} else { $lektor = null; } // Link fuer den Export $export_link = 'zeitsperre_days.php?format=xls&'; $export_param = ''; if (!is_null($days)) { $export_param .= ($export_param != '' ? '&' : '') . "days={$days}"; } if (!is_null($lektor)) { $export_param .= ($export_param != '' ? '&' : '') . "lektor={$lektor}"; } $export_link .= $export_param; $datum_beginn = date('Y-m-d'); $ts_beginn = $datum_obj->mktime_fromdate($datum_beginn); $ts_ende = $datum_obj->jump_day($ts_beginn, $days); $datum_ende = date('Y-m-d', $ts_ende); // Lektoren holen $ma = new mitarbeiter(); $mitarbeiter = $ma->getMitarbeiterZeitsperre($datum_beginn, $datum_ende, $lektor); if (isset($_REQUEST['format']) && $_REQUEST['format'] == 'xls') { // Creating a workbook $workbook = new Spreadsheet_Excel_Writer(); // sending HTTP headers $workbook->send($p->t('zeitsperre/zeitsperren') . ".xls"); $workbook->setVersion(8); // Creating a worksheet $worksheet =& $workbook->addWorksheet($p->t('zeitsperre/zeitsperren')); $worksheet->setInputEncoding('utf-8'); $worksheet->setZoom(85); $worksheet->freezePanes(array(1, 0, 1, 0));