AND t.tanggal BETWEEN "' . tgl_indo6($_GET['tgl1']) . '" AND "' . tgl_indo6($_GET['tgl2']) . '" ORDER BY t.tanggal ASC'; $e3 = mysql_query($s3); $keluarTot = 0; if (mysql_num_rows($e3) <= 0) { $out .= '<tr> <td colspan="4" align="center">data kosong</td> </tr>'; } else { while ($r3 = mysql_fetch_assoc($e3)) { $keluarTot += $r3['nominal']; $out .= '<tr> <td width="10%">' . tgl_indo5($r3['tanggal']) . '</td> <td width="20%">' . getNoKwitansi($r3['idTransaksi']) . '</td> <td width="30%">' . $r3['uraian'] . '</td> <td align="right" width="20%">' . setuang($r3['nominal']) . '</td> </tr>'; } } $out .= '</tbody> <tfoot> <tr class="info fg-white"> <th colspan="3" align="right">Jumlah : </th> <th align="right">' . setuang($keluarTot) . '</th> </tr> </tfoot> </table>'; $saldoAkhir = $r['nominal'] + $masukTot - $keluarTot; $out .= '<table width="100%">
<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 $out .= '<tr align="center"> <td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } $out .= '</table> </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,
<th width="18%">No. Transaksi</th> <th width="30%">Uraian</th> <th width="20%">Debet</th> <th width="20%">Kredit</th> </tr> </thead> <tbody>'; $debitTot = $kreditTot = 0; while ($r2 = mysql_fetch_assoc($e2)) { $debit = $r2['jenisrekening'] == 'd' ? setuang($r2['nominal']) : ''; $kredit = $r2['jenisrekening'] == 'k' ? setuang($r2['nominal']) : ''; $debitTot += $debit == '' ? 0 : $r2['nominal']; $kreditTot += $kredit == '' ? 0 : $r2['nominal']; $out .= '<tr > <td width="10%">' . tgl_indo5($r2['tanggal']) . '</td> <td width="20%">' . getNoKwitansi($r2['replid']) . '</td> <td width="30%">' . $r2['uraian'] . '</td> <td align="right" width="20%">' . $debit . '</td> <td align="right" width="20%">' . $kredit . '</td> </tr>'; } $selisihDebit = $debitTot - $kreditTot >= 0 ? setuang($debitTot - $kreditTot) : ''; $selisihKredit = $debitTot - $kreditTot < 0 ? setuang(abs($debitTot - $kreditTot)) : ''; $out .= '</tbody> <tfoot> <tr class="head"> <th colspan="3" align="right">Total</th> <th align="right">' . ($debitTot != 0 ? setuang($debitTot) : '') . '</th> <th align="right">' . ($kreditTot != 0 ? setuang($kreditTot) : '') . '</th> </tr> <tr class="head">
while ($r1 = mysql_fetch_assoc($e1)) { $out .= '<table width="100%"> <tr> <td width="36%"> <img width="100" src="../../images/logo.png" alt="" /> </td> <td> <b>Kwitansi Transaksi ' . $JTrans . '</b> </td> </tr> </table><br />'; // start of header $out .= '<table width="100%"> <tr> <td width="20%" >No. Kwitansi </td> <td>: ' . getNoKwitansi($r1['replid']) . '</td> </tr> <tr> <td>No. Bukti</td> <td>: ' . ($r1['nobukti'] == '' ? '-' : $r1['nobukti']) . '</td> </tr> <tr> <td>Tanggal</td> <td>: ' . tgl_indo8($r1['tanggal']) . '</td> </tr> <tr> <td>Uraian</td> <td>: ' . $r1['uraian'] . '</td> </tr>'; if ($JTrans == 'pengeluaran') { $out .= '<tr>