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;
}
