?>
</td>
<td><?php
echo $records[$iRow]->NAMA_CUST;
?>
</td>
<td><?php
echo $records[$iRow]->VLT;
?>
</td>
<td><?php
echo $records[$iRow]->KET;
?>
</td>
<td><?php
echo DATE_FORMAT_($records[$iRow]->TGL_INPUT);
?>
</td>
<td><?php
echo $records[$iRow]->NO_URUT;
?>
</td>
<td><?php
echo $records[$iRow]->BRG;
?>
</td>
<td><?php
echo $records[$iRow]->NAMABARANG;
?>
</td>
<td><?php
<td width="50%">
Tanggal SO
</td>
<td width="50%">:
<?php
echo DATE_FORMAT_($record_hdr->TGL);
?>
</td>
</tr>
<tr>
<td width="50%">
Tanggal Delivery
</td>
<td width="50%">:
<?php
echo DATE_FORMAT_($record_hdr->TGL_KIRIM);
?>
</td>
</tr>
<tr>
<td width="50%">
Cara Bayar
</td>
<td width="50%">:
</td>
</tr>
</table>
</td>
<td style="width:43%; height:200px; text-align: left;">
<table border="0">
function excel_recap_data()
{
$records = $this->model_so->get_so_header_detail($this->input->post());
foreach ($records as &$detail) {
$detail->B_APP = $this->_str_status_approve_so($detail);
}
$this->load->library('pexcel');
// Create new PHPExcel object
$sheet = new PHPExcel();
// Set document properties
$sheet->getProperties()->setCreator("MKD.JuiceBoxV2")->setTitle("Office 2007 XLSX User Document")->setSubject("Office 2007 XLSX User Document")->setDescription("User document for Office 2007 XLSX")->setKeywords("office 2007")->setCategory("Recap");
// Add some data
$sheet->setActiveSheetIndex(0)->setCellValue('A2', 'NO')->setCellValue('B2', 'NO. BUKTI')->setCellValue('C2', 'TANGGAL')->setCellValue('D2', 'TANGGAL KIRIM')->setCellValue('E2', 'STATUS')->setCellValue('F2', 'NO. PO. CUSTOMER')->setCellValue('G2', 'NAMA CUSTOMER')->setCellValue('H2', 'VALUTA/KURS')->setCellValue('I2', 'KETERANGAN')->setCellValue('J2', 'TANGGAL INPUT')->setCellValue('K2', 'APPROVE');
$sheet->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$sheet->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$sheet->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$sheet->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$sheet->getActiveSheet()->getColumnDimension('E')->setWidth(5);
$sheet->getActiveSheet()->getColumnDimension('F')->setWidth(25);
$sheet->getActiveSheet()->getColumnDimension('G')->setWidth(25);
$sheet->getActiveSheet()->getColumnDimension('H')->setWidth(15);
$sheet->getActiveSheet()->getColumnDimension('I')->setWidth(25);
$sheet->getActiveSheet()->getColumnDimension('J')->setWidth(25);
$sheet->getActiveSheet()->getColumnDimension('K')->setWidth(10);
$no = 1;
$i = 3;
foreach ($records as $record) {
$sheet->setActiveSheetIndex(0)->setCellValue("A{$i}", $no)->setCellValue("B{$i}", $record->NO_BUKTI)->setCellValue("C{$i}", DATE_FORMAT_($record->TGL))->setCellValue("D{$i}", DATE_FORMAT_($record->TGL_KIRIM))->setCellValue("E{$i}", $record->STATUS)->setCellValue("F{$i}", $record->NO_PO_CUST)->setCellValue("G{$i}", $record->NAMA_CUST)->setCellValue("H{$i}", $record->VLT)->setCellValue("I{$i}", $record->KET)->setCellValue("J{$i}", DATE_FORMAT_($record->TGL_INPUT))->setCellValue("K{$i}", $record->B_APP);
$i++;
$no++;
}
// Rename worksheet (worksheet, not filename)
$sheet->getActiveSheet()->setTitle('sheet1');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$sheet->setActiveSheetIndex(0);
//this is the header given from PHPExcel examples. but the output seems somewhat corrupted in some cases.
//header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
//so, we use this header instead.
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="recap.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($sheet, 'Excel2007');
$objWriter->save('php://output');
// die( $this->load->view('pb/list_data_ajax', $data, TRUE));
die;
}
