From 5667d14c708f9244fe2419707f98ff472ca23480 Mon Sep 17 00:00:00 2001
From: rentaiming <806181062@qq.com>
Date: 星期二, 30 七月 2024 16:30:43 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/HomeStatisticsQuery.java                 |    3 
 ruoyi-common/ruoyi-common-redis/src/main/java/com/ruoyi/common/redis/configure/RedisConfig.java                       |    2 
 ruoyi-api/ruoyi-api-system/src/main/java/com/ruoyi/system/api/domain/SysOperLog.java                                  |    2 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java       |    4 
 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysRoleController.java                           |    4 
 ruoyi-modules/ruoyi-file/ruoyi-modules-file.iml                                                                       |    8 +
 ruoyi-modules/ruoyi-management/pom.xml                                                                                |    6 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java                |   44 ++----
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/ADDRKDTO.java                            |   13 +
 ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml                                         |   23 ++
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java                    |    2 
 ruoyi-modules/ruoyi-system/pom.xml                                                                                    |    5 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/UpdateRKDTO.java                         |   12 +
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java           |   38 -----
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java |    6 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java                            |    6 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlStoreManagementImgController.java      |    2 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java              |    6 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAudit.java                                 |    4 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/OssController.java                       |   80 +++++++++++
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java   |    2 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/util/ObsUploadUtil.java                             |   78 +++++++++++
 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDeptController.java                           |    9 -
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/HomeStatisticsController.java            |    4 
 ruoyi-common/ruoyi-common-security/src/main/java/com/ruoyi/common/security/service/TokenService.java                  |    2 
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/HomeStatisticsServiceImpl.java         |    9 +
 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java      |    4 
 27 files changed, 261 insertions(+), 117 deletions(-)

diff --git a/ruoyi-api/ruoyi-api-system/src/main/java/com/ruoyi/system/api/domain/SysOperLog.java b/ruoyi-api/ruoyi-api-system/src/main/java/com/ruoyi/system/api/domain/SysOperLog.java
index 5bb4183..f8def5f 100644
--- a/ruoyi-api/ruoyi-api-system/src/main/java/com/ruoyi/system/api/domain/SysOperLog.java
+++ b/ruoyi-api/ruoyi-api-system/src/main/java/com/ruoyi/system/api/domain/SysOperLog.java
@@ -49,4 +49,6 @@
     @Excel(name = "电话")
     private String phone;
 
+
+
 }
diff --git a/ruoyi-common/ruoyi-common-redis/src/main/java/com/ruoyi/common/redis/configure/RedisConfig.java b/ruoyi-common/ruoyi-common-redis/src/main/java/com/ruoyi/common/redis/configure/RedisConfig.java
index 43340c6..e9c791e 100644
--- a/ruoyi-common/ruoyi-common-redis/src/main/java/com/ruoyi/common/redis/configure/RedisConfig.java
+++ b/ruoyi-common/ruoyi-common-redis/src/main/java/com/ruoyi/common/redis/configure/RedisConfig.java
@@ -61,7 +61,7 @@
         // 集群模式
         // config.useClusterServers().addNodeAddress("192.168.110.188:7004", "192.168.110.188:7001");
         // 2.根据 Config 创建出 RedissonClient 示例。
-        config.useSingleServer().setAddress("redis://192.168.110.235:6379").setPassword("123456");
+        config.useSingleServer().setAddress("redis://127.0.0.1:6379").setPassword("123456");
         return Redisson.create(config);
     }
 
diff --git a/ruoyi-common/ruoyi-common-security/src/main/java/com/ruoyi/common/security/service/TokenService.java b/ruoyi-common/ruoyi-common-security/src/main/java/com/ruoyi/common/security/service/TokenService.java
index b7fa65b..b443c96 100644
--- a/ruoyi-common/ruoyi-common-security/src/main/java/com/ruoyi/common/security/service/TokenService.java
+++ b/ruoyi-common/ruoyi-common-security/src/main/java/com/ruoyi/common/security/service/TokenService.java
@@ -54,13 +54,11 @@
         loginUser.setUsername(userName);
         loginUser.setIpaddr(IpUtils.getIpAddr());
         refreshToken(loginUser);
-
         // Jwt存储信息
         Map<String, Object> claimsMap = new HashMap<String, Object>();
         claimsMap.put(SecurityConstants.USER_KEY, token);
         claimsMap.put(SecurityConstants.DETAILS_USER_ID, userId);
         claimsMap.put(SecurityConstants.DETAILS_USERNAME, userName);
-
         // 接口返回信息
         Map<String, Object> rspMap = new HashMap<String, Object>();
         rspMap.put("access_token", JwtUtils.createToken(claimsMap));
