<?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($_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' where party_id='$cpid'";
			$qres=mysqli_query($GLOBALS['dbcon'], $psql);
			$canSql="update tbl_candidates set 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 INNER JOIN party_statusdate ON candidates_id=party_id WHERE 1 AND candidates_user!='h1admin' AND candidates_alloted='Yes' $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;">Allocated Candidates</h3>
        <?php if($srch==1){ ?>
        <small class="pull-right"><a href="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 col-md-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 Candidates to Shift</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)) {
	if($row['status']=='1'){
		$stats = "Fresh";
	}
	if($row['status']=='2'){
		$stats = "Follow Up";
	}
	if($row['status']=='3'){
		$stats = "Positive";
	}
	if($row['status']=='4'){
		$stats = "Selected";
	}
	if($row['status']=='5'){
		$stats = "Rejected";
	}
	if($row['status']=='6'){
		$stats = "Not Interested";
	}
	if($row['status']=='7'){
		$stats = "Block";
	}
?>
              <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><small class="pull-right text-warning"><strong>
                          <?=$stats?>
                          </strong></small></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> <!--<small class="pull-right text-success"><strong>User :
                          <?=$row['candidates_user']?>
                          </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='Yes' $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='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");?>