CMS的“栏目管理”中修改“是否显示”的bug！

###  **案例：**

1. 将栏目管理中的一个栏目设置为“不显示”。
![设置为“不显示”](https://images.gitee.com/uploads/images/2018/0726/144904_11010819_1576753.png "屏幕截图.png")
2. 去前台页面查看效果，发现该“联系我们”依然存在。
![“联系我们”依然存在](https://images.gitee.com/uploads/images/2018/0726/145138_bf78e7b3_1576753.png "屏幕截图.png")
3. 查看代码发现，前后台查询的sql语句为 **同一条** 。原sql语句为：
ofcms\ofcms-admin\src\main\resources\conf\sql\cms\column.sql
```
#sql("query")
select
			t.column_id,
		 	t.site_id,
		 	t.column_code,
		 	t.up_column_id,
		 	t.form_id,f.form_name,
		 	t.column_name,
		 	t.column_english,
		 	t.template_path,
		 	t.column_desc,
		 	t.content_url,
		 	t.column_content,
		 	t.column_image,
		 	t.column_index_page,
		 	t.column_list_page,
		 	t.column_content_page,
		 	t.is_show,
		 	t.sort,
		 	t.create_time,
		 	t.upate_time,
		 	t.status,
		 	t.remark
	from
		  of_cms_column t left join of_cms_form f on t.form_id = f.form_id  where t.status = '1' and t.site_id = #para(site_id)
	#if (column_name?? ) and  t.column_name = #para(column_name)#end
	#if (sort?? && field) order by order_field order_sort  #else order by t.sort asc #end
#end
```
4. 通过sql语句我们发现，查询条件中并未设置有“t.is_show = '1”。即是否显示的状态为1（1为显示，0为不显示）；

###  ** 解决思路：**

1. 再添加一条sql语句为“cms_query”并修改“query”的sql。其中“query”的sql语句为 **前台界面** 查询所用，即添加查询条件“t.is_show = '1”；“cms_query”的语句为 **后台cms** 查询所用，不添加“is_show”的条件即则原sql语句查询。具体sql语句为：

```
#sql("query")
select
			t.column_id,
		 	t.site_id,
		 	t.column_code,
		 	t.up_column_id,
		 	t.form_id,f.form_name,
		 	t.column_name,
		 	t.column_english,
		 	t.template_path,
		 	t.column_desc,
		 	t.content_url,
		 	t.column_content,
		 	t.column_image,
		 	t.column_index_page,
		 	t.column_list_page,
		 	t.column_content_page,
		 	t.is_show,
		 	t.sort,
		 	t.create_time,
		 	t.upate_time,
		 	t.status,
		 	t.remark
	from
		  of_cms_column t left join of_cms_form f on t.form_id = f.form_id  where t.status = '1'
		  and t.site_id = #para(site_id)  and t.is_show = '1'
    #if (column_name?? ) and  t.column_name = #para(column_name)#end
    #if (sort?? && field) order by order_field order_sort  #else order by t.sort asc ,t.up_column_id asc #end
#end

#sql("cms_query")
select
			t.column_id,
		 	t.site_id,
		 	t.column_code,
		 	t.up_column_id,
		 	t.form_id,f.form_name,
		 	t.column_name,
		 	t.column_english,
		 	t.template_path,
		 	t.column_desc,
		 	t.content_url,
		 	t.column_content,
		 	t.column_image,
		 	t.column_index_page,
		 	t.column_list_page,
		 	t.column_content_page,
		 	t.is_show,
		 	t.sort,
		 	t.create_time,
		 	t.upate_time,
		 	t.status,
		 	t.remark
	from
		  of_cms_column t left join of_cms_form f on t.form_id = f.form_id  where t.status = '1'
		  and t.site_id = #para(site_id)
    #if (column_name?? ) and  t.column_name = #para(column_name)#end
    #if (sort?? && field) order by order_field order_sort  #else order by t.sort asc ,t.up_column_id asc #end
#end
```
2. 再将\ofcms\ofcms-admin\src\main\java\com\ofsoft\cms\admin\controller\cms\ColumnController.java里menu方法修改为如下：

```
public void menu() {
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("site_id", SystemUtile.getSiteId());
         **List<Record> list = Db.find(Db.getSqlPara("cms.column.cms_query", params));** 
        List<TreeGird> result = SystemUtile.tree(list, parent);
        rendSuccessJson(result);
    }
```
3. 重启tomcat，发现前台首页界面的“联系我们”消失了。
![“联系我们”消失了](https://images.gitee.com/uploads/images/2018/0726/152234_015e8934_1576753.png "屏幕截图.png")

欧福/ofcms

内容风险标识

评论 (0)

欧福/ofcms .gitee-modal { width: 500px !important; }

内容风险标识