<?php include 'connection.php'; include 'funciones.php'; error_reporting(E_ERROR | E_WARNING | E_PARSE); date_default_timezone_set('America/El_Salvador'); $bolinfo = mysql_query("SELECT nombre, porcentaje, valor, fecha, ciudad from bolsa"); $intinfo = mysql_query("SELECT nombre, porcentaje, fecha from tasainteres"); $divinfo = mysql_query("SELECT nombre, cambio, pais, fecha from divisa"); $datinfo = mysql_query("SELECT indicador, periodo, cifras, enlaceDetalles as enlace from datoseconomicos"); $merinfo = mysql_query("SELECT nombre, descripcion, cambio, porcentaje, menor, masAlto, ultimo, fecha from mercado"); while ($bolpreview = mysql_fetch_array($bolinfo)) { $bolsa[] = array('nombre' => $bolpreview['nombre'], 'fecha' => $bolpreview['fecha'], 'valor' => $bolpreview['valor'], 'ciudad' => $bolpreview['ciudad'], 'porcentaje' => $bolpreview['porcentaje']); } while ($intpreview = mysql_fetch_array($intinfo)) { $interes[] = array('nombre' => $intpreview['nombre'], 'fecha' => $intpreview['fecha'], 'porcentaje' => $intpreview['porcentaje']); } while ($divpreview = mysql_fetch_array($divinfo)) { $divisa[] = array('nombre' => $divpreview['nombre'], 'pais' => $divpreview['pais'], 'fecha' => formatoFecha2($divpreview['fecha']), 'cambio' => $divpreview['cambio']); } while ($datpreview = mysql_fetch_array($datinfo)) { $dato[] = array('indicador' => $datpreview['indicador'], 'periodo' => $datpreview['periodo'], 'cifras' => $datpreview['cifras'], 'enlace' => $datpreview['enlace']); } while ($merpreview = mysql_fetch_array($merinfo)) { $mercado[] = array('nombre' => $merpreview['nombre'], 'descripcion' => $merpreview['descripcion'], 'cambio' => $merpreview['cambio'], 'porcentaje' => $merpreview['porcentaje'], 'menor' => $merpreview['menor'], 'masAlto' => $merpreview['masAlto'], 'fecha' => $merpreview['fecha'], 'ultimo' => $merpreview['ultimo']); } echo json_encode(array('negocios' => articulo(45), 'coyunturas' => articulo(46), 'mundos' => articulo(47), 'mercados' => articulo(48), 'analisiss' => opinion(49), 'bolsas' => $bolsa, 'intereses' => $interes, 'divisas' => $divisa, 'datos' => $dato, 'subsecciones' => subseccion(5), 'mercas' => $mercado, 'banner1' => banner(5, 1), 'banner2' => banner(5, 2), 'banner3' => banner(5, 3), 'banner4' => banner(5, 4), 'bannerMovil' => banner(5, 'movil'), 'leidos' => leidos(5)));
function leidos($idSeccion) { $seccion = ''; $seccion2 = ''; if ($idSeccion == 1) { $info = mysql_query("SELECT a.idArticulo as id, a.titulo, c.url as urlSubseccion, se.url as urlSeccion, i.rutafoto as foto, a.fecha, count(b.idArticulo) as total from articulo a, vistaarticulo b, subseccion c, seccion se, imagenesarticulo i where a.idArticulo = i.idArticulo and i.posicion = 'principal' and (select x.idSeccion from subseccion as x where x.idSubseccion=a.idSubseccion) = {$idSeccion} and a.idArticulo = b.idArticulo and a.activo = 1 and c.idSeccion = se.idSeccion and c.idSubseccion = a.idSubseccion and a.idSubseccion = 6 group by b.idArticulo order by total desc limit 2"); while ($infopreview = mysql_fetch_array($info)) { $seccion[] = array('id' => $infopreview['id'], 'titulo' => $infopreview['titulo'], 'urlSubseccion' => $infopreview['urlSubseccion'], 'urlSeccion' => $infopreview['urlSeccion'], 'total' => $infopreview['total'], 'foto' => $infopreview['foto'], 'fecha' => formatoFecha2($infopreview['fecha'])); } $info2 = mysql_query("SELECT a.idArticulo as id, a.titulo, c.url as urlSubseccion, se.url as urlSeccion, i.rutafoto as foto, a.fecha,count(b.idArticulo) as total from articulo a, vistaarticulo b, subseccion c, seccion se, personal i where a.idPersonal = i.idPersonal and (select x.idSeccion from subseccion as x where x.idSubseccion=a.idSubseccion) = {$idSeccion} and a.idArticulo = b.idArticulo and a.activo = 1 and a.idSubseccion <> 6 and c.idSeccion = se.idSeccion and c.idSubseccion = a.idSubseccion group by b.idArticulo order by total desc limit 2"); while ($info2preview = mysql_fetch_array($info2)) { $seccion2[] = array('id' => $info2preview['id'], 'titulo' => $info2preview['titulo'], 'urlSubseccion' => $info2preview['urlSubseccion'], 'urlSeccion' => $info2preview['urlSeccion'], 'total' => $info2preview['total'], 'foto' => $info2preview['foto'], 'fecha' => formatoFecha2($info2preview['fecha'])); } } else { $info = mysql_query("SELECT a.idArticulo as id, a.titulo, c.url as urlSubseccion, se.url as urlSeccion, i.rutafoto as foto, a.fecha, count(b.idArticulo) as total from articulo a, vistaarticulo b, subseccion c, seccion se, imagenesarticulo i where a.idArticulo = i.idArticulo and i.posicion = 'principal' and (select x.idSeccion from subseccion as x where x.idSubseccion=a.idSubseccion) = {$idSeccion} and a.idArticulo = b.idArticulo and a.activo = 1 and c.idSeccion = se.idSeccion and c.idSubseccion = a.idSubseccion group by b.idArticulo order by total desc limit 4"); while ($infopreview = mysql_fetch_array($info)) { $seccion[] = array('id' => $infopreview['id'], 'titulo' => $infopreview['titulo'], 'urlSubseccion' => $infopreview['urlSubseccion'], 'urlSeccion' => $infopreview['urlSeccion'], 'total' => $infopreview['total'], 'foto' => $infopreview['foto'], 'fecha' => formatoFecha2($infopreview['fecha'])); } } $actinfo = mysql_query("SELECT a.idArticulo as id, a.titulo, s.url as urlSubseccion, se.url as urlSeccion, i.rutafoto as foto, a.fecha, count(b.idArticulo) from articulo a, subseccion as s, seccion se, vistaarticulo b, imagenesarticulo i where a.idArticulo = i.idArticulo and i.posicion = 'principal' and a.idSubseccion = s.idSubseccion and a.activo = 1 and s.idSeccion = se.idSeccion and a.idArticulo = b.idArticulo and a.idSubseccion not in (1,2,3,4,5,6,35,45,46,49,54,57,58,59,60) group by b.idArticulo ORDER BY a.fecha desc, a.hora desc limit 4"); while ($actpreview = mysql_fetch_array($actinfo)) { $actualidad[] = array('id' => $actpreview['id'], 'titulo' => $actpreview['titulo'], 'urlSeccion' => $actpreview['urlSeccion'], 'urlSubseccion' => $actpreview['urlSubseccion'], 'foto' => $actpreview['foto'], 'fecha' => formatoFecha2($actpreview['fecha'])); } return array('seccion' => $seccion, 'seccion2' => $seccion2, 'portada' => $actualidad); }