}
}
else
{
echo
CHtml::tag('option',
array
('value'=>''), 'servers', true);
}
}
模型:
GossServer.php
代码如下:
/**
* 通过节点 ID
获取该节点下所有的服务器名称
* @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("找不到这个节点对应的服务器");
}
return
$ret
;
}
Node.php
代码如下:
/**
* 通过 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
){