hs_err_pid36404.log
New file @@ -0,0 +1,198 @@ # # There is insufficient memory for the Java Runtime Environment to continue. # Native memory allocation (mmap) failed to map 134217728 bytes for Failed to commit area from 0x0000000081c00000 to 0x0000000089c00000 of length 134217728. # Possible reasons: # The system is out of physical RAM or swap space # The process is running with CompressedOops enabled, and the Java Heap may be blocking the growth of the native heap # Possible solutions: # Reduce memory load on the system # Increase physical memory or swap space # Check if swap backing store is full # Decrease Java heap size (-Xmx/-Xms) # Decrease number of Java threads # Decrease Java thread stack sizes (-Xss) # Set larger code cache with -XX:ReservedCodeCacheSize= # This output file may be truncated or incomplete. # # Out of Memory Error (./src/hotspot/os/windows/os_windows.cpp:3301), pid=36404, tid=8528 # # JRE version: (11.0.11+9) (build ) # Java VM: OpenJDK 64-Bit Server VM (11.0.11+9-b1341.60, mixed mode, sharing, tiered, compressed oops, g1 gc, windows-amd64) # No core dump will be written. Minidumps are not enabled by default on client versions of Windows # --------------- S U M M A R Y ------------ Command Line: org.jetbrains.git4idea.http.GitAskPassApp Username for 'http://gitlab.nhys.cdnhxx.com': Host: Intel(R) Core(TM) i5-9400 CPU @ 2.90GHz, 6 cores, 7G, Windows 10 , 64 bit Build 19041 (10.0.19041.207) Time: Mon Jul 19 18:25:39 2021 �й���ʱ�� elapsed time: 0.020709 seconds (0d 0h 0m 0s) --------------- T H R E A D --------------- Current thread (0x00000158851b6000): JavaThread "Unknown thread" [_thread_in_vm, id=8528, stack(0x0000003aed700000,0x0000003aed800000)] Stack: [0x0000003aed700000,0x0000003aed800000] Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) V [jvm.dll+0x5f5c8a] V [jvm.dll+0x779405] V [jvm.dll+0x77aa1d] V [jvm.dll+0x77b0d3] V [jvm.dll+0x244bc8] V [jvm.dll+0x5f3084] V [jvm.dll+0x5e7fe5] V [jvm.dll+0x30098b] V [jvm.dll+0x3008fa] V [jvm.dll+0x3007d2] V [jvm.dll+0x3056b6] V [jvm.dll+0x34e353] V [jvm.dll+0x34ea56] V [jvm.dll+0x34e453] V [jvm.dll+0x2db398] V [jvm.dll+0x2dc547] V [jvm.dll+0x757bf7] V [jvm.dll+0x7593ec] V [jvm.dll+0x35b8d9] V [jvm.dll+0x73b38e] V [jvm.dll+0x3c3cc3] V [jvm.dll+0x3c60e1] C [jli.dll+0x5373] C [ucrtbase.dll+0x21542] C [KERNEL32.DLL+0x16fd4] C [ntdll.dll+0x4cec1] --------------- P R O C E S S --------------- Threads class SMR info: _java_thread_list=0x00000158830a0110, length=0, elements={ } Java Threads: ( => current thread ) Other Threads: 0x000001588317d000 GCTaskThread "GC Thread#0" [stack: 0x0000003aed800000,0x0000003aed900000] [id=31824] 0x00000158851fc800 ConcurrentGCThread "G1 Main Marker" [stack: 0x0000003aed900000,0x0000003aeda00000] [id=9432] 0x00000158851fe800 ConcurrentGCThread "G1 Conc#0" [stack: 0x0000003aeda00000,0x0000003aedb00000] [id=28756] [error occurred during error reporting (printing all threads), id 0xc0000005, EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00007ffd7a87b9f7] VM state:not at safepoint (not fully initialized) VM Mutex/Monitor currently owned by a thread: ([mutex/lock_event]) [0x00000158851b2420] Heap_lock - owner thread: 0x00000158851b6000 Heap address: 0x0000000081c00000, size: 2020 MB, Compressed Oops mode: Non-zero based: 0x0000000081c00000 Narrow klass base: 0x0000000000000000, Narrow klass shift: 0 GC Heap History (0 events): No events Deoptimization events (0 events): No events Classes redefined (0 events): No events Internal exceptions (0 events): No events Events (1 events): Event: 0.010 Loaded shared library D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\zip.dll Dynamic libraries: 0x00007ff6ee870000 - 0x00007ff6ee87a000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\java.exe 0x00007ffda5130000 - 0x00007ffda5324000 C:\windows\SYSTEM32\ntdll.dll 0x00007ffda4c20000 - 0x00007ffda4cdd000 C:\windows\System32\KERNEL32.DLL 0x00007ffda2710000 - 0x00007ffda29d7000 C:\windows\System32\KERNELBASE.dll 0x00007ffda2ed0000 - 0x00007ffda2fd0000 C:\windows\System32\ucrtbase.dll 0x00007ffd9c0b0000 - 0x00007ffd9c0c9000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\jli.dll 0x00007ffda3720000 - 0x00007ffda38c0000 C:\windows\System32\USER32.dll 0x00007ffda2d20000 - 0x00007ffda2d42000 C:\windows\System32\win32u.dll 0x00007ffda40e0000 - 0x00007ffda410a000 C:\windows\System32\GDI32.dll 0x00007ffda2c10000 - 0x00007ffda2d1a000 C:\windows\System32\gdi32full.dll 0x00007ffda2b70000 - 0x00007ffda2c0d000 C:\windows\System32\msvcp_win.dll 0x00007ffd8c120000 - 0x00007ffd8c3ba000 C:\windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.19041.1_none_b555e41d4684ddec\COMCTL32.dll 0x00007ffda4ce0000 - 0x00007ffda4d7e000 C:\windows\System32\msvcrt.dll 0x00007ffd9bfd0000 - 0x00007ffd9bfe7000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\VCRUNTIME140.dll 0x00007ffda4ef0000 - 0x00007ffda4f20000 C:\windows\System32\IMM32.DLL 0x00007ffd79c20000 - 0x00007ffd79cbd000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\msvcp140.dll 0x00007ffd7a590000 - 0x00007ffd7b0d9000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\server\jvm.dll 0x00007ffda4f30000 - 0x00007ffda4fda000 C:\windows\System32\ADVAPI32.dll 0x00007ffda3950000 - 0x00007ffda39eb000 C:\windows\System32\sechost.dll 0x00007ffda39f0000 - 0x00007ffda3b13000 C:\windows\System32\RPCRT4.dll 0x00007ffda3fa0000 - 0x00007ffda3fa8000 C:\windows\System32\PSAPI.DLL 0x00007ffd90640000 - 0x00007ffd90649000 C:\windows\SYSTEM32\WSOCK32.dll 0x00007ffda4e80000 - 0x00007ffda4eeb000 C:\windows\System32\WS2_32.dll 0x00007ffda2020000 - 0x00007ffda202a000 C:\windows\SYSTEM32\VERSION.dll 0x00007ffd88dd0000 - 0x00007ffd88df7000 C:\windows\SYSTEM32\WINMM.dll 0x00007ffda2560000 - 0x00007ffda2573000 C:\windows\System32\kernel.appcore.dll 0x00007ffd92480000 - 0x00007ffd92491000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\verify.dll 0x00007ffd8e470000 - 0x00007ffd8e654000 C:\windows\SYSTEM32\DBGHELP.DLL 0x00007ffd8da70000 - 0x00007ffd8da9c000 C:\windows\SYSTEM32\dbgcore.DLL 0x00007ffda2e50000 - 0x00007ffda2ecf000 C:\windows\System32\bcryptPrimitives.dll 0x00007ffd92340000 - 0x00007ffd92369000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\java.dll 0x00007ffd9e180000 - 0x00007ffd9e18b000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\jimage.dll 0x00007ffd921c0000 - 0x00007ffd921d8000 D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\zip.dll dbghelp: loaded successfully - version: 4.0.5 - missing functions: none symbol engine: initialized successfully - sym options: 0x614 - pdb path: .;D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin;C:\windows\SYSTEM32;C:\windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.19041.1_none_b555e41d4684ddec;D:\java\JetBrains\IntelliJ IDEA 2021.1.3\jbr\bin\server VM Arguments: java_command: org.jetbrains.git4idea.http.GitAskPassApp Username for 'http://gitlab.nhys.cdnhxx.com': java_class_path (initial): D:/java/JetBrains/IntelliJ IDEA 2021.1.3/plugins/git4idea/lib/git4idea-rt.jar;D:/java/JetBrains/IntelliJ IDEA 2021.1.3/lib/xmlrpc-2.0.1.jar;D:/java/JetBrains/IntelliJ IDEA 2021.1.3/lib/commons-codec-1.15.jar Launcher Type: SUN_STANDARD [Global flags] intx CICompilerCount = 3 {product} {ergonomic} uint ConcGCThreads = 2 {product} {ergonomic} uint G1ConcRefinementThreads = 6 {product} {ergonomic} size_t G1HeapRegionSize = 1048576 {product} {ergonomic} uintx GCDrainStackTargetSize = 64 {product} {ergonomic} size_t InitialHeapSize = 134217728 {product} {ergonomic} size_t MarkStackSize = 4194304 {product} {ergonomic} size_t MaxHeapSize = 2118123520 {product} {ergonomic} size_t MinHeapDeltaBytes = 1048576 {product} {ergonomic} uintx NonNMethodCodeHeapSize = 5830732 {pd product} {ergonomic} uintx NonProfiledCodeHeapSize = 122913754 {pd product} {ergonomic} uintx ProfiledCodeHeapSize = 122913754 {pd product} {ergonomic} uintx ReservedCodeCacheSize = 251658240 {pd product} {ergonomic} bool SegmentedCodeCache = true {product} {ergonomic} bool UseCompressedClassPointers = true {lp64_product} {ergonomic} bool UseCompressedOops = true {lp64_product} {ergonomic} bool UseG1GC = true {product} {ergonomic} bool UseLargePagesIndividualAllocation = false {pd product} {ergonomic} Logging: Log output configuration: #0: stdout all=warning uptime,level,tags #1: stderr all=off uptime,level,tags Environment Variables: JAVA_HOME=D:\java\jdk1.8.0_102 CLASSPATH=.;D:\java\jdk1.8.0_102\lib;D:\java\jdk1.8.0_102\lib\tools.jar PATH=D:\java\git\mingw64\libexec\git-core;D:\java\git\mingw64\libexec\git-core;D:\java\git\mingw64\bin;D:\java\git\usr\bin;C:\Users\Administrator\bin;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\windows\System32\OpenSSH;D:\java\jdk1.8.0_102\bin;D:\java\jdk1.8.0_102\jre\bin;D:\java\maven-3.8.1\bin;%mysql%\bin;D:\java\git\cmd;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps USERNAME=Administrator DISPLAY=:0.0 LC_ALL=en_US.UTF-8 OS=Windows_NT PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 158 Stepping 10, GenuineIntel --------------- S Y S T E M --------------- OS: Windows 10 , 64 bit Build 19041 (10.0.19041.207) OS uptime: 10 days 7:26 hours CPU:total 6 (initial active 6) (6 cores per cpu, 1 threads per core) family 6 model 158 stepping 10 microcode 0xb4, 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, fma Memory: 4k page, system-wide physical 8072M (459M free) TotalPageFile size 20873M (AvailPageFile size 36M) current process WorkingSet (physical memory assigned to process): 10M, peak: 10M current process commit charge ("private bytes"): 56M, peak: 184M vm_info: OpenJDK 64-Bit Server VM (11.0.11+9-b1341.60) for windows-amd64 JRE (11.0.11+9-b1341.60), built on Jun 4 2021 08:17:54 by "" with MS VC++ 14.0 (VS2015) END. springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
@@ -122,7 +122,7 @@ index++; continue; } vo.setCardNo(oneData.get(1)); vo.setCardNo(oneData.get(1).toUpperCase()); //根据身份证号码解析年龄以及性别 //获取用户生日 String birthday = vo.getCardNo().substring(6, 14); @@ -330,16 +330,18 @@ vo.setWorkCompany(oneData.get(24).trim()); } if(StringUtils.isNotEmpty(oneData.get(25))){ Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25)); if(isOk.equals(-1)){ ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO(); importErrorVO.setErrorPosition("第" + index + "行，第26列"); importErrorVO.setErrorMsg("您填写的本地/外地有误"); populationImportErrorVOList.add(importErrorVO); index++; continue; } vo.setOutOrLocal(isOk); Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25)); if(isOk.equals(-1)){ ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO(); importErrorVO.setErrorPosition("第" + index + "行，第26列"); importErrorVO.setErrorMsg("您填写的本地/外地有误"); populationImportErrorVOList.add(importErrorVO); index++; continue; } vo.setOutOrLocal(isOk); }else { vo.setOutOrLocal(1); } if(StringUtils.isNotEmpty(oneData.get(26))){ vo.setCensusRegister(oneData.get(26).trim()); springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/ComSwPatrolRecordDTO.java
New file @@ -0,0 +1,59 @@ package com.panzhihua.common.model.dtos.community; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.databind.annotation.JsonSerialize; import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; import com.panzhihua.common.model.helper.encrypt.EncryptQuery; import com.panzhihua.common.model.helper.encrypt.EncryptQueryClass; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * 巡查记录DTO */ @Data public class ComSwPatrolRecordDTO implements Serializable { private static final long serialVersionUID = 1L; /** * 分页-当前页数 */ @ApiModelProperty(value = "分页-当前页数",example = "1") private Long pageNum; /** * 分页-每页记录数 */ @ApiModelProperty(value = "分页-每页记录数",example = "10") private Long pageSize; /** * 社区id */ @ApiModelProperty("社区id") private Long communityId; @ApiModelProperty("巡查开始时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date patrolAtBegin; @ApiModelProperty("巡查结束时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date patrolAtEnd; /** * (取字典表国家标准编码)巡查类型(1.防火巡查2.防汛巡查3.防疫巡查) */ @ApiModelProperty("巡查类型(1.防火巡查2.防汛巡查3.防疫巡查)") private Integer patrolType; /** * 巡查人员 */ @ApiModelProperty("巡查人员") private String patrolPerson; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComSwPatrolRecordVO.java
New file @@ -0,0 +1,228 @@ package com.panzhihua.common.model.vos.community; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.databind.annotation.JsonSerialize; import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录实体类 */ @Data @ApiModel("巡查记录表") public class ComSwPatrolRecordVO implements Serializable { private static final long serialVersionUID = 1L; /** * 巡查记录id */ @ApiModelProperty("巡查记录id") @JsonSerialize(using = ToStringSerializer.class) private Long id; /** * 社区id */ @ApiModelProperty("社区id") @JsonSerialize(using = ToStringSerializer.class) private Long communityId; /** * 报告id */ @ApiModelProperty("报告id") @JsonSerialize(using = ToStringSerializer.class) private Long reportId; /** * 巡查时间 */ @ApiModelProperty("巡查时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date PatrolTime; /** * 天气 */ @ApiModelProperty("天气") private String weather; /** * 温度 */ @ApiModelProperty("温度") private String temperature; /** * 风 */ @ApiModelProperty("风") private String wind; /** * (取字典表国家标准编码)巡查类型(1.防火巡查2.防汛巡查3.防疫巡查) */ @ApiModelProperty("巡查类型(1.防火巡查2.防汛巡查3.防疫巡查)") private Integer patrolType; /** * 巡查领导 */ @ApiModelProperty("巡查领导") private String patrolLeader; /** * 巡查人员 */ @ApiModelProperty("巡查人员") private String patrolPerson; /** * 巡查地址 */ @ApiModelProperty("巡查地址") private String address; /** * 巡查记录 */ @ApiModelProperty("巡查记录") private String recordContent; /** * 发现记录 */ @ApiModelProperty("发现记录") private String findRecord; /** * 记录照片 */ @ApiModelProperty("记录照片") private String recordPhoto; /** * 备注 */ @ApiModelProperty("备注") private String remark; /** * 接班领导 */ @ApiModelProperty("接班领导") private String successionLeader; /** * 接班人员 */ @ApiModelProperty("接班人员") private String successionPerson; /** * 接班时间 */ @ApiModelProperty("接班时间") private Date successionTime; /** * 是否存在隐患（1是 、0否） */ @ApiModelProperty("是否存在隐患（1是 、0否）") private Integer isHiddenDanger; /** * 隐患名称 */ @ApiModelProperty("隐患名称") private String dagerName; /** * 排查时间 */ @ApiModelProperty("排查时间") private Date checkTime; /** * 主体部门、单位或个人全称 */ @ApiModelProperty("主体部门、单位或个人全称") private String unitName; /** * 隐患简述 */ @ApiModelProperty("隐患简述") private String dagerDescription; /** * 是否立即整改（1是 、0否） */ @ApiModelProperty("是否立即整改（1是 、0否）") private Integer isRectifyImmediately; /** * 采取措施 */ @ApiModelProperty("采取措施") private String takeSteps; /** * 采取措施照片 */ @ApiModelProperty("采取措施照片") private String stepsPhoto; /** * 整改人员 */ @ApiModelProperty("整改人员") private String rectifyPerson; /** * 创建时间 */ @ApiModelProperty("创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date createAt; /** * 更新时间 */ @ApiModelProperty("更新时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date updateAt; /** * 创建人 */ @ApiModelProperty("创建人") private Long createBy; /** * 巡查类型 */ public interface patrolType{ int huo = 1; int xun = 2; int yi = 3; } /** * 是否 */ public interface isOk{ int yes = 1; int no = 0; } } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -1442,7 +1442,7 @@ * @return */ @PostMapping("/common/data/car/export") R exportRealCar(ExportComMngCarExcelDTO exportComMngCarExcelDTO); R exportRealCar(@RequestBody ExportComMngCarExcelDTO exportComMngCarExcelDTO); /** * 社区后台实有单位管理列表 @@ -3727,4 +3727,12 @@ */ @PostMapping("/easyphoto/readUserReward") R readUserReward(@RequestParam("userId") Long userId,@RequestParam("communityId") Long communityId); /** * 分页查询巡查记录 * @param comSwPatrolRecordDTO 查询参数 * @return 分页集合 */ @PostMapping("/patrolRecor/page") R pagePatrolRecord(@RequestBody ComSwPatrolRecordDTO comSwPatrolRecordDTO); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/ComSwPatrolRecordApi.java
New file @@ -0,0 +1,45 @@ package com.panzhihua.community_backstage.api; import com.panzhihua.common.controller.BaseController; import com.panzhihua.common.model.dtos.community.ComSwPatrolRecordDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.service.community.CommunityService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录前端控制器 */ @Slf4j @Api(tags = {"社区管理/安全工作"}) @RestController @RequestMapping("/patrolRecord") public class ComSwPatrolRecordApi extends BaseController { @Resource private CommunityService communityService; /** * 分页查询巡查记录 * @param comSwPatrolRecordDTO 查询参数 * @return 分页集合 */ @ApiOperation(value = "分页查询巡查记录") @PostMapping("/pagePatrolRecord") public R pagePatrolRecord(@RequestBody ComSwPatrolRecordDTO comSwPatrolRecordDTO){ Long communityId = this.getCommunityId(); comSwPatrolRecordDTO.setCommunityId(communityId); return communityService.pagePatrolRecord(comSwPatrolRecordDTO); } }
New file @@ -0,0 +1,39 @@ package com.panzhihua.service_community.api; import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO; import com.panzhihua.common.model.dtos.community.ComSwPatrolRecordDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.service_community.service.ComSwPatrolRecordService; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录前端控制器 */ @Slf4j @RestController @RequestMapping("/patrolRecord") public class ComSwPatrolRecordApi { @Resource private ComSwPatrolRecordService comMngPopulationService; /** * 分页查询巡查记录 * @param comSwPatrolRecordDTO 查询参数 * @return 分页集合 */ @PostMapping("/page") public R pagePatrolRecord(@RequestBody ComSwPatrolRecordDTO comSwPatrolRecordDTO){ return comMngPopulationService.pagePatrolRecord(comSwPatrolRecordDTO); } }
@@ -119,7 +119,7 @@ * @return */ @PostMapping("/car/export") public R exportRealCar(ExportComMngCarExcelDTO exportComMngCarExcelDTO){ public R exportRealCar(@RequestBody ExportComMngCarExcelDTO exportComMngCarExcelDTO){ return comMngCarService.exportRealCar(exportComMngCarExcelDTO); }
@@ -86,11 +86,11 @@ "<if test='exportComMngCarExcelDTO.areaName != null and exportComMngCarExcelDTO.areaName.trim() != ""'>" + " and t.area_name LIKE concat( #{exportComMngCarExcelDTO.areaName}, '%' ) " + " </if> " + "<if test='exportComMngCarExcelDTO.communityId != null and exportComMngCarExcelDTO.communityId != 0'>" + "<if test='exportComMngCarExcelDTO.communityId != null and exportComMngCarExcelDTO.communityId != ""'>" + " and t.community_id = #{exportComMngCarExcelDTO.communityId} " + " </if> " + "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != 0'>" + " and t.village_id = #{exportComMngCarExcelDTO.villageId} " + "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != ""'>" + " and t.area_id = #{exportComMngCarExcelDTO.villageId} " + " </if> " + "<if test='exportComMngCarExcelDTO.userName != null and exportComMngCarExcelDTO.userName.trim() != ""'>" + " and t.user_name LIKE concat( #{exportComMngCarExcelDTO.userName}, '%' ) " + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java
New file @@ -0,0 +1,66 @@ package com.panzhihua.service_community.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO; import com.panzhihua.common.model.dtos.community.ComSwPatrolRecordDTO; import com.panzhihua.common.model.vos.community.ComMngPopulationVO; import com.panzhihua.common.model.vos.community.ComSwPatrolRecordVO; import com.panzhihua.service_community.model.dos.ComSwPatrolRecordDO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录mapper类 */ @Mapper public interface ComSwPatrolRecordDAO extends BaseMapper<ComSwPatrolRecordDO> { @Select("<script> " + "SELECT " + "cspr.id, " + "cspr.community_id AS communityId, " + "cspr.patrol_time AS patrolTime, " + "cspr.weather" + "cspr.temperature" + "cspr.wind" + "cspr.patrol_type AS patrolType, " + "cspr.patrol_person AS patrolPerson, " + "cspr.address, " + "cspr.record_content AS recordContent, " + "cspr.find_record AS findRecord, " + "cspr.record_photo AS recordPhoto, " + "cspr.remark, " + "cspr.succession_person AS successionPerson, " + "cspr.succession_time AS successionTime, " + "cspr.create_at AS createAt, " + "cspr.create_time AS createTime," + "csprr.report_id AS reportId" + "FROM " + "com_sw_patrol_record AS cspr" + "left join com_sw_patrol_record_report AS csprr on cspr.id = csprr.patrol_record_id" + "<where>" + "<if test='comSwPatrolRecordDTO.communityId != null and comSwPatrolRecordDTO.communityId != ""'>" + "AND cspr.community_id = #{comSwPatrolRecordDTO.communityId} " + " </if> " + "<if test='comSwPatrolRecordDTO.patrolPerson != null and comSwPatrolRecordDTO.patrolPerson != ""'>" + "AND cspr.patrol_person LIKE concat('%',#{comSwPatrolRecordDTO.patrolPerson},'%') " + " </if> " + "<if test='comSwPatrolRecordDTO.patrolType != null and comSwPatrolRecordDTO.patrolType != ""'>" + "AND cspr.patrol_type = #{comSwPatrolRecordDTO.patrolType} " + " </if> " + "<if test='comSwPatrolRecordDTO.patrolAtBegin != null '>" + "AND cspr.patrol_time <![CDATA[ >= ]]> #{comSwPatrolRecordDTO.patrolTime} " + " </if> " + "<if test='comSwPatrolRecordDTO.patrolAtEnd != null '>" + "AND cspr.patrol_time <![CDATA[ <= ]]> #{comSwPatrolRecordDTO.patrolTime} " + " </if> " + " </where>" + " order by create_at desc" + "</script>") IPage<ComSwPatrolRecordVO> pagePatrolRecord(Page page, @Param("comSwPatrolRecordDTO") ComSwPatrolRecordDTO comSwPatrolRecordDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComSwPatrolRecordDO.java
New file @@ -0,0 +1,209 @@ package com.panzhihua.service_community.model.dos; import com.baomidou.mybatisplus.annotation.*; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录实体类 */ @Data @TableName("com_sw_patrol_record") public class ComSwPatrolRecordDO implements Serializable { private static final long serialVersionUID = 1L; /** * 主键id */ @TableId(type = IdType.INPUT) private Long id; /** * 社区id */ private Long communityId; /** * 巡查时间 */ private Date patrolTime; /** * 天气 */ private String weather; /** * 温度 */ private String temperature; /** * 风 */ private String wind; /** * (取字典表国家标准编码)巡查类型(1.防火巡查2.防汛巡查3.防疫巡查) */ private Integer patrolType; /** * 巡查领导 */ private String patrolLeader; /** * 巡查人员 */ private String patrolPerson; /** * 巡查地址 */ private String address; /** * 巡查记录 */ private String recordContent; /** * 发现记录 */ private String findRecord; /** * 记录照片 */ private String recordPhoto; /** * 备注 */ private String remark; /** * 接班领导 */ private String successionLeader; /** * 接班人员 */ private String successionPerson; /** * 接班时间 */ private Date successionTime; /** * 是否存在隐患（1是 、0否） */ private Integer isHiddenDanger; /** * 隐患名称 */ private String dagerName; /** * 排查时间 */ private Date checkTime; /** * 主体部门、单位或个人全称 */ private String unitName; /** * 隐患简述 */ private String dagerDescription; /** * 是否立即整改（1是 、0否） */ private Integer isRectifyImmediately; /** * 采取措施 */ private String takeSteps; /** * 采取措施照片 */ private String stepsPhoto; /** * 整改人员 */ private String rectifyPerson; /** * 创建时间 */ @TableField(fill = FieldFill.INSERT) private Date createAt; /** * 创建人 */ private Long createBy; /** * 更新时间 */ @TableField(fill = FieldFill.UPDATE) private Date updateAt; /** * 更新人 */ private Long updateBy; @Override public String toString() { return "ComSwPatrolRecordDO{" + "id=" + id + ", patrolTime=" + patrolTime + ", weather=" + weather + ", temperature=" + temperature + ", wind=" + wind + ", patrolType=" + patrolType + ", patrolLeader=" + patrolLeader + ", patrolPerson=" + patrolPerson + ", address=" + address + ", recordContent=" + recordContent + ", findRecord=" + findRecord + ", recordPhoto=" + recordPhoto + ", remark=" + remark + ", successionLeader=" + successionLeader + ", successionPerson=" + successionPerson + ", successionTime=" + successionTime + ", isHiddenDanger=" + isHiddenDanger + ", dagerName=" + dagerName + ", checkTime=" + checkTime + ", unitName=" + unitName + ", dagerDescription=" + dagerDescription + ", isRectifyImmediately=" + isRectifyImmediately + ", takeSteps=" + takeSteps + ", stepsPhoto=" + stepsPhoto + ", rectifyPerson=" + rectifyPerson + ", createAt=" + createAt + ", createBy=" + createBy + ", updateAt=" + updateAt + ", updateBy=" + updateBy + "}"; } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComSwPatrolRecordService.java
New file @@ -0,0 +1,22 @@ package com.panzhihua.service_community.service; import com.baomidou.mybatisplus.extension.service.IService; import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO; import com.panzhihua.common.model.dtos.community.ComSwPatrolRecordDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.service_community.model.dos.ComSwPatrolRecordDO; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录服务类 */ public interface ComSwPatrolRecordService extends IService<ComSwPatrolRecordDO> { /** * 分页查询巡查记录 * @param comSwPatrolRecordDTO 查询参数 * @return 分页集合 */ R pagePatrolRecord(ComSwPatrolRecordDTO comSwPatrolRecordDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSwPatrolRecordServiceImpl.java
New file @@ -0,0 +1,46 @@ package com.panzhihua.service_community.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.panzhihua.common.model.dtos.community.ComSwPatrolRecordDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.ComSwPatrolRecordVO; import com.panzhihua.service_community.dao.ComSwPatrolRecordDAO; import com.panzhihua.service_community.model.dos.ComSwPatrolRecordDO; import com.panzhihua.service_community.service.ComSwPatrolRecordService; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import javax.annotation.Resource; /** * @auther txb * @create 2021-07-23 14:38:38 * @describe 社区》安全工作》巡查记录服务实现类 */ @Slf4j @Service public class ComSwPatrolRecordServiceImpl extends ServiceImpl<ComSwPatrolRecordDAO, ComSwPatrolRecordDO> implements ComSwPatrolRecordService { @Resource private ComSwPatrolRecordDAO comSwPatrolRecordDAO; @Override public R pagePatrolRecord(ComSwPatrolRecordDTO comSwPatrolRecordDTO) { Page page = new Page<>(); Long pageNum = comSwPatrolRecordDTO.getPageNum(); Long pageSize = comSwPatrolRecordDTO.getPageSize(); if (null == pageNum || 0 == pageNum) { pageNum = 1L; } if (null == pageSize || 0 == pageSize) { pageSize = 10L; } page.setSize(pageSize); page.setCurrent(pageNum); IPage<ComSwPatrolRecordVO> iPage = comSwPatrolRecordDAO.pagePatrolRecord(page, comSwPatrolRecordDTO); return R.ok(iPage); } }
