Tul xxx Tul

Viewing: delivery_orders.php

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

session_start();

$admin_id = $_SESSION['admin_id'];

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

date_default_timezone_set('America/Bogota');

$today = new DateTime('today');
$tomorrow = (clone $today)->modify('+1 day');
$today_start = $today->format('Y-m-d H:i:s');
$tomorrow_start = $tomorrow->format('Y-m-d H:i:s');

// Obtener fechas de filtro
$fecha_desde = isset($_GET['fecha_desde']) ? $_GET['fecha_desde'] : $today->format('Y-m-01');
$fecha_hasta = isset($_GET['fecha_hasta']) ? $_GET['fecha_hasta'] : $today->format('Y-m-d');
if($fecha_desde > $fecha_hasta){
   $fecha_desde = $fecha_hasta;
}

// Obtener estadísticas del día
$select_stats_today = $conn->prepare("SELECT COUNT(*) as total_pedidos, COALESCE(SUM(total_amount), 0) as total_recaudado FROM `delivery_orders` WHERE created_at >= ? AND created_at < ?");
$select_stats_today->execute([$today_start, $tomorrow_start]);
$stats_today = $select_stats_today->fetch(PDO::FETCH_ASSOC) ?: ['total_pedidos' => 0, 'total_recaudado' => 0];

// Obtener estadísticas del rango de fechas
$select_stats_range = $conn->prepare("SELECT COUNT(*) as total_pedidos, COALESCE(SUM(total_amount), 0) as total_recaudado FROM `delivery_orders` WHERE DATE(created_at) BETWEEN ? AND ?");
$select_stats_range->execute([$fecha_desde, $fecha_hasta]);
$stats_range = $select_stats_range->fetch(PDO::FETCH_ASSOC);

// Obtener SOLO pedidos de HOY para esta vista (según fecha del servidor MySQL)
$select_orders = $conn->prepare("SELECT * FROM `delivery_orders` WHERE created_at >= ? AND created_at < ? ORDER BY created_at ASC");
$select_orders->execute([$today_start, $tomorrow_start]);
$orders = $select_orders->fetchAll(PDO::FETCH_ASSOC);

// Obtener categorías y productos
$select_categories = $conn->prepare("SELECT * FROM `categories` ORDER BY name ASC");
$select_categories->execute();
$categorias = $select_categories->fetchAll(PDO::FETCH_ASSOC);

$select_products = $conn->prepare("SELECT p.*, c.name as category_name FROM `products` p LEFT JOIN `categories` c ON p.category = c.id ORDER BY c.name, p.name");
$select_products->execute();
$productos = $select_products->fetchAll(PDO::FETCH_ASSOC);

function normaliza_categoria($str){
   $str = mb_strtolower($str, 'UTF-8');
   $map = ['á'=>'a','à'=>'a','ä'=>'a','â'=>'a','Á'=>'a','À'=>'a','Â'=>'a','Ä'=>'a','é'=>'e','è'=>'e','ë'=>'e','ê'=>'e','É'=>'e','È'=>'e','Ê'=>'e','Ë'=>'e','í'=>'i','ì'=>'i','ï'=>'i','î'=>'i','Í'=>'i','Ì'=>'i','Î'=>'i','Ï'=>'i','ó'=>'o','ò'=>'o','ö'=>'o','ô'=>'o','Ó'=>'o','Ò'=>'o','Ô'=>'o','Ö'=>'o','ú'=>'u','ù'=>'u','ü'=>'u','û'=>'u','Ú'=>'u','Ù'=>'u','Û'=>'u','Ü'=>'u','ñ'=>'n','Ñ'=>'n','ç'=>'c','Ç'=>'c'];
   $str = strtr($str, $map);
   $str = preg_replace('/[^a-z0-9]+/','-',$str);
   $str = trim($str,'-');
   return $str;
}

?>

