$sql = "select a.* from sline_model_archive a left join sline_allorderlist b on(a.id=b.aid and b.typeid={$typeid} ) {$where} order by b.displayorder asc, a.modtime desc,a.addtime desc "; } $destinfo = TongYong::getDestSeoInfo($module_dest_table, $dest_id); //目的地优化信息; $seoinfo = TongYong::getSeoInfo($destinfo, $attrid, $typeid); //组合搜索标题 //下级目的地 $destlist = Helper_Archive::getChildDest($dest_id, $typeid); $pv = new ListView($typeid); $pv->pagesize = 16; //分页条数. $pv->SetSql($sql); //seo变量赋值 foreach ($destinfo as $k => $v) { $pv->Fields[$k] = $v; } foreach ($seoinfo as $k => $v) { $pv->Fields[$k] = $v; } $pv->Fields['typeid'] = $typeid; $pv->Fields['modulename'] = $module_name; $pv->Fields['modulepinyin'] = $module_pinyin; $pv->SetParameter('destid', $dest_id); $pv->SetParameter('attrid', $attrid); $templet = Helper_Archive::getUseTemplet('line_list'); //获取使用模板 $templet = SLINETEMPLATE . "/" . $cfg_df_style . "/tongyong/tongyong_index.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit;
} $sql = "select a.* from #@__visa a left join #@__allorderlist b on (a.id=b.aid and b.typeid={$typeid} and a.webid=b.webid) where a.ishidden=0 {$where} order by case when b.displayorder is null then 9999 end,b.displayorder asc,a.modtime desc,a.addtime desc"; $seoarr = array(); //seo信息数组 $seoarr['typename'] = GetTypeName($typeid); $seoarr['pageno'] = !empty($pageno) ? '第' . $pageno . '页-' : ""; $seoarr['seotitle'] = $countryinfo['seotitle'] ? $countryinfo['seotitle'] : $countryinfo['kindname']; $seoarr['seodescription'] = !empty($countryinfo['description']) ? "<meta name=\"description\" content=\"" . $countryinfo['description'] . "\"/>" : ""; $seoarr['seokeyword'] = !empty($countryinfo['keyword']) ? "<meta name=\"keywords\" content=\"" . $countryinfo['keyword'] . "\"/>" : ""; $seoarr['jieshao'] = $countryinfo['jieshao']; $seoarr['litpic_guoqi'] = $countryinfo['countrypic'] ? $countryinfo['countrypic'] : getDefaultImage(); $seoarr['bigpic'] = $countryinfo['bigpic'] ? $countryinfo['bigpic'] : '/templets/smore/images/guojia_bg.jpg'; $seoarr['countryname'] = $countryinfo['kindname']; $pv = new ListView($typeid); $pv->pagesize = 8; //分页条数. $pv->SetSql($sql); //seo变量赋值 foreach ($seoarr as $k => $v) { $pv->Fields[$k] = $v; } $pv->SetParameter('countrypy', $countrypy); $pv->SetParameter('cityid', $cityid); //模板选择 $templet = Helper_Archive::getUseTemplet('visa_list'); //获取使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "visa/list.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit;
$pv = new ListView($typeid); $pv->pagesize = 40; //分页条数. $pv->Fields['tagword'] = $tagwords; $pv->SetSql($sql); //seo变量赋值 foreach ($destinfo as $k => $v) { $pv->Fields[$k] = $v; } foreach ($seoarr as $k => $v) { $pv->Fields[$k] = $v; } $pv->Fields['searchname'] = empty($pv->Fields['dest_name']) ? $keyword : $pv->Fields['dest_name']; $pv->Fields['searchname'] = empty($pv->Fields['searchname']) ? '全部' : $pv->Fields['searchname']; //分页搜索条件 $pv->SetParameter('dest_id', $dest_id); $pv->SetParameter('priceid', $priceid); $pv->SetParameter('sorttype', $sorttype); $pv->SetParameter('keyword', $keyword); $pv->SetParameter('attrid', $attrid); //获取上级开启了导航的目的地 getTopNavDest($dest_id); //模板选择 $templet = Helper_Archive::getUseTemplet('spot_list'); //获取使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "spots/" . "spot_search.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit; //本页面用到的函数
$whereor = trim(trim($whereor), 'or'); $wh = !empty($whereor) ? "({$where}) or ({$whereor})" : $where; $leftnavinfo = getLeftNav($wh, $typeid); $whereor = empty($whereor) ? $where : $whereor; /*if($typeid) { // $wh.='('.$wh.')'." and typeid=$typeid"; // $whereor.=" and typeid=$typeid"; // $where.=" and typeid=$typeid"; }*/ $sql = "select a.* from (select *,case when {$where} then 1 when {$whereor} then 2 end as neworder from #@__search where ({$wh})" . $w . ") a order by neworder"; $pv = new ListView(0); $pv->pagesize = 25; //分页条数. $pv->SetSql($sql); $pv->SetParameter('typeid', $typeid); $pv->SetParameter('keyword', $keyword); $templet = Helper_Archive::getUseTemplet('cloudsearch_index'); //获取首页使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "" . "cloudsearch.htm"; $pv->SetTemplet($templet); $pv->Display(); exit; //获取图片html function getLitPicHtml($row) { $litpic = $row['litpic']; $url = getSearchUrl($row); if (!empty($litpic)) { $litpic = getUploadFileUrl(str_replace('litpic', 'lit240', $litpic)); $out = '<li class="li_img"><a href="' . $url . '" target="_blank"><img src="' . $litpic . '" width="118" height="90" /></a></li>';
if (isset($pageno)) { $pageno = intval(preg_replace("/[^\\d]/", '', $pageno)); } //当前页 if ($tid == '7') { $sql = "select * from #@__leave where reply is null and approval='1' order by addtime desc"; } else { if ($tid == '8') { $sql = "select * from #@__leave where reply is not null and approval='1' order by addtime desc"; } else { $sql = "select * from #@__leave where typeid='{$tid}' and approval='1' order by addtime desc"; } } $pv = new ListView($typeid); $pv->listGetChannelKeywords($typeid); //根据栏目类型获取关键词.介绍,栏目名称 $pv->Fields['name'] = GetName($tid); $pv->pagesize = 30; //分页条数. $pv->SetSql($sql); //注意以下这两句与伪静态规则有关系,不能写反了. $pv->SetParameter('tid', $tid); $pv->SetTemplet(SLINETEMPLATE . "/" . $cfg_df_style . "/" . "questions/" . "list.htm"); $pv->Display(); function GetName($typeid) { global $dsql; $sql = "select shortname from #@__nav where webid='0' and isopen='1' and typeid='{$typeid}'"; $row = $dsql->GetOne($sql); return $row['shortname']; }
//其他栏目URL if (empty($dest_id)) { $dest_url = $GLOBALS['cfg_basehost'] . '/destination/'; $hotel_url = $GLOBALS['cfg_basehost'] . '/hotels/'; $raider_url = $GLOBALS['cfg_basehost'] . '/raiders/'; $photo_url = $GLOBALS['cfg_basehost'] . '/photos/'; } else { $pinyin = Helper_Archive::getDestPinyin($dest_id); $pinyin = !empty($pinyin) ? $pinyin : $dest_id; $dest_url = $GLOBALS['cfg_basehost'] . '/' . $pinyin . '/'; $hotel_url = $GLOBALS['cfg_basehost'] . '/hotels/' . $pinyin . '/'; $raider_url = $GLOBALS['cfg_basehost'] . '/raiders/' . $pinyin . '/'; $photo_url = $GLOBALS['cfg_basehost'] . '/photos/' . $pinyin . '/'; } //设置翻页参数(如果使用伪静态,则不能弄反了) $pv->SetParameter('dest_id', $dest_id); $pv->SetParameter('param1', 0); $pv->SetParameter('param2', 0); $pv->SetParameter('day', $day); $pv->SetParameter('priceid', $priceid); $pv->SetParameter('sorttype', $sorttype); $pv->SetParameter('keyword', $keyword); $pv->SetParameter('startcity', $startcity); $pv->SetParameter('attrid', $attrid); $templet = Helper_Archive::getUseTemplet('line_list'); //获取使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/lines/line_search.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit;
} $sql = "select a.* from #@__visa a left join #@__allorderlist b on (a.id=b.aid and b.typeid={$typeid} and a.webid=b.webid) where a.ishidden=0 {$where} order by case when b.displayorder is null then 9999 end,b.displayorder asc,a.modtime desc,a.addtime desc"; $seoarr = array(); //seo信息数组 $seoarr['navtitle'] = $seoarr['searchtitle'] = $navtitle . "列表"; $seoarr['typename'] = GetTypeName($typeid); $seoarr['pageno'] = !empty($pageno) ? '第' . $pageno . '页-' : ""; $pv = new ListView($typeid); $pv->pagesize = 10; //分页条数. $pv->SetSql($sql); //seo变量赋值 foreach ($seoarr as $k => $v) { $pv->Fields[$k] = $v; } $pv->SetParameter('countryid', $countryid); $pv->SetParameter('cityid', $cityid); $pv->SetParameter('visatypeid', $visatypeid); $pv->SetParameter('temppara', 0); //模板选择 $templet = Helper_Archive::getUseTemplet('visa_list'); //获取使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "visa/visa_search.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit; //搜索Url function getSearchUrl($val = null, $key = null, $exclude = null, $arr = array('countryid', 'cityid', 'visatypeid'), $url = "/visa/", $table = "") { return Helper_Archive::getUrlStatic($val, $key, $exclude, $arr, $url, $table, 0);
} $destinfo = getDestInfo($typeid, $dest_id); //目的地优化信息; $seoarr = Generateinfo(); $seoarr['channelname'] = $channelname; //栏目名称 //当前页数->title里面使用 $seoarr['pageno'] = !empty($pageno) ? '第' . $pageno . '页-' : ""; //下级目的地 $destlist = Helper_Archive::getChildDest($dest_id, $typeid); //seo变量赋值 foreach ($seoarr as $k => $v) { $pv->Fields[$k] = $v; } $jieshao = $destinfo['jieshao']; $pv->SetParameter('jieshao', $jieshao); $pv->SetParameter('dest_id', $dest_id); $pv->SetParameter('startplaceid', $startplaceid); $pv->SetParameter('carkindid', $carkindid); $pv->SetParameter('displayorder', $displayorder); $pv->SetParameter('attrid', $attrid); getTopNavDest($dest_id); //模板选择 $templet = Helper_Archive::getUseTemplet('car_list'); //获取使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "cars/" . "car_search.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); /** * 生成searchtitle,keyword,description等信息.
$where .= " and find_in_set({$dest_id},a.kindlist)"; $wherecount .= " and find_in_set({$dest_id},a.kindlist)"; } $sql = "select a.* from sline_jieban a left join sline_allorderlist b on(a.id=b.aid and b.typeid={$typeid} ) {$where} order by b.displayorder asc, a.addtime desc "; //下级目的地 $destlist = Helper_Archive::getChildDest($dest_id, $typeid); $seoinfo = JieBan::getChannelSeo($typeid); //优化信息标题 $pv = new ListView($typeid); $pv->pagesize = 16; //分页条数. $pv->SetSql($sql); //seo变量赋值 foreach ($destinfo as $k => $v) { $pv->Fields[$k] = $v; } foreach ($seoinfo as $k => $v) { $pv->Fields[$k] = $v; } $pv->Fields['typeid'] = $typeid; $pv->Fields['monthid'] = $monthid; $pv->Fields['pageno'] = $pageno; $pv->SetParameter('destid', $dest_id); $pv->SetParameter('monthid', $monthid); $pv->SetParameter('day', $day); $pv->SetParameter('attrid', $attrid); $templet = SLINETEMPLATE . "/" . $cfg_df_style . "/jieban/index.htm"; //默认模板 $pv->SetTemplet($templet); $pv->Display(); exit;
$pv->Fields['seodescription'] = !empty($destinfo['description']) ? "<meta name=\"description\" content=\"" . $destinfo['description'] . "\"/>" : ""; $pv->Fields['seotitle'] = !empty($destinfo['seotitle']) ? $destinfo['seotitle'] : $pv->Fields['seotitle']; } if (!empty($dest_id)) { $where .= " and find_in_set({$dest_id},a.kindlist)"; } if (!empty($attrid)) { $attrid_arr = explode(',', $attrid); foreach ($attrid_arr as $k => $v) { $where .= " and find_in_set({$v},a.attrid)"; } } $mianbao = getTuanMianBao($dest_id); $destlist = getTuanChildDest($dest_id); //获取上级开启了导航的目的地 getTopNavDest($dest_id); $virtual_arr = $dsql->GetOne("select sum(ifnull(virtualnum,0)) as number from #@__tuan"); $booknum = Helper_Archive::getSellNum(0, 13) + $virtual_arr['number']; $sql = "select a.* from #@__tuan a left join #@__allorderlist b on (a.id=b.aid and b.typeid={$typeid} and a.webid=b.webid) where {$where} order by ifnull(b.displayorder,9999) asc,a.addtime desc"; $pv->pagesize = 16; //分页条数. $pv->SetSql($sql); $pv->SetParameter('dest_id', $dest_id); $pv->SetParameter('status', $status); $pv->SetParameter('attrid', $attrid); $templet = Helper_Archive::getUseTemplet('tuan_index'); //获取首页使用模板 $templet = !empty($templet) ? $templet : SLINETEMPLATE . "/" . $cfg_df_style . "/" . "tuan/" . "tuan_index.htm"; $pv->SetTemplet($templet); $pv->Display(); exit;