96, 'cm' => 28, 'mm' => 2.8, 'pt' => 1.33, 'pc' => 12, ); // 打印列表 public function actionIndex() { $this->newline='
'; $getName = safe_replace(Yii::app()->request->getQuery('realname')); //$getStatus = safe_replace(Yii::app()->request->getQuery('status')); $grade_id = safe_replace(Yii::app()->request->getQuery('grade_id')); $class_id = safe_replace(Yii::app()->request->getQuery('class_id')); $display = safe_replace(Yii::app()->request->getQuery('display')); $type_id = safe_replace(Yii::app()->request->getQuery('type_id')); //$getStatus = safe_replace(Yii::app()->request->getQuery('status')); $grade_class_array = array(); $con = array(); // 打印任务处理 // $ExamModel = Exam::model(); //$ClassModel = ClassModel::model(); $printList = array(); $grade_class_data=$this->sConn->createCommand("select class_id,class_name from class where grade='{$grade_id}' and semester_id='{$this->semesterId}'")->queryAll(); //$grade_class_data = ClassModel::model()->findAll('grade=:grade and semester_id=:semester_id', array(':grade' => $grade_id,':semester_id'=>$this->semesterId)); if ($grade_class_data) { foreach ($grade_class_data as $v) { $grade_class_array[$v['class_id']] = $v; } } // 获取当前学期班级并组装 $criteria = new CDbCriteria(); $criteria->addCondition('semester_id=:semester_id'); if ($grade_id) { $con = array('c.grade = ' . $grade_id); $criteria->addCondition('grade=:grade'); $criteria->params[':grade'] = $grade_id; } if ($class_id) { $con = array_merge($con, array('c.class_id = ' . $class_id)); $criteria->addCondition('class_id=:class_id'); $criteria->params[':class_id'] = $class_id; } if ($getName) { $con = array_merge($con, array("e.name like '%{$getName}%'")); } if(in_array($this->subjectId,$this->mathSubjectId)){ $con = array_merge($con, array("e.subject_id in (".implode(',',$this->mathSubjectId).")")); }else{ $con = array_merge($con, array('e.subject_id = ' . $this->subjectId)); } if($display) { $con = array_merge($con, array("e.export_dispaly = 1")); }else { $con = array_merge($con, array("e.export_dispaly = 0")); } $con = array_merge($con, array('eg.create_type in (0,1,2,3,5,6)')); if($type_id){ if($type_id==1){ $con =array_merge($con, array('eg.is_third = 0')); }elseif($type_id==2){ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type > 0')); }else{ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type =0')); } } $criteria->params[':semester_id'] = Yii::app()->session['session_semester_id']; $class_array = ClassModel::model()->findAll($criteria); $ccArray = array(); $ccName = array(); foreach ($class_array as $cc => $ca) { array_push($ccArray, $ca->class_id); $ccName[$ca->class_id] = $ca->class_name; } $resultList = $this->schoolManager->getPrintListre(array_merge(array("cep.type = '0'", "(e.status = 1 or e.status=4)"), $con),array('e.complete_time desc')); // $resultList = $this->schoolManager->getPrintListre(array_merge(array("cep.type = '0'", "(e.status = 1 )"), $con),array('e.complete_time desc')); if ($resultList["rs"]) { foreach ($resultList['rs'] as $k => $v) { $printList[$k] = $v; $printList[$k]['class_name'] = @$ccName[$v["class_id"]]; $printList[$k]['is_method_pdf'] = SExamTeachingProduct::isGenerate($v['exam_id'], 31); //FIXME 方法宝教师端 $pname = $this->schoolManager->getExamName($v["exam_id"]); // 周周练名称 $printList[$k]['print_name'] = $pname; //试卷类别 if($v['is_third']==0){ $printList[$k]['type_name'] = '校本课程平台试卷'; }elseif($v['is_third']==1){ if($v['mark_type']==0){ $printList[$k]['type_name'] = '第三方导入成绩试卷'; }else{ $printList[$k]['type_name'] = '第三方线上阅卷试卷'; } } if(isset(Yii::app()->params['grade_list'][$v['grade']])){ $printList[$k]['grade_name']=Yii::app()->params['grade_list'][$v['grade']]['grade_name']; }else{ $printList[$k]['grade_name']=''; } } } $data = array(); // $subject_exam_data = $this->schoolManager->getxuekeStatus($this->semesterId); $data['realname'] = $getName; $data['grade_id'] = $grade_id; $data['class_id'] = $class_id; $data['display'] = $display; $data['grade_class'] = $grade_class_array; $data['printList'] = $printList; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; // $data["subject"] = $subject_exam_data; $data["subjectId"] = $this->subjectId; if (isset($this->schoolInfo->use_zhixue) && !empty($this->schoolInfo->use_zhixue)) { $data["use_zhixue"] = $this->schoolInfo->use_zhixue; } else { $data["use_zhixue"] = 0; } $data['past_sem_exist'] = 0;//默认不存在过去的学期 $data['type_id']=$type_id; $sql = 'select start_time from semester where status=1 limit 1'; $res = $this->sConn->createCommand($sql)->queryRow(); $start_time = $res['start_time']; if (!$start_time) { Yii::app()->jump->error('该学校无当前学期,请检查学期是否设置错误'); } $sql = 'select count(*) as rownum from semester where status=0 and start_time < '.$start_time; $res = $this->sConn->createCommand($sql)->queryRow(); $row_num = $res['rownum']; $row_num && $data['past_sem_exist']=1; unset($resultList); $this->render('index', $data); } /** * 是否开通过方法宝 */ public function isOpenProductMethod($classId=0,$examId=0,$type=ProductDownload::PRODUCT_TYPE_METHOD){ $allStudent = SStudentClassRelation::model()->getStudentInfoByClassId($classId); $studentIds=_array_column($allStudent,'student_id'); $sql = "select e.name,c.class_name,c.grade,e.class_id,p.add_time,e.semester_id from exam e join class_exam_printer p on p.exam_id=e.exam_id join class c on e.class_id = c.class_id where e.class_id = '{$classId}' and e.exam_id = '{$examId}'"; $names = $this->sConn->createCommand($sql)->queryRow(); $Sem=new SSemester(); $code= $Sem->conn->createQuery() ->from('semester') ->where("semester_id = '".$names['semester_id']."'") ->limit(1) ->query() ->read(); $intarr=array( "schoolId"=>$this->schoolId, "clazzId"=>$names['class_id'], "semester"=>$code['refer_code'], "grade"=>$names['grade'], "students"=>$studentIds, "examTime"=>$names['add_time'], "classify"=>$type, "subject"=>$this->subjectId ); $basic = imsBasicAuth($this->schoolId.'_'.Yii::app()->session['coachInfo']['coach_name'],Yii::app()->params["zsy_api_key"]); $rs = json_decode(Curl::http_post_Basic_json(Yii::app()->params["get_limit_url"], json_encode($intarr),$basic)); //该班级是否有学生开通过方法宝 $isClassOpen=false; if(isset($rs->data)){ $limitstu=$rs->data; if(($limitstu==0) || (is_array($limitstu) && array_intersect($studentIds,$limitstu))){ $isClassOpen=true; } } return $isClassOpen; } //获取错题前十和教师讲堂考试班级 public function actionClassExamAc(){ $examGroupId = safe_replace(Yii::app()->request->getQuery('examGroupId')); $resultList = array(); if(is_numeric($examGroupId) && $examGroupId > 0){ $con = array(); $con = array_merge($con, array(" e.exam_group_id = ".$examGroupId)); if(in_array($this->subjectId,$this->mathSubjectId)){ $con = array_merge($con, array("e.subject_id in (".implode(',',$this->mathSubjectId).")")); }else{ $con = array_merge($con, array('e.subject_id = ' . $this->subjectId)); } $resultList = $this->schoolManager->getClassExamAc(array_merge(array("cep.type = '0'", "e.status = 1"), $con),array('e.complete_time desc')); } // var_dump($resultList);die; $this->render('reset_ac',array("resultList" => $resultList,'printType'=>'')); } //重置错题前十和教师讲堂 public function actionResetAc(){ $param = Yii::app()->request->getParam('examIds'); foreach($param as $value){ $examId = $value[0]; $this->setIs_new($examId); //教师讲案 if($value[1] == 1 && $value[2] != ''){ $status_1 = $this->sConn->createCommand()->update("exam", array("academicr_pdf_path" => '', "academicr_pdf_time" => 0, "is_academicr_pdf" => 0), "exam_id = '{$examId}'"); } //错题前十 if($value[3] == 1 && $value[4] != ''){ $status_2 = $this->sConn->createCommand()->update("exam", array("is_topwb_pdf" => 0, "is_topwb_html" => 90), "exam_id = '{$examId}'"); } } echo 1; } public function actionIndex_duo() { $getName = safe_replace(Yii::app()->request->getQuery('realname')); //$getStatus = safe_replace(Yii::app()->request->getQuery('status')); $grade_id = safe_replace(Yii::app()->request->getQuery('grade_id')); $class_id = safe_replace(Yii::app()->request->getQuery('class_id')); $type_id = safe_replace(Yii::app()->request->getQuery('type_id')); //$getStatus = safe_replace(Yii::app()->request->getQuery('status')); $grade_class_array = array(); $con = array(); // 打印任务处理 // $ExamModel = Exam::model(); // $ClassModel = ClassModel::model(); $printList = array(); $grade_class_data=$this->sConn->createCommand("select class_id,class_name from class where grade='{$grade_id}' and semester_id='{$this->semesterId}'")->queryAll(); //$grade_class_data = ClassModel::model()->findAll('grade=:grade and semester_id=:semester_id', array(':grade' => $grade_id,':semester_id'=>$this->semesterId)); if ($grade_class_data) { foreach ($grade_class_data as $v) { $grade_class_array[$v['class_id']] = $v; } } // 获取当前学期班级并组装 $criteria = new CDbCriteria(); $criteria->addCondition('semester_id=:semester_id'); if ($grade_id) { $con = array('c.grade = ' . $grade_id); $criteria->addCondition('grade=:grade'); $criteria->params[':grade'] = $grade_id; } if ($class_id) { $con = array_merge($con, array('c.class_id = ' . $class_id)); $criteria->addCondition('class_id=:class_id'); $criteria->params[':class_id'] = $class_id; } if ($getName) { $con = array_merge($con, array("e.name like '%{$getName}%'")); } if($type_id){ if($type_id==1){ $con =array_merge($con, array('eg.is_third = 0')); }elseif($type_id==2){ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type > 0')); }else{ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type =0')); } } if(in_array(Yii::app()->session['session_duoxueke_subject_id'],$this->mathSubjectId)){ $con = array_merge($con, array("e.subject_id in (".implode(',',$this->mathSubjectId).")")); }else{ $con = array_merge($con, array('e.subject_id = ' . Yii::app()->session['session_duoxueke_subject_id'])); } $criteria->params[':semester_id'] = Yii::app()->session['session_semester_id']; $class_array = ClassModel::model()->findAll($criteria); $ccArray = array(); $ccName = array(); foreach ($class_array as $cc => $ca) { array_push($ccArray, $ca->class_id); $ccName[$ca->class_id] = $ca->class_name; } $resultList = $this->schoolManager->getPrintListre(array_merge(array("cep.type = '0'", "(e.status = 1 or e.status=4)"), $con),array('e.complete_time desc')); //$resultList = $this->schoolManager->getPrintListre(array_merge(array("cep.type = '0'", "(e.status = 1)"), $con),array('e.complete_time desc')); if ($resultList["rs"]) { foreach ($resultList['rs'] as $k => $v) { $printList[$k] = $v; $printList[$k]['class_name'] = @$ccName[$v["class_id"]]; // $pname = @$ExamModel->getExamName($v["exam_id"]); // 周周练名称 $pname = $this->schoolManager->getExamName($v["exam_id"]); // 周周练名称 $printList[$k]['print_name'] = $pname; //试卷类别 if($v['is_third']==0){ $printList[$k]['type_name'] = '校本课程平台试卷'; }elseif($v['is_third']==1){ if($v['mark_type']==0){ $printList[$k]['type_name'] = '第三方导入成绩试卷'; }else{ $printList[$k]['type_name'] = '第三方线上阅卷试卷'; } } if(isset(Yii::app()->params['grade_list'][$v['grade']])){ $printList[$k]['grade_name']=Yii::app()->params['grade_list'][$v['grade']]['grade_name']; }else{ $printList[$k]['grade_name']=''; } //判断是否上传答案、试题 $uploadExamInfo=SThirdMultiTemplate::model()->getStatusByExamGroupId($v['exam_group_id']); $uploadStatus=0; if($uploadExamInfo){ if(isset($uploadExamInfo[1])){ if($uploadExamInfo[1]['topic_upload']==1){ $uploadStatus+=1; } } if(isset($uploadExamInfo[2])){ if($uploadExamInfo[2]['answer_upload']==1){ $uploadStatus+=3; } } } if($uploadStatus<4){ $printList[$k]['topic_answer_upload']=0; }else{ $printList[$k]['topic_answer_upload']=1; } } } $data = array(); // $subject_exam_data = $this->schoolManager->getxuekeStatus($this->semesterId); $data['realname'] = $getName; $data['grade_id'] = $grade_id; $data['class_id'] = $class_id; $data['grade_class'] = $grade_class_array; $data['printList'] = $printList; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; // $data["subject"] = $subject_exam_data; $data["subjectId"] = $this->subjectId; if (isset($this->schoolInfo->use_zhixue) && !empty($this->schoolInfo->use_zhixue)) { $data["use_zhixue"] = $this->schoolInfo->use_zhixue; } else { $data["use_zhixue"] = 0; } $data['past_sem_exist'] = 0;//默认不存在过去的学期 $data['type_id']=$type_id; $sql = 'select start_time from semester where status=1 limit 1'; $res = $this->sConn->createCommand($sql)->queryRow(); $start_time = $res['start_time']; if (!$start_time) { Yii::app()->jump->error('该学校无当前学期,请检查学期是否设置错误'); } $sql = 'select count(*) as rownum from semester where status=0 and start_time < '.$start_time; $res = $this->sConn->createCommand($sql)->queryRow(); $row_num = $res['rownum']; $row_num && $data['past_sem_exist']=1; unset($resultList); $this->render('index1', $data); } // 更新试卷为打印状态 public function actionExcel() { $classId = safe_replace(Yii::app()->request->getQuery('classId')); $examId = safe_replace(Yii::app()->request->getQuery('examId')); $is_outer = safe_replace(Yii::app()->request->getQuery('is_outer')); $type = safe_replace(Yii::app()->request->getQuery('type')); $type = !in_array($type, array('excel', 'word')) ? 'excel' : $type; $url = Yii::app()->params['te_url'] . "wp/reportExcel?wpId={$examId}&classId={$classId}&schoolId={$this->schoolId}&type={$type}&is_outer={$is_outer}"; $this->redirect($url); } /** * 重置教师讲案 */ public function actionreload_academicr(){ $examId = safe_replace(Yii::app()->request->getQuery('examId')); $type = safe_replace(Yii::app()->request->getQuery('type')); $this->setIs_new($examId); if($type==1){//教师讲案 if($this->sConn->createCommand()->update("exam", array("academicr_pdf_path" => '', "academicr_pdf_time" => 0, "is_academicr_pdf" => 0), "exam_id = '{$examId}'")){ echo json_encode(array("status"=>0));exit; } }elseif($type==2){//错题前十 $status = $this->sConn->createCommand()->update("exam", array("is_topwb_pdf" => 0, "is_topwb_html" => 90), "exam_id = '{$examId}'"); if($status !== false){ $sql = 'select exam_group_id from exam where exam_id = '.$examId; $res = $this->sConn->createCommand($sql)->queryRow(); if (isset($res['exam_group_id'])) { //发送消息 $sendMsg = array( 'school_id' => $this->schoolId, 'msg_type' => 90, 'subject_id' => 3, 'send_type' => 'exam', 'product_type' => array(14), 'exam_group_id' => $res['exam_group_id'], 'exam_ids' => array($examId), 'complete_rate' => 0.9, ); sendDataToKafka('xbkc-php-product-html',$sendMsg); echo json_encode(array("status"=>0));exit; } } }elseif ($type==3){ if($this->sConn->createCommand()->update("exam_teaching_product", array("is_create_pdf" => 0,"pdf_path"=>""), "exam_id = '{$examId}' and product_type=31")){ echo json_encode(array("status"=>0));exit; } } echo json_encode(array("status"=>1));exit; } /** * 下载教师讲案 */ public function actionAcademicr() { @ini_set('default_socket_timeout', 5); @ini_set('memory_limit', '512M'); set_time_limit(0); $examId = safe_replace(Yii::app()->request->getQuery('examId')); $classId = safe_replace(Yii::app()->request->getQuery('classId')); $force = safe_replace(Yii::app()->request->getQuery('force')); $isFromPast = safe_replace(Yii::app()->request->getQuery('isFromPast')); //过去学期的教师讲案如果需要生成的话,只生成个性化版的,不生成分层版的 $sem = new SSemester(); $codeNow = $sem->getCodeByExamId($examId); $this->setIs_new($examId); $sql = "select e.teacher_id,eg.mark_type,e.name as exam_name,e.academicr_pdf_path,e.academicr_pdf_time,p.paper_id,e.is_academicr_pdf,c.class_name,eg.import_score_type,c.grade,p.method_ids,e.semester_id from exam as e left join class as c on c.class_id=e.class_id left join exam_group as eg on e.exam_group_id=eg.exam_group_id left join paper as p on p.exam_id=e.exam_id where e.exam_id={$examId}"; $exam_info = $this->sConn->createCommand($sql)->queryRow(); $grade = $exam_info['grade']; $paper_method_ids = $exam_info['method_ids']; $score_type = $exam_info['import_score_type'];//成绩导入流程 0-正常扫描 $semesterId = $exam_info['semester_id']; // $pdfpath = str_replace("protected", "", Yii::app()->basePath) . $exam_info['academicr_pdf_path']; $pdfurl = $pdfpath = $exam_info['academicr_pdf_path']; $is_create=1; $force=0; if(strpos($pdfurl,'http') !== false){ // if(!file_get_contents($pdfurl)){ if(!$this->curlDownloadImage($pdfurl)){ $force = 1; } }else{ $force = 1; } if (!$exam_info['academicr_pdf_path'] || $exam_info['is_academicr_pdf'] == 0 || $force) { $is_create=0; $sql = "SELECT e.exam_group_id, e.exam_id, e.name AS exam_name, e.create_time AS exam_time, p.paper_id, p.score as paper_score, e.class_id,e.is_preparation_created,e.tpl_index, eg.mark_type,p.is_labelled,p.labelled_type,eg.qxk_paper_id "; $sql.= "FROM exam e "; $sql.= "JOIN paper p ON p.exam_id = e.exam_id "; $sql.= "JOIN exam_group eg ON eg.exam_group_id = e.exam_group_id "; $sql.= "WHERE e.status = '1' AND e.exam_id = '{$examId}' "; $data = array(); $exam = $this->sConn->createCommand($sql)->queryRow(); $labelled_type = $exam['labelled_type']; $class_id = $exam['class_id']; $is_qxk = $exam['qxk_paper_id']?1:0;//是否是全学科 if($class_id){ $exam['show_level'] = $this->get_version($class_id); $exam['level_rule'] = $this->get_level_rule($class_id); } //获取显示设置 $setting_arr = array("common"=>1,"common_wrong"=>1,"paper"=>1,"paper_wrong"=>1,"real_topic"=>1,"classmateOptimization"=>1); $sql = "select tt.template_id,tt.config_text from teaching_template tt join teaching_class_set tcs on tt.template_id=tcs.template_id where tt.subject_id = 3 and tcs.class_id='{$class_id}'"; $setting_data = $this->sConn->createCommand($sql)->queryRow(); if($setting_data){ $setting_data_arr = json_decode($setting_data['config_text'],true); if(isset($setting_data_arr['common'])){ $setting_arr['common'] = $setting_data_arr['common']; } if(isset($setting_data_arr['common_wrong'])){ $setting_arr['common_wrong'] = $setting_data_arr['common_wrong']; } if(isset($setting_data_arr['paper'])){ $setting_arr['paper'] = $setting_data_arr['paper']; } if(isset($setting_data_arr['paper_wrong'])){ $setting_arr['paper_wrong'] = $setting_data_arr['paper_wrong']; } if(isset($setting_data_arr['real_topic'])){ $setting_arr['real_topic'] = $setting_data_arr['real_topic']; } if(isset($setting_data_arr['classmateOptimization'])){ $setting_arr['classmateOptimization'] = $setting_data_arr['classmateOptimization']; } } $is_same_bs = 1;//是否开启相同变式题（需要读提分宝班级定制的配置） $same_bs_data = array();//开启相同变式题 原题跟变式题的对应关系 $is_same_bs = $this->getClassSet($classId, $semesterId); if($is_same_bs && $labelled_type == 1){ //判断有没有订单（提分方案2，提分宝3） 如果没有订单生成教学宝 有订单没数据不能生成 $has_order = 0; $table_spr = empty($codeNow)?'student_paper_relation':'student_paper_relation_'.$codeNow; $sql = "select student_id from {$table_spr} where exam_id = '{$examId}'"; $spr_data = $this->sConn->createCommand($sql)->queryAll(); $relateStudentRes = array(); if($spr_data){ foreach($spr_data as $spr_v){ $relateStudentRes[]['student_id'] = $spr_v['student_id']; } } foreach(array(2,3) as $product_type){ $temp_order = $this->getOrderStu($examId, $classId, $product_type, $relateStudentRes, $semesterId, $grade); if($temp_order && isset($temp_order['limitstu']) && $temp_order['limitstu']){ $has_order = 1; break; } } $sql = "select preparation_plan_id,template_id,topic_id from preparation_plan_topic where preparation_plan_id='{$examId}'"; $same_bs = $this->sConn->createCommand($sql)->queryAll(); if($same_bs){ foreach($same_bs as $same_k=>$same_v){ $same_bs_data[$same_v['template_id']][] = $same_v['topic_id']; } }else{ if($has_order){ echo json_encode(array("status"=>1,"error"=>"变式题未生成,请等待")); exit; } } $setting_arr['common'] = 0; } if($labelled_type == 2){ $exam['show_level'] = 0; }else{ $sql = "select switch from producut_set_edition"; $switch_data = $this->sConn->createCommand($sql)->queryRow(); if($switch_data && in_array($switch_data['switch'],array(3,4))){ $exam['show_level'] = 0; $sql = "select template_id,topic_id,topic_type from product_common_topic where exam_id = '{$examId}' and is_action=0 order by topic_type asc"; $gongxing_data = $this->sConn->createCommand($sql)->queryAll(); if(!$gongxing_data && !$is_same_bs){ echo json_encode(array("status"=>1,"error"=>"共性问题未生成，请稍等")); exit; } }else{ if ($exam && !$isFromPast && $exam['show_level'] == 1 && $exam['is_preparation_created'] != 1) { //如果选择的是分层班,教师讲案的生成条件是教师讲评题已经抽出 echo json_encode(array("status"=>1,"error"=>"文件内容尚未生成,请等待")); exit; }elseif ($exam && !$isFromPast && $exam['show_level'] == 1 && $exam['is_preparation_created'] == 2) { echo json_encode(array("status"=>1,"error"=>"由于题库题目导致无法生成，请联系后台题库老师去处理题目！")); exit; } } } if (!isset($exam['is_labelled']) || $exam['is_labelled']!=1) { echo json_encode(array("status"=>1,"error"=>"试卷还未标注，请先标注试卷")); exit; } // if($switch_data && in_array($switch_data['switch'],array(3,4))){ // $sql = "select template_id,topic_id,topic_type from product_common_topic where exam_id = '{$examId}' order by topic_type asc"; // $gongxing_data = $this->sConn->createCommand($sql)->queryAll(); // if(!$gongxing_data){ // echo json_encode(array("status"=>1,"error"=>"共性问题未生成，请稍等")); // exit; // } // } if ($exam) { //同学优解 $staticUrl = Yii::app()->params['static_url'][$this->schoolGroupId]; $excellent_solution = SStudentPaperTopicRs::model()->bestAnswer($exam,$codeNow,$staticUrl,$this->sConn,$is_qxk); //获取共性问题 $has_topic_gaokao = array();//本教学宝其他题，用于抽取高考真题 $gen_topics = array(); $gen_topics_ids = array();//共性所有题ID集合 $gen_topics_detail = array();//试题详情 $gen_topics_msg = array();//题目难度、考点、挑战信息 $schoolId = $this->schoolId;//当前学校 $school_province_name = "";//学校省份 $school_province_id = 0;//学校省份Id $gen_origin_ids = array();//共性原题Id $gen_origin_methods = array();//共性原题考点集合 $school_msg = Yii::app()->businessDb->createCommand()->from('school') ->select("province_id") ->where("school_id = ".$schoolId) ->queryRow(); if($school_msg){ $school_province_id = $school_msg['province_id']; } if($school_province_id){ $region_msg = Yii::app()->businessDb->createCommand()->from('region') ->select("region_name") ->where("region_id = ".$school_province_id) ->queryRow(); if($region_msg){ $school_province_name = $region_msg["region_name"]; } } $sql = "select template_id,topic_id,topic_type,template_no from product_common_topic where exam_id = '{$examId}' and is_action=0 order by topic_type asc"; $gongxing_data = $this->sConn->createCommand($sql)->queryAll(); if($gongxing_data && $labelled_type != 2){ foreach($gongxing_data as $k=>$v){ $i = 0; $gen_topics_ids[] = $gen_origin_ids[] = $v['template_id']; $gen_topics_ids[] = $v['topic_id']; $gen_topics[$v['topic_type']][$i]['topic_id'] = $v['template_id']; $gen_topics[$v['topic_type']][$i]['is_template'] = 1; $i++; $gen_topics[$v['topic_type']][$i]['topic_id'] = $v['topic_id']; $gen_topics[$v['topic_type']][$i]['is_template'] = 0; //变式训练获取地区挑战数 if($v['topic_id']){ $gen_topics_msg[$v['topic_id']]['school_province_name'] = $school_province_name; $topic_count = Yii::app()->topic_province_count->hmget('province_stat:topic:'.$school_province_id,array($v['topic_id'])); if($topic_count && isset($topic_count[0])){ $gen_topics_msg[$v['topic_id']]['province_count'] = empty($topic_count[0])?1000:$topic_count[0]+1000; }else{ $gen_topics_msg[$v['topic_id']]['province_count'] = 1000; } $gen_topics_msg[$v['template_id']]['template_no'] = $v['template_no']; } } } $gen_topics_ids = array_values(array_unique($gen_topics_ids)); if($gen_topics_ids){ $topicItems_1 = $this->aipost('/topic/batchAll', array('topicIds' => $gen_topics_ids)); //debug($topicItems_1); if ($topicItems_1 && !isset($topicItems_1['status'])) { foreach ($topicItems_1 as $topicItem) { $gen_topics_detail_temp[$topicItem['id']] = $topicItem; } if ($gen_topics_detail_temp) { foreach ($gen_topics_detail_temp as $k => $v) { $v=(array)$v; $teacher_tips= isset($v['teacher_tips'])?$v['teacher_tips']:""; if(!$teacher_tips){ $teacher_tips = $this->dealTeacherTips($v); } $v['teacher_tips'] = $this->topicProcess($teacher_tips); $v['parse_content'] = $this->topicProcess($v['parse_content']); if($v['type_id'] == 5 || $v['type_id'] == 6){ $v['title'] = preg_replace("/]*[\s]+src[\s]*=[\s]*(([\'\"](\/images\/list_\d\.png)[\'\"])|(\/images\/list_\d\.png))[^>]*>/si", '__________', $v['title']); } $v['title'] = $this->topicProcess($v['title']); if(isset($v['items'][0])){ $v['items'][0]=(array)$v['items'][0]; $v['items'][0]['options']=(array)$v['items'][0]['options']; if (isset($v['items']) && isset($v['items'][0]) && isset($v['items'][0]['options'])) { foreach ($v['items'][0]['options'] as $key => $val) { $val=(array)$val; $v['items'][0]['options'][$key]=(array)$v['items'][0]['options'][$key]; $v['items'][0]['options'][$key]['option_content'] = $this->topicProcess($val['option_content']); } } } //难度 $gen_topics_msg[(string)$v['id']]['difficulty'] = isset($v['difficulty_degree'])?$v['difficulty_degree']:0; //考点 $gen_topics_msg[(string)$v['id']]['methods'] = ""; $methods_arr = array(); if(isset($v['specials']) && $v['specials']){ foreach($v['specials'] as $specials){ if(isset($specials['method_name'])){ $methods_arr[] = $specials['method_name']; } if(in_array($v['id'],$gen_origin_ids)){ $gen_origin_methods[$specials['method_id']] = $specials['method_name']; } } }elseif (isset($v['kps']) && $v['kps']){ foreach($v['kps'] as $kps){ if(isset($kps['kp_name'])){ $methods_arr[] = $kps['kp_name']; } if(in_array($v['id'],$gen_origin_ids)){ $gen_origin_methods[$kps['kp_id']] = $kps['kp_name']; } } } if($methods_arr){ $gen_topics_msg[$v['id']]['methods'] = implode(",",$methods_arr); } $gen_topics_detail[$v['id']] = $v; } } unset($gen_topics_detail_temp); } unset($topicItems_1); } //年级共性问题 $grade_topics_ids = array(); $grade_topic_data = array(); $sql = "select topic_id from product_grade_common_topic where exam_group_id = '{$exam['exam_group_id']}'"; $grade_data = $this->sConn->createCommand($sql)->queryAll(); if($grade_data){ foreach($grade_data as $k=>$v){ $grade_topics_ids[] = $v['topic_id']; } } if($grade_topics_ids){ $grade_topic_item = $this->aipost('/topic/batchAll', array('topicIds' => $grade_topics_ids)); if ($grade_topic_item && !isset($grade_topic_item['status'])) { foreach ($grade_topic_item as $k => $v) { $v['parse_content'] = $this->topicProcess($v['parse_content']); if($v['type_id'] == 5 || $v['type_id'] == 6){ $v['title'] = preg_replace("/]*[\s]+src[\s]*=[\s]*(([\'\"](\/images\/list_\d\.png)[\'\"])|(\/images\/list_\d\.png))[^>]*>/si", '__________', $v['title']); } $v['title'] = $this->topicProcess($v['title']); if(isset($v['items'][0])){ if (isset($v['items']) && isset($v['items'][0]) && isset($v['items'][0]['options'])) { foreach ($v['items'][0]['options'] as $key => $val) { $v['items'][0]['options'][$key]=(array)$v['items'][0]['options'][$key]; $v['items'][0]['options'][$key]['option_content'] = $this->topicProcess($val['option_content']); } } } $grade_topic_item[$k] =$v; } $grade_topic_data = $grade_topic_item; } } $data['grade_topic_data'] = $grade_topic_data; $data['gen_origin_methods'] = $gen_origin_methods?implode(",",$gen_origin_methods):""; $data['gen_topics_msg'] = $gen_topics_msg; $data['gen_topics'] = $gen_topics; $data['gen_topics_detail'] = $gen_topics_detail; $data['excellent_solution'] = $excellent_solution; $data['wb_isp_version'] = $exam['show_level']; $data['level_rule'] = $exam['level_rule']; $data['examGroups'] = array(); $data['examGroupIds'] = array(); $data['exams'] = array(); $data['examIds'] = array(); $data['prevExams'] = array(); $data['prevExamIds'] = array(); $data['papers'] = array(); $data['paperIds'] = array(); $data['prevPapers'] = array(); $data['prevPaperIds'] = array(); $data['fcTopicIds'] = array(); $data['methodIds'] = array(); $data['methodNames'] = array(); $data['topicIds'] = array(); $data['noTopicIds'] = array(); $data['topicDetails'] = array(); $data['answer_score_details'] = array();//客观题答案明细 if (!isset($data['examGroups'][$exam['exam_group_id']])) { $data['examGroups'][$exam['exam_group_id']] = array( 'examIds' => array(), 'paperIds' => array(), 'examName' => $exam['exam_name'], 'examTime' => $exam['exam_time'], 'fullScore' => $exam['paper_score'], ); } $data['examGroups'][$exam['exam_group_id']]['examIds'][] = $exam['exam_id']; $data['examGroups'][$exam['exam_group_id']]['paperIds'][] = $exam['paper_id']; if (!isset($data['exams'][$exam['exam_id']])) { $data['exams'][$exam['exam_id']] = array( 'paperIds' => array(), 'examName' => $exam['exam_name'], 'examTime' => $exam['exam_time'], 'examGroupId' => $exam['exam_group_id'], 'fullScore' => $exam['paper_score'], ); } $data['exams'][$exam['exam_id']]['paperIds'][] = $exam['paper_id']; if (!isset($data['papers'][$exam['paper_id']])) { $data['papers'][$exam['paper_id']] = array(); } $data['papers'][$exam['paper_id']]['examId'] = $exam['exam_id']; $data['papers'][$exam['paper_id']]['examName'] = $exam['exam_name']; $data['papers'][$exam['paper_id']]['examTime'] = $exam['exam_time']; $data['papers'][$exam['paper_id']]['examGroupId'] = $exam['exam_group_id']; $data['papers'][$exam['paper_id']]['fullScore'] = $exam['paper_score']; $data['examGroupIds'][] = $exam['exam_group_id']; $data['examIds'][] = $exam['exam_id']; $data['paperIds'][] = $exam['paper_id']; // 上一次考试 $sql = "SELECT e.exam_id, p.paper_id FROM exam e JOIN paper p ON p.exam_id = e.exam_id WHERE e.subject_id in(".implode(',',$this->mathSubjectId).") and e.class_id = '" . $exam['class_id'] . "' AND e.create_time < '" . $exam['exam_time'] . "' AND e.status = '1' ORDER BY e.create_time DESC LIMIT 1"; $query = $this->sConn->createCommand($sql)->queryRow(); if ($query) { $codePrev = $sem->getCodeByExamId($query['exam_id']); $data['prevExamIds'][] = $query['exam_id']; $data['prevPaperIds'][] = $query['paper_id']; $data['exams'][$exam['exam_id']]['prevExamId'] = $query['exam_id']; $data['papers'][$exam['paper_id']]['prevPaperId'] = $query['paper_id']; $data['prevExams'][$query['exam_id']] = $exam['exam_id']; $data['prevPapers'][$query['paper_id']] = $exam['paper_id']; // 上次考试总分 $prevQuery = $this->sConn->createCommand(" SELECT score FROM paper WHERE paper_id = '" . $query['paper_id'] . "' ")->queryRow(); if ($prevQuery) { $data['papers'][$exam['paper_id']]['prevFullScore'] = $prevQuery['score']; } unset($prevQuery); // 上次考试的平均得分率 if(empty($codePrev)){ $prevQuery = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS total_num, SUM(scoring) AS total_score, MAX(scoring) AS max_score, MIN(scoring) AS min_score FROM student_paper_relation WHERE is_feedback = '1' AND paper_id = '" . $query['paper_id'] . "' ")->queryRow(); }else{ $prevQuery = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS total_num, SUM(scoring) AS total_score, MAX(scoring) AS max_score, MIN(scoring) AS min_score FROM student_paper_relation_".$codePrev." WHERE is_feedback = '1' AND paper_id = '" . $query['paper_id'] . "' ")->queryRow(); } if ($prevQuery) { $data['papers'][$exam['paper_id']]['prevTotalNum'] = $prevQuery['total_num']; $data['papers'][$exam['paper_id']]['prevTotalScore'] = $prevQuery['total_score']; $data['papers'][$exam['paper_id']]['prevMaxScore'] = $prevQuery['max_score']; $data['papers'][$exam['paper_id']]['prevMinScore'] = $prevQuery['min_score']; $data['papers'][$exam['paper_id']]['prevAvgScore'] = 0; $data['papers'][$exam['paper_id']]['prevAvgRate'] = 0; if ($prevQuery['total_num'] > 0) { $data['papers'][$exam['paper_id']]['prevAvgScore'] = number_format($prevQuery['total_score'] / $prevQuery['total_num'], 2); if (isset($data['papers'][$exam['paper_id']]['prevFullScore']) && $data['papers'][$exam['paper_id']]['prevFullScore'] > 0) { $data['papers'][$exam['paper_id']]['prevAvgRate'] = number_format($prevQuery['total_score'] / ($prevQuery['total_num'] * $data['papers'][$exam['paper_id']]['prevFullScore']), 4) * 100; } } } } unset($query); // 参加考试人数、平均得分率、平均分、及格率、最高分、最低分 if(empty($codeNow)){ $query = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS total_num, SUM(scoring) AS total_score, MAX(scoring) AS max_score, MIN(scoring) AS min_score FROM student_paper_relation WHERE is_feedback = '1' AND paper_id IN (" . implode(',', $data['paperIds']) . ") GROUP BY paper_id ")->queryAll(); }else{ $query = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS total_num, SUM(scoring) AS total_score, MAX(scoring) AS max_score, MIN(scoring) AS min_score FROM student_paper_relation_".$codeNow." WHERE is_feedback = '1' AND paper_id IN (" . implode(',', $data['paperIds']) . ") GROUP BY paper_id ")->queryAll(); } if ($query) { foreach ($query as $k => $v) { $data['papers'][$v['paper_id']]['totalNum'] = $v['total_num']; $data['papers'][$v['paper_id']]['totalScore'] = $v['total_score']; $data['papers'][$v['paper_id']]['maxScore'] = $v['max_score']; $data['papers'][$v['paper_id']]['minScore'] = $v['min_score']; $data['papers'][$v['paper_id']]['avgScore'] = 0; $data['papers'][$v['paper_id']]['avgRate'] = 0; $data['papers'][$v['paper_id']]['avgFluctuate'] = 0; if ($v['total_num'] > 0) { $data['papers'][$v['paper_id']]['avgScore'] = number_format($v['total_score'] / $v['total_num'], 2); if (isset($data['papers'][$exam['paper_id']]['fullScore']) && $data['papers'][$exam['paper_id']]['fullScore'] > 0) { $data['papers'][$v['paper_id']]['avgRate'] = number_format($v['total_score'] / ($v['total_num'] * $data['papers'][$exam['paper_id']]['fullScore']), 4) * 100; if (isset($data['papers'][$v['paper_id']]['prevAvgRate'])) { $data['papers'][$v['paper_id']]['avgFluctuate'] = number_format($data['papers'][$v['paper_id']]['avgRate'] - $data['papers'][$v['paper_id']]['prevAvgRate'], 2); } } } } } unset($query); // 单题班级情况 if(empty($codeNow)){ $sql = " SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, ptr.score, sptr.handlerIndex FROM student_paper_topic_rs sptr JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id) where 1=1 "; //WHERE sptr.handlerIndex = '1'"; }else{ $sql = " SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, ptr.score, sptr.handlerIndex FROM student_paper_topic_rs_".$codeNow." sptr JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id) where 1=1 "; //WHERE sptr.handlerIndex = '1'"; } $sql.="AND sptr.paper_id IN (" . implode(',', $data['paperIds']) . ")"; $query = $this->sConn->createCommand($sql)->queryAll(); $class_topic_score = array(); $topic_score_arr = array(); if ($query) { $data['papers'][$v['paper_id']]['topics'] = array(); foreach ($query as $k => $v) { if (!isset($data['papers'][$v['paper_id']]['topics'][$v['topic_id']])) { $data['papers'][$v['paper_id']]['topics'][$v['topic_id']] = array(); $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['fullScore'] = $v['score']; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['totalScore'] = 0; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['avgScore'] = 0; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['avgRate'] = 0; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['numRight'] = 0; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['numWrong'] = 0; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['studentIds'] = array(); $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['rateLess70'] = array();//得分率低于70%的,选择题错的 $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['classRate'] = 0; } $topic_score_arr[$v['topic_id']] = $v['score']; //班级得分 if (!isset($class_topic_score[$v['paper_id']])) { $class_topic_score[$v['paper_id']] = array(); } if (!isset($class_topic_score[$v['paper_id']][$v['topic_id']])) { $class_topic_score[$v['paper_id']][$v['topic_id']] = array(); } $class_topic_score[$v['paper_id']][$v['topic_id']][] = $v['scoring']; $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['totalScore'] += $v['scoring']; if ($v['is_right'] == 1) { $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['numRight'] ++; } else { if($v["handlerIndex"]==1){ $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['numWrong'] ++; } } if($v["handlerIndex"]==1){ $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['studentIds'][] = $v['student_id']; } if ($v['score'] && ($v['scoring']/$v['score'] < 0.7 && $v["handlerIndex"]==1)) { $data['papers'][$v['paper_id']]['topics'][$v['topic_id']]['rateLess70'][] = $v['student_id']; } } } unset($query); // 缺考人数 if(empty($codeNow)){ $query = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS absent_num FROM student_paper_relation WHERE is_feedback = '0' AND paper_id IN (" . implode(',', $data['paperIds']) . ") GROUP BY paper_id ")->queryAll(); }else{ $query = $this->sConn->createCommand(" SELECT paper_id, COUNT(student_id) AS absent_num FROM student_paper_relation_".$codeNow." WHERE is_feedback = '0' AND paper_id IN (" . implode(',', $data['paperIds']) . ") GROUP BY paper_id ")->queryAll(); } if ($query) { foreach ($query as $k => $v) { $data['papers'][$v['paper_id']]['absentNum'] = $v['absent_num']; } } unset($query); // 及格率 if(empty($codeNow)){ $query = $this->sConn->createCommand(" SELECT paper_id, student_id, scoring FROM student_paper_relation WHERE is_feedback = '1' AND paper_id IN (" . implode(',', $data['paperIds']) . ") ")->queryAll(); }else{ $query = $this->sConn->createCommand(" SELECT paper_id, student_id, scoring FROM student_paper_relation_".$codeNow." WHERE is_feedback = '1' AND paper_id IN (" . implode(',', $data['paperIds']) . ") ")->queryAll(); } if ($query) { foreach ($query as $k => $v) { if (!isset($data['papers'][$exam['paper_id']]['passNum'])) { $data['papers'][$exam['paper_id']]['passNum'] = 0; $data['papers'][$exam['paper_id']]['passNum_90'] = 0; } if (isset($data['papers'][$exam['paper_id']]['fullScore']) && $data['papers'][$exam['paper_id']]['fullScore'] > 0) { if ($v['scoring'] / $data['papers'][$exam['paper_id']]['fullScore'] >= 0.6) { $data['papers'][$exam['paper_id']]['passNum'] ++; } if ($v['scoring'] / $data['papers'][$exam['paper_id']]['fullScore'] >= 0.9) { $data['papers'][$exam['paper_id']]['passNum_90'] ++; } } } unset($query); } foreach ($data['paperIds'] as $paperId) { if (!isset($data['papers'][$exam['paper_id']]['passRate'])) { $data['papers'][$exam['paper_id']]['passRate'] = 0; } if (isset($data['papers'][$v['paper_id']]['totalNum']) && $data['papers'][$v['paper_id']]['totalNum'] > 0 && isset($data['papers'][$exam['paper_id']]['passNum'])) { $data['papers'][$exam['paper_id']]['passRate'] = number_format($data['papers'][$exam['paper_id']]['passNum'] / $data['papers'][$v['paper_id']]['totalNum'], 4) * 100; } } $prevQuery = array(); if ($data['prevPaperIds']) { // 上次考试排名 if(empty($codePrev)){ $prevQuery = $this->sConn->createCommand(" SELECT paper_id, student_id, scoring FROM student_paper_relation WHERE paper_id IN (" . implode(',', $data['prevPaperIds']) . ") AND is_feedback = '1' ORDER BY paper_id ASC, scoring DESC ")->queryAll(); }else{ $prevQuery = $this->sConn->createCommand(" SELECT paper_id, student_id, scoring FROM student_paper_relation_".$codePrev." WHERE paper_id IN (" . implode(',', $data['prevPaperIds']) . ") AND is_feedback = '1' ORDER BY paper_id ASC, scoring DESC ")->queryAll(); } } if ($prevQuery) { foreach ($prevQuery as $k => $v) { if (isset($data['prevPapers'][$v['paper_id']])) { if (!isset($data['papers'][$data['prevPapers'][$v['paper_id']]]['prevRanks'])) { $data['papers'][$data['prevPapers'][$v['paper_id']]]['prevRanks'] = array(); $data['papers'][$data['prevPapers'][$v['paper_id']]]['_prevRanks'] = array(); $data['papers'][$data['prevPapers'][$v['paper_id']]]['_i'] = 0; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j'] = 0; } if (!isset($prevRank[$data['prevPapers'][$v['paper_id']]])) { $prevRank[$data['prevPapers'][$v['paper_id']]] = 0; } if ($data['papers'][$data['prevPapers'][$v['paper_id']]]['_i'] > 0) { if ($v['scoring'] == $data['papers'][$data['prevPapers'][$v['paper_id']]]['_prevRanks'][$data['papers'][$data['prevPapers'][$v['paper_id']]]['_i'] - 1][1]) { $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j'] ++; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_prevRanks'][] = array( $v['student_id'], $v['scoring'], $prevRank[$data['prevPapers'][$v['paper_id']]] ); } else { $prevRank[$data['prevPapers'][$v['paper_id']]] ++; $prevRank[$data['prevPapers'][$v['paper_id']]]+= $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j']; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j'] = 0; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_prevRanks'][] = array( $v['student_id'], $v['scoring'], $prevRank[$data['prevPapers'][$v['paper_id']]] ); } } else { $prevRank[$data['prevPapers'][$v['paper_id']]] ++; $prevRank[$data['prevPapers'][$v['paper_id']]]+= $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j']; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_j'] = 0; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_prevRanks'][] = array( $v['student_id'], $v['scoring'], $prevRank[$data['prevPapers'][$v['paper_id']]] ); } $data['papers'][$data['prevPapers'][$v['paper_id']]]['prevRanks'][$v['student_id']] = $prevRank[$data['prevPapers'][$v['paper_id']]]; $data['papers'][$data['prevPapers'][$v['paper_id']]]['_i'] ++; } } unset($prevRank); } // 本次考试排名 if(empty($codeNow)){ $query = $this->sConn->createCommand(" SELECT spr.paper_id, spr.student_id, si.realname, spr.scoring FROM student_paper_relation spr JOIN student_info si ON si.student_id = spr.student_id WHERE spr.paper_id IN (" . implode(',', $data['paperIds']) . ") AND spr.is_feedback = '1' ORDER BY spr.paper_id ASC, spr.scoring DESC ")->queryAll(); }else{ $query = $this->sConn->createCommand(" SELECT spr.paper_id, spr.student_id, si.realname, spr.scoring FROM student_paper_relation_".$codeNow." spr JOIN student_info si ON si.student_id = spr.student_id WHERE spr.paper_id IN (" . implode(',', $data['paperIds']) . ") AND spr.is_feedback = '1' ORDER BY spr.paper_id ASC, spr.scoring DESC ")->queryAll(); } $studentNames = array(); if ($query) { foreach ($query as $k => $v) { if (!isset($data['papers'][$v['paper_id']]['ranks'])) { $data['papers'][$v['paper_id']]['ranks'] = array(); $data['papers'][$v['paper_id']]['_ranks'] = array(); $data['papers'][$v['paper_id']]['_i'] = 0; $data['papers'][$v['paper_id']]['_j'] = 0; } if (!isset($rank[$v['paper_id']])) { $rank[$v['paper_id']] = 0; } if ($data['papers'][$v['paper_id']]['_i'] > 0) { if ($v['scoring'] == $data['papers'][$v['paper_id']]['_ranks'][$data['papers'][$v['paper_id']]['_i'] - 1][1]) { $data['papers'][$v['paper_id']]['_j'] ++; $data['papers'][$v['paper_id']]['_ranks'][] = array( $v['student_id'], $v['scoring'], $rank[$v['paper_id']] ); } else { $rank[$v['paper_id']] ++; $rank[$v['paper_id']]+= $data['papers'][$v['paper_id']]['_j']; $data['papers'][$v['paper_id']]['_j'] = 0; $data['papers'][$v['paper_id']]['_ranks'][] = array( $v['student_id'], $v['scoring'], $rank[$v['paper_id']] ); } } else { $rank[$v['paper_id']] ++; $rank[$v['paper_id']]+= $data['papers'][$v['paper_id']]['_j']; $data['papers'][$v['paper_id']]['_j'] = 0; $data['papers'][$v['paper_id']]['_ranks'][] = array( $v['student_id'], $v['scoring'], $rank[$v['paper_id']] ); } $data['papers'][$v['paper_id']]['ranks'][] = array( 'studentId' => $v['student_id'], 'realname' => $v['realname'], 'rank' => $rank[$v['paper_id']], ); $data['papers'][$v['paper_id']]['_i'] ++; $studentNames[$v['student_id']] = $v['realname']; } unset($rank); } //班级得分率 $class_topic_rate = array(); if ($class_topic_score) { foreach ($class_topic_score as $_p_id => $t_id_scoring) { if (!isset($class_topic_rate[$_p_id])) { $class_topic_rate[$_p_id] = array(); } foreach ($t_id_scoring as $_t_id => $_t_scoring) { if (isset($topic_score_arr[$_t_id]) && $topic_score_arr[$_t_id] > 0) { $class_topic_rate[$_p_id][$_t_id] = round(array_sum($_t_scoring)/($topic_score_arr[$_t_id]*count($_t_scoring)),2) * 100; }else{ $class_topic_rate[$_p_id][$_t_id] = 0; } } } } unset($class_topic_score); //得分率低于70%的,选择题错的对应的学生名称 if($studentNames && isset($data['papers']) && isset($data['papers'][$v['paper_id']]['topics'])){ foreach ($data['papers'] as $pId => $_topics){ foreach ($_topics['topics'] as $tId => $less70) { foreach ($less70['rateLess70'] as $lessk => $stuId) { if (isset($studentNames[$stuId])) { $data['papers'][$pId]['topics'][$tId]['rateLess70'][$lessk] = $studentNames[$stuId]; } } $data['papers'][$pId]['topics'][$tId]['classRate'] = isset($class_topic_rate[$pId]) && isset($class_topic_rate[$pId][$tId])?$class_topic_rate[$pId][$tId]:0; } } } $data['studentNames'] = $studentNames; unset($studentNames); // 大幅进步、大幅度退步 foreach ($data['papers'] as $key => $val) { if (isset($val['prevRanks']) && isset($val['ranks'])) { foreach ($val['ranks'] as $k => $v) { if (isset($val['prevRanks'][$v['studentId']])) { // 进步 if (!isset($data['papers'][$key]['forwards'])) { $data['papers'][$key]['forwards'] = array(); } if ($val['prevRanks'][$v['studentId']] - $v['rank'] > 0) { if (!isset($data['papers'][$key]['forwards'][$val['prevRanks'][$v['studentId']] - $v['rank']])) { $data['papers'][$key]['forwards'][$val['prevRanks'][$v['studentId']] - $v['rank']] = array(); } $data['papers'][$key]['forwards'][$val['prevRanks'][$v['studentId']] - $v['rank']][] = array( 'studentId' => $v['studentId'], 'realname' => $v['realname'], 'rank' => $v['rank'], 'prevRank' => $val['prevRanks'][$v['studentId']] ); } // 退步 if (!isset($data['papers'][$key]['rewinds'])) { $data['papers'][$key]['rewinds'] = array(); } if ($v['rank'] - $val['prevRanks'][$v['studentId']] > 0) { if (!isset($data['papers'][$key]['rewinds'][$v['rank'] - $val['prevRanks'][$v['studentId']]])) { $data['papers'][$key]['rewinds'][$v['rank'] - $val['prevRanks'][$v['studentId']]] = array(); } $data['papers'][$key]['rewinds'][$v['rank'] - $val['prevRanks'][$v['studentId']]][] = array( 'studentId' => $v['studentId'], 'realname' => $v['realname'], 'rank' => $v['rank'], 'prevRank' => $val['prevRanks'][$v['studentId']] ); } } } if (isset($data['papers'][$key]['forwards'])) { krsort($data['papers'][$key]['forwards'], SORT_NUMERIC); } if (isset($data['papers'][$key]['rewinds'])) { krsort($data['papers'][$key]['rewinds'], SORT_NUMERIC); } } if (isset($val['topics'])) { foreach ($val['topics'] as $k => $v) { if (count($v['studentIds']) > 0) { $data['papers'][$key]['topics'][$k]['avgScore'] = number_format($v['totalScore'] / count($v['studentIds']), 2); if (isset($data['papers'][$key]['topics'][$k]['fullScore']) && $data['papers'][$key]['topics'][$k]['fullScore'] > 0) { $data['papers'][$key]['topics'][$k]['avgRate'] = number_format($v['totalScore'] / (count($v['studentIds']) * $data['papers'][$key]['topics'][$k]['fullScore']), 4) * 100; } } } } } unset($query); // 考试情况分析 if(empty($codeNow)){ $query = $this->sConn->createCommand(" SELECT e.exam_group_id, e.exam_id, sptr.paper_id, sptr.student_id, sptr.topic_id, sptr.type, sptr.is_right, sptr.scoring, ptr.topic_id, ptr.stem_id,ptr.no, ptr.`order`,ptr.score, ptr.method_ids, ptr.method_difficulty,sptr.answer ,sptr.handlerIndex FROM student_paper_topic_rs sptr JOIN student_paper_relation spr ON (spr.paper_id = sptr.paper_id AND spr.student_id = sptr.student_id) JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id AND ptr.type = sptr.type) JOIN paper p ON p.paper_id = ptr.paper_id JOIN exam e ON e.exam_id = p.exam_id WHERE spr.is_feedback = '1' AND sptr.paper_id IN (" . implode(',', $data['paperIds']) . ") ORDER BY sptr.paper_id ASC, sptr.type ASC, ptr.order ASC, sptr.topic_id ASC, sptr.student_id ASC ")->queryAll(); }else{ $query = $this->sConn->createCommand(" SELECT e.exam_group_id, e.exam_id, sptr.paper_id, sptr.student_id, sptr.topic_id, sptr.type, sptr.is_right, sptr.scoring, ptr.topic_id, ptr.stem_id,ptr.no, ptr.`order`,ptr.score, ptr.method_ids, ptr.method_difficulty,sptr.answer ,sptr.handlerIndex FROM student_paper_topic_rs_".$codeNow." sptr JOIN student_paper_relation_".$codeNow." spr ON (spr.paper_id = sptr.paper_id AND spr.student_id = sptr.student_id) JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id AND ptr.type = sptr.type) JOIN paper p ON p.paper_id = ptr.paper_id JOIN exam e ON e.exam_id = p.exam_id WHERE spr.is_feedback = '1' AND sptr.paper_id IN (" . implode(',', $data['paperIds']) . ") ORDER BY sptr.paper_id ASC, sptr.type ASC, ptr.order ASC, sptr.topic_id ASC, sptr.student_id ASC ")->queryAll(); } if($is_qxk){ $qxkKnowledge = SPaperTopicRelation::newKnowledgeRelate();//获取全学科知识点对应老知识点的关系 } if ($query) { //转换试卷中每道题目的序号 $paperNos = $this->transferOrders($data['paperIds'],$is_qxk); //计算出每道必做题 做了的人数 foreach($query as $k => $v){ if (!isset($data['papers'][$v['paper_id']]['doTopicNums'])) {//每道必做题 做了的人数 $data['papers'][$v['paper_id']]['doTopicNums'] = array(); } if (!isset($data['papers'][$v['paper_id']]['doTopicNums'][$v['topic_id']])) { $data['papers'][$v['paper_id']]['doTopicNums'][$v['topic_id']] = 0; } if ($v["handlerIndex"] == 1) { $data['papers'][$v['paper_id']]['doTopicNums'][$v['topic_id']] ++; } } foreach ($query as $k => $v) { if($v['stem_id']){ $new_topic_id = (string)$v['stem_id']; }else{ $new_topic_id = (string)$v['topic_id']; } //客观题答案明细 if($v['type'] == 1 && !$score_type){//单选题 if(!isset($data['answer_score_details'][$v['topic_id']])){ $data['answer_score_details'][$v['topic_id']] = array(); $data['answer_score_details'][$v['topic_id']]['answer'] = ''; $data['answer_score_details'][$v['topic_id']]['option']['A'] = 0; $data['answer_score_details'][$v['topic_id']]['option']['B'] = 0; $data['answer_score_details'][$v['topic_id']]['option']['C'] = 0; $data['answer_score_details'][$v['topic_id']]['option']['D'] = 0; $data['answer_score_details'][$v['topic_id']]['order'] = $v['order']; } if(isset($data['answer_score_details'][$v['topic_id']]['option'][$v['answer']])){ $data['answer_score_details'][$v['topic_id']]['option'][$v['answer']]++; } } if((in_array($v['type'],array(2,11)) && !$score_type ) ||($is_qxk && $v['type']==3)){//多选不定项 $v_answer = str_replace(',','',$v['answer']); if(!isset($data['answer_score_details'][$v['topic_id']])){ $data['answer_score_details'][$v['topic_id']] = array(); $data['answer_score_details'][$v['topic_id']]['answer'] = ''; $data['answer_score_details'][$v['topic_id']]['order'] = $v['order']; } if(isset($data['answer_score_details'][$v['topic_id']]['option'][$v_answer])){ $data['answer_score_details'][$v['topic_id']]['option'][$v_answer]++; }else{ $data['answer_score_details'][$v['topic_id']]['option'][$v_answer] = 1; } } if (!isset($data['papers'][$v['paper_id']]['errorNums'])) { $data['papers'][$v['paper_id']]['errorNums'] = array(); } if (!isset($data['papers'][$v['paper_id']]['errorNums'][$v['no']])) { $data['papers'][$v['paper_id']]['errorNums'][$v['no']] = 0; } if ($v['is_right'] != 1 && $v["handlerIndex"] ==1) { $data['papers'][$v['paper_id']]['errorNums'][$v['no']] ++; } if (!in_array((string)$new_topic_id, $data['topicIds'],true)) { $data['topicIds'][] = $new_topic_id; } if (!in_array((string)$v['topic_id'], $data['noTopicIds'],true)) { $data['noTopicIds'][] = (string)$v['topic_id']; } if (!isset($data['papers'][$v['paper_id']]['topicIds'])) { $data['papers'][$v['paper_id']]['topicIds'] = array(); } if (!isset($data['papers'][$v['paper_id']]['noTopicIds'])) { $data['papers'][$v['paper_id']]['noTopicIds'] = array(); } if (!in_array($new_topic_id, $data['papers'][$v['paper_id']]['topicIds'],true)) { $data['papers'][$v['paper_id']]['topicIds'][] = $new_topic_id; } if (!in_array((string)$v['topic_id'], $data['papers'][$v['paper_id']]['noTopicIds'],true)) { $data['papers'][$v['paper_id']]['noTopicIds'][] = (string)$v['topic_id']; } if (!isset($data['papers'][$v['paper_id']]['topicNos'])) { $data['papers'][$v['paper_id']]['topicNos'] = array(); } $data['papers'][$v['paper_id']]['topicNos'][$v['topic_id']] = $v['no']; //带选做题的新序号 if (!isset($data['papers'][$v['paper_id']]['newTopicNos'])) { $data['papers'][$v['paper_id']]['newTopicNos'] = array(); } $data['papers'][$v['paper_id']]['newTopicNos'][$v['topic_id']] = isset($paperNos[$v['paper_id']][$v['topic_id']])?$paperNos[$v['paper_id']][$v['topic_id']]:$v['no']; if (!isset($data['examGroups'][$v['exam_group_id']]['topicIds'])) { $data['examGroups'][$v['exam_group_id']]['topicIds'] = array(); } if (!in_array($v['topic_id'], $data['examGroups'][$v['exam_group_id']]['topicIds'])) { $data['examGroups'][$v['exam_group_id']]['topicIds'][] = $v['topic_id']; } if (!isset($data['examGroups'][$v['exam_group_id']]['rules'])) { $data['examGroups'][$v['exam_group_id']]['rules'] = array(); } $ruleMethodIds = $v['method_ids']; $ruleType =(in_array($v['type'], array(17, 27)) ? 7 : $v['type']); if($is_qxk && $v["method_ids"]){//如果是全学科的考试转变成老知识点 $methodIds = explode(',', $v['method_ids']); $ruleMethodIds = array(); foreach($methodIds as $methodId){ if(isset($qxkKnowledge[$methodId])){ $ruleMethodIds = array_merge($ruleMethodIds,$qxkKnowledge[$methodId]); } } $ruleMethodIds = empty($ruleMethodIds)?"":join(",",$ruleMethodIds); $ruleType = 8; } $data['examGroups'][$v['exam_group_id']]['rules'][$v['topic_id']] = array( 'num' => 1, 'difficulty' => $v['method_difficulty'], 'type' => $ruleType, 'inMethodIds' => $ruleMethodIds, 'eqMethodIds' => $ruleMethodIds, 'callback' => $v['topic_id'], ); $no = $paperNos[$v['paper_id']][$v['topic_id']]; if ($v['method_ids'] && $data['papers'][$v['paper_id']]['doTopicNums'][$v['topic_id']]) { $methodIds = explode(',', $v['method_ids']); foreach ($methodIds as $methodId) { if (!in_array($methodId, $data['methodIds'])) { $data['methodIds'][] = $methodId; } if (!isset($data['papers'][$v['paper_id']]['methodNos'])) { $data['papers'][$v['paper_id']]['methodNos'] = array(); } if (!isset($data['papers'][$v['paper_id']]['methodNos'][$methodId])) { $data['papers'][$v['paper_id']]['methodNos'][$methodId] = array(); } if (!in_array($no, $data['papers'][$v['paper_id']]['methodNos'][$methodId]) ) { $data['papers'][$v['paper_id']]['methodNos'][$methodId][] = $no; } if (!isset($data['papers'][$v['paper_id']]['methodErrorNums'])) { $data['papers'][$v['paper_id']]['methodErrorNums'] = array(); } if (!isset($data['papers'][$v['paper_id']]['methodErrorNums'][$methodId])) { $data['papers'][$v['paper_id']]['methodErrorNums'][$methodId] = 0; } if ($v['is_right'] != 1 && $v['handlerIndex']==1) { $data['papers'][$v['paper_id']]['methodErrorNums'][$methodId] ++; } if (!isset($data['papers'][$v['paper_id']]['methodErrorStudents'])) { $data['papers'][$v['paper_id']]['methodErrorStudents'] = array(); } if (!isset($data['papers'][$v['paper_id']]['methodErrorStudents'][$methodId])) { $data['papers'][$v['paper_id']]['methodErrorStudents'][$methodId] = array(); } if ($v['is_right'] != 1) { if (!in_array($v['student_id'], $data['papers'][$v['paper_id']]['methodErrorStudents'][$methodId],true) && $v['handlerIndex']==1) { $data['papers'][$v['paper_id']]['methodErrorStudents'][$methodId][] = $v['student_id']; } } if (!isset($data['papers'][$v['paper_id']]['methodFullScores'])) { $data['papers'][$v['paper_id']]['methodFullScores'] = array(); } if (!isset($data['papers'][$v['paper_id']]['methodFullScores'][$methodId])) { $data['papers'][$v['paper_id']]['methodFullScores'][$methodId] = 0; } $data['papers'][$v['paper_id']]['methodFullScores'][$methodId] += $v['score']; if (!isset($data['papers'][$v['paper_id']]['methodScores'])) { $data['papers'][$v['paper_id']]['methodScores'] = array(); } if (!isset($data['papers'][$v['paper_id']]['methodScores'][$methodId])) { $data['papers'][$v['paper_id']]['methodScores'][$methodId] = 0; } $data['papers'][$v['paper_id']]['methodScores'][$methodId] += $v['scoring']; } } } foreach ($data['papers'] as $key => $val) { if (isset($val['errorNums'])) { //重置题号 $i = 1; $newErrorNums = array(); foreach($val['errorNums'] as $k => $v){ $newErrorNums[$i] = $v; $i++; } if($newErrorNums){ $val['errorNums'] = $newErrorNums; $data['papers'][$key]['errorNums'] = $newErrorNums; } foreach ($val['errorNums'] as $k => $v) { if (!isset($data['papers'][$key]['errorRates'])) { $data['papers'][$key]['errorRates'] = array(); } if ($data['papers'][$key]['totalNum'] > 0) { $data['papers'][$key]['errorRates'][$k] = number_format($data['papers'][$key]['errorNums'][$k] / $data['papers'][$key]['totalNum'], 4) * 100; } else { $data['papers'][$key]['errorRates'][$k] = 0; } } } } } } else { echo json_encode(array("status" => 1, "error" => "文件尚未生成")); exit; } if ($data['wb_isp_version'] != 1 || $isFromPast) { //个性化版 if (isset($data['examGroups']) && $data['examGroups'] && is_array($data['examGroups'])) { // 抽题 foreach ($data['examGroups'] as $key => $val) { if($same_bs_data){ $data['examGroups'][$key]['fcTopicIds'] = array(); $data['examGroups'][$key]['fcCallbacks'] = array(); foreach($same_bs_data as $sa_k=>$sa_v){ $has_topic_gaokao[] = $sa_k; foreach($sa_v as $sa_v_topic){ $has_topic_gaokao[] = $sa_v_topic; $data['examGroups'][$key]['fcTopicIds'][] = $sa_v_topic; $data['examGroups'][$key]['fcCallbacks'][$sa_k][] = $sa_v_topic; if (!in_array((string)$sa_v_topic, $data['fcTopicIds'])) { $data['fcTopicIds'][] = (string)$sa_v_topic; } } } }else{ if($labelled_type == 2){//教师端标注抽题 $data['examGroups'][$key]['fcTopicIds'] = array(); $data['examGroups'][$key]['fcCallbacks'] = array(); $sql = "select topic_id,relation_id from exam_topic_label where exam_group_id = '{$key}'"; $etl_data = $this->sConn->createCommand($sql)->queryAll(); if($etl_data){ foreach($etl_data as $etl_data_v){ if($etl_data_v['topic_id'] && $etl_data_v['relation_id']){ $relation_topic_arr = explode(",",$etl_data_v['relation_id']); foreach($relation_topic_arr as $relation_topic_v){ if (!in_array((string)$relation_topic_v, $data['fcTopicIds'])) { $data['fcTopicIds'][] = (string)$relation_topic_v; } $data['examGroups'][$key]['fcTopicIds'][] = $relation_topic_v; $data['examGroups'][$key]['fcCallbacks'][$etl_data_v['topic_id']][] = $relation_topic_v; $has_topic_gaokao[] = $relation_topic_v; } $has_topic_gaokao[] = $etl_data_v['topic_id']; } } } }else{ if (isset($val['rules'])) { $fc = $this->apiPost('/isp/ai', array( 'schoolId' => $this->schoolId, 'rules' => $val['rules'], 'notInTopicIds' => $data['examGroups'][$key]['topicIds'], )); if ($fc && !isset($fc->error)) { $data['examGroups'][$key]['fcTopicIds'] = array(); $data['examGroups'][$key]['fcCallbacks'] = array(); foreach ($fc as $k => $v) { if (!in_array($v->id, $data['fcTopicIds'])) { $data['fcTopicIds'][] = $v->id; } $data['examGroups'][$key]['fcTopicIds'][] = $v->id; $data['examGroups'][$key]['fcCallbacks'][$v->callback][] = $v->id; $has_topic_gaokao[] = $v->id; $has_topic_gaokao[] = $v->callback; } } } } } } $topicDetails=array(); $topicItems_1 = $this->apiPost('/topic/batchAll', array('topicIds' => array_merge( $data['topicIds'], (isset($data['fcTopicIds']) ? $data['fcTopicIds'] : array()) ))); if (isset($topicItems_1->error)) { $error[] = $topicItems_1->error; } elseif (! $topicItems_1) { $error[] = 'Error in pumping system[2]'; } else { foreach ($topicItems_1 as $topicItem) { $topicDetails[(string)$topicItem->id] = (object)$topicItem; } } // $topicItems = $this->apiPost('/topic/batch', // array('topicIds' => array_merge( // $data['topicIds'], // (isset($data['fcTopicIds']) ? $data['fcTopicIds'] : array()) // ))); // // if (isset($topicItems->error)) { // $error[] = $topicItems->error; // } elseif (! $topicItems) { // $error[] = 'Error in pumping system[2]'; // } else { // foreach ($topicItems as $topicItem) { // $topicDetails[$topicItem->id] = (object)$topicItem; // } // } // if($data['topicIds']){ // $condition = "topic_id IN (". implode(',', $data['topicIds']) .")"; // $topicItems_1 = STopic::model()->getRecords($condition, 0, 100, $exam_info['teacher_id'], true); // } // if ($topicItems_1) { // foreach ($topicItems_1 as $topicItem_1) { // $topicDetails[$topicItem_1['id']] = (object)$topicItem_1; // } // } if ($topicDetails) { foreach ($topicDetails as $k => $v) { $v=(array)$v; $v['id'] = (string)$v['id']; $teacher_tips= isset($v['teacher_tips'])?$v['teacher_tips']:""; if(!$teacher_tips){ $teacher_tips = $this->dealTeacherTips($v); } $v['teacher_tips'] = $this->topicProcess($teacher_tips); $v['parse_content'] = $this->topicProcess($v['parse_content']); if($v['type_id'] == 5){ $v['title'] = preg_replace("/]*[\s]+src[\s]*=[\s]*(([\'\"](\/images\/list_\d\.png)[\'\"])|(\/images\/list_\d\.png))[^>]*>/si", '__________', $v['title']); } $v['title'] = $this->topicProcess($v['title']); if(isset($v['items'][0])){ $v['items'][0]=(array)$v['items'][0]; $v['items'][0]['options']=(array)$v['items'][0]['options']; if (isset($v['items']) && isset($v['items'][0]) && isset($v['items'][0]['options'])) { foreach ($v['items'][0]['options'] as $key => $val) { $val=(array)$val; $v['items'][0]['options'][$key]=(array)$v['items'][0]['options'][$key]; $v['items'][0]['options'][$key]['option_content'] = $this->topicProcess($val['option_content']); if(isset($data['answer_score_details'][$v['id']]) && $val['option_correct'] == 1){ $data['answer_score_details'][$v['id']]['answer'] .= $this->numToLetter($key + 1); } } } } $data['topicDetails'][$v['id']] = $v; } unset($topicDetails); } } } else { //分层版 //获取原题以及对应四个层次的提分题 //$preparation_plan_id = $exam['preparation_plan_id']; if($data['level_rule'] == 1){ $isDiffMin = $this->sConn->createCommand(" select template_id,level,topic_id,difficulty_degree from preparation_plan_topic where preparation_plan_id=" . $examId." and is_diff_min = 1")->queryAll(); if($isDiffMin){ $plan_topic_res = $isDiffMin; }else{ $plan_topic_res = $this->sConn->createCommand(" select template_id,level,topic_id,difficulty_degree from preparation_plan_topic where preparation_plan_id=" . $examId)->queryAll(); if($plan_topic_res){ $topicsOrigin = array(); $topicRelation = array(); foreach($plan_topic_res as $k=>$v){ $topicsOrigin[] = $v['template_id']; $topicRelation[$v['template_id']][] = $v; $has_topic_gaokao[] =$v['template_id']; $has_topic_gaokao[] =$v['topic_id']; } if($topicsOrigin){ $topicsOrigin = array_unique($topicsOrigin); $topicDetails = $this->aipost('/topic/batchAll', array('topicIds' => $topicsOrigin)); if (!$topicDetails) { echo json_encode(array("status" => 1, "error" => "获取接口batchALL无数据!")); exit(); } elseif (isset($topicDetails['status']) && $topicDetails['status']==0) { echo json_encode(array("status" => 1, "error" => $topicDetails['error'][0])); exit(); } $topicDiff = array(); foreach($topicDetails as $k=>$v){ if(isset($v['difficulty_degree'])){ $diff = $v['difficulty_degree']; }elseif(isset($v['experience_degree'])){ $diff = $v['experience_degree']; }else{ $diff = 0; } $topicDiff[$v['id']] = $diff; } $new_plan_topic_res = array(); foreach($topicDiff as $k=>$v){ if(isset($topicRelation[$k])){ $arr1 = array(); $arr2 = array(); foreach($topicRelation[$k] as $relation){ $arr1[] = $relation['difficulty_degree']; } $x=$v; $count=count($arr1); for ($i=0; $i <$count ; $i++) { $arr2[]=abs($x-$arr1[$i]); } $min= min($arr2); for ($i=0; $i <$count ; $i++) { if ($min==$arr2[$i]) { $new_plan_topic_res[] = $topicRelation[$k][$i]; break 1; } } } } } $plan_topic_res = $new_plan_topic_res; } } }else{ $plan_topic_res = $this->sConn->createCommand(" select template_id,level,topic_id from preparation_plan_topic where preparation_plan_id=" . $examId)->queryAll(); } if (!$plan_topic_res) { echo json_encode(array("status" => 1, "error" => "文件尚未生成")); exit; } $template_topic_arr = array(); $isp_id_arr = array(); foreach ($plan_topic_res as $v) { $template_id = $v['template_id']; $level = $v['level']; $topic_id = $v['topic_id']; if (!isset($template_topic_arr[$template_id])) { $template_topic_arr[$template_id] = array(); } $template_topic_arr[$template_id][$level] = $topic_id; $isp_id_arr[] = $topic_id; } //试卷中校本题库题是哪些,云题库题是哪些 $sch_id_arr = array(); //试卷中校本题库题是哪些 $yun_id_arr = array(); $sql = 'select topic_id,mode,type,no from paper_topic_relation ptr join paper p on p.paper_id = ptr.paper_id where p.exam_id=' . $examId; $paper_topic_res = $this->sConn->createCommand($sql)->queryAll(); if (!$paper_topic_res) { echo json_encode(array("status" => 1, "error" => "文件尚未生成")); exit; } $topic_no_arr = $this->getTopicNoByPaper($paper_topic_res, $exam['tpl_index']); //获取每道题在试卷中的序号,如 21A,21B foreach ($paper_topic_res as $v) { $v['mode'] == 1 && $sch_id_arr[] = $v['topic_id']; $v['mode'] == 0 && $yun_id_arr [] = $v['topic_id']; } $isp_id_arr = array_merge($isp_id_arr, $yun_id_arr); //获取所有以上题目的详情,以供显示到教师讲案中 $topic_detail_arr = $this->paperTopicDetail($isp_id_arr, $sch_id_arr, $examId,'分层提分题'); if (!$topic_detail_arr) { echo json_encode(array("status" => 1, "error" => "获取不到试卷题目内容")); exit; } foreach($topic_detail_arr as $k_topic=>$v_topic){ if(isset($data['answer_score_details'][(string)$k_topic])){ $data['answer_score_details'][(string)$k_topic]['answer'] = isset($v_topic['answer_format'])?$v_topic['answer_format']:''; } } $diff_id_arr = array_diff($isp_id_arr + $sch_id_arr, array_keys($topic_detail_arr)); if ($diff_id_arr) { //todo 发送消息到补提 echo json_encode(array("status" => 1, "error" => "请等待题库老师补题!")); exit; } else { $data['template_topic_arr'] = $template_topic_arr; $data['topic_details'] = $topic_detail_arr; $data['topic_no_arr'] = $topic_no_arr; unset($template_topic_arr); unset($topic_detail_arr); } } // 获取考点名称 if (isset($data['methodIds']) && $data['methodIds']) { if($is_qxk){ $methods = $this->apiPost('/all_knowledge/knowledge_name', array('knowledgeIds' => $data['methodIds'])); if ($methods && isset($methods->data) && $methods->data) { foreach ($methods->data as $k => $v) { $data['methodNames'][$k] = $v; } unset($methods); } }else{ $methods = $this->apiPost('/special/methods', array('methodIds' => $data['methodIds'])); if ($methods) { foreach ($methods as $k => $v) { $data['methodNames'][$v->method_id] = $v->method_name; } unset($methods); } } } if (isset($data['examGroupIds']) && $data['examGroupIds'] && is_array($data['examGroupIds'])) { // 年级单题情况 // $query = $this->sConn->createCommand(" // SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, e.exam_group_id, ptr.score // FROM student_paper_topic_rs sptr // JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id) // JOIN paper p ON p.paper_id = sptr.paper_id // JOIN exam e ON e.exam_id = p.exam_id // WHERE e.exam_group_id IN (" . implode(',', $data['examGroupIds']) . ") AND sptr.handlerIndex = '1' // ")->queryAll(); ////年级单题情况优化后begining//////////////// // $sql = "SELECT count(0) as count // FROM student_paper_topic_rs sptr // JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id) // JOIN paper p ON p.paper_id = sptr.paper_id // JOIN exam e ON e.exam_id = p.exam_id // WHERE e.exam_group_id IN (" . implode(',', $data['examGroupIds']) . ") AND sptr.handlerIndex = '1'"; // $countNum = $this->sConn->createCommand($sql)->queryRow(); // $query = array(); // if($countNum){ // $num = $countNum['count']; // $limit = 10000; // $page = ceil($num/$limit); // $sql_s = "SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, e.exam_group_id, ptr.score // FROM student_paper_topic_rs sptr // JOIN paper_topic_relation ptr ON (ptr.paper_id = sptr.paper_id AND ptr.topic_id = sptr.topic_id) // JOIN paper p ON p.paper_id = sptr.paper_id // JOIN exam e ON e.exam_id = p.exam_id // WHERE e.exam_group_id IN (" . implode(',', $data['examGroupIds']) . ") AND sptr.handlerIndex = '1'"; // for($i = 1;$i <= $page ; $i++){ // $offset = ($i - 1)*$limit; // $sql = $sql_s." limit {$offset},{$limit}"; // if($query){ // $query_next = $this->sConn->createCommand($sql)->queryAll(); // if($query_next){ // foreach($query_next as $k=>$v){ // array_push($query,$v); // } // } // unset($query_next); // }else{ // $query = $this->sConn->createCommand($sql)->queryAll(); // } // } // } //////////////ending/////////////// //////////newbegining $this->sConn->active = false; $this->sConn = $this->getDbConnection(); $query = array(); if(empty($codeNow)){ $sql = "SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, e.exam_group_id,sptr.handlerIndex FROM student_paper_topic_rs sptr JOIN paper p ON p.paper_id = sptr.paper_id JOIN exam e ON e.exam_id = p.exam_id WHERE e.exam_group_id IN (" . implode(',', $data['examGroupIds']) . ") "; }else{ $sql = "SELECT sptr.student_id, sptr.paper_id, sptr.topic_id, sptr.is_right, sptr.scoring, e.exam_group_id,sptr.handlerIndex FROM student_paper_topic_rs_".$codeNow." sptr JOIN paper p ON p.paper_id = sptr.paper_id JOIN exam e ON e.exam_id = p.exam_id WHERE e.exam_group_id IN (" . implode(',', $data['examGroupIds']) . ") "; } $sptrData = $this->sConn->createCommand($sql)->queryAll(); if($sptrData){ $paperTopic = array(); $paperIds = array(); foreach($sptrData as $k=>$v){ if(!in_array($v['paper_id'], $paperIds,true)){ $paperIds[] = $v['paper_id']; } } if($paperIds){ $sql = "select score,paper_id,topic_id from paper_topic_relation where paper_id in (" . implode(',', $paperIds) . ")"; $ptrData = $this->sConn->createCommand($sql)->queryAll(); if($ptrData){ foreach($ptrData as $k=>$v){ $paperTopic[$v['paper_id']][$v['topic_id']] = $v['score']; } unset($ptrData); } if($paperTopic){ foreach($sptrData as $k=>$v){ if(isset($paperTopic[$v['paper_id']]) && isset($paperTopic[$v['paper_id']][$v['topic_id']])){ $sptrData[$k]['score'] = $paperTopic[$v['paper_id']][$v['topic_id']]; } } $query = $sptrData; } } unset($sptrData); } /////////newending /// $grade_topic_score = array(); if ($query) { foreach ($query as $k => $v) { if (!isset($data['examGroups'][$v['exam_group_id']]['topics'])) { $data['examGroups'][$v['exam_group_id']]['topics'] = array(); } if (!isset($data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']])) { $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']] = array(); $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['fullScore'] = $v['score']; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['totalScore'] = 0; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['avgScore'] = 0; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['avgRate'] = 0; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['numRight'] = 0; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['numWrong'] = 0; $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['studentIds'] = array(); } $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['totalScore'] += $v['scoring']; if ($v['is_right'] == 1) { $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['numRight'] ++; } else { if($v["handlerIndex"]==1){//必做题 $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['numWrong'] ++; } } if($v["handlerIndex"]==1) {//必做题 $data['examGroups'][$v['exam_group_id']]['topics'][$v['topic_id']]['studentIds'][] = $v['student_id']; } //年级得分 if (!isset($grade_topic_score[$v['topic_id']])) { $grade_topic_score[$v['topic_id']] = array(); } $grade_topic_score[$v['topic_id']][] = $v['scoring']; } foreach ($data['examGroups'] as $key => $val) { if (isset($val['topics'])) { foreach ($val['topics'] as $k => $v) { if (count($v['studentIds']) > 0) { $data['examGroups'][$key]['topics'][$k]['avgScore'] = number_format($v['totalScore'] / count($v['studentIds']), 2); if (isset($data['examGroups'][$key]['topics'][$k]['fullScore']) && $data['examGroups'][$key]['topics'][$k]['fullScore'] > 0) { $data['examGroups'][$key]['topics'][$k]['avgRate'] = number_format($v['totalScore'] / (count($v['studentIds']) * $data['examGroups'][$key]['topics'][$k]['fullScore']), 4) * 100; } } } } } } } //debug($data); $grade_topic_rate = array(); if ($grade_topic_score) { foreach ($grade_topic_score as $_t_id => $_t_scoring) { if (isset($topic_score_arr[$_t_id]) && $topic_score_arr[$_t_id] > 0) { $grade_topic_rate[$_t_id] = round(array_sum($_t_scoring)/($topic_score_arr[$_t_id]*count($_t_scoring)),2) * 100; }else{ $grade_topic_rate[$_t_id] = 0; } } } unset($grade_topic_score); unset($topic_score_arr); //高考真题 $data['gaokao_topic'] = array(); if($grade == 3){ $gaokao_topic = array(); $sql = "select topic_id from gaokao_academicr_topic where class_id ='{$classId}'"; $gaokao_data = $this->sConn->createCommand($sql)->queryAll(); if($gaokao_data){ foreach($gaokao_data as $gao){ $gaokao_topic[] = $gao['topic_id']; } } if($gen_origin_methods){ $weak_methodids = array_keys($gen_origin_methods); }else{ $weak_methodids = array(); } if($paper_method_ids){ $paper_methodids = explode(",",$paper_method_ids); }else{ $paper_methodids = array(); } if($has_topic_gaokao){ $has_topic = $has_topic_gaokao; }else{ $has_topic = array(); } $gaokao_topic = $this->acadGaokao($examId,$classId,$has_topic,$weak_methodids,$paper_methodids); if($gaokao_topic){ $topicBatchs = $this->aipost('topic/batchall', array('topicIds' => $gaokao_topic)); if ($topicBatchs && !isset($topicBatchs->error)) { $data['gaokao_topic'] = $this->formatDetails($topicBatchs); } } } //整理客观题明细数据 if($data['answer_score_details']){ $new_answer_score_details = array(); $a = 0; foreach($data['answer_score_details'] as $k=>$v){ if(isset($v['option']) && $v['option']){ foreach($v['option'] as $option_type=>$option_count){ $new_answer_score_details[$a]['id'] = $k; $new_answer_score_details[$a]['order'] = $v['order']; $new_answer_score_details[$a]['answer'] = $v['answer']?$v['answer']:''; $new_answer_score_details[$a]['option'] = $option_type; $new_answer_score_details[$a]['option_count'] = $option_count; $a++; } } } $data['answer_score_details'] = $new_answer_score_details; } $this->sConn->active = false; // 关闭连接 close(); // debug($data); if (isset($data['papers']) && $data['papers'] && is_array($data['papers'])) { // 渲染 foreach ($data['papers'] as $key => $val) { if (!isset($val['examId']) || !$val['examId']) continue; if (!isset($val['examGroupId']) || !$val['examGroupId']) continue; $classname = ClassModel::model()->getClassName($classId); $data = array_merge($val, array( 'methodNames' => (isset($data['methodNames']) ? $data['methodNames'] : array()), 'topicDetails' => (isset($data['topicDetails']) ? $data['topicDetails'] : array()), 'groupTopics' => (isset($data['examGroups']) && isset($data['examGroups'][$val['examGroupId']]) && isset($data['examGroups'][$val['examGroupId']]['topics']) ? $data['examGroups'][$val['examGroupId']]['topics'] : array()), 'fcCallbacks' => (isset($data['examGroups']) && isset($data['examGroups'][$val['examGroupId']]) && isset($data['examGroups'][$val['examGroupId']]['fcCallbacks']) ? $data['examGroups'][$val['examGroupId']]['fcCallbacks'] : array()), 'wb_isp_version' => isset($data['wb_isp_version']) ? $data['wb_isp_version'] : 0, 'template_topic_arr' => isset($data['template_topic_arr']) ? $data['template_topic_arr'] : array(), 'topic_details' => isset($data['topic_details']) ? $data['topic_details'] : array(), 'topic_no_arr' => isset($data['topic_no_arr']) ? $data['topic_no_arr']: array(), 'level_rule' => isset($data['level_rule']) ? $data['level_rule'] : 0, 'gradeTopicRate' => $grade_topic_rate, 'studentNames'=>isset($data['studentNames']) ? $data['studentNames'] : array(), 'excellent_solution'=>isset($data['excellent_solution']) ? $data['excellent_solution'] : array(), 'gen_topics'=>isset($data['gen_topics']) ? $data['gen_topics'] : array(), 'gen_topics_detail'=>isset($data['gen_topics_detail']) ? $data['gen_topics_detail'] : array(), 'gen_topics_msg'=>isset($data['gen_topics_msg']) ? $data['gen_topics_msg'] : array(), 'answer_score_details'=>isset($data['answer_score_details']) ? $data['answer_score_details'] : array(), 'gen_origin_methods'=>isset($data['gen_origin_methods'])?$data['gen_origin_methods']:'', 'gaokao_topic'=>isset($data['gaokao_topic'])?$data['gaokao_topic']:array(), 'setting_arr'=>isset($setting_arr)?$setting_arr:array(), 'grade_topic_data'=>isset($data['grade_topic_data']) ? $data['grade_topic_data'] : array(), 'is_qxk'=>$is_qxk, ) ); $data['className'] = $classname; //是否是精准学习宝学校 $http = http('customer/precision-learning-school/check/'.$this->schoolId, 'GET', $this->authUsername); $response = formatResponse($http); $data['isPrecise'] = isset($response['data']) ? $response['data'] : 0; //教师姓名 $sql = "select t.teacher_id,t.teacher_name from teacher t join teacher_class_relation tcr on t.teacher_id = tcr.teacher_id where tcr.class_id = '{$class_id}' and tcr.semester_id = '{$semesterId}' and t.subjects=3"; $teacher_msg = $this->sConn->createCommand($sql)->queryRow(); if($teacher_msg){ $data['teacherName'] = $teacher_msg['teacher_name']; } $html = $this->renderPartial("academicr_1", $data, true); //echo 11;exit; $htmlpath = str_replace("protected", "", Yii::app()->basePath) . '/upload/tmpDir/academicr/'; //存放生成的HTML路径 $pdfpath = str_replace("protected", "", Yii::app()->basePath) . '/upload/tmpDir/academicr/' . $this->schoolId . "/"; //存放生成的PDF路径 $pdfurl = '/upload/tmpDir/academicr/' . $this->schoolId . "/"; if (!is_dir($htmlpath)) { if (!mkdir($htmlpath, 0777, true)) { exit('Create directory fail: ' . $htmlpath); } }if (!is_dir($pdfpath)) { if (!mkdir($pdfpath, 0777, true)) { exit('Create directory fail1: ' . $pdfpath); } } $htmlpath.=$examId . ".html"; $f = fopen($htmlpath, "w"); fwrite($f, $html); fclose($f); // echo 11;exit; $htmlurl = '/upload/tmpDir/academicr/' . $examId . ".html"; //访问HTML的路径 if (Yii::app()->basePath == "C:\wamp\www\zsyas2\protected") {//本地的basePath $locale='en_US.UTF-8'; // 或 $locale='zh_CN.UTF-8'; setlocale(LC_ALL,$locale); putenv('LC_ALL='.$locale); $htmlurl = "http://zsyte.dev.xueping.com/html/%E9%A6%96%E9%A1%B5.html"; // $pdffname = str_replace(".", "。", $exam_info['class_name'] . "-" . $exam_info['exam_name']); // $pdffname = str_replace(" ", "", $pdffname) . ".pdf"; // $pdffname=iconv("UTF-8", "GBK",$pdffname); $pdffname=$classId."-".$examId.".pdf"; $pdfpath = $pdfpath . $pdffname; $pdfurl = $pdfurl . $pdffname; $header_str = $this->schoolInfo->school_name.$exam_info['class_name']."+++".$exam_info['exam_name']."+++"."时间：".date("Y-m-d",time()); $commond = Yii::app()->params['phantomjs_server'] . " " . Yii::app()->basePath . '/../js/html2pdf_math.js' . " " . " {$htmlurl}" . " {$pdfpath}" . " 176mm*250mm '{$header_str}'"; } else { $locale='en_US.UTF-8'; // 或 $locale='zh_CN.UTF-8'; setlocale(LC_ALL,$locale); putenv('LC_ALL='.$locale); // echo Yii::app()->params['phantomjs'];exit; $htmlurl = "http://" . $_SERVER['SERVER_NAME'] . $htmlurl; // $pdffname = str_replace(".", "。", $exam_info['class_name'] . "-" . $exam_info['exam_name']); // $pdffname = str_replace(" ", "", $pdffname) . ".pdf"; // $pdffname=iconv("UTF-8", "GBK",$pdffname); $pdffname=$classId."-".$examId.".pdf"; $pdfpath = $pdfpath . $pdffname; $pdfurl = $pdfurl . $pdffname; $header_str = $this->schoolInfo->school_name.$exam_info['class_name']."+++".$exam_info['exam_name']."+++"."时间：".date("Y-m-d",time()); // $header_str = ''; $commond = Yii::app()->params['phantomjs_server'] . " " . Yii::app()->basePath . '/../js/html2pdf_math.js' . " " . " {$htmlurl}" . " {$pdfpath}" . " 176mm*250mm '{$header_str}'"; } exec($commond, $res, $code); $ucloud = new HuaweiCloud(); //上传html $rehtml = $examId.".html"; $rehtmlname = 'zsyas2/math_academicr/'.$this->schoolId.'/'. date('Y') . '/' . date('m') . '/' . date('d').'/'. uniqid() . '.' . $rehtml; $uploadHtmlInfo = $ucloud->putFile($rehtmlname, $htmlpath); if($uploadHtmlInfo['status'] == 0){ $html_url = "http://" . $_SERVER['SERVER_NAME'].$htmlurl; }else{ $html_url = $uploadHtmlInfo['url']; @unlink($htmlpath); } $this->sConn->createCommand()->update("exam", array("academicr_html_path"=>$html_url), "exam_id = '{$examId}'"); if(isset($res[0])){ if (strpos($res[0], 'succeed') !== false) {//命令返回成功 if ($this->file_exists($pdfpath)) { $repdf = $examId.".pdf"; $rename = 'zsyas2/math_academicr/'.$this->schoolId.'/'. date('Y') . '/' . date('m') . '/' . date('d').'/'. uniqid() . '.' . $repdf; $uploadInfo = $ucloud->putFile($rename, $pdfpath); if ($uploadInfo['status'] == 0) { $pdfurl="http://" . $_SERVER['SERVER_NAME'].$pdfurl; $this->sConn->createCommand()->update("exam", array("academicr_html_path"=>$html_url,"academicr_pdf_path" => $pdfurl, "academicr_pdf_time" => time(), "is_academicr_pdf" => 1), "exam_id = '{$examId}'"); //throw new CException("PDF文件上传失败"); }else{ @unlink($pdfpath); $pdfurl = $uploadInfo['url']; $this->sConn->createCommand()->update("exam", array("academicr_html_path"=>$html_url,"academicr_pdf_path" => $pdfurl, "academicr_pdf_time" => time(), "is_academicr_pdf" => 1), "exam_id = '{$examId}'"); } // $pdfurl=iconv("GBK", "UTF-8",$pdfurl); // $this->sConn->createCommand()->update("exam", array("academicr_pdf_path" => $pdfurl, "academicr_pdf_time" => time(), "is_academicr_pdf" => 1), "exam_id = '{$examId}'"); // @unlink($htmlpath); } else { $this->sConn->createCommand()->update("exam", array("academicr_pdf_path" => "", "academicr_pdf_time" => 0, "is_academicr_pdf" => 0), "exam_id = '{$examId}'"); // @unlink($htmlpath); throw new CException("PDF文件未找到"); } } else { // @unlink($htmlpath); throw new CException("PDF创建失败"); } }else{ Curl::post(Yii::app()->params['handle_log_api'], array( "exam_group_id" => (string)$val['examGroupId'], "operate_project" => 'zsyas2', "school_id" => $this->schoolId, "title" => '下载教师讲案', "operate_account" => Yii::app()->session['coachInfo']['coach_name'], "operate_method" => $this->action, "operate_url" => $this->getRoute(), "operate_sql" => '', "operate_param" =>json_encode(array('post'=>array("examId"=>$examId,"pdf"=>array("commond"=>$commond,"res"=>$res,"code"=>$code),"htmlurl"=>$html_url))), )); echo json_encode(array("status" => 1, "error" => "PDF创建失败!")); exit; } } } else { throw new CException("系统错误"); } } if($this->curlDownloadImage($pdfurl)){ // if (file_get_contents($pdfurl)) { echo json_encode(array("status" => 0, "error" => "","is_create"=>$is_create)); exit; } else { echo json_encode(array("status" => 1, "error" => "文件尚未生成!")); exit; } } private function getTopicNoByPaper($paper_topcic_relation_arr, $tpl_index) { $topic_no_arr = array(); //每道题的序号 if ($tpl_index == 10 || $tpl_index == 1010) { //10,1010 表示江苏那个有a,b,c,d选做题的模板，编号不能按表里的编号来 $prefix_no = 0; $num = 0; $index_arr = array('A','B','C','D','E'); foreach($paper_topcic_relation_arr as $v) { if (!$prefix_no && $v['type'] == 17) { $prefix_no = $v['no']; $topic_no_arr[$v['topic_id']] = $prefix_no.'A'; } elseif ($prefix_no && $v['type'] == 17) { $num += 1; $topic_no_arr[$v['topic_id']] = $prefix_no.$index_arr[$num]; } if ($v['type'] == 27) { $prefix_no += 1; $topic_no_arr[$v['topic_id']] = $prefix_no; } if ($v['type'] != 17 && $v['type'] != 27){ $topic_no_arr[$v['topic_id']] = $v['no']; } } } else { foreach ($paper_topcic_relation_arr as $v) { $topic_no_arr[$v['topic_id']] = $v['no']; } } return $topic_no_arr; } function get_level_rule($class_id) { if($class_id){ $sql = 'select level_rule,pcr.set_type from product_class_relation pcr join class c on pcr.class_id=c.class_id join product_setting ps on pcr.ps_id=ps.ps_id where c.class_id='.$class_id; $product_res = $this->sConn->createCommand($sql)->queryRow(); if (!$product_res) { //没有找到班级与设置的关系表 return 0; } else { // if ($product_res['set_type'] == 1) { //如果是错题本，还是找以前的配置 // return 0; // } else{ return $product_res['level_rule']; // } } } return 0; } function get_version($class_id) { if($class_id){ $sql = 'select show_level,pcr.set_type from product_class_relation pcr join class c on pcr.class_id=c.class_id join product_setting ps on pcr.ps_id=ps.ps_id where c.class_id='.$class_id; $product_res = $this->sConn->createCommand($sql)->queryRow(); if (!$product_res) { //没有找到班级与设置的关系表 $sql = 'select wb_isp_version from class where class_id='.$class_id; $res = $this->sConn->createCommand($sql)->queryRow(); return $res['wb_isp_version']; } else { if ($product_res['set_type'] == 1) { //如果是错题本，还是找以前的配置 $sql = 'select wb_isp_version from class where class_id='.$class_id; $res = $this->sConn->createCommand($sql)->queryRow(); return $res['wb_isp_version']; } else{ return $product_res['show_level']; } } } return 0; } private function check_pdf($pdf_path) { if (substr($pdf_path, strlen($pdf_path) - 4, 4) == ".pdf") { if (file_exists($pdf_path)) { return true; } } return false; } public function actiondown_load() { //旧下载 暂时注释 /*set_time_limit(0); $data = array(); $time = time(); $examId = safe_replace(Yii::app()->request->getQuery('examId')); $sql = "select c.class_name,e.teacher_id,eg.mark_type,e.name as exam_name,e.academicr_pdf_path,e.academicr_pdf_time,p.paper_id,e.is_academicr_pdf,e.exam_group_id from exam as e left join exam_group as eg on e.exam_group_id=eg.exam_group_id left join paper as p on p.exam_id=e.exam_id left join `class` as c on c.class_id=e.class_id where e.exam_id={$examId}"; $exam_info = $this->sConn->createCommand($sql)->queryRow(); $pdfpath = str_replace("protected", "", Yii::app()->basePath) . $exam_info['academicr_pdf_path']; if ($this->check_pdf($pdfpath)) { $data['coachId'] = $this->coachId; $data['schoolId'] = $this->schoolId; $data['examGroupId'] = (string)$exam_info['exam_group_id']; $data['examId'] = (string)$examId; $data['createTime'] = $time; $pushData=json_encode($data); @$stompconn = new Stomp(Yii::app()->params["stomp_address"]); @$stompconn->send("zsy-task.download-teacher-lecture-data-point", $pushData); unset($stompconn); Header("Content-type:application/pdf"); Header("Accept-Ranges: bytes"); Header("Accept-Length: " . filesize($pdfpath)); Header("Content-Disposition: attachment; filename=" . $this->filter_file_name($exam_info['exam_name']."-".$exam_info['class_name']) . ".pdf"); // 输出文件内容 ob_clean(); flush();// 刷新内容 $file=fopen($pdfpath,"r"); $download_rate=1024; while (!feof($file)){ print fread($file,round($download_rate*1024));// 发送当前部分文件给浏览者 flush();// flush 内容输出到浏览器端 sleep(1);// 终端1秒后继续 } fclose($file); } else { Yii::app()->jump->error('考试不存在或尚未生成PDF'); }*/ //新下载 set_time_limit(0); $data = array(); $time = time(); $examId = safe_replace(Yii::app()->request->getQuery('examId')); $sql = "select c.class_name,e.teacher_id,eg.mark_type,e.name as exam_name,e.academicr_pdf_path,e.academicr_pdf_time,p.paper_id,e.is_academicr_pdf,e.exam_group_id,e.class_id,e.subject_id from exam as e left join exam_group as eg on e.exam_group_id=eg.exam_group_id left join paper as p on p.exam_id=e.exam_id left join `class` as c on c.class_id=e.class_id where e.exam_id={$examId}"; $exam_info = $this->sConn->createCommand($sql)->queryRow(); if($this->curlDownloadImage($exam_info['academicr_pdf_path'])){ // if(file_get_contents($exam_info['academicr_pdf_path'])){ $url = $exam_info['academicr_pdf_path']; // // 获取远程文件大小 // // 注意filesize()无法获取远程文件大小 // $headers = get_headers($url, 1); // $fileSize = $headers['Content-Length']; // //echo $fileSize;exit; // // 设置header头 // // 因为不知道文件是什么类型的，告诉浏览器输出的是字节流 // header('Content-Type: application/pdf'); // // 告诉浏览器返回的文件大小类型是字节 // header('Accept-Ranges:bytes'); // // 告诉浏览器返回的文件大小 // header('Content-Length: ' . $fileSize); // // 告诉浏览器文件作为附件处理并且设定最终下载完成的文件名称 // Header("Content-Disposition: attachment; filename=" . $this->filter_file_name($exam_info['exam_name']."-".$exam_info['class_name']) . ".pdf"); // 输出文件内容 // //针对大文件，规定每次读取文件的字节数为4096字节，直接输出数据 // ob_clean(); // $read_buffer = 1024*1024; // $handle = fopen($url, 'rb'); // //总的缓冲的字节数 // $sum_buffer = 0; // //只要没到文件尾，就一直读取 // while (!feof($handle)) { // echo fread($handle, $read_buffer); // ob_flush(); // } // fclose($handle); $this->curlDownload($url,$this->filter_file_name($exam_info['exam_name']."-".$exam_info['class_name'])); if(in_array($exam_info['subject_id'],array(18,19))){ if($exam_info['subject_id'] == 18){//理综 12物理，13化学，14生物 $subject_arr = array(12,13,14); }else{//文综 $subject_arr = array(15,16,17); } $sql = "select t.teacher_id,t.subjects from teacher_class_relation tcr left join teacher t on tcr.teacher_id = t.teacher_id where tcr.class_id = '{$exam_info['class_id']}' and t.subjects in (".implode(',',$subject_arr).") and t.status = 0 group by t.subjects"; $teacher_info = $this->sConn->createCommand($sql)->queryAll(); if($teacher_info){ $data['coachId'] = $this->coachId; $data['schoolId'] = $this->schoolId; $data['examGroupId'] = (string)$exam_info['exam_group_id']; $data['examId'] = (string)$examId; $data['createTime'] = $time; $data['clazzId'] = (string)$exam_info['class_id']; $data['toDataPoint'] = true; $data['dataPointType'] = 3; foreach($teacher_info as $k=>$v){ if($v['teacher_id']){ $data['teacherId'] = $v['teacher_id']; }else{ $data['teacherId'] = '0'; } @$this->sendKafka('datapoint-logs',$data); } // $pushData=json_encode($data); // @$stompconn = new Stomp(Yii::app()->params["stomp_address"]); // if(isset($stompconn) && $stompconn){ // foreach($teacher_info as $k=>$v){ // if($v['teacher_id']){ // $data['teacherId'] = $v['teacher_id']; // }else{ // $data['teacherId'] = '0'; // } // $pushData=json_encode($data); // @$stompconn->send("zsy-task.download-teacher-lecture-data-point", $pushData); // } // } // unset($stompconn); } }else{ if(in_array($exam_info['subject_id'],array(3,6,51))){ $exam_info['subject_id'] = 3; } $sql = "select t.teacher_id from teacher_class_relation tcr left join teacher t on tcr.teacher_id = t.teacher_id where tcr.class_id = '{$exam_info['class_id']}' and t.subjects = '{$exam_info['subject_id']}' and t.status = 0"; $teacher_info = $this->sConn->createCommand($sql)->queryRow(); if($teacher_info){ $data['teacherId'] = $teacher_info['teacher_id']; }else{ $data['teacherId'] = '0'; } $url = $exam_info['academicr_pdf_path']; $data['coachId'] = $this->coachId; $data['schoolId'] = $this->schoolId; $data['examGroupId'] = (string)$exam_info['exam_group_id']; $data['examId'] = (string)$examId; $data['createTime'] = $time; $data['clazzId'] = (string)$exam_info['class_id']; $data['toDataPoint'] = true; $data['dataPointType'] = 3; @$this->sendKafka('datapoint-logs',$data); // $pushData=json_encode($data); // @$stompconn = new Stomp(Yii::app()->params["stomp_address"]); // @$stompconn->send("zsy-task.download-teacher-lecture-data-point", $pushData); // unset($stompconn); } }else{ Yii::app()->jump->error('考试不存在或尚未生成PDF'); } } function filter_file_name($filename){ return str_replace(array(',','.','/','?','!','@','#','$','%','^','&','*','(',')','-','+','{','}','[',']',':',';','"','`','~'), array('，','。',' ','？','！',' ',' ',' ',' ','·',' ',' ','（','）','-','+','【','】','【','】','：','；','“',' ',' ') , $filename); } function readfile_chunked($filename,$retbytes=true) { $chunksize = 1*(1024*1024); // how many bytes per chunk $buffer = ''; $cnt =0; // $handle = fopen($filename, 'rb'); $handle = fopen($filename, 'rb'); if ($handle === false) { return false; } while (!feof($handle)) { $buffer = fread($handle, $chunksize); echo $buffer; ob_flush(); flush(); if ($retbytes) { $cnt += strlen($buffer); } } $status = fclose($handle); if ($retbytes && $status) { return $cnt; // return num. bytes delivered like readfile() does. } return $status; } private function paperTopicDetail($yun_id_arr, $sch_id_arr, $exam_id, $typestr) { try { $all_id_arr = array_merge($yun_id_arr,$sch_id_arr); if (!$all_id_arr ) { return false; } $data = array(); $total_count = count($all_id_arr); $page_size = 100; $page = ceil($total_count/$page_size); for ($i = 0; $i<$page; $i++) { $offset = $i * $page_size; $id_arr = array_slice($all_id_arr,$offset, $page_size); $topicBatchs = $this->aipost('topic/batchall', array('topicIds' => $id_arr)); if (!$topicBatchs) { throw new Exception('获取接口topic/batchALL数据时无任何返回,type is '.$typestr.' ,exam_id is ('.$exam_id.')'); }if(isset($topicBatchs->status) && $topicBatchs->status == 0 ){ throw new Exception($topicBatchs->error[0]); } else{ $data += $this->formatDetails($topicBatchs); } } return $data; } catch (Exception $e) { return false; } } public function formatDetails($topicBatches) { $optionIndex = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K'); $topicDetails = array(); foreach ($topicBatches AS $ke=>$topic) { if(!isset($topic["teacher_tips"]) || !$topic["teacher_tips"]){ $topicBatches[$ke]["teacher_tips"] = $this->dealTeacherTips($topic); } $topic = (object) $topic; $topic->id = (string)$topic->id; $type = $topic->type_id; 6 == $type && $type = 5; //6表示多空题,多空题也是5 $topicDetails[$topic->id] = array(); $topicDetails[$topic->id]['type'] = $type; $topicDetails[$topic->id]['methods'] = ''; //考点 $topicDetails[$topic->id]['method_id_arr'] = ''; //考点id数组 $topicDetails[$topic->id]['kps'] = ''; //知识点 $topicDetails[$topic->id]['queBody'] = $this->topicProcess($topic->title); //题目详情 $topicDetails[$topic->id]['options'] = ''; $topicDetails[$topic->id]['parse_video_qrcode'] = isset($topic->parse_video_qrcode) ? $topic->parse_video_qrcode : ''; $topicDetails[$topic->id]['answer'] = ''; //每题的正确答案 $topicDetails[$topic->id]['analysis'] = $this->topicProcess($topic->parse_content); //答题解析 $topicDetails[$topic->id]['teacher_tips'] = $this->topicProcess($topic->teacher_tips); //名师点评 $topicDetails[$topic->id]['difficulty_degree'] = isset($topic->difficulty_degree) ? $topic->difficulty_degree : null; $topicDetails[$topic->id]['difficulty'] = $topic->difficulty; $topicDetails[$topic->id]['type_name'] = $topic->type_name; $topicDetails[$topic->id]['source'] = $topic->source; $_methods = array(); $_method_id_arr = array(); if ($topic->specials) { foreach ($topic->specials AS $_method) { $_method = (object) $_method; if ($_method->method_name) { $_methods[] = $_method->method_name; } if (isset($_method->method_id)) { $_method_id_arr[] = $_method->method_id; } } $topicDetails[$topic->id]['methods'] = implode('|', array_unique($_methods)); //考点 $topicDetails[$topic->id]['method_id_arr'] = $_method_id_arr; } $_kps = array(); if (isset($topic->kps) && $topic->kps) { foreach ($topic->kps as $_kp) { $_kp = (object) $_kp; if ($_kp->kp_name) { $_kps[$_kp->kp_id] = $_kp->kp_name; } } $topicDetails[$topic->id]['kps'] = $_kps; //考点 } if ($topic->type_id == 1 || $topic->type_id == 2) { //选择题有选项 if ($topic->items) { if (isset($topic->items[0])) { $topic->items[0] = (object) $topic->items[0]; if (isset($topic->items[0]->options)) { $options = $topic->items[0]->options; if ($options) { $_tmp_options = array(); $anwer_str = ""; foreach ($options AS $_optionIndex => $_option) { $_option = (object) $_option; $_tmp_options[$_optionIndex] = $this->topicProcess($_option->option_content); if ($_option->option_correct) { if($anwer_str == ""){ $anwer_str = $this->topicProcess($optionIndex[$_optionIndex]); // $topicDetails[$topic->id]['answer'] = $this->topicProcess($optionIndex[$_optionIndex]); }else{ $anwer_str .= "、".$this->topicProcess($optionIndex[$_optionIndex]); } } } $topicDetails[$topic->id]['answer'] = $anwer_str; $topicDetails[$topic->id]['answer_format'] = str_replace('、', '', $anwer_str); $_list_type = (int) $topic->items[0]->list_type; $topicDetails[$topic->id]['options'] = $this->option_process($_tmp_options, $_list_type); } } } } } else { if ($topic->items) { if (isset($topic->items[0])) { $topic->items[0] = (object) $topic->items[0]; if (isset($topic->items[0]->options)) { $options = $topic->items[0]->options; if ($options) { $_answer = ''; foreach ($options as $v) { $_option = (object) $v; if (trim($_answer) != '') { $_answer .= ' ; '; } $_answer .= $_option->option_content; } $topicDetails[$topic->id]['answer'] = $this->topicProcess($_answer); } } } } } } return $topicDetails; } private function option_process($options, $list_type) { $option_index = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J'); if ($list_type == 0) { //纵向排列，即1行1个 $option_str = ""; foreach ($options as $key => $option) { $option_str.="

