Imprimir Rótulos

query("SELECT nombre, codigo_base FROM products"); $product_prefixes = []; while ($row = $stmt_products->fetch(PDO::FETCH_ASSOC)) { $product_prefixes[$row['nombre']] = $row['codigo_base']; } $user_id = $_SESSION['user_id']; $user_role = $_SESSION['user_role'] ?? 'Asesor'; $selected_month = $_GET['mes'] ?? ''; $selected_year = $_GET['año'] ?? ''; $search_query = $_GET['q'] ?? ''; $is_today = isset($_GET['today']); $sql = "SELECT p.* FROM pedidos p WHERE p.estado = 'ROTULADO 📦'"; $params = []; if ($user_role === 'Asesor') { $sql .= " AND p.asesor_id = ?"; $params[] = $user_id; } if (!empty($search_query)) { $sql .= " AND (p.nombre_completo LIKE ? OR p.dni_cliente LIKE ? OR p.celular LIKE ?)"; $params[] = "%$search_query%"; $params[] = "%$search_query%"; $params[] = "%$search_query%"; } if (!empty($selected_month)) { $sql .= " AND MONTH(p.created_at) = ?"; $params[] = $selected_month; } if (!empty($selected_year)) { $sql .= " AND YEAR(p.created_at) = ?"; $params[] = $selected_year; } if ($is_today) { $sql .= " AND DATE(p.created_at) = CURDATE()"; } $sql .= " ORDER BY p.created_at DESC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $pedidos = $stmt->fetchAll(); ?> Imprimir Rótulos

← VOLVER

No hay pedidos rotulados para mostrar.

VARIANTE:

CANT:

AG:

1) { $sede_val = trim($parts[0]) . ' / ' . trim(end($parts)); } } echo 'SEDE: ' . htmlspecialchars($sede_val); ?>