function xls_to_number($v) { if (strpos($v, ']* ')) { $r = explode(']* ', $v); return to_number($r[1]); } return $v; }
function _plus() { $total = 0; $strings = array(); $isString = false; foreach (func_get_args() as $arg) { if (is_string($arg)) { $isString = true; } $strings[] = to_string($arg); if (!$isString) { $total += to_number($arg); } } return $isString ? join('', $strings) : $total; }
/** * Creates the global constructor used in user-land * @return Func */ static function getGlobalConstructor() { $Number = new Func(function ($value = 0) { $self = Func::getContext(); if ($self instanceof Number) { $self->value = to_number($value); return $self; } else { return to_number($value); } }); $Number->instantiate = function () { return new Number(); }; $Number->set('prototype', Number::$protoObject); $Number->setMethods(Number::$classMethods, true, false, true); //constants $Number->set('NaN', NAN); $Number->set('MAX_VALUE', INF); $Number->set('MIN_VALUE', -INF); $Number->set('NEGATIVE_INFINITY', -INF); $Number->set('POSITIVE_INFINITY', INF); return $Number; }
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $kode_faktor = isset($_REQUEST['kode_faktor']) ? to_number($_REQUEST['kode_faktor']) : ''; $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; } }
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $kode_blok = isset($_REQUEST['kode_blok']) ? clean($_REQUEST['kode_blok']) : ''; $kode_desa = isset($_REQUEST['kode_desa']) ? clean($_REQUEST['kode_desa']) : ''; $kode_lokasi = isset($_REQUEST['kode_lokasi']) ? clean($_REQUEST['kode_lokasi']) : ''; $kode_unit = isset($_REQUEST['kode_unit']) ? clean($_REQUEST['kode_unit']) : ''; $kode_sk_tanah = isset($_REQUEST['kode_sk_tanah']) ? clean($_REQUEST['kode_sk_tanah']) : ''; $kode_faktor = isset($_REQUEST['kode_faktor']) ? clean($_REQUEST['kode_faktor']) : ''; $kode_tipe = isset($_REQUEST['kode_tipe']) ? clean($_REQUEST['kode_tipe']) : ''; $kode_sk_bangunan = isset($_REQUEST['kode_sk_bangunan']) ? clean($_REQUEST['kode_sk_bangunan']) : ''; $kode_penjualan = isset($_REQUEST['kode_penjualan']) ? clean($_REQUEST['kode_penjualan']) : ''; $class = isset($_REQUEST['class']) ? clean($_REQUEST['class']) : ''; $status_gambar_siteplan = isset($_REQUEST['status_gambar_siteplan']) ? to_number($_REQUEST['status_gambar_siteplan']) : '0'; $status_gambar_lapangan = isset($_REQUEST['status_gambar_lapangan']) ? to_number($_REQUEST['status_gambar_lapangan']) : '0'; $status_gambar_gs = isset($_REQUEST['status_gambar_gs']) ? to_number($_REQUEST['status_gambar_gs']) : '0'; $program = isset($_REQUEST['program']) ? to_number($_REQUEST['program']) : '0'; $luas_tanah = isset($_REQUEST['luas_tanah']) ? to_decimal($_REQUEST['luas_tanah']) : '0'; $disc_tanah = isset($_REQUEST['disc_tanah']) ? to_decimal($_REQUEST['disc_tanah'], 16) : '0'; $ppn_tanah = isset($_REQUEST['ppn_tanah']) ? to_decimal($_REQUEST['ppn_tanah']) : '0'; $luas_bangunan = isset($_REQUEST['luas_bangunan']) ? to_decimal($_REQUEST['luas_bangunan']) : '0'; $disc_bangunan = isset($_REQUEST['disc_bangunan']) ? to_decimal($_REQUEST['disc_bangunan'], 16) : '0'; $ppn_bangunan = isset($_REQUEST['ppn_bangunan']) ? to_decimal($_REQUEST['ppn_bangunan']) : '0'; $nama_desa = ''; $lokasi = ''; $jenis_unit = ''; $harga_tanah_sk = ''; $faktor_strategis = ''; $tipe_bangunan = ''; $harga_bangunan_sk = ''; $jenis_penjualan = ''; $tgl_bangunan = '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $tanda_jadi = isset($_REQUEST['tanda_jadi']) ? to_number($_REQUEST['tanda_jadi']) : ''; $jumlah = isset($_REQUEST['jumlah']) ? clean($_REQUEST['jumlah']) : ''; $total_current = isset($_REQUEST['total_current']) ? clean($_REQUEST['total_current']) : ''; $total_bayar = isset($_REQUEST['total_bayar']) ? clean($_REQUEST['total_bayar']) : ''; $tanggal_input = isset($_REQUEST['tgl_spp']) ? clean($_REQUEST['tgl_spp']) : ''; $kode_bayar = isset($_REQUEST['kode_bayar']) ? clean($_REQUEST['kode_bayar']) : ''; $keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $pola_bayar = isset($_REQUEST['pola_bayar']) ? clean($_REQUEST['pola_bayar']) : ''; $status_kompensasi = isset($_REQUEST['status_kompensasi']) ? clean($_REQUEST['status_kompensasi']) : ''; $uang_muka = isset($_REQUEST['uang_muka']) ? clean($_REQUEST['uang_muka']) : ''; $total = isset($_REQUEST['total']) ? clean($_REQUEST['total']) : ''; $kbank = isset($_REQUEST['kbank']) ? clean($_REQUEST['kbank']) : ''; $tanggal_akad = isset($_REQUEST['tanggal_akad']) ? clean($_REQUEST['tanggal_akad']) : ''; $max = isset($_REQUEST['max']) ? to_number($_REQUEST['max']) : ''; $msg = ''; 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') { $query = "DELETE FROM RENCANA WHERE KODE_BLOK = '{$id}'"; ex_false($conn->execute($query), $query); for ($a = 1; $a <= $max; $a++) { $tgl_bayar = isset($_REQUEST['tanggal_bayar_' . $a]) ? clean($_REQUEST['tanggal_bayar_' . $a]) : '';
<?php require_once '../../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $coba = isset($_REQUEST['coba']) ? clean($_REQUEST['coba']) : ''; $sisa = isset($_REQUEST['sisa']) ? clean($_REQUEST['sisa']) : ''; $no_va = isset($_REQUEST['no_va']) ? clean($_REQUEST['no_va']) : ''; $tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : ''; $nilai = isset($_REQUEST['nilai']) ? to_number($_REQUEST['nilai']) : ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { ex_login(); //ex_app('C01'); //ex_mod('COF02'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); if ($act == 'Tambah') { //ex_ha('COF02', 'I'); ex_empty($no_va, 'nomor_va harus diisi.'); ex_empty($tanggal, 'tanggal harus diisi.'); ex_empty($nilai, 'nilai harus diisi.'); $query = "SELECT NOMOR_VA FROM PEMBAYARAN WHERE NOMOR_VA = '{$no_va}'"; ex_found($conn->Execute($query)->recordcount(), "Nomor_VA \"{$no_va}\" telah terdaftar."); $query = "INSERT INTO PEMBAYARAN (NOMOR_VA, TANGGAL, NILAI, STATUS)\n\t\t\tVALUES(\n\t\t\t\t'{$no_va}',\n\t\t\t\tCONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\t'{$nilai}','0'\n\t\t\t)"; ex_false($conn->execute($query), $query); $msg = "Data virtual account berhasil disimpan."; } elseif ($act == 'Ubah') {
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $kode = isset($_REQUEST['kode']) ? clean($_REQUEST['kode']) : ''; $kode_blok = isset($_REQUEST['kode_blok']) ? to_number($_REQUEST['kode_blok']) : ''; $no_va = isset($_REQUEST['no_va']) ? to_number(trim($_REQUEST['no_va'])) : ''; $no_va_ph = isset($_REQUEST['no_va_ph']) ? to_number($_REQUEST['no_va_ph']) : ''; $harga_awal = isset($_REQUEST['harga_awal']) ? to_number($_REQUEST['harga_awal']) : ''; $no_ppjb_awal = isset($_REQUEST['no_ppjb_awal']) ? clean($_REQUEST['no_ppjb_awal']) : ''; $no_ppjb_hak = isset($_REQUEST['no_ppjb_hak']) ? clean($_REQUEST['no_ppjb_hak']) : ''; $tanggal_awal = isset($_REQUEST['tanggal_awal']) ? clean($_REQUEST['tanggal_awal']) : ''; $tanggal_sekarang = date("Y-m-d H:i:s"); $tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : ''; $tanggal_permohonan = isset($_REQUEST['tanggal_permohonan']) ? clean($_REQUEST['tanggal_permohonan']) : ''; $tanggal_persetujuan = isset($_REQUEST['tanggal_persetujuan']) ? clean($_REQUEST['tanggal_persetujuan']) : ''; $harga_hak = isset($_REQUEST['harga_hak']) ? to_number($_REQUEST['harga_hak']) : ''; $biaya = isset($_REQUEST['biaya']) ? to_number($_REQUEST['biaya']) : ''; $masa_bangun = isset($_REQUEST['masa_bangun']) ? to_number($_REQUEST['masa_bangun']) : ''; $keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $pihak_pertama = isset($_REQUEST['pihak_pertama']) ? clean($_REQUEST['pihak_pertama']) : ''; $no_id = isset($_REQUEST['no_id']) ? clean($_REQUEST['no_id']) : ''; $alamat = isset($_REQUEST['alamat']) ? clean($_REQUEST['alamat']) : ''; $tlp1 = isset($_REQUEST['tlp1']) ? clean($_REQUEST['tlp1']) : ''; $tlp3 = isset($_REQUEST['tlp3']) ? clean($_REQUEST['tlp3']) : ''; $email = isset($_REQUEST['email']) ? clean($_REQUEST['email']) : ''; $suami_istri = isset($_REQUEST['suami_istri']) ? clean($_REQUEST['suami_istri']) : ''; $no_fax = isset($_REQUEST['no_fax']) ? clean($_REQUEST['no_fax']) : ''; $pihak_kedua = isset($_REQUEST['pihak_kedua']) ? clean($_REQUEST['pihak_kedua']) : ''; $no_id_hak = isset($_REQUEST['no_id_hak']) ? clean($_REQUEST['no_id_hak']) : ''; $alamat_hak = isset($_REQUEST['alamat_hak']) ? clean($_REQUEST['alamat_hak']) : ''; $tlp1_hak = isset($_REQUEST['tlp1_hak']) ? clean($_REQUEST['tlp1_hak']) : ''; $tlp3_hak = isset($_REQUEST['tlp3_hak']) ? clean($_REQUEST['tlp3_hak']) : ''; $email_hak = isset($_REQUEST['email_hak']) ? clean($_REQUEST['email_hak']) : '';
$msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $jenis_pembayaran = isset($_REQUEST['jenis_pembayaran']) ? clean($_REQUEST['jenis_pembayaran']) : ''; $nama_pembayar = isset($_REQUEST['nama_pembayar']) ? clean($_REQUEST['nama_pembayar']) : ''; $keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $jumlah = isset($_REQUEST['jumlah']) ? to_number($_REQUEST['jumlah']) : ''; $diposting = isset($_REQUEST['diposting']) ? to_number($_REQUEST['diposting']) : ''; $tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : ''; $tgl_terima = isset($_REQUEST['tgl_terima']) ? clean($_REQUEST['tgl_terima']) : ''; $via = isset($_REQUEST['via']) ? clean($_REQUEST['via']) : ''; $catatan = isset($_REQUEST['catatan']) ? clean($_REQUEST['catatan']) : ''; $catatan_kwt = isset($_REQUEST['catatan_kwt']) ? clean($_REQUEST['catatan_kwt']) : ''; $subtotal = isset($_REQUEST['subtotal']) ? to_number($_REQUEST['subtotal']) : ''; $ppn = isset($_REQUEST['ppn']) ? to_number($_REQUEST['ppn']) : ''; //$via = (isset($_REQUEST['bayar_secara'])) ? to_number($_REQUEST['bayar_secara']) : ''; $blok_baru = isset($_REQUEST['blok_baru']) ? clean($_REQUEST['blok_baru']) : ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { ex_login(); //ex_app(''); ex_mod('K01'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); if ($act == 'Ubah') { //ex_ha('', 'U'); ex_empty($tgl_terima, 'Tanggal Terima harus diisi.'); ex_empty($jenis_pembayaran, 'Jenis Pembayaran harus diisi.'); ex_empty($nama_pembayar, 'Telah Terima Dari harus diisi.');
<?php require_once '../../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $nama = isset($_REQUEST['nama']) ? clean($_REQUEST['nama']) : ''; $alamat = isset($_REQUEST['alamat']) ? clean($_REQUEST['alamat']) : ''; $npwp = isset($_REQUEST['npwp']) ? clean($_REQUEST['npwp']) : ''; $tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : ''; $uang_no = isset($_REQUEST['uang_no']) ? to_number($_REQUEST['uang_no']) : ''; $lain_no = isset($_REQUEST['lain_no']) ? to_number($_REQUEST['lain_no']) : ''; $faktur_no = isset($_REQUEST['faktur_no']) ? to_number($_REQUEST['faktur_no']) : ''; $tanda_no = isset($_REQUEST['tanda_no']) ? to_number($_REQUEST['tanda_no']) : ''; $uang_reg = isset($_REQUEST['uang_reg']) ? clean($_REQUEST['uang_reg']) : ''; $lain_reg = isset($_REQUEST['lain_reg']) ? clean($_REQUEST['lain_reg']) : ''; $faktur_reg = isset($_REQUEST['faktur_reg']) ? clean($_REQUEST['faktur_reg']) : ''; $tanda_reg = isset($_REQUEST['tanda_reg']) ? clean($_REQUEST['tanda_reg']) : ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { ex_login(); //ex_app(''); die_mod('K09'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); if ($act == 'save1') { //ex_ha('', 'U'); $query = "SELECT * FROM CS_REGISTER_CUSTOMER_SERVICE WHERE NAMA_PT = '{$nama}' AND TGL_PKP = CONVERT(DATETIME,'{$tanggal}',105) AND \n\t\t\tALAMAT = '{$alamat}' AND NPWP = '{$npwp}'"; ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah."); $query = "UPDATE CS_REGISTER_CUSTOMER_SERVICE \n\t\t\tSET\n\t\t\t\tNAMA_PT = '{$nama}', \n\t\t\t\tTGL_PKP = CONVERT(DATETIME,'{$tanggal}',105), \n\t\t\t\tALAMAT = '{$alamat}', \n\t\t\t\tNPWP = '{$npwp}'\n\t\t\t";
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $namapemilik = isset($_REQUEST['namapemilik']) ? clean($_REQUEST['namapemilik']) : ''; $namapembeli = isset($_REQUEST['namapembeli']) ? clean($_REQUEST['namapembeli']) : ''; $no_bast = isset($_REQUEST['no_bast']) ? clean($_REQUEST['no_bast']) : ''; $tgl_bast = isset($_REQUEST['tgl_bast']) ? clean($_REQUEST['tgl_bast']) : ''; $no_tlp = isset($_REQUEST['no_tlp']) ? clean($_REQUEST['no_tlp']) : ''; $no_spp = isset($_REQUEST['no_spp']) ? to_number($_REQUEST['no_spp']) : ''; $progress = isset($_REQUEST['progress']) ? to_number($_REQUEST['progress']) : '0'; $jml_kunci = isset($_REQUEST['jml_kunci']) ? clean($_REQUEST['jml_kunci']) : ''; $anak_kunci = isset($_REQUEST['anak_kunci']) ? clean($_REQUEST['anak_kunci']) : ''; $tgl_serah_kunci = isset($_REQUEST['tgl_serah_kunci']) ? clean($_REQUEST['tgl_serah_kunci']) : ''; $tglkonpro = isset($_REQUEST['tglkonpro']) ? clean($_REQUEST['tglkonpro']) : ''; $tgl_propur = isset($_REQUEST['tgl_propur']) ? clean($_REQUEST['tgl_propur']) : ''; $masaberlaku = isset($_REQUEST['masaberlaku']) ? clean($_REQUEST['masaberlaku']) : ''; $keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $kontraktor = isset($_REQUEST['kontraktor']) ? clean($_REQUEST['kontraktor']) : ''; $r_nama_desa = ''; $r_lokasi = ''; $r_jenis_unit = ''; $r_harga_tanah_sk = ''; $r_faktor_strategis = ''; $r_tipe_bangunan = ''; $r_harga_bangunan_sk = ''; $r_jenis_penjualan = ''; $r_progres = '';
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $nomor = isset($_REQUEST['nomor']) ? clean($_REQUEST['nomor']) : ''; $kode_blok = isset($_REQUEST['kode_blok']) ? clean($_REQUEST['kode_blok']) : ''; $tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : ''; $nama_pembayar = isset($_REQUEST['nama_pembayar']) ? clean($_REQUEST['nama_pembayar']) : ''; $no_tlp = isset($_REQUEST['no_tlp']) ? clean($_REQUEST['no_tlp']) : ''; $alamat = isset($_REQUEST['alamat']) ? clean($_REQUEST['alamat']) : ''; $catatan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $jumlah = isset($_REQUEST['jumlah']) ? to_number($_REQUEST['jumlah']) : ''; $koordinator = isset($_REQUEST['koordinator']) ? clean($_REQUEST['koordinator']) : ''; $penerima = isset($_REQUEST['penerima']) ? clean($_REQUEST['penerima']) : ''; $pembayaran = isset($_REQUEST['pembayaran']) ? clean($_REQUEST['pembayaran']) : ''; $bayar_secara = isset($_REQUEST['bayar_secara']) ? clean($_REQUEST['bayar_secara']) : ''; $bank = isset($_REQUEST['bank']) ? clean($_REQUEST['bank']) : ''; $no = isset($_REQUEST['no']) ? to_number($_REQUEST['no']) : ''; $kata = ''; $tmp = explode('#', $pembayaran); $pembayaran = $tmp[0]; $grup = $tmp[1]; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { ex_login(); //ex_app(''); ex_mod('K03'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); $user = $_SESSION['USER_ID']; if ($act == 'Tambah') { //ex_ha('', 'I');
$num = to_number($num); return is_nan($num) ? NAN : (double) exp($num); }, 'sqrt' => function ($num) { $num = to_number($num); return is_nan($num) ? NAN : (double) sqrt($num); }, 'sin' => function ($num) { $num = to_number($num); return is_nan($num) ? NAN : (double) sin($num); }, 'cos' => function ($num) { $num = to_number($num); return is_nan($num) ? NAN : (double) cos($num); }, 'tan' => function ($num) { $num = to_number($num); return is_nan($num) ? NAN : (double) tan($num); }, 'atan' => function ($num) { $num = to_number($num); return is_nan($num) ? NAN : (double) atan($num); }, 'atan2' => function ($y, $x) { $y = to_number($y); $x = to_number($x); if (is_nan($y) || is_nan($x)) { return NAN; } return (double) atan2($y, $x); }); $constants = array('E' => M_E, 'LN10' => M_LN10, 'LN2' => M_LN2, 'LOG10E' => M_LOG10E, 'LOG2E' => M_LOG2E, 'PI' => M_PI, 'SQRT1_2' => M_SQRT1_2, 'SQRT2' => M_SQRT2); $Math = new Object(); $Math->setMethods($methods, true, false, true); $Math->setProps($constants, true, false, true); return $Math; });
<?php require_once '../../../../config/config.php'; $msg = ''; $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(); } }
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $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(); if ($act == 'Tambah') { ex_ha('M02', 'I'); ex_empty($kode_desa, 'Kode desa harus diisi.'); ex_empty($nama_desa, 'Nama desa harus diisi.'); $query = "SELECT COUNT(KODE_DESA) AS TOTAL FROM DESA WHERE KODE_DESA = '{$kode_desa}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Kode desa \"{$kode_desa}\" telah terdaftar."); $query = "SELECT COUNT(NAMA_DESA) AS TOTAL FROM DESA WHERE NAMA_DESA = '{$nama_desa}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Nama desa '{$nama_desa}' telah terdaftar."); $query = "INSERT INTO DESA (KODE_DESA, NAMA_DESA)\n\t\t\tVALUES('{$kode_desa}', '{$nama_desa}')"; ex_false($conn->Execute($query), $query); $msg = "Data Desa telah ditambahkan."; } elseif ($act == 'Ubah') { ex_ha('M02', 'U');
<?php require_once '../../../../../config/config.php'; $msg = ''; $error = FALSE; $nama_pt = isset($_REQUEST['nama_pt']) ? clean($_REQUEST['nama_pt']) : ''; $unit = isset($_REQUEST['unit']) ? clean($_REQUEST['unit']) : ''; $nama_dep = isset($_REQUEST['nama_dep']) ? clean($_REQUEST['nama_dep']) : ''; $nama_pejabat = isset($_REQUEST['nama_pejabat']) ? clean($_REQUEST['nama_pejabat']) : ''; $nama_jabatan = isset($_REQUEST['nama_jabatan']) ? clean($_REQUEST['nama_jabatan']) : ''; $kota = isset($_REQUEST['kota']) ? clean($_REQUEST['kota']) : ''; $pejabat_ppjb = isset($_REQUEST['pejabat_ppjb']) ? clean($_REQUEST['pejabat_ppjb']) : ''; $jabatan_ppjb = isset($_REQUEST['jabatan_ppjb']) ? clean($_REQUEST['jabatan_ppjb']) : ''; $nomor_sk = isset($_REQUEST['nomor_sk']) ? clean($_REQUEST['nomor_sk']) : ''; $jumlah_hari = isset($_REQUEST['jumlah_hari']) ? clean($_REQUEST['jumlah_hari']) : ''; $nomor_ppjb = isset($_REQUEST['nomor_ppjb']) ? to_number($_REQUEST['nomor_ppjb']) : ''; $reg_ppjb = isset($_REQUEST['reg_ppjb']) ? clean($_REQUEST['reg_ppjb']) : ''; $tanggal_sk = isset($_REQUEST['tanggal_sk']) ? clean($_REQUEST['tanggal_sk']) : ''; $nomor_ppjb_ph = isset($_REQUEST['nomor_ppjb_ph']) ? clean($_REQUEST['nomor_ppjb_ph']) : ''; $reg_ppjb_ph = isset($_REQUEST['reg_ppjb_ph']) ? clean($_REQUEST['reg_ppjb_ph']) : ''; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { ex_login(); //ex_app('A01'); ex_mod('JB12'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); if ($act == 'save1') { //ex_ha('JB12', 'U');
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $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(); if ($act == 'Tambah') { ex_ha('M01', 'I'); ex_empty($kode_lokasi, 'Kode lokasi harus diisi.'); ex_empty($lokasi, 'Nama lokasi harus diisi.'); $query = "SELECT COUNT(KODE_LOKASI) AS TOTAL FROM LOKASI WHERE KODE_LOKASI = '{$kode_lokasi}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Kode lokasi \"{$kode_lokasi}\" telah terdaftar."); $query = "SELECT COUNT(LOKASI) AS TOTAL FROM LOKASI WHERE LOKASI = '{$lokasi}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Nama lokasi \"{$lokasi}\" telah terdaftar."); $query = "INSERT INTO LOKASI (KODE_LOKASI, LOKASI)\n\t\t\tVALUES('{$kode_lokasi}', '{$lokasi}')"; ex_false($conn->Execute($query), $query); $msg = "Data Lokasi \"{$lokasi}\" berhasil ditambahkan."; } elseif ($act == 'Ubah') { ex_ha('M01', 'U'); ex_empty($kode_lokasi, 'Kode lokasi harus diisi.');
<?php require_once '../../../../config/config.php'; $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);
<?php require_once '../../../../config/config.php'; $msg = ''; $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(); if ($act == 'Tambah') { ex_ha('M11', 'I'); ex_empty($kode_bayar, 'Kode jenis pembayaran harus diisi.'); ex_empty($jenis_bayar, 'Nama jenis pembayaran harus diisi.'); $query = "SELECT COUNT(KODE_BAYAR) AS TOTAL FROM JENIS_PEMBAYARAN WHERE KODE_BAYAR = '{$kode_bayar}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Kode jenis pembayaran \"{$kode_bayar}\" telah terdaftar."); $query = "SELECT COUNT(JENIS_BAYAR) AS TOTAL FROM JENIS_PEMBAYARAN WHERE JENIS_BAYAR = '{$jenis_bayar}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Nama jenis pembayaran \"{$jenis_bayar}\" telah terdaftar."); $query = "INSERT INTO JENIS_PEMBAYARAN (KODE_BAYAR, JENIS_BAYAR)\n\t\t\tVALUES('{$kode_bayar}', '{$jenis_bayar}')"; ex_false($conn->Execute($query), $query); $msg = "Data jenis pembayaran berhasil ditambahkan."; } elseif ($act == 'Ubah') { ex_ha('M11', 'U'); ex_empty($kode_bayar, 'Kode pembayaran harus diisi.');
function to_number($value) { if ($value === null) { return NAN; } if ($value === Object::$null) { return 0.0; } if (is_float($value)) { return $value; } if (is_int($value)) { return (double) $value; } if (is_bool($value)) { return $value ? 1.0 : 0.0; } if ($value instanceof Object) { return to_number(to_primitive($value)); } //trim whitespace $value = preg_replace('/^[\\s\\x0B\\xA0]+|[\\s\\x0B\\xA0]+$/u', '', $value); if ($value === '') { return 0.0; } if ($value === 'Infinity' || $value === '+Infinity') { return INF; } if ($value === '-Infinity') { return -INF; } if (preg_match('/^([+-]?)(\\d+\\.\\d*|\\.\\d+|\\d+)$/i', $value)) { return (double) $value; } if (preg_match('/^([+-]?)(\\d+\\.\\d*|\\.\\d+|\\d+)e([+-]?[0-9]+)$/i', $value, $m)) { return pow($m[1] . $m[2], $m[3]); } if (preg_match('/^0x[a-z0-9]+$/i', $value)) { return (double) hexdec(substr($value, 2)); } return NAN; }
// $virtual_account = $val[1]; // $virtual_account = (!empty($virtual_account)) ? clean($virtual_account) : ''; $kode_blok = $val[0]; $kode_pola_bayar = $pola_bayar; $query = "\n\t\t\t\tSELECT COUNT(KODE_BLOK) AS TOTAL FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$kode_blok}' \n\t\t\t\tAND KODE_POLA_BAYAR = {$kode_pola_bayar}\n\t\t\t\t"; $total_data = $conn->Execute($query)->fields['TOTAL']; $jumBaris = $row - 1; $jumData = $highestRow - 1; //bila data telah ada maka hapus dahulu data sebelumnya if ($total_data > 0) { $conn->Execute("DELETE FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$kode_blok}' \n\t\t\t\t\tAND KODE_POLA_BAYAR = {$kode_pola_bayar}\n\t\t\t\t\t"); } $harga_tanah = $val[1]; $harga_bangunan = $val[2]; $harga_tanah = !empty($harga_tanah) ? to_number($harga_tanah) : '0'; $harga_bangunan = !empty($harga_bangunan) ? to_number($harga_bangunan) : '0'; $query = "\n\t\t\t\tINSERT INTO DETAIL_POLA_BAYAR \n\t\t\t\t(\n\t\t\t\tKODE_BLOK, KODE_POLA_BAYAR, HARGA_TANAH, HARGA_BANGUNAN \n\t\t\t\t)\n\t\t\t\tVALUES\n\t\t\t\t(\n\t\t\t\t'{$kode_blok}', {$kode_pola_bayar}, {$harga_tanah}, {$harga_bangunan}\n\t\t\t\t)\t\t\t\t\t\n\t\t\t\t"; ex_false($conn->Execute($query), $query); $query = "SELECT count(*) AS TOTAL from HARGA_TANAH WHERE HARGA_TANAH = '{$harga_tanah}' and STATUS = '1'"; $qty_sk = $conn->Execute($query)->fields['TOTAL']; if ($qty_sk < 1) { $query = "INSERT INTO HARGA_TANAH(KODE_SK,KODE_LOKASI,TANGGAL,HARGA_TANAH,STATUS) VALUES((SELECT MAX(KODE_SK)+1 FROM HARGA_TANAH),0,GETDATE(),{$harga_tanah},'1')"; ex_false($conn->Execute($query), $query); } $query = "SELECT count(*) AS TOTAL from HARGA_BANGUNAN WHERE HARGA_BANGUNAN = '{$harga_bangunan}' and STATUS = '1'"; $qty_sk = $conn->Execute($query)->fields['TOTAL']; if ($qty_sk < 1) { $query = "INSERT INTO HARGA_BANGUNAN(KODE_SK,KODE_LOKASI,TANGGAL,JENIS_BANGUNAN,HARGA_BANGUNAN,STATUS) VALUES((SELECT MAX(KODE_SK)+1 FROM HARGA_BANGUNAN),0,GETDATE(),'0',{$harga_bangunan},'1')"; ex_false($conn->Execute($query), $query); } $conn->committrans();
ex_login(); ex_app('M'); ex_mod('M09'); $conn = conn($sess_db); ex_conn($conn); $conn->begintrans(); if ($act == 'Tambah') { ex_ha('M09', 'I'); ex_empty($kode_blok, 'Kode Blok harus diisi'); $query = "DELETE FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$kode_blok}'"; $conn->Execute($query); $data = $conn->Execute("SELECT KODE_POLA_BAYAR AS POLA FROM POLA_BAYAR"); while (!$data->EOF) { $pola_bayar = $data->fields['POLA']; $harga_tanah = isset($_REQUEST['harga_tanah_' . $pola_bayar]) ? to_number($_REQUEST['harga_tanah_' . $pola_bayar]) : 0; $harga_bangunan = isset($_REQUEST['harga_bangunan_' . $pola_bayar]) ? to_number($_REQUEST['harga_bangunan_' . $pola_bayar]) : 0; if ($harga_bangunan == 0 && $harga_tanah == 0) { $data->movenext(); continue; } $query = "INSERT INTO DETAIL_POLA_BAYAR(KODE_BLOK, KODE_POLA_BAYAR, HARGA_TANAH, HARGA_BANGUNAN) VALUES \n\t\t\t\t(\n\t\t\t\t\t'{$kode_blok}',\n\t\t\t\t\t'{$pola_bayar}',\n\t\t\t\t\t'{$harga_tanah}',\n\t\t\t\t\t'{$harga_bangunan}'\n\t\t\t\t)"; ex_false($conn->Execute($query), $query); $data->movenext(); } $msg = "Detail Pola Bayar berhasil ditambahkan."; } elseif ($act == 'Ubah') { ex_ha('M09', 'U'); ex_empty($kode_blok, 'Kode Blok harus diisi'); if ($sebelumnya != $pola_bayar) { $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$kode_blok}' AND KODE_POLA_BAYAR = '{$pola_bayar}'"; ex_found($conn->Execute($query)->fields['TOTAL'], "Detail Pola Bayar Sudah Terdaftar");
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : ''; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $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) {
if ($len === 1) { $code = ord($ch[0]); } else { $ch = mb_convert_encoding($ch, 'UCS-2LE', 'UTF-8'); $code = ord($ch[1]) * 256 + ord($ch[0]); } return (double) $code; }, 'indexOf' => function ($search, $offset = 0) { $self = Func::getContext(); $index = mb_strpos($self->value, $search, $offset); return $index === false ? -1.0 : (double) $index; }, 'lastIndexOf' => function ($search, $offset = null) { $self = Func::getContext(); $str = $self->value; if ($offset !== null) { $offset = to_number($offset); if ($offset > 0 && $offset < $self->length) { $str = mb_substr($str, 0, $offset + 1); } } $index = mb_strrpos($str, $search); return $index === false ? -1.0 : (double) $index; }, 'split' => function ($delim) { $self = Func::getContext(); $str = $self->value; if ($delim instanceof RegExp) { //$arr = mb_split($delim->source, $str); $arr = preg_split($delim->toString(true), $str); } else { $delim = to_string($delim); if ($delim === '') {
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $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(); }
function to_character($t) { $algo = "abcdefghijklmnopqrstuvwxyz"; $len = strlen($algo); for ($j = 0; $j < $len; $j++) { if ($t == $j) { return $algo[$j]; } } } $test = $_POST['dec']; $length = strlen($test); $out = ""; $k = $_POST['key']; for ($i = 0; $i < $length; $i++) { $o = to_number($test[$i]) - $k; if ($o < 0) { $o = $o + 26; } $l = fmod($o, 26); $out .= to_character($l); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <style type="text/css">
$alamat_npwp = isset($_REQUEST['alamat_npwp']) ? clean($_REQUEST['alamat_npwp']) : ''; $email = isset($_REQUEST['email']) ? clean($_REQUEST['email']) : ''; $tlp_rumah = isset($_REQUEST['tlp_rumah']) ? clean($_REQUEST['tlp_rumah']) : ''; $tlp_kantor = isset($_REQUEST['tlp_kantor']) ? clean($_REQUEST['tlp_kantor']) : ''; $tlp_lain = isset($_REQUEST['tlp_lain']) ? clean($_REQUEST['tlp_lain']) : ''; $identitas = isset($_REQUEST['identitas']) ? clean($_REQUEST['identitas']) : ''; $no_identitas = isset($_REQUEST['no_identitas']) ? clean($_REQUEST['no_identitas']) : ''; $npwp = isset($_REQUEST['npwp']) ? clean($_REQUEST['npwp']) : ''; $jenis_npwp = isset($_REQUEST['jenis_npwp']) ? clean($_REQUEST['jenis_npwp']) : ''; $bank = isset($_REQUEST['bank']) ? clean($_REQUEST['bank']) : ''; $jumlah_kpr = isset($_REQUEST['jumlah_kpr']) ? to_number($_REQUEST['jumlah_kpr']) : ''; $agen = isset($_REQUEST['agen']) ? clean($_REQUEST['agen']) : ''; $koordinator = isset($_REQUEST['koordinator']) ? clean($_REQUEST['koordinator']) : ''; $tgl_akad = isset($_REQUEST['tgl_akad']) ? clean($_REQUEST['tgl_akad']) : ''; $status_kompensasi = isset($_REQUEST['status_kompensasi']) ? clean($_REQUEST['status_kompensasi']) : ''; $tanda_jadi = isset($_REQUEST['tanda_jadi']) ? to_number($_REQUEST['tanda_jadi']) : ''; $status_spp = isset($_REQUEST['status_spp']) ? clean($_REQUEST['status_spp']) : ''; $tgl_proses = isset($_REQUEST['tgl_proses']) ? clean($_REQUEST['tgl_proses']) : ''; $tgl_tanda_jadi = isset($_REQUEST['tgl_tanda_jadi']) ? clean($_REQUEST['tgl_tanda_jadi']) : ''; $redistribusi = isset($_REQUEST['redistribusi']) ? clean($_REQUEST['redistribusi']) : ''; $tgl_redistribusi = isset($_REQUEST['tgl_redistribusi']) ? clean($_REQUEST['tgl_redistribusi']) : ''; $kelengkapan = isset($_REQUEST['kelengkapan']) ? clean($_REQUEST['kelengkapan']) : ''; $keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : ''; $catatan_penagihan = isset($_REQUEST['catatan_penagihan']) ? clean($_REQUEST['catatan_penagihan']) : ''; //DATA RENCANA & REALISASI $luas_tanah = isset($_REQUEST['luas_tanah']) ? clean($_REQUEST['luas_tanah']) : ''; $luas_bangunan = isset($_REQUEST['luas_bangunan']) ? clean($_REQUEST['luas_bangunan']) : ''; $tipe_bangunan = isset($_REQUEST['tipe_bangunan']) ? clean($_REQUEST['tipe_bangunan']) : ''; $total_tanah = isset($_REQUEST['total_tanah']) ? to_clean($_REQUEST['total_tanah']) : ''; $total_bangunan = isset($_REQUEST['total_bangunan']) ? to_clean($_REQUEST['total_bangunan']) : ''; $nomor_kwitansi = isset($_REQUEST['nomor_kwitansi']) ? clean($_REQUEST['nomor_kwitansi']) : '';
<?php require_once '../../../../config/config.php'; $msg = ''; $error = FALSE; $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(); }
$kode_desa = isset($_REQUEST['kode_desa']) ? clean($_REQUEST['kode_desa']) : ''; $kode_lokasi = isset($_REQUEST['kode_lokasi']) ? clean($_REQUEST['kode_lokasi']) : ''; $kode_unit = isset($_REQUEST['kode_unit']) ? clean($_REQUEST['kode_unit']) : ''; $kode_sk_tanah = isset($_REQUEST['kode_sk_tanah']) ? clean($_REQUEST['kode_sk_tanah']) : ''; $kode_faktor = isset($_REQUEST['kode_faktor']) ? clean($_REQUEST['kode_faktor']) : ''; $kode_tipe = isset($_REQUEST['kode_tipe']) ? clean($_REQUEST['kode_tipe']) : ''; $kode_sk = isset($_REQUEST['kode_sk']) ? clean($_REQUEST['kode_sk']) : ''; $kode_penjualan = isset($_REQUEST['kode_penjualan']) ? clean($_REQUEST['kode_penjualan']) : ''; $class = isset($_REQUEST['class']) ? clean($_REQUEST['class']) : ''; $status_gambar_siteplan = isset($_REQUEST['status_gambar_siteplan']) ? to_number($_REQUEST['status_gambar_siteplan']) : '0'; $status_gambar_lapangan = isset($_REQUEST['status_gambar_lapangan']) ? to_number($_REQUEST['status_gambar_lapangan']) : '0'; $status_gambar_gs = isset($_REQUEST['status_gambar_gs']) ? to_number($_REQUEST['status_gambar_gs']) : '0'; $program = isset($_REQUEST['program']) ? to_number($_REQUEST['program']) : '0'; $luas_tanah = isset($_REQUEST['luas_tanah']) ? to_decimal($_REQUEST['luas_tanah']) : '0'; $disc_tanah = isset($_REQUEST['disc_tanah']) ? to_decimal($_REQUEST['disc_tanah'], 16) : '0'; $harga_disc_tanah = isset($_REQUEST['harga_disc_tanah']) ? to_number($_REQUEST['harga_disc_tanah']) : '0'; $ppn_tanah = isset($_REQUEST['ppn_tanah']) ? to_decimal($_REQUEST['ppn_tanah']) : '0'; $luas_bangunan = isset($_REQUEST['luas_bangunan']) ? to_decimal($_REQUEST['luas_bangunan']) : '0'; $disc_bangunan = isset($_REQUEST['disc_bangunan']) ? to_decimal($_REQUEST['disc_bangunan'], 16) : '0'; $ppn_bangunan = isset($_REQUEST['ppn_bangunan']) ? to_decimal($_REQUEST['ppn_bangunan']) : '0'; // HARGA DI TABEL SK $kode_sk = isset($_REQUEST['kode_sk']) ? $_REQUEST['kode_sk'] : ''; $harga_cash_keras = isset($_REQUEST['harga_cash_keras']) ? bigintval($_REQUEST['harga_cash_keras']) : '0'; $CB36X = isset($_REQUEST['harga_CB36X']) ? bigintval($_REQUEST['harga_CB36X']) : '0'; $CB48X = isset($_REQUEST['harga_CB48X']) ? bigintval($_REQUEST['harga_CB48X']) : '0'; $KPA24X = isset($_REQUEST['harga_KPA24X']) ? bigintval($_REQUEST['harga_KPA24X']) : '0'; $KPA36X = isset($_REQUEST['harga_KPA36X']) ? bigintval($_REQUEST['harga_KPA36X']) : '0'; $lokasi = ''; $jenis_unit = ''; $harga_tanah_sk = ''; $faktor_strategis = '';
$kode_desa = !empty($kode_desa) ? clean($kode_desa) : ''; $kode_lokasi = !empty($kode_lokasi) ? clean($kode_lokasi) : ''; $kode_unit = !empty($kode_unit) ? clean($kode_unit) : ''; $kode_sk_tanah = !empty($kode_sk_tanah) ? clean($kode_sk_tanah) : ''; $kode_faktor = !empty($kode_faktor) ? clean($kode_faktor) : ''; $kode_tipe = !empty($kode_tipe) ? clean($kode_tipe) : ''; $kode_sk_bangunan = !empty($kode_sk_bangunan) ? clean($kode_sk_bangunan) : ''; $kode_penjualan = !empty($kode_penjualan) ? clean($kode_penjualan) : ''; $class = !empty($class) ? clean($class) : ''; $status_gambar_siteplan = !empty($status_gambar_siteplan) ? to_number($status_gambar_siteplan) : '0'; $status_gambar_lapangan = !empty($status_gambar_lapangan) ? to_number($status_gambar_lapangan) : '0'; $status_gambar_gs = !empty($status_gambar_gs) ? to_number($status_gambar_gs) : '0'; $program = !empty($program) ? to_number($program) : '0'; $luas_tanah = !empty($luas_tanah) ? to_decimal($luas_tanah) : '0'; $disc_tanah = !empty($disc_tanah) ? to_decimal($disc_tanah, 16) : '0'; $harga_disc_tanah = !empty($harga_disc_tanah) ? to_number($harga_disc_tanah) : '0'; $ppn_tanah = !empty($ppn_tanah) ? to_decimal($ppn_tanah) : '0'; $luas_bangunan = !empty($luas_bangunan) ? to_decimal($luas_bangunan) : '0'; $disc_bangunan = !empty($disc_bangunan) ? to_decimal($disc_bangunan, 16) : '0'; $ppn_bangunan = !empty($ppn_bangunan) ? to_decimal($ppn_bangunan) : '0'; $query = "\n\t\t\t\t\tINSERT INTO STOK \n\t\t\t\t\t(\n\t\t\t\t\tNO_VA,KODE_BLOK, KODE_UNIT, KODE_DESA, KODE_LOKASI, KODE_SK_TANAH, \n\t\t\t\t\tKODE_FAKTOR, KODE_TIPE, KODE_SK_BANGUNAN, KODE_PENJUALAN, \n\t\t\t\t\t\n\t\t\t\t\tLUAS_TANAH, LUAS_BANGUNAN, \n\t\t\t\t\tPPN_TANAH, PPN_BANGUNAN, \n\t\t\t\t\tDISC_TANAH, DISC_BANGUNAN, \n\t\t\t\t\t\n\t\t\t\t\tPROGRESS, \n\t\t\t\t\t\n\t\t\t\t\tCLASS, STATUS_STOK, TERJUAL, PROGRAM,\n\t\t\t\t\t\n\t\t\t\t\tSTATUS_GAMBAR_SITEPLAN, \n\t\t\t\t\tSTATUS_GAMBAR_LAPANGAN, \n\t\t\t\t\tSTATUS_GAMBAR_GS\n\t\t\t\t\t)\n\t\t\t\t\tVALUES\n\t\t\t\t\t(\n\t\t\t\t\t'{$virtual_account}','{$kode_blok}', {$kode_unit}, {$kode_desa}, {$kode_lokasi}, {$kode_sk_tanah}, \n\t\t\t\t\t{$kode_faktor}, {$kode_tipe}, {$kode_sk_bangunan}, {$kode_penjualan}, \n\t\t\t\t\t\n\t\t\t\t\t{$luas_tanah}, {$luas_bangunan}, \n\t\t\t\t\t{$ppn_tanah}, {$ppn_bangunan}, \n\t\t\t\t\t{$disc_tanah}, {$disc_bangunan}, \n\t\t\t\t\t\n\t\t\t\t\t0, \n\t\t\t\t\t\n\t\t\t\t\t'{$class}', '0', '0', '{$program}', \n\t\t\t\t\t\n\t\t\t\t\t'{$status_gambar_siteplan}', \n\t\t\t\t\t'{$status_gambar_lapangan}', \n\t\t\t\t\t'{$status_gambar_gs}'\n\t\t\t\t\t)\t\t\t\t\t\n\t\t\t\t\t"; ex_false($conn->Execute($query), $query); } else { //cek data yang gagal $kode_blok_gagal[] = $kode_blok; } $conn->committrans(); //hitung jumlah gagal $jumlah_gagal += $total_data; //hitung jumlah berhasil $jumlah_berhasil = $jumData - $jumlah_gagal;