One Hat Cyber Team

View File Name : view_ticket.php

<?php 
 
 include 'config.php';
 define('HOST', $host);
 define('USER', $username);
 define('PASSWORD', $password);
 define('DATABASE', $database);
 require 'class/Database.php';
 require 'class/Users.php';
 require 'class/Time.php';
 require 'class/Tickets.php';
 require 'class/Department.php';
 $database = new Database;
 $users = new Users;
 $time = new Time;
 $department = new Department;
 $tickets = new Tickets;
  
$ticketDetails = $tickets->ticketInfo($_GET['id']);
$ticketReplies = $tickets->getTicketReplies($ticketDetails['id']);
$user = $users->getUserInfo();
$tickets->updateTicketReadStatus($ticketDetails['id']);


?>	

 





<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta http-equiv="x-ua-compatible" content="ie=edge">

    <title></title>
    <link rel="shortcut icon" href="assets/images/favicon.png">

    <!-- fraimwork - css include -->
    <link rel="stylesheet" type="text/css" href="assets/css/bootstrap.min.css">

    <!-- icon css include -->
    <link rel="stylesheet" type="text/css" href="assets/css/fontawesome-all.css">
    <link rel="stylesheet" type="text/css" href="assets/css/flaticon.css">

    <!-- carousel css include -->
    <link rel="stylesheet" type="text/css" href="assets/css/slick.css">
    <link rel="stylesheet" type="text/css" href="assets/css/slick-theme.css">
    <link rel="stylesheet" type="text/css" href="assets/css/animate.css">
    <link rel="stylesheet" type="text/css" href="assets/css/owl.carousel.min.css">
    <link rel="stylesheet" type="text/css" href="assets/css/owl.theme.default.min.css">

    <!-- others css include -->
    <link rel="stylesheet" type="text/css" href="assets/css/magnific-popup.css">
    <link rel="stylesheet" type="text/css" href="assets/css/jquery.mCustomScrollbar.min.css">
    <link rel="stylesheet" type="text/css" href="assets/css/calendar.css">

    <!-- custom css include -->
    <link rel="stylesheet" type="text/css" href="assets/css/style.css">


	 
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>



    <script src="js/jquery.dataTables.min.js"></script>
    <script src="js/dataTables.bootstrap.min.js"></script>
    <link rel="stylesheet" href="css/dataTables.bootstrap.min.css" />
    <script src="js/general.js"></script>
    <script src="js/tickets.js"></script>
    <style>

    </style>
</head>


<body class="homepage2">



    <?php include('header.php');
 
