【phpcms-v9】phpcms-v9中联动菜单实现筛选
发布:smiling 来源: PHP粉丝网 添加日期:2014-10-24 10:19:05 浏览: 评论:0
- <!--初始化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(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>//开源代码phpfensi.com
- </li>
- {if $n%5==0}<li class="bk20 hr"></li>{/if}
- {/loop}
- </ul>
- <div id="pages" class="text-c">{$pages}</div>
- {/pc}
Tags: phpcms联动菜单 phpcms菜单筛选
相关文章
- · phpcms v9中模板标签使用及联动菜单(2014-10-22)
- ·【phpcms-v9】phpcms-v9中联动菜单的调用(2014-10-24)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)