<?php
/*
* easAddUp
*/
class easAddUp_ViewModel extends ViewModel{
public $viewFields = array(
'easAddUp'=>array('add_up_id','mark','note_info','add_up_date','create_date'),
'empDept'=>array('dept_name','_on'=>'easAddUp.dept_id=empDept.dept_id','_type'=>'INNER'),
'mupUser'=>array('user_name','_on'=>'mupUser.user_id=easAddUp.create_user_id'),
//'empDept'=>array('title'=>'category_name', '_on'=>'Blog.category_id=Category.id'),
//'User'=>array('name'=>'username', '_on'=>'Blog.user_id=User.id'),
);
}
?>模型类像上面定义的使用中，如果有where条件，则查不出结果，而没有where条件，则可以出到视图的结果。
public function dept_emp_list()
{
$model = D('easAddUp_View');
$dept_id= I('get.dept_id');
$where['dept_id'] = $dept_id;
$dept_emp_ass_list = $model->where($where)->select(); //这个没有结果
//$dept_emp_ass_list = $model->select(); 这个有结果
dump($model->getLastSql());
dump($dept_emp_ass_list);有查询的条件的SQL输出:string(408) "SELECT easAddUp.add_up_id AS add_up_id,easAddUp.mark AS mark,easAddUp.note_info AS note_info,easAddUp.add_up_date AS add_up_date,easAddUp.create_date AS create_date,empDept.dept_name AS dept_name,mupUser.user_name AS user_name FROM eas_add_up easAddUp JOIN emp_dept empDept ON easAddUp.dept_id=empDept.dept_id LEFT JOIN mup_user mupUser ON mupUser.user_id=easAddUp.create_user_id WHERE ( `dept_id` = '12' ) "
最佳答案
