从来没见过这么漂亮的女律师，做你的当事人一定会很幸福。学会坚强，做一只沙漠中永不哭泣的骆驼！
假如网站中,有一个价格字段trueprice,我希望根据价格从小到大,或从大到小进行点击筛选，或按热门,最新商品进行排序,效果图如下
列表模板上增加排序,myorder=hot注意,其中增加了一个虚拟字段myorder,这个字段后台并没有添加.他只是一个排序的标志符,需要最后排除掉.
另外,模板上用到了{dede:php}标签,需要在后台系统设置.系统基本参数,其它设置中,去掉对php模板标签的限制.
模板如下
<a class="ib padding-right" rel="nofollow noopener noreferrer" 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" rel="nofollow noopener noreferrer" 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" rel="nofollow noopener noreferrer" 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"rel="nofollow noopener noreferrer" 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("<",">","","","","","","",""),
$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 rel="nofollow noopener noreferrer" 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 rel="nofollow noopener noreferrer" 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 rel="nofollow noopener noreferrer" 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 rel="nofollow noopener noreferrer" href='".$purl."PageNo=$prepagenum".$pageaddurl."'>".$uaprevious."</a></li>\r\n";
$indexpage="<li><a rel="nofollow noopener noreferrer" 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 rel="nofollow noopener noreferrer" href='".$purl."PageNo=$nextpagenum".$pageaddurl."'>".$uanext."</a></li>\r\n";
$endpage="<li><a rel="nofollow noopener noreferrer" 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 rel="nofollow noopener noreferrer" 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;
}
|
本文织梦列表页点击按价格按评分按更新按点击排序进行筛选方法到此结束。只要努力，你就能成为你想成为的人。小编再次感谢大家对我们的支持！