Member.php 7.4 KB
<?php

namespace app\common\model;

use app\teacher\model\Teacher;
use think\Exception;
use think\Model;
use think\Db;

class Member extends Model
{
    const MATCH     = 1;
    const PROJECT   = 2;
    const STUDENT   = 1;
    const TEACHER   = 2;
    const CAPTAIN_Y = 2;
    const CAPTAIN_N = 1;
    // 表名
    protected $name = 'members';
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    // 追加属性
    protected $append = [

    ];

    //更新竞赛成员
    public function updateMembers($flg = false)
    {
        if(!$flg) {
            $info = Db::name('match_items')->alias('i')
                ->field('i.id,d.student_ids,d.teacher_ids,i.user_id,i.match_id')
                ->join('match_items_details d','d.match_items_id = i.id','inner')
                ->where('i.deletetime',null)
                ->select();
            $insert = [];
            $teacherInsert = [];
            foreach ($info as $key => $val) {
                if($val['student_ids'] == '') {
                    $student = [];
                }else{
                    $student = explode(',',$val['student_ids']);
                }
                if($val['teacher_ids'] == '' || $val['teacher_ids'] == null) {
                    $teacher = [];
                }else {
                    $teacher = explode(',',$val['teacher_ids']);
                }
                array_push($student,$val['user_id']);
                foreach ($student as $v_student) {
                    if(!User::get($v_student)) {
                        continue;
                    }
                    $tmp = [];
                    $tmp['item_id'] = $val['id'];
                    $tmp['container_id'] = $val['match_id'];
                    $tmp['member_type'] = 1;
                    $tmp['member_source'] = 1;
                    $tmp['college_id'] = Db::name('user')->where(['id' => $v_student])->value('college');
                    $tmp['member_id'] = $v_student;
                    if($v_student == $val['user_id']) {
                        $tmp['is_captain'] = 2;
                    }else{
                        $tmp['is_captain'] = 1;
                    }
                    $insert[] = $tmp;
                }
                if(!empty($teacher)) {
                    foreach ($teacher as $v_teacher) {
                        if(!Teacher::get($v_teacher)) {
                            continue;
                        }
                        $tmp = [];
                        $tmp['item_id'] = $val['id'];
                        $tmp['member_type'] = 2;
                        $tmp['member_source'] = 1;
                        $tmp['container_id'] = $val['match_id'];
                        $tmp['college_id'] = Db::name('teacher')->where(['id' => $v_teacher])->value('college_id');
                        $tmp['member_id'] = $v_teacher;
                        $tmp['is_captain'] = 1;
                        $teacherInsert[] = $tmp;
                    }
                }
            }
            $model = new static;
            Db::startTrans();
            try {
                $model->insertAll($insert);
                $model->insertAll($teacherInsert);
                Db::commit();
                echo 'ok';
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
        }else{
            $map['p.project_member_ids'] = ['EXP',Db::raw('IS NOT NULL')];
            $info = Db::name('project_register')->alias('p')
                ->field('p.id,p.container_id,p.project_member_ids,p.project_teacher_ids,p.user_id')
                ->where(['p.school_id' => 6])
                ->where('p.deletetime',null)
                ->where($map)
                ->select();


//            dump(collection($info)->toArray());die;
            $studentInsert = $teacherInsert = [];

            foreach ($info as $val) {
                if($val['project_member_ids'] == '') {
                    $student = [];
                }else{
                    $student = explode(',',$val['project_member_ids']);
                }
                if($val['project_teacher_ids'] == '') {
                    $teacher = [];
                }else {
                    $teacher = explode(',',$val['project_teacher_ids']);
                }
                array_unshift($student,$val['user_id']);
                foreach ($student as $sk => $st) {
                    if(!User::get($st)) {
                        continue;
                    }
                    $tmp = [];
                    $tmp['item_id'] = $val['id'];
                    $tmp['container_id'] = $val['container_id'];
                    $tmp['member_type'] = 1;
                    $tmp['member_source'] = 2;
                    $tmp['college_id'] = Db::name('user')->where(['id' => $st])->value('college');
                    $tmp['member_id'] = $st;
                    $tmp['sort'] = $sk;
                    if($st == $val['user_id']) {
                        $tmp['is_captain'] = 2;
                    }else{
                        $tmp['is_captain'] = 1;
                    }
                    $studentInsert[] = $tmp;
                }

                if(!empty($teacher)) {
                    foreach ($teacher as $v_teacher) {
                        if(!Teacher::get($v_teacher)) {
                            continue;
                        }
                        $tmp = [];
                        $tmp['item_id'] = $val['id'];
                        $tmp['member_type'] = 2;
                        $tmp['member_source'] = 2;
                        $tmp['container_id'] = $val['container_id'];
                        $tmp['college_id'] = Db::name('teacher')->where(['id' => $v_teacher])->value('college_id');
                        $tmp['member_id'] = $v_teacher;
                        $tmp['is_captain'] = 1;
                        $teacherInsert[] = $tmp;
                    }
                }
            }

            Db::startTrans();
            try {
                $this->insertAll($teacherInsert);
                $this->insertAll($studentInsert);
                Db::commit();
                echo 'ok';
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
        }

    }


    /**
     * 获取用户报名次数
     * @param $itemId 比赛id
     * @param $userId 用户id
     * @param $type   学生or教师
     * @param $source 来源 竞赛or双创
     * @param bool $captain 是否为队长
     */
    public static function getUserRegisterCount($containerId,$userId,$type,$source,$captain=false)
    {
        $model = new static;
        $where = $type == self::STUDENT ? ($captain ? ['is_captain' => self::CAPTAIN_Y] : ['is_captain' => self::CAPTAIN_N]) : [];
        return $model->where(['container_id' => $containerId,'member_id' => $userId,'member_type' =>$type,'member_source' => $source])->where($where)->count('id');
    }

    /**
     * @param $containerId   赛事id
     * @param $userId        用户id
     * @param $source        竞赛or双创
     */
    public static function isLeader($containerId,$userId,$source)
    {
        $model = new static;
        $info = $model->field('id')->where(['container_id' => $containerId,'member_id' => $userId,'member_source' => $source,'is_captain' => self::CAPTAIN_Y])->find();
        return $info ? true : false;
    }
}