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