asdadsasd
PK     ü‘-\ÔŸ)¼,  ,    api.phpnu „[µü¤        <?php
require_once 'api_client.php';

header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type');

// Manejar preflight requests
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit();
}

// Inicializar API client y cache
$api = new WooCommerceAPI();
$cache = new SimpleCache();

// Obtener acciÃ³n
$action = $_GET['action'] ?? 'orders';

try {
    switch ($action) {
        case 'orders':
            handleOrdersRequest($api, $cache);
            break;
            
        case 'order_details':
            handleOrderDetailsRequest($api, $cache);
            break;
            
        case 'stats':
            handleStatsRequest($api, $cache);
            break;
            
        case 'debug':
            handleDebugRequest($api);
            break;
            
        default:
            throw new Exception('AcciÃ³n no vÃ¡lida');
    }
    
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode([
        'success' => false,
        'message' => $e->getMessage()
    ]);
}

/**
 * Manejar peticiÃ³n de pedidos
 */
function handleOrdersRequest($api, $cache) {
    $page = intval($_GET['page'] ?? 1);
    $cache_key = "orders_page_{$page}";
    
    // Intentar obtener del cache
    $cached_data = $cache->get($cache_key);
    if ($cached_data !== false) {
        echo json_encode([
            'success' => true,
            'data' => $cached_data,
            'cached' => true
        ]);
        return;
    }
    
    // Obtener pedidos frescos de la API
    $orders = $api->getCompletedOrdersByProduct(IGLESIAS_PRODUCT_ID, $page);
    
    // Procesar y formatear los pedidos
    $processed_orders = [];
    
    foreach ($orders as $order) {
        $church_data = extractChurchData($order);
        
        $processed_orders[] = [
            'id' => $order['id'],
            'number' => $order['number'],
            'status' => $order['status'],
            'total' => floatval($order['total']),
            'date_created' => $order['date_created'],
            'church_name' => $church_data['church_name'],
            'pastor_name' => $church_data['pastor_name'],
            'billing_email' => $order['billing']['email'],
            'billing_phone' => $order['billing']['phone'],
            'total_churches' => $church_data['total_churches']
        ];
    }
    
    // Guardar en cache
    $cache->set($cache_key, $processed_orders);
    
    echo json_encode([
        'success' => true,
        'data' => $processed_orders,
        'cached' => false
    ]);
}

/**
 * Manejar peticiÃ³n de detalles de pedido
 */
function handleOrderDetailsRequest($api, $cache) {
    $order_id = intval($_GET['id'] ?? 0);
    
    if (!$order_id) {
        throw new Exception('ID de pedido requerido');
    }
    
    $cache_key = "order_details_{$order_id}";
    
    // Intentar obtener del cache
    $cached_data = $cache->get($cache_key);
    if ($cached_data !== false) {
        echo json_encode([
            'success' => true,
            'data' => $cached_data,
            'cached' => true
        ]);
        return;
    }
    
    // Obtener detalles del pedido
    $order = $api->getOrderDetails($order_id);
    $church_data = extractChurchData($order);
    $participation_details = extractParticipationDetails($order);
    
    $order_details = [
        'id' => $order['id'],
        'number' => $order['number'],
        'status' => $order['status'],
        'total' => floatval($order['total']),
        'date_created' => $order['date_created'],
        'church_name' => $church_data['church_name'],
        'pastor_name' => $church_data['pastor_name'],
        'billing_email' => $order['billing']['email'],
        'billing_phone' => $order['billing']['phone'],
        'billing_address' => formatAddress($order['billing']),
        'total_churches' => $church_data['total_churches'],
        'participation_details' => $participation_details
    ];
    
    // Guardar en cache
    $cache->set($cache_key, $order_details);
    
    echo json_encode([
        'success' => true,
        'data' => $order_details,
        'cached' => false
    ]);
}

/**
 * Manejar peticiÃ³n de estadÃ­sticas
 */
function handleStatsRequest($api, $cache) {
    $cache_key = 'order_stats';
    
    // Intentar obtener del cache
    $cached_data = $cache->get($cache_key);
    if ($cached_data !== false) {
        echo json_encode([
            'success' => true,
            'data' => $cached_data,
            'cached' => true
        ]);
        return;
    }
    
    // Obtener estadÃ­sticas frescas
    $stats = $api->getOrderStats(IGLESIAS_PRODUCT_ID);
    
    // Guardar en cache por mÃ¡s tiempo (10 minutos)
    $cache->set($cache_key, $stats, 600);
    
    echo json_encode([
        'success' => true,
        'data' => $stats,
        'cached' => false
    ]);
}

/**
 * Extraer datos de la iglesia de los metadatos del pedido
 */
function extractChurchData($order) {
    $church_name = '';
    $pastor_name = '';
    $total_churches = 0;
    
    foreach ($order['line_items'] as $item) {
        if ($item['product_id'] == IGLESIAS_PRODUCT_ID) {
            foreach ($item['meta_data'] as $meta) {
                switch ($meta['key']) {
                    case 'Nombre de la Iglesia/Ministerio':
                        $church_name = $meta['value'];
                        break;
                    case 'Pastor / Representante':
                        $pastor_name = $meta['value'];
                        break;
                    case 'NÃºmero de Iglesias':
                        $total_churches = intval($meta['value']);
                        break;
                }
            }
            break;
        }
    }
    
    return [
        'church_name' => $church_name,
        'pastor_name' => $pastor_name,
        'total_churches' => $total_churches
    ];
}

/**
 * Extraer detalles de participaciÃ³n econÃ³mica
 */
function extractParticipationDetails($order) {
    $details = [];
    
    foreach ($order['line_items'] as $item) {
        if ($item['product_id'] == IGLESIAS_PRODUCT_ID) {
            foreach ($item['meta_data'] as $meta) {
                // Buscar metadatos especÃ­ficos de cada iglesia (formato: "Iglesia 1", "Iglesia 2", etc.)
                if (preg_match('/^Iglesia (\d+)$/', $meta['key'], $matches)) {
                    $church_number = $matches[1];
                    $description = $meta['value'];
                    $amount = extractAmountFromString($description);
                    
                    $details[] = [
                        'church' => "Iglesia {$church_number}",
                        'description' => $description,
                        'amount' => $amount
                    ];
                }
                // TambiÃ©n buscar el metadato "ParticipaciÃ³n EconÃ³mica" como fallback
                elseif ($meta['key'] === 'ParticipaciÃ³n EconÃ³mica') {
                    $lines = explode("\n", $meta['value']);
                    foreach ($lines as $line) {
                        $line = trim($line);
                        if (!empty($line) && strpos($line, ':') !== false) {
                            $parts = explode(':', $line, 2);
                            $church = trim($parts[0]);
                            $desc = trim($parts[1]);
                            $amount = extractAmountFromString($desc);
                            
                            $details[] = [
                                'church' => $church,
                                'description' => $desc,
                                'amount' => $amount
                            ];
                        }
                    }
                }
            }
            break;
        }
    }
    
    return $details;
}

/**
 * Extraer cantidad numÃ©rica de una cadena
 */
function extractAmountFromString($string) {
    // Debug para ver quÃ© estamos procesando
    error_log("Extracting amount from: " . $string);
    
    // Buscar patrones como "150â‚¬", "150.00â‚¬", "150 â‚¬", "- 150â‚¬", etc.
    if (preg_match('/-\s*(\d+(?:[.,]\d{1,2})?)\s*â‚¬/', $string, $matches)) {
        $amount = floatval(str_replace(',', '.', $matches[1]));
        error_log("Found amount with dash-euro pattern: " . $amount);
        return $amount;
    }
    
    // Buscar patrones como "cantidad personalizada - 250â‚¬"
    if (preg_match('/(\d+(?:[.,]\d{1,2})?)\s*â‚¬/', $string, $matches)) {
        $amount = floatval(str_replace(',', '.', $matches[1]));
        error_log("Found amount with euro pattern: " . $amount);
        return $amount;
    }
    
    // Buscar solo nÃºmeros con decimales al final de la cadena
    if (preg_match('/(\d+(?:[.,]\d{1,2})?)$/', trim($string), $matches)) {
        $amount = floatval(str_replace(',', '.', $matches[1]));
        error_log("Found amount with number pattern: " . $amount);
        return $amount;
    }
    
    error_log("No amount found in: " . $string);
    return 0;
}

/**
 * Formatear direcciÃ³n de facturaciÃ³n
 */
function formatAddress($billing) {
    $address_parts = array_filter([
        $billing['address_1'],
        $billing['address_2'],
        $billing['city'],
        $billing['state'],
        $billing['postcode'],
        $billing['country']
    ]);
    
    return implode(', ', $address_parts);
}

/**
 * Limpiar cache expirado periÃ³dicamente
 */
function cleanupCache($cache) {
    // Solo limpiar ocasionalmente (10% de probabilidad)
    if (rand(1, 10) === 1) {
        $cache->cleanup();
    }
}

// Limpiar cache al final
cleanupCache($cache);

/**
 * FunciÃ³n de debug para verificar datos
 */
