xiaoben-as2-php/protected/models/SchoolManager.php

<?php
/**
 * @author: Rick Guo
 * @brief: 学校管理器
 */

defined("ROLE_USER") or define("ROLE_USER", 1);
defined("ROLE_SU") or define("ROLE_SU", 2);

class SchoolManager extends Model{
	public $coachId;
	public $coach;
	public $coachRole;
	public $role;
	public $parentNotificationHost;
	public $semesterAllowToChangeDays;
	public $semesterAllowToChangeTime;
	public $apiUrl;
	public $topicUrl;
	public $topicField;
	public $topicCacheTime;
	public $chapterCacheTime;
	public $sTopic;

	//试题sections顺序 升序
	public $topicTypesOrder = array(
		"选择题" => 1,
		"填空题" => 2,
		"解答题" => 3,
	);

	public $msgs = array(
		"global" => array(
			"0" => "操作成功",
			"1001" => "缺少参数",
			"1002" => "系统错误",
		),

		"changeSemester" => array(
			"2001" => "不能切换到已完成的学期",
			"2002" => "",
            "2003"=>"创建班级失败",
		),

		"delSemester" => array(
			"2001" => "不能删除当前学期",
			"2002" => "学期已关联班级",
		),

		"delClass" => array(
			"2001" => "该班级已关联学生",
			"2002" => "该班级已创建过考试",
		),

		"delTeacher" => array(
			"2001" => "该老师已绑定班级",
			"2002" => "该老师已创建过周周练",
		),

		"purgeTeacher" => array(
			"2001" => "该老师已绑定班级",
			"2002" => "该老师已创建过考试",
            "2003" => "该老师还有未完成的阅卷任务",
            "2004" => "该老师还有未处理的问题卷",
		),

		"purgeStudent" => array(
			"2001" => "无法操作，该学生已存在考试数据",
		),

		"removeStudentClassRelation" => array(
			"2001" => "该学生存在周周练数据",
		),

		"replaceIspTopic" => array(
			"2001" => "新题目和被替换的题目相同，未替换",
			"2002" => "被替换的题目在该提分册不存在",
			"2003" => "新题目已经存在于该提分册，请选择别的题目",
		),
	);

	public $inciseTables=array(
        'student_paper_topic_rs',
        'student_paper_relation',
        'student_improve_score_plan_topics',
        'student_wrong_plan_topics',
        'student_upload_result'
    );
	function __construct($coachId, $role = ROLE_USER,$pad=''){


		parent::__construct();
		if($pad)
		{

			$this->role = $role;

			$this->parentNotificationHost = Yii::app()->params["notification_host"];
			$this->semesterAllowToChangeDays = !empty(Yii::app()->params["semester_allow_to_change_days"]) ? Yii::app()->params["semester_allow_to_change_days"] : 15;
			$this->semesterAllowToChangeTime = $this->semesterAllowToChangeDays * 24 * 3600;
			$this->msgs["changeSemester"]["2002"] = "只有在学期开始前{$this->semesterAllowToChangeDays}天内允许切换";

			$this->apiUrl = Yii::app()->params["api"][0]["prefix"];
			$this->topicUrl = $this->apiUrl.Yii::app()->params["topic_store"]["topic_append"];
			$this->topicField = Yii::app()->params["topic_store"]["topic_field"];
			$this->topicCacheTime = !empty(Yii::app()->params["topic_cache_time"]) ? Yii::app()->params["topic_cache_time"] : 43200;
			$this->topicHost = $this->apiUrl.Yii::app()->params["topic_store"]["topic_host"];
			$this->chapterCacheTime = !empty(Yii::app()->params["chapter_cache_time"]) ? Yii::app()->params["chapter_cache_time"] : 43200;
			$this->sTopic = new STopic();
		}else
		{
			if(!$coachId)
				throw new CException("助教ID不能为空");
			$this->coachId = $coachId;
			$this->role = $role;
			$this->coach = $this->getMyInfo();
			$this->coachRole = $this->coach["leader"];
			$this->parentNotificationHost = Yii::app()->params["notification_host"];
			$this->semesterAllowToChangeDays = !empty(Yii::app()->params["semester_allow_to_change_days"]) ? Yii::app()->params["semester_allow_to_change_days"] : 15;
			$this->semesterAllowToChangeTime = $this->semesterAllowToChangeDays * 24 * 3600;
			$this->msgs["changeSemester"]["2002"] = "只有在学期开始前{$this->semesterAllowToChangeDays}天内允许切换";

			$this->apiUrl = Yii::app()->params["api"][0]["prefix"];
			$this->topicUrl = $this->apiUrl.Yii::app()->params["topic_store"]["topic_append"];
			$this->topicField = Yii::app()->params["topic_store"]["topic_field"];
			$this->topicCacheTime = !empty(Yii::app()->params["topic_cache_time"]) ? Yii::app()->params["topic_cache_time"] : 43200;
			$this->topicHost = $this->apiUrl.Yii::app()->params["topic_store"]["topic_host"];
			$this->chapterCacheTime = !empty(Yii::app()->params["chapter_cache_time"]) ? Yii::app()->params["chapter_cache_time"] : 43200;
			$this->sTopic = new STopic();
		}

	}

	protected function rs($code, $action = __FUNCTION__){
		$rs = array();

		if($code !== null){
			if(is_array($code))
				$codeStr = implode(", ", $code);
			else
				$codeStr = $code;

			$rs = array(
				"code" => $codeStr,
				"msg" => $this->translateCode($code, $action),
			);
		}

		return $rs;
	}

	protected function translateCode($code, $action = __FUNCTION__, $symbol = "<br/>"){
		$msg = array();

		if($code !== null && isset($this->msgs[$action])){
			if(!is_array($code))
				$code = array($code);

			$i = 1;
			foreach($code as $val){
				if(isset($this->msgs[$action][(string)$val])){
					if($val != 0)
						$msg[] = "<span style='color:red'>{$this->msgs[$action][(string)$val]}</span>";
					else
						$msg[] = "<span style='color:green'>{$this->msgs[$action][(string)$val]}</span>";

					$i++;
				}
			}
		}

		if($msg){
			$msg = implode($symbol, $msg);
		}
		else
			$msg = "";

		return $msg;
	}

	public function getTeachers($orderBy = array("teacher_id asc", "teacher_name asc")){
		$teachers = array();

		$orderBy = $this->orderBy($orderBy);
		$rs = $this->sConn->createCommand("select * from teacher where status != 2 group by teacher_id{$orderBy}")->queryAll();

		if($rs)
			$teachers = $rs;

		return $teachers;
	}

	public function getTeacherAccount($teacherId){
		$account = array();

		if($teacherId){
			$account = $this->conn->createCommand("select * from xb_teacher where teacher_id = '{$teacherId}'")->queryRow();
		}

		return $account;
	}

	public function getTeachersAccounts($teachersIds){
		if(!is_array($teachersIds) || !$teachersIds)
			return array();

		$teachersIds = "'".implode("','", $teachersIds)."'";

		return $this->conn->createCommand("select * from xb_teacher where teacher_id in({$teachersIds})")->queryAll();
	}

	public function countTeachersAccountsPages($pageSize){
		if(!$pageSize)
			return 0;

		$rs = $this->conn->createCommand("select count(*) from xb_teacher")->queryRow();
		$rs = current($rs);

		return ceil($rs / $pageSize);
	}