$option_index[$key].$option

"; } } elseif ($list_type == 1) { //横向排列，即1行4个 $option_str = ""; foreach ($options as $key => $option) { $option_str.="

$option_index[$key].$option

"; } } elseif ($list_type == 2) { //1行2个 $option_str = ""; foreach ($options as $key => $option) { if ($key % 2 == 0) { $option1 = $options[$key]; $option_str2 = "

$option_index[$key].$option1

"; $key1 = $key + 1; if (isset($options[$key1])) { $option2 = $options[$key1]; $option_str2.="

$option_index[$key1].$option2

"; } $option_str.=$option_str2; } else { continue; } } } return $option_str; } private function topicProcess($html) { if (preg_match_all('/(]*[\s]+)((src)[\s]*=[\s]*(([\"]([^\"]*)[\"])|([\']([^\']*)[\'])|([^\s]*)))([^>]*>)/si', $html, $arr)) { foreach ($arr[0] as $v) { $process_str = $this->img_process($v); ; $html = str_replace($v, $process_str, $html); } } $html = preg_replace('/style\s*=\s*(([\"]([^\"]*)[\"])|([\']([^\']*)[\']))/si', '', $html); $html = preg_replace('//', '', $html); $html = preg_replace('/<\/p>/', '', $html); $html = preg_replace('//', '', $html); $html = preg_replace('//', '', $html); $html = preg_replace('/<\/big>/', '', $html); $html = str_replace(" ", '', $html); return $html; } private function img_process($img) { $widthArr = array(); $heightArr = array(); $width = ''; $height = ''; if (preg_match('/[\s\'"]width\s*:\s*(\d+\.*\d*)\s*([a-zA-Z]+)*/si', $img, $widthArr)) { $width = $this->length_process($widthArr); } else { if (preg_match('/[\s\'"]width\s*=\s*[\'"]\s*(\d+\.*\d*)\s*([a-zA-Z]+)*;?[\'"]/si', $img, $widthArr)) { $width = $this->length_process($widthArr); } } if ($width) { $width = "width=" . $width; } if (preg_match('/[\s\'"]height\s*:\s*(\d+\.*\d*)\s*([a-zA-Z]+)*/si', $img, $heightArr)) { $height = $this->length_process($heightArr); } else { if (preg_match('/[\s\'"]height\s*=\s*[\'"]\s*(\d+\.*\d*)\s*([a-zA-Z]+)*;?[\'"]/si', $img, $heightArr)) { $height = $this->length_process($heightArr); } } if ($height) { $height = "height=" . $height; } $return_img = preg_replace('/]*[\s]+(src[\s]*=[\s]*(([\"]([^\"]*)[\"])|([\']([^\']*)[\'])|([^\s]*)))([^>]*>)/si', "", $img); return $return_img; } private function length_process($length_arr) { $length = 0.6 * $length_arr[1]; $unit_keys = array_keys($this->units); if (isset($length_arr[2])) { //将直接连接单位改为 单位换算 if (in_array($length_arr[2], $unit_keys)) { $length = $length * $this->units[$length_arr[2]]; } else { $length .= $length_arr[2]; } } return $length; } public function numToUpper($number) { $number = substr($number, 0, 2); $arr = array('零', '一', '二', '三', '四', '五', '六', '七', '八', '九'); if (strlen($number) == 1) { $result = $arr[$number]; } else { if ($number == 10) { $result = '十'; } else { if ($number < 20) { $result = '十'; } else { $result = $arr[substr($number, 0, 1)] . '十'; } if (substr($number, 1, 1) != '0') { $result .= $arr[substr($number, 1, 1)]; } } } return $result; } public function numToLetter($number) { $letters = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); $number = (int) $number; $result = ''; if ($number >= 1 AND $number <= 26) { $result = $letters[$number - 1]; } return $result; } public function actionDownload() { $exam_id = safe_replace(Yii::app()->request->getQuery('exam_id')); $host = ''; $databases_data = BusinessDatabase::model()->find('school_id=:school_id', array(':school_id' => $this->schoolId)); if ($databases_data) { $host = isset(Yii::app()->params['static_url'][$databases_data->group_id]) ? Yii::app()->params['static_url'][$databases_data->group_id] : Yii::app()->params['api_host'].'/uploads/'; } $exam_data = Exam::model()->find('exam_id=:exam_id', array(':exam_id' => $exam_id)); if ($exam_data) { $filename = $exam_data->topwb_pdf_path; $filenames = explode('/', $filename); $filenames = array_reverse($filenames); if (!filter_var(trim($filename), FILTER_VALIDATE_URL)) { //没有http $filename = $host . '/' . $filename; } header('Content-Description: File Transfer'); header('Content-Type: application/vnd.android.package-archive'); header('Content-Disposition: attachment; filename=' . $filenames[0]); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $filename); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 0); curl_setopt($ch, CURLOPT_WRITEFUNCTION, function ($ch, $buffer) { echo $buffer; return strlen($buffer); }); curl_exec($ch); curl_close($ch); /*$content = curlDownloadImage($filename); $length=strlen($content);//取得字符串长度，即文件大小，单位是字节 $encoded_filename = rawurlencode($filename);//采用rawurlencode避免空格被替换为+ $ua = $_SERVER["HTTP_USER_AGENT"];//获取用户浏览器UA信息 header('Content-Type: application/octet-stream');//告诉浏览器输出内容类型，必须 header('Content-Encoding: none');//内容不加密，gzip等，可选 header("Content-Transfer-Encoding: binary" );//文件传输方式是二进制，可选 header("Content-Length: ".$length);//告诉浏览器文件大小，可选 if (preg_match("/MSIE/", $ua)) {//从UA中找到MSIE判断是IE header('Content-Disposition: attachment; filename="' . $encoded_filename . '"'); } else if (preg_match("/Firefox/", $ua)) {//同理判断火狐 header('Content-Disposition: attachment; filename*="utf8\'\'' . $filenames[0] . '"'); } else {//其他情况，谷歌等 header('Content-Disposition: attachment; filename="' . $filenames[0] . '"'); } echo $content; exit();*/ } } public function actionStatistics() { $data = array(); $semester_data = Semester::model()->findAll(); if ($semester_data) { $data['semester'] = $semester_data; } else { $data['semester'] = array(); } $data['school_info'] = $this->schoolInfo; $this->render('statistics', $data); } public function actionPastacdemicrs() { $param_semester_id = safe_replace(Yii::app()->request->getQuery('semester')); $param_grad_id = safe_replace(Yii::app()->request->getQuery('grade')); $param_class_id = safe_replace(Yii::app()->request->getQuery('class')); $param_exam_name = safe_replace(Yii::app()->request->getQuery('exam_name')); $data = array( 'current_sem_id' =>0, 'current_grade_id'=>0, 'current_class_id'=>0, 'current_exam_name'=>'', 'sem_arr' => array(), 'class_arr' => array() ); if ($param_semester_id) { $data['current_sem_id'] = $param_semester_id; } if ($param_grad_id) { $data['current_grade_id'] = $param_grad_id; } if ($param_class_id) { $data['current_class_id'] = $param_class_id; } if ($param_exam_name) { $data['current_exam_name'] = $param_exam_name; } //获取所有过去的学期,默认当前学期的第一学期被选中 $_current_sem_start_time = 0; $sql = 'select start_time from semester where status=1 limit 1'; $res = $this->sConn->createCommand($sql)->queryRow(); $start_time = $res['start_time']; if (!$start_time) { Yii::app()->jump->error('该学校无当前学期,请检查学期是否设置错误'); } $sql = 'select semester_id,semester_name from semester where status=0 and start_time < '.$start_time.' order by start_time desc '; $res = $this->sConn->createCommand($sql)->queryAll(); if (!$res) { Yii::app()->jump->error('以前的学期不存在'); } $sem_arr = array(); foreach ($res as $v) { $sem_arr[$v['semester_id']] = $v['semester_name']; } $data['sem_arr'] = $sem_arr; if (!$data['current_sem_id']) { $data['current_sem_id'] = $res[0]['semester_id']; } //如果选择了年级,显示出对应的班级 if ($param_grad_id) { $class_arr = array(); $sql = 'select class_id,class_name from class where semester_id='.$data['current_sem_id'].' and grade='.$param_grad_id; $res = $this->sConn->createCommand($sql)->queryAll(); foreach ($res as $v) { $class_arr[$v['class_id']] = $v['class_name']; } $data['class_arr'] = $class_arr; } //符合查询条件的考试 $sql = 'select e.exam_id,e.name,e.is_academicr_pdf,c.class_id,c.class_name from exam e join class c on c.class_id=e.class_id join class_exam_printer cep on cep.class_id=e.class_id and cep.exam_id=e.exam_id where e.semester_id='.$data['current_sem_id'].' and e.status=1 and cep.type=0 and e.subject_id in ('.implode(',',$this->mathSubjectId).') '; if ($param_grad_id) { $sql.= ' and c.grade='.$param_grad_id; } if ($param_class_id) { $sql.= ' and c.class_id='.$param_class_id; } if ($param_exam_name) { $sql .= ' and e.name like "%'.$param_exam_name.'%"'; } $sql .= ' order by cep.add_time desc'; $res = $this->sConn->createCommand($sql)->query(); $data['page_total'] = $res->rowCount; $sql = $res->queryString." limit :offset, :limit"; $command = $this->sConn->createCommand($sql); $pager = new CPagination($res->rowCount, 10); $offset = $pager->getOffset(); $command->bindValue(":offset", $offset); $limit = $pager->getLimit(); $command->bindValue(":limit", $limit); $res = $command->queryAll(); if (!$res) { $exam_data = array(); } else{ foreach ($res as $v) { $exam_id = $v['exam_id']; $exam_data[$exam_id]['exam_name'] = $v['name']; $exam_data[$exam_id]['class_name'] = $v['class_name']; $exam_data[$exam_id]['class_id']=$v['class_id']; $exam_data[$exam_id]['status'] = $v['is_academicr_pdf']?'已生成':'未生成'; } } $data['exam_data'] = $exam_data; $data['pager'] = $pager; $this->render('pastacdemicrs',$data); } public function actionGetGradeClass() { $grade = Req::post("grade"); $semester_id = Req::post("semester_id"); $sql = 'select class_id,class_name from class where semester_id='.$semester_id.' and grade='.$grade; $classes = $this->sConn->createCommand($sql)->queryAll(); if ($classes) { $error['success'] = 1; $error['message'] = $classes; } else { $error['success'] = 0; $error['message'] = '未找到班级！'; } echo json_encode($error); exit(); } public function actionS_download() { $semester_id = Req::post("semester_id"); $data = array(); $host = ''; if (!$semester_id) { echo '{"status":-1}'; exit; } $semester_data = Semester::model()->find('semester_id=:semester_id', array(':semester_id' => $semester_id)); if ($semester_data) { $databases_data = BusinessDatabase::model()->find('school_id=:school_id', array(':school_id' => $this->schoolId)); if ($databases_data) { $host = isset(Yii::app()->params['static_url'][$databases_data->group_id]) ? Yii::app()->params['static_url'][$databases_data->group_id] : Yii::app()->params['static_url'][0]; } $str = $host . '/teaching_quality/' . $this->schoolId . '/' . $semester_data->semester_id . '/' . trim($this->schoolInfo->school_name) . '学校' . trim($semester_data->semester_name) . '教学质量统计表.xls'; $file_data = Curl::http_get($str); if ($file_data) { /*校长报告埋点*/ $stomp_data = array(); $stomp_data['coachId'] = $this->coachId; $stomp_data['schoolId'] = $this->schoolId; $stomp_data['semesterId'] = (string)$semester_id; $stomp_data['createTime'] = time(); $stomp_data['toDataPoint'] = true; $stomp_data['dataPointType'] = 4; @$this->sendKafka('datapoint-logs',$stomp_data); // $pushData=json_encode($stomp_data); // @$stompconn = new Stomp(Yii::app()->params["stomp_address"]); // @$stompconn->send("zsy-task.download-coach-schoolmaster-report-data-point", $pushData); // unset($stompconn); echo '{"status":1,"file_path":"' . $str . '"}'; exit; } echo '{"status":0}'; exit; } else { echo '{"status":-2}'; exit; } } /** * 判断远程文件是否存在 * @param string $url 文件地址 * @return boolean */ function url_exists($url) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); //涓嶄笅杞? curl_setopt($ch, CURLOPT_NOBODY, 1); //璁剧疆瓒呮椂 curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 3); curl_setopt($ch, CURLOPT_TIMEOUT, 3); curl_exec($ch); $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE); if ($http_code == 200) { return true; } return false; } function transferOrders($paperIds,$is_qxk=0) { $sql = 'select paper_id,topic_id,type,`order`,stem_id from paper_topic_relation where paper_id in ('.implode(',',$paperIds).') order by paper_id, type asc,`order` asc'; $paper_topcic_relation_res = $this->sConn->createCommand($sql)->queryAll(); $sql = 'select tpl_index,tpl_data,paper_id from exam e join paper p on e.exam_id = p.exam_id where p.paper_id in ('.implode(',',$paperIds).')' ; $tpl_index_res = $this->sConn->createCommand($sql)->queryAll(); $tpl_index_arr = array(); $topic_no_data_arr = $tpl_data_arr = array(); $changeDoToicNo = array(); foreach ($tpl_index_res as $v) { $tpl_index_arr[$v['paper_id']] = $v['tpl_index']; if($v['tpl_data']){ $v['tpl_data'] = preg_replace('/:\s*(-?\d{15,})/', ': "$1"', $v['tpl_data']);//把15位的int转成string $tplData = json_decode($v['tpl_data'],true); if($tplData){ $tplstatus = 0; if(isset($tplData['tplstatus'])){ $tpl_data_arr[$v['paper_id']] = $tplData['tplstatus']; }else{ $tpl_data_arr[$v['paper_id']] = 0; } } //选做题题号 if (isset($tplData['new_items']) && $tplData['new_items']) { $new_items = array_values($tplData['new_items']); foreach ($new_items as $key => &$item) { if (isset($item['sameAliasNo']) && $item['sameAliasNo']>0) { $no =$item['alias']; $item['topicId'] = (string)$item['topicId']; $changeDoToicNo[$v['paper_id']]["list"][$item['topicId']]["sameAliasNo"] = $item['sameAliasNo'];//选做题组id $changeDoToicNo[$v['paper_id']]["list"][$item['topicId']]["smTopicLen"] = $item['smTopicLen'];//选做题组必做数量 $changeDoToicNo[$v['paper_id']]["list"][$item['topicId']]["no"] = $no;//题号 $changeDoToicNo[$v['paper_id']]["list"][$item['topicId']]["topicId"] = $item['topicId'];//题目id $changeDoToicNo[$v['paper_id']]["gather"][$item['sameAliasNo']][]=$item['topicId']; } } } } } $paper_topcic_relation_arr = array(); foreach ( $paper_topcic_relation_res as $v) { $paper_id = $v['paper_id']; $type = $v['type']; $order = $v['order']; $topic_id = (string)$v['topic_id']; $stem_id = (string)$v['stem_id']; if (!isset($paper_topcic_relation_arr[$paper_id])) { $paper_topcic_relation_arr[$paper_id] = array(); } $paper_topcic_relation_arr[$paper_id][] = array( 'type' => $type, 'order' => $order, 'topic_id'=>$topic_id, 'stem_id'=>$stem_id ); } $paper_topic_no_arr = array(); foreach ($paper_topcic_relation_arr as $paper_id => $paper_topic_relation) { $tpl_index = $tpl_index_arr[$paper_id]; $tplstatus = isset($tpl_data_arr[$paper_id])?$tpl_data_arr[$paper_id]:0; $change_do_toicno = isset($changeDoToicNo[$paper_id])?$changeDoToicNo[$paper_id]:array(); $paper_topic_no_arr[$paper_id] =$this->topic_number($paper_topic_relation,$tpl_index,$tplstatus,$is_qxk,$change_do_toicno); } return $paper_topic_no_arr; } function topic_number($paper_topcic_relation_arr, $tpl_index,$tplstatus,$is_qxk=0,$change_do_toicno=array()) { $topic_no_arr = array(); //每道题的序号 if($is_qxk){ $_order = 1; $small_no = 1; //$change_no =65; $change_no_arr = $temp_stem_arr = array(); foreach($paper_topcic_relation_arr as $v){ if($v['stem_id']){ $temp_stem_arr[$v['stem_id']][] = $v['topic_id']; } } foreach ($paper_topcic_relation_arr as $v) { if(!isset($temp_stem_arr[$v['stem_id']]) || count($temp_stem_arr[$v['stem_id']]) == 1){ if(!empty($change_do_toicno["list"]) && isset($change_do_toicno["list"][$v['topic_id']]) && count($change_do_toicno["gather"][$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])>1){//判断是否选做题 if(isset($change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])){ $change_no = $change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]]; }else{ $change_no = 65;//从A开始 } $topic_no_arr[$v['topic_id']] = $_order . chr($change_no) ; $change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]] = $change_no +1; }else{ $topic_no_arr[$v['topic_id']] = $_order; $_order++; } $small_no = 1; }else{//大小提 if(!empty($change_do_toicno["list"]) && isset($change_do_toicno["list"][$v['topic_id']]) && count($change_do_toicno["gather"][$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])>1) {//判断是否选做题 if(isset($change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])){ $change_no = $change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]]; }else{ $change_no = 65;//从A开始 } $_order = $_order . chr($change_no); } $topic_no_arr[$v['topic_id']] = $_order.'('.$small_no.')'; if($small_no == count($temp_stem_arr[$v['stem_id']])){ $small_no = 1; $_order++; } $small_no++; } } }else if ($tpl_index == 10 || $tpl_index == 1010 || $tplstatus == 3 || $tplstatus == 4) { //10,1010 表示江苏那个有a,b,c,d选做题的模板，编号不能按表里的编号来 $prefix_no = 0; $num = 0; $index_arr = array('A','B','C','D','E'); $_order = 0; foreach($paper_topcic_relation_arr as $v) { if (!$prefix_no && $v['type'] == 17) { $_order += 1; //序号加1 $prefix_no = $_order; $topic_no_arr[$v['topic_id']] = $prefix_no.'A'; } elseif ($prefix_no && $v['type'] == 17) { $num += 1; $topic_no_arr[$v['topic_id']] = $prefix_no.$index_arr[$num]; } if ($v['type'] == 27) { $prefix_no += 1; $topic_no_arr[$v['topic_id']] = $prefix_no; } if ($v['type'] != 17 && $v['type'] != 27){ $_order += 1; $topic_no_arr[$v['topic_id']] = $_order; } } } else { //其他模板都是根据order就行 $_order = 0; foreach ($paper_topcic_relation_arr as $v) { if(!empty($change_do_toicno["list"]) && isset($change_do_toicno["list"][$v['topic_id']]) && count($change_do_toicno["gather"][$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])>1) {//判断是否选做题 if (isset($change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]])) { $change_no = $change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]]; } else { $change_no = 65;//从A开始 $_order += 1; } $topic_no_arr[$v['topic_id']] = $_order . chr($change_no); $change_no_arr[$change_do_toicno["list"][$v['topic_id']]["sameAliasNo"]] = $change_no + 1; }else{ $_order += 1; $topic_no_arr[$v['topic_id']] = $_order; } } } return $topic_no_arr; } public function actionAjax_down() { $examId = Req::post("exam_id"); $file_type = Req::post("download_type"); $param['hasStudentNo'] = (int)Req::post("hasStudentNo"); //是否有学号 $param['hasStudentSystemCard'] = (int)Req::post("hasStudentSystemCard"); //是否有学生系统准考证号 $param['hasStudentSchoolCard'] = (int)Req::post("hasStudentSchoolCard"); //是否有学生学校准考证号 $param['hasIdNumber'] = (int)Req::post("hasIdNumber"); //是否有身份证 $param['removeOuterStudent'] = (int)Req::post("removeOuterStudent"); //是否移除借读生 $param['removeZeroStudent'] = (int)Req::post("removeZeroStudent"); //过滤0分考生 $param['hasClazzAchievement'] = (int)Req::post("hasClazzAchievement"); //班级成绩分析表 $param['hasStudentAchievementRank'] = (int)Req::post("hasStudentAchievementRank"); //学生成绩排名分析表 $param['hasGradeAchievement'] = (int)Req::post("hasGradeAchievement"); //年级成绩分析表 $param['hasClazzAvgScore'] = (int)Req::post("hasClazzAvgScore"); //班级平均分表 $param['hasScoreSection'] = (int)Req::post("hasScoreSection"); //班级分数段表 $param['hasSubjectAchievement'] = (int)Req::post("hasSubjectAchievement"); //各科成绩分析表 $param['hasWenLiZongDetail'] = (int)Req::post("hasWenLiZongDetail"); //是否有文综理综单科成绩明细报表 $scoreSectionList = Req::post('scoreSection'); //总分段 $param['isSimpleClazzAchievement'] = (int)Req::post("isSimpleClazzAchievement"); //班级学生成绩分析表(完整版：0；简易版：1，简易版不提供题目统计、答错人数、选项统计、分数段人数、缺考人数) $param['isSimpleClazzAvgScore'] = (int)Req::post("isSimpleClazzAvgScore"); //班级平均分表(完整版：0；简易版：1，简易版不提供题目统计) $param['isSimpleGradeAchievement'] = (int)Req::post("isSimpleGradeAchievement"); //年级学生成绩分析表(完整版：0；简易版：1，简易版不提供题目统计、答错人数、选项统计、分数段人数) $param['totalScoreCoefficient'] = Req::post("totalScoreCoefficient"); //总分系数 $param['excellentRatio'] = Req::post('excellentRatio'); //优秀率 $param['goodRatio'] = Req::post('goodRatio'); //良好率 $param['mediumRatio'] = Req::post('mediumRatio'); //中等率 $param['hasStudentAnswerDetail'] = Req::post("hasClazzChoiceTopicStatistics"); //选择题作答明细表 $param['showSetting'] = Req::post("scoreOfEachQuestion"); //每题得分（学生答案，学生得分 0学生答案，1学生得分） $param['examId'] = $examId; $param['paperSizeType'] = Req::post("paperSizeType"); //A4横向:1;A3纵向:2;默认1; $param['showRankingChanges'] = (int)Req::post("showRankingChanges"); //是否显示排名升降 显示:1;隐藏:0 $param['totalScoreCoefficientIsRounding'] = (int)Req::post("totalScoreCoefficientIsRounding"); //启用总分系数后，是否保留小数，0整数，1保留小数 if(!$param['paperSizeType']) $param['paperSizeType'] =1; if($scoreSectionList){ // $param['scoreSectionList']=explode(',',$scoreSectionList); $param['scoreSectionList']=$scoreSectionList; } if($param['totalScoreCoefficient']=='-1'){ $param['totalScoreCoefficient']=0; } if(!$examId || !$file_type) { echo json_encode(array('status'=>0,'result'=>''));exit; } if($file_type==1 || $file_type==2){ if($file_type==2){ $urlType='excel'; }else{ //word没有 // unset($param['hasScoreSection']); unset($param['hasWenLiZongDetail']); unset($param['hasGradeAchievement']); unset($param['hasSubjectAchievement']); unset($param['isSimpleGradeAchievement']); unset($param['hasStudentAnswerDetail']); // unset($param['showSetting']); $urlType='word'; } //获取是否是全学科组卷 $sql = "select eg.qxk_paper_id,e.class_id,e.name,e.subject_id,e.exam_group_id from exam_group eg join exam e on eg.exam_group_id = e.exam_group_id where e.exam_id= '{$examId}'"; $quan_data = $this->sConn->createCommand($sql)->queryRow(); if($quan_data && $quan_data['qxk_paper_id']){ $url = Yii::app()->params['zsy_api_url'].'/qxk/academic/exam-report/download/'.$urlType; }else{ $url = Yii::app()->params['zsy_api_url'].'/teacher/academic/download/'.$urlType.'/'.$this->schoolId; } $this->setIs_new($examId); $username = $this->schoolId; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $rs = $this->CrmApiPost($url,$param,$username,$password); if(isset($rs->errCode) && $rs->errCode =='00') { //组装打印参数 $printData=array(); $printData['typeId']=18; $printData['productType']=60003; $printData['params']=array( 'classIds'=>array($quan_data['class_id']), 'url'=>$rs->data, 'name'=>$quan_data['name'], 'subjectId'=>$quan_data['subject_id'], 'examGroupId'=>$quan_data['exam_group_id'], ); echo json_encode(array('status'=>1,'result'=>$rs->data,'print'=>$printData));exit; } $errMsg = '下载失败'; if(isset($rs->errMsg)) { $errMsg = $rs->errMsg; } echo json_encode(array('status'=>0,'result'=>$errMsg));exit; } } public function CrmApiPost($url, $arr, $username,$password,$method='POST') { $ch = @curl_init(); $result = FALSE; if ($ch) { $data = json_encode($arr); if($method=='POST'){ // Digest认证 curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC); curl_setopt($ch, CURLOPT_USERPWD, $username .':'. $password); // 不输出头部 curl_setopt($ch, CURLOPT_HEADER, 0); // curl_exec 获取到的内容不直接输出, 而是返回 curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); // 请求重启路由器的地址 传参 进行重启 curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_TIMEOUT,120); curl_setopt($ch, CURLOPT_USERAGENT, 'Api Client/1.0.0 (chengfei@liancaitech.com)'); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_HTTPHEADER, array( 'Content-Type: application/json', 'Content-Length: '. strlen($data), )); }else{ // Digest认证 curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC); curl_setopt($ch, CURLOPT_USERPWD, $username .':'. $password); // 不输出头部 curl_setopt($ch, CURLOPT_HEADER, 0); // curl_exec 获取到的内容不直接输出, 而是返回 curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); // 请求重启路由器的地址 传参 进行重启 curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_USERAGENT, 'Api Client/1.0.0 (chengfei@liancaitech.com)'); } if( !curl_errno($ch)) { $result = json_decode(curl_exec($ch)); } // 释放资源 curl_close($ch); } return $result; } public function setIs_new($exam_id) { if($exam_id) { Exam::model()->updateAll(array('is_new'=>2),'exam_id=:exam_id',array(':exam_id'=>$exam_id)); } } // 操作周周练显示状态 public function actionOprateexam(){ $exam_id = Req::post("exam_id"); $flag = Req::post("flag"); $error['success'] = 0; if (empty($exam_id)) { $error['message'] = '操作失败！'; echo json_encode($error);exit(); } $this->setIs_new($exam_id); if ($this->schoolManager->oprateExamExportDisplay($exam_id,$flag)) { $error['success'] = 1; $error['message'] = '操作成功！'; } else { $error['message'] = '操作失败！'; } echo json_encode($error);exit(); } public function actionGetSection(){ $param=array(); $exam_id = Req::post("exam_id"); $result['success']=0; if(!$exam_id){ exit(json_encode($result)); } //判断考试类型 $is_lecture_download=1; //教师讲案 $is_topwb_download=1; //错题前十 $is_lecture_download_msg=''; $is_topwb_download_msg=''; $exam_data = Exam::model()->find('exam_id=:exam_id', array(':exam_id' => $exam_id)); $xamGroupData=ExamGroup::model()->find('exam_group_id=:exam_group_id', array(':exam_group_id' => $exam_data->exam_group_id)); if($xamGroupData->is_third==1 && $xamGroupData->mark_type==0){ $is_lecture_download=0; $is_topwb_download=0; $is_lecture_download_msg='线下导入成绩不能下载教师讲案'; $is_topwb_download_msg='线下导入成绩不能下载错题前十'; }else{ if($exam_data->is_topwb_pdf!=1){ $is_topwb_download=0; $is_topwb_download_msg='错题前十未生成'; } } $result['download_rule']=array( 'is_lecture_download'=>$is_lecture_download, 'is_topwb_download'=>$is_topwb_download, 'is_lecture_download_msg'=>$is_lecture_download_msg, 'is_topwb_download_msg'=>$is_topwb_download_msg, ); if(isset(Yii::app()->session['session_duoxueke_subject_id'])){ $subjectId= Yii::app()->session['session_duoxueke_subject_id']; }else{ $subjectId= $this->subjectId; } if(!in_array($subjectId,Yii::app()->params['mathSubjectId'])){ $result['download_rule']['is_topwb_download']=0; $result['download_rule']['is_topwb_download_msg']='当前科目暂未上线错题前十'; } $username = $this->schoolInfo->school_id; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $url = Yii::app()->params['zsy_api_url'].'/teacher/academic/exam/score/section/'.$this->schoolId.'/'.$exam_id; $rs = $this->CrmApiPost($url,$param,$username,$password,'GET'); //debug($rs); if(isset($rs->errCode) && $rs->errCode =='00') { $result['success']=1; $result['data']=$rs->data; } exit(json_encode($result)); } //读取考试班级 public function actionGetExamClass(){ $exam_group_id = Req::post("examGroupId"); $is_third = Req::post("isThird"); $result['success']=0; //读取考试 $exam_group_data = ExamGroup::model()->find('exam_group_id=:exam_group_id',array(':exam_group_id'=>$exam_group_id)); if(!$exam_group_data) { $result['msg']='未找到考试信息'; exit(json_encode($result)); } $topic_answer_upload=0; if($is_third){ //判断是否上传答案、试题 $uploadExamInfo=SThirdMultiTemplate::model()->getStatusByExamGroupId($exam_group_id); $uploadStatus=0; if($uploadExamInfo){ if(isset($uploadExamInfo[1])){ if($uploadExamInfo[1]['topic_upload']==1){ $uploadStatus+=1; } } if(isset($uploadExamInfo[2])){ if($uploadExamInfo[2]['answer_upload']==1){ $uploadStatus+=3; } } } if($uploadStatus<4){ $topic_answer_upload=0; }else{ $topic_answer_upload=1; } } $classes=$this->schoolManager->getExportClassByExamGroupId($exam_group_id); $initData=array(); $exam_id=0; if($classes){ foreach ($classes as $key => $val){ $initData['examTitle']=$val['name']; $temp=array('className'=>$val['class_name'],'id'=>$val['class_id']); $check=$this->schoolManager->classExamHasPaperRs($val['exam_id'], $val['class_id']); if($check && $val['status']==1) { $temp['excel'] = 1; $temp['word'] = 1; if ($val['is_topwb_pdf'] == 1) { $temp['error'] = 1; } else { $temp['error'] = 0; } if (!$is_third || $topic_answer_upload == 1) { $temp['teacher'] = 1; } else { $temp['teacher'] = 0; } $exam_id = $val['exam_id']; }elseif($check){ $temp['excel']=1; $temp['word']=0; $temp['error']=0; $temp['teacher']=0; }else{ $temp['excel']=0; $temp['word']=0; $temp['error']=0; $temp['teacher']=0; } $initData['class'][]=$temp; } } // if(!$exam_id) { // $result['msg']='无可下载报告班级'; // exit(json_encode($result)); // } $result['class']=$classes; $username = $this->schoolInfo->school_id; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $url = Yii::app()->params['zsy_api_url'].'/teacher/academic/exam/score/section/'.$this->schoolId.'/'.$exam_id; $rs = $this->CrmApiPost($url,array(),$username,$password,'GET'); if(isset($rs->errCode) && $rs->errCode =='00') { $result['success']=1; $initData['scorePart']=$rs->data; } $result['success']=1; $result['data']=$initData; exit(json_encode($result)); } //发送任务 public function actionPushTask(){ $exam_group_id = Req::post("examGroupId"); $download_type = Req::post("download_type"); $classes = Req::post("class_ids"); //新字段 $param['hasStudentNo'] = (int)Req::post("hasStudentNo"); //是否有学号 $param['hasStudentSystemCard'] = (int)Req::post("hasStudentSystemCard"); //是否有学生系统准考证号 $param['hasStudentSchoolCard'] = (int)Req::post("hasStudentSchoolCard"); //是否有学生学校准考证号 $param['hasIdNumber'] = (int)Req::post("hasIdNumber"); //是否有身份证 $param['removeOuterStudent'] = (int)Req::post("removeOuterStudent"); //是否移除借读生 $param['removeZeroStudent'] = (int)Req::post("removeZeroStudent"); //过滤0分考生 $param['hasClazzAchievement'] = (int)Req::post("hasClazzAchievement"); //班级成绩分析表 $param['hasStudentAchievementRank'] = (int)Req::post("hasStudentAchievementRank"); //学生成绩排名分析表 $param['hasGradeAchievement'] = (int)Req::post("hasGradeAchievement"); //年级成绩分析表 $param['hasClazzAvgScore'] = (int)Req::post("hasClazzAvgScore"); //班级平均分表 $param['hasScoreSection'] = (int)Req::post("hasScoreSection"); //班级分数段表 $param['hasSubjectAchievement'] = (int)Req::post("hasSubjectAchievement"); //各科成绩分析表 $param['hasWenLiZongDetail'] = (int)Req::post("hasWenLiZongDetail"); //是否有文综理综单科成绩明细报表 $param['scoreSection'] = Req::post('scoreSection'); //总分段 $param['isSimpleClazzAchievement'] = (int)Req::post("isSimpleClazzAchievement"); //班级学生成绩分析表(完整版：0；简易版：1，简易版不提供题目统计、答错人数、选项统计、分数段人数、缺考人数) $param['isSimpleClazzAvgScore'] = (int)Req::post("isSimpleClazzAvgScore"); //班级平均分表(完整版：0；简易版：1，简易版不提供题目统计) $param['isSimpleGradeAchievement'] = (int)Req::post("isSimpleGradeAchievement"); //年级学生成绩分析表(完整版：0；简易版：1，简易版不提供题目统计、答错人数、选项统计、分数段人数) $param['totalScoreCoefficient'] = Req::post("totalScoreCoefficient"); //总分系数 $param['excellentRatio'] = Req::post('excellentRatio'); //优秀率 $param['goodRatio'] = Req::post('goodRatio'); //良好率 $param['mediumRatio'] = Req::post('mediumRatio'); //中等率 $param['reportType'] = Req::post('reportType'); //中等率 $param['showSetting'] = Req::post("scoreOfEachQuestion"); //每题得分（学生答案，学生得分） $param['paperSizeType'] = Req::post("paperSizeType"); //纸张设置：A4横向:1;A3纵向:2;默认1; $param['showRankingChanges'] = (int)Req::post("showRankingChanges"); //是否显示排名升降 显示:1;隐藏:0 $param['totalScoreCoefficientIsRounding'] = (int)Req::post("totalScoreCoefficientIsRounding"); //启用总分系数后，是否保留小数，0整数，1保留小数 if(!$param['paperSizeType']) $param['paperSizeType']=1; if($param['totalScoreCoefficient']==-1){ unset($param['totalScoreCoefficient']); } if(!$exam_group_id){ $result['msg']='参数错误，缺少考试ID'; exit(json_encode($result)); } $school_id =$this->schoolId; if(isset(Yii::app()->session['session_duoxueke_subject_id'])){ $subjectId= Yii::app()->session['session_duoxueke_subject_id']; }else{ $subjectId= $this->subjectId; } $result['status']=0; if(!$download_type){ $result['msg']='请选择下载类型'; exit(json_encode($result)); } if(!$classes){ $result['msg']='请选择下载班级'; exit(json_encode($result)); } $classIds=array(); $classNames=array(); if($classes){ foreach ($classes as $val){ $classIds[]=$val['id']; $classNames[]=$val['className']; } } $examData=$this->sConn->createCommand("select exam_id,subject_id from exam where exam_group_id='{$exam_group_id}'")->queryRow(); $paperLabelled=$this->sConn->createCommand("select is_labelled from paper where exam_id='{$examData['exam_id']}'")->queryRow(); if($examData['subject_id']<>12){ $paperLabelled['is_labelled']=0; //批量下载除物理其它学科不判断标注 } $insertSql="insert into download_table_setting(`school_id`,`exam_group_id`,`download_type`,`status`,`create_time`,`class_ids`,`class_names`,`update_time`,`subject_id`,`config`,`is_labelled`) values"; $insertSql.="('".$school_id."','".$exam_group_id."','".$download_type."',1,'".time()."','".implode(',',$classIds)."','".implode(',',$classNames)."',".time().",'".$subjectId."','".json_encode($param)."','".$paperLabelled['is_labelled']."')"; $this->conn->createCommand($insertSql)->execute(); $last_insert_id = $this->conn->createCommand("select last_insert_id()")->queryRow(); $taskId=$last_insert_id['last_insert_id()']; if($download_type==1){ $pushData=array('id'=>$taskId); // $stompconn = new Stomp(Yii::app()->params["stomp_address"]); // $stompconn->send("academic.batchDownloadAchievementReportWord", $pushData); sendDataToKafka('xbkc-academic-batch-download-achievement-report-word',$pushData); unset($stompconn); }elseif ($download_type==2){ $pushData=array('id'=>$taskId); // $stompconn = new Stomp(Yii::app()->params["stomp_address"]); // $stompconn->send("academic.batchDownloadAchievementReportExcel", $pushData); sendDataToKafka('xbkc-academic-batch-download-achievement-report-excel',$pushData); unset($stompconn); } $result['status']=1; exit(json_encode($result)); } //下载进度 public function actionDownloadProgress(){ $subject_id=(int)Req::post("subjectId"); $status=(int)Req::post("status"); $page=(int)Req::post("page"); if(!$page) $page=1; $pageLimit=10; $limit=($page-1)*$pageLimit; $result['success']=0; $where[]="school_id ='{$this->schoolId}'"; if($subject_id){ $where[]="subject_id ='{$subject_id}'"; } if($status){ $where[]="status ='{$status}'"; } $count=$this->conn->createCommand("select count(*) as count from `download_table_setting` where ".implode(' and ',$where))->queryRow(); $total=intval($count['count']); $pageTotal=ceil($total/$pageLimit); $data=$this->conn->createCommand("select id,download_type,status,class_names,zip_url,exam_group_id,class_ids,school_id,subject_id,error_msg from `download_table_setting` where ".implode(' and ',$where)." order by create_time desc limit {$limit},{$pageLimit} ")->queryAll(); $downTask=array(); if($data){ foreach ($data as $val){ //判断错题本 if($val['download_type']==4 && !$val['zip_url']){ $classIds=explode(',',$val['class_ids']); $examPdf=$this->sConn->createCommand("select is_topwb_pdf,topwb_pdf_path,name,subject_id from `exam`where exam_group_id='{$val['exam_group_id']}' and class_id in(".implode(',',$classIds).")")->queryAll(); $files=array(); $isAllCreate=true; $examName=''; $subjectId=0; if($examPdf){ foreach ($examPdf as $v){ $examName=$v['name']; $subjectId=$v['subject_id']; if($v['is_topwb_pdf']==0){ $isAllCreate=false; break; } if (filter_var(trim($v['topwb_pdf_path']), FILTER_VALIDATE_URL)) { //有http $top_url = $v['topwb_pdf_path']; }else{ $top_url = Yii::app()->params['static_url'][$this->schoolGroupId].'/'.$v['topwb_pdf_path']; } $files[] = $top_url; } } if($isAllCreate){ //生成压缩包 $fileName='【'.Yii::app()->params['subjectId'][$subjectId].'】'.'·'.$this->schoolInfo->school_name.'·'.$examName.'·错题前十'; $zip_url=$this->createZip($files,$fileName); //$zip_url=Yii::app()->request->hostInfo.'/'.$zip_url; FIXME 2019-12-23 if($zip_url){ $this->conn->createCommand("update `download_table_setting` set status=2,zip_url='".$zip_url."' where id='".$val['id']."'")->execute(); $val['status']=2; $val['zip_url']=$zip_url; } } } if($val['download_type']==1){ $printProductType=60003; }elseif($val['download_type']==3) { $printProductType = 20003; }elseif($val['download_type']==4){ $printProductType = 10005; }else{ $printProductType=60003; } if(isset($downTask[$val['exam_group_id']])){ //组装打印参数 $printData=array(); $printData['typeId']=18; $printData['productType']=$printProductType; $printData['params']=array( 'classIds'=>explode(',',$val['class_ids']), 'url'=>$val['zip_url'], 'name'=>$downTask[$val['exam_group_id']]['examName'], 'subjectId'=>$val['subject_id'], 'examGroupId'=>$val['exam_group_id'], ); $downTask[$val['exam_group_id']]['task'][]=array( 'downloadType'=>$val['download_type'], 'id'=>$val['id'], 'status'=>$val['status'], 'zipUrl'=>$val['zip_url'], 'class'=>explode(',',$val['class_names']), 'subject'=>Yii::app()->params['subjectId'][$val['subject_id']], 'errorMsg'=>$val['error_msg'], 'print'=>$printData ); }else{ //读取考试信息 $examInfo=$this->sConn->createCommand("select `name` from `exam` where exam_group_id='{$val['exam_group_id']}'")->queryRow(); // $downTask[$val['exam_group_id']]=array( // 'examName'=>$examInfo['name'], // 'task'=>array($val), // ); //组装打印参数 $printData=array(); $printData['typeId']=18; $printData['productType']=$printProductType; $printData['params']=array( 'classIds'=>explode(',',$val['class_ids']), 'url'=>$val['zip_url'], 'name'=>$examInfo['name'], 'subjectId'=>$val['subject_id'], 'examGroupId'=>$val['exam_group_id'], ); $downTask[$val['exam_group_id']]['examName']=$examInfo['name']; $downTask[$val['exam_group_id']]['task'][]=array( 'downloadType'=>$val['download_type'], 'id'=>$val['id'], 'status'=>$val['status'], 'zipUrl'=>$val['zip_url'], 'class'=>explode(',',$val['class_names']), 'subject'=>Yii::app()->params['subjectId'][$val['subject_id']], 'errorMsg'=>$val['error_msg'], 'print'=>$printData ); } } } $result['success']=1; $result['pages']=array( 'totalPage'=>$pageTotal, 'pageLimit'=>$pageLimit, 'nowPage'=>$page, 'total'=>$total ); $result['data']['listData']=array_values($downTask); if(isset(Yii::app()->params['subjectId']) && Yii::app()->params['subjectId']){ $viewData['subject']=Yii::app()->params['subjectId']; unset($viewData['subject'][6]); unset($viewData['subject'][51]); if(isset($viewData['subject'][20])) unset($viewData['subject'][20]); } $result['subjects']=$viewData['subject']; $result['sessionSubjectId']= Yii::app()->session['session_duoxueke_subject_id']; exit(json_encode($result)); } //生成压缩包 private function createZip($files,$fileName) { $zipFileName=$fileName.'.zip'; $dirFile='upload/tmpDir/BatchDownLoadFile/'.date('Y').'/'.date('m').'/'.date('j'); if(!is_dir($dirFile)){ $this->mkdir($dirFile); } $dirFile.='/'.$zipFileName; $zip = new ZipArchive; $zip->open($dirFile, ZipArchive::CREATE); foreach ($files as $file) { $ch = curl_init(); curl_setopt($ch, CURLOPT_POST, 0); curl_setopt($ch,CURLOPT_URL,$file); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $fileContent = curl_exec($ch); curl_close($ch); //$zip->addFromString(basename($file), $fileContent); $zip->addFromString( iconv('utf-8', 'gbk//ignore', basename($file)), $fileContent);//中文使用这个 } $zip->close(); if(file_exists($dirFile)){ //FIXME 20191223 $rename = 'zsyas2/batchDownLoadFile/'.$this->schoolId.'/'. date('Y') . '/' . date('m') . '/' . date('d').'/'. uniqid() . '/' . $zipFileName; $ucloud = new HuaweiCloud(); $uploadInfo = $ucloud->putFile($rename, $dirFile); @unlink($dirFile); if ($uploadInfo['status'] == 0) { return false; }else{ $uploadInfo['url'] = str_replace("%2F","/",$uploadInfo['url']); return $uploadInfo['url']; } } return false; } public function actionBatch(){ ini_set('memory_limit', '500M'); $getName = safe_replace(Yii::app()->request->getQuery('realname')); $grade_id = safe_replace(Yii::app()->request->getQuery('grade_id')); $type_id = safe_replace(Yii::app()->request->getQuery('type_id')); $grade_class_array = array(); $searchProcessSubjectId=$this->subjectId; $con = array(); // 打印任务处理 $ExamModel = Exam::model(); $ClassModel = ClassModel::model(); $printList = array(); $grade_class_data = ClassModel::model()->findAll('grade=:grade', array(':grade' => $grade_id)); if ($grade_class_data) { foreach ($grade_class_data as $v) { $grade_class_array[$v->class_id] = $v->attributes; } } // 获取当前学期班级并组装 $criteria = new CDbCriteria(); $criteria->addCondition('semester_id=:semester_id'); if ($grade_id) { $con = array('c.grade = ' . $grade_id); $criteria->addCondition('grade=:grade'); $criteria->params[':grade'] = $grade_id; } if ($getName) { $con = array_merge($con, array("e.name like '%{$getName}%'")); } if(in_array($this->subjectId,$this->mathSubjectId)){ $con = array_merge($con, array("e.subject_id in (".implode(',',$this->mathSubjectId).")")); $searchProcessSubjectId=3; }else{ $con = array_merge($con, array('e.subject_id = ' . $this->subjectId)); } $con = array_merge($con, array('eg.create_type in (0,1,2,3,5,6)')); if($type_id){ if($type_id==1){ $con =array_merge($con, array('eg.is_third = 0')); }elseif($type_id==2){ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type > 0')); }else{ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type =0')); } } $criteria->params[':semester_id'] = Yii::app()->session['session_semester_id']; $resultList = $this->schoolManager->getExportList(array_merge(array("(e.status = 1 or e.status=4)"), $con),array('e.complete_time desc')); //$resultList = $this->schoolManager->getExportList(array_merge(array("(e.status = 1 )"), $con),array('e.complete_time desc')); if ($resultList["rs"]) { foreach ($resultList['rs'] as $k => $v) { $printList[$k] = $v; //班级数量 $examIds=$ExamModel->getExamIds($v['exam_group_id']); $printList[$k]['class_count']=count($examIds); if(isset(Yii::app()->params['grade_list'][$v['grade']])){ $printList[$k]['grade_name']=Yii::app()->params['grade_list'][$v['grade']]['grade_name']; }else{ $printList[$k]['grade_name']=''; } //试卷类别 if($v['is_third']==0){ $printList[$k]['type_name'] = '校本课程平台试卷'; }elseif($v['is_third']==1){ if($v['mark_type']==0){ $printList[$k]['type_name'] = '第三方导入成绩试卷'; }else{ $printList[$k]['type_name'] = '第三方线上阅卷试卷'; } } //考试日期 $tplData=json_decode($v['tpl_data'],true); if(isset($tplData['examDate'])){ $printList[$k]['exam_date'] =$tplData['examDate']; }else{ $printList[$k]['exam_date'] =''; } //试题数量 if(isset($tplData['totals'])){ $printList[$k]['topic_count'] =$tplData['totals']; }else{ $printList[$k]['topic_count'] =0; } } } $data = array(); // $subject_exam_data = $this->schoolManager->getxuekeStatus($this->semesterId); $data['realname'] = $getName; $data['grade_id'] = $grade_id; $data['grade_class'] = $grade_class_array; $data['printList'] = $printList; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; //$data["subject"] = $subject_exam_data; $data['searchProcessSubjectId']=$searchProcessSubjectId; if (isset($this->schoolInfo->use_zhixue) && !empty($this->schoolInfo->use_zhixue)) { $data["use_zhixue"] = $this->schoolInfo->use_zhixue; } else { $data["use_zhixue"] = 0; } $data['past_sem_exist'] = 0;//默认不存在过去的学期 $data['type_id']=$type_id; $sql = 'select start_time from semester where status=1 limit 1'; $res = $this->sConn->createCommand($sql)->queryRow(); $start_time = $res['start_time']; if (!$start_time) { Yii::app()->jump->error('该学校无当前学期,请检查学期是否设置错误'); } $sql = 'select count(*) as rownum from semester where status=0 and start_time < '.$start_time; $res = $this->sConn->createCommand($sql)->queryRow(); $row_num = $res['rownum']; $row_num && $data['past_sem_exist']=1; unset($resultList); $this->render('index2', $data); } public function actionBatch_duo(){ ini_set('memory_limit', '300M'); $getName = safe_replace(Yii::app()->request->getQuery('realname')); $grade_id = safe_replace(Yii::app()->request->getQuery('grade_id')); $type_id = safe_replace(Yii::app()->request->getQuery('type_id')); $grade_class_array = array(); $searchProcessSubjectId=Yii::app()->session['session_duoxueke_subject_id']; $con = array(); // 打印任务处理 $ExamModel = Exam::model(); $ClassModel = ClassModel::model(); $printList = array(); $grade_class_data = ClassModel::model()->findAll('grade=:grade', array(':grade' => $grade_id)); if ($grade_class_data) { foreach ($grade_class_data as $v) { $grade_class_array[$v->class_id] = $v->attributes; } } // 获取当前学期班级并组装 $criteria = new CDbCriteria(); $criteria->addCondition('semester_id=:semester_id'); if ($grade_id) { $con = array('c.grade = ' . $grade_id); $criteria->addCondition('grade=:grade'); $criteria->params[':grade'] = $grade_id; } if ($getName) { $con = array_merge($con, array("e.name like '%{$getName}%'")); } if(in_array(Yii::app()->session['session_duoxueke_subject_id'],$this->mathSubjectId)){ $con = array_merge($con, array("e.subject_id in (".implode(',',$this->mathSubjectId).")")); $searchProcessSubjectId=3; }else{ $con = array_merge($con, array('e.subject_id = ' . Yii::app()->session['session_duoxueke_subject_id'])); } $con = array_merge($con, array('eg.create_type in (0,1,2,3,5,6)')); if($type_id){ if($type_id==1){ $con =array_merge($con, array('eg.is_third = 0')); }elseif($type_id==2){ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type > 0')); }else{ $con = array_merge($con, array('eg.is_third = 1')); $con = array_merge($con, array('eg.mark_type =0')); } } //如果是物理去掉全学科的组卷 if($searchProcessSubjectId == 12){ // $con = array_merge($con, array('(eg.qxk_paper_id is null or eg.qxk_paper_id=0)')); } $criteria->params[':semester_id'] = Yii::app()->session['session_semester_id']; $resultList = $this->schoolManager->getExportList(array_merge(array("(e.status = 1 or e.status=4)"), $con),array('e.complete_time desc')); //$resultList = $this->schoolManager->getExportList(array_merge(array("(e.status = 1)"), $con),array('e.complete_time desc')); if ($resultList["rs"]) { foreach ($resultList['rs'] as $k => $v) { $printList[$k] = $v; //班级数量 $examIds=$ExamModel->getExamIds($v['exam_group_id']); $printList[$k]['class_count']=count($examIds); if(isset(Yii::app()->params['grade_list'][$v['grade']])){ $printList[$k]['grade_name']=Yii::app()->params['grade_list'][$v['grade']]['grade_name']; }else{ $printList[$k]['grade_name']=''; } //试卷类别 if($v['is_third']==0){ $printList[$k]['type_name'] = '校本课程平台试卷'; }elseif($v['is_third']==1){ if($v['mark_type']==0){ $printList[$k]['type_name'] = '第三方导入成绩试卷'; }else{ $printList[$k]['type_name'] = '第三方线上阅卷试卷'; } } //考试日期 $tplData=json_decode($v['tpl_data'],true); if(isset($tplData['examDate'])){ $printList[$k]['exam_date'] =$tplData['examDate']; }else{ $printList[$k]['exam_date'] =''; } //试题数量 if(isset($tplData['totals'])){ $printList[$k]['topic_count'] =$tplData['totals']; }else{ $printList[$k]['topic_count'] =0; } } } // debug($printList); $data = array(); // $subject_exam_data = $this->schoolManager->getxuekeStatus($this->semesterId); $data['realname'] = $getName; $data['grade_id'] = $grade_id; $data['grade_class'] = $grade_class_array; $data['printList'] = $printList; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; // $data["subject"] = $subject_exam_data; $data['searchProcessSubjectId']=$searchProcessSubjectId; if (isset($this->schoolInfo->use_zhixue) && !empty($this->schoolInfo->use_zhixue)) { $data["use_zhixue"] = $this->schoolInfo->use_zhixue; } else { $data["use_zhixue"] = 0; } $data['past_sem_exist'] = 0;//默认不存在过去的学期 $data['type_id']=$type_id; $sql = 'select start_time from semester where status=1 limit 1'; $res = $this->sConn->createCommand($sql)->queryRow(); $start_time = $res['start_time']; if (!$start_time) { Yii::app()->jump->error('该学校无当前学期,请检查学期是否设置错误'); } $sql = 'select count(*) as rownum from semester where status=0 and start_time < '.$start_time; $res = $this->sConn->createCommand($sql)->queryRow(); $row_num = $res['rownum']; $row_num && $data['past_sem_exist']=1; unset($resultList); // debug($data); $this->render('index2_duo', $data); } //删除任务 public function actionDeleteTask(){ $ids = Req::post("ids"); $result['success']=0; if(!$ids){ $result['msg']='请选择删除的任务'; exit(json_encode($result)); } $rs=$this->conn->createCommand("delete from download_table_setting where id in(".implode(',',$ids).") ")->execute(); if($rs){ $result['success']=1; exit(json_encode($result)); } } private function mkdir($path, $chmod = 0755){ return is_dir($path) || (self::mkdir(dirname($path), $chmod) && mkdir($path, $chmod)); } /** * 发送消息队列 * @return mixed */ private function sendKafka($topic='',$data = array()) { if ($data) { $conf = new RdKafka\Conf(); $conf->set('metadata.broker.list', Yii::app()->params['kafka']); $producer = new RdKafka\Producer($conf); $topic = $producer->newTopic($topic); $topic->produce(RD_KAFKA_PARTITION_UA, 0, json_encode($data)); $producer->poll(0); $result = $producer->flush(10000); if($result===0){ return true; } // $destination = 'zsyte.markingFinishedNotify'; // // $stomp_address = Yii::app()->params['markingFinishedNotifyAddress']; // // $stomp = new Stomp($stomp_address); // $stomp->subscribe($destination); // //// $data = array('schoolId'=>123,'examGroupId'=>45679794,'examIds'=>array('54646465')); // // $bool = $stomp->send($destination, json_encode($data)); } return true; } /* * 假期报告 */ public function actionHoliday_index(){ Url::clean(); $data = array(); $classId = Req::get("classId"); $grade = (int)Req::get("grade"); $semsterId = (string)Req::get("semesterId"); $limit = (int)Req::get("limit") ? (int)Req::get("limit") :10; $newCondition = array(); $schoolId = $this->schoolId; if($grade){ $newCondition[] = 'hrs.grade='.$grade; } if($classId){ $newCondition[] = 'hrs.class_id='.$classId; } if(!$semsterId){ $semsterId = $this->semesterId; } if($semsterId){ $newCondition[] = 'hrs.semester_id='.$semsterId; } $resultList = $this->schoolManager->getHolidayReport($newCondition,array('hrs.create_time desc','hrs.report_id desc'),$limit); $printList = array(); if($resultList["rs"]){ foreach ($resultList['rs'] as $k=>$v) { $printList[$k]=$v; } } if (empty($grade)) { $grade = 'ALL'; } // $classes = $this->schoolManager->getClasses($grade); //获取全学科试用学校 $url = Yii::app()->params['zsy_api_url'].'/cms/api/qxk-math-trial-school/'.$this->schoolId; $username = $this->schoolInfo->school_id; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $rs = $this->CrmApiPost($url,array(),$username,$password,'GET'); $is_qxk_school = (isset($rs->errCode) && $rs->errCode =='00')?$rs->data:false;//是否全学科试用学校---true是全学科--全学科走新的redis的key $mkey = $is_qxk_school?"qxk_holiday_school_semester":"holiday_school_semester"; $semsters = $this->schoolManager->getSemesters(); $sql = "select report_id from holiday_report_setting where semester_id= '{$semsterId}'"; $res = $this->sConn->createCommand($sql)->queryRow(); if(!$res){ if((string)$semsterId === (string)$this->semesterId){ $is_current_semester = 1; }else{ $is_current_semester = 0; } $status = $this->schoolManager->batchInsetHolidayReport($schoolId,$semsterId,$is_current_semester,$is_qxk_school); if(isset($status["status"]) && $status["status"] == 1){ /** * 发送redis开始跑数据 */ // $holiday_status = Yii::app()->holiday_report->hmget('holiday_school_semester',array($schoolId.':'.$semsterId)); // if($holiday_status && isset($holiday_status[0]) && $holiday_status[0]){ Yii::app()->holiday_report->hmset($mkey,array($schoolId.':'.$semsterId=>0)); // } $resultList = $this->schoolManager->getHolidayReport($newCondition,array('hrs.create_time desc','hrs.report_id desc'),$limit); $printList = array(); if($resultList["rs"]){ foreach ($resultList['rs'] as $k=>$v) { $printList[$k]=$v; } } } } // debug($resultList); if(isset($resultList) && $resultList){ $data['is_all_pdf'] = isset($resultList['is_all_pdf'])?$resultList['is_all_pdf']:0; $data['create_time'] = isset($resultList['create_time'])?$resultList['create_time']:0; } $class_select_arr = array(); if($semsterId){ $class_select_arr[] = "hrs.semester_id=".$semsterId; } if(in_array($grade,array(1,2,3))){ $class_select_arr[] = "c.grade=".$grade; } // $class_select_arr[] = "c.class_type=1"; $classes = $this->schoolManager->getClassesByHolidayReport($class_select_arr,array()); $data['limit'] = $limit; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; $data['printList'] = $printList; $data["classes"] = $classes; $data["classId"] = $classId; $data["grade"] = $grade; $data["semsterId"] = $semsterId; $data["semsters"] = $semsters; //数据生成状态 $data['data_status'] = 0; $data_status_arr = Yii::app()->holiday_report->hmget($mkey,array($schoolId.':'.$semsterId)); if($data_status_arr && isset($data_status_arr[0]) && $data_status_arr[0]){ $data['data_status'] = $data_status_arr[0]; } //批量重置数量 $holiday_school_semester = Yii::app()->add_exam_class->hmget('zsyas2:holiday_school_reset',array($this->schoolId.'_'.$semsterId)); if($holiday_school_semester && $holiday_school_semester[0]){ $data['reset_time'] = $holiday_school_semester[0]; }else{ $data['reset_time'] = 0; } $this->render('holiday_index',$data); } /** * 假期报告设置 */ public function actionAjaxSettingHolidayReport(){ $semesterId = $this->semesterId; $schoolId = $this->schoolId; $report_ids = getBatchUuid($schoolId,100); debug(array_values($report_ids)); $status = $this->schoolManager->batchInsetHolidayReport($schoolId,$semesterId); } /** * 假期报告选择学生 */ public function actionSelectStuByHolidayReport(){ $data = array(); $sname = (string)Req::get("sname"); //学生名字 $reportId = (string)Req::get("reportId"); if(!$reportId){ Yii::app()->jump->error('参数错误！'); } //获取班级名称以及周后推送名称 $sql = "select c.class_name,hrs.grade,hrs.class_id,hrs.create_time,hrs.semester_id,s.semester_name 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 where hrs.report_id = '{$reportId}'"; $names = $this->sConn->createCommand($sql)->queryRow(); // debug($names); if(!$names){ $names = array(); $names['name'] = ''; $names['class_name'] = ''; $names['grade'] = 0; }else{ $data['name'] = $names['semester_name'].'假期总结报告'.'---'.$names['class_name']; } $sql = "select student_id,is_report_pdf from holiday_report_student where report_id = '{$reportId}'"; $relateStudent = $this->sConn->createCommand($sql)->queryAll(); $studentIds = array(); $stuIsPdf = array(); if($relateStudent){ foreach ($relateStudent as $studentInfo) { $studentIds[] = (string)$studentInfo['student_id']; $stuIsPdf[(string)$studentInfo['student_id']] = $studentInfo['is_report_pdf']; } } if($studentIds){ $studentNames = SStudentInfo::model()->getStudentNames($studentIds); //求学生名字 if($studentNames){ if($sname){ $i = 1; foreach($studentNames as $k=>$v){ if(strpos($v,$sname) !== false){ $data['list'][$i]['stu_id'] = (string)$k; $data['list'][$i]['stu_name'] = $v; $data['list'][$i]['name'] = $names['class_name'].$v.'假期报告'; $data['list'][$i]['is_pdf'] = isset($stuIsPdf[(string)$k])?$stuIsPdf[(string)$k]:0; $i++; } } }else{ $i = 1; foreach($studentNames as $k=>$v){ $data['list'][$i]['stu_id'] = (string)$k; $data['list'][$i]['stu_name'] = $v; $data['list'][$i]['name'] = $names['class_name'].$v.'假期报告'; $data['list'][$i]['is_pdf'] = isset($stuIsPdf[(string)$k])?$stuIsPdf[(string)$k]:0; $i++; } } } $intarr=array( "subject"=>3, "grade"=>$names['grade'], "examTime"=>$names['create_time'], "students"=>$studentIds, ); //暂时去掉验证订单权限 $data['limitstu']=$studentIds; /* $basic = imsBasicAuth($this->schoolId.'_'.Yii::app()->session['coachInfo']['coach_name'],Yii::app()->params["zsy_api_key"]); $rs = json_decode(Curl::http_post_Basic_json(Yii::app()->params["get_all_limit_url_gather"], json_encode($intarr),$basic),true); if(!$rs){ Yii::app()->jump->error("接口错误"); } if($rs['errCode']!="00"){ Yii::app()->jump->error($rs['errMsg']); } if(!empty($rs['data'])){ $data['limitstu']=$rs['data']; }*/ } $data['reportId'] = $reportId; $data['sname'] = $sname; // debug($data); $this->render('holiday_report_stu',$data); } /** * 下载假期报告 */ public function actionGetHolidayReportFile(){ $reportId = (string)Req::get("reportId"); $studentsIds = (string)Req::get("studentsIds"); $params = array(); if(!$reportId){ echo json_encode(array("success" => 0, "message" => "缺少参数")); exit(); } //获取组ID $sql = "select school_group_id,semester_id from holiday_report_setting where report_id = '{$reportId}'"; $report_settint_data = $this->sConn->createCommand($sql)->queryRow(); if(!$report_settint_data){ echo json_encode(array("success" => 0, "message" => "设置信息错误")); exit(); }else{ $school_group_id = $report_settint_data['school_group_id']; } if(isset($school_group_id) && $school_group_id){ $apiUrl = isset(Yii::app()->params["improve_url"][$school_group_id]) ? Yii::app()->params["improve_url"][$school_group_id] : null; }else{ $apiUrl = isset(Yii::app()->params["improve_url"][$this->schoolGroupId]) ? Yii::app()->params["improve_url"][$this->schoolGroupId] : null; } if(!$studentsIds){ $studentsIds = array(); $sql = "select student_id from holiday_report_student where report_id = '{$reportId}' and is_report_pdf = 1"; $stuArr = $this->sConn->createCommand($sql)->queryAll(); if($stuArr){ foreach($stuArr as $k=>$v){ $studentsIds[] = $v['student_id']; } } }else{ $studentsIds = explode(',',$studentsIds); } if(!$studentsIds || empty($studentsIds)){ echo json_encode(array("success" => 0, "message" => "无生成的学生")); exit(); } $params['reportId'] = $reportId; // $apiUrl = isset(Yii::app()->params["improve_url"][$this->schoolGroupId]) ? Yii::app()->params["improve_url"][$this->schoolGroupId] : null; if(!$apiUrl){ echo json_encode(array("success" => 0, "message" => "接口配置信息错误")); exit(); } $sql = "select class_id,grade,create_time,semester_id from holiday_report_setting where report_id = '{$reportId}'"; $msg = $this->sConn->createCommand($sql)->queryRow(); $Sem=new SSemester(); $code= $Sem->conn->createQuery() ->from('semester') ->where("semester_id = '".$msg['semester_id']."'") ->limit(1) ->query() ->read(); $intarr=array( "schoolId"=>$this->schoolId, "clazzId"=>$msg['class_id'], "semester"=>$code['refer_code'], "grade"=>$msg['grade'], "students"=>$studentsIds, "examTime"=>$msg['create_time'], "classify"=>6, "subject"=>8 ); $schoolInfo = BusinessSchool::model()->find('school_id=:school_id', array(':school_id' => $this->schoolId)); if(isset($schoolInfo['is_allow_download']) && ($schoolInfo['is_allow_download']==1)){ if($studentsIds){ $params["studentIds"] = $studentsIds; } }else{ if(Yii::app()->params["limit_open"]){ // $basic = imsBasicAuth($this->schoolId.'_'.Yii::app()->session['coachInfo']['coach_name'],Yii::app()->params["zsy_api_key"]); // $rs = json_decode(Curl::http_post_Basic_json(Yii::app()->params["get_limit_url"], json_encode($intarr),$basic)); $intarr=array( "subject"=>3, "grade"=>$msg['grade'], "examTime"=>$msg['create_time'], "students"=>$studentsIds, ); $basic = imsBasicAuth($this->schoolId.'_'.Yii::app()->session['coachInfo']['coach_name'],Yii::app()->params["zsy_api_key"]); $rs = json_decode(Curl::http_post_Basic_json(Yii::app()->params["get_all_limit_url_gather"], json_encode($intarr),$basic),true); if(!$rs){ Yii::app()->jump->error("接口错误"); } if($rs['errCode']!="00"){ echo json_encode(array("success" => 0, "message" => $rs['errMsg'])); exit(); } if(!empty($rs['data'])){ $params["studentIds"]=$rs['data']; if(count($rs['data']) 0, "message" =>"请先购买商品")); exit(); } }else{ if($studentsIds){ $params["studentIds"] = $studentsIds; } } } $params['schoolId'] = $this->schoolId; $params['type'] = 4; // $apiUrl = "http://zsyapi.testing.xueping.com"; $rs = Curl::post($apiUrl."/rest/download_week_pdf/index", $params); if(!($rs = json_decode($rs))){ $rs = array( "success" => 0, "message" => "请求接口失败", ); }else{ //更新下载时间 $time = time(); if($studentsIds){ $sql = "update holiday_report_student set is_report_download = 1,report_download_time={$time} where report_id = '{$reportId}' and student_id in (".implode(',',$studentsIds).") and report_download_time = 0"; $this->sConn->createCommand($sql)->execute(); } } // if(isset($rs->downloadPath)){ // if (YII_ENV == 'pro' || YII_ENV == 'production') { // $rs->downloadPath = preg_replace('/http\:\/\/zstatic\d{1,2}/','http://zstatic'.$groupId,$rs->downloadPath); // } // } echo json_encode($rs);exit; } /** * 重置假期报告 */ public function actionAjaxResetHolidayReport(){ $reportId = Req::post('report_id'); $classId = Req::post('class_id'); $semsterId = Req::post('semster_id'); $schoolId = $this->schoolId; if(!$reportId){ echo json_encode(array("status"=>0,"result"=>"假期报告ID不能为空"));exit; } if(!$classId){ echo json_encode(array("status"=>0,"result"=>"班级ID不能为空"));exit; } if(!$semsterId){ echo json_encode(array("status"=>0,"result"=>"学期ID不能为空"));exit; } if((string)$semsterId === (string)$this->semesterId){ $is_current_semester = 1; }else{ $is_current_semester = 0; } //获取全学科试用学校 $url = Yii::app()->params['zsy_api_url'].'/cms/api/qxk-math-trial-school/'.$this->schoolId; $username = $this->schoolInfo->school_id; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $rs = $this->CrmApiPost($url,array(),$username,$password,'GET'); $is_qxk_school = (isset($rs->errCode) && $rs->errCode =='00')?$rs->data:false;//是否全学科试用学校---true是全学科--全学科走新的redis的key $mkey = $is_qxk_school?"qxk_holiday_school_semester":"holiday_school_semester"; $status = $this->schoolManager->resetReport($reportId,$classId,$is_current_semester,$is_qxk_school); Yii::app()->holiday_report->hmset($mkey,array($schoolId.':'.$semsterId=>0)); if($status){ echo json_encode(array("status"=>1,"result"=>"重置成功"));exit; }else{ echo json_encode(array("status"=>0,"result"=>"重置失败"));exit; } } /** * 批量下载假期报告 */ public function actionAjaxBatchPrintHoliday(){ } /** * 批量重置假期报告 */ public function actionAjaxBatchResetHoliday(){ $semesterId = Req::post("semster_id"); if(!$semesterId){ echo json_encode(array("status"=>0,"result"=>"请指定学期Id"));exit; } // echo $semesterId;exit; $school_id = $this->schoolId; $holiday_school_semester = Yii::app()->add_exam_class->hmget('zsyas2:holiday_school_reset',array($school_id.'_'.$semesterId)); if($holiday_school_semester && $holiday_school_semester[0]){ $reset_time = $holiday_school_semester[0]; }else{ $reset_time = 0; } if($reset_time > 4){ echo json_encode(array("status"=>0,"result"=>"重置次数不能超过5次"));exit; } //获取全学科试用学校 $url = Yii::app()->params['zsy_api_url'].'/cms/api/qxk-math-trial-school/'.$this->schoolId; $username = $this->schoolInfo->school_id; $password = md5($this->schoolId.Yii::app()->params['zsy_api_key']); $rs = $this->CrmApiPost($url,array(),$username,$password,'GET'); $is_qxk_school = (isset($rs->errCode) && $rs->errCode =='00')?$rs->data:false;//是否全学科试用学校---true是全学科--全学科走新的redis的key $status = $this->schoolManager->batchResetReport($semesterId); $mkey = $is_qxk_school?"qxk_holiday_school_semester":"holiday_school_semester"; Yii::app()->holiday_report->hmset($mkey,array($school_id.':'.$semesterId=>0)); if($status){ $holiday_school_semester = Yii::app()->add_exam_class->hmset('zsyas2:holiday_school_reset',array($school_id.'_'.$semesterId=>$reset_time+1)); echo json_encode(array("status"=>1,"result"=>"批量重置成功"));exit; }else{ echo json_encode(array("status"=>0,"result"=>"批量重置失败"));exit; } } function curlDownloadImage($url) { if (empty($url)) { return false; } $curl = curl_init($url); // 不取回数据 curl_setopt($curl, CURLOPT_NOBODY, true); // 发送请求 $result = curl_exec($curl); $found = false; // 如果请求没有发送失败 if ($result !== false) { // 再检查http响应码是否为200 $statusCode = curl_getinfo($curl, CURLINFO_HTTP_CODE); if ($statusCode == 200) { $found = true; } } curl_close($curl); return $found; } function curlDownload($url,$title) { if (empty($url) || empty($title)) { return false; } $ext=substr($url,strrpos($url,'.')+1); $path='upload/tmpDir/downloadTempFiled/'; if (!file_exists($path)) { mkdir($path, 0777, true); } $pathName=$path.$title.'.'.$ext; $pathName = iconv('UTF-8', 'GBK', $pathName); // 获取远程文件资源 $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 2); $tempFile = curl_exec($ch); curl_close($ch); // 保存文件 $fp = @fopen($pathName, "w"); fwrite($fp, $tempFile); fclose($fp); header('content-type:application/octet-stream'); header('content-disposition:attachment; filename='.$title.'.'.$ext); header('content-length:'.filesize($pathName)); readfile($pathName); } /** * 教师讲案高考真题 * @exam_id 考试ID * @class_id 班级ID * @has_topic 教师讲案其他题集合 * @weak_methodids 共性题考点 * @paper_methodids 试卷考点 */ function acadGaokao($exam_id,$class_id,$has_topic,$weak_methodids,$paper_methodids){ //最终抽出来的题 $final_topic = array(); if(!$weak_methodids){ return $final_topic; }else{ $topic_data = $this->aipost('/relation_math/true_topic', array('methodIds' => $weak_methodids)); if($topic_data && isset($topic_data['data']) && $topic_data['data']){ $topic_pool = $topic_data['data']; }else{ return $final_topic; } } //step1 过滤已经存在的题 if($has_topic){ foreach($topic_pool as $k=>$v){ if(in_array($k,$has_topic)){ unset($topic_pool[$k]); } } } //step2 过滤超纲的题 if($paper_methodids){ foreach($topic_pool as $k=>$v){ foreach($v as $method){ if(!in_array($method,$paper_methodids)){ unset($topic_pool[$k]); continue; } } } } //step3 优先抽全部薄弱考点的题，如果题不够，逐一减少薄弱考点，直到抽到2题为止 $weak_methodids(薄弱考点) if($topic_pool){ //整理数据 $topic_methods_count = array();//题目对应薄弱考点数量 $count_to_topic = array();//薄弱考点数量对应题目 foreach($topic_pool as $k=>$v){ foreach($v as $method){ if(in_array($method,$weak_methodids)){ if(!isset($topic_methods_count[$k])){ $topic_methods_count[$k] = 1; }else{ $topic_methods_count[$k] ++; } } } } if($topic_methods_count){ foreach($topic_methods_count as $k=>$v){ for($a=1;$a<=$v;$a++){ if(!isset($count_to_topic[$a])){ $count_to_topic[$a] = array(); } $count_to_topic[$a][] = $k; } } } if($count_to_topic){ krsort($count_to_topic);//根据薄弱考点数量倒序 foreach($count_to_topic as $k=>$v){ foreach($v as $topic_id){ if(count($final_topic) > 1){ break; } if(!in_array($topic_id,$final_topic)){ $final_topic[] = $topic_id; } } } } } //过滤完没题就随机抽两题 if(!$final_topic || count($final_topic) < 2){ $topic_keys = array_keys($topic_pool); shuffle($topic_keys); foreach($topic_keys as $k=>$v){ if(count($final_topic) > 1){ break; } if(!in_array($v,$final_topic)){ $final_topic[] = $v; } } } //插入数据 if($final_topic){ $delSql = "delete from gaokao_academicr_topic where exam_id = '".$exam_id."'"; $insertSql="insert into gaokao_academicr_topic (`exam_id`,`class_id`,`topic_id`,`create_time`) values"; $insertSqlStr = ""; foreach($final_topic as $k=>$v){ $insertSqlStr.="('".$exam_id."','".$class_id."','".$v."','".time()."'),"; } $insertSql .= substr($insertSqlStr, 0, -1); $this->sConn->createCommand($delSql)->execute(); $this->sConn->createCommand($insertSql)->execute(); } return $final_topic; } /** * 教师假期报告设置 */ public function actionHoliday_teacher_index(){ Url::clean(); $data = array(); $semsterId = (string)Req::get("semesterId"); $teacher_name = (string)Req::get("teacher_name"); $limit = (int)Req::get("limit") ? (int)Req::get("limit") :10; $newCondition = array(); $schoolId = $this->schoolId; if(!$semsterId){ $semsterId = $this->semesterId; } if($semsterId){ $newCondition[] = "htrs.semester_id='$semsterId'"; } if($teacher_name){ $newCondition[] = "t.teacher_name='$teacher_name'"; } $resultList = $this->schoolManager->getTeacherHolidayReport($newCondition,array('htrs.create_time desc','htrs.report_id desc'),$limit); $printList = array(); if($resultList["rs"]){ foreach ($resultList['rs'] as $k=>$v) { $printList[$k]=$v; } } $sql = "select report_id from holiday_teacher_report_setting where semester_id= '{$semsterId}'"; $res = $this->sConn->createCommand($sql)->queryRow(); if(!$res){ $status = $this->schoolManager->batchInsetHolidayTeacherReport($schoolId,$semsterId,1); if(isset($status["status"]) && $status["status"] == 1){ $resultList = $this->schoolManager->getTeacherHolidayReport($newCondition,array('htrs.create_time desc','htrs.report_id desc'),$limit); $printList = array(); if($resultList["rs"]){ foreach ($resultList['rs'] as $k=>$v) { $printList[$k]=$v; } } } }else{ //验证有无新老师 $this->schoolManager->batchInsetHolidayTeacherReport($schoolId,$semsterId,2); } $semsters = $this->schoolManager->getSemesters(); $data['limit'] = $limit; $data['pages'] = $resultList['pager']; $data['page_total'] = $resultList['pager']->rowsCount; $data['printList'] = $printList; $data["semsterId"] = $semsterId; $data["semsters"] = $semsters; $data["teacher_name"] = $teacher_name; // debug($data); $this->render('holiday_teacher_index',$data); } /** * 重置教师假期报告 */ public function actionAjaxResetHolidayTeacherReport(){ $reportId = Req::post('report_id'); $teacherId = Req::post('teacher_id'); $semsterId = Req::post('semster_id'); $schoolId = $this->schoolId; if(!$reportId){ echo json_encode(array("status"=>0,"result"=>"假期报告ID不能为空"));exit; } if(!$teacherId){ echo json_encode(array("status"=>0,"result"=>"教师ID不能为空"));exit; } if(!$semsterId){ echo json_encode(array("status"=>0,"result"=>"学期ID不能为空"));exit; } $status = $this->schoolManager->resetTeacherReport($reportId,$teacherId,$semsterId); if($status){ echo json_encode(array("status"=>1,"result"=>"重置成功"));exit; }else{ echo json_encode(array("status"=>0,"result"=>"重置失败"));exit; } } /** * 批量重置教师假期报告 */ public function actionAjaxBatchResetHolidayTeacher(){ $semesterId = Req::post("semster_id"); if(!$semesterId){ echo json_encode(array("status"=>0,"result"=>"请指定学期Id"));exit; } $school_id = $this->schoolId; $status = $this->schoolManager->batchResetTeacherReport($semesterId); if($status){ echo json_encode(array("status"=>1,"result"=>"批量重置成功"));exit; }else{ echo json_encode(array("status"=>0,"result"=>"批量重置失败"));exit; } } /** * 获取订单 */ function getOrderStu($eid, $cid, $typeVal,$relateStudentRes,$semesterId, $grade) { $data = array(); $Sem=new SSemester(); $code= $Sem->conn->createQuery() ->from('semester') ->where("semester_id = '".$this->semesterId."'") ->limit(1) ->query() ->read(); $examInfo = Exam::model()->findByPk($eid); $print_time=ClassExamPrinter::model()->findAll('exam_id=:exam_id and class_id=:classid and type=0',array(':exam_id'=>$eid,':classid'=>$cid)); if($print_time && $print_time[0]->add_time){ $exam_time = $print_time[0]->add_time; }else{ $exam_time = $examInfo['create_time']; } $intarr=array( "schoolId"=>$this->schoolId, "clazzId"=>$cid, "semester"=>$code['refer_code'], "grade"=>$grade, "examTime"=>$exam_time, "students"=>array(), "classify"=>$typeVal, ); $intarr['subject']=$examInfo['subject_id']; if(in_array($intarr['subject'],$this->mathSubjectId)){ $intarr['subject']=3; } foreach($relateStudentRes as $key => $val){ $intarr['students'][] = $val['student_id']; } $basic = imsBasicAuth($this->schoolId.'_'.Yii::app()->session['coachInfo']['coach_name'],Yii::app()->params["zsy_api_key"]); $rs = json_decode(Curl::http_post_Basic_json(Yii::app()->params["get_limit_url"], json_encode($intarr),$basic)); if(!$rs){ //Yii::app()->jump->error("接口错误"); return false; } if($rs->errCode!="00"){ //Yii::app()->jump->error($rs->errMsg); //exit(); return false; } if(!empty($rs->data)){ foreach($rs->data as $v){ $data['limitstu'][$v]=$v; } }else{ $data['limitstu']=-1; } return $data; } /** * 获取班级设置 */ function getClassSet($classId,$semesterId){ $is_set = 0; $temp_swich = 3; $temp_bate = 0; $switch_arr = array(3=>0,4=>1); $sql = "select switch from producut_set_edition"; $switch_data = $this->sConn->createCommand($sql)->queryRow(); if($switch_data && $switch_data['switch'] && in_array($switch_data['switch'],array(3,4))){ $temp_swich = $switch_data['switch']; $temp_bate = $switch_arr[$temp_swich]; } if($classId && $semesterId){ $sql = "select wrong_book,isp,wb_isp from product_class_set where class_id = '{$classId}' and semester_id='{$semesterId}' and subject_id =3 and is_beta={$temp_bate}"; $res = $this->sConn->createCommand($sql)->queryAll(); if($res){ foreach($res as $res_k=>$res_v){ $setting_arr = array(); $setting_arr[1] = $res_v['wrong_book']; $setting_arr[2] = $res_v['isp']; $setting_arr[3] = $res_v['wb_isp']; foreach($setting_arr as $k=>$v){ $sql = "select config_text from product_template where template_id = '{$v}'"; $data = $this->sConn->createCommand($sql)->queryRow(); if($data){ $json_data = $data['config_text']; $json_data_arr = json_decode($json_data,true); if(isset($json_data_arr['studentLevelDivide']) && isset($json_data_arr['studentLevelDivide']['isPushSameTrain']) && $json_data_arr['studentLevelDivide']['isPushSameTrain']){ $is_set = 1; break 2; } } } } }else{ $sql = "select template_id,config_text from product_template where subject_id=3 and is_default=1 and target_type=1 and is_beta={$temp_bate}"; $data = $this->sConn->createCommand($sql)->queryAll(); if($data){ foreach($data as $k=>$v){ $json_data = $v['config_text']; $json_data_arr = json_decode($json_data,true); if(isset($json_data_arr['studentLevelDivide']) && isset($json_data_arr['studentLevelDivide']['isPushSameTrain']) && $json_data_arr['studentLevelDivide']['isPushSameTrain']){ $is_set = 1; break; } } } } } return $is_set; } /**获取名师指点信息 * @param $topicInfo * @return mixed|string */ public function dealTeacherTips($topicInfo){ if(isset($topicInfo["teacher_tips"]) && $topicInfo["teacher_tips"]){//如果有的话直接返回 return $topicInfo["teacher_tips"]; } //兼容全学科题目 if(!isset($topicInfo["topic_type_config"]) || empty($topicInfo["topic_type_config"]) || !isset($topicInfo["affiliate"])|| empty($topicInfo["affiliate"])){ return ""; } $topicTypeConfig = $topicInfo["topic_type_config"]; if(is_object($topicTypeConfig)){ $topicTypeConfig = json_decode(json_encode($topicTypeConfig),true); } //$topicTypeConfig = json_decode($topicInfo["topic_type_config"],true); if(!isset($topicTypeConfig["subject_custom"]) || !isset($topicTypeConfig["subject_custom"]["custom_column"])){ return ""; } if(!isset($topicTypeConfig["subject_custom"]["custom_column"][$topicInfo["subject_id"]])){ return ""; } $customColumnArr = $topicTypeConfig["subject_custom"]["custom_column"][$topicInfo["subject_id"]]; $field_name = ""; foreach($customColumnArr as $value){//获取题型对应的 名师指点定制标签 if(isset($value["field_describe"]) && strpos($value["field_describe"],"名师指点") !==false){ $field_name =$value["field_name"]; break; } } if(!$field_name){ return ""; } $returnTeacherTips =""; $affiliate = $topicInfo["affiliate"]; if(is_object($affiliate)){ $affiliate = json_decode(json_encode($affiliate),true); } foreach($affiliate as $affValue){//获取定制标签的值 if(is_object($affValue)){ $affValue = json_decode(json_encode($affValue),true); } if(isset($affValue["field_key"]) && $affValue["field_key"] == $field_name){ $returnTeacherTips = isset($affValue["field_value"])?$affValue["field_value"]:""; break; } } return $returnTeacherTips; } }