Пример #1
0
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;
}
Пример #2
0
						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)));