Tul xxx Tul

Viewing: delivery_history.php

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

session_start();

$admin_id = $_SESSION['admin_id'] ?? null;
if(!$admin_id){
   header('location:admin_login.php');
   exit();
}

date_default_timezone_set('America/Bogota');

$today = new DateTime('today', new DateTimeZone('America/Bogota'));
$yesterday = (clone $today)->modify('-1 day');

// Determinar primera fecha disponible de pedidos
$historic_start = $yesterday->format('Y-m-d');
$min_date_stmt = $conn->query("SELECT MIN(DATE(created_at)) AS min_date FROM `delivery_orders`");
if ($min_date_stmt) {
   $min_date_row = $min_date_stmt->fetch(PDO::FETCH_ASSOC);
   if (!empty($min_date_row['min_date'])) {
      $historic_start = $min_date_row['min_date'];
   }
}

// Filtros (por defecto: ayer)
$max_history_date = $yesterday->format('Y-m-d');
$fecha_desde = isset($_GET['fecha_desde']) && $_GET['fecha_desde'] !== '' ? $_GET['fecha_desde'] : $historic_start;
$fecha_hasta = isset($_GET['fecha_hasta']) && $_GET['fecha_hasta'] !== '' ? $_GET['fecha_hasta'] : $max_history_date;

if ($fecha_hasta > $max_history_date) $fecha_hasta = $max_history_date;
if ($fecha_desde > $fecha_hasta) $fecha_desde = $fecha_hasta;

$start_dt = DateTime::createFromFormat('Y-m-d H:i:s', $fecha_desde . ' 00:00:00', new DateTimeZone('America/Bogota')) ?: clone $yesterday;
$start_dt->setTime(0,0,0);
$end_dt = DateTime::createFromFormat('Y-m-d H:i:s', $fecha_hasta . ' 00:00:00', new DateTimeZone('America/Bogota')) ?: clone $yesterday;
$end_dt->setTime(0,0,0);
$end_dt->modify('+1 day');
if($end_dt > $today){
   $end_dt = clone $today;
}

$start_datetime = $start_dt->format('Y-m-d H:i:s');
$end_datetime = $end_dt->format('Y-m-d H:i:s');

// Totales del rango (excluyendo hoy)
$select_stats_range = $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_range->execute([$start_datetime, $end_datetime]);
$stats_range = $select_stats_range->fetch(PDO::FETCH_ASSOC) ?: ['total_pedidos' => 0, 'total_recaudado' => 0];

// Pedidos del rango (excluyendo hoy)
$select_orders = $conn->prepare("SELECT * FROM `delivery_orders` WHERE created_at >= ? AND created_at < ? ORDER BY created_at ASC");
$select_orders->execute([$start_datetime, $end_datetime]);
$orders = $select_orders->fetchAll(PDO::FETCH_ASSOC);

