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 "}"; }