fengjin
2022-11-14 3e0c2dda5a8963977a2518fe75936f830e975d20
1.法律法规相关代码
8个文件已修改
4个文件已添加
461 ■■■■■ 已修改文件
flower_city/src/main/java/com/dg/core/api/AutomessagePolicyDocumentsAppletsController.java 64 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/controller/AutomessagePolicyDocumentsController.java 141 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/gen/entity/AutomessagePolicyDocuments.java 32 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/gen/mapper/AutomessagePolicyDocumentsMapper.java 35 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/manual/pojo/QueryResults.java 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/manual/pojo/RecommendResult.java 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/db/manual/pojo/Search.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/service/IAutomessagePolicyDocumentsService.java 58 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/service/impl/AutomessagePolicyDocumentsServiceImpl.java 77 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/resources/mapper/AutomessagePolicyDocumentsMapper.xml 26 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/resources/mapper/TransactionEventMapper.xml 4 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/java/com/dg/core/api/AutomessagePolicyDocumentsAppletsController.java
New file
@@ -0,0 +1,64 @@
package com.dg.core.api;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.dg.core.ResultData;
import com.dg.core.annotation.Authorization;
import com.dg.core.annotation.CurrentUser;
import com.dg.core.controller.BaseController;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.SysUser;
import com.dg.core.service.IAutomessagePolicyDocumentsService;
import com.dg.core.util.TableDataInfo;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.List;
@Api(tags = {"获取法律法规政策文件小程序接口"})
@RestController
@RequestMapping("/applets/AutomessagePolicyDocumentsController")
public class AutomessagePolicyDocumentsAppletsController extends BaseController {
    @Resource
    private IAutomessagePolicyDocumentsService iAutomessagePolicyDocumentsService;
    /**
     * 获取法律法规政策文件列表(不分页)
     * @param name
     * @param type
     * @return
     */
    @ApiOperation(value = "获取法律法规政策文件列表(不分页)",response = AutomessagePolicyDocuments.class)
    @ApiImplicitParams({
            @ApiImplicitParam(name = "type", value = "类型(1.法律法规2.政策文件)", required = true, dataType = "String", paramType = "query")
    })
    @GetMapping("/selectList")
    public ResultData selectConfigList(@RequestParam(value = "name",required = false) String name,
                                          @RequestParam(value = "type",required = false) String type,
                                       @RequestParam(value = "departmentId",required = false) Integer departmentId){
        List<AutomessagePolicyDocuments> list = iAutomessagePolicyDocumentsService.selectConfigList(name,type,departmentId);
        return  ResultData.success(list);
    }
    /**
     * 根据id获取法律法规政策文件数据
     * @return
     */
    @ApiOperation(value = " 根据id获取法律法规政策文件数据 ",response = AutomessagePolicyDocuments.class)
    @GetMapping("/selectAutomessagePolicyDocumentById")
    @Authorization
    public ResultData selectAutomessagePolicyDocumentById(@RequestParam(value = "id") Integer id){
        AutomessagePolicyDocuments automessagePolicyDocuments = iAutomessagePolicyDocumentsService.selectAutomessagePolicyDocumentById(id);
        if (automessagePolicyDocuments!=null){
            return  ResultData.success(automessagePolicyDocuments);
        }else {
            return  ResultData.error("查找失败");
        }
    }
}
flower_city/src/main/java/com/dg/core/controller/AutomessagePolicyDocumentsController.java
New file
@@ -0,0 +1,141 @@
package com.dg.core.controller;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.dg.core.ResultData;
import com.dg.core.annotation.Authorization;
import com.dg.core.annotation.CurrentUser;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.SysUser;
import com.dg.core.service.IAutomessagePolicyDocumentsService;
import com.dg.core.util.TableDataInfo;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import lombok.Data;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.List;
@Api(tags = {"获取法律法规政策文件接口"})
@RestController
@RequestMapping("/AutomessagePolicyDocumentsController")
public class AutomessagePolicyDocumentsController extends BaseController {
    @Resource
    private IAutomessagePolicyDocumentsService iAutomessagePolicyDocumentsService;
    /**
     * 获取法律法规政策文件列表(分页)
     * @param name
     * @param type
     * @return
     */
    @ApiOperation(value = "获取法律法规政策文件列表(分页)",response = AutomessagePolicyDocuments.class)
    @ApiImplicitParams({
            @ApiImplicitParam(name = "type", value = "类型(1.法律法规2.政策文件)", required = true, dataType = "String", paramType = "query")
    })
    @GetMapping("/selectConfigList")
    @Authorization
    public TableDataInfo selectConfigList(@RequestParam(value = "pageNum",required = false) Integer pageNum,
                                          @RequestParam(value = "pageSize",required = false) Integer pageSize,
                                          @RequestParam(value = "name",required = false) String name,
                                          @RequestParam(value = "type",required = false) String type,
                                          @RequestParam(value = "departmentId",required = false) Integer departmentId,
                                          @CurrentUser SysUser sysUser){
        Page<AutomessagePolicyDocuments> pageParam = new Page<>(pageNum,pageSize);
        List<AutomessagePolicyDocuments> list = iAutomessagePolicyDocumentsService.selectConfigList(pageParam,pageSize,name,type,sysUser,departmentId);
        return getDataTable(list,iAutomessagePolicyDocumentsService.selectCountList(name,type,departmentId));
    }
    /**
     * 获取法律法规政策文件列表(不分页)
     * @param name
     * @param type
     * @return
     */
    @ApiOperation(value = "获取法律法规政策文件列表(不分页)",response = AutomessagePolicyDocuments.class)
    @ApiImplicitParams({
            @ApiImplicitParam(name = "type", value = "类型(1.法律法规2.政策文件)", required = true, dataType = "String", paramType = "query")
    })
    @GetMapping("/selectList")
    public ResultData selectConfigList(@RequestParam(value = "name",required = false) String name,
                                          @RequestParam(value = "type",required = false) String type,
                                       @RequestParam(value = "departmentId",required = false) Integer departmentId){
        List<AutomessagePolicyDocuments> list = iAutomessagePolicyDocumentsService.selectConfigList(name,type,departmentId);
        return  ResultData.success(list);
    }
    /**
     * 新增法律法规政策文件
     * @return
     */
    @ApiOperation(value = " 新增法律法规政策文件 ",response = AutomessagePolicyDocuments.class)
    @ApiImplicitParams({
            @ApiImplicitParam(name = "type", value = "类型(1.法律法规2.政策文件)传参中的type 传入1则是新增的法律规范2则是政策文件", required = true, dataType = "String", paramType = "query")
    })
    @PostMapping("/add")
    @Authorization
    public ResultData add(@RequestBody AutomessagePolicyDocuments automessagePolicyDocuments,@CurrentUser SysUser sysUser){
        automessagePolicyDocuments.setCreateUserId(sysUser.getUserId());
        automessagePolicyDocuments.setUpdateUserId(sysUser.getUserId());
        int add = iAutomessagePolicyDocumentsService.add(automessagePolicyDocuments);
        if (add>0){
          return  ResultData.success("新增成功");
        }else {
          return  ResultData.error("新增失败");
        }
    }
    /**
     * 修改法律法规政策文件
     * @return
     */
    @ApiOperation(value = " 新增法律法规政策文件 ",response = AutomessagePolicyDocuments.class)
    @PostMapping("/update")
    @Authorization
    public ResultData update(@RequestBody AutomessagePolicyDocuments automessagePolicyDocuments,@CurrentUser SysUser sysUser){
        automessagePolicyDocuments.setUpdateUserId(sysUser.getUserId());
        int update = iAutomessagePolicyDocumentsService.update(automessagePolicyDocuments);
        if (update>0){
            return  ResultData.success("修改成功");
        }else {
            return  ResultData.error("修改失败");
        }
    }
    /**
     * 删除法律法规政策文件
     * @return
     */
    @ApiOperation(value = " 删除法律法规政策文件 ",response = AutomessagePolicyDocuments.class)
    @DeleteMapping("/delete")
    @Authorization
    public ResultData delete(@RequestParam(value = "id") Integer id){
        int delete = iAutomessagePolicyDocumentsService.delete(id);
        if (delete>0){
            return  ResultData.success("删除成功");
        }else {
            return  ResultData.error("删除失败");
        }
    }
    /**
     * 根据id获取法律法规政策文件数据
     * @return
     */
    @ApiOperation(value = " 根据id获取法律法规政策文件数据 ",response = AutomessagePolicyDocuments.class)
    @GetMapping("/selectAutomessagePolicyDocumentById")
    @Authorization
    public ResultData selectAutomessagePolicyDocumentById(@RequestParam(value = "id") Integer id){
        AutomessagePolicyDocuments automessagePolicyDocuments = iAutomessagePolicyDocumentsService.selectAutomessagePolicyDocumentById(id);
        if (automessagePolicyDocuments!=null){
            return  ResultData.success(automessagePolicyDocuments);
        }else {
            return  ResultData.error("查找失败");
        }
    }
}
flower_city/src/main/java/com/dg/core/db/gen/entity/AutomessagePolicyDocuments.java
@@ -1,6 +1,7 @@
package com.dg.core.db.gen.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
@@ -47,7 +48,7 @@
    /**
     * 跳转链接类型(1.富文本2.微信文章)
     */
    @ApiModelProperty("名称")
    @ApiModelProperty(" 跳转链接类型(1.富文本2.微信文章)")
    private String linkType;
    /**
@@ -78,7 +79,7 @@
     * 创建人
     */
    @ApiModelProperty("创建人")
    private Integer createUserId;
    private String createUserId;
    /**
     * 修改时间
@@ -91,5 +92,30 @@
     * 修改人
     */
    @ApiModelProperty("修改人")
    private Integer  updateUserId;
    private String  updateUserId;
    /**
     * 部门名称
     */
    @TableField(exist = false)
    @ApiModelProperty("部门名称")
    private String departmentName;
    /**
     * 修改人名称
     */
    @TableField(exist = false)
    @ApiModelProperty("修改人名称")
    private String updateUserName;
    /**
     * 创建人名称
     */
    @TableField(exist = false)
    @ApiModelProperty("创建人名称")
    private String createUserName;
    @TableField(exist = false)
    @ApiModelProperty("是否能够删除1.可以删除修改 2.不能删除修改")
    private  Integer isDelete;
}
flower_city/src/main/java/com/dg/core/db/gen/mapper/AutomessagePolicyDocumentsMapper.java
@@ -1,7 +1,10 @@
package com.dg.core.db.gen.mapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.dg.core.db.gen.entity.AutomessageCommonProblem;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.data.repository.query.Param;
import java.util.List;
@@ -15,6 +18,36 @@
 */
