--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/delete-pagament.php Sat May 06 00:50:37 2006 +0200
@@ -0,0 +1,135 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<html>
+<head>
+ <title>Ètxelon - Eliminar pagament</title>
+ <meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1">
+</head>
+
+<body>
+<?php
+
+ include("getdb.inc");
+ // Variables globals
+ $touchdb = 1; // Si val 0, no es modificarà la base de dades
+
+ // Fem la connexió
+ $connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password);
+ mysql_select_db($mysql_db, $connexio);
+
+ $data = $_GET["id"];
+
+
+ // Crides a funcions per obtenir parametres
+ $habitants = obtenir_habitants($connexio);
+ $num_habitants = count($habitants);
+ $altres = obtenir_altres($connexio);
+ $gent = obtenir_gent($connexio);
+
+ $pagament = obtenir_pagament($data, $connexio);
+ $pagadors = obtenir_pagadors($data, $connexio);
+
+if(!isset($_GET["sure"]) && isset($_GET["id"]))
+{
+?>
+
+<H1 ALIGN=center>Eliminar pagament</H1>
+
+<H2>Dades generals</H2>
+
+<p> Dades del pagament: </p>
+<TABLE BORDER=0>
+<TR>
+ <TH>Data i Hora:
+ <TD> <?php
+ echo date("d/m/Y H:i",$data); ?>
+
+<TR>
+ <TH> Comentari:
+ <TD> <?php
+ echo strtohtml($pagament["comentari"]); ?>
+
+</TABLE>
+
+
+<H2>Pagadors i cobradors</H2>
+<!-- Taula de compradors globals -->
+<TABLE BORDER=1>
+<CAPTION>Pagadors</CAPTION>
+<TR>
+ <TH>Persona
+ <TH>Pagat
+ <TH>Cobrat
+ <TH>Balanç
+<?php
+ $suma_pagat = 0;
+ $suma_cobrat = 0;
+ $suma_balans = 0;
+ foreach($gent as $key => $value)
+ {
+ if (isset($pagadors[$key]))
+ {
+ echo "<TR>\n\t<TD>". strtohtml($gent[$key]["nom"]) . "\n";
+
+ printf("\t<TD align=right>%.2f\n", $pagadors[$key]["pagat"]);
+ printf("\t<TD align=right>%.2f\n", $pagadors[$key]["cobrat"]);
+ printf("\t<TD align=right>%.2f\n", $pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"]);
+
+ $suma_pagat += $pagadors[$key]["pagat"];
+ $suma_cobrat += $pagadors[$key]["cobrat"];
+ $suma_balans += $pagadors[$key]["pagat"] - $pagadors[$key]["cobrat"];
+ }
+ }
+ echo "<TR>\n\t<TH>Total\n";
+ printf("\t<TD align=right>%.2f\n", $suma_pagat);
+ printf("\t<TD align=right>%.2f\n", $suma_cobrat);
+ printf("\t<TD align=right>%.2f\n", $suma_balans);
+?>
+</TABLE>
+
+<HR WIDTH="70%">
+<BR>
+<CENTER>
+<TABLE BORDER=2>
+<TR>
+ <TD><A HREF="delete-pagament?id=<?php echo $_GET["id"]; ?>&sure=yes"><STRONG>ELIMINAR SEGUR!</STRONG></A>
+</TR>
+</TABLE>
+</CENTER>
+
+<?php
+}
+elseif (isset($_GET["id"]) && $_GET["sure"] == "yes")
+{
+ // Borrem pagadors
+ $query = "DELETE FROM pagadors WHERE data=FROM_UNIXTIME($data);";
+ if ($touchdb)
+ {
+ $resultat = mysql_query($query, $connexio);
+ if (!$resultat)
+ warn_mysql("pagadors");
+ }
+ else
+ echo $query . "<BR>\n";
+
+ // Borrem pagament
+ $query = "DELETE FROM pagaments WHERE data=FROM_UNIXTIME($data);";
+ if ($touchdb)
+ {
+ $resultat = mysql_query($query, $connexio);
+ if (!$resultat)
+ warn_mysql("pagaments");
+ }
+ else
+ echo $query . "<BR>\n";
+
+ echo "<p>Si no hi ha cap error en línies anteriors, el pagament ha estat eliminat.</p>\n";
+
+}
+?>
+<BR>
+<A HREF="index">Tornar al menú d'inici</A>
+
+
+
+</body>
+</html>