zq-erp/src/main/java/com/matrix/system/app/action/ApiStoreAction.java
@@ -49,7 +49,7 @@ sysStoreInfo.setShopId(users.getShopId()); sysStoreInfo.setCompanyId(users.getCompanyId()); } sysStoreInfo.setQueryKey(storeListDto.getQueryKey()); PaginationVO pageVo = new PaginationVO(); pageVo.setOffset((storeListDto.getPageNum() - 1) * storeListDto.getPageSize()); pageVo.setLimit(storeListDto.getPageSize()); zq-erp/src/main/java/com/matrix/system/hive/bean/SysStoreInfo.java
@@ -87,6 +87,17 @@ private String name; @Extend private String queryKey; public String getQueryKey() { return queryKey; } public void setQueryKey(String queryKey) { this.queryKey = queryKey; } public String getName() { return name; } zq-erp/src/main/resources/mybatis/mapper/hive/SysStoreInfoDao.xml
@@ -406,6 +406,10 @@ <if test="record.batch != null and record.batch !='' "> and batch = #{record.batch} </if> <if test="record.queryKey != null and record.queryKey !='' "> and (instr(c.name,#{record.queryKey}) or instr(c.goods_no, #{record.queryKey}) or instr(c.zjm, #{record.queryKey})) </if> <if test="record.storeId != null and record.storeId !='' "> and STORE_ID = #{record.storeId} </if> @@ -479,6 +483,9 @@ <if test="record.batch != null and record.batch !='' "> and batch = #{record.batch} </if> <if test="record.queryKey != null and record.queryKey !='' "> and (instr(c.name,#{record.queryKey}) or instr(c.goods_no, #{record.queryKey}) or instr(c.zjm, #{record.queryKey})) </if> <if test="record.storeId != null and record.storeId !='' "> and STORE_ID = #{record.storeId} </if>