Ejemplo n.º 1
0
    /**
     * 提交申请第 3 步处理.
     * 
     * @access public
     * @return void
     * @author Liuping <*****@*****.**>
     */
    public function appSubmit3Action()
    {
        // 校验一级中介是否有权限添加申请
        if (!AgentAuth::checkTopAgentOfApply()) {
            $this->error('No permission');
        }
        // 申请 id
        $appStatusId = intval(I('post.appStatus', ''));
        // 陈述内容
        $stateContent = I('post.stateText', '');
        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');
        }
        // 申请状态
        $applyStatus = intval($appStatusInfo['a_status']);
        // 若申请状态为材料出错(a_status : 2), 就不验证是否超过允许添加的条数和不更新申请数量
        $res = FALSE;
        // 默认为未超过申请条数
        if (2 !== $applyStatus) {
            // 检查是否已超过允许添加的条数
            $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'];
        // 个人陈述
        $perStateInfo = $modelStu->fetchPerStateInfo($stuId, $ano);
        if (empty($perStateInfo)) {
            // 新增
            $perStateInfo = $modelStu->fetchPerStateInfo($stuId, '');
            $perStateInfo['id'] = '';
            $perStateInfo['uid'] = $uid;
            $perStateInfo['fuid'] = $fuid;
            $perStateInfo['partid'] = $partid;
            $perStateInfo['s_id'] = $stuId;
            $perStateInfo['a_no'] = $ano;
            $perStateInfo['create_time'] = time();
        }
        // 陈述内容
        $perStateInfo['content'] = $stateContent;
        // 执行验证规则
        $res = $modelStu->validate($modelStu->perStateRules)->create($perStateInfo);
        if (!$res) {
            $this->error($modelStu->getError());
        }
        $modelStu->startTrans();
        // 开启事务
        $res = $modelStu->procPerStateInfo($perStateInfo, $uid, $stuId, $ano);
        $res1 = $modelAppStatus->switchCompleteStatus($appStatusId, 1, time());
        $stuFullName = $appStatusInfo['first_name'] . ' ' . $appStatusInfo['family_name'];
        // 若申请状态为材料出错(a_status : 2), 就不验证是否超过允许添加的条数和不更新申请数量
        $res2 = TRUE;
        // 默认为更新数量成功
        if (2 !== $applyStatus) {
            $res2 = $modelAppStatus->updateApplyNum($appStatusInfo['year'], $stuId, $stuFullName);
        }
        $aoInfo = $modelStu->fetchAoInfo($stuId);
        $res3 = $modelAppStatus->switchApplyStatus($appStatusId, 1);
        // 更新状态为 审核中.
        $res4 = TRUE;
        $res5 = TRUE;
        $res6 = TRUE;
        $_cont = '用户重新提交了申请';
        $_cont1 = 'Application has been resubmitted, application status changes to"Verifying by ApplicationUK"';
        if (!empty($aoInfo) && 2 === $applyStatus) {
            // 有跟进AO且状态是材料出错, 就记录日志
            $res4 = $modelStu->writeLog($aoInfo['ao_uid'], $uid, $ano, 1, date('Y-m-d H:i:s') . ', ' . $_cont);
            $res5 = $modelStu->writeApplyLog($aoInfo['ao_uid'], $uid, $ano, 1, $_cont1);
        }
        // 新申请记录新申请日志.
        if (0 === $applyStatus) {
            $_cont1 = 'Your application has been submitted and now under verification, application status changes to "Verifing by ApplicationUK"';
            $res6 = $modelStu->writeApplyLog(empty($aoInfo) ? 0 : $aoInfo['ao_uid'], $uid, $ano, 1, $_cont1);
        }
        if ($res && $res1 && $res2 && $res3 && $res4 && $res5 && $res6) {
            $modelStu->commit();
            if (!empty($aoInfo) && 2 === $applyStatus) {
                // 材料出错重新提交, 给 AO 发邮件
                $resubmitTime = date('Y-m-d H:i:s', time());
                $emailTitle = $stuFullName . ' ' . $_cont;
                $emailContent = <<<MAIL
学生姓名: {$stuFullName}.
提交时间: {$resubmitTime}.
描述: {$_cont}.
MAIL;
                // 发送邮件
                MemberStuModel::sendEmail($aoInfo['ao_user_email'], $emailTitle, $emailContent);
            } elseif (!empty($aoInfo)) {
                // 新添加/修改申请时要发邮件
                $_cont = '提交了新的申请';
                $resubmitTime = date('Y-m-d H:i:s', time());
                $emailTitle = $stuFullName . ' ' . $_cont;
                $emailContent = <<<MAIL
学生姓名: {$stuFullName}.
提交时间: {$resubmitTime}.
描述: {$_cont}.
MAIL;
                // 发送邮件
                MemberStuModel::sendEmail($aoInfo['ao_user_email'], $emailTitle, $emailContent);
            }
            // 写入系统日志
            $_mark = session('username') . '在' . date('Y-m-d H:i:s') . ', 添加了一个申请资料, 申请编号 : ' . $ano . ', 学生姓名 : ' . $appStatusInfo['first_name'] . $appStatusInfo['family_name'];
            if (1 === $operFlag) {
                // 写入新增日志
                system_log($_mark, $modelAppStatus->getTableName(), $ano, 'a', $appStatusInfo, NULL, 1);
            }
            // 成功跳转到已申请列表.
            //$this->success('Successful!', U('Student/studentList'));
            $this->success('Successful!', U('Student/studentDetail', ['id' => $stuId]));
        } else {
            $modelStu->rollback();
            $this->error('Action failed');
        }
    }
