<?php
ob_start();
error_reporting(0);
include("connect.php");
session_start(); 
$ver = $_SESSION["admin_id"];
$user_id = $_SESSION["manager_id"];
$agent_id= base64_decode($_GET['id']);
if(!isset($_SESSION["admin_id"])){
   header('location:http://www.btcover.appexperts.net');
}
date_default_timezone_set('Asia/Calcutta');
	$cdate  = date("Y-m-d");
?>
<!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">
</head>

<body>
   
    <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">Agent Policies Detail</h4>
                         <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="agent.php">View Agent</a></li>
									<li class="breadcrumb-item active" aria-current="page">Agent Policies</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" >
                                <div class="table-responsive" style="float:left; width:100%; overflow-Y: auto; height: 500px;">
                                    <table id="zero_config" class="table table-striped table-bordered" >
                                        <thead>
                                            <tr>
											  <th><b>#</b></th>
											  <th><b>Policy No</b></th>
											  <th><b>Policy Name</b></th>
											  <th><b>Vehicle Type</b></th>
											    <th><b>Agent Name</b></th>
											<th><b>Company Name</b></th>
											  <th><b>Premium Amt</b></th>
											<th><b>Policy Date</b></th>
											  <th><b>Renewal Date</b></th>
											 
											   <th><b>Action</b></th>
											   <th><b>Detail</b></th>
											   
											</tr>
                                        </thead>
                                        <tbody>
										<?php 
										$c=1;
										
											$selrenew3=mysqli_query($con,"SELECT tbl_policy_master.*,tbl_customer_premium.policy_no,tbl_customer_premium.agent_id,tbl_agent.agent_name FROM `tbl_customer_premium`,`tbl_policy_master`,`tbl_agent` where tbl_policy_master.policy_no = tbl_customer_premium.policy_no and tbl_customer_premium.agent_id='$agent_id' and tbl_customer_premium.agent_id=tbl_agent.agent_id and tbl_policy_master.admin_id='$ver' and tbl_policy_master.status in ('Active','Renewal Pending') ");
										
										if(mysqli_num_rows($selrenew3)>0)
										{
											while($recset=mysqli_fetch_array($selrenew3))
											{
															$query = mysqli_query($con,"SELECT * FROM tbl_insurance_company,tbl_policy_type,tbl_vehicle_master where tbl_insurance_company.company_id='".$recset['company_id']."' and tbl_policy_type.policy_id = '".$recset['policy_type']."' and tbl_vehicle_master.vehicle_id = '".$recset['vehicle_id']."'");
															$fetch_query=mysqli_fetch_assoc($query);
				
										?>
                                      <tr>
										  <td><?php echo $c++; ?></td>
										
										  <td><?php echo $recset['policy_no']; ?></td>
										  <td><?php echo $fetch_query['policy_name']; ?></td>
										  <td><?php echo $fetch_query['vehicle_type']; ?></td>
										  <td><?php echo $recset['customer_name']; ?></td>
										  <td><?php echo $recset['agent_name']; ?></td>
										  <td><?php echo $recset['premium_amt']; ?></td>
										  <td><?php echo date("d-m-Y", strtotime($recset['policy_date']) ); ?></td>
										  <td><?php echo date("d-m-Y", strtotime($recset['renewal_date']) ); ?></td>
											<td><?php echo $recset['cstatus']; ?></td>
										  <td width="15%">
												<a href="policy-detail.php?id=<?php echo base64_encode($recset['policy_no'])?>&id2=agent&id3=<?php echo base64_encode($recset['agent_id'])?>" style="font-size:12px;padding:1px 5px;"  class="btn btn-success">View Policy</a>
										  </td>
										 
										</tr>
										<?php }} else { ?>
										 <tr>
										  <td colspan='15'>No Data Available</td>
										</tr>
										<?php } ?>
                                        </tbody>
                                      </table>
                                </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>
          
        </div>
      
    </div>
  
    <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>