pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeCardOperateMapper.java
@@ -132,4 +132,26 @@ * @return */ Double getTradeAmountByCardNo(Long cardNum); /** * 指定时间段内开卡总数量（物理卡） * @param params * @return */ Long getOpenCountIcCardsCount(Map<String, Object> params); /** * 指定时间段内挂失总数量（物理卡） * @param params * @return */ Long getLossCountIcCardsCount(Map<String, Object> params); /** * 指定时间段内充值总数量（物理卡） * @param params * @return */ Long getRechargeCountIcCardsCount(Map<String, Object> params); } pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
@@ -183,12 +183,4 @@ * @param money */ void updateMoney(@Param("id")Long id , @Param("money")Double money); /** * 指定时间段内开卡总数量（物理卡） * @param params * @return */ Long getOpenCountIcCardsCount(Map<String, Object> params); } pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeCardOperateMapper.xml
@@ -693,4 +693,31 @@ ORDER BY ope.operate_dt DESC LIMIT 0,1 </select> <!--指定时间段内开卡总数量（物理卡）--> <select id="getOpenCountIcCardsCount" resultType="java.lang.Long"> SELECT count(*) FROM `se_card_operate` WHERE operate_dt BETWEEN #{timeStart} AND #{timeStop} AND operate_type = 1 </select> <!--指定时间段内挂失总数量（物理卡）--> <select id="getLossCountIcCardsCount" resultType="java.lang.Long"> SELECT count(*) FROM `se_card_operate` WHERE operate_dt BETWEEN #{timeStart} AND #{timeStop} AND operate_type = 6 </select> <!--指定时间段内充值总数量（物理卡）--> <select id="getRechargeCountIcCardsCount" resultType="java.lang.Long"> SELECT count(*) FROM `se_card_operate` WHERE operate_dt BETWEEN #{timeStart} AND #{timeStop} AND operate_type = 2 </select> </mapper> pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml
@@ -589,13 +589,4 @@ ORDER BY card.id </select> <!--指定时间段内开卡总数量（物理卡）--> <select id="getOpenCountIcCardsCount" resultType="java.lang.Long"> SELECT count(*) FROM `se_client_card` WHERE createDt BETWEEN #{timeStart} AND #{timeStop} </select> </mapper> pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java
@@ -45,4 +45,42 @@ return BaseResponseUtils.buildException(e.getMessage()); } } /** * 指定时间段内挂失总数量（物理卡） * * @param qo * @return */ @GetMapping(path = "/getLossCountIcCards") @SsoAop() public BaseResponse<QueryResultVo<List<VoICCard>>> getLossCountIcCards(CommonQO qo) { try { QueryResultVo<List<VoICCard>> res = icCardSv.getLossCountIcCards(qo); return BaseResponseUtils.buildSuccess(res); }catch (Exception e){ log.error("获取记录异常", e); return BaseResponseUtils.buildException(e.getMessage()); } } /** * 指定时间段内充值总数量（物理卡） * * @param qo * @return */ @GetMapping(path = "/getRechargeCountIcCards") @SsoAop() public BaseResponse<QueryResultVo<List<VoICCard>>> getRechargeCountIcCards(CommonQO qo) { try { QueryResultVo<List<VoICCard>> res = icCardSv.getRechargeCountIcCards(qo); return BaseResponseUtils.buildSuccess(res); }catch (Exception e){ log.error("获取记录异常", e); return BaseResponseUtils.buildException(e.getMessage()); } } } pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java
@@ -1,6 +1,7 @@ package com.dy.pipIrrStatistics.card; import com.dy.common.webUtil.QueryResultVo; import com.dy.pipIrrGlobal.daoSe.SeCardOperateMapper; import com.dy.pipIrrGlobal.daoSe.SeClientCardMapper; import com.dy.pipIrrGlobal.voSt.VoICCard; import com.dy.pipIrrGlobal.voSt.VoIntakeAccumulateAmount; @@ -27,7 +28,7 @@ public class IcCardSv { @Autowired private SeClientCardMapper seClientCardMapper; private SeCardOperateMapper seCardOperateMapper; /** * 指定时间段内开卡总数量（物理卡） @@ -54,7 +55,79 @@ Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); Long itemTotal = seClientCardMapper.getOpenCountIcCardsCount(params); Long itemTotal = seCardOperateMapper.getOpenCountIcCardsCount(params); QueryResultVo<List<VoICCard>> rsVo = new QueryResultVo<>() ; rsVo.pageSize = qo.pageSize ; rsVo.pageCurr = qo.pageCurr ; rsVo.calculateAndSet(itemTotal, params); return rsVo ; } /** * 指定时间段内挂失总数量（物理卡） * @param qo * @return */ public QueryResultVo<List<VoICCard>> getLossCountIcCards(CommonQO qo) { String timeStart = qo.getTimeStart(); String timeStop = qo.getTimeStop(); if (timeStart != null && timeStart != ""){ timeStart = timeStart + " 00:00:00"; }else { timeStart = LocalDate.now() + " 00:00:00"; } if (timeStop != null && timeStop != ""){ timeStop = timeStop + " 23:59:59"; }else { timeStop = LocalDateTime.now().toString(); } qo.setTimeStart(timeStart); qo.setTimeStop(timeStop); Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); Long itemTotal = seCardOperateMapper.getLossCountIcCardsCount(params); QueryResultVo<List<VoICCard>> rsVo = new QueryResultVo<>() ; rsVo.pageSize = qo.pageSize ; rsVo.pageCurr = qo.pageCurr ; rsVo.calculateAndSet(itemTotal, params); return rsVo ; } /** * 指定时间段内充值总数量（物理卡） * @param qo * @return */ public QueryResultVo<List<VoICCard>> getRechargeCountIcCards(CommonQO qo) { String timeStart = qo.getTimeStart(); String timeStop = qo.getTimeStop(); if (timeStart != null && timeStart != ""){ timeStart = timeStart + " 00:00:00"; }else { timeStart = LocalDate.now() + " 00:00:00"; } if (timeStop != null && timeStop != ""){ timeStop = timeStop + " 23:59:59"; }else { timeStop = LocalDateTime.now().toString(); } qo.setTimeStart(timeStart); qo.setTimeStop(timeStop); Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); Long itemTotal = seCardOperateMapper.getRechargeCountIcCardsCount(params); QueryResultVo<List<VoICCard>> rsVo = new QueryResultVo<>() ; rsVo.pageSize = qo.pageSize ;
