-
Eric Laufer authored
Das ist der erste Upload des neuen VMS-SUEE
26044b8a
buchungen.php 4.71 KiB
<?php
if ($_GET['seite'] == '') {$_GET['seite'] = '1';}
$start = $_GET['seite'] * 100 - 100;
$buchungen = mysqli_fetch_array(db_query("SELECT COUNT(id) AS gesammt FROM ".$db_prefix."_buchungen "));
$bu_jung = mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_buchungen ORDER BY id ASC LIMIT 1"));
$bu_alt = mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_buchungen ORDER BY id DESC LIMIT 1"));
$u = db_query("SELECT uid FROM ".$db_prefix."_kontodaten ");
$b = db_query("SELECT verwendungszweck FROM ".$db_prefix."_buchungen GROUP BY verwendungszweck ");
head("Filtern der ".number_format($buchungen['gesammt'],0,',','.')." Buchungen");
echo '
<table width="100%">
<tr>
<td>Anzahl Buchungen vorhganden</td>
<td>'. number_format($buchungen['gesammt'],0,',','.') .'</td>
<td></td>
<td></td>
</tr>
<tr>
<td>älteste Buchung</td>
<td>'.date("d.m.Y H:i",$bu_jung['buchungszeit']) .'</td>
<td>Neuste Buchung</td>
<td>'. date("d.m.Y H:i",$bu_alt['buchungszeit']) .'</td>
</tr>
</table>
<form method="post" action="">
<table width="100%">
<tr>
<td>Anzahl der Datensätze:</td>
<td>
<select name="anzahl">
<option value="100">100</option>
<option value="200">200</option>
<option value="300">300</option>
<option value="400">400</option>
<option value="500">500</option>
<option value="'.$buchungen['gesammt'].'">'.number_format($buchungen['gesammt'],0,',','.').'</option>
</select>
</td>
<td>User ID</td>
<td>
<select name="uid">
<option value="0">Bitte wählen</option>';
while($uid = mysqli_fetch_array($u)){
echo '<option value="'. $uid['uid'] .'" '; if($_POST['uid'] == $uid['uid']){ echo 'SELECTED';} echo '>'. $uid['uid'] .'</option>';
}
echo '
</select>
</td>
<td>Verwendungszweck</td>
<td>
<select name="zweck" style="width: 250px;">
<option value="0">Bitte wählen</option>';
while($ver = mysqli_fetch_array($b)){
echo '<option value="'. $ver['verwendungszweck'] .'"'; if($_POST['zweck'] == $ver['verwendungszweck']){ echo 'SELECTED';} echo '>'. $ver['verwendungszweck'] .'</option>';
}
echo '
</select>
</td>
<input type="hidden" name="sortierung" value="1">
<td><input type="submit" name="buch_anzeigen" value="Anzeigen>>"></td>
</tr>
</table>
</form>
';
foot();
if(!empty($_POST['sortierung'])){
if($_POST['zweck'] != 0){
if($_POST['uid'] != 0){
$and = 'AND';
}else{
$and = '';
}
}else{
$and = '';
}
if($_POST['zweck'] != 0){ $zweck = 'verwendungszweck = '.$_POST['zweck'];}else{ $zweck = '';}
if($_POST['uid'] != 0){ $uid = 'uid = '.$_POST['uid'];}else{ $uid = '';}
$limit = 'LIMIT '.$_POST['anzahl'];
$ab = db_query("SELECT * FROM ".$db_prefix."_buchungen WHERE ".$uid." ".$and." ".$zweck." ORDER BY id DESC ".$limit." ");
echo '
<table class="tabellenbody" width="100%">
<tr class="tabellenhead">
<td>Datum</td>
<td>Zeit</td>
<td>User</td>
<td>Betrag</td>
<td>Verwendung</td>
</tr>
';
while($buch = mysqli_fetch_array($ab)){
$user = mysqli_fetch_array(db_query("SELECT nickname FROM ".$db_prefix."_userdaten WHERE uid = '".$buch['uid']."' "));
echo '
<tr>
<td>'.date("d.m.Y", $buch['buchungszeit']).'</td>
<td>'.date("H:i", $buch['buchungszeit']).'</td>
<td>'.$user['nickname'].'</td>
<td>'.number_format($buch['buchungsmenge'],2,',','.').'</td>
<td>'.$buch['verwendungszweck'].'</td>
</tr>
';
}
}else{
echo '
<table class="tabellenbody" width="100%">
<tr class="tabellenhead">
<td>Datum</td>
<td>Zeit</td>
<td>User</td>
<td>Betrag</td>
<td>Verwendung</td>
</tr>
';
$nac = db_query("SELECT * FROM ".$db_prefix."_buchungen ORDER BY id DESC LIMIT $start,50");
while($buch = mysqli_fetch_array($nac)){
$user = mysqli_fetch_array(db_query("SELECT nickname FROM ".$db_prefix."_userdaten WHERE uid = '".$buch['uid']."' "));
echo '
<tr>
<td>'.date("d.m.Y", $buch['buchungszeit']).'</td>
<td>'.date("H:i", $buch['buchungszeit']).'</td>
<td>'.$user['nickname'].'</td>
<td>'.number_format($buch['buchungsmenge'],2,',','.').'</td>
<td>'.$buch['verwendungszweck'].'</td>
</tr>
';
}
$seiten = db_query("SELECT id FROM " . $db_prefix . "_buchungen");
$menge = mysqli_num_rows($seiten);
$seitenanzahl = $menge / 100;
echo 'Seite: ';
for($a = 0; $a < $seitenanzahl; $a++) {
$b = $a + 1;
if ($_GET['seite'] == $b) {
echo ' '.$b.' ';
} else {
echo ' <a href="?content=/buchungen&seite='.$b.'">'.$b.'</a> ';
}
}
}
?>