Example #1
0
 public function imprimir_detalle()
 {
     $data['id'] = $this->input->post('id');
     $data['cliente'] = $this->clientes->buscar_cliente_detalle($data);
     $data['orden'] = $this->clientes->buscar_orden_detalle($data);
     $html = $this->load->view('pdf/detalle_cliente', $data, true);
     /////////////
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetTitle('Titulo Generación de Etiqueta');
     $pdf->SetSubject('Subtitulo');
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('freemono', '', 14, '', true);
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(10, 10, 10);
     $pdf->SetAutoPageBreak(true, -10);
     $pdf->AddPage('P', array(215.9, 279.4));
     //en mm 21.59cm por 27.94cm
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     $nombre_archivo = utf8_decode("informe" . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
Example #2
0
 public function generar_turno($numero, $cita)
 {
     $data['numero'] = base64_decode($numero);
     $data['cita'] = base64_decode($cita);
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     //$pdf->SetAuthor('Osmel Calderón');
     $pdf->SetTitle('Titulo Generación de Etiqueta');
     $pdf->SetSubject('Subtitulo');
     //$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
     //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 001', PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
     //$pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     // Establecer el tipo de letra
     //Si tienes que imprimir carácteres ASCII estándar, puede utilizar las fuentes básicas como
     // Helvetica para reducir el tamaño del archivo.
     //$pdf->SetFont('freemono', '', 14, '', true);
     // Añadir una página
     // Este método tiene varias opciones, consulta la documentación para más información.
     //  $pdf->AddPage();
     //fijar efecto de sombra en el texto
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Establecemos el contenido para imprimir
     //$provincia = $this->input->post('provincia');
     //$data['id_movimiento']='29';
     // remove default header/footer
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     // set default monospaced font
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // set margins
     //$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT, PDF_MARGIN_BOTTOM);
     // set margins
     $pdf->SetMargins(0, 0, 0);
     // set auto page breaks
     $pdf->SetAutoPageBreak(true, -10);
     $pdf->AddPage('P', array(100.0, 100.0));
     //en mm
     //$pdf->AddPage(); //en mm
     $html = $this->load->view('pdfs/turno', $data, true);
     // Imprimimos el texto con writeHTMLCell()
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     // ---------------------------------------------------------
     // Cerrar el documento PDF y preparamos la salida
     // Este método tiene varias opciones, consulte la documentación para más información.
     $nombre_archivo = utf8_decode($data['numero'] . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
 /** @Functions que permiten generar PDF's con reportes
     /**************************************************************************/
 public function reporte_medicamentos()
 {
     // Carga de datos
     $data_meds = $this->gestion->get_medicamentos();
     $tmp_meds = $this->templates->tmp_reporte_medicamentos($data_meds);
     // Generacion de PDF
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('Sysmedcloud');
     $pdf->SetTitle('Reporte de Medicamentos');
     $pdf->SetSubject('');
     $pdf->SetKeywords('');
     $pdf->SetHeaderData('logo.png', PDF_HEADER_LOGO_WIDTH + 20, 'Reporte', 'Medicamentos', array(0, 64, 255), array(0, 64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('Helvetica', '', 8, '', true);
     $pdf->AddPage();
     $pdf->writeHTML($tmp_meds, true, 0, true, 0);
     $nombre_archivo = utf8_decode("reporte-medicamentos-" . date("d") . "_" . date("m") . "_" . date("Y") . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
Example #4
0
 public function GeneraPdf($html, $nombre)
 {
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('');
     $pdf->SetTitle('');
     $pdf->SetSubject('');
     $pdf->SetKeywords('');
     $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . '', PDF_HEADER_STRING, array(255, 255, 255), array(255, 255, 255));
     $pdf->SetFooterData($tc = array(0, 64, 0), $lc = array(255, 255, 255));
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('helvetica', '', 10, '', true);
     $pdf->AddPage();
     $pdf->writeHTML($html, true, false, true, false, '');
     $nombre_archivo = utf8_decode($nombre . date('Y-m-d-His') . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
Example #5
0
 public function generar($code)
 {
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     // $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('Espacio Vivo');
     // $pdf->SetTitle('Ejemplo de provincías con TCPDF');
     // $pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('espacio vivo, inmuebles, pdf, PDF, renta');
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
     // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 001', PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     // $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     // $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     // $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     // Establecer el tipo de letra
     //Si tienes que imprimir carácteres ASCII estándar, puede utilizar las fuentes básicas como
     // Helvetica para reducir el tamaño del archivo.
     $pdf->SetFont('helvetica', '', 14, '', false);
     // Añadir una página
     // Este método tiene varias opciones, consulta la documentación para más información.
     $pdf->AddPage();
     //fijar efecto de sombra en el texto
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Establecemos el contenido para imprimir
     $immovable = $this->general->bringme_immovable($code);
     $immovable = $immovable[0];
     $html = $this->load->view("pdf", $immovable, true);
     // Imprimimos el texto con writeHTMLCell()
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     // ---------------------------------------------------------
     // Cerrar el documento PDF y preparamos la salida
     // Este método tiene varias opciones, consulte la documentación para más información.
     $nombre_archivo = utf8_decode("Inmueble" . $immovable['code'] . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
Example #6
0
 public function index()
 {
     if (strlen($this->getParam()) == 0) {
         App::redirectUrl($this->registry->router->generate('frontend.home', true));
     }
     $product = App::getModel('product/product')->getProductAndAttributesById((int) $this->registry->core->getParam());
     $range = App::getModel('product/product')->getRangeType((int) $this->registry->core->getParam());
     App::getModel('product/product')->getPhotos($product);
     if (empty($product)) {
         App::redirectUrl($this->registry->router->generate('frontend.home', true));
     }
     $product['photo']['normal'][0] = 'design/' . str_replace(DESIGNPATH, '', $product['photo']['normal'][0]);
     $selectAttributes = App::getModel('product/product')->getProductAttributeGroups($product);
     $attset = App::getModel('product/product')->getProductVariant($product);
     $this->registry->template->assign('product', $product);
     $this->registry->template->assign('attributes', $selectAttributes);
     $this->registry->template->assign('attset', $attset);
     $this->registry->template->assign('ROOTPATH', ROOTPATH);
     $htmlcontent = $this->registry->template->fetch($this->loadTemplate('index.tpl'));
     $pdf = new Pdf(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('Gekosale');
     $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setLanguageArray(1);
     $pdf->SetFont('dejavusans', '', 10);
     $pdf->AddPage();
     $pdf->writeHTML($htmlcontent, true, 0, true, 0);
     @ob_clean();
     $pdf->Output($product['seo'], 'D');
 }
Example #7
0
    public function exportInvoice($ids)
    {
        $pdf = new Pdf(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8');
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetAuthor('Gekosale');
        $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        $pdf->setLanguageArray(1);
        $pdf->SetFont('dejavusans', '', 10);
        $sql = 'SELECT 
					*
				FROM invoice
				WHERE 
					idinvoice IN (' . implode(',', $ids) . ')';
        $stmt = Db::getInstance()->prepare($sql);
        $stmt->execute();
        $Data = array();
        while ($rs = $stmt->fetch()) {
            switch ($rs['contenttype']) {
                case 'html':
                    $data = $rs['contentcopy'];
                    $pdf->AddPage();
                    $pdf->writeHTML($data, true, 0, true, 0);
                    break;
            }
        }
        @ob_clean();
        $pdf->Output('Faktury z ' . date('Y-m-d'), 'D');
    }
Example #8
0
<?php

$pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Anibal Urbiola');
$pdf->SetTitle('Descarga de la ficha de chikungunya');
$pdf->SetSubject('Conversion a PDF');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 001', PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
$pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
// datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// se pueden modificar en el archivo tcpdf_config.php de libraries/config
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// se pueden modificar en el archivo tcpdf_config.php de libraries/config
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// se pueden modificar en el archivo tcpdf_config.php de libraries/config
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//relación utilizada para ajustar la conversión de los píxeles
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// ---------------------------------------------------------
// establecer el modo de fuente por defecto
$pdf->setFontSubsetting(true);
// Establecer el tipo de letra
//Si tienes que imprimir carácteres ASCII estándar, puede utilizar las fuentes básicas como
// Helvetica para reducir el tamaño del archivo.
$pdf->SetFont('courier', '', 14, '', true);
    public function cetak_kertas_resep()
    {
        $this->load->library('Pdf');
        $pdf = new Pdf('P', 'mm', 'A5', true, 'UTF-8', false);
        // $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetPageOrientation('P');
        $pdf->SetAuthor('Pemerintah Kota Bogor');
        $pdf->SetTitle('Resep Obat');
        $pdf->SetSubject('Resep Obat');
        $pdf->SetKeywords('Resep Obat');
        // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 001', PDF_HEADER_STRING, array(0,64,255), array(0,64,128));
        $pdf->setFooterData(array(0, 64, 0), array(0, 64, 128));
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
            require_once dirname(__FILE__) . '/lang/eng.php';
            $pdf->setLanguageArray($l);
        }
        $pdf->setFontSubsetting(true);
        $pdf->SetFont('helvetica', '', 11, '', true);
        $pdf->AddPage();
        $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
        $puskesmas = $this->m_rujukan->get_puskesmas_info($this->session->userdata('kd_puskesmas'));
        $kd_trans_pelayanan = $this->uri->segment(3);
        $surat = $this->m_rujukan->get_data_pasien($kd_trans_pelayanan);
        if ($surat['alamat'] == '') {
            $surat['alamat'] = "-";
        }
        if ($surat['umur'] == '') {
            $surat['umur'] = "-";
        }
        if ($surat['jenis_kelamin'] == '') {
            $surat['jenis_kelamin'] = "-";
        }
        if ($surat['idkartu_medical'] == '') {
            $surat['idkartu_medical'] = "-";
        }
        if ($surat['kd_bayar'] == '') {
            $surat['kd_bayar'] = "-";
        }
        if ($surat['no_asuransi'] == '') {
            $surat['no_asuransi'] = "-";
        }
        if ($surat['nm_dokter'] == '') {
            $surat['nm_dokter'] = "_____________________";
        }
        $tgl = date('d-m-Y');
        #echo $this->db->last_query(); exit;
        $html = '<table align="center" border="0" align="left">';
        $html .= '
						<tr>
                        <td width="20%" style="text-align: center;"><img src="' . base_url() . 'assets/img/logo.png" width="80" height="80"/></td>
						
                        <td width="80%" style="text-align: center;"><h4>00/DOK IN PKM - USI/01/PKM/151/2011</h4><br><h3>PEMERINTAH PROPINSI ' . $puskesmas["nm_propinsi"] . '<br>DINAS KESEHATAN KOTA ' . $puskesmas["nm_kota"] . '</h3>
                        <h4>UPTD ' . $puskesmas["nm_puskesmas"] . '<br>' . $puskesmas["alamat"] . '<br>' . $puskesmas["no_telp"] . '</h4>
					    </td>
                    </tr>';
        $html .= '</table>';
        $html .= '<p align="left"><b>Resep Obat</b></p>';
        $html .= '<table align="center" cellpadding="2" cellspacing="0" border="0" width="100%">
    <tr>
        <td width="20%" border="1px" style="text-align: center;">' . $surat["kd_bayar"] . '</td>
        <td width="5%" style="text-align: left;"></td>
        <td width="75%" style="text-align: right;">' . $puskesmas["nm_kota"] . ', ' . $tgl . '</td>
    </tr>
    <tr>
        <td style="text-align: right;" colspan="3">No KK: ' . $surat["idkartu_medical"] . '</td>
    </tr>
	<tr>
        <td style="text-align: right;" colspan="3">No R.M. Pasien: ' . $surat["kd_rekam_medis"] . '</td>
    </tr>
    <tr>
    <td><p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
	<p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
	<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>
    <p>&nbsp;</p></td>
  </tr>
    <tr>
        <td style="text-align: right;" colspan="3">Pemeriksa, </td>
    </tr>
	<tr>
    <td><p>&nbsp;</p>
    <p>&nbsp;</p></td>
  </tr>	
	<tr>
        <td style="text-align: right;" colspan="3">' . $surat["nm_dokter"] . '</td>
    </tr>
	<tr>
        <td width="17%" style="text-align: left;">No. Antrian</td>
        <td width="2%" style="text-align: left;">:</td>
        <td width="81%" style="text-align: left;">' . $surat["no_antrian"] . '</td>
    </tr>
    <tr>
        <td width="17%" style="text-align: left;">Nama</td>
        <td width="2%" style="text-align: left;">:</td>
        <td width="81%" style="text-align: left;">' . $surat["nm_lengkap"] . '</td>
    </tr>
    <tr>
        <td style="text-align: left;">Umur</td>
        <td style="text-align: left;">:</td>
        <td style="text-align: left;">' . $surat["umur"] . '</td>
    </tr>
    <tr>
        <td style="text-align: left;">Alamat</td>
        <td style="text-align: left;">:</td>
        <td style="text-align: left;">' . $surat["alamat"] . ', Kel. ' . ucwords(strtolower($surat["nm_kelurahan"])) . ', Kec. ' . ucwords(strtolower($surat["nm_kecamatan"])) . ' , ' . ucwords(strtolower($surat["nm_kota"])) . '</td>
    </tr>
    <tr>
        <td style="text-align: left;">Status Psn</td>
        <td style="text-align: left;">:</td>
        <td style="text-align: left;">' . $surat["cara_bayar"] . ' , No ' . $surat["no_asuransi"] . '</td>
    </tr>
</table>';
        $pdf->SetTitle('Judul');
        $pdf->SetHeaderMargin(30);
        $pdf->SetTopMargin(20);
        $pdf->setFooterMargin(20);
        $pdf->SetAutoPageBreak(true);
        $pdf->SetAuthor('Pengarang');
        $pdf->SetDisplayMode('real', 'default');
        $pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, '', true);
        $pdf->Output('Resep.pdf', 'I');
    }
Example #10
0
 public function generarSalidaEmpleados()
 {
     $departamento = $this->input->get("departamento") != 'null' ? '=' . $this->input->get("departamento") : 'LIKE "%"';
     $nacionalidad = $this->input->get("nacionalidad") != '' ? "LIKE '%" . $this->input->get("nacionalidad") . "%'" : 'LIKE "%"';
     $cedula = $this->input->get("cedula") != '' ? '=' . $this->input->get("cedula") : 'LIKE "%"';
     $nombre = $this->input->get("nombre") != '' ? "LIKE '%" . $this->input->get("nombre") . "%'" : 'LIKE "%"';
     $apellido = $this->input->get("apellido") != '' ? "LIKE '%" . $this->input->get("apellido") . "%'" : 'LIKE "%"';
     $pdf = new Pdf('l', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH1, PDF_HEADER_TITLE, PDF_HEADER_STRING);
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,'Listado General',PDF_HEADER_STRING,array(0,64,255), array(0,64,128));
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetPageOrientation('p');
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     $pdf->AddPage();
     $html = null;
     $nombre_archivo = null;
     $username = $this->session->userdata('datasession');
     if ($username['idusuario'] == 13) {
         $resultado2 = $this->ReporteGeneral_model->getdptoempleadosdos($nacionalidad, $cedula, $nombre, $apellido, $departamento);
     } else {
         $resultado2 = $this->ReporteGeneral_model->getdptoempleados($nacionalidad, $cedula, $nombre, $apellido, $username['idusuario']);
         $resultado = $this->ReporteGeneral_model->getsalidasempleados($nacionalidad, $cedula, $nombre, $apellido, $username['idusuario']);
     }
     if ($resultado2->num_rows() > 0) {
         foreach ($resultado2->result_array() as $fila2) {
             if ($username['idusuario'] == 13) {
                 $resultado = $this->ReporteGeneral_model->getsalidasempleadosdos($nacionalidad, $cedula, $nombre, $apellido, $fila2['departamento']);
             } else {
                 $resultado = $this->ReporteGeneral_model->getsalidasempleados($nacionalidad, $cedula, $nombre, $apellido, $username['idusuario']);
             }
             $pdf->SetFont('Times', 'B', 14);
             $pdf->Text(14, 25, 'Departamento: ' . $fila2['nombre']);
             $pdf->SetFont('Times', 'B', 12);
             $pdf->Text(50, 35, 'Resumen de autorización(es) por empleado(s).');
             $pdf->Ln(15);
             $pdf->SetFont('times', '', 11, '', true);
             $pdf->SetFillColor('150', '210', '255');
             $pdf->Cell(20, 0, 'Cédula', 1, 0, 'C', 1);
             $pdf->Cell(60, 0, 'Nombres y Apellidos', 1, 0, 'C', 1);
             $pdf->Cell(20, 0, 'Personal', 1, 0, 'C', 1);
             $pdf->Cell(20, 0, 'Laboral', 1, 0, 'C', 1);
             $pdf->Cell(20, 0, 'Medico', 1, 0, 'C', 1);
             $pdf->Cell(20, 0, 'Estudio', 1, 0, 'C', 1);
             $pdf->Cell(20, 0, 'Sindical', 1, 0, 'C', 1);
             $pdf->Cell(10, 0, 'Total', 1, 1, 'C', 1);
             $cedemp = 'null';
             $motivo = array();
             $tot = 0;
             foreach ($resultado->result_array() as $fila) {
                 $tot = $tot + 1;
                 if ($cedemp != $fila['cedula']) {
                     if ($cedemp != 'null') {
                         $result = 0;
                         foreach ($motivo as $re) {
                             if ($re != 0) {
                                 $result = $result + $re;
                             }
                             $pdf->Cell(20, 0, $re, 1, 0, 'C', 0, '', 0);
                         }
                         $pdf->Cell(10, 5, $result, 1, 1, 'C', 1);
                         unset($motivo);
                         $motivo = array();
                         $pdf->Cell(20, 0, $fila['cedula'], 1, 0, 'C', 0, '', 1);
                         $pdf->Cell(60, 0, $fila['nombre'] . ' ' . $fila['apellido'], 1, 0, 'C', 0, '', 1);
                         $mot1 = $fila["Personal"];
                         $mot2 = $fila["Laboral"];
                         $mot3 = $fila["Medico"];
                         $mot4 = $fila["Estudio"];
                         $mot5 = $fila["Sindical"];
                         array_push($motivo, $mot1, $mot2, $mot3, $mot4, $mot5);
                         $cedemp = $fila['cedula'];
                     } else {
                         if ($tot == 1) {
                             $pdf->Cell(20, 0, $fila['cedula'], 1, 0, 'C', 0, '', 1);
                             $pdf->Cell(60, 0, $fila['nombre'] . ' ' . $fila['apellido'], 1, 0, 'C', 0, '', 1);
                             $mot1 = $fila["Personal"];
                             $mot2 = $fila["Laboral"];
                             $mot3 = $fila["Medico"];
                             $mot4 = $fila["Estudio"];
                             $mot5 = $fila["Sindical"];
                             array_push($motivo, $mot1, $mot2, $mot3, $mot4, $mot5);
                             $cedemp = $fila['cedula'];
                         }
                     }
                 } else {
                     if ($motivo[0] == 0 && $fila["Personal"] != '0') {
                         $reemplazo = array(0 => $fila["Personal"]);
                         $motivo = array_replace($motivo, $reemplazo);
                     }
                     if ($motivo[1] == 0 && $fila["Laboral"] != '0') {
                         $reemplazo = array(1 => $fila["Laboral"]);
                         $motivo = array_replace($motivo, $reemplazo);
                     }
                     if ($motivo[2] == 0 && $fila["Medico"] != '0') {
                         $reemplazo = array(2 => $fila["Medico"]);
                         $motivo = array_replace($motivo, $reemplazo);
                     }
                     if ($motivo[3] == 0 && $fila["Estudio"] != '0') {
                         $reemplazo = array(3 => $fila["Estudio"]);
                         $motivo = array_replace($motivo, $reemplazo);
                     }
                     if ($motivo[4] == 0 && $fila["Sindical"] != '0') {
                         $reemplazo = array(4 => $fila["Sindical"]);
                         $motivo = array_replace($motivo, $reemplazo);
                     }
                 }
             }
             $result2 = 0;
             foreach ($motivo as $re) {
                 if ($re != 0) {
                     $result2 = $result2 + $re;
                 }
                 $pdf->Cell(20, 0, $re, 1, 0, 'C', 0, '', 0);
             }
             $pdf->Cell(10, 5, $result2, 1, 1, 'C', 1);
             $pdf->AddPage();
         }
     } else {
         $pdf->SetFont('Times', 'B', 18);
         $pdf->Text(14, 25, 'No se encuentran autorización(es) con las características indicadas.');
     }
     $pdf->Output('resumengeneral.pdf', 'I');
 }
Example #11
0
 public function reporteEstatusPdf()
 {
     $pdf = new Pdf('L', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->setPageOrientation('p');
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, 15, PDF_MARGIN_RIGHT);
     //$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('times', '', 12, '', true);
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     $pdf->AddPage();
     $html = null;
     $reporteEstatus = $this->reporteticket_model->reporteEstatusPDF();
     if ($reporteEstatus) {
         $pdf->Image("imagen/logo/logoborde.png", $x = 5, $y = 5, $w = 70, $h = 40, $type = '', $link = '', $align = 'right', $resize = false, $dpi = 300, $palign = '', $ismask = false, $imgmask = false, $border = 0, $fitbox = false, $hidden = false, $fitonpage = false, $alt = false, $altimgs = array());
         $pdf->Text(120, 15, "República Bolivariana de Venezuela", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
         $pdf->Text(120, 20, "Gobernación del Estado Lara", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
         $pdf->Text(120, 25, "Oficina de Atención al Ciudadano.", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
         $pdf->SetFont('Times', 'B', 12);
         $pdf->Text(60, 50, 'Reporte estadistico del estatus de los Ticket registrados.');
         foreach ($reporteEstatus->result_array() as $fila) {
             $arregloDatos[] = array('estatus' => $fila['estatus'], 'contador' => $fila['contador']);
         }
         $pdf->Ln(10);
         $pdf->SetFillColor('150', '210', '255');
         $pdf->Cell(0, 0, 'Cuadro Resumen', 1, 1, 'C', 1);
         $pdf->Cell(75, 0, 'Tipo ticket', 1, 0, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
         $pdf->Cell(75, 0, 'Sector relacionado', 1, 0, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
         $pdf->Cell(30, 0, 'Cantidad', 1, 1, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
         $reporteCuadro = $this->reporteticket_model->reporteEstatusCuadroPDF();
         foreach ($reporteCuadro as $fila2) {
             $pdf->Cell(75, 0, $fila2->tipo, 1, 0, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
             $pdf->Cell(75, 0, $fila2->sector, 1, 0, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
             $pdf->Cell(30, 0, $fila2->cantidad, 1, 1, 'C', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
             $total = $fila2->total;
         }
         $pdf->Cell(150, 0, 'Total de ticket', 1, 0, 'R', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M');
         $pdf->Cell(30, 0, $total, 1, 1, 'C', 1);
         $pdf->Ln(10);
         $pdf->graficoPDF($arregloDatos, 'Grafico', array(60, '', 90, 100), '');
     } else {
         $pdf->SetFont('Times', 'B', 18);
         $pdf->Text(14, 40, 'No se encuentra información con las características indicadas.');
     }
     $nombre_archivo = utf8_decode("listado.pdf");
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
     $pdf->Output($nombre_archivo, 'I');
 }
 public function generar()
 {
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('Israel Parra');
     $pdf->SetTitle('Ejemplo de provincías con TCPDF');
     $pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
     $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 001', PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     // Establecer el tipo de letra
     //Si tienes que imprimir carácteres ASCII estándar, puede utilizar las fuentes básicas como
     // Helvetica para reducir el tamaño del archivo.
     $pdf->SetFont('freemono', '', 14, '', true);
     // Añadir una página
     // Este método tiene varias opciones, consulta la documentación para más información.
     $pdf->AddPage();
     //fijar efecto de sombra en el texto
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Establecemos el contenido para imprimir
     $matricula = $this->input->post('provincia');
     $provincias = $this->modelo->getIdentificacion($matricula);
     foreach ($provincias as $fila) {
         $prov = $fila['nombre'];
     }
     //preparamos y maquetamos el contenido a crear
     $html = '';
     $html .= "<style type=text/css>";
     $html .= "th{color: #fff; font-weight: bold; background-color: #222}";
     $html .= "td{background-color: #AAC7E3; color: #fff}";
     $html .= "</style>";
     $html .= "<h2>Localidades de " . $prov . "</h2><h4>Actualmente: " . count($provincias) . " localidades</h4>";
     $html .= "<table width='100%'>";
     $html .= "<tr><th>Id localidad</th><th>Localidades</th></tr>";
     //provincias es la respuesta de la función getProvinciasSeleccionadas($provincia) del modelo
     foreach ($provincias as $fila) {
         $id = $fila['ap'];
         $localidad = $fila['am'];
         $html .= "<tr><td class='id'>" . $id . "</td><td class='localidad'>" . $localidad . "</td></tr>";
     }
     $html .= "</table>";
     // Imprimimos el texto con writeHTMLCell()
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     // ---------------------------------------------------------
     // Cerrar el documento PDF y preparamos la salida
     // Este método tiene varias opciones, consulte la documentación para más información.
     $nombre_archivo = utf8_decode("Localidades de " . $prov . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
 function generar()
 {
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetAuthor('Cony Jaramillo');
     $pdf->SetTitle('Combrobante');
     $pdf->SetSubject('Registro Coordinadores y Promotores');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     ob_start();
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
     $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING, array(0, 64, 255), array(0, 1, 0));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     //$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     // Establecer el tipo de letra
     $pdf->SetFont('helvetica', '', 14, '', true);
     // Añadir una página
     // Este método tiene varias opciones, consulta la documentación para más información.
     $pdf->AddPage();
     //fijar efecto de sombra en el texto
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(255, 255, 255), 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Establecemos el contenido para imprimir
     $data['nombre'] = $this->input->post('nombre');
     $data['folio'] = $this->input->post('folio');
     $data['correo'] = $this->input->post('correo');
     $data['fecha'] = $this->input->post('fecha');
     $data['plantel'] = $this->input->post('plantel');
     $data['institucion'] = $this->input->post('institucion');
     $data['tipo_registro'] = $this->input->post('tipo_registro');
     $matricula = $this->input->post('matricula');
     //preparamos y maquetamos el contenido a crear
     $html = "";
     $html .= "<style type=text/css>";
     $html .= " h1 {\n\t\t\t\t\t  \n\t\t\t\t\t    width: 100%;\n\t\t\t\t\t    font-weight: bold;\n\t\t\t\t\t    font-size: 13;\n\t\t\t\t\t    line-height: 2;\n\t\t\t\t\t    text-align: center;\n\t\t\t\t\t    color: #070005;\n\t\t\t\t\t}\n    \t\t\th2{\n    \t\t\t\t\ttext-align: justify;\n    \t\t\t\t\tfont-weight: bold;\n\t\t\t\t\t\tfont-size: 9;\n\t\t\t\t\t\tline-height: 1.5;\n    \t\t\t\t\tcolor:  #070005;\n    \t\t\t\t}\n    \t\t\th3{\n    \t\t\t\tline-height: 3;\n    \t\t\t\ttext-align: center;\n    \t\t\t\tfont-weight: normal;\n    \t\t\t\tfont-size: 9;\n    \t\t\t\t}\n\t\t\t\t\th4{\n    \t\t\t\t\ttext-align: center;\n    \t\t\t\t\tfont-weight: bold;\n\t\t\t\t\t\tfont-size: 10;\n\t\t\t\t\t\tline-height: 1;\n    \t\t\t\t\tcolor: #070005;\n\t\t\t\t}\n    \t\t\t\n    \t\t\th5{\n    \t\t\t\t\ttext-align: justify;\n    \t\t\t\t\tfont-weight: bold;\n\t\t\t\t\t\tfont-size: 10;\n\t\t\t\t\t\tline-height: 4;\n    \t\t\t\t\tcolor:  #070005;\n\t\t\t\t}\n    \t\t\tp {\n    \t\t\t \tline-height: 1.5;\n    \t\t\t\tcolor: #5E5D5D;\n    \t\t\t\tfont-weight: bold;\n\t\t\t\t    text-align: justify;\n\t\t\t\t\t\n    \t\t\t\tfont-size: 9;\n    \t\t\t\t\n\t\t\t\t}\n    \t\t\t\t\n    \t\t\t\n\t\t\t";
     $html .= "</style>";
     $html .= '<h1>COMPROBANTE DE REGISTRO COMO ' . $data['tipo_registro'] . '<br> DEL PROGRAMA PREPA S&Iacute;</h1>';
     $html .= "<p><h5>" . $data['nombre'] . "</h5></p>";
     $html .= '<table border="0">
 			<tr>
 				<td><h2>FECHA DE REGISTRO</h2></td>
 				<td colspan="2"><p>' . $data['fecha'] . '</p></td>
 				
 			</tr>
 			<tr>
 				<td><h2>INSTITUCION</h2></td>
 				<td colspan="2"><p>' . $data['institucion'] . '</p></td>
 			</tr>
 			<tr>
 				<td><h2>PLANTEL</h2></td>
 				<td colspan="2"><p>' . $data['plantel'] . '</p></td>
 			</tr>
 			<tr>
 				<td colspan="3"><h4></h4></td>
 			</tr>
 			<tr>
 				<td colspan="3" bgcolor="#FBEFFB"><h4>FOLIO:   ' . $data['folio'] . '</h4></td>
 				
 			</tr>
 			
 			</table>';
     $html .= "<br><br><br><br><br><h3>Has quedado registrado, te sugerimos estar al pendiente de tu correo: <br> <u>" . $data['correo'] . "</u></h3>";
     // Imprimimos el texto con writeHTMLCell()
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     $estilo = array('padding' => 'auto');
     $tipos = array('C128A');
     for ($i = 0; $i < sizeof($tipos); $i++) {
         $pdf->SetXY(78, 110);
         $pdf->Cell(45, 50, $matricula, 0, 0, 'C');
         $pdf->write1DBarcode($matricula, $tipos[$i], 75, 115, 50, 14, '', $estilo);
     }
     // ---------------------------------------------------------
     // Cerrar el documento PDF y preparamos la salida
     // Este método tiene varias opciones, consulte la documentación para más información.
     $nombre_archivo = utf8_decode("Registro_" . $data['folio'] . ".pdf");
     $pdf->Output($nombre_archivo, 'I');
     ob_end_flush();
 }
Example #14
0
    function make_pdf($PDF_html, $PDF_name='Ads2Trade_Document', $PDF_Title='Ads2Trade Dcoument', $PDF_Orientation="L")
    {
        $CI =& get_instance();
        $CI->load->library('pdf'); // load library (if not already loaded - CI will handle this check for us though)

        // create new PDF document
        //$pdf = new TCPDF($PDF_Orientation, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
        $pdf = new Pdf($PDF_Orientation, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

        $html = $PDF_html;

        //Make sure orientation is valid i.e. either P or L
        if($PDF_Orientation != 'P' && $PDF_Orientation != 'L'){
            $PDF_Orientation = 'L'; //default to landscape if invalid value supplied
        }

        $pdf->setPageOrientation($PDF_Orientation); //custom class seemed to not be picking up orientation in constructor

        if($PDF_name == '' or  is_null($PDF_name)){
            $PDF_name = 'Ads2Trade_Document'; //default to landscape if invalid value supplied
        }

        // set document information
        //$pdf->SetCreator(PDF_CREATOR);
        $pdf->SetCreator("Ads2Trade");
        $pdf->SetAuthor('Ads2Trade');
        $pdf->SetTitle('Ads2Trade Document Title Goes Here');
        $pdf->SetSubject('Ads2Trade');
        $pdf->SetKeywords('Ads2Trade, PDF, asset, auction, advertising');

        // set default header data
        $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, $PDF_Title, PDF_HEADER_STRING);

        // set header and footer fonts
        $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

        // set default monospaced font
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

        // set margins
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

        // set auto page breaks
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

        // set image scale factor
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

        // set some language-dependent strings (optional)
        if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
            require_once(dirname(__FILE__).'/lang/eng.php');
            $pdf->setLanguageArray($l);
        }


        // ---------------------------------------------------------

        // set font
        $pdf->SetFont('dejavusans', '', 10);

        // add a page
        $pdf->AddPage();

        // create some HTML content
        if (is_null($html) or ($html == '')) {
                $html = '<!DOCTYPE html>
                <html>
                  <head>
                  <title></title>
                          <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
                  </head>
                 <body>
                     <p>ERROR: No Document Data Supplied</p>
                 </body>
                 </html>';

        }

        // output the HTML content
        $pdf->writeHTML($html, true, false, true, false, '');


        // reset pointer to the last page
        $pdf->lastPage();

        // ---------------------------------------------------------

        //Close and output PDF document
        $pdf->Output($PDF_name.'.pdf', 'I');

    }
Example #15
0
    public function generarListadogendis()
    {
        $nacionalidad = $this->input->get("nacionalidad") != '' ? "LIKE '%" . $this->input->get("nacionalidad") . "%'" : 'LIKE "%"';
        $ceduladisca = $this->input->get("cedula") != '' ? '=' . $this->input->get("cedula") : 'LIKE "%"';
        $nombre = $this->input->get("nombre") != '' ? "LIKE '%" . $this->input->get("nombre") . "%'" : 'LIKE "%"';
        $apellido = $this->input->get("apellido") != '' ? "LIKE '%" . $this->input->get("apellido") . "%'" : 'LIKE "%"';
        $edocivil = $this->input->get("edocivil") != 'null' ? '=' . $this->input->get("edocivil") : 'LIKE "%"';
        $edad = $this->input->get("edad") != 'null' ? '=' . $this->input->get("edad") : '>= 0';
        $municipio = $this->input->get("municipio") != 'null' ? '=' . $this->input->get("municipio") : 'LIKE "%"';
        $parroquia = $this->input->get("parroquia") != 'null' ? '=' . $this->input->get("parroquia") : 'LIKE "%"';
        $sexo = $this->input->get("sexo") != 'null' ? '=' . $this->input->get("sexo") : 'LIKE "%"';
        $direccion = $this->input->get("direccion") != 'null' ? '=' . $this->input->get("direccion") : 'LIKE "%"';
        $institucion = $this->input->get("institucion") != 'null' ? '=' . $this->input->get("institucion") : 'LIKE "%"';
        $poseeinforme = $this->input->get("poseeinforme") != 'null' ? '=' . $this->input->get("poseeinforme") : 'LIKE "%"';
        $condiciondis = $this->input->get("condiciondis") != 'null' ? '=' . $this->input->get("condiciondis") : 'LIKE "%"';
        $medicamentos = $this->input->get("medicamentos") != 'null' ? '=' . $this->input->get("medicamentos") : 'LIKE "%"';
        $tipodiscapacidad = $this->input->get("tipodiscapacidad") != 'null' ? '=' . $this->input->get("tipodiscapacidad") : 'LIKE "%"';
        $requiereayuda = $this->input->get("requiereayuda") != 'null' ? '=' . $this->input->get("requiereayuda") : 'LIKE "%"';
        $ayuda = $this->input->get("ayuda") != 'null' ? '=' . $this->input->get("ayuda") : 'LIKE "%"';
        $tipovivienda = $this->input->get("tipovivienda") != 'null' ? '=' . $this->input->get("tipovivienda") : 'LIKE "%"';
        $status = $this->input->get("status") != 'null' ? '=' . $this->input->get("status") : 'LIKE "%"';
        $pdf = new Pdf('l', 'mm', 'A4', true, 'UTF-8', false);
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetSubject('Tutorial TCPDF');
        $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
        //$pdf->SetHeaderData(PDF_HEADER_LOGO,PDF_HEADER_LOGO_WIDTH,PDF_HEADER_LOGO_WIDTH1,PDF_HEADER_TITLE ,PDF_HEADER_STRING,array(0,64,255),array(0,64, 128));
        $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
        // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
        //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
        $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH1, PDF_HEADER_TITLE, PDF_HEADER_STRING);
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        $pdf->SetPageOrientation('l');
        $pdf->SetFillColorArray('');
        // se pueden modificar en el archivo tcpdf_config.php de libraries/config
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        // se pueden modificar en el archivo tcpdf_config.php de libraries/config
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        // se pueden modificar en el archivo tcpdf_config.php de libraries/config
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        //relación utilizada para ajustar la conversión de los píxeles
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        // establecer el modo de fuente por defecto
        $pdf->setFontSubsetting(true);
        $pdf->SetFont('times', '', 10, '', true);
        $pdf->AddPage();
        $html = null;
        $nombre_archivo = null;
        // Establecemos el contenido para imprimir
        $resultado1 = $this->Repplanilla_model->getdiscapacidad($status, $nacionalidad, $ceduladisca, $direccion, $nombre, $apellido, $edocivil, $edad, $municipio, $parroquia, $sexo, $institucion, $tipodiscapacidad, $ayuda, $requiereayuda, $poseeinforme, $condiciondis, $medicamentos);
        if ($resultado1) {
            $html = '';
            $html .= "<style type=text/css>";
            $html .= "th{color: black; font-weight: bold; background-color:#AAC7E3; align=center}";
            $html .= "td{ color: #222; align=center}";
            $html .= "p.saltodepagina{display: block; page-break-before: always}";
            $html .= "</style>";
            foreach ($resultado1 as $fila) {
                $html .= '
				<table border="1" >
					<tr><th colspan="6"><h3>I. Identificación de la Persona con Discapacidad</h3></th>
					</tr>
					<tr align="center" bgcolor="#DCDCDC">
						<td><b>Cédula</b></td>
						<td colspan="2"><b>Nombres y Apellidos</b></td>
						<td><b>Sexo</b></td>
						<td><b>Edo. Civil</b></td>
						<td><br><b>Posee Partida</b></td>	
					</tr>
					<tr align="center">
						<td>
						' . mb_convert_case($fila['nacionalidad'], MB_CASE_TITLE, "UTF-8") . '
						-
						' . mb_convert_case($fila['cedula'], MB_CASE_TITLE, "UTF-8") . '
						</td>
						<td  colspan="2" align="justify">' . mb_convert_case($fila['nombres'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['sexo'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . $fila['edocivil'] . '</td>
						<td>' . mb_convert_case($fila['poseepartida'], MB_CASE_TITLE, "UTF-8") . '</td>	
					</tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td><b>Teléfono Móvil </b></td>
						<td colspan="2"><br><b>Municipio</b></td>
						<td colspan="2"><b>Parroquia</b></td>
						<td><br><b>Fecha Nac.</b></td>
					</tr>
					<tr align="left">
						<td align="center">' . $fila['movil'] . '</td>
						<td colspan="2">' . mb_convert_case($fila['municipio'], MB_CASE_TITLE, "UTF-8") . ' </td>
						<td colspan="2">' . mb_convert_case($fila['parroquia'], MB_CASE_TITLE, "UTF-8") . ' </td>
						<td align="center">' . $fila['fechanac'] . '</td>
					</tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td><b>Teléfono Local</b></td>
						<td colspan="4"><b>Dirección</b></td>
						<td><b>Edad</b></td>
					</tr>
					<tr align="justify">
						<td align="center">' . $fila['fijo'] . '</td>
						<td colspan="4">' . mb_convert_case($fila['direccion'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td align="center">
						' . $fila['edaddis'] . ' año(s) y ' . $fila['meses'] . ' mes(es)</td>
					</tr>
					<tr><th colspan="6" align="center"><h3>II. Caracteristícas Socio-Familiar de la Persona con Discapacidad</h3></th></tr> 
					<tr align="center" bgcolor="#DCDCDC">
						<td><b>CI Responsable</b></td>
						<td colspan="2"><b>Nombres y Apellidos del Responsable</b></td>
						<td colspan="3"><b>Dirección</b></td>
					</tr>
					<tr align="left">
						<td align="center">' . $fila['cedularesponsable'] . '</td>
						<td colspan="2">' . mb_convert_case($fila['nombresresponsable'], MB_CASE_TITLE, "UTF-8") . ' </td>
						<td colspan="3" align="justify">' . mb_convert_case($fila['direccionresponsable'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td><b>Tipo Vivienda</b></td>
						<td><b>Tenencia Vivienda</b></td>
						<td><b>Parentesco</b></td>
						<td><b>Padres Vivos</b></td>
						<td>
						<b>Nro. Personas</b>
						</td>
						<td><b>Convive con el Discapacitado</b></td>
					</tr> 
					<tr>
						<td>' . mb_convert_case($fila['tipovivienda'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['tenenciavivienda'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['familiardirecto'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['parentescofamiliar'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td align="left">
						Habitantes:' . $fila['numerohabitantes'] . '
					    Trabajan:' . $fila['numerotrabajan'] . '</td>
						<td>' . $fila['convivenciadiscapa'] . '</td>
					</tr> 
					<tr><th colspan="6" align="center"><h3>III. Caracteristícas de la Discapacidad</h3></th></tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td><br><b>Condición/Discapacidad</b></td>
						<td><br><b>Tipo Discapacidad</b></td> 
						<td colspan="2"><br><b>Diagnóstico Tipo Discapacidad</b></td>
						<td><br><b>Certificado Informe Médico</b></td>
						<td><br><b>Estatus</b></td>
					</tr>
						<tr align="left">
						<td align="center">' . mb_convert_case($fila['condicion'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td align="center">' . mb_convert_case($fila['tipodis'], MB_CASE_TITLE, "UTF-8") . '</td> 
						<td colspan="2">' . mb_convert_case($fila['describirtipodisca'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td align="center">' . mb_convert_case($fila['poseeinforme'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td align="center">' . mb_convert_case($fila["status"], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					<tr align="center"  bgcolor="#DCDCDC">
						
						<td><b>Requiere  Medicamento</b></td>
						<td colspan="2"><br><b>Nombre de los Medicamentos</b></td>
						<td><br><b>Requiere Ayuda</b></td>
						<td colspan="2"><br><b>Nombre de la Ayuda</b></td>
					</tr>
					<tr align="center"> 
						<td>' . mb_convert_case($fila['usamedica'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['nombremedica'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['requiereayuda'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['nombreayuda'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					<tr><th colspan="6" align="center"><h3>IV. Nivel Educativo de la Persona con Discapacidad</h3></th></tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td ><b>Grado de instrucción</b></td>
						<td colspan="2"><b>Deseo de continuar Estudiando</b></td>
						<td colspan="2"><b>Condiciones para seguir Estudiando</b></td>
						<td><b>Limitación de Estudio</b></td>
					</tr>
					<tr align="center">
						<td>' . mb_convert_case($fila['gradoinstruccion'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['deseoestudio'], MB_CASE_TITLE, "UTF-8") . '</td> 
						<td colspan="2">' . mb_convert_case($fila['condicionestudio'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['nombrelimitacion'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
				</table>';
                $resultado2 = $this->Repplanilla_model->getnivelocupacional($fila['cedula']);
                foreach ($resultado2 as $fila) {
                    $html .= '	
					<table border="1">
					<tr><th colspan="6" align="center"><h3>V. Nivel Ocupacional de la Persona con Discapacidad</h3></th></tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td><b>Habilidad o Destreza</b></td>
						<td><b>Posee Experiencia</b></td> 
						<td colspan="2"><b>Experiencia Laboral</b></td>
						<td><b>Act. Recreativa/Deportiva</b></td>
						<td><b>Nombre de la Actividad</b></td>
					</tr>
					<tr align="center">
						<td>' . mb_convert_case($fila['habilidaddis'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['experiencialaboral'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['descripcionexperiencia'], MB_CASE_TITLE, "UTF-8") . '</td> 
						<td>' . mb_convert_case($fila['actividadrecdep'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['indiqueactividad'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					<tr align="center"  bgcolor="#DCDCDC">
					    <td><b>Desarrolla Actividad</b></td>
					    <td><b>Tipo Actividad Productiva</b></td>
						<td><b>Condiciones para Aprender Oficio</b></td>
						<td><b>Manifiesta Deseo de Aprender</b></td>
						<td colspan="2"><br><b>Tipo de Oficio que le Gustaría Aprender</b></td>
					</tr>
					<tr align="center">
						<td>' . mb_convert_case($fila['realizaactividad'], MB_CASE_TITLE, "UTF-8") . '</td>
					    <td>' . mb_convert_case($fila['actproductiva'], MB_CASE_TITLE, "UTF-8") . '</td>	
						<td>' . mb_convert_case($fila['condicionaprender'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['deseoaprender'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['oficioocup'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					<tr><th colspan="6" align="center"><h3>VI. Nivel de Apoyo Institucional para la Persona con Discapacidad</h3></th></tr>
					<tr align="center"  bgcolor="#DCDCDC">
						<td colspan="2"><br><b>Institución de Apoyo</b></td> 
						<td colspan="2"><b>Nombre completo de la Institución</b></td>
						<td colspan="2"><b>Tipo de Ayuda Prestada</b></td>
					</tr>
					<tr align="center">
						<td colspan="2">' . mb_convert_case($fila['nombreinstapoyo'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2"  align="left" >' . mb_convert_case($fila['nombrecompletoindt'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['tipoayuda'], MB_CASE_TITLE, "UTF-8") . '</td> 
					</tr>
				
						<tr align="center"  bgcolor="#DCDCDC">
						<td><b>Existe Consejo Comunal</b></td>
						<td colspan="2"><br><b>Consejo Comunal en su Sector</b></td>
						<td><b>Existe Comité Comunitario</b></td>
						<td colspan="2"><b>Comité Comunitario en su Sector</b></td>
					</tr>
					<tr align="center">
						<td>' . mb_convert_case($fila['existeconsejo'], MB_CASE_TITLE, "UTF-8") . '</td> 
						<td colspan="2">' . mb_convert_case($fila['nombreconsejo'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td>' . mb_convert_case($fila['existecomite'], MB_CASE_TITLE, "UTF-8") . '</td>
						<td colspan="2">' . mb_convert_case($fila['nombrecomite'], MB_CASE_TITLE, "UTF-8") . '</td>
					</tr>
					</table>';
                    $resultado3 = $this->Repplanilla_model->getusuario($fila['cedula']);
                    foreach ($resultado3 as $fila) {
                        $html .= '	
					<table border="1">
						<tr><th colspan="6" align="center"><h3>Información de la Persona que Elaboro el Registro</h3></th></tr>
						<tr align="center"  bgcolor="#DCDCDC">
							<td><b>Cédula</b></td>
							<td colspan="3"><br><b>Nombre y Apellido</b></td> 
							<td><b>Teléfono</b></td>
							<td><b>Fecha del Registro</b></td>
							
						</tr>
					   <tr align="center">	
							<td>' . mb_convert_case($fila['cedulausuario'], MB_CASE_TITLE, "UTF-8") . '</td>
							<td colspan="3">' . mb_convert_case($fila['nombresusuario'], MB_CASE_TITLE, "UTF-8") . '</td> 
							<td>' . mb_convert_case($fila['telfusuario'], MB_CASE_TITLE, "UTF-8") . '</td>
							<td>' . mb_convert_case($fila['fecharegistro'], MB_CASE_TITLE, "UTF-8") . '</td>	
						</tr>
					</table><br><br><br>';
                    }
                }
            }
            $nombre_archivo = utf8_decode("Planilla Discapacitados.pdf");
        } else {
            $html = '';
            $html .= "<style type=text/css>";
            $html .= "th{color: #fff; font-weight: bold; background-color: #AAC7E3}";
            $html .= "td{background-color: #fff; color: #222}";
            $html .= "</style>";
            $html .= "<h4>Planilla de Personas con Discapacidad</h4>";
            $html .= "<table width='100%'>";
            $html .= "<tr><th>No hay Personas con Discapacidad con las caracteristicas indicadas</th></tr>";
            $html .= "</table>";
            $nombre_archivo = utf8_decode("Planilla de Personas con Discapacidad.pdf");
        }
        $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
        $pdf->Output($nombre_archivo, 'I');
    }
Example #16
0
    function index()
    {
        date_default_timezone_set('Australia/NSW');
        $ImageW = 105;
        //WaterMark Size
        $ImageH = 30;
        $id_user = $this->uri->segment(2);
        $created_at = urldecode($this->uri->segment(3));
        $display_name = $this->session->userdata('display_name');
        $getOrganization = $this->survey_model->get_organization($id_user);
        $getsurveydetails = $this->survey_model->getsurveydetails($id_user, $created_at);
        $getsurveydetail = unserialize($getsurveydetails);
        $this->load->library('Pdf');
        $pdf = new Pdf(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
        // set document information
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetAuthor('AMIT');
        $pdf->SetTitle('SMG Health Survey Report');
        $pdf->SetSubject('Survey Report');
        $pdf->SetKeywords('SMG Health Survey Report ');
        // set header and footer fonts
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        // set default monospaced font
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        // set margins
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP - 15, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        // set auto page breaks
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        // set image scale factor
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        // set some language-dependent strings (optional)
        if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
            require_once dirname(__FILE__) . '/lang/eng.php';
            $pdf->setLanguageArray($l);
        }
        $pdf->SetFont('freeserif', '', 48);
        // remove default header
        $pdf->setPrintHeader(false);
        // add a page
        $pdf->AddPage();
        // get the current page break margin
        $bMargin = $pdf->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $pdf->getAutoPageBreak();
        // disable auto-page-break
        $pdf->SetAutoPageBreak(false, 0);
        // set bacground image
        $img_file = Base_url() . 'assets/site/images/coverImage.jpg';
        $pdf->Image($img_file, 0, 0, 210, 297, '', '', '', false, 400, '', false, false, 0);
        // restore auto-page-break status
        $pdf->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content
        $pdf->setPageMark();
        // Print a text
        $html = '<div style="position: relative; right:0; left:0; text-align:center; padding: 50px 15px;">
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">SMG Health Bounce Back Survey</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                    <h1 style="margin: 100px 0 0px; color: #000; font-weight: 500;font-size: 24px; text-transform: capitalize;">' . $getOrganization . '</h1>
                                    <h1 style="margin: 0 0 20px; color: #000; font-weight: 500;font-size: 18px;">' . $created_at . '</h1>
                                </div>';
        $pdf->writeHTML($html, true, false, true, false, '');
        // ---------------------------------------------------------
        $img_file = Base_url() . 'assets/site/images/innerbanner.jpg';
        $pdf->AddPage();
        $myPageWidth = $pdf->getPageWidth();
        $myPageHeight = $pdf->getPageHeight();
        $myX = $myPageWidth / 2 - 50;
        $myY = $myPageHeight / 2 - 40;
        $pdf->SetAlpha(0.09);
        $pdf->Image(Base_url() . 'assets/site/images/dase_logo.png', $myX, $myY, $ImageW, $ImageH, '', '', '', true, 150);
        $pdf->SetAlpha(1);
        $pdf->Image($img_file, 0, 0, 210, 47, '', '', '', false, 300, '', false, false, 0);
        $pdf->SetDrawColor(255, 0, 0);
        $content = '<table cellspacing="0" cellpadding="0">
            <tr><td><img title="" alt="" src="' . Base_url() . 'assets/site/images/dase_logo.png"></td></tr>
            <tr><td>' . $display_name . '</td></tr>
            <tr><td>' . $created_at . '</td></tr>
            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>
        </table>';
        $content .= '<div style="padding: 30px;">
                                <p style="margin: 0 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Introduction</p>
                                <p>Thank you for completing your Bounce Back Survey. This report provides you with a summary of your results, makes some personalised recommendations and provides you with the tools to create an action plan.</p>
                                <p>Each dimension is presented individually with a description of your results and strategies for strengthening.</p>
                                <p style="margin: 5px 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Understanding Your Report</p>
                                <p>Your report contains a description of the 10 dimensions of resilience for which you were assessed.  Your individual assessment results for each dimension is presented as a flag.  Refer to the table below when reading your report.</p>
                                <p>Red flag: <img src="' . Base_url() . 'assets/site/images/close_icon.jpg" height="25" alt="">
                                &nbsp;&nbsp;&nbsp;Green Flag:<img src="' . Base_url() . 'assets/site/images/tick_icon.jpg" height="25" alt=""></p>
                                <p style="margin: 5px 0 10px; color: #424242; font-weight: 500; font-size: 20px;">Summary of Results</p>
                                <table style="text-align: left;">
                                    <thead>
                                        <tr>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:200px">Name</th>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 1</th>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 2</th>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 3</th>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 4</th>
                                            <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>';
        $grandtotal = 0;
        //$content.='<table cellspacing="0" cellpadding="5" border="1">';
        // $content.='<tr><td width="25%"><strong>Dimension</strong></td><td width="10%"><strong>Score</strong></td><td width="65%"><strong>Comment</strong></td></tr>';
        foreach ($getsurveydetail as $key => $value) {
            $getcategory = $this->survey_model->getcategory($key);
            $getvalue1 = $this->survey_model->getvalue($value[0]);
            $getvalue2 = $this->survey_model->getvalue($value[1]);
            $getvalue3 = $this->survey_model->getvalue($value[2]);
            $getvalue4 = $this->survey_model->getvalue($value[3]);
            $getQuestion = $this->survey_model->getQuestion($value[3]);
            $total = $getvalue1 + $getvalue2 + $getvalue3 + $getvalue4;
            $grandtotal = $grandtotal + $total;
            $content .= '
                                        <tr>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; background-color:#f5f5f5; width:200px">' . $getQuestion . '</td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue1 . '</td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue2 . '</td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue3 . '</td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue4 . '</td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $total . '</td>
                                        </tr>';
        }
        $content .= '               </tbody>
                                    <tfoot>
                                        <tr>
                                            <td style="padding:3px; border: solid 1px #e0e0e0;" colspan="5"></td>
                                            <td style="padding:3px; border: solid 1px #e0e0e0;background-color:#B72529; color:#fff;">' . $grandtotal . '</td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>';
        // $content.='<p style="padding: 75px 15px 0;text-align:center; border-top: solid 1px #E0E0E0; font-size: 10px;">&nbsp;<br>© 2016. SMG Health. All rights reserved.</p>';
        $pdf->SetFont('freeserif', '', 12);
        $pdf->setTextRenderingMode($stroke = 0, $fill = true, $clip = false);
        //$pdf->writeHTMLCell(0, 10, '© 2016. SMG Health. All rights reserved.', 0, false, 'C', 0, '', 0, false, 'T', 'M');
        $pdf->writeHTML($content, true, false, false, false, '');
        foreach ($getsurveydetail as $key => $value) {
            $getcategory = $this->survey_model->getcategory($key);
            $getvalue1 = $this->survey_model->getvalue($value[0]);
            $getvalue2 = $this->survey_model->getvalue($value[1]);
            $getvalue3 = $this->survey_model->getvalue($value[2]);
            $getvalue4 = $this->survey_model->getvalue($value[3]);
            $getQuestion = $this->survey_model->getQuestion($value[3]);
            $total = $getvalue1 + $getvalue2 + $getvalue3 + $getvalue4;
            $getFeedback = $this->survey_model->getFeedback($getQuestion, $total);
            $pdf->AddPage();
            $myPageWidth = $pdf->getPageWidth();
            $myPageHeight = $pdf->getPageHeight();
            $myX = $myPageWidth / 2 - 50;
            $myY = $myPageHeight / 2 - 40;
            $pdf->SetAlpha(0.09);
            $pdf->Image(Base_url() . 'assets/site/images/dase_logo.png', $myX, $myY, $ImageW, $ImageH, '', '', '', true, 150);
            $pdf->SetAlpha(1);
            // set the starting point for the page content
            $pdf->setPageMark();
            $pdf->Image($img_file, 0, 0, 210, 47, '', '', '', false, 300, '', false, false, 0);
            // set color for text stroke
            $pdf->SetDrawColor(255, 0, 0);
            $content = '<table cellspacing="0" cellpadding="0">
                <tr><td><img title="" alt="" src="' . Base_url() . 'assets/site/images/dase_logo.png"></td></tr>
                <tr><td>' . $display_name . '</td></tr>
                <tr><td>' . $created_at . '</td></tr>
                <tr><td>&nbsp;</td></tr>
                <tr><td>&nbsp;</td></tr>
            </table>';
            if ($total > 13) {
                $icon = "tick_icon.jpg";
            } else {
                $icon = "close_icon.jpg";
            }
            $content .= '<div style="padding: 30px;">
                        <p style="margin: 0 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Interpretation of scores</p>';
            $content .= '<div style="padding:0 0 30px;">
                                    <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Dimension :</span>' . $getQuestion . '</h3>
                                    <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Score :</span>' . $total . '</h3>
                                    <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Comment :</span><img src="' . Base_url() . 'assets/site/images/' . $icon . '" alt=""></h3>
                                    <div style="margin-left:200px;">
                                        ' . $getFeedback . '
                                    </div>
                                </div>
';
            $pdf->SetFont('freeserif', '', 12);
            $pdf->setTextRenderingMode($stroke = 0, $fill = true, $clip = false);
            //$pdf->writeHTMLCell(0, 10, '© 2016. SMG Health. All rights reserved.', 0, false, 'C', 0, '', 0, false, 'T', 'M');
            $pdf->writeHTML($content, true, false, false, false, '');
        }
        $pdf->Output('example.pdf', 'I');
    }
Example #17
0
 public function index()
 {
     if ($this->input->post('action') != NULL && $this->input->post('action') == 'user_survey') {
         if ($cats = $this->questionnaire_model->get_question_cats()) {
             foreach ($cats as $cat) {
                 $data[$cat->id_questionnaire] = array();
                 if ($questions = $this->questionnaire_model->get_questionnaire($cat->id_questionnaire)) {
                     foreach ($questions as $q) {
                         $data[$cat->id_questionnaire][] = $this->input->post('answer_' . $q->question_no);
                     }
                 }
             }
         }
         $survey_data = serialize($data);
         $created_at = date(DATETIME_DATABASE_FORMAT);
         $table_data = array('id_user' => $this->session->userdata('id_user'), 'survey_data' => $survey_data, 'created_at' => $created_at);
         if ($this->site_model->insert('smg_survey', $table_data)) {
             date_default_timezone_set('Australia/NSW');
             $ImageW = 105;
             //WaterMark Size
             $ImageH = 30;
             $id_user = $this->session->userdata('id_user');
             $display_name = $this->session->userdata('display_name');
             $getOrganization = $this->survey_model->get_organization($id_user);
             $getsurveydetails = $this->survey_model->getsurveydetails($id_user, $created_at);
             $getsurveydetail = unserialize($getsurveydetails);
             $this->load->library('Pdf');
             $pdf = new Pdf(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
             // set document information
             $pdf->SetCreator(PDF_CREATOR);
             $pdf->SetAuthor('AMIT');
             $pdf->SetTitle('SMG Health Survey Report');
             $pdf->SetSubject('Survey Report');
             $pdf->SetKeywords('SMG Health Survey Report ');
             // set header and footer fonts
             $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
             // set default monospaced font
             $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
             // set margins
             $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP - 15, PDF_MARGIN_RIGHT);
             $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
             $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
             // set auto page breaks
             $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
             // set image scale factor
             $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
             // set some language-dependent strings (optional)
             if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
                 require_once dirname(__FILE__) . '/lang/eng.php';
                 $pdf->setLanguageArray($l);
             }
             $pdf->SetFont('freeserif', '', 48);
             // remove default header
             $pdf->setPrintHeader(false);
             // add a page
             $pdf->AddPage();
             // get the current page break margin
             $bMargin = $pdf->getBreakMargin();
             // get current auto-page-break mode
             $auto_page_break = $pdf->getAutoPageBreak();
             // disable auto-page-break
             $pdf->SetAutoPageBreak(false, 0);
             // set bacground image
             $img_file = Base_url() . 'assets/site/images/coverImage.jpg';
             $pdf->Image($img_file, 0, 0, 210, 297, '', '', '', false, 400, '', false, false, 0);
             // restore auto-page-break status
             $pdf->SetAutoPageBreak($auto_page_break, $bMargin);
             // set the starting point for the page content
             $pdf->setPageMark();
             // Print a text
             $html = '<div style="position: relative; right:0; left:0; text-align:center; padding: 50px 15px;">
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">SMG Health Bounce Back Survey</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 0 0 20px; color: #333; font-weight: 500;font-size: 40px;">&nbsp;</h1>
                                         <h1 style="margin: 100px 0 0px; color: #000; font-weight: 500;font-size: 24px; text-transform: capitalize;">' . $getOrganization . '</h1>
                                         <h1 style="margin: 0 0 20px; color: #000; font-weight: 500;font-size: 18px;">' . $created_at . '</h1>
                                     </div>';
             $pdf->writeHTML($html, true, false, true, false, '');
             // ---------------------------------------------------------
             $img_file = Base_url() . 'assets/site/images/innerbanner.jpg';
             $pdf->AddPage();
             $myPageWidth = $pdf->getPageWidth();
             $myPageHeight = $pdf->getPageHeight();
             $myX = $myPageWidth / 2 - 50;
             $myY = $myPageHeight / 2 - 40;
             $pdf->SetAlpha(0.09);
             $pdf->Image(Base_url() . 'assets/site/images/dase_logo.png', $myX, $myY, $ImageW, $ImageH, '', '', '', true, 150);
             $pdf->SetAlpha(1);
             $pdf->Image($img_file, 0, 0, 210, 47, '', '', '', false, 300, '', false, false, 0);
             $pdf->SetDrawColor(255, 0, 0);
             $content = '<table cellspacing="0" cellpadding="0">
                 <tr><td><img title="" alt="" src="' . Base_url() . 'assets/site/images/dase_logo.png"></td></tr>
                 <tr><td>' . $display_name . '</td></tr>
                 <tr><td>' . $created_at . '</td></tr>
                 <tr><td>&nbsp;</td></tr>
                 <tr><td>&nbsp;</td></tr>
             </table>';
             $content .= '<div style="padding: 30px;">
                                     <p style="margin: 0 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Introduction</p>
                                     <p>Thank you for completing your Bounce Back Survey. This report provides you with a summary of your results, makes some personalised recommendations and provides you with the tools to create an action plan.</p>
                                     <p>Each dimension is presented individually with a description of your results and strategies for strengthening.</p>
                                     <p style="margin: 5px 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Understanding Your Report</p>
                                     <p>Your report contains a description of the 10 dimensions of resilience for which you were assessed.  Your individual assessment results for each dimension is presented as a flag.  Refer to the table below when reading your report.</p>
                                     <p>Red flag: <img src="' . Base_url() . 'assets/site/images/close_icon.jpg" height="25" alt="">
                                     &nbsp;&nbsp;&nbsp;Green Flag:<img src="' . Base_url() . 'assets/site/images/tick_icon.jpg" height="25" alt=""></p>
                                     <p style="margin: 5px 0 10px; color: #424242; font-weight: 500; font-size: 20px;">Summary of Results</p>
                                     <table style="text-align: left;">
                                         <thead>
                                             <tr>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:200px">Name</th>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 1</th>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 2</th>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 3</th>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Question 4</th>
                                                 <th style="padding:3px; border: solid 1px #e0e0e0; background-color:#18A7A5;color:#fff; width:90px">Total</th>
                                             </tr>
                                         </thead>
                                         <tbody>';
             $grandtotal = 0;
             //$content.='<table cellspacing="0" cellpadding="5" border="1">';
             // $content.='<tr><td width="25%"><strong>Dimension</strong></td><td width="10%"><strong>Score</strong></td><td width="65%"><strong>Comment</strong></td></tr>';
             foreach ($getsurveydetail as $key => $value) {
                 $getcategory = $this->survey_model->getcategory($key);
                 $getvalue1 = $this->survey_model->getvalue($value[0]);
                 $getvalue2 = $this->survey_model->getvalue($value[1]);
                 $getvalue3 = $this->survey_model->getvalue($value[2]);
                 $getvalue4 = $this->survey_model->getvalue($value[3]);
                 $getQuestion = $this->survey_model->getQuestion($value[3]);
                 $total = $getvalue1 + $getvalue2 + $getvalue3 + $getvalue4;
                 $grandtotal = $grandtotal + $total;
                 $content .= '
                                             <tr>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; background-color:#f5f5f5; width:200px">' . $getQuestion . '</td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue1 . '</td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue2 . '</td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue3 . '</td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $getvalue4 . '</td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0; width:90px">' . $total . '</td>
                                             </tr>';
             }
             $content .= '               </tbody>
                                         <tfoot>
                                             <tr>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0;" colspan="5"></td>
                                                 <td style="padding:3px; border: solid 1px #e0e0e0;background-color:#B72529; color:#fff;">' . $grandtotal . '</td>
                                             </tr>
                                         </tfoot>
                                     </table>
                                 </div>';
             // $content.='<p style="padding: 75px 15px 0;text-align:center; border-top: solid 1px #E0E0E0; font-size: 10px;">&nbsp;<br>© 2016. SMG Health. All rights reserved.</p>';
             $pdf->SetFont('freeserif', '', 12);
             $pdf->setTextRenderingMode($stroke = 0, $fill = true, $clip = false);
             //$pdf->writeHTMLCell(0, 10, '© 2016. SMG Health. All rights reserved.', 0, false, 'C', 0, '', 0, false, 'T', 'M');
             $pdf->writeHTML($content, true, false, false, false, '');
             foreach ($getsurveydetail as $key => $value) {
                 $getcategory = $this->survey_model->getcategory($key);
                 $getvalue1 = $this->survey_model->getvalue($value[0]);
                 $getvalue2 = $this->survey_model->getvalue($value[1]);
                 $getvalue3 = $this->survey_model->getvalue($value[2]);
                 $getvalue4 = $this->survey_model->getvalue($value[3]);
                 $getQuestion = $this->survey_model->getQuestion($value[3]);
                 $total = $getvalue1 + $getvalue2 + $getvalue3 + $getvalue4;
                 $getFeedback = $this->survey_model->getFeedback($getQuestion, $total);
                 $pdf->AddPage();
                 $myPageWidth = $pdf->getPageWidth();
                 $myPageHeight = $pdf->getPageHeight();
                 $myX = $myPageWidth / 2 - 50;
                 $myY = $myPageHeight / 2 - 40;
                 $pdf->SetAlpha(0.09);
                 $pdf->Image(Base_url() . 'assets/site/images/dase_logo.png', $myX, $myY, $ImageW, $ImageH, '', '', '', true, 150);
                 $pdf->SetAlpha(1);
                 // set the starting point for the page content
                 $pdf->setPageMark();
                 $pdf->Image($img_file, 0, 0, 210, 47, '', '', '', false, 300, '', false, false, 0);
                 // set color for text stroke
                 $pdf->SetDrawColor(255, 0, 0);
                 $content = '<table cellspacing="0" cellpadding="0">
                     <tr><td><img title="" alt="" src="' . Base_url() . 'assets/site/images/dase_logo.png"></td></tr>
                     <tr><td>' . $display_name . '</td></tr>
                     <tr><td>' . $created_at . '</td></tr>
                     <tr><td>&nbsp;</td></tr>
                     <tr><td>&nbsp;</td></tr>
                 </table>';
                 if ($total > 13) {
                     $icon = "tick_icon.jpg";
                 } else {
                     $icon = "close_icon.jpg";
                 }
                 $content .= '<div style="padding: 30px;">
                             <p style="margin: 0 0 10px;color: #424242;font-weight: 500;font-size: 20px;">Interpretation of scores</p>';
                 $content .= '<div style="padding:0 0 30px;">
                                         <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Dimension :</span>' . $getQuestion . '</h3>
                                         <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Score :</span>' . $total . '</h3>
                                         <h3 style="margin: 0 0 5px;color: #18A7A5;font-weight: 700;font-size: 24px;"><span style="display:inline-block; width:200px; color: #ADADAD; font-weight:500;">Comment :</span><img src="' . Base_url() . 'assets/site/images/' . $icon . '" alt=""></h3>
                                         <div style="margin-left:200px;">
                                             ' . $getFeedback . '
                                         </div>
                                     </div>
                 ';
                 $pdf->SetFont('freeserif', '', 12);
                 $pdf->setTextRenderingMode($stroke = 0, $fill = true, $clip = false);
                 //$pdf->writeHTMLCell(0, 10, '© 2016. SMG Health. All rights reserved.', 0, false, 'C', 0, '', 0, false, 'T', 'M');
                 $pdf->writeHTML($content, true, false, false, false, '');
             }
             /* Create ditectory to save PDF report */
             $fillpath = realpath("assets/site/reports");
             if (!is_dir($fillpath . "/{$id_user}")) {
                 mkdir($fillpath . "/{$id_user}");
             }
             $filename = $fillpath . "/{$id_user}/" . 'survey-report-' . strtotime('now') . '.pdf';
             $pdf->Output($filename, 'F');
             /* Mail to user */
             $username = $this->session->userdata('display_name');
             $user = $this->site_model->get_row('smg_users', array('id_user' => $this->session->userdata('id_user')));
             $user_email = $user->user_email;
             $this->load->library('email');
             $config['mailtype'] = 'html';
             $this->email->initialize($config);
             $this->email->from('*****@*****.**', 'Subhadip Sahoo');
             $this->email->to($user_email);
             $this->email->subject("Thanks for giving bounce back survey");
             $msg['username'] = $username;
             $bodyMsg = $this->load->view('site/email-templates/tmpl_survey_report', $msg, TRUE);
             $this->email->message($bodyMsg);
             $this->email->attach($filename);
             $this->email->send();
             $this->session->set_userdata('suc_msg', 'You have successfully submitted the survey.');
             redirect('thank-you');
             //                redirect('https://www.smghealth.com.au');
             exit;
         }
     } else {
         $data['sidebar'] = get_employee_sidebar();
         $header['title'] = 'Survey Panel';
         $header['display_name'] = $this->session->userdata('display_name');
         $data['header'] = $header;
         if ($ques = $this->survey_model->survey_questions()) {
             $data['questions'] = $ques;
         }
         $data['template'] = 'site/screens/survey_panel';
         $this->load->view('site/master_layout', $data);
     }
 }
    public function generarReporteActividadEvento()
    {
        $idEvento = $this->input->get('idEv');
        $html = null;
        $pdf = new Pdf('L', 'mm', 'Legal', true, 'UTF-8', false);
        $pdf->setPageOrientation('l');
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        $pdf->SetMargins(PDF_MARGIN_LEFT, 15, PDF_MARGIN_RIGHT);
        $pdf->setHeaderMargin(2);
        $pdf->SetHeaderData('bannerprevengo4.png', 270, 'Gobernacion de Lara', 'Oficina de Personal--División de Planificación y Presupuesto', array(0, 64, 255), array(0, 64, 128));
        $pdf->setFooterMargin(12);
        $pdf->setFooterData();
        $pdf->SetAlpha(1, 'Normal');
        $pdf->Image('imagen/logo/degradado.PNG', 30, 54, 100, 104, '', '', 'N', '', '', 'C');
        // recuperamos la opacidad por defecto
        $pdf->SetAlpha(1, 'Normal');
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        $pdf->setFontSubsetting(true);
        $pdf->SetFont('times', '', 12, '', true);
        $pdf->SetFont('Times', 'B', 12);
        $pdf->setPrintHeader(true);
        $pdf->setPrintFooter(true);
        $pdf->AddPage();
        $pdf->SetTextColor('8', '8', '8');
        $pdf->Ln(10);
        $pdf->SetFont('times', '', 11, '', true);
        $ano = date('Y');
        $mesesN = array(1 => "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
        $mes = $mesesN[date('n')];
        $dia = date('d');
        $html .= '
                    <table>
                   
                    <tr colspan="8">
                     
                        <td colspan="8"><p align="rigth"><b>Barquisimeto, ' . $dia . ' de ' . $mes . ' del ' . $ano . '</b></p></td>
                    </tr>
                    </table>';
        $html .= "<h1>Reporte General de Metas alcanzada para las actividades</h1>";
        $condicion = 'evento.id=' . $idEvento;
        $reporte = $this->evento_model->cargarListaEventoSeleccionPDF($condicion);
        if ($reporte->num_rows > 0) {
            foreach ($reporte->result_array() as $fila2) {
                $html .= '
                    <table border="1">
                <tr colspan="4">
                       
                        <td colspan="4" bgColor="#429DED"><p align="center"><b>Evento</b></p></td>
                     
                         
                    </tr>   
                    
                      <tr colspan="4">
                       
                        <td colspan="1" bgColor="#429DED"><p align="center"><b>Titulo</b></p></td>
                        <td colspan="2" bgColor="#429DED"><p align="center"><b>Descripción</b></p></td>
                        <td colspan="1" bgColor="#429DED"><p align="center"><b>Estatus</b></p></td>
                         
                    </tr>


                  <tr colspan="4">
                           
                            <td colspan="1"><p align="center">' . $fila2['titulo'] . '</p></td>
                            <td colspan="2"><p align="center">' . $fila2['descripcion'] . '</p></td>
                            <td colspan="1"><p align="center">' . $fila2['estatus'] . '</p></td>
                        </tr>';
                $reporte2 = $this->actividad_model->cargarMetaPlandeAccionDeEventoPDF($fila2['idEv']);
                $html .= '<tr colspan="4">
                        <td colspan="4" bgColor="#429DED"><p align="center"><b>Plan de Accion</b></p></td>       
                    </tr>';
                if ($reporte2->num_rows > 0) {
                    foreach ($reporte2->result_array() as $fila2) {
                        $html .= '
                    <tr colspan="5">
                        <td colspan="1" bgColor="#00BFFF"><p align="center"><b>Actividad:</b></p></td>
                        <td colspan="1" bgColor="#00BFFF"><p align="center"><b>Meta Propuesta</b></p></td>
                        <td colspan="1" bgColor="#00BFFF"><p align="center"><b>Meta Alcanzada</b></p></td>
                        <td colspan="1" bgColor="#00BFFF"><p align="center"><b>Estatus</b></p></td>
                         
            </tr>       
            
                       <tr colspan="4">
                            <td colspan="1" ><p align="center">' . $fila2['descripcion'] . '</p></td>
                            <td colspan="1" ><p align="center">' . $fila2['metap'] . '</p></td>
                            <td colspan="1" ><p align="center">' . $fila2['metaa'] . '</p></td>
                            <td colspan="1" ><p align="center">' . $fila2['estatus'] . '</p></td>
                           
                        </tr>';
                    }
                } else {
                    $html .= '<tr colspan="4">
                             <td colspan="4"><p align="center"><b> El evento no tiene plan de accion registrado.</b></p></td>    
                        </tr>';
                }
                $html .= '</table>';
                $html .= '<h1></H1>';
            }
        } else {
            $html .= '<tr colspan="4">
                        <td colspan="4" bgColor="#429DED"><p align="center"><b>No hay Eventos registrados</b></p></td>       
                    </tr>';
            $html .= '</table>';
        }
        $nombre_archivo = utf8_decode("reporteEventos.pdf");
        $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
        $pdf->Output($nombre_archivo, 'I');
    }
Example #19
0
    public function getInvoiceById($id)
    {
        $pdf = new Pdf(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8');
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetAuthor('Gekosale');
        $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        $pdf->setLanguageArray(1);
        $pdf->SetFont('dejavusans', '', 10);
        $sql = 'SELECT 
					*
				FROM invoice I
				LEFT JOIN `order` O ON O.idorder = I.orderid
				WHERE 
					I.idinvoice = :id AND IF(O.clientid IS NOT NULL, O.clientid = :clientid, 1)';
        $stmt = Db::getInstance()->prepare($sql);
        $stmt->bindValue('id', $id);
        $stmt->bindValue('clientid', Session::getActiveClientid());
        $stmt->execute();
        $rs = $stmt->fetch();
        $Data = array();
        if ($rs) {
            switch ($rs['contenttype']) {
                case 'html':
                    $htmlcontent = $rs['contentoriginal'];
                    $pdf->AddPage();
                    $pdf->writeHTML($htmlcontent, true, 0, true, 0);
                    @ob_clean();
                    $pdf->Output($rs['symbol'], 'D');
                    break;
                case 'pdf':
                    $data = base64_decode($rs['contentoriginal']);
                    header('Content-Type: application/pdf');
                    header('Content-Description: File Transfer');
                    header('Content-Transfer-Encoding: binary');
                    header('Content-Disposition: attachment; filename="' . $rs['symbol'] . '.pdf"');
                    header('Content-Length: ' . strlen($data));
                    header('Cache-Control: private, must-revalidate, post-check=0, pre-check=0');
                    header('Expires: 0');
                    echo $data;
                    exit;
                    break;
            }
        }
    }
Example #20
0
 public function generarReporteEventoGeneralSeleccionFecha()
 {
     $fecha = date("Y-m-d", strtotime($this->input->get('fecha')));
     $pdf = new Pdf('L', 'mm', 'Legal', true, 'UTF-8', false);
     $pdf->setPageOrientation('l');
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, 15, PDF_MARGIN_RIGHT);
     //$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('times', '', 12, '', true);
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     $pdf->AddPage();
     $html = null;
     $pdf->SetFont('Times', 'B', 14);
     $pdf->Image("imagen/logo/bannerprevengo2.png", $x = 5, $y = 5, $w = 290, $h = 40, $type = 'PNG', $link = '', $align = 'right', $resize = false, $dpi = 300, $palign = '', $ismask = false, $imgmask = false, $border = 0, $fitbox = false, $hidden = false, $fitonpage = false, $alt = false, $altimgs = array());
     $pdf->SetTextColor('0', '25', '215');
     $pdf->Text(130, 12, "República Bolivariana de Venezuela", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
     $pdf->Text(130, 17, "Gobernación del Estado Lara", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
     $pdf->Text(130, 23, "Oficina de Personal--División de Planificación y Presupuesto.", $fstroke = false, $fclip = false, $ffill = true, $border = 0, $ln = 0, $align = 'left', $fill = false, $link = '', $stretch = 0, $ignore_min_height = false, $calign = 'T', $valign = 'M', $rtloff = false);
     $pdf->SetFont('Times', 'B', 12);
     $pdf->SetTextColor('8', '8', '8');
     // $pdf->Text(50, 35, 'Reporte General de Eventos.');
     // $pdf->Ln(20);
     //$pdf->Text(30, 40, 'Fecha:' . date('d-m-Y'),  $align = 'rigth');
     $pdf->Ln(15);
     $pdf->SetFont('times', '', 11, '', true);
     $ano = date('Y');
     $mesesN = array(1 => "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
     $mes = $mesesN[date('n')];
     $dia = date('d');
     $html .= '
                 <table>
                
                 <tr colspan="8">
                     <td colspan="2"><p align="center"><b></b></p></td>
                     <td colspan="2" ><p align="center"><b></b></p></td>
                     <td colspan="2"><p align="center"><b>Barquisimeto, ' . $dia . ' de ' . $mes . ' del ' . $ano . '</b></p></td>
                 </tr>
                 </table>';
     $html .= "<h1>Reporte General de Eventos con  las siguientes caracteristicas: </h1>";
     $html .= '
                 <table border="1">
                 <tr colspan="1"  width="5" heigth="5">
                     <td colspan="1" bgColor="#429DED"><p align="center"><b> Fecha </b></p></td>
                 </tr>
                   <tr colspan="1"  width="5" heigth="5">    
                     <td colspan="1" bgColor=""><p align="center"><b> ' . date("Y-m-d", strtotime($this->input->get('fecha'))) . '</b></p></td>
                 </tr>
                  
                 </table>';
     $condicion = 'evento.fechatope="' . $fecha . '"';
     $reporte = $this->evento_model->cargarListaEventoSeleccionPDF($condicion);
     $html .= "<H1></h1>";
     if ($reporte->num_rows() > 0) {
         $html .= '
                 <table border="1">
                
                 <tr colspan="8">
                     <td colspan="3" bgColor="#429DED"><p align="center"><b>Titulo</b></p></td>
                     <td colspan="10" bgColor="#429DED"><p align="center"><b>Descripción</b></p></td>
                     <td colspan="2" bgColor="#429DED"><p align="center"><b>Tipo de Evento</b></p></td>
                      <td colspan="2" bgColor="#429DED"><p align="center"><b>Sector</b></p></td>
                       <td colspan="2" bgColor="#429DED"><p align="center"><b>Alcance</b></p></td>
                     <td colspan="2" bgColor="#429DED"><p align="center"><b>Agente</b></p></td>
                     <td colspan="2.5" bgColor="#429DED"><p align="center"><b>Estatus</b></p></td>
                     
                 </tr>';
         foreach ($reporte->result_array() as $fila2) {
             $html .= '<tr colspan="8">
                         <td colspan="3"><p align="center">' . $fila2['titulo'] . '</p></td>
                         <td colspan="10"><p align="center">' . $fila2['descripcion'] . '</p></td>
                         <td colspan="2"><p align="center">' . $fila2['tipoEv'] . '</p></td>
                         <td colspan="2"><p align="center">' . $fila2['sector'] . '</p></td>
                              <td colspan="2"><p align="center">' . $fila2['alcance'] . '</p></td>
                         <td colspan="2"><p align="center">' . $fila2['agente'] . '</p></td>
                         <td colspan="2.5"><p align="center">' . $fila2['estatus'] . '</p></td>
                         
                     </tr>';
         }
         $html .= '<tr>
                      <td colspan="21"><p align="right"> Cantidad de Eventos:  </p></td>
                      <td colspan="2"><p align="center">' . $reporte->num_rows() . '</p></td>
                     </tr>
                 </table>';
     } else {
         $html .= '<h1>No se encuentra eventos registrados para la fecha seleccionada.</h1>';
     }
     $nombre_archivo = utf8_decode("reporteEventos.pdf");
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
     $pdf->Output($nombre_archivo, 'I');
 }
 function imprimir()
 {
     $this->load->library('Pdf');
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $this->load->library('zend');
     //load in folder Zend
     $this->zend->load('Zend/Barcode');
     //generate barcode
     $fichas = $this->Ficha->buscar_imprimir();
     foreach ($fichas as $f) {
         $res = Zend_Barcode::factory('code128', 'image', array('text' => $f['clave']), array());
         $res = $res->draw();
         imagepng($res, './codigos/' . $f['clave'] . '.png');
     }
     //$pdf->SetAuthor('Israel Parra');
     // $pdf->SetTitle('Ejemplo de provincías con TCPDF');
     //$pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config_alt.php de libraries/config
     //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 001', PDF_HEADER_STRING, array(0, 64, 255), array(0, 64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     // Establecer el tipo de letra
     //Si tienes que imprimir carácteres ASCII estándar, puede utilizar las fuentes básicas como
     // Helvetica para reducir el tamaño del archivo.
     $pdf->SetFont('freemono', '', 14, '', true);
     // Añadir una página
     // Este método tiene varias opciones, consulta la documentación para más información.
     $pdf->AddPage();
     //fijar efecto de sombra en el texto
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Establecemos el contenido para imprimir
     $fichas = $this->Ficha->buscar_imprimir();
     //foreach($fichas as $fila)
     $i = 0;
     while ($i < 1) {
         $clave = $fichas[$i]['clave'];
         //
         //preparamos y maquetamos el contenido a crear
         $html = '';
         $html .= "<style type=text/css>";
         $html .= "th{color: #fff; font-weight: bold; background-color: #222}";
         $html .= "td{background-color: #AAC7E3; color: #fff}";
         $html .= "</style>";
         $html .= '<img src="./codigos/' . $clave . '.png">';
         //generate barcode
         //$html .= Zend_Barcode::render('code128', 'image', array('text'=>$clave), array())->render();
         $style = array('border' => true, 'vpadding' => 'auto', 'hpadding' => 'auto', 'fgcolor' => array(0, 0, 0), 'bgcolor' => false, 'module_width' => 4, 'module_height' => 3);
         $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 4, $fill = 0, $reseth = true, $align = '', $autopadding = true);
         //$pdf->Ln();
         //$pdf->Addpage();
         $i++;
     }
     // ---------------------------------------------------------
     // Cerrar el documento PDF y preparamos la salida
     // Este método tiene varias opciones, consulte la documentación para más información.
     $nombre_archivo = utf8_decode("Demandas.pdf");
     $pdf->Output($nombre_archivo, 'I');
 }
Example #22
0
 public function generarSalidaEmpleados()
 {
     $nacionalidad = $this->input->get("nacionalidad") != '' ? "LIKE '%" . $this->input->get("nacionalidad") . "%'" : 'LIKE "%"';
     $cedula = $this->input->get("cedula") != '' ? '=' . $this->input->get("cedula") : 'LIKE "%"';
     $nombre = $this->input->get("nombre") != '' ? "LIKE '%" . $this->input->get("nombre") . "%'" : 'LIKE "%"';
     $apellido = $this->input->get("apellido") != '' ? "LIKE '%" . $this->input->get("apellido") . "%'" : 'LIKE "%"';
     $pdf = new Pdf('p', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     // $pdf->SetHeaderData(PDF_HEADER_LOGO,PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING,array(0,64,255),array(0,64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,'Listado General',PDF_HEADER_STRING,array(0,64,255), array(0,64,128));
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetPageOrientation('l');
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('times', '', 10, '', true);
     $pdf->AddPage();
     $pdf->Cell(44, 0, 'Cédula', 1, 0, 'C', 0, '', 0);
     $pdf->Cell(90, 0, 'Nombres y Apellidos', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(44, 0, 'Sexo', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(44, 0, 'Edo. Civil', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(44, 0, 'Posee Partida', 1, 1, 'C', 0, '', 1);
     $pdf->Ln(5);
     $pdf->Cell(44, 0, 'Teléfono Móvil ', 1, 0, 'C', 0, '', 0);
     $pdf->Cell(90, 0, 'Municipio', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(88, 0, 'Parroquia', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(44, 0, 'Fecha Nac.', 1, 1, 'C', 0, '', 1);
     $pdf->Ln(5);
     $pdf->Cell(44, 0, 'Teléfono Local', 1, 0, 'C', 0, '', 0);
     $pdf->Cell(178, 0, 'Dirección', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(44, 0, 'Edad', 1, 1, 'C', 0, '', 1);
     $pdf->Ln(5);
     $pdf->Cell(44, 0, 'CI Responsable', 1, 0, 'C', 0, '', 0);
     $pdf->Cell(90, 0, 'Nombres y Apellidos del Responsable', 1, 0, 'C', 0, '', 1);
     $pdf->Cell(130, 0, 'Dirección', 1, 0, 'C', 0, '', 1);
     // <td><b>CI Responsable</b></td>
     //                 <td colspan="2"><b>Nombres y Apellidos del Responsable</b></td>
     //                 <td colspan="3"><b>Dirección</b></td>
     //                     <td><b>Tipo Vivienda</b></td>
     //                 <td><b>Tenencia Vivienda</b></td>
     //                 <td><b>Parentesco</b></td>
     //                 <td><b>Padres Vivos</b></td>
     //                 <td>
     //                 <b>Nro. Personas</b>
     //                 </td>
     //                 <td><b>Convive con el Discapacitado</b></td>
     //                             <td><br><b>Condición/Discapacidad</b></td>
     //                 <td><br><b>Tipo Discapacidad</b></td>
     //                 <td colspan="2"><br><b>Diagnóstico Tipo Discapacidad</b></td>
     //                 <td><br><b>Certificado Informe Médico</b></td>
     //                 <td><br><b>Estatus</b></td>
     //                                 <td><b>Requiere  Medicamento</b></td>
     //                 <td colspan="2"><br><b>Nombre de los Medicamentos</b></td>
     //                 <td><br><b>Requiere Ayuda</b></td>
     //                 <td colspan="2"><br><b>Nombre de la Ayuda</b></td>
     //                         <td ><b>Grado de instrucción</b></td>
     //                 <td colspan="2"><b>Deseo de continuar Estudiando</b></td>
     //                 <td colspan="2"><b>Condiciones para seguir Estudiando</b></td>
     //                 <td><b>Limitación de Estudio</b></td>
     // ---------------------------------------------------------
     //Close and output PDF document
     $pdf->Output('example_004.pdf', 'I');
 }
/**
* Generates statistics
*
* @param int $surveyid The survey id
* @param mixed $allfields
* @param mixed $q2show
* @param mixed $usegraph
* @param string $outputType Optional - Can be xls, html or pdf - Defaults to pdf
* @param string $pdfOutput Sets the target for the PDF output: DD=File download , F=Save file to local disk
* @param string $statlangcode Lamguage for statistics
* @param mixed $browse  Show browse buttons
* @return buffer
*/
function generate_statistics($surveyid, $allfields, $q2show = 'all', $usegraph = 0, $outputType = 'pdf', $pdfOutput = 'I', $statlangcode = null, $browse = true)
{
    global $pdfdefaultfont, $pdffontsize;
    $astatdata = array();
    //astatdata generates data for the output page's javascript so it can rebuild graphs on the fly
    //load surveytranslator helper
    Yii::import('application.helpers.surveytranslator_helper', true);
    $statisticsoutput = "";
    //This string carries all the actual HTML code to print.
    $imagedir = Yii::app()->getConfig("imagedir");
    $tempdir = Yii::app()->getConfig("tempdir");
    $tempurl = Yii::app()->getConfig("tempurl");
    $clang = Yii::app()->lang;
    $pdf = array();
    //Make sure $pdf exists - it will be replaced with an object if a $pdf is actually being created
    // Used for getting coordinates for google maps
    $agmapdata = array();
    //pick the best font file if font setting is 'auto'
    if (is_null($statlangcode)) {
        $statlangcode = getBaseLanguageFromSurveyID($surveyid);
    } else {
        $statlang = new Limesurvey_lang($statlangcode);
    }
    /*
     * this variable is used in the function shortencode() which cuts off a question/answer title
     * after $maxchars and shows the rest as tooltip (in html mode)
     */
    $maxchars = 13;
    //we collect all the html-output within this variable
    $statisticsoutput = '';
    /**
     * $outputType: html || pdf ||
     */
    /**
     * get/set Survey Details
     */
    //no survey ID? -> come and get one
    if (!isset($surveyid)) {
        $surveyid = returnGlobal('sid');
    }
    //Get an array of codes of all available languages in this survey
    $surveylanguagecodes = Survey::model()->findByPk($surveyid)->additionalLanguages;
    $surveylanguagecodes[] = Survey::model()->findByPk($surveyid)->language;
    $fieldmap = createFieldMap($surveyid, "full", false, false, $statlang->getlangcode());
    // Set language for questions and answers to base language of this survey
    $language = $statlangcode;
    if ($q2show == 'all') {
        $summarySql = " SELECT gid, parent_qid, qid, type " . " FROM {{questions}} WHERE parent_qid=0" . " AND sid={$surveyid} ";
        $summaryRs = Yii::app()->db->createCommand($summarySql)->query()->readAll();
        foreach ($summaryRs as $field) {
            $myField = $surveyid . "X" . $field['gid'] . "X" . $field['qid'];
            // Multiple choice get special treatment
            if ($field['type'] == "M") {
                $myField = "M{$myField}";
            }
            if ($field['type'] == "P") {
                $myField = "P{$myField}";
            }
            //numerical input will get special treatment (arihtmetic mean, standard derivation, ...)
            if ($field['type'] == "N") {
                $myField = "N{$myField}";
            }
            if ($field['type'] == "|") {
                $myField = "|{$myField}";
            }
            if ($field['type'] == "Q") {
                $myField = "Q{$myField}";
            }
            // textfields get special treatment
            if ($field['type'] == "S" || $field['type'] == "T" || $field['type'] == "U") {
                $myField = "T{$myField}";
            }
            //statistics for Date questions are not implemented yet.
            if ($field['type'] == "D") {
                $myField = "D{$myField}";
            }
            if ($field['type'] == "F" || $field['type'] == "H") {
                //Get answers. We always use the answer code because the label might be too long elsewise
                $query = "SELECT code, answer FROM {{answers}} WHERE qid='" . $field['qid'] . "' AND scale_id=0 AND language='{$language}' ORDER BY sortorder, answer";
                $result = Yii::app()->db->createCommand($query)->query();
                $counter2 = 0;
                //check all the answers
                foreach ($result->readAll() as $row) {
                    $row = array_values($row);
                    $myField = "{$myField}{$row[0]}";
                }
                //$myField = "{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}[]";
            }
            if ($q2show == 'all') {
                $summary[] = $myField;
            }
            //$allfields[]=$myField;
        }
    } else {
        // This gets all the 'to be shown questions' from the POST and puts these into an array
        if (!is_array($q2show)) {
            $summary = returnGlobal('summary');
        } else {
            $summary = $q2show;
        }
        //print_r($_POST);
        //if $summary isn't an array we create one
        if (isset($summary) && !is_array($summary)) {
            $summary = explode("+", $summary);
        }
    }
    /**
     * pdf Config
     */
    if ($outputType == 'pdf') {
        //require_once('classes/tcpdf/config/lang/eng.php');
        global $l;
        $l['w_page'] = $statlang->gT("Page", 'unescaped');
        //require_once('classes/tcpdf/mypdf.php');
        Yii::import('application.libraries.admin.pdf', true);
        // create new PDF document
        $pdf = new Pdf();
        $pdf->SetFont($pdfdefaultfont, '', $pdffontsize);
        $surveyInfo = getSurveyInfo($surveyid, $language);
        // set document information
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetAuthor('LimeSurvey');
        $pdf->SetTitle('Statistic survey ' . $surveyid);
        $pdf->SetSubject($surveyInfo['surveyls_title']);
        $pdf->SetKeywords('LimeSurvey, Statistics, Survey ' . $surveyid . '');
        $pdf->SetDisplayMode('fullpage', 'two');
        // set header and footer fonts
        $pdf->setHeaderFont(array($pdfdefaultfont, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array($pdfdefaultfont, '', PDF_FONT_SIZE_DATA));
        // set default header data
        $pdf->SetHeaderData("statistics.png", 10, $statlang->gT("Quick statistics", 'unescaped'), $statlang->gT("Survey") . " " . $surveyid . " '" . flattenText($surveyInfo['surveyls_title'], false, true, 'UTF-8') . "'");
        // set default monospaced font
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        //set margins
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        //set auto page breaks
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        //set image scale factor
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        //set some language-dependent strings
        $pdf->setLanguageArray($l);
    }
    if ($outputType == 'xls') {
        /**
         * Initiate the Spreadsheet_Excel_Writer
         */
        Yii::import('application.libraries.admin.pear.Spreadsheet.Excel.Xlswriter', true);
        if ($pdfOutput == 'F') {
            $sFileName = $tempdir . '/statistic-survey' . $surveyid . '.xls';
            $workbook = new Xlswriter($sFileName);
        } else {
            $workbook = new Xlswriter();
        }
        $workbook->setVersion(8);
        // Inform the module that our data will arrive as UTF-8.
        // Set the temporary directory to avoid PHP error messages due to open_basedir restrictions and calls to tempnam("", ...)
        $workbook->setTempDir($tempdir);
        // Inform the module that our data will arrive as UTF-8.
        // Set the temporary directory to avoid PHP error messages due to open_basedir restrictions and calls to tempnam("", ...)
        if (!empty($tempdir)) {
            $workbook->setTempDir($tempdir);
        }
        if ($pdfOutput != 'F') {
            $workbook->send('statistic-survey' . $surveyid . '.xls');
        }
        // Creating the first worksheet
        $sheet =& $workbook->addWorksheet(utf8_decode('results-survey' . $surveyid));
        $sheet->setInputEncoding('utf-8');
        $sheet->setColumn(0, 20, 20);
        $separator = "~|";
        /**XXX*/
    }
    /**
     * Start generating
     */
    $selects = buildSelects($allfields, $surveyid, $language);
    //count number of answers
    $query = "SELECT count(*) FROM {{survey_{$surveyid}}}";
    //if incompleted answers should be filtert submitdate has to be not null
    if (incompleteAnsFilterState() == "inc") {
        $query .= " WHERE submitdate is null";
    } elseif (incompleteAnsFilterState() == "filter") {
        $query .= " WHERE submitdate is not null";
    }
    $result = Yii::app()->db->createCommand($query)->query();
    //$total = total number of answers
    $row = $result->read();
    $total = reset($row);
    //are there any filters that have to be taken care of?
    if (isset($selects) && $selects) {
        //filter incomplete answers?
        if (incompleteAnsFilterState() == "filter" || incompleteAnsFilterState() == "inc") {
            $query .= " AND ";
        } else {
            $query .= " WHERE ";
        }
        //add filter criteria to SQL
        $query .= implode(" AND ", $selects);
    }
    //get me some data Scotty
    $result = Yii::app()->db->createCommand($query)->query();
    //put all results into $results
    $row = $result->read();
    $results = reset($row);
    if ($total) {
        $percent = sprintf("%01.2f", $results / $total * 100);
    }
    switch ($outputType) {
        case "xls":
            $xlsRow = 0;
            $sheet->write($xlsRow, 0, $statlang->gT("Number of records in this query:", 'unescaped'));
            $sheet->write($xlsRow, 1, $results);
            ++$xlsRow;
            $sheet->write($xlsRow, 0, $statlang->gT("Total records in survey:", 'unescaped'));
            $sheet->write($xlsRow, 1, $total);
            if ($total) {
                ++$xlsRow;
                $sheet->write($xlsRow, 0, $statlang->gT("Percentage of total:", 'unescaped'));
                $sheet->write($xlsRow, 1, $percent . "%");
            }
            break;
        case 'pdf':
            // add summary to pdf
            $array = array();
            //$array[] = array($statlang->gT("Results"),"");
            $array[] = array($statlang->gT("Number of records in this query:", 'unescaped'), $results);
            $array[] = array($statlang->gT("Total records in survey:", 'unescaped'), $total);
            if ($total) {
                $array[] = array($statlang->gT("Percentage of total:", 'unescaped'), $percent . "%");
            }
            $pdf->addPage('P', 'A4');
            $pdf->Bookmark($pdf->delete_html($statlang->gT("Results", 'unescaped')), 0, 0);
            $pdf->titleintopdf($statlang->gT("Results", 'unescaped'), $statlang->gT("Survey", 'unescaped') . " " . $surveyid);
            $pdf->tableintopdf($array);
            $pdf->addPage('P', 'A4');
            break;
        case 'html':
            $statisticsoutput .= "<br />\n<table class='statisticssummary' >\n" . "\t<thead><tr><th colspan='2'>" . $statlang->gT("Results") . "</th></tr></thead>\n" . "\t<tr><th >" . $statlang->gT("Number of records in this query:") . '</th>' . "<td>{$results}</td></tr>\n" . "\t<tr><th>" . $statlang->gT("Total records in survey:") . '</th>' . "<td>{$total}</td></tr>\n";
            //only calculate percentage if $total is set
            if ($total) {
                $percent = sprintf("%01.2f", $results / $total * 100);
                $statisticsoutput .= "\t<tr><th align='right'>" . $statlang->gT("Percentage of total:") . '</th>' . "<td>{$percent}%</td></tr>\n";
            }
            $statisticsoutput .= "</table>\n";
            break;
        default:
            break;
    }
    //put everything from $selects array into a string connected by AND
    //This string ($sql) can then be passed on to other functions so you can
    //browse these results
    if (isset($selects) && $selects) {
        $sql = implode(" AND ", $selects);
    } elseif (!empty($newsql)) {
        $sql = $newsql;
    }
    if (!isset($sql) || !$sql) {
        $sql = "NULL";
    }
    //only continue if we have something to output
    if ($results > 0) {
        if ($outputType == 'html' && $browse === true) {
            //add a buttons to browse results
            $statisticsoutput .= "<form action='" . Yii::app()->getController()->createUrl("admin/responses/index/surveyid/{$surveyid}") . "' method='post' target='_blank'>\n" . "\t\t<p>" . "\t\t\t<input type='submit' value='" . $statlang->gT("Browse") . "'  />\n" . "\t\t\t<input type='hidden' name='sid' value='{$surveyid}' />\n" . "\t\t\t<input type='hidden' name='sql' value=\"{$sql}\" />\n" . "\t\t\t<input type='hidden' name='subaction' value='all' />\n" . "\t\t</p>" . "\t\t</form>\n";
        }
    }
    //end if (results > 0)
    /* Show Summary results
     * The $summary array contains each fieldname that we want to display statistics for
     *
     * */
    if (isset($summary) && $summary) {
        //let's run through the survey
        $runthrough = $summary;
        //START Chop up fieldname and find matching questions
        //loop through all selected questions
        foreach ($runthrough as $rt) {
            //Step 1: Get information about this response field (SGQA) for the summary
            $outputs = buildOutputList($rt, $language, $surveyid, $outputType, $sql, $statlang);
            $statisticsoutput .= $outputs['statisticsoutput'];
            //2. Collect and Display results #######################################################################
            if (isset($outputs['alist']) && $outputs['alist']) {
                $display = displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $pdf, $statlang);
                $statisticsoutput .= $display['statisticsoutput'];
                $astatdata = array_merge($astatdata, $display['astatdata']);
            }
            //end if -> collect and display results
            //Delete Build Outputs data
            unset($outputs);
            unset($display);
        }
        // end foreach -> loop through all questions
        //output
        if ($outputType == 'html') {
            $statisticsoutput .= "<br />&nbsp;\n";
        }
    }
    //end if -> show summary results
    switch ($outputType) {
        case 'xls':
            $workbook->close();
            if ($pdfOutput == 'F') {
                return $sFileName;
            } else {
                return;
            }
            break;
        case 'pdf':
            $pdf->lastPage();
            if ($pdfOutput == 'F') {
                // This is only used by lsrc to send an E-Mail attachment, so it gives back the filename to send and delete afterwards
                $pdf->Output($tempdir . "/" . $statlang->gT('Survey') . '_' . $surveyid . "_" . $surveyInfo['surveyls_title'] . '.pdf', $pdfOutput);
                return $tempdir . "/" . $statlang->gT('Survey') . '_' . $surveyid . "_" . $surveyInfo['surveyls_title'] . '.pdf';
            } else {
                return $pdf->Output($statlang->gT('Survey') . '_' . $surveyid . "_" . $surveyInfo['surveyls_title'] . '.pdf', $pdfOutput);
            }
            break;
        case 'html':
            $statisticsoutput .= "<script type=\"text/javascript\" src=\"http://maps.googleapis.com/maps/api/js?sensor=false\"></script>\n" . "<script type=\"text/javascript\">var site_url='" . Yii::app()->baseUrl . "';var temppath='{$tempurl}';var imgpath='" . Yii::app()->getConfig('adminimageurl') . "';var aGMapData=" . ls_json_encode($agmapdata) . ";var aStatData=" . ls_json_encode($astatdata) . "</script>";
            return $statisticsoutput;
            break;
        default:
            return $statisticsoutput;
            break;
    }
}
Example #24
0
 public function generarListadogeneneral()
 {
     $nombre = $this->input->get("nombre") != '' ? "LIKE '%" . $this->input->get("nombre") . "%'" : 'LIKE "%"';
     $apellido = $this->input->get("apellido") != '' ? "LIKE '%" . $this->input->get("apellido") . "%'" : 'LIKE "%"';
     $pdf = new Pdf('l', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->SetCreator(PDF_CREATOR);
     $pdf->SetSubject('Tutorial TCPDF');
     $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     // $pdf->SetHeaderData(PDF_HEADER_LOGO,PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING,array(0,64,255),array(0,64, 128));
     $pdf->setFooterData($tc = array(0, 64, 0), $lc = array(0, 64, 128));
     // datos por defecto de cabecera, se pueden modificar en el archivo tcpdf_config.php de libraries/config
     // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,'Listado General',PDF_HEADER_STRING,array(0,64,255), array(0,64,128));
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     $pdf->SetPageOrientation('p');
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // se pueden modificar en el archivo tcpdf_config.php de libraries/config
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //relación utilizada para ajustar la conversión de los píxeles
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // establecer el modo de fuente por defecto
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('times', '', 9, '', true);
     $pdf->AddPage();
     $html = null;
     $nombre_archivo = null;
     // Establecemos el contenido para imprimir
     $resultado = $this->ReporteGeneral_model->getlistadogeneral($nombre, $apellido);
     if ($resultado) {
         $html = '';
         $html .= "<style type=text/css>";
         $html .= "th{color: #fff; font-weight: bold; background-color: #0B615E; align=center}";
         $html .= "td{background-color: #fff; color: #222; align=center}";
         $html .= "</style>";
         $html .= "<h2>Listado General de las Personas con Permisos</h2>";
         $html .= "<table width='100%' border='1' cellpadding='0' cellspacing='0' >";
         $html .= "<tr>\r\n            <th><em>Fecha del Permiso</em></th>\r\n            <th><em>Cédula</em></th>\r\n            <th><em>Nombres</em></th>\r\n            <th><em>Cantidad de salidas</em></th>\r\n            <th><em>Departamento</em></th>\r\n            <th><em>Motivo</em></th>\r\n            </tr>";
         foreach ($resultado as $fila) {
             $html .= '<tr>
                 <td>' . mb_convert_case($fila["fechaautorizacion"], MB_CASE_TITLE, "UTF-8") . '</td>
                 <td>' . mb_convert_case($fila["cedula"], MB_CASE_TITLE, "UTF-8") . '</td>
                 <td>' . mb_convert_case($fila["nombre"], MB_CASE_TITLE, "UTF-8") . '  ' . mb_convert_case($fila["apellido"], MB_CASE_TITLE, "UTF-8") . '</td>
                 <td>' . mb_convert_case($fila["contsalida"], MB_CASE_TITLE, "UTF-8") . '</td>
                 <td>' . mb_convert_case($fila["departamento"], MB_CASE_TITLE, "UTF-8") . '</td>
                 <td>' . mb_convert_case($fila["motivo"], MB_CASE_TITLE, "UTF-8") . '</td>
            </tr>
         <hr>';
         }
         $html .= "</table>";
         $cantidad = count($resultado);
         if ($cantidad > 1) {
             $html .= "<h4>Actualmente: " . count($resultado) . " empleados con permisos</h4>";
         } else {
             $html .= "<h4>Actualmente: " . count($resultado) . " empleados con permisos</h4>";
         }
         $nombre_archivo = utf8_decode("Listado General.pdf");
     } else {
         $html = '';
         $html .= "<style type=text/css>";
         $html .= "th{color: #fff; font-weight: bold; background-color: #AAC7E3}";
         $html .= "td{background-color: #fff; color: #222}";
         $html .= "</style>";
         $html .= "<h4>Listado General de las Personas con Permisos</h4>";
         $html .= "<table width='100%'>";
         $html .= "<tr><th>No hay empleados de permiso con las características indicadas</th></tr>";
         $html .= "</table>";
         $nombre_archivo = utf8_decode("Listado General " . $nombre . ".pdf");
     }
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
     $pdf->Output($nombre_archivo, 'I');
 }
Example #25
0
 public function index()
 {
     $this->load->library('Pdf');
     $hashqid = $_GET['qid'];
     $this->load->model('quotationmodel');
     $data = $this->quotationmodel->fetchQuotationDetails($hashqid);
     //$this->load->view('admin/pdfquotation',$data);
     $pdf = new Pdf('P', 'mm', 'A4', true, 'UTF-8', false);
     ob_clean();
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //set image scale factor
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // set document information
     $pdf->SetCreator('Gizmoland');
     $pdf->SetTitle("Quotation");
     // set default header data
     //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING, array(0,64,255), array(0,64,128));
     //$pdf->setFooterData($tc=array(0,64,0), $lc=array(0,64,128));
     // set header and footer fonts
     $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // set default monospaced font
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     //set margins
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     //set auto page breaks
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     //set image scale factor
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     //set some language-dependent strings
     //$pdf->setLanguageArray($l);
     // ---------------------------------------------------------
     // set default font subsetting mode
     $pdf->setFontSubsetting(true);
     // Set font
     // dejavusans is a UTF-8 Unicode font, if you only need to
     // print standard ASCII chars, you can use core fonts like
     // helvetica or helvetica to reduce file size.
     $pdf->SetFont('helvetica', '', 14, '', true);
     // Add a page
     // This method has several options, check the source code documentation for more information.
     $pdf->AddPage();
     $pdf->SetXY(15, 8);
     $pdf->SetFont('helvetica', 'B', 12);
     $pdf->SetTextColor(0, 0, 0, 100);
     $pdf->Cell(0, 0, 'Quotation', 0, 1, 'C', 0, '', 0);
     $pdf->SetXY(5, 5);
     $pdf->SetXY(0, 28);
     $pdf->SetFont('helvetica', 'B', 12);
     $pdf->Cell(65, 5, 'Customer Details', 0, 1, 'C', 0, '', 0);
     $pdf->SetXY(0, 28);
     $pdf->Cell(325, 5, 'Consolidated Premium Retailers', 0, 1, 'C', 0, '', 0);
     $pdf->Ln(2);
     $pdf->SetFont('helvetica', '', 10);
     $pdf->SetTextColor(0, 0, 0, 100);
     $pdf->SetXY(15, 35);
     //Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=0, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M')
     $pdf->Cell(25, 5, 'Customer Name :', 0, 1, 'L', 0, '', 0);
     $pdf->Cell(25, 5, 'Contact :', 0, 1, 'L', 0, '', 0);
     $pdf->Cell(25, 5, 'Address :', 0, 1, 'L', 0, '', 0);
     $pdf->SetFont('helvetica', '', 10);
     $pdf->SetXY(45, 35);
     $pdf->Cell(25, 5, ucfirst($data['name']), 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(30, 40);
     $pdf->Cell(25, 5, $data['contact'], 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(30, 45);
     //$pdf->Cell(25, 5, $data['address'], 0, 1, 'L', 0, '', 0);
     $pdf->Cell(25, 5, '', 0, 1, 'L', 0, '', 0);
     $pdf->writeHTMLCell($w = 80, $h = 0, $x = 15, $y = '', $data['address'], $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     //$pdf->SetXY(40, 50);
     $style4 = array('L' => 0, 'T' => array('width' => 0.25, 'cap' => 'butt', 'join' => 'miter', 'dash' => '20,10', 'phase' => 10, 'color' => array(100, 100, 255)), 'R' => array('width' => 0.5, 'cap' => 'round', 'join' => 'miter', 'dash' => 0, 'color' => array(50, 50, 127)), 'B' => array('width' => 0.75, 'cap' => 'square', 'join' => 'miter', 'dash' => '30,10,5,10'));
     //$style = array('width' => 0.1, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0));
     //$pdf->Line(5, 10, 80, 30, $style);
     $pdf->SetFont('helvetica', '', 10);
     $pdf->SetXY(131, 35);
     $pdf->Cell(25, 5, 'Contact :', 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(131, 40);
     $pdf->Cell(25, 5, 'Email :', 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(131, 45);
     $pdf->Cell(25, 5, 'TIN :', 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(131, 50);
     $pdf->Cell(25, 5, 'CST :', 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(131, 55);
     $pdf->Cell(25, 5, 'Sales Person :', 0, 1, 'L', 0, '', 0);
     $pdf->SetFont('helvetica', '', 10);
     $pdf->SetXY(147, 35);
     $pdf->Cell(25, 5, $data['retailcontact'], 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(143, 40);
     $pdf->Cell(25, 5, $data['maildid'], 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(140, 45);
     $pdf->Cell(25, 5, $data['tin'], 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(140, 50);
     $pdf->Cell(25, 5, $data['cst'], 0, 1, 'L', 0, '', 0);
     $pdf->SetXY(155, 55);
     $pdf->Cell(25, 5, $data['salesperson'], 0, 1, 'L', 0, '', 0);
     $invoicedetails = '<table><thead><tr><th  style="font-weight:bold;" width="35%">Quotation Details</th><th></th></tr></thead><tbody>';
     $invoicedetails .= '<tr><td  width="25%">Quotation Number:</td><td>' . $data['qid'] . '</td></tr>';
     $invoicedetails .= '<tr><td  width="25%">Quotation Date:</td><td>' . date("m/d/y", $data['quotationdate']) . '</td></tr>';
     $pdf->Ln(20);
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = 15, $y = '', $invoicedetails, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     $pdf->Line(15, 100, 195, 100, $style4);
     $pdf->Line(15, 110, 195, 110, $style4);
     $pos = 105;
     $pdf->SetFont('helvetica', '', 10);
     $itemdetails = '<table  cellpadding="5" cellspacing="10"><thead><tr style="font-weight:bold;"><th width="15%" style="text-align:center;">Item Code</th><th width="27%" style="text-align:center;">Description of Goods</th><th width="7%">QTY</th><th width="13%" style="text-align:center;">Price</th><th width="9%"  style="text-align:center;">TAX%</th><th width="15%"  style="text-align:center;">DIS%</th><th width="14%" style="text-align:center;">Net</th></tr></thead><tbody>';
     foreach ($data['itemdetails'] as $row) {
         $actualprice = $row['price'] * $row['quantity'];
         $disvalue = $row['quantity'] * $row['price'] * $row['dis'] / 100;
         $taxvalue = ($actualprice - $disvalue) * $row['taxpercent'] / 100;
         $rowtotal = $actualprice - ($disvalue + $taxvalue);
         $itemdetails .= '<tr><td width="15%">' . $row['itemcode'] . '</td><td  width="27%">' . $row['description'] . '</td><td width="7%">' . $row['quantity'] . '</td><td width="13%"  style="text-align:right;">' . number_format($row['price'], 2, '.', ',') . '</td><td width="9%" style="text-align:right;">' . number_format($row['taxpercent'], 2, '.', ',') . '</td><td  width="15%" style="text-align:right;">' . number_format($row['dis'], 2, '.', ',') . '</td><td width="14%" style="text-align:right;">' . number_format($rowtotal, 2, '.', ',') . '</td></tr>';
         $pos = $pos + 10;
     }
     $itemdetails .= '</tbody></table>';
     $pos = $pos + 50;
     $pdf->Ln(5);
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = 15, $y = '', $itemdetails, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
     $pdf->Ln(2);
     $pdf->Line(15, $pos, 195, $pos, $style4);
     $subdetails = '<table><thead><tr><th  style="font-weight:bold;" width="50%"></th><th></th></tr></thead><tbody>';
     $subdetails .= '<tr><td  width="50%" style="font-weight:bold;">Subtotal  :</td><td  style="text-align:right;">' . number_format($data['subtotal'], 2, '.', ',') . '</td></tr>';
     $subdetails .= '<tr><td  width="50%" style="font-weight:bold;">Tax Total :</td><td  style="text-align:right;">' . number_format($data['taxtotal'], 2, '.', ',') . '</td></tr>';
     $subdetails .= '<tr><td  width="50%" style="font-weight:bold;">Round Off :</td><td  style="text-align:right;">' . number_format($data['roundoff'], 2, '.', ',') . '</td></tr>';
     $subdetails .= '<tr><td  width="50%" style="font-weight:bold;">Net Amount:</td><td style="text-align:right;">' . number_format($data['netamount'], 2, '.', ',') . '</td></tr>';
     $subdetails .= '</tbody></table>';
     //$pdf->Ln(5);
     $pdf->SetXY(140, $pos);
     $pdf->writeHTMLCell($w = 52, $h = 0, $x = 125, $y = '', $subdetails, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'right', $autopadding = true);
     $remarksdetails = '<table><thead><tr><th  style="font-weight:bold;" width="50%"></th><th></th></tr></thead><tbody>';
     $remarksdetails .= '<tr><td  width="50%"></td><td  style="text-align:right;"></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td  style="text-align:right;"></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td  style="text-align:right;"></td></tr>';
     //$remarksdetails .= '<tr><td  width="95%">Rupees '.ucfirst($this->no_to_words($data['netamount']).' only/-').'</td><td   width="5%"></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td  style="text-align:right;"></td></tr>';
     $remarksdetails .= '<tr><td  width="50%" style="font-weight:bold;">Term&Condition</td><td style="text-align:right;"></td></tr>';
     $remarksdetails .= '<tr><td  width="90%" style="text-align:Justify;">' . $data['term'] . '</td><td width="10%"></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $remarksdetails .= '<tr><th  style="font-weight:bold;text-align:right;" width="95%">For CONSOLIDATED PREMIUM RETAILERS</th></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $remarksdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $remarksdetails .= '<tr><td  style="text-align:right; width:80%;">Authorised Signatory</td><td></td></tr>';
     $remarksdetails .= '</tbody></table>';
     $pdf->SetXY(140, $pos);
     //$pdf->Ln(5);
     $pdf->writeHTMLCell($w = 180, $h = 0, $x = 15, $y = '', $remarksdetails, $border = 0, $ln = 1, $fill = 0, $reseth = false, $align = 'right', $autopadding = true);
     /*
     $footerdetails = '<table><thead><tr><th></th><th  style="font-weight:bold;" width="75%">For CONSOLIDATED PREMIUM RETAILERS</th></tr></thead><tbody>';
     $footerdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $footerdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $footerdetails .= '<tr><td  width="50%"></td><td></td></tr>';
     $footerdetails .= '<tr><td  style="text-align:right; width:80%;">Authorised Signatory</td><td></td></tr>';
     $footerdetails .= '<tr><td  style="text-align:center;" width="30%"></td><td></td></tr>';
     $footerdetails .= '<tr><td style="text-align:left;" width="50%"></td><td></td></tr>';
     $footerdetails .= '</tbody></table>';
     
     //$pdf->SetXY(160, 150);
     $pdf->Ln(5);
     //$pdf->writeHTMLCell($w=180, $h=0, $x=15, $y='',$footerdetails, $border=1, $ln=1, $fill=0, $reseth=false, $align='right', $autopadding=true);
     */
     $pdf->Output($data['qid'] . '.pdf', 'I');
 }
Example #26
0
 public function ticketPdf()
 {
     $ticket = $this->input->get("ticket");
     $pdf = new Pdf('L', 'mm', 'A4', true, 'UTF-8', false);
     $pdf->setPageOrientation('p');
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(PDF_MARGIN_LEFT, 15, PDF_MARGIN_RIGHT);
     //$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     $pdf->setFontSubsetting(true);
     $pdf->SetFont('times', '', 12, '', true);
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     $pdf->AddPage();
     $html = null;
     $buscarTicket = $this->ticket_model->buscarTicket($ticket);
     $buscarTicketSector = $this->ticket_model->buscarTicketSector($ticket);
     if ($buscarTicket) {
         foreach ($buscarTicket as $fila1) {
             $html = '';
             $html .= "<style type=text/css>";
             $html .= "td{ color: #222}";
             $html .= "</style>";
             $html .= '<table border="0">
             <tr colspan="6">                        
                 <td colspan="2" align="left"><img alt="Imagen" src="imagen/logo/logoborde.png" width="220" heigth="90"/></td>
                 <td colspan="2" ><br></td>
                 <td colspan="2"><p align="right"><b>República Bolivariana de Venezuela<br>Gobernación del Estado Lara</b></p></td>
             </tr><br>
             <tr colspan="6">
                 <td colspan="6" align="right"><b>Ticket: ' . $fila1->codigo . '</b></td><br>
             </tr>
             <tr colspan="6">
                 <td colspan="6" align="right"><b>Barquisimeto, ' . $fila1->fecha . '</b></td>
             </tr><br>
             <tr colspan="6">
                 <td colspan="6" align="center"><b>REQUERIMIENTO</b></td>
             </tr>
             </table><br>
             
             <table border="1">                
             <tr colspan="6">
                 <td colspan="2" bgColor="#DCDCDC"><p align="center"><b>Solicitante:</b></p></td>
                 <td colspan="4"><p align="center">' . $fila1->solicitante . '</p></td><br>
             </tr>
             <tr colspan="6">
                 <td colspan="2" bgColor="#DCDCDC"><p align="center"><b>Tipo de requerimiento:</b></p></td>
                 <td colspan="4"><p align="center">' . $fila1->nombretipo . '</p></td><br>
             </tr>
             </table><br>';
             if ($fila1->tipoticket == 3) {
                 $html .= '
                 <table border="1">
                 <tr colspan="8">
                     <td colspan="8" bgColor="#DCDCDC"><p align="center"><b>DESCRIPCIÓN REQUERIMIENTO.-</b></p></td>
                 </tr>
                 <tr colspan="8">
                     <td colspan="3" bgColor="#DCDCDC"><p align="center"><b>Tipo de ayuda</b></p></td>
                     <td colspan="3" bgColor="#DCDCDC"><p align="center"><b>Descripción</b></p></td>
                     <td colspan="2" bgColor="#DCDCDC"><p align="center"><b>Cantidad</b></p></td>
                 </tr>';
                 foreach ($buscarTicketSector as $fila2) {
                     $variable = $fila2->nombresector;
                     $html .= '<tr colspan="8">
                         <td colspan="3"><p align="center">' . $fila2->ayudaticket . '</p></td>
                         <td colspan="3"><p align="center">' . $fila2->descripcion . '</p></td>
                         <td colspan="2"><p align="center">' . $fila2->cantidad . '</p></td>
                     </tr>';
                 }
                 $html .= '<tr colspan="8">
                     <td colspan="8" bgColor="#DCDCDC"><p align="center">SECTOR RELACIONADO AL REQUERIMIENTO: ' . $variable . '</p></td><br>
                 </tr>
                 </table>';
             } else {
                 $html .= '<table border="1">
                 <tr colspan="6">
                     <td colspan="6" bgColor="#DCDCDC"><p align="center">SECTOR RELACIONADO AL REQUERIMIENTO: ' . $fila1->nombresector . '</p></td><br>
                 </tr>
                 <tr colspan="6">
                     <td colspan="6" bgColor="#DCDCDC"><p align="center">DESCRIPCIÓN REQUERIMIENTO.-</p></td><br>
                 </tr>                
                 <tr colspan="6">
                     <td colspan="6"><p align="justify">' . $fila1->descripcion . '</p></td><br>
                 </tr>
                 </table>';
             }
         }
     } else {
         $pdf->SetFont('Times', 'B', 18);
         $pdf->Text(5, 25, 'No se encuentra Documento con las características indicadas.');
     }
     $nombre_archivo = utf8_decode("ticket.pdf");
     $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
     $pdf->Output($nombre_archivo, 'I');
 }
    public function cetak_rm()
    {
        $no_rm = $this->uri->segment(3);
        $view_rekam_medis = $this->m_crud->get_list_pasien($no_rm);
        $view_trans_pelayanan = $this->m_crud->get_pasien_rekam_medis($no_rm);
        $this->load->library('Pdf');
        $pdf = new Pdf('P', 'mm', 'F4', true, 'UTF-8', false);
        // $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
        $pdf->SetPrintHeader(false);
        $pdf->SetPrintFooter(false);
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetPageOrientation('P');
        $pdf->SetAuthor('Pemerintah Kota Bogor');
        $pdf->SetTitle('Rekam Medis');
        $pdf->SetSubject('Rekam Medis Pasien');
        $pdf->SetKeywords('Medical Record');
        // $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 001', PDF_HEADER_STRING, array(0,64,255), array(0,64,128));
        //$pdf->setFooterData(array(0,64,0), array(0,64,128));
        $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
        $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
            require_once dirname(__FILE__) . '/lang/eng.php';
            $pdf->setLanguageArray($l);
        }
        $pdf->setFontSubsetting(true);
        $pdf->SetFont('helvetica', '', 9, '', true);
        $pdf->SetTopMargin(10);
        $pdf->AddPage();
        $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal'));
        $puskesmas = $this->m_rujukan->get_puskesmas_info($this->session->userdata('kd_puskesmas'));
        #echo $this->session->userdata('kd_puskesmas');
        #echo $this->db->last_query(); exit;
        $html = '<table width="100%" align="center" border="0">';
        $html .= '<tr>
                        <td width="20%" style="text-align: center;"><img src="' . base_url() . 'assets/img/' . $puskesmas["logo"] . '" width="80" height="80"/></td>
                        <td width="80%" align="center"><h2>PEMERINTAH PROPINSI ' . $puskesmas["nm_propinsi"] . '<br>DINAS KESEHATAN KOTA ' . $puskesmas["nm_kota"] . '</h2>
                        <h1>UPTD ' . $puskesmas["nm_puskesmas"] . '</h1>
						<h3>' . $puskesmas["alamat"] . ' Telp. ' . $puskesmas["telp"] . '</h3>
                        </td>
                    </tr>
					<tr>
              <td colspan="" bordercolordark="#0A0A0A" style="text-align: center;">____________________________________________________________________________________________________</td>
              </tr>';
        $html .= '</table><p></p>';
        $html .= '<div id="rekam-medis">
                        	<h4 class="widgettitle nomargin">Rekam Medis Pasien</h4>
                            <div class="widgetcontent bordered">
                            	<div class="row-fluid">
                                	<div class="span6">
                                    	<table class="table table-bordered table-invoice">
                                            <tbody>
                                                <tr>
                                                    <td width="30%">No. Rekam Medis</td>
                                                    <td width="70%">' . $view_rekam_medis['kd_rekam_medis'] . '</td>
                                                </tr>
                                                <tr>
                                                    <td>Nama Pasien</td>
                                                    <td>' . $view_rekam_medis['nm_lengkap'] . '</td>
                                                </tr>
                                                <tr>
                                                    <td>Tempat, Tgl Lahir</td>
                                                    <td>' . $view_rekam_medis['tempat_lahir'] . ' / ' . $this->functions->format_tgl_cetak2($view_rekam_medis['tanggal_lahir']) . '</td>
                                                </tr>';
        $hitung = $this->functions->CalcAge($view_rekam_medis['tanggal_lahir'], date('Y-m-d'));
        //$hitung = $this->functions->dateDifference($view_rekam_medis['tanggal_lahir'], date('Y-m-d'));
        $umurku = $hitung[0] . ' Tahun ' . $hitung[1] . ' Bulan ' . $hitung[2] . ' Hari';
        // echo $umurku;
        $html .= '
                                                <tr>
                                                    <td>Umur</td>
                                                    <td>' . $umurku . '
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td>Jenis Kelamin</td>
                                                    <td>' . ucwords(strtolower($view_rekam_medis['jenis_kelamin'])) . '</td>
                                                </tr>
                                                <tr>
                                                    <td>Alamat</td>
                                                    <td>' . $view_rekam_medis['alamat'] . '</td>
                                                </tr>
                                                <tr>
                                                    <td>Puskesmas</td>
                                                    <td>' . $view_rekam_medis['nm_puskesmas'] . '</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>';
        $html .= '
                        </div> <!-- </row-fluid> -->
                        <div class="clearfix"><br/></div>';
        $html .= '
            <h4 class="widgettitle">Kunjungan Pasien</h4>
            <div class="row-fluid">
                <div class="span12">
                    <table class="table table-bordered table-stripped table-hover" border="1">
                        <thead>
                        <tr align="center">
                            <th><b>No.</b></th>
                            <th><b>Tanggal</b></th>
                            <th><b>Puskesmas</b></th>
                            <th><b>Poli</b></th>
                            <th><b>Dokter</b></th>
                            <th><b>Anamnesa</b></th>
                            <th><b>Cat.Fisik</b></th>
                            <th><b>Penyakit</b></th>
                            <th><b>Tindakan</b></th>
                            <th><b>Obat (Dosis) (Jml)</b></th>
                        </tr>
                        </thead>
                        <tbody>';
        if (isset($view_trans_pelayanan) && !empty($view_trans_pelayanan)) {
            $i = 1;
            foreach ($view_trans_pelayanan as $rs) {
                if ($rs['anamnesa'] == '0') {
                    $rs['anamnesa'] = "-";
                }
                if ($rs['catatan_fisik'] == '0') {
                    $rs['catatan_fisik'] = "-";
                }
                if ($rs['tindakan'] == '') {
                    $rs['tindakan'] = "-";
                }
                if ($rs['dokter'] == '') {
                    $rs['dokter'] = "-";
                }
                $html .= '<tr>
                                    <td>' . $i . '</td>
                                    <td>' . $this->functions->convert_date_indo(array("datetime" => $rs['tgl_pelayanan'])) . '</td>
                                    <td>' . $rs['nm_puskesmas'] . '</td> <!-- jenis layanan diganti poli mana -->
                                    <td>' . $rs['unit_layanan'] . '</td>
                                    <td>' . $rs['dokter'] . '</td>
                                    <td>' . $rs['anamnesa'] . '</td>
                                    <td>' . $rs['catatan_fisik'] . '</td>
                                    <td>' . $rs['kd_icd'] . ' - ' . $rs['penyakit'] . '</td>
                                    <td>' . $rs['tindakan'] . '</td>';
                $pecahObat = explode(';', $rs['obat']);
                $pecahDosis = explode(';', $rs['dosis']);
                $pecahJml = explode(';', $rs['jml_obat']);
                $obatku = '';
                for ($z = 0; $z < count($pecahObat); $z++) {
                    $obatku .= $pecahObat[$z] . " (" . $pecahDosis[$z] . ") (" . $pecahJml[$z] . ")";
                    if ($z != count($pecahObat) - 1) {
                        $obatku .= " \n- ";
                    }
                }
                $html .= '


                                    <td>' . $obatku . '</td>

                                </tr>';
                $i++;
            }
        } else {
            $html .= '

                            <tr>
                                <td colspan="11"><center>Tidak ada riwayat kunjungan</center></td>
                            </tr>';
        }
        $html .= '
                        </tbody>
                    </table>
                </div>
            </div>
            </div> <!-- </widgetcontent> -->
            </div>';
        $pdf->SetTitle('Judul');
        $pdf->SetHeaderMargin(30);
        $pdf->SetTopMargin(20);
        $pdf->setFooterMargin(20);
        $pdf->SetAutoPageBreak(true);
        $pdf->SetAuthor('Pengarang');
        $pdf->SetDisplayMode('real', 'default');
        $pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, '', true);
        $pdf->Output('Rekam Medis.pdf', 'I');
    }