123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193 |
- <?php
- /* See license terms in /license.txt */
- /**
- * This is the export library for Chamilo.
- * Include/require it in your code to use its functionality.
- *
- * Several functions below are adaptations from functions distributed by www.nexen.net
- *
- * @package chamilo.library
- */
- /**
- * Code
- */
- require_once 'document.lib.php';
- require_once api_get_path(LIBRARY_PATH).'pdf.lib.php';
- /**
- *
- * @package chamilo.library
- */
- class Export {
- private function __construct() {
- }
- /**
- * Export tabular data to CSV-file
- * @param array $data
- * @param string $filename
- */
- public static function export_table_csv ($data, $filename = 'export') {
- $file = api_get_path(SYS_ARCHIVE_PATH).uniqid('').'.csv';
- $handle = @fopen($file, 'a+');
- if(is_array($data)) {
- foreach ($data as $index => $row) {
- $line = '';
- if(is_array($row)) {
- foreach($row as $value) {
- $line .= '"'.str_replace('"', '""', $value).'";';
- }
- }
- @fwrite($handle, $line."\n");
- }
- }
- @fclose($handle);
- DocumentManager :: file_send_for_download($file, true, $filename.'.csv');
- return false;
- }
- /**
- * Export tabular data to XLS-file
- * @param array $data
- * @param string $filename
- */
- public static function export_table_xls ($data, $filename = 'export') {
- $file = api_get_path(SYS_ARCHIVE_PATH).uniqid('').'.xls';
- $handle = @fopen($file, 'a+');
- foreach ($data as $index => $row) {
- @fwrite($handle, implode("\t", $row)."\n");
- }
- @fclose($handle);
- DocumentManager :: file_send_for_download($file, true, $filename.'.xls');
- return false;
- }
- /**
- * Export tabular data to XML-file
- * @param array Simple array of data to put in XML
- * @param string Name of file to be given to the user
- * @param string Name of common tag to place each line in
- * @param string Name of the root element. A root element should always be given.
- * @param string Encoding in which the data is provided
- */
- public static function export_table_xml ($data, $filename = 'export', $item_tagname = 'item', $wrapper_tagname = null, $encoding = null) {
- if (empty($encoding)) {
- $encoding = api_get_system_encoding();
- }
- $file = api_get_path(SYS_ARCHIVE_PATH).'/'.uniqid('').'.xml';
- $handle = fopen($file, 'a+');
- fwrite($handle, '<?xml version="1.0" encoding="'.$encoding.'"?>'."\n");
- if (!is_null($wrapper_tagname)) {
- fwrite($handle, "\t".'<'.$wrapper_tagname.'>'."\n");
- }
- foreach ($data as $index => $row) {
- fwrite($handle, '<'.$item_tagname.'>'."\n");
- foreach ($row as $key => $value) {
- fwrite($handle, "\t\t".'<'.$key.'>'.$value.'</'.$key.'>'."\n");
- }
- fwrite($handle, "\t".'</'.$item_tagname.'>'."\n");
- }
- if (!is_null($wrapper_tagname)) {
- fwrite($handle, '</'.$wrapper_tagname.'>'."\n");
- }
- fclose($handle);
- DocumentManager :: file_send_for_download($file, true, $filename.'.xml');
- return false;
- }
- /**
- * Export hierarchical tabular data to XML-file
- * @param array Hierarchical array of data to put in XML, each element presenting a 'name' and a 'value' property
- * @param string Name of file to be given to the user
- * @param string Name of common tag to place each line in
- * @param string Name of the root element. A root element should always be given.
- * @param string Encoding in which the data is provided
- * @return void Prompts the user for a file download
- */
- public static function export_complex_table_xml ($data, $filename = 'export', $wrapper_tagname, $encoding = 'ISO-8859-1') {
- $file = api_get_path(SYS_ARCHIVE_PATH).'/'.uniqid('').'.xml';
- $handle = fopen($file, 'a+');
- fwrite($handle, '<?xml version="1.0" encoding="'.$encoding.'"?>'."\n");
- if (!is_null($wrapper_tagname)) {
- fwrite($handle, '<'.$wrapper_tagname.'>');
- }
- $s = self::_export_complex_table_xml_helper($data);
- fwrite($handle,$s);
- if (!is_null($wrapper_tagname)) {
- fwrite($handle, '</'.$wrapper_tagname.'>'."\n");
- }
- fclose($handle);
- DocumentManager :: file_send_for_download($file, true, $filename.'.xml');
- return false;
- }
- /**
- * Helper for the hierarchical XML exporter
- * @param array Hierarhical array composed of elements of type ('name'=>'xyz','value'=>'...')
- * @param int Level of recursivity. Allows the XML to be finely presented
- * @return string The XML string to be inserted into the root element
- */
- public static function _export_complex_table_xml_helper ($data, $level = 1) {
- if (count($data)<1) { return '';}
- $string = '';
- foreach ($data as $index => $row) {
- $string .= "\n".str_repeat("\t",$level).'<'.$row['name'].'>';
- if (is_array($row['value'])) {
- $string .= self::_export_complex_table_xml_helper($row['value'],$level+1)."\n";
- $string .= str_repeat("\t",$level).'</'.$row['name'].'>';
- } else {
- $string .= $row['value'];
- $string .= '</'.$row['name'].'>';
- }
- }
- return $string;
- }
- public static function export_table_pdf($data, $file_name = 'export', $header, $description, $params = array()) {
- $headers = $data[0];
- unset($data[0]);
- $html = '';
-
- $headers_in_pdf = '<img width="150px" src="'.api_get_path(WEB_CSS_PATH).api_get_setting('stylesheets').'/images/header-logo.png">';
-
- $html = '<br/><table width="100%" cellspacing="1" cellpadding="5" border="0">
- <tr><td width="100%" style="text-align: center;" class="title" colspan="4"><h1>'.$header.'</h1></td></tr></table><br />';
- $html .= $description.'<br />';
-
- $table = new HTML_Table(array('class' => 'data_table', 'repeat_header' => '1'));
- $row = 0;
- $column = 0;
- foreach ($headers as $header) {
- $table->setHeaderContents($row, $column, $header);
- $column++;
- }
- $row++;
-
- foreach ($data as &$printable_data_row) {
- $column = 0;
- foreach ($printable_data_row as &$printable_data_cell) {
- $table->setCellContents($row, $column, $printable_data_cell);
- //$table->updateCellAttributes($row, $column);
- $column++;
- }
- $table->updateRowAttributes($row, $row % 2 ? 'class="row_even"' : 'class="row_odd"', true);
- $row++;
- }
-
- $html .= $table->toHtml();
- $html = api_utf8_encode($html);
-
- $css_file = api_get_path(TO_SYS, WEB_CSS_PATH).'/print.css';
- $css = file_exists($css_file) ? @file_get_contents($css_file) : '';
-
- $pdf = new PDF('A4', 'P', $params);
- $pdf->set_custom_header($headers_in_pdf);
- $pdf->content_to_pdf($html, $css, $file_name, api_get_course_id());
- exit;
- }
- }
|