protected function execute(InputInterface $input, OutputInterface $output) { $id = $input->getArgument('id'); $pdffile = $input->getArgument('pdf'); $em = $this->getContainer()->get('doctrine'); $tab = $this->csv($pdffile); $template = $em->getRepository('PrintBundle:Template')->find($id); $path = $this->getContainer()->get('kernel')->getRootDir() . '/../web/uploads/pdf/' . $template->getPdffile(); $width = $template->getWidth(); $height = $template->getHeight(); $orientation = $height > $width ? 'P' : 'L'; $custom_layout = array($width, $height); $i = 1; foreach ($tab as $key => $value) { $pdf = new \FPDI($orientation, 'mm', $custom_layout, true, 'UTF-8', false); $pdf->setPageOrientation($orientation); $pdf->SetMargins(PDF_MARGIN_LEFT, 40, PDF_MARGIN_RIGHT); $pdf->SetAutoPageBreak(true, 40); $pdf->setFontSubsetting(false); // add a page $pdf->AddPage($orientation); $pdf->setSourceFile($path); $_tplIdx = $pdf->importPage(1); $size = $pdf->useTemplate($_tplIdx, 0, 0, $width, true); foreach ($template->getChildactivity() as $opt) { $pdf->SetXY($opt->getX(), $opt->getY()); $pdf->SetFont($opt->getFont(), '', $opt->getFontsize() * 2); // echo $opt->getFontsize()."\n"; $pdf->Cell($opt->getWidth(), $opt->getHeight(), $value[$opt->getName()]); } //$pdf->Cell(0, $size['h'], 'TCPDF and FPDI'); // echo $template->getId(); $pdf->Output($this->getContainer()->get('kernel')->getRootDir() . '/../web/folder/pdf' . $template->getId() . "-{$i}.pdf", 'F'); $i++; } }
$pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/usuarios_registrados/agentes_comerciales/comisiones/templates/orden_pago.pdf"); define("MAX_REGISTROS_POR_HOJA", 52); dibujarCabecera($rowCabecera); $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";
if ($autoPrint) $pdf = new PDF_AutoPrint(); else $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/solicitud_afiliacion.pdf"); //Página 1.. $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "", 8); if (($row2["SA_MOTIVOALTA"] == "03") or ($row2["SA_MOTIVOALTA"] == "04") or ($row2["SA_MOTIVOALTA"] == "05")) { $pdf->Ln(6); $pdf->Cell(-0.4); $pdf->Cell(0, 0, "X"); $pdf->Ln(8.2); $pdf->Cell(1); } else { $pdf->Ln(10.2); $pdf->Cell(-0.4); $pdf->Cell(0, 0, "X"); $pdf->SetFont("Arial", "B", 8); $pdf->Ln(4); $pdf->Cell(1); $pdf->Cell(45, 0, $row2["AR_NOMBRE"]); }
$sql = "SELECT art.utiles.armar_cuit(sa_cuit) cuit, sa_nombre FROM asa_solicitudafiliacion WHERE sa_idformulario = :idformulario"; $stmt = DBExecSql($conn, $sql, $params); $row2 = DBGetQuery($stmt, 1, false); if ($autoPrint) $pdf = new PDF_AutoPrint(); else $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/nomina_personal_expuesto.pdf"); $pdf->AddPage("L"); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx, null, null, 0, 0, true); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(17); $pdf->Cell(14); $pdf->Cell(226, 0, $row2["SA_NOMBRE"]); $pdf->Cell(16); $pdf->Cell(0, 0, $row2["CUIT"]); if ($autoPrint) $pdf->AutoPrint(false); $pdf->Output(); ?>
$pdf = new FPDI("P", "mm", array(216, 320)); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/rgrl.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pagina = 1; dibujarPie($pagina); // Cabecera.. setNumeroSolicitud($row["CUIT"], $row["FO_FORMULARIO"]); $pdf->SetFont("Arial", "B", 8); $pdf->Ln(-7.2); $pdf->Cell(4); $pdf->Cell(0, 0, date("d/m/Y")); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(3); $pdf->Cell(192, 0, $row["TITULO"], 0, 0, "C"); $pdf->SetFont("Arial", "B", 8); $pdf->Ln(34.6); $pdf->Cell(26); $pdf->Cell(100, 0, $row["NOMBRE"]); $pdf->Cell(26); $pdf->Cell(0, 0, ponerGuiones($row["CUIT"])); $pdf->Ln(5.2);
/** * Save post metadata when a post is saved. * * @param int $post_id The post ID. * @param post $post The post object. * @param bool $update Whether this is an existing post being updated or not. */ public function save_ticket_data($post_id, $post, $update) { global $product; /* * In production code, $slug should be set only once in the plugin, * preferably as a class property, rather than in each function that needs it. */ $slug = 'product'; // If this isn't a 'product' post, don't update it. if ($slug != $post->post_type) { return; } $getprod = get_product($post_id); //If it's not a ticket return aswell if ($getprod->product_type != 'ticket') { return; } $getmeta = get_post_meta($post_id, '_downloadable_files', true); //Traverse the return array since we don't know the first key foreach ($getmeta as $key => $value) { $url = $value['file']; } $path = $_SERVER['DOCUMENT_ROOT'] . parse_url($url, PHP_URL_PATH); //To get the dir, use: dirname($path) require_once 'fpdf/fpdf.php'; require_once 'fpdi/fpdi.php'; //Get stuff to add to pdf :D $getmetaall = get_post_meta($post_id); $getcontent = get_post_meta($post_id, 'frs_woo_product_tabs', true); $i = 1; $pdf = new FPDI(); // $pdf->AddPage(); //Set the source PDF file //$pagecount = $pdf->setSourceFile($path); //Import the first page of the file //$tpl = $pdf->importPage($i); //Use this page as template //$pdf->useTemplate($tpl); #Print Hello World at the bottom of the page //Clear all $pdf->SetFillColor(255, 255, 255); $pdf->SetY(1); $pdf->SetFont('Arial', 'I', 19); $pdf->Cell(0, $pdf->h - 2, ' ', 0, 0, 'C', true); //Go to 1.5 cm from bottom $pdf->SetY(1); //Select Arial italic 8 $pdf->SetFont('Arial', 'I', 19); //Print centered cell with a text in it $pdf->Cell(0, 10, $post->post_title, 0, 0, 'C'); /* $pdf->SetY(10); $pdf->SetFont('Arial','I',16); $pdf->Cell(0, 10, gmdate("Y-m-d", $getmetaall["wpcf-event-start-date"][0]), 0, 0, 'C'); $pdf->SetY(20); $pdf->SetFont('Arial','I',16); $pdf->Cell(0, 10, 'Start time: ' . $getmetaall["wpcf-event-start-time"][0], 0, 0, 'C'); $pdf->SetY(27); $pdf->SetFont('Arial','I',16); $pdf->Cell(0, 10, 'End time: ' . $getmetaall["wpcf-event-end-time"][0], 0, 0, 'C'); $pdf->SetY(1); $pdf->Image('http://dancenergy.zenutech.com/production/wp-content/uploads/2014/06/Logo.png', 5, 0, 33.78); */ //Select Arial italic 8 $pdf->SetY(20); $pdf->SetFont('Arial', 'I', 15); $pdf->WriteHTML($getcontent[0]['ticket_content']); $pdf->Output($path, "F"); /* echo "<pre>"; var_dump( $getmetaall ); echo "</pre>"; */ return; }
public function view_sign_pce(){ require_once('./assets/fpdf17/fpdf.php'); require_once('./assets/fpdf17/fpdi.php'); $pce_id=$this->uri->segment(3,''); // init pce data $pce_dat=$this->m_pce->get_pce_by_id($pce_id); $project=$this->m_project->get_project_by_id($pce_dat->project_id); //init sign pic $ae_sign_user_dat=$this->m_user->get_user_by_login_name($project->project_cs); $ae_sign_filename="no"; if (isset($ae_sign_user_dat->sign_filename)) { $ae_sign_filename=$ae_sign_user_dat->sign_filename; } $client_service_sign_dat=$this->m_user->get_user_by_login_name($pce_dat->csd_sign); $client_service_sign_filename="no"; if (isset($client_service_sign_dat->sign_filename)) { $client_service_sign_filename=$client_service_sign_dat->sign_filename; } $finance_sign_dat=$this->m_user->get_user_by_login_name($pce_dat->fc_sign); $finance_sign_filename="no"; if (isset($finance_sign_dat->sign_filename)) { $finance_sign_filename=$finance_sign_dat->sign_filename; } // initiate FPDI $pdf = new FPDI(); // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวธรรมดา กำหนด ชื่อ เป็น angsana $pdf->AddFont('angsana','','angsa.php'); // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวหนา กำหนด ชื่อ เป็น angsana $pdf->AddFont('angsana','B','angsab.php'); // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวหนา กำหนด ชื่อ เป็น angsana $pdf->AddFont('angsana','I','angsai.php'); // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวหนา กำหนด ชื่อ เป็น angsana $pdf->AddFont('angsana','BI','angsaz.php'); // get the page count $pageCount = $pdf->setSourceFile("./media/real_pdf/".$pce_dat->filename); // iterate through all pages for ($pageNo = 1; $pageNo <= $pageCount; $pageNo++) { // import a page $templateId = $pdf->importPage($pageNo); // get the size of the imported page $size = $pdf->getTemplateSize($templateId); // create a page (landscape or portrait depending on the imported page size) if ($size['w'] > $size['h']) { $pdf->AddPage('L', array($size['w'], $size['h'])); } else { $pdf->AddPage('P', array($size['w'], $size['h'])); } // use the imported page $pdf->useTemplate($templateId); $pdf->SetTextColor(0,0,0); $pdf->SetFont('angsana','B',14); $pdf->SetXY(5, 5); //$pdf->Write(8, 'A complete document imported with FPDI'); $all_three_sign=0; if ($finance_sign_filename!="no"&&$finance_sign_filename!=""&&$finance_sign_filename!=null) { $pdf->Image("./media/sign_photo/".$finance_sign_filename,152,242,40,0); $c_time=$pce_dat->fc_sign_time; $pdf->SetXY(162,269); $pdf->Cell(30,5,iconv( 'UTF-8','cp874' , date("d",$c_time)." ".date("m",$c_time)." ".date("Y",$c_time)),0,0); $all_three_sign+=1; } if ($client_service_sign_filename!="no"&&$client_service_sign_filename!=""&&$client_service_sign_filename!=null) { $pdf->Image("./media/sign_photo/".$client_service_sign_filename,86,242,40,0); $c_time=$pce_dat->csd_sign_time; $pdf->SetXY(96,269.5); $pdf->Cell(30,5,iconv( 'UTF-8','cp874' , date("d",$c_time)." ".date("m",$c_time)." ".date("Y",$c_time)),0,0); $all_three_sign+=1; } if ($ae_sign_filename!="no"&&$ae_sign_filename!=""&&$ae_sign_filename!=null) { $pdf->Image("./media/sign_photo/".$ae_sign_filename,20,242,40,0); $c_time=$pce_dat->cs_sign_time; $pdf->SetXY(30,270); $pdf->Cell(30,5,iconv( 'UTF-8','cp874' , date("d",$c_time)." ".date("m",$c_time)." ".date("Y",$c_time)),0,0); $all_three_sign+=1; } //if ($all_three_sign==3) { $pdf->Image("./img/Client_Approval_Tag.png",110,204.2,35,0); //} //$pdf->Image("images/play.png",100,100,100,0); } $new_filename=$pce_dat->pce_no."_A.pdf"; // Output the new PDF //@unlink("./media/real_pdf/".$new_filename); $pdf->Output($new_filename,"I"); //redirect("media/real_pdf/".$new_filename); }
/** * Determine if the email should actually be sent and setup email merge variables * * @since 0.1 * @param int $order_id */ public function trigger($order_id) { global $woocommerce; // bail if no order ID is present if (!$order_id) { return; } // setup order object $this->object = new WC_Order($order_id); //check if is downloadbale if (!$this->object->has_downloadable_item()) { return; } // replace variables in the subject/headings $this->find[] = '{order_date}'; $this->replace[] = date_i18n(woocommerce_date_format(), strtotime($this->object->order_date)); $this->find[] = '{order_number}'; $this->replace[] = $this->object->get_order_number(); //To get the dir, use: dirname($path) require_once 'fpdf/fpdf.php'; require_once 'fpdi/fpdi.php'; if (!$this->is_enabled() || !$this->get_recipient()) { return; } $upload_dir = wp_upload_dir(); // Array of key => value pairs //cosntruct ticket temp dir $tickettemp = $upload_dir['basedir'] . '/tickets_temp'; if (!file_exists($tickettemp)) { mkdir($tickettemp, 0755, true); } $items = $this->object->get_items(); $varation_ids = array(); $metaorder = get_post_meta($this->object->id); $emaailid = $this->object->billing_email; $downloadlinks = array(); $i = 0; foreach ($items as $key => $value) { $x = 1; $getprod = $this->object->get_product_from_item($value); $getdownload = $this->object->get_item_downloads($value); if ($getprod->product_type != 'ticket') { break; } if (empty($getdownload)) { break; } $qty = intval($value['qty']); while ($x <= $qty) { $x++; foreach ($getdownload as $keysub => $valuesub) { $downlink = $valuesub['file']; } $path = $_SERVER['DOCUMENT_ROOT'] . parse_url($downlink, PHP_URL_PATH); $pdfout = $tickettemp . '/ticket_' . $this->object->id . '' . $value['product_id'] . '' . $x . '.pdf'; $downloadlinks[$i] = $pdfout; $pagenum = 1; $pdf = new FPDI(); $pdf->AddPage(); //Set the source PDF file $pagecount = $pdf->setSourceFile($path); //Import the first page of the file $tpl = $pdf->importPage($pagenum); //Use this page as template $pdf->useTemplate($tpl); $getfooterY = $pdf->h - 35; //Select Arial italic 8 $pdf->SetY($getfooterY); $pdf->SetFont('Arial', 'I', 10); $pdf->Cell(0, 10, 'Ticket id: ' . $this->object->id . '' . $value['product_id'] . '' . $x, 0, 0, 'C'); $pdf->Output($pdfout, "F"); $i++; } } /* $email_class = new WC_Email(); remove_action( 'woocommerce_after_resend_order_email', array( $email_class->emails['WC_Email_Customer_Completed_Order'], 'trigger' ) ); remove_action( 'woocommerce_order_status_completed_notification', array( $email_class->emails['WC_Email_Customer_Completed_Order'], 'trigger' ) ); echo "<pre>"; var_dump( $this->emails ); echo "</pre>"; var_dump( $downloadlinks ); var_dump( $items ); var_dump( $emaailid); var_dump( $this->object ); */ // woohoo, send the email! $this->send($this->get_recipient() . ', ' . $this->object->billing_email, $this->get_subject(), $this->get_content(), $this->get_headers(), $downloadlinks); //Delete the temp tickets foreach ($downloadlinks as $key => $value) { chmod($value, 0777); if (file_exists($value)) { unlink($value); } } //die(); }
function ten_tardiness_second($second_offenders = array()) { $this->load->library('fpdf'); define('FPDF_FONTPATH', $this->config->item('fonts_path')); $this->load->library('fpdi'); // initiate FPDI $pdf = new FPDI('P', 'mm', 'Legal'); $pdf->SetLeftMargin(20); $pdf->SetRightMargin(15); // add a page $pdf->AddPage(); // set the sourcefile $pdf->setSourceFile('dtr/template/notice2nd.pdf'); // select the first page $tplIdx = $pdf->importPage(1); // use the page we imported $pdf->useTemplate($tplIdx); $offices = Input::get('offices'); $office_id = $offices[0]; $m1 = 'Jul'; $m2 = 'Aug'; $m3 = 'Sep'; $m4 = 'Oct'; $m5 = 'Nov'; $m6 = 'Dec'; $mo1 = '07'; $mo2 = '08'; $mo3 = '09'; $mo4 = '10'; $mo5 = '11'; $mo6 = '12'; $pdf->SetFont('Arial', '', '12'); $pdf->SetXY(155, 50); $pdf->Write(0, date('F d, Y')); $pdf->SetX(35); $pdf->SetFont('Arial', 'B', ''); $pdf->Cell(0, 6, "HON. EDWARD S. HAGEDORN ", '', 1, 'L', FALSE); $pdf->SetFont('Arial', '', ''); $pdf->SetX(35); $pdf->Cell(0, 6, "City Mayor", '', 1, 'L', FALSE); $pdf->SetX(35); $pdf->Cell(0, 6, "Puerto Princesa City", '', 1, 'L', FALSE); $pdf->Cell(0, 6, "", '', 1, 'C', FALSE); $pdf->Cell(0, 6, "Thru: ATTY. SHIRLEY R. DAGANTA", '', 1, 'C', FALSE); $pdf->Cell(0, 6, "CG Assistant Dept. Head II", '', 1, 'C', FALSE); $pdf->Cell(0, 6, "Assistant City Legal Officer II", '', 1, 'C', FALSE); $pdf->Ln(12); $pdf->SetX(35); $pdf->SetFont('Arial', 'B', ''); $pdf->Write(0, 'Madam:'); $pdf->SetFont('Arial', '', ''); $pdf->Ln(6); $pdf->SetX(35); $pdf->MultiCell(0, 6, " Please be informed that despite the first notice issued to him/her as per records in this office, it has been observed that the he/she has continuously incurred the following tardiness and undertime, viz:", 0, 'L', false); //$pdf->SetX(35); //$pdf->Cell(0,6," $number of your employees has incurred the following, viz:",'',0,'L',false); $pdf->SetFont('Arial', 'BI', 10); $pdf->Ln(2); $pdf->SetFillColor(210, 210, 210); //$pdf->SetX(20); //header $pdf->Cell(50, 8, "Name", 'RLTB', 0, 'C', 1); $pdf->Cell(20, 4, $m1, '1', 0, 'C', 1); $pdf->Cell(20, 4, $m2, '1', 0, 'C', 1); $pdf->Cell(20, 4, $m3, '1', 0, 'C', 1); $pdf->Cell(20, 4, $m4, '1', 0, 'C', 1); $pdf->Cell(20, 4, $m5, '1', 0, 'C', 1); $pdf->Cell(20, 4, $m6, '1', 1, 'C', 1); $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(240, 240, 240); $pdf->Cell(50, 4, "", 'RLB', 0, 'C', false); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 0, 'C', 1); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 0, 'C', 1); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 0, 'C', 1); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 0, 'C', 1); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 0, 'C', 1); $pdf->Cell(10, 4, "Tardy", '1', 0, 'C', 1); $pdf->Cell(10, 4, "UT", '1', 1, 'C', 1); $pdf->SetFillColor(215, 255, 215); $year1 = Input::get('year'); $tardis = $second_offenders; if (is_array($tardis)) { foreach ($tardis as $tardi) { $name = $this->Employee->get_employee_info($tardi, $field = ''); $late1 = $this->Tardiness->count_late($name['employee_id'], $mo1, $year1, 1, 3); $late2 = $this->Tardiness->count_late($name['employee_id'], $mo2, $year1, 1, 3); $late3 = $this->Tardiness->count_late($name['employee_id'], $mo3, $year1, 1, 3); $late4 = $this->Tardiness->count_late($name['employee_id'], $mo4, $year1, 1, 3); $late5 = $this->Tardiness->count_late($name['employee_id'], $mo5, $year1, 1, 3); $late6 = $this->Tardiness->count_late($name['employee_id'], $mo6, $year1, 1, 3); $under_time1 = $this->Tardiness->count_late($name['employee_id'], $mo1, $year1, 2, 4); $under_time2 = $this->Tardiness->count_late($name['employee_id'], $mo2, $year1, 2, 4); $under_time3 = $this->Tardiness->count_late($name['employee_id'], $mo3, $year1, 2, 4); $under_time4 = $this->Tardiness->count_late($name['employee_id'], $mo4, $year1, 2, 4); $under_time5 = $this->Tardiness->count_late($name['employee_id'], $mo5, $year1, 2, 4); $under_time6 = $this->Tardiness->count_late($name['employee_id'], $mo6, $year1, 2, 4); $late1['tardi_count'] = $this->Tardiness->is_tardy_zero($late1['tardi_count']); $late2['tardi_count'] = $this->Tardiness->is_tardy_zero($late2['tardi_count']); $late3['tardi_count'] = $this->Tardiness->is_tardy_zero($late3['tardi_count']); $late4['tardi_count'] = $this->Tardiness->is_tardy_zero($late4['tardi_count']); $late5['tardi_count'] = $this->Tardiness->is_tardy_zero($late5['tardi_count']); $late6['tardi_count'] = $this->Tardiness->is_tardy_zero($late6['tardi_count']); $under_time1['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time1['tardi_count']); $under_time2['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time2['tardi_count']); $under_time3['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time3['tardi_count']); $under_time4['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time4['tardi_count']); $under_time5['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time5['tardi_count']); $under_time6['tardi_count'] = $this->Tardiness->is_tardy_zero($under_time6['tardi_count']); //start employee tardy $pdf->Cell(50, 4, ucwords(strtolower(utf8_decode($name['fname'] . ' ' . $name['mname'] . ' ' . $name['lname']))), 'RLTB', 0, 'L', false); $pdf->Cell(10, 4, $late1['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time1['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $late2['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time2['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $late3['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time3['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $late4['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time4['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $late5['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time5['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $late6['tardi_count'], '1', 0, 'C', FALSE); $pdf->Cell(10, 4, $under_time6['tardi_count'], '1', 1, 'C', FALSE); } } $pdf->Cell(50, 4, "", 'RLTB', 0, 'L', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 0, 'C', FALSE); $pdf->Cell(10, 4, "", '1', 1, 'C', FALSE); // line break $pdf->Ln(5); $pdf->SetFont('Arial', '', '12'); $pdf->SetX(35); $pdf->MultiCell(0, 6, " Section 8, Rule XVII of the Omnibus Rules Implementing Book V of Executive Order No. 292, states that: \n\t\t\t\t 'Officers and employees who have incurred tardiness and undertime, regardless of the number of minutes per day, ten (10) times a month for at least two (2) consecutive months during the year or for at least two (2) months in a semester shall be subject to disciplinary action.'\n\t\t\t\t Violation of the said rule carries the following penalties:\n\t\t\n\t\t\t\t 1.\tFirst Offense - Reprimand;\n\t\t\t\t 2.\tSecond Offense - Suspension for one (1) day to thirty (30) days; and\n\t\t\t\t 3.\tThird Offense - Dismissal.\n\t\t\n\t\t\t\t For your appropriate action.\n\t\t", '', 1, 'L', false); $pdf->Cell(0, 6, " Very truly yours, ", 0, 'R', FALSE); $pdf->Cell(0, 6, " ", '', 1, 'R', FALSE); $pdf->Cell(0, 6, " ", '', 1, 'R', FALSE); $pdf->SetFont('Arial', 'B', ''); $pdf->Cell(0, 6, " FELIMON R. SABAS ", '', 1, 'R', FALSE); $pdf->SetFont('Arial', '', ''); $pdf->Cell(0, 6, " CG Department Head II ", '', 1, 'R', FALSE); $pdf->Cell(0, 6, " (City Personnel Officer) ", '', 1, 'R', FALSE); $pdf->MultiCell(0, 6, "\n\t\tNOTED:\n\t\t\n\t\tBY AUTHORITY OF THE CITY MAYOR:", 0, 'L', FALSE); $pdf->SetFont('Arial', 'B', ''); $pdf->Cell(0, 6, " ATTY. AGUSTIN M. ROCAMORA", '', 1, 'L', FALSE); $pdf->SetFont('Arial', '', ''); $pdf->Cell(0, 6, " City Administrator II", '', 1, 'L', FALSE); header('Cache-Control: maxage=3600'); //Adjust maxage appropriately header('Pragma: public'); //If the parameter is D = download F = save as file $pdf->Output('dtr/reports/ten_tardiness_second.pdf', 'F'); }
function cto_apps($id = '') { $c = CompensatoryTimeoff::find($id); $name = $this->Employee->get_employee_info($c->employee_id); $office_name = $this->Office->get_office_name($name['office_id']); $this->load->library('fpdf'); define('FPDF_FONTPATH', $this->config->item('fonts_path')); $this->load->library('fpdi'); $pdf = new FPDI('P', 'mm', 'Legal'); // add a page $pdf->AddPage(); // set the sourcefile $pdf->setSourceFile('dtr/template/app_for_offset.pdf'); // select the first page $tplIdx = $pdf->importPage(1); // use the page we imported $pdf->useTemplate($tplIdx); // set font, font style, font size. $pdf->SetFont('Arial', 'B', 12); // set initial placement $pdf->SetXY(158, 10.5); $pdf->Write(0, 'Tracking no: ' . $id); $pdf->Ln(9); $pdf->SetX(158); $pdf->Ln(20); // go to 25 X (indent) $pdf->SetX(12); $this->Office->fields = array('office_code'); $office = $this->Office->get_office_info($name['office_id']); // write office $pdf->SetFont('Arial', 'B', 10); $pdf->Write(0, $office['office_name']); $pdf->SetFont('Arial', 'B', 12); //lname $pdf->SetX(99); $pdf->Write(0, $name['lname']); //fname $pdf->SetX(145); $pdf->Write(0, $name['fname']); //mname $pdf->SetX(187); $pdf->Write(0, $name['mname'][0] . '.'); $pdf->Ln(10); //date of file $pdf->SetX(20); $pdf->Write(0, $c->date_file); //position $pdf->SetFont('Arial', 'B', 10); $pdf->SetX(63); $pdf->Write(0, $name['position']); $pdf->SetFont('Arial', 'B', 12); // We need to check what salary grade the office use if ($office['salary_grade_type'] == 'hospital') { $this->Salary_grade->salary_grade_type = 'hospital'; } //monthly salary $pdf->SetX(140); $pdf->Write(0, 'P ' . number_format($this->Salary_grade->get_monthly_salary($name['salary_grade'], $name['step']), 2)); $days = 'day'; if ($c->days > 1) { $days = 'days'; } $pdf->Ln(13); $pdf->SetX(30); $pdf->Write(0, $c->days . ' ' . $days); $pdf->SetX(140); //$pdf->Write(0, 'daily rate here'); $pdf->Ln(13); $pdf->SetX(50); $pdf->Write(0, $this->Helps->get_month_name($c->month) . ' ' . $c->dates . ', ' . $c->year); $cto_balances_as_of = date("F d, Y", strtotime($c->date_file . "-1 day")); $pdf->SetXY(30, 106); $pdf->Write(0, $cto_balances_as_of); // Compute balances // (balance + earn) - spent $cto = CompensatoryTimeoff::getBalance($c->employee_id); //$balance = $cto->days; $balance = $cto; $cto = CompensatoryTimeoff::getEarnedSpent($c->employee_id); //$earn = $cto->days; $earn = $cto; $cto = CompensatoryTimeoff::getEarnedSpent($c->employee_id, 'spent'); //$spent = $cto->days; $spent = $cto; $total_balance = $balance + $earn - $spent; $pdf->SetXY(35, 116); $pdf->Write(0, $total_balance); $pdf->SetX(87); $pdf->Write(0, ''); // hours here // Get office head $office = $this->Office->get_office_info($name['office_id']); // If detailed if ($name['detailed_office_id'] != 0) { $detailed_office = $this->Office->get_office_info($name['detailed_office_id']); $office['office_head'] = $detailed_office['office_head']; $office['position'] = $detailed_office['position']; } // If Employee is Department head $o = new Office_m(); $o->get_by_employee_id($c->employee_id); if ($o->exists()) { $office['office_head'] = 'CARMENCITA O. REYES'; $office['position'] = 'Governor'; } // We need to work out for this as exception if ($c->employee_id == '61') { $office['office_head'] = 'ANTONIO L. UY, JR. M.D.'; $office['position'] = 'Vice Governor'; } $pdf->Ln(6); $pdf->SetX(120); $pdf->Cell(73, 4, strtoupper($office['office_head']), '0', 0, 'C', FALSE); $pdf->Ln(5); $pdf->SetFont('Arial', '', 10); $pdf->SetX(120); $pdf->Cell(73, 4, $office['position'], '0', 0, 'C', FALSE); $pdf->SetFont('Arial', 'B', 12); // Statement of CTO signatory $statement_certified = Setting::getField('cto_certification'); $statement_certified_position = Setting::getField('cto_certification_position'); $pdf->Ln(5); $pdf->SetX(22); $pdf->Cell(73, 4, strtoupper($statement_certified), '0', 0, 'C', FALSE); $pdf->Ln(5); $pdf->SetFont('Arial', '', 10); $pdf->SetX(22); $pdf->Cell(73, 4, $statement_certified_position, '0', 0, 'C', FALSE); $pdf->SetFont('Arial', 'B', 12); // ====================Second Form ============= $pdf->Ln(44); $pdf->SetX(12); // write office $pdf->SetFont('Arial', 'B', 10); $pdf->Write(0, $office['office_name']); $pdf->SetFont('Arial', 'B', 12); //lname $pdf->SetX(99); $pdf->Write(0, $name['lname']); //fname $pdf->SetX(145); $pdf->Write(0, $name['fname']); //mname $pdf->SetX(187); $pdf->Write(0, $name['mname'][0] . '.'); $pdf->Ln(10); //date of file $pdf->SetX(20); $pdf->Write(0, $c->date_file); //position $pdf->SetFont('Arial', 'B', 10); $pdf->SetX(63); $pdf->Write(0, $name['position']); $pdf->SetFont('Arial', 'B', 12); //monthly salary $pdf->SetX(140); $pdf->Write(0, 'P ' . number_format($this->Salary_grade->get_monthly_salary($name['salary_grade'], $name['step']), 2)); $pdf->Ln(13); $pdf->SetX(30); $pdf->Write(0, $c->days . ' ' . $days); $pdf->SetX(140); //$pdf->Write(0, 'daily rate here'); $pdf->Ln(13); $pdf->SetX(50); $pdf->Write(0, $this->Helps->get_month_name($c->month) . ' ' . $c->dates . ', ' . $c->year); $cto_balances_as_of = date("F d, Y", strtotime($c->date_file . "-1 day")); $pdf->Ln(30); $pdf->SetX(30); //$pdf->Write(0, $cto_balances_as_of); $pdf->Ln(10); $pdf->SetX(35); //$pdf->Write(0, $total_balance); $pdf->Ln(6); $pdf->SetX(120); $pdf->Cell(73, 4, strtoupper($office['office_head']), '0', 0, 'C', FALSE); $pdf->Ln(5); $pdf->SetFont('Arial', '', 10); $pdf->SetX(120); $pdf->Cell(73, 4, $office['position'], '0', 0, 'C', FALSE); $pdf->SetFont('Arial', 'B', 12); $pdf->Ln(5); $pdf->SetX(22); $pdf->Cell(73, 4, strtoupper($statement_certified), '0', 0, 'C', FALSE); $pdf->Ln(5); $pdf->SetFont('Arial', '', 10); $pdf->SetX(22); $pdf->Cell(73, 4, $statement_certified_position, '0', 0, 'C', FALSE); $pdf->SetFont('Arial', 'B', 12); header('Cache-Control: maxage=3600'); //Adjust maxage appropriately header('Pragma: public'); $pdf->Output('dtr/reports/cto-apps-' . intval($c->employee_id) . '.pdf', 'I'); //return Redirect::to('dtr/reports/leave-apps-'.$rows['employee_id'].'.pdf', 'refresh'); }
function write_instruction($rec_ind, $q, $data) { // $ind = recipe index, $q = quote array, $data = recipe data array // Dynamic Data $bul = html_entity_decode("•", ENT_HTML401, "cp1252"); $deg = html_entity_decode("°", ENT_HTML401, "cp1252"); $recipe = $data[$rec_ind][0]; $style = $data[$rec_ind][1]; $og = $data[$rec_ind][2]; $fg = $data[$rec_ind][3]; $abv = $data[$rec_ind][4] . "%"; //$hop1 = $bul . " " . $data[$rec_ind][5]; if (empty($data[$rec_ind][5])) { $hop1 = ""; } else { $hop1 = $bul . " " . $data[$rec_ind][5]; } if (empty($data[$rec_ind][6])) { $hop2 = ""; } else { $hop2 = $bul . " " . $data[$rec_ind][6]; } if (empty($data[$rec_ind][7])) { $hop3 = ""; } else { $hop3 = $bul . " " . $data[$rec_ind][7]; } if (empty($data[$rec_ind][8])) { $hop4 = ""; } else { $hop4 = $bul . " " . $data[$rec_ind][8]; } if (empty($data[$rec_ind][9])) { $hop5 = ""; } else { $hop5 = $bul . " " . $data[$rec_ind][9]; } if (empty($data[$rec_ind][10])) { $hop6 = ""; } else { $hop6 = $bul . " " . $data[$rec_ind][10]; } if (empty($data[$rec_ind][11])) { $sp_inst = "No special instructions needed. Instead, we have included a quote about beer: \n" . $q[rand(0, 12)]; } else { $sp_inst = $data[$rec_ind][11]; } if (empty($data[$rec_ind][12])) { $ing1 = ""; } else { $ing1 = $bul . " " . $data[$rec_ind][12]; } if (empty($data[$rec_ind][13])) { $ing2 = ""; } else { $ing2 = $bul . " " . $data[$rec_ind][13]; } if (empty($data[$rec_ind][14])) { $ing3 = ""; } else { $ing3 = $bul . " " . $data[$rec_ind][14]; } if (empty($data[$rec_ind][15])) { $ing4 = ""; } else { $ing4 = $bul . " " . $data[$rec_ind][15]; } if (empty($data[$rec_ind][16])) { $ing5 = ""; } else { $ing5 = $bul . " " . $data[$rec_ind][16]; } if (empty($data[$rec_ind][17])) { $ing6 = ""; } else { $ing6 = $bul . " " . $data[$rec_ind][17]; } if (empty($data[$rec_ind][18])) { $ing7 = ""; } else { $ing7 = $bul . " " . $data[$rec_ind][18]; } if (empty($data[$rec_ind][19])) { $ing8 = ""; } else { $ing8 = $bul . " " . $data[$rec_ind][19]; } if (empty($data[$rec_ind][20])) { $ing9 = ""; } else { $ing9 = $bul . " " . $data[$rec_ind][20]; } if (empty($data[$rec_ind][21])) { $ing10 = ""; } else { $ing10 = $bul . " " . $data[$rec_ind][21]; } if (empty($data[$rec_ind][22])) { $ing11 = ""; } else { $ing11 = $bul . " " . $data[$rec_ind][22]; } if (empty($data[$rec_ind][23])) { $ing12 = ""; } else { $ing12 = $bul . " " . $data[$rec_ind][23]; } if (empty($data[$rec_ind][24])) { $ing13 = ""; } else { $ing13 = $bul . " " . $data[$rec_ind][24]; } if (empty($data[$rec_ind][25])) { $ing14 = ""; } else { $ing14 = $bul . " " . $data[$rec_ind][25]; } if (empty($data[$rec_ind][26])) { $ing15 = ""; } else { $ing15 = $bul . " " . $data[$rec_ind][26]; } if (empty($data[$rec_ind][27])) { $ing16 = ""; } else { $ing16 = $bul . " " . $data[$rec_ind][27]; } if (empty($data[$rec_ind][28])) { $ing17 = ""; } else { $ing17 = $bul . " " . $data[$rec_ind][28]; } if (empty($data[$rec_ind][29])) { $ing18 = ""; } else { $ing18 = $bul . " " . $data[$rec_ind][29]; } // Initiate FPDI & FPDF $pdf = new FPDI(); $pdf->setSourceFile("extract_template.pdf"); // Create page 1 & Read Template Page 1 $pdf->AddPage('P', 'Letter'); $tmp = $pdf->importPage(1); $pdf->useTemplate($tmp, 0, 0); // Declare Fonts $pdf->AddFont('Kenyancoffee', '', 'Kenyancoffeerg.php'); $pdf->AddFont('Roboto', '', 'Roboto-Regular.php'); $pdf->AddFont('Roboto', 'L', 'Roboto-Light.php'); $pdf->AddFont('Roboto', 'B', 'Roboto-Bold.php'); // Write Dynamic Data - Header $pdf->SetFont('Kenyancoffee', '', 23); $pdf->SetTextColor(229, 80, 84); $pdf->SetXY(57.3, 19); $pdf->Cell(0, 0, $recipe); $pdf->SetFont('Roboto', 'L', 9.9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(57.3, 25.5); $pdf->Cell(0, 0, $style); $pdf->SetFont('Roboto', 'L', 9.9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(65.2, 36.2); $pdf->Cell(0, 0, $og); $pdf->SetFont('Roboto', 'L', 9.9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(85.2, 36.2); $pdf->Cell(0, 0, $fg); $pdf->SetFont('Roboto', 'L', 9.9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(108.5, 36.2); $pdf->Cell(0, 0, $abv); // Write Dynamic Data - Ingredients $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 156.5); $pdf->Cell(0, 0, $ing1); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 161.5); $pdf->Cell(0, 0, $ing2); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 166.5); $pdf->Cell(0, 0, $ing3); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 171.5); $pdf->Cell(0, 0, $ing4); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 176.5); $pdf->Cell(0, 0, $ing5); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 181.5); $pdf->Cell(0, 0, $ing6); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 186.5); $pdf->Cell(0, 0, $ing7); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 191.5); $pdf->Cell(0, 0, $ing8); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 196.5); $pdf->Cell(0, 0, $ing9); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 201.5); $pdf->Cell(0, 0, $ing10); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 206.5); $pdf->Cell(0, 0, $ing11); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 211.5); $pdf->Cell(0, 0, $ing12); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 216.5); $pdf->Cell(0, 0, $ing13); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 221.5); $pdf->Cell(0, 0, $ing14); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 226.5); $pdf->Cell(0, 0, $ing15); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 231.5); $pdf->Cell(0, 0, $ing16); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 236.5); $pdf->Cell(0, 0, $ing17); $pdf->SetFont('Roboto', 'B', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(5.3, 241.5); $pdf->Cell(0, 0, $ing18); // Write Dynamic Data - Hop Schedule $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 171); $pdf->Cell(0, 0, $hop1); $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 174.2); $pdf->Cell(0, 0, $hop2); $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 177.4); $pdf->Cell(0, 0, $hop3); $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 180.6); $pdf->Cell(0, 0, $hop4); $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 183.8); $pdf->Cell(0, 0, $hop5); $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(114, 187); $pdf->Cell(0, 0, $hop6); // Create page 2 & Read Template Page 2 $pdf->AddPage('P', 'Letter'); $tmp = $pdf->importPage(2); $pdf->useTemplate($tmp, 0, 0); // Write Dynamic Data - Special Instructions $pdf->SetFont('Roboto', '', 7.5); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(11, 13); $pdf->MultiCell(165, 3, utf8_decode($sp_inst)); $shortname = str_replace(' ', '', $recipe); $filename = "C:/Users/tyler/Google Drive/MonsterBrew/Product/Recipe Kits/Instructions/Instructions - Extract/EX_INS_" . $shortname . ".pdf"; $pdf->Output($filename, 'F'); }
<?php if (@$_POST['id_certificado']) { global $wpdb; $certificado = $wpdb->get_row($wpdb->prepare("SELECT c.id as id, c.nome as nome, e.id as evento_id FROM participantes c INNER JOIN " . "evento e ON (e.id = c.evento_id) WHERE c.id=%d", $_POST['id_certificado'])); require get_stylesheet_directory() . '/inc/fpdf/fpdf.php'; require get_stylesheet_directory() . '/inc/fpdf/fpdi.php'; $pdf = new FPDI('L', 'mm', "A4"); $pdf->setSourceFile(get_stylesheet_directory() . "/certificados/evento_" . $certificado->evento_id . ".pdf"); $pdf->AddPage('L'); $tplidx = $pdf->importPage(1, '/MediaBox'); $pdf->useTemplate($tplidx, 0, 0, 297, 210, true); $pdf->SetXY(10, 85); //Informamos a fonte, seu estilo e seu tamanho $pdf->SetFont('Arial', '', 28); $pdf->Cell(0, 8, iconv("UTF-8", "CP1252", $certificado->nome), 0, 1, 'C'); $arquivo_certificado = preg_replace('/[^A-Za-z0-9\\-]/', '', str_replace(" ", "_", $certificado->nome)) . ".pdf"; $pdf->Output($arquivo_certificado, 'D'); $wpdb->query($wpdb->prepare("UPDATE participantes SET data_geracao = CURRENT_TIMESTAMP WHERE id=%d", $_POST['id_certificado'])); } get_header(); ?> <section> <div class="container mt-lg mb-lg"> <?php if (have_posts()) { ?> <?php while (have_posts()) { the_post();
else $pdf = new FPDI(); if ($msgSqlVacio == "") { $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/responsabilidad_civil.pdf"); $pdf->SetDrawColor(255, 255, 255); $pdf->SetFillColor(255, 255, 255); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(30); $pdf->Cell(168); $pdf->Cell(0, 0, "PCI".$row2["IDFORMULARIO"]); $pdf->Ln(5); $pdf->SetDrawColor(0, 0, 0); if ($row2["BOLETA"] == "") { $pdf->Cell(46); $pdf->Cell(7, 0, "", 1, 0, "C"); } if ($row2["DEBITO"] == "") { $pdf->Ln(0.1); $pdf->Cell(57); $pdf->Cell(18.6, 0, "", 1, 0, "C"); } $pdf->SetDrawColor(255, 255, 255);
$pdf = new FPDI(); $pdf->setSourceFile(DATA_AVISO_OBRA_PATH.$_REQUEST["filename"].".".$_REQUEST["extension"]); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $_REQUEST["x"] = $_REQUEST["x"] * 0.686; $_REQUEST["y"] = $_REQUEST["y"] * 0.728; if ($_REQUEST["tipoSello"] == "n") { $pdf->SetFont("Arial", "B", 14); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY($_REQUEST["x"] + 8, $_REQUEST["y"] + 18); $pdf->Cell(0, 0, "NO CORRESPONDE PRESENTACIÓN"); $pdf->SetXY($_REQUEST["x"] + 11, $_REQUEST["y"] + 24); $pdf->Cell(0, 0, "POR ACTIVIDAD DESARROLLADA"); } else { $pdf->SetFont("Arial", "B", 16); switch ($_REQUEST["tipoSello"]) { case "e": $pdf->SetDrawColor(0, 0, 196); $pdf->SetTextColor(0, 0, 196); break; case "h": $pdf->SetDrawColor(196, 0, 0); $pdf->SetTextColor(196, 0, 0); break; case "i":
function watermark_and_sent(stdClass $issuedcert) { global $CFG, $USER, $COURSE, $DB, $PAGE; if ($issuedcert->haschange) { //This issue have a haschange flag, try to reissue if (empty($issuedcert->timedeleted)) { require_once $CFG->dirroot . '/mod/simplecertificate/locallib.php'; try { // Try to get cm $cm = get_coursemodule_from_instance('simplecertificate', $issuedcert->certificateid, 0, false, MUST_EXIST); $context = context_module::instance($cm->id); //Must set a page context to issue .... $PAGE->set_context($context); $simplecertificate = new simplecertificate($context, null, null); $file = $simplecertificate->get_issue_file($issuedcert); } catch (moodle_exception $e) { // Only debug, no errors debugging($e->getMessage(), DEBUG_DEVELOPER, $e->getTrace()); } } else { //Have haschange and timedeleted, somehting wrong, it will be impossible to reissue //add wraning debugging("issued certificate [{$issuedcert->id}], have haschange and timedeleted"); } $issuedcert->haschange = 0; $DB->update_record('simplecertificate_issues', $issuedcert); } if (empty($file)) { $fs = get_file_storage(); if (!$fs->file_exists_by_hash($issuedcert->pathnamehash)) { print_error(get_string('filenotfound', 'simplecertificate', '')); } $file = $fs->get_file_by_hash($issuedcert->pathnamehash); } $canmanage = false; if (!empty($COURSE)) { $canmanage = has_capability('mod/simplecertificate:manage', context_course::instance($COURSE->id)); } if ($canmanage || !empty($USER) && $USER->id == $issuedcert->userid) { send_stored_file($file, 0, 0, true); } else { require_once $CFG->libdir . '/pdflib.php'; require_once $CFG->dirroot . '/mod/simplecertificate/lib/fpdi/fpdi.php'; // copy to a tmp file $tmpfile = $file->copy_content_to_temp(); // TCPF doesn't import files yet, so i must use FPDI $pdf = new FPDI(); $pageCount = $pdf->setSourceFile($tmpfile); for ($pageNo = 1; $pageNo <= $pageCount; $pageNo++) { // import a page $templateId = $pdf->importPage($pageNo); // get the size of the imported page $size = $pdf->getTemplateSize($templateId); // create a page (landscape or portrait depending on the imported page size) if ($size['w'] > $size['h']) { $pdf->AddPage('L', array($size['w'], $size['h'])); // Font size 1/3 Height if it landscape $fontsize = $size['h'] / 3; } else { $pdf->AddPage('P', array($size['w'], $size['h'])); // Font size 1/3 Width if it portrait $fontsize = $size['w'] / 3; } // use the imported page $pdf->useTemplate($templateId); // Calculating the rotation angle $rotAngle = atan($size['h'] / $size['w']) * 180 / pi(); // Find the middle of the page to use as a pivot at rotation. $mX = $size['w'] / 2; $mY = $size['h'] / 2; // Set the transparency of the text to really light $pdf->SetAlpha(0.25); $pdf->StartTransform(); $pdf->Rotate($rotAngle, $mX, $mY); $pdf->SetFont("freesans", "B", $fontsize); $pdf->SetXY(0, $mY); $boder_style = array('LTRB' => array('width' => 2, 'dash' => $fontsize / 5, 'cap' => 'round', 'join' => 'round', 'phase' => $fontsize / $mX)); $pdf->Cell($size['w'], $fontsize, get_string('certificatecopy', 'simplecertificate'), $boder_style, 0, 'C', false, '', 4, true, 'C', 'C'); $pdf->StopTransform(); // Reset the transparency to default $pdf->SetAlpha(1); } // Set protection seems not work, so comment // $pdf->SetProtection(array('print', 'modify', 'print-high'),null, random_string(), '1',null); // For DEGUG // $pdf->Output($file->get_filename(), 'I'); // Save and send tmpfiles $pdf->Output($tmpfile, 'F'); send_temp_file($tmpfile, $file->get_filename()); } }
$stmt = DBExecSP($conn, $curs, $sql, $params); $row = DBGetSP($curs, false); // ******* INICIO - Armado del reporte.. ******* $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/usuarios_registrados/clientes/denuncias_de_siniestros/templates/denuncia_siniestro.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "", 8); $pdf->Ln(15); switch ($row["EW_TIPOSINIESTRO"]) { case 1: $pdf->Cell(81); $pdf->Cell(0, 0, "X"); break; case 2: $pdf->Cell(113); $pdf->Cell(0, 0, "X"); break; case 3: $pdf->Cell(45.2); $pdf->Cell(0, 0, "X"); break; } $pdf->Ln(4); $pdf->Cell(154); $pdf->Cell(0, 0, str_replace("/", " ", $row["EW_FECHASIN"]));
FROM cfi_firma WHERE fi_id = 444"; // Queda fijo Ana Bordachar.. $stmt = DBExecSql($conn, $sql, array()); $rowFirmante = DBGetQuery($stmt, 1, false); $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/usuarios_registrados/agentes_comerciales/comisiones/templates/ingresos_brutos_generico.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "", 13); $numeroComprobante = str_pad($row["NROCOMPROBANTE"], 12, "0", STR_PAD_LEFT); $pdf->Ln(4.6); $pdf->Cell(148); $pdf->Cell(0, 0, substr($numeroComprobante, 0, 4)."-".substr($numeroComprobante, 4)); $pdf->SetFont("Arial", "B", 12); $pdf->Ln(14); $pdf->Cell(2); $pdf->Cell(0, 0, "Provincia Aseguradora de Riesgos de Trabajo S.A."); $pdf->SetFont("Arial", "", 10); $pdf->Ln(6); $pdf->Cell(2); $pdf->Cell(0, 0, "Carlos Pellegrini 91 1º Piso - Capital Federal"); $pdf->Ln(6); $pdf->Cell(2); $pdf->Cell(0, 0, "C.P. 1009");
function preview($rows, $report_name = '') { $html = ' <table width="100%" border="0"> <tr> <td colspan="3" align="center">' . $report_name . '</td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <table width="100%" border="1"> <tbody><tr> <td width="10%"><strong>Employee ID</strong></td> <td width="9%"><strong>Name</strong></td> <td width="4%"><strong>Sex</strong></td> <td width="10%"><strong>Position/<br /> Designation</strong></td> <td width="13%"><strong>Office / Department</strong></td> <td width="11%"><strong>Employment Status</strong></td> <td width="6%"><strong>Salary Grade</strong></td> <td width="9%"><strong>Eligibility</strong></td> <td width="11%"><strong>Education</strong></td> <td width="8%"><strong>Birthday</strong></td> <td width="9%"><strong>Address</strong></td></tr>'; $office = new Orm_office(); foreach ($rows as $row) { $office->get_by_office_id($row->office_id); $type_employment = $this->options->type_employment(); $birth_date = $row->birth_date; if ($row->birth_date == '0000-00-00') { $birth_date = ''; } $html .= ' <tr> <td>' . $row->id . '</td> <td>' . $row->lname . ',' . $row->fname . ' ' . $row->mname . '</td> <td>' . $row->sex . '</td> <td>' . $row->position . '</td> <td>' . $office->office_name . '</td> <td>' . $type_employment[$row->permanent] . '</td> <td>' . $row->salary_grade . '-' . $row->step . '</td> <td>' . $row->eligibility . '</td> <td>' . $row->education . '</td> <td>' . $birth_date . '</td> <td>' . $row->res_address . '</td> </tr>'; } $html .= ' <tr><td><p> </p></td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td><td> </td></tr> </tbody></table>'; // Signatories $sr_prepared = $this->Settings->get_selected_field('sr_prepared'); $sr_prepared_position = $this->Settings->get_selected_field('sr_prepared_position'); $sr_certified = $this->Settings->get_selected_field('sr_certified'); $sr_certified_position = $this->Settings->get_selected_field('sr_certified_position'); $html .= ' <table width="100%" border="0"> <tr> <td width="38%"> </td> <td width="23%"> </td> <td width="39%"> </td> </tr> <tr> <td align="center">PREPARED BY:</td> <td> </td> <td align="center">CERTIFIED CORRECT:</td> </tr> <tr> <td align="center"> </td> <td> </td> <td align="center"> </td> </tr> <tr> <td align="center"> </td> <td> </td> <td align="center"> </td> </tr> <tr> <td align="center">' . $sr_prepared . '</td> <td> </td> <td align="center">' . $sr_certified . '</td> </tr> <tr> <td align="center">' . $sr_prepared_position . '</td> <td> </td> <td align="center">' . $sr_certified_position . '</td> </tr> </table> '; $this->load->library('MPDF52/mpdf'); //$this->mpdf->WriteHTML('<p>Hello There hahahaha</p>'); //$this->mpdf->Output('mpdf.pdf','I'); // LOAD a stylesheet $stylesheet = file_get_contents(base_url() . 'css/mpdf/mpdfstyletables.css'); $this->mpdf->WriteHTML($stylesheet, 1); // The parameter 1 tells that this is css/style only and no body/html/text $this->mpdf->WriteHTML($html); $this->mpdf->Output('dtr/template/pds/archives/pds_' . date('Y_m_d') . '.pdf', 'F'); return 'dtr/template/pds/archives/pds_' . date('Y_m_d') . '.pdf'; exit; $this->load->helper('settings'); $this->load->library('fpdf'); //define('FPDF_FONTPATH',$this->config->item('fonts_path')); $this->load->library('fpdi'); // initiate FPDI $pdf = new FPDI('L', 'mm', 'Letter'); // add a page $pdf->AddPage(); // set the sourcefile //$pdf->setSourceFile('dtr/template/service_record/service_record.pdf'); // import page 1 //$tplIdx = $pdf->importPage(1); // use the imported page and place it at point 10,10 with a width of 100 mm //$pdf->useTemplate($tplIdx, 1, 1, 210); // now write some text above the imported page $pdf->SetFont('Arial'); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(15, 60); $pdf->SetFont('Arial', '', 16); $pdf->Cell(0, 3, "Report Name", '', 1, 'C', false); //$pdf->Ln(4); //$e = new Employee_m(); //$e->get_by_employee_id( $employee_id ); $pdf->SetFont('Arial', '', 12); //$pdf->Cell(0,8,"Employee No.:".$e->id ,'',1,'L',false); //$pdf->Ln(2); //$pdf->SetFont('Arial', '', 12); //$pdf->Cell(0,8,"Employee Name:".$e->lname.', '.$e->fname.' '.$e->mname ,'',1,'L',false); $pdf->Ln(4); $pdf->Cell(0, 8, "Emp ID Name Sex Position/Designation Office Employment Status Salary Grade Eligibility Education Birth Day Address", '1', 1, 'L', false); $pdf->Ln(4); $i = 1; $this->load->helper('text'); //$pdf->Cell(30,12, word_wrap('msayado maahhn ndhah ahhhehe so ano gagawin mo now', 10) ,'1',1,'L',false); //$pdf->MultiCell(30,3,word_wrap("hello this is a sample nlong text with line break ", 15) ,'1',1,'L',false); //$pdf->MultiCell(30,3,word_wrap("hello this is a sample nlong text with line break ", 15) ,'0',1,'L',false); foreach ($rows as $row) { $pdf->SetFont('Arial', '', 11); $pdf->SetX(10); //$pdf->Write(0, $row->id); $pdf->Cell(15, 12, $row->id, '1', 0, 'L', false); $pdf->SetX(29); //$pdf->Write(0, $row->lname.', '.$row->fname.''.$row->mname); $pdf->Cell(30, 12, word_wrap($row->lname . ', ' . $row->fname . '' . $row->mname, 10), '1', 1, 'L', false); $pdf->SetFont('Arial', '', 8); $pdf->SetX(62); $pdf->Write(0, $row->sex); $pdf->SetX(75); //$pdf->Write(0, $row->company); $pdf->Write(0, $row->position); //$pdf->SetFont('Arial', '', 12); $pdf->SetX(160); $pdf->Write(0, $row->movement); //$pdf->SetX(150); //$pdf->Write(0, $row->salary_grade); $pdf->SetFont('Arial', '', 8); $pdf->SetX(185); //$pdf->Write(0, $row->status); if ($row->govt_service == 1) { $row->govt_service = 'Yes'; } else { $row->govt_service = 'No'; } $pdf->SetX(190); //$pdf->Write(0, $row->govt_service); $pdf->SetFont('Arial', '', 12); if ($i == 6 || $i == 10 || $i == 13 || $i == 16 || $i == 19 || $i == 22) { $pdf->Ln(8); } else { $pdf->Ln(7); } $i++; } $pdf->Cell(0, 8, "--------------------------------------------------------- Nothing Follows ---------------------------------------------------------", '', 1, 'C', false); // Signatories $pdf->Ln(15); $pdf->SetX(20); $pdf->Cell(90, 5, "PREPARED BY:", '0', 0, 'C', false); $pdf->Cell(90, 5, "CERTIFIED CORRECT:", '0', 1, 'C', false); $pdf->Ln(10); $sr_prepared = $this->Settings->get_selected_field('sr_prepared'); $sr_prepared_position = $this->Settings->get_selected_field('sr_prepared_position'); $sr_certified = $this->Settings->get_selected_field('sr_certified'); $sr_certified_position = $this->Settings->get_selected_field('sr_certified_position'); $pdf->SetX(20); $pdf->Cell(90, 5, $sr_prepared, '0', 0, 'C', false); //4th param border $pdf->Cell(90, 5, $sr_certified, '0', 1, 'C', false); $pdf->SetX(20); $pdf->Cell(90, 5, $sr_prepared_position, '0', 0, 'C', false); $pdf->Cell(90, 5, $sr_certified_position, '0', 1, 'C', false); // Output $pdf->Output('dtr/template/pds/archives/pds_' . date('Y_m_d') . '.pdf', 'F'); return 'dtr/template/pds/archives/pds_' . date('Y_m_d') . '.pdf'; }
$pdf->Text(58, 73, $rowCabecera["FECHA_CHEQUE"]); $pdf->Text(83, 73, $rowCabecera["OPAGO"]); $pdf->Text(105, 73, $rowCabecera["DESCRIPCION"]); $pdf->Text(170, 73, $rowCabecera["MONTOREEMP"]); //--------------------------------------------------------------------------- $i = 1; $netoAPagar = 0; $posX = 0; $stmt = DBExecSql($conn, $sqlMain, $paramsMain); while ($row = DBGetQuery($stmt, 1, false)) { if ($i == 1 && $netoAPagar > 0) { $pdf->AddPage();} $posX = (93 + ($i*4)); $pdf->SetXY(20, $posX); $pdf->Cell(20, 0, $row["DESCRIPTION"], 0, 0, 'L' ); $pdf->SetX(40); $pdf->Cell(50, 0, $row["BANK_NAME"], 0, 0, 'L' ); $pdf->SetX(88); $pdf->Cell(20, 0, $row["BANK_ACCOUNT_NUM"], 0, 0, 'L' ); $pdf->SetX(120); $pdf->Cell(20, 0, $row["CHEQUE"], 0, 0, 'L' ); $pdf->SetX(146); $pdf->Cell(20, 0, $row["FECHA_OP"], 0, 0, 'L' ); $pdf->SetX(170); $pdf->Cell(20, 0, $row["MONTO"], 0, 0, 'R' );
"SELECT fi_caracter, fi_firmante FROM cfi_firma WHERE fi_id = 444"; // Queda fijo Ana Bordachar.. $stmt = DBExecSql($conn, $sql, array()); $rowFirmante = DBGetQuery($stmt, 1, false); $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/usuarios_registrados/agentes_comerciales/comisiones/templates/ingresos_brutos_4.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(41.8); $pdf->Cell(39.6); $pdf->Cell(80, 0, "Provincia Aseguradora de Riesgos de Trabajo S.A."); $pdf->Ln(5.4); $pdf->Cell(39.6); $pdf->Cell(80, 0, "Carlos Pellegrini 91 1º Piso - Capital Federal"); $pdf->Ln(5); $pdf->Cell(39.6); $pdf->Cell(0, 0, "30-68825409-0"); $pdf->SetFont("Arial", "", 10); $pdf->Ln(-4.6); $pdf->Cell(152); $pdf->Cell(8, 0, $row["ANOFECHA"]);
$rowE = DBGetQuery($stmt, 1, false); if ($autoPrint) $pdf = new PDF_AutoPrint(); else $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/exposicion_riesgos_quimicos.pdf"); $pdf->AddPage("L"); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx, null, null, 0, 0, true); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(22); $pdf->Cell(16); $pdf->Cell(252, 0, $row2["SA_NOMBRE"]); $pdf->Cell(20); $pdf->Cell(0, 0, $row2["CUIT"]); $pdf->Ln(8); $pdf->Cell(44); $pdf->Cell(84, 0, $rowE["NROESTABLECIMIENTO"]); $pdf->Cell(20); $pdf->Cell(48, 0, $rowE["CIIU"]); $pdf->Cell(22); $pdf->Cell(76, 0, $rowE["ACTIVIDAD"]);
public function executeBatchPrintBadge(sfWebRequest $request) { $ids = $request->getParameter('ids'); // initiate FPDI $pdf = new FPDI('P', 'pt'); // set the sourcefile $pdf->setSourceFile(sfConfig::get('sf_upload_dir') . '/badges/ID_new.pdf'); foreach ($ids as $id) { $this->employee = EmployeePeer::retrieveByPk($id); // import page 1 $tplIdx = $pdf->importPage(1); // add a new page based on size of the badge $s = $pdf->getTemplatesize($tplIdx); $pdf->AddPage('P', array($s['w'], $s['h'])); $pdf->useTemplate($tplIdx); $pdf->setMargins(0, 0, 0, 0); $pdf->SetAutoPageBreak(false); if ($this->employee->getPicture()) { $pdf->Image(sfConfig::get('sf_upload_dir') . '/' . sfConfig::get('app_employee_images_dir') . '/' . $this->employee->getPicture(), 29.5, 25.5, 60.3, 74.3); } else { $pdf->Image(sfConfig::get('sf_upload_dir') . '/badges/picture_missing.jpg', 29.5, 25.5, 60.3, 74.3); } // now write some text above the imported page $pdf->SetFont('freesans', 'B', 12); $pdf->SetTextColor(82, 78, 134); $pdf->SetXY(22, 110); $pdf->Cell(0, 12, $this->employee->getFullName()); $pdf->Ln(); $pdf->SetX(22); $pdf->SetFont('freesans', 'BI', 10); $pdf->Cell(0, 14, $this->employee->getJob()); $pdf->SetDisplayMode('real'); } return $pdf->Output('newpdf.pdf', 'D'); }
function showForm($data = "", $msg = "") { global $t, $db, $sesIdUsuario, $hoy, $usuario; $idReg = $data[idReg]; $idPedido = $data[idPedido]; //echo "ID_PEDIDO : $idPedido <hr>"; $t->set_file("page", "opGuia.inc.html"); // ----------------------------------------- // Datos del Pedido // ----------------------------------------- $sql = "select id_cliente,ori,des,mov,bkg,pos_fec,pos_hor,pos_min,ori,des, "; $sql .= "destinatario,destinatario_dom "; $sql .= "from PEDIDO where id_pedido='{$idPedido}' "; $db->query($sql); while ($db->next_record()) { $idCliente = $db->f(id_cliente); $cliente = getValueTable("cliente", "CLIENTE", "id_cliente", $idCliente); $ori = $db->f(ori); $des = $db->f(des); $mov = $db->f(mov); $bkg = $db->f(bkg); $posFec = $db->f(pos_fec); $posHor = $db->f(pos_hor); $posMin = $db->f(pos_min); $pos = "{$posFec} {$posHor}:{$posMin}"; $ori = $db->f(ori); $des = $db->f(des); $ruta = "{$ori} / {$des}"; $destinatario = $db->f(destinatario); $destinatarioDom = $db->f(destinatario_dom); } $t->set_var(array("ID_REG" => $idReg, "ID_PEDIDO" => $idPedido, "ACTION" => $PHP_SELF, "MENSAJE" => "", "CLIENTE" => $cliente, "ORI" => $ori, "DES" => $des, "MOV" => $mov, "CANCELADO_DETALLE" => "", "IMPRIMIR" => "<a href=\"javascript:ventanaNueva('opGuiaImp.php?idReg={$idReg}',850,600)\"><img src=\"../images/imp.png\" border=\"0\" height=\"30\" width=\"30\"></a>", "PDF" => "")); // Consultar si esta cancelada la Guia de embarque. $stRegGE = getValueTable("st_reg", "GUIA", "id_guia", $idReg); $bajaIdUsr = getValueTable("baja_id_usr", "GUIA", "id_guia", $idReg); $bajaFec = getValueTable("baja_fec", "GUIA", "id_guia", $idReg); if ($stRegGE == "B") { $bajaUsr = getValueTable("usuario", "USUARIO", "id_usuario", $bajaIdUsr); $bajaDetalle = "<font color=red>**CANCELADO**<br>Por: {$bajaUsr}<br>Fecha : {$bajaFec}</font>"; $t->set_var("CANCELADO_DETALLE", "{$bajaDetalle}"); } else { $stRegColor = "class=\"color3\""; $bajaDetalle = ""; $t->set_var("BAJA", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idGuia}','baja')\"><img src=\"../images/b_del.png\" border=0></a>"); } if (empty($idReg) || $idReg == 0) { $op = "nuevo"; } elseif ($stRegGE == "B") { $op = "cancelado"; $t->set_var("GUARDAR", ""); $t->set_var("ACTUALIZAR", ""); $t->set_var("IMPRIMIR", ""); } else { $op = "editar"; } switch ($op) { case "editar": if ($usuario->havePerm("1,9", $_SESSION['sesArrPerms'])) { // 9 : [Transporte] Captura Pedidos $t->set_var("GUARDAR", ""); $t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\">Actualizar Datos</a>"); } else { $t->set_var("GUARDAR", ""); $t->set_var("ACTUALIZAR", ""); } break; case "nuevo": if ($usuario->havePerm("1,9", $_SESSION['sesArrPerms'])) { if (!empty($idPedido)) { $t->set_var("GUARDAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','','rec')\">Guardar</a>"); $t->set_var("ACTUALIZAR", ""); } else { $t->set_var("GUARDAR", "<font color=\"red\"><b>ERROR : PRIMERO SELECCIONE UN PEDIDO Y LUEGO CREE UNA GUIA DE EMBARQUE.</b></font>"); $t->set_var("ACTUALIZAR", ""); } } else { $t->set_var("GUARDAR", ""); $t->set_var("ACTUALIZAR", ""); } break; } // -------------------------- // CONSULTA DE GUIA // -------------------------- if ($idReg > 0) { $sql = "select * from GUIA where id_guia='{$idReg}'"; $db->query($sql); while ($db->next_record()) { $serie = $db->f(serie); $folio = $db->f(folio); $data[folio] = $serie . $folio; //$data[facturaS] = $db->f(factura_s); $data[factura] = $db->f(factura); $idConte = $db->f(id_contenedor); $idEquipo = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $data[conte] = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); $data[equipo] = getValueTable("equipo", "EQUIPO", "id_equipo", $idEquipo); $data[sello] = $db->f(sello); $data[flete] = $db->f(flete); $data[seguro] = $db->f(seguro); $data[otroCosto] = $db->f(otro_costo); $data[diceContener] = $db->f(dice_contener); $data[mercancia] = $db->f(mercancia); $data[bulto] = $db->f(bulto); $data[operador] = $db->f(operador); $data[nota] = $db->f(nota); $data[traUni] = $db->f(tra_uni); $data[traPla] = $db->f(tra_pla); $data[chaUni] = $db->f(cha_uni); $data[chaPla] = $db->f(cha_pla); $data[terLlega] = $db->f(ter_llega); $data[terSale] = $db->f(ter_sale); $data[terVacLlega] = $db->f(ter_vac_llega); $data[terVacSale] = $db->f(ter_vac_sale); $data[referencia] = $db->f(referencia); $data[tonelaje] = $db->f(tonelaje); $data[valorDec] = $db->f(valor_dec); $capIdUsr = $db->f(cap_id_usr); $capFec = $db->f(cap_fec); $modIdUsr = $db->f(mod_id_usr); $modFec = $db->f(mod_fec); $capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr); $modUsr = getValueTable("usuario", "USUARIO", "id_usuario", $modIdUsr); $data[maniobra] = $db->f(maniobra); $data[autopista] = $db->f(autopista); $data[clase] = $db->f(clase); $data[ruta] = $db->f(ruta); $data[gastosViaje] = $db->f(gastos_viaje); $data[dollyNum] = $db->f(dolly_num); $data[dollyPla] = $db->f(dolly_pla); } } // Combos if ($data[maniobra] == "M") { $t->set_var("MANI_SEL_M", "selected"); } if ($data[maniobra] == "C") { $t->set_var("MANI_SEL_C", "selected"); } if ($data[autopista] == "S") { $t->set_var("AUTOPISTA_SEL_S", "selected"); } if ($data[autopista] == "N") { $t->set_var("AUTOPISTA_SEL_N", "selected"); } // Combo Bulto if ($data[bulto] == "20-DC") { $t->set_var("20DCSEL", "selected"); } if ($data[bulto] == "40-DC") { $t->set_var("40DCSEL", "selected"); } if ($data[bulto] == "40-HC") { $t->set_var("40HCSEL", "selected"); } if ($data[bulto] == "20-RF") { $t->set_var("20RFSEL", "selected"); } if ($data[bulto] == "40-RF") { $t->set_var("40RFSEL", "selected"); } if ($data[bulto] == "20-OT") { $t->set_var("20OTSEL", "selected"); } if ($data[bulto] == "40-OT") { $t->set_var("40OTSEL", "selected"); } if ($data[bulto] == "20-FL") { $t->set_var("20FLSEL", "selected"); } if ($data[bulto] == "40-FL") { $t->set_var("40FLSEL", "selected"); } if ($data[bulto] == "20-TK") { $t->set_var("20TKSEL", "selected"); } if ($data[bulto] == "40-TK") { $t->set_var("40TKSEL", "selected"); } // Combo Clase de contenedor if ($data[clase] == "A") { $t->set_var("CLASESELA", "selected"); } if ($data[clase] == "B") { $t->set_var("CLASESELB", "selected"); } if ($data[clase] == "C") { $t->set_var("CLASESELC", "selected"); } if ($data[clase] == "D") { $t->set_var("CLASESELD", "selected"); } if ($data[clase] == "FG") { $t->set_var("CLASESELFG", "selected"); } if ($data[clase] == "GC") { $t->set_var("CLASESELGC", "selected"); } $folioX = $data[folio]; $t->set_var(array("FOLIO" => $folioX, "FACTURA_S" => $data[facturaS], "FACTURA" => $data[factura], "REFERENCIA" => $data[referencia], "TONELAJE" => $data[tonelaje], "VALOR_DEC" => $data[valorDec], "CONTENEDOR" => $data[conte], "EQUIPO" => $data[equipo], "SELLO" => $data[sello], "FLETE" => $data[flete], "MANIOBRA" => $data[maniobra], "SEGURO" => $data[seguro], "AUTOPISTA" => $data[autopista], "OTRO_COSTO" => $data[otroCosto], "MERCANCIA" => $data[mercancia], "DICE_CONTENER" => $data[diceContener], "OPERADOR" => $data[operador], "NOTA" => $data[nota], "TRA_UNI" => $data[traUni], "TRA_PLA" => $data[traPla], "CHA_UNI" => $data[chaUni], "CHA_PLA" => $data[chaPla], "TER_LLEGA" => $data[terLlega], "TER_SALE" => $data[terSale], "TER_VAC_LLEGA" => $data[terVacLlega], "TER_VAC_SALE" => $data[terVacSale], "CAPTURO" => "{$capUsr} / {$capFec}", "MODIFICO" => "{$modUsr} / {$modFec}", "RUTA" => $data[ruta], "GASTOS_VIAJE" => $data[gastosViaje], "DOLLY_NUM" => $data[dollyNum], "DOLLY_PLA" => $data[dollyPla])); // ""=>$data[], //$facS = $data[facturaS]; $facX = $data[factura]; if (preg_match("/(.{0,2})(.*)/", $facX, $parts)) { $facS = $parts[1]; $facN = $parts[2]; } if ($idReg > 0 && !empty($facN)) { // ---------------------------------------------- // PROCESO DE EDICION DE FACTURA-PDF // // 1. Comprobar que exista la factura original. // 2. Buscar todas las GE que tengan la misma factura relacionada. // 3. Consultar (Folio_serie,Folio,Contenedor,Tipo,Bkg,Posicionamiento,Ruta,etc. // 4. Generar nuevo PDF. // ---------------------------------------------- $facN2 = str_pad($facN, 7, 0, STR_PAD_LEFT); $filePdfOri = "OPE0606129RAF" . $facS . $facN2 . ".pdf"; $filePdfEdi = "OPE0606129RAF" . $facS . $facN2 . "_.pdf"; // Consultar datos GE con la misma Factura. unset($txtFac); unset($txtFac2); $numConte = 0; $sql = "select folio,id_contenedor "; $sql .= "from GUIA "; //$sql.="where factura_s='$facS' and factura='$facN' and st_reg<>'B' "; $sql .= "where factura='{$facX}' and st_reg<>'B' "; $db->query($sql); while ($db->next_record()) { $numConte++; $folioX = $db->f(folio); $folioS = substr($folioX, 0, 2); $folioN = substr($folioX, 2, 10); $idConte = $db->f(id_contenedor); $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); $idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq); // Si la cantidad de contenedores es mayor al limite, entonces 2do arreglo. $maxConte = 17; if ($numConte > $maxConte) { $txtFac2[] = "{$folioS} {$folioN} {$conte} {$equipo}"; } else { $txtFac[] = "{$folioS} {$folioN} {$conte} {$equipo}"; } } // --------------------------------------------------- // Editar factura. if (file_exists("../facturas/{$filePdfOri}")) { //$pdf =& new FPDI(); $pdf = new FPDI(); $pdf->AddPage(); //Set the source PDF file $pagecount = $pdf->setSourceFile("../facturas/{$filePdfOri}"); //Import the first page of the file $tpl = $pdf->importPage(1); //Use this page as template $pdf->useTemplate($tpl); $pdf->SetFont('Arial', '', 7); // PAGINA #1 // Inicializa la posición $destinatarioDom = str_replace("\n", "", $destinatarioDom); $destinatarioDom = str_replace("\r", "", $destinatarioDom); $pdf->SetXY(60, 90); $pdf->Cell(45, 5, "BKG : {$bkg} ", 0, 0, 'L'); $pdf->SetXY(60, 93); $pdf->Cell(45, 5, "POSICIONAMIENTO : {$pos} ", 0, 0, 'L'); $pdf->SetXY(60, 96); $pdf->Cell(45, 5, "RUTA : {$ruta}", 0, 0, 'L'); $pdf->SetXY(60, 99); $pdf->Cell(45, 5, "SALIDA DE VACIO : ? ", 0, 0, 'L'); $pdf->SetXY(60, 105); $pdf->Cell(60, 5, $destinatario, 0, 0, 'L'); // Seccionar a varias Cell, el domicilio del destinatario // Direccion de destinatario $s = $destinatarioDom; $s = strtoupper($s); $lenTl = strlen($s); // Conocer el numero de lineas $nlDes = $lenTl / 15; // El total de caracteres entre el ancho de 35 que es el max de caracteres x linea. $posIni = 0; $y = 109; for ($i = 1; $i <= $nlDes; $i++) { $txtX = substr($s, $posIni, 35); $pdf->SetXY(60, $y); $pdf->Cell(60, 4, $txtX, 0, 0, 'L'); $posIni = $posIni + 35; $y = $y + 3; } // --------------------------- $y = 90; foreach ($txtFac as $txt) { $pdf->SetXY(10, $y); $pdf->Cell(45, 5, $txt, 0, 0, 'L'); $y = $y + 3; } if ($numConte > $maxConte) { $pdf->SetXY(60, 130); $pdf->Cell(45, 5, "*** VER ANEXO *** VER ANEXO ***", 0, 0, 'L'); // PAGINA #2 $pdf->AddPage(); $y = 20; foreach ($txtFac2 as $txt2) { $pdf->SetXY(10, $y); $pdf->Cell(45, 5, "{$txt2}", 0, 0, 'L'); $y = $y + 3; if ($y == 266) { $y = 20; $pdf->AddPage(); } } } // Grabar archivo //echo "[$filePdfEdi]"; $pdf->Output("../facturas/{$filePdfEdi}", "F"); //$x = file_exists("../facturas/$filePdfEdi"); if (file_exists("../facturas/{$filePdfEdi}")) { $pdfImg = "<a href=\"javascript:ventanaNueva('../facturas/{$filePdfEdi}',800,600)\"><img src=\"../images/pdf.gif\" width=\"25\" hight=\"20\" border=0></a>"; } else { $pdfImg = ""; } $t->set_var("PDF", "{$pdfImg}"); } else { $t->set_var("PDF", ""); } } // ----------------------------------------------- // Control de mensajes // ------------------------------------------- if (!empty($msg)) { $canMsg = count($msg); if ($canMsg > 0) { foreach ($msg as $val) { $cadMsg .= $val . " <br>"; } $t->set_var(array("MENSAJE" => $cadMsg)); } } $t->pparse("out", "page"); }
function back_id($results) { $this->load->helper('settings'); //print preview of MR $this->load->library('fpdf'); $this->load->library('fpdi'); // initiate FPDI $pdf = new FPDI('L'); // add a page $pdf->AddPage(); // set the sourcefile $pagecount = $pdf->setSourceFile('pdf-report/id/back-id.pdf'); // import page 1 $tplIdx = $pdf->importPage(1); // use the imported page and place it at point 10,10 with a width of 100 mm $pdf->useTemplate($tplIdx); // now write some text above the imported page $pdf->SetTextColor(0, 0, 0); $pdf->SetFont('Arial', '', 7); $n = 1; foreach ($results as $result) { $s = new Personal_m(); $row = $s->get_by_employee_id($result->employee_id); //======================== START Column 1 | Right to Left ============================== if ($n == 11) { //add new page $pdf->addPage(); for ($n = 1; $n <= 1; $n++) { $tplidx = $pdf->ImportPage(1); $pdf->useTemplate($tplIdx); //, 1, 1, 210 } $n = $n - 1; } $bday = $row->birth_date; $address = $row->res_address; $blood_type = '"' . $row->blood_type . '"'; $gsis = $row->gsis; $pagibig = $row->pagibig; $philhealth = $row->philhealth; $tin = $row->tin; $emergency = ''; $contact = $row->cp; //----------------------------- Row 1 ---------------------------------- ///Birthday if ($n == 1) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(247, 23); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(257, 15); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(247, 28.3); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(247, 33); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(247, 38); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(247, 43.5); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(247, 48.5); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(235, 75.5); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(250, 78); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(250); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 2 ---------------------------------- if ($n == 2) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(189, 23); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(199, 15); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(189, 28.3); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(189, 33); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(189, 38); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(189, 43.5); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(189, 48.5); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(177, 75.5); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(192, 78); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(192); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 3 ---------------------------------- if ($n == 3) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(131, 23); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(141, 15); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(131, 28.3); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(131, 33); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(131, 38); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(131, 43.5); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(131, 48.5); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(119, 75.5); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(134, 78); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(134); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 4 ---------------------------------- if ($n == 4) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(73, 23); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(83, 15); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(83); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(83); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(3); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(73, 28.3); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(73, 33); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(73, 38); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(73, 43.5); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(73, 48.5); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(61, 75.5); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(76, 78); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(76); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 5 ---------------------------------- if ($n == 5) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(15, 23); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(25, 15); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(15, 28.3); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(15, 33); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(15, 38); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(15, 43.5); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(15, 48.5); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(3, 75.5); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(18, 78); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(18); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //======================== END Column 1 | Right to Left ============================== //======================== START Column 2 | Right to Left ============================== //----------------------------- Row 1 ---------------------------------- ///Birthday if ($n == 6) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(247, 123.5); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(257, 115); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(257); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(247, 128.5); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(247, 133.5); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(247, 138.5); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(247, 144); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //TIN $pdf->SetXY(247, 149); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(235, 176.3); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(250, 178.5); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(250); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 2 ---------------------------------- //----------------------------- Row 2 ---------------------------------- if ($n == 7) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(189, 123.5); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(199, 115); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(199); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(189, 128.5); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(189, 133.5); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(189, 138.5); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(189, 144); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //tin $pdf->SetXY(189, 149); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(177, 176.3); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(192, 178.5); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(192); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 3 ---------------------------------- if ($n == 8) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(131, 123.5); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(141, 115); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(141); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(131, 128.5); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(131, 133.5); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(131, 138.5); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(131, 144); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(131, 149); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(119, 176.3); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(134, 178.5); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(134); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 4 ---------------------------------- if ($n == 9) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(73, 123.5); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(83, 115); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(83); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(83); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(3); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(73, 128.5); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(73, 133.5); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(73, 138.5); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(73, 144); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(73, 149); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(61, 176.3); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(76, 178.5); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(76); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //----------------------------- Row 5 ---------------------------------- if ($n == 10) { //Birthday if ($bday != '0000-00-00') { $pdf->SetXY(15, 123.5); $pdf->Cell(50, 0, date('F d, Y', strtotime(date('F d, Y', strtotime($bday)))), '0', 0, 'C', false); } //Address $pdf->SetXY(25, 115); $addr = splitstroverflow(ucwords(strtolower(utf8_decode($address))), 28); $pdf->Cell(30, 0, $addr[0], '0', 0, 'C', false); //display text overflow if ($addr[1]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[1], '0', 0, 'C', false); } if ($addr[2]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[2], '0', 0, 'C', false); } if ($addr[3]) { $pdf->Ln(2.5); $pdf->SetX(25); $pdf->Cell(30, 0, $addr[3], '0', 0, 'C', false); } //Blood Type $pdf->SetXY(15, 128.5); $pdf->Cell(50, 0, strtoupper($blood_type), '0', 0, 'C', false); //GSIS $pdf->SetXY(15, 133.5); $pdf->Cell(50, 0, strtoupper($gsis), '0', 0, 'C', false); //PAGIBIG $pdf->SetXY(15, 138.5); $pdf->Cell(50, 0, strtoupper($pagibig), '0', 0, 'C', false); //PHILHEALTH $pdf->SetXY(15, 144); $pdf->Cell(50, 0, strtoupper($philhealth), '0', 0, 'C', false); //tin $pdf->SetXY(15, 149); $pdf->Cell(50, 0, strtoupper($tin), '0', 0, 'C', false); //in case of emergency $pdf->SetXY(3, 176.3); $pdf->Cell(60, 0, strtoupper($emergency), '0', 0, 'C', false); //CP No. $pdf->SetXY(18, 178.5); $cpno = splitstroverflow($contact, 13); $pdf->Cell(30, 0, $cpno[0], '0', 0, 'C', false); if ($cpno[1]) { $pdf->Ln(3); $pdf->SetX(18); $pdf->Cell(30, 0, $cpno[1], '0', 0, 'C', false); } } //======================== END Column 2 | Right to Left ============================== $n++; } // Output $pdf->Output('pdf-report/back-id.pdf', 'F'); return 'pdf-report/back-id.pdf'; }
"SELECT art.utiles.armar_cuit(sa_cuit) cuit, sa_nombre FROM asa_solicitudafiliacion WHERE sa_idformulario = :sa_idformulario"; $stmt = DBExecSql($conn, $sql, $params); $row2 = DBGetQuery($stmt, 1, false); if ($autoPrint) $pdf = new PDF_AutoPrint(); else $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_afiliacion/templates/ventanilla_electronica.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "B", 9); $pdf->Ln(34.5); $pdf->Cell(38); $pdf->Cell(136, 0, $row2["SA_NOMBRE"]); $pdf->Ln(5.2); $pdf->Cell(31); $pdf->Cell(32, 0, $row2["CUIT"]); if ($autoPrint) $pdf->AutoPrint(false); $pdf->Output(); ?>
public function createScreeningPdf($hash) { $screening_entry_model = ScreeningEntry::findOne(['hash' => $hash]); $screening_form_model = ScreeningForm::findOne(['id' => $screening_entry_model->screening_form_id]); $subject_model = Subject::findOne(['id' => $screening_entry_model->subject_id]); $count = 1; //$permissions = \SetaPDF_Core_SecHandler::PERM_DIGITAL_PRINT ; $this->_font = 'Helvetica'; //class_exists('TCPDF', true); // trigger Composers autoloader to load the TCPDF class $pdf = new \FPDI(); $pdf->SetAutoPageBreak(true); // add a page $pdf->SetTopMargin(30); $pdf->AddPage(); $pdf->setSourceFile(\yii::$app->basePath . "/../letterhead-mini-header.pdf"); $tplIdx = $pdf->importPage(1); // use the imported page and place it at point 10,10 with a width of 100 mm $pdf->useTemplate($tplIdx, 0, 0); $pdf->SetFont($this->_font, '', 9); $pdf->SetXY(10, 6); $pdf->Cell(0, 3, 'Confidential - Participant screening form'); $pdf->SetFont($this->_font, '', 12); $pdf->SetXY(10, 14); $pdf->MultiCell(150, 3, yii::$app->DateComponent->timestampToUkDate($screening_entry_model->created_at), 0, 'R'); $pdf->MultiCell(100, 3, $screening_entry_model->screening_form_title, 0, ''); $pdf->Ln(); $pdf->SetFont($this->_font, '', 9); $pdf->Cell(100, 4, sprintf('Participant: %s %s (dob %s)', $screening_entry_model->subject->first_name, $screening_entry_model->subject->last_name, yii::$app->DateComponent->isoToUkDate($screening_entry_model->subject->dob))); $pdf->Cell(50, 4, sprintf('Identifier: %s', $screening_entry_model->subject->cubric_id), 0, '', 'R'); $pdf->Ln(); $pdf->Cell(100, 4, sprintf('Researcher: %s %s (project %s)', $screening_entry_model->researcher->first_name, $screening_entry_model->researcher->last_name, $screening_entry_model->project->code)); $pdf->Cell(50, 4, sprintf('Resource: %s', $screening_entry_model->resource_title), 0, '', 'R'); $pdf->SetXY(10, 38); $pdf->SetFont($this->_font, '', 12); $pdf->Cell(150, 4, sprintf('Responses')); $pdf->SetFont($this->_font, '', 9); $pdf->Ln(); foreach (yii::$app->screeningresponse->getResponses($hash) as $response) { if (strlen($response['caption']) > 0) { $pdf->Ln(); $pdf->MultiCell(180, 4, sprintf('%s ', $response['caption']), 0, 'U'); $count = 1; } $pdf->MultiCell(180, 4, sprintf('%s. %s ', $count, $response['content'])); $pdf->SetFont($this->_font, 'B', 9); if ($response['response'] === null) { $response['response'] = 'Not specified / Unknown.'; } $pdf->MultiCell(180, 4, sprintf('%s ', $response['response'])); $pdf->SetFont($this->_font, '', 9); $count++; $pdf->Ln(); } $pdf->Ln(); $pdf->SetFont($this->_font, '', 12); $pdf->Cell(180, 4, sprintf('Signatures')); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont($this->_font, '', 9); $pdf->Cell(100, 4, 'Participant '); $pdf->Cell(100, 4, 'Researcher '); $pdf->Ln(); $pdf->Ln(); $currentX = $pdf->GetX(); $currentY = $pdf->GetY(); $pdf->Image(sprintf('/tmp/subject-%s.png', $hash), $currentX, $currentY); $currentX = $pdf->GetX(); $pdf->Image(sprintf('/tmp/researcher-%s.png', $hash), $currentX + 100, $currentY); // now write some text above the imported page // NOW SET ScreeningEntry::progress_id = PUBLISHED so it cannot be edited again. // $pdfData = $pdf->Output('S'); // create a writer // create a Http writer //$writer = new \SetaPDF_Core_Writer_Http("fpdf-sign-demo.pdf", true); // load document by filename //$document = new \SetaPDF_Core_Document::loadByString($pdfData, $writer); //$document = new \SetaPDF_Core_Reader_File($pdf->Output(), $writer); $writer = new \SetaPDF_Core_Writer_File("/Users/Spiro/tmp/myPDF.pdf"); $document = \SetaPDF_Core_Document::loadByString($pdf->Output("S"), $writer); // let's prepare the temporary file writer: \SetaPDF_Core_Writer_TempFile::setTempDir("/tmp/"); // create a signer instance for the document $signer = new \SetaPDF_Signer($document); // add a field with the name "Signature" to the top left of page 1 $signer->addSignatureField(\SetaPDF_Signer_SignatureField::DEFAULT_FIELD_NAME, 1, \SetaPDF_Signer_SignatureField::POSITION_LEFT_BOTTOM, array('x' => 10, 'y' => 10), 180, 50); // set some signature properties $signer->setReason('Integrity'); $signer->setLocation('CUBRIC'); $signer->setContactInfo('+44 2920 703859'); // ccreate an OpenSSL module instance $module = new \SetaPDF_Signer_Signature_Module_OpenSsl(); // set the sign certificate $module->setCertificate(file_get_contents("/Users/spiro/Sites/projects/certs/certificate.pem")); // set the private key for the sign certificate $module->setPrivateKey(array(file_get_contents("/Users/spiro/Sites/projects/certs/key.pem"), "")); // create a Signature appearance $visibleAppearance = new \SetaPDF_Signer_Signature_Appearance_Dynamic($module); // choose a document to get the background from and convert the art box to an xObject $backgroundDocument = \SetaPDF_Core_Document::loadByFilename(Yii::getAlias('@frontend/web/img/cubric-logo.pdf')); $backgroundXObject = $backgroundDocument->getCatalog()->getPages()->getPage(1)->toXObject($document); // format the date $visibleAppearance->setShowFormat(\SetaPDF_Signer_Signature_Appearance_Dynamic::CONFIG_DATE, 'd-m-Y H:i:s'); // disable the distinguished name $visibleAppearance->setShow(\SetaPDF_Signer_Signature_Appearance_Dynamic::CONFIG_DISTINGUISHED_NAME, false); // set the background with 50% opacity $visibleAppearance->setGraphic($backgroundXObject, 0.5); //$visibleAppearance->setBackgroundLogo($backgroundXObject, .5); // sign/certify the document // define the appearance $signer->setAppearance($visibleAppearance); $signer->sign($module); if (file_exists(sprintf('/tmp/subject-%s.png', $hash))) { } // unlink(sprintf('/tmp/subject-%s.png' , $hash)); if (file_exists(sprintf('/tmp/researcher-%s.png', $hash))) { } // unlink(sprintf('/tmp/researcher-%s.png' , $hash)); return true; }
$pdf->Image($logo, 0.5, 0.4, 2.5, 0.9, null, null, 'N', true, 300, null, false, false, 0, true); } else { //set position for header text, if enabled $pdf->SetXY($x + 0.5, $y + 0.4); } //header if ($fax_header != '') { $pdf->SetLeftMargin(0.5); $pdf->SetFont($pdf_font, "", 10); $pdf->Write(0.3, $fax_header); } //fax, cover sheet $pdf->SetTextColor(0, 0, 0); $pdf->SetFont($pdf_font, "B", 55); $pdf->SetXY($x + 4.55, $y + 0.25); $pdf->Cell($x + 3.5, $y + 0.4, $text['label-fax-fax'], 0, 0, 'R', false, null, 0, false, 'T', 'T'); $pdf->SetFont($pdf_font, "", 12); $pdf->SetFontSpacing(0.0425); $pdf->SetXY($x + 4.55, $y + 1.0); $pdf->Cell($x + 3.5, $y + 0.4, $text['label-fax-cover-sheet'], 0, 0, 'R', false, null, 0, false, 'T', 'T'); $pdf->SetFontSpacing(0); //field labels $pdf->SetFont($pdf_font, "B", 12); if ($fax_recipient != '' || sizeof($fax_numbers) > 0) { $pdf->Text($x + 0.5, $y + 2.0, strtoupper($text['label-fax-recipient']) . ":"); } if ($fax_sender != '' || $fax_caller_id_number != '') { $pdf->Text($x + 0.5, $y + 2.3, strtoupper($text['label-fax-sender']) . ":"); } if ($fax_page_count > 0) { $pdf->Text($x + 0.5, $y + 2.6, strtoupper($text['label-fax-attached']) . ":");
"SELECT fi_caracter, fi_firmante FROM cfi_firma WHERE fi_id = 444"; // Queda fijo Ana Bordachar.. $stmt = DBExecSql($conn, $sql, array()); $rowFirmante = DBGetQuery($stmt, 1, false); $pdf = new FPDI(); $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/usuarios_registrados/agentes_comerciales/comisiones/templates/obra_social.pdf"); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "", 12); $pdf->Ln(4); $pdf->Cell(8); $pdf->Cell(0, 0, "Provincia Aseguradora de Riesgos de Trabajo S.A."); $pdf->SetFont("Arial", "", 10); $pdf->Ln(6); $pdf->Cell(8); $pdf->Cell(0, 0, "Carlos Pellegrini 91 1º Piso - Capital Federal"); $pdf->Ln(6); $pdf->Cell(8); $pdf->Cell(0, 0, "C.P. 1009"); $pdf->Ln(6); $pdf->Cell(8); $pdf->Cell(0, 0, "Tel: 4819-2800 Fax: 0800-999-1829");
$graficoOk = false; } // FIN - Generación de gráfico que va incrustado en el reporte.. if ($graficoOk) { $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/solicitud_cotizacion/plantillas/analisis_comparativo_costos.pdf"); $pdf->SetDrawColor(255, 255, 255); $pdf->SetFillColor(255, 255, 255); $pdf->AddPage(); $tplIdx = $pdf->importPage(1); $pdf->useTemplate($tplIdx); $pdf->SetFont("Arial", "B", 10); $pdf->Ln(33); $pdf->Cell(40); $pdf->Cell(144, 0, $row["RAZONSOCIAL"]); $pdf->Ln(6.6); $pdf->Cell(28); $pdf->Cell(36, 0, $row["CUIT"]); $pdf->Cell(16); $pdf->Cell(80, 0, $row["CIIU"]); $pdf->Ln(6.6); $pdf->Cell(38); $pdf->Cell(146, 0, $row["DESCRIPCIONCIIU"]); $pdf->Ln(6); $pdf->Cell(32);
$pdf = new FPDI(); if ($user->getPrivilege() <= 10) { $source = "docs/certificatelead.pdf"; } else { $source = "docs/certificate.pdf"; } $pagecount = $pdf->setSourceFile($source); $tplidx = $pdf->importPage(1); $pdf->addPage('L'); $pdf->useTemplate($tplidx, 0, 0, 0); $date = date('jS F Y'); $pdf->AddFont('DejaVu', '', 'DejaVuSansCondensed.ttf', true); $pdf->SetFont('DejaVu', '', 30); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(0, 95); $pdf->Cell(297, 15, $name, 0, 0, 'C', 0); $pdf->SetFont('Arial', '', 18); $pdf->SetXY(170, 160); $pdf->Write(0, $date); $attachment = $pdf->output('Certificate.pdf', 'S'); header('Pragma: public'); header('Expires: -1'); header('Content-Transfer-Encoding: binary'); header('Content-Type: application/pdf'); header('Content-Disposition: attachment;filename="ISOS%20Certificate.pdf"'); header('Cache-Control: max-age=0'); // output the file echo $attachment; exit; break; case 'violationlist':