 
echo CHtml::dropDownList('node', '', CHtml::listData(Node::model()->findAll(),'name','name'),array('empty'=>'--請選擇節(jié)點(diǎn)--', 
'id' => 'node', 
'ajax'=>array( 
'type'=>'POST', 
'url'=>Yii::app()->createUrl('cdnauto/config/getNodeServersByNodeName'), 
'update'=>'#servers', 
'data'=>array('node_name'=>'js:$("#node").val()'), 
) 
) 
); 
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; 
echo CHtml::dropDownList('servers', '', array('--請選擇服務(wù)器--')); 

控制器：
cdnauto/controllers/ConfigController.php

復(fù)制代碼代碼如下:

 
public function actionGetNodeServersByNodeName(){ 
// if(!Yii::app()->request->isAjaxRequest) 
// throw new CHttpException(404); 
$node_name = $_POST['node_name']; 
$nodeid = Node::model()->getNodeId($_POST['node_name']); //通過節(jié)點(diǎn)名稱獲取該節(jié)點(diǎn)ID 
$server = GossServer::model()->getServerByNodeid($nodeid); //通過節(jié)點(diǎn)ID獲取服務(wù)器信息 
//$server 為array類型，形如 $server = array(array('name'=>'name1'),array('name'=>'name2'));所以需要兩次foreach 
if(isset($server)){ 
foreach ($server as $k=>$v){ 
foreach($v as $kk => $vv){ 
echo CHtml::tag('option', array('value'=>$kk), CHtml::encode($vv), true); 
} 
} 
}else{ 
echo CHtml::tag('option', array('value'=>''), 'servers', true); 
} 
} 

模型：
GossServer.php

復(fù)制代碼代碼如下:

 
/** 
* 通過節(jié)點(diǎn)ID獲取該節(jié)點(diǎn)下所有的服務(wù)器名稱 
* @author ysdaniel 
*/ 
public static function getServerByNodeid($nodeid) 
{ 
$sql = "SELECT name FROM OSS_Server WHERE nodeid = '{$nodeid}' "; 
///$sql = "SELECT name,nodeid FROM OSS_Server WHERE nodeid = '{$nodeid}' "; //both ok 
$cmd = Yii::app()->db->createCommand($sql); 
$ret = $cmd->queryAll(); 
if (!$ret){ 
throw new Exception("找不到這個(gè)節(jié)點(diǎn)對(duì)應(yīng)的服務(wù)器"); 
} 
return $ret; 
} 

Node.php

復(fù)制代碼代碼如下:

 
/** 
* 通過nodename獲取nodeid名 
* @author 
*/ 
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; 
//throw new Exception("找不到Node{$name}"); 
} 
return $ret[0]['id']; 
} 