<?php

namespace app\common\model\plus\release;

use app\common\model\BaseModel;

/**
 * 项目模型
 */
class Project extends BaseModel
{
    protected $name = 'release_project';
    protected $pk = 'project_id';


    /**
     * 关联上传图片表
     */
    public function image()
    {
        return $this->hasMany('app\\common\\model\\plus\\release\\ReleaseProjectImage', 'project_id', 'id')->order(['id' => 'asc']);
    }

    /**
     * 关联分类
     * @return \think\model\relation\BelongsTo
     */
    public function category()
    {
        return $this->belongsTo('app\\common\\model\\plus\\release\\ReleaseCategory','category_id','category_id');
    }

     /**
     * 关联
     * @return \think\model\relation\BelongsTo
     */
    public function user()
    {
        return $this->belongsTo('app\\common\\model\\user\\User','user_id','user_id');
    }


    /**
     * 关联多标签表
     */
    public function tag()
    {
        return $this->hasMany('app\\common\\model\\plus\\release\\Tag', 'tag_id', 'tag_id');
    }
    /**
     * 关联评论表
     */
    public function evaluate()
    {
        return $this->hasMany('app\\common\\model\\plus\\release\\Evaluate', 'project_id', 'project_id')->order(['id' => 'desc']);
    }


    /**
     * 获取详情
     */
    public static function detail($project_id)
    {
        return (new static())->with(['image','evaluate','evaluate.user','category'])->find($project_id);
    }

    /**
     * 获取列表记录
     */
    public function getAll()
    {
        return $this->where('is_delete', '=', 0)
            ->field('project_id,name')
            ->order(['sort' => 'asc', 'create_time' => 'asc'])
            ->select();
    }
}