<?php
|
|
|
namespace app\operations\model\store;
|
|
use app\common\model\store\Coupon as CouponModel;
|
use app\operations\model\store\Store as StoreModel;
|
use app\operations\model\supplier\Supplier as SupplierModel;
|
|
/**
|
* 店员模型
|
*/
|
class Coupon extends CouponModel
|
{
|
// 定义全局的查询范围
|
protected $globalScope = ['status'];
|
public function scopeStatus($query)
|
{
|
$shop_supplier_ids = \app\operations\model\supplier\Supplier::getSupplierIdsByUser(session('jjjshop_operations')['user']);
|
if (empty($shop_supplier_ids)){
|
$query->where($query->getTable() . '.shop_supplier_id', -1);
|
}else{
|
$query->where($query->getTable() . '.shop_supplier_id', 'in', $shop_supplier_ids);
|
}
|
}
|
/**
|
* 获取列表数据
|
*/
|
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;
|
}
|
|
}
|
