File: /home/rtbrisc/public_html/admin/main/project/history.php
<?php include("../general/header.php"); ?>
<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 HISTORY</p>
</li>
<li><a href="../project" class="active">PROJECT SUPPORT</a> </li>
<li><a href="../dashboard" class="active">DASHBOARD</a> </li>
</ul>
<!-- BEGIN PlACE PAGE CONTENT HERE -->
<div class="row">
<div class="col-md-12 col-vlg-12 col-sm-12">
<div class="tiles m-b-10">
<div class="tiles-body">
<input type="text" class="form-control" id="mySearch" onkeyup="mySearch()" placeholder="Search Report">
<table class="table table-striped table-advance table-hover" id="myTable">
<thead>
<tr>
<th>Ticket ID</th>
<th>Project Type</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
require_once("../worker/workers/server/issues.php");
require_once("../worker/workers/server/utilities.php");
//
$history = mysqli_query($iss, "SELECT * FROM tblprojects WHERE CustomerID = '$customerID' ORDER BY DateCreated DESC");
while($his_row = mysqli_fetch_assoc($history)){
?>
<tr>
<td><a href="#" data-toggle="modal" data-target="#<?php echo $his_row['TicketID']; ?>"><?php echo $his_row['TicketID']; ?></a></td>
<td>
<?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'];
?>
</td>
<td>
<?php
$status = $his_row['StatusFlag'];
if($status == 0){
echo "Ongoing";
}elseif($status == 1){
echo "Done";
}elseif($status == 2){
echo "Cancelled";
}else{
echo "Unknown";
}
?>
</td>
<td>
<?php if($his_row['StatusFlag'] == 0 || $his_row['StatusFlag'] == 1){ ?>
<a href="update.php?tid=<?php echo $his_row['TicketID']; ?>" class="btn btn-warning">View Status</a>
<?php }else{ ?>
<a href="details.php?tid=<?php echo $his_row['TicketID']; ?>" class="btn btn-primary">View Details</a>
<?php } ?>
</td>
</tr>
<!-- Modal -->
<div class="modal fade" id="<?php echo $his_row['TicketID']; ?>" 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 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>
<?php
}
?>
</tbody>
</table>
</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>
function mySearch() {
// Declare variables
var input, filter, table, tr, td, i;
input = document.getElementById("mySearch");
filter = input.value.toUpperCase();
table = document.getElementById("myTable");
tr = table.getElementsByTagName("tr");
// Loop through all table rows, and hide those who don't match the search query
for (i = 0; i < tr.length; i++) {
td = tr[i].getElementsByTagName("td")[0];
if (td) {
if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
tr[i].style.display = "";
} else {
tr[i].style.display = "none";
}
}
}
}
</script>
</body>
</html>