<?php session_start(); ?>
<?php include_once('includes/config.php'); ?>
<?php
    include_once("includes/complaint.php");
    $complaint = new complaint();

	//$comreply = $complaint->fetchComplaintReplyDisplay($_GET["case_no"]);
	$complaintss = $complaint->fetchComplaint($_GET["complaint_id"]);

    if(isset($_GET["complaint_id"]))
	{
      $complaintss = $complaint->deleteComplaint($_GET["complaint_id"]);
      header("Location: manage-complaint.php");
  	}
?>
<?php
    include_once("includes/paging.class.php");
    $page = new paging();
    $page->db();
    $page->table = "tbcomplaint";

    if(isset($_GET["page"]) && !empty($_GET["page"])) {
      $current_page = intval($_GET["page"]);
    }
    else
      $current_page = 1;

    $page->page = $current_page;
	$page->order = "case_no";
    $page->ordertype = "DESC";
    $page->page_limit = 10;
    $page->generateSelectQuery();
    $page->generatePaging();
    $complaints = $page->page_results;
?>
<?php

                                                    $page->db();
                                                    $page->table = "tbcomplaintreply";

                                                    if(isset($_GET["page"]) && !empty($_GET["page"])) {
                                                        $current_page = intval($_GET["page"]);
                                                    }
                                                    else
                                                        $current_page = 1;

                                                    //$page->cond ="case_no=".stripslashes($_GET["case_no"]);
                                                    $page->page = $current_page;
                                                    $page->order = "comreply_id";
                                                    $page->ordertype = "DESC";
                                                    $page->page_limit = 1;
                                                    $page->generateSelectQuery();
                                                    $page->generatePaging();
                                                    $comreply = $page->page_results;
                                               ?>
<?php include 'header.php' ?>
<link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Roboto:400,100,300,500">
<link rel="stylesheet" href="../bower_components/bootstrap/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="../bower_components/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="../dist/css/style.css">
<script type="text/javascript">
			function complaint_id(complaint_id)
			{
				if(confirm('Are you sure to delete this record <?php echo $complaintss["case_no"]; ?> ?'))
				{
					window.location.href='manage-complaint.php?complaint_id='+complaint_id;
				}
			}
</script>
<div class="two-sp columns"> <?php include ("inc_menu.php");?> </div>
<div class="two-sp-no-padding columns">
  &nbsp;
</div>

<div class="ten columns">
	<div id="page-wrapper">
            <div class="row">
                <div class="eleven columns">
                <h3>Manage Complaint</h3>
                </div>
                <div class="eleven columns top-repair-nav">
                <table width="100%"  border="0" align="center" cellpadding="5" cellspacing="10">
                  <tr>
                      <td>
                       <a href="add-complaint.php"><strong>ADD COMPLAINT</strong></a> |
                       <a href="manage-complaint.php"><strong>MANAGE COMPLAINT</strong></a>
                       </td>
                      </tr>
                </table>
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->
        	  		<div class="row">
                    <div class="col-lg-12">
                      <div class="panel panel-default">
                    	<div class="panel-body">
                        <div class="table-responsive">
                          <table class="table table-striped table-bordered table-hover">
                                <thead>
                                    <tr>
                                        <th>Case No</th>
										<th>Branch</th>
                                        <th>Name</th>
                                        <th>Email</th>
                                        <th>Contact</th>
                                        <th>Job No/Invoice No</th>
                                        <th>Status</th>
										<th>Operator Assign</th>
                                        <th>Date</th>
                                        <?php if($_SESSION['RP_Username']=="admin" || $_SESSION['RP_Username']=="clement" || $_SESSION['RP_Username']=="mel"){?>
                                        <th>Action</th>
                                        <?php }?>
                                    </tr>
                                </thead>
                                <tbody>
									<?php
                                      if(!empty($complaints)) {
                                        foreach($complaints as $complaint) {
                                     ?>
                                    <tr>
                                        <td><a href="case.php?case_no=<?php echo $complaint["case_no"]; ?>"><?php echo $complaint["case_no"] ?></a></td>
										<td><?php echo $complaint["branch"]; ?></td>
                                        <td><?php echo $complaint["name"]; ?></td>
                                        <td><?php echo $complaint["email"]; ?></td>
                                        <td><?php echo $complaint["contact"]; ?></td>
                                        <td><?php echo $complaint["job"]; ?></td>
                                        <td>
                                        		<?php
                                                            if(!empty($comreply)) {
                                                                foreach($comreply as $comreplys) {
                                                ?>
                                                <input type="hidden" name="case_no" value="<?php echo $case_no; ?>">
                                            <div><?php echo str_replace("\n","<br>",$comreplys['content']); ?>
                                            </div>
                                            <?php
											  }
											}
										 ?>

                                            <div><?php echo $complaint["status"]; ?><br /></div>


                                        </td>
										<td><?php echo $complaint["assign"]; ?></td>
                                        <td><?php echo date ("j F Y, g:i a",strtotime($complaint["date"])); ?></td>
                                        <?php if($_SESSION['RP_Username']=="admin" || $_SESSION['RP_Username']=="clement" || $_SESSION['RP_Username']=="mel"){?>
                                        <td><a href="javascript:complaint_id(<?php echo $complaint["complaint_id"] ?>)"><img src="../images/user-trash.png" width="16" height="16" /></a></td>
                                        <?php }?>
                                    </tr>
                                </tbody>
									<?php
                                    }
                                  }
                              ?>
                         </table>
                          <div class="link-fonts" style="clear:both; margin:13px 21px 0px 0px; float:right; font-weight:bold;">
								<?php
                                    $url = "manage-complaint.php";
                                    if($page->page <= 1)
                                        $start = '';
                                    else
                                        $start = '<a href="'.$url.'?page=1" class="listViewPaginationLinkS1">Start</a>';

                                    //prev
                                    if($page->page <= 1)
                                        $prev = '';
                                    else
                                        $prev = '<a href="'.$url.'?page='.$page->page_details["prev"].'" class="listViewPaginationLinkS1">Previous</a>';

                                    //label
                                    $label = '<span class="pageNumbers">'.$page->page_details["start"].'&nbsp;&nbsp;-&nbsp;&nbsp;'.$page->page_details["to"].'&nbsp;&nbsp;of&nbsp;&nbsp;'.$page->page_details["total"].'</span>';

                                    //next
                                    if($page->page >= $page->page_details["last"])
                                        $next = '';
                                    else
                                        $next = '<a href="'.$url.'?page='.$page->page_details["next"].'" class="listViewPaginationLinkS1">Next</a>';

                                    //end
                                    if($page->page >= $page->page_details["last"])
                                        $end = '';
                                    else
                                        $end = '<a href="'.$url.'?page='.$page->page_details["last"].'" class="listViewPaginationLinkS1">End</a>';

                                    echo $start.'&nbsp;&nbsp;&nbsp;'.$prev.'&nbsp;&nbsp;&nbsp;'.$label.'&nbsp;&nbsp;&nbsp;'.$next.'&nbsp;&nbsp;&nbsp;'.$end;

                                    $page->mysqlClose();
                                ?>
                          </div>
                      </div>
                    </div>
                 </div>
                </div>
                <!-- /.row -->
            <!-- /.row -->
        </div>
        <!-- /#page-wrapper -->
    </div>
</div>
<script src="../bower_components/jquery/dist/jquery.min.js"></script>
<script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="../dist/js/jquery.backstretch.min.js"></script>
<script src="../dist/js/scripts.js"></script>
<?php include 'footer.php'; ?>
<?php $db = new db;
	  $db->mysqlClose(); ?>