protected function footer($objPHPExcel, $start, $file_name, $format, $html_title)
{
$start++;
$jemaat = get_jemaat_from_user_id(Yii::app()->user->getId());
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Dicetak oleh: " . $jemaat->real_name);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Pada tanggal " . get_date_today('dd/MM/yyyy') . " jam " . get_time_now());
ob_end_clean();
ob_start();
if ($format == 'excel') {
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename={$file_name}.xls");
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
} else {
$objPHPExcel->getActiveSheet()->setShowGridlines(false);
$mPDF1 = Yii::app()->ePdf->mpdf();
$mPDF1 = Yii::app()->ePdf->mpdf('', 'A4');
$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
$header = $objWriter->generateHTMLHeader(true);
$header = str_replace("<body>", "<body onload='window.print();'>", $header);
$header = str_replace("Untitled Spreadsheet", $html_title, $header);
$html = $header . $objWriter->generateStyles(true) . $objWriter->generateSheetData() . $objWriter->generateHTMLFooter();
if ($format == 'pdf') {
$mPDF1->WriteHTML($html);
$mPDF1->Output('MutasiKasDitangan.pdf', 'D');
} else {
echo $html;
}
}
}
public function view()
{
$objWriter = new PHPExcel_Writer_HTML($this->getPHPExcelObj());
$html['header'] = $objWriter->generateHTMLHeader();
$html['style'] = $objWriter->generateStyles(true);
// do not write <style> and </style>
$html['body'] = $objWriter->generateSheetData();
$html['footer'] = $objWriter->generateHTMLFooter();
return $html;
}
public function generate($format = "Excel5", $docName = "Tabelle")
{
switch ($format) {
case 'Excel2007':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel2007.php';
$writer = new PHPExcel_Writer_Excel2007($this);
$ext = 'xlsx';
$header = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
//supprime le pre-calcul
$writer->setPreCalculateFormulas(false);
break;
case 'Excel2003':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel2007.php';
$writer = new PHPExcel_Writer_Excel2007($this);
$writer->setOffice2003Compatibility(true);
$ext = 'xlsx';
//supprime le pre-calcul
$writer->setPreCalculateFormulas(false);
break;
case 'Excel5':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel5.php';
$writer = new PHPExcel_Writer_Excel5($this);
$ext = 'xls';
break;
case 'CSV':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/CSV.php';
$writer = new PHPExcel_Writer_CSV($this);
$writer->setDelimiter(",");
//l'op�rateur de s�paration est la virgule
$writer->setSheetIndex(0);
//Une seule feuille possible
$ext = 'csv';
break;
case 'PDF':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/PDF.php';
$writer = new PHPExcel_Writer_PDF($this);
$writer->setSheetIndex(0);
//Une seule feuille possible
$ext = 'pdf';
break;
case 'HTML':
include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/HTML.php';
$writer = new PHPExcel_Writer_HTML($this);
$writer->setSheetIndex(0);
//Une seule feuille possible
$ext = 'html';
break;
}
header('Content-type:' . $header);
header('Content-Disposition:inline;filename=' . $docName . '.' . $ext);
$writer->save('php://output');
}
/**
* Create a new PHPExcel_Writer_PDF
*
* @param PHPExcel $phpExcel PHPExcel object
*/
public function __construct(PHPExcel $phpExcel)
{
parent::__construct($phpExcel);
$this->setUseInlineCss(TRUE);
$this->_tempDir = PHPExcel_Shared_File::sys_get_temp_dir();
}
protected function getWriter()
{
$writer = new \PHPExcel_Writer_HTML($this->objPHPExcel);
$writer->setPreCalculateFormulas(false);
return $writer;
}
/**
* Create a new PHPExcel_Writer_PDF
*
* @param PHPExcel $phpExcel PHPExcel object
*/
public function __construct(PHPExcel $phpExcel)
{
parent::__construct($phpExcel);
$this->setUseInlineCss(true);
$this->_tempDir = sys_get_temp_dir();
}
public function actionPrint($id)
{
if (Yii::app()->request->isAjaxRequest) {
return;
}
// if (isset($_POST) && !empty($_POST)) {
$pinjam = $this->loadModel($id, 'MtKembaliKendaraan');
// $pinjam = new MtKembaliKendaraan;
$image = dirname(Yii::app()->getBasePath()) . '/images/mahkotrans.png';
$start = 1;
$file_name = 'KembaliKendaraan' . $pinjam->doc_ref_kembali;
$worksheet_name = 'Kembali Kendaraan ' . $pinjam->doc_ref_kembali;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getDefaultStyle()->getFont()->setSize(9);
$objPHPExcel->setActiveSheetIndex(0)->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Logo');
$objDrawing->setDescription('Logo');
$objDrawing->setPath($image);
$objDrawing->setHeight(30);
$objDrawing1 = clone $objDrawing;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0);
$objDrawing1->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing1->setCoordinates("A{$start}");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "MAHKOTRANS")->getStyle("A{$start}")->getFont()->setSize(14);
$start++;
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Villa Seturan Indah Blok D-10 Depok Sleman Yogyakarta 55281")->getStyle("A{$start}")->getFont()->setSize(6);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Telp. (0274) 7439982, 085292750055, 087838488822")->getStyle("A{$start}")->getFont()->setSize(6);
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PENGEMBALIAN KENDARAAN")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nomor Sewa / Kembali")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->doc_ref . " / " . $pinjam->doc_ref_kembali)->setCellValue("D{$start}", "Tanggal")->setCellValue("E{$start}", ": " . $pinjam->trans_date);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nama Konsumen")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->idPelanggan->nama)->setCellValue("D{$start}", "Kelompok Konsumen")->setCellValue("E{$start}", ": " . $pinjam->idPinjam->idKelompok->nama);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Tanda Pengenal")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->tanda_pengenal)->setCellValue("D{$start}", "No. Identitas")->setCellValue("E{$start}", ": " . $pinjam->idPinjam->no_identitas);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Jaminan")->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->jaminan . ", " . $pinjam->idPinjam->jaminan_desc);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Rencana Kembali")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->tgl_rencana_kembali)->setCellValue("D{$start}", "Kembali")->setCellValue("E{$start}", ": " . $pinjam->tgl_kembali);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nopol / Jenis Mobil")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->idMobil->nopol . " / " . $pinjam->idPinjam->idMobil->jenis)->setCellValue("D{$start}", "Season")->setCellValue("E{$start}", $pinjam->idPinjam->season == 0 ? ": Low" : ": High");
$start++;
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_DASHED)));
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PERHITUNGAN ONGKOS SEWA")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nama Item")->setCellValue("C{$start}", "Jumlah")->setCellValue("D{$start}", "Tarif")->setCellValue("G{$start}", "Total")->getStyle("B{$start}:G{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Mobil")->setCellValue("B{$start}", "Extend Per Bulan")->setCellValue("C{$start}", $pinjam->extend_bln)->setCellValue("D{$start}", $pinjam->idPinjam->trf_bulan)->setCellValue("G{$start}", $pinjam->extend_bln * $pinjam->idPinjam->trf_bulan);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $pinjam->extend_hari)->setCellValue("B{$start}", "Extend Per Hari")->setCellValue("D{$start}", $pinjam->idPinjam->trf_hari)->setCellValue("G{$start}", $pinjam->extend_hari * $pinjam->idPinjam->trf_hari);
$start++;
$extend_jam = $pinjam->extend_jam > 0 ? 1 : 0;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $extend_jam)->setCellValue("B{$start}", "Extend Per 12 Jam")->setCellValue("D{$start}", $pinjam->idPinjam->trf_jam)->setCellValue("G{$start}", $extend_jam * $pinjam->idPinjam->trf_jam);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $pinjam->overtime_jam)->setCellValue("B{$start}", "Overtime Per Jam")->setCellValue("D{$start}", $pinjam->idPinjam->trf_over_persen)->setCellValue("G{$start}", $pinjam->overtime_jam * $pinjam->idPinjam->trf_over_persen);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->setCellValue("A{$start}", "Lembar 1 : Untuk Konsumen")->setCellValue("C{$start}", "Total Extend")->setCellValue("G{$start}", $pinjam->ongkos_extend);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Total Sewa")->setCellValue("G{$start}", $pinjam->ongkos_sewa);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Driver")->setCellValue("G{$start}", $pinjam->ongkos_driver);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Bensin")->setCellValue("G{$start}", $pinjam->ongkos_bbm);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Total")->setCellValue("G{$start}", $pinjam->total_ongkos);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Diskon")->setCellValue("G{$start}", $pinjam->disc);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("C{$start}:F{$start}")->setCellValue("C{$start}", "DP " . $pinjam->trans_via . " / No. Bukti : " . $pinjam->no_bukti_bayar)->setCellValue("G{$start}", $pinjam->idPinjam->dp);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Pelunasan")->setCellValue("G{$start}", $pinjam->pelunasan);
// $start++;
// $objPHPExcel->setActiveSheetIndex(0)->mergeCells("A$start:G$start")->
// setCellValue("A$start", " ");
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->setCellValue("A{$start}", "Penyewa,")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Managemen Mahkotrans,")->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->getStyle("A{$start}")->applyFromArray($styleArray);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->getStyle("D{$start}")->applyFromArray($styleArray);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("C{$start_body}:G{$start}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING);
//=================================================================================================================
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objDrawing->setCoordinates("A{$start}");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "MAHKOTRANS")->getStyle("A{$start}")->getFont()->setSize(14);
$start++;
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Villa Seturan Indah Blok D-10 Depok Sleman Yogyakarta 55281")->getStyle("A{$start}")->getFont()->setSize(6);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Telp. (0274) 7439982, 085292750055, 087838488822")->getStyle("A{$start}")->getFont()->setSize(6);
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PENGEMBALIAN KENDARAAN")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nomor Sewa / Kembali")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->doc_ref . " / " . $pinjam->doc_ref_kembali)->setCellValue("D{$start}", "Tanggal")->setCellValue("E{$start}", ": " . $pinjam->trans_date);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nama Konsumen")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->idPelanggan->nama)->setCellValue("D{$start}", "Kelompok Konsumen")->setCellValue("E{$start}", ": " . $pinjam->idPinjam->idKelompok->nama);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Tanda Pengenal")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->tanda_pengenal)->setCellValue("D{$start}", "No. Identitas")->setCellValue("E{$start}", ": " . $pinjam->idPinjam->no_identitas);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Jaminan")->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->jaminan . ", " . $pinjam->idPinjam->jaminan_desc);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Rencana Kembali")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->tgl_rencana_kembali)->setCellValue("D{$start}", "Kembali")->setCellValue("E{$start}", ": " . $pinjam->tgl_kembali);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nopol / Jenis Mobil")->setCellValue("B{$start}", ": " . $pinjam->idPinjam->idMobil->nopol . " / " . $pinjam->idPinjam->idMobil->jenis)->setCellValue("D{$start}", "Season")->setCellValue("E{$start}", $pinjam->idPinjam->season == 0 ? ": Low" : ": High");
$start++;
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_DASHED)));
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PERHITUNGAN ONGKOS SEWA")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Nama Item")->setCellValue("C{$start}", "Jumlah")->setCellValue("D{$start}", "Tarif")->setCellValue("G{$start}", "Total")->getStyle("B{$start}:G{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Mobil")->setCellValue("B{$start}", "Extend Per Bulan")->setCellValue("C{$start}", $pinjam->extend_bln)->setCellValue("D{$start}", $pinjam->idPinjam->trf_bulan)->setCellValue("G{$start}", $pinjam->extend_bln * $pinjam->idPinjam->trf_bulan);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $pinjam->extend_hari)->setCellValue("B{$start}", "Extend Per Hari")->setCellValue("D{$start}", $pinjam->idPinjam->trf_hari)->setCellValue("G{$start}", $pinjam->extend_hari * $pinjam->idPinjam->trf_hari);
$start++;
$extend_jam = $pinjam->extend_jam > 0 ? 1 : 0;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $extend_jam)->setCellValue("B{$start}", "Extend Per 12 Jam")->setCellValue("D{$start}", $pinjam->idPinjam->trf_jam)->setCellValue("G{$start}", $extend_jam * $pinjam->idPinjam->trf_jam);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", $pinjam->overtime_jam)->setCellValue("B{$start}", "Overtime Per Jam")->setCellValue("D{$start}", $pinjam->idPinjam->trf_over_persen)->setCellValue("G{$start}", $pinjam->overtime_jam * $pinjam->idPinjam->trf_over_persen);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->setCellValue("A{$start}", "Lembar 2 : Untuk Arsip")->setCellValue("C{$start}", "Total Extend")->setCellValue("G{$start}", $pinjam->ongkos_extend);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Total Sewa")->setCellValue("G{$start}", $pinjam->ongkos_sewa);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Driver")->setCellValue("G{$start}", $pinjam->ongkos_driver);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Bensin")->setCellValue("G{$start}", $pinjam->ongkos_bbm);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Total")->setCellValue("G{$start}", $pinjam->total_ongkos);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Diskon")->setCellValue("G{$start}", $pinjam->disc);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("C{$start}:F{$start}")->setCellValue("C{$start}", "DP " . $pinjam->trans_via . " / No. Bukti : " . $pinjam->no_bukti_bayar)->setCellValue("G{$start}", $pinjam->idPinjam->dp);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C{$start}", "Pelunasan")->setCellValue("G{$start}", $pinjam->pelunasan);
// $start++;
// $objPHPExcel->setActiveSheetIndex(0)->mergeCells("A$start:G$start")->
// setCellValue("A$start", " ");
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->setCellValue("A{$start}", "Penyewa,")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Managemen Mahkotrans,")->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:B{$start}")->getStyle("A{$start}")->applyFromArray($styleArray);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->getStyle("D{$start}")->applyFromArray($styleArray);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("C{$start_body}:G{$start}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING);
ob_end_clean();
ob_start();
$objPHPExcel->getActiveSheet()->setShowGridlines(false);
$mPDF1 = Yii::app()->ePdf->mpdf('', 'A4', 0, '', 5, 5, 6, 0, 0, 0, 'P');
$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
$html = $objWriter->generateStyles(true) . $objWriter->generateSheetData();
$html = str_replace('.' . $image, app()->getBaseUrl(true) . '/images/mahkotrans.png', $html);
$mPDF1->WriteHTML($html);
$mPDF1->Output($file_name, 'D');
Yii::app()->end();
}
/**
* @Title: exports_exc
* @Description: todo(导出execl或者PDF或者直接打印)
* @param 导出的数据 $date
* @param 导出文件模板路径 $filePath
* @param 状态值 $step 1：表示答应或者导出execl 其他代表导出PDF
* @param 其他指定坐标信息 $tsdate $tsdate=array('A1'=>$_POST['projectname'].$proname);
* @param 打印标记 $isprint 1表示打印
* @param 审核信息数组 $auditdate
* @author liminggang
* @date 2014-5-5 下午5:47:53
* @throws
*/
public function exports_exc($date, $filePath, $step = 1, $tsdate = array(), $isprint, $auditdate = array())
{
import('@.ORG.PHPExcel', '', $ext = '.php');
//创建一个PHPExcel对象
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($filePath);
/**读取excel文件中的第一个工作表*/
$currentSheet = $objPHPExcel->getSheet(0);
/**取得最大的列号*/
$allColumn = $currentSheet->getHighestColumn();
/**取得一共有多少行*/
$allRow = $currentSheet->getHighestRow();
for ($currentRow = 2; $currentRow <= $allRow; $currentRow++) {
/**从第A列开始输出*/
for ($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn++) {
$val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65, $currentRow)->getValue();
/**ord()将字符转为十进制数*/
/**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将gb2312编码转为utf-8编码输出
* 如果存在ereg判断汉字问题。则必须用utf-8，不然不识别汉字
* */
$val = iconv('utf-8', 'utf-8', $val) . "\t";
$val = trim($val);
if (isset($date[$val])) {
$objPHPExcel->getActiveSheet()->setCellValue($currentColumn . $currentRow, $date[$val], '');
}
}
}
if ($auditdate) {
$coutnrow = $allRow + 1;
$style = array('font' => array('name' => '黑体', 'bold' => true, 'italic' => false), 'borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_MEDIUM), 'top' => array('style' => PHPExcel_Style_Border::BORDER_MEDIUM), 'left' => array('style' => PHPExcel_Style_Border::BORDER_MEDIUM), 'right' => array('style' => PHPExcel_Style_Border::BORDER_MEDIUM)), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER));
foreach ($auditdate as $k => $v) {
for ($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn++) {
$objPHPExcel->getActiveSheet()->getStyle($currentColumn . $coutnrow)->applyFromArray($style);
}
$objPHPExcel->getActiveSheet()->setCellValue("A" . $coutnrow, $v['name']);
$objPHPExcel->getActiveSheet()->mergeCells("B" . $coutnrow . ":" . $allColumn . $coutnrow)->setCellValue("B" . $coutnrow, $v['doinfo']);
$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(40);
$coutnrow++;
}
}
foreach ($tsdate as $row => $d) {
$objPHPExcel->getActiveSheet()->setCellValue($row, $d);
}
if ($step == 1) {
if ($isprint == 1) {
//打印
$objExcel = new PHPExcel();
$objWriteHTML = new PHPExcel_Writer_HTML($objPHPExcel);
//输出网页格式的对象
$objWriteHTML->save(UPLOAD_Sample . "tbprint.html");
echo json_encode(UPLOAD_Sample . "tbprint.html");
} else {
//转execl
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
ob_end_clean();
//清除缓冲区,避免乱码
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . time() . '.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
} else {
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'pdf');
//设置文件头信息
header('Content-Type: application/pdf');
header('Content-Disposition: attachment;filename="' . time() . '.pdf"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'pdf');
//设置字体
$objWriter->SetFont('arialunicid0-chinese-simplified');
$objWriter->save('php://output');
}
exit;
}
public function actionMutasiKasDiTangan()
{
if (Yii::app()->request->isAjaxRequest) {
return;
}
if (isset($_POST) && !empty($_POST)) {
$format = $_POST['format'];
$start_date = $_POST['trans_date_mulai'];
$end_date = $_POST['trans_date_sampai'];
$start = 1;
$file_name = 'MutasiKas';
$worksheet_name = 'Mutasi Kas';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->setActiveSheetIndex(0)->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objPHPExcel->setActiveSheetIndex(0)->getPageMargins()->setLeft(0.1 / 2.54);
$objPHPExcel->setActiveSheetIndex(0)->getPageMargins()->setRight(0.1 / 2.54);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "MUTASI KAS DI TANGAN")->getStyle("A{$start}")->getFont()->setSize(18)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PONDOK ASUH HARAPAN")->getStyle("A{$start}")->getFont()->setSize(14)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PERIODE: " . sql2long_date($start_date) . " - " . sql2long_date($end_date))->getStyle("A{$start}")->getFont()->setSize(12)->setBold(true);
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$start++;
$start++;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Doc. Ref")->setCellValue("B{$start}", "Tanggal")->setCellValue("C{$start}", "Payee/Payor")->setCellValue("D{$start}", "Nama Rekening")->setCellValue("E{$start}", "Kas Masuk")->setCellValue("F{$start}", "Kas Keluar")->setCellValue("G{$start}", "Saldo Kas")->getStyle("A{$start}:G{$start}")->getFont()->setBold(true);
$start++;
$rows = Pah::get_mutasi_kas_ditangan($start_date, $end_date);
$nomer = 1;
$saldo = 0;
foreach ($rows as $row) {
$saldo += $row['saldo'];
// $kas_masuk = $row['kas_masuk'] == 0 ? '' : ($format == 'excel' ? $row['kas_masuk'] : number_format($row['kas_masuk']));
// $kas_keluar = $row['kas_keluar'] == 0 ? '' : ($format == 'excel' ? -$row['kas_keluar'] : number_format(-$row['kas_keluar']));
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", $nomer)->setCellValue("B{$start}", sql2date($row['trans_date']))->setCellValue("C{$start}", Pah::get_payee_payoor($row['type'], $row['trans_no']))->setCellValue("D{$start}", $row['nama_rekening'])->setCellValue("E{$start}", $kas_masuk)->setCellValue("F{$start}", $kas_keluar)->setCellValue("G{$start}", $format == 'excel' ? $saldo : number_format($saldo));
$nomer++;
$start++;
}
$end_body = $start - 1;
$styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:G{$end_body}")->applyFromArray($styleArray);
$start_row = $start_body + 1;
if ($format == 'excel') {
$objPHPExcel->setActiveSheetIndex(0)->getStyle("E{$start_row}:G{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING);
} else {
$objPHPExcel->setActiveSheetIndex(0)->getStyle("E{$start_body}:G{$end_body}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
}
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("A")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("B")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("C")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("D")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("E")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("F")->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension("G")->setAutoSize(true);
$start++;
$jemaat = get_jemaat_from_user_id(Yii::app()->user->getId());
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Dicetak oleh: " . $jemaat->real_name);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Pada tanggal " . get_date_today('dd/MM/yyyy') . " jam " . get_time_now());
ob_end_clean();
ob_start();
if ($format == 'excel') {
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename={$file_name}.xls");
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
} else {
$objPHPExcel->getActiveSheet()->setShowGridlines(false);
$mPDF1 = Yii::app()->ePdf->mpdf();
$mPDF1 = Yii::app()->ePdf->mpdf('', 'A4');
$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
$header = $objWriter->generateHTMLHeader(true);
$header = str_replace("<body>", "<body onload='window.print();'>", $header);
$header = str_replace("Untitled Spreadsheet", "Mutasi Kas di Tangan", $header);
$html = $header . $objWriter->generateStyles(true) . $objWriter->generateSheetData() . $objWriter->generateHTMLFooter();
if ($format == 'pdf') {
$mPDF1->WriteHTML($html);
$mPDF1->Output('MutasiKasDitangan.pdf', 'D');
} else {
echo $html;
}
// header('Content-Type: application/pdf');
// header("Content-Disposition: attachment;filename='$file_name.pdf'");
// header('Cache-Control: max-age=0');
// $objPHPExcel->getActiveSheet()->setShowGridlines(false);
// $rendererName = PHPExcel_Settings::PDF_RENDERER_MPDF;
// $rendererLibraryPath = Yii::app()->basePath . '/vendors/mpdf';
// if (!PHPExcel_Settings::setPdfRenderer($rendererName,$rendererLibraryPath)) {
// die(
// 'Please set the $rendererName and $rendererLibraryPath values' .
// PHP_EOL .
// ' as appropriate for your directory structure'
// );
// }
//
// $objWriter = new PHPExcel_Writer_PDF($objPHPExcel);
// $objWriter->save('php://output');
}
Yii::app()->end();
}
}
function generateBook($book, $format) {
$this->book= $book;
if (!$book->bookId)
$bookName= "spreadsheet-1";
else
$bookName= "spreadsheet-$book->bookId";
$filename= "default-".rand(1,9999);
/*SET SPREADSHEET PROPERTIES*/
if ($format!= "ods"){
$this->objPHPExcel = new PHPExcel();
$this->objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$this->objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$this->objPHPExcel->getProperties()->setTitle("Test Document");
$this->objPHPExcel->getProperties()->setSubject("Test Document");
$this->objPHPExcel->getProperties()->setDescription("Test document generated using PHP classes.");
$this->objPHPExcel->getProperties()->setKeywords("office php");
$this->objPHPExcel->getProperties()->setCategory("Test result file");
}
else{
$this->objPHPOds= new PHPOds(); //create a new ods file
}
/*GENERATE THE SHEETS*/
$this->_generateSheets($format);
global $cnf;
$currentDir= $cnf['path']['Temp']."/"; // Get the Storage Folder
switch($format){
case "ods":
saveOds($this->objPHPOds,"$filename.$format"); //save the object to a ods file
break;
case "pdf":
$objWriter1 = new PHPExcel_Writer_PDF($this->objPHPExcel);
$objWriter1->writeAllSheets();
$objWriter1->setTempDir($currentDir);
$objWriter1->save("$filename.$format"); //save the object to a pdf file
break;
case "xls":
$objWriter2 = new PHPExcel_Writer_Excel5($this->objPHPExcel);
$objWriter2->setTempDir($currentDir);
$objWriter2->save("$filename.$format"); //save the object to a xls file
break;
case "xlsx":
$objWriter3 = PHPExcel_IOFactory::createWriter($this->objPHPExcel, 'Excel2007');
$objWriter3->save($currentDir."$filename.$format"); //save the object to a xlsx file
break;
case "csv":
$objWriter4 = new PHPExcel_Writer_CSV($this->objPHPExcel);
//$objWriter4->setTempDir($currentDir);
$objWriter4->setDelimiter(';');
$objWriter4->setEnclosure('');
$objWriter4->setLineEnding("\r\n");
$objWriter4->save("$filename.$format"); //save the object to a CSV file
break;
case "html":
$objWriter5 = new PHPExcel_Writer_HTML($this->objPHPExcel);
$objWriter5->writeAllSheets();
//$objWriter5->setTempDir($currentDir);
$objWriter5->save("$filename.$format"); //save the object to a HTML file
break;
}
if ($format != "ods")
$this->_send("$filename.$format", $format, $bookName);
}
public function actionPrint($id)
{
if (Yii::app()->request->isAjaxRequest) {
return;
}
// if (isset($_POST) && !empty($_POST)) {
$kas_masuk = $this->loadModel($id, 'MtKasMasuk');
// $pinjam = new MtPinjamKendaraan;
$image = dirname(Yii::app()->getBasePath()) . '/images/mahkotrans.png';
$start = 1;
$file_name = 'KasMasuk' . $kas_masuk->doc_ref;
$worksheet_name = 'Kas Masuk ' . $kas_masuk->doc_ref;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getDefaultStyle()->getFont()->setSize(9);
$objPHPExcel->setActiveSheetIndex(0)->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Logo');
$objDrawing->setDescription('Logo');
$objDrawing->setPath($image);
$objDrawing->setHeight(30);
$objDrawing1 = clone $objDrawing;
$start_body = $start;
$objPHPExcel->setActiveSheetIndex(0);
$objDrawing1->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing1->setCoordinates("A{$start}");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "MAHKOTRANS")->getStyle("A{$start}")->getFont()->setSize(14);
$start++;
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Villa Seturan Indah Blok D-10 Depok Sleman Yogyakarta 55281")->getStyle("A{$start}")->getFont()->setSize(6);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Telp. (0274) 7439982, 085292750055, 087838488822")->getStyle("A{$start}")->getFont()->setSize(6);
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "KUITANSI")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "No : " . $kas_masuk->doc_ref)->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", " ")->getStyle("B{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Telah terima dari");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': ' . $kas_masuk->dari);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Sebagai pembayaran");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': ' . $kas_masuk->note);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Uang sejumlah");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': Rp ' . number_format($kas_masuk->amount, 2));
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Yogyakarta, " . get_date_today('dd MMMM yyyy'))->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Staf Mahkotrans")->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//=================================================================================================================
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objDrawing->setCoordinates("A{$start}");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "MAHKOTRANS")->getStyle("A{$start}")->getFont()->setSize(14);
$start++;
$objPHPExcel->getActiveSheet()->setTitle($worksheet_name);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Villa Seturan Indah Blok D-10 Depok Sleman Yogyakarta 55281")->getStyle("A{$start}")->getFont()->setSize(6);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Telp. (0274) 7439982, 085292750055, 087838488822")->getStyle("A{$start}")->getFont()->setSize(6);
$styleArray = array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start_body}:G{$start}")->applyFromArray($styleArray);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "KUITANSI")->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle("A{$start}")->getFont()->setSize(12);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "No : " . $kas_masuk->doc_ref)->getStyle("A{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", " ")->getStyle("B{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Telah terima dari");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': ' . $kas_masuk->dari);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Sebagai pembayaran");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': ' . $kas_masuk->note);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$start}", "Uang sejumlah");
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("B{$start}:G{$start}")->setCellValue("B{$start}", ': Rp ' . number_format($kas_masuk->amount, 2));
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Yogyakarta, " . get_date_today('dd MMMM yyyy'))->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", " ")->getStyle("A{$start}")->getFont()->setSize(16)->setBold(true);
$start++;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("D{$start}:G{$start}")->setCellValue("D{$start}", "Staf Mahkotrans")->getStyle("D{$start}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
ob_end_clean();
ob_start();
$objPHPExcel->getActiveSheet()->setShowGridlines(false);
$mPDF1 = Yii::app()->ePdf->mpdf('', 'A4', 0, '', 10, 10, 5, 0, 0, 0, 'P');
$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
$html = $objWriter->generateStyles(true) . $objWriter->generateSheetData();
$html = str_replace('.' . $image, app()->getBaseUrl(true) . '/images/mahkotrans.png', $html);
$mPDF1->WriteHTML($html);
$mPDF1->Output($file_name, 'D');
Yii::app()->end();
}