diff --git a/ruoyi-modules/ruoyi-file/ruoyi-modules-file.iml b/ruoyi-modules/ruoyi-file/ruoyi-modules-file.iml
new file mode 100644
index 0000000..4769643
--- /dev/null
+++ b/ruoyi-modules/ruoyi-file/ruoyi-modules-file.iml
@@ -0,0 +1,8 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<module version="4">
+  <component name="AdditionalModuleElements">
+    <content url="file://$MODULE_DIR$" dumb="true">
+      <sourceFolder url="file://$MODULE_DIR$/lib" type="java-resource" />
+    </content>
+  </component>
+</module>
\ No newline at end of file
diff --git a/ruoyi-modules/ruoyi-management/pom.xml b/ruoyi-modules/ruoyi-management/pom.xml
index 0048229..ff28a0d 100644
--- a/ruoyi-modules/ruoyi-management/pom.xml
+++ b/ruoyi-modules/ruoyi-management/pom.xml
@@ -112,12 +112,6 @@
         </exclusion>
       </exclusions>
     </dependency>
-    <!-- 分布式事务 -->
-    <dependency>
-      <groupId>com.ruoyi</groupId>
-      <artifactId>ruoyi-common-seata</artifactId>
-    </dependency>
-
 
     <!-- mybatis-plus -->
     <dependency>
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/HomeStatisticsController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/HomeStatisticsController.java
index 77f2e8b..36b9560 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/HomeStatisticsController.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/HomeStatisticsController.java
@@ -25,8 +25,8 @@
     private HomeStatisticsService homeStatisticsService;
     @PostMapping("/getHomeStatistics")
     @ApiOperation(value = "首页统计接口")
-    public R<HomeStatisticsVO> getHomeStatistics(@RequestBody HomeStatisticsQuery homeStatisticsQuery) {
-        return R.ok(homeStatisticsService.getHomeStatistics(homeStatisticsQuery));
+    public R<HomeStatisticsVO> getHomeStatistics(HomeStatisticsQuery homeStatisticsQuery) {
+         return R.ok(homeStatisticsService.getHomeStatistics(homeStatisticsQuery));
     }
 
 }
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/OssController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/OssController.java
new file mode 100644
index 0000000..bc2f249
--- /dev/null
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/OssController.java
@@ -0,0 +1,80 @@
+package com.ruoyi.management.controller;
+
+
+import com.ruoyi.management.util.ObsUploadUtil;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestParam;
+import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
+
+@RestController
+@RequestMapping("/base/oss")
+@Api(value = "文件上传", tags = "文件上传", description = "文件上传")
+public class OssController {
+    private static final String endpoint = "obs.cn-north-4.myhuaweicloud.com";
+    private static final String accessKeyId = "DRJFJRVQ9KVLQUSJUROI";
+    private static final String accessKeySecret = "3zpPkULh0a8CTTYjKL4f7szQZECkvVol4SwNab0f";
+    private static final String bucketName = "jkjianshen";
+    @PostMapping("/upload")
+    @ApiOperation(value = "文件上传")
+    public String upload(@RequestParam("file") MultipartFile file) throws IOException {
+        String s = ObsUploadUtil.obsUpload(file);
+        return s;
+    }
+//    @PostMapping("/uploadVideo")
+//    @ApiOperation(value = "视频上传",tags = "文件上传")
+//    public String uploadVideo(@RequestParam("file") MultipartFile file) throws Exception {
+//        // 获取文件名
+//        String fileName = file.getOriginalFilename();
+//        // 构建目标文件路径
+//        String filePath = "/usr/local/temp" + fileName;
+////        String filePath = "C:/temp/" + fileName;
+//        // 创建目标文件对象
+//        File targetFile = new File(filePath);
+//        // 将 MultipartFile 内容写入目标文件
+//        try (FileOutputStream fos = new FileOutputStream(targetFile)) {
+//            fos.write(file.getBytes());
+//        }
+//        String s = UploadVideoUtil.endUpload(targetFile.toString(), UUIDUtil.getRandomCode(5)+fileName);
+//        // 创建要删除的文件对象
+//        File fileToDelete = new File(targetFile.toString());
+//        // 检查文件是否存在,并删除文件
+//        if (fileToDelete.exists()) {
+//            fileToDelete.delete();
+//        }
+//        return s;
+//    }
+
+//    @PostMapping("/upload")
+//    @ApiOperation(value = "文件上传",tags = "文件上传")
+//    public ResponseEntity<String> upload(@RequestParam("file") MultipartFile file) throws IOException {
+//        // 创建 OSSClient 实例
+//        OSSClient ossClient = new OSSClient(endpoint, accessKeyId, accessKeySecret);
+//
+//
+//        // 创建 PutObjectRequest 对象
+//        PutObjectRequest putObjectRequest = new PutObjectRequest(bucketName, file.getOriginalFilename(), file.getInputStream());
+//
+//        ObjectMetadata metadata = new ObjectMetadata();
+//        // 取消文件缓存,文件每次都会从OSS服务器获取
+//        metadata.setHeader("Cache-Control", "no-cache");
+//        metadata.setHeader("Expires", "0");
+//
+//
+//        // 上传文件
+//        PutObjectResult putObjectResult = ossClient.putObject(putObjectRequest);
+//
+//        // 关闭 OSSClient 实例
+//        ossClient.shutdown();
+//
+//        String fileUrl = "https://" + bucketName + "." + endpoint + "/" + file.getOriginalFilename();
+//        return ResponseEntity.ok(fileUrl);
+//    }
+
+
+}
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java
index 4c2ed56..855e735 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java
@@ -40,12 +40,6 @@
         return R.ok(slGoodsShelfService.getGoodsShelfList(slGoodsShelfQuery));
     }
 
