PHP SemBrowse::create_result_xls Beispiele

Beispiel #1

Datei: courses.php Projekt: ratbird/hope

 public function export_results_action()
 {
     $sem_browse_obj = new SemBrowse();
     $tmpfile = basename($sem_browse_obj->create_result_xls());
     if ($tmpfile) {
         $this->redirect(getDownloadLink($tmpfile, _("ErgebnisVeranstaltungssuche.xls"), 4));
     } else {
         $this->render_nothing();
     }
 }

Beispiel #2

Datei: show_bereich.php Projekt: ratbird/hope

            array_unshift($parameters, $show_semester);
        } else {
            $query = "SELECT seminar_inst.seminar_id\n                  FROM seminar_inst\n                  LEFT JOIN seminare AS s ON (seminar_inst.seminar_id = s.Seminar_id)\n                  WHERE seminar_inst.Institut_id = ?";
        }
        if (!$GLOBALS['perm']->have_perm(get_config('SEM_VISIBILITY_PERM'))) {
            $query .= " AND s.visible = 1";
        }
        $statement = DBManager::get()->prepare($query);
        $statement->execute($parameters);
        $seminar_ids = $statement->fetchAll(PDO::FETCH_COLUMN);
        $sem_browse_obj->sem_browse_data['search_result'] = array_flip($seminar_ids);
        $sem_browse_obj->show_result = true;
        break;
}
if (Request::int('send_excel')) {
    $tmpfile = basename($sem_browse_obj->create_result_xls($excel_text));
    if ($tmpfile) {
        header('Location: ' . getDownloadLink($tmpfile, _("Veranstaltungsübersicht.xls"), 4));
        page_close();
        die;
    }
}
PageLayout::setHelpKeyword("Basis.Informationsseite");
PageLayout::setTitle(($level == "s" ? $SessSemName["header_line"] . " - " : "") . $head_text);
if ($level == "s" && $SessSemName[1] && $SessSemName["class"] == "inst") {
    Navigation::activateItem('/course/main/courses');
}
$sidebar = Sidebar::get();
$sidebar->setImage('sidebar/seminar-sidebar.png');
$semester = new SelectWidget(_("Semester:"), URLHelper::getURL(), 'select_sem');
foreach (array_reverse(Semester::getAll()) as $one) {