$xtable->btnbar_end(); */ //echo $xtable->ndata; if ($xtable->ndata > 0) { // Table head $heads = array('@!NIS{2}', '@Nama{2}'); $t0 = dbQSql("SELECT aka_sks.*,aka_pelajaran.kode as kodepel FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE kelas='{$kls}' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama"); while ($r0 = dbFA($t0)) { $pelid = $r0['pelajaran']; $s = $phn[$pelid] . '!' . $r0['kodepel'] . '{C}'; array_push($heads, $s); } $heads = array_merge($heads, array('@!JML Nilai{C,2}', '@Rata-rata{C,2}', '@Peringkat{C,2}', 'Keterangan{2}')); //array_push($heads,'Keterangan'); $xtable->head_addrow($heads); $heads2 = array(); $n = count($SSKM); foreach ($SSKM as $k => $v) { array_push($heads2, '!SKM: ' . $v . '{C}'); } $xtable->head_addrow($heads2); $xtable->head_multi(); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nis'], 60); $xtable->td($r['nama'], 200); $t0 = dbQSql("SELECT aka_sks.*,aka_pelajaran.kode as kodepel FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE kelas='{$kls}' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama"); while ($r0 = dbFA($t0)) { $pelid = $r0['pelajaran']; if (isset($r["TNILAI_" . $pelid])) {
$labarugi[$rek]['kredit'] = $neracasaldo[$rek]['kredit']; } } } $xtable = new xtable($fmod); $xtable->noopt = true; $xtable->tbl_width = '1000px'; $xtable->tbl_style = 'float:left;margin-bottom:30px'; $xtable->row_strip = false; $xtable->cari = 0; $xtable->ndata = count($neracasaldo); if ($xtable->ndata > 0) { //$s='<button style="float:left;margin-right:4px" class="btn" onclick=""><div class="bi_pri">Cetak</div></button>'; //echo '<div class="tbltopbar" style="width:100%;margin-bottom:5px"><div style="width:700px">'.$s.'</div></div>'; //echo '<div class="sfont" style="font-size:15px;float:left;width:1000px;text-align:center;margin-bottom:20px">Neraca Lajur</div>'; $xtable->head_addrow('Kode Rekening{2,70px,C}', 'Nama Rekening{2}', 'Neraca Saldo{C,1,2}', 'Laba/Rugi{C,1,2}', 'Neraca{C,1,2}'); $xtable->head_addrow('Debet{R}', 'Kredit{R}', 'Debet{R}', 'Kredit{R}', 'Debet{R}', 'Kredit{R}'); $xtable->head_multi(); $neracasaldo_debet = 0; $neracasaldo_kredit = 0; $labarugi_debet = 0; $labarugi_kredit = 0; $neraca_debet = 0; $neraca_kredit = 0; foreach ($neracasaldo as $rek => $r) { $xtable->row_begin(); $xtable->td($neracasaldo[$rek]['kode'], 70, 'c'); $xtable->td($neracasaldo[$rek]['nama']); // Neraca saldo $xtable->td(fRp($neracasaldo[$rek]['debet'], 0), 90, 'r'); $xtable->td(fRp($neracasaldo[$rek]['kredit'], 0), 90, 'r');
$db->where("kelompok='{$kel}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('nopendaftaran', 'nama')); $xtable->btnbar_begin(); if ($ncalon < $kapasitas) { $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();