<?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' $con ORDER BY ps.next_date DESC LIMIT $start_from,$limit";  
$rs_result = mysqli_query($GLOBALS['dbcon'], $sql);  
?>
      <div class="col-sm-9" id="ctID">
        <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-today.php"><strong>View All</strong></a></small>
        <? } ?>
        <form name="search1" action="" method="POST" onsubmit="return searchValidate();">
          <div class="row" id="faq-result">
            <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-info">
                        <?=$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><small><strong>Next Date</strong></small></td>
                      <td><?php if($row['next_date']<$crDate){ ?>
                        <small class="redb"><strong><span class="glyphicon glyphicon-hand-right"></span>&nbsp;&nbsp;
                        <?=$row['next_date']?>
                        </strong></small>
                        <? }else{ ?>
                        <small>
                        <?=$row['next_date']?>
                        </small>
                        <? } ?></td>
                    </tr>
                    <?php if($row['candidates_extra_remark']!=""){ ?>
                     <tr>
                      <td><small><strong>Remark</strong></small></td>
                      <td><small>
                        <?=$row['candidates_extra_remark']?>
                        </small></td>
                    </tr>
                    <?}?>
                    
                    <tr>
                      <td colspan="2" class="mastfoot"><a href="javascript:void(0);" style="color:#0033CC" onclick="window.open('your-comments.php?cpid=<?php echo $row['candidates_id']; ?>&uname=<?php echo $_SESSION['admin_user_id']; ?>&status=<?php echo $row['status']; ?>','mcomments','toolbar=yes,location=yes,status=yes,scrollbars=yes,resizable=yes,width=650,height=600')"> <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.fresh_party_date <= '$crDate' AND ps.status='1' $con ORDER BY ps.next_date DESC";  
$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-today.php?page=".$i."'>".$i."</a></li>";  
};  
echo $pagLink . "</ul>";
}
?>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
<?php include("hr-footer.php");?>