/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
///非admin用户，可查看所属业务组内的任务
$svr_con = "";
if (Yii::$app->user->getIdentity()->admin != 1) {
$app_con = "svr_gid in (0";
$query = DcmdUserGroup::find()->andWhere(['uid' => Yii::$app->user->getId()])->asArray()->all();
if ($query) {
foreach ($query as $item) {
$app_con .= "," . $item['gid'];
}
}
$app_con .= ")";
$query = DcmdApp::find()->where($app_con)->asArray()->all();
$app_con = "app_id in (0";
foreach ($query as $item) {
$app_con .= "," . $item['app_id'];
}
$app_con .= ")";
$query = DcmdService::find()->where($app_con)->asArray()->all();
$svr_con = "svr_id in (0";
foreach ($query as $item) {
$svr_con .= "," . $item['svr_id'];
}
$svr_con .= ")";
}
$query = DcmdTaskHistory::find()->where($svr_con)->orderBy('task_id desc');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => 20]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['task_id' => $this->task_id, 'depend_task_id' => $this->depend_task_id, 'svr_id' => $this->svr_id, 'update_env' => $this->update_env, 'update_tag' => $this->update_tag, 'state' => $this->state, 'freeze' => $this->freeze, 'valid' => $this->valid, 'pause' => $this->pause, 'concurrent_rate' => $this->concurrent_rate, 'timeout' => $this->timeout, 'auto' => $this->auto, 'process' => $this->process, 'utime' => $this->utime, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]);
$query->andFilterWhere(['like', 'task_name', $this->task_name])->andFilterWhere(['like', 'task_cmd', $this->task_cmd])->andFilterWhere(['like', 'depend_task_name', $this->depend_task_name])->andFilterWhere(['like', 'svr_name', $this->svr_name])->andFilterWhere(['like', 'svr_path', $this->svr_path])->andFilterWhere(['like', 'tag', $this->tag])->andFilterWhere(['like', 'err_msg', $this->err_msg])->andFilterWhere(['like', 'task_arg', $this->task_arg])->andFilterWhere(['like', 'comment', $this->comment]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params, $pagesize = 20)
{
///应用组用户只可查看所在组的应用的模板
$task_con = "";
if (Yii::$app->user->getIdentity()->admin != 1) {
$app_con = "svr_gid in (0";
$query = DcmdUserGroup::find()->andWhere(['uid' => Yii::$app->user->getId()])->asArray()->all();
if ($query) {
foreach ($query as $item) {
$app_con .= "," . $item['gid'];
}
}
$app_con .= ")";
$query = DcmdApp::find()->where($app_con)->asArray()->all();
$task_con = "app_id in (0";
foreach ($query as $item) {
$task_con .= "," . $item['app_id'];
}
$task_con .= ")";
}
$query = DcmdTaskTemplate::find()->where($task_con)->orderBy('task_tmpt_name');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => $pagesize]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['task_tmpt_id' => $this->task_tmpt_id, 'task_cmd_id' => $this->task_cmd_id, 'svr_id' => $this->svr_id, 'app_id' => $this->app_id, 'update_env' => $this->update_env, 'concurrent_rate' => $this->concurrent_rate, 'timeout' => $this->timeout, 'process' => $this->process, 'auto' => $this->auto, 'utime' => $this->utime, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]);
$query->andFilterWhere(['like', 'task_tmpt_name', $this->task_tmpt_name])->andFilterWhere(['like', 'task_cmd', $this->task_cmd])->andFilterWhere(['like', 'svr_name', $this->svr_name])->andFilterWhere(['like', 'task_arg', $this->task_arg])->andFilterWhere(['like', 'comment', $this->comment]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
///应用组用户只可查看所在组的应用
$svr_pool_con = "";
if (Yii::$app->user->getIdentity()->admin != 1) {
$app_con = "svr_gid in (0";
$query = DcmdUserGroup::find()->andWhere(['uid' => Yii::$app->user->getId()])->asArray()->all();
if ($query) {
foreach ($query as $item) {
$app_con .= "," . $item['gid'];
}
}
$app_con .= ")";
$query = DcmdApp::find()->where($app_con)->asArray()->all();
$svr_pool_con = "app_id in (0";
foreach ($query as $item) {
$svr_pool_con .= "," . $item['app_id'];
}
$svr_pool_con .= ")";
}
$query = DcmdServicePool::find()->where($svr_pool_con)->orderBy('svr_pool');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => 20]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['svr_pool_id' => $this->svr_pool_id, 'svr_id' => $this->svr_id, 'app_id' => $this->app_id, 'utime' => $this->utime, 'ctime' => $this->ctime, 'opr_uid' => $this->opr_uid]);
$query->andFilterWhere(['like', 'svr_pool', $this->svr_pool])->andFilterWhere(['like', 'repo', $this->repo])->andFilterWhere(['like', 'env_ver', $this->env_ver])->andFilterWhere(['like', 'comment', $this->comment]);
return $dataProvider;
}
public function getAppName($app_id)
{
$query = DcmdApp::findOne($app_id);
if ($query) {
return $query['app_name'];
}
return "";
}
public function getAppAlias($app_id)
{
$query = DcmdApp::findOne($app_id);
if ($query) {
return $query->app_alias;
}
return "";
}
public function getAppAlias($app_id)
{
$ret = DcmdApp::findOne($app_id);
if ($ret) {
return $ret['app_alias'];
} else {
return "";
}
}
public function getAppName($app_id)
{
$ret = DcmdApp::findOne($app_id);
if ($ret) {
return $ret['app_name'];
} else {
return '';
}
}
public function getAppName($svr_id)
{
$query = DcmdService::findOne($svr_id);
if ($query) {
$app = DcmdApp::findOne($query['app_id']);
if ($app) {
return $app['app_name'];
}
}
return "";
}
