ProjectMembers.php 1.3 KB
<?php
namespace app\index\model;

use think\Model;

class ProjectMembers extends Model
{
    const STUDENT = 1; //学生
    const TEACHER = 2; //教师

    const ENTER     = 1; //入驻
    const MATCH     = 2; //大创
    const PROJECT   = 3; //竞赛

    protected $table  = 'fa_project_members';

    protected $autoWriteTimestamp = 'int';
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = 'deletetime';
    // 追加属性
    protected $append = [
    ];

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

    /**
     * @param $id 项目id
     * @param $memberSource 成员来源
     */
    public function getMembers($id,$memberSource)
    {
        switch ($memberSource) {
            case self::ENTER:
                $whereField = 'enter_id';
                break;
            case self::MATCH:
                $whereField = 'match_item_id';
                break;
            default:
                $whereField = 'project_register_id';
        }

        $data = $this->where([$whereField => $id])->where('deletetime',null)->select();
        return $data ? collection($data)->toArray() : null;
    }
}