From 783636b8af8b5309ad1e6f1598aed7df10bebb63 Mon Sep 17 00:00:00 2001 From: wuzeyu <1223318623@qq.com> Date: 星期五, 23 八月 2024 15:17:25 +0800 Subject: [PATCH] 修改用户分页查询接口一个用户两个角色会出现两条数据的bug --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java | 151 ++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 116 insertions(+), 35 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java index ef40bf5..0721be2 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java @@ -2,11 +2,18 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoBa.BaUser; +import com.dy.pipIrrGlobal.pojoPr.PrController; +import com.dy.pipIrrGlobal.voBa.VoUserInfo; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; +import java.util.List; +import java.util.Map; + @Mapper public interface BaUserMapper extends BaseMapper<BaUser> { + + BaUser selectByPrimaryKey(Long id); /** * 鐢ㄦ埛鐧诲綍 @@ -17,39 +24,113 @@ BaUser login(@Param("phone") String phone, @Param("password") String password) ; -// -// /** -// * 鎻掑叆涓�鏉¤褰� -// * @param userPo -// * @return -// */ -// long insertSelective(BaUser userPo); -// -// /** -// * 鎻掑叆涓�鏉¤褰曪紝濡傛灉鍞竴閿啿绐佸垯鏇存柊 -// * @param userPo -// * @return -// */ -// long insertOnDuplicateUpdate(BaUser userPo); -// -// /** -// * 鏇存柊涓�鏉¤褰� -// * @param userPo -// * @return -// */ -// int updateSelective(BaUser userPo); -// -// /** -// * 鎵归噺鎻掑叆 -// * @param userPoList -// * @return -// */ -// int batchInsert(List<BaUser> userPoList); -// -// /** -// * 鎵归噺鏇存柊 -// * @param userPoList -// * @return -// */ -// int batchUpdate(List<BaUser> userPoList); + /** + * 鏌ヨ鎬绘暟 + * @param params 鏌ヨ鏉′欢 + * @return 鎬绘暟 + */ + Long selectTotal(Map<?, ?> params) ; + + /** + * 鍒嗛〉鏌ヨ涓�浜� + * @param params 鏌ヨ鏉′欢 + * @return 瀹炰綋闆嗗悎 + */ + List<BaUser> selectSome(Map<?, ?> params) ; + + + /** + * insert record to table + * @param record the record + * @return insert count + */ + int putin(BaUser record); + + /** + * insert record to table selective + * @param record the record + * @return insert count + */ + int insertSelective(BaUser record); + + + /** + * update record selective + * @param record the updated record + * @return update count + */ + int updateByPrimaryKeySelective(BaUser record); + + /** + * update record + * @param record the updated record + * @return update count + */ + int updateByPrimaryKey(BaUser record); + + /** + * update record + * @param id 瀹炰綋ID + * @param password 鏂板瘑鐮� + * @return update count + */ + int changePassword(@Param("id") Long id, @Param("password") String password) ; + + /** + * delete by primary key + * @param id primaryKey + * @return deleteCount + */ + int deleteByPrimaryKey(Long id); + + /** + * 閫昏緫鍒犻櫎 + * @param id primaryKey + * @return update count + */ + int deleteLogicById(Long id); + + /** + * 鏍规嵁鐢ㄦ埛缂栧彿鑾峰彇鐢ㄦ埛淇℃伅 + * @param userId 鐢ㄦ埛缂栧彿 + * @return 鐢ㄦ埛淇℃伅鍒楄〃 + * 2024-01-09 搴熷純 + */ + List<VoUserInfo> getUserInfos(@Param("userId") Long userId); + + /** + * 鏍规嵁鐢ㄦ埛缂栧彿鑾峰彇鐢ㄦ埛淇℃伅 + * @param userId + * @return + */ + Map getUserInfoById(@Param("userId") Long userId); + + /** + * 鏍规嵁鎸囧畾鐨勬潯浠惰幏鍙栫敤鎴疯褰曟暟 + * @param params + * @return + */ + Long getRecordCount(Map<?, ?> params); + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鐢ㄦ埛鍒楄〃 + * @param params + * @return + */ + List<VoUserInfo> getUsers(Map<?, ?> params); + + /** + * 鏍规嵁鐢ㄦ埛缂栧彿鑾峰彇瑙掕壊ID鍒楄〃 + * @param userId + * @return + */ + List<Map<String, Object>> getRoleIdsByUserId(@Param("userId") Long userId); + + /** + * getRoleNamesByUserId + * @param userId + * @return + */ + List<Map<String, Object>> getRoleNamesByUserId(@Param("userId") Long userId); + } -- Gitblit v1.8.0