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.