From 7fa292ef97ba73d89e02a15da4c35a8a32de1a92 Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期一, 13 九月 2021 16:47:07 +0800 Subject: [PATCH] 修改活动报名bug --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml | 2 +- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActEvaluateDAO.java | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActEvaluateDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActEvaluateDAO.java index bacb023..e740e0e 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActEvaluateDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActEvaluateDAO.java @@ -28,8 +28,20 @@ List<ComActActEvaluateExcelVO> getEvaluateLists(@Param("comActActEvaluateVO") ComActActEvaluateVO comActActEvaluateVO); + /** + * 分页查询活动评价列表 + * @param page 分页参数 + * @param activityId 活动id + * @return 活动评价列表 + */ IPage<ComActActEvaluateVO> getEvaluateListPage(Page page, @Param("activityId") Long activityId); + /** + * 查询某活动的用户评价 + * @param activityId 活动id + * @param userId 用户id + * @return 用户评价记录 + */ ComActActEvaluateVO getEvaluateListByUserId(@Param("activityId") Long activityId,@Param("userId") Long userId); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml index 0237169..ca8c565 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml @@ -47,7 +47,7 @@ AND su.`name` = #{comActActRegistVO.name} </if> <if test="comActActRegistVO.tags != null and comActActRegistVO.tags !=''"> - AND su.tags like ('%', #{comActActRegistVO.tags}, '%') + AND su.tags like concat ('%', #{comActActRegistVO.tags}, '%') </if> <if test="comActActRegistVO.createAt != null"> AND caar.create_at = #{comActActRegistVO.createAt} -- Gitblit v1.7.1