<?php 
$resultset  = $this->resultset;
$others     = $this->others;
?>
<!--Page main section start-->

<section id="min-wrapper" class="active">
<div id="main-content">
<div class="container-fluid">
<div class="row">
    <div class="col-md-12">
        <!--Top header start-->
        <h3 class="ls-top-header">Activities</h3>
        <!--Top header end -->

        <!--Top breadcrumb start -->
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-home"></i></a></li>
            <li class="active">Insurance Policies</li>
            <li class="active">Manage Insurance Policies</li>
        </ol>
        <!--Top breadcrumb start -->
    </div>
</div>
<!-- Main Content Element  Start-->
<div class="row">


<div class="col-md-12">
                            <div class="panel panel-primary">
                                <div class="panel-heading">
                                    <h3 class="panel-title"><i class="fa fa-filter"></i> Filter By</h3>
                                    <ul class="panel-control">
                                        <li><a class="minus active" href="javascript:void(0)"><i class="fa fa-angle-down large"></i></a></li>
                                    </ul>
                                </div>
                                <div class="panel-body" style="display:none;">
                                    <form class="ls_form" role="form">
                                    
                                    <div class="col-md-4">
                                      <div class="form-group">
                                        <label>Insurance Company</label>
                                            <input type="text" class="form-control whbg">                                      
                                          
                                        </div>
                                        </div>
                                        
                                    	<div class="col-md-4">
                                        <div class="form-group">
                                            <label>Policy No.</label>
                                              <input type="text" class="form-control whbg">                                      
                                          
                                        </div>
                                        </div>
                                        
                                        <div class="col-md-4">
                                        <div class="form-group">
                                            <label>Issued</label>
                                              <input type="text" class="form-control whbg">                                      
                                          
                                        </div>
                                        </div>
                                        
                                        
                                        
                                        <div class="col-md-3">
                                        <div class="form-group form-group1">
                                            <button class="btn btn-info"><i class="fa fa-search"></i> Filter</button>
                                        </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>



<div class="col-md-12" align="right">
    <div class="form-group form-group1">
        <a class="btn btn-success btn-group-xs" href="/insurance-policies/add"><i class="fa fa-fw fa-arrows"></i> Add Insurance Policy</a>
    </div>
</div>
                    
                    
    
<div class="col-md-12">
    <?php if (count($this->messages)) { ?>
     <div class="alert alert-success" >
         <button data-dismiss="alert" class="close" type="button">x</button>
         <?php foreach ($this->messages as $message) {  ?>
         <?php echo $this->escape($message); ?>
         <?php } ?>
     </div>
    <?php } ?>
</div>    
    
                    
	<div class="col-md-12">
    	<div class="leadeBorder">
        	<div class="panel-body">
                
                
                
                
                
                
                
                <div class="table-responsive ls-table">
        <table class="table table-bordered small" >
      <thead>
            <tr class="alert alert-info">

              <th style="font-size:12px; vertical-align:top;"><strong>Insurance Company</strong></th>
              <th style="font-size:12px; vertical-align:top;"><strong>Policy No.</strong></th>
                <th style="font-size:12px; vertical-align:top;"><strong>Total Child Policies</strong></th>
                <th style="font-size:12px; vertical-align:top;"><strong>Issued</strong></th>
              <th style="font-size:12px; vertical-align:top;"><strong>Balance</strong></th>
              <th style="font-size:12px; vertical-align:top;"><strong>Start Date</strong></th>
              <th style="font-size:12px; vertical-align:top;"><strong>Expiry</strong></th>
                <th style="font-size:12px; vertical-align:top;"><strong>GTX Commission</strong></th>                                                
              <th style="font-size:12px; vertical-align:top;"><strong>Status</strong></th>
              <th style="font-size:12px; vertical-align:top;"><strong>Action</strong></th>
          </tr>
        </thead>
                                        
        <tbody>


        <?php
        $obj    = new Travel_Model_TblInsurance();
        $table  = "TB_Insurance_Policy_Childs";
        $colsArr= array("count(*) as TotalRows");
        
        if(!empty($this->paginator) ) {
        foreach($this->paginator as $num => $v){
        ?>
        <tr>
            <td><?php echo $v['CompanyName']?></td>
            <td><?php echo $v['PolicyId']?></td>
            <td><?php echo $v['TotalChildPolicy']?></td>
            <td><?php $res = $obj->getTotalRecords($table, $colsArr, array("IsIssued" => 1, "MasterPolicyRef" => $v['MasterPolicySysId']) );
            echo $res['TotalRows']; ?></td>
            <td><?php $res = $obj->getTotalRecords($table, $colsArr, array("IsIssued" => 0, "MasterPolicyRef" => $v['MasterPolicySysId']) );
            echo $res['TotalRows']; ?></td>
            <td><?php echo $v['LaunchDate']->format("d/m/Y")?></td>
            <td><?php echo $v['ExpiryDate']->format("d/m/Y")?></td>
            <td><?php echo $v['GTXCommision']?> %</td>
            <td><?php echo $status = ($v['IsActive']==1) ? 'Active' : 'Deactive';?></td>
            <td class="text-center">
                <a href="<?php echo $this->baseUrl('insurance-policies/edit/sid/'. base64_encode($v['MasterPolicySysId']) );?>" class="btn btn-xs btn-warning tooltipLink" data-toggle="tooltip" data-placement="top" title="Edit"><i class="fa fa-pencil-square-o"></i></a>
                <a onclick="return confirm('Are you sure you want to delete the selected record?');" href="<?php echo $this->baseUrl('insurance-policies/delete/sid/'. base64_encode($v['MasterPolicySysId'])); ?>" class="btn btn-xs btn-danger tooltipLink" data-toggle="tooltip" data-placement="top" title="Delete">
                    <i class="fa fa-stop"></i>
                </a>
                <a title="" class="btn btn-xs btn-success tooltipLink" href="<?php echo $this->baseUrl('insurance-policies/export/sid/'. base64_encode($v['MasterPolicySysId']) );?>" data-original-title="Export Child Policies"><i class="fa fa-file-excel-o"></i></a>
            </td>
        </tr>
        <?php }
        }
        else {
        ?>	
            <td colspan="6"><b>No Record Found.</b></td>
        <?php
        }?>	
            
        </tbody>
                                  
        </table>

</div>               
                                    <!--Table Wrapper Finish-->
                                    
<!--Pagingnation Start-->
    <?php if (!empty($this->paginator) ) { ?>
        <?php echo $this->paginationControl($this->paginator, 'Sliding', 'pagination.phtml'); ?>
    <?php } ?> 
<!--Pagingnation End-->

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

<!-- Main Content Element  End-->
</div>
</div>

<?php echo $this->render('copyrightfooter.phtml'); ?>
</section>


<?php
include_once 'application/views/scripts/newfooter.phtml';?>

<!--Page main section end -->