/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = DcmdServicePoolAttr::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'app_id' => $this->app_id, 'svr_id' => $this->svr_id, 'svr_pool_id' => $this->svr_pool_id, 'utime' => $this->utime, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]); $query->andFilterWhere(['like', 'attr_name', $this->attr_name])->andFilterWhere(['like', 'attr_value', $this->attr_value])->andFilterWhere(['like', 'comment', $this->comment]); return $dataProvider; }
public function actionCreateByCmd($task_cmd_id) { if (Yii::$app->request->post()) { ///提交新建任务 #var_dump(Yii::$app->request->post()); exit ; $dcmd_task = new DcmdTask(); $post_task = Yii::$app->request->post()['DcmdTask']; $dcmd_task->task_name = Yii::$app->request->post()['task_cmd_prv'] . '-' . $post_task['task_name']; $dcmd_task->task_cmd = $post_task['task_cmd']; $dcmd_task->depend_task_id = 0; $dcmd_task->depend_task_name = "NULL"; $dcmd_task->app_id = $post_task['app_id']; $dcmd_app = DcmdApp::findOne($post_task['app_id']); $dcmd_task->app_name = $dcmd_app->app_name; $dcmd_task->svr_id = $post_task['svr_id']; $dcmd_svr = DcmdService::findOne($post_task['svr_id']); $dcmd_task->svr_name = $dcmd_svr->svr_name; /// $post_task['svr_name']; $dcmd_task->svr_path = $dcmd_svr->svr_path; ///$post_task['svr_path']; $dcmd_task->node_multi_pool = $dcmd_svr->node_multi_pool; $dcmd_task->err_msg = ' '; $dcmd_task->tag = $post_task['tag']; $dcmd_task->update_env = $post_task['update_env']; $dcmd_task->update_tag = $post_task['update_tag']; $dcmd_task->state = 0; $dcmd_task->freeze = 0; $dcmd_task->valid = 1; $dcmd_task->pause = 0; $dcmd_task->concurrent_rate = $post_task['concurrent_rate']; $dcmd_task->timeout = $post_task['timeout']; $dcmd_task->auto = $post_task['auto']; $dcmd_task->process = $post_task['process']; $dcmd_task->utime = date('Y-m-d H:i:s'); $dcmd_task->ctime = $dcmd_task->utime; $dcmd_task->opr_uid = Yii::$app->user->getId(); $dcmd_task->comment = $post_task['comment']; $arg = array(); $opr_log = new DcmdOprLog(); $opr_log->log_table = "dcmd_task"; $opr_log->opr_type = 1; $opr_log->sql_statement = "insert task:" . $dcmd_task->task_name; $opr_log->ctime = date('Y-m-d H:i:s'); $opr_log->opr_uid = Yii::$app->user->getId(); $opr_log->save(); foreach (Yii::$app->request->post() as $k => $v) { if (substr($k, 0, 3) == "Arg") { $arg[substr($k, 3)] = $v; } } $dcmd_task->task_arg = arrToXml($arg); if ($dcmd_task->save()) { ///设备池默认属性 $svr_pool_attr_def = array(); $tmp_query = DcmdServicePoolAttrDef::find()->asArray()->all(); foreach ($tmp_query as $item) { $svr_pool_attr_def[$item['attr_name']] = $item['def_value']; } ///保存服务池子信息 if (array_key_exists("selection", Yii::$app->request->post())) { $svr_pool = Yii::$app->request->post()["selection"]; foreach ($svr_pool as $k => $svr_pool_id) { $svr_query = DcmdService::findOne($dcmd_task->svr_id); $svr_pool_query = DcmdServicePool::findOne($svr_pool_id); $svr_pool_node_query = DcmdServicePoolNode::find()->andWhere(['svr_pool_id' => $svr_pool_id])->asArray()->all(); $dcmd_task_service_pool = new DcmdTaskServicePool(); $dcmd_task_service_pool->task_id = $dcmd_task->task_id; $dcmd_task_service_pool->task_cmd = $dcmd_task->task_cmd; $dcmd_task_service_pool->svr_pool = $svr_pool_query['svr_pool']; $dcmd_task_service_pool->svr_pool_id = $svr_pool_id; $dcmd_task_service_pool->env_ver = $svr_pool_query['env_ver']; $dcmd_task_service_pool->repo = $svr_pool_query['repo']; $dcmd_task_service_pool->run_user = $svr_query['run_user']; $dcmd_task_service_pool->undo_node = count($svr_pool_node_query); $dcmd_task_service_pool->doing_node = 0; $dcmd_task_service_pool->finish_node = 0; $dcmd_task_service_pool->fail_node = 0; $dcmd_task_service_pool->ignored_fail_node = 0; $dcmd_task_service_pool->ignored_doing_node = 0; $dcmd_task_service_pool->state = 0; $dcmd_task_service_pool->utime = date('Y-m-d H:i:s'); $dcmd_task_service_pool->ctime = $dcmd_task_service_pool->utime; $dcmd_task_service_pool->opr_uid = Yii::$app->user->getId(); if (!$dcmd_task_service_pool->save()) { Yii::$app->getSession()->setFlash('error', "保存服务池子失败"); } else { $tm = date('Y-m-d H:i:s'); ///保存服务池属性 $svr_pool_attr = array(); $tmp_query = DcmdServicePoolAttr::find()->andWhere(['svr_pool_id' => $svr_pool_id])->asArray()->all(); foreach ($tmp_query as $item) { $svr_pool_attr[$item['attr_name']] = $item['attr_value']; } foreach ($svr_pool_attr_def as $name => $value) { $dcmd_task_service_pool_attr = new DcmdTaskServicePoolAttr(); $dcmd_task_service_pool_attr->task_id = $dcmd_task->task_id; $dcmd_task_service_pool_attr->app_id = $dcmd_task->app_id; $dcmd_task_service_pool_attr->svr_id = $dcmd_task->svr_id; $dcmd_task_service_pool_attr->svr_pool_id = $svr_pool_id; $dcmd_task_service_pool_attr->attr_name = $name; if (array_key_exists($name, $svr_pool_attr)) { $dcmd_task_service_pool_attr->attr_value = $svr_pool_attr[$name]; } else { $dcmd_task_service_pool_attr->attr_value = $value; } $dcmd_task_service_pool_attr->utime = $tm; $dcmd_task_service_pool_attr->ctime = $tm; $dcmd_task_service_pool_attr->opr_uid = Yii::$app->user->getId(); $dcmd_task_service_pool_attr->save(); } } } } } ///选择服务池子 return $this->redirect(array('select-service-pool-node', 'task_id' => $dcmd_task->task_id)); } else { ///添加新任务 ///获取改用户可以操作的产品列表 $group = "select app_id, app_name from dcmd_app where "; $query = DcmdUserGroup::find()->andWhere(['uid' => Yii::$app->user->getId()])->all(); if (Yii::$app->user->getIdentity()->admin == 1) { $group .= " sa_gid in (0"; } else { $group .= " svr_gid in (0"; } if ($query) { foreach ($query as $item) { $group .= "," . $item->gid; } } $group .= ")"; $query = DcmdApp::findBySql($group)->all(); $app = array("" => ""); if ($query) { foreach ($query as $item) { $app[$item->app_id] = $item->app_name; } } $task_cmd = DcmdTaskCmd::findOne($task_cmd_id); $model = new DcmdTask(); $model->depend_task_id = 0; $model->depend_task_name = ""; $model->task_cmd = $task_cmd->task_cmd; $task_cmd_prv = $task_cmd->ui_name . '-' . date("YmdHis"); $args = $this->showTaskArg(arrToXml(array()), $task_cmd_id); return $this->render('create_by_cmd', ['model' => $model, 'app' => $app, 'task_cmd_prv' => $task_cmd_prv, 'args' => $args]); } echo "未知错误!"; exit; }
public function actionDeleteAll() { if (!array_key_exists('selection', Yii::$app->request->post())) { Yii::$app->getSession()->setFlash('error', '未选择服务池!'); return $this->redirect(['index']); } $select = Yii::$app->request->post()['selection']; $err_msg = ""; $suc_msg = ""; foreach ($select as $k => $id) { $model = $this->findModel($id); ///仅仅用户与该应用在同一个系统组才可以操作 $temp = DcmdApp::findOne($model['app_id']); $query = DcmdUserGroup::findOne(['uid' => Yii::$app->user->getId(), 'gid' => $temp['sa_gid']]); if ($query == NULL) { $err_msg .= $model->svr_pool . ":没有权限删除<br>"; continue; } $node = DcmdServicePoolNode::find()->where(['svr_pool_id' => $id])->one(); if ($node) { $err_msg .= $model->svr_pool . ':服务池子设备不为空,不可删除<br>'; continue; } else { ///删除服务池属性 DcmdServicePoolAttr::deleteAll(['svr_pool_id' => $id]); $model->delete(); $suc_msg .= $model->svr_pool . ':删除成功<br>'; } } if ($suc_msg != "") { Yii::$app->getSession()->setFlash('success', $suc_msg); } if ($err_msg != "") { Yii::$app->getSession()->setFlash('error', $err_msg); } return $this->redirect(['index']); }
public function actionDeleteAll() { if (Yii::$app->user->getIdentity()->admin != 1) { Yii::$app->getSession()->setFlash('success', NULL); Yii::$app->getSession()->setFlash('error', "对不起, 你没有权限!"); return $this->redirect(array('index')); } if (!array_key_exists('selection', Yii::$app->request->post())) { Yii::$app->getSession()->setFlash('error', '未选择属性!'); return $this->redirect(['index']); } $select = Yii::$app->request->post()['selection']; foreach ($select as $k => $v) { $model = $this->findModel($v); DcmdServicePoolAttr::deleteAll(['attr_name' => $model->attr_name]); $model->delete(); } Yii::$app->getSession()->setFlash('success', "删除成功"); return $this->redirect(['index']); }
/** * Finds the DcmdServicePoolAttr model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return DcmdServicePoolAttr the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = DcmdServicePoolAttr::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }