<?php
session_start();
require_once("includes/dbsmain.inc.php");	
$per_page = 50;
$page = $_REQUEST['page'];
$start = ($page-1)*50;
if($_SESSION['admin_user_id']!='h1admin'){
	$hcon = " and candidates_user='$_SESSION[admin_user_id]'";
}else{
	$hcon = "";
}
if(!empty($_REQUEST['usrnam'])){
$unam=trim($_REQUEST['usrnam']);
$sql = "select * from tbl_candidates where 1 $hcon and (candidates_name like '%$unam%' or candidates_email='$unam' or candidates_mobile like '%$unam%' or candidates_user='$unam') ";
$srch=1;
}else{
$sql = "select * from tbl_candidates where 1 $hcon order by candidates_id DESC limit $start,50";
}
$rsd = mysqli_query($GLOBALS['dbcon'], $sql);
?>
<form name="ufrm" action="" method="post">
  <div class="table-responsive">
    <table class="table table-bordered table-striped">
      <thead>
        <tr class="text-info">
          <th>Name</th>
          <th>Mobile</th>
          <th>Specialized in</th>
          <th>Current Employment Status</th>
          <?php /*if($_SESSION['admin_user_id']=='h1admin'){ ?>
          <th>User</th>
          <? } */?>
          <th class="text-center">Action</th>
        </tr>
      </thead>
      <tbody>
        <?php
while ($rows = mysqli_fetch_array($rsd))
{?>
        <tr>
          <td><?=$rows['candidates_name']?></td>
          <td><?=$rows['candidates_mobile']?></td>
          <td><?=$rows['candidates_specialization']?></td>
          <td><?=$rows['candidates_current_emp_status']?></td>
          <?php /*if($_SESSION['admin_user_id']=='h1admin'){ ?>
          <td><?=$rows['candidates_user']?></td>
          <? } */?>
          <td class="text-center"><a href="add-candidate.php?candidateID=<?=$rows['candidates_id']?>"><span class="glyphicon glyphicon-edit text-info" title="View/Edit Candidate Information"></span></a> <a href="manage-candidate.php?action=delete&delID=<?=$rows['candidates_id']?>" onClick="javascript:return confirm('Do you really want to delete this record?');"><span class="glyphicon glyphicon-trash text-danger" style="margin-left:7px;" title="Delete Candidate"></span></a>
            <?php if($rows['candidates_resume_name']!=''){ ?>
            <a href="download.php?f=<?=$rows['candidates_resume_name']?>"><span class="glyphicon glyphicon-download-alt text-success" style="margin-left:7px;" title="Download Resume"></span></a>
            <? } ?></td>
        </tr>
        <? } ?>
      </tbody>
    </table>
  </div>
</form>
<script type="text/javascript">
$(document).ready(function(){
	
	var Timer  = '';
	var selecter = 0;

	var Main =0;
	
	bring(selecter);
	
});

function bring ( selecter )
{	
	$('div.shopp:eq(' + selecter + ')').stop().animate({
		opacity  : '1.0',
		height: '60px'
		
	},300,function(){
		
		if(selecter < 6)
		{
			clearTimeout(Timer); 
		}
	});
	
	selecter++;
	var Func = function(){ bring(selecter); };
	Timer = setTimeout(Func, 20);
}

</script>