model()->where(['product_type'=>1]); $grid->column('id', __('Id')); $grid->column('orderUser.nickname', __('预约用户')); $grid->column('orderPatient.appoint_start_time', __('预约时间'))->display(function ($w){ return date('Y-m-d H:i:s',$w); }); $grid->column('orderPatient.appoint_end_time', __('门诊时间'))->display(function ($w){ if(empty($w)) return ''; return date('Y-m-d H:i:s',$w); });; $grid->column('orderPatient.name', __('预约患者'))->display(function ($w){ return $w==1?'男':'女'; });; $grid->column('orderPatient.sex', __('患者性别')); $grid->column('orderPatient.birthday', __('患者年龄'))->display(function ($w){ return birthday_to_age($w); });; $grid->column('docter.name', __('预约医生')); // $grid->column('organization_id', __('Organization id')); //查询 $grid->quickSearch(function ($model, $query) { $model->whereHas('patients',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->equal('docter_id','排班医生')->select('/cdms/api/getDocter'); $filter->equal('order_status','订单状态')->select(Order::$_order_status); $filter->between('orderPatient.appoint_start_time','预约时间')->datetime(); }); }); 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', __('User id')); $show->field('docter_id', __('Docter id')); $show->field('patient_id', __('Patient id')); $show->field('organization_id', __('Organization id')); $show->field('order_sn', __('Order sn')); $show->field('payment_type', __('Payment type')); $show->field('product_type', __('Product type')); $show->field('order_status', __('Order status')); $show->field('payment_status', __('Payment status')); $show->field('total_amount', __('Total amount')); $show->field('payment_amount', __('Payment amount')); $show->field('discount_amount', __('Discount amount')); $show->field('payment_time', __('Payment time')); $show->field('created_at', __('Created at')); $show->field('updated_at', __('Updated at')); return $show; } /** * Make a form builder. * * @return Form */ protected function form() { $form = new Form(new Order()); $form->display('orderUser.nickename', __('用户')); $form->display('docter_id', __('医生')); $form->number('payment_time', __('Payment time')); return $form; } }