File: /home/rtbrisc/public_html/admin/main/helpdesk/update.php
<?php include("../general/header.php"); ?>
<?php
$ticketID = $_GET['tid'];
?>
<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>REQUEST DETAILS</p>
</li>
<li><a href="../helpdesk/history.php" class="active">SERVICE HISTORY</a> </li>
<li><a href="../helpdesk" class="active">HELPDESK</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");
require_once("../worker/workers/server/customercare.php");
$history = mysqli_query($iss, "SELECT * FROM tblhelpdeskrequest WHERE TicketID = '$ticketID'");
if($his_row = mysqli_fetch_assoc($history)){
$ticket = $his_row['TicketID'];
$techid = $his_row['TechnicianID'];
$supporttrip = mysqli_query($iss, "SELECT * FROM tblsupporttrip WHERE TicketID = '$ticket' && TechnicianID = '$techid'");
$trip_his = mysqli_fetch_assoc($supporttrip);
?>
<!-- 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>TICKET ID: <a href="#" data-toggle="modal" data-target="#info"><?php echo $his_row['TicketID']; ?></a></h3>
<span class="text-danger"><?php echo @$_SESSION['det_err'] ?></span>
<span class="text-success"><?php echo @$_SESSION['det_suc'] ?></span>
</div>
<div class="grid-body no-border">
<h3>REQUEST UPDATE</h3>
<h4><b>Have you been contacted?:</b>
<?php
$contact_query = mysqli_query($iss, "SELECT * FROM tblhelpdeskupdate WHERE TicketID = '$ticket'");
$contact_row = mysqli_fetch_assoc($contact_query);
if($contact_row){
echo $contact_row['CustomerContacted'];
}else{
echo "No";
}
?></h4>
<h4><b>Is replacement part required to fix the device?:</b>
<?php
echo $contact_row['ReplacementRequired'];
?></h4>
<h4><b>Cost of replacement part to be paid for:</b>
<?php
if($contact_row['ReplacementRequired'] == "Yes"){
$detail = mysqli_query($iss, "SELECT * FROM tblpaymentinfo WHERE TicketID = '$ticket'");
echo '<table class="table table-striped table-advance table-hover" width="50%"" id="myTable">';
echo "<tr>";
echo "<th>Required Item</th>";
echo "<th>Price</th>";
echo "</tr>";
while($detail_row = mysqli_fetch_assoc($detail)){
echo "<tr>";
echo "<td>";
echo $detail_row['Item'];
echo "</td>";
echo "<td>";
echo $detail_row['ItemPrice'];
echo "</td>";
echo "</tr>";
}
$tot = mysqli_query($iss, "SELECT * FROM tblpaymentticket WHERE TicketID = '$ticket'");
$tot_row = mysqli_fetch_assoc($tot);
if($tot){
$num = $tot_row['ServiceCharge'] + $tot_row['TotalAmount'];
echo "<tr>";
echo "<td>Service Charge</td><td>" . $tot_row['ServiceCharge'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Total</td><td>" . $num . "</td>";
echo "</tr>";
}
echo "</table>";
}else{
echo "Not Applicable";
}
?></h4>
<?php
if(empty($his_row['TechnicianID'])){
?>
<h4><b>Technician Assigned?: </b> No </h4>
<span class="text-danger">(Technician Not yet Assigned)</span>
<?php
}else{
if ($trip_his) {
?>
<h4><b>Technician Assigned?: </b> Yes</h4>
<h4><b>Technician ID: </b>
<?php
$tech = $his_row['TechnicianID'];
$tech_data = mysqli_query($ccs, "SELECT * FROM tbltechnician WHERE TechnicianID = '$tech'");
$tech_row = mysqli_fetch_assoc($tech_data);
echo $tech_row['Firstname'] . " " . $tech_row['Lastname'] . " (" . $tech_row['TechnicianID'] . ")";
?>
</h4>
<h4><b>Trip Status: </b>
<?php
if($trip_his['TripStatus'] == 0){
echo "Not Started";
}else if($trip_his['TripStatus'] == 1){
echo "Started";
}else if($trip_his['TripStatus'] == 2){
echo "Finished";
}else{
echo "Invalid Trip Status";
}
?></h4>
<h4><b>Task Status: </b>
<?php
if($trip_his['TaskStatus'] == 0){
echo "Not Started";
}else if($trip_his['TaskStatus'] == 1 && ($his_row['TrackStatus'] == 0 || $his_row['TrackStatus'] == 2)){
echo "Started";
}else if($trip_his['TaskStatus'] == 1 && $his_row['TrackStatus'] == 1){
echo "<span class='text-danger'>Device is being tracked</span>";
}else if($trip_his['TaskStatus'] == 2 && ($his_row['TrackStatus'] == 0 || $his_row['TrackStatus'] == 2)){
echo "Finished";
}else if($trip_his['TaskStatus'] == 2 && $his_row['TrackStatus'] == 1){
echo "<span class='text-danger'>Device is being tracked</span>";
}else{
echo "Invalid Task Status";
}
?></h4>
<?php
}else{ echo "Invalid Ticket ID"; }
}
?>
<h4><b>Payment Status: </b>
<?php
$tick = $his_row['TicketID'];
$pay = mysqli_query($iss, "SELECT * FROM tblpaymentticket WHERE TicketID = '$tick'");
$pay_row = mysqli_fetch_assoc($pay);
if($pay_row['PaymentStatus'] == 1){
$payid = $pay_row['PaymentID'];
echo "<span class='text-danger'><b>Payment Ticket Generated. <a href='../payment/pay.php?tid=$payid'>Click here to proceed with payment</a></b></span>";
}else if($pay_row['PaymentStatus'] == 2){
echo "<span css='text-success'>Paid.</span>";
}else{
echo "Payment ticket not applicable.";
}
?></h4>
<?php
}else{
echo "No Details";
}
?>
<br>
<?php
if($trip_his['TaskStatus'] == 2 && $trip_his['Confirmation'] == 0 && $trip_his['Rating'] == 0 && ($his_row['TrackStatus'] == 0 || $his_row['TrackStatus'] == 2)){
?>
<a href="completion.php?tid=<?php echo $techid; ?>&tick=<?php echo $ticket; ?>" class="btn btn-primary" style="background-color: #C7100E; margin-bottom: 5px;">Task Completion Confirmation</a>
<a href="#" class="btn btn-warning" data-toggle='modal' data-target='#report' style="margin-bottom: 5px;">Report Technician</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Helpdesk List</a>
<?php
}elseif(($trip_his['TaskStatus'] == 1 || $trip_his['TaskStatus'] == 2) && $trip_his['Confirmation'] == 0 && $trip_his['Rating'] == 0 && $his_row['TrackStatus'] == 1) {
?>
<p class="text-danger">This request is currently Tracked, please make sure your device has been returned before you disable tracking.</p>
<a href="#" class="btn btn-warning" data-toggle='modal' data-target='#report' style="margin-bottom: 5px;">Report Technician</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Helpdesk List</a>
<?php
}elseif($trip_his['TaskStatus'] == 2 && $trip_his['Confirmation'] == 1 && $trip_his['Rating'] == 0) {
?>
<a href="../rating/rate.php?tid=<?php echo $techid; ?>&tick=<?php echo $ticket; ?>" class="btn btn-primary" style="background-color: #C7100E; margin-bottom: 5px;">Service Rating</a>
<a href="#" class="btn btn-warning" data-toggle='modal' data-target='#report' style="margin-bottom: 5px;">Report Technician</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Helpdesk List</a>
<?php
}elseif($trip_his['TaskStatus'] == 2 && $trip_his['Confirmation'] == 1 && $trip_his['Rating'] == 1){
?>
<a href="#" class="btn btn-warning" data-toggle='modal' data-target='#report' style="margin-bottom: 5px;">Report Technician</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Helpdesk List</a>
<?php
}else{
?>
<a href="#" class="btn btn-warning" data-toggle='modal' data-target='#report' style="margin-bottom: 5px;">Report Technician</a>
<a href="#" data-toggle="modal" data-target="#<?php echo $ticket; ?>" class="btn btn-primary" style="background-color: #C7100E; margin-bottom: 5px;">Cancel Request</a>
<a href="history.php" class="btn btn-primary" style="margin-bottom: 5px;">Back To Helpdesk List</a>
<?php
}
?>
<!-- Customer Report Modal -->
<div class="modal fade" id="report" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel"><b>Report Technician: (Ticket ID: <?php echo $ticket; ?>)</b></h4>
</div>
<div class="modal-body text-black">
<form method="post" action="../worker/" enctype="multipart/form-data" id="form_traditional_validation" name="form_traditional_validation" role="form" autocomplete="off" class="validate">
<input type="hidden" name="txtCustomerID" id="txtCustomerID" value="<?php echo $customerID; ?>">
<input type="hidden" name="txtTicketID" id="txtTicketID" value="<?php echo $ticket; ?>">
<div class="form-group row">
<label for="need" class="control-label col-lg-3 text-right">Complain: <span class="text-danger">*</span></label>
<div class="col-lg-9">
<textarea class="form-control" rows="4" id="txtComplain" name="txtComplain" placeholder="Please Type In You Complains" required></textarea>
</div>
</div>
</div>
<div class="modal-footer">
<input type="submit" name="submit" class="btn btn-primary" style="background-color: #C7100E;" value="Report Technician">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
</div>
</form>
</div>
</div>
</div>
<!-- Helpdesk Request Modal -->
<div class="modal fade" id="<?php echo $ticket; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel"><b>Cancel Confirmation (Ticket ID: <?php echo $ticket; ?>)</b></h4>
</div>
<div class="modal-body text-black">
Do you really want to cancel this request?
</div>
<div class="modal-footer">
<a href="cancel.php?tid=<?php echo $ticketID; ?>&tech=<?php echo $his_row['TechnicianID']; ?>" class="btn btn-primary" style="background-color: #C7100E;">Proceed</a>
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</div>
<!-- Modal -->
<div class="modal fade" id="info" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">Ticket ID: <?php echo $his_row['TicketID']; ?></h4>
</div>
<div class="modal-body text-black">
<!-- <b>Customer ID:</b> <?php //echo $his_row['CustomerID']; ?><br> -->
<h3>Request Information</h3>
<b>Support Plan:</b>
<?php
$supportID = $his_row['SupportPlanID'];
$support = mysqli_query($utl, "SELECT * FROM tblsupportplan WHERE SupportPlanID = $supportID");
$support_row = mysqli_fetch_assoc($support);
echo $support_row['SupportPlanText'];
?><br>
<b>Request:</b>
<?php
$requestID = $his_row['RequestID'];
$request = mysqli_query($utl, "SELECT * FROM tblrequest WHERE RequestID = $requestID ");
$request_row = mysqli_fetch_assoc($request);
echo $request_row['RequestText'];
?><br>
<b>Request Type:</b>
<?php
$requestTypeID = $his_row['RequestTypeID'];
$request_type = mysqli_query($utl, "SELECT * FROM tblrequesttype WHERE RequestID = $requestID && RequestTypeID = $requestTypeID");
$request_type_row = mysqli_fetch_assoc($request_type);
echo $request_type_row['RequestTypeText'];
?><br>
<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>
<b>Support Time Type:</b>
<?php
$supporttimetype = $his_row['SupportTimeType'];
$time_his = mysqli_query($utl, "SELECT * FROM tblsupporttime WHERE SupportTimeID = '$supporttimetype'");
$time_his_row = mysqli_fetch_assoc($time_his);
echo $time_his_row['SupportTimeType'];
?><br>
<b>Support Time:</b> <?php echo $his_row['SupportTime']; ?><br>
<h3>Contact Information</h3>
<?php
$tick = $his_row['TicketID'];
$contact = mysqli_query($iss, "SELECT * FROM tblsupportinfo WHERE TicketID = '$tick'");
$contact_row = mysqli_fetch_assoc($contact);
echo "Contact Name: " . $contact_row['SupportName'] . "<br>";
echo "Contact Number: " . $contact_row['SupportNumber'] . "<br>";
echo "Contact Email: " . $contact_row['SupportEmail'] . "<br>";
echo "Contact Location: " . $contact_row['SupportLocation'] . "<br>";
?>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary" onclick="PrintThis('<?php echo $his_row['TicketID']; ?>')">Print Ticket</button>
</div>
</div>
</div>
</div>
<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"); ?>
</body>
<?php
unset($_SESSION['det_err']);
unset($_SESSION['det_suc']);
?>
</html>