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