130829 12:58:45  2020 Connect   lms@localhost on
                 2020 Init DB   lms
                 2020 Query     SET NAMES 'UTF8'
                 2020 Query     SELECT section, var, value FROM uiconfig WHERE disabled=0
                 2020 Query     SELECT d.id AS docid, c.id, c.pin, d.name,
                d.number, n.template, d.cdate, d.paytime, c.email,
                COALESCE(ca.balance, 0) AS balance, v.value
                FROM documents d
                JOIN customers c ON (c.id = d.customerid)
                JOIN (SELECT SUM(value) * -1 AS value, docid
                        FROM cash
                        GROUP BY docid
                ) v ON (v.docid = d.id)
                LEFT JOIN numberplans n ON (d.numberplanid = n.id)
                LEFT JOIN (SELECT SUM(value) AS balance, customerid
                        FROM cash
                        GROUP BY customerid
                ) ca ON (ca.customerid = d.customerid)
                WHERE c.email <> '' AND d.type = 1
                        AND d.cdate > UNIX_TIMESTAMP() - 86400
                 2020 Query     INSERT INTO messages (type, cdate, subject, body)
                VALUES (1, UNIX_TIMESTAMP(), 'invoices test', 'test')
                 2020 Query     SELECT LAST_INSERT_ID()
                 2020 Query     INSERT INTO messageitems
                (messageid, customerid, destination, status)
                VALUES ('146', '843', 'paszczus@gmail.com', 1)
                 2020 Query     UPDATE messageitems
                SET status = 3, lastdate = UNIX_TIMESTAMP(), error = 'Failed to connect to x.x.x.x:25 [SMTP: Failed to connect socket: Connection refused (code: -1, response: )]'
                WHERE messageid = '146' AND customerid = '843'
                 2020 Query     SELECT d.id AS docid, c.id, c.pin, d.name,
                d.number, n.template, d.cdate, d.paytime, c.email,
                COALESCE(ca.balance, 0) AS balance, v.value
                FROM documents d
                JOIN customers c ON (c.id = d.customerid)
                JOIN (
                        SELECT SUM(value) * -1 AS value, docid
                        FROM cash
                        GROUP BY docid
                ) v ON (v.docid = d.id)
                LEFT JOIN numberplans n ON (d.numberplanid = n.id)
                LEFT JOIN (
                        SELECT SUM(value) AS balance, cash.customerid
                        FROM cash
                        LEFT JOIN documents ON documents.id = cash.docid
                        WHERE cash.docid = 0 OR (cash.docid <> 0
                                AND (documents.type = 2 OR (documents.type IN (1,3)
                                        AND documents.cdate + documents.paytime * 86400 < UNIX_TIMESTAMP())))
                        GROUP BY cash.customerid
                ) ca ON (ca.customerid = d.customerid)
                WHERE c.email <> '' AND d.type = 1 AND d.closed = 0 AND ca.balance < 0
                        AND d.cdate + (d.paytime + 1 + 10) * 86400 > UNIX_TIMESTAMP()
                        AND d.cdate + (d.paytime + 10) * 86400 < UNIX_TIMESTAMP()
                 2020 Query     SELECT d.id AS docid, c.id, c.pin, d.name,
                d.number, n.template, d.cdate, c.email,
                COALESCE(ca.balance, 0) AS balance, v.value
                FROM documents d
                JOIN customers c ON (c.id = d.customerid)
                JOIN (SELECT SUM(value) * -1 AS value, docid
                        FROM cash
                        GROUP BY docid
                ) v ON (v.docid = d.id)
                LEFT JOIN numberplans n ON (d.numberplanid = n.id)
                LEFT JOIN (SELECT SUM(value) AS balance, customerid
                        FROM cash
                        GROUP BY customerid
                ) ca ON (ca.customerid = d.customerid)
                WHERE c.email <> '' AND d.type = 5
                        AND d.cdate > UNIX_TIMESTAMP() - 86400
                 2020 Quit