$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);