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