PHP owloo_number_format函数代码示例

function getCrecimientoMobile($days, $idCountry, $total_user)
{
    $crecimiento = '';
    $sql = "SELECT ((rc1.category_18 + rc1.category_19 + rc1.category_20 + rc1.category_21 + rc1.category_22 + rc1.category_23) - (\n\t\t\t\t\t\t\tSELECT (rc2.category_18 + rc2.category_19 + rc2.category_20 + rc2.category_21 + rc2.category_22 + rc2.category_23) \n\t\t\t\t\t\t\tFROM record_country_for_user_preference rc2 \n\t\t\t\t\t\t\tWHERE date = (\n\t\t\t\t\t\t\t\t\tSELECT date \n\t\t\t\t\t\t\t\t\tFROM record_country_for_user_preference \n\t\t\t\t\t\t\t\t\tWHERE DATE_SUB('" . get_last_date_for_user_preference() . "',INTERVAL " . $days . " DAY) <= date \n\t\t\t\t\t\t\t\t\tGROUP BY date \n\t\t\t\t\t\t\t\t\tORDER BY 1 ASC \n\t\t\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\tAND rc2.id_country = " . $idCountry . "\n\t\t\t\t\t\t )) cambio \n\t\t\t\tFROM record_country_for_user_preference rc1 \n\t\t\t\tWHERE date = '" . get_last_date_for_user_preference() . "'\n\t\t\t\t\tAND rc1.id_country = " . $idCountry . ";\n\t\t\t\t";
    $que = mysql_query($sql) or die(mysql_error());
    if ($fila = mysql_fetch_assoc($que)) {
        if ($fila['cambio'] > 0) {
            $crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_up">' . owloo_number_format($fila['cambio']) . '</span>';
            $crecimiento['porcentaje'] = '<span class="owloo_arrow_up_porcent">' . owlooFormatPorcent($fila['cambio'], $total_user) . '%</span>';
        } else {
            if ($fila['cambio'] == 0) {
                $crecimiento['value'] = '<span class="owloo_not_change_audition"><em>sin cambio</em></span>';
                $crecimiento['porcentaje'] = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
            } else {
                $crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_down">' . owloo_number_format($fila['cambio'] * -1) . '</span>';
                $crecimiento['porcentaje'] = '<span class="owloo_arrow_down_porcent">' . owlooFormatPorcent($fila['cambio'] * -1, $total_user) . '%</span>';
            }
        }
    }
    return $crecimiento;
}

" title="" alt="" />
                    </span>
                    <a href="<?php 
    echo URL_ROOT;
    ?>
twitter-stats/userpage/<?php 
    echo $fetchdata["owloo_screen_name"];
    ?>
" title="Datos y estadísticas de <?php 
    echo $fetchdata["owloo_user_name"];
    ?>
 en Twitter">@<?php 
    echo $fetchdata["owloo_screen_name"];
    ?>
</a>
                </div>
                <div class="owloo_description">
                    <?php 
    echo $fetchdata["owloo_user_name"];
    ?>
 tiene <strong><?php 
    echo owloo_number_format($fetchdata["count"]);
    ?>
 de menciones</strong> entre todas las cuentas registradas en el owloo.
                </div>
            </div>
        </div>
		<?php 
}
?>
    <script>window.setTimeout(function(){ load_twitter_avatar() }, 1000);</script>