-    @PostMapping("/getBGoodsShelfList")
-    @ApiOperation(value = "分页不获货架表管理")
-    public R<List<SlGoodsShelf>> getBGoodsShelfList(@RequestBody SlGoodsShelfQuery slGoodsShelfQuery) {
-        return R.ok(slGoodsShelfService.getBGoodsShelfList(slGoodsShelfQuery));
-    }
-
     @PostMapping("/addSlGoodsShelf")
     @ApiOperation(value = "添加/修改货架管理")
     public R addSlGoodsShelf(@RequestBody SlGoodsShelfDTO slGoodsShelfDTO) {
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlStoreManagementImgController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlStoreManagementImgController.java
index 01a19fc..db4adf0 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlStoreManagementImgController.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlStoreManagementImgController.java
@@ -40,7 +40,7 @@
     }
 
     @PostMapping("/getStoreManagementimgOne")
-    @ApiOperation(value = "獲取仓库管理平面圖")
+    @ApiOperation(value = "获取仓库管理平面圖")
     public R<SlStoreManagementImg> getStoreManagementimgOne(@RequestBody StoreManagementimgQuery storeManagementimgQuery) {
         return R.ok(slStoreManagementImgService.getStoreManagementimgOne(storeManagementimgQuery));
     }
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java
index 454eb58..c4e1f6f 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java
@@ -60,8 +60,8 @@
 
     @PostMapping("/uplSlVolumeProductionRk")
     @ApiOperation(value = "修改入库批次管理")
