LEFT JOIN psb_calonsiswa_ibu i ON i.calonsiswa = c.replid
LEFT JOIN psb_calonsiswa_kontakdarurat d ON d.calonsiswa = c.replid
LEFT JOIN psb_calonsiswa_keluarga k ON k.calonsiswa = c.replid
LEFT JOIN psb_setbiaya b ON b.replid = c.setbiaya
WHERE
c.replid='.$_POST['replid'];
$e = mysql_query($s) or die(mysql_error());
$r = mysql_fetch_assoc($e);
// print_r($r);exit();
$stat = ($e)?'sukses':'gagal';
$regNum = setuang(getBiaya('dpp',$_POST['replid']));
$regNumNet = setuang(getBiayaNet('dpp',$_POST['replid']));
$nopendaftaran = getNoPendaftaran($_POST['replid'],$r['kelompok'])['full'];
$proses = getField('proses','psb_kelompok','replid',$r['kelompok']);
$discangsuran = setuang(getDiscAngsuran($regNum, $r['angsuran']));
$disctunai = setuang(getDisc('disctunai',$_POST['replid']));
// var_dump($discangsuran);exit();
$out = json_encode(array(
'status' =>$stat,
// pembayaran
'setbiaya' =>$r['setbiaya'],
'dpp' =>$regNum,
'angsuran' =>$r['angsuran'],
'discangsuran' =>$discangsuran,
'discsubsidi' =>setuang($r['discsubsidi']),
'discsaudara' =>setuang($r['discsaudara']),
'iddisctunai' =>$r['disctunai'],
'disctunai' =>$disctunai,
'disctotal' =>setuang(getDiscTotal($_POST['replid'])),
'dppnet' =>$regNumNet,
'joiningf' =>setuang($r['joiningf']),
function getDiscTotal($siswa)
{
$ret = getDisc('discangsuran', $siswa) + getDisc('disctunai', $siswa) + getSiswaBy('discsubsidi', $siswa) + getSiswaBy('discsaudara', $siswa);
return $ret;
}
function getDiscTotal($typ, $siswa)
{
// var_dump(getSiswaBy('discsaudara',$siswa));exit(); 150.000
// var_dump(getSiswaBy('disctb',$siswa));exit(); 0
// var_dump(getDiscTunai($typ,$siswa));exit(); 750.000
$ret = getDisc('discangsuran', $siswa) + getDisc('disctunai', $siswa) + getDiscTunai($typ, $siswa) + getSiswaBy('disctb', $siswa) + getSiswaBy('discsaudara', $siswa);
// var_dump($ret);exit();
return $ret;
}
