From 3c00fb91eb2f617922730e7d0c56ea0e1ad373e0 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期二, 05 九月 2023 18:23:29 +0800
Subject: [PATCH] 新增数据接入接口

---
 src/main/java/com/job/zsc/pojo/DustExceptionData.java               |   16 +
 src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java |   38 +++
 hs_err_pid13764.log                                                 |  397 ++++++++++++++++++++++++++++++++++++
 src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml        |   42 +++
 src/main/java/com/job/zsc/pojo/AuditInfo.java                       |   25 ++
 src/main/java/com/job/zsc/controller/FugitiveDustController.java    |   33 +++
 src/main/java/com/job/zsc/service/FugitiveDustService.java          |   11 +
 src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java            |   20 +
 src/main/java/com/job/zsc/pojo/DustDataAccessSetting.java           |   27 ++
 src/main/java/com/job/zsc/controller/dustAudit/audit                |    0 
 10 files changed, 603 insertions(+), 6 deletions(-)

diff --git a/hs_err_pid13764.log b/hs_err_pid13764.log
new file mode 100644
index 0000000..600bd6f
--- /dev/null
+++ b/hs_err_pid13764.log
@@ -0,0 +1,397 @@
+#
+# A fatal error has been detected by the Java Runtime Environment:
+#
+#  EXCEPTION_STACK_OVERFLOW (0xc00000fd) at pc=0x0000000062c45127, pid=13764, tid=0x00000000000069f4
+#
+# JRE version: Java(TM) SE Runtime Environment (8.0_251-b08) (build 1.8.0_251-b08)
+# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.251-b08 mixed mode windows-amd64 compressed oops)
+# Problematic frame:
+# V  [jvm.dll+0x215127]
+#
+# Failed to write core dump. Minidumps are not enabled by default on client versions of Windows
+#
+# If you would like to submit a bug report, please visit:
+#   http://bugreport.java.com/bugreport/crash.jsp
+#
+
+---------------  T H R E A D  ---------------
+
+Current thread (0x0000000019c17800):  JavaThread "HikariPool-1 connection adder" daemon [_thread_in_vm, id=27124, stack(0x000000001b5f0000,0x000000001b6f0000)]
+
+siginfo: ExceptionCode=0xc00000fd, ExceptionInformation=0x0000000000000001 0x000000001b6ec4c0 
+
+Registers:
+RAX=0x000000001b6ec4c0, RBX=0x0000000000000004, RCX=0x0000000000003000, RDX=0x0000000000000006
+RSP=0x000000001b6ef4c0, RBP=0x0000000000000000, RSI=0x000000001b6ef4c0, RDI=0x0000000000000004
+R8 =0x0000000000000006, R9 =0x000000001ca183b0, R10=0x00000000176ce2f0, R11=0x000000001b5fa148
+R12=0x000000001ca183b0, R13=0x0000000019c17800, R14=0x000000001b6ef588, R15=0x00000000176ce2f0
+RIP=0x0000000062c45127, EFLAGS=0x0000000000010206
+
+Top of Stack: (sp=0x000000001b6ef4c0)
+0x000000001b6ef4c0:   0000b3edd6466fc0 0000000100006c48
+0x000000001b6ef4d0:   0000000019c17800 000000001ca183b0
+0x000000001b6ef4e0:   00000000ffffffff 0000000062c46057
+0x000000001b6ef4f0:   000000001b6ef5f0 00000000176ce2f0
+0x000000001b6ef500:   0000000019c17800 0000000062af1193
+0x000000001b6ef510:   000000001b6ef550 0000000019c17800
+0x000000001b6ef520:   000000001b6ef5e0 0000000019c17800
+0x000000001b6ef530:   00000000176ce2f0 0000000019c17800
+0x000000001b6ef540:   00000000033b3be0 0000000019c17800
+0x000000001b6ef550:   00000000176ce2f0 0000000019c17800
+0x000000001b6ef560:   00000000176ce2f0 0000000019c17800
+0x000000001b6ef570:   0000000000000001 00000000176ce2f0
+0x000000001b6ef580:   0000000019c17800 000000001c734b90
+0x000000001b6ef590:   0000000019c17800 0000000062af28fd
+0x000000001b6ef5a0:   000000001b6ef8a8 0000000100006c48
+0x000000001b6ef5b0:   0000000100006c48 0000000000bbb000 
+
+Instructions: (pc=0x0000000062c45127)
+0x0000000062c45107:   48 89 6c 24 30 33 ed 66 90 e8 6b 5e 08 00 ff c3
+0x0000000062c45117:   48 63 c8 48 8b c6 48 0f af cf 48 ff c7 48 2b c1
+0x0000000062c45127:   89 28 48 63 c3 48 3b 05 f5 f8 59 00 7e db 48 8b
+0x0000000062c45137:   6c 24 30 48 8b 5c 24 38 48 8b 74 24 40 48 83 c4 
+
+
+Register to memory mapping:
+
+RAX=0x000000001b6ec4c0 is pointing into the stack for thread: 0x0000000019c17800
+RBX=0x0000000000000004 is an unknown value
+RCX=0x0000000000003000 is an unknown value
+RDX=0x0000000000000006 is an unknown value
+RSP=0x000000001b6ef4c0 is pointing into the stack for thread: 0x0000000019c17800
+RBP=0x0000000000000000 is an unknown value
+RSI=0x000000001b6ef4c0 is pointing into the stack for thread: 0x0000000019c17800
+RDI=0x0000000000000004 is an unknown value
+R8 =0x0000000000000006 is an unknown value
+R9 =0x000000001ca183b0 is an unknown value
+R10={method} {0x00000000176ce2f8} 'run' '()V' in 'java/lang/Thread'
+R11=0x000000001b5fa148 is pointing into the stack for thread: 0x0000000019c17800
+R12=0x000000001ca183b0 is an unknown value
+R13=0x0000000019c17800 is a thread
+R14=0x000000001b6ef588 is pointing into the stack for thread: 0x0000000019c17800
+R15={method} {0x00000000176ce2f8} 'run' '()V' in 'java/lang/Thread'
+
+
+Stack: [0x000000001b5f0000,0x000000001b6f0000],  sp=0x000000001b6ef4c0,  free space=1021k
+Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
+
+
+---------------  P R O C E S S  ---------------
+
+Java Threads: ( => current thread )
+=>0x0000000019c17800 JavaThread "HikariPool-1 connection adder" daemon [_thread_in_vm, id=27124, stack(0x000000001b5f0000,0x000000001b6f0000)]
+  0x0000000019c1e800 JavaThread "HikariPool-1 connection closer" daemon [_thread_blocked, id=11500, stack(0x0000000001160000,0x0000000001260000)]
+  0x0000000019c1d800 JavaThread "HikariPool-1 housekeeper" daemon [_thread_blocked, id=30208, stack(0x000000001f5c0000,0x000000001f6c0000)]
+  0x0000000019c1b800 JavaThread "DestroyJavaVM" [_thread_blocked, id=19656, stack(0x0000000002fe0000,0x00000000030e0000)]
+  0x0000000019c17000 JavaThread "http-nio-8081-Acceptor" daemon [_thread_in_native, id=32528, stack(0x000000001ebc0000,0x000000001ecc0000)]
+  0x0000000019c1c000 JavaThread "http-nio-8081-Poller" daemon [_thread_blocked, id=21280, stack(0x000000001eac0000,0x000000001ebc0000)]
+  0x0000000019c1a800 JavaThread "http-nio-8081-exec-10" daemon [_thread_blocked, id=23936, stack(0x000000001e8c0000,0x000000001e9c0000)]
+  0x0000000019c16000 JavaThread "http-nio-8081-exec-9" daemon [_thread_blocked, id=31076, stack(0x000000001e7c0000,0x000000001e8c0000)]
+  0x0000000019c13000 JavaThread "http-nio-8081-exec-8" daemon [_thread_blocked, id=23800, stack(0x000000001e6c0000,0x000000001e7c0000)]
+  0x0000000019c14000 JavaThread "http-nio-8081-exec-7" daemon [_thread_blocked, id=25752, stack(0x000000001e5c0000,0x000000001e6c0000)]
+  0x0000000019c19000 JavaThread "http-nio-8081-exec-6" daemon [_thread_blocked, id=21020, stack(0x000000001e4c0000,0x000000001e5c0000)]
+  0x0000000019c18800 JavaThread "http-nio-8081-exec-5" daemon [_thread_blocked, id=23392, stack(0x000000001e3c0000,0x000000001e4c0000)]
+  0x0000000019c15800 JavaThread "http-nio-8081-exec-4" daemon [_thread_blocked, id=34640, stack(0x000000001e2c0000,0x000000001e3c0000)]
+  0x0000000019c1a000 JavaThread "http-nio-8081-exec-3" daemon [_thread_blocked, id=20620, stack(0x000000001e1c0000,0x000000001e2c0000)]
+  0x0000000019c14800 JavaThread "http-nio-8081-exec-2" daemon [_thread_blocked, id=20144, stack(0x000000001e0c0000,0x000000001e1c0000)]
+  0x000000001c57b000 JavaThread "http-nio-8081-exec-1" daemon [_thread_blocked, id=31808, stack(0x000000001dfc0000,0x000000001e0c0000)]
+  0x000000001c57a000 JavaThread "mysql-cj-abandoned-connection-cleanup" daemon [_thread_blocked, id=33288, stack(0x000000001d8c0000,0x000000001d9c0000)]
+  0x000000001c57c800 JavaThread "container-0" [_thread_blocked, id=19248, stack(0x000000001d7c0000,0x000000001d8c0000)]
+  0x000000001c57b800 JavaThread "Catalina-utility-2" [_thread_blocked, id=26212, stack(0x000000001d6c0000,0x000000001d7c0000)]
+  0x000000001c57d000 JavaThread "Catalina-utility-1" [_thread_blocked, id=26960, stack(0x000000001b7f0000,0x000000001b8f0000)]
+  0x000000001add7000 JavaThread "RMI Scheduler(0)" daemon [_thread_blocked, id=29792, stack(0x000000001b6f0000,0x000000001b7f0000)]
+  0x000000001a9c6800 JavaThread "RMI TCP Accept-0" daemon [_thread_in_native, id=23572, stack(0x000000001aff0000,0x000000001b0f0000)]
+  0x0000000019dad800 JavaThread "Service Thread" daemon [_thread_blocked, id=6428, stack(0x000000001a400000,0x000000001a500000)]
+  0x0000000019d0f800 JavaThread "C1 CompilerThread2" daemon [_thread_blocked, id=20288, stack(0x000000001a300000,0x000000001a400000)]
+  0x0000000019d0c800 JavaThread "C2 CompilerThread1" daemon [_thread_blocked, id=3956, stack(0x000000001a200000,0x000000001a300000)]
+  0x0000000019d0b000 JavaThread "C2 CompilerThread0" daemon [_thread_blocked, id=20944, stack(0x000000001a100000,0x000000001a200000)]
+  0x0000000019ce6800 JavaThread "Monitor Ctrl-Break" daemon [_thread_in_native, id=25896, stack(0x000000001a000000,0x000000001a100000)]
+  0x0000000019a0a800 JavaThread "Attach Listener" daemon [_thread_blocked, id=19256, stack(0x0000000019f00000,0x000000001a000000)]
+  0x0000000019a56800 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=23928, stack(0x0000000019e00000,0x0000000019f00000)]
+  0x000000000339a000 JavaThread "Finalizer" daemon [_thread_blocked, id=788, stack(0x0000000019900000,0x0000000019a00000)]
+  0x000000001806b800 JavaThread "Reference Handler" daemon [_thread_blocked, id=22044, stack(0x0000000019800000,0x0000000019900000)]
+
+Other Threads:
+  0x0000000018047800 VMThread [stack: 0x0000000019700000,0x0000000019800000] [id=8292]
+  0x000000001a9d1000 WatcherThread [stack: 0x000000001b0f0000,0x000000001b1f0000] [id=24424]
+
+VM state:synchronizing (normal execution)
+
+VM Mutex/Monitor currently owned by a thread:  ([mutex/lock_event])
+[0x00000000032a3dc0] Threads_lock - owner thread: 0x0000000018047800
+
+heap address: 0x0000000082800000, size: 2008 MB, Compressed Oops mode: 32-bit
+Narrow klass base: 0x0000000000000000, Narrow klass shift: 3
+Compressed class space size: 1073741824 Address: 0x0000000100000000
+
+Heap:
+ PSYoungGen      total 245760K, used 74402K [0x00000000d6300000, 0x00000000ea600000, 0x0000000100000000)
+  eden space 232448K, 31% used [0x00000000d6300000,0x00000000daa9ed68,0x00000000e4600000)
+  from space 13312K, 7% used [0x00000000e4600000,0x00000000e4709ae0,0x00000000e5300000)
+  to   space 12800K, 0% used [0x00000000e9980000,0x00000000e9980000,0x00000000ea600000)
+ ParOldGen       total 71680K, used 20755K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c44d68,0x0000000086e00000)
+ Metaspace       used 45182K, capacity 48103K, committed 48256K, reserved 1091584K
+  class space    used 5721K, capacity 6266K, committed 6272K, reserved 1048576K
+
+Card table byte_map: [0x0000000012760000,0x0000000012b50000] byte_map_base: 0x000000001234c000
+
+Marking Bits: (ParMarkBitMap*) 0x000000006325af90
+ Begin Bits: [0x00000000133f0000, 0x0000000015350000)
+ End Bits:   [0x0000000015350000, 0x00000000172b0000)
+
+Polling page: 0x0000000000d60000
+
+CodeCache: size=245760Kb used=14669Kb max_used=14669Kb free=231090Kb
+ bounds [0x00000000033a0000, 0x0000000004200000, 0x00000000123a0000]
+ total_blobs=8101 nmethods=7555 adapters=458
+ compilation: enabled
+
+Compilation events (10 events):
+Event: 5363.600 Thread 0x0000000019d0f800 7661       1       java.security.AlgorithmParametersSpi::<init> (5 bytes)
+Event: 5363.600 Thread 0x0000000019d0f800 nmethod 7661 0x00000000041f4590 code [0x00000000041f46e0, 0x00000000041f47f0]
+Event: 5363.600 Thread 0x0000000019d0f800 7660       1       sun.security.ssl.SSLSocketImpl::initHandshaker (260 bytes)
+Event: 5363.606 Thread 0x0000000019d0f800 nmethod 7660 0x00000000041f4850 code [0x00000000041f49e0, 0x00000000041f4ec8]
+Event: 5363.606 Thread 0x0000000019d0f800 7663       1       javax.crypto.spec.SecretKeySpec::<init> (54 bytes)
+Event: 5363.607 Thread 0x0000000019d0f800 nmethod 7663 0x00000000041f5090 code [0x00000000041f5220, 0x00000000041f5528]
+Event: 5363.607 Thread 0x0000000019d0f800 7662       1       sun.security.ssl.HandshakeInStream::digestNow (8 bytes)
+Event: 5363.608 Thread 0x0000000019d0f800 nmethod 7662 0x00000000041f56d0 code [0x00000000041f5820, 0x00000000041f5968]
+Event: 5363.608 Thread 0x0000000019d0f800 7664       1       com.mysql.cj.protocol.a.NativeProtocol::versionMeetsMinimum (21 bytes)
+Event: 5363.612 Thread 0x0000000019d0f800 nmethod 7664 0x00000000041f5a10 code [0x00000000041f5b80, 0x00000000041f5d78]
+
+GC Heap History (10 events):
+Event: 231.996 GC heap before
+{Heap before GC invocations=13 (full 2):
+ PSYoungGen      total 128000K, used 127645K [0x00000000d6300000, 0x00000000df000000, 0x0000000100000000)
+  eden space 117248K, 100% used [0x00000000d6300000,0x00000000dd580000,0x00000000dd580000)
+  from space 10752K, 96% used [0x00000000de580000,0x00000000defa7730,0x00000000df000000)
+  to   space 12288K, 0% used [0x00000000dd800000,0x00000000dd800000,0x00000000de400000)
+ ParOldGen       total 71680K, used 13180K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 18% used [0x0000000082800000,0x00000000834df138,0x0000000086e00000)
+ Metaspace       used 44934K, capacity 47715K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+Event: 232.049 GC heap after
+Heap after GC invocations=13 (full 2):
+ PSYoungGen      total 132096K, used 4096K [0x00000000d6300000, 0x00000000e2300000, 0x0000000100000000)
+  eden space 119808K, 0% used [0x00000000d6300000,0x00000000d6300000,0x00000000dd800000)
+  from space 12288K, 33% used [0x00000000dd800000,0x00000000ddc00030,0x00000000de400000)
+  to   space 12288K, 0% used [0x00000000e1700000,0x00000000e1700000,0x00000000e2300000)
+ ParOldGen       total 71680K, used 18187K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 25% used [0x0000000082800000,0x00000000839c2dd8,0x0000000086e00000)
+ Metaspace       used 44934K, capacity 47715K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+}
+Event: 596.955 GC heap before
+{Heap before GC invocations=14 (full 2):
+ PSYoungGen      total 132096K, used 123904K [0x00000000d6300000, 0x00000000e2300000, 0x0000000100000000)
+  eden space 119808K, 100% used [0x00000000d6300000,0x00000000dd800000,0x00000000dd800000)
+  from space 12288K, 33% used [0x00000000dd800000,0x00000000ddc00030,0x00000000de400000)
+  to   space 12288K, 0% used [0x00000000e1700000,0x00000000e1700000,0x00000000e2300000)
+ ParOldGen       total 71680K, used 18187K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 25% used [0x0000000082800000,0x00000000839c2dd8,0x0000000086e00000)
+ Metaspace       used 44959K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+Event: 597.062 GC heap after
+Heap after GC invocations=14 (full 2):
+ PSYoungGen      total 183808K, used 256K [0x00000000d6300000, 0x00000000e2400000, 0x0000000100000000)
+  eden space 171520K, 0% used [0x00000000d6300000,0x00000000d6300000,0x00000000e0a80000)
+  from space 12288K, 2% used [0x00000000e1700000,0x00000000e1740000,0x00000000e2300000)
+  to   space 12800K, 0% used [0x00000000e0a80000,0x00000000e0a80000,0x00000000e1700000)
+ ParOldGen       total 71680K, used 20667K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c2ed68,0x0000000086e00000)
+ Metaspace       used 44959K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+}
+Event: 797.267 GC heap before
+{Heap before GC invocations=15 (full 2):
+ PSYoungGen      total 183808K, used 171776K [0x00000000d6300000, 0x00000000e2400000, 0x0000000100000000)
+  eden space 171520K, 100% used [0x00000000d6300000,0x00000000e0a80000,0x00000000e0a80000)
+  from space 12288K, 2% used [0x00000000e1700000,0x00000000e1740000,0x00000000e2300000)
+  to   space 12800K, 0% used [0x00000000e0a80000,0x00000000e0a80000,0x00000000e1700000)
+ ParOldGen       total 71680K, used 20667K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c2ed68,0x0000000086e00000)
+ Metaspace       used 44969K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+Event: 797.288 GC heap after
+Heap after GC invocations=15 (full 2):
+ PSYoungGen      total 184320K, used 224K [0x00000000d6300000, 0x00000000e6580000, 0x0000000100000000)
+  eden space 171520K, 0% used [0x00000000d6300000,0x00000000d6300000,0x00000000e0a80000)
+  from space 12800K, 1% used [0x00000000e0a80000,0x00000000e0ab8000,0x00000000e1700000)
+  to   space 12800K, 0% used [0x00000000e5900000,0x00000000e5900000,0x00000000e6580000)
+ ParOldGen       total 71680K, used 20707K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c38d68,0x0000000086e00000)
+ Metaspace       used 44969K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+}
+Event: 1159.330 GC heap before
+{Heap before GC invocations=16 (full 2):
+ PSYoungGen      total 184320K, used 171744K [0x00000000d6300000, 0x00000000e6580000, 0x0000000100000000)
+  eden space 171520K, 100% used [0x00000000d6300000,0x00000000e0a80000,0x00000000e0a80000)
+  from space 12800K, 1% used [0x00000000e0a80000,0x00000000e0ab8000,0x00000000e1700000)
+  to   space 12800K, 0% used [0x00000000e5900000,0x00000000e5900000,0x00000000e6580000)
+ ParOldGen       total 71680K, used 20707K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c38d68,0x0000000086e00000)
+ Metaspace       used 44972K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+Event: 1159.359 GC heap after
+Heap after GC invocations=16 (full 2):
+ PSYoungGen      total 239616K, used 288K [0x00000000d6300000, 0x00000000e6000000, 0x0000000100000000)
+  eden space 232448K, 0% used [0x00000000d6300000,0x00000000d6300000,0x00000000e4600000)
+  from space 7168K, 4% used [0x00000000e5900000,0x00000000e5948000,0x00000000e6000000)
+  to   space 13312K, 0% used [0x00000000e4600000,0x00000000e4600000,0x00000000e5300000)
+ ParOldGen       total 71680K, used 20739K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c40d68,0x0000000086e00000)
+ Metaspace       used 44972K, capacity 47779K, committed 48000K, reserved 1091584K
+  class space    used 5701K, capacity 6232K, committed 6272K, reserved 1048576K
+}
+Event: 2661.073 GC heap before
+{Heap before GC invocations=17 (full 2):
+ PSYoungGen      total 239616K, used 232736K [0x00000000d6300000, 0x00000000e6000000, 0x0000000100000000)
+  eden space 232448K, 100% used [0x00000000d6300000,0x00000000e4600000,0x00000000e4600000)
+  from space 7168K, 4% used [0x00000000e5900000,0x00000000e5948000,0x00000000e6000000)
+  to   space 13312K, 0% used [0x00000000e4600000,0x00000000e4600000,0x00000000e5300000)
+ ParOldGen       total 71680K, used 20739K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c40d68,0x0000000086e00000)
+ Metaspace       used 45084K, capacity 47919K, committed 48000K, reserved 1091584K
+  class space    used 5708K, capacity 6246K, committed 6272K, reserved 1048576K
+Event: 2661.196 GC heap after
+Heap after GC invocations=17 (full 2):
+ PSYoungGen      total 245760K, used 1062K [0x00000000d6300000, 0x00000000ea600000, 0x0000000100000000)
+  eden space 232448K, 0% used [0x00000000d6300000,0x00000000d6300000,0x00000000e4600000)
+  from space 13312K, 7% used [0x00000000e4600000,0x00000000e4709ae0,0x00000000e5300000)
+  to   space 12800K, 0% used [0x00000000e9980000,0x00000000e9980000,0x00000000ea600000)
+ ParOldGen       total 71680K, used 20755K [0x0000000082800000, 0x0000000086e00000, 0x00000000d6300000)
+  object space 71680K, 28% used [0x0000000082800000,0x0000000083c44d68,0x0000000086e00000)
+ Metaspace       used 45084K, capacity 47919K, committed 48000K, reserved 1091584K
+  class space    used 5708K, capacity 6246K, committed 6272K, reserved 1048576K
+}
+
+Deoptimization events (0 events):
+No events
+
+Classes redefined (0 events):
+No events
+
+Internal exceptions (10 events):
+Event: 17.107 Thread 0x000000001c57b000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7845720) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 17.110 Thread 0x000000001c57b000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d789cf10) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 17.114 Thread 0x000000001c57b000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7903eb0) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 17.114 Thread 0x000000001c57b000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7906488) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 17.114 Thread 0x000000001c57b000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7908788) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 50.763 Thread 0x0000000019c14800 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7b390c8) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 50.809 Thread 0x0000000019c1a000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7d21a60) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 50.899 Thread 0x0000000019c18800 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d7f0c118) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 3502.619 Thread 0x0000000019c19000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d9277ce0) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+Event: 3550.783 Thread 0x0000000019c14000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x00000000d98dafb0) thrown at [C:\jenkins\workspace\8-2-build-windows-amd64-cygwin\jdk8u251\737\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
+
+Events (10 events):
+Event: 5363.575 Thread 0x0000000019c17800 Thread added: 0x0000000019c17800
+Event: 5368.608 Executing VM operation: RevokeBias
+Event: 5368.639 Executing VM operation: RevokeBias done
+Event: 5368.639 Executing VM operation: RevokeBias
+Event: 5368.640 Executing VM operation: RevokeBias done
+Event: 5368.640 Thread 0x0000000019c1e800 Thread exited: 0x0000000019c1e800
+Event: 5368.640 Thread 0x0000000019c17800 Thread exited: 0x0000000019c17800
+Event: 5368.952 Thread 0x0000000019c1e800 Thread added: 0x0000000019c1e800
+Event: 5368.964 Thread 0x0000000019c17800 Thread added: 0x0000000019c17800
+Event: 5369.135 Executing VM operation: RevokeBias
+
+
+Dynamic libraries:
+0x00007ff761ca0000 - 0x00007ff761cd7000 	E:\ruanjian\JDK-1.8\bin\java.exe
+0x00007ff981410000 - 0x00007ff981608000 	C:\Windows\SYSTEM32\ntdll.dll
+0x00007ff97f4d0000 - 0x00007ff97f58f000 	C:\Windows\System32\KERNEL32.DLL
+0x00007ff97eeb0000 - 0x00007ff97f1a6000 	C:\Windows\System32\KERNELBASE.dll
+0x00007ff980e30000 - 0x00007ff980edf000 	C:\Windows\System32\ADVAPI32.dll
+0x00007ff981280000 - 0x00007ff98131e000 	C:\Windows\System32\msvcrt.dll
+0x00007ff9802e0000 - 0x00007ff98037c000 	C:\Windows\System32\sechost.dll
+0x00007ff97f770000 - 0x00007ff97f896000 	C:\Windows\System32\RPCRT4.dll
+0x00007ff981080000 - 0x00007ff98121d000 	C:\Windows\System32\USER32.dll
+0x00007ff97e9f0000 - 0x00007ff97ea12000 	C:\Windows\System32\win32u.dll
+0x00007ff980380000 - 0x00007ff9803ac000 	C:\Windows\System32\GDI32.dll
+0x00007ff97eaf0000 - 0x00007ff97ec05000 	C:\Windows\System32\gdi32full.dll
+0x00007ff97e8e0000 - 0x00007ff97e97d000 	C:\Windows\System32\msvcp_win.dll
+0x00007ff97ec10000 - 0x00007ff97ed10000 	C:\Windows\System32\ucrtbase.dll
+0x00007ff95bde0000 - 0x00007ff95c07a000 	C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.19041.1110_none_60b5254171f9507e\COMCTL32.dll
+0x00007ff981330000 - 0x00007ff981360000 	C:\Windows\System32\IMM32.DLL
+0x00000000632e0000 - 0x00000000633b2000 	E:\ruanjian\JDK-1.8\jre\bin\msvcr100.dll
+0x0000000062a30000 - 0x00000000632db000 	E:\ruanjian\JDK-1.8\jre\bin\server\jvm.dll
+0x00007ff9813c0000 - 0x00007ff9813c8000 	C:\Windows\System32\PSAPI.DLL
+0x00007ff967ae0000 - 0x00007ff967ae9000 	C:\Windows\SYSTEM32\WSOCK32.dll
+0x00007ff967a80000 - 0x00007ff967aa7000 	C:\Windows\SYSTEM32\WINMM.dll
+0x00007ff9781e0000 - 0x00007ff9781ea000 	C:\Windows\SYSTEM32\VERSION.dll
+0x00007ff981010000 - 0x00007ff98107b000 	C:\Windows\System32\WS2_32.dll
+0x00007ff96b050000 - 0x00007ff96b05f000 	E:\ruanjian\JDK-1.8\jre\bin\verify.dll
+0x00007ff959f20000 - 0x00007ff959f49000 	E:\ruanjian\JDK-1.8\jre\bin\java.dll
+0x00007ff96d590000 - 0x00007ff96d5b3000 	E:\ruanjian\JDK-1.8\jre\bin\instrument.dll
+0x00007ff95dd00000 - 0x00007ff95dd16000 	E:\ruanjian\JDK-1.8\jre\bin\zip.dll
+0x00007ff97fa50000 - 0x00007ff980194000 	C:\Windows\System32\SHELL32.dll
+0x00007ff97c9a0000 - 0x00007ff97d133000 	C:\Windows\SYSTEM32\windows.storage.dll
+0x00007ff9803b0000 - 0x00007ff980704000 	C:\Windows\System32\combase.dll
+0x00007ff97e1b0000 - 0x00007ff97e1de000 	C:\Windows\SYSTEM32\Wldp.dll
+0x00007ff97f8a0000 - 0x00007ff97f94d000 	C:\Windows\System32\SHCORE.dll
+0x00007ff9801a0000 - 0x00007ff9801f5000 	C:\Windows\System32\shlwapi.dll
+0x00007ff97e6c0000 - 0x00007ff97e6df000 	C:\Windows\SYSTEM32\profapi.dll
+0x00007ff977390000 - 0x00007ff9773aa000 	E:\ruanjian\IntelliJ IDEA 2022.2.2\bin\breakgen64.dll
+0x00007ff959c40000 - 0x00007ff959c5a000 	E:\ruanjian\JDK-1.8\jre\bin\net.dll
+0x00007ff97dea0000 - 0x00007ff97df0a000 	C:\Windows\system32\mswsock.dll
+0x00007ff97dbd0000 - 0x00007ff97dc9a000 	C:\Windows\SYSTEM32\DNSAPI.dll
+0x00007ff97db90000 - 0x00007ff97dbcc000 	C:\Windows\SYSTEM32\IPHLPAPI.DLL
+0x00007ff981320000 - 0x00007ff981328000 	C:\Windows\System32\NSI.dll
+0x00007ff976ab0000 - 0x00007ff976aba000 	C:\Windows\System32\rasadhlp.dll
+0x00007ff96e200000 - 0x00007ff96e30e000 	C:\Windows\SSLVPNRedirector64.dll
+0x00007ff980bb0000 - 0x00007ff980c7d000 	C:\Windows\System32\OLEAUT32.dll
+0x00007ff974dc0000 - 0x00007ff974e26000 	C:\Windows\SYSTEM32\OLEACC.dll
+0x00007ff96e160000 - 0x00007ff96e1fd000 	C:\Windows\SYSTEM32\WINSPOOL.DRV
+0x00007ff974b00000 - 0x00007ff974b17000 	C:\Windows\SYSTEM32\dhcpcsvc6.DLL
+0x00007ff976830000 - 0x00007ff97684d000 	C:\Windows\SYSTEM32\dhcpcsvc.DLL
+0x00007ff975790000 - 0x00007ff975812000 	C:\Windows\System32\fwpuclnt.dll
+0x00007ff97f1b0000 - 0x00007ff97f1d7000 	C:\Windows\System32\bcrypt.dll
+0x00007ff963ed0000 - 0x00007ff963edd000 	E:\ruanjian\JDK-1.8\jre\bin\management.dll
+0x00007ff9564f0000 - 0x00007ff956502000 	E:\ruanjian\JDK-1.8\jre\bin\nio.dll
+0x00007ff97e090000 - 0x00007ff97e0a8000 	C:\Windows\SYSTEM32\CRYPTSP.dll
+0x00007ff97d7c0000 - 0x00007ff97d7f4000 	C:\Windows\system32\rsaenh.dll
+0x00007ff97e680000 - 0x00007ff97e6ae000 	C:\Windows\SYSTEM32\USERENV.dll
+0x00007ff97ed10000 - 0x00007ff97ed92000 	C:\Windows\System32\bcryptprimitives.dll
+0x00007ff97e0b0000 - 0x00007ff97e0bc000 	C:\Windows\SYSTEM32\CRYPTBASE.dll
+0x00007ff964100000 - 0x00007ff964117000 	C:\Windows\system32\napinsp.dll
+0x00007ff963db0000 - 0x00007ff963dcb000 	C:\Windows\system32\pnrpnsp.dll
+0x00007ff979b00000 - 0x00007ff979b15000 	C:\Windows\system32\wshbth.dll
+0x00007ff97a2b0000 - 0x00007ff97a2cd000 	C:\Windows\system32\NLAapi.dll
+0x00007ff963d90000 - 0x00007ff963da2000 	C:\Windows\System32\winrnr.dll
+0x00007ff96c170000 - 0x00007ff96c194000 	E:\ruanjian\JDK-1.8\jre\bin\sunec.dll
+0x00007ff97a300000 - 0x00007ff97a30c000 	E:\ruanjian\JDK-1.8\jre\bin\sunmscapi.dll
+0x00007ff97e780000 - 0x00007ff97e8de000 	C:\Windows\System32\CRYPT32.dll
+0x00007ff97e220000 - 0x00007ff97e248000 	C:\Windows\SYSTEM32\ncrypt.dll
+0x00007ff97e1e0000 - 0x00007ff97e21b000 	C:\Windows\SYSTEM32\NTASN1.dll
+0x00007ff96cca0000 - 0x00007ff96ce84000 	C:\Windows\SYSTEM32\dbghelp.dll
+
+VM Arguments:
+jvm_args: -XX:TieredStopAtLevel=1 -Xverify:none -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:E:\ruanjian\IntelliJ IDEA 2022.2.2\lib\idea_rt.jar=60341:E:\ruanjian\IntelliJ IDEA 2022.2.2\bin -Dfile.encoding=UTF-8 
+java_command: com.job.zsc.QianduanApplication
+java_class_path (initial): E:\ruanjian\JDK-1.8\jre\lib\charsets.jar;E:\ruanjian\JDK-1.8\jre\lib\deploy.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\access-bridge-64.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\cldrdata.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\dnsns.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\jaccess.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\jfxrt.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\localedata.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\nashorn.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\sunec.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\sunjce_provider.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\sunmscapi.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\sunpkcs11.jar;E:\ruanjian\JDK-1.8\jre\lib\ext\zipfs.jar;E:\ruanjian\JDK-1.8\jre\lib\javaws.jar;E:\ruanjian\JDK-1.8\jre\lib\jce.jar;E:\ruanjian\JDK-1.8\jre\lib\jfr.jar;E:\ruanjian\JDK-1.8\jre\lib\jfxswt.jar;E:\ruanjian\JDK-1.8\jre\lib\jsse.jar;E:\ruanjian\JDK-1.8\jre\lib\management-agent.jar;E:\ruanjian\JDK-1.8\jre\lib\plugin.jar;E:\ruanjian\JDK-1.8\jre\lib\resources.jar;E:\ruanjian\JDK-1.8\jre\lib\rt.jar;D:\z\workplace\qianduan\target\classes;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\org\springframework\boot\spring-boot-starter-web\2.5.15\spring-boot-starter-web-2.5.15.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\org\springframework\boot\spring-boot-starter\2.5.15\spring-boot-starter-2.5.15.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\org\springframework\boot\spring-boot\2.5.15\spring-boot-2.5.15.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\org\springframework\boot\spring-boot-autoconfigure\2.5.15\spring-boot-autoconfigure-2.5.15.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\org\springframework\boot\spring-boot-starter-logging\2.5.15\spring-boot-starter-logging-2.5.15.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\ch\qos\logback\logback-classic\1.2.12\logback-classic-1.2.12.jar;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\mvn_repo\ch\qos\logback\logback-core\1.2.12\logback-core-1.2.12.jar;E:\ruanjian\maven-3.9.2\apache-m
+Launcher Type: SUN_STANDARD
+
+Environment Variables:
+JAVA_HOME=E:\ruanjian\JDK-1.8
+PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;E:\ruanjian\Python\Scripts\;E:\ruanjian\Python\;E:\ruanjian\JDK-1.8\bin;E:\ruanjian\maven-3.9.2\apache-maven-3.9.2\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;E:\ruanjian\NodeJs\;E:\ruanjian\MySql\mysql-8.0.33-winx64\bin\;E:\ruanjian\Git\cmd;E:\ruanjian\Python\Scripts;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;;E:\ruanjian\IntelliJ IDEA 2022.2.2\bin;;C:\Users\Administrator\AppData\Roaming\npm;E:\ruanjian\VsCode\Microsoft VS Code\bin;E:\ruanjian\qudongjinning\DriverGenius;E:\ruanjian\qudongjinning\DriverGenius\ksoft
+USERNAME=Administrator
+OS=Windows_NT
+PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 158 Stepping 10, GenuineIntel
+
+
+
+---------------  S Y S T E M  ---------------
+
+OS: Windows 10.0 , 64 bit Build 19041 (10.0.19041.3031)
+
+CPU:total 6 (initial active 6) (6 cores per cpu, 1 threads per core) family 6 model 158 stepping 10, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt, avx, avx2, aes, clmul, erms, 3dnowpref, lzcnt, tsc, tscinvbit, bmi1, bmi2, adx
+
+Memory: 4k page, physical 8219024k(1225892k free), swap 23748536k(1066908k free)
+
+vm_info: Java HotSpot(TM) 64-Bit Server VM (25.251-b08) for windows-amd64 JRE (1.8.0_251-b08), built on Mar 12 2020 06:31:49 by "" with MS VC++ 10.0 (VS2010)
+
+time: Fri Sep 01 16:09:54 2023
+timezone: 中国标准时间
+elapsed time: 5369 seconds (0d 1h 29m 29s)
+
diff --git a/src/main/java/com/job/zsc/controller/FugitiveDustController.java b/src/main/java/com/job/zsc/controller/FugitiveDustController.java
index ef0ce13..9cd105f 100644
--- a/src/main/java/com/job/zsc/controller/FugitiveDustController.java
+++ b/src/main/java/com/job/zsc/controller/FugitiveDustController.java
@@ -112,10 +112,43 @@
 }
 
     //   杩斿洖寮傚父鐨勫簵閾烘�绘暟
