From c54a584c08f11ae73f05973defd1899ba9740557 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Fri, 7 Jun 2024 11:34:21 +0700
Subject: import match payment invoice

---
 import_match_payment_invoice.ktr | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'import_match_payment_invoice.ktr')

diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr
index 11e4155..7074623 100644
--- a/import_match_payment_invoice.ktr
+++ b/import_match_payment_invoice.ktr
@@ -556,7 +556,9 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select * from v_match_payment_invoice</sql>
+    <sql>select * from v_match_payment_invoice v
+join account_payment ap on ap.id = v.payment_id
+where ap.write_date >= (now() - '15 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
-- 
cgit v1.2.3