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; }
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"); }