<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------


namespace app\admin\model\special;

use traits\ModelTrait;
use basic\ModelBasic;

/**
 * Class SpecialSubject 二级分类
 * @package app\admin\model\special
 */
class SpecialSubject extends ModelBasic
{
    use ModelTrait;

    public static function get_subject_list($where){
        $data=self::setWhere($where)->page((int)$where['page'],(int)$where['limit'])->select();
        foreach ($data as &$item){
            $item['grade_name']=Grade::where('id',$item['grade_id'])->where('is_del',0)->value('name');
            $item['add_time']=date('Y-m-d H:i:s',$item['add_time']);
            $item['special_count']=Special::PreWhere()->where('subject_id',$item['id'])->count();
        }
        $count=self::setWhere($where)->count();
        return compact('data','count');
    }

    public static function setWhere($where){
        $model=self::order('sort desc,add_time desc')->where('is_del',0);
        if($where['name']) $model=$model->where('name','like',"%$where[name]%");
        if($where['pid']) $model=$model->where('grade_id',$where['pid']);
        return $model;
    }

    public static function getSubjectAll(){
        return self::order('sort desc,add_time desc')->where(['is_show'=>1,'is_del'=>0])->field('name,id')->select();
    }
}