d.nama LIKE "%'.$searchTerm.'%"
OR k.nama LIKE "%'.$searchTerm.'%"
GROUP BY
d.replid ';
*/
// var_dump($s);exit();
$e = mysql_query($s);
$r = mysql_fetch_assoc($e);
$stat = $e ? 'sukses' : 'gagal';
if (!$e) {
$stat = 'gagal';
} else {
//sukses
$kuota = getKuotaAnggaran($r['detilanggaran']);
$stat = 'sukses';
$transaksiArr = array('nomer' => $r['nomer'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'idrekkas' => $r['rekkas'], 'rekkas' => getRekening($r['rekkas']), 'iddetilanggaran' => $r['detilanggaran'], 'detilanggaran' => getAnggaran($r['detilanggaran']), 'kuotaBilCur' => 'Rp. ' . number_format($kuota['kuotaNum']), 'sisaBilCur' => 'Rp. ' . number_format($kuota['sisaNum']), 'terpakaiBilCur' => 'Rp. ' . number_format($kuota['terpakaiNum']), 'sisaBilNum' => $kuota['sisaNum'], 'outcome' => 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 'in_come':
$s = 'SELECT
t.*,
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);
<tr>
<td>No. Bukti</td>
<td>: ' . $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 ($jenisTrans == 'pengeluaran') {
$out .= '<tr>
<td>Detail Anggaran</td>
<td>: ' . getAnggaran($r1['detilanggaran']) . '</td>
</tr>';
}
$out .= '</table>';
// end of header
// start of detail table
$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>';
$totbayar = 0;
if ($jenisTrans2 != 'ju') {
if ($jenisTrans2 == 'out') {
$debit1 = 0;
$stat = $e ? 'sukses' : 'gagal';
if (!$e) {
$stat = 'gagal';
} else {
//sukses
$kuotaNum = getDetAnggaran($r['detilanggaran'], 'kuotaNum');
$kuotaCur = setuang(getDetAnggaran($r['detilanggaran'], 'kuotaNum'));
// var_dump($kuotaCur);exit();
$terpakaiNum = getDetAnggaran($r['detilanggaran'], 'terpakaiNum');
$terpakaiCur = setuang(getDetAnggaran($r['detilanggaran'], 'terpakaiNum'));
$sisaNum = getDetAnggaran($r['detilanggaran'], 'sisaNum');
$sisaCur = setuang(getDetAnggaran($r['detilanggaran'], 'sisaNum'));
$stat = 'sukses';
$nobuktiTyp = strpos($r['nobukti'], 'INV') === false ? '0' : '1';
//==TRUE?1:0;
$transaksiArr = array('nomer' => $r['nomer'], 'nobuktiTyp' => $nobuktiTyp, 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'idrekkas' => $r['rekkas'], 'rekkas' => getRekening($r['rekkas']), 'outcome' => array('iddetilanggaran' => $r['detilanggaran'], 'detilanggaran' => getAnggaran($r['detilanggaran']) . '[sisa :' . $sisaCur . ' kuota ' . $kuotaCur . ']', 'sisaanggaran' => $sisaNum, 'sisaanggaran' => $sisaNum, '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 'in_come':
$s = 'SELECT
t.*,
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);