+
     @GetMapping("/exceptionsitenum")
     public Result exceptionSiteNum(){
         List<DustExceptionData> list = fugitiveDustService.exceptionSiteNum();
         return Result.success(list);
     }
 
+    /*鏂板瀹¤鍐呭*/
+    @PostMapping("/audit")
+    public Result addAuditNotes(@RequestBody AuditInfo auditInfo){
+        fugitiveDustService.addAuditNotes(auditInfo);
+        return Result.success();
+    }
+    /*杩斿洖瀹℃牳琛ㄦ墍鏈夋暟鎹�*/
+    @PostMapping("/auditAllData")
+    public Result getAuditAllData(){
+        List<AuditInfo> list = fugitiveDustService.getAuditAllData();
+        return Result.success(list);
+    }
+
+    /*鏇存柊寮傚父琛ㄦ牸*/
+    @PutMapping("/auditUpdate")
+    public Result getAuditAllData(@RequestBody AuditInfo auditInfo){
+        fugitiveDustService.update(auditInfo);
+        return Result.success();
+    }
+
+    /*鏍规嵁寮傚父鏃堕棿杩斿洖鏃堕棿鍐呭凡瀹℃牳鐨勫紓甯�*/
+    @GetMapping("/auditnum")
+    public Result getHasAuditedData(String beginTime, String endTime){
+        List<DustExceptionData> list = fugitiveDustService.getHasAuditedData(beginTime,endTime);
+        return Result.success(list);
+    }
+
+    @PostMapping("setting")
+    public Result setting(@RequestBody DustDataAccessSetting dustDataAccessSetting){
+       fugitiveDustService.setting(dustDataAccessSetting);
+        return Result.success();
+    }
 }
