<?php
session_start();
ob_start();
include('lib/conn.php');
include('functions.php');

$hr_manager_id = $_SESSION['sat_login_id'];

$level = getUserlevel($hr_manager_id);

function change_dateformat_get_day($date_form)
{

	if($date_form!=''){

		$date1=explode("-",$date_form);

		$dateformat=$date1[2]."-".$date1[0]."-".$date1[1];

		return $dateformat;
	}
	else{
		$dateformat='';
		return $dateformat;
	}
}

$associate_type = '';
$sep = '';
foreach($_REQUEST['associate_type'] as $assoc_type)
{
	$associate_type = $associate_type.$sep.$assoc_type;
	$sep = ',';
}

$visa_status = '';
$sep1 = '';
foreach($_REQUEST['visa_status'] as $visa_sts)
{
	$visa_status = $visa_status.$sep1.$visa_sts;
	$sep1 = ',';
}


// Some html code omitted
function cleanData(&$str) {
	// escape tab characters 
	$str = preg_replace("/\t/", "\\t", $str); 
	// escape new lines 
	$str = preg_replace("/\r?\n/", "\\n", $str); 
	// convert 't' and 'f' to boolean values 
	if($str == 't') $str = 'TRUE'; 
	if($str == 'f') $str = 'FALSE'; 
	// force certain number/date formats to be imported as strings 
	if(preg_match("/^0/", $str) || preg_match("/^\+?\d{8,}$/", $str) || preg_match("/^\d{4}.\d{1,2}.\d{1,2}/", $str)) 
		{ $str = "'$str"; } 
	// escape fields that include double quotes 
	if(strstr($str, '"')) 
		$str = '"' . str_replace('"', '""', $str) . '"'; 
} 
function export() {
        // file name for download 
        $filename = "ABSI Timesheet Report for Period - " . $_REQUEST['start_date'] ." -  " . $_REQUEST['end_date'] .".xls"; 
        header("Content-Disposition: attachment; filename=\"$filename\""); 
        header("Content-Type: application/vnd.ms-excel"); 
        $flag = false;
		
		$sql = "SELECT * FROM sat_staff as sat_sf INNER JOIN timesheet tm ON sat_sf.staff_id = tm.staff_id INNER JOIN timesheet_weekly_hours as twh ON tm.id = twh.timesheet_id  WHERE tm.date_from = '".change_dateformat_get_day($_REQUEST['start_date'])."' AND tm.date_to = '".change_dateformat_get_day($_REQUEST['end_date'])."'";
		
		if($associate_type != '')
		{
			$sql.=" AND sat_sf.associate_type in (".$associate_type.")";
		}
		
		if($visa_status != '')
		{
			$sql.=" AND sat_sf.visa_status in (".$visa_status.")";
		}
		
		if($level == '2')
		{
			$sql.=" AND sat_sf.hr_manager = '".$hr_manager_id."'";
		}
		
		$result = mysql_query($sql);
		
		$inc = 1;
		while(false !== ($row = mysql_fetch_assoc($result))) { 
			
	        if(!$flag) { 
		        // display field/column names as first row 
		    echo  "Time Sheet Status Report"."\t"." "."\t"." "."\t"."Period -->"."\t".$_REQUEST['start_date']."\t".$_REQUEST['end_date']."\n";
			echo  " "."\t"." "."\t"." "."\t"." "."\t"."Approved"."\t"."Un-Approved"."\t"."Holiday"."\t"."Vacation"."\t"."Personal"."\t"."Sick"."\t"."Un-paid Time"."\t"."Total"."\t"."Submitted"."\t"."<40"."\n";
			echo  "Serial No."."\t"."Staff Code"."\t"."Name"."\t"."Type"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Hours"."\t"."Saved"."\t"."Explanation"."\n";
			 $flag = true; 
	        }         
	        array_walk($row, 'cleanData');
			
			$staff_name =  $row['lastname'].", ".$row['firstname'];
			
			$approved_hours = ($row['sun_approved'] + $row['mon_approved'] + $row['tue_approved'] + $row['wed_approved'] + $row['thu_approved'] + $row['fri_approved'] + $row['sat_approved']);
			$unapproved_hours = ($row['sun_unapproved'] + $row['mon_unapproved'] + $row['tue_unapproved'] + $row['wed_unapproved'] + $row['thu_unapproved'] + $row['fri_unapproved'] + $row['sat_unapproved']);
			$holiday_hours = ($row['sun_holiday'] + $row['mon_holiday'] + $row['tue_holiday'] + $row['wed_holiday'] + $row['thu_holiday'] + $row['fri_holiday'] + $row['sat_holiday']);
			$vacation_hours = ($row['sun_vacation'] + $row['mon_vacation'] + $row['tue_vacation'] + $row['wed_vacation'] + $row['thu_vacation'] + $row['fri_vacation'] + $row['sat_vacation']);
			$personal_hours = ($row['sun_personal'] + $row['mon_personal'] + $row['tue_personal'] + $row['wed_personal'] + $row['thu_personal'] + $row['fri_personal'] + $row['sat_personal']);
			$sick_hours = ($row['sun_sick'] + $row['mon_sick'] + $row['tue_sick'] + $row['wed_sick'] + $row['thu_sick'] + $row['fri_sick'] + $row['sat_sick']);
			$unpaid_hours = ($row['sun_unpaid'] + $row['mon_unpaid'] + $row['tue_unpaid'] + $row['wed_unpaid'] + $row['thu_unpaid'] + $row['fri_unpaid'] + $row['sat_unpaid']);
			$total_hours = $row['weekly_hours'];
			
			if($row['submit_flag'] == 1){
				$submit_status = 'Submitted';
			}else{
				$submit_status = 'Saved';
			}
			
			
			$str = $inc."\t".$row['staff_code']."\t".$staff_name."\t".$row['associate_type']."\t".$approved_hours."\t".$unapproved_hours."\t".$holiday_hours."\t".$vacation_hours."\t".$personal_hours."\t".$sick_hours."\t".$unpaid_hours."\t".$total_hours."\t".$submit_status."\t".$row['explanation']."\t"."\n";
			echo $str;
			
			$inc++;
        }
}


export();

?>