/**
* 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;