public interface AutomessagePolicyDocumentsMapper extends BaseMapper<AutomessagePolicyDocuments> {
   List<AutomessagePolicyDocuments> selectConfigList();
   /**
    * 获取法律法规政策文件 (分页)
    * @param page
    * @param state
    * @param name 名称
    * @param type 类型
    * @return
    */
   List<AutomessagePolicyDocuments> selectConfigList(IPage<AutomessagePolicyDocuments> page, Integer state, @Param("name") String name, @Param("type") String type, @Param("departmentId") Integer departmentId);
   /**
    * 获取法律法规政策文件 (不分页)
    * @param name 名称
    * @param type 类型
    * @return
    */
   List<AutomessagePolicyDocuments> selectConfigList(@Param("name") String name, @Param("type") String type, @Param("departmentId") Integer departmentId);
   /**
    * 根据id获取法律法规政策文件数据
    * @return
    */
   AutomessagePolicyDocuments selectAutomessagePolicyDocumentById(Integer id);
   /**
    * 获取法律法规政策文件 (统计)
    * @return
    */
  Integer selectCountList(@Param("name") String name, @Param("type") String type,@Param("departmentId") Integer departmentId);
}
flower_city/src/main/java/com/dg/core/db/manual/pojo/QueryResults.java
@@ -1,5 +1,6 @@
package com.dg.core.db.manual.pojo;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.KeywordEntity;
import com.dg.core.db.gen.entity.OrganizationChartEntity;
import com.dg.core.db.gen.entity.TransactionEvent;
@@ -32,4 +33,10 @@
    @ApiModelProperty("办事部门列表")
    private  List<OrganizationChartEntity> organizationChartEntityList;
    @ApiModelProperty("政策文件列表")
    private  List<AutomessagePolicyDocuments> automessagePolicyDocuments;
    @ApiModelProperty("法律法规列表")
    private  List<AutomessagePolicyDocuments> regulations;
}
flower_city/src/main/java/com/dg/core/db/manual/pojo/RecommendResult.java
@@ -1,5 +1,6 @@
package com.dg.core.db.manual.pojo;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.KeywordEntity;
import com.dg.core.db.gen.entity.OrganizationChartEntity;
import com.dg.core.db.gen.entity.TransactionEvent;
@@ -21,4 +22,10 @@
    @ApiModelProperty("办事部门列表")
    private  List<OrganizationChartEntity> organizationChartEntityList;
    @ApiModelProperty("政策文件列表")
    private  List<AutomessagePolicyDocuments> automessagePolicyDocuments;
    @ApiModelProperty("法律法规列表")
    private  List<AutomessagePolicyDocuments> regulations;
}
flower_city/src/main/java/com/dg/core/db/manual/pojo/Search.java
@@ -29,7 +29,7 @@
    @ApiModelProperty("分类id父id")
    private Integer parentClassifyId;
    @ApiModelProperty("搜索数据类型1.办事部门2.办事指南 3.推荐办事指南4.分类")
    @ApiModelProperty("搜索数据类型1.办事部门2.办事指南 3.推荐办事指南4.分类 5.政策文件 6.法律法规")
    private  Integer type;
    @ApiModelProperty("办事指南")
