From b29e83da6faf2ee8157a4aee80d1c441da24fb33 Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Wed, 23 Dec 2020 16:54:05 +0800
Subject: [PATCH] modify

---
 zq-erp/src/main/java/com/matrix/system/hive/service/imp/ShoppingGoodsServiceImpl.java |    2 +-
 zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsDao.xml                    |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/zq-erp/src/main/java/com/matrix/system/hive/service/imp/ShoppingGoodsServiceImpl.java b/zq-erp/src/main/java/com/matrix/system/hive/service/imp/ShoppingGoodsServiceImpl.java
index 4977b14..161010c 100644
--- a/zq-erp/src/main/java/com/matrix/system/hive/service/imp/ShoppingGoodsServiceImpl.java
+++ b/zq-erp/src/main/java/com/matrix/system/hive/service/imp/ShoppingGoodsServiceImpl.java
@@ -476,7 +476,7 @@
         SysUsers user = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
         shoppingGoodsListDto.setShopId(user.getShopId());
         PaginationVO pageVo = new PaginationVO();
-        int offset = (shoppingGoodsListDto.getPageNum() - 1) + shoppingGoodsListDto.getPageSize();
+        int offset = (shoppingGoodsListDto.getPageNum() - 1) * shoppingGoodsListDto.getPageSize();
         int limit = shoppingGoodsListDto.getPageSize();
         pageVo.setOffset(offset);
         pageVo.setLimit(limit);
diff --git a/zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsDao.xml b/zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsDao.xml
index c06863f..9baed01 100644
--- a/zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsDao.xml
+++ b/zq-erp/src/main/resources/mybatis/mapper/hive/ShoppingGoodsDao.xml
@@ -1257,7 +1257,7 @@
 
 	<select id="selectShopppingGoodsAipTotal" resultType="java.lang.Integer">
 		select count(1)
-		from shopping_goods
+		from shopping_goods a
 		where 1=1
 		<if test="record.queryKey != null and record.queryKey != ''">
 			and (instr(name,#{record.queryKey}) or instr(code ,#{record.queryKey}) or instr(zjm ,#{record.queryKey}))

--
Gitblit v1.9.1