From b75700ee1bf4bc07f1da7899aac864cb561022f4 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sun, 7 Dec 2014 17:48:35 +0100 Subject: add shift delete model --- includes/pages/admin_import.php | 7 +++++-- includes/pages/user_shifts.php | 5 +++-- 2 files changed, 8 insertions(+), 4 deletions(-) (limited to 'includes/pages') diff --git a/includes/pages/admin_import.php b/includes/pages/admin_import.php index f4c2b252..120ab91b 100644 --- a/includes/pages/admin_import.php +++ b/includes/pages/admin_import.php @@ -129,8 +129,11 @@ function admin_import() { engelsystem_error('Unable to update shift.'); } - foreach ($events_deleted as $event) - sql_query("DELETE FROM `Shifts` WHERE `PSID`=" . sql_escape($event['PSID']) . " LIMIT 1"); + foreach ($events_deleted as $event) { + $result = Shift_delete_by_psid($event['PSID']); + if ($result === false) + engelsystem_error('Unable to delete shift.'); + } engelsystem_log("Pentabarf import done"); diff --git a/includes/pages/user_shifts.php b/includes/pages/user_shifts.php index 2f0bee6e..c1a5cc91 100644 --- a/includes/pages/user_shifts.php +++ b/includes/pages/user_shifts.php @@ -178,8 +178,9 @@ function user_shifts() { // Schicht löschen bestätigt if (isset($_REQUEST['delete'])) { - sql_query("DELETE FROM `NeededAngelTypes` WHERE `shift_id`=" . sql_escape($shift_id)); - sql_query("DELETE FROM `Shifts` WHERE `SID`=" . sql_escape($shift_id) . " LIMIT 1"); + $result = Shift_delete($shift_id); + if ($result === false) + engelsystem_error('Unable to delete shift.'); engelsystem_log("Deleted shift " . $shift['name'] . " from " . date("y-m-d H:i", $shift['start']) . " to " . date("y-m-d H:i", $shift['end'])); success(_("Shift deleted.")); -- cgit v1.2.3-70-g09d2