diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-11 04:54:33 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-11 04:54:33 +0000 |
| commit | fd63a4a63532aed40786de3f061796d17673eabe (patch) | |
| tree | 146f2374b8fc71ed0d6ce6c78b2fc37a8cb07615 /LedgerSMB/BP.pm | |
| parent | 19fe934f445c8f15b476f8cba1c3cbf449a59995 (diff) | |
Fixing error searching by address
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1263 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB/BP.pm')
| -rw-r--r-- | LedgerSMB/BP.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/LedgerSMB/BP.pm b/LedgerSMB/BP.pm index f745f62d..4eaade6b 100644 --- a/LedgerSMB/BP.pm +++ b/LedgerSMB/BP.pm @@ -67,7 +67,7 @@ sub get_vc { SELECT count(*) FROM (SELECT DISTINCT vc.id FROM $form->{vc} vc, $item a, status s - WHERE a.$form->{vc}_id = vc.id + WHERE a.entity_id = vc.entity_id AND s.trans_id = a.id AND s.formname = ? AND s.spoolfile IS NOT NULL) AS total|; @@ -91,7 +91,7 @@ sub get_vc { SELECT DISTINCT vc.id, vc.name FROM $item a JOIN $form->{vc} vc - ON (a.$form->{vc}_id = vc.id) + USING (entity_id) JOIN status s ON (s.trans_id = a.id) WHERE s.formname = ? AND s.spoolfile IS NOT NULL|; @@ -207,11 +207,11 @@ sub get_spoolfiles { WHERE s.trans_id = a.id AND s.spoolfile IS NOT NULL AND s.formname = ? - AND a.$form->{vc}_id = vc.id|; + AND a.entity_id = vc.entity_id|; push( @queryargs, $form->{type} ); if ( $form->{"$form->{vc}_id"} ) { - $query .= qq| AND a.$form->{vc}_id = $form->{"$form->{vc}_id"}|; + $query .= qq| AND a.entity_id = $form->{"entity_id"}|; } else { |