<?php
$result = multiRowQuery("SELECT * FROM history WHERE depotID = '" . $_SESSION['depot'] . "' ORDER BY date DESC;");
while ($row = $result->fetch_assoc()) {
?>
<tr>
<td><?php
echo datum($row["date"]);
?>
</td>
<td><?php
echo $row["menge"];
?>
</td>
<td><?php
echo getNameFromStockID($row["stocksID"]);
?>
</td>
<td><?php
echo $row["type"];
?>
</td>
<td><?php
echo printSign($row["wert"], " €");
?>
</td>
</tr>
<tr>
<td colspan="5">
<div style="width:device-width padding: 10px;">
],
}]
});
});
</script>
<?php
$top = singleRowQuery("SELECT `stockID`, \n\t\t\t\t\t\t\t\t\t\t\t\t @aktwert := (`menge` * (SELECT stocks.price FROM stocks WHERE stocks.id = `stockID`)) as aktwert, \n\t\t\t\t\t\t\t\t\t\t\t\t @gewinn := (@aktwert - startGeld) as gewinn,\n\t\t\t\t\t\t\t\t\t\t\t\t (@gewinn / (startGeld * 0.01)) as tendenz\n\t\t\t\t\t\t\t\t\t\t\t\t FROM trade WHERE `depotID` = '" . $_SESSION['depot'] . "' \n\t\t\t\t\t\t\t\t\t\t\t\t ORDER BY tendenz DESC \n\t\t\t\t\t\t\t\t\t\t\t\t LIMIT 0,1");
$topID = $top[0];
$topTendenz = round($top[3], 2);
$topName = getNameFromStockID($topID);
$flop = singleRowQuery("SELECT `stockID`, \n\t\t\t\t\t\t\t\t\t\t\t\t @aktwert := (`menge` * (SELECT stocks.price FROM stocks WHERE stocks.id = `stockID`)) as aktwert, \n\t\t\t\t\t\t\t\t\t\t\t\t @gewinn := (@aktwert - startGeld) as gewinn,\n\t\t\t\t\t\t\t\t\t\t\t\t (@gewinn / (startGeld * 0.01)) as tendenz\n\t\t\t\t\t\t\t\t\t\t\t\t FROM trade WHERE `depotID` = '" . $_SESSION['depot'] . "' AND stockID <> '" . $topID . "'\n\t\t\t\t\t\t\t\t\t\t\t\t ORDER BY tendenz ASC \n\t\t\t\t\t\t\t\t\t\t\t\t LIMIT 0,1");
$flopID = $flop[0];
$flopTendenz = round($flop[3], 2);
$flopName = getNameFromStockID($flopID);
if ($topTendenz >= 0) {
$topClass = "glyphicon glyphicon-arrow-up text-success";
} else {
$topClass = "glyphicon glyphicon-arrow-down text-danger";
}
if ($flopTendenz >= 0) {
$flopClass = "glyphicon glyphicon-arrow-up text-success";
} else {
$flopClass = "glyphicon glyphicon-arrow-down text-danger";
}
if ($topName == "") {
$topName = "N/A";
}
if ($flopName == "") {
$flopName = "N/A";
