| New file | 
 |  |  | 
 |  |  | package com.dy.pipIrrSell.unlock; | 
 |  |  |  | 
 |  |  | import com.dy.common.webUtil.QueryResultVo; | 
 |  |  | import com.dy.pipIrrGlobal.daoSe.SeUnlockMapper; | 
 |  |  | import com.dy.pipIrrGlobal.pojoSe.SeUnlock; | 
 |  |  | import com.dy.pipIrrGlobal.voSe.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.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<List<VoUnlock>> getUnlocks(QueryVo queryVo) { | 
 |  |  |         //完善查询注销记录的起止时间 | 
 |  |  |         DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd"); | 
 |  |  |  | 
 |  |  |         String unlocklTimeStart = queryVo.unlocklTimeStart; | 
 |  |  |         String unlockTimeStop = queryVo.unlockTimeStop; | 
 |  |  |         if(unlocklTimeStart != null) { | 
 |  |  |             unlocklTimeStart = unlocklTimeStart + " 00:00:00"; | 
 |  |  |             queryVo.setUnlocklTimeStart(unlocklTimeStart); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         if(unlockTimeStop != null) { | 
 |  |  |             unlockTimeStop = unlockTimeStop + " 23:59:59"; | 
 |  |  |             queryVo.setUnlockTimeStop(unlockTimeStop); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo); | 
 |  |  |  | 
 |  |  |         Long itemTotal = seUnlockMapper.getRecordCount(params); | 
 |  |  |  | 
 |  |  |         QueryResultVo<List<VoUnlock>> rsVo = new QueryResultVo<>() ; | 
 |  |  |         rsVo.pageSize = queryVo.pageSize ; | 
 |  |  |         rsVo.pageCurr = queryVo.pageCurr ; | 
 |  |  |  | 
 |  |  |         rsVo.calculateAndSet(itemTotal, params); | 
 |  |  |         rsVo.obj = seUnlockMapper.getUnlocks(params); | 
 |  |  |         return rsVo ; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 添加解锁记录 | 
 |  |  |      * @param po | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     public Long add(SeUnlock po) { | 
 |  |  |         seUnlockMapper.insert(po); | 
 |  |  |         return po.getId(); | 
 |  |  |     } | 
 |  |  | } |