From 4af1e0cab60c25d6c969474b3517b33e2ebcbb9c Mon Sep 17 00:00:00 2001 From: luodangjia <luodangjia> Date: 星期六, 26 十月 2024 17:47:48 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/TAppUserServiceImpl.java | 9 ++ ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java | 12 ++++ ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java | 4 ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/SiteController.java | 9 ++ ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml | 16 +--- ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/RptUtils.java | 33 +++++++++++ ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TAccountingStrategyDetailController.java | 44 ++++++++++---- ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java | 3 ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java | 26 ++++---- ruoyi-service/ruoyi-chargingPile/src/main/resources/logback.xml | 4 ruoyi-service/ruoyi-order/src/main/resources/logback.xml | 4 11 files changed, 117 insertions(+), 47 deletions(-) diff --git a/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java b/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java index 7117147..d85c948 100644 --- a/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java +++ b/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java @@ -14,7 +14,7 @@ @ApiModelProperty(value = "类型(1=开始,2=结束)") private Integer type; @ApiModelProperty(value = "站点ids 选择全部 不传") - private List<Integer> siteIds; + private Integer siteIds; @ApiModelProperty(value = "合作商id ") private Integer partnerId; @ApiModelProperty(value = "开始时间2020-01-01 00:00:00") @@ -22,4 +22,5 @@ @ApiModelProperty(value = "结束时间2021-01-01 23:59:59") private String endTime; + } diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/TAppUserServiceImpl.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/TAppUserServiceImpl.java index 72656e7..bd17572 100644 --- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/TAppUserServiceImpl.java +++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/TAppUserServiceImpl.java @@ -11,6 +11,7 @@ import com.ruoyi.account.mapper.TAppUserMapper; import com.ruoyi.account.service.TAppUserService; import com.ruoyi.account.service.TInviteUserService; +import com.ruoyi.account.util.RptUtils; import com.ruoyi.account.wx.model.WeixinProperties; import com.ruoyi.account.wx.pojo.AppletUserDecodeData; import com.ruoyi.common.core.exception.ServiceException; @@ -18,6 +19,7 @@ import com.ruoyi.system.api.model.LoginUserApplet; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.util.StringUtils; import org.springframework.web.client.RestTemplate; import java.util.HashMap; @@ -69,9 +71,10 @@ break; } } - appUser.setAvatar(appletUserDecodeData.getAvatarUrl()); + + appUser.setAvatar(StringUtils.hasLength(appletUserDecodeData.getAvatarUrl())?appletUserDecodeData.getAvatarUrl():"http://221.182.45.100:8090/2024-10-26/logo.png"); + appUser.setName(StringUtils.hasLength(appletUserDecodeData.getNickName())?appletUserDecodeData.getNickName():RptUtils.around(appletUserDecodeData.getPhoneNumber(),3,4)); appUser.setCity(appletUserDecodeData.getCity()); - appUser.setName(appletUserDecodeData.getNickName()); appUser.setProvince(appletUserDecodeData.getProvince()); appUser.setWxOpenid(appletUserDecodeData.getOpenId()); this.saveOrUpdate(appUser); @@ -113,6 +116,8 @@ } } appUser.setAliOpenid(response.getOpenId()); + appUser.setAvatar("http://221.182.45.100:8090/2024-10-26/logo.png"); + appUser.setName(RptUtils.around(phone,3,4)); this.saveOrUpdate(appUser); if(Objects.nonNull(inviteUserId)){ inviteUserService.saveInviteUser(appUser.getId(), inviteUserId); diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java index 2ac66fd..3da1a3f 100644 --- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java +++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java @@ -877,91 +877,91 @@ " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京B\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京C\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京D\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京E\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京F\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京G\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京H\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京J\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京K\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京L\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京M\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京Y\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + - " \"AreaCode\": \"110110\"\n" + + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"豫A\",\n" + diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/RptUtils.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/RptUtils.java new file mode 100644 index 0000000..41e207a --- /dev/null +++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/RptUtils.java @@ -0,0 +1,33 @@ +package com.ruoyi.account.util; + +/** + * 脱敏工具类 + */ +public class RptUtils { + private static final String SYMBOL = "*"; + + /** + * 脱敏 + * @param str 待脱敏字符串 + * @param left 左边保留多少位 + * @param right 右边保留多少位 + * @return 脱敏结果,除左右外,其余字符将被替换为* + */ + public static String around(String str, int left, int right){ + if (str == null || (str.length() < left + right +1)){ + return str; + } + String regex = String.format("(?<=\\w{%d})\\w(?=\\w{%d})", left, right); + return str.replaceAll(regex, SYMBOL); + } + + /** + * 正则表达式实现金额数据脱敏 + * @param money + * @return + */ + public static String getMoney(String money){ + //保留0个数到0个结束 + return around(money,0,0); + } + } \ No newline at end of file diff --git a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/SiteController.java b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/SiteController.java index 0ce1585..dbd0aa4 100644 --- a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/SiteController.java +++ b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/SiteController.java @@ -18,6 +18,7 @@ import com.ruoyi.common.core.dto.ChargingPercentProvinceDto; import com.ruoyi.chargingPile.service.*; import com.ruoyi.common.core.domain.R; +import com.ruoyi.common.core.utils.DateUtils; import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.web.domain.AjaxResult; import com.ruoyi.common.core.web.page.PageInfo; @@ -125,9 +126,11 @@ Site byId = siteService.getById(one.getSiteId()); TAccountingStrategy byId1 = accountingStrategyService.getById(byId.getAccountingStrategyId()); List<TAccountingStrategyDetail> list = accountingStrategyDetailService.lambdaQuery().eq(TAccountingStrategyDetail::getAccountingStrategyId, byId1.getId()).list(); + list.stream().filter(item -> "00:00".equals(item.getEndTime())).forEach(item -> item.setEndTime("23:59:59")); for (TAccountingStrategyDetail tAccountingStrategyDetail : list) { // 当前时间属于那个阶段 取哪个阶段的电价 - if(LocalTime.now().isAfter(LocalTime.parse(tAccountingStrategyDetail.getStartTime())) && LocalTime.now().isBefore(LocalTime.parse(tAccountingStrategyDetail.getEndTime()))){ + if(DateUtils.string2LocalTime(tAccountingStrategyDetail.getStartTime() + ":00").compareTo(LocalTime.now()) <= 0 + && DateUtils.string2LocalTime(tAccountingStrategyDetail.getEndTime() + ("23:59:59".equals(tAccountingStrategyDetail.getEndTime())?"":":00")).compareTo(LocalTime.now()) > 0){ siteInfoVO.setElectrovalence(tAccountingStrategyDetail.getElectrovalence().add(tAccountingStrategyDetail.getServiceCharge()).setScale(4, BigDecimal.ROUND_HALF_UP)); if(null != byId1.getDiscount()){ siteInfoVO.setVipElectrovalence((tAccountingStrategyDetail.getServiceCharge().multiply(byId1.getDiscount()).add(tAccountingStrategyDetail.getElectrovalence())).setScale(4, BigDecimal.ROUND_HALF_UP)); @@ -168,9 +171,11 @@ Site byId = siteService.getById(one.getSiteId()); TAccountingStrategy byId1 = accountingStrategyService.getById(byId.getAccountingStrategyId()); List<TAccountingStrategyDetail> list = accountingStrategyDetailService.lambdaQuery().eq(TAccountingStrategyDetail::getAccountingStrategyId, byId1.getId()).list(); + list.stream().filter(item -> "00:00".equals(item.getEndTime())).forEach(item -> item.setEndTime("23:59:59")); for (TAccountingStrategyDetail tAccountingStrategyDetail : list) { // 当前时间属于那个阶段 取哪个阶段的电价 - if(LocalTime.now().isAfter(LocalTime.parse(tAccountingStrategyDetail.getStartTime())) && LocalTime.now().isBefore(LocalTime.parse(tAccountingStrategyDetail.getEndTime()))){ + if(DateUtils.string2LocalTime(tAccountingStrategyDetail.getStartTime() + ":00").compareTo(LocalTime.now()) <= 0 + && DateUtils.string2LocalTime(tAccountingStrategyDetail.getEndTime() + ("23:59:59".equals(tAccountingStrategyDetail.getEndTime())?"":":00")).compareTo(LocalTime.now()) > 0){ siteInfoVO.setElectrovalence(tAccountingStrategyDetail.getElectrovalence().add(tAccountingStrategyDetail.getServiceCharge()).setScale(4, BigDecimal.ROUND_HALF_UP)); if(null != byId1.getDiscount()){ siteInfoVO.setVipElectrovalence((tAccountingStrategyDetail.getServiceCharge().multiply(byId1.getDiscount()).add(tAccountingStrategyDetail.getElectrovalence())).setScale(4, BigDecimal.ROUND_HALF_UP)); diff --git a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TAccountingStrategyDetailController.java b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TAccountingStrategyDetailController.java index 3bd8ac6..9d81853 100644 --- a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TAccountingStrategyDetailController.java +++ b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TAccountingStrategyDetailController.java @@ -10,12 +10,14 @@ import com.ruoyi.chargingPile.service.*; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.exception.ServiceException; +import com.ruoyi.common.core.utils.DateUtils; import com.ruoyi.common.core.web.domain.AjaxResult; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; +import java.time.LocalTime; import java.util.List; import java.util.Objects; @@ -100,10 +102,16 @@ public R<TAccountingStrategyDetail> getDetailBySiteId(@RequestParam("siteId") Integer siteId){ Site site = siteService.getById(siteId); TAccountingStrategy accountingStrategy = accountingStrategyService.getById(site.getAccountingStrategyId()); - TAccountingStrategyDetail one = accountingStrategyDetailService.getOne(Wrappers.<TAccountingStrategyDetail>lambdaQuery() - .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId()) - .last(" and DATE_FORMAT(now(), '%H:%i') between start_time and end_time")); - return R.ok(one); + List<TAccountingStrategyDetail> list = accountingStrategyDetailService.list(Wrappers.<TAccountingStrategyDetail>lambdaQuery() + .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId())); + list.stream().filter(item -> "00:00".equals(item.getEndTime())).forEach(item -> item.setEndTime("23:59:59")); + for (TAccountingStrategyDetail accountingStrategyDetail : list) { + if(DateUtils.string2LocalTime(accountingStrategyDetail.getStartTime() + ":00").compareTo(LocalTime.now()) <= 0 + && DateUtils.string2LocalTime(accountingStrategyDetail.getEndTime() + ("23:59:59".equals(accountingStrategyDetail.getEndTime())?"":":00")).compareTo(LocalTime.now()) > 0){ + return R.ok(accountingStrategyDetail); + } + } + return R.ok(); } /** * 通过桩id查询当前时段使用的策略明细 @@ -123,19 +131,31 @@ .eq(TChargingGun::getChargingPileId, chargingPile.getId()).eq(TChargingGun::getDelFlag, 0) .last("LIMIT 1")); TAccountingStrategy accountingStrategy = accountingStrategyService.getById(chargingGun.getAccountingStrategyId()); - TAccountingStrategyDetail one; + TAccountingStrategyDetail one = null; if(Objects.nonNull(accountingStrategy)){ - one = accountingStrategyDetailService.getOne(Wrappers.<TAccountingStrategyDetail>lambdaQuery() - .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId()) - .last(" and DATE_FORMAT(now(), '%H:%i') between start_time and end_time")); + List<TAccountingStrategyDetail> list = accountingStrategyDetailService.list(Wrappers.<TAccountingStrategyDetail>lambdaQuery() + .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId())); + list.stream().filter(item -> "00:00".equals(item.getEndTime())).forEach(item -> item.setEndTime("23:59:59")); + for (TAccountingStrategyDetail accountingStrategyDetail : list) { + if(DateUtils.string2LocalTime(accountingStrategyDetail.getStartTime() + ":00").compareTo(LocalTime.now()) <= 0 + && DateUtils.string2LocalTime(accountingStrategyDetail.getEndTime() + ("23:59:59".equals(accountingStrategyDetail.getEndTime())?"":":00")).compareTo(LocalTime.now()) > 0){ + return R.ok(accountingStrategyDetail); + } + } }else { Site site = siteService.getById(chargingPile.getSiteId()); accountingStrategy = accountingStrategyService.getById(site.getAccountingStrategyId()); - one = accountingStrategyDetailService.getOne(Wrappers.<TAccountingStrategyDetail>lambdaQuery() - .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId()) - .last(" and DATE_FORMAT(now(), '%H:%i') between start_time and end_time")); + List<TAccountingStrategyDetail> list = accountingStrategyDetailService.list(Wrappers.<TAccountingStrategyDetail>lambdaQuery() + .eq(TAccountingStrategyDetail::getAccountingStrategyId, accountingStrategy.getId())); + list.stream().filter(item -> "00:00".equals(item.getEndTime())).forEach(item -> item.setEndTime("23:59:59")); + for (TAccountingStrategyDetail accountingStrategyDetail : list) { + if(DateUtils.string2LocalTime(accountingStrategyDetail.getStartTime() + ":00").compareTo(LocalTime.now()) <= 0 + && DateUtils.string2LocalTime(accountingStrategyDetail.getEndTime() + ("23:59:59".equals(accountingStrategyDetail.getEndTime())?"":":00")).compareTo(LocalTime.now()) > 0){ + return R.ok(accountingStrategyDetail); + } + } } - return R.ok(one); + return R.ok(); } /** * 校验充电桩计费模版是否准确 diff --git a/ruoyi-service/ruoyi-chargingPile/src/main/resources/logback.xml b/ruoyi-service/ruoyi-chargingPile/src/main/resources/logback.xml index a1c5267..774e490 100644 --- a/ruoyi-service/ruoyi-chargingPile/src/main/resources/logback.xml +++ b/ruoyi-service/ruoyi-chargingPile/src/main/resources/logback.xml @@ -58,11 +58,11 @@ </appender> <!-- 系统模块日志级别控制 --> - <logger name="com.ruoyi" level="debug" /> + <logger name="com.ruoyi" level="info" /> <!-- Spring日志级别控制 --> <logger name="org.springframework" level="debug" /> - <root level="debug"> + <root level="info"> <appender-ref ref="console" /> </root> diff --git a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java index 9ac5b25..a74b6dc 100644 --- a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java +++ b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java @@ -71,10 +71,10 @@ query.addCriteria(Criteria.where("transaction_serial_number").regex(mongoChargingOrderQuery.getCode(), "i")); // "i" 表示不区分大小写 } if (mongoChargingOrderQuery.getOrderType() !=null){ - query.addCriteria(Criteria.where("order_type").is(mongoChargingOrderQuery.getOrderType())); + query.addCriteria(Criteria.where("orderType").is(mongoChargingOrderQuery.getOrderType())); } if (mongoChargingOrderQuery.getSiteId() != null){ - query.addCriteria(Criteria.where("site_id").is(mongoChargingOrderQuery.getSiteId())); + query.addCriteria(Criteria.where("siteId").is(mongoChargingOrderQuery.getSiteId())); } if (mongoChargingOrderQuery.getChargingPileCode() != null && !mongoChargingOrderQuery.getChargingPileCode().isEmpty()) { query.addCriteria(Criteria.where("charging_pile_code").is(mongoChargingOrderQuery.getChargingPileCode())); diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java index 9440d8d..a5b335c 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java @@ -2435,6 +2435,18 @@ @Override public PageInfo<TSettlementConfirm> settlementList(SettlementListQuery dto) { + if (StringUtils.hasLength(dto.getStartTime())){ + dto.setType(1); + String[] split = dto.getStartTime().split(" - "); + dto.setStartTime(split[0]); + dto.setEndTime(split[1]); + } + if (StringUtils.hasLength(dto.getEndTime())){ + dto.setType(2); + String[] split = dto.getStartTime().split(" - "); + dto.setStartTime(split[0]); + dto.setEndTime(split[1]); + } PageInfo<TSettlementConfirm> pageInfo = new PageInfo<>(dto.getPageCurr(),dto.getPageSize()); List<TSettlementConfirm> list = tSettlementConfirmMapper.settlementList(pageInfo,dto); for (TSettlementConfirm tSettlementConfirm : list) { diff --git a/ruoyi-service/ruoyi-order/src/main/resources/logback.xml b/ruoyi-service/ruoyi-order/src/main/resources/logback.xml index ea899ba..61d523e 100644 --- a/ruoyi-service/ruoyi-order/src/main/resources/logback.xml +++ b/ruoyi-service/ruoyi-order/src/main/resources/logback.xml @@ -60,9 +60,9 @@ <!-- 系统模块日志级别控制 --> <logger name="com.ruoyi" level="info" /> <!-- Spring日志级别控制 --> - <logger name="org.springframework" level="debug" /> + <logger name="org.springframework" level="warn" /> - <root level="debug"> + <root level="info"> <appender-ref ref="console" /> </root> diff --git a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml index cd7c16b..5b7209c 100644 --- a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml +++ b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml @@ -13,28 +13,22 @@ select t1.* from t_settlement_confirm t1 where 1=1 - <if test="req.type != null "> - and t1.type = #{req.type} - </if> <if test="req.partnerId != null "> - and t1.partnerId = #{req.partnerId} + and t1.partner_id = #{req.partnerId} + </if> + <if test="req.siteIds != null "> + and t1.site_id = #{req.siteIds} </if> <if test="req.type == 1 "> <if test="req.startTime != null and req.startTime!=''"> and (t1.start_time between #{req.startTime} and #{req.endTime} </if> </if> - <if test="req.siteIds != null and req.siteIds.size() > 0"> - AND t1.site_id IN - <foreach collection="req.siteIds" item="siteId" open="(" separator="," close=")"> - #{siteId} - </foreach> - </if> <if test="req.type == 2 "> <if test="req.startTime != null and req.startTime!=''"> and (t1.end_time between #{req.startTime} and #{req.endTime} </if> </if> -and t1.del_flag = 0 + and t1.del_flag = 0 </select> </mapper> -- Gitblit v1.7.1