} foreach ($result as $row) { foreach ($columns as $col) { $array[$j][] = strip_tags($row[$col]); } $j++; } switch ($exportFormat) { case 'xls': //TODO add date if exists $file_name = !empty($action) ? $action : 'company_report'; $browser = new Browser(); if ($browser->getPlatform() == Browser::PLATFORM_WINDOWS) { Export::export_table_xls_html($array, $file_name, 'ISO-8859-15'); } else { Export::export_table_xls_html($array, $file_name); } break; case 'csv': default: //TODO add date if exists $file_name = !empty($action) ? $action : 'company_report'; Export::arrayToCsv($array, $file_name); break; } exit; } $i = 0; if (!empty($result)) { foreach ($result as $row) { // if results tab give not id, set id to $i otherwise id="null" for all <tr> of the jqgrid - ref #4235
$timeReport->data[] = array('coach' => array('username' => $teacher['username'], 'completeName' => $teacher['completeName']), 'totalTime' => SessionManager::getTotalUserTimeInPlatform($teacher['user_id'], $selectedFrom, $selectedUntil)); } } $timeReport->sortData($withFilter); if (isset($_GET['export'])) { $dataToExport = $timeReport->prepareDataToExport($withFilter); $fileName = get_lang('TeacherTimeReport') . ' ' . api_get_local_time(); switch ($_GET['export']) { case 'pdf': $params = array('add_signatures' => false, 'filename' => $fileName, 'pdf_title' => "{$reportTitle} - {$reportSubTitle}", 'pdf_description' => get_lang('TeacherTimeReport'), 'format' => 'A4-L', 'orientation' => 'L'); $pdfContent = Export::convert_array_to_html($dataToExport); Export::export_html_to_pdf($pdfContent, $params); break; case 'xls': array_unshift($dataToExport, array($reportTitle), array($reportSubTitle), array()); Export::export_table_xls_html($dataToExport, $fileName); break; } die; } $form->addSelect('course', get_lang('Course'), $optionsCourses, ['id' => 'courses']); $form->addSelect('session', get_lang('Session'), $optionsSessions, ['id' => 'session']); $form->addSelect('teacher', get_lang('Teacher'), $optionsTeachers, ['id' => 'teacher']); $form->addDateRangePicker('daterange', get_lang('Date'), false, ['id' => 'daterange', 'maxDate' => $limitDate->format('Y-m-d'), 'format' => 'YYYY-MM-DD', 'timePicker' => 'false', 'value' => "{$selectedFrom} / {$selectedUntil}"]); $form->addButtonFilter(get_lang('Filter')); $form->addHidden('from', ''); $form->addHidden('until', ''); $form->setDefaults(['course' => $selectedCourse, 'session' => $selectedSession, 'teacher' => $selectedTeacher, 'date_range' => "{$selectedFrom} / {$selectedUntil}", 'from' => $selectedFrom, 'until' => $selectedUntil]); $tpl = new Template($toolName); $tpl->assign('reportTitle', $reportTitle); $tpl->assign('reportSubTitle', $reportSubTitle);