← Back
Editing: index.php
<?php $titolo = "Vedi fatture"; require_once ("funct.php"); require_once ("conn.php"); $annoc = date("Y"); # anno corrente $anno = isset($_REQUEST['anno']) ? $_REQUEST['anno'] : $annoc; require_once ("testacoda.php"); $query = new doQuery (); $mensPrev = 0; if ($az == "pag") { $row = $query->freeQuery ("UPDATE `fatture` SET `pagata` = 's', `data_pagam` = '".data2date ($_REQUEST['data_pagam'])."' WHERE `id` = $id", 0); header ("Location: ".$_SERVER['PHP_SELF']."?anno=$anno"); } else if (!isset($id)) { $mese = $anno == $annoc ? date("m") > 1 ? date("m")-1 : 1 : 12 ; # mese corrente o annuale $totimp = 0; $totsald = 0; $rows = $query->freeQuery ("SELECT * FROM `fatture` WHERE `data`>='".$anno."-01-01' AND `data`<='".$anno."-12-31' ORDER BY `numero`", 0); foreach ($rows as $i=>$row) { $bgcol = $i%2 ? "lightyellow" : ""; $row2 = $query->freeQuery ( "SELECT * FROM `clienti` WHERE `id` = ".$row->id_cliente." LIMIT 1", 0); foreach ($arIva as $al=>$dt) { if ($row->data > $dtOl && $row->data <= $dt) $alIva = $al; $dtOl = $dt; } if ($row->pagata == "c") $imponibile = 0; else $imponibile = $row->imponibile; $totimp+= $imponibile; switch ($row->tipo) { case 0: case 1: $note = ""; $totlordo+= round ($imponibile*(100+$alIva)/100, 2); $saldato = addzero (round ($imponibile*(100+$alIva)/100, 2), 2); if ($row->data < date ("Y-m-01")) $mensPrev+= round ($imponibile*0.55/$mese, 2); break; case 2: case 3: case 4: $note = "es. IVA"; $totlordo+= $imponibile; $saldato = $imponibile; if ($row->data < date ("Y-m-01")) $mensPrev+= round ($imponibile*0.65/$mese, 2); break; case 11: $note = "ric.fisc."; $totlordo+= $imponibile*(1+($ritaccP/100)); $saldato = addzero ($imponibile*(1+($ritaccP/100)), 2); if ($row->data < date ("Y-m-01")) $mensPrev+= round ($imponibile*0.65/$mese, 2); break; } if ($row->pagata == "c") { # nota di credito $saldo = "N.d.C."; } else if ($row->pagata == "s") { # saldate $saldo = date2data ($row->data_pagam); if ($row->data < date ("Y-m-01")) $totsald+= $saldato; } else { $totavere+= $saldato; $saldo = "<form method=\"post\" name=\"form".$row->id."\"> <a href=\"javascript: void(0);\" onclick=\"javascript:document.getElementById('dt".$row->id."').style.display='block'\"><img src=\"images/apply.gif\" border=\"0\" /></a> <div id=\"dt".$row->id."\" style=\"display: none;\"> <input type=\"text\" name=\"data_pagam\" size=\"12\" /> <input type=\"hidden\" name=\"id\" value=\"".$row->id."\" /> <input type=\"hidden\" name=\"az\" value=\"pag\" /> <input type=\"hidden\" name=\"anno\" value=\"".$anno."\" /> <input type=\"submit\" name=\"\" value=\"ins\" /> </div> </form>"; } if (strpos ($row2[0]->denominazione, '--')) $nomecli = str_replace("--","-", $row2[0]->denominazione); else $nomecli = str_replace("@","<br />", $row2[0]->denominazione); $indircli = str_replace("-","<br />", $row2[0]->indirizzo); $codfisc = $row2[0]->codfisc; $piva = $row2[0]->partiva; $elenco.= "<tr bgcolor=\"".$bgcol."\"><td><a href=\"ricevutepdf.php?id=".$row->id."\" title=\"vedi fattura ".$row->numero."\"><img src=\"images/view.gif\" border=\"0\" /></a><td>".$row->numero."</td> <td><a href=\"javascript:Cli('".addslashes ($nomecli."<br />".$indircli."<br />c.f. ".$codfisc." - p.i. ".$piva)."')\">$nomecli</a> <td>".date2data ($row->data)."</td><td>".$note."</td> <td align=\"right\">".$imponibile."</td> <td align=\"right\">".$saldato."</td> <td align=\"center\">".$saldo."</td> </tr>\n"; $cc++; } for ($i=2004; $i<=$annoc; $i++) { if ($i == $anno) $anni.= "<a hreF=\"".$_SERVER['PHP_SELF']."?anno=".$i."\" style=\"color: #FFFF99;\">".$anno."</a> "; # scelta di anno per la visione delle fatture else $anni.= "<a hreF=\"".$_SERVER['PHP_SELF']."?anno=".$i."\">".$i."</a> "; # 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 <?php echo $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><b>Note</b></td> <td width="50" align="right"><b>Netto</b></td> <td width="50" align="right"><b>Lordo</b></td> <td align="center"><b>Saldo - data</b></td></tr> <?= $elenco; ?> <tr><td colspan="5"></td><td colspan="2" bgcolor="#000000" width="45" height="2"></td></tr> <tr><td colspan="5" align="right"><b>Totale<br />Totale saldato<br />Da avere</b></td> <td align="right" valign="top"><b><?= addzero ($totimp, 2); ?></b></td> <td align="right" valign="top"><b><?= addzero (round ($totlordo, 2)); ?><br /> <?= addzero ($totsald, 2); ?><br /> <?= addzero (round ($totavere, 2)); ?></b></td></tr> <tr bgcolor="yellow"><td colspan="5"></td></tr> <tr><td height="40" colspan="8" style="text-align:justify;"><b>Prego vogliate saldare tramite accredito su conto corrente bancario n. 00111772 presso Webank it intestato a Fabrizio Felici, cod. IBAN IT23U0503401753000000111772</td></tr> </table> <?php echo $coda; } else { $row = $query->freeQuery ("SELECT *, date_format(`data`, '%d-%m-%Y') AS `data` FROM `fatture` WHERE `id` = ".$id, 0); $id = $row[0]->id; $id_cliente = $row[0]->id_cliente; $numero = $row[0]->numero; $data = $row[0]->data; $imponibile = $row[0]->imponibile; $tipo = $row[0]->tipo; ?> <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> <?php # cliente $row = $query->freeQuery ("SELECT * FROM `clienti` WHERE `id`=$id_cliente", 0); if (strpos ($row[0]->denominazione, '--')) $nomecli = str_replace("--","-", $row[0]->denominazione); else $nomecli = str_replace("-","<br />",$row[0]->denominazione); $indircli = str_replace("-","<br />",$row[0]->indirizzo); echo "<tr><td width=380 height=\"1\"70><td width=\"2\"40 valign=\"top\"><b>$nomecli<br />$indircli<br />p.iva ".$row[0]->partiva."\n"; echo "<tr><td height=\"60\"><b>Fattura n. $numero del $data"; # prestazioni echo "<tr><td align=\"center\" colspan=\"2\"> <table border cellspacing=\"0\" cellpadding=\"1\"><tr bgcolor=\"lightgrey\"><td width=\"550\"><b>Descrizione prestazioni<td width=\"70\" align=\"center\"><b>€\n"; $rows = $query->freeQuery ("SELECT * FROM `prestazioni` WHERE `id_fattura`=$id", 0); $importo = 0; foreach ($rows as $i=>$row) { echo "<tr><td>".$row[0]->descrizione."<td align=\"right\">".$row[0]->importo."</td></tr>\n"; $importo+= $row[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, 2); $iva = addzero ($imponibile*$alIva/100, 2); $lordo = addzero ($imponibile*(100+$alIva)/100, 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\n"; if ($tipo != 1) echo " <tr><td align=\"right\"><b>r.a. a detrarre 20%<tr><td align=\"right\"><b>TOTALE netto a pagare\n"; echo " </table><td width=\"1\"00> <table border 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\n"; if ($tipo != 1) echo " <tr><td align=\"right\"><b>$iva<tr><td align=\"right\"><b>$imponibile\n"; ?> </table> </table> <tr><td height="140" colspan="2" style="text-align:justify;"><b>Prego vogliate saldare tramite accredito su conto corrente bancario n. 00111772 presso Webank it intestato a Fabrizio Felici, cod. IBAN IT23U0503401753000000111772</td></tr> <tr><td height="80" valign="top"><b>Grosseto, $data<td valign=bottom><b>Ing. Fabrizio Felici <tr><td height="140" colspan="2" style="text-align:justify;"><b>Prego vogliate saldare tramite accredito su conto corrente bancario n. 00111772 presso Webank it intestato a Fabrizio Felici, cod. IBAN IT23U0503401753000000111772</td></tr></table> </body> </html> <?php } ?>
Save File
Cancel