PHP to_number函数代码示例

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');