0) { $model = $model->where('clerk.store_id', '=', (int)$store_id); } if (!empty($search)) { $model = $model->where('clerk.real_name', 'like', '%' . $search . '%'); } if(!empty($params['shop_supplier_id']) && empty($store_id)){ $store_ids = StoreModel::getStoreIds($params['shop_supplier_id']); $model = $model->where('clerk.store_id', 'in', $store_ids); } // 查询列表数据 $data = $model->with(['store', 'clerk', 'usercoupon']) ->alias('coupon') ->field(['coupon.*']) ->join('store_clerk clerk', 'clerk.clerk_id = coupon.clerk_id', 'INNER') ->order(['coupon.create_time' => 'desc']) ->paginate($params); foreach ($data as &$row) { $row['supplier'] = SupplierModel::detail($row["clerk"]["shop_supplier_id"]);//核销的商户信息 $row['coupon_name'] = $row['usercoupon']['name']; unset($row['usercoupon']); } unset($row); return $data; } }