<?php
|
|
|
namespace app\supplier\model\store;
|
|
use app\common\model\store\Coupon as CouponModel;
|
|
/**
|
* 店员模型
|
*/
|
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 . '%');
|
}
|
$model = $model->where('coupon.shop_supplier_id', '=', $params['shop_supplier_id']);
|
// 查询列表数据
|
$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['coupon_content'] = empty($row['usercoupon']['coupon_project']) ? '' : $row['usercoupon']['coupon_project'][$row['project_id']]['content'];
|
$row['coupon_name'] = $row['usercoupon']['name'];
|
unset($row['usercoupon']);
|
}
|
unset($row);
|
return $data;
|
}
|
|
}
|
