<?php
namespace Admin\Model;
use Think\Model\ViewModel;
class UserStoresOrdersViewModel extends ViewModel {
public $viewFields = array(
'users'=>array('user_id'),
'users_stores'=>array('store_id','_on'=>'users.user_id=users_stores.user_id', '_type'=>'LEFT'),
'orders'=>array('order_id', 'order_status', 'order_time', 'total_price', 'openID', 'order_number', '_on'=>'orders.store_id=users_stores.store_id'),
'stores'=>array('store_name', '_on'=>'users_stores.store_id=stores.store_id'),
);
}
?>以下是生成的sql语句:SELECT users.user_id AS user_id,users_stores.store_id AS store_id,orders.order_id AS order_id,orders.order_status AS order_status,orders.order_time AS order_time,orders.total_price AS total_price,orders.openID AS openID,orders.order_number AS order_number,stores.store_name AS store_name FROM users users JOIN users_stores users_stores ON users.user_id=users_stores.user_id LEFT JOIN orders orders ON orders.store_id=users_stores.store_id JOIN stores stores ON users_stores.store_id=stores.store_id]但是我如果做了这样的做操作以后$model = D('UserStoresOrdersView');
$orderInfo = $model->field('store_id, order_status, store_name , sum(total_price) as total_price, count(order_status) as status_num')->group('order_status')->having('store_id=store_id')->order('store_id')->select();生成的sql语句为:SELECT sum(total_price) as total_price,count(order_status) as status_num,users_stores.store_id AS store_id FROM users users JOIN users_stores users_stores ON users.user_id=users_stores.user_id LEFT JOIN orders orders ON orders.store_id=users_stores.store_id JOIN stores stores ON users_stores.store_id=stores.store_id GROUP BY orders.order_status HAVING store_id=store_id ORDER BY users_stores.store_id ASC奇怪的是这里order_status、store_name这两个字段在生成的sql语句中不见了,这是为什么呢?如果我做直接select操作,所有字段是有的。难道这是一个bug!
ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。