<?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;
    }

}