From f92107718d728a2bfa6e7bb3127007586616d5ee Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Mon, 28 Apr 2025 11:41:26 +0800 Subject: [PATCH] feat(mall): 添加活动评价功能 --- src/main/resources/mapper/modules/HappyActivityOptionMapper.xml | 27 +++++++++ src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java | 11 ++- src/main/java/cc/mrbird/febs/mall/service/HappyActivityService.java | 5 + src/main/java/cc/mrbird/febs/mall/mapper/HappyActivityMapper.java | 6 ++ src/main/java/cc/mrbird/febs/mall/controller/activity/ApiHappyActivityController.java | 12 ++++ src/main/java/cc/mrbird/febs/mall/dto/activity/ApiActivityCommentDto.java | 28 +++++++++ src/main/java/cc/mrbird/febs/mall/vo/activity/ApiActivityCommentVo.java | 45 +++++++++++++++ 7 files changed, 130 insertions(+), 4 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/controller/activity/ApiHappyActivityController.java b/src/main/java/cc/mrbird/febs/mall/controller/activity/ApiHappyActivityController.java index 9361c27..fcc0f4b 100644 --- a/src/main/java/cc/mrbird/febs/mall/controller/activity/ApiHappyActivityController.java +++ b/src/main/java/cc/mrbird/febs/mall/controller/activity/ApiHappyActivityController.java @@ -3,11 +3,13 @@ import cc.mrbird.febs.common.annotation.Limit; import cc.mrbird.febs.common.entity.FebsResponse; import cc.mrbird.febs.mall.dto.*; +import cc.mrbird.febs.mall.dto.activity.ApiActivityCommentDto; import cc.mrbird.febs.mall.dto.activity.ApiOperateValidRegisterActivityDto; import cc.mrbird.febs.mall.dto.activity.ApiVoteOptionInPageDto; import cc.mrbird.febs.mall.dto.activity.ApiVoteOptionRecordInPageDto; import cc.mrbird.febs.mall.service.HappyActivityService; import cc.mrbird.febs.mall.vo.*; +import cc.mrbird.febs.mall.vo.activity.ApiActivityCommentVo; import cc.mrbird.febs.mall.vo.activity.ApiVoteActivityHotVo; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -48,6 +50,16 @@ return happyActivityService.activityInfo(dto); } + + @ApiOperation(value = "活动评价", notes = "活动评价") + @ApiResponses({ + @ApiResponse(code = 200, message = "success", response = ApiActivityCommentVo.class) + }) + @PostMapping(value = "/commentByActivityId") + public FebsResponse commentByActivityId(@RequestBody ApiActivityCommentDto dto) { + return new FebsResponse().success().data(happyActivityService.commentByActivityId(dto)); + } + @ApiOperation(value = "点赞关注转发", notes = "点赞关注转发") @PostMapping(value = "/operateDo") public FebsResponse operateDo(@RequestBody @Validated ApiOperateDoDto dto) { diff --git a/src/main/java/cc/mrbird/febs/mall/dto/activity/ApiActivityCommentDto.java b/src/main/java/cc/mrbird/febs/mall/dto/activity/ApiActivityCommentDto.java new file mode 100644 index 0000000..2b4d301 --- /dev/null +++ b/src/main/java/cc/mrbird/febs/mall/dto/activity/ApiActivityCommentDto.java @@ -0,0 +1,28 @@ +package cc.mrbird.febs.mall.dto.activity; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import javax.validation.constraints.NotBlank; +import javax.validation.constraints.NotNull; + +@Data +@ApiModel(value = "ApiActivityCommentDto", description = "参数") +public class ApiActivityCommentDto { + + + @ApiModelProperty(value = "页码", example = "1") + private Integer pageNow; + + @ApiModelProperty(value = "每页数量", example = "10") + private Integer pageSize; + + + @NotNull(message = "活动ID不能为空") + @ApiModelProperty(value = "活动ID", example = "1") + private Long activityId; + + @ApiModelProperty(value = "评价等级", example = "1:好评2:中评3:差评") + private Integer commentType; +} diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/HappyActivityMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/HappyActivityMapper.java index 1fc8969..48e9b32 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/HappyActivityMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/HappyActivityMapper.java @@ -1,6 +1,7 @@ package cc.mrbird.febs.mall.mapper; import cc.mrbird.febs.mall.dto.activity.AdminHappyActivityOrderDto; +import cc.mrbird.febs.mall.dto.activity.ApiActivityCommentDto; import cc.mrbird.febs.mall.dto.activity.ApiVoteOptionInPageDto; import cc.mrbird.febs.mall.dto.activity.ApiVoteOptionRecordInPageDto; import cc.mrbird.febs.mall.entity.HappyActivity; @@ -10,9 +11,12 @@ import cc.mrbird.febs.mall.dto.ApiVoteRecordInPageDto; import cc.mrbird.febs.mall.vo.ApiActivityOptionListVo; import cc.mrbird.febs.mall.vo.ApiVoteRecordInPageVo; +import cc.mrbird.febs.mall.vo.activity.ApiActivityCommentVo; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.ibatis.annotations.Param; + +import java.util.List; public interface HappyActivityMapper extends BaseMapper<HappyActivity> { @@ -29,4 +33,6 @@ Page<HappyActivityOrder> selectOrderInPage(Page<HappyActivityOrder> page, @Param("record")AdminHappyActivityOrderDto dto); Page<ApiActivityOptionListVo> getVoteOptionRecordInPage(Page<ApiActivityOptionListVo> page, @Param("record")ApiVoteOptionRecordInPageDto dto); + + List<ApiActivityCommentVo> selectActivityCommentPage(Page<ApiActivityCommentVo> page, @Param("record")ApiActivityCommentDto dto); } diff --git a/src/main/java/cc/mrbird/febs/mall/service/HappyActivityService.java b/src/main/java/cc/mrbird/febs/mall/service/HappyActivityService.java index 99842c4..ee17b5c 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/HappyActivityService.java +++ b/src/main/java/cc/mrbird/febs/mall/service/HappyActivityService.java @@ -7,7 +7,10 @@ import cc.mrbird.febs.mall.dto.ApiOperateDoDto; import cc.mrbird.febs.mall.dto.ApiOperateVoteDto; import cc.mrbird.febs.mall.dto.ApiVoteRecordInPageDto; +import cc.mrbird.febs.mall.vo.activity.ApiActivityCommentVo; import com.baomidou.mybatisplus.extension.service.IService; + +import java.util.List; public interface HappyActivityService extends IService<HappyActivity> { @@ -70,4 +73,6 @@ void overtimeJob(); FebsResponse addComment(ApiPayOrderAddCommentDto dto); + + List<ApiActivityCommentVo> commentByActivityId(ApiActivityCommentDto dto); } diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java index 27f52ae..6f755cb 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/HappyActivityServiceImpl.java @@ -14,10 +14,7 @@ import cc.mrbird.febs.mall.service.IApiMallMemberWalletService; import cc.mrbird.febs.mall.vo.*; import cc.mrbird.febs.mall.dto.ApiOperateDoDto; -import cc.mrbird.febs.mall.vo.activity.ApiActivityOrderInfoVo; -import cc.mrbird.febs.mall.vo.activity.ApiActivityOrderListVo; -import cc.mrbird.febs.mall.vo.activity.ApiCheckOrderVo; -import cc.mrbird.febs.mall.vo.activity.ApiVoteActivityHotVo; +import cc.mrbird.febs.mall.vo.activity.*; import cc.mrbird.febs.pay.model.BrandWCPayRequestData; import cc.mrbird.febs.pay.service.IXcxPayService; import cc.mrbird.febs.rabbit.producter.AgentProducer; @@ -966,6 +963,12 @@ } @Override + public List<ApiActivityCommentVo> commentByActivityId(ApiActivityCommentDto dto) { + Page<ApiActivityCommentVo> page = new Page<>(dto.getPageNow(), dto.getPageSize()); + return this.baseMapper.selectActivityCommentPage(page,dto); + } + + @Override public FebsResponse voteActivityHot(Long id) { ApiVoteActivityHotVo apiVoteActivityHotVo = new ApiVoteActivityHotVo(); diff --git a/src/main/java/cc/mrbird/febs/mall/vo/activity/ApiActivityCommentVo.java b/src/main/java/cc/mrbird/febs/mall/vo/activity/ApiActivityCommentVo.java new file mode 100644 index 0000000..1de6ac4 --- /dev/null +++ b/src/main/java/cc/mrbird/febs/mall/vo/activity/ApiActivityCommentVo.java @@ -0,0 +1,45 @@ +package cc.mrbird.febs.mall.vo.activity; + +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +@Data +@ApiModel(value = "ApiActivityCommentVo", description = "参数") +public class ApiActivityCommentVo { + + + @ApiModelProperty(value = "头像") + private String avatar; + + @ApiModelProperty(value = "名称") + private String name; + + @ApiModelProperty(value = "评价时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + private Date createdTime; + + @ApiModelProperty(value = "评分 4.0") + private Double star; + + @ApiModelProperty(value = "评论") + private String comment; + + @ApiModelProperty(value = "图片") + private String images; + + @ApiModelProperty(value = "是否匿名评价 1:匿名 2:不匿名") + private Integer anonymousState; + + @ApiModelProperty(value = "好评 大于四星") + private Integer greatNum; + + @ApiModelProperty(value = "好评 大于三星小于四星") + private Integer goodNum; + + @ApiModelProperty(value = "差评 小于三星") + private Integer badNum; +} diff --git a/src/main/resources/mapper/modules/HappyActivityOptionMapper.xml b/src/main/resources/mapper/modules/HappyActivityOptionMapper.xml index 767b05a..2caf60b 100644 --- a/src/main/resources/mapper/modules/HappyActivityOptionMapper.xml +++ b/src/main/resources/mapper/modules/HappyActivityOptionMapper.xml @@ -136,4 +136,31 @@ order by a.likes_cnt desc </select> + <select id="selectActivityCommentPage" resultType="cc.mrbird.febs.mall.vo.activity.ApiActivityCommentVo"> + select + a.*, + b.name name, + b.avatar avatar + from happy_activity_comment a + left join mall_member b on b.id = a.member_id + <where> + <if test="record != null"> + <if test="record.activityId != null and record.activityId != ''"> + and a.activity_id = #{record.activityId} + </if> + <if test="record.commentType != null and record.commentType != '' and record.commentType == 1"> + and a.star <![CDATA[ > ]]> 4 + </if> + <if test="record.commentType != null and record.commentType != '' and record.commentType == 2"> + and (a.star <![CDATA[ >= ]]> 3 and a.star <![CDATA[ <= ]]> 4) + </if> + <if test="record.commentType != null and record.commentType != '' and record.commentType == 3"> + and (a.star <![CDATA[ < ]]> 3 ) + </if> + </if> + </where> + group by a.id + order by a.created_time desc + </select> + </mapper> \ No newline at end of file -- Gitblit v1.9.1