【phpcms-v9】phpcms-v9中聯動菜單實現篩選

2024-09-10 07:15:54

字體：大中小

來源：轉載

供稿：網友

{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];}       



<?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(emptyempty($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>//開源代碼Vevb.com

    </li>

    {if $n%5==0}<li class="bk20 hr"></li>{/if}

{/loop}

        </ul>

        <div id="pages" class="text-c">{$pages}</div>

{/pc}