dedecms列表页标签筛选联动筛选查询

2020年4月2日 14:03   作者：网站管理员 分类：站长笔记 阅读(566)

前言

dedecms是一款功能非常强大的开源网站系统，随着越来越多的人在使用它，它的功能也被开发的越来越完善，今天就跟大家来聊一聊我是如何通过dedecms来实现列表页标签筛选联动筛选查询功能的。

此功能主要使用dede自定义字段来完成，并且需要在禁用模板PHP标签，删除参数里的PHP后保存即可。后台系统-系统基本参数-其它选项-模板引擎禁用标签：php

演示站点 http://www.imyx.net/jiage/index.html

效果预览

dedecms列表页标签筛选联动筛选查询-大江博客

步骤

后台发布文章时通过自定义字段的选择来归类文章类别，前台列表通过调用自定义字段来实现标签筛选联动筛选查询

涉及改动文件

include/arc.listview.class.php

include/extend.func.php

arc.listview.class.php文件在

if(empty($cfg_need_typeid2)) $cfg_need_typeid2 = 'N';

下添加如下代码（因人而异）：

//dedecms筛选 开始
		//获得附加表的相关信息
		$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']))
			{
				$keyarr = array();
				$filtersql = "";
				global $cfg_rewritea;
				if($cfg_rewritea == 'Y')
				{
					$filterparms = getFilterParms($_REQUEST['tid']);
					$new_filter = array();
					foreach ($filterparms as $key=>$value)
					{
						$new_filter[$key] = $key;
					}
					$filters = (isset($_REQUEST['filter']) && $_REQUEST['filter']!="") ? $_REQUEST['filter'] : "";
					$filter_arr = array();
					if ($filters!="")
					{
						preg_match_all('/[A-Za-z]+_\d+/i', $filters, $filters_arr);
						$filter_arr = $filters_arr[0];
					}
					$keyarr1 = array();
					foreach ($filter_arr as $value)
					{
						$keyarr1 = explode("_",$value);
						$name_key = $new_filter[$keyarr1[0]];
						array_splice($keyarr1,0,1);
						$now_arr = array();
						foreach ($keyarr1 as $k => $v)
						{
							$now_arr = $filterparms[$name_key];
							$filtersql .= " AND find_in_set('".(isset($now_arr[$v]) ? $now_arr[$v] : "")."', ".$addtable.".".$name_key.")";
						}
					}
				}
				else
				{
					foreach($_GET as $key => $value) {
						if ($key!="tid" && $key!="TotalResult" && $key!="PageNo") {
							$keyarr = explode("|", $value);
							foreach ($keyarr as $k => $v)
							{
								$filtersql .= " AND find_in_set('".string_filter(urldecode($v))."', ".$addtable.".".string_filter($key).")";
							}
						}
					}
				}
			}
		}
		else
		{
			$addField = '';
			$addJoin = '';
		}
		//dedecms筛选 结束

extend.func.php文件在最下面添加如下代码

/**
 *  字符过滤函数(用于安全)
 *
 * @access    public
 * @param     string  $str  字符
 * @param     string  $stype  类型
 * @return    string
 */
function string_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;
}

/**
 *  筛选字段输出(用于发布)
 *
 * @access    public
 * @param     string  $channelid	模型id号
 * @param     string  $type		  	输出类型
 * @param     string  $fieldsnamef	字段名称
 * @param     string  $defaulttid	指定栏目id
 * @return    string
 */
 
