if ($row["SUSCRIBEPOLIZARC"] == "S") { $pdf->Ln(119); $pdf->Cell(32); $pdf->Cell(32, 0, $row["VALORRC"], 0, 0, "R"); $pdf->Ln(6); $pdf->Cell(32); $pdf->Cell(32, 0, $row["CUOTAINICIALRC"], 0, 0, "R"); $pdf->Ln(5.7); $pdf->Cell(32); $pdf->Cell(32, 0, $row["SUMAASEGURADARC"], 0, 0, "R"); } else { $pdf->Ln(96); $pdf->Rect($pdf->GetX(), $pdf->GetY(), 194, 44, "DF"); } if (($id == 328723) or ($id == 334890)) { // Harcodeado por ticket 41756.. $pdf->Rect(92, 110, 104, 8, "DF"); $pdf->Ln(-102); $pdf->SetFont("Arial", "", 8); $pdf->Cell(80); $pdf->Cell(0, 0, "Claúsula penal por incumplimientos de denuncias del empleador $2.000- (dos mil)", 0, 0); } if ($row["ILTEMPLEADOR"] != "S") $pdf->Rect(12, 123, 104, 4, "DF"); $pdf->Output($file, "F");
if ($fax_caller_id_number != '') { $pdf->Write(0.3, ' (' . format_phone($fax_caller_id_number) . ')'); } } else { if ($fax_caller_id_number != '') { $pdf->Write(0.3, format_phone($fax_caller_id_number)); } } if ($fax_page_count > 0) { $pdf->Text($x + 2.0, $y + 2.6, $fax_page_count . ' ' . $text['label-fax-page' . ($fax_page_count > 1 ? 's' : null)]); } if ($fax_subject != '') { $pdf->Text($x + 2.0, $y + 2.9, $fax_subject); } //message $pdf->Rect($x + 0.5, $y + 3.4, 7.5, 6.25, 'D'); if ($fax_message != '') { $pdf->SetFont($pdf_font, "", 12); $pdf->SetXY($x + 0.75, $y + 3.65); $pdf->MultiCell(7, 5.75, $fax_message, 0, 'L', false); } //footer if ($fax_footer != '') { $pdf->SetFont("helvetica", "", 8); $pdf->SetXY($x + 0.5, $y + 9.9); $pdf->MultiCell(7.5, 0.75, $fax_footer, 0, 'C', false); } // save cover pdf $pdf->Output($dir_fax_temp . '/' . $fax_instance_uuid . '_cover.pdf', "F"); // Display [I]nline, Save to [F]ile, [D]ownload //convert pdf to tif, add to array of pages, delete pdf
$pdf->Cell(14); $pdf->Cell(41, 0, $row2["TELEFONO"]); $pdf->Ln(4.4); $pdf->Cell(40); $pdf->Cell(16, 0, $row2["ESTABLECIMIENTOS"]); $pdf->Ln(2.4); $pdf->SetFont("Arial", "", 7); $pdf->SetDrawColor(255, 255, 255); $pdf->SetFillColor(0, 135, 196); switch ($row2["SA_NIVEL"]) { case 1: $pdf->Cell(66); $pdf->Rect($pdf->GetX(), $pdf->GetY(), 4.2, 3.4, "F"); $pdf->Ln(2); $pdf->Cell(66.6); $pdf->Cell(0, 0, "I"); $pdf->Ln(-2); break; case 2: $pdf->Cell(72.4); $pdf->Rect($pdf->GetX(), $pdf->GetY(), 4, 3.4, "F"); $pdf->Ln(2); $pdf->Cell(72.6); $pdf->Cell(0, 0, "II"); $pdf->Ln(-2); break; case 3: $pdf->Cell(78.6);
$pdf->SetFont('Helvetica'); $pdf->SetTextColor(0, 0, 0); $pdf->SetFontSize(10); $pdf->SetXY(17, 10.7); $pdf->Write(10, $row["FIRST_NAME"] . " " . $row["LAST_NAME"]); //Date $pdf->SetFontSize(10); $pdf->SetXY(115, 10.7); $pdf->Write(10, $row["TODAY_DATE"]); //Age $pdf->SetFontSize(10); $pdf->SetXY(168, 10.7); $pdf->Write(10, $row["AGE"]); //Gender if ('M' == $row["GENDER"]) { $pdf->Rect(195, 13, 4, 4); } elseif ('F' == $row["GENDER"]) { $pdf->Rect(200.5, 13, 3.5, 4); } //Dominant hand $pdf->SetFontSize(10); $pdf->SetXY(38, 14.9); $pdf->Write(10, $row["HAND"]); //Occupation $pdf->SetFontSize(10); $pdf->SetXY(114, 14.9); $pdf->Write(10, $row["OCCUPATION"]); //Leisure activities $pdf->SetFontSize(10); $pdf->SetXY(33, 19); $pdf->Write(10, $row["LEISURE"]);
$pdf->Ln(5.2); $pdf->Cell(8); $pdf->Cell(38, 0, $row["PROVINCIA"]); $pdf->Cell(36); $pdf->Cell(32, 0, $row["CPOSTALA"]); $pdf->Cell(16); $pdf->Cell(28, 0, $row["LOCALIDAD"]); $pdf->Cell(14); $pdf->Cell(26, 0, $row["TELEFONOS"]); $pdf->Ln(4); $pdf->SetFillColor(255, 255, 255); $pdf->Rect($pdf->GetX() + 128, $pdf->GetY(), 40, 4.6, "F"); $pdf->SetFillColor(0, 0, 0); $pdf->SetFont("Arial", "B", 10); $pdf->Ln(2.6); $pdf->Cell(128); $pdf->Cell(70, 0, " (".$row["DESCRIPCION"].")"); $pdf->Ln(3.6); $pdf->Rect($pdf->GetX() + 8, $pdf->GetY(), 80, 4, "F"); $pdf->SetTextColor(255, 255, 255); $pdf->SetFont("Arial", "B", 7); $pdf->Ln(2.4); $pdf->Cell(1); $pdf->Cell(114, 0, $row["HEADER"].": CONDICIONES A CUMPLIR", 0, 0, "C");
case "h": $pdf->SetDrawColor(196, 0, 0); $pdf->SetTextColor(196, 0, 0); break; case "i": $pdf->SetDrawColor(0, 0, 196); $pdf->SetTextColor(0, 0, 196); break; case "s": $pdf->SetDrawColor(0, 0, 196); $pdf->SetTextColor(0, 0, 196); break; } $pdf->SetLineWidth(0.8); $pdf->Rect($_REQUEST["x"], $_REQUEST["y"], (64 * 0.8289), (52 * 0.6745), "D"); $pdf->Rect($_REQUEST["x"] + 5, $_REQUEST["y"] + 9, (64 * 0.8289) - 10, (52 * 0.6745) - 18, "D"); $pdf->SetXY($_REQUEST["x"] + 0.4, $_REQUEST["y"] + 5); $pdf->Cell(0, 0, "Provincia ART S.A."); $pdf->SetXY($_REQUEST["x"] + 8, $_REQUEST["y"] + 18); $pdf->Cell(0, 0, $arrFecha[0]." ".strtoupper(substr(GetMonthName($arrFecha[1]), 0, 3))." ".$arrFecha[2]); $pdf->SetFont("Arial", "B", 18); $pdf->SetXY($_REQUEST["x"] + 3.4, $_REQUEST["y"] + 31); $pdf->Cell(46, 0, getLeyendaSello($_REQUEST["tipoSello"]), 0, 1, "C"); } if ($_REQUEST["accion"] == "g") $pdf->Output("Aviso de Obra.pdf", "D");
} if ($row2["DEBITO"] == "") { $pdf->Ln(0.1); $pdf->Cell(57); $pdf->Cell(18.6, 0, "", 1, 0, "C"); } $pdf->SetDrawColor(255, 255, 255); $pdf->Ln(3); $pdf->Cell(20); $pdf->Cell(24, 0, $row2["COD_PRODUCTOR"]); $pdf->Cell(4); $pdf->Cell(32, 0, $row2["CUITVENDEDOR"]); $pdf->Rect($pdf->GetX() + 2, $pdf->GetY() - 2, 12, 2.8, "DF"); $pdf->Ln(4); $pdf->Cell(20); $pdf->Cell(80, 0, $row2["NOM_PRODUCTOR"]); $pdf->Ln(-4); $pdf->Ln(10.4); $pdf->Cell(16); $pdf->Cell(36, 0, $row2["FECHAVIGENCIADESDE"]); $pdf->Cell(15); $pdf->Cell(30, 0, $row2["FECHAVIGENCIAHASTA"]); // DATOS DEL EMPLEADOR..
$i = 1; $netoAPagar = 0; while ($row = DBGetQuery($stmt)) { if (($i % MAX_REGISTROS_POR_HOJA) == 0) dibujarCabecera(); $pdf->Ln(4); $pdf->Cell(-5); $pdf->Cell(32, 0, $row["TIPO"], 0, 0, "C"); $pdf->Cell(20, 0, $row["FECHA"], 0, 0, "C"); $pdf->Cell(32, 0, $row["NUMERO"], 0, 0, "C"); $pdf->Cell(84, 0, $row["DESCRIPCION"], 0, 0, "C"); $pdf->Cell(32, 0, $row["MONTOFORMATEADO"], 0, 0, "R"); $netoAPagar+= str_replace(",", ".", $row["MONTO"]); $i++; } $pdf->SetY(272); $pdf->Ln(1); $pdf->Rect($pdf->GetX() - 5, $pdf->GetY(), 200, 0.2, "F"); $sql = "SELECT TO_CHAR(".$netoAPagar.", '$9,999,999,990.00') montoformateado FROM DUAL"; $pdf->SetFont("Arial", "B", 8); $pdf->Ln(2); $pdf->Cell(132); $pdf->Cell(20, 0, "Neto a Pagar:"); $pdf->Cell(43, 0, ValorSql($sql, 0, array()), 0, 0, "R"); $pdf->Output(); ?>
// // Imprimer la facture. // $facture_PDF = new FPDI(NULL, 'portrait', 15, 15, 10, 15, 'oui', 'non', NULL); $facture_PDF->setSourceFile(CHEMIN_DOSSIER_WEBSERVICES . 'sesamath_ent_convention_sacoche_etablissement_facture.pdf'); // ajouter une page ; y importer la page 1 ; l'utiliser comme support $facture_PDF->AddPage(); $tplIdx = $facture_PDF->importPage(1); $facture_PDF->useTemplate($tplIdx); // numéro $facture_PDF->SetFont('Arial', '', $taille_police); $facture_PDF->choisir_couleur_fond('gris_clair'); $facture_PDF->SetXY(130, 10); $facture_PDF->CellFit(50, $hauteur_ligne, To::pdf('Facture n°' . $f_convention_id), 0, 2, 'C', TRUE); // établissement $facture_PDF->Rect(120 - $marge_bordure, 20 - $marge_bordure, 70 + 2 * $marge_bordure, $hauteur_ligne * count($tab_etabl_coords) + 2 * $marge_bordure, 'D'); $facture_PDF->SetXY(120, 20); foreach ($tab_etabl_coords as $ligne) { $facture_PDF->CellFit(70, $hauteur_ligne, To::pdf($ligne), 0, 2, 'L', FALSE); } // date création $facture_PDF->SetXY(14, 99); $facture_PDF->CellFit(70, $hauteur_ligne, To::pdf('À Erôme, le ' . convert_date_mysql_to_french($DB_ROW['convention_creation']) . '.'), 0, 2, 'L', FALSE); // référence du connecteur $facture_PDF->SetFont('Arial', 'B', $taille_police); $facture_PDF->SetXY(17, 138); $facture_PDF->CellFit(100, $hauteur_ligne, To::pdf($connecteur_ref), 0, 2, 'C', FALSE); // période du connecteur $facture_PDF->SetFont('Arial', 'B', $taille_police); $facture_PDF->SetXY(17, 144); $facture_PDF->CellFit(100, $hauteur_ligne, To::pdf('du ' . convert_date_mysql_to_french($DB_ROW['convention_date_debut']) . ' au ' . convert_date_mysql_to_french($DB_ROW['convention_date_fin'])), 0, 2, 'C', FALSE);
} else { $pdf->Ln(2.6); $pdf->Cell(-4.8); $pdf->Cell(0, 0, "X"); $pdf->SetFont("Arial", "B", 8); $pdf->Ln(4); $pdf->Cell(-5); $pdf->Cell(48, 0, $row2["AR_NOMBRE"]); } // Tapo el N° de solicitud que está en el pdf original.. $pdf->SetDrawColor(255, 255, 255); $pdf->SetFillColor(255, 255, 255); $pdf->Rect(80, 19, 48, 4, "F"); $pdf->SetDrawColor(0, 0, 0); $pdf->SetFillColor(0, 0, 0); $pdf->SetFont("Arial", "", 10); $pdf->Ln(4.4); $pdf->Cell(190, 0, setNumeroSolicitud($row2["CUITSUSCRIPCION"], $row2["FO_FORMULARIO"]), 0, 0, "C"); $pdf->SetFont("Arial", "B", 8); $pdf->Ln(38.6); $pdf->Cell(24); $pdf->Cell(176, 0, $row2["SC_RAZONSOCIAL"]); $pdf->Ln(5); $pdf->Cell(10); $pdf->Cell(48, 0, ponerGuiones($row2["SC_CUIT"]));
$pdf->Cell(2); $pdf->Cell(16, 0, $row["FECHA"]); $pdf->Cell(0.4); $pdf->Cell(30, 0, $row["NUMERO"]); $pdf->Cell(1.4); $pdf->Cell(95, 0, $row["DESCRIPCION"]); $pdf->SetFont("Arial", "", 8); $pdf->Cell(2); $pdf->Cell(17, 0, trim($row["MONTOFORMAT"]), 0, 0, "R"); $pdf->SetFont("Arial", "", 7); $pdf->Ln(2); $pdf->Rect($pdf->GetX() - 4.6, $pdf->GetY(), 204, 0.2, "F"); $i++; if ($i > MAX_LINEAS_POR_HOJA) { $i = 1; } $netoAPagar+= str_replace(",", ".", $row["MONTO"]); } $sql = "SELECT TO_CHAR(".$netoAPagar.", '".DB_FORMATMONEY."') montoformateado FROM DUAL"; $pdf->SetFont("Arial", "B", 8); $pdf->Ln(4); $pdf->Cell(132); $pdf->Cell(20, 0, "Neto a Pagar:"); $pdf->Cell(44, 0, ValorSql($sql, 0, array()), 0, 0, "R");