<?php

require_once '../../../../../config/config.php';
$msg = '';
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$app_id = isset($_REQUEST['app_id']) ? clean($_REQUEST['app_id']) : '';
$modul_name = isset($_REQUEST['modul_name']) ? clean($_REQUEST['modul_name']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        ex_login();
        ex_app('A01');
        ex_mod('PU05');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        if ($act == 'Edit') {
            ex_ha('PU05', 'U');
            ex_empty($app_id, 'Pilih app.');
            ex_empty($modul_name, 'Modul harus diisi.');
            $ols_modul_name = $conn->Execute("SELECT MODUL_NAME FROM APPLICATION_MODULS WHERE MODUL_ID = '{$id}'")->fields['MODUL_NAME'];
            if ($modul_name != $ols_modul_name) {
                $query = "SELECT COUNT(MODUL_NAME) AS TOTAL FROM APPLICATION_MODULS WHERE MODUL_NAME = '{$modul_name}'";
                ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$modul_name}\" telah terdaftar.");
            }
            $query = "\n\t\t\tUPDATE APPLICATION_MODULS \n\t\t\tSET APP_ID = '{$app_id}',\n\t\t\t\tMODUL_NAME = '{$modul_name}'\n\t\t\tWHERE\n\t\t\t\tMODUL_ID = '{$id}'\n\t\t\t";
            ex_false($conn->Execute($query), $query);
            $msg = 'Data modul berhasil diubah.';
        }
        $conn->committrans();

$base_harga_tanah = 0;
$nilai_tambah = 0;
$nilai_kurang = 0;
$fs_harga_tanah = 0;
$disc_harga_tanah = 0;
$ppn_harga_tanah = 0;
$harga_tanah = 0;
$base_harga_bangunan = 0;
$fs_harga_bangunan = 0;
$disc_harga_bangunan = 0;
$ppn_harga_bangunan = 0;
$harga_bangunan = 0;
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        ex_login();
        ex_app('M');
        ex_mod('M28');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        if ($act == 'Tambah') {
            ex_ha('M28', 'I');
            ex_empty($kode_blok, 'Kode Blok harus diisi.');
            ex_empty($no_va, 'Nomor VA harus diisi.');
            ex_empty($kode_lokasi, 'Tower harus diisi.');
            ex_empty($kode_unit, 'Jenis unit harus diisi.');
            ex_empty($kode_tipe, 'Tipe harus diisi.');
            ex_empty($kode_penjualan, 'Jenis penjualan harus diisi.');
            $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM STOK WHERE KODE_BLOK = '{$kode_blok}'";
            ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \"{$kode_blok}\" telah terdaftar.");
            $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM STOK WHERE NO_VA = '{$no_va}'";

<?php

require_once '../../../../config/config.php';
$msg = '';
$error = FALSE;
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$user_id = isset($_REQUEST['user_id']) ? clean($_REQUEST['user_id']) : '';
$login_id = isset($_REQUEST['login_id']) ? clean($_REQUEST['login_id']) : '';
$passowrd_id = isset($_REQUEST['passowrd_id']) ? clean($_REQUEST['passowrd_id']) : '';
$full_name = isset($_REQUEST['full_name']) ? clean($_REQUEST['full_name']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        ex_login();
        ex_app('C01');
        ex_mod('COL02');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        if ($act == 'Tambah') {
            ex_ha('COL02', 'I');
            ex_empty($user_id, 'User id harus diisi.');
            ex_empty($login_id, 'Login id harus diisi.');
            ex_empty($passowrd_id, 'Password harus diisi.');
            ex_empty($full_name, 'Nama harus diisi.');
            $query = "SELECT COUNT(USER_ID) AS TOTAL FROM USER_APPLICATIONS WHERE USER_ID = '{$user_id}'";
            ex_found($conn->Execute($query)->fields['TOTAL'], "User ID \"{$user_id}\" telah terdaftar.");
            $query = "SELECT COUNT(LOGIN_ID) AS TOTAL FROM USER_APPLICATIONS WHERE LOGIN_ID = '{$login_id}'";
            ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$login_id}\" telah terdaftar.");
            $query = "INSERT INTO USER_APPLICATIONS (USER_ID, LOGIN_ID, PASSOWRD_ID, FULL_NAME)\n\t\t\tVALUES('{$user_id}', '{$login_id}', '{$passowrd_id}', '{$full_name}')";
            ex_false($conn->Execute($query), $query);