function getData($id_rig) { /* * restituisce tutti i dati relativi al rigo contabile del pagamento */ global $gTables; $anagrafica = new Anagrafica(); $paymov = new Schedule; $sqlquery= "SELECT ".$gTables['tesmov'].".*, ".$gTables['paymov'].".*, ".$gTables['rigmoc'].".import FROM ".$gTables['rigmoc']." LEFT JOIN ".$gTables['paymov']." ON ".$gTables['paymov'].".id_rigmoc_pay = ".$gTables['rigmoc'].".id_rig LEFT JOIN ".$gTables['tesmov']." ON ".$gTables['rigmoc'].".id_tes = ".$gTables['tesmov'].".id_tes WHERE ".$gTables['rigmoc'].".id_rig = $id_rig ORDER BY expiry ASC"; $rs = gaz_dbi_query($sqlquery); $a=array(); $i=1; while ($r = gaz_dbi_fetch_array($rs)) { $a[$i] = $r; $a[$i]['t'] = $paymov->getDocumentData($r['id_tesdoc_ref']); $i++; } return array('d'=>$a,'partner'=>$anagrafica->getPartner($a[1]['clfoco'])); }
function selectCustomer($name,$val,$strSearch='',$val_hiddenReq='',$mesg,$class='FacetSelect') { global $gTables,$admin_aziend; $anagrafica = new Anagrafica(); if ($val>100000000) { //vengo da una modifica della precedente select case quindi non serve la ricerca $partner = $anagrafica->getPartner($val); echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; echo "\t<input type=\"hidden\" name=\"search[$name]\" value=\"".substr($partner['ragso1'],0,8)."\">\n"; echo "\t<input type=\"submit\" value=\"".$partner['ragso1']." ".$partner["ragso2"]." ".$partner["citspe"]." (".$partner["codice"].")\" name=\"change\" onclick=\"this.form.$name.value='0'; this.form.hidden_req.value='change';\" title=\"$mesg[2]\">\n"; } else { if (strlen($strSearch) >= 2) { //sto ricercando un nuovo partner echo "\t<select tabindex=\"1\" name=\"$name\" class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='$name'; this.form.submit();\">\n"; echo "<option value=\"0\"> ---------- </option>"; $partner = $anagrafica->queryPartners("*", "codice LIKE '".$admin_aziend['mascli']."%' AND codice >".intval($admin_aziend['mascli'].'000000')." AND ragso1 LIKE '".addslashes($strSearch)."%'","codice ASC"); if (count($partner) > 0) { foreach ($partner as $r) { $selected = ''; if ($r['codice'] == $val) { $selected = "selected"; } echo "\t\t <option value=\"".$r['codice']."\" $selected >".$r['ragso1']." ".$r["ragso2"]." ".$r["citspe"]."</option>\n"; } echo "\t </select>\n"; } else { $msg = $mesg[0]; } } else { $msg = $mesg[1]; echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; } echo "\t<input tabindex=\"2\" type=\"text\" id=\"search_$name\" name=\"search[$name]\" value=\"".$strSearch."\" maxlength=\"15\" size=\"9\" class=\"FacetInput\">\n"; if (isset($msg)) { echo "<input type=\"text\" style=\"color: red; font-weight: bold;\" size=\"".strlen($msg)."\" disabled value=\"$msg\">"; } echo "\t<input tabindex=\"3\" type=\"image\" align=\"middle\" name=\"search_str\" src=\"../../library/images/cerbut.gif\">\n"; } }
$script_transl['date'] => "conclusion_date", $script_transl['number'] => "doc_number", $script_transl['customer'] => "id_customer", $script_transl['current_fee'] => "current_fee", $script_transl['print'] => "", $script_transl['delete'] => "" ); $linkHeaders = new linkHeaders($headers_tesdoc); $linkHeaders -> output(); ?> </tr> <?php //recupero le testate in base alle scelte impostate $result = gaz_dbi_dyn_query('*',$gTables['contract'], $where, $orderby,$limit, $passo); while ($row = gaz_dbi_fetch_array($result)) { $cliente = $anagrafica->getPartner($row['id_customer']); print "<tr>"; print "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-edit\" href=\"admin_contract.php?Update&id_contract=".$row['id_contract']."\"><i class=\"glyphicon glyphicon-edit\"></i> ".$row["id_contract"]."</a></td>"; print "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_date($row["conclusion_date"])."</td>"; print "<td class=\"FacetDataTD\" align=\"center\">".$row["doc_number"]." </td>"; print "<td class=\"FacetDataTD\" align=\"center\">".$cliente['ragso1']." </td>"; print "<td class=\"FacetDataTD\" align=\"center\">".$row["current_fee"]." </td>"; print "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default\" href=\"print_contract.php?id_contract=".$row['id_contract']."\"><i class=\"glyphicon glyphicon-print\"></i></a></td>"; print "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-elimina\" href=\"delete_contract.php?id_contract=".$row['id_contract']."\"><i class=\"glyphicon glyphicon-remove\"></i></a></td>"; print "</tr>\n"; } ?> </form> </table> </body> </html>
array('lun' => 20,'nam'=>'') ) ); $pdf = new Report_template(); $pdf->setVars($admin_aziend,$title); $pdf->setFooterMargin(22); $pdf->setTopMargin(43); $pdf->setRiporti(''); $pdf->AddPage(); $paymov = new Schedule; $paymov->setScheduledPartner($admin_aziend['mascli']); if (sizeof($paymov->Partners) > 0) { $anagrafica = new Anagrafica(); foreach ($paymov->Partners as $p){ $anagrafica = new Anagrafica(); $prt = $anagrafica->getPartner($p); $pdf->SetFont('helvetica','B',10); $pdf->SetFillColor(200,255,200); $pdf->Ln(2); $pdf->Cell(186,5,$prt['ragso1']." ".$prt['ragso2']." tel:".$prt['telefo']." fax:".$prt['fax']." mob:".$prt['cell']." ",1,1,'',1,'',1); $pdf->SetFont('helvetica','',9); $paymov->getPartnerStatus($p,substr($_GET['date'],0,10)); foreach ($paymov->PartnerStatus as $k=>$v){ $pdf->SetTextColor(255,0,0); $pdf->SetFillColor(230,255,230); $pdf->Cell(56,5,"REF: ".$k,1,0,'',1,'',1); $pdf->SetTextColor(0); $pdf->Cell(130,5, $paymov->docData[$k]['descri'].' n.'. $paymov->docData[$k]['numdoc'].'/'. $paymov->docData[$k]['seziva'].' '.
$utsfin= mktime(0,0,0,$mesfin,$giofin,$annfin); $datafine = date("Ymd",$utsfin); if ($_GET['rp'] <> 'S') { $ristampa = "status <> 'DISTINTATO' and "; } else { $ristampa = "(banacc = '".intval($_GET['ba'])."' or banacc = 0) and "; } $luogo_data=$admin_aziend['citspe'].", lì "; $where = $ristampa." scaden BETWEEN '".$datainizio."' AND '".$datafine."' AND progre BETWEEN '".intval($_GET['ni'])."' AND '".intval($_GET['nf'])."'"; $result = gaz_dbi_dyn_query("*", $gTables['effett'],$where,"tipeff, scaden, id_tes"); $anagrafica = new Anagrafica(); $banacc = $anagrafica->getPartner(intval($_GET['ba'])); $descbanacc = $banacc['ragso1']; if (isset($_GET['de'])) { $luogo_data .= ucwords(strftime("%d %B %Y",$utsemi)); } else { $luogo_data .=ucwords(strftime("%d %B %Y", mktime (0,0,0,date("m"),date("d"),date("Y")))); } $title = array('luogo_data'=>$luogo_data, 'title'=>'Distinta effetti dal '.strftime("%d %B %Y",$utsini).' al '.strftime("%d %B %Y",$utsfin), 'hile'=>array(array('lun' => 18,'nam'=>'Scadenza'), array('lun' => 18,'nam'=>'Effetto'), array('lun' => 100,'nam'=>'Cliente / Indirizzo,P.IVA / Fattura'), array('lun' => 30,'nam'=>'Appoggio'), array('lun' => 24,'nam'=>'Importo') )
} } header("Location: ".$_POST['ritorno']); exit; } else { $message = "Si stà tentando di eliminare un documento diverso dall'ultimo emesso !".$ultimo_documento['tipdoc'].$ultimo_documento['id_tes']; } } if (isset($_POST['Return'])) { header("Location: report_ddtacq.php"); exit; } $form = gaz_dbi_get_row($gTables['tesdoc'], "id_tes", $_GET['id_tes']); $anagrafica = new Anagrafica(); $cliente = $anagrafica->getPartner($form['clfoco']); $titolo="Eliminazione Documento d'Acquisto"; require("../../library/include/header.php"); $script_transl=HeadMain(); ?> <form method="POST"> <input type="hidden" name="id_tes" value="<?php print $_GET['id_tes']; ?>"> <input type="hidden" name="ritorno" value="<?php print $_POST['ritorno'];?>"> <div align="center" class="FacetFormHeaderFont">Attenzione!!! <?php print $titolo;?> </div> <table border="0" cellpadding="3" cellspacing="1" class="FacetFormTABLE" align="center"> <!-- BEGIN Error --> <tr> <td colspan="2" class="FacetDataTD"> <?php if (! $message == "") { print "$message";
$script_transl['descri']=>"descri", $script_transl['protoc']=>"", $script_transl['numdoc']=>"", $script_transl['amount']=>"", $script_transl['source']=> "", $script_transl['delete']=>"" ); $linkHeaders = new linkHeaders($headers_tesmov); $linkHeaders -> output(); $recordnav = new recordnav($gTables['tesmov'], $where, $limit, $passo); $recordnav -> output(); $anagrafica = new Anagrafica(); while ($a_row = gaz_dbi_fetch_array($result)) { $paymov=false; if (substr($a_row["clfoco"],0,3) == $admin_aziend['mascli'] or substr($a_row["clfoco"],0,3) == $admin_aziend['masfor']) { $partner = $anagrafica->getPartner($a_row["clfoco"]); $title = $partner['ragso1']." ".$partner['ragso2']; if (substr($a_row["clfoco"],0,3) == $admin_aziend['mascli']){ $paymov = getPaymov($a_row["id_tes"],$a_row["clfoco"]); } } else { $title = ""; } print "<tr>"; print "<td class=\"FacetDataTD\" align=\"right\"><a class=\"btn btn-xs btn-default btn-edit\" href=\"admin_movcon.php?id_tes=".$a_row["id_tes"]."&Update\" title=\"Modifica\"><i class=\"glyphicon glyphicon-edit\"></i> ".$a_row["id_tes"]."</a>  </td>"; print "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_date($a_row["datreg"])." </td>"; print "<td class=\"FacetDataTD\" title= \"$title\" align=\"center\">".$a_row["caucon"]." </td>"; print "<td class=\"FacetDataTD\" title= \"$title\">".$a_row["descri"]." </td>"; if ($a_row["protoc"] > 0) { print "<td class=\"FacetDataTD\" align=\"center\">".$a_row["protoc"]."/".$a_row["seziva"].""; print "</td>";
$orderby = "id_tes desc"; $result = gaz_dbi_dyn_query ($gTables['tesbro'].".*, ".$gTables['clfoco'].".codice", $gTables['tesbro']." LEFT JOIN ".$gTables['clfoco']." ON ".$gTables['tesbro'].".clfoco = ".$gTables['clfoco'].".codice", $where, $orderby, $limit, $passo); $ctrlprotoc = ""; $anagrafica = new Anagrafica(); while ($r = gaz_dbi_fetch_array($result)) { if ($r["tipdoc"] == 'APR') { $tipodoc="Preventivo"; $modulo="stampa_prefor.php?id_tes=".$r['id_tes']; $modifi="admin_broacq.php?id_tes=".$r['id_tes']."&Update"; } if ($r["tipdoc"] == 'AOR') { $tipodoc="Ordine"; $modulo="stampa_ordfor.php?id_tes=".$r['id_tes']; $modifi="admin_broacq.php?id_tes=".$r['id_tes']."&Update"; } $fornitore = $anagrafica->getPartner($r['clfoco']); echo "<tr>"; if (! empty ($modifi)) { echo "<td class=\"FacetDataTD\"><a class=\"btn btn-xs btn-default\" href=\"".$modifi."\"><i class=\"glyphicon glyphicon-edit\"></i> ".$r["id_tes"]."</td>"; } else { echo "<td class=\"FacetDataTD\"><button class=\"btn btn-xs btn-default disabled\">".$r["id_tes"]." </button></td>"; } echo "<td class=\"FacetDataTD\">".$tipodoc." </td>"; echo "<td class=\"FacetDataTD\">".$r["numdoc"]." </td>"; echo "<td class=\"FacetDataTD\">".gaz_format_date($r["datemi"])." </td>"; echo "<td class=\"FacetDataTD\">".$fornitore["ragso1"]." </td>"; echo "<td class=\"FacetDataTD\">".$r["status"]." </td>"; echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default\" href=\"".$modulo."\"><i class=\"glyphicon glyphicon-print\"></i></a>"; echo "</td>"; // Colonna "Mail" echo "<td class=\"FacetDataTD\" align=\"center\">";
gaz_dbi_table_insert('assist',$form); } elseif ($toDo == 'update') { gaz_dbi_table_update('assist',$form['ref_code'],$form); } header("Location: ".$form['ritorno']); exit; } } elseif (isset($_POST['Return'])) { // torno indietro header("Location: ".$form['ritorno']); exit; } } elseif (!isset($_POST['Update']) && isset($_GET['Update'])) { $assist = gaz_dbi_get_row($gTables['assist'],"codice",$_GET['codice']); //se e' il primo accesso per UPDATE $anagrafica = new Anagrafica(); $cliente = $anagrafica->getPartner($assist['clfoco']); $form = gaz_dbi_get_row($gTables['assist'], 'codice', $_GET['codice']); $form['search']['clfoco']=substr($cliente['ragso1'],0,10); $form['ritorno']=$_SERVER['HTTP_REFERER']; $form['ref_code']=$form['codice']; } else { //se e' il primo accesso per INSERT $form=gaz_dbi_fields('assist'); $rs_ultima_ass = gaz_dbi_dyn_query("codice", $gTables['assist'],$where,"codice desc"); $ultimo_documento = gaz_dbi_fetch_array($rs_ultima_ass); // se e' il primo documento dell'anno, resetto il contatore if ($ultimo_documento) { $form['codice'] = $ultimo_documento['codice'] + 1; } else { $form['codice'] = 1; }
echo $script_transl['view']; echo '" tabindex="100" >'; echo "\t </td>\n"; echo "\t </tr>\n"; echo "</table>\n"; if (isset($_POST['preview']) and $msg=='') { $accounts = accountValue(date("Ymd",$uts_last_closing),date("Ymd",$uts_date_closing)); if ($accounts) { $anagrafica = new Anagrafica(); $loss = $accounts['tot']['cos']; $profit = $accounts['tot']['ric']; $assets = $accounts['tot']['att']; $liabilities = $accounts['tot']['pas']; $ctrl_bal = round($loss + $profit + $assets + $liabilities,2); $income = round($loss + $profit,2); $eco = $anagrafica->getPartner($form['economic_result']); echo "<table class=\"Tlarge\">"; if ($ctrl_bal != 0 ) { echo "<tr><td colspan=\"4\" ><a href=\"./error_rigmoc.php\" class=\"FacetDataTDred\">".$script_transl['errors'][3]."! -> ".$admin_aziend['symbol']." $ctrl_bal </a></TD></TR>"; } echo "<tr><TD><hr></TD><TD class=\"FacetFieldCaptionTD\" align=\"center\">".$script_transl['view'].$script_transl['closing'].$script_transl['of'].date("d-m-Y",$uts_date_closing)."</TD><td colspan=\"2\"><hr></TD></TR>"; echo "<tr><td>".$script_transl['code']."</td><td>".$script_transl['descr']."</td><td align=\"right\">".$script_transl['entry']."</td><td align=\"right\">".$script_transl['exit']."</td><tr>"; echo "<tr><td class=\"FacetSelect\" align=\"center\" colspan=\"4\">".$script_transl['economic']."</TD></TR>"; echo "<tr><td class=\"FacetSelect\">".$script_transl['costs']."</TD><td colspan=\"3\"></td></TR>"; foreach ($accounts['cos'] as $k => $v){ echo "<tr><td>".$k."</td><td>".$v['name']."</td><td></td><td align=\"right\">".gaz_format_number($v['val'])."</td><tr>"; } if ($income < 0 ) { //profitto $pro = $anagrafica->getPartner($form['operating_profit']); if (isset($accounts['pas'][$form['operating_profit']]['val'])) { $accounts['pas'][$form['operating_profit']]['val']+=$income;
if ((isset($_GET['Update']) and !isset($_GET['id_contract']))) { header("Location: ".$form['ritorno']); exit; } if ((isset($_POST['Update'])) or (isset($_GET['Update']))) { $toDo = 'update'; } else { $toDo = 'insert'; } if ((isset($_POST['Insert'])) or (isset($_POST['Update']))) { //se non e' il primo accesso //qui si deve fare un parsing di quanto arriva dal browser... $form['id_contract'] = intval($_POST['id_contract']); $cliente = $anagrafica->getPartner(intval($_POST['id_customer'])); $form['hidden_req'] = $_POST['hidden_req']; foreach($_POST['search'] as $k=>$v){ $form['search'][$k]=$v; } $form['doc_type'] = strtoupper(substr($_POST['doc_type'],0,3)); $form['id_customer'] = substr($_POST['id_customer'],0,13); $form['vat_section'] = intval($_POST['vat_section']); $form['doc_number'] = intval($_POST['doc_number']); $form['conclusion_date_Y'] = intval($_POST['conclusion_date_Y']); $form['conclusion_date_M'] = intval($_POST['conclusion_date_M']); $form['conclusion_date_D'] = intval($_POST['conclusion_date_D']); $form['start_date_Y'] = intval($_POST['start_date_Y']); $form['start_date_M'] = intval($_POST['start_date_M']); $form['start_date_D'] = intval($_POST['start_date_D']); $form['months_duration'] = intval($_POST['months_duration']);
$form['insert_imponi'] = $_POST['insert_imponi']; } //ricarico i registri per il form dei righi contabili già immessi $loadCosRic = 0; for( $i = 0; $i < $_POST['rigcon']; $i++ ) { $form['id_rig_rc'][$i] = $_POST['id_rig_rc'][$i]; $form['mastro_rc'][$i] = $_POST['mastro_rc'][$i]; $form['conto_rc'.$i] = $_POST['conto_rc'.$i]; $form['darave_rc'][$i] = $_POST['darave_rc'][$i]; $form['importorc'][$i] = $_POST['importorc'][$i]; $form['paymov_op_cl'][$i] = 0; if ($_POST['mastro_rc'][$i] == $mastroclienti || $_POST['mastro_rc'][$i] == $mastrofornitori) { if ($_POST['conto_rc'.$i] > 0) { //se viene inserito un nuovo partner do l'ok alla ricarica della contropartita costi/ricavi in base al conto presente sull'archivio clfoco if ($_POST['cod_partner'] == 0 and $form['conto_rc'.$i] > 0) { $partner = $anagrafica->getPartner($form['conto_rc'.$i]); $loadCosRic = substr($form['conto_rc'.$i],0,1); } $form['cod_partner'] = $_POST['conto_rc'.$i]; } if (($form['mastro_rc'][$i] == $mastroclienti && $form['darave_rc'][$i] == 'D') ||($form['mastro_rc'][$i] == $mastrofornitori && $form['darave_rc'][$i] == 'A') ){ // è un rigo di documento o addebito (apertura partita) $form['paymov_op_cl'][$i] = 1; } else { // è un rigo di pagamento o storno (chiusura partita) $form['paymov_op_cl'][$i] = 2; } if (isset($_POST['paymov'][$i])) { // se ho dati sul form delle partite aperte dei clienti/fornitori li ricarico $paymov_tot[$i]=0.00; foreach($_POST['paymov'][$i] as $k=>$v) { $form['paymov'][$i][$k] = $v; // qui devo ancora fare il parsing $paymov_tot[$i] +=$v['amount'];
$form['hidden_req'] = $_POST['hidden_req']; foreach($_POST['search'] as $k=>$v){ $form['search'][$k]=$v; if (substr($k,0,6)=='clfoco') { $form[$k]=$_POST[$k]; } } // Se viene inviata la richiesta di importare un ordine if (isset($_POST['import'])) { // faccio il controllo se e' stato selezionato il relativo cliente $n=key($_POST['import']); if ($form['clfoco'.$n]<100000000){ // se non e' stato selezionato il cliente restituisco l'errore $msg .="0+"; } else { $anagrafica = new Anagrafica(); $cli=$anagrafica->getPartner(intval($form['clfoco'.$n])); } if (empty($msg)) { // non ci sono errori formali: importo l'ordine web $form['tipdoc']='VOW'; $form['seziva']=1; $form['numdoc']=$n; $form['clfoco']=$form['clfoco'.$n]; $form['pagame']=$cli['codpag']; $form['banapp']=$cli['banapp']; $form['listin']=$cli['listin']; $form['status'] = 'GENERATO'; $form['initra'] = substr($n,0,4)."-".substr($n,4,2)."-".substr($n,6,2)." ".substr($n,8,2).":".substr($n,10,2).":".substr($n,12,2); $form['datemi'] = substr($n,0,4)."-".substr($n,4,2)."-".substr($n,6,2); $text=filter_var($_POST['order'][$n]['text'],FILTER_SANITIZE_STRING); tesbroInsert($form); //recupero l'id assegnato dall'inserimento
$pdf->AddPage(); $pdf->setFooterMargin(21); $pdf->setTopMargin(44); $pdf->SetFont('helvetica','',7); $ctrlmopre = 0; $numrig=1; $anagrafica = new Anagrafica(); while ($mov = gaz_dbi_fetch_array($result)) { $giomov = substr($mov['datreg'],8,2); $mesmov = substr($mov['datreg'],5,2); $annmov = substr($mov['datreg'],0,4); $giodoc = substr($mov['datdoc'],8,2); $mesdoc = substr($mov['datdoc'],5,2); $anndoc = substr($mov['datdoc'],0,4); $clfoco = $anagrafica->getPartner($mov["codcon"]); $utsmov= mktime(0,0,0,$mesmov,$giomov,$annmov); $datamov = date("d-m-Y",$utsmov); $datadoc = $giodoc.'-'.$mesdoc.'-'.$anndoc; if($mov["darave"] == 'D') { $dare = gaz_format_number($mov["import"]); $tot_dare += $mov["import"]; $avere = ""; } else { $avere = gaz_format_number($mov["import"]); $tot_avere += $mov["import"]; $dare = ""; } if ($mov["id_tes"] != $ctrlmopre) {
<input type="submit" name="Return" value="Indietro"> <input type="submit" name="anteprima" value="VISUALIZZA L'ANTEPRIMA !"> </td> </tr> </table> <?php //mostro l'anteprima if (isset($_POST['anteprima']) and $message == "") { //recupero i documenti da contabilizzare $result = gaz_dbi_dyn_query("*", $gTables['effett'], "datemi like '".intval($_POST['annexe'])."%' and id_con = 0 and banacc > 0 and progre between ".$_POST['proini'].' and '.$_POST['profin'].' '.$querytip,'tipeff asc, scaden asc'); echo "<div><center><b>ANTEPRIMA CONTABILIZZAZIONE </b></div>"; echo "<table class=\"Tlarge\">"; echo "<th class=\"FacetFieldCaptionTD\">Scadenza</th><th class=\"FacetFieldCaptionTD\">Emissione</th><th class=\"FacetFieldCaptionTD\">Tipo</th><th class=\"FacetFieldCaptionTD\">Progr.</th><th class=\"FacetFieldCaptionTD\">Cliente</th><th class=\"FacetFieldCaptionTD\">Importo</th><th class=\"FacetFieldCaptionTD\">Saldo<br />Conto</th><th class=\"FacetFieldCaptionTD\">N.Fatt.</th><th class=\"FacetFieldCaptionTD\">Data Fattura</th>"; $anagrafica = new Anagrafica(); while ($effett = gaz_dbi_fetch_array($result)) { $client = $anagrafica->getPartner($effett['clfoco']); $pagame = gaz_dbi_get_row($gTables['pagame'],"codice",$effett['pagame']); $giorno = substr($effett['datfat'],8,2); $mese = substr($effett['datfat'],5,2); $anno = substr($effett['datfat'],0,4); //stampo i totali echo '<tr><td>'.$effett['scaden'].'</td><td>'.$effett['datemi'].'</td><td>'.$effett['tipeff'].'</td><td>'.$effett['progre'].'</td><td>'.$client['ragso1'].'</td><td align=\'right\'>'.$effett['impeff'].'</td><td align=\'right\'>'.$effett['salacc'].'</td><td align=\'right\'>'.$effett['numfat'].'/'.$effett['seziva'].'</td><td align=\'right\'>'.$effett['datfat'].'</td></tr>'; } echo "<tr><td colspan=\"9\" align=\"right\"><input type=\"submit\" name=\"genera\" value=\"CONFERMA LA CONTABILIZZAZIONE DEGLI EFFETTI SOPRAELENCATI !\"></TD></TR>"; echo '</table>'; } ?> </form> </body> </html>
require("../../library/include/datlib.inc.php"); $admin_aziend=checkAdmin(); if (!isset($_GET['ristam']) or !isset($_GET['banacc']) or !isset($_GET['scaini']) or !isset($_GET['scafin']) or !isset($_GET['proini']) or !isset($_GET['profin'])) { header("Location: report_effett.php"); exit; } if ($_GET['ristam'] <> 'S') { $ristampa = $gTables['effett'].".status <> 'DISTINTATO' AND "; } else { $ristampa = "(banacc = '".$_GET['banacc']."' OR banacc = 0) AND "; } require("../../library/include/riba_cbi.inc.php"); $anagrafica = new Anagrafica(); $contoAccredito = $anagrafica->getPartner(intval($_GET['banacc'])); $countryData = gaz_dbi_get_row($gTables['country'],"iso",$contoAccredito['country']); $bancaAccredito = gaz_dbi_get_row($gTables['banapp'],"codice",$contoAccredito['banapp']); if (isset($_GET['datemi'])){ $dataemissione = substr($_GET['datemi'],8,2).substr($_GET['datemi'],5,2).substr($_GET['datemi'],2,2); } else { $dataemissione = date("dmy"); } // creo il file di back up con il nome ottenuto in precedenza. $filename = "RIBAdel$dataemissione.cbi"; $where = $ristampa." tipeff = 'B' AND scaden BETWEEN '".$_GET['scaini']."' AND '".$_GET['scafin']."' AND progre BETWEEN '".$_GET['proini']."' AND '".$_GET['profin']."' "; //recupero le testate in base alle scelte impostate $result = gaz_dbi_dyn_query("*",$gTables['effett']." LEFT JOIN ".$gTables['clfoco']." ON ".$gTables['effett'].".clfoco = ".$gTables['clfoco'].".codice LEFT JOIN ".$gTables['anagra']." ON ".$gTables['anagra'].".id = ".$gTables['clfoco'].".id_anagra LEFT JOIN ".$gTables['banapp']." ON ".$gTables['effett'].".banapp = ".$gTables['banapp'].".codice", $where, "tipeff ASC,scaden ASC, id_tes ASC"); //C.F. o P.I. creditore if (empty ($admin_aziend['pariva'])){ $codfis = $admin_aziend['codfis'];
$_SESSION['print_request'] = gaz_dbi_last_id(); header("Location: invsta_letter.php"); exit; } } } } elseif ((!isset($_POST['Update'])) and (isset($_GET['Update']))) { //se e' il primo accesso per UPDATE $form['ritorno'] = $_SERVER['HTTP_REFERER']; $form['hidden_req']=''; $lettera = gaz_dbi_get_row($gTables['letter'],'id_let',intval($_GET['id_let'])); if ($lettera['adminid'] != $_SESSION['Login']) { //non è l'utente che ha scritto la lettera header("Location: report_letter.php"); exit; } $anagrafica = new Anagrafica(); $partner = $anagrafica->getPartner($lettera['clfoco']); $form['search']['clfoco']=substr($partner['ragso1'],0,10); $form['id_let'] = $lettera['id_let']; $form['gioemi'] = substr($lettera['write_date'],8,2); $form['mesemi'] = substr($lettera['write_date'],5,2); $form['annemi'] = substr($lettera['write_date'],0,4); $form['numero'] = $lettera['numero']; $form['tipo'] = $lettera['tipo']; $form['clfoco'] = $lettera['clfoco']; $form['oggetto'] = $lettera['oggetto']; $form['c_a'] = $lettera['c_a']; $form['corpo'] = $lettera['corpo']; if ($lettera['signature'] == 1) { $form['signature'] = 'checked'; } else { $form['signature'] = '';
echo "<table class=\"Tmiddle\">\n"; if (!empty($msg)) { echo '<tr><td class="FacetDataTDred">'.$gForm->outputErrors($msg,$script_transl['errors'])."</td></tr>\n"; } echo "<tr>\n"; echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_emi']."</td><td class=\"FacetDataTD\">\n"; $gForm->CalendarPopup('date_emi',$form['date_emi_D'],$form['date_emi_M'],$form['date_emi_Y'],'FacetSelect',1); echo "</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['bank']."</td><td class=\"FacetDataTD\">\n"; $select_bank = new selectconven("bank"); $select_bank -> addSelected($form['bank']); $select_bank -> output($admin_aziend['masban']); if ($form['bank']>0){ $bank_data = $anagrafica->getPartner($form['bank']); if ($bank_data['addbol']=='N'){ $form['eof']= ''; } else { $form['eof']= 'eof'; } } echo " ".$script_transl['eof']; $gForm->selCheckbox('eof',$form['eof'],$script_transl['eof_title']); echo "</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['reprint']."</td><td class=\"FacetDataTD\">\n"; $gForm->variousSelect('reprint',$script_transl['reprint_value'],$form['reprint'],'FacetSelect',0,'reprint'); echo "\t </td>\n"; echo "</tr>\n";
require('../../config/templates/report_template.php'); 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();
header("Location: ".$_POST['ritorno']); exit; } if ((isset($_POST['Insert'])) or (isset($_POST['Update']))) { //se non e' il primo accesso $parse_clfoco=gaz_dbi_parse_post('clfoco'); $form = $parse_clfoco+gaz_dbi_parse_post('anagra'); // Se viene inviata la richiesta di conferma totale ... if (isset($_POST['ins'])) { //validazione IBAN $iban= new IBAN; $msg .= ((empty($form['iban']) || !$iban->checkIBAN($form['iban'])) ? "16+" : '' ); $msg .= ((substr($form['iban'],0,2) != $form['country']) ? "20+" : '' ); //fine validazione IBAN if ($toDo == 'insert') { // e' un inserimento, controllo se il codice esiste $rs_ctrl = $anagrafica->getPartner($admin_aziend['masban']*1000000+$form['codice']); if ($rs_ctrl){ $msg .= "17+"; } } if ($form['codice'] <= 0){ //codice sbagliato <1 $msg .= "18+"; } if (empty($form['ragso1']) && $form['banapp'] <= 0){ //descrizione vuota e senza banca appoggio $msg .= "19+"; } if ($msg == "") {// nessun errore //formatto i campi per l'iserimento $form['codice']=$admin_aziend['masban']*1000000+$form['codice']; if (empty($form['ragso1'])){ //prendo la descrizione della banca appoggio $banapp = gaz_dbi_get_row($gTables['banapp'],'codice',$form['banapp']);
header("Location: report_contract.php"); exit; } else { $id= intval($_GET['id_contract']); } require('../../library/tcpdf/tcpdf.php'); require("./lang.".$admin_aziend['lang'].".php"); require("../../language/".$admin_aziend['lang']."/menu.inc.php"); $script_transl=$strCommon+$strScript['admin_contract.php']; $anagrafica = new Anagrafica(); // recupero i dati relativi al contratto $contract = gaz_dbi_get_row($gTables['contract'],'id_contract' ,$id); $body = gaz_dbi_get_row($gTables['body_text'],'id_body' ,$contract['id_body_text']); $rs_rows = gaz_dbi_dyn_query("*", $gTables['contract_row'], "id_contract = $id","id_row ASC"); $customer= $anagrafica->getPartner($contract['id_customer']); $payment= gaz_dbi_get_row($gTables['pagame'],'codice' ,$contract['payment_method']); $bank= gaz_dbi_get_row($gTables['banapp'],'codice' ,$contract['bank']); $revenue= gaz_dbi_get_row($gTables['clfoco'],'codice' ,$contract['cod_revenue']); $vat= gaz_dbi_get_row($gTables['aliiva'],'codice' ,$contract['vat_code']); if ($contract['tacit_renewal']==0) { $tacit_reneval = $script_transl['no']; } else { $tacit_reneval = $script_transl['yes']; } if ($contract['periodic_reassessment']==0) { $periodic_reassessment = $script_transl['no']; } else { $periodic_reassessment = $script_transl['yes']; }
require('../../library/tcpdf/tcpdf.php'); $logo=$admin_aziend['image']; $testat = $_GET['id_tes']; $tesbro = gaz_dbi_get_row($gTables['tesbro'],"id_tes",$testat); //se non e' il tipo di documento stampabile da questo modulo ... va a casa if ($tesbro['tipdoc'] <> 'VPA') { header("Location: report_salcon.php"); exit; } if ($tesbro['status'] == 'GENERATO' or $tesbro['status'] == 'MODIFICATO') gaz_dbi_put_row($gTables['tesbro'],"id_tes",$tesbro['id_tes'],"status",'STAMPATO'); $anagrafica = new Anagrafica(); $client = $anagrafica->getPartner($tesbro['clfoco']); $pagame = gaz_dbi_get_row($gTables['pagame'],"codice",$tesbro['pagame']); $vettor = gaz_dbi_get_row($gTables['vettor'],"codice",$tesbro['vettor']); $nomemese=ucwords(strftime("%B", mktime (0,0,0,substr($tesbro['datemi'],5,2),1,0))); $day = substr($tesbro['datemi'],8,2); $month = substr($tesbro['datemi'],5,2); $year = substr($tesbro['datemi'],0,4); $emissione =$tesbro['numdoc'].' del '.substr($tesbro['datemi'],8,2).'/'.substr($tesbro['datemi'],5,2).'/'.substr($tesbro['datemi'],0,4); $cliente1=$client['ragso1']; $cliente2=$client['ragso2']; $cliente3=$client['indspe']; $cliente4=$client['capspe'].' '.$client['citspe'].' ('.$client['prospe'].')'; $intesta1=$admin_aziend['ragso1'].' '.$admin_aziend['ragso2']; $intesta2=$admin_aziend['indspe'].' '.$admin_aziend['capspe'].' '.$admin_aziend['citspe'].' ('.$admin_aziend['prospe'].')'; $intesta3='Tel.'.$admin_aziend['telefo'].' C.F. '.$admin_aziend['codfis'].' P.I. '.$admin_aziend['pariva']; $intesta4=$admin_aziend['e_mail'];
} } elseif ($toDo == 'update') { $anagrafica->updatePartners($form['codice'],$form); } header("Location: ".$form['ritorno']); exit; } } elseif (isset($_POST['Return'])) { // torno indietro header("Location: ".$form['ritorno']); exit; } } elseif (!isset($_POST['Update']) && isset($_GET['Update'])) { //se e' il primo accesso per UPDATE $anagrafica = new Anagrafica(); $form = $anagrafica->getPartner(intval($admin_aziend['mascli']*1000000+$_GET['codice'])); $form['codice'] = intval(substr($form['codice'],3)); $toDo = 'update'; $form['search']['id_des']=''; $form['ritorno']=$_SERVER['HTTP_REFERER']; $form['hidden_req'] = ''; $form['datnas_Y'] = substr($form['datnas'],0,4); $form['datnas_M'] = substr($form['datnas'],5,2); $form['datnas_D'] = substr($form['datnas'],8,2); } elseif (!isset($_POST['Insert'])) { //se e' il primo accesso per INSERT $anagrafica = new Anagrafica(); $last=$anagrafica->queryPartners('*',"codice BETWEEN ".$admin_aziend['mascli']."000000 AND ".$admin_aziend['mascli']."999999" ,"codice DESC",0,1); $form=array_merge(gaz_dbi_fields('clfoco'),gaz_dbi_fields('anagra')); $form['codice']=substr($last[0]['codice'],3) + 1; $toDo = 'insert'; $form['search']['id_des']='';
$_POST['annemi'] = substr($testata['datemi'],0,4); $_POST['spediz'] = $conto['iban']; $utsemi= mktime(0,0,0,$_POST['mesemi'],$_POST['gioemi'],$_POST['annemi']); $utsval= mktime(0,0,0,$_POST['mesval'],$_POST['gioval'],$_POST['annval']); $_POST['numfat'] = $testata['numfat']; //impropriamente usato per il numero di conto d'addebito while ($rigo = gaz_dbi_fetch_array($rs_rig)) { $_POST['righi'][$_POST['num_rigo']]['prelis'] = $rigo['prelis']; $_POST['righi'][$_POST['num_rigo']]['descri'] = $rigo['descri']; $_POST['righi'][$_POST['num_rigo']]['id_rig'] = $rigo['id_rig']; $_POST['num_rigo']++; } } elseif (!isset($_POST['Insert'])) { //se e' il primo accesso per INSERT $anagrafica = new Anagrafica(); $conto = $anagrafica->getPartner($_GET['codice']); $_POST['num_rigo'] = 0; $_POST['gioemi'] = $day; $_POST['mesemi'] = $month; $_POST['annemi'] = $year; $utsnew= mktime(0,0,0,$month,$day+5,$year); $_POST['gioval'] = strftime ("%d",$utsnew); $_POST['mesval'] = strftime ("%m",$utsnew); $_POST['annval'] = strftime ("%Y",$utsnew); $_POST['spediz'] = $conto['iban']; $_POST['righi'] = array(); $_POST['numfat'] = ""; //impropriamente usato per il numero di conto d'addebito $_POST['id_con'] = ""; //recupero tutti i movimenti contabili del conto insieme alle relative testate per creare l'array dei debiti $utsemi= mktime(0,0,0,$_POST['mesemi'],$_POST['gioemi'],$_POST['annemi']); $utsval= mktime(0,0,0,$_POST['mesval'],$_POST['gioval'],$_POST['annval']);
if (isset($form["row_$k"])) { //se ho un rigo testo if ($k > $delri) { //se ho un rigo testo dopo $new_k=$k-1; $form["row_$new_k"] = $form["row_$k"]; unset($form["row_$k"]); } } } array_splice($form['rows'],$delri,1); $i--; } } elseif ((!isset($_POST['Update'])) and (isset($_GET['Update']))) { //se e' il primo accesso per UPDATE $tesdoc = gaz_dbi_get_row($gTables['tesdoc'],"id_tes",intval($_GET['id_tes'])); $anagrafica = new Anagrafica(); $fornitore = $anagrafica->getPartner($tesdoc['clfoco']); $id_des = $anagrafica->getPartner($tesdoc['id_des']); $rs_rig = gaz_dbi_dyn_query("*", $gTables['rigdoc'], "id_tes = ".$tesdoc['id_tes'],"id_rig asc"); $form['id_tes'] = $tesdoc['id_tes']; $form['hidden_req'] = ''; // inizio rigo di input $form['in_descri'] = ""; $form['in_tiprig'] = 0; $form['in_artsea'] = $admin_aziend['artsea']; $form['in_codart'] = ""; $form['in_pervat'] = 0; $form['in_unimis'] = ""; $form['in_prelis'] = 0.000; $form['in_sconto'] = 0; $form['in_quanti'] = 0; $form['in_codvat'] = $admin_aziend['preeminent_vat'];
foreach ($form['rows'] as $k => $val) { if (isset($form["row_$k"])) { //se ho un rigo testo if ($k > $delri) { //se ho un rigo testo dopo $new_k=$k-1; $form["row_$new_k"] = $form["row_$k"]; unset($form["row_$k"]); } } } array_splice($form['rows'],$delri,1); $next_row--; } } elseif ((!isset($_POST['Update'])) and (isset($_GET['Update']))) { //se e' il primo accesso per UPDATE $tesbro = gaz_dbi_get_row($gTables['tesbro'],"id_tes",$_GET['id_tes']); $anagrafica = new Anagrafica(); $cliente = $anagrafica->getPartner($tesbro['clfoco']); $rs_rig = gaz_dbi_dyn_query("*",$gTables['rigbro'],"id_tes = ".intval($_GET['id_tes']),"id_rig asc"); $form['id_tes'] = $_GET['id_tes']; $form['hidden_req'] = ''; // inizio rigo di input $form['in_descri'] = ""; $form['in_tiprig'] = 0; $form['in_id_doc'] = 0; $form['in_artsea'] = $admin_aziend['artsea']; $form['in_codart'] = ""; $form['in_pervat'] = 0; $form['in_tipiva'] = 0; $form['in_ritenuta'] = $admin_aziend['ritenuta']; $form['in_unimis'] = ""; $form['in_prelis'] = 0; $form['in_sconto'] = 0;
$causal = gaz_dbi_get_row($gTables['caumag'], 'codice', $form['caumag']); } if (isset($_POST['Return'])){ header("Location: report_movmag.php"); exit; } require("../../library/include/header.php"); $script_transl=HeadMain(0,0,'admin_movmag'); print "<form method=\"POST\">\n"; echo "<input type=\"hidden\" value=\"".$form['id_mov']."\" name=\"id_mov\">\n"; print "<div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['del_this']."</div>\n"; print "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" class=\"FacetFormTABLE\" align=\"center\">\n"; $anagrafica = new Anagrafica(); $a_part = $anagrafica->getPartner($form['clfoco']); $partner = $a_part['ragso1']." ".$a_part['ragso2']; print "<tr><td class=\"FacetFieldCaptionTD\">n. ID </td><td class=\"FacetDataTD\">".$form["id_mov"]."</td></tr>"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[1]."</td><td class=\"FacetDataTD\">".$form["datreg"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[2]."</td><td class=\"FacetDataTD\">".$causal["descri"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl["operat"]."</td><td class=\"FacetDataTD\">".$script_transl["operat_value"][$form["operat"]]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl["partner"]."</td><td class=\"FacetDataTD\">".$partner."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[8]."</td><td class=\"FacetDataTD\">".$form["datdoc"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[7]."</td><td class=\"FacetDataTD\">".$form["artico"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[12]."</td><td class=\"FacetDataTD\">".$form["quanti"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[13]."</td><td class=\"FacetDataTD\">".$form["prezzo"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[14]."</td><td class=\"FacetDataTD\">".$form["scorig"]."</td></tr>\n"; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[10]."</td><td class=\"FacetDataTD\">".$form["scochi"]."</td></tr>\n"; $valore = CalcolaImportoRigo($form['quanti'], $form['prezzo'], $form['scorig']) ; $valore = CalcolaImportoRigo(1, $valore, $form['scochi']) ; print "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl["amount"]."</td><td class=\"FacetDataTD\">".gaz_format_number($valore)."</td></tr>\n";
function selectDocPartner($name, $val, $strSearch = '', $val_hiddenReq = '', $mesg, $m = 0, $anonimo = -1, $tab = 1) { /* se passo $m=-1 ottengo tutti i partner nel piano dei conti indistintamente passare false su $tab se non si vuole la tabulazione */ global $gTables; $tab1 = ''; $tab2 = ''; $tab3 = ''; if ($tab) { $tab1 = ' tabindex="' . $tab . '"'; $tab2 = ' tabindex="' . ($tab + 1) . '"'; $tab3 = ' tabindex="' . ($tab + 2) . '"'; } if ($val > 100000000) { //vengo da una modifica della precedente select case quindi non serve la ricerca $partner = gaz_dbi_get_row($gTables['clfoco'] . ' LEFT JOIN ' . $gTables['anagra'] . ' ON ' . $gTables['clfoco'] . '.id_anagra = ' . $gTables['anagra'] . '.id', "codice", $val); echo "\t<input type=\"submit\" value=\"⇒\" name=\"fantoccio\" disabled>\n"; echo "\t<input type=\"hidden\" name=\"{$name}\" value=\"{$val}\">\n"; echo "\t<input type=\"hidden\" name=\"search[{$name}]\" value=\"" . substr($partner['ragso1'], 0, 8) . "\">\n"; echo "\t<input type=\"submit\" tabindex=\"999\" value=\"" . $partner['ragso1'] . "\" name=\"change\" onclick=\"this.form.{$name}.value='0'; this.form.hidden_req.value='change';\" title=\"{$mesg['2']}\">\n"; } elseif (preg_match("/^id_([0-9]+)\$/", $val, $match)) { // e' stato selezionata la sola anagrafica $partner = gaz_dbi_get_row($gTables['anagra'], 'id', $match[1]); echo "\t<input type=\"submit\" value=\"⇒\" name=\"fantoccio\" disabled>\n"; echo "\t<input type=\"hidden\" name=\"{$name}\" value=\"{$val}\">\n"; echo "\t<input type=\"hidden\" name=\"search[{$name}]\" value=\"" . substr($partner['ragso1'], 0, 8) . "\">\n"; echo "\t<input type=\"submit\" tabindex=\"999\" style=\"background:#FFBBBB\"; value=\"" . $partner['ragso1'] . "\" name=\"change\" onclick=\"this.form.{$name}.value='0'; this.form.hidden_req.value='change';\" title=\"{$mesg['2']}\">\n"; } elseif ($val == $anonimo) { // e' un cliente anonimo echo "\t<input type=\"submit\" value=\"⇒\" name=\"fantoccio\" disabled>\n"; echo "\t<input type=\"hidden\" name=\"{$name}\" value=\"{$val}\">\n"; echo "\t<input type=\"hidden\" name=\"search[{$name}]\" value=\"\">\n"; echo "\t<input type=\"submit\" tabindex=\"999\" value=\"" . $mesg[5] . "\" name=\"change\" onclick=\"this.form.{$name}.value='0'; this.form.hidden_req.value='change';\" title=\"{$mesg['2']}\">\n"; } else { if (strlen($strSearch) >= 2) { //sto ricercando un nuovo partner if ($m > 100) { //ho da ricercare nell'ambito di un mastro $this->setWhat($m); } if (is_numeric($strSearch)) { //ricerca per partita iva $partner = $this->queryAnagra(" pariva = " . intval($strSearch)); } elseif (substr($strSearch, 0, 1) == '@') { //ricerca conoscendo il codice cliente $temp_agrafica = new Anagrafica(); $codicetemp = intval($m * 1000000 + substr($strSearch, 1)); $last = $temp_agrafica->getPartner($codicetemp); $codicecer = $last['id_anagra']; $partner = $this->queryAnagra(" a.id = " . intval($codicecer)); //echo "---".$m."-".$codicetemp."-".$codicecer; //debug } elseif (substr($strSearch, 0, 1) == '#') { //ricerca conoscendo il codice cliente $partner = $this->queryAnagra(" a.fe_cod_univoco LIKE '%" . addslashes(substr($strSearch, 1)) . "%'"); } elseif (is_numeric(substr($strSearch, 6, 2))) { //ricerca per codice fiscale $partner = $this->queryAnagra(" a.codfis LIKE '%" . addslashes($strSearch) . "%'"); } else { //ricerca per ragione sociale $partner = $this->queryAnagra(" a.ragso1 LIKE '" . addslashes($strSearch) . "%'"); } if (count($partner) > 0) { echo "\t<select name=\"{$name}\" {$tab1} class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='{$name}'; this.form.submit();\">\n"; echo "<option value=\"0\"> ---------- </option>"; if ($anonimo > 100) { echo "<option value=\"{$anonimo}\">" . $mesg[5] . "</option>"; } preg_match("/^id_([0-9]+)\$/", $val, $match); foreach ($partner as $r) { if ($r['codpart'] > 0) { $r['codice'] = $r['codpart']; } $style = ''; $selected = ''; $disabled = ''; if ($r['status'] == 'HIDDEN') { $disabled = ' disabled '; } if (isset($match[1]) && $match[1] == $r['id']) { $selected = "selected"; } elseif ($r['codice'] == $val && $val > 0) { $selected = "selected"; } if ($m < 0) { // vado cercando tutti i partner del piano dei conti if ($r["codice"] < 1) { // disabilito le anagrafiche presenti solo in altre aziende $disabled = ' disabled '; $style = 'style="background:#FF6666";'; } } elseif ($r["codice"] < 1) { $style = 'style="background:#FF6666";'; $r['codice'] = 'id_' . $r['id']; } elseif (substr($r["codice"], 0, 3) != $m) { $style = 'style="background:#FFBBBB";'; $r['codice'] = 'id_' . $r['id']; } echo "\t\t <option {$style} value=\"" . $r['codice'] . "\" {$selected} {$disabled}>" . $r["ragsoc"] . " " . $r["citta"] . "</option>\n"; } echo "\t </select>\n"; } else { $msg = $mesg[0]; echo "\t<input type=\"hidden\" name=\"{$name}\" value=\"{$val}\">\n"; } } else { $msg = $mesg[1]; echo "\t<input type=\"hidden\" name=\"{$name}\" value=\"{$val}\">\n"; } echo "\t<input type=\"text\" {$tab2} id=\"search_{$name}\" name=\"search[{$name}]\" value=\"" . $strSearch . "\" maxlength=\"15\" size=\"9\" class=\"FacetInput\">\n"; if (isset($msg)) { echo "<input type=\"text\" style=\"color: red; font-weight: bold;\" size=\"" . strlen($msg) . "\" disabled value=\"{$msg}\">\n"; } echo "\t<input type=\"image\" {$tab3} align=\"middle\" name=\"search_str\" src=\"../../library/images/cerbut.gif\">\n"; } }
"ID" => "id_tes", "Numero" => "numfat", "Data" => "datemi", "Fornitore (cod.)" => "clfoco", "Status" => "", "Stampa" => "", "Cancella" => "" ); $linkHeaders = new linkHeaders($headers_tesdoc); $linkHeaders -> output(); ?> </tr> <?php $result = gaz_dbi_dyn_query ('*', $gTables['tesdoc'], $where, $orderby, $limit, $passo); $anagrafica = new Anagrafica(); while ($a_row = gaz_dbi_fetch_array($result)) { $cliente = $anagrafica->getPartner($a_row['clfoco']); echo "<tr>"; echo "<td class=\"FacetDataTD\"><a href=\"admin_docacq.php?id_tes=".$a_row["id_tes"]."&Update\">".$a_row["id_tes"]."</a>  </td>"; echo "<td class=\"FacetDataTD\">".$a_row["numfat"]." </td>"; echo "<td class=\"FacetDataTD\">".$a_row["datemi"]." </td>"; echo "<td class=\"FacetDataTD\">".$cliente["ragso1"]." </td>"; echo "<td class=\"FacetDataTD\">".$a_row["status"]." </td>"; echo "<td class=\"FacetDataTD\"><a href=\"stampa_docacq.php?id_tes=".$a_row["id_tes"]."\"><center><img src=\"../../library/images/stampa.gif\" alt=\"Stampa\" border=\"0\"></a></td>"; echo "<td class=\"FacetDataTD\"><a href=\"delete_docacq.php?id_tes=".$a_row["id_tes"]."\"><center><img src=\"../../library/images/x.gif\" alt=\"Cancella\" border=\"0\"></a></td>"; echo "</tr>"; } ?> </table> </body> </html>
function setXMLvars($gTables, $tesdoc, $testat, $tableName, $ecr = false) { $this->gTables = $gTables; $admin_aziend = gaz_dbi_get_row($gTables['aziend'], 'codice', $_SESSION['enterprise_id']); $this->azienda = $admin_aziend; $this->pagame = gaz_dbi_get_row($gTables['pagame'], "codice", $tesdoc['pagame']); $this->banapp = gaz_dbi_get_row($gTables['banapp'], "codice", $tesdoc['banapp']); $anagrafica = new Anagrafica(); $this->banacc = $anagrafica->getPartner($this->pagame['id_bank']); $this->vettor = gaz_dbi_get_row($gTables['vettor'], "codice", $tesdoc['vettor']); $this->tableName = $tableName; $this->intesta1 = $admin_aziend['ragso1']; $this->intesta1bis = $admin_aziend['ragso2']; $this->intesta2 = $admin_aziend['indspe'] . ' ' . sprintf("%05d", $admin_aziend['capspe']) . ' ' . $admin_aziend['citspe'] . ' (' . $admin_aziend['prospe'] . ')'; $this->intesta3 = 'Tel.' . $admin_aziend['telefo'] . ' '; $this->aziendTel = $admin_aziend['telefo']; $this->aziendFax = $admin_aziend['fax']; $this->codici = ''; if ($admin_aziend['codfis'] != '') { $this->codici .= 'C.F. ' . $admin_aziend['codfis'] . ' '; } if ($admin_aziend['pariva']) { $this->codici .= 'P.I. ' . $admin_aziend['pariva'] . ' '; } if ($admin_aziend['rea']) { $this->codici .= 'R.E.A. ' . $admin_aziend['rea']; } if ($tesdoc['template'] == 'FatturaImmediata') { $this->sempl_accom = true; } else { $this->sempl_accom = false; } $this->intesta4 = $admin_aziend['e_mail']; $this->intesta5 = $admin_aziend['sexper']; if ($admin_aziend['sexper'] == 'G') { $this->TipoRitenuta = 'RT02'; } else { $this->TipoRitenuta = 'RT01'; } $this->colore = $admin_aziend['colore']; $this->decimal_quantity = $admin_aziend['decimal_quantity']; $this->decimal_price = $admin_aziend['decimal_price']; $this->logo = $admin_aziend['image']; $this->link = $admin_aziend['web_url']; $this->perbollo = 0; $this->iva_bollo = gaz_dbi_get_row($gTables['aliiva'], "codice", $admin_aziend['taxstamp_vat']); $this->client = $anagrafica->getPartner($tesdoc['clfoco']); $this->cliente1 = $this->client['ragso1']; $this->cliente2 = $this->client['ragso2']; $this->cliente3 = $this->client['indspe']; if (!empty($this->client['citspe'])) { $this->cliente4 = sprintf("%05d", $this->client['capspe']) . ' ' . strtoupper($this->client['citspe']) . ' ' . strtoupper($this->client['prospe']); } else { $this->cliente4 = ''; } $country = gaz_dbi_get_row($gTables['country'], "iso", $this->client['country']); if ($this->client['country'] != 'IT') { $this->cliente4b = strtoupper($country['istat_name']); } else { $this->cliente4b = ''; } if (!empty($this->client['pariva'])) { $this->cliente5 = 'P.I. ' . $this->client['pariva'] . ' '; } else { $this->cliente5 = ''; } if (!empty($this->client['pariva'])) { //se c'e' la partita iva if (!empty($this->client['codfis']) and $this->client['codfis'] == $this->client['pariva']) { $this->cliente5 = 'C.F. e P.I. ' . $this->client['codfis']; } elseif (!empty($this->client['codfis']) and $this->client['codfis'] != $this->client['pariva']) { $this->cliente5 = 'C.F. ' . $this->client['codfis'] . ' P.I. ' . $this->client['pariva']; } else { //per es. se non c'e' il codice fiscale $this->cliente5 = ' P.I. ' . $this->client['pariva']; } } else { //se NON c'e' la partita iva $this->cliente5 = ''; if (!empty($this->client['codfis'])) { $this->cliente5 = 'C.F. ' . $this->client['codfis']; } } // variabile e' sempre un array $this->id_agente = gaz_dbi_get_row($gTables['agenti'], 'id_agente', $tesdoc['id_agente']); $this->rs_agente = $anagrafica->getPartner($this->id_agente['id_fornitore']); $this->name_agente = substr($this->rs_agente['ragso1'] . " " . $this->rs_agente['ragso2'], 0, 47); if (isset($tesdoc['id_des']) and $tesdoc['id_des'] > 0) { $this->partner_dest = $anagrafica->getPartnerData($tesdoc['id_des']); $this->destinazione = substr($this->partner_dest['ragso1'] . " " . $this->partner_dest['ragso2'], 0, 45); $this->destinazione .= "\n" . substr($this->partner_dest['indspe'], 0, 45); $this->destinazione .= "\n" . substr($this->partner_dest['capspe'] . " " . $this->partner_dest['citspe'] . " (" . $this->partner_dest['prospe'] . ")", 0, 45); } else { if (isset($tesdoc['destin']) and is_array($tesdoc['destin'])) { $this->destinazione = $tesdoc['destin']; } elseif (isset($tesdoc['destin']) and is_string($tesdoc['destin'])) { $destino = preg_split("/[\r\n]+/i", $tesdoc['destin'], 3); $this->destinazione = substr($destino[0], 0, 45); foreach ($destino as $key => $value) { if ($key == 1) { $this->destinazione .= "\n" . substr($value, 0, 45) . "\n"; } elseif ($key > 1) { $this->destinazione .= substr(preg_replace("/[\r\n]+/i", ' ', $value), 0, 45); } } } else { $this->destinazione = ''; } } $this->clientSedeLegale = trim($this->client['sedleg']) != '' ? preg_split("/\n/", trim($this->client['sedleg'])) : array(); $this->client = $anagrafica->getPartner($tesdoc['clfoco']); $this->tesdoc = $tesdoc; $this->expense_pervat = gaz_dbi_get_row($gTables['aliiva'], "codice", $this->tesdoc['expense_vat']); $this->min = substr($tesdoc['initra'], 14, 2); $this->ora = substr($tesdoc['initra'], 11, 2); $this->day = substr($tesdoc['initra'], 8, 2); $this->month = substr($tesdoc['initra'], 5, 2); $this->year = substr($tesdoc['initra'], 0, 4); $this->trasporto = $tesdoc['traspo']; $this->testat = $testat; $this->ddt_data = false; $this->TipoDocumento = 'TD01'; // <TipoDocumento> 2.1.1.1 $this->docRelNum = $this->tesdoc["numdoc"]; // Numero del documento relativo $this->docRelDate = $this->tesdoc["datemi"]; // Data del documento relativo switch ($tesdoc["tipdoc"]) { case "FAD": $this->ddt_data = true; $this->docRelNum = $this->tesdoc["numfat"]; $this->docRelDate = $this->tesdoc["datfat"]; break; case "FAI": $this->docRelNum = $this->tesdoc["numfat"]; $this->docRelDate = $this->tesdoc["datfat"]; break; case "FNC": $this->TipoDocumento = 'TD04'; // <TipoDocumento> 2.1.1.1 $this->docRelNum = $this->tesdoc["numfat"]; $this->docRelDate = $this->tesdoc["datfat"]; break; case "FND": $this->TipoDocumento = 'TD05'; // <TipoDocumento> 2.1.1.1 $this->docRelNum = $this->tesdoc["numfat"]; $this->docRelDate = $this->tesdoc["datfat"]; break; case "FAP": $this->TipoDocumento = 'TD06'; // <TipoDocumento> 2.1.1.1 $this->docRelNum = $this->tesdoc["numfat"]; $this->docRelDate = $this->tesdoc["datfat"]; break; case "DDT": case "DDL": case "DDR": default: $this->ddt_data = true; $this->docRelNum = $this->tesdoc["numdoc"]; // Numero del documento relativo $this->docRelDate = $this->tesdoc["datemi"]; // Data del documento relativo } $this->protoc = $this->tesdoc["protoc"]; $this->seziva = $this->tesdoc["seziva"]; // aggiungo l'eventuale intermediario in caso di installazione "da commercialista" $intermediary_code = gaz_dbi_get_row($gTables['config'], 'variable', 'intermediary'); if ($intermediary_code['cvalue'] > 0) { $intermediary = gaz_dbi_get_row($gTables['aziend'], 'codice', $intermediary_code['cvalue']); $this->IdCodice = $intermediary['codfis']; $this->Intermediary = $intermediary['codice']; } else { $this->IdCodice = $admin_aziend['codfis']; $this->Intermediary = false; } $this->totimp_body = 0; $this->totimp_decalc = 0; $this->totimp_doc = 0; }