<?php include("hr-header.php");?>
    <div class="container-fluid" style="margin-top:30px;">
    <div class="row">
     <div class="col-sm-12">
    <div class="col-sm-3" style="padding-left:0;">
     <?php include("hr-left-menu.php");?>
    </div>
   <?php  
$limit = 10;  
if (isset($_GET['page'])) { $page  = $_GET['page']; } else { $page=1; }
$start_from = ($page-1) * $limit;  

/************FOR SEARCH RESULT START*************/
if(isset($_POST['search'])){
	$candidateinfo=trim($_POST['candidate']);
$con = " AND (tc.candidates_name LIKE '%$candidateinfo%' OR tc.candidates_email='$candidateinfo' OR tc.candidates_mobile LIKE '%$candidateinfo%')";
	$srch=1;
}
/************FOR SEARCH RESULT END*************/

$sql = "SELECT * FROM tbl_candidates as tc INNER JOIN party_statusdate as ps ON tc.candidates_id=ps.party_id WHERE 1 AND ps.user_id='$_SESSION[admin_user_id]' AND ps.next_date <='$crDate' AND ps.status='1' AND ps.follow_party_date='0000-00-00' $con ORDER BY ps.next_date ASC LIMIT $start_from,$limit";  
$rs_result = mysqli_query($GLOBALS['dbcon'], $sql);  
?> 
    <div class="col-sm-9">
    <h3 class="page-header text-primary" style="margin-top:0;">Fresh Candidates (Today)</h3> 
     <?php if($srch==1){ ?><small class="pull-right"><a href="fresh-candidates.php"><strong>View All</strong></a></small><? } ?>
    
    <form name="search1" action="" method="POST" onsubmit="return searchValidate();">
    <div class="row">
        <div class="col-xs-12 col-sm-8 col-sm-offset-2">
            <div class="input-group">
                <input type="text" value="<?php print $_POST['candidate']?>"  name="candidate" class="form-control">
                <div class="input-group-btn">
                    <button type="submit" name="search" class="btn btn-default"><span class="glyphicon glyphicon-search"></span> Search</button>
                </div>                
            </div>
        </div>
    </div>
</form>
    
    
    <div class="row" style="margin-top:35px;">
      <div class="col-sm-12 col-md-12"> 
      <?php  
while ($row = mysqli_fetch_assoc($rs_result)) {  
?> 
      <div class="col-sm-12 col-md-6 col-xs-12"> 
           <div class="table-responsive">
        <table class="table table-bordered">
   
    <tbody>
        <tr>
            <td colspan="2" class="masthead"><strong class="text-danger"><?=$row['candidates_name']?></strong></td>
         </tr>
        <tr>
            <td width="21%"><small><strong>Mobile</strong></small></td>
            <td width="79%"><small><?=$row['candidates_mobile']?></small></td>            
        </tr>
        <tr>
            <td><small><strong>Email</strong></small></td>
            <td><small><?=$row['candidates_email']?></small></td>            
        </tr>
        <tr>
            <td><small><strong>Emp Status</strong></small></td>
            <td><small><?=$row['candidates_current_emp_status']?></small></td>            
        </tr>
        <tr>
            <td colspan="2" class="mastfoot"><a href=""><small class="text-info"><strong>Add/View Comment</strong></small></a></td>
        </tr>
    </tbody>
</table>
</div>   
</div>
<? } ?>
      

    </div>
    </div>
    
    
    <div class="row">
      <div class="col-sm-12 col-md-12"> 
      
<?php  
$sqlPage = "SELECT * FROM tbl_candidates as tc INNER JOIN party_statusdate as ps ON tc.candidates_id=ps.party_id WHERE 1 AND ps.user_id='$_SESSION[admin_user_id]' AND ps.next_date <='$crDate' AND ps.status='1' AND ps.follow_party_date='0000-00-00' $con ORDER BY ps.next_date ASC";  
$page_result = mysqli_query($GLOBALS['dbcon'], $sqlPage); 
$total_records = mysqli_num_rows($page_result);  
$total_pages = ceil($total_records / $limit); 
if($total_pages>1){ 
$pagLink = "<ul class='pagination'>";  
for ($i=1; $i<=$total_pages; $i++) {  
if($_REQUEST['page']==$i){
	$class = 'active';
}else{
	$class = '';
}
             $pagLink .= "<li class='$class'><a href='fresh-candidates.php?page=".$i."'>".$i."</a></li>";  
};  
echo $pagLink . "</ul>";
}
?>

 </div>
    </div>
    
    </div>
    
    </div>
    </div>
    </div>
    <?php include("hr-footer.php");?>