/** * Erzeugt ein PDF auf Basis der übergebenen Funktion. * @param $module * @param $action * @param $param * @param null $filename falls kein Dateiname angegeben wird, wird das PDF direkt im Browser ausgegeben * @throws \Exception */ public static function generate($module, $action, $param, $filename = null, $template = true, $margin = 0) { $druckinhalt = new WrapperControl(null, 'druck'); $druckinhalt->setModule($module)->setAction($action)->addParams($param); $pdf = new \mPDF('de-DE', 'A4'); $pdf->SetDisplayMode('fullpage'); // Zeigt eine ganze Seite an, wenn das PDF in Acrobat geöffnet wird if ($margin > 0) { $pdf->SetTopMargin($margin); } $pdf->SetFooter('Seite {PAGENO} / {nb}'); //file_get_contents('https://maxcdn.bootstrapcdn.com/bootstrap/3.3.1/css/bootstrap.min.css') . $stylesheet = file_get_contents('templates/print/css/default.css'); $pdf->WriteHTML($stylesheet, 1); if ($template && file_exists('site/Print.template.html')) { $vars = ['heading' => Application::getCurrentResponse()->getMetadata()->getHeading()]; $header = Parser::parse(null, null, $vars, file_get_contents('site/Print.template.html')); $pdf->WriteHTML($header, 2); } $pdf->WriteHTML($druckinhalt->toHtml(), 2); if ($filename === null) { $pdf->Output($module . $action . '.pdf', 'I'); } else { //$filename = Files::validateFilename($filename); $pdf->Output($filename, 'F'); } unset($pdf); }
public function ActionCreatePDF($id) { $mpdf = Yii::app()->ePdf->mpdf(); $model_historia = $this->loadModel($id); $model_historiaO_paciente = HistoriaObstetricia::model()->getHistoriasObstetriciaByPaciente($model_historia->paciente->id); $model_historiaG_paciente = HistoriaGinecologia::model()->getHistoriasGinecologicasByPaciente($model_historia->paciente->id); $historia = array($model_historiaG_paciente, $model_historiaO_paciente); $stylesheet = file_get_contents('C:\\wamp\\www\\Gineobs\\themes\\hebo\\css\\pdfMain.css'); //configurando pdf general $mpdf = new mPDF('utf-8', 'Letter-L'); //agregando header y footer $mpdf->SetHeader('{DATE j-m-Y}||Recipe #' . $model_historia->paciente->id); $mpdf->SetFooter('Dr. María Hernández|Ginecologia y obstetricia|{PAGENO}'); //Propiedades del PDF $mpdf->setTitle("Historia Medica"); $mpdf->setAuthor("María Hernández"); $mpdf->setCreator("Edgar Cardona y Gabriela Soto"); $mpdf->setSubject("Historia medica de pacientes."); $mpdf->setKeywords("Historia,Medicina"); //escribiendo CSS $mpdf->WriteHTML($stylesheet, 1); //Escribiendo PDF $mpdf->writeHTML($this->renderPartial('historia', array('model' => $model_historia->paciente->id, 'historia' => $historia), true), 2); //Salida $mpdf->output("Recipe Medico", EYiiPdf::OUTPUT_TO_DOWNLOAD); }
static public function mpdf( $html_path, $pdf_path, $css_rel_path, $format = 'A4', $download = false) { // reporting komplett abschalten $error_reporting = error_reporting(); error_reporting(0); ProjectConfiguration::registerMPDF(); $mpdf=new mPDF('ch-DE',$format,'8','DejaVuSansCondensed',15,15,30,15,10,10); $mpdf->packTableData = true; //$mpdf->debug = true; $mpdf->SetDisplayMode('fullpage'); $mpdf->defaultfooterfontstyle=''; $mpdf->defaultfooterfontsize='8'; $mpdf->SetFooter(basename($pdf_path).'|Stand: {DATE j.m.Y H:i}|Seite {PAGENO}/{nbpg}'); $mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list $mpdf->shrink_tables_to_fit=1; // LOAD a stylesheet #$stylesheet = file_get_contents(sfConfig::get('sf_web_dir').'/css/backend/pdf/class_etat.css'); $stylesheet = file_get_contents(sfConfig::get('sf_web_dir').'/css/'.$css_rel_path); $mpdf->WriteHTML($stylesheet,1); // parameter 1 indicates this is css $html = file_get_contents($html_path); $mpdf->WriteHTML($html,2); //$mpdf->SetTitle(); $mpdf->SetAuthor(''); $mpdf->SetCreator('rockstep'); if ($download) { $mpdf->Output( $pdf_path, 'I'); } else { $mpdf->Output( $pdf_path, 'F'); } error_reporting($error_reporting); }
public static function GerarPdf($html, $titulo = null, $paisagem = false, $nomePdf = null) { $mpdf = new mPDF(); $mpdf->allow_charset_conversion = true; $mpdf->charset_in = 'utf-8'; if ($paisagem == true) { $mpdf->CurOrientation = 'l'; } //Exibir a pagina inteira no browser //$mpdf->SetDisplayMode('fullpage'); //Cabeçalho: Seta a data/hora completa de quando o PDF foi gerado + um texto no lado direito if ($titulo != null) { $mpdf->SetHeader("{$titulo}"); } //Rodapé: Seta a data/hora completa de quando o PDF foi gerado + um texto no lado direito $mpdf->SetFooter("{DATE j/m/Y H:i}|{PAGENO}/{nb}| {$titulo}"); $mpdf->WriteHTML($html); // define um nome para o arquivo PDF if ($nomePdf == null) { $nomePdf = time() . '.pdf'; } $mpdf->Output($nomePdf, 'I'); }
function pdf($html, $filename = null, $cabecalho = '', $rodape = '') { require APPPATH . "helpers/mpdf/mpdf.php"; $mpdf = new mPDF(); //$mpdf->allow_charset_conversion=true; $mpdf->charset_in = 'utf-8'; //Exibir a pagina inteira no browser $mpdf->SetDisplayMode('fullpage'); //Cabeçalho: Seta a data/hora completa de quando o PDF foi gerado + um texto no lado direito if ($cabecalho !== '') { $mpdf->SetHeader('{DATE j/m/Y H:i}| | ' . $cabecalho); } //Rodapé: Seta a data/hora completa de quando o PDF foi gerado + um texto no lado direito if ($rodape !== '') { $mpdf->SetFooter($rodape); } $mpdf->WriteHTML($html); // define um nome para o arquivo PDF if ($filename == null) { $filename = date("Y-m-d_his") . '_impressao.pdf'; } $mpdf->Output($filename, 'I'); }
function preDisplay() { parent::preDisplay(); $tour = new Tour(); $html = file_get_contents("custom/modules/Tours/tpls/basic_pdf.tpl"); $html = str_replace("{NAME}", $this->bean->name, $html); $desc = html_entity_decode_utf8($this->bean->description); $desc = $tour->removeHtmlTags($desc); $html = str_replace("{TOUR_NOTE}", $desc, $html); $picture = '<img width="627" height="312" src="modules/images/' . $this->bean->picture . '">'; $html = str_replace("{PICTURE}", $picture, $html); $html = str_replace("{CODE}", $this->bean->tour_code, $html); $html = str_replace("{DURATION}", $this->bean->duration, $html); $html = str_replace("{TRANSPORT}", $this->bean->transport2, $html); $html = str_replace("{START_DATE}", $this->bean->start_date, $html); $program = html_entity_decode_utf8($tour->get_data_to_export2pdf($_GET['record'])); $html = str_replace("{TOUR_PROGRAM_LINES}", $program, $html); // Xuat ra pdf $mpdf = new mPDF("vi"); $mpdf->SetFooter('{PAGENO}'); $mpdf->WriteHTML($html); $mpdf->Output("Tour.pdf", "D"); exit; }
public function gerarRelatorio($data = NULL, $origem = NULL) { //verificando a sessao $this->verificarSessao(); //iniciando o relatório $mpdf = new mPDF('', '', 0, '', 15, 15, 35, 16, 9, 9, 'L'); //tamanho do pdf $mpdf->SetDisplayMode('fullpage'); //cabeçalho $mpdf->SetHeader('|Faculdade de Tecnologia Dom Amaury Castanho <br /> Av. Tiradentes, 1211 - Parque Industrial, Itu - SP, 13309-640 <br />(11) 4013-1872|'); //rodapé $mpdf->SetFooter('|Página {PAGENO} de {nb}|www.fatecitu.edu.br'); switch ($origem) { case 1: $html = $this->load->view('relatorio/modelos/historicoAtivo_view', $data, true); //titulo $mpdf->SetTitle('Histórico do Ativo'); //conteúdo $mpdf->WriteHTML($html); //gerar pdf $mpdf->Output('historicoDoAtivo.pdf', 'D'); break; case 2: $html = $this->load->view('relatorio/modelos/ativosPorLocal_view', $data, true); //titulo $mpdf->SetTitle('Ativos por Local'); //conteúdo $mpdf->WriteHTML($html); //gerar pdf $mpdf->Output('ativosPorLocal.pdf', 'D'); break; case 3: //titulo $mpdf->SetTitle('Relatório de Divergência'); $html = $this->load->view('relatorio/modelos/divergencia_view', $data, true); $mpdf->WriteHTML($html); //adicionando uma nova página $mpdf->AddPage(); $html = $this->load->view('relatorio/modelos/ativosLocalErrado_view', $data, true); $mpdf->WriteHTML($html); //adicionando uma nova página $mpdf->AddPage(); $html = $this->load->view('relatorio/modelos/ativoNaoEncontrado_view', $data, true); $mpdf->WriteHTML($html); //gerar pdf $mpdf->Output('assets/docs/' . $data['id'] . '.pdf', 'F'); $mpdf->Output('relatorioDeDivergencia.pdf', 'D'); break; } redirect('ativo/carregarRelatorio'); }
//============================================================== //============================================================== //============================================================== include "../mpdf.php"; $mpdf = new mPDF('', 'A4', '', '', 32, 25, 27, 25, 16, 13); $mpdf->mirrorMargins = 1; $mpdf->SetDisplayMode('fullpage', 'two'); $mpdf->useOnlyCoreFonts = true; $mpdf->defaultfooterfontsize = 13; $mpdf->AddPage(); $mpdf->Image('clematis.jpg', 0, 0, 210, 297, 'jpg', '', true, false); // e.g. the last "false" allows a full page picture $mpdf->y = 70; $mpdf->Shaded_box('mPDF Example File', 'Arial', '', 28, '70%', 'DF', 3, '#FFFFFF', '#000044', 10); $mpdf->AddPage(); $mpdf->SetFooter('{PAGENO}'); $mpdf->WriteHTML($html); $mpdf->AddPage('', 'NEXT-EVEN'); $mpdf->SetFooter(); $mpdf->SetAlpha(0.5); $mpdf->Image('clematis.jpg', 0, 0, 210, 297, 'jpg', '', true, false); // e.g. the last "false" allows a full page picture $mpdf->SetAlpha(1); $mpdf->writeBarcode('978-0-9542246-0-8', 1, 130, 230, 1, 0, 3, 3, 4, 4); // Save the pages to a file $mpdf->Output('test.pdf', 'F'); //============================================================== //============================================================== //============================================================== //============================================================== //==============================================================
/*********************************************************************/ /*Generar el reporte del dia, todos los tours */ /* */ /*********************************************************************/ $hotel = $_GET['hotel']; $table_header = ""; include "../mpdf/mpdf.php"; $mpdf = new mPDF(”); //the table stylesheet $stylesheet = file_get_contents('../mpdf/examples/mpdfstyletables.css'); $mpdf->WriteHTML($stylesheet, 1); //$mpdf->useDefaultCSS2 = true; //set header and footer to the pdf $mpdf->SetHeader('{DATE j-m-Y h:i:s}| <h5>Operadora Zacatecas S.A de C.V<h5> |{PAGENO}'); $mpdf->SetFooter('|Operadora|'); $mpdf->WriteHTML('<br/>'); $texto = "ERROR: "; //archivo de configuracion include 'config.php'; $mysqli = new mysqli($hostdb, $usuariodb, $clavedb, $nombredb); /* comprobar la conexión */ if (mysqli_connect_errno()) { echo $texto . mysqli_connect_error(); /**printf("Falló la conexión: %s\n", mysqli_connect_error());**/ exit; } //Consultar todos los hoteles activos en la base de datos //Esta consulta carga la clave de los hoteles //$consulta = 'SELECT th.id_tour, t.nombre_tour, th.horario, t.numero_tour FROM tourhorario th, tours t WHERE th.id_tour = t.id_tour'; $consulta = "SELECT clave_hotel, nombre_hotel FROM institucion WHERE clave_hotel='" . $hotel . "'";
$deduct = $totSetA - $totSetAB; } } $outNum = "This is :{$totSetA} and This is :{$totSetAB}"; //$html.='<table style="font-size:14px" width="1015" border="0"> //<tr> // <td width="48%">'.date('m/d/Y').' - Current Payment</td> // <td width="52%" align="right">$-'.number_format($what[0],2).'</td> //</tr> //</table>'; $html .= '</td> </tr> </table> <table style="font-family:Arial, Helvetica, sans-serif; font-size:18px;" width="1025" border="0"> <tr> <td height="38" align="right">$' . number_format($deduct, 2) . '</td> </tr> </table><pagebreak/> '; } } $mpdf = new mPDF(); $mpdf->SetHTMLHeader(''); $mpdf->SetFooter(''); $mpdf->WriteHTML($html); $mpdf->Output(); //$mpdf->Output('filename.pdf','F'); exit; //============================================================== //============================================================== //==============================================================
public function pdfReportAction(Request $request) { $html = $request->getSession()->get('pdf'); //$html = utf8_encode($html); $mpdf = new \mPDF(); //$mpdf->WriteHTML('<pagebreak sheet-size="A5-L" />'); //$L = "L"; //$mpdf->_setPageSize("A4",$L); $mpdf->defaultheaderfontsize = 10; /* in pts */ $mpdf->defaultheaderfontstyle = B; /* blank, B, I, or BI */ $mpdf->defaultheaderline = 1; /* 1 to include line below header/above footer */ $mpdf->defaultfooterfontsize = 12; /* in pts */ $mpdf->defaultfooterfontstyle = B; /* blank, B, I, or BI */ $mpdf->defaultfooterline = 1; /* 1 to include line below header/above footer */ $mpdf->SetHeader('{DATE j-m-Y}|{PAGENO}|Reportes SISCONEE'); $mpdf->SetFooter('{PAGENO}'); /* defines footer for Odd and Even Pages - placed at Outer margin */ $mpdf->WriteHTML($html); $mpdf->Output(); exit; }
public function download() { $data_id = $this->uri->segment(4); $pembiayaan = $this->clients_pembiayaan_model->get_pembiayaan($data_id)->result(); $pembiayaan = $pembiayaan[0]; //print_r($pembiayaan); $html = ""; $html .= '<style> @page{ margin-top: 1cm; margin-bottom: 1cm; margin-left: 1cm; margin-right: 1cm;} body, p{ font-family: Helvetica, Arial;font-size: 12px;line-height: 130%;} .tbl{border-collapse: collapse;border: none;} .tbl thead{border-bottom: 1px solid #000;} .tbl td, .tbl th{padding: 3px;border: none;} .clear{float: none;clear: both} h2{ line-height: 130%; } </style>'; $html .= "<div style=''>"; $html .= '<h2 align="center">PERNYATAAN PEMBIAYAAN<br/>"AL IJARAH (JASA) / AL HIWALAH (PENALANGAN)"<br/>KOPERASI AMARTHA INDONESIA</h2>'; $html .= '<hr/>'; $html .= '<p>Yang bertanda tangan di bawah ini :</p>'; $html .= '<table class="tbl">'; $html .= '<tr><td width="30px">1.</td><td width="80px">Nama</td><td width="250px"> : <b>' . $pembiayaan->officer_name . '</b></td><td width="80px"> </td><td width="200px"></td></tr>'; $html .= '<tr><td></td><td>Jabatan</td><td colspan="3"> : <b>Field Officer Amartha Indonesia</b></td></tr>'; $html .= '<tr><td></td><td colspan="4">Bertindak atas nama Koperasi Amartha Indonesia untuk selanjutnya Pihak Pertama</td></tr>'; $html .= '<tr><td></td><td colspan="4"> </td></tr>'; $html .= '<tr><td>2.</td><td>Nama</td><td> : <b>' . $pembiayaan->client_fullname . '</b></td><td>Majelis</td><td> : <b>' . $pembiayaan->group_name . '</b></td></tr>'; $html .= '<tr><td></td><td>Alamat</td><td> : <b>' . $pembiayaan->client_kampung . ', ' . $pembiayaan->client_desa . '' . $pembiayaan->client_kecamatan . '</b></td><td>Pekerjaan</td><td> : <b>' . $pembiayaan->client_job . '</b></td></tr>'; $html .= '<tr><td></td><td>No. KTP</td><td> : <b>' . $pembiayaan->client_ktp . '</b></td><td></td><td></td></tr>'; $html .= '<tr><td></td><td colspan="4">Dalam hal ini bertindak atas nama pribadi, selanjutnya dalam perjanjian ini disebut Pihak Kedua.</td></tr>'; $html .= '</table>'; $html .= '<br/>'; $html .= '<p>Menerangkan telah sepakat untuk membuat persetujuan aqad Al Ijaroh /Al Hiwalah sebagaimana tercantum di bawah ini :</p>'; $html .= '<table class="tbl">'; $html .= '<tr><td width="30px" valign="top">1.</td><td>Pihak Kedua mengajukan Pembiayaan untuk <b>' . $pembiayaan->data_keterangan . '</b> sebesar <b>Rp ' . number_format($pembiayaan->data_plafond) . '</b>.</td></tr>'; $html .= '<tr><td width="30px" valign="top">2.</td><td>Pihak Pertama bersedia memfasilitasi pengajuan Pihak Kedua untuk keperluan itu (butir 1) dan Pihak Pertama mewakilkan kepada Pihak Kedua untuk melakukan proses yang berkaitan dengan kepentingan sesuai butir 1 sebesar <b>Rp ' . number_format($pembiayaan->data_plafond) . '</b>.</td></tr>'; $html .= '<tr><td width="30px" valign="top">3.</td><td>Jangka waktu pembiayaan yang diberikan oleh Pihak Pertama kepada Pihak Kedua sebesar tersebut di atas telah disepakati kedua belah pihak selama 50 minggu.</td></tr>'; $html .= '<tr><td width="30px" valign="top">4.</td><td>Terhadap pembiayaan ini Pihak Kedua pada hakekatnya mengaku berhutang kepada Pihak Pertama dan semata-mata akan digunakan untuk keperluan sebagaimana yang tersebut dalam butir 1 (satu) di atas.</td></tr>'; $html .= '<tr><td width="30px" valign="top">5.</td><td>Atas pembiayaan tersebut, Pihak Kedua bersedia :</td></tr>'; $html .= '<tr><td width="30px"></td><td>'; $html .= '<table class="tbl">'; $html .= '<tr><td width="20px" valign="top">a)</td><td colspan="2">Memberikan ujrah kepada Pihak Pertama sebesar <b>Rp' . number_format($pembiayaan->data_margin) . '</b> yang akan diangsur selama 50 minggu sebesar <b>Rp' . number_format($pembiayaan->data_margin / 50) . '</b></td></tr>'; $html .= '<tr><td width="20px" valign="top">b)</td><td colspan="2">Melunasi hutang tersebut dengan cara membayar angsuran setiap minggu sebesar <b>Rp ' . number_format($pembiayaan->data_angsuranpokok + $pembiayaan->data_margin / 50 + 1000) . '</b>, dengan rincian sebagai berikut:</td></tr>'; $html .= '<tr><td width="20px"></td><td width="100px">Pokok </td><td width="">: <b>Rp ' . number_format($pembiayaan->data_angsuranpokok) . '</b></td></tr>'; $html .= '<tr><td width="20px"></td><td width="">Ujroh </td><td width="">: <b>Rp ' . number_format($pembiayaan->data_margin / 50) . '</b></td></tr>'; $html .= '<tr><td width="20px"></td><td width="">Tab Wajib </td><td width="">: <b>Rp ' . number_format(1000) . '</b></td></tr>'; $html .= '</table>'; $html .= '</td></tr>'; $html .= '<tr><td width="30px" valign="top">6.</td><td>Pihak Kedua bersedia membayar kepada Pihak Kesatu, biaya administrasi sebesar <b>Rp ' . number_format($pembiayaan->data_plafond * 1 / 100) . '</b></td></tr>'; $html .= "<tr><td width='30px' valign='top'>7.</td><td>Pihak Kedua dalam kedudukannya sebagai pengguna dana harus memenuhi syarat usaha ataupun keperluan yang dijalankan oleh Pihak Kedua hendaknya halal menurut syara' serta tidak bertentangan dengan undang-undang dan hukum yang berlaku.</td></tr>"; $html .= '<tr><td width="30px" valign="top">8.</td><td>Jika dikemudian hari ternyata terdapat kesalahan di dalam perjanjian ini dan atau terjadi perselisihan antara kedua belah pihak berkaitan dengan perjanjian ini akan di selesaikan dengan cara musyawarah mufakat yang dilandasi <i>ukhuwah islamiyyah</i>.</td></tr>'; $html .= '<tr><td width="30px"></td><td></td></tr>'; $html .= '</table>'; $html .= '<p>Demikian perjanjian ini disepakati dan ditandatangani pada hari ...................... tanggal ........................ di ........................</p>'; $html .= "<div align='center'><i>Walhamdulillaahirabbil'aalamiin</i></div>"; $html .= "</div>"; $html .= "<br/><br/>"; $html .= '<table class="tbl" width="200%">'; $html .= '<tr>'; $html .= '<td width="33%" align="center">Pihak Pertama<br/><br/><br/><br/><br/><br/>(' . $pembiayaan->officer_name . ')</td>'; $html .= '<td width="33%" align="center">Pihak Kedua<br/><br/><br/><br/><br/><br/>(' . $pembiayaan->client_fullname . ')</td>'; $html .= '<td width="33%" align="center">Ketua Majelis<br/><br/><br/><br/><br/><br/>(' . $pembiayaan->group_leader . ')</td>'; $html .= '</tr>'; $html .= '</table>'; //echo $html; $filename = "AKAD_" . $pembiayaan->client_account; $this->load->library('mpdf'); $mpdf = new mPDF('utf-8', 'A4'); $mpdf->SetFooter("Top Sheet" . '||{PAGENO}|'); $mpdf->WriteHTML($html); $pdfFilePath = FCPATH . "downloads/topsheet/{$filename}.pdf"; $pdffile = base_url() . "downloads/topsheet/{$filename}.pdf"; $mpdf->Output($pdfFilePath, 'F'); redirect($pdffile, 'refresh'); }
public function download_aruskas() { if ($this->session->userdata('logged_in')) { $timestamp = date("Ymdhis"); $tgl = date("d-M-Y"); $filename = "LAPORAN_ARUS_KAS_{$timestamp}"; $html = "<style> table tr td{ border:0;} </style>"; $html .= ''; //$html .= '<h1 align="center">Amartha Microfinance</h1>'; //$html .= '<hr/>'; $html .= '<h2 align="center">LAPORAN ARUS KAS</h2><br/>'; //Cek User Branch $user_branch = $this->session->userdata('user_branch'); function getStartAndEndDate($week, $year) { $time = strtotime("1 January {$year}", time()); $day = date('w', $time); $time += (7 * $week + 1 - $day) * 24 * 3600; $return[0] = date('Y-n-j', $time); $time += 6 * 24 * 3600; $return[1] = date('Y-n-j', $time); return $return; } $date_today = date("Y-m-d"); $date_year_today = date("Y"); $date_week_today = date("W", strtotime($date_today)) - 1; $date_week_before = $date_week_today - 1; $week_today = getStartAndEndDate($date_week_today, $date_year_today); $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); if ($date_start and $date_end and $date_start <= $date_end) { $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); } else { //$date_start =$week_today[0]; //$date_end = $week_today[1]; $date_start = $date_year_today . "-01-01"; $date_end = $date_today; } $date_end_before = strtotime($date_start); $date_end_before = strtotime("-1 day", $date_end_before); $date_end_before = date('Y-m-d', $date_end_before); $date_start_before = "2013-01-01"; $arus_kas_operasi_actual = 0; $arus_kas_operasi_before = 0; //Hitung Laba Rugi TODAY $accounting = $this->accounting_model->get_all_accounting_labarugi()->result(); foreach ($accounting as $c) { $code = $c->accounting_code; $code_level0 = substr($code, 0, 1); $code_level1 = substr($code, 0, 3); $code_level2 = substr($code, 0, 5); $haschild = $c->accounting_haschild; $parent = $c->accounting_parent; $account_debet = 0; $account_credit = 0; $account_saldo = 0; $saldo_awal = 0; if ($haschild == "1" and $parent == "0") { } elseif ($haschild == "1" and $parent != "0") { } else { //LEVEL 3 $account_debet = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $user_branch); $account_credit = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $user_branch); $account_debet_before = $this->jurnal_model->sum_account_debet_by_date($code, $date_start_before, $date_end_before, $user_branch); $account_credit_before = $this->jurnal_model->sum_account_credit_by_date($code, $date_start_before, $date_end_before, $user_branch); $account_saldo_before = $account_debet_before - $account_credit_before; $account_saldo = $account_saldo_before + $account_debet - $account_credit; //grand total dihitung dari total account level 3 $grand_total_debet += $account_debet; $grand_total_credit += $account_credit; $grand_total_before += $account_saldo_before; if ($code_level0 == "4") { $grand_total_pendapatan_debet += $account_debet; $grand_total_pendapatan_credit += $account_credit; $grand_total_pendapatan_before += $account_saldo_before; //* $grand_total_pendapatan_credit_before += $account_credit; } elseif ($code_level0 == "5") { $grand_total_beban_debet += $account_debet; $grand_total_beban_credit += $account_credit; $grand_total_beban_before += $account_saldo_before; //* $grand_total_beban_debet_before += $account_debet; } } $code_level0_old = $code_level0; } //GRAND TOTAL LABA RUGI BERJALAN $grand_total_saldo = $saldo_awal + $grand_total_debet - $grand_total_credit; $grand_total_pendapatan_saldo = $grand_total_pendapatan_before + $grand_total_pendapatan_debet - $grand_total_pendapatan_credit; $grand_total_beban_saldo = $grand_total_beban_before + $grand_total_beban_debet - $grand_total_beban_credit; $laba_rugi = $grand_total_pendapatan_credit - $grand_total_beban_debet; $laba_rugi_before = $grand_total_pendapatan_credit_before - $grand_total_beban_debet_before; //End of Hitung Laba Rugi //ARUS KAS OPERASI $arus_kas_operasi_actual += $laba_rugi; $arus_kas_operasi_before += $laba_rugi_before; $grand_total_debet = 0; $grand_total_credit = 0; $grand_total_before = 0; //Penyusutan aset tetap $get_account_saldo = $this->get_account_saldo("1060302", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $actual_1060302 = $total_saldo; $before_1060302 = $total_before; $get_account_saldo = $this->get_account_saldo("1060202", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $actual_1060202 = $total_saldo; $before_1060202 = $total_before; $penyusutan_aset_tetap_actual = $actual_1060302 + $actual_1060202; $penyusutan_aset_tetap_before = $before_1060302 + $before_1060202; $arus_kas_operasi_actual += $penyusutan_aset_tetap_actual; $arus_kas_operasi_before += $penyusutan_aset_tetap_before; //Piutang Pembiayaan $get_account_saldo = $this->get_account_saldo("1030000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $piutang_pembiayaan_actual = $total_saldo; $piutang_pembiayaan_before = $total_before; $arus_kas_operasi_actual += $piutang_pembiayaan_actual; $arus_kas_operasi_before += $piutang_pembiayaan_before; //Beban dibayar di muka $get_account_saldo = $this->get_account_saldo("1070104", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $beban_dibayar_dimuka_actual = $total_saldo; $beban_dibayar_dimuka_before = $total_before; $arus_kas_operasi_actual += $beban_dibayar_dimuka_actual; $arus_kas_operasi_before += $beban_dibayar_dimuka_before; //persediaan_barang_cetakan $get_account_saldo = $this->get_account_saldo("1070104", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $persediaan_barang_cetakan_actual = $total_saldo; $persediaan_barang_cetakan_before = $total_before; $arus_kas_operasi_actual += $persediaan_barang_cetakan_actual; $arus_kas_operasi_before += $persediaan_barang_cetakan_before; //simpanan anggota $get_account_saldo = $this->get_account_saldo("2010000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $simpanan_anggota_actual = $total_saldo; $simpanan_anggota_before = $total_before; $arus_kas_operasi_actual += $simpanan_anggota_actual; $arus_kas_operasi_before += $simpanan_anggota_before; //simpanan berjangka $get_account_saldo = $this->get_account_saldo("2020000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $simpanan_berjangka_actual = $total_saldo; $simpanan_berjangka_before = $total_before; $arus_kas_operasi_actual += $simpanan_berjangka_actual; $arus_kas_operasi_before += $simpanan_berjangka_before; //hutang pembiayaan $get_account_saldo = $this->get_account_saldo("2040000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $hutang_pembiayaan_actual = $total_saldo; $hutang_pembiayaan_before = $total_before; $arus_kas_operasi_actual += $hutang_pembiayaan_actual; $arus_kas_operasi_before += $hutang_pembiayaan_before; //hutang_lain $get_account_saldo = $this->get_account_saldo("2050000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $hutang_lain_actual = $total_saldo; $hutang_lain_before = $total_before; $arus_kas_operasi_actual += $hutang_lain_actual; $arus_kas_operasi_before += $hutang_lain_before; //ARUS KAS INVESTASI $arus_kas_investasi_actual = 0; $arus_kas_investasi_before = 0; //Penambahan aset tetap $get_account_saldo = $this->get_account_saldo("1060000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_aset_tetap_actual = $total_saldo; $penambahan_aset_tetap_before = $total_before; $arus_kas_investasi_actual += $penambahan_aset_tetap_actual; $arus_kas_investasi_before += $penambahan_aset_tetap_before; //Penambahan aset lain $get_account_saldo = $this->get_account_saldo("1070000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_aset_lain_actual = $total_saldo; $penambahan_aset_lain_before = $total_before; $arus_kas_investasi_actual += $penambahan_aset_lain_actual; $arus_kas_investasi_before += $penambahan_aset_lain_before; //ARUS KAS PENDANAAN $arus_kas_pendanaan_actual = 0; $arus_kas_pendanaan_before = 0; //Penambahan simpanan $get_account_saldo = $this->get_account_saldo("3010101", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_simpanan_3010101_actual = $total_saldo; $penambahan_simpanan_3010101_before = $total_before; $get_account_saldo = $this->get_account_saldo("3010102", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_simpanan_3010102_actual = $total_saldo; $penambahan_simpanan_3010102_before = $total_before; $penambahan_simpanan_actual = $penambahan_simpanan_3010101_actual + $penambahan_simpanan_3010102_actual; $penambahan_simpanan_before = $penambahan_simpanan_3010101_before + $penambahan_simpanan_3010102_before; $arus_kas_pendanaan_actual += $penambahan_simpanan_actual; $arus_kas_pendanaan_before += $penambahan_simpanan_before; //Penambahan hibah $get_account_saldo = $this->get_account_saldo("3010103", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_hibah_actual = $total_saldo; $penambahan_hibah_before = $total_before; $arus_kas_pendanaan_actual += $penambahan_hibah_actual; $arus_kas_pendanaan_before += $penambahan_hibah_before; //Penambahan modal $get_account_saldo = $this->get_account_saldo("3010202", 3, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $penambahan_modal_actual = $total_saldo; $penambahan_modal_before = $total_before; $arus_kas_pendanaan_actual += $penambahan_modal_actual; $arus_kas_pendanaan_before += $penambahan_modal_before; //KAS AWAL TAHUN $kas_awal_tahun_actual = $arus_kas_operasi_actual + $arus_kas_investasi_actual + $arus_kas_pendanaan_actual; $kas_awal_tahun_before = $arus_kas_operasi_before + $arus_kas_investasi_before + $arus_kas_pendanaan_before; //KAS AKHIR TAHUN $get_account_saldo = $this->get_account_saldo("1010000", 1, $date_start, $date_end, $date_start_before, $date_end_before, $user_branch); list($total_before, $total_debet, $total_credit, $total_saldo) = $get_account_saldo; $kas_akhir_tahun_actual = $total_saldo; $kas_akhir_tahun_before = $total_before; //SELISIH KAS $selisih_kas_actual = $kas_awal_tahun_actual - $kas_akhir_tahun_actual; $selisih_kas_before = $kas_awal_tahun_before - $kas_akhir_tahun_before; //LAPORAN FORMAT $laporan .= '<table cellpadding="5px" width="95%" align="center">'; $laporan .= '<tr> <td width="28%" align="left" ></td> <td width="20%" align="center" style="border-bottom: 1px solid #000;">2014</td> <td width="4%" align="left" ></td> <td width="20%" align="center" style="border-bottom: 1px solid #000;">2013</td> <td width="28%" align="right"></td> </tr>'; $laporan .= '<tr> <td align="left" ><b>Arus Kas Dari Aktivitas Operasi</b></td> <td align="right"></td> <td> </td> <td align="right"></td> <td align="right"><b><i>Cash Flow From Operating Activities</i></b></td> </tr>'; $laporan .= '<tr> <td align="left" >Laba bersih</td> <td align="right">' . ($laba_rugi < 0 ? "(" . number_format(abs($laba_rugi)) . ")" : number_format($laba_rugi)) . '</td> <td> </td> <td align="right">' . ($laba_rugi_before < 0 ? "(" . number_format(abs($laba_rugi_before)) . ")" : number_format($laba_rugi_before)) . '</td> <td align="right"><i>Net Income</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penyesuaian untuk merekonsiliasi Laba bersih menjadi arus kas bersih dari aktivitas operasi:</td> <td align="right"> </td> <td> </td> <td align="right"> </td> <td align="right"><i>Adjustment to reconcile net income to be net cash from Operationg activities:</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penyusutan aset tetap</td> <td align="right">' . ($penyusutan_aset_tetap_actual < 0 ? "(" . number_format(abs($penyusutan_aset_tetap_actual)) . ")" : number_format($penyusutan_aset_tetap_actual)) . '</td> <td> </td> <td align="right">' . ($penyusutan_aset_tetap_before < 0 ? "(" . number_format(abs($penyusutan_aset_tetap_before)) . ")" : number_format($penyusutan_aset_tetap_before)) . '</td> <td align="right"><i>Depreciation of fixed assets</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penyusutan Aset dan Liabilitas dari Operasional: </td> <td align="right"></td> <td> </td> <td align="right"></td> <td align="right"><i>Changes in operating assets and liablities</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Piutang Pembiayaan</td> <td align="right">' . ($piutang_pembiayaan_actual < 0 ? "(" . number_format(abs($piutang_pembiayaan_actual)) . ")" : number_format($piutang_pembiayaan_actual)) . '</td> <td> </td> <td align="right">' . ($piutang_pembiayaan_before < 0 ? "(" . number_format(abs($piutang_pembiayaan_before)) . ")" : number_format($piutang_pembiayaan_before)) . '</td> <td align="right"><i>Financing Receivables</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Beban dibayar dimuka</td> <td align="right">' . ($beban_dibayar_dimuka_actual < 0 ? "(" . number_format(abs($beban_dibayar_dimuka_actual)) . ")" : number_format($beban_dibayar_dimuka_actual)) . '</td> <td> </td> <td align="right">' . ($beban_dibayar_dimuka_before < 0 ? "(" . number_format(abs($beban_dibayar_dimuka_before)) . ")" : number_format($beban_dibayar_dimuka_before)) . '</td> <td align="right"><i>Prepaid Expenses</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Persediaan Barang Cetakan</td> <td align="right">' . ($persediaan_barang_cetakan_actual < 0 ? "(" . number_format(abs($persediaan_barang_cetakan_actual)) . ")" : number_format($persediaan_barang_cetakan_actual)) . '</td> <td> </td> <td align="right">' . ($persediaan_barang_cetakan_before < 0 ? "(" . number_format(abs($persediaan_barang_cetakan_before)) . ")" : number_format($persediaan_barang_cetakan_before)) . '</td> <td align="right"><i>Inventory</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Simpanan Anggota</td> <td align="right">' . ($simpanan_anggota_actual < 0 ? "(" . number_format(abs($simpanan_anggota_actual)) . ")" : number_format($simpanan_anggota_actual)) . '</td> <td> </td> <td align="right">' . ($simpanan_anggota_before < 0 ? "(" . number_format(abs($simpanan_anggota_before)) . ")" : number_format($simpanan_anggota_before)) . '</td> <td align="right"><i>Members Savings</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Simpanan Berjangka</td> <td align="right">' . ($simpanan_berjangka_actual < 0 ? "(" . number_format(abs($simpanan_berjangka_actual)) . ")" : number_format($simpanan_berjangka_actual)) . '</td> <td> </td> <td align="right">' . ($simpanan_berjangka_before < 0 ? "(" . number_format(abs($simpanan_berjangka_before)) . ")" : number_format($simpanan_berjangka_before)) . '</td> <td align="right"><i>Term Deposits</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Hutang Pembiayaan</td> <td align="right">' . ($hutang_pembiayaan_actual < 0 ? "(" . number_format(abs($hutang_pembiayaan_actual)) . ")" : number_format($hutang_pembiayaan_actual)) . '</td> <td> </td> <td align="right">' . ($hutang_pembiayaan_before < 0 ? "(" . number_format(abs($hutang_pembiayaan_before)) . ")" : number_format($hutang_pembiayaan_before)) . '</td> <td align="right"><i>Financing Payables</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Hutang Lain-lain</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($hutang_lain_actual < 0 ? "(" . number_format(abs($hutang_lain_actual)) . ")" : number_format($hutang_lain_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($hutang_lain_before < 0 ? "(" . number_format(abs($hutang_lain_before)) . ")" : number_format($hutang_lain_before)) . '</td> <td align="right"><i>Other Liabilities</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Arus kas bersih dari aktivitas operasi</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_operasi_actual < 0 ? "(" . number_format(abs($arus_kas_operasi_actual)) . ")" : number_format($arus_kas_operasi_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_operasi_before < 0 ? "(" . number_format(abs($arus_kas_operasi_before)) . ")" : number_format($arus_kas_operasi_before)) . '</td> <td align="right"><i>Net cash flow from operating activities</i></td> </tr>'; $laporan .= '<tr> <td align="left" ><br/><b>Arus Kas Dari Aktivitas Investasi</b></td> <td align="right"></td> <td> </td> <td align="right"></td> <td align="right"><br/><b><i>Cash Flow From Investment Operating</i></b></td> </tr>'; $laporan .= '<tr> <td align="left" >Penambahan Aset Tetap</td> <td align="right">' . ($penambahan_aset_tetap_actual < 0 ? "(" . number_format(abs($penambahan_aset_tetap_actual)) . ")" : number_format($penambahan_aset_tetap_actual)) . '</td> <td> </td> <td align="right">' . ($penambahan_aset_tetap_before < 0 ? "(" . number_format(abs($penambahan_aset_tetap_before)) . ")" : number_format($penambahan_aset_tetap_before)) . '</td> <td align="right"><i>Acquisition of Fixed Assets</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penambahan Aset Lain</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($penambahan_aset_lain_actual < 0 ? "(" . number_format(abs($penambahan_aset_lain_actual)) . ")" : number_format($penambahan_aset_lain_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($penambahan_aset_lain_before < 0 ? "(" . number_format(abs($penambahan_aset_lain_before)) . ")" : number_format($penambahan_aset_lain_before)) . '</td> <td align="right"><i>Acquisition of Other Assets</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Arus kas bersih dari aktivitas investasi</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_investasi_actual < 0 ? "(" . number_format(abs($arus_kas_investasi_actual)) . ")" : number_format($arus_kas_investasi_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_investasi_actual < 0 ? "(" . number_format(abs($arus_kas_investasi_actual)) . ")" : number_format($arus_kas_investasi_actual)) . '</td> <td align="right"><i>Net cash flow from investment activities</i></td> </tr>'; $laporan .= '<tr> <td align="left" ><br/><b>Arus Kas Dari Aktivitas Pendanaan</b></td> <td align="right"></td> <td> </td> <td align="right"></td> <td align="right"><br/><b><i>Cash Flow From Financing Operating</i></b></td> </tr>'; $laporan .= '<tr> <td align="left" >Penambahan (Pengurangan) Simpanan</td> <td align="right">' . ($penambahan_simpanan_actual < 0 ? "(" . number_format(abs($penambahan_simpanan_actual)) . ")" : number_format($penambahan_simpanan_actual)) . '</td> <td> </td> <td align="right">' . ($penambahan_simpanan_before < 0 ? "(" . number_format(abs($penambahan_simpanan_before)) . ")" : number_format($penambahan_simpanan_before)) . '</td> <td align="right"><i>Increase (Decrease) Savings</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penambahan (Pengurangan) Hibah</td> <td align="right">' . ($penambahan_hibah_actual < 0 ? "(" . number_format(abs($penambahan_hibah_actual)) . ")" : number_format($penambahan_hibah_actual)) . '</td> <td> </td> <td align="right">' . ($penambahan_hibah_before < 0 ? "(" . number_format(abs($penambahan_hibah_before)) . ")" : number_format($penambahan_hibah_before)) . '</td> <td align="right"><i>Increase (Decrease) Grants</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Penambahan (Pengurangan) Modal Penyertaan</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($penambahan_modal_actual < 0 ? "(" . number_format(abs($penambahan_modal_actual)) . ")" : number_format($penambahan_modal_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($penambahan_modal_before < 0 ? "(" . number_format(abs($penambahan_modal_before)) . ")" : number_format($penambahan_modal_before)) . '</td> <td align="right"><i>Increase (Decrease) Capital Participations</i></td> </tr>'; $laporan .= '<tr> <td align="left" >Arus kas bersih dari aktivitas pendanaan</td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_pendanaan_actual < 0 ? "(" . number_format(abs($arus_kas_pendanaan_actual)) . ")" : number_format($arus_kas_pendanaan_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($arus_kas_pendanaan_before < 0 ? "(" . number_format(abs($arus_kas_pendanaan_before)) . ")" : number_format($arus_kas_pendanaan_before)) . '</td> <td align="right"><i>Net cash flow from investment financing</i></td> </tr>'; $laporan .= '<tr> <td align="left" ><br/><b>Kenaikan (penurunan) bersih kas dan setara kas</b></td> <td align="right">' . ($selisih_kas_actual < 0 ? "(" . number_format(abs($selisih_kas_actual)) . ")" : number_format($selisih_kas_actual)) . '</td> <td> </td> <td align="right">' . ($selisih_kas_before < 0 ? "(" . number_format(abs($selisih_kas_before)) . ")" : number_format($selisih_kas_before)) . '</td> <td align="right"><br/><b><i>Net increase (decrease) in cash and cash equivalent</i></b></td> </tr>'; $laporan .= '<tr> <td align="left" ><br/><b>Kas dan setara kas awal tahun</b></td> <td align="right" style="border-bottom: 1px solid #000;">' . ($kas_awal_tahun_actual < 0 ? "(" . number_format(abs($kas_awal_tahun_actual)) . ")" : number_format($kas_awal_tahun_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 1px solid #000;">' . ($kas_awal_tahun_before < 0 ? "(" . number_format(abs($kas_awal_tahun_before)) . ")" : number_format($kas_awal_tahun_before)) . '</td> <td align="right"><br/><b><i>Cash and cash equivalent at beginning of year</i></b></td> </tr>'; $laporan .= '<tr> <td align="left" ><br/><b>Kas dan setara kas akhir tahun</b></td> <td align="right" style="border-bottom: 2px solid #000;">' . ($kas_akhir_tahun_actual < 0 ? "(" . number_format(abs($kas_akhir_tahun_actual)) . ")" : number_format($kas_akhir_tahun_actual)) . '</td> <td> </td> <td align="right" style="border-bottom: 2px solid #000;">' . ($kas_akhir_tahun_before < 0 ? "(" . number_format(abs($kas_akhir_tahun_before)) . ")" : number_format($kas_akhir_tahun_before)) . '</td> <td align="right"><br/><b><i>Cash and cash equivalent at end of year</i></b></td> </tr>'; $laporan .= '</table>'; $html .= $laporan; $this->load->library('mpdf'); $mpdf = new mPDF('utf-8', 'A4-L'); $mpdf->SetHeader("Amartha Microfinance" . '||' . $tgl . '|'); $mpdf->SetFooter("Laporan Arus Kas" . '||{PAGENO}|'); $mpdf->WriteHTML($html); //echo $html; //$this->mpdf->Output(); $pdfFilePath = FCPATH . "downloads/aruskas/{$filename}.pdf"; $pdffile = base_url() . "downloads/aruskas/{$filename}.pdf"; $mpdf->Output($pdfFilePath, 'F'); redirect($pdffile, 'refresh'); } else { //If no session, redirect to login page redirect('login', 'refresh'); } }
public function export($id) { if (empty($id)) { $this->load->helper('url'); redirect('/', 'refresh'); } $filename = time(); $pdfFilePath = FCPATH . "/assets/downloads/{$filename}.pdf"; if (file_exists($pdfFilePath) == FALSE) { ini_set('memory_limit', '32M'); $html = $this->view($id, true); $pdf = new mPDF(); $pdf->SetFooter($_SERVER['HTTP_HOST'] . '|{PAGENO}|' . date(DATE_RFC822)); // $pdf->WriteHTML($html); $pdf->Output($pdfFilePath, 'F'); } $this->load->helper('download'); $data = file_get_contents($pdfFilePath); $name = 'article_' . $id . '.pdf'; force_download($name, $data); }
public function actionExportPdf() { //$searchModel = new SecuritasSearch(); //$dataProvider = $searchModel->search(Yii::$app->request->queryParams); $session = Yii::$app->session; $dataProvider = $session->get('dataProvider'); $html = $this->renderPartial('_pdf', ['dataProvider' => $dataProvider]); //function mPDF($mode='',$format='A4',$default_font_size=0,$default_font='',$mgl=15,$mgr=15,$mgt=16,$mgb=16,$mgh=9,$mgf=9, $orientation='P') { $mpdf = new \mPDF('c', 'A4-L', 0, '', 15, 10, 15, 10, 10, 10); $header = ['L' => [], 'C' => [], 'R' => ['content' => 'Page {PAGENO} of {nbpg}', 'font-family' => 'sans', 'font-style' => '', 'font-size' => '9'], 'line' => 1]; $mpdf->SetFooter($header, 'O'); $mpdf->SetDisplayMode('fullpage'); $mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list $mpdf->WriteHTML($html); $mpdf->Output($this->id . '_' . date('YmdHis') . '.pdf', 'D'); exit; }
public function daily() { $user_branch = $this->session->userdata('user_branch'); $branch = $this->branch_model->get_branch($user_branch)->result(); $branch_name = $branch[0]->branch_name; //$schedule = $this->group_model->get_schedule($user_branch, "Senin"); //foreach ($schedule as $day){ $group_id = $this->uri->segment(4); //$group_id = $day->group_id; //Get group details $group = $this->group_model->get_group($group_id)->result(); $group = $group[0]; //Get total client per group $total_client = $this->clients_model->count_client_by_group($group_id); //Get client detail //$clients = $this->clients_model->get_pembiayaan_by_group($group_id); $clients_a = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'A'); $clients_b = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'B'); $clients_c = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'C'); $clients_d = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'D'); $clients_e = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'E'); $clients_f = $this->clients_model->get_pembiayaan_by_group_by_subgroup($group_id, 'F'); //Count TR per group $group_tr = $this->clients_pembiayaan_model->count_tr_by_group($group_id); $timestamp = date("Ymdhis"); $filename = "Topsheet_{$branch_name_}{$timestamp}"; $get_last_ts_entry = $this->transaction_model->get_last_tr_date_by_group($group_id)->result(); $get_last_ts_entry = $get_last_ts_entry[0]; $date_next_week = date("d / m / Y", strtotime(date("Y-m-d", strtotime($get_last_ts_entry->tr_date)) . " +1 week")); $date_next_week_2 = date("Y-m-d", strtotime(date("Y-m-d", strtotime($get_last_ts_entry->tr_date)) . " +1 week")); $html = ""; $html .= '<style> @page{ margin-top: 0.5cm; margin-bottom: 0.5cm; margin-left: 1cm; margin-right: 1cm;} body{ font-family: Helvetica, Arial;font-size: 9px;line-height: 125%;} .tbl{border-collapse: collapse;border: none;font-size: 8px;} .tbl thead{border-bottom: 1px solid #000;} .tbl td, .tbl th{padding: 1px 3px;border: 0.5px solid #666;} .clear{float: none;clear: both} #topsheet{width: 100%;float: none;clear: both;padding-bottom: 0px;} .topsheet_head2{width: 20%;float: left;font-size: 9px;} .topsheet_head3{width: 50%;float: left;font-size: 9px; text-align: center;} .topsheet_head3 h2{font-size: 12pt;} .topsheet_head{width: 25%;float: left;font-size: 9px;} .topsheet_head td,.topsheet_head2 td{ border: none;font-size: 9px;} .tbl tr td.bdr_btm, .tbl tr th.bdr_btm{ border: none; border-left: none; border-right: none;border-bottom: 0.5px solid #666;} .tbl tr td.bdr_leftbtm, .tbl tr th.bdr_leftbtm{ border: none; border-left: 0.5px solid #666; border-right: none;border-bottom: 0.5px solid #666;} .tbl tr td.bdr_btm_bold, .tbl tr th.bdr_btm_bold{ border: none; border-left: none; border-right: none;border-bottom: 1px solid #000;} .tbl tr td.bdr_leftbtm_bold, .tbl tr th.bdr_leftbtm_bold{ border: none; border-left: 0.5px solid #666;; border-right: none;border-bottom: 1px solid #000;} .tbl tr td.nobdr, .tbl tr th.nobdr{border: none;} .tbl tr td.border_bold{border: 1px solid #000;} .tbl td.padlr{ padding-left: 5px;padding-right: 7px;} </style>'; $html .= "<div style='page-break-after: alwayss;'>"; //$html .= "<div style=''><img src='http://mis.amartha.com/files/logo_amartha.png' /></div>"; //$html .= "<div style='float:right;position:absolute;right:35px;top:20px;'><small>TS ".$timestamp."</small></div>"; $html .= '<h2 align="center">TOPSHEET</h2>'; //$html .= '<div id="topsheet"><div class="topsheet_head2"><table border="0"><tr><td>Area</td><td>: Bogor Barat</td></tr><tr><td>Cabang</td><td>: 101 Ciseeng</td></tr><tr><td>Majelis</td><td>: <b>Melati</b></td></tr></table></div><div class="topsheet_head"><table border="0"><tr><td>Kampung</td><td>: Blok Sukun</td></tr><tr><td>Desa</td><td>: Cibeuntang</td></tr><tr><td>Jumlah Anggota</td><td>: 21</td></tr></table></div><div class="topsheet_head"><table border="0"><tr><td>Pertemuan Ke</td><td>: 32</td></tr><tr><td>Tanggal</td><td>: 01/10/2014</td></tr><tr><td>Ketua</td><td>: Elsah</td></tr></table></div><div class="topsheet_head"><table border="0"><tr><td>Tanggung Renteng</td><td>: Ada / Tidak</td></tr><tr><td>Akumulasi TR</td><td>: 2</td></tr><tr><td>Pendamping</td><td>: Linda</td></tr></table></div><div class="clear"></div></div><table class="tbl" width="100%" cellspacing="0"><thead><tr><th rowspan="2">No</th><th rowspan="2">Rekening</th><th rowspan="2">Nama</th><th colspan="5"><b>Kehadiran</b></th><th colspan="5"><b>Pembiayaan</b></th><th colspan="2"><b>Keterlambatan</b></th><th colspan="3"><b>Tabungan Sukarela</b></th><th colspan="5"><b>Tabungan Berjangka</b></th><th rowspan="2">Ket</th></tr><tr><td align="center">S</td><td align="center">C</td><td align="center">I</td><td align="center">A</td><td align="center">V</td><td align="center">Sisa<br/>Pokok</td><td align="center">Sisa<br/>Profit</td><td align="center">F</td><td align="center">P</td><td align="center">Total<br/>Angsur</td><td align="center">F</td><td align="center">Total<br/>Angsur</td><td align="center">Saldo</td><td align="center">Setor</td><td align="center">Tarik</td><td align="center">V</td><td align="center">P</td><td align="center">Saldo</td><td align="center">Setor</td><td align="center">Tarik</td></tr></thead>'; /* $html .= '<div id="topsheet">'; $html .= '<div class="topsheet_head2">'; $html .= '<table border="0" width="100%" class="nobdr">'; $html .= '<tr><td class="nobdr"><img src="http://mis.amartha.com/files/logo_amartha.png" /></td></tr>'; $html .= '</table>'; $html .= '</div>'; $html .= '<div class="topsheet_head3 nobdr">'; $html .= '<table border="0" width="100%" class="nobdr" >'; $html .= '<tr><td align="center" class="nobdr"><h2 align="center">TOPSHEET</h2></td></tr>'; $html .= '</table>'; $html .= '</div>'; $html .= '<div class="topsheet_head2">'; $html .= '<table border="0" width="100%">'; $html .= "<tr><td align='right'><i>* Semua angka dalam ribuan ('000)</i></td></tr>"; $html .= '</table>'; $html .= '</div>'; $html .= '</div>'; */ $html .= '<div id="topsheet">'; $html .= '<div class="topsheet_head2">'; $html .= '<table border="0" >'; $html .= '<tr><td>Area</td><td>: ' . $group->area_name . '</td></tr>'; $html .= '<tr><td>Cabang</td><td>: ' . $group->branch_name . '</td></tr>'; $html .= '<tr><td>Majelis</td><td>: <b>' . $group->group_name . '</b></td></tr>'; $html .= '</table>'; $html .= '</div>'; $html .= '<div class="topsheet_head">'; $html .= '<table border="0">'; $html .= '<tr><td>Kampung</td><td>: ' . $group->group_kampung . '</td></tr>'; $html .= '<tr><td>Desa</td><td>: ' . $group->group_desa . '</td></tr>'; $html .= '<tr><td>Jumlah Anggota</td><td>: ' . $total_client . '</td></tr>'; $html .= '</table>'; $html .= '</div>'; $html .= '<div class="topsheet_head">'; $html .= '<table border="0">'; $html .= '<tr><td>Tanggal</td><td>: ' . $date_next_week . '</td></tr>'; $html .= '<tr><td>Ketua</td><td>: ' . $group->group_leader . '</td></tr>'; $html .= '<tr><td></td></tr>'; $html .= '</table>'; $html .= '</div>'; $html .= '<div class="topsheet_head">'; $html .= '<table border="0">'; $html .= '<tr><td>Akumulasi TR</td><td>: ' . $group_tr . '</td></tr>'; $html .= '<tr><td>Field Officer</td><td>: ' . $group->officer_name . '</td></tr>'; $html .= '<tr><td></td></tr>'; $html .= '</table>'; $html .= '</div>'; //$html .= '<div class="clear"></div>'; $html .= '</div>'; $html .= '<table class="tbl" width="100%" cellspacing="0">'; //$html .= '<thead>'; $html .= '<tr>'; $html .= ' <th rowspan="2" align="left" class="bdr_btm_bold">No</th>'; $html .= ' <th rowspan="2" align="left" class="bdr_btm_bold">Rekening</th>'; $html .= ' <th rowspan="2" align="left" class="bdr_btm_bold">Nama</th>'; $html .= ' <th colspan="6" class="bdr_btm_bold"><b>Absensi</b></th>'; $html .= ' <th rowspan="2" class="nobdr" width="2px"> </th>'; $html .= ' <th colspan="9" class="bdr_btm_bold"><b>Pembiayaan</b></th>'; $html .= ' <th rowspan="2" class="nobdr" width="2px"> </th>'; $html .= ' <th class="bdr_btm_bold"><b>Keterlambatan</b></th>'; $html .= ' <th rowspan="2" class="nobdr" width="2px"> </th>'; $html .= ' <th colspan="3" class="bdr_btm_bold"><b>Tab Sukarela</b></th>'; $html .= ' <th rowspan="2" class="nobdr" width="2px"> </th>'; $html .= ' <th colspan="4" class="bdr_btm_bold"><b>Tab Berjangka</b></th>'; $html .= ' <th rowspan="2" class="nobdr" width="2px"> </th>'; $html .= ' <th rowspan="2" class="bdr_btm_bold" width="60px">Ket</th>'; $html .= '</tr>'; $html .= '<tr>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">S</td>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">C</td>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">I</td>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">A</td>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">TR</td>'; $html .= ' <td align="center" class="bdr_btm_bold" width="25px">H</td>'; $html .= ' <td align="right" class="bdr_btm_bold">Plafond</td>'; $html .= ' <td align="center" class="bdr_btm_bold">Status</td>'; $html .= ' <td align="center" class="nobdr"> </td>'; $html .= ' <td align="center" class="bdr_btm_bold padlr" width="25px">F</td>'; $html .= ' <td align="center" class="bdr_btm_bold padlr" width="25px">P</td>'; $html .= ' <td align="right" class="bdr_btm_bold padlr" width="50px">Sisa<br/>Pokok</td>'; $html .= ' <td align="right" class="bdr_btm_bold padlr" width="50px">Sisa<br/>Profit</td>'; $html .= ' <td align="right" class="bdr_btm_bold padlr" width="50px">Saldo<br/>Tab.Wajib</td>'; $html .= ' <td align="right" class="bdr_btm_bold padlr" width="50px">Total<br/>Angsur</td>'; $html .= ' <td align="center" class="bdr_btm_bold">Minggu</td>'; $html .= ' <td align="center" class="bdr_btm_bold">Saldo</td>'; $html .= ' <td align="center" class="bdr_leftbtm_bold">Setor</td>'; $html .= ' <td align="center" class="bdr_leftbtm_bold">Tarik</td>'; $html .= ' <td align="center" class="bdr_btm_bold">P</td>'; $html .= ' <td align="center" class="bdr_btm_bold">Saldo</td>'; $html .= ' <td align="center" class="bdr_leftbtm_bold">Setor</td>'; $html .= ' <td align="center" class="bdr_leftbtm_bold">Tarik</td>'; $html .= '</tr>'; //$html .= '</thead>'; $html .= '<tbody>'; $no = 1; $today = date("Y-m-d"); //print_r($clients ); foreach ($clients_a as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_a) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //SUBGROUP B foreach ($clients_b as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_b) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //SUBGROUP C foreach ($clients_c as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_c) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //SUBGROUP D foreach ($clients_d as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_d) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //SUBGROUP E foreach ($clients_e as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_e) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //SUBGROUP F foreach ($clients_f as $c) { if ($c->data_status != 4) { $margin = 0; $angsuranke = 0; $angsuranke_sekarang = 0; $angsuran_pokok = 0; $angsuran_profit = 0; $sisa_pokok = 0; $sisa_profit = 0; if ($c->data_status == 1) { $status = "A"; $id_pembiayaan = $c->data_id; $margin = $c->data_margin; $angsuranke = $c->data_angsuranke; $angsuranke_sekarang = $c->data_angsuranke; //$pertemuanke_sekarang = $c->data_pertemuanke + 1; $date_tagihan_pertama = $c->data_date_first; $diff = strtotime($today, 0) - strtotime($date_tagihan_pertama, 0); $pertemuanke_sekarang = floor($diff / 604800) + 2; $plafond = $c->data_plafond / 1000; $angsuran_pokok = $c->data_angsuranpokok; $angsuran_profit = $c->data_margin / 50; //$totalangsuran = $c->data_totalangsuran; $totalangsuran = ($c->data_plafond + $c->data_margin) / 50; $sisa_pokok = (50 - $angsuranke) * $angsuran_pokok / 1000; $sisa_profit = (50 - $angsuranke) * $angsuran_profit / 1000; $total_tabwajib += $c->data_tabunganwajib; $grand_totalangsuran += $totalangsuran + $c->data_tabunganwajib; $data_par = $c->data_par; } elseif ($c->data_status == 2 and $c->data_date_accept == "{$date_next_week_2}") { $status = "T"; } else { $status = "P"; } $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; if ($id_pembiayaan != "" or $id_pembiayaan != 0) { $absen_s = $this->clients_model->count_absen_s($id_pembiayaan); $absen_c = $this->clients_model->count_absen_c($id_pembiayaan); $absen_i = $this->clients_model->count_absen_i($id_pembiayaan); $absen_a = $this->clients_model->count_absen_a($id_pembiayaan); } else { $absen_s = 0; $absen_c = 0; $absen_i = 0; $absen_a = 0; } $data_tr = $c->data_tr; if ($data_tr == 0) { $data_tr = "-"; } $html .= '<tr>'; $html .= '<td align="center" class="bdr_btm">' . $no . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_account . '</td>'; $html .= '<td class="bdr_btm">' . $c->client_fullname . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_s . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_c . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_i . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $absen_a . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $data_tr . '</td>'; $html .= '<td class="bdr_btm"> </td>'; //hadir $html .= '<td class="nobdr" width="2px"> </td>'; //space $html .= '<td align="right" class="bdr_btm" >' . number_format($plafond, 0) . '</td>'; $html .= '<td align="center" class="bdr_btm">' . $status . '</td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '<td align="center" class="bdr_btm">' . $angsuranke_sekarang . '</td>'; if ($c->data_status == 1) { $data_sisa_pokok = number_format($sisa_pokok, 1); } else { $data_sisa_pokok = "-"; } if ($c->data_status == 1) { $data_sisa_profit = number_format($sisa_profit, 1); } else { $data_sisa_profit = "-"; } $html .= '<td align="right" class="bdr_btm">' . $data_sisa_pokok . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_sisa_profit . '</td>'; //if($c->data_status == 1 AND $data_sisa_pokok!="-"){ $data_totalangsuran=number_format((($c->data_totalangsuran + $c->data_tabunganwajib)/1000),1); }else{ $data_totalangsuran = "-";} if ($c->data_status == 1 and $data_sisa_pokok != "-") { $data_totalangsuran = number_format((($c->data_plafond + $c->data_margin) / 50 + $c->data_tabunganwajib) / 1000, 1); } else { $data_totalangsuran = "-"; } if ($c->tabwajib_saldo) { $data_tabwajib = number_format($c->tabwajib_saldo / 1000, 1); } else { $data_tabwajib = "0"; } $html .= '<td class="bdr_btm" align="right">' . $data_tabwajib . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_totalangsuran . '</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td align="center" class="bdr_btm">-</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; if ($c->tabsukarela_saldo) { $data_tabsukarela = number_format($c->tabsukarela_saldo / 1000, 1); } else { $data_tabsukarela = "0"; } $html .= '<td align="right" class="bdr_btm">' . $data_tabsukarela . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //if($c->tabberjangka_saldo!="" AND $c->tabberjangka_credit == 0){ if ($c->tabberjangka_saldo != "" and $c->tabberjangka_status == 1) { $data_tabberjangka = number_format($c->tabberjangka_saldo / 1000, 1); $data_tabberjangka_ke = $c->tabberjangka_angsuranke; $data_tabberjangka_plafond = number_format($c->tabberjangka_plafond / 1000, 1); } else { $data_tabberjangka = "-"; $data_tabberjangka_ke = "-"; $data_tabberjangka_plafond = "-"; } $html .= '<td align="center" class="bdr_btm">' . $data_tabberjangka_ke . '</td>'; $html .= '<td align="right" class="bdr_btm">' . $data_tabberjangka . '</td>'; $html .= '<td align="right" class="bdr_leftbtm">' . $data_tabberjangka_plafond . '</td>'; $html .= '<td class="bdr_leftbtm"> </td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="bdr_btm"> </td>'; $html .= '</tr>'; //PRINT SUBTOTAL $subtotal_angsuran += $data_totalangsuran; $subtotal_tabberjangka += $data_tabberjangka_plafond; $total_tabberjangka += $data_tabberjangka_plafond; $no++; } //endif } if (count($clients_f) > 0) { $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_angsuran, 1) . "</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>" . number_format($subtotal_tabberjangka, 1) . "</b></td><td colspan='3' class='nobdr'></td></tr>"; $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; } //if($total_client != 5 OR $total_client != 10 OR $total_client != 15 OR $total_client != 20 OR $total_client != 25 OR $total_client != 30){ // $html .= "<tr><td colspan='18' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>".number_format($subtotal_angsuran,1)."</b></td><td colspan='7' class='nobdr'></td><td colspan='2' class='nobdr' align='right'>Subtotal</td><td class='nobdr' align='right'><b>".number_format($subtotal_tabberjangka,1)."</b></td><td colspan='3' class='nobdr'></td></tr>"; // $html .= "<tr><td colspan='32' class='bdr_btm'></td></tr>"; $subtotal_angsuran = 0; $subtotal_tabberjangka = 0; //} $html .= '<tr>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td aligh="right" colspan="5" class="bdr_btm_bold">Total Anggota Tidak Hadir</td>'; $html .= '<td class="bdr_btm_bold"> </td>'; //kolom total hadir $html .= '<td class="nobdr" > </td>'; //space $html .= '<td class="nobdr" colspan="3"> </td>'; //space $html .= '<td align="right" colspan="5" class="bdr_btm_bold">Total</td>'; $html .= '<td align="right" class="bdr_btm_bold"><b>' . number_format($grand_totalangsuran / 1000, 1) . '</b></td>'; $html .= '<td class="nobdr"></td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td colspan="3" class="bdr_btm_bold"></td>'; $html .= '<td class="nobdr"> </td>'; $html .= '<td align="right" colspan="3" class="nobdr"></td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td class="nobdr"> </td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td colspan="12" rowspan="5" class="nobdr"><small><u>Keterangan:</u><br/>TR1: Hadir & tanggung renteng<br/>TR2: Absen tapi tanggung renteng<br/>TR3: Absen dan tidak tanggung renteng<br/><br/> <b>S</b>:Sakit; <b>C</b>:Cuti Melahirkan/Pembiayaan<br/> <b>I</b>:Izin; <b>A</b>: Alpha<br/><br/><b>A</b>:Angsuran; <b>P</b>:Pengajuan; <b>T</b>: Terima;<br/>Total Angsur=Ags.Pokok+Ags.Profit+T.Wajib</small></td>'; $html .= '<td rowspan="5" class="nobdr" > </td>'; //space $html .= '<td colspan="3" rowspan="5" class="nobdr" align="center">RF</td>'; $html .= '<td colspan="3" class="bdr_btm_bold">Setoran</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; $html .= '<td colspan="2" rowspan="5" class="nobdr" align="center">TAB</td>'; //$html .= '<td class="nobdr"></td>'; $html .= '<td colspan="3" class="bdr_btm_bold">Tab Sukarela</td>'; //eks tab wajib //$html .= '<td align="right" class="bdr_btm_bold"><b>'.number_format(($total_tabwajib/1000),1).'</b></td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td colspan="3" class="bdr_btm_bold">Adm</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //$html .= '<td class="nobdr"></td>'; $html .= '<td colspan="3" class="bdr_btm_bold">UMB Tab Sukarela</td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td colspan="3" class="bdr_btm_bold">LWK</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //$html .= '<td class="nobdr"></td>'; $html .= '<td colspan="2" class="bdr_btm_bold">Tab Berjangka</td>'; $html .= '<td align="right" class="bdr_btm_bold"><b>' . number_format($total_tabberjangka, 1) . '</b></td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td colspan="3" class="bdr_btm_bold">Gagal Dropping</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //$html .= '<td class="nobdr"></td>'; $html .= '<td colspan="3" class="bdr_btm_bold" ></td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td colspan="3" class="bdr_btm_bold">Total</td>'; $html .= '<td class="nobdr" width="2px"> </td>'; //$html .= '<td class="nobdr"></td>'; $html .= '<td colspan="3" class="bdr_btm_bold">Total</td>'; $html .= '</tr>'; $html .= '<tr>'; $html .= '<td class="nobdr" width="2px" colspan="3"> </td>'; $html .= '<td class="nobdr" colspan="5" align="center">Ketua Majelis</td>'; $html .= '<td class="nobdr" align="center" colspan="5">Field Officer</td>'; $html .= '<td colspan="12" class="border_bold"><b>TOTAL</b></td>'; $html .= '<td colspan="4" class="nobdr" align="center">Teller</td>'; $html .= '<td colspan="4" class="nobdr" align="center">Manager</td>'; $html .= '</tr>'; $html .= '</tbody></table>'; $html .= "</div>"; $html .= "<br/><br/><br/>"; //$html; $this->load->library('mpdf'); $mpdf = new mPDF('utf-8', 'A4-L'); $mpdf->SetFooter("Top Sheet" . '||{PAGENO}|'); //$mpdf->AddPage(); $mpdf->WriteHTML($html); //$this->mpdf->Output(); //} $pdfFilePath = FCPATH . "downloads/topsheet/{$filename}.pdf"; $pdffile = base_url() . "downloads/topsheet/{$filename}.pdf"; $mpdf->Output($pdfFilePath, 'F'); redirect($pdffile, 'refresh'); //echo $html; //echo $this->benchmark->elapsed_time(); }
function export_to_pdf($qry, $filename, $paper_size = 'A4', $is_portrait = TRUE) { $ci = get_instance(); $company = $ci->systems_model->getCompany_ById(sesCompany()->id); $ci->load->library('mpdf'); //=====================================================================================================\\ if ($paper_size == 'F4') { if ($is_portrait) { $paper_setup = array(215.9, 330.2); } else { $paper_setup = array(330.2, 215.9); } } if ($paper_size == 'A3') { if ($is_portrait) { $paper_setup = array(297, 420); } else { $paper_setup = array(420, 297); } } $mpdf = new mPDF('utf-8', $paper_setup, '', '', 15, 15, 35, 16, 10, 10); $mpdf->SetTitle("Example"); $mpdf->SetAuthor("Example"); $logo_path = base_url() . "assets/images/logo-{$company->code}.png"; $title = join(" ", explode("_", strtoupper($filename))); $html_head = "<html><head>\n\t\t<style>\n\t\t.logo \t{ float: left; margin-top: -80px; width: 100px; height: 100px; }\n\t\tbody \t{ font-family: Courier; font-size: 10pt; }\n\t\ttd \t\t{ vertical-align: top; }\n\t\t.top-border \t{ border-top: 0.1mm solid #000000; }\n\t\t.bottom-border \t{ border-bottom: 0.1mm solid #000000; }\n\t\t.left-border \t{ border-left: 0.1mm solid #000000; }\n\t\t.right-border \t{ border-right: 0.1mm solid #000000; }\n\t\ttable thead td { \n\t\t\ttext-align: center;\n\t\t\tborder: 0.1mm solid #000000;\n\t\t\tborder-collapse: collapse;\n\t\t}\n\t\t.items td {\n\t\t\tborder-left: 0.1mm solid #000000;\n\t\t\tborder-right: 0.1mm solid #000000;\n\t\t}\n\t\t.items td.blanktotal {\n\t\t\tbackground-color: #FFFFFF;\n\t\t\tborder: 0mm none #000000;\n\t\t\tborder-top: 0.1mm solid #000000;\n\t\t\t/* border-right: 0.1mm solid #000000; */\n\t\t}\t\t\n\t\t.items td.totals {\n\t\t\ttext-align: right;\n\t\t\tborder: 0.1mm solid #000000;\n\t\t}\n\t\t</style>\n\t\t</head>\n\t\t<body>\n\t\t\n\t\t<!--mpdf\n\t\t<htmlpageheader name='myheader'>\n\t\t\t<div class='logo'><img src='{$logo_path}' width='100' /></div>\n\t\t\t<table width='100%'>\n\t\t\t\t<tr><td><center><h1>{$company->name}</h1></center></td></tr>\n\t\t\t\t<tr><td><center>|||</center></td></tr>\n\t\t\t\t<tr><td><center><h3>{$title}</h3></center></td></tr>\n\t\t\t</table>\n\t\t</htmlpageheader>\n\n\t\t<sethtmlpageheader name='myheader' value='on' show-this-page='1' />\n\t\tmpdf-->"; $mpdf->WriteHTML($html_head); $mpdf->SetFooter("|Page {PAGENO} of {nb}|Printed @ " . date('d M Y H:i')); $header = "\n\t\t<table class='items' width='100%' style='margin-top: 1.25em; border-collapse: collapse;' cellpadding='8'>\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<td><strong>NO.</strong></td>"; $fields = $qry->list_fields(); $fields_count = count($fields); foreach ($fields as $field) { $header .= "<td><strong>{$field}</strong></td>"; } $header .= "</tr>\n\t\t</thead>\n\t\t<tbody>"; $mpdf->WriteHTML($header); if ($qry->num_rows() < 1) { crud_error(l('report_no_data')); } $num = 1; foreach ($qry->result() as $row) { $detail .= "\n\t\t\t\t<tr>\n\t\t\t\t\t<td align='right'>{$num}</td>\n\t\t\t\t\t"; foreach ($fields as $field) { $detail .= "<td>" . $row->{$field} . "</td>"; } /* foreach ($fields as $field) { $detail .= "<td style='white-space: nowrap;>".$row->$field."</td>"; } */ $detail .= "\n\t\t\t\t</tr>\n\t\t\t"; $num++; } $mpdf->WriteHTML($detail); $fields_count = $fields_count + 1; $footer = "\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan=" . $fields_count . " class='blanktotal'> </td>\n\t\t\t\t</tr>\n\t\t\t\t</tbody>\n\t\t\t</table>"; $mpdf->WriteHTML($footer); $mpdf->WriteHTML("</body></html>"); // Sending headers to force the user to download the file header('Set-Cookie: fileDownload=true; path=/'); // setcookie("fileDownload", "true", time() - 3600, "/"); // setcookie("fileDownload", "true", time() - 3600); // $mpdf->Output(); $mpdf->Output($filename . '.pdf', 'D'); }
<?php // Include mpdf library include("mpdf60/mpdf.php"); $mpdf = new mPDF(); $mpdf->SetDisplayMode('fullpage'); $mpdf->defaultfooterfontsize = 10; // in pts $mpdf->defaultfooterfontstyle = B; // blank, B, I, or BI $mpdf->defaultfooterline = 1; $mpdf->defaultfootercolor = '#ff9918'; // footer text $mpdf->SetFooter('Mohd Gausul Abdeen'.'| Page {PAGENO} of 7 | '.'Powered by test'); //test1.php html code file $html = file_get_contents('test1.php'); $mpdf->WriteHTML($html); $content = $mpdf->Output('', 'S'); $file_name="report.pdf"; $content =$mpdf->Output($file_name,'F'); print_r($file_name); ?>
$runTxa = explode(",", $d["taxs"]); $Tax = 0; foreach ($runTxa as $idat) { //echo $idat.'<br>'; $ops = mysql_fetch_array(mysql_query("SELECT * FROM tax_table WHERE tax_id = '{$idat}' AND saasid = '" . $_SESSION['saasid'] . "' AND active = 'true'")); //echo $ops['percent'].'<br>'.$subTottax; $Tax = round($subTottax * $ops['percent'] / 100, 2); $runTax .= '<div style="width:360px; height:31px; float:right; clear:both; border-bottom:solid thin #CCC;"><div style="width:210px; float:left">' . $ops['tax_name'] . ':</div> <div style="width:130px; float:left; text-align:right">$' . $Tax . '</div></div>'; $taxcom += $Tax; } $afterMath = number_format($cleanSub + $taxcom, 2); $html .= '<div style="width:360px; height:31px; float:right;"><div style="width:210px; float:left">Subtotal:</div> <div style="width:130px; float:left; text-align:right">$' . $cleanSubtru . '</div></div> ' . $runTax . ' <div style="width:360px; height:31px; float:right; clear:both"><div style="width:210px; float:left; font-weight:bold">Total:</div> <div style="width:130px; float:left; text-align:right">$' . $afterMath . '</div></div><input name="estiamount" id="estiamount" type="hidden" value="' . $afterMath . '" />'; $html .= '</div> '; $rt = mysql_fetch_array(mysql_query("SELECT * FROM core_users WHERE usr_id = '" . $b["salesman"] . "' AND saasid = '" . $_SESSION['saasid'] . "'")); $mpdf = new mPDF(); $mpdf->SetHTMLHeader('<div style="width:161px; height:64px; float:left; background-image:url(images/main_logo.gif)"></div><div style="float:left; text-align:right; font-size:11px">Estimate for: ' . $dd["companyname"] . '<br>Date Created: ' . $b["issue_date"] . '<br>Created By: ' . $rt["fname"] . ' ' . $rt["lname"] . '</div>'); $mpdf->SetFooter('ACS Estimate | {PAGENO}'); $mpdf->WriteHTML($html); $mpdf->Output(); //$mpdf->Output('filename.pdf','F'); exit; //============================================================== //============================================================== //==============================================================
public function tabwajib_download() { $client_account = $this->uri->segment(3); $data = $this->tabwajib_model->get_transaction($client_account); $client = $this->tabwajib_model->get_account($client_account); $client = $client[0]; $timestamp = date("Ymdhis"); $tgl = date("d-M-Y"); $filename = "MUTASI_TAB_WAJIB_" . $client->client_account . "_{$timestamp}"; $html = "<style> table tr td,table thead tr td, table tr th{ border-left:0; border-right:0;} table thead tr td,table thead tr th,table tr th{ border-bottom: 2px solid #000; }</style>"; $html .= ''; $no = 1; $html .= '<h2 align="center">MUTASI TABUNGAN WAJIB</h2>'; $html .= "<p align='center'>" . $client->client_fullname . " - " . $client->client_account . "</p><br/>"; $html .= '<table border="1" width="100%">'; ////$html .= '<thead>'; $html .= '<tr>'; $html .= '<th>NO</th>'; $html .= '<th align="left" class="text-left">KODE TRANSAKSI</th>'; $html .= '<th align="left" class="text-left">TANGGAL</th>'; $html .= '<th align="right" class="text-right">DEBET</th>'; $html .= '<th align="right" class="text-right">KREDIT</th>'; $html .= '<th align="right" class="text-right">SALDO</th>'; $html .= '<th align="left" class="text-left">KETERANGAN</th>'; $html .= '</tr> '; foreach ($data as $c) { $html .= '<tr> '; $html .= '<td align="center">' . $no . '</td>'; $html .= '<td>' . $c->tr_topsheet_code . '</td> '; $html .= '<td>' . date("Y-m-d", strtotime($c->tr_date)) . '</td>'; $html .= '<td align="right" class="text-right">' . number_format($c->tr_debet) . '</td>'; $html .= '<td align="right" class="text-right">' . number_format($c->tr_credit) . '</td>'; $html .= '<td align="right" class="text-right">' . number_format($c->tr_saldo) . '</td>'; $html .= '<td>' . $c->tr_remark . '</td>'; $html .= '</tr>'; $no++; } $html .= '</table>'; $this->load->library('mpdf'); $mpdf = new mPDF('utf-8', 'A4-L'); $mpdf->SetHeader("Amartha Microfinance" . '||' . $tgl . '|'); $mpdf->SetFooter("Mutasi Tabungan Wajib" . '||{PAGENO}|'); $mpdf->WriteHTML($html); //echo $html; //$this->mpdf->Output(); $pdfFilePath = FCPATH . "downloads/mutasi/{$filename}.pdf"; $pdffile = base_url() . "downloads/mutasi/{$filename}.pdf"; $mpdf->Output($pdfFilePath, 'F'); redirect($pdffile, 'refresh'); }
* it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. * * Primary Author Contact: Jacob Bates <*****@*****.**> */ require '../vendor/autoload.php'; use zz\Html\HTMLMinify; ini_set('max_execution_time', 300); $pdf = new mPDF(); $stylesheet = <<<EOD <link rel="stylesheet" href="../assets/css/pdf.css" type="text/css"> EOD; session_start(); $title = $_POST['context_title']; session_write_close(); $html = HTMLMinify::minify($_POST['result_html']); $pdf->SetHeader("Scanned on " . date("m/d/Y") . " at " . date("g:i a")); $pdf->SetFooter("Page {PAGENO} / {nb}"); $pdf->WriteHTML($stylesheet, 1); $pdf->WriteHTML($html, 2); $pdf->Output($title . '_' . date("Y-m-d_g:i-a") . '.pdf', 'D'); exit;
public function laba_rugi_download() { if ($this->session->userdata('logged_in')) { $total_branch = $this->branch_model->count_branch(); $timestamp = date("Ymdhis"); $tgl = date("d-M-Y"); $filename = "LAPORAN_LABA_RUGI_{$timestamp}"; $print = "<style> table tr td,table thead tr td, table tr th{ border-left:0; border-right:0; font-size:10px;} table thead tr td,table thead tr th,table tr th{ border-bottom: 0.5px solid #666; }</style>"; $print .= ''; //$print .= '<h1 align="center">Amartha Microfinance</h1>'; //$print .= '<hr/>'; $print .= '<h2 align="center">LAPORAN LABA RUGI</h2><br/>'; $print .= '<table border="1" width="100%">'; $print .= '<tr> <th width="350px"></th> <th class="text-center">Konsolidasi</th> <th class="text-center">Pusat</th> <th class="text-center">Ciseeng</th> <th class="text-center">Jasinga</th> <th class="text-center">Bojong Gede</th> <th class="text-center">Kemang</th> <th class="text-center">Tenjo</th> <th class="text-center">Cangkuang</th> <th class="text-center">Pangalengan</th> </tr>'; $colspan = $total_branch + 2; $colspan2 = $total_branch + 3; //Cek User Branch $user_branch = $this->session->userdata('user_branch'); if ($user_branch == "0") { $user_branch = NULL; } function getStartAndEndDate($week, $year) { $time = strtotime("1 January {$year}", time()); $day = date('w', $time); $time += (7 * $week + 1 - $day) * 24 * 3600; $return[0] = date('Y-n-j', $time); $time += 6 * 24 * 3600; $return[1] = date('Y-n-j', $time); return $return; } $date_today = date("Y-m-d"); $date_year_today = date("Y"); $date_week_today = date("W", strtotime($date_today)) - 1; $date_week_before = $date_week_today - 1; $week_today = getStartAndEndDate($date_week_today, $date_year_today); $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); if ($date_start and $date_end and $date_start <= $date_end) { $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); } else { //$date_start =$week_today[0]; $date_start = "2015-01-01"; $date_end = date("Y-m-d"); } $date_end_before = strtotime($date_start); //$date_end_before = $date_start; $date_end_before = strtotime("-1 day", $date_end_before); $date_end_before = date('Y-m-d', $date_end_before); $date_start_before = "2014-01-01"; //echo $date_start_before." ----- ".$date_end_before; $account_debet = 0; $account_credit = 0; $account_saldo = 0; $saldo_awal = 0; //PENDAPATAN $print .= ' <tr><td align="left" ><b>Pendapatan</b></td> <td colspan="' . $colspan . '" ></td></tr>'; //4010000 Pendapatan Pembiayaan $code = "4010000"; $code_level1 = substr($code, 0, 3); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4010000_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_4010000_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_4010000[$branch] = $account_4010000_credit[$branch] - $account_4010000_debet[$branch]; $account_4010000_total += $account_4010000[$branch]; $account_pendapatan_total[$branch] += $account_4010000[$branch]; } $print .= ' <tr><td align="left" > Pendapatan Pembiayaan</td>'; $print .= ' <td align="right" class="">' . ($account_4010000_total < 0 ? "(" . number_format(abs($account_4010000_total)) . ")" : number_format($account_4010000_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_4010000[$branch] < 0 ? "(" . number_format(abs($account_4010000[$branch])) . ")" : number_format($account_4010000[$branch])) . '</td>'; } $print .= '</tr>'; //4020000 Pendapatan Jasa Administrasi $code = "4020000"; $code_level1 = substr($code, 0, 3); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4020000_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_4020000_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_4020000[$branch] = $account_4020000_credit[$branch] - $account_4020000_debet[$branch]; $account_4020000_total += $account_4020000[$branch]; $account_pendapatan_total[$branch] += $account_4020000[$branch]; } $print .= ' <tr><td align="left" > Pendapatan Administrasi</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_4020000_total < 0 ? "(" . number_format(abs($account_4020000_total)) . ")" : number_format($account_4020000_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_4020000[$branch] < 0 ? "(" . number_format(abs($account_4020000[$branch])) . ")" : number_format($account_4020000[$branch])) . '</td>'; } $print .= '</tr>'; //Jumlah Pendapatan $account_pendapatan_konsolidasi = $account_4010000_total + $account_4020000_total; $print .= ' <tr><td align="left" >Total Pendapatan</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_konsolidasi < 0 ? "(" . number_format(abs($account_pendapatan_konsolidasi)) . ")" : number_format($account_pendapatan_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_total[$branch] < 0 ? "(" . number_format(abs($account_pendapatan_total[$branch])) . ")" : number_format($account_pendapatan_total[$branch])) . '</td>'; } $print .= ' </tr>'; //--------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------- $print .= ' <tr><td align="left" colspan="' . $colspan2 . '"> </td></tr>'; $print .= ' <tr><td align="left" ><b>Biaya Langsung</b></td> <td colspan="' . $colspan . '" ></td></tr>'; //Beban Dana Pinjaman Bank $code = "5010200"; $code_level1 = substr($code, 0, 5); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5010200_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_5010200_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_5010200[$branch] = $account_5010200_debet[$branch] - $account_5010200_credit[$branch]; $account_5010200_total += $account_5010200[$branch]; $account_biaya_langsung_total[$branch] += $account_5010200[$branch]; } $print .= ' <tr><td align="left" > Beban Dana Pinjaman Bank</td>'; $print .= ' <td align="right" class="">' . ($account_5010200_total < 0 ? "(" . number_format(abs($account_5010200_total)) . ")" : number_format($account_5010200_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5010200[$branch] < 0 ? "(" . number_format(abs($account_5010200[$branch])) . ")" : number_format($account_5010200[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Dana Simpanan Berjangka $code = "5010100"; $code_level1 = substr($code, 0, 5); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5010100_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_5010100_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_5010100[$branch] = $account_5010100_debet[$branch] - $account_5010100_credit[$branch]; $account_5010100_total += $account_5010100[$branch]; $account_biaya_langsung_total[$branch] += $account_5010100[$branch]; } $print .= ' <tr><td align="left" > Beban Dana Simpanan Berjangka</td>'; $print .= ' <td align="right" class="">' . ($account_5010100_total < 0 ? "(" . number_format(abs($account_5010100_total)) . ")" : number_format($account_5010100_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5010100[$branch] < 0 ? "(" . number_format(abs($account_5010100[$branch])) . ")" : number_format($account_5010100[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Bonus $code = "5020000"; $code_level1 = substr($code, 0, 3); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5020000_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_5020000_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_5020000[$branch] = $account_5020000_debet[$branch] - $account_5020000_credit[$branch]; $account_5020000_total += $account_5020000[$branch]; $account_biaya_langsung_total[$branch] += $account_5020000[$branch]; } $print .= ' <tr><td align="left" > Beban Bonus</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_5020000_total < 0 ? "(" . number_format(abs($account_5020000_total)) . ")" : number_format($account_5020000_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_5020000[$branch] < 0 ? "(" . number_format(abs($account_5020000[$branch])) . ")" : number_format($account_5020000[$branch])) . '</td>'; } $print .= '</tr>'; //Total Biaya_langsung $account_biaya_langsung_konsolidasi = $account_5010100_total + $account_5010200_total + $account_5020000_total; $print .= ' <tr><td align="left" >Total Biaya Langsung</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_biaya_langsung_konsolidasi < 0 ? "(" . number_format(abs($account_biaya_langsung_konsolidasi)) . ")" : number_format($account_biaya_langsung_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_biaya_langsung_total[$branch] < 0 ? "(" . number_format(abs($account_biaya_langsung_total[$branch])) . ")" : number_format($account_biaya_langsung_total[$branch])) . '</td>'; } $print .= ' </tr>'; $print .= ' <tr><td></td><td align="left" class="border_btm" colspan="' . $colspan . '"> </td></tr>'; //Laba Rugi Kotor $account_labarugi_kotor_konsolidasi = $account_pendapatan_konsolidasi - $account_biaya_langsung_konsolidasi; $print .= ' <tr><td align="left" ><b>Laba (Rugi) Kotor</b></td>'; $print .= ' <td align="right" class="border_btm"><b>' . ($account_labarugi_kotor_konsolidasi < 0 ? "(" . number_format(abs($account_labarugi_kotor_konsolidasi)) . ")" : number_format($account_labarugi_kotor_konsolidasi)) . '</b></td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_labarugi_kotor_total[$branch] = $account_pendapatan_total[$branch] - $account_biaya_langsung_total[$branch]; $print .= ' <td align="right" class="border_btm"><b>' . ($account_labarugi_kotor_total[$branch] < 0 ? "(" . number_format(abs($account_labarugi_kotor_total[$branch])) . ")" : number_format($account_labarugi_kotor_total[$branch])) . '</b></td>'; } $print .= ' </tr>'; //--------------------------------------------------------------------------------------------- //BEBAN OPERASI //--------------------------------------------------------------------------------------------- $print .= ' <tr><td align="left" colspan="' . $colspan2 . '"> </td></tr>'; $print .= ' <tr><td align="left" ><b>Biaya Operasi</b></td> <td colspan="' . $colspan . '" ></td></tr>'; //Beban Lainnya: 5030101, 5030102, 5030103, 5030104, 5030105, 5030106, 5030108, 5030109, 5030110, 5030111, 5030112, 5030113, 5030114 $code = "5030101"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030101_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030101_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030101[$branch] = $account_5030101_debet[$branch] - $account_5030101_credit[$branch]; $account_5030101_total += $account_5030101[$branch]; $account_beban_gaji_total[$branch] += $account_5030101[$branch]; $account_beban_operasi_total[$branch] += $account_5030101[$branch]; } $code = "5030102"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030102_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030102_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030102[$branch] = $account_5030102_debet[$branch] - $account_5030102_credit[$branch]; $account_5030102_total += $account_5030102[$branch]; $account_beban_gaji_total[$branch] += $account_5030102[$branch]; $account_beban_operasi_total[$branch] += $account_5030102[$branch]; } $code = "5030103"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030103_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030103_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030103[$branch] = $account_5030103_debet[$branch] - $account_5030103_credit[$branch]; $account_5030103_total += $account_5030103[$branch]; $account_beban_gaji_total[$branch] += $account_5030103[$branch]; $account_beban_operasi_total[$branch] += $account_5030103[$branch]; } $code = "5030104"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030104_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030104_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030104[$branch] = $account_5030104_debet[$branch] - $account_5030104_credit[$branch]; $account_5030104_total += $account_5030104[$branch]; $account_beban_gaji_total[$branch] += $account_5030104[$branch]; $account_beban_operasi_total[$branch] += $account_5030104[$branch]; } $code = "5030105"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030105_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030105_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030105[$branch] = $account_5030105_debet[$branch] - $account_5030105_credit[$branch]; $account_5030105_total += $account_5030105[$branch]; $account_beban_gaji_total[$branch] += $account_5030105[$branch]; $account_beban_operasi_total[$branch] += $account_5030105[$branch]; } $code = "5030106"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030106_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030106_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030106[$branch] = $account_5030106_debet[$branch] - $account_5030106_credit[$branch]; $account_5030106_total += $account_5030106[$branch]; $account_beban_gaji_total[$branch] += $account_5030106[$branch]; $account_beban_operasi_total[$branch] += $account_5030106[$branch]; } $code = "5030108"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030108_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030108_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030108[$branch] = $account_5030108_debet[$branch] - $account_5030108_credit[$branch]; $account_5030108_total += $account_5030108[$branch]; $account_beban_gaji_total[$branch] += $account_5030108[$branch]; $account_beban_operasi_total[$branch] += $account_5030108[$branch]; } $code = "5030109"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030109_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030109_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030109[$branch] = $account_5030109_debet[$branch] - $account_5030109_credit[$branch]; $account_5030109_total += $account_5030109[$branch]; $account_beban_gaji_total[$branch] += $account_5030109[$branch]; $account_beban_operasi_total[$branch] += $account_5030109[$branch]; } $code = "5030110"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030110_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030110_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030110[$branch] = $account_5030110_debet[$branch] - $account_5030110_credit[$branch]; $account_5030110_total += $account_5030110[$branch]; $account_beban_gaji_total[$branch] += $account_5030110[$branch]; $account_beban_operasi_total[$branch] += $account_5030110[$branch]; } $code = "5030111"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030111_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030111_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030111[$branch] = $account_5030111_debet[$branch] - $account_5030111_credit[$branch]; $account_5030111_total += $account_5030111[$branch]; $account_beban_gaji_total[$branch] += $account_5030111[$branch]; $account_beban_operasi_total[$branch] += $account_5030111[$branch]; } $code = "5030112"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030112_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030112_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030112[$branch] = $account_5030112_debet[$branch] - $account_5030112_credit[$branch]; $account_5030112_total += $account_5030112[$branch]; $account_beban_gaji_total[$branch] += $account_5030112[$branch]; $account_beban_operasi_total[$branch] += $account_5030112[$branch]; } $code = "5030113"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030113_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030113_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030113[$branch] = $account_5030113_debet[$branch] - $account_5030113_credit[$branch]; $account_5030113_total += $account_5030113[$branch]; $account_beban_gaji_total[$branch] += $account_5030113[$branch]; $account_beban_operasi_total[$branch] += $account_5030113[$branch]; } $code = "5030114"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030114_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030114_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030114[$branch] = $account_5030114_debet[$branch] - $account_5030114_credit[$branch]; $account_5030114_total += $account_5030114[$branch]; $account_beban_gaji_total[$branch] += $account_5030114[$branch]; $account_beban_operasi_total[$branch] += $account_5030114[$branch]; } $account_beban_gaji_konsolidasi = $account_5030101_total + $account_5030102_total + $account_5030103_total + $account_5030104_total + $account_5030105_total + $account_5030106_total + $account_5030108_total + $account_5030109_total + $account_5030110_total + $account_5030111_total + $account_5030112_total + $account_5030113_total + $account_5030114_total; $print .= ' <tr><td align="left" > Beban Gaji & Honor</td>'; $print .= ' <td align="right" class="">' . ($account_beban_gaji_konsolidasi < 0 ? "(" . number_format(abs($account_beban_gaji_konsolidasi)) . ")" : number_format($account_beban_gaji_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_gaji_total[$branch] < 0 ? "(" . number_format(abs($account_beban_gaji_total[$branch])) . ")" : number_format($account_beban_gaji_total[$branch])) . '</td>'; } $print .= '</tr>'; //5080404 Beban Asuransi Jiwa $code = "5080404"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080404_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080404_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080404[$branch] = $account_5080404_debet[$branch] - $account_5080404_credit[$branch]; $account_5080404_total += $account_5080404[$branch]; $account_beban_operasi_total[$branch] += $account_5080404[$branch]; } $print .= ' <tr><td align="left" > Beban Asuransi Jiwa</td>'; $print .= ' <td align="right" class="">' . ($account_5080404_total < 0 ? "(" . number_format(abs($account_5080404_total)) . ")" : number_format($account_5080404_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5080404[$branch] < 0 ? "(" . number_format(abs($account_5080404[$branch])) . ")" : number_format($account_5080404[$branch])) . '</td>'; } $print .= '</tr>'; //5040003 Beban Rekrutmen $code = "5040003"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5040003_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5040003_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5040003[$branch] = $account_5040003_debet[$branch] - $account_5040003_credit[$branch]; $account_5040003_total += $account_5040003[$branch]; $account_beban_operasi_total[$branch] += $account_5040003[$branch]; } $print .= ' <tr><td align="left" > Beban Rekrutmen</td>'; $print .= ' <td align="right" class="">' . ($account_5040003_total < 0 ? "(" . number_format(abs($account_5040003_total)) . ")" : number_format($account_5040003_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5040003[$branch] < 0 ? "(" . number_format(abs($account_5040003[$branch])) . ")" : number_format($account_5040003[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Training $print .= ' <tr><td align="left" > Beban Training</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //5030107 Insentif Operations $code = "5030107"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5030107_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5030107_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5030107[$branch] = $account_5030107_debet[$branch] - $account_5030107_credit[$branch]; $account_5030107_total += $account_5030107[$branch]; $account_beban_operasi_total[$branch] += $account_5030107[$branch]; } $print .= ' <tr><td align="left" > Insentif Operations</td>'; $print .= ' <td align="right" class="">' . ($account_5030107_total < 0 ? "(" . number_format(abs($account_5030107_total)) . ")" : number_format($account_5030107_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5030107[$branch] < 0 ? "(" . number_format(abs($account_5030107[$branch])) . ")" : number_format($account_5030107[$branch])) . '</td>'; } $print .= '</tr>'; //5080501 Beban Rumah Tangga Pusat $code = "5080501"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080501_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080501_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080501[$branch] = $account_5080501_debet[$branch] - $account_5080501_credit[$branch]; $account_5080501_total += $account_5080501[$branch]; $account_beban_RT_pusat_total[$branch] += $account_5080501[$branch]; $account_beban_operasi_total[$branch] += $account_5080501[$branch]; } $code = "5080301"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080301_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080301_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080301[$branch] = $account_5080301_debet[$branch] - $account_5080301_credit[$branch]; $account_5080301_total += $account_5080301[$branch]; $account_beban_RT_pusat_total[$branch] += $account_5080301[$branch]; $account_beban_operasi_total[$branch] += $account_5080301[$branch]; } $account_beban_RT_pusat_konsolidasi = $account_5080501_total + $account_5080301_total; $account_beban_RT_cabang_konsolidasi = $account_beban_RT_pusat_konsolidasi - $account_beban_RT_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Rumah Tangga Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_beban_RT_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_RT_pusat_total[0])) . ")" : number_format($account_beban_RT_pusat_total[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_beban_RT_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_RT_pusat_total[0])) . ")" : number_format($account_beban_RT_pusat_total[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban ATK Pusat : 5080201, 5080202, 5080203, 5080401 $code = "5080201"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080201_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080201_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080201[$branch] = $account_5080201_debet[$branch] - $account_5080201_credit[$branch]; $account_5080201_total += $account_5080201[$branch]; $account_beban_ATK_pusat_total[$branch] += $account_5080201[$branch]; $account_beban_operasi_total[$branch] += $account_5080201[$branch]; } $code = "5080202"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080202_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080202_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080202[$branch] = $account_5080202_debet[$branch] - $account_5080202_credit[$branch]; $account_5080202_total += $account_5080202[$branch]; $account_beban_ATK_pusat_total[$branch] += $account_5080202[$branch]; $account_beban_operasi_total[$branch] += $account_5080202[$branch]; } $code = "5080203"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080203_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080203_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080203[$branch] = $account_5080203_debet[$branch] - $account_5080203_credit[$branch]; $account_5080203_total += $account_5080203[$branch]; $account_beban_ATK_pusat_total[$branch] += $account_5080203[$branch]; $account_beban_operasi_total[$branch] += $account_5080203[$branch]; } $code = "5080401"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080401_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080401_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080401[$branch] = $account_5080401_debet[$branch] - $account_5080401_credit[$branch]; $account_5080401_total += $account_5080401[$branch]; $account_beban_ATK_pusat_total[$branch] += $account_5080401[$branch]; $account_beban_operasi_total[$branch] += $account_5080401[$branch]; } $account_beban_ATK_pusat_konsolidasi = $account_5080201_total + $account_5080202_total + $account_5080203_total + $account_5080401_total; $account_beban_ATK_cabang_konsolidasi = $account_beban_ATK_pusat_konsolidasi - $account_beban_ATK_pusat_total[0]; $print .= ' <tr><td align="left" > Beban ATK Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_beban_ATK_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_ATK_pusat_total[0])) . ")" : number_format($account_beban_ATK_pusat_total[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_beban_ATK_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_ATK_pusat_total[0])) . ")" : number_format($account_beban_ATK_pusat_total[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban Transportasi Pusat : 5080302, 5080303, 5080304 $code = "5080302"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080302_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080302_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080302[$branch] = $account_5080302_debet[$branch] - $account_5080302_credit[$branch]; $account_5080302_total += $account_5080302[$branch]; $account_beban_transportasi_pusat_total[$branch] += $account_5080302[$branch]; $account_beban_operasi_total[$branch] += $account_5080302[$branch]; } $code = "5080303"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080303_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080303_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080303[$branch] = $account_5080303_debet[$branch] - $account_5080303_credit[$branch]; $account_5080303_total += $account_5080303[$branch]; $account_beban_transportasi_pusat_total[$branch] += $account_5080303[$branch]; $account_beban_operasi_total[$branch] += $account_5080303[$branch]; } $code = "5080304"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080304_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080304_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080304[$branch] = $account_5080304_debet[$branch] - $account_5080304_credit[$branch]; $account_5080304_total += $account_5080304[$branch]; $account_beban_transportasi_pusat_total[$branch] += $account_5080304[$branch]; $account_beban_operasi_total[$branch] += $account_5080304[$branch]; } $account_beban_transportasi_pusat_konsolidasi = $account_5080302_total + $account_5080303_total + $account_5080304_total; $account_beban_transportasi_cabang_konsolidasi = $account_beban_transportasi_pusat_konsolidasi - $account_beban_transportasi_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Transportasi Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_beban_transportasi_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_transportasi_pusat_total[0])) . ")" : number_format($account_beban_transportasi_pusat_total[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_beban_transportasi_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_transportasi_pusat_total[0])) . ")" : number_format($account_beban_transportasi_pusat_total[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban Perawatan Pusat $code = "5060000"; $code_level1 = substr($code, 0, 3); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5060000_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_5060000_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_5060000[$branch] = $account_5060000_debet[$branch] - $account_5060000_credit[$branch]; $account_5060000_total += $account_5060000[$branch]; $account_beban_operasi_total[$branch] += $account_5060000[$branch]; } $account_5060000_cabang = $account_5060000_total - $account_5060000[0]; $print .= ' <tr><td align="left" > Beban Perawatan Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_5060000[0] < 0 ? "(" . number_format(abs($account_5060000[0])) . ")" : number_format($account_5060000[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_5060000[0] < 0 ? "(" . number_format(abs($account_5060000[0])) . ")" : number_format($account_5060000[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban Listrik, Air, Telepon dan Internet Pusat : 5080101, 5080102, 5080103 $code = "5080101"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080101_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080101_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080101[$branch] = $account_5080101_debet[$branch] - $account_5080101_credit[$branch]; $account_5080101_total += $account_5080101[$branch]; $account_beban_listrik_air_telp_pusat_total[$branch] += $account_5080101[$branch]; $account_beban_operasi_total[$branch] += $account_5080101[$branch]; } $code = "5080102"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080102_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080102_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080102[$branch] = $account_5080102_debet[$branch] - $account_5080102_credit[$branch]; $account_5080102_total += $account_5080102[$branch]; $account_beban_listrik_air_telp_pusat_total[$branch] += $account_5080102[$branch]; $account_beban_operasi_total[$branch] += $account_5080102[$branch]; } $code = "5080103"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080103_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080103_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080103[$branch] = $account_5080103_debet[$branch] - $account_5080103_credit[$branch]; $account_5080103_total += $account_5080103[$branch]; $account_beban_listrik_air_telp_pusat_total[$branch] += $account_5080103[$branch]; $account_beban_operasi_total[$branch] += $account_5080103[$branch]; } $account_beban_listrik_air_telp_pusat_konsolidasi = $account_5080101_total + $account_5080102_total + $account_5080103_total; $account_beban_listrik_air_telp_cabang_konsolidasi = $account_beban_listrik_air_telp_pusat_konsolidasi - $account_beban_listrik_air_telp_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Listrik, Air, Telepon dan Internet Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_beban_listrik_air_telp_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_listrik_air_telp_pusat_total[0])) . ")" : number_format($account_beban_listrik_air_telp_pusat_total[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_beban_listrik_air_telp_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_listrik_air_telp_pusat_total[0])) . ")" : number_format($account_beban_listrik_air_telp_pusat_total[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban Lain-lain Pusat : 5080104, 5080402, 5080403, 5080406, 5080502, 5080503, 5080504 $code = "5080104"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080104_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080104_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080104[$branch] = $account_5080104_debet[$branch] - $account_5080104_credit[$branch]; $account_5080104_total += $account_5080104[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080104[$branch]; $account_beban_operasi_total[$branch] += $account_5080104[$branch]; } $code = "5080402"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080402_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080402_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080402[$branch] = $account_5080402_debet[$branch] - $account_5080402_credit[$branch]; $account_5080402_total += $account_5080402[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080402[$branch]; $account_beban_operasi_total[$branch] += $account_5080402[$branch]; } $code = "5080403"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080403_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080403_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080403[$branch] = $account_5080403_debet[$branch] - $account_5080403_credit[$branch]; $account_5080403_total += $account_5080403[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080403[$branch]; $account_beban_operasi_total[$branch] += $account_5080403[$branch]; } $code = "5080406"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080406_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080406_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080406[$branch] = $account_5080406_debet[$branch] - $account_5080406_credit[$branch]; $account_5080406_total += $account_5080406[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080406[$branch]; $account_beban_operasi_total[$branch] += $account_5080406[$branch]; } $code = "5080502"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080502_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080502_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080502[$branch] = $account_5080502_debet[$branch] - $account_5080502_credit[$branch]; $account_5080502_total += $account_5080502[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080502[$branch]; $account_beban_operasi_total[$branch] += $account_5080502[$branch]; } $code = "5080503"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080503_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080503_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080503[$branch] = $account_5080503_debet[$branch] - $account_5080503_credit[$branch]; $account_5080503_total += $account_5080503[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080503[$branch]; $account_beban_operasi_total[$branch] += $account_5080503[$branch]; } $code = "5080504"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080504_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080504_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080504[$branch] = $account_5080504_debet[$branch] - $account_5080504_credit[$branch]; $account_5080504_total += $account_5080504[$branch]; $account_beban_lainlain_pusat_total[$branch] += $account_5080504[$branch]; $account_beban_operasi_total[$branch] += $account_5080504[$branch]; } $account_beban_lainlain_pusat_konsolidasi = $account_5080104_total + $account_5080402_total + $account_5080403_total + $account_5080406_total + $account_5080502_total + $account_5080503_total + $account_5080504_total; $account_beban_lainlain_cabang_konsolidasi = $account_beban_lainlain_pusat_konsolidasi - $account_beban_lainlain_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Lain-lain Pusat</td>'; $print .= ' <td align="right" class="">' . ($account_beban_lainlain_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_lainlain_pusat_total[0])) . ")" : number_format($account_beban_lainlain_pusat_total[0])) . '</td>'; $print .= ' <td align="right" class="">' . ($account_beban_lainlain_pusat_total[0] < 0 ? "(" . number_format(abs($account_beban_lainlain_pusat_total[0])) . ")" : number_format($account_beban_lainlain_pusat_total[0])) . '</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">0</td>'; } $print .= '</tr>'; //Beban Rumah Tangga Seluruh Cabang $account_beban_RT_cabang_konsolidasi = $account_beban_RT_pusat_konsolidasi - $account_beban_RT_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Rumah Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_RT_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_RT_cabang_konsolidasi)) . ")" : number_format($account_beban_RT_cabang_konsolidasi)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $total_branch <= 0; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_RT_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_beban_RT_pusat_total[$branch])) . ")" : number_format($account_beban_RT_pusat_total[$branch])) . '</td>'; } $print .= '</tr>'; //Beban ATK Seluruh Cabang $account_beban_ATK_cabang_konsolidasi = $account_beban_ATK_pusat_konsolidasi - $account_beban_ATK_pusat_total[0]; $print .= ' <tr><td align="left" > Beban ATK Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_ATK_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_ATK_cabang_konsolidasi)) . ")" : number_format($account_beban_ATK_cabang_konsolidasi)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_ATK_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_beban_ATK_pusat_total[$branch])) . ")" : number_format($account_beban_ATK_pusat_total[$branch])) . '</td>'; } //Beban Transportasi Seluruh Cabang $account_beban_transportasi_cabang_konsolidasi = $account_beban_transportasi_pusat_konsolidasi - $account_beban_transportasi_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Transportasi Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_transportasi_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_transportasi_cabang_konsolidasi)) . ")" : number_format($account_beban_transportasi_cabang_konsolidasi)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_transportasi_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_beban_transportasi_pusat_total[$branch])) . ")" : number_format($account_beban_transportasi_pusat_total[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Perawatan Seluruh Cabang $print .= ' <tr><td align="left" > Beban Perawatan Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_5060000_cabang < 0 ? "(" . number_format(abs($account_5060000_cabang)) . ")" : number_format($account_5060000_cabang)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5060000[$branch] < 0 ? "(" . number_format(abs($account_5060000[$branch])) . ")" : number_format($account_5060000[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Listrik, Air, Telepon dan Internet Seluruh Cabang $account_beban_listrik_air_telp_cabang_konsolidasi = $account_beban_listrik_air_telp_pusat_konsolidasi - $account_beban_listrik_air_telp_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Listrik, Air, Telepon dan Internet Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_listrik_air_telp_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_listrik_air_telp_cabang_konsolidasi)) . ")" : number_format($account_beban_listrik_air_telp_cabang_konsolidasi)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_listrik_air_telp_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_beban_listrik_air_telp_pusat_total[$branch])) . ")" : number_format($account_beban_listrik_air_telp_pusat_total[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Lain-lain Seluruh Cabang $account_beban_lainlain_cabang_konsolidasi = $account_beban_lainlain_pusat_konsolidasi - $account_beban_lainlain_pusat_total[0]; $print .= ' <tr><td align="left" > Beban Lain-lain Seluruh Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_lainlain_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_lainlain_cabang_konsolidasi)) . ")" : number_format($account_beban_lainlain_cabang_konsolidasi)) . '</td>'; $print .= ' <td align="right" class="">0</td>'; for ($branch = 1; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_lainlain_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_beban_lainlain_pusat_total[$branch])) . ")" : number_format($account_beban_lainlain_pusat_total[$branch])) . '</td>'; } //Beban Cleaning Service $print .= ' <tr><td align="left" > Beban Cleaning Service</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Keamanan dan Kebersihan $code = "5080405"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5080405_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5080405_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5080405[$branch] = $account_5080405_debet[$branch] - $account_5080405_credit[$branch]; $account_5080405_total += $account_5080405[$branch]; $account_biaya_langsung_total[$branch] += $account_5080405[$branch]; } $print .= ' <tr><td align="left" > Beban Keamanan dan Kebersihan</td>'; $print .= ' <td align="right" class="">' . ($account_5080405_total < 0 ? "(" . number_format(abs($account_5080405_total)) . ")" : number_format($account_5080405_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5080405[$branch] < 0 ? "(" . number_format(abs($account_5080405[$branch])) . ")" : number_format($account_5080405[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Penyusutan $code = "5070000"; $code_level1 = substr($code, 0, 3); for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5070000_debet[$branch] = $this->jurnal_model->sum_account_parent_debet_by_date($code_level1, $date_start, $date_end, $branch); $account_5070000_credit[$branch] = $this->jurnal_model->sum_account_parent_credit_by_date($code_level1, $date_start, $date_end, $branch); $account_5070000[$branch] = $account_5070000_debet[$branch] - $account_5070000_credit[$branch]; $account_5070000_total += $account_5070000[$branch]; $account_biaya_operasi_total[$branch] += $account_5070000[$branch]; } $print .= ' <tr><td align="left" > Beban Penyusutan</td>'; $print .= ' <td align="right" class="">' . ($account_5070000_total < 0 ? "(" . number_format(abs($account_5070000_total)) . ")" : number_format($account_5070000_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5070000[$branch] < 0 ? "(" . number_format(abs($account_5070000[$branch])) . ")" : number_format($account_5070000[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Sewa Kantor Cabang : 5040001, 5040002 $code = "5040001"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5040001_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5040001_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5040001[$branch] = $account_5040001_debet[$branch] - $account_5040001_credit[$branch]; $account_5040001_total += $account_5040001[$branch]; $account_beban_sewa_kantor_cabang_total[$branch] += $account_5040001[$branch]; $account_beban_operasi_total[$branch] += $account_5040001[$branch]; } $code = "5040002"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5040002_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5040002_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5040002[$branch] = $account_5040002_debet[$branch] - $account_5040002_credit[$branch]; $account_5040002_total += $account_5040002[$branch]; $account_beban_sewa_kantor_cabang_total[$branch] += $account_5040002[$branch]; $account_beban_operasi_total[$branch] += $account_5040002[$branch]; } $account_beban_sewa_kantor_cabang_konsolidasi = $account_5040001_total + $account_5040002_total; $print .= ' <tr><td align="left" > Beban Sewa Kantor Cabang</td>'; $print .= ' <td align="right" class="">' . ($account_beban_sewa_kantor_cabang_konsolidasi < 0 ? "(" . number_format(abs($account_beban_sewa_kantor_cabang_konsolidasi)) . ")" : number_format($account_beban_sewa_kantor_cabang_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_beban_sewa_kantor_cabang_total[$branch] < 0 ? "(" . number_format(abs($account_beban_sewa_kantor_cabang_total[$branch])) . ")" : number_format($account_beban_sewa_kantor_cabang_total[$branch])) . '</td>'; } $print .= '</tr>'; //Beban MIS $print .= ' <tr><td align="left" > Beban MIS</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Total Biaya Operasi for ($branch = 0; $branch <= $total_branch; $branch++) { $account_beban_operasi_konsolidasi += $account_beban_operasi_total[$branch]; } $print .= ' <tr><td align="left" >Total Biaya Operasi</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_beban_operasi_konsolidasi < 0 ? "(" . number_format(abs($account_beban_operasi_konsolidasi)) . ")" : number_format($account_beban_operasi_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_beban_operasi_total[$branch] < 0 ? "(" . number_format(abs($account_beban_operasi_total[$branch])) . ")" : number_format($account_beban_operasi_total[$branch])) . '</td>'; } $print .= ' </tr>'; $print .= ' <tr><td></td><td align="left" class="border_btm" colspan="' . $colspan . '"> </td></tr>'; //Laba (Rugi) Operasi $account_LR_operasi_konsolidasi = $account_labarugi_kotor_konsolidasi - $account_beban_operasi_konsolidasi; $print .= ' <tr><td align="left" ><b>Laba (Rugi) Operasi</b></td>'; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_operasi_konsolidasi < 0 ? "(" . number_format(abs($account_LR_operasi_konsolidasi)) . ")" : number_format($account_LR_operasi_konsolidasi)) . '</b></td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_LR_operasi[$branch] = $account_labarugi_kotor_total[$branch] - $account_beban_operasi_total[$branch]; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_operasi[$branch] < 0 ? "(" . number_format(abs($account_LR_operasi[$branch])) . ")" : number_format($account_LR_operasi[$branch])) . '</b></td>'; } $print .= ' </tr>'; //--------------------------------------------------------------------------------------------- //Pendapatan Diluar Usaha //--------------------------------------------------------------------------------------------- $print .= ' <tr><td align="left" colspan="' . $colspan2 . '"> </td></tr>'; $print .= ' <tr><td align="left" ><b>Pendapatan & Beban Diluar Usaha</b></td> <td colspan="' . $colspan . '" ></td></tr>'; $print .= ' <tr><td align="left" ><b>Pendapatan Diluar Usaha</b></td> <td colspan="' . $colspan . '" ></td></tr>'; //Pendapatan Bunga Bank $code = "4030005"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030005_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030005_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030005[$branch] = $account_4030005_credit[$branch] - $account_4030005_debet[$branch]; $account_4030005_total += $account_4030005[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030005[$branch]; } $print .= ' <tr><td align="left" > Pendapatan Bunga Bank</td>'; $print .= ' <td align="right" class="">' . ($account_4030005_total < 0 ? "(" . number_format(abs($account_4030005_total)) . ")" : number_format($account_4030005_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_4030005[$branch] < 0 ? "(" . number_format(abs($account_4030005[$branch])) . ")" : number_format($account_4030005[$branch])) . '</td>'; } $print .= '</tr>'; //Pendapatan Lainnya : 4030001, 4030002, 4030003, 4030004, 4030006 $code = "4030001"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030001_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030001_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030001[$branch] = $account_4030001_credit[$branch] - $account_4030001_debet[$branch]; $account_4030001_total += $account_4030001[$branch]; $account_pendapatan_lain_pusat_total[$branch] += $account_4030001[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030001[$branch]; } $code = "4030002"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030002_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030002_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030002[$branch] = $account_4030002_credit[$branch] - $account_4030002_debet[$branch]; $account_4030002_total += $account_4030002[$branch]; $account_pendapatan_lain_pusat_total[$branch] += $account_4030002[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030002[$branch]; } $code = "4030003"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030003_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030003_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030003[$branch] = $account_4030003_credit[$branch] - $account_4030003_debet[$branch]; $account_4030003_total += $account_4030003[$branch]; $account_pendapatan_lain_pusat_total[$branch] += $account_4030003[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030003[$branch]; } $code = "4030004"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030004_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030004_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030004[$branch] = $account_4030004_credit[$branch] - $account_4030004_debet[$branch]; $account_4030004_total += $account_4030004[$branch]; $account_pendapatan_lain_pusat_total[$branch] += $account_4030004[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030004[$branch]; } $code = "4030006"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_4030006_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_4030006_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_4030006[$branch] = $account_4030006_credit[$branch] - $account_4030006_debet[$branch]; $account_4030006_total += $account_4030006[$branch]; $account_pendapatan_lain_pusat_total[$branch] += $account_4030006[$branch]; $account_pendapatan_diluar_usaha_total[$branch] += $account_4030006[$branch]; } $account_pendapatan_lain_konsolidasi = $account_4030001_total + $account_4030002_total + $account_4030003_total + $account_4030004_total + $account_4030006_total; $print .= ' <tr><td align="left" > Pendapatan Lainnya</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_lain_konsolidasi < 0 ? "(" . number_format(abs($account_pendapatan_lain_konsolidasi)) . ")" : number_format($account_pendapatan_lain_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_lain_pusat_total[$branch] < 0 ? "(" . number_format(abs($account_pendapatan_lain_pusat_total[$branch])) . ")" : number_format($account_pendapatan_lain_pusat_total[$branch])) . '</td>'; } $print .= '</tr>'; //Total Pendapatan Diluar Usaha $account_pendapatan_diluar_usaha_konsolidasi = $account_4030005_total + $account_pendapatan_lain_konsolidasi; $print .= ' <tr><td align="left" > Total Pendapatan Diluar Usaha</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_diluar_usaha_konsolidasi < 0 ? "(" . number_format(abs($account_pendapatan_diluar_usaha_konsolidasi)) . ")" : number_format($account_pendapatan_diluar_usaha_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_pendapatan_diluar_usaha_total[$branch] < 0 ? "(" . number_format(abs($account_pendapatan_diluar_usaha_total[$branch])) . ")" : number_format($account_pendapatan_diluar_usaha_total[$branch])) . '</td>'; } $print .= '</tr>'; //--------------------------------------------------------------------------------------------- //Beban Diluar Usaha //--------------------------------------------------------------------------------------------- $print .= ' <tr><td align="left" colspan="' . $colspan2 . '"> </td></tr>'; $print .= ' <tr><td align="left" ><b>Beban Diluar Usaha</b></td> <td colspan="' . $colspan . '" ></td></tr>'; //Beban Bunga Bank $code = "5090004"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5090004_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5090004_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5090004[$branch] = $account_5090004_debet[$branch] - $account_5090004_credit[$branch]; $account_5090004_total += $account_5090004[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5090004[$branch]; } $print .= ' <tr><td align="left" > Beban Bunga Bank</td>'; $print .= ' <td align="right" class="">' . ($account_5090004_total < 0 ? "(" . number_format(abs($account_5090004_total)) . ")" : number_format($account_5090004_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5090004[$branch] < 0 ? "(" . number_format(abs($account_5090004[$branch])) . ")" : number_format($account_5090004[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Merchant Discount Rate $print .= ' <tr><td align="left" > Beban Merchant Discount Rate</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Kerugian Penghapusan Aktiva Tetap $code = "5090003"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5090003_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5090003_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5090003[$branch] = $account_5090003_debet[$branch] - $account_5090003_credit[$branch]; $account_5090003_total += $account_5090003[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5090003[$branch]; } $print .= ' <tr><td align="left" > Beban Kerugian Penghapusan Aktiva Tetap</td>'; $print .= ' <td align="right" class="">' . ($account_5090003_total < 0 ? "(" . number_format(abs($account_5090003_total)) . ")" : number_format($account_5090003_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5090003[$branch] < 0 ? "(" . number_format(abs($account_5090003[$branch])) . ")" : number_format($account_5090003[$branch])) . '</td>'; } $print .= '</tr>'; //Selisih kurs/Penerimaan /Pembayaran $print .= ' <tr><td align="left" > Selisih kurs/Penerimaan /Pembayaran</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Beban PPh Pasal 21 Karyawan $code = "5050003"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5050003_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5050003_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5050003[$branch] = $account_5050003_debet[$branch] - $account_5050003_credit[$branch]; $account_5050003_total += $account_5050003[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5050003[$branch]; } $print .= ' <tr><td align="left" > Beban PPh Pasal 21 Karyawan</td>'; $print .= ' <td align="right" class="">' . ($account_5050003_total < 0 ? "(" . number_format(abs($account_5050003_total)) . ")" : number_format($account_5050003_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_5050003[$branch] < 0 ? "(" . number_format(abs($account_5050003[$branch])) . ")" : number_format($account_5050003[$branch])) . '</td>'; } $print .= '</tr>'; //Beban PPh Pasal 4 Ayat (2) atas Sewa Ruangan $print .= ' <tr><td align="left" > Beban PPh Pasal 4 Ayat (2) atas Sewa Ruangan</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Beban PPh Pasal 4 Ayat (2) atas Bunga Bank $print .= ' <tr><td align="left" > Beban PPh Pasal 4 Ayat (2) atas Bunga Bank</td>'; $print .= ' <td align="right" class="">' . ($account_9999999_total < 0 ? "(" . number_format(abs($account_9999999_total)) . ")" : number_format($account_9999999_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="">' . ($account_9999999[$branch] < 0 ? "(" . number_format(abs($account_9999999[$branch])) . ")" : number_format($account_9999999[$branch])) . '</td>'; } $print .= '</tr>'; //Beban Lainnya: 5050001, 5050002, 5050005, 5090001, 5090002, 5090005 $code = "5050001"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5050001_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5050001_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5050001[$branch] = $account_5050001_debet[$branch] - $account_5050001_credit[$branch]; $account_5050001_total += $account_5050001[$branch]; $account_beban_lain_total[$branch] += $account_5050001[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5050001[$branch]; } $code = "5050002"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5050002_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5050002_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5050002[$branch] = $account_5050002_debet[$branch] - $account_5050002_credit[$branch]; $account_5050002_total += $account_5050002[$branch]; $account_beban_lain_total[$branch] += $account_5050002[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5050002[$branch]; } $code = "5050005"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5050005_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5050005_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5050005[$branch] = $account_5050005_debet[$branch] - $account_5050005_credit[$branch]; $account_5050005_total += $account_5050005[$branch]; $account_beban_lain_total[$branch] += $account_5050005[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5050005[$branch]; } $code = "5090001"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5090001_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5090001_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5090001[$branch] = $account_5090001_debet[$branch] - $account_5090001_credit[$branch]; $account_5090001_total += $account_5090001[$branch]; $account_beban_lain_total[$branch] += $account_5090001[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5090001[$branch]; } $code = "5090002"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5090002_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5090002_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5090002[$branch] = $account_5090002_debet[$branch] - $account_5090002_credit[$branch]; $account_5090002_total += $account_5090002[$branch]; $account_beban_lain_total[$branch] += $account_5090002[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5090002[$branch]; } $code = "5090005"; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_5090005_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code, $date_start, $date_end, $branch); $account_5090005_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code, $date_start, $date_end, $branch); $account_5090005[$branch] = $account_5090005_debet[$branch] - $account_5090005_credit[$branch]; $account_5090005_total += $account_5090005[$branch]; $account_beban_lain_total[$branch] += $account_5090005[$branch]; $account_beban_diluar_usaha_total[$branch] += $account_5090005[$branch]; } $account_beban_lain_konsolidasi = $account_5050001_total + $account_5050002_total + $account_5050005_total + $account_5090001_total + $account_5090002_total + $account_5090005_total; $print .= ' <tr><td align="left" > Beban Lainnya</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_beban_lain_konsolidasi < 0 ? "(" . number_format(abs($account_beban_lain_konsolidasi)) . ")" : number_format($account_beban_lain_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_beban_lain_total[$branch] < 0 ? "(" . number_format(abs($account_beban_lain_total[$branch])) . ")" : number_format($account_beban_lain_total[$branch])) . '</td>'; } $print .= '</tr>'; //Total Beban Diluar Usaha for ($branch = 0; $branch <= $total_branch; $branch++) { $account_beban_diluar_usaha_konsolidasi += $account_beban_diluar_usaha_total[$branch]; } $print .= ' <tr><td align="left" > Total Beban Diluar Usaha</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_beban_diluar_usaha_konsolidasi < 0 ? "(" . number_format(abs($account_beban_diluar_usaha_konsolidasi)) . ")" : number_format($account_beban_diluar_usaha_konsolidasi)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_beban_diluar_usaha_total[$branch] < 0 ? "(" . number_format(abs($account_beban_diluar_usaha_total[$branch])) . ")" : number_format($account_beban_diluar_usaha_total[$branch])) . '</td>'; } $print .= '</tr>'; $print .= ' <tr><td></td><td align="left" colspan="' . $colspan . '" class="border_btm"> </td></tr>'; //--------------------------------------------------------------------------------------------- //Laba (Rugi) TOTAL //--------------------------------------------------------------------------------------------- //Laba (Rugi) Sebelum Pajak $account_LR_sebelum_pajak_konsolidasi = $account_LR_operasi_konsolidasi + $account_pendapatan_diluar_usaha_konsolidasi - $account_beban_diluar_usaha_konsolidasi; $print .= ' <tr><td align="left" ><b>Laba (Rugi) Sebelum Pajak</b></td>'; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_sebelum_pajak_konsolidasi < 0 ? "(" . number_format(abs($account_LR_sebelum_pajak_konsolidasi)) . ")" : number_format($account_LR_sebelum_pajak_konsolidasi)) . '</b></td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_LR_sebelum_pajak[$branch] = $account_LR_operasi_total[$branch] + $account_pendapatan_diluar_usaha_total[$branch] - $account_beban_diluar_usaha_total[$branch]; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_sebelum_pajak[$branch] < 0 ? "(" . number_format(abs($account_LR_sebelum_pajak[$branch])) . ")" : number_format($account_LR_sebelum_pajak[$branch])) . '</b></td>'; } $print .= '</tr>'; $print .= ' <tr><td></td><td align="left" colspan="' . $colspan . '" class="border_btm"></td></tr>'; //Pajak Penghasilan Badan $code = "5050004"; for ($branch = 0; $branch <= $total_branch; $branch++) { //$account_5050004_debet[$branch] = $this->jurnal_model->sum_account_debet_by_date($code,$date_start,$date_end,$branch); //$account_5050004_credit[$branch] = $this->jurnal_model->sum_account_credit_by_date($code,$date_start,$date_end,$branch); //$account_5050004[$branch] = $account_5050004_debet[$branch] - $account_5050004_credit[$branch]; $account_5050004[$branch] = 0; $account_5050004_total += $account_5050004[$branch]; } $print .= ' <tr><td align="left" > Pajak Penghasilan Badan</td>'; $print .= ' <td align="right" class="border_btm">' . ($account_5050004_total < 0 ? "(" . number_format(abs($account_5050004_total)) . ")" : number_format($account_5050004_total)) . '</td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $print .= ' <td align="right" class="border_btm">' . ($account_5050004[$branch] < 0 ? "(" . number_format(abs($account_5050004[$branch])) . ")" : number_format($account_5050004[$branch])) . '</td>'; } $print .= '</tr>'; $print .= ' <tr><td></td><td align="left" colspan="' . $colspan . '" class="border_btm"></td></tr>'; //Laba (Rugi) Bersih $account_LR_bersih_konsolidasi = $account_LR_sebelum_pajak_konsolidasi - $account_5050004_total; $print .= ' <tr><td align="left" ><b>Laba (Rugi) Bersih</b></td>'; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_bersih_konsolidasi < 0 ? "(" . number_format(abs($account_LR_bersih_konsolidasi)) . ")" : number_format($account_LR_bersih_konsolidasi)) . '</b></td>'; for ($branch = 0; $branch <= $total_branch; $branch++) { $account_LR_bersih_total[$branch] = $account_LR_sebelum_pajak[$branch] - $account_5050004[$branch]; $print .= ' <td align="right" class="border_btm"><b>' . ($account_LR_bersih_total[$branch] < 0 ? "(" . number_format(abs($account_LR_bersih_total[$branch])) . ")" : number_format($account_LR_bersih_total[$branch])) . '</b></td>'; } $print .= '</tr>'; $print .= '</table>'; $html .= $print; $this->load->library('mpdf'); $mpdf = new mPDF('utf-8', 'A4-L'); $mpdf->SetHeader("Amartha Microfinance" . '||' . $tgl . '|'); $mpdf->SetFooter("Laporan Laba Rugi" . '||{PAGENO}|'); $mpdf->WriteHTML($html); //echo $html; //$this->mpdf->Output(); $pdfFilePath = FCPATH . "downloads/labarugi/{$filename}.pdf"; $pdffile = base_url() . "downloads/labarugi/{$filename}.pdf"; $mpdf->Output($pdfFilePath, 'F'); redirect($pdffile, 'refresh'); } else { //If no session, redirect to login page redirect('login', 'refresh'); } }
public function actionExportPdfDetail($tgl) { $dates = $this->getDates($tgl); $asset = Asset::find()->where(['TGL' => $dates[0]])->one(); $assetat = Assetat::find()->where(['TGL' => $dates[2]])->one(); $searchModel = new IndikatorSearch(['TGL' => $tgl]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $html = $this->renderPartial('_detail_pdf', ['asset' => $asset, 'assetat' => $assetat, 'dataProvider' => $dataProvider, 'dates' => $dates]); //function mPDF($mode='',$format='A4',$default_font_size=0,$default_font='',$mgl=15,$mgr=15,$mgt=16,$mgb=16,$mgh=9,$mgf=9, $orientation='P') { $mpdf = new \mPDF('c', 'A4', 0, '', 15, 10, 15, 10, 10, 10); $header = ['L' => ['content' => date('d-M-Y H:i:s'), 'font-family' => 'sans', 'font-style' => '', 'font-size' => '9'], 'C' => [], 'R' => ['content' => 'Page {PAGENO} of {nbpg}', 'font-family' => 'sans', 'font-style' => '', 'font-size' => '9'], 'line' => 1]; $mpdf->SetFooter($header, 'O'); $mpdf->SetDisplayMode('fullpage'); $mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list $mpdf->WriteHTML($html); $mpdf->Output($this->id . '_' . date('YmdHis') . '.pdf', 'D'); exit; }
protected function exporttopdf($title,$filename,$html) { $org_data=Organization::model()->findAll(); foreach($org_data as $as=>$row) { $org=$row['organization_id']; } $mpdf=Yii::app()->ePdf->mpdf(); $mpdf=Yii::app()->ePdf->mpdf('', 'A4',0,'',15,15,25,16,4,9,'P'); $mpdf = new mPDF('', 'A4',0,'',15,15,30,20,4,9,'P'); ob_clean(); ob_clean(); $org = Organization::model()->findAll(); $org_image=CHtml::link(CHtml::image(Yii::app()->controller->createUrl('/site/loadImage', array('id'=>$org[0]['organization_id'])),'No Image',array('width'=>130,'height'=>70))); $org_name=$org[0]['organization_name']; $org_add=$org[0]['address_line1']."<br/>".$org[0]['address_line2']."<br/>"; $mpdf->SetHTMLHeader('<table style="border-bottom:1.6px solid #74b9fo;border-top:hidden;border-left:hidden;border-right:hidden;width:100%;"><tr style="border:hidden"><td vertical-align="center" style="width:35px;border:hidden" align="left">'.$org_image.'</td><td style="border:hidden"><b style="font-size:22px;">'.$org_name.'</b><br/><span style="font-size:10.2px">'.$org_add.'</td></tr></table>'); $mpdf->SetWatermarkImage('images/rudraSoftech.png',0.3, ''); $mpdf->showWatermarkImage = true; $arr = array ( 'odd' => array ( 'L' => array ( 'content' => $title, 'font-size' => 10, 'font-style' => 'B', 'font-family' => 'serif', 'color'=>'#27292b' ), 'C' => array ( 'content' => 'Page - {PAGENO}/{nbpg}', 'font-size' => 10, 'font-style' => 'B', 'font-family' => 'serif', 'color'=>'#27292b' ), 'R' => array ( 'content' => 'Printed @ {DATE j-m-Y H:m}', 'font-size' => 10, 'font-style' => 'B', 'font-family' => 'serif', 'color'=>'#27292b' ), 'line' => 1, ), 'even' => array () ); $mpdf->SetFooter($arr); $mpdf->WriteHTML('<sethtmlpageheader name="main" page="ALL" value="on" show-this-page="1">'); $mpdf->WriteHTML($html); $mpdf->Output($filename,"I"); /* Yii::import('application.extensions.tcpdf.*'); require_once('tcpdf/tcpdf.php'); require_once('tcpdf/config/lang/eng.php'); ob_clean(); $pdf = new TCPDF(); $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor(Yii::app()->name); $pdf->SetTitle($title); $pdf->SetSubject($title); $pdf->SetKeywords('example, text, report'); $pdf->SetHeaderData('', 0, $title, ''); //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".Yii::app()->name, ""); $pdf->setHeaderFont(Array('helvetica', '', 8)); $pdf->setFooterFont(Array('helvetica', '', 6)); $pdf->SetMargins(15, 18, 15); $pdf->SetHeaderMargin(5); $pdf->SetFooterMargin(10); $pdf->SetAutoPageBreak(TRUE, 15); $pdf->SetFont('dejavusans', '', 7); $resolution= array(150, 150); $pdf->AddPage('P', $resolution); $pdf->writeHTML($html, true, false, true, false, ''); $pdf->LastPage(); $pdf->Output($filename, "I");*/ }
<?php // Export to PDF using mPDF require_once './vendor/autoload.php'; require_once 'config.php'; require_once 'functions.php'; $data = htmlspecialchars_decode($_REQUEST['data']); $afm = $_REQUEST['afm']; $stylesheet = file_get_contents('lib/bootstrap.min.css'); $fname = 'pdf/es_' . $afm . '_' . rand() . '.pdf'; $footer = "{$dnsiStrShort}"; // mPDF initialization & pdf creation $mpdf = new mPDF(); $mpdf->SetFooter($footer); $mpdf->WriteHTML($stylesheet, 1); $mpdf->WriteHTML($data, 2); $mpdf->Output($fname); //log to file if ($canLog) { logToFile($afm, $logFile, 1); } // echo (return) file link echo "<a href='{$fname}' target='_blank'><strong>Λήψη αρχείου</strong></a>";
<p>e para clareza firmo(amos) o presente.</p> <p class='direita'>Ribeirão Preto,".date("d/m/Y")."</p> <p>Assinatura ......................................................................................................................................</p> <p>Nome <strong>Hugo Lopes</strong> CPF/CNPJ: <strong>437.706.058-962</strong></p> <p>Endereço <strong>Rua da Penha, 200 - Jd. Alguma Coisa - São Paulo</strong></p> </fieldset>"; //instanciamos nossa classe mPDF $mpdf=new mPDF(); //definimos o tipo de exibicao $mpdf->SetDisplayMode('fullpage'); //definimos estilos de fonts $mpdf->useOnlyCoreFonts = true; $mpdf->watermark_font = 'DejaVuSansCondensed'; //definimos se vamos exibir a marca d'agua $mpdf->showWatermarkText = false; $mpdf->SetWatermarkText('Marca d\'agua'); //colocamos um icone de logo tipo no pdf $mpdf->SetWatermarkImage('icones/logoif.png', 1, '', array(140,10)); //definimos se sera exibido ou nao o logo no pdf $mpdf->showWatermarkImage = true; //escrve o titulo de nosso pdf $mpdf->WriteHTML('<br/><h1>Titulo do PDF</h1><hr/>'); //definimos oque vai conter no rodape do pdf $mpdf->SetFooter('{DATE j/m/Y H:i}||Pagina {PAGENO}/{nb}'); //e finalmente escrevemos todo nosso conteudo no pdf para exibir $mpdf->WriteHTML($html); //fechamos nossa instancia ao pdf $mpdf->Output(); //pausamos a tela para exibir o que foi feito exit(); ?>
$runTxa = explode(",", $d["taxs"]); $Tax = 0; foreach ($runTxa as $idat) { //echo $idat.'<br>'; $ops = mysql_fetch_array(mysql_query("SELECT * FROM tax_table WHERE tax_id = '{$idat}' AND saasid = '" . $_SESSION['saasid'] . "' AND active = 'true'")); //echo $ops['percent'].'<br>'.$subTottax; $Tax = round($subTottax * $ops['percent'] / 100, 2); $runTax .= '<div style="width:360px; height:31px; float:right; clear:both; border-bottom:solid thin #CCC;"><div style="width:210px; float:left">' . $ops['tax_name'] . ':</div> <div style="width:130px; float:left; text-align:right">$' . $Tax . '</div></div>'; $taxcom += $Tax; } $afterMath = number_format($cleanSub + $taxcom, 2); $html .= '<div style="width:360px; height:31px; float:right;"><div style="width:210px; float:left">Subtotal:</div> <div style="width:130px; float:left; text-align:right">$' . $cleanSubtru . '</div></div> ' . $runTax . ' <div style="width:360px; height:31px; float:right; clear:both"><div style="width:210px; float:left; font-weight:bold">Total:</div> <div style="width:130px; float:left; text-align:right">$' . $afterMath . '</div></div><input name="estiamount" id="estiamount" type="hidden" value="' . $afterMath . '" />'; $html .= '</div> '; $rt = mysql_fetch_array(mysql_query("SELECT * FROM core_users WHERE usr_id = '" . $b["salesman"] . "' AND saasid = '" . $_SESSION['saasid'] . "'")); $mpdf = new mPDF(); $mpdf->SetHTMLHeader('<div style="width:161px; height:64px; float:left; background-image:url(images/main_logo.gif)"></div><div style="float:left; text-align:right; font-size:11px">Work Order for: ' . $dd["companyname"] . '<br>Date Created: ' . $b["issue_date"] . '<br>Created By: ' . $rt["fname"] . ' ' . $rt["lname"] . '</div>'); $mpdf->SetFooter('ACS Work Orders | {PAGENO}'); $mpdf->WriteHTML($html); $mpdf->Output(); //$mpdf->Output('filename.pdf','F'); exit; //============================================================== //============================================================== //==============================================================
<input type="password" size="40" name="password" value="secret"> <br /><br /> <input type="checkbox" name="QPC" value="ON" > Checkboxes<br> <input type="checkbox" name="QPA" value="ON" > Not selected<br> <input type="checkbox" name="QLY" value="ON" checked="checked" > Selected<br> <input type="checkbox" name="QLY" value="ON" disabled="disabled" > Disabled <br /><br /> <input type="submit" name="submit" value="Submit" /> <input type="image" name="submit" src="goto.gif" /> <input type="button" name="submit" value="Button" /> <input type="reset" name="submit" value="Reset" /> </form> '; //============================================================== //============================================================== //============================================================== include "../mpdf.php"; $mpdf = new mPDF(); $mpdf->SetHeader('Document Title|Center Text'); $mpdf->SetFooter('Document Title | {PAGENO}'); $mpdf->WriteHTML($html); $mpdf->Output(); exit; //============================================================== //============================================================== //==============================================================
$mpdf = new mPDF('c'); $mpdf->mirrorMargins = 1; // Use different Odd/Even headers and footers and mirror margins $mpdf->defaultheaderfontsize = 10; /* in pts */ $mpdf->defaultheaderfontstyle = B; /* blank, B, I, or BI */ $mpdf->defaultheaderline = 1; /* 1 to include line below header/above footer */ $mpdf->defaultfooterfontsize = 12; /* in pts */ $mpdf->defaultfooterfontstyle = B; /* blank, B, I, or BI */ $mpdf->defaultfooterline = 1; /* 1 to include line below header/above footer */ $mpdf->SetHeader('{DATE j-m-Y}|{PAGENO}/{nb}|My document'); $mpdf->SetFooter('{PAGENO}'); /* defines footer for Odd and Even Pages - placed at Outer margin */ $mpdf->SetFooter(array('L' => array('content' => 'Text to go on the left', 'font-family' => 'sans-serif', 'font-style' => 'B', 'font-size' => '10'), 'C' => array('content' => '- {PAGENO} -', 'font-family' => 'serif', 'font-style' => 'BI', 'font-size' => '18'), 'R' => array('content' => 'Printed @ {DATE j-m-Y H:m}', 'font-family' => 'monospace', 'font-style' => '', 'font-size' => '10'), 'line' => 1), 'E'); $html = ' <h1>mPDF</h1> <h2>Headers & Footers Method 1</h2> <h3>Odd / Right page</h3> <p>Nulla felis erat, imperdiet eu, ullamcorper non, nonummy quis, elit. Suspendisse potenti. Ut a eros at ligula vehicula pretium. Maecenas feugiat pede vel risus. Nulla et lectus. Fusce eleifend neque sit amet erat. Integer consectetuer nulla non orci. Morbi feugiat pulvinar dolor. Cras odio. Donec mattis, nisi id euismod auctor, neque metus pellentesque risus, at eleifend lacus sapien et risus. Phasellus metus. Phasellus feugiat, lectus ac aliquam molestie, leo lacus tincidunt turpis, vel aliquam quam odio et sapien. Mauris ante pede, auctor ac, suscipit quis, malesuada sed, nulla. Integer sit amet odio sit amet lectus luctus euismod. Donec et nulla. Sed quis orci. </p> <pagebreak /> <h3>Even / Left page</h3> <p>Nulla felis erat, imperdiet eu, ullamcorper non, nonummy quis, elit. Suspendisse potenti. Ut a eros at ligula vehicula pretium. Maecenas feugiat pede vel risus. Nulla et lectus. Fusce eleifend neque sit amet erat. Integer consectetuer nulla non orci. Morbi feugiat pulvinar dolor. Cras odio. Donec mattis, nisi id euismod auctor, neque metus pellentesque risus, at eleifend lacus sapien et risus. Phasellus metus. Phasellus feugiat, lectus ac aliquam molestie, leo lacus tincidunt turpis, vel aliquam quam odio et sapien. Mauris ante pede, auctor ac, suscipit quis, malesuada sed, nulla. Integer sit amet odio sit amet lectus luctus euismod. Donec et nulla. Sed quis orci. </p> '; $mpdf->WriteHTML($html); $mpdf->Output(); exit;
$html = $html2; } else { $html = $html1; } $pph[$i] = SinglePage($html, $pw, $ph, $minK); // $pph saves the actual height of each page } //============================================================== // Save the pages to a file $mpdf->Output('test.pdf', 'F'); // Now collate those pages using IMPORT - 4 pages to one page $mpdf = new mPDF(); $mpdf->SetImportUse(); $mpdf->SetDisplayMode('fullpage'); $mpdf->SetHeader('{DATE j-m-Y}|My Yearbook 2005|{PAGENO}'); $mpdf->SetFooter('|Printed using mPDF|'); $pagecount = $mpdf->SetSourceFile('test.pdf'); for ($i = 1; $i <= $pagecount; $i++) { if ($i % 4 == 1) { $mpdf->AddPage(); } $pgheight = $mpdf->h - $mpdf->tMargin - $mpdf->bMargin; $hspacing = min($spacing, $mpdf->pgwidth - $pw * 2); $vspacing = min($spacing, $pgheight - $ph * 2); $x1 = $mpdf->lMargin + ($mpdf->pgwidth / 2 - $hspacing / 2 - $pw) / 2; $x2 = $mpdf->lMargin + $mpdf->pgwidth / 2 + $hspacing / 2 + ($mpdf->pgwidth / 2 - $hspacing / 2 - $pw) / 2; $y1 = $mpdf->tMargin + ($pgheight / 2 - $vspacing / 2 - $ph) / 2; $y2 = $mpdf->tMargin + $pgheight / 2 + $vspacing / 2 + ($pgheight / 2 - $vspacing / 2 - $ph) / 2; if ($i % 4 == 1) { $x = $x1; $y = $y1;