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.*;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2024-01-24 19:02
|
* @LastEditTime 2024-01-24 19:02
|
* @Description
|
*/
|
|
@Slf4j
|
@Service
|
public class GeneralSv {
|
@Autowired
|
private SeGeneralMapper seGeneralMapper;
|
|
@Autowired
|
private SeAuditsMapper seAuditsMapper;
|
|
@Autowired
|
private SeCardOperateMapper seCardOperateMapper;
|
|
/**
|
* 获取未生成总账的交易日期列表（当天的交易记录不生成总账）
|
* @return
|
*/
|
public List<Map<String, Object>> getDatesOfNotInGenerals() {
|
return seGeneralMapper.getDatesOfNotInGenerals();
|
}
|
|
/**
|
* 添加总账
|
* @param po 总账对象
|
* @return
|
*/
|
public Integer addGeneral(SeGeneral po) {
|
return seGeneralMapper.insert(po);
|
}
|
|
/**
|
* 根据交易日期获取总账记录列表（待生成的）
|
* @param operateDate 交易日期
|
* @return 取总账记录列表
|
*/
|
public List<SeGeneral> getGeneralByOperateDate(String operateDate) {
|
return seGeneralMapper.getGeneralByOperateDate(operateDate);
|
}
|
|
/**
|
* 根据指定条件获取总账记录
|
* @param queryVo
|
* @return
|
*/
|
public QueryResultVo<List<VoGeneral>> getGenerals(QoGeneral queryVo) {
|
Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo);
|
|
Long itemTotal = seGeneralMapper.getRecordCount(params);
|
|
QueryResultVo<List<VoGeneral>> 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.calculateAndSet(itemTotal, params);
|
rsVo.obj = seGeneralMapper.getGenerals(params);
|
return rsVo ;
|
}
|
|
/**
|
* 修改总账审核意见
|
* @param po
|
* @return
|
*/
|
public Integer updateGeneral(SeGeneral po) {
|
return seGeneralMapper.updateByPrimaryKeySelective(po);
|
}
|
|
/**
|
* 根据编号查询总账
|
* @param id
|
* @return
|
*/
|
public SeGeneral getGeneralById(Long id) {
|
return seGeneralMapper.selectByPrimaryKey(id);
|
}
|
|
/**
|
* t添加总账审核记录
|
* @param po
|
* @return
|
*/
|
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);
|
|
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("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;
|
}
|
}
|
