<th class="table-header-repeat line-left minwidth-1"><a href="">Aksi</a></th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$j = 0;
foreach ($results->result() as $row) {
?>
<tr class="alternate-row">
<td align="left" valign="top"><?php
echo $row->glid;
?>
</td>
<td align="left" valign="top"><?php
echo convert_date_mysql_indo($row->tanggal);
?>
</td>
<td align="left" valign="top"><?php
echo $row->nama;
?>
</td>
<td align="left" valign="top"><?php
echo convert_rupiah_non_rp($row->jumlah);
?>
</td>
<td align="left" valign="top"><?php
echo $row->ket_transaksi;
?>
</td>
<td align="left" valign="top">
<textarea rows="2" cols="100" id="area" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="area2" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="subtotal" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="subtotal2" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="send" style="display:none ;"></textarea>
<table>
<tr>
<td>
<select id="bank" name="bank" class="inp-form2">
<option value="0">Pilih bank...</option>
<?php $i=0; foreach($bank->result() as $row) {$i++;?>
<option value="<?php echo $row->bank;?>" <?php if ($bankselect == $row->bank) {echo "selected";}?>><?php echo $row->bank;?></option>
<?php } ?>
</select>
</td>
<td>
<select id="year" name="year" class="inp-form2">
<option value="0">Pilih tahun...</option>
<?php $i=0; foreach($year->result() as $row) {$i++;?>
<option value="<?php echo $row->year;?>" <?php if ($yearselect == $row->year) {echo "selected";}?>><?php echo $row->year;?></option>
<?php } ?>
</select>
</td>
<td>
<input type="text" name="no_porsi" id="no_porsi" value="<?=$no_porsiselect?>" placeholder="Nomor Porsi" class="inp-form">
</td>
<td>
<a onclick="javascript:change_content2();">
<button class="form-submit" id="send" name="send" type="submit">
Filter
echo $var_php;
*/
$i = 0;
foreach ($result->result() as $row) {
?>
<tr>
<td align="left" valign="middle" id="cheks[<?echo $row->id; ?>]">
<input type="checkbox" id="chek[<?echo $row->id; ?>]" name="chek[<?echo $row->id; ?>]" onchange="save_data(<?echo $row->id; ?>);" > </input>
</td>
<td align="left" valign="middle" id="no_porsi[<?echo $row->id; ?>]">
<? echo $row->no_porsi; ?>
</td>
<td align="left" valign="middle" id="tgl_setor[<?echo $row->id; ?>]">
<? echo convert_date_mysql_indo($row->tgl_setor);?>
</td>
<td align="left" valign="middle" id="bps[<?echo $row->id; ?>]">
<? echo $row->bps ;?>
</td>
<td align="left" valign="middle" id="na_calhaj[<?echo $row->id; ?>]">
<? echo $row->na_calhaj ;?>
</td>
<td align="left" valign="middle" id="alt_calhaj[<?echo $row->id; ?>]">
<? echo $row->alt_calhaj ;?>
</td>
<td align="left" valign="middle" id="nil_setor_awal[<?echo $row->id; ?>]">
<? echo convert_rupiah_non_rp($row->nil_setor_awal) ;?>
</td>
<td align="left" valign="middle" id="nil_setor[<?echo $row->id; ?>]">
<? echo convert_rupiah_non_rp($row->nil_setor) ;?>
?>
<tr class="alternate-row">
<td align="left" valign="top"><?php
echo $i + $param3;
?>
</td>
<td align="left" valign="top"><?php
echo $row->GLID;
?>
</td>
<td align="left" valign="top"><?php
echo $row->GLID_PARENT;
?>
</td>
<td align="left" valign="top"><?php
echo convert_date_mysql_indo($row->TANGGAL);
?>
</td>
<td align="right" valign="top"><?php
echo convert_rupiah_non_rp($row->jumlah);
?>
</td>
<td align="left" valign="top"><?php
echo $row->KETERANGAN;
?>
</td>
<td align="left" valign="top">
<?php
echo anchor('pembatalan_sa/detail_pembatalan_sa_list/' . $row->GLID . '/' . $row->GLID_PARENT, '[detail]', array('class' => 'with-tip view', 'id' => 'view'));
?>
</td>
<!--
<script type="text/javascript" src="<?=base_url()?>asset/admin/js/jquery-1.4.2.min.js"></script>
-->
<script type="text/javascript">
$(document).ready(function(){
$("#propinsi").change(function(){
var propinsi = $("#propinsi").val();
$.ajax({
type : "POST",
url : "<?php echo base_url(); ?>index.php/penerimaan_sa/getKota",
data : "propinsi=" + propinsi,
success: function(data){
$("#kota").html(data);
}
});
});
});
</script>
<textarea rows="2" cols="100" id="area" style="display:none;"></textarea>
<textarea rows="2" cols="100" id="area2" style="display:none;"></textarea>
<textarea rows="2" cols="100" id="subtotal" style="display:none;"></textarea>
<textarea rows="2" cols="100" id="subtotal2" style="display:none;"></textarea>
<textarea rows="2" cols="100" id="send" style="display:none;"></textarea>
<table>
<tr>
<td>
<select id="bank" name="bank" class="inp-form2" style="display:none">
<option value="0">Pilih bank...</option>
<?php $i=0; foreach($bank->result() as $row) {$i++;?>
<option value="<?php echo $row->bank;?>" <?php if ($bankselect == $row->bank) {echo "selected";}?>><?php echo $row->bank;?></option>
<?php ini_set("memory_limit","32M"); ?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15">
<style>
#div_laporan{
margin:0 auto;
}
table.laporan {
border-spacing: 0;
margin:0 auto;
font-size: 0.8em;
font-family: sans-serif;
}
tr.border,th.th_border,td.use_border {
border:0.5px solid #ccc;
padding:2pt;
}
</style>
<div id="div_laporan" align="center">
<table class="laporan" width="90%" border="1">
<tr><td colspan="5" div align="center"><b>KEMENTRIAN KOMUNIKASI DAN INFORMATIKA</b></td></tr>
<tr><td colspan="5" div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN POS DAN INFORMATIKA</b></td></tr>
<tr><td colspan="5" div align="center"><b>BALAI PENYEDIA DAN PENGELOLA PEMBIAYAAN TELEKOMUNIKASI DAN INFORMATIKA</b><br/></td></tr>
<tr><td colspan="5" div align="center"><b>BUKU BESAR</b></td></tr>
<tr><td colspan="5" div align="center"><b>Per : <?php echo $this->fungsi->dateindo3('-',$periode_awal) . ' S/D ' . $this->fungsi->dateindo3('-',$periode_akhir); ?></b></td></tr>
<tr><td colspan="5" div align="center">(Dalam Rupiah)</td></tr>
<tr><td colspan="5" div align="center">AKUNID <?=$akun;?></td></tr>
<!--<tr><td colspan="10"><b>TANGGAL CETAK : <?php /* echo $this->fungsi->dateindo3('-',date('Y-m-d')) */ ?></b></td></tr>-->
<th class="table-header-repeat line-left minwidth-1" >NAMA AKUN</th>
<th class="table-header-repeat line-left minwidth-1" >DEBET</th>
<th class="table-header-repeat line-left minwidth-1" >KREDIT</th>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($akunid); $i++) {
?>
<tr>
<td><?php
echo $glid . '<input type="hidden" name="glid" value="' . $glid . '">';
?>
</td>
<td><?php
echo convert_date_mysql_indo($tanggal) . '<input type="hidden" name="tanggal" value="' . $tanggal . '">';
?>
</td>
<td><?php
echo $akunid[$i] . '<input type="hidden" name="akunid[]" value="' . $akunid[$i] . '">';
?>
</td>
<td><?php
echo $nakun[$i];
?>
</td>
<td><?php
echo $debet[$i] . '<input type="hidden" name="debet[]" value="' . $debet[$i] . '">';
?>
</td>
<td><?php
<?php ini_set("memory_limit","32M"); ?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15">
<style>
#div_laporan{
margin:0 auto;
}
table.laporan {
border-spacing: 0;
margin:0 auto;
font-size: 0.8em;
font-family: sans-serif;
}
tr.border,th.th_border,td.use_border {
border:0.5px solid #ccc;
padding:2pt;
}
</style>
<div id="div_laporan" align="center">
<table class="laporan" >
<tr><td colspan="7" align="left"><b>SAWERI GADING CELL</b></td></tr>
<tr><td colspan="7" align="left"><b>JL. S PARMAN 18 BANYUWANGI</b></td></tr>
<tr><td colspan="7" align="left"><b>TELP (0333)-411345</b></td></tr>
<tr><td colspan="7" align="left"><b></b><br/></td></tr>
<tr><td colspan="7" div align="center"><b>LAPORAN Laba Rugi</b></td></tr>
<tr><td colspan="7" align="left"><b>PERIODE : <?php echo $periode_awal.' S/D '.$periode_akhir ?></b></td></tr>
<tr><td colspan="7" align="left"><b>TANGGAL CETAK : <?php echo $date_now; ?></b></td></tr>
<tr class="border">
}
function get_detail_calon_haji_pusat_id($id, $glid1, $glid2, $glid3)
{
$glid = $glid1 . '/' . $glid2 . '/' . $glid3;
$result = $this->calon_haji->get_detail_calon_haji_pusat($glid);
$data = "";
foreach ($result->result() as $row) {
$data .= "{$row->id}|{$row->no_porsi}|";
$data .= convert_date_mysql_indo($row->tgl_setor);
$data .= "|{$row->bps}|{$row->na_calhaj}|{$row->alt_calhaj}|";
$data .= convert_rupiah_non_rp($row->nil_setor);
$data .= "|~";
}
echo $data;
</script>
<div id="tab-settings" class="tabs-content">
<button type="button" onclick="report_pdf()"><img src="<?=base_url()?>asset/admin/images/icons/fugue/tick-circle.png" width="16" height="16">REKAP PDF</button>
<button type="submit" onclick="report_excel()"><img src="<?=base_url()?>asset/admin/images/icons/fugue/tick-circle.png" width="16" height="16">REKAP EXCEL</button>
</div>
<?php
$attributes = array('class' => 'formccs', 'id' => 'myform', 'name'=> 'myform');
echo form_open('laporan_buku_kas/report_excel', $attributes);
?>
<div id="div_laporan">
<input name="rekap_tabel1" id="rekap_tabel1" type="hidden" value="rekap_tabel1" />
<input name="periode_awal" id="tanggal_awal" type="hidden" value="<?=$periode_awal;?>" />
<input name="periode_akhir" id="tanggal_akhir" type="hidden" value="<?=$periode_akhir;?>" />
<table class="laporan" width="90%" border="1">
<tr><td colspan="5" div align="center"><b>KEMENTRIAN KOMUNIKASI DAN INFORMATIKA</b></td></tr>
<tr><td colspan="5" div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN POS DAN INFORMATIKA</b></td></tr>
<tr><td colspan="5" div align="center"><b>BALAI PENYEDIA DAN PENGELOLA PEMBIAYAAN TELEKOMUNIKASI DAN INFORMATIKA</b><br/></td></tr>
<tr><td colspan="5" div align="center"><b>BUKU BESAR</b></td></tr>
<tr><td colspan="5" div align="center"><b>Per : <?php echo $this->fungsi->dateindo3('-',$periode_awal) . ' S/D ' . $this->fungsi->dateindo3('-',$periode_akhir); ?></b></td></tr>
<tr><td colspan="5" div align="center">(Dalam Rupiah)</td></tr>
<tr><td colspan="5" div align="center">AKUNID <?=$akun;?></td></tr>
<!--<tr><td colspan="10"><b>TANGGAL CETAK : <?php /* echo $this->fungsi->dateindo3('-',date('Y-m-d')) */ ?></b></td></tr>-->
<tr>
<th scope="col" rowspan="2">URAIAN</th>
<th scope="col" rowspan="2">CATATAN</th>
<th scope="col" rowspan="2">PERIODE</th>
<th scope="col" colspan="2">KENAIKAN (PENURUNAN)</th>
<tr>
<?php
$i = 1;
$j = 0;
foreach ($results->result() as $row) {
?>
<tr class="alternate-row">
<td align="left" valign="top"><?php
echo $i + $param3;
?>
</td>
<td align="left" valign="top"><? if ($row->na_calhaj) { echo $row->na_calhaj; } else {}?> </td>
<td align="left" valign="top"><? if ($row->tgl_setor) { echo convert_date_mysql_indo($row->tgl_setor); } else {}?> </td>
<td align="right" valign="top"><? if ($row->nil_setor) { echo convert_rupiah_non_rp($row->nil_setor); } else {}?> </td>
<td align="right" valign="top"><? if ($row->v_union_no_porsi) { echo $row->v_union_no_porsi; } else {}?> </td>
<td align="left" valign="top"><? if ($row->nama_bank) { echo $row->nama_bank; } else {}?> </td>
<td align="left" valign="top"><? if ($row->tanggal_bank) { echo convert_date_mysql_indo($row->tanggal_bank); } else {}?> </td>
<td align="right" valign="top"><? if ($row->jumlah_bank) { echo convert_rupiah_non_rp($row->jumlah_bank); } else {}?> </td>
<!--
<td align="center" valign="top"><? if ($row->status_setor_awal) { echo '<img src="'.base_url().'asset/admin/images/icons/true.png" width ="15" height="15" alt="" />'; } else {echo '<img src="'.base_url().'asset/admin/images/icons/false.png" width ="15" height="15" alt="" />';}?> </td>
<td align="center" valign="top"><? if ($row->status_penerimaan == 'Lunas') { echo '<img src="'.base_url().'asset/admin/images/icons/true.png" width ="15" height="15" alt="" />'; } else {echo '<img src="'.base_url().'asset/admin/images/icons/false.png" width ="15" height="15" alt="" />';}?> </td>
<td align="center" valign="top"><? if ($row->status_penerimaan == 'Lunas Tunda') { echo '<img src="'.base_url().'asset/admin/images/icons/true.png" width ="15" height="15" alt="" />'; } else {echo '<img src="'.base_url().'asset/admin/images/icons/false.png" width ="15" height="15" alt="" />';}?> </td>
<td align="center" valign="top"><? if ($row->status_penerimaan) { echo $row->status_penerimaan;} else {echo '';}?> </td>
-->
<td align="center" valign="top">
<?
$glid=substr($row->glid,1,4);
if ($glid == 'BSLT') { echo 'Lunas Tunda'; }
else if ($glid == 'BSL/') { echo 'Lunas'; }
else if ($glid == 'BSA/') { echo 'Awal'; }
<!--
<script type="text/javascript" src="<?=base_url()?>asset/admin/js/jquery-1.4.2.min.js"></script>
-->
<textarea rows="2" cols="100" id="area" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="area2" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="subtotal" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="subtotal2" style="display:none ;"></textarea>
<textarea rows="2" cols="100" id="send" style="display:none ;"></textarea>
<table>
<tr>
<td>
<select id="bank" name="bank" class="inp-form2">
<option value="0">Pilih bank...</option>
<?php $i=0; foreach($bank->result() as $row) {$i++;?>
<option value="<?php echo $row->id_bank;?>" <?php if ($bankselect == $row->id_bank) {echo "selected";}?>><?php echo $row->nama_bank;?></option>
<?php } ?>
</select>
</td>
<td>
<select id="year" name="year" class="inp-form2">
<option value="0">Pilih tahun...</option>
<?php
date('Y');
$year = array();
for($i=0; $i<=15; $i++)
{
$year['year'][$i] = date('Y') - $i;
?>
<option value="<?php echo $year['year'][$i];?>" <?php if ($yearselect == $year['year'][$i]) {echo "selected";}?>><?php echo $year['year'][$i];?></option>
<?