Tym razem do listy faktur - bez tego mam niektóre faktury (dla klientów mających wystawiane faktury co miesiąc) w podsumowaniu ze zdublowanymi pozycjami (np. faktura z jedna pozycja na 60zł ma niby 52 pozycje na kwote 3120,00zł :)
Index: invoicelist.php =================================================================== RCS file: /cvsroot/lms/modules/invoicelist.php,v retrieving revision 1.66 diff -u -r1.66 invoicelist.php --- invoicelist.php 1 Apr 2011 10:35:12 -0000 1.66 +++ invoicelist.php 6 Dec 2011 13:45:40 -0000 @@ -107,7 +107,7 @@ COUNT(a.docid) AS count FROM documents d JOIN invoicecontents a ON (a.docid = d.id) - LEFT JOIN invoicecontents b ON (d.reference = b.docid AND a.itemid = b.itemid) + LEFT JOIN invoicecontents b ON (d.reference>0 AND d.reference = b.docid AND a.itemid = b.itemid) LEFT JOIN countries ON (countries.id = d.countryid) LEFT JOIN numberplans ON (d.numberplanid = numberplans.id) LEFT JOIN (
pozdrawiam Jarek Dziubek