織夢全網最新聯動篩選功能的實現(單選和多選)可顯示分類的文章數量
之前寫過這篇文章《織夢DEDECMS5.7實現聯動篩選(支持多條件多級選項)》下面二次開發(fā)織夢聯動篩選是之前升級版,修復手機端無法加載_m.htm列表模板BUG:

// 字符過濾函數
function wwwcms_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;
}
// 麥站 mengdiqiu.com.cn
// 載入自定義表單(用于發(fā)布)
// @access public
// @param string $fieldset 字段列表
// @param string $loadtype 載入類型
// @return string
function AddFilter($channelid, $type=1, $fieldsnamef, $defaulttid, $loadtype='autofield')
{
global $tid,$dsql,$id;
$tid = $defaulttid ? $defaulttid : $tid;
if ($id!="")
{
$tidsq = $dsql->GetOne(" Select typeid From `# @__archives` where id='$id' ");
$tid = $tidsq["typeid"];
}
$nofilter = (isset($_REQUEST['TotalResult']) ? "&TotalResult=".$_REQUEST['TotalResult'] : '').(isset($_REQUEST['PageNo']) ? "&PageNo=".$_REQUEST['PageNo'] : '');
$filterarr = wwwcms_filter(stripos($_SERVER['REQUEST_URI'], "list.php?tid=") ? str_replace($nofilter, '', $_SERVER['REQUEST_URI']) : $GLOBALS['cfg_cmsurl']."/plus/list.php?tid=".$tid);
$cInfos = $dsql->GetOne(" Select * From `# @__channeltype` where id='$channelid' ");
$fieldset=$cInfos['fieldset'];
$dtp = new DedeTagParse();
$dtp->SetNameSpace('field','<','>');
$dtp->LoadSource($fieldset);
$dede_addonfields = '';
if(is_array($dtp->CTags))
{
foreach($dtp->CTags as $tid=>$ctag)
{
$fieldsname = $fieldsnamef ? explode(",", $fieldsnamef) : explode(",", $ctag->GetName());
if(($loadtype!='autofield' || ($loadtype=='autofield' && $ctag->GetAtt('autofield')==1)) && in_array($ctag->GetName(), $fieldsname) )
{
$href1 = explode($ctag->GetName().'=', $filterarr);
$href2 = explode('&', $href1[1]);
$fields_value = $href2[0];
$dede_addonfields .= '<div class="scv-shaixuan"><b>'.$ctag->GetAtt('itemname').':</b>';
switch ($type) {
case 1:
$lola = $ctag->GetName();
$dederow = $dsql->GetOne("SELECT count($lola) FROM # @__addonarticle WHERE $lola");
$dederowz = $dederow["count($lola)"];
$dede_addonfields .= (preg_match("/&".$ctag->GetName()."=/is",$filterarr,$regm) ? '<a title="全部" href="'.str_replace("&".$ctag->GetName()."=".$fields_value,"",$filterarr).'">全部('.$dederowz.')</a>' : '<span>全部('.$dederowz.')</span>').' ';
$addonfields_items = explode(",",$ctag->GetAtt('default'));
for ($i=0; $i<count($addonfields_items); $i++)
{
$lola = $ctag->GetName();
$lolb = $addonfields_items[$i];
$dederow = $dsql->GetOne("SELECT count(*) FROM # @__addonarticle WHERE $lola='$lolb'");
$dederows = $dederow["count(*)"];
$href = stripos($filterarr,$ctag->GetName().'=') ? str_replace("=".$fields_value,"=".urlencode($addonfields_items[$i]),$filterarr) : $filterarr.'&'.$ctag->GetName().'='.urlencode($addonfields_items[$i]);//echo $href;
$dede_addonfields .= ($fields_value!=urlencode($addonfields_items[$i]) ? '<a title="'.$addonfields_items[$i].'" href="'.$href.'">'.$addonfields_items[$i].'(<span>'.$dederows.'</span>)</a>' : '<span>'.$addonfields_items[$i].'('.$dederows.')</span>')." ";
}
$dede_addonfields .= '</div>';
break;
case 2:
$dede_addonfields .= '<select name="filter"'.$ctag->GetName().' onchange="window.location=this.options[this.selectedIndex].value">
'.'<option value="'.str_replace("&".$ctag->GetName()."=".$fields_value,"",$filterarr).'">全部</option>';
$addonfields_items = explode(",",$ctag->GetAtt('default'));
for ($i=0; $i<count($addonfields_items); $i++)
{
$href = stripos($filterarr,$ctag->GetName().'=') ? str_replace("=".$fields_value,"=".urlencode($addonfields_items[$i]),$filterarr) : $filterarr.'&'.$ctag->GetName().'='.urlencode($addonfields_items[$i]);
$dede_addonfields .= '<option value="'.$href.'"'.($fields_value==urlencode($addonfields_items[$i]) ? ' selected="selected"' : '').'>'.$addonfields_items[$i].'</option>
';
}
$dede_addonfields .= '</select><br/>
';
break;
}
}
}
}
echo $dede_addonfields;
}
|

if($key=="goodstype" || $key=="goodscolor" ){ //你的自定義字段名
$count=0;
$nowsql ='';
$var=explode(",",wwwcms_filter(iconv("UTF-8", "gb2312", $value))); //iconv是轉碼的意思,如果你url傳進來的參數是中文,就需要轉碼
if(!empty($var)){
foreach($var as $value){
if($count==0){
$filtersql.="and ($addtable.".wwwcms_filter($key)." like '%".$value."%'";
$count++;
}else{
$filtersql.="or $addtable.".wwwcms_filter($key)." like '%".$value."%'";
}
}
$filtersql.=")";
}
}else{
$filtersql .= ($key!="tid" && $key!="TotalResult" && $key!="PageNo") ? " AND $addtable.".wwwcms_filter($key)." = ".wwwcms_filter(iconv("UTF-8", "gb2312", $value))."" : ''; //如果傳遞的值是中文,則需要轉碼
}
|
上一篇:首頁調用自定義表單內容方法
欄 目:dedecms
下一篇:織夢文章屬性增加推薦特薦圖標
本文標題:織夢全網最新聯動篩選功能的實現(單選和多選)可顯示分類的文章數量
本文地址:http://mengdiqiu.com.cn/a1/dedecms/13828.html
您可能感興趣的文章
- 08-05Dedecms文件目錄結構解說(能知道織夢每個文件有什么用)
- 08-05織夢DedeCMS獲取當前欄目文章數量
- 08-05織夢模板如何添加和調用自定義字段的方法
- 08-05織夢DedeCMS調用顯示discuz里面主題的方法
- 08-05限制織夢會員每天投稿數量方法
- 08-05常用的織夢dedecms安全設置集合整理
- 08-05織夢教程:后臺編輯器添加中文字體方法
- 08-05織夢修改文章排序到第一位如何解決?
- 08-05dede副欄目調用支持arclist標簽
- 08-05織夢教程:手把手教你讓dedecms禁止發(fā)布重復文章