Preview: LCA_xls_report.php
Size: 5.22 KB
/home/jambtst2015/public_html/giraffeng.com/admin/LCA_xls_report.php
<?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();
//}
?>
Directory Contents
Dirs: 17 × Files: 180