all();
$grid->disableExport(false);
// 1 => 1614700800
// 2 => 1614787200
// 3 => 1614787200
// 4 => 1614873600
$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','devloper']);
$where = ['product_type'=>4];
if(!$is_admin){
$org_id = $user->org_id;
$where = ['product_type'=>4,'organization_id'=>$org_id];
}
$grid->model()->where($where);
if(!empty($res['appoint_start_time']['start']) || !empty($res['appoint_start_time']['start']) ){
$grid->model()->orderBy('appoint_start_time');
} else {
$grid->model()->orderBy('appoint_start_time','desc');
}
$grid->column('id', __('Id'));
$grid->column('user.nickname', __('预约用户'));
$grid->column('patient.phone', __('电话'))->display(function ($w){
// dd($this->orderPatient);
// if(empty($w)) {
// if(empty($this->orderUser->phone)) return '';
// return $this->orderUser->phone;
// }
return $w;
});
$grid->column('appoint_start_time', __('预约时间'))->display(function ($w){
if(empty($this->orderPatient) || empty($this->orderPatient->appoint_start_time)) return '';
return date('Y-m-d H:i',$w).'~'.date('H:i',$this->appoint_end_time);
});
$grid->column('end_time', __('接种时间'))->display(function ($w){
if(empty($w)) return '';
return date('Y-m-d',$w);
});
$grid->column('patient.name', __('接种患者'));
$grid->column('orderPatient.sex', __('患者性别'))->display(function ($w){
return $w==1?'男':'女';
});
$grid->column('orderPatient.birthday', __('患者年龄'))->display(function ($w){
return birthday_to_age($w);
});
$grid->column('vac_name', __('接种疫苗'))->display(function ($w){
$vaccine_name = OrderVaccine::where('order_id',$this->id)->pluck('vaccine_name')->toArray();
if(empty($vaccine_name) ) return '';
return implode(',',$vaccine_name);
});
// $grid->column('docter.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=>'warring',2=>'success',3=>'info',4=>'danger']);
$grid->filter(function ($filter) {
$filter->column(1/2, function ($filter) {
// $filter->equal('docter.id','排班医生')->select('https://wechat.fresherbaby.com/api/getAppiontInfo?telphone=13808729518&sig=d7d875f10af1c341b8ba3d9e433e88aa&SecretKey=2018&st=2018&id=11&barcode=&area=12');
$filter->like('patient.phone','电话');
$filter->like('patient.name','患者名称');
$filter->equal('order_status','订单状态')->select(Order::$_order_status);
$filter->timestampBetween('appoint_start_time','预约时间')->datetime();
$filter->timestampBetween('end_time','接种时间')->datetime();
});
});
$grid->tools(function ($tools) {
$tools->append(new FasteOrder());
});
$grid->actions(function ($actions) {
// if( $actions->row->order_status<= 2){
// $actions->add(new Reserved());
// }
if(!empty($actions->row->order_status) && ($actions->row->order_status<= 3 || $actions->row->order_status == 7 ) ){
$actions->add(new Finished());
$actions->add(new OrderCance());
$actions->add(new AddVaccine());
}
$actions->disableEdit();
// $actions->disableView();
$actions->disableDelete();
});
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('orderPatient.name', __('患者姓名'));
$show->field('orderPatient.sex', __('患者性别'))->as(function ($w){
return $w==1?'男':'女';
});
$show->field('orderPatient.birthday', __('生日'))->as(function ($w){
return birthday_to_age($w);
});
$show->field('orderVaccine.id', __('疫苗'))->as(function ($w){
$vaccine_name = OrderVaccine::where('order_id',$this->id)->pluck('vaccine_name')->toArray();
if(empty($vaccine_name) ) return '';
return implode(',',$vaccine_name);
});
$show->field('payment_status', __('支付状态'))->using(Order::getPayStatus())->label('info');
$show->field('order_status', __('订单状态'))->using(Order::getStatus())->label('info');
$show->field('created_at', __('创建时间'));
$show->field('updated_at', __('更新时间'));
return $show;
}
/**
* Make a form builder.
*
* @return Form
*/
protected function form()
{
$form = new Form(new OrderVaccine());
$form->number('order_id', __('Order id'));
$form->number('order_patient_id', __('Order patient id'));
$form->number('vaccine_id', __('Vaccine id'));
$form->switch('vaccine_type', __('Vaccine type'));
$form->number('vaccine_price', __('Vaccine price'));
$form->text('vaccine_name', __('Vaccine name'));
$form->text('vaccine_remark', __('Vaccine remark'));
$form->text('vaccine_supplier', __('Vaccine supplier'));
return $form;
}
public function info()
{
DB::enableQueryLog();
$list = Order::join('order_patients','order_patients.order_id','=','orders.id')->where('product_type',4)->orderBy('order_patients.appoint_start_time','desc')
->select(['order_id','appoint_start_time'])->paginate(20)->toArray();
dump(DB::getQueryLog());
dd($list);
}
}