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>
