user_model->authorize(2)) { $this->session->set_flashdata('error', __("You're not allowed to do that!")); redirect('dashboard'); } $map_custom = json_decode($this->optionslib->get_map_custom()); $this->user_map_color_qso = $map_custom->qso->color ?? ''; $this->user_map_color_qsoconfirm = $map_custom->qsoconfirm->color ?? ''; $this->user_map_color_unworked = $map_custom->unworked->color ?? ''; } public function index() { // Render Page $data['page_title'] = __("Awards"); $this->load->view('interface_assets/header', $data); $this->load->view('awards/index'); $this->load->view('interface_assets/footer'); } public function dok () { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $this->load->model('dok'); $this->load->model('bands'); $this->load->model('modes'); if($this->input->method() === 'post') { $postdata['doks'] = $this->security->xss_clean($this->input->post('doks')); } else { $postdata['doks'] = 'both'; } $data['worked_bands'] = $this->bands->get_worked_bands('dok'); $data['modes'] = $this->modes->active(); if ($this->input->post('band') != NULL) { if ($this->input->post('band') == 'All') { $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['clublog'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $data['dok_array'] = $this->dok->get_dok_array($bands, $postdata, $location_list); $data['dok_summary'] = $this->dok->get_dok_summary($bands, $postdata, $location_list); } else { $location_list = null; $data['dok_array'] = null; $data['dok_summary'] = null; } // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("DOK")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/dok/index'); $this->load->view('interface_assets/footer'); } public function dxcc () { $this->load->model('dxcc'); $this->load->model('modes'); $this->load->model('bands'); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $data['orbits'] = $this->bands->get_worked_orbits(); $data['sats_available'] = $this->bands->get_worked_sats(); $data['user_default_band'] = $this->session->userdata('user_default_band'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('dxcc'); // Used in the view for band select $data['modes'] = $this->modes->active(); // Used in the view for mode select $data['adif_propmodes'] = $this->config->item('adif_propmodes'); if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['includedeleted'] = ($this->input->post('includedeleted',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sats')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbits')); $postdata['prop_mode'] = $this->security->xss_clean($this->input->post('prop_mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = NULL; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['sat'] = 'All'; $postdata['orbit'] = 'All'; $postdata['prop_mode'] = 'All'; $postdata['dateFrom'] = null; $postdata['dateTo'] = null; } if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $dxcclist = $this->dxcc->fetchdxcc($postdata, $location_list); if ($dxcclist && $dxcclist[0]->adif == "0") { unset($dxcclist[0]); } $dxcc_result = $this->dxcc->get_dxcc_array($dxcclist, $bands, $postdata, $location_list); // Extract bands data and summary from the result $data['dxcc_array'] = ($dxcc_result && isset($dxcc_result['matrix'])) ? $dxcc_result['matrix'] : null; $data['dxcc_summary'] = ($dxcc_result && isset($dxcc_result['summary'])) ? $dxcc_result['summary'] : null; $data['dxcc_continent_summary'] = ($dxcc_result && isset($dxcc_result['continent_summary'])) ? $dxcc_result['continent_summary'] : null; } else { $location_list = null; $data['dxcc_array'] = null; $data['dxcc_summary'] = null; $data['dxcc_continent_summary'] = null; } // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("DXCC")); $data['posted_band'] = $postdata['band']; $this->load->view('interface_assets/header', $data); $this->load->view('awards/dxcc/index'); $this->load->view('interface_assets/footer'); } public function dxcc_progress() { try { $this->load->model('dxcc'); $this->load->model('bands'); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); // Get posted data if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['includedeleted'] = ($this->input->post('includedeleted',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sat')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbit')); $postdata['prop_mode'] = $this->security->xss_clean($this->input->post('prop_mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); } else { // Default values $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = NULL; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['sat'] = 'All'; $postdata['orbit'] = 'All'; $postdata['prop_mode'] = 'All'; $postdata['dateFrom'] = null; $postdata['dateTo'] = null; } // Get bands if ($this->input->post('band') != NULL) { if ($this->input->post('band') == 'All') { $bands = $this->bands->get_worked_bands('dxcc'); } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $this->bands->get_worked_bands('dxcc'); } // Fetch mode progress $total_dxcc_entities = $this->dxcc->countDxccEntities($postdata); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $dxcc_mode_summary = $this->dxcc->mode_progress($total_dxcc_entities, $postdata, $location_list); } else { $dxcc_mode_summary = null; } // Generate HTML $html = ''; if ($dxcc_mode_summary) { $data['dxcc_mode_summary'] = $dxcc_mode_summary; $html = $this->load->view('awards/dxcc/progress', $data, true); $this->output ->set_content_type('application/json') ->set_output(json_encode(['success' => true, 'html' => $html])); } else { $this->output ->set_content_type('application/json') ->set_output(json_encode(['success' => true, 'html' => ''])); } } catch (Exception $e) { $this->output ->set_content_type('application/json') ->set_output(json_encode(['success' => false, 'message' => $e->getMessage()])); } } public function wapc () { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wapcmap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('wapc'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('wapc'); $data['modes'] = $this->modes->active(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['includedeleted'] = $this->security->xss_clean($this->input->post('includedeleted')); $postdata['Africa'] = $this->security->xss_clean($this->input->post('Africa')); $postdata['Asia'] = $this->security->xss_clean($this->input->post('Asia')); $postdata['Europe'] = $this->security->xss_clean($this->input->post('Europe')); $postdata['NorthAmerica'] = $this->security->xss_clean($this->input->post('NorthAmerica')); $postdata['SouthAmerica'] = $this->security->xss_clean($this->input->post('SouthAmerica')); $postdata['Oceania'] = $this->security->xss_clean($this->input->post('Oceania')); $postdata['Antarctica'] = $this->security->xss_clean($this->input->post('Antarctica')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['clublog'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = 0; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['wapc_array'] = $this->wapc->get_wapc_array($bands, $postdata); $data['wapc_summary'] = $this->wapc->get_wapc_summary($bands, $postdata); // Render Page $data['page_title'] =__( "Awards - WAPC"); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wapc/index'); $this->load->view('interface_assets/footer', $footerData); } public function waja () { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wajamap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('waja'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('waja'); $data['modes'] = $this->modes->active(); if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['includedeleted'] = $this->security->xss_clean($this->input->post('includedeleted')); $postdata['Africa'] = $this->security->xss_clean($this->input->post('Africa')); $postdata['Asia'] = $this->security->xss_clean($this->input->post('Asia')); $postdata['Europe'] = $this->security->xss_clean($this->input->post('Europe')); $postdata['NorthAmerica'] = $this->security->xss_clean($this->input->post('NorthAmerica')); $postdata['SouthAmerica'] = $this->security->xss_clean($this->input->post('SouthAmerica')); $postdata['Oceania'] = $this->security->xss_clean($this->input->post('Oceania')); $postdata['Antarctica'] = $this->security->xss_clean($this->input->post('Antarctica')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['clublog'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = 0; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['waja_array'] = $this->waja->get_waja_array($bands, $postdata); $data['waja_summary'] = $this->waja->get_waja_summary($bands, $postdata); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render Page $data['page_title'] =__( "Awards - WAJA"); $this->load->view('interface_assets/header', $data); $this->load->view('awards/waja/index'); $this->load->view('interface_assets/footer', $footerData); } /** * JCC Award Main Page. */ public function jcc() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/jcc.js', 'assets/js/sections/jccmap.js' ]; $this->load->helper('awards'); $this->load->model('jcc_model'); $this->load->model('modes'); $this->load->model('bands'); if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['notworked'] = ($this->input->post('notworked', true) ?? 0) == 0 ? null : 1; $postdata['includedeleted'] = ($this->input->post('includedeleted', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->input->post('band', true) ?? 'All'; $postdata['mode'] = $this->input->post('mode', true) ?? 'All'; $postdata['prop_mode'] = $this->input->post('prop_mode', true) ?? 'All'; } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 1; $postdata['qrz'] = null; $postdata['clublog'] = null; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = null; $postdata['includedeleted'] = null; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['prop_mode'] = 'All'; } $data['postdata'] = $postdata; $data['worked_bands'] = $this->bands->get_worked_bands('jcc'); $data['modes'] = $this->modes->active(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // If "All" is selected, show all bands that have been worked. Otherwise, just the selected band. if ($postdata['band'] == 'All') { $bands = $data['worked_bands']; } else { $bands = [$postdata['band']]; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view // Query the database for JCC status $jcc_entity_status = $this->jcc_model->query_entity_status($postdata, 'band'); $data['jcc_array'] = $this->jcc_model->get_jcc_array($bands, $postdata, $jcc_entity_status); $data['jcc_summary'] = $this->jcc_model->get_jcc_summary($bands, $postdata, $jcc_entity_status); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("JCC")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/jcc/index'); $this->load->view('interface_assets/footer', $footerData); } /** * Export JCC QSOs as CSV for Award Application */ public function jcc_export() { $this->load->model('Jcc_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['includedeleted'] = ($this->input->post('includedeleted', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->input->post('band', true) ?? 'All'; $postdata['mode'] = $this->input->post('mode', true) ?? 'All'; $postdata['prop_mode'] = $this->input->post('prop_mode', true) ?? 'All'; $qsos = $this->Jcc_model->get_jcc_export($postdata); $fp = fopen( 'php://output', 'w' ); $i=1; fputcsv($fp, array('No', 'Callsign', 'Date', 'Band', 'Mode', 'Remarks'), escape: '\\'); foreach ($qsos as $qso) { fputcsv($fp, array( $i, $qso['COL_CALL'], $qso['COL_TIME_ON'], $qso['COL_BAND'] . ($qso['COL_PROP_MODE'] ? (' / ' . $qso['COL_PROP_MODE']) : ''), $qso['COL_MODE'], $qso['entity'] . ' - ' . $qso['entity_name'] ), escape: '\\'); $i++; } fclose($fp); return; } public function vucc() { $this->load->model('vucc'); $this->load->model('bands'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('vucc'); $data['vucc_array'] = $this->vucc->get_vucc_array($data); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("VUCC")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/vucc/index'); $this->load->view('interface_assets/footer'); } public function vucc_band(){ $this->load->model('vucc'); $band = str_replace('"', "", $this->security->xss_clean($this->input->get("Band"))); $type = str_replace('"', "", $this->security->xss_clean($this->input->get("Type"))); $data['vucc_array'] = $this->vucc->vucc_details($band, $type); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['type'] = $type; // Render Page $data['page_title'] = "VUCC - " .$band . " Band"; $data['filter'] = "band ".$band; $data['band'] = $band; $this->load->view('interface_assets/header', $data); $this->load->view('awards/vucc/band'); $this->load->view('interface_assets/footer'); } public function vucc_details_ajax(){ $this->load->model('logbook_model'); $gridsquare = str_replace('"', "", $this->security->xss_clean($this->input->post("Gridsquare"))); $band = str_replace('"', "", $this->security->xss_clean($this->input->post("Band"))); $data['results'] = $this->logbook_model->vucc_qso_details($gridsquare, $band); // Render Page $data['page_title'] = __("Log View - VUCC"); $data['filter'] = "vucc " . $gridsquare . " and band ".$band; $this->load->view('awards/details', $data); } /* * Used to fetch QSOs from the logbook in the awards */ public function qso_details_ajax() { $this->load->model('logbook_model'); $searchphrase = str_replace('"', "", $this->security->xss_clean($this->input->post("Searchphrase"))); $band = str_replace('"', "", $this->security->xss_clean($this->input->post("Band"))); $mode = str_replace('"', "", $this->security->xss_clean($this->input->post("Mode"))); $sat = str_replace('"', "", $this->security->xss_clean($this->input->post("Sat"))); $orbit = str_replace('"', "", $this->security->xss_clean($this->input->post("Orbit"))); $propagation = str_replace('"', "", $this->security->xss_clean($this->input->post("Propagation")) ?? ''); $type = $this->security->xss_clean($this->input->post('Type')); $qsl = $this->input->post('QSL') == null ? '' : $this->security->xss_clean($this->input->post('QSL')); $searchmode = $this->input->post('searchmode') == null ? '' : $this->security->xss_clean($this->input->post('searchmode')); $dateFrom = $this->security->xss_clean($this->input->post('dateFrom')); $dateTo = $this->security->xss_clean($this->input->post('dateTo')); $data['results'] = $this->logbook_model->qso_details($searchphrase, $band, $mode, $type, $qsl, $sat, $orbit, $searchmode, $propagation, $dateFrom, $dateTo); $data['adif_propmodes'] = $this->config->item('adif_propmodes'); // This is done because we have two different ways to get dxcc info in Wavelog. Once is using the name (in awards), and the other one is using the ADIF DXCC. // We replace the values to make it look a bit nicer if ($type == 'DXCC2') { $type = 'DXCC'; $dxccname = $this->logbook_model->get_entity($searchphrase); $searchphrase = $dxccname['name']; } $qsltype = []; if (strpos($qsl, "Q") !== false) { $qsltype[] = "QSL"; } if (strpos($qsl, "L") !== false) { $qsltype[] = "LoTW"; } if (strpos($qsl, "E") !== false) { $qsltype[] = "eQSL"; } if (strpos($qsl, "Z") !== false) { $qsltype[] = "QRZ.com"; } if (strpos($qsl, "C") !== false) { $qsltype[] = "Clublog"; } // Render Page $data['page_title'] = __("Log View")." - " . $type; $data['filter'] = (($type != $band) ? $type : '')." ".$searchphrase." ".__("and")." "; $data['filter'] .= ($band == 'All' ? lcfirst(__("Every band (w/o SAT)")) : __("band")." ".$band); if ($band == 'SAT') { if ($sat != 'All' && $sat != null) { $data['filter'] .= __(" and satellite ").$sat; } if ($orbit != 'All' && $orbit != null) { $data['filter'] .= __(" and orbit type ").$orbit; } } if ($propagation != '' && $propagation != null) { $data['filter'] .= __(" and propagation ").$propagation; } if ($mode != null && strtolower($mode) != 'all') { $data['filter'] .= __(" and mode ").strtoupper($mode); } if (!empty($qsltype)) { $data['filter'] .= __(" and ").implode('/', $qsltype); } $data['ispopup'] = true; $this->load->view('awards/details', $data); } /* Handles showing worked SOTAs Comment field - SOTA:# */ public function sota() { // Grab all worked sota stations $this->load->model('sota'); $this->load->model('bands'); $this->load->model('modes'); $data['sota_all'] = $this->sota->get_all(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('sota'); $data['modes'] = $this->modes->active(); // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("SOTA")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/sota/index'); $this->load->view('interface_assets/footer'); } public function sota_map() { $this->load->model('sota'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); $data = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $data = $this->sota->get_map_data($postdata, $location_list); } header('Content-Type: application/json'); echo json_encode($data); } public function sota_table() { $this->load->model('sota'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); if ($this->session->userdata('user_date_format')) { $date_format = $this->session->userdata('user_date_format'); } else { $date_format = $this->config->item('qso_date_format'); } $out = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $rows = $this->sota->get_qso_list($postdata, $location_list); foreach ($rows as $row) { $ts = strtotime($row->COL_TIME_ON); $out[] = [ '' . htmlspecialchars((string)$row->COL_SOTA_REF) . '', date($date_format, $ts), date('H:i', $ts), '' . htmlspecialchars((string)$row->COL_CALL) . '', ($row->COL_SAT_NAME != null) ? $row->COL_SAT_NAME : $row->COL_BAND, $row->COL_RST_SENT, $row->COL_RST_RCVD, ]; } } header('Content-Type: application/json'); echo json_encode(['data' => $out]); } /* Handles showing worked WWFFs Comment field - WWFF:# */ public function wwff() { // Grab all worked wwff stations $this->load->model('wwff'); $this->load->model('bands'); $this->load->model('modes'); $data['wwff_all'] = $this->wwff->get_all(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('wwff'); $data['modes'] = $this->modes->active(); // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("WWFF")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wwff/index'); $this->load->view('interface_assets/footer'); } public function wwff_map() { $this->load->model('wwff'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); $data = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $data = $this->wwff->get_map_data($postdata, $location_list); } header('Content-Type: application/json'); echo json_encode($data); } public function wwff_table() { $this->load->model('wwff'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); if ($this->session->userdata('user_date_format')) { $date_format = $this->session->userdata('user_date_format'); } else { $date_format = $this->config->item('qso_date_format'); } $out = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $rows = $this->wwff->get_qso_list($postdata, $location_list); foreach ($rows as $row) { $ts = strtotime($row->COL_TIME_ON); $out[] = [ '' . htmlspecialchars((string)$row->COL_WWFF_REF) . '', date($date_format, $ts), date('H:i', $ts), '' . htmlspecialchars((string)$row->COL_CALL) . '', ($row->COL_SAT_NAME != null) ? $row->COL_SAT_NAME : $row->COL_BAND, $row->COL_RST_SENT, $row->COL_RST_RCVD, ]; } } header('Content-Type: application/json'); echo json_encode(['data' => $out]); } /* Handles showing worked POTAs Comment field - POTA:# */ public function pota() { // Grab all worked pota stations $this->load->model('pota'); $this->load->model('bands'); $this->load->model('modes'); $data['pota_all'] = $this->pota->get_all(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('pota'); $data['modes'] = $this->modes->active(); $data['pota_award_tiers'] = $this->pota->award_tiers(); $data['pota_hunted_count'] = $this->pota->count_unique_references('COL_POTA_REF'); // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("POTA")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/pota/index'); $this->load->view('interface_assets/footer'); } public function pota_map() { $this->load->model('pota'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); $data = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $data = $this->pota->get_map_data($postdata, $location_list); } header('Content-Type: application/json'); echo json_encode($data); } public function pota_table() { $this->load->model('pota'); $this->load->model('logbooks_model'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); if ($this->session->userdata('user_date_format')) { $date_format = $this->session->userdata('user_date_format'); } else { $date_format = $this->config->item('qso_date_format'); } $out = []; $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array && $logbooks_locations_array[0] !== -1) { $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; $rows = $this->pota->get_qso_list($postdata, $location_list); foreach ($rows as $row) { $ts = strtotime($row->COL_TIME_ON); $dateCell = date($date_format, $ts); $timeCell = date('H:i', $ts); $callCell = '' . htmlspecialchars((string)$row->COL_CALL) . ''; $bandCell = ($row->COL_SAT_NAME != null) ? $row->COL_SAT_NAME : $row->COL_BAND; $rstSent = $row->COL_RST_SENT; $rstRcvd = $row->COL_RST_RCVD; // A QSO can carry several POTA references - emit one row per park foreach (explode(',', (string)$row->COL_POTA_REF) as $reference) { $reference = trim($reference); if ($reference === '') continue; $refCell = '' . htmlspecialchars($reference) . ''; $out[] = [ $refCell, $dateCell, $timeCell, $callCell, $bandCell, $rstSent, $rstRcvd, ]; } } } header('Content-Type: application/json'); echo json_encode(['data' => $out]); } public function cq() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/cqmap_geojson.js', 'assets/js/sections/cqmap.js' ]; $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('cq'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('cq'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['datefrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateto'] = $this->security->xss_clean($this->input->post('dateTo')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['datefrom'] = null; $postdata['dateto'] = null; } $data['posted_band'] = $postdata['band']; if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $cq_result = $this->cq->get_cq_array($bands, $postdata, $location_list); // Extract bands data and summary from the result $data['cq_array'] = ($cq_result && isset($cq_result['bands'])) ? $cq_result['bands'] : null; $data['cq_summary'] = ($cq_result && isset($cq_result['summary'])) ? $cq_result['summary'] : null; } else { $location_list = null; $data['cq_array'] = null; $data['cq_summary'] = null; } // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("CQ WAZ (Worked All Zones)")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/cq/index'); $this->load->view('interface_assets/footer', $footerData); } public function was() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wasmap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('was'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('was'); $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['was_array'] = $this->was->get_was_array($bands, $postdata); $data['was_summary'] = $this->was->get_was_summary($bands, $postdata); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("Worked All States (WAS)"));; $this->load->view('interface_assets/header', $data); $this->load->view('awards/was/index'); $this->load->view('interface_assets/footer', $footerData); } public function rac() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/racmap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('rac'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('rac'); $data['modes'] = $this->modes->active(); // Used in the view for mode select $data['user_map_custom'] = $this->optionslib->get_map_custom(); if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['rac_array'] = $this->rac->get_rac_array($bands, $postdata); $data['rac_summary'] = $this->rac->get_rac_summary($bands, $postdata); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("RAC")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/rac/index'); $this->load->view('interface_assets/footer', $footerData); } public function helvetia() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/helvetiamap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('helvetia_model'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('helvetia'); $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['helvetia_array'] = $this->helvetia_model->get_helvetia_array($bands, $postdata); $data['helvetia_summary'] = $this->helvetia_model->get_helvetia_summary($bands, $postdata); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render Page $data['page_title'] =sprintf(__("Awards - %s"), __("H26")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/helvetia/index'); $this->load->view('interface_assets/footer', $footerData); } public function iota () { $this->load->model('iota'); $this->load->model('modes'); $this->load->model('bands'); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array[0] === -1) { return null; } $data['user_map_custom'] = $this->optionslib->get_map_custom(); $location_list = "'".implode("','",$logbooks_locations_array)."'"; $data['worked_bands'] = $this->bands->get_worked_bands('iota'); // Used in the view for band select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view $data['modes'] = $this->modes->active(); // Used in the view for mode select if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['includedeleted'] = ($this->input->post('includedeleted',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')) ?? NULL; $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')) ?? NULL; } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = NULL; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $iotalist = $this->iota->fetchIota($postdata, $location_list); $data['iota_array'] = $this->iota->get_iota_array($iotalist, $bands, $postdata, $location_list); $data['iota_summary'] = $this->iota->get_iota_summary($bands, $postdata, $location_list); $data['posted_band']=$postdata['band']; // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("IOTA (Island On The Air)")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/iota/index'); $this->load->view('interface_assets/footer'); } public function counties() { $this->load->model('counties'); $data['counties_progress'] = $this->counties->get_counties_progress(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("US Counties")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/counties/index'); $this->load->view('interface_assets/footer'); } public function counties_list_ajax() { $this->load->model('counties'); $state = str_replace('"', "", $this->security->xss_clean($this->input->post("State"))); $type = str_replace('"', "", $this->security->xss_clean($this->input->post("Type"))); $data['counties_array'] = $this->counties->counties_details($state, $type); $data['type'] = $type; $this->load->view('awards/counties/details_ajax', $data); } public function counties_details_ajax() { $this->load->model('logbook_model'); $state = str_replace('"', "", $this->security->xss_clean($this->input->post("State"))); $county = str_replace('"', "", $this->security->xss_clean($this->input->post("County"))); $data['results'] = $this->logbook_model->county_qso_details($state, $county); $data['adif_propmodes'] = $this->config->item('adif_propmodes'); // Render Page $data['page_title'] = __("Log View - Counties"); $data['filter'] = "county " . $state; $this->load->view('awards/details', $data); } public function counties_state_ajax() { $this->load->model('counties'); $state = str_replace('"', "", $this->security->xss_clean($this->input->post("State"))); $data['counties_array'] = $this->counties->get_county_counts($state); $data['state'] = $state; $this->load->view('awards/counties/state_ajax', $data); } public function gridmaster($dxcc) { $dxcc = $this->security->xss_clean($dxcc); $data['page_title'] = __("Awards - ").strtoupper($dxcc)." Gridmaster"; $this->load->model('bands'); $this->load->model('gridmap_model'); $this->load->model('stations'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['homegrid']= explode(',', $this->stations->find_gridsquare()); $data['modes'] = $this->gridmap_model->get_worked_modes(); $data['bands']= $this->bands->get_worked_bands(); $data['sats_available']= $this->bands->get_worked_sats(); $data['layer']= $this->optionslib->get_option('option_map_tile_server'); $data['attribution']= $this->optionslib->get_option('option_map_tile_server_copyright'); $data['gridsquares_gridsquares']= __("Gridsquares"); $data['gridsquares_gridsquares_worked']= __("Gridsquares worked"); $data['gridsquares_gridsquares_lotw']= __("Gridsquares confirmed on LoTW"); $data['gridsquares_gridsquares_paper']= __("Gridsquares confirmed by paper QSL"); $data['gridsquares_total_gridsquares_worked']= __("Total Gridsquares worked"); $indexData['dxcc'] = $dxcc; $footerData = []; $footerData['scripts']= [ 'assets/js/leaflet/geocoding.js', 'assets/js/leaflet/L.MaidenheadColouredGridmasterMap.js', 'assets/js/sections/gridmaster.js' ]; $this->load->view('interface_assets/header',$data); $this->load->view('awards/gridmaster/index',$indexData); $this->load->view('interface_assets/footer',$footerData); } public function ffma() { $data['page_title'] = sprintf(__("Awards - %s"), __("Fred Fish Memorial Award (FFMA)")); $this->load->model('bands'); $this->load->model('ffma_model'); $this->load->model('stations'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['homegrid']= explode(',', $this->stations->find_gridsquare()); $data['layer']= $this->optionslib->get_option('option_map_tile_server'); $data['attribution']= $this->optionslib->get_option('option_map_tile_server_copyright'); $data['gridsquares_gridsquares']= __("Gridsquares"); $data['gridsquares_gridsquares_worked']= __("Gridsquares worked"); $data['gridsquares_gridsquares_lotw']= __("Gridsquares confirmed on LoTW"); $data['gridsquares_gridsquares_paper']= __("Gridsquares confirmed by paper QSL"); $data['gridsquares_total_gridsquares_worked']= __("Total Gridsquares worked"); $data['grid_count'] = $this->ffma_model->get_grid_count(); $data['grids'] = $this->ffma_model->get_grids(); $footerData = []; $footerData['scripts']= [ 'assets/js/leaflet/geocoding.js', 'assets/js/sections/ffma.js', 'assets/js/leaflet/L.MaidenheadColouredGridmasterMap.js' ]; $this->load->view('interface_assets/header',$data); $this->load->view('awards/ffma/index'); $this->load->view('interface_assets/footer',$footerData); } public function getFfmaGridsjs() { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $location_list = "'".implode("','",$logbooks_locations_array)."'"; $this->load->model('ffma_model'); $array_grid_4char = array(); $array_grid_4char_lotw = array(); $array_grid_4char_paper = array(); $grid_4char = ""; $grid_4char_lotw = ""; $query = $this->ffma_model->get_lotw($location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_4char_lotw = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_4char_lotw, $array_grid_4char_lotw)){ array_push($array_grid_4char_lotw, $grid_4char_lotw); } } } $query = $this->ffma_model->get_paper($location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_4char_paper = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_4char_paper, $array_grid_4char_paper)){ array_push($array_grid_4char_paper, $grid_4char_paper); } } } $query = $this->ffma_model->get_worked($location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_four = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_four, $array_grid_4char)){ array_push($array_grid_4char, $grid_four); } } } $vucc_grids = $this->ffma_model->get_vucc_lotw($location_list); foreach($vucc_grids as $key) { $grid_four_lotw = strtoupper(substr($key,0,4)); if(!in_array($grid_four_lotw, $array_grid_4char_lotw)){ array_push($array_grid_4char_lotw, $grid_four_lotw); } } $vucc_grids = $this->ffma_model->get_vucc_paper($location_list); foreach($vucc_grids as $key) { $grid_four_paper = strtoupper(substr($key,0,4)); if(!in_array($grid_four_paper, $array_grid_4char_paper)){ array_push($array_grid_4char_paper, $grid_four_paper); } } $vucc_grids = $this->ffma_model->get_vucc_worked($location_list); foreach($vucc_grids as $key) { $grid_four = strtoupper(substr($key,0,4)); if(!in_array($grid_four, $array_grid_4char)){ array_push($array_grid_4char, $grid_four); } } $data['grid_4char_lotw'] = ($array_grid_4char_lotw); $data['grid_4char_paper'] = ($array_grid_4char_paper); $data['grid_4char'] = ($array_grid_4char); $data['grid_count'] = $this->ffma_model->get_grid_count(); $data['grids'] = $this->ffma_model->get_grids(); header('Content-Type: application/json'); echo json_encode($data); } public function getGridmasterGridsjs($dxcc) { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $location_list = "'".implode("','",$logbooks_locations_array)."'"; $this->load->model('gridmaster_model'); $dxcc = $this->security->xss_clean($dxcc); $array_grid_4char = array(); $array_grid_4char_lotw = array(); $array_grid_4char_paper = array(); $grid_4char = ""; $grid_4char_lotw = ""; $query = $this->gridmaster_model->get_lotw($dxcc, $location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_4char_lotw = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_4char_lotw, $array_grid_4char_lotw)){ array_push($array_grid_4char_lotw, $grid_4char_lotw); } } } $query = $this->gridmaster_model->get_paper($dxcc, $location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_4char_paper = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_4char_paper, $array_grid_4char_paper)){ array_push($array_grid_4char_paper, $grid_4char_paper); } } } $query = $this->gridmaster_model->get_worked($dxcc, $location_list); if ($query && $query->num_rows() > 0) { foreach ($query->result() as $row) { $grid_four = strtoupper(substr($row->GRID_SQUARES,0,4)); if(!in_array($grid_four, $array_grid_4char)){ array_push($array_grid_4char, $grid_four); } } } $vucc_grids = $this->gridmaster_model->get_vucc_lotw($dxcc, $location_list); foreach($vucc_grids as $key) { $grid_four_lotw = strtoupper(substr($key,0,4)); if(!in_array($grid_four_lotw, $array_grid_4char_lotw)){ array_push($array_grid_4char_lotw, $grid_four_lotw); } } $vucc_grids = $this->gridmaster_model->get_vucc_paper($dxcc, $location_list); foreach($vucc_grids as $key) { $grid_four_paper = strtoupper(substr($key,0,4)); if(!in_array($grid_four_paper, $array_grid_4char_paper)){ array_push($array_grid_4char_paper, $grid_four_paper); } } $vucc_grids = $this->gridmaster_model->get_vucc_worked($dxcc, $location_list); foreach($vucc_grids as $key) { $grid_four = strtoupper(substr($key,0,4)); if(!in_array($grid_four, $array_grid_4char)){ array_push($array_grid_4char, $grid_four); } } $data['grid_4char_lotw'] = ($array_grid_4char_lotw); $data['grid_4char_paper'] = ($array_grid_4char_paper); $data['grid_4char'] = ($array_grid_4char); $data['grid_count'] = $this->gridmaster_model->get_grid_count($dxcc); $data['grids'] = $this->gridmaster_model->get_grids($dxcc); $data['lat'] = $this->gridmaster_model->get_lat($dxcc); $data['lon'] = $this->gridmaster_model->get_lon($dxcc); $data['zoom'] = $this->gridmaster_model->get_zoom($dxcc); header('Content-Type: application/json'); echo json_encode($data); } /* Handles showing worked Sigs Adif fields: my_sig */ public function sig() { // Grab all worked sig stations $this->load->model('sig'); $data['sig_types'] = $this->sig->get_all_sig_types(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("SIG")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/sig/index'); $this->load->view('interface_assets/footer'); } /* Handles showing worked Sigs */ public function sig_details() { // Grab all worked sig stations $this->load->model('sig'); $type = str_replace('"', "", $this->security->xss_clean($this->input->get("type"))); $data['sig_all'] = $this->sig->get_all($type); $data['type'] = $type; $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render page $data['page_title'] = __("Awards - SIG - ") . $type; $this->load->view('interface_assets/header', $data); $this->load->view('awards/sig/qso_list'); $this->load->view('interface_assets/footer'); } /* Handles exporting SIGS to ADIF */ public function sigexportadif() { // Set memory limit to unlimited to allow heavy usage ini_set('memory_limit', '-1'); $this->load->model('adif_data'); $type = $this->security->xss_clean($this->uri->segment(3)); $data['qsos'] = $this->adif_data->sig_all($type); $this->load->view('adif/data/exportall', $data); } /* function was_map This displays the WAS map and requires the $band_type and $mode_type */ public function was_map() { $stateString = 'AK,AL,AR,AZ,CA,CO,CT,DE,FL,GA,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,OR,PA,RI,SC,SD,TN,TX,UT,VA,VT,WA,WI,WV,WY'; $wasArray = explode(',', $stateString); $this->load->model('was'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $was_array = $this->was->get_was_array($bands, $postdata); $states = array(); foreach ($wasArray as $state) { // Generating array for use in the table $states[$state] = '-'; // Inits each state's count } foreach ($was_array as $was => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { $states[$was] = 'W'; break; } if (strpos($key, '>C<') !== false) { $states[$was] = 'C'; break; } if (strpos($key, '-') !== false) { $states[$was] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($states); } public function wap() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wapmap.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('wap'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('wap'); $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; } $data['wap_array'] = $this->wap->get_wap_array($bands, $postdata); $data['wap_summary'] = $this->wap->get_wap_summary($bands, $postdata); $data['user_map_custom'] = $this->optionslib->get_map_custom(); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("WAP")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wap/index'); $this->load->view('interface_assets/footer', $footerData); } /* function WAIP This displays the WAIP (Worked All Italian Provinces) award */ public function waip() { $data['active_station_logbook'] = $this->logbooks_model->find_name($this->session->userdata('active_station_logbook')); $this->load->model('waip'); $this->load->model('bands'); // Get station location $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); // Generate QSL string for displayContacts links (QSL only) $postdata['qsl'] = 1; $postdata['confirmed'] = 1; $data['qsl_string'] = $this->genfunctions->gen_qsl_from_postdata($postdata); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; // All data comes from single efficient query $data['waip_worked'] = $this->waip->get_waip_worked_by_modes($location_list); $data['waip_array'] = $this->waip->get_waip_simple_by_modes($postdata, $location_list); $data['waip_totals'] = $this->waip->get_waip_totals_by_modes($postdata, $location_list); // Band-based data $data['waip_worked_bands'] = $this->waip->get_waip_worked_by_bands($location_list); $data['waip_array_bands'] = $this->waip->get_waip_simple_by_bands($postdata, $location_list); $data['waip_totals_bands'] = $this->waip->get_waip_totals_by_bands($postdata, $location_list); } else { $location_list = null; $data['waip_worked'] = null; $data['waip_array'] = null; $data['waip_totals'] = null; $data['waip_worked_bands'] = null; $data['waip_array_bands'] = null; $data['waip_totals_bands'] = null; } // Pass postdata for use in view $data['postdata'] = $postdata; // Render page $data['page_title'] = sprintf(__("Awards - %s"), __('WAIP')); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $this->load->view('interface_assets/header', $data); $this->load->view('awards/waip/index'); $this->load->view('interface_assets/footer'); } /* function waip_map Returns JSON data for WAIP Award map visualization */ public function waip_map() { $this->load->model('waip'); // Get category (MIXED, PHONE, CW, DIGI, or band like 20M) $category = $this->security->xss_clean($this->input->post('category')); if (!$category) { $category = 'MIXED'; } // QSL only $postdata['qsl'] = 1; // Get location list for active station $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; // Get map status directly from model $provinces = $this->waip->get_waip_map_status($category, $postdata, $location_list); header('Content-Type: application/json'); echo json_encode($provinces); } /* function WAP_map This displays the WAP Worked All The Netherlands Provinces map and requires the $band_type and $mode_type */ public function wap_map() { $stateString = 'DR,FL,FR,GD,GR,LB,NB,NH,OV,UT,ZH,ZL'; $wapArray = explode(',', $stateString); $this->load->model('wap'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $wap_array = $this->wap->get_wap_array($bands, $postdata); $states = array(); foreach ($wapArray as $state) { // Generating array for use in the table $states[$state] = '-'; // Inits each state's count } foreach ($wap_array as $was => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>C<') !== false) { $states[$was] = 'C'; break; } if (strpos($key, '>W<') !== false) { $states[$was] = 'W'; break; } if (strpos($key, '-') !== false) { $states[$was] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($states); } /* function RAC_map This displays the RAC map and requires the $band_type and $mode_type */ public function rac_map() { $stateString = 'AB,BC,MB,NB,NL,NT,NS,NU,ON,PE,QC,SK,YT'; $racArray = explode(',', $stateString); $this->load->model('rac'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $rac_array = $this->rac->get_rac_array($bands, $postdata); $states = array(); foreach ($racArray as $state) { // Generating array for use in the table $states[$state] = '-'; // Inits each state's count } foreach ($rac_array as $was => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { $states[$was] = 'W'; break; } if (strpos($key, '>C<') !== false) { $states[$was] = 'C'; break; } if (strpos($key, '-') !== false) { $states[$was] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($states); } /* function H26_map This displays the H26 map and requires the $band_type and $mode_type */ public function helvetia_map() { $stateString = 'AG,AI,AR,BE,BL,BS,FR,GE,GL,GR,JU,LU,NE,NW,OW,SG,SH,SO,SZ,TG,TI,UR,VD,VS,ZG,ZH'; $helvetiaArray = explode(',', $stateString); $this->load->model('helvetia_model'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $helvetia_array = $this->helvetia_model->get_helvetia_array($bands, $postdata); $states = array(); foreach ($helvetiaArray as $state) { // Generating array for use in the table $states[$state] = '-'; // Inits each state's count } foreach ($helvetia_array as $was => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { $states[$was] = 'W'; break; } if (strpos($key, '>C<') !== false) { $states[$was] = 'C'; break; } if (strpos($key, '-') !== false) { $states[$was] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($states); } /* function cq_map This displays the CQ Zone map and requires the $band_type and $mode_type */ public function cq_map() { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('cq'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('cq'); if ($this->input->post('band') == 'All') { $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['datefrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateto'] = $this->security->xss_clean($this->input->post('dateTo')); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $zones = $this->cq->get_cq_array($bands, $postdata, $location_list, true); } else { $location_list = null; $zones = array(); } header('Content-Type: application/json'); echo json_encode($zones); } /* function waja_map */ public function waja_map() { $prefectureString = '01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47'; $wajaArray = explode(',', $prefectureString); $this->load->model('waja'); $this->load->model('bands'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $waja_array = $this->waja->get_waja_array($bands, $postdata); $prefectures = array(); foreach ($wajaArray as $state) { // Generating array for use in the table $prefectures[$state] = '-'; // Inits each state's count } foreach ($waja_array as $waja => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { $prefectures[$waja] = 'W'; break; } if (strpos($key, '>C<') !== false) { $prefectures[$waja] = 'C'; break; } if (strpos($key, '-') !== false) { $prefectures[$waja] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($prefectures); } /* function wapc_map */ public function wapc_map() { $this->load->model('wapc'); $this->load->model('bands'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->input->post('band', TRUE); $postdata['mode'] = $this->input->post('mode', TRUE); $wapc_array = $this->wapc->get_wapc_array($bands, $postdata); $provinces = array(); $wapcArray = array_keys($this->wapc->cnProvinces); foreach ($wapcArray as $state) { $provinces[$state] = '-'; } foreach ($wapc_array as $wapc => $value) { foreach ($value as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { $provinces[$wapc] = 'W'; break; } if (strpos($key, '>C<') !== false) { $provinces[$wapc] = 'C'; break; } if (strpos($key, '-') !== false) { $provinces[$wapc] = '-'; break; } } } } header('Content-Type: application/json'); echo json_encode($provinces); } /* function dxcc_map This displays the DXCC map */ public function dxcc_map() { $this->load->model('dxcc'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('dxcc'); if ($this->input->post('band') == 'All') { $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['includedeleted'] = ($this->input->post('includedeleted',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sat')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbit')); $postdata['prop_mode'] = $this->security->xss_clean($this->input->post('prop_mode')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $dxcclist = $this->dxcc->fetchdxcc($postdata, $location_list); if (!empty($dxcclist) && $dxcclist[0]->adif == "0") { unset($dxcclist[0]); } $dxcc_array = $this->dxcc->get_dxcc_array($dxcclist, $bands, $postdata, $location_list, true); } else { $location_list = null; $dxcc_array = array(); $dxcclist = []; } $newdxcc = []; $i = 0; foreach ($dxcclist as $dxcc) { $newdxcc[$i]['adif'] = $dxcc->adif; $newdxcc[$i]['prefix'] = $dxcc->prefix; $newdxcc[$i]['name'] = ucwords(strtolower($dxcc->name), "- (/"); if ($dxcc->Enddate!=null) { $newdxcc[$i]['name'] .= ' (deleted)'; } $newdxcc[$i]['lat'] = $dxcc->lat; $newdxcc[$i]['long'] = $dxcc->long; $newdxcc[$i++]['status'] = isset($dxcc_array[$dxcc->adif]) ? $dxcc_array[$dxcc->adif] : 'x'; } header('Content-Type: application/json'); echo json_encode($newdxcc); } /** * Provide data for AJAX to render the JCC map */ public function jcc_map() { $this->load->model('jcc_model'); $this->load->model('bands'); $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? null : 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? null : 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? null : 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? null : 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? null : 1; $postdata['worked'] = ($this->input->post('worked', true) ?? 0) == 0 ? null : 1; $postdata['confirmed'] = ($this->input->post('confirmed', true) ?? 0) == 0 ? null : 1; $postdata['notworked'] = ($this->input->post('notworked', true) ?? 0) == 0 ? null : 1; $postdata['includedeleted'] = ($this->input->post('includedeleted', true) ?? 0) == 0 ? null : 1; $postdata['band'] = $this->input->post('band', true) ?? 'All'; $postdata['mode'] = $this->input->post('mode', true) ?? 'All'; $postdata['prop_mode'] = $this->input->post('prop_mode', true) ?? 'All'; $jcc_entity_status = $this->jcc_model->query_entity_status($postdata, 'none'); $jccs = $this->jcc_model->get_jcc_map_array($postdata, $jcc_entity_status); header('Content-Type: application/json'); echo json_encode($jccs); } /* function iota This displays the IOTA map */ public function iota_map() { $this->load->model('iota'); $this->load->model('bands'); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); if ($logbooks_locations_array[0] === -1) { return null; } $location_list = "'".implode("','",$logbooks_locations_array)."'"; $bands[] = $this->security->xss_clean($this->input->post('band')); $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['includedeleted'] = ($this->input->post('includedeleted',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')) ?? NULL; $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')) ?? NULL; $iotalist = $this->iota->fetchIota($postdata, $location_list); $iota_array = $this->iota->get_iota_array($iotalist, $bands, $postdata, $location_list); $i = 0; $newiota = []; foreach ($iotalist as $iota) { $newiota[$i]['tag'] = $iota->tag; $newiota[$i]['prefix'] = $iota->prefix; $newiota[$i]['name'] = ucwords(strtolower($iota->name), "- (/"); if ($iota->status == 'D') { $newiota[$i]['name'] .= ' (deleted)'; } $newiota[$i]['lat1'] = $iota->lat1; $newiota[$i]['lon1'] = $iota->lon1; $newiota[$i]['lat2'] = $iota->lat2; $newiota[$i]['lon2'] = $iota->lon2; $newiota[$i++]['status'] = isset($iota_array[$iota->tag]) ? $this->returnStatus($iota_array[$iota->tag]) : 'x'; } header('Content-Type: application/json'); echo json_encode($newiota); } function returnStatus($string) { foreach ($string as $key) { if($key != "") { if (strpos($key, '>W<') !== false) { return 'W'; } if (strpos($key, '>C<') !== false) { return 'C'; } if ($key == '-') { return '-'; } } } } public function wab() { $this->load->model('bands'); $this->load->model('gridmap_model'); $this->load->model('stations'); $data['modes'] = $this->gridmap_model->get_worked_modes(); $data['bands'] = $this->bands->get_worked_bands(); $data['orbits'] = $this->bands->get_worked_orbits(); $data['sats_available'] = $this->bands->get_worked_sats(); $data['user_default_band'] = $this->session->userdata('user_default_band'); $data['user_default_confirmation'] = $this->session->userdata('user_default_confirmation'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wab.js' ]; // Render page $data['page_title'] = sprintf(__("Awards - %s"), "Worked All Britain"); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wab/index'); $this->load->view('interface_assets/footer', $footerData); } public function wab_map() { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sat')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbit')); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('wab'); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $wab_array = $this->wab->get_wab_array($location_list, $postdata); } else { $location_list = null; $wab_array = null; } header('Content-Type: application/json'); echo json_encode($wab_array); } public function wab_list() { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); $postdata['worked'] = $this->security->xss_clean($this->input->post('worked')); $postdata['confirmed'] = $this->security->xss_clean($this->input->post('confirmed')); $postdata['notworked'] = $this->security->xss_clean($this->input->post('notworked')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sat')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbit')); $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('wab'); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $wab_array = $this->wab->get_wab_list($location_list, $postdata); } else { $location_list = null; $wab_array = null; } $data['wab_array'] = $wab_array; $data['postdata']['band'] = $postdata['band']; $data['postdata']['mode'] = $postdata['mode']; $data['postdata']['sat'] = $postdata['sat']; $data['postdata']['orbit'] = $postdata['orbit']; $this->load->view('awards/wab/list', $data); } public function itu() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/itumap_geojson.js', 'assets/js/sections/itumap.js' ]; $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('itu'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('cq'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['datefrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateto'] = $this->security->xss_clean($this->input->post('dateTo')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['datefrom'] = null; $postdata['dateto'] = null; } $data['posted_band'] = $postdata['band']; if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $itu_result = $this->itu->get_itu_array($bands, $postdata, $location_list); // Extract bands data and summary from the result $data['itu_array'] = ($itu_result && isset($itu_result['bands'])) ? $itu_result['bands'] : null; $data['itu_summary'] = ($itu_result && isset($itu_result['summary'])) ? $itu_result['summary'] : null; } else { $location_list = null; $data['itu_array'] = null; $data['itu_summary'] = null; } // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("ITU Zones")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/itu/index'); $this->load->view('interface_assets/footer', $footerData); } /* function itu_map This displays the ITU Zone map and requires the $band_type and $mode_type */ public function itu_map() { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('itu'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands('cq'); if ($this->input->post('band') == 'All') { $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['datefrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateto'] = $this->security->xss_clean($this->input->post('dateTo')); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $zones = $this->itu->get_itu_array($bands, $postdata, $location_list, true); } else { $location_list = null; $zones = array(); } header('Content-Type: application/json'); echo json_encode($zones); } public function wac() { $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $this->load->model('wac'); $this->load->model('modes'); $this->load->model('bands'); $data['worked_bands'] = $this->bands->get_worked_bands(); $data['modes'] = $this->modes->active(); // Used in the view for mode select $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['orbits'] = $this->bands->get_worked_orbits(); $data['sats_available'] = $this->bands->get_worked_sats(); $data['user_default_band'] = $this->session->userdata('user_default_band'); if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->input->post('band'); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sats')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbits')); $postdata['worked'] = ($this->input->post('worked',true) ?? 0) == 0 ? NULL: 1; $postdata['confirmed'] = ($this->input->post('confirmed',true) ?? 0) == 0 ? NULL: 1; $postdata['notworked'] = ($this->input->post('notworked',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = null; $postdata['qrz'] = null; $postdata['clublog'] = null; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['sat'] = 'All'; $postdata['orbit'] = 'All'; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['band'] = 'All'; } if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; $data['wac_array'] = $this->wac->get_wac_array($bands, $postdata, $location_list); $data['wac_summary'] = $this->wac->get_wac_summary($bands, $postdata, $location_list); } else { $location_list = null; $data['wac_array'] = null; $data['wac_summary'] = null; } $data['posted_band'] = $postdata['band']; $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wac.js', ]; // Render page $data['page_title'] = sprintf(__("Awards - %s"), __("Worked All Continents (WAC)")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wac/index'); $this->load->view('interface_assets/footer', $footerData); } public function wae () { $this->load->model('wae'); $this->load->model('modes'); $this->load->model('bands'); $data['orbits'] = $this->bands->get_worked_orbits(); $data['sats_available'] = $this->bands->get_worked_sats(); $data['user_default_band'] = $this->session->userdata('user_default_band'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('dxcc'); // Used in the view for band select $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; $postdata['worked'] = $this->input->post('worked') == 0 ? NULL: 1; $postdata['confirmed'] = $this->input->post('confirmed') == 0 ? NULL: 1; $postdata['notworked'] = $this->input->post('notworked') == 0 ? NULL: 1; $postdata['includedeleted'] = $this->security->xss_clean($this->input->post('includedeleted')); $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sats')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbits')); $postdata['dateFrom'] = $this->security->xss_clean($this->input->post('dateFrom')); $postdata['dateTo'] = $this->security->xss_clean($this->input->post('dateTo')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['worked'] = 1; $postdata['confirmed'] = 1; $postdata['notworked'] = 1; $postdata['includedeleted'] = 0; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['sat'] = 'All'; $postdata['orbit'] = 'All'; $postdata['dateFrom'] = null; $postdata['dateTo'] = null; } $result = $this->wae->get_wae_array($bands, $postdata); $data['wae_array'] = $result['matrix'] ?? null; $data['wae_summary'] = $result['summary'] ?? null; $data['posted_band'] = $postdata['band']; // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("WAE")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/wae/index'); $this->load->view('interface_assets/footer'); } public function seven3on73 () { // Grab all worked stations on AO-73 $this->load->model('Seven3on73'); $data['seven3on73_array'] = $this->Seven3on73->get_all(); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['page_title'] = sprintf(__("Awards - %s"), __("73 on 73")); $this->load->view('interface_assets/header', $data); $this->load->view('awards/73on73/index'); $this->load->view('interface_assets/footer'); } public function wpx () { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/wpx.js', ]; $this->load->model('wpx'); $this->load->model('modes'); $this->load->model('bands'); $data['orbits'] = $this->bands->get_worked_orbits(); $data['sats_available'] = $this->bands->get_worked_sats(); $data['user_default_band'] = $this->session->userdata('user_default_band'); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $data['worked_bands'] = $this->bands->get_worked_bands('dxcc'); // Used in the view for band select $data['modes'] = $this->modes->active(); // Used in the view for mode select if ($this->input->post('band') != NULL) { // Band is not set when page first loads. if ($this->input->post('band') == 'All') { // Did the user specify a band? If not, use all bands $bands = $data['worked_bands']; } else { $bands[] = $this->security->xss_clean($this->input->post('band')); } } else { $bands = $data['worked_bands']; } $data['bands'] = $bands; // Used for displaying selected band(s) in the table in the view if($this->input->method() === 'post') { $postdata['qsl'] = ($this->input->post('qsl',true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw',true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl',true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz',true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog',true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa',true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia',true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe',true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica',true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania',true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica',true) ?? 0) == 0 ? NULL: 1; $postdata['band'] = $this->security->xss_clean($this->input->post('band')); $postdata['mode'] = $this->security->xss_clean($this->input->post('mode')); $postdata['sat'] = $this->security->xss_clean($this->input->post('sats')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbits')); } else { // Setting default values at first load of page $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = NULL; $postdata['qrz'] = NULL; $postdata['clublog'] = NULL; $postdata['Africa'] = 1; $postdata['Asia'] = 1; $postdata['Europe'] = 1; $postdata['NorthAmerica'] = 1; $postdata['SouthAmerica'] = 1; $postdata['Oceania'] = 1; $postdata['Antarctica'] = 1; $postdata['band'] = 'All'; $postdata['mode'] = 'All'; $postdata['sat'] = 'All'; $postdata['orbit'] = 'All'; } $data['wpx_array'] = $this->wpx->get_wpx_array($bands, $postdata); // Render Page $data['page_title'] = sprintf(__("Awards - %s"), __("WPX")); $data['posted_band']=$postdata['band']; $this->load->view('interface_assets/header', $data); $this->load->view('awards/wpx/index'); $this->load->view('interface_assets/footer', $footerData); } public function wpx_details() { $postdata['band'] = $this->input->post('band', true); $postdata['status'] = $this->input->post('status', true); $postdata['sat'] = $this->security->xss_clean($this->input->post('sats')); $postdata['orbit'] = $this->security->xss_clean($this->input->post('orbits')); $postdata['mode'] = $this->input->post('mode'); $postdata['qsl'] = ($this->input->post('qsl', true) ?? 0) == 0 ? NULL: 1; $postdata['lotw'] = ($this->input->post('lotw', true) ?? 0) == 0 ? NULL: 1; $postdata['eqsl'] = ($this->input->post('eqsl', true) ?? 0) == 0 ? NULL: 1; $postdata['qrz'] = ($this->input->post('qrz', true) ?? 0) == 0 ? NULL: 1; $postdata['clublog'] = ($this->input->post('clublog', true) ?? 0) == 0 ? NULL: 1; $postdata['Africa'] = ($this->input->post('Africa', true) ?? 0) == 0 ? NULL: 1; $postdata['Asia'] = ($this->input->post('Asia', true) ?? 0) == 0 ? NULL: 1; $postdata['Europe'] = ($this->input->post('Europe', true) ?? 0) == 0 ? NULL: 1; $postdata['NorthAmerica'] = ($this->input->post('NorthAmerica', true) ?? 0) == 0 ? NULL: 1; $postdata['SouthAmerica'] = ($this->input->post('SouthAmerica', true) ?? 0) == 0 ? NULL: 1; $postdata['Oceania'] = ($this->input->post('Oceania', true) ?? 0) == 0 ? NULL: 1; $postdata['Antarctica'] = ($this->input->post('Antarctica', true) ?? 0) == 0 ? NULL: 1; $postdata['summaryband'] = $this->input->post('summaryband', true); $this->load->model('wpx'); $this->load->model('modes'); $this->load->model('bands'); $results = $this->wpx->getWpxBandDetails($postdata); $data['band'] = $postdata['band']; $data['status'] = $postdata['status']; $data['results'] = $results; $this->load->view('awards/wpx/wpx_details', $data); } /* Handles displaying the Polska Award (Polish Award) Tracks contacts with Polish voivodeships (provinces) for the Poland award program Uses COL_STATE field for voivodeship codes (16 Polish voivodeships) */ public function pl_polska() { $footerData = []; $footerData['scripts'] = [ 'assets/js/sections/award_pl_polska.js', 'assets/js/leaflet/L.Maidenhead.js', ]; $this->load->model('logbooks_model'); $this->load->model('stations'); $data['active_station_logbook'] = $this->logbooks_model->find_name($this->session->userdata('active_station_logbook')); $this->load->model('award_pl_polska'); $this->load->model('bands'); $this->load->library('Genfunctions'); // Define valid bands for Polska award (per PZK rules) // https://awards.pzk.org.pl/polish-awards/polska.html // SAT is explicitly excluded (no satellite/repeater contacts allowed) $data['worked_bands'] = array('160M', '80M', '40M', '30M', '20M', '17M', '15M', '12M', '10M', '6M', '2M'); if($this->input->method() === 'post') { $postdata['qsl'] = $this->security->xss_clean($this->input->post('qsl')); $postdata['lotw'] = $this->security->xss_clean($this->input->post('lotw')); $postdata['eqsl'] = $this->security->xss_clean($this->input->post('eqsl')); $postdata['qrz'] = $this->security->xss_clean($this->input->post('qrz')); $postdata['clublog'] = $this->security->xss_clean($this->input->post('clublog')); // Always use active logbook (no multiselect) $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); } else { $postdata['qsl'] = 1; $postdata['lotw'] = 1; $postdata['eqsl'] = 0; $postdata['qrz'] = 0; $postdata['clublog'] = 0; // Default to active logbook $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); } // Add confirmed key for gen_qsl_from_postdata function compatibility $postdata['confirmed'] = 1; // Generate QSL string for displayContacts links $data['qsl_string'] = $this->genfunctions->gen_qsl_from_postdata($postdata); if ($logbooks_locations_array) { $location_list = "'".implode("','",$logbooks_locations_array)."'"; // Worked data (all QSOs, not just confirmed) $data['polska_worked'] = $this->award_pl_polska->get_polska_worked_by_modes($location_list); $data['polska_worked_bands'] = $this->award_pl_polska->get_polska_worked_by_bands($data['worked_bands'], $location_list); // Confirmed data $data['polska_array'] = $this->award_pl_polska->get_polska_simple_by_modes($postdata, $location_list); $data['polska_totals'] = $this->award_pl_polska->get_polska_totals_by_modes($postdata, $location_list); // Band-based confirmed data $data['polska_array_bands'] = $this->award_pl_polska->get_polska_simple_by_bands($data['worked_bands'], $postdata, $location_list); $data['polska_totals_bands'] = $this->award_pl_polska->get_polska_totals_by_bands($data['worked_bands'], $postdata, $location_list); // Calculate award classes for each mode category $data['polska_classes'] = array(); $mode_categories = array('MIXED', 'PHONE', 'CW', 'DIGI'); foreach ($mode_categories as $category) { $postdata_temp = $postdata; $postdata_temp['mode'] = $category; $postdata_temp['band'] = 'All'; $data['polska_classes'][$category] = $this->award_pl_polska->getPolskaClassByCategory($location_list, $category, $postdata_temp, true); } // Calculate award classes for each band $data['polska_classes_bands'] = array(); $valid_bands = array('160M', '80M', '40M', '30M', '20M', '17M', '15M', '12M', '10M', '6M', '2M'); foreach ($valid_bands as $band) { $postdata_temp = $postdata; $postdata_temp['band'] = $band; $postdata_temp['mode'] = 'All'; $data['polska_classes_bands'][$band] = $this->award_pl_polska->getPolskaClassByBand($location_list, $band, $postdata_temp, true); } } else { $location_list = null; $data['polska_worked'] = null; $data['polska_worked_bands'] = null; $data['polska_array'] = null; $data['polska_totals'] = null; $data['polska_array_bands'] = null; $data['polska_totals_bands'] = null; $data['polska_classes'] = null; $data['polska_classes_bands'] = null; } // Pass postdata for use in view $data['postdata'] = $postdata; // Render page $data['page_title'] = sprintf(__("Awards - %s"), __('"Polska" Award')); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $this->load->view('interface_assets/header', $data); $this->load->view('awards/pl_polska/index'); $this->load->view('interface_assets/footer', $footerData); } /* function polska_map Returns JSON data for Polska Award map visualization */ public function polska_map() { $this->load->model('award_pl_polska'); // Get category (MIXED, PHONE, CW, DIGI, or band like 20M) $category = $this->security->xss_clean($this->input->post('category')); if (!$category) { $category = 'MIXED'; } $postdata['qsl'] = $this->input->post('qsl') == 0 ? NULL: 1; $postdata['lotw'] = $this->input->post('lotw') == 0 ? NULL: 1; $postdata['eqsl'] = $this->input->post('eqsl') == 0 ? NULL: 1; $postdata['qrz'] = $this->input->post('qrz') == 0 ? NULL: 1; $postdata['clublog'] = $this->input->post('clublog') == 0 ? NULL: 1; // Get location list for active station $this->load->model('logbooks_model'); $logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook')); $location_list = "'" . implode("','", $logbooks_locations_array) . "'"; // Get map status directly from model $voivodeships = $this->award_pl_polska->get_polska_map_status($category, $postdata, $location_list); header('Content-Type: application/json'); echo json_encode($voivodeships); } /* * AMSAT Rover Award */ public function amsat_rover() { $this->load->model('amsat_rover'); $data['page_title'] = __("Awards - AMSAT Rover"); $data['user_map_custom'] = $this->optionslib->get_map_custom(); $station_info = $this->amsat_rover->get_station_info(); $data['home_grid'] = $station_info['home_grid']; $data['station_callsign'] = $station_info['station_callsign']; $filters = ($this->input->method() === 'post') ? $this->amsat_rover->get_filters() : ['confirmations' => ['lotw', 'qsl']]; $data['filters'] = $filters; foreach (['bonus_social', 'bonus_photos', 'bonus_mm', 'bonus_journal'] as $field) { $data[$field] = (bool) $this->input->post($field); } $result = $this->amsat_rover->get_activations($filters, $station_info); $data['activations'] = $result['activations']; $data['summary'] = $result['summary']; $this->load->view('interface_assets/header', $data); $this->load->view('awards/amsat_rover/index'); $this->load->view('interface_assets/footer'); } /* * AMSAT Rover Award - Export as plain text for email */ public function amsat_rover_export_text() { $this->load->model('amsat_rover'); $station_info = $this->amsat_rover->get_station_info(); $result = $this->amsat_rover->get_activations($this->amsat_rover->get_filters(), $station_info); $bonus = $this->amsat_rover->get_bonus(); $total = $result['summary']['total_points'] + $bonus['bonus']; $out = "AMSAT Rover Award Application\n" . "============================\n\n" . "Call: {$station_info['station_callsign']}\n" . "Home Grid: {$station_info['home_grid']}\n\n" . "Grid Activations (Confirmed):\n" . "----------------------------\n"; if (empty($result['activations'])) { $out .= "No confirmed satellite activations found.\n"; } else { foreach ($result['activations'] as $a) { $out .= sprintf("%s | %s | %s | %d pt | %s | %s | %s\n", $a['my_grid'], $a['call_worked'], $a['mode_category'], $a['points'], $a['confirmation'], $a['satellite'] ?? 'N/A', date('Y-m-d H:i', strtotime($a['date'])) . ' UTC'); } } $out .= "\nSummary:\n--------\n" . "Base Points: {$result['summary']['total_points']}\n"; if ($bonus['bonus'] > 0) { $out .= "Bonus Points: {$bonus['bonus']}\n" . implode("\n", $bonus['details']) . "\n"; } $out .= "Total Points: {$total}\nTarget: 25\n" . ($total >= 25 ? "\nStatus: APPROVED - Ready to submit!\n" : "\nStatus: " . (25 - $total) . " more points needed\n") . "\nEvidence: LoTW screenshots/QSL cards attached\n"; if ($this->input->post('bonus_social')) { $out .= "Social Media Evidence: [include link to social media post with @amsat tag]\n"; } if ($this->input->post('bonus_photos')) { $out .= "Photo Evidence: [include link to photo post with @amsat tag]\n"; } if ($this->input->post('bonus_journal')) { $out .= "AMSAT Journal Evidence: [reference to published article]\n"; } header('Content-Type: text/plain; charset=utf-8'); echo $out; } /* * AMSAT Rover Award - Export as CSV */ public function amsat_rover_export_csv() { $this->load->model('amsat_rover'); $station_info = $this->amsat_rover->get_station_info(); $result = $this->amsat_rover->get_activations($this->amsat_rover->get_filters(), $station_info); header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename="amsat_rover_activations.csv"'); $fp = fopen('php://output', 'w'); fputcsv($fp, ['Grid', 'Mode', 'Category', 'Points', 'Confirmation', 'Satellite', 'Date', 'Callsign'], escape: '\\'); foreach ($result['activations'] as $a) { fputcsv($fp, [ $a['my_grid'], $a['mode'], $a['mode_category'], $a['points'], $a['confirmation'], $a['satellite'] ?? 'N/A', date('Y-m-d H:i', strtotime($a['date'])) . ' UTC', $a['call_worked'], ], escape: '\\'); } fclose($fp); } }