function cetakPDF() { ini_set('memory_limit', '512M'); $this->output->enable_profiler(FALSE); $this->load->library('TCPDF'); $stock = new stock_model(); $store = $this->orm->refstore->where('idrefstore', $_SESSION['user']['idrefstore'])->fetch(); $image_store = ($store['image_file'] == "" or $store['image_file'] == NULL) ? "./front_assets/img/bizon_inventory.jpg" : "./uploads/stores/" . $store['image_file']; //print_r(json_encode($data)); exit; // create new PDF document $pdf = new PDFLaporanRekapitulasi(PDF_PAGE_ORIENTATION, PDF_UNIT, 'A4', true, 'UTF-8', false); // set document information $pdf->SetCreator(WEB_TITLE); $pdf->SetAuthor($this->session->userdata('email')); $pdf->SetTitle("Laporan Stock Control"); $pdf->SetSubject('Laporan Stock Control'); $pdf->namaStore = $store['nama']; $pdf->image = $image_store; // 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(5, 45, 5); $pdf->SetHeaderMargin(10); $pdf->SetFooterMargin(10); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); // --------------------------------------------------------- // 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 times to reduce file size. $fontname = $pdf->addTTFfont('./Tahoma.ttf', 'TrueTypeUnicode', '', 96); // use the font $pdf->SetFont($fontname, '', 10, '', false); // Add a page // This method has several options, check the source code documentation for more information. $pdf->AddPage('L'); // Set some content to print $html = ' <style type="text/css"> .rotate-text { /* Safari */ -webkit-transform: rotate(-90deg); /* Firefox */ -moz-transform: rotate(-90deg); /* IE */ -ms-transform: rotate(-90deg); /* Opera */ -o-transform: rotate(-90deg); /* Internet Explorer */ filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=3); } .border-table{ border:0.5px solid #000; } table.border { border-width: 1px; border-spacing: 2px; border-style: outset; border-color: gray; border-collapse: separate; background-color: white; border:0.5px solid #000; } table.border th { border-width: 1px; padding: 1px; border-style: outset; border-color: gray; background-color: white; -moz-border-radius: ; border:0.5px solid #000; } table.border td { border-width: 0px; padding: 3px 3px3px 3px; border-style: inline; border-color: gray; background-color: white; -moz-border-radius: ; padding-left : 3px; padding-right : 3px; } table.border tr { border-width: 1px; padding: 1px; border-style: outset; border-color: gray; background-color: white; -moz-border-radius: ; } </style> <body> '; $html .= '<table class="border" width="100%"> <thead> <tr> <th width="35"><b>No</b></th> <th><b>Kode Barang</b></th> <th width="280"><b>Nama Barang</b></th> <th><b>Jenis Barang</b></th> <th width="80"><b>Stock Awal</b></th> <th width="80"><b>Stock</b></th> <th><b>Gudang</b></th> </tr> </thead> <tbody>'; $no = 1; foreach ($this->orm->refbarang->where('idrefstore', $_SESSION['user']['idrefstore'])->order('kodebarang ASC') as $row) { $refjenisbarang = $this->orm->refjenisbarang->where('idrefjenisbarang', $row['idrefjenisbarang'])->fetch(); $html .= '<tr> <td width="35">' . $no . '</td> <td>' . $row['kodebarang'] . '</td> <td width="280">' . $row['namabarang'] . '</td> <td>' . $refjenisbarang['jenisbarang'] . '</td> <td width="80">' . $row['stockawal'] . '</td> <td width="80">' . $row['stock'] . '</td> <td>' . $row->refgudang['namagudang'] . '</td> </tr>'; $no++; } $html .= '</tbody> </table>'; $html .= '</body>'; //print_r($html); exit; // Print text using writeHTMLCell() $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true); // --------------------------------------------------------- // Close and output PDF document // This method has several options, check the source code documentation for more information. $pdf->Output("Laporan Stock Control.pdf", 'I'); //============================================================+ // END OF FILE //============================================================+ }
function cetakPDF($tanggal_dari, $tanggal_sampai, $idRefBarang = 0) { ini_set('memory_limit', '512M'); $this->output->enable_profiler(FALSE); $this->load->library('TCPDF'); $stock = new stock_model(); $store = $this->orm->refstore->where('idrefstore', $_SESSION['user']['idrefstore'])->fetch(); $image_store = ($store['image_file'] == "" or $store['image_file'] == NULL) ? "./front_assets/img/bizon_inventory.jpg" : "./uploads/stores/" . $store['image_file']; $data = $stock->_loadMutasi($tanggal_dari, $tanggal_sampai, $idRefBarang); $barang = $this->orm->refbarang->where('idrefbarang', $idRefBarang)->fetch(); //print_r(json_encode($data)); exit; // create new PDF document $pdf = new PDFLaporanRekapitulasi(PDF_PAGE_ORIENTATION, PDF_UNIT, 'A4', true, 'UTF-8', false); // set document information $pdf->SetCreator(WEB_TITLE); $pdf->SetAuthor($this->session->userdata('email')); $pdf->SetTitle("Laporan Surat Jalan"); $pdf->SetSubject('Laporan Surat Jalan'); $pdf->tanggal_dari = $tanggal_dari; $pdf->tanggal_sampai = $tanggal_sampai; $pdf->namaBarang = $barang['namabarang']; $pdf->jenisBarang = $barang->refjenisbarang['jenisbarang']; $pdf->namaStore = $store['nama']; $pdf->image = $image_store; // 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(5, 68, 5); $pdf->SetHeaderMargin(15); $pdf->SetFooterMargin(25); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); // --------------------------------------------------------- // 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 times to reduce file size. $fontname = $pdf->addTTFfont('./Tahoma.ttf', 'TrueTypeUnicode', '', 96); // use the font $pdf->SetFont($fontname, '', 10, '', false); // Add a page // This method has several options, check the source code documentation for more information. $pdf->AddPage('L'); // Set some content to print $html = ' <style type="text/css"> .rotate-text { /* Safari */ -webkit-transform: rotate(-90deg); /* Firefox */ -moz-transform: rotate(-90deg); /* IE */ -ms-transform: rotate(-90deg); /* Opera */ -o-transform: rotate(-90deg); /* Internet Explorer */ filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=3); } .border-table{ border:0.5px solid #000; } table.border { border-width: 1px; border-spacing: 2px; border-style: outset; border-color: gray; border-collapse: separate; background-color: white; border:0.5px solid #000; } table.border th { border-width: 1px; padding: 1px; border-style: outset; border-color: gray; background-color: white; -moz-border-radius: ; border:0.5px solid #000; } table.border td { border-width: 0px; padding: 3px 3px3px 3px; border-style: inline; border-color: gray; background-color: white; -moz-border-radius: ; padding-left : 3px; padding-right : 3px; } table.border tr { border-width: 1px; padding: 1px; border-style: outset; border-color: gray; background-color: white; -moz-border-radius: ; } </style> <body> '; $html .= ' <table cellpadding="0" cellspacing="0" class="border"> <tr class="border"> <th width="80" class="border" style="text-align: center;"><b>Tanggal</b></th> <th width="300" class="border" style="text-align: center;" ><b>Keterangan</b></th> <th class="border" style="text-align: center; "><b>No. DO </b></th> <th class="border" style="text-align: center; "><b>No. BPB</b></th> <th width="80" class="border" style="text-align: center; "><b>JUMLAH</b></th> <th width="80" class="border" style="text-align: center; "><b>SISA</b></th></tr> '; $no = 1; if (!empty($data)) { $tgl_stock_awal = strtotime('-1 day', strtotime($data[0]['tanggaltransaksi'])); $html .= '<tr>' . '<td style="text-align: center;"> ' . Tanggal::fieldDate(date('Y-m-d', $tgl_stock_awal)) . ' </td>' . '<td style="text-align: left;"> </td>' . '<td style="text-align: left;"> </td>' . '<td style="text-align: left;"> </td>' . '<td style="text-align: right;"> </td>' . '<td style="text-align: right;"> ' . number_format($data[0]['stockawalkirim'], 0, ',', '.') . '</td></tr>'; foreach ($data as $row) { $keterangan = ''; if ($row['transaksi'] == 'KIRIM') { $keterangan = 'Dikirim Ke ' . $row['namapelanggan']; } elseif ($row['transaksi'] == 'TERIMA') { $keterangan = 'Diterima Dari ' . $row['namasupplier']; } $saw = $stock->_getSaldoAwalBarang($idRefBarang, null, null, $row['idtransaksibarang']); $kirim = $row['jumlahkirim'] == null ? 0 : $row['jumlahkirim']; $terima = $row['jumlahterima'] == null ? 0 : $row['jumlahterima']; $saldo = $saw; $saldo = $saldo + $terima; $saldo = $saldo - $kirim; if ($kirim == 0) { $kirim = null; } if ($terima == 0) { $terima = null; } $html .= '<tr>' . '<td style="text-align: center;"> ' . Tanggal::fieldDate($row['tanggaltransaksi']) . ' </td>' . '<td style="text-align: left;"> ' . $keterangan . '</td>' . '<td style="text-align: left;"> ' . $row['nomordo'] . '</td>' . '<td style="text-align: left;"> ' . $row['nomorpengadaan'] . '</td>' . '<td style="text-align: right;"> ' . $kirim . $terima . '</td>' . '<td style="text-align: right;"> ' . $saldo . '</td></tr>'; $no++; } } $html .= '</table>'; $html .= '<br/> <br/> <br/> <hr/> <div style="text-align: center"> Akhir Laporan </div> </body>'; //print_r($html); exit; // Print text using writeHTMLCell() $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true); // --------------------------------------------------------- // Close and output PDF document // This method has several options, check the source code documentation for more information. $pdf->Output("Kartu Stock {$tanggal_dari} _ {$tanggal_sampai} _ {$barang['namabarang']}.pdf", 'I'); //============================================================+ // END OF FILE //============================================================+ }