function bearing($tx, $rx)
{
$my = qra2latlong($tx);
$stn = qra2latlong($rx);
$bearing = bearing($my[0], $my[1], $stn[0], $stn[1]);
return $bearing;
}
function json_map($date)
{
$this->load->model('logbook_model');
$qsos = $this->logbook_model->map_day($date);
echo "{\"markers\": [";
$count = 1;
foreach ($qsos->result() as $row) {
//print_r($row);
if ($row->COL_GRIDSQUARE != null) {
$stn_loc = qra2latlong($row->COL_GRIDSQUARE);
if ($count != 1) {
echo ",";
}
echo "{\"lat\":\"" . $stn_loc[0] . "\",\"lng\":\"" . $stn_loc[1] . "\", \"html\":\"Callsign: " . $row->COL_CALL . "<br />Date/Time: " . $row->COL_TIME_ON . "<br />Band: " . $row->COL_BAND . "<br />Mode: " . $row->COL_MODE . "\",\"label\":\"" . $row->COL_CALL . "\"}";
$count++;
} else {
$query = $this->db->query('
SELECT *
FROM dxcc
WHERE prefix = SUBSTRING( \'' . $row->COL_CALL . '\', 1, LENGTH( prefix ) )
ORDER BY LENGTH( prefix ) DESC
LIMIT 1
');
foreach ($query->result() as $dxcc) {
if ($count != 1) {
echo ",";
}
echo "{\"lat\":\"" . $dxcc->lat . "\",\"lng\":\"" . $dxcc->long . "\", \"html\":\"Callsign: " . $row->COL_CALL . "<br />Date/Time: " . $row->COL_TIME_ON . "<br />Band: " . $row->COL_BAND . "<br />Mode: " . $row->COL_MODE . "\",\"label\":\"" . $row->COL_CALL . "\"}";
$count++;
}
}
}
echo "]";
echo "}";
}
