?> </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; }