站长学院
CMS建站教程 SEO优化攻略
来源:齐鲁CMS 栏目:PHPCMS 阅读: 日期:2020-08-01
最近有朋友使用PHPCMS做建站使用想开发个多条筛选功能,PHPCMS的电影模型有这个筛选功能,齐鲁建站小编根据这个实例经过一翻研究,找到了方法,今天就来说说phpcms v9二次开发多个筛选条件功能的图文教程 。
下面就来说说phpcms筛选条件开发的方法。
先来看看实际效果图。
实现方法:
添加字段: 后台-->内容-->内容相关设置-->模型管理-->文章模型-->字段管理-->添加字段-->如下图示例:
添加自定义函数:
将以下代码添加到 phpcms/libs/functions/extention.func.php 文件
<?php/*** extention.func.php 用户自定义函数库** @copyright (C) 2005-2010 PHPCMS* @license http://www.phpcms.cn/license/* @lastmodify 2010-10-27*//********************实现筛选功能************************//*** 通过指定keyid形式显示所有联动菜单* @param $keyid 菜单主id* @param $linkageid 联动菜单id,0调用顶级* @param $modelid 模型id* @param $fieldname 字段名称*/function show_linkage($keyid, $linkageid = 0, $modelid = '', $fieldname='zone') {$datas = $infos = $array = array();$keyid = intval($keyid);$linkageid = intval($linkageid);//当前菜单id$field_value = intval($_GET[$fieldname]);$urlrule = structure_filters_url($fieldname,$array,1,$modelid);if($keyid == 0) return false;$datas = getcache($keyid,'linkage');$infos = $datas['data'];foreach($infos as $k=>$v){if($v['parentid']==$field_value){$array[$k]['name'] = $v['name'];$array[$k]['value'] = $k;$array[$k]['url'] = str_replace('{$'.$fieldname.'}',$k,$urlrule);$array[$k]['menu'] = $field_value == $k ? '<em>'.$v['name'].'</em>' : '<a href='.$array[$k]['url'].'>'.$v['name'].'</a>' ;}}return $array;}function structure_filters_url($fieldname,$array=array(),$type = 1,$modelid) {if(empty($array)) {$array = $_GET;} else {$array = array_merge($_GET,$array);}//TODO$fields = getcache('model_field_'.$modelid,'model');if(is_array($fields) && !empty($fields)) {ksort($fields);foreach ($fields as $_v=>$_k) {if($_k['filtertype'] || $_k['rangetype']) {if(strpos(URLRULE,'.html') === FALSE) $urlpars .= '&'.$_v.'={$'.$_v.'}';else $urlpars .= '-{$'.$_v.'}';}}}//后期增加伪静态等其他url规则管理,apache伪静态支持9个参数if(strpos(URLRULE,'.html') === FALSE) $urlrule =APP_PATH.'index.php?m=content&c=index&a=lists&catid={$catid}'.$urlpars.'&page={$page}' ;else $urlrule =APP_PATH.'list-{$catid}'.$urlpars.'-{$page}.html';//根据get传值构造URLif (is_array($array)) foreach ($array as $_k=>$_v) {if($_k=='page') $_v=1;if($type == 1) if($_k==$fieldname) continue;$_findme[] = '/{\$'.$_k.'}/';$_replaceme[] = $_v;}//type 模式的时候,构造排除该字段名称的正则if($type==1) $filter = '(?!'.$fieldname.'.)';$_findme[] = '/{\$'.$filter.'([a-z0-9_]+)}/';$_replaceme[] = '';$urlrule = preg_replace($_findme, $_replaceme, $urlrule);return $urlrule;}/*** 生成分类信息中的筛选菜单* @param $field 字段名称* @param $modelid 模型ID*/function filters($field,$modelid,$diyarr = array()) {$fields = getcache('model_field_'.$modelid,'model');$options = empty($diyarr) ? explode("\n",$fields[$field]['options']) : $diyarr;$field_value = intval($_GET[$field]);foreach($options as $_k) {$v = explode("|",$_k);$k = trim($v[1]);$option[$k]['name'] = $v[0];$option[$k]['value'] = $k;$option[$k]['url'] = structure_filters_url($field,array($field=>$k),2,$modelid);$option[$k]['menu'] = $field_value == $k ? '<em>'.$v[0].'</em>' : '<a href='.$option[$k]['url'].'>'.$v[0].'</a>' ;}$all['name'] = '全部';$all['url'] = structure_filters_url($field,array($field=>''),2,$modelid);$all['menu'] = $field_value == '' ? '<em>'.$all['name'].'</em>' : '<a href='.$all['url'].'>'.$all['name'].'</a>';array_unshift($option,$all);return $option;}/*** 获取联动菜单层级* @param $keyid 联动菜单分类id* @param $linkageid 菜单id* @param $leveltype 获取类型 parentid 获取父级id child 获取时候有子栏目 arrchildid 获取子栏目数组*/function get_linkage_level($keyid,$linkageid,$leveltype = 'parentid') {$child_arr = $childs = array();$leveltypes = array('parentid','child','arrchildid','arrchildinfo');$datas = getcache($keyid,'linkage');$infos = $datas['data'];if (in_array($leveltype, $leveltypes)) {if($leveltype == 'arrchildinfo') {$child_arr = explode(',',$infos[$linkageid]['arrchildid']);foreach ($child_arr as $r) {$childs[] = $infos[$r];}return $childs;} else {return $infos[$linkageid][$leveltype];}}}// 根据linkageid递归到父级function get_parent_url($modelid,$field,$linkageid=0,$array = array()){$modelid = intval($modelid);if(!$modelid || empty($field)) return false;$fields = getcache('model_field_'.$modelid,'model');$keyid = $fields[$field]['linkageid'];$datas = getcache($keyid,'linkage');$infos = $datas['data'];if(empty($linkageid)){$linkageid = intval($_GET[$field]);if(!$linkageid) return false;}$urlrule = structure_filters_url($field,array(),1,$modelid);$urlrule = str_replace('{$'.$field.'}',$infos[$linkageid]['parentid'],$urlrule);array_unshift($array,array('name'=> $infos[$linkageid]['name'],'url'=>$urlrule));if($infos[$linkageid]['parentid']){return get_parent_url($modelid,$field,$infos[$linkageid]['parentid'],$array);}return $array;}/*** 构造筛选时候的sql语句,jianggle解决直接筛选出该模型下的所有内容的问题,改成同模型下的栏目间互相独立*/function structure_filters_sql($modelid,$catid) {//增加了$catid参数$sql = $fieldname = $min = $max = '';$fieldvalue = array();$modelid = intval($modelid);$catid = intval($catid);$model = getcache('model','commons');$fields = getcache('model_field_'.$modelid,'model');$fields_key = array_keys($fields);//TODO$sql = '`status` = \'99\'';if($catid!=0) $sql .= ' AND `catid`=\''.$catid.'\'';//同模型,不同catidforeach ($_GET as $k=>$r) {if(in_array($k,$fields_key) && intval($r)!=0 && ($fields[$k]['filtertype'] || $fields[$k]['rangetype']|| $fields[$k]['boxtype'])) {if($fields[$k]['formtype'] == 'linkage') {$datas = getcache($fields[$k]['linkageid'],'linkage');$infos = $datas['data'];if($infos[$r]['arrchildid']) {$sql .= ' AND `'.$k.'` in('.$infos[$r]['arrchildid'].')';}} elseif($fields[$k]['rangetype']) {if(is_numeric($r)) {$sql .=" AND `$k` = '$r'";} else {$fieldvalue = explode('_',$r);$min = intval($fieldvalue[0]);$max = $fieldvalue[1] ? intval($fieldvalue[1]) : 999999;$sql .=" AND `$k` >= '$min' AND `$k` < '$max'";}}elseif($fields[$k]['boxtype']=='checkbox') {$sql .=" AND `$k` like '%,$r,%'";} else {$sql .=" AND `$k` = '$r'";}}}// echo $sql;return $sql;}/*** 分页,如去掉则分页会有问题*/function makeurlrule() {if(strpos(URLRULE,'.html') === FALSE) {return url_par('page={$'.'page}');}else {$url = preg_replace('/-[0-9]+.html$/','-{$page}.html',get_url());return $url;}}/********************实现前台输出“选项名称”功能************************//*** 根据box类型字段获取显示名称* @param $field 字段名称* @param $value 字段值* @param $modelid 字段所在模型id*/function box($field, $value, $modelid='') {$fields = getcache('model_field_'.$modelid,'model');extract(string2array($fields[$field]['setting']));$options = explode("\n",$fields[$field]['options']);foreach($options as $_k) {$v = explode("|",$_k);$k = trim($v[1]);$option[$k] = $v[0];}$string = '';switch($fields[$field]['boxtype']) {case 'radio':$string = $option[$value];break;case 'checkbox':$value_arr = explode(',',$value);foreach($value_arr as $_v) {if($_v) $string .= $option[$_v].' 、';}break;case 'select':$string = $option[$value];break;case 'multiple':$value_arr = explode(',',$value);foreach($value_arr as $_v) {if($_v) $string .= $option[$_v].' 、';}break;}return $string;}?>
模板使用
{template "content","header"}<!--main--><div class="main"><div class="col-left"><div class="crumbs"><a href="{siteurl($siteid)}">首页</a><span> > </span>{catpos($catid)} 列表</div>{php $sql = structure_filters_sql($modelid,$catid)}{php $urlrule = makeurlrule()}{pc:content action="lists" catid="$catid" where="$sql" num="3" order="id DESC" page="$page" moreinfo="1" urlrule="$urlrule"}<ul>{loop $data $r}<li><h2><a href="{$r[url]}" title="{$r[title]}" target="_blank">{$r[title]}</a></h2>性别:{box('sex',$r[sex],$modelid)} 学历:{box('edu',$r[edu],$modelid)}</li>{/loop}</ul><div id="pages" class="text-c">{$pages}</div>{/pc}</div><div class="col-auto"><div class="box"><h5 class="title-2">性别</h5><ul class="content digg">{loop filters('sex',$modelid) $r}<li>{$r[menu]} </li>{/loop}</ul></div><div class="bk10"></div><div class="box"><h5 class="title-2">学历</h5><ul class="content digg">{loop filters('edu',$modelid) $r}<li>{$r[menu]} </li>{/loop}</ul></div><div class="bk10"></div></div></div>{template "content","footer"}
调用解析
pc标签调用筛选后的结果代码:
{php $sql = structure_filters_sql($modelid,$catid)}{php $urlrule = makeurlrule()}{pc:content action="lists" catid="$catid" where="$sql" num="3" order="id DESC" page="$page" moreinfo="1" urlrule="$urlrule"}
输出自定义字段的选项名称代码:
{box('sex',$r[sex],$modelid)} //sex为添加的自定义字段 $modelid为模型id号
调用筛选字段并展现代码:
{loop filters('sex',$modelid) $r} //sex为添加的自定义字段 $modelid为模型id号<li>{$r[menu]}</li>{/loop}
以上就是关于phpcms筛选条件开发的所有内容,有需要的朋友可以对着教程试试看,开发之前建议备份好哦。