wavelog/application/controllers/Awards.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/*
	Handles Displaying of information for awards.

	These are taken from comments fields or ADIF fields
*/

class Awards extends CI_Controller {

	private $user_map_color_qso;
	private $user_map_color_qsoconfirm;
	private $user_map_color_unworked;

	function __construct()
	{
		parent::__construct();

		if(!$this->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[] = [
					'<a target="_blank" href="https://www.sotadata.org.uk/en/summit/' . htmlspecialchars((string)$row->COL_SOTA_REF) . '">' . htmlspecialchars((string)$row->COL_SOTA_REF) . '</a>',
					date($date_format, $ts),
					date('H:i', $ts),
					'<a href="javascript:displayQso(' . (int)$row->COL_PRIMARY_KEY . ')">' . htmlspecialchars((string)$row->COL_CALL) . '</a>',
					($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[] = [
					'<a target="_blank" href="https://www.cqgma.org/zinfo.php?ref=' . htmlspecialchars((string)$row->COL_WWFF_REF) . '">' . htmlspecialchars((string)$row->COL_WWFF_REF) . '</a>',
					date($date_format, $ts),
					date('H:i', $ts),
					'<a href="javascript:displayQso(' . (int)$row->COL_PRIMARY_KEY . ')">' . htmlspecialchars((string)$row->COL_CALL) . '</a>',
					($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 = '<a href="javascript:displayQso(' . (int)$row->COL_PRIMARY_KEY . ')">' . htmlspecialchars((string)$row->COL_CALL) . '</a>';
				$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 = '<a target="_blank" href="https://pota.app/#/park/' . htmlspecialchars($reference) . '">' . htmlspecialchars($reference) . '</a>';
					$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);
	}

}