/** 查询 */
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;
//返回冲突的方案的名称
}
