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>