-    public R uplSlVolumeProductionRk(@RequestBody List<SlVolumeProductionRkDTO> SlVolumeProductionRkDTO) {
-        slVolumeProductionRkService.uplSlVolumeProductionRk(SlVolumeProductionRkDTO);
+    public R uplSlVolumeProductionRk(@RequestBody UpdateRKDTO slVolumeProductionRkDTOS) {
+        slVolumeProductionRkService.uplSlVolumeProductionRk(slVolumeProductionRkDTOS.getSlVolumeProductionRkDTOS());
         return R.ok();
     }
 
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAudit.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAudit.java
index 035a645..db78053 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAudit.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAudit.java
@@ -7,6 +7,7 @@
 import java.util.Date;
 import io.swagger.annotations.ApiModel;
 import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
 import lombok.Getter;
 import lombok.Setter;
 
@@ -18,8 +19,7 @@
  * @author hjl
  * @since 2024-06-25
  */
-@Getter
-@Setter
+@Data
 @TableName("sl_audit")
 @ApiModel(value = "SlAudit对象", description = "审核记录")
 public class SlAudit {
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/ADDRKDTO.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/ADDRKDTO.java
new file mode 100644
index 0000000..575280a
--- /dev/null
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/ADDRKDTO.java
@@ -0,0 +1,13 @@
+package com.ruoyi.management.domain.dto;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+@ApiModel("添加入库批次DTO")
+public class ADDRKDTO {
+    private List<SlVolumeProductionRkListDTO> slVolumeProductionRkListDTO;
+}
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/HomeStatisticsQuery.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/HomeStatisticsQuery.java
index 1c6355a..8ade541 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/HomeStatisticsQuery.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/HomeStatisticsQuery.java
@@ -27,16 +27,13 @@
     @ApiModelProperty("货架id")
     private Long shelfId;
 
-
     /** 城市code */
     @ApiModelProperty("城市code")
     private String cityCode;
 
-
     /** 所属区县code */
     @ApiModelProperty("所属区县code")
     private String countyCode;
-
 
     /** 所属街道code */
     @ApiModelProperty("所属街道code")
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/UpdateRKDTO.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/UpdateRKDTO.java
new file mode 100644
index 0000000..2f93c81
--- /dev/null
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/UpdateRKDTO.java
@@ -0,0 +1,12 @@
+package com.ruoyi.management.domain.dto;
+
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+@ApiModel("添加入库批次DTO")
+public class UpdateRKDTO {
+    private List<SlVolumeProductionRkDTO> slVolumeProductionRkDTOS;
+}
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java
index 6512fee..d1e7b99 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java
@@ -1,5 +1,6 @@
 package com.ruoyi.management.domain.vo;
 
+import cn.hutool.core.date.DateTime;
 import com.baomidou.mybatisplus.annotation.TableField;
 import io.swagger.annotations.ApiModel;
 import io.swagger.annotations.ApiModelProperty;
@@ -15,6 +16,9 @@
 
     @ApiModelProperty("发起人电话")
     private String sysPhone;
+
+    @ApiModelProperty("发起时间")
+    private DateTime createTime;
 
     @ApiModelProperty("入库管理id")
     private Long rkId;
@@ -33,6 +37,8 @@
 
     @ApiModelProperty("1 待管理员审核,2 待主管审核,3 待主任审核, 4已完成, 5,已拒绝")
     private Integer auditStatus;
+    @ApiModelProperty("1 待管理员审核,2 待主管审核,3 待主任审核, 4已完成, 5,已拒绝")
+    private Integer state;
 
 
     @ApiModelProperty("申请人id")
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java
index 566fcd7..ad87ae9 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java
@@ -25,8 +25,6 @@
 public interface SlGoodsShelfService extends IService<SlGoodsShelf> {
     PageDTO<SlGoodsShelfVO> getGoodsShelfList(@RequestBody SlGoodsShelfQuery slGoodsShelfQuery);
 
-    List<SlGoodsShelf> getBGoodsShelfList(@RequestBody SlGoodsShelfQuery slGoodsShelfQuery);
-
    void addSlGoodsShelf(@RequestBody SlGoodsShelfDTO slGoodsShelfDTO);
 
     SlGoodsShelfVO getSlGoodsShelfOne( Long id);
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/HomeStatisticsServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/HomeStatisticsServiceImpl.java
index 8a4a08e..6a91647 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/HomeStatisticsServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/HomeStatisticsServiceImpl.java
@@ -120,6 +120,9 @@
                    repertoryZhai=repertoryZhai+li1.getCkNum();
                }
            }
+           if (li.getRkPice() == null){
+               li.setRkPice(BigDecimal.ZERO);
+           }
            d=d+li.getRkPice().multiply(new BigDecimal(li.getRkPice().intValue())).doubleValue();
            li.setRepertoryZhai(repertoryZhai);
        }
@@ -155,6 +158,9 @@
             // 处理键和值
             Long a=0L;
             for (homeVO vo : value) {
+                if (vo.getGoodsMaterialsNum()== null){
+                    vo.setGoodsMaterialsNum(0L);
+                }
                 a=a+vo.getGoodsMaterialsNum();
             }
             goodsMaterialsNmVO.setGoodsMaterialsNum(a);
@@ -174,6 +180,9 @@
             // 处理键和值
             Long a=0L;
             for (homeVO vo : value) {
+                if (vo.getGoodsMaterialsNum()== null){
+                    vo.setGoodsMaterialsNum(0L);
+                }
                 a=a+vo.getGoodsMaterialsNum();
             }
             goodsMaterialsNmVO1.setGoodsMaterialsNum(a);
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java
index c4e9fb4..4e872f8 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java
@@ -20,10 +20,7 @@
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.HashSet;
-import java.util.List;
-import java.util.Set;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -76,34 +73,26 @@
             goodsSkuIdList1.add(0L);
             wrapper.in(SlAudit::getSysId,goodsSkuIdList1);
         }
