}
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M15');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $obj = $conn->Execute("\n\t\tSELECT  \n\t\ts.NO_VA,\n\t\ts.KODE_BLOK,\n\t\ts.LUAS_BANGUNAN,\n\t\ts.STATUS_STOK,\n\t\ts.TERJUAL,\n\t\ts.KODE_PENJUALAN,\n\t\tt.TIPE_BANGUNAN,\n\t\ths.KODE_SK,\n\t\ths.HARGA_CASH_KERAS,\n\t\ths.CB36X,\n\t\ths.CB48X,\n\t\ths.KPA24X,\n\t\ths.KPA36X,\n\t\th.*,\n\t\tju.*,\n\t\tt.*,\n\t\tp.*\n\t\tFROM \n\t\tSTOK s\n\t\tLEFT JOIN TIPE t ON s.KODE_TIPE = t.KODE_TIPE\n\t\tLEFT JOIN HARGA_SK hs ON s.KODE_SK = hs.KODE_SK AND s.KODE_BLOK = hs.KODE_BLOK\n\t\tLEFT JOIN LOKASI h ON s.KODE_LOKASI = h.KODE_LOKASI\n\t\tLEFT JOIN JENIS_UNIT ju ON s.KODE_UNIT = ju.KODE_UNIT\n\t\tLEFT JOIN JENIS_PENJUALAN p ON s.KODE_PENJUALAN = p.KODE_JENIS\n\t\tWHERE\t\t\n\t\ts.KODE_BLOK = '{$id}'");
    $no_va = $obj->fields['NO_VA'];
    $kode_blok = $obj->fields['KODE_BLOK'];
    $kode_lokasi = $obj->fields['KODE_LOKASI'];
    $kode_unit = $obj->fields['KODE_UNIT'];
    $kode_tipe = $obj->fields['KODE_TIPE'];
    $kode_penjualan = $obj->fields['KODE_PENJUALAN'];
    $kode_sk = $obj->fields['KODE_SK'];
    $lokasi = $obj->fields['LOKASI'];
    $jenis_unit = $obj->fields['JENIS_UNIT'];
    $tipe_bangunan = $obj->fields['TIPE_BANGUNAN'];
<?php

require_once '../../../../config/config.php';
die_login();
die_app('A01');
die_mod('PT02');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= "WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT  \n\tCOUNT(KODE_BLOK) AS TOTAL\nFROM \n\tRESERVE\n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
	<td class="text-right">
		<input type="button" id="prev_page" value=" < ">
		Hal : <input type="text" name="page_num" size="5" class="page_num apply text-center" value="<?php 
echo $page_num;
                    ex_empty($cb_data, 'Pilih data yang akan diverifikasi.');
                    foreach ($cb_data as $id_del) {
                        $query = "UPDATE KWITANSI SET \n\t\t\t\t\tVER_KEUANGAN = 1,\n\t\t\t\t\tVER_KEUANGAN_TANGGAL = CONVERT(DATETIME,'{$tgl}',105),\n\t\t\t\t\tVER_KEUANGAN_OFFICER = '{$officer}'\n\t\t\t\t\tWHERE NOMOR_KWITANSI = '{$id_del}'";
                        if ($conn->Execute($query)) {
                            $act[] = $id_del;
                        } else {
                            $error = TRUE;
                        }
                    }
                    $msg = $error ? 'Sebagian data kwitansi gagal diverifikasi.' : 'Data kwitansi berhasil diverifikasi.';
                }
            }
        }
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('');
die_mod('');
$conn = conn($sess_db);
die_conn($conn);
Esempio n. 4
0
<?php

require_once '../../../../config/config.php';
die_login();
die_app('C01');
die_mod('COL03');
$conn = conn($sess_db);
die_conn($conn);
$msg = '';
$error = FALSE;
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        $conn->begintrans();
        $no_surat_akhir = isset($_REQUEST['no_surat_akhir']) ? clean($_REQUEST['no_surat_akhir']) : '';
        $registrasi = isset($_REQUEST['registrasi']) ? clean($_REQUEST['registrasi']) : '';
        $conn->Execute("DELETE FROM REGISTRASI_SURAT");
        $query = "\n\t\tINSERT INTO REGISTRASI_SURAT (\n\t\tNO_SURAT_AKHIR, REGISTRASI\n\t\t)\n\t\tVALUES (\n\t\t'{$no_surat_akhir}', '{$registrasi}'\n\t\t)\n\t\t";
        ex_false($conn->Execute($query), $query);
        $conn->committrans();
        $msg = 'Parameter berhasil diubah.';
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        $conn->rollbacktrans();
    }
    close($conn);
    $json = array('msg' => $msg, 'error' => $error);
    echo json_encode($json);
    exit;
}
Esempio n. 5
0
        include 'marketing/menu.php';
        break;
    case 'C01':
        die_app($sess_app_id);
        include 'collection_tunai/menu.php';
        break;
    case 'C02':
        die_app($sess_app_id);
        include 'collection_kpr/menu.php';
        break;
    case 'C03':
        die_app($sess_app_id);
        include 'ppjb/menu.php';
        break;
    case 'C04':
        die_app($sess_app_id);
        include 'kredit/menu.php';
        break;
}
?>
				</ul>
				<div id="profil">
					<a href="index.php"><?php 
echo $_SESSION['FULL_NAME'];
?>
</a> | 
					<a href="authentic.php?act=logout">Logout</a>
				</div>
				<div class="clear"></div>
			</div>