find("school_id=:sid",array(':sid'=>Yii::app()->session['coachInfo']['school_id']));
//查询学段
$data['gradeGroup'] = BusinessGradeGroup::model()->findAll("section=:sid",array(':sid'=>$data['schoolinfo']['section']));
//查询学制
$data['gradeConfig'] = BusinessGradeConfig::model()->findAll();
$gradeArr=array();
foreach ($data['gradeConfig'] as $datum){
$gradeArr[$datum['group_id']][$datum['grade_id']]=$datum['grade_name'];
}
$data['gradeConfig'] = $gradeArr;
$realGradeArr=array();
$grade = SGrade::model()->findAll();
foreach ($grade as $item){
if(isset($gradeArr[$data['schoolinfo']['grade_group_id']][$item->id])){
$realGradeArr[]=$item;
}
}
$data['grade']=$realGradeArr;
$data['area'] = CMRegion::model()->findAllBySql("select region_name from region where region_id in ({$data['schoolinfo']['province_id']},{$data['schoolinfo']['city_id']},{$data['schoolinfo']['area_id']})");
$semesterId = Yii::app()->session['session_semester_id'];
$classList = SClass::model()->findAll("semester_id=:semester_id and arts_science<>0 and is_hide=0 ",array(':semester_id'=>$semesterId));
//读取学年
$schoolYear=array();
$period = $this->getHttp('sys/school/year/period/list', 'get');
if($period['status']==1){
$schoolYear=$period['data'];
}
$data['schoolYear']=$schoolYear;
$detail = $this->getHttp('customer/school/coach/official/detail', 'get');
if($detail){
//学校概况
if(isset($detail['data']['schoolProfile']['schoolBuildYear'])){
$data['schoolprofile']['schoolBuildYear']=$detail['data']['schoolProfile']['schoolBuildYear']; //年份
}else{
$data['schoolprofile']['schoolBuildYear']=''; //年份
}
if(isset($detail['data']['schoolProfile']['studentCount'])){
$data['schoolprofile']['studentCount']=$detail['data']['schoolProfile']['studentCount']; //规模
}else{
$data['schoolprofile']['studentCount']=''; //规模
}
if(isset($detail['data']['schoolProfile']['artsAndScience'])){
$data['schoolprofile']['artsAndScience']=$detail['data']['schoolProfile']['artsAndScience'];
}else{
$data['schoolprofile']['artsAndScience']='';
}
if(isset($detail['data']['schoolProfile']['bookVersion'])){
$data['schoolprofile']['bookVersion']=$detail['data']['schoolProfile']['bookVersion'];
}else{
$data['schoolprofile']['bookVersion']='';
}
if(isset($detail['data']['schoolProfile']['schoolNature'])){
$data['schoolprofile']['schoolNature']=$detail['data']['schoolProfile']['schoolNature']; //学校性质
}else{
$data['schoolprofile']['schoolNature']=''; //学校性质
}
if(isset($detail['data']['schoolProfile']['schoolType'])){
$data['schoolprofile']['schoolType']=$detail['data']['schoolProfile']['schoolType']; //学校类型
}else{
$data['schoolprofile']['schoolType']='0'; //学校类型
}
if(isset($detail['data']['schoolProfile']['isMinority'])){
$data['schoolprofile']['isMinority']=$detail['data']['schoolProfile']['isMinority']; //是否设置少数民族
}else{
$data['schoolprofile']['isMinority']=''; //是否设置少数民族
}
if(isset($detail['data']['schoolProfile']['isStaying'])){
$data['schoolprofile']['isStaying']=$detail['data']['schoolProfile']['isStaying']; //寄宿制形式
}else{
$data['schoolprofile']['isStaying']=''; //寄宿制形式
}
//升学率
if(isset($detail['data']['upRates'])){
$data['schoolentrancerate'] =$detail['data']['upRates'];
}else{
$data['schoolentrancerate'] =array();
}
//规模
if(isset($detail['data']['scaleResDTOS'])){
$data['scale']=$detail['data']['scaleResDTOS'];
}else{
$data['scale']=array();
}
//联系方式
if(isset($detail['data']['schoolContact']['schoolMasterName'])){
$data['schoocontact']['schoolMasterName']=$detail['data']['schoolContact']['schoolMasterName'];
}else{
$data['schoocontact']['schoolMasterName']='';
}
if(isset($detail['data']['schoolContact']['schoolMasterMobile'])){
$data['schoocontact']['schoolMasterMobile']=$detail['data']['schoolContact']['schoolMasterMobile'];
}else{
$data['schoocontact']['schoolMasterMobile']='';
}
if(isset($detail['data']['schoolContact']['schoolMaster2Name'])){
$data['schoocontact']['schoolMaster2Name']=$detail['data']['schoolContact']['schoolMaster2Name'];
}else{
$data['schoocontact']['schoolMaster2Name']='';
}
if(isset($detail['data']['schoolContact']['schoolMaster2Mobile'])){
$data['schoocontact']['schoolMaster2Mobile']=$detail['data']['schoolContact']['schoolMaster2Mobile'];
}else{
$data['schoocontact']['schoolMaster2Mobile']='';
}
if(isset($detail['data']['schoolContact']['grade1HeadName'])){
$data['schoocontact']['grade1HeadName']=$detail['data']['schoolContact']['grade1HeadName'];
}else{
$data['schoocontact']['grade1HeadName']='';
}
if(isset($detail['data']['schoolContact']['grade1HeadMobile'])){
$data['schoocontact']['grade1HeadMobile']=$detail['data']['schoolContact']['grade1HeadMobile'];
}else{
$data['schoocontact']['grade1HeadMobile']='';
}
if(isset($detail['data']['schoolContact']['grade2HeadName'])){
$data['schoocontact']['grade2HeadName']=$detail['data']['schoolContact']['grade2HeadName'];
}else{
$data['schoocontact']['grade2HeadName']='';
}
if(isset($detail['data']['schoolContact']['grade2HeadMobile'])){
$data['schoocontact']['grade2HeadMobile']=$detail['data']['schoolContact']['grade2HeadMobile'];
}else{
$data['schoocontact']['grade2HeadMobile']='';
}
if(isset($detail['data']['schoolContact']['grade3HeadName'])){
$data['schoocontact']['grade3HeadName']=$detail['data']['schoolContact']['grade3HeadName'];
}else{
$data['schoocontact']['grade3HeadName']='';
}
if(isset($detail['data']['schoolContact']['grade3HeadMobile'])){
$data['schoocontact']['grade3HeadMobile']=$detail['data']['schoolContact']['grade3HeadMobile'];
}else{
$data['schoocontact']['grade3HeadMobile']='';
}
}
//处理文理科分班情况
foreach ($data['grade'] as $grade){
if($grade['arts_science']==1){
//不分科
}elseif($grade['arts_science']==2){
//查询班级
foreach ($classList as $class){
if($class['grade']==$grade['id'] ){
$data['arts_science'][$grade['id']][$class['arts_science']]['ids'][]=$class['class_id'];
$data['arts_science'][$grade['id']][$class['arts_science']]['names'][]=$class['class_name'];
}
}
}
}
//自定义学科设置
$data['extendSubject']=BusinessSubject::model()->findAll("is_basic=0");
//已配置自定义学科
$extendSubjectSchool=SExtendSubject::model()->findAll();
if($extendSubjectSchool){
foreach ($extendSubjectSchool as $key => $val){
$data['extendSubjectSchool'][$val['subject_id']]['subject_id']=$val['subject_id'];
$data['extendSubjectSchool'][$val['subject_id']]['subject_name']=$val['subject_name'];
if(SExtendSubject::model()->checkSubjectUsed($val['subject_id'])){
$data['extendSubjectSchool'][$val['subject_id']]['used']=1;
}else{
$data['extendSubjectSchool'][$val['subject_id']]['used']=0;
}
}
}
$_num= '';
$use_version = '';
if(isset(Yii::app()->session['coachInfo']->use_version))
{
$use_version = Yii::app()->session['coachInfo']->use_version;
}else
{
$use_version = Yii::app()->session['coachInfo']['use_version'];
}
if(!$use_version)
{
$use_version = 100;
}
$version_number = implode('',explode('.',$use_version));
if(strlen($version_number)<7)
{
for($i=0;$i<7-strlen($version_number);$i++)
{
$_num.='0';
}
}
$version_number=(int)$version_number.$_num;
//获取学校的安全与隐私配置
$schoolPrivate = new BSchoolPrivate();
$isPrivate = $schoolPrivate->getPrivate($this->schoolId);
$data['is_private'] = $isPrivate;
//debug($data);
//获取学校平板登陆权限配置
$data['login_permission'] = $data['schoolinfo']['is_login_permission'];
if(Yii::app()->params['section']==0){
$this->render('add_section',$data);
}else{
$this->render('add2',$data);
}
}
public function actionSaveSchoolPrivate(){
if (Yii::app()->request->getIsPostRequest()){
$is_private = Req::post('is_private');
$model = new BSchoolPrivate();
$result = $model->savePrivate($this->schoolId, $is_private);
if ($result){
returnMsg(1,'保存成功');
}else{
returnMsg(0,'保存失败');
}
}else{
returnMsg(0,"非法请求");
}
}
public function actioninsert(){
if (Yii::app()->request->getIsPostRequest())
{
$card_length = Req::post("card_length");
$card_status = Req::post("card_status");
$_err = array();
$business_student_data = BusinessStudent::model()->findAll('school_id=:school_id',array(':school_id'=>$this->schoolId));
if($business_student_data)
{
foreach($business_student_data as $v)
{
if($v->school_student_card)
{
if(strlen($v->school_student_card)!=$card_length)
{
$_err[] = '学生准考证号长度存在不等于'.$card_length.'位!';
continue;
}
}
}
BusinessSchool::model()->updateAll(array('card_length'=>$card_length,'card_status'=>$card_status),'school_id=:school_id',array(':school_id'=>$this->schoolId));
if($_err)
{
Yii::app()->jump->setSuccessWait(8);
Yii::app()->jump->success('保存成功
但学生准考证号长度存在不等于'.$card_length.'位,请修改学生学校准考证号
',Yii::app()->createUrl('school/add'));exit;
}
Yii::app()->jump->success('保存成功',Yii::app()->createUrl('school/add'));
}else
{
Yii::app()->jump->error('此学校没有学生,请先导入学生!');
}
}
}
/**
* 设置学校准考证号
*/
public function actionGrade_insert()
{
if (Yii::app()->request->getIsPostRequest())
{
$_err = array();
foreach (Yii::app()->params['grade_list'] as $id =>$val){
if(Req::post("card_status".$id)){
$data = $this->get_card_length($id,Req::post("card_length".$id));
if($data){
$_err[$id] = $data;
}
}
}
foreach (Yii::app()->params['grade_list'] as $id =>$val){
if(isset($_POST['card_status'.$id])){
$cardLength=Req::post("card_length".$id);
$cardStatus=Req::post("card_status".$id);
if(!$cardLength) $cardLength=0;
SGrade::model()->updateAll(array('card_length'=>$cardLength,'card_status'=>$cardStatus),'id=:id',array(':id'=>$id));
}
}
if($_err){
Yii::app()->jump->setSuccessWait(8);
Yii::app()->jump->setHeight(240);
$str='';
foreach ($_err as $grade =>$item){
$str.=Yii::app()->params['grade_list'][$grade]['grade_name'].'学生准考证号长度存在不等于'.Req::post("card_length".$grade).'位,请修改学生学校准考证号';
}
Yii::app()->jump->error($str,Yii::app()->createUrl('school/add'));exit;
}else{
Yii::app()->jump->success('保存成功',Yii::app()->createUrl('school/add'));exit;
}
}else
{
Yii::app()->jump->error('不能多次提交',Yii::app()->createUrl('school/add'));exit;
}
}
protected function get_card_length($grade,$card_length)
{
$class_data = ClassModel::model()->findAll('grade=:grade and semester_id=:semester_id',array(':grade'=>$grade,':semester_id'=>$this->semesterId));
$class_ids = array();
$student_ids = array();
$_err = array();
if($class_data)
{
foreach($class_data as $v)
{
$class_ids[$v->class_id] = $v->class_id;
}
$criteria = new CDbCriteria();
$criteria->addInCondition('class_id',$class_ids);
$criteria->addCondition('status=:status');
$criteria->params[':status'] = 0;
$student_class_data = SStudentClassRelation::model()->findAll($criteria);
if($student_class_data)
{
foreach($student_class_data as $v)
{
$student_ids[$v->student_id] = $v->student_id;
}
unset($criteria);
$business_student_data=$this->schoolManager->getStudentByCardLength($student_ids,$card_length);
if($business_student_data){
$_err[] = '学生准考证号长度存在不等于'.$card_length.'位!';
}
/*
$criteria = new CDbCriteria();
$criteria->addInCondition('student_id',$student_ids);
$business_student_data = BusinessStudent::model()->findAll($criteria);
if($business_student_data)
{
foreach($business_student_data as $v)
{
if($v->school_student_card)
{
if(strlen($v->school_student_card)!=$card_length)
{
$_err[] = '学生准考证号长度存在不等于'.$card_length.'位!';
continue;
}
}
}
}
*/
}
}
return $_err;
}
//联系人
public function actionContact_insert()
{
$params=array();
$params['schoolMasterName'] = Req::post("schoolMasterName");
$params['schoolMasterMobile'] = Req::post("schoolMasterMobile");
$params['schoolMaster2Name'] = Req::post("schoolMaster2Name");
$params['schoolMaster2Mobile'] = Req::post("schoolMaster2Mobile");
$params['grade1HeadName'] = Req::post("grade1HeadName");
$params['grade1HeadMobile'] = Req::post("grade1HeadMobile");
$params['grade2HeadName'] = Req::post("grade2HeadName");
$params['grade2HeadMobile'] = Req::post("grade2HeadMobile");
$params['grade3HeadName'] = Req::post("grade3HeadName");
$params['grade3HeadMobile'] = Req::post("grade3HeadMobile");
$params['schoolId']=$this->schoolId;
$res = $this->getHttp('customer/school/coach/contact', 'put',$params);
if ($res['status'] == 1) {
Yii::app()->jump->success('保存成功',Yii::app()->createUrl('school/add'));
} else {
Yii::app()->jump->error($res['msg']);
}
}
public function actionAjax_student()
{
$card_length = Req::post("card_length");
$business_student_data = BusinessStudent::model()->findAll('school_id=:school_id',array(':school_id'=>$this->schoolId));
if($business_student_data)
{
foreach($business_student_data as $v)
{
if($v->school_student_card)
{
if(strlen($v->school_student_card) != $card_length)
{
echo json_encode(array('status'=>1,'msg'=>'学生准考证号长度存在不等于'.$card_length.'位!'));exit;
}
}
}
echo json_encode(array('status'=>0,'msg'=>''));exit;
}else
{
echo json_encode(array('status'=>1,'msg'=>'此学校没有学生,请先导入学生!'));exit;
}
}
public function actionSetusewp()
{
$use_wp = Req::post("use_wp");
if(false !== BusinessSchool::model()->updateAll(
array('use_wp'=>$use_wp),'school_id=:sid',array(':sid'=>Yii::app()->session['coachInfo']['school_id'])))
{
echo json_encode(array('status'=>1,'wp'=>$use_wp));exit;
}
echo json_encode(array('status'=>0));exit;
}
/**
* 学校概况
*/
public function actionProfile_insert()
{
$profile=$_POST['profile'];
$params=array();
$params['schoolId']=$this->schoolId;
$params['schoolBuildYear']=$profile['schoolBuildYear'];
$params['schoolNature']=$profile['schoolNature'];
$params['isMinority']=$profile['isMinority'];
$params['isStaying']=intval($profile['isStaying']);
// $params['studentCount']=$profile['studentCount'];
$params['schoolType']=$profile['schoolType'];
if(isset($profile['bookVersion'])){
$params['bookVersion']=$profile['bookVersion'];
}else{
$params['bookVersion']=0;
}
$params['artsAndScience']=$profile['artsAndScience'];
$upRates=array();
if(Yii::app()->params['section']==0){
if(isset($_POST['schoolYear']) && $_POST['schoolYear']){
foreach ($_POST['schoolYear'] as $key => $val){
$upRates[]=array(
'schoolYearId'=>$val,
'highSchoolRate'=>$_POST['upRate'][$key],
'level1Rate'=>0,
'level2Rate'=>0,
'level3Rate'=>0,
);
}
}
}else{
if(isset($_POST['schoolYear']) && $_POST['schoolYear']){
foreach ($_POST['schoolYear'] as $key => $val){
$upRates[]=array(
'schoolYearId'=>$val,
'level1Rate'=>$_POST['level1Rate'][$key],
'level2Rate'=>$_POST['level2Rate'][$key],
'level3Rate'=>$_POST['level3Rate'][$key],
'highSchoolRate'=>0
);
}
}
}
if($upRates){
$params['upRates']=$upRates;
}
$scaleResDTOS=array();
if(Yii::app()->params['section']==0){
if(isset($_POST['schoolScale']) && $_POST['schoolScale']){
foreach ($_POST['schoolScale'] as $key => $val){
$scaleResDTOS[]=array(
'schoolYearId'=>$val,
'gradeOne'=>0,
'gradeTwo'=>0,
'gradeThree'=>0,
'highSchoolSix'=>$_POST['highSchoolSix'][$key],
'highSchoolSeven'=>$_POST['highSchoolSeven'][$key],
'highSchoolEight'=>$_POST['highSchoolEight'][$key],
'highSchoolNine'=>$_POST['highSchoolNine'][$key],
);
}
}
}else{
if(isset($_POST['schoolScale']) && $_POST['schoolScale']){
foreach ($_POST['schoolScale'] as $key => $val){
$scaleResDTOS[]=array(
'schoolYearId'=>$val,
'gradeOne'=>$_POST['gradeOne'][$key],
'gradeTwo'=>$_POST['gradeTwo'][$key],
'gradeThree'=>$_POST['gradeThree'][$key],
'highSchoolSix'=>0,
'highSchoolSeven'=>0,
'highSchoolEight'=>0,
'highSchoolNine'=>0,
);
}
}
}
if($scaleResDTOS){
$params['scaleDTOS']=$scaleResDTOS;
}
$res = $this->getHttp('customer/school/coach/profile-uprate', 'put',$params);
if ($res['status'] == 1) {
Yii::app()->jump->success('保存成功',Yii::app()->createUrl('school/add'));
} else {
Yii::app()->jump->error($res['msg']);
}
}
/*读取所有班级*/
public function actionGetClass(){
$grade_id = Req::post("grade_id"); //年级
$title = Req::post("title");
$type = Req::post("type");
$selected_class_id=Req::post('selected_class_id');
$semesterId=Yii::app()->session['session_semester_id'];
if($selected_class_id){
$SelectedClassArr=explode(',',$selected_class_id);
}else{
$SelectedClassArr=array();
}
$class_data = ClassModel::model()->findAll('semester_id=:semester_id and grade=:grade and is_hide=0',array(':semester_id'=>$semesterId,':grade'=>$grade_id));
$html='
'; $html.=''; $html.=''; $html.=''; $html.='
'; $result=array( 'status'=>1, 'html'=>$html ); exit(json_encode($result)); } /*保存年级班级文理分科*/ public function actionSaveArtsAndScience(){ $class_data=Req::post('class_data'); $semesterId=Yii::app()->session['session_semester_id']; $result=array('status'=>0); if(!$class_data || !is_array($class_data)){ exit(json_encode($result)); } $err=array(); $ClassModel=new SClass(); foreach ($class_data as $key=>$val){ if($key===0){ continue; //年级id没有0 } if($val=='close'){ //不分科 SGrade::model()->updateAll(array('arts_science'=>1),'id=:id',array(':id'=>$key)); $allClass=array(); $ClassList=$ClassModel->getClassList('class_id',array("grade={$key} and semester_id={$semesterId}")); if($ClassList){ foreach ($ClassList as $id){ $allClass[]=$id['class_id']; } } if($allClass){ $ClassModel->updateAll(array('arts_science'=>0),' class_id in('.implode(',',$allClass).')'); }else{ $err[]='没有班级数据,年级:'.$key; } }else{ if(!is_array($val)){ $err[]='班级数据有误,年级:'.$key; } foreach($val as $ke=>$class){ if($ke===0){ continue; } //查询当前已选择班级 $oldClass=array(); $ClassList=$ClassModel->getClassList('class_id',array("grade={$key} and arts_science={$ke} and semester_id={$semesterId}")); if($ClassList){ foreach ($ClassList as $id){ $oldClass[]=$id['class_id']; } } if($class){ foreach ($class as $i=>$cid){ if($oldClass && in_array((string)$cid,$oldClass,true)){ unset($class[$i]); unset($oldClass[array_search((string)$cid,$oldClass,true)]); } } } //需要新增的 if($class){ $ClassModel->updateAll(array('arts_science'=>$ke),' class_id in('.implode(',',$class).')'); } //需要清除状态的 if($oldClass){ $ClassModel->updateAll(array('arts_science'=>0),' class_id in('.implode(',',$oldClass).')'); } } SGrade::model()->updateAll(array('arts_science'=>2),'id=:id',array(':id'=>$key)); } } $result['status']=1; $result['err']=$err; exit(json_encode($result)); } private function getHttp($url,$method,$params = array()){ $res = http($url, $method, $this->authUsername, $params); $res = $this->handleRes($res); return $res; } /** * 处理接口返回的数据 * @param $res * @return array */ public function handleRes($res){ $result = array( 'status' => 0, 'data' => array(), 'msg' => '暂无数据', ); if($res){ $res = json_decode($res,true); if(isset($res['errCode']) && $res['errCode'] == '00'){ $result['status'] = 1; $result['data'] = isset($res['data'])?$res['data']:array(); $result['msg'] = $res['errMsg']; }else{ if(isset($res['errMsg'])){ $result['msg'] = $res['errMsg']; } } } unset($res); return $result; } //加载未配置学科 public function actionGetExtendSubjects(){ //自定义学科设置 $extendSubject=BusinessSubject::model()->findAll("is_basic=0 and section='".Yii::app()->params['section']."'"); //已配置自定义学科 $extendSubjectSchool=SExtendSubject::model()->findAll(); $isHasSubject=array(); if($extendSubjectSchool){ foreach ($extendSubjectSchool as $item){ $isHasSubject[$item->subject_id]=$item->subject_name; } } $html=''; if($extendSubject){ foreach ($extendSubject as $key=>$item){ if(!isset($isHasSubject[$item['subject_id']])){ $html.=''; }else{ $html.=''; } } } exit(json_encode(array('status'=>1,'data'=>$html))); } //保存自定义学科 public function actionSaveExtendSubjects(){ $subjects=Req::post('subjects'); $result['status']=0; if(!$subjects || !is_array($subjects)){ $result['msg']='请选择学科'; exit(json_encode($result)); } $extendSubject=BusinessSubject::model()->findAll("is_basic=0"); foreach ($extendSubject as $val){ $result[$val->subject_id]=$val->subject_name; } $insertData=array(); foreach ($subjects as $val){ $insertData[$val]=$result[$val]; } if(SExtendSubject::model()->insertExtendSubject($insertData)){ $result['status']=1; $result['msg']='操作成功'; } exit(json_encode($result)); } //删除自定义科目 public function actionDelExtendSubject(){ $subjectId=Req::post('subjectId'); $result['status']=0; if(!$subjectId){ $result['msg']='请选择学科'; exit(json_encode($result)); } //查询科目是否有教师 if(SExtendSubject::model()->checkSubjectUsed($subjectId)){ $result['msg']='该学科已有使用数据,不能删除'; exit(json_encode($result)); } if(SExtendSubject::model()->delExtendSubject($subjectId)){ $result['status']=1; exit(json_encode($result)); } //知了家校考试 } //设置学生平板登录设备权限 public function actionAjaxSettingLoginpermission() { $is_login_permission = (int)Req::post('setting_status');//0-多个设备 1-单个设备 $result['status'] = 0; if (!in_array($is_login_permission, array(0, 1))) { $result['msg'] = '参数错误'; exit(json_encode($result)); } $schoolModel = new BusinessSchool(); $now_permission = $schoolModel->updateLoginPermission($this->schoolId, $is_login_permission); require_once(Yii::app()->basePath . '/extensions/RedisLoginCtrl.php'); foreach (range(0, RedisLoginCtrl::getRedisNum()) as $redisNun) { RedisLoginCtrl::getRedisObj($redisNun)->set('zsy:student_login_check:' . $this->schoolId, $now_permission); } //Yii::app()->stu_login_permission->setValue('zsy:student_login_check:' . $this->schoolId, $now_permission); if (!$now_permission) { $del_key = "zsy:school_login_key:" . $this->schoolId; $del_data = Yii::app()->stu_login_permission->lrange($del_key, 0, -1); if ($del_data) { foreach ($del_data as $k => $v) { Yii::app()->stu_login_permission->del($v); } Yii::app()->stu_login_permission->del($del_key); } } $result['status'] = 1; exit(json_encode($result)); } //保存学段年级组设置 public function actionSaveSection(){ $gradeGroup=(int)Req::post('gradeGroup'); $result['status']=0; if($gradeGroup==$this->schoolInfo['grade_group_id']){ $result['msg']='学段设置与原设置相同'; exit(json_encode($result)); } //查询学制 $gradeConfig = BusinessGradeConfig::model()->findAll("group_id=:sid",array(':sid'=>$gradeGroup)); $businessRs=false; $transaction_conn = $this->conn->beginTransaction(); try{ $updateSql="update school set grade_group_id='{$gradeGroup}',grade_group_changed=1 where school_id='{$this->schoolId}'"; $this->conn->createCommand($updateSql)->execute(); $businessRs=true; }catch (\Exception $e){ $transaction_conn->rollback(); Yii::app()->jump->error('添加老师失败!'); } if($businessRs){ $transaction = $this->sConn->beginTransaction(); try{ foreach ($gradeConfig as $item){ $check=$this->sConn->createCommand("select id from grade where id='{$item['grade_id']}'")->queryRow(); if($check){ $this->sConn->createCommand("update grade set grade_name='{$item['grade_name']}' where id='{$item['grade_id']}'")->execute(); }else{ $this->sConn->createCommand("insert into grade(`id`,`grade_name`,`card_length`,`card_status`,`arts_science`) values(".$item['grade_id'].",'".$item['grade_name']."',0,0,1)")->execute(); } } $transaction_conn->commit(); $transaction->commit(); $result['status']=1; $result['msg']='学段设置成功'; exit(json_encode($result)); }catch (\Exception $e){ $transaction->rollback(); $transaction_conn->rollback(); $result['msg']='学段设置失败'; exit(json_encode($result)); } } } //保存阅卷留痕设置 public function actionMarkingSet(){ $coordinate=(int)Req::post('coordinate'); $updateSql="update school set marking_coordinate='{$coordinate}' where school_id='{$this->schoolId}'"; $this->conn->createCommand($updateSql)->execute(); Yii::app()->jump->success('保存成功',Yii::app()->createUrl('school/add')); } }