package com.dy.pipIrrSell.loss; import com.dy.common.webUtil.QueryResultVo; import com.dy.pipIrrGlobal.daoSe.SeLossMapper; import com.dy.pipIrrGlobal.pojoSe.SeLoss; import com.dy.pipIrrGlobal.voSe.VoLoss; 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.time.format.DateTimeFormatter; import java.util.List; import java.util.Map; /** * @author ZhuBaoMin * @date 2023/12/6 9:46 * @LastEditTime 2023/12/6 9:46 * @Description */ @Slf4j @Service public class LossSv { @Autowired private SeLossMapper seLossMapper; public QueryResultVo> getLosses(QueryVo queryVo) { //完善查询挂失记录的起止时间 DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd"); //LocalDateTime lossTimeStart = queryVo.lossTimeStart; //LocalDateTime lossTimeStop = queryVo.lossTimeStop; //if(lossTimeStart != null) { // lossTimeStart = LocalDateTime.parse(df.format(lossTimeStart) + " 00:00:00", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); // queryVo.setLossTimeStart(lossTimeStart); //} // //if(lossTimeStop != null) { // lossTimeStop = LocalDateTime.parse(df.format(lossTimeStop) + " 23:59:59", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); // queryVo.setLossTimeStop(lossTimeStop); //} String lossTimeStart = queryVo.lossTimeStart; String lossTimeStop = queryVo.lossTimeStop; if(lossTimeStart != null) { lossTimeStart = lossTimeStart + " 00:00:00"; queryVo.setLossTimeStart(lossTimeStart); } if(lossTimeStop != null) { lossTimeStop = lossTimeStop + " 23:59:59"; queryVo.setLossTimeStop(lossTimeStop); } Map params = (Map) PojoUtils.generalize(queryVo); Long itemTotal = seLossMapper.getRecordCount(params); QueryResultVo> 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 = seLossMapper.getLosses(params); return rsVo ; } /** * 添加挂失记录 * @param po * @return */ public Long add(SeLoss po) { seLossMapper.insert(po); return po.getId(); } }