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;
}
function iTextC($d='',$v='',$s='',$p='',$cb='',$at=''){ $bc=""; $bc2="";
if($cb!=""){$n=preg_match("/onblur=\".+\"/", $cb,$m);
if($n>0){
$bc=str_replace("\"","",$m[0]);
$bc=";".str_replace("onblur=","",$bc);
$cb=str_replace($m[0],"",$cb);
}}
if($cb!=""){$n=preg_match("/onfocus=\".+\"/", $cb,$m);
if($n>0){
$bc2=str_replace("\"","",$m[0]);
$bc2=";".str_replace("onfocus=","",$bc2);
$cb=str_replace($m[0],"",$cb);
}}
if(is_array($v)) $v=$v[$d];
if(!is_numeric($v)) $v=0;
if($p==''){
if(defined('ITEXTC_SHOW_NUL')){
if(ITEXTC_SHOW_NUL==0) $p='Rp';
}
}
return "<input type=\"text\" class=\"iText\"".(($d=="")?"":" id=\"".$d."\" name=\"".$d."\" ").(($s=="")?"style=\"width:150px\"":" style=\"".$s."\" ")." value=\"".fRp($v)."\" ".(($p=="")?"":" placeholder=\"".$p."\" ").($cb==""?"":" ".$cb." ").($at==""?"":" ".$at." ")."onfocus=\"this.className='iTextx';ufRpt(this);".$bc2."\" onblur=\"this.className='iText';fRpt(this)".$bc."\"/>";
}
$xtable->btnbar_add();
} else {
echo '<div class="infobox" style="float:left;margin-left:40px">Kuota periode pendaftaran ini telah penuh.</div>';
}
$xtable->btnbar_print();
$xtable->search_box();
$xtable->btnbar_end();
if ($xtable->ndata > 0) {
$xtable->head_addrow('@Nomor pendaftaran{2,100px}', '@Nama{2}', 'Uang pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}');
$xtable->head_addrow('Subsidi{R}', 'Saudara{R}', 'Tunai{R}', '!x bulan{R}');
$xtable->head_multi();
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 100);
$xtable->td($r['nama']);
$xtable->td(fRp($r['sumpokok']), 90, 'r');
$xtable->td(fRp($r['disctb']), 90, 'r');
$xtable->td(fRp($r['discsaudara']), 90, 'r');
$xtable->td(fRp($r['disctunai']), 90, 'r');
$xtable->td(fRp($r['denda']), 90, 'r');
$xtable->td(fRp($r['sumnet']), 90, 'r');
$xtable->td(fRp($r['angsuran']) . '<br/>x ' . $r['jmlangsur'] . ' bulan', 90, 'r');
$xtable->opt($r['replid'], 'v', 'u', 'd');
$xtable->row_end();
}
$xtable->foot();
}
}
} else {
departemen_warn(1);
}
$tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">';
$tglSearch .= '<div class="">Tampilkan »</div>';
$tglSearch .= '</button>';
$t .= $tglSearch;
$t .= '</div>';
$xtable->btnbar_f('print', 'srcbox', $t . '<br>', $s);
hiddenval('modul', $modid);
hiddenval('pembayaran', 0);
if ($xtable->ndata > 0) {
$xtable->head('@No pendaftaran', '@Nama', 'Biaya pendaftaran{R}', 'Jumlah dibayar{R}', '@Tanggal pembayaran', '@Status');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 120);
$xtable->td($r['nama']);
$xtable->td(fRp($r['nominal']), 110, 'r');
$xtable->td(fRp($r['jmlbayar']), 110, 'r');
if ($r['lunas'] == '1') {
$s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>';
} else {
$s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>';
}
$xtable->td(fftgl($r['tglbayar']), 140);
$xtable->td($s, 110, 'c');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ditemukan data pembayaran.');
}
// End of Tabel transaksi
} else {
?>
</div>
<?php
notifbox();
if ($xtable->ndata > 0) {
// Table head
$xtable->head(' ', 'Kelompok', 'tanggal pendaftaran~C', 'Biaya pendaftaran{R}', 'Calon Siswa~C', 'Siswa Diterima~C', 'Keterangan');
$k = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'");
$n = mysql_num_rows($q);
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0");
$n1 = mysql_num_rows($q);
$xtable->td('<div style="margin:auto;width:14px;height:14px;background:' . $bcolor[$k++] . '"></div>', 20, 'c');
$xtable->td($r['kelompok'], 300);
$xtable->td(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 180, 'c');
$xtable->td(fRp($r['biaya']), 120, 'r');
$xtable->td($n, 100, 'c');
$xtable->td($n1, 100, 'c');
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
} else {
departemen_warn(1);
}
$aktiva = 0;
$pasiva = 0;
// Aktiva
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Aktiva :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekaktiva as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekaktiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekaktiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$aktiva += $rekaktiva[$rek]['nominal'];
}
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Aktiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($aktiva, 1, 1, 1) . '</b></td>', '</tr>';
echo '<tr height="10px">', '<td></td>', '<td></td>', '<td></td>', '</tr>';
// pasiva
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Pasiva :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekpasiva as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekpasiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekpasiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$pasiva += $rekpasiva[$rek]['nominal'];
}
echo '<tr height="20px">', '<td style="font-size:11px" >Laba bersih</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($lababersih, 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$pasiva += $lababersih;
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total pasiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($pasiva, 1, 1, 1) . '</b></td>', '</tr>';
echo '</table>';
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
$xtable->td(fRp($kredit, 0), 100, 'r', $s);
$xtable->row_end();
$saldo = $saldo_awal + $debet - $kredit;
//$saldo=$saldo<0?-$saldo:$saldo;
$xtable->row_begin();
$s = '';
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('SALDO AWAL', '', '', $s);
$xtable->td(fRp($saldo_awal, 0), 100, 'r', $s);
$xtable->td('', 100, 'r', $s);
$xtable->row_end();
$xtable->row_begin();
$s = '';
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('SALDO AKHIR', '', '', $s);
if ($saldo < 0) {
$xtable->td('<span style="color:#ff0000">(' . fRp(-$saldo, 0) . ')</span>', 100, 'r', $s);
} else {
$xtable->td(fRp($saldo, 0), 100, 'r', $s);
}
$xtable->td('', 100, 'r', $s);
$xtable->row_end();
$xtable->foot();
}
echo '</div>';
$beban = 0;
// Pendapatan
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Pendapatan :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekpendapatan as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekpendapatan[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekpendapatan[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$pendapatan += $rekpendapatan[$rek]['nominal'];
}
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Pendapatan:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($pendapatan, 1, 1, 1) . '</td>', '</tr>';
echo '<tr height="10px">', '<td></td>', '<td></td>', '<td></td>', '</tr>';
// Beban
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Beban :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekbeban as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekbeban[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekbeban[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$beban += $rekbeban[$rek]['nominal'];
}
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Beban:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($beban, 1, 1, 1) . '</td>', '</tr>';
echo '<tr height="10px">', '<td></td>', '<td></td>', '<td><div style="margin-top:4px;padding-top:4px;margin-left:10px;width:110px;border-top:1px solid #666"></div></td>', '</tr>';
$lababersih = $pendapatan - $beban;
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i><b>Laba Bersih:</b></i></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($lababersih, 1, 1, 1) . '</b></td>', '</tr>';
echo '</table>';
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
// $xtable->row_begin();
$xtable->row_begin($r['replid']);
$t2 = dbQSql("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'");
$r2 = dbFA($t2);
$dibayar = 0;
$t3 = dbQSql("SELECT * FROM keu_transaksi WHERE pembayaran='" . $r2['replid'] . "'");
while ($r3 = dbFA($t3)) {
$dibayar += $r3['nominal'];
// print_r($r3);exit();
}
if ($fid == 0) {
$fid = $r['replid'];
}
$xtable->td($r['nis'], 40);
$xtable->td($r['nama']);
$xtable->td(fRp($r2['nominal'] - $dibayar), 80, 'r');
if (admin_isoperator()) {
$s = '<button class="btn" title="Proses" onclick="E(\'siswa\').value=' . $r['replid'] . ';pembayaran_proses_get()"><div class="bi_arrow2b"> </div></button>~36px';
} else {
$s = '<div style="height:23px;width:36px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data siswa.');
}
$xform->table_end(0);
hiddenval('siswa_list_num', $xtable->ndata);
hiddenval('siswa_list_firstid', $fid);
?>
</td></tr>
<tr height="24px"><td width="100px">Total aset:</td><td><?php
echo fRp(grup_aset($grup));
?>
</td></tr>
</table>
</div>
<?php
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@kode', '@nama barang', 'jenis', 'Jumlah unit~R', 'Aset~R', 'penyusutan<br/>per tahun~R', 'keterangan', '{40px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='" . $r['replid'] . "'"));
$xtable->td($r['kode'], 80);
$xtable->td($r['nama'], 200);
$xtable->td(jenis_name($r['jenis']), 200);
$xtable->td($n, 80, 'r');
$xtable->td(fRp(katalog_aset($r['replid'])), 100, 'r');
$xtable->td($r['susut'] . ' %', 120, 'r');
$xtable->td(nl2br($r['keterangan']));
$xtable->opt($r['replid'], 'v');
//'<button class="btn" title="Tambah unit barang baru." onclick="katalog_unit_add(\'<id>\')"><div class="bi_add">Unit</div></button>~50');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
from
keu_jurnal kj,
keu_rekening kr
where
kj.rek=kr.replid and
kj.transaksi=' . $res['replid'] . '
order by
kj.kredit asc';
$exe2 = mysql_query($sql2);
$out .= '<table class="isi" >';
while ($res2 = mysql_fetch_assoc($exe2)) {
$out .= '<tr>
<td width="200px">' . $res2['nama'] . '</td>
<td width="60px">' . $res2['kode'] . '</td>
<td width="80px">' . fRp($res2['debet']) . '</td>
<td width="80px">' . fRp($res2['kredit']) . '</td>
</tr>';
}
$out .= '</table>';
// end of detil jurnal --------
$out .= '</td>';
$out .= '</tr>';
$nox++;
}
}
$out .= '</table><br>';
echo $out;
#generate html -> PDF ------------
$out2 = ob_get_contents();
ob_end_clean();
$mpdf = new mPDF('c', 'A4', '');
}
?>
<input type="hidden" id="<?php
echo 'tbiaya' . $r['replid'] . '_' . $h['replid'];
?>
" value="<?php
echo $biaya;
?>
" />
</td>
<td width="150px" align="right">
<?php
if (admin_isoperator()) {
echo iTextC('spp' . $r['replid'] . '_' . $h['replid'], $spp, 'float:right;width:150px;text-align:right');
} else {
echo fRp($spp);
}
?>
<input type="hidden" id="<?php
echo 'tspp' . $r['replid'] . '_' . $h['replid'];
?>
" value="<?php
echo $spp;
?>
" />
</td>
</tr>
<?php
$tfield .= '~biaya' . $r['replid'] . '_' . $h['replid'];
$tfield2 .= '~spp' . $r['replid'] . '_' . $h['replid'];
$tfield3 .= '~daftar' . $r['replid'] . '_' . $h['replid'];
$xtable->td('<b>' . fRp($debet, 0) . '</b>', 100, 'r', $s);
$xtable->td('<b>' . fRp($kredit, 0) . '</b>', 100, 'r', $s);
$xtable->row_end();
$saldo = $debet - $kredit;
$saldo = $saldo < 0 ? -$saldo : $saldo;
$xtable->row_begin();
$xtable->td();
$xtable->td();
$xtable->td();
$xtable->td();
if ($debet >= $kredit) {
$xtable->td('<b>' . fRp($saldo, 0) . '</b>', 100, 'r');
$xtable->td();
} else {
$xtable->td();
$xtable->td('<b>' . fRp($saldo, 0) . '</b>', 100, 'r');
}
$xtable->row_end();
$xtable->foot();
}
echo '</div>';
}
} else {
$xtable = new xtable($fmod);
$xtable->btnbar_begin();
echo '<div style="visibility:hidden">';
$xtable->search_box();
echo '</div>';
$xtable->btnbar_end();
$xtable->nodata_cust('Tidak data transaksi.');
}
<?php
require_once MODDIR . 'xform/xform.php';
require_once MODDIR . 'control.php';
appmod_use('aka/tahunajaran', 'aka/tingkat', 'aka/kelas', 'aka/siswa');
$modul = gpost('modul');
$reftipe = gpost('reftipe');
$refid = gpost('refid');
$siswaid = gpost('siswa', 0);
$pemb = pembayaran_getdatabysubj($modul, $siswaid);
hiddenval('pembayaran', $pemb['replid']);
$db = siswa_db_byID($siswa);
$t = $db->query();
$siswa = mysql_fetch_array($t);
$fmod = 'pembayaran_data';
$xform = new xform($fmod);
$xform->table_begin();
$xform->col_begin();
$s = '<button title="Edit data pembayaran" onclick="pembayaran_data_form(\'uf\',' . $pemb['replid'] . ')" style="float:left;margin-left:100px" class="btn"><div class="bi_edit">Edit</div></button>';
$xform->group_begin('Pembayaran yang harus dilunasi ', 100, 150);
echo '<div class="xrowl"><div class="xlabel" style="width:100px">Pembayaran:</div><div class="xlabel" style="position:relative;height:20px;width:px">' . $pemb['modul']['nama'] . '<div style="position:absolute;top:-32px;right:-80px">' . $s . '</div></div></div>';
$xform->fl('Jml pembayaran', fRp($pemb['nominal']));
$xform->fl('Besar cicilan', fRp($pemb['cicilan']));
$xform->fl('Status', $pemb['lunas'] == 1 ? '<span style="color:#00a000"><b>Lunas</b></span>' : '<span style="color:#ff8000"><b>Belum lunas</b></span>');
if ($pemb['keterangan'] != '') {
echo '<div class="xrowl" style="margin-top:4px"><div class="infobox" style="float:left;width:100%">Perubahan terakhir pada ' . fftgl($pemb['tanggal']) . '. Keterangan: <i style="float:none !important">' . $pemb['keterangan'] . '.</i></div></div>';
}
$xform->table_end(0);
<?php
$fmod = 'discount';
$xtable = new xtable($fmod);
$xtable->btnbar_f('add');
// Query
$t = mysql_query("SELECT * FROM psb_disctunai ORDER BY nilai");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Diskon (%)~C', 'Diskon (Tunai)~C', 'Keterangan~C');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nilai'], 100, 'c');
$xtable->td(fRp($r['nilai2']), 100);
// $xtable->td($r['nilai2']);
$xtable->td($r['keterangan']);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
$xtable->row_begin();
$xtable->td('<i>Tidak ada data.</i>', 80, '', 'colspan="4"');
$xtable->row_end();
}
$xtable->row_begin();
$s = 'style="border-top:2px solid #88d9ff"';
$xtable->td('Jumlah Pengeluaran</b>', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('' . ($kredit > 0 ? fRp($kredit, 0) : 0) . '', 100, 'r', $s);
$xtable->row_end();
$xtable->foot();
$saldo_awal = $saldo_awal + $debet - $kredit;
echo '<div class="sfont" style="background:#f0f0f0;font-size:13px;float:left;width:800px;text-align:left;margin-bottom:10px">';
//echo '<div style="float:left">['.$jd['koderek'].'] '.$jd['nrek'].'</div>';
echo '<div style="float:right;margin:2px;">Saldo Akhir: ' . ($saldo_awal > 0 ? fRp($saldo_awal) : 'Rp 0') . '</div>';
echo '</div>';
echo '</div>';
}
} else {
$xtable = new xtable($fmod);
$xtable->btnbar_begin();
echo '<div style="visibility:hidden">';
$xtable->search_box();
echo '</div>';
$xtable->btnbar_end();
$xtable->nodata_cust('Tidak data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
$fmod = 'tahunbuku';
$xtable = new xtable($fmod, 'tahun buku');
$xtable->btnbar_f('add');
// Query data
$sql = "SELECT * FROM keu_tahunbuku";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Tahun Buku', 'tanggal mulai', 'Saldo awal{R}', 'Keterangan', 'Status{C}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nama'], 200);
//$xtable->td($r['kode'],140);
$xtable->td(fftgl($r['tanggal1']), 120);
$xtable->td(fRp($r['saldoawal']), 140, 'r');
$xtable->td(nl2br($r['keterangan']));
if ($r['aktif'] == '1') {
//$s='<button class="btns" title="Klik untuk me-non aktifkan." style="width:85px" onclick="tahunbuku_status_form(\'uf\','.$r['replid'].')">Aktif</button>';
$s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:83px;margin:auto"><b>Aktif</b></div>';
} else {
$s = '<button class="btn" title="Klik untuk mengaktifkan." style="width:85px" onclick="tahunbuku_status_form(\'uf\',' . $r['replid'] . ')">Tidak Aktif</button>';
}
$xtable->td($s, 100, 'c');
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
$debet = 0;
$kredit = 0;
foreach ($saldo_rek as $rek => $r) {
$xtable->row_begin();
$xtable->td($r['kode'], 70, 'c');
$xtable->td($r['nama']);
$xtable->td(fRp($r['debet'], 0), 100, 'r');
$xtable->td(fRp($r['kredit'], 0), 100, 'r');
$debet += $r['debet'];
$kredit += $r['kredit'];
$xtable->row_end();
}
$xtable->row_begin();
$s = 'style="border-top:2px solid #88d9ff"';
$xtable->td('<b>Jumlah</b>', '', 'c', $s);
$xtable->td('', '', '', $s);
$xtable->td('<b>' . fRp($debet, 0) . '</b>', 100, 'r', $s);
$xtable->td('<b>' . fRp($kredit, 0) . '</b>', 100, 'r', $s);
$xtable->row_end();
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
$pdf->MultiCell($twx[$i], 0, $r['disctunai'] . ' %', 0, 'R', 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$i++;
$pdf->MultiCell($twx[$i], 0, fRp($r['denda']), 0, 'R', 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$i++;
$pdf->MultiCell($twx[$i], 0, fRp($r['sumnet']), 0, 'R', 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$i++;
$pdf->MultiCell($twx[$i], 0, fRp($r['angsuran']) . $lnbr . 'x ' . $r['jmlangsur'] . ' bulan', 0, 'R', 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$i++;
$pdf->MultiCell($twx[$i], 0, $r['ujian1'], 0, $tax[$i++], 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$pdf->MultiCell($twx[$i], 0, $r['ujian2'], 0, $tax[$i++], 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
}
$pdf->MultiCell($twx[$i], 0, $r['ujian3'], 0, $tax[$i++], 0, 0, '', '', true);
if ($pdf->getLastH() > $my) {
$my = $pdf->getLastH();
// 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');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
} else {
echo '<div class="infobox">Tidak ada tahun buku yang aktif.</div>';
}
// Laba/Rugi
// $laba=$labarugi_kredit-$labarugi_debet;
if ($laba < 0) {
$xtable->td();
$xtable->td('<b>' . fRp($labarugi_debet - $laba, 0) . '</b>', 100, 'r');
} else {
$xtable->td('<b>' . fRp($labarugi_debet + $laba, 0) . '</b>', 100, 'r');
$xtable->td();
}
// Neraca
// $selisih=$neraca_debet-$neraca_kredit;
if ($selisih < 0) {
$xtable->td('<b>' . fRp($neraca_kredit - $selisih, 0) . '</b>', 100, 'r');
$xtable->td();
} else {
$xtable->td();
$xtable->td('<b>' . fRp($neraca_kredit + $selisih, 0) . '</b>', 100, 'r');
}
$xtable->row_end();
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
px;margin-right:4px;margin-top:10px;margin-bottom:4px">
<?php
$t1 = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'");
$k = 0;
while ($r1 = mysql_fetch_array($t1)) {
$n = mysql_num_rows(mysql_query("SELECT * FROM psb_calonsiswa WHERE kelompok='" . $r1['replid'] . "' AND status<>0"));
$w = intval($n * $barw / $kapasitas);
echo '<div style="float:left;background:' . $bcolor[$k++] . ';height:4px;width:' . $w . 'px"></div>';
}
?>
</div>
<?php
//$t=dbQSql($token);
$no = 1;
$doc->head('No{C}', '@Kelompok', '@Tanggal Pendaftaran', '@Biaya Pendaftaran', '@calon Siswa', '@Siswa diterima', 'Keterangan');
while ($r = dbFA($query)) {
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'");
$n1 = mysql_num_rows($q);
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0");
$n2 = mysql_num_rows($q);
$doc->nl();
$doc->cell($no++, 20, 'c');
$doc->cell($r['kelompok'], 80);
$doc->cell(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 50);
$doc->cell(fRp($r['biaya']), 50);
//$doc->cell($r['biaya'],50);
$doc->cell($n1, 50);
$doc->cell($n2, 50);
}
$doc->cell($r['keterangan'], 50);
$doc->end();
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
$kel = gpost('kelompok');
$kelompok = kelompok_r($kel, $pros);
$cid = gets('token');
$query = mysql_query("SELECT * FROM psb_calonsiswa WHERE replid='{$cid}' LIMIT 0,1");
//$query = mysql_query("SELECT * FROM psb_calonsiswa WHERE proses='$pros' AND kelompok='$kel' ORDER BY nopendaftaran");
$token = doc_decrypt($token);
$doc = new doc();
$doc->dochead('Pendataan Calon Siswa', 100);
//$doc->nl();
//$doc->row_blank(5);
//$t=dbQSql($token);
$no = 1;
$doc->head('@Nomor Pendaftaran{2}', '@Nama{2}', '@Uang Pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}');
$doc->head('Subsidi{R}', 'Saudara{R}', 'Tunai{R}', '!x bulan{R}');
while ($r = dbFA($query)) {
$doc->nl();
//$doc->cell($no++,20,'c');
$doc->cell($r['nopendaftaran'], 90, 'r');
$doc->cell($r['nama']);
$doc->cell(fRp($r['sumpokok']), 90, 'r');
$doc->cell(fRp($r['disctb']), 90, 'r');
$doc->cell(fRp($r['discsaudara']), 90, 'r');
$doc->cell(fRp($r['disctunai']), 90, 'r');
$doc->cell(fRp($r['denda']), 90, 'r');
$doc->cell(fRp($r['angsuran']) . '<br/>x ' . $r['jmlangsur'] . ' bulan', 90, 'r');
}
$doc->end();
}
}
}
}
}
}
}
$xtable->td(fhtgl($r['tanggal']), 80);
$xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/><span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span>' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120);
$xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"');
$xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"');
$t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid");
if (mysql_num_rows($t1) > 0) {
$s = '<div style="background:#fff"><table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">';
while ($r1 = mysql_fetch_array($t1)) {
$s .= '<tr><td>' . $r1['nrek'] . '</td><td width="40px" align="center">' . $r1['koderek'] . '</td><td width="100px" align="right">' . fRp($r1['debet']) . '</td><td width="100px" align="right">' . fRp($r1['kredit']) . '</td></tr>';
}
$s .= '</table></div>';
} else {
$s = '';
}
$xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"');
$s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>';
$xtable->opt($r['replid'], 'u', 'd');
$row++;
}
$xtable->foot();
hiddenval('xtd_jd_num', $row);
echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>';
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
exit;
}
$PSBar->end();
// Query
$db = new xdb("sar_grup", "", "lokasi='{$lok}'");
$t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama'));
$xtable->btnbar_begin();
$xtable->btnbar_add();
echo '<div class="sfont" style="float:right;margin-top:4px">Total aset: ' . fRp(lokasi_aset($lok)) . '</div>';
$xtable->btnbar_end();
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@kode', '@nama Grup barang', 'Jumlah unit~C', 'Unit tersedia~C', 'Unit dipinjam~C', 'Total aset~R', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE grup='" . $r['replid'] . "'"));
$xtable->td($r['kode'], 100);
$xtable->td($r['nama'], 200);
$xtable->td($n, 100, 'c');
$xtable->td(0, 100, 'c');
$xtable->td(0, 100, 'c');
$xtable->td(fRp(grup_aset($r['replid'])), 120, 'r');
$xtable->td(nl2br($r['keterangan']));
$xtable->opt($r['replid'], 'v', 'u', 'd');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
$pdf->MultiCell(100, 0, ': ' . fftgl($transaksi['tanggal']), 0, 'L', 0, 1, '', '', true);
$pdf->MultiCell(30, 0, 'Diterima dari', 0, 'L', 0, 0, '', '', true);
$pdf->MultiCell(100, 0, ': ', 0, 'L', 0, 1, '', '', true);
dc_YDown(2);
// Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=0, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M')
$pdf->setCellPaddings(1, 1, 1, 1);
$pdf->Cell(20, 0, 'Perkiraan', 1, 0, 'C');
$pdf->Cell(100, 0, 'Uraian', 1, 0, 'C');
$pdf->Cell(30, 0, 'Jumlah', 1, 1, 'C');
$t = mysql_query("SELECT * FROM keu_transaksi WHERE keu_transaksi.ct='" . $transaksi['ct'] . "'");
$total = 0;
while ($r = mysql_fetch_array($t)) {
$t1 = mysql_query("SELECT keu_jurnal.rek,keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid");
while ($r1 = mysql_fetch_array($t1)) {
if ($r1['rek'] != 1) {
$pdf->Cell(20, 0, $r1['koderek'], 1, 0, 'C');
$pdf->Cell(100, 0, $r['uraian'], 1, 0, 'L');
$pdf->Cell(30, 0, fRp($r['nominal']), 1, 1, 'R');
$total += $r['nominal'];
}
}
}
$pdf->Cell(20, 0, '', 1, 0, 'C');
$pdf->Cell(100, 0, 'Jumlah', 1, 0, 'R');
$pdf->Cell(30, 0, fRp($total), 1, 1, 'R');
$pdf->lastPage();
// ---------------------------------------------------------
$pdf->Output('SIADU - Bukti Transaksi.pdf', 'I');
} else {
echo "okoko Dokumen tidak tersedia!";
}
</td>
<td align="">
<table class="stable" cellspacing="0" cellpadding="0">
<tr height="24px"><td colspan="2"><b>Kondisi Barang:</b></td></tr>
<tr><td><div id="placeholder" style="background:#fff;width:300px;height:120px"></div></td></tr>
</table>
</td>
</tr></table>
</div>
<?php
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@kode', '@barkode', 'sumber', 'harga~R', '@kondisi', 'status', 'keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 200);
$xtable->td($r['barkode'], 100);
$xtable->td(sumber_name($r['sumber']), 100);
$xtable->td(fRp($r['harga']), 120, 'r');
$xtable->td(kondisi_name($r['kondisi']), 100);
$xtable->td($r['status'] == 1 ? 'Tersedia' : 'Dipinjam', 100);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
<td class="cell" align="center" width="300px">Uraian</td>
<td class="cell" align="center" width="100px">Nominal</td>
</tr>
<?php
$t = mysql_query("SELECT * FROM keu_transaksi WHERE keu_transaksi.nomer='{$token}'");
$total = 0;
while ($r = mysql_fetch_array($t)) {
$t1 = mysql_query("SELECT keu_jurnal.rek,keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' AND keu_rekening.kategorirek<>'1' AND keu_rekening.kategorirek<>'2' ORDER BY keu_jurnal.replid");
while ($r1 = mysql_fetch_array($t1)) {
if ($r1['rek'] != 1) {
echo '<tr>';
echo '<td class="cell" width="100px" align="center" x:str>' . $r1['koderek'] . '</td>';
echo '<td class="cell">' . $r['uraian'] . '</td>';
echo '<td class="cell" width="100px" align="right">' . fRp($r['nominal']) . '</td>';
echo '</tr>';
$total += $r['nominal'];
}
}
}
echo '<tr>';
echo '<td class="cell" width="100px"></td>';
echo '<td class="cell" align="right">Jumlah</td>';
echo '<td class="cell" width="100px" align="right" x:fmla="=SUM(C8:C9)">' . fRp($total) . '</td>';
echo '</tr>';
?>
</table>
<?php
} else {
doc_nofile();
}
$xtable->td(fhtgl($r['tanggal']), 80);
$xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/>
<span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span>
' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120);
$xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"');
$xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"');
$t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid");
if (mysql_num_rows($t1) > 0) {
$s = '<div style="background:#fff">
<table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">';
while ($r1 = mysql_fetch_array($t1)) {
$s .= '<tr>
<td>' . $r1['nrek'] . '</td>
<td width="40px" align="center">' . $r1['koderek'] . '</td>
<td width="100px" align="right">' . fRp($r1['debet']) . '</td>
<td width="100px" align="right">' . fRp($r1['kredit']) . '</td>
</tr>';
}
$s .= '</table></div>';
} else {
$s = '';
}
$xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"');
$s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>';
$xtable->opt($r['replid'], 'u', 'd');
$row++;
}
$xtable->foot();
hiddenval('xtd_jd_num', $row);
echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>';
} else {
