Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- playground:prodliste:mainmenue [2022/12/08 14:48] – angelegt andretzky
+++ playground:prodliste:mainmenue [2025/08/28 12:40] (aktuell) – Externe Bearbeitung 127.0.0.1
@@ Zeile 1: / Zeile 1: @@
-====== Atikelinfos ======
-[[playground:prodliste:6005|6005]]
-======  ======
+====== Liste der Q-meldungen ======
+~~NOCACHE~~
+<datatables dom="Bfrtip" buttons=' [ "copy" ]'>
+<sql> select q_meldung.Lfd_Nr as 'Lfd-Nr.',
+q_meldung.erstellt_am as 'Datum',
+CONVERT(CAST(CONVERT(Gemeldet_von USING latin1) AS BINARY) USING utf8) as 'Gemeldet von',
+CONVERT(CAST(CONVERT(Ursprung USING latin1) AS BINARY) USING utf8) as Ursprung,
+CONVERT(CAST(CONVERT(Kunden USING latin1) AS BINARY) USING utf8) as 'Kunden/Lieferant',
+CONVERT(CAST(CONVERT(Bezeichnung USING latin1) AS BINARY) USING utf8) as Bezeichnung,
+CONVERT(CAST(CONVERT(Menge USING latin1) AS BINARY) USING utf8) as 'Anz.',
+CONVERT(CAST(CONVERT(Reklamationsgrund USING latin1) AS BINARY) USING utf8) as Reklamationsgrund,
+CONVERT(CAST(CONVERT(geschaetzter_Nacharbeitsaufwand USING latin1) AS BINARY) USING utf8) as 'Nacharbeitsaufwand',
+CONVERT(CAST(CONVERT(Materialkosten_Nacharbeit USING latin1) AS BINARY) USING utf8) as 'Materialkosten'
+ from qm_massnahmen, q_meldung WHERE qm_massnahmen.Lfd_Nr = q_meldung.Lfd_Nr
+;</sql>
+</datatable>
-Page: playground:prodliste:mainmenue
-Creator: [[user:andretzky|Tassilo Andretzky]]
-Date: 08/12/2022 14:48