function AddFilter($channelid, $type=1, $fieldsnamef, $defaulttid, $loadtype='autofield')
{
	global $dsql,$tid,$id,$cfg_cmspath,$cfg_rewritea;
	$tid = $defaulttid ? $defaulttid : $tid;
	if ($id!="")
	{
		$tidsq = $dsql->GetOne(" Select typeid From `#@__archives` where id='$id' ");
		$tid = $tidsq["typeid"];
	}
	$plist = $_SERVER['HTTP_X_REWRITE_URL'] ? string_filter($_SERVER['HTTP_X_REWRITE_URL']) : string_filter($_SERVER['REQUEST_URI']);
	if($cfg_rewritea == 'Y')
	{
		$typedirsq = $dsql->GetOne(" Select typedir From `#@__arctype` where id='$tid' ");
		$typedir = $typedirsq["typedir"];
		$typedir = preg_replace('/{cmspath}/', '', $typedir);
		$plist = stripos($plist, "makehtml_list_action.php") ? $cfg_cmspath.$typedir.'/' : $plist;
		$filterarr = string_filter(stripos($plist, ".html") ? str_replace(".html", "", $plist) : $cfg_cmspath.$typedir.'/');
	}
	else
	{
		$nofilter = (isset($_REQUEST['TotalResult']) ? "&TotalResult=".$_REQUEST['TotalResult'] : '').(isset($_REQUEST['PageNo']) ? "&PageNo=".$_REQUEST['PageNo'] : '');
		$filterarr = string_filter(stripos($plist, "list.php?tid=") ? str_replace($nofilter, '', $plist) : $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))
    {
		$all_item = array();
		foreach($dtp->CTags as $tida=>$ctag)
        {
			$field_name = $ctag->GetName();
			$fieldsname = $fieldsnamef ? explode(",", $fieldsnamef) : explode(",", $field_name);
			if(($loadtype!='autofield' || ($loadtype=='autofield' && $ctag->GetAtt('autofield')==1)) && in_array($field_name, $fieldsname) )
			{
				$all_item[] = $field_name;
			}
		}
		foreach($dtp->CTags as $tida=>$ctag)
        {
            $field_name = $ctag->GetName();
			$fieldsname = $fieldsnamef ? explode(",", $fieldsnamef) : explode(",", $field_name);
			if(($loadtype!='autofield' || ($loadtype=='autofield' && $ctag->GetAtt('autofield')==1)) && in_array($field_name, $fieldsname) )
			{
				$dede_addonfields .= '<ul><li id="mtxz">
				<span>'.$ctag->GetAtt('itemname').'：</span>
				<p>
				';//名称
				if($cfg_rewritea == 'Y')
				{
					$filterparms = getFilterParms($tid);
					$new_filter = array();
					foreach ($filterparms as $key=>$value)
					{
						$new_filter[] = $key;
					}
					$name_key = array_search($field_name, $new_filter);
					preg_match('#[a-z]+?_\d+?_([a-z0-9_]+)#i',$filterarr,$href0);
					$href0 = $href0 ? $href0[1] : "";
					$href1 = explode("_".$field_name.'_', "_".$href0);
					$href2 = ($href1[1]!="" && strpos($href1[1],"_")) ? explode('_', $href1[1]) : array($href1[1]!="" ? $href1[1] : "");
					$fields_value = $href2!=array() ? $href2[0] : "";
					$fields_value1 = $fields_value!="" ? explode('_', $fields_value) : "";
					$all_href = str_replace(array("_".$field_name."_".$fields_value,"_".$field_name.".","."),array("",".","."),$filterarr.'.html');
					if (!preg_match('/_[A-Za-z]+_\d+/i',$all_href))
					{
						$all_href = $cfg_cmspath.$typedir.'/';
					}
					$dede_addonfields .= (preg_match("/_".$field_name."_/is",$filterarr,$regm) ? '<a href="'.$all_href.'">全部</a>' : '<p><a class="acti">全部</a>');
					$href = "";
					$addonfields_items = explode(",",$ctag->GetAtt('default'));
					for ($i=0; $i<count($addonfields_items); $i++)
					{
						$is_select = in_array($i, $fields_value1) ? 1 : 0;
						$newarr = array();
						if (stripos($filterarr,"_".$field_name.'_'))
						{
							$valuestr = "";
							$newarr[] = $i;
							sort($newarr);
							foreach ($newarr as $value)
							{
								$valuestr = "_".$value;
							}
							$restr = $field_name.$valuestr;
							$href = str_replace("_".$field_name."_".$fields_value, "_".$field_name.$valuestr, $filterarr);
						}
						else
						{
							if($href0)
							{
								preg_match_all('/[a-z]+_\d+/i', $href0, $href0_arr);
								$fstrarr = array();
								$fstr = "";
								foreach ($all_item as $key=>$value)
								{
									if ($ctag->GetName()==$value) {
										$fstrarr[$value] = $value."_".$i;
									}
								}
								$fstrarr = array_merge($href0_arr[0], $fstrarr);
								sort($fstrarr);
								foreach ($fstrarr as $v)
								{
									$fstr .= "_".$v;
								}
								$filterarr1 = explode("list_", $filterarr);
								$href = $filterarr1[0]."list_".$tid.$fstr;
							}
							else
							{
								$filterarr1 = explode("list_", $filterarr);
								$href = $filterarr1[0]."list_".$tid.'_'.$field_name.'_'.$i;
							}
						}
						$href .= ".html";
						$href = str_replace(array("_".$field_name.".",".","_".$_REQUEST['TotalResult']."_".$_REQUEST['PageNo']),array(".",".",""),$href);
						
						$dede_addonfields .= (((strpos($filterarr,$field_name."_".$fields_value)=="" || $fields_value!=$i) && $is_select==0 ) ? '<a href="'.$href.'">'.$addonfields_items[$i].'</a>' : '<a class="acti">'.$addonfields_items[$i].'</a>');
					}
				}
				else
				{
					$href1 = explode($ctag->GetName().'=', $filterarr);
					$href2 = explode('&', $href1[1]);
					$fields_value = $href2[0];
					$fields_value1 = explode("|",$fields_value);
					$dede_addonfields .= (preg_match("/&".$ctag->GetName()."=/is",$filterarr,$regm) ? '<p><a title="全部" href="'.str_replace("&".$ctag->GetName()."=".$fields_value,"",$filterarr).'">全部</a>
					' : '<a class="acti"  >全部</a>
					<var>
');//quanbu
					$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]);
						$href = str_replace("&TotalResult=".$_REQUEST['TotalResult']."&PageNo=".$_REQUEST['PageNo'], "", $href);
						
						$dede_addonfields .= ($fields_value!=urlencode($addonfields_items[$i]) && $is_select!=1 ? '
						<a title="'.$addonfields_items[$i].'" href="'.$href.'">'.$addonfields_items[$i].'</a>' : '<a class="acti">'.$addonfields_items[$i].'</a>');//小标题
					}
					$dede_addonfields .= '</var></p>
</li>
';
				}
			}
        }
    }
	echo $dede_addonfields;
}

