BuildingEnter.php 3.5 KB
<?php
namespace app\index\model;

use think\Model;

class BuildingEnter extends Model
{
    const IS_DRAFTS_Y = 1;//草稿
    const IS_DRAFTS_N = 2;//正式
    const TEAM = 1;//团队
    const COMPANY = 2;//公司
    protected $table  = 'fa_project_building_enter';

    protected $autoWriteTimestamp = 'int';
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = 'deletetime';
    // 追加属性
    protected $append = [
        'status_text',
        'end_time_text',
    ];
    protected $statusText = [
        1   => '待审核',
        2   => '已通过',
        3   => '已驳回',
        4   => '已取消',
        5   => '已到期',
    ];

    /**
     * 关联成员表
     * @return \think\model\relation\HasMany
     */
    public function members()
    {
        return $this->hasMany('ProjectMembers', 'enter_id')->order(['sort' => 'desc']);
    }

    /**
     * 关联审核表
     * @return \think\model\relation\HasMany
     */
    public function enterLog()
    {
        return $this->hasMany('BuildingEnterLog', 'enter_id')->where('deletetime',null)->order('createtime','asc');
    }

    /**
     * 关联审核表
     * @return \think\model\relation\HasMany
     */
    public function member()
    {
        return $this->hasMany('ProjectMembers', 'enter_id')->where('deletetime',null)->order('createtime','desc');
    }


    /**
     * 关联院校表
     * @return \think\model\relation\HasOne
     */
    public function college()
    {
        return $this->hasOne('app\\school\\model\\basic\\College', 'id','college_id');
    }

    /**
     * 关联用户表
     * @return \think\model\relation\HasOne
     */
    public function user()
    {
        return $this->hasOne('app\\school\\model\\basic\\User', 'id','user_id');
    }

    /**
     * 关联房间预约变
     * @return \think\model\relation\HasMany
     */
    public function roomOrder()
    {
        return $this->hasOne('ProjectRoomOrder', 'enter_id','id')->where('deletetime',null);
    }


    /**
     * 获取器:创建时间
     * @param $value
     * @return false|string
     */
    public function getCreateTimeAttr($value)
    {
        return $value > 0 ? date('Y-m-d H:i:s', $value) : 0;
    }
    /**
     * 获取器:自定义项目结束时间
     * @param $value
     * @return false|string
     */
    public function getProjectEndTimeAttr($value)
    {
        return $value > 0 ? date('Y-m-d H:i:s', $value) : 0;
    }

    /**
     * 获取器:孵化期文字描述
     * @param $value
     * @return false|string
     */
    public function getEndTimeTextAttr($value,$data)
    {
        if(isset($data['time_limit'])) {
            switch ($data['time_limit'])
            {
                case 1:
                    return '半年';
                    break;
                case 2:
                    return '一年';
                    break;
                case 3:
                    return '两年';
                    break;
                default:
                    $data['project_endtime'] > 0 ? date('Y-m-d H:i:s', $data['project_endtime']) : 0;
            }
        }
    }
    /**
     * 获取器:公司注册时间
     * @param $value
     * @return false|string
     */
    public function getCompanyRegisterTimeAttr($value)
    {
        return $value > 0 ? date('Y-m-d H:i:s', $value) : 0;
    }
    public function getStatusTextAttr($val,$data)
    {
        return isset($data['status']) ? $this->statusText[$data['status']] : '';
    }
}