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);