foreach ($r5 as $i => $v) {
$out.='<tr>
<td>'.(empty($v['namakontakdarurat'])?'-':$v['namakontakdarurat']).'</td>
<td>'.(empty($v['hubkontakdarurat'])?'-':$v['hubkontakdarurat']).'</td>
<td>'.(empty($v['telponkontakdarurat1'])?'-':$v['telponkontakdarurat1']).'</td>
<td>'.(empty($v['telponkontakdarurat2'])?'-':$v['telponkontakdarurat2']).'</td>
</tr>';
}
}
$out.='</table>
</td>
</tr>
<tr><td colspan="3"> </td></tr>';
// bioadata saudara siswa
$r6=getFieldArr2('*',$tb6,'siswa',$replid);
$out.='<tr xclass="head"><td colspan="3">Biodata Saudara</td>
</tr><tr xstyle="background-color:green" >
<td colspan="3">
<table style="width:100%;background-color:grey">
<tr class="head" >
<td>Nama</td>
<td>Jenis Kelamin</td>
<td>Tempat / Tgl. Lahir</td>
<td>Sekolah</td>
<td>Grade</td>
</tr>';
if(count($r6)==0) $out.='<tr><td align="center">-</td><td align="center">-</td><td align="center">-</td><td align="center">-</td><td align="center">-</td></tr>';
else{
foreach ($r6 as $i => $v) {
$out.='<tr>
// ambiledit -----------------------------------------------------------------
// delete -----------------------------------------------------------------
// ambiledit -----------------------------------------------------------------
case 'ambiledit':
// history login
$cnt = getField('count(*)', 'kon_loginhistory', 'id_login', $_POST['id_user']);
$isLogged = $cnt > 0 ? true : false;
// data user/login
$s = ' SELECT *
from ' . $tb . '
WHERE id_login = '******'id_user'];
$e = mysql_query($s) or die(mysql_error());
$stat = $e ? 'sukses' : 'gagal';
$r = mysql_fetch_assoc($e);
// data departemen
$logDep = getFieldArr2('id_departemen', 'kon_logindepartemen', 'id_login', $_POST['id_user']);
// data modul & menu
// $sd = ''
// result
$out = json_encode(array('status' => $stat, 'nama' => $r['nama'], 'username' => $r['username'], 'id_level' => $r['id_level'], 'isLogged' => $isLogged, 'departemen' => $logDep));
break;
// ambiledit -----------------------------------------------------------------
// aktifkan -----------------------------------------------------------------
// ambiledit -----------------------------------------------------------------
// aktifkan -----------------------------------------------------------------
case 'aktifkan':
if (!isset($_POST['id_' . $mnu])) {
$stat = 'no_id_' . $mnu . '_to_post';
} else {
$akt = getField('aktif', $tb, 'id_login', $_POST['id_' . $mnu]);
$s = 'UPDATE ' . $tb . ' set aktif=' . ($akt == 1 ? 0 : 1) . ' where id_' . $mnu . '=' . $_POST['id_' . $mnu];
JOIN aka_subtingkat st ON st.replid = db.subtingkat
JOIN aka_tingkat t ON t.replid = st.tingkat
JOIN departemen d ON d.replid = dg.departemen
JOIN aka_tahunajaran ta ON ta.replid = dg.tahunajaran
WHERE
s.replid ='.$_POST['replid'].'
GROUP BY
s.replid';
// pr($s);
$e = mysql_query($s) or die(mysql_error());
$r = mysql_fetch_assoc($e);
$stat = !$e?'gagal':'sukses';
$kontakdaruratArr = getFieldArr2('*',$tb5,'siswa',$_POST['replid']);
$saudaraArr = getFieldArr2('*',$tb6,'siswa',$_POST['replid']);
$biayaArr = getFieldArr2('*',$tb7,'siswa',$_POST['replid']);
// TODO : fetch psb_siswabiaya (tingkat & subtingkat terakhir/paling tinggi )
// pr($biayaArr);
$out = json_encode(array(
'status' =>$stat,
/*bio siswa*/
'statussiswa' =>$r['status'],
'replid' =>$r['replid'],
'nopendaftaran' =>getNoPendaftaran2($_POST['replid']),
// $r['nopendaftaran'],
'namasiswa' =>$r['namasiswa'],
'nis' =>$r['nis'],
'nisn' =>$r['nisn'],
'panggilansiswa' =>$r['panggilansiswa'],
'jkelaminsiswa' =>$r['jkelaminsiswa'],
'tempatlahirsiswa' =>$r['tempatlahirsiswa'],
