viric@0: <?php
viric@0: 
viric@0: include("./strings.inc");
viric@0: 
viric@0: class llistes
viric@0: {
viric@0: 
viric@0: function LlistaButxaques($connexio)
viric@0: {
viric@0: ?>
viric@0: <table border=1>
viric@0: <tr>
viric@0: 	<th><?php echo _("ID") ?>
viric@0: 	<th><?php echo _("Nom") ?>
viric@0: <?php
viric@0: 
viric@0: 	$butxaques = obtenir_butxaques($connexio);
viric@0: 
viric@0: 	foreach(array_keys($butxaques) as $i)
viric@0: 	{
viric@0: 		echo "<TR>\n";
viric@0: 		echo "\t<TD>" . $i . "\n";
viric@0: 		echo "\t<TD>" . strtohtml($butxaques[$i]) . "\n";
viric@0: 	}
viric@0: 
viric@0: 	
viric@0: ?>
viric@0: 
viric@0: </table>
viric@0: <?php
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function LlistaMoviments($connexio, $ordre=1)
viric@0: {
viric@0: ?>
viric@0: <table border=1>
viric@0: <tr>
viric@0: 	<th><a href="llista-moviments?ordre=1"><?php echo _("Data") ?></a>
viric@0: 	<th><a href="llista-moviments?ordre=2"><?php echo _("Modificat") ?></a>
viric@0: 	<th><?php echo _("Orígen") ?>
viric@0: 	<th><?php echo _("Destí") ?>
viric@0: 	<th><?php echo _("Diners") ?>
viric@0: 	<th><?php echo _("Raó") ?>
viric@0: <?php
viric@0: 	$butxaques = obtenir_butxaques($connexio);
viric@0: 
viric@0: 	if ($ordre == 1)
viric@0: 		$query ="SELECT UNIX_TIMESTAMP(data),
viric@0: 		UNIX_TIMESTAMP(data_modif), butxaca_origen,
viric@0: 		butxaca_desti, quantitat, rao FROM moviments
viric@0: 		ORDER BY data DESC;";
viric@0: 	else
viric@0: 		$query ="SELECT UNIX_TIMESTAMP(data),
viric@0: 		UNIX_TIMESTAMP(data_modif), butxaca_origen,
viric@0: 		butxaca_desti, quantitat, rao FROM moviments
viric@0: 		ORDER BY data_modif DESC;";
viric@0: 	$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 
viric@0: 	while ($fila = mysql_fetch_row($resultat))
viric@0: 	{
viric@0: 		echo "<TR>\n";
viric@0: 		echo "\t<TD><a href=\"update-moviment?id=". $fila[0].
viric@0: 			"\">" . date("d/m/Y H:i",$fila[0]) .
viric@0: 			"</a>\n";
viric@0: 		echo "\t<TD>". date("d/m/Y H:i",$fila[1]) ."\n";
viric@0: 		echo "\t<TD>" . strtohtml($butxaques[$fila[2]]) . "\n";
viric@0: 		echo "\t<TD>" . strtohtml($butxaques[$fila[3]]) . "\n";
viric@0: 		echo "\t<TD>" . sprintf("%.2f", $fila[4]) . "\n";
viric@0: 		echo "\t<TD>" . strtohtml($fila[5]) . "\n";
viric@0: 	}
viric@0: 
viric@0: 	
viric@0: ?>
viric@0: 
viric@0: </table>
viric@0: <?php
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function LlistaIngressos($connexio, $ordre=1)
viric@0: // 1 = per data. altres, per data_modif
viric@0: {
viric@0: ?>
viric@0: <table border=1>
viric@0: <tr>
viric@0: 	<th><a href="llista-ingressos?ordre=1"><?php echo _("Data") ?></a>
viric@0: 	<th><a href="llista-ingressos?ordre=2"><?php echo _("Modificat") ?></a>
viric@0: 	<th><?php echo _("Butxaca") ?>
viric@0: 	<th><?php echo _("Diners") ?>
viric@0: 	<th><?php echo _("Raó") ?>
viric@0: <?php
viric@0: 	$butxaques = obtenir_butxaques($connexio);
viric@0: 
viric@0: 	if ($ordre == 1)
viric@0: 		$query ="SELECT UNIX_TIMESTAMP(data),
viric@0: 			UNIX_TIMESTAMP(data_modif), butxaca,
viric@0: 			quantitat, rao FROM ingressos ORDER BY data DESC;";
viric@0: 	else
viric@0: 		$query ="SELECT UNIX_TIMESTAMP(data),
viric@0: 			UNIX_TIMESTAMP(data_modif), butxaca,
viric@0: 			quantitat, rao FROM ingressos ORDER BY data_modif DESC;";
viric@0: 	$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 
viric@0: 	while ($fila = mysql_fetch_row($resultat))
viric@0: 	{
viric@0: 		echo "<TR>\n";
viric@0: 		echo "\t<TD><a href=\"update-ingres?id=". $fila[0].
viric@0: 			"\">" . date("d/m/Y H:i",$fila[0]) .
viric@0: 			"</a>\n";
viric@0: 		echo "\t<TD>". date("d/m/Y H:i",$fila[1]) ."\n";
viric@0: 		echo "\t<TD>" . strtohtml($butxaques[$fila[2]]) . "\n";
viric@0: 		echo "\t<TD>" . pricetohtml( $fila[3]) . "\n";
viric@0: 		echo "\t<TD>" . strtohtml($fila[4]) . "\n";
viric@0: 			"</a>\n";
viric@0: 	}
viric@0: 
viric@0: 	
viric@0: ?>
viric@0: 
viric@0: </table>
viric@0: <?php
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function StatusButxaques($connexio)
viric@0: {
viric@0: ?>
viric@0: <table border=1>
viric@0: <tr>
viric@0: 	<th><?php echo _("Butxaca") ?>
viric@0: 	<th><?php echo _("Ingressos") ?>
viric@0: 	<th><?php echo _("Despeses") ?>
viric@0: 	<th><?php echo _("Moviments negatius") ?>
viric@0: 	<th><?php echo _("Moviments positius") ?>
viric@0: 	<th><?php echo _("Total") ?>
viric@0: <?php
viric@0: 	$butxaques = obtenir_butxaques($connexio);
viric@0: 
viric@0: 	$total = 0;
viric@0: 	
viric@0: 	foreach(array_keys($butxaques) as $i)
viric@0: 	{
viric@0: 		echo "<tr>";
viric@0: 		echo "<td>" . $butxaques[$i]. "\n";
viric@0: 
viric@0: 		// Ingressos
viric@0: 		$query ="SELECT SUM(quantitat) FROM ingressos WHERE
viric@0: 		butxaca =" . $i. " AND quantitat > 0;";
viric@0: 		$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1;
viric@0: 		}
viric@0: 
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		$ingressos = $fila[0];
viric@0: 		echo "<td>" . pricetohtml($fila[0]). "\n";
viric@0: 
viric@0: 		// Despeses
viric@0: 		$query ="SELECT SUM(quantitat) FROM ingressos WHERE
viric@0: 		butxaca =" . $i. " AND quantitat < 0;";
viric@0: 		$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1;
viric@0: 		}
viric@0: 
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		echo "<td>" . pricetohtml($fila[0]). "\n";
viric@0: 		$ingressos = $ingressos + $fila[0];
viric@0: 
viric@0: 		// Moviments negatius
viric@0: 		$query ="SELECT SUM(quantitat) FROM moviments WHERE
viric@0: 		butxaca_origen =" . $i. ";";
viric@0: 		$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1;
viric@0: 		}
viric@0: 
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		echo "<td>" . pricetohtml(-$fila[0]). "\n";
viric@0: 		$ingressos = $ingressos - $fila[0];
viric@0: 
viric@0: 		// Moviments positius
viric@0: 		$query ="SELECT SUM(quantitat) FROM moviments WHERE
viric@0: 		butxaca_desti =" . $i. ";";
viric@0: 		$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1;
viric@0: 		}
viric@0: 
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		echo "<td>" . pricetohtml($fila[0]). "\n";
viric@0: 		$ingressos = $ingressos + $fila[0];
viric@0: 
viric@0: 		echo "<td>" . pricetohtml($ingressos) . "\n";
viric@0: 		$total = $total + $ingressos;
viric@0: 	}
viric@0: 
viric@0: 	echo "<tr>\n";
viric@0: 	echo "<th>". _("Total"). "<td><td><td><td><td>" . pricetohtml($total).
viric@0: 		"\n";
viric@0: 
viric@0: 	
viric@0: ?>
viric@0: 
viric@0: </table>
viric@0: <?php
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: } // Fi de classe
viric@0: ?>