Preview: employee_3-2-5.php
Size: 48.75 KB
/home/jambtst2015/public_html/giraffeng.com/admin/employee_3-2-5.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>";
?>
<script>
$(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'));
//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_automatic(id){
var cnfm = confirm("Are you sure to reinitialize all hours automatically.");
if(cnfm == true){
$('#sick_text_'+id).hide();
$('#holiday_text_'+id).hide();
$('#personal_text_'+id).hide();
$.ajax({
url : 'update_hours_automatic.php',
type : 'POST',
data : 'staff_id='+id,
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(url);
},
success : function(data, textStatus, jqXHR){
var str = data;
var hrs = str.split("^");
$('#sick_'+id).html(hrs[0]);
$('#holiday_'+id).html(hrs[1]);
$('#personal_'+id).html(hrs[2]);
$('#sick_'+id).show();
$('#holiday_'+id).show();
$('#personal_'+id).show();
$("#success_hrs").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Hours Reinitialized Successfully.</p>');
//$('#market_div').html(data);
},
/*complete : function(jqXHR, textStatus){
alert(3);
},*/
error : function(jqXHR, textStatus, errorThrown){
}
});
}else{
return false;
}
}
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();
}
function update_hrs_manually(id){
if(!$("#frm_hrs").validationEngine('validate'))
{
return false;
}
else
{
var vacation = $('#vacation_txt_'+id).val();
var sick = $('#sick_txt_'+id).val();
var holiday = $('#holiday_txt_'+id).val();
var personal = $('#personal_txt_'+id).val();
$.ajax({
url : 'update_hours_manual.php',
type : 'POST',
data : 'staff_id='+id+'&holiday='+holiday+'&personal='+personal+'&sick='+sick+'&vacation='+vacation,
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(url);
},
success : function(data, textStatus, jqXHR){
var str = data;
var hrs = str.split("^");
$('#sick_text_'+id).hide();
$('#holiday_text_'+id).hide();
$('#personal_text_'+id).hide();
$('#vacation_text_'+id).hide();
$('#submit_'+id).hide();
$('#sick_'+id).html(hrs[0]);
$('#holiday_'+id).html(hrs[1]);
$('#personal_'+id).html(hrs[2]);
$('#vacation_'+id).html(hrs[3]);
$('#sick_'+id).show();
$('#holiday_'+id).show();
$('#personal_'+id).show();
$('#vacation_'+id).show();
$("#success_hrs").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Hours Reinitialized Successfully.</p>');
//$('#market_div').html(data);
},
/*complete : function(jqXHR, textStatus){
alert(3);
},*/
error : function(jqXHR, textStatus, errorThrown){
}
});
}
}
</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']."");
}*/
}
?>
<script type="text/javascript" language="javascript">
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>
<div class="container_bottom_section">
<?php if($delmsg!=''){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $delmsg; ?></p>
<?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="clear"></div>
<!--requirement search-->
<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">
<div class="require_add">
<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;">Search By Requirement</h3>
<!--<a href="candidateform.php" class="require">Add Candidate</a>-->
<div class="clear"></div>
</div>
<form name="myfrm_req" action="employee.php" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="table_search">
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td width="137" height="25" valign="top" class="require_table_search">Requirement:</td>
<td colspan="4" align="left" valign="top">
<select name="req_id" class="validate[required] selectfield require_select">
<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="35"> </td>
<td width="135" valign="top" class="require_table_search"><?php if($_REQUEST['req_id']!=''){ ?>Primary Skill:<?php } ?></td>
<td colspan="4" align="left" valign="top">
<?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>
<td width="11"> </td>
<td width="143" valign="top" class="require_table_search"> </td>
<td width="435" colspan="4" align="left" valign="top"> </td>
</tr>
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td> </td>
<td colspan="4"> </td>
<td> </td>
<td> </td>
<td colspan="4"><span style="float:left;">
<input name="submit2" type="submit" value="GO" class="submit" style="margin-top:0px;" />
</span></td>
<td> </td>
<td> </td>
<td colspan="4"> </td>
</tr>
</table>
</form>
</div>
<!--requirement search-->
<!--search-->
<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">
<div class="require_add">
<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>
<!--<a href="candidateform.php" class="require">Add Candidate</a>-->
<div class="clear"></div>
</div>
<form name="myfrm" action="employee.php" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="table_search">
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td width="98" height="25" valign="top" class="require_table_search">Name:</td>
<td colspan="4" align="left" valign="top">
<input type="text" name="name" class="textfield require_field" value="<?php echo $_REQUEST['name']; ?>" />
</td>
<td width="21"> </td>
<td width="135" valign="top" class="require_table_search">Primary Email:</td>
<td colspan="4" align="left" valign="top"><input type="text" name="email" class="textfield require_field" value="<?php echo $_REQUEST['email']; ?>" /></td>
<td width="13"> </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>
<td colspan="4" align="left" valign="top"><select class=" selectfield require_select" id="visa_status" name="visa_status">
<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> </td>
<td valign="top" class="require_table_search">Account Manager</td>
<td colspan="4" align="left" valign="top"><select name="account_manager" id="account_manager" class=" selectfield require_select">
<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)){
?>
<option value="<?php echo $array_product['user_id']; ?>" <?php if($_REQUEST['account_manager']==$array_product['user_id']) echo "selected"; ?>> <?php echo $array_product['firstname']?> </option>
<?php
}
?>
</select></td>
<td> </td>
<td valign="top" class="require_table_search">HR Manager:</td>
<td colspan="4" align="left" valign="top"><select name="hr_manager" class=" selectfield require_select">
<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)){
?>
<option value="<?php echo $array_product['user_id']; ?>" <?php if($_REQUEST['hr_manager']==$array_product['user_id']) echo "selected"; ?>> <?php echo $array_product['firstname']?> </option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td height="25" valign="top" class="require_table_search">Sales Manager</td>
<td colspan="4" align="left" valign="top"><select name="sales_manager" class=" selectfield require_select">
<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)){
?>
<option value="<?php echo $array_product['user_id']; ?>" <?php if($_REQUEST['sales_manager']==$array_product['user_id']) echo "selected"; ?>> <?php echo $array_product['firstname']?> </option>
<?php
}
?>
</select></td>
<td> </td>
<td valign="top" class="require_table_search">Status:</td>
<td colspan="4" align="left" valign="top"><select name="record_status" class="selectfield require_select">
<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> </td>
<td valign="top" class="require_table_search">Sort Order:</td>
<td colspan="4" align="left" valign="top">
<select name="order" class="selectfield require_select">
<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>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td colspan="8">
<span style="float:left;">
<input name="submit2" type="submit" value="Search" class="require sm" style="margin-top:0px !important;" />
<a href="employee.php" style="text-decoration:none;" class="require org"> Show All
<!-- <input name="submit3" type="button" value="Show All" class="submit" style="margin-top:0px;" /> -->
</a>
</span>
</td>
</tr>
</table>
</form>
</div>
<!--search-->
<div class="container_bottom_section tbl_cls_new tbl_req_new" style="width:100%;">
<table width="1100" border="1" cellspacing="0" cellpadding="0" bordercolor="#616161" style="border-collapse:collapse;" class="list-table">
<tr>
<td width="116" class="head_text">First Name</td>
<td width="94" class="head_text">Last 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="147" class="head_text">Type</td>
<td width="124" class="head_text">Visa</td>
<td width="110" class="head_text">Status </td>
<td width="110" class="head_text">Action </td>
<td width="116" align="center" class="head_text"><input id="chkAllFiles" type="checkbox" title="All Files" style="margin-right:8px;" /></td>
</tr>
<form action="employee.php" method="post" id="send_mail" name="send_mail">
<input type="hidden" name="re_ini" id="re_ini" value="" />
<!--<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">Home/Cell/Work</td>
<td class="head_text2">Typesetting Industry</td>
<td class="head_text2">Valid User 1,2,3</td>
<td class="edit">
<a href="candidateform.html"><img src="images/edit.png" width="16" height="16" /></a>
<a href="#"><img src="images/view.png" width="16" height="16" /></a>
</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"><?php echo $lname; ?></td>
<td class="head_text2"><?php echo $row_contact_details['username']; ?></td>
<td class="head_text2"><a href="mailto:<?php echo $pemail; ?>?cc=<?php echo $ccMail; ?>" class="email_mail"><?php echo $pemail; ?></a></td>
<td class="head_text2"><?php echo $cphone; ?></td>
<td class="head_text2"><?php echo $associate_type; ?></td>
<td class="head_text2"><?php if($visa_status!=''){ echo $visa_status; }else{ echo 'N/A'; } ?></td>
<td class="head_text2"><?php if($current_associate_status!=''){ echo $current_associate_status; }else{ echo "N/A"; } ?></td>
<td class="head_text2">
<a 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']?>" title="View Details" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_ViewTooltip">V</a>
<a 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']?>" title="Update Details" id="ctl00_ContentPlaceHolder1_GridView1_ctl02_HyperLink1">U</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 href="timesheet_edit.php?id=<?php echo $row_contact_details['staff_id'];?>&page=<?php echo $_REQUEST['page']; ?>" title="Timesheet">T</a>
<a href="javascript:void(0);" onclick="open_personal_div('<?php echo $inc; ?>');" title="Hours Information">H</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']; ?>" style="display:none;text-align:center;">
<a href="javascript:void(0);" class="new_btn" 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++;
}
?>
<script type="text/javascript" language="javascript">
$(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 colspan="10" class="head_text1 tbl-footer pagination-nw" style="background-color:;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<?php echo pagination($limit,$page,'employee.php?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'].'&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'].'&req_id='.$_REQUEST['req_id'].'&page=',$total_results); //call function to show pagination ?>
</td>
<td>
<div class="goto-page">
<input type="text" class="search_go_new" name="pagego" id="pagego" value="<?php echo $page; ?>" />
<input type="submit" name="submit" value="Go" id="cango" class="require sm"/>
</div>
</td>
</tr>
</table>
</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 class="clear"></div>
</div>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180