flower_city/src/main/java/com/dg/core/service/IAutomessagePolicyDocumentsService.java
New file
@@ -0,0 +1,58 @@
package com.dg.core.service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.SysUser;
import org.springframework.data.repository.query.Param;
import java.util.List;
public interface IAutomessagePolicyDocumentsService {
    /**
     * 获取法律法规政策文件 (分页)
     * @param page
     * @param state
     * @return
     */
    List<AutomessagePolicyDocuments> selectConfigList(IPage<AutomessagePolicyDocuments> page, Integer state, String name, String type, SysUser sysUser,Integer departmentId);
    /**
     * 获取法律法规政策文件 (不分页)
     * @param name 名称
     * @param type 类型
     * @return
     */
    List<AutomessagePolicyDocuments> selectConfigList(String name, String type,Integer departmentId);
    /**
     * 新增法律法规政策文件
     * @return
     */
    int add(AutomessagePolicyDocuments automessagePolicyDocuments);
    /**
     * 修改法律法规政策文件
     * @return
     */
    int update(AutomessagePolicyDocuments automessagePolicyDocuments);
    /**
     * 删除法律法规政策文件
     * @return
     */
    int delete(Integer id);
    /**
     * 根据id获取法律法规政策文件数据
     * @return
     */
    AutomessagePolicyDocuments selectAutomessagePolicyDocumentById(Integer id);
    /**
     * 获取法律法规政策文件 (统计)
     * @return
     */
    Integer selectCountList(String name,String type,Integer departmentI);
}
flower_city/src/main/java/com/dg/core/service/impl/AutomessagePolicyDocumentsServiceImpl.java
New file
@@ -0,0 +1,77 @@
package com.dg.core.service.impl;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dg.core.db.gen.entity.AutomessagePolicyDocuments;
import com.dg.core.db.gen.entity.SysUser;
import com.dg.core.db.gen.mapper.AutomessagePolicyDocumentsMapper;
import com.dg.core.service.IAutomessagePolicyDocumentsService;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Service;
import java.time.LocalDateTime;
import java.util.List;
@Service
public class AutomessagePolicyDocumentsServiceImpl extends ServiceImpl<AutomessagePolicyDocumentsMapper, AutomessagePolicyDocuments> implements IAutomessagePolicyDocumentsService {
    @Override
    public List<AutomessagePolicyDocuments> selectConfigList(IPage<AutomessagePolicyDocuments> page, Integer state, String name, String type, SysUser sysUser,Integer departmentId) {
        List<AutomessagePolicyDocuments> automessagePolicyDocumentsList = baseMapper.selectConfigList(page, state, name, type, departmentId);
        for (AutomessagePolicyDocuments automessagePolicyDocuments:automessagePolicyDocumentsList) {
            if(sysUser.getUserType().equals("1")){//超级管理员
                automessagePolicyDocuments.setIsDelete(1);
            }else if (sysUser.getUserType().equals("3") && sysUser.getIsDivisionHead().equals("1")){//部门领导
                if (sysUser.getDepartmentId().equals(automessagePolicyDocuments.getDepartmentId())){//如果是一个部门则可以删除
                    automessagePolicyDocuments.setIsDelete(1);
                }else {
                    automessagePolicyDocuments.setIsDelete(2);
                }
            }
            else if (sysUser.getUserType().equals("2")){
                if(sysUser.getUserId().equals(automessagePolicyDocuments.getCreateUserId())){//如果它创建的则可以删除
                    automessagePolicyDocuments.setIsDelete(1);
                }else {
                    automessagePolicyDocuments.setIsDelete(2);
                }
            }
        }
        return automessagePolicyDocumentsList;
    }
    @Override
    public List<AutomessagePolicyDocuments> selectConfigList(String name, String type,Integer departmentId) {
        return baseMapper.selectConfigList(name,type,departmentId);
    }
    @Override
    public int add(AutomessagePolicyDocuments automessagePolicyDocuments) {
        automessagePolicyDocuments.setCreateTime(LocalDateTime.now());
        automessagePolicyDocuments.setUpdateTime(LocalDateTime.now());
        return baseMapper.insert(automessagePolicyDocuments);
    }
    @Override
    public int update(AutomessagePolicyDocuments automessagePolicyDocuments) {
        automessagePolicyDocuments.setCreateTime(LocalDateTime.now());
        automessagePolicyDocuments.setUpdateTime(LocalDateTime.now());
        return baseMapper.updateById(automessagePolicyDocuments);
    }
    @Override
    public int delete(Integer id) {
        return baseMapper.deleteById(id);
    }
    @Override
    public AutomessagePolicyDocuments selectAutomessagePolicyDocumentById(Integer id) {
        return baseMapper.selectAutomessagePolicyDocumentById(id);
    }
    @Override
    public Integer selectCountList(String name,String type,Integer departmentId) {
        return baseMapper.selectCountList(name,type,departmentId);
    }
}
flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
@@ -45,6 +45,10 @@
    @Resource
    private GuideRepairOrderMapper guideRepairOrderMapper;
    @Resource
    private  AutomessagePolicyDocumentsMapper automessagePolicyDocumentsMapper;
    @Override
    public TransactionEvent selectConfigData(String Id, SysUser sysUser) {
        TransactionEvent transactionEvent = baseMapper.selectConfigData(Id);
@@ -157,6 +161,8 @@
        }
        queryResults.setTransactionEventList(searchesAssociate);
        queryResults.setKeywordEntityList(keywordMapper.selectByName(keyWord));
        queryResults.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null));
        queryResults.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null));
        return queryResults;
    }
