//echo ''.$sql_default.'\n';
$sql_default = mysql_query($sql_default) or die(mysql_error());
$count_default = mysql_num_rows($sql_default);
if ($count_default > 0) {
$cpi_value = array();
$cpi_growth = array();
$cpi_growth_first = array();
$cpi_growth_year = array();
$cpi_time = array();
$cpi_rose = 0;
$previous = 0;
$first_value = 0;
$last_value = 0;
while ($row = mysql_fetch_array($sql_default)) {
$period = $row['time_cpi_' . $table_search];
$value_yearback = getyearbackValue('cpi_' . $table_search . '_value', $table_search, 'id_' . $table_search, '' . $byDefaut, $period);
$total = $row['cpi_' . $table_search . '_value'];
if ($previous === 0) {
$growth = ($total / $pvalue - 1) * 100;
$growth_first = 0;
$first_value = $total;
$growth_year = ($total / $value_yearback - 1) * 100;
} else {
$growth = ($total / $previous - 1) * 100;
$growth_first = ($total / $first_value - 1) * 100;
$growth_year = ($total / $value_yearback - 1) * 100;
// echo ''.$growth.'<br>';
}
$previous = $total;
$last_value = $total;
// echo 'period:'.$period.':val:'.$total.' <br>';
function getrwandaup()
{
$table_Search = 'group';
$sql_pmonth = "SELECT `cpi_" . $table_Search . "_value`,`time_cpi_" . $table_Search . "` FROM `cpi_data_" . $table_Search . "` WHERE `id_" . $table_Search . "`='00' and `time_cpi_" . $table_Search . "` = (select max(`time_cpi_" . $table_Search . "`)from `cpi_data_" . $table_Search . "` )";
// echo ''.$sql_pmonth;
$sql_pmonth = mysql_query($sql_pmonth);
while ($row = mysql_fetch_array($sql_pmonth)) {
$pvalue = $row['cpi_' . $table_Search . '_value'];
$ptime = $row['time_cpi_' . $table_Search];
$yearbackValue = getyearbackValue("cpi_" . $table_Search . "_value", $table_Search, "id_" . $table_Search, "00", $ptime);
$recentvalue = (floatval($pvalue) / floatval($yearbackValue) - 1) * 100;
return $recentvalue;
}
return 0;
}
