jest dobrze. dzieki
Pozdrawiam Michał Korzeniowski www.mediatelekom.pl <www.mediatelekom.pl> Media Telekom Sp. z o.o. ul. Berka Joselewicza 3 08-110 Siedlce tel:+48 25 7948484 mob:+48 533733249 NIP:821-264-03-46 REGON:147113865 KRS 0000499286 Sąd Rejonowy dla m.st. Warszawy w Warszawie, XIV Wydział Gospodarczy Krajowego Rejestru Sądowego W dniu 11.01.2016 o 13:13, Tomasz Chiliński pisze:
diff --git a/bin/lms-sendinvoices b/bin/lms-sendinvoices index e67fc77..736788b 100755 --- a/bin/lms-sendinvoices +++ b/bin/lms-sendinvoices @@ -235,7 +235,7 @@ $dbq = $dbase->prepare("SELECT d.id, d.number, d.cdate, d.name, d.customerid, n. LEFT JOIN customers c ON (c.id = d.customerid) LEFT JOIN numberplans n ON (n.id = d.numberplanid) $groupjoin
WHERE c.deleted = 0 AND d.type = 1 AND EXISTS(SELECT COUNT(contact) FROM customercontacts WHERE customerid = c.id AND (type & 16 > 0))
WHERE c.deleted = 0 AND d.type = 1 AND EXISTS(SELECT id FROM customercontacts WHERE customerid = c.id AND (type & 16 > 0)) AND d.cdate >= $daystart AND d.cdate <= $dayend AND c.invoicenotice = 1 $groupwhere"); $dbq->execute();
