Yii 1.x 透過 CHtml::dropDownList 搭配 AJAX 實現節點 → 伺服器兩級聯動選單。
<?php
// 節點下拉選單
echo CHtml::dropDownList('node', '', CHtml::listData(Node::model()->findAll(), 'name', 'name'), [
'empty' => '-- 請選擇節點 --',
'id' => 'node',
'ajax' => [
'type' => 'POST',
'url' => Yii::app()->createUrl('cdnauto/config/getNodeServersByNodeName'),
'update' => '#servers', // 直接更新目標 select 內容
'data' => ['node_name' => 'js:$("#node").val()'], // JS 表達式取得當前值
]
]);
echo " ";
echo CHtml::dropDownList('servers', '', ['-- 請選擇服務器 --']);
?>
public function actionGetNodeServersByNodeName() {
// if (!Yii::app()->request->isAjaxRequest) throw new CHttpException(404);
$node_name = $_POST['node_name'];
$nodeid = Node::model()->getNodeId($node_name); // 透過節點名稱取得 ID
$servers = GossServer::model()->getServerByNodeid($nodeid); // 取得伺服器列表
if (isset($servers)) {
foreach ($servers as $server) {
foreach ($server as $value => $label) {
// 輸出
public static function getServerByNodeid($nodeid) {
$sql = "SELECT name FROM OSS_Server WHERE nodeid = '{$nodeid}'";
$cmd = Yii::app()->db->createCommand($sql);
$ret = $cmd->queryAll();
if (!$ret) {
throw new Exception("找不到這個節點對應的服務器");
}
return $ret; // 返回 [[name=>'srv1'], [name=>'srv2']]
}
public static function getNodeId($name) {
$sql = "SELECT id FROM OSS_Node WHERE name = '{$name}'";
$cmd = Yii::app()->db->createCommand($sql);
$ret = $cmd->queryAll();
if (!$ret) return null;
return $ret[0]['id'];
}
OSS_Node: id (PK), name
OSS_Server: id (PK), name, nodeid (FK)
CHtml::listData() 快速將 AR 陣列轉為鍵值對ajax['data'] 使用 js: 前綴執行 JavaScript 表達式取得動態值ajax['update'] 直接指定目標容器 ID,框架自動替換 innerHTML<option> 標籤,而非 JSON,簡化前端處理// 控制器
header('Content-Type: application/json');
echo json_encode($servers);
Yii::app()->end();
// 視圖 JS 修改
'ajax' => [
'type' => 'POST',
'url' => ...,
'success' => 'js:function(data) {
var $sel = $("#servers").empty();
$sel.append($("