您现在的位置是:首页 > CMS程序 > 织梦列表页点击按价格按评分按更新按点击排序进行筛选方法

织梦列表页点击按价格按评分按更新按点击排序进行筛选方法

时间:2020-06-08 16:35:40  来源:www.vpskp.com  阅读次数: 我要评论

阿里云服务器 腾讯云服务器 习梦云:高防云服务器 ZJI:香港日本美国独服
LOCVPS服务周到 HostKvm低调KVM 傲游主机:优质VPS 80VPS:老牌VPS主机
搬瓦工:CN2 GIA线路 CloudCone:性价比高 Vultr:按小时计费VPS VirMach:超级便宜
JustMySocks科学上网 CloudRaft大硬盘VPS 洛杉矶QN机房官方VPS 恒创:香港CN2服务器

假如网站中,有一个价格字段trueprice,我希望根据价格从小到大,或从大到小进行点击筛选,或按热门,最新商品进行排序,效果图如下 

织梦列表页点击按价格按评分按更新按点击排序进行筛选方法

列表模板上增加排序,myorder=hot注意,其中增加了一个虚拟字段myorder,这个字段后台并没有添加.他只是一个排序的标志符,需要最后排除掉. 

另外,模板上用到了{dede:php}标签,需要在后台系统设置.系统基本参数,其它设置中,去掉对php模板标签的限制. 

模板如下

 <a class="ib padding-right"  href="/plus/list.php?tid={dede:field.typeid/}&myorder=hot">{dede:php}if($_GET['myorder']=='hot'){echo '<span>最热</span>';}else{echo '最热';}{/dede:php}</a> <a class="ib padding-right" href="/plus/list.php?tid={dede:field.typeid/}&myorder=new">{dede:php}if($_GET['myorder']=='new'){echo '<span>最新</span>';}else{echo '最新';}{/dede:php}</a> <a class="ib padding-right" href="/plus/list.php?tid={dede:field.typeid/}&myorder=price_high">{dede:php}if($_GET['myorder']=='price_high'){echo '<span>价高</span>';}else{echo '价高';}{/dede:php}</a><a class="ib padding-right"href="/plus/list.php?tid={dede:field.typeid/}&myorder=price_low">{dede:php}if($_GET['myorder']=='price_low'){echo '<span>价低</span>';}else{echo '价低';}{/dede:php}</a>

首先,在自定义函数中/include/extend.func.php增加非法过滤函数

