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 authenticate() { $users = array('demo' => 'demo', 'admin' => 'admin'); $user = Users::model()->findByAttributes(array('user_id' => $this->username)); if ($user === null) { $this->errorCode = self::ERROR_USERNAME_INVALID; } else { if (!bCrypt::verify($this->password, $user->password)) { // $pass = $user->password; // $pass2 = $this->password; // $very = $this->encrypt($this->password); // $encrypt = $this->encrypt("nove"); // $enc = NEW bCrypt(); // $veryvied = $enc->verify($this->password, $user->password); $this->errorCode = self::ERROR_PASSWORD_INVALID; } else { $this->_id = $user->id; $this->username = $user->user_id; //$this->username = '******'; $this->errorCode = self::ERROR_NONE; $user->last_visit_date = get_date_today('yyyy-MM-dd HH:mm:ss'); $user->save(); } } return !$this->errorCode; }
function Now($formatDate = 'yyyy-MM-dd') { return get_date_today($formatDate) . ' ' . get_time_now(); }
public function actionPengeluaranPerKodeRekeningDetil() { 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']; $kode = $_POST['account_code']; $daftar_code = Pah::get_arr_kode_rekening_pengeluaran($kode); $index = 0; $objPHPExcel = new PHPExcel(); $objPHPExcel->getDefaultStyle()->getFont()->setSize(10); $file_name = 'PengeluaranPerKodeRekeningDetil'; foreach ($daftar_code as $key => $codename) { $start = 1; $worksheet_name = "{$key} - {$codename}"; if ($index > 0) { $objPHPExcel->createSheet($index); } $objPHPExcel->setActiveSheetIndex($index); $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.1 / 2.54); $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0.1 / 2.54); $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "LAPORAN DETIL PENGELUARAN " . strtoupper($codename))->getStyle("A{$start}")->getFont()->setSize(18)->setBold(true); $start++; $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PONDOK ASUH HARAPAN")->getStyle("A{$start}")->getFont()->setSize(14)->setBold(true); $start++; $objPHPExcel->getActiveSheet()->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->getActiveSheet()->setCellValue("A{$start}", "Tgl")->setCellValue("B{$start}", "Keterangan")->setCellValue("C{$start}", "Debit")->setCellValue("D{$start}", "Kredit")->getStyle("A{$start}:D{$start}")->getFont()->setBold(true); $start++; $rows = Pah::get_pengeluaran_detil_kode_rekening($start_date, $end_date, $key); $total = Pah::get_total_pengeluaran($start_date, $end_date, $key); $total_persen = 0; foreach ($rows as $row) { // $total_persen += $row['total_beban'] / $total; // $total_beban = $row['total_beban']; // $persen = $row['total_beban'] / $total; $objPHPExcel->getActiveSheet()->setCellValue("A{$start}", $row['tran_date'])->setCellValue("B{$start}", $row['memo_'])->setCellValue("C{$start}", $row['debit'])->setCellValue("D{$start}", $row['kredit']); $start++; } //$total_format = $format == 'excel' ? $total : acc_format($total); $objPHPExcel->getActiveSheet()->setCellValue("A{$start}", 'Total')->setCellValue($total > 0 ? "C{$start}" : "D{$start}", $total); // ->setCellValue("C$start", $format == 'excel' ? $total_persen : percent_format($total_persen, 2)); $start++; $end_body = $start - 1; $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))); $objPHPExcel->getActiveSheet()->getStyle("A{$start_body}:D{$end_body}")->applyFromArray($styleArray); $start_row = $start_body + 1; $objPHPExcel->getActiveSheet()->getStyle("C{$start_row}:D{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING); // $objPHPExcel->getActiveSheet()->getStyle("C$start_row:C$end_body")->getNumberFormat() // ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00); $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setAutoSize(true); $start++; $jemaat = get_jemaat_from_user_id(Yii::app()->user->getId()); $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Dicetak oleh: " . $jemaat->real_name); $start++; $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Pada tanggal " . get_date_today('dd/MM/yyyy') . " jam " . get_time_now()); $index++; } ob_end_clean(); ob_start(); 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'); Yii::app()->end(); } }
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(); }