dataList(1); /** * 渲染模板 */ return $this->render('index', $params); } /** * 查询数据列表 */ protected function dataList($type = '') { $request = Yii::$app->request; $creatTime = $request->get('creatTime'); $endTime = $request->get('endTime'); $name = $request->get('name'); $gets = [ 'creatTime' => $creatTime, 'endTime' => $endTime, 'name' => $name, ]; $where = ['and']; if ($creatTime) { $creatTime = strtotime($creatTime); $where[] = ['>=', 'm.created_at', $creatTime]; } if ($endTime) { $endTime = strtotime($endTime) + 86400; $where[] = ['<=', 'm.created_at', $endTime]; } if ($name) { $where[] = ['like', 'm.name', $name]; } if ($type == 0) { $pageList = ModelRepository::getPageList($where); $pages = null; } else { $pageSize = 20; $pages = new Pagination(['totalCount' => ModelRepository::getPageCount($where), 'pageSize' => $pageSize]); $pageList = ModelRepository::getPageList($where, $pages->offset, $pages->limit); } /** * 数据整理 */ return [ 'listdata' => $pageList, 'pages' => $pages, 'gets' => $gets ]; } /** * 创建机器型号 * @return string */ public function actionCreate() { return $this->render('create'); } /** * 创建机器型号 * @return string */ public function actionDoAdd() { $request = Yii::$app->request; $name = $request->post("name"); // 机器型号 if (empty($name)) { Yii::$app->session->setFlash('error', '机器型号不能为空'); return $this->render('create'); } $result = Model::create($request->post()); if ($result === -1) { Yii::$app->session->setFlash('error', '添加失败, 机器型号' . $name . '已存在'); return $this->render('create'); } if ($result) { Yii::$app->session->setFlash('success', '添加成功'); } else { Yii::$app->session->setFlash('error', '添加失败'); } return $this->redirect('index'); } /** * 编辑机器型号 * @return string */ public function actionEdit() { $modelId = $this->request->get("mid"); $info = ModelRepository::selectOne($modelId, true); return $this->render('edit', ["info" => $info]); } /** * 编辑机器型号 * @return string */ public function actionDoEdit() { $request = Yii::$app->request; $name = $request->post("name"); $mid = $request->post("mid"); if (empty($mid)) { Yii::$app->session->setFlash('error', '机器型号编号不能为空'); $params = $this->dataList(1); return $this->render('index', $params); } $model =ModelRepository::selectOne($mid,true); if (empty($model)) { Yii::$app->session->setFlash('error', '机器型号记录不存在'); $params = $this->dataList(1); return $this->render('index', $params); } if (empty($name)) { Yii::$app->session->setFlash('error', '机器型号不能为空'); return $this->render('edit', ["info" => $model]); } $result = Model::update($mid, $request->post()); if ($result === -1) { Yii::$app->session->setFlash('error', '修改的机器型号' . $name . '已存在'); return $this->render('edit', ["info" => $model]); } if ($result) { Yii::$app->session->setFlash('success', '编辑成功'); } else { Yii::$app->session->setFlash('error', '编辑失败'); } $model = ModelRepository::selectOne($mid,true); return $this->render('edit', ["info" => $model]); } /** * 删除机器型号 * @return string * @throws \Exception */ public function actionDoDel() { $request = Yii::$app->request; $itemId = $request->post("data_id"); $msg = array(); // 删除对应的机器型号 if (Model::delete($itemId)) { $msg['status'] = 1; $msg['msg'] = "操作成功"; } else { $msg['status'] = 0; $msg['msg'] = "操作失败"; } return $this->renderJson($msg); } }