← Back
Editing: vedi.php
<?php $titolo = "Vedi fatture"; require_once ("conn.php"); require_once ("testacoda.php"); $query = new doQuery (); $annoc = date("Y"); # anno corrente $anno = isset($_REQUEST['anno']) ? $_REQUEST['anno'] : $annoc; if ($az == "pag") { $riga = $query->freeQuery ("UPDATE `fatture` SET `pagata` = 's' WHERE `id` = $id", 0); # $ris = mysql_query($sql,$connessione) or die($sql.": ".mysql_error()); header ("Location: ".$_SERVER['PHP_SELF']); } else if (!isset($id)) { $totimp = 0; $totsald = 0; $righe = $query->freeQuery ("SELECT *, date_format(data, '%d/%m/%Y') AS data FROM `fatture` WHERE `data`>='$anno-01-01' AND `data`<='$anno-12-31' ORDER BY `numero`", 0); foreach ($righe as $i=>$riga) { $bgcol = $i%2 ? "lightyellow" : ""; $riga2 = $query->freeQuery ( "SELECT * FROM `clienti` WHERE `id`=".$riga->id_cliente." LIMIT 1", 0); $imponibile = $riga->imponibile; if ($riga->pagata == "s") { $saldo = "<img src=\"images/apply.gif\">"; $totsald+= $imponibile; } else $saldo = "<a href=\"".$_SERVER['PHP_SELF']."?id=".$riga->id."&az=pag\"><img src=\"images/kill.gif\" border=\"0\" /></a>"; $totimp+= $imponibile; $nomecli = str_replace("-","<br />", $riga2[0]->denominazione); $indircli = str_replace("-","<br />", $riga2[0]->indirizzo); $codfisc = $riga2[0]->codfisc; $piva = $riga2[0]->partiva; $elenco.= "<tr bgcolor=\"".$bgcol."\"><td><a href=\"fatturepdf.php?id=".$riga->id."\" title=\"vedi fattura ".$riga->numero."\"><img src=\"images/view.gif\" border=\"0\" /></a><td>".$riga->numero."</td> <td><a href=\"javascript:Cli('".addslashes (str_replace ("-","<br />", $riga2[0]->denominazione))."','".addslashes (str_replace ("-","<br />", $riga2[0]->indirizzo))."','".$riga2[0]->codfisc."','$piva')\">".$nomecli."</a><td>\n". $riga->data."</td><td align=\"right\">$imponibile</td><td align=\"center\">$saldo</td></tr>\n"; $cc++; } $totlordo = round ($totimp*1.2, 2); # totale lordo $mese = $anno == $annoc ? date("m") > 1 ? date("m") : 2 : 12 ; # mese corrente o annuale $gmensile = round ($totsald*1.2/2/($mese-1), 2); # guadagno medio mensile incassato $gprevisto = round ($totlordo/2/($mese-1), 2); # guadagno mensile previsto for ($i=2004; $i<=$annoc; $i++) $anni.= "<a hreF=\"$PHP_SELF?anno=".$i."\">".$i."</a> \n"; # scelta di anno per la visione delle fatture echo "$testa <script language=\"JavaScript\"><!-- function Cli(nome,indir,cf,iva){ var s1 = \"<title>Cliente</title><body bgcolor=\"#ffffee\"><b>\"+ nome +\"</b><br />\"+ indir +\"<br />c. f. \"+ cf +\"<br />p. iva \"+ iva +\"</body>\" popup = window.open(\"\",\"popDialog\",\"height=150,width=300,scrollbars=no\") popup.document.write(s1) popup.document.close() } --></script> <p>Anno ".$anni."</p> <table width=\"700\"><tr bgcolor=\"white\"><td></td><td><b>Numero</b></td><td><b>Cliente</b></td><td><b>Data</b></td><td width=\"50\" align=\"right\"><b>Imponibile</b></td><td align=\"right\">Saldo</b></td></tr> ".$elenco." <tr><td colspan=\"4\"></td><td bgcolor=\"black\" width=\"45\" height=\"2\"></td></tr> <tr><td colspan=\"4\" align=\"right\"><b>Totale<br />Tot lordo<br />Totale saldato<p>Mensile medio incassato<br />Mensile medio previsto</b></td> <td align=\"right\"><b>".$totimp."<br /> ".$totlordo."<br /> ".$totsald."<p> ".$gmensile."<br /> ".$gprevisto."</b></td></tr> <tr bgcolor=\"yellow\"><td colspan=\"5\"></td></tr> </table> ".$coda; } else { $riga = $query->freeQuery ("SELECT *, date_format(`data`, '%d-%m-%Y') AS `data` FROM `fatture` WHERE `id`=$id", 0); $id = $riga[0]->id; $id_cliente = $riga[0]->id_cliente; $numero = $riga[0]->numero; $data = $riga[0]->data; $imponibile = $riga[0]->imponibile; $tipo = $riga[0]->tipo; # testata echo "<html><head> <meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-15\"> <link href=\"stile.css\" rel=\"stylesheet\" type=\"text/css\"> </head> <body bgcolor=\"white\" text=\"black\" link=\"black\" vlink=\"black\" leftmargin=\"0\" topmargin=\"0\"> <table align=\"center\" width=\"620\"> <tr><td align=\"center\" colspan=\"2\"> <table><tr> <td align=\"center\"><img src=\"smartmedia/pics/smartlogop.gif\"> <td align=\"center\"><img src=\"smartmedia/pics/smartmedia2000.gif\"> <tr><td colspan=\"2\" height=\"40\" valign=\"top\" style=\"text-align:center; font-weight:bold; font-size:12px; font-family:Arial\">di Felici ing. Fabrizio - v. Lituania 46, 58100 Grosseto - Tel. 3476444150 0564453651 - p. IVA 01208620532 </td></tr></table>"; # cliente $riga = $query->freeQuery ("SELECT * FROM `clienti` WHERE `id`=$id_cliente", 0); $nomecli = str_replace("-","<br />",$riga[0]->denominazione); $indircli = str_replace("-","<br />",$riga[0]->indirizzo); echo "<tr><td width=380 height=\"1\"70><td width=\"2\"40 valign=\"top\"><b>$nomecli<br />$indircli<br />p.iva ".$riga[0]->partiva.""; echo "<tr><td height=\"60\"><b>Fattura n. $numero del $data"; # prestazioni echo "<tr><td align=\"center\" colspan=\"2\"> <table ellspacing=\"0\" cellpadding=\"1\"><tr bgcolor=\"lightgrey\"><td width=\"550\"><b>Descrizione prestazioni<td width=\"70\" align=\"center\"><b>€"; $righe = $query->freeQuery ("SELECT * FROM `prestazioni` WHERE `id_fattura`=$id", 0); $importo = 0; foreach ($righe as $i=>$riga) { echo "<tr><td>".$riga[0]->descrizione."<td align=\"right\">".$riga[0]->importo."</td></tr>"; $importo+= $riga[0]->importo; } # calcoli delle cifre if (round($importo*1.04,2) != $imponibile) die ("C'e' un errore negli importi immessi."); $inps = addzero($importo*0.04); $importo = addzero($importo); $iva = addzero($imponibile*0.2); $lordo = addzero($imponibile*1.2); echo "</table><table cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"500\"> <table width=\"544\"><tr><td align=\"right\">totale prestazioni<tr><td align=\"right\">contributo I.N.P.S. 4% <tr><td align=\"right\">imponibile I.V.A.<tr><td align=\"right\">I.V.A. 20% <tr><td align=\"right\"><b>TOTALE complessivo"; if ($tipo != 1) echo "<tr><td align=\"right\"><b>r.a. a detrarre 20%<tr><td align=\"right\"><b>TOTALE netto a pagare"; echo "</table><td width=\"1\"00> <table cellspacing=\"0\" cellpadding=\"1\" width=\"76\"><tr><td align=\"right\">$importo<tr><td align=\"right\">$inps<tr><td align=\"right\">$imponibile<tr><td align=\"right\">$iva <tr><td align=\"right\"><b>$lordo"; if ($tipo != 1) echo "<tr><td align=\"right\"><b>$iva<tr><td align=\"right\"><b>$imponibile"; echo "</table></table>"; # note echo "<tr><td height=\"140\" colspan=\"2\" style=\"text-align:justify;\"><b>Prego vogliate saldare tramite accredito su conto corrente bancario n. CC1190000251 presso Unipol banca Grosseto intestato a <b>Felici Fabrizio</b>, CIN H, ABI 3127, CAB 14301</td><tr>"; # data e firma echo "<tr><td height=\"80\" valign=\"top\"><b>Grosseto, $data<td valign=bottom><b>Ing. Fabrizio Felici </table></body></html>"; } ?>
Save File
Cancel