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);
$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);
}
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");
