Exemple #1
0
 function renderXls()
 {
     $workbook = new Spreadsheet_Excel_Writer();
     // sending HTTP headers
     $workbook->send($this->getKursus()->getKursusNavn());
     // Creating a worksheet
     $worksheet =& $workbook->addWorksheet('Deltagere');
     $format_bold =& $workbook->addFormat();
     $format_bold->setBold();
     $format_bold->setSize(8);
     $format_italic =& $workbook->addFormat();
     $format_italic->setItalic();
     $format_italic->setSize(8);
     $format =& $workbook->addFormat();
     $format->setSize(8);
     $i = 0;
     $worksheet->write($i, 0, 'Vejle Idrætshøjskole: ' . $this->getKursus()->getKursusNavn(), $format_bold);
     $i = 2;
     foreach ($this->getKursus()->getDeltagere() as $deltager) {
         $worksheet->write($i, 0, $deltager->get('navn'), $style);
         $worksheet->write($i, 1, $deltager->get('cpr'), $style);
         $i++;
     }
     $worksheet->hideGridLines();
     // Let's send the file
     $data = $workbook->close();
     $response = new k_http_Response(200, $data);
     $response->setEncoding(NULL);
     $response->setContentType("application/excel");
     /*
     $response->setHeader("Content-Length", strlen($data));
     $response->setHeader("Content-Disposition", "attachment;filename=\"\"");
     $response->setHeader("Content-Transfer-Encoding", "binary");
     $response->setHeader("Cache-Control", "Public");
     $response->setHeader("Pragma", "public");
     */
     throw $response;
 }
 function GET()
 {
     $color = array('body' => 'black', 'caption' => '#ddd', 'container' => 'black', 'navigation_main' => '#D61031');
     $margin['default'] = '30px';
     $margin['left'] = '40px';
     $pics = array($this->url('/gfx/images/widepics/hangingout1.jpg'));
     $data = array('color' => $color, 'margin' => $margin, 'image_url' => $this->url('/gfx/') . '/', 'pics' => $pics);
     $data = $this->render(dirname(__FILE__) . '/templates/css.tpl.php', $data);
     $response = new k_http_Response(200, $data);
     $response->setEncoding(NULL);
     $response->setContentType('text/css');
     $response->setHeader('Content-Length', strlen($data));
     $response->setHeader('Content-Transfer-Encoding', 'binary');
     $response->setHeader('Cache-Control', 'Public');
     $response->setHeader('Pragma', 'public');
     throw $response;
 }