Esempio n. 1
0
function track_getDetailStatus($id)
{
    $query = "SELECT h.id,h.idtransaksi,h.idstatus, h.tglwaktu, h.idkecamatan, h.idkantorcabang, a.nama nmkec, b.nama nmkab, c.deskripsi FROM historystatus h,kecamatan a, kabupaten b, tblstatus c where h.idkecamatan=a.id and a.idkabupaten=b.id and h.idstatus=c.id and idtransaksi={$id} order by h.tglwaktu";
    $result = mysql_query($query);
    $hasil = array();
    if (!$result) {
        $message = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $query;
        die($message);
    }
    while ($row = mysql_fetch_assoc($result)) {
        if ($row['idkantorcabang'] != NULL) {
            $nmkc = kc_getNamaKC($row['idkantorcabang']);
            $row['nmkc'] = $nmkc;
        }
        $hasil[] = $row;
    }
    return $hasil;
}
Esempio n. 2
0
require_once '../lib/auth.php';
require_once '../modules/kantor_cabang.php';
require_once '../modules/tracking.php';
if (!empty($_REQUEST['op'])) {
    switch ($_REQUEST['op']) {
        case 'login':
            $hasil = auth_autentifikasi($_POST['username'], $_POST['password']);
            if ($hasil) {
                $_SESSION['id'] = $hasil['id'];
                $_SESSION['nama'] = $hasil['nama'];
                $_SESSION['jabatan'] = $hasil['jabatan'];
                if ($_SESSION['jabatan'] == 'peg. pengiriman') {
                    $_SESSION['rute'] = track_getRuteByIdPeg($_SESSION['id']);
                }
                $_SESSION['idkantorcabang'] = $hasil['idkantorcabang'];
                $_SESSION['namakantorcabang'] = kc_getNamaKC($hasil['idkantorcabang']);
                $_SESSION['idkecamatan'] = kc_getIdKecKC($hasil['idkantorcabang']);
                unset($_SESSION['error_login']);
                header("Location: administratif/index.php");
            } else {
                $_SESSION['error_login'] = "******";
                header("Location: index.php");
            }
            break;
        case 'logout':
            auth_logout();
            break;
    }
} else {
    header("Location: ../index.php");
}