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