91豆麻精品91久久久久久,中文在线资源,国产精品女视频,yw.139尤物在线精品视频

?
  歡迎訪問全國企業網站設計NO.1網站開發商平臺 付款方式
主頁 > 網站建設 > 建站知識 > 織夢列表頁點擊按價格按評分按更新按點擊排序

織夢列表頁點擊按價格按評分按更新按點擊排序

POST TIME:2020-10-09

假如網站中,有一個價格字段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;
    }

? 主站蜘蛛池模板： 贵港市| 金秀| 谷城县| 故城县| 耒阳市| 鹿邑县| 永泰县| 水富县| 方城县| 金寨县| 冕宁县| 祁阳县| 红桥区| 雷州市| 自贡市| 绍兴市| 卢氏县| 东港市| 阿鲁科尔沁旗| 普安县| 大足县| 安图县| 永寿县| 绥滨县| 迁西县| 汝南县| 克什克腾旗| 大田县| 平湖市| 陆丰市| 永昌县| 舟山市| 晋中市| 沙河市| 白城市| 建宁县| 宜川县| 梁平县| 姜堰市| 镇宁| 门头沟区|