}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('act' => $act, 'error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
}
die_login();
die_app('M');
die_mod('M15');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
$obj = $conn->Execute("\n\t\tSELECT \n\t\ts.NO_VA,\n\t\ts.KODE_BLOK,\n\t\ts.LUAS_BANGUNAN,\n\t\ts.STATUS_STOK,\n\t\ts.TERJUAL,\n\t\ts.KODE_PENJUALAN,\n\t\tt.TIPE_BANGUNAN,\n\t\ths.KODE_SK,\n\t\ths.HARGA_CASH_KERAS,\n\t\ths.CB36X,\n\t\ths.CB48X,\n\t\ths.KPA24X,\n\t\ths.KPA36X,\n\t\th.*,\n\t\tju.*,\n\t\tt.*,\n\t\tp.*\n\t\tFROM \n\t\tSTOK s\n\t\tLEFT JOIN TIPE t ON s.KODE_TIPE = t.KODE_TIPE\n\t\tLEFT JOIN HARGA_SK hs ON s.KODE_SK = hs.KODE_SK AND s.KODE_BLOK = hs.KODE_BLOK\n\t\tLEFT JOIN LOKASI h ON s.KODE_LOKASI = h.KODE_LOKASI\n\t\tLEFT JOIN JENIS_UNIT ju ON s.KODE_UNIT = ju.KODE_UNIT\n\t\tLEFT JOIN JENIS_PENJUALAN p ON s.KODE_PENJUALAN = p.KODE_JENIS\n\t\tWHERE\t\t\n\t\ts.KODE_BLOK = '{$id}'");
$no_va = $obj->fields['NO_VA'];
$kode_blok = $obj->fields['KODE_BLOK'];
$kode_lokasi = $obj->fields['KODE_LOKASI'];
$kode_unit = $obj->fields['KODE_UNIT'];
$kode_tipe = $obj->fields['KODE_TIPE'];
$kode_penjualan = $obj->fields['KODE_PENJUALAN'];
$kode_sk = $obj->fields['KODE_SK'];
$lokasi = $obj->fields['LOKASI'];
$jenis_unit = $obj->fields['JENIS_UNIT'];
$tipe_bangunan = $obj->fields['TIPE_BANGUNAN'];
<?php
require_once '../../../../config/config.php';
die_login();
die_app('A01');
die_mod('PT02');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
$query_search .= "WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(KODE_BLOK) AS TOTAL\nFROM \n\tRESERVE\n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>
<table id="pagging-1" class="t-control">
<tr>
<td class="text-right">
<input type="button" id="prev_page" value=" < ">
Hal : <input type="text" name="page_num" size="5" class="page_num apply text-center" value="<?php
echo $page_num;
ex_empty($cb_data, 'Pilih data yang akan diverifikasi.');
foreach ($cb_data as $id_del) {
$query = "UPDATE KWITANSI SET \n\t\t\t\t\tVER_KEUANGAN = 1,\n\t\t\t\t\tVER_KEUANGAN_TANGGAL = CONVERT(DATETIME,'{$tgl}',105),\n\t\t\t\t\tVER_KEUANGAN_OFFICER = '{$officer}'\n\t\t\t\t\tWHERE NOMOR_KWITANSI = '{$id_del}'";
if ($conn->Execute($query)) {
$act[] = $id_del;
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data kwitansi gagal diverifikasi.' : 'Data kwitansi berhasil diverifikasi.';
}
}
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('act' => $act, 'error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
}
die_login();
die_app('');
die_mod('');
$conn = conn($sess_db);
die_conn($conn);
<?php
require_once '../../../../config/config.php';
die_login();
die_app('C01');
die_mod('COL03');
$conn = conn($sess_db);
die_conn($conn);
$msg = '';
$error = FALSE;
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
$conn->begintrans();
$no_surat_akhir = isset($_REQUEST['no_surat_akhir']) ? clean($_REQUEST['no_surat_akhir']) : '';
$registrasi = isset($_REQUEST['registrasi']) ? clean($_REQUEST['registrasi']) : '';
$conn->Execute("DELETE FROM REGISTRASI_SURAT");
$query = "\n\t\tINSERT INTO REGISTRASI_SURAT (\n\t\tNO_SURAT_AKHIR, REGISTRASI\n\t\t)\n\t\tVALUES (\n\t\t'{$no_surat_akhir}', '{$registrasi}'\n\t\t)\n\t\t";
ex_false($conn->Execute($query), $query);
$conn->committrans();
$msg = 'Parameter berhasil diubah.';
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
$conn->rollbacktrans();
}
close($conn);
$json = array('msg' => $msg, 'error' => $error);
echo json_encode($json);
exit;
}
include 'marketing/menu.php';
break;
case 'C01':
die_app($sess_app_id);
include 'collection_tunai/menu.php';
break;
case 'C02':
die_app($sess_app_id);
include 'collection_kpr/menu.php';
break;
case 'C03':
die_app($sess_app_id);
include 'ppjb/menu.php';
break;
case 'C04':
die_app($sess_app_id);
include 'kredit/menu.php';
break;
}
?>
</ul>
<div id="profil">
<a href="index.php"><?php
echo $_SESSION['FULL_NAME'];
?>
</a> |
<a href="authentic.php?act=logout">Logout</a>
</div>
<div class="clear"></div>
</div>
