[Summary view]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  namespace mod_data\local\exporter;
  18  
  19  use MoodleODSWorkbook;
  20  use MoodleODSWriter;
  21  
  22  /**
  23   * ODS entries exporter for mod_data.
  24   *
  25   * @package    mod_data
  26   * @copyright  2023 ISB Bayern
  27   * @author     Philipp Memmel
  28   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  29   */
  30  class ods_entries_exporter extends entries_exporter {
  31  
  32      /**
  33       * Returns the file extension of this entries exporter.
  34       *
  35       * @see \mod_data\local\exporter\entries_exporter::get_export_data_file_extension()
  36       */
  37      public function get_export_data_file_extension(): string {
  38          return 'ods';
  39      }
  40  
  41      /**
  42       * Returns the ods data exported by the ODS library for further handling.
  43       *
  44       * @see \mod_data\local\exporter\entries_exporter::get_data_file_content()
  45       */
  46      public function get_data_file_content(): string {
  47          global $CFG;
  48          require_once("$CFG->libdir/odslib.class.php");
  49          $filearg = '-';
  50          $workbook = new MoodleODSWorkbook($filearg);
  51          $worksheet = [];
  52          $worksheet[0] = $workbook->add_worksheet('');
  53          $rowno = 0;
  54          foreach ($this->exportdata as $row) {
  55              $colno = 0;
  56              foreach ($row as $col) {
  57                  $worksheet[0]->write($rowno, $colno, $col);
  58                  $colno++;
  59              }
  60              $rowno++;
  61          }
  62          $writer = new MoodleODSWriter($worksheet);
  63          return $writer->get_file_content();
  64      }
  65  }