<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 
示例#3
0
                 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>