// Categorías y productos (para modal de edición)
$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>Historial de Pedidos | 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-info:#17a2b8; --color-warning:#ffc107; --color-danger:#dc3545; }
      body { background: #f4f4f4; }
      .dashboard { padding: 1rem 1.2rem 3rem; }
      .section-title { font-size: 2.3rem; font-weight: 800; color: #111; margin: 0; }
      .section-header { display:flex; align-items:center; gap:.8rem; margin-bottom: 1rem; }
      .btn-back-header { margin-left:auto; padding:.85rem 1.8rem; border-radius:10px; border:1px solid rgba(0,0,0,0.12); background:#f3f3f3; color:#333; font-size:1.08rem; display:inline-flex; align-items:center; gap:.45rem; font-weight:700; text-decoration:none; white-space:nowrap; }
      .btn-back-header:hover { background:#e7e7e7; }

      .stats-container { display:flex; flex-wrap:wrap; gap:1.2rem; margin-bottom:2rem; align-items:stretch; }
      .stat-card { background: linear-gradient(135deg, rgba(255,255,255,0.95), rgba(255,255,255,0.88)); border-radius: 16px; padding: 1rem 1.2rem; box-shadow: 0 8px 20px rgba(0,0,0,0.08); color:#111; flex:1 1 320px; position:relative; overflow:hidden; }
      .stat-card.range { background:#ffffff; color:#111; padding: 0.9rem 1.1rem; flex:0 0 320px; max-width: 340px; border:1px solid rgba(0,0,0,0.06); box-shadow: 0 12px 28px rgba(0,0,0,0.08); }
      .stat-header { display:flex; align-items:center; justify-content:space-between; }
      .stat-label { font-weight:800; }
      .stat-content { display:flex; gap:0.9rem; align-items:center; justify-content:space-between; margin-top:.35rem; }
      .stat-left { flex:1; }
      .stat-value { font-size:1.9rem; font-weight:900; }
      .stat-right { min-width: 150px; background: rgba(255,255,255,0.18); border-radius: 12px; padding:.7rem; text-align:right; }
      .stat-right-label { font-size:.85rem; opacity:.9; text-transform:uppercase; letter-spacing:1px; font-weight:700; }
      .stat-right-amount { font-size:1.4rem; font-weight:900; }
      .stat-card.range .stat-right { background:#f8f9fa; border:1px solid rgba(0,0,0,0.05); }
      .stat-card.range .stat-right-label { color:#444; opacity:0.8; }
      .stat-card.range .stat-right-amount { color:#222; }
      .stat-card.range .stat-label { color:#222; }

      .order-actions { display:flex; gap:.5rem; margin-top:.6rem; }
      .btn-action { padding:.6rem .9rem; border:none; border-radius:8px; font-weight:800; display:inline-flex; align-items:center; gap:.4rem; cursor:pointer; }
      .btn-status { background:#f1f1f1; color:#333; }
      .btn-edit { background: linear-gradient(135deg, var(--color-info) 0%, #117a8b 100%); color:#fff; }
      .btn-delete { background: linear-gradient(135deg, #dc3545 0%, #a71d2a 100%); color:#fff; }
      .btn-action i { font-size: .9rem; }

      .modal-overlay { position: fixed; inset: 0; background: rgba(0,0,0,0.5); display: none; align-items: center; justify-content: center; z-index: 2000; }
      .modal-overlay.show { display: flex; }
      .modal-container { width: min(1100px, 96%); max-height: 92vh; background: #fff; border-radius: 14px; overflow: hidden; display:flex; flex-direction:column; box-shadow: 0 18px 48px rgba(0,0,0,0.2); }
      .modal-header { padding: 1rem 1.2rem; display:flex; justify-content:space-between; align-items:center; border-bottom: 1px solid #eee; }
      .modal-title { font-weight: 900; font-size: 1.2rem; }
      .modal-body { padding: 1rem 1.2rem; overflow: auto; }
      .modal-footer { padding: .9rem 1.2rem; display:flex; gap:.6rem; justify-content:flex-end; border-top: 1px solid #eee; }
      .form-group { margin-bottom: .8rem; }
      .form-label { font-weight: 700; color:#111; margin-bottom:.35rem; display:block; }
      .form-control, .form-select { width:100%; padding:.8rem 1rem; border:2px solid #e6e6e6; border-radius:10px; font-size:1rem; }
      .grid-three { display:grid; grid-template-columns: 0.9fr 1.4fr 0.9fr; gap: 1.2rem; }
      .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-sticky { position: sticky; top: .25rem; }
      .cart-section { margin-top:1rem; padding:1.1rem; background:#fff; border:2px dashed #28a745; border-radius:12px; }
      .cart-items { max-height: 200px; overflow:auto; display:flex; flex-direction:column; gap:.45rem; }
      .cart-title { font-size:1.1rem; font-weight:800; margin:0 0 .6rem 0; display:flex; justify-content:space-between; align-items:center; }
      .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, #28a745 0%, #1e7e34 100%); color:#fff; border:none; border-radius:10px; padding:.9rem 1.4rem; font-weight:800; cursor:pointer; }
      .btn-secondary { background:#f1f1f1; color:#333; border:none; border-radius:10px; padding:.9rem 1.4rem; font-weight:800; cursor:pointer; }

      @media (max-width: 1200px) {
         .modal-container { width: min(980px, 94%); }
         .grid-three { grid-template-columns: 1fr; gap: 1rem; }
         .cart-sticky { position: static; }
      }

      @media (max-width: 768px) {
         .modal-container {
            width: 100%;
            height: 100vh;
            max-height: none;
            border-radius: 0;
         }
         .modal-header,
         .modal-footer { padding: 0.9rem 1rem; }
         .modal-body {
            padding: 1rem;
            max-height: calc(100vh - 150px);
         }
         .products-container {
            max-height: 46vh;
            padding: 0.8rem;
         }
         .products-grid { grid-template-columns: repeat(auto-fill, minmax(200px, 1fr)); }
         .cart-section { margin-top: 0; }
      }

      @media (max-width: 540px) {
         .products-grid { grid-template-columns: repeat(auto-fill, minmax(160px, 1fr)); }
         .modal-title { font-size: 1.05rem; }
         .btn-primary,
         .btn-secondary { width: 100%; justify-content: center; }
         .modal-footer { flex-direction: column; align-items: stretch; }
      }

      .stat-card.filters-card { display:flex; flex-direction:column; gap:1.1rem; flex:1 1 460px; min-width:320px; }
      .stat-card.filters-card .filters-header { display:flex; align-items:center; gap:.6rem; font-weight:800; color:#111; font-size:1.05rem; }
      .filters-form { display:grid; grid-template-columns: repeat(auto-fit, minmax(170px, 1fr)); align-items:end; gap:1rem; }
      .filter-group { display:flex; flex-direction:column; gap:.4rem; }
      .filter-group label { font-weight:700; color:#111; }
      .filter-group input { padding:.8rem 1rem; border:2px solid #e6e6e6; border-radius:10px; font-size:1rem; }
      .filter-action { display:flex; align-items:stretch; }
      .filters-form .btn { width:100%; justify-content:center; }
      @media (max-width: 520px){ .filters-form { grid-template-columns: 1fr; } }
      .btn { padding:.9rem 1.6rem; border:none; border-radius:10px; font-weight:800; display:inline-flex; gap:.5rem; align-items:center; cursor:pointer; }
      .btn-filter { background: linear-gradient(135deg, var(--color-primary) 0%, #7a0000 100%); color:#fff; }
      .btn-reset { background:#fff; color: var(--color-primary); border:1px solid rgba(179,0,0,0.25); }
      .btn-back { background:#f1f1f1; color:#333; text-decoration:none; }

      .orders-container { display: grid; grid-template-columns: repeat(auto-fill, minmax(350px, 1fr)); gap: 2rem; margin-bottom: 3rem; }
      @media (max-width: 900px) {
         .stats-container { flex-direction: column; }
         .stat-card.range,
         .stat-card.filters-card { flex: 1 1 100%; min-width: 100%; }
      }
      @media (max-width: 768px) {
         .stat-card.filters-card { padding: 1rem 1.1rem; }
         .filters-form { grid-template-columns: 1fr; gap: 0.8rem; }
         .filter-group { width: 100%; }
         .filter-action { width: 100%; }
         .filter-action .btn { width: 100%; }
         .products-grid { grid-template-columns: 1fr; }
         .product-card { flex-direction: row; align-items: center; }
         .product-card .product-quantity { margin-left: auto; }
         .orders-container { grid-template-columns: minmax(0, 1fr); gap: 1.2rem; justify-items: center; }
         .order-card { width: min(560px, 100%); margin: 0 auto; border-radius: 18px; padding: 1.2rem; }
      }
      @media (max-width: 520px) {
         .filters-form { gap: 0.7rem; }
         .products-grid { grid-template-columns: 1fr; }
         .product-card { flex-direction: row; align-items: center; gap: 0.6rem; padding: 0.65rem; }
         .product-card .product-quantity { margin-left: auto; width: auto; justify-content: flex-end; }
         .product-card .product-name { font-size: 0.92rem; }
         .product-card .product-price { font-size: 0.9rem; }
         .orders-container { gap: 1rem; }
         .order-card { width: 100%; padding: 1rem; border-radius: 16px; }
      }
      .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-print { background: linear-gradient(135deg, #f97316 0%, #ea580c 100%); color: #fff; }
      .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; }
      .empty-state { text-align:center; color:#666; padding:2rem 0; display:flex; flex-direction:column; gap:.6rem; align-items:center; justify-content:center; min-height:220px; background:rgba(255,255,255,0.8); border-radius:16px; box-shadow:0 10px 30px rgba(0,0,0,0.08); }
   </style>
</head>
<body class="admin-panel">
<?php include '../components/admin_header.php' ?>

<section class="dashboard">
   <div class="section-header">
      <h1 class="section-title">Historial de Pedidos</h1>
      <a href="delivery_orders.php" class="btn-back-header"><i class="fas fa-arrow-left"></i> Volver</a>
   </div>

   <div class="stats-container">
      <div class="stat-card range">
         <div class="stat-header">
            <span class="stat-label">Pedidos en Rango</span>
            <i class="fas fa-chart-line"></i>
         </div>
         <div class="stat-content">
            <div class="stat-left">
               <div class="stat-value"><?php echo (int)$stats_range['total_pedidos']; ?></div>
               <div>Pedidos anteriores a hoy</div>
            </div>
            <div class="stat-right">
               <div class="stat-right-label">Total recaudado</div>
               <div class="stat-right-amount">COP <?php echo number_format((float)$stats_range['total_recaudado'], 0, ',', '.'); ?></div>
            </div>
         </div>
      </div>
      <div class="stat-card filters-card">
         <div class="filters-header"><i class="fas fa-filter"></i> Filtros de historial</div>
         <form method="GET" class="filters-form">
            <div class="filter-group">
               <label for="fecha_desde">Desde:</label>
               <input type="date" id="fecha_desde" name="fecha_desde" value="<?php echo htmlspecialchars($fecha_desde); ?>">
            </div>
            <div class="filter-group">
               <label for="fecha_hasta">Hasta:</label>
               <input type="date" id="fecha_hasta" name="fecha_hasta" value="<?php echo htmlspecialchars($fecha_hasta); ?>">
            </div>
            <div class="filter-action">
               <button type="submit" class="btn btn-filter"><i class="fas fa-search"></i> Buscar</button>
            </div>
            <div class="filter-action">
               <button type="button" class="btn btn-reset" onclick="resetHistoryFilters()">Restablecer</button>
            </div>
         </form>
      </div>
   </div>

   <div class="orders-container" style="display:flex; flex-wrap:wrap; gap:2rem;">
      <?php if(!empty($orders)) { foreach($orders as $index => $order){ $items = json_decode($order['order_items'], true); ?>
         <div class="order-card"
              data-order-id="<?php echo (int)$order['id']; ?>"
              data-customer="<?php echo htmlspecialchars($order['customer_name'], ENT_QUOTES); ?>"
              data-phone="<?php echo htmlspecialchars($order['phone'], ENT_QUOTES); ?>"
              data-address="<?php echo htmlspecialchars($order['address'], ENT_QUOTES); ?>"
              data-payment="<?php echo htmlspecialchars($order['payment_method'], ENT_QUOTES); ?>"
              data-notes="<?php echo htmlspecialchars($order['notes'], ENT_QUOTES); ?>"
              data-status="<?php echo htmlspecialchars($order['status'], ENT_QUOTES); ?>"
              data-items="<?php echo htmlspecialchars(base64_encode($order['order_items']), ENT_QUOTES); ?>">
            <span class="order-status <?php echo htmlspecialchars($order['status']); ?>"><?php echo ucwords(str_replace('_',' ', $order['status'])); ?></span>
            <div class="order-header">
               <div class="order-number">Pedido #<?php echo $index + 1; ?></div>
               <div class="order-datetime"><i class="far fa-clock"></i> <?php echo date('d/m/Y h:i A', strtotime($order['created_at'])); ?></div>
            </div>
            <div class="customer-info">
               <div class="customer-name"><?php echo htmlspecialchars($order['customer_name']); ?></div>
               <div class="customer-detail"><i class="fas fa-phone"></i> <?php echo htmlspecialchars($order['phone']); ?></div>
               <div class="customer-detail"><i class="fas fa-map-marker-alt"></i> <?php echo htmlspecialchars($order['address']); ?></div>
               <div class="customer-detail"><i class="fas fa-money-bill-wave"></i> <?php echo 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) { ?>
                 <div class="order-item"><span><?php echo (int)$item['cantidad']; ?>x <?php echo htmlspecialchars($item['nombre']); ?></span><span>COP <?php echo number_format(((float)$item['precio'] * (int)$item['cantidad']), 0, ',', '.'); ?></span></div>
               <?php } } ?>
            </div>
            <div class="order-total"><span>Total:</span><span>COP <?php echo number_format((float)$order['total_amount'], 0, ',', '.'); ?></span></div>
            <?php if(!empty($order['notes'])) { ?><div class="customer-detail" style="background:#fff3cd; padding:.5rem; border-radius:6px; margin-top:.5rem;"><i class="fas fa-sticky-note"></i> <?php echo htmlspecialchars($order['notes']); ?></div><?php } ?>
            <div class="order-actions">
               <button class="btn-action btn-status" onclick="cambiarEstado(<?php echo (int)$order['id']; ?>, '<?php echo htmlspecialchars($order['status'], ENT_QUOTES); ?>')"><i class="fas fa-sync-alt"></i> Estado</button>
               <button class="btn-action btn-print" onclick="imprimirPedido(<?php echo (int)$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(<?php echo (int)$order['id']; ?>)"><i class="fas fa-trash"></i> Eliminar</button>
            </div>
         </div>
      <?php } } else { ?>
         <div class="empty-state" style="margin:auto; width:100%; max-width:520px;">
            <i class="fas fa-box-open" style="font-size:2rem;"></i>
            <h3>No hay pedidos para el rango seleccionado</h3>
            <p>Cambia el rango de fechas para ver otros días</p>
         </div>
      <?php } ?>
   </div>
  <!-- Modal 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] = [];
                      $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">
                            <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">COP <?= number_format($p['price'], 0, ',', '.') ?></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['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['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>

</section>

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

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 qEl = document.getElementById('edit-qty-' + id); if (qEl) qEl.textContent = item.cantidad;
    editCart[id] = { id, nombre: item.nombre, precio: parseFloat(item.precio), cantidad: parseInt(item.cantidad) };
  });
  updateEditCart();
  filterEditModalCategory('');
}

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('closeEditOrder')?.addEventListener('click', cerrarModalEditar);
document.getElementById('cancelEditOrder')?.addEventListener('click', cerrarModalEditar);
document.getElementById('editOrderOverlay')?.addEventListener('click', (e)=>{ if (e.target.id === 'editOrderOverlay') cerrarModalEditar(); });

function updateEditQuantity(id, change, name, price){
  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(price), 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;
    editTotal += subtotal;
    html += `<div class="cart-item">
      <div class="cart-item-info"><span>${item.cantidad}x ${item.nombre}</span><small class="cart-item-subtotal">COP ${subtotal.toLocaleString('es-CO')}</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('editModalCategoryFilter')?.addEventListener('change', function(){ filterEditModalCategory(this.value); });
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;
}

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

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('status', form.status.value);
  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 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:(v)=>{ if(!v) return 'Debes seleccionar un estado'; } })
  .then(res=>{ if(res.isConfirmed){ fetch('update_delivery_status.php', { method:'POST', headers:{'Content-Type':'application/x-www-form-urlencoded'}, body:'id='+id+'&status='+res.value })
    .then(r=>r.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(res=>{ if(res.isConfirmed){ window.location.href = 'delete_delivery.php?id=' + id + '&redirect=delivery_history.php'; } });
}

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');
}
function resetHistoryFilters(){
   const form = document.querySelector('.filters-form');
   if(!form) return;
   const y = new Date(Date.now() - 24*60*60*1000); // ayer
   const yyyy = y.getFullYear();
   const mm = String(y.getMonth()+1).padStart(2,'0');
   const dd = String(y.getDate()).padStart(2,'0');
   const val = `${yyyy}-${mm}-${dd}`;
   form.querySelector('#fecha_desde').value = val;
   form.querySelector('#fecha_hasta').value = val;
   form.submit();
}
</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