Commit graph

12 commits

Author SHA1 Message Date
Peter Goodhall
3e944f71cc Normalize location lists and sanitize SQL
Replace fragile quoted-implode station lists with normalized integer CSVs and where_in usage to ensure station_id lists are numeric. Add normalize_location_list helpers in multiple models (Lookup_model, Sig, Timeline_model) and update controllers to cast inputs (e.g. dxcc_id) to ints. Escape user-supplied SQL fragments with $this->db->escape_str/escape_like_str and sanitize band/mode parameters; consolidate band/mode filtering into add_band_mode_filters in Timeline_model. Add guards for empty location lists (returning empty results) and a method_exists check around a legacy vucc_shit call. Overall this improves input validation and reduces SQL injection risk while removing duplicated list-building logic.
2026-06-24 22:29:00 +01:00
Peter Goodhall
d847e4819e Add pagination and DXCC tab to previous QSOs
Implement server-side pagination for previous contacts and add a DXCC Summary tab. Controller Qso now uses last_custom_paginated and exposes total_rows/total_pages/current_page/limit. Logbook_model gained last_custom_paginated and last_custom_count to support paged queries. The previous_contacts view was updated with HTMX pagination controls and wrapping for a scrollable table; qso/index was refactored to a tabbed UI (Previous Contacts / DXCC Summary). Lookup result display was improved: responsive table, sticky header, consolidation of LSB/USB into SSB and filtering out empty modes. JS and CSS updates load DXCC HTML into the new tab, hide legacy dxccsummary elements, and add form reset / Escape handling to return focus to the previous contacts tab.
2026-03-26 22:26:47 +00:00
int2001
f1a7644c9b
Fix PHP-Error at DXCC-Summary (Add QSO, bottom) if logbook is empty 2024-01-01 09:50:29 +00:00
Andreas
39536c98e9 [Quick lookup] Adapted for selectable bands 2023-02-18 14:19:02 +01:00
Andreas
0ecc5de833 [DXCC summary] Fix for bands that are not active 2023-02-18 09:58:54 +01:00
Andreas Kristiansen
42fa1a06d0
Merge branch 'station_logbooks' into cloudlog_php8_compatible 2021-11-13 16:03:52 +01:00
Andreas
939434090d [Bands] Consolidated get_worked_bands to it's own model. This will make it easier to have everything in one place, and perhaps also move bands to db. 2021-11-13 15:55:17 +01:00
Andreas
1b2a88b355 Removed all constructors in models, since this doesn't work in never CodeIgniter 2021-11-06 20:24:28 +01:00
Andreas
cad5c1c569 [Quick Lookup] Updated code to support station logbooks 2021-09-10 23:13:25 +02:00
Andreas
c8b0e48bcd [Quick lookup] WWFF added. Did some refactoring to simplify code, and make it easier to add queries. 2021-03-17 18:23:01 +01:00
Andreas
d23464aa5f [Quick lookup] Fix if user inputs longer grid than 4 characters. 2021-03-14 11:56:45 +01:00
Andreas
681cd0af9b [Quick lookup] New feature to quickly check worked/confirmed on band/mode. Invoked by ALT-L 2021-03-14 10:11:21 +01:00