/** * 获取专业大学的专业数据. * * @access private * @param integer $schoolId 学校 id * @param integer $suId 大学科 id * @param integer $subId 子学科 id * @param integer $type 学科所属 Programme type 类型, 1 : 硕士(1-7), 2 : 硕士预科(7 以下) * @param string $lang 语系, 默认 en-us * @return array * @author Liuping <*****@*****.**> */ private function fetchCourseData($schoolId, $suId, $subId, $type, $lang = 'en-us') { $where = 'a.lang=:lang AND a.us_id=:us_id'; $binds[':lang'] = $lang; $binds[':us_id'] = $schoolId; if (intval($suId) < 1) { if (1 === $type) { // 硕士 $where .= " AND a.su_id <= 7"; } else { // 硕士预科 $where .= " AND a.su_id > 7"; } } else { $where .= " AND a.su_id=:su_id"; $binds[':su_id'] = $suId; } if (intval($subId) < 1) { } else { $where .= " AND a.sub_id=:sub_id"; $binds[':sub_id'] = $subId; } // 2016-1-20 列出所有专业, 前端还要做一个若选择的是已关闭的专业给一个弹出提示. //$where .= " AND a.is_close=0"; // 2015-12-9 已关闭的专业不列出. /* $where = 'lang=:lang AND us_id=:us_id AND su_id=:su_id AND sub_id=:sub_id'; $fields = ['fid AS major_id', 'name AS major_name']; $binds = [':lang' => $lang, ':us_id' => $schoolId, ':su_id' => $suId, ':sub_id' => $subId]; */ $fields = ['a.fid AS major_id', 'a.name AS major_name', 'a.su_id AS main_sub_id', 'a.sub_id AS child_sub_id', 'b.start_time', 'a.is_close AS closed']; $model = M('university_majorlang'); $joins = ["INNER JOIN __UNIVERSITY_MAJOR__ AS b ON a.fid=b.id"]; $lists = $model->alias('a')->field($fields)->join($joins)->where($where)->bind($binds)->select(); if (FALSE === $lists) { return []; } // 处理 lists 中的 start_time 为数组. foreach ($lists as &$row) { $tmp = getApplyMonth($row['start_time'], $lang); $tmp = empty($tmp) ? [] : $tmp; $row['start_time'] = $tmp; } unset($row); return $lists; }
public function shopCarStep4() { $anoList = unserialize(session('appNumber')); //获取批量申请编号集 //查找收藏夹 $where['a.uid'] = session('uid'); $where['a.id'] = array('IN', session('shopCar')); $statusList = session('STATUS_'); $where['b.id'] = array('IN', $statusList); $field = 'a.us_id,a.su_id,a.sub_id,a.mj_id,b.year,a.month,b.a_no'; $collectionList = M('apply_collection')->alias('a')->field($field)->join('LEFT JOIN __APPLY_STATUS__ b ON a.us_id=b.us_id and a.mj_id=b.mj_id and a.uid=b.uid')->where($where)->select(); $sql = M('apply_collection')->getLastSql(); if (count($collectionList) > 0) { //判断收藏的数据集不为空! //对数据进行加工! foreach ($collectionList as $rs) { $carBuy['universityName'] = M('universitylang')->where(array('lang' => 'en-us', 'fid' => $rs['us_id']))->getField('name'); //获取学校名称 $carBuy['universityID'] = $rs['us_id']; $carBuy['logo'] = M('university')->where(array('id' => $rs['us_id']))->getField('logo'); //获取学校LOGO $carBuy['majorName'] = M('university_majorlang')->where(array('lang' => 'en-us', 'fid' => $rs['mj_id']))->getField('name'); //获取专业名称 $carBuy['majorID'] = $rs['mj_id']; $carBuy['year'] = $rs['year']; $carBuy['a_no'] = $rs['a_no']; $carBuy['content'] = M('member_personal_statement')->where(array('uid' => session('uid'), 'a_no' => $rs['a_no']))->find()['content']; // if(empty($carBuy['content'])){ // $carBuy['content'] = M( 'member_personal_statement' )->where( array( 'uid' => session( 'uid' ),'a_no'=>'' ) )->find()['content']; // } $sql = M('member_personal_statement')->getLastSql(); if ($rs['sub_id'] > 7) { $carBuy['type'] = 2; } else { $carBuy['type'] = 1; } $carBuy['monthList'] = getApplyMonth($rs['month']); $allList[] = $carBuy; } $this->assign('collectionList', $allList); } else { $this->error('ERROR'); } $memberPS = M('member_personal_statement')->where(array('a_no' => array('in', $anoList['ano'])))->find(); //通过学生编号,获取页面数据 if (!$memberPS) { $memberPS = M('member_personal_statement')->where(array('uid' => session('uid'), 'a_no' => ''))->find(); //通过学生登录ID,获取页面数据 } $this->assign('memberPS', $memberPS); $this->display(); }
/** * @查看个人资料 * @Author: 段涛 * @function name: applyreview * @param $appID申请编号 * @return bool */ public function applyreview($appID) { //安全检测 $owner = M('apply_status')->where(array('uid' => session('uid'), 'a_no' => $appID))->Count('id'); if (!$owner) { $this->error(L('MSG_VALIDATE14'), U('/Home/Index')); return false; } //输出申请内容 $where['a_no'] = $appID; $member = M('member')->where($where)->find(); $this->assign('member', $member); //用户基本资料 $certificate = M('member_certificate')->where($where)->find(); $this->assign('certificate', $certificate); //用户基语言证书 $education = M('member_education')->where($where)->order('id ASC')->select(); $this->assign('Education', $education); //用户教育背景资料 $other = M('member_other')->where($where)->find(); $this->assign('other', $other); //用户其他信息 $PS = M('member_personal_statement')->where($where)->find(); $this->assign('PS', $PS); //用户个人陈述 $referees = M('member_referees')->where($where)->order('id ASC')->select(); $this->assign('referees', $referees); //用户推荐人 $upload = M('member_upload')->where($where)->find(); $this->assign('upload', $upload); //上传文件 $work = M('member_work_experience')->where($where)->order('id ASC')->select(); $this->assign('work', $work); //用户工作经验 //获取申请专业,学校,年份信息 $status = M('apply_status')->field('year,us_id,mj_id')->where(array('a_no' => $appID))->find(); $status['us_Name'] = M('universitylang')->where(array('lang' => 'en-us', 'fid' => $status['us_id']))->getField('name'); $status['mj_Name'] = M('university_majorlang')->where(array('lang' => 'en-us', 'fid' => $status['mj_id']))->getField('name'); $appMonth = M('apply_status')->where($where)->getField('month'); $status['month'] = getApplyMonth($appMonth); $this->assign('status', $status); $this->display(); }