|
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
|
2 <html> |
|
3 <head> |
|
4 <title>Ètxelon - Eliminar pagament</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 $pagament = obtenir_pagament($data, $connexio); |
|
29 $pagadors = obtenir_pagadors($data, $connexio); |
|
30 |
|
31 if(!isset($_GET["sure"]) && isset($_GET["id"])) |
|
32 { |
|
33 ?> |
|
34 |
|
35 <H1 ALIGN=center>Eliminar pagament</H1> |
|
36 |
|
37 <H2>Dades generals</H2> |
|
38 |
|
39 <p> Dades del pagament: </p> |
|
40 <TABLE BORDER=0> |
|
41 <TR> |
|
42 <TH>Data i Hora: |
|
43 <TD> <?php |
|
44 echo date("d/m/Y H:i",$data); ?> |
|
45 |
|
46 <TR> |
|
47 <TH> Comentari: |
|
48 <TD> <?php |
|
49 echo strtohtml($pagament["comentari"]); ?> |
|
50 |
|
51 </TABLE> |
|
52 |
|
53 |
|
54 <H2>Pagadors i cobradors</H2> |
|
55 <!-- Taula de compradors globals --> |
|
56 <TABLE BORDER=1> |
|
57 <CAPTION>Pagadors</CAPTION> |
|
58 <TR> |
|
59 <TH>Persona |
|
60 <TH>Pagat |
|
61 <TH>Cobrat |
|
62 <TH>Balanç |
|
63 <?php |
|
64 $suma_pagat = 0; |
|
65 $suma_cobrat = 0; |
|
66 $suma_balans = 0; |
|
67 foreach($gent as $key => $value) |
|
68 { |
|
69 if (isset($pagadors[$key])) |
|
70 { |
|
71 echo "<TR>\n\t<TD>". strtohtml($gent[$key]["nom"]) . "\n"; |
|
72 |
|
73 printf("\t<TD align=right>%.2f\n", $pagadors[$key]["pagat"]); |
|
74 printf("\t<TD align=right>%.2f\n", $pagadors[$key]["cobrat"]); |
|
75 printf("\t<TD align=right>%.2f\n", $pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"]); |
|
76 |
|
77 $suma_pagat += $pagadors[$key]["pagat"]; |
|
78 $suma_cobrat += $pagadors[$key]["cobrat"]; |
|
79 $suma_balans += $pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"]; |
|
80 } |
|
81 } |
|
82 echo "<TR>\n\t<TH>Total\n"; |
|
83 printf("\t<TD align=right>%.2f\n", $suma_pagat); |
|
84 printf("\t<TD align=right>%.2f\n", $suma_cobrat); |
|
85 printf("\t<TD align=right>%.2f\n", $suma_balans); |
|
86 ?> |
|
87 </TABLE> |
|
88 |
|
89 <HR WIDTH="70%"> |
|
90 <BR> |
|
91 <CENTER> |
|
92 <TABLE BORDER=2> |
|
93 <TR> |
|
94 <TD><A HREF="delete-pagament?id=<?php echo $_GET["id"]; ?>&sure=yes"><STRONG>ELIMINAR SEGUR!</STRONG></A> |
|
95 </TR> |
|
96 </TABLE> |
|
97 </CENTER> |
|
98 |
|
99 <?php |
|
100 } |
|
101 elseif (isset($_GET["id"]) && $_GET["sure"] == "yes") |
|
102 { |
|
103 // Borrem pagadors |
|
104 $query = "DELETE FROM pagadors WHERE data=FROM_UNIXTIME($data);"; |
|
105 if ($touchdb) |
|
106 { |
|
107 $resultat = mysql_query($query, $connexio); |
|
108 if (!$resultat) |
|
109 warn_mysql("pagadors"); |
|
110 } |
|
111 else |
|
112 echo $query . "<BR>\n"; |
|
113 |
|
114 // Borrem pagament |
|
115 $query = "DELETE FROM pagaments WHERE data=FROM_UNIXTIME($data);"; |
|
116 if ($touchdb) |
|
117 { |
|
118 $resultat = mysql_query($query, $connexio); |
|
119 if (!$resultat) |
|
120 warn_mysql("pagaments"); |
|
121 } |
|
122 else |
|
123 echo $query . "<BR>\n"; |
|
124 |
|
125 echo "<p>Si no hi ha cap error en línies anteriors, el pagament ha estat eliminat.</p>\n"; |
|
126 |
|
127 } |
|
128 ?> |
|
129 <BR> |
|
130 <A HREF="index">Tornar al menú d'inici</A> |
|
131 |
|
132 |
|
133 |
|
134 </body> |
|
135 </html> |