2020-11-15T14:16:47+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-15T14:16:47+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T14:16:47+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T14:16:47+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-11-15T14:16:47+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-15T14:17:30+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-11-15T14:17:30+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-15T14:17:30+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-15T14:17:30+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-15T14:17:30+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-15T14:17:30+01:00 NOTICE (5): getLastInsertRecord() 2020-11-15T14:17:30+01:00 NOTICE (5): LastID: 70495 2020-11-15T14:17:30+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-15T14:26:37+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-15T14:26:37+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T14:26:37+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T14:26:37+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:26:37+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-15T14:35:48+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:35:48+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC 2020-11-15T14:35:54+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:35:54+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 19062D38-80A2-4412-8668-26C27A7C3903 Editmode: 2020-11-15T14:35:54+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:35:54+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:04+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:04+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:08+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:08+01:00 NOTICE (5): AjaxController - uid: FDE31F37-ECBA-4072-8F76-687037BA0D6D Editmode: 1 2020-11-15T14:36:08+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [kundennummer] = ?, [name] = ?, [strasse] = ?, [ort] = ?, [plz] = ?, [telefon] = ?, [beschreibung] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-11-15T14:36:08+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:15+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:15+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 2F0CA026-7B38-48CC-AEE5-3ED01E995C89 Editmode: 2020-11-15T14:36:15+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:15+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:18+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:18+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 1F6CA346-8CA6-4F38-9D1E-40BF954ED02D Editmode: 2020-11-15T14:36:18+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:18+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:27+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:27+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: FF4405BA-86BB-4603-99A9-4AD7BF947D10 Editmode: 2020-11-15T14:36:27+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:27+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:33+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:33+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 548A483B-9DE8-4975-B892-AE3E27038AC0 Editmode: 2020-11-15T14:36:33+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:33+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:41+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:41+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 9904F652-4847-EA11-8438-00155D071F00 Editmode: 2020-11-15T14:36:41+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:41+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:46+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 9B53C729-BD36-EA11-8438-00155D071F00 Editmode: 2020-11-15T14:36:46+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:46+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:36:54+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:36:54+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 1D3E8AB7-E250-EA11-8439-00155D071F00 Editmode: 2020-11-15T14:36:54+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:36:54+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:37:01+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:37:01+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 43D90E78-EE94-EA11-843D-00155D071F00 Editmode: 2020-11-15T14:37:01+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:37:01+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:37:06+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:37:06+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 54C16BC7-36C0-EA11-8440-00155D071F00 Editmode: 2020-11-15T14:37:06+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:37:06+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:37:09+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:37:09+01:00 NOTICE (5): AjaxController - archivekundeAction - uid: 5C10EB48-753B-EA11-8438-00155D071F00 Editmode: 2020-11-15T14:37:09+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-11-15T14:37:09+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:40:05+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:40:05+01:00 NOTICE (5): AjaxController - uid: FDE31F37-ECBA-4072-8F76-687037BA0D6D Editmode: 0 2020-11-15T14:40:05+01:00 NOTICE (5): KundenTable - insertNewRecord 2020-11-15T14:40:05+01:00 NOTICE (5): KundenTable - SQL: INSERT INTO [kunde] ([kundennummer], [name], [strasse], [ort], [plz], [telefon], [beschreibung], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?, ?) 2020-11-15T14:40:05+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:40:25+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:40:25+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:40:28+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:40:28+01:00 NOTICE (5): AjaxController - uid: EC766E11-4827-EB11-844A-00155D071F00 Editmode: 1 2020-11-15T14:40:28+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [kundennummer] = ?, [name] = ?, [strasse] = ?, [ort] = ?, [plz] = ?, [telefon] = ?, [beschreibung] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-11-15T14:40:28+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:40:31+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:40:31+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:40:33+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:40:33+01:00 NOTICE (5): AjaxController - uid: EC766E11-4827-EB11-844A-00155D071F00 Editmode: 1 2020-11-15T14:40:33+01:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [kundennummer] = ?, [name] = ?, [strasse] = ?, [ort] = ?, [plz] = ?, [telefon] = ?, [beschreibung] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-11-15T14:40:33+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-11-15T14:41:03+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:41:03+01:00 NOTICE (5): AjaxController - uid: EC766E11-4827-EB11-844A-00155D071F00 Editmode: 0 2020-11-15T14:41:03+01:00 NOTICE (5): KundenTable - insertNewRecord 2020-11-15T14:41:03+01:00 NOTICE (5): KundenTable - SQL: INSERT INTO [kunde] ([kundennummer], [name], [strasse], [ort], [plz], [telefon], [beschreibung], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?, ?) 2020-11-15T14:41:03+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-11-15T14:41:24+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-15T14:41:24+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-11-15T14:41:24+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-11-15T14:41:24+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T14:41:24+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[archiv] = ? ORDER BY [name] ASC 2020-11-15T15:18:40+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-15T15:18:40+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T15:18:40+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-15T15:18:40+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T15:18:40+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-15T15:18:43+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-15T15:18:43+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-11-15T15:18:43+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-11-15T15:18:43+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-15T15:18:43+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[archiv] = ? ORDER BY [name] ASC