zccy/app/models/store/Card.php

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

namespace app\models\store;

use app\models\system\SystemStore;
use crmeb\services\PHPExcelService;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;

/**
 * 商品浏览分析
 * Class StoreVisit
 * @package app\admin\model\store
 */
class Card extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

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

    use ModelTrait;

    /**
     * @param $where
     * @return array
     */
    public static function systemPage($where)
    {
        $model = new self;
        $model = $model->alias('s');
        if ($where['status'] != '') $model = $model->where('s.status', $where['status']);
        if ($where['name'] != '') $model = $model->where('s.name|s.code', 'LIKE', "%$where[name]%");
        $model = $model->page(bcmul($where['page'], $where['limit'], 0), $where['limit']);
        $model = $model->order('s.id desc');
        return self::page($model, function ($item) {
            if ($item['status'] == 0) {
                $item['start_name'] = '待赠送';
            } else if ($item['status'] == 1) {
                $item['start_name'] = '待核销';
            } else $item['start_name'] = '已使用';

            $item['store'] = $item['store_id'] ? SystemStore::where('id', $item['store_id'])->value('name') . '/' . $item['store_id'] : '--';
            $item['check_store'] = $item['check_store_id'] ? SystemStore::where('id', $item['check_store_id'])->value('name') . '/' . $item['check_store_id'] : '--';

            $item['add_time_text'] = $item['add_time'] ? date('Y-m-d H:i:s', $item['add_time']) : '--';
            $item['send_time_text'] = $item['send_time'] ? date('Y-m-d H:i:s', $item['send_time']) : '--';
            $item['check_time_text'] = $item['check_time'] ? date('Y-m-d H:i:s', $item['check_time']) : '--';

        }, $where, $where['limit']);
    }

    public static function SaveExcel($where)
    {
        $model = new self;
        if ($where['status'] != '') $model = $model->where('s.status', $where['status']);
        if ($where['name'] != '') $model = $model->where('s.name|s.code', 'LIKE', "%$where[name]%");
        $list = $model->order('id desc')->select();
        count($list) && $list = $list->toArray();
        $excel = [];
        foreach ($list as $item) {
            if ($item['status'] == 0) {
                $item['start_name'] = '待赠送';
            } else if ($item['status'] == 1) {
                $item['start_name'] = '待核销';
            } else $item['start_name'] = '已使用';
            $excel[] = [
                $item['id'],
                $item['name'],
                $item['code'],
                $item['password'],
                $item['price'],
                $item['store_award'],
                $item['start_name'],
            ];
        }
        PHPExcelService::setExcelHeader(['编号', '标题', '卡号', '密码', '价格', '奖金', '状态'])
            ->setExcelTile('礼品卡导出', ' ', ' 生成时间：' . date('Y-m-d H:i:s', time()))
            ->setExcelContent($excel)
            ->ExcelSave();
    }

    public static function createCode()
    {
        do {
            $str = date('Y') . '-' . substr(time(), 6, 4) . rand(1000, 9999) . rand(1000, 9999);
        } while (self::be(['code' => $str]));
        return $str;
    }


    public static function createPassword()
    {
        return substr(md5(md5('lpk.zccy.rand' . rand(100000, 999999)) . rand(0, 100000)), 0, 16);
    }
}