File: /home/rtbrisc/public_html/admin/main/project/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>PROJECT DETAILS</p>
</li>
<li><a href="../project/history.php" class="active">PROJECT HISTORY</a> </li>
<li><a href="../project" class="active">PROJECT</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 tblprojects 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>
</div>
<span class="text-danger"><?php echo @$_SESSION['det_err'] ?></span>
<div class="grid-body no-border">
<h3>PROJECT SUPPORT UPDATE</h3>
<h4><b>Have you been contacted?:</b>
<?php
$contact_query = mysqli_query($iss, "SELECT * FROM tblprojectupdate WHERE TicketID = '$ticket'");
$contact_row = mysqli_fetch_assoc($contact_query);
if($contact_row){
echo $contact_row['CustomerContacted'];
}else{
echo "No";
}
?></h4>
<h4><b>Have you sent supporting document(s)?:</b>
<?php
echo $contact_row['Document'];
?></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){
echo "Started";
}else if($trip_his['TaskStatus'] == 2){
echo "Finished";
}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 Project Support 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 Project Support 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 Project Support 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 Project Support 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 Project Support 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>
<!-- Project Cancel 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">Ticket ID: <?php echo $ticket; ?></h4>
</div>
<div class="modal-body text-black">
Do you really want to cancel this project?
</div>
<div class="modal-footer">
<a href="cancel.php?tid=<?php echo $ticketID; ?>" 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>Project 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>Project Type:</b>
<?php
$projectType = $his_row['ProjectTypeID'];
$req = mysqli_query($utl, "SELECT * FROM tblprojecttype WHERE ProjectTypeID = $projectType");
$request_row = mysqli_fetch_assoc($req);
echo $request_row['ProjectTypeText'] . " -" . $his_row['ProjectTypeOther'];
?><br>
<b>Project Desription:</b> <?php echo $his_row['Description']; ?><br>
<b>Project Duration:</b>
<?php
$durationID = $his_row['ProjectTenure'];
$duration = mysqli_query($utl, "SELECT * FROM tblprojecttenure WHERE ProjectTenureID = $durationID");
$duration_row = mysqli_fetch_assoc($duration);
echo $duration_row['ProjectTenureText'];
?><br>
<b>Start Date:</b> <?php echo $his_row['ProjectStart']; ?><br>
<b>Location:</b> <?php echo $his_row['ProjectLocation']; ?><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']);
?>
</html>