<!DOCTYPE html>
<html lang="es">
<head>
   <meta charset="UTF-8">
   <meta http-equiv="X-UA-Compatible" content="IE=edge">
   <meta name="viewport" content="width=device-width, initial-scale=1.0">
   <title>Pedidos a Domicilio | DONDEEDY</title>
   <link rel="icon" href="../images/favicon.png" type="image/png">
   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css">
   <link rel="stylesheet" href="../css/admin_style.css">
   <style>
   :root {
      --color-primary: #b30000;
      --color-success: #28a745;
      --color-warning: #ffc107;
      --color-info: #17a2b8;
      --color-danger: #dc3545;
   }

   .stats-container {
      display: grid;
      grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
      gap: 1.5rem;
      margin-bottom: 2.5rem;
      animation: fadeInUp 0.5s ease;
   }

   .stat-card {
      background: linear-gradient(135deg, rgba(255,255,255,0.95) 0%, rgba(255,255,255,0.85) 100%);
      backdrop-filter: blur(10px);
      border-radius: 18px;
      padding: 1.15rem 1.2rem;
      box-shadow: 0 8px 22px rgba(0,0,0,0.1);
      display: flex;
      flex-direction: column;
      gap: 0.6rem;
      transition: transform 0.25s ease, box-shadow 0.25s ease;
      border: 1px solid rgba(255,255,255,0.28);
      position: relative;
      overflow: hidden;
   }

   .stat-card:hover {
      transform: translateY(-3px);
      box-shadow: 0 12px 28px rgba(0,0,0,0.14);
   }

   .stat-card.today {
      background: #ffffff;
      color: #111;
      border: 1px solid rgba(0,0,0,0.08);
      box-shadow: 0 12px 30px rgba(0,0,0,0.1);
   }

   .stat-card.range {
      background: linear-gradient(135deg, #116f80 0%, #17a2b8 100%);
      color: white;
   }

   .stat-card .stat-header {
      display: flex;
      justify-content: space-between;
      align-items: center;
      gap: 1rem;
   }

   .stat-card .stat-icon {
      font-size: 2.4rem;
      opacity: 0.9;
   }

   .stat-card .stat-label {
      font-size: 1.05rem;
      font-weight: 600;
      opacity: 0.95;
   }

   .stat-card .stat-content {
      display: flex;
      gap: 1.2rem;
      align-items: stretch;
      margin-top: 0.4rem;
   }

   .stat-card .stat-left {
      flex: 1;
      display: flex;
      flex-direction: column;
      gap: 0.45rem;
   }

   .stat-card .stat-value {
      font-size: 2rem;
      font-weight: 800;
      margin: 0.1rem 0;
   }

   .stat-card .stat-sublabel {
      font-size: 0.95rem;
      opacity: 0.85;
   }

   .stat-card .stat-right {
      min-width: 160px;
      background: rgba(255,255,255,0.12);
      border-radius: 14px;
      padding: 0.9rem 1rem;
      display: flex;
      flex-direction: column;
      justify-content: center;
      gap: 0.3rem;
      text-align: right;
      box-shadow: inset 0 0 18px rgba(255,255,255,0.12);
   }

   .stat-card.today .stat-right {
      background: #f8f9fa;
      border: 1px solid rgba(0,0,0,0.06);
      box-shadow: none;
   }

   .stat-card.today .stat-label {
      color: #1e4f3a;
      font-weight: 700;
   }

   .stat-card.today .stat-right-label {
      color: #475a52;
      opacity: 0.85;
   }

   .stat-card.today .stat-right-amount {
      color: #1e7e34;
   }

   .stat-card.range .stat-right {
      background: rgba(255,255,255,0.16);
   }

   .stat-card .stat-right-label {
      font-size: 0.85rem;
      text-transform: uppercase;
      letter-spacing: 1px;
      opacity: 0.78;
      font-weight: 700;
   }

   .stat-card .stat-right-amount {
      font-size: 1.45rem;
      font-weight: 900;
      line-height: 1.1;
   }

   .actions-buttons {
      display: flex;
      gap: 1.2rem;
      flex-wrap: wrap;
      justify-content: center;
      align-items: center;
   }

   .filters-section {
      background: rgba(255,255,255,0.95);
      backdrop-filter: blur(10px);
      border-radius: 20px;
      padding: 2rem;
      margin-bottom: 3rem;
      box-shadow: 0 10px 30px rgba(0,0,0,0.1);
   }

   .filters-form {
      display: flex;
      gap: 1.2rem;
      align-items: end;
      flex-wrap: wrap;
   }

   .filter-group {
      flex: 1;
      min-width: 200px;
      display: flex;
      flex-direction: column;
      gap: 0.5rem;
   }

   .filter-group label {
      font-weight: 600;
      color: #111;
      font-size: 1.1rem;
   }

   .filter-group input {
      padding: 1rem;
      border: 2px solid #e0e0e0;
      border-radius: 10px;
      font-size: 1.1rem;
      transition: border-color 0.3s ease;
   }

   .filter-group input:focus {
      outline: none;
      border-color: var(--color-primary);
   }

   .filters-actions {
      display: flex;
      gap: 0.9rem;
      align-items: center;
      flex-wrap: wrap;
   }

   .btn-filter,
   .btn-reset,
   .btn-add-inline,
   .btn-history {
      padding: 1.25rem 2.6rem;
      border: none;
      border-radius: 10px;
      font-weight: 800;
      letter-spacing: 0.4px;
      display: inline-flex;
      align-items: center;
      gap: 0.6rem;
      cursor: pointer;
      transition: transform 0.2s ease, box-shadow 0.2s ease;
      justify-content: center;
      font-size: 1.1rem;
   }

   .btn-filter {
      background: linear-gradient(135deg, var(--color-primary) 0%, #7a0000 100%);
      color: white;
   }

   .btn-reset {
      background: #ffffff;
      color: var(--color-primary);
      border: 1px solid rgba(179,0,0,0.25);
   }

   .btn-filter:hover,
   .btn-reset:hover,
   .btn-add-inline:hover,
   .btn-history:hover {
      transform: translateY(-2px);
      box-shadow: 0 5px 15px rgba(0,0,0,0.15);
   }

   .btn-add-inline {
      background: linear-gradient(135deg, var(--color-success) 0%, #1e7e34 100%);
      color: #fff;
   }

   .btn-history {
      background: linear-gradient(135deg, var(--color-info) 0%, #117a8b 100%);
      color: #fff;
      text-decoration: none;
   }

   .orders-container {
      display: grid;
      grid-template-columns: repeat(auto-fill, minmax(350px, 1fr));
      gap: 2rem;
      margin-bottom: 3rem;
   }
   .orders-container.orders-empty {
      display: flex;
      justify-content: center;
      align-items: center;
      min-height: 45vh;
   }

   .order-card {
      background: rgba(255,255,255,0.95);
      backdrop-filter: blur(10px);
      border-radius: 20px;
      padding: 1.5rem;
      box-shadow: 0 10px 30px rgba(0,0,0,0.1);
      transition: transform 0.3s ease, box-shadow 0.3s ease;
      border: 1px solid rgba(0,0,0,0.05);
      position: relative;
      overflow: hidden;
   }

   .order-card:hover {
      transform: translateY(-5px);
      box-shadow: 0 15px 40px rgba(0,0,0,0.15);
   }

   .order-status {
      position: absolute;
      top: 0;
      right: 0;
      padding: 0.5rem 1rem;
      border-radius: 0 20px 0 20px;
      font-weight: 600;
      font-size: 0.85rem;
      text-transform: uppercase;
   }

   .order-status.pendiente {
      background: var(--color-warning);
      color: #333;
   }

   .order-status.en_preparacion {
      background: var(--color-info);
      color: white;
   }

   .order-status.en_camino {
      background: #6f42c1;
      color: white;
   }

   .order-status.entregado {
      background: var(--color-success);
      color: white;
   }

   .order-status.cancelado {
      background: var(--color-danger);
      color: white;
   }

   .order-header {
      margin-bottom: 1rem;
      padding-bottom: 1rem;
      border-bottom: 2px solid #f0f0f0;
   }

   .order-number {
      font-size: 1.2rem;
      font-weight: 800;
      color: var(--color-primary);
      margin-bottom: 0.5rem;
   }

   .order-datetime {
      font-size: 0.9rem;
      color: #666;
      display: flex;
      align-items: center;
      gap: 0.5rem;
   }

   .customer-info {
      margin-bottom: 1rem;
   }

   .customer-name {
      font-weight: 700;
      font-size: 1.1rem;
      margin-bottom: 0.5rem;
      color: #333;
   }

   .customer-detail {
      display: flex;
      align-items: center;
      gap: 0.5rem;
      margin-bottom: 0.3rem;
      color: #666;
      font-size: 0.95rem;
   }

   .order-items {
      background: #f8f9fa;
      border-radius: 10px;
      padding: 1rem;
      margin-bottom: 1rem;
   }

   .order-items-title {
      font-weight: 600;
      margin-bottom: 0.5rem;
      color: #333;
   }

   .order-item {
      display: flex;
      justify-content: space-between;
      margin-bottom: 0.3rem;
      padding: 0.3rem 0;
      border-bottom: 1px solid #e0e0e0;
      font-size: 0.9rem;
   }

   .order-item:last-child {
      border-bottom: none;
   }

   .order-total {
      background: #f5f5f5;
      color: #222;
      padding: 1rem;
      border-radius: 10px;
      display: flex;
      justify-content: space-between;
      align-items: center;
      font-size: 1.2rem;
      font-weight: 700;
      margin-bottom: 1rem;
      border: 1px solid #e0e0e0;
   }

   .order-total span:last-child {
      color: #1e7e34;
   }

   .order-actions {
      display: flex;
      gap: 0.5rem;
      justify-content: space-between;
   }

   .btn-action {
      flex: 1;
      padding: 0.8rem;
      border: none;
      border-radius: 10px;
      font-weight: 600;
      cursor: pointer;
      transition: transform 0.2s ease, box-shadow 0.2s ease;
      display: flex;
      align-items: center;
      justify-content: center;
      gap: 0.5rem;
   }

   .btn-action:hover {
      transform: translateY(-2px);
      box-shadow: 0 5px 15px rgba(0,0,0,0.2);
   }

   .btn-edit {
      background: linear-gradient(135deg, var(--color-info) 0%, #117a8b 100%);
      color: white;
   }

   .btn-delete {
      background: linear-gradient(135deg, var(--color-danger) 0%, #a71d2a 100%);
      color: white;
   }

   .btn-status {
      background: linear-gradient(135deg, #a8adb7 0%, #6f7682 100%);
      color: #fff;
   }

   .btn-print {
      background: linear-gradient(135deg, #f97316 0%, #ea580c 100%);
      color: #fff;
   }

   .empty-state {
      text-align: center;
      padding: 4rem 2rem;
      background: rgba(255,255,255,0.95);
      border-radius: 20px;
      margin-top: 2rem;
   }

   .empty-state i {
      font-size: 5rem;
      color: #ddd;
      margin-bottom: 1rem;
   }

   .empty-state h3 {
      color: #666;
      font-size: 1.5rem;
      margin-bottom: 1rem;
   }

   .empty-state p {
      color: #999;
      margin-bottom: 2rem;
   }

   @keyframes fadeInUp {
      from {
         opacity: 0;
         transform: translateY(20px);
      }
      to {
         opacity: 1;
         transform: translateY(0);
      }
   }

   .section-title {
      font-size: 2.3rem;
      font-weight: 800;
      color: #111;
      margin-bottom: 2.5rem;
      display: inline-flex;
      align-items: center;
      gap: 0.9rem;
   }
   
   .modal-overlay { 
      position: fixed; 
      inset: 0; 
      background: rgba(17,24,39,0.55); 
      backdrop-filter: blur(4px); 
      -webkit-backdrop-filter: blur(4px); 
      display: none; 
      align-items: center; 
      justify-content: center; 
      z-index: 2000; 
      padding: 24px; 
   }
   .modal-overlay.show { 
      display: flex; 
   }
   .modal-container {
      width: min(1280px, 95vw);
      max-height: 88vh;
      background: linear-gradient(180deg, rgba(255,255,255,0.98), rgba(255,255,255,0.94));
      border-radius: 20px;
      box-shadow: 0 30px 80px rgba(0,0,0,0.35);
      overflow: hidden;
      transform: translateY(20px);
      opacity: 0;
      transition: transform .25s ease, opacity .25s ease;
      border: 1px solid rgba(0,0,0,0.06);
   }
   .modal-overlay.show .modal-container { 
      transform: translateY(0); 
      opacity: 1; 
   }
   .modal-header {
      display: flex;
      align-items: center;
      justify-content: space-between;
      padding: 1.1rem 1.4rem;
      border-bottom: 1px solid #eee;
      background: linear-gradient(90deg, rgba(179,0,0,0.06), transparent);
   }
   .modal-title { 
      font-size: 1.4rem; 
      font-weight: 800; 
      color: var(--color-primary); 
      display:flex; 
      align-items:center; 
      gap:.6rem; 
   }
   .modal-close { 
      border: none; 
      background: #fff; 
      border-radius: 10px; 
      padding: .5rem .7rem; 
      cursor: pointer; 
      box-shadow: 0 4px 12px rgba(0,0,0,0.06); 
   }
   .modal-body { 
      padding: 1.1rem 1.4rem; 
      overflow: auto; 
      max-height: calc(88vh - 140px); 
   }
   .modal-footer { 
      padding: 1rem 1.4rem; 
      border-top: 1px solid #eee; 
      background: #fafafa; 
      display:flex; 
      gap:.8rem; 
      justify-content:flex-end; 
   }
   
   .grid-two { 
      display: grid; 
      grid-template-columns: 1fr 1fr; 
      gap: 1.2rem; 
   }
   @media (max-width: 992px) { 
      .grid-two { 
         grid-template-columns: 1fr; 
      } 
   }
   @media (max-width: 992px) { .grid-two { grid-template-columns: 1fr; } }

   .grid-three { display: grid; grid-template-columns: 0.9fr 1.4fr 0.9fr; gap: 1.2rem; align-items: start; }
   @media (max-width: 1200px) { .grid-three { grid-template-columns: 1fr; } }
   .cart-sticky { position: sticky; top: .25rem; }
   .form-group { margin-bottom: 1rem; }
   .form-label { display:block; font-weight:700; margin-bottom:.4rem; color:#333; }
   .form-control, .form-select { width:100%; padding: .9rem 1rem; border: 2px solid #e6e6e6; border-radius: 10px; font-size: 1rem; }
   .form-control:focus, .form-select:focus { outline:none; border-color: var(--color-primary); box-shadow: 0 0 0 3px rgba(179,0,0,0.08); }
   .products-container { max-height: 58vh; overflow: auto; border: 2px solid #f0f0f0; border-radius: 12px; padding: 1rem; background: #f9fafb; }
   .category-block { display:none; margin-bottom: 1.1rem; background:#fff; border-radius:10px; padding: .9rem; border:1px solid #f1f1f1; }
   .category-placeholder { display:flex; align-items:center; justify-content:center; text-align:center; padding:1.4rem; border:2px dashed #d9d9d9; border-radius:12px; color:#777; font-weight:600; background:#fff; min-height:120px; margin-bottom:1rem; }
   .category-title { color: var(--color-primary); font-size:1.1rem; font-weight:800; margin:0 0 .7rem 0; }
   .products-grid { display:grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr)); gap:.8rem; }
   .product-card { background:#fff; border:1px solid #eee; border-radius:12px; padding:.7rem; display:flex; align-items:center; gap:.8rem; transition: box-shadow .2s ease; }
   .product-card:hover { box-shadow: 0 10px 20px rgba(0,0,0,0.06); }
   .product-image { width:56px; height:56px; object-fit:cover; border-radius:10px; }
   .product-name { font-weight:700; color:#222; }
   .product-price { color: #28a745; font-weight:700; font-size:.95rem; }
   .product-quantity { display:flex; align-items:center; gap:.45rem; }
   .btn-quantity { width:32px; height:32px; border:1px solid #ddd; background:#fff; border-radius:8px; cursor:pointer; font-weight:800; }
   .quantity-display { min-width: 28px; text-align:center; font-weight:800; }
   .cart-section { margin-top:1rem; padding:1.1rem; background:#fff; border:2px dashed #28a745; border-radius:12px; }
   .cart-title { font-size:1.1rem; font-weight:800; margin:0 0 .6rem 0; display:flex; justify-content:space-between; align-items:center; }
   .cart-items { max-height: 200px; overflow:auto; display:flex; flex-direction:column; gap:.45rem; }
   .cart-item { display:flex; justify-content:space-between; align-items:center; gap:.8rem; padding:.55rem .65rem; border:1px solid #e6f5ea; border-radius:10px; background:linear-gradient(90deg, rgba(232,255,239,0.7), rgba(255,255,255,0.9)); box-shadow:0 4px 10px rgba(40,167,69,0.08); transition: transform .2s ease, box-shadow .2s ease; }
   .cart-item:hover { transform: translateY(-2px); box-shadow:0 8px 18px rgba(40,167,69,0.12); }
   .cart-item-info { display:flex; flex-direction:column; color:#1f3d2c; font-weight:600; }
   .cart-item-actions { display:flex; align-items:center; gap:.4rem; }
   .cart-remove-btn { border:none; background:rgba(220,53,69,0.12); color:#dc3545; border-radius:999px; padding:.35rem .75rem; font-size:.85rem; font-weight:700; cursor:pointer; transition: background .2s ease, transform .2s ease; display:flex; align-items:center; gap:.35rem; }
   .cart-remove-btn:hover { background:rgba(220,53,69,0.22); transform: translateY(-1px); }
   .cart-item-subtotal { font-weight:800; color:#1e7e34; font-size:1rem; }
   .cart-total { text-align:right; font-size:1.2rem; font-weight:900; color:#28a745; margin-top:.8rem; }
   .cart-empty { display:flex; flex-direction:column; align-items:center; justify-content:center; gap:.35rem; color:#6f7d6d; padding:1.2rem; background:#f6fff7; border-radius:12px; border:1px dashed rgba(40,167,69,0.25); }
   .cart-empty i { font-size:1.7rem; color:#28a745; }
   .cart-empty small { font-weight:500; color:#9aa0a6; }
   .btn-primary { background: linear-gradient(135deg, var(--color-success), #1e7e34); color:#fff; border:none; border-radius:10px; padding:.9rem 1.2rem; font-weight:800; }
   .btn-secondary { background:#6c757d; color:#fff; border:none; border-radius:10px; padding:.9rem 1.2rem; font-weight:700; }
   </style>
</head>
<body>

<?php include '../components/admin_header.php' ?>

<section class="dashboard">
   <h1 class="section-title">
      Pedidos a Domicilio
   </h1>

   <!-- Estadísticas -->
   <div class="stats-container">
      <div class="stat-card today">
         <div class="stat-header">
            <span class="stat-label">Pedidos Hoy</span>
            <i class="fas fa-calendar-day stat-icon"></i>
         </div>
         <div class="stat-content">
            <div class="stat-left">
               <span class="stat-value"><?= $stats_today['total_pedidos'] ?></span>
               <span class="stat-sublabel">Pedidos registrados durante el día</span>
            </div>
            <div class="stat-right">
               <span class="stat-right-label">Monto recaudado</span>
               <span class="stat-right-amount">COP <?= number_format($stats_today['total_recaudado'], 0, ',', '.') ?></span>
            </div>
         </div>
      </div>

      <div class="actions-buttons">
         <a class="btn-history" href="delivery_history.php">
            <i class="fas fa-history"></i> Historial
         </a>
         <button type="button" class="btn-add-inline" onclick="mostrarModalAgregar()">
            Agregar Pedido
         </button>
      </div>
   </div>

   <!-- Lista de Pedidos -->
   <div class="orders-container<?= empty($orders) ? ' orders-empty' : '' ?>">
      <?php
      if(!empty($orders)) {
         foreach($orders as $index => $order){
            $items = json_decode($order['order_items'], true);
            $displayNumber = $index + 1;
      ?>
      <div class="order-card"
           data-order-id="<?= $order['id'] ?>"
           data-customer="<?= htmlspecialchars($order['customer_name'], ENT_QUOTES) ?>"
           data-phone="<?= htmlspecialchars($order['phone'], ENT_QUOTES) ?>"
           data-address="<?= htmlspecialchars($order['address'], ENT_QUOTES) ?>"
           data-payment="<?= htmlspecialchars($order['payment_method'], ENT_QUOTES) ?>"
           data-notes="<?= htmlspecialchars($order['notes'], ENT_QUOTES) ?>"
           data-status="<?= htmlspecialchars($order['status'], ENT_QUOTES) ?>"
           data-items="<?= htmlspecialchars(base64_encode($order['order_items']), ENT_QUOTES) ?>"
           data-total="<?= (float)$order['total_amount'] ?>">
         <span class="order-status <?= $order['status'] ?>"><?= str_replace('_', ' ', $order['status']) ?></span>
         
         <div class="order-header">
            <div class="order-number">Pedido #<?= $displayNumber ?></div>
            <div class="order-datetime">
               <i class="far fa-clock"></i>
               <?= date('d/m/Y h:i A', strtotime($order['created_at'])) ?>
            </div>
         </div>

         <div class="customer-info">
            <div class="customer-name"><?= htmlspecialchars($order['customer_name']) ?></div>
            <div class="customer-detail">
               <i class="fas fa-phone"></i> <?= htmlspecialchars($order['phone']) ?>
            </div>
            <div class="customer-detail">
               <i class="fas fa-map-marker-alt"></i> <?= htmlspecialchars($order['address']) ?>
            </div>
            <div class="customer-detail">
               <i class="fas fa-money-bill-wave"></i> <?= ucfirst($order['payment_method']) ?>
            </div>
         </div>

         <div class="order-items">
            <div class="order-items-title">Productos:</div>
            <?php
            if(is_array($items)) {
               foreach($items as $item) {
                  $costo = isset($item['coste']) ? (float)$item['coste'] : null;
                  echo '<div class="order-item">';
                  echo '<span>' . $item['cantidad'] . 'x ' . htmlspecialchars($item['nombre']) . '</span>';
                  echo '<span>';
                  echo 'COP ' . number_format($item['precio'] * $item['cantidad'], 0, ',', '.');
                  if($costo !== null) {
                     echo '<br><small style="display:block;color:#6b7280;">Costo unit: COP ' . number_format($costo, 0, ',', '.') . '</small>';
                  }
                  echo '</span>';
                  echo '</div>';
               }
            }
            ?>
         </div>

         <div class="order-total">
            <span>Total:</span>
            <span>COP <?= number_format($order['total_amount'], 0, ',', '.') ?></span>
         </div>

         <?php if($order['notes']) { ?>
         <div class="customer-detail" style="background: #fff3cd; padding: 0.5rem; border-radius: 5px; margin-bottom: 1rem;">
            <i class="fas fa-sticky-note"></i> <?= htmlspecialchars($order['notes']) ?>
         </div>
         <?php } ?>

         <div class="order-actions">
            <button class="btn-action btn-status" onclick="cambiarEstado(<?= $order['id'] ?>, '<?= $order['status'] ?>')">
               <i class="fas fa-sync-alt"></i> Estado
            </button>
            <button class="btn-action btn-print" onclick="imprimirPedido(<?= $order['id'] ?>)">
               <i class="fas fa-print"></i> Imprimir
            </button>
            <button class="btn-action btn-edit" onclick="mostrarModalEditar(this)">
               <i class="fas fa-edit"></i> Editar
            </button>
            <button class="btn-action btn-delete" onclick="eliminarPedido(<?= $order['id'] ?>)">
               <i class="fas fa-trash"></i> Eliminar
            </button>
         </div>
      </div>
      <?php
         }
      } else {
      ?>
      <div class="empty-state">
         <i class="fas fa-box-open"></i>
         <h3>No hay pedidos en este período</h3>
         <p>Cambia el rango de fechas o agrega un nuevo pedido</p>
      </div>
      <?php } ?>
   </div>
</section>

<!-- Modal para editar pedido -->
<div class="modal-overlay" id="editOrderOverlay">
  <div class="modal-container" role="dialog" aria-modal="true" aria-labelledby="editOrderTitle">
    <div class="modal-header">
      <div class="modal-title" id="editOrderTitle"><i class="fas fa-edit"></i> Editar Pedido a Domicilio</div>
      <button class="modal-close" id="closeEditOrder" aria-label="Cerrar"><i class="fas fa-times"></i></button>
    </div>
    <div class="modal-body">
      <form id="editOrderForm">
        <input type="hidden" name="order_id" id="editOrderId">
        <div class="grid-three">
          <div>
            <div class="form-group">
              <label class="form-label" for="editCustomerName">Nombre y Apellido</label>
              <input type="text" id="editCustomerName" name="customer_name" class="form-control" required>
            </div>
            <div class="form-group">
              <label class="form-label" for="editPhone">Teléfono Celular</label>
              <input type="tel" id="editPhone" name="phone" class="form-control" required>
            </div>
            <div class="form-group">
              <label class="form-label" for="editAddress">Dirección</label>
              <textarea id="editAddress" name="address" class="form-control" rows="3" required></textarea>
            </div>
            <div class="form-group">
              <label class="form-label" for="editPayment">Método de Pago</label>
              <select id="editPayment" name="payment_method" class="form-select" required>
                <option value="">Seleccione un método</option>
                <option value="efectivo">Efectivo</option>
                <option value="transferencia">Transferencia</option>
              </select>
            </div>
            <div class="form-group">
              <label class="form-label" for="editStatus">Estado del Pedido</label>
              <select id="editStatus" name="status" class="form-select" required>
                <option value="pendiente">Pendiente</option>
                <option value="en_preparacion">En Preparación</option>
                <option value="en_camino">En Camino</option>
                <option value="entregado">Entregado</option>
                <option value="cancelado">Cancelado</option>
              </select>
            </div>
            <div class="form-group">
              <label class="form-label" for="editNotes">Notas (Opcional)</label>
              <textarea id="editNotes" name="notes" class="form-control" rows="2"></textarea>
            </div>
          </div>
          <div>
            <div class="form-group">
              <label class="form-label" for="editModalCategoryFilter">Filtrar por Categoría</label>
              <select id="editModalCategoryFilter" class="form-select">
                <option value="">Seleccione una categoría</option>
                <?php foreach($categorias as $cat): ?>
                  <option value="<?= normaliza_categoria($cat['name']) ?>"><?= htmlspecialchars($cat['name']) ?></option>
                <?php endforeach; ?>
              </select>
            </div>
            <div class="form-group">
              <div class="products-container">
                <div id="editCategoryPlaceholder" class="category-placeholder">
                  Selecciona una categoría para ver los productos disponibles.
                </div>
                <?php
                  $productosPorCategoria = [];
                  foreach ($productos as $producto) {
                    $ck = normaliza_categoria($producto['category_name']);
                    if (!isset($productosPorCategoria[$ck])) $productosPorCategoria[$ck] = [];
                    $producto['sale_price'] = isset($producto['sale_price']) && $producto['sale_price'] > 0 ? $producto['sale_price'] : $producto['price'];
                    $productosPorCategoria[$ck][] = $producto;
                  }
                  foreach ($categorias as $cat):
                    $key = normaliza_categoria($cat['name']);
                    if (!isset($productosPorCategoria[$key])) continue;
                ?>
                  <div class="category-block categoria-<?= $key ?>" data-category="<?= $key ?>">
                    <h3 class="category-title"><?= htmlspecialchars($cat['name']) ?></h3>
                    <div class="products-grid">
                      <?php foreach ($productosPorCategoria[$key] as $p): ?>
                        <div class="product-card" data-cost="<?= (float)$p['price'] ?>" data-sale="<?= (float)$p['sale_price'] ?>">
                          <img src="../uploaded_img/<?= htmlspecialchars($p['image']) ?>" alt="<?= htmlspecialchars($p['name']) ?>" class="product-image">
                          <div style="flex:1;">
                            <div class="product-name"><?= htmlspecialchars($p['name']) ?></div>
                            <div class="product-price">
                              <strong>Venta:</strong> COP <?= number_format($p['sale_price'], 0, ',', '.') ?><br>
                              <small style="color:#64748b;">Costo: COP <?= number_format($p['price'], 0, ',', '.') ?></small>
                            </div>
                          </div>
                          <div class="product-quantity">
                            <button type="button" class="btn-quantity" onclick="updateEditQuantity(<?= (int)$p['id'] ?>, -1, '<?= htmlspecialchars($p['name'], ENT_QUOTES) ?>', <?= (float)$p['sale_price'] ?>, <?= (float)$p['price'] ?>)">-</button>
                            <span class="quantity-display" id="edit-qty-<?= (int)$p['id'] ?>">0</span>
                            <button type="button" class="btn-quantity" onclick="updateEditQuantity(<?= (int)$p['id'] ?>, 1, '<?= htmlspecialchars($p['name'], ENT_QUOTES) ?>', <?= (float)$p['sale_price'] ?>, <?= (float)$p['price'] ?>)">+</button>
                          </div>
                        </div>
                      <?php endforeach; ?>
                    </div>
                  </div>
                <?php endforeach; ?>
              </div>
            </div>
          </div>
          <div class="cart-sticky">
            <div class="cart-section">
              <h3 class="cart-title"><span><i class="fas fa-shopping-cart"></i> Resumen del Pedido</span></h3>
              <div id="editModalCartItems" class="cart-items"></div>
              <div class="cart-total">Total: COP <span id="editModalTotalAmount">0</span></div>
            </div>
          </div>
        </div>
      </form>
    </div>
    <div class="modal-footer">
      <button class="btn-secondary" type="button" id="cancelEditOrder">Cancelar</button>
      <button class="btn-primary" type="submit" form="editOrderForm" id="saveEditOrder" disabled>Actualizar Pedido</button>
    </div>
  </div>
</div>

<!-- Modal para agregar pedido -->
<div class="modal-overlay" id="addOrderOverlay">
  <div class="modal-container" role="dialog" aria-modal="true" aria-labelledby="addOrderTitle">
    <div class="modal-header">
      <div class="modal-title" id="addOrderTitle"><i class="fas fa-plus-circle"></i> Nuevo Pedido a Domicilio</div>
      <button class="modal-close" id="closeAddOrder" aria-label="Cerrar"><i class="fas fa-times"></i></button>
    </div>
    <div class="modal-body">
      <form id="addOrderForm">
        <div class="grid-three">
          <div>
            <div class="form-group">
              <label class="form-label">Nombre y Apellido</label>
              <input type="text" name="customer_name" class="form-control" required>
            </div>
            <div class="form-group">
              <label class="form-label">Teléfono Celular</label>
              <input type="tel" name="phone" class="form-control" required>
            </div>
            <div class="form-group">
              <label class="form-label">Dirección</label>
              <textarea name="address" class="form-control" rows="3" required></textarea>
            </div>
            <div class="form-group">
              <label class="form-label">Método de Pago</label>
              <select name="payment_method" class="form-select" required>
                <option value="">Seleccione un método</option>
                <option value="efectivo">Efectivo</option>
                <option value="transferencia">Transferencia</option>
              </select>
            </div>
            <div class="form-group">
              <label class="form-label">Notas (Opcional)</label>
              <textarea name="notes" class="form-control" rows="2"></textarea>
            </div>
          </div>
          <div>
            <div class="form-group">
              <label class="form-label">Filtrar por Categoría</label>
              <select id="modalCategoryFilter" class="form-select">
                <option value="">Seleccione una categoría</option>
                <?php foreach($categorias as $cat): ?>
                  <option value="<?= normaliza_categoria($cat['name']) ?>"><?= htmlspecialchars($cat['name']) ?></option>
                <?php endforeach; ?>
              </select>
            </div>
            <div class="form-group">
              <div class="products-container">
                <div id="categoryPlaceholder" class="category-placeholder">
                  Selecciona una categoría para ver los productos disponibles.
                </div>
                <?php
                  $productosPorCategoria = [];
                  foreach ($productos as $producto) {
                    $ck = normaliza_categoria($producto['category_name']);
                    if (!isset($productosPorCategoria[$ck])) {
                      $productosPorCategoria[$ck] = [];
                    }
                    $salePrice = isset($producto['sale_price']) && (float)$producto['sale_price'] > 0
                      ? (float)$producto['sale_price']
                      : (float)$producto['price'];
                    $producto['sale_price'] = $salePrice;
                    $producto['price'] = (float)$producto['price'];
                    $productosPorCategoria[$ck][] = $producto;
                  }
                  foreach ($categorias as $cat):
                    $key = normaliza_categoria($cat['name']);
                    if (!isset($productosPorCategoria[$key])) continue;
                ?>
                  <div class="category-block categoria-<?= $key ?>" data-category="<?= $key ?>">
                    <h3 class="category-title"><?= htmlspecialchars($cat['name']) ?></h3>
                    <div class="products-grid">
                      <?php foreach ($productosPorCategoria[$key] as $p): ?>
                        <div class="product-card" data-cost="<?= (float)$p['price'] ?>" data-sale="<?= (float)$p['sale_price'] ?>">
                          <img src="../uploaded_img/<?= htmlspecialchars($p['image']) ?>" alt="<?= htmlspecialchars($p['name']) ?>" class="product-image">
                          <div style="flex:1;">
                            <div class="product-name"><?= htmlspecialchars($p['name']) ?></div>
                            <div class="product-price">
                              <strong>Venta:</strong> COP <?= number_format($p['sale_price'], 0, ',', '.') ?><br>
                              <small style="color:#64748b;">Costo: COP <?= number_format($p['price'], 0, ',', '.') ?></small>
                            </div>
                          </div>
                          <div class="product-quantity">
                            <button type="button" class="btn-quantity" onclick="updateQuantity(<?= (int)$p['id'] ?>, -1, '<?= htmlspecialchars($p['name'], ENT_QUOTES) ?>', <?= (float)$p['sale_price'] ?>, <?= (float)$p['price'] ?>)">-</button>
                            <span class="quantity-display" id="qty-<?= (int)$p['id'] ?>">0</span>
                            <button type="button" class="btn-quantity" onclick="updateQuantity(<?= (int)$p['id'] ?>, 1, '<?= htmlspecialchars($p['name'], ENT_QUOTES) ?>', <?= (float)$p['sale_price'] ?>, <?= (float)$p['price'] ?>)">+</button>
                          </div>
                        </div>
                      <?php endforeach; ?>
                    </div>
                  </div>
                <?php endforeach; ?>
              </div>
            </div>
          </div>
          <div class="cart-sticky">
            <div class="cart-section">
              <h3 class="cart-title"><span><i class="fas fa-shopping-cart"></i> Resumen del Pedido</span></h3>
              <div id="modalCartItems" class="cart-items"></div>
              <div class="cart-total">Total: COP <span id="modalTotalAmount">0</span></div>
            </div>
          </div>
        </div>

      </form>
    </div>
    <div class="modal-footer">
      <button class="btn-secondary" type="button" id="cancelAddOrder">Cancelar</button>
      <button class="btn-primary" type="submit" form="addOrderForm" id="saveAddOrder" disabled>Guardar Pedido</button>
    </div>
  </div>
  
</div>

<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
let cart = {};
let total = 0;
let editCart = {};
let editTotal = 0;

function mostrarModalAgregar() {
  const overlay = document.getElementById('addOrderOverlay');
  overlay.classList.add('show');
  document.body.style.overflow = 'hidden';
  // reset form
  document.getElementById('addOrderForm').reset();
  cart = {}; total = 0; updateCart();
  document.querySelectorAll('.quantity-display').forEach(el => el.textContent = '0');
  const categorySelect = document.getElementById('modalCategoryFilter');
  if (categorySelect) {
    categorySelect.value = '';
  }
  resetModalCategories();
}

function mostrarModalEditar(button) {
  const card = button.closest('.order-card');
  if (!card) return;
  const overlay = document.getElementById('editOrderOverlay');
  overlay.classList.add('show');
  document.body.style.overflow = 'hidden';

  const orderId = card.dataset.orderId;
  const customer = card.dataset.customer || '';
  const phone = card.dataset.phone || '';
  const address = card.dataset.address || '';
  const payment = card.dataset.payment || '';
  const notes = card.dataset.notes || '';
  const status = card.dataset.status || 'pendiente';
  const encodedItems = card.dataset.items || '';
  let items = [];
  try {
    const decoded = encodedItems ? atob(encodedItems) : '[]';
    items = JSON.parse(decoded || '[]');
    if (!Array.isArray(items)) items = [];
  } catch (e) {
    items = [];
  }

  editCart = {};
  editTotal = 0;

  document.getElementById('editOrderId').value = orderId;
  document.getElementById('editCustomerName').value = customer;
  document.getElementById('editPhone').value = phone;
  document.getElementById('editAddress').value = address;
  document.getElementById('editPayment').value = payment;
  document.getElementById('editNotes').value = notes;
  document.getElementById('editStatus').value = status;

  const categorySelect = document.getElementById('editModalCategoryFilter');
  if (categorySelect) categorySelect.value = '';

  document.querySelectorAll('[id^="edit-qty-"]').forEach(el => el.textContent = '0');

  items.forEach(item => {
    const id = parseInt(item.id);
    if (!id) return;
    const qtyDisplay = document.getElementById('edit-qty-' + id);
    if (qtyDisplay) qtyDisplay.textContent = item.cantidad;
    editCart[id] = {
      id,
      nombre: item.nombre,
      precio: parseFloat(item.precio),
      coste: item.coste !== undefined ? parseFloat(item.coste) : 0,
      cantidad: parseInt(item.cantidad)
    };
  });

  updateEditCart();
  resetEditModalCategories();
}

function cerrarModalAgregar() {
  const overlay = document.getElementById('addOrderOverlay');
  overlay.classList.remove('show');
  document.body.style.overflow = '';
}

function cerrarModalEditar() {
  const overlay = document.getElementById('editOrderOverlay');
  overlay.classList.remove('show');
  document.body.style.overflow = '';
  const categorySelect = document.getElementById('editModalCategoryFilter');
  if (categorySelect) categorySelect.value = '';
}

document.getElementById('closeAddOrder')?.addEventListener('click', cerrarModalAgregar);
document.getElementById('cancelAddOrder')?.addEventListener('click', cerrarModalAgregar);
document.getElementById('addOrderOverlay')?.addEventListener('click', (e) => {
  if (e.target.id === 'addOrderOverlay') cerrarModalAgregar();
});

document.getElementById('closeEditOrder')?.addEventListener('click', cerrarModalEditar);
document.getElementById('cancelEditOrder')?.addEventListener('click', cerrarModalEditar);
document.getElementById('editOrderOverlay')?.addEventListener('click', (e) => {
  if (e.target.id === 'editOrderOverlay') cerrarModalEditar();
});

function resetModalCategories(){
  filterModalCategory('');
}

function filterModalCategory(cat){
  const placeholder = document.getElementById('categoryPlaceholder');
  const blocks = document.querySelectorAll('#addOrderForm .category-block');
  const targetKey = (cat || '').toString().trim().toLowerCase();
  let anyVisible = false;
  blocks.forEach(b => {
    const blockKey = (b.dataset.category || '').toString().trim().toLowerCase();
    if (targetKey && blockKey === targetKey) {
      b.style.display = 'block';
      anyVisible = true;
    } else {
      b.style.display = 'none';
    }
  });
  if (placeholder) {
    placeholder.style.display = anyVisible ? 'none' : 'flex';
  }
  const productsContainer = document.querySelector('#addOrderForm .products-container');
  if (productsContainer) {
    productsContainer.scrollTop = 0;
  }
}

document.getElementById('modalCategoryFilter')?.addEventListener('change', function(){
  filterModalCategory(this.value);
});

function resetEditModalCategories(){
  filterEditModalCategory('');
}

function filterEditModalCategory(cat){
  const placeholder = document.getElementById('editCategoryPlaceholder');
  const blocks = document.querySelectorAll('#editOrderForm .category-block');
  const targetKey = (cat || '').toString().trim().toLowerCase();
  let anyVisible = false;
  blocks.forEach(b => {
    const blockKey = (b.dataset.category || '').toString().trim().toLowerCase();
    if (targetKey && blockKey === targetKey) {
      b.style.display = 'block';
      anyVisible = true;
    } else {
      b.style.display = 'none';
    }
  });
  if (placeholder) {
    placeholder.style.display = anyVisible ? 'none' : 'flex';
  }
  const productsContainer = document.querySelector('#editOrderForm .products-container');
  if (productsContainer) productsContainer.scrollTop = 0;
}

document.getElementById('editModalCategoryFilter')?.addEventListener('change', function(){
  filterEditModalCategory(this.value);
});

function updateQuantity(id, change, name, salePrice, costPrice){
  const qEl = document.getElementById('qty-' + id);
  let q = parseInt(qEl.textContent) || 0;
  q = Math.max(0, q + change);
  qEl.textContent = q;
  if (q === 0) {
    delete cart[id];
  } else {
    cart[id] = {
      id,
      nombre: name,
      precio: parseFloat(salePrice),
      coste: typeof costPrice !== 'undefined' ? parseFloat(costPrice) : 0,
      cantidad: q
    };
  }
  updateCart();
}

function updateCart(){
  const list = document.getElementById('modalCartItems');
  const totalEl = document.getElementById('modalTotalAmount');
  const saveBtn = document.getElementById('saveAddOrder');
  if (!list || !totalEl) return;
  if (Object.keys(cart).length === 0){
    list.innerHTML = '<div class="cart-empty"><i class="fas fa-clipboard-list"></i><strong>No hay productos seleccionados</strong><small>Elige una categoría y agrega tus comidas favoritas</small></div>';
    total = 0; totalEl.textContent = '0'; saveBtn.disabled = true;
    return;
  }
  let html = '';
  total = 0;
  Object.values(cart).forEach(item => {
    const subtotal = item.precio * item.cantidad;
    const subtotalCost = (item.coste || 0) * item.cantidad;
    total += subtotal;
    html += `<div class="cart-item">
      <div class="cart-item-info"><span>${item.cantidad}x ${item.nombre}</span>
        <small class="cart-item-subtotal">
          Venta: COP ${subtotal.toLocaleString('es-CO')}
          ${item.coste ? `<br><span style="color:#64748b;">Costo: COP ${subtotalCost.toLocaleString('es-CO')}</span>` : ''}
        </small>
      </div>
      <div class="cart-item-actions">
        <button type="button" class="cart-remove-btn" onclick="removeFromCart(${item.id})"><i class="fas fa-times"></i> Quitar</button>
      </div>
    </div>`;
  });
  list.innerHTML = html;
  totalEl.textContent = total.toLocaleString('es-CO');
  saveBtn.disabled = false;
}

function removeFromCart(id){
  if (cart[id]) {
    delete cart[id];
    const qtyDisplay = document.getElementById('qty-' + id);
    if (qtyDisplay) qtyDisplay.textContent = '0';
    updateCart();
  }
}

function updateEditQuantity(id, change, name, salePrice, costPrice){
  const qEl = document.getElementById('edit-qty-' + id);
  if (!qEl) return;
  let q = parseInt(qEl.textContent) || 0;
  q = Math.max(0, q + change);
  qEl.textContent = q;
  if (q === 0) {
    delete editCart[id];
  } else {
    editCart[id] = {
      id,
      nombre: name,
      precio: parseFloat(salePrice),
      coste: typeof costPrice !== 'undefined' ? parseFloat(costPrice) : 0,
      cantidad: q
    };
  }
  updateEditCart();
}

function updateEditCart(){
  const list = document.getElementById('editModalCartItems');
  const totalEl = document.getElementById('editModalTotalAmount');
  const saveBtn = document.getElementById('saveEditOrder');
  if (!list || !totalEl) return;
  if (Object.keys(editCart).length === 0){
    list.innerHTML = '<div class="cart-empty"><i class="fas fa-clipboard-list"></i><strong>No hay productos seleccionados</strong><small>Selecciona una categoría para editar el pedido</small></div>';
    editTotal = 0; totalEl.textContent = '0'; if (saveBtn) saveBtn.disabled = true;
    return;
  }
  let html = '';
  editTotal = 0;
  Object.values(editCart).forEach(item => {
    const subtotal = item.precio * item.cantidad;
    const subtotalCost = (item.coste || 0) * item.cantidad;
    editTotal += subtotal;
    html += `<div class="cart-item">
      <div class="cart-item-info"><span>${item.cantidad}x ${item.nombre}</span>
        <small class="cart-item-subtotal">
          Venta: COP ${subtotal.toLocaleString('es-CO')}
          ${item.coste ? `<br><span style="color:#64748b;">Costo: COP ${subtotalCost.toLocaleString('es-CO')}</span>` : ''}
        </small>
      </div>
      <div class="cart-item-actions">
        <button type="button" class="cart-remove-btn" onclick="removeFromEditCart(${item.id})"><i class="fas fa-times"></i> Quitar</button>
      </div>
    </div>`;
  });
  list.innerHTML = html;
  totalEl.textContent = editTotal.toLocaleString('es-CO');
  if (saveBtn) saveBtn.disabled = false;
}

function removeFromEditCart(id){
  if (editCart[id]) {
    delete editCart[id];
    const qtyDisplay = document.getElementById('edit-qty-' + id);
    if (qtyDisplay) qtyDisplay.textContent = '0';
    updateEditCart();
  }
}

document.getElementById('addOrderForm')?.addEventListener('submit', function(e){
  e.preventDefault();
  if (Object.keys(cart).length === 0){
    Swal.fire('Aviso','Debes agregar al menos un producto','warning');
    return;
  }
  const form = e.target;
  const payload = new URLSearchParams();
  payload.set('customer_name', form.customer_name.value.trim());
  payload.set('phone', form.phone.value.trim());
  payload.set('address', form.address.value.trim());
  payload.set('payment_method', form.payment_method.value);
  payload.set('notes', form.notes.value.trim());
  payload.set('order_items', JSON.stringify(Object.values(cart)));
  payload.set('total_amount', String(total));

  fetch('create_delivery.php', { method:'POST', headers:{'Content-Type':'application/x-www-form-urlencoded'}, body: payload.toString() })
    .then(r => r.json())
    .then(data => {
      if (data.success){
        cerrarModalAgregar();
        Swal.fire('¡Guardado!','El pedido ha sido registrado','success').then(()=>{ location.reload(); });
      } else {
        Swal.fire('Error', data.message || 'No se pudo guardar', 'error');
      }
    })
    .catch(() => Swal.fire('Error','No se pudo guardar','error'));
});

document.getElementById('editOrderForm')?.addEventListener('submit', function(e){
  e.preventDefault();
  if (Object.keys(editCart).length === 0){
    Swal.fire('Aviso','Debes agregar al menos un producto','warning');
    return;
  }
  const form = e.target;
  const payload = new URLSearchParams();
  const orderId = form.order_id?.value;
  if (!orderId) {
    Swal.fire('Error','No se pudo identificar el pedido','error');
    return;
  }
  payload.set('order_id', orderId);
  payload.set('customer_name', form.customer_name.value.trim());
  payload.set('phone', form.phone.value.trim());
  payload.set('address', form.address.value.trim());
  payload.set('payment_method', form.payment_method.value);
  payload.set('notes', form.notes.value.trim());
  payload.set('order_items', JSON.stringify(Object.values(editCart)));
  payload.set('total_amount', String(editTotal));

  fetch('update_delivery.php', {
      method:'POST',
      headers:{'Content-Type':'application/x-www-form-urlencoded'},
      body: payload.toString(),
      credentials: 'same-origin'
    })
    .then(r => {
      if (!r.ok) throw new Error('Respuesta no válida');
      return r.json();
    })
    .then(data => {
      if (data.success){
        cerrarModalEditar();
        Swal.fire('¡Actualizado!','El pedido ha sido modificado','success').then(()=>{ location.reload(); });
      } else {
        Swal.fire('Error', data.message || 'No se pudo actualizar','error');
      }
    })
    .catch((err) => {
      console.error('Error actualizando pedido', err);
      Swal.fire('Error','No se pudo actualizar','error');
    });
});

function restablecerFiltros(){
  const form = document.querySelector('.filters-form');
  if (!form) return;
  const today = new Date().toISOString().split('T')[0];
  const desde = form.querySelector('#fecha_desde');
  const hasta = form.querySelector('#fecha_hasta');
  if (desde) desde.value = today;
  if (hasta) hasta.value = today;
  form.submit();
}

function cambiarEstado(id, estadoActual) {
   const estados = {
      'pendiente': 'Pendiente',
      'en_preparacion': 'En Preparación',
      'en_camino': 'En Camino',
      'entregado': 'Entregado',
      'cancelado': 'Cancelado'
   };
   
   Swal.fire({
      title: 'Cambiar Estado del Pedido',
      input: 'select',
      inputOptions: estados,
      inputValue: estadoActual,
      showCancelButton: true,
      confirmButtonText: 'Cambiar',
      cancelButtonText: 'Cancelar',
      confirmButtonColor: '#28a745',
      cancelButtonColor: '#6c757d',
      inputValidator: (value) => {
         if (!value) {
            return 'Debes seleccionar un estado';
         }
      }
   }).then((result) => {
      if (result.isConfirmed) {
         fetch('update_delivery_status.php', {
            method: 'POST',
            headers: {
               'Content-Type': 'application/x-www-form-urlencoded',
            },
            body: 'id=' + id + '&status=' + result.value
         })
         .then(response => response.json())
         .then(data => {
            if(data.success) {
               Swal.fire('¡Actualizado!', 'El estado del pedido ha sido actualizado.', 'success')
               .then(() => location.reload());
            } else {
               Swal.fire('Error', 'No se pudo actualizar el estado.', 'error');
            }
         });
      }
   });
}

function eliminarPedido(id) {
   Swal.fire({
      title: '¿Estás seguro?',
      text: "Esta acción no se puede deshacer",
      icon: 'warning',
      showCancelButton: true,
      confirmButtonText: 'Sí, eliminar',
      cancelButtonText: 'Cancelar',
      confirmButtonColor: '#dc3545',
      cancelButtonColor: '#6c757d',
   }).then((result) => {
      if (result.isConfirmed) {
         window.location.href = 'delete_delivery.php?id=' + id;
      }
   });
}

function imprimirPedido(id) {
   if(!id){
      Swal.fire('Error', 'No se pudo identificar el pedido para imprimir.', 'error');
      return;
   }
   const url = `delivery_order_ticket.php?id=${encodeURIComponent(id)}`;
   window.open(url, '_blank');
}
</script>

</body>
</html>
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