2020-06-25T10:19:47+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-25T10:19:48+02: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] 2020-06-25T10:19:48+02: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] 2020-06-25T10:19:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:19:48+02: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] 2020-06-25T10:19:53+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:19:53+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T10:19:53+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T10:19:53+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:19:53+02: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-06-25T10:20:09+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:20:09+02:00 NOTICE (5): deleteprojektAction 2020-06-25T10:20:09+02:00 NOTICE (5): deleteData 2020-06-25T10:20:09+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ? 2020-06-25T10:22:57+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:22:57+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:23:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:23:01+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:23:01+02:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:23:01+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:23:01+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:23:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:23:01+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:23:25+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:23:25+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:23:25+02:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 0 2020-06-25T10:23:25+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:23:25+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:23:25+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:23:25+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:23:25+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:23:50+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:23:50+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:25:06+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:25:06+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:25:09+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:25:09+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:25:09+02:00 NOTICE (5): AjaxController - uid: DF4BE720-D85B-EA11-8439-00155D071F00 Editmode: 1 2020-06-25T10:25:09+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:25:09+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:25:09+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:25:09+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:25:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:25:48+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:25:48+02:00 NOTICE (5): AjaxController - uid: DF4BE720-D85B-EA11-8439-00155D071F00 Editmode: 0 2020-06-25T10:25:48+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:25:48+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:25:48+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:25:49+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:25:49+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:26:49+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:26:49+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 2020-06-25T10:26:49+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-25T10:26:49+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:27:16+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:27:16+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:27:20+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:27:20+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:27:20+02:00 NOTICE (5): AjaxController - uid: 8C2C931E-7D3B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:27:20+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:27:20+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:27:20+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:27:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:28:10+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:28:10+02:00 NOTICE (5): deleteprojektAction 2020-06-25T10:28:10+02:00 NOTICE (5): deleteData 2020-06-25T10:28:10+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ? 2020-06-25T10:34:00+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:34:00+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T10:34:00+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T10:34:00+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:34:00+02: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-06-25T10:34:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:34:03+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:34:08+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:34:08+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:34:08+02:00 NOTICE (5): AjaxController - uid: 2CB11809-B53E-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:34:08+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:34:08+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:34:08+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:34:08+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:39:44+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:39:44+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:40:14+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:40:14+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:40:14+02:00 NOTICE (5): AjaxController - uid: 50431B16-AE79-EA11-843B-00155D071F00 Editmode: 1 2020-06-25T10:40:14+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:40:14+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:40:15+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:40:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:41:26+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-25T10:41:26+02: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] 2020-06-25T10:41:26+02: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] 2020-06-25T10:41:26+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-06-25T10:41:26+02: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] 2020-06-25T10:41:56+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-06-25T10:41:56+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-25T10:41:56+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T10:41:56+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-25T10:41:56+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-25T10:41:57+02:00 NOTICE (5): getLastInsertRecord() 2020-06-25T10:41:57+02:00 NOTICE (5): LastID: 40323 2020-06-25T10:41:57+02: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] = ? 2020-06-25T10:42:01+02: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] 2020-06-25T10:42:01+02: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] 2020-06-25T10:42:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:42:01+02: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] 2020-06-25T10:42:36+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:42:36+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T10:42:36+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T10:42:36+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:42:36+02: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-06-25T10:43:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:43:52+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:43:52+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T10:43:52+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:43:52+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:43:52+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:43:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:43:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:45:39+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:45:39+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:45:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:45:43+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:45:43+02:00 NOTICE (5): AjaxController - uid: E036D2E7-5F59-EA11-8439-00155D071F00 Editmode: 1 2020-06-25T10:45:43+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:45:43+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:45:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:45:43+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:46:23+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:46:23+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:46:27+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:46:27+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:46:27+02:00 NOTICE (5): AjaxController - uid: A26C702A-813B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:46:27+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:46:27+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:46:27+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:46:27+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:47:44+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:47:44+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:47:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:47:52+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:47:52+02:00 NOTICE (5): AjaxController - uid: B127B48E-813B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:47:52+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:47:52+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:47:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:47:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:48:21+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:48:21+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:48:27+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:48:27+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:48:27+02:00 NOTICE (5): AjaxController - uid: DB80AC6A-7A3F-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:48:27+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:48:27+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:48:27+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:48:28+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:49:44+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:49:44+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:49:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:49:48+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:49:48+02:00 NOTICE (5): AjaxController - uid: F67AD849-823B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:49:48+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:49:48+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:49:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:49:48+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:50:09+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:50:09+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:50:15+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:50:15+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:50:15+02:00 NOTICE (5): AjaxController - uid: EBDD8F1A-823B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:50:15+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:50:15+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:50:15+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:50:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:52:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:52:01+02: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-06-25T10:52:07+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:52:07+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T10:52:07+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T10:52:07+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:52:07+02: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-06-25T10:52:17+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:52:17+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:52:17+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T10:52:17+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:52:17+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:52:17+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:52:17+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:52:17+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:53:42+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:53:42+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: F962A9E5-D75B-EA11-8439-00155D071F00 Editmode: 2020-06-25T10:53:42+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-25T10:53:42+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:53:56+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:53:56+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: C50580CB-813B-EA11-8438-00155D071F00 Editmode: 2020-06-25T10:53:56+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-25T10:53:56+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:54:47+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:54:47+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:54:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:54:52+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:54:52+02:00 NOTICE (5): AjaxController - uid: 96AA8A52-813B-EA11-8438-00155D071F00 Editmode: 1 2020-06-25T10:54:52+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:54:52+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:54:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:54:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:54:57+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:54:57+02: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-06-25T10:55:04+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:55:04+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T10:55:04+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T10:55:04+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:55:04+02: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-06-25T10:57:10+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:10+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:57:10+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T10:57:10+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:57:10+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:57:10+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:57:10+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:10+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:57:15+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:15+02: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-25T10:57:21+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:21+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:57:21+02:00 NOTICE (5): AjaxController - uid: 7A0B60DA-C1B6-EA11-8440-00155D071F00 Editmode: 1 2020-06-25T10:57:21+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-25T10:57:21+02: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].[uid] = ? ORDER BY [name] ASC 2020-06-25T10:57:21+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:21+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T10:57:45+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:45+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T10:57:45+02:00 NOTICE (5): AjaxController - uid: 7A0B60DA-C1B6-EA11-8440-00155D071F00 Editmode: 0 2020-06-25T10:57:45+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T10:57:45+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T10:57:45+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T10:57:45+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T10:57:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T11:18:06+02: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] 2020-06-25T11:18:06+02: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] 2020-06-25T11:18:06+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T11:18:06+02: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] 2020-06-25T11:18:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T11:18:20+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T11:18:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T11:18:20+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T11:18:20+02: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-06-25T11:18:29+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T11:18:29+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-25T11:18:29+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T11:18:29+02:00 NOTICE (5): ProjektTable - insertNewRecord 2020-06-25T11:18:29+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-06-25T11:18:29+02: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].[projektnummer] = ? ORDER BY [name] ASC 2020-06-25T11:18:29+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T11:18:29+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T11:47:51+02:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-06-25T11:47:51+02:00 INFO (6): Sie haben keine Berechtigung für diese Seite/Action/Route 2020-06-25T11:47:56+02: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] 2020-06-25T11:47:56+02: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] 2020-06-25T11:47:56+02:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-06-25T11:47:56+02:00 INFO (6): Sie haben keine Berechtigung für diese Seite/Action/Route 2020-06-25T11:48:03+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-25T11:48:03+02: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] 2020-06-25T11:48:03+02: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] 2020-06-25T11:48:03+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-06-25T11:48:03+02: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] 2020-06-25T11:48:17+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-06-25T11:48:17+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-25T11:48:17+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-25T11:48:17+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-25T11:48:17+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-25T11:48:17+02:00 NOTICE (5): getLastInsertRecord() 2020-06-25T11:48:17+02:00 NOTICE (5): LastID: 40324 2020-06-25T11:48:17+02: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] = ? 2020-06-25T14:15:48+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-25T14:15:48+02: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] 2020-06-25T14:15:48+02: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] 2020-06-25T14:15:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T14:15:48+02: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] 2020-06-25T14:15:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-25T14:15:52+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-25T14:15:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-25T14:15:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-25T14:15:52+02: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