$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('');
