phpcms v9联动菜单实现筛选

<!--初始化init-->
{php $theurl = "index.php?m=content&c=index&a=lists&catid=$catid";}
{php $brandid = (isset($_get['brandid']) && is_numeric($_get['brandid']) ? $_get['brandid'] : '');}
{php $priceid = (isset($_get['priceid']) && is_numeric($_get['priceid']) ? $_get['priceid'] : '');}
{php $areaid = (isset($_get['areaid']) && is_numeric($_get['areaid']) ? $_get['areaid'] : '');}
{php $degree = (isset($_get['degree']) ? $_get['degree'] : '');}<!-- 读取缓存-->
{php $modelid_cache = getcache('model_field_'.$modelid,'model');} <!-- 模型缓存 -->
{php $brand_linkage = getcache(3360,'linkage'); $brand_data = $brand_linkage[data];} <!-- 品牌缓存 -->
{php $area_linkage = getcache(3379,'linkage'); $area_data = $area_linkage[data];} <!-- 区域缓存 --><!-- sql_条件-->
<?php
if($area_data[$_get[areaid]][parentid] == 0) {
$paid = 0;
} else {
$paid = $area_data[$_get[areaid]]['parentid'];
}
$areaid_arr = array();
$boroughs = $streets = '';
foreach($area_data as $k=>$r){
if($r[parentid] == 0){
$boroughs[$k] = $r['name'];
}elseif(($_get[areaid] == $r['parentid'] || $paid == $r['parentid'])){
$streets[$k] = $r['name'];
$areaid_arr[] = $k;
}
}
/**-- 排序的数组 --**/
$order_arr = array(
'finer' => array('finer'=>'desc'),
'avgsort' => array('avgsort'=>'desc'),
'reviews' => array('reviews'=>'desc'),
'enjoy' => array('enjoy'=>'desc'),
'price' => array('avgprice'=>'desc'),
'price_s' => array('avgprice'=>'asc'),
'picture' => array('pictures'=>'desc'),
'picture_s' => array('pictures'=>'asc'),
'addtime' => array('addtime'=>'desc'),
'pageviews' => array('pageviews'=>'desc'),
);
/**-- 查询的数组 --**/
$where = array();
if($catid) $where['catid'] = (int) $catid;
if($brandid) $where['brandid'] = (int) $brandid;
if($priceid) $where['priceid'] = (int) $priceid;
if($paid){
if($areaid) $where['areaid'] = (int) $areaid;
$areasql = '';
}else{
if($areaid) $areasql = ' and `areaid` in('.join(',',$areaid_arr).')';
}
function getwheresql($wheresqlarr) {
$result = $comma = '';
if(empty($wheresqlarr)) {
$result = '1';
} elseif(is_array($wheresqlarr)) {
foreach ($wheresqlarr as $key => $value) {
$result .= $comma.$key.'=\''.$value.'\'';
$comma = ' and ';
}
} else {
$result = $wheresqlarr;
}
return $result;
}
$wheresql = getwheresql($where);
$wheresql .= $areasql;
//echo $wheresql;
?>{php $data = explode("\r\n", $modelid_cache['priceid']['options']);}
{php $price_arr = array();}
<div class="col-cate">
<b>价格 :</b> {if $priceid}
<a href="{url_par("brandid=$brandid&areaid=$areaid",$theurl)}" style="color:#6633ff;">全部</a>
{else}
<font style="color:#fff; background-color:#6633ff">全部</font>
{/if}{loop $data $r}
{php $r = explode("|",trim($r))}
{php $price_arr[$r[1]] = $r[0];}
{if $priceid == $r[1]}
<font style="color:#fff; background-color:#6633ff">{$r[0]}</font>
{else}
<a href='{url_par("brandid=$brandid&priceid=$r[1]&areaid=$areaid",$theurl)}'>{$r[0]}</a>
{/if}
{/loop}
</div>{php $data = explode("\r\n", $modelid_cache['degree']['options']);}
<div class="col-cate">
<b>学历 :</b> {if $degree}
<a href="{url_par("brandid=$brandid&priceid=$priceid&areaid=$areaid",$theurl)}" style="color:#6633ff;">全部</a>
{else}
<font style="color:#fff; background-color:#6633ff">全部</font>
{/if}{loop $data $r}
{php $r = explode("|",trim($r))}
{if $degree == $r[1]}
<font style="color:#fff; background-color:#6633ff">{$r[0]}</font>
{else}
<a href='{url_par("brandid=$brandid&priceid=$priceid°ree=$r[1]&areaid=$areaid",$theurl)}'>{$r[0]}</a>
{/if}
{/loop}
</div> <div class="col-cate">
<b>品牌 :</b>
{if $brandid}
<a href="{url_par("priceid=$priceid&areaid=$areaid",$theurl)}" style="color:#6633ff;">全部</a>
{else}
<font style="color:#fff; background-color:#6633ff">全部</font>
{/if}
{loop $brand_data $r}
{if $brandid == $r[linkageid]}
<font style="color:#fff; background-color:#6633ff">{$r[name]}</font>
{else}
<a href="{url_par("brandid=$r[linkageid]&priceid=$priceid&areaid=$areaid",$theurl)}">{$r[name]}</a>
{/if}
{/loop}
</div> <div class="col-cate">
<b>商圈 :</b>
{if $_get[areaid]}
<a href="{url_par("brandid=$brandid&priceid=$priceid",$theurl)}" style="color:#6633ff;">全部</a>
{else}
<font style="color:#fff; background-color:#6633ff">全部</font>
{/if}
{loop $boroughs $key $val}
{if $_get[areaid] == $key || $paid == $key}
<font style="color:#fff; background-color:#6633ff"> {$val}</font>
{else}
<a href="{url_par("brandid=$brandid&priceid=$priceid&areaid=$key",$theurl)}">{$val}</a>
{/if}
{/loop}
</div>
{if $_get[areaid]}
<div class="col_cate_2" style="padding:8px; border:1px solid #57a3c9; background-color:#eff5f8; margin-top:4px;">
{loop $streets $key $val}
{if $_get[areaid] == $key}
<font style="color:#fff; background-color:#6633ff"> {$val}</font>
{else}
<a href="{url_par("brandid=$brandid&priceid=$priceid&areaid=$key",$theurl)}">{$val}</a>
{/if}
{/loop}
</div>
{/if} {pc:get sql="select * from v9_news where $wheresql" cache="3600" num="10" page="$page" return="data"}
<h3 style="font-size:12px; color:#ff0000; line-height:22px; text-align:right;">共找到 {php echo count($data);} 个结果</h3>
<ul class="list lh24 f14" style="margin-top:12px;">
{loop $data $r} {php $db = pc_base::load_model('hits_model'); $_r = $db->get_one(array('hitsid'=>'c-'.$modelid.'-'.$r[id])); $views = $_r[views]; }
{php $comment_tag = pc_base::load_app_class("comment_tag", "comment"); $comment_total = $comment_tag->count(array('commentid'=>'content_'.$catid.'-'.$r[id].'-'.$modelid));} <li style="background-color:#f9f9f9; border-bottom:1px solid #999999; margin-top:4px;"><span class="rt">{date('y-m-d h:i:s',$r[inputtime])}</span>·<a href="{$r[url]}" target="_blank"{title_style($r[style])}>{$r[title]}</a>
<p><span style="font-size:11px; font-family:pmingliu; color:#666666;">学历要求：{$r[degree]}</span></p>
<p><span style="font-size:11px; font-family:pmingliu; color:#666666;">价格区间：<font style="font-family:verdana, arial, helvetica, sans-serif; font-size:10px;">[{$price_arr[$r[priceid]]}]</font> 品牌：<span {if $r[brandid] == $brandid} style="color:#f00;"{/if}>[{$brand_data[$r[brandid]][name]}] </span> 区域：[{$area_data[$r[areaid]][name]}] 点击:{$views} 评论:{if $comment_total}{$comment_total}{else}0{/if}</span></p>
</li>
{if $n%5==0}<li class="bk20 hr"></li>{/if}
{/loop}
</ul>
<div id="pages" class="text-c">{$pages}</div>
{/pc}