| | |
| | | "<if test='loginUserInfoVO.phone != null and loginUserInfoVO.phone.trim() != ""'>" + |
| | | "AND u.phone like concat(#{loginUserInfoVO.phone},'%') " + |
| | | " </if> " + |
| | | " order by u.user_id desc " + |
| | | "</script>") |
| | | IPage<LoginUserInfoVO> pageUser(Page page, @Param("loginUserInfoVO") LoginUserInfoVO loginUserInfoVO); |
| | | |
| | |
| | | "u.continuous_landing_days + 1,\n" + |
| | | "0)") |
| | | int timedTaskContinuousLandingDays(); |
| | | @Select("select state from com_mng_volunteer_mng where phone=#{phone} order by create_at desc limit 1") |
| | | @Select("select id,create_at,state,name,phone,photo_path,political_face,reject_reson,apply_reson,address,age,job,integral,community_id,submit_user_id " + |
| | | " from com_mng_volunteer_mng where phone=#{phone} order by create_at desc limit 1") |
| | | ComMngVolunteerMngVO selectVolunteerMngByPhone(String phone); |
| | | @Update("update sys_user set face_state=null where user_id=#{userId}") |
| | | int updateFaceState(Long userId); |
| | |
| | | " card_photo_front = #{userArchivesVO.cardPhotoFront} \n" + |
| | | ", card_photo_back = #{userArchivesVO.cardPhotoBack} \n" + |
| | | ",family_book = #{userArchivesVO.familyBook} \n" + |
| | | ",job = #{userArchivesVO.job} \n" + |
| | | " where user_id = #{userArchivesVO.userId}") |
| | | void updateUserArchives(@Param("userArchivesVO") UpdateUserArchivesVO userArchivesVO); |
| | | |