/** * 添加学生 第 3 步提交处理. * * @access public * @return void * @author Liuping <*****@*****.**> */ public function addStep3Action() { // 校验一级中介是否有权限添加学生 if (!AgentAuth::checkTopAgentOfStu()) { $this->error('No permission'); } // 当前操作, 参见第 1 步中说明. $operFlag = intval(I('post.oper', 1)); $studentId = intval(I('post.currStudent', 0)); // 学生 id if (empty($studentId)) { $this->error('Invalid parameters'); } // 实例化 MemberStu 模型 $model = new MemberStuModel(); $stuInfo = $model->fetchStuInfo($studentId); if (empty($stuInfo)) { $this->error('Invalid parameters'); } // 对学生做权限验证 $res = AgentAuth::checkStu($studentId, [AgentAuth::WRITE]); if (9 !== $res['status']) { $this->error('No permission'); } $uid = $stuInfo['uid']; $paretUId = $stuInfo['fuid']; $partid = $stuInfo['partid']; $ano = ''; // 验证成功规则能过, 验证是否有添加学生的权限 // 校验一级中介是否有权限添加学生 if (!AgentAuth::checkTopAgentOfStu($uid)) { $this->error('No permission'); } // 各表单项允许的条数配置. $config = C('ADD_STUDENT_FORM_OPT'); // 获取数据 $eduBackInfo = I('post.eduInfo', []); // 教育背景信息. $certInfo = I('post.engCertInfo', []); // 英语证书信息 $workExpInfo = I('post.workExpInfo', []); // 工作经验信息 $refInfo = I('post.refInfo', []); // 推荐人信息. // 处理数据 $eduBackInfo = $this->processData($eduBackInfo); $workExpInfo = $this->processData($workExpInfo); $refInfo = $this->processData($refInfo); // 按允许的条数截取 $eduBackInfo = array_slice($eduBackInfo, 0, $config['eduBackNum']); $workExpInfo = array_slice($workExpInfo, 0, $config['workExpNum']); $refInfo = array_slice($refInfo, 0, $config['refereesNum']); // 字段映射处理 $eduBackInfo = $this->autoBatchFieldMap($eduBackInfo, $this->eduInfoMaps); $workExpInfo = $this->autoBatchFieldMap($workExpInfo, $this->workExpInfoMaps); $refInfo = $this->autoBatchFieldMap($refInfo, $this->refInfoMaps); $this->autoFieldMap($certInfo, $this->engCertInfoMaps); // 一维数组映射 // 补齐默认数据 // 补齐教育背景信息. foreach ($eduBackInfo as &$row) { $row['uid'] = $uid; $row['fuid'] = $paretUId; $row['partid'] = $partid; $row['s_id'] = $studentId; $row['a_no'] = $ano; if (empty($row['id'])) { $row['create_time'] = time(); } // 目前的规则是, 若教育背景的 国家为 china 就读类型才可以有值 if ('china' === strtolower($row['institution_country'])) { if ('other' !== strtolower($row['attend_type'])) { // 不为 other 指定的就读类型设置为空串 $row['attend_other_type'] = ''; } } else { // 不是中国就读类型都为空 $row['attend_type'] = ''; $row['attend_other_type'] = ''; } } unset($row); // 补齐英语证书信息 $certInfo['uid'] = $uid; $certInfo['fuid'] = $paretUId; $certInfo['partid'] = $partid; $certInfo['s_id'] = $studentId; $certInfo['a_no'] = $ano; //$certInfo['readly_for_test'] = isset($certInfo['readly_for_test']) ? $certInfo['readly_for_test'] : ''; // 2016-1-19 新增 表已加默认值. if (empty($certInfo['id'])) { $certInfo['create_time'] = time(); } // 补齐工作经验 foreach ($workExpInfo as &$row) { $row['uid'] = $uid; $row['fuid'] = $paretUId; $row['partid'] = $partid; $row['s_id'] = $studentId; $row['a_no'] = $ano; if (empty($row['id'])) { $row['create_time'] = time(); } } unset($row); // 补齐推荐人信息 foreach ($refInfo as &$row) { $row['uid'] = $uid; $row['fuid'] = $paretUId; $row['partid'] = $partid; $row['s_id'] = $studentId; $row['a_no'] = $ano; if (empty($row['id'])) { $row['create_time'] = time(); } } unset($row); // 验证规则 部分 // 验证教育背景 qualification 为 other 时, qualificationOther 必填 // institution_country 为 china 时, attend_type 必填 // attend_type 为 other 时, attend_other_type 必填 foreach ($eduBackInfo as &$row) { // 处理 qualification, 若为 Other 时, 拼接成 qualification-qualificationOther if ('other' === strtolower($row['qualification'])) { if (empty($row['qualificationOther'])) { $this->error('Title of qualification cannot be empty'); } elseif (!$model->validateEnChar($row['qualificationOther'])) { $this->error('Please enter a valid qualification'); } // 检测通过用 - 连接. $row['qualification'] = $row['qualification'] . '-' . $row['qualificationOther']; } unset($row['qualificationOther']); // 验证其它规则项 $res = $model->validate($model->eduInfoRules)->create($row); if (!$res) { $this->error($model->getError()); } // institution_country 为中国时 if ('china' === strtolower($row['institution_country'])) { $res1 = $model->validate($model->eduInfoRules1)->create($row); if (!$res1) { $this->error($model->getError()); } // 若 attend_type 为 other 时验证 attend_other_type if ('other' === strtolower($row['attend_type'])) { $res2 = $model->validate($model->eduInfoRules2)->create($row); if (!$res2) { $this->error($model->getError()); } } } } unset($row); // 验证工作经验 foreach ($workExpInfo as $row) { $res = $model->validate($model->workExpInfoRules)->create($row); if (!$res) { $this->error($model->getError()); } } unset($row); // 验证语言证书 // have_en_test 即 是否在近两年内有过英语测试 为 yes 时 // 证书名称 总成绩 考试日期 城市(拼音) 国家(拼音) 证书号码(证书的右下角)为必填项 // en_is_first 为 no 时, 其它规则还保留原有的验证规则. $res = $model->validate($model->certInfoRules2)->create($certInfo); if (!$res) { $this->error($model->getError()); } $en_is_first = strtolower($certInfo['en_is_first']); if ('yes' === $en_is_first) { // en_is_first 为 yes 不验证其它规则, 置空 $certInfo['certification_name'] = ''; $certInfo['totle_score'] = 0; $certInfo['test_date'] = ''; $certInfo['country'] = ''; $certInfo['city'] = ''; $certInfo['certification_number'] = ''; } else { // en_is_first 为 no 时执行原有的验证规则. $res = $model->validate($model->certInfoRules)->create($certInfo); if (!$res) { $this->error($model->getError()); } if ('yes' === strtolower($certInfo['have_en_test'])) { $res1 = $model->validate($model->certInfoRules1)->create($certInfo); if (!$res1) { $this->error($model->getError()); } } else { // 等于 no 置空 $certInfo['certification_name'] = ''; $certInfo['totle_score'] = 0; $certInfo['test_date'] = ''; $certInfo['country'] = ''; $certInfo['city'] = ''; $certInfo['certification_number'] = ''; } } // 验证推荐人 foreach ($refInfo as $row) { $res = $model->validate($model->refInfoRules)->create($row); if (!$res) { $this->error($model->getError()); } } unset($row); // 开启事务 $model->startTrans(); // 全部通过写入数据库. $res = $model->procEduBackInfo($eduBackInfo, $uid, $studentId, $ano); $res1 = $model->procEngLangCertInfo($certInfo, $uid, $studentId, $ano); $res2 = $model->procWorkExpInfo($workExpInfo, $uid, $studentId, $ano); $res3 = $model->procRefereeInfo($refInfo, $uid, $studentId, $ano); if (!($res && $res1 && $res2 && $res3)) { $model->rollback(); $this->error('Action failed'); } // 都处理成功, 提交事务. $model->commit(); // 跳转到第三步 $stepUrl = U('addStep4'); $this->myRedirect('addTrans', $stepUrl, $studentId, $uid, $ano, $operFlag); }
/** * 提交申请第 2 步处理. * * @access public * @return void * @author Liuping <*****@*****.**> */ public function appSubmit2Action() { // 校验一级中介是否有权限添加申请 if (!AgentAuth::checkTopAgentOfApply()) { $this->error('No permission'); } // 申请 id $appStatusId = intval(I('post.appStatus', '')); if (empty($appStatusId)) { $this->error('Parameters error', U('Student/noApplyStudentList')); } $modelAppStatus = new ApplyStatusModel(); $appStatusInfo = $modelAppStatus->find($appStatusId); if (NULL === $appStatusInfo || FALSE === $appStatusInfo) { $appStatusInfo = []; } if (empty($appStatusInfo)) { $this->error('Parameters error', U('Student/noApplyStudentList')); } // 操作类型 1 : 添加, 2 : 编辑 $operFlag = intval(I('post.oper', 1)); // 根据操作类型, 设置不同的权限 $authRule = []; if (1 === $operFlag) { $authRule[] = AgentAuth::ADD; } else { $authRule[] = AgentAuth::WRITE; } $modelStu = new MemberStuModel(); // 验证权限 $res = AgentAuth::checkStu($appStatusInfo['s_no'], $authRule); if ($res['status'] !== 9) { $this->error('No permission'); } // 检查是否已超过允许添加的条数 $res = $modelAppStatus->checkApplyNum($appStatusInfo['year'], $appStatusInfo['s_no']); if ($res) { // 超过申请次数跳转到中介未申请学生列表 $msg = 'The application amount of ' . $appStatusInfo['year'] . 'entry for this student has run out.'; $this->error($msg, U('Student/noApplyStudentList')); } // 开始组装新添加的数据 $uid = $appStatusInfo['uid']; $fuid = $appStatusInfo['fuid']; $partid = $appStatusInfo['partid']; $stuId = $appStatusInfo['s_no']; $ano = $appStatusInfo['a_no']; // 中介的联系信息 $agentLinkInfo = $modelAppStatus->fetchAgentInfo($uid); // 获取该学生的所有个人信息 // 学生个人详细信息 $perInfo = $modelStu->fetchPerInfo($stuId, $ano); if (empty($perInfo)) { // 新增 $perInfo = $modelStu->fetchPerInfo($stuId, ''); $perInfo['id'] = ''; $perInfo['uid'] = $uid; $perInfo['fuid'] = $fuid; $perInfo['partid'] = $partid; $perInfo['s_id'] = $stuId; $perInfo['a_no'] = $ano; $perInfo['create_time'] = time(); // 将联系电话和邮箱修改成中介的 //$perInfo['contact_number'] = $agentLinkInfo['telephone']; $perInfo['email_address'] = $agentLinkInfo['email']; } // 学生个人其它信息 $perOtherInfo = $modelStu->fetchPerOtherInfo($stuId, $ano); if (empty($perOtherInfo)) { $perOtherInfo = $modelStu->fetchPerOtherInfo($stuId, ''); $perOtherInfo['id'] = ''; $perOtherInfo['uid'] = $uid; $perOtherInfo['fuid'] = $fuid; $perOtherInfo['partid'] = $partid; $perOtherInfo['s_id'] = $stuId; $perOtherInfo['a_no'] = $ano; $perOtherInfo['create_time'] = time(); } // 学生教育背景信息 $eduBackInfo = $modelStu->fetchEduBackInfo($stuId, $ano); if (empty($eduBackInfo)) { $eduBackInfo = $modelStu->fetchEduBackInfo($stuId, ''); foreach ($eduBackInfo as &$row) { $row['id'] = ''; $row['uid'] = $uid; $row['fuid'] = $fuid; $row['partid'] = $partid; $row['s_id'] = $stuId; $row['a_no'] = $ano; $row['create_time'] = time(); } unset($row); } // 语言证书信息 $engCertInfo = $modelStu->fetchEngCertInfo($stuId, $ano); if (empty($engCertInfo)) { $engCertInfo = $modelStu->fetchEngCertInfo($stuId, ''); $engCertInfo['id'] = ''; $engCertInfo['uid'] = $uid; $engCertInfo['fuid'] = $fuid; $engCertInfo['partid'] = $partid; $engCertInfo['s_id'] = $stuId; $engCertInfo['a_no'] = $ano; $engCertInfo['create_time'] = time(); } // 工作经验 $workExpInfo = $modelStu->fetchWorkExpInfo($stuId, $ano); if (empty($workExpInfo)) { $workExpInfo = $modelStu->fetchWorkExpInfo($stuId, ''); if (!empty($workExpInfo)) { foreach ($workExpInfo as &$row) { $row['id'] = ''; $row['uid'] = $uid; $row['fuid'] = $fuid; $row['partid'] = $partid; $row['s_id'] = $stuId; $row['a_no'] = $ano; $row['create_time'] = time(); } unset($row); } } // 推荐人信息 $refereeInfo = $modelStu->fetchRefereesInfo($stuId, $ano); if (empty($refereeInfo)) { $refereeInfo = $modelStu->fetchRefereesInfo($stuId, ''); foreach ($refereeInfo as &$row) { $row['id'] = ''; $row['uid'] = $uid; $row['fuid'] = $fuid; $row['partid'] = $partid; $row['s_id'] = $stuId; $row['a_no'] = $ano; $row['create_time'] = time(); } unset($row); } // 上传信息 $uploadInfo = $modelStu->fetchUploadInfo($stuId, $ano); if (empty($uploadInfo)) { $uploadInfo = $modelStu->fetchUploadInfo($stuId, ''); $uploadInfo['id'] = ''; $uploadInfo['uid'] = $uid; $uploadInfo['fuid'] = $fuid; $uploadInfo['partid'] = $partid; $uploadInfo['s_id'] = $stuId; $uploadInfo['a_no'] = $ano; $uploadInfo['create_time'] = time(); } // 开启事务 $modelStu->startTrans(); $res = $modelStu->procPerInfo($perInfo, $uid, $stuId, $ano); $res1 = $modelStu->procPerOtherInfo($perOtherInfo, $uid, $stuId, $ano); $res2 = $modelStu->procEduBackInfo($eduBackInfo, $uid, $stuId, $ano); $res3 = $modelStu->procEngLangCertInfo($engCertInfo, $uid, $stuId, $ano); $res4 = $modelStu->procWorkExpInfo($workExpInfo, $uid, $stuId, $ano); $res5 = $modelStu->procRefereeInfo($refereeInfo, $uid, $stuId, $ano); $res6 = $modelStu->procUploadInfo($uploadInfo, $uid, $stuId, $ano); if ($res && $res1 && $res2 && $res3 && $res4 && $res5 && $res6) { $modelStu->commit(); } else { $modelStu->rollback(); $this->error('Action failed!'); } $url = 'appSubmit3'; $this->redirect('addTrans', [$this->jumpUrl => $url, $this->jumpInfo => $appStatusId, 'oper' => $operFlag]); }