芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/employee.php

<?php include("includes/head.php"); ?>

<?php include("includes/header.php"); ?>

<?php include ("includes/libmail.php"); ?>

<?php include("includes/fancybox.php"); ?>

<?php

//echo $currentFile = $_SERVER["PHP_SELF"]."<br>";

//echo $parts = Explode('/', $currentFile)."<br>";

//echo $pageName = $parts[count($parts) - 1]."<br>";

$(document).ready(function(){

jQuery(".check_box").click(function(){

var all_checked = false;

jQuery(".check_box").each(function(){

if(jQuery(this).is(':checked')){

all_checked = true;

}else{

all_checked = false;

return all_checked;

}

});

jQuery("#chkAllFiles").attr('checked', all_checked);

});

jQuery('#chkAllFiles').click(function(){

//alert(1111);

//jQuery(".check_box").attr('checked', jQuery('#chkAllFiles').is(':checked'));

if(this.checked==true){

$(".check_box").each(function() {

//alert(this.checked);

this.checked=true;

});

}else{

$(".check_box").each(function() {

//alert(this.checked);

this.checked=false;

});

}

});

//submit the form//

//document.getElementById("mSend").onclick = function() {

/*	function submit() {

var val ='';

$(".check_box").each(function() {

//alert(this.checked);

if(this.checked==true){

val = 'yes';

}

});

if(val==''){

alert("Please select atleast one staff!");

return false;

}

else{

document.getElementById("send_mail").submit();

}

$(document).ready(function(){

$(".tmsend").click(function(){

//$("#mSend").removeClass("tmsend");

var val ='';

$(".check_box").each(function() {

//alert(this.checked);

if(this.checked==true){

val = 'yes';

}

});

if(val==''){

alert("Please select atleast one staff!");

return false;

}

else{

$("#mSend").removeClass("tmsend");

document.getElementById("send_mail").submit();

}

});

$(document).ready(function(){

$(".tmsend1").click(function(){

//$("#mSend").removeClass("tmsend");

var val ='';

$(".check_box").each(function() {

//alert(this.checked);

if(this.checked==true){

val = 'yes';

}

});

if(val==''){

alert("Please select atleast one staff!");
			$('#re_ini').val('');
			return false;

}

else{

$("#mSend1").removeClass("tmsend");
			$('#re_ini').val(1);

document.getElementById("send_mail").submit();

}

});

function update_hours_manual(id){
	
	$('#vacation_'+id).hide();
	$('#vacation_text_'+id).show();
	$('#holiday_'+id).hide();
	$('#holiday_text_'+id).show();
	$('#sick_'+id).hide();
	$('#sick_text_'+id).show();
	$('#personal_'+id).hide();
	$('#personal_text_'+id).show();
	$('#submit_'+id).show();
	
}

</script>

<?php

$last_friDay = date("m-d-Y", strtotime('-1 week  Friday')) ;

if($_REQUEST['employee']!=''){

if($_REQUEST['re_ini'] == 1){
	$sql_hours = mysql_fetch_array(mysql_query("SELECT * FROM hour_master WHERE id = 1"));
	foreach($_REQUEST['employee'] as $reciver){
		
	$sql_update_hours = mysql_query("UPDATE  staff_personal SET sick = '".$sql_hours['sick']."', holiday = '".$sql_hours['holiday']."' , personal = '".$sql_hours['personal']."' WHERE staff_id = '".$reciver."' ");
	
	header("location:employee.php?success=6");
		
	}
}else{
	foreach($_REQUEST['employee'] as $reciver){
		
			
	
		
	
		$receiver1 = mysql_fetch_array(mysql_query("SELECT `pemail`,`firstname` FROM `sat_staff` WHERE `staff_id` = '".$reciver."'"));
	
		$to = $receiver1['pemail'];
	
		
	
		$body = "<p>".$receiver1['firstname'].",</p>
	
	
	
	<p>We have not received your client approved timesheets for the week ending ".$last_friDay." .</p>
	
	<br>
	
	<p>Please send us email or fax at your earliest to avoid any delay in the billing and payroll processing.</p>
	
	
	
	<br>
	
	<p>Thanks for your co-operation and understanding.<p>
	
	<br>
	
	Thanks,<br>
	
	Accounting Team<br>
	
	American Business Solutions Inc.<br>
	
	8850 Whitney Drive / Lewis Center, OH 43035<br>
	
	Direct: 614-887-8819 , 1-614-754-4852<br>
	
	Work: 614-888-2227<br>
	
	614-917-2277 (Fax)<br>
	
	Email: timesheet@absi-usa.com<br>
	
	(www.absi-usa.com)<br>";
	
	$subject='ABSI Time Reporting';
	
	
	
	$body1 = emailTempalte($subject , $body);
	
	
	
	$form = "SAT@ABSI <itteam@absi-usa.com>";
	
		
	
		
	
		$ccEmail = 'info@absi-usa.com';
	
		$m = new Mail();
	
		$m->From ($form);
	
			$m->Subject ($subject);
	
			$m->Body ($body1);
	
			$m->to ($to);
	
			$m->cc($ccEmail);
	
		   $m->Send();
	
		   header("location:employee.php?success=5");
	
		
	}
}

}

if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')

{

mysql_query("delete from sat_staff where staff_id='".$_REQUEST['delete_id']."'");

mysql_query("delete from `sat_staff_activity` where staff_id='".$_REQUEST['delete_id']."'");

//mysql_query("delete from  sat_staff_history where candidate_id='".$_REQUEST['delete_id']."'");

$delmsg="Staff details deleted successfully";

/*if($_REQUEST['page']!="")

{

header("location:manage_directory_domestic_product.php?msg=$msg&page=".$_REQUEST['page']."&ch_location=".$_REQUEST['ch_location']."&company_type=".$_REQUEST['company_type']."&comp_name=".$_REQUEST['comp_name']."&search_productID=".$_REQUEST['search_productID']."");

}

else

{

header("location:manage_directory_domestic_product.php?msg=$msg&ch_location=".$_REQUEST['ch_location']."&company_type=".$_REQUEST['company_type']."&comp_name=".$_REQUEST['comp_name']."&search_productID=".$_REQUEST['search_productID']."");

}*/

}

function view(userid)

{

window.open('view_employee.php?userid='+userid,'news view','height=600, width=1000, resizable=yes, scrollbars=yes');

}

function open_src(val){

if(val==''){

$('#div_src').toggle("slow");

}

else{

$('#div_src_req').toggle("slow");

}

$(document).ready(function(){

setTimeout(function(){

$(".mydiv").fadeOut("slow", function () {

$(".mydiv").remove("slow");

});

}, 4000);

});

function open_personal_div(id)
{
	$("#personal_div"+id).show();
	$("#fade1").show();
}

function close_personal_div(id)
{
	$("#personal_div"+id).hide();
	$("#fade1").hide();
}

</script>

<?php if($delmsg!=''){ ?>

<?php } ?>

<?php if($_REQUEST['success']=='1'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Staff Added Successfully</p>

<?php } ?>

<?php if($_REQUEST['success']=='2'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Details Updated Successfully</p>

<?php } ?>

<?php if($_REQUEST['success']=='4'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">A/C Manager Transfered Successfully</p>

<?php } ?>

<?php if($_REQUEST['success']=='5'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Email send successfully</p>

<?php } ?>

<?php if($_REQUEST['success']=='6'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Hours Reinitialized successfully</p>

<?php } ?>

<?php /*?><a href="javascript:open_src('req');" class="require" style="margin-right:5px; margin-bottom:5px;">Show Requirement</a><?php */?>

<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;"><i class="fa fa-search"></i> Search</a>

<?php /*?><a href="hotlist.php" class="require" style="margin-right:5px; margin-bottom:5px;" target="_blank">Generate Hotlist</a>

<?php

if($_SESSION['sat_login_id']==1){ ?>

<a href="candidate_export_xls.php" class="require" style="margin-right:5px; margin-bottom:5px;">Export</a>

<a href="candidate_report.php" class="require" style="margin-right:5px; margin-bottom:5px;" target="_blank">Generate Report</a>

<?php } ?><?php */?>

<?php if($level!=3){ ?>

<a href="employeeform.php" class="require org" style="margin-right:5px; margin-bottom:5px;"><i class="fa fa-plus"></i> Add Staff</a>

<?php } ?>

<a href="javascript:void(0);" class="require sky-blue tmsend" style="margin-right:5px; margin-bottom:5px;" id="mSend" <?php /*?>onclick="return submit();"<?php */?>><i class="fa fa-reply"></i> Send timesheet mail for selected staff</a>

<a href="javascript:void(0);" class="require gray tmsend1" style="margin-right:5px; margin-bottom:5px;" id="mSend1" <?php /*?>onclick="return submit();"<?php */?>><i class="fa fa-undo"></i> Reinitialize Hours</a>

<style>

#div_src_req{display:none;}

#div_src{display:none;}

</style>

<div class="search-box" style="padding:5px; <?php if($_REQUEST['submit2']=='GO') { ?>display:block;<?php } ?> border:1px solid #C4C4C4; margin-bottom:10px;" id="div_src_req">

<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;">Search By Requirement</h3>

</div>

<tr>

</tr>

<tr>

<td width="137" height="25" valign="top" class="require_table_search">Requirement:</td>

<option value="">-- Select --</option>

<?php

$sql_title = "select * from abs_requirement where 1 and status='Open' order by last_edit_time desc, req_id desc";

$qry_title = mysql_query($sql_title);

while($arr_title = mysql_fetch_array($qry_title)){

<option value="<?php echo $arr_title['req_id']; ?>"

<?php if($_REQUEST['req_id']!=''){ if($arr_title['req_id']==$_REQUEST['req_id']) { ?>selected="selected"<?php } } else{ if($arr_title['req_id']==$_POST['req_id']) { ?>selected="selected"<?php } } ?>><?php echo $arr_title['name']." - [".$arr_title['req_id']."]"; ?>

</option>

<?php

}

</select>

</td>

<td width="135" valign="top" class="require_table_search"><?php if($_REQUEST['req_id']!=''){ ?>Primary Skill:<?php } ?></td>

<?php

if($_REQUEST['req_id']!=''){

$reqqry = mysql_query("select * from abs_requirement where req_id='".$_REQUEST['req_id']."'");

$arrReq = mysql_fetch_assoc($reqqry);

echo $prySkill = check_null_value('exhibit','abs_exhibit','id',$arrReq['main_skill']);

$_REQUEST['primary_skills_req'] = $arrReq['main_skill'];

}

</td>

</tr>

<tr>

</tr>

<tr>

</span></td>

</tr>

</table>

</form>

</div>

<div class="search-box" style="padding:5px; <?php if($_REQUEST['submit2']=='Search' || $level == 3) { ?>display:block;<?php } ?> border:1px solid #C4C4C4; margin-bottom:10px;" id="div_src">

<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;"> <i class="fa fa-search"></i>   Search By</h3>

</div>

<tr>

</tr>

<tr>

</td>

<td width="135" valign="top" class="require_table_search">Primary Email:</td>

<td width="134" valign="top" class="require_table_search">Associate Type:</td>

<td width="199" colspan="4" align="left" valign="top"><select name="associate_type" class="validate[required] selectfield require_select" id="associate_type" <?php /*?>onchange="candidatetypeother(this.value);"<?php */?>>

<option value="">-- Select --</option>

<option value="W2" <?php if($_REQUEST['associate_type']=="W2"){?> selected="selected"<?php }?>>W2</option>

<option value="1099" <?php if($_REQUEST['associate_type']=="1099"){?> selected="selected" <?php }?>>1099</option>

<option value="C2C" <?php if($_REQUEST['associate_type']=="C2C"){?> selected="selected" <?php } ?>>C2C</option>

<option value="Future H1B" <?php if($_REQUEST['associate_type']=="Future H1B"){?> selected="selected" <?php } ?>>Future H1B</option>

<option value="Prospect" <?php if($_REQUEST['associate_type']=="Prospect"){?> selected="selected" <?php } ?>>Prospect</option>

<option value="EX" <?php if($_REQUEST['associate_type']=="EX"){?> selected="selected" <?php } ?>>EX</option>

</select></td>

</tr>

<tr>

<td height="25" valign="top" class="require_table_search">Visa Status:</td>

<option value="">Select</option>

<option value="H1B" <?php if($_REQUEST['visa_status']=="H1B"){?> selected="selected"<?php }?>>H1B</option>

<option value="US Citizen" <?php if($_REQUEST['visa_status']=="US Citizen"){?> selected="selected"<?php }?>>US Citizen</option>

<option value="GC" <?php if($_REQUEST['visa_status']=="GC"){?> selected="selected"<?php }?>>GC</option>

<option value="EAD" <?php if($_REQUEST['visa_status']=="EAD"){?> selected="selected"<?php }?>>EAD</option>

<option value="OPT" <?php if($_REQUEST['visa_status']=="OPT"){?> selected="selected"<?php }?>>OPT</option>

<option value="TN" <?php if($_REQUEST['visa_status']=="TN"){?> selected="selected"<?php }?>>TN</option>

</select></td>

<td valign="top" class="require_table_search">Account Manager</td>

<option value="">-- Select --</option>

<?php

$sql_product=sprintf("select user_id,firstname from sat_users where status='Active' order by firstname");

$query_product=mysql_query($sql_product);

while($array_product=mysql_fetch_array($query_product)){

<?php

}

</select></td>

<td valign="top" class="require_table_search">HR Manager:</td>

<option value="">-- Select --</option>

<?php

$sql_product=sprintf("select user_id,firstname from sat_users where status='Active' order by firstname");

$query_product=mysql_query($sql_product);

while($array_product=mysql_fetch_array($query_product)){

<?php

}

</select></td>

</tr>

<tr>

<td height="25" valign="top" class="require_table_search">Sales Manager</td>

<option value="">-- Select --</option>

<?php

$sql_product=sprintf("select user_id,firstname from sat_users where status='Active' order by firstname");

$query_product=mysql_query($sql_product);

while($array_product=mysql_fetch_array($query_product)){

<?php

}

</select></td>

<td valign="top" class="require_table_search">Status:</td>

<option value="">-- Select --</option>

<option value="Active" <?php if($_REQUEST['record_status']=='Active') { ?>selected="selected"<?php } ?>>Active</option>

<option value="Inactive" <?php if($_REQUEST['record_status']=='Inactive') { ?>selected="selected"<?php } ?>>Inactive</option>

</select></td>

<td valign="top" class="require_table_search">Sort Order:</td>

<option value="">-- Select --</option>

<option value="asc" <?php if($_REQUEST['order']=="asc"){?> selected="selected" <?php }?>>Ascending</option>

<option value="desc" <?php if($_REQUEST['order']=="desc"){?> selected="selected" <?php }?>>Descending</option>

</select>

</td>

</tr>

<tr>

</tr>

</table>

</form>

</div>

<tr>

<td width="116" class="head_text">First Name</td>

<td width="94" class="head_text">Username</td>

<td width="85" class="head_text">Email</td>

<td width="97" class="head_text">Phone</td>

<td width="110" class="head_text">Status </td>

<td width="110" class="head_text">Action </td>

</tr>

<!--<tr>

<td class="head_text2">Lorem Ipsum</td>

<td class="head_text2">System Created</td>

<td class="head_text2">Dolor Sit Amet</td>

<td class="head_text2">Exhibit 3</td>

<td class="head_text2">Typesetting Industry</td>

<td class="head_text2">Valid User 1,2,3</td>

</td>

</tr>-->

<?php

//print_r($_REQUEST['primary_skills']);

$oredr = '';

$qry_contact = "select * from  sat_staff where 1";

if($level == 2){
		$qry_contact.= " AND hr_manager = '".$_SESSION['sat_login_id']."'"; 
	}

if($_REQUEST['todate']!=''){

$qry_contact .= " and `effective_date` = '".$_REQUEST['todate']."'";

}

if($_REQUEST['first']!='' && $_REQUEST['last']!=''){

$qry_contact .= " and `add_date` >= '".$_REQUEST['first']."' AND `add_date` <= '".$_REQUEST['last']."'";

}

if($_REQUEST['name']!=''){

$qry_contact .= " and CONCAT(firstname, ' ',lastname) like '%".$_REQUEST['name']."%'";

}

if($_REQUEST['associate_type']!=''){

$qry_contact .= " and associate_type='".$_REQUEST['associate_type']."'";

}

if($_REQUEST['email']!=''){

$qry_contact .= " and pemail like '%".$_REQUEST['email']."%'";

}

if($_REQUEST['visa_status']!=''){

$qry_contact .= " and visa_status='".$_REQUEST['visa_status']."'";

}

if($_REQUEST['account_manager']!=''){

$qry_contact .= " and account_manager='".$_REQUEST['account_manager']."'";

}

if($_REQUEST['hr_manager']!=''){

$qry_contact .= " and hr_manager='".$_REQUEST['hr_manager']."'";

}

if($_REQUEST['sales_manager']!=''){

$qry_contact .= " and sales_manager='".$_REQUEST['sales_manager']."'";

}

if($_REQUEST['visa_type']!=''){

$qry_contact .= " and visa_type='".$_REQUEST['visa_type']."'";

}

if($_REQUEST['hotlist']!=''){

$qry_contact .= " and hotlist='".$_REQUEST['hotlist']."'";

}

if($_REQUEST['blacklisted']!=''){

$qry_contact .= " and blacklisted='".$_REQUEST['blacklisted']."'";

}

/*if($_REQUEST['blacklisted']==''){

$qry_contact .= " and blacklisted='N'";

}*/

if($_REQUEST['send_emails']!=''){

$qry_contact .= " and send_emails='".$_REQUEST['send_emails']."'";

}

if($_REQUEST['relocation']!=''){

$qry_contact .= " and relocation='".$_REQUEST['relocation']."'";

}

if($_REQUEST['vendor_name']!=''){

$qry_contact .= " and vendor_name='".$_REQUEST['vendor_name']."'";

}

if($_REQUEST['record_status']!=''){

$qry_contact .= " and current_associate_status='".$_REQUEST['record_status']."'";

}

/*if($_REQUEST['record_status']=='' && $_REQUEST['blacklisted']=='' && $_REQUEST['vendor_name']==''){

$qry_contact .= " and record_status='Active' and blacklisted='N'";

}*/

if($_REQUEST['state']!=''){

$qry_contact .= " and state='".$_REQUEST['state']."'";

}

if($_REQUEST['city']!=''){

$qry_contact .= " and city like '%".$_REQUEST['city']."%'";

}

if($_REQUEST['order']=="asc"){

$oredr = $_REQUEST['order'];

}

if($_REQUEST['order']=="desc"){

$oredr = $_REQUEST['order'];

}

if($_REQUEST['order']==""){

$oredr = 'desc';

}

$qry_contact .= " order by current_associate_status, staff_id ".$oredr;

//echo $qry_contact;

$_SESSION['sqlCandidate']='';

//$_SESSION['sqlCandidate'] = $qry_contact;

$sel_events=mysql_query($qry_contact);

////////////////////////////////Start pagination////////////////////////////////////

/*if(empty($_REQUEST['page'])) { $_REQUEST['page']=''; }

$page=$_REQUEST['page'];

if($page==""){

$page = 1;

}

if($_POST['submit2']!='' && $page!=1){

$page = 1;

}

$max_results = 10;

$prev = ($page - 1);

$next = ($page + 1);

$from = (($page * $max_results) - $max_results);

$total_results = mysql_num_rows($sel_events);

echo $total_pages = ceil($total_results / $max_results);

$pagination = '';

if($page > 1)

{

$pagination .= "<a href=\"employee.php?page=$prev&name=".$_REQUEST['name']."&email=".$_REQUEST['email']."&main_skills=".$_REQUEST['main_skills']."&candidate_type=".$_REQUEST['candidate_type']."&owner=".$_REQUEST['owner']."&visa_type=".$_REQUEST['visa_type']."&hotlist=".$_REQUEST['hotlist']."&blacklisted=".$_REQUEST['blacklisted']."&send_emails=".$_REQUEST['send_emails']."&relocation=".$_REQUEST['relocation']."&record_status=".$_REQUEST['record_status']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."&city=".$_REQUEST['city']."&state=".$_REQUEST['state']."&primary_skills_src=".$primary_skills."&secondary_skills_src=".$secondary_skills."&first=".$_REQUEST['first']."&last=".$_REQUEST['last']."\" class=\"more_link_pagination_prev\">Previous</a>";

$pagination.="   ";

}

for($i = 1; $i <=$total_pages; $i++)

{

if(($page) == $i)

{

$pagination .= $i;

$pagination.='   ';

}

else

{

$pagination .= "<a href=\"employee.php?page=$i&name=".$_REQUEST['name']."&email=".$_REQUEST['email']."&main_skills=".$_REQUEST['main_skills']."&candidate_type=".$_REQUEST['candidate_type']."&owner=".$_REQUEST['owner']."&visa_type=".$_REQUEST['visa_type']."&hotlist=".$_REQUEST['hotlist']."&blacklisted=".$_REQUEST['blacklisted']."&send_emails=".$_REQUEST['send_emails']."&relocation=".$_REQUEST['relocation']."&record_status=".$_REQUEST['record_status']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."&city=".$_REQUEST['city']."&state=".$_REQUEST['state']."&primary_skills_src=".$primary_skills."&secondary_skills_src=".$secondary_skills."&first=".$_REQUEST['first']."&last=".$_REQUEST['last']."\" class=\"more_link_pagination\">$i</a>";

$pagination.='   ';

}

if($page < $total_pages)

{

$pagination .= "<a href=\"employee.php?page=$next&name=".$_REQUEST['name']."&email=".$_REQUEST['email']."&main_skills=".$_REQUEST['main_skills']."&candidate_type=".$_REQUEST['candidate_type']."&owner=".$_REQUEST['owner']."&visa_type=".$_REQUEST['visa_type']."&hotlist=".$_REQUEST['hotlist']."&blacklisted=".$_REQUEST['blacklisted']."&send_emails=".$_REQUEST['send_emails']."&relocation=".$_REQUEST['relocation']."&record_status=".$_REQUEST['record_status']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."&city=".$_REQUEST['city']."&state=".$_REQUEST['state']."&primary_skills_src=".$primary_skills."&secondary_skills_src=".$secondary_skills."&first=".$_REQUEST['first']."&last=".$_REQUEST['last']."\" class=\"more_link_pagination_prev\">Next</a>";

$pagination.="   ";

}

$qry_contact.=" limit $from,$max_results";

//echo $qry_contact;

$result=mysql_query($qry_contact);*/

////////////////////////////////End pagination////////////////////////////////////

///////////////////new pagination start/////////////////////////

$total_results = mysql_num_rows($sel_events);

$page=1;//Default page

$limit=10;//Records per page

$start=0;//starts displaying records from 0

if(isset($_GET['page']) && $_GET['page']!=''){

$page=$_GET['page'];

}

$start=($page-1)*$limit;

$qry_contact.=" LIMIT $start, $limit";

//echo $qry_contact;

$result=mysql_query($qry_contact);

///////////////////new pagination end/////////////////////////

if(mysql_num_rows($result)>0)

{

$inc=1;

while($row_contact_details=mysql_fetch_array($result))

{

$fname = $row_contact_details['firstname'];

$lname = $row_contact_details['lastname'];

$cphone = $row_contact_details['cphone'];

$associate_type = $row_contact_details['associate_type'];

$visa_status= $row_contact_details['visa_status'];

$pemail = $row_contact_details['pemail'];

if($row_contact_details['aemail']!=''){

$aemail = $row_contact_details['aemail'].',';

}

$acmgrMail = check_null_value('email','sat_users','user_id',$row_contact_details['account_manager']);

if($acmgrMail!='N/A'){

$acmgrMail = $acmgrMail;

}else{

$acmgrMail = '';

}

$ccMail = $aemail.$acmgrMail;

$current_associate_status = $row_contact_details['current_associate_status'];

<tr>

<td class="head_text2 <?php if($_REQUEST['req_id']!=''){ ?>pop_up_tooltip<?php } ?>">

<?php echo $fname; ?>

</td>

<td class="head_text2"><a href="mailto:<?php echo $pemail; ?>?cc=<?php echo $ccMail; ?>" class="email_mail"><?php echo $pemail; ?></a></td>

<a class="tooltp" href="view_employee.php?userid=<?php echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>"  id="ctl00_ContentPlaceHolder1_GridView1_ctl02_ViewTooltip">
    		V
    		<span> 
    			View Details
    			<i class="fa fa-caret-down"></i>
    		</span> 
    	</a>

<a class="tooltp" href="employeeform_edit.php?userid=<?php echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>"  id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink1">
    		U
    		<span class="lg-text"> 
    			Update Details
    			<i class="fa fa-caret-down"></i>
    		</span>
    	</a>

<?php /*?> <a href="empnotes.php?userid=<?php echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>" title="Notes" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink2">N</a>
	
	    <a href="view_H1B.php?userid=<?php  echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>" title="H1B" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink3">H</a>
	
	    <a href="view_green_card.php?userid=<?php echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>" title="Green Card" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink4">G</a>
	
	    <a href="view_LCA.php?userid=<?php  echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&associate_type=<?=$_REQUEST['associate_type']?>&visa_status=<?=$_REQUEST['visa_status']?>&account_manager=<?=$_REQUEST['account_manager']?>&hr_manager=<?=$_REQUEST['hr_manager']?>&sales_manager=<?=$_REQUEST['sales_manager']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>" title="LCA" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink5">L</a><?php */?>
    
    	<a class="tooltp" href="timesheet_edit.php?id=<?php  echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>">
    		T
    		<span> 
    			Timesheet
    			<i class="fa fa-caret-down"></i>
    		</span>
    	</a> 
    
		<a class="tooltp" href="javascript:void(0);" onclick="open_personal_div('<?php echo $inc; ?>');">
			H
			<span class="lg-text"> 
    			Hours Information
    			<i class="fa fa-caret-down"></i>
    		</span>
		</a> 
    </td>

<td class="head_text2"  align="center">
    	<?php if($current_associate_status=='Active'){?> <input type="checkbox" value="<?php echo $row_contact_details['staff_id'];?>" class="check_box" name="employee[]"  /><?php }else{ ?>--<?php } ?>
    
    
    <div id="personal_div<?php echo $inc; ?>" style="display:none;" class="white_content"  >
                        
                        <div class="close close-new" onclick="close_personal_div('<?php echo $inc; ?>');"><a href = "javascript:void(0);"></a> </div>
                            <div class="l-contnt relative up-contnt" style="height:180px;"> 
                            
                            <h2 class="up_nw_load_nw">Staff Hours Information</h2>
                            
                            <div id="success_hrs"></div>
                            <div class="clear"></div>
                            <div class="text-center auto-man">
                                                                                   
                            <a href="javascript:void(0);" onclick="update_hours_automatic('<?php echo $row_contact_details['staff_id']; ?>');">Automatic</a> | <a href="javascript:void(0);" onclick="update_hours_manual('<?php echo $row_contact_details['staff_id']; ?>');">Manual</a>
                            </div>
                            <div class="form-body reason_reject">
                            
		                            <?php $staff_personal_details = mysql_fetch_array(mysql_query("SELECT * FROM staff_personal WHERE staff_id = '".$row_contact_details['staff_id']."'")); ?>
		                            
		                            <form name="frm_hrs" id="frm_hrs" action="">        
		                            <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#616161" class="light-tbl" style="border-collapse:collapse;">
		
										  <tbody>
										  <tr>
										
										    <td width="116" class="head_text">Vacation</td>
										
										    <td width="94" class="head_text">Sick</td>
										
											<td width="94" class="head_text">Holiday</td>
										
										    <td width="85" class="head_text">Personal</td>
										
										  </tr>
										
										
										  <tr>
										
										    <td class="head_text2 ">
                                            <div id="vacation_text_<?php echo $row_contact_details['staff_id']; ?>" style="display:none;"><input type="text" name="vacation_txt" id="vacation_txt_<?php echo $row_contact_details['staff_id']; ?>" value="<?php echo $staff_personal_details['vacation'] ;?>" class="validate[required]" /></div>
                                            <div id="vacation_<?php echo $row_contact_details['staff_id']; ?>"><?php echo $staff_personal_details['vacation'] ;?></div></td>
															    
										    <td class="head_text2">
										    <div id="sick_text_<?php echo $row_contact_details['staff_id']; ?>" style="display:none;"><input type="text" name="sick_txt" id="sick_txt_<?php echo $row_contact_details['staff_id']; ?>" value="<?php echo $staff_personal_details['sick'] ;?>" class="validate[required]" /></div>
										    <div id="sick_<?php echo $row_contact_details['staff_id']; ?>"><?php echo $staff_personal_details['sick'] ;?></div></td>
										
											<td class="head_text2">
										    <div id="holiday_text_<?php echo $row_contact_details['staff_id']; ?>" style="display:none;"><input type="text" name="holiday_txt" id="holiday_txt_<?php echo $row_contact_details['staff_id']; ?>" value="<?php echo $staff_personal_details['holiday'] ;?>" class="validate[required]" /></div>
										    <div id="holiday_<?php echo $row_contact_details['staff_id']; ?>"><?php echo $staff_personal_details['holiday'] ;?></div></td>
										
										    <td class="head_text2">
										    <div id="personal_text_<?php echo $row_contact_details['staff_id']; ?>" style="display:none;"><input type="text" name="personal_txt" id="personal_txt_<?php echo $row_contact_details['staff_id']; ?>" value="<?php echo $staff_personal_details['personal'] ;?>" class="validate[required]" /></div>
										    <div id="personal_<?php echo $row_contact_details['staff_id']; ?>"><?php echo $staff_personal_details['personal'] ;?></div></td>
										
											</tr>
									</tbody> 
								</table>  
							</form>
		
							<div id="submit_<?php echo $row_contact_details['staff_id']; ?>" class="lg-s" style="display:none;text-align:center;   margin: 14px 0 0;">
								<a href="javascript:void(0);" class="require float-none org" onclick="update_hrs_manually('<?php echo $row_contact_details['staff_id']; ?>');">Submit</a>
							</div>  	
         
                             </div>
                             
                             
                            
                            </div>
                            </div>
                        <div id="fade1" class="black_overlay"> </div>
    
    
    
    
    
    </td>

<?php /*?> <td class="head_text2"><a href="javascript:void(0);" onClick="return view('<?php// echo $row_contact_details['candidate_id'];?>');" style="color:#094A66; font-family:Arial, Helvetica, sans-serif;">Primary Key</a></td><?php */?>

<?php /*?><td class="edit" style="padding:4px 0;">

<a href="candidateform_edit.php?userid=<?php echo $row_contact_details['candidate_id'];?>&page=<?php echo $page; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&main_skills=<?=$_REQUEST['main_skills']?>&order=<?=$_REQUEST['order']?>&candidate_type=<?=$_REQUEST['candidate_type']?>&owner=<?=$_REQUEST['owner']?>&visa_type=<?=$_REQUEST['visa_type']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>"><img src="images/edit.png" alt="Edit" title="Edit" /></a>

<?php

$sql_history="SELECT * FROM sat_staff_history WHERE candidate_id='".$row_contact_details['candidate_id']."'";

$res_history=mysql_query($sql_history);

$row_history=mysql_num_rows($res_history);

if($row_history>0)

{

<a title="History" href="candidate_history.php?hid=<?php echo $row_contact_details['candidate_id'];?>&page_main=<?=$_REQUEST['page']?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&main_skills=<?=$_REQUEST['main_skills']?>&order=<?=$_REQUEST['order']?>&candidate_type=<?=$_REQUEST['candidate_type']?>&owner=<?=$_REQUEST['owner']?>&visa_type=<?=$_REQUEST['visa_type']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>"><img src="images/history.png" width="19" height="22" alt="History" title="History"></a>

<?php

}

<?php

if($_SESSION['sat_login_id']==1 || $row_contact_details['owner']==$_SESSION['sat_login_id']){

<a href="employee.php?delete=del&delete_id=<?php echo $row_contact_details['candidate_id'];?>&page=<?=$_REQUEST['page']?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&main_skills=<?=$_REQUEST['main_skills']?>&order=<?=$_REQUEST['order']?>&candidate_type=<?=$_REQUEST['candidate_type']?>&owner=<?=$_REQUEST['owner']?>&visa_type=<?=$_REQUEST['visa_type']?>&hotlist=<?=$_REQUEST['hotlist']?>&blacklisted=<?=$_REQUEST['blacklisted']?>&send_emails=<?=$_REQUEST['send_emails']?>&relocation=<?=$_REQUEST['relocation']?>&record_status=<?=$_REQUEST['record_status']?>&submit2=<?=$_REQUEST['submit2']?>&state=<?=$_REQUEST['state']?>&city=<?=$_REQUEST['city']?>&primary_skills_src=<?=$primary_skills?>&secondary_skills_src=<?=$secondary_skills?>&first=<?=$_REQUEST['first']?>&last=<?=$_REQUEST['last']?>" onclick="return confirm('Are you sure you want to delete this candidate?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a>

<?php

}

</td><?php */?>

</tr>

<?php
	$inc++;
	}

$(function(){

$('#cango').click(function(){
	  
	  var pagego_id = $('#pagego').val();

if(pagego_id==''){

alert('Please put page number');

}else{

var url = 'employee.php?page='+pagego_id+'&name=<?php echo $_REQUEST['name']; ?>&email=<?php echo $_REQUEST['email'];?>&associate_type=<?php echo $_REQUEST['associate_type'];?>&visa_status=<?php echo $_REQUEST['visa_status'];?>&account_manager=<?php echo $_REQUEST['account_manager'];?>&hr_manager=<?php echo $_REQUEST['hr_manager'];?>&sales_manager=<?php echo $_REQUEST['sales_manager'];?>&hotlist=<?php echo $_REQUEST['hotlist'];?>&blacklisted=<?php echo $_REQUEST['blacklisted'];?>&send_emails=<?php echo $_REQUEST['send_emails'];?>&relocation=<?php echo $_REQUEST['relocation'];?>&record_status=<?php echo $_REQUEST['record_status'];?>&submit2=<?php echo $_REQUEST['submit2'];?>&state=<?php echo $_REQUEST['state'];?>&city=<?php echo $_REQUEST['city'];?>&primary_skills_src=<?php echo $primary_skills;?>&secondary_skills_src=<?php echo $secondary_skills;?>&first=<?php echo $_REQUEST['first'];?>&last=<?php echo $_REQUEST['last'];?>';

window.location = url;

}

});

</script>

<?php if($total_results > $limit){ ?>

<tr>

</td>

</tr>

<?php } ?>

<?php

}

else

{

<tr>

<td colspan="10" class="head_text" style=" color:#F00; font-size:14px;background-color:#B2CEFC;">No candidate found</td>

</tr>

<?php

}

</table>

</div>

<?php include("includes/footer.php"); ?>