<?php

class Csv_model extends CI_Model
{

	/*
	 * Gets the grids from the datbase
	 *
	 * Filters:
	 *
	 * $band = filter on band
	 * $mode = filter on mode
	 * $dxcc = filter on dxx
	 * $cqz = filter on cq zone
	 * $propagation = Filter on propagation
	 * $fromdate = Date range from
	 * $todate = Date range to
	 *
	 */
	function get_qsos($station_id, $band, $mode, $dxcc, $cqz, $propagation, $fromdate, $todate) {
		$binds=[];
		$sql = "";

		$sql .= "SELECT station_callsign, COL_MY_SOTA_REF, COL_QSO_DATE, COL_TIME_ON, COL_BAND, COL_MODE, COL_CALL, COL_SOTA_REF, COL_COMMENT
			FROM ".$this->config->item('table_name').
			" JOIN station_profile on station_profile.station_id = ".$this->config->item('table_name').".station_id".
			" WHERE (COALESCE(COL_SOTA_REF,NULL,'') != '' OR COALESCE(COL_MY_SOTA_REF,NULL,'') != '')";

		if ($station_id != "All") {
			$sql .= ' and ' . $this->config->item('table_name'). '.station_id = ?';
			$binds[]=$station_id;
		}

		if ($band != 'All') {
			if ($band == 'SAT') {
				$sql .= " and col_prop_mode = ?";
				$binds[]=$band;
			} else {
				$sql .= " and col_prop_mode !='SAT'";
				$sql .= " and col_band = ?";
				$binds[]=$band;
			}
		}

		if ($mode != 'All') {
			$sql .= " and (COL_MODE = ? or COL_SUBMODE = ?)";
			$binds[]=$mode;
			$binds[]=$mode;
		}

		if ($dxcc != 'All') {
			$sql .= " and COL_DXCC = ?";
			$binds[]=$dxcc;
		}

		if ($cqz != 'All') {
			$sql .= " and COL_CQZ = ?";
			$binds[]=$cqz;
		}

		if ($propagation == 'NoRPT') { // All but RPT
			$sql .= " and COL_PROP_MODE != 'RPT'";
		} else if ($propagation == 'All') {
			; // No Prop-Filter
		} else { // Propmode set, add SQL
			$sql .= " and COL_PROP_MODE = ?";
			$binds[] = $propagation;
		}

		// If date is set, we format the date and add it to the where-statement
		if ($fromdate != "") {
			$sql .= " and COL_TIME_ON >= ?";
			$binds[]=$fromdate . ' 00:00:00';
		}
		if ($todate != "") {
			$sql .= " and COL_TIME_ON <= ?";
			$binds[]=$todate . ' 23:59:59';
		}

		$sql .= ' and station_profile.user_id = ?';
		$binds[]=$this->session->userdata('user_id');

		$sql .= ' ORDER BY `COL_TIME_ON` ASC';

		$query = $this->db->query($sql,$binds);

		return $query->result_array();
	}
}
?>
