| | |
| | | @ApiOperation(value = "分页获取热门商家", response = ConvenientMerchantVO.class) |
| | | @PostMapping("/merchant/popular") |
| | | public R getPopularMerchants(@RequestBody @Valid PagePopularMerchantDTO pagePopularMerchantDTO) { |
| | | pagePopularMerchantDTO.setAreaCode(this.getAreaCode()); |
| | | return communityService.getPopularMerchants(pagePopularMerchantDTO); |
| | | } |
| | | |
| | |
| | | @Min(value = 1) |
| | | private Long pageSize; |
| | | |
| | | private String areaCode; |
| | | |
| | | } |
| | |
| | | SELECT * FROM ( |
| | | SELECT id, `name`, consultation_volume, view_num |
| | | FROM com_convenient_merchants |
| | | WHERE (community_id = ${pagePopularMerchantDTO.communityId} OR community_id = 0) AND is_del = 0 ORDER BY (consultation_volume + consultation_volume) DESC LIMIT 100 |
| | | WHERE area_code=#{areaCode} and (community_id = ${pagePopularMerchantDTO.communityId} OR community_id = 0) AND is_del = 0 ORDER BY (consultation_volume + consultation_volume) DESC LIMIT 100 |
| | | ) temp |
| | | </select> |
| | | <select id="getIndexMerchantBaseData" |