<?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);
}