diff --git a/src/main/java/com/job/zsc/controller/dustAudit/audit b/src/main/java/com/job/zsc/controller/dustAudit/audit
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/src/main/java/com/job/zsc/controller/dustAudit/audit
diff --git a/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java b/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java
index 78094de..7598ab1 100644
--- a/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java
+++ b/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java
@@ -1,9 +1,7 @@
 package com.job.zsc.mapper;
 
-import com.job.zsc.pojo.AnalysisDustData;
-import com.job.zsc.pojo.DustExceptionData;
-import com.job.zsc.pojo.DustExceptionType;
-import com.job.zsc.pojo.DustSiteData;
+import com.job.zsc.pojo.*;
+import org.apache.ibatis.annotations.Insert;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Select;
@@ -39,4 +37,18 @@
 
     @Select("select DISTINCT mn_code from dust_exception_data")
     List<DustExceptionData> exceptionSiteNum();
+
+    /*鏂板瀹¤鍐呭*/
+    @Insert("insert into audit_info(exception_id,checker,checker_content,enterprise_content,audit_status,create_time,update_time) values(#{exceptionId},#{checker},#{checkerContent},#{enterpriseContent},#{auditStatus},#{createTime},#{updateTime})")
+    void insert(AuditInfo auditInfo);
+
+    @Select("select * from audit_info")
+    List<AuditInfo> getAuditAllData();
+    void update(AuditInfo auditInfo);
+
+
+    List<DustExceptionData> getHasAuditedData(String beginTime, String endTime);
+
+    @Insert("insert into dust_global_setting(user,create_time,begin_time,end_time,region,is_regular_time) values( #{user},#{createTime},#{beginTime},#{endTime},#{region},#{isRegularTime})")
+    void setting(DustDataAccessSetting dustDataAccessSetting);
 }
