for ($ii = 0; $ii < $num2; $ii++) {
$day = mysql_result($result, $ii, "eav_day");
$shift = mysql_result($result, $ii, "eav_jsh_name");
$available[$day][$shift] = 1;
}
for ($ii = 1; $ii <= 7; $ii++) {
$shiftList = "";
for ($s = 0; $s < $jobshifts; $s++) {
if ($available[$ii][$jobshift[$s]] == 1) {
if (strlen($shiftList) > 0) {
$shiftList .= ", ";
}
$shiftList .= $jobshift[$s];
}
}
$line .= formatExcel($shiftList);
}
$data .= trim($line) . "\n";
}
$data = str_replace("\r", "", $data);
if ($data == "") {
$data = "\n(0) Records Found!\n";
}
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=employees.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "{$header}\n{$data}";
function formatExcel($value)
{
if (!isset($value) or $value == "") {
$query .= "ORDER BY emp_last_name";
$export = mysql_query($query);
$num = mysql_num_rows($export);
$header = "Employee\t" . date("D, M.j", $startDate) . "\t" . date("D, M.j", strtotime("+1 day", $startDate)) . "\t" . date("D, M.j", strtotime("+2 day", $startDate)) . "\t";
$header .= date("D, M.j", strtotime("+3 day", $startDate)) . "\t" . date("D, M.j", strtotime("+4 day", $startDate)) . "\t" . date("D, M.j", strtotime("+5 day", $startDate)) . "\t";
$header .= date("D, M.j", strtotime("+6 day", $startDate)) . "\t";
for ($i = 0; $i < $num; $i++) {
$emp_id = mysql_result($export, $i, "emp_id");
$emp_name = mysql_result($export, $i, "emp_name");
$line = '"' . $emp_name . '"' . "\t";
for ($j = 0; $j < 7; $j++) {
$query = "SELECT job_short FROM ss_jobs, ss_schedulestaff WHERE scs_emp_id = '" . $emp_id . "' AND job_id = scs_job_id AND scs_year = '" . $year . "' AND scs_month = '" . $month . "' AND scs_day = '" . ($day + $j) . "'";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
$value = mysql_result($result, 0, "job_short");
$line .= formatExcel($value);
} else {
$line .= "\t";
}
}
$data .= trim($line) . "\n";
}
$data = str_replace("\r", "", $data);
if ($data == "") {
$data = "\n(0) Records Found!\n";
}
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=schedule.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "{$header}\n{$data}";
$job_name = mysql_result($export, $i, "job_name");
$job_hours = mysql_result($export, $i, "job_hours");
$line = '"' . $job_name . '"' . "\t";
$totalHours = 0;
for ($ii = 1; $ii <= 7; $ii++) {
$query = "SELECT shj_num FROM ss_shiftjobs WHERE shj_job_id = '" . $job_id . "' AND shj_day = '" . $ii . "'";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
$value = mysql_result($result, 0, "shj_num");
$line .= formatExcel($value);
$totalHours += $value * $job_hours;
} else {
$line .= "\t";
}
}
$line .= formatExcel($totalHours);
$data .= trim($line) . "\n";
}
$data = str_replace("\r", "", $data);
if ($data == "") {
$data = "\n(0) Records Found!\n";
}
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=proforma.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "{$header}\n{$data}";
function formatExcel($value)
{
if (!isset($value) or $value == "") {
$value = "\t";
