| | |
| | | consumeDetail.setConsumeName(RechargeRecordEnum.EVENT_REGISTRATION.getMsg()); |
| | | consumeDetail.setConsumeTime(paymentCompetition.getTime()); |
| | | consumeDetail.setConsumeAmount("-" + paymentCompetition.getAmount()); |
| | | consumeDetail.setType(2); |
| | | details.add(consumeDetail); |
| | | consumeDetail.setType(1); |
| | | } |
| | | } |
| | | // 2.取消赛事报名 |
| | |
| | | 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()); |
| | |
| | | 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> |
| | |
| | | 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> |
| | |
| | | </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"> |
| | |
| | | * @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); |
| | | |