diff --git a/src/main/java/com/job/zsc/pojo/AuditInfo.java b/src/main/java/com/job/zsc/pojo/AuditInfo.java
new file mode 100644
index 0000000..1ed0fc5
--- /dev/null
+++ b/src/main/java/com/job/zsc/pojo/AuditInfo.java
@@ -0,0 +1,25 @@
+package com.job.zsc.pojo;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.time.LocalDateTime;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class AuditInfo {
+    private String auditId;
+    private  int exceptionId;
+    private  String checker;
+    private  String checkerContent;
+    private  String enterpriseContent;
+    private  int auditStatus;
+    private LocalDateTime createTime;
+    private LocalDateTime updateTime;
+
+}
+
diff --git a/src/main/java/com/job/zsc/pojo/DustDataAccessSetting.java b/src/main/java/com/job/zsc/pojo/DustDataAccessSetting.java
new file mode 100644
index 0000000..b09e72a
--- /dev/null
+++ b/src/main/java/com/job/zsc/pojo/DustDataAccessSetting.java
@@ -0,0 +1,27 @@
+package com.job.zsc.pojo;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.time.LocalDateTime;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class DustDataAccessSetting {
+
+    private int id;
+    private String user;
+    private LocalDateTime createTime;
+    private LocalDateTime updateTime;
+
+    private String type;
+    private String exceeding;
+    private String beginTime;
+    private String endTime;
+    private String region;
+    private String isRegularTime;
+
+
+}
diff --git a/src/main/java/com/job/zsc/pojo/DustExceptionData.java b/src/main/java/com/job/zsc/pojo/DustExceptionData.java
index 583c7a0..403b458 100644
--- a/src/main/java/com/job/zsc/pojo/DustExceptionData.java
+++ b/src/main/java/com/job/zsc/pojo/DustExceptionData.java
@@ -6,12 +6,13 @@
 import lombok.NoArgsConstructor;
 
 import javax.xml.ws.soap.Addressing;
