private function setWhere($query)
{
if (isset($query['search']) && !empty($query['search'])) {
$this->where('order_no|userRelation.server_user_detail_name', 'like', '%' . trim($query['search']) . '%');
}
if (isset($query['start_time']) && !empty($query['start_time'])) {
$this->where('order.create_time', '>=', strtotime($query['start_time']));
}
if (isset($query['end_time']) && !empty($query['end_time'])) {
$this->where('order.create_time', '<', strtotime($query['end_time']) + 86400);
}
if (isset($query['active_id']) && $query['active_id'] > 0) {
$this->where('order.active_id', '=', (int)$query['active_id']);
}
if (isset($query['delivery_type']) && !empty($query['delivery_type'])) {
$query['delivery_type'] > -1 && $this->where('delivery_type', '=', $query['delivery_type']);
}
if (isset($query['extract_shop_id']) && !empty($query['extract_shop_id'])) {
$query['extract_shop_id'] > -1 && $this->where('extract_shop_id', '=', $query['extract_shop_id']);
}
}
public function getList($dataType, $query = [])
{
// 检索查询条件
!empty($query) && $this->setWhere($query);
// 获取数据列表
return $this->with(['active', 'goods.image', 'address', 'user','userRelation'])
->alias('order')
->field('order.*, active.status as active_status')
->join('user', 'user.user_id = order.user_id', 'LEFT')
->join('sharing_active active', 'order.active_id = active.active_id', 'LEFT')
->where($this->transferDataType($dataType))
->where('order.is_delete', '=', 0)
->order(['order.create_time' => 'desc'])
->paginate(10, false, [
'query' => \request()->request()
]);
}
public function userRelation()
{
$module = "app\\common\\model\\merge\\user\\UserRelationModel";
return $this->belongsTo($module, "user_id", "user_id");
}
错误信息，
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'userRelation.server_user_detail_name' in 'where clause'

那位，大佬讲解一下一对一关联查询，条件在关联的模型中的处理方式

有需求加我 2465167794

为啥不直接用获取器呢?