require_once "Spreadsheet/Excel/Writer.php"; $cache = get_cache_function($unit->get_id(), CACHE_LIFETIME_STATIC); $participant_group = $unit->get_attribute("UNIT_POINTLIST_PARTICIPANTS"); $proxy = $unit->get_attribute("UNIT_POINTLIST_PROXY"); if (defined("LOG_DEBUGLOG")) { $time1 = microtime(TRUE); $login = lms_steam::get_current_user()->get_name(); logging::write_log(LOG_DEBUGLOG, "units_pointlist_excel:\t " . $login . "\t" . $unit->get_display_name() . "\t" . $participant_group->get_identifier() . "\t" . $participant_group->count_members() . "\t" . date("d.m.y G:i:s", time()) . "... "); } $members = $cache->call("lms_steam::group_get_members", $participant_group->get_id(), TRUE); // INITIALIZATION $course_id = $course->get_course_id(); $course_name = $course->get_course_name(); $semester = $course->get_semester(); $proxy_data = $proxy->get_all_attributes(); $points = units_pointlist::extract_pointlist($proxy_data); $maxpoints = $proxy_data["UNIT_POINTLIST_MAXPOINTS"]; $count = $unit->get_attribute("UNIT_POINTLIST_COUNT"); $bonus_1 = $unit->get_attribute("UNIT_POINTLIST_BONUS_1"); $bonus_2 = $unit->get_attribute("UNIT_POINTLIST_BONUS_2"); $unit_name = $unit->get_display_name(); $excel = new Spreadsheet_Excel_Writer(); $excel->setTempDir(PATH_TEMP); $format_table_header =& $excel->addFormat(array('Size' => 12, 'Align' => 'left', 'Bold' => 1)); $format_table_header_number =& $excel->addFormat(array('Size' => 12, 'Align' => 'right', 'Bold' => 1)); $sheet_table_header =& $excel->addFormat(array('Size' => 14, 'Align' => 'left')); $format_table_header =& $excel->addFormat(array('Size' => 12, 'Align' => 'left', 'Bold' => 1)); $format_table_header_faded =& $excel->addFormat(array('Size' => 12, 'Align' => 'left', 'Color' => 'grey')); $format_cell =& $excel->addFormat(array('Size' => 9, 'Align' => 'left', 'Bold' => 1)); $format_cell->setAlign('vcenter'); $format_cell->setTextWrap(1);