class UserViewModel extends ViewModel {
public $viewFields = array(
'user'=>array('id','phone','user','realname','unit','department'),
'unit'=>array('name'=>'uname', '_on'=>'cns_user.unit=cns_unit.id'),
'department'=>array('name'=>'dname', '_on'=>'cns_user.department=cns_department.did'),
);
}以上是我的代码，然后执行出来的sql语句如下：SELECT user.id AS id, user.phone AS phone, user.user AS user, user.realname AS realname, user.unit AS unit, user.department AS department, unit.name AS uname, department.name AS dname
FROM cns_user user
JOIN cns_unit unit ON cns_user.unit = cns_unit.id
JOIN cns_department department ON cns_user.department = cns_department.did
ORDER BY user.id DESC 这句sql执行是错误的，因为select后面都没有跟上cns_这个表前缀……下面是因该正确执行的sql语句
SELECT cns_user.id AS id, cns_user.phone AS phone, cns_user.user AS cns_user, cns_user.realname AS realname, cns_user.unit AS unit, cns_user.department AS department, cns_unit.name AS uname, cns_department.name AS dname
FROM cns_user cns_user
JOIN cns_unit cns_unit ON cns_user.unit = cns_unit.id
JOIN cns_department cns_department ON cns_user.department = cns_department.did
ORDER BY cns_user.id DESC
LIMIT 0 , 30我的视图模型应该怎样修改啊？ 最佳答案
