有一个表中有三个字段:SHENG、SHI、XIAN三个字段,要关联出区域表中的区域名称,于是这个表应与AREA表关联三次才能得出三个区域的名称,视图配置如下:public $viewFields = array(
'seller_reg'=>array('seller_id','seller_name','account','reg_time','_type'=>'LEFT'),
'seller'=>array('class_id','business_id','sheng','shi','xian','big_class_order','small_class_order','profile','tags','stopinfo','atmosphere','recommend','feature','min_consumption','prefer_lever','prefer','poi','pid','rong_id','rong_discount','address','tel','businesstime','per_money','attention','temp_id','logo','brand','status','_on'=>'seller_reg.seller_id=seller.seller_id','_type'=>'LEFT'),
'area'=>array('_as' => 'shi','title'=>'shititle','_on'=>'seller.shi=shi.area_id'),
'area'=>array('_as' => 'sheng','title'=>'shengtitle','_on'=>'seller.sheng=sheng.area_id'),
'area'=>array('_as' => 'xian','title'=>'xiantitle','_on'=>'seller.xian=xian.area_id','_type'=>'LEFT'),
'business'=>array('business_name', '_on'=>'Business.business_id=seller.business_id','_type'=>'LEFT'),
'seller_class'=>array('class_name', '_on'=>'seller.class_id=seller_class.class_id','_type'=>'LEFT'),
'prefer'=>array('prefer_id', '_on'=>'seller.seller_id=prefer.seller_id'),
);最后,结果始终只出来一个区域的名称,也不报错,模型解析出来的SQL如下:SELECT seller_reg.seller_id AS seller_id,seller_reg.seller_name AS seller_name,seller_reg.account AS account,seller_reg.reg_time AS reg_time,seller.class_id AS class_id,seller.business_id AS business_id,seller.sheng AS sheng,seller.shi AS shi,seller.xian AS xian,seller.big_class_order AS big_class_order,seller.small_class_order AS small_class_order,seller.profile AS profile,seller.tags AS tags,seller.stopinfo AS stopinfo,seller.atmosphere AS atmosphere,seller.recommend AS recommend,seller.feature AS feature,seller.min_consumption AS min_consumption,seller.prefer_lever AS prefer_lever,seller.prefer AS prefer,seller.poi AS poi,seller.pid AS pid,seller.rong_id AS rong_id,seller.rong_discount AS rong_discount,seller.address AS address,seller.tel AS tel,seller.businesstime AS businesstime,seller.per_money AS per_money,seller.attention AS attention,seller.temp_id AS temp_id,seller.logo AS logo,seller.brand AS brand,seller.status AS status,xian.title AS xiantitle,business.business_name AS business_name,seller_class.class_name AS class_name,prefer.prefer_id AS prefer_id FROM local_seller_reg seller_reg LEFT JOIN local_seller seller ON seller_reg.seller_id=seller.seller_id LEFT JOIN local_area xian ON seller.xian=xian.area_id LEFT JOIN local_business business ON Business.business_id=seller.business_id LEFT JOIN local_seller_class seller_class ON seller.class_id=seller_class.class_id LEFT JOIN local_prefer prefer ON seller.seller_id=prefer.seller_id

最佳答案

评论() 相关

收藏

赞

yipinglan

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。