+import java.time.LocalDateTime;
 
 @Data
 @AllArgsConstructor
 @NoArgsConstructor
 public class DustExceptionData {
-
+    /*寮傚父琛�*/
     private String id;
     private String name;   //绔欑偣鍚嶅瓧
     private String mnCode;      //璁惧缂栧彿
@@ -32,4 +33,17 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private String endTime;
 
+
+    /*瀹℃牳缁撴灉琛�*/
+    private String auditId;
+    private  String exceptionId;
+    private  String checker;
+    private  String checkerContent;
+    private  String enterpriseContent;
+    private  int auditStatus;
+
+    private LocalDateTime createTime;
+    private LocalDateTime updateTime;
+
+
 }
diff --git a/src/main/java/com/job/zsc/service/FugitiveDustService.java b/src/main/java/com/job/zsc/service/FugitiveDustService.java
index 486956a..70a8981 100644
--- a/src/main/java/com/job/zsc/service/FugitiveDustService.java
+++ b/src/main/java/com/job/zsc/service/FugitiveDustService.java
@@ -36,4 +36,15 @@
     List<AnalysisDustData> analysisAll(String siteName, String beginTime, String endTime);
 
     List<DustSiteData> conditonQueryhistoryallData(String siteName, String mnCode, String beginTime, String endTime, String[] scenarioType);
