From 6b90436a61338d46282bf724e445e90af80461e1 Mon Sep 17 00:00:00 2001 From: Administrator <zhubaomin> Date: 星期三, 27 十二月 2023 10:34:25 +0800 Subject: [PATCH] 2023-12-27 朱宝民 增加了交易记录查询 使分页具有兼容性 --- pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/recharge/RechargeSv.java | 77 ++++++++++++++++++++++++++++++++------ 1 files changed, 64 insertions(+), 13 deletions(-) diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/recharge/RechargeSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/recharge/RechargeSv.java index a82ee98..10baa78 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/recharge/RechargeSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/recharge/RechargeSv.java @@ -1,15 +1,16 @@ package com.dy.pipIrrSell.recharge; import com.dy.common.webUtil.QueryResultVo; +import com.dy.pipIrrGlobal.daoSe.SeRechargeHistoryMapper; import com.dy.pipIrrGlobal.daoSe.SeRechargeMapper; -import com.dy.pipIrrGlobal.pojoSe.VoRecharge; +import com.dy.pipIrrGlobal.pojoSe.SeRecharge; +import com.dy.pipIrrGlobal.pojoSe.SeRechargeHistory; +import com.dy.pipIrrGlobal.voSe.VoRecharge; import lombok.extern.slf4j.Slf4j; import org.apache.dubbo.common.utils.PojoUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; -import java.time.LocalDateTime; -import java.time.format.DateTimeFormatter; import java.util.List; import java.util.Map; @@ -26,34 +27,84 @@ @Autowired private SeRechargeMapper seRechargeMapper; + @Autowired + private SeRechargeHistoryMapper seRechargeHistoryMapper; + public QueryResultVo<List<VoRecharge>> getRecharges(QueryVo queryVo) { //瀹屽杽鏌ヨ鍏呭�艰褰曠殑璧锋鏃堕棿 - DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd"); - - LocalDateTime rechargeTimeStart = queryVo.rechargeTimeStart; - LocalDateTime rechargeTimeStop = queryVo.rechargeTimeStop; + String rechargeTimeStart = queryVo.rechargeTimeStart; + String rechargeTimeStop = queryVo.rechargeTimeStop; if(rechargeTimeStart != null) { - rechargeTimeStart = LocalDateTime.parse(df.format(rechargeTimeStart) + " 00:00:00", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); + rechargeTimeStart = rechargeTimeStart + " 00:00:00"; queryVo.setRechargeTimeStart(rechargeTimeStart); } - if(rechargeTimeStop != null) { - rechargeTimeStop = LocalDateTime.parse(df.format(rechargeTimeStop) + " 23:59:59", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); + rechargeTimeStop = rechargeTimeStop + " 23:59:59"; queryVo.setRechargeTimeStop(rechargeTimeStop); } - Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); Long itemTotal = seRechargeMapper.getRecordCount(params); QueryResultVo<List<VoRecharge>> rsVo = new QueryResultVo<>() ; - rsVo.pageSize = queryVo.pageSize ; - rsVo.pageCurr = queryVo.pageCurr ; + Integer pageCurr = 0; + Integer pageSize = 10000; + rsVo.pageCurr = 1; + rsVo.pageSize = 10000; + if(queryVo.pageSize != null && queryVo.pageCurr != null) { + rsVo.pageSize = queryVo.pageSize ; + rsVo.pageCurr = queryVo.pageCurr; + pageSize = queryVo.pageSize ; + pageCurr = (Integer.parseInt(params.get("pageCurr").toString()) - 1) * Integer.parseInt(params.get("pageSize").toString()); + } + params.put("pageCurr", pageCurr); + params.put("pageSize", pageSize); + rsVo.calculateAndSet(itemTotal, params); rsVo.obj = seRechargeMapper.getRecharges(params); return rsVo ; } + /** + * 鏍规嵁姘村崱缂栧彿锛堜富閿級鍒犻櫎鍏呭�艰褰� + * @param cardId + * @return + */ + //public Integer deleteByPrimaryKey(Long cardId) { + // return seRechargeMapper.deleteByPrimaryKey(cardId); + //} + + /** + * 娣诲姞鍏呭�艰褰� + * @param po + * @return + */ + public Long add(SeRecharge po) { + seRechargeMapper.insert(po); + return po.getId(); + } + + /** + * 鏍规嵁姘村崱缂栧彿鍒犻櫎鍏呭�艰褰� + * @param cardId + * @return + */ + public Integer deleteByCardId(Long cardId) { + return seRechargeMapper.deleteByCardId(cardId); + } + //public Integer deleteByCardNum(String cardNum) { + // return seRechargeMapper.deleteByCardNum(cardNum); + //} + + /** + * 娣诲姞鍏呭�煎巻鍙茶〃 + * @param po + * @return + */ + public Long addHistory(SeRechargeHistory po){ + seRechargeHistoryMapper.insert(po); + return po.getId(); + } } -- Gitblit v1.8.0