xl/app/admin/model/ump/StoreCoupon.php

<?php
/**
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/11/11
 */

namespace app\admin\model\ump;

use crmeb\services\FormBuilder as Form;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\facade\Route as Url;
use app\admin\model\store\StoreCategory as CategoryModel;


/**
 * Class StoreCategory
 * @package app\admin\model\store
 */
class StoreCoupon extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

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

    use ModelTrait;

    /**
     * @param $where
     * @return array
     */
    public static function systemPage($where)
    {
        $model = new self;
        $model = $model->alias('a')
            ->field('a.*,b.name')
            ->leftJoin('system_store b', 'b.id = a.store_id');
        if ($where['status'] != '') $model = $model->where('a.status', $where['status']);
        if ($where['type'] != '') $model = $model->where('a.type', $where['type']);
        if ($where['title'] != '') $model = $model->where('a.title', 'LIKE', "%$where[title]%");
//        if($where['is_del'] != '')  $model = $model->where('is_del',$where['is_del']);
        $model = $model->where('a.is_del', 0);
        $model = $model->order('a.id desc');
        $list = self::page($model, $where);
        if ($list){
            foreach ($list['list'] as &$v){
                $v['start_time'] = $v['start_time'] > 0 ? date('Y-m-d H:i:s', $v['start_time']) : 0;
                $v['end_time'] =  $v['start_time'] > 0 ? date('Y-m-d H:i:s', $v['end_time']) : 0;
            }
        }
        return $list;
    }

    /**
     * @param $where
     * @return array
     */
    public static function systemPageCoupon($where)
    {
        $model = new self;
        if ($where['status'] != '') $model = $model->where('status', $where['status']);
        if ($where['title'] != '') $model = $model->where('title', 'LIKE', "%$where[title]%");
//        if($where['is_del'] != '')  $model = $model->where('is_del',$where['is_del']);
        $model = $model->where('is_del', 0);
        $model = $model->where('status', 1);
        $model = $model->order('sort desc,id desc');
        return self::page($model, $where);
    }

    public static function editIsDel($id)
    {
        $data['status'] = 0;
        self::beginTrans();
        $res1 = self::edit($data, $id);
        $res2 = false !== StoreCouponUser::where('cid', $id)->update(['is_fail' => 1]);
        $res3 = false !== StoreCouponIssue::where('cid', $id)->update(['status' => -1]);
        $res = $res1 && $res2 && $res3;
        self::checkTrans($res);
        return $res;

    }

    /**
     * 品类券
     * @param $tab_id
     * @return array
     * @throws \FormBuilder\exception\FormBuilderException
     */
    public static function createClassRule($tab_id)
    {
        $formbuider = [];
        $formbuider[] = Form::select('category_id', '选择品类')->setOptions(function () {
            $list = CategoryModel::getTierList(null, 1);
            $menus = [];
            foreach ($list as $menu) {
                $menus[] = ['value' => $menu['id'], 'label' => $menu['html'] . $menu['cate_name']];
            }
            return $menus;
        })->filterable(1)->col(12);
        return $formbuider;
    }

    /**
     * 商品券
     * @param $tab_id
     * @return array
     * @throws \FormBuilder\exception\FormBuilderException
     */
    public static function createProductRule($tab_id)
    {
        $formbuider = [];
        $formbuider[] = Form::frameImages('image', '商品', Url::buildUrl('admin/ump.StoreCoupon/select', array('fodder' => 'image')))->icon('plus')->width('100%')->height('500px');
        $formbuider[] = Form::hidden('product_id', 0);
        return $formbuider;
    }
}