From 04821fd724cc279ae6d41f968f79c767cfd9233e Mon Sep 17 00:00:00 2001 From: wuzeyu <1223318623@qq.com> Date: 星期四, 12 九月 2024 17:17:55 +0800 Subject: [PATCH] 优化代码 指定时间段内开阀次数高于指定值的农户 指定时间段内开阀次数低于指定值的农户 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java | 139 ++++++++++++++++++++++++++++++++++------------ 1 files changed, 103 insertions(+), 36 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 af709fd..1a4779b 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 @@ -1,8 +1,9 @@ package com.dy.pipIrrGlobal.daoBa; import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.dy.pipIrrGlobal.pojoBa.BaBlock; 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; @@ -11,6 +12,8 @@ @Mapper public interface BaUserMapper extends BaseMapper<BaUser> { + + BaUser selectByPrimaryKey(Long id); /** * 鐢ㄦ埛鐧诲綍 @@ -36,39 +39,103 @@ List<BaUser> selectSome(Map<?, ?> params) ; -// -// /** -// * 鎻掑叆涓�鏉¤褰� -// * @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); + /** + * 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); + + /** + * 寰楀埌鎵�鏈夋墜鏈哄彿(鐧诲綍璐﹀彿) + * @return + */ + List<String> getPhones(); } -- Gitblit v1.8.0