http://document.thinkphp.cn/manual_3_2.html#view_model
ThinkPHP还可以支持视图模型的JOIN类型定义,我们可以把上面的视图定义改成:
public $viewFields = array(
'Blog'=>array('id','name','title','_type'=>'LEFT'),
'Category'=>array('title'=>'category_name','_on'=>'Category.id=Blog.category_id','_type'=>'RIGHT'),
'User'=>array('name'=>'username','_on'=>'User.id=Blog.user_id'),
);
需要注意的是,这里的_type定义对下一个表有效,因此要注意视图模型的定义顺序。Blog模型的
'_type'=>'LEFT'
针对的是下一个模型Category而言,通过上面的定义,我们在查询的时候最终生成的SQL语句就变成:
Select
Blog.id as id,
Blog.name as name,
Blog.title as title,
Category.title as category_name,
User.name as username
from think_blog Blog LEFT JOIN think_category Category ON Blog.category_id=Category.id RIGHT JOIN think_user User ON Blog.user_id=User.id