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
$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>
<td align="center">' . getTglTrans($r2['replid'], $pre) . '</td>
</tr>';
$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>
<td align="right">Rp. ' . number_format($biaya) . '</td>
<td align="right">Rp. ' . number_format($kurangan) . '</td>
<td style="background-color:' . $clr . '" align="center">' . $status . '</td>
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>
<td align="right">Rp. ' . number_format($biaya) . '</td>
<td align="right">Rp. ' . number_format($kurangan) . '</td>
<td style="background-color:' . $clr . ';" align="center">' . $status . '</td>
$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>
<td align="right">Rp. ' . number_format($kurangan) . ',-</td>
<td style="background-color:' . $clr . '" align="center">' . $status . '</td>
