k.kakek_nama namaKakek,
k.nenek_nama namaNenek
FROM psb_calonsiswa c
LEFT JOIN psb_calonsiswa_ayah a ON a.calonsiswa = c.replid
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'],
<td width="20%">Kelompok</td>
<td>: ' . $kelompok . '</td>
</tr><tr>
<td width="20%">Kriteria</td>
<td>: ' . $kriteria . '</td>
</tr><tr>
<td width="20%">Golongan</td>
<td>: ' . $golongan . '</td>
</tr>';
// Pembayaran
$out .= '
<tr class="head">
<td colspan="3">Pembayaran</td>
</tr><tr>
<td width="20%">Registration Fee</td>
<td>: ' . setuang(getBiayaNet('registration', $r['replid'])) . ' (' . ($r['angsuran'] == 1 ? 'cash' : $r['angsuran'] . 'x angsuran') . ')</td>
</tr><tr>
<td width="20%">Material Fee</td>
<td>: ' . setuang(getBiaya('material', $r['replid'])) . '</td>
</tr><tr>
<td width="20%">Tuition Fee</td>
<td>: ' . setuang(getBiaya('tuition', $r['replid'])) . '</td>
</tr>';
// bio data calon siswa
$out .= '
<tr class="head">
<td colspan="3">Biodata Siswa</td>
</tr><tr>
<td width="20%">No. Pendaftaran</td>
<td>: ' . getNoPendaftaran($replid, $r['kelompok'])['akhir'] . '</td>
<td align="right" rowspan="5"><img height="120" src="../img/upload/' . $r['photo'] . '" alt="" /></td>
k.nenek_nama namaNenek
FROM psb_calonsiswa c
LEFT JOIN psb_calonsiswa_ayah a ON a.calonsiswa = c.replid
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
-- LEFT JOIN aka_tingkat t ON t.replid = c.tingkat
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('registration', $_POST['replid']));
$regNumNet = setuang(getBiayaNet('registration', $_POST['replid']));
$nopendaftaran = getNoPendaftaran($_POST['replid'], $r['kelompok'])['akhir'];
// $tingkat = getField('tingkat','psb_calonsiswa','replid',$r['tingkat']);
$tahunajaran = getField('tahunajaran', 'psb_kelompok', 'replid', $r['kelompok']);
$discangsuran = setuang(getDiscAngsuran($regNum, $r['angsuran']));
$disctunai = setuang(getDisc('disctunai', $_POST['replid']));
// var_dump($tingkat);exit();
$out = json_encode(array('status' => $stat, 'setbiaya' => $r['setbiaya'], 'registration' => $regNum, 'angsuran' => $r['angsuran'], 'discangsuran' => $discangsuran, 'discsubsidi' => setuang($r['discsubsidi']), 'discsaudara' => setuang($r['discsaudara']), 'iddisctunai' => $r['disctunai'], 'disctunai' => $disctunai, 'disctotal' => setuang(getDiscTotal($_POST['replid'])), 'registrationnet' => $regNumNet, 'material' => setuang($r['material']), 'tuition' => setuang($r['tuition']), 'nopendaftaranH' => $r['nopendaftaran'], 'nopendaftaran' => $nopendaftaran, 'namaSiswa' => $r['namaSiswa'], 'tahunajaran' => $tahunajaran, 'kelompok' => $r['kelompok'], 'tingkat' => $r['tingkat'], 'golongan' => $r['golongan'], 'kelamin' => $r['kelamin'], 'tmplahir' => $r['tmplahir'], 'tgllahir' => tgl_indo5($r['tgllahir']), 'agama' => $r['agama'], 'alamat' => $r['alamat'], 'telpon' => $r['telpon'], 'sekolahasal' => $r['sekolahasal'], 'photo' => $r['photo'], 'darah' => $r['darah'], 'kesehatan' => $r['kesehatan'], 'ketkesehatan' => $r['ketkesehatan'], 'namaAyah' => $r['namaAyah'], 'kebangsaanAyah' => $r['kebangsaanAyah'], 'tmplahirAyah' => $r['tmplahirAyah'], 'tgllahirAyah' => tgl_indo5($r['tgllahirAyah']), 'pekerjaanAyah' => $r['pekerjaanAyah'], 'telponAyah' => $r['telponAyah'], 'pinbbAyah' => $r['pinbbAyah'], 'emailAyah' => $r['emailAyah'], 'namaIbu' => $r['namaIbu'], 'kebangsaanIbu' => $r['kebangsaanIbu'], 'tmplahirIbu' => $r['tmplahirIbu'], 'tgllahirIbu' => tgl_indo5($r['tgllahirIbu']), 'pekerjaanIbu' => $r['pekerjaanIbu'], 'telponIbu' => $r['telponIbu'], 'pinbbIbu' => $r['pinbbIbu'], 'emailIbu' => $r['emailIbu'], 'namaKakek' => $r['namaKakek'], 'namaNenek' => $r['namaNenek'], 'namaDarurat' => $r['namaDarurat'], 'hubungan' => $r['hubungan'], 'telponDarurat' => $r['telponDarurat']));
break;
// ambiledit -----------------------------------------------------------------
//detail siswa
// ambiledit -----------------------------------------------------------------
//detail siswa
case 'detail':
$s = ' SELECT
t.replid,
