2021-06-09T10:59:07+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-06-09T10:59:07+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-06-09T10:59:07+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-06-09T10:59:07+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T10:59:07+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-06-09T10:59:10+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T10:59:10+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-06-09T10:59:18+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T10:59:18+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: AE7BA2CF-6FAA-EB11-8455-00155D071F00 Editmode:
2021-06-09T10:59:18+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T10:59:18+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T10:59:52+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T10:59:52+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: AF22F17A-AF8C-EB11-8455-00155D071F00 Editmode:
2021-06-09T10:59:52+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T10:59:52+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T10:59:59+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T10:59:59+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 7815E67A-AE8C-EB11-8455-00155D071F00 Editmode:
2021-06-09T10:59:59+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T10:59:59+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:00:09+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:00:09+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 528805AB-D9F4-EA11-8448-00155D071F00 Editmode:
2021-06-09T11:00:09+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:00:09+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:00:12+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:00:12+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 003503C4-C8B4-EA11-8440-00155D071F00 Editmode:
2021-06-09T11:00:12+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:00:12+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:00:49+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:00:49+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 5DDD1274-0578-405C-844D-CC1631D8F212 Editmode:
2021-06-09T11:00:49+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:00:49+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:00:53+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:00:53+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 28DED3BD-5ECA-EA11-8440-00155D071F00 Editmode:
2021-06-09T11:00:53+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:00:53+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:00:56+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:00:56+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 4BA7DB47-C8B4-EA11-8440-00155D071F00 Editmode:
2021-06-09T11:00:56+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:00:56+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:01:06+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:01:06+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: 028F71F3-8834-4898-9240-33C584BDF815 Editmode:
2021-06-09T11:01:06+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:01:06+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:01:15+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:01:15+02:00 NOTICE (5): AjaxController - archivekundeAction - uid: FDE31F37-ECBA-4072-8F76-687037BA0D6D Editmode:
2021-06-09T11:01:15+02:00 NOTICE (5): KundenTable - SQL: UPDATE [kunde] SET [archiv] = ? WHERE [uid] = ?
2021-06-09T11:01:15+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].[kundennummer] = ? ORDER BY [k].[name] ASC
2021-06-09T11:01:23+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:01:23+02:00 NOTICE (5): deletekundeAction
2021-06-09T11:01:23+02:00 NOTICE (5): deleteData
2021-06-09T11:01:23+02:00 NOTICE (5): KundenTable - SQL: DELETE FROM [kunde] WHERE [uid] = ?
2021-06-09T11:01:28+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:01:28+02:00 NOTICE (5): deletekundeAction
2021-06-09T11:01:28+02:00 NOTICE (5): deleteData
2021-06-09T11:01:28+02:00 NOTICE (5): KundenTable - SQL: DELETE FROM [kunde] WHERE [uid] = ?
2021-06-09T11:01:34+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:01:34+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-06-09T11:02:28+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-06-09T11:02:28+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2021-06-09T11:02:28+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2021-06-09T11:02:28+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:02: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].[archiv] = ? ORDER BY [name] ASC
2021-06-09T11:35:44+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-06-09T11:35:45+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2021-06-09T11:35:45+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2021-06-09T11:35:45+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T11:35:45+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-06-09T16:59:23+02:00 NOTICE (5): BenutzerTable - SQL: SELECT [benutzer].* FROM [benutzer] WHERE [username] = ?
2021-06-09T16:59: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-06-09T16:59: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-06-09T16:59:23+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T16:59: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-06-09T16:59:46+02:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS [lastnummer] FROM [projekt]
2021-06-09T16:59:46+02:00 NOTICE (5): KundenTable - SQL: SELECT [kunde].[uid] AS [uid], [kunde].[name] AS [name] FROM [kunde] ORDER BY [name] ASC
2021-06-09T16:59:46+02:00 NOTICE (5): ProjekteTable - SQL: SELECT [projektstatus].[uid] AS [uid], [projektstatus].[name] AS [name] FROM [projektstatus] ORDER BY [key] ASC
2021-06-09T16:59:46+02:00 INFO (6): Rollen: array (
  0 => 'user',
  1 => 'admin',
  2 => 'superadmin',
)
2021-06-09T16:59:46+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