function budget_opt($s=1,$i=0){
$tbuku=tahunbuku_getaktifid();
$res=Array();
if($s==1)$res[0]='';
$sql="SELECT * FROM keu_budget WHERE tahunbuku='$tbuku' ORDER BY nama";
$t=mysql_query($sql); while($r=mysql_fetch_array($t)){
$sisa=budget_getnominal($r['replid'])-budget_getuses($r['replid']);
$res[$r['replid']]=$r['nama'].($i!=1?'':' (sisa anggaran: '.fRp($sisa).')');
}
return $res;
}
$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>';
$s .= '<div style="width:480px;height:6px;border:1px solid #01a8f7;border-radius:3px">';
$s .= '<div style="width:' . $bar . 'px;height:6px;background:' . $clr . '"></div>';
$s .= '</div>';
$s .= '<div class="sfont" style="width:480px;height:18px;padding:1px;padding-top:6px;text-align:left' . ($sisa < 0 ? ';color:#ff0000' : '') . '">';
$s .= '<span style="float:left">terpakai: <b>' . fRp($uses) . '</b> ( ' . number_format($uses * 100 / $r['nominal'], 2) . '% )</span>';
$s .= '<span style="float:right">sisa anggaran: <b>' . fRp($sisa, 1, 1) . '</b> ( ' . number_format($sisa * 100 / $r['nominal'], 2) . '% )</span>';
$s .= '</div>';
$xtable->td($s, 484, 'r');
$xtable->td(nl2br($r['keterangan']));
$s = '<button title="Daftar transaksi" class="btn"><div class="bi_lisb"> </div></button>';
$xtable->opt($r['replid'], 'u', 'd');
<?php
appmod_use('keu/budget');
$budget = gpost('budget');
if ($budget != 0) {
$sisa = budget_getnominal($budget) - budget_getuses($budget);
echo $sisa;
} else {
echo "x";
}