function getCrecimientoFacebookLocalFansPage($id_page, $id_country, $last_update, $days)
{
    $crecimiento = array();
    $sql = "SELECT likes, (likes - (\n                            SELECT likes \n                            FROM facebook_page_local_fans_country \n                            WHERE id_page = {$id_page}\n                                AND id_country = {$id_country}\n                                AND date = (\n                                        SELECT date \n                                        FROM facebook_page_local_fans_country \n                                        WHERE DATE_SUB('{$last_update}',INTERVAL {$days} DAY) <= date\n                                            AND id_page = {$id_page}\n                                        ORDER BY 1 ASC \n                                        LIMIT 1\n                                    ) \n                        )) cambio \n                FROM facebook_page_local_fans_country\n                WHERE id_page = {$id_page} \n                    AND id_country = {$id_country}\n                    AND date = '{$last_update}';\n                ";
    $que = mysql_query($sql) or die(mysql_error());
    if ($fila = mysql_fetch_assoc($que)) {
        if ($fila['cambio'] > 0) {
            $crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_up">' . owloo_number_format($fila['cambio']) . '</span>';
            $crecimiento['porcentaje'] = '<span class="owloo_arrow_up_porcent">' . owlooFormatPorcent($fila['cambio'], $fila['likes']) . '%</span>';
        } else {
            if ($fila['cambio'] == 0) {
                $crecimiento['value'] = '<span class="owloo_not_change_audition"><em>sin cambio</em></span>';
                $crecimiento['porcentaje'] = '<span class="owloo_not_change_audition"><em>n/a</em></span>';
            } else {
                $crecimiento['value'] = '<span class="owloo_change_audition owloo_arrow_down">' . owloo_number_format($fila['cambio'] * -1) . '</span>';
                $crecimiento['porcentaje'] = '<span class="owloo_arrow_down_porcent">' . owlooFormatPorcent($fila['cambio'] * -1, $fila['likes']) . '%</span>';
            }
        }
    }
    return $crecimiento;
}

    echo URL_ROOT;
    ?>
twitter-stats/userpage/<?php 
    echo $fetchdata["owloo_screen_name"];
    ?>
" title="Datos y estadísticas de <?php 
    echo $fetchdata["owloo_user_name"];
    ?>
 en Twitter">@<?php 
    echo $fetchdata["owloo_screen_name"];
    ?>
</a>
                </div>
                <div class="owloo_description">
                    <?php 
    echo $fetchdata["owloo_user_name"];
    ?>
 actualmente tiene <strong><?php 
    echo owloo_number_format($fetchdata["owloo_followers_count"]);
    ?>
 seguidores</strong> y está <strong>siguiendo a <?php 
    echo owloo_number_format($fetchdata["owloo_following_count"]);
    ?>
 perfiles</strong>.
                </div>
            </div>
        </div>
		<?php 
}
?>
	<script>window.setTimeout(function(){ load_twitter_avatar() }, 1000);</script>

