happ/app/admin/model/ump/StoreCouponIssue.php

<?php
/**
 * @author: xaboy<365615158@qq.com>
 * @day: 2018/01/17
 */

namespace app\admin\model\ump;

use crmeb\basic\BaseModel;
use crmeb\traits\ModelTrait;

class StoreCouponIssue extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'store_coupon_issue';

    use ModelTrait;

    protected $insert = ['add_time'];

    public static function stsypage($where)
    {
        $model = self::alias('A')
            ->field('A.*,B.title,B.type')
            ->join('store_coupon B', 'A.cid = B.id')
            ->where('A.is_del', 0)
            ->order('A.id DESC');
        if (isset($where['status']) && $where['status'] != '') {
            $model = $model->where('A.status', $where['status']);
        }
        if (isset($where['type']) && $where['type'] != '') {
            $model = $model->where('B.type', $where['type']);
        }
        if (isset($where['coupon_title']) && $where['coupon_title'] != '') {
            $model = $model->where('B.title', 'LIKE', "%$where[coupon_title]%");
        }
        return self::page($model);
    }

    protected function setAddTimeAttr()
    {
        return time();
    }

    /**
     * 发布优惠券
     * @param $cid
     * @param int $total_count
     * @param int $start_time
     * @param int $end_time
     * @param int $remain_count
     * @param int $status
     * @param int $is_permanent
     * @param int $full_reduction
     * @param int $is_give_subscribe
     * @param int $is_full_give
     * @return StoreCouponIssue|\think\Model
     */
    public static function setIssue($cid, $total_count = 0, $start_time = 0, $end_time = 0, $remain_count = 0, $status = 0, $is_permanent = 0, $full_reduction = 0, $is_give_subscribe = 0, $is_full_give = 0)
    {
        return self::create(compact('cid', 'start_time', 'end_time', 'total_count', 'remain_count', 'status', 'is_permanent', 'full_reduction', 'is_give_subscribe', 'is_full_give'));
    }
}