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

}