//Estadísticas de Habla Hispana
//Por mes
if ($hh_city_mayor_crec_mes['ciudad'] != '') {
    $hh_city_mayor_crec_mes['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_crec_mes['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_crec_mes['pais'] . '">' . $hh_city_mayor_crec_mes['ciudad'] . '</a>';
    $hh_city_mayor_crec_mes['cambio'] = owloo_number_format($hh_city_mayor_crec_mes['cambio']);
} else {
    $hh_city_mayor_crec_mes['ciudad'] = '<span>sin cambio</span>';
    $hh_city_mayor_crec_mes['cambio'] = '<span>0</span>';
}
if ($hh_city_mayor_decrec_mes['ciudad'] != '') {
    $hh_city_mayor_decrec_mes['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_decrec_mes['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_decrec_mes['pais'] . '">' . $hh_city_mayor_decrec_mes['ciudad'] . '</a>';
    $hh_city_mayor_decrec_mes['cambio'] = owloo_number_format($hh_city_mayor_decrec_mes['cambio']);
} else {
    $hh_city_mayor_decrec_mes['ciudad'] = '<span>sin cambio</span>';
    $hh_city_mayor_decrec_mes['cambio'] = '<span>0</span>';
}
//Por 3 meses
if ($hh_city_mayor_crec_3_meses['ciudad'] != '') {
    $hh_city_mayor_crec_3_meses['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_crec_3_meses['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_crec_3_meses['pais'] . '">' . $hh_city_mayor_crec_3_meses['ciudad'] . '</a>';
    $hh_city_mayor_crec_3_meses['cambio'] = owloo_number_format($hh_city_mayor_crec_3_meses['cambio']);
} else {
    $hh_city_mayor_crec_3_meses['ciudad'] = '<span>sin cambio</span>';
    $hh_city_mayor_crec_3_meses['cambio'] = '<span>0</span>';
}
if ($hh_city_mayor_decrec_3_meses['ciudad'] != '') {
    $hh_city_mayor_decrec_3_meses['ciudad'] = '<a href="' . URL_ROOT . 'facebook-stats/cities/' . convert_to_url_string($hh_city_mayor_decrec_3_meses['country']) . '/" title="Estadísticas de Facebook en ' . $hh_city_mayor_decrec_3_meses['pais'] . '">' . $hh_city_mayor_decrec_3_meses['ciudad'] . '</a>';
    $hh_city_mayor_decrec_3_meses['cambio'] = owloo_number_format($hh_city_mayor_decrec_3_meses['cambio']);
} else {
    $hh_city_mayor_decrec_3_meses['ciudad'] = '<span>sin cambio</span>';
    $hh_city_mayor_decrec_3_meses['cambio'] = '<span>0</span>';
}

        echo $temp_3_local_fans[0]['country'];
        ?>
 es el país con mayor cantidad de fans que siguen a <?php 
        echo $page_data['name'];
        ?>
 en Facebook, seguido por <?php 
        echo $temp_3_local_fans[1]['country'];
        ?>
 con <?php 
        echo owloo_number_format($temp_3_local_fans[1]['fans']);
        ?>
 y <?php 
        echo $temp_3_local_fans[2]['country'];
        ?>
 con <?php 
        echo owloo_number_format($temp_3_local_fans[2]['fans']);
        ?>
.
                    </p>
                    <div class="owloo_ads_content_468x60">
                        <div class="owloo_ads_468x60 owloo_ads_box"><?php 
        echo get_owloo_ads('468x60');
        ?>
</div>
                    </div>
                </div>
            </div>
        </div>
        <div id="owloo_section_fb_local_fans" class="owloo_country_section owloo_country_content_tw_chart">
            <h2>
                Crecimiento de fans en

/"><?php 
    echo $fila['name'];
    ?>
</a>
                    </div>
                    <div class="owloo_fb_ranking_item">
                        <div class="owloo_title owloo_fb_pta_td">PTA</div>
                        <div class="owloo_fb_num_green"><?php 
    echo owlooFormatPorcent($fila['talking_about'], $fila['total_likes']);
    ?>
%</div>
                    </div>
                    <div class="owloo_fb_ranking_item">
                        <div class="owloo_title">Fans totales</div>
                        <div class="owloo_fb_num_green"><?php 
    echo owloo_number_format($fila['total_likes']);
    ?>
</div>
                    </div>
                    <div class="owloo_fb_ranking_item owloo_fb_ranking_item_change_audition">
                        <div class="owloo_title">Semana</div>
                        <div class="owloo_change_audition"><?php 
    echo $crecimiento_fans['semana']['value'];
    ?>
</div>
                    </div>
                    <?php 
    if ($fila['is_verified']) {
        ?>
                    <div class="owloo_fb_ranking_item owloo_no_border">
                        <span class="owloo_fb_page_verified"></span>

<?php

$qry = "";
$qry = $qry . " SELECT owloo_user_id, owloo_hashword, count(owloo_hashword) AS count";
$qry = $qry . " FROM owloo_hashtag";
$qry = $qry . " WHERE owloo_user_id = '" . $update_id . "'";
$qry = $qry . " GROUP BY owloo_hashword, owloo_user_id";
$qry = $qry . " ORDER BY count DESC";
$qry = $qry . " LIMIT 0 , 5";
$qrydata = mysql_query($qry);
$_hashtag = '<table><thead><tr><th>Hashtag</th><th class="owloo_country_table_3">Cantidad</th></tr></thead><tbody>';
while ($fetchdata = mysql_fetch_array($qrydata)) {
    $_hashtag .= '<tr><td>#' . $fetchdata["owloo_hashword"] . '</td><td>' . owloo_number_format($fetchdata["count"]) . '</td></tr>';
}
$_hashtag .= '</tbody></table>';
?>
$(document).ready(function(){
    $("#owloo_tw_chart_5").html('<?php 
echo $_hashtag;
?>
');
    $("#owloo_tw_chart_desc_5").html('Los cinco hashtags más utilizados por @<?php 
echo $_GET['screenname'];
?>
 desde que esta cuenta se encuentra registrada en Owloo.');
});

% de usuarios tienen BlackBerry y el <?php 
echo owlooFormatPorcent($total_intereses_others_mobile_windows, $crecimiento['total_user']);
?>
% prefieren Windows.
                    </p>
                    <div class="owloo_ads_content_468x60">
                        <div class="owloo_ads_468x60 owloo_ads_box"></div>
                    </div>
                </div>
                <div class="owloo_right owloo_country_width_34">
                    <table>
                        <thead>
                            <tr>
                                <th class="owloo_country_table_th" colspan="2">Dispositivos móviles</th>
                                <th class="owloo_country_table_th"><?php 
echo owloo_number_format($intereses_total_mobile_os);
?>
</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>Día</td>
                                <td><?php 
echo $crecimientoMobileUSers['dia']['value'];
?>
</td>
                                <td><?php 
echo $crecimientoMobileUSers['dia']['porcentaje'];
?>
</td>

function get_instagram_last_post($id_profile, $count, $followed_by_count, $data_type = 'last_post')
{
    $media = array();
    $where = '';
    $order_by = '';
    /*if($data_type == 'last_post'){*/
    $order_by = 'created_time DESC';
    /*}elseif($data_type == 'engagement_rate'){
          $where = ' AND created_time >= '.strtotime(date('Y-m-d').' -1 months');
          $order_by = 'engagement DESC';
      }*/
    $qry = ' SELECT id_media, caption_text, type, images_standard_resolution, videos_standard_resolution, filter, comments_count, likes_count, (comments_count + likes_count) engagement, location_latitude, location_longitude, location_name, link, FROM_UNIXTIME(created_time) created_time 
                    FROM ' . DB_INSTAGRAM_PREFIX . 'media
                    WHERE id_profile = $1 AND active = 1 ' . $where . '
                    ORDER BY ' . $order_by . '
                    LIMIT 0 , $2;';
    $que = db_query($qry, array($id_profile, $count));
    $index = 0;
    while ($fila = mysql_fetch_assoc($que)) {
        $media[$index]['type'] = $fila['type'];
        $media[$index]['images_standard_resolution'] = $fila['images_standard_resolution'];
        $media[$index]['videos_standard_resolution'] = $fila['videos_standard_resolution'];
        if ($data_type == 'engagement_rate') {
            $media[$index]['caption_text'] = $fila['caption_text'];
            $media[$index]['filter'] = $fila['filter'];
            $media[$index]['comments_count'] = owloo_number_format($fila['comments_count']);
            $media[$index]['likes_count'] = owloo_number_format($fila['likes_count']);
            $media[$index]['engagement_rate'] = $followed_by_count > 0 ? owlooFormatPorcent(($fila['likes_count'] + $fila['comments_count']) / $followed_by_count * 100) : 0;
            $media[$index]['location'] = array();
            if (!empty($fila['location_latitude'])) {
                $media[$index]['location'] = array('latitude' => $fila['location_latitude'], 'longitude' => $fila['location_longitude'], 'name' => $fila['location_name']);
            }
            $media[$index]['link'] = $fila['link'];
            $media[$index]['created_time'] = $fila['created_time'];
            //$media[$index]['comments'] = get_instagram_medio_comments($fila['id_media'], 5);
        }
        $index++;
    }
    return $media;
}

    ?>
facebook-stats/pages/<?php 
    echo strtolower($fila['username']);
    ?>
/" title="Estadísticas de <?php 
    echo $fila['name'];
    ?>
 en Facebook"><?php 
    echo $fila['name'];
    ?>
</a>
                    </div>
                    <div class="owloo_fb_ranking_item">
                        <div class="owloo_title">Fans totales</div>
                        <div class="owloo_fb_num_green"><?php 
    echo owloo_number_format($fila['likes']);
    ?>
</div>
                    </div>
                    <div class="owloo_fb_ranking_item">
                        <div class="owloo_title owloo_fb_pta_td">PTA</div>
                        <div class="owloo_fb_num_green"><?php 
    echo owlooFormatPorcent($fila['talking_about'], $fila['likes']);
    ?>
%</div>
                    </div>
                    <div class="owloo_fb_ranking_item owloo_fb_ranking_item_change_audition">
                        <div class="owloo_title">Semana</div>
                        <div class="owloo_change_audition"><?php 
    echo $crecimiento_fans['semana']['value'];
    ?>

        </div>
        <h1 class="owloo_main_title_h1 owloo_align_center owloo_fb_engagement_title">
            Datos de <?php 
echo $country_data['nombre'];
?>
 en Facebook
        </h1>
        <div class="owloo_fb_fan_page_country_description">
            <?php 
$country_data_num = getCountryData($country_data['code']);
?>
            <?php 
echo $country_data['nombre'];
?>
 cuenta con <?php 
echo owloo_number_format($country_data_num['total_user']);
?>
 usuarios, de los cuáles el <?php 
echo owlooFormatPorcent($country_data_num['total_female'], $country_data_num['total_user']);
?>
% son mujeres y <?php 
echo owlooFormatPorcent($country_data_num['total_male'], $country_data_num['total_user']);
?>
 son hombres.<br/>
            Actualmente se encuentra en la posición <?php 
echo getRanking($country_data['id_country']);
?>
 en el ranking mundial de Facebook.
            <hr>
            <a href="<?php 
echo URL_ROOT;

    echo owloo_number_format($followers_count);
    ?>
</td>
                            </tr>
                            <tr>
                                <td>Siguiendo</td>
                                <td><?php 
    echo owloo_number_format($following_count);
    ?>
</td>
                            </tr>
                            
                            <tr>
                                <td>Tweets</td>
                                <td><?php 
    echo owloo_number_format($tweetcount);
    ?>
</td>
                            </tr>
                            <tr>
                                <td>Cuenta verificada</td>
                                <td><?php 
    if ($verified == 1) {
        $verimg = '<img src="' . URL_IMAGES . 'owloo_user_verified_account.png" class="owloo_tooltip" title="Cuenta verificada" alt="Si"/>';
    } else {
        $verimg = '<img src="' . URL_IMAGES . 'owloo_tw_not_verified.png" class="owloo_tooltip" title="Cuenta no verificada" alt="No"/>';
    }
    echo $verimg;
    ?>
                                </td>
                            </tr>

                        <div class="owloo_title">
                            <span class="owloo_country_flag" style="background-position:0 <?php 
    echo -20 * ($fila['id_country'] - 1);
    ?>
px"></span>
                            <strong><?php 
    echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
    ?>
</strong>
                        </div>
                        <div class="owloo_description">
                            <?php 
    echo substr($fila['nombre'], 0, strpos($fila['nombre'], ','));
    ?>
 cuenta con <strong><?php 
    echo owloo_number_format($fila['total_user']);
    ?>
 usuarios</strong> de los cuales el <?php 
    echo round($fila['total_female'] * 100 / $fila['total_user'], 2);
    ?>
% son mujeres y <?php 
    echo round($fila['total_male'] * 100 / $fila['total_user'], 2);
    ?>
% son hombres.
                        </div>
                    </div>
                </div>
			<?php 
}
?>
</div>

<?php

$qry = "";
$qry = $qry . " SELECT owloo_user_id, owloo_screenanme , count( owloo_screenanme ) AS count";
$qry = $qry . " FROM owloo_mentions";
$qry = $qry . " WHERE owloo_user_id = '" . $update_id . "'";
$qry = $qry . " GROUP BY owloo_screenanme, owloo_user_id";
$qry = $qry . " ORDER BY count DESC";
$qry = $qry . " LIMIT 0 , 5";
$qrydata = mysql_query($qry);
$_menciones = '<table><thead><tr><th>Menciones</th><th class="owloo_country_table_3">Cantidad</th></tr></thead><tbody>';
while ($fetchdata = mysql_fetch_array($qrydata)) {
    $_menciones .= '<tr><td>@' . $fetchdata["owloo_screenanme"] . '</td><td>' . owloo_number_format($fetchdata["count"]) . '</td></tr>';
}
$_menciones .= '</tbody></table>';
?>
$(document).ready(function(){
    $("#owloo_tw_chart_4").html('<?php 
echo $_menciones;
?>
');
    $("#owloo_tw_chart_desc_4").html('Los cinco perfiles más mencionados de @<?php 
echo $_GET['screenname'];
?>
 desde que esta cuenta se encuentra registrada en Owloo.');
});