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