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;
