|
1 <?php |
|
2 |
|
3 include("./strings.inc"); |
|
4 |
|
5 class llistes |
|
6 { |
|
7 |
|
8 function LlistaButxaques($connexio) |
|
9 { |
|
10 ?> |
|
11 <table border=1> |
|
12 <tr> |
|
13 <th><?php echo _("ID") ?> |
|
14 <th><?php echo _("Nom") ?> |
|
15 <?php |
|
16 |
|
17 $butxaques = obtenir_butxaques($connexio); |
|
18 |
|
19 foreach(array_keys($butxaques) as $i) |
|
20 { |
|
21 echo "<TR>\n"; |
|
22 echo "\t<TD>" . $i . "\n"; |
|
23 echo "\t<TD>" . strtohtml($butxaques[$i]) . "\n"; |
|
24 } |
|
25 |
|
26 |
|
27 ?> |
|
28 |
|
29 </table> |
|
30 <?php |
|
31 return 0; |
|
32 } |
|
33 |
|
34 function LlistaMoviments($connexio, $ordre=1) |
|
35 { |
|
36 ?> |
|
37 <table border=1> |
|
38 <tr> |
|
39 <th><a href="llista-moviments?ordre=1"><?php echo _("Data") ?></a> |
|
40 <th><a href="llista-moviments?ordre=2"><?php echo _("Modificat") ?></a> |
|
41 <th><?php echo _("Orígen") ?> |
|
42 <th><?php echo _("Destí") ?> |
|
43 <th><?php echo _("Diners") ?> |
|
44 <th><?php echo _("Raó") ?> |
|
45 <?php |
|
46 $butxaques = obtenir_butxaques($connexio); |
|
47 |
|
48 if ($ordre == 1) |
|
49 $query ="SELECT UNIX_TIMESTAMP(data), |
|
50 UNIX_TIMESTAMP(data_modif), butxaca_origen, |
|
51 butxaca_desti, quantitat, rao FROM moviments |
|
52 ORDER BY data DESC;"; |
|
53 else |
|
54 $query ="SELECT UNIX_TIMESTAMP(data), |
|
55 UNIX_TIMESTAMP(data_modif), butxaca_origen, |
|
56 butxaca_desti, quantitat, rao FROM moviments |
|
57 ORDER BY data_modif DESC;"; |
|
58 $resultat = mysql_query($query, $connexio); |
|
59 |
|
60 if (!$resultat) |
|
61 { |
|
62 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
63 return 1; |
|
64 } |
|
65 |
|
66 while ($fila = mysql_fetch_row($resultat)) |
|
67 { |
|
68 echo "<TR>\n"; |
|
69 echo "\t<TD><a href=\"update-moviment?id=". $fila[0]. |
|
70 "\">" . date("d/m/Y H:i",$fila[0]) . |
|
71 "</a>\n"; |
|
72 echo "\t<TD>". date("d/m/Y H:i",$fila[1]) ."\n"; |
|
73 echo "\t<TD>" . strtohtml($butxaques[$fila[2]]) . "\n"; |
|
74 echo "\t<TD>" . strtohtml($butxaques[$fila[3]]) . "\n"; |
|
75 echo "\t<TD>" . sprintf("%.2f", $fila[4]) . "\n"; |
|
76 echo "\t<TD>" . strtohtml($fila[5]) . "\n"; |
|
77 } |
|
78 |
|
79 |
|
80 ?> |
|
81 |
|
82 </table> |
|
83 <?php |
|
84 return 0; |
|
85 } |
|
86 |
|
87 function LlistaIngressos($connexio, $ordre=1) |
|
88 // 1 = per data. altres, per data_modif |
|
89 { |
|
90 ?> |
|
91 <table border=1> |
|
92 <tr> |
|
93 <th><a href="llista-ingressos?ordre=1"><?php echo _("Data") ?></a> |
|
94 <th><a href="llista-ingressos?ordre=2"><?php echo _("Modificat") ?></a> |
|
95 <th><?php echo _("Butxaca") ?> |
|
96 <th><?php echo _("Diners") ?> |
|
97 <th><?php echo _("Raó") ?> |
|
98 <?php |
|
99 $butxaques = obtenir_butxaques($connexio); |
|
100 |
|
101 if ($ordre == 1) |
|
102 $query ="SELECT UNIX_TIMESTAMP(data), |
|
103 UNIX_TIMESTAMP(data_modif), butxaca, |
|
104 quantitat, rao FROM ingressos ORDER BY data DESC;"; |
|
105 else |
|
106 $query ="SELECT UNIX_TIMESTAMP(data), |
|
107 UNIX_TIMESTAMP(data_modif), butxaca, |
|
108 quantitat, rao FROM ingressos ORDER BY data_modif DESC;"; |
|
109 $resultat = mysql_query($query, $connexio); |
|
110 |
|
111 if (!$resultat) |
|
112 { |
|
113 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
114 return 1; |
|
115 } |
|
116 |
|
117 while ($fila = mysql_fetch_row($resultat)) |
|
118 { |
|
119 echo "<TR>\n"; |
|
120 echo "\t<TD><a href=\"update-ingres?id=". $fila[0]. |
|
121 "\">" . date("d/m/Y H:i",$fila[0]) . |
|
122 "</a>\n"; |
|
123 echo "\t<TD>". date("d/m/Y H:i",$fila[1]) ."\n"; |
|
124 echo "\t<TD>" . strtohtml($butxaques[$fila[2]]) . "\n"; |
|
125 echo "\t<TD>" . pricetohtml( $fila[3]) . "\n"; |
|
126 echo "\t<TD>" . strtohtml($fila[4]) . "\n"; |
|
127 "</a>\n"; |
|
128 } |
|
129 |
|
130 |
|
131 ?> |
|
132 |
|
133 </table> |
|
134 <?php |
|
135 return 0; |
|
136 } |
|
137 |
|
138 function StatusButxaques($connexio) |
|
139 { |
|
140 ?> |
|
141 <table border=1> |
|
142 <tr> |
|
143 <th><?php echo _("Butxaca") ?> |
|
144 <th><?php echo _("Ingressos") ?> |
|
145 <th><?php echo _("Despeses") ?> |
|
146 <th><?php echo _("Moviments negatius") ?> |
|
147 <th><?php echo _("Moviments positius") ?> |
|
148 <th><?php echo _("Total") ?> |
|
149 <?php |
|
150 $butxaques = obtenir_butxaques($connexio); |
|
151 |
|
152 $total = 0; |
|
153 |
|
154 foreach(array_keys($butxaques) as $i) |
|
155 { |
|
156 echo "<tr>"; |
|
157 echo "<td>" . $butxaques[$i]. "\n"; |
|
158 |
|
159 // Ingressos |
|
160 $query ="SELECT SUM(quantitat) FROM ingressos WHERE |
|
161 butxaca =" . $i. " AND quantitat > 0;"; |
|
162 $resultat = mysql_query($query, $connexio); |
|
163 |
|
164 if (!$resultat) |
|
165 { |
|
166 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
167 return 1; |
|
168 } |
|
169 |
|
170 $fila = mysql_fetch_row($resultat); |
|
171 $ingressos = $fila[0]; |
|
172 echo "<td>" . pricetohtml($fila[0]). "\n"; |
|
173 |
|
174 // Despeses |
|
175 $query ="SELECT SUM(quantitat) FROM ingressos WHERE |
|
176 butxaca =" . $i. " AND quantitat < 0;"; |
|
177 $resultat = mysql_query($query, $connexio); |
|
178 |
|
179 if (!$resultat) |
|
180 { |
|
181 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
182 return 1; |
|
183 } |
|
184 |
|
185 $fila = mysql_fetch_row($resultat); |
|
186 echo "<td>" . pricetohtml($fila[0]). "\n"; |
|
187 $ingressos = $ingressos + $fila[0]; |
|
188 |
|
189 // Moviments negatius |
|
190 $query ="SELECT SUM(quantitat) FROM moviments WHERE |
|
191 butxaca_origen =" . $i. ";"; |
|
192 $resultat = mysql_query($query, $connexio); |
|
193 |
|
194 if (!$resultat) |
|
195 { |
|
196 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
197 return 1; |
|
198 } |
|
199 |
|
200 $fila = mysql_fetch_row($resultat); |
|
201 echo "<td>" . pricetohtml(-$fila[0]). "\n"; |
|
202 $ingressos = $ingressos - $fila[0]; |
|
203 |
|
204 // Moviments positius |
|
205 $query ="SELECT SUM(quantitat) FROM moviments WHERE |
|
206 butxaca_desti =" . $i. ";"; |
|
207 $resultat = mysql_query($query, $connexio); |
|
208 |
|
209 if (!$resultat) |
|
210 { |
|
211 echo mysql_errno().": ".mysql_error()."<BR>"; |
|
212 return 1; |
|
213 } |
|
214 |
|
215 $fila = mysql_fetch_row($resultat); |
|
216 echo "<td>" . pricetohtml($fila[0]). "\n"; |
|
217 $ingressos = $ingressos + $fila[0]; |
|
218 |
|
219 echo "<td>" . pricetohtml($ingressos) . "\n"; |
|
220 $total = $total + $ingressos; |
|
221 } |
|
222 |
|
223 echo "<tr>\n"; |
|
224 echo "<th>". _("Total"). "<td><td><td><td><td>" . pricetohtml($total). |
|
225 "\n"; |
|
226 |
|
227 |
|
228 ?> |
|
229 |
|
230 </table> |
|
231 <?php |
|
232 return 0; |
|
233 } |
|
234 |
|
235 } // Fi de classe |
|
236 ?> |