From df5cc553bde495f22757f0d6472a714a056a02d8 Mon Sep 17 00:00:00 2001 From: kongdeqiang <123456> Date: 星期五, 28 四月 2023 16:57:57 +0800 Subject: [PATCH] 默认变更列表 --- src/main/java/com/boying/controller/phone/EticketController.java | 24 ++++++------ src/main/java/com/boying/entity/EnterPark.java | 10 +++++ src/main/java/com/boying/controller/car/PlateServlet3.java | 28 +++++++++++-- src/main/java/com/boying/service/FileInfoService.java | 2 + src/main/java/com/boying/controller/FileInfoController.java | 6 +++ src/main/java/com/boying/entity/OutPark.java | 10 +++++ src/main/java/com/boying/job/ReadFileScheduled2.java | 9 ++-- src/main/java/com/boying/job/GetEticketScheduled.java | 9 +++- src/main/java/com/boying/service/impl/FileInfoServiceImpl.java | 13 ++++++ src/main/java/com/boying/job/EticketScheduled.java | 2 10 files changed, 88 insertions(+), 25 deletions(-) diff --git a/src/main/java/com/boying/controller/FileInfoController.java b/src/main/java/com/boying/controller/FileInfoController.java index 2423411..93b54af 100644 --- a/src/main/java/com/boying/controller/FileInfoController.java +++ b/src/main/java/com/boying/controller/FileInfoController.java @@ -59,4 +59,10 @@ fileInfoService.getFile(path,response); } + + @GetMapping("/showImgById/{fileId}") + public void showImgById(@PathVariable Long fileId,HttpServletResponse response) { + fileInfoService.getFileById(fileId,response); + } + } diff --git a/src/main/java/com/boying/controller/car/PlateServlet3.java b/src/main/java/com/boying/controller/car/PlateServlet3.java index a318310..e00d4ee 100644 --- a/src/main/java/com/boying/controller/car/PlateServlet3.java +++ b/src/main/java/com/boying/controller/car/PlateServlet3.java @@ -9,6 +9,7 @@ import com.boying.entity.*; import com.boying.service.*; import com.boying.util.DateUtilOther; +import com.boying.util.FileUtil; import com.boying.util.StringUtil; import com.google.gson.JsonObject; import com.google.gson.JsonParser; @@ -35,6 +36,7 @@ import java.util.List; import java.util.concurrent.TimeUnit; + /** * Servlet implementation class PlateServlet */ @@ -52,6 +54,7 @@ private final TicketService ticketService; private final CostRuleService costRuleService; private final WhiteListService whiteListService; + private final FileInfoService fileInfoService; private final String LEDURL = "http://192.168.31.212:9988/LedShow/IGetResultDataAllLine"; /** @@ -216,6 +219,7 @@ BufferedReader reader = new BufferedReader(new InputStreamReader(request.getInputStream(),"UTF-8")); String str = ""; String lineStr = ""; + FileInfo fileInfo = null; while((str = reader.readLine()) != null){ lineStr += str; } @@ -226,6 +230,7 @@ JSONObject result = alarmInfoPlate.getJSONObject("result"); JSONObject plateResult = result.getJSONObject("PlateResult"); String carNo = plateResult.get("license").toString(); + String image = plateResult.get("imageFile").toString(); String code = alarmInfoPlate.get("serialno").toString(); try { @@ -261,7 +266,14 @@ break; } - System.out.println("缂栧彿锛�"+serialno+"璁惧璇嗗埆鍒颁簡锛�"+license); + + if(StringUtils.isNotBlank(image)){ + fileInfo = FileUtil.generateBase64StringToFile(image, 1,1); + fileInfoService.save(fileInfo); + } + + + System.out.println("缂栧彿锛�"+serialno+" 璁惧璇嗗埆鍒颁簡锛�"+license); String format = sdf.format(new Date()); s+= format+",杞︾墝鍙蜂负锛�"+license+",serialno涓猴細"+code+" "; @@ -272,7 +284,7 @@ easyNoOpen(request,response); }else{ if(barrier.getType()==0){ - outPark(license, barrier.getId(), barrier.getParkId(),request,response); + outPark(license, barrier.getId(), barrier.getParkId(),request,response,fileInfo); s+=license+"-淇濆瓨鍑哄満璁板綍\n"; }else{ String num = redisTemplate.opsForValue().get("car_park_" + barrier.getParkId()); @@ -288,7 +300,7 @@ }else { //led鏄剧ず inLedShow(code, license,barrier.getParkId(),request,response); - enterPark(license,barrier.getId(),barrier.getParkId()); + enterPark(license,barrier.getId(),barrier.getParkId(),fileInfo); s+=license+"-淇濆瓨鍏ュ満璁板綍\n"; } } @@ -342,7 +354,7 @@ - public void enterPark(String carNo,Integer barrierId,Integer parkId) { + public void enterPark(String carNo,Integer barrierId,Integer parkId,FileInfo fileInfo) { Park park = parkService.getById(parkId); // int num = 0; // String s = redisTemplate.opsForValue().get("car_park_" + parkId); @@ -373,6 +385,9 @@ if(tickets.size()>0){ enterPark.setStatus(1);//鍙戠幇鏈夎繚绔� } + if(fileInfo != null){ + enterPark.setImgId(fileInfo.getId()); + } enterParkService.saveOrUpdate(enterPark); // Barrier barrier = barrierService.getById(barrierId); @@ -380,7 +395,7 @@ // barrierService.saveOrUpdate(barrier); } - public double outPark(String carNo,Integer barrierId,Integer parkId,HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { + public double outPark(String carNo,Integer barrierId,Integer parkId,HttpServletRequest request, HttpServletResponse response,FileInfo fileInfo) throws ServletException, IOException { double money = 0.0; EnterPark enterPark = null; String toDayHrMinSec = null; @@ -411,6 +426,9 @@ //outPark.setPrice(Double.valueOf(String.format("%.1f", money))); outPark.setPrice(money); outPark.setStatus3(findTicket(carNo)); + if(fileInfo != null){ + outPark.setImgId(fileInfo.getId()); + } outParkService.saveOrUpdate(outPark); Barrier barrier =barrierService.getById(barrierId); barrier.setCarNo(carNo); diff --git a/src/main/java/com/boying/controller/phone/EticketController.java b/src/main/java/com/boying/controller/phone/EticketController.java index 8c98762..4b0f1f9 100644 --- a/src/main/java/com/boying/controller/phone/EticketController.java +++ b/src/main/java/com/boying/controller/phone/EticketController.java @@ -29,13 +29,13 @@ */ - public static void main(String[] args) { + public static void main9(String[] args) { //鐩存帴寮�绁� SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); SimpleDateFormat sdf2 = new SimpleDateFormat("hh:mm:ss"); String format = sdf.format(new Date()); String format2 = sdf2.format(new Date()); - String idStr = 111111+""; + String idStr = 17107+""; String dateStr = DateUtil.currentSeconds()+""; String l = idStr + dateStr; @@ -43,7 +43,7 @@ //寮�绁ㄧ敵璇� DirectTicket.info info = new DirectTicket.info(); info.setOrdernum(1); - info.setAmt(3.0); + info.setAmt(7.5); info.setAmount(1); info.setIncitemcode("072101"); info.setIncitemname("鍋滆溅娉婁綅鍙婂叕鍏卞仠杞﹀満绛夋湁鍋夸娇鐢ㄦ敹鍏�"); @@ -57,8 +57,8 @@ directTicket.setIssuedate(format); directTicket.setIssuetime(format2); directTicket.setPayerpartytype("1"); - directTicket.setPayer("鍐�A0C5MA"); - directTicket.setAmt(3.0); + directTicket.setPayer("鍐�A0CM05"); + directTicket.setAmt(7.5); directTicket.setUsername("寮犲▏"); directTicket.setChecker("涔斿畞"); directTicket.setPayinfo(json); @@ -73,7 +73,7 @@ txt += map+",\n"; if(entity.getBody().getCode() ==1 ){ //鐢宠鎴愬姛锛屽幓鑾峰彇寮�绁ㄦ枃浠� - //System.out.println(entity.getBody()); + System.out.println(entity.getBody()); Object o = entity.getBody().getData().get(0); String s = JSON.toJSONString(o); Map<String,Object> mapTypes = (Map)JSON.parse(s); @@ -88,18 +88,18 @@ } } - public static void main9(String[] args) { + public static void main(String[] args) { Map<String,Object> map1 = new HashMap<>(); - map1.put("einvoicecode", ""); - map1.put("einvoicenumber",""); - map1.put("bizcode", ""); - map1.put("randomnumber",""); + map1.put("einvoicecode", "13011223"); + map1.put("einvoicenumber","0005489442"); + map1.put("bizcode", "171071682490940"); + map1.put("randomnumber","366660"); map1.put("billfiletype",1); SimpleDateFormat sdf3 = new SimpleDateFormat("yyyy-MM-dd_HH_mm_ss"); RestTemplate restTemplate = new RestTemplate(); ResponseEntity<ReturnData> entity = restTemplate.postForEntity("http://10.255.200.204:7991/geteinvoicebybizcode", HTTPEntityUtil.setEntity(map1), ReturnData.class); + System.out.println(entity.getBody()); if(entity.getBody().getCode() == 1){ - System.out.println(entity.getBody()); Object o1 = entity.getBody().getData().get(0); String s1 = JSON.toJSONString(o1); EticketFile eticketFile = JSONObject.parseObject(s1, EticketFile.class); diff --git a/src/main/java/com/boying/entity/EnterPark.java b/src/main/java/com/boying/entity/EnterPark.java index 1e709d8..e430ee6 100644 --- a/src/main/java/com/boying/entity/EnterPark.java +++ b/src/main/java/com/boying/entity/EnterPark.java @@ -5,6 +5,7 @@ import com.boying.common.BaseEntity; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; +import io.swagger.models.auth.In; import lombok.Data; import javax.persistence.Column; @@ -42,8 +43,17 @@ @Column(columnDefinition = "int comment '鏈彂鐜拌繚绔狅細0 鍙戠幇杩濈珷锛�1'") private int status; + @ApiModelProperty(value = "鍥剧墖id") + @Column(columnDefinition = "int comment '鍥剧墖id'") + private Integer imgId; + + @Transient @TableField(exist = false) private String parkName; + @Transient + @TableField(exist = false) + private String imgPath; + } diff --git a/src/main/java/com/boying/entity/OutPark.java b/src/main/java/com/boying/entity/OutPark.java index 513c70c..b0e44fc 100644 --- a/src/main/java/com/boying/entity/OutPark.java +++ b/src/main/java/com/boying/entity/OutPark.java @@ -5,9 +5,11 @@ import com.boying.common.BaseEntity; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; +import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Transient; import java.time.LocalDateTime; @@ -95,7 +97,15 @@ */ private int status3; + @ApiModelProperty(value = "鍥剧墖id") + @Column(columnDefinition = "int comment '鍥剧墖id'") + private Integer imgId; + @Transient @TableField(exist = false) private String parkName; + + @Transient + @TableField(exist = false) + private String imgPath; } diff --git a/src/main/java/com/boying/job/EticketScheduled.java b/src/main/java/com/boying/job/EticketScheduled.java index 22737de..eb28bd6 100644 --- a/src/main/java/com/boying/job/EticketScheduled.java +++ b/src/main/java/com/boying/job/EticketScheduled.java @@ -43,7 +43,7 @@ private FileInfoService fileInfoService; private Boolean taskFlag = false; - // @Scheduled(cron = "0/10 * * * * ?") + //@Scheduled(cron = "0/10 * * * * ?") public void execute() throws Exception { if(taskFlag == true){ System.out.println("姝e湪杩愯锛屽己鍒堕��鍑�-------銆�"); diff --git a/src/main/java/com/boying/job/GetEticketScheduled.java b/src/main/java/com/boying/job/GetEticketScheduled.java index 0fd02e2..7f439d8 100644 --- a/src/main/java/com/boying/job/GetEticketScheduled.java +++ b/src/main/java/com/boying/job/GetEticketScheduled.java @@ -47,9 +47,12 @@ } QueryWrapper<OrderRecord> wrapper = new QueryWrapper<>(); wrapper.lambda() - .eq(OrderRecord::getTicketStatus, 0) - .isNotNull(OrderRecord::getEinvoicecode) - .orderByDesc(OrderRecord::getCreateTime); +// .eq(OrderRecord::getTicketStatus, 0) +// .isNotNull(OrderRecord::getEinvoicecode) +// .orderByDesc(OrderRecord::getCreateTime); + .in(OrderRecord::getPayCode,"13040623000000055070","13040623000000062406","13040623000000232508","13040623000000363081","13040623000000242992","13040623000000319574","13040623000000362919","13040623000000154458","13040623000000151150", + "13040623000000155450","13040623000000241009","13040623000000363014","13040623000000220187","13040623000000231732","13040623000000362898","13040623000000362900","13040623000000362951","13040623000000153156","13040623000000150991", + "13040623000000327435","13040623000000226482"); List<OrderRecord> list = orderRecordService.list(wrapper); if (list.size() > 0) { if (list.size() > 50) { diff --git a/src/main/java/com/boying/job/ReadFileScheduled2.java b/src/main/java/com/boying/job/ReadFileScheduled2.java index f4e134a..3baa9ab 100644 --- a/src/main/java/com/boying/job/ReadFileScheduled2.java +++ b/src/main/java/com/boying/job/ReadFileScheduled2.java @@ -9,6 +9,7 @@ import com.boying.service.OrderRecordService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; import java.io.IOException; @@ -36,12 +37,12 @@ @Autowired private ErrorLogService errorLogService; - //@Scheduled(cron = "0 30 14 * * ?") + //@Scheduled(cron = "0 40 18 * * ?") public void execute() throws Exception { - Path path = Paths.get("E:\\ycCheckBill\\Bank_PSBC_20230422.txt"); + Path path = Paths.get("E:\\ycCheckBill\\Bank_PSBC_20230421.txt"); - DateTime start = DateUtil.parse( "2023-04-21 22:30:00"); - DateTime end = DateUtil.parse("2023-04-22 22:29:59"); + DateTime start = DateUtil.parse( "2023-04-20 22:30:00"); + DateTime end = DateUtil.parse("2023-04-21 22:29:59"); QueryWrapper<OrderRecord> wrapper = new QueryWrapper<>(); wrapper.lambda() diff --git a/src/main/java/com/boying/service/FileInfoService.java b/src/main/java/com/boying/service/FileInfoService.java index 6080a63..884c2d8 100644 --- a/src/main/java/com/boying/service/FileInfoService.java +++ b/src/main/java/com/boying/service/FileInfoService.java @@ -16,4 +16,6 @@ void downloadPng(FileInfo byId,HttpServletRequest request, HttpServletResponse response); void getFile(String downloadPath, HttpServletResponse response); + + void getFileById(Long fileId, HttpServletResponse response); } diff --git a/src/main/java/com/boying/service/impl/FileInfoServiceImpl.java b/src/main/java/com/boying/service/impl/FileInfoServiceImpl.java index c1eae7f..7978673 100644 --- a/src/main/java/com/boying/service/impl/FileInfoServiceImpl.java +++ b/src/main/java/com/boying/service/impl/FileInfoServiceImpl.java @@ -31,6 +31,7 @@ public class FileInfoServiceImpl extends ServiceImpl<FileInfoMapper, FileInfo> implements FileInfoService { private final SystemConfigProperties systemConfigProperties; + private final FileInfoMapper fileInfoMapper; @Override public String downloadPathFile(String downloadPath, HttpServletRequest request, HttpServletResponse response) { //璁剧疆鏂囦欢璺緞 @@ -166,4 +167,16 @@ System.out.println("鏂囦欢璇诲彇寮傚父锛�"+e.getLocalizedMessage()); } } + + @Override + public void getFileById(Long fileId, HttpServletResponse response) { + try { + FileInfo fileInfo = fileInfoMapper.selectById(fileId); + InputStream input = new FileInputStream(new File(fileInfo.getFileBaseDir()+fileInfo.getFileName()+fileInfo.getFileLast())); + response.setContentType(MediaType.IMAGE_PNG_VALUE); + IoUtil.copy(input, response.getOutputStream()); + }catch (Exception e){ + System.out.println("鏂囦欢璇诲彇寮傚父锛�"+e.getLocalizedMessage()); + } + } } -- Gitblit v1.9.1