File: /home/rtbrisc/public_html/admin/main/track/details.php
<?php include("../general/header.php"); ?>
<?php
$ticketID = $_GET['track'];
?>
<body class="">
<?php include("../general/navbar.php"); ?>
<!-- BEGIN CONTENT -->
<div class="page-container row-fluid">
<?php include("../general/sidebar.php"); ?>
<!-- BEGIN PAGE CONTAINER-->
<div class="page-content">
<div class="content">
<!-- BEGIN PAGE TITLE -->
<?php include("../general/customer_name.php"); ?>
<!-- END PAGE TITLE -->
<ul class="breadcrumb">
<li>
<p>TRACKING DETAILS</p>
</li>
<li><a href="available.php" class="active">GENERATE TRACKING ID</a> </li>
<li><a href="../track" class="active">TRACK YOUR DEVICE</a> </li>
<li><a href="../dashboard" class="active">DASHBOARD</a> </li>
</ul>
<?php
require_once("../worker/workers/server/customer.php");
require_once("../worker/workers/server/utilities.php");
require_once("../worker/workers/server/issues.php");
$history = mysqli_query($iss, "SELECT r.TicketID, r.CustomerID, r.SupportPlanID, r.RequestID, r.RequestTypeID, r.DeviceTypeID, r.DeviceTypeInfo, r.DeviceBrandID, r.DeviceBrandInfo, r.DeviceModel, r.Description, r.SupportTimeType, r.SupportTime, r.StatusFlag, r.TechnicianID, t.TrackingID, t.TrackStatus, t.PickDate
FROM tblhelpdeskrequest r, tbltracking t
WHERE r.TicketID = '$ticketID' && t.TicketID = '$ticketID'");
if($his_row = mysqli_fetch_assoc($history)){
?>
<!-- BEGIN PLACE PAGE CONTENT HERE -->
<div class="row">
<div class="col-md-12 col-vlg-12 col-sm-12">
<div class="grid simple form-grid horizontal red">
<div class="grid-title no-border">
<h3>Tracking ID: <?php echo $his_row['TrackingID']; ?></h3>
</div>
<span class="text-danger"><?php echo @$_SESSION['det_err'] ?></span>
<div class="grid-body no-border">
<h3>Device Status</h3>
<ul>
<?php
$tid = $his_row['TrackingID'];
$track = mysqli_query($iss, "SELECT * FROM tbltrackinfo WHERE TrackingID = '$tid' ORDER BY DateCreated DESC");
if($track){
while($track_his = mysqli_fetch_assoc($track)){
?>
<li><h4><?php echo $track_his['TrackUpdate']; ?></h4></li>
<?php
}
}else{
echo "No Updates Yet!!!";
}
?>
</ul>
<h3>Device Information</h3>
<b>Device Type:</b>
<?php
$deviceType = $his_row['DeviceTypeID'];
$device = mysqli_query($utl, "SELECT * FROM tbldevice WHERE DeviceID = $deviceType ");
$devicetype_row = mysqli_fetch_assoc($device);
echo $devicetype_row['DeviceText'] . " -" . $his_row['DeviceTypeInfo'];
?><br>
<b>Device Brand:</b>
<?php
$deviceBrand = $his_row['DeviceBrandID'];
$device_brand = mysqli_query($utl, "SELECT * FROM tbldevicebrand WHERE DeviceBrandID = $deviceBrand ");
$device_brand_row = mysqli_fetch_assoc($device_brand);
echo $device_brand_row['DeviceBrandText'] . " -" . $his_row['DeviceBrandInfo'];
?><br>
<b>Device Model:</b> <?php echo $his_row['DeviceModel']; ?><br>
<b>Description:</b> <?php echo $his_row['Description']; ?><br>
<?php
}else{
echo "No Details";
}
?>
<br>
<?php
if($his_row['TrackStatus'] < 2){
?>
<a href="update.php?tid=<?php echo $ticketID; ?>" class="btn btn-primary" style="background-color: #C7100E; margin-bottom: 5px;">End Tracking</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Tracking List</a>
<?php
}else{
?>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Tracking List</a>
<?php
}
?>
<br>
</div>
</div>
</div>
</div>
<!-- END DASHBOARD TILES -->
<!-- END PLACE PAGE CONTENT HERE -->
</div>
</div>
<!-- END PAGE CONTAINER -->
<?php include("../general/chat_bar.php"); ?>
</div>
<!-- END CONTENT -->
<?php include("../general/footer.php"); ?>
<script src="../assets/js/moment/moment.js"></script>
<script src="../assets/js/bootstrap-material-datetimepicker/js/bootstrap-material-datetimepicker.js"></script>
<script src="../assets/js/bootstrap-daterangepicker/daterangepicker.js"></script>
<script>
$(function() {
$('input[name="txtDateTime"]').daterangepicker({
timePicker: true,
singleDatePicker: true,
showDropdowns: true,
minYear: moment().startOf('hour'),
maxYear: moment().startOf('hour').add(32, 'hour'),
locale: {
format: 'M/DD/YYYY hh:mm A'
}
//minYear: 1901,
//maxYear: parseInt(moment().format('YYYY'),10)
});
});
</script>
</body>
<?php
unset($_SESSION['det_err']);
?>
</html>