From 29c3367d8c8f9777bde6a86fa26c86d19a35bc07 Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期四, 19 八月 2021 15:18:25 +0800 Subject: [PATCH] Merge branch 'zzj' of http://182.151.2.19:9380/root/zhihuishequ into zzj --- springcloud_k8s_panzhihuazhihuishequ/common/common.iml | 154 ++++++++++++++++++++++++++++++++++++++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml | 13 ++ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java | 8 ++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java | 5 + springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java | 7 + 5 files changed, 185 insertions(+), 2 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/common.iml b/springcloud_k8s_panzhihuazhihuishequ/common/common.iml new file mode 100644 index 0000000..a73b292 --- /dev/null +++ b/springcloud_k8s_panzhihuazhihuishequ/common/common.iml @@ -0,0 +1,154 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module org.jetbrains.idea.maven.project.MavenProjectsManager.isMavenModule="true" type="JAVA_MODULE" version="4"> + <component name="FacetManager"> + <facet type="Spring" name="Spring"> + <configuration /> + </facet> + </component> + <component name="NewModuleRootManager" LANGUAGE_LEVEL="JDK_1_8"> + <output url="file://$MODULE_DIR$/target/classes" /> + <output-test url="file://$MODULE_DIR$/target/test-classes" /> + <content url="file://$MODULE_DIR$"> + <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" /> + <excludeFolder url="file://$MODULE_DIR$/target" /> + </content> + <orderEntry type="inheritedJdk" /> + <orderEntry type="sourceFolder" forTests="false" /> + <orderEntry type="library" name="Maven: cn.hutool:hutool-core:5.6.7" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-context:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-aop:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-beans:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-core:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-jcl:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-expression:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.projectlombok:lombok:1.18.12" level="project" /> + <orderEntry type="library" name="Maven: ch.qos.logback:logback-classic:1.1.11" level="project" /> + <orderEntry type="library" name="Maven: ch.qos.logback:logback-core:1.1.11" level="project" /> + <orderEntry type="library" name="Maven: org.slf4j:slf4j-api:1.7.25" level="project" /> + <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-core:9.0.38" level="project" /> + <orderEntry type="library" name="Maven: org.apache.tomcat:tomcat-annotations-api:9.0.38" level="project" /> + <orderEntry type="library" name="Maven: org.apache.commons:commons-lang3:3.10" level="project" /> + <orderEntry type="library" name="Maven: com.alibaba:fastjson:1.2.74" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-web:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-annotations:2.11.2" level="project" /> + <orderEntry type="library" name="Maven: eu.bitwalker:UserAgentUtils:1.21" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-webmvc:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-swagger2:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: io.swagger:swagger-annotations:1.5.20" level="project" /> + <orderEntry type="library" name="Maven: io.swagger:swagger-models:1.5.20" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-spi:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-core:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: net.bytebuddy:byte-buddy:1.10.14" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-schema:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-swagger-common:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: io.springfox:springfox-spring-web:2.9.2" level="project" /> + <orderEntry type="library" name="Maven: com.google.guava:guava:29.0-jre" level="project" /> + <orderEntry type="library" name="Maven: com.google.guava:failureaccess:1.0.1" level="project" /> + <orderEntry type="library" name="Maven: com.google.guava:listenablefuture:9999.0-empty-to-avoid-conflict-with-guava" level="project" /> + <orderEntry type="library" name="Maven: com.google.code.findbugs:jsr305:3.0.2" level="project" /> + <orderEntry type="library" name="Maven: org.checkerframework:checker-qual:2.11.1" level="project" /> + <orderEntry type="library" name="Maven: com.google.errorprone:error_prone_annotations:2.3.4" level="project" /> + <orderEntry type="library" name="Maven: com.google.j2objc:j2objc-annotations:1.3" level="project" /> + <orderEntry type="library" name="Maven: com.fasterxml:classmate:1.5.1" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.plugin:spring-plugin-core:1.2.0.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.plugin:spring-plugin-metadata:1.2.0.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.mapstruct:mapstruct:1.2.0.Final" level="project" /> + <orderEntry type="library" name="Maven: io.jsonwebtoken:jjwt:0.9.1" level="project" /> + <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-databind:2.11.2" level="project" /> + <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-core:2.11.2" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-data-redis:2.4.0" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-autoconfigure:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-logging:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.apache.logging.log4j:log4j-to-slf4j:2.13.3" level="project" /> + <orderEntry type="library" name="Maven: org.apache.logging.log4j:log4j-api:2.13.3" level="project" /> + <orderEntry type="library" name="Maven: org.slf4j:jul-to-slf4j:1.7.30" level="project" /> + <orderEntry type="library" name="Maven: jakarta.annotation:jakarta.annotation-api:1.3.5" level="project" /> + <orderEntry type="library" name="Maven: org.yaml:snakeyaml:1.26" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.data:spring-data-redis:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.data:spring-data-keyvalue:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.data:spring-data-commons:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-tx:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-oxm:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework:spring-context-support:5.2.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: io.lettuce:lettuce-core:5.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-common:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-handler:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-resolver:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-buffer:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-codec:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.netty:netty-transport:4.1.52.Final" level="project" /> + <orderEntry type="library" name="Maven: io.projectreactor:reactor-core:3.3.10.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.reactivestreams:reactive-streams:1.0.3" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-starter-openfeign:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-starter:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-context:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.security:spring-security-rsa:1.0.9.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.bouncycastle:bcpkix-jdk15on:1.64" level="project" /> + <orderEntry type="library" name="Maven: org.bouncycastle:bcprov-jdk15on:1.64" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-openfeign-core:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-netflix-ribbon:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-netflix-archaius:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: io.github.openfeign.form:feign-form-spring:3.8.0" level="project" /> + <orderEntry type="library" name="Maven: io.github.openfeign.form:feign-form:3.8.0" level="project" /> + <orderEntry type="library" name="Maven: commons-fileupload:commons-fileupload:1.3.3" level="project" /> + <orderEntry type="library" name="Maven: commons-io:commons-io:2.5" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-commons:2.2.6.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.security:spring-security-crypto:5.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: io.github.openfeign:feign-core:10.10.1" level="project" /> + <orderEntry type="library" name="Maven: io.github.openfeign:feign-slf4j:10.10.1" level="project" /> + <orderEntry type="library" name="Maven: io.github.openfeign:feign-hystrix:10.10.1" level="project" /> + <orderEntry type="library" name="Maven: com.netflix.archaius:archaius-core:0.7.6" level="project" /> + <orderEntry type="library" scope="RUNTIME" name="Maven: commons-configuration:commons-configuration:1.8" level="project" /> + <orderEntry type="library" scope="RUNTIME" name="Maven: commons-lang:commons-lang:2.6" level="project" /> + <orderEntry type="library" name="Maven: com.netflix.hystrix:hystrix-core:1.5.18" level="project" /> + <orderEntry type="library" name="Maven: io.reactivex:rxjava:1.3.8" level="project" /> + <orderEntry type="library" name="Maven: org.hdrhistogram:HdrHistogram:2.1.9" level="project" /> + <orderEntry type="library" name="Maven: org.apache.commons:commons-pool2:2.6.2" level="project" /> + <orderEntry type="library" name="Maven: commons-net:commons-net:3.6" level="project" /> + <orderEntry type="library" name="Maven: com.alibaba:easyexcel:2.2.6" level="project" /> + <orderEntry type="library" name="Maven: org.apache.poi:poi:3.17" level="project" /> + <orderEntry type="library" name="Maven: org.apache.commons:commons-collections4:4.1" level="project" /> + <orderEntry type="library" name="Maven: org.apache.poi:poi-ooxml:3.17" level="project" /> + <orderEntry type="library" name="Maven: com.github.virtuald:curvesapi:1.04" level="project" /> + <orderEntry type="library" name="Maven: org.apache.poi:poi-ooxml-schemas:3.17" level="project" /> + <orderEntry type="library" name="Maven: org.apache.xmlbeans:xmlbeans:2.6.0" level="project" /> + <orderEntry type="library" name="Maven: stax:stax-api:1.0.1" level="project" /> + <orderEntry type="library" name="Maven: cglib:cglib:3.1" level="project" /> + <orderEntry type="library" name="Maven: org.ow2.asm:asm:4.2" level="project" /> + <orderEntry type="library" name="Maven: org.ehcache:ehcache:3.8.1" level="project" /> + <orderEntry type="library" name="Maven: org.glassfish.jaxb:jaxb-runtime:2.3.3" level="project" /> + <orderEntry type="library" name="Maven: jakarta.xml.bind:jakarta.xml.bind-api:2.3.3" level="project" /> + <orderEntry type="library" name="Maven: org.glassfish.jaxb:txw2:2.3.3" level="project" /> + <orderEntry type="library" name="Maven: com.sun.istack:istack-commons-runtime:3.0.11" level="project" /> + <orderEntry type="library" scope="RUNTIME" name="Maven: com.sun.activation:jakarta.activation:1.2.2" level="project" /> + <orderEntry type="library" name="Maven: com.jcraft:jsch:0.1.53" level="project" /> + <orderEntry type="library" name="Maven: jakarta.validation:jakarta.validation-api:2.0.2" level="project" /> + <orderEntry type="library" name="Maven: org.hibernate.validator:hibernate-validator:6.1.5.Final" level="project" /> + <orderEntry type="library" name="Maven: org.jboss.logging:jboss-logging:3.4.1.Final" level="project" /> + <orderEntry type="library" name="Maven: com.belerweb:pinyin4j:2.5.1" level="project" /> + <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-aop:2.3.4.RELEASE" level="project" /> + <orderEntry type="library" name="Maven: org.aspectj:aspectjweaver:1.9.6" level="project" /> + <orderEntry type="library" name="Maven: org.apache.httpcomponents:httpclient:4.5.12" level="project" /> + <orderEntry type="library" name="Maven: org.apache.httpcomponents:httpcore:4.4.13" level="project" /> + <orderEntry type="library" name="Maven: org.jdom:jdom2:2.0.5" level="project" /> + <orderEntry type="library" name="Maven: org.json:json:20160810" level="project" /> + <orderEntry type="library" name="Maven: commons-codec:commons-codec:1.9" level="project" /> + <orderEntry type="library" name="Maven: com.tencentcloudapi:tencentcloud-sdk-java:3.1.286" level="project" /> + <orderEntry type="library" name="Maven: commons-logging:commons-logging:1.2" level="project" /> + <orderEntry type="library" name="Maven: com.squareup.okio:okio:1.12.0" level="project" /> + <orderEntry type="library" name="Maven: com.squareup.okhttp:okhttp:2.7.5" level="project" /> + <orderEntry type="library" name="Maven: com.google.code.gson:gson:2.8.6" level="project" /> + <orderEntry type="library" name="Maven: javax.xml.bind:jaxb-api:2.3.1" level="project" /> + <orderEntry type="library" name="Maven: javax.activation:javax.activation-api:1.2.0" level="project" /> + <orderEntry type="library" name="Maven: com.squareup.okhttp:logging-interceptor:2.7.5" level="project" /> + <orderEntry type="library" name="Maven: cn.hutool:hutool-all:5.6.7" level="project" /> + <orderEntry type="library" name="Maven: com.esotericsoftware:reflectasm:1.11.9" level="project" /> + <orderEntry type="library" name="Maven: cn.afterturn:easypoi-base:4.1.0" level="project" /> + <orderEntry type="library" name="Maven: ognl:ognl:3.2.6" level="project" /> + <orderEntry type="library" name="Maven: org.javassist:javassist:3.20.0-GA" level="project" /> + <orderEntry type="library" name="Maven: javax.validation:validation-api:2.0.1.Final" level="project" /> + <orderEntry type="library" name="Maven: cn.afterturn:easypoi-annotation:4.1.0" level="project" /> + </component> +</module> \ No newline at end of file diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java index 82a4a1e..7e5d495 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java @@ -170,4 +170,12 @@ @ApiModelProperty(value = "完成人名称") private String completeName; + @ApiModelProperty(value = "是否上报城管 0未上报 1已上报 2已退回") + private Integer isReportUrban; + + @ApiModelProperty(value = "城管安排状态 0未安排 1已安排 2已处理") + private Integer urbanStatus; + + @ApiModelProperty(value = "社区名字") + private String communityName; } diff --git a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java index bde4b04..f700c3d 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java +++ b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java @@ -260,6 +260,13 @@ return communityService.pageEasyPhoto(comActEasyPhotoVO); } + @ApiOperation(value = "城管分页查询随手拍") + @PostMapping("/pageeasyphoto/urban") + public R pageEasyPhotoUrban(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO) { + comActEasyPhotoVO.setIsReportUrban(1); + return communityService.pageEasyPhoto(comActEasyPhotoVO); + } + @ApiOperation(value = "随手拍详情", response = ComActEasyPhotoVO.class) @GetMapping("easyphoto") public R detailEasyPhoto(@RequestParam("id") Long id) { diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java index 83263e4..4f65534 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java @@ -199,12 +199,17 @@ "p.activity_amount, " + "count(pu.id)giveThumbsUpNum, " + "p.handle_photo_list " + + "c.name communityName " + + "p.transfer_time" + + "p.transfer_reason" + + "p.urban_status" + "FROM " + "com_act_easy_photo p " + "JOIN sys_user u on p.sponsor_id=u.user_id " + "LEFT JOIN sys_user su on p.handler_id=su.user_id " + "LEFT JOIN sys_user su1 on p.complete_id=su1.user_id " + "LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id " + + "LEFT JOIN com_act c on p.community_id=c.community_id " + "WHERE p.del_tag = 0 and p.id=#{id}") ComActEasyPhotoVO detailEasyPhoto(Long id); @Select("SELECT " + diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml index 70e96d3..303c14e 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml @@ -57,12 +57,14 @@ p.activity_type, p.activity_amount, p.activity_id, - p.examine_at + p.examine_at, + c.name communityName FROM com_act_easy_photo p LEFT JOIN sys_user u ON p.sponsor_id = u.user_id LEFT JOIN com_act_easy_photo_user pu ON p.id = pu.easy_photo_id LEFT JOIN sys_user su ON p.handler_id = su.user_id + left join com_act c on p.community_id =c.community_id WHERE p.del_tag = 0 <if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'> @@ -70,6 +72,12 @@ </if> <if test='comActEasyPhotoVO.status != null and comActEasyPhotoVO.status!=0' > AND p.`status` = #{comActEasyPhotoVO.status} + </if> + <if test='comActEasyPhotoVO.isReportUrban != null and comActEasyPhotoVO.isReportUrban!=0' > + AND p.`is_report_urban` = #{comActEasyPhotoVO.isReportUrban} + </if> + <if test='comActEasyPhotoVO.urbanStatus != null and comActEasyPhotoVO.urbanStatus!=0' > + AND p.`urban_status` = #{comActEasyPhotoVO.urbanStatus} </if> <if test='comActEasyPhotoVO.createBegin != null '> AND p.create_at BETWEEN #{comActEasyPhotoVO.createBegin} @@ -82,7 +90,8 @@ <if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != ""'> AND (u.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.happen_addr like concat(#{comActEasyPhotoVO.keyWord},'%') or - su.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') + su.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or + p.detail like concat(#{comActEasyPhotoVO.keyWord},'%') ) </if> GROUP BY -- Gitblit v1.7.1