function getAngsuranNominal($idSiswa, $idBiaya) { // a.angsuran // JOIN psb_detailbiaya db on db.replid = sb.detailbiaya // JOIN psb_angsuran a on a.replid = sb.angsuran $s = 'SELECT IFNULL(a.angsuran,1)angsuran FROM psb_siswabiaya sb left JOIN psb_detailbiaya db on db.replid = sb.detailbiaya left JOIN psb_angsuran a on a.replid = sb.angsuran WHERE sb.siswa = ' . $idSiswa . ' AND db.biaya = ' . $idBiaya; $e = mysql_query($s); $ra = mysql_fetch_assoc($e); $angsuran = $ra['angsuran']; $biayaNett = getBiayaNett2($idSiswa, $idBiaya); $angsuranNominal = $biayaNett / $angsuran; // pr($angsuran); return $angsuranNominal; }
WHERE status != "2" and idbiaya =' . $_POST['biaya'] . ' and idsiswa =' . $_POST['replid'] . ' AND idsubtingkat = ' . $_POST['subtingkat'] . ' GROUP BY idsiswabiaya ORDER BY idsubtingkat asc, namasiswa asc'; // pr($s); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; // awal $biayaNett = getBiayaNett2($_POST['replid'], $_POST['biaya']); $angsuranNominal = getAngsuranNominal($_POST['replid'], $_POST['biaya']); // terbayar $terbayarAngsurankeReal = getTerbayarAngsuranke($_POST['replid'], $_POST['biaya']); $terbayarBaru = getTerbayarBaru($_POST['replid'], $_POST['biaya']); $terbayarTotal = getTerbayarTotal($_POST['replid'], $_POST['biaya']); $terbayarAngsurankeRule = ceil($terbayarTotal / $angsuranNominal); // akan bayar $akanBayarke = $terbayarTotal % $angsuranNominal == 0 ? $terbayarAngsurankeRule + 1 : $terbayarAngsurankeRule; $lunasPerAngsuran = $terbayarTotal % $angsuranNominal == 0 ? true : false; $lunasTotalAngsuran = $terbayarTotal == $biayaNett ? true : false; $kuranganAngsuran = $terbayarAngsurankeRule == $akanBayarke ? $angsuranNominal - $terbayarBaru : 0; //belum bayar $belumBayarAngsuranke = intval($r['angsuran']) - intval($akanBayarke); $semester = getField('semester', 'aka_semester', 'replid', $r['idsemester']); $out = json_encode(array('status' => $stat, 'datax' => array('idsiswabiaya' => $r['idsiswabiaya'], 'ditagih' => $r['ditagih'], 'idsemester' => $r['idsemester'], 'idsemester' => $r['idsemester'], 'semester' => $semester == '1' ? 'Ganjil' : 'Genap', 'namasiswa' => $r['namasiswa'], 'kelas' => $r['kelas'], 'biaya' => $r['biaya'], 'nis' => $r['nis'], 'biayaAwal' => setuang($r['biayaAwal']), 'biayaNett' => setuang($biayaNett), 'totalDiskon' => setuang($r['biayaAwal'] - $biayaNett), 'kuranganAngsuran' => $kuranganAngsuran, 'viabayar' => $r['viabayar'], 'isAngsur2' => $r['isAngsur2'], 'angsuran' => $r['angsuran'], 'angsuranNominal' => setuang($angsuranNominal), 'lunasPerAngsuran' => $lunasPerAngsuran, 'lunasTotalAngsuran' => $lunasTotalAngsuran, 'terbayarAngsurankeReal' => $terbayarAngsurankeReal, 'terbayarAngsurankeRule' => $terbayarAngsurankeRule, 'terbayarBaru' => setuang($terbayarBaru), 'terbayarTotal' => setuang($terbayarTotal), 'akanBayarke' => $akanBayarke, 'belumBayarAngsuranke' => $belumBayarAngsuranke)));