|
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
|
2 <html> |
|
3 <head> |
|
4 <title>Ètxelon - Consulta de compres</title> |
|
5 <meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"> |
|
6 </head> |
|
7 |
|
8 <body> |
|
9 |
|
10 <h1 align=center>Ètxelon</h1> |
|
11 <h2>Total de compres</h2> |
|
12 |
|
13 <?php |
|
14 include("getdb.inc"); |
|
15 $connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password); |
|
16 mysql_select_db($mysql_db, $connexio); |
|
17 |
|
18 |
|
19 // Crides a funcions per obtenir parametres |
|
20 $habitants = obtenir_habitants($connexio); |
|
21 $num_habitants = count($habitants); |
|
22 ?> |
|
23 |
|
24 <TABLE BORDER=1> |
|
25 <TR> |
|
26 <TH ROWSPAN=2>Data |
|
27 <TH ROWSPAN=2>Botiga |
|
28 <TH ROWSPAN=2>Motiu |
|
29 <TH ROWSPAN=2>Preu |
|
30 <TH COLSPAN=<?php echo $num_habitants?>>Pagat |
|
31 <TH ROWSPAN=2>Excepcions |
|
32 <TH ROWSPAN=2>Eliminiar |
|
33 <TR> |
|
34 <?php |
|
35 foreach($habitants as $i) |
|
36 echo "\t<TH>" . strtohtml($i["nom"]). "\n"; |
|
37 ?> |
|
38 |
|
39 <?php |
|
40 $query = "SELECT UNIX_TIMESTAMP(data),botiga,motiu,preu FROM compres ORDER BY data DESC"; |
|
41 $resultat = mysql_query($query, $connexio); |
|
42 |
|
43 // Per cada compra ... |
|
44 $num_compres = 0; |
|
45 while ($fila = mysql_fetch_row($resultat)) |
|
46 { |
|
47 $data = $fila[0]; |
|
48 $date_shown = date("d/m/Y H:i",$data); |
|
49 printf("<tr>\n\t<td><A HREF=\"view-compra?id=%s\">%s</A>\n", $data, |
|
50 $date_shown); |
|
51 printf("\t<td>%s\n", strtohtml($fila[1])); |
|
52 printf("\t<td>%s\n", strtohtml($fila[2])); |
|
53 printf("\t<td align=right>%s\n", pricetohtml($fila[3])); |
|
54 |
|
55 // Obtenim lo que toca pagar a cadascú |
|
56 $query = "SELECT compradors.persona,compradors.pagat,compradors.toca_pagar FROM compradors,gent WHERE compradors.data = FROM_UNIXTIME($data) AND compradors.persona = gent.id AND gent.habitant = 1 ORDER BY gent.nom;"; |
|
57 $resultat2 = mysql_query($query, $connexio); |
|
58 |
|
59 unset($compradors); |
|
60 while ($fila2 = mysql_fetch_row($resultat2)) |
|
61 { |
|
62 $compradors[$fila2[0]] = array( "pagat" => $fila2[1], |
|
63 "toca_pagar" => $fila2[2]); |
|
64 } |
|
65 foreach($habitants as $i) |
|
66 { |
|
67 if (isset($compradors[$i["id"]])) |
|
68 printf("\t<td align=right>%s\n", pricetohtml($compradors[$i["id"]]["pagat"])); |
|
69 else |
|
70 printf("\t<td align=right>%s\n", pricetohtml(0)); |
|
71 } |
|
72 $excepcions = obtenir_excepcions($data,$connexio); |
|
73 if ($excepcions != 0) |
|
74 printf("\t<td align=right>%d\n", count($excepcions)); |
|
75 else |
|
76 printf("\t<td align=right>0\n"); |
|
77 printf("\t<td><A HREF=\"delete-compra?id=%s\">Eliminar</A>\n", $data); |
|
78 |
|
79 $num_compres++; |
|
80 } |
|
81 |
|
82 ?> |
|
83 </TABLE> |
|
84 |
|
85 <P>Hi ha un total de <?php echo $num_compres ?> compres. </P> |
|
86 |
|
87 <HR WIDTH="70%"> |
|
88 <BR> |
|
89 <A HREF="index">Tornar al menú d'inici</A> |
|
90 |
|
91 </body> |
|
92 </html> |
|
93 |