2020-06-22T10:37:14+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-22T10:37:14+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-22T10:37:14+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-22T10:37:14+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:14+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-22T10:37:22+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:37:22+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-22T10:37:22+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-22T10:37:22+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:22+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-22T10:37:26+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:26+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-22T10:37:29+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:29+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:37:29+02:00 NOTICE (5): AjaxController - uid: 9778CD3B-703B-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:37:29+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:37: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].[uid] = ? ORDER BY [name] ASC 2020-06-22T10:37:29+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:29+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:37:34+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:34+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-22T10:37:37+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:37+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:37:37+02:00 NOTICE (5): AjaxController - uid: EFF54B24-803B-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:37:37+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:37:37+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-22T10:37:37+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:37+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:37:53+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T10:37:56+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:56+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:37:56+02:00 NOTICE (5): AjaxController - uid: 50ABE226-823B-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:37:56+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:37: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-22T10:37:56+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:37:56+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38: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] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T10:38:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:03+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:03+02:00 NOTICE (5): AjaxController - uid: 2CB11809-B53E-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:38:03+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38: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] = ? ORDER BY [name] ASC 2020-06-22T10:38:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:03+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:10+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T10:38:13+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:13+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:13+02:00 NOTICE (5): AjaxController - uid: 15CEA403-8E3F-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:38:13+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38:13+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-22T10:38:13+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:13+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:18+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:18+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-22T10:38:20+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:20+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:20+02:00 NOTICE (5): AjaxController - uid: CBB9DA35-D940-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T10:38:20+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38: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-22T10:38:20+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:31+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:31+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-22T10:38:36+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:36+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:36+02:00 NOTICE (5): AjaxController - uid: 8C55B4B4-3152-EA11-8439-00155D071F00 Editmode: 1 2020-06-22T10:38:36+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38: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].[uid] = ? ORDER BY [name] ASC 2020-06-22T10:38:36+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:36+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:38+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:38+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-22T10:38:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:43+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:43+02:00 NOTICE (5): AjaxController - uid: 4225EF91-4656-EA11-8439-00155D071F00 Editmode: 1 2020-06-22T10:38:43+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38: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-22T10:38:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:43+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:38:50+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38: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-22T10:38:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:52+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:38:52+02:00 NOTICE (5): AjaxController - uid: B554ECEA-4656-EA11-8439-00155D071F00 Editmode: 1 2020-06-22T10:38:52+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:38: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-22T10:38:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:38:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:39:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39: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] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T10:39:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:03+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:39:03+02:00 NOTICE (5): AjaxController - uid: DF4BE720-D85B-EA11-8439-00155D071F00 Editmode: 1 2020-06-22T10:39:03+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:39: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] = ? ORDER BY [name] ASC 2020-06-22T10:39:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:03+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:39:19+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:19+02:00 NOTICE (5): deleteprojektAction 2020-06-22T10:39:19+02:00 NOTICE (5): deleteData 2020-06-22T10:39:19+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ? 2020-06-22T10:39:30+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:30+02:00 NOTICE (5): deleteprojektAction 2020-06-22T10:39:30+02:00 NOTICE (5): deleteData 2020-06-22T10:39:30+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ? 2020-06-22T10:39:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:43+02:00 NOTICE (5): deleteprojektAction 2020-06-22T10:39:43+02:00 NOTICE (5): deleteData 2020-06-22T10:39:43+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ? 2020-06-22T10:39:50+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39: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-22T10:39:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:52+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T10:39:52+02:00 NOTICE (5): AjaxController - uid: E9CDD339-F094-EA11-843D-00155D071F00 Editmode: 1 2020-06-22T10:39:52+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T10:39: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-22T10:39:53+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:39:53+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:40: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-22T10:40: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-22T10:40:01+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:40: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-22T10:40:02+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T10:40:02+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-22T10:40:02+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-22T10:40:02+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:40:02+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-22T10:40:16+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-22T10:40:16+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-22T10:40:16+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:40:16+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-22T10:40:58+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:40:58+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-22T10:40:58+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-22T10:40:58+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-22T10:40:58+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-22T10:40:58+02:00 NOTICE (5): getLastInsertRecord() 2020-06-22T10:40:58+02:00 NOTICE (5): LastID: 40315 2020-06-22T10:40:58+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-22T10:41:19+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:41:19+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-22T10:41:19+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-22T10:41:19+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-22T10:41:19+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-22T10:41:19+02:00 NOTICE (5): getLastInsertRecord() 2020-06-22T10:41:19+02:00 NOTICE (5): LastID: 40316 2020-06-22T10:41:19+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-22T10:41:55+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:41:55+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-22T10:41:55+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-22T10:41:55+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-22T10:41:55+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-22T10:41:55+02:00 NOTICE (5): getLastInsertRecord() 2020-06-22T10:41:55+02:00 NOTICE (5): LastID: 40317 2020-06-22T10:41:55+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-22T10:42:15+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:42:15+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-22T10:42:15+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-22T10:42:15+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-22T10:42:15+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-22T10:42:15+02:00 NOTICE (5): getLastInsertRecord() 2020-06-22T10:42:15+02:00 NOTICE (5): LastID: 40318 2020-06-22T10:42:15+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-22T10:42:33+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:42:33+02:00 INFO (6): addleistungAction() aufgerufen 2020-06-22T10:42:33+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-06-22T10:42:33+02:00 INFO (6): LeistungenTable - insertNewRecord 2020-06-22T10:42:33+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-06-22T10:42:33+02:00 NOTICE (5): getLastInsertRecord() 2020-06-22T10:42:33+02:00 NOTICE (5): LastID: 40319 2020-06-22T10:42:33+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-22T10:42:52+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-22T10:42:52+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-22T10:42:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T10:42:52+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-22T22:25:31+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-06-22T22:25:31+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-22T22:25:32+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-22T22:25:32+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:25:32+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-22T22:28:51+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:28:51+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-22T22:31:55+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:31:55+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-22T22:32:39+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:32:39+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:32:50+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:32:50+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: EB3A38A3-1445-4C69-B325-4B48032D20C5 Editmode: 2020-06-22T22:32:50+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:32:50+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].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-06-22T22:33:24+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:33:24+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 16D64CAB-7F8C-4253-850E-074A1D66A44C Editmode: 2020-06-22T22:33:24+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:33:24+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].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-06-22T22:33:39+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:33:39+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-22T22:34:08+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:34:08+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:34:18+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:34:18+02:00 NOTICE (5): AjaxController - uid: 05C13C31-0BA1-45EB-8BF5-0CB37CB1D5F3 Editmode: 1 2020-06-22T22:34:18+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [kundennummer] = ?, [name] = ?, [strasse] = ?, [ort] = ?, [plz] = ?, [telefon] = ?, [beschreibung] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T22:34:18+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:34:48+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:34:48+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:34:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:34:52+02:00 NOTICE (5): AjaxController - uid: BC92646B-6189-41CF-AFDF-485DE5BD4042 Editmode: 1 2020-06-22T22:34:52+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [kundennummer] = ?, [name] = ?, [strasse] = ?, [ort] = ?, [plz] = ?, [telefon] = ?, [beschreibung] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T22:34:52+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:38:09+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:38:09+02:00 NOTICE (5): AjaxController - uid: BC92646B-6189-41CF-AFDF-485DE5BD4042 Editmode: 0 2020-06-22T22:38:09+02:00 NOTICE (5): KundenTable - insertNewRecord 2020-06-22T22:38:09+02:00 NOTICE (5): KundenTable - SQL: INSERT INTO [kunde] ([kundennummer], [name], [strasse], [ort], [plz], [telefon], [beschreibung], [angelegt_von], [stundensatz]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 2020-06-22T22:38:09+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].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-06-22T22:39:52+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:39:52+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].[uid] = ? ORDER BY [k].[name] ASC 2020-06-22T22:40:00+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:40:00+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 8CDA37A0-693B-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:40:00+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:40:00+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].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-06-22T22:41:37+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:41:37+02:00 NOTICE (5): AjaxController - uid: 8CDA37A0-693B-EA11-8438-00155D071F00 Editmode: 0 2020-06-22T22:41:37+02:00 NOTICE (5): KundenTable - insertNewRecord 2020-06-22T22:41:37+02:00 NOTICE (5): KundenTable - SQL: INSERT INTO [kunde] ([kundennummer], [name], [strasse], [ort], [plz], [telefon], [beschreibung], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?, ?) 2020-06-22T22:41:37+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].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-06-22T22:42:17+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T22:42:17+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-22T22:42:17+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-22T22:42:17+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42: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].[archiv] = ? ORDER BY [name] ASC 2020-06-22T22:42:25+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42:25+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 9778CD3B-703B-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:42:25+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:42: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].[uid] = ? ORDER BY [name] ASC 2020-06-22T22:42:40+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42:40+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-22T22:42:49+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42:49+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T22:42:49+02:00 NOTICE (5): AjaxController - uid: BE1D984C-803B-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T22:42:49+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T22:42: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-22T22:42:49+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42:49+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T22:42:55+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:42:55+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: BE1D984C-803B-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:42:55+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:42:55+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-22T22:43:00+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:00+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: ACD201D3-803B-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:43:00+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43: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].[uid] = ? ORDER BY [name] ASC 2020-06-22T22:43:10+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T22:43:18+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:18+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T22:43:18+02:00 NOTICE (5): AjaxController - uid: 96AA8A52-813B-EA11-8438-00155D071F00 Editmode: 1 2020-06-22T22:43:18+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T22:43:18+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-22T22:43:18+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:18+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T22:43:23+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:23+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 2CB11809-B53E-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:43:23+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43: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] = ? ORDER BY [name] ASC 2020-06-22T22:43:27+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:27+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 50ABE226-823B-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:43:27+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43: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-22T22:43:32+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:32+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 15CEA403-8E3F-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:43:32+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43:32+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-22T22:43:36+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:36+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: CBB9DA35-D940-EA11-8438-00155D071F00 Editmode: 2020-06-22T22:43:36+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43: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].[uid] = ? ORDER BY [name] ASC 2020-06-22T22:43:43+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43: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] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-06-22T22:43:54+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:54+02:00 INFO (6): addprojektAction() aufgerufen 2020-06-22T22:43:54+02:00 NOTICE (5): AjaxController - uid: 87F8B511-DE50-EA11-8439-00155D071F00 Editmode: 1 2020-06-22T22:43:54+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-06-22T22:43:54+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-22T22:43:54+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:54+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T22:43:58+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:43:58+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 87F8B511-DE50-EA11-8439-00155D071F00 Editmode: 2020-06-22T22:43:58+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:43:58+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-22T22:44:03+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:44:03+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 8C55B4B4-3152-EA11-8439-00155D071F00 Editmode: 2020-06-22T22:44:03+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:44: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] = ? ORDER BY [name] ASC 2020-06-22T22:44:12+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:44:12+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 4225EF91-4656-EA11-8439-00155D071F00 Editmode: 2020-06-22T22:44:12+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ? 2020-06-22T22:44:12+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-22T22:44:41+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-06-22T22:44:41+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-06-22T22:44:41+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-06-22T22:44:41+02:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-06-22T22:44:41+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