$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));
//Formate Definieren
$format_header =& $workbook->addFormat();
$format_header->setBold();
$format_header->setAlign("center");
