<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>
</tr><tr>
<td width="20%">Nama Lengkap</td>
<td>: ' . $r['nama'] . '</td>
</tr><tr>
<td width="20%">Jenis Kelamin</td>
<td>: ' . $r['kelamin'] . '</td>
m.rek3,
m.nama modul,
m.replid idmodul
FROM
keu_modulpembayaran m
LEFT JOIN keu_katmodulpembayaran k ON k.replid = m.katmodulpembayaran
LEFT JOIN keu_pembayaran p ON p.modul = m.replid
WHERE
m.angkatan = ' . $ang . ' AND
k.nama = "spp"';
// var_dump($s2);exit();
$e2 = mysql_query($s2);
// var_dump($s2);exit();
$r2 = mysql_fetch_assoc($e2);
$stat = $e2 ? 'sukses' : 'gagal';
$out = json_encode(array('status' => $stat, 'datax' => array('nis' => getSiswaBy('nis', $sis), 'idsiswa' => $sis, 'siswa' => getSiswaBy('nama', $sis), 'nomer' => getNoTrans($_POST['subaksi']), 'tanggal' => tgl_indo5(date('Y-m-d')), 'rekkas' => $r2['rek1'], 'rekitem' => $r2['rek2'], 'rek1' => getRekening($r2['rek1']), 'rek2' => getRekening($r2['rek2']), 'rek3' => getRekening($r2['rek3']), 'modul' => $r2['modul'], 'idmodul' => $r2['idmodul'], 'status' => getStatusBayar('spp', $_POST['replid']), 'nominal' => 'Rp. ' . number_format(getBiaya('spp', $sis)))));
break;
}
break;
// ambiledit ------------------------------------------------------------------
// generate barcode -----------------------------------------------------------
// ambiledit ------------------------------------------------------------------
// generate barcode -----------------------------------------------------------
case 'kodegenerate':
$s = 'SELECT
tb1.lokasi,
tb1.grup,
tb1.tempat,
tb1.katalog,
tb2.barang,
LPAD(tb2.barang,5,0)barkode
function getBiayaNet($typ, $siswa)
{
$biayaNet = getBiaya($typ, $siswa) - getDiscTotal($siswa);
return $biayaNet;
}
<td width="15%" align="center">Tanggal Bayar</td>
</tr>';
$nox = 1;
$totbayar = 0;
if ($n == 0) {
$out .= '<tr>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
</tr>';
} else {
while ($r2 = mysql_fetch_assoc($e2)) {
$biaya = getBiaya($pre, $r2['replid']);
$terbayar = getTerbayar($pre, $r2['replid']);
$status = getStatusBayar($pre, $r2['replid']);
// var_dump($status);exit();
if ($status == 'lunas') {
$clr = 'lightGreen';
} else {
// belum
$clr = 'pink';
}
$out .= '<tr>
<td align="right">' . $nox . '.</td>
<td align="center">' . $r2['nis'] . '</td>
<td>' . $r2['nama'] . '</td>
<td align="right">Rp. ' . number_format($biaya) . '</td>
<td style="background-color:' . $clr . '" align="center">' . $status . '</td>
</tr>';
$nox = 1;
$totbayar = $totkurang = 0;
if ($n == 0) {
$out .= '<tr>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
</tr>';
} else {
$nox = 1;
while ($r2 = mysql_fetch_assoc($e2)) {
$biaya = getBiaya('joining fee', $r2['replid']);
$terbayar = getTerbayar('joining fee', $r2['replid']);
$kurangan = $biaya - $terbayar;
$status = getStatusBayar('joining fee', $r2['replid']);
if ($status == 'lunas') {
$clr = 'lightGreen';
} elseif ($status == 'kurang') {
$clr = 'yellow';
} else {
// belum
$clr = 'pink';
}
$out .= '<tr>
<td align="right">' . $nox . '.</td>
<td>' . $r2['nopendaftaran'] . '</td>
<td>' . $r2['nama'] . '</td>
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;
}
<td align="center">Tanggal Bayar</td>
</tr>';
$nox = 1;
$totbayar = $totkurang = 0;
if ($n == 0) {
$out .= '<tr>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
</tr>';
} else {
while ($r2 = mysql_fetch_assoc($e2)) {
$biaya = getBiaya('formulir', $r2['replid']);
$terbayar = getTerbayar('formulir', $r2['replid']);
$kurangan = $biaya - $terbayar;
$status = getStatusBayar('formulir', $r2['replid']);
if ($status == 'lunas') {
$clr = 'lightGreen';
} elseif ($status == 'kurang') {
$clr = 'yellow';
} else {
// belum
$clr = 'pink';
}
$out .= '<tr>
<td align="right">' . $nox . '.</td>
<td>' . $r2['nopendaftaran'] . '</td>
<td>' . $r2['nama'] . '</td>
/* kakek nenek*/
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']),
function getDiscTunai($typ, $siswa)
{
$s = 'SELECT nilai FROM psb_disctunai WHERE replid =' . getSiswaBy('disctunai', $siswa);
$e = mysql_query($s);
$r = mysql_fetch_assoc($e);
$biaya = getBiaya($typ, $siswa);
$ret = $r['nilai'] * $biaya / 100;
return $ret;
}
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
-- 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
$nox = 1;
$totdpp = 0;
$totkurang = 0;
if ($n == 0) {
$out .= '<tr>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>-</td>
</tr>';
} else {
while ($r = mysql_fetch_assoc($e)) {
$dpp = getBiaya('dpp', $r['replid']) - getDiscTotal('dpp', $r['replid']);
$kurangan = $dpp - getTerbayar('dpp', $r['replid']);
$status = getStatusBayar('dpp', $r['replid']);
if ($status == 'lunas') {
$clr = 'lightGreen';
} elseif ($status == 'kurang') {
$clr = 'yellow';
} else {
// belum
$clr = 'pink';
}
$out .= '<tr>
<td align="right">' . $nox . '.</td>
<td>' . $r['nis'] . '</td>
<td>' . $r['nama'] . '</td>
<td align="right">Rp. ' . number_format($dpp) . ',-</td>