disableCreateButton();
$grid->model()->wherein('product_type',[3,4,5]);
//筛选
$grid->filter(function ($filter){
$filter->disableIdFilter();
$filter->column(1/2, function ($filter) {
$filter->like('user.nickname','用户姓名');
$filter->like('docter.name','医生姓名');
$filter->like('orderPatient.name','患者姓名');
$filter->equal('orderPatient.patient_phone','患者电话');
$filter->equal('product_type','预约类型')->radio(
[
''=>'不限',
3=>'门诊预约',
4=>'疫苗接种预约',
5=>'儿保预约'
]
);
});
$filter->column(1/2, function ($filter) {
$filter->equal('order_status','订单状态')->radio(
[
''=>'不限',
1=>'未支付',
2=>'待接单',
3=>'进行中',
4=>'已完成',
5=>'已取消',
6=>'已超时',
7=>'已预约',
]
);
$filter->equal('payment_status','支付状态')->radio(
[
''=>'不限',
1=>'待付款',
2=>'已付款',
3=>'退款中',
4=>'已退款',
5=>'待退款',
]
);
$filter->timestampBetween('payment_time', "支付时间")->datetime();
$filter->timestampBetween('end_time', "订单完成时间")->datetime();
$filter->between('created_at','创建时间')->datetime();
});
});
$grid->actions(function ($actions){
// 1.门诊预约和儿保预约有退款操作
$actions->disableView();
$actions->disableEdit();
$actions->disableDelete();
if ($actions->row->product_type == 3 || $actions->row->product_type == 5)
{
if (
//已取消 待退款
($actions->row->order_status == 5 && $actions->row->payment_status == 5)||
//已超时 已支付
($actions->row->order_status == 6 && $actions->row->payment_status == 2)){
//判断是否是服务包支付 是的话走退次数的逻辑,不是的话走退余额的操作
if ($actions->row->payment_type == 3)
{
$actions->add(new RefundServicePackAction());
}else
{
$actions->add(new RefundApplicationAction());
}
}
}
});
$grid->export(function ($export) {
$export->filename('预约订单');
});
$status_arr = Order::getStatus();
$grid->model()->orderBy('id','desc');
$grid->column('created_at','创建时间')->hide();
$grid->column('id', __('Id'))->sortable();
$grid->column('user.nickname', __('用户姓名'));
$grid->column('docter.name', __('医生姓名'));
$grid->column('orderPatient.name', __('患者姓名'));
$grid->column('orderPatient.patient_phone', __('患者电话'));
$grid->column('organization_id', __('预约机构'))->display(function ($org_id){
$name = Organization::where('id',$org_id)->value('name');
return $name;
});
$grid->column('orderPatient.appoint_start_time', __('预约日期'))->display(function ($time){
return date('Y-m-d H:i:s',$time);
});
$grid->column('product_type', __('产品类型'))->using([3=>'门诊预约',4=>'疫苗接种预约',5=>'儿保预约']);
$grid->column('payment_type', __('支付方式'))->display(function ($payment_type){
if ($payment_type == 1)
{
return '微信支付';
}
if ($payment_type == 2){
return '余额支付';
}
if ($payment_type == 3){
$order_pack_id = OrderPack::where('id',$this->pay_order_pack_id)->value('service_pack_id');
$name = ServicePack::where('id',$order_pack_id)->value('name');
return '服务包支付('.$name.')';
}
});
$grid->column('order_status', __('订单状态'))->display(function ($w) use ($status_arr) {
$info = $status_arr[intval($w)];
if($w == 1 || $w == 2){
return ''.$info.'';
} else if( $w == 4 ){
return ''.$info.'';
} else if($w == 7 || $w == 3 ){
return ''.$info.'';
} else if($w == 6){
return ''.$info.'';
} else {
return ''.$info.'';
}
});;
$grid->column('payment_status', __('支付状态'))->using([1=>'待付款',2=>'已付款',3=>'退款中',4=>'已退款',5=>'待退款'])->label([1=>'warning',2=>'success',3=>'info',4=>'danger',5=>'default']);;
$grid->column('total_amount', __('订单总金额'))->display(function ($money){
return $money/100;
});
$grid->column('payment_amount', __('用户实际支付的金额'))->display(function ($money){
return $money/100;
});
$grid->column('discount_amount', __('折扣金额'))->display(function ($money){
return $money/100;
});
$grid->column('order_notes', __('订单备注'));
$grid->column('payment_time', __('支付时间'))->display(function ($time){
if ($time == 0)
{
return '';
}else
{
return date('Y-m-d H:i:s',$time);
}
});
$grid->column('end_time', __('订单完成时间'))->display(function ($time){
if ($time == 0)
{
return '';
}else
{
return date('Y-m-d H:i:s',$time);
}
});
return $grid;
}
/**
* Make a show builder.
*
* @param mixed $id
* @return Show
*/
protected function detail($id)
{
$show = new Show(Order::findOrFail($id));
$show->field('id', __('Id'));
$show->field('user_id', __('用户id'));
$show->field('user.nickname', __('用户姓名'));
$show->field('docter_id', __('医生id'));
$show->field('docter.name', __('医生姓名'));
$show->field('patient_id', __('患者id'));
$show->field('orderPatient.name', __('患者姓名'));
$show->field('organization_id', __('机构id'));
$show->field('organization.name', __('机构名'));
$show->field('order_sn', __('订单号'));
$show->field('product_type', __('产品类型'))->using([3=>'门诊预约',4=>'疫苗接种预约',5=>'儿保预约']);
$show->field('payment_type', __('支付类型'))->using([1=>'微信支付',2=>'余额支付']);
$show->field('order_status', __('订单状态'))->using([1=>'未支付',2=>'待接单',3=>'进行中',4=>'已完成',5=>'已取消']);
$show->field('payment_status', __('支付状态'))->using([1=>'待付款',2=>'已付款',3=>'退款中',4=>'已退款']);
$show->field('total_amount', __(' 订单总金额'))->as(function ($money){
return $money/100;
});
$show->field('payment_amount', __('用户实际支付的金额'))->as(function ($money){
return $money/100;
});
$show->field('discount_amount', __('折扣金额'))->as(function ($money){
return $money/100;
});
$show->field('payment_time', __('支付时间'))->as(function ($time){
if($time == 0)
{
return '';
}
else
{
return date('Y-m-d H:i:s',$time);
}
});
$show->field('receiving_time', __('接单时间'))->as(function ($time){
if($time == 0)
{
return '';
}
else
{
return date('Y-m-d H:i:s',$time);
}
});
$show->field('end_time', __('订单完成时间'))->as(function ($time){
if($time == 0)
{
return '';
}
else
{
return date('Y-m-d H:i:s',$time);
}
});
$show->field('created_at', __('创建时间'));
$show->field('updated_at', __('更新时间'));
return $show;
}
/**
* Make a form builder.
*
* @return Form
*/
protected function form()
{
$form = new Form(new Order());
$form->number('user_id', __('User id'));
$form->number('docter_id', __('Docter id'));
$form->number('patient_id', __('Patient id'));
$form->number('organization_id', __('Organization id'));
$form->text('order_sn', __('Order sn'));
$form->switch('payment_type', __('Payment type'))->default(1);
$form->switch('product_type', __('Product type'))->default(1);
$form->switch('order_status', __('Order status'))->default(1);
$form->switch('payment_status', __('Payment status'))->default(1);
$form->number('total_amount', __('Total amount'));
$form->number('payment_amount', __('Payment amount'));
$form->number('discount_amount', __('Discount amount'));
$form->number('payment_time', __('Payment time'));
$form->number('outtime', __('Outtime'));
$form->number('receiving_time', __('Receiving time'));
return $form;
}
}