|
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 <?php |
|
11 include("getdb.inc"); |
|
12 $connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password); |
|
13 mysql_select_db($mysql_db, $connexio); |
|
14 |
|
15 |
|
16 // Crides a funcions per obtenir parametres |
|
17 $habitants = obtenir_habitants($connexio); |
|
18 $num_habitants = count($habitants); |
|
19 |
|
20 $gent = obtenir_gent($connexio); |
|
21 |
|
22 $persona = $_GET["user_id"]; |
|
23 |
|
24 |
|
25 // Necessitem $GET_["user_id"] |
|
26 ?> |
|
27 |
|
28 <h1 align=center>Ètxelon</h1> |
|
29 <h1 align=center>Moviments de |
|
30 "<EM><?php echo strtohtml($gent[$persona]["nom"]) ?></EM>"</h1> |
|
31 |
|
32 <h2>Compres on ha tingut a veure</h2> |
|
33 |
|
34 |
|
35 <TABLE BORDER=1> |
|
36 <TR> |
|
37 <TH>Data |
|
38 <TH>Botiga |
|
39 <TH>Motiu |
|
40 <TH>Preu |
|
41 <TH>Pagat |
|
42 <TH>Excepcions |
|
43 <TH>Eliminiar |
|
44 <?php |
|
45 $query = "SELECT UNIX_TIMESTAMP(compres.data),compres.botiga,compres.motiu,compres.preu FROM compres,compradors WHERE compradors.data=compres.data AND compradors.persona=$persona GROUP BY compres.data ORDER BY compres.data DESC;"; |
|
46 $resultat = mysql_query($query, $connexio); |
|
47 |
|
48 // Per cada compra ... |
|
49 $num_compres = 0; |
|
50 while ($fila = mysql_fetch_row($resultat)) |
|
51 { |
|
52 $data = $fila[0]; |
|
53 $date_shown = date("d/m/Y H:i",$data); |
|
54 printf("<tr>\n\t<td><A HREF=\"view-compra?id=%s\">%s</A>\n", $data, |
|
55 $date_shown); |
|
56 printf("\t<td>%s\n", strtohtml($fila[1])); |
|
57 printf("\t<td>%s\n", strtohtml($fila[2])); |
|
58 printf("\t<td align=right>%s\n", pricetohtml($fila[3])); |
|
59 |
|
60 // Obtenim lo que toca pagar a cadascú |
|
61 $query = "SELECT compradors.persona,compradors.pagat,compradors.toca_pagar FROM compradors WHERE compradors.data = FROM_UNIXTIME($data) AND compradors.persona = $persona;"; |
|
62 $resultat2 = mysql_query($query, $connexio); |
|
63 |
|
64 unset($compradors); |
|
65 // Hauria de sortir només 1 fila! 1 per la persona que hem escollit. |
|
66 while ($fila2 = mysql_fetch_row($resultat2)) |
|
67 { |
|
68 $compradors[$fila2[0]] = array( "pagat" => $fila2[1], |
|
69 "toca_pagar" => $fila2[2]); |
|
70 } |
|
71 |
|
72 if (isset($compradors[$persona])) |
|
73 printf("\t<td align=right>%s\n", pricetohtml($compradors[$persona]["pagat"])); |
|
74 else |
|
75 printf("\t<td align=right>%s\n", pricetohtml(0)); |
|
76 |
|
77 $excepcions = obtenir_excepcions($data,$connexio); |
|
78 if ($excepcions != 0) |
|
79 printf("\t<td align=right>%d\n", count($excepcions)); |
|
80 else |
|
81 printf("\t<td align=right>0\n"); |
|
82 printf("\t<td><A HREF=\"delete-compra?id=%s\">Eliminar</A>\n", $data); |
|
83 |
|
84 $num_compres++; |
|
85 } |
|
86 |
|
87 ?> |
|
88 </TABLE> |
|
89 |
|
90 <P>En/La <?php echo $gent[$persona]["nom"] ?> té a veure en <?php echo $num_compres ?> compres. </P> |
|
91 |
|
92 <HR WIDTH="70%"> |
|
93 |
|
94 |
|
95 <h2>Compres on ha tingut a veure <EM>amb excepcions</EM></h2> |
|
96 |
|
97 <TABLE BORDER=1> |
|
98 <TR> |
|
99 <TH>Data |
|
100 <TH>Botiga |
|
101 <TH>Motiu |
|
102 <TH>Preu |
|
103 <TH>Pagat |
|
104 <TH>Excepcions |
|
105 <TH>Eliminiar |
|
106 <?php |
|
107 $query = "SELECT UNIX_TIMESTAMP(compres.data),compres.botiga,compres.motiu,compres.preu FROM compres,compradors_excepcions,excepcions WHERE excepcions.data=compres.data AND compradors_excepcions.ex_id=excepcions.id AND compradors_excepcions.persona=$persona GROUP BY compres.data ORDER BY compres.data DESC;"; |
|
108 $resultat = mysql_query($query, $connexio); |
|
109 |
|
110 // Per cada compra ... |
|
111 $num_compres = 0; |
|
112 while ($fila = mysql_fetch_row($resultat)) |
|
113 { |
|
114 $data = $fila[0]; |
|
115 $date_shown = date("d/m/Y H:i",$data); |
|
116 printf("<tr>\n\t<td><A HREF=\"view-compra?id=%s\">%s</A>\n", $data, |
|
117 $date_shown); |
|
118 printf("\t<td>%s\n", strtohtml($fila[1])); |
|
119 printf("\t<td>%s\n", strtohtml($fila[2])); |
|
120 printf("\t<td align=right>%s\n", pricetohtml($fila[3])); |
|
121 |
|
122 // Obtenim lo que toca pagar a cadascú |
|
123 $query = "SELECT compradors.persona,compradors.pagat,compradors.toca_pagar FROM compradors WHERE compradors.data = FROM_UNIXTIME($data) AND compradors.persona = $persona;"; |
|
124 $resultat2 = mysql_query($query, $connexio); |
|
125 |
|
126 unset($compradors); |
|
127 // Hauria de sortir només 1 fila! 1 per la persona que hem escollit. |
|
128 while ($fila2 = mysql_fetch_row($resultat2)) |
|
129 { |
|
130 $compradors[$fila2[0]] = array( "pagat" => $fila2[1], |
|
131 "toca_pagar" => $fila2[2]); |
|
132 } |
|
133 |
|
134 if (isset($compradors[$persona])) |
|
135 printf("\t<td align=right>%s\n", pricetohtml($compradors[$persona]["pagat"])); |
|
136 else |
|
137 printf("\t<td align=right>%s\n", pricetohtml(0)); |
|
138 |
|
139 $excepcions = obtenir_excepcions($data,$connexio); |
|
140 if ($excepcions != 0) |
|
141 printf("\t<td align=right>%d\n", count($excepcions)); |
|
142 else |
|
143 printf("\t<td align=right>0\n"); |
|
144 printf("\t<td><A HREF=\"delete-compra?id=%s\">Eliminar</A>\n", $data); |
|
145 |
|
146 $num_compres++; |
|
147 } |
|
148 |
|
149 ?> |
|
150 </TABLE> |
|
151 |
|
152 <P>En/La <?php echo $gent[$persona]["nom"] ?> té a veure <em>amb excepcions</em> en <?php echo $num_compres ?> compres. </P> |
|
153 |
|
154 <HR WIDTH="70%"> |
|
155 |
|
156 <!-- ************* PAGAMENTS ************** --> |
|
157 |
|
158 <h2>Pagaments</h2> |
|
159 |
|
160 |
|
161 <TABLE BORDER=1> |
|
162 <TR> |
|
163 <TH ROWSPAN=1>Data |
|
164 <TH COLSPAN=1>Balanç |
|
165 <TH ROWSPAN=1>Comentari |
|
166 <TH ROWSPAN=1>Eliminar |
|
167 <?php |
|
168 $query = "SELECT UNIX_TIMESTAMP(pagaments.data),pagaments.comentari FROM pagaments,pagadors WHERE pagaments.data=pagadors.data AND pagadors.persona=$persona ORDER BY pagaments.data DESC"; |
|
169 $resultat = mysql_query($query, $connexio); |
|
170 |
|
171 // Per cada pagament ... |
|
172 $num_pagaments=0; |
|
173 while ($fila = mysql_fetch_row($resultat)) |
|
174 { |
|
175 $data = $fila[0]; |
|
176 $date_shown = date("d/m/Y H:i",$data); |
|
177 printf("<tr>\n\t<td><A HREF=\"view-pagament?id=%s\">%s</A>\n", |
|
178 $data, $date_shown); |
|
179 |
|
180 /* |
|
181 // Obtenim lo que toca pagar a cadascú |
|
182 $query = "SELECT pagadors.persona,pagadors.pagat,pagadors.cobrat FROM pagadors,gent WHERE pagadors.data = FROM_UNIXTIME($data) AND pagadors.persona = gent.id AND gent.habitant = 1 ORDER BY gent.nom;"; |
|
183 $resultat2 = mysql_query($query, $connexio); |
|
184 |
|
185 while ($fila2 = mysql_fetch_row($resultat2)) |
|
186 { |
|
187 $pagadors[$fila2[0]] = array( "pagat" => $fila2[1]); |
|
188 } |
|
189 */ |
|
190 $pagadors = obtenir_pagadors($data, $connexio); |
|
191 if (isset($pagadors[$persona])) |
|
192 printf("\t<td align=right>%s\n", pricetohtml($pagadors[$persona]["cobrat"] - $pagadors[$persona]["pagat"])); |
|
193 else |
|
194 printf("\t<td align=right>%s\n", pricetohtml(0)); |
|
195 // Comentari |
|
196 printf("\t<td>%s\n", strtohtml($fila[1])); |
|
197 // Eliminar |
|
198 printf("\t<td align=center><A HREF=\"delete-pagament?id=%s\">Eliminar</A>\n", $data); |
|
199 |
|
200 $num_pagaments++; |
|
201 } |
|
202 |
|
203 ?> |
|
204 </TABLE> |
|
205 |
|
206 |
|
207 <P>En/La <?php echo $gent[$persona]["nom"] ?> té a veure en <?php echo $num_pagaments ?> pagaments. </P> |
|
208 |
|
209 <HR WIDTH="70%"> |
|
210 <BR> |
|
211 <A HREF="index">Tornar al menú d'inici</A> |
|
212 |
|
213 </body> |
|
214 </html> |
|
215 |