model()->orderByDesc('orders.id');
$res = request()->all();
$grid->disableExport(false);
$grid->export(function ($export) {
$export->filename('儿保订单'.Date('Y-m-d',time()));
$export->column('order_status', function ($value, $original) {
$order_status_arr = Order::getStatus();
return $order_status_arr[intval($original)];
} );
});
$user = Admin::user();
$is_admin = Admin::user()->inRoles(['administrator','developer']);
$where = ['product_type'=>5];
if(!$is_admin){
$org_id = $user->org_id;
$where['organization_id']=$org_id;
}
$grid->model()->where($where);
if(!empty($res['orderPatient']['appoint_start_time']['start']) || !empty($res['orderPatient']['appoint_start_time']['start']) ){
$grid->model()->orderBy('appoint_start_time');
} else {
$grid->model()->orderBy('appoint_start_time','desc');
}
$grid->column('id', __('ID'));
$grid->column('orderUser.user_name', __('预约用户'))->display(function($w){
if(empty($w)) return '';
return $w;
});
$grid->column('orderPatient.appoint_start_time', __('预约时间'))->display(function ($w){
if(empty($w)) return '';
return date('Y-m-d H:i',$w).'~'.date('H:i',$w);
});
$grid->column('patient.name', __('儿保患者'));
$grid->column('patient.phone', __('电话'));
$grid->column('orderPatient.sex', __('患者性别'))->display(function ($w){
return $w==1?'男':'女';
});
$grid->column('orderPatient.birthday', __('患者年龄'))->display(function ($w){
return birthday_to_age($w);
});
// $grid->column('orders.docter_id', __('排班医生'))->display(function ($w){
// return Docter::where('id',$w)->value('name');
// });
$grid->column('nurse_name', __('项目名称'));
$status_arr = Order::getStatus();
$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(Order::getPayStatus())->label([1=>'warning',2=>'success',3=>'info',4=>'danger',5=>'default']);
//查询
// $grid->quickSearch(function ($model, $query) {
// $model->whereHas('patient',function ($model) use ($query) {
// $model->where('name', 'like', "{$query}%");
// });
// })->placeholder('请输入患者姓名');
$grid->filter(function (Grid\Filter $filter){
$filter->disableIdFilter();
$filter->column(1/2, function ($filter) {
$filter->like('patient.phone','电话');
$filter->like('patient.name','患者名称');
$filter->equal('order_status','订单状态')->select(Order::$_order_status);
$filter->timestampBetween('orderPatient.appoint_start_time','预约时间')->datetime();
});
});
$grid->actions(function ($actions) {
// if(!empty($actions->row->orders) && $actions->row->orders->order_status < 2){
// $actions->add(new Reserved());
// }
if($actions->row->order_status<= 3 || $actions->row->order_status == 7 ){
$actions->add(new OrderCance());
$actions->add(new Finished());
}
// $actions->add(new DelNurse());
$actions->disableView();
$actions->disableDelete();
});
return $grid;
}
/**
* Make a show builder.
*
* @param mixed $id
* @return Show
*/
protected function detail($id)
{
$show = new Show(OrderNurse::findOrFail($id));
$show->field('id', __('Id'));
$show->field('orderPatient.name', __('患者用户'));
$show->field('orderUser.user_nam', __('患者名称'));
$show->field('orderNurse.nurse_name', __('儿保项目'));
$show->field('orderNurse.nurse_price', __('订单价格'));
$show->field('nurse_remark', __('儿保备注'));
$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->display('id', __(' 订单id'));
$form->display('orderUser.user_name', __('预约用户'));
$form->display('orderPatient.name', __('预约患者'));
$form->display('orderNurse.nurse_name', __('项目名称'));
$form->text('orderNurse.nurse_price', __('订单价格'));
$form->textarea('nurse_remark', __('备注'))->rows(5);
$form->setWidth(6);
return $form;
}
}