<?php

namespace app\models\company;

use think\facade\Db;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;

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

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

    use ModelTrait;

    public static function systemPage($where)
    {
        $model = new self;
        if (isset($where['title']) && $where['title'] !== '') $model = $model->where('title', 'LIKE', "%$where[title]%");
        if (isset($where['sid']) && $where['sid'] !== '') $model = $model->where('sid', $where['sid']);
        $model = $model->where('is_del', 0);
        $model = $model->order('sort desc,id desc');
        $count = $model->count();
        $list = $model->page((int)$where['page'], (int)$where['limit'])->select()->each(function ($item) {
            $item['_add_time'] = date('Y-m-d H:i:s', $item['add_time']);
        })->toArray();
        return compact('count', 'list');
    }

    /**
     * 详情
     */
    public static function getOne($id)
    {
        $info = self::where('is_del', 0)->find($id);
        if ($info) {
            $info['example'] = ExampleModel::where(['cid' => $id])->order('sort desc, id asc')->select();
            $info['designer'] = DesignerModel::where(['cid' => $id])->order('sort desc, id asc')->select();
            if (isset($info['slider_image']) && $info['slider_image'])
                $info['slider_image'] = json_decode($info['slider_image'], true);
            else
                $info['slider_image'] = [];
        }
        return $info;
    }

}