SmartGov中，隐藏待处理的信访信件
来源：本站原创
点击数： 次
发布时间：2009年12月31日
在SmartGov中，信访的信件填写时，如果设置了信件的类型为公开，则提交的信件会即时显示在前台，由于可能会导致部分恶意信件对网站造成影响，因此下面将介绍如何将信件列表显示的信件限定除了是公开类型的，还要是由后台审核处理过的
在“标签管理”中找到标签：信件列表标签
然后编辑标签的查询语句，加上红色部分的代码
注：PE_GV_Letters.Status 是信件的状态码，待处理的状态码为0，所以查询的时候加上条件，限定不查询为0的信件即可满足要求。
|
SELECT Top @pagesize PE_GV_Letters.*, PE_GV_LetterType.LetterTypeName, PE_GV_Department.DepartmentName FROM PE_GV_Letters, PE_GV_LetterType, PE_GV_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_GV_Department.DepartmentId AND PE_GV_Letters.IsPublic=1 AND PE_GV_Letters.Status!=0 AND PE_GV_Letters.LetterTypeId=@LetterTypeId AND PE_GV_Letters.LetterId NOT IN(SELECT Top @startrow PE_GV_Letters.LetterId FROM PE_GV_Letters, PE_GV_LetterType, PE_GV_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_GV_Department.DepartmentId AND PE_GV_Letters.IsPublic=1 AND PE_GV_Letters.Status!=0 AND PE_GV_Letters.LetterTypeId=@LetterTypeId ORDER BY InputTime DESC) ORDER BY InputTime DESC SELECT COUNT(*) FROM PE_GV_Letters, PE_GV_LetterType, PE_GV_Department WHERE PE_GV_Letters.LetterTypeId=PE_GV_LetterType.LetterTypeId AND PE_GV_Letters.DepartmentId=PE_GV_Department.DepartmentId AND PE_GV_Letters.IsPublic=1 AND PE_GV_Letters.LetterTypeId=@LetterTypeId |