xmpt/app/admin/model/ump/StoreTryRecord.php

<?php
/**
 * Created by PhpStorm
 * Author: 向往那片天空
 * Date: 2020/6/9
 * Time: 9:07
 * 微信/QQ: 250023777
 * 格言: 抓住中心，宁精勿杂，宁专勿多
 */

namespace app\admin\model\ump;


use app\admin\model\order\StoreOrder;
use crmeb\basic\BaseModel;
use crmeb\services\PHPExcelService;
use crmeb\traits\ModelTrait;

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

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

    use ModelTrait;

    public static function validWhere()
    {
        return self::where('is_del', 0);
    }

    /**
     * 导出EXCEL表格,并下载
     * @param $where
     */
    public static function SaveExcel($where)
    {
        $title = StoreTryProduct::where("id={$where['tid']}")->value('store_name');
        $list = self::where("tid={$where['tid']} and is_del=0")->order('is_check desc,id desc')->select();
        count($list) && $list = $list->toArray();
        $excel = [];
        foreach ($list as $item) {
            $excel[] = [
                $item['id'],
                $item['uid'],
                $item['name'],
                $item['phone'],
                $item['address'],
                $item['attr'],
                $item['is_check'] ? '是' : '否',
                date('Y-m-d H:i:s', $item['add_time'])
            ];
        }
        PHPExcelService::setExcelHeader(['编号', '用户编号', '姓名', '电话', '地址', '规格', '是否选用', '申请时间'])
            ->setExcelTile($title . '-试用申请表', 'sheet1', ' 生成时间：' . date('Y-m-d H:i:s', time()))
            ->setExcelContent($excel)
            ->ExcelSave();
    }

    /**
     * @param $where
     * @return array
     */
    public static function systemPage($where)
    {
        $model = self::setWhere($where)->limit(bcmul($where['page'], $where['limit'], 0), $where['limit']);
        return self::page($model, $where, $where['limit']);
    }

    /**
     * 设置拼团 where 条件
     * @param $where
     * @param null $model
     * @return mixed
     */
    public static function setWhere($where, $model = null)
    {
        $model = $model === null ? new self() : $model;
        $model = $model->where('tid', $where['tid']);
        if (isset($where['uid']) && $where['uid'] != '') {
            $model = $model->where('uid|name|phone', 'like', "%$where[uid]%");
        }
        return $model->order('is_check desc,id desc')->where('is_del', 0);
    }

}