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>
