/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = DcmdTaskTemplateServicePool::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'task_tmpt_id' => $this->task_tmpt_id, 'svr_pool_id' => $this->svr_pool_id, 'utime' => $this->utime, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]); return $dataProvider; }
/** * Creates a new DcmdTaskTemplateServicePool model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate($task_tmpt_id) { if (Yii::$app->user->getIdentity()->admin != 1) { Yii::$app->getSession()->setFlash('success', NULL); Yii::$app->getSession()->setFlash('error', "对不起,你没有权限!"); return $this->redirect(array('dcmd-task-template/view', 'id' => $task_tmpt_id)); } if (Yii::$app->request->post()) { $tm = date('Y-m-d H:i:s'); if (array_key_exists("selection", Yii::$app->request->post())) { foreach (Yii::$app->request->post()['selection'] as $k => $v) { $dcmd_task_template_service_pool = new DcmdTaskTemplateServicePool(); $dcmd_task_template_service_pool->task_tmpt_id = $task_tmpt_id; $dcmd_task_template_service_pool->utime = $tm; $dcmd_task_template_service_pool->ctime = $tm; $dcmd_task_template_service_pool->opr_uid = Yii::$app->user->getId(); $dcmd_task_template_service_pool->svr_pool_id = $v; $dcmd_task_template_service_pool->save(); } Yii::$app->getSession()->setFlash('success', "添加服务池子成功!"); } else { Yii::$app->getSession()->setFlash('success', "没有选择服务池!"); } return $this->redirect(['dcmd-task-template/view', 'id' => $task_tmpt_id]); } $model = new DcmdTaskTemplateServicePool(); $query = DcmdTaskTemplate::findOne($task_tmpt_id); $svr_id = 0; if ($query) { $svr_id = $query['svr_id']; } ///获取未添加的服务池子列表 $query = DcmdTaskTemplateServicePool::find()->andWhere(['task_tmpt_id' => $task_tmpt_id])->asArray()->all(); $exist_svr_pool = "svr_pool_id not in ( 0"; if ($query) { foreach ($query as $item) { $exist_svr_pool .= "," . $item['svr_pool_id']; } } $exist_svr_pool .= ") and svr_id=" . $svr_id; $query = DcmdServicePool::find()->where($exist_svr_pool); $dataProvider = new ActiveDataProvider(['query' => $query]); $searchModel = new DcmdServicePoolSearch(); ///获取任务模板名称 $task_tmpt_name = ""; $query = DcmdTaskTemplate::findOne($task_tmpt_id); if ($query) { $task_tmpt_name = $query['task_tmpt_name']; } $model->task_tmpt_id = $task_tmpt_id; return $this->render('create', ['model' => $model, 'task_tmpt_id' => $task_tmpt_id, 'task_tmpt_name' => $task_tmpt_name, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
public function actionSelectServicePool($task_id, $task_tmpt_id) { $task = DcmdTask::findOne($task_id); ///获取任务模板的服务池子 $query = DcmdTaskTemplateServicePool::find()->andWhere(['task_tmpt_id' => $task_tmpt_id])->asArray()->all(); $svr_pool = "svr_pool_id in (0"; foreach ($query as $item) { $svr_pool .= "," . $item['svr_pool_id']; } $svr_pool .= ")"; $query = DcmdServicePool::find()->where($svr_pool); $dataProvider = new ActiveDataProvider(['query' => $query]); $searchModel = new DcmdServicePoolSearch(); return $this->render('select_service_pool', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'task_id' => $task_id, 'task_name' => $task->task_name, 'task_cmd' => $task->task_cmd]); }