Skip to content
Snippets Groups Projects
buchungen.php 4.71 KiB
Newer Older
Eric Laufer's avatar
1.1
Eric Laufer committed
<?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>&auml;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&auml;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&auml;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&auml;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 '&nbsp;'.$b.'&nbsp;';
				} else {
					echo '  <a href="?content=/buchungen&seite='.$b.'">'.$b.'</a>&nbsp;';
				}
			}
}
?>