/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = DcmdServicePoolAttrDef::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['attr_id' => $this->attr_id, 'optional' => $this->optional, 'attr_type' => $this->attr_type, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]);
$query->andFilterWhere(['like', 'attr_name', $this->attr_name])->andFilterWhere(['like', 'def_value', $this->def_value])->andFilterWhere(['like', 'comment', $this->comment]);
return $dataProvider;
}
/**
* Updates an existing DcmdServicePoolAttr model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id, $svr_pool_id)
{
$svr_pool = DcmdServicePool::findOne($svr_pool_id);
///仅仅用户与该应用在同一个系统组才可以操作
$temp = DcmdApp::findOne($svr_pool->app_id);
$query = DcmdUserGroup::findOne(['uid' => Yii::$app->user->getId(), 'gid' => $temp['sa_gid']]);
if ($query == NULL) {
Yii::$app->getSession()->setFlash('success', NULL);
Yii::$app->getSession()->setFlash('error', "对不起, 你没有权限!");
return $this->redirect(array('dcmd-service-pool/view', 'id' => $svr_pool_id, 'show_div' => 'dcmd-service-pool-attr'));
}
if ($id == 0) {
///需要新建
$attr_id = Yii::$app->request->queryParams['attr_id'];
$def_attr = DcmdServicePoolAttrDef::findOne($attr_id);
$query = DcmdServicePoolAttr::findOne(['svr_pool_id' => $svr_pool_id, 'attr_name' => $def_attr->attr_name]);
if (count($query) > 0) {
$id = $query['id'];
} else {
$model = new DcmdServicePoolAttr();
$model->app_id = $svr_pool->app_id;
$model->svr_id = $svr_pool->svr_id;
$model->svr_pool_id = $svr_pool_id;
$model->attr_name = $def_attr->attr_name;
$model->attr_value = $def_attr->def_value;
$model->comment = $def_attr->comment;
$model->utime = date('Y-m-d H:i:s');
$model->ctime = $model->utime;
$model->opr_uid = Yii::$app->user->getId();
$model->save();
$id = $model->id;
}
}
$model = $this->findModel($id);
if ($model->load(Yii::$app->request->post()) && $model->save()) {
Yii::$app->getSession()->setFlash('success', '修改成功!');
return $this->redirect(['/dcmd-service-pool/view', 'id' => $model->svr_pool_id, 'show_div' => 'dcmd-service-pool-attr']);
} else {
return $this->render('update', ['model' => $model]);
}
}
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;
}
/**
* Displays a single DcmdServicePool model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
$searchModel = new DcmdServicePoolNodeSearch();
$con = array();
$con['DcmdServicePoolNodeSearch'] = array('svr_pool_id' => $id);
if (array_key_exists('DcmdServicePoolNodeSearch', Yii::$app->request->queryParams)) {
$con = array_merge($con, Yii::$app->request->queryParams);
}
$con['DcmdServicePoolNodeSearch']['svr_pool_id'] = $id;
$dataProvider = $searchModel->search($con, false);
$show_div = "dcmd-service-pool-node";
if (array_key_exists("show_div", Yii::$app->request->queryParams)) {
$show_div = Yii::$app->request->queryParams['show_div'];
}
///获取属性
$self_attr = DcmdServicePoolAttr::find()->andWhere(['svr_pool_id' => $id])->asArray()->all();
$def_attr = DcmdServicePoolAttrDef::find()->asArray()->all();
$attr_str = '<div id="w1" class="grid-view">
<table class="table table-striped table-bordered"><thead>
<tr><th>属性名</th><th>值</th><th>操作</th></tr>
</thead><tbody>';
$attr = array();
foreach ($self_attr as $item) {
$attr_str .= '<tr><td>' . $item['attr_name'] . '</td><td>' . $item['attr_value'] . '</td><td><a href="/ducter/index.php?r=dcmd-service-pool-attr/update&id=' . $item['id'] . '&svr_pool_id=' . $id . '">修改</a></td></tr>';
$attr[$item['attr_name']] = $item['attr_name'];
}
foreach ($def_attr as $item) {
if (array_key_exists($item['attr_name'], $attr)) {
continue;
}
$attr_str .= '<tr><td>' . $item['attr_name'] . '</td><td>' . $item['def_value'] . '</td><td><a href="/ducter/index.php?r=dcmd-service-pool-attr/update&id=0&attr_id=' . $item['attr_id'] . '&svr_pool_id=' . $id . '">修改</a></td></tr>';
}
$attr_str .= "</tbody></table></div>";
return $this->render('view', ['svr_pool_id' => $id, 'model' => $this->findModel($id), 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'show_div' => $show_div, 'attr_str' => $attr_str]);
}
/**
* Finds the DcmdServicePoolAttrDef model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return DcmdServicePoolAttrDef the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = DcmdServicePoolAttrDef::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}