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
WHERE transaksi =' . $r['replid'] . ' ORDER BY jenisrekening ASC '; $e2 = mysql_query($s2); $tb2 = ''; if (mysql_num_rows($e2) != 0) { $tb2 .= '<table class="isi" width="100%"> <tr class="head"> <td width="60%">Rekening</td> <td width="20%">Debit</td> <td width="20%">Kredit</td> </tr>'; while ($r2 = mysql_fetch_assoc($e2)) { $debit = $r2['jenisrekening'] == 'd' ? setuang($r2['nominal']) : '-'; $kredit = $r2['jenisrekening'] == 'k' ? setuang($r2['nominal']) : '-'; $tb2 .= '<tr> <td width="60%">' . getRekening($r2['detilrekening']) . '</td> <td width="20%" align="right">' . $debit . '</td> <td width="20%" align="right">' . $kredit . '</td> </tr>'; } $tb2 .= '</table>'; } $out .= '<tr> <td width="12%" valign="top">' . tgl_indo5($r['tanggal']) . '</td> <td width="18%" valign="top" style="font-weight:bold;">' . getNoKwitansi($r['replid']) . '<br>' . $r['nobukti'] . '</td> <td width="15%" valign="top">' . $r['uraian'] . '</td> <td width="55%">' . $tb2 . '</td> </tr>'; } } else { #kosong
while ($r2 = mysql_fetch_assoc($e2)) { if ($jTrans == 'ju') { $debit = $r2['jenis'] == 'd' ? $r2['nominal'] : 0; $kredit = $r2['jenis'] == 'k' ? $r2['nominal'] : 0; } else { if ($jTrans == 'out') { $debit = $r2['rek'] == $r1['rekitem'] ? $r1['nominal'] : 0; $kredit = $r2['rek'] == $r1['rekkas'] ? $r1['nominal'] : 0; } else { // in $debit = $r2['rek'] == $r1['rekkas'] ? $r1['nominal'] : 0; $kredit = $r2['rek'] == $r1['rekitem'] ? $r1['nominal'] : 0; } } $tb2 .= '<tr> <td width="60%" >' . getRekening($r2['rek']) . '</td> <td width="20%" align="right" >Rp. ' . number_format($debit) . ',-</td> <td width="20%" align="right" >Rp. ' . number_format($kredit) . ',-</td> </tr>'; } $tb2 .= '</table>'; } $out .= '<tr> <td>' . tgl_indo($r1['tanggal']) . '</td> <td>' . $r1['nomer'] . '<br>' . getDetJenisTrans2($r1['replid']) . '<br>' . $r1['nobukti'] . '</td> <td>' . $r1['uraian'] . '</td> <td>' . $tb2 . '</td> </tr>'; } } $out .= '</table>';
<td align="center">Nama Kategori</td> <td align="center">Rekening</td> <td align="center">Keterangan</td> </tr>'; $nox = 1; if($n==0){ $out.='<tr> <td>-</td> <td>-</td> <td>-</td> </tr>'; }else{ while ($r=mysql_fetch_assoc($e)) { $out.='<tr> <td>'.$r['nama'].'</td> <td>'.getRekening($r['rekening']).'</td> <td>'.$r['keterangan'].'</td> </tr>'; $nox++; } } $out.='</table>'; // $out.='<p>Total : '.$n.'</p>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf=new mPDF('c','A4',''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
$debit2 = $r1['nominal']; $kredit2 = 0; } else { // in $debit1 = $r1['nominal']; $kredit1 = 0; $debit2 = 0; $kredit2 = $r1['nominal']; } } $out .= '<tr> <td>' . getRekening($r1['rekkas']) . '</td> <td align="right">Rp. ' . number_format($debit1) . '</td> <td align="right">Rp. ' . number_format($kredit1) . '</td> </tr><tr> <td>' . getRekening($r1['rekitem']) . '</td> <td align="right">Rp. ' . number_format($debit2) . '</td> <td align="right">Rp. ' . number_format($kredit2) . '</td> </tr>'; $out .= '<tr class="head"> <td ></td> <td colspan="2" align="center">Rp. ' . number_format($r1['nominal']) . '</td> </tr>'; $out .= '</table><br>'; } // end of detail table } $out .= '</body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents();
SELECT replid from keu_jurnal WHERE transaksi = t.replid and jenisrekening="k" )idjurnal FROM keu_transaksi t WHERE t.replid =' . $_POST['replid']; // pr($s); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; if (!$e) { $stat = 'gagal'; } else { //sukses $stat = 'sukses'; $kodekas = getField('kode', 'keu_detilrekening', 'replid', $r['idrekkas']); $namakas = getField('nama', 'keu_detilrekening', 'replid', $r['idrekkas']); $transaksiArr = array('nomer' => getNoKwitansi($_POST['replid']), 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'idrekkas' => $r['idrekkas'], 'rekkas' => $kodekas . ' - ' . $namakas, 'saldokas' => setuang(getSaldoRekeningSkrg($r['idrekkas'])), 'detjenistransaksi' => $r['detjenistransaksi'], 'income' => array('departemen' => $r['departemen'], 'tingkat' => $r['tingkat'], 'idjurnal' => $r['idjurnal'], 'idrekitem' => $r['idrekitem'], 'rekitem' => getRekening($r['idrekitem']), 'rekitemsaldo' => setuang(getSaldoRekeningSkrg($r['idrekitem'])), 'nominal' => setuang($r['nominal']), 'uraian' => $r['uraian'])); } $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr)); break; case 'ju': $s = 'SELECT * FROM ' . $tb . ' WHERE replid=' . $_POST['replid']; // var_dump($s);exit(); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; if (!$e) { $stat = 'gagal'; } else { //sukses $s2 = ' SELECT j.replid,
j.replid idjurnal FROM ' . $tb . ' t LEFT JOIN keu_jurnal j on j.transaksi = t.replid WHERE t.replid =' . $_POST['replid'] . ' AND j.jenis ="d"'; // var_dump($s);exit(); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; if (!$e) { $stat = 'gagal'; } else { //sukses $stat = 'sukses'; $transaksiArr = array('nomer' => $r['nomer'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'idrekkas' => $r['rekkas'], 'rekkas' => getRekening($r['rekkas']), 'income' => array('idjurnal' => $r['idjurnal'], 'idrekitem' => $r['rekitem'], 'rekitem' => getRekening($r['rekitem']), 'nominal' => setuang($r['nominal']), 'uraian' => $r['uraian'])); } $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr)); break; case 'ju': $s = 'SELECT * FROM ' . $tb . ' WHERE replid=' . $_POST['replid']; // var_dump($s);exit(); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; if (!$e) { $stat = 'gagal'; } else { //sukses $s2 = 'SELECT * FROM keu_jurnal WHERE transaksi =' . $_POST['replid'] . ' ORDER BY jenis ASC'; $e2 = mysql_query($s2);
s.tahunajaran, m.angkatan, m.bulan, m.katmodulpembayaran, s.semester, t.departemen FROM ' . $tb . ' m LEFT JOIN keu_katmodulpembayaran k on k.replid = m.katmodulpembayaran LEFT JOIN aka_semester s on s.replid = m.semester LEFT JOIN aka_tahunajaran t on t.replid = s.tahunajaran WHERE m.replid =' . $_POST['replid']; $e = mysql_query($s); $r = mysql_fetch_assoc($e); // var_dump($r);exit(); $out = json_encode(array('katmodulpembayaran' => $r['katmodulpembayaran'], 'departemen' => $r['departemen'], 'angkatan' => $r['angkatan'], 'tahunajaran' => $r['tahunajaran'], 'semester' => $r['semester'], 'bulan' => $r['bulan'], 'idrek1' => $r['rek1'], 'idrek2' => $r['rek2'], 'idrek3' => $r['rek3'], 'rek1' => getRekening($r['rek1']), 'rek2' => getRekening($r['rek2']), 'rek3' => getRekening($r['rek3']), 'keterangan' => $r['keterangan'])); break; // ambiledit ----------------------------------------------------------------- // cmbkategorirek ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- // cmbkategorirek ----------------------------------------------------------------- case 'cmbkategorirek': $w = ''; if (isset($_POST['replid'])) { $w = 'where replid =' . $_POST['replid']; } else { if (isset($_POST[$mnu])) { $w = 'where ' . $mnu . '=' . $_POST[$mnu]; } } $s = ' SELECT *
$out .= '<table class="isi" width="100%"> <tr class="head"> <td align="center">Rekening</td> <td align="center">Debit</td> <td align="center">Kredit</td> </tr>'; $s2 = 'SELECT * FROM keu_jurnal WHERE transaksi =' . $r1['replid'] . ' ORDER BY jenisrekening ASC'; $e2 = mysql_query($s2); $debitTot = $krditTot = 0; while ($r2 = mysql_fetch_assoc($e2)) { $debit = $r2['jenisrekening'] == 'd' ? $r2['nominal'] : 0; $kredit = $r2['jenisrekening'] == 'k' ? $r2['nominal'] : 0; $debitTot += $debit; $kreditTot += $kredit; $out .= '<tr> <td>' . getRekening($r2['detilrekening']) . '</td> <td align="right">' . setuang($debit) . '</td> <td align="right">' . setuang($kredit) . '</td> </tr>'; } $out .= '<tr class="head"> <td></td> <td align="right">' . setuang($debitTot) . '</td> <td align="right">' . setuang($kreditTot) . '</td> </tr>'; $out .= '</table><br>'; } // end of detail table } $out .= '</body>'; echo $out;
ORDER BY jenis ASC'; $e2 = mysql_query($s2); $tb2 = ''; if (mysql_num_rows($e2) != 0) { $tb2 .= '<table class="isi" width="100%"> <tr class="head"> <td width="60%">Rekening</td> <td width="20%">Debit</td> <td width="20%">Kredit</td> </tr>'; while ($r2 = mysql_fetch_assoc($e2)) { $debit = $r2['rek'] == $r['rekkas'] ? $r['nominal'] : 0; $kredit = $r2['rek'] == $r['rekitem'] ? $r['nominal'] : 0; $tb2 .= '<tr> <td>' . getRekening($r2['rek']) . '</td> <td align="right">Rp. ' . number_format($debit) . ',-</td> <td align="right">Rp. ' . number_format($kredit) . ',-</td> </tr>'; } $tb2 .= '</table>'; } $out .= '<tr> <td width="10%" valign="top">' . tgl_indo7($r['tanggal']) . '</td> <td valign="top" width="15%">' . $r['nomer'] . '<br>' . getDetJenisTrans2($r['replid']) . '<br>' . $r['nobukti'] . '</td> <td valign="top" width="30%">' . $r['uraian'] . '</td> <td width="40%" valign="top">' . $tb2 . '</td> </tr>'; } } $out .= '</table>';