pipIrr-SV.git - Gitblit

			@@ -1,19 +1,23 @@
			package com.dy.pipIrrSell.general;

			import com.alibaba.fastjson2.JSONArray;
			import com.alibaba.fastjson2.JSONObject;
			import com.dy.common.webUtil.QueryResultVo;
			import com.dy.pipIrrGlobal.daoSe.SeAuditsMapper;
			import com.dy.pipIrrGlobal.daoSe.SeCardOperateMapper;
			import com.dy.pipIrrGlobal.daoSe.SeGeneralMapper;
			import com.dy.pipIrrGlobal.pojoSe.SeAudits;
			import com.dy.pipIrrGlobal.pojoSe.SeGeneral;
			import com.dy.pipIrrGlobal.voSe.VoGeneral;
			import com.dy.pipIrrGlobal.voSe.VoTransactionStatistics;
			import com.dy.pipIrrSell.general.qo.QoGeneral;
			import com.dy.pipIrrSell.general.qo.QoToAudit;
			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.List;
			import java.util.Map;
			import java.util.*;

			/**
			* @author ZhuBaoMin
			@@ -30,6 +34,9 @@

			@Autowired
			private SeAuditsMapper seAuditsMapper;

			@Autowired
			private SeCardOperateMapper seCardOperateMapper;

			/**
			* 获取未生成总账的交易日期列表（当天的交易记录不生成总账）
			@@ -112,4 +119,71 @@
			public Integer addAudits(SeAudits po) {
			return seAuditsMapper.insert(po);
			}

			/**
			* 财务对账审核页，收银员+日期分组，排除交易类型分组
			* @param vo
			* @return
			*/
			public Map getToAudit(QoToAudit vo) {
			/**
			* 取出指定日期三种支付方式（现金、扫码、转账）实收金额
			*/
			JSONArray array_paymentSums = new JSONArray();
			String tradeDate = vo.getTradeDate();
			Long cashierId = vo.cashierId;

			Float receivedCash = Optional.ofNullable(seGeneralMapper.getPaymentSums(tradeDate, cashierId, 1L)).orElse(0f);
			Float receivedQRCode = Optional.ofNullable(seGeneralMapper.getPaymentSums(tradeDate, cashierId,2L)).orElse(0f);
			Float receivedTransfer = Optional.ofNullable(seGeneralMapper.getPaymentSums(tradeDate, cashierId, 3L)).orElse(0f);
			JSONObject job = new JSONObject();
			job.put("tradeDate", tradeDate);
			job.put("receivedCash", receivedCash);
			job.put("receivedQRCode", receivedQRCode);
			job.put("receivedTransfer", receivedTransfer);
			array_paymentSums.add(job);

			// 生成查询参数
			Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo) ;

			//获取笔数合计、实收金额合计、赠送金额合计
			Integer totalCount = 0;
			Float totalReceived = 0f;
			Float totalGift = 0f;
			Map map_sum = Optional.ofNullable(seGeneralMapper.getTransactionStatisticsSums(params)).orElse(new HashMap());
			if(map_sum.size() > 0) {
			totalCount = Integer.parseInt(map_sum.get("totalCount").toString());
			totalReceived = Float.parseFloat(map_sum.get("totalReceived").toString());
			totalGift = Float.parseFloat(map_sum.get("totalGift").toString());
			}

			// 获取符合条件的记录数
			Long itemTotal = seGeneralMapper.getToAuditRecordCount(params);

			Integer pageSize = vo.getPageSize();
			// 计算总页数
			Integer pageTotal ;
			pageTotal = (int)Math.ceil((itemTotal==null?0.0D:itemTotal.doubleValue())/pageSize);

			// 根据当前页码及每页数量计算偏移量
			Integer pageCurr = (Integer.parseInt(params.get("pageCurr").toString()) - 1) * Integer.parseInt(params.get("pageSize").toString());
			params.put("pageCurr", pageCurr);

			List<VoTransactionStatistics> list = seGeneralMapper.getToAudit(params);
			Map map_record = new HashMap();
			map_record.put("itemTotal", itemTotal);
			map_record.put("pageCurr", vo.pageCurr);
			map_record.put("pageSize", pageSize);
			map_record.put("pageTotal", pageTotal);
			map_record.put("list", list);

			Map map_result = new HashMap();
			map_result.put("totalCount", totalCount);
			map_result.put("totalReceived", totalReceived);
			map_result.put("totalGift", totalGift);
			map_result.put("records", map_record);
			map_result.put("paymentSums", array_paymentSums);

			return map_result;
			}
			}