public function plan()
{
if ($_GET) {
$applyInfoModel = M('apply_info');
$uid = session('uid');
$year = $applyInfoModel->field('year')->where("uid={$uid}")->find();
$universityMajorModel = M('university_major');
$majorData = $universityMajorModel->field('id,us_id,su_id,sub_id,start_time')->where("id={$_GET['id']}")->find();
$startTime = month_map($majorData['start_time'], true);
echo json_encode(array('year' => $year, 'month' => $startTime, 'other' => $majorData));
}
}
private function applyInfo($a_no, $lang)
{
$statusModel = M('apply_status');
$field = "CASE WHEN a.o_status>=4 THEN c.uo_expire\n ELSE c.co_expire END expire,\n CASE WHEN a.needMargin=1 THEN CONCAT('£',a.margin)\n ELSE 'None' END margin,a.isOfferAccept isofferaccept,\n CASE WHEN a.needMargin=1 AND a.marginStatus=2 THEN 1 END deposit,\n CASE WHEN a.needMargin=2 OR a.marginStatus=1 THEN 1 END accept,\n c.offer_txt,b.name us,d.name mj,a.uid,a.a_no,a.year,a.o_status,f.logo,DATE_FORMAT(a.openDate,'%d/%b/%Y') entranceDate,a.reason3,a.s_no,\n e.transcript,e.reference_letter_1,e.reference_letter_2,\n e.english_transcript,e.diploma,e.degree_certificate,e.uk_visa,\n e.resume,e.achievement,e.passport,e.id,\n g.cas_txt,g.cas_expire";
$join = "LEFT JOIN __UNIVERSITYLANG__ b ON a.us_id=b.fid\n LEFT JOIN __APPLY_OFFER__ c ON a.a_no=c.a_no\n LEFT JOIN __UNIVERSITY_MAJORLANG__ d ON a.mj_id=d.fid\n LEFT JOIN __MEMBER_UPLOAD__ e ON a.a_no=e.a_no\n LEFT JOIN __UNIVERSITY__ f ON a.us_id=f.id\n LEFT JOIN __APPLY_CAS__ g ON a.a_no=g.a_no";
$where = "a.a_no='{$a_no}' and b.lang='en-us' and d.lang='en-us'";
$info = $statusModel->alias('a')->field($field)->join($join)->where($where)->find();
$expire = explode('/', $info['expire']);
if (!empty($expire[1])) {
$info['expire'] = $expire[0] . '/' . month_map($expire[1]) . '/' . $expire[2];
}
$casexpire = explode('/', $info['cas_expire']);
if (!empty($casexpire[1])) {
$info['cas_expire'] = $casexpire[0] . '/' . month_map($casexpire[1]) . '/' . $casexpire[2];
}
$info['offer_txt'] = htmlspecialchars_decode($info['offer_txt']);
$info['cas_txt'] = htmlspecialchars_decode($info['cas_txt']);
$info['reason3'] = htmlspecialchars_decode($info['reason3']);
return $info;
}
/**
* 得到收藏的学校ID
* @access public
* @param $id int 专业ID
* @return string
* @author liuxiaolin <*****@*****.**>
*/
public function getCourseTpl($id)
{
$majorModel = M('university_majorlang');
$lang = LANG_SET;
$field = 'a.fid as id, a.us_id, a.su_id, a.sub_id, a.name, a.introduction, a.apply_way,
a.category, a.degree, a.addr, b.url, b.duration, b.start_time, b.tuition, b.a_tuition, b.s_ship, b.p_ship,c.stip_val';
$where = array('a.fid' => $id, 'a.lang' => $lang);
$join = array('inner join __UNIVERSITY_MAJOR__ as b on b.id = a.fid left join __UNIVERSITY__ c ON a.us_id=c.id');
//得到专业信息
$majorData = $majorModel->alias('a')->field($field)->join($join)->where($where)->find();
$time = date('Y-m', time());
$timeArr = explode('-', $time);
if ($timeArr[1] >= 9) {
$res = $timeArr[0] + 1;
} else {
$res = $timeArr[0];
}
$majorData['year'] = $res;
//处理入学时间;
$majorData['start_time'] = month_map($majorData['start_time']);
if ($majorData['tuition'] == 0) {
$majorData['tuition'] = '--';
}
$courseModel = M('university_major_courselang');
$field = 'a.name';
$where = array('a.mj_id' => $id, 'a.lang' => $lang);
$join = array('inner join __UNIVERSITY_MAJOR_COURSE__ as b on b.id = a.fid');
//得到课程信息
$courseData = $courseModel->alias('a')->field($field)->join($join)->where($where)->select();
//处理专业详情及课程
$img = new \Home\Lib\CreatePic();
if (is_wap()) {
$width = 480;
} else {
$width = 800;
}
$majorData['introduction'] = $img->gen($majorData['introduction'], $width, 11);
$course = $img->gen(array_column($courseData, "name"), $width, 11);
$this->assign('major', $majorData);
$this->assign('course', $course);
if (is_wap()) {
$url = T('bootstrap/Match/courseTpl');
} else {
$url = T('default/Match/courseTpl');
}
$html = $this->fetch($url);
echo $html;
}
