$anagrafica = new Anagrafica(); while ($a_row = gaz_dbi_fetch_array($result)) { $partner = $anagrafica->getPartner($a_row["clfoco"]); $title = $partner['ragso1']." ".$partner['ragso2']; $valore = CalcolaImportoRigo($a_row['quanti'], $a_row['prezzo'], $a_row['scorig']) ; $valore = CalcolaImportoRigo(1, $valore, $a_row['scochi']) ; echo "<tr>\n"; echo "<td class=\"FacetDataTD\"><a class=\"btn btn-xs btn-default\" href=\"admin_movmag.php?id_mov=".$a_row["id_mov"]."&Update\" title=\"".ucfirst($script_transl['update'])."!\"><i class=\"glyphicon glyphicon-edit\"></i> ".$a_row["id_mov"]."</a>  </td>"; echo "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_date($a_row["datreg"])." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["caumag"]." - ".$a_row["descau"]."</td>\n"; if ($a_row['id_rif'] == 0) { echo "<td class=\"FacetDataTD\" align=\"center\" title=\"$title\">".$a_row['desdoc']." ".$script_transl[9]." ".gaz_format_date($a_row["datdoc"])."</td>\n"; } else { if ($a_row['tipdoc'] == "ADT" || $a_row['tipdoc'] == "AFA" || $a_row['tipdoc'] == "AFC") { echo "<td class=\"FacetDataTD\" align=\"center\" title=\"$title\"><a href=\"../acquis/admin_docacq.php?Update&id_tes=".$a_row['testata']."\">".$a_row['desdoc']." ".$script_transl[9]." ".gaz_format_date($a_row["datdoc"])."</a></td>\n"; } else { echo "<td class=\"FacetDataTD\" align=\"center\" title=\"$title\"><a href=\"../vendit/admin_docven.php?Update&id_tes=".$a_row['testata']."\">".$a_row['desdoc']." ".$script_transl[9]." ".gaz_format_date($a_row["datdoc"])."</a></td>\n"; } } echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["artico"]." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_quantity($a_row["quanti"],1,$admin_aziend['decimal_quantity'])."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"right\">".gaz_format_number($valore)." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-elimina\" href=\"delete_movmag.php?id_mov=".$a_row["id_mov"]."\"><i class=\"glyphicon glyphicon-remove\"></i></a></td>\n"; echo "</tr>\n"; } ?> </table> </body> </html>
$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>"; } else { print "<td class=\"FacetDataTD\"></td>"; } print "<td class=\"FacetDataTD\" align=\"center\">".$a_row["numdoc"]."</td>"; print "<td class=\"FacetDataTD\" title= \"$title\" align=\"right\">".gaz_format_number($a_row['dare'])." </td>"; print "<td class=\"FacetDataTD\" align=\"center\">"; $docref=getDocRef($a_row); if (!empty($docref)){ echo "<a class=\"btn btn-xs btn-default btn-default\" title=\"".$script_transl['sourcedoc']."\" href=\"$docref\"><i class=\"glyphicon glyphicon-print\"></i></a>"; } elseif($paymov) {
} else { $span=9; echo "<tr>"; $linkHeaders = new linkHeaders($script_transl['header2']); $linkHeaders -> output(); echo "</tr>"; while (list($key, $mv) = each($m)) { $saldo += $mv['dare']; $saldo -= $mv['avere']; echo "<tr><td class=\"FacetDataTD\">".gaz_format_date($mv["datreg"])." </td>"; echo "<td align=\"center\" class=\"FacetDataTD\"><a href=\"admin_movcon.php?id_tes=".$mv["id_tes"]."&Update\">".$mv["id_tes"]."</a>  </td>"; echo "<td class=\"FacetDataTD\">".$mv["tesdes"]." </td>"; if (!empty($mv['numdoc'])){ echo "<td align=\"center\" class=\"FacetDataTD\">".$mv["protoc"]." </td>"; echo "<td align=\"center\" class=\"FacetDataTD\">".$mv["numdoc"]." </td>"; echo "<td align=\"center\" class=\"FacetDataTD\">".gaz_format_date($mv["datdoc"])." </td>"; } else { echo "<td class=\"FacetDataTD\" colspan=\"3\"></td>"; } echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number($mv['dare'])." </td>"; echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number($mv['avere'])." </td>"; echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number($saldo)." </td></tr>"; } } echo "\t<tr class=\"FacetFieldCaptionTD\">\n"; echo '<td colspan="'.$span.'" align="right"><input type="submit" name="print" value="'; echo $script_transl['print']; echo '">'; echo "\t </td>\n"; echo "\t </tr>\n"; } else {
$cl_exp=''; $class_paymov='FacetDataTD'; } elseif($vi['status']==3){ // SCADUTA $cl_exp=''; $class_paymov='FacetDataTDevidenziaKO'; } elseif($vi['status']==9){ // PAGAMENTO ANTICIPATO $class_paymov='FacetDataTDevidenziaBL'; $vi['expiry']=$vi['cl_exp']; } elseif($vi['status']==0){ // APERTA $lnk=" <a title=\"Riscuoti\" class=\"btn btn-xs btn-default btn-pagamento\" href=\"customer_payment.php?partner=".$p."\"><i class=\"glyphicon glyphicon-euro\"></i></a>"; } } echo "<tr class='".$class_paymov."'>"; echo "<td align=\"right\">".$vi['id']."</td>"; echo "<td align=\"right\">".$v_op."</td>"; echo "<td align=\"center\">".gaz_format_date($vi['expiry'])."</td>"; echo "<td align=\"right\">".$v_cl."</td>"; echo "<td align=\"center\">".$cl_exp."</td>"; echo "<td align=\"center\">".$expo."</td>"; echo "<td align=\"center\">".$script_transl['status_value'][$vi['status']]." $lnk</td>"; echo "</tr>\n"; } } } echo "\t<tr class=\"FacetFieldCaptionTD\">\n"; echo '<td colspan="9" align="right"><input type="submit" name="print" value="'; echo $script_transl['print']; echo '">'; echo "\t </td>\n"; echo "\t </tr>\n"; } else {
$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\">"; if (!empty($fornitore["e_mail"])) { echo '<a class="btn btn-xs btn-default btn-email" onclick="confirMail(this);return false;" id="doc'.$r["id_tes"].'" url="'.$modulo.'&dest=E" href="#" title="mailto: '.$fornitore["e_mail"].'" mail="'.$fornitore["e_mail"].'" namedoc="'.$tipodoc.' n.'.$r["numdoc"].' del '.gaz_format_date($r["datemi"]).'"><i class="glyphicon glyphicon-envelope"></i></a>'; } else { echo '<a title="Non hai memorizzato l\'email per questo fornitore, inseriscila ora" target="_blank" href="admin_fornit.php?codice='.substr($r["codice"],3).'&Update"><i class="glyphicon glyphicon-edit"></i></a>'; } echo "</td>"; echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-elimina\" href=\"delete_broacq.php?id_tes=".$r['id_tes']."\"><i class=\"glyphicon glyphicon-remove\"></i></a></td>"; echo "</tr>"; } ?> </table> </form> </body> </html>
echo "<input type=\"hidden\" value=\"".$form['ritorno']."\" name=\"ritorno\" />\n"; echo "<div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['title1'].$ecr['descri'].$script_transl['title2']."</div>\n"; $rs=getAccountedTickets($ecr['id_cash']); echo "<table class=\"Tlarge\">"; echo "<th class=\"FacetFieldCaptionTD\">".$script_transl['date']."</th> <th class=\"FacetFieldCaptionTD\">".$script_transl['num']."</th> <th class=\"FacetFieldCaptionTD\">".$script_transl['sez']."</th> <th class=\"FacetFieldCaptionTD\">".$script_transl['customer']."</th> <th class=\"FacetFieldCaptionTD\">".$script_transl['importo']."</th>"; if (count($rs['all']) > 0) { foreach($rs['all'] as $k=>$v) { if ($v['tes']['clfoco']<100000000){ $v['tes']['ragsoc']= $script_transl['anony']; } echo "<tr class=\"FacetDataTD\"> <td align=\"center\">".gaz_format_date($v['tes']['datemi'])."</td> <td align=\"center\">".$v['tes']['numdoc']."</td> <td align=\"center\">".$v['tes']['seziva']."</td> <td>".$v['tes']['ragsoc'].$v['tes']['citta']."</td> <td align=\"right\">".gaz_format_number($v['tot'])."</td> </tr>\n"; } echo "<tr class=\"FacetFieldCaptionTD\">\n"; echo '<td colspan="4" align="right"><input type="submit" name="submit" value="'; echo $script_transl['submit']; echo '">'; echo "</td>\n"; echo '<td align="right" style="font-weight=bolt;">'; echo gaz_format_number($rs['tot']); echo "\t </td>\n"; echo "</tr>\n";
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 { echo "<td class=\"$cl\"></td>"; } echo "<td align=\"right\" class=\"$cl\">".gaz_format_number($movimenti["import"])." </td>"; echo "<td align=\"center\" class=\"$cl\">".$movimenti["darave"]." </td></tr>\n"; } } else { echo "<tr><td colspan=\"6\" class=\"FacetDataTDred\">Non ci sono movimenti contabili relativi al fornitore ".$conto['ragso1']." ".$conto['ragso2']." !<td></tr>\n"; } echo "</table></form>"; ?> </body> </html>
function settleAccount($name,$val,$date_r=false) { if (preg_match("/^id_([0-9]+)$/",$val,$match)) { // è un partner da inserire sul piano dei conti $val=0; } global $gTables,$admin_aziend; $rs_display=array(); // INIZIO determinazione limiti di date if ($date_r) { $final_date = $date_r; } else { $final_date = date("Ymd"); } $rs_last_opening = gaz_dbi_dyn_query("*", $gTables['tesmov'], "caucon = 'APE' AND datreg <= ".$final_date,"datreg DESC",0,1); $last_opening = gaz_dbi_fetch_array($rs_last_opening); if ($last_opening) { $date_ini = substr($last_opening['datreg'],0,4).substr($last_opening['datreg'],5,2).substr($last_opening['datreg'],8,2); } else { $date_ini = '20040101'; } // FINE determinazione limiti di date if ($val>100000000 && $val < 299999999 && intval(substr($val,3,6))>0 && $val!=$admin_aziend['cassa_'] ) { $where = " codcon = $val AND datreg BETWEEN $date_ini AND ".$final_date; $orderby = " datreg ASC "; $select = $gTables['tesmov'].".id_tes,datreg,codice,".$gTables['clfoco'].".descri,numdoc,datdoc,import*(darave='D') AS dare,import*(darave='A') AS avere"; $table = $gTables['clfoco']." LEFT JOIN ".$gTables['rigmoc']." ON ".$gTables['clfoco'].".codice = ".$gTables['rigmoc'].".codcon " ."LEFT JOIN ".$gTables['tesmov']." ON ".$gTables['rigmoc'].".id_tes = ".$gTables['tesmov'].".id_tes "; $rs=gaz_dbi_dyn_query ($select, $table, $where, $orderby); while ($r = gaz_dbi_fetch_array($rs)) { $rs_display[]=$r; } } else { $where = " codcon = $val AND datreg BETWEEN $date_ini AND ".$final_date." GROUP BY codcon"; $orderby = " codcon "; $select = "codice,".$gTables['clfoco'].".descri,codcon,SUM(import*(darave='D')) AS dare, SUM(import*(darave='A')) AS avere,datreg"; $table = $gTables['clfoco']." LEFT JOIN ".$gTables['rigmoc']." ON ".$gTables['clfoco'].".codice = ".$gTables['rigmoc'].".codcon " ."LEFT JOIN ".$gTables['tesmov']." ON ".$gTables['rigmoc'].".id_tes = ".$gTables['tesmov'].".id_tes "; $rs=gaz_dbi_dyn_query ($select, $table, $where, $orderby); while ($r = gaz_dbi_fetch_array($rs)) { $r['datreg']= substr($final_date,0,4).'-'.substr($final_date,4,2).'-'.substr($final_date,-2); $r['descri']= 'Saldo '; $rs_display[]=$r; } } echo '<div style="display:none;" class="selectContainer" id="'.$name."\">\n"; echo '<div class="selectHeader">'.$val."</div>\n"; echo '<table cellspacing="0" cellpadding="0" width="100%" class="selectTable">'; $saldo=0.00; $c=false; foreach ($rs_display as $r) { if ($c) { $class='odd'; } else { $class='even'; } $c=!$c; $saldo += $r['dare']; $saldo -= $r['avere']; echo "<tr class=\"$class\"> \n <td>".gaz_format_date($r['datreg']).' - '.$r['descri']." </td>\n <td style=\"text-align:right;\"> ".$r['dare']." </td>\n <td style=\"text-align:right;\"> ".$r['avere']." </td>\n <td style=\"text-align:right;cursor:pointer;\"> <a onclick=\"selectValue('$saldo','$name')\">".gaz_format_number($saldo)."</a> </td>\n </tr>\n"; } echo "</table></div>\n"; }
echo "</div>\n"; echo "<table class=\"Tlarge\">\n"; echo "<tr class=\"FacetColumnTD\">\n"; echo "<td align=\"right\">".$strScript['admin_contract.php']['doc_number']."</td>\n"; echo "<td align=\"center\">".$strScript['admin_contract.php']['start_date']."</td>\n"; echo "<td>".$strScript['admin_contract.php']['customer']."</td>\n"; echo "<td align=\"right\">".$strScript['admin_contract.php']['current_fee']."</td>\n"; echo "<td align=\"center\">".$strScript['admin_contract.php']['last_document_date']."</td>\n"; echo "<td align=\"center\">".$script_transl['n_creation']."</td>\n"; echo "<td align=\"center\">".$strScript['admin_contract.php']['doc_type']."</td>\n"; echo "<td></td>\n"; echo "\t </tr>\n"; foreach ($form['rows'] as $k=>$val) { echo "<tr class=\"FacetDataTD\">\n"; echo "<td align=\"right\">".$val['doc_number']."</td>\n"; echo "<td align=\"center\">".gaz_format_date($val['start_date'])."</td>\n"; echo "<td>".$val['ragsoc']."</td>\n"; echo "<td align=\"right\">".gaz_format_number($val['current_fee'])."</td>\n"; echo "<td align=\"center\">".$val['df']."</td>\n"; echo "<td align=\"center\">".$val['n_bill']."</td>\n"; echo "<td align=\"center\">".$strScript['admin_contract.php']['doc_type_value'][$val['doc_type']]."</td>\n"; if (empty($val['error'])) { echo "<td align=\"center\"><input type=\"checkbox\" name=\"check_$k\" ".$val['check_'.$k]." ></td>\n"; } else { echo "<td class=\"FacetDataTDred\" align=\"center\">".$val['error']."</td>\n"; } echo "\t </tr>\n"; } if (count($form['rows']) > 0) { echo "\t<tr class=\"FacetFieldCaptionTD\">\n"; echo '<td colspan="7" align="right"><input type="submit" name="create" value="';
$tot+=$tot_row; } else { // se descrittivo $desc_arr=str_split(trim($v['descri']),24); foreach ($desc_arr as $d_v) { $ticket_printer->descri_ticket($d_v); } } } if (!empty($tesdoc['spediz'])) { // è stata impostata la stampa del codice fiscale $ticket_printer->descri_ticket('CF= '.$tesdoc['spediz']); } $ticket_printer->pay_ticket(); $ticket_printer->close_ticket(); // FINE invio header("Location: ".$form['ritorno']); exit; } require("../../library/include/header.php"); $script_transl = HeadMain(0); echo "<div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['head'].$tesdoc['numdoc'].'('.gaz_format_date($tesdoc['datemi']).')'.$script_transl['on'].'<font class="FacetDataTD">'.$ecr['descri']."</font></div>\n"; echo "<form method=\"POST\" name=\"ecr\">\n"; echo "<input type=\"hidden\" value=\"".$form['ritorno']."\" name=\"ritorno\" />\n"; echo "<table class=\"Tsmall\">\n"; echo "\t<tr><td colspan=\"2\" class=\"FacetDataTDred\">".$script_transl['message']."</td></tr>\n"; echo "<tr><td colspan=\"2\" align=\"center\">".$script_transl['total'].' '.$admin_aziend['symbol'].' '.gaz_format_number($tot)."</td></tr>\n"; echo "<tr><td align=\"left\"> <input type=\"submit\" name=\"return\" value=\"".$script_transl['return']."\" /></td><td align=\"right\"><input style=\"color:red;\" type=\"submit\" name=\"ins\" value=\"".$script_transl['submit']."\" /></td></tr>\n"; echo "</table>\n"; ?> </body> </form> </html>
function createMultiDocument($results, $templateName, $gTables, $dest = false) { $templates = array('Received' => 'received', 'CartaIntestata' => 'carta_intestata', 'Lettera' => 'lettera', 'FatturaAcquisto' => 'fattura_acquisto', 'FatturaImmediata' => 'fattura_immediata', 'Parcella' => 'parcella', 'PreventivoCliente' => 'preventivo_cliente', 'OrdineCliente' => 'ordine_cliente', 'OrdineWeb' => 'ordine_web', 'FatturaSemplice' => 'fattura_semplice', 'FatturaAllegata' => 'fattura_allegata', 'OrdineFornitore' => 'ordine_fornitore', 'PreventivoFornitore' => 'preventivo_fornitore', 'InformativaPrivacy' => 'informativa_privacy', 'DDT' => 'ddt'); $config = new Config(); $configTemplate = new configTemplate(); require "../../config/templates" . ($configTemplate->template ? '.' . $configTemplate->template : '') . '/' . $templates[$templateName] . '.php'; $pdf = new $templateName(); $docVars = new DocContabVars(); //$pdf->SetPageFormat($config->getValue('page_format')); $pdf->SetTitle($templateName); $pdf->SetTopMargin(79); $pdf->SetHeaderMargin(5); $ctrlprotoc = 0; while ($tesdoc = gaz_dbi_fetch_array($results)) { //se il cliente non e' lo stesso di prima $ref = $tesdoc['protoc']; if ($templateName == 'DDT') { $ref = $tesdoc['numdoc']; } if ($ref != $ctrlprotoc && $ctrlprotoc > 0) { $pdf->pageFooter(); } // Inizio pagina $testat = $tesdoc['id_tes']; $docVars->setData($gTables, $tesdoc, $testat, 'rigdoc'); $docVars->initializeTotals(); $pdf->setVars($docVars, $templateName); $pdf->setTesDoc(); if ($ctrlprotoc == 0) { $pdf->setCreator('GAzie - ' . $docVars->intesta1); $pdf->setAuthor($docVars->user['Cognome'] . ' ' . $docVars->user['Nome']); $pdf->Open(); } //aggiungo una pagina $pdf->pageHeader(); $ctrlprotoc = $tesdoc['protoc']; if ($templateName == 'DDT') { $ctrlprotoc = $tesdoc['numdoc']; } $testat = $tesdoc['id_tes']; $pdf->docVars->setData($gTables, $tesdoc, $testat, 'rigdoc'); $pdf->compose(); } $pdf->pageFooter(); if ($dest && $dest == 'E') { // è stata richiesta una e-mail $dest = 'S'; // Genero l'output pdf come stringa binaria // Costruisco oggetto con tutti i dati del file pdf da allegare $content->name = $docVars->intesta1 . '_' . $templateName . '_n.' . $docVars->docRelNum . '_del_' . gaz_format_date($docVars->docRelDate) . '.pdf'; $content->string = $pdf->Output($docVars->intesta1 . '_' . $templateName . '_n.' . $docVars->docRelNum . '_del_' . gaz_format_date($docVars->docRelDate) . '.pdf', $dest); $content->encoding = "base64"; $content->mimeType = "application/pdf"; $gMail = new GAzieMail(); $gMail->sendMail($docVars->azienda, $docVars->user, $content, $docVars->client); } elseif ($dest && $dest == 'X') { // è stata richiesta una stringa da allegare $dest = 'S'; // Genero l'output pdf come stringa binaria // Costruisco oggetto con tutti i dati del file pdf $content->descri = $docVars->intesta1 . '_' . $templateName . '_n.' . $docVars->tesdoc['numfat'] . '/' . $docVars->tesdoc['seziva'] . '_del_' . gaz_format_date($docVars->tesdoc['datfat']) . '.pdf'; $content->string = $pdf->Output($content->descri, $dest); $content->mimeType = "PDF"; return $content; } else { // va all'interno del browser $pdf->Output(); } }
$ctr_mv=''; echo "<tr>"; $linkHeaders=new linkHeaders($script_transl['header']); $linkHeaders->output(); echo "</tr>"; while (list($key, $mv) = each($m)) { if ($ctr_mv != $mv['tipeff']) { echo "\t<tr>\n"; echo "\t<td colspan=\"6\">".$mv['tipeff'].' - '.$script_transl['type_value'][$mv['tipeff']]."</td>\n"; echo "\t </tr>\n"; } echo "<td align=\"center\" class=\"FacetDataTD\"><A HREF=\"./update_effett.php?id_tes=".$mv['id_tes']."\">".$mv['progre']."</a></td>"; echo "<td align=\"center\" class=\"FacetDataTD\">".gaz_format_date($mv['scaden'])."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number($mv['impeff'])."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\">".$mv['ragso1'].' '.$mv['ragso2']."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\"> n.".$mv['numfat'].' sez.'.$mv['seziva']." del ".gaz_format_date($mv['datfat'])."</td>\n"; echo "<td align=\"center\" class=\"FacetDataTD\">".$mv['desban']."</td>\n"; echo "</tr>\n"; $ctr_mv = $mv['tipeff']; } echo "\t<tr class=\"FacetFieldCaptionTD\">\n"; echo '<td colspan="7" align="right"><input type="submit" name="print" value="'; echo $script_transl['print']; echo '">'; echo "\t </td>\n"; echo "\t </tr>\n"; } echo "</table>\n"; } ?> </form>
} else { echo $tesdoc_r["tipdoc"].$rigbro_r["id_doc"]. " "; } $ultimo_documento = $rigbro_r["id_doc"]; } } } echo "</td>"; } echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-stampa\" href=\"".$modulo."\"><i class=\"glyphicon glyphicon-print\"></i></a>"; echo "</td>"; // Colonna "Mail" echo "<td class=\"FacetDataTD\" align=\"center\">"; if (!empty($r["e_mail"])) { echo '<a class="btn btn-xs btn-default btn-email" onclick="confirMail(this);return false;" id="doc'.$r["id_tes"].'" url="'.$modulo.'&dest=E" href="#" title="mailto: '.$r["e_mail"].'" mail="'.$r["e_mail"].'" namedoc="'.$script_transl['type_value'][$r["tipdoc"]].' n.'.$r["numdoc"].' del '.gaz_format_date($r["datemi"]).'"><i class="glyphicon glyphicon-envelope"></i></a>'; } else { echo '<a title="Non hai memorizzato l\'email per questo cliente, inseriscila ora" href="admin_client.php?codice='.substr($r["codice"],3).'&Update"><i class="glyphicon glyphicon-edit"></i></a>'; } echo "</td>"; echo "<td class=\"FacetDataTD\" align=\"center\">"; if (!$remains_atleastone || !$processed_atleastone) { //possono essere cancellati solo gli ordini inevasi o completamente evasi echo "<a class=\"btn btn-xs btn-default btn-elimina\" href=\"delete_broven.php?id_tes=".$r['id_tes']."\"><i class=\"glyphicon glyphicon-remove\"></i></a>"; } echo "</td>"; echo "</tr>\n"; } ?> </table> </form>
ucwords(strtolower($script_transl['print'])) => "", 'Mail'=>'', $script_transl['delete'] => "" ); $linkHeaders = new linkHeaders($headers_mov); $linkHeaders -> output(); $recordnav = new recordnav($table, $where, $limit, $passo); $recordnav -> output(); while ($a_row = gaz_dbi_fetch_array($result)) { echo "<tr>\n"; echo "<td class=\"FacetDataTD\" align=\"right\"><a href=\"admin_letter.php?id_let=".$a_row["id_let"]."&Update\" title=\"".ucfirst($script_transl['update'])."!\">".$a_row["id_let"]."</a>  </td>"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["write_date"]." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["numero"]."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["tipo"]."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row['ragso1']." ".$a_row['ragso2']."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$a_row["oggetto"]." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\"> <a href=\"stampa_letter.php?id_let=".$a_row["id_let"]."\"><img src=\"../../library/images/stampa.gif\" alt=\"Stampa\" border=\"0\" /></a></td>"; // Colonna "Mail" echo "<td class=\"FacetDataTD\" align=\"center\">"; if (!empty($a_row["e_mail"])) { echo '<a onclick="confirMail(this);return false;" id="doc'.$a_row["id_let"].'" url="stampa_letter.php?id_let='.$a_row["id_let"].'&dest=E" href="#" title="mailto: '.$a_row["e_mail"].'" mail="'.$a_row["e_mail"].'" namedoc="Lettera n.'.$a_row["numero"].' del '.gaz_format_date($a_row["write_date"]).'"><img src="../../library/images/email.gif" border="0"></a>'; } echo "</td>"; echo "<td class=\"FacetDataTD\" align=\"center\"><a href=\"delete_letter.php?id_let=".$a_row["id_let"]."\"><img src=\"../../library/images/x.gif\" title=\"".$script_transl['delete']."!\" border=\"0\"></a></td>\n"; echo "</tr>\n"; } ?> </table> </body> </html>
if (sizeof($r['data'])>0) { echo "<tr>"; echo '<TD colspan="7" align="center" class="FacetDataTD">'.$script_transl['preview']."</td>\n"; echo "</tr>"; echo "<tr>"; $linkHeaders=new linkHeaders($script_transl['header']); $linkHeaders->output(); echo "</tr>\n"; foreach($r['data'] as $v) { echo "<tr>"; echo "<td class=\"FacetDataTD\"><A HREF=\"http://localhost/gazie/modules/vendit/update_effett.php?id_tes=".$v['id_tes']."\">".$v["progre"]."</A></td>"; echo "<td class=\"FacetDataTD\">".$v["tipeff"]." </td>"; echo "<td class=\"FacetDataTD\">".gaz_format_date($v["scaden"])."</td>"; echo "<td class=\"FacetDataTD\" align=\"right\">".$admin_aziend['symbol'].' '.gaz_format_number($v["impeff"])." </td>"; echo "<td class=\"FacetDataTD\">".$v["customer"]." </td>"; echo "<td class=\"FacetDataTD\"><A HREF=\"http://localhost/gazie/modules/vendit/admin_docven.php?id_tes=".$v['id_tes']."&Update\">n.".$v["numfat"]."/".$v["seziva"]." - ".gaz_format_date($v["datfat"])."</a></td>"; echo "<td class=\"FacetDataTD\">".$v["desban"]." </td>"; echo "</tr>\n"; echo "<tr>"; if ($v["status"]=='DISTINTATO') { echo "<td class=\"FacetDataTDred\" align=\"center\" colspan=\"4\">".strtoupper($script_transl['reprint'])."!"; } else { echo "<td colspan=\"4\">"; } echo "</td>"; echo "<td>".$v["pariva"]."</td>"; echo "<td align=\"right\">".gaz_format_number($v["totfat"])."</td>"; echo "<td align=\"center\">".$v["coordi"]." </td>"; echo "</tr>\n"; } echo '<TD colspan="4" class="FacetDataTD">'.
</tr> <tr> <td class="FacetFieldCaptionTD"><?php echo $script_transl['pagame']; ?></td> <td class="FacetDataTD"><?php print $pagame["descri"]; ?> </td> </tr> <tr> <td class="FacetFieldCaptionTD"><?php echo $script_transl['banapp']; ?></td> <td class="FacetDataTD"><?php print $banapp["descri"]; ?> </td> </tr> <tr> <td class="FacetFieldCaptionTD"><?php echo $script_transl['impeff']; ?></td> <td class="FacetDataTD"><?php print gaz_format_number($form["impeff"]); ?> </td> </tr> <tr> <td class="FacetFieldCaptionTD"><?php echo $script_transl['date_exp']; ?></td> <td class="FacetDataTD"><?php print gaz_format_date($form["scaden"]); ?> </td> </tr> <tr> <td class="FacetFieldCaptionTD"><?php echo $script_transl['account_id']; ?></td> <td class="FacetDataTD"><?php print ($form['id_con']); ?> </td> </tr> <tr> <td align="right"> <?php echo '<input type="submit" accesskey="r" name="Return" value="'.$script_transl['return'].'"></td><td> '.ucfirst($script_transl['safe']); echo ' <input type="submit" accesskey="d" name="Delete" value="'.$script_transl['delete'].'">'; ?> </td> </tr> </table>
function printTransact($transact,$error) { global $script_transl,$admin_aziend; $nrec=0; echo "<td align=\"center\" class=\"FacetDataTD\" >N.Rec.</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" >N.Mov.</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" >".$script_transl['sourcedoc']."</td>"; echo "<td class=\"FacetDataTD\" >".$script_transl['soggetto']."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" >".$script_transl['pariva']."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" >".$script_transl['codfis']."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" >".$script_transl['quadro']."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\" >".$script_transl['amount']."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\" >".$script_transl['tax']."</td>"; echo "</tr>\n"; foreach ($transact as $key=>$value ) { $nrec++; $totale = gaz_format_number($value['operazioni_imponibili']+$value['operazioni_nonimp']+$value['operazioni_esente']); $class = ' '; switch ($value['quadro']) { case 'FE': $class = 'style="color:#000000; background-color: #FFDDDD;"'; break; case 'NE': $class = 'style="color:#000000; background-color: #DDFFDD;"'; break; case 'FR': $class = 'style="color:#000000; background-color: #AFC8D8"'; break; case 'NR': $class = 'style="color:#000000; background-color: #D3CFA8;"'; break; case 'DF': $class = 'style="color:#000000; background-color: #DDDDFF;"'; break; } if (isset($error[$key])){ $class = ' class="FacetDataTDred" '; } echo "<tr>"; echo "<td align=\"right\" $class>$nrec</a></td>"; echo "<td align=\"center\" $class><a href=\"../contab/admin_movcon.php?id_tes=".$value['id_tes']."&Update\">n.".$value['id_tes']." - ".gaz_format_date($value['datreg'])."</a></td>"; echo "<td align=\"center\" $class> sez.".$value['seziva']." n.".$value['numdoc'].' del '.gaz_format_date($value['datdoc'])."</td>"; echo "<td $class>".$value['ragso1'].' '.$value['ragso2']."</td>"; if ($value['riepil']== 1 ){ // è un riepilogativo quindi il tracciato dovrà prevedere l'apposito flag echo "<td align=\"center\" colspan=\"2\" style=\"color:#000000; background-color: #DDADAF;\">".$script_transl['riepil']."</td>"; } else { echo "<td align=\"center\" $class>".$value['iso']." ".$value['pariva']."</td>"; echo "<td align=\"center\" $class>".$value['codfis']."</td>"; } echo "<td align=\"center\" $class>".$value['quadro']."</td>"; echo "<td align=\"right\" $class>$totale</td>"; echo "<td align=\"right\" $class>".gaz_format_number($value['imposte_addebitate'])."</td>"; echo "</tr>\n"; if (isset($error[$key])) { foreach ($error[$key] as $val_err ) { echo "<tr>"; echo "<td class=\"FacetDataTDred\" colspan=\"10\">".$val_err; if (substr($value['clfoco'],0,3) == $admin_aziend['mascli']) { echo ", <a href='../vendit/admin_client"; } else { echo ", <a href='../acquis/admin_fornit"; } echo ".php?codice=".substr($value['clfoco'],3,6)."&Update' target='_NEW'>". $script_transl['errors'][0]."</a><br /></td> </tr>\n"; } } } }
$msg=$script_transl['afternoon']; } elseif ($t>17 && $t<=21) { $msg=$script_transl['evening']; } else { $msg=$script_transl['night']; } echo "<form method=\"POST\" name=\"myform\">\n"; echo "<input type=\"hidden\" value=\"".$form['hidden_req']."\" name=\"hidden_req\" />\n"; echo '<div id="admin_main" ><table border="1" class="Tmiddle">'; echo "<tr class=\"FacetFormHeaderFont\">\n"; echo "<td class=\"FacetDataTD\"><A href=\"../config/admin_utente.php?Login="******"&Update\"><img src=\"view.php?table=admin&field=Login&value=".$admin_aziend['Login']."\" alt=\"".$admin_aziend['Cognome'].' '.$admin_aziend['Nome']."\" width=100 title=\"".$script_transl['change_usr']."\" border=\"2\"></a>"; echo "</td>"; echo "<td id='admin_welcome'>"; echo ucfirst($msg)." ".$admin_aziend['Nome'].' (ip='.$admin_aziend['last_ip'].')'. "\n"; echo "".$script_transl['access'].$admin_aziend['Access'].$script_transl['pass'].gaz_format_date($admin_aziend['datpas'])."<br>"; echo "<div id='admin_p_logout'>".$script_transl['logout']." → <input name=\"logout\" type=\"submit\" value=\" Logout \"></div></td>\n"; echo "<td align=\"center\" bgcolor=\"#".$admin_aziend['colore']."\">".$script_transl['company']."<a href=\"../config/admin_aziend.php\"><img src=\"view.php?table=aziend&value=".$form['enterprise_id']."\" width=\"200\" alt=\"Logo\" border=\"0\" title=\"".$script_transl['upd_company']."\"></a><br />".$script_transl['mesg_co'][2]." → "; echo selectCompany('enterprise_id',$form['enterprise_id'],$form['search']['enterprise_id'],$form['hidden_req'],$script_transl['mesg_co']); echo "</td>\n"; echo "</tr></table></div>\n"; echo "<div id='admin_footer'>"; echo "<div align=\"center\"><br /> GAzie Version: $versSw Software Open Source (lic. GPL) ".$script_transl['business']." ".$script_transl['proj']."<a target=\"_new\" title=\"".$script_transl['auth']."\" href=\"http://http://www.devincentiis.it\"> http://www.devincentiis.it</a></div>\n"; echo '<div><table border="0" class="Tmiddle">'; echo "<tr align=\"center\"><td>\n"; echo "<a href=\"http://gazie.devincentiis.it\" target=\"_new\" title=\"".$script_transl['devel']." www.gazie.it\"><img src=\"../../library/images/gazie.gif\" height=\"38\" border=\"0\"></a>\n"; foreach ($script_transl['strBottom'] as $value){ echo "<a href=\"".$value['href']."\" title=\"".$value['title']."\" target=\"_NEW\" >"; // echo "<img src=\"http://".$_SERVER['HTTP_HOST']."/".$radix."/library/images/".$value['img']."\" border=\"0\" ></a>\n"; echo "<img src=\"../../library/images/".$value['img']."\" border=\"0\" ></a>\n"; }
break; } $totimponi += $imponi; if ($v['tipiva'] != "D" || $v['tipiva'] != "T") { // indetraibile o split payment $totimpost += $impost; } if ($ctrl != $v['id_tes']) { // primo rigo iva del movimento contabile if ($maxY>265){ $pdf->AddPage(); $maxY = $pdf->GetY(); } $pdf->SetY($maxY); $pdf->Cell(10,4,$v['protoc'],'LTB',0,'C'); $pdf->Cell(18,4,gaz_format_date($v['datreg']),'LTB',0,'C'); $pdf->Cell(32,4,$v['numdoc'],'LTB',0,'C'); $pdf->Cell(18,4,gaz_format_date($v['datdoc']),'LTB',0,'R'); $pdf->Cell(112,4,$v['ragsoc'],'LTR',1,'L'); $topCarry[1]['name']= gaz_format_number($totimponi).' '; $botCarry[1]['name']= gaz_format_number($totimponi).' '; $topCarry[2]['name']= gaz_format_number($totimpost).' '; $botCarry[2]['name']= gaz_format_number($totimpost).' '; $topCarry[3]['name']= gaz_format_number($totimponi+$totimpost).' '; $botCarry[3]['name']= gaz_format_number($totimponi+$totimpost).' '; $pdf->setTopCarryBar($topCarry); $pdf->setBotCarryBar($botCarry); $pdf->Cell(66,4,$v['descri'],'LTB',0,'R'); $pdf->Cell(12,4,'cod. '.$v['codiva'],1,0,'C'); $pdf->Cell(40,4,$v['desiva'],1,0,'L'); $pdf->Cell(20,4,gaz_format_number($v['imponi']),1,0,'R'); $pdf->Cell(14,4,gaz_format_number($v['periva']).'%',1,0,'C'); $pdf->Cell(18,4,gaz_format_number($v['impost']),1,0,'R');
} else { $status_cl=true; } } if (empty($mv["numdoc"])){ $mv["datdoc"]=''; $mv['seziva']=''; } $pdf->Cell(45,4,$partner,'LTB',0,'',$status_cl,'',1); $pdf->Cell(20,4,$paymov,1,0,'R',$status_cl,'',2); $pdf->Cell(41,4,$mv['descri'],1,0,'C',$status_cl,'',1); $pdf->Cell(11,4,$mv["numdoc"].'/'.$mv['seziva'],1,0,'R',$status_cl); $pdf->Cell(15,4,$mv["datdoc"],1,0,'C',$status_cl); $pdf->Cell(15,4,gaz_format_date($mv["datreg"]),1,0,'C',$status_cl); if ($mv['id_rigmoc_pay']==0){ $pdf->Cell(12,4,gaz_format_number($mv['amount']),1,0,'R',$status_cl); $pdf->Cell(12,4,'',1,0,'R',$status_cl); } else { $pdf->Cell(12,4,'',1,0,'R',$status_cl); $pdf->Cell(12,4,gaz_format_number($mv['amount']),1,0,'R',$status_cl); } $pdf->Cell(15,4,gaz_format_date($mv["expiry"]),1,1,'C',$status_cl); $ctrl_partner=$mv["clfoco"]; $ctrl_id_tes=$mv["id_tes"]; $ctrl_paymov=$mv["id_tesdoc_ref"]; } } $pdf->setRiporti(''); $pdf->Output(); ?>
echo "\t </tr>\n"; $sum=0.00; } echo "\t<tr>\n"; echo "\t<td colspan=\"10\">".$mv['artico']." - ".$mv['desart']."</td>\n"; echo "\t </tr>\n"; } // passo tutte le variabili al metodo in modo da non costringere lo stesso a fare le query per ricavarsele $magval= $gForm->getStockValue($mv['id_mov'],$mv['artico'],$mv['datreg'],$admin_aziend['stock_eval_method']); $r_span=count($magval); foreach ($magval as $mval) { if ($ctrl_id <> $mv['id_mov']) { echo "<tr><td class=\"FacetDataTD\" rowspan=\"$r_span\">".gaz_format_date($mv['datreg'])." id:".$mv['id_mov']."</td>"; echo "<td align=\"center\" class=\"FacetDataTD\" rowspan=\"$r_span\">".$mv['caumag'].'-'.substr($mv['descri'],0,20)."</td>"; echo "<td class=\"FacetDataTD\" rowspan=\"$r_span\">".substr($mv['desdoc'].' del '.gaz_format_date($mv['datdoc']).' - '.$mv['ragso1'].' '.$mv['ragso2'],0,85)."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\" rowspan=\"$r_span\">".number_format($mv['prezzo'],$admin_aziend['decimal_price'],',','.')."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\" rowspan=\"$r_span\">".$mv['unimis']."</td>\n"; } else { echo "<tr>"; } echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_quantity($mval['q']*$mv['operat'],1,$admin_aziend['decimal_quantity'])."</td>"; if ($mv['operat']==1) { echo "<td align=\"right\" class=\"FacetDataTD\">".number_format($mval['v'],$admin_aziend['decimal_price'],',','')."</td><td></td>"; } else { echo "<td></td><td align=\"right\" class=\"FacetDataTD\">".number_format($mval['v'],$admin_aziend['decimal_price'],',','')."</td>"; } echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_quantity($mval['q_g'],1,$admin_aziend['decimal_quantity'])."</td>"; echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number($mval['v_g'])."</td>"; echo "</tr>"; $ctrl_id = $mv['id_mov'];
$status=$script_transl['status_value'][1]; } else { $status=$script_transl['status_value'][0]; } if ($row['numfat']>0) { $cliente = $anagrafica->getPartner($row['clfoco']); $invoice="<a href=\"stampa_docven.php?id_tes=".$row['id_tes']."&template=FatturaAllegata\">n.".$row['numfat']." del ".gaz_format_date($row['datfat']).' a '.$cliente['ragso1']." <img src=\"../../library/images/stampa.gif\" border=\"0\"></a>\n"; } else { $invoice=''; } echo "<tr>"; // Colonna ID scontrino echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-edit\" href=\"admin_scontr.php?Update&id_tes=".$row['id_tes']."\"><i class=\"glyphicon glyphicon-edit\"></i> ".$row["id_tes"]."</a></td>"; // Colonna data emissione echo "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_date($row['datemi'])."</td>"; // Colonna numero documento echo "<td class=\"FacetDataTD\" align=\"center\">".$row["numdoc"]." </td>"; // Colonna fattura echo "<td class=\"FacetDataTD\" align=\"center\">$invoice</td>"; echo "<td class=\"FacetDataTD\" align=\"center\">".$status." </td>"; echo '<td class="FacetDataTD" align="right" style="font-weight=bolt;">'; echo gaz_format_number($tot_tes); echo "\t </td>\n"; // Colonna Elimina if ($row["id_con"] == 0) { if (getLastId($row['datemi'],$row['seziva']) == $row["id_tes"]) { echo "<td class=\"FacetDataTD\" align=\"center\"><a class=\"btn btn-xs btn-default btn-elimina\" href=\"delete_docven.php?id_tes=".$row['id_tes']."\"><i class=\"glyphicon glyphicon-remove\"></i></a></td>"; } else { echo "<td class=\"FacetDataTD\" align=\"center\"><button class=\"btn btn-xs btn-default btn-elimina disabled\"><i class=\"glyphicon glyphicon-remove\"></i></button></td>"; }
$pdf->SetFillColor(160, 255,220 ); $pdf->setRiporti(''); $pdf->AddPage(); $config = new Config; $paymov = new Schedule; $ctrl_pm=0; $pdf->SetFont('helvetica','',10); $pdf->Cell(100,6,$d['d'][1]['descri'],1,1,'L',1,'',1); while (list($k, $mv) = each($d['d'])) { if ($ctrl_pm <> $mv["id_tesdoc_ref"]){ } $pdf->Cell(30,6,$mv['id_tesdoc_ref'],'LTB',0,'L',0,'',1); $pdf->Cell(70,6,$mv['t']['descri'],1,0,'L',0,'',1); $pdf->Cell(25,6,$mv['t']["numdoc"].'/'.$mv['t']['seziva'],1,0,'C',0); $pdf->Cell(25,6,gaz_format_date($mv['t']["datdoc"]),1,0,'C',0); $pdf->Cell(36,6,gaz_format_number($mv['amount']),1,1,'R',0); $ctrl_pm=$mv["id_tesdoc_ref"]; } $pdf->Ln(10); $pdf->SetFont('helvetica','B',10); $pdf->Cell(150,6,$script_transl['tot'].': ','LTB',0,'R'); $pdf->Cell(36,6,'€ '.gaz_format_number($d['d'][1]['import']),'RTB',1,'R',1,'',1); $pdf->Ln(10); $pdf->SetFont('courier','',8); $pdf->Cell(100,6,''); $pdf->Cell(60,6,$admin_aziend['Nome'].' '.$admin_aziend['Cognome'],0,1,'C'); $pdf->Cell(100,6,''); $pdf->Cell(60,20,'____________________________',0,0,'C'); $pdf->setRiporti(''); $pdf->Output();
$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>
} break; case "2": $checkin = ''; break; case "3": $checkin = ''; break; case "6": $body_text = gaz_dbi_get_row($gTables['body_text'],'id_body',$v['id_body_text']); $v['descri'] = substr($body_text['body_text'],0,80); $checkin = ''; break; } if ($ctrl_tes != $v['id_tes']) { echo "<tr><td class=\"FacetDataTD\" colspan=\"7\"> ".$script_transl['from']."<a href=\"admin_broven.php?Update&id_tes=".$v["id_tes"]."\" title=\"".$script_transl['upd_ord']."\">".$v['numdoc']."</a> ".$script_transl['del'].' '.gaz_format_date($v['datemi'])." </td></tr>"; } echo "<tr>"; echo "<input type=\"hidden\" name=\"righi[$k][id_tes]\" value=\"".$v['id_tes']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][datemi]\" value=\"".$v['datemi']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][tipdoc]\" value=\"".$v['tipdoc']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][numdoc]\" value=\"".$v['numdoc']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][id_rig]\" value=\"".$v['id_rig']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][tiprig]\" value=\"".$v['tiprig']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][id_doc]\" value=\"".$v['id_doc']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][id_body_text]\" value=\"".$v['id_body_text']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][codvat]\" value=\"".$v['codvat']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][pervat]\" value=\"".$v['pervat']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][ritenuta]\" value=\"".$v['ritenuta']."\">\n"; echo "<input type=\"hidden\" name=\"righi[$k][codric]\" value=\"".$v['codric']."\">\n"; echo "<td><input type=\"hidden\" name=\"righi[$k][codart]\" value=\"".$v['codart']."\">".$v['codart']."</td>\n";
$pdf->setRiporti(''); $pdf->AddPage('L',$config->getValue('page_format')); } // passo tutte le variabili al metodo in modo da non costringere lo stesso a fare le query per ricavarsele $magval= $gForm->getStockValue($mv['id_mov'],$mv['artico'],$mv['datreg'],$admin_aziend['stock_eval_method']); $r_span=count($magval); foreach ($magval as $mval) { $aRiportare['top'][1]['nam'] = gaz_format_quantity($mval['q_g'],1,$admin_aziend['decimal_quantity']); $aRiportare['bot'][1]['nam'] = gaz_format_quantity($mval['q_g'],1,$admin_aziend['decimal_quantity']); $aRiportare['top'][2]['nam'] = gaz_format_number($mval['v_g']); $aRiportare['bot'][2]['nam'] = gaz_format_number($mval['v_g']); if ($ctrl_id <> $mv['id_mov']) { $pdf->Cell(16,4,gaz_format_date($mv['datreg']),'LTR',0,'C'); $pdf->Cell(30,4,$mv['caumag'].'-'.substr($mv['descri'],0,17),'TR'); $pdf->Cell(100,4,substr($mv['desdoc'].' '.gaz_format_date($mv['datdoc']).' - '.$mv['ragso1'].' '.$mv['ragso2'],0,80),'TR'); $pdf->Cell(17,4,number_format($mv['prezzo'],$admin_aziend['decimal_price'],',',' '),'TR',0,'R'); $pdf->Cell(8,4,$mv['unimis'],'TR',0,'C'); } else { $pdf->Cell(16,4,'','LR'); $pdf->Cell(30,4,'','R'); $pdf->Cell(100,4,'','R'); $pdf->Cell(17,4,'','R'); $pdf->Cell(8,4,'','R'); } $pdf->Cell(17,4,gaz_format_quantity($mval['q']*$mv['operat'],1,$admin_aziend['decimal_quantity']),1,0,'R'); if ($mv['operat']==1) { $pdf->Cell(17,4,number_format($mval['v'],$admin_aziend['decimal_price'],',',''),1,0,'R'); $pdf->Cell(17,4,'',1); } else { $pdf->Cell(17,4,'',1);
if (isset($_GET['anteprima']) and $msg == "") { $result = gaz_dbi_dyn_query($gTables['rigdoc'].".*,".$gTables['tesdoc'].".id_tes,".$gTables['tesdoc'].".tipdoc,".$gTables['tesdoc'].".numdoc,".$gTables['tesdoc'].".datemi,".$gTables['tesdoc'].".datfat,".$gTables['tesdoc'].".imball,".$gTables['tesdoc'].".clfoco,".$gTables['tesdoc'].".caumag,".$gTables['tesdoc'].".sconto as scochi", $gTables['rigdoc']." LEFT JOIN ".$gTables['tesdoc']." ON ".$gTables['rigdoc'].".id_tes = ".$gTables['tesdoc'].".id_tes LEFT JOIN ".$gTables['caumag']." ON ".$gTables['tesdoc'].".caumag = ".$gTables['caumag'].".codice", "tiprig = 0 AND id_mag = 0 AND caumag > 0 AND datemi BETWEEN $datainizio AND $datafine ", " datemi ASC, ".$gTables['tesdoc'].".id_tes ASC, id_rig ASC"); $numrow = gaz_dbi_num_rows($result); echo "<table class=\"Tlarge\">"; if ($numrow > 0) { echo "<tr><td class=\"FacetFieldCaptionTD\" colspan=\"6\" >$numrow ".$script_transl[5]."</td></tr>"; require("../../modules/vendit/lang.".$admin_aziend['lang'].".php"); $desdoc = $strScript["admin_docven.php"][0]; require("../../modules/acquis/lang.".$admin_aziend['lang'].".php"); $desdoc += $strScript["admin_docacq.php"][0]; while ($row = gaz_dbi_fetch_array($result)) { echo "<tr>\n"; $valore = CalcolaImportoRigo($row['quanti'], $row['prelis'], $row['sconto']) ; $valore = CalcolaImportoRigo(1, $valore, $row['scochi']) ; $descri = $desdoc[$row['tipdoc']]." n.".$row['numdoc']; echo "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_date($row["datemi"])." </td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$row["caumag"]." - ".$row["descri"]."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">$descri</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".$row["codart"]."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"center\">".gaz_format_quantity($row["quanti"],1,$admin_aziend['decimal_quantity'])."</td>\n"; echo "<td class=\"FacetDataTD\" align=\"right\">".gaz_format_number($valore)." </td>"; echo "</tr>\n"; } echo "<tr><td colspan=\"6\" align=\"center\"><input type=\"submit\" name=\"insert\" value=\"".strtoupper($script_transl[0])." !\"></TD></TR>"; } else { echo "<tr><td class=\"FacetDataTDred\" align=\"center\">".$script_transl[6]."</td></tr>"; } } ?> </form> </body>
$ex= new Expiry; $partner=$anagrafica->getPartner(intval($_POST['conto_rc'.$i])); $pag = gaz_dbi_get_row($gTables['pagame'], "codice", $partner['codpag']); $rs_ex=$ex->CalcExpiry(floatval($_POST['importorc'][$i]),$datadoc,$pag['tipdec'],$pag['giodec'],$pag['numrat'],$pag['tiprat'],$pag['mesesc'],$pag['giosuc']); foreach($rs_ex as $ve){ // attraverso le rate $new_paymov[$j]['amount']=$ve['amount']; $new_paymov[$j]['expiry']=$ve['date']; $calc->updatePaymov($new_paymov[$j]); } } else { $new_paymov[$j]['expiry']=gaz_format_date($new_paymov[$j]['expiry'],true); $calc->updatePaymov($new_paymov[$j]); } } else { // chiusura partita $new_paymov[$j]['id_rigmoc_pay']=$last_id_rig; $new_paymov[$j]['expiry']=gaz_format_date($new_paymov[$j]['expiry'],true); $calc->updatePaymov($new_paymov[$j]); } } } } } if ($toDo == 'insert') { header("Location: report_movcon.php"); } else { header("Location: ".$form['ritorno']); } exit; } }
if ($vi['cl_val']==$vi['op_val']){ $vi['status']=2; // la partita è chiusa ma è esposta a rischio insolvenza $pdf->SetFillColor(255,245,185); $class_paymov='FacetDataTDevidenziaOK'; } } else { if ($vi['cl_val']==$vi['op_val']){ // chiusa e non esposta $cl_exp=''; $pdf->SetFillColor(230,255,230); } elseif($vi['status']==3){ // SCADUTA $cl_exp=''; $pdf->SetFillColor(255,160,160); } elseif($vi['status']==9){ // PAGAMENTO ANTICIPATO $pdf->SetFillColor(190,190,255); $vi['expiry']=$vi['cl_exp']; } } $pdf->Cell(28,4,$vi['id'],'LTB',0,'C',1,'',1); $pdf->Cell(28,4,$v_op,1,0,'R',1); $pdf->Cell(28,4,gaz_format_date($vi['expiry']),1,0,'C',1,'',1); $pdf->Cell(28,4,$v_cl,1,0,'R',1); $pdf->Cell(28,4,$cl_exp,1,0,'C',1); $pdf->Cell(28,4,$expo,1,0,'C',1); $pdf->Cell(18,4,$script_transl['status_value'][$vi['status']],1,1,'C',1); } } } } $pdf->setRiporti(''); $pdf->Output(); ?>
if ( $row['fax'] != "" ) $fax = "fax: ".$row['fax']; else $fax = ""; if ( $row['cell'] != "" ) $mob = "mob:".$row['cell']; else $mob = ""; if ( $row['telefo'] != "" ) $tel = "tel:".$row['telefo']; else $tel = ""; if ( $row['e_mail'] != "" ) $email = $row['e_mail']; else $email = ""; $pdf->Cell(188,6,$row['ragso1']." ".$row['ragso2']." ".$tel." ".$fax." ".$mob." ".$email,1,1,'',1,'',1); $vrag = $row["ragso1"]; $totale_ore = 0; } $pdf->SetFont('helvetica','',9); $pdf->Cell(12,5,$row['id'],'LTB',0,'R',1,'',1); $pdf->Cell(20,5,gaz_format_date($row['data']),1,0,'C',1,'',1); $pdf->Cell(62,5,$row['oggetto'],1,0,'L',1); $pdf->Cell(64,5,substr($row['descrizione'],0,50),1,0,'L',1); $pdf->Cell(12,5,gaz_format_number($row['ore']),1,0,'R',1); $totale_ore += $row['ore']; $pdf->Cell(18,5,$row['stato'],1,1,'R',1); } $pdf->SetFont('helvetica','B',10); $pdf->SetFillColor(255,255,255); if ( $totale_ore != -1 ) { $pdf->Cell(158,5,'Totale Ore :','LTB',0,'R',1,'',1); $pdf->Cell(12,5,gaz_format_number($totale_ore),1,1,'R',1); } $pdf->setRiporti('');