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');
}
