/** 查询 */ public function actionSearch() { $request = Yii::$app->request; if ($request->isPost) { $type = $request->post('type'); $content = trim($request->post('content')); } else { $type = $request->get('type'); $content = trim($request->get('content')); } switch ($type) { case 'state': $query = Scheme::find()->where(['like', $type, $content]); break; default: $query = Scheme::find(); break; } $schemes = $query->andWhere(['usageModeId' => Scheme::USAGE_PRACTICE])->all(); return $this->render('index', ['schemes' => $schemes]); }
/** 查询 */ public function actionSearch() { $request = Yii::$app->request; if ($request->isPost) { $type = $request->post('type'); $content = trim($request->post('content')); } else { $type = $request->get('type'); $content = trim($request->get('content')); } switch ($type) { case 'usageMode': $query = Scheme::find()->where(['usageModeId' => $content]); break; default: $query = Scheme::find(); break; } $schemes = $query->orderBy(['startDate' => SORT_DESC])->all(); return $this->render('index', ['schemes' => $schemes]); }
/** * 检查方案是否有启用冲突,暂停使用 * @param $usageModeId * @param $startDate * @param $endDate * @return bool|mixed */ public static function checkScheme($usageModeId, $startDate, $endDate) { $scheme = $scheme = Scheme::find()->where(['usageModeId' => $usageModeId, 'state' => Scheme::STATE_ABLE])->andWhere(['>', 'level', Scheme::LEVEL_UNDO])->andWhere(['<=', 'startDate', $startDate])->andWhere(['>=', 'endDate', $startDate])->one(); if (!$scheme) { //如果开始时间不在启用的时间当中 $scheme = $scheme = Scheme::find()->where(['usageModeId' => $usageModeId, 'state' => Scheme::STATE_ABLE])->andWhere(['>', 'level', Scheme::LEVEL_UNDO])->andWhere(['<=', 'startDate', $endDate])->andWhere(['>=', 'endDate', $endDate])->one(); } if (!$scheme) { //如果结束时间不在启用的时间当中 return false; //表示没有冲突 } return $scheme->name; //返回冲突的方案的名称 }