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;
}
<?php
appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$fmod = 'transaksi';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
//$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1,2');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.ct";
$tanggal1 = gpost('tanggal1', date("Y-m") . "-1");
$tgl = explode("-", date("Y-m-d"));
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tanggal2 = gpost('tanggal2', date("Y-m") . "-" . $dim);
$ct_jurnaldetil = gpost('ct_jurnaldetil', 1);
$ct_umum = gpost('ct_umum', 1);
$ct_pemasukan = gpost('ct_pemasukan', 1);
$ct_pengeluaran = gpost('ct_pengeluaran', 1);
$ct_siswa = gpost('ct_siswa', 1);
$ct_calonsiswa = gpost('ct_calonsiswa', 1);
$ct_barang = gpost('ct_barang', 1);
$w = "";
$sel = 0;
if ($ct_umum != 0) {
if ($w != "") {
$w .= " OR ";
}
$w .= "keu_transaksi.jenis='" . JT_UMUM . "'";
$sel++;
}
if ($ct_pemasukan != 0) {
function transaksi_posting($no,$ct,$tgl,$urai,$jur,$jt=JT_UMUM,$kat=0){
$tid=0;
$n=count($jur);
if($n>0){
$trans=array();
$trans['tahunbuku']=tahunbuku_getaktifid();
$trans['nomer']=$no;
$trans['tanggal']=$tgl;
$trans['uraian']=$urai;
//$trans['rekkas']=$rekkas;
//$trans['rekitem']=$rekitem;
//$trans['modul']=$mod;
$trans['kategori']=$kat;
$trans['jenis']=$jt;
$trans['ct']=$ct;
$trans['nominal']=0;
for($i=0;$i<$n;$i++){
$jurnal=$jur[$i];
$trans['nominal']+=$jurnal['debet'];
//log_print("dapat debet:".$jurnal['debet']);
}
if(dbInsert("keu_transaksi",$trans)){
$tid=mysql_insert_id();
for($i=0;$i<$n;$i++){
$jurnal=$jur[$i];
$jurnal['transaksi']=$tid;
$q=dbInsert("keu_jurnal",$jurnal);
if($jurnal['debet']!=0){
transaksi_saldo('in',$jurnal['rek'],'',$jurnal['debet']);
}
}
}
}transaksi_cekpembayaran($tid);
return $tid;
}
