document.getElementById('kredit' + counter ).value = jumlah;
//document.getElementById('realisasi2' + counter ).value = realisasi2;
//document.getElementById('sisa2' + counter ).value = sisa2;
//document.getElementById('detail_qty').value = 1;
//document.getElementById('akunid1').value = akunid;
/*document.getElementById('detail_nakun').value = nakun;
document.getElementById('detail_jumlah').value = jumlah;
document.getElementById('detail_count').value = '1';
*/
$.fancybox.close();
}
function set_akun(counter,parent,uraian,realisasi){
tot = 0;
var pecah = parent.split(".");
var parent_pecah = pecah[0]+'.'+pecah[1]+'.'+pecah[2]+'.'+pecah[3]+'.'+pecah[4]+'.'+pecah[5]+'.0.0';
$.ajax({
type : "POST",
url : "<?php
echo base_url();
?>
index.php/jurnal_umum/getKodeAkun",
data : "parent_pecah=" + parent_pecah,
success: function(data){
//$("#parent_3").html(data);
// var parent_pecah2 = data;
//alert(data);
echo convert_rupiah_non_rp(array_sum($sum_debet) - array_sum($sum_kredit));
}
?>
</b></td>
</tr>
<tr><td colspan="6"> </td></tr>
<?php
//$get_kas_awal=$row_kas_awal->JUMLAH_KAS_AWAL;
$j = $j + 1;
foreach ($results_pendapatan->result() as $row_pendp) {
?>
<tr>
<?php
if ($row_pendp->AKUNID[0] != 0 && $row_pendp->AKUNID[1] == 0 && $row_pendp->AKUNID[2] == 0 && $row_pendp->AKUNID[3] == 0 && $row_pendp->AKUNID[4] == 0) {
echo '<td align="left" valign="middle">' . $row_pendp->AKUNID . '</td>';
} else {
if ($row_pendp->AKUNID[0] != 0 && $row_pendp->AKUNID[1] != 0 && $row_pendp->AKUNID[2] == 0 && $row_pendp->AKUNID[3] == 0 && $row_pendp->AKUNID[4] == 0) {
echo '<td align="left" valign="middle">' . $row_pendp->AKUNID . ' </td>';
} else {
if ($row_pendp->AKUNID[0] != 0 && $row_pendp->AKUNID[1] != 0 && $row_pendp->AKUNID[2] != 0 && $row_pendp->AKUNID[3] == 0 && $row_pendp->AKUNID[4] == 0) {
echo '<td align="left" valign="middle"> ' . $row_pendp->AKUNID . ' </td>';
} else {
if ($row_pendp->AKUNID[0] != 0 && $row_pendp->AKUNID[1] != 0 && $row_pendp->AKUNID[2] != 0 && $row_pendp->AKUNID[3] != 0 && $row_pendp->AKUNID[4] == 0) {
echo '<td align="left" valign="middle"> ' . $row_pendp->AKUNID . ' </td>';
} else {
if ($row_pendp->AKUNID[0] != 0 && $row_pendp->AKUNID[1] != 0 && $row_pendp->AKUNID[2] != 0 && $row_pendp->AKUNID[3] != 0 && $row_pendp->AKUNID[4] != 0) {
echo '<td align="left" valign="middle"> ' . $row_pendp->AKUNID . ' </td>';
}
<table width="666" border="1" align="center" cellpadding="1" cellspacing="1">
<tr>
<th width="158" bgcolor="#D4DFFF" scope="col">AKUNID</th>
<th width="305" bgcolor="#D4DFFF" scope="col">NAMA AKUN</th>
<th width="181" bgcolor="#D4DFFF" scope="col">KAS</th>
</tr>
<?php
foreach ($sum_kas->result() as $row) {
?>
<tr>
<td align="left" valign="top"><?php
echo $row->AKUNID;
?>
</td>
<td align="left" valign="top"><?php
echo $row->NAKUN;
?>
</td>
<td align="left" valign="top"><?php
echo convert_rupiah_non_rp($row->DEBET);
?>
</td>
</tr>
<?php
}
?>
</table>
<? echo $row->kd_spph; ?>
</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[<?echo $row->id; ?>]">
<? echo convert_rupiah_non_rp($row->nil_pelunasan) ;?>
</td>
</tr>
<?php
$i++;
}
?>
</table>
</form>
<?php
echo $this->pagination_custom_lunas->create_links();
?>
?>
<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">
<script>
var counter = 0;
$(document).ready(function(){
counter=counter+1;
$("#view"+counter).fancybox({
$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'; }
else { echo ''; }
}
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;
<? 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) ;?>
</td>
</tr>
<?php
$i++;
}
?>
</table>
</form>
<?php
echo $this->pagination_custom_lunas_batal->create_links();
?>
</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="3" div align="center"><b>KEMENTRIAN AGAMA</b></td></tr>
<tr><td colspan="3" div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN HAJI DAN UMRAH</b></td></tr>
<tr><td colspan="3" div align="center"><b>LAPORAN ARUS KAS</b></td></tr>
<tr><td colspan="3" 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="3" div align="center">(Dalam Rupiah)</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">URAIAN</th>
<th scope="col">CATATAN</th>
<th scope="col">JUMLAH</th>
</tr>
<tr>
<td>ARUS KAS DARI AKTIVITAS OPERASI</td>
?>
</td>
</tr>
</tbody>
</table>
<br>Posting Pembukuan
<table border="0" width="100%" cellpadding="0" cellspacing="0" class="display" id="transaction-table">
<thead>
<tr>
<th class="table-header-repeat line-left minwidth-1"><a href="">No</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Glid</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Tanggal</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Akun Id</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Nama AKun</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Debet</a></th>
<th class="table-header-repeat line-left minwidth-1"><a href="">Kredit</a></th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
foreach ($results->result() as $row) {
?>
<tr class="alternate-row">
<td align="left" valign="top"><?php
echo $i;
?>
</td>
<td align="left" valign="top"><?php
echo $row->glid;
<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="4" div align="center"><b>KEMENTRIAN AGAMA</b></td></tr>
<tr><td colspan="4" div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN HAJI </b></td></tr>
<tr><td colspan="4" div align="center"><b>LAPORAN NERACA</b></td></tr>
<tr><td colspan="4" 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="4" div align="center">(Dalam Rupiah)</td></tr>
<!--<tr><td colspan="10"><b>TANGGAL CETAK : <?php /* echo $this->fungsi->dateindo3('-',date('Y-m-d')) */ ?></b></td></tr>-->
<table class="laporan" width="90%" border="1">
<tr>
<th scope="col">URAIAN</th>
<th scope="col">CATATAN</th>
<!--<th scope="col">PERIODE</th>-->
<th scope="col">SALDO AKHIR RP</th>
</tr>
<tr>
<td><b>Aset</b></td>
<td></td>
<td></td>
</tr>
<?
$j=1;
foreach($results_kas->result() as $row)
{
?>
?>
</td>
<td align="left" valign="top"><?php
echo convert_date_mysql_indo($row->TANGGAL);
?>
</td>
<td align="left" valign="top"><?php
echo $row->AKUNID;
?>
</td>
<td align="left" valign="top"><?php
echo convert_rupiah_non_rp($row->DEBET);
?>
</td>
<td align="left" valign="top"><?php
echo convert_rupiah_non_rp($row->KREDIT);
?>
</td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
<!--end data detail jurnal koreksi-->
<!-- start id-form -->
<table border="0" cellpadding="0" cellspacing="0" id="id-form" width="100%">
</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>
<!--
<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" >
<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">
<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
<?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>-->
$this->pengeluaran_kas->update_posting_pengeluaran_kas($glid[$i], $data);
}
$this->list_posting();
}
function getParent_1()
{
$kirim = $this->input->post('kirim');
$pieces = explode("#", $kirim);
$tahun = $pieces[0];
$counter = $pieces[1];
$result = $this->pengeluaran_kas->get_master_akun2($tahun);
$i = 0;
echo "\r\t\t\t\t<thead>\r\t\t\t\t\t<tr>\t\t\t\t\t\t\t\t\t\t\r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-0' width='10px'><a href=''>Nomor</a></th> \r\t\t\t\t\t\t<!--<th class='table-header-repeat line-left minwidth-1'><a href=''>Parent</a></th>\t-->\r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-0'><a href=''>Kode</a></th>\t\t \t\t\t\t\t\t\r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-1'><a href=''>Uraian</a></th> \r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-1'><a href=''>Nilai</a></th>\t\t\r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-1'><a href=''>Realisasi</a></th>\t\r\t\t\t\t\t\t<th class='table-header-repeat line-left minwidth-1'><a href=''>Sisa</a></th>\t\t\t\t\t\t\t\r\t\t\t\t\t</tr>\r\t\t\t\t</thead>\r\t\t\t\t<tbody id='items'>\r\t\t\t\t</tbody>\r\t\t\t\t";
foreach ($result->result() as $row) {
$i = $i + 1;
$hasil1 = strlen(str_replace(" ", "", $row->kode));
if (preg_match("/[.]/", $row->kode) && $hasil1 == 8 && preg_match("/[0-9]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td> ";
echo " ";
echo "<b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} elseif (preg_match("/[.]/", $row->kode) && preg_match("/[0-9]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td><b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} elseif ($hasil1 == 4 && preg_match("/[0-9]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td> ";
echo "<b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} elseif ($hasil1 == 3 && preg_match("/[0-9]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td> ";
echo " ";
echo " ";
echo "<b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} elseif (preg_match("/[a-zA-Z]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td> ";
echo " ";
echo " ";
echo " ";
echo "<b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} else {
if (preg_match("/[0-9]/", $row->kode)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td> ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "<b>" . $row->kode . "</b>";
echo " </td>";
echo "<td><b>" . $row->uraian . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->jumlah) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->realisasi2) . "</b></td>";
echo "<td style='text-align:right'><b>" . convert_rupiah_non_rp($row->sisa2) . "</b></td>";
echo "</tr>";
} elseif (preg_match("/[>]/", $row->uraian) or preg_match("/[>>]/", $row->uraian)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
//echo "<td><b>".$row->kode."</b></td>";
echo "<td> ";
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "<b> > </b>";
echo " </td>";
echo "<td><i><u>" . $row->uraian . "</u></i></td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->jumlah) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->realisasi2) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->sisa2) . "</td>";
echo "</tr>";
} elseif (preg_match("/[-]/", $row->uraian)) {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
//echo "<td><b>".$row->kode."</b></td>";
echo "<td> ";
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "<b> - </b></td>";
//echo "//<td>";
//\'$row->parent\',\'$row->kode\',\'$row->uraian\',\'$row->jumlah\',\'$row->realisasi2\',\'$row->sisa2\',\'\'
$print = "<td><a href='javascript:set_barang3(\"{$row->parent}\",\"{$row->kode}\",\"{$row->uraian}\",\"{$row->jumlah}\",\"{$row->realisasi2}\",\"{$row->sisa2}\",\"" . $counter . "\")'>" . $row->uraian . "</a></td>";
echo $print;
//echo "</a></td>";
//echo "\"with quotes\" or without quotes\'asda";
//echo "asdasdasd";
//echo $row->uraian."</a></td>";
//echo "<td>".$row->uraian."</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->jumlah) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->realisasi2) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->sisa2) . "</td>";
echo "</tr>";
} else {
echo "<tr>";
echo "<td>" . $i . "</td>";
//echo "<td>".$row->parent."</td>";
echo "<td><b>" . $row->kode . "</b></td>";
echo "<td>kosong</td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td>" . $row->uraian . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->jumlah) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->realisasi2) . "</td>";
echo "<td style='text-align:right'>" . convert_rupiah_non_rp($row->sisa2) . "</td>";
echo "</tr>";
}
<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="9" div align="center"><b>KEMENTRIAN AGAMA</b></td></tr>
<tr><td colspan="9" div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN HAJI DAN UMRAH</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="9" div align="center"><b>BUKU BESAR</b></td></tr>
<tr><td colspan="9" 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="9" div align="center">(Dalam Rupiah)</td></tr>
<tr><td colspan="9" div align="center">AKUNID : <?=$akun;?> -- <?=$nakun;?> </td></tr>
<tr><td colspan="9" div align="center">aldo Awal : <?=convert_rupiah_non_rp($saldo_akun_awal);?></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">NO JURNAL</th>
<th scope="col" rowspan="2">TANGGAL</th>
<th scope="col" class="th_border" > Uraian </th>
<th scope="col" class="th_border"> Parawaba </th>
<th scope="col" class="th_border"> Kategori </th>
<th scope="col" class="th_border"> Nilai </th>
</tr>
<?php
$i = 0;
$nama_supplier = null;
$hutang[] = 0;
$sum_debet[] = 0;
$sum_kredit[] = 0;
$var_saldo = 0;
$saldo = 0;
$qty_perbrg = 0;
foreach ($results->result() as $row) {
$i = $i + 1;
?>
<tr class="border-row">
<td align="left" valign="top">
<?php
echo $i;
?>
</td>
<td align="left" valign="top">
<?php
$array_hari = array(1 => "Senin", "Selasa", "Rabu", "Kamis", "Jumat", "Sabtu", "Minggu");
$hari = $array_hari[date("N")];
$this->load->library('Lib_date');
$sekarang = $this->lib_date->mysql_to_human(date("Y-m-d"));
<!--
<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>
<?
