/**
* 获取专业大学的专业数据.
*
* @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();
}
