| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.io.IOException; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | |
| | | @Override |
| | | public OutPark count4(Integer bId) { |
| | | // OutPark outPark = null; |
| | | // try { |
| | | // String s = redisTemplate.opsForValue().get("outPark-"+bId); |
| | | // if(!StringUtil.isNullOrEmpty(s)){ |
| | | // outPark = JSON.parseObject(s, OutPark.class); |
| | | // return outPark; |
| | | // }else { |
| | | // QueryWrapper<OutPark> wrapper = new QueryWrapper<>(); |
| | | // wrapper.lambda() |
| | | // .eq(OutPark::getBarrierId,bId) |
| | | // .eq(OutPark::getStatus,1) |
| | | // .eq(OutPark::getStatus2,0) |
| | | // .orderByDesc(OutPark::getCreateTime); |
| | | // List<OutPark> outParks = outParkMapper.selectList(wrapper); |
| | | // if(outParks.size()>0){ |
| | | // String jsonValue = JSON.toJSONString(outParks.get(0)); |
| | | // redisTemplate.opsForValue().set("outPark-"+bId, jsonValue); |
| | | // return outParks.get(0); |
| | | // }else{ |
| | | // return null; |
| | | // } |
| | | // } |
| | | // } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | // return null; |
| | | |
| | | QueryWrapper<OutPark> wrapper = new QueryWrapper<>(); |
| | | wrapper.lambda() |
| | | .eq(OutPark::getBarrierId,bId) |
| | | .eq(OutPark::getStatus,1) |
| | | .eq(OutPark::getStatus2,0) |
| | | .orderByDesc(OutPark::getCreateTime); |
| | | List<OutPark> outParks = outParkMapper.selectList(wrapper); |
| | | if(outParks.size()>0){ |
| | | return outParks.get(0); |
| | | }else{ |
| | | return null; |
| | | OutPark outPark = null; |
| | | try { |
| | | String s = redisTemplate.opsForValue().get("outPark-"+bId); |
| | | if(!StringUtil.isNullOrEmpty(s)){ |
| | | outPark = JSON.parseObject(s, OutPark.class); |
| | | return outPark; |
| | | }else { |
| | | return null; |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | return null; |
| | | // |
| | | // QueryWrapper<OutPark> wrapper = new QueryWrapper<>(); |
| | | // wrapper.lambda() |
| | | // .eq(OutPark::getBarrierId,bId) |
| | | // .eq(OutPark::getStatus,1) |
| | | // .eq(OutPark::getStatus2,0) |
| | | // .orderByDesc(OutPark::getCreateTime); |
| | | // List<OutPark> outParks = outParkMapper.selectList(wrapper); |
| | | // if(outParks.size()>0){ |
| | | // return outParks.get(0); |
| | | // }else{ |
| | | // return null; |
| | | // } |
| | | } |
| | | |
| | | @Override |
| | |
| | | } |
| | | |
| | | @Override |
| | | public OutPark findBy5min(String carNo, Integer parkId,LocalDateTime dateTime) { |
| | | LocalDateTime localDateTime = dateTime.minusMinutes(5); |
| | | QueryWrapper<OutPark> wrapper = new QueryWrapper<>(); |
| | | wrapper.lambda() |
| | | .eq(OutPark::getCarNo,carNo) |
| | | .eq(OutPark::getParkId,parkId) |
| | | .ge(OutPark::getCreateTime,localDateTime) |
| | | .isNotNull(OutPark::getEnterTime); |
| | | List<OutPark> outParks = outParkMapper.selectList(wrapper); |
| | | if(outParks != null && outParks.size()>0){ |
| | | for (OutPark outPark : outParks) { |
| | | if(outPark.getPrice() == 0){ |
| | | return outPark; |
| | | } |
| | | if(outPark.getPrice() != 0 && outPark.getStatus() == 1){ |
| | | return outPark; |
| | | } |
| | | } |
| | | } |
| | | return null; |
| | | } |
| | | @Override |
| | | public OutPark findBy10min(String carNo, Integer parkId,LocalDateTime dateTime) { |
| | | LocalDateTime localDateTime = dateTime.minusMinutes(10); |
| | | QueryWrapper<OutPark> wrapper = new QueryWrapper<>(); |
| | | wrapper.lambda() |
| | | .eq(OutPark::getCarNo,carNo) |
| | | .eq(OutPark::getParkId,parkId) |
| | | .ge(OutPark::getCreateTime,localDateTime) |
| | | .ge(OutPark::getPrice,0) |
| | | .isNotNull(OutPark::getPayCode) |
| | | .isNotNull(OutPark::getEnterTime); |
| | | List<OutPark> outParks = outParkMapper.selectList(wrapper); |
| | | if(outParks != null && outParks.size()>0){ |
| | | return outParks.get(0); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | @Override |
| | | public List<OutPark> getList(long current, long size, String carNo, Long parkId, String payCode, String date) { |
| | | return outParkMapper.getList((current-1)*size,size,carNo,parkId,payCode,date); |
| | | } |