2021-09-23T08:39: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-23T08:39: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-23T08:39:53+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2021-09-23T08:39:53+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-23T08:39:53+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-23T08:39:53+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:39:53+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-23T08:42:45+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:42:45+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:42:45+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T08:42:45+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T08:42:45+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T08:42:45+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T08:42:46+02:00 NOTICE (5): LastID: 130770 2021-09-23T08:42:46+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-23T08:43:05+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:43:05+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:43:05+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T08:43:05+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T08:43:05+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T08:43:05+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T08:43:05+02:00 NOTICE (5): LastID: 130771 2021-09-23T08:43:05+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-23T08:45:01+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:45:01+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:45:01+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T08:45:01+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T08:45:01+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T08:45:01+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T08:45:01+02:00 NOTICE (5): LastID: 130772 2021-09-23T08:45:01+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:49:15+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:49:15+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:49:15+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T08:49:15+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T08:49:15+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T08:49:15+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T08:49:15+02:00 NOTICE (5): LastID: 130773 2021-09-23T08:49:15+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:50:10+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:50:10+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].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:50:18+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:50:18+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:50:18+02:00 NOTICE (5): AjaxController - uid: E48EBD5D-3A1C-EC11-841C-00155D071F00 Editmode: 1 2021-09-23T08:50:18+02:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = NULL, [ist_fakturiert] = ? WHERE [uid] = ? 2021-09-23T08:50:18+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].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:51:21+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:51:21+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].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:51:26+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:51:26+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:51:26+02:00 NOTICE (5): AjaxController - uid: 6844F680-391C-EC11-841C-00155D071F00 Editmode: 1 2021-09-23T08:51:26+02:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = NULL, [ist_fakturiert] = ? WHERE [uid] = ? 2021-09-23T08:51:26+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:51:32+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:51:32+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:51:38+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:51:38+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:51:38+02:00 NOTICE (5): AjaxController - uid: C8B86275-391C-EC11-841C-00155D071F00 Editmode: 1 2021-09-23T08:51:38+02:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = NULL, [ist_fakturiert] = ? WHERE [uid] = ? 2021-09-23T08:51: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].[uid] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T08:52:26+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T08:52:26+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T08:52:26+02:00 NOTICE (5): AjaxController - uid: C8B86275-391C-EC11-841C-00155D071F00 Editmode: 0 2021-09-23T08:52:26+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T08:52:26+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T08:52:26+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T08:52:26+02:00 NOTICE (5): LastID: 130774 2021-09-23T08:52:26+02:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ? 2021-09-23T10:49:13+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2021-09-23T10:49:13+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-23T10:49:13+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-23T10:49:13+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T10:49:13+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-23T10:49:47+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T10:49:47+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T10:49:47+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T10:49:47+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T10:49:47+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T10:49:47+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T10:49:47+02:00 NOTICE (5): LastID: 130775 2021-09-23T10:49:47+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-23T14:49: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-23T14:49: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-23T14:49:23+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ? 2021-09-23T14:49:23+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-23T14:49:23+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-23T14:49:23+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T14:49:23+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-23T14:50:24+02:00 INFO (6): Rollen: array ( 0 => 'user', ) 2021-09-23T14:50:24+02:00 INFO (6): addleistungAction() aufgerufen 2021-09-23T14:50:24+02:00 NOTICE (5): AjaxController - uid: Editmode: 0 2021-09-23T14:50:24+02:00 INFO (6): LeistungenTable - insertNewRecord 2021-09-23T14:50:24+02:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?) 2021-09-23T14:50:24+02:00 NOTICE (5): getLastInsertRecord() 2021-09-23T14:50:24+02:00 NOTICE (5): LastID: 130776 2021-09-23T14:50:24+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] = ?