package com.dy.pipIrrSell.unlock; import com.dy.common.webUtil.QueryResultVo; import com.dy.pipIrrGlobal.daoSe.SeUnlockMapper; import com.dy.pipIrrGlobal.pojoSe.VoUnlock; 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.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.List; import java.util.Map; /** * @author ZhuBaoMin * @date 2023/12/6 15:02 * @LastEditTime 2023/12/6 15:02 * @Description */ @Slf4j @Service public class UnlockSv { @Autowired private SeUnlockMapper seUnlockMapper; public QueryResultVo> getUnlocks(QueryVo queryVo) { //完善查询注销记录的起止时间 DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd"); LocalDateTime unlocklTimeStart = queryVo.unlocklTimeStart; LocalDateTime unlockTimeStop = queryVo.unlockTimeStop; if(unlocklTimeStart != null) { unlocklTimeStart = LocalDateTime.parse(df.format(unlocklTimeStart) + " 00:00:00", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); queryVo.setUnlocklTimeStart(unlocklTimeStart); } if(unlockTimeStop != null) { unlockTimeStop = LocalDateTime.parse(df.format(unlockTimeStop) + " 23:59:59", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); queryVo.setUnlockTimeStop(unlockTimeStop); } Map params = (Map) PojoUtils.generalize(queryVo); Long itemTotal = seUnlockMapper.getRecordCount(params); QueryResultVo> rsVo = new QueryResultVo<>() ; rsVo.pageSize = queryVo.pageSize ; rsVo.pageCurr = queryVo.pageCurr ; rsVo.calculateAndSet(itemTotal, params); rsVo.obj = seUnlockMapper.getUnlocks(params); return rsVo ; } }