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

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

namespace app\admin\model\water;

use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\model\concern\SoftDelete;

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

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

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

    use ModelTrait;
    protected $autoWriteTimestamp = true;



    public static function list($where)
    {
        $model = self::alias('a')->field('a.*,b.name as th_name,c.name as cate_name')->order('a.id DESC')
        ->leftJoin('water_thickness b', 'a.th_id = b.id')
        ->leftJoin('water_cate c', 'a.cate_id = c.id');

        if ($where['name'])$model->where('a.name|a.number|a.id' , 'like', '%'.$where['name'].'%');
        if ($where['role'] == 'roof'){
            $model->where('a.type', 1);
        }elseif ($where['role'] == 'side_plate'){
            $model->where('a.type', 2);
        }elseif ($where['role'] == 'lacing'){
            $model->where('a.type', 3);
        }elseif ($where['role'] == 'floor'){
            $model->where('a.type', 4);
        }elseif ($where['role'] == 'column'){
            $model->where('a.type', 5);
        }elseif ($where['role'] == 'fula'){
            $model->where('a.type', 6);
        }elseif ($where['role'] == 'warm'){
            $model->where('a.type', 7);
        }elseif ($where['role'] == 'channel'){
            $model->where('a.type', 8);
        }elseif ($where['role'] == 'escalator'){
            $model->where('a.type', 9);
        }
        $data['count'] = $model->count();
        if ($where['page'] && $where['limit']){
            $model->page($where['page'], $where['limit']);
        }else{
            $model->page(20, 1);
        }
        $list = $model->select()->toArray();
        if (count($list) > 0){
            foreach ($list as &$item){
                $item['long'] = $item['long'].'m';
                $item['wide'] = $item['wide'].'m';
                $item['weight'] = $item['weight'].'kg';
            }

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

    }


}