From 13f17e5f0f2bc304dbfbfd62e31786fd5ec26dd9 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Tue, 29 Jun 2021 10:38:35 +0800
Subject: [PATCH] 20210628 集物员审核

---
 gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml           |    2 +-
 gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java       |    5 +++++
 gc-shop/src/main/java/com/xzx/gc/shop/service/OrderService.java     |    2 +-
 gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryJhyOrderListDto.java |    3 +++
 gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml            |    3 ++-
 5 files changed, 12 insertions(+), 3 deletions(-)

diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryJhyOrderListDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryJhyOrderListDto.java
index 1023b43..8ad8d67 100644
--- a/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryJhyOrderListDto.java
+++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryJhyOrderListDto.java
@@ -15,6 +15,9 @@
     @ApiModelProperty(value="联系人/手机号")
     private String account;
 
+    @ApiModelProperty(value="手机号")
+    private String accountPhone;
+
     @ApiModelProperty(value="状态 1-待接单2-服务中3-已收款4-待入库5-已完成6-已取消")
     private Integer status;
 
diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java b/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java
index 858f0ce..e073a68 100644
--- a/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java
+++ b/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java
@@ -3,6 +3,7 @@
 import cn.hutool.core.bean.BeanUtil;
 import cn.hutool.core.collection.CollUtil;
 import cn.hutool.core.convert.Convert;
+import cn.hutool.core.util.StrUtil;
 import com.github.pagehelper.PageHelper;
 import com.github.pagehelper.PageInfo;
 import com.xzx.gc.common.utils.StringUtils;
@@ -36,6 +37,10 @@
 
     public Map<String, Object> queryOrderList(QueryJhyOrderListDto model) {
         PageHelper.startPage(model.getPage(), model.getLimit());
+        String accountPhone = model.getAccount();
+        String name = StrUtil.isEmpty(model.getAccount())?model.getAccount():StringUtils.encode(model.getAccount());
+        model.setAccount(name);
+        model.setAccountPhone(accountPhone);
         List<QueryJhyOrderListVo> maps = jhyOrderMapper.queryOrderList(model);
         if(CollUtil.isNotEmpty(maps)){
             for(QueryJhyOrderListVo queryJhyOrderListVo : maps){
diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/service/OrderService.java b/gc-shop/src/main/java/com/xzx/gc/shop/service/OrderService.java
index 022caf0..1ecd9e8 100644
--- a/gc-shop/src/main/java/com/xzx/gc/shop/service/OrderService.java
+++ b/gc-shop/src/main/java/com/xzx/gc/shop/service/OrderService.java
@@ -61,7 +61,7 @@
     private IdUtils idUtils;
 
     public Map<String, Object> queryOrderList(QueryOrderListDto model) {
-        String name = model.getName();
+        String name = StrUtil.isEmpty(model.getName())?model.getName():StringUtils.encode(model.getName());
         String orderNo = model.getOrderNo();
         Integer status = model.getStatus() == null ? 0 : model.getStatus();
         Date createdTimeStart = model.getCreatedTimeStart();
diff --git a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
index 11e51cc..b1ff9e4 100644
--- a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
+++ b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
@@ -29,7 +29,7 @@
         </if>
         <if test="record.account != null and record.account != ''">
             and ( b.nick_name like concat('%',#{record.account},'%')
-                      or b.mobile_phone like concat('%',#{record.account},'%') )
+                      or b.mobile_phone like concat('%',#{record.accountPhone},'%') )
         </if>
         <if test="record.reserveTimeStart != null">
             and a.reserve_time >= #{record.reserveTimeStart}
diff --git a/gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml b/gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml
index 43c85d5..de9f4f6 100644
--- a/gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml
+++ b/gc-user/src/main/resources/mapper/user/JhyInfoMapper.xml
@@ -23,7 +23,8 @@
         <where>
             1=1
             <if test="record.name != null and record.name != ''">
-                and (username like CONCAT(CONCAT(#{record.name}, '%'), '%') or phone=#{record.phone})
+                and (username like concat('%',#{record.name},'%')
+                or phone like concat('%',#{record.phone},'%') )
             </if>
             <if test="record.isJhy != null and record.isJhy != ''">
                 and is_jhy=#{record.isJhy}

--
Gitblit v1.9.1