WaterTank/app/admin/model/water/WaterCate.php

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

namespace app\admin\model\water;

use app\models\user\WechatUser;
use crmeb\services\MiniProgramService;
use crmeb\services\WechatService;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\model\concern\SoftDelete;

/**
 * Class StoreCategory
 * @package app\admin\model\store
 */
class WaterCate extends BaseModel
{

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

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

    use ModelTrait;
    protected $autoWriteTimestamp = true;




    public static function list($where)
    {
        $model = self::field('*')->order('id DESC');

        if ($where['name'])$model->where('name|id' , 'like', '%'.$where['name'].'%');
        if ($where['type'])$model->where('type' , $where['type']);
        if ($where['gc']){
            if ($where['gc'] == 1){
                $model->where('is_gc', 0);
            }else{
                $model->where('is_gc', 1);
            }
        }
        $data['count'] = $model->count();
        if ($where['page'] && $where['limit']){
            $model->page($where['page'], $where['limit']);
        }else{
            $model->page(20, 1);
        }
        $list = $model->select()->toArray();

        $type = [1 => '顶板', 2 =>'侧板', 3 =>'拉筋', 4 =>'底板',5 => '立柱', 6 =>'辅拉', 7 =>'保温', 8 =>'槽钢', 9 =>'扶梯管'];
        foreach ($list as &$item){
            $item['type'] = $type[$item['type']];
        }

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

    }



}