$objPHPExcel->getActiveSheet()->getStyle('Q2')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('Q5', $LANG_NEXTIME_REPORTS['technician_region']);
//$objPHPExcel->getActiveSheet()->getStyle('Q5')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Q5')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('Q4', $LANG_NEXTIME_REPORTS['supervisor_name']);
//$objPHPExcel->getActiveSheet()->getStyle('Q4')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Q4')->getFont()->setName('Arial');
//$objPHPExcel->getActiveSheet()->setCellValue('A4', $LANG_NEXTIME_REPORTS['supervisor_title']);
//$objPHPExcel->getActiveSheet()->getStyle('A4')->getFont()->setBold(true);
//$objPHPExcel->getActiveSheet()->getStyle('A4')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('U3')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('U3', $A['fullname']);
$objPHPExcel->getActiveSheet()->getStyle('U3')->getFont()->setSize(14);
//$objPHPExcel->getActiveSheet()->getStyle('U3')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('U4')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('U4', DB_getItem($_TABLES['users'], 'fullname', 'uid=' . $ts->getSupervisorUID($A['uid'])));
//$objPHPExcel->getActiveSheet()->getStyle('D4')->getFont()->setName('Arial');
//$objPHPExcel->getActiveSheet()->setCellValue('D4','');
$objPHPExcel->getActiveSheet()->getStyle('U2')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('U2', $tech_number);
$objPHPExcel->getActiveSheet()->getStyle('U2')->getFont()->setSize(14);
//$objPHPExcel->getActiveSheet()->getStyle('U2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('U5')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('U5', nexlistValue($CONF_NEXTIME['nexlist_user_locations'], DB_getItem($_TABLES['nextime_extra_user_data'], 'region', 'uid=' . $A['uid']), 0));
$objPHPExcel->getActiveSheet()->getStyle('Q6')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('Q6', $LANG_NEXTIME_REPORTS['period_from']);
$objPHPExcel->getActiveSheet()->getStyle('Q7')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('Q7', $LANG_NEXTIME_REPORTS['period_to']);
$objPHPExcel->getActiveSheet()->getStyle('U6')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->setCellValue('U6', $start_date);
$objPHPExcel->getActiveSheet()->getStyle('U7')->getFont()->setName('Arial');
$output .= $ts->generateTableHeader(false, true, $ts->determineIfItemIsInLockRangeByDateStamp($startStamp, $emp));
$retval = $ts->generateTimesheetRows($emp, $startStamp, $numberOfDays, null, 0, false, true);
$output .= $retval[1];
if ($ts->determineIfItemIsInLockRangeByDateStamp($startStamp, $emp)) {
$output .= $ts->generateTableFooter(true, $retval[2], $retval[3], $retval[4], $retval[5], $ts->determineIfItemIsInLockRangeByDateStamp($startStamp, $emp));
} else {
$output .= $ts->generateTableFooter(false, $retval[2], $retval[3], $retval[4], $retval[5], $ts->determineIfItemIsInLockRangeByDateStamp($startStamp, $emp));
}
$output .= $ts->generateTotalRowCount($retval[0]);
}
$T->set_var('approval_rows', $output);
$T->set_var('approval_all_table_style', 'display:none');
$T->set_var('approved_by', $_USER['uid']);
$T->set_var('userinformation_table_style', '');
//using $emp, we generate the top information table
$T->set_var('emp_sup', $ts->getUserFullName($ts->getSupervisorUID($emp)));
$T->set_var('emp_number', $ts->getEmployeeNumber($emp));
$T->set_var('emp_name', $ts->getUserFullName($emp));
} else {
//show as line items
$output = $ts->generateApprovalTimesheetRows($uid, $emp, false, $hideapproved);
$T->set_var('approval_rows', $output[1]);
$T->set_var('approval_all_table_style', '');
$T->set_var('userinformation_table_style', 'display:none;');
}
} else {
//all timesheets that this user can see
if ($sup > 0) {
$output = $ts->generateApprovalTimesheetRows($sup, 0, false, $hideapproved, true);
} else {
$output = $ts->generateApprovalTimesheetRows($uid, 0, false, $hideapproved, false);
