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