Tul xxx Tul

Viewing: delete_delivery.php

<?php
include '../components/connect.php';

session_start();

$admin_id = $_SESSION['admin_id'];

if(!isset($admin_id)){
   header('location:admin_login.php');
   exit();
}

if(isset($_GET['id'])){
   $delete_id = (int)$_GET['id'];
   $redirect = $_GET['redirect'] ?? 'delivery_orders.php';
   $allowed_redirects = ['delivery_orders.php', 'delivery_history.php'];
   if(!in_array($redirect, $allowed_redirects, true)){
      $redirect = 'delivery_orders.php';
   }

   try {
      $conn->beginTransaction();

      $notesKey = 'Pedido domicilio #' . (int)$delete_id;
      $delete_movements = $conn->prepare("DELETE FROM `inventory_movements` WHERE notes = ? AND movement_type = 'out'");
      $delete_movements->execute([$notesKey]);

      $delete_preparers = $conn->prepare("DELETE FROM `delivery_order_preparers` WHERE order_id = ?");
      $delete_preparers->execute([(int)$delete_id]);

      $delete_items = $conn->prepare("DELETE FROM `delivery_order_items` WHERE order_id = ?");
      $delete_items->execute([(int)$delete_id]);
      
      $delete_order = $conn->prepare("DELETE FROM `delivery_orders` WHERE id = ?");
      $delete_order->execute([(int)$delete_id]);

      // Delete associated cash transaction if exists
      $delete_cash = $conn->prepare("DELETE FROM `cash_transactions` WHERE reference_type = 'delivery' AND reference_id = ?");
      $delete_cash->execute([(int)$delete_id]);

      $conn->commit();
   } catch (Throwable $e) {
      if ($conn->inTransaction()) {
         $conn->rollBack();
      }
   }
   
   header('location:' . $redirect);
   exit();
} else {
   header('location:delivery_orders.php');
   exit();
}
?>

User / IP	: 216.73.216.146
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64