2020-11-24T14:59:06+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2020-11-24T14:59:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T14:59:06+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T14:59:06+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T14:59:06+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2020-11-24T15:00:08+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T15:00:08+01:00 INFO (6): addleistungAction() aufgerufen
2020-11-24T15:00:08+01:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2020-11-24T15:00:08+01:00 INFO (6): LeistungenTable - insertNewRecord
2020-11-24T15:00:08+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2020-11-24T15:00:08+01:00 NOTICE (5): getLastInsertRecord()
2020-11-24T15:00:08+01:00 NOTICE (5): LastID: 70512
2020-11-24T15:00: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].[id] = ? AND [l].[ist_fakturiert] = ?
2020-11-24T15:02:23+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T15:02:23+01:00 INFO (6): addleistungAction() aufgerufen
2020-11-24T15:02:23+01:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2020-11-24T15:02:23+01:00 INFO (6): LeistungenTable - insertNewRecord
2020-11-24T15:02:23+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2020-11-24T15:02:23+01:00 NOTICE (5): getLastInsertRecord()
2020-11-24T15:02:23+01:00 NOTICE (5): LastID: 70513
2020-11-24T15:02:23+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2020-11-24T21:00:26+01:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2020-11-24T21:00:27+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:00:27+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:00:27+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:00:27+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2020-11-24T21:00:34+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:00:34+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ?
2020-11-24T21:00:41+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:00:41+01:00 INFO (6): addleistungAction() aufgerufen
2020-11-24T21:00:41+01:00 NOTICE (5): AjaxController - uid: C4A882A7-5D2E-EB11-844A-00155D071F00 Editmode: 1
2020-11-24T21:00:41+01:00 NOTICE (5): LeistungenTable - SQL: UPDATE [leistung] SET [uid_projekt] = ?, [startzeit] = ?, [endzeit] = ?, [datum] = ?, [rechnungstext] = ?, [faktura] = ?, [angelegt_von] = ?, [stundensatz] = ?, [ist_fakturiert] = NULL WHERE [uid] = ?
2020-11-24T21:00:41+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[uid] = ? AND [l].[ist_fakturiert] = ?
2020-11-24T21:00:45+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:00:45+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:00:45+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:00: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].[ist_fakturiert] = ?
2020-11-24T21:02:21+01:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2020-11-24T21:02:21+01:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2020-11-24T21:02:21+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2020-11-24T21:02:21+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:02: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].[archiv] = ? ORDER BY [name] ASC
2020-11-24T21:02:23+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02:23+01:00 NOTICE (5): ProjekteTable - SQL: SELECT [p].[uid] AS [uid], [p].[name] AS [name], [k].[name] AS [kundenname] FROM [projekt] AS [p] INNER JOIN [kunde] AS [k] ON [p].[uid_kunde] = [k].[uid] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02:23+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:02:23+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[ist_fakturiert] = ?
2020-11-24T21:02: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] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02: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] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02:32+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:02: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].[ist_fakturiert] = ?
2020-11-24T21:02: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] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02: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] ORDER BY [k].[name] ASC, [p].[name] ASC
2020-11-24T21:02:38+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:02: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] WHERE [l].[ist_fakturiert] = ?
2020-11-24T21:05:27+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:05:27+01:00 INFO (6): addleistungAction() aufgerufen
2020-11-24T21:05:27+01:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2020-11-24T21:05:27+01:00 INFO (6): LeistungenTable - insertNewRecord
2020-11-24T21:05:27+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2020-11-24T21:05:27+01:00 NOTICE (5): getLastInsertRecord()
2020-11-24T21:05:27+01:00 NOTICE (5): LastID: 70514
2020-11-24T21:05:27+01:00 NOTICE (5): LeistungenTable - SQL: SELECT [l].*, [p].[name] AS [projektname], [p].[projektnummer] AS [projektnummer], [b].[vorname] AS [vorname], [b].[nachname] AS [nachname], [k].[name] AS [kunde] FROM [leistung] AS [l] INNER JOIN [projekt] AS [p] ON [l].[uid_projekt] = [p].[uid] INNER JOIN [benutzer] AS [b] ON [l].[angelegt_von] = [b].[uid] INNER JOIN [kunde] AS [k] ON [k].[uid] = [p].[uid_kunde] WHERE [l].[id] = ? AND [l].[ist_fakturiert] = ?
2020-11-24T21:06:15+01:00 INFO (6): Rollen: array (
  0 => 'user',
)
2020-11-24T21:06:15+01:00 INFO (6): addleistungAction() aufgerufen
2020-11-24T21:06:15+01:00 NOTICE (5): AjaxController - uid:  Editmode: 0
2020-11-24T21:06:15+01:00 INFO (6): LeistungenTable - insertNewRecord
2020-11-24T21:06:15+01:00 NOTICE (5): LeistungenTable - SQL: INSERT INTO [leistung] ([uid_projekt], [startzeit], [endzeit], [datum], [rechnungstext], [faktura], [angelegt_von]) VALUES (?, ?, ?, ?, ?, ?, ?)
2020-11-24T21:06:15+01:00 NOTICE (5): getLastInsertRecord()
2020-11-24T21:06:15+01:00 NOTICE (5): LastID: 70515
2020-11-24T21:06: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].[id] = ? AND [l].[ist_fakturiert] = ?