<?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."_"."employee_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="First Name"."\t";
$col_heading.="Last Name"."\t";
$col_heading.="Home Phone"."\t";
$col_heading.="Cell Phone"."\t";
$col_heading.="Address"."\t";
$col_heading.="Primary Email"."\t";
$col_heading.="Alternative Email"."\t";
$col_heading.="DOB"."\t";
$col_heading.="Associate Type"."\t";
$col_heading.="Visa Status"."\t";
$col_heading.="Billing Client Name"."\t";
$col_heading.="End Client Name"."\t";
$col_heading.="Work Site Street"."\t";
$col_heading.="Work Site city"."\t";
$col_heading.="Work Site State"."\t";
$col_heading.="Work Site Zip Code"."\t";
$col_heading.="Work Phone"."\t";
$col_heading.="Work Email"."\t";
$col_heading.="Client Payment Terms"."\t";
$col_heading.="Client Contact Name"."\t";
$col_heading.="Client Contact Email"."\t";
$col_heading.="Client Contact Phone No"."\t";
$col_heading.="On PSA"."\t";
$col_heading.="PSA Effective Date"."\t";
$col_heading.="PSA Deal Details"."\t";
$col_heading.="Insurance Coverage"."\t";
$col_heading.="Hire Date"."\t";
$col_heading.="Starting Date"."\t";
$col_heading.="Ending Date"."\t";
$col_heading.="Vendor Name"."\t";
$col_heading.="Vendor Contact Name"."\t";
$col_heading.="Vendor Contact Phone"."\t";
$col_heading.="Vendor Contact Email"."\t";
$col_heading.="Account Manager"."\t";
$col_heading.="HR Manager"."\t";
$col_heading.="Sales Manager"."\t";
$col_heading.="Source"."\t";

$col_heading.="Current Associate Status"."\t";
$col_heading.="Add Date"."\t";
$col_heading.="Notes"."\t\n";

	if($_SESSION['sqlCandidate']!=''){
		$sql =$_SESSION['sqlCandidate'];
	}else{
		$sql ="select * from `sat_staff` where 1 AND `staff_id` = '".$_REQUEST['userid']."'";	
	}
	$result=mysql_query($sql);
	if(mysql_num_rows($result)>0){
		while($row_domestic_productDetails=mysql_fetch_array($result)){
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['firstname']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['lastname'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['hphone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['cphone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['address']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['pemail']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['aemail']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['dob']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['associate_type']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['visa_status']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['billing_client_name']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['end_client_name'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['worksite_street']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['worksite_city']))."\t";
			$col_heading.=check_null($row_domestic_productDetails['worksite_state'])."\t";
			$col_heading.=check_null($row_domestic_productDetails['worksite_zipcode'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['work_phone_no']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['work_email']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['client_payment_terms']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['client_contact_name']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['client_contact_email']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['client_contact_phone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['on_psa']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['psa_effective_date'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['psa_deal_details']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['insurance_coverage']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['hire_date'])."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['starting_date'])."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['ending_date'])."\t";
			$col_heading.=check_null($row_domestic_productDetails['vendor_name'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['vendor_contact_name']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['vendor_conatct_phone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['vendor_contact_email']))."\t";
			$col_heading.=check_null_value('firstname','sat_users','user_id',stripslashes($row_domestic_productDetails['account_manager']),'lastname')."\t";
			$col_heading.=check_null_value('firstname','sat_users','user_id',stripslashes($row_domestic_productDetails['hr_manager']),'lastname')."\t";
			$col_heading.=check_null_value('firstname','sat_users','user_id',stripslashes($row_domestic_productDetails['sales_manager']),'lastname')."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['source']))."\t";
			
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['current_associate_status']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['add_date'])."\t";
			$col_heading.=check_null(htmlspecialchars_decode(stripslashes($row_domestic_productDetails['notes_comments'])))."\t";
			
		}
		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();
//}
?>