$n = mysql_num_rows($e); $out .= '<body> <table width="100%"> <tr> <td width="43%"> <img width="100" src="../../images/logo.png" alt="" /> </td> <td> <b>' . $mnu . '</b> </td> </tr> </table><br />'; $r = mysql_fetch_assoc($e); $out .= '<table xclass="isi" width="100%">'; $proses = getProses('tahunajaran', $r['kelompok']); $kelompok = getKelompok('kelompok', $r['kelompok']); $kriteria = getField('tingkat', 'aka_tingkat', 'replid', $r['tingkat']); $golongan = getField('golongan', 'psb_golongan', 'replid', $r['golongan']); // var_dump($proses);exit(); // bioadata siswa $out .= ' <tr class="head"> <td colspan="3">Kriteria Siswa</td> </tr><tr> <td width="20%">Tahun Ajaran</td> <td>: ' . $proses . '</td> </tr><tr> <td width="20%">Kelompok</td> <td>: ' . $kelompok . '</td> </tr><tr> <td width="20%">Kriteria</td>
WHERE p.modul = ' . $r2['idmodul'] . ' 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
$e2 = mysql_query($s2) or die(mysql_error()); $n = mysql_num_rows($e2); $out .= '<body> <table width="100%"> <tr> <td width="39%"> <img width="100" src="../../images/logo.png" alt="" /> </td> <td> <b>Pembayaran ' . $mnu . '</b> </td> </tr> </table><br />'; $kel = getKelompok('kelompok', $kelompok); $pros = getProses('proses', getKelompok('proses', $kelompok)); $dep = getDepartemen('nama', getProses('departemen', getKelompok('proses', $kelompok))); $out .= '<table width="100%"> <tr> <td>Departemen </td> <td>: ' . $dep . '</td> <td></td> </tr> <tr> <td>Periode</td> <td>: ' . $pros . '</td> <td align="right"></td> </tr> <tr> <td>Kelompok</td> <td>: ' . $kel . '</td> <td align="right"> Total :' . $n . ' Data</td>