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 | 159 +++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 123 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 a88c072..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,11 +1,19 @@ package com.dy.pipIrrGlobal.daoBa; +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 com.baomidou.mybatisplus.core.mapper.Mapper<BaUser> { +public interface BaUserMapper extends BaseMapper<BaUser> { + + BaUser selectByPrimaryKey(Long id); /** * 鐢ㄦ埛鐧诲綍 @@ -16,39 +24,118 @@ 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); + + /** + * 寰楀埌鎵�鏈夋墜鏈哄彿(鐧诲綍璐﹀彿) + * @return + */ + List<String> getPhones(); } -- Gitblit v1.8.0