$out .= '<body>
<table width="100%">
<tr>
<td width="40 %">
<img width="100" src="../../images/logo.png" alt="" />
</td>
<td>
<b>Jurnal Umum</b>
</td>
</tr>
</table><br />';
$out .= '<table width=100%"">
<tr>
<td>Tanggal : ' . $_GET['tgl1TB'] . ' s/d ' . $_GET['tgl2TB'] . '</td>
<td align="right">Tahun Buku :</td>
<td width="5%" align="right">' . getTahunBuku('nama') . '</td>
</tr>';
$out .= '</table>';
$out .= '<table class="isi" width="100%">
<tr class="head">
<td align="center">Tanggal </td>
<td align="center">No. Jurnal/Jenis Bukti/No.Bukti</td>
<td align="center">Uraian</td>
<td align="center">Detil Jurnal</td>
</tr>';
$nox = 1;
$totbayar = 0;
if ($n1 == 0) {
$out .= '<tr>
<td>-</td>
<td>-</td>
if (!$e2) {
$stat = 'gagal_insert_transaksi';
} else {
// 3. simpan jurnal
$s3 = 'INSERT INTO keu_jurnal SET transaksi =' . $id2 . ', rek =' . $_POST['rekkasH'] . ', jenis = "d", nominal =' . $nominal;
$s4 = 'INSERT INTO keu_jurnal SET transaksi =' . $id2 . ', rek =' . $_POST['rekitemH'] . ',jenis = "k", nominal =' . $nominal;
// $s3 = 'INSERT INTO keu_jurnal SET transaksi ='.$id2.', rek ='.$_POST['rekkasH'].', debet ='.$nominal;
// $s4 = 'INSERT INTO keu_jurnal SET transaksi ='.$id2.', rek ='.$_POST['rekitemH'].', kredit ='.$nominal;
$e3 = mysql_query($s3);
$e4 = mysql_query($s4);
if (!$e3 or !$e4) {
$stat = 'gagal_insert_jurnal';
} else {
// 4. update saldo rekening
$s5 = 'UPDATE keu_saldorekening SET nominal2 = nominal2 + ' . $nominal . ' WHERE rekening =' . $_POST['rekkasH'] . ' AND tahunbuku=' . getTahunBuku('replid');
$s6 = 'UPDATE keu_saldorekening SET nominal2 = nominal2 - ' . $nominal . ' WHERE rekening =' . $_POST['rekitemH'] . ' AND tahunbuku=' . getTahunBuku('replid');
// var_dump($s6);exit();
$e5 = mysql_query($s5);
$e6 = mysql_query($s6);
$stat = ($e5 or $e6) ? 'sukses' : 'gagal_update_saldorekening';
}
}
}
$out = json_encode(array('status' => $stat));
break;
// add / edit -----------------------------------------------------------------
// delete ---------------------------------------------------------------------
// add / edit -----------------------------------------------------------------
// delete ---------------------------------------------------------------------
case 'hapus':
switch ($_POST['subaksi']) {
$tingKet = getTingkat('keterangan',$tingkat);
$out.='<body>
<table width="100%">
<tr>
<td width="41%">
<img width="100" src="../../images/logo.png" alt="" />
</td>
<td>
<b>Detil Anggaran</b>
</td>
</tr>
</table><br />
<table width="100%">
<tr>
<td width="10%">Tahun Buku </td>
<td>: '.getTahunBuku('nama').'</td>
<td></td>
</tr>
<tr>
<td width="10%">Kategori</td>
<td>: '.$katAnggaranNama.' ('.$katAnggaranKet.')</td>
<td></td>
</tr>
<tr>
<td width="10%">Tingkat</td>
<td>: '.$tingNama.'('.$tingKet.')</td>
<td></td>
</tr>
<tr>
<td>Departemen</td>
<td>: '.$depNama.'</td>
d.kategorirekening ASC,
d.kode ASC';
*/
$e = mysql_query($s) or die(mysql_error());
$n = mysql_num_rows($e);
$out .= '<body>
<table width="100%">
<tr>
<td width="40%">
<img width="100" src="../../images/logo.png" alt="" />
</td>
<td>
<b>Neraca Saldo</b>
</td>
<td align="right">
<b>Tahun Buku : ' . getTahunBuku('nama') . '</b>
</td>
</tr>
</table><br />';
$out .= '<table class="isi" width="100%">
<tr class="head">
<td align="center">Kode Rekening </td>
<td align="center">Nama Rekening</td>
<td align="center">Debet</td>
<td align="center">Kredit</td>
</tr>';
$nox = 1;
$debetTot = $kreditTot = 0;
if ($n == 0) {
$out .= '<tr>
<td>-</td>
<td colspan=9 ><span style="color:red;text-align:center;">
... data tidak ditemukan...</span></td></tr>';
}
#link paging
$out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>';
$out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>';
break;
// view -----------------------------------------------------------------
// add / edit -----------------------------------------------------------------
// view -----------------------------------------------------------------
// add / edit -----------------------------------------------------------------
case 'simpan':
$s = $tb . ' set nama = "' . filter($_POST['namaTB']) . '",
tanggal1 = "' . filter($_POST['tanggal1TB']) . '",
keterangan = "' . filter($_POST['keteranganTB']) . '"';
$thBukuLama = getTahunBuku('replid');
if (!isset($_POST['replid'])) {
//add
if (mysql_num_rows(mysql_query('SELECT * from ' . $tb)) > 0) {
$s1 = 'UPDATE ' . $tb . ' set aktif="0"';
$e1 = mysql_query($s1);
}
$s2 = 'INSERT INTO ' . $s . ' ,aktif = "1"';
} else {
//edit
$s2 = 'UPDATE ' . $s . ' WHERE replid=' . $_POST['replid'];
}
// var_dump($thBukuLama);exit();
// $ssr = 'SELECT max(replid) from keu_tahunbuku';
// $esr = mysql_query($ssr);
// $rsr = mysql_fetch_assoc($esr);
</table>';
$saldoAkhir = $r['nominal'] + $masukTot - $keluarTot;
$out .= '<b class="fg-' . ($saldoAkhir < 0 ? 'red' : 'green') . ' place-right"> Saldo Akhir : ' . setuang($saldoAkhir) . '</b><br><br>';
$out .= '<hr>';
}
} else {
#kosong
$out .= '<tr align="center">
<td colspan=9 ><span style="color:red;text-align:center;">
... data tidak ditemukan...</span></td></tr>';
}
break;
//buku tambahan
//buku tambahan
case 'bt':
$out = '<div style="font-weight:bold;" class="text-right">Tahun Buku : ' . getTahunBuku('nama') . '</div>
<table class="table hovered bordered striped">
<thead>
<tr style="color:white;"class="info">
<th class="text-center">Tanggal </th>
<th class="text-center">Kode Rekening</th>
<th class="text-center">Nama Perkiraan</th>
<th class="text-center">No. Transaksi</th>
<th class="text-center">Uraian</th>
<th class="text-center">Debet</th>
<th class="text-center">Kredit</th>
</tr>
<tr style="display:none;" id="btTR" class="info">
<th class="text-center"></th>
<th class="text-center"><div class="input-control text"><input placeholder="cari" id="bt_kodeS" class="bt_cari"></div></th>
<th class="text-center"><div class="input-control text"><input placeholder="cari" id="bt_namaS" class="bt_cari"></div></th>
$ejk2 = mysql_query($sjd2);
$stat2 = (!$ejd2 and !$ejk2) ? false : true;
}
}
$stat = !$stat1 ? 'gagal_insert_transaksi' : (!$stat2 ? 'gagal_jurnal' : (!$stat3 ? 'gagal_update_saldoawal' : 'sukses'));
} else {
// out_come
// 1. simpan transaksi
$totNominal = 0;
$rekArr = $_POST[$sub . '_idTR'];
$stat1 = $stat2 = $stat3 = true;
// var_dump($rekArr);exit();
foreach ($rekArr as $i => $v) {
$nom = intval(getuang($_POST[$sub . '_nominal' . $v . 'TB']));
// $jenis = $_POST[$sub.'_jenis'.$v.'TB'];
$s1 = 'keu_transaksi SET tahunbuku =' . getTahunBuku('replid') . ',
rekkas =' . $_POST['rekkasH'] . ',
uraian ="' . $_POST[$sub . '_uraian' . $v . 'TB'] . '",
rekitem =' . $_POST[$sub . '_rek' . $v . 'H'] . ',
nominal =' . $nom . ',
nomer ="' . getNoTrans2($sub) . '",
tanggal ="' . tgl_indo6($_POST['tanggalTB']) . '",
detjenistrans =' . getDetJenisTrans('replid', 'kode', $_POST['detjenistransH']) . ',
detilanggaran =' . $_POST['detilanggaranH'] . ',
nobukti ="' . $_POST['nobuktiTB'] . '"';
$s = (isset($_POST['idformH']) and $_POST['idformH'] != '') ? 'UPDATE ' . $s1 . ' WHERE replid=' . $_POST['idformH'] : 'INSERT INTO ' . $s1;
$e = mysql_query($s);
$idx = mysql_insert_id();
$id = ($idx != '' or !empty($idx)) ? $idx : $_POST['idformH'];
// $id = (mysql_insert_id()!='' OR !empty(mysql_insert_id()))?mysql_insert_id():$_POST['idformH'];
// 2. simpan jurnal umum
$s = $tb . ' set nama = "' . filter($_POST['a_namaTB']) . '",
departemen = "' . filter($_POST['a_departemenH']) . '",
rekening = "' . filter($_POST['a_rekeningH']) . '",
keterangan = "' . filter($_POST['a_keteranganTB']) . '"';
$s2 = isset($_POST['replid']) ? 'UPDATE ' . $s . ' WHERE replid=' . $_POST['replid'] : 'INSERT INTO ' . $s;
$e = mysql_query($s2);
$stat = $e ? 'sukses' : 'gagal';
$out = json_encode(array('status' => $stat));
break;
// detil anggaran
// detil anggaran
case 'detilanggaran':
$su = 'keu_detilanggaran set tingkat = ' . $_POST['d_tingkatH'] . ',
nama = "' . $_POST['d_namaTB'] . '",
keterangan = "' . $_POST['d_keteranganTB'] . '",
tahunbuku = ' . getTahunBuku('replid');
if (isset($_POST['replid']) and $_POST['replid'] != '') {
$s1 = 'UPDATE ' . $su . ' WHERE replid=' . $_POST['replid'];
} else {
$s1 = 'INSERT INTO ' . $su . ',kategorianggaran=' . $_POST['d_kategorianggaranH2'];
}
$e1 = mysql_query($s1);
$id = mysql_insert_id();
if (!$e1) {
$stat = 'gagal_detilanggaran_' . mysql_error();
} else {
$stat = 'sukses';
if (isset($_POST['d_nominalTB'])) {
$stat2 = true;
$cc = '';
foreach ($_POST['d_nominalTB'] as $i => $v) {
</head>';
$out .= '<body>';
$s = 'SELECT
d.replid,
d.kode kode,
d.nama nama,
s.nominal saldoAwal,
s.nominal2 saldoAkhir
FROM
keu_transaksi t
LEFT JOIN keu_jurnal j ON t.replid = j.transaksi
LEFT JOIN keu_detilrekening d ON d.replid = j.rek
LEFT JOIN keu_kategorirekening k ON k.replid = d.kategorirekening
LEFT JOIN keu_saldorekening s ON s.rekening = d.replid
WHERE
t.tahunbuku=' . getTahunBuku('replid') . ' AND(
k.nama ="KAS" OR
k.nama ="BANK"
) AND t.tanggal between "' . tgl_indo6($_GET['tgl1TB']) . '" AND "' . tgl_indo6($_GET['tgl2TB']) . '"
GROUP BY
d.kode
ORDER BY
d.kategorirekening ASC,
d.kode ASC';
// var_dump($s);exit();
$e = mysql_query($s);
$jum = mysql_num_rows($e);
$out = '';
$totaset = 0;
if ($jum != 0) {
while ($r = mysql_fetch_assoc($e)) {
