$where['name'] = $name;
$where['uname'] = m_strtolower($name);
$where['_logic'] = 'or';
$map['_complex'] = $where;
$map['name'] = $name;
$map['create_time']=array('between',array($start,$end));
$total=D("DriverOrdersView")->where($map)->count();
其他代码我就不展示了
在生成的SQL语句中，( ( `name` = '林' ) OR ( `uname` = '林' ) )似乎没被转换成( ( DriverAccu.name = '林' ) OR ( DriverAccu.uname = '林' ) )
出错SQL提示：
1052:Column 'name' in where clause is ambiguous [ SQL语句 ]：SELECT COUNT(*) AS tp_count FROM cw_driver_orders DriverOrders LEFT JOIN cw_driver_accu DriverAccu ON DriverOrders.accu_id=DriverAccu.id LEFT JOIN cw_driver_youhuiquan DriverYouhuiquan ON DriverYouhuiquan.id=DriverOrders.youhui_id WHERE ( ( `name` = '林' ) OR ( `uname` = '林' ) ) AND ( (DriverOrders.create_time BETWEEN 1430409600 AND 1433087999 ) ) AND ( DriverAccu.name = '林' ) LIMIT 1
最佳答案