-        if (!data.getUserType().equals(00)){
+        if (!data.getUserType().equals("00")){
             wrapper.in(SlAudit::getShenhId,userid);
         }
-        List state=new ArrayList<>();
-        state.add(1);
-        state.add(2);
-        state.add(3);
-        state.add(4);
-        state.add(5);
-        wrapper.eq(SlAudit::getState,state);
         wrapper.eq(SlAudit::getType,auditRecordListQuery.getType());
-        wrapper.eq( SlAudit::getDelFlag,0);
+        wrapper.eq(SlAudit::getDelFlag,0);
         wrapper.orderByDesc(SlAudit::getCreateTime);
         Page<SlAudit> page1 = this.page(page, wrapper);
         PageDTO<SlAuditVO> slEquipmentVOPageDTO = PageDTO.of(page1, SlAuditVO.class);
         List<SlAuditVO> list = slEquipmentVOPageDTO.getList();
         for (SlAuditVO sl:list){
-            SlAuditVO slAuditVO=new SlAuditVO();
             SysUser data2 = sysUserClient.getSysUser(sl.getSysId()).getData();
-            slAuditVO.setSysPhone(data2.getPhonenumber());
-            slAuditVO.setSysName(data2.getNickName());
+            sl.setSysPhone(data2.getPhonenumber());
+            sl.setSysName(data2.getNickName());
             SlStoreManagement byId = slStoreManagementService.getById(sl.getManagementId());
-            slAuditVO.setStoreManagementName(byId.getStoreManagementName());
-            slAuditVO.setStoreManagementNo(byId.getStoreManagementNo());
+            sl.setStoreManagementName(byId.getStoreManagementName());
+            sl.setStoreManagementNo(byId.getStoreManagementNo());
             if (sl.getZymanagementId()!=null){
                 SlStoreManagement byId1 = slStoreManagementService.getById(sl.getZymanagementId());
-                slAuditVO.setBstoreManagementName(byId1.getStoreManagementName());
-                slAuditVO.setBstoreManagementNo(byId1.getStoreManagementNo());
+                sl.setBstoreManagementName(byId1.getStoreManagementName());
+                sl.setBstoreManagementNo(byId1.getStoreManagementNo());
             }
         }
         return slEquipmentVOPageDTO;
@@ -127,11 +116,10 @@
             }
             this.removeById(page1);
         }
-
-
         SlAudit slAudit=new SlAudit();
         slAudit.setType(slAuditDTO.getType());
         slAudit.setState(1);
+        slAudit.setCreateTime(new Date());
         slAudit.setRkId(slAuditDTO.getRkId());
         if (slAudit.getType()==1){
             SlVolumeProductionRkgl slVolumeProductionRkgl = slVolumeProductionRkglMapper.selectById(slAuditDTO.getRkId());
@@ -152,14 +140,14 @@
             slAuditRecord1.setShenhId(byId.getCompetentId());
             slAuditRecord1.setType(2);
             slAuditRecord1.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord1);
 
             SlAuditRecord slAuditRecord2=new SlAuditRecord();
             slAuditRecord2.setAuditId(slAudit.getId());
             slAuditRecord2.setShenhId(byId.getDirectorId());
             slAuditRecord2.setType(3);
             slAuditRecord2.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord2);
         }
         if (slAudit.getType()==2){
 
@@ -181,14 +169,14 @@
             slAuditRecord1.setShenhId(byId.getCompetentId());
             slAuditRecord1.setType(2);
             slAuditRecord1.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord1);
 
             SlAuditRecord slAuditRecord2=new SlAuditRecord();
             slAuditRecord2.setAuditId(slAudit.getId());
             slAuditRecord2.setShenhId(byId.getDirectorId());
             slAuditRecord2.setType(3);
             slAuditRecord2.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord2);
         }
         if (slAudit.getType()==3){
             SlVolumeProductionZygl slVolumeProductionZygl = slVolumeProductionZyglMapper.selectById(slAuditDTO.getRkId());
@@ -210,14 +198,14 @@
             slAuditRecord1.setShenhId(byId.getCompetentId());
             slAuditRecord1.setType(2);
             slAuditRecord1.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord1);
 
             SlAuditRecord slAuditRecord2=new SlAuditRecord();
             slAuditRecord2.setAuditId(slAudit.getId());
             slAuditRecord2.setShenhId(byId.getDirectorId());
             slAuditRecord2.setType(3);
             slAuditRecord2.setState(1);
