k.nama = "formulir"'; // var_dump($s2);exit(); $e2 = mysql_query($s2); $r2 = mysql_fetch_assoc($e2); $stat = $e2 ? 'sukses' : 'gagal'; $biaya = getBiaya('formulir', $_POST['replid']); $terbayar = getTerbayar('formulir', $_POST['replid']); $out = json_encode(array('status' => $stat, 'datax' => array('nopendaftaran' => $r1['nopendaftaran'], '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'], 'status' => $biaya == $terbayar && $biaya != 0 ? 'lunas' : 'belum', 'nominal' => 'Rp. ' . number_format($biaya)))); break; case 'joiningf': $angkatan = getSiswa('angkatan', $_POST['replid']); $modul = getModulPembayaran('Joining Fee', $angkatan); // var_dump($angkatan);exit(); $nominal = getBiaya('joiningf', $_POST['replid']); $terbayar = getTerbayar('Joining Fee', $_POST['replid']); $maxbayar = getBiaya('joiningf', $_POST['replid']) - getTerbayar('Joining Fee', $_POST['replid']); $out = json_encode(array('status' => $modul != null ? 'sukses' : 'gagal', 'datax' => array('nopendaftaran' => $modul['nopendaftaran'], 'idsiswa' => $_POST['replid'], 'siswa' => $modul['siswa'], 'nomer' => getNoTrans($_POST['subaksi']), 'tanggal' => tgl_indo5(date('Y-m-d')), 'rekkas' => $modul['rek1'], 'rekitem' => $modul['rek2'], 'rek1' => $modul['rek1'] == '0' ? '' : getRekening($modul['rek1']), 'rek2' => $modul['rek2'] == '0' ? '' : getRekening($modul['rek2']), 'rek3' => $modul['rek3'] == '0' ? '' : getRekening($modul['rek3']), 'modul' => $modul['modul'], 'idmodul' => $modul['idmodul'], 'nominal' => $nominal, 'nominal2' => 'Rp. ' . number_format($nominal), 'terbayar' => $terbayar, 'terbayar2' => 'Rp. ' . number_format($terbayar), 'maxbayar' => $maxbayar, 'status' => getStatusBayar('joiningf', $_POST['replid']), 'maxbayar2' => 'Rp. ' . number_format($maxbayar)))); break; case 'dpp': // get angkatan by : siswa -> kelompok -> angkatan $s1 = 'SELECT p.angkatan, b.nilai nominal, c.nis, c.replid idsiswa, c.nama siswa, c.jmlangsur, a.cicilan, c.discsaudara, c.disctb, d.nilai disctunaipers,
</tr>'; $nox = 1; $totbayar = 0; if ($n == 0) { $out .= '<tr> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr>'; } else { while ($r2 = mysql_fetch_assoc($e2)) { $biaya = getBiaya($pre, $r2['replid']); $terbayar = getTerbayar($pre, $r2['replid']); $status = getStatusBayar($pre, $r2['replid']); // var_dump($status);exit(); if ($status == 'lunas') { $clr = 'lightGreen'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td align="center">' . $r2['nis'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td> <td style="background-color:' . $clr . '" align="center">' . $status . '</td> <td align="center">' . getTglTrans($r2['replid'], $pre) . '</td>
function akanBayarOpt($typ, $siswa) { $biayaKotor = getBiaya($typ, $siswa); // 15.000.000 $diskonTotal = getDiscTotal($typ, $siswa); // 900.000 // __________ - $biaya = $biayaKotor - $diskonTotal; // 14.100.000 $angsurkali = getSiswaBy('jmlangsur', $siswa); // 3 x use $terbayar = getTerbayar($typ, $siswa); // 4.700.000 $angsurnom = $biaya / $angsurkali; // @4.700.000 use $sisabayar = $biaya - $terbayar; // 9.400.000 // var_dump($diskonTotal);exit(); $ret = array(); $nominal = 0; $count = $sisabayar / $angsurnom; // 1 x for ($i = 1; $i <= $count; $i++) { $nominal += $angsurnom; $ret[] = array('idAngsur' => $i, 'nomAngsur' => 'Rp. ' . number_format($nominal)); } return $ret; }
$nox = 1; $totbayar = $totkurang = 0; if ($n == 0) { $out .= '<tr> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr>'; } else { $nox = 1; while ($r2 = mysql_fetch_assoc($e2)) { $biaya = getBiaya('joining fee', $r2['replid']); $terbayar = getTerbayar('joining fee', $r2['replid']); $kurangan = $biaya - $terbayar; $status = getStatusBayar('joining fee', $r2['replid']); if ($status == 'lunas') { $clr = 'lightGreen'; } elseif ($status == 'kurang') { $clr = 'yellow'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td>' . $r2['nopendaftaran'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td>
</tr>'; $nox = 1; $totbayar = $totkurang = 0; if ($n == 0) { $out .= '<tr> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr>'; } else { while ($r2 = mysql_fetch_assoc($e2)) { $biaya = getBiaya('formulir', $r2['replid']); $terbayar = getTerbayar('formulir', $r2['replid']); $kurangan = $biaya - $terbayar; $status = getStatusBayar('formulir', $r2['replid']); if ($status == 'lunas') { $clr = 'lightGreen'; } elseif ($status == 'kurang') { $clr = 'yellow'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td>' . $r2['nopendaftaran'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td>
$totdpp = 0; $totkurang = 0; if ($n == 0) { $out .= '<tr> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr>'; } else { while ($r = mysql_fetch_assoc($e)) { $dpp = getBiaya('dpp', $r['replid']) - getDiscTotal('dpp', $r['replid']); $kurangan = $dpp - getTerbayar('dpp', $r['replid']); $status = getStatusBayar('dpp', $r['replid']); if ($status == 'lunas') { $clr = 'lightGreen'; } elseif ($status == 'kurang') { $clr = 'yellow'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td>' . $r['nis'] . '</td> <td>' . $r['nama'] . '</td> <td align="right">Rp. ' . number_format($dpp) . ',-</td> <td align="right">Rp. ' . number_format($kurangan) . ',-</td>