$pdf->Line(74 + 42 * $i, 16.2, 74 + 42 * $i, 16 + 10); } $pdf->SetLineWidth(0.2); // Grosor por defecto // PRIMERA FILA $pdf->SetFont('NewsGotT', 'B', 10); $pdf->SetWidths(array(63, 42, 42, 42, 42, 42)); $pdf->SetAligns(array('L', 'C', 'C', 'C', 'C', 'C')); $pdf->Row(array('', 'LUNES', 'MARTES', 'MIÉRCOLES', 'JUEVES', 'VIERNES')); // SEGUNDA FILA $pdf->SetWidths(array(8, 55, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7)); $pdf->SetAligns(array('C', 'L', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->Row(array('#', 'Alumno/a', '1', '2', '3', '4', '5', '6', '1', '2', '3', '4', '5', '6', '1', '2', '3', '4', '5', '6', '1', '2', '3', '4', '5', '6', '1', '2', '3', '4', '5', '6')); // RESTO DE LA TABLA $pdf->SetFont('NewsGotT', '', 10); $pdf->SetFillColor(239, 240, 239); // Color de sombreado // Consultamos los alumnos del grupo seleccionado $result = mysqli_query($db_con, "SELECT nc, CONCAT(apellidos,', ',nombre) AS alumno FROM FALUMNOS WHERE unidad='{$unidad}' ORDER BY nc ASC"); $i = 0; while ($alumno = mysqli_fetch_array($result)) { if ($i % 2 == 0) { $somb = 'DF'; } else { $somb = ''; } $pdf->Row(array($alumno['nc'], substr($alumno['alumno'], 0, 40), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), $somb); $pdf->SetLineWidth(0.6); // Grosor de linea for ($j = 0; $j < 6; $j++) { if ($i < 34) {
require_once "linegraph.php"; require_once "diagram.php"; require_once "/fpdf/fpdf.php"; //$picture = "D://xampp//htdocs//BroadcastSystem//images//abs_cbn logo.png"; $pdf = new PDF_MC_Table(); $pdf->Open(); $pdf->AddPage('L'); //$pdf->Image($picture,20,5,20,20); $pdf->SetFont("Arial", "B", "16"); $pdf->Cell(0, 10, "Broadcast System & Maintenance", 0, 1, "C"); $pdf->SetFont("Arial", "", "12"); $pdf->Cell(0, 10, "Technical Operation Division", 0, 1, "C"); $pdf->SetFont("Arial", "B", "14"); $pdf->SetXY(10, 35); $pdf->SetTextColor(255, 255, 255); $pdf->SetFillColor(64, 64, 64); $pdf->Cell(0, 10, "List of All Reports", 0, 1, "C", 1); $pdf->SetTextColor(0, 0, 0); $pdf->SetFont("Arial", "B", "12"); $pdf->SetXY(10, 50); $pdf->Write(5, "Rep#"); $pdf->SetXY(30, 50); $pdf->Write(5, "Date"); $pdf->SetXY(50, 50); $pdf->Write(5, "Location"); $pdf->SetXY(75, 50); $pdf->Write(5, "Machine"); $pdf->SetXY(105, 50); $pdf->Write(5, "Serial #"); $pdf->SetXY(135, 50); $pdf->Write(5, "Program");
//$pdf->AddPage('L'); $pdf->SetDisplayMode(100, "single"); $pdf->SetTitle("Netherhall House"); $border = 1; $high = 6; $width1 = 180; $width2 = $width1 / 2; $width3 = $width1 / 3; $width4 = $width1 / 4; /* $pdf->SetFont('Arial','B',12); $pdf->Cell(180,$high,"OUTSTANDING SUMMARY",0,0,'C',true); $pdf->Ln(); $pdf->Ln(); */ $pdf->SetFillColor(255, 255, 255); $pdf->SetFont('Arial', 'B', 18); $pdf->Cell(180, $high, $arrResident[name] . " " . $arrResident[surname], 0, 0, '', true); $pdf->SetFont('Arial', '', 8); $pdf->Ln(); $pdf->Ln(); $pdf->SetFillColor(230, 230, 230); $pdf->Cell(16, $high, "Arrival", $border, 0, '', true); $pdf->Cell(16, $high, "Departure", $border, 0, '', true); $pdf->Cell(9, $high, "Days", $border, 0, 'R', true); $pdf->Cell(10, $high, "Room", $border, 0, '', true); $pdf->Cell(13, $high, "W. Rate", $border, 0, 'R', true); $pdf->Cell(15, $high, "Total", $border, 0, 'R', true); $pdf->Cell(13, $high, "Laundry", $border, 0, 'R', true); $pdf->Cell(13, $high, "HC", $border, 0, 'R', true); $pdf->Cell(13, $high, "Printing", $border, 0, 'R', true);
function reporteKardexProduccion() { $txtFechaInicio = $_REQUEST['txtFechaInicio']; $txtFechaFinal = $_REQUEST['txtFechaFinal']; $idProducto = $_REQUEST['idProducto']; $idTipoMovimiento = $_REQUEST['idTipoMovimiento']; $idTipoOperacion = $_REQUEST['idTipoOperacion']; $txtDescripcion = $_REQUEST['txtDescripcion']; $reporte = $this->AutoLoadModel('reporte'); $datos = $reporte->reporteKardexProduccion($txtFechaInicio, $txtFechaFinal, $idProducto, $idTipoMovimiento, $idTipoOperacion); $cantidadData = count($datos); $pdf = new PDF_MC_Table("L", "mm", "A4"); $titulos = array('#', 'FECHA', 'T. MOV.', 'CONCEPTO', 'ORDEN', 'RAZON SOCIAL', 'DEVOLUCION', 'PRECIO', 'CANT. ', 'SALDO', 'IMPORTE S/.'); $pdf->SetFont('Helvetica', 'B', 7.5); $ancho = array(8, 18, 20, 30, 18, 70, 20, 20, 15, 15, 20); $orientacion = array('', 'C', 'C', '', 'C', '', 'C', 'R', 'C', 'C', 'R'); $tipoCambioVentas = $this->configIni($this->configIni('Globals', 'Modo'), 'TipoCambio'); $pdf->SetWidths($ancho); if (!empty($txtFechaFinal) || !empty($txtFechaInicio)) { $fecha1 = !empty($txtFechaInicio) ? $txtFechaInicio : utf8_decode('?'); $fecha2 = !empty($txtFechaFinal) ? $txtFechaFinal : utf8_decode('?'); $pdf->_fecha = 'Rango Fecha: ' . $fecha1 . ' - ' . $fecha2; } $pdf->_titulo = "REPORTE::KARDEX DE PRODUCCION"; $pdf->_datoPie = $txtDescripcion . ' ' . 'Impreso el :' . date('Y-m-d H:m:s'); $pdf->AddPage(); $pdf->_titulos = $titulos; $relleno = true; $pdf->fill($relleno); $pdf->SetFillColor(0224, 235, 255); $pdf->SetTextColor(0); $pdf->SetDrawColor(12, 78, 139); $pdf->SetLineWidth(0.3); $pdf->_orientacion = $orientacion; $pdf->SetAligns($orientacion); $pdf->SetTitulos($titulos); $pdf->SetFillColor(0224, 235, 255); $pdf->SetTextColor(0); $pdf->SetDrawColor(12, 78, 139); $importeFactura = 0; $importeBoleta = 0; for ($i = 0; $i < $cantidadData; $i++) { $modoFactura = ""; $fila = array($i + 1, $datos[$i]['fecha'], $datos[$i]['tipo movimiento'], $datos[$i]['concepto movimiento'], $datos[$i]['codigov'], html_entity_decode($datos[$i]['razon social'], ENT_QUOTES, 'UTF-8'), $datos[$i]['devolucion'], number_format($datos[$i]['precio'], 2), $datos[$i]['cantidad'], $datos[$i]['saldo'], number_format(round($datos[$i]['precio'], 2) * $datos[$i]['cantidad'], 2)); $pdf->Row($fila); $relleno = !$relleno; $pdf->fill($relleno); } $pdf->AliasNbPages(); $pdf->Output(); }
} //----------------------------------------------------------------------------- //-----------------------Inicio pdf--------------------------------------------- $pdf = new PDF_MC_Table('L', 'mm', 'Letter'); $pdf->AddFont('GillSans', '', 'GillSans.php'); $pdf->AddFont('GillSans', 'B', 'GillSans_B.php'); $pdf->AddFont('GillSans', 'BI', 'GillSans_BI.php'); $pdf->AddFont('GillSans', 'I', 'GillSans_I.php'); $pdf->AddFont('GillSans', 'L', 'GillSans_L.php'); $pdf->AddFont('GillSans', 'LI', 'GillSans_LI.php'); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetLeftMargin(25); //---------------------------------------------- $pdf->SetFont('GillSans', '', 10); $pdf->SetFillColor(249, 250, 252); $pdf->Cell(70, 4, ' Estructura Programática ', 0, 0, 'L', 0); $pdf->Cell(70, 4, 'Ejercicio: 2015 ', 0, 0, 'L', 0); $pdf->Ln(5); $pdf->SetFont('GillSans', 'B', 10); $pdf->Cell(240, 4, 'Catálogo de Programas', 1, 1, 'C', 1); $pdf->SetFont('GillSans', '', 10); $y = $pdf->GetY(); $x = $pdf->GetX(); $pdf->MultiCell(20, 8, 'ID', 1, 'C', 1); $pdf->SetXY($x + 20, $y); $pdf->MultiCell(40, 8, 'Clave', 1, 'C', 1); $pdf->SetXY($x + 60, $y); $pdf->MultiCell(150, 8, 'Descripción', 1, 'C', 1); $pdf->SetXY($x + 210, $y); $pdf->Cell(30, 8, 'Tipo', 1, 0, 'C', 1);
$pdf->SetXY(1.5, 3); function DateToIndo($bulan, $tahun) { // fungsi atau method untuk mengubah tanggal ke format indonesia // variabel BulanIndo merupakan variabel array yang menyimpan nama-nama bulan $BulanIndo = array("JANUARI", "FEBRUARI", "MARET", "APRIL", "MEI", "JUNI", "JULI", "AGUSTUS", "SEPTEMBER", "OKTOBER", "NOVEMBER", "DESEMBER"); $result = $BulanIndo[(int) $bulan - 1] . " " . $tahun; return $result; } $sql = "SELECT gudang FROM gl_gudang WHERE id = '{$cabang}' "; $cekdata = mysql_query($sql) or die(mysql_error()); $row_data = mysql_fetch_array($cekdata); $pdf->Cell(8, 3, "CABANG : " . $row_data['gudang'], 0, 0, 'L'); //HEADER TABLE $pdf->SetFont('Arial', 'B', 11); $pdf->SetFillColor(125, 125, 125); $pdf->SetTextColor(255, 255, 255); $pdf->SetXY(1, 5); $pdf->Cell(1, 0.7, "No", 1, 0, 'C', true); $pdf->Cell(2.8, 0.7, "UNIT", 1, 0, 'C', true); $days = array(); for ($i = 1; $i <= $num; $i++) { $pdf->Cell(0.8, 0.7, "{$i}", 1, 0, 'C', true); } $pdf->Cell(3.8, 0.7, "CASHIN", 1, 0, 'C', true); $pdf->Cell(3.8, 0.7, "CASHOUT", 1, 0, 'C', true); $pdf->Cell(3.8, 0.7, "PPN", 1, 1, 'C', true); //ISI TABLE global $datesArray, $query2, $arr; unset($datesArray); $datesArray[] = array();