public function actionRepeatOpr() { if (!array_key_exists('selection', Yii::$app->request->post()) && !array_key_exists('ips', Yii::$app->request->post())) { Yii::$app->getSession()->setFlash('error', '未选择设备!'); return $this->redirect(['index']); } $ips = ""; if (array_key_exists('selection', Yii::$app->request->post())) { $select = Yii::$app->request->post()['selection']; if (count($select) < 1) { Yii::$app->getSession()->setFlash('error', '未选择设备!'); return $this->redirect(['index']); } $query = DcmdServicePoolNode::findAll($select); $hv = array(); foreach ($query as $item) { if (in_array($item->ip, $hv)) { continue; } $ips .= $item->ip . ";"; array_push($hv, $item->ip); } } else { $ips = Yii::$app->request->post()['ips']; } ///IP可替换的重复操作 $params = array("DcmdOprCmdRepeatExecSearch" => array("ip_mutable" => 1)); $searchModel = new DcmdOprCmdRepeatExecSearch(); $dataProvider = $searchModel->search($params); return $this->render('repeat_opr', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'ips' => $ips]); }
public function actionAppList($ip) { $ret_msg = '<table class="table table-striped table-bordered"><tbody>'; $ret_msg .= "<tr><td>产品</td><td>产品别名</td><td>服务</td><td>服务池</td></tr>"; $connection = Yii::$app->db; ///$command = $connection->createCommand('SELECT * FROM dcmd_app'); ///$posts = $command->queryAll(); //从服务池获取该机器对应的服务列表 $query = DcmdServicePoolNode::findAll(['ip' => $ip]); if ($query) { $svr_id = "dcmd_service_pool.svr_id in (0"; foreach ($query as $svr_node) { $svr_id .= "," . $svr_node->svr_id; } $svr_id .= ")"; $sql = "select dcmd_app.app_name, dcmd_app.app_id, dcmd_app.app_alias, dcmd_service.svr_name, dcmd_service.svr_id, dcmd_service_pool.svr_pool , dcmd_service_pool.svr_pool_id from dcmd_app inner join dcmd_service on dcmd_app.app_id = dcmd_service.app_id inner join dcmd_service_pool on dcmd_service.svr_id = dcmd_service_pool.svr_id where " . $svr_id; $command = $connection->createCommand($sql); $data = $command->queryAll(); if ($data) { foreach ($data as $k => $v) { $ret_msg .= "<tr><td><a href='index.php?r=dcmd-app/view&id=" . $v['app_id'] . "' target=_blank>" . $v['app_name'] . "</a></td>"; $ret_msg .= "<td>" . $v['app_alias'] . "</td>"; $ret_msg .= "<td><a href='index.php?r=dcmd-service/view&id=" . $v['svr_id'] . "' target=_blank>" . $v['svr_name'] . "</a></td>"; $ret_msg .= "<td><a href='index.php?r=dcmd-service-pool/view&id=" . $v['svr_pool_id'] . "' target=_blank>" . $v['svr_pool'] . "</a></td></tr>"; } } } $ret_msg .= "</tbody></table>"; echo $ret_msg; }