<?php


namespace app\api\model\store;

use app\common\model\store\Coupon as CouponModel;
use app\api\model\store\Store as StoreModel;

/**
 * 店员模型
 */
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["start_time"])){
            $start_time = strtotime($params["start_time"])-1;
            $model = $model->where('coupon.create_time', '>', $start_time);
        }
        if(!empty($params["end_time"])){
            $end_time = strtotime($params["end_time"]) + 86399;
            $model = $model->where('coupon.create_time', '<', $end_time);
        }

        // 查询列表数据
        $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_name'] = $row['usercoupon']['name'];
            unset($row['usercoupon']);
        }
        unset($row);
        return $data;
    }

}