<?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> '; } } } ?>