Revision 46b00796
Von Tamino Steinert vor 8 Monaten hinzugefügt
| templates/design40_webpages/custom_data_export_designer/edit.html | ||
|---|---|---|
| 39 | 39 |
SELECT extract(YEAR FROM oe.transdate) AS "Jahr", SUM(oe.amount) AS "Angebotssumme" |
| 40 | 40 |
FROM oe |
| 41 | 41 |
LEFT JOIN employee ON (oe.employee_id = employee.id) |
| 42 |
WHERE (oe.customer_id IS NOT NULL) |
|
| 43 |
AND COALESCE(oe.quotation, FALSE) |
|
| 42 |
WHERE record_type = 'sales_quotation' |
|
| 44 | 43 |
AND (employee.login = <%Benutzer-Login%>) |
| 45 | 44 |
GROUP BY "Jahr" |
| 46 | 45 |
ORDER BY "Jahr" |
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt