Preview: view_green_card.php
Size: 29.58 KB
/home/jambtst2015/public_html/giraffeng.com/admin/view_green_card.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<script>
function open_src(val){
if(val==''){
$('#excel_open').toggle("slow");
}
else{
$('#div_src_req').toggle("slow");
}
}
function open_src1(val){
if(val==''){
$('#div_src_req').toggle("slow");
}
else{
$('#div_src_req').toggle("slow");
}
}
function linK(){
var user_id = document.getElementById("anotheruser1").value;
window.location = "GREEN_xls_report.php?userid="+user_id;
}
function changeUser(){
var value = document.getElementById("anotheruser").value;
//alert(value);
window.location = "<?php echo 'http://' . $_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/'; ?>view_green_card.php?userid="+value+"&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']?>";
}
</script>
<?php
/*---fetch value----*/
//include('lib/conn.php');
//include("functions.php");
$userId = $_REQUEST['userid'];
$userhId = $_REQUEST['userhid'];
if($userId!=''){
}
?>
<body>
<div class="container_bottom_section">
<a class="require" style="margin-right:5px; margin-bottom:5px;" href="employee.php?userid=<?=$_REQUEST['userid'];?>&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']?>">Back</a>
<a href="new_green_card.php?userid=<?=$_REQUEST['userid'];?>&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']?>" class="require" style="margin-right:5px; margin-bottom:5px;">Add Green Card</a>
<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Click For export to excel </a>
<a href="javascript:open_src1('');" class="require" style="margin-right:5px; margin-bottom:5px;">Search</a>
<div style="clear:both"></div>
</div>
<div class="body_section">
<style>
#div_src_req{display:none;}
#div_src{display:none;}
</style>
<div class="clear"></div>
<div style="padding:5px; border:1px solid #C4C4C4; margin-bottom:10px;<?php if($_REQUEST['notice_no']!='' || $_REQUEST['search_by']!=''){ ?> display:block; <?php } ?>" 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="" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="require_table_search">
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td align="center">
Select Requirement:
<select name="search_by" class="selectfield require_select">
<option value="labor_case_number" <?php if($_REQUEST['search_by']=="labor_case_number"){?> selected <?php } ?>>Labor Case Number</option>
<option value="I_140_receipt_no" <?php if($_REQUEST['search_by']=="I_140_receipt_no"){?> selected <?php } ?>>I 140 Receipt No</option>
<option value="I_485_receipt_no" <?php if($_REQUEST['search_by']=="I_485_receipt_no"){?> selected <?php } ?>>I 485 Receipt No</option>
<option value="I_765_receipt" <?php if($_REQUEST['search_by']=="I_765_receipt"){?> selected <?php } ?>>I 765 Receipt</option>
<option value="I_131_receipt" <?php if($_REQUEST['search_by']=="I_131_receipt"){?> selected <?php } ?>>I 131 Receipt</option>
<option value="I_485_receipt" <?php if($_REQUEST['search_by']=="I_485_receipt"){?> selected <?php } ?>>I 485 Receipt</option>
<option value="I_765_receipt_spouse" <?php if($_REQUEST['search_by']=="I_765_receipt_spouse"){?> selected <?php } ?>>I 765 Receipt Spouse</option>
<option value="I_131_receipt_spouse" <?php if($_REQUEST['search_by']=="I_131_receipt_spouse"){?> selected <?php } ?>>I 131 Receipt Spouse</option>
<option value="I_485_receipt_spouse" <?php if($_REQUEST['search_by']=="I_485_receipt_spouse"){?> selected <?php } ?>>I 485 Receipt Spouse</option>
</select>
<input type="text" name="notice_no" id="notice_no" value="<?php echo $_REQUEST['notice_no'];?>" class="textfield require_field"/>
</td>
</tr>
<tr><td> </td></tr>
<tr><td align="center">
<input name="sub" type="submit" value="Search" class="submit_14" />
</td></tr>
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td> </td>
<td colspan="4"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="4"> </td>
</tr>
</table>
</form>
</div>
<div class="body_container table_container table_container_nw" style="width:100%;">
<div class="container_bottom_section tbl_req_new" style="width:100%;">
<form name="myfrm" action="" method="post" id="formID" enctype="multipart/form-data">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#000000" style="border-collapse:collapse; margin:0 auto;">
<?php
if(empty($_REQUEST['success'])){ $_REQUEST['success']=''; }
if($_REQUEST['success']=='1'){
?>
<tr>
<td colspan="2" class="head_text" style="color:#090; background:none; text-align:left;" align="left">Green Card Added Successfully</td>
</tr>
<?php
}
if($_REQUEST['success']=='2'){
?>
<tr>
<td colspan="2" class="head_text" style="color:#090; background:none; text-align:left;" align="left">Green Card Updated Successfully</td>
</tr>
<?php
}
?>
<tr>
<?php
if($_REQUEST['edit']=='no'){
?>
<td colspan="2" style="font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#F00;">
Sorry, you do not have permission to edit this entry.
</td>
<?php } ?></tr>
<tr>
<?php
//} ?>
<tr>
<td colspan="2">
<br>
<p id="excel_open" style="display:none" align="center" class="fieldtextnew view_requirement">
Employee Name:<select name="anotheruser1" id="anotheruser1" >
<?php
$ActUsers = mysql_query("SELECT `staff_id` , `firstname` , `lastname` FROM `sat_staff` WHERE `current_associate_status`='Active'");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['staff_id']; ?>" <?php if($ActUsers1['staff_id']==$_REQUEST['userid']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
<?php } ?>
</select>
<a href="javascript:void(0)" onClick="return linK();" style="background-color: #7AAAF5; border-radius: 5px;color: #FFFFFF;width:16;height:20;padding:4px;font: 12px Arial,Helvetica,sans-serif;">Export to excel</a>
</p>
<br>
<p align="center" class="fieldtextnew view_requirement"> Select another consultant: <select name="anotheruser" id="anotheruser" onChange="return changeUser();" class="selectfield require_select">
<?php
$ActUsers = mysql_query("SELECT `staff_id` , `firstname` , `lastname` FROM `sat_staff` WHERE `current_associate_status`='Active'");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['staff_id']; ?>" <?php if($ActUsers1['staff_id']==$_REQUEST['userid']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
<?php } ?>
</select>
</p>
<br>
<p class="client_table"> Green Card Details</p>
</td>
</tr>
<?php if(empty($error)){$error='';}
if($error!=''){
?>
<tr>
<td colspan="2">
<div class="error"><?php echo $error; ?></div>
</td>
</tr>
<?php } ?>
<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="0" class="table_top2">
<?php
$query1 = "select * from sat_staff_view where employee_name='".$userId."'";
if($_REQUEST['search_by']!='' && $_REQUEST['notice_no']!=''){
$query1 .=" AND ".$_REQUEST['search_by']." = '".mysql_real_escape_string($_REQUEST['notice_no'])."'";
}
$query1 .= " ORDER by staff_view_id DESC";
$query = mysql_query($query1);
$no_of_record=mysql_num_rows($query);
while($result=mysql_fetch_array($query)){
?>
<tr>
<td>
<table>
<tr>
<td valign="top" width="50%" >
<table class="table_fst candidate_table_margin" style="margin-top:0px; padding-left:16px !important;">
<tr>
<td width="170" align="left" valign="top" class="fieldtextnew view_requirement">Employee Name :</td>
<td width="281" valign="top" class="fieldtextnewtext"><?php if($result['employee_name']!='') {
$employee = mysql_fetch_array(mysql_query("SELECT firstname,lastname FROM `sat_staff` WHERE `staff_id` = '$result[employee_name]'"));
echo $employee['firstname']." ".$employee['lastname']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td width="170" align="left" valign="top" class="fieldtextnew view_requirement">GC Count :</td>
<td width="281" valign="top" class="fieldtextnewtext"><?php echo $result['gc_count']?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">GC Status :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['gc_status']!='') { echo $result['gc_status']; }else{ echo "N/A"; }?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Employee Status :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['employee_status']!='') { echo $result['employee_status']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Case :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['case1']!='') { echo $result['case1']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Filed By :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['filed_by']!='') { echo $result['filed_by']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Type :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['type']!='') { echo $result['type']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Category :</td>
<td valign="top" class="fieldtextnewtext">
<?php
if($result['category']=='') {
echo 'N/A';
}
else{
echo $result['category'];
}
?>
</td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Labor Status :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['labor_status']!='') { echo $result['labor_status']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-140 Status :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_140_status']!='') { echo $result['I_140_status']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-485 Status :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_485_sts']!='') { echo $result['I_485_sts']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">GC Job Title :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['gc_jon_title']!='') { echo $result['gc_jon_title']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">GC Qualifications :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['gc_qualifications']!='') { echo $result['gc_qualifications']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">GC Experience :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['gc_experience']!='') { echo $result['gc_experience']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Labor Filing Date :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['labor_filing_date']!='0000-00-00') { echo change_dateformat_reverse($result['labor_filing_date']); }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Labor Case Number :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['labor_case_number']!='') { echo $result['labor_case_number']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Labor Approval Date :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['labor_approval_date']!='0000-00-00') { echo change_dateformat_reverse($result['labor_approval_date']); }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Labor Salary :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['labor_salary']!='') { echo $result['labor_salary']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Priority Date :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['priority_date']!='0000-00-00') { echo change_dateformat_reverse($result['priority_date']); }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-140 Filing Date :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_140_filing_date']!='0000-00-00') { echo change_dateformat_reverse($result['I_140_filing_date']); }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td width="235" align="left" valign="top" class="fieldtextnew view_requirement">I-140 Receipt No. :</td>
<td width="216" valign="top" class="fieldtextnewtext">
<?php if($result['I_140_receipt_no']!='') { echo $result['I_140_receipt_no']; }else{ echo "N/A"; } ?>
</td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement"><span style="padding-top:13px;">I-140 Approval Date</span> :</td>
<td valign="top" class="fieldtextnewtext">
<?php if($result['I_140_approval_date']!='0000-00-00') { echo change_dateformat_reverse($result['I_140_approval_date']); }else{ echo "N/A"; } ?>
</td>
</tr>
</table>
</td>
<td valign="top" width="50%" >
<table class="table_scnd candidate_table_margin" style="padding-left:16px !important;">
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement"><span style="padding-top:13px;">I-485 Filing Date</span> :</td>
<td valign="top" class="fieldtextnewtext">
<?php if($result['I_485_filing_date']!='0000-00-00') { echo change_dateformat_reverse($result['I_485_filing_date']); }else{ echo "N/A"; } ?>
</td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement"><span style="padding-top:13px;">I-485 Receipt No</span> :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_485_receipt_no']!='') { echo $result['I_485_receipt_no']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement"><span style="padding-top:13px;">W2 2005</span> :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['W2_2005']!='') { echo $result['W2_2005']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">W2 2006 :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['W2_2006']!='') { echo $result['W2_2006']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">W2 2007 :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['W2_2007']!='') { echo $result['W2_2007']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">W2 2008 :</td>
<td valign="top" class="fieldtextnewtext">
<?php if($result['W2_2008']!='') { echo $result['W2_2008']; }else{ echo "N/A"; } ?>
</td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">W2 2009 :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['W2_2009']!='') { echo $result['W2_2009']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">W2 2010 :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['W2_2010']!='') { echo $result['W2_2010']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Note :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['note']!='') { echo $result['note']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-765 Receipt# :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_765_receipt']!='') { echo $result['I_765_receipt']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-131 Receipt# :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_131_receipt']!='') { echo $result['I_131_receipt']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-485 Receipt# :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_485_receipt']!='') { echo $result['I_485_receipt']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-765 Receipt# Spouse :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_485_receipt']!='') { echo $result['I_485_receipt']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-131 Receipt# Spouse :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_131_receipt_spouse']!='') { echo $result['I_131_receipt_spouse']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">I-485 Receipt# Spouse :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['I_485_receipt_spouse']!='') { echo $result['I_485_receipt_spouse']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">USCIS Conf :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['USCIS_conf']!='') { echo $result['USCIS_conf']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Notes :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['notes']!='') { echo $result['notes']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Action Plan :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['action_plan']!='') { echo $result['action_plan']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Created By :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['created_by']!='') {
$created_by = mysql_fetch_array(mysql_query("SELECT firstname,lastname FROM `sat_users` WHERE `user_id` = '$result[created_by]'"));
echo $created_by['firstname']." ".$created_by['lastname']; }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Created Date :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['created_date']!='0000-00-00') { echo change_dateformat_reverse($result['created_date']); }else{ echo "N/A"; } ?></td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Last Update By :</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['last_update_by']!='') {
$update_by = mysql_fetch_array(mysql_query("SELECT firstname,lastname FROM `sat_users` WHERE `user_id` = '$result[last_update_by]'"));
echo $update_by['firstname']." ".$update_by['lastname']; }else{ echo "N/A"; } ?>
</td>
</tr>
<tr>
<td align="left" valign="top" class="fieldtextnew view_requirement">Last Update Date:</td>
<td valign="top" class="fieldtextnewtext"><?php if($result['last_update_date']!='0000-00-00') { echo change_dateformat_reverse($result['last_update_date']); }else{ echo "N/A"; } ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="8" align="center">
<a href="edit_green_card.php?edit_id=<?php echo $result['staff_view_id']; ?>&userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="edit" type="button" value="Edit" class="submit" style=" margin-bottom:10px;" /></a>
<?php /*?>
<a href="employee.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="Cancel" class="submit" style=" margin-bottom:10px;" /></a>
<a href="view_LCA.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="LCA" class="submit" style=" margin-bottom:10px;" /></a>
<a href="view_H1B.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="H1B" class="submit" style=" margin-bottom:10px;" /></a><?php */?>
</td>
</tr>
</table>
</td>
<?php
}
?>
</tr>
<?php
if($no_of_record=='0'){
?>
<tr>
<td colspan="10" class="head_text" style=" color:#F00; font-size:14px;background-color:#B2CEFC;" align="center">No Result Found</td>
</tr>
<?php } ?>
<tr>
<td colspan="10" align="center">
<a href="employee.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="Cancel" class="submit" style=" margin-bottom:10px;" /></a>
<a href="view_LCA.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="LCA" class="submit" style=" margin-bottom:10px;" /></a>
<a href="view_H1B.php?userid=<?=$_REQUEST['userid'];?>&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']?>">
<input name="cancel" type="button" value="H1B" class="submit" style=" margin-bottom:10px;" /></a>
</td>
</tr>
<!--<tr>
<td colspan="2" height="20" bgcolor="#EFEFEF">
</td>
</tr>-->
</table>
</td>
</tr>
</table>
<tr>
</tr>
<div class="clear"></div>
</form>
</div>
</div>
</div>
</body>
</html>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180