function handleDebugRequest($api) {
    try {
        // Obtener algunos pedidos para debug
        $orders = $api->getCompletedOrders(1, 5);
        
        $debug_info = [
            'total_orders_found' => count($orders),
            'orders_sample' => []
        ];
        
        foreach ($orders as $order) {
            $has_iglesias_product = false;
            $iglesias_metadata = [];
            
            foreach ($order['line_items'] as $item) {
                if ($item['product_id'] == IGLESIAS_PRODUCT_ID) {
                    $has_iglesias_product = true;
                    foreach ($item['meta_data'] as $meta) {
                        $iglesias_metadata[$meta['key']] = $meta['value'];
                    }
                    break;
                }
            }
            
            if ($has_iglesias_product) {
                $debug_info['orders_sample'][] = [
                    'id' => $order['id'],
                    'number' => $order['number'],
                    'total' => $order['total'],
                    'status' => $order['status'],
                    'metadata' => $iglesias_metadata
                ];
            }
        }
        
        echo json_encode([
            'success' => true,
            'debug_info' => $debug_info
        ]);
        
    } catch (Exception $e) {
        echo json_encode([
            'success' => false,
            'error' => $e->getMessage()
        ]);
    }
}PK     ü‘-\ÂF	¨  ¨  	  README.mdnu „[µü¤        # Visor de Pedidos de Iglesias

Sistema para visualizar pedidos completados del producto de participaciÃ³n de iglesias a travÃ©s de la API REST de WordPress/WooCommerce.

## ConfiguraciÃ³n

### 1. Credenciales de WooCommerce

Edita el archivo `config.php` y configura:

```php
// URL de tu sitio WordPress
define('WP_API_BASE_URL', 'https://tu-sitio-wordpress.com');

// Credenciales de la API REST de WooCommerce
define('WC_CONSUMER_KEY', 'ck_tu_consumer_key_aqui');
define('WC_CONSUMER_SECRET', 'cs_tu_consumer_secret_aqui');
```

### 2. Generar Credenciales de API en WooCommerce

1. Ve a tu panel de WordPress
2. Navega a **WooCommerce > ConfiguraciÃ³n > Avanzado > REST API**
3. Haz clic en **AÃ±adir clave**
4. Configura:
   - DescripciÃ³n: "Visor de Pedidos Externo"
   - Usuario: Selecciona un usuario administrador
   - Permisos: **Lectura**
5. Copia las claves generadas al archivo `config.php`

### 3. ConfiguraciÃ³n del Servidor

- AsegÃºrate de que PHP estÃ© instalado (versiÃ³n 7.4 o superior)
- Habilita las extensiones: `curl`, `json`
- Configura permisos de escritura en la carpeta `cache` (se crea automÃ¡ticamente)

## Estructura de Archivos

```
external-orders-viewer/
â”œâ”€â”€ config.php              # ConfiguraciÃ³n principal
â”œâ”€â”€ api_client.php           # Cliente para API de WooCommerce
â”œâ”€â”€ api.php                  # Endpoint de la API local
â”œâ”€â”€ index.html               # PÃ¡gina principal
â”œâ”€â”€ assets/
â”‚   â”œâ”€â”€ style.css           # Estilos CSS
â”‚   â””â”€â”€ script.js           # JavaScript principal
â”œâ”€â”€ cache/                   # Directorio de cache (se crea automÃ¡ticamente)
â””â”€â”€ README.md               # Esta documentaciÃ³n
```

## Funcionalidades

### CaracterÃ­sticas Principales

- **Dashboard con EstadÃ­sticas**: Visualiza totales de pedidos, iglesias y recaudaciÃ³n
- **Lista de Pedidos**: Muestra todos los pedidos completados del producto de iglesias
- **Filtros Avanzados**: Buscar por iglesia, pastor, email; filtrar por fecha y cantidad
- **Detalles Completos**: Modal con informaciÃ³n detallada de cada pedido
- **ExportaciÃ³n CSV**: Descarga datos filtrados en formato CSV
- **Cache Inteligente**: Sistema de cache para mejorar rendimiento
- **Responsive**: DiseÃ±o adaptable para mÃ³viles y tablets

### Datos Mostrados

Para cada pedido se muestra:
- NÃºmero de pedido
- Fecha de creaciÃ³n
- Nombre de la iglesia/ministerio
- Nombre del pastor/representante
- InformaciÃ³n de contacto (email, telÃ©fono)
- NÃºmero de iglesias representadas
- Detalles de participaciÃ³n econÃ³mica
- Total del pedido

## Uso

1. **InstalaciÃ³n**: Sube los archivos a tu servidor web
2. **ConfiguraciÃ³n**: Edita `config.php` con tus credenciales
3. **Acceso**: Navega a `index.html` en tu navegador
4. **Permisos**: AsegÃºrate de que el directorio tenga permisos de escritura para el cache

### Filtros Disponibles

- **BÃºsqueda de texto**: Busca en nombre de iglesia, pastor o email
- **Filtro de fecha**: Hoy, esta semana, este mes, este aÃ±o
- **Filtro de cantidad**: Rangos de importes econÃ³micos

## Seguridad

- Las credenciales de API solo tienen permisos de **lectura**
- No se almacenan datos sensibles en el cache
- Todas las peticiones son validadas
- Sistema de cache con expiraciÃ³n automÃ¡tica

## SoluciÃ³n de Problemas

### Error "cURL Error" o "HTTP Error 401"
- Verifica las credenciales de API en `config.php`
- AsegÃºrate de que la URL base sea correcta
- Confirma que las claves de API estÃ©n activas

### Error "No se encontraron pedidos"
- Verifica que existan pedidos completados para el producto ID 5029
- Comprueba que el producto estÃ© configurado correctamente

### Problemas de Cache
- Elimina manualmente la carpeta `cache` para forzar actualizaciÃ³n
- Verifica permisos de escritura en el directorio

### Error de CORS
- Si usas desde un dominio diferente, configura CORS en tu WordPress
- AsegÃºrate de que el servidor permita peticiones desde el origen

## PersonalizaciÃ³n

### Cambiar ID del Producto
Edita `config.php` y modifica:
```php
define('IGLESIAS_PRODUCT_ID', 5029); // Cambia por el ID correcto
```

### Ajustar Cache
Modifica la duraciÃ³n del cache en `config.php`:
```php
define('CACHE_DURATION', 300); // 5 minutos en segundos
```

### Personalizar Estilos
Edita `assets/style.css` para cambiar la apariencia visual.

## Requisitos del Sistema

- **PHP**: 7.4 o superior
- **Extensiones**: curl, json, file system access
- **WordPress**: 5.0 o superior
- **WooCommerce**: 3.0 o superior
- **Navegador**: Moderno con soporte para ES6

## Soporte

Para problemas o consultas:
1. Verifica la configuraciÃ³n siguiendo esta documentaciÃ³n
2. Revisa los logs de PHP para errores especÃ­ficos
3. Confirma que las credenciales de API funcionen correctamentePK     ü‘-\nÊó³¯   ¯   ,  cache/a8489bc680339ef84def3b1b71aa368a.cachenu „[µü¤        a:2:{s:7:"expires";i:1765354505;s:4:"data";a:4:{s:12:"total_orders";i:12;s:12:"total_amount";d:2002;s:14:"total_churches";i:15;s:17:"average_per_order";d:166.83333333333334;}}PK     ü‘-\'´¥³%  %  ,  cache/fd96ab23b60c6e6b67e56886ae090b30.cachenu „[µü¤        a:2:{s:7:"expires";i:1763637401;s:4:"data";a:12:{s:2:"id";i:5090;s:6:"number";s:4:"5090";s:6:"status";s:9:"completed";s:5:"total";d:200;s:12:"date_created";s:19:"2025-11-18T12:54:37";s:11:"church_name";s:32:"Nueva Sion San Pedro Del Pinatar";s:11:"pastor_name";s:19:"Gustavo Camps Parra";s:13:"billing_email";s:0:"";s:13:"billing_phone";s:0:"";s:15:"billing_address";s:0:"";s:14:"total_churches";i:1;s:21:"participation_details";a:1:{i:0;a:3:{s:6:"church";s:9:"Iglesia 1";s:11:"description";s:27:"hasta 100 miembros - 200â‚¬";s:6:"amount";d:200;}}}}PK     ü‘-\ï¶Ìë  ë  ,  cache/8219db266264aaa2e76e0d81848f80b9.cachenu „[µü¤        a:2:{s:7:"expires";i:1763637480;s:4:"data";a:12:{s:2:"id";i:5054;s:6:"number";s:4:"5054";s:6:"status";s:9:"completed";s:5:"total";d:1;s:12:"date_created";s:19:"2025-11-12T08:02:39";s:11:"church_name";s:6:"church";s:11:"pastor_name";s:15:"ANGEL FERNANDEZ";s:13:"billing_email";s:0:"";s:13:"billing_phone";s:0:"";s:15:"billing_address";s:0:"";s:14:"total_churches";i:3;s:21:"participation_details";a:3:{i:0;a:3:{s:6:"church";s:9:"Iglesia 1";s:11:"description";s:26:"hasta 50 miembros - 150â‚¬";s:6:"amount";d:150;}i:1;a:3:{s:6:"church";s:9:"Iglesia 2";s:11:"description";s:27:"hasta 200 miembros - 300â‚¬";s:6:"amount";d:300;}i:2;a:3:{s:6:"church";s:9:"Iglesia 3";s:11:"description";s:33:"cantidad personalizada - 445.9â‚¬";s:6:"amount";d:445.9;}}}}PK     ü‘-\!Àõ2   2   ,  cache/b85b9af1226c289e7795064bf72d052e.cachenu „[µü¤        a:2:{s:7:"expires";i:1765354209;s:4:"data";a:0:{}}PK     ü‘-\²ýhª  ª    api_client.phpnu „[µü¤        <?php
require_once 'config.php';

/**
 * Clase para manejar las conexiones con la API de WooCommerce
 */
class WooCommerceAPI {
    
    private $consumer_key;
    private $consumer_secret;
    private $base_url;
    
    public function __construct() {
        $this->consumer_key = WC_CONSUMER_KEY;
        $this->consumer_secret = WC_CONSUMER_SECRET;
        $this->base_url = WP_API_BASE_URL . '/wp-json/wc/v3/';
    }
    
    /**
     * Realizar peticiÃ³n GET a la API de WooCommerce
     */
    private function makeRequest($endpoint, $params = []) {
        $url = $this->base_url . $endpoint;
        
        // AÃ±adir autenticaciÃ³n como parÃ¡metros de query
        $params['consumer_key'] = $this->consumer_key;
        $params['consumer_secret'] = $this->consumer_secret;
        
        $url .= '?' . http_build_query($params);
        
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_TIMEOUT, 30);
        curl_setopt($ch, CURLOPT_USERAGENT, 'WordPress API Client');
        
        $response = curl_exec($ch);
        $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        
        if (curl_error($ch)) {
            throw new Exception('cURL Error: ' . curl_error($ch));
        }
        
        curl_close($ch);
        
        if ($httpCode !== 200) {
            throw new Exception("HTTP Error {$httpCode}: " . $response);
        }
        
        return json_decode($response, true);
    }
    
    /**
     * Obtener pedidos completados con paginaciÃ³n
     */
    public function getCompletedOrders($page = 1, $per_page = ITEMS_PER_PAGE) {
        $params = [
            'status' => 'completed',
            'page' => $page,
            'per_page' => $per_page,
            'order' => 'desc',
            'orderby' => 'date'
        ];
        
        return $this->makeRequest('orders', $params);
    }
    
    /**
     * Obtener pedidos completados filtrados por producto especÃ­fico
     */
    public function getCompletedOrdersByProduct($product_id, $page = 1, $per_page = ITEMS_PER_PAGE) {
        // Primero obtenemos todos los pedidos completados
        $orders = $this->getCompletedOrders($page, $per_page);
        
        // Filtramos los que contienen el producto especÃ­fico
        $filtered_orders = [];
        
        foreach ($orders as $order) {
            foreach ($order['line_items'] as $item) {
                if ($item['product_id'] == $product_id) {
                    $filtered_orders[] = $order;
                    break; // Solo necesitamos encontrar uno para incluir el pedido
                }
            }
        }
        
        return $filtered_orders;
    }
    
    /**
     * Obtener detalles de un pedido especÃ­fico
     */
    public function getOrderDetails($order_id) {
        return $this->makeRequest("orders/{$order_id}");
    }
    
    /**
     * Obtener informaciÃ³n del producto
     */
    public function getProduct($product_id) {
        return $this->makeRequest("products/{$product_id}");
    }
    
    /**
     * Obtener estadÃ­sticas resumidas
     */
    public function getOrderStats($product_id) {
        try {
            // Obtener TODOS los pedidos completados, pÃ¡gina por pÃ¡gina
            $all_orders = [];
            $page = 1;
            $per_page = 100; // MÃ¡s pedidos por pÃ¡gina para ser eficiente
            
            do {
                $orders = $this->getCompletedOrders($page, $per_page);
                
                // Filtrar solo los pedidos que contienen el producto especÃ­fico
                foreach ($orders as $order) {
                    foreach ($order['line_items'] as $item) {
                        if ($item['product_id'] == $product_id) {
                            $all_orders[] = $order;
                            break; // Solo necesitamos encontrar uno para incluir el pedido
                        }
                    }
                }
                
                $page++;
                
                // Continuar solo si obtuvimos el mÃ¡ximo de pedidos (indica que hay mÃ¡s pÃ¡ginas)
                // Pero tambiÃ©n poner un lÃ­mite de seguridad para evitar loops infinitos
            } while (count($orders) == $per_page && $page <= 50);
            
            $total_orders = count($all_orders);
            $total_amount = 0;
            $total_churches = 0;
            
            foreach ($all_orders as $order) {
                $total_amount += floatval($order['total']);
                
                // Buscar metadatos de nÃºmero de iglesias en los line items
                foreach ($order['line_items'] as $item) {
                    if ($item['product_id'] == $product_id) {
                        foreach ($item['meta_data'] as $meta) {
                            if ($meta['key'] === 'NÃºmero de Iglesias') {
                                $total_churches += intval($meta['value']);
                                break;
                            }
                        }
                        break; // Ya encontramos el producto, no necesitamos seguir buscando
                    }
                }
            }
            
            return [
                'total_orders' => $total_orders,
                'total_amount' => $total_amount,
                'total_churches' => $total_churches,
                'average_per_order' => $total_orders > 0 ? $total_amount / $total_orders : 0
            ];
            
        } catch (Exception $e) {
            error_log("Error getting order stats: " . $e->getMessage());
            return [
                'error' => $e->getMessage(),
                'total_orders' => 0,
                'total_amount' => 0,
                'total_churches' => 0,
                'average_per_order' => 0
            ];
        }
    }
}

/**
 * Clase para manejar cache simple en archivos
 */
class SimpleCache {
    
    private $cache_dir;
    
    public function __construct($cache_dir = 'cache') {
        $this->cache_dir = $cache_dir;
        if (!is_dir($this->cache_dir)) {
            mkdir($this->cache_dir, 0755, true);
        }
    }
    
    /**
     * Guardar datos en cache
     */
    public function set($key, $data, $duration = CACHE_DURATION) {
        $cache_file = $this->cache_dir . '/' . md5($key) . '.cache';
        $cache_data = [
            'expires' => time() + $duration,
            'data' => $data
        ];
        
        file_put_contents($cache_file, serialize($cache_data));
    }
    
    /**
     * Obtener datos del cache
     */
    public function get($key) {
        $cache_file = $this->cache_dir . '/' . md5($key) . '.cache';
        
        if (!file_exists($cache_file)) {
            return false;
        }
        
        $cache_data = unserialize(file_get_contents($cache_file));
        
        if (time() > $cache_data['expires']) {
            unlink($cache_file);
            return false;
        }
        
        return $cache_data['data'];
    }
    
    /**
     * Limpiar cache expirado
     */
    public function cleanup() {
        $files = glob($this->cache_dir . '/*.cache');
        $cleaned = 0;
        
        foreach ($files as $file) {
            $cache_data = unserialize(file_get_contents($file));
            if (time() > $cache_data['expires']) {
                unlink($file);
                $cleaned++;
            }
        }
        
        return $cleaned;
    }
}PK     ü‘-\Ö†Ü4s  s  
  config.phpnu „[µü¤        <?php
/**
 * ConfiguraciÃ³n para conectar con la API de WordPress/WooCommerce
 */

// URL base de tu sitio WordPress
define('WP_API_BASE_URL', 'https://dev2.donacion.alospiesdelrey.org');

// Credenciales de la API REST de WooCommerce
// Estas se crean en WooCommerce > ConfiguraciÃ³n > Avanzado > REST API
define('WC_CONSUMER_KEY', 'ck_8596559a16f803a7af96fc26cb1460d76e5def12');
define('WC_CONSUMER_SECRET', 'cs_940416f5ddf502129cc86ae3929da4437da528c5');

// ID del producto especÃ­fico (iglesias)
define('IGLESIAS_PRODUCT_ID', 5029);

// ConfiguraciÃ³n de la base de datos (opcional, si quieres cache local)
define('DB_HOST', 'alospiesjsvidawp.mysql.db');
define('DB_NAME', 'alospiesjsvidawp');
define('DB_USER', 'alospiesjsvidawp');
define('DB_PASS', 'Rtvidawp19');

// ConfiguraciÃ³n general
define('ITEMS_PER_PAGE', 20);
define('CACHE_DURATION', 300); // 5 minutos en segundosPK     ü‘-\Þ°# z  z  
  setup.htmlnu „[µü¤        <!DOCTYPE html>
<html lang="es">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>ConfiguraciÃ³n - Visor de Pedidos</title>
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            min-height: 100vh;
            padding: 20px;
        }
        
        .setup-container {
            max-width: 800px;
            margin: 0 auto;
            background: white;
            border-radius: 15px;
            padding: 30px;
            box-shadow: 0 20px 60px rgba(0,0,0,0.1);
        }
        
        .setup-header {
            text-align: center;
            margin-bottom: 30px;
        }
        
        .setup-header h1 {
            color: #2c3e50;
            font-size: 2.5rem;
            margin-bottom: 10px;
        }
        
        .setup-header p {
            color: #7f8c8d;
            font-size: 1.1rem;
        }
        
        .step {
            background: #f8f9fa;
            border-radius: 10px;
            padding: 25px;
            margin-bottom: 20px;
            border-left: 4px solid #667eea;
        }
        
        .step h3 {
            color: #2c3e50;
            font-size: 1.3rem;
            margin-bottom: 15px;
        }
        
        .step ol {
            padding-left: 20px;
        }
        
        .step li {
            margin-bottom: 8px;
            color: #555;
            line-height: 1.6;
        }
        
        .config-example {
            background: #2c3e50;
            color: #ecf0f1;
            padding: 20px;
            border-radius: 8px;
            font-family: 'Courier New', monospace;
            font-size: 14px;
            margin: 15px 0;
            overflow-x: auto;
        }
        
        .warning {
            background: #fff3cd;
            color: #856404;
            padding: 15px;
            border-radius: 8px;
            border: 1px solid #ffeaa7;
            margin: 15px 0;
        }
        
        .success {
            background: #d1edff;
            color: #0c5460;
            padding: 15px;
            border-radius: 8px;
            border: 1px solid #bee5eb;
            margin: 15px 0;
        }
        
        .btn {
            background: linear-gradient(135deg, #667eea, #764ba2);
            color: white;
            padding: 12px 25px;
            border: none;
            border-radius: 8px;
            cursor: pointer;
            font-size: 16px;
            text-decoration: none;
            display: inline-block;
            margin-top: 20px;
            transition: transform 0.3s ease;
        }
        
        .btn:hover {
            transform: translateY(-2px);
        }
        
        .test-section {
            text-align: center;
            padding: 30px 0;
            border-top: 2px solid #e9ecef;
            margin-top: 30px;
        }
    </style>
</head>
<body>
    <div class="setup-container">
        <div class="setup-header">
            <h1>ðŸ› ï¸ ConfiguraciÃ³n del Visor de Pedidos</h1>
            <p>Configura el sistema para conectar con tu WordPress/WooCommerce</p>
        </div>

        <div class="step">
            <h3>ðŸ“‹ Paso 1: Configurar Credenciales de API</h3>
            <p>Edita el archivo <strong>config.php</strong> con las credenciales de tu sitio:</p>
            <div class="config-example">
// URL base de tu sitio WordPress
define('WP_API_BASE_URL', '<strong>https://donacion.alospiesdelrey.org</strong>');

// Credenciales de la API REST de WooCommerce
define('WC_CONSUMER_KEY', '<strong>ck_tu_consumer_key_aqui</strong>');
define('WC_CONSUMER_SECRET', '<strong>cs_tu_consumer_secret_aqui</strong>');
            </div>
        </div>

        <div class="step">
            <h3>ðŸ”‘ Paso 2: Generar Claves de API en WooCommerce</h3>
            <ol>
                <li>Ve a tu panel de administraciÃ³n de WordPress</li>
                <li>Navega a <strong>WooCommerce â†’ ConfiguraciÃ³n â†’ Avanzado â†’ REST API</strong></li>
                <li>Haz clic en <strong>"AÃ±adir clave"</strong></li>
                <li>Configura:
                    <ul style="margin-top: 8px; margin-left: 20px;">
                        <li><strong>DescripciÃ³n:</strong> "Visor de Pedidos Externo"</li>
                        <li><strong>Usuario:</strong> Selecciona un administrador</li>
                        <li><strong>Permisos:</strong> <strong>Lectura</strong></li>
                    </ul>
                </li>
                <li>Copia las claves generadas y pÃ©galas en <strong>config.php</strong></li>
            </ol>
        </div>

        <div class="step">
            <h3>âš™ï¸ Paso 3: Verificar Requisitos del Servidor</h3>
            <p>AsegÃºrate de que tu servidor tenga:</p>
            <ul style="margin-left: 20px; margin-top: 10px;">
                <li>âœ… PHP 7.4 o superior</li>
                <li>âœ… ExtensiÃ³n cURL habilitada</li>
                <li>âœ… ExtensiÃ³n JSON habilitada</li>
                <li>âœ… Permisos de escritura para crear directorio cache</li>
            </ul>
        </div>

        <div class="warning">
            <strong>âš ï¸ Importante:</strong> AsegÃºrate de que las credenciales de API tengan SOLO permisos de lectura por seguridad.
        </div>

        <div class="success">
            <strong>âœ… Una vez configurado:</strong> El sistema mostrarÃ¡ todos los pedidos completados del producto de iglesias (ID: 5029) con estadÃ­sticas en tiempo real.
        </div>

        <div class="test-section">
            <h3>ðŸš€ Â¿Todo configurado?</h3>
            <p>Haz clic para probar la conexiÃ³n con tu WordPress</p>
            <a href="index.html" class="btn">Ir al Visor de Pedidos</a>
        </div>
    </div>
</body>
</html>PK     ü‘-\B’¥V¼  ¼    sample_orders.jsonnu „[µü¤        {
  "success": true,
  "data": [
    {
      "order_id": "5148",
      "items": [
        {
          "order_item_id": "2463",
          "church_name": "IGLESIA HERMANOS DE MOLINA",
          "pastor_name": "JOSÃ‰ VERA MANUEL GARCIA",
          "total_churches": "1",
          "contact_email": "manuel.garcia@molinadesegura.es",
          "contact_phone": "679714131",
          "total": "200",
          "meta": {
            "_line_subtotal": "200",
            "_line_subtotal_tax": "0",
            "_line_tax": "0",
            "_line_tax_data": "a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}",
            "_line_total": "200",
            "_product_id": "5029",
            "_qty": "1",
            "_tax_class": "",
            "_variation_id": "0",
            "Correo de Contacto": "manuel.garcia@molinadesegura.es",
            "Iglesia 1": "cantidad personalizada - 200â‚¬",
            "Nombre de la Iglesia/Ministerio": "IGLESIA HERMANOS DE MOLINA",
            "NÃºmero de Iglesias": "1",
            "Pastor / Representante": "JOSÃ‰ VERA MANUEL GARCIA",
            "TelÃ©fono de Contacto": "679714131",
            "Total Real Calculado": "200â‚¬"
          }
        }
      ]
    }
  ]
}
PK     ü‘-\ÑF}Ž      db_orders.phpnu „[µü¤        
<?php
require_once 'config.php';
header('Content-Type: application/json');

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
    echo json_encode(['success' => false, 'message' => 'Error de conexiÃ³n a la base de datos']);
    exit;
}
$conn->set_charset('utf8');

$sql = "SELECT p.ID AS order_id, oi.order_item_id, oim.meta_key, oim.meta_value
FROM tpv_apr_7784posts p
JOIN tpv_apr_7784woocommerce_order_items oi ON oi.order_id = p.ID AND oi.order_item_type = 'line_item'
JOIN tpv_apr_7784woocommerce_order_itemmeta oim ON oim.order_item_id = oi.order_item_id
WHERE p.post_type = 'shop_order'
  AND p.post_status = 'wc-completed'
  AND EXISTS (
    SELECT 1
    FROM tpv_apr_7784woocommerce_order_itemmeta oim2
    WHERE oim2.order_item_id = oi.order_item_id
      AND oim2.meta_key = '_product_id'
      AND oim2.meta_value = '" . IGLESIAS_PRODUCT_ID . "'
  )
ORDER BY p.ID DESC, oi.order_item_id, oim.meta_key";

$result = $conn->query($sql);
$orders = [];
while ($row = $result->fetch_assoc()) {
    $order_id = $row['order_id'];
    $order_item_id = $row['order_item_id'];
    $meta_key = $row['meta_key'];
    $meta_value = $row['meta_value'];
    // Agrupar por pedido y por item
    if (!isset($orders[$order_id])) {
        $orders[$order_id] = [
            'order_id' => $order_id,
            'items' => []
        ];
    }
    if (!isset($orders[$order_id]['items'][$order_item_id])) {
        $orders[$order_id]['items'][$order_item_id] = [
            'order_item_id' => $order_item_id,
            'church_name' => '',
            'pastor_name' => '',
            'total_churches' => '',
            'contact_email' => '',
            'contact_phone' => '',
            'total' => '',
            'meta' => []
        ];
    }
    $orders[$order_id]['items'][$order_item_id]['meta'][$meta_key] = $meta_value;
    // Extraer campos principales para el frontend
    if ($meta_key == 'Nombre de la Iglesia/Ministerio') $orders[$order_id]['items'][$order_item_id]['church_name'] = $meta_value;
    if ($meta_key == 'Pastor / Representante') $orders[$order_id]['items'][$order_item_id]['pastor_name'] = $meta_value;
    if ($meta_key == 'NÃºmero de Iglesias') $orders[$order_id]['items'][$order_item_id]['total_churches'] = $meta_value;
    if ($meta_key == 'Correo de Contacto') $orders[$order_id]['items'][$order_item_id]['contact_email'] = $meta_value;
    if ($meta_key == 'TelÃ©fono de Contacto') $orders[$order_id]['items'][$order_item_id]['contact_phone'] = $meta_value;
    if ($meta_key == '_line_total') $orders[$order_id]['items'][$order_item_id]['total'] = $meta_value;
}
$conn->close();
// Convertir a array indexado para el frontend
$orders_out = array_values(array_map(function($order) {
    $order['items'] = array_values($order['items']);
    return $order;
}, $orders));
echo json_encode(['success' => true, 'data' => $orders_out]);


// Consulta principal: pedidos completados con el producto 5029, todos los metadatos de sus items
$sql = "SELECT p.ID AS order_id, oi.order_item_id, oim.meta_key, oim.meta_value
FROM tpv_apr_7784posts p
JOIN tpv_apr_7784woocommerce_order_items oi ON oi.order_id = p.ID AND oi.order_item_type = 'line_item'
JOIN tpv_apr_7784woocommerce_order_itemmeta oim ON oim.order_item_id = oi.order_item_id
WHERE p.post_type = 'shop_order'
  AND p.post_status = 'wc-completed'
  AND EXISTS (
    SELECT 1
    FROM tpv_apr_7784woocommerce_order_itemmeta oim2
    WHERE oim2.order_item_id = oi.order_item_id
      AND oim2.meta_key = '_product_id'
      AND oim2.meta_value = '" . IGLESIAS_PRODUCT_ID . "'
  )
ORDER BY p.ID DESC, oi.order_item_id, oim.meta_key";

$result = $conn->query($sql);
$orders = [];
while ($row = $result->fetch_assoc()) {
    $order_id = $row['order_id'];
    $order_item_id = $row['order_item_id'];
    $meta_key = $row['meta_key'];
    $meta_value = $row['meta_value'];
    // Agrupar por pedido y por item
    if (!isset($orders[$order_id])) {
        $orders[$order_id] = [
            'order_id' => $order_id,
            'items' => []
        ];
    }
    if (!isset($orders[$order_id]['items'][$order_item_id])) {
        $orders[$order_id]['items'][$order_item_id] = [
            'order_item_id' => $order_item_id,
            'meta' => []
        ];
    }
    $orders[$order_id]['items'][$order_item_id]['meta'][$meta_key] = $meta_value;
}
$conn->close();
// Convertir a array indexado para el frontend
$orders_out = array_values(array_map(function($order) {
    $order['items'] = array_values($order['items']);
    return $order;
}, $orders));
echo json_encode(['success' => true, 'data' => $orders_out]);
PK     ü‘-\˜¹M/ìP  ìP    assets/script.jsnu „[µü¤        // ConfiguraciÃ³n y variables globales
let currentPage = 1;
let totalPages = 1;
let allOrders = [];
let filteredOrders = [];
let isLoading = false;
let ordersCache = {}; // Cache local para detalles de pedidos

// URLs de la API
const API_BASE = 'db_orders.php';

// Elementos DOM
const elements = {
    loading: document.getElementById('loading'),
    errorMessage: document.getElementById('error-message'),
    errorText: document.getElementById('error-text'),
    ordersGrid: document.getElementById('orders-grid'),
    searchInput: document.getElementById('search-input'),
    dateFilter: document.getElementById('date-filter'),
    amountFilter: document.getElementById('amount-filter'),
    refreshBtn: document.getElementById('refresh-btn'),
    exportBtn: document.getElementById('export-btn'),
    prevPageBtn: document.getElementById('prev-page'),
    nextPageBtn: document.getElementById('next-page'),
    pageInfo: document.getElementById('page-info'),
    paginationInfo: document.getElementById('pagination-info'),
    modal: document.getElementById('order-modal'),
    modalTitle: document.getElementById('modal-title'),
    modalBody: document.getElementById('modal-body'),
    modalClose: document.getElementById('modal-close'),
    // EstadÃ­sticas
    totalOrders: document.getElementById('total-orders'),
    totalChurches: document.getElementById('total-churches'),
    totalAmount: document.getElementById('total-amount'),
    averageOrder: document.getElementById('average-order')
};


// ...existing code...

// InicializaciÃ³n cuando se carga la pÃ¡gina (al final para asegurar que loadData estÃ© definida)
document.addEventListener('DOMContentLoaded', function() {
    initializeEventListeners();
    loadData();
});

// Configurar event listeners
function initializeEventListeners() {
    // BÃºsqueda
    elements.searchInput.addEventListener('input', debounce(handleSearch, 300));
    
    // Filtros
    elements.dateFilter.addEventListener('change', handleFilter);
    elements.amountFilter.addEventListener('change', handleFilter);
    
    // Botones de acciÃ³n
    elements.refreshBtn.addEventListener('click', refreshData);
    elements.exportBtn.addEventListener('click', exportToCSV);
    
    // PaginaciÃ³n
    elements.prevPageBtn.addEventListener('click', () => changePage(currentPage - 1));
    elements.nextPageBtn.addEventListener('click', () => changePage(currentPage + 1));
    
    // Modal
    elements.modalClose.addEventListener('click', closeModal);
    elements.modal.addEventListener('click', (e) => {
        if (e.target === elements.modal) closeModal();
    });

// Cerrar modal con ESC (fuera de la funciÃ³n para que loadData estÃ© en el scope global)
document.addEventListener('keydown', (e) => {
    if (e.key === 'Escape' && elements.modal.style.display === 'block') {
        closeModal();
    }
});

// Cargar datos iniciales
async function loadData() {
    showLoading(true);
    hideError();
    
    try {
        // Cargar estadÃ­sticas
        const statsResponse = await fetch(`${API_BASE}?action=stats`);
        const statsData = await statsResponse.json();
        
        if (statsData.success) {
            updateStats(statsData.data);
        }
        
        // Cargar pedidos
        await loadOrders();
        
    } catch (error) {
        console.error('Error loading data:', error);
        showError('Error al cargar los datos: ' + error.message);
    } finally {
        showLoading(false);
    }
}

// Cargar pedidos
async function loadOrders(page = 1) {
    try {
        const response = await fetch(`${API_BASE}?action=orders&page=${page}`);
        const result = await response.json();
        // AdaptaciÃ³n: acceder a los datos igual que script-nuevo.js
        if (result.success && Array.isArray(result.data)) {
            // Transformar pedidos en array plano de items
            allOrders = [];
            result.data.forEach(order => {
                order.items.forEach(item => {
                    allOrders.push({
                        ...item,
                        order_id: order.order_id
                    });
                });
            });
            filteredOrders = [...allOrders];
            applyFilters();
            updatePagination();
            renderOrders();
        } else {
            throw new Error(result.message || 'Error al cargar pedidos');
        }
    } catch (error) {
        console.error('Error loading orders:', error);
        showError('Error al cargar pedidos: ' + error.message);
    }
}

// Actualizar estadÃ­sticas
function updateStats(stats) {
    // Actualizar con animaciÃ³n
    animateNumber(elements.totalOrders, parseInt(stats.total_orders) || 0);
    animateNumber(elements.totalChurches, parseInt(stats.total_churches) || 0);
    animateCurrency(elements.totalAmount, parseFloat(stats.total_amount) || 0);
    animateCurrency(elements.averageOrder, parseFloat(stats.average_per_order) || 0);
}

// Animar nÃºmeros
function animateNumber(element, targetValue) {
    const startValue = 0;
    const duration = 1500;
    const startTime = Date.now();
    
    function updateNumber() {
        const now = Date.now();
        const progress = Math.min((now - startTime) / duration, 1);
        const easeProgress = 1 - Math.pow(1 - progress, 3); // Ease out cubic
        const currentValue = Math.floor(startValue + (targetValue - startValue) * easeProgress);
        
        element.textContent = currentValue.toLocaleString('es-ES');
        
        if (progress < 1) {
            requestAnimationFrame(updateNumber);
        }
    }
    
    updateNumber();
}

// Animar valores monetarios
function animateCurrency(element, targetValue) {
    const startValue = 0;
    const duration = 1500;
    const startTime = Date.now();
    
    function updateCurrency() {
        const now = Date.now();
        const progress = Math.min((now - startTime) / duration, 1);
        const easeProgress = 1 - Math.pow(1 - progress, 3); // Ease out cubic
        const currentValue = startValue + (targetValue - startValue) * easeProgress;
        
        element.textContent = formatCurrency(currentValue);
        
        if (progress < 1) {
            requestAnimationFrame(updateCurrency);
        }
    }
    
    updateCurrency();
}

// Aplicar filtros
function applyFilters() {
    const searchTerm = elements.searchInput.value.toLowerCase().trim();
    const dateFilter = elements.dateFilter.value;
    const amountFilter = elements.amountFilter.value;
    
    filteredOrders = allOrders.filter(order => {
        // Filtro de bÃºsqueda
        if (searchTerm) {
            const searchableText = [
                order.church_name || '',
                order.pastor_name || '',
                order.billing_email || '',
                order.order_number || ''
            ].join(' ').toLowerCase();
            
            if (!searchableText.includes(searchTerm)) {
                return false;
            }
        }
        
        // Filtro de fecha
        if (dateFilter) {
            const orderDate = new Date(order.date_created);
            const now = new Date();
            
            switch (dateFilter) {
                case 'today':
                    if (orderDate.toDateString() !== now.toDateString()) return false;
                    break;
                case 'week':
                    const weekAgo = new Date(now.getTime() - 7 * 24 * 60 * 60 * 1000);
                    if (orderDate < weekAgo) return false;
                    break;
                case 'month':
                    if (orderDate.getMonth() !== now.getMonth() || 
                        orderDate.getFullYear() !== now.getFullYear()) return false;
                    break;
                case 'year':
                    if (orderDate.getFullYear() !== now.getFullYear()) return false;
                    break;
            }
        }
        
        // Filtro de cantidad
        if (amountFilter) {
            const amount = parseFloat(order.total);
            switch (amountFilter) {
                case '0-200':
                    if (amount >= 200) return false;
                    break;
                case '200-500':
                    if (amount < 200 || amount >= 500) return false;
                    break;
                case '500-1000':
                    if (amount < 500 || amount >= 1000) return false;
                    break;
                case '1000+':
                    if (amount < 1000) return false;
                    break;
            }
        }
        
        return true;
    });
    
    currentPage = 1;
    updatePagination();
    renderOrders();
}

// Renderizar pedidos
function renderOrders() {
    const startIndex = (currentPage - 1) * 10;
    const endIndex = startIndex + 10;
    const pageOrders = filteredOrders.slice(startIndex, endIndex);
    
    if (pageOrders.length === 0) {
        elements.ordersGrid.innerHTML = `
            <div style="text-align: center; padding: 40px; color: #7f8c8d;">
                <i class="fas fa-inbox" style="font-size: 48px; margin-bottom: 15px; display: block;"></i>
                <p>No se encontraron pedidos que coincidan con los filtros aplicados.</p>
            </div>
        `;
        return;
    }
    
    elements.ordersGrid.innerHTML = pageOrders.map(item => createOrderCard(item, item.order_id)).join('');
    
    // Actualizar informaciÃ³n de paginaciÃ³n
    const total = filteredOrders.length;
    const showing = Math.min(endIndex, total);
    elements.paginationInfo.textContent = `Mostrando ${startIndex + 1}-${showing} de ${total} pedidos`;
}

// Crear tarjeta de pedido
// ...existing code...
function createOrderCard(item, order_id) {
    const churchesText = item.total_churches > 1 ? 
        `${item.total_churches} iglesias` : 
        `${item.total_churches} iglesia`;
    return `
        <div class="order-card">
            <div class="order-header">
                <div class="order-number">Pedido #${order_id}</div>
                <div class="order-status">Completado</div>
            </div>
            <div class="order-info">
                <div class="order-field">
                    <label>Iglesia/Ministerio</label>
                    <span>${escapeHtml(item.church_name || 'No especificado')}</span>
                </div>
                <div class="order-field">
                    <label>Pastor/Representante</label>
                    <span>${escapeHtml(item.pastor_name || 'No especificado')}</span>
                </div>
                <div class="order-field">
                    <label>Email de Contacto</label>
                    <span>${escapeHtml(item.contact_email || 'No especificado')}</span>
                </div>
                <div class="order-field">
                    <label>TelÃ©fono de Contacto</label>
                    <span>${escapeHtml(item.contact_phone || 'No especificado')}</span>
                </div>
                <div class="order-field">
                    <label>Total</label>
                    <span>${escapeHtml(item.total || 'No especificado')}</span>
                </div>
            </div>
        </div>
    `;
}
}

// Mostrar detalles del pedido en modal
async function showOrderDetails(orderId) {
    // Verificar si ya tenemos los datos en cache local
    const cachedOrder = ordersCache[orderId];
    
    if (cachedOrder && cachedOrder.participation_details) {
        // Usar datos del cache sin hacer llamada a la API
        renderOrderDetails(cachedOrder);
        elements.modal.style.display = 'block';
        return;
    }
    
    try {
        showLoading(true);
        
        const response = await fetch(`${API_BASE}?action=order_details&id=${orderId}`);
        const data = await response.json();
        
        if (data.success) {
            // Actualizar cache local con detalles completos
            ordersCache[orderId] = { ...ordersCache[orderId], ...data.data };
            
            renderOrderDetails(data.data);
            elements.modal.style.display = 'block';
        } else {
            throw new Error(data.message || 'Error al cargar detalles del pedido');
        }
        
    } catch (error) {
        console.error('Error loading order details:', error);
        showError('Error al cargar detalles: ' + error.message);
    } finally {
        showLoading(false);
    }
}

// Renderizar detalles del pedido en el modal
function renderOrderDetails(order) {
    elements.modalTitle.textContent = `Pedido #${order.number}`;
    
    let participationHtml = '';
    
    if (order.participation_details && order.participation_details.length > 0) {
        let totalCalculated = 0;
        
        participationHtml = order.participation_details.map(detail => {
            const amount = parseFloat(detail.amount) || 0;
            totalCalculated += amount;
            
            return `
                <div class="participation-item">
                    <div class="participation-church">${escapeHtml(detail.church || 'Iglesia')}</div>
                    <div class="participation-desc">${escapeHtml(detail.description || 'Sin descripciÃ³n')}</div>
                    <div class="participation-amount">${formatCurrency(amount)}</div>
                </div>
            `;
        }).join('');
        
        // Agregar total final
        participationHtml += `
            <div class="participation-item participation-total">
                <div class="participation-church"><strong>TOTAL</strong></div>
                <div class="participation-desc"></div>
                <div class="participation-amount"><strong>${formatCurrency(order.total)}</strong></div>
            </div>
        `;
    } else {
        participationHtml = `
            <div class="participation-item participation-total">
                <div class="participation-church">Total del pedido</div>
                <div class="participation-desc"></div>
                <div class="participation-amount"><strong>${formatCurrency(order.total)}</strong></div>
            </div>
        `;
    }
    
    elements.modalBody.innerHTML = `
        <div class="detail-section">
            <h4>InformaciÃ³n del Pedido</h4>
            <div class="detail-grid">
                <div class="detail-item">
                    <label>NÃºmero de Pedido</label>
                    <span>#${order.number}</span>
                </div>
                <div class="detail-item">
                    <label>Estado</label>
                    <span>Completado</span>
                </div>
                <div class="detail-item">
                    <label>Fecha</label>
                    <span>${formatDate(order.date_created)}</span>
                </div>
                <div class="detail-item">
                    <label>Total</label>
                    <span style="color: #e74c3c; font-weight: bold;">${formatCurrency(order.total)}</span>
                </div>
            </div>
        </div>
        
        <div class="detail-section">
            <h4>InformaciÃ³n de la Iglesia</h4>
            <div class="detail-grid">
                <div class="detail-item">
                    <label>Nombre de la Iglesia/Ministerio</label>
                    <span>${escapeHtml(order.church_name || 'No especificado')}</span>
                </div>
                <div class="detail-item">
                    <label>Pastor/Representante</label>
                    <span>${escapeHtml(order.pastor_name || 'No especificado')}</span>
                </div>
                <div class="detail-item">
                    <label>TelÃ©fono</label>
                    <span>${escapeHtml(order.billing_phone || 'No especificado')}</span>
                </div>
                <div class="detail-item">
                    <label>Email</label>
                    <span>${escapeHtml(order.billing_email || 'No especificado')}</span>
                </div>
                <div class="detail-item">
                    <label>NÃºmero de Iglesias</label>
                    <span>${order.total_churches || 'No especificado'}</span>
                </div>
                <div class="detail-item">
                    <label>DirecciÃ³n</label>
                    <span>${escapeHtml(order.billing_address || 'No especificada')}</span>
                </div>
            </div>
        </div>
        
        <div class="detail-section">
            <h4>ParticipaciÃ³n EconÃ³mica Detallada</h4>
            <div class="participation-details-enhanced">
                ${participationHtml}
            </div>
        </div>
    `;
}

// Cerrar modal
function closeModal() {
    elements.modal.style.display = 'none';
}

// Cambiar pÃ¡gina
function changePage(newPage) {
    if (newPage < 1 || newPage > totalPages || newPage === currentPage) return;
    
    currentPage = newPage;
    updatePagination();
    renderOrders();
}

// Actualizar paginaciÃ³n
function updatePagination() {
    const itemsPerPage = 10;
    totalPages = Math.ceil(filteredOrders.length / itemsPerPage);
    
    elements.prevPageBtn.disabled = currentPage <= 1;
    elements.nextPageBtn.disabled = currentPage >= totalPages;
    elements.pageInfo.textContent = `PÃ¡gina ${currentPage} de ${totalPages}`;
}

// Manejar bÃºsqueda
function handleSearch() {
    applyFilters();
}

// Manejar filtros
function handleFilter() {
    applyFilters();
}

// Refrescar datos
async function refreshData() {
    if (isLoading) return;
    
    elements.refreshBtn.innerHTML = '<i class="fas fa-sync-alt fa-spin"></i> Actualizando...';
    elements.refreshBtn.disabled = true;
    
    try {
        await loadData();
    } finally {
        elements.refreshBtn.innerHTML = '<i class="fas fa-sync-alt"></i> Actualizar';
        elements.refreshBtn.disabled = false;
    }
}

// Exportar a CSV
function exportToCSV() {
    if (filteredOrders.length === 0) {
        alert('No hay datos para exportar');
        return;
    }
    
    const headers = [
        'NÃºmero de Pedido',
        'Fecha',
        'Iglesia/Ministerio',
        'Pastor/Representante',
        'Email',
        'TelÃ©fono',
        'NÃºmero de Iglesias',
        'Total'
    ];
    
    const csvContent = [
        headers.join(','),
        ...filteredOrders.map(order => [
            order.number,
            formatDate(order.date_created),
            `"${escapeCSV(order.church_name || '')}"`,
            `"${escapeCSV(order.pastor_name || '')}"`,
            `"${escapeCSV(order.billing_email || '')}"`,
            `"${escapeCSV(order.billing_phone || '')}"`,
            order.total_churches || '',
            order.total
        ].join(','))
    ].join('\n');
    
    downloadCSV(csvContent, `pedidos_iglesias_${new Date().toISOString().split('T')[0]}.csv`);
}

// Mostrar/ocultar loading
function showLoading(show) {
    isLoading = show;
    elements.loading.style.display = show ? 'block' : 'none';
    elements.ordersGrid.style.display = show ? 'none' : 'block';
}

// Mostrar error
function showError(message) {
    elements.errorText.textContent = message;
    elements.errorMessage.style.display = 'block';
    elements.ordersGrid.style.display = 'none';
}

// Ocultar error
function hideError() {
    elements.errorMessage.style.display = 'none';
}

// Utilidades
function debounce(func, wait) {
    let timeout;
    return function executedFunction(...args) {
        const later = () => {
            clearTimeout(timeout);
            func(...args);
        };
        clearTimeout(timeout);
        timeout = setTimeout(later, wait);
    };
}

function formatCurrency(amount) {
    return new Intl.NumberFormat('es-ES', {
        style: 'currency',
        currency: 'EUR'
    }).format(amount);
}

function formatDate(dateString) {
    return new Date(dateString).toLocaleDateString('es-ES', {
        year: 'numeric',
        month: 'long',
        day: 'numeric',
        hour: '2-digit',
        minute: '2-digit'
    });
}

function escapeHtml(text) {
    const div = document.createElement('div');
    div.textContent = text;
    return div.innerHTML;
}

function escapeCSV(text) {
    return text.replace(/"/g, '""');
}

function downloadCSV(content, filename) {
    const blob = new Blob([content], { type: 'text/csv;charset=utf-8;' });
    const link = document.createElement('a');
    
    if (link.download !== undefined) {
        const url = URL.createObjectURL(blob);
        link.setAttribute('href', url);
        link.setAttribute('download', filename);
        link.style.visibility = 'hidden';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    }
}PK     ü‘-\ý{öô'  '    assets/script-nuevo.jsnu „[µü¤        // Nuevo script para mostrar los pedidos correctamente

// URL del backend que devuelve el JSON
const API_BASE = '/eventos/external-orders-viewer/db_orders.php';

// Elemento donde se mostrarÃ¡n los pedidos
const ordersContainer = document.getElementById('orders-container');

// FunciÃ³n para crear la tarjeta de cada pedido
function createOrderCard(item, orderId) {
    const card = document.createElement('div');
    card.className = 'order-card';
    card.innerHTML = `
        <h3>Pedido #${orderId}</h3>
        <p><strong>Iglesia/Ministerio:</strong> ${item.church_name || ''}</p>
        <p><strong>Pastor/Representante:</strong> ${item.pastor_name || ''}</p>
        <p><strong>NÃºmero de Iglesias:</strong> ${item.total_churches || ''}</p>
        <p><strong>Correo de Contacto:</strong> ${item.contact_email || ''}</p>
        <p><strong>TelÃ©fono de Contacto:</strong> ${item.contact_phone || ''}</p>
        <p><strong>Total:</strong> ${item.total || ''}â‚¬</p>
        <details>
            <summary>Ver detalles meta</summary>
            <pre>${JSON.stringify(item.meta, null, 2)}</pre>
        </details>
    `;
    return card;
}

// FunciÃ³n para renderizar todos los pedidos
function renderOrders(orders) {
    ordersContainer.innerHTML = '';
    orders.forEach(order => {
        order.items.forEach(item => {
            const card = createOrderCard(item, order.order_id);
            ordersContainer.appendChild(card);
        });
    });
}

// FunciÃ³n para cargar los pedidos desde el backend
async function loadOrders() {
    try {
        const response = await fetch(`${API_BASE}?action=orders`);
        const result = await response.json();
        if (result.success && Array.isArray(result.data)) {
            renderOrders(result.data);
        } else {
            ordersContainer.innerHTML = '<p>No se pudieron cargar los pedidos.</p>';
        }
    } catch (error) {
        ordersContainer.innerHTML = `<p>Error al cargar los pedidos: ${error}</p>`;
    }
}

// Ejecutar al cargar la pÃ¡gina
window.addEventListener('DOMContentLoaded', loadOrders);
PK     ü‘-\@•q¢w(  w(    assets/style.cssnu „[µü¤        * {
    box-sizing: border-box;
    margin: 0;
    padding: 0;
}

body {
    font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    min-height: 100vh;
    color: #333;
}

.container {
    max-width: 1400px;
    margin: 0 auto;
    padding: 20px;
}

/* Header */
.header {
    background: white;
    border-radius: 15px;
    padding: 25px;
    margin-bottom: 20px;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
    display: flex;
    justify-content: space-between;
    align-items: center;
    flex-wrap: wrap;
}

.header h1 {
    color: #2c3e50;
    font-size: 2rem;
    font-weight: 600;
}

.header h1 i {
    color: #e74c3c;
    margin-right: 10px;
}

.header-actions {
    display: flex;
    gap: 10px;
}

/* Botones */
.btn {
    padding: 12px 20px;
    border: none;
    border-radius: 8px;
    cursor: pointer;
    font-size: 14px;
    font-weight: 500;
    display: inline-flex;
    align-items: center;
    gap: 8px;
    transition: all 0.3s ease;
    text-decoration: none;
}

.btn-primary {
    background: linear-gradient(135deg, #667eea, #764ba2);
    color: white;
}

.btn-primary:hover {
    transform: translateY(-2px);
    box-shadow: 0 5px 15px rgba(102, 126, 234, 0.4);
}

.btn-secondary {
    background: linear-gradient(135deg, #11998e, #38ef7d);
    color: white;
}

.btn-secondary:hover {
    transform: translateY(-2px);
    box-shadow: 0 5px 15px rgba(17, 153, 142, 0.4);
}

.btn-outline {
    background: transparent;
    border: 2px solid #667eea;
    color: #667eea;
}

.btn-outline:hover {
    background: #667eea;
    color: white;
}

.btn:disabled {
    opacity: 0.5;
    cursor: not-allowed;
    transform: none;
}

/* EstadÃ­sticas */
.stats-section {
    margin-bottom: 20px;
}

.stats-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
    gap: 20px;
}

.stat-card {
    background: white;
    border-radius: 15px;
    padding: 25px;
    display: flex;
    align-items: center;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
    transition: transform 0.3s ease;
}

.stat-card:hover {
    transform: translateY(-5px);
}

.stat-icon {
    background: linear-gradient(135deg, #667eea, #764ba2);
    color: white;
    width: 60px;
    height: 60px;
    border-radius: 15px;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 24px;
    margin-right: 20px;
}

.stat-info h3 {
    font-size: 2rem;
    font-weight: 700;
    color: #2c3e50;
    margin-bottom: 5px;
}

.stat-info p {
    color: #7f8c8d;
    font-size: 14px;
    font-weight: 500;
}

/* Filtros */
.filters-section {
    background: white;
    border-radius: 15px;
    padding: 25px;
    margin-bottom: 20px;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
}

.filters {
    display: grid;
    grid-template-columns: 1fr auto auto;
    gap: 15px;
    align-items: center;
}

.search-input {
    padding: 12px 20px;
    border: 2px solid #e9ecef;
    border-radius: 8px;
    font-size: 14px;
    transition: border-color 0.3s ease;
}

.search-input:focus {
    outline: none;
    border-color: #667eea;
}

.filter-select {
    padding: 12px 15px;
    border: 2px solid #e9ecef;
    border-radius: 8px;
    background: white;
    cursor: pointer;
    font-size: 14px;
}

/* Loading y Error */
.loading, .error-message {
    text-align: center;
    padding: 40px;
    background: white;
    border-radius: 15px;
    margin: 20px 0;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
}

.loading {
    color: #667eea;
    font-size: 18px;
}

.error-message {
    color: #e74c3c;
    font-size: 16px;
}

.error-message i {
    font-size: 24px;
    margin-bottom: 10px;
    display: block;
}

/* SecciÃ³n de pedidos */
.orders-section {
    background: white;
    border-radius: 15px;
    padding: 25px;
    margin-bottom: 20px;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
}

.section-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 25px;
    padding-bottom: 15px;
    border-bottom: 2px solid #f8f9fa;
}

.section-header h2 {
    color: #2c3e50;
    font-size: 1.5rem;
    font-weight: 600;
}

.pagination-info {
    color: #7f8c8d;
    font-size: 14px;
}

/* Grid de pedidos */
.orders-grid {
    display: grid;
    gap: 20px;
}

.order-card {
    border: 2px solid #f1f3f4;
    border-radius: 12px;
    padding: 20px;
    transition: all 0.3s ease;
    cursor: pointer;
    position: relative;
    overflow: hidden;
}

.order-card:hover {
    border-color: #667eea;
    transform: translateY(-2px);
    box-shadow: 0 5px 20px rgba(102, 126, 234, 0.2);
}

.order-card::before {
    content: '';
    position: absolute;
    top: 0;
    left: 0;
    width: 4px;
    height: 100%;
    background: linear-gradient(135deg, #11998e, #38ef7d);
}

.order-header {
    display: flex;
    justify-content: space-between;
    align-items: flex-start;
    margin-bottom: 15px;
}

.order-number {
    font-weight: 600;
    color: #2c3e50;
    font-size: 16px;
}

.order-status {
    background: #d4edda;
    color: #155724;
    padding: 4px 12px;
    border-radius: 20px;
    font-size: 12px;
    font-weight: 500;
}

.order-info {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 15px;
    margin-bottom: 15px;
}

.order-field {
    display: flex;
    flex-direction: column;
    gap: 2px;
}

.order-field label {
    font-size: 12px;
    color: #7f8c8d;
    font-weight: 500;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

.order-field span {
    color: #2c3e50;
    font-weight: 500;
}

.order-amount {
    color: #e74c3c !important;
    font-weight: 700;
    font-size: 18px;
}

.order-footer {
    display: flex;
    justify-content: space-between;
    align-items: center;
    padding-top: 15px;
    border-top: 1px solid #f1f3f4;
}

.churches-info {
    background: #e3f2fd;
    color: #1565c0;
    padding: 6px 12px;
    border-radius: 20px;
    font-size: 12px;
    font-weight: 500;
}

.order-date {
    color: #7f8c8d;
    font-size: 12px;
}

/* PaginaciÃ³n */
.pagination {
    display: flex;
    justify-content: center;
    align-items: center;
    gap: 20px;
    margin-top: 20px;
}

#page-info {
    color: white;
    font-weight: 500;
    background: rgba(255,255,255,0.2);
    padding: 10px 20px;
    border-radius: 8px;
}

/* Modal */
.modal {
    display: none;
    position: fixed;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: rgba(0,0,0,0.8);
    z-index: 1000;
    animation: fadeIn 0.3s ease;
}

.modal-content {
    position: absolute;
    top: 50%;
    left: 50%;
    transform: translate(-50%, -50%);
    background: white;
    border-radius: 15px;
    max-width: 800px;
    width: 90%;
    max-height: 90%;
    overflow-y: auto;
    animation: slideIn 0.3s ease;
}

.modal-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    padding: 25px;
    border-bottom: 2px solid #f8f9fa;
}

.modal-header h3 {
    color: #2c3e50;
    font-size: 1.5rem;
    font-weight: 600;
}

.modal-close {
    background: none;
    border: none;
    font-size: 24px;
    color: #7f8c8d;
    cursor: pointer;
    padding: 5px;
}

.modal-close:hover {
    color: #e74c3c;
}

.modal-body {
    padding: 25px;
}

.detail-section {
    margin-bottom: 25px;
}

.detail-section h4 {
    color: #2c3e50;
    font-size: 1.2rem;
    font-weight: 600;
    margin-bottom: 15px;
    padding-bottom: 8px;
    border-bottom: 2px solid #f8f9fa;
}

.detail-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 15px;
}

.detail-item {
    background: #f8f9fa;
    padding: 15px;
    border-radius: 8px;
}

.detail-item label {
    font-size: 12px;
    color: #7f8c8d;
    font-weight: 500;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    display: block;
    margin-bottom: 5px;
}

.detail-item span {
    color: #2c3e50;
    font-weight: 500;
    font-size: 14px;
}

.participation-details {
    background: #e8f5e8;
    border: 2px solid #d4edda;
    border-radius: 10px;
    padding: 20px;
    margin-top: 15px;
}

.participation-details-enhanced {
    background: #f8f9fa;
    border: 2px solid #e9ecef;
    border-radius: 10px;
    padding: 20px;
    margin-top: 15px;
}

.participation-item {
    display: grid;
    grid-template-columns: 150px 1fr auto;
    gap: 15px;
    align-items: center;
    padding: 12px 0;
    border-bottom: 1px solid #dee2e6;
}

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

.participation-item.participation-total {
    border-top: 2px solid #28a745;
    margin-top: 10px;
    padding-top: 15px;
    font-weight: bold;
    background: #d4edda;
    margin-left: -20px;
    margin-right: -20px;
    padding-left: 20px;
    padding-right: 20px;
    border-radius: 0 0 8px 8px;
}

.participation-church {
    font-weight: 600;
    color: #495057;
    font-size: 14px;
}

.participation-desc {
    color: #6c757d;
    font-size: 14px;
}

.participation-amount {
    font-weight: bold;
    color: #28a745;
    font-size: 16px;
    text-align: right;
}

/* Animaciones */
@keyframes fadeIn {
    from { opacity: 0; }
    to { opacity: 1; }
}

@keyframes slideIn {
    from {
        opacity: 0;
        transform: translate(-50%, -60%);
    }
    to {
        opacity: 1;
        transform: translate(-50%, -50%);
    }
}

@keyframes pulse {
    0% { transform: scale(1); }
    50% { transform: scale(1.05); }
    100% { transform: scale(1); }
}

.loading i {
    animation: spin 1s linear infinite;
}

@keyframes spin {
    from { transform: rotate(0deg); }
    to { transform: rotate(360deg); }
}

/* Responsive */
@media (max-width: 768px) {
    .container {
        padding: 10px;
    }
    
    .header {
        flex-direction: column;
        align-items: stretch;
        gap: 15px;
    }
    
    .header-actions {
        justify-content: center;
    }
    
    .filters {
        grid-template-columns: 1fr;
    }
    
    .order-info {
        grid-template-columns: 1fr;
    }
    
    .order-footer {
        flex-direction: column;
        align-items: flex-start;
        gap: 10px;
    }
    
    .pagination {
        flex-direction: column;
        gap: 10px;
    }
    
    .modal-content {
        width: 95%;
        margin: 20px;
    }
}PK     ü‘-\©Q­†[  [  
  debug.htmlnu „[µü¤        <!DOCTYPE html>
<html>
<head>
    <title>Debug API</title>
</head>
<body>
    <h1>Debug del API</h1>
    <button onclick="testDebug()">Test Debug</button>
    <button onclick="testStats()">Test Stats</button>
    <pre id="result"></pre>

    <script>
        async function testDebug() {
            try {
                const response = await fetch('api.php?action=debug');
                const data = await response.json();
                document.getElementById('result').textContent = JSON.stringify(data, null, 2);
            } catch (error) {
                document.getElementById('result').textContent = 'Error: ' + error.message;
            }
        }

        async function testStats() {
            try {
                const response = await fetch('api.php?action=stats');
                const data = await response.json();
                document.getElementById('result').textContent = JSON.stringify(data, null, 2);
            } catch (error) {
                document.getElementById('result').textContent = 'Error: ' + error.message;
            }
        }
    </script>
</body>
</html>PK     ü‘-\dLØj  j  
  index.htmlnu „[µü¤        <!DOCTYPE html>
<html lang="es">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Visor de Pedidos - Iglesias</title>
    <link rel="stylesheet" href="assets/style.css">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet">
</head>
<body>
    <div class="container">
        <header class="header">
            <h1><i class="fas fa-church"></i> Visor de Pedidos - ParticipaciÃ³n de Iglesias</h1>
            <div class="header-actions">
                <button id="refresh-btn" class="btn btn-primary">
                    <i class="fas fa-sync-alt"></i> Actualizar
                </button>
                <button id="export-btn" class="btn btn-secondary">
                    <i class="fas fa-download"></i> Exportar CSV
                </button>
            </div>
        </header>

        <div class="stats-section">
            <div class="stats-grid">
                <div class="stat-card">
                    <div class="stat-icon">
                        <i class="fas fa-shopping-cart"></i>
                    </div>
                    <div class="stat-info">
                        <h3 id="total-orders">-</h3>
                        <p>Total Pedidos</p>
                    </div>
                </div>
                
                <div class="stat-card">
                    <div class="stat-icon">
                        <i class="fas fa-church"></i>
                    </div>
                    <div class="stat-info">
                        <h3 id="total-churches">-</h3>
                        <p>Total Iglesias</p>
                    </div>
                </div>
                
                <div class="stat-card">
                    <div class="stat-icon">
                        <i class="fas fa-euro-sign"></i>
                    </div>
                    <div class="stat-info">
                        <h3 id="total-amount">-</h3>
                        <p>Total Recaudado</p>
                    </div>
                </div>
                
                <div class="stat-card">
                    <div class="stat-icon">
                        <i class="fas fa-chart-line"></i>
                    </div>
                    <div class="stat-info">
                        <h3 id="average-order">-</h3>
                        <p>Promedio por Pedido</p>
                    </div>
                </div>
            </div>
        </div>

        <div class="filters-section">
            <div class="filters">
                <input type="text" id="search-input" placeholder="Buscar por iglesia, pastor o email..." class="search-input">
                <select id="date-filter" class="filter-select">
                    <option value="">Todas las fechas</option>
                    <option value="today">Hoy</option>
                    <option value="week">Esta semana</option>
                    <option value="month">Este mes</option>
                    <option value="year">Este aÃ±o</option>
                </select>
                <select id="amount-filter" class="filter-select">
                    <option value="">Todas las cantidades</option>
                    <option value="0-200">0â‚¬ - 200â‚¬</option>
                    <option value="200-500">200â‚¬ - 500â‚¬</option>
                    <option value="500-1000">500â‚¬ - 1000â‚¬</option>
                    <option value="1000+">1000â‚¬+</option>
                </select>
            </div>
        </div>

        <div class="loading" id="loading">
            <i class="fas fa-spinner fa-spin"></i> Cargando pedidos...
        </div>

        <div class="error-message" id="error-message" style="display: none;">
            <i class="fas fa-exclamation-triangle"></i>
            <span id="error-text">Error al cargar los datos</span>
        </div>

        <div class="orders-section">
            <div class="section-header">
                <h2>Pedidos Completados</h2>
                <div class="pagination-info">
                    <span id="pagination-info">Mostrando 0 de 0 pedidos</span>
                </div>
            </div>
            
            <div class="orders-grid" id="orders-container">
                <!-- Los pedidos se cargarÃ¡n aquÃ­ dinÃ¡micamente -->
            </div>
        </div>

        <div class="pagination">
            <button id="prev-page" class="btn btn-outline" disabled>
                <i class="fas fa-chevron-left"></i> Anterior
            </button>
            <span id="page-info">PÃ¡gina 1 de 1</span>
            <button id="next-page" class="btn btn-outline" disabled>
                Siguiente <i class="fas fa-chevron-right"></i>
            </button>
        </div>
    </div>

    <!-- Modal para ver detalles del pedido -->
    <div id="order-modal" class="modal">
        <div class="modal-content">
            <div class="modal-header">
                <h3 id="modal-title">Detalles del Pedido</h3>
                <button class="modal-close" id="modal-close">
                    <i class="fas fa-times"></i>
                </button>
            </div>
            <div class="modal-body" id="modal-body">
                <!-- Contenido del modal se carga dinÃ¡micamente -->
            </div>
        </div>
    </div>

    <!-- <script src="assets/script.js"></script> -->
    <script src="assets/script-nuevo.js"></script>
</body>
</html>PK       ü‘-\ÔŸ)¼,  ,                  api.phpnu „[µü¤        PK       ü‘-\ÂF	¨  ¨  	            ;,  README.mdnu „[µü¤        PK       ü‘-\nÊó³¯   ¯   ,            ?  cache/a8489bc680339ef84def3b1b71aa368a.cachenu „[µü¤        PK       ü‘-\'´¥³%  %  ,            '@  cache/fd96ab23b60c6e6b67e56886ae090b30.cachenu „[µü¤        PK       ü‘-\ï¶Ìë  ë  ,            ¨B  cache/8219db266264aaa2e76e0d81848f80b9.cachenu „[µü¤        PK       ü‘-\!Àõ2   2   ,            ïE  cache/b85b9af1226c289e7795064bf72d052e.cachenu „[µü¤        PK       ü‘-\²ýhª  ª              }F  api_client.phpnu „[µü¤        PK       ü‘-\Ö†Ü4s  s  
            ed  config.phpnu „[µü¤        PK       ü‘-\Þ°# z  z  
            h  setup.htmlnu „[µü¤        PK       ü‘-\B’¥V¼  ¼              Æ  sample_orders.jsonnu „[µü¤        PK       ü‘-\ÑF}Ž                Ä„  db_orders.phpnu „[µü¤        PK       ü‘-\˜¹M/ìP  ìP              —  assets/script.jsnu „[µü¤        PK       ü‘-\ý{öô'  '              @è  assets/script-nuevo.jsnu „[µü¤        PK       ü‘-\@•q¢w(  w(              ­ð  assets/style.cssnu „[µü¤        PK       ü‘-\©Q­†[  [  
            d debug.htmlnu „[µü¤        PK       ü‘-\dLØj  j  
            ù index.htmlnu „[µü¤        PK      K  3   