From d919e26796ec5a6f78fc0b665840207f185f1274 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期四, 22 二月 2024 15:25:20 +0800 Subject: [PATCH] Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV --- pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/wallet/WalletSv.java | 225 ++++++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 195 insertions(+), 30 deletions(-) diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/wallet/WalletSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/wallet/WalletSv.java index 2e7b236..3fafbb3 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/wallet/WalletSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/wallet/WalletSv.java @@ -1,13 +1,29 @@ package com.dy.pipIrrSell.wallet; +import com.dy.common.webUtil.QueryResultVo; +import com.dy.pipIrrGlobal.daoSe.SeConsumeMapper; +import com.dy.pipIrrGlobal.daoSe.SeRefundMapper; import com.dy.pipIrrGlobal.daoSe.SeWalletMapper; -import com.dy.pipIrrGlobal.daoSe.SeWalletRechargeHistoryMapper; import com.dy.pipIrrGlobal.daoSe.SeWalletRechargeMapper; +import com.dy.pipIrrGlobal.pojoSe.SeConsume; +import com.dy.pipIrrGlobal.pojoSe.SeRefund; import com.dy.pipIrrGlobal.pojoSe.SeWallet; -import com.dy.pipIrrGlobal.pojoSe.SeWalletRechargeHistory; +import com.dy.pipIrrGlobal.pojoSe.SeWalletRecharge; +import com.dy.pipIrrGlobal.voSe.VoWallet; +import com.dy.pipIrrGlobal.voSe.VoWalletConsume; +import com.dy.pipIrrGlobal.voSe.VoWalletRecharge; +import com.dy.pipIrrGlobal.voSe.VoWalletRefund; +import com.dy.pipIrrSell.wallet.qo.QueryVo; +import com.dy.pipIrrSell.wallet.qo.QoWalletRecharge; 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.util.HashMap; +import java.util.List; +import java.util.Map; +import java.util.Optional; /** * @author ZhuBaoMin @@ -26,54 +42,203 @@ private SeWalletRechargeMapper seWalletRechargeMapper; @Autowired - private SeWalletRechargeHistoryMapper seWalletRechargeHistoryMapper; + private SeConsumeMapper seConsumeMapper; + + @Autowired + private SeRefundMapper seRefundMapper; + + /** + * 鏍规嵁鍐滄埛ID鑾峰彇鐢靛瓙閽卞寘瀵硅薄 + * @param clientId + * @return + */ + public SeWallet getWalletByClientId(Long clientId) { + return seWalletMapper.getWalletByClientId(clientId); + } /** * 娉ㄥ唽鐢靛瓙閽卞寘璐﹀彿 + * @param po 鐢靛瓙閽卞寘瀹炰綋绫� + * @return 鐢靛瓙閽卞寘ID + */ + public Long addWallet(SeWallet po) { + seWalletMapper.insert(po); + return po.getId(); + } + + /** + * 鐢靛瓙閽卞寘鍏呭�� * @param po * @return */ - public Integer add(SeWallet po) { - return seWalletMapper.insert(po); + public Long addRecharge(SeWalletRecharge po) { + seWalletRechargeMapper.insert(po); + return po.getId(); } /** - * 鏍规嵁缂栧彿浠庨挶鍖呰〃涓幏鍙栬閽卞寘浣欓 - * @param id + * 鐢靛瓙閽卞寘娑堣垂 + * @param po * @return */ - public Float getMoneyById(Long id) { - SeWallet po = seWalletMapper.selectByPrimaryKey(id); - return po.getMoney(); + public Long addConsume(SeConsume po) { + seConsumeMapper.insert(po); + return po.getId(); } /** - * 鏍规嵁閽卞寘缂栧彿淇敼閽卞寘浣欓 - * @param id 閽卞寘缂栧彿锛堜富閿級 - * @param money 閽卞寘浣欓 - * @return 淇敼璁板綍鏁伴噺 - */ - public Integer updateMoneyById(Long id, Float money) { - SeWallet po = seWalletMapper.selectByPrimaryKey(id); - po.setMoney(money); - return seWalletMapper.updateByPrimaryKey(po); - } - - /** - * 鏍规嵁id鍒犻櫎鍏呭�艰褰� - * @param id + * 娣诲姞閫�娆剧敵璇� + * @param po * @return */ - public Integer deleteWallerRechargeById(Long id) { - return seWalletMapper.deleteByPrimaryKey(id); + public Long addRefund(SeRefund po) { + seRefundMapper.insert(po); + return po.getId(); } /** - * 灏嗗厖鍊艰褰曟坊鍔犲埌鍏呭�煎巻鍙茶〃 - * @param po 鍏呭�煎巻鍙插疄浣� + * 鏍规嵁閽卞寘ID鑾峰彇寰呭鏍哥殑閫�娆剧敵璇峰璞� + * @param walletId * @return */ - public Integer addWallerRechargeHistory(SeWalletRechargeHistory po) { - return seWalletRechargeHistoryMapper.insert(po); + public SeRefund getRefundByWallerId(Long walletId) { + return seRefundMapper.getRefundByWallerId(walletId); + } + + /** + * 瀹℃牳閫�娆剧敵璇� + * @param po + * @return + */ + public Integer auditRefund(SeRefund po) { + return seRefundMapper.updateByPrimaryKeySelective(po); + } + + /** + * 淇敼鐢靛瓙閽卞寘 + * 鍏呭�笺�佹秷璐广�佺敵璇烽��娆俱�佸鏍搁��娆炬椂闇�瑕佷慨鏀圭數瀛愰挶鍖呯殑锛氫綑棰濄�佹渶鍚庢搷浣溿�佹渶鍚庢搷浣滄椂闂� + * @param po + * @return + */ + public Integer updateWallet(SeWallet po) { + return seWalletMapper.updateByPrimaryKeySelective(po); + } + + + /** + * 鏍规嵁鍐滄埛濮撳悕鑾峰彇鐢靛瓙閽卞寘璐︽埛璁板綍 + * @param queryVo + * @return + */ + public QueryResultVo<List<VoWallet>> getWallets(QueryVo queryVo) { + Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); + + Long itemTotal = seWalletMapper.getRecordCount(params); + + QueryResultVo<List<VoWallet>> rsVo = new QueryResultVo<>() ; + rsVo.pageSize = queryVo.pageSize ; + rsVo.pageCurr = queryVo.pageCurr ; + + rsVo.calculateAndSet(itemTotal, params); + rsVo.obj = seWalletMapper.getWallets(params); + return rsVo ; + } + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鐢靛瓙閽卞寘鍏呭�艰褰� + * @param queryVo + * @return + */ + public QueryResultVo<List<VoWalletRecharge>> getWalletRecharges(QoWalletRecharge queryVo) { + //瀹屽杽鏌ヨ鍏呭�艰褰曠殑璧锋鏃堕棿 + String timeStart = queryVo.getTimeStart(); + String timeStop = queryVo.getTimeStop(); + if(timeStart != null) { + timeStart = timeStart + " 00:00:00"; + queryVo.setTimeStart(timeStart); + } + if(timeStop != null) { + timeStop = timeStop + " 23:59:59"; + queryVo.setTimeStop(timeStop); + } + + Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); + + Long itemTotal = seWalletRechargeMapper.getRecordCount(params); + + QueryResultVo<List<VoWalletRecharge>> rsVo = new QueryResultVo<>() ; + rsVo.pageSize = queryVo.pageSize ; + rsVo.pageCurr = queryVo.pageCurr ; + + rsVo.calculateAndSet(itemTotal, params); + rsVo.obj = seWalletRechargeMapper.getWalletRecharges(params); + return rsVo ; + } + + /** + * 鏍规嵁鍐滄埛ID鑾峰彇鐢靛瓙閽卞寘娑堣垂璁板綍 + * @param queryVo + * @return + */ + public Map getWalletConsumes(QueryVo queryVo) { + // 鑾峰彇鐢靛瓙閽卞寘娑堣垂姹囨�讳俊鎭� + String clientName = ""; + String clientNum = ""; + Double money = 0.0; + Double totalConsume = 0.0; + Long clientId = Optional.ofNullable(queryVo.getClientId()).orElse(0L); + Map map_consumeSum = Optional.ofNullable(seConsumeMapper.getWalletConsumeSum(clientId)).orElse(new HashMap()); + if(map_consumeSum.size() > 0) { + clientName = map_consumeSum.get("clientName").toString(); + clientNum = map_consumeSum.get("clientNum").toString(); + money = Double.parseDouble(map_consumeSum.get("money").toString()); + totalConsume = Double.parseDouble(map_consumeSum.get("totalConsume").toString()); + } + + Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); + Long itemTotal = seConsumeMapper.getRecordCount(params); + + QueryResultVo<List<VoWalletConsume>> rsVo = new QueryResultVo<>() ; + rsVo.pageSize = queryVo.pageSize ; + rsVo.pageCurr = queryVo.pageCurr ; + + rsVo.calculateAndSet(itemTotal, params); + List<VoWalletConsume> list = seConsumeMapper.getWalletConsumes(params); + + + Map map_record = new HashMap(); + map_record.put("itemTotal", rsVo.itemTotal); + map_record.put("pageCurr", rsVo.pageCurr); + map_record.put("pageSize", rsVo.pageSize); + map_record.put("pageTotal", rsVo.pageTotal); + map_record.put("list", list); + + Map map_result = new HashMap(); + map_result.put("clientName", clientName); + map_result.put("clientNum", clientNum); + map_result.put("money", money); + map_result.put("totalConsume", totalConsume); + map_result.put("records", map_record); + + return map_result; + } + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鐢靛瓙閽卞寘閫�娆捐褰� + * @param queryVo + * @return + */ + public QueryResultVo<List<VoWalletRefund>> getWalletRefunds(QueryVo queryVo) { + Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); + + Long itemTotal = seRefundMapper.getRecordCount(params); + + QueryResultVo<List<VoWalletRefund>> rsVo = new QueryResultVo<>() ; + rsVo.pageSize = queryVo.pageSize ; + rsVo.pageCurr = queryVo.pageCurr ; + + rsVo.calculateAndSet(itemTotal, params); + rsVo.obj = seRefundMapper.getWalletRefunds(params); + return rsVo ; } } -- Gitblit v1.8.0