| | |
| | | } |
| | | comActDynVO.setIsTopping(null); |
| | | comActDynVO.setStatus(1); |
| | | comActDynVO.setAreaCode(this.getAreaCode()); |
| | | return communityService.pageDynamic(comActDynVO); |
| | | } |
| | | |
| | |
| | | @ApiOperation(value = "办事指南_分页", response = ComActWorkGuideVO.class) |
| | | @PostMapping("pageworkguide") |
| | | public R detailWorkGuide(@RequestBody PageActWorkGuideDTO pageActWorkGuideDTO) { |
| | | pageActWorkGuideDTO.setAreaCode(this.getAreaCode()); |
| | | return communityService.pageWorkGuide(pageActWorkGuideDTO); |
| | | } |
| | | |
| | |
| | | @ApiOperation(value = "办事指南列表-按分类查询", response = ComActWorkGuideAppletsVO.class) |
| | | @PostMapping("list") |
| | | public R listWorkGuide(@RequestBody PageActWorkGuideDTO pageActWorkGuideDTO) { |
| | | pageActWorkGuideDTO.setAreaCode(this.getAreaCode()); |
| | | return communityService.listWorkGuide(pageActWorkGuideDTO); |
| | | } |
| | | |
| | |
| | | |
| | | @ApiModelProperty("跳转状态") |
| | | private Integer jumpType; |
| | | |
| | | private String areaCode; |
| | | } |
| | |
| | | + "LEFT JOIN com_act_dyn_type as cadt ON cadt.id = d.type " |
| | | + "LEFT JOIN com_act ca ON d.community_id = ca.community_id " + "WHERE 1=1 " |
| | | + "<if test='comActDynVO.choice == 0 '>" + "and d.community_id = ${comActDynVO.communityId} " + " </if> " |
| | | + "<if test='comActDynVO.areaCode !=null '>" + "and ca.area_code = ${comActDynVO.areaCode} " + " </if> " |
| | | + "<if test='comActDynVO.title != null and comActDynVO.title.trim() != ""'>" |
| | | + "AND d.title like concat(#{comActDynVO.title},'%') " + " </if> " |
| | | + "<if test='comActDynVO.isTopping != null '>" + "AND d.is_topping = #{comActDynVO.isTopping} " + " </if> " |
| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO; |
| | | import com.panzhihua.common.model.dtos.community.PageActWorkGuideDTO; |
| | | import com.panzhihua.common.model.vos.community.ComActWorkGuideAppletsVO; |
| | | import com.panzhihua.common.model.vos.community.ComActWorkGuideClassifyVO; |
| | | import com.panzhihua.common.model.vos.community.ComMngPopulationVO; |
| | |
| | | * 查询办事指南分类列表 |
| | | * @return 办事指南分类列表 |
| | | */ |
| | | List<ComActWorkGuideAppletsVO> listWorkGuideClassify(); |
| | | List<ComActWorkGuideAppletsVO> listWorkGuideClassify(PageActWorkGuideDTO pageActWorkGuideDTO); |
| | | |
| | | } |
| | |
| | | //结果数据集合 |
| | | List<ComActWorkGuideAppletsVO> resultList = new ArrayList<>(); |
| | | |
| | | List<ComActWorkGuideAppletsVO> workGuideClassifyList = comActWorkGuideClassifyDAO.listWorkGuideClassify(); |
| | | List<ComActWorkGuideAppletsVO> workGuideClassifyList = comActWorkGuideClassifyDAO.listWorkGuideClassify(pageActWorkGuideDTO); |
| | | //通过办事指南分类查询分类下办事指南 |
| | | workGuideClassifyList.forEach(workGuideClassify -> { |
| | | List<ComActWorkGuideDetailAppletsVO> workGuideList = this.baseMapper.getWorkGuideListByClassifyId(workGuideClassify.getId(),10L); |
| | |
| | | AND classify_name like concat ('%', #{comActWorkGuideClassifyVO.classifyName}, '%') |
| | | </if> |
| | | <if test="comActWorkGuideClassifyVO.areaCode != null and comActWorkGuideClassifyVO.areaCode !=''"> |
| | | AND area_code = #{comActWorkGuideClassifyVO.classifyName} |
| | | AND area_code = #{comActWorkGuideClassifyVO.areaCode} |
| | | </if> |
| | | </where> |
| | | order by create_at desc |
| | |
| | | SELECT cawgc.id, cawgc.classify_name, cawgc.picture_url,( SELECT count( id ) FROM com_act_work_guide WHERE classify = cawgc.id ) AS `count` |
| | | FROM |
| | | com_act_work_guide_classify AS cawgc |
| | | <where> |
| | | <if test="areaCode!=null"> |
| | | and cawgc.area_code = #{area_code} |
| | | </if> |
| | | </where> |
| | | order by `count` asc |
| | | </select> |
| | | |