W dniu 21.04.2012 10:05, JOYNET napisał(a):
> tak, tez robilem, ale problem jest z tym zapytaniem:
> tak wyglada oryginal:
> // get documents data
> $docs = $DB->GetAllByKey('SELECT documents.id AS id, number,
> cdate, customerid,
> userid, name, address, zip, city, ten, ssn, template,
> reference, extnumber, paytime, closed
> FROM documents
> LEFT JOIN numberplans ON numberplanid =
> numberplans.id
> WHERE (type = ? OR type = ?) AND (cdate BETWEEN ? AND
> ?) ', 'id', array(DOC_INVOICE, DOC_CNOTE, $unixfrom, $unixto));
>
>
>
> a tak po zmianie;
>
> // get documents data
> $docs = $DB->GetAllByKey('SELECT documents.id AS id,
> imessengers.uid AS nrfv, number, cdate, customerid,
> userid, name, address, zip, city, ten, ssn, template,
> reference, extnumber, paytime, closed
> FROM documents
> LEFT JOIN imessengers ON (imessengers.customerid =
> documents.customerid) AND (imessengers.type = 1)
> LEFT JOIN numberplans ON numberplanid = numberplans.id
> WHERE (type = ? OR type = ?) AND (cdate BETWEEN ? AND ?) ',
> 'id', array(DOC_INVOICE, DOC_CNOTE, $unixfrom, $unixto));
>
> po ktorej nie laduje juz zadnych danych do exportu...
Wstaw zapytanie:
SELECT documents.id AS id, imessengers.uid AS nrfv, number, cdate,
customerid,
userid, name, address, zip, city, ten, ssn, template,
reference, extnumber, paytime, closed
FROM documents
LEFT JOIN imessengers ON (imessengers.customerid =
documents.customerid) AND (imessengers.type = 1)
LEFT JOIN numberplans ON numberplanid = numberplans.id;
i zobacz jaki będzie błąd.
--
Pozdrawiam
Tomasz Chiliński, Chilan
