2020-03-14T17:36:46+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T17:36:46+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] 2020-03-14T17:36:46+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] 2020-03-14T17:36:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T17:36: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] 2020-03-14T17:36:50+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T17:36:50+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] 2020-03-14T17:36:53+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T17:36:53+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T17:36:59+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T17:36:59+01:00 INFO (6): addbenutzerAction() aufgerufen 2020-03-14T17:36:59+01:00 NOTICE (5): AjaxController - uid: 82B39FAB-3B3D-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:36:59+01:00 NOTICE (5): BenutzerTable - SQL: UPDATE [benutzer] SET [username] = ?, [email] = ?, [vorname] = ?, [nachname] = ?, [aktiv] = ?, [passwort] = ?, [roles] = ? WHERE [uid] = ? 2020-03-14T17:36:59+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T17:37:03+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T17:37: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] 2020-03-14T17:37: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] 2020-03-14T17:37:03+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:37: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] 2020-03-14T17:37:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:37:06+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:37:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:37:06+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:37: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T17:39:02+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:39:02+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:39:02+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:39:02+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:39: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T17:39:59+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:39:59+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:39:59+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:39:59+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:39:59+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-03-14T17:40:40+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:40:40+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:40:40+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:40:40+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:40:40+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-03-14T17:41:12+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:41:12+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:41:12+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:41:12+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:41:12+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-03-14T17:43:06+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:43: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-03-14T17:43:09+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:43:09+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:43:09+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:43:09+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:43:09+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:43:27+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:43:27+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:43:27+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:43:27+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:43:27+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:43:42+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:43:42+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:43:42+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 0 2020-03-14T17:43:42+01:00 NOTICE (5): ProjektTable - insertNewRecord 2020-03-14T17:43:42+01:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von], [stundensatz]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-03-14T17:43:42+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:48:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T17:48:14+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T17:48:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T17:48:14+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:48: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T17:48:21+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:48:21+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-03-14T17:48:26+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:48:26+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:48:26+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:48:26+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:48:26+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:48:27+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:48:27+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:48:27+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:48:27+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:48:27+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:48:54+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:48:54+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:48:54+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:48:54+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:48:54+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:49:01+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:49:01+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:49:01+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:49:01+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:49:01+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:49:07+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:49:07+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:49:07+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:49:07+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:49:07+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T17:49:44+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T17:49:44+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T17:49:44+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T17:49:44+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T17:49:44+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T18:07:40+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:07:40+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:07:40+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:07:40+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:07:40+01:00 ERR (3): ProjektTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T18:11:21+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:21+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:11:21+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:11:21+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:11:21+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-03-14T18:11:21+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:21+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:11:24+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:24+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-03-14T18:11:30+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:30+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:11:30+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:11:30+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:11:30+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-03-14T18:11:31+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:31+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:11:34+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:34+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-03-14T18:11:40+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:11:40+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC 2020-03-14T18:12:54+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:12:54+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC 2020-03-14T18:12:57+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:12:57+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:12:57+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:12:57+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T18:13:04+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13:04+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-03-14T18:13:09+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13:09+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:13:09+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:13:09+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:13:09+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-03-14T18:13:09+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13:09+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:13:11+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13:11+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-03-14T18:13:15+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:13:15+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:13:15+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:13:15+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T18:13:19+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:13:19+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-03-14T18:15:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:15:08+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:15:08+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:15:08+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15: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-03-14T18:15:12+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:12+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-03-14T18:15:16+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:16+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:15:16+01:00 NOTICE (5): AjaxController - uid: E9A15408-753B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:15:16+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:15: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] = ? ORDER BY [name] ASC 2020-03-14T18:15:16+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:16+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:15:19+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:19+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-03-14T18:15:22+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:22+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-03-14T18:15:26+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15: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-03-14T18:15:50+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:15:50+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-03-14T18:16:18+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:16:18+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:16:18+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:16:18+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:16:18+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-03-14T18:16:20+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:16:20+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-03-14T18:25:32+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] 2020-03-14T18:25:32+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] 2020-03-14T18:25:32+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:25:32+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] 2020-03-14T18:25:35+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:25:35+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] = ? 2020-03-14T18:25:45+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:25:45+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:25:45+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:25:45+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:25:45+01:00 ERR (3): LeistungenTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T18:25:47+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:25:47+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:25:47+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:25:47+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:25:47+01:00 ERR (3): LeistungenTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T18:25:47+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:25:47+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:25:47+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:25:47+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:25:47+01:00 ERR (3): LeistungenTable - Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'stundensatz'. 2020-03-14T18:27:32+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:32+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] = ? 2020-03-14T18:27:33+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:33+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:27:33+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:27:33+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:27:33+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] = ? 2020-03-14T18:27:35+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:35+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] = ? 2020-03-14T18:27:39+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:39+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] = ? 2020-03-14T18:27:42+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] 2020-03-14T18:27:42+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] 2020-03-14T18:27:42+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:42+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] 2020-03-14T18:27:44+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:44+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] = ? 2020-03-14T18:27:48+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:48+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:27:48+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:27:48+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:27: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].[uid] = ? 2020-03-14T18:27:50+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:50+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] = ? 2020-03-14T18:27:53+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] 2020-03-14T18:27:53+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] 2020-03-14T18:27:53+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:27:53+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] 2020-03-14T18:28:15+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:28:15+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] = ? 2020-03-14T18:28:56+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:28:56+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] = ? 2020-03-14T18:29:57+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:29: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].[uid] = ? 2020-03-14T18:30:20+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:30:20+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] = ? 2020-03-14T18:31:37+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] 2020-03-14T18:31:38+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] 2020-03-14T18:31:38+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:31:38+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] 2020-03-14T18:32:11+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32:12+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] = ? 2020-03-14T18:32:16+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32:16+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:32:16+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:32:16+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:32:16+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] = ? 2020-03-14T18:32:17+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32:17+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] = ? 2020-03-14T18:32:20+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32:20+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:32:20+01:00 NOTICE (5): AjaxController - uid: D548AC42-D445-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:32:20+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:32:20+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] = ? 2020-03-14T18:32:22+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32:22+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] = ? 2020-03-14T18:32:25+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:32: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].[uid] = ? 2020-03-14T18:43:56+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:43:56+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:43:56+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:43:56+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:43:56+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-03-14T18:44:07+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:44:07+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-03-14T18:44:11+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:44:11+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:44:11+01:00 NOTICE (5): AjaxController - uid: ACD201D3-803B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:44:11+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:44:11+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-03-14T18:44:12+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:44:12+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:48:28+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] 2020-03-14T18:48:28+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] 2020-03-14T18:48:28+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:48:28+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] 2020-03-14T18:48:42+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:48:42+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] = ? 2020-03-14T18:48:45+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:48:45+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:48:45+01:00 NOTICE (5): AjaxController - uid: 08895E6F-913B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:48:45+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:48:45+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] = ? 2020-03-14T18:48:47+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:48:47+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? 2020-03-14T18:48:53+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:48:53+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:48:53+01:00 NOTICE (5): AjaxController - uid: 08895E6F-913B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:48:53+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:48:53+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] = ? 2020-03-14T18:49:05+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:05+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] = ? 2020-03-14T18:49:08+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:08+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:49:08+01:00 NOTICE (5): AjaxController - uid: 08895E6F-913B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:49:08+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:49:08+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] = ? 2020-03-14T18:49:39+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:49:39+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:49:39+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:49:39+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:39+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-03-14T18:49:52+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:52+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-03-14T18:49:55+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:55+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:49:55+01:00 NOTICE (5): AjaxController - uid: ACD201D3-803B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:49:55+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:49: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] = ? ORDER BY [name] ASC 2020-03-14T18:49:55+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:49:55+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:53:50+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:53:50+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-03-14T18:53:58+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:53:58+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:53:58+01:00 NOTICE (5): AjaxController - uid: ACD201D3-803B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:53:58+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:53:58+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-03-14T18:53:58+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:53:58+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:54:00+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:00+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC 2020-03-14T18:54:08+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:08+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[uid] = ? ORDER BY [k].[name] ASC 2020-03-14T18:54:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:54:14+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T18:54:14+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T18:54:14+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T18:54:23+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54: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].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC 2020-03-14T18:54:26+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:26+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T18:54:26+01:00 NOTICE (5): AjaxController - uid: ACD201D3-803B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:54:26+01:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ? WHERE [uid] = ? 2020-03-14T18:54: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] = ? ORDER BY [name] ASC 2020-03-14T18:54:26+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:26+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T18:54:38+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] 2020-03-14T18:54:38+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] 2020-03-14T18:54:38+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:38+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] 2020-03-14T18:54:42+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:42+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] = ? 2020-03-14T18:54:44+01:00 INFO (6): Rollen: array ( 0 => 'user', ) 2020-03-14T18:54:44+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T18:54:44+01:00 NOTICE (5): AjaxController - uid: 08895E6F-913B-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T18:54:44+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ? WHERE [uid] = ? 2020-03-14T18:54:44+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] = ? 2020-03-14T19:25:55+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T19:25:56+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] 2020-03-14T19:25:56+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] 2020-03-14T19:25:56+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:25:56+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] 2020-03-14T19:26:25+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:26:25+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:26:56+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:26:56+01:00 INFO (6): addbenutzerAction() aufgerufen 2020-03-14T19:26:56+01:00 NOTICE (5): AjaxController - uid: DD94FD72-F12E-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T19:26:56+01:00 NOTICE (5): BenutzerTable - SQL: UPDATE [benutzer] SET [username] = ?, [email] = ?, [vorname] = ?, [nachname] = ? WHERE [uid] = ? 2020-03-14T19:26:56+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:27:02+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:27:02+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:28:17+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T19:28:17+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] 2020-03-14T19:28:17+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] 2020-03-14T19:28:17+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:28:17+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] 2020-03-14T19:28:23+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:28:23+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:28:34+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:28:34+01:00 INFO (6): addbenutzerAction() aufgerufen 2020-03-14T19:28:34+01:00 NOTICE (5): AjaxController - uid: DD94FD72-F12E-EA11-8438-00155D071F00 Editmode: 1 2020-03-14T19:28:34+01:00 NOTICE (5): BenutzerTable - SQL: UPDATE [benutzer] SET [username] = ?, [email] = ?, [vorname] = ?, [nachname] = ? WHERE [uid] = ? 2020-03-14T19:28:34+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:28:37+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:28:37+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:28:57+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:28:57+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:28:57+01:00 NOTICE (5): BenutzerTable - SQL: UPDATE [benutzer] SET [passwort] = ? WHERE [uid] = ? 2020-03-14T19:28:57+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:29:11+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T19:29:11+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] 2020-03-14T19:29:11+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] 2020-03-14T19:29:11+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:29:11+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] 2020-03-14T19:29:17+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:29:17+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[uid] = ? 2020-03-14T19:30:21+01:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-03-14T19:30:30+01:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-03-14T19:30:30+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[username] = ? 2020-03-14T19:31:04+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2020-03-14T19:31:04+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] 2020-03-14T19:31:04+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] 2020-03-14T19:31:04+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:31: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] 2020-03-14T19:32:02+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32:02+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T19:32:02+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-03-14T19:32:02+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-03-14T19:32:02+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-03-14T19:32:02+01:00 NOTICE (5): getLastInsertRecord() 2020-03-14T19:32:02+01:00 NOTICE (5): LastID: 10208 2020-03-14T19:32:02+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] = ? 2020-03-14T19:32:29+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32:29+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC 2020-03-14T19:32:43+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32:43+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-03-14T19:32:43+01:00 NOTICE (5): KundenTable - insertNewRecord 2020-03-14T19:32:43+01:00 NOTICE (5): KundenTable - SQL: INSERT INTO [kunde] ([kundennummer], [name], [strasse], [ort], [plz], [telefon], [beschreibung], [angelegt_von], [stundensatz]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 2020-03-14T19:32:43+01:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[kundennummer] = ? ORDER BY [k].[name] ASC 2020-03-14T19:32:46+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T19:32:46+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC 2020-03-14T19:32:46+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC 2020-03-14T19:32:46+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32: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].[archiv] = ? ORDER BY [name] ASC 2020-03-14T19:32:59+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32:59+01:00 INFO (6): addprojektAction() aufgerufen 2020-03-14T19:32:59+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-03-14T19:32:59+01:00 NOTICE (5): ProjektTable - insertNewRecord 2020-03-14T19:32:59+01:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von], [stundensatz]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-03-14T19:32:59+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-03-14T19:32:59+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:32:59+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt] 2020-03-14T19:33:11+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:33:11+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-03-14T19:33:18+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] 2020-03-14T19:33:18+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] 2020-03-14T19:33:18+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:33:18+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] 2020-03-14T19:33:35+01:00 INFO (6): Rollen: array ( 0 => 'user', 1 => 'admin', 2 => 'superadmin', ) 2020-03-14T19:33:35+01:00 INFO (6): addleistungAction() aufgerufen 2020-03-14T19:33:35+01:00 NOTICE (5): AjaxController - uid: Editmode: 0 2020-03-14T19:33:35+01:00 INFO (6): LeistungenTable - insertNewRecord 2020-03-14T19:33:35+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2020-03-14T19:33:35+01:00 NOTICE (5): getLastInsertRecord() 2020-03-14T19:33:35+01:00 NOTICE (5): LastID: 10209 2020-03-14T19:33:35+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] = ? 2020-03-14T19:35:33+01:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-03-14T19:35:37+01:00 INFO (6): Rollen: array ( 0 => 'guest', ) 2020-03-14T19:35:37+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [b].* FROM [benutzer] AS [b] WHERE [b].[username] = ?