New file |
| | |
| | | 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("查找失败"); |
| | | } |
| | | } |
| | | } |
New file |
| | |
| | | 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("查找失败"); |
| | | } |
| | | } |
| | | } |
| | |
| | | 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; |
| | |
| | | /** |
| | | * 跳转链接类型(1.富文本2.微信文章) |
| | | */ |
| | | @ApiModelProperty("名称") |
| | | @ApiModelProperty(" 跳转链接类型(1.富文本2.微信文章)") |
| | | private String linkType; |
| | | |
| | | /** |
| | |
| | | * 创建人 |
| | | */ |
| | | @ApiModelProperty("创建人") |
| | | private Integer createUserId; |
| | | private String createUserId; |
| | | |
| | | /** |
| | | * 修改时间 |
| | |
| | | * 修改人 |
| | | */ |
| | | @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; |
| | | } |
| | |
| | | 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; |
| | | |
| | |
| | | */ |
| | | 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); |
| | | |
| | | } |
| | |
| | | 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; |
| | |
| | | @ApiModelProperty("办事部门列表") |
| | | private List<OrganizationChartEntity> organizationChartEntityList; |
| | | |
| | | @ApiModelProperty("政策文件列表") |
| | | private List<AutomessagePolicyDocuments> automessagePolicyDocuments; |
| | | |
| | | @ApiModelProperty("法律法规列表") |
| | | private List<AutomessagePolicyDocuments> regulations; |
| | | |
| | | } |
| | |
| | | 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; |
| | |
| | | |
| | | @ApiModelProperty("办事部门列表") |
| | | private List<OrganizationChartEntity> organizationChartEntityList; |
| | | |
| | | @ApiModelProperty("政策文件列表") |
| | | private List<AutomessagePolicyDocuments> automessagePolicyDocuments; |
| | | |
| | | @ApiModelProperty("法律法规列表") |
| | | private List<AutomessagePolicyDocuments> regulations; |
| | | } |
| | |
| | | @ApiModelProperty("分类id父id") |
| | | private Integer parentClassifyId; |
| | | |
| | | @ApiModelProperty("搜索数据类型1.办事部门2.办事指南 3.推荐办事指南4.分类") |
| | | @ApiModelProperty("搜索数据类型1.办事部门2.办事指南 3.推荐办事指南4.分类 5.政策文件 6.法律法规") |
| | | private Integer type; |
| | | |
| | | @ApiModelProperty("办事指南") |
New file |
| | |
| | | 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); |
| | | } |
New file |
| | |
| | | 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); |
| | | } |
| | | |
| | | |
| | | } |
| | |
| | | @Resource |
| | | private GuideRepairOrderMapper guideRepairOrderMapper; |
| | | |
| | | |
| | | @Resource |
| | | private AutomessagePolicyDocumentsMapper automessagePolicyDocumentsMapper; |
| | | |
| | | @Override |
| | | public TransactionEvent selectConfigData(String Id, SysUser sysUser) { |
| | | TransactionEvent transactionEvent = baseMapper.selectConfigData(Id); |
| | |
| | | } |
| | | queryResults.setTransactionEventList(searchesAssociate); |
| | | queryResults.setKeywordEntityList(keywordMapper.selectByName(keyWord)); |
| | | queryResults.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null)); |
| | | queryResults.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null)); |
| | | return queryResults; |
| | | } |
| | | |
| | |
| | | } |
| | | 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; |
| | | } |
| | |
| | | <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> |
| | |
| | | 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> |