From 2d77aea8bdf80d27ffe88b5e14bf5d7cb5d8214b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 14 Sep 2007 04:56:25 +0000 Subject: Adding multi-vendor searches now require the account number for the AR/AP account git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1596 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Payment.sql | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'sql/modules') diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql index 6ecce576..15415f81 100644 --- a/sql/modules/Payment.sql +++ b/sql/modules/Payment.sql @@ -95,7 +95,8 @@ CREATE TYPE payment_contact_invoice AS ( CREATE OR REPLACE FUNCTION payment_get_all_contact_invoices (in_account_class int, in_business_type int, in_currency char(3), - in_date_from date, in_date_to date, in_batch_id int) + in_date_from date, in_date_to date, in_batch_id int, + in_ar_ap_accno text) RETURNS SETOF payment_contact_invoice AS $$ DECLARE payment_item payment_contact_invoice; @@ -135,8 +136,14 @@ BEGIN WHERE batch_id = in_batch_id)) AND c.entity_class = in_account_class AND a.curr = in_currency + AND EXISTS (select trans_id FROM acc_trans + WHERE trans_id = a.id AND + chart_id = (SELECT id frOM chart + WHERE accno + = in_ar_ap_accno) + ) GROUP BY e.id, e.name, c.meta_number, c.threshold - HAVING sum(amount - a.paid) > c.threshold + HAVING sum(a.amount - a.paid) > c.threshold LOOP RETURN NEXT payment_item; END LOOP; -- cgit v1.2.3 value='committer'>committer
path: root/tags/a5/d2
diff options
context:
space:
mode:
Diffstat (limited to 'tags/a5/d2')
-rw-r--r--tags/a5/d2/1301268695.26693.668.camel@localhost/debian0
-rw-r--r--tags/a5/d2/1301268695.26693.668.camel@localhost/signed0
-rw-r--r--tags/a5/d2/1938440111.3081436.1557251027432.JavaMail.app@lor1-app13311.prod.linkedin.com/unread0
-rw-r--r--tags/a5/d2/20061103012740.GB26839@nighthawk.chemicalconnection.dyndns.org/debian0
-rw-r--r--tags/a5/d2/20061103012740.GB26839@nighthawk.chemicalconnection.dyndns.org/inbox0
-rw-r--r--tags/a5/d2/20061103012740.GB26839@nighthawk.chemicalconnection.dyndns.org/old0
-rw-r--r--tags/a5/d2/200702141528.43952.rgx@gmx.de/debian0
-rw-r--r--tags/a5/d2/201212281539.43659.holger@layer-acht.org/debian0
-rw-r--r--tags/a5/d2/49BCD6A1.6050307@when.com/sugar0
-rw-r--r--tags/a5/d2/87blgbr89x.fsf@DigitalMercury.dynalias.net/debian0
-rw-r--r--tags/a5/d2/87blgbr89x.fsf@DigitalMercury.dynalias.net/signed0
-rw-r--r--tags/a5/d2/87blgbr89x.fsf@DigitalMercury.dynalias.net/unread0
-rw-r--r--tags/a5/d2/AANLkTikJDCRaubKOEaB7PQVFk-LkIuV_8niuiPz4ONc1@mail.gmail.com/sugar0
-rw-r--r--tags/a5/d2/AANLkTikJDCRaubKOEaB7PQVFk-LkIuV_8niuiPz4ONc1@mail.gmail.com/unread0
14 files changed, 0 insertions, 0 deletions