function getFilterParms($ptid,$part=0)
{
	global $dsql, $tid, $use_fields_name;
	$tid = $ptid ? $ptid : $tid;
	$tidsq = $dsql->GetOne(" Select channeltype,templist From `#@__arctype` where id='$tid' ");
	$channelid = $tidsq["channeltype"];

    $cInfos = $dsql->GetOne(" Select * From  `#@__channeltype` where id='$channelid' ");
	$fieldset=$cInfos['fieldset'];
	$dtp = new DedeTagParse();
    $dtp->SetNameSpace('field','<','>');
    $dtp->LoadSource($fieldset);
	$ctag1 = $dtp->CTags;
	
	if ($part==1) {
		$tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];
		$tempfile = str_replace(array("{tid}","{cid}","{style}"), array($tid,$cInfos['nid'],$GLOBALS['cfg_df_style']), $tidsq['templist']);
		$tempfile = $tmpdir."/".$tempfile;
		if(!file_exists($tempfile))
		{
			$tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/list_default.htm";
		}
		$dtp1 = new DedeTagParse();
		$dtp1->LoadTemplate($tempfile);
		$TempSource = $dtp1->SourceString;
		preg_match_all("/{dede:php}(.*?){\/dede:php}/is",$TempSource,$regm);
		$use_fields_name = array();
		if ($regm[0]) {
			foreach ($regm[0] as $key=>$value)
			{
				if (strpos($value, "AddFilter")>-1) {
					$attr = explode("'", $value);
					$attr = explode(",", $attr[1]);
				}
				$use_fields_name = array_merge($use_fields_name, $attr);
			}
		}
	} else {
		$use_fields_name = $use_fields_name ? explode(",", $use_fields_name) : "";
	}
    if(is_array($ctag1))
    {
		$all_item = array();
		foreach($ctag1 as $tida=>$ctag)
        {
			$field_name = $ctag->GetName();
			$fieldsname = explode(",", $field_name);
			if($ctag->GetAtt('autofield')==1 && in_array($field_name, $fieldsname))
			{
				if ($use_fields_name!="" && $part==1) {
					if (in_array($field_name, $use_fields_name) && $ctag->GetAtt('default')) {
						$all_item[$field_name] = explode(",",$ctag->GetAtt('default'));
					}
				} else {
					if ($ctag->GetAtt('default')) {
						$all_item[$field_name] = explode(",",$ctag->GetAtt('default'));
					}
				}
			}
		}
    }
	return $all_item;
}

如果文件未改动可选择打包下载-文件打包下载地址：代码文件打包下载

后台添加自定义字段 核心-频道模型-普通文章-字段管理-添加新字段

dedecms列表页标签筛选联动筛选查询-大江博客

发布文章时选择相对应的字段类型

dedecms列表页标签筛选联动筛选查询-大江博客

列表页调用

{dede:php}AddFilter(1,1,"xingzhi,hangye,youhui,jiage");{/dede:php}

其中的第一个 1 就是 频道ID     第二个1不用管!!   后面的是自定义的字段名称!!!

附件内容

如果文件未改动可选择打包下载-文件打包下载地址：代码文件打包下载

注意事项

代码编辑时请务必使用专业代码编辑器或者相关软件，并且一定要复制备份一份原文件。

请大家尊重版权，如非必要请不要去除版权等相关信息，另外积极支持正版软件，谢谢！

 

本文为站长亲测无误后发表，转载请注明出处！

至此关于dedecms列表页标签筛选联动筛选查询的解决办法已全部完成，本文由博主边操作边写记录并亲测无误，如您在过程中遇到什么问题，请联系我QQ：726322022  微信：hb6958 （请注明来意）

未经作者允许不得转载：大江博客 » dedecms列表页标签筛选联动筛选查询
博主微信：欢迎加微一起交流
欢迎加微一起交流，每天分享更多有趣的事儿，有趣有料！
2000人已加
分享到：
赞(1)

说点啥吧抢沙发

评论前必须 ☞☞ 登录/注册 ！

相关推荐

推荐文章

归档

标签云

乡愁 (7)乡村 (9)代码 (22)四季 (8)大同司 (6)大娘 (6)天空 (14)安静 (11)山村 (9)张榜 (3)情感 (7)感动 (8)明天 (17)朋友 (27)母亲 (35)民工 (4)爱 (82)留守 (14)白露秋霜 (244)相思 (3)相识 (6)红尘 (27)纯洁 (3)美丽 (19)自然 (9)艾草 (23)蕲春 (22)蕲艾 (6)视野 (2)诗歌 (5)释然 (19)野马 (23)雪花 (9)青春 (9)风景 (10)

近期文章