mirror of
https://github.com/magicbug/Cloudlog
synced 2026-08-13 17:49:35 -04:00
e904595a9d
Bump migration version to 265 and add a migration (265_add_station_time_on_index) that creates idx_station_time_on on (station_id, COL_TIME_ON) for faster time-based queries. Introduce lazy QSO loading: controller now sets defer_qso_list and uses a new POST endpoint get_filtered_qsos to fetch filtered QSO lists and summaries; also updated cache keys/render version and added per-entry cache deletion. Note model: add include_qso_list flag, memoize QSO summaries/lists and station IDs, replace DATE(COL_TIME_ON) filters with half-open datetime ranges (start inclusive, end exclusive) via helper methods to improve index use and performance. View: update public_index to render QSO list containers with data attributes, add JS to fetch and render QSO rows on demand, and support highlight DX updates. Overall changes optimize QSO queries and enable deferred loading to reduce initial page load and DB cost.
400 lines
No EOL
14 KiB
PHP
400 lines
No EOL
14 KiB
PHP
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
|
|
|
|
class Stationdiary extends CI_Controller {
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->load->model('note');
|
|
$this->load->library('pagination');
|
|
$this->load->driver('cache', array('adapter' => 'file'));
|
|
}
|
|
|
|
private function get_public_qso_datetime_format($userDateFormat = NULL)
|
|
{
|
|
$dateFormat = !empty($userDateFormat) ? trim((string)$userDateFormat) : trim((string)$this->config->item('qso_date_format'));
|
|
if ($dateFormat === '') {
|
|
$dateFormat = 'Y-m-d';
|
|
}
|
|
|
|
if (preg_match('/[GgHh]/', $dateFormat) || strpos($dateFormat, 'i') !== FALSE) {
|
|
return $dateFormat;
|
|
}
|
|
|
|
return $dateFormat . ' H:i';
|
|
}
|
|
|
|
private function get_or_create_public_visitor_token()
|
|
{
|
|
$cookieName = 'cloudlog_diary_visitor';
|
|
$token = $this->input->cookie($cookieName, TRUE);
|
|
|
|
if (!empty($token) && preg_match('/^[a-f0-9]{32,64}$/i', $token)) {
|
|
return $token;
|
|
}
|
|
|
|
try {
|
|
$token = bin2hex(random_bytes(16));
|
|
} catch (Exception $e) {
|
|
$token = md5(uniqid((string)mt_rand(), TRUE));
|
|
}
|
|
|
|
setcookie($cookieName, $token, time() + (365 * 24 * 60 * 60), '/', '', (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off'), TRUE);
|
|
return $token;
|
|
}
|
|
|
|
private function build_public_visitor_hash()
|
|
{
|
|
$token = $this->get_or_create_public_visitor_token();
|
|
$ipAddress = (string)$this->input->ip_address();
|
|
$userAgent = substr((string)$this->input->user_agent(), 0, 255);
|
|
$secret = (string)$this->config->item('encryption_key');
|
|
|
|
return hash('sha256', $token . '|' . $ipAddress . '|' . $userAgent . '|' . $secret);
|
|
}
|
|
|
|
public function index($callsign = NULL, $offset = 0)
|
|
{
|
|
if ($this->security->xss_clean($callsign, TRUE) === FALSE) {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$resolution = $this->note->resolve_public_user_by_callsign($callsign);
|
|
if (!isset($resolution['status']) || $resolution['status'] !== 'ok') {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$user_id = (int)$resolution['user_id'];
|
|
$cleanCallsign = strtoupper($resolution['callsign']);
|
|
$pageOffset = is_numeric($offset) ? (int)$offset : 0;
|
|
$cacheVersion = $this->note->get_public_diary_cache_version($user_id);
|
|
$renderVersion = 'public_diary_render_v5';
|
|
$cacheKey = 'public_station_diary_' . md5($cleanCallsign . '_' . $pageOffset . '_' . $cacheVersion . '_' . $renderVersion);
|
|
|
|
$cachedHtml = $this->cache->get($cacheKey);
|
|
if ($cachedHtml !== FALSE && !empty($cachedHtml)) {
|
|
$this->output->set_output($cachedHtml);
|
|
return;
|
|
}
|
|
|
|
$perPage = 10;
|
|
$totalRows = $this->note->count_public_station_diary_entries($user_id);
|
|
|
|
$config['base_url'] = site_url('station-diary/' . rawurlencode($cleanCallsign));
|
|
$config['total_rows'] = $totalRows;
|
|
$config['per_page'] = $perPage;
|
|
$config['uri_segment'] = 3;
|
|
$config['num_links'] = 5;
|
|
$config['full_tag_open'] = '<ul class="pagination pagination-sm">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = array('class' => 'page-link');
|
|
$config['first_link'] = FALSE;
|
|
$config['last_link'] = FALSE;
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_link'] = '«';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_link'] = '»';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><a href="#" class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="visually-hidden">(current)</span></a></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$this->pagination->initialize($config);
|
|
|
|
$data['callsign'] = $cleanCallsign;
|
|
$data['entries'] = $this->note->get_public_station_diary_entries($user_id, $perPage, $pageOffset, FALSE);
|
|
$data['pagination_links'] = $this->pagination->create_links();
|
|
$data['page_title'] = 'Station Diary - ' . $cleanCallsign;
|
|
$data['rss_url'] = site_url('station-diary/' . rawurlencode($cleanCallsign) . '/rss');
|
|
$data['qso_datetime_format'] = $this->get_public_qso_datetime_format($resolution['user_date_format'] ?? NULL);
|
|
$data['is_single_entry'] = false;
|
|
$data['defer_qso_list'] = true;
|
|
$data['current_entry_permalink'] = '';
|
|
|
|
$html = $this->load->view('station_diary/public_index', $data, TRUE);
|
|
$this->cache->save($cacheKey, $html, 86400);
|
|
$this->output->set_output($html);
|
|
}
|
|
|
|
public function rss($callsign = NULL)
|
|
{
|
|
if ($this->security->xss_clean($callsign, TRUE) === FALSE) {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$resolution = $this->note->resolve_public_user_by_callsign($callsign);
|
|
if (!isset($resolution['status']) || $resolution['status'] !== 'ok') {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$user_id = (int)$resolution['user_id'];
|
|
$cleanCallsign = strtoupper($resolution['callsign']);
|
|
$entries = $this->note->get_public_station_diary_entries($user_id, 25, 0);
|
|
|
|
$this->output->set_content_type('application/rss+xml; charset=UTF-8');
|
|
$this->load->view('station_diary/rss', array(
|
|
'callsign' => $cleanCallsign,
|
|
'entries' => $entries, 'feed_url' => site_url('station-diary/' . rawurlencode($cleanCallsign) . '/rss'), ));
|
|
}
|
|
|
|
public function entry($callsign = NULL, $entry_id = 0)
|
|
{
|
|
if ($this->security->xss_clean($callsign, TRUE) === FALSE) {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$resolution = $this->note->resolve_public_user_by_callsign($callsign);
|
|
if (!isset($resolution['status']) || $resolution['status'] !== 'ok') {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$user_id = (int)$resolution['user_id'];
|
|
$cleanCallsign = strtoupper($resolution['callsign']);
|
|
$entryId = (int)$entry_id;
|
|
if ($entryId <= 0) {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$cacheVersion = $this->note->get_public_diary_cache_version($user_id);
|
|
$renderVersion = 'public_diary_render_v4';
|
|
$cacheKey = 'public_station_diary_entry_' . md5($cleanCallsign . '_' . $entryId . '_' . $cacheVersion . '_' . $renderVersion);
|
|
|
|
$cachedHtml = $this->cache->get($cacheKey);
|
|
if ($cachedHtml !== FALSE && !empty($cachedHtml)) {
|
|
$this->output->set_output($cachedHtml);
|
|
return;
|
|
}
|
|
|
|
$entry = $this->note->get_public_station_diary_entry($user_id, $entryId);
|
|
if (!$entry) {
|
|
show_404();
|
|
return;
|
|
}
|
|
|
|
$entryReactionTotals = $this->note->get_station_diary_reaction_totals($entry->id);
|
|
|
|
$data['callsign'] = $cleanCallsign;
|
|
$data['entries'] = array($entry);
|
|
$data['pagination_links'] = '';
|
|
$data['page_title'] = $entry->title . ' - Station Diary - ' . $cleanCallsign;
|
|
$data['rss_url'] = site_url('station-diary/' . rawurlencode($cleanCallsign) . '/rss');
|
|
$data['qso_datetime_format'] = $this->get_public_qso_datetime_format($resolution['user_date_format'] ?? NULL);
|
|
$data['is_single_entry'] = true;
|
|
$data['defer_qso_list'] = false;
|
|
$data['current_entry_permalink'] = site_url('station-diary/' . rawurlencode($cleanCallsign) . '/entry/' . (int)$entry->id);
|
|
$data['entry_reaction_totals'] = $entryReactionTotals;
|
|
$data['visitor_reaction'] = null;
|
|
|
|
$html = $this->load->view('station_diary/public_index', $data, TRUE);
|
|
$this->cache->save($cacheKey, $html, 86400);
|
|
$this->output->set_output($html);
|
|
}
|
|
|
|
public function react($callsign = NULL, $entry_id = 0)
|
|
{
|
|
header('Content-Type: application/json');
|
|
|
|
if (strtolower($this->input->method()) !== 'post') {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid request method'));
|
|
return;
|
|
}
|
|
|
|
if ($this->security->xss_clean($callsign, TRUE) === FALSE) {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid callsign'));
|
|
return;
|
|
}
|
|
|
|
$resolution = $this->note->resolve_public_user_by_callsign($callsign);
|
|
if (!isset($resolution['status']) || $resolution['status'] !== 'ok') {
|
|
echo json_encode(array('success' => false, 'message' => 'Not found'));
|
|
return;
|
|
}
|
|
|
|
$user_id = (int)$resolution['user_id'];
|
|
$entryId = (int)$entry_id;
|
|
if ($entryId <= 0) {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid entry'));
|
|
return;
|
|
}
|
|
|
|
$entry = $this->note->get_public_station_diary_entry($user_id, $entryId);
|
|
if (!$entry) {
|
|
echo json_encode(array('success' => false, 'message' => 'Entry not found'));
|
|
return;
|
|
}
|
|
|
|
$reaction = strtolower(trim((string)$this->input->post('reaction', TRUE)));
|
|
if (!in_array($reaction, array('like', 'love', 'fire'), TRUE)) {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid reaction'));
|
|
return;
|
|
}
|
|
|
|
$visitorHash = $this->build_public_visitor_hash();
|
|
$saved = $this->note->save_station_diary_reaction($entryId, $reaction, $visitorHash);
|
|
if (!$saved) {
|
|
echo json_encode(array('success' => false, 'message' => 'Unable to save reaction'));
|
|
return;
|
|
}
|
|
|
|
$cleanCallsign = strtoupper($resolution['callsign']);
|
|
$cacheVersion = $this->note->get_public_diary_cache_version($user_id);
|
|
$renderVersion = 'public_diary_render_v4';
|
|
$entryCacheKey = 'public_station_diary_entry_' . md5($cleanCallsign . '_' . $entryId . '_' . $cacheVersion . '_' . $renderVersion);
|
|
$this->cache->delete($entryCacheKey);
|
|
|
|
$totals = $this->note->get_station_diary_reaction_totals($entryId);
|
|
$visitorReaction = $this->note->get_station_diary_visitor_reaction($entryId, $visitorHash);
|
|
|
|
echo json_encode(array(
|
|
'success' => true,
|
|
'totals' => $totals,
|
|
'visitor_reaction' => $visitorReaction,
|
|
));
|
|
}
|
|
|
|
public function get_filtered_qsos()
|
|
{
|
|
$this->output->set_content_type('application/json');
|
|
|
|
if (strtolower($this->input->method()) !== 'post') {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid request method'));
|
|
return;
|
|
}
|
|
|
|
$callsign = $this->input->post('callsign', TRUE);
|
|
$entryId = (int)$this->input->post('entry_id', TRUE);
|
|
$startDate = trim((string)$this->input->post('start_date', TRUE));
|
|
$endDate = trim((string)$this->input->post('end_date', TRUE));
|
|
$logbookId = (int)$this->input->post('logbook_id', TRUE);
|
|
$satOnly = $this->input->post('sat_only', TRUE) === '1';
|
|
|
|
if ($this->security->xss_clean($callsign, TRUE) === FALSE || $entryId <= 0) {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid request'));
|
|
return;
|
|
}
|
|
|
|
$resolution = $this->note->resolve_public_user_by_callsign($callsign);
|
|
if (!isset($resolution['status']) || $resolution['status'] !== 'ok') {
|
|
echo json_encode(array('success' => false, 'message' => 'Not found'));
|
|
return;
|
|
}
|
|
|
|
$userId = (int)$resolution['user_id'];
|
|
$entry = $this->note->get_public_station_diary_entry($userId, $entryId);
|
|
if (!$entry) {
|
|
echo json_encode(array('success' => false, 'message' => 'Entry not found'));
|
|
return;
|
|
}
|
|
|
|
$entryDate = date('Y-m-d', strtotime($entry->created_at));
|
|
if ($startDate === '') {
|
|
$startDate = !empty($entry->qso_date_start) ? $entry->qso_date_start : $entryDate;
|
|
}
|
|
if ($endDate === '') {
|
|
$endDate = !empty($entry->qso_date_end) ? $entry->qso_date_end : $entryDate;
|
|
}
|
|
|
|
if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $startDate) || !preg_match('/^\d{4}-\d{2}-\d{2}$/', $endDate)) {
|
|
echo json_encode(array('success' => false, 'message' => 'Invalid date format'));
|
|
return;
|
|
}
|
|
|
|
if ($logbookId <= 0) {
|
|
$logbookId = !empty($entry->logbook_id) ? (int)$entry->logbook_id : 0;
|
|
}
|
|
|
|
$qsoSummary = $this->note->get_qso_summary_for_date_range($userId, $startDate, $endDate, $logbookId, $satOnly);
|
|
$qsoList = $this->note->get_qso_list_for_date_range($userId, $startDate, $endDate, $logbookId, $satOnly);
|
|
|
|
echo json_encode(array(
|
|
'success' => true,
|
|
'qso_list' => $qsoList,
|
|
'highlight_dx' => $qsoSummary['highlight_dx'] ?? null,
|
|
));
|
|
}
|
|
|
|
public function get_qso_map_data()
|
|
{
|
|
$this->output->set_content_type('application/json');
|
|
|
|
$dateFrom = $this->input->post('date_from', TRUE);
|
|
$dateTo = $this->input->post('date_to', TRUE);
|
|
$logbookId = (int)$this->input->post('logbook_id', TRUE);
|
|
$satOnly = $this->input->post('sat_only', TRUE) === '1';
|
|
$entryId = (int)$this->input->post('entry_id', TRUE);
|
|
|
|
if (empty($dateFrom) || empty($dateTo)) {
|
|
echo json_encode(array('error' => 'Date range required'));
|
|
return;
|
|
}
|
|
|
|
// Get user_id from the entry to ensure we only show their QSOs
|
|
$userId = null;
|
|
if ($entryId > 0) {
|
|
$userId = $this->note->get_public_entry_user_id($entryId);
|
|
}
|
|
|
|
if (!$userId) {
|
|
echo json_encode(array('error' => 'Unable to determine user context'));
|
|
return;
|
|
}
|
|
|
|
// Load necessary models
|
|
$this->load->model('logbook_model');
|
|
$this->load->model('Stations');
|
|
|
|
// Get QSOs for the date range
|
|
$qsos = $this->logbook_model->get_qsos_for_public_map($dateFrom, $dateTo, $logbookId, $satOnly, $userId);
|
|
|
|
if (empty($qsos) || $qsos->num_rows() === 0) {
|
|
echo json_encode(array('error' => 'No QSOs found', 'markers' => array()));
|
|
return;
|
|
}
|
|
|
|
// Get plot array for map markers (uses gridsquare, VUCC, DXCC fallback)
|
|
$plotArray = $this->logbook_model->get_plot_array_for_map($qsos->result(), TRUE);
|
|
|
|
// Try to get station location from logbook
|
|
$stationArray = array();
|
|
if ($logbookId > 0) {
|
|
$this->load->model('logbooks_model');
|
|
$this->load->library('qra');
|
|
|
|
$logbookLocations = $this->logbooks_model->list_logbook_relationships($logbookId);
|
|
if (!empty($logbookLocations)) {
|
|
// Get the first station's location
|
|
$stationData = $this->Stations->profile($logbookLocations[0])->row();
|
|
if ($stationData && !empty($stationData->station_gridsquare)) {
|
|
list($stationLat, $stationLng) = $this->qra->qra2latlong($stationData->station_gridsquare);
|
|
if ($stationLat != 0 && $stationLng != 0) {
|
|
$stationArray = array(
|
|
'station' => array(
|
|
'lat' => $stationLat,
|
|
'lng' => $stationLng,
|
|
'html' => '<strong>' . htmlspecialchars($stationData->station_callsign ?? '', ENT_QUOTES) . '</strong><br>' . $stationData->station_gridsquare,
|
|
'label' => $stationData->station_profile_name ?? '',
|
|
'icon' => 'stationIcon'
|
|
)
|
|
);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// Merge and return
|
|
echo json_encode(array_merge($plotArray, $stationArray));
|
|
}
|
|
} |