-            slAuditRecordMapper.insert(slAuditRecord);
+            slAuditRecordMapper.insert(slAuditRecord2);
         }
 
     }
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java
index dd657cc..51ee44c 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java
@@ -87,8 +87,8 @@
     public PageDTO<SlGoodsMaterialsVO> getGoodSmaterialsList(SlGoodsMaterialsQuery slGoodsMaterialsQuery) {
         Page<SlGoodsMaterials> page = new Page<>(slGoodsMaterialsQuery.getPageCurr(), slGoodsMaterialsQuery.getPageSize());
         LambdaQueryWrapper< SlGoodsMaterials> wrapper= Wrappers.lambdaQuery();
-        if (slGoodsMaterialsQuery.getGoodsMaterialsName()!=null&&slGoodsMaterialsQuery.getGoodsMaterialsName()!=""){
-            wrapper.eq(SlGoodsMaterials::getGoodsMaterialsName,slGoodsMaterialsQuery.getGoodsMaterialsName());
+        if (slGoodsMaterialsQuery.getGoodsMaterialsName()!=null&& !slGoodsMaterialsQuery.getGoodsMaterialsName().isEmpty()){
+            wrapper.like(SlGoodsMaterials::getGoodsMaterialsName,slGoodsMaterialsQuery.getGoodsMaterialsName());
         }
         if (slGoodsMaterialsQuery.getIsConsume()!=0){
             wrapper.eq(SlGoodsMaterials::getIsConsume,slGoodsMaterialsQuery.getIsConsume());
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java
index b66f156..134822b 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java
@@ -103,44 +103,6 @@
     }
 
     @Override
-    public List<SlGoodsShelf> getBGoodsShelfList(SlGoodsShelfQuery slGoodsShelfQuery) {
-        Long userid = SecurityUtils.getUserId();
-        SysUser data = sysUserClient.getSysUser(userid).getData();
-
-        LambdaQueryWrapper<SlStoreManagement> wrapper= Wrappers.lambdaQuery();
-        if(slGoodsShelfQuery.getStoreManagementName()!=null&&slGoodsShelfQuery.getStoreManagementName()!=""){
-            wrapper.eq(SlStoreManagement::getStoreManagementName,slGoodsShelfQuery.getStoreManagementName());
-        }
-        if (slGoodsShelfQuery.getStoreManagementNumber()!=0 && slGoodsShelfQuery.getStoreManagementNumber()!=null){
-            wrapper.eq(SlStoreManagement::getStoreManagementGrade,slGoodsShelfQuery.getStoreManagementNumber());
-        }
-        wrapper.eq(SlStoreManagement::getStoreManagementGrade,data.getRoleType());
-        wrapper.eq(SlStoreManagement::getDelFlag,0);
-        List<SlStoreManagement> page1 = SlStoreManagementService.list(wrapper);
-        Set<Long> slStoreManagementIdList = null;
-        slStoreManagementIdList = page1.stream().map(SlStoreManagement::getId)
-                .collect(Collectors.toSet());
-
-
-        LambdaQueryWrapper< SlGoodsShelf> wrapper1= Wrappers.lambdaQuery();
-        wrapper1.like(SlGoodsShelf::getGoodsShelfName,slGoodsShelfQuery.getGoodsShelfName());
-        if(slGoodsShelfQuery.getStoreManagementName()!=null&&slGoodsShelfQuery.getStoreManagementName()!="") {
-            if (slStoreManagementIdList.size() > 0) {
-                wrapper1.in(SlGoodsShelf::getStoreManagementId, slStoreManagementIdList);
-            } else {
-                slStoreManagementIdList=new HashSet<>();
-                slStoreManagementIdList.add(0L);
-                wrapper1.in(SlGoodsShelf::getStoreManagementId, slStoreManagementIdList);
-            }
-        }
-        wrapper1.eq( SlGoodsShelf::getDelFlag,0);
-        wrapper1.orderByDesc(SlGoodsShelf::getCreateTime);
-        List<SlGoodsShelf> page2 = this.list(wrapper1);
-
-        return page2;
-    }
-
-    @Override
     public void addSlGoodsShelf(SlGoodsShelfDTO slGoodsShelfDTO) {
         if (slGoodsShelfDTO.getId()==null){
             SlGoodsShelf slGoodsShelf=new SlGoodsShelf();
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java
index 419fc4b..6f4e4ff 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java
@@ -80,8 +80,6 @@
             if (slGoodsShelf!=null){
                 list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName());
             }
-
-
             LambdaQueryWrapper<SlGoodsShelf> wrapper5= Wrappers.lambdaQuery();
             wrapper5.eq(SlGoodsShelf::getStoreManagementId,byId.getManagementId());
             wrapper5.eq(SlGoodsShelf::getStoreManagementNumber,list.getStoreManagementNumber());
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java
index eb5827b..b16390c 100644
--- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java
@@ -108,10 +108,10 @@
                 .collect(Collectors.toSet());
 
         LambdaQueryWrapper< SlVolumeProductionRkgl> wrapper1= Wrappers.lambdaQuery();
-        if (getVolumeProductionRkQuery.getPresentState()!=0&&getVolumeProductionRkQuery.getPresentState()!=null){
+        if (getVolumeProductionRkQuery.getPresentState()!=null && getVolumeProductionRkQuery.getPresentState()!=0){
             wrapper1.eq(SlVolumeProductionRkgl::getPresentState,getVolumeProductionRkQuery.getPresentState());
         }
-        if (getVolumeProductionRkQuery.getAuditStatus()!=0&&getVolumeProductionRkQuery.getAuditStatus()!=null) {
+        if (getVolumeProductionRkQuery.getAuditStatus()!=null && getVolumeProductionRkQuery.getAuditStatus()!=0) {
             wrapper1.eq(SlVolumeProductionRkgl::getAuditStatus, getVolumeProductionRkQuery.getAuditStatus());
         }
         if (goodsSkuIdList.size()>0){
@@ -158,6 +158,8 @@
             this.save(slVolumeProductionRkgl);
         }else{
             slVolumeProductionRkgl = this.getById(volumeProductionRkglDTO.getId());
+            slVolumeProductionRkgl.setPresentState(1);
+            slVolumeProductionRkgl.setAuditStatus(1);
             if (volumeProductionRkglDTO.getSource()!=null){
                 slVolumeProductionRkgl.setSource(volumeProductionRkglDTO.getSource());
             }
diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/util/ObsUploadUtil.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/util/ObsUploadUtil.java
new file mode 100644
index 0000000..05b98d9
--- /dev/null
+++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/util/ObsUploadUtil.java
@@ -0,0 +1,78 @@
+package com.ruoyi.management.util;
+
+import com.obs.services.ObsClient;
+import com.obs.services.model.ObjectMetadata;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
+import java.io.InputStream;
+import java.util.UUID;
+
+public class ObsUploadUtil {
+
+	public static String endPoint = "obs.cn-southwest-2.myhuaweicloud.com";
+	public static String accessKeyId = "LP9N1TLAYN8ERS1PVIYK";
+	public static String accessKeySecret = "bV55lFHi1cG0SYBvnab8yIgDX6etKRSLh5j1gkPR";
+	public static String bucketName = "haitunyingyu";
+	public static String oss_domain = "https://haitunyingyu.obs.cn-southwest-2.myhuaweicloud.com/";
+	// 创建ObsClient实例
+	public static ObsClient obsClient = new ObsClient(accessKeyId, accessKeySecret, endPoint);
+
+	public static String obsUpload(MultipartFile file) throws IOException{
+		//CommonsMultipartFile file = (CommonsMultipartFile)multipartFile;
+		String fileName = "";
+		if(file!=null && !"".equals(file.getOriginalFilename()) && file.getOriginalFilename()!=null){
+			InputStream content = file.getInputStream();//获得指定文件的输入流
+			ObjectMetadata meta = new ObjectMetadata();// 创建上传Object的Metadata
+			meta.setContentLength(file.getSize());  // 必须设置ContentLength
+			String originalFilename = file.getOriginalFilename();
+			if (originalFilename.contains("apk")){
+				fileName = "bf2fe5c5499341e5bc0d56c0c7d5fb2e.apk";
+				System.err.println("apk");
+			}else{
+				fileName =  UUID.randomUUID().toString().replaceAll("-","") + originalFilename.subSequence(originalFilename.lastIndexOf("."), originalFilename.length());
+			}
+			obsClient.putObject(bucketName,"admin/"+fileName,content,meta);// 上传Object.
+			if(fileName != null && !"".equals(fileName)){
+				System.out.println(fileName);
+				fileName = oss_domain+"admin/"+fileName;
+			}
+		}
+		return fileName;
+	}
+
+	/**
+	 * 删除某个Object
+	 *
+	 * @param bucketUrl
+	 * @return
+	 */
+	public static boolean deleteObject(String bucketUrl) {
+		try {
+			bucketUrl=bucketUrl.replace(oss_domain+"web","");
+			// 删除Object.
+			obsClient.deleteObject(bucketName, bucketUrl);
+		} catch (Exception e) {
+			e.printStackTrace();
+			return false;
+		} finally {
+			//ossClient.shutdown();
+		}
+		return true;
+	}
+	
+//	 public static void createBucket(String bucketName)
+//     {
+//         //初始化 OSSClient
+////          ossClient = new OssClient(endPoint, accessKeyId, accessKeySecret);
+//
+//         // 新建一个Bucket
+//         Bucket bucket = ossClient.createBucket(bucketName);
+//         System.out.println(bucket.getName());
+//         System.out.println(bucket.getCreationDate());
+//     }
+//	 
+//	 public static void main(String[] args) {
+//		 OssUploadUtil.createBucket("ssfdfsd");
+//	}
+}
diff --git a/ruoyi-modules/ruoyi-system/pom.xml b/ruoyi-modules/ruoyi-system/pom.xml
index 579270f..c09cc0c 100644
--- a/ruoyi-modules/ruoyi-system/pom.xml
+++ b/ruoyi-modules/ruoyi-system/pom.xml
@@ -96,11 +96,6 @@
             <version>1.2.47</version>
         </dependency>
         
-        <!-- 分布式事务 -->
-        <dependency>
-            <groupId>com.ruoyi</groupId>
-            <artifactId>ruoyi-common-seata</artifactId>
-        </dependency>
     </dependencies>
 
     <build>
diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDeptController.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDeptController.java
index b80814c..e14672b 100644
--- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDeptController.java
+++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDeptController.java
@@ -1,18 +1,15 @@
 package com.ruoyi.system.controller;
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-import com.baomidou.mybatisplus.core.toolkit.IdWorker;
 import java.util.List;
 
 import com.ruoyi.common.core.web.page.PageInfo;
-import com.ruoyi.system.api.domain.SysRole;
 import com.ruoyi.system.domain.dto.deptQuery;
 import com.ruoyi.system.service.ISysDeptService;
-import io.seata.common.util.StringUtils;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
-import org.apache.commons.lang3.ArrayUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.util.StringUtils;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.DeleteMapping;
 import org.springframework.web.bind.annotation.GetMapping;
@@ -22,7 +19,6 @@
 import org.springframework.web.bind.annotation.RequestBody;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RestController;
-import com.ruoyi.common.core.constant.UserConstants;
 import com.ruoyi.common.core.web.controller.BaseController;
 import com.ruoyi.common.core.web.domain.AjaxResult;
 import com.ruoyi.common.log.annotation.Log;
@@ -65,7 +61,7 @@
 
         PageInfo<SysDept> page = deptService.page(pageInfo,
                 new LambdaQueryWrapper<SysDept>().orderByDesc(SysDept::getCreateTime)
-                        .like(StringUtils.isNotBlank(dept.getDeptName()), SysDept::getDeptName,
+                        .like(StringUtils.hasLength(dept.getDeptName()), SysDept::getDeptName,
                                 dept.getDeptName()).eq(SysDept::getDelFlag, "0"));
         return AjaxResult.success(page);
     }
@@ -73,7 +69,6 @@
     /**
      * 查询部门列表(排除节点)
      */
-
     /**
      * 根据部门编号获取详细信息
      */
diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysRoleController.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysRoleController.java
index dbdf710..0103917 100644
--- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysRoleController.java
+++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysRoleController.java
@@ -27,7 +27,6 @@
 import com.ruoyi.system.service.ISysRoleService;
 import com.ruoyi.system.service.ISysUserRoleService;
 import com.ruoyi.system.service.ISysUserService;
-import io.seata.common.util.StringUtils;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import io.swagger.annotations.ApiParam;
@@ -41,6 +40,7 @@
 import javax.servlet.http.HttpServletResponse;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.util.CollectionUtils;
+import org.springframework.util.StringUtils;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.DeleteMapping;
 import org.springframework.web.bind.annotation.GetMapping;
@@ -100,7 +100,7 @@
 
         PageInfo<SysRole> page = roleService.page(pageInfo,
                 new LambdaQueryWrapper<SysRole>().ne(SysRole::getRoleId, 20)
-                        .like(StringUtils.isNotBlank(query.getRoleName()), SysRole::getRoleName,
+                        .like(StringUtils.hasLength(query.getRoleName()), SysRole::getRoleName,
                                 query.getRoleName()).eq(SysRole::getDelFlag, "0"));
         return AjaxResult.success(page);
     }
diff --git a/ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml b/ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
index 6fd7c73..9db6064 100644
--- a/ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
+++ b/ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
@@ -24,9 +24,16 @@
         <result property="updateTime"   column="update_time"  />
 		<result property="contacts"   column="contacts"  />
         <result property="remark"       column="remark"       />
-        <result property="roleType"       column="roleType"       />
-        <result property="objectId"       column="objectId"       />
+        <result property="provinceName"       column="province_name"       />
+        <result property="provinceCode"       column="province_code"       />
+        <result property="cityName"       column="city_name"       />
+        <result property="cityCode"       column="city_code"       />
+        <result property="countyName"       column="county_name"       />
+        <result property="countyCode"       column="county_code"       />
+        <result property="townName"       column="town_name"       />
+        <result property="townCode"       column="town_code"       />
 			<result property="userType" column="user_type"/>
+			<result property="roleType" column="roleType"/>
         <association property="dept"    column="dept_id" javaType="com.ruoyi.system.api.domain.SysDept" resultMap="deptResult" />
         <collection  property="roles"   javaType="java.util.List"           resultMap="RoleResult" />
     </resultMap>
@@ -52,14 +59,22 @@
 	
 	<sql id="selectUserVo">
         select u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark, 
-        d.dept_id, d.dept_name,u.contacts,u.province_name,u.province_code,u.city_name,u.city_code,u.county_name,u.county_code,u.town_name,u.town_code,
+        d.dept_id, d.dept_name,u.contacts,
+        u.province_name ,
+        u.province_code ,
+        u.city_name ,
+        u.city_code ,
+        u.county_name ,
+        u.county_code ,
+        u.town_name ,
+        u.town_code ,
 							 r.role_id,
 							 r.role_name,
 							 r.role_key,
 							 r.role_sort,
 							 r.data_scope,
 							 r.status   as role_status,
-							 u.roleType as roleType,
+							 u.roleType,
 							 u.objectId AS objectId,
 							 u.user_type
         from sys_user u

--
Gitblit v1.7.1