buchungen.php

<?php userstatus();?>

<?php head('Buchungsübersicht (max. 50 Buchungen)');?>
<center>
<table class="table">
<thead>
<tr>
<th scope="col"><b>Zeit</b></th>
<th scope="col"><b>Buchung</b></th>
<th scope="col"><b><?php echo $system['waehrung'];?></b></th>
<th scope="col"><b>Verwendungszweck</b></th>
</tr>
</thead>
<?php
$i = 0;
$buchungen_lesen = sql::$db->prepare ("SELECT * FROM `" . _VMS_ . "_buchungen` WHERE uid=:session_uid ORDER BY buchungszeit DESC LIMIT 50");
$buchungen_lesen -> bindParam(':session_uid', $_SESSION['uid'], PDO::PARAM_INT);
$buchungen_lesen -> execute();
while ($buchung_schreiben = $buchungen_lesen->fetch()) {
$i++;
$buchcolor = $system['positiv_farbe'];
if ($buchung_schreiben['buchungsmenge'] < 0) $buchcolor=$system['negativ_farbe'];

if ($i % 2 == 0){
   $row = 0;
} else {
   $row = 1;
}
?>
<tr class="tabellenbody_<?php echo $row;?>">
<td align="left">&nbsp;<?php echo date("d.m.Y - H:i",$buchung_schreiben['buchungszeit']);?>&nbsp;</td>
<td align="center">&nbsp;<?php echo $buchung_schreiben['buchungs_id'];?></td>
<td align="right">&nbsp;<font color="<?php echo $buchcolor;?>"><?php echo number_format($buchung_schreiben['buchungsmenge'],2,",",".");?></font>&nbsp;</td>
<td align="left">&nbsp;<?php echo $buchung_schreiben['verwendungszweck'];?></td>
</tr>
<?php
}
?>
</table>
</center>
<?php foot();?>