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Í</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(); }
$ctx = $result->fields['ctx']; if (Session::hostAllowed_by_ip_ctx($dbconn, $hostIP, $ctx)) { //$pdf->MultiCell(70, 6, "".getrisk($risk)." : $riskcount" ,0,0,'C'); $riskArray[getrisk($risk)] += $riskcount; if (!array_key_exists($risk, $risk_in_graph)) { $colorarray[$index] = getriskcolor($risk); $risk_in_graph[$risk] = 1; $index++; } } $result->MoveNext(); } $pdf->Ln(); $pdf->Ln(); //$pdf->SetXY(85, 53); #$valY); $pdf->SetXY(85, 48); #$valY); $pdf->PieChart(140, 40, $riskArray, '%l', $colorarray); $pdf->SetXY($valX, $valY + 31); //Host-Vulnerability Summary $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $total_number2 = _("Total number of vulnerabilities identified per system"); if ($chinese) { $total_number2 = mb_convert_encoding($total_number2, 'Big5', 'HTML-ENTITIES'); $pdf->SetFont('Big5', '', 10); } else { $total_number2 = mb_convert_encoding($total_number2, 'ISO-8859-1', 'HTML-ENTITIES'); $pdf->SetFont('Helvetica', 'B', 12); }
$hostIP = $result->fields['hostIP']; if (Session::hostAllowed_by_ip_ctx($dbconn, $hostIP, $hostctx)) { //$pdf->MultiCell(70, 6, "".getrisk($risk)." : $riskcount" ,0,0,'C'); $riskArray[getrisk($risk)] += $riskcount; if (!array_key_exists($risk, $risk_in_graph)) { $colorarray[$index] = getriskcolor($risk); $risk_in_graph[$risk] = 1; $index++; } } $result->MoveNext(); } $pdf->Ln(); $pdf->Ln(); //$pdf->SetXY(85, 53); #$valY); $pdf->SetXY(85, 45); #$valY); $pdf->PieChart(140, 40, $riskArray, '%l', $colorarray); $pdf->SetXY($valX, $valY + 30); //Host-Vulnerability Summary $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $total_number2 = _("Total number of vulnerabilities identified per system"); if ($chinese) { $total_number2 = mb_convert_encoding($total_number2, 'Big5', 'HTML-ENTITIES'); $pdf->SetFont('Big5', '', 10); } else { $total_number2 = mb_convert_encoding($total_number2, 'ISO-8859-1', 'HTML-ENTITIES');
public function generarListadoGneral() { $departamento = $this->input->get("departamento") != 'null' ? '=' . $this->input->get("departamento") : '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->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->getlistadogeneraldosdos($departamento); $depa = $this->ReporteGeneral_model->getdpto($departamento); } if ($username['idusuario'] == 18) { $depaafinanzas = $this->empleado_model->buscarDepartamentoUsuario($username['cedula'], $username['nacionalidad']); foreach ($depaafinanzas->result_array() as $row) { $dat[] = array('depa' => $row['departamento']); } $departamento2 = $row['departamento']; $arredepar18 = array(4, 5, 11, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 28, 29, 30); if ($departamento != 'LIKE "%"') { if (in_array($this->input->get("departamento"), $arredepar18)) { $depa = $this->ReporteGeneral_model->getdptotres($departamento); } else { $depa = $this->ReporteGeneral_model->getdptotresdos($departamento2); } } else { $depa = $this->ReporteGeneral_model->getdptotresdos($departamento2); } $resultado2 = $this->ReporteGeneral_model->getlistadogeneraldosdos($departamento); } if ($username['idusuario'] != 13 && $username['idusuario'] != 18) { $resultado2 = $this->ReporteGeneral_model->getlistadogenerall($username['idusuario']); $depa = $this->empleado_model->buscarDepartamentoUsuario($username['cedula'], $username['nacionalidad']); } if ($resultado2->num_rows() > 0) { foreach ($depa->result_array() as $row) { if ($username['idusuario'] == 13) { $resultado = $this->ReporteGeneral_model->getlistadogeneraldos($row['departamento']); } if ($username['idusuario'] == 18) { $resultado4 = $this->ReporteGeneral_model->gettotalempeladosafinanzas($row['departamento']); $resultado3 = $this->ReporteGeneral_model->gettotalPermisosafinanzas($row['departamento']); $resultado = $this->ReporteGeneral_model->getlistadogeneraldos($row['departamento']); } if ($username['idusuario'] != 13 && $username['idusuario'] != 18) { $resultado = $this->ReporteGeneral_model->getlistadogenerall($username['idusuario']); } // $pdf->SetXY(10, 05); // $pdf->Image('imagen/logo/Logo-Nuevo-Gober-sin-borde.png', '', '', 60, 0, '', '', 'T', false, 300, '', false, false, 1, false, false, false); // $pdf->SetXY(170, 10); // $pdf->Image('imagen/logo/LARA-PROGRESISTA-CON-BORDE.png', '', '', 22, 0, '', '', 'T', false, 300, '', false, false, 1, false, false, false); $pdf->Ln(20); $pdf->SetFont('Times', 'B', 16); $pdf->SetXY('15', 40); $pdf->Text(14, 35, 'Departamento: ' . $row['nombre']); $pdf->SetFont('times', '', 12, '', true); $pdf->SetFillColor('150', '210', '255'); $pdf->SetXY(15, 50); $pdf->MultiCell(35, 10, 'Oficina', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Personal', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Laboral', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Medico', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Estudio', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Sindical', 1, 0, 'C', 0); $pdf->MultiCell(20, 10, 'Total', 1, 0, 'R', 0); $pdf->MultiCell(30, 10, 'Nro. Empleados', 1, 1, 'C', 1); $idoficina = 'null'; $motivo = array(); $tot = 0; foreach ($resultado->result_array() as $fila) { $tot = $tot + 1; if ($idoficina != $fila['id']) { if ($idoficina != null) { $result = 0; foreach ($motivo as $re) { if ($re != 0) { $result = $result + $re; } $pdf->Cell(20, 25, $re, 1, 0, 'C', 0, '', 0); // VALORES DEL ULTIMO } unset($motivo); $motivo = array(); $pdf->MultiCell(35, 25, $row['nombre'], 1, 0, 'C', 0); $mot1 = $fila["Personal"]; $mot2 = $fila["Laboral"]; $mot3 = $fila["Medico"]; $mot4 = $fila["Estudio"]; $mot5 = $fila["Sindical"]; array_push($motivo, $mot1, $mot2, $mot3, $mot4, $mot5); $idoficina = $fila['id']; } else { if ($tot == 1) { $pdf->SetFillColor('190'); $pdf->MultiCell(35, 25, $row['nombre'], 1, 0, 'C', 0); $mot1 = $fila["Personal"]; $mot2 = $fila["Laboral"]; $mot3 = $fila["Medico"]; $mot4 = $fila["Estudio"]; $mot5 = $fila["Sindical"]; array_push($motivo, $mot1, $mot2, $mot3, $mot4, $mot5); $idoficina = $fila['id']; } } } 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, 25, $re, 1, 0, 'C', 0, '', 0); // VALORES DEL ULTIMO } $pdf->Cell(20, 25, $result2, 1, 0, 'C', 1); if ($username['idusuario'] == 18) { $resultado4 = $this->ReporteGeneral_model->gettotalempeladosafinanzas($row['departamento']); $resultado3 = $this->ReporteGeneral_model->gettotalPermisosafinanzas($row['departamento']); } else { $resultado4 = $this->ReporteGeneral_model->gettotalempelados($row['departamento']); $resultado3 = $this->ReporteGeneral_model->gettotalPermisos($row['departamento']); } foreach ($resultado4->result_array() as $fila2) { if ($fila2['departamento'] == $row['departamento']) { $pdf->Cell(30, 25, $fila2["total"], 1, 1, 'C', 1); } } $pdf->AddPage(); } } else { $pdf->SetFont('Times', 'B', 18); $pdf->Text(14, 12, 'No se encuentran autorización(es) con las características indicadas.'); } $pdf->Output('resumengeneral.pdf', 'I'); }
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'); }
/** * Index Page for this controller. * * Maps to the following URL * http://example.com/index.php/welcome * - or - * http://example.com/index.php/welcome/index * - or - * Since this controller is set as the default controller in * config/routes.php, it's displayed at http://example.com/ * * So any other public methods not prefixed with an underscore will * map to /index.php/welcome/<method_name> * @see http://codeigniter.com/user_guide/general/urls.html */ public function ubet() { $this->load->library('pdf'); $pdf = new Pdf('L', 'mm', 'A4', true, 'UTF-8', false); //$pdf->setPrintHeader(false); //$pdf->setPrintFooter(false); $pdf->SetPrintFooter(false); //$pdf->SetAutoPageBreak(true, 9); $pdf->SetFont('dejavusans', '', 10); //$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); $pdf->AddPage(); $pdf->SetFillColor(255, 255, 127); //$pdf->SetFont('helvetica', 'B', 12); //$pdf->getPageDimensions(); //$hasBorder = false; //flag for fringe case $sql = "select customerName,contactLastName,contactFirstName from customers"; $sqlq = $this->db->query($sql); $sqla = $sqlq->result_array(); //print_r($sqla); //exit(); $page = 0; foreach ($sqla as $row) { $maxnocells = 0; $cellcount = 0; //write text first $startX = $pdf->GetX(); $startY = $pdf->GetY(); //draw cells and record maximum cellcount //cell height is 6 and width is 80 $cellcount = $pdf->MultiCell(30, 6, $row['customerName'], 0, 'L', 0, 0); if ($cellcount > $maxnocells) { $maxnocells = $cellcount; } $cellcount = $pdf->MultiCell(80, 6, $row['contactLastName'], 0, 'L', 0, 0); if ($cellcount > $maxnocells) { $maxnocells = $cellcount; } $cellcount = $pdf->MultiCell(80, 6, $row['contactFirstName'], 0, 'L', 0, 0); if ($cellcount > $maxnocells) { $maxnocells = $cellcount; } $page++; $pdf->SetXY($startX, $startY); //if($page>20){ //$pdf->AddPage(); //$page=0; //} //now do borders and fill //cell height is 6 times the max number of cells $pdf->MultiCell(30, $maxnocells * 6, '', 1, 'L', 0, 0); $pdf->MultiCell(80, $maxnocells * 6, '', 1, 'L', 0, 0); $pdf->MultiCell(80, $maxnocells * 6, '', 1, 'L', 0, 0); $pdf->Ln(); } //$pdf->Cell(240,0,'','T'); //last bottom border $pdf->Output('example_005.pdf', 'I'); }