<?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="Candidate Name"."\t";
$col_heading.="LCA Count"."\t";
$col_heading.="LCA Number"."\t";
$col_heading.="Work Location1"."\t";
$col_heading.="Prevl Wages1"."\t";
$col_heading.="Work Location2"."\t";
$col_heading.="Prevl Wages2"."\t";
$col_heading.="Wage Rate"."\t";
$col_heading.="LCA Position Title"."\t";
$col_heading.="Start Date"."\t";
$col_heading.="End Date"."\t";
$col_heading.="LCA Activity Status"."\t";
$col_heading.="Exmpt"."\t";
$col_heading.="LCA Status"."\t";
$col_heading.="Associate's Qualification"."\t";
$col_heading.="Graduation Year"."\t";
$col_heading.="Experience Years"."\t";
$col_heading.="Current Salary"."\t";
$col_heading.="LCA Level"."\t";
$col_heading.="LCA Given Rcpt"."\t";
$col_heading.="10 Days Posting Notice"."\t";
$col_heading.="Current Employment Status"."\t";
$col_heading.="Public Inspection File"."\t";
$col_heading.="Notes"."\t";
$col_heading.="Filed By"."\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 `lca_details` where 1 AND `candidate_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['candidate_name']),'lastname')."\t";
			$col_heading.=check_null($row_domestic_productDetails['lca_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['lca_number']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['work_location1']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['prevl_wages1']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['work_location2']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['prevl_wages2']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['wage_rate']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['lca_position_rate']))."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['start_date']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['end_date'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['lca_activity_status']))."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['exmpt']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['lca_staus'])."\t";
			$col_heading.=check_null($row_domestic_productDetails['associates_qualification'])."\t";
			$col_heading.=check_null_date(stripslashes($row_domestic_productDetails['graduation_year']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['experience_years']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['current_salary']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['lca_level']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['lca_given_rcpt']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['10days_posting_notice']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['current_employment_status']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['public_inspection_file'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['notes']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['filed_by']))."\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();
//}
?>