function _moduleContent(&$smarty, $module_name) { //global variables global $arrConf; global $arrConfModule; $arrConf = array_merge($arrConf, $arrConfModule); //folder path for custom templates $local_templates_dir = getWebDirModule($module_name); switch (getParameter('action')) { case 'csvdownload': return download_csv($smarty); default: return display_form($smarty, $module_name, $local_templates_dir); } }
require_once(C_LIB_PATH.'lib_div.php'); require_once(C_LIB_PATH.'lib_sel_area.php'); require_once(C_INC_PATH.'common.php'); $gc->db = new DataBaseClass(); $gc->db->connect(C_DB_SERVER, C_DB_USERNAME, C_DB_PASSWORD, C_DB_DATABASE, C_DB_CHARACTER); $gc->db->err_log_file = C_LOG_PATH.C_DB_ERR_FILE; if(!fdb_company_login_check($gc)){ header("Location: ".C_CADMIN_URL."login.php"); exit(0); } $dl_ret = download_csv($gc); if($dl_ret){ exit(0); } header("Content-Type: text/html;charset=UTF-8"); out_html($gc); $gc->db->disconnect(); //////////////////////////////////////////////////////////////////////////////// function download_csv($gc) { $crlf = "\r\n";
// CPD Report headers $columns = array('objective' => get_string('objective', 'report_cpd'), 'development_need' => get_string('developmentneed', 'report_cpd'), 'activity_type' => get_string('activitytype', 'report_cpd'), 'activity' => get_string('activity', 'report_cpd'), 'due_date' => get_string('datedue', 'report_cpd'), 'start_date' => get_string('datestart', 'report_cpd'), 'end_date' => get_string('dateend', 'report_cpd'), 'status' => get_string('status', 'report_cpd'), 'timetaken' => get_string('timetaken', 'report_cpd')); if (!empty($download) || !empty($print)) { // Filter object $filter_data = new stdClass(); $filter_data->cpdyearid = $cpdyearid; $filter_data->filterbydate = optional_param('filterbydate', null, PARAM_BOOL); $filter_data->from = optional_param('from', null, PARAM_INT); $filter_data->to = optional_param('to', null, PARAM_INT); $filter_data->userid = $USER->id; if (($cpd_records = get_cpd_records($filter_data)) && !empty($download)) { // Add disclaimer $cpd_records[] = array(); $cpd_records[] = array(get_string('confirmstatement', 'report_cpd') . ':', ''); $cpd_records[] = array(get_string('date') . ':', ''); download_csv('cpd_record', $columns, $cpd_records); exit; } } else { $columns['edit'] = get_string('edit'); $columns['delete'] = get_string('delete'); } $cpd_years = get_cpd_menu('years'); $userid = $USER->id; $filter = new cpd_filter_form('index.php', compact('cpd_years', 'userid'), 'post', '', array('class' => 'cpdfilter')); if (empty($cpd_records)) { $filter_data = $filter->get_data(); if (empty($filter_data)) { // Filter object $filter_data = new stdClass(); $filter_data->userid = $USER->id;
* LMT/Backstage/Checkin/Home.php * LHS Math Club Website * * A dashboard page for staff running checkin */ require_once '../../../.lib/lmt-functions.php'; backstage_access(); lmt_page_header('Check-in'); if (isset($_GET['SCH_ID'])) { find_school($_GET['SCH_ID']); } else { if (isset($_GET['IND_ID'])) { find_individual($_GET['IND_ID']); } else { if (isset($_GET['Download'])) { download_csv(); } } } function download_csv() { // Get Data $file = "Team ID,Team Name,School\n"; $result = DB::queryRaw('SELECT team_id, teams.name AS team_name, schools.name AS school_name FROM teams ' . 'LEFT JOIN schools ON teams.school=schools.school_id WHERE teams.deleted="0" ORDER BY team_id'); $row = mysqli_fetch_assoc($result); while ($row) { $id = htmlentities($row['team_id']); $team_name = htmlentities($row['team_name']); $school_name = htmlentities($row['school_name']); if ($school_name == '') { $school_name = 'None';
print_r($data[0][0]); echo '</table>'; echo '<table class="table">'; print_r($data[1][0]); echo '</table>'; echo '<br>'; echo '<table class="table">'; print_r($data[2][0]); echo '</table>'; parse_top_10($data, $etf); } } $etf = strtoupper($etf); $file = file_get_contents("csv/" . $etf . ".csv"); if (empty($file)) { download_csv($etf); } if (empty($data['error'])) { echo '<a href="csv/' . $etf . '.csv">Download csv format ' . $etf . '</a>'; } //no file - no link //class container echo '</div>'; } //get data } } //if else ?> </div> <!-- Latest compiled and minified JavaScript -->