$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$nm = isset($_REQUEST['nm']) ? clean($_REQUEST['nm']) : '';
$kode_desa = isset($_REQUEST['kode_desa']) ? to_number($_REQUEST['kode_desa']) : '';
$nama_desa = isset($_REQUEST['nama_desa']) ? clean($_REQUEST['nama_desa']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M02');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M02', 'U');
ex_empty($kode_desa, 'Kode desa harus diisi.');
ex_empty($nama_desa, 'Nama desa harus diisi.');
$query = "\n\t\t\tDELETE FROM DESA\n\t\t\tWHERE\n\t\t\t\tKODE_DESA = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data Desa berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
foreach ($cb_data as $id_del) {
if ($id_del == 9) {
$msg = 'Maaf Tagihan denda tidak bisa dihapus';
} else {
$query = "DELETE FROM TAGIHAN_LAIN_LAIN WHERE TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105)\n\t\t\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)\t\t\t\t\n\t\t\t\t\tAND KODE_BAYAR = {$id_del} AND KODE_BLOK = '{$kode}'";
if ($conn->Execute($query)) {
$act[] = $id_del;
} else {
$error = TRUE;
}
$msg = $error ? 'Sebagian data gagal dihapus.' : 'Data Tagihan berhasil dihapus.';
}
}
} elseif ($act == 'Pindah') {
ex_ha('C04', 'U');
ex_empty($blok_baru, 'Blok baru harus diisi.');
$query = "\n\t\t\tUPDATE KWITANSI \n\t\t\tSET\n\t\t\t\tKODE_BLOK = '{$blok_baru}', \n\t\t\t\tSTATUS_PINDAH_BLOK = '1'\n\t\t\tWHERE\n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->execute($query), $query);
$query = "\n\t\t\tUPDATE KWITANSI_LAIN_LAIN\n\t\t\tSET\n\t\t\t\tKODE_BLOK = '{$blok_baru}'\n\t\t\tWHERE\n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->execute($query), $query);
$msg = 'Blok berhasil dipindahkan.';
}
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
$faktor_strategis = isset($_REQUEST['faktor_strategis']) ? clean($_REQUEST['faktor_strategis']) : '';
$nilai_tambah = isset($_REQUEST['nilai_tambah']) ? to_decimal($_REQUEST['nilai_tambah']) : '';
$nilai_kurang = isset($_REQUEST['nilai_kurang']) ? to_decimal($_REQUEST['nilai_kurang']) : '';
$status = isset($_REQUEST['status']) ? to_number($_REQUEST['status']) : '0';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M05');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('PM03', 'D');
$act = array();
$cb_data = $_REQUEST['cb_data'];
ex_empty($cb_data, 'Pilih data yang akan dihapus.');
foreach ($cb_data as $id_del) {
if ($conn->Execute("DELETE FROM FAKTOR WHERE KODE_FAKTOR = '{$id_del}'")) {
$act[] = $id_del;
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data gagal dihapus.' : 'Data faktor strategis berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
$ar_modul_id = isset($_REQUEST['ar_modul_id']) ? $_REQUEST['ar_modul_id'] : array();
$ar_ronly = isset($_REQUEST['r_ronly']) ? $_REQUEST['r_ronly'] : array();
$ar_edit = isset($_REQUEST['r_edit']) ? $_REQUEST['r_edit'] : array();
$ar_insert = isset($_REQUEST['r_insert']) ? $_REQUEST['r_insert'] : array();
$ar_delete = isset($_REQUEST['r_delete']) ? $_REQUEST['r_delete'] : array();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
//ex_app('A');
ex_mod('A05');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('A05', 'U');
ex_empty($user_id, 'Pilih user ID.');
ex_empty($app_id, 'Pilih App ID.');
foreach ($ar_modul_id as $i => $modul_id) {
$conn->Execute("DELETE FROM APPLICATION_RIGHTS WHERE USER_ID = '{$user_id}' AND MODUL_ID = '{$modul_id}'");
$r_ronly = isset($ar_ronly[$modul_id]) ? $ar_ronly[$modul_id] : 'T';
$r_edit = isset($ar_edit[$modul_id]) ? $ar_edit[$modul_id] : 'T';
$r_insert = isset($ar_insert[$modul_id]) ? $ar_insert[$modul_id] : 'T';
$r_delete = isset($ar_delete[$modul_id]) ? $ar_delete[$modul_id] : 'T';
$query = "INSERT INTO APPLICATION_RIGHTS (USER_ID, MODUL_ID, R_RONLY, R_EDIT, R_INSERT, R_DELETE) VALUES \n\t\t\t(\n\t\t\t\t'{$user_id}',\n\t\t\t\t'{$modul_id}',\n\t\t\t\t\n\t\t\t\t'{$r_ronly}',\n\t\t\t\t'{$r_edit}',\n\t\t\t\t'{$r_insert}',\n\t\t\t\t'{$r_delete}'\n\t\t\t)";
ex_false($conn->Execute($query), $query);
}
$msg = "Hak akses modul berhasil diubah.";
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
<?php
require_once '../config/config.php';
$msg = '';
$error = FALSE;
$app_id = isset($_REQUEST['app_id']) ? clean($_REQUEST['app_id']) : '';
$login_id = isset($_REQUEST['login_id']) ? clean($_REQUEST['login_id']) : '';
$password_id = isset($_REQUEST['password_id']) ? clean($_REQUEST['password_id']) : '';
$db = isset($_REQUEST['db']) ? clean($_REQUEST['db']) : '';
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST' and $act == 'login') {
try {
ex_empty($app_id, 'Pilih APP.');
ex_empty($login_id, 'Masukkan kode user..');
ex_empty($password_id, 'Masukkan Password.');
ex_empty($db, 'Pilih database.');
$conn = conn($db);
ex_conn($conn);
if ($conn) {
$conn->begintrans();
}
$user_id = '';
$login_id = strtoupper($login_id);
$password_id = $password_id;
$full_name = '';
$role = '';
$div = '';
$modul_id = array();
$modul_ha = array();
$obj = $conn->Execute("\n\t\tSELECT \n\t\t\tUPPER(USER_ID) AS USER_ID, \n\t\t\t(PASSOWRD_ID) AS PASSOWRD_ID, \n\t\t\tUPPER(LOGIN_ID) AS LOGIN_ID, \n\t\t\tUPPER(FULL_NAME) AS FULL_NAME,\n\t\t\tUPPER(ROLE) AS ROLE,\n\t\t\tUPPER(DIV) AS DIV\n\t\tFROM\n\t\t\tUSER_APPLICATIONS\n\t\tWHERE\n\t\t\tLOGIN_ID = '{$login_id}'\n\t\t");
$dbpass = $obj->fields['PASSOWRD_ID'];
ex_login();
ex_app('M');
ex_mod('M29');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Reserve') {
ex_ha('M29', 'I');
ex_empty($nama_calon_pembeli, 'Nama calon pembeli harus diisi.');
//ex_empty($tanggal_reserve, 'Tanggal reserve harus diisi.');
//ex_empty($berlaku_sampai, 'Tanggal berlaku sampai harus diisi.');
ex_empty($alamat, 'Alamat harus diisi.');
ex_empty($telepon, 'No Telepon harus diisi.');
//ex_empty($agen, 'Agen harus diisi.');
ex_empty($no_ktp, 'Identitas KTP harus diisi.');
ex_empty($koordinator, 'Koordinator harus diisi.');
$query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM RESERVE WHERE KODE_BLOK = '{$id}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \\'{$id}\\' telah terdaftar.");
$query = "\n\t\t\tINSERT INTO RESERVE\n\t\t\t(\n\t\t\t\tKODE_BLOK, NAMA_CALON_PEMBELI, TANGGAL_RESERVE, BERLAKU_SAMPAI, \n\t\t\t\tALAMAT, TELEPON, AGEN, KOORDINATOR, NO_IDENTITAS, NPWP\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t'{$id}', '{$nama_calon_pembeli}', CONVERT(DATETIME,'{$tanggal_reserve}',105), \n\t\t\t\tCONVERT(DATETIME,'{$berlaku_sampai}',105), '{$alamat}', '{$telepon}', '{$agen}', '{$koordinator}', '{$no_ktp}', '{$no_npwp}'\n\t\t\t)\n\t\t\t";
ex_false($conn->Execute($query), $query);
$query = "\n\t\t\tUPDATE STOK SET\n\t\t\t\tTERJUAL = '1' \n\t\t\tWHERE \n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = "Blok \\'{$id}\\' berhasil direserve.";
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
} else {
if ($act == 'Ubah') {
// ex_ha('JB09', 'U');
ex_empty($no_ppjb_hak, 'No. PPJB Pengalihan Hak harus diisi.');
ex_empty($tanggal, 'Tanggal harus diisi.');
ex_empty($harga_hak, 'Harga harus diisi.');
ex_empty($biaya, 'Biaya harus diisi.');
ex_empty($masa_bangun, 'Masa bangun harus diisi.');
ex_empty($pihak_kedua, 'Nama Pembeli Pihak Kedua harus diisi.');
ex_empty($no_id_hak, 'No. Identitas Pihak Kedua harus diisi.');
ex_empty($alamat_hak, 'Alamat Pihak Kedua harus diisi.');
ex_empty($tlp1_hak, 'No. Telp. Pihak Kedua harus diisi.');
ex_empty($tlp3_hak, 'No. HP Pihak Kedua harus diisi.');
ex_empty($email_hak, 'Email Pihak Kedua harus diisi.');
ex_empty($suami_istri_hak, 'Nama Suami/Istri Pihak Kedua harus diisi.');
ex_empty($no_fax_hak, 'No. Fax Pihak Kedua harus diisi.');
$query = "\n\t\t\t\tUPDATE CS_PENGALIHAN_HAK SET \n\t\t\t\tNO_PPJB_PH = '{$no_ppjb_hak}',\n\t\t\t\tNPWP = '{$npwp}',\n\t\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\tTANGGAL_PERMOHONAN = CONVERT(DATETIME,'{$tanggal_permohonan}',105),\n\t\t\t\tTANGGAL_PERSETUJUAN = CONVERT(DATETIME,'{$tanggal_persetujuan}',105),\n\t\t\t\tHARGA_PENGALIHAN_HAK = {$harga_hak},\n\t\t\t\tBIAYA_PENGALIHAN_HAK = {$biaya},\n\t\t\t\tMASA_BANGUN = '{$masa_bangun}',\n\t\t\t\tKETERANGAN = '{$keterangan}',\t\n\t\t\t\tPIHAK_KEDUA = '{$pihak_kedua}',\n\t\t\t\tALAMAT_PIHAK_KEDUA = '{$alamat_hak}',\n\t\t\t\tNO_ID_PIHAK_KEDUA = '{$no_id_hak}',\n\t\t\t\tNO_TELP_PIHAK_KEDUA = '{$tlp1_hak}',\n\t\t\t\tNO_HP_PIHAK_KEDUA = '{$tlp3_hak}',\n\t\t\t\tNO_FAX_PIHAK_KEDUA = '{$no_fax_hak}',\n\t\t\t\tEMAIL_PIHAK_KEDUA = '{$email_hak}',\n\t\t\t\tNAMA_SUAMI_ISTRI = '{$suami_istri_hak}'\n\t\t\t\tWHERE NO_PPJB_PH = '{$no_ppjb_hak}'\n\t\t\t\t";
ex_false($conn->execute($query), $query);
//update spp dengan data yang baru
$query = "\n\t\t\t\tUPDATE SPP SET \n\t\t\t\tNAMA_PEMBELI = '{$pihak_kedua}',\n\t\t\t\tALAMAT_RUMAH = '{$alamat_hak}',\n\t\t\t\tALAMAT_SURAT = '{$alamat_hak}',\n\t\t\t\tNO_IDENTITAS = '{$no_id_hak}',\n\t\t\t\tNPWP = '{$npwp}',\n\t\t\t\tTELP_RUMAH = '{$tlp1_hak}',\n\t\t\t\tTELP_KANTOR = '',\n\t\t\t\tTELP_LAIN = '{$tlp3_hak}',\n\t\t\t\tALAMAT_EMAIL = '{$email_hak}',\n\t\t\t\tNAMA_SUAMI_ISTRI = '{$suami_istri_hak}',\n\t\t\t\tNO_FAX = '{$no_fax_hak}'\n\t\t\t\tWHERE KODE_BLOK = '{$kode}'\n\t\t\t\t";
ex_false($conn->execute($query), $query);
$msg = 'Data Pengalihan Hak berhasil diubah.';
}
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$kode_bayar = isset($_REQUEST['kode_bayar']) ? to_number($_REQUEST['kode_bayar']) : '';
$jenis_bayar = isset($_REQUEST['jenis_bayar']) ? clean($_REQUEST['jenis_bayar']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M11');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M11', 'U');
ex_empty($kode_bayar, 'Kode pembayaran harus diisi.');
ex_empty($jenis_bayar, 'Nama jenis pembayaran harus diisi.');
$query = "\n\t\t\tDELETE FROM JENIS_PEMBAYARAN \n\t\t\tWHERE\n\t\t\t\tKODE_BAYAR = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data jenis pembayaran berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$cb_data = $_REQUEST['cb_data'];
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.';
} else {
if ($field1 == 2) {
$act = array();
$cb_data = $_REQUEST['cb_data'];
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();
// ex_empty($kode_lokasi, 'Kode lokasi harus diisi.');
// ex_empty($jenis_bangunan, 'Pilih jenis bangunan.');
// ex_empty($harga_bangunan, 'Harga bangunan > 0');
// ex_empty($tanggal, 'Pilih tanggal.');
$query = "SELECT COUNT(KODE_SK) AS TOTAL FROM HARGA_SK WHERE KODE_SK = '{$kode_sk}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Kode sk \"{$kode_sk}\" telah terdaftar.");
$query = "INSERT INTO HARGA_SK (KODE_SK, KODE_BLOK, HARGA_CASH_KERAS, CB36X, CB48X, KPA24X, KPA36X, TANGGAL, STATUS) VALUES \n\t\t\t(\n\t\t\t\t'{$kode_sk}',\n\t\t\t\t'{$kode_blok}',\n\t\t\t\t'{$cash_keras}',\n\t\t\t\t'{$cb36x}',\n\t\t\t\t'{$cb48x}',\n\t\t\t\t'{$kpa24x}',\n\t\t\t\t'{$kpa36x}',\n\t\t\t\tCONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\t'{$status}'\n\t\t\t)";
ex_false($conn->Execute($query), $query);
$msg = "Data harga bangunan berhasil ditambahkan.";
} elseif ($act == 'Ubah') {
ex_ha('M10', 'U');
ex_empty($kode_sk, 'Kode sk harus diisi.');
ex_empty($kode_lokasi, 'Kode lokasi harus diisi.');
ex_empty($jenis_bangunan, 'Pilih jenis bangunan.');
ex_empty($harga_bangunan, 1, 'Harga bangunan > 0');
ex_empty($tanggal, 'Pilih tanggal.');
if ($kode_sk != $id) {
$query = "SELECT COUNT(KODE_SK) AS TOTAL FROM HARGA_BANGUNAN WHERE KODE_SK = '{$kode_sk}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Kode sk \"{$kode_sk}\" telah terdaftar.");
}
$query = "SELECT * FROM HARGA_BANGUNAN WHERE KODE_SK = '{$kode_sk}' AND KODE_LOKASI = '{$kode_lokasi}' AND JENIS_BANGUNAN = '{$jenis_bangunan}' AND HARGA_BANGUNAN = '{$harga_bangunan}' AND TANGGAL = CONVERT(DATETIME,'{$tanggal}',105) AND STATUS = '{$status}'";
ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
$query = "\n\t\t\tUPDATE HARGA_BANGUNAN \n\t\t\tSET KODE_SK = '{$kode_sk}',\n\t\t\t\tKODE_LOKASI = '{$kode_lokasi}',\n\t\t\t\tJENIS_BANGUNAN = '{$jenis_bangunan}',\n\t\t\t\tHARGA_BANGUNAN = '{$harga_bangunan}',\n\t\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\tSTATUS = '{$status}'\n\t\t\tWHERE\n\t\t\t\tKODE_SK = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data harga bangunan berhasil diubah.';
} elseif ($act == 'Hapus') {
$act = array();
// $cb_data = $_REQUEST['cb_data'];
// ex_empty($cb_data, 'Pilih data yang akan dihapus.');
foreach ($cb_data as $id_del) {
$querySrc = "SELECT COUNT(KODE_SK) AS TOTAL FROM stok WHERE KODE_SK ='{$id_del}'";
ex_login();
//ex_app('');
//ex_mod('');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Simpan') {
//ex_ha('', 'I');
ex_empty($alamat_rumah, 'Alamat rumah harus diisi.');
ex_empty($identitas, 'Identitas harus diisi.');
ex_empty($no_identitas, 'No identitas harus diisi.');
ex_empty($npwp, 'No npwp harus diisi.');
ex_empty($no_customer, 'No virtual account harus diisi.');
ex_empty($koordinator, 'Koordinator harus diisi.');
ex_empty($bank, 'Bank harus diisi.');
ex_empty($tanda_jadi, 'Tanda jadi harus diisi.');
$query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM SPP WHERE KODE_BLOK = '{$id}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \\'{$id}\\' telah terdaftar.");
$query = "SELECT MAX(NOMOR_SPP) AS NOMOR_SPP FROM SPP";
$obj = $conn->execute($query);
$no_spp = 1 + $obj->fields['NOMOR_SPP'];
$query = "\n\t\t\tINSERT INTO SPP \n\t\t\t(KODE_BLOK,\n\t\t\t\t\t\t\t COSTUMER_ID,\n\t\t\t\t\t\t\t NOMOR_CUSTOMER,\n\t\t\t\t\t\t\t NOMOR_SPP,\n\t\t\t\t\t\t\t NAMA_PEMBELI,\n\t\t\t\t\t\t\t ALAMAT_RUMAH,\n\t\t\t\t\t\t\t ALAMAT_SURAT,\n\t\t\t\t\t\t\t ALAMAT_NPWP,\n\t\t\t\t\t\t\t ALAMAT_EMAIL,\n\t\t\t\t\t\t\t IDENTITAS,\n\t\t\t\t\t\t\t NO_IDENTITAS,\n\t\t\t\t\t\t\t NPWP,\n\t\t\t\t\t\t\t JENIS_NPWP,\n\t\t\t\t\t\t\t TELP_RUMAH,\n\t\t\t\t\t\t\t TELP_KANTOR,\n\t\t\t\t\t\t\t TELP_LAIN,\n\t\t\t\t\t\t\t KODE_BANK,\n\t\t\t\t\t\t\t TANGGAL_SPP,\n\t\t\t\t\t\t\t KODE_AGEN,\n\t\t\t\t\t\t\t KODE_KOORDINATOR,\n\t\t\t\t\t\t\t JUMLAH_KPR,\n\t\t\t\t\t\t\t STATUS_KOMPENSASI,\n\t\t\t\t\t\t\t TANGGAL_AKAD,\n\t\t\t\t\t\t\t TANDA_JADI,\n\t\t\t\t\t\t\t TANGGAL_TANDA_JADI,\n\t\t\t\t\t\t\t STATUS_SPP,\n\t\t\t\t\t\t\t TANGGAL_PROSES,\n\t\t\t\t\t\t\t SPP_REDISTRIBUSI,\n\t\t\t\t\t\t\t SPP_REDISTRIBUSI_TANGGAL,\n\t\t\t\t\t\t\t KETERANGAN)\n\t\t\tVALUES('{$id}',\n\t\t\t\t '{$costumer_id}',\n\t\t\t\t '{$no_customer}',\n\t\t\t\t '{$no_spp}',\n\t\t\t\t '{$nama}',\n\t\t\t\t '{$alamat_rumah}',\n\t\t\t\t '{$alamat_surat}',\n\t\t\t\t '{$alamat_npwp}',\n\t\t\t\t '{$email}',\n\t\t\t\t '{$identitas}',\n\t\t\t\t '{$no_identitas}',\n\t\t\t\t '{$npwp}',\n\t\t\t '{$jenis_npwp}',\n\t\t\t\t '{$tlp_rumah}',\n\t\t\t\t '{$tlp_kantor}',\n\t\t\t\t '{$tlp_lain}',\n\t\t\t\t '{$bank}',\n\t\t\t\t CONVERT(DATETIME,'{$tgl_spp}',105),\n\t\t\t\t '{$agen}',\n\t\t\t\t '{$koordinator}',\n\t\t\t\t '{$jumlah_kpr}',\n\t\t\t\t '{$status_kompensasi}',\n\t\t\t\t CONVERT(DATETIME,'{$tgl_akad}',105),\n\t\t\t\t '{$tanda_jadi}',\n\t\t\t\t CONVERT(DATETIME,'{$tgl_tanda_jadi}',105),\n\t\t\t\t '{$status_spp}',\n\t\t\t\t CONVERT(DATETIME,'{$tgl_proses}',105),\n\t\t\t\t '{$redistribusi}',\n\t\t\t\t CONVERT(DATETIME,'{$tgl_redistribusi}',105),\n\t\t\t\t '{$keterangan}')";
ex_false($conn->execute($query), $query);
$query = "UPDATE SPP SET OTORISASI = '0' WHERE KODE_BLOK = '{$id}'";
ex_false($conn->execute($query), $query);
$query = "DELETE FROM RESERVE WHERE KODE_BLOK = '{$id}'";
ex_false($conn->execute($query), $query);
$query = "\n\t\t\tUPDATE STOK SET TERJUAL = '2' WHERE KODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data SPP berhasil disimpan';
}
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$kode_tipe = isset($_REQUEST['kode_tipe']) ? to_number($_REQUEST['kode_tipe']) : '';
$tipe_bangunan = isset($_REQUEST['tipe_bangunan']) ? clean($_REQUEST['tipe_bangunan']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M04');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M04', 'U');
ex_empty($kode_tipe, 'Kode tipe harus diisi.');
ex_empty($tipe_bangunan, 'Nama tipe bangunan harus diisi.');
$query = "\n\t\t\tDELETE FROM TIPE\n\t\t\tWHERE\n\t\t\t\tKODE_TIPE = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data Tipe berhasil diubah.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$app_id = isset($_REQUEST['app_id']) ? clean($_REQUEST['app_id']) : '';
$menu_name = isset($_REQUEST['menu_name']) ? clean($_REQUEST['menu_name']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
//ex_app('A');
ex_mod('A02');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Edit') {
ex_ha('A02', 'U');
ex_empty($app_id, 'Pilih app.');
ex_empty($menu_name, 'menu harus diisi.');
$ols_menu_name = $conn->Execute("SELECT MENU_NAME FROM MENUS WHERE MENU_ID = '{$id}'")->fields['MENU_NAME'];
if ($menu_name != $ols_menu_name) {
$query = "SELECT COUNT(MENU_NAME) AS TOTAL FROM MENUS WHERE MENU_NAME = '{$menu_name}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$menu_name}\" telah terdaftar.");
}
$query = "\n\t\t\tUPDATE APPLICATION_MENU\n\t\t\tSET APP_ID = '{$app_id}',\n\t\t\t\tMENU_NAME = '{$menu_name}'\n\t\t\tWHERE\n\t\t\t\tmenu_ID = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data menu berhasil diubah.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
ex_mod('P06');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Tambah') {
ex_ha('P06', 'I');
ex_empty($tanggal, 'Tanggal PPJB harus diisi.');
ex_empty($jenis_ppjb, 'Jenis PPJB harus diisi.');
$conn->begintrans();
$query = "\n\t\t\tINSERT INTO CS_PPJB (KODE_BLOK, TANGGAL, \n\t\t\tMASA_BANGUN, DAYA_LISTRIK, JENIS, ADDENDUM, CATATAN,\n\t\t\tTANGGAL_PINJAM_PEMBELI, TANGGAL_TT_PEMBELI, TANGGAL_TT_PEJABAT, TANGGAL_PENYERAHAN,\n\t\t\tSTATUS_CETAK, STATUS_CETAK_PAIJB, NAMA_PEMBELI, NOMOR_ARSIP)\n\t\t\t\n\t\t\tVALUES ('{$id}', CONVERT(DATETIME,'{$tanggal}',105), \n\t\t\t'{$masa_bangun}', '{$daya_listrik}', '{$jenis_ppjb}', '{$addendum}', '{$catatan}',\n\t\t\tCONVERT(DATETIME,'{$tanggal_pinjam_pembeli}',105), CONVERT(DATETIME,'{$tanggal_tt_pembeli}',105), CONVERT(DATETIME,'{$tanggal_tt_pejabat}',105), CONVERT(DATETIME,'{$tanggal_penyerahan}',105),\n\t\t\t'{$status_cetak}', '{$status_cetak_paijb}', '{$nama_pembeli}', '{$nomor_arsip}')\n\t\t\t";
ex_false($conn->execute($query), $query);
$msg = 'Data PPJB telah ditambah.';
} elseif ($act == 'Ubah') {
ex_ha('P06', 'U');
ex_empty($tanggal, 'Tanggal PPJB harus diisi.');
ex_empty($jenis_ppjb, 'Jenis PPJB harus diisi.');
$conn->begintrans();
$query = "\n\t\t\tUPDATE CS_PPJB SET\n\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105), \n\t\t\tMASA_BANGUN = '{$masa_bangun}', DAYA_LISTRIK = '{$daya_listrik}', JENIS = '{$jenis_ppjb}', ADDENDUM = '{$addendum}', \n\t\t\tCATATAN = '{$catatan}',\n\t\t\tTANGGAL_PINJAM_PEMBELI = CONVERT(DATETIME,'{$tanggal_pinjam_pembeli}',105), TANGGAL_TT_PEMBELI = CONVERT(DATETIME,'{$tanggal_tt_pembeli}',105), TANGGAL_TT_PEJABAT = CONVERT(DATETIME,'{$tanggal_tt_pejabat}',105), TANGGAL_PENYERAHAN = CONVERT(DATETIME,'{$tanggal_penyerahan}',105),\n\t\t\tSTATUS_CETAK = '{$status_cetak}', STATUS_CETAK_PAIJB='{$status_cetak_paijb}', NOMOR_ARSIP = '{$nomor_arsip}'\t\t\t\n\t\t\tWHERE KODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->execute($query), $query);
$msg = 'Data PPJB berhasil diubah.';
} elseif ($act == 'Hapus') {
ex_ha('P06', 'D');
$query = "DELETE FROM CS_PPJB WHERE KODE_BLOK = '{$id}'";
ex_false($conn->execute($query), $query);
$msg = 'Data PPJB telah dihapus.';
} elseif ($act == 'Ttd') {
ex_ha('P06', 'U');
$nama = isset($_REQUEST['nama']) ? clean($_REQUEST['nama']) : '';
$jabatan = isset($_REQUEST['jabatan']) ? clean($_REQUEST['jabatan']) : '';
$query = "\n\t\t\tUPDATE CS_PPJB SET\n\t\t\t\tNAMA_PENANDATANGAN = '{$nama}',\n\t \t\t\tJABATAN = '{$jabatan}'\n\t\t\tWHERE\n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->execute($query), $query);
// $type = (isset($_REQUEST['type'])) ? clean($_REQUEST['type']) : '';
list($x, $y) = explode("X", $kode_pola_bayar);
// or POST
$kode_pola_bayar = $x;
// 6
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
die_login();
// die_app('');
// die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$conn->begintrans();
$error = false;
if ($act == 'Apply') {
ex_empty($kode_pola_bayar, 'Pola Bayar harus diisi.');
$query = "DELETE FROM RENCANA WHERE KODE_BLOK = '{$id}'";
ex_false($conn->execute($query), $query);
$query = "SELECT KODE_POLA, NAMA_POLA_BAYAR FROM POLA_BAYAR WHERE KODE_POLA_BAYAR = '{$kode_pola_bayar}'";
$obj = $conn->execute($query);
$pola_bayar = $obj->fields['KODE_POLA'];
$nama_pola = $obj->fields['NAMA_POLA_BAYAR'];
//proses pengambilan harga sk yang dipilih sesuai pola bayar
$query = "SELECT count(KODE_BLOK) as TOTAL FROM HARGA_SK WHERE KODE_SK=(SELECT KODE_SK FROM STOK WHERE KODE_BLOK = '{$id}') AND KODE_BLOK='{$id}'";
ex_not_found($conn->Execute($query)->fields['TOTAL'], "Pola Bayar Tidak Tersedia");
$query = "SELECT ({$pola_bayar}) as HARGA FROM HARGA_SK WHERE KODE_SK = (SELECT KODE_SK FROM STOK WHERE KODE_BLOK = '{$id}') AND KODE_BLOK = '{$id}'";
$obj = $conn->execute($query);
$harga_pemesanan = $obj->fields['HARGA'];
$harga_total = $harga_pemesanan - $tanda_jadi;
//update harga total yang dipalkai pada tabel spp
$query = "UPDATE SPP SET \n\t\t\t\t\t\t\tHARGA_TOTAL\t= {$harga_total},\n\t\t\t\t\t\t\tPOLA_BAYAR\t= '{$nama_pola}'\n\t\t\t\t\t\t WHERE KODE_BLOK\t\t= '{$id}'\n\t\t\t\t\t\t ";
$msg = '';
$error = FALSE;
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$kode_lokasi = isset($_REQUEST['kode_lokasi']) ? to_number($_REQUEST['kode_lokasi']) : '';
$lokasi = isset($_REQUEST['lokasi']) ? clean($_REQUEST['lokasi']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M01');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M01', 'U');
ex_empty($kode_lokasi, 'Kode lokasi harus diisi.');
ex_empty($lokasi, 'Nama lokasi harus diisi.');
$query = "\n\t\t\tDELETE FROM LOKASI \n\t\t\tWHERE\n\t\t\t\tKODE_LOKASI = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data Lokasi berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$nm = isset($_REQUEST['nm']) ? clean($_REQUEST['nm']) : '';
$kode_jenis = isset($_REQUEST['kode_jenis']) ? to_number($_REQUEST['kode_jenis']) : '';
$jenis_penjualan = isset($_REQUEST['jenis_penjualan']) ? clean($_REQUEST['jenis_penjualan']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M07');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M07', 'U');
ex_empty($kode_jenis, 'Kode penjualan harus diisi.');
ex_empty($jenis_penjualan, 'Nama penjualan harus diisi.');
$query = "\n\t\t\tDELETE FROM JENIS_PENJUALAN \n\t\t\tWHERE\n\t\t\t\tKODE_JENIS = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data jenis penjualan berhasil dihapus.';
$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;
// $cb_data = $_REQUEST['cb_data'];
// foreach ($cb_data as $id)
// {
// $obj = $conn->Execute("SELECT COUNT(MENU_ID) AS TOTAL FROM APPLICATION_MENU WHERE MENU_ID = '$id' AND USER_ID = '$user_id'");
// $total = $obj->fields['TOTAL'];
// if($total == 0)
// {
// if ($conn->Execute("INSERT INTO APPLICATION_MENU(USER_ID, MENU_ID, R_RONLY, R_EDIT, R_INSERT, R_DELETE)
// VALUES('$user_id','$id',NULL,NULL,NULL,NULL)")) {
// $act[] = $id;
// } else {
// $error = TRUE;
// }
// }
// }
ex_empty($user_id, 'Pilih user ID.');
//ex_empty($app_id, 'Pilih App ID.');
foreach ($ar_menu_id as $i => $menu_id) {
$conn->Execute("DELETE FROM APPLICATION_MENU WHERE USER_ID = '{$user_id}' AND MENU_ID = '{$menu_id}'");
$akses = isset($akses_modul[$menu_id]) ? $akses_modul[$menu_id] : 'NO';
if ($akses != 'NO') {
$query = "INSERT INTO APPLICATION_MENU(USER_ID, MENU_ID, STATUS)\n\t\t\t\t\tVALUES('{$user_id}','{$menu_id}','Y')";
ex_false($conn->Execute($query), $query);
}
}
//$msg = $akses;
$msg = "Status berhasil diubah";
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$app_id = isset($_REQUEST['app_id']) ? clean($_REQUEST['app_id']) : '';
$modul_name = isset($_REQUEST['modul_name']) ? clean($_REQUEST['modul_name']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('A01');
ex_mod('PU05');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Edit') {
ex_ha('PU05', 'U');
ex_empty($app_id, 'Pilih app.');
ex_empty($modul_name, 'Modul harus diisi.');
$ols_modul_name = $conn->Execute("SELECT MODUL_NAME FROM APPLICATION_MODULS WHERE MODUL_ID = '{$id}'")->fields['MODUL_NAME'];
if ($modul_name != $ols_modul_name) {
$query = "SELECT COUNT(MODUL_NAME) AS TOTAL FROM APPLICATION_MODULS WHERE MODUL_NAME = '{$modul_name}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$modul_name}\" telah terdaftar.");
}
$query = "\n\t\t\tUPDATE APPLICATION_MODULS \n\t\t\tSET APP_ID = '{$app_id}',\n\t\t\t\tMODUL_NAME = '{$modul_name}'\n\t\t\tWHERE\n\t\t\t\tMODUL_ID = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data modul berhasil diubah.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
ex_mod('M28');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Ubah') {
ex_ha('M28', 'I');
ex_empty($kode_blok, 'Kode Blok harus diisi.');
ex_empty($kode_desa, 'Desa harus diisi.');
ex_empty($kode_lokasi, 'Lokasi harus diisi.');
ex_empty($kode_unit, 'Jenis unit harus diisi.');
ex_empty($kode_sk_tanah, 'SK tanah harus diisi.');
ex_empty($kode_faktor, 'Faktor strategis harus diisi.');
ex_empty($kode_tipe, 'Tipe harus diisi.');
ex_empty($kode_sk_bangunan, 'SK bangunan harus diisi.');
ex_empty($kode_penjualan, 'Jenis penjualan harus diisi.');
ex_empty($class, 'Pilih class.');
$query = "\n\t\t\tUPDATE STOK \n\t\t\tSET KODE_BLOK = '{$kode_blok}', \n\t\t\t\tKODE_UNIT = '{$kode_unit}', \n\t\t\t\tKODE_DESA = '{$kode_desa}', \n\t\t\t\tKODE_LOKASI = '{$kode_lokasi}', \n\t\t\t\tKODE_SK_TANAH = '{$kode_sk_tanah}', \n\t\t\t\tKODE_FAKTOR = '{$kode_faktor}', \n\t\t\t\tKODE_TIPE = '{$kode_tipe}', \n\t\t\t\tKODE_SK_BANGUNAN = '{$kode_sk_bangunan}', \n\t\t\t\tKODE_PENJUALAN = '{$kode_penjualan}', \n\t\t\t\t\n\t\t\t\tLUAS_TANAH = '{$luas_tanah}', \n\t\t\t\tLUAS_BANGUNAN = '{$luas_bangunan}', \n\t\t\t\tPPN_TANAH = '{$ppn_tanah}', \n\t\t\t\tPPN_BANGUNAN = '{$ppn_bangunan}', \n\t\t\t\tDISC_TANAH = '{$disc_tanah}', \n\t\t\t\tDISC_BANGUNAN = '{$disc_bangunan}', \n\t\t\t\t\n\t\t\t\tCLASS = '{$class}',\n\t\t\t\tPROGRAM = '{$program}',\n\t\t\t\t\n\t\t\t\tSTATUS_GAMBAR_SITEPLAN = '{$status_gambar_siteplan}', \n\t\t\t\tSTATUS_GAMBAR_LAPANGAN = '{$status_gambar_lapangan}', \n\t\t\t\tSTATUS_GAMBAR_GS = '{$status_gambar_gs}'\n\t\t\tWHERE\n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data stok berhasil diubah.';
}
$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);
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
//ex_app('A');
ex_mod('A06');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Pemulihan') {
ex_ha('A06', 'U');
$act = array();
$cb_data = $_REQUEST['cb_data'];
ex_empty($cb_data, 'Pilih data yang akan dipulihkan.');
foreach ($cb_data as $id_del) {
if ($conn->Execute("UPDATE SPP SET TANGGAL_SPP = CONVERT(DATETIME,GETDATE(),105), TANGGAL_PROSES = CONVERT(DATETIME,GETDATE(),105)\n\t\t\t\tWHERE KODE_BLOK = '{$id_del}'")) {
$act[] = $id_del;
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data gagal dipulihkan.' : 'Data berhasil dipulihkan.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
$nilai = isset($_REQUEST['nilai']) ? $_REQUEST['nilai'] : '';
$bank = isset($_REQUEST['nama_bank']) ? $_REQUEST['nama_bank'] : '';
$kode_bank = isset($_REQUEST['kode_bank']) ? $_REQUEST['kode_bank'] : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$list_id_sukses = array();
$list_id_error = array();
try {
ex_login();
//ex_app('A01');
//ex_mod('PO01');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_empty($cb_data, 'Pilih data yang akan disimpan.');
ex_empty($bayar_via, 'Error. Kode bank, please contact developer.');
ex_empty($tanggal_transaksi, 'Error. Tanggal bayar, please contact developer.');
$error_update = FALSE;
foreach ($cb_data as $x => $id_save) {
$spl = $tanggal_transaksi[$x];
$a = explode(' ', $tanggal_transaksi[$x]);
$b = explode('/', $tanggal_transaksi[$x]);
$tgl_bayar_bank = $b[2] . '-' . $b[1] . '-' . $b[0];
$tgl_bayar_bank = date('Y-d-m', strtotime($tgl_bayar_bank));
$list_tanggal[] = $tgl_bayar_bank;
$query = "\n\t\t\t\tSELECT COUNT(TANGGAL) AS TOTAL FROM PEMBAYARAN WHERE NOMOR_VA = '{$nomor_va[$x]}' and TANGGAL = CONVERT(DATETIME,'{$tgl_bayar_bank}',105) AND KODE_BANK = '{$kode_bank}'\n\t\t\t\t";
$total_data = $conn->Execute($query)->fields['TOTAL'];
// print_r($query);
if ($total_data == 0) {
$query = "INSERT INTO PEMBAYARAN (NOMOR_VA, TANGGAL, NILAI, STATUS, KODE_BANK)\n\t\t\t\t\tVALUES(\n\t\t\t\t\t'{$nomor_va[$x]}',\n\t\t\t\t\tCONVERT(DATETIME,'{$tgl_bayar_bank}',105),\n\t\t\t\t\t'{$nilai[$x]}',\n\t\t\t\t\t'0',\n\t\t\t\t\t'{$kode_bank}'\n\t\t\t\t\t)";
if ($conn->Execute($query)) {
$list_id_sukses[] = $id_save;
case 'NIAGA':
$ext = 'txt';
$path = 'niaga';
break;
case 'NIAGA_AD':
$ext = 'txt';
$path = 'niaga_ad';
break;
case 'PERMATA':
$ext = 'txt';
$path = 'permata';
break;
}
try {
ex_empty($nama_bank, 'Pilih Kode Bank.');
ex_empty($path, 'Aplikasi import bank yang anda pilih belum tersedia');
// buat pathnya di C..jika belum ada, sistem langsung dibikin
$path = 'C:BANK/' . $path;
if (!file_exists($path)) {
mkdir($path, 0777, true);
}
if (!isset($_FILES) and !isset($_FILES['file_import'])) {
throw new Exception('Error upload file.');
}
$tmp_name = $_FILES['file_import']['tmp_name'];
$file_name = $_FILES['file_import']['name'];
$file_type = pathinfo(basename($file_name), PATHINFO_EXTENSION);
$error_upload = $_FILES['file_import']['error'];
if ($error_upload > 0) {
throw new Exception('Silakan pilih file.');
}
$msg = '';
$error = FALSE;
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$kode_unit = isset($_REQUEST['kode_unit']) ? to_number($_REQUEST['kode_unit']) : '';
$jenis_unit = isset($_REQUEST['jenis_unit']) ? clean($_REQUEST['jenis_unit']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M06');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M06', 'U');
ex_empty($kode_unit, 'Kode jenis unit harus diisi.');
ex_empty($jenis_unit, 'Nama jenis unit harus diisi.');
$query = "\n\t\t\tDELETE FROM JENIS_UNIT \n\t\t\tWHERE\n\t\t\t\tKODE_UNIT = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data jenis unit berhasil dihapus';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$kode_bank = isset($_REQUEST['kode_bank']) ? to_number($_REQUEST['kode_bank']) : '';
$nama_bank = isset($_REQUEST['nama_bank']) ? clean($_REQUEST['nama_bank']) : '';
$alamat_bank = isset($_REQUEST['alamat_bank']) ? clean($_REQUEST['alamat_bank']) : '';
$npwp = isset($_REQUEST['npwp']) ? clean($_REQUEST['npwp']) : '';
$kode_va_unit = isset($_REQUEST['kode_va_unit']) ? clean($_REQUEST['kode_va_unit']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M08');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M08', 'U');
ex_empty($kode_bank, 'Kode bank harus diisi.');
ex_empty($nama_bank, 'Nama bank harus diisi.');
$query = "\n\t\t\tDELETE FROM BANK \n\t\t\tWHERE\n\t\t\t\tKODE_BANK = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data lembaga keuangan berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$conn->begintrans();
if ($act == 'Tambah') {
ex_ha('PM11', 'I');
ex_empty($nomor_id, 'No ID harus diisi.');
ex_empty($nama, 'Nama harus diisi.');
ex_empty($alamat, 'Alamat harus diisi.');
$query = "SELECT COUNT(NOMOR_ID) AS TOTAL FROM CLUB_PERSONAL WHERE NOMOR_ID = '{$id}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Nomor ID \"{$id}\" telah terdaftar.");
$query = "INSERT INTO CLUB_PERSONAL (NOMOR_ID, NAMA, ALAMAT)\n\t\t\tVALUES('{$nomor_id}', '{$nama}', '{$alamat}')";
ex_false($conn->Execute($query), $query);
$msg = "Data Club Personal telah ditambahkan.";
} elseif ($act == 'Ubah') {
ex_ha('PM11', 'U');
ex_empty($nomor_id, 'Nomor id harus diisi.');
ex_empty($nama, 'Nama harus diisi.');
ex_empty($alamat, 'Alamat harus diisi.');
if ($nomor_id != $id) {
$query = "SELECT COUNT(NOMOR_ID) AS TOTAL FROM CLUB_PERSONAL WHERE NOMOR_ID = '{$id}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "Nomor ID \"{$id}\" telah terdaftar.");
}
$query = "SELECT * FROM CLUB_PERSONAL WHERE NOMOR_ID = '{$id}' AND NAMA = '{$nama}'";
ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
$query = "\n\t\t\tUPDATE CLUB_PERSONAL\n\t\t\tSET NOMOR_ID \t= '{$id}',\n\t\t\t\tNAMA\t \t= '{$nama}',\n\t\t\t\tALAMAT\t\t= '{$alamat}'\t\t\t\n\t\t\tWHERE\n\t\t\t\tNOMOR_ID = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data Club personal berhasil diubah.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$nm = isset($_REQUEST['nm']) ? clean($_REQUEST['nm']) : '';
$nomor_id = isset($_REQUEST['nomor_id']) ? clean($_REQUEST['nomor_id']) : '';
$nama = isset($_REQUEST['nama']) ? clean($_REQUEST['nama']) : '';
$alamat = isset($_REQUEST['alamat']) ? clean($_REQUEST['alamat']) : '';
$jabatan = isset($_REQUEST['jabatan']) ? to_number($_REQUEST['jabatan']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M13');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
ex_ha('M13', 'U');
ex_empty($nomor_id, 'Nomor id harus diisi.');
$query = "\n\t\t\tDELETE FROM CLUB_PERSONAL\n\t\t\tWHERE\n\t\t\t\tNOMOR_ID = '{$id}' AND JABATAN_KLUB = '5'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data Club personal berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
$msg = '';
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$app_name = isset($_REQUEST['app_name']) ? clean($_REQUEST['app_name']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
//ex_app('A');
ex_mod('A01');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
if ($act == 'Edit') {
ex_ha('A01', 'U');
ex_empty($app_name, 'App harus diisi.');
$ols_app_name = $conn->Execute("SELECT APP_NAME FROM APPLICATIONS WHERE APP_ID = '{$id}'")->fields['APP_NAME'];
if ($app_name != $ols_app_name) {
$query = "SELECT COUNT(APP_NAME) AS TOTAL FROM APPLICATIONS WHERE APP_NAME = '{$app_name}'";
ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$app_name}\" telah terdaftar.");
}
$query = "\n\t\t\tUPDATE APPLICATIONS \n\t\t\tSET APP_NAME = '{$app_name}'\n\t\t\tWHERE\n\t\t\t\tAPP_ID = '{$id}'\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data app berhasil diubah.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
$act = array();
$cb_data = $_REQUEST['cb_data'];
ex_empty($cb_data, 'Pilih data yang akan diotorisasi.');
foreach ($cb_data as $id_del) {
if ($conn->Execute("UPDATE STOK SET STATUS_STOK = '1' WHERE KODE_BLOK = '{$id_del}'")) {
$act[] = $id_del;
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data stok gagal diotorisasi.' : 'Data stok berhasil diotorisasi.';
} elseif ($act == 'Batal_Otorisasi') {
ex_ha('M28', 'U');
$act = array();
$cb_data = $_REQUEST['cb_data'];
ex_empty($cb_data, 'Pilih data yang akan dibatalkan diotorisasi.');
foreach ($cb_data as $id_del) {
if ($conn->Execute("UPDATE STOK SET STATUS_STOK = '0' WHERE KODE_BLOK = '{$id_del}'")) {
$act[] = $id_del;
} else {
$error = TRUE;
}
}
$msg = $error ? 'Sebagian data stok gagal batal otorisasi.' : 'Data stok yang telah diotorisasi berhasil dibatalkan otorisasinya.';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
$non3 = isset($_REQUEST['non3']) ? clean($_REQUEST['non3']) : '';
$non4 = isset($_REQUEST['non4']) ? clean($_REQUEST['non4']) : '';
$non5 = isset($_REQUEST['non5']) ? clean($_REQUEST['non5']) : '';
$non_jenis = isset($_REQUEST['non_jenis']) ? clean($_REQUEST['non_jenis']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
ex_login();
ex_app('M');
ex_mod('M12');
$conn = conn($sess_db);
ex_conn($conn);
$conn->begintrans();
//ex_ha('M12', 'U');
ex_empty($nama_pola_bayar, 'Nama pola pembayaran harus diisi.');
ex_empty($nilai1, 'Rumus pola pembayaran harus diisi.');
ex_empty($kali1, 'Rumus pola pembayaran harus diisi.');
$query = "\n\t\t\tDELETE FROM POLA_BAYAR\n\t\t\tWHERE\n\t\t\t\tKODE_POLA_BAYAR = {$kode_pola_bayar}\n\t\t\t";
ex_false($conn->Execute($query), $query);
$msg = 'Data pola pembayaran berhasil dihapus.';
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('error' => $error, 'msg' => $msg);
echo json_encode($json);
exit;
