<?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
if(isset($_POST['submit']))
{ 
	$execu_name=$_POST['veri_name'];
	$cid=$_POST['cid'];
	$company=count($_POST['cid']);
	if($company >0)
	{
		$companyid=implode(",",$_POST['cid']);
		foreach($cid as $cpid)
		{
			$psql="update party_statusdate set user_id='$execu_name', status='1',fresh_party_date=now() where party_id='$cpid'";
			$qres=mysqli_query($GLOBALS['dbcon'], $psql);
			$canSql="update tbl_candidates set candidates_alloted='Yes', candidates_user='$execu_name' where candidates_id='$cpid'";
			$qrecd=mysqli_query($GLOBALS['dbcon'], $canSql);
		}
	}
}
?>    
   <?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 (candidates_name LIKE '%$candidateinfo%' OR candidates_email='$candidateinfo' OR candidates_mobile LIKE '%$candidateinfo%')";
	$srch=1;
}
/************FOR SEARCH RESULT END*************/

$sql = "SELECT * FROM tbl_candidates WHERE 1 AND candidates_user='h1admin' AND candidates_alloted='No' $con ORDER BY candidates_id 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;">Non Allocated Candidates</h3> 
     <?php if($srch==1){ ?><small class="pull-right"><a href="non-allocated-candidates.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>
    <form class="form-inline" name="form" action="" method="post" enctype="multipart/form-data" onSubmit="return selectValidate()">
    <div class="row" style="margin-top:35px;">
    <div class="col-sm-12"> 
     <div class="form-group"><input name="check_all" type="checkbox" id="check_all" value="check_all" onclick="checkall(this.form)" />
              <select name="veri_name" class="form-control">
			  <option value="0">Select One</option>
                <?php
					$esql="SELECT * FROM tbl_admin WHERE 1 AND admin_status='Active' AND admin_userid!='h1admin' ORDER BY admin_userid ASC";
					$qq=mysqli_query($GLOBALS['dbcon'], $esql);
					while($res=mysqli_fetch_array($qq))
					{
					?>
                <option value="<?php echo $res['admin_userid'];?>"><?php echo $res['admin_userid']; ?></option>
                <?php
					}
					
					?>
              </select>
              <button type="submit" name="submit" class="btn btn-warning" onclick="return select_one()"><span class="glyphicon glyphicon-share"></span> Shift</button></div>
             
    </div>
    </div>
    <div class="row">
    
      <div class="col-sm-12 col-md-12" style="margin-top:15px;"> 
      <?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">
            <input type="checkbox" name="cid[]" id="cid[]" value="<?php echo $row['candidates_id']; ?>">
            <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>Specialization</strong></small></td>
            <td><small><?=$row['candidates_specialization']?></small></td>            
        </tr>
        <tr>
            <td colspan="2" class="mastfoot"><small><strong>Add Date : <?=$row['candidates_add_date']?></strong></small></td>
        </tr>
    </tbody>
</table>
</div>   
</div>
<? } ?>
      

    </div>
    </div>
    
    </form>
    <div class="row">
      <div class="col-sm-12 col-md-12"> 
      
<?php  
$sqlPage = "SELECT * FROM tbl_candidates WHERE 1 AND candidates_user='h1admin' AND candidates_alloted='No' $con ORDER BY candidates_id 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='non-allocated-candidates.php?page=".$i."'>".$i."</a></li>";  
};  
echo $pagLink . "</ul>";
}
?>

 </div>
    </div>
    
    </div>
    
    </div>
    </div>
    </div>
    <script language="javascript" src="select_all_checkbox_code.js" type="text/javascript"></script>
    <script type="text/javascript">
	function selectValidate(){
if(document.form.veri_name.selectedIndex=='0'){
		alert('Select Name To Shift Candidates !');
		document.form.veri_name.focus();
		return false;
	}
return true;
 }
 function select_one()
{
var chks = document.getElementsByName('cid[]');
var hasChecked = false;
for (var i = 0; i < chks.length; i++)
{
if (chks[i].checked)
{
hasChecked = true;
break;
}else{
hasChecked = false;
}
}
if (hasChecked == false)
{
alert("Please select at least one !");
return false;
}else{
return true;
}
}
 </script>
    <?php include("hr-footer.php");?>