活动积分优化相关代码提交

puhanshu

2021-10-22 f8b116ce4c5edea7e33c31347d2065ce33fa5f53

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbActivityMemberDAO.java

@@ -2,8 +2,6 @@

import java.util.List;

import com.panzhihua.common.model.vos.community.ActivitySignInRecordVO;
import com.panzhihua.common.model.vos.community.ComActActRegistVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -34,13 +32,13 @@
    // " </where>" +
    // "</script>")

//    @Select("<script>  " + "SELECT " + " m.id," + " m.NAME," + " u.phone," + " m.create_at registrationTime" + " FROM "
//        + " com_pb_activity_member m " + " LEFT JOIN sys_user u ON m.user_id = u.user_id " + "WHERE "
//        + "m.activity_id = #{pageActivityMembersVO.activityId} "
//        + "<if test='pageActivityMembersVO.name != null and pageActivityMembersVO.name.trim() != &quot;&quot;'>"
//        + "AND m.`name` = #{pageActivityMembersVO.name} " + " </if> "
//        + "<if test='pageActivityMembersVO.phone != null and pageActivityMembersVO.phone.trim() != &quot;&quot;'>"
//        + "AND u.phone = #{pageActivityMembersVO.phone}" + " </if> " + "</script>")
    @Select("<script>  " + "SELECT " + " m.id," + " m.NAME," + " u.phone," + " m.create_at registrationTime" + " FROM "
        + " com_pb_activity_member m " + " LEFT JOIN sys_user u ON m.user_id = u.user_id " + "WHERE "
        + "m.activity_id = #{pageActivityMembersVO.activityId} "
        + "<if test='pageActivityMembersVO.name != null and pageActivityMembersVO.name.trim() != &quot;&quot;'>"
        + "AND m.`name` = #{pageActivityMembersVO.name} " + " </if> "
        + "<if test='pageActivityMembersVO.phone != null and pageActivityMembersVO.phone.trim() != &quot;&quot;'>"
        + "AND u.phone = #{pageActivityMembersVO.phone}" + " </if> " + "</script>")
    IPage<PageActivityMembersVO> pageActivityMembers(Page page,
        @Param("pageActivityMembersVO") PageActivityMembersVO pageActivityMembersVO);

@@ -58,33 +56,4 @@

    @Select("select type from sys_user where user_id=#{createBy}")
    LoginUserInfoVO selectUserInfo(Long createBy);

    /**
     * 活动签到记录
     * @param id 党员活动主键
     * @param userId 用户id
     * @return
     */
    List<ComActActRegistVO> listRegistRecord(@Param("id") Long id, @Param("userId") Long userId);

    /**
     * 活动报名签到情况
     * @param id 党员活动主键
     * @return
     */
    List<ActivitySignInRecordVO> listSignInRecord(@Param("id") Long id);

    /**
     * 获取用户活动报名记录
     * @param userId
     * @return
     */
    List<PageActivityMembersVO> selectList(@Param("userId") Long userId);

    /**
     * 新增党员活动二维码数据
     * @param id 党员活动id
     * @return
     */
    int insertComActActivityCode(@Param("id") Long id);
}