$objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $output); break; case 'nextime_activity_id': $output = nexlistValue($CONF_NEXTIME['nexlist_nextime_activities'], $XX['nextime_activity_id'], 0); $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $output); break; case 'project_id': $output = nexlistValue($CONF_NEXTIME['nexlist_nextime_projects'], $XX['project_id'], 1); $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $output); break; case 'task_id': $output = nexlistValue($CONF_NEXTIME['nexlist_timesheet_tasks'], $XX['task_id'], 1); $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $output); break; case 'total_reg_hours': $output = $ts->getTotalHRSFromID($XX['id']); $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $output == 0 ? '' : $output); break; default: $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter, $XX[$key] == 0 ? '' : $XX[$key]); break; } $objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); if ($key == 'total_reg_hours') { $objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getFont()->setBold(true); } if ($colnum >= 7 || $colnum <= 20) { $objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); } if ($key == 'standby') { $objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getNumberFormat()->setFormatCode('"$"#0_-');
//now cycle thrue each of these.. $taskcount = 1; $startingRowCount = $rowCounter; while ($X = DB_fetchArray($perUserRes)) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $rowCounter, date('l', $X['datestamp'])); $objPHPExcel->getActiveSheet()->setCellValue('B' . $rowCounter, date('Y/m/d', $X['datestamp'])); $objPHPExcel->getActiveSheet()->setCellValue('C' . $rowCounter, $taskcount); //and now for each column, starting at offset 5 $colcount = 0; $xlscol = 4; //column d foreach ($LANG_NEXTIME_REPORT_COLUMNS as $dbcol => $name) { if ($colcount > 3) { //skip out 0-4 if ($dbcol == 'total_reg_hours') { $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$xlscol] . $rowCounter, $ts->getTotalHRSFromID($X['id'])); } else { $objPHPExcel->getActiveSheet()->setCellValue($CONF_NEXTIME['report_columns'][$xlscol] . $rowCounter, $X[$dbcol]); } $xlscol += 1; } $colcount += 1; } $taskcount += 1; $rowCounter += 1; } $endRowCounter = $rowCounter - 1; //give a totals line.... //totals line goes from $startingRowCount to $endRowCounter $colcount = 0; $xlscol = 4;