?>

    <!-- breadcrumb-section - start
		================================================== -->
    <section id="breadcrumb-section" class="breadcrumb-section clearfix">
        <div class="jarallax" style="background-image: url(assets/images/slider/slider.webp);">
            <div class="overlay-black">
                <div class="container">
                    <div class="row justify-content-center">
                        <div class="col-lg-6 col-md-12 col-sm-12">

                            <!-- breadcrumb-title - start -->
                            <div class="breadcrumb-title text-center mt-10">
                                <span class="sub-title">all you need to know</span>
                                <h2 class="big-title"><strong>User</strong> Dashboard</h2>
                            </div>
                            <!-- breadcrumb-title - end -->


                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- breadcrumb-section - end
		================================================== -->



		<?php 
    
     
    
    $sql="SELECT * FROM `members` WHERE `id` = '$u_id'";
    $res=mysqli_query($con,$sql);
    
    while($row=mysqli_fetch_assoc($res)){
    ?>

    <section class="user-dashboard-section mb-10 mt-10">
        <div class="container">
            <div class="row">
              
                <div class="col-sm-12">
                 
                    <div class="dashboard-right-sidebar">
                        <div class="tab-content" id="pills-tabContent">
                            

						<section class="comment-list">          
		<article class="row align-items-center">            
			<div class="col-md-12 col-sm-12">
				<div class="panel panel-default arrow left">
					<div class="panel-heading right">
					<?php if($ticketDetails['resolved']) { ?>
					<button type="button" class="btn btn-danger btn-sm">
					  <span class="glyphicon glyphicon-eye-close"></span> Closed
					</button>
					<?php } else { ?>
					<button type="button" class="btn btn-success btn-sm">
					  <span class="glyphicon glyphicon-eye-open"></span> Open
					</button>
					<?php } ?>
					<span class="ticket-title"><?php echo $ticketDetails['title']; ?></span>
					</div>
					<div class="panel-body">						
						<div class="comment-post">
						<p>
						<?php echo $ticketDetails['message']; ?>
						</p>
						</div>                 
					</div>
					<div class="panel-heading right">
						<span class="glyphicon glyphicon-time"></span> <time class="comment-date" datetime="16-12-2014 01:05"><i class="fa fa-clock-o"></i> <?php echo $time->ago($ticketDetails['date']); ?></time>
						&nbsp;&nbsp;<span class="glyphicon glyphicon-user"></span> <?php echo $ticketDetails['creater']; ?>
						&nbsp;&nbsp;<span class="glyphicon glyphicon-briefcase"></span> <?php echo $ticketDetails['department']; ?>
					</div>
				</div>			 
			</div>
		</article>		
		
		<?php foreach ($ticketReplies as $replies) { ?>		
			<article class="row">
				<div class="col-md-12 col-sm-12">
				    
				    
				    <?php if($replies['user'] == 'admin') { ?>
					<div class="panel panel-info arrow right">
						<div class="panel-heading">
						    
														
								<span class="glyphicon glyphicon-user"></span> <b>Admin</b>  
						
							
						<span class="glyphicon glyphicon-time"></span> <time class="comment-date" datetime="16-12-2014 01:05"><i class="fa fa-clock-o"></i> <?php echo $time->ago($replies['date']); ?></time>							
						</div>
						<div class="panel-body">						
							<div class="comment-post">
							<p>
							<?php echo $replies['message']; ?>
							</p>
							</div>                  
						</div>
						
					</div>
						<?php } else { ?>
						
							<div class="panel panel-success arrow right">
						<div class="panel-heading">
						    
														
								<span class="glyphicon glyphicon-user"></span><?php echo $u_name?>
						
							
						<span class="glyphicon glyphicon-time"></span> <time class="comment-date" datetime="16-12-2014 01:05"><i class="fa fa-clock-o"></i> <?php echo $time->ago($replies['date']); ?></time>							
						</div>
						<div class="panel-body">						
							<div class="comment-post">
							<p>
							<?php echo $replies['message']; ?>
							</p>
							</div>                  
						</div>
					</div>
							
							<?php } ?>
					
				</div>            
			</article> 		
		<?php } ?>
		
		<form method="post" id="ticketReply">
			<article class="row">
				<div class="col-md-12 col-sm-12">				
					<div class="form-group">							
						<textarea class="form-control" rows="5" id="message" name="message" placeholder="Enter your reply..." required></textarea>	
					</div>				
			</div>
			</article>  
			<article class="row">
				<div class="col-md-12 col-sm-12">
					<div class="form-group">							
						<input type="submit" name="reply" id="reply" class="btn btn-success" value="Reply" />		
					</div>
				</div>
			</article> 
			<input type="hidden" name="ticketId" id="ticketId" value="<?php echo $ticketDetails['id']; ?>" />	
			<input type="hidden" name="action" id="action" value="saveTicketReplies" />			
		</form>
	</section>	

                        </div>
                    </div>
                </div>
    </section>

    <?php }  ?>


	


	
	<?php include('add_ticket_model.php'); ?>





    <?php include('footer.php')?>



    <!-- carousel jquery include -->
    <script src="assets/js/slick.min.js"></script>
    <script src="assets/js/owl.carousel.min.js"></script>

    <!-- map jquery include -->
    <script src="assets/js/gmap3.min.js"></script>
    <script src="http://maps.google.com/maps/api/js?key=AIzaSyC61_QVqt9LAhwFdlQmsNwi5aUJy9B2SyA"></script>

    <!-- calendar jquery include -->
    <script src="assets/js/atc.min.js"></script>

    <!-- others jquery include -->
    <script src="assets/js/jquery.magnific-popup.min.js"></script>
    <script src="assets/js/isotope.pkgd.min.js"></script>
    <script src="assets/js/jarallax.min.js"></script>
    <script src="assets/js/jquery.mCustomScrollbar.concat.min.js"></script>

    <!-- gallery img loaded - jqury include -->
    <script src="assets/js/imagesloaded.pkgd.min.js"></script>

    <!-- multy count down - jqury include -->
    <script src="assets/js/jquery.countdown.js"></script>


    <!-- custom jquery include -->
    <script src="assets/js/custom.js"></script>




    <!-- Bootstrap js-->
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/bootstrap/bootstrap.bundle.min.js"></script>
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/bootstrap/bootstrap-notify.min.js"></script>
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/bootstrap/popper.min.js"></script>


    <!-- Nav & tab upside js -->
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/nav-tab.js"></script>

    <!-- script js -->
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/script.js"></script>

    <!-- theme setting js -->
    <script src="https://themes.pixelstrap.com/fastkart/assets/js/theme-setting.js"></script>
</body>

</html>