Hi Christian,
Fehlermeldung: Wieder Unknown column 'iv.invoice_number' - wie würdest du denn die Zeile schreiben?
LG FElix
HTML Code:
/* List of invoices */ SELECT tl.id AS ptid, iv.invoice_number as ReNr, CASE WHEN iv.invoice_type_id = '1' THEN 'Supplier' WHEN iv.invoice_type_id = '2' THEN 'Company' END as 'Typ', LEFT(iv.created_at,10) as ReDatum, ivp.`type` AS 'Anteil', CASE WHEN ivp.`type` = 'Office' THEN ROUND((ivp.value/100),2) END as 'Betrag Global', CASE WHEN ivp.`type` = 'Agent' THEN ROUND((ivp.value/100),2) END as 'Betrag M', LEFT(PaymentReminderSentAt,10) as 'Z-Erinnerung', ROUND(ta.value/100,2) as 'Zahlung', LEFT(ta.`date`,10) as 'am', c.name AS 'Payment_Z' FROM invoices iv LEFT JOIN taims tl ON (iv.taim_id = tl.id) LEFT JOIN company c ON (tl.company_id=c.id) LEFT JOIN invoice_parts ivp ON (ivp.invoice_id = iv.id) LEFT JOIN invoice_part_transaction ivpt ON (ivpt.invoice_part_id = ivp.id) LEFT JOIN transactions ta ON (ta.id = ivpt.transaction_id) LEFT JOIN (SELECT eml.taim_id, MAX(eml.sent_at) AS PaymentReminderSentAt FROM emails eml WHERE eml.deleted_at IS NULL AND eml.template LIKE 'Zahlungserinnerung%' AND eml.body LIKE '%'||concat(iv.invoice_number)||'%' GROUP BY taim_id) AS em ON (em.taim_id=tl.id) WHERE iv.deleted_at IS NULL AND iv.value != '0' And tl.id = '72' ORDER BY iv.invoice_number ASC
LG FElix
Comment