|
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
|
2 <html> |
|
3 <head> |
|
4 <title>Ètxelon - Eliminar compra</title> |
|
5 <meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"> |
|
6 </head> |
|
7 |
|
8 <body> |
|
9 <?php |
|
10 |
|
11 include("getdb.inc"); |
|
12 // Variables globals |
|
13 $touchdb = 1; // Si val 0, no es modificarà la base de dades |
|
14 |
|
15 // Fem la connexió |
|
16 $connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password); |
|
17 mysql_select_db($mysql_db, $connexio); |
|
18 |
|
19 $data = $_GET["id"]; |
|
20 |
|
21 |
|
22 // Crides a funcions per obtenir parametres |
|
23 $habitants = obtenir_habitants($connexio); |
|
24 $num_habitants = count($habitants); |
|
25 $altres = obtenir_altres($connexio); |
|
26 $gent = obtenir_gent($connexio); |
|
27 |
|
28 $compra = obtenir_compra($data, $connexio); |
|
29 $compradors = obtenir_compradors($data, $connexio); |
|
30 $excepcions = obtenir_excepcions($data, $connexio); |
|
31 |
|
32 $preu_per_compradors = $compra["preu"]; |
|
33 $max_compradors_ex = 0; |
|
34 if ($excepcions != 0) |
|
35 foreach($excepcions as $key => $value) |
|
36 { |
|
37 $preu_per_compradors -= $excepcions[$key]["preu"]; |
|
38 $compradors_excepcions[$key] = obtenir_compradors_excepcions($key, $connexio); |
|
39 $max_compradors_ex = max(count($compradors_excepcions[$key]),$max_compradors_ex); |
|
40 } |
|
41 |
|
42 |
|
43 if(!isset($_GET["sure"]) && isset($_GET["id"])) |
|
44 { |
|
45 ?> |
|
46 |
|
47 <H1 ALIGN=center>Eliminar compra</H1> |
|
48 |
|
49 <H2>Dades generals</H2> |
|
50 |
|
51 <p> Dades de la compra: </p> |
|
52 <TABLE BORDER=0> |
|
53 <TR> |
|
54 <TH>Hora i Data: |
|
55 <TD> <?php |
|
56 echo date("d/m/Y H:i",$data); ?> |
|
57 |
|
58 <TR> |
|
59 <TH> Botiga: |
|
60 <TD> <?php |
|
61 echo strtohtml($compra["botiga"]); ?> |
|
62 |
|
63 <TR> |
|
64 <TH> Motiu: |
|
65 <TD> <?php |
|
66 echo strtohtml($compra["motiu"]); ?> |
|
67 |
|
68 <TR> |
|
69 <TH> Comentari: |
|
70 <TD> <?php |
|
71 echo strtohtml($compra["comentari"]); ?> |
|
72 |
|
73 <TR> |
|
74 <TH> Preu: |
|
75 <TD> <?php |
|
76 echo pricetohtml($compra["preu"]); ?> |
|
77 |
|
78 <TR> |
|
79 <TH> Preu (a repartir) |
|
80 <TD> <?php |
|
81 echo pricetohtml($preu_per_compradors); ?> |
|
82 |
|
83 </TABLE> |
|
84 |
|
85 |
|
86 <!-- Taula de compradors globals --> |
|
87 <TABLE BORDER=1> |
|
88 <CAPTION>Compradors globals</CAPTION> |
|
89 <TR> |
|
90 <TH>Persona |
|
91 <TH>Pagat |
|
92 <TH>Toca pagar |
|
93 <TH>Percentatge |
|
94 <TH>Toca pagar + excepcions |
|
95 <TH>Balanç |
|
96 <?php |
|
97 $suma_pagat = 0; |
|
98 $suma_toca_pagar = 0; |
|
99 $suma_percentatge = 0; |
|
100 $suma_toca_pagar_ex = 0; |
|
101 $suma_balans = 0; |
|
102 foreach($gent as $key => $value) |
|
103 { |
|
104 // Serveix per calcular el preu que toca pagar a cada un realment |
|
105 $modificador = 0; |
|
106 if ($excepcions != 0) |
|
107 foreach($excepcions as $key_ex => $value_ex) |
|
108 { |
|
109 if(isset($compradors_excepcions[$key_ex][$key]["toca_pagar"])) |
|
110 $modificador += $compradors_excepcions[$key_ex][$key]["toca_pagar"]; |
|
111 } |
|
112 |
|
113 |
|
114 if (isset($compradors[$key])) |
|
115 { |
|
116 /* |
|
117 if (!isset($compradors[$key]["pagat"])) |
|
118 $compradors[$key]["pagat"] = 0; |
|
119 if (!isset($compradors[$key]["toca_pagar"])) |
|
120 $compradors[$key]["toca_pagar"] = 0; |
|
121 */ |
|
122 |
|
123 echo "<TR>\n\t<TD>". strtohtml($gent[$key]["nom"]) . "\n"; |
|
124 |
|
125 printf("\t<TD align=right>%s\n", pricetohtml($compradors[$key]["pagat"])); |
|
126 printf("\t<TD align=right>%s\n", pricetohtml($compradors[$key]["toca_pagar"])); |
|
127 printf("\t<TD align=right>%s\n", pricetohtml($compradors[$key]["toca_pagar"] |
|
128 * 100 / $preu_per_compradors)); |
|
129 printf("\t<TD align=right>%s\n", pricetohtml($compradors[$key]["toca_pagar"] |
|
130 + $modificador)); |
|
131 printf("\t<TD align=right>%s\n", pricetohtml($compradors[$key]["pagat"] |
|
132 - ($compradors[$key]["toca_pagar"] + $modificador))); |
|
133 //echo "\t<TD>" . $compradors[$key]["pagat"] . "\n"; |
|
134 //echo "\t<TD>" . $compradors[$key]["toca_pagar"] . "\n"; |
|
135 //echo "\t<TD>" . ($compradors[$key]["toca_pagar"] * 100 / $preu_per_compradors) . "\n"; |
|
136 |
|
137 //echo "\t<TD>" . ($compradors[$key]["toca_pagar"] + $modificador) . "\n"; |
|
138 //echo "\t<TD>" . ($compradors[$key]["pagat"] - ($compradors[$key]["toca_pagar"] + $modificador)) . "\n"; |
|
139 |
|
140 $suma_pagat += $compradors[$key]["pagat"]; |
|
141 $suma_toca_pagar += $compradors[$key]["toca_pagar"]; |
|
142 $suma_percentatge += ($compradors[$key]["toca_pagar"] / $preu_per_compradors*100); |
|
143 $suma_toca_pagar_ex += $compradors[$key]["toca_pagar"] + $modificador; |
|
144 $suma_balans += $compradors[$key]["pagat"] - ($compradors[$key]["toca_pagar"] + $modificador); |
|
145 } |
|
146 } |
|
147 echo "<TR>\n\t<TH>Total\n"; |
|
148 printf("\t<TD align=right>%s\n", pricetohtml($suma_pagat)); |
|
149 printf("\t<TD align=right>%s\n", pricetohtml($suma_toca_pagar)); |
|
150 printf("\t<TD align=right>%s\n", pricetohtml($suma_percentatge)); |
|
151 printf("\t<TD align=right>%s\n", pricetohtml($suma_toca_pagar_ex)); |
|
152 printf("\t<TD align=right>%s\n", pricetohtml($suma_balans)); |
|
153 ?> |
|
154 </TABLE> |
|
155 |
|
156 <HR WIDTH="70%"> |
|
157 <H2>Excepcions</H2> |
|
158 |
|
159 <TABLE BORDER=1> |
|
160 <TR> |
|
161 <TH>Id |
|
162 <TH>Article |
|
163 <TH>Preu |
|
164 <TH COLSPAN=<?php echo $max_compradors_ex ?>>Toca Pagar |
|
165 |
|
166 <?php |
|
167 if ($excepcions != 0) |
|
168 foreach($excepcions as $key => $value) |
|
169 { |
|
170 $compradors_excepcions[$key] = obtenir_compradors_excepcions($key, $connexio); |
|
171 // Poso els noms dels compradors |
|
172 echo "<TR>\n\t<TD>\n\t<TD>\n\t<TD>\n"; |
|
173 foreach($compradors_excepcions[$key] as $key_c => $value_c) |
|
174 { |
|
175 echo "\t<TH>" . $gent[$key_c]["nom"] . "\n"; |
|
176 } |
|
177 // Poso l'excepcio en si |
|
178 printf("<TR>\n\t<TH>%d\n", $key); |
|
179 echo "\t<TD>" . strtohtml($excepcions[$key]["article"]) . "\n"; |
|
180 printf("\t<TD align=right>%s\n", pricetohtml($excepcions[$key]["preu"])); |
|
181 foreach($compradors_excepcions[$key] as $key_c => $value_c) |
|
182 { |
|
183 printf("\t<TD align=right>%.2f\n", pricetohtml($value_c["toca_pagar"])); |
|
184 } |
|
185 } |
|
186 ?> |
|
187 |
|
188 </TABLE> |
|
189 |
|
190 <HR WIDTH="70%"> |
|
191 <BR> |
|
192 <CENTER> |
|
193 <TABLE BORDER=2> |
|
194 <TR> |
|
195 <TD><A HREF="delete-compra?id=<?php echo $_GET["id"]; ?>&sure=yes"><STRONG>ELIMINAR SEGUR!</STRONG></A> |
|
196 </TR> |
|
197 </TABLE> |
|
198 </CENTER> |
|
199 |
|
200 <?php |
|
201 } |
|
202 elseif (isset($_GET["id"]) && $_GET["sure"] == "yes") |
|
203 { |
|
204 if ($excepcions != 0) |
|
205 foreach($excepcions as $key_ex => $value_ex) |
|
206 { |
|
207 // Borrem excepcions |
|
208 $query = "DELETE FROM compradors_excepcions WHERE ex_id=$key_ex;"; |
|
209 if ($touchdb) |
|
210 { |
|
211 $resultat = mysql_query($query, $connexio); |
|
212 if (!$resultat) |
|
213 warn_mysql("compradors_excepcions"); |
|
214 } |
|
215 else |
|
216 echo $query . "<BR>\n"; |
|
217 } |
|
218 // Borrem compradors |
|
219 $query = "DELETE FROM compradors WHERE data=FROM_UNIXTIME($data);"; |
|
220 if ($touchdb) |
|
221 { |
|
222 $resultat = mysql_query($query, $connexio); |
|
223 if (!$resultat) |
|
224 warn_mysql("compradors"); |
|
225 } |
|
226 else |
|
227 echo $query . "<BR>\n"; |
|
228 |
|
229 // Borrem excepcions |
|
230 $query = "DELETE FROM excepcions WHERE data=FROM_UNIXTIME($data);"; |
|
231 if ($touchdb) |
|
232 { |
|
233 $resultat = mysql_query($query, $connexio); |
|
234 if (!$resultat) |
|
235 warn_mysql("excepcions"); |
|
236 } |
|
237 else |
|
238 echo $query . "<BR>\n"; |
|
239 |
|
240 // Borrem compres |
|
241 $query = "DELETE FROM compres WHERE data=FROM_UNIXTIME($data);"; |
|
242 if ($touchdb) |
|
243 { |
|
244 $resultat = mysql_query($query, $connexio); |
|
245 if (!$resultat) |
|
246 warn_mysql("compres"); |
|
247 } |
|
248 else |
|
249 echo $query . "<BR>\n"; |
|
250 |
|
251 echo "<p>Si no hi ha cap error en línies anteriors, la compra ha estat eliminada.</p>\n"; |
|
252 |
|
253 } |
|
254 ?> |
|
255 <BR> |
|
256 <A HREF="index">Tornar al menú d'inici</A> |
|
257 |
|
258 |
|
259 |
|
260 </body> |
|
261 </html> |