WaterTank/app/admin/model/water/WaterDefault.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 WaterDefault extends BaseModel
{

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

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

    use ModelTrait;
    protected $autoWriteTimestamp = true;



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

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

        foreach ($list as &$item)
        {
            $item['side_plate_name'] = '';
            $item['lacing_name'] = '';
            $item['fula_name'] = '';
            $item['roof'] = WaterCate::where('id', $item['roof'])->value('name');
            $item['floor'] = WaterCate::where('id', $item['floor'])->value('name');
            $item['column'] = WaterCate::where('id', $item['column'])->value('name');

            $side_plate = explode(',', $item['side_plate']);
            $number = 1;
            foreach ($side_plate as $value){
                $item['side_plate_name'] .= '<div>第'.$number.'层'.WaterCate::where('id', $value)->value('name').'</div>';
                $number += 1;
            }

            $lacing = explode(',', $item['lacing']);
            $number = 1;
            foreach ($lacing as $value){
                $item['lacing_name'] .= '<div>第'.$number.'层'.WaterCate::where('id', $value)->value('name').'</div>';
                $number += 1;
            }

            $fula = explode(',', $item['fula']);
            $number = 1;
            foreach ($fula as $value){
                $item['fula_name'] .= '<div>第'.$number.'层'.WaterCate::where('id', $value)->value('name').'</div>';
                $number += 1;
            }
        }
        $data['data'] = $list;
        return $data;

    }


}