<?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";