[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [8923] property: find invoice by vendor id
From: |
Sigurd Nes |
Subject: |
[Fmsystem-commits] [8923] property: find invoice by vendor id |
Date: |
Fri, 17 Feb 2012 13:21:44 +0000 |
Revision: 8923
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8923
Author: sigurdne
Date: 2012-02-17 13:21:43 +0000 (Fri, 17 Feb 2012)
Log Message:
-----------
property: find invoice by vendor id
Modified Paths:
--------------
trunk/property/inc/class.soinvoice.inc.php
Modified: trunk/property/inc/class.soinvoice.inc.php
===================================================================
--- trunk/property/inc/class.soinvoice.inc.php 2012-02-17 10:50:03 UTC (rev
8922)
+++ trunk/property/inc/class.soinvoice.inc.php 2012-02-17 13:21:43 UTC (rev
8923)
@@ -86,7 +86,6 @@
$join_tables = '';
$filtermethod = '';
$querymethod = '';
- //_debug_array($data);
$this->db->query("SELECT * FROM fm_ecoart");
$art_list = array();
@@ -175,7 +174,7 @@
$no_q = false;
if ($voucher_id)
{
- $filtermethod = " WHERE bilagsnr = " .
(int)$voucher_id . " OR bilagsnr_ut = '{$voucher_id}'";
+ $filtermethod = " WHERE bilagsnr = " .
(int)$voucher_id . " OR bilagsnr_ut = '{$voucher_id}' OR spvend_code = ".
(int)$query;
$no_q = true;
}
@@ -193,7 +192,7 @@
$sql = "SELECT bilagsnr, bilagsnr_ut, count(bilagsnr)
as invoice_count, sum(belop) as belop, sum(godkjentbelop) as
godkjentbelop,spvend_code,fakturadato FROM $table $join_tables $filtermethod
$querymethod GROUP BY periode,
bilagsnr,bilagsnr_ut,spvend_code,fakturadato,oppsynsigndato,saksigndato,budsjettsigndato";
$sql2 = "SELECT DISTINCT bilagsnr FROM $table
$join_tables $filtermethod $querymethod";
-
+ _debug_array($sql);
$this->db->query($sql2,__LINE__,__FILE__);
$this->total_records = $this->db->num_rows();
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [8923] property: find invoice by vendor id,
Sigurd Nes <=