pid) { $this->result('您正使用本系统内部接口,禁止非法链接使用!'); } return parent::beforeAction($action); } //主界面 public function actionIndex() { $apis = [ 'list' => '板车清单', 'detail' => '详情', 'get-status'=>'状态字典', 'fache'=>'发车', 'list-online'=>'装车中', 'add'=>'添加', 'edit'=>'编辑', 'delete'=>'删除', 'show'=>'显示', 'hide'=>'隐藏', 'ajax'=>'ajax操作' ]; $this->result('您正使用CMTS-GM系统板车管理接口!', $apis, 200); } public function actionGetStatus(){ $status = Yii::$app->params['TruckStatus']; $this->result('板车状态字典', $status, 200); } //板车列表 public function actionList() { $s = $this->search(); $res = $s['res']; if (!$res) { $this->result('没有查询到相应的数据!', [], 0); } $data= [ 'total'=>$s['query']->count(), 'trucks' => $res, 'drivers' => $s['drivers'], 'page'=>$this->page ]; $this->result('板车列表查询成功!', $data, 200); } public function actionDetail() { $pid = $this->pid; $post = $this->postdata; $id = isset($post['id']) ? $post['id'] : 0; if ($id <= 0) { $this->result('查询参数错误!'); } $model = new AcTruck(); $detail = $model->findOne($id)->toArray(); if(!$detail) $this->result('未查询到相应数据'); $data = $this->showTruck($detail); $this->result('查询成功!', $data, 200); } public function actionAdd() { //数据预检查、编排 $data = $this->preSave('add'); if(!$data) $this->result('数据预检查未通过,保存失败', $data, 100); //保存资料 $model = new AcTruck(); foreach ($data as $key=>$val) { $model->$key = $val; } $res = $model->save(); $msg = '数据保存失败!'; if(!$res) $this->result($msg, [], 100); $msg = '数据保存成功!'; $return = []; $return['id']= $model->attributes['id']; //获取插入后id; $this->result($msg,$return, 200); } //编辑板车资料 public function actionEdit() { $detail = $this->preUpdate(); //数据预检查、编排 $data = $this->preSave('edit'); if(!$data) $this->result('数据预检查未通过,保存失败', $data, 100); //保存资料 foreach ($data as $key=>$val) { $detail->$key = $val; } $res = $detail->save(); $msg = '数据编辑失败!'; if(!$res) $this->result($msg, [], 100); $msg = '数据编辑成功!'; $return = []; $return['data']= $detail; $this->result($msg,$return, 200); } //删除板车 public function actionDelete() { $detail = $this->preUpdate(); $data = []; $data['update_at'] = time(); $data['deleted'] = $detail->deleted + 1; //保存资料 foreach ($data as $key=>$val) { $detail->$key = $val; } $res = $detail->save(); $msg = '板车删除失败!'; if(!$res) $this->result($msg, [], 100); $msg = '板车删除成功!'; $this->result($msg,[], 200); } public function actionAjax() { $detail = $this->preUpdate(); $get = Yii::$app->request->get(); $msg = ''; $errorCode = 0; $detail->update_at = time(); switch ($get['do']) { case 'out': $detail->status_code = 0; $res = $detail->save(); if ($res) { $msg = '板车停用标记成功'; $errorCode = 200; } else { $msg = '板车停用标记失败'; } break; case 'in': $detail->status_code = 1; $res = $detail->save(); if ($res) { $msg = '板车启用标记成功'; $errorCode = 200; } else { $msg = '板车启用标记失败'; } break; case 'lock': $detail->status_code = 99; $res = $detail->save(); if ($res) { $msg = '板车锁定标记成功'; $errorCode = 200; } else { $msg = '板车锁定标记失败'; } break; case 'repair': $detail->status_code = 2; $res = $detail->save(); if ($res) { $msg = '板车检修标记成功'; $errorCode = 200; } else { $msg = '板车检修标记失败'; } break; case 'reset': $detail->status_code = 3; $res = $detail->save(); if ($res) { $msg = '板车保养标记成功'; $errorCode = 200; } else { $msg = '板车保养标记失败'; } break; case 'working': $detail->status_code = 1; $res = $detail->save(); if ($res) { $msg = '板车恢复标记成功'; $errorCode = 200; } else { $msg = '板车恢复标记失败'; } break; default: break; } $this->result($msg,[], $errorCode); } //发车 public function actionFache() { $truck = $this->preUpdate(); $get = Yii::$app->request->get(); $msg = ''; $errorCode = 0; if ($truck->status_code == 1) { $truck->update_at = time(); $res = $truck->update(); if ($res) { $msg = '发车成功,请进行下一步操作'; $errorCode = 200; }else{ $msg = '发车标记保存失败'; $errorCode = 0; } }elseif ($truck->status_code == 4) { $msg = '当前板车已在装车中,发车操作无效'; $errorCode = 400; } else if ($truck->status_code == 5) { $msg = '当前板车已在运输中,发车操作无效'; $errorCode = 400; }else if ($truck->status_code != 1) { $msg = '当前板车状态不允许发车,请先确认板车已归为正常状态'; $errorCode = 400; } $this->result($msg,[], $errorCode); } //装车中的板车(即在线板车列表,标记了发车状态为装车中的) public function actionListOnline(){ $this->postdata['status'] = 4; $s = $this->search(); $res = $s['res']; if (!$res) { $this->result('没有在装车中的板车!', [], 0); } $data= [ 'total'=>$s['query']->count(), 'trucks' => $res, 'drivers' => $s['drivers'], 'page'=>$this->page ]; $this->result('在线板车列表获取成功!', $data, 200); } private function search(){ $pid = $this->pid; $return = []; $model = new AcTruck(); $where = $where2 = []; $where['pid'] = $pid; $where2[] = 'and'; $post = $this->postdata; if(isset($post['status'])){ $where['status_code'] = (int)$post['status']; } $search = $post['search'] ?? []; $search['title'] = isset($search['title']) ? trim(htmlspecialchars_decode($search['title'])) : ''; if (!empty($search['title'])) { $where2[] = ['LIKE', 'num_left', $search['title']]; } $where['deleted'] = 0; $data = $model->find()->where($where); if ($search['title']) { $data = $data->andwhere($where2); } $pages = new Pagination(['totalCount' => $data->count(), 'pageSize' => $this->pageSize]); $res = $data->offset($pages->offset)->limit($pages->limit)->all(); $dids = []; if ($res) { foreach ($res as $k => $v) { if($v->driver_id) $dids[] = $v->driver_id; if($v->driver2_id) $dids[] = $v->driver2_id; } } $drivers = []; if($dids){ $AcDriver = new AcDriver(); $where = []; $where[] = ['=','pid',$this->pid]; $where[] = ['IN','id',$dids]; $_drivers = $AcDriver->find()->where($where)->all(); foreach ($_drivers as $s) { $drivers[$s->id] = $s->toArray(); } } return ['res'=>$res,'query'=>$data,'drivers'=>$drivers]; } /* * 数据更新前的预检查,返回对应关联数据 * 必须确保get与post数据中均包含需更新的数据id且一致 * */ private function preUpdate() { $id = (int)Yii::$app->request->get('id'); if(!$id) $this->result('请求错误,未携带ID参数'); $post = $this->postdata; if($post['id'] != $id) $this->result('传参id与请求数据不匹配',[],403); $model = new AcTruck(); $res = $model->findOne($id); if(!$res) $this->result('未查询到相应数据',[],404); return $res; } /* * 数据保存前的预检查(查重、参数校验等) * 要保存的数据[],直接从post中取出 * @op,操作类型(add,edit……) * 校验机制: * 编辑数据时,必须用get方式传入参数id,并与post进来的数据id进行比对,只有一致时才能继续; * 查重:禁止录入重复数据 * 返回:校验重组后的数据 * */ private function preSave($op) { $post = $this->postdata; $data = []; //格式化数据 //目标键=》POST键 $model = new AcTruck(); switch ($op) { case 'add': $cols = ['num_p' => 'num_p', 'num_area' => 'num_area', 'num_left' => 'num_left']; foreach ($cols as $col => $key) { $data[$col] = isset($post[$key]) ? trim($post[$key]) : ''; if(!$data[$col]) $this->result('请传入板车车牌号'); } //查询车牌号是否在库 $hasOne = AcTruck::find()->where(['num_p' => $data['num_p'], 'num_area' => $data['num_area'], 'num_left' => $data['num_left']])->one(); if($hasOne) $this->result('保存失败,该车牌号已在库!',$hasOne,100); $data['create_at'] = time(); $data['update_at'] = $data['create_at']; break; case 'edit': //编辑模式下,没有改车牌号,避免校验重复性 $id = (int)Yii::$app->request->get('id'); $_id = (int)$post['id']; if(!$id != $_id) $this->result('id参数不匹配,请检查'); $data['update_at'] = time(); break; } $data['pid'] = $this->pid; $cols = ['driver_id' => 'driver', 'driver2_id' => 'driver2', 'status_code' => 'status_code', 'max_cars' => 'max_cars', 'deleted' => 'deleted']; foreach ($cols as $col => $key) { $data[$col] = isset($post[$key]) ? (int)$post[$key] : 0; } $cols = ['remark' => 'editor']; foreach ($cols as $col => $key) { $data[$col] = isset($post[$key]) ? htmlspecialchars($post[$key]) : ''; } return $data; } private function showTruck($detail){ $data = $detail->toArray(); $AcDriver = new AcDriver(); $driver = $AcDriver->findOne($detail->driver_id); if ($driver) { $data['driver_title'] = $driver->name; $data['driver_mobile'] = $driver->mobile; } $driver2 = $AcDriver->findOne($detail->driver2_id); if ($driver2) { $data['driver2_title'] = $driver2->name; $data['driver2_mobile'] = $driver2->mobile; } return $data; } }