| | |
| | | */ |
| | | @RequestMapping(value = "/water/getCount") |
| | | @ResponseBody |
| | | public Object getCount1(Integer time,String insertTime,Integer payType,Integer type) { |
| | | public Object getCount1(Integer time,String insertTime,Integer payType,Integer type,String code) { |
| | | if (payType!=null){ |
| | | switch (payType){ |
| | | case 1: |
| | |
| | | // 用户小件物流订单记录 |
| | | List<TOrderPrivateCar> tOrderPrivateCars = new ArrayList<>(); |
| | | List<TOrderLogistics> tOrderLogistics = new ArrayList<>(); |
| | | // 用户取消订单记录 |
| | | List<OrderCancel> orderCancels = new ArrayList<>(); |
| | | // 用户充值 |
| | | List<TPubTransactionDetails> tPubTransactionDetails = new ArrayList<>(); |
| | | // 司机结算总额 |
| | | List<SettlementDetail> settlementDetails1 = new ArrayList<>(); |
| | | List<SettlementDetail> settlementDetails1 = new ArrayList<>(); |
| | | // 司机提现 |
| | | List<TPubWithdrawal> driver = new ArrayList<>(); |
| | | // 用户提现 |
| | |
| | | EntityWrapper<TOrderPrivateCar> tOrderPrivateCarEntityWrapper = new EntityWrapper<>(); |
| | | // 用户小件物流订单wrapper |
| | | EntityWrapper<TOrderLogistics> tOrderLogisticsEntityWrapper = new EntityWrapper<>(); |
| | | // 司机手动结算金额 |
| | | Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>(); |
| | | // 用户取消订单wrapper |
| | | Wrapper<OrderCancel> orderCancelEntityWrapper = new EntityWrapper<>(); |
| | | // 用户取消订单记录 |
| | | List<OrderCancel> orderCancels = new ArrayList<>(); |
| | | // 司机手动结算金额 |
| | | Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>(); |
| | | List<Integer> integers = new ArrayList<>(); |
| | | integers.add(1); |
| | | integers.add(2); |
| | |
| | | orderType = new EntityWrapper<TPubTransactionDetails>() |
| | | .eq("userType",1) |
| | | .eq("orderType", 5) |
| | | ; |
| | | ; |
| | | // 用户提现wrapper |
| | | userWrapper = new EntityWrapper<TPubWithdrawal>() |
| | | .eq("state", 2) |
| | | .eq("userType", 1) |
| | | ; |
| | | ; |
| | | // 司机提现wrapper |
| | | between = new EntityWrapper<TPubWithdrawal>() |
| | | .eq("state", 2) |
| | |
| | | .in("payType",Arrays.asList(1, 2)); |
| | | // 司机手动结算金额 |
| | | orderType1 = new EntityWrapper<SettlementDetail>() |
| | | .isNotNull("settlementRecordId") |
| | | .in("orderType", Arrays.asList(1, 4)); |
| | | // 用户取消订单费用 |
| | | orderCancelEntityWrapper.eq("state", 2) |
| | | .eq("userType", 1).in("payType",integers) |
| | | ; |
| | | .in("payType",integers) |
| | | .eq("userType", 1); |
| | | }else{ |
| | | orderType = new EntityWrapper<TPubTransactionDetails>() |
| | | .eq("orderType", 5) |
| | |
| | | .eq("userType", 2) |
| | | .between("handleTime", start, end); |
| | | // 司机手动结算金额 |
| | | orderType1 = new EntityWrapper<SettlementDetail>() |
| | | orderType1 = new EntityWrapper<SettlementDetail>() |
| | | .isNotNull("settlementRecordId") |
| | | .in("orderType", Arrays.asList(1, 4)) |
| | | .between("createTime", start, end); |
| | | // 用户专车订单wrapper |
| | |
| | | .in("payType",integers) |
| | | .between("insertTime", start, end); |
| | | } |
| | | |
| | | |
| | | if (type != null){ |
| | | switch (type){ |
| | | case 1: |
| | | // 只查询用户订单 |
| | | tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); |
| | | tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper); |
| | | // 用户取消订单费用 |
| | | orderCancelEntityWrapper.eq("state", 2) |
| | | .eq("userType", 1); |
| | | orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); |
| | | break; |
| | | case 2: |
| | | // 只查询用户充值 |
| | |
| | | break; |
| | | } |
| | | }else{ |
| | | if(ToolUtil.isNotEmpty(code)){ |
| | | tOrderPrivateCarEntityWrapper.like("orderNum", code); |
| | | tOrderLogisticsEntityWrapper.like("orderNum", code); |
| | | orderType.like("", code); |
| | | } |
| | | |
| | | |
| | | // 只查询用户订单 |
| | | tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); |
| | | tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper); |
| | | orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); |
| | | |
| | | tPubTransactionDetails = pubTransactionDetailsService.selectList(orderType); |
| | | // 只查询司机手动结算的 |
| | | settlementDetails1 = settlementDetailService.selectList(orderType1); |
| | | driver = pubWithdrawalService.selectList(between); |
| | | user = pubWithdrawalService.selectList(userWrapper); |
| | | orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); |
| | | |
| | | } |
| | | List<WaterVO> res = new ArrayList<>(); |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | |
| | | BigDecimal driverWithdrawal = new BigDecimal("0"); |
| | | // 用户提现金额 |
| | | BigDecimal userWithdrawal = new BigDecimal("0"); |
| | | // 用户订单消费 |
| | | |
| | | // 用户订单消费 |
| | | for (TOrderPrivateCar tOrderPrivateCar : tOrderPrivateCars) { |
| | |
| | | if(payType!=null && payType == 2){ |
| | | break; |
| | | } |
| | | String code1 = tPubWithdrawal.getCode(); |
| | | if(ToolUtil.isNotEmpty(code) && !code1.contains(code)){ |
| | | continue; |
| | | } |
| | | WaterVO waterVO = new WaterVO(); |
| | | waterVO.setInsertTime(format.format(tPubWithdrawal.getHandleTime())); |
| | | waterVO.setCode(tPubWithdrawal.getCode()); |
| | |
| | | if(payType!=null && payType == 2){ |
| | | break; |
| | | } |
| | | WaterVO waterVO = new WaterVO(); |
| | | if (tPubWithdrawal.getHandleTime()!=null){ |
| | | waterVO.setInsertTime(format.format(tPubWithdrawal.getHandleTime())); |
| | | String code1 = tPubWithdrawal.getCode(); |
| | | if(ToolUtil.isNotEmpty(code) && !code1.contains(code)){ |
| | | continue; |
| | | } |
| | | WaterVO waterVO = new WaterVO(); |
| | | waterVO.setInsertTime(format.format(tPubWithdrawal.getHandleTime())); |
| | | waterVO.setCode(tPubWithdrawal.getCode()); |
| | | TUser user2 = appUserService.selectById(tPubWithdrawal.getUserId()); |
| | | if (user2!=null){ |
| | |
| | | // 临时数据 |
| | | continue; |
| | | } |
| | | String code1 = paymentRecord.getCode(); |
| | | if(ToolUtil.isNotEmpty(code) && !code1.contains(code)){ |
| | | continue; |
| | | } |
| | | waterVO.setInsertTime(format.format(paymentRecord.getInsertTime())); |
| | | waterVO.setCode(paymentRecord.getCode()); |
| | | if (paymentRecord.getPayType()!=null){ |
| | |
| | | continue; |
| | | } |
| | | } |
| | | |
| | | waterVO.setPayType("银行卡支付"); |
| | | break; |
| | | case 3: |
| | | case 4: |
| | | continue; |
| | | } |
| | | } |
| | | |
| | |
| | | switch (income.getOrderType()){ |
| | | case 1: |
| | | SettlementRecord settlementRecord = settlementRecordService.selectById(income.getSettlementRecordId()); |
| | | if (settlementRecord!=null){ |
| | | if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus() == 2){ |
| | | if (settlementRecord!=null && settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus() == 2){ |
| | | if (settlementRecord.getPayType()!=null){ |
| | | switch (settlementRecord.getPayType()){ |
| | | case 1: |
| | | if (payType!=null){ |
| | | if (payType != 1){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("手机支付"); |
| | | break; |
| | | case 2: |
| | | if (payType!=null){ |
| | | if (payType != 2){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("银行卡支付"); |
| | | break; |
| | | case 3: |
| | | case 4: |
| | | continue; |
| | | } |
| | | |
| | | } |
| | | }else{ |
| | | continue; |
| | | } |
| | | // 查询订单信息 |
| | | TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(income.getOrderId()); |
| | | if (tOrderPrivateCar==null){ |
| | | continue; |
| | | } |
| | | String code1 = tOrderPrivateCar.getOrderNum(); |
| | | if(ToolUtil.isNotEmpty(code) && !code1.contains(code)){ |
| | | continue; |
| | | } |
| | | platformVO.setCode(tOrderPrivateCar.getOrderNum()); |
| | | TDriver tDriver = driverService.selectById(tOrderPrivateCar.getDriverId()); |
| | | if (tDriver != null){ |
| | | platformVO.setName(tDriver.getFirstName()+tDriver.getLastName()); |
| | | platformVO.setPhone(tDriver.getPhone()); |
| | | } |
| | | platformVO.setRemark(tOrderPrivateCar.getRemark()); |
| | | if (income.getCreateTime()!=null){ |
| | | platformVO.setInsertTime(format.format(income.getCreateTime())); |
| | | } |
| | | platformVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); |
| | | if (income.getPrice() != null){ |
| | | String string = income.getPrice().toString(); |
| | | BigDecimal bigDecimal1 = new BigDecimal(string); |
| | | platformVO.setMoney(bigDecimal1+""); |
| | | }else{ |
| | | continue; |
| | | } |
| | | |
| | | if (tOrderPrivateCar.getPayType() == null){ |
| | | continue; |
| | | } |
| | | |
| | | // 专车订单 |
| | | String string4 = tOrderPrivateCar.getOrderMoney().toString(); |
| | | balance = balance.add(new BigDecimal(string4)); |
| | | res.add(platformVO); |
| | | break; |
| | | case 4: |
| | | // 小件物流 |
| | | // 查询订单信息 |
| | | SettlementRecord settlementRecord1 = settlementRecordService.selectById(income.getSettlementRecordId()); |
| | | if (settlementRecord1!=null){ |
| | | if (settlementRecord1.getPaymentStatus()!=null && settlementRecord1.getPaymentStatus() == 2){ |
| | | switch (settlementRecord1.getPayType()){ |
| | | case 1: |
| | | if (payType!=null){ |
| | | if (payType != 1){ |
| | |
| | | }else{ |
| | | continue; |
| | | } |
| | | // 查询订单信息 |
| | | TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(income.getOrderId()); |
| | | if (tOrderPrivateCar==null){ |
| | | continue; |
| | | } |
| | | platformVO.setCode(tOrderPrivateCar.getOrderNum()); |
| | | TDriver tDriver = driverService.selectById(tOrderPrivateCar.getDriverId()); |
| | | if (tDriver != null){ |
| | | platformVO.setName(tDriver.getFirstName()+tDriver.getLastName()); |
| | | platformVO.setPhone(tDriver.getPhone()); |
| | | } |
| | | platformVO.setRemark(tOrderPrivateCar.getRemark()); |
| | | if (income.getCreateTime()!=null){ |
| | | platformVO.setInsertTime(format.format(income.getCreateTime())); |
| | | } |
| | | platformVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); |
| | | if (income.getOrderMoney() != null){ |
| | | String string = income.getPrice().toString(); |
| | | BigDecimal bigDecimal1 = new BigDecimal(string); |
| | | platformVO.setMoney(bigDecimal1+""); |
| | | }else{ |
| | | continue; |
| | | } |
| | | |
| | | if (tOrderPrivateCar.getPayType() == null){ |
| | | continue; |
| | | } |
| | | |
| | | |
| | | // 专车订单 |
| | | String string4 = income.getPrice().toString(); |
| | | balance = balance.add(new BigDecimal(string4)); |
| | | res.add(platformVO); |
| | | break; |
| | | case 4: |
| | | SettlementRecord settlementRecord1 = settlementRecordService.selectById(income.getSettlementRecordId()); |
| | | if (settlementRecord1!=null&& settlementRecord1.getPaymentStatus()!=null && settlementRecord1.getPaymentStatus() == 2){ |
| | | if (settlementRecord1.getPayType()!=null){ |
| | | switch (settlementRecord1.getPayType()){ |
| | | case 1: |
| | | if (payType!=null){ |
| | | if (payType != 1){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("手机支付"); |
| | | break; |
| | | case 2: |
| | | if (payType!=null){ |
| | | if (payType != 2){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("银行卡支付"); |
| | | break; |
| | | case 3: |
| | | case 4: |
| | | continue; |
| | | } |
| | | |
| | | } |
| | | }else { |
| | | continue; |
| | | } |
| | | // 小件物流 |
| | | // 查询订单信息 |
| | | TOrderLogistics tOrderLogistics1 = orderLogisticsService.selectById(income.getOrderId()); |
| | | if (tOrderLogistics1==null){ |
| | | continue; |
| | | } |
| | | switch (tOrderLogistics1.getPayType()){ |
| | | case 1: |
| | | if (payType!=null){ |
| | | if (payType != 1){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("手机支付"); |
| | | break; |
| | | case 2: |
| | | if (payType!=null){ |
| | | if (payType != 2){ |
| | | continue; |
| | | } |
| | | } |
| | | platformVO.setPayType("银行卡支付"); |
| | | break; |
| | | case 3: |
| | | |
| | | case 4: |
| | | continue; |
| | | } |
| | | String code2 = tOrderLogistics1.getOrderNum(); |
| | | if(ToolUtil.isNotEmpty(code) && !code2.contains(code)){ |
| | | continue; |
| | | } |
| | | platformVO.setCode(tOrderLogistics1.getOrderNum()); |
| | |
| | | platformVO.setName(tDriver1.getFirstName()+tDriver1.getLastName()); |
| | | platformVO.setPhone(tDriver1.getPhone()); |
| | | } |
| | | |
| | | platformVO.setRemark(tOrderLogistics1.getRemark()); |
| | | platformVO.setMoney(new BigDecimal(income.getPrice())+""); |
| | | platformVO.setMoney(BigDecimal.valueOf(income.getPrice())+""); |
| | | if (income.getCreateTime()!=null){ |
| | | platformVO.setInsertTime(format.format(income.getCreateTime())); |
| | | } |
| | |
| | | continue; |
| | | } |
| | | |
| | | String string1 = income.getPrice().toString(); |
| | | String string1 = tOrderLogistics1.getOrderMoney().toString(); |
| | | // 小件物流订单 |
| | | balance = balance.add(new BigDecimal(string1)); |
| | | res.add(platformVO); |
| | |
| | | // 只查询用户订单 |
| | | tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); |
| | | tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper); |
| | | orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); |
| | | |
| | | tPubTransactionDetails = pubTransactionDetailsService.selectList(orderType); |
| | | // 只查询司机手动结算的 |
| | | settlementDetails1 = settlementDetailService.selectList(orderType1); |
| | | driver = pubWithdrawalService.selectList(between); |
| | | user = pubWithdrawalService.selectList(userWrapper); |
| | | orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); |
| | | } |
| | | List<WaterVO> res = new ArrayList<>(); |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |