<?php
|
|
|
namespace app\shop\model\store;
|
|
use app\common\model\store\Coupon as CouponModel;
|
use app\shop\model\store\Store as StoreModel;
|
use app\shop\model\supplier\Supplier as SupplierModel;
|
|
/**
|
* 店员模型
|
*/
|
class Coupon extends CouponModel
|
{
|
/**
|
* 获取列表数据
|
*/
|
public function getList($store_id = 0, $search = '', $params)
|
{
|
$model = $this;
|
if ($store_id > 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;
|
}
|
|
}
|
