<button data-hint="hapus" class="button" onclick="del(' . $r['replid'] . ');"> <i class="icon-remove on-left"></i> </button> </td>'; $rekening = ''; if ($r['rek1'] != 0) { $rekening .= '<b> Kas :</b> ' . getRekening($r['rek1']) . '<br>'; } if ($r['rek2'] != 0) { $rekening .= '<b> Pendapatan :</b> ' . getRekening($r['rek2']) . '<br>'; } if ($r['rek3'] != 0) { $rekening .= '<b> Piutang :</b> ' . getRekening($r['rek3']) . '<br>'; } $kat = getKatModulPembayaran('nama', $r['idkat']); $thn = $kat != 'Registration' ? '/ Th. Ajaran ' . getTahunAjaran('tahunajaran', $r['idtahunajaran']) : '/ Angkatan ' . getAngkatan('angkatan', $r['angkatan']); $sem = $kat != 'Registration' ? '/ Sem. ' . $r['semester'] : ''; $bln = $kat == 'Tuition Fee' && $r['bulan'] != 0 ? '/ ' . bln_nama($r['bulan'], 'id', 'c') : ''; $nama = $kat . $thn . $sem . $bln; $out .= '<tr> <td>' . $nama . '</td> <td>' . $rekening . '</td> <td>' . $r['tahunajaran'] . '</td> <td>' . $r['semester'] . '</td> <td>' . ($r['bulan'] != 0 ? bln_nama($r['bulan'], 'id', 's') : '-') . '</td> <td>' . $r['keterangan'] . '</td> ' . $btn . ' </tr>'; } } else { #kosong
AND p.siswa = ' . $r1['idsiswa'] . ' GROUP BY p.siswa'; $e3 = mysql_query($s3); $r3 = mysql_fetch_assoc($e3); $stat = $e2 ? 'sukses' : 'gagal'; $out = json_encode(array('status' => $stat, 'datax' => array('nis' => $r1['nis'], 'idsiswa' => $r1['idsiswa'], 'siswa' => $r1['siswa'], 'nomer' => getNoTrans($_POST['subaksi']), 'tanggal' => tgl_indo5(date('Y-m-d')), 'rekkas' => $r2['rek1'], 'rekitem' => $r2['rek2'], 'rek1' => getRekening($r2['rek1']), 'rek2' => getRekening($r2['rek2']), 'rek3' => getRekening($r2['rek3']), 'modul' => $r2['modul'], 'idmodul' => $r2['idmodul'], 'nominal' => 'Rp. ' . number_format($r1['nominal']), 'nominalnet' => 'Rp. ' . number_format($r1['nominalnet']), 'discsubsidi' => 'Rp. ' . number_format($r1['disctb']), 'discsaudara' => 'Rp. ' . number_format($r1['discsaudara']), 'disctunaipers' => $r1['disctunaipers'], 'disctunairp' => 'Rp. ' . number_format($r1['disctunairp']), 'disctotal' => 'Rp. ' . number_format($r1['disctotal']), 'jmlangsur' => $r1['cicilan'], 'angsuran' => 'Rp. ' . number_format($r1['nominalnet'] / $r1['cicilan']), 'status' => getStatusBayar('dpp', $_POST['replid']), 'terbayar' => 'Rp. ' . number_format($r3['terbayar'])))); break; case 'spp': $sis = $_POST['replid']; // $kel = getSiswaBy('kelompok', $sis); // 5 $pros = getKelompok('proses', $kel); // 3 $ang = getAngkatan('replid', $pros); // 3 // get data : modul pembayaran (untuk form) $s2 = 'SELECT m.replid, m.rek1, m.rek2, m.rek3, m.nama modul, m.replid idmodul FROM keu_modulpembayaran m LEFT JOIN keu_katmodulpembayaran k ON k.replid = m.katmodulpembayaran LEFT JOIN keu_pembayaran p ON p.modul = m.replid WHERE m.angkatan = ' . $ang . ' AND
GROUP BY ss.replid ) t1 ON t1.replid = cs.replid LEFT JOIN psb_kelompok k on k.replid = cs.kelompok LEFT JOIN psb_proses p on p.replid = k.proses ) t2 ON t2.replid = c.replid WHERE t2.angkatan = ' . $angkatan . ' AND t2.nama LIKE "%' . $nama . '%" AND t2.nis LIKE "%' . $nis . '%" ' . $status; // var_dump($s);exit(); $e = mysql_query($s) or die(mysql_error()); $n = mysql_num_rows($e); // header info $departemen = getDepartemen('nama', getAngkatan('departemen', $angkatan)); $angkatanx = getAngkatan('angkatan', $angkatan); $out .= '<body> <table width="100%"> <tr> <td width="32%"> <img width="100" src="../../images/logo.png" alt="" /> </td> <td> <b>Pembayaran ' . $mnu . '</b> </td> </tr> </table><br />'; $out .= '<table width="100%"> <tr> <td width="10%">Departemen </td> <td>: ' . $departemen . '</td>