	public function getTeachersByClassesIds($classesIds){
		$teachers = array();

		if($classesIds){
			$classesIds = "'".implode("','", $classesIds)."'";
			return $this->sConn->createCommand("
				select t.*, tcr.class_id,tcr.is_bzr,t.subjects,tcr.hxb_ing
				from teacher_class_relation as tcr
				join teacher as t on t.teacher_id = tcr.teacher_id
				where tcr.class_id in($classesIds)
			")->queryAll();
		}

		return $teachers;
	}
	public function getTeachersByClassesIdsAndteacherName($classesIds,$teacher_name){
		$teachers = array();

		if($classesIds){
			$classesIds = "'".implode("','", $classesIds)."'";
			return $this->sConn->createCommand("
				select t.*, tcr.class_id
				from teacher_class_relation as tcr
				join teacher as t on t.teacher_id = tcr.teacher_id
				where tcr.class_id in($classesIds) and t.teacher_name LIKE '%{$teacher_name}%'
			")->queryAll();
		}

		return $teachers;
	}

	public function getTeachersIdsByClassesIds($classesIds){
		$classes = $this->getTeachersByClassesIds($classesIds);

		return $this->grouping($classes, "teacher_id");
	}

	public function getMyInfo(){
		return $this->conn->createCommand("select * from coach where coach_id = '{$this->coachId}'")->queryRow();
	}

	public function getNowClassesByTeacherId($teacherId,$class_id = 0){
		$classes = array();

		if($teacherId){
		    if($class_id >0){
                $classes = $this->sConn->createCommand("
				select c.*
				from teacher_class_relation as tcr
				join class as c on c.class_id = tcr.class_id and c.semester_id = '{$this->semester["id"]}'
				where tcr.teacher_id = '{$teacherId}' and c.class_id = '{$class_id}'
			")->queryAll();
            }else{

                $classes = $this->sConn->createCommand("
				select c.*
				from teacher_class_relation as tcr
				join class as c on c.class_id = tcr.class_id and c.semester_id = '{$this->semester["id"]}'
				where tcr.teacher_id = '{$teacherId}'  and c.is_hide=0
			")->queryAll();
            }

		}

		return $classes;
	}

	public function getClassesByTeacherId($teacherId){
		$classes = array();

		if($teacherId){
			$classes = $this->sConn->createCommand("
				select c.*
				from teacher_class_relation as tcr
				join class as c on c.class_id = tcr.class_id
				where tcr.teacher_id = '{$teacherId}'
			")->queryAll();
		}

		return $classes;
	}

	/**
	 * 获取 上传试卷列表
	 *
	 * @author CeeFee
	 */
	public function getUploadPaperList($orderBy = array("add_time DESC", "id DESC"),$subject_id=3, $pageSize = 10)
	{
		$str = '';
		$orderBy = $this->orderBy($orderBy);
		if($subject_id==3)
		{
			$str = ' subject_id in ('.implode(',',Yii::app()->params['mathSubjectId']).')';
		}else
		{
			$str = ' subject_id = '.$subject_id;
		}
		$handle = $this->sConn->createCommand("
			SELECT * FROM upload_paper WHERE  {$str}
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getTeachersList($orderBy = array("teacher_name asc", "teacher_id asc"), $pageSize = 10){
		/*$orderBy = $this->orderBy($orderBy);
		$classesIds = $this->getClassesIdsByCoachId($this->coachId);
		$teachersIds = $this->getTeachersIdsByClassesIds($classesIds);
		$teachersIds = "'".implode("','", $teachersIds)."'";

		$handle = $this->sConn->createCommand("
			select * from teacher where coach_id = '{$this->coachId}' and status != 2
			union
			select * from teacher where teacher_id in({$teachersIds})
			{$orderBy}
		")->query();*/
		/**
		 * 刘红伟修改
		 * 时间：2016-11-7
		 */
		$orderBy = $this->orderBy($orderBy);
		/*$classesIds = $this->getClassesIdsByCoachId($this->coachId);
		$teachersIds = $this->getTeachersIdsByClassesIds($classesIds);
		$teachersIds = "'".implode("','", $teachersIds)."'";*/

		$handle = $this->sConn->createCommand("
			select * from teacher where  status != 2 {$orderBy}
		")->query();
		$rs = $this->paging($this->sConn, $handle, $pageSize);
		$teachersIds = $this->grouping($rs["rs"], "teacher_id");
		$teachersAccounts = $this->getTeachersAccounts($teachersIds);

		foreach($rs["rs"] as $key => $val){
			$rs["rs"][$key]["businessphone"] = null;
			$rs["rs"][$key]["class_name"] = null;

			foreach($teachersAccounts as $account){
				if($val["teacher_id"] == $account["teacher_id"]){
					$rs["rs"][$key]["businessphone"] = $account["phone_number"];
					$classes = $this->getNowClassesByTeacherId($val["teacher_id"]);
					$classes = $this->grouping($classes, "class_name");
					$classes = implode(",", $classes);
					$rs["rs"][$key]["class_name"] = $classes;
				}
			}
		}

		return $rs;
	}
	public function getTeachersListre($teacher_name='',$subject_id = 0,$class_id = 0,$orderBy = array("teacher_name asc", "teacher_id asc"), $pageSize = 10){
		/*$orderBy = $this->orderBy($orderBy);
		$classesIds = $this->getClassesIdsByCoachId($this->coachId);
		$teachersIds = $this->getTeachersIdsByClassesIds($classesIds);
		$teachersIds = "'".implode("','", $teachersIds)."'";

		$handle = $this->sConn->createCommand("
			select * from teacher where coach_id = '{$this->coachId}' and status != 2
			union
			select * from teacher where teacher_id in({$teachersIds})
			{$orderBy}
		")->query();*/
		/**
		 * 刘红伟修改
		 * 时间：2016-11-7
		 */
		$orderBy = $this->orderBy($orderBy);
		/*$classesIds = $this->getClassesIdsByCoachId($this->coachId);
		$teachersIds = $this->getTeachersIdsByClassesIds($classesIds);
		$teachersIds = "'".implode("','", $teachersIds)."'";*/

		$condition=array();
		if($teacher_name){
            if(is_array($teacher_name)){
                $condition[]="t.teacher_id in(".implode(',',$teacher_name).")";
            }else{
                $condition[]="t.teacher_name LIKE '%{$teacher_name}%'";
            }
        }
        if($subject_id){
            if(in_array($subject_id,Yii::app()->params['mathSubjectId'])){
                $condition[]="t.subjects  in(".implode(',',Yii::app()->params['mathSubjectId']).")";
            }else{
                $condition[]="t.subjects  ='{$subject_id}'";
            }
        }
		if($class_id){
            $condition[]="tr.class_id = ".$class_id." and  tr. semester_id = '".$this->semester["id"]."'";

            $handle = $this->sConn->createCommand("
select t.*,tr.class_id from teacher as t LEFT JOIN teacher_class_relation tr on t.teacher_id = tr.teacher_id where ".implode(' and ',$condition)."  GROUP by t.teacher_id HAVING tr.class_id >0 order by t.add_time desc
		")->query();
        }else{

		    if($condition){
                $handle = $this->sConn->createCommand("select * from teacher t where ".implode(' and ',$condition)."  {$orderBy}")->query();
            }else{
                $handle = $this->sConn->createCommand("select * from teacher   {$orderBy}")->query();
            }

        }


		$rs = $this->paging($this->sConn, $handle, $pageSize);

		$teachersIds = $this->grouping($rs["rs"], "teacher_id");
		$teachersAccounts = $this->getTeachersAccounts($teachersIds);

		$teachers = array();
		if($teachersAccounts)
		{
			foreach($teachersAccounts as $v)
			{
				$teachers[$v['teacher_id']]	=	$v;
			}
		}

		foreach($rs["rs"] as $key => $val){
			$rs["rs"][$key]["businessphone"] = null;
			$rs["rs"][$key]["class_name"] = null;
            if(isset($teachers[$val["teacher_id"]]) && !empty($teachers[$val["teacher_id"]])){
                $rs["rs"][$key]["businessphone"] = $teachers[$val["teacher_id"]]["phone_number"];

            }
            $classes = $this->getNowClassesByTeacherId($val["teacher_id"],$class_id);

            if(!$classes&&$class_id){
                unset($rs["rs"][$key]);
                continue;
            }
            $classes = $this->grouping($classes, "class_name");
            $classes = implode(",", $classes);
            $rs["rs"][$key]["class_name"] = $classes;
		}

		return $rs;
	}
	public function getClasses($grade = "ALL", $orderBy = array("class_id asc", "class_name asc"), $offset = 0, $limit = -1){
		$classes = array();
		$condition = array();

		if(in_array($grade, array("1", "2", "3")))
			$condition = array("grade = '{$grade}'");
		else if($grade !== "ALL")
			return $classes;

		$condition = Arr::merge($condition, array("semester_id = '{$this->semester["id"]}'"));

		$condition = $this->condition($condition);
		$orderBy = $this->orderBy($orderBy);
		$limit = $this->limit($offset, $limit);

		$classes = $this->sConn->createCommand("select * from class{$condition} group by class_id{$orderBy}{$limit}")->queryAll();

		return $classes;
	}

	public function getClassesWithoutTheClass($classId, $orderBy = array("class_id asc", "class_name asc"), $offset = 0, $limit = -1){
		$classes = array();

		if($classId){
			$condition = array("semester_id = '{$this->semester["id"]}'", "class_id != '{$classId}'");
			$condition = $this->condition($condition);
			$orderBy = $this->orderBy($orderBy);
			$limit = $this->limit($offset, $limit);

			$classes = $this->sConn->createCommand("select * from class{$condition} group by class_id{$orderBy}{$limit}")->queryAll();
			$classes = Arr::toObj($classes);
		}

		return $classes;
	}

	public function getClassesList($condition = array(), $pageSize = 9){
		$condition = $this->condition($condition);
		$handle = $this->sConn->createCommand("
			select c.*
			from class as c
			{$condition}
			order by c.class_id desc
		")->query();
		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getMyClassesList($condition = array(), $pageSize = 9){
		$condition = Arr::merge(array("ccr.coach_id = '{$this->coachId}'"), $condition);
		return $this->getClassesList($condition, $pageSize);
	}
	public function getClassesDetailListre($condition = array(), $pageSize = 9){
		$condition = $this->condition($condition);
		/*$handle = $this->sConn->createCommand("
			select c.*, seme.semester_name as name, seme.school_year
			from class as c
			join semester as seme on seme.semester_id = c.semester_id
			JOIN teacher_class_relation as tc on c.class_id = tc.class_id and seme.semester_id = tc.semester_id
			JOIN teacher as t on tc.teacher_id = t.teacher_id
			{$condition}
			order by c.class_id desc
		")->query();*/
		$handle = $this->sConn->createCommand("
			select c.*, seme.semester_name as name, seme.school_year,c.teacher_id
			from class as c
			join semester as seme on seme.semester_id = c.semester_id

			{$condition}
			order by c.sort!=0 desc,c.sort,c.class_id desc
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		if($rs["rs"]){
			$coachesIds = $this->grouping($rs["rs"], "coach_id");
			$coachesIds = array_unique($coachesIds);
			$coaches = $this->getCoachesByIds($coachesIds);

			$classesIds = $this->grouping($rs["rs"], "class_id");
			$classesIds = array_unique($classesIds);
			$teachers = $this->getTeachersByClassesIds($classesIds);

			foreach($rs["rs"] as $key => $val){
				$rs["rs"][$key]["coach_name"] = "";
				foreach($coaches as $coach){
					if($val["coach_id"] == $coach["coach_id"]){
						$rs["rs"][$key]["coach_name"] = $coach["coach_name"];
					}
				}
			}
			foreach($rs["rs"] as $key => $val){
				$rs["rs"][$key]["teachers"] = "";
                $rs["rs"][$key]["teachers_count"]=0;
                $rs["rs"][$key]["teachers_bzr"]='';
				foreach($teachers as $teacher){
					if(strcmp($val["class_id"],$teacher["class_id"])==0){
                        $rs["rs"][$key]["teachers"] .= $teacher["teacher_name"];
                        $rs["rs"][$key]["teachers_count"] ++;

					}
				}
				//读取班主任
                if($val['teacher_id']){
				    $rs['rs'][$key]['teachers_bzr']=Teacher::model()->getTeacherName($val['teacher_id']);
                }
			}


		}

		return $rs;
	}
	public function getClassesDetailList($condition = array(), $pageSize = 9,$teacher_name=''){
		$condition = $this->condition($condition);
		$handle = $this->sConn->createCommand("
			select c.*, seme.semester_name as name, seme.school_year,c.teacher_id
			from class as c
			join semester as seme on seme.semester_id = c.semester_id
			{$condition}
			order by c.sort!=0 desc,c.sort,c.class_id desc
		")->query();
		$rs = $this->paging($this->sConn, $handle, $pageSize);
		if($rs["rs"]){
			$coachesIds = $this->grouping($rs["rs"], "coach_id");
			$coachesIds = array_unique($coachesIds);
			$coaches = $this->getCoachesByIds($coachesIds);

			$classesIds = $this->grouping($rs["rs"], "class_id");
			$classesIds = array_unique($classesIds);
			if($teacher_name){
				$teachers = $this->getTeachersByClassesIdsAndteacherName($classesIds,$teacher_name);
			}else{

				$teachers = $this->getTeachersByClassesIds($classesIds);
			}

			foreach($rs["rs"] as $key => $val){
                $rs["rs"][$key]["coach_name"] = "";
                foreach($coaches as $coach){
                    if($val["coach_id"] == $coach["coach_id"]){
                        $rs["rs"][$key]["coach_name"] = $coach["coach_name"];
                    }
                }
				$rs["rs"][$key]["teachers"] = "";
				foreach($teachers as $teacher){
					if($val["class_id"] == $teacher["class_id"]){
						$rs["rs"][$key]["teachers"] .= $teacher["teacher_name"];
					}
				}
                //读取班主任
                if($val['teacher_id']){
                    $rs['rs'][$key]['teachers_bzr']=Teacher::model()->getTeacherName($val['teacher_id']);
                }
			}


		}

		return $rs;
	}

	public function getMyclassesDetailList($condition = array(), $pageSize = 9){
		$condition = Arr::merge(array("c.coach_id = '{$this->coachId}'"), $condition);
		return $this->getClassesDetailList($condition, $pageSize);
	}

	public function getCoachesByIds($coachesIds){
		$coaches = array();

		if($coachesIds && is_array($coachesIds)){
			$coachesIds = implode("','", $coachesIds);
			$coachesIds = "'{$coachesIds}'";
			$coaches = $this->conn->createCommand("select * from coach where coach_id in($coachesIds)")->queryAll();
		}

		return $coaches;
	}

	public function changeClassTeachersRelation($classId, $teachersIds,$semesterId=0){
		if($classId && $teachersIds){
			if(!is_array($teachersIds))
				$teachersIds = array($teachersIds);

			$values = "";

			foreach($teachersIds as $key => $teacherId){
				if(trim((string)$teacherId) == null){
					unset($teachersIds[$key]);
					continue;
				}

				$values .= ",('{$classId}', '{$teacherId}', '{$semesterId}')";
			}

			if($values){
				$values = "values".substr($values, 1);

				try{
					$trans = $this->sConn->beginTransaction();
					$this->sConn->createCommand("delete from teacher_class_relation where class_id = '{$classId}'")->execute();
					$this->sConn->createCommand("insert into teacher_class_relation(`class_id`, `teacher_id`, `semester_id`) {$values}")->execute();
					$trans->commit();
					$rs = true;
				}
				catch(Exception $e){
					$trans->rollBack();
					$rs = false;
				}

				return $rs;
			}
		}

		return false;
	}

	public function _changeClassTeachersRelation($classId, $teachersIds,$class_data	= array()){
		if($classId && $teachersIds){
			if(!is_array($teachersIds))
				$teachersIds = array($teachersIds);

			$values = "";

			foreach($teachersIds as $key => $teacherId){
				if(trim((string)$teacherId) == null){
					unset($teachersIds[$key]);
					continue;
				}

				$values .= ",('{$classId}', '{$teacherId}', '{$class_data['semester_id']}')";
			}
            if(!isset($class_data['class_type'])){
                $class_data['class_type']=1;
            }
			if($values){
				$values = "values".substr($values, 1);

				try{
					$trans = $this->sConn->beginTransaction();
                    if(isset($class_data['teacher_id'])){
                        $this->sConn->createCommand("insert into class(`class_id`,`class_name`, `coach_id`, `semester_id`,`period`,`grade`,`level`,`wrong_book_type`,`improve_book_type`,`wb_isp_version`,`add_time`,`class_type`,`teacher_id`) VALUES (".$classId.",'".$class_data['class_name']."',".$class_data['coach_id'].",".$class_data['semester_id'].",".$class_data['period'].",".$class_data['grade'].",".$class_data['level'].",".$class_data['wrong_book_type'].",".$class_data['improve_book_type'].",".$class_data['wb_isp_version'].",".$class_data['add_time'].",".$class_data['class_type'].",".$class_data['teacher_id'].")")->execute();
                    }else{
                        $this->sConn->createCommand("insert into class(`class_id`,`class_name`, `coach_id`, `semester_id`,`period`,`grade`,`level`,`wrong_book_type`,`improve_book_type`,`wb_isp_version`,`add_time`,`class_type`) VALUES (".$classId.",'".$class_data['class_name']."',".$class_data['coach_id'].",".$class_data['semester_id'].",".$class_data['period'].",".$class_data['grade'].",".$class_data['level'].",".$class_data['wrong_book_type'].",".$class_data['improve_book_type'].",".$class_data['wb_isp_version'].",".$class_data['add_time'].",".$class_data['class_type'].")")->execute();
                    }


					$this->sConn->createCommand("delete from teacher_class_relation where class_id = '{$classId}'")->execute();
					$this->sConn->createCommand("insert into teacher_class_relation(`class_id`, `teacher_id`, `semester_id`) {$values}")->execute();
					$trans->commit();
					$rs = true;
				}
				catch(Exception $e){
					$trans->rollBack();
					$rs = false;
				}

				return $rs;
			}
		}

		return false;
	}
	/**
	 * @param $semesterId
	 *
	 * @return bool
	 * 刘红伟
	 * 开发时间 2016-09-29

	 *
	 */

	public function insertStudentInfoAndStudentClass($userNames,$studnetIds,$realname_array,$userno,$_IDX_array,$sex_array,$school_id,$class_id,$is_insert = 1)
	{

		$trans 				= 	$this->sConn->beginTransaction();
		$student_id_array	=	array();
		$sql1				=	'';
		try {
			if($is_insert)
			{
				$sql1='';
				$sql='INSERT INTO `student_info`
								 (`student_id`,`realname`,`sex`,`school_id`,`class_id`,`add_time`)VALUES';

				foreach($userNames as $username)
				{
					if(isset($studnetIds[$username]) && !empty($studnetIds[$username]))
					{
						$student_id_array[] = $studnetIds[$username];

						$sql1.='('.$studnetIds[$username].',"'.(isset($realname_array[$username]) && !empty($realname_array[$username])?$sex_array[$username]:'').'",'.(isset($sex_array[$username]) && !empty($sex_array[$username])?$sex_array[$username]:0).','.$school_id.','.$class_id.','.time().'),';

					}
				}
				$sql	.=	substr($sql1,0,-1).';';

				$this->sConn->createCommand($sql)->execute();
			}else
			{

				foreach($userNames as $username)
				{

					if(isset($studnetIds[$username]) && !empty($studnetIds[$username]))
					{  $student_id_array[] = $studnetIds[$username];
						$sql	=	'update  `student_info` set realname="'.$realname_array[$username].'",sex='.$sex_array[$username].',class_id='.$class_id.',update_time='.time().' where student_id='.$studnetIds[$username].';';
						$this->sConn->createCommand($sql)->execute();
					}
				}
			}
			$sql1	=	'';
			$sql	=	'';
			$this->sConn->createCommand("delete from student_class_relation where class_id =".$class_id." and student_id in (".implode(',',$student_id_array).")")->execute();
			$sql	=	'INSERT INTO `student_class_relation`
								 (`class_id`,`student_id`,`status`,`serial_number`,`userno`,`update_time`)VALUES';

			foreach($userNames as $username)
			{
				if(isset($studnetIds[$username]) && !empty($studnetIds[$username]))
				{
					$sql1 .= '(' . $class_id . ',' . $studnetIds[$username] . ',0,' . $_IDX_array[$username] . ',"' . $userno[$username] . '",' . time() . '),';
				}
			}
			$sql	.=	substr($sql1,0,-1).';';

			$this->sConn->createCommand($sql)->execute();
			$trans->commit();
		} catch (Exception $e) {
			$trans->rollBack();
			return false;
		}
		return true;

	}

	public function getClassByClassIds($classIds)
	{
		if(!$classIds)
		{
			return false;
		}
		$rs = $this->sConn->createCommand("
					select *
					from class
					where class_id in(".implode(',',$classIds).") ")->queryAll();
		if($rs)
		{
			return $rs;
		}
		return false;
	}

	public function updateStudentClassByClassIdAndStudentID($class_id,$student_ids)
	{
		$trans = $this->sConn->beginTransaction();
		try {

			$sql='update  `student_class_relation` set status = 1 where class_id= '.$class_id;
			$this->sConn->createCommand($sql)->execute();
			$sql='update  `student_info` set class_id = 0 where class_id= '.$class_id;
			$this->sConn->createCommand($sql)->execute();
			$sql='update  `student_class_relation` set status = 1 where student_id in ('.implode(',',$student_ids).')';
			$this->sConn->createCommand($sql)->execute();
			$trans->commit();
		} catch (Exception $e) {
			$trans->rollBack();
			return false;
		}
		return true;
	}


	public function getStudentByStudentIds($studentIds){
		if($studentIds && is_array($studentIds))
		{

			$rs = $this->sConn->createCommand("select * from student_info where student_id in(".implode(',',$studentIds).")")->queryAll();

			if($rs)
			{
				return $rs;
			}
		}

		return false;
	}

	/**
	 * @param $studentsIds
	 * @param $paper_id
	 * @param $exam_id
	 *
	 */
	public function getStudentByStudentIdsAndParperIdAndExamId($studentsIds,$paper_id,$exam_id)
	{
		$data	=	array();
		$criteria	=	new CDbCriteria();
		$criteria->addCondition('paper_id=:paper_id');
		$criteria->addCondition('exam_id=:exam_id');
		$criteria->addInCondition('student_id',$studentsIds);
		$criteria->addCondition('is_feedback=:is_feedback');
		$criteria->addCondition('is_del=:is_del');
		$criteria->params[':paper_id']		=	$paper_id;
		$criteria->params[':exam_id']		=	$exam_id;
		$criteria->params[':is_feedback']	=	1;
		$criteria->params[':is_del']	=	0;

		$rs	=	SStudentPaperRelation::model()->findAll($criteria);
		if($rs){
			foreach($rs as $v)
			{
				$data[] = $v->attributes;
			}
			return $rs;
		}
		return false;
	}

	public function delStudentPaperByStudentAndPaperAndExamId($studentsIds,$paper_id)
	{
        $rs=false;


        $trans 			= $this->sConn->beginTransaction();

        try {
            $this->sConn->createCommand("update student_paper_relation set is_del=1 where student_id in(".implode(',',$studentsIds).") and paper_id='".$paper_id."' ")->execute();
            $this->sConn->createCommand("DELETE FROM  student_answer_card_online where student_id in(".implode(',',$studentsIds).") and paper_id='".$paper_id."'")->execute();
           // $this->sConn->createCommand("DELETE FROM  student_paper_relation_property where student_id in(".implode(',',$studentsIds).") and paper_id=".$paper_id." ")->execute();
            $trans->commit();
            return true;
        } catch (Exception $e) {
            $trans->rollBack();
            return false;
        }
		return false;

	}

	/**
	 * 获取班级学生
	 * @param $class_id
	 *
	 * @return array|bool|\CDbDataReader
	 */
	public function getClassStudentByClassId($class_id)
	{
		$rs = $this->sConn->createCommand("select * from student_class_relation where class_id=".$class_id." and status=0")->queryAll();
		if($rs){
			return $rs;
		}
		return false;
	}

	public function getClassPaperByClassAndPaper($class_id,$paper_id,$status=0)
	{
		$rs = $this->sConn->createCommand("select student_id,paper_id,class_id,exam_id from student_paper_relation where class_id=".$class_id." and paper_id=".$paper_id." and is_del=".$status)->queryAll();
		if($rs){
			return $rs;
		}
		return false;
	}

	public function getClassStudentInfoByClassId($class_id){
	    $sql="select scr.student_id,realname,scr.class_id from student_class_relation scr join student_info si on si.student_id=scr.student_id where scr.class_id='".$class_id."' and scr.status=0";
		//$rs = $this->sConn->createCommand("select student_id,realname,class_id from student_info where class_id=".$class_id)->queryAll();
        $rs = $this->sConn->createCommand($sql)->queryAll();
		if($rs){
			return $rs;
		}
		return false;
	}

	public function getStudentByStudentIdsAndParperId($studentsIds,$paper_id,$is_del=0)
	{
		$rs = $this->sConn->createCommand("select student_id from student_paper_relation where student_id in(".$studentsIds.") and paper_id=".$paper_id." and is_del=".$is_del)->queryAll();
		if($rs){
			return $rs;
		}
		return false;
	}
	public function getStudentsByStudentIdsAndExam_ids($exam_ids,$studentsIds)
	{
		if($exam_ids && $studentsIds)
		{
			$rs = $this->sConn->createCommand("select student_id from student_paper_relation where exam_id in ( ".$exam_ids." ) and student_id in(".$studentsIds.") and is_del=0")->queryAll();
			if($rs){
				return $rs;
			}
		}

		return false;
	}



	public function addAndUpdateStudentPaper($class_id,$add_student,$exam_id,$semester_id,$paper_id,$student_cards=array(),$school_student_cards=array(),$exam_ids=array(),$grade=array()	)
	{

		$trans 			= $this->sConn->beginTransaction();
		$sql			=	'insert into `student_paper_relation` (`student_id`,`paper_id`,`class_id`,`exam_id`,`semester_id`,`student_card`,`school_student_card`,`studytrend_exam_name`)VALUES';
		$sql1			=	'';

		$sqlProperty    =   'insert into `student_paper_relation_property` (`student_id`,`paper_id`,`class_id`,`exam_id`,`semester_id`,`create_time`) VALUES';
        $sqlPV          =   '';
		try {

			if($add_student)
			{
				$criteria = new CDbCriteria();
				$criteria->addCondition('exam_id=:exam_id');
				$criteria->addCondition('paper_id = :paper_id');
				$criteria->addInCondition('student_id',$add_student);
				$criteria->params[':exam_id']	=	$exam_id;
				$criteria->params[':paper_id']	=	$paper_id;

				SStudentPaperRelation::model()->deleteAll($criteria);
                SStudentPaperRelationProperty::model()->deleteAll($criteria);
				foreach($add_student as $student_id)
				{
					$school_student_card	=	0;
					$student_card = 0;
					if(isset($school_student_cards[$student_id]) && !empty($school_student_cards[$student_id]))
					{
						$school_student_card	=	$school_student_cards[$student_id];
					}

					if(isset($student_cards[$student_id]) && !empty($student_cards[$student_id]))
					{
						$student_card	= $student_cards[$student_id];
						$sql1 .= '(' . $student_id . ',' . $paper_id . ','.$class_id.',' .$exam_id. ',' . $semester_id .','.$student_card.',"'.$school_student_card.'",""),';
                        $sqlPV.= '(' . $student_id . ',' . $paper_id . ','.$class_id.',' .$exam_id. ',' . $semester_id .','.time().'),';
					}


				}

				$sql 	.=	substr($sql1,0,-1).';';
                $sqlProperty 	.=	substr($sqlPV,0,-1).';';

				$this->sConn->createCommand($sql)->execute();
                $this->sConn->createCommand($sqlProperty)->execute();
			}



			$trans->commit();
		} catch (Exception $e) {
			$trans->rollBack();
			return false;
		}
		return true;
	}
	/**
	 * 刘红伟  end
	 */











	public function semesterAllowToChange($semesterId){
		if($semester = $this->getSemester($semesterId)){
			if(is_numeric($semester["start_time"]) && ($semester["start_time"] - time()) <= $this->semesterAllowToChangeTime)
				return true;
		}

		return false;
	}

	public function semesterExists($semesterId){
		if(!$semesterId)
			return false;

		$rs = $this->sConn->createCommand("select exists(select * from semester where semester_id = '{$semesterId}')")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function changeSemester($semesterId){
		$code = 1001;

		if($semesterId){
			$code = array();

			if($this->role !== ROLE_SU){
				if($this->isPreviousSemester($semesterId))
					$code[] = 2001;

				if(!$this->semesterAllowToChange($semesterId)){
					$code[] = 2002;
				}
			}

			if($code)
				return $this->rs($code, __FUNCTION__);

			try{
				if($this->semesterExists($semesterId)){
					$trans = $this->sConn->beginTransaction();
					$this->sConn->createCommand("update semester set status = 0 where status = 1")->execute();
					$this->sConn->createCommand("update semester set status = 1 where semester_id = '{$semesterId}'")->execute();

					$trans->commit();
					$rs = true;
				}
				else
					$rs = false;
			}
			catch(Exception $e){
				$trans->rollBack();
				$rs = false;
			}

			if($rs){
				if($this->isFutureSemester($semesterId))
					$this->activateSemesterClassesStudentsRelations($semesterId);
			}

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function getClassesTeachers($classesIds){
		$teachers = array();

		if($classesIds){
			$classesIds = implode(",", $classesIds);

			$rs = $this->sConn->createCommand("
				select t.teacher_name , tcr.class_id, c.level,t.subjects
				from teacher_class_relation as tcr
				join teacher as t on t.teacher_id = tcr.teacher_id
				join class as c on c.class_id = tcr.class_id
				where tcr.class_id in({$classesIds})

			")->queryAll();

			if($rs)
			    foreach ($rs as $val){
                    if(isset(Yii::app()->params['subjectId'][$val['subjects']])){
                        $teachers[(string)$val['class_id']][]=$val['teacher_name'].'('.Yii::app()->params['subjectId'][$val['subjects']].')';
                    }else{
                        $teachers[(string)$val['class_id']][]=$val['teacher_name'];
                    }

                }

		}

		return $teachers;
	}




	public function getTeachersByclassIdsAndteacherName($classesIds,$teacher_name){
		$teachers = array();

		if($classesIds){
			$classesIds = implode(",", $classesIds);

			$rs = $this->sConn->createCommand("
				select group_concat(t.teacher_name) as teachers_names, tcr.class_id, c.level
				from teacher_class_relation as tcr
				join teacher as t on t.teacher_id = tcr.teacher_id
				join class as c on c.class_id = tcr.class_id
				where tcr.class_id in({$classesIds}) AND t.teacher_name LIKE '%{$teacher_name}%'
				group by tcr.class_id
			")->queryAll();

			if($rs)
				$teachers = $rs;
		}

		return $teachers;
	}
	public function getClassPreviousStudentsList($classId, $condition = array(), $pageSize = 9, $type = "OBJ"){
		$rs = $this->buildEmptyPagingStruct();

		if($classId){
			$condition = Arr::merge(array("scr.class_id = '{$classId}'"), $condition);
			$condition = $this->condition($condition);
			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}
				group by student_id
				order by scr.serial_number ASC ,stu.student_id desc
			")->query();
			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}
	public function getClassPreviousStudentsListre($classId, $condition = array(), $pageSize = 9, $type = "OBJ"){
		$rs = $this->buildEmptyPagingStruct();

		if($classId){
			$condition = Arr::merge(array("scr.class_id = '{$classId}'"), $condition);
			$condition = $this->condition($condition);
			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id and scr.status = 0
				join class as c on c.class_id = scr.class_id
				{$condition}
				group by student_id
				order by scr.serial_number ASC ,stu.student_id desc
			")->query();
			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}
	public function getClassPreviousStudentsListWithAccounts($classId, $condition = array(), $pageSize = 9){
		$rs = $this->getClassPreviousStudentsList($classId, $condition, $pageSize, "ARR");

		if($rs["rs"]){
			foreach($rs["rs"] as $key => $val){
				$rs["rs"][$key]["username"] = "";
				$rs["rs"][$key]["status"] = null;
			}

			$studentsIds = $this->grouping($rs["rs"], "student_id");
			$studentsIds = implode("','", $studentsIds);
			$studentsIds = "'{$studentsIds}'";
			$accounts = $this->conn->createCommand("select * from student where student_id in({$studentsIds})")->queryAll();

			if($accounts){
				foreach($accounts as $account){
					foreach($rs["rs"] as $key => $val){
						if($val["student_id"] && $val["student_id"] == $account["student_id"]){
							$rs["rs"][$key]["username"] = $account["username"];
							$rs["rs"][$key]["status"] = $account["status"];
						}
					}
				}
			}
		}

		return $rs;
	}

	public function getClass($classId){
		$class = array();

		if($classId){
			$class = $this->sConn->createCommand("select * from class where class_id = '{$classId}'")->queryRow();
		}

		return $class;
	}

	public function getClassInfo($classId, $type = "ARR"){
		$classInfo = null;

		if($classId){
			$classInfo = $this->sConn->createCommand("
				select c.*, csr.subject_id, csr.material_id, csr.module_ids as modules_ids
				from class as c
				left join class_subject_relation as csr on csr.class_id = c.class_id
				where c.class_id = '{$classId}'
			")->queryRow();

			if($type == "OBJ"){
				$classInfo = Arr::toObj($classInfo);
			}
		}

		return $classInfo;
	}

	public function getClassTeachersIds($classId){
		$teachersIds = array();

		if($classId){
			$rs = $this->sConn->createCommand("
				select * from teacher_class_relation where class_id = '{$classId}' group by teacher_id
			")->queryAll();

			if($rs)
				$teachersIds = $this->grouping($rs, "teacher_id");
		}

		return $teachersIds;
	}

	public function semesterHasClass($semesterId){
		if($semesterId){
			$rs = $this->sConn->createCommand("select exists(select * from class where semester_id = '{$semesterId}')")->queryRow();

			return current($rs) ? true : false;
		}

		return false;
	}

	public function classHasStudent($classId){
		if(!($class = $this->getClass($classId)))
			return false;

		$condition = array("class_id = '{$classId}'");
		if($this->isCurrentSemester($class["semester_id"]))
			$condition = Arr::merge($condition, array("status = 0"));
		$condition = $this->condition($condition);

		$rs = $this->sConn->createCommand("select exists(select * from student_class_relation{$condition})")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function classHasExam($classId){
		if($classId){
			$rs = $this->sConn->createCommand("select exam_id,exam_group_id from exam where class_id = '{$classId}'")->queryAll();
			if($rs){
				return $rs;
			}

		}

		return false;
	}

	public function studentHasPaper($studentId){
		if($studentId){
			$rs = $this->sConn->createCommand("
				select exists(select * from student_paper_relation where semester_id = '{$this->semester["id"]}' and student_id = '{$studentId}' and is_del=0)
			")->queryRow();
			$rs = current($rs);

			return $rs ? true : false;
		}

		return false;
	}

	public function studentHasPaperInOtherSemesters($studentId){
		if(!$studentId)
			return false;

		$rs = $this->sConn->createCommand("
			select exists(select * from student_paper_relation where semester_id != '{$this->semester["id"]}' and student_id = '{$studentId}') and is_del=0
		")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function teacherHasBindedClass($teacherId){
		if($teacherId){
			$rs = $this->sConn->createCommand("select count(*) from teacher_class_relation where teacher_id = '{$teacherId}'")->queryAll();

			return current(current($rs)) > 0 ? true : false;
		}

		return false;
	}

	public function teacherHasCreatedExam($teacherId){
		if($teacherId){
			$rs = $this->sConn->createCommand("select count(*) from exam where teacher_id = '{$teacherId}'")->queryAll();

			return current(current($rs)) > 0 ? true : false;
		}

		return false;
	}

    public function teacherHasMarkingTask($teacherId){
        if($teacherId){
            $rs = $this->sConn->createCommand("select count(*) from marking_task where teacher_id = '{$teacherId}' AND status=0" )->queryAll();

            return current(current($rs)) > 0 ? true : false;
        }

        return false;
    }

    public function teacherHasProblemMark($teacherId){
        if($teacherId){
            $rs = $this->sConn->createCommand("select count(*) from marking_task where teacher_id = '{$teacherId}' AND status=1 AND is_problem=1 AND problem_status=0" )->queryAll();

            return current(current($rs)) > 0 ? true : false;
        }

        return false;
    }

	public function delSemester($semesterId){
		$code = 1001;

		if($semesterId){
			$code = array();

			if($this->role !== ROLE_SU){
				if($this->isCurrentSemester($semesterId))
					$code[] = 2001;
				if($this->semesterHasClass($semesterId))
					$code[] = 2002;
			}

			if($code)
				return $this->rs($code, __FUNCTION__);

			$rs = $this->sConn->createCommand("delete from semester where semester_id = '{$semesterId}'")->execute();

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}
	public function CoachdelClass($classId){
		$code = 1001;

		$hasStudent=false;
        $hasExam=false;
		if($classId){
			$code = array();

			if($this->role !== ROLE_SU){
				if($this->classHasStudent($classId)){
                    $hasStudent=true;
                    $code[] = 2001;
                }

				if($this->classHasExam($classId)){
                    $code[] = 2002;
                    $hasExam=true;
                }

			}

            if($hasStudent){
                return $this->rs($code, 'delClass');
            }else{
                try{
                    $trans = $this->sConn->beginTransaction();
                    //查询班级属性
                    $classInfo=$this->sConn->createCommand("select class_type from class where class_id = '{$classId}' " )->queryRow();
                    if($hasExam){
                        //隐藏班级
                        $this->sConn->createCommand("UPDATE class SET is_hide = 1  WHERE class_id = '{$classId}'")->execute();
                    }else{
                        $this->sConn->createCommand("delete from class where class_id = '{$classId}'")->execute();
                        $this->sConn->createCommand("delete from class_subject_relation where class_id = '{$classId}'")->execute();
                        $this->sConn->createCommand("delete from teacher_class_relation where class_id = '{$classId}'")->execute();


                        if($classInfo['class_type']==1){
                            //查询行政班学生
                            $classStudent=$this->sConn->createCommand("select student_id from student_class_relation  WHERE class_id = '{$classId}' and status=0")->queryAll();
                            if($classStudent){
                                $studentIds=array();
                                foreach ($classStudent as $item){
                                    $studentIds[]=$item['student_id'];
                                }
                                $this->sConn->createCommand("update student_class_relation set status=1,operation=1 where student_id in(".implode(',',$studentIds).") and status=0")->execute();
                            }
                        }else{
                            $this->sConn->createCommand("UPDATE student_class_relation SET status = 1  WHERE class_id = '{$classId}'")->execute();
                        }

                        $this->sConn->createCommand("delete from product_class_relation where class_id = '{$classId}'")->execute();
                    }
                    $trans->commit();
                    $rs = true;
                }
                catch(Exception $e){
                    $trans->rollBack();

                    $rs = false;
                }

                $code = $rs ? 0 : 1002;

            }


		}

		return $this->rs($code, "global");
	}
	public function delClass($classId){
		$code = 1001;

		if($classId){
			$code 				= array();
			$exam_ids			=	array();
			$exam_group_ids		=	array();
			$paper_ids			=	array();
			$_exam_group_ids	=	array();
			$exam_group 		=	array();

            //查询班级属性
            $classInfo=$this->sConn->createCommand("select class_type from class where class_id = '{$classId}' " )->queryRow();
			if($this->role !== ROLE_SU){
				$class_exam	=	$this->classHasExam($classId);
				if($class_exam)
				{
					if(count($class_exam)>2){
						$code[] = 2002;
					}else
					{
						foreach($class_exam as $v)
						{
							$exam_ids[$v['exam_id']]	=	$v['exam_id'];
							$exam_group_ids[$v['exam_group_id']]	=	$v['exam_group_id'];
						}
						$papers = $this->sConn->createCommand("select paper_id from paper where exam_id IN (".implode(',',$exam_ids).")")->queryAll();
						if($papers)
						{
							foreach($papers as $v)
							{
								$paper_ids[$v['paper_id']]	=	$v['paper_id'];
							}
						}
						$exams = $this->sConn->createCommand("select exam_id,exam_group_id from exam where exam_group_id IN (".implode(',',$exam_group_ids).")")->queryAll();

						if($exams)
						{
							foreach ($exams as $v)
							{
								$exam_group[$v['exam_group_id']][] = $v;
							}
							foreach($exam_group_ids as $v)
							{
								if(isset($exam_group[$v]) && !empty($exam_group[$v]) && count($exam_group[$v])==1){
									$_exam_group_ids[]	=	$v['exam_group_id'];
								}
							}
						}

					}
				}



			}


			if($code)
				return $this->rs($code, __FUNCTION__);

			try{
				$trans = $this->sConn->beginTransaction();

				$this->sConn->createCommand("delete from class where class_id = '{$classId}'")->execute();
				//$this->sConn->createCommand("UPDATE student_info SET class_id = 0  WHERE class_id = '{$classId}'")->execute();

                if($classInfo['class_type']==1){
                    //查询行政班学生
                    $classStudent=$this->sConn->createCommand("select student_id from student_class_relation  WHERE class_id = '{$classId}' and status=0")->queryAll();
                    if($classStudent){
                        $studentIds=array();
                        foreach ($classStudent as $item){
                            $studentIds[]=$item['student_id'];
                        }
                        $this->sConn->createCommand("update student_class_relation set status=1,operation=1 where student_id in(".implode(',',$studentIds).") and status=0")->execute();
                    }
                }else{
                    $this->sConn->createCommand("UPDATE student_class_relation SET status = 1,operation=1 WHERE class_id = '{$classId}'")->execute();
                }

				$this->sConn->createCommand("delete from class_subject_relation where class_id = '{$classId}'")->execute();
				$this->sConn->createCommand("delete from teacher_class_relation where class_id = '{$classId}'")->execute();
				$this->sConn->createCommand("delete from exam where class_id = '{$classId}'")->execute();
				$this->sConn->createCommand("delete from student_paper_relation where class_id = '{$classId}'")->execute();
				if($paper_ids)
				{
					$this->sConn->createCommand("delete from student_paper_topic_rs where paper_id in (".implode(',',$paper_ids).")")->execute();
				}
				$trans->commit();
				$rs = true;
			}
			catch(Exception $e){
				$trans->rollBack();

				$rs = false;
			}


			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function delExam($examId, $type){
		if($examId && $type){
			return $this->sConn->createCommand("delete from exam where exam_id = '{$examId}' and type = '{$type}'")->execute();
		}

		return false;
	}

	public function studentHasBindedClass($studentId){
		if(!$studentId)
			return false;

		$rs = $this->sConn->createCommand("select exists(select * from student_class_relation where student_id = '{$studentId}' and status = 0)")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function studentAccountExists($studentId){
		if(!$studentId)
			return false;

		$rs = $this->conn->createCommand("select exists(select * from student where student_id = '{$studentId}')")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function purgeStudent($studentId,$auth=0,$classId=0){
		$code = 1001;
		$msg  = '删除成功';
		if($auth==0)
		{
		    $rs = true;
            $authUsername = Yii::app()->session['coachInfo']["school_id"] . '_' . Yii::app()->session['coachInfo']["coach_name"];
            $http = http('service/student-delete-perm','post', $authUsername, array($studentId));
            $response = formatResponse($http);
            if(isset($response['data']) && $response['data']){
                if($response['data'][0]['hasOrder']==1){
                    $rs=false;
                    $code = 2001;
                    $msg = '无法操作，该学生已存在订单数据';
                }
            }

            if($studentId && $rs){
                if($classId){
                    $student_paper_relation = $this->sConn->createCommand("select * from student_paper_relation where student_id  = ".$studentId." and class_id='".$classId."'")->queryRow();
                }else{
                    $student_paper_relation = $this->sConn->createCommand("select * from student_paper_relation where student_id  = ".$studentId)->queryRow();
                }

                if(!$student_paper_relation)
                {
                    $trans1 = $this->sConn->beginTransaction();
                    try{
                        if($classId){
                            $this->sConn->createCommand("update student_class_relation set status = 1,`operation`=1 where student_id = '{$studentId}' and class_id='".$classId."' and status = 0")->execute();
                        }else{
                            $this->sConn->createCommand("update student_class_relation set status = 1,`operation`=1 where student_id = '{$studentId}' and status = 0")->execute();
                        }

                        $trans1->commit();

                    }
                    catch(Exception $e){
                        $trans1->rollBack();
                        $rs = false;
                        $msg = '删除失败';
                    }
                    $code = $rs ? 0 : 1002;
                }else
                {
                    $code = 2001;
                    $msg = '无法操作，该学生已存在考试数据';
                }

            }else
            {
                $rs = false;
                if(!$msg){
                    $msg = '删除失败';
                }
                $code = $rs ? 0 : 1002;
            }
		}else
		{
			$rs = true;
			if($studentId){

				$trans1 = $this->sConn->beginTransaction();
				try{
                    if($classId){
                        $this->sConn->createCommand("update student_class_relation set status = 1,`operation`=1 where student_id = '{$studentId}' and class_id='".$classId."' and status = 0")->execute();
                    }else{
                        $this->sConn->createCommand("update student_class_relation set status = 1,`operation`=1 where student_id = '{$studentId}' and status = 0")->execute();
                    }

					$trans1->commit();

				}
				catch(Exception $e){
					$trans1->rollBack();
					$rs = false;
					$msg = '删除失败';
				}
			}else
			{

				$rs = false;
				$msg = '删除失败';
			}
			$code = $rs ? 0 : 1002;
		}


		return array('code'=>$code,'msg'=>$msg);
	}

	public function removeStudentClassRelation($studentId, $classId){
		$code = 1001;

		if($studentId && $classId){

			if($this->role !== ROLE_SU){
				if($this->studentHasPaper($studentId))
					return $this->rs(2001, __FUNCTION__);
			}

			$rs = $this->sConn->createCommand("delete from student_class_relation where student_id = '{$studentId}' and class_id = '{$classId}'")->execute();

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function teacherAccountExists($teacherId){
		if(!$teacherId)
			return false;

		$rs = $this->conn->createCommand("select exists(select * from xb_teacher where teacher_id = '{$teacherId}')")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function delTeacher($teacherId){
		$code = 1001;

		if($teacherId){
			$code = array();

			if($this->role !== ROLE_SU){
				if($this->teacherHasBindedClass($teacherId))
					$code[] = 2001;
				if($this->teacherHasCreatedExam($teacherId))
					$code[] = 2002;
			}

			if($code)
				return $this->rs($code, __FUNCTION__);

			try{
				$trans1 = $this->sConn->beginTransaction();
				$trans2 = $this->conn->beginTransaction();

				$this->conn->createCommand("update xb_teacher set status = '2' where teacher_id = '{$teacherId}'")->execute();
				$this->sConn->createCommand("update teacher set status = '2' where teacher_id = '{$teacherId}'")->execute();
				$this->kickTeacher($teacherId);

				$trans1->commit();
				$trans2->commit();

				$rs = true;
			}
			catch(Exception $e){
				$trans1->rollBack();
				$trans2->rollBack();

				$rs = false;
			}

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function purgeTeacher($teacherId){
		$code = 1001;

		if($teacherId){
			$code = array();

			$teacherAccountExists = $this->teacherAccountExists($teacherId);

			if($this->role !== ROLE_SU && $teacherAccountExists){
				if($this->teacherHasBindedClass($teacherId))
					$code[] = 2001;
				if($this->teacherHasCreatedExam($teacherId))
					$code[] = 2002;
                if ($this->teacherHasMarkingTask($teacherId))
                    $code[] = 2003;
                if ($this->teacherHasProblemMark($teacherId))
                    $code[] = 2004;
			}

			if($code)
				return $this->rs($code, __FUNCTION__);

			try{
				$trans1 = $this->sConn->beginTransaction();
				$trans2 = $this->conn->beginTransaction();

				if($teacherAccountExists){
					$this->conn->createCommand("delete from xb_teacher where teacher_id = '{$teacherId}'")->execute();
				}
				$this->sConn->createCommand("delete from teacher where teacher_id = '{$teacherId}'")->execute();
				$this->sConn->createCommand("delete from teacher_class_relation where teacher_id = '{$teacherId}'")->execute();
				$this->kickTeacher($teacherId);

				$trans1->commit();
				$trans2->commit();

				$rs = true;
			}
			catch(Exception $e){
				$trans1->rollBack();
				$trans2->rollBack();

				$rs = false;
			}

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function getSemesters($condition = array(), $orderBy = array("start_time desc"), $offset = 0, $limit = -1){
		$condition = $this->condition($condition);
		$orderBy = $this->orderBy($orderBy);
		$limit = $this->limit($offset, $limit);

		$rs = $this->sConn->createCommand("select * from semester{$condition}{$orderBy}{$limit}")->queryAll();

		return $rs;
	}

	public function getSemestersList($condition = array(), $orderBy = array(), $pageSize = 20){
		$condition = $this->condition($condition);
		$orderBy = $this->orderBy($orderBy);

		$handle = $this->sConn->createCommand("select * from semester{$condition}{$orderBy}")->query();
		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getSemesterIdByClassId($classId){
		$semesterId = null;

		$class = $this->getClass($classId);
		if(!empty($class["semester_id"]))
			$semesterId = $class["semester_id"];

		return $semesterId;
	}

	public function getSemester($semesterId){
		$semester = array();

		if($semesterId){
			$semester = $this->sConn->createCommand("select * from semester where semester_id = '{$semesterId}'")->queryRow();
		}

		return $semester;
	}

	public function getTheYearLastSemester($year){
		if(!$year)
			return array();

		return $this->sConn->createCommand("select * from semester where school_year = '{$year}' order by start_time desc limit 1")->queryRow();
	}

	public function getCurrSemester(){
		return $this->sConn->createCommand("select * from semester where status = '1'")->queryRow();
	}
	public function isCurrentSemester($semesterId){

		$semester	=	$this->getCurrSemester();
		if($semester && $semester['semester_id']==$semesterId){
			return true;
		}
		return false;
	}
	public function getClassExamsList($classId, $orderBy = array("exam_id desc"), $pageSize = 9){
		$rs = $this->buildEmptyPagingStruct();

		if($classId){
			$orderBy = $this->orderBy($orderBy);

			$handle = $this->sConn->createCommand("
				select e.* from exam as e where e.class_id = '{$classId}' and e.semester_id = '{$this->semester["id"]}' and e.type = 2{$orderBy}
			")->query();

			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}

	public function getExamRecordsList($examId, $orderBy = array("record_id asc"), $pageSize = 9){
		$rs = array();

		if($examId){
			$orderBy = $this->orderBy($orderBy);

			$handle = $this->sConn->createCommand("
				select er.*, stu.realname
				from exam_record as er
				join student_info as stu on stu.student_id = er.student_id
				where er.exam_id = '{$examId}'
				{$orderBy}
			")->query();

			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}

	public function getExam($examId, $type = "ARR"){
		$exam = array();

		if($examId){
			$exam = $this->sConn->createCommand("select * from exam where exam_id = '{$examId}'")->queryRow();

			if($type == "OBJ"){
				$exam = Arr::toObj($exam);
			}
		}

		return $exam;
	}

	public function getExamClassId($examId){
		if($exam = $this->getExam($examId))
			return $exam["class_id"];

		return null;
	}

	public function isClassExam($classId, $examId){
		$rs = false;
		if($classId && $examId){
			$rs = $this->sConn->createCommand("select exists(select * from exam where exam_id = '{$examId}' and class_id = '{$classId}')")->queryRow();
			$rs = current($rs) ? true : false;
		}

		return $rs;
	}

	public function studentBelongsToClass($studentId, $classId){
		if($studentId && $classId){
			$rs = $this->sConn->createCommand("select exists(select * from student_info where student_id = '{$studentId}' and class_id = '{$classId}')")->queryRow();
			$rs = current($rs);
			if($rs) return true;
		}

		return false;
	}

	public function getMyClassesIds(){
		$ids = array();

		$rs = $this->sConn->createCommand("select * from class where coach_id = '{$this->coachId}'")->queryAll();
		if($rs){
			$ids = $this->grouping($rs, "class_id");
		}

		return $ids;
	}

	public function isMyClass($classId){
		if($classId){
			$myClassesIds = $this->getMyClassesIds();
			if(in_array($classId, $myClassesIds))
				return true;
		}

		return false;
	}

	public function getExamClassesIds($examId){
		$ids = array();

		if($examId){
			$rs = $this->sConn->createCommand("select * from exam where exam_id = '{$examId}'")->queryAll();
			$ids = $this->grouping($rs, "class_id");
		}

		return $ids;
	}

	public function getParentsList($orderBy = array(), $pageSize = 9){
		$handle = $this->conn->createCommand("
			select pa.*
			from student as stu
			join parent_student_relation as psr on psr.student_id = stu.student_id
			join `parent` as pa on pa.parent_id = psr.parent_id and pa.status != 2
			where stu.school_id = '{$this->schoolId}'
			group by pa.parent_id
		")->query();

		$rs = $this->paging($this->conn, $handle, $pageSize);

		return $rs;
	}

	public function delParentsStudentsRelations($parentsIds){
		if($parentsIds){
			if(!is_array($parentsIds)){
				$parentsIds = array($parentsIds);
			}

			$ids = "";
			foreach($parentsIds as $key => $val){
				$ids .= ",'{$val}'";
			}
			$ids = substr($ids, 1);

			try{
				$trans = $this->sConn->beginTransaction();
				$this->sConn->createCommand("delete from parent_student_relation where parent_id in({$ids})")->execute();
				$trans->commit();

				return true;
			}
			catch(Exception $e){
				$trans->rollBack();

				return false;
			}
		}

		return false;
	}

	public function updateParent($parentId, $parentData){
		$updateKeys = array("phone_number", "password", "realname", "sex", "age", "status", "last_login_time");
		$insertKeys = array("phone_number");

		foreach($parentData as $key => $val){
			switch($key){
				case "phone_number":
					if(!Filter::testPhoneNumber($val))
						return false;
					break;

				case "password":
					if(strlen($val) > 18)
						return false;
					$parentData[$key] = md5(sha1($val));
					break;

				case "realname":
					if(strlen($val) > 10)
						return false;
					break;

				case "sex":
					if(!in_array($val, array("0", "1", "2")))
						return false;
					break;

				case "age":
					if(!is_numeric($val) || $val < 1 || $val > 100)
						return false;
					break;

				case "status":
					if(!in_array($val, array("0", "1", "2")))
						return false;
					break;

				case "last_login_time":
					if(!is_numeric($val) || strlen($val) > 10)
						return false;
					break;

				default:
					break;
			}
		}

		if($parentId){
			$pattern = "";
			foreach($parentData as $key => $val){
				if(!in_array($key, $updateKeys))
					continue;

				$pattern .= ",`{$key}` = '{$val}'";
			}
			$pattern = substr($str, 1);

			if($pattern)
				return $this->conn->createCommand("update parent set {$pattern} where parent_id = '{$parentId}'")->execute();
		}
		else{
			$fields = "";
			$values = "";

			$keys = array();
			foreach($parentData as $key => $val){
				if(!in_array($key, $allowKeys))
					continue;

				$keys[] = $key;
				$fields .= ",`{$key}`";
				$values .= ",'{$val}'";
			}

			if(array_diff($requiredKeys, $keys))
				return false;

			$fields .= ",`signup_time`";
			$values .= ",'".time()."'";

			$fields = substr($fields, 1);
			$values = substr($values, 1);

			return $this->conn->createCommand("insert into parent({$fields}) values({$values})")->execute();
		}

		return false;
	}

	public function addParent($parentData){
		return $this->updateParent(null, $parentData);
	}

	public function getStudentInfo($studentId, $type = "ARRAY"){
		$studentInfo = array();

		if($studentId){
			$studentInfo = $this->sConn->createCommand("
				select stu.student_id, stu.realname, stu.sex, stu.family_tel, stu.telephone, stu.student_phone, stu.picture, stu.signature, stu.add_time,
					stu.update_time,stu.is_outer, scr.userno, scr.serial_number, c.class_name, c.class_id,stu.id_number,stu.field_1,stu.field_2,stu.field_3,stu.field_4,stu.field_5
				from student_info as stu
				join student_class_relation as scr on scr.student_id = stu.student_id and scr.status = 0
				join class as c on c.class_id = scr.class_id
				where stu.student_id = '{$studentId}'
			")->queryRow();
			if($type == "OBJ")
				$studentInfo = Arr::toObj($studentInfo);
		}

		return $studentInfo;
	}

	public function getStudentInfoByUsername($username){
		$studentInfo = array();

		if($username){
			$rs = $this->conn->createCommand("select * from student where username = '{$username}'")->queryAll();
			if($rs){
				$rs = current($rs);
				$studentInfo = $this->getStudentInfo($rs["student_id"]);
			}
		}

		return $studentInfo;
	}

	public function getStudentParents($studentId){
		$parents = array();

		if($studentId){
			$parents = $this->conn->createCommand("
				select pa.*, pwor.openid
				from parent_student_relation as psr
				join parent as pa on pa.parent_id = psr.parent_id
				join parent_wechat_openid_relation as pwor on pwor.parent_id = psr.parent_id
				where psr.student_id = '{$studentId}'
				group by pa.parent_id
				limit 0, 10
			")->queryAll();
		}

		return $parents;
	}

	public function insertExamRecord($recordData, $xls){
		if((empty($recordData["exam_id"]) && !isset($_FILES)) || empty($recordData["name"]) || empty($recordData["class_id"]))
			return false;

		$time = time();

		if(isset($xls["error"]) && $xls["error"] == 0){
			$xls = $xls["file"];
			$excel = new Excel();
			$sheetData = $excel->read($xls);
			$studentsCount = 0;

			$students = array();
			$studentsIds = array();
			$notExistStudents = array();
			$notExistStudentsCount = 0;
			$incomplete = array();
			$incompleteCount = 0;
			$notBelongsToClass = array();
			$notBelongsToClassCount = 0;
			$studentsExist = array();
			$studentsExistCount = 0;

			foreach($sheetData as $key => $val){
				$chinese = $val["B"];
				$math = $val["C"];
				$english = $val["D"];
				$physics = $val["E"];
				$chemistry = $val["F"];
				$biology = $val["G"];
				$politics = $val["H"];
				$history = $val["I"];
				$geography = $val["J"];
				$classRank = $val["K"];
				$gradeRank = $val["L"];
				if(Str::isBlank($chinese) && Str::isBlank($math)&& Str::isBlank($english)&& Str::isBlank($physics)&& Str::isBlank($chemistry)&& Str::isBlank($biology)&& Str::isBlank($politics)&& Str::isBlank($history)&& Str::isBlank($geography)&& Str::isBlank($classRank)&& Str::isBlank($gradeRank)){
					continue;
				}

				if(Str::isBlank($chinese) || Str::isBlank($math)|| Str::isBlank($english)|| Str::isBlank($physics)|| Str::isBlank($chemistry)|| Str::isBlank($biology)|| Str::isBlank($politics)|| Str::isBlank($history)|| Str::isBlank($geography)|| Str::isBlank($classRank)|| Str::isBlank($gradeRank)){
					$studentsCount++;
					$incompleteCount++;
					continue;
				}

				$studentsCount++;

				$username = (string)$val["A"];
				$studentInfo = $this->getStudentInfoByUsername($username);
				$studentId = $studentInfo ? $studentInfo["student_id"] : null;
				if(!$studentId){
					$notExistStudents[] = $username;
					$notExistStudentsCount++;
					continue;
				}

				if(!$this->studentBelongsToClass($studentId, $recordData["class_id"])){
					$notBelongsToClass[] = $username;
					$notBelongsToClassCount++;
					continue;
				}

				if(in_array($studentId, $studentsIds)){
					$studentsExist[] = $username;
					$studentsExistCount++;
					continue;
				}

				$studentsIds[] = $studentId;

				$chinese = is_numeric($val["B"]) && $val["B"] ? $val["B"] : 0;
				$math = is_numeric($val["C"]) && $val["C"] ? $val["C"] : 0;
				$english = is_numeric($val["D"]) && $val["D"] ? $val["D"] : 0;
				$physics = is_numeric($val["E"]) && $val["E"] ? $val["E"] : 0;
				$chemistry = is_numeric($val["F"]) && $val["F"] ? $val["F"] : 0;
				$biology = is_numeric($val["G"]) && $val["G"] ? $val["G"] : 0;
				$politics = is_numeric($val["H"]) && $val["H"] ? $val["H"] : 0;
				$history = is_numeric($val["I"]) && $val["I"] ? $val["I"] : 0;
				$geography = is_numeric($val["J"]) && $val["J"] ? $val["J"] : 0;
				$classRank = is_numeric($val["K"]) && $val["K"] ? $val["K"] : 0;
				$gradeRank = is_numeric($val["L"]) && $val["L"] ? $val["L"] : 0;

				$totalScore = $chinese + $math + $english + $physics + $chemistry + $biology + $politics + $history + $geography;

				$students[$studentId]["student_id"] = $studentId;
				$students[$studentId]["subject_chinese"] = $chinese;
				$students[$studentId]["subject_math"] = $math;
				$students[$studentId]["subject_english"] = $english;
				$students[$studentId]["subject_physics"] = $physics;
				$students[$studentId]["subject_chemistry"] = $chemistry;
				$students[$studentId]["subject_biology"] = $biology;
				$students[$studentId]["subject_history"] = $history;
				$students[$studentId]["subject_politics"] = $politics;
				$students[$studentId]["subject_geography"] = $geography;
				$students[$studentId]["total_score"] = $totalScore;
				$students[$studentId]["class_rank"] = $classRank;
				$students[$studentId]["grade_rank"] = $gradeRank;
			}
			$failedCount = $notExistStudentsCount + $incompleteCount + $notBelongsToClassCount + $studentsExistCount;
			$successCount = $studentsCount - $failedCount;
			$result["global"]["msg"] = "从Excel读取了{$studentsCount}条记录，其中{$successCount}导入成功，{$failedCount}条导入失败";
			$result["errors"][0]["type"] = "数据信息不完整";
			$result["errors"][0]["count"] = $incompleteCount;
			$result["errors"][0]["msg"] = "共有{$incompleteCount}行数据不完整，请检查";
			$result["errors"][1]["type"] = "不存在该用户名的学生";
			$result["errors"][1]["count"] = $notExistStudentsCount;
			$notExistStudents = implode(",", $notExistStudents);
			$result["errors"][1]["msg"] = "用户名为{$notExistStudents}的学生无法导入";
			$result["errors"][2]["type"] = "该学生不属于本班级";
			$result["errors"][2]["count"] = $notBelongsToClassCount;
			$notBelongsToClass = implode(",", $notBelongsToClass);
			$result["errors"][2]["msg"] = "用户名为{$notBelongsToClass}的学生无法导入";
			$result["errors"][3]["type"] = "表格中有重复的学生";
			$result["errors"][3]["count"] = $studentsExistCount;
			$studentsExist = implode(",", $studentsExist);
			$result["errors"][3]["msg"] = "用户名为{$studentsExist}的学生无法导入";

			if($failedCount == $studentsCount){
				$result["global"]["result"] = "失败";
				return $result;
			}
			else if($successCount == $studentsCount){
				$result["global"]["result"] = "全部成功";
				unset($result["errors"][0]);
			}
			else{
				$result["global"]["result"] = "部分成功";
			}

			$fields = "";
			$values = array();
			if($students){
				if(!empty($recordData["exam_id"]))
					$examId = $recordData["exam_id"];
				else{
//					$uuid = $this->sConn->createCommand("select RIGHT(UUID_SHORT(), 20)")->queryAll();
//					$examId = current(current($uuid));
                    $examId=getUniqueId($this->schoolId);
				}

				$student = current($students);
				foreach($student as $key => $val){
					$fields .= ",`{$key}`";
				}
				$fields .= ",`record_id`";
				$fields .= ",`exam_id`";
				$fields .= ",`coach_id`";
				$fields .= ",`add_time`";
				$fields = "(".substr($fields, 1).")";

				foreach($students as $studentId => $student){
					$values[$studentId] = "";
					foreach($student as $key => $val){
						$values[$studentId] .= ",'{$val}'";
					}
                    $uuid=getUniqueId($this->schoolId);
					$values[$studentId] .= ",'{$uuid}'";
					$values[$studentId] .= ",'{$examId}'";
					$values[$studentId] .= ",'{$this->coachId}'";
					$values[$studentId] .= ",'{$time}'";
					$values[$studentId] = "(".substr($values[$studentId], 1).")";
				}

				if($values){
					$values = implode(",", $values);
					$sql = "insert into exam_record{$fields} values{$values}";
				}
				else{
					$sql = "";
				}


				try{
					$trans = $this->sConn->beginTransaction();
					if(isset($recordData["exam_id"]) && $recordData["exam_id"]){
						if(isset($recordData["name"]) && $recordData["name"])
							$this->sConn->createCommand("update exam set name = '{$recordData["name"]}' where exam_id = '{$recordData["exam_id"]}'")->execute();

						if($sql){
							$this->sConn->createCommand("delete from exam_record where exam_id = '{$examId}'")->execute();
							$this->sConn->createCommand($sql)->execute();
						}
					}
					else if($sql){
						$this->sConn->createCommand("
							insert into exam(`exam_id`, `class_id`, `name`, semester_id, `type`, `status`, `create_time`)
							values('{$examId}', '{$recordData["class_id"]}', '{$recordData["name"]}', '{$this->semester["id"]}', 2, 2, '{$time}')
						")->execute();

						$this->sConn->createCommand($sql)->execute();
					}

					$trans->commit();
					if($students){
						foreach($students as $student){
							if($parents = $this->getStudentParents($student["student_id"])){
								$student = $this->getStudentInfo($student["student_id"]);
								$studentName = $student ? $student["realname"] : "";
								$msg = "您的孩子{$studentName}综合排名有了新的数据, 点击查看";
								$redirectionPath = "home/examrecord?studentId={$student["student_id"]}";

								foreach($parents as $parent){
									$this->writeParentNotification($parent["parent_id"], $msg, 1, $redirectionPath);
									if($parent["openid"])
										send_weixin($parent["openid"], $msg, $this->parentNotificationHost."/home/examrecord?studentId={$student["student_id"]}");
								}
							}
						}
					}

					return $result;
				}
				catch(Exception $e){
					$trans->rollBack();
					return false;
				}
			}
			else if(isset($recordData["name"]) && $recordData["name"] && isset($recordData["exam_id"]) && $recordData["exam_id"])
				return $this->sConn->createCommand("update exam set name = '{$recordData["name"]}' where exam_id = '{$recordData["exam_id"]}'")->execute();

			return false;
		}
		else if(isset($recordData["name"]) && $recordData["name"] && isset($recordData["exam_id"]) && $recordData["exam_id"]){
			return $this->sConn->createCommand("update exam set name = '{$recordData["name"]}' where exam_id = '{$recordData["exam_id"]}'")->execute();
		}

		return false;
	}

	public function getOrdersList($orderBy = array(), $pageSize = 9){
		$orderBy = $this->orderBy($orderBy);

		$handle = $this->conn->createCommand("
			select ord.*
			from order_school_relation as osr
			join `order` as ord on ord.order_id = osr.order_id
			where osr.school_id = '{$this->schoolId}'
			{$orderBy}
		")->query();

		$rs = $this->paging($this->conn, $handle, $pageSize);

		return $rs;
	}

	public function writeParentNotification($parentId, $content, $type = null, $redirectionPath = ""){
		if($parentId && $content){
			$time = time();
			$fields = "`parent_id`, `content`, `time`";
			$values = "'{$parentId}', '{$content}', '{$time}'";
			if($type){
				$fields .= ", `type`";
				$values .= ", '{$type}'";

				if($type == 1 && $redirectionPath){
					$fields .= ",`redirection_path`";
					$values .= ",'{$redirectionPath}'";
				}
			}

			$sql = "insert into parent_notification({$fields}) values({$values})";
			return $this->conn->createCommand($sql)->execute();
		}

		return false;
	}

	public function getClassStudentsList($classId, $condition = array(), $pageSize = 9, $type = "OBJ"){
		$rs = $this->buildEmptyPagingStruct();

		if($classId){

			$condition = Arr::merge(array("scr.class_id = '{$classId}'", "scr.status = 0"), $condition);
			$condition = $this->condition($condition);

			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.grade,c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}
				order by serial_number asc
			")->query();
			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}
	public function getInClassStudentsList($classId, $condition = array(), $pageSize = 9, $type = "OBJ"){
		$rs = $this->buildEmptyPagingStruct();

		if($classId){
			$condition = Arr::merge(array("scr.class_id in( ".implode(',',$classId).")", "scr.status = 0"), $condition);
			$condition = $this->condition($condition);
			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.grade,c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}

				order by serial_number asc
			")->query();
			$rs = $this->paging($this->sConn, $handle, $pageSize);
		}

		return $rs;
	}
	public function getStudents($studentsIds = array()){
		$students = array();

		if($studentsIds){
			$studentsIds = "'".implode("','", $studentsIds)."'";
			$students = $this->sConn->createCommand("
				select stu.*, scr.serial_number, scr.userno
				from student_info as stu
				left join student_class_relation as scr on scr.student_id = stu.student_id and scr.status = 0
				where stu.student_id in({$studentsIds})
				order by serial_number asc
			")->queryAll();
		}

		return $students;
	}

	public function getClassStudents($classId, $condition = array(), $type = "OBJ"){
		$students = array();

		if($classId){
			$condition = Arr::merge(array("scr.class_id = '{$classId}'", "scr.status = 0"), $condition);
			$condition = $this->condition($condition);
			$students = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}
				order by serial_number asc
			")->queryAll();
		}
		if($type == "OBJ")
			$students = Arr::toObj($students);

		return $students;
	}

	public function getClassStudentsListWithAccounts1($classId, $condition = array(), $pageSize = 9,$where=''){
			$student_ids	=	array();
		if(empty($where))
		{
			if(is_array($classId)){
				$rs = $this->getInClassStudentsList($classId, $condition, $pageSize, "ARR");
			}else{
				$rs = $this->getClassStudentsList($classId, $condition, $pageSize, "ARR");
			}
		}else
		{

			$accounts = $this->conn->createCommand("select * from student where ".$where)->queryRow();
			if($accounts)
			{
				$condition=	array("stu.student_id=" . $accounts['student_id']);

				if(is_array($classId)){
					$rs = $this->getInClassStudentsList($classId, $condition, $pageSize, "ARR");
				}else{
					$rs = $this->getClassStudentsList($classId, $condition, $pageSize, "ARR");
				}

			}else
			{
				$rs["rs"] =array();
				$rs['pager'] = (object)array();
				$rs['pager']->rowsCount	=	0;
			}


		}



		if($rs["rs"]){
			foreach($rs["rs"] as $key => $val){
				$rs["rs"][$key]["username"] = "";
				$rs["rs"][$key]["status"] = null;
			}

			$studentsIds = $this->grouping($rs["rs"], "student_id");
			$studentsIds = implode("','", $studentsIds);
			$studentsIds = "'{$studentsIds}'";
			if($where)
			{
				$accounts = $this->conn->createCommand("select * from student where ".$where)->queryAll();

				if($accounts){
					foreach($accounts as $account){
						foreach($rs["rs"] as $key => $val){

							if($val["student_id"] && $val["student_id"] == $account["student_id"]){
								$rs["rs"][$key]["username"] 	= $account["username"];
								$rs["rs"][$key]["student_card"] = $account["student_card"];
								$rs["rs"][$key]["school_student_card"] = $account["school_student_card"];
								if(isset($account["zhixue_student_card"]))
								{
									$rs["rs"][$key]["zhixue_student_card"] = $account["zhixue_student_card"];
								}

								$rs["rs"][$key]["status"] 		= $account["status"];
							}else
							{
								unset($rs["rs"][$key]);
								$rs['pager']->rowsCount = 0;
							}
						}
					}
				}else
				{
					foreach($rs["rs"] as $key => $val){

						unset($rs["rs"][$key]);
					}
					$rs['pager']->rowsCount = 0;
				}
			}else
			{
				$accounts = $this->conn->createCommand("select * from student where student_id in({$studentsIds})")->queryAll();
				if($accounts){
					foreach($accounts as $account){
						foreach($rs["rs"] as $key => $val){
							if($val["student_id"] && $val["student_id"] == $account["student_id"]){
								$rs["rs"][$key]["username"] 	= $account["username"];
								$rs["rs"][$key]["student_card"] = $account["student_card"];
								$rs["rs"][$key]["school_student_card"] = $account["school_student_card"];
								if(isset($account["zhixue_student_card"]))
								{
									$rs["rs"][$key]["zhixue_student_card"] = $account["zhixue_student_card"];
								}

								$rs["rs"][$key]["status"] 		= $account["status"];
							}
						}
					}
				}


			}


		}

		return $rs;
	}
	public function getClassStudentsListWithAccounts($classId, $condition = array(), $pageSize = 9,$where=''){
		$student_ids	=	array();
		if(empty($where))
		{
			if(is_array($classId)){
				$rs = $this->getInClassStudentsList($classId, $condition, $pageSize, "ARR");
			}else{
				$rs = $this->getClassStudentsList($classId, $condition, $pageSize, "ARR");
			}
		}else
		{

            $accounts = $this->conn->createCommand("select * from student where ".$where)->queryAll();
            if($accounts)
            {
                $studentIdOr=array();
                foreach ($accounts as $v){
                    $studentIdOr[]=" stu.student_id=" . $v['student_id']." ";
                }
                $condition=	array(" (".implode(' OR ',$studentIdOr).") ","c.class_type=1");

                if(is_array($classId)){
                    $rs = $this->getInClassStudentsList($classId, $condition, $pageSize, "ARR");
                }else{
                    $rs = $this->getClassStudentsList($classId, $condition, $pageSize, "ARR");
                }

            }else
			{
				$rs["rs"] =array();
				$rs['pager'] = (object)array();
				$rs['pager']->rowsCount	=	0;
			}


		}

        //debug($rs["rs"]);

		if($rs["rs"]){
			foreach($rs["rs"] as $key => $val){
				$rs["rs"][$key]["username"] = "";
				$rs["rs"][$key]["status"] = null;
			}

			$studentsIds = $this->grouping($rs["rs"], "student_id");
			$studentsIds = implode("','", $studentsIds);
			$studentsIds = "'{$studentsIds}'";
			if($where)
			{

				$accounts = $this->conn->createCommand("select * from student where ".$where)->queryAll();

				if($accounts){

					$b_student_status = array();
					$b_student_card = array();
					$b_student_username = array();
					$b_school_student_card = array();
					$b_zhixue_student_card = array();
					foreach($accounts as $v)
					{
						$b_student_card[$v['student_id']]	=	$v['student_card'];
						$b_student_status[$v['student_id']]	=	$v['status'];
						$b_student_username[$v['student_id']]	=	$v['username'];
						$b_school_student_card[$v['student_id']]	=	$v['school_student_card'];
						$b_zhixue_student_card[$v['student_id']]	=	$v['zhixue_student_card'];
					}

					foreach($rs["rs"] as $key => $val){
						if( isset($b_student_card[$val["student_id"]]) && !empty($b_student_card[$val["student_id"]])){
							$rs["rs"][$key]["username"] 	= $b_student_username[$val["student_id"]];
							$rs["rs"][$key]["student_card"] = $b_student_card[$val["student_id"]];
							$rs["rs"][$key]["school_student_card"] = $b_school_student_card[$val["student_id"]];
							if(isset($b_zhixue_student_card[$val["student_id"]]))
							{
								$rs["rs"][$key]["zhixue_student_card"] = $b_zhixue_student_card[$val["student_id"]];
							}

							$rs["rs"][$key]["status"] 		= $b_student_status[$val["student_id"]];
						}else
						{
							unset($rs["rs"][$key]);
							$rs['pager']->rowsCount = 0;
						}
					}

				}else
				{
					foreach($rs["rs"] as $key => $val){

						unset($rs["rs"][$key]);
					}
					$rs['pager']->rowsCount = 0;
				}
			}else
			{

				$accounts = $this->conn->createCommand("select * from student where student_id in ({$studentsIds})")->queryAll();
				if($accounts){
					$b_student_status = array();
					$b_student_card = array();
					$b_student_username = array();
					$b_school_student_card = array();
					$b_zhixue_student_card = array();
					foreach($accounts as $v)
					{
						$b_student_card[$v['student_id']]	=	$v['student_card'];
						$b_student_status[$v['student_id']]	=	$v['status'];
						$b_student_username[$v['student_id']]	=	$v['username'];
						$b_school_student_card[$v['student_id']]	=	$v['school_student_card'];
						$b_zhixue_student_card[$v['student_id']]	=	$v['zhixue_student_card'];
					}

					foreach($rs["rs"] as $key => $val){
						if( isset($b_student_card[$val["student_id"]]) && !empty($b_student_card[$val["student_id"]])){
							$rs["rs"][$key]["username"] 	= $b_student_username[$val["student_id"]];
							$rs["rs"][$key]["student_card"] = $b_student_card[$val["student_id"]];
							$rs["rs"][$key]["school_student_card"] = $b_school_student_card[$val["student_id"]];
							if(isset($b_zhixue_student_card[$val["student_id"]]))
							{
								$rs["rs"][$key]["zhixue_student_card"] = $b_zhixue_student_card[$val["student_id"]];
							}

							$rs["rs"][$key]["status"] 		= $b_student_status[$val["student_id"]];
						}
					}

				}


			}


		}

		return $rs;
	}

	public function classExamHasPaperRs($examId, $classId){
		if($examId){
			$rs = $this->sConn->createCommand("
				select exists(
					select *
					from exam as e
					join paper as p on p.exam_id = e.exam_id and p.paper_type = 1
					join student_paper_relation as spr on spr.paper_id = p.paper_id and spr.class_id = '{$classId}'
					join student_info as stu on stu.student_id = spr.student_id
					join student_class_relation as scr on scr.student_id = stu.student_id and scr.class_id = '{$classId}'
					where e.exam_id = '{$examId}' and (spr.scoring > 0 or spr.lost_score > 0) and spr.is_del=0
				)
			")->queryRow();
			$rs = current($rs);

			if($rs) return true;
		}

		return false;
	}

	public function isPreviousSemester($semesterId){
		if(($semester = $this->getSemester($semesterId)) && ($currSemester = $this->getCurrSemester())){
			if($semester["start_time"] < $currSemester["start_time"])
				return true;
		}

		return false;
	}

	public function isFutureSemester($semesterId){
		return !$this->isCurrentSemester($semesterId) && !$this->isPreviousSemester($semesterId) ? true : false;
	}

	public function kickTeacher($teacherId){
		if($teacherId){
			return Redist::del(Yii::app()->session->sessionID);
		}

		return false;
	}

	public function teacherPhoneNumberExists($phoneNumber){
		if($phoneNumber){
			$count = $this->conn->createCommand("select exists(select * from xb_teacher where phone_number = '{$phoneNumber}')")->queryRow();
			$count = current($count);
			return $count ? true : false;
		}

		return false;
	}

	public function getExamRsByClass($examId, $classId, $orderBy = array(), $type = ""){
		if(!$orderBy)
			$orderBy = array("--scr.serial_number asc", "stu.realname asc");
		$orderBy = $this->orderBy($orderBy);

		$rs = $this->sConn->createCommand("
			select stu.student_id, stu.realname, stu.sex, stu.class_id, scr.userno, scr.serial_number, e.exam_id as exam_id, e.name as exam_name, p.paper_name,
				spr.scoring, p.score, p.paper_id, spr.wrong_count, spr.partial_right_count
			from exam as e
			join paper as p on p.exam_id = e.exam_id and p.paper_type = 1
			join student_paper_relation as spr on spr.paper_id = p.paper_id and spr.class_id = '{$classId}'
			join student_info as stu on stu.student_id = spr.student_id
			join student_class_relation as scr on scr.student_id = stu.student_id and scr.class_id = '{$classId}'
			where e.exam_id = '{$examId}' and spr.is_del=0
			{$orderBy}
		")->queryAll();

		if($rs){
			Arr::sortByField($rs, "scoring", "DESC");
			$previousRecord = 0;
			$previousRank = 1;
			foreach($rs as $key => $val){
				if($val["scoring"] && $val["score"]){
					$rs[$key]["right_rate"] = $val["scoring"] / $val["score"];
					$rs[$key]["right_rate"] = sprintf("%.2f", $rs[$key]["right_rate"]);
				}
				else
					$rs[$key]["right_rate"] = 0;

				if($val["scoring"] && $val["score"]){
					$rs[$key]["scoring_rate"] = $val["scoring"] / $val["score"];
					$rs[$key]["scoring_rate"] = sprintf("%.2f", $rs[$key]["scoring_rate"]);
				}
				else
					$rs[$key]["scoring_rate"] = 0;

				$rs[$key]["wrong_count"] = $val["wrong_count"] + $val["partial_right_count"];

				if($val["scoring"] == $previousRecord){
					$rs[$key]["rank"] = $previousRank;
				}
				else{
					$rs[$key]["rank"] = $key + 1;
				}
				$previousRecord = $val["scoring"];
				$previousRank = $rs[$key]["rank"];
			}

			Arr::sortByField($rs, "serial_number");
		}

		if($type === "EXCEL"){
			$array = array();
			foreach($rs as $key => $val){
				$array[$key] = array(
					$val["serial_number"],
					$val["realname"],
					$val['exam_name'] . ($val["paper_name"] ? ' '.$val['paper_name'] : ''),
					$val["scoring"],
					$val["score"],
					($val["scoring_rate"] * 100)."%",
					$val["rank"],
					$val["wrong_count"],
				);
			}
			$title = array("编号",	"姓名", "试卷", "得分", "总分", "得分率", "班级名次", "错题");
			array_unshift($array, $title);
			$rs = $array;
		}

		return $rs;
	}

	public function serialNumberExistsInClass($serialNumber, $classId, $studentId = null){
		if($serialNumber && $classId){
			$condition = array("class_id = '{$classId}'", "serial_number = '{$serialNumber}'", "status = 0");
			if($studentId)
				$condition = Arr::merge($condition, array("student_id != '{$studentId}'"));
			$condition = $this->condition($condition);

			$rs = $this->sConn->createCommand("select exists(select * from student_class_relation{$condition})")->queryRow();

			$rs = current($rs);

			return $rs ? true : false;
		}

		return false;
	}

	public function getPrintTask($examId, $classId, $type){
		if(!$examId || !$classId || !is_numeric($type))
			return array();

		return $this->sConn->createCommand("select * from class_exam_printer where exam_id = '{$examId}' and class_id = '{$classId}' and `type` = '{$type}'")->queryRow();
	}

        //获取班级多个考试
        public function getClassExamAc($condition = array(), $orderBy = array("add_time desc")){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$handle = $this->sConn->createCommand("
			select e.is_academicr_pdf,e.academicr_pdf_path,e.is_topwb_pdf,e.is_new,e.is_topwb_html,cep.*, c.class_name, csr.subject_id, e.name as exam_name, e.upload_status, e.create_time,e.exam_group_id, e.is_display,e.complete_time,e.is_topwb_pdf,e.topwb_pdf_path,e.topwb_pdf_time,e.is_academicr_pdf, eg.mark_type, eg.mark_status,eg.upload_status as group_upload_status,
				p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->queryAll();

                return $handle;
        }

	public function getPrintListre($condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);

		$handle = $this->sConn->createCommand("
			select e.is_academicr_pdf,e.academicr_pdf_path,e.is_topwb_pdf,e.is_new,e.is_fine_paper,e.is_topwb_html,cep.*, c.class_name, csr.subject_id, e.name as exam_name, e.tpl_index, e.tpl_data, e.upload_status, e.create_time,e.exam_group_id, e.is_display,e.complete_time,e.is_topwb_pdf,e.topwb_pdf_path,e.topwb_pdf_time,e.is_academicr_pdf, eg.mark_type, eg.mark_status,eg.upload_status as group_upload_status,
				p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id,eg.is_third,c.grade,e.status,eg.is_tagging,eg.qxk_paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf from student_paper_relation where exam_id in({$examsIds}) ")->queryAll();

		$examsSprs = array();
		foreach($sprs as $key => $val){
			if(!isset($examsSprs[$val["exam_id"]]))
				$examsSprs[$val["exam_id"]] = array();

			$examsSprs[$val["exam_id"]][] = $val;
		}

		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1){
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}



				$examsStudentsCount[$examId]["is_uploaded_count"]++;

				if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}


				if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


				if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}

			}
		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
				$rs["rs"][$key]["wrongbook_pdf_count"] = 0;
				$rs["rs"][$key]["wbisp_pdf_count"] = 0;
				$rs["rs"][$key]["isp_pdf_count"] = 0;
			}

			$tplData = json_decode($val["tpl_data"], true);
			$paperSize = null;
			$examDate = null;

			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "12":
						$paperSize = "A3";
						break;

					case "13":
						$paperSize = "A4";
						break;

					case "14":
						$paperSize = "8K";
						break;

					case "15":
						$paperSize = "16K";
						break;
					case "2012":
						$paperSize = "A3";
						break;
					case "2013":
						$paperSize = "A4";
						break;
					case "2014":
						$paperSize = "8K";
						break;
					case "2015":
						$paperSize = "16K";
						break;
					case "2016":
						$paperSize = "A3";
						break;
					case "2017":
						$paperSize = "A4";
						break;
					case "2018":
						$paperSize = "8K";
						break;
					case "2019":
						$paperSize = "16K";
						break;
					case "1012":
						$paperSize = "A3";
						break;
					case "1013":
						$paperSize = "A4";
						break;
					case "1014":
						$paperSize = "8K";
						break;
					case "1015":
						$paperSize = "16K";
						break;
					case "1016":
						$paperSize = "A3";
						break;
					case "1017":
						$paperSize = "A4";
						break;
					case "1018":
						$paperSize = "8K";
						break;
					case "1019":
						$paperSize = "16K";
						break;
					case "3012":
						$paperSize = "A3";
						break;
					case "3016":
						$paperSize = "A3";
						break;
				}
			}

			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "16":
						$paperSize = "A3";
						break;
					case "3016":
						$paperSize = "A3";
						break;
					case "3007":
						$paperSize = "A3";
						break;
					case "3012":
						$paperSize = "A3";
						break;
					case "17":
						$paperSize = "A4";
						break;

					case "18":
						$paperSize = "8K";
						break;

					case "19":
						$paperSize = "16K";
						break;
				}
			}
			if($tplData){
				if(!isset($tplData["examDate"]) || !($examDate = strtotime($tplData["examDate"])))
					$examDate = $val["create_time"];

				if($paperSize === null && isset($tplData["paper"]) && $tplData["paper"] == 1)
					$paperSize = "A3";
                                
                            $rs["rs"][$key]["topic_count"] = isset($tplData['totals'])?$tplData['totals']:0;   
			}

			if($examDate === null)
				$examDate = $val["create_time"];
			if($paperSize === null)
				$paperSize = "A4";

			$time = time();
			$expireTime = $examDate + (3600 * 24 * 2);

			if($time > $expireTime){
				$rs["rs"][$key]["is_expired"] = true;
			}
			else{
				$rs["rs"][$key]["is_expired"] = false;
			}

			$rs["rs"][$key]["exam_time"] = $examDate;
			$rs["rs"][$key]["paper_size"] = $paperSize;
		}

		return $rs;
	}

        //获取下载班级
        public function getDownloadClassWb($condition = array(), $orderBy = array("add_time desc")){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$rs['rs'] = $this->sConn->createCommand("
			select cep.*, c.class_name, csr.subject_id, e.name as exam_name,e.is_new,  e.upload_status, e.create_time, e.is_display,eg.upload_status as group_upload_status, eg.mark_type, eg.mark_status,e.exam_group_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->queryAll();


		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf from student_paper_relation where exam_id in({$examsIds}) and is_del=0")->queryAll();

		$examsSprs = array();
		foreach($sprs as $key => $val){
                    if(!isset($examsSprs[$val["exam_id"]]))
                            $examsSprs[$val["exam_id"]] = array();

                    $examsSprs[$val["exam_id"]][] = $val;
		}

		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1)
				{
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}


				if($v["is_feedback"] == 1)
				{
					$examsStudentsCount[$examId]["is_uploaded_count"]++;
				}


                if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}

                if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


                if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}
			}
		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
                $rs["rs"][$key]["wrongbook_pdf_count"] = 0;
                $rs["rs"][$key]["wbisp_pdf_count"] = 0;
                $rs["rs"][$key]["isp_pdf_count"] = 0;
			}
                }
                return $rs["rs"];
        }


	public function getPrintList($condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$handle = $this->sConn->createCommand("
			select cep.*, c.class_name, csr.subject_id, e.name as exam_name,e.is_new, e.tpl_index, e.tpl_data, e.upload_status, e.create_time, e.is_display,eg.upload_status as group_upload_status, eg.mark_type, eg.mark_status,e.exam_group_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf from student_paper_relation where exam_id in({$examsIds}) and is_del=0")->queryAll();

		$examsSprs = array();
		foreach($sprs as $key => $val){
			if(!isset($examsSprs[$val["exam_id"]]))
				$examsSprs[$val["exam_id"]] = array();

			$examsSprs[$val["exam_id"]][] = $val;
		}

		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1)
				{
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}


				if($v["is_feedback"] == 1)
				{
					$examsStudentsCount[$examId]["is_uploaded_count"]++;
				}


                if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}

                if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


                if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}
			}
		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
                $rs["rs"][$key]["wrongbook_pdf_count"] = 0;
                $rs["rs"][$key]["wbisp_pdf_count"] = 0;
                $rs["rs"][$key]["isp_pdf_count"] = 0;
			}

			$tplData = json_decode($val["tpl_data"], true);
			$paperSize = null;
			$examDate = null;

			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "12":
						$paperSize = "A3";
						break;

					case "13":
						$paperSize = "A4";
						break;

					case "14":
						$paperSize = "8K";
						break;

					case "15":
						$paperSize = "16K";
						break;
					case "2012":
						$paperSize = "A3";
						break;
					case "2013":
						$paperSize = "A4";
						break;
					case "2014":
						$paperSize = "8K";
						break;
					case "2015":
						$paperSize = "16K";
						break;
					case "2016":
						$paperSize = "A3";
						break;
					case "2017":
						$paperSize = "A4";
						break;
					case "2018":
						$paperSize = "8K";
						break;
					case "2019":
						$paperSize = "16K";
						break;
					case "1012":
						$paperSize = "A3";
						break;
					case "1013":
						$paperSize = "A4";
						break;
					case "1014":
						$paperSize = "8K";
						break;
					case "1015":
						$paperSize = "16K";
						break;
					case "1016":
						$paperSize = "A3";
						break;
					case "1017":
						$paperSize = "A4";
						break;
					case "1018":
						$paperSize = "8K";
						break;
					case "1019":
						$paperSize = "16K";
						break;
					case "3016":
						$paperSize = "A3";
						break;
					case "3012":
						$paperSize = "A3";
						break;
					case "3013":
						$paperSize = "A4";
						break;
					case "3017":
						$paperSize = "A4";
						break;
				}
			}
			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "16":
						$paperSize = "A3";
						break;
					case "3016":
						$paperSize = "A3";
						break;
					case "3017":
						$paperSize = "A4";
						break;
					case "3013":
						$paperSize = "A4";
						break;
					case "3007":
						$paperSize = "A3";
						break;
					case "17":
						$paperSize = "A4";
						break;

					case "18":
						$paperSize = "8K";
						break;

					case "19":
						$paperSize = "16K";
						break;
				}
			}

			if($tplData){
				if(!isset($tplData["examDate"]) || !($examDate = strtotime($tplData["examDate"])))
					$examDate = $val["create_time"];

				if($paperSize === null && isset($tplData["paper"]) && $tplData["paper"] == 1)
					$paperSize = "A3";
			}

			if($examDate === null)
				$examDate = $val["create_time"];
			if($paperSize === null)
				$paperSize = "A4";

			$time = time();
			$expireTime = $examDate + (3600 * 24 * 2);

			if($time > $expireTime){
				$rs["rs"][$key]["is_expired"] = true;
			}
			else{
				$rs["rs"][$key]["is_expired"] = false;
			}

			$rs["rs"][$key]["exam_time"] = $examDate;
			$rs["rs"][$key]["paper_size"] = $paperSize;
		}

		return $rs;
	}
	public function getExamList($condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$handle = $this->sConn->createCommand("
			select c.class_name,e.exam_id,eg.exam_group_id,e.class_id, csr.subject_id, e.name as exam_name,e.is_new, e.tpl_index, e.tpl_data, e.upload_status, e.create_time, e.is_display, e.status, eg.mark_type, eg.mark_status,
				p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id,eg.import_score_type
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by e.class_id, e.exam_id, e.`type`
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select paper_id,exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf,student_img_paper from student_paper_relation where exam_id in({$examsIds}) and is_del=0")->queryAll();

		$examsSprs = array();
		$paperExamIds=array();
		foreach($sprs as $key => $val){
			if(!isset($examsSprs[$val["exam_id"]]))
				$examsSprs[$val["exam_id"]] = array();

			$examsSprs[$val["exam_id"]][] = $val;
            $paperExamIds[$val["exam_id"]]=$val["paper_id"];
		}
        $importScoretype=$this->grouping($rs["rs"], "import_score_type", true);
        //判断上传成绩方式
        $student_answer_img_num=array();

        //导入方式，读取实际上传数量
        foreach($paperExamIds as $eid =>$paperId){
            $student_answer_img_num[$eid]=$this->getUpAnswerStudent($paperId,array(),true);
        }


		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"student_img_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
                'student_img_up_num'
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1)
				{
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}


				if($v["is_feedback"] == 1)
				{
					$examsStudentsCount[$examId]["is_uploaded_count"]++;
				}


                if(trim($v["student_img_paper"]))
                {
                    $examsStudentsCount[$examId]["student_img_count"]++;
                }

				if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}

				if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


				if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}
			}
			if(isset($student_answer_img_num[$examId])){
                $examsStudentsCount[$examId]["student_img_up_num"]=$student_answer_img_num[$examId];
            }else{
                $examsStudentsCount[$examId]["student_img_up_num"]=0;
            }


		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["student_img_count"] = $examsStudentsCount[$val["exam_id"]]["student_img_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
                $rs["rs"][$key]["student_img_up_num"] = $examsStudentsCount[$val["exam_id"]]["student_img_up_num"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
				$rs["rs"][$key]["student_img_count"] = 0;
				$rs["rs"][$key]["wrongbook_pdf_count"] = 0;
				$rs["rs"][$key]["wbisp_pdf_count"] = 0;
				$rs["rs"][$key]["isp_pdf_count"] = 0;
                $rs["rs"][$key]["student_img_up_num"] = 0;
			}

			$tplData = json_decode($val["tpl_data"], true);
			$paperSize = null;
			$examDate = null;



			if($tplData){
				if(!isset($tplData["examDate"]) || !($examDate = strtotime($tplData["examDate"])))
					$examDate = $val["create_time"];

				if($paperSize === null && isset($tplData["paper"]) && $tplData["paper"] == 1)
					$paperSize = "A3";
			}

			if($examDate === null)
				$examDate = $val["create_time"];
			if($paperSize === null)
				$paperSize = "A4";

			$time = time();
			$expireTime = $examDate + (3600 * 24 * 2);

			if($time > $expireTime){
				$rs["rs"][$key]["is_expired"] = true;
			}
			else{
				$rs["rs"][$key]["is_expired"] = false;
			}

			$rs["rs"][$key]["exam_time"] = $examDate;
			$rs["rs"][$key]["paper_size"] = $paperSize;
		}

		return $rs;
	}

	public function getThirdPrintList($condition = array(), $orderBy = array("e.create_time desc"), $pageSize = 9){
		$condition = Arr::merge($condition, array("e.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);

		$sql="select eg.*,e.exam_id,e.school_card_status,e.school_card_length, e.name as exam_name,e.is_new, e.tpl_index, e.tpl_data, e.upload_status, e.create_time, e.is_display, eg.mark_type, eg.mark_status,e.subject_id,e.class_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled, p.labelled_type,p.paper_id
			from exam_group as eg
			left join exam as e on eg.exam_group_id = e.exam_group_id
			left join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by eg.exam_group_id
				{$orderBy}
		";
		$handle = $this->sConn->createCommand($sql)->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}


        //获取下载班级
        public function getDownloadClassIpf($condition = array(), $orderBy = array("add_time desc")){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$rs['rs'] = $this->sConn->createCommand("
			select cep.*, c.class_name, csr.subject_id, e.name as exam_name,e.is_new, e.upload_status, e.create_time,e.complete_time, e.is_display, eg.mark_type,eg.upload_status as group_upload_status, eg.mark_status,e.exam_group_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->queryAll();


		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf from student_paper_relation where exam_id in({$examsIds})")->queryAll();

		$examsSprs = array();
		foreach($sprs as $key => $val){
			if(!isset($examsSprs[$val["exam_id"]]))
				$examsSprs[$val["exam_id"]] = array();

			$examsSprs[$val["exam_id"]][] = $val;
		}

		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1)
				{
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}



				$examsStudentsCount[$examId]["is_uploaded_count"]++;

				if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}

				if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


				if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}
			}
		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
				$rs["rs"][$key]["wrongbook_pdf_count"] = 0;
				$rs["rs"][$key]["wbisp_pdf_count"] = 0;
				$rs["rs"][$key]["isp_pdf_count"] = 0;
			}
                }
                return $rs["rs"];
        }

	public function getPrintList_ipf($condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);

		$handle = $this->sConn->createCommand("
			select cep.*, c.class_name, csr.subject_id, e.name as exam_name,e.is_new, e.tpl_index, e.tpl_data, e.upload_status, e.create_time,e.complete_time, e.is_display, eg.mark_type,eg.upload_status as group_upload_status, eg.mark_status,e.exam_group_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
			from class as c
			join class_subject_relation as csr on csr.class_id = c.class_id
			join exam as e on e.class_id = c.class_id
			join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			join paper as p on p.exam_id = e.exam_id
			{$condition}
			group by class_id, exam_id, type
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		$examsIds = $this->grouping($rs["rs"], "exam_id", true);
		$examsIds = "'".implode("','", $examsIds)."'";

		$sprs = $this->sConn->createCommand("select exam_id, is_complete, is_feedback,is_wrongbook_pdf,is_wbisp_pdf,is_isp_pdf,is_wrongbook_download,is_two_isp_download,is_three_isp_download from student_paper_relation where exam_id in({$examsIds})")->queryAll();

		$examsSprs = array();
		foreach($sprs as $key => $val){
			if(!isset($examsSprs[$val["exam_id"]]))
				$examsSprs[$val["exam_id"]] = array();

			$examsSprs[$val["exam_id"]][] = $val;
		}

		$examsStudentsCount = array();
		foreach($examsSprs as $examId => $sprs){
			$examsStudentsCount[$examId] = array(
				"is_complete_count" => 0,
				"is_uploaded_count" => 0,
				"wrongbook_pdf_count" => 0,
				"wbisp_pdf_count" => 0,
				"isp_pdf_count" => 0,
                "wrongbook_download_count" => 0,
                "wbisp_download_count" => 0,
                "isp_download_count" => 0,
			);

			$examsStudentsCount[$examId]["students_count"] = count($sprs);

			foreach($sprs as $k => $v){
				if($v["is_complete"] == 1)
				{
					$examsStudentsCount[$examId]["is_complete_count"]++;
				}



				$examsStudentsCount[$examId]["is_uploaded_count"]++;

				if($v["is_wrongbook_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wrongbook_pdf_count"]++;
				}

				if($v["is_wbisp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["wbisp_pdf_count"]++;
				}


				if($v["is_isp_pdf"] == 1)
				{
					$examsStudentsCount[$examId]["isp_pdf_count"]++;
				}

                if($v["is_wrongbook_download"] == 1)
                {
                    $examsStudentsCount[$examId]["wrongbook_download_count"]++;
                }

                if($v["is_two_isp_download"] == 1)
                {
                    $examsStudentsCount[$examId]["isp_download_count"]++;
                }


                if($v["is_three_isp_download"] == 1)
                {
                    $examsStudentsCount[$examId]["wbisp_download_count"]++;
                }
			}
		}

		foreach($rs["rs"] as $key => $val){
			if(isset($examsStudentsCount[$val["exam_id"]])){
				$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
				$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
				$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
				$rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
				$rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
				$rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
                $rs["rs"][$key]["wrongbook_download_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_download_count"];
                $rs["rs"][$key]["isp_download_count"] = $examsStudentsCount[$val["exam_id"]]["isp_download_count"];
                $rs["rs"][$key]["wbisp_download_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_download_count"];
			}
			else{
				$rs["rs"][$key]["students_count"] = 0;
				$rs["rs"][$key]["is_complete_count"] = 0;
				$rs["rs"][$key]["is_uploaded_count"] = 0;
				$rs["rs"][$key]["wrongbook_pdf_count"] = 0;
				$rs["rs"][$key]["wbisp_pdf_count"] = 0;
				$rs["rs"][$key]["isp_pdf_count"] = 0;
				$rs["rs"][$key]["wrongbook_download_count"] = 0;
				$rs["rs"][$key]["isp_download_count"] = 0;
				$rs["rs"][$key]["wbisp_download_count"] = 0;
			}

			$tplData = json_decode($val["tpl_data"], true);
			$paperSize = null;
			$examDate = null;

			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "12":
						$paperSize = "A3";
						break;

					case "13":
						$paperSize = "A4";
						break;

					case "14":
						$paperSize = "8K";
						break;

					case "15":
						$paperSize = "16K";
						break;
					case "2012":
						$paperSize = "A3";
						break;
					case "2013":
						$paperSize = "A4";
						break;
					case "2014":
						$paperSize = "8K";
						break;
					case "2015":
						$paperSize = "16K";
						break;
					case "2016":
						$paperSize = "A3";
						break;
					case "2017":
						$paperSize = "A4";
						break;
					case "2018":
						$paperSize = "8K";
						break;
					case "2019":
						$paperSize = "16K";
						break;
					case "1012":
						$paperSize = "A3";
						break;
					case "1013":
						$paperSize = "A4";
						break;
					case "1014":
						$paperSize = "8K";
						break;
					case "1015":
						$paperSize = "16K";
						break;
					case "1016":
						$paperSize = "A3";
						break;
					case "1017":
						$paperSize = "A4";
						break;
					case "1018":
						$paperSize = "8K";
						break;
					case "1019":
						$paperSize = "16K";
						break;
				}
			}
			if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
				switch($val["tpl_index"]){
					case "16":
						$paperSize = "A3";
						break;

					case "17":
						$paperSize = "A4";
						break;

					case "18":
						$paperSize = "8K";
						break;

					case "19":
						$paperSize = "16K";
						break;
				}
			}
			if($tplData){
				if(!isset($tplData["examDate"]) || !($examDate = strtotime($tplData["examDate"])))
					$examDate = $val["create_time"];

				if($paperSize === null && isset($tplData["paper"]) && $tplData["paper"] == 1)
					$paperSize = "A3";
			}

			if($examDate === null)
				$examDate = $val["create_time"];
			if($paperSize === null)
				$paperSize = "A4";

			$time = time();
			$expireTime = $examDate + (3600 * 24 * 2);

			if($time > $expireTime){
				$rs["rs"][$key]["is_expired"] = true;
			}
			else{
				$rs["rs"][$key]["is_expired"] = false;
			}

			$rs["rs"][$key]["exam_time"] = $examDate;
			$rs["rs"][$key]["paper_size"] = $paperSize;
		}

		return $rs;
	}
	public function getPrintListOfCoach($coachId, $condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
		$rs = $this->buildEmptyPagingStruct();

		if($coachId){
			$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
			$condition = $this->condition($condition);
			$orderBy = $this->orderBy($orderBy);
			$handle = $this->sConn->createCommand("
				select cep.*, c.class_name, csr.subject_id, e.name as exam_name,e.is_new, e.tpl_index, e.tpl_data, e.upload_status, e.create_time, e.is_display, eg.mark_type,eg.upload_status as group_upload_status, eg.mark_status,e.exam_group_id,p.tpl_doc_src, p.answer_card_src, p.is_labelled,p.paper_id
				from class as c
				join class_subject_relation as csr on csr.class_id = c.class_id
				join exam as e on e.class_id = c.class_id
				join class_exam_printer as cep on cep.class_id = c.class_id and cep.exam_id = e.exam_id
				JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
				join paper as p on p.exam_id = e.exam_id
				{$condition}
				group by class_id, exam_id, type
				{$orderBy}
			")->query();

			$rs = $this->paging($this->sConn, $handle, $pageSize);

			$examsIds = $this->grouping($rs["rs"], "exam_id", true);
			$examsIds = "'".implode("','", $examsIds)."'";

			$sprs = $this->sConn->createCommand("select * from student_paper_relation where exam_id in({$examsIds}) ")->queryAll();

			$examsSprs = array();
			foreach($sprs as $key => $val){
				if(!isset($examsSprs[$val["exam_id"]]))
					$examsSprs[$val["exam_id"]] = array();

				$examsSprs[$val["exam_id"]][] = $val;
			}

			$examsStudentsCount = array();
			foreach($examsSprs as $examId => $sprs){
				$examsStudentsCount[$examId] = array(
					"is_complete_count" => 0,
					"is_uploaded_count" => 0,
                    "wrongbook_pdf_count" => 0,
                    "wbisp_pdf_count" => 0,
                    "isp_pdf_count" => 0,
				);

				$examsStudentsCount[$examId]["students_count"] = count($sprs);

				foreach($sprs as $k => $v){
					if($v["is_complete"] == 1)
						$examsStudentsCount[$examId]["is_complete_count"]++;

					if($v["is_feedback"] == 1)
						$examsStudentsCount[$examId]["is_uploaded_count"]++;
                    if($v["is_wrongbook_pdf"] == 1)
                        $examsStudentsCount[$examId]["wrongbook_pdf_count"]++;

                    if($v["is_wbisp_pdf"] == 1)
                        $examsStudentsCount[$examId]["wbisp_pdf_count"]++;

                    if($v["is_isp_pdf"] == 1)
                        $examsStudentsCount[$examId]["isp_pdf_count"]++;
				}
			}

			foreach($rs["rs"] as $key => $val){
				if(isset($examsStudentsCount[$val["exam_id"]])){
					$rs["rs"][$key]["students_count"] = $examsStudentsCount[$val["exam_id"]]["students_count"];
					$rs["rs"][$key]["is_complete_count"] = $examsStudentsCount[$val["exam_id"]]["is_complete_count"];
					$rs["rs"][$key]["is_uploaded_count"] = $examsStudentsCount[$val["exam_id"]]["is_uploaded_count"];
                    $rs["rs"][$key]["wrongbook_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wrongbook_pdf_count"];
                    $rs["rs"][$key]["wbisp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["wbisp_pdf_count"];
                    $rs["rs"][$key]["isp_pdf_count"] = $examsStudentsCount[$val["exam_id"]]["isp_pdf_count"];
				}
				else{
					$rs["rs"][$key]["students_count"] = 0;
					$rs["rs"][$key]["is_complete_count"] = 0;
					$rs["rs"][$key]["is_uploaded_count"] = 0;
                    $rs["rs"][$key]["wrongbook_pdf_count"] = 0;
                    $rs["rs"][$key]["wbisp_pdf_count"] = 0;
                    $rs["rs"][$key]["isp_pdf_count"] = 0;
				}

				$tplData = json_decode($val["tpl_data"], true);
				$paperSize = null;
				$examDate = null;

				if(in_array($val["tpl_index"], Yii::app()->params["custom_tpls_ids"])){
					switch($val["tpl_index"]){
						case "12":
							$paperSize = "A3";
							break;

						case "13":
							$paperSize = "A4";
							break;

						case "14":
							$paperSize = "8K";
							break;

						case "15":
							$paperSize = "16K";
							break;
						case "2012":
							$paperSize = "A3";
							break;
						case "2013":
							$paperSize = "A4";
							break;
						case "2014":
							$paperSize = "8K";
							break;
						case "2015":
							$paperSize = "16K";
							break;
						case "2016":
							$paperSize = "A3";
							break;
						case "2017":
							$paperSize = "A4";
							break;
						case "2018":
							$paperSize = "8K";
							break;
						case "2019":
							$paperSize = "16K";
							break;
						case "1012":
							$paperSize = "A3";
							break;
						case "1013":
							$paperSize = "A4";
							break;
						case "1014":
							$paperSize = "8K";
							break;
						case "1015":
							$paperSize = "16K";
							break;
						case "1016":
							$paperSize = "A3";
							break;
						case "1017":
							$paperSize = "A4";
							break;
						case "1018":
							$paperSize = "8K";
							break;
						case "1019":
							$paperSize = "16K";
							break;
						case "3013":
							$paperSize = "A4";
							break;
						case "3017":
							$paperSize = "A4";
							break;
					}
				}

				if($tplData){
					if(!isset($tplData["examDate"]) || !($examDate = strtotime($tplData["examDate"])))
						$examDate = $val["create_time"];

					if($paperSize === null && isset($tplData["paper"]) && $tplData["paper"] == 1)
						$paperSize = "A3";
				}

				if($examDate === null)
					$examDate = $val["create_time"];
				if($paperSize === null)
					$paperSize = "A4";

				$time = time();
				$expireTime = $examDate + (3600 * 24 * 2);

				if($time > $expireTime){
					$rs["rs"][$key]["is_expired"] = true;
				}
				else{
					$rs["rs"][$key]["is_expired"] = false;
				}

				$rs["rs"][$key]["exam_time"] = $examDate;
				$rs["rs"][$key]["paper_size"] = $paperSize;
			}
		}

		return $rs;
	}

	public function getClassesByCoachId($coachId,$grade=''){
		$classes = array();

		if($coachId){
			if(in_array($grade, array("1", "2", "3"))) {
				$classes = $this->sConn->createCommand("select * from `class` where coach_id = '{$coachId}' and grade='{$grade}'")->queryAll();
			} else {
				$classes = $this->sConn->createCommand("select * from `class` where coach_id = '{$coachId}'")->queryAll();
			}
		}

		return $classes;
	}

	public function getClassesIdsByCoachId($coachId){
		$rs = $this->getClassesByCoachId($coachId);
		$ids = $this->grouping($rs, "class_id");
		return $ids;
	}

	/**
	 * 获取学期的班级
	 * @param $semesterId
	 *
	 * @return array|\CDbDataReader
	 */
	public function getSemesterClasses($semesterId){
		$classes = array();

		if($semesterId){
			$classes = $this->sConn->createCommand("select * from class where semester_id = '{$semesterId}' and is_hide=0")->queryAll();
		}

		return $classes;
	}
	public function getSemesterClassesStudent($semesterId){
		$classes = array();

		if($semesterId){

			$classes = $this->sConn->createCommand("
				select c.*
				from class as c
				left join student_class_relation as scr on scr.class_id = c.class_id
				where c.semester_id = ".$semesterId ." and scr.status = 0 and c.is_hide=0
				group by scr.class_id ")->queryAll();

		}

		return $classes;
	}
	public function getSemesterStudents($semesterId){
		$students = array();

		if($semesterId){
			$students = $this->sConn->createCommand("
				select stu.student_id, stu.realname, scr.class_id, scr.userno, scr.serial_number
				from class as c
				join student_class_relation as scr on scr.class_id = c.class_id and scr.status = 1
				join student_info as stu on stu.student_id = scr.student_id
				where c.semester_id = '{$semesterId}'
				group by stu.student_id
			")->queryAll();
		}

		return $students;
	}

	public function activateSemesterClassesStudentsRelations($semesterId){
		$rs = false;

		if($semesterId){
			$students = $this->getSemesterStudents($semesterId);
			$classes = $this->getSemesterClasses($semesterId);

			if($students && $classes){
				$studentsIds = $this->grouping($students, "student_id");
				$studentsIds = "'".implode("','", $studentsIds)."'";

				$classesIds = $this->grouping($classes, "class_id");
				$classesIds = "'".implode("','", $classesIds)."'";

				try{
					$trans = $this->sConn->beginTransaction();
					$this->sConn->createCommand("update student_class_relation set status = '1' where student_id in({$studentsIds}) and status = 0")->execute();
					$this->sConn->createCommand("update student_class_relation set status = '0' where student_id in({$studentsIds}) and class_id in({$classesIds}) and status = 1")->execute();
					foreach($students as $student){
						$this->sConn->createCommand("update student_info set class_id = '{$student["class_id"]}' where student_id = '{$student["student_id"]}'")->execute();
					}
					$trans->commit();
					$rs = true;
				}
				catch(Exception $e){
					$trans->rollBack();
					$rs = false;
				}
			}
		}

		return $rs;
	}

	public function getExamPaper($examId){
		$paper = array();

		if($examId){
			$paper = $this->sConn->createCommand("select * from paper where exam_id = '{$examId}'")->queryRow();
		}

		return $paper;
	}

	public function setPrintTransChecked($classId, $examId){
		if($classId && $examId){
			$rs = $this->sConn->createCommand("select exists(select * from class_exam_printer where class_id = '{$classId}' and exam_id = '{$examId}' and type = '2' and is_checked = 1)")->queryRow();
			$isChecked = current($rs) > 0 ? true : false;
			if($isChecked)
				$rs = true;
			else{
				$rs = $this->sConn->createCommand("update class_exam_printer set is_checked = '1' where class_id = '{$classId}' and exam_id = '{$examId}' and type = '2'")->execute();
			}

			return $rs ? true : false;
		}

		return false;
	}

	public function setStudentIspChecked($planId){
		if($planId){
			$rs = $this->sConn->createCommand("select exists(select * from student_improve_score_plan where plan_id = '{$planId}' and is_checked = 1)")->queryRow();
			$isChecked = current($rs) > 0 ? true : false;
			if($isChecked)
				$rs = true;
			else{
				$rs = $this->sConn->createCommand("update student_improve_score_plan set is_checked = '1' where plan_id = '{$planId}'")->execute();
			}

			return $rs ? true : false;
		}

		return false;
	}

	public function getClassStudentsIspsList($classId, $examId, $orderBy = array("scr.serial_number asc", "stu.realname asc"), $pageSize = 9){
		$isps = $this->buildEmptyPagingStruct();

		/*if($examId && $classId){
			$orderBy = $this->orderBy($orderBy);
			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, sisp.is_checked, sisp.plan_id
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join student_improve_score_plan as sisp on sisp.student_id = scr.student_id and sisp.exam_id = '{$examId}'
				where scr.class_id = '{$classId}' and sisp.is_created=1 and scr.status = 0
				{$orderBy}
			")->query();
			$isps = $this->paging($this->sConn, $handle, $pageSize);
		}*/
		if($examId && $classId){
			$orderBy = $this->orderBy($orderBy);
			$handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, sisp.is_checked, sisp.plan_id
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join student_improve_score_plan as sisp on sisp.student_id = scr.student_id and sisp.exam_id = '{$examId}'
				where scr.class_id = '{$classId}' and sisp.is_created=1
				{$orderBy}
			")->query();
			$isps = $this->paging($this->sConn, $handle, $pageSize);
		}
		return $isps;
	}

	public function getIspInfo($planId){
		$isp = array();

		if($planId){
			$isp = $this->sConn->createCommand("
				select sisp.*, p.difficulty, p.score, spr.class_id
				from student_improve_score_plan as sisp
				join paper as p on p.paper_id = sisp.paper_id
				join student_paper_relation as spr on spr.student_id = sisp.student_id and spr.paper_id = sisp.paper_id
				where sisp.plan_id = '{$planId}' and spr.is_del=0
			")->queryRow();
		}

		return $isp;
	}

	//获取题目难度描述
	public function getTopicDifficultyDescription($key){
		$key = (string)$key;

		$description = array(
			"1" => "容易",
			"2" => "中等",
			"3" => "困难",
		);

		return isset($description[$key]) ? $description[$key] : "";
	}

	//从接口获取题目信息
	public function getTopics($topicsIds = array(), $detial = false,$subject=0,$params=array()){
		$topics = array();
		$array = array();
		$cachedTopics = array();

		if($topicsIds){
			foreach($topicsIds as $val){
				if(!$val)
					continue;



				$array[$this->topicField][] = $val;
			}
            if($subject && $subject!=8){
                $array['subjectId']=$subject;
            }

            if($params){
                $array['params']=$params;
            }
			if($array){
				$topics = Curl::post($this->topicUrl, $array);
				$topics = json_decode($topics, true);

				if(isset($topics["status"]))
				{
//                    unset($array['subjectId']);
//                    unset($array['params']);
//                    $topics = Curl::post($this->topicUrl, $array);
//                    $topics = json_decode($topics, true);
//                    if(isset($topics["status"])) $topics =  array();

                    $topics =  array();

				}
			}


		}

		return $topics;
	}

	public function getTopic($topicId){
		$topic = array();

		if($topicId){
			$rs = $this->getTopics(array($topicId));
			if($rs) $topic = current($rs);
		}

		return $topic;
	}

	public function getTopicsByIspRecords($plan, $topicsRs, $paperTopicsRecords){
		$topics = array();

		if(Arr::isAvailable($plan) && Arr::isAvailable($topicsRs) && Arr::isAvailable($paperTopicsRecords)){
			$topicsIds = array();
			$schoolTopicsIds = array();

			foreach($topicsRs as $topicRs){
				foreach($paperTopicsRecords as $paperTopicRecord){
					$topicsIds[] = $topicRs["topic_id"];
				}
			}

			$schoolTopicsIds = array_unique($schoolTopicsIds);
			$topicsIds = array_unique($topicsIds);
			$schoolTopicsIds = "'".implode("','", $schoolTopicsIds)."'";

			$topics = $this->getTopics($topicsIds);

		}

		return $topics;
	}

	public function getTopicsRecordsFromStudentIsp($planId, $type = "ALL"){
		$rs = array();

		if($planId){
			$condition = array("plan_id = '{$planId}'");
			if($type === "IMPROVE")
				$condition = Arr::merge($condition, array("is_template = 0"));

			$condition = $this->condition($condition);

			$rs = $this->sConn->createCommand("select * from student_improve_score_plan_topics{$condition}")->queryAll();
		}

		return $rs;
	}

	public function getIspTopics($planId){
		$topics = array();

		if($isp = $this->getIspInfo($planId)){
			$topicsRecords = $this->getTopicsRecordsFromStudentIsp($planId);
			$paperTopicsRecords = $this->getPaperTopicsRecords($isp["paper_id"]);
			$topics = $this->getTopicsByIspRecords($isp, $topicsRecords, $paperTopicsRecords);

			foreach($topics as $key => $topic){
				foreach($topicsRecords as $k => $v){
					if($topic["id"] == $v["topic_id"]){
						$topics[$key]["is_source"] = $v["is_template"];
						$topics[$key]["source_id"] = $v["template_id"];

					}
				}
			}

			foreach($topics as $key => $topic){
				foreach($paperTopicsRecords as $k => $topicRecord){
					if($topic["id"] == $topicRecord["topic_id"])
						$topics[$key]["number"] = $topicRecord["no"];
				}
			}
		}

		return $topics;
	}

	public function getIspTopicsIds($planId){
		$ids = array();

		if($rs = $this->getTopicsRecordsFromStudentIsp($planId)){
			$ids = $this->grouping($rs, "topic_id");
		}

		return $ids;
	}

	public function getPaperTopicsRecords($paperId){
		$records = array();

		if($paperId){
			$records = $this->sConn->createCommand("select * from paper_topic_relation where paper_id = '{$paperId}' order by type asc, `order` asc")->queryAll();
		}

		return $records;
	}

	public function getPaperTopics($paperId,$subject=0,$params=array(),$onlySlave=0){
		if(!($ptrs = $this->getPaperTopicsRecords($paperId)))
			return array();

		$schoolTopicsIds = array();
		$topicsIds = array();

		foreach($ptrs as $ptr){

		    if($onlySlave==1){
                $topicsIds[] = $ptr["topic_id"];
            }else{
                if(isset($ptr['stem_id']) && $ptr['stem_id']){
                    $topicsIds[] = $ptr["stem_id"];
                }else{
                    $topicsIds[] = $ptr["topic_id"];
                }
            }
		}

		$topics = $this->getTopics($topicsIds,false,$subject,$params);

		return $topics;
	}

	public function getPaperTopicsIds($paperId){
		if(!($topicsRecords = $this->getPaperTopicsRecords($paperId)))
			return array();

		return $this->grouping($topicsRecords, "topic_id");
	}

	public function composeIspTopics($planId, $topics){
		$sections = array(
			"选择题" => array(
				"type_id" => 1,
				"type_name" => "单选题",
				"wrong_topics" => array(),
				"wrong_topics_count" => 0,
				"correct_topics" => array(),
				"correct_topics_count" => 0,
				"order" => $this->topicTypesOrder["选择题"],
			),
			"填空题" => array(
				"type_id" => 5,
				"type_name" => "填空题",
				"wrong_topics" => array(),
				"wrong_topics_count" => 0,
				"correct_topics" => array(),
				"correct_topics_count" => 0,
				"order" => $this->topicTypesOrder["填空题"],
			),
			"解答题" => array(
				"type_id" => 7,
				"type_name" => "简答题",
				"wrong_topics" => array(),
				"wrong_topics_count" => 0,
				"correct_topics" => array(),
				"correct_topics_count" => 0,
				"order" => $this->topicTypesOrder["解答题"],
			),
		);

		if($topics){
			$topicsOrder = array();
			$topicNum = 1;

			foreach($sections as $key => $val){
				foreach($topics as $k => $topic){
					if($topic["type_id"] == $val["type_id"]){
						if($topic["is_source"]){
							$sections[$key]["wrong_topics"][$topic["id"]] = $topic;
						}
						else{
							$sections[$key]["correct_topics"][$topic["source_id"]][$topic["id"]] = $topic;
							$sections[$key]["correct_topics_count"]++;
						}
					}
				}

				$sections[$key]["wrong_topics_count"] = count($sections[$key]["wrong_topics"]);

				foreach($sections[$key]["wrong_topics"] as $wrongTopicId => $wrongTopic){
					if(!isset($wrongTopic["kps"]))
						$wrongTopic["kps"] = array();

					$kps = $wrongTopic["kps"];
					$kpsNames = $this->grouping($kps, "kp_name");
					$kpsNamesStr = implode("； ", $kpsNames);

					$sections[$key]["wrong_topics"][$wrongTopicId]["kps"] = $kps;
					$sections[$key]["wrong_topics"][$wrongTopicId]["kps_names_str"] = $kpsNamesStr;

					$sections[$key]["wrong_topics"][$wrongTopicId]["methods_ids"] = array();
					$wrongTopicMethodsNames = array();

					if(!empty($wrongTopic["specials"])){
						foreach($wrongTopic["specials"] as $method){
							$wrongTopicMethodsNames[] = $method["method_name"];
							if($method["method_id"])
								$sections[$key]["wrong_topics"][$wrongTopicId]["methods_ids"][] = $method["method_id"];
						}
					}

					$sections[$key]["wrong_topics"][$wrongTopicId]["methods_names_str"] = implode("； ", $wrongTopicMethodsNames);
					unset($wrongTopicMethodsNames);

					if(!empty($sections[$key]["correct_topics"][$wrongTopic["id"]])){
						foreach($sections[$key]["correct_topics"][$wrongTopic["id"]] as $correctTopicId => $correctTopic){
							if(!isset($correctTopic["kps"]))
								$correctTopic["kps"] = array();

							$kps = $correctTopic["kps"];
							$kpsNames = $this->grouping($kps, "kp_name");
							$kpsNamesStr = implode("； ", $kpsNames);

							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["kps"] = $kps;
							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["kps_names_str"] = $kpsNamesStr;

							//过滤掉图片float样式
							/*$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["title"] = preg_replace_callback(
								"/float\s*?:\s*?[a-zA-Z]*?\s*?(;|\"|\')/i",
								function($matches){
									return $matches[0] == "\"" || $matches[0] == "'" ? $matches[0] : "";
								},
								$correctTopic["title"]
							);

							//将题干相对路径转换为绝对路径
							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["title"] = preg_replace(
								"/src\s*?\=\s*?\"\s*?(\/.*)\.((?:gif)|(?:jpg)|(?:png))(.*?)\"/i",
								"src=\"{$this->topicHost}$1.$2$3$4\"",
								$correctTopic["title"]
							);*/

							$topicsOrder[$correctTopicId] = $topicNum;

							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["methods_ids"] = array();
							$correctTopicMethodsNames = array();
							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["methods_count"] = 0;

							if(isset($correctTopic["specials"])){
								$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["methods_count"] = count($correctTopic["specials"]);

								foreach($correctTopic["specials"] as $tsm){
									if($tsm["method_id"]){
										$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["methods_ids"][] = $tsm["method_id"];
										$correctTopicMethodsNames[] = $tsm["method_name"];
									}
								}
							}

							$sections[$key]["correct_topics"][$wrongTopicId][$correctTopicId]["methods_names_str"] = implode("； ", $correctTopicMethodsNames);
							unset($correctTopicMethodsNames);

							$topicNum++;
						}

						Arr::sortByField($sections[$key]["correct_topics"][$wrongTopic["id"]],'');
					}
				}

				Arr::sortByField($sections[$key]["wrong_topics"], "number", "ASC");

				if(!$this->ispTopicsOrderSeted($planId))
					$this->setIspTopicsOrder($planId, $topicsOrder);
			}

			Arr::sortByField($sections,'', "ASC", "NATURAL", true);
		}

		return $sections;
	}

	public function ispTopicsOrderSeted($planId){
		if($topics = $this->getTopicsRecordsFromStudentIsp($planId, "IMPROVE")){

				return true;
		}

		return false;
	}

	public function setIspTopicsOrder($planId, $order = array()){
		if($planId && $order){
			try{
				$trans = $this->sConn->beginTransaction();
				foreach($order as $key => $val){
					$this->sConn->createCommand("update student_improve_score_plan_topics set `order` = '{$val}' where plan_id = '{$planId}' and topic_id = '{$key}'")->execute();
				}
				$trans->commit();

				return true;
			}
			catch(Exception $e){
				$trans->rollBack();

				return false;
			}
		}

		return false;
	}

	public function ispTopicExists($topicId, $planId){
		if($topicId && $planId){
			$rs = $this->sConn->createCommand("select exists(select * from student_improve_score_plan_topics where topic_id = '{$topicId}' and plan_id = '{$planId}' and is_template = 0)")->queryRow();
			$rs = current($rs);

			return $rs ? true : false;
		}

		return false;
	}

	public function getIspTopic($planId, $topicId){
		$topic = array();

		if($planId && $topicId){
			$topic = $this->sConn->createCommand("select * from student_improve_score_plan_topics where topic_id = '{$topicId}' and plan_id = '{$planId}' and is_template = 0")->queryRow();
		}

		return $topic;
	}

	public function replaceIspTopic($planId, $previousTopicId, $newTopicId){
		$code = 1001;

		if($previousTopicId && $newTopicId){
			$code = array();

			if($previousTopicId == $newTopicId)
				$code[] = 2001;
			if(!$this->ispTopicExists($previousTopicId, $planId))
				$code[] = 2002;
			if($this->ispTopicExists($newTopicId, $planId))
				$code[] = 2003;

			if($code)
				return $this->rs($code, __FUNCTION__);

			$rs = $this->sConn->createCommand("update student_improve_score_plan_topics set topic_id = '{$newTopicId}' where topic_id = '{$previousTopicId}' and plan_id = '{$planId}' and is_template = 0")->execute();

			$code = $rs ? 0 : 1002;
		}

		return $this->rs($code, "global");
	}

	public function changeExamStatus($examId, $status){
		if($examId){
			$rs = $this->sConn->createCommand("update exam set status = '{$status}' where exam_id = '{$examId}'")->execute();

			return $rs ? true : false;
		}

		return false;
	}

	public function getStudentByIspId($planId){
		$student = array();

		if($planId){
			$student = $this->sConn->createCommand("
				select stu.*
				from student_improve_score_plan as sisp
				join student_info as stu on stu.student_id = sisp.student_id
				where sisp.plan_id = '{$planId}'
			")->queryRow();
		}

		return $student;
	}

	public function getStudentIdByIspId($planId){
		$studentId = null;

		if($student = $this->getStudentByIspId($planId)){
			$studentId = $student["student_id"];
		}

		return $studentId;
	}

	public function getClassVacationHomeworkList($classId, $pageSize = 9){
		if(!$classId)
			return $this->buildEmptyPagingStruct();

		$handle = $this->sConn->createCommand("
			select c.class_name, seme.semester_name, cvh.generate_time, c.class_id
			from class_vacation_homework as cvh
			join class as c on c.class_id = cvh.class_id
			join semester as seme on seme.semester_id = cvh.semester_id
			where cvh.class_id = '{$classId}' and cvh.semester_id = '{$this->semester["id"]}'
			order by cvh.generate_time desc
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getClassesVacationHomeworkList($pageSize = 9){
		$handle = $this->sConn->createCommand("
			select c.class_name, seme.semester_name, cvh.generate_time, c.class_id
			from class_vacation_homework as cvh
			join class as c on c.class_id = cvh.class_id
			join semester as seme on seme.semester_id = cvh.semester_id
			where cvh.semester_id = '{$this->semester["id"]}'
			order by cvh.generate_time desc
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getClassVhStudents($classId,$realname = NULL, $pageSize = 9){
		if(!$classId)
			return $this->buildEmptyPagingStruct();

		$where    =   '';
// 		debug($realname);
		if (!empty($realname)) {
			$where = "cvh.class_id = '{$classId}' and cvh.semester_id = '{$this->semester["id"]}' and stu.realname like '%{$realname}%'";
		} else {
			$where = "cvh.class_id = '{$classId}' and cvh.semester_id = '{$this->semester["id"]}'";
		}

		$handle = $this->sConn->createCommand("
			select c.class_name, c.class_id, stu.realname, cvh.semester_id, vh.is_generated, stu.student_id
			from class_vacation_homework as cvh
			join vacation_homework as vh on vh.class_id = cvh.class_id and vh.semester_id = cvh.semester_id
			join student_info as stu on stu.student_id = vh.student_id
			join class as c on c.class_id = cvh.class_id
			where {$where}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		return $rs;
	}

	public function getMaterialChapters($materialId){
		$chapters = array();

		if($materialId){
			if(!($module = Yii::app()->cache->get("material_{$materialId}"))){
				$module = Curl::post($this->moduleUrl, array($this->moduleField => $materialId));
				$module = json_decode($module, true);

				if($module)
					Yii::app()->cache->set("material_{$materialId}", $module, $this->chapterCacheTime);
			}

			if(isset($module["chapters"]) && $module["chapters"]){
				foreach($module["chapters"] as $chapter){
					$chapters[$chapter["chapter_id"]] = $chapter;

					if($chapter["chapter_id"] && !Yii::app()->cache->get("chapter_{$chapter["chapter_id"]}"))
						Yii::app()->cache->set("chapter_{$chapter["chapter_id"]}", $chapter, $this->chapterCacheTime);
				}
			}
		}

		return $chapters;
	}

	public function getSchoolInfo(){
		return $this->conn->createCommand("select * from school where school_id = '{$this->schoolId}'")->queryRow();
	}

	public function getArea($areaId){
		if(!$areaId)
			return array();

		return $this->conn->createCommand("select region_id as area_id, region_code as area_code, region_name as area_name from region where region_id = '{$areaId}'")->queryRow();
	}

	public function getSchoolAreaFromSchoolInfo($schoolInfo){
		$schoolArea = array(
			"province_id" => null,
			"province_name" => null,
			"city_id" => null,
			"city_name" => null,
			"district_id" => null,
			"district_name" => null,
		);

		$municipalitiesIds = array(2, 3, 10, 23);

		if(!Arr::isAvailable($schoolInfo, array("province_id", "city_id", "area_id")))
			return $schoolArea;

		if($area = $this->getArea($schoolInfo["province_id"])){
			$schoolArea["province_id"] = $area["area_id"];
			$schoolArea["province_name"] = $area["area_name"];
		}
		if($area = $this->getArea($schoolInfo["city_id"])){
			$schoolArea["city_id"] = $area["area_id"];
			$schoolArea["city_name"] = $area["area_name"];
		}
		if($area = $this->getArea($schoolInfo["area_id"])){
			$schoolArea["district_id"] = $area["area_id"];
			$schoolArea["district_name"] = $area["area_name"];
		}

		if(in_array($schoolArea["province_id"], $municipalitiesIds))
			$schoolArea["city_name"] = $schoolArea["province_name"];

		return $schoolArea;
	}

	public function getCoachIdByClassId($classId){
		if(!$classId)
			return null;

		$rs = $this->sConn->createCommand("select coach_id from `class` where class_id = '{$classId}'")->queryRow();

		return $rs ? current($rs) : null;
	}

	public function getCoachClassRelationByClassId($classId, $type = "ARR"){
		if(!$classId)
			return array();

		$rs = $this->sConn->createCommand("select coach_id, class_id from `class` where class_id = '{$classId}'")->queryRow();

		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getCoachClassesRelations($coachId, $type = "ARR"){
		if(!$coachId)
			return array();

		$rs = $this->sConn->createCommand("select coach_id, class_id from class where coach_id = '{$coachId}'")->queryAll();

		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getExamClasses($examId){
		if(!$examId)
			return array();

		return $this->sConn->createCommand("
			select c.class_id, c.class_name
			from exam as e
			join class as c on c.class_id = e.class_id
			where e.exam_id = '{$examId}'
		")->queryAll();
	}

	public function changeExamUploadStatus($examId, $uploadStatus){
		if(!$examId || !$uploadStatus)
			return false;

		return $this->sConn->createCommand()->update("exam", array("upload_status" => $uploadStatus), "exam_id = '{$examId}'");
	}

	public function ExamStatusAndUploadStatus($examId,$status,$upload_status){
		if($examId){

			$rs = $this->sConn->createCommand("select * from `exam` where exam_id = '{$examId}' and status= ".$status." and upload_status = ".$upload_status)->queryRow();
			if($rs)
			{
				return $rs;
			}
		}

		return false;
	}
    public function ExamStatusAndUploadStatusArr($examId,$statusArr,$upload_status){
        if($examId){

            $rs = $this->sConn->createCommand("select * from `exam` where exam_id = '{$examId}' and status in(".implode(',',$statusArr).") and upload_status = ".$upload_status)->queryRow();
            if($rs)
            {
                return $rs;
            }
        }

        return false;
    }

	public function getExamClassesRelations($examId, $type = "ARR"){
		if(!$examId)
			return array();

		$rs = $this->sConn->createCommand("select exam_id, class_id from exam where exam_id = '{$examId}'")->queryAll();

		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}
		return $rs;
	}

	public function getExamClassesRelationsFilteredByUploadStatus($examId, $uploadStatus, $type = "ARR"){
		if(!$examId || !$uploadStatus)
			return array();

		$rs = $this->sConn->createCommand("select exam_id, class_id from exam where exam_id = '{$examId}' and upload_status = '{$uploadStatus}'")->queryAll();

		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getExamsByExamGroupId($examGroupId, $type = "ARR"){
		if(!$examGroupId)
			return array();

		$rs = $this->sConn->createCommand("select * from exam where exam_group_id = '{$examGroupId}'")->queryAll();
		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getExamsIdsByExamGroupId($examGroupId){
		if(!$examGroupId)
			return array();

		$rs = $this->sConn->createCommand("select exam_id from exam where exam_group_id = '{$examGroupId}'")->queryAll();
		return $this->grouping($rs, "exam_id");
	}

	public function getExamGroupIdByExamId($examId){
		if(!($exam = $this->getExam($examId)))
			return null;

		return $exam["exam_group_id"];
	}

	public function getStudentsPaperRs($paperId, $studentsIds, $type = "ARR"){
		if(!$paperId || !is_array($studentsIds) || !$studentsIds)
			return array();

		$studentsIds = "'".implode("','", $studentsIds)."'";

		$orderBy = array("scoring DESC", "right_count ASC", "student_id ASC");
		$orderBy = $this->orderBy($orderBy);
		$rs = $this->sConn->createCommand("select * from student_paper_relation where paper_id = '{$paperId}' and student_id in({$studentsIds}) and (scoring > 0 or lost_score > 0) and is_del=0 {$orderBy}")->queryAll();
		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getStudentsPdfsPaths($paperId, $studentsIds, $check = "", $type = "OBJ"){
		if(!$paperId || !is_array($studentsIds) || !$studentsIds)
			return array();

		$studentsIds = "'".implode("','", $studentsIds)."'";
		$condition = array("paper_id = '{$paperId}'", "student_id in({$studentsIds})", "(scoring > 0 or lost_score > 0)");

		if($check == "WB"){
			$condition[] = "is_wrongbook_pdf = 1";
		}
		else if($check == "ISP"){
			$condition[] = "is_isp_pdf = 1";
		}
		else if($check == "WB_ISP"){
			$condition[] = "is_wbisp_pdf = 1";
		}
		$condition[] = "is_del = 0";
		$condition = $this->condition($condition);

		$rs = $this->sConn->createCommand("select wrongbook_pdf_path, isp_pdf_path, wbisp_pdf_path from student_paper_relation{$condition}")->queryAll();

		if($type == "OBJ"){
			$rs = Arr::toObj($rs);
		}

		return $rs;
	}

	public function getThisYearSemesterDictionary($year){
		if(!$year)
			return array();

		return $this->conn->createCommand("select * from semester_refer where code like '{$year}%'")->queryAll();
	}

    public function getThisYearSemesterName($semester_name){
        if(!$semester_name)
            return array();

        return $this->conn->createCommand("select * from semester_refer where `name` = '".$semester_name."'")->queryRow();
    }

	public function classSubjectExists($classId){
		if(!$classId)
			return false;

		$rs = $this->sConn->createCommand("select exists(select * from class_subject_relation where class_id = '{$classId}')")->queryRow();
		$rs = current($rs);

		return $rs ? true : false;
	}

	public function getSemesterNameByCode($code){
		if(!$code)
			return null;

		$rs = $this->conn->createCommand("select `name` from semester_refer where `code` = '{$code}'")->queryRow();

		if(!$rs)
			return null;

		return current($rs);
	}

	public function getPaperWithTopicsDetails($paperId, $type = "JSON"){
		if(!$paperId)
			return array();
		$rs = apiPost(Yii::app()->params['get_api_url'].'/coachio/iointerface/getpaperwithtopicsdetails', 'paperIdStr='.$paperId);

		if($type == "ARR" && $rs){
			$rs = json_decode($rs, true);
		}

		return $rs;
	}
	public function getPaperWithTopicsDetails_v2($paperId, $type = "JSON"){
		if(!$paperId)
			return array();
		$rs = apiPost(Yii::app()->params['get_api_url'].'/coachio/iointerface_v2/getpaperwithtopicsdetails', 'paperIdStr='.$paperId);

		if($type == "ARR" && $rs){
			$rs = json_decode($rs, true);
		}

		return $rs;
	}
	public function getSubjectIdByTopic($topic){
		return isset($topic["subject_id"]) ? $topic["subject_id"] : 0;
	}

	public function getSubjectIdByTplData($tplData){
		return isset($tplData["subjectId"]) ? $tplData["subjectId"] : 0;
	}

	public function checkExamAnswers($examId){
		if(!$examId)
			return false;

		$rs = $this->sConn->createCommand("
			select stu.realname
			from paper as p
			join student_paper_relation as spr on spr.paper_id = p.paper_id
			join student_paper_topic_rs as sptr on sptr.student_id = spr.student_id and sptr.paper_id = spr.paper_id
			join student_info as stu on stu.student_id = spr.student_id
			where p.exam_id = '{$examId}' and spr.is_feedback = 1 and spr.is_del=0 and (sptr.answer = '' and sptr.answer_url = '')
			group by spr.student_id
		")->queryAll();

		if(!$rs)
			return array();

		$studentsNames = array();
		foreach($rs as $student){
			$studentsNames[] = $student["realname"];
		}

		return $studentsNames;
	}

	// 操作周周练显示状态
    public function oprateExamDisplay($exam_groupId, $flag=0){
        if($exam_groupId){
            $rs = $this->sConn->createCommand("UPDATE `exam` SET `is_display` = '{$flag}' where `exam_group_id` = '{$exam_groupId}'")->execute();
            return $rs ? true : false;
        }
        return false;
    }
	// 操作周周练显示状态
	public function oprateExamExportDisplay($exam_Id, $flag=0){
		if($exam_Id){
			 if($this->sConn->createCommand("UPDATE `exam` SET `export_dispaly` = '{$flag}' where `exam_id` = '{$exam_Id}'")->execute())
			 {
				 return true;
			 }
		}

		return false;
	}
	public function ThirdOprateExamDisplay($exam_group_id, $flag=0){
		if($exam_group_id){
			$rs = $this->sConn->createCommand("UPDATE `exam` SET `is_display` = '{$flag}' where `exam_group_id` = '{$exam_group_id}'")->execute();
			return $rs ? true : false;
		}
		return false;
	}
    // 根据年级获取当前学期班级
    public function getSchoolByGrade($grade,$semesterId) {
        return $this->sConn->createCommand("select class_id,class_name from class where grade = '{$grade}' and semester_id='{$semesterId}'")->queryAll();
    }

	/**
	 * 刘红伟
	 */

	public function getPaperByExamId($exam_id){
		if(!$exam_id)
			return false;

		$rs = $this->sConn->createCommand("select * from paper where `exam_id` = '{$exam_id}'")->queryRow();

		if(!$rs)
			return false;

		return $rs;
	}

	public function getxuekeStatus($semester_id,$is_third = 0)
	{
		$subject_exam_data	=	array();
		$class_data			=	ClassModel::model()->findAll('semester_id=:semester_id',array(':semester_id'=>$semester_id));
		$class_array		=	array();
		if($class_data)
		{
			foreach($class_data as $v)
			{
				$class_array[$v->class_id]	=	$v->class_id;
			}
		}
		$criteria	=	new CDbCriteria();
		$criteria->addInCondition('class_id',$class_array);
		$criteria->addCondition('is_new=:is_new');
		$criteria->params[':is_new']	=	0;
		$exam_data	=	Exam::model()->findAll($criteria);
		unset($criteria);
		$exam_group_id = array();
		if($exam_data)
		{
			foreach($exam_data as $v)
			{
				$exam_group_id[$v->exam_group_id] = $v->exam_group_id;
				$subject_exam_data[$v->exam_group_id][$v->subject_id][$v->exam_id]	=	$v->exam_id;
			}
		}
		$subject 	= array();
		$criteria	=	new CDbCriteria();
		$criteria->addInCondition('exam_group_id',$exam_group_id);
		$criteria->addCondition('is_third=:is_third');
		$criteria->params[':is_third']	=	$is_third;
		$exam_group_data	=	ExamGroup::model()->findAll($criteria);
		if($exam_group_data)
		{
			foreach($exam_group_data as $v)
			{
				if(isset($subject_exam_data[$v->exam_group_id]))
				{
					foreach($subject_exam_data[$v->exam_group_id] as $k=>$s)
					{
						$subject[$k] = $s;
					}

				}

			}
		}

		return $subject;
	}

	public function getStudentProduct($class_ids,$subject_id=3){
        if(!$class_ids) return false;
        $sql = "select student_id,class_id from student_class_relation where class_id in (".implode(',',$class_ids).") and `status` = 0";
        $res = $this->sConn->createCommand($sql)->queryAll();

        $student_rel_class = array();
        if($res){
            foreach ($res as $v){
                if(!isset($student_rel_class[$v['class_id']])){
                    $student_rel_class[$v['class_id']] = array();
                }
                $student_rel_class[$v['class_id']][] = $v['student_id'];
            }
        }
        unset($res);


        $rs_is_pdf = array();
        $rs_is_download = array();
        $class_buti=array();
        //查询补题状态
        $sql="select rpc.status,category,rpc.class_id from review_product_class rpc ";
        $sql.=" left join review_paper_product_set rpps on rpps.rprs_id=rpc.rprs_id ";
        $sql.=" where rpps.semester_id = {$this->semester['id']} and rpps.subject_id='{$subject_id}' and rpc.status=5";
        $res = $this->sConn->createCommand($sql)->queryAll();
        if($res){
            foreach ($res as $v){
                $class_buti[(string)$v['class_id']][$v['category']]=1;
            }
        }
        if($student_rel_class){
            $create_num = array();
            foreach ($student_rel_class as $class_id => $student_ids){
                if(!$student_ids){
                    continue;
                }
                $__sql = "select student_id,is_download,type,product_type,rpc.status as rpc_status from student_product sp";
                $__sql.=" left join review_product_class rpc on rpc.rpc_id=sp.plan_id";
                $__sql.=" left join review_paper_product_set rpps on rpps.rprs_id=rpc.rprs_id";
                $__sql.= " where sp.semester_id = {$this->semester['id']} and student_id in(".implode(',',$student_ids).") and `type` >0 and rpps.subject_id='{$subject_id}'";

                $sql = $__sql.' and is_pdf_created = 1 ';
                $res = $this->sConn->createCommand($sql)->queryAll();


                if($res){
                    foreach ($res as $v){
                         if(!isset($create_num[$class_id])){
                             $create_num[$class_id] = array();
                         }
                        if(!isset($create_num[$class_id][$v['product_type']])){
                            $create_num[$class_id][$v['product_type']] = 0;
                        }
                        $create_num[$class_id][$v['product_type']]++;

                        $rs_is_pdf[] = array(
                            'class_id' => $class_id,
                            'class_name' => '',
                            'is_download' => $v['is_download'],
                            'type' => $v['type'],
                            'student_id' => $v['student_id'],
                            'student_sum' => $create_num[$class_id][$v['product_type']],
                            'product_type'=>$v['product_type'],
                            'rpc_status'=>$v['rpc_status']
                        );
                    }
                }
                unset($res);

                $sql = $__sql.' and is_download = 1 ';
                $res = $this->sConn->createCommand($sql)->queryAll();
                if($res){
                    $student_sum = count($student_ids);
                    foreach ($res as $v){
                        $rs_is_download[] = array(
                            'class_id' => $class_id,
                            'class_name' => '',
                            'is_download' => $v['is_download'],
                            'type' => $v['type'],
                            'student_id' => $v['student_id'],
                            'student_sum' => $student_sum,
                            'product_type'=>$v['product_type'],
                        );
                    }
                }
                unset($res);
            }
        }

        return array($rs_is_pdf,$rs_is_download,$class_buti);
    }

//	public function getStudentProduct($condition = array()){
//		$condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
//		$condition = $this->condition($condition);
//		//后面需要优化
//
//		$rs = $this->sConn->createCommand("
//			select * from (SELECT
//									c.class_name,
//									c.class_id,
//									p.is_download,
//									p.`type`,
//									p.student_id,
//									COUNT(p.student_id) as student_sum
//						FROM
//							class AS c
//						LEFT JOIN student_class_relation cr ON
//																c.class_id = cr.class_id
//																AND cr.`status` = 0
//
//						LEFT JOIN student_product AS p ON p.student_id = cr.student_id
//					{$condition} and p.semester_id = {$this->semester['id']}
//					GROUP BY c.class_id,p.type ORDER BY c.grade asc,c.class_id asc)as gc WHERE `type` >0")->queryAll();
//
//
//		if($rs)
//		{
//			return $rs;
//		}
//		return false;
//	}
	public function getPadSchool($school_ids)
	{
		$school_data	=	array();
		if($school_ids){
			$school_data = $this->conn->createCommand("
				select s.*,sp.*
				from school_project as sp
				left join school as s on sp.school_id = s.school_id
				WHERE s.school_id in (".implode(',',$school_ids).")
			")->queryAll();
		}
		return $school_data;
	}

    //根据学校Id读取学生数据
    public  function getStudentBySchool($school_id){
        $sql=" select student_id from student where school_id='".$school_id."' and status=1 ";
        $Arr = $this->conn->createCommand($sql)->queryAll();
        return $Arr;
    }
    //读取学生信息扩展字段设置
    public function getStudentExtend(){
        $sql="select * from student_info_extend ";
        $Arr = $this->sConn->createCommand($sql)->queryAll();
        $result=array();
        if($Arr){
            foreach ($Arr as $val){
                $result[$val['field_name']]=array(
                    'field_mean'=>$val['field_mean'],
                    'is_enable'=>$val['is_enable']
                );
            }
        }
        return $result;
    }
    //默认设置扩展
    public function setDefaultStudentExtend(){
        $result=array();
        $insert="insert into student_info_extend(`field_name`,`field_mean`,`is_enable`) values ('field_1','智学网考号',1)";
        $this->sConn->createCommand($insert)->execute();
        $result['field_1']=array(
            'field_mean'=>'智学网考号',
            'is_enable'=>1
        );
        return $result;
    }

    //切换学期，保留班级，保留学生
    public function changeSemesterByStudentAndClass($semesterId,$oldSemesterId,$IsRetainClass=false,$IsGraduation=false,$classNewNameArr=array(),$gradeDirector=1){
        if($semesterId && $oldSemesterId){
            $code = array();

            if($this->role !== ROLE_SU){
                if($this->isPreviousSemester($semesterId))
                    $code[] = 2001;

                if(!$this->semesterAllowToChange($semesterId)){
                    $code[] = 2002;
                }
            }

            if($code)
                return $this->rs($code, __FUNCTION__);

            $class_r_class=array();     //新旧班级对应关系
            $classSql="";
            $classTeacherSql="";
            $classSubjectSql='';
            $classStudentSql='';
            $updateStudentInfoSql=array();
            $updateClassStudentSql='';

            $updateClassProgressSql=array();
            $classTypeArr=array();

            $classifiedValues=array();
            $classifiedSql='';

            $updateTeacherSql=array();  //年级主任同步升班

            $cancelClassSubjectId=array();  //不同步升级年级主任，则删除对应科目

            $classesModel	=	new ClassModel();

            $classes_old = $this->getSemesterClassesGraduation($oldSemesterId,$IsGraduation); //读取所有原班级

            //判断是否保留班级
            if($IsRetainClass){

                if($classes_old){

                    $classValues=array();
                    $classTeacherValues=array();
                    $classSubjectValues=array();
                    foreach($classes_old as $val){
                        $classTypeArr[$val['class_id']]=$val['class_type'];
                        $checkCreatedClass=$classesModel->find('semester_id=:seid and class_name=:cname',array(':seid'=>$semesterId,':cname'=>$val['class_name']));
                        if ($checkCreatedClass)
                        {
                            $class_r_class[$val['class_id']]=$checkCreatedClass['class_id'];
                            continue;
                        }else{

                            //$classId    =	getUUID();
                            $classId    =	getUniqueId($this->schoolId);
                            if (empty($classId)) {
                                $code[]=2003;
                                return $this->rs($code, __FUNCTION__);
                            }
                            $class_r_class[$val['class_id']]=$classId;

                            $teacherIds=$this->getTeachersByClassesIds(array($val['class_id']));


                            $grade=$val['grade'];
                            $className=$val['class_name'];
                            if(isset($classNewNameArr[(string)$val['class_id']])){
                                $grade=$grade+1;
                                $className=$classNewNameArr[(string)$val['class_id']];
                            }
                            $classValues[]="('".$classId."','".$className."','".$val['level']."','".$grade."','".$semesterId."','".$val['period']."','".time()."','".$this->coachId."','".$val['wrong_book_type']."','".$val['improve_book_type']."','".$val['wb_isp_version']."','".$val['sort']."','".$val['arts_science']."','".$val['teacher_id']."','".$val['class_type']."')";

                           // $sql_teacher="select * from teacher_class_relation where class_id = '{$val['class_id']}';";
                           // $classTeacher=$this->sConn->createCommand($sql_teacher)->queryAll();

                            if($teacherIds){
                                foreach($teacherIds as $tid){
                                    //读取教师岗位
                                    if($classNewNameArr && $tid['posts']==3){
                                        if($gradeDirector==1){
                                            //同步升级
                                            $updateTeacherSql[]="update teacher set grade='".$grade."' where teacher_id='".$tid['teacher_id']."'";
                                            $classTeacherValues[]="('".$classId."','".$tid['teacher_id']."','".$semesterId."','".$tid['hxb_ing']."','".$tid['is_bzr']."')";
                                        }elseif($gradeDirector==2){
                                            //不同步,取消班级教师关联
                                            $cancelClassSubjectId[$tid['subjects']]=$tid['subjects'];
                                        }
                                    }else{
                                        $classTeacherValues[]="('".$classId."','".$tid['teacher_id']."','".$semesterId."','".$tid['hxb_ing']."','".$tid['is_bzr']."')";
                                    }

                                }
                            }

                            //班级科目
                            $sql_subject="select * from class_subject_relation where class_id = '{$val['class_id']}';";
                            $classSubject=$this->sConn->createCommand($sql_subject)->queryAll();
                            if($classSubject){
                                foreach ($classSubject as $v){
                                    if(!$cancelClassSubjectId || !isset($cancelClassSubjectId[$v['subject_id']])){
                                        $classSubjectValues[]="('".$classId."','".$v['subject_id']."','".$v['material_id']."','".$v['module_ids']."')";
                                    }
                                }
                            }

                            //更新教学进度
                            $updateClassProgressSql[]="update teach_progress_class set class_id = {$classId} where class_id = '{$val['class_id']}'";
                        }
                    }

                    //走班设置
                    $classified="select * from classified where semester_id='{$oldSemesterId}'";
                    $classifiedData=$this->sConn->createCommand($classified)->queryAll();
                    if($classifiedData){
                        foreach ($classifiedData as $value){
                            $classifiedValues[]="('".$value['grade']."','".$value['subject_id']."','".$value['status']."','".$semesterId."')";
                        }
                    }

                    //组装sql
                    if($classValues){
                        $classSql="insert into class(`class_id`,`class_name`,`level`,`grade`,`semester_id`,`period`,`add_time`,`coach_id`,`wrong_book_type`,`improve_book_type`,`wb_isp_version`,`sort`,`arts_science`,`teacher_id`,`class_type`) values";
                        $classSql.=implode(',',$classValues);
                        if($classTeacherValues){
                            $classTeacherSql="insert into teacher_class_relation(`class_id`,`teacher_id`,`semester_id`,`hxb_ing`,`is_bzr`) values";
                            $classTeacherSql.=implode(',',$classTeacherValues);
                        }
                        if($classSubjectValues){
                            $classSubjectSql="insert into class_subject_relation(`class_id`,`subject_id`,`material_id`,`module_ids`) values";
                            $classSubjectSql.=implode(',',$classSubjectValues);
                        }
                    }

                    if($classifiedValues){
                        $classifiedDel="delete from classified where semester_id='{$semesterId}'";

                        $classifiedSql='insert into classified(`grade`,`subject_id`,`status`,`semester_id`) values ';
                        $classifiedSql.=implode(',',$classifiedValues);
                    }
                    
                    //学生处理
                    $classStudentSql="";
                    $classStudentValues=array();
                    $classIds=array();
                    if($class_r_class){
                        foreach ($class_r_class as $key=>$val){
                            //查询原班学生
                            $classStudent=$this->sConn->createCommand("select student_id,serial_number,userno,class_type from student_class_relation where class_id='".$key."' and status=0 ")->queryAll();
                            $studentIds=array();
                            if($classStudent){
                                $classIds[]=$key;

                                $classType=isset($classTypeArr[$key])?$classTypeArr[$key]:$v['class_type'];

                                foreach ($classStudent as $v){
                                    $studentIds[]=$v['student_id'];

                                    $classStudentValues[]="('".$val."','".$v['student_id']."',0,'".$v['serial_number']."','".$v['userno']."','".time()."',0,'".$classType."')";
                                }

                                $updateStudentInfoSql[]="update student_info set class_id='".$val."' where student_id in(".implode(',',$studentIds).") ;";
                            }

                        }
                        if($classStudentValues){
                            $classStudentSql="insert into student_class_relation(`class_id`,`student_id`,`status`,`serial_number`,`userno`,`update_time`,`operation`,`class_type`) values ";
                            $classStudentSql.=implode(',',$classStudentValues);
                        }

                    }

                    if($classIds){
                        $updateClassStudentSql="update student_class_relation set status=1,operation=3 where class_id in(".implode(',',$classIds).") and status=0; ";
                    }


                }
            }


            //执行
            $trans = $this->sConn->beginTransaction();
            try{
                if($this->semesterExists($semesterId)){
                    //切表
                    $inciseTables =  $this->inciseTables;
                    $oldSemester = $this->sConn->createCommand("SELECT semester_id,refer_code FROM `semester` WHERE `semester_id` = '".$oldSemesterId."'")->queryRow();
                    $newSemester = $this->sConn->createCommand("SELECT semester_id,refer_code FROM `semester` WHERE `semester_id` = '".$semesterId."'")->queryRow();

                    foreach ($inciseTables as $inciseTable) {
                        $newTableName = $inciseTable . '_' . $newSemester['refer_code'];    //新学期表名
                        $oldTableName= $inciseTable . '_' . $oldSemester['refer_code'];     //旧学期（当前学期）需要改的名字
                        $existTable = $this->sConn->createCommand("SHOW TABLES LIKE '$newTableName';")->queryRow(); //查询新学期表是否存在
                        if($existTable){
                            //修改当前的表名
                            $existOldTable=$this->sConn->createCommand("SHOW TABLES LIKE '$oldTableName';")->queryRow(); //查询当前学期表是否存在
                            if($existOldTable){
                                //throw new Exception('3001');
                                //重复表进行重命名
                                $bakTableName=$oldTableName.'_'.date('YmdHis');
                                $this->sConn->createCommand("ALTER  TABLE ".$oldTableName." RENAME TO ".$bakTableName)->execute();
                            }
                            $this->sConn->createCommand("ALTER  TABLE ".$inciseTable." RENAME TO ".$oldTableName)->execute();
                            //修改新学期表名
                            $this->sConn->createCommand("ALTER  TABLE ".$newTableName." RENAME TO ".$inciseTable)->execute();
                        }else{

                            //修改当前的表名
                            $existOldTable=$this->sConn->createCommand("SHOW TABLES LIKE '$oldTableName';")->queryRow(); //查询当前学期表是否存在
                            if($existOldTable){
                                //throw new Exception('3001');
                                //重复表进行重命名
                                $bakTableName=$oldTableName.'_'.date('YmdHis');
                                $this->sConn->createCommand("ALTER  TABLE ".$oldTableName." RENAME TO ".$bakTableName)->execute();
                            }
                            $this->sConn->createCommand("ALTER  TABLE ".$inciseTable." RENAME TO ".$oldTableName)->execute();
                            //创建新学期表
                            $this->sConn->createCommand('CREATE TABLE '.$inciseTable.' LIKE '.$oldTableName)->execute();

                        }

                    }

                    if($classSql){
                        $this->sConn->createCommand($classSql)->execute();
                        if($classTeacherSql){
                            $this->sConn->createCommand($classTeacherSql)->execute();
                        }
                        if($classSubjectSql){
                            $this->sConn->createCommand($classSubjectSql)->execute();
                        }
                        if($updateTeacherSql){
                            foreach ($updateTeacherSql as $sql){
                                $this->sConn->createCommand($sql)->execute();
                            }
                        }
                    }
                    if($classStudentSql){
                        $this->sConn->createCommand($classStudentSql)->execute();
                        if($updateClassStudentSql){
                            $this->sConn->createCommand($updateClassStudentSql)->execute();
                        }
                        if($updateStudentInfoSql){
                            foreach($updateStudentInfoSql as $query){
                                $this->sConn->createCommand($query)->execute();
                            }
                        }
                    }
                    if(isset($classifiedSql) && $classifiedSql ){
                        $this->sConn->createCommand($classifiedDel)->execute();
                        $this->sConn->createCommand($classifiedSql)->execute();
                    }
                    if($updateClassProgressSql){
                        foreach($updateClassProgressSql as $query){
                            $this->sConn->createCommand($query)->execute();
                        }
                    }
                    //处理毕业班学生
                    if($IsGraduation){
                       $classGraduation= $this->sConn->createCommand("select class_id from class where semester_id = '{$oldSemesterId}' and (grade=3 or grade=9)")->queryAll();
                       if($classGraduation){
                           $gClassId=array();
                           foreach ($classGraduation as $item){
                               $gClassId[]=$item['class_id'];
                           }
                           $this->sConn->createCommand("update student_class_relation set status=1,operation=3 where class_id in(".implode(',',$gClassId).") and status=0; ")->execute();

                       }
                    }

                    $this->sConn->createCommand("update semester set status = 0 where status = 1")->execute();
                    $this->sConn->createCommand("update semester set status = 1 where semester_id = '{$semesterId}'")->execute();

                    $trans->commit();
                    $rs = true;
                }
                else
                    $rs = false;
            }
            catch(Exception $e){
                $trans->rollBack();
                if($e->getMessage()=='3001'){
                    $code[] = 3001;
                    return $this->rs($code, __FUNCTION__);
                }else{
                    debug($e->getMessage());
                    $rs = false;
                }
            }


            $code = $rs ? 0 : 1002;
        }
        return $this->rs($code, "global");
    }

    //前一学期待分班学生数量
    public function getWaitStudent(){
        $nowSemester=$this->getCurrSemester();
        $count=0;
	    //前一学期
        $sql="select semester_id from semester where end_time< '".$nowSemester['end_time']."' order by end_time desc limit 1";
        $prevSemester=$this->sConn->createCommand($sql)->queryRow();

        $sql_student="select count(*) as count from student_class_relation scr ";
        $sql_student.=" join class c on c.class_id=scr.class_id ";
        $sql_student.=" where c.semester_id='".$prevSemester['semester_id']."' and scr.status=2 ";
        $studentCount=$this->sConn->createCommand($sql_student)->queryRow();
        if($studentCount){
            $count=$studentCount['count'];
        }
        return $count;

    }

    //获取上一学期id
    public function getPrevSemesterId(){
        $nowSemester=$this->getCurrSemester();
        $count=0;
        //前一学期
        $sql="select semester_id from semester where end_time< '".$nowSemester['end_time']."' order by end_time desc limit 1";
        $prevSemester=$this->sConn->createCommand($sql)->queryRow();
        if($prevSemester){
            return $prevSemester['semester_id'];
        }
        return 0;
    }

    //读取上学期班级
    public function getClassesBySemesterId($semesterId){
        $classes = array();
        $condition = array();

        $condition= array("semester_id = '{$semesterId}'");

        $condition = $this->condition($condition);
        $orderBy = $this->orderBy(array("class_id asc", "class_name asc"));


        $classes = $this->sConn->createCommand("select * from class{$condition} group by class_id{$orderBy}")->queryAll();

        return $classes;
    }

    public function getPrevSemesterClassStudentsList($classId, $condition = array(), $pageSize = 9,$where=''){
        $student_ids	=	array();
        if(empty($where))
        {
              $rs = $this->getPrevSemesterClassRelation($classId, $condition, $pageSize, "ARR");
        }else
        {

            $accounts = $this->conn->createCommand("select * from student where ".$where)->queryAll();
            if($accounts)
            {
                $studentIdOr=array();
                foreach ($accounts as $v){
                    $studentIdOr[]=" stu.student_id=" . $v['student_id']." ";
                }
                $condition=	array(" (".implode(' OR ',$studentIdOr).") ");
                $rs = $this->getPrevSemesterClassRelation($classId, $condition, $pageSize, "ARR");
            }else
            {
                $rs["rs"] =array();
                $rs['pager'] = (object)array();
                $rs['pager']->rowsCount	=	0;
            }


        }



        if($rs["rs"]){
            foreach($rs["rs"] as $key => $val){
                $rs["rs"][$key]["username"] = "";
                $rs["rs"][$key]["status"] = null;
            }

            $studentsIds = $this->grouping($rs["rs"], "student_id");
            $studentsIds = implode("','", $studentsIds);
            $studentsIds = "'{$studentsIds}'";
            if($where)
            {

                $accounts = $this->conn->createCommand("select * from student where ".$where)->queryAll();

                if($accounts){

                    $b_student_status = array();
                    $b_student_card = array();
                    $b_student_username = array();
                    $b_school_student_card = array();
                    $b_zhixue_student_card = array();
                    foreach($accounts as $v)
                    {
                        $b_student_card[$v['student_id']]	=	$v['student_card'];
                        $b_student_status[$v['student_id']]	=	$v['status'];
                        $b_student_username[$v['student_id']]	=	$v['username'];
                        $b_school_student_card[$v['student_id']]	=	$v['school_student_card'];
                        $b_zhixue_student_card[$v['student_id']]	=	$v['zhixue_student_card'];
                    }

                    foreach($rs["rs"] as $key => $val){
                        if( isset($b_student_card[$val["student_id"]]) && !empty($b_student_card[$val["student_id"]])){
                            $rs["rs"][$key]["username"] 	= $b_student_username[$val["student_id"]];
                            $rs["rs"][$key]["student_card"] = $b_student_card[$val["student_id"]];
                            $rs["rs"][$key]["school_student_card"] = $b_school_student_card[$val["student_id"]];
                            if(isset($b_zhixue_student_card[$val["student_id"]]))
                            {
                                $rs["rs"][$key]["zhixue_student_card"] = $b_zhixue_student_card[$val["student_id"]];
                            }

                            $rs["rs"][$key]["status"] 		= $b_student_status[$val["student_id"]];
                        }else
                        {
                            unset($rs["rs"][$key]);
                            $rs['pager']->rowsCount = 0;
                        }
                    }

                }else
                {
                    foreach($rs["rs"] as $key => $val){

                        unset($rs["rs"][$key]);
                    }
                    $rs['pager']->rowsCount = 0;
                }
            }else
            {

                $accounts = $this->conn->createCommand("select * from student where student_id in ({$studentsIds})")->queryAll();
                if($accounts){
                    $b_student_status = array();
                    $b_student_card = array();
                    $b_student_username = array();
                    $b_school_student_card = array();
                    $b_zhixue_student_card = array();
                    foreach($accounts as $v)
                    {
                        $b_student_card[$v['student_id']]	=	$v['student_card'];
                        $b_student_status[$v['student_id']]	=	$v['status'];
                        $b_student_username[$v['student_id']]	=	$v['username'];
                        $b_school_student_card[$v['student_id']]	=	$v['school_student_card'];
                        $b_zhixue_student_card[$v['student_id']]	=	$v['zhixue_student_card'];
                    }

                    foreach($rs["rs"] as $key => $val){
                        if( isset($b_student_card[$val["student_id"]]) && !empty($b_student_card[$val["student_id"]])){
                            $rs["rs"][$key]["username"] 	= $b_student_username[$val["student_id"]];
                            $rs["rs"][$key]["student_card"] = $b_student_card[$val["student_id"]];
                            $rs["rs"][$key]["school_student_card"] = $b_school_student_card[$val["student_id"]];
                            if(isset($b_zhixue_student_card[$val["student_id"]]))
                            {
                                $rs["rs"][$key]["zhixue_student_card"] = $b_zhixue_student_card[$val["student_id"]];
                            }

                            $rs["rs"][$key]["status"] 		= $b_student_status[$val["student_id"]];
                        }
                    }

                }


            }


        }

        return $rs;
    }

    public function getPrevSemesterClassRelation($classId, $condition = array(), $pageSize = 9, $type = "OBJ"){
        $rs = $this->buildEmptyPagingStruct();

        if($classId){
            if(is_array($classId)){
                $condition = Arr::merge(array("scr.class_id in( ".implode(',',$classId).")", "scr.status = 2"), $condition);
            }else{
                $condition = Arr::merge(array("scr.class_id =".$classId, "scr.status = 2"), $condition);
            }

            $condition = $this->condition($condition);
            $handle = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}

				order by serial_number asc
			")->query();
            $rs = $this->paging($this->sConn, $handle, $pageSize);
        }

        return $rs;
    }


    //读取导入学生模板
    public function getImportStudentTemplate(){
        $sql="select * from import_student_template ";
        $Arr = $this->sConn->createCommand($sql)->queryRow();
        $result=array();
        if($Arr){
            $result=$Arr['tpl_data'];
        }
        return $result;
    }

    //判断班级是否存在
    public function classNameExists($className,$semesterIds,$class_type=1){
        if(!$semesterIds || !$className)
            return false;

        if(is_array($semesterIds)){
            $rs = $this->sConn->createCommand("select class_id from class where class_name = '{$className}' and semester_id in(".implode(',',$semesterIds).") and class_type='".$class_type."' and is_hide=0")->queryRow();
        }else{
            $rs = $this->sConn->createCommand("select class_id from class where class_name = '{$className}' and semester_id='".$semesterIds."'  and class_type='".$class_type."'  and is_hide=0 ")->queryRow();
        }
        if($rs){
            return $rs['class_id'];
        }
        return false;
    }
    //根据班级，姓名 读取行政班学生数据
    public function getStudentByNameClass($studentName,$semesterIds,$idNumber=false){
	    if(!$studentName || !$semesterIds){
	        return null;
        }

        $sql="SELECT si.student_id,si.realname,si.class_id,c.semester_id,c.class_name FROM `student_info` si ";
	    $sql.="join student_class_relation scr on scr.student_id=si.student_id ";
	    $sql.="join class c on c.class_id = scr.class_id ";
        $sql.="where  si.realname='{$studentName}' and  scr.status=0 and scr.class_type=1";

        if(is_array($semesterIds)){
            $sql.=" and semester_id in(".implode(',',$semesterIds).")";
        }else{
            $sql.=" and semester_id ='{$semesterIds}'";
        }
        if($idNumber){
            $sql.=" and si.id_number='".$idNumber."'";
        }
        $student=$this->sConn->createCommand($sql)->queryAll();

        return $student;
    }

    //核验身份证号是否存在
    public function checkStudentIdNumber($id){
	    if(!$id) return false;
        $rs = $this->sConn->createCommand("select exists(select student_id from student_info where id_number = '{$id}')")->queryRow();
        $rs = current($rs);

        return $rs ? true : false;
    }

    //读取匹配成功数据
    public function getNormalStudent($condition,$pageSize){
	    $where='';
	    if($condition){
            $where=" where ".implode(' and ',$condition);
        }
        $handle = $this->sConn->createCommand("select student_name,class_name,sex,modify_name,extend,id_number,student_card from import_student_temp  {$where} order by id asc ")->query();
        $rs = $this->paging($this->sConn, $handle, $pageSize);
        return $rs;
    }

    public function getSemesterClassesGraduation($semesterId,$Graduation=false)
    {
        $classes = array();

        if ($semesterId) {
            if ($Graduation) {
                $classes = $this->sConn->createCommand("select * from class where semester_id = '{$semesterId}' and grade<>3 and grade<>9 and is_hide=0")->queryAll();
            } else {
                $classes = $this->sConn->createCommand("select * from class where semester_id = '{$semesterId}' and is_hide=0")->queryAll();
            }
        }
        return $classes;
    }

    //根据班级读取分组
    public function getTeamByClass($class_id,$get="team"){
	    if(!$class_id){
	        return null;
        }
        $sql="select * from class_team where class_id='".$class_id."'";
	    $teamData=$this->sConn->createCommand($sql)->queryAll();
	    $student_ids=array();

	    if($teamData){
	        foreach($teamData as $key=>$val){
	            $studentSql="select cst.student_id,cst.student_card,cst.real_name from class_student_team cst ";
                $studentSql.="join student_class_relation scr on scr.student_id=cst.student_id and scr.class_id=cst.class_id ";
                $studentSql.="where cst.team_id='".$val['team_id']."' and scr.status=0";

                $student=$this->sConn->createCommand($studentSql)->queryAll();
                if($student){
                    foreach($student as $v){
                        $student_ids[$v['student_id']]=$val['team_name'];
                    }
                    $teamData[$key]['student']=$student;
                }else{
                    $teamData[$key]['student']=null;
                }
            }

        }
        if($get=='team'){
            return $teamData;
        }elseif($get=='student'){
            return $student_ids;
        }else{
	        return null;
        }

    }
    //根据班级读取学生列表

    public function getStudentByClassId($get_id){
	    if(!$get_id) return null;

        $condition = array("scr.class_id = '{$get_id}'", "scr.status = 0");
        $condition = $this->condition($condition);
        $get_list = $this->sConn->createCommand("
				select stu.*, scr.userno, scr.serial_number, c.class_name
				from student_class_relation as scr
				join student_info as stu on stu.student_id = scr.student_id
				join class as c on c.class_id = scr.class_id
				{$condition}
				order by serial_number asc
			")->queryAll();

        $student_ids	=	array();
        $result=array();
        if($get_list)
        {
            foreach($get_list as $k=> $v)
            {
                $student_ids[$v['student_id']]	=	$v['student_id'];
                $result[$v['student_id']]=$v;
            }

            if($student_ids){
                $criteria		=	new CDbCriteria();
                $criteria->addInCondition('student_id',$student_ids);
                $b_student_data	=	BusinessStudent::model()->findAll($criteria);
                if($b_student_data)
                {
                    foreach($b_student_data as $v)
                    {
                        $result[$v->student_id]['student_card']	=	$v->student_card;
                        $result[$v->student_id]['school_student_card']	=	(string)$v->school_student_card;
                    }
                }


            }

        }

        return $result;

    }
    //读取督学卡上传数量
    public function getSuperviseStudentByExamId($examIds){
        if(!$examIds) return 0;
        $data=$this->sConn->createCommand("select count(*) as count from supervise_card where exam_id in(".implode(',',$examIds).")")->queryRow();
        if($data){
            return $data['count'];
        }
        return 0;

    }

    //判断智学网号是否存在
    public function checkZhiXueNumber($id){
        if(!$id) return false;
        $rs = $this->conn->createCommand("select exists(select student_id from student where zhixue_student_card = '{$id}')")->queryRow();
        $rs = current($rs);

        return $rs ? true : false;
    }

    //读取全部学生id
    public function delStudentPaperByExamIds($examIds){
	    if(!$examIds || !is_array($examIds)) return false;
        $rs = $this->sConn->createCommand("update student_paper_relation set `is_del`=1 where exam_id in(".implode(',',$examIds).") and is_feedback=0 ")->execute();
        return $rs;
    }



    //删除student_paper_relation 同步删除student_paper_relation_property
    public function delStudentPaperPropertyByExamIds($examIds,$studentIds){
        if(!$examIds || !is_array($examIds)) return false;
        if(!$studentIds || !is_array($studentIds)) return false;


        $trans = $this->sConn->beginTransaction();
        try{
            $this->sConn->createCommand("update student_paper_relation set `is_del`=1 where exam_id in(".implode(',',$examIds).") and is_feedback=0 ")->execute();
            //$this->sConn->createCommand("delete from  student_paper_relation_property  where exam_id in(".implode(',',$examIds).") and student_id in(".implode(',',$studentIds).") ")->execute();

            $trans->commit();
            $rs = true;
        }
        catch(Exception $e){
            $trans->rollBack();
            $rs = false;
        }

        return $rs;

    }


    //读取全部学生id
    public function getStudentPaperByExamIds($examIds){
        if(!$examIds || !is_array($examIds)) return false;
        $rs = $this->sConn->createCommand("select student_id from  student_paper_relation  where exam_id in(".implode(',',$examIds).") and is_feedback=0 and is_del=0 ")->queryAll();
        return $rs;
    }


    //读取一条学期数据，判断是否新学校
    public function getOneSemester(){
        $semester= $this->sConn->createCommand("select semester_id from semester  limit 1")->queryRow();
        return $semester;
    }

    //根据学校准考证号读取学生数据
    public function getStudentInfoBySchoolCard($schoolStudentCard,$schoolId,$semesterId){
        $students=$this->conn->createCommand("select student_id from `student` where school_student_card='".$schoolStudentCard."' and school_id='".$schoolId."'")->queryAll();
        $result=array();
        if($students){
            foreach ($students as $key => $val){
                $sql="SELECT si.student_id,si.realname,scr.class_id FROM `student_info` si ";
                $sql.="join student_class_relation scr on scr.student_id=si.student_id ";
                $sql.="join class c on c.class_id = scr.class_id ";
                $sql.="where scr.status=0 and si.student_id='".$val['student_id']."' and c.semester_id='".$semesterId."' ";
                $data=$this->sConn->createCommand($sql)->queryRow();
                if($data){
                    $result[]=$data;
                }
            }
        }
        return $result;
    }
    //根据学校准考证号读取学生数据
    public function getStudentIdBySchoolCard($schoolStudentCard,$schoolId){
        $students=$this->conn->createCommand("select student_id from `student` where school_student_card='".$schoolStudentCard."' and school_id='".$schoolId."'")->queryAll();
        return $students;
    }

    //获取教学进度
    public function getTeachProgress($sql = '', $pageSize = 10){
		$handle = $this->sConn->createCommand($sql)->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);

		if($rs["rs"]){



		}

		return $rs;
	}


    //根据班级id，统计学生数量
    public function getStudentIdByClassId($classId){
        if(!$classId) return 0;
        $result=array();
        $data=$this->sConn->createCommand("select `student_id`  from student_class_relation where class_id='".$classId."' and `status`=0 ")->queryAll();

        if($data){
            foreach ($data as $val){
                $result[]=$val['student_id'];
            }
        }
        return $result;

    }
    //统计家长绑定数量
    public function countBindStudentIds($studentIds,$schoolId){
        if(!$studentIds || !is_array($studentIds)) return false;
        if(!$schoolId) return false;
        $sql="select count(parent_id) as count from wx_parent_student where student_id in(".implode(',',$studentIds).") and school_id ='".$schoolId."' ";
        $sql="SELECT * from (SELECT parent_id,student_id,school_id from wx_parent_student where school_id='".$schoolId."' and student_id in(".implode(',',$studentIds).") ) t group by student_id;";
        $data=Yii::app()->db251->createCommand($sql)->queryAll();
        return count($data);
    }
    //根据学生id，读取家长信息
    public function getParentByStudentIds($studentIds,$schoolId){
	    if(!$studentIds || !is_array($studentIds)) return false;
	    if(!$schoolId) return false;

	    $result=array();
        $sql="select pt.student_id,pu.mobile,pt.create_time,pt.type,pt.parent_id,pt.bind_type from `wx_parent_student` pt join wx_parent_user pu on pt.parent_id=pu.user_id ";
        $sql.=" where pt.school_id='".$schoolId."' and pt.student_id in (".implode(',',$studentIds).") order by `type` asc";

        $data=Yii::app()->db251->createCommand($sql)->queryAll();
        if($data){
            foreach ($data as $val){
                $val['mobile']=substr_replace($val['mobile'],'****',3,4);
                $result[$val['student_id']][]=$val;
            }
        }

        return $result;
    }
    //家长端解除绑定
    public function UnbindZl($parentId,$studentId,$schoolId){
        if(!$parentId || !$schoolId || !$studentId) return false;
        $sql="delete from `wx_parent_student` where school_id='".$schoolId."' and parent_id='".$parentId."' and student_id='".$studentId."'";
        if(Yii::app()->db251->createCommand($sql)->execute()){
            return true;
        }
        return false;
    }
    //加载教师
    public function loadTeacher($keyword,$subject){

        $where=array();
        $where[]="status=0 ";
	    if($subject){
            $where[]=" subjects='{$subject}'";
        }
        if($keyword){
            $where[]=" teacher_name like '".$keyword."%' ";
        }

        $sql="select teacher_id,teacher_name,subjects,posts from `teacher` where ".implode(' and ',$where);

        $data=$this->sConn->createCommand($sql)->queryAll();
        return $data;
    }

    //获取教师信息
    public function getTeachersByTeacherIds($teachersIds){
        if(!is_array($teachersIds) || !$teachersIds)
            return array();

        $teachersIds = "'".implode("','", $teachersIds)."'";

        return $this->sConn->createCommand("select teacher_name,subjects,status from teacher where teacher_id in({$teachersIds})")->queryAll();
    }


    //读取学校报名数据
    public function getSignUpBySchoolIdTaskId($schoolId,$taskId){
	    if(!$schoolId || !$taskId) return null;
        return $this->conn->createCommand("select uesn_id,teacher_id,school_id,user_name,mobile from united_exam_signup where school_id='".$schoolId."' and tk_exam_id='".$taskId."'")->queryRow();
    }
    //报名
    public function SignUp($data){
	    if(!$data || !is_array($data)) return false;
	    $sql="insert into united_exam_signup set ";
	    $setValue=array();
	    foreach ($data as $field => $value){
            $setValue[]="`{$field}` = '".$value."'";
        }
        $sql.=implode(',',$setValue);
	    return $this->conn->createCommand($sql)->execute();
    }

    //退出 报名
    public function SignOutBySchoolIdTaskId($schoolId,$taskId){
        if(!$schoolId || !$taskId) return null;
        return $this->conn->createCommand("delete from united_exam_signup where school_id='".$schoolId."' and tk_exam_id='".$taskId."'")->execute();
    }

    //根据考试id，读取联考数据
    public function getUnitedByExamGroupId($exam_group_id){
	    if(!$exam_group_id) return false;
	    $sql="SELECT uea.paper_template_url,uea.answer_template_url,uea.apply_deadline,uea.branch FROM `united_exam` ue ";
	    $sql.=" join united_exam_apply uea on uea.task_exam_id=ue.tk_exam_id";
	    $sql.=" where ue.exam_group_id='".$exam_group_id."'";
        return $this->conn->createCommand($sql)->queryRow();
    }

    //查询是否有联考数据
    public function getUnitedList($apply_setting_type){
	    $time=time();
        if($apply_setting_type==1){
            $sql="select task_exam_id,exam_name,grade,branch,create_time,apply_deadline,exam_time from united_exam_apply where apply_deadline>'".$time."' and apply_setting_type=1";
        }else{
            $sql="select task_exam_id,exam_name,grade,branch,create_time,apply_deadline,exam_time from united_exam_apply where apply_deadline>'".$time."' ";
        }
        return $this->conn->createCommand($sql)->queryAll();
    }
    //查询联考
    public function getUnitedByTaskExamId($task_exam_id){
	    if(!$task_exam_id) return false;
        $sql="select task_exam_id,exam_name,grade,branch,create_time,apply_deadline,exam_time from united_exam_apply where task_exam_id='".$task_exam_id."'";
        return $this->conn->createCommand($sql)->queryRow();
    }

    //根据联考id,查询是否创建考试
    public function getExamByTaskId($task_exam_id){
        if(!$task_exam_id) return false;
        $sql="select exam_group_id from united_exam where tk_exam_id='".$task_exam_id."' limit 1";
        return $this->conn->createCommand($sql)->queryRow();
    }


    //查询是否有联考数据
    public function getAllUnitedList($apply_setting_type){
        $time=time();
        if($apply_setting_type==1){
            $sql="select task_exam_id,exam_name,grade,branch,create_time,apply_deadline,exam_time from united_exam_apply where  apply_setting_type=1";
        }else{
            $sql="select task_exam_id,exam_name,grade,branch,create_time,apply_deadline,exam_time from united_exam_apply  ";
        }
        return $this->conn->createCommand($sql)->queryAll();
    }

    //按学生准考证长度判断
    public function getStudentByCardLength($studentIds,$cardLength){
	    if(!$studentIds || !is_array($studentIds)) return false;
	    if(!is_numeric($cardLength)) return false;
	    $sql="select student_id from student where student_id in(".implode(',',$studentIds).") and char_length(school_student_card)<>".$cardLength." limit 1";
        return $this->conn->createCommand($sql)->queryRow();
    }

    public function UUID_SHORT($length = 20)
    {
        $query  = $this->sConn->createCommand("SELECT UUID_SHORT() AS UUID_SHORT")->query()->read();
        $result = $query['UUID_SHORT'];

        if ($length AND is_int($length))
        {
            $result = substr($result, ($length * -1));
        }

        return $result;
    }

    public function getZlExamList($condition = array(), $orderBy = array("zl_create_time desc"), $pageSize = 9){
        $condition = Arr::merge($condition, array("c.semester_id = '{$this->semester["id"]}'"));
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);

        $handle = $this->sConn->createCommand("
			select c.class_name,e.zl_exam_id,eg.zl_exam_group_id,e.zl_class_id, eg.zl_exam_name as exam_name, e.zl_tpl_data, eg.zl_create_time, eg.zl_is_display
			from class as c
			join zl_exam as e on e.zl_class_id = c.class_id
			JOIN zl_exam_group eg ON eg.zl_exam_group_id = e.zl_exam_group_id
			{$condition}
			group by e.zl_class_id, e.zl_exam_id
			{$orderBy}
		")->query();

        $rs = $this->paging($this->sConn, $handle, $pageSize);


        $ZlStudentExamRelation=new ZlStudentExamRelation();
        $ZlStudentExamRs=new ZlStudentExamRs();
        if($rs['rs']){
            foreach($rs['rs'] as $key => $val){
                $allStudent=$ZlStudentExamRelation->getCountStudentByExamGroupId($val['zl_exam_group_id'],$val['zl_exam_id']);
                $allStudentRs=$ZlStudentExamRs->getCountStudentRsByExamGroupId($val['zl_exam_group_id'],$val['zl_exam_id']);
                $rs['rs'][$key]['is_uploaded_count']=$allStudentRs;
                $rs['rs'][$key]['students_count']=$allStudent;
            }
        }

        return $rs;
    }


    public function getEnglishWeek($condition = array(), $orderBy = array("ew.create_time desc"), $pageSize = 10){
		$condition = Arr::merge($condition, array("ew.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$handle = $this->sConn->createCommand("
			select ew.week_id,ew.set_id,ew.`name`,c.class_name,ew.week_group_id,ews.is_new_version from english_week ew join english_week_setting ews on ews.id=ew.set_id join class c on ew.class_id = c.class_id
			{$condition}
			group by ew.week_id
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);
                if($rs['rs']){
                    foreach($rs['rs'] as $k=>$v){
                        $rs['rs'][$k]['totalCount'] = 0;
                        $rs['rs'][$k]['pdfCount'] = 0;
                        $rs['rs'][$k]['isDown'] = 0;
                        $rs['rs'][$k]['downTime'] = '';
                        $week_id = $v['week_id'];
                        $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_week_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from english_week_student where student_id > 0 and week_id = '{$week_id}'";
                        $countArr = $this->sConn->createCommand($sql)->queryRow();
                        if($countArr){
                            $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount'])?$countArr['totalCount']:0;
                            $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount'])?$countArr['pdfCount']:0;
                        }
                        $sql = "select week_download_time from english_week_student where student_id > 0 and week_id = '{$week_id}' and is_week_download = 1 order by week_download_time desc limit 1";
                        $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                        if($isDownArr){
                            $rs['rs'][$k]['isDown'] = 1;
                            $rs['rs'][$k]['downTime'] = isset($isDownArr['week_download_time'])?date("Y-m-d H:i",$isDownArr['week_download_time']):'';
                        }
                    }
                }

		return $rs;
	}

        public function getEnglishMonth($condition = array(), $orderBy = array("em.create_time desc"), $pageSize = 10){
		$condition = Arr::merge($condition, array("em.semester_id = '{$this->semester["id"]}'"));
		$condition = $this->condition($condition);

		$orderBy = $this->orderBy($orderBy);
		$handle = $this->sConn->createCommand("
			select em.month_id,em.`name`,c.class_name from english_month em join class c on em.class_id = c.class_id
			{$condition}
			group by em.month_id
			{$orderBy}
		")->query();

		$rs = $this->paging($this->sConn, $handle, $pageSize);
                if($rs['rs']){
                    foreach($rs['rs'] as $k=>$v){
                        $rs['rs'][$k]['totalCount'] = 0;
                        $rs['rs'][$k]['pdfCount'] = 0;
                        $rs['rs'][$k]['isDown'] = 0;
                        $rs['rs'][$k]['downTime'] = '';
                        $month_id = $v['month_id'];
                        $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_month_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from english_month_student where month_id = '{$month_id}'";
                        $countArr = $this->sConn->createCommand($sql)->queryRow();
                        if($countArr){
                            $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount'])?$countArr['totalCount']:0;
                            $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount'])?$countArr['pdfCount']:0;
                        }
                        $sql = "select download_time from english_month_student where month_id = '{$month_id}' and is_download = 1 order by download_time desc limit 1";
                        $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                        if($isDownArr){
                            $rs['rs'][$k]['isDown'] = 1;
                            $rs['rs'][$k]['downTime'] = isset($isDownArr['download_time'])?date("Y-m-d H:i",$isDownArr['download_time']):'';
                        }
                    }
                }

		return $rs;
	}

	//导出报告列表


    public function getExportList($condition = array(), $orderBy = array("add_time desc"), $pageSize = 9){
        $condition = Arr::merge($condition, array("e.semester_id = '{$this->semester["id"]}'"));
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $handle = $this->sConn->createCommand("
			select e.is_academicr_pdf,e.academicr_pdf_path,e.is_topwb_pdf,e.is_new,e.is_topwb_html,  e.name as exam_name, e.tpl_index, e.tpl_data, e.upload_status, e.create_time,e.exam_group_id, e.is_display,e.complete_time,e.is_topwb_pdf,e.topwb_pdf_path,e.topwb_pdf_time,e.is_academicr_pdf, eg.mark_type, eg.mark_status,eg.upload_status as group_upload_status,e.subject_id,
				eg.is_third,c.grade,e.status
			from exam as e
			join class as c on e.class_id=c.class_id
			JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id
			{$condition}
	        group by exam_group_id
			{$orderBy}
		")->query();

        $rs = $this->paging($this->sConn, $handle, $pageSize);

        return $rs;
    }

    //读取班级列表
    public function getExportClassByExamGroupId($examGroupId){
	    if(!$examGroupId) return false;
	    $sql="SELECT e.is_topwb_pdf,e.class_id,class_name,e.exam_id,e.name,e.status,e.upload_status FROM `exam` e join class c on c.class_id=e.class_id where e.exam_group_id='{$examGroupId}'";
        return $this->sConn->createCommand($sql)->queryAll();
    }


    //获取试卷大题关联表数据
    public function getPaperLargeTopicsRecords($paperId){
        $records = array();

        if($paperId){
            $records = $this->sConn->createCommand("select * from paper_topic_large where paper_id = '{$paperId}'")->queryAll();
        }

        return $records;
    }



    //读取走班设置
    public function getClassShift($semester,$subjectId=0){
	    if(!$semester) return null;
	    if($subjectId){
            $sql="select grade,subject_id,status from classified where semester_id='{$semester}' and subject_id='{$subjectId}'";
        }else{
            $sql="select grade,subject_id,status from classified where semester_id='{$semester}'";
        }
	    return $this->sConn->createCommand($sql)->queryAll();
    }

    //查询走班设置
    public function getClassifiedBySubject($grade,$subject,$semester){
        if(!$semester || !$grade || !$subject) return null;
        $sql="select grade,subject_id,status from classified where semester_id='{$semester}' and grade='{$grade}' and subject_id='{$subject}'";
        return $this->sConn->createCommand($sql)->queryRow();
    }
    //添加走班记录
    public function insertClassified($data){
	    if(!$data || !is_array($data)) return false;
	    $sql="insert into classified(`grade`,`subject_id`,`status`,`semester_id`) values ";
        $values=array();
	    foreach ($data as $val){
            $values[]="('".$val['grade']."','".$val['subject_id']."','".$val['status']."','".$val['semester_id']."')";
        }
        $sql.=implode(',',$values);
        return $this->sConn->createCommand($sql)->execute();
    }
    //更新记录状态
    public function updateClassifiedBySubject($grade,$subject,$semester,$type){
        if(!$semester || !$grade || !$subject || !$type) return false;
        if($type=='enable'){
            $sql="update classified set status=1 where semester_id='{$semester}' and grade='{$grade}' and subject_id='{$subject}'";
        }elseif($type=='disable'){
            $sql="update classified set status=0 where semester_id='{$semester}' and grade='{$grade}' and subject_id='{$subject}'";
        }else{
            return false;
        }
        return $this->sConn->createCommand($sql)->execute();
    }

    //根据年级查询学科
    public function getSubjectByGrade($grade=0,$subjectId=0,$semester){
	    if(!$semester) return null;
	    if($grade){
	        if($subjectId){
                $sql="select subject_id from classified where grade='{$grade}' and semester_id='{$semester}' and status=1 and subject_id='".$subjectId."'";
            }else{
                $sql="select subject_id from classified where grade='{$grade}' and semester_id='{$semester}' and status=1";
            }

        }else{
            if($subjectId){
                $sql="select subject_id from classified where semester_id='{$semester}' and status=1 and subject_id='".$subjectId."'";
            }else{
                $sql="select subject_id from classified where semester_id='{$semester}' and status=1 ";
            }

        }

        return $this->sConn->createCommand($sql)->queryAll();
    }

    public function DelClassSubject($classId){
        if(!$classId)
            return false;

        return $this->sConn->createCommand("delete from class_subject_relation where class_id = '{$classId}'")->execute();

    }

    //读取班级科目
    public function getSubjectByClass($classId,$type='Name'){
        if(!$classId) return null;
        $sql="select subject_id from class_subject_relation where class_id='{$classId}' ";
        $data = $this->sConn->createCommand($sql)->queryAll();
        $result=array();
        if($data){

            foreach ($data as $val){
                if($val['subject_id']){
                    if($type=='Name'){
                        $result[$val['subject_id']]=Yii::app()->params['subjectId'][$val['subject_id']];
                    }else{
                        $result[]=$val['subject_id'];
                    }
                }
            }
        }

        return $result;
    }

    //获取已走班学生
    public function getStudentBySubjects($subjects,$grade,$semester){
        if(!$subjects || !$semester || !$grade) return null;

        $studentIds=array();
        $classSql="SELECT c.class_id,c.class_name FROM `class` c ";
        $classSql.=" left join class_subject_relation csr on csr.class_id= c.class_id ";
        $classSql.=" where c.class_type=2 and csr.subject_id in(".implode(',',$subjects).") and semester_id='".$semester."' and grade='{$grade}'";
        $classData=$this->sConn->createCommand($classSql)->queryAll();

        $classIds=array();
        if($classData){
            foreach ($classData as $v){
                $classIds[$v['class_id']]=$v['class_id'];
            }

            $sql="select student_id from student_class_relation where class_id in(".implode(',',$classIds).") and status=0";
            $studentData=$this->sConn->createCommand($sql)->queryAll();
            if($studentData){
                foreach ($studentData as $val){
                    $studentIds[]=(string)$val['student_id'];
                }
            }
        }
        return $studentIds;
    }

    //根据姓名，查询未走班学生
    public function getClassifiedStudentByName($realName,$subjects,$grade,$semester){
        if(!$subjects || !$semester || !$grade || !$realName) return null;
	    $result=array();
        $studentData=$this->sConn->createCommand("select student_id,realname from student_info where realname like '%".$realName."%'")->queryAll();

        if($studentData){
            foreach ($studentData as $val){
                //查询班级
                $classData=$this->sConn->createCommand("select class_id,class_type from student_class_relation where student_id ='".$val['student_id']."' and status=0 ")->queryAll();
                if($classData){
                    $flag=true;
                    foreach ($classData as $v){
                        $classInfo=  $this->getClassInfo($v['class_id']);
                        if(strcmp($semester,$classInfo['semester_id'])!=0){
                            $flag=false;
                            break;
                        }
                        if($grade!=$classInfo['grade']){
                            $flag=false;
                            break;
                        }
                        if($v['class_type']==2){
                            $classSubjects=$this->getSubjectByClass($v['class_id']);
                            foreach ($classSubjects as $subjectId =>$subjectName){
                                if(in_array($subjectId,$subjects)){
                                    $flag=false;
                                    break;
                                }
                            }
                        }

                    }
                    if($flag){
                        //查询系统准考证
                        $studentInfo=$this->conn->createCommand("select student_card from student where student_id='{$val['student_id']}'")->queryRow();
                        if($studentInfo){
                            $val['realname']=$val['realname'].'('.$studentInfo['student_card'].')';
                        }
                        $result[]=$val;
                    }
                }
            }
        }
        return $result;
    }

    //查询指定班级内相似姓名学生
    public function searchStudentByClassIdsStudentName($classIds,$studentName,$excludeStudentIds=array()){
	    if(!$classIds || !is_array($classIds) || !$studentName) return null;

	    $sql="select si.student_id,si.realname,scr.class_id from student_info si ";
	    $sql.=" join student_class_relation scr on scr.student_id=si.student_id ";
	    $sql.=" where scr.class_id in(".implode(',',$classIds).") and si.realname like '%".$studentName."%'";

	    $result=array();
	    $data=$this->sConn->createCommand($sql)->queryAll();
	    if($data){
	        foreach ($data as $val){
	            if($excludeStudentIds && in_array((string)$val['student_id'],$excludeStudentIds,true)){
	                continue;
                }
	            $studentCard=$this->conn->createCommand("select student_card from student where student_id='".$val['student_id']."'")->queryRow();
	            if($studentCard){
                    $result[$val['student_id']]=array(
                        'realname'=>$val['realname'].'('.$studentCard['student_card'].')',
                        'class_id'=>$val['class_id'],
                        'student_id'=>$val['student_id']
                    );
                }

            }
        }
        return $result;
    }

    //添加走班学生
    public function addClassifiedStudent($studentIds,$classId){

        $subjects=$this->getSubjectByClass($classId); //本班级科目
        $sql="replace into student_class_relation(`class_id`,`serial_number`,`student_id`,`status`,`update_time`,`operation`,`class_type`) values ";
        $values=array();
        $serialNumber=array();
        foreach ($studentIds as $student_id){
            //查询已有走班记录
            $classRelation=$this->sConn->createCommand("select class_id from student_class_relation where student_id='{$student_id}' and status=0 and class_type=2")->queryAll();
            if($classRelation){
                foreach ($classRelation as $class_id){
                    $classSubject=$this->getSubjectByClass($class_id['class_id'],'ID');
                    if(array_intersect($classSubject,$subjects)){
                        //已经有相关科目的走班记录
                        return -1;
                    }
                }
            }
            //查询新班级最大序号
           if(!isset($serialNumber[$classId])){
               $newClass=$this->sConn->createCommand("select serial_number from student_class_relation where class_id='{$classId}' order by serial_number desc limit 1")->queryRow();
               if($newClass ){
                   $serialNumber[$classId]=intval($newClass['serial_number'])+1;
               }else{
                   $serialNumber[$classId]=1;
               }
           }else{
               $serialNumber[$classId]++;
           }

            $values[]="('".$classId."','".$serialNumber[$classId]."','".$student_id."',0,'".time()."',2,2)";
        }


        if($values){
            $sql.=implode(',',$values);
            $rs=$this->sConn->createCommand($sql)->execute();
        }
        return $rs;
    }

    //教学班转班
    public function copyClassified($toClassId,$studentData){
        if(!$toClassId || !$studentData) return false;

        //查询目标班级
        $classSubjects=$this->getSubjectByClass($toClassId,'ARR');

        //取消原所在班级关系
        $updateOldClass=array();
        $insertNewClass=array();
        //查询新班级最大序号
        $serialNumber=1;
        $newClass=$this->sConn->createCommand("select serial_number from student_class_relation where class_id='{$toClassId}' order by serial_number desc limit 1")->queryRow();

        if($newClass){
            $serialNumber=intval($newClass['serial_number'])+1;
        }
        foreach ($studentData as $studentId => $classId){
            $updateOldClass[]="update student_class_relation set status=1,operation=2 where class_id='{$classId}' and student_id='{$studentId}'";

            //查询学生原科目
            $sql="select c.class_id,csr.subject_id,scr.student_id,scr.`status` from class c";
            $sql.=" join class_subject_relation csr on csr.class_id=c.class_id ";
            $sql.="join student_class_relation scr on scr.class_id=c.class_id";
            $sql.=" where   scr.`status`=0 and scr.student_id='{$studentId}' and csr.subject_id in(".implode(',',$classSubjects).") and c.class_type=2 ";
            $repeatSubjectData=$this->sConn->createCommand($sql)->queryAll();
            //取消学生原科目与目标班科目冲突关系
            if($repeatSubjectData){
                foreach ($repeatSubjectData as $v){
                    $updateOldClass[]="update student_class_relation set status=1,operation=2 where class_id='".$v['class_id']."' and student_id='{$studentId}'";
                }
            }

            //加入新班级
            $insertNewClass[]="('".$toClassId."','".$studentId."',0,'".$serialNumber."',0,'".time()."',2,2)";
            $serialNumber++;
        }

        $trans = $this->sConn->beginTransaction();
        try{

            if($updateOldClass){
                foreach ($updateOldClass as $v){
                    $this->sConn->createCommand($v)->execute();
                }
            }
            if($insertNewClass){
                $insertSql="insert into student_class_relation(`class_id`,`student_id`,`status`,`serial_number`,`userno`,`update_time`,`operation`,`class_type`) values ";
                $insertSql.=implode(',',$insertNewClass);
                $this->sConn->createCommand($insertSql)->execute();
            }

            $trans->commit();
            $rs = true;
        }
        catch(Exception $e){
            $trans->rollBack();
            $rs = false;
        }

        return $rs;

    }

    //根据班级，姓名 读取教学班学生数据
    public function getStudentByNameClassified($studentName,$semesterIds){
        if(!$studentName || !$semesterIds){
            return null;
        }

        $sql="SELECT si.student_id,si.realname,si.class_id,c.semester_id,c.class_name,c.grade FROM `student_info` si ";
        $sql.="join student_class_relation scr on scr.student_id=si.student_id ";
        $sql.="join class c on c.class_id = scr.class_id ";
        $sql.="where  si.realname='{$studentName}' and  scr.status=0 and scr.class_type=2";

        if(is_array($semesterIds)){
            $sql.=" and semester_id in(".implode(',',$semesterIds).")";
        }else{
            $sql.=" and semester_id ='{$semesterIds}'";
        }

        $student=$this->sConn->createCommand($sql)->queryAll();

        return $student;
    }

    //根据科目读取教学班
    public function getClassifiedBySubjectId($grade,$subjectId,$semesterId){
	    $sql="select c.class_id,c.class_name from class c ";
	    $sql.="join class_subject_relation csr on csr.class_id=c.class_id ";
	    $sql.=" where c.grade='".$grade."' and csr.subject_id='".$subjectId."' and c.semester_id='".$semesterId."'";

	    return $this->sConn->createCommand($sql)->queryAll();
    }
    public function getClassIdBySubjectId($subjectId,$semesterId=0){
        $sql="select c.class_id,c.class_name from class c ";
        $sql.="join class_subject_relation csr on csr.class_id=c.class_id ";
        $sql.=" where  csr.subject_id='".$subjectId."'";
        if($semesterId){
            $sql.="  and c.semester_id='".$semesterId."'";
        }
        $classIds=array();
        $data=$this->sConn->createCommand($sql)->queryAll();
        if($data){
            foreach ($data as $val){
                $classIds[]=$val['class_id'];
            }
        }
        return $classIds;
    }
    //
    public function checkClassifiedSubject($subjectId,$classId){
	    if(!$subjectId || !$classId) return false;
	    $sql="select exists(select subject_id from class_subject_relation where class_id='{$classId}' and subject_id='{$subjectId}')";
        $rs = $this->sConn->createCommand($sql)->queryRow();
        $rs = current($rs);

        return $rs ? true : false;
    }



    public function getMathWeek($condition = array(), $orderBy = array("mrs.create_time desc"), $pageSize = 10){
        $condition = Arr::merge($condition, array("mrs.semester_id = '{$this->semester["id"]}'"));
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $handle = $this->sConn->createCommand("
			select mrs.mr_id,special_id,name,c.grade,c.class_id,c.class_name from math_review_setting mrs join class c on mrs.class_id= c.class_id
			{$condition}
			group by mrs.mr_id
			{$orderBy}
		")->query();

        $rs = $this->paging($this->sConn, $handle, $pageSize);
        if($rs['rs']){
            foreach($rs['rs'] as $k=>$v){
                $rs['rs'][$k]['totalCount'] = 0;
                $rs['rs'][$k]['pdfCount'] = 0;
                $rs['rs'][$k]['isDown'] = 0;
                $rs['rs'][$k]['downTime'] = '';
                $mr_id=$v['mr_id'];
                $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_review_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from math_review_student where mr_id = '{$mr_id}'";

                $countArr = $this->sConn->createCommand($sql)->queryRow();
                if($countArr){
                    $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount'])?$countArr['totalCount']:0;
                    $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount'])?$countArr['pdfCount']:0;
                }
                $sql = "select review_download_time from math_review_student where mr_id = '{$mr_id}' and is_review_download = 1 order by review_download_time desc limit 1";
                $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                if($isDownArr){
                    $rs['rs'][$k]['isDown'] = 1;
                    $rs['rs'][$k]['downTime'] = isset($isDownArr['review_download_time'])?date("Y-m-d H:i",$isDownArr['review_download_time']):'';
                }
            }
        }

        return $rs;
    }

	public function getStudentByExamIds($examsIds,$page,$pageSize){
		if(!$examsIds) return null;
		$offset=($page-1)*$pageSize;


		$query=$this->sConn->createCommand("select count(*) as count from student_paper_relation where exam_id in(".implode(',',$examsIds).") and is_feedback=0  ")->queryRow();
		$total=$query['count'];
		$pages=ceil($total/$pageSize);

		$sprs = $this->sConn->createCommand("select student_id,student_card from student_paper_relation where exam_id in(".implode(',',$examsIds).") and is_feedback=0 limit {$offset},{$pageSize} ")->queryAll();
		$data['pageTotal']=$pages;
		$data['page']=$page;
		$data['list']=$sprs;
        $data['pageSize']=$pageSize;
		return $data;
	}

	public function getAllStudentByExamIds($examsIds){
		if(!$examsIds) return null;

		$sprs = $this->sConn->createCommand("select student_id,student_card from student_paper_relation where exam_id in(".implode(',',$examsIds).") and is_feedback=0  ")->queryAll();

        if($sprs){
            foreach($sprs as $key =>$val){
                $StudentInfo=$this->sConn->createCommand("select realname from `student_info` where student_id='".$val['student_id']."' ")->queryRow();
                if($StudentInfo){

                    $sprs[$key]['realname']=$StudentInfo['realname'];
                }
            }
        }
		return $sprs;
	}

	//读取在线答题卡

    public function getAnswerSheetOnline($examGroupId){
        if(!$examGroupId || !is_numeric($examGroupId)){
            return null;
        }

        $rs=$this->sConn->createCommand("select online_card,is_qrcode_online,file_path,multiplex_id from `third_answer_sheet` where exam_group_id='{$examGroupId}' and online_card=1")->queryRow();
        return $rs;
    }
    /**
     * 英语外刊美文产品列表
     */
    public function getEnglishReading($condition = array(), $orderBy = array("er.create_time desc"), $pageSize = 10){
            $condition = Arr::merge($condition, array("er.semester_id = '{$this->semester["id"]}'"));
            $condition = $this->condition($condition);

            $orderBy = $this->orderBy($orderBy);
            $handle = $this->sConn->createCommand("
                    select er.week_id,er.reading_id,er.`name`,c.class_name,ers.type,ers.level,ers.recommend_mode,ers.product_type from english_reading er join class c on er.class_id = c.class_id join english_reading_setting ers on er.reading_id = ers.reading_id
                    {$condition}
                    group by er.week_id
                    {$orderBy}
            ")->query();

            $rs = $this->paging($this->sConn, $handle, $pageSize);
            if($rs['rs']){
                foreach($rs['rs'] as $k=>$v){
                    $rs['rs'][$k]['totalCount'] = 0;
                    $rs['rs'][$k]['pdfCount'] = 0;
                    $rs['rs'][$k]['isDown'] = 0;
                    $rs['rs'][$k]['downTime'] = '';
                    $rs['rs'][$k]['type_name'] = '';
                    $rs['rs'][$k]['recommend_mode_name'] = '';
                    $rs['rs'][$k]['product_type_name'] = '';
					if($v['recommend_mode']==1){
						$rs['rs'][$k]['recommend_mode_name']='经典模式';
					}elseif($v['recommend_mode']==2){
						$rs['rs'][$k]['recommend_mode_name']='智能推荐模式';
					}
					if($v['product_type']==1){
						$rs['rs'][$k]['product_type_name']='基础宝';
					}elseif($v['product_type']==2){
						$rs['rs'][$k]['product_type_name']='外刊宝';
					}elseif($v['product_type']==3){
						$rs['rs'][$k]['product_type_name']='热点宝';
					}
                    if($v['type'] == 1){
                        $rs['rs'][$k]['type_name'] = '（个性外刊)';
                    }else if($v['type'] == 2){
                        if($v['level'] == 1){
                            $rs['rs'][$k]['type_name'] = '（共性外刊-尖子班）';
                        }else if($v['level'] == 2){
                            $rs['rs'][$k]['type_name'] = '（共性外刊-培优班）';
                        }else if($v['level'] == 3){
                            $rs['rs'][$k]['type_name'] = '（共性外刊-提高班）';
                        }
                    }
                    $week_id = $v['week_id'];
                    $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_week_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from english_reading_student where week_id = '{$week_id}'";
                    $countArr = $this->sConn->createCommand($sql)->queryRow();
                    if($countArr){
                        $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount'])?$countArr['totalCount']:0;
                        $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount'])?$countArr['pdfCount']:0;
                    }
                    $sql = "select week_download_time from english_reading_student where week_id = '{$week_id}' and is_week_download = 1 order by week_download_time desc limit 1";
                    $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                    if($isDownArr){
                        $rs['rs'][$k]['isDown'] = 1;
                        $rs['rs'][$k]['downTime'] = isset($isDownArr['week_download_time'])?date("Y-m-d H:i",$isDownArr['week_download_time']):'';
                    }
                }
            }

            return $rs;
    }

    /**
     * 假期报告列表
     */
    public function getHolidayReport($condition = array(), $orderBy = array("hrs.create_time desc"), $pageSize = 10){
            $condition = $this->condition($condition);

            $orderBy = $this->orderBy($orderBy);
            $handle = $this->sConn->createCommand("
                    select hrs.report_id,hrs.report_group_id,c.class_name,hrs.semester_id,s.semester_name,hrs.create_time,hrs.reset_times,hrs.class_id,hrs.reset_time from holiday_report_setting hrs join class c on hrs.class_id = c.class_id join semester s on s.semester_id= hrs.semester_id
                    {$condition}
                    group by hrs.report_id
                    {$orderBy}
            ")->query();

            $rs = $this->paging($this->sConn, $handle, $pageSize);
            if($rs['rs']){
                $rs['is_all_pdf'] = 1;//是否全部生成pdf
                $rs['create_time'] = 0;//创建时间
                $create_time_arr = array();
                $reset_time_arr = array();
                foreach($rs['rs'] as $k=>$v){
                    $rs['create_time'] = $v['create_time']?$v['create_time']:0;
                    if($v['create_time']){
                        $create_time_arr[] = $v['create_time'];
                    }
                    if($v['reset_time']){
                        $reset_time_arr[] = $v['reset_time'];
                    }
                    $rs['rs'][$k]['totalCount'] = 0;
                    $rs['rs'][$k]['pdfCount'] = 0;
                    $rs['rs'][$k]['isDown'] = 0;
                    $rs['rs'][$k]['downTime'] = '';
                    $rs['rs'][$k]['report_name'] = $v['class_name'].$v['semester_name'].'假期总结报告';
                    $rs['rs'][$k]['create_time'] = $v['reset_time']?date('Y-m-d',$v['reset_time']):date('Y-m-d',$v['create_time']);
                    $report_id = $v['report_id'];
                    $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_report_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from holiday_report_student where report_id = '{$report_id}'";
                    $countArr = $this->sConn->createCommand($sql)->queryRow();
                    if($countArr){
                        $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount'])?$countArr['totalCount']:0;
                        $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount'])?$countArr['pdfCount']:0;
                    }
                    if($rs['is_all_pdf']){
                        if($rs['rs'][$k]['totalCount'] && $rs['rs'][$k]['pdfCount'] != $rs['rs'][$k]['totalCount']){
                            $rs['is_all_pdf'] = 0;
                        }else{
                            $rs['is_all_pdf'] = 1;
                        }
                    }
                    $sql = "select report_download_time from holiday_report_student where `report_id` = '{$report_id}' and is_report_download = 1 order by report_download_time desc limit 1";
                    $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                    if($isDownArr){
                        $rs['rs'][$k]['isDown'] = 1;
                        $rs['rs'][$k]['downTime'] = isset($isDownArr['report_download_time'])?date("Y-m-d H:i",$isDownArr['report_download_time']):'';
                    }
                }

                if($reset_time_arr){
                    $rs['create_time'] = max($reset_time_arr);
                }else{
                    if($create_time_arr){
                        $rs['create_time'] = max($create_time_arr);
                    }
                }
            }

            return $rs;
    }

    /**
     * 根据条件获取班级
     */
    public function getClassesByCondition($condition = array(),$orderBy = array()){
        $classes = array();
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $classes = $this->sConn->createCommand("select * from class{$condition} group by class_id{$orderBy}")->queryAll();
        return $classes;
    }
    /**
     * 批量插入假期报告学生
     */
    public function batchInsetHolidayReport($schoolId,$semesterId,$is_current_semester,$is_qxk_school=0){
        $data = array();
        $data['status'] = 0;
        $data['error'] = '创建失败';
        $new_report_ids = array();
        $time = time();
//        $classIds = $this->getClassesByCondition(array('semester_id='.$semesterId,'class_type=1','is_hide=0'),array());
        $classIds = $this->getClassesByCondition(array('semester_id='.$semesterId,'class_type=1'),array());
        $is_qxk_school = $is_qxk_school?1:0;
        if(!$classIds){
            $data['error'] = '暂无班级';
            return $data;
        }else{
            $class_count = count($classIds);
            $report_ids = getBatchUuid($schoolId,$class_count);
            if($report_ids){
                $report_ids_values = array_values($report_ids);

                if(count($classIds) != count($report_ids)){
                    $data['error'] = '班级数量不符合';
                    return $data;
                }
                $i = 0;
                $classIds = array_values($classIds);
                foreach($classIds as $k=>$v){
                    if(isset($report_ids_values[$i]) && $report_ids_values[$i]){
                        $new_report_ids[$v["class_id"]] = $report_ids_values[$i];
                    }
                    $i++;
                }
            }else{
                $data['error'] = 'Id错误';
                return $data;
            }
        }
        if($is_current_semester){
            $sql = "select c.class_name,c.class_id,scr.student_id from class c join student_class_relation scr on c.class_id = scr.class_id where c.semester_id = '{$semesterId}' and c.class_type = 1 and scr.`status`=0 group by scr.student_id";
        }else{
            $sql = "select class_name,class_id,student_id from (select c.class_name,c.class_id,scr.student_id,scr.update_time from class c join student_class_relation scr on c.class_id = scr.class_id where c.semester_id = '{$semesterId}' and c.class_type = 1 order BY scr.update_time desc) a GROUP BY student_id order by update_time desc";
        }
        $student_data = $this->sConn->createCommand($sql)->queryAll();
        if(!$student_data){
            $data['error'] = '暂无学生';
            return $data;
        }
        $trans = $this->sConn->beginTransaction();
        try{
            $report_group_id = getUniqueId($schoolId);
            $insert_values = "";
            foreach($classIds as $class){
                if(isset($new_report_ids[$class["class_id"]]) && $new_report_ids[$class["class_id"]]){
                    $report_id = $new_report_ids[$class["class_id"]];
                    $insert_values .= "(".$report_group_id.",".$report_id.",".$class["grade"].",".$class["semester_id"].",".$class["class_id"].",".$time.",".$is_qxk_school."),";
                }
            }
            if($insert_values){
                $insert_sql = "insert into holiday_report_setting (report_group_id,report_id,grade,semester_id,class_id,create_time,is_qxk_school) values".substr($insert_values,0,-1).';';
                $this->sConn->createCommand($insert_sql)->execute();
            }


            if($student_data){
                $count = count($student_data);//需要插入的学生总数
                $limit = 3000;
                $page = ceil($count/$limit);
                for ($i=0; $i < $page; $i++) {
                    $values = '';
                    for ($j=$i*$limit; $j < ($i+1)*$limit; $j++) {
                        if($j > $count - 1){
                            continue;
                        }
                        if(isset($new_report_ids[$student_data[$j]['class_id']]) && $new_report_ids[$student_data[$j]['class_id']]){
                            //拼接values的值
                            $report_id_2 = $new_report_ids[$student_data[$j]['class_id']];
                            $values .= '('.$report_id_2.','.$student_data[$j]['class_id'].','.$student_data[$j]['student_id'].'),';
                        }

                    }
                    $values = "insert into holiday_report_student (report_id,class_id,student_id) values".substr($values,0,-1).';';
                    $this->sConn->createCommand($values)->execute();
                }
            }

            $trans->commit();
            $data['status'] = 1;
            $data['error'] = '创建成功';
        }
        catch(Exception $e){
            $trans->rollBack();
            $data['status'] = 0;
            $data['error'] = '创建失败';
        }
        return $data;
    }


    /**
     * 重置假期报告
     */
    public function resetReport($reportId,$classId,$is_current_semester,$is_qxk_school=0){
        $time = time();
        $status = false;
        $is_qxk_school = $is_qxk_school?1:0;
        $trans = $this->sConn->beginTransaction();
        try{
            //删除学生数据
            $sql = "delete from holiday_report_student where report_id = '{$reportId}'";
            $this->sConn->createCommand($sql)->execute();

            //学生数据
            if($is_current_semester){
                $sql = "select c.class_name,c.class_id,scr.student_id from class c join student_class_relation scr on c.class_id = scr.class_id where c.class_id = '{$classId}' and scr.`status`=0 group by scr.student_id" ;
            }else{
                $sql = "select student_id,update_time,class_id from (select student_id,update_time,class_id from student_class_relation where class_id = '{$classId}' order by student_id desc) a GROUP BY student_id order by update_time desc" ;
            }
            $student_data = $this->sConn->createCommand($sql)->queryAll();
            if($student_data){
                $count = count($student_data);//需要插入的学生总数
                $limit = 3000;
                $page = ceil($count/$limit);
                for ($i=0; $i < $page; $i++) {
                    $values = '';
                    for ($j=$i*$limit; $j < ($i+1)*$limit; $j++) {
                        if($j > $count - 1){
                            continue;
                        }
                        $values .= '('.$reportId.','.$student_data[$j]['class_id'].','.$student_data[$j]['student_id'].'),';

                    }
                    $values = "insert into holiday_report_student (report_id,class_id,student_id) values".substr($values,0,-1).';';
                    $this->sConn->createCommand($values)->execute();
                }
            }
            //更新设置表
            $sql = "update holiday_report_setting set is_all_html=90,school_group_id=0,reset_time={$time},reset_times= reset_times + 1,is_qxk_school={$is_qxk_school} where report_id = '{$reportId}'";
            $this->sConn->createCommand($sql)->execute();

            //重置后清除已存在的下载任务
            $this->conn->createCommand("delete from pack_product_task where school_id ={$this->schoolId} and unique_key= {$reportId} and product_type=8 and class_id={$classId} ")->execute();

            $trans->commit();
            $status = true;
        }
        catch(Exception $e){
            $trans->rollBack();
        }
        return $status;

    }

    /**
     * 批量重置
     */
    public function batchResetReport($semesterId,$is_qxk_school=0){
        $time = time();
        $status = false;
        $report_ids = array();
        $is_qxk_school = $is_qxk_school?1:0;
        $sql = "select report_id from holiday_report_setting where semester_id='$semesterId'";
        $report_data = $this->sConn->createCommand($sql)->queryAll();
        if($report_data){
            foreach($report_data as $k=>$v){
                $report_ids[] = $v['report_id'];
            }
        }
        $trans = $this->sConn->beginTransaction();
        try{
            if($report_ids){
                $sql = "update holiday_report_setting set is_all_html=90,reset_time={$time},school_group_id=0,is_qxk_school={$is_qxk_school} where semester_id = '{$semesterId}'";
                $this->sConn->createCommand($sql)->execute();
                $sql = "update holiday_report_student set is_report_html=90 where report_id in (".implode(",",$report_ids).")";
                $this->sConn->createCommand($sql)->execute();

                //重置后清除已存在的下载任务
                $task_sql = "delete from pack_product_task where school_id ={$this->schoolId} and unique_key in (". implode(",", $report_ids).") and product_type=8";
                $this->conn->createCommand($task_sql)->execute();
            }

            $trans->commit();
            $status = true;
        }catch(Exception $e){
            $trans->rollBack();
        }
        return $status;
    }

    /**
     * 假期报告获取班级
     */
    public function getClassesByHolidayReport($condition = array(),$orderBy = array())
    {
        $classes = array();
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $classes = $this->sConn->createCommand("select c.* from class c right join holiday_report_setting hrs on c.class_id=hrs.class_id{$condition} group by class_id{$orderBy}")->queryAll();
        return $classes;
    }

    //查询考试上传学生数量
    public function getStudentCountByExamGroupId($examGroupId,$hasFeedback=0){
        if(!$examGroupId){
            return null;
        }

        $result=array();
        $result['total']=0;         //总数
        $result['is_feedback']=0;   // 已扫描
        $result['is_del']=0;        //缺考
        $result['abnormal']=0;      //异常总量
        $result['complete']=0;      //完成数量
        $result['surplus']=0;       //剩余量
        $sql="select exam_id from exam where exam_group_id='{$examGroupId}'";
        $data=$this->sConn->createCommand($sql)->queryAll();
        $examIds=array();
        if($data){
            if($hasFeedback){
                foreach ($data as $val){
                    $examIds[]=$val['exam_id'];
                }

                $studentSql="select student_id,is_feedback,is_del from student_paper_relation where exam_id in(".implode(',',$examIds).")";
                $studentData=$this->sConn->createCommand($studentSql)->queryAll();

                if($studentData){
                    foreach ($studentData as $val){
                        if($val['is_feedback']==1){
                            $result['is_feedback']++;
                        }
                        if($val['is_del']==1){
                            $result['is_del']++;
                        }else{
                            $result['total']++;
                        }
                    }
                }
            }

            $abnormalSql="select status from assist_student_scan_task where exam_group_id = '{$examGroupId}'";
            $abnormalData=$this->conn->createCommand($abnormalSql)->queryAll();
            if($abnormalData){
                $result['abnormal']=count($abnormalData);
                foreach ($abnormalData as $val){
                    if($val['status']==0){
                        $result['surplus']++;
                    }
                    if($val['status']==1){
                        $result['complete']++;
                    }
                }
            }

        }
        return $result;
    }


    //查询待处理数据
    public function getSurplusDataByExamGroupId($examGroupId){
        $abnormalSql="select status from assist_student_scan_task where exam_group_id = '{$examGroupId}' and status=0";
        $abnormalData=$this->conn->createCommand($abnormalSql)->queryAll();
        $result=array();
        if($abnormalData){
            foreach ($abnormalData as $val){
                $result[]=array(
                    'task_id'=>$val['task_id'],
                    'student'=>$val['data']
                );
            }
        }
        return $result;
    }

    /**
     * 好题本
     */
    public function getHtb($condition = array(), $orderBy = array("htb.create_time desc"), $pageSize = 10)
    {
        $condition = Arr::merge($condition, array("htb.semester_id = '{$this->semester["id"]}'"));
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $handle = $this->sConn->createCommand("
			select htb.htb_id,htb.name,c.grade,c.class_id,c.class_name,htb.is_new_version,htb.htb_group_id from math_htb_setting htb join class c on htb.class_id= c.class_id
			{$condition}
			group by htb.htb_id
			{$orderBy}
		")->query();

        $rs = $this->paging($this->sConn, $handle, $pageSize);
        if ($rs['rs']) {
            foreach ($rs['rs'] as $k => $v) {
                $rs['rs'][$k]['totalCount'] = 0;
                $rs['rs'][$k]['pdfCount'] = 0;
                $rs['rs'][$k]['isDown'] = 0;
                $rs['rs'][$k]['downTime'] = '';
                $htb_id = $v['htb_id'];
                $sql = "select COUNT(student_id) AS totalCount,SUM(CASE WHEN is_htb_pdf = 1 THEN 1 ELSE 0 END) AS pdfCount from math_htb_student where htb_id = '{$htb_id}'";

                $countArr = $this->sConn->createCommand($sql)->queryRow();
                if ($countArr) {
                    $rs['rs'][$k]['totalCount'] = isset($countArr['totalCount']) ? $countArr['totalCount'] : 0;
                    $rs['rs'][$k]['pdfCount'] = isset($countArr['pdfCount']) ? $countArr['pdfCount'] : 0;
                }
                $sql = "select htb_download_time from math_htb_student where htb_id = '{$htb_id}' and is_htb_download = 1 order by htb_download_time desc limit 1";
                $isDownArr = $this->sConn->createCommand($sql)->queryRow();
                if ($isDownArr) {
                    $rs['rs'][$k]['isDown'] = 1;
                    $rs['rs'][$k]['downTime'] = isset($isDownArr['htb_download_time']) ? date("Y-m-d H:i", $isDownArr['htb_download_time']) : '';
                }
            }
        }

        return $rs;
    }

    /**
     * 全学科获取题型(topic表中题型)
     */
    public function getPaperTopicsRecordsByTopic($paperId)
    {
        $records = array();
        if ($paperId) {
            $sql = "select ptr.*,t.bank_type from paper_topic_relation ptr join topic t on ptr.topic_id = t.topic_id where ptr.paper_id = '{$paperId}' order by ptr.`order` asc";
            
            $records = $this->sConn->createCommand($sql)->queryAll();
        }

        return $records;
    }
    //读取最新版本软件
    public function getNewVersionBySoftwareId($id){
        $sql="select file_url from client_software_version where software_id = '{$id}' order by id desc";
        $data=$this->conn->createCommand($sql)->queryRow();
        if($data){
            return $data['file_url'];
        }else{
            return '';
        }
    }
    //统计考试班级和人数
    public function countExamsAndStudents($examGroupId){
        if(!$examGroupId) return false;
        $result=array();
        $sql="select exam_id from exam where exam_group_id='".$examGroupId."'";
        $exam=$this->sConn->createCommand($sql)->queryAll();
        if($exam){
            $examIds=array();
            foreach ($exam as $val){
                $examIds[]=$val['exam_id'];
            }
            $result['classes']=count($examIds);
            $student=$this->sConn->createCommand("select count(*) as count from student_paper_relation where exam_id in(".implode(',',$examIds).") and is_del=0")->queryRow();
            if($student){
                $result['students']=$student['count'];
            }
        }
        return $result;
    }
    //根据班级名称读取班级
    public function getClassInfoByClassName($className,$semesterIds){
        if(!$semesterIds || !$className)
            return false;


        $rs = $this->sConn->createCommand("select class_id from class where class_name = '{$className}' and semester_id='".$semesterIds."'   and is_hide=0 ")->queryRow();

        if($rs){
            return $rs['class_id'];
        }
        return false;
    }

    //查询指定科目班级执教教师
    public function getTeacherByClassSubject($classId,$subjectId){
        if(!$classId || !$subjectId) return false;

        if(in_array($subjectId,array(3,6,51))) $subjectId=3;
        $rs = $this->sConn->createCommand("SELECT t.teacher_id,class_id FROM `teacher_class_relation` tcr join teacher t on t.teacher_id=tcr.teacher_id where t.subjects='{$subjectId}' and tcr.class_id='{$classId}';")->queryRow();

        return $rs;

    }


    public function getExamName($examId)
    {
        if (!$examId) return null;

        $sql = "select name from exam where exam_id ='{$examId}'";
        $exam = $this->sConn->createCommand($sql)->queryRow();

        if ($exam) {
            return $exam['name'];
        }
        return null;
    }

    //读取未上传考生
    public function getNoUploadStudentByGroupId($examGroupId,$page,$del=-1,$classId=0){
        if(!$examGroupId) return false;
        if(!$page) $page=1;
        $result=array();
        $pageLimit=10;

        if($classId){
            $sql="select exam_id,class_id from exam where exam_group_id='".$examGroupId."' and class_id='{$classId}'";
        }else{
            $sql="select exam_id,class_id from exam where exam_group_id='".$examGroupId."'";
        }


        $exam=$this->sConn->createCommand($sql)->queryAll();
        if($exam) {
            $examIds = array();
            $classIds=array();
            $className=array();
            foreach ($exam as $val) {
                $examIds[] = $val['exam_id'];
                $classIds[]=$val['class_id'];
            }

            $classSql="select class_name,class_id from class where class_id in(".implode(',',$classIds).")";
            $classes=$this->sConn->createCommand($classSql)->queryAll();
            foreach ($classes as $val){
                $className[(string)$val['class_id']]=$val['class_name'];
            }

            $condition=array();
            $condition[]=" is_feedback=0 ";
            $condition[]=" exam_id in(".implode(',',$examIds).") ";
            $offset=($page-1)*$pageLimit;

            if($del==-1) {
                //全部
            }elseif($del==0){
                $condition[]=" is_del=0 ";
            }elseif($del==1){
                $condition[]=" is_del=1 ";
            }

            $countData=$this->sConn->createCommand("select count(*) as count from student_paper_relation where ".implode(' AND ',$condition))->queryRow();


            $result['total']=$countData['count'];
            $result['totalPage']=ceil($result['total']/$pageLimit);
            $result['page']=$page;
            $result['pageLimit']=$pageLimit;
            $sql="select student_id,class_id,student_card,school_student_card,is_del,exam_id from student_paper_relation where ".implode(' AND ',$condition)." order by  student_id  limit {$offset},{$pageLimit} ";

            $studentData=$this->sConn->createCommand($sql)->queryAll();

            if($studentData){
                foreach ($studentData as $key =>$val){
                    if(isset($className[(string)$val['class_id']])){
                        $studentData[$key]['class_name']=   $className[(string)$val['class_id']];
                    }
                    $studentInfo=$this->sConn->createCommand("select realname from student_info where student_id ='{$val['student_id']}'")->queryRow();
                    if($studentInfo){
                        $studentData[$key]['student_name']=   $studentInfo['realname'];
                    }
                    if($val['is_del']==1){
                        $studentData[$key]['status']= '缺考';
                    }else{
                        $studentData[$key]['status']= '未上传';
                    }
                }
            }
            $result['list']=$studentData;
            $result['classes']=$className;
        }

        return $result;
    }

    //删除学生
    public function delStudentPaperByStudentAndExamIds($studentsIds,$examId)
    {

        $trans 			= $this->sConn->beginTransaction();

        try {
            if(is_array($examId)){
                $this->sConn->createCommand("update student_paper_relation set is_del=1 where student_id in(".implode(',',$studentsIds).") and exam_id in(".implode(',',$examId).") and is_feedback=0")->execute();
                $this->sConn->createCommand("DELETE FROM  student_answer_card_online where student_id in(".implode(',',$studentsIds).") and exam_id in(".implode(',',$examId).") ")->execute();

            }else{
                $this->sConn->createCommand("update student_paper_relation set is_del=1 where student_id in(".implode(',',$studentsIds).") and exam_id ='{$examId}' and is_feedback=0")->execute();
                $this->sConn->createCommand("DELETE FROM  student_answer_card_online where student_id in(".implode(',',$studentsIds).") and exam_id ='{$examId}' ")->execute();

            }

            $trans->commit();
            return true;
        } catch (Exception $e) {
            $trans->rollBack();
            return false;
        }


    }
    //下载学生
    public function getExcelStudent($studentIds,$examGroupId)
    {
        $array=array();
        $sql = "select exam_id,class_id from exam where exam_group_id='" . $examGroupId . "'";

        $exam = $this->sConn->createCommand($sql)->queryAll();
        if ($exam) {
            $examIds = array();
            $classIds = array();
            $className = array();
            foreach ($exam as $val) {
                $examIds[] = $val['exam_id'];
                $classIds[] = $val['class_id'];
            }

            $classSql = "select class_name,class_id from class where class_id in(" . implode(',', $classIds) . ")";
            $classes = $this->sConn->createCommand($classSql)->queryAll();
            foreach ($classes as $val) {
                $className[(string)$val['class_id']] = $val['class_name'];
            }

            $condition = array();
          //  $condition[] = " student_id in(" . implode(',', $studentIds) . ") ";
            $condition[] = " exam_id in(" . implode(',', $examIds) . ") ";
            $condition[] = " is_feedback=0 ";

            $sql = "select student_id,class_id,student_card,school_student_card,is_del,exam_id from student_paper_relation where " . implode(' AND ', $condition) . "  ";

            $studentData = $this->sConn->createCommand($sql)->queryAll();


            if ($studentData) {
                foreach ($studentData as $key => $val) {

                    $studentInfo = $this->sConn->createCommand("select realname from student_info where student_id ='{$val['student_id']}'")->queryRow();

                    $status='未上传';
                    if ($val['is_del'] == 1) {
                        $status = '缺考';
                    }
                    $array[]=array(
                        $studentInfo['realname'],
                        $val['student_card'],
                        $val['school_student_card'],
                        $className[(string)$val['class_id']],
                        $status
                    );
                }
            }


            $title = array("姓名", "系统准考证号", "学校准考证号", "班级", "状态");
            array_unshift($array, $title);
        }
        return $array;
    }

    public function getCyletStudentByExamIds($examIds,$classIds){
        if(!$examIds || !is_array($examIds)) return null;

        $studentIds=array();
        $sql="select exam_group_id from exam where exam_id in(".implode(',',$examIds).")";
        $data = $this->sConn->createCommand($sql)->queryAll();
        foreach ($data as $datum){
            $examGroupId[]=$datum['exam_group_id'];

            $sql="select exam_id from exam where exam_group_id in(".implode(',',$examGroupId).") and class_id in(".implode(',',$classIds).")";
            $studentExam=$this->sConn->createCommand($sql)->queryAll();
            $studentExamIds=array();
            foreach ($studentExam as $val){
                $studentExamIds[]=$val['exam_id'];
            }

            if($studentExamIds){
                $sql="select student_id from student_paper_relation where exam_id in(".implode(',',$studentExamIds).") and is_del=0";
                $studentRs=$this->sConn->createCommand($sql)->queryAll();
                if($studentRs){
                    foreach ($studentRs as $val){
                        $studentIds[(string)$val['student_id']]=$val['student_id'];
                    }
                }
            }

        }
        return array_values($studentIds);
    }

    //删除学生
    public function delStudentPaperByExamGroupId($examId)
    {

        $trans 			= $this->sConn->beginTransaction();
        try {
            if(is_array($examId)){
                $this->sConn->createCommand("update student_paper_relation set is_del=1 where  exam_id in(".implode(',',$examId).") and is_feedback=0")->execute();
                $this->sConn->createCommand("DELETE FROM  student_answer_card_online where  exam_id in(".implode(',',$examId).") ")->execute();

            }else{
                $this->sConn->createCommand("update student_paper_relation set is_del=1 where  exam_id ='{$examId}' and is_feedback=0")->execute();
                $this->sConn->createCommand("DELETE FROM  student_answer_card_online where  exam_id ='{$examId}' ")->execute();

            }

            $trans->commit();
            return true;
        } catch (Exception $e) {
            $trans->rollBack();
            return false;
        }
    }
    //读取未上传考生
    public function getStudentPaperByExamGroupId($examId)
    {
        if (is_array($examId)) {
            $rs = $this->sConn->createCommand("select student_id from  student_paper_relation  where  exam_id in(" . implode(',', $examId) . ") and is_feedback=0")->queryAll();

        } else {
            $rs = $this->sConn->createCommand("select student_id from  student_paper_relation  where  exam_id ='{$examId}' and is_feedback=0")->queryAll();
        }
        $result = array();
        if ($rs) {

            foreach ($rs as $val) {
                $result[(string)$val['student_id']] = $val['student_id'];
            }
        }

        return $result;

    }


    //发送标注到教师端
    public function sendLabelToTeacher($examGroupId,$type){
        if(!$examGroupId || !in_array($type,array('send','cancel','resend')) ){
            return false;
        }
        $examData=$this->getExamsIdsByExamGroupId($examGroupId);
        if(!$examData){
            return false;
        }
        $examIds=array();
        foreach ($examData as $val){
            $examIds[]=$val;
        }
        if($type=='send' || $type=='resend'){
            $rs=$this->sConn->createCommand("update paper set is_labelled=2,labelled_type=2,send_labelled_time='".time()."' where exam_id in(".implode(',',$examIds).")")->execute();
        }else{
            $rs=$this->sConn->createCommand("update paper set is_labelled=4,send_labelled_time='".time()."' where exam_id in(".implode(',',$examIds).")")->execute();
        }

        return $rs;
    }

    //更新发送类型
    public function updatePaperLabelledType($examGroupId,$type){
        if(!$examGroupId ){
            return false;
        }
        $examData=$this->getExamsIdsByExamGroupId($examGroupId);
        if(!$examData){
            return false;
        }
        $examIds=array();

        foreach ($examData as $val){
            $examIds[]=$val;

        }
        $rs=$this->sConn->createCommand("update paper set labelled_type='{$type}',send_labelled_time='".time()."',is_labelled=0 where exam_id in(".implode(',',$examIds).")")->execute();
        return $rs;
    }

    
    /**
     * 教师假期报告列表
     */
    public function getTeacherHolidayReport($condition = array(), $orderBy = array("htrs.create_time desc"), $pageSize = 10){
            $condition = $this->condition($condition);

            $orderBy = $this->orderBy($orderBy);
            $handle = $this->sConn->createCommand("
                    select htrs.report_id,htrs.report_group_id,htrs.semester_id,htrs.teacher_id,htrs.create_time,t.teacher_name from holiday_teacher_report_setting htrs join teacher t on t.teacher_id = htrs.teacher_id 
                    {$condition}
                    group by htrs.report_id
                    {$orderBy}
            ")->query();

            $rs = $this->paging($this->sConn, $handle, $pageSize);
            if($rs['rs']){
                $rs['is_all_pdf'] = 1;//是否全部生成pdf
                $rs['create_time'] = 0;//创建时间
                $create_time_arr = array();
                $reset_time_arr = array();
                foreach($rs['rs'] as $k=>$v){
                    $teacher_id = $v['teacher_id'];
                    $report_id = $v['report_id'];
                    $semester_id = $v['semester_id'];
                    //获取教师登陆账号
                    $sql = "select phone_number from xb_teacher where teacher_id = '{$teacher_id}'";
                    $teacher_data = $this->conn->createCommand($sql)->queryRow();
                    if($teacher_data){
                        $rs['rs'][$k]['phone_number'] = $teacher_data['phone_number'];
                    }else{
                        $rs['rs'][$k]['phone_number'] = "";
                    }
                    //获取生成数量
                    $sql = "select count(1) count,report_pdf_time from holiday_report_teacher where report_id = '{$report_id}' and is_report_pdf = 1";
                    $pdf_data = $this->sConn->createCommand($sql)->queryRow();
                    if($pdf_data){
                        $rs['rs'][$k]['pdf_count'] = $pdf_data['count'];
                        $rs['rs'][$k]['build_time'] = $pdf_data['report_pdf_time']?date("Y-m-d",$pdf_data['report_pdf_time']):'';
                    }else{
                        $rs['rs'][$k]['pdf_count'] = 0;
                        $rs['rs'][$k]['build_time'] = '';
                    }
                    //获取执教班级
                    $sql = "select c.class_id,c.class_name from teacher_class_relation tcr join class c on tcr.class_id = c.class_id where tcr.semester_id ='{$semester_id}' and tcr.teacher_id = '{$teacher_id}'";
                    $class_data = $this->sConn->createCommand($sql)->queryAll();
                    if($class_data){
                        $class_name = "";
                        foreach($class_data as $v){
                            $class_name .= $v['class_name'].'、';
                        }
//                        $rs['rs'][$k]['class_name'] = mb_substr($class_name, 0, -1);
                        $rs['rs'][$k]['class_name'] = rtrim($class_name, "、");
                    }else{
                        $rs['rs'][$k]['class_name'] = '';
                    }
                    
                    
                    
                }
                
                
            }

            return $rs;
    }
    
    /**
     * 批量插入教师假期报告
     * @type 1-没数据全部插入 2-有教师补数据
     */
    public function batchInsetHolidayTeacherReport($schoolId,$semesterId,$type){
        $data = array();
        $data['status'] = 0;
        $data['error'] = '创建失败';
        $teacher_ids = array();
        $new_report_ids = array();
        $insert_values_1 = "";//sql1
        $insert_values_2 = "";//sql2
        $time = time();
        
        //获取教师执教班级信息
        if($type == 1){
            $sql = "select t.teacher_id,t.teacher_name,tcr.class_id,c.grade from teacher t "
                    . "join teacher_class_relation tcr on t.teacher_id = tcr.teacher_id "
                    . "join class c on tcr.class_id = c.class_id "
                    . "where tcr.semester_id = '{$semesterId}' and t.subjects in (".implode(',',Yii::app()->params['mathSubjectId']).") GROUP BY t.teacher_id,c.grade";
        }else if($type == 2){
            $sql = "select t.teacher_id,t.teacher_name,tcr.class_id,c.grade from teacher t "
                . "join teacher_class_relation tcr on t.teacher_id = tcr.teacher_id "
                . "join class c on tcr.class_id = c.class_id "
                . "where tcr.semester_id = '{$semesterId}' and t.subjects in (".implode(',',Yii::app()->params['mathSubjectId']).") and t.teacher_id not in "
                . "(select teacher_id from holiday_teacher_report_setting where semester_id = '{$semesterId}') "
                . "GROUP BY t.teacher_id,c.grade";
        }
        $teacher_class_data = $this->sConn->createCommand($sql)->queryAll();
        if(!$teacher_class_data){
            $data['error'] = '暂无教师班级信息';
            return $data;
        }else{
            $report_group_id = getUniqueId($schoolId);
            foreach($teacher_class_data as $k=>$v){
                $teacher_ids[] = $v['teacher_id'];
            }
            $teacher_ids = array_unique($teacher_ids);
            
            $teacher_count = count($teacher_ids);
            $report_ids = getBatchUuid($schoolId,$teacher_count);
            if($report_ids){
                $report_ids_values = array_values($report_ids);
            
                if(count($teacher_ids) != count($report_ids)){
                    $data['error'] = '教师数量不符合';
                    return $data;
                }
                $i = 0;
                $teacher_ids = array_values($teacher_ids);
                foreach($teacher_ids as $k=>$v){
                    if(isset($report_ids_values[$i]) && $report_ids_values[$i]){
                        $new_report_ids[$v] = $report_ids_values[$i];
                        $report_id = $new_report_ids[$v];
                        $insert_values_1 .= "(".$report_group_id.",".$report_id.",".$v.",".$semesterId.",".$time."),";
                        $i++;
                    }
                }
                //组装插入sql语句
                foreach($teacher_class_data as $v){
                    if(isset($new_report_ids[$v['teacher_id']]) && $new_report_ids[$v['teacher_id']]){
                        $report_id = $new_report_ids[$v['teacher_id']];
                        $insert_values_2 .= "(".$report_id.",".$v['teacher_id'].",".$v['grade']."),";
                    }
                }
            }
        }
        $trans = $this->sConn->beginTransaction();
        try{
            
            if($insert_values_1){
                $insert_sql = "insert into holiday_teacher_report_setting (report_group_id,report_id,teacher_id,semester_id,create_time) values".substr($insert_values_1,0,-1).';';
                $this->sConn->createCommand($insert_sql)->execute();
            }
            if($insert_values_2){
                $insert_sql = "insert into holiday_report_teacher (report_id,teacher_id,grade) values".substr($insert_values_2,0,-1).';';
                $this->sConn->createCommand($insert_sql)->execute();
            }

            $trans->commit();
            $data['status'] = 1;
            $data['error'] = '创建成功';
        }
        catch(Exception $e){
            $trans->rollBack();
            $data['status'] = 0;
            $data['error'] = '创建失败';
        }
        return $data;
    }
    
    /**
     * 重置教师假期报告(单个)
     */
    public function resetTeacherReport($reportId,$teacherId,$semesterId){
        $time = time();
        $status = false;
        $insert_values = '';
        $trans = $this->sConn->beginTransaction();
        try{
            //删除学生数据
            $sql = "delete from holiday_report_teacher where report_id = '{$reportId}'";
            $this->sConn->createCommand($sql)->execute();
            
            //执教班级数据
            $sql = "select t.teacher_id,t.teacher_name,tcr.class_id,c.grade from teacher t "
                . "join teacher_class_relation tcr on t.teacher_id = tcr.teacher_id "
                . "join class c on tcr.class_id = c.class_id "
                . "where t.teacher_id = '{$teacherId}' and tcr.semester_id = '{$semesterId}' and t.subjects in (".implode(',',Yii::app()->params['mathSubjectId']).") GROUP BY t.teacher_id,c.grade";
            $teacher_class_data = $this->sConn->createCommand($sql)->queryAll();
            
            if($teacher_class_data){
                foreach($teacher_class_data as $k=>$v){
                    $insert_values .= "(".$reportId.",".$v['teacher_id'].",".$v['grade']."),";
                }
                if($insert_values){
                    $insert_sql = "insert into holiday_report_teacher (report_id,teacher_id,grade) values".substr($insert_values,0,-1).';';
                    $this->sConn->createCommand($insert_sql)->execute();
                }
            }
            //更新设置表
            $sql = "update holiday_teacher_report_setting set is_all_html=90,school_group_id=0,reset_time={$time},reset_times= reset_times + 1 where report_id = '{$reportId}'";
            $this->sConn->createCommand($sql)->execute();
            //重置后清除已存在的下载任务
//            $this->conn->createCommand("delete from pack_product_task where school_id ={$this->schoolId} and unique_key= {$reportId} and product_type=8 and class_id={$classId} ")->execute();

            $trans->commit();
            $status = true;
        }
        catch(Exception $e){
            $trans->rollBack();
        }
        return $status;
    }
    
    /**
     * 批量重置教师假期报告
     */
    public function batchResetTeacherReport($semesterId)
    {
        $time = time();
        $status = false;
        $report_ids = array();

        $sql = "select report_id from holiday_teacher_report_setting where semester_id='$semesterId'";
        $report_data = $this->sConn->createCommand($sql)->queryAll();
        if ($report_data) {
            foreach ($report_data as $k => $v) {
                $report_ids[] = $v['report_id'];
            }
        }
        $trans = $this->sConn->beginTransaction();
        try {

            if ($report_ids) {
                $sql = "update holiday_teacher_report_setting set is_all_html=90,reset_time={$time},school_group_id=0 where semester_id = '{$semesterId}'";
                $this->sConn->createCommand($sql)->execute();
                $sql = "update holiday_report_teacher set is_report_html=90,is_report_pdf=0 where report_id in (" . implode(",", $report_ids) . ")";
                $this->sConn->createCommand($sql)->execute();
                //重置后清除已存在的下载任务
//                $task_sql = "delete from pack_product_task where school_id ={$this->schoolId} and unique_key in (". implode(",", $report_ids).") and product_type=8";
//                $this->conn->createCommand()->execute($task_sql);
            }

            $trans->commit();
            $status = true;
        } catch (Exception $e) {
            $trans->rollBack();
        }
        return $status;
    }

    //读取全部考生
    public function getAllStudentPaperByExamIds($examIds,$studentIds=array())
    {
        if($studentIds){
            $rs = $this->sConn->createCommand("select spr.class_id,si.student_id,si.realname,student_card,school_student_card,is_feedback,exam_id,paper_id,student_img_paper from  student_paper_relation spr left join student_info si on spr.student_id=si.student_id  where  exam_id in(" . implode(',', $examIds) . ") and spr.student_id in(".implode(',',$studentIds).") and is_del=0")->queryAll();
        }else{
            $rs = $this->sConn->createCommand("select spr.class_id,si.student_id,si.realname,student_card,school_student_card,is_feedback,exam_id,paper_id,student_img_paper from  student_paper_relation spr left join student_info si on spr.student_id=si.student_id  where  exam_id in(" . implode(',', $examIds) . ") and is_del=0")->queryAll();
        }


        return $rs;

    }

    //读取走班，根据学生id
    public function getAllClassByStudentId($studentIds){

        $sql="select c.class_id,c.class_name,student_id from student_class_relation scr
join class c on c.class_id=scr.class_id
where status=0 and c.class_type=2 and student_id in(".implode(',',$studentIds).")";
        $rs = $this->sConn->createCommand($sql)->queryAll();
        $result=array();
        if($rs){
            foreach ($rs as $v){
                $subject=$this->sConn->createCommand("select subject_id from class_subject_relation where class_id='{$v['class_id']}'")->queryAll();
                $subjectList=array();
                if($subject){
                    foreach ($subject as $item){
                        $subjectList[]=Yii::app()->params['subjectId'][$item['subject_id']];
                    }
                }
                $result[$v['student_id']][]=array(
                    'class_name'=>$v['class_name'],
                    'subject'=>$subjectList
                );
            }
        }
        return $result;
    }
    //全学科题库获取题型
    public function getAllSubjectTopicType($subject){
        $topics = array();
        $array = array();

        $array['subjectId']=$subject;
        $url= $this->apiUrl.'/all_subject/topic_type';
        $topics = Curl::post($url, $array);

        $topics=json_decode($topics,true);
        if(isset($topics['status']) && $topics['status']==1 ){
            return $topics['data'];
        }

        return null;
    }
    //全学科题库获取题型
    public function getAllSubjectBasicType(){
        $topics = array();
        $array = array();

        $url= $this->apiUrl.'/all_subject/basic_topic_type';
        $topics = Curl::post($url, $array);

        $topics=json_decode($topics,true);
        if(isset($topics['status']) && $topics['status']==1 ){
            return $topics['data'];
        }

        return null;
    }
    //查询上传答案图片学生
    public function getUpAnswerStudent($paperId,$studentIds=array(),$count=true){
        if(!$paperId ){
            return null;
        }
        if($count){
            if($studentIds){
                $sql="select count(DISTINCT student_id) as count from student_paper_topic_rs where paper_id='{$paperId}' and student_id in(".implode(',',$studentIds).") and answer_url<>'' ";
            }else{
                $sql="select count(DISTINCT student_id) as count from student_paper_topic_rs where paper_id='{$paperId}' and answer_url<>'' ";
            }

            $rs=$this->sConn->createCommand($sql)->queryRow();
            return $rs['count'];
        }else{
            if($studentIds){
                $sql="select DISTINCT student_id from student_paper_topic_rs where paper_id='{$paperId}' and student_id in(".implode(',',$studentIds).") and answer_url<>'' ";
            }else{
                $sql="select DISTINCT student_id from student_paper_topic_rs where paper_id='{$paperId}'  and answer_url<>'' ";
            }

            $rs=$this->sConn->createCommand($sql)->queryALl();

            return $rs;
        }

    }
    //读取在线答题卡

    public function getAnswerSheet($examGroupId){
        if(!$examGroupId || !is_numeric($examGroupId)){
            return null;
        }

        $sql="select online_card,tas.is_qrcode_online,tas.file_path,tas.multiplex_id,ocm.marking_papers,ocm.paper_size from `third_answer_sheet` tas  ";
        $sql.=" left join online_card_multiplex ocm on ocm.multiplex_id=tas.multiplex_id ";
        $sql.=" where tas.exam_group_id='{$examGroupId}' ";
        $rs=$this->sConn->createCommand($sql)->queryRow();
        return $rs;
    }


    //更新标注期望完成时间
    public function updateEstimateTime($examGroupId,$tplData)
    {
        if (!$examGroupId || !is_numeric($examGroupId) || !$tplData) {
            return null;
        }

        $rs = $this->sConn->createCommand("update exam set tpl_data='" . $tplData . "' where exam_group_id='{$examGroupId}'")->execute();
        return $rs;
    }

    //保存考试全流程节点时间
    public function saveExamProcess($examGroupId,$actionType,$actionTime,$examId=0,$classId=0){

        if(!$examGroupId || !is_numeric($examGroupId)) return false;


        $model=new SExamProcess();

        $model->exam_group_id=$examGroupId;
        $model->exam_id=$examId;
        $model->class_id=$classId;
        $model->action_type=$actionType;
        $model->action_time=$actionTime;
        if($model->save()){
            return true;
        }
        return false;
    }
    // 批量保存考试全流程节点时间
    public function saveExamProcessBatch($examGroupId,$batchData){

        if(!$examGroupId || !is_numeric($examGroupId)) return false;

        $sql="insert into exam_process(`exam_group_id`,`exam_id`,`class_id`,`action_type`,`action_time`) values ";
        $valueData=array();
        foreach ($batchData as $val){
            if(!in_array($val['action_type'],array(1,2,3,4,5,6,7,8,9,10,11,12))){
                return false;
            }
            if(!isset($val['exam_id']) || !isset($val['class_id']) || !isset($val['action_type']) || !isset($val['action_time'])){
                return false;
            }
            $valueData[]="('{$examGroupId}','{$val['exam_id']}','{$val['class_id']}','{$val['action_type']}','{$val['action_time']}')";
        }

        if($this->sConn->createCommand($sql.implode(',',$valueData))->execute()){
            return true;
        }
        return false;

    }


    //删除指定班级未上传考生
    public function delStudentPaperByExamId($examIds){
        if(!$examIds || !is_array($examIds)) return false;

        $sql="update student_paper_relation set is_del=1 where exam_id in(".implode(',',$examIds).") and is_feedback=0";
        if($this->sConn->createCommand($sql)->execute()){
            return true;
        }
        return false;
    }

    //查询导出考试数据白名单
    public function getExportExamWhiteList($schoolId){
        if(!$schoolId || !is_numeric($schoolId)) return false;
        $sql="select id from school_download_exam_whitelist where school_id='".$schoolId."'";
        $rs= $this->conn->createCommand($sql)->queryRow();
        if($rs){
            return 1;
        }else{
            return 0;
        }
    }
    //读取在线答题卡
    public function getOnlineCardMultiplex($multiplexId){
        if(!$multiplexId){
            return null;
        }

        $sql="select marking_papers from `online_card_multiplex`   ";
        $sql.=" where multiplex_id='{$multiplexId}' ";
        $rs=$this->sConn->createCommand($sql)->queryRow();
        return $rs;
    }

    //获取全学科试卷结构
    public function getQxkPaperTopics($topicIds){

        $rs = http('/qxk/topic/list','POST',$this->schoolId,array('topicList'=>array_values($topicIds)),'cgi');
        $rs=json_decode($rs,true);
        if(isset($rs['errCode']) && $rs['errCode']=='00'){
            return $rs['data'];
        }
        return null;
    }
    //读取学校省份
    public function getProvince($pid){
        if(!$pid) return null;
        $sql="select region_name from region where region_id='{$pid}'";
        $data=$this->conn->createCommand($sql)->queryRow();
        if($data){
            return $data['region_name'];
        }
        return null;
    }
    //读取在线答题卡
    public function getOnlineCardMultiplexByGroupId($groupId){
        if(!$groupId){
            return null;
        }

        $sql="select marking_papers,is_download,exam_group_id from `online_card_multiplex`   ";
        $sql.=" where exam_group_id='{$groupId}' ";
        $rs=$this->sConn->createCommand($sql)->queryRow();
        return $rs;
    }
    /**
     * 校本纠错本
     */
    public function getCorrect($condition = array(), $orderBy = array("create_time desc"), $pageSize = 10)
    {
        $condition = Arr::merge($condition, array("gps.semester_id = '{$this->semester["id"]}'"));
        $condition = $this->condition($condition);

        $orderBy = $this->orderBy($orderBy);
        $handle = $this->sConn->createCommand("
			select  gps.gp_group_id,`name`,gps.grade,gps.create_time,status,setting,gp.reset_times from general_product_setting gps LEFT JOIN general_product gp on gp.gp_group_id=gps.gp_group_id
			{$condition}
			group by gps.gp_group_id
			{$orderBy}
		")->query();

        $rs = $this->paging($this->sConn, $handle, $pageSize);

        if ($rs['rs']) {
            foreach ($rs['rs'] as $k => $v) {
                $rs['rs'][$k]['totalClass'] = 0;
                $rs['rs'][$k]['isDown'] = 0;
                $rs['rs'][$k]['isCreate'] = 0;
                $rs['rs'][$k]['isAllCreate'] = 1;
                $rs['rs'][$k]['abnormal']='';
                $rs['rs'][$k]['examGroupIdCount']=0;

                $sql="select gp_id from general_product where gp_group_id='{$v['gp_group_id']}'";
                $classCount=$this->sConn->createCommand($sql)->queryAll();
                $rs['rs'][$k]['totalClass'] = count($classCount);
                $gpIds=array();
                foreach ($classCount as $item){
                    $gpIds[]=$item['gp_id'];
                }
                $sql="select student_id from general_product_student where gp_id in(".implode(',',$gpIds).") and is_create_pdf=1 ";
                $isCreate=$this->sConn->createCommand($sql)->queryRow();
                if($isCreate){
                    $rs['rs'][$k]['isCreate'] = 1;
                }
                $sql="select student_id from general_product_student where gp_id in(".implode(',',$gpIds).") and is_create_pdf=0";
                $noCreate=$this->sConn->createCommand($sql)->queryRow();
                if($noCreate){
                    $rs['rs'][$k]['isAllCreate'] = 0;
                }

                $sql="select distinct gp_id from general_product_student where gp_id in(".implode(',',$gpIds).") and is_download=1";
                $isDownArr = $this->sConn->createCommand($sql)->queryAll();
                $rs['rs'][$k]['isDown'] = count($isDownArr);

                //查询异常
                $setting=json_decode($v['setting'],1);
                if(isset($setting['no_exam_class']) && $setting['no_exam_class']){
                    $names=array();
                    $classNames=$this->sConn->createCommand("select class_name from class where class_id in(".implode(',',$setting['no_exam_class']).")")->queryAll();
                    foreach ($classNames as $cname){
                        $names[]=$cname['class_name'];
                    }
                    $rs['rs'][$k]['abnormal'] = implode(',',$names);
                }

                if(isset($setting['exam_group_ids'])){
                    $rs['rs'][$k]['examGroupIdCount']=count($setting['exam_group_ids']);
                }


            }
        }

        return $rs;
    }
}