kqt/app/admin/model/user/Close.php

<?php
/**
 * Created by PhpStorm.
 * User: liying
 * Date: 2018/7/20
 * Time: 18:08
 */

namespace app\admin\model\user;

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

class Close extends BaseModel
{

    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

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

    use ModelTrait;
    protected $autoWriteTimestamp = true;




    public static function list($where)
    {
        $model = self::alias('a')->field('a.*,b.nickname,b.phone')
            ->leftJoin('user b', 'b.uid = a.uid')
            ->order('a.id DESC');

        if ($where['name'])$model->where('b.nickname|b.uid|b.phone' , 'like', '%'.$where['name'].'%');
        if (trim($where['data']) != '') $model = self::getModelTime($where, $model,  'a.create_time');
        $data['count'] = $model->count();
        if ($where['page'] && $where['limit']){
            $model->page($where['page'], $where['limit']);
        }else{
            $model->page(20, 1);
        }
        $list = $model->select()->toArray();

        $data['data'] = $list;
        return $data;

    }
}