//Made in Poland
//Stworzony przez: Andrzej Morawski
//
//
//--------------------------- Dla IOFFE ------------------------------------------------
//error_reporting(7);
//data, wartosc
$dawaj_dzis="select to_char(data,'dd.mm.yyyy'), wartosc from elfin.emer_fundusze_srednia where data = (select max(data) from elfin.emer_fundusze_srednia)";
$dawaj_wczoraj="select to_char(data,'dd.mm.yyyy'), wartosc from elfin.emer_fundusze_srednia where data = (select max(data) from elfin.emer_fundusze_srednia where data < (select max(data) from elfin.emer_fundusze_srednia))";
$dawaj_miesiac="select to_char(data,'dd.mm.yyyy'), wartosc from elfin.emer_fundusze_srednia where data = (select max(data) from elfin.emer_fundusze_srednia where data < sysdate-30)";
$kiciek = new Base;
$kiciek->login();
$IOFEE = $kiciek->take($dawaj_dzis);
$IOFEE_d = $kiciek->take($dawaj_wczoraj);
$IOFEE_m = $kiciek->take($dawaj_miesiac);
//id_funduszu, wyc_data, wyc_wartosc, nazwa_skr, nazwa, zmiana
$querry="select id_funduszu, to_char(wyc_data,'dd.mm.yyyy'), wyc_wartosc, nazwa_skr, nazwa, zmiana "
."from elfin.v_emer_fundusze_wyc order by id_funduszu";
//id_funduszu, wyc_data, wyc_wartosc, nazwa_skr, nawa
$querry2="select id_funduszu, to_char(wyc_data,'dd.mm.yyyy'), wyc_wartosc, nazwa_skr, nazwa "
."from elfin.v_emer_fundusze_pop1mc order by id_funduszu";
// Dane dla "dzisiaj" ;)
$OFE = $kiciek->take($querry);
// Dane dla "miesiac temu" ;)
$OFE_m = $kiciek->take($querry2);
$kiciek->logOff;
//------------------- Dla IOFFE -----------------------
$iofee_sr_d=(str_to_double($IOFEE[0][1])/str_to_double($IOFEE_d[0][1]));
$iofee_sr_m=(str_to_double($IOFEE[0][1])/str_to_double($IOFEE_m[0][1]));
for ($i=0; $i
Sortuj według nazwy kolumny
Wartości jednostek rozrachunkowych OFE |
Data aktualizacji |
if ($order == 0) {?>
Fundusz |
}
else {?>
Fundusz
}?>
if ($order == 1) {?>
Wartość jednostki [zł] |
}
else {?>
Wartość jednostki [zł]
}?>
if ($order == 2) {?>
Zmiana dzienna |
}
else {?>
Zmiana dzienna
}?>
//if ($order == 3) {?>
Zmiana miesięczna |
//} else {?>
//}?>
// Sortowanie asort po .... zalezy od wybranej opcji...
$center='align="center"';
$right='align="right"';
$color = '#ffffff';
$bylo=0;
if ($order == 1) { // Segregowanie po Wartosc jednostki
asort($wartosc_j);
$war = end($wartosc_j);
for ( $u=0; $u $war && $bylo == 0) {
echo "";
echo "".$IOFEE[0][0]." | ";
echo "";
?>
echo "IOFEE | ";
echo "";
echo number_format(str_to_double($IOFEE[0][1]),"1",","," ");
echo " | ";
echo "";
echo number_format(($iofee_sr_d-1)*100,"1",","," ");
echo "% | ";
echo "";
echo number_format(($iofee_sr_m-1)*100,"1",","," ");
echo "% | ";
echo " ";
$bylo++;
$war = next($wartosc_j);
$u--;
}
else {
echo "";
echo "".$OFE[$nr][1]." | ";
?>>
echo $OFE[$nr][3]." | ";
echo "";
echo number_format($war,"1",","," ");
echo " | ";
echo "";
echo number_format($srednia_d[$nr],"1",","," ");
echo "% | ";
echo "";
echo number_format(($srednia_m[$nr]-1)*100,"1",","," ");
echo "% | ";
echo " ";
}
if ($color=='#ffffff') // Zabawa z kolorami
$color = '#DFDDDD';
else
$color = '#ffffff';
$war = prev($wartosc_j);
}
}
else if ($order == 2) { // Segregowanie po Zmiana dzienna
asort($srednia_d);
$war = end($srednia_d);
for ( $u=0; $u $war && $bylo == 0 ) {
echo "";
echo "".$IOFEE[0][0]." | ";
echo "";
?>
echo "IOFEE | ";
echo "";
echo number_format(str_to_double($IOFEE[0][1]),"1",","," ");
echo " | ";
echo "";
echo number_format(($iofee_sr_d-1)*100,"1",","," ");
echo "% | ";
echo "";
echo number_format(($iofee_sr_m-1)*100,"1",","," ");
echo "% | ";
echo " ";
$bylo++;
$war = next($srednia_d);
$u--;
}
else {
echo "";
echo "".$OFE[$nr][1]." | ";
echo ""
?>
echo $OFE[$nr][3]." | ";
echo "";
echo number_format($wartosc_j[$nr],"1",","," ");
echo " | ";
echo "";
echo number_format($war,"1",","," ");
echo "% | ";
echo "";
echo number_format(($srednia_m[$nr]-1)*100,"1",","," ");
echo "% | ";
echo " ";
}
if ($color=='#ffffff') // Zabawa z kolorami
$color = '#DFDDDD';
else
$color = '#ffffff';
$war = prev($srednia_d);
}
}
else if ($order == 3) {// Segregowanie po Zmiana miesieczna
asort($srednia_m);
$war = end($srednia_m);
for ( $u=0; $u $war && $bylo == 0) {
echo "";
echo "".$IOFEE[0][0]." | ";
echo "";
?>
echo "IOFEE | ";
echo "";
echo number_format(str_to_double($IOFEE[0][1]),"1",","," ");
echo " | ";
echo "";
echo number_format(($iofee_sr_d-1)*100,"1",","," ");
echo "% | ";
echo "";
echo number_format(($iofee_sr_m-1)*100,"1",","," ");
echo "% | ";
echo " ";
$bylo++;
$war = next($srednia_m);
$u--;
}
else {
echo "";
echo "".$OFE[$nr][1]." | ";
echo ""
?>
echo $OFE[$nr][3]." | ";
echo "";
echo number_format($wartosc_j[$nr],"1",","," ");
echo " | ";
echo "";
echo number_format($srednia_d[$nr],"1",","," ");
echo "% | ";
echo "";
echo number_format(($war-1)*100,"1",","," ");
echo "% | ";
echo " ";
}
if ($color=='#ffffff') // Zabawa z kolorami
$color = '#DFDDDD';
else
$color = '#ffffff';
$war = prev($srednia_m);
}
}
else if($order == 0) { // Segregowanie po Nazwa funduszu
asort($nazwa_f); ?>
echo $IOFEE[0][0]; ?> |
IOFEE |
echo number_format(str_to_double($IOFEE[0][1]),"1",","," "); ?>
|
echo number_format(($iofee_sr_d-1)*100,"1",","," "); ?>
% |
echo number_format(($iofee_sr_m-1)*100,"1",","," "); ?>
% |
for ($war = reset($nazwa_f); $war; $war = next($nazwa_f)) {
$nr = key($nazwa_f);
?>
echo $OFE[$nr][1]; ?> |
echo $war; ?> |
echo number_format($wartosc_j[$nr],"1",","," "); ?>
|
echo number_format($srednia_d[$nr],"1",","," "); ?>
% |
echo number_format(($srednia_m[$nr]-1)*100,"1",","," "); ?>
% |
if ($color=='#ffffff') // Zabawa z kolorami
$color = '#DFDDDD';
else
$color = '#ffffff';
}
}
?>
include("../com/eis_link.inc"); ?>
|
|