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> <?