Example #1
0
            }
        }
        $cont++;
    }
    return array('series_data' => implode(',', $seriesData), 'series_data_min' => $seriesDataMin, 'series_data_max' => $seriesDataMax, 'x_axis' => implode(',', $xAxisCategories));
}
//Países
$countries = array();
$query = 'SELECT id_country, code, nombre, name, idiom FROM ' . DB_FACEBOOK_PREFIX . 'country_3_1 ORDER BY 1;';
$que = db_query($query, array());
while ($fila = mysql_fetch_assoc($que)) {
    $countries[$fila['id_country']] = array('code' => $fila['code'], 'name' => $fila['nombre'], 'name_en' => $fila['name'], 'idiom' => $fila['idiom']);
}
$query = "SELECT id_city, name, slug, id_country FROM " . DB_FACEBOOK_PREFIX . "city_3_1 WHERE active_fb_get_data = 1 AND active = 1;";
$que_cities = db_query($query, array());
$cities_last_update = get_city_date_last_update(mysql_num_rows($que_cities));
while ($city = mysql_fetch_assoc($que_cities)) {
    $id_city = $city['id_city'];
    $name = $city['name'];
    $slug = $city['slug'];
    $country_code = $countries[$city['id_country']]['code'];
    $idiom = !empty($countries[$city['id_country']]['idiom']) ? $countries[$city['id_country']]['idiom'] : 'NULL';
    $country_code = $countries[$city['id_country']]['code'];
    $grow_90 = getCrecimiento($id_city, $cities_last_update, 90);
    $query = "SELECT total_user, total_female, total_male FROM " . DB_FACEBOOK_PREFIX . "record_city_3_1 WHERE id_city = \$1 AND date = '\$2';";
    $que_audience = db_query($query, array($city['id_city'], $cities_last_update));
    if ($audience = mysql_fetch_assoc($que_audience)) {
        $total_user = $audience['total_user'];
        $total_female = $audience['total_female'];
        $total_male = $audience['total_male'];
    }
Example #2
0
<?php

$page = 1;
if (isset($_POST['page']) && is_numeric($_POST['page'])) {
    if ($_POST['page'] < 1) {
        $page = 1;
    } elseif ($_POST['page'] > ceil(MAX_LIST_CITY_COUNT / PAGER_PP)) {
        $page = ceil(MAX_LIST_CITY_COUNT / PAGER_PP);
    } else {
        $page = $_POST['page'];
    }
}
$ultimas_12_semanas = get_city_date_last_update(5 + 8);
//SQL para obtener el ranking de países de la última fecha
$sql = "SELECT fc.id_city id_city, fc.name nombre, total_user, total_female, total_male, c.id_country, c.code code, c.name name, c.nombre countryName\n\t\t\t\t\tFROM record_city rc \n\t\t\t\t\t\tJOIN facebook_city fc \n\t\t\t\t\t\t\tON rc.id_city = fc.id_city \n\t\t\t\t\t\tJOIN country c \n\t\t\t\t\t\t\tON fc.id_country = c.id_country \n\t\t\t\t\tWHERE date = STR_TO_DATE('" . CITY_DATE_LAST_UPDATE . "','%Y-%m-%d') \n\t\t\t\t\tORDER BY 3 DESC\n\t\t\t\t\tLIMIT " . PAGER_PP * ($page - 1) . ", " . PAGER_PP . ";\n\t\t\t\t";
$res = mysql_query($sql) or die(mysql_error());
$cont = 1 + PAGER_PP * ($page - 1);
while ($fila = mysql_fetch_assoc($res)) {
    $crecimiento = $fila['total_user'] - get_city_total_audience_for_date($fila['id_city'], $ultimas_12_semanas);
    $class_crecimiento = '';
    if ($crecimiento > 0) {
        $class_crecimiento = 'owloo_arrow_up';
    } else {
        if ($crecimiento < 0) {
            $crecimiento *= -1;
            $class_crecimiento = 'owloo_arrow_down';
        }
    }
    ?>
                <div class="owloo_ranking_item">
                    <div class="owloo_rank"><?php 
Example #3
0
{
    return 71;
}
function get_fb_page_total_rows_count($hispanic = '')
{
    return 1738;
}
function get_country_data($id_country, $columna)
{
    return 'MX';
}
function get_city_date_last_update($numSemanas = 1)
{
    return '2014-03-17';
}
define('CITY_DATE_LAST_UPDATE', get_city_date_last_update());
function get_city_top($countryCode, $count)
{
    return json_decode('
[{"id_city":"2001","nombre":"New Delhi","total_user":"******","total_female":"1700000","total_male":"4600000"},{"id_city":"2002","nombre":"Mumbai","total_user":"******","total_female":"1760000","total_male":"4200000"},{"id_city":"2003","nombre":"Bangalore","total_user":"******","total_female":"1240000","total_male":"3200000"},{"id_city":"2004","nombre":"Hyderabad","total_user":"******","total_female":"1000000","total_male":"3000000"},{"id_city":"2005","nombre":"Chennai","total_user":"******","total_female":"940000","total_male":"2800000"}]', true);
}
function get_owloo_ads($size)
{
    switch ($size) {
        case '728x90':
            return '
                    <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                    <!-- Owloo 728x90 -->
                    <ins class="adsbygoogle"
                         style="display:inline-block;width:728px;height:90px"
                         data-ad-client="ca-pub-2178667345797931"
<?php

require_once '../owloo_config.php';
/************************************************ ULTIMOS 30 DIAS *********************************************************/
$ultimos30Dias = get_city_date_last_update(5);
//Obtenemos todos los países de Hispoamérica
$_hh_countries = array();
$sql = "SELECT id_country\n                FROM `country`\n                WHERE `habla_hispana` =1;\n                ";
$que = mysql_query($sql) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
    $_hh_countries[] = $fila['id_country'];
}
//Obtenemos todas las ciudades de Hispoamérica
$_hh_cities = array();
$sql = "SELECT id_city \n                FROM `facebook_city` \n                WHERE id_country IN(" . implode(',', $_hh_countries) . ");\n                ";
$que = mysql_query($sql) or die(mysql_error());
while ($fila = mysql_fetch_assoc($que)) {
    $_hh_cities[] = $fila['id_city'];
}
//Vaciamos la tala auxiliar
$sql = "TRUNCATE TABLE record_city_grow_temp;\n                ";
$que = mysql_query($sql) or die(mysql_error());
//Registramos el crecimiento de los últimos 30 días de las ciudades de Hispanoamérica
$sql = "INSERT INTO record_city_grow_temp (id_city, period, date_start, date_end, total_user, cambio) SELECT DISTINCT id_city, 30, date, STR_TO_DATE('" . $ultimos30Dias . "','%Y-%m-%d'), total_user, (total_user - (\n                            SELECT total_user \n                            FROM record_city \n                            WHERE date = STR_TO_DATE('" . $ultimos30Dias . "','%Y-%m-%d') \n                                AND id_city = rc1.id_city\n                    )) cambio\n                FROM record_city rc1\n                WHERE date = STR_TO_DATE('" . CITY_DATE_LAST_UPDATE . "','%Y-%m-%d')\n                    AND id_city IN(" . implode(',', $_hh_cities) . ")\n                ORDER BY 6 DESC, 5 ASC;\n                ";
$que = mysql_query($sql) or die(mysql_error());
$ultimos90Dias = get_city_date_last_update(5 + 8);
//Registramos el crecimiento de los últimos 90 días de las ciudades de Hispanoamérica
$sql = "INSERT INTO record_city_grow_temp (id_city, period, date_start, date_end, total_user, cambio) SELECT DISTINCT id_city, 90, date, STR_TO_DATE('" . $ultimos90Dias . "','%Y-%m-%d'), total_user, (total_user - (\n                            SELECT total_user \n                            FROM record_city \n                            WHERE date = STR_TO_DATE('" . $ultimos90Dias . "','%Y-%m-%d') \n                                AND id_city = rc1.id_city\n                    )) cambio\n                FROM record_city rc1\n                WHERE date = STR_TO_DATE('" . CITY_DATE_LAST_UPDATE . "','%Y-%m-%d')\n                    AND id_city IN(" . implode(',', $_hh_cities) . ")\n                ORDER BY 6 DESC, 5 ASC;\n                ";
$que = mysql_query($sql) or die(mysql_error());