'univercity' => 'univercity', 'univercityyear' => 'univercityyear', 'schoolname' => 'schoolname', 'programname' => 'programname', 'typeofapplication' => 'typeofapplication', 'status' => 'status', 'semname' => 'semname', 'dateofapplication' => 'dateofapplication', 'typeofprogram' => 'typeofprogram', 'applicationid' => 'applicationid' ); switch ($format) { case 'xls' : user_download_xls($fields); } die; } echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('dd', 'local_cobaltcourses')); echo $OUTPUT->box_start(); echo '<ul>'; echo '<li><a href="download_all.php?format=xls">' . get_string('downloadexcel') . '</a></li>'; echo '</ul>'; echo $OUTPUT->box_end(); echo $OUTPUT->footer(); function user_download_xls($fields) { $admission = cobalt_admission::get_instance();
} else { $departmentids .= $departmentuser->userid; } } $sqlsearch = " AND userid in ({$departmentids}) "; } else { $sqlsearch = "AND 1 = 0"; } $userids = $DB->get_records_sql_menu("SELECT userid, userid as id\n FROM\n {company_users}\n WHERE\n companyid = :companyid\n " . $sqlsearch, $params); switch ($format) { case 'csv': user_download_csv($userids, $fields, !$companyid); case 'ods': user_download_ods($userids, $fields, !$companyid); case 'xls': user_download_xls($userids, $fields, !$companyid); } die; } echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('download', 'admin')); // Get url of ourselves. $url = new moodle_url('/blocks/iomad_company_admin/user_bulk_download.php', array('companyid' => $companyid)); // Show download options menu. echo $OUTPUT->box_start(); echo '<ul>'; echo '<li><a href="' . $url->out(true, array('format' => 'csv')) . '">' . get_string('downloadtext') . '</a></li>'; echo '<li><a href="' . $url->out(true, array('format' => 'ods')) . '">' . get_string('downloadods') . '</a></li>'; echo '<li><a href="' . $url->out(true, array('format' => 'xls')) . '">' . get_string('downloadexcel') . '</a></li>'; echo '</ul>'; echo $OUTPUT->box_end();
redirect($return); } if ($format) { $fields = array('id' => 'id', 'username' => 'username', 'email' => 'email', 'firstname' => 'firstname', 'lastname' => 'lastname', 'idnumber' => 'idnumber', 'institution' => 'institution', 'department' => 'department', 'phone1' => 'phone1', 'phone2' => 'phone2', 'city' => 'city', 'url' => 'url', 'icq' => 'icq', 'skype' => 'skype', 'aim' => 'aim', 'yahoo' => 'yahoo', 'msn' => 'msn', 'country' => 'country'); if ($extrafields = $DB->get_records('user_info_field')) { foreach ($extrafields as $n => $v) { $fields['profile_field_' . $v->shortname] = 'profile_field_' . $v->shortname; } } switch ($format) { case 'csv': user_download_csv($fields); case 'ods': user_download_ods($fields); case 'xls': user_download_xls($fields); } die; } echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('download', 'admin')); echo $OUTPUT->box_start(); echo '<ul>'; echo '<li><a href="user_bulk_download.php?format=csv">' . get_string('downloadtext') . '</a></li>'; echo '<li><a href="user_bulk_download.php?format=ods">' . get_string('downloadods') . '</a></li>'; echo '<li><a href="user_bulk_download.php?format=xls">' . get_string('downloadexcel') . '</a></li>'; echo '</ul>'; echo $OUTPUT->box_end(); echo $OUTPUT->continue_button($return); echo $OUTPUT->footer(); function user_download_ods($fields)
// redirect($return); // } if ($format) { $fields = array('id' => 'id', 'username' => 'username', 'email' => 'email', 'firstname' => 'firstname', 'lastname' => 'lastname', 'idnumber' => 'idnumber', 'institution' => 'institution', 'phone1' => 'phone1', 'phone2' => 'phone2', 'city' => 'city', 'url' => 'url', 'icq' => 'icq', 'skype' => 'skype', 'aim' => 'aim', 'yahoo' => 'yahoo', 'msn' => 'msn', 'country' => 'country'); if ($extrafields = $DB->get_records('user_info_field')) { foreach ($extrafields as $n => $v) { $fields['profile_field_' . $v->shortname] = 'profile_field_' . $v->shortname; } } switch ($format) { case 'csv': user_download_csv($fields, $extrafields); case 'ods': user_download_ods($fields, $extrafields); case 'xls': user_download_xls($fields, $extrafields); } die; } echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('download', 'admin')); echo $OUTPUT->box_start(); echo '<ul>'; echo '<li><a href="user_bulk_download_list.php?format=csv">' . get_string('downloadtext') . '</a></li>'; echo '<li><a href="user_bulk_download_list.php?format=ods">' . get_string('downloadods') . '</a></li>'; echo '<li><a href="user_bulk_download_list.php?format=xls">' . get_string('downloadexcel') . '</a></li>'; echo '</ul>'; echo $OUTPUT->box_end(); echo $OUTPUT->continue_button($return); echo $OUTPUT->footer(); function user_download_ods($fields, $extrafields = array())