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 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;
}
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;
}
