Пример #1
0
    $ar = explode('_', $dayid);
    $before = $ar[0];
    $after = $ar[1];
    $w = " and (day>='{$before}' and day<='{$after}')";
    $where .= $w;
    $wherecount .= $w;
}
//如果选择目的地
if (!empty($dest_id)) {
    $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;