$distributor_name = input('distributor_name', '', 'trim');
if (!empty($distributor_name)) {
$where['d.real_name'] = ['like', '%' . $distributor_name . '%'];
}
$salesman_name = input('salesman_name', '', 'trim');
if (!empty($salesman_name)) {
$where['s.real_name'] = ['like', '%' . $salesman_name . '%'];
}
public function getOrdersByWhere($where, $offset, $limit)
{
return $this
->field($this->table .'.*, s.real_name as salesman_name, d.real_name as distributor_name')
->join([
['ma_admin s', $this->table.'.salesman_id=s.id', 'left'],
['ma_admin d', $this->table.'.distributor_id=d.id', 'left']
])
->where($where)
->limit($offset, $limit)
->order($this->table.'.id desc')
// ->fetchSql()
->select();
}查询接口出现SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.real_name' in 'where clause'提示fetchSql输出的SQL语句，在MySQL中可正常使用
最佳答案
