echo "<tr><td><input type=\"text\" name=\"righi[{$key}][descri]\" value=\"{$value['descri']}\" maxlength=\"50\" size=\"50\"></td>\n"; echo "<td align=\"right\"><input align=\"right\" type=\"text\" name=\"righi[{$key}][prelis]\" value=\"".preg_replace("/\,/",'.', $importo_rigo)."\" maxlength=\"11\" size=\"11\"></td>\n"; echo "<td align=\"right\"><input type=\"image\" name=\"del[{$key}]\" src=\"../../library/images/xbut.gif\" title=\"Elimina rigo!\"></td></tr>\n"; echo "<input type=\"hidden\" name=\"righi[{$key}][id_rig]\" value=\"{$value['id_rig']}\">\n"; } if($_POST['num_rigo'] > 0) { echo "<tr><td></td><td align=\"right\"class=\"FacetAltDataTD\">Totale € ".number_format($totale,2, '.', '')." </td><td align=\"right\">\n"; if ($toDo == 'update') { echo '<input title="Modifica il movimento contabile e la ricevuta di pagamento" type="submit" value="MODIFICA !" accesskey="i" name="upd">'; } else { echo '<input title="Inserisci il movimento contabile e la ricevuta di pagamento" type="submit" value="INSERISCI !" accesskey="i" name="ins" id="preventDuplicate" onClick="chkSubmit();">'; } echo "</td></tr>\n"; } //recupero tutti i movimenti contabili del conto insieme alle relative testate... $result = mergeTable($gTables['rigmoc'],"*",$gTables['tesmov'],"*","id_tes","codcon = ".$conto['codice']." ORDER BY datreg asc"); $nummov = gaz_dbi_num_rows($result); if ($nummov > 0) { echo "</table><br \><table class=\"Tlarge\"><tr><td colspan=\"6\">Questi sono i movimenti contabili relativi al fornitore ".$conto['ragso1']." ".$conto['ragso2'].":<td></tr>\n"; echo "<tr><th class=\"FacetFieldCaptionTD\">Mov.</th><th class=\"FacetFieldCaptionTD\">Descrizione</th><th class=\"FacetFieldCaptionTD\">N.Doc.</th><th class=\"FacetFieldCaptionTD\">Data Doc.</th><th class=\"FacetFieldCaptionTD\">Importo</th><th class=\"FacetFieldCaptionTD\">D/A</th></tr>\n"; while ($movimenti = gaz_dbi_fetch_array($result)) { $cl="FacetDataTD"; if ($movimenti["id_tes"] == $testata["id_con"]) { $cl="FacetDataTDred"; } echo "<tr><td class=\"$cl\">n.<a href=\"../contab/admin_movcon.php?Update&id_tes=".$movimenti["id_tes"]."\" title=\"Modifica il movimento\">".$movimenti["id_tes"]."</a> del ".gaz_format_date($movimenti["datreg"])." </td>\n"; echo "<td class=\"$cl\">".$movimenti["descri"]." </td>"; echo "<td align=\"center\" class=\"$cl\">".$movimenti["numdoc"]." </td>"; if ( $movimenti['datdoc'] > 0 ){ echo "<td align=\"center\" class=\"$cl\">".gaz_format_date($movimenti['datdoc'])." </td>"; } else {
header("Location: select_libgio.php"); exit; } $gioini = substr($_GET['regini'],0,2); $mesini = substr($_GET['regini'],3,2); $annini = substr($_GET['regini'],6,4); $utsini= mktime(0,0,0,$mesini,$gioini,$annini); $giofin = substr($_GET['regfin'],0,2); $mesfin = substr($_GET['regfin'],3,2); $annfin = substr($_GET['regfin'],6,4); $utsfin= mktime(0,0,0,$mesfin,$giofin,$annfin); $datainizio = date("Ymd",$utsini); $datafine = date("Ymd",$utsfin); $title = 'Libro Giornale dal '.date("d-m-Y",$utsini).' al '.date("d-m-Y",$utsfin); //recupero tutti i movimenti contabili insieme alle relative testate... $result = mergeTable($gTables['rigmoc'],"*",$gTables['tesmov'],"*","id_tes","datreg between $datainizio and $datafine ORDER BY datreg, ".$gTables['rigmoc'].".id_tes,id_rig,codcon"); $cover_descri = 'Libro Giornale dell\'anno '.date("Y",$utsfin); $tot_avere=number_format($_GET['valave'],2, '.', ''); $tot_dare=number_format($_GET['valdar'],2, '.', ''); $topCarry = array(array('lenght' => 150,'name'=>'da riporto : ','frame' => 'B','fill'=>0,'font'=>8), array('lenght' => 20,'name'=>'','frame' => 1,'fill'=>0), array('lenght' => 20,'name'=>'','frame' => 1,'fill'=>0)); $botCarry = array(array('lenght' => 150,'name'=>'a riporto : ','frame' => 'T','fill'=>0,'font'=>8), array('lenght' => 20,'name'=>'','frame' => 1,'fill'=>1), array('lenght' => 20,'name'=>'','frame' => 1,'fill'=>1)); $top = array(array('lenght' => 10,'name'=>'Progr.','frame' => 1,'fill'=>1,'font'=>8), array('lenght' => 18,'name'=>'Data Reg.','frame' => 1,'fill'=>1), array('lenght' => 60,'name'=>'Descrizione Operazione / Num. e Data Doc.','frame' => 1,'fill'=>1),
if (!isset($_GET['codice'])){ header("Location: report_credit.php"); exit; } if(!isset($_GET["annfin"])){ $_GET["annfin"] = date("Y"); } if(!isset($_GET["annini"])) { $_GET["annini"] = date("Y")-1; } $anagrafica = new Anagrafica(); $conto = $anagrafica->getPartner(intval($_GET['codice'])); //recupero tutti i movimenti contabili del conto insieme alle relative testate... $result = mergeTable($gTables['rigmoc'],"*",$gTables['tesmov'],"*","id_tes","codcon = ".intval($_GET['codice'])." AND datreg BETWEEN '".intval($_GET["annini"])."0101' AND '".intval($_GET["annfin"])."1231' AND caucon <> 'CHI' AND caucon <> 'APE' OR (caucon = 'APE' AND codcon ='".intval($_GET['codice'])."%' AND datreg LIKE '".intval($_GET["annini"])."%') ORDER BY datreg ASC"); $emissione = 'Estratto conto: '.$conto['ragso1'].' '.$conto['ragso2']; $title = array('title'=>$emissione, 'hile'=>array(array('lun' => 20,'nam'=>'Data'), array('lun' => 75,'nam'=>'Descrizione'), array('lun' => 18,'nam'=>'N.Doc.'), array('lun' => 18,'nam'=>'Data.Doc.'), array('lun' => 18,'nam'=>'Dare'), array('lun' => 18,'nam'=>'Avere'), array('lun' => 20,'nam'=>'Saldo') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->SetTopMargin(39);
print "<tr><th class=\"FacetFieldCaptionTD\">Descrizione</th><th class=\"FacetFieldCaptionTD\">Importo</th><th class=\"FacetFieldCaptionTD\">Selez.</th></tr>\n"; print "<input type=\"hidden\" value=\"{$_POST['rigbon']}\" name=\"rigbon\">\n"; $totale=0.00; foreach ($_POST['righi'] as $key => $value) { $totale+=$value['prelis']; $importo=number_format($value['prelis'],2, '.', ''); print "<tr><td><input type=\"text\" name=\"righi[{$key}][descri]\" value=\"{$value['descri']}\" maxlength=\"50\" size=\"50\"></td>\n"; print "<td align=\"right\"><input align=\"right\" type=\"text\" name=\"righi[{$key}][prelis]\" value=\"{$value['prelis']}\" maxlength=\"11\" size=\"11\"></td>\n"; print "<td align=\"right\"><input type=\"image\" name=\"del[{$key}]\" src=\"../../library/images/xbut.gif\" title=\"Elimina rigo!\"></td></tr>\n"; print "<input type=\"hidden\" name=\"righi[{$key}][id_rig]\" value=\"{$value['id_rig']}\">\n"; } if($_POST['rigbon'] > 0) print "<tr><td></td><td align=\"right\"class=\"FacetAltDataTD\">Totale € ".number_format($totale,2, '.', '')." </td><td align=\"right\"><input type=\"submit\" title=\"Modifica l'$descridoc e proponi la stampa\" value=\"MODIFICA !\" accesskey=\"i\" name=\"update\" ></td></tr>\n"; //recupero tutti i movimenti contabili del conto insieme alle relative testate... $result = mergeTable($gTables['rigmoc'],"*",$gTables['tesmov'],"*","id_tes","codcon = {$conto['codice']} and caucon <> 'CHI' and caucon <> 'APE' ORDER BY datreg asc"); $nummov = gaz_dbi_num_rows($result); if ($nummov > 0) { print "</table><br><table class=\"Tlarge\"><tr><td colspan=\"6\">Questi sono i movimenti contabili, epurati degli eventuali movimenti di apertura e chiusura, relativi al fornitore ".$conto['ragso1']." ".$conto['ragso2'].":<td></tr>\n"; print "<tr><th class=\"FacetFieldCaptionTD\">Mov.</th><th class=\"FacetFieldCaptionTD\">Descrizione</th><th class=\"FacetFieldCaptionTD\">N.Doc.</th><th class=\"FacetFieldCaptionTD\">Data Doc.</th><th class=\"FacetFieldCaptionTD\">Importo</th><th class=\"FacetFieldCaptionTD\">D/A</th></tr>\n"; while ($movimenti = gaz_dbi_fetch_array($result)) { print "<tr><td class=\"FacetDataTD\">n.<a href=\"../contab/admin_movcon.php?Update&id_tes=".$movimenti["id_tes"]."\" title=\"Modifica il movimento\">".$movimenti["id_tes"]."</a> del ".$movimenti["datreg"]." </td>\n"; print "<td class=\"FacetDataTD\">".$movimenti["descri"]." </td>\n"; print "<td align=\"center\" class=\"FacetDataTD\">".$movimenti["numdoc"]." </td>\n"; print "<td align=\"center\" class=\"FacetDataTD\">".$movimenti["datdoc"]." </td>\n"; print "<td align=\"right\" class=\"FacetDataTD\">".number_format($movimenti["import"],2, '.', '')." </td>\n"; print "<td align=\"center\" class=\"FacetDataTD\">".$movimenti["darave"]." </td></tr>\n"; } }