/*字符过滤函数*/function snail_filter($str,$stype="inject") {    if ($stype=="inject")  {        $str = str_replace(               array( "select", "insert", "update", "delete", "alter", "cas", "union", "into", "load_file", "outfile", "create", "join", "where", "like", "drop", "modify", "rename", "'", "/*", "*", "../", "./"),   array("","","","","","","","","","","","","","","","","","","","","",""),   $str);    } else if ($stype=="xss") {        $farr = array("//s+/" ,                      "/<(//?)(script|META|STYLE|HTML|HEAD|BODY|STYLE |i?frame|b|strong|style|html|img|P|o:p|iframe|u|em|strike|BR|div|a|TABLE|TBODY|object|tr|td|st1:chsdate|FONT|span|MARQUEE|body|title|/r/n|link|meta|/?|/%)([^>]*?)>/isU",           "/(<[^>]*)on[a-zA-Z]+/s*=([^>]*>)/isU",          );        $tarr = array(" ",                      "",          "//1//2",          );         $str = preg_replace($farr, $tarr, $str);        $str = str_replace(               array( "<", ">", "'", "/"", ";", "/*", "*", "../", "./"),   array("&lt;","&gt;","","","","","","",""),   $str);    }    return $str;}

然后,在include/arc.listview.class.php里面增加排序判断及分页的定义,并排除myorder字段

一,修改CountRecord(),在第二行的下面 

在if(empty(cfgneedtypeid2))cfgneedtypeid2))cfg_need_typeid2 = ‘N’的下面

增加

 //新增,多条件筛选 ,获得附加表的相关信息        $addtable  = $this->ChannelUnit->ChannelInfos['addtable'];        if($addtable!="")        {            $addJoin = " LEFT JOIN `$addtable` ON arc.id = ".$addtable.'.aid ';            $addField = '';            $fields = explode(',',$this->ChannelUnit->ChannelInfos['listfields']);            foreach($fields as $k=>$v)            {                $nfields[$v] = $k;            }            if(is_array($this->ChannelUnit->ChannelFields) && !empty($this->ChannelUnit->ChannelFields))            {                foreach($this->ChannelUnit->ChannelFields as $k=>$arr)                {                    if(isset($nfields[$k]))                    {                        if(!empty($arr['rename'])) {                            $addField .= ','.$addtable.'.'.$k.' as '.$arr['rename'];                        }                        else {                            $addField .= ','.$addtable.'.'.$k;                        }                    }                }            }            if (isset($_REQUEST['tid'])){                $myget=$_GET;                unset($myget['myorder']);//删除一个字段                 //删除数组中的个别元素,活动状态,进行中,刚结束等,这些值是根据结束时间动态判断的,所以,数据库中并不存在,需要过滤掉这个sql查询条件                foreach($_GET as $key => $value) {                    //过滤掉不在$addtable表格中的字段,本次不负责处理                    //print_r($_GET);exit;                    $filtersql .= ($key!="q"&$key!="tid" && $key!="TotalResult" && $key!="PageNo") ? " AND $addtable.".snail_filter($key)." = '".snail_filter(urldecode($value))."'" : '';                }            }        }        else        {            $addField = '';            $addJoin = '';        }        //新增结束        //统计数据库记录

二、继续找到

$cquery = "SELECT COUNT(*) AS dd FROMdede_arctinyarc WHERE ".$this->addSql; 

修改为

$cquery = "SELECT COUNT(*) AS dd FROM `dede_arctiny` arc $addJoin WHERE ".$this->addSql.$filtersql;


三,替换函数function GetArcList()为全新的

function GetArcList($limitstart=0,$row=10,$col=1,$titlelen=30,$infolen=250,    $imgwidth=120,$imgheight=90,$listtype="all",$orderby="default",$innertext="",$tablewidth="100",$ismake=1,$orderWay='desc')    {        global $cfg_list_son;        $typeid=$this->TypeID;        if($row=='') $row = 10;        if($limitstart=='') $limitstart = 0;        if($titlelen=='') $titlelen = 100;        if($infolen=='') $infolen = 250;        if($imgwidth=='') $imgwidth = 120;        if($imgheight=='') $imgheight = 120;        if($listtype=='') $listtype = 'all';          if($orderWay=='') $orderWay = 'desc';        if($orderby=='') {            $orderby='default';        }        else {            $orderby=strtolower($orderby);        }        $tablewidth = str_replace('%','',$tablewidth);        if($tablewidth=='') $tablewidth=100;        if($col=='') $col=1;        $colWidth = ceil(100/$col);        $tablewidth = $tablewidth.'%';        $colWidth = $colWidth.'%';        $innertext = trim($innertext);        if($innertext=='') {            $innertext = GetSysTemplets('list_fulllist.htm');        }        //排序方式        $ordersql = '';        if($orderby=="senddate" || $orderby=="id") {            $ordersql=" order by arc.id $orderWay";        }        else if($orderby=="hot" || $orderby=="click") {            $ordersql = " order by arc.click $orderWay";        }        else if($orderby=="lastpost") {            $ordersql = "  order by arc.lastpost $orderWay";        }else if($orderby=="weight") {             $ordersql = "  order by arc.weight $orderWay";       }        else {            $ordersql=" order by arc.sortrank $orderWay";        }        //新增综合排序:默认 最热 最新 价高 价低         $addtable  = $this->ChannelUnit->ChannelInfos['addtable'];        if($_GET['myorder']=='默认'){                    $orderby='sortrank';                    $ordersql = "  order by arc.sortrank $orderWay";                }elseif($_GET['myorder']=='hot'){                    $orderby='hot';                   $ordersql = " order by arc.click $orderWay";                }                elseif($_GET['myorder']=='new'){                    $orderby='id';                    $ordersql = " order by arc.id $orderWay";                }                elseif($_GET['myorder']=='price_high'){                    $orderby='price_high';                    $ordersql = " order by ".$addtable.".price ".$orderWay;                }                elseif($_GET['myorder']=='price_low'){                    $orderby='price_low';                    $ordersql = " order by ".$addtable.".price asc";                }                 elseif($_GET['myorder']=='mian_high'){                    $orderby='mian_high';                    $ordersql = " order by ".$addtable.".mian ".$orderWay;                }                elseif($_GET['myorder']=='mian_low'){                    $orderby='mian_low';                    $ordersql = " order by ".$addtable.".mian asc";                }               else{                    $ordersql=" order by arc.id $orderWay";                }        //多条件查询新增,获得附加表的相关信息/        ////获得一个单列的文档列表继续        if($addtable!="")        {            $addJoin = " left join `$addtable` on arc.id = ".$addtable.'.aid ';            $addField = '';            $fields = explode(',',$this->ChannelUnit->ChannelInfos['listfields']);            foreach($fields as $k=>$v)            {                $nfields[$v] = $k;            }            if(is_array($this->ChannelUnit->ChannelFields) && !empty($this->ChannelUnit->ChannelFields))            {                foreach($this->ChannelUnit->ChannelFields as $k=>$arr)                {                    if(isset($nfields[$k]))                    {                        if(!empty($arr['rename'])) {                            $addField .= ','.$addtable.'.'.$k.' as '.$arr['rename'];                        }                        else {                            $addField .= ','.$addtable.'.'.$k;                        }                    }                }            }            if (isset($_REQUEST['tid'])){                $myget=$_GET;                unset($myget['myorder']);//删除一个字段            foreach($myget as $key => $value) {                    $mywhere=" AND $addtable.".snail_filter($key)." = '".snail_filter(urldecode($value))."'";                }                $filtersql .= ($key!="tid" && $key!="TotalResult" && $key!="PageNo") ? $mywhere : '';            }        }        else        {            $addField = '';            $addJoin = '';        }//print_r($addField);exit;//取出所有自定义字段      织梦6久阁模板网 //print_r($addJoin);exit;//left join `dede_addonarticle` on arc.id = dede_addonarticle.aid        //如果不用默认的sortrank或id排序,使用联合查询(数据量大时非常缓慢)        if(ereg('hot|click|lastpost|weight',$orderby))        {            $query = "Select arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,           tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath           $addField           from `dede_archives` arc           left join `dede_arctype` tp on arc.typeid=tp.id           $addJoin           WHERE {$this->addSql} $filtersql $ordersql LIMIT $limitstart,$row";        }        //普通情况先从arctiny表查出ID,然后按ID查询(速度非常快)        else        {            $t1 = ExecTime();            $ids = array();            $query = "SELECT id FROM `dede_arctiny` arc $addJoin WHERE {$this->addSql} $filtersql $ordersql LIMIT $limitstart,$row ";            //print_r($query);exit;//SELECT id FROM `dede_arctiny` arc left join `dede_addonarticle` on arc.id = dede_addonarticle.aid WHERE arc.arcrank > -1 And ( arc.typeid = '1' OR CONCAT(',', arc.typeid2, ',') like '%,1,%' ) AND dede_addonarticle.mystate = '即将开始' AND dede_addonarticle.mytype = '投资返现' order by arc.id desc LIMIT 0,16            $this->dsql->SetQuery($query);            $this->dsql->Execute();            //die(mysql_error());            while($arr=$this->dsql->GetArray())            {                $ids[] = $arr['id'];            }            //print_r($ids);exit;            $idstr = join(',',$ids);            //print_r($idstr);exit;//13,12,11,10,9,5,4 文章id串            if($idstr=='')            {                return '';            }            else            {                $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,                    tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath                    $addField                    from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id                    $addJoin                    where arc.id in($idstr) $ordersql ";            }            $t2 = ExecTime();            //echo $t2-$t1;        }        $this->dsql->SetQuery($query);        //print_r($query);exit;        //die(mysql_error());        $this->dsql->Execute('al');        $t2 = ExecTime();        //echo $t2-$t1;exit;        $artlist = '';        $this->dtp2->LoadSource($innertext);        $GLOBALS['autoindex'] = 0;        for($i=0;$i<$row;$i++)            //print_r($row);exit;调用条数20        {            if($col>1)            {                $artlist .= "<div>/r/n";            }            for($j=0;$j<$col;$j++)            {                if($row = $this->dsql->GetArray("al"))                    //print_r($row);exit;                {                    $GLOBALS['autoindex']++;                    $ids[$row['id']] = $row['id'];                    //处理一些特殊字段                    $row['infos'] = cn_substr($row['description'],$infolen);                    $row['id'] =  $row['id'];                    if($row['corank'] > 0 && $row['arcrank']==0)                    {                        $row['arcrank'] = $row['corank'];                    }                    $row['filename'] = $row['arcurl'] = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],                    $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);                    $row['typeurl'] = GetTypeUrl($row['typeid'],MfTypedir($row['typedir']),$row['isdefault'],$row['defaultname'],                    $row['ispart'],$row['namerule2'],$row['moresite'],$row['siteurl'],$row['sitepath']);                    if($row['litpic'] == '-' || $row['litpic'] == '')                    {                        $row['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';                    }                    if(!eregi("^http://",$row['litpic']) && $GLOBALS['cfg_multi_site'] == 'Y')                    {                        $row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];                    }                    $row['picname'] = $row['litpic'];                    $row['stime'] = GetDateMK($row['pubdate']);                    $row['typelink'] = "<a href='".$row['typeurl']."'>".$row['typename']."</a>";                    $row['image'] = "<img src='".$row['picname']."' border='0' width='$imgwidth' height='$imgheight' alt='".ereg_replace("['><]","",$row['title'])."'>";                    $row['imglink'] = "<a href='".$row['filename']."'>".$row['image']."</a>";                    $row['fulltitle'] = $row['title'];                    $row['title'] = cn_substr($row['title'],$titlelen);                    if($row['color']!='')                    {                        $row['title'] = "<font color='".$row['color']."'>".$row['title']."</font>";                    }                    if(ereg('c',$row['flag']))                    {                        $row['title'] = "".$row['title']."";                    }                    $row['textlink'] = "<a href='".$row['filename']."'>".$row['title']."</a>";                    $row['plusurl'] = $row['phpurl'] = $GLOBALS['cfg_phpurl'];                    $row['memberurl'] = $GLOBALS['cfg_memberurl'];                    $row['templeturl'] = $GLOBALS['cfg_templeturl'];                    //编译附加表里的数据                    foreach($row as $k=>$v)                    {                        $row[strtolower($k)] = $v;                    }                    foreach($this->ChannelUnit->ChannelFields as $k=>$arr)                    {                        if(isset($row[$k]))                        {                            $row[$k] = $this->ChannelUnit->MakeField($k,$row[$k]);                        }                    }                    if(is_array($this->dtp2->CTags))                    {                        foreach($this->dtp2->CTags as $k=>$ctag)                        {                            //print_r($this->dtp2->CTags);exit;所有字段名                            if($ctag->GetName()=='array')                            {                                //传递整个数组,在runphp模式中有特殊作用                                $this->dtp2->Assign($k,$row);                            }                            else                            {                                if(isset($row[$ctag->GetName()]))                                {                                    $this->dtp2->Assign($k,$row[$ctag->GetName()]);                                }                                else                                {                                    $this->dtp2->Assign($k,'');                                }                            }                        }                    }if($row['myendtime']!=''){                    if($row['myendtime']<time()){//已结束的活动                    $artlist2 .= $this->dtp2->GetResult();                }else{                    $artlist1 .= $this->dtp2->GetResult();                    }                    $artlist=$artlist1.$artlist2;                    }else{                    $artlist .= $this->dtp2->GetResult();                    }                    //$i2=$i2+1;                    //print_r($i2);                }//if hasRow//exit;            }//Loop Col//print_r($col);exit;            if($col>1)            {                $i += $col - 1;                $artlist .= "  </div>/r/n";            }            $row2[] = $row;        }//Loop Line//print_r($row2);exit;        $t3 = ExecTime();        //echo ($t3-$t2);        $this->dsql->FreeResult('al');        //die(mysql_error());        return $artlist;    }


四,动态分页函数整体替换为

//获取动态的分页列表    function GetPageListDM($list_len,$listitem="index,end,pre,next,pageno",$pagelang)    {    /*****************************************************************************************/                     if($pagelang=='cn'){                          $uahome="首页";                          $uaprevious="?";                          $uanext="?";                          $ualastpage="末页";                          $uapage="页";                          $uatotal="共";                          $uarecords="条记录";                       }else{                          $uahome=" Home ";                          $uaprevious=" Previous ";                          $uanext=" Next ";                          $ualastpage=" Last Page ";                          $uapage=" Page ";                          $uatotal=" Total ";                          $uarecords=" Records. ";                        }        global $cfg_rewrite;        $prepage = $nextpage = '';        $prepagenum = $this->PageNo-1;        $nextpagenum = $this->PageNo+1;        if($list_len=='' || ereg("[^0-9]",$list_len))        {            $list_len=3;        }        $totalpage = ceil($this->TotalResult/$this->PageSize);        if($totalpage<=1 && $this->TotalResult>0)        {            return "</ul><ul class=/"margin pagination border-main pageinfo/"><li><a >".$uatotal." 1 ".$uapage."/".$this->TotalResult."".$uarecords."</a></li>/r/n";        }        if($this->TotalResult == 0)        {            return "</ul><ul class=/"margin pagination border-main pageinfo/"><li><a >".$uatotal." 0 ".$uapage."/".$this->TotalResult."".$uarecords."</a></li>/r/n";        }        $maininfo = "</ul><ul class=/"margin pagination border-main pageinfo/"><li><a >".$uatotal." <strong>{$totalpage}</strong>".$uapage."<strong>".$this->TotalResult."</strong>".$uarecords."</a></li>/r/n";        $purl = $this->GetCurUrl();        if($cfg_rewrite == 'Y')        {            $nowurls = ereg_replace("/-", ".php?", $purl);            $nowurls = explode("?", $nowurls);            $purl = $nowurls[0];        }        $geturl = "tid=".$this->TypeID."&TotalResult=".$this->TotalResult."&";        $purl .= '?'.$geturl;        $optionlist = '';        //$hidenform = "<input type='hidden' name='tid' value='".$this->TypeID."'>/r/n";        //$hidenform .= "<input type='hidden' name='TotalResult' value='".$this->TotalResult."'>/r/n";//获取筛选参数        foreach($_GET as $key => $value) {            $pageaddurl .= ($key!="tid" && $key!="TotalResult" && $key!="PageNo") ? "&".snail_filter($key)."=".snail_filter($value) : '';        }        //获得?和?的链接        if($this->PageNo != 1)         {            $prepage.="<li><a href='".$purl."PageNo=$prepagenum".$pageaddurl."'>".$uaprevious."</a></li>/r/n";            $indexpage="<li><a href='".$purl."PageNo=1".$pageaddurl."'>".$uahome."</a></li>/r/n";        }        else        {            $indexpage="<li><a>".$uahome."</a></li>/r/n";        }        if($this->PageNo!=$totalpage && $totalpage>1)        {            $nextpage.="<li><a href='".$purl."PageNo=$nextpagenum".$pageaddurl."'>".$uanext."</a></li>/r/n";            $endpage="<li><a href='".$purl."PageNo=$totalpage".$pageaddurl."'>".$ualastpage."</a></li>/r/n";        }        else        {            $endpage="<li><a>".$ualastpage."</a></li>/r/n";        }        //获得数字链接        $listdd="";        $total_list = $list_len * 2 + 1;        if($this->PageNo >= $total_list)        {            $j = $this->PageNo-$list_len;            $total_list = $this->PageNo+$list_len;            if($total_list>$totalpage)            {                $total_list=$totalpage;            }        }        else        {            $j=1;            if($total_list>$totalpage)            {                $total_list=$totalpage;            }        }        for($j;$j<=$total_list;$j++)        {            if($j==$this->PageNo)            {                $listdd.= "<li class=/"active pagenum/"><a>$j</a></li>/r/n";            }            else            {                $listdd.="<li class=/"pagenum/"><a href='".$purl."PageNo=$j".$pageaddurl."'>".$j."</a></li>/r/n";            }        }        $plist = '';        if(eregi('index',$listitem)) $plist .= $indexpage;        if(eregi('pre',$listitem)) $plist .= $prepage;        if(eregi('pageno',$listitem)) $plist .= $listdd;        if(eregi('next',$listitem)) $plist .= $nextpage;        if(eregi('end',$listitem)) $plist .= $endpage;        if(eregi('option',$listitem)) $plist .= $optionlist;        if(eregi('info',$listitem)) $plist .= $maininfo;        if($cfg_rewrite == 'Y')        {            $plist = str_replace('.php?tid=', '-', $plist);            $plist = str_replace('&TotalResult=', '-', $plist);            $plist = preg_replace("/&PageNo=(/d+)/i",'-//1.html',$plist);        }        return $plist;    }


搬瓦工:CN2 GIA线路 CloudCone:性价比高 Vultr:按小时计费VPS VirMach:超级便宜
JustMySocks科学上网 CloudRaft大硬盘VPS 洛杉矶QN机房官方VPS 恒创:香港CN2服务器
留言与评论(共有 0 条评论)
   
验证码: