/** *展会信息 *@date 2010-6-2 *@time 上午10:38:22 */ function show() { //展会信息 $aid = intval($_REQUEST['aid']); $this->assign('industries', $this->_get_fair()); $this->assign("city", $this->_get_city('fair')); $this->assign('date', $this->_get_time()); $year = array(); $nowyear = date('Y'); $year['sy']['name'] = $nowyear; $year['sy']['ms'] = mktime(0, 0, 0, 1, 1, $nowyear); $year['sy']['me'] = mktime(0, 0, 0, 1, 1, $nowyear + 1) - 1; $year['ny']['name'] = $nowyear + 1; $year['ny']['ms'] = mktime(0, 0, 0, 1, 1, $nowyear + 1); $year['ny']['me'] = mktime(0, 0, 0, 1, 1, $nowyear + 2) - 1; $this->assign('year', $year); $flang = Input::getVar($_REQUEST['flang']); $dao = D("Archives"); $condition = array(); if ($flang) { $lan = explode('_', $flang); if ($lan['1'] == 'CN') { $flang = $lan['0'] . '_CN'; } else { $flang = $lan['0'] . '_EN'; } $condition['writer'] = $flang; $condition['channel'] = 11; $_SESSION['flang'] = $lan['1']; } else { $condition['id'] = $aid; } $info = $dao->where($condition)->find(); if ($info['ismake'] == '0') { $this->error("error: the information has been deleted!"); } if (empty($info)) { $this->error("sorry,the information is not available now.<br/>\n您查看的信息暂时空缺。"); } $lan = explode('_', $info['writer']); $lang['cn'] = $lan['0'] . '_CN'; $lang['en'] = $lan['0'] . '_EN'; $this->assign('lang', $lang); $info['_fair'] = $dao->relationGet("fair"); $album = $this->get_album($info['id'], $info['channel']); if ($info['picurl']) { $info['picurl'] = str_replace('../Public/Uploads', '/Public/Uploads', $info['picurl']); } else { $info['picurl'] = out_images($album['0'], 's'); } $info['albumnum'] = count($album); $this->assign("album", $album); $this->assign('info', $info); $page = array(); $page['title'] = $info['title'] . ' - BeingfunChina 缤纷中国'; $page['keywords'] = $info['keywords'] . ',fair,china,biz'; $page['description'] = $info['description']; $this->assign('page', $page); $this->assign('dh', $this->_get_dh($info['typeid'])); $this->display(); }
/** *分类信息内容页面 *@date 2010-4-30 *@time 下午05:08:30 */ function show() { //分类信息内容页面 $aid = intval($_GET['aid']); if (empty($aid)) { $this->error("error: aid is null!"); } $dao = D("Archives"); $info = $dao->where("id={$aid}")->find(); if (empty($info)) { $this->error("error: info is null!"); } if ($info['ismake'] == '0') { $this->error("error: the information has been deleted!"); } $this->ads($info['channel'], 'content', '1'); $city = $this->_get_city('localion'); switch (true) { case $info['channel'] == 4: //Jobs $info['_jobs'] = $dao->relationGet("jobs"); $info['itype'] = $info['itype'] == '0' ? 'All' : $info['itype'] == '1' ? 'Offered' : 'Wanted'; $category = array("All", "Full time", "Part time", "Internship", "Voluntary"); $info['category'] = $category[$info['category']]; break; case $info['channel'] == 5: //realestate $info['_realestate'] = $dao->relationGet("realestate"); break; case $info['channel'] == 6: //commerce $types = array(1 => 'All', 2 => 'Offered', 3 => 'Wanted'); $cat = array('Brand-new', 'Second-hand'); $info['itype'] = $types[$info['type']]; $info['category'] = $cat[$info['category']]; $info['_commerce'] = $dao->relationGet("commerce"); break; case $info['channel'] == 7: //agents $info['_agents'] = $dao->relationGet("agents"); break; case $info['channel'] == 8: //personals $info['_personals'] = $dao->relationGet("personals"); break; case $info['channel'] == 9: //services $info['itype'] = $info['itype'] == 1 ? 'All' : $info['itype'] == 2 ? 'Offered' : 'Wanted'; $category = array("All", "Full time", "Part time", "Internship", "Voluntary"); $info['category'] = $category[$info['category']]; $info['_services'] = $dao->relationGet("services"); break; } $local = ''; if ($info['zone_id'] && $info['city_id']) { $local = $city[$info['city_id']]['_zone'][$info['zone_id']]['name'] . ',' . $city[$info['city_id']]['cename']; } elseif (empty($info['zone_id']) && $info['city_id']) { $local = $city[$info['city_id']]['cename']; } $info['position'] = trim($info['position'] . ',' . $local, ','); $album = $this->get_album($info['id'], $info['channel']); if ($info['picurl']) { $info['picurl'] = str_replace('../Public/Uploads', '/Public/Uploads', $info['picurl']); } else { $info['picurl'] = out_images($album['0'], 's'); } $info['albumnum'] = count($album); $this->assign("album", $album); $this->assign('info', $info); //$this->assign('comments',$this->_get_comments($info['id'],$info['channel'])); $this->assign("group", $this->member_group($this->member_comments($info['id'], $info['channel']), "0,6")); $page = array(); $page['title'] = $info['title'] . ' - BeingfunChina 缤纷中国'; $page['keywords'] = $info['keywords']; $page['description'] = $info['description']; $this->assign('page', $page); if ($this->_is_admin() || $this->user['uid'] == $info['uid']) { $cp = '<a href="/Cp/photo/info/' . $info['channel'] . '_' . $info['id'] . '">Add Photos</a> / <a href="/Cp/my_edit_classifieds/info/' . $info['channel'] . '_' . $info['id'] . '">edit</a> / <a href="/Cp/del_arc/info/' . $info['channel'] . '_' . $info['id'] . '/to/' . myencode("/clist/{$info['typeid']}.html") . '/">remove</a>'; $cp .= string2checked('f', $info['flag'], ',', '1') == 1 ? " / <a href=\"/Cp/attr/info/{$info['channel']}_{$info['id']}/clear/f/to/" . myencode("/clss/{$info['id']}.html") . "\" title=\"clear Featured\"><font color=\"#FF0000\">Featured</font></a> / " : " / <a href=\"/Cp/attr/info/{$info['channel']}_{$info['id']}/fld/f/to/" . myencode("/clss/{$info['id']}.html") . "\" title=\"Set Featured\">Featured</a> / "; $this->assign('cp', $cp); } //dump($this->_get_dh($info['typeid'])); $this->assign('dh', $this->_get_dh($info['typeid'])); $cid_sql = ''; if ($this->pcid == '0') { $cid_sql = ""; } elseif ($this->pcid < 1000) { $cid_sql = " AND (cid={$this->pcid} or cid='0')"; } else { $city_temp = array('name' => '', 'id' => ''); foreach ($this->cgroup[$this->pcid]['city'] as $k => $v) { $city_temp['id'] .= $k . ','; $city_temp['name'] .= $v . ','; } $cid_sql = " AND (cid in ({$city_temp['id']} or cid='0')"; } $this->assign("new_arc", $this->_get_uptype_arc($info['typeid'])); $f_arc = array(); $condition = array(); $condition['ismake'] = '1'; $classifieds_ch = '4,5,6,7,8,9'; $condition['channel'] = array('in', "{$classifieds_ch}"); $condition['_string'] = "FIND_IN_SET('f',`flag`) > 0"; if ($this->pcid == '0') { $condition['_string'] .= ""; } elseif ($this->pcid < 1000) { $condition['_string'] .= " AND (cid={$this->pcid} or cid='0')"; } else { $city_temp = array('name' => '', 'id' => ''); foreach ($this->cgroup[$this->pcid]['city'] as $k => $v) { $city_temp['id'] .= $k . ','; $city_temp['name'] .= $v . ','; } $condition['_string'] .= " AND (cid in ({$city_temp['id']}) or cid='0')"; } $f_arc = $dao->where($condition)->order("pubdate DESC")->limit("0,20")->findAll(); shuffle($f_arc); $this->assign('f_arc', $f_arc); $condition = array(); $st = mktime(0, 0, 1, date("m"), date("d"), date("Y")); $et = mktime(59, 59, 59, date("m"), date("d") + 30, date("Y")); $condition['channel'] = '10'; $condition['ismake'] = '1'; $condition['_string'] = "`showstart`>={$st} AND `showstart`<={$et}"; if ($this->pcid == '0' || empty($this->pcid)) { $city = ''; } elseif ($this->pcid < 1000) { $city = " AND (cid={$this->pcid} or cid='0')"; } else { $city_temp = array('name' => '', 'id' => ''); foreach ($this->cgroup[$this->pcid]['city'] as $k => $v) { $city_temp['id'] .= $k . ','; $city_temp['name'] .= $v . ','; } $city = " AND (cid in ({$city_temp['id']}) or cid='0')"; } $condition['_string'] .= $city; $f_event = array(); $f_event = $dao->where($condition)->order("pubdate DESC")->limit("0,20")->findAll(); shuffle($f_event); $this->assign("event", $f_event); $this->display(); }
/** *城市指南内容页 *@date 2010-5-12 *@time 下午04:13:26 */ function show() { //城市指南内容页 $aid = intval($_GET['aid']); if (empty($aid)) { $this->error("error: aid is null!"); } $this->chk_cid(); /*$dao=D("CityGuideView"); $info=$dao->where("Archives.id=$aid")->find();*/ $dao = D("Archives"); $info = $dao->where("id={$aid}")->find(); if (!empty($info['reurl']) && $info['reurl'] != 'http://') { redirect($info['reurl']); } if ($info['ismake'] == '0') { $this->error("error: the information has been deleted!"); } $info['content'] = $dao->relationGet("article"); $cname = array('bj' => 'Beijing', 'sh' => 'Shanghai', 'gz' => 'Guangzhou', 'sz' => 'Shenzhen'); //if(empty($info['maps'])){ $city = $this->_get_city('localion'); $local = ''; if ($info['zone_id'] && $info['city_id']) { $local = $cname[$city[$info['city_id']]['cename']] . ' ' . $city[$info['city_id']]['_zone'][$info['zone_id']]['name'] . ' District'; } elseif (empty($info['zone_id']) && $info['city_id']) { $local = $city[$info['city_id']]['cename']; } $local = trim($info['position'] . ',' . $local, ','); $info['maps'] = $info['contact']; //} $album = $this->get_album($info['id'], $info['channel']); if ($info['picurl']) { $info['picurl'] = str_replace('../Public/Uploads', '/Public/Uploads', $info['picurl']); } else { $info['picurl'] = out_images($album['0'], 's'); } $info['albumnum'] = count($album); $this->assign("album", $album); $this->assign("group", $this->member_group($this->member_comments($info['id'], $info['channel']), "0,6")); $this->assign('info', $info); $page = array(); $page['title'] = $info['title'] . ' - BeingfunChina 缤纷中国'; $page['keywords'] = $info['keywords']; $page['description'] = $info['description']; $this->assign('page', $page); $this->assign('dh', $this->_get_dh($info['typeid'])); $this->ads('2', 'content', 0, $info['typeid']); if ($this->_is_admin()) { $cp = '<a href="/Cp/photo/info/2_' . $info['id'] . '">Add Photos</a> / <a href="/Cp/my_edit_cityguide/info/2_' . $info['id'] . '">edit</a> / <a href="/Cp/del_arc/info/2_' . $info['id'] . '/to/' . myencode("/cglist/{$info['typeid']}.html") . '">remove</a>'; $this->assign('cp', $cp); } $this->assign("new_arc", $this->_get_uptype_arc($info['typeid'])); $condition = array(); $st = mktime(0, 0, 1, date("m"), date("d"), date("Y")); $et = mktime(59, 59, 59, date("m"), date("d") + 30, date("Y")); $condition['channel'] = '10'; $condition['ismake'] = '1'; $condition['_string'] = "`showstart`>={$st} AND `showstart`<={$et}"; if ($this->pcid == '0' || empty($this->pcid)) { $city = ''; } elseif ($this->pcid < 1000) { $city = " AND (cid={$this->pcid} or cid='0')"; } else { $city_temp = array('name' => '', 'id' => ''); foreach ($this->cgroup[$this->pcid]['city'] as $k => $v) { $city_temp['id'] .= $k . ','; $city_temp['name'] .= $v . ','; } $city = " AND (cid in ({$city_temp['id']}) or cid='0')"; } $condition['_string'] .= $city; $f_event = array(); $f_event = $dao->where($condition)->order("pubdate DESC")->limit("0,20")->findAll(); shuffle($f_event); //dump($dao->getLastSql()); $this->assign("event", $f_event); self::album(); self::ctg_news(); $this->display(); }