<?php appmod_use('keu/budget'); $fmod = 'budget'; $xtable = new xtable($fmod, 'anggaran'); $tahunbuku = tahunbuku_getaktif(); $tbuku = $tahunbuku['replid']; if ($tbuku != 0) { // Page Selection Bar $PSBar = new PSBar_2(140); $PSBar->begin(); $PSBar->selection('Tahun buku', '<b>' . $tahunbuku['nama'] . '</b>'); hiddenval('tahunbuku', $tahunbuku['replid']); $PSBar->end(); $xtable->btnbar_f('add'); // Query $db = new xdb("keu_budget", "*", "tahunbuku='{$tbuku}'", "nama"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { // Table head $xtable->head('Nama Anggarang', 'Anggaran', 'Status anggaran', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nama'], 200); $xtable->td(fRp($r['nominal']), 110); $uses = budget_getuses($r['replid']); $sisa = $r['nominal'] - $uses; $clr = color_level($r['nominal'], $sisa < 0 ? $r['nominal'] : $uses); $bar = $sisa < 0 ? 480 : intval($uses * 480 / $r['nominal']); $s = '<div class="sfont" style="width:480px;height:20px;padding:1px;text-align:left"><span style="float:left">Total anggaran: <b>' . fRp($r['nominal']) . '</b></span></div>';
<?php appmod_use('keu/rekening'); $bukutahun = tahunbuku_getaktif(); $tahunbuku = tahunbuku_getaktifid(); $saldo_awal = tahunbuku_getsaldoawal(); echo '<div id="tabelrekx" style="display:">'; $xtable = new xtable($fmod); $xtable->noopt = true; $xtable->tbl_width = '1000px'; $xtable->tbl_style = 'float:left;margin-bottom:30px'; $xtable->row_strip = false; $xtable->usepaggging = false; $xtable->cari = 0; $db = new xdb("keu_jurnal"); $db->field("keu_jurnal:*", "keu_rekening:kode as koderek,nama as nrek", "keu_transaksi:tanggal,nomer,uraian"); $db->join("transaksi", "keu_transaksi"); $db->join("rek", "keu_rekening"); $db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'"); $db->where_and("keu_rekening.kategorirek='1'"); $db->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); echo '<div class="sfont" style="font-size:13px;float:left;width:1000px;text-align:left;margin-top:20px;margin-bottom:20px;text-align:center">Tahun Buku: ' . $bukutahun['nama'] . '</div>'; if ($xtable->ndata > 0) { // echo '<div class="sfont" style="font-size:13px;float:left;width:800px;text-align:left;margin-bottom:4px">['.$jd['koderek'].'] '.$jd['nrek'].'</div>'; // Table head $xtable->head('Tanggal', 'Kode Rekening{C,70px}', 'Nama Perkiraan', 'Nomor Transaksi{70px}', 'Uraian', 'Debet{R,100px}', 'Kredit{R,100px}'); $debet = 0; $kredit = 0; while ($r = mysql_fetch_array($t)) {
function transaksi_newnomer($jt=JT_UMUM){ $kode=transaksi_kodejt($jt); $tb=tahunbuku_getaktif(); $ct=transaksi_lastct()+1; $res=array(); //$res['nomer']=$tb['kode'].sprintf("%05d",$ct); $res['nomer']=$kode.'-'.sprintf("%04d",$ct).'/'.date("m").'/'.date("Y"); $res['ct']=$ct; return $res; }