{source}
<?php
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘instrSysName’, ‘instrCode’, ‘price’, ‘instrName’, ‘pricePrevClosePricePDelta’ )));
$query->from($db->quoteName(‘#__inbroke_info_metoxes’));
$query->order($db->quoteName(‘pricePrevClosePricePDelta’) . ‘DESC’);
$db->setQuery($query);
$res = $db->loadAssocList();
$milivar = $res;
//$milivar = array_multisort($res, array(‘pricePrevClosePricePDelta’=>SORT_DESC));
//usort($res, make_comparer([‘pricePrevClosePricePDelta’, SORT_DESC]));
//echo $res;
//function sort($a, $b) {
// if ($a[‘pricePrevClosePricePDelta’] == $b[‘pricePrevClosePricePDelta’]) return 0;
// return ($a[‘pricePrevClosePricePDelta’] > $b[‘pricePrevClosePricePDelta’]) ? 1 : -1;
//}
//usort($milivar, ‘sort’);
//array_multisort($milivar, ‘pricePrevClosePricePDelta’, SORT_DESC);
$length = count($milivar);
//var_dump($milivar);
echo “<div class=’topupitem’>”;
echo “<h4>Top ανόδου</h4>”;
echo “<div class=’xrti’><span class=’xrt’>Σύμβολο</span> <span class=’xrt’>Τιμή</span> <span class=’xrt’>Μεταβολή</span></div>”;
echo ‘<div class=”scrxrima”>’;
//echo ‘<marquee class=”xrimascroll” id=”scroller” behavior=”scroll” direction=”up” scrollamount=”1″ truespeed=”true” scrolldelay=”30″ onmouseover=”this.stop();” onmouseout=”this.start();” onfinish=”PageReload();”>’;
echo “<div class=’ul’>”;
for ($i = 0; $i < 15; $i++) {
if (($milivar[$i][‘instrCode’])) {
$out = NULL;
$price = NULL;
$priceperc = NULL;
if ($milivar[$i][‘pricePrevClosePricePDelta’] > 0){
$varclass = “green”;
$arrowvar = “arrowup”;
} elseif ($milivar[$i][‘pricePrevClosePricePDelta’] == 0) {
$varclass = “grey”;
$arrowvar = “arrow”;
} else {
$varclass = “red”;
$arrowvar = “arrowdown”;
}
$out .= “<div class=’li’>”;
$out .= ‘<span class=”xrli-a”><a class=”‘.$varclass.'” href=”‘.$milivar[$i][‘instrSysName’].'”>’ ;
$out .= $milivar[$i][‘instrCode’];
$out .= “</a>”;
$out .= “</span>”;
//$out .= ” “;
//$out .= “<span class=’xrli-b $varclass’>”.$milivar[$i][‘instrName’].”</span>”;
//$priceperc = $milivar[$i][‘price’];
//if (empty($priceperc) {
//$price = ” – %”;
//} else
//$priceperc = substr($milivar[$i][‘pricePrevClosePricePDelta’], 0, -2);
$priceperc = round($milivar[$i][‘pricePrevClosePricePDelta’], 2);
if (empty($priceperc)) {
$price = ” – %”;
}
else $price = “$priceperc %”;
//$out .= ” “;
$out .= “<span class=’xrli-c $varclass’>”.$milivar[$i][‘price’].” €</span>”;
$out .= “<span class=’xrli-d $varclass’>”.$price.”</span>”;
$out .= “<span class='”.$arrowvar.”‘><div class='”.$arrowvar.”‘></div></span>”;
$out .= “</div>”;
$out = $out;
print_r ($out);
}
}
echo “</div>”;
//echo “</marquee>”;
echo “</div>”;
echo “</div>”;
?>
<!– top down –>
<?php
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘instrSysName’, ‘instrCode’, ‘price’, ‘instrName’, ‘pricePrevClosePricePDelta’ )));
$query->from($db->quoteName(‘#__inbroke_info_metoxes’));
$query->order($db->quoteName(‘pricePrevClosePricePDelta’) . ‘ASC’);
$db->setQuery($query);
$res = $db->loadAssocList();
$milivar = $res;
//$milivar = array_multisort($res, array(‘pricePrevClosePricePDelta’=>SORT_DESC));
//usort($res, make_comparer([‘pricePrevClosePricePDelta’, SORT_DESC]));
//echo $res;
//function sort($a, $b) {
// if ($a[‘pricePrevClosePricePDelta’] == $b[‘pricePrevClosePricePDelta’]) return 0;
// return ($a[‘pricePrevClosePricePDelta’] > $b[‘pricePrevClosePricePDelta’]) ? 1 : -1;
//}
//usort($milivar, ‘sort’);
//array_multisort($milivar, ‘pricePrevClosePricePDelta’, SORT_DESC);
$length = count($milivar);
//var_dump($milivar);
echo “<div class=’topdownitem’>”;
echo “<h4>Top πτώσης</h4>”;
echo “<div class=’xrti’><span class=’xrt’>Σύμβολο</span> <span class=’xrt’>Τιμή</span> <span class=’xrt’>Μεταβολή</span></div>”;
echo ‘<div class=”scrxrima topdownin”>’;
//echo ‘<marquee class=”xrimascroll” id=”scroller” behavior=”scroll” direction=”up” scrollamount=”1″ truespeed=”true” scrolldelay=”30″ onmouseover=”this.stop();” onmouseout=”this.start();” onfinish=”PageReload();”>’;
echo “<div class=’ul’>”;
for ($i = 0; $i < 15; $i++) {
if (($milivar[$i][‘instrCode’])) {
$out = NULL;
$price = NULL;
$priceperc = NULL;
if ($milivar[$i][‘pricePrevClosePricePDelta’] > 0){
$varclass = “green”;
$arrowvar = “arrowup”;
} elseif ($milivar[$i][‘pricePrevClosePricePDelta’] == 0) {
$varclass = “grey”;
$arrowvar = “arrow”;
} else {
$varclass = “red”;
$arrowvar = “arrowdown”;
}
$out .= “<div class=’li’>”;
$out .= ‘<span class=”xrli-a”><a class=”‘.$varclass.'” href=”‘.$milivar[$i][‘instrSysName’].'”>’ ;
$out .= $milivar[$i][‘instrCode’];
$out .= “</a>”;
$out .= “</span>”;
//$out .= ” “;
//$out .= “<span class=’xrli-b $varclass’>”.$milivar[$i][‘instrName’].”</span>”;
//$priceperc = $milivar[$i][‘price’];
//if (empty($priceperc) {
//$price = ” – %”;
//} else
//$priceperc = substr($milivar[$i][‘pricePrevClosePricePDelta’], 0, -2);
$priceperc = round($milivar[$i][‘pricePrevClosePricePDelta’], 2);
if (empty($priceperc)) {
$price = ” – %”;
}
else $price = “$priceperc %”;
//$out .= ” “;
$out .= “<span class=’xrli-c $varclass’>”.$milivar[$i][‘price’].” €</span>”;
$out .= “<span class=’xrli-d $varclass’>”.$price.”</span>”;
$out .= “<span class='”.$arrowvar.”‘><div class='”.$arrowvar.”‘></div></span>”;
$out .= “</div>”;
$out = $out;
print_r ($out);
}
}
echo “</div>”;
//echo “</marquee>”;
echo “</div>”;
echo “</div>”;
?>
<!– top Aksias –>
<?php
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘instrSysName’, ‘instrCode’, ‘price’, ‘instrName’, ‘pricePrevClosePricePDelta’, ‘totalInstrTurnover’ )));
$query->from($db->quoteName(‘#__inbroke_info_metoxes’));
$query->order($db->quoteName(‘totalInstrTurnover’) . ‘DESC’);
$db->setQuery($query);
$res = $db->loadAssocList();
$milivar = $res;
//$milivar = array_multisort($res, array(‘pricePrevClosePricePDelta’=>SORT_DESC));
//usort($res, make_comparer([‘pricePrevClosePricePDelta’, SORT_DESC]));
//echo $res;
//function sort($a, $b) {
// if ($a[‘pricePrevClosePricePDelta’] == $b[‘pricePrevClosePricePDelta’]) return 0;
// return ($a[‘pricePrevClosePricePDelta’] > $b[‘pricePrevClosePricePDelta’]) ? 1 : -1;
//}
//usort($milivar, ‘sort’);
//array_multisort($milivar, ‘pricePrevClosePricePDelta’, SORT_DESC);
$length = count($milivar);
//var_dump($milivar);
echo “<div class=’topvalueitem’>”;
echo “<h4>Top αξίας</h4>”;
echo “<div class=’xrti’><span class=’xrt’>Σύμβολο</span> <span class=’xrt’>Τιμή</span> <span class=’xrt’>Μεταβολή</span></div>”;
echo ‘<div class=”scrxrima”>’;
//echo ‘<marquee class=”xrimascroll” id=”scroller” behavior=”scroll” direction=”up” scrollamount=”1″ truespeed=”true” scrolldelay=”30″ onmouseover=”this.stop();” onmouseout=”this.start();” onfinish=”PageReload();”>’;
echo “<div class=’ul’>”;
for ($i = 0; $i < 15; $i++) {
if (($milivar[$i][‘instrCode’])) {
$out = NULL;
$price = NULL;
$priceperc = NULL;
if ($milivar[$i][‘pricePrevClosePricePDelta’] > 0){
$varclass = “green”;
$arrowvar = “arrowup”;
} elseif ($milivar[$i][‘pricePrevClosePricePDelta’] == 0) {
$varclass = “grey”;
$arrowvar = “arrow”;
} else {
$varclass = “red”;
$arrowvar = “arrowdown”;
}
$out .= “<div class=’li’>”;
$out .= ‘<span class=”xrli-a”><a class=”‘.$varclass.'” href=”‘.$milivar[$i][‘instrSysName’].'”>’ ;
$out .= $milivar[$i][‘instrCode’];
$out .= “</a>”;
$out .= “</span>”;
//$out .= ‘<span class=”xrli-cap”>’ ;
//$out .= $milivar[$i][‘totalInstrTurnover’];
//$out .= “</a>”;
//$out .= “</span>”;
//$out .= ” “;
//$out .= “<span class=’xrli-b $varclass’>”.$milivar[$i][‘instrName’].”</span>”;
//$priceperc = $milivar[$i][‘price’];
//if (empty($priceperc) {
//$price = ” – %”;
//} else
//$priceperc = substr($milivar[$i][‘pricePrevClosePricePDelta’], 0, -2);
$priceperc = round($milivar[$i][‘pricePrevClosePricePDelta’], 2);
if (empty($priceperc)) {
$price = ” – %”;
}
else $price = “$priceperc %”;
//$out .= ” “;
$out .= “<span class=’xrli-c $varclass’>”.$milivar[$i][‘price’].” €</span>”;
$out .= “<span class=’xrli-d $varclass’>”.$price.”</span>”;
$out .= “<span class='”.$arrowvar.”‘><div class='”.$arrowvar.”‘></div></span>”;
$out .= “</div>”;
$out = $out;
print_r ($out);
}
}
echo “</div>”;
//echo “</marquee>”;
echo “</div>”;
echo “</div>”;
?>
<!– top volume –>
<?php
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘instrSysName’, ‘instrCode’, ‘price’, ‘instrName’, ‘pricePrevClosePricePDelta’, ‘totalInstrVolume’ )));
$query->from($db->quoteName(‘#__inbroke_info_metoxes’));
$query->order($db->quoteName(‘totalInstrVolume’) . ‘DESC’);
$db->setQuery($query);
$res = $db->loadAssocList();
$milivar = $res;
//$milivar = array_multisort($res, array(‘pricePrevClosePricePDelta’=>SORT_DESC));
//usort($res, make_comparer([‘pricePrevClosePricePDelta’, SORT_DESC]));
//echo $res;
//function sort($a, $b) {
// if ($a[‘pricePrevClosePricePDelta’] == $b[‘pricePrevClosePricePDelta’]) return 0;
// return ($a[‘pricePrevClosePricePDelta’] > $b[‘pricePrevClosePricePDelta’]) ? 1 : -1;
//}
//usort($milivar, ‘sort’);
//array_multisort($milivar, ‘pricePrevClosePricePDelta’, SORT_DESC);
$length = count($milivar);
//var_dump($milivar);
echo “<div class=’topvolumeitem’>”;
echo “<h4>Top όγκου</h4>”;
echo “<div class=’xrti’><span class=’xrt’>Σύμβολο</span> <span class=’xrt’>Τιμή</span> <span class=’xrt’>Μεταβολή</span></div>”;
echo ‘<div class=”scrxrima”>’;
//echo ‘<marquee class=”xrimascroll” id=”scroller” behavior=”scroll” direction=”up” scrollamount=”1″ truespeed=”true” scrolldelay=”30″ onmouseover=”this.stop();” onmouseout=”this.start();” onfinish=”PageReload();”>’;
echo “<div class=’ul’>”;
for ($i = 0; $i < 15; $i++) {
if (($milivar[$i][‘instrCode’])) {
$out = NULL;
$price = NULL;
$priceperc = NULL;
if ($milivar[$i][‘pricePrevClosePricePDelta’] > 0){
$varclass = “green”;
$arrowvar = “arrowup”;
} elseif ($milivar[$i][‘pricePrevClosePricePDelta’] == 0) {
$varclass = “grey”;
$arrowvar = “arrow”;
} else {
$varclass = “red”;
$arrowvar = “arrowdown”;
}
$out .= “<div class=’li’>”;
$out .= ‘<span class=”xrli-a”><a class=”‘.$varclass.'” href=”‘.$milivar[$i][‘instrSysName’].'”>’ ;
$out .= $milivar[$i][‘instrCode’];
$out .= “</a>”;
$out .= “</span>”;
//$out .= ‘<span class=”xrli-cap”>’ ;
//$out .= $milivar[$i][‘totalInstrTurnover’];
//$out .= “</a>”;
//$out .= “</span>”;
//$out .= ” “;
//$out .= “<span class=’xrli-b $varclass’>”.$milivar[$i][‘instrName’].”</span>”;
//$priceperc = $milivar[$i][‘price’];
//if (empty($priceperc) {
//$price = ” – %”;
//} else
//$priceperc = substr($milivar[$i][‘pricePrevClosePricePDelta’], 0, -2);
$priceperc = round($milivar[$i][‘pricePrevClosePricePDelta’], 2);
if (empty($priceperc)) {
$price = ” – %”;
}
else $price = “$priceperc %”;
//$out .= ” “;
$out .= “<span class=’xrli-c $varclass’>”.$milivar[$i][‘price’].” €</span>”;
$out .= “<span class=’xrli-d $varclass’>”.$price.”</span>”;
$out .= “<span class='”.$arrowvar.”‘><div class='”.$arrowvar.”‘></div></span>”;
$out .= “</div>”;
$out = $out;
print_r ($out);
}
}
echo “</div>”;
//echo “</marquee>”;
echo “</div>”;
echo “</div>”;
?>
<br><br>
{/source}