← Back
Editing: rep_caparre.php
<?php require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); require_once ("testacoda.php"); $query = new doQuery(); $mm = $_REQUEST['mm']; $aa = $_REQUEST['aa']; $tp = $_REQUEST['tp']; # seleziona la prima caparra per inizio anno $sql0 = "SELECT DATE_FORMAT(`data`, '%Y') AS `anno` FROM `pagamenti` WHERE `id_utente` = ".ID_UTENTE." AND `pagamenti`.`tipo` = 2 AND `pagamenti`.`data` > '2000-01-01' ORDER BY `pagamenti`.`data` LIMIT 1"; $row0 = $query->freeQuery ($sql0, 0); $anno0 = $row0[0]->anno; # array dei tipi contratti $tpAr = array ("Tutti"=>"Tutti"); foreach ($tipoAr as $nm) $tpAr[$nm] = $nm; for ($i=2; $i<=count ($tipoContrAr); $i++) $tpAr[$tipoContrAr[$i]] = $tipoContrAr[$i]; ?> <form method="post" name="data" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <h3 align=\"center\">Caparre del mese <?php echo selNumb ("mm", 1, 12, '', $mm, '', '')." ".selNumb ("aa", $anno0, date("Y"), '', $aa, '', '')." di ".selList ("tp", $tpAr, '', $tp, '', '')." ".ABBR_STR; ?> <input type="hidden" name ="op" value="ds" /><input type="submit" value="mostra" /></h3> </form> <?php if ($op == "ds") { $sql = "SELECT `contratti`.`id`, `numero`, `contratti`.`data_in`, `contratti`.`stato`, `cognome`, `nome`, `cifra`, `pagamenti`.`data`, `metodo`, `id_fiscale`, `pagamenti`.`tipo` FROM `pagamenti`, $wc2p AND `pagamenti`.`id_contratto` = `contratti`.`id` AND (`pagamenti`.`tipo` = 2 OR `pagamenti`.`tipo` = 6 ) AND `pagamenti`.`data` LIKE '".$aa."-".$mm."%'"; if ($tp != "Tutti") $sql.= "AND `numero` LIKE '".$tp." %'"; $sql.= "GROUP BY `contratti`.`numero` ORDER BY `pagamenti`.`data`"; $rows = $query->freeQuery ($sql, 0); foreach ($rows as $row) { $sqlf = "SELECT * FROM `fiscali` WHERE `id_contratto` = ".$row->id." AND `tipo` > 3"; $rowf = $query->freeQuery ($sqlf, 0); $numero = $rowf[0]->numero; $data = $rowf[0]->data; if ($rowf[0]->numero == "") { $sqlf = "SELECT * FROM `fiscali` WHERE `id` = ".$row->id_fiscale." AND `tipo` > 3"; $rowf = $query->freeQuery ($sqlf, 0); $numero = $rowf[0]->numero; $data = $rowf[0]->data; } $stato = $row->stato < 0 ? "<b>disdetto</b>" : "rif int"; $cifra = $row->tipo == 2 ? $row->cifra : -($row->cifra); $totale+= $cifra; $testo.= "<tr><td><b>".$row->numero." ".$row->cognome." ".$row->nome."</b> ".date2data ($row->data_in)."</td><td></td><td align=\"right\"><b>".$cifra."€</b></td><td>".dateNoTime (date2data($row->data))." ".$metodiPag0[$row->metodo]."</td><td></td><td>$stato <b>".$numero."</b> ".dateNoTime (date2data($data))."</td></tr>"; } ?> <table><tr><td>CONTRATTO</td><td> </td><td colspan="2">CAPARRA (tot. <?php echo $totale; ?>€)</td><td> </td><td>DOC FISCALE</td></tr> <?php echo $testo; ?> </table> <p><input name="invio" type="button" value="Stampa" onclick="javascript:print();" /></p> <?php } ?>
Save File
Cancel