Ejemplo n.º 2
0
    /**
     * 额外材料提交处理.
     * 
     * @access public
     * @return void
     * @author Liuping <*****@*****.**>
     */
    public function extraFilesAction()
    {
        $extraId = intval(I('post.extraStatus', ''));
        // 额外材料主键ID
        if (empty($extraId)) {
            $this->error('Invalid parameters');
        }
        // 实例化额外信息
        $modelExtra = M('member_upload_extra');
        $extraInfo = $modelExtra->find($extraId);
        if (NULL === $extraInfo || FALSE === $extraInfo) {
            $this->error('Invalid parameters');
        }
        $stuId = $extraInfo['s_id'];
        // 学生 id
        $ano = $extraInfo['a_no'];
        // 申请编号
        $postExtraDetail = I('post.detail', '');
        if (empty($postExtraDetail)) {
            $this->error('Please provide valid files');
        }
        // 去掉为空的数据
        $data = [];
        $_detailSrcs = isset($postExtraDetail['src']) ? $postExtraDetail['src'] : [];
        $_detailIds = isset($postExtraDetail['id']) ? $postExtraDetail['id'] : [];
        foreach ($_detailSrcs as $k => $v) {
            if (!empty($v)) {
                $data[] = ['id' => $_detailIds[$k], 'src' => $v];
            }
        }
        if (empty($data)) {
            $this->error('Please provide valid files');
        }
        $uid = session('uid');
        // 组装数据
        foreach ($data as &$row) {
            $row['fid'] = $extraId;
            $row['uid'] = $uid;
            $row['a_no'] = $ano;
            $_id = $row['id'];
            if (empty($_id)) {
                $row['reason'] = '';
                $row['create_time'] = date('Y-m-d H:i:s', time());
                $row['update_time'] = date('Y-m-d H:i:s', time());
                $row['is_del'] = 0;
            } else {
                $row['update_time'] = date('Y-m-d H:i:s', time());
            }
        }
        unset($row);
        $allowExtraNum = 5;
        // 同一个申请额外材料允许的最多条数
        $data = array_slice($data, 0, $allowExtraNum);
        $modelExtra->startTrans();
        // 开启事务
        $res = $this->procExtraDetailInfo($data);
        // 更新状态为已完成上传
        $res1 = $modelExtra->where('id=:id')->bind(':id', $extraId)->save(['is_complete' => 1]);
        if (FALSE !== $res1) {
            $res1 = TRUE;
        }
        // 写入日志
        $modelStu = new MemberStuModel();
        $aoInfo = $modelStu->fetchAoInfo($stuId);
        // 获取AO信息
        $modelAppStatus = new ApplyStatusModel();
        // 获取申请信息
        $appStatusInfo = $modelAppStatus->where('s_no=:sno AND a_no=:ano')->bind([':sno' => $stuId, ':ano' => $ano])->find();
        $strFullName = '';
        if (!empty($appStatusInfo)) {
            $strFullName = $appStatusInfo['first_name'] . ' ' . $appStatusInfo['family_name'];
        }
        $res2 = TRUE;
        $res3 = TRUE;
        $_cont = '用户提交了额外材料';
        $_cont1 = 'Your extra files have been received, application status changes to "Assessing by university"';
        if (!empty($aoInfo) && !empty($appStatusInfo)) {
            $res2 = $modelStu->writeLog($aoInfo['ao_uid'], $appStatusInfo['uid'], $ano, 1, date('Y-m-d H:i:s') . ', ' . $_cont);
            $res3 = $modelStu->writeApplyLog($aoInfo['ao_uid'], $appStatusInfo['uid'], $ano, 1, $_cont1);
        }
        // 更新额外材料标志位
        $res4 = $modelAppStatus->switchExtraFilesStatus($appStatusInfo['id'], 2);
        $res5 = $modelAppStatus->switchApplyStatus($appStatusInfo['id'], 5);
        // 评估中
        if ($res && $res1 && $res2 && $res3 && $res4 && $res5) {
            $modelExtra->commit();
            // 提交事务
            // 都成功, 给 AO 发送邮件
            if (!empty($aoInfo) && !empty($appStatusInfo)) {
                $resubmitTime = date('Y-m-d H:i:s', time());
                $emailTitle = $strFullName . ' ' . $_cont;
                $emailContent = <<<MAIL
学生姓名: {$strFullName}.
提交时间: {$resubmitTime}.
描述: {$_cont}.
MAIL;
                // 发送邮件
                MemberStuModel::sendEmail($aoInfo['ao_user_email'], $emailTitle, $emailContent);
            }
            $this->success('Successful!', U('studentDetail', ['id' => $stuId]));
        } else {
            $modelExtra->rollback();
            $this->error('Action failed');
        }
    }
