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 -->
