<?php 
session_start();
if($_SESSION['sat_login_id']!=''){
include('lib/conn.php');
include("functions.php");
$Randid=rand(100,500);
$date=date("m-d-Y");
$filename = $Randid."_".$date."_"."H1B_data.xls"; 

header("Expires: Sat, 01 Jan 2000 00:00:00 GMT"); 
header("Last-Modified: ".date("D, d M Y H:i:s")." GMT"); 
header("Pragma: public"); 
header("Expires: 0"); 
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Cache-Control: public"); 
header("Content-Description: File Transfer"); 

session_cache_limiter("must-revalidate"); 
header("Content-Type: application/vnd.ms-excel"); 
header('Content-Disposition: attachment; filename="' . $filename .'"'); 
$col_heading="Employee Name"."\t";
$col_heading.="GC Count"."\t";
$col_heading.="GC Status"."\t";
$col_heading.="Employee Status"."\t";
$col_heading.="Case"."\t";
$col_heading.="Filed By"."\t";
$col_heading.="Type"."\t";
$col_heading.="Category"."\t";
$col_heading.="Labor Status"."\t";
$col_heading.="I-140 Status"."\t";
$col_heading.="I-485 Sts"."\t";
$col_heading.="GC Job Title"."\t";
$col_heading.="GC Qualifications"."\t";
$col_heading.="GC Experience"."\t";
$col_heading.="Labor Filing Date"."\t";
$col_heading.="Labor Case Number"."\t";
$col_heading.="Labor Approval Date"."\t";
$col_heading.="Labor Salary"."\t";
$col_heading.="Priority Date"."\t";
$col_heading.="I-140 Filing Date"."\t";
$col_heading.="I-140 Receipt No"."\t";
$col_heading.="I-140 Approval Date"."\t";
$col_heading.="I-485 Filing Date"."\t";
$col_heading.="I-485 Receipt No"."\t";
$col_heading.="W2 2005"."\t";
$col_heading.="W2 2006"."\t";
$col_heading.="W2 2007"."\t";
$col_heading.="W2 2008"."\t";
$col_heading.="W2 2009"."\t";
$col_heading.="W2 2010"."\t";
$col_heading.="Note"."\t";
$col_heading.="I-765 Receipt#"."\t";
$col_heading.="I-131 Receipt#"."\t";
$col_heading.="I-485 Receipt#"."\t";
$col_heading.="I-765 Receipt# Spouse"."\t";
$col_heading.="I-131 Receipt# Spouse"."\t";
$col_heading.="I-485 Receipt# Spouse"."\t";
$col_heading.="USCIS Conf"."\t";
$col_heading.="Notes"."\t";
$col_heading.="Action Plan"."\t";
$col_heading.="Created By"."\t";
$col_heading.="Created Date"."\t";
$col_heading.="Last Update By"."\t";
$col_heading.="Last Update Date"."\t\n";



	if($_SESSION['sqlCandidate']!=''){
		$sql =$_SESSION['sqlCandidate'];
	}else{
		$sql ="select * from `sat_staff_view` where 1 AND `employee_name` = '".$_REQUEST['userid']."'";	
	}
	$result=mysql_query($sql);
	if(mysql_num_rows($result)>0){
		while($row_domestic_productDetails=mysql_fetch_array($result)){
			$col_heading.=check_null_value('firstname','sat_staff','staff_id',stripslashes($row_domestic_productDetails['employee_name']),'lastname')."\t";
			$col_heading.=check_null($row_domestic_productDetails['gc_count'])."\t";
			//$col_heading.=check_null_value('firstname','sat_staff','staff_id',stripslashes($row_domestic_productDetails['employee_name']),'lastname')."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['gc_status']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['employee_status']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['case1']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['filed_by']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['type']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['category']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['labor_status']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_140_status']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['I_485_sts'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['gc_jon_title']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['gc_qualifications']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['gc_experience'])."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['labor_filing_date'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['labor_case_number']))."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['labor_approval_date']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['labor_salary']))."\t";
			
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['priority_date']))."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['I_140_filing_date']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_140_receipt_no']))."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['I_140_approval_date']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['I_485_filing_date'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_485_receipt_no']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_2005']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_2006']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_2007']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_2008']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_2009']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['W2_20010']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['note']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_765_receipt']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_131_receipt']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_485_receipt']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_765_receipt_spouse']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_131_receipt_spouse']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['I_485_receipt_spouse']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['USCIS_conf']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['notes']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['action_plan']))."\t";
			
			$col_heading.=check_null_value('firstname','sat_users','user_id',stripslashes($row_domestic_productDetails['created_by']),'lastname')."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['created_date']))."\t";
			
			$col_heading.=check_null_value('firstname','sat_users','user_id',stripslashes($row_domestic_productDetails['last_update_by']),'lastname')."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['last_update_date']))."\t\n";
			
			
		}
		echo $col_heading;
		//exit;
	}
  $_SESSION['sqlCandidate']='';
	
	/*else{
		header('location:candidate.php?error=1');
		exit();
	}*/
}
else{
	header('location:index.php');
}

//}
//else{
	//header('location:index.php');
	//exit();
//}
?>