From 2fed5b176458a3776be9ea39ae9bc52c461ca815 Mon Sep 17 00:00:00 2001 From: nickchange <126672920+nickchange@users.noreply.github.com> Date: 星期六, 28 十月 2023 14:33:59 +0800 Subject: [PATCH] 10.28。1 --- cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml | 4 ++-- cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java | 2 +- cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml | 3 +-- cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java | 12 +++++++++++- cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java | 2 +- 5 files changed, 16 insertions(+), 7 deletions(-) diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java index bdb6234..00455c9 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java +++ b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java @@ -706,8 +706,8 @@ consumeDetail.setConsumeName(RechargeRecordEnum.EVENT_REGISTRATION.getMsg()); consumeDetail.setConsumeTime(paymentCompetition.getTime()); consumeDetail.setConsumeAmount("-" + paymentCompetition.getAmount()); + consumeDetail.setType(2); details.add(consumeDetail); - consumeDetail.setType(1); } } // 2.取消赛事报名 diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java index 6315975..d310d4a 100644 --- a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java +++ b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/CompetitionServiceImpl.java @@ -163,7 +163,17 @@ competitionInfo.setAge(competition.getStartAge() + "-" + competition.getEndAge()); competitionInfo.setProvince(competition.getEntryProvince()); competitionInfo.setCity(competition.getEntryCity()); - competitionInfo.setAddress(competition.getEntryAddress()); + String str = competition.getAddress(); + str = str.substring(str.indexOf("省") + 1); + + // 去掉第一个“市”及之前的字符串 + str = str.substring(str.indexOf("市") + 1); + + // 去掉第一个“区”及之前的字符串 + str = str.substring(str.indexOf("区") + 1); + + + competitionInfo.setAddress(str); competitionInfo.setCashPrice(competition.getCashPrice()); competitionInfo.setPlayPaiCoin(competition.getPlayPaiCoin()); competitionInfo.setClassPrice(competition.getClassPrice()); diff --git a/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml b/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml index 9d40a34..afed275 100644 --- a/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml +++ b/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml @@ -37,7 +37,7 @@ SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`, amount from t_payment_competition - where payStatus = 2 and payType = 1 and payType = 2 + where payStatus = 2 and payType in (1,2) <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd"> and DATE_FORMAT(payTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd} </if> @@ -49,7 +49,7 @@ SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`, amount from t_payment_competition - where payStatus = 3 and payType = 1 and payType = 2 + where payStatus = 3 and payType in (1,2) <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd"> and DATE_FORMAT(refundTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd} </if> diff --git a/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml b/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml index da4b78a..0daff8f 100644 --- a/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml +++ b/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml @@ -50,8 +50,7 @@ </select> <select id="billingDataRequestVo" resultType="com.dsh.course.model.BillingRequest"> - SELECT DATE_FORMAT(payTime, '%m-%d %H:%i')as `time`, - amount + SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`,IFNULL(playPaiCoin, cashPayment) AS amount from t_course_package_payment where payStatus = 2 and state = 1 and payType = 3 <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd"> diff --git a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java index f5244ef..8a3ef81 100644 --- a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java +++ b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java @@ -14,7 +14,7 @@ * @date 2023/7/13 16:48 */ public interface SiteBookingMapper extends BaseMapper<SiteBooking> { - List<BillingRequestOfType> queryDatas(Integer appUserId, String monthStart, String monthEnd); + List<BillingRequestOfType> queryDatas(@Param("appUserId")Integer appUserId,@Param("monthStart") String monthStart,@Param("monthEnd") String monthEnd); List<SiteBooking> listAll(@Param("query")SiteBookingQuery query, @Param("sTime")String sTime, @Param("eTime")String eTime, @Param("amount") BigDecimal amount); -- Gitblit v1.7.1