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