From 0a4f165eec7585da85a0bd58444efb5eac06d35f Mon Sep 17 00:00:00 2001
From: fs-danaus <danaus314@qq.com>
Date: 星期三, 21 二月 2024 17:53:34 +0800
Subject: [PATCH] 优化多附件上传功能及业绩宝接口代码更新

---
 src/com/yc/open/qiyunfang/service/QiyunfangImpl.java |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/com/yc/open/qiyunfang/service/QiyunfangImpl.java b/src/com/yc/open/qiyunfang/service/QiyunfangImpl.java
index 650f0b2..1fbd663 100644
--- a/src/com/yc/open/qiyunfang/service/QiyunfangImpl.java
+++ b/src/com/yc/open/qiyunfang/service/QiyunfangImpl.java
@@ -80,7 +80,7 @@
                 " a.Amount5 as AMT_5 , --25-36涓湀(閲戦)\n" +
                 " a.Amount6 as AMT_6 , --37-48涓湀(閲戦)\n" +
                 " a.Amount7 as AMT_7  --48涓湀浠ヤ笂(閲戦)\n" +
-                " from f140933(@companyid,@periodid,'','','',30,150,180,360,360,360) a", new BeanPropertyRowMapper<>(InventoryAgeDataEntry.class));
+                " from f140933(@companyid,@periodid,'','','',30,150,180,360,360,360) a where isnull(a.EndDigit,0)<>0 and isnull(a.EndAmount,0)<>0", new BeanPropertyRowMapper<>(InventoryAgeDataEntry.class));
     }
     @Override
     public List<CustomerDataEntry> getCustomerData() {

--
Gitblit v1.8.0