getConnection(); $country = strtoupper($_GET['c'] ?? 'CO'); $category = $_GET['cat'] ?? 'todos'; $q = trim($_GET['q'] ?? ''); $team = trim($_GET['team'] ?? ''); if (!in_array($country, ['CO','EC','PE'], true)) $country = 'CO'; $countryMeta = [ 'CO' => ['flag' => '🇨🇴', 'name' => 'Colombia', 'greet' => 'Tu Colombia, en tu bolsillo', 'currency' => 'COP', 'rate_key' => 'cop', 'gradient' => 'linear-gradient(135deg,#fcd34d,#f59e0b 45%,#dc2626 85%)'], 'EC' => ['flag' => '🇪🇨', 'name' => 'Ecuador', 'greet' => 'Tu Ecuador, todo el día', 'currency' => 'USD', 'rate_key' => null, 'gradient' => 'linear-gradient(135deg,#fcd34d,#0048b3 50%,#ed1c24 90%)'], 'PE' => ['flag' => '🇵🇪', 'name' => 'Perú', 'greet' => 'Tu Perú siempre cerca', 'currency' => 'PEN', 'rate_key' => 'pen', 'gradient' => 'linear-gradient(135deg,#d91023,#fff 50%,#d91023 100%)'], ]; $meta = $countryMeta[$country]; $allowed = ['todos','deportes','farandula','economia','politica','breaking','regional','general','tecnologia','loteria']; if (!in_array($category, $allowed, true)) $category = 'todos'; $where = ["fi.country = ?", "fi.status IN ('processed','published','new')", "fi.published_at IS NOT NULL"]; $params = [$country]; if ($category !== 'todos') { $where[] = "(fi.llm_category = ? OR (fi.llm_category IS NULL AND fs.category = ?))"; $params[] = $category; $params[] = $category; } if ($q !== '') { $where[] = "(fi.title LIKE ? OR fi.llm_headline LIKE ?)"; $params[] = "%$q%"; $params[] = "%$q%"; } if ($team !== '') { $where[] = "(fi.title LIKE ? OR fi.llm_entities LIKE ?)"; $params[] = "%$team%"; $params[] = "%\"$team\"%"; } $whereSql = implode(' AND ', $where); $stmt = $pdo->prepare(" SELECT fi.id, fi.title, fi.summary, fi.image_url, fi.url, fi.published_at, fi.llm_headline, fi.llm_category, fi.llm_importance, fi.llm_cross_sell, fs.name AS source_name, fs.category AS source_category, fi.raw_category FROM feed_items fi JOIN feed_sources fs ON fs.id = fi.source_id WHERE $whereSql ORDER BY fi.published_at DESC, fi.id DESC LIMIT 40 "); $stmt->execute($params); $items = $stmt->fetchAll(PDO::FETCH_ASSOC); // Stats por país (para los tabs) $countStmt = $pdo->query(" SELECT country, COUNT(*) AS total, SUM(llm_processed) AS llm_done FROM feed_items WHERE country IN ('CO','EC','PE') GROUP BY country"); $countByCountry = []; foreach ($countStmt as $r) $countByCountry[$r['country']] = $r; // Tipo cambio $ratesFile = '/tmp/practyco_rates.json'; $rate = null; if ($meta['rate_key'] && file_exists($ratesFile)) { $data = json_decode(file_get_contents($ratesFile), true); $rate = $data['data']['tether'][$meta['rate_key']] ?? null; } function timeAgo(string $datetime): string { $diff = time() - strtotime($datetime); if ($diff < 60) return "ahora"; if ($diff < 3600) return floor($diff / 60) . " min"; if ($diff < 86400) return floor($diff / 3600) . " h"; if ($diff < 604800) return floor($diff / 86400) . " d"; return date('d M', strtotime($datetime)); } function categoryColor(string $cat): array { return match($cat) { 'deportes' => ['bg' => '#10b981', 'fg' => '#fff', 'emoji' => '⚽'], 'farandula' => ['bg' => '#ec4899', 'fg' => '#fff', 'emoji' => '🎭'], 'economia' => ['bg' => '#0891b2', 'fg' => '#fff', 'emoji' => '💵'], 'politica' => ['bg' => '#7c3aed', 'fg' => '#fff', 'emoji' => '🏛️'], 'breaking' => ['bg' => '#ef4444', 'fg' => '#fff', 'emoji' => '🚨'], 'regional' => ['bg' => '#f59e0b', 'fg' => '#fff', 'emoji' => '📍'], 'tecnologia' => ['bg' => '#06b6d4', 'fg' => '#fff', 'emoji' => '💻'], 'loteria' => ['bg' => '#eab308', 'fg' => '#000', 'emoji' => '🎰'], default => ['bg' => '#475569', 'fg' => '#fff', 'emoji' => '📰'], }; } function crossSellCta(?string $cs, string $country): ?array { $sendLabel = match($country) { 'CO' => 'Enviar a Colombia', 'EC' => 'Enviar a Ecuador', 'PE' => 'Enviar a Perú', default => 'Enviar remesa', }; return match($cs) { 'dollar_up' => ['icon' => '💵', 'text' => 'Buen momento para enviar plata', 'color' => '#10b981', 'label' => $sendLabel], 'goal' => ['icon' => '⚽', 'text' => 'Manda algo para celebrar', 'color' => '#10b981', 'label' => $sendLabel], 'breaking' => ['icon' => '🆘', 'text' => 'Envía ayuda a tu familia', 'color' => '#ef4444', 'label' => $sendLabel], 'farandula_compra' => ['icon' => '🎁', 'text' => 'Regálale entradas', 'color' => '#ec4899', 'label' => $sendLabel], 'lottery' => ['icon' => '🎉', 'text' => '¿Ganaste? Compártelo', 'color' => '#eab308', 'label' => $sendLabel], default => null, }; } $qsBase = function(array $override = []) use ($country, $category, $q, $team) { $params = array_merge(['c' => $country, 'cat' => $category, 'q' => $q, 'team' => $team], $override); $params = array_filter($params, fn($v) => $v !== '' && $v !== null); return http_build_query($params); }; ?> Mi <?= $meta['name'] ?> · Practyco
🚧 DEMO Practyco · Mi País — el inmigrante latino siempre conectado
$cMeta): $isActive = $cCode === $country ? 'active' : ''; $total = $countByCountry[$cCode]['total'] ?? 0; ?> news

noticias frescas
$ ▲
💵 USD
📰 total 🤖 con LLM
🔍
Sin resultados en . Prueba otra categoría.
= 70): ?> ★
AI
→
💸 Enviar a