|
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
|
2 <html> |
|
3 <head> |
|
4 <title>Ètxelon - Veure pagament</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>Veure pagament</H1> |
|
12 |
|
13 <?php |
|
14 include("getdb.inc"); |
|
15 |
|
16 // Fem la connexió |
|
17 $connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password); |
|
18 mysql_select_db($mysql_db, $connexio); |
|
19 |
|
20 |
|
21 $data = $_GET["id"]; |
|
22 |
|
23 // Crides a funcions per obtenir parametres |
|
24 $habitants = obtenir_habitants($connexio); |
|
25 $num_habitants = count($habitants); |
|
26 $altres = obtenir_altres($connexio); |
|
27 $gent = obtenir_gent($connexio); |
|
28 |
|
29 $pagament = obtenir_pagament($data, $connexio); |
|
30 $pagadors = obtenir_pagadors($data, $connexio); |
|
31 ?> |
|
32 |
|
33 <H2>Dades generals</H2> |
|
34 |
|
35 <p> Dades del pagament: </p> |
|
36 <TABLE BORDER=0> |
|
37 <TR> |
|
38 <TH>Data i Hora: |
|
39 <TD> <?php |
|
40 echo date("d/m/Y H:i",$data); ?> |
|
41 |
|
42 <TR> |
|
43 <TH> Comentari: |
|
44 <TD> <?php |
|
45 echo strtohtml($pagament["comentari"]); ?> |
|
46 |
|
47 </TABLE> |
|
48 |
|
49 |
|
50 <H2>Pagadors i cobradors</H2> |
|
51 <!-- Taula de compradors globals --> |
|
52 <TABLE BORDER=1> |
|
53 <CAPTION>Pagadors</CAPTION> |
|
54 <TR> |
|
55 <TH>Persona |
|
56 <TH>Pagat |
|
57 <TH>Cobrat |
|
58 <TH>Balanç |
|
59 <?php |
|
60 $suma_pagat = 0; |
|
61 $suma_cobrat = 0; |
|
62 $suma_balans = 0; |
|
63 foreach($gent as $key => $value) |
|
64 { |
|
65 if (isset($pagadors[$key])) |
|
66 { |
|
67 echo "<TR>\n\t<TD>". strtohtml($gent[$key]["nom"]) . "\n"; |
|
68 |
|
69 printf("\t<TD align=right>%s\n", pricetohtml($pagadors[$key]["pagat"])); |
|
70 printf("\t<TD align=right>%s\n", pricetohtml($pagadors[$key]["cobrat"])); |
|
71 printf("\t<TD align=right>%s\n", pricetohtml($pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"])); |
|
72 |
|
73 $suma_pagat += $pagadors[$key]["pagat"]; |
|
74 $suma_cobrat += $pagadors[$key]["cobrat"]; |
|
75 $suma_balans += $pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"]; |
|
76 } |
|
77 } |
|
78 echo "<TR>\n\t<TH>Total\n"; |
|
79 printf("\t<TD align=right>%.2f\n", pricetohtml($suma_pagat)); |
|
80 printf("\t<TD align=right>%.2f\n", pricetohtml($suma_cobrat)); |
|
81 printf("\t<TD align=right>%.2f\n", pricetohtml($suma_balans)); |
|
82 ?> |
|
83 </TABLE> |
|
84 |
|
85 <HR WIDTH="70%"> |
|
86 |
|
87 <H2>Llegenda</H2> |
|
88 |
|
89 <UL> |
|
90 <LI>La suma del que s'ha <em>pagat</em> ha de ser igual a la suma del que s'ha |
|
91 <em>cobrat</em>. O sigui, que el <em>balanç total</em> ha de ser |
|
92 <strong>0</strong>. |
|
93 </UL> |
|
94 |
|
95 <HR WIDTH="70%"> |
|
96 <BR> |
|
97 <A HREF="index">Tornar al menú d'inici</A> |
|
98 |
|
99 </body> |
|
100 </html> |