2021-09-29T08:40:11+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T08:40:11+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T08:40:15+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-09-29T08:40:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T08:40:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T08:40:15+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T08:40:15+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T08:48:25+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T08:48:25+02:00 INFO (6): addleistungAction() aufgerufen
2021-09-29T08:48:25+02:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2021-09-29T08:48:25+02:00 INFO (6): LeistungenTable - insertNewRecord
2021-09-29T08:48:25+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2021-09-29T08:48:25+02:00 NOTICE (5): getLastInsertRecord()
2021-09-29T08:48:25+02:00 NOTICE (5): LastID: 130792
2021-09-29T08:48:25+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2021-09-29T08:51:25+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T08:51:25+02:00 INFO (6): addleistungAction() aufgerufen
2021-09-29T08:51:25+02:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2021-09-29T08:51:25+02:00 INFO (6): LeistungenTable - insertNewRecord
2021-09-29T08:51:25+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2021-09-29T08:51:25+02:00 NOTICE (5): getLastInsertRecord()
2021-09-29T08:51:25+02:00 NOTICE (5): LastID: 130793
2021-09-29T08:51:25+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2021-09-29T08:53:22+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T08:53:22+02:00 INFO (6): addleistungAction() aufgerufen
2021-09-29T08:53:22+02:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2021-09-29T08:53:22+02:00 INFO (6): LeistungenTable - insertNewRecord
2021-09-29T08:53:22+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2021-09-29T08:53:22+02:00 NOTICE (5): getLastInsertRecord()
2021-09-29T08:53:22+02:00 NOTICE (5): LastID: 130794
2021-09-29T08:53:22+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2021-09-29T13:08:15+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-09-29T13:08:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:08:15+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:08:15+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:08:15+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T13:08:21+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:08:21+02:00 NOTICE (5): KundenTable - SQL: SELECT [k].*, [b].[vorname] AS [vorname], [b].[nachname] AS [nachname] FROM [kunde] AS [k] INNER JOIN [benutzer] AS [b] ON [k].[angelegt_von] = [b].[uid] WHERE [k].[archiv] = ? ORDER BY [k].[name] ASC
2021-09-29T13:08:26+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:08:26+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2021-09-29T13:08:26+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2021-09-29T13:08:26+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:08:26+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:09:10+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:09:10+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:09:18+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:09:18+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 50431B16-AE79-EA11-843B-00155D071F00 Editmode:
2021-09-29T13:09:18+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ?
2021-09-29T13:09:18+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC
2021-09-29T13:09:41+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:09:41+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:12:20+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:12:20+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:12:20+02:00 NOTICE (5): AjaxController - uid: 59E6193B-3819-EB11-8448-00155D071F00 Editmode: 1
2021-09-29T13:12:20+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ?
2021-09-29T13:12:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC
2021-09-29T13:12:20+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:12:20+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:12:51+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:12:51+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:12:51+02:00 NOTICE (5): AjaxController - uid: 59E6193B-3819-EB11-8448-00155D071F00 Editmode: 0
2021-09-29T13:12:51+02:00 NOTICE (5): ProjektTable - insertNewRecord
2021-09-29T13:12:51+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?)
2021-09-29T13:12:51+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[projektnummer] = ? ORDER BY [name] ASC
2021-09-29T13:12:52+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:12:52+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:13:23+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:13:23+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:13:23+02:00 NOTICE (5): AjaxController - uid: 59E6193B-3819-EB11-8448-00155D071F00 Editmode: 0
2021-09-29T13:13:23+02:00 NOTICE (5): ProjektTable - insertNewRecord
2021-09-29T13:13:23+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?)
2021-09-29T13:13:23+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[projektnummer] = ? ORDER BY [name] ASC
2021-09-29T13:13:23+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:13:23+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:13:54+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:13:54+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:13:54+02:00 NOTICE (5): AjaxController - uid: 59E6193B-3819-EB11-8448-00155D071F00 Editmode: 0
2021-09-29T13:13:54+02:00 NOTICE (5): ProjektTable - insertNewRecord
2021-09-29T13:13:54+02:00 NOTICE (5): ProjektTable - SQL: INSERT INTO [projekt] ([name], [beschreibung], [uid_kunde], [projektnummer], [uid_projektstatus], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?)
2021-09-29T13:13:54+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[projektnummer] = ? ORDER BY [name] ASC
2021-09-29T13:13:54+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:13:54+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:14:24+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:24+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:14:29+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:29+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:14:29+02:00 NOTICE (5): AjaxController - uid: 21681BF6-F969-EB11-844C-00155D071F00 Editmode: 1
2021-09-29T13:14:29+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ?
2021-09-29T13:14:29+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC
2021-09-29T13:14:29+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:29+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:14:35+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:35+02:00 NOTICE (5): AjaxController - archiveprojektAction - uid: 50431B16-AE79-EA11-843B-00155D071F00 Editmode:
2021-09-29T13:14:35+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [archiv] = ? WHERE [uid] = ?
2021-09-29T13:14:36+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC
2021-09-29T13:14:40+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:14:40+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2021-09-29T13:14:40+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2021-09-29T13:14:40+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:40+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:14:59+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:14:59+02:00 NOTICE (5): deleteprojektAction
2021-09-29T13:14:59+02:00 NOTICE (5): deleteData
2021-09-29T13:14:59+02:00 NOTICE (5): ProjekteTable - SQL: DELETE FROM [projekt] WHERE [uid] = ?
2021-09-29T13:15:08+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:15:08+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? AND [p].[archiv] = ? ORDER BY [name] ASC
2021-09-29T13:15:28+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:15:28+02:00 INFO (6): addprojektAction() aufgerufen
2021-09-29T13:15:28+02:00 NOTICE (5): AjaxController - uid: 8C2C931E-7D3B-EA11-8438-00155D071F00 Editmode: 1
2021-09-29T13:15:28+02:00 NOTICE (5): ProjekteTable - SQL: UPDATE [projekt] SET [name] = ?, [beschreibung] = ?, [uid_kunde] = ?, [projektnummer] = ?, [uid_projektstatus] = ?, [stundensatz] = ?, [angelegt_von] = ?, [zeitkontingent] = ? WHERE [uid] = ?
2021-09-29T13:15:28+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].*, [k].[name] AS [kunde], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [s].[name] AS [status], [s].[key] AS [class] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] INNER JOIN [benutzer] AS [b] ON [p].[angelegt_von] = [b].[uid] INNER JOIN [projektstatus] AS [s] ON [p].[uid_projektstatus] = [s].[uid] WHERE [p].[uid] = ? ORDER BY [name] ASC
2021-09-29T13:15:28+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:15:28+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-09-29T13:16:04+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:04+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:04+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:16:04+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T13:16:11+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:11+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:11+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:16:11+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T13:16:38+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:38+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T13:16:38+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-09-29T13:16:38+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T17:06:21+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-09-29T17:06:22+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T17:06:22+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T17:06:22+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T17:06:22+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T17:14:29+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T17:14:29+02:00 INFO (6): addleistungAction() aufgerufen
2021-09-29T17:14:29+02:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2021-09-29T17:14:29+02:00 INFO (6): LeistungenTable - insertNewRecord
2021-09-29T17:14:29+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2021-09-29T17:14:29+02:00 NOTICE (5): getLastInsertRecord()
2021-09-29T17:14:29+02:00 NOTICE (5): LastID: 130795
2021-09-29T17:14:29+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2021-09-29T20:15:49+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-09-29T20:15:49+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:15:49+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:15:49+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T20:15:49+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T20:17:19+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:17:19+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:17:19+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T20:17:19+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T20:17:33+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:17:33+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:17:33+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T20:17:33+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T20:17:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:17:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:19:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:19:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:19:45+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T20:19:45+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2021-09-29T20:20:17+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:20:17+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2021-09-29T20:20:17+02:00 INFO (6): Rollen: array (
  0 => 'user',
)
2021-09-29T20:20:17+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?