<?php
ob_start();
error_reporting(0);
include("connect.php");
session_start(); 
$ver = $_SESSION["admin_id"];
$admin_id = $_SESSION["admin_id"];
$dis_id = $_SESSION["manager_id"];
$user_type = $_SESSION["user_type"];
$user_session = $_SESSION["user_session"];
 
$id1 = base64_decode($_GET['id']);
if(!isset($_SESSION["admin_id"])){
   header('location:http://www.btcover.appexperts.net');
}
?>
<!DOCTYPE html>
<html dir="ltr" lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="assets/images/favicon.png">
    <title>BTCOVER : Admin Dashboard</title>
    <!-- Custom CSS -->
    <link rel="stylesheet" type="text/css" href="assets/extra-libs/multicheck/multicheck.css">
    <link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.css" rel="stylesheet">
    <link href="dist/css/style.min.css" rel="stylesheet">
		
		<script>
	
		function myFunction() {
			var txt;
		
			var r = confirm("Are you sure to Cancel!");
			if (r == true) {
				window.location.href="add-policy2.php";
			} 
		}
		</script>
		
</head>

<body>
    <!-- ============================================================== -->
    <!-- Preloader - style you can find in spinners.css -->
    <!-- ============================================================== -->
   
	 <div id="main-wrapper">
   <?php include("header.php"); ?>
    
     <?php include("menu.php"); ?>
	
            <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Bread crumb and right sidebar toggle -->
            <!-- ============================================================== -->
            <div class="page-breadcrumb">
                <div class="row">
                    <div class="col-12 d-flex no-block align-items-center">
                        <h4 class="page-title">All Policy</h4>
                        <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="add-policy.php?id=<?php echo base64_encode($ver)?>"> <span class="label label-info" style="padding:8px 8px 5px; font-size:12px;"> <i class="fas fa-plus" style="font-size:12px;"></i> Add Policy  </span></a>&nbsp;&nbsp;
									
									<a href="download_policy_detail.php"> <span class="label label-info" style="padding:8px 8px 5px; font-size:12px;"> <i class="fa fa-download" style="font-size:12px;"></i> Export Policy Detail  </span></a>
									</li>
									
									
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            <div class="container-fluid" >
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body" style="float:left; width:100%; overflow-Y: auto; height: 500px;">
                                <div class="table-responsive">
                                    <table id="zero_config" class="table table-striped table-bordered">
                                        <thead>
                                            <tr>
											  <th><b>#</b></th>
											    <th><b>Customer Name</b></th>
												 <th><b>Phone No</b></th>
												 <th><b>Address</b></th>
												 <th><b>Policy No.</b></th>
												
											</tr>
                                        </thead>
                                        <tbody>
										  <?php 
									   $c=1;
										if($user_type=='Manager') 
											$selrenew3=mysqli_query($con,"SELECT * FROM `tbl_policy_master` ,tbl_customer where tbl_policy_master.customer_id=tbl_customer.customer_id and tbl_policy_master.manager_id='$dis_id' and tbl_policy_master.status in ('Active','Renewal Pending') order by id desc");
										else
											$selrenew3=mysqli_query($con,"SELECT * FROM `tbl_policy_master` ,tbl_customer where tbl_policy_master.customer_id=tbl_customer.customer_id and tbl_policy_master.manager_id in (select manager_id from tbl_manager where admin_id='$ver') and tbl_policy_master.status in ('Active','Renewal Pending') order by id desc");
										if(mysqli_num_rows($selrenew3)>0)
										{
											while($recset=mysqli_fetch_array($selrenew3))
											{
										?>
										<tr>
										  <td><?php echo $c++; ?></td>
										  <td><?php echo $recset['customer_name']; ?></td>
										  <td><?php echo $recset['phone_no']; ?></td>
										  <td><?php echo $recset['address']; ?></td>
										  <td><a href="policy-detail.php?id=<?php echo base64_encode($recset['policy_no'])?>&user=policy"><?php echo $recset['policy_no']; ?></a></td>
										 
										</tr>
										<?php }} else { ?>
										 <tr>
										  <td colspan='5'>No Data Available</td>
										</tr>
										<?php } ?>
                                        </tbody>
                                       
                                    </table>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
             
            </div>
         
            </div>
             <footer class="footer text-center">
                  2019 &copy; All Rights Reserved by BTCOVER. Designed and Developed by <a href="http://www.belltechnology.in/">Bell Technology</a>.
            </footer>
          
            <!-- ============================================================== -->
            <!-- End footer -->
            <!-- ============================================================== -->
        </div>
        <!-- ============================================================== -->
        <!-- End Page wrapper  -->
        <!-- ============================================================== -->
    </div>
    <!-- ============================================================== -->
    <!-- End Wrapper -->
    <!-- ============================================================== -->
    <!-- ============================================================== -->
    <!-- All Jquery -->
    <!-- ============================================================== -->
     <script src="assets/libs/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap tether Core JavaScript -->
    <script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
    <script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
    <!-- slimscrollbar scrollbar JavaScript -->
    <script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
    <script src="assets/extra-libs/sparkline/sparkline.js"></script>
    <!--Wave Effects -->
    <script src="dist/js/waves.js"></script>
    <!--Menu sidebar -->
    <script src="dist/js/sidebarmenu.js"></script>
    <!--Custom JavaScript -->
    <script src="dist/js/custom.min.js"></script>
    <!-- this page js -->
    <script src="assets/extra-libs/multicheck/datatable-checkbox-init.js"></script>
    <script src="assets/extra-libs/multicheck/jquery.multicheck.js"></script>
    <script src="assets/extra-libs/DataTables/datatables.min.js"></script>
    <script>
        /****************************************
         *       Basic Table                   *
         ****************************************/
        $('#zero_config').DataTable();
    </script>

</body>

</html>