Ejemplo n.º 3
0
    /**
     * @上传额外材料操作
     * @Author: 段涛
     * @function name: extraFilesAction
     */
    public function extraFilesAction()
    {
        $ano = I('get.ano');
        if (empty($ano)) {
            $this->error(L('MSG_VALIDATE18'), U('/Home/index'));
        }
        $data = I('post.');
        if ($data['detail']['src'][0] == '') {
            $this->error('Please upload at least one file.');
        }
        $model1 = M('member_upload_extra');
        $model1->startTrans();
        $model2 = M('member_upload_extra_deputy');
        $model2->startTrans();
        $status = 1;
        //        $isComplete=$model1->where(array('a_no'=>$ano))->getField('is_complete');
        //        if($isComplete==1){
        //            $this->error('对不起,您已经提交过了,切勿重复提交!');
        //        }
        foreach ($data['detail']['id'] as $k => $rs) {
            if (empty($data['detail']['src'][$k])) {
                //如果为空,则删除
                $result = $model2->where(array('id' => $rs))->delete();
                if ($result === false) {
                    $status = 0;
                }
            } elseif (!empty($data['detail']['src'][$k]) && empty($rs)) {
                //链接不为空,和数据ID为空,则为添加
                $data['fid'] = $data['extraStatus'];
                $data['uid'] = session('uid');
                $data['a_no'] = $ano;
                $data['src'] = $data['detail']['src'][$k];
                $data['create_time'] = date("Y-m-d H:i:s", strtotime(time()));
                $data['name'] = '学生';
                $result = $model2->add($data);
                if ($result === false) {
                    $status = 0;
                }
            } else {
                //不为空则为添加
                $result = $model2->save(array('id' => $rs, 'src' => $data['detail']['src'][$k]));
                if ($result === false) {
                    $status = 0;
                }
            }
        }
        //更新额外材料主附表
        $result2 = $model1->save(array('id' => $data['extraStatus'], 'is_complete' => 1, 'updata_time' => time()));
        // 写入日志
        $stuId = M('member_stu')->where(array('uid' => session('uid')))->getField('id');
        if ($stuId == "") {
            $model2->rollback();
            $model1->rollback();
            $this->error(L('data error'));
        }
        $modelStu = new MemberStuModel();
        $aoInfo = $modelStu->fetchAoInfo($stuId);
        // 获取AO信息
        $modelAppStatus = new ApplyStatusModel();
        // 获取申请信息
        $appStatusInfo = $modelAppStatus->where('s_no=:sno AND a_no=:ano')->bind([':sno' => $stuId, ':ano' => $ano])->find();
        $strFullName = '';
        if (!empty($appStatusInfo)) {
            $strFullName = $appStatusInfo['first_name'] . ' ' . $appStatusInfo['family_name'];
        }
        $res2 = TRUE;
        $res3 = TRUE;
        $_cont = '用户提交了额外材料';
        $_cont1 = 'Your extra files have been received, application status changes to "Assessing by university"';
        if (!empty($aoInfo) && !empty($appStatusInfo)) {
            $res2 = $modelStu->writeLog($aoInfo['ao_uid'], $appStatusInfo['uid'], $ano, 1, date('Y-m-d H:i:s') . ', ' . $_cont);
            $res3 = $modelStu->writeApplyLog($aoInfo['ao_uid'], $appStatusInfo['uid'], $ano, 1, $_cont1);
        }
        // 更新额外材料标志位
        $res4 = $modelAppStatus->switchExtraFilesStatus($appStatusInfo['id'], 2);
        $res5 = $modelAppStatus->switchApplyStatus($appStatusInfo['id'], 5);
        // 评估中
        if ($status && $result2 && $res2 && $res3 && $res4 && $res5) {
            $model2->commit();
            $model1->commit();
            // 都成功, 给 AO 发送邮件
            if (!empty($aoInfo) && !empty($appStatusInfo)) {
                $resubmitTime = date('Y-m-d H:i:s', time());
                $emailTitle = $strFullName . ' ' . $_cont;
                $emailContent = <<<MAIL
                    学生姓名: {$strFullName}.
                    提交时间: {$resubmitTime}.
                    描述: {$_cont}.
MAIL;
                // 发送邮件
                MemberStuModel::sendEmail($aoInfo['ao_user_email'], $emailTitle, $emailContent);
                //给学生发邮件
                $this->sentMailToUser($ano);
            }
            $this->success(L('MSG_VALIDATE22'), U('Home/Member/index'));
        } else {
            $model2->rollback();
            $model1->rollback();
            $this->error(L('MSG_VALIDATE23'));
        }
    }