$hint = 'lunas';
$func = 'onclick="pembayaranFR(\'dpp\',' . $res['replid'] . ');"';
} else {
// kurang
$clr = 'yellow';
$icon = 'half';
$hint = 'kurang';
$func = 'onclick="pembayaranFR(\'dpp\',' . $res['replid'] . ');"';
}
}
$btn = '<td align="center">
<button data-hint="' . $hint . '" class="fg-white bg-' . $clr . '" ' . $func . '>
<i class="icon-battery-' . $icon . '"></i>
</button>
</td>';
$dpp = getBiaya('registration', $res['replid']) - getDiscTotal('registration', $res['replid']);
$kurangan = $dpp - getTerbayar('registration', $res['replid']);
// var_dump($kurangan);exit();
$out .= '<tr>
<td>' . $res['nis'] . '</td>
<td>' . $res['nama'] . '</td>
<td align="right">Rp. ' . number_format($dpp) . '</td>
<td align="right">Rp. ' . number_format($kurangan) . '</td>
<td align="center">' . getTglTrans($res['replid'], 'registration') . '</td>
' . $btn . '
</tr>';
}
} else {
#kosong
$out .= '<tr align="center">
<td colspan=9 ><span style="color:red;text-align:center;">
function getBiayaNet($typ, $siswa)
{
$biayaNet = getBiaya($typ, $siswa) - getDiscTotal($siswa);
return $biayaNet;
}
function akanBayarOpt($typ, $siswa)
{
$biayaKotor = getBiaya($typ, $siswa);
// 15.000.000
$diskonTotal = getDiscTotal($typ, $siswa);
// 900.000
// __________ -
$biaya = $biayaKotor - $diskonTotal;
// 14.100.000
$angsurkali = getSiswaBy('jmlangsur', $siswa);
// 3 x use
$terbayar = getTerbayar($typ, $siswa);
// 4.700.000
$angsurnom = $biaya / $angsurkali;
// @4.700.000 use
$sisabayar = $biaya - $terbayar;
// 9.400.000
// var_dump($diskonTotal);exit();
$ret = array();
$nominal = 0;
$count = $sisabayar / $angsurnom;
// 1 x
for ($i = 1; $i <= $count; $i++) {
$nominal += $angsurnom;
$ret[] = array('idAngsur' => $i, 'nomAngsur' => 'Rp. ' . number_format($nominal));
}
return $ret;
}
$hint = 'lunas';
$func = 'onclick="pembayaranFR(\'dpp\',' . $res['replid'] . ');"';
} else {
// kurang
$clr = 'yellow';
$icon = 'half';
$hint = 'kurang';
$func = 'onclick="pembayaranFR(\'dpp\',' . $res['replid'] . ');"';
}
}
$btn = '<td align="center">
<button data-hint="' . $hint . '" class="fg-white bg-' . $clr . '" ' . $func . '>
<i class="icon-battery-' . $icon . '"></i>
</button>
</td>';
$dpp = getBiaya('dpp', $res['replid']) - getDiscTotal('dpp', $res['replid']);
$kurangan = $dpp - getTerbayar('dpp', $res['replid']);
$out .= '<tr>
<td>' . $res['nis'] . '</td>
<td>' . $res['nama'] . '</td>
<td align="right">Rp. ' . number_format($dpp) . '</td>
<td align="right">Rp. ' . number_format($kurangan) . '</td>
<td align="center">' . getTglTrans($res['replid'], 'dpp') . '</td>
' . $btn . '
</tr>';
}
} else {
#kosong
$out .= '<tr align="center">
<td colspan=9 ><span style="color:red;text-align:center;">
... data tidak ditemukan...</span>
$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']),
'spp' =>setuang($r['spp']),
'daftar' =>setuang($r['daftar']),
// data siswa
'nopendaftaranH' =>$r['nopendaftaran'],
'nopendaftaran' =>$nopendaftaran,
'namaSiswa' =>$r['namaSiswa'],
'proses' =>$proses,
'kelompok' =>$r['kelompok'],
'kriteria' =>$r['kriteria'],
'golongan' =>$r['golongan'],
'kelamin' =>$r['kelamin'],
'tmplahir' =>$r['tmplahir'],
-- 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,
d.nama departemen,
akt.tahunajaran tahunajaran,
k.kelompok kelompok,
t.nopendaftaran nopendaftaran,
t.status statusx,
t.nama as nama_siswa,
if(t.kelamin="L","Laki-Laki","Perempuan") jk,
