/**
* 查看学生详情信息.
*
* @access public
* @param integer $id 学生 id
* @return void
* @author Liuping <*****@*****.**>
*/
public function studentData($id)
{
// 是否是 Review 标记, 唯一区别就是正常查看没有个人陈述, 2 : 表示 Review
//$flag = I('post.f', '');
// 学生 id
$studentId = intval($id);
// 没有 学生 id
if (empty($studentId)) {
$this->error('Invalid parameters');
}
// 实例化模型
$model = new MemberStuModel();
// 学生基本信息
$stuInfo = $model->fetchStuInfo($studentId);
if (empty($stuInfo)) {
$this->error('Invalid parameters');
}
// 对学生做权限验证
$res = AgentAuth::checkStu($studentId, [AgentAuth::READ]);
if (9 !== $res['status']) {
$this->error('No permission');
}
// 学生所属中介 uid
$agentUId = $stuInfo['uid'];
$ano = '';
// 个人信息
$perInfo = $model->fetchPerInfo($studentId, $ano);
// 其它信息
$perOtherInfo = $model->fetchPerOtherInfo($studentId, $ano);
// 教育背景
$eduBackInfo = $model->fetchEduBackInfo($studentId, $ano);
// 语言证书
$engCertInfo = $model->fetchEngCertInfo($studentId, $ano);
// 工作经验
$workExpInfo = $model->fetchWorkExpInfo($studentId, $ano);
// 学生推荐人信息
$refereeInfo = $model->fetchRefereesInfo($studentId, $ano);
// 上传的附件信息
$uploadInfo = $model->fetchUploadInfo($studentId, $ano);
// 添加学生时限制的条数
$config = C('ADD_STUDENT_FORM_OPT');
$refereeNum = $config['refereesNum'];
// 推荐人允许的条数
// 将 推荐人信息分解成 $ref1 $ref2
$ref1 = [];
$ref2 = [];
if (!empty($refereeInfo)) {
$len = count($refereeInfo);
if ($len >= $refereeNum) {
$ref1 = $refereeInfo[0];
$ref2 = $refereeInfo[1];
} else {
$ref1 = $refereeInfo[0];
}
}
$this->assign('upload', $uploadInfo);
$this->assign('referInfo1', $ref2);
$this->assign('referInfo0', $ref1);
$this->assign('workExpInfo', $workExpInfo);
$this->assign('engCertInfo', $engCertInfo);
$this->assign('eduBackInfo', $eduBackInfo);
$this->assign('perOtherInfo', $perOtherInfo);
$this->assign('perInfo', $perInfo);
$this->assign('stuInfo', $stuInfo);
$this->display();
}
/**
* 提交申请第 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]);
}