2020-11-06T12:05:03+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-06T12:05:03+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T12:05:03+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T12:05:03+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:05:03+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-06T12:05:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:05:08+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-11-06T12:05:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-11-06T12:05:08+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:05:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:06:08+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:06:14+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:14+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:06:14+01:00 NOTICE (5): AjaxController - uid: 82AABE08-D850-EA11-8439-00155D071F00 Editmode: 1 2020-11-06T12:06:14+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:06:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:06:14+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:06:16+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:16+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:06:25+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:25+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:06:25+01:00 NOTICE (5): AjaxController - uid: 7E6D37D4-8D3F-EA11-8438-00155D071F00 Editmode: 1 2020-11-06T12:06:25+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:06:25+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:06:25+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:25+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:06:28+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:28+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:06:37+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:37+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:06:37+01:00 NOTICE (5): AjaxController - uid: 9FBB156E-2789-EA11-843B-00155D071F00 Editmode: 1 2020-11-06T12:06:37+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:06:37+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:06:38+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:38+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:06:43+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:43+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:06:57+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:57+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:06:57+01:00 NOTICE (5): AjaxController - uid: 93A56FFF-B61A-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T12:06:57+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:06:57+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:06:58+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:06:58+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:07:02+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:07:02+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:07:06+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:07:06+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:07:06+01:00 NOTICE (5): AjaxController - uid: 93A56FFF-B61A-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T12:07:06+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:07:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:07:07+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:07:07+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:08:05+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:08:05+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:08:05+01:00 NOTICE (5): AjaxController - uid: 93A56FFF-B61A-EB11-8448-00155D071F00 Editmode: 0 2020-11-06T12:08:05+01:00 NOTICE (5): ProjektTable - insertNewRecord 2020-11-06T12:08:05+01:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von], [stundensatz]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T12:08:05+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[projektnummer] = ? ORDER BY [name] ASC 2020-11-06T12:08:05+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:08:05+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:12:15+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:15+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:12:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:46+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:12:46+01:00 NOTICE (5): AjaxController - uid: 7E6D37D4-8D3F-EA11-8438-00155D071F00 Editmode: 1 2020-11-06T12:12:46+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:12:46+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:12:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:46+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:12:49+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:49+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:12:53+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:53+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:12:53+01:00 NOTICE (5): AjaxController - uid: 82AABE08-D850-EA11-8439-00155D071F00 Editmode: 1 2020-11-06T12:12:53+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:12:53+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:12:53+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:53+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:12:55+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:55+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:12:57+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:57+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:12:57+01:00 NOTICE (5): AjaxController - uid: 9FBB156E-2789-EA11-843B-00155D071F00 Editmode: 1 2020-11-06T12:12:57+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:12:57+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:12:57+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:12:57+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:13:01+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:01+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:13:03+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:03+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:13:03+01:00 NOTICE (5): AjaxController - uid: 93A56FFF-B61A-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T12:13:03+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:13:03+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:13:03+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:03+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:13:05+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:13:08+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:08+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:13:08+01:00 NOTICE (5): AjaxController - uid: 9C2E9257-2020-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T12:13:08+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:13:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:13:08+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:13:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:14:23+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:14:23+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:14:23+01:00 NOTICE (5): AjaxController - uid: 9C2E9257-2020-EB11-8448-00155D071F00 Editmode: 0 2020-11-06T12:14:23+01:00 NOTICE (5): ProjektTable - insertNewRecord 2020-11-06T12:14:23+01:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?) 2020-11-06T12:14:23+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[projektnummer] = ? ORDER BY [name] ASC 2020-11-06T12:14:24+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:14:24+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T12:14:26+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:14:26+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-11-06T12:14:31+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:14:31+01:00 INFO (6): addprojektAction() aufgerufen 2020-11-06T12:14:31+01:00 NOTICE (5): AjaxController - uid: 4AD31039-2120-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T12:14:31+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ? 2020-11-06T12:14:31+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC 2020-11-06T12:14:31+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T12:14:31+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-11-06T14:41:24+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-06T14:41:25+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T14:41:25+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T14:41:25+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T14:41:25+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-06T14:41:57+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T14:41:57+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T14:41:57+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-06T14:41:57+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-06T14:41:57+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T14:41:57+01:00 NOTICE (5): getLastInsertRecord() 2020-11-06T14:41:57+01:00 NOTICE (5): LastID: 70482 2020-11-06T14:41:57+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T17:54:05+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-06T17:54:05+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T17:54:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T17:54:06+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-11-06T17:54:06+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-06T17:54:48+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-11-06T17:54:48+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T17:54:48+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-06T17:54:48+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-06T17:54:48+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T17:54:48+01:00 NOTICE (5): getLastInsertRecord() 2020-11-06T17:54:48+01:00 NOTICE (5): LastID: 70483 2020-11-06T17:54:48+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T17:55:04+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-11-06T17:55:04+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T17:55:04+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-06T17:55:04+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-06T17:55:04+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T17:55:04+01:00 NOTICE (5): getLastInsertRecord() 2020-11-06T17:55:04+01:00 NOTICE (5): LastID: 70484 2020-11-06T17:55:04+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:47:51+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-11-06T18:47:52+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T18:47:52+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC 2020-11-06T18:47:52+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:47:52+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ? 2020-11-06T18:49:52+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:49:52+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T18:49:52+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-06T18:49:52+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-06T18:49:52+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T18:49:52+01:00 NOTICE (5): getLastInsertRecord() 2020-11-06T18:49:52+01:00 NOTICE (5): LastID: 70485 2020-11-06T18:49:52+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:50:31+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:50:31+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T18:50:31+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-11-06T18:50:31+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-11-06T18:50:31+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-11-06T18:50:31+01:00 NOTICE (5): getLastInsertRecord() 2020-11-06T18:50:31+01:00 NOTICE (5): LastID: 70486 2020-11-06T18:50:31+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:50:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:50:46+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:50:51+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:50:51+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T18:50:51+01:00 NOTICE (5): AjaxController - uid: C413F38F-5820-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T18:50:51+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ?, [ist_fakturiert] = ? WHERE [uid] = ? 2020-11-06T18:50:51+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:50:59+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:50:59+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ? 2020-11-06T18:51:03+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-11-06T18:51:03+01:00 INFO (6): addleistungAction() aufgerufen 2020-11-06T18:51:03+01:00 NOTICE (5): AjaxController - uid: C413F38F-5820-EB11-8448-00155D071F00 Editmode: 1 2020-11-06T18:51:03+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ?, [ist_fakturiert] = ? WHERE [uid] = ? 2020-11-06T18:51:03+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ?