viric@0: viric@0:
viric@0: | viric@0: \n"; viric@0: echo "\t | " . $i . "\n"; viric@0: echo "\t | " . strtohtml($butxaques[$i]) . "\n"; viric@0: } viric@0: viric@0: viric@0: ?> viric@0: viric@0: |
---|
viric@0: | viric@0: | viric@0: | viric@0: | viric@0: | viric@0: "; viric@0: return 1; viric@0: } viric@0: viric@0: while ($fila = mysql_fetch_row($resultat)) viric@0: { viric@0: echo " |
---|---|---|---|---|---|
" . date("d/m/Y H:i",$fila[0]) . viric@0: "\n"; viric@0: echo "\t | ". date("d/m/Y H:i",$fila[1]) ."\n"; viric@0: echo "\t | " . strtohtml($butxaques[$fila[2]]) . "\n"; viric@0: echo "\t | " . strtohtml($butxaques[$fila[3]]) . "\n"; viric@0: echo "\t | " . sprintf("%.2f", $fila[4]) . "\n"; viric@0: echo "\t | " . strtohtml($fila[5]) . "\n"; viric@0: } viric@0: viric@0: viric@0: ?> viric@0: viric@0: |
viric@0: | viric@0: | viric@0: | viric@0: | viric@0: "; viric@0: return 1; viric@0: } viric@0: viric@0: while ($fila = mysql_fetch_row($resultat)) viric@0: { viric@0: echo " |
---|---|---|---|---|
" . date("d/m/Y H:i",$fila[0]) . viric@0: "\n"; viric@0: echo "\t | ". date("d/m/Y H:i",$fila[1]) ."\n"; viric@0: echo "\t | " . strtohtml($butxaques[$fila[2]]) . "\n"; viric@0: echo "\t | " . pricetohtml( $fila[3]) . "\n"; viric@0: echo "\t | " . strtohtml($fila[4]) . "\n"; viric@0: "\n"; viric@0: } viric@0: viric@0: viric@0: ?> viric@0: viric@0: |
viric@0: | viric@0: | viric@0: | viric@0: | viric@0: | viric@0: "; viric@0: echo " | " . $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()." "; viric@0: return 1; viric@0: } viric@0: viric@0: $fila = mysql_fetch_row($resultat); viric@0: $ingressos = $fila[0]; viric@0: echo " | " . 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()." "; viric@0: return 1; viric@0: } viric@0: viric@0: $fila = mysql_fetch_row($resultat); viric@0: echo " | " . 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()." "; viric@0: return 1; viric@0: } viric@0: viric@0: $fila = mysql_fetch_row($resultat); viric@0: echo " | " . 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()." "; viric@0: return 1; viric@0: } viric@0: viric@0: $fila = mysql_fetch_row($resultat); viric@0: echo " | " . pricetohtml($fila[0]). "\n"; viric@0: $ingressos = $ingressos + $fila[0]; viric@0: viric@0: echo " | " . pricetohtml($ingressos) . "\n"; viric@0: $total = $total + $ingressos; viric@0: } viric@0: viric@0: echo " |
---|---|---|---|---|---|---|---|---|---|---|---|
". _("Total"). " | " . pricetohtml($total). viric@0: "\n"; viric@0: viric@0: viric@0: ?> viric@0: viric@0: |