|  |  | 
 |  |  | package com.dy.pipIrrSell.cardOperate; | 
 |  |  |  | 
 |  |  | import com.alibaba.fastjson2.JSON; | 
 |  |  | import com.alibaba.fastjson2.JSONArray; | 
 |  |  | import com.alibaba.fastjson2.JSONObject; | 
 |  |  | import com.dy.common.webUtil.BaseResponse; | 
 |  |  | import com.dy.common.webUtil.BaseResponseUtils; | 
 |  |  | import com.dy.common.webUtil.QueryResultVo; | 
 |  |  | import com.dy.pipIrrGlobal.daoBa.BaSettingsMapper; | 
 |  |  | import com.dy.pipIrrGlobal.daoSe.SeCardOperateMapper; | 
 |  |  | import com.dy.pipIrrGlobal.daoSe.SeClientCardMapper; | 
 |  |  | import com.dy.pipIrrGlobal.daoSe.SeClientMapper; | 
 |  |  | import com.dy.pipIrrGlobal.daoSe.SeGeneralMapper; | 
 |  |  | import com.dy.pipIrrGlobal.pojoSe.SeCardOperate; | 
 |  |  | import com.dy.pipIrrGlobal.pojoSe.SeClientCard; | 
 |  |  | import com.dy.pipIrrGlobal.voSe.VoRecharge; | 
 |  |  | import com.dy.pipIrrGlobal.voSe.*; | 
 |  |  | import com.dy.pipIrrSell.cardOperate.dto.DtoRecharge; | 
 |  |  | import com.dy.pipIrrSell.cardOperate.enums.OperateTypeENUM; | 
 |  |  | import com.dy.pipIrrSell.cardOperate.qo.QoRecharge; | 
 |  |  | import com.dy.pipIrrSell.cardOperate.qo.*; | 
 |  |  | import com.dy.pipIrrSell.clientCard.ClientCardSv; | 
 |  |  | import com.dy.pipIrrSell.clientCard.LastOperateENUM; | 
 |  |  | import com.dy.pipIrrSell.result.SellResultCode; | 
 |  |  | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | import org.springframework.stereotype.Service; | 
 |  |  |  | 
 |  |  | import java.text.DecimalFormat; | 
 |  |  | import java.util.*; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private ClientCardSv clientCardSv; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private SeGeneralMapper seGeneralMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private BaSettingsMapper baSettingsMapper; | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 添加开卡记录 | 
 |  |  | 
 |  |  |      * @param clientNum 农户编号 | 
 |  |  |      * @return 5级行政区划代码 | 
 |  |  |      */ | 
 |  |  |     public Long getAreaCodeByNum(String clientNum) { | 
 |  |  |         return seClientMapper.getAreaCodeByNum(clientNum); | 
 |  |  |     public String getAreaCodeByNum(String clientNum) { | 
 |  |  |         Long areaCode = seClientMapper.getAreaCodeByNum(clientNum); | 
 |  |  |         if (areaCode == null) { | 
 |  |  |             return ""; | 
 |  |  |         } | 
 |  |  |         return String.valueOf(areaCode); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  | 
 |  |  |          */ | 
 |  |  |         Long cardId = 0L; | 
 |  |  |         Long clientId = 0L; | 
 |  |  |         String cardNum = po.getCardNum(); | 
 |  |  |         Long cardNum = po.getCardNum(); | 
 |  |  |         Float money = po.getMoney(); | 
 |  |  |         Float amount = po.getAmount(); | 
 |  |  |         Float gift = po.getGift(); | 
 |  |  | 
 |  |  |         Long operator = po.getOperator(); | 
 |  |  |         Date rechargeTime = new Date(); | 
 |  |  |  | 
 |  |  |         // 如果传入的是10位的水卡编号,升为17位水卡编号 | 
 |  |  |         String cardNumS = String.valueOf(cardNum).trim(); | 
 |  |  |         if(cardNumS.length() == 10) { | 
 |  |  |             cardNumS = "100000" + cardNumS.substring(0,6) + "0" + cardNumS.substring(6); | 
 |  |  |         } | 
 |  |  |         cardNum = Long.valueOf(cardNumS); | 
 |  |  |  | 
 |  |  |         // 验证水卡状态是否支持当前操作 | 
 |  |  |         String stateName = Optional.ofNullable(clientCardSv.getCardStateByCardNum(cardNum)).orElse(""); | 
 |  |  |         if(stateName.length() == 0 || !stateName.equals("正常")) { | 
 |  |  |             return BaseResponseUtils.buildErrorMsg(stateName + ", " + SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage()); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         /** | 
 |  |  |          * 依据水卡编号获取水卡表主键及农户编号 | 
 |  |  |          */ | 
 |  |  |         Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap()); | 
 |  |  |         if(map == null || map.size() <= 0) { | 
 |  |  |             return BaseResponseUtils.buildFail(SellResultCode.CARD_NUMBER_MISTAKE.getMessage()); | 
 |  |  |             return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage()); | 
 |  |  |         } | 
 |  |  |         cardId = Long.parseLong(map.get("cardId").toString()); | 
 |  |  |         clientId = Long.parseLong(map.get("clientId").toString()); | 
 |  |  | 
 |  |  |         seClientCard.setLastoper(LastOperateENUM.RECHARGE.getCode ()); | 
 |  |  |         Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0); | 
 |  |  |         if(rec_updateClientCard == 0) { | 
 |  |  |             return BaseResponseUtils.buildFail(SellResultCode.RECHARGE_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage()); | 
 |  |  |             return BaseResponseUtils.buildErrorMsg(SellResultCode.RECHARGE_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage()); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         /** | 
 |  |  | 
 |  |  |         seCardOperateMapper.insert(seCardOperate); | 
 |  |  |         Long rec = Optional.ofNullable(seCardOperate.getId()).orElse(0L); | 
 |  |  |         if(rec == 0) { | 
 |  |  |             return BaseResponseUtils.buildFail(SellResultCode.REPLACE_FAIL_WRITE_RECHARGE_ERROR.getMessage()); | 
 |  |  |             return BaseResponseUtils.buildErrorMsg(SellResultCode.REPLACE_FAIL_WRITE_RECHARGE_ERROR.getMessage()); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         return BaseResponseUtils.buildSuccess(true) ; | 
 |  |  |         //return BaseResponseUtils.buildSuccess(true) ; | 
 |  |  |  | 
 |  |  |         cardNumS = String.valueOf(cardNum).trim(); | 
 |  |  |         if(cardNumS.substring(0,2).equals("10")) { | 
 |  |  |             cardNumS = cardNumS.substring(6,12) + cardNumS.substring(13); | 
 |  |  |         } | 
 |  |  |         cardNum = Long.parseLong(cardNumS); | 
 |  |  |  | 
 |  |  |         Map map_response = new HashMap(); | 
 |  |  |         map_response.put("projectNo", String.format("%02x", Integer.parseInt(getProjectNo()))); | 
 |  |  |         map_response.put("orderNumber", rec); | 
 |  |  |         map_response.put("cardNum", cardNum); | 
 |  |  |         return BaseResponseUtils.buildSuccess(map_response) ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取充值记录 | 
 |  |  |      * @param queryVo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public QueryResultVo<List<VoRecharge>> getRecharges(QoRecharge queryVo) { | 
 |  |  |         //完善查询充值记录的起止时间 | 
 |  |  |         String rechargeTimeStart = queryVo.rechargeTimeStart; | 
 |  |  |         String rechargeTimeStop = queryVo.rechargeTimeStop; | 
 |  |  |         if(rechargeTimeStart != null) { | 
 |  |  |             rechargeTimeStart = rechargeTimeStart + " 00:00:00"; | 
 |  |  |             queryVo.setRechargeTimeStart(rechargeTimeStart); | 
 |  |  |         } | 
 |  |  |         if(rechargeTimeStop != null) { | 
 |  |  |             rechargeTimeStop = rechargeTimeStop + " 23:59:59"; | 
 |  |  |             queryVo.setRechargeTimeStop(rechargeTimeStop); | 
 |  |  |         } | 
 |  |  |         //String rechargeTimeStart = queryVo.rechargeTimeStart; | 
 |  |  |         //String rechargeTimeStop = queryVo.rechargeTimeStop; | 
 |  |  |         //if(rechargeTimeStart != null) { | 
 |  |  |         //    rechargeTimeStart = rechargeTimeStart + " 00:00:00"; | 
 |  |  |         //    queryVo.setRechargeTimeStart(rechargeTimeStart); | 
 |  |  |         //} | 
 |  |  |         //if(rechargeTimeStop != null) { | 
 |  |  |         //    rechargeTimeStop = rechargeTimeStop + " 23:59:59"; | 
 |  |  |         //    queryVo.setRechargeTimeStop(rechargeTimeStop); | 
 |  |  |         //} | 
 |  |  |  | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); | 
 |  |  |  | 
 |  |  |         Long itemTotal = seCardOperateMapper.getRecordCount(params); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoRecharge>> rsVo = new QueryResultVo<>() ; | 
 |  |  |         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.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         rsVo.obj = seCardOperateMapper.getRecharges(params); | 
 |  |  |         return rsVo ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取交易记录 | 
 |  |  |      * @param vo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public Map getTransactions(QoTransaction vo){ | 
 |  |  |         DecimalFormat df = new DecimalFormat("0.00"); | 
 |  |  |         // 补齐查询时间 | 
 |  |  |         String operateTimeStart = vo.operateTimeStart; | 
 |  |  |         String operateTimeStop = vo.operateTimeStop; | 
 |  |  |         if(operateTimeStart != null) { | 
 |  |  |             operateTimeStart = operateTimeStart + " 00:00:00"; | 
 |  |  |             vo.setOperateTimeStart(operateTimeStart); | 
 |  |  |         } | 
 |  |  |         if(operateTimeStop != null) { | 
 |  |  |             operateTimeStop = operateTimeStop + " 23:59:59"; | 
 |  |  |             vo.setOperateTimeStop(operateTimeStop); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         // 生成查询参数 | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo) ; | 
 |  |  |  | 
 |  |  |         // 获取符合条件的记录数 | 
 |  |  |         Long itemTotal = Optional.ofNullable(seCardOperateMapper.getTransactionRecordCount(params)).orElse(0L); | 
 |  |  |  | 
 |  |  |         List<VoTradeDetails> list = seCardOperateMapper.getTransactions(params); | 
 |  |  |         if(list.size() == 0) { | 
 |  |  |             return new HashMap(); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         // 遍历交易明细记录,汇总购水金额、购卡金额 | 
 |  |  |         Double totalWaterCost = 0.0; | 
 |  |  |         Double totalCardCost = 0.0; | 
 |  |  |         JSONArray array= JSONArray.parseArray(JSON.toJSONString(list)); | 
 |  |  |         for(int i = 0; i < array.size(); i++) { | 
 |  |  |             JSONObject job = array.getJSONObject(i); | 
 |  |  |             Double waterCost = Optional.ofNullable(job.getDouble("waterCost")).orElse(0.0); | 
 |  |  |             Double cardCost = Optional.ofNullable(job.getDouble("cardCost")).orElse(0.0); | 
 |  |  |             totalWaterCost = totalWaterCost + waterCost; | 
 |  |  |             totalCardCost = totalCardCost + cardCost; | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         Map map_record = new HashMap(); | 
 |  |  |         map_record.put("itemTotal", itemTotal); | 
 |  |  |         map_record.put("list", list); | 
 |  |  |  | 
 |  |  |         Map map_result = new HashMap(); | 
 |  |  |         map_result.put("waterCost", df.format(totalWaterCost)); | 
 |  |  |         map_result.put("cardCost", df.format(totalCardCost)); | 
 |  |  |         map_result.put("records", map_record); | 
 |  |  |  | 
 |  |  |         return map_result; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取开卡记录 | 
 |  |  |      * @param queryVo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public QueryResultVo<List<VoActiveCard>> getActiveCards(QoActiveCard queryVo) { | 
 |  |  |         //完善查询充值记录的起止时间 | 
 |  |  |         String activeTimeStart = queryVo.activeTimeStart; | 
 |  |  |         String activeTimeStop = queryVo.activeTimeStop; | 
 |  |  |         if(activeTimeStart != null) { | 
 |  |  |             activeTimeStart = activeTimeStart + " 00:00:00"; | 
 |  |  |             queryVo.setActiveTimeStart(activeTimeStart); | 
 |  |  |         } | 
 |  |  |         if(activeTimeStop != null) { | 
 |  |  |             activeTimeStop = activeTimeStop + " 23:59:59"; | 
 |  |  |             queryVo.setActiveTimeStop(activeTimeStop); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); | 
 |  |  |  | 
 |  |  |         Long itemTotal = seCardOperateMapper.getActiveCardRecordCount(params); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoActiveCard>> rsVo = new QueryResultVo<>() ; | 
 |  |  |  | 
 |  |  |         rsVo.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         rsVo.obj = seCardOperateMapper.getActiveCards(params); | 
 |  |  |         return rsVo ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取补卡记录 | 
 |  |  |      * @param queryVo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public QueryResultVo<List<VoReissueCard>> getReissueCards(QoReissueCard queryVo) { | 
 |  |  |         //完善查询充值记录的起止时间 | 
 |  |  |         String reissueCardTimeStart = queryVo.reissueCardTimeStart; | 
 |  |  |         String reissueCardTimeStop = queryVo.reissueCardTimeStop; | 
 |  |  |         if(reissueCardTimeStart != null) { | 
 |  |  |             reissueCardTimeStart = reissueCardTimeStart + " 00:00:00"; | 
 |  |  |             queryVo.setReissueCardTimeStart(reissueCardTimeStart); | 
 |  |  |         } | 
 |  |  |         if(reissueCardTimeStop != null) { | 
 |  |  |             reissueCardTimeStop = reissueCardTimeStop + " 23:59:59"; | 
 |  |  |             queryVo.setReissueCardTimeStop(reissueCardTimeStop); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); | 
 |  |  |  | 
 |  |  |         Long itemTotal = seCardOperateMapper.getReissueCardRecordCount(params); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoReissueCard>> rsVo = new QueryResultVo<>() ; | 
 |  |  |  | 
 |  |  |         rsVo.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         rsVo.obj = seCardOperateMapper.getReissueCards(params); | 
 |  |  |         return rsVo ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取IC卡注销记录 | 
 |  |  |      * @param queryVo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public QueryResultVo<List<VoOperate>> getCommonOperations(QoCommonOperate 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 = Optional.ofNullable(seCardOperateMapper.getCommonOperationRecordCount(params)).orElse(0L); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoOperate>> rsVo = new QueryResultVo<>() ; | 
 |  |  |  | 
 |  |  |         rsVo.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         rsVo.obj = seCardOperateMapper.getCommonOperations(params); | 
 |  |  |         return rsVo ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取收据列表 | 
 |  |  |      * @param queryVo | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public Map getReceipts(QoReceipt queryVo) { | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); | 
 |  |  |  | 
 |  |  |         DecimalFormat df = new DecimalFormat("#.00"); | 
 |  |  |         Double totalAmount = Optional.ofNullable(seCardOperateMapper.getTotalAmount(params)).orElse(0.0); | 
 |  |  |  | 
 |  |  |         Long itemTotal = seCardOperateMapper.getReceiptsRecordCount(params); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoReceipt>> rsVo = new QueryResultVo<>() ; | 
 |  |  |         rsVo.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         //rsVo.obj = seCardOperateMapper.getReceipts(params); | 
 |  |  |         //return rsVo ; | 
 |  |  |  | 
 |  |  |         List<VoReceipt> list = seCardOperateMapper.getReceipts(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("totalAmount", df.format(totalAmount)); | 
 |  |  |         map_result.put("records", map_record); | 
 |  |  |  | 
 |  |  |         return map_result; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 判断指定水卡是否为挂失状态且无补卡记录 | 
 |  |  |      * @param cardNum 水卡编号 | 
 |  |  |      * @return 是否已挂失未补卡 | 
 |  |  |      */ | 
 |  |  |     public Boolean isLostAndUnreplaced(Long cardNum) { | 
 |  |  |         Integer lostCount = seClientCardMapper.getLostCount(cardNum); | 
 |  |  |         Integer replacedCount = seClientCardMapper.getReplacedCount(cardNum); | 
 |  |  |         if(lostCount > 0 && replacedCount == 0) { | 
 |  |  |             return true; | 
 |  |  |         } | 
 |  |  |         return false; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 修改农户水卡 | 
 |  |  |      * @param po | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public Integer updateClientCard(SeClientCard po) { | 
 |  |  |         return seClientCardMapper.updateByPrimaryKeySelective(po); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取项目编号 | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public String getProjectNo() { | 
 |  |  |         return baSettingsMapper.getItemValue("projectNo"); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据水卡编号获取其挂失时退款金额(补卡时判断使用) | 
 |  |  |      * @param cardNum | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public Double getTradeAmountByCardNo(Long cardNum) { | 
 |  |  |         return seCardOperateMapper.getTradeAmountByCardNo(cardNum); | 
 |  |  |     } | 
 |  |  | } |