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; }