@@ -190,6 +196,8 @@
        }
        recommendResult.setKeywordEntityList(keywordEntityList);
        List<OrganizationChartEntity> organizationChartEntities = organizationChartMapper.selectByKeyWord(keyWord);
        recommendResult.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null));
        recommendResult.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null));
        recommendResult.setOrganizationChartEntityList(organizationChartEntities);
        return recommendResult;
    }
flower_city/src/main/resources/mapper/AutomessagePolicyDocumentsMapper.xml
@@ -44,7 +44,33 @@
            <if test="type!=null">
                and type = #{type}
            </if>
            <if test="departmentId != null">
                 and department_id  in  (SELECT id from automessage_organization_chart where id=#{departmentId} or parent_id = #{departmentId})
            </if>
        </where>
    </select>
    <select id="selectCountList" resultType="integer">
      select count(*) from automessage_policy_documents
      <where>
            <if test="name!=null and name!=''">
                and name  like concat('%', #{name}, '%')
            </if>
            <if test="type!=null">
                and type = #{type}
            </if>
          <if test="departmentId != null">
              and department_id  in  (SELECT id from automessage_organization_chart where id=#{departmentId} or parent_id = #{departmentId})
          </if>
        </where>
    </select>
    <select id="selectAutomessagePolicyDocumentById" resultMap="AutomessagePolicyDocumentsResult">
        <include refid="selectAutomessagePolicyDocumentsResult" />
        <where>
            id = #{id}
        </where>
    </select>
</mapper>
flower_city/src/main/resources/mapper/TransactionEventMapper.xml
@@ -439,7 +439,9 @@
                 select  id,matter_name title,concat((select classify_name from  automessage_classify_administration
                                                      where id=(select parent_id from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)),
                                                     '>',(select classify_name from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)) content,
                         browse_num views,2 type from automessage_transaction_event
                         browse_num views,2 type from automessage_transaction_event UNION
                 SELECT id ,name title,'政策文件' content,null        views,5 type FROM     automessage_policy_documents where type=2      UNION
                 SELECT id ,name title,'法律法规' content,null        views,6 type FROM     automessage_policy_documents where type=1
             ) k
        where  k.title like concat('%',#{keyWord}, '%') or k.content  like concat('%', #{keyWord}, '%')
    </select>