+    /*鏂板瀹¤淇℃伅*/
+    void addAuditNotes(AuditInfo auditInfo);
+
+    List<AuditInfo> getAuditAllData();
+
+    void update(AuditInfo auditInfo);
+
+    List<DustExceptionData> getHasAuditedData(String beginTime, String endTime);
+
+
+    void setting(DustDataAccessSetting dustDataAccessSetting);
 }
diff --git a/src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java b/src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java
index 92d2393..4193d73 100644
--- a/src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java
+++ b/src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java
@@ -9,6 +9,7 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
+import java.time.LocalDateTime;
 import java.util.List;
 
 @Slf4j
@@ -133,5 +134,42 @@
         return list;
     }
 
+    @Override
+    public void addAuditNotes(AuditInfo auditInfo) {
+        if(auditInfo.getAuditStatus()==3){
+            auditInfo.setUpdateTime(LocalDateTime.now());
+            auditInfo.setCreateTime(LocalDateTime.now());
+        }else{
+            auditInfo.setCreateTime(LocalDateTime.now());
+
+        }
+        fugitiveDustMapper.insert(auditInfo);
+    }
+
+    @Override
+    public List<AuditInfo> getAuditAllData() {
+        List<AuditInfo> list = fugitiveDustMapper.getAuditAllData();
+        return list;
+    }
+
+    @Override
+    public void update(AuditInfo auditInfo) {
+        auditInfo.setUpdateTime(LocalDateTime.now());
+        fugitiveDustMapper.update(auditInfo);
+    }
+
+
+    @Override
+    public List<DustExceptionData> getHasAuditedData(String beginTime, String endTime) {
+        List<DustExceptionData> list = fugitiveDustMapper.getHasAuditedData(beginTime,endTime);
+        return list;
+    }
+
+    @Override
+    public void setting(DustDataAccessSetting dustDataAccessSetting) {
+        dustDataAccessSetting.setCreateTime(LocalDateTime.now());
+        fugitiveDustMapper.setting(dustDataAccessSetting);
+    }
+
 
 }
diff --git a/src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml b/src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml
index 04cc427..f6b8a7d 100644
--- a/src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml
+++ b/src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml
@@ -3,6 +3,32 @@
         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
         "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.job.zsc.mapper.FugitiveDustMapper">
+    <update id="update">
+        update audit_info
+        <set>
+            <if test="exceptionId != null and exceptionId!=''" >
+                exception_id = #{exceptionId},
+            </if>
+            <if test="checker != null and checker!=''" >
+                checker = #{checker},
+            </if>
+
+            <if test="checkerContent != null and checkerContent!=''" >
+                checker_content = #{checkerContent} ,
+            </if>
+            <if test="enterpriseContent != null and enterpriseContent!=''" >
+                enterprise_content = #{enterpriseContent},
+            </if>
+            <if test="auditStatus != null and auditStatus!=''" >
+                audit_status = #{auditStatus},
+            </if>
+            <if test="updateTime != null" >
+                update_time = #{updateTime}
+        </if>
+
+        </set>
+        where exception_id = #{exceptionId}
+    </update>
 
     <select id="conditonQueryDustHistoryData" resultType="com.job.zsc.pojo.DustSiteData">
         select a.*,b.*
@@ -72,7 +98,8 @@
 
     <!--鏉′欢鏌ヨ寮傚父鏁版嵁-->
     <select id="getExceptionData" resultType="com.job.zsc.pojo.DustExceptionData">
-        select b.name,b.typename,b.address,b.duty_company,a.*
+        select *
+        from (select a.* ,b.name,b.typename,b.address,b.duty_company
         from dust_exception_data as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code
         <where>
             <if test="siteName !=null and siteName != ''">
@@ -90,6 +117,8 @@
                 and (a.begin_time between #{beginTime} and #{endTime} or a.end_time between #{beginTime} and  #{endTime})
             </if>
         </where>
+        )
+        as c left join audit_info as d  on c.id = d.exception_id
     </select>
 
 
@@ -123,4 +152,15 @@
         </where>
         order by a.lst asc
     </select>
+    <select id="getHasAuditedData" resultType="com.job.zsc.pojo.DustExceptionData">
+        select *
+        from dust_exception_data as a left join audit_info as b on a.id = b.exception_id
+        <where>
+            <if test="beginTime != null and endTime != null">
+                (a.begin_time between #{beginTime} and #{endTime} or a.end_time between #{beginTime} and  #{endTime}) and b.audit_status != 0
+
+            </if>
+        </where>
+
+    </select>
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.3