Commit graph

54 commits

Author SHA1 Message Date
Peter Goodhall
a56f1b8773 Added EME to DXCC Awards page 2026-07-21 13:16:10 +01:00
Peter Goodhall
e5ce621734 Replace band dropdown with multi-select checkboxes
Replaces the single band dropdown on the DXCC awards page with a group of checkboxes allowing multiple bands to be selected simultaneously.

- Controller and model updated to accept `bands[]` array instead of a single `band` value
- `addBandToQuery()` in Dxcc model now handles array input, building appropriate IN clauses and SAT propagation mode logic
- `returnStatus()` priority fixed: Confirmed (C) now takes precedence over Worked (W); unworked entries now return 'x' instead of null
- JS updated to collect checked band values; map and filter reset functions updated accordingly
- Uninitialized `$newdxcc`/`$newiota` arrays now explicitly initialized before use
2026-07-20 22:08:53 +01:00
Peter Goodhall
c6bdee1bc5 Sanitize location lists and harden SQL
Replace string-quoted station_id lists with comma-separated, integer-casted lists and harden SQL across awards models. This diff converts constructions like "'a','b'" to implode(',', array_map('intval', ...)) and uses $this->db->escape_str() for band/mode values and band lists to reduce injection/format issues. Added helper methods (addModeToQuery, addBandToQuery variants) to centralize mode/band filtering, parameterized time/mode/band queries in Gmdxsummer_model, and escaped band arrays when building IN() lists. Also added null/empty-checks for logbook arrays in several models and small refactors (e.g. VUCC addBandToQuery) to keep SQL building consistent.
2026-06-24 22:26:11 +01:00
Peter Goodhall
177f605183 Add year filter to DXCC awards
Add a year filter to the DXCC awards UI and backend. Controller: populate worked_years for the view and read/sanitize a year POST value (default 'All'). Model: introduce addYearToQuery() to append a YEAR(col_time_on) clause to existing DXCC queries and call it in relevant query paths; add get_worked_years() to return distinct worked years for the active logbook locations. View: add a year select dropdown to the DXCC awards form. This enables narrowing DXCC results by year.
2026-05-03 22:48:10 +01:00
Peter Goodhall
d597e2e83b Add DXCC statistics and continent breakdown
Introduces DXCC statistics and continent breakdown features to the awards page, including new controller endpoints for DXCC QSOs, QSOs by status, and continent QSOs. Updates the DXCC model to provide continent and milestone statistics, and enhances the awards view with summary cards, continent progress, table search, sorting, and modal dialogs for QSO details.
2026-01-06 22:34:05 +00:00
Peter Goodhall
3d7258c1f5 Optimize dashboard model loading and DXCC count
Refactored Dashboard controller to load common models in the constructor and optimize dashboard options processing using associative arrays for faster lookups. Replaced DXCC entity counting logic with a new get_total_dxcc_count() method in the Dxcc model to avoid loading all records, improving performance.
2025-08-09 21:14:39 +01:00
HB9HIL
3f4857e6db fixed worked and confirmed badges in awards 2023-11-25 23:54:14 +01:00
HB9HIL
bccd6819c1 fix dxcc award bg colors 2023-11-20 02:14:51 +01:00
phl0
5e1bbdaa97
Show deleted DXCC as badge in DXCC awards 2023-05-14 16:00:22 +02:00
phl0
90b2e9c7f9
Implement eQSL and QSL filter for DXCC awards 2023-01-18 13:51:46 +01:00
Andreas
30f3df15ce [DXCC] Added map 2022-11-11 19:23:41 +01:00
Andreas
8527598c22 [DXCC Award] Added ucwords to the DXCC Name so that it displays nicer 2022-09-20 12:18:40 +02:00
Andreas
09144a5589 [Bands] Only use selected bands in total in awards 2022-09-07 20:40:31 +02:00
Andreas
66e72d035a [DXCC Award] Added filtering to the summary 2021-12-31 14:05:33 +01:00
Andreas
8c7fa355fb [Awards] Fixed implode error when logbook is empty 2021-11-14 17:11:59 +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
006b721b0e [DXCC Award] Updated code to support station logbooks 2021-09-09 20:59:51 +02:00
Andreas
38d6112b4c [Awards DXCC] Added fix for summary that didn't check if col_dxcc > 0. Fixed a small bug in a query and added some checks for col_dxcc > 0, just to be sure 2021-07-28 18:51:44 +02:00
Andreas
8b370c9783 [Awards] Fixed DXCC QSO details to also filter on modes. Made a generic function to display QSOs. It's now used for DXCC, WAS, IOTA, CQ, VUCC. This is also done in preparation for adding mode filter to WAS, IOTA and CQ Award. 2021-07-24 14:31:16 +02:00
Warren Volz
0fcd7eb07e Correct dxcc exceptions table name 2021-04-05 15:26:20 -06:00
Andreas
2005ff7f55 [DXCC Award] Adjusted queries for mode. 2020-12-13 09:18:47 +01:00
Peter Goodhall
166789e57d
Merge pull request #662 from AndreasK79/dashboard_needed_dxcc_fix
Fixed a couple of bugs in countries breakdown on dashboard.
2020-10-18 15:06:42 +01:00
Andreas
68c8b3889c Fixed a couple of bugs in countries breakdown on dashboard. 2020-10-16 20:02:54 +02:00
Andreas
1696656082 Added total for the DXCC award. 2020-10-14 13:03:21 +02:00
Andreas
fe5ccb0ea2 Added bootstrapdialog for DXCC award. 2020-09-20 06:00:54 +02:00
Peter Goodhall
c58784c022
Merge branch 'master' into lotw-sync 2020-09-01 17:49:34 +01:00
Peter Goodhall
047636b674 Basics for ADIF TQ8 headers added based on database info 2020-08-25 15:53:20 +01:00
Andreas
9ced2f4791 Hopefully fixed DXCC summary. 2020-08-19 17:42:42 +02:00
AndreasK79
bf12d931b4 Fixed for DXCC award. Removed SAT QSOs from each band. Only counts for SAT. 2020-03-21 07:53:12 +01:00
Kim Huebel
4c290c3360 URL-Encoding fixed
This fixes a problem with URL-Encoding of some entities with & in the name like Agalega & St Brandon Islands or similiar.
Problem was, that the & was misinterpreted within the browser-url and does not show the correct results.
2020-03-05 19:42:54 +01:00
phl0
5accdc248f
Omit "Deleted" columen if deleted DXCCs are not included 2020-03-05 17:09:53 +01:00
phl0
fe286bd74c
Revert "Do not store div design in array"
This reverts commit 1aa2741351.
2020-03-05 17:03:55 +01:00
phl0
8cd5c690d6
Fix nasty bug with deleted vs. includedeleted 2020-03-05 15:48:50 +01:00
phl0
1aa2741351
Do not store div design in array 2020-03-05 15:22:36 +01:00
phl0
3f036e91d4
Fix error if nothing is selected at all in Awards 2020-03-05 15:16:46 +01:00
Peter Goodhall
5e8ca71d59 New DXCC modal wasn't getting log qso table name from config file 2020-03-03 14:50:59 +00:00
AndreasK79
e8941cf17d Reworked DXCC award. Changed look a bit, and added form for selection.
Setting of start/end in dxcc_entities was fixed as well. This is needed to be able to select/deselect deleted entites.
2020-03-03 12:39:45 +01:00
Peter Goodhall
a290fc5201 Update Dxcc.php 2019-12-03 19:06:19 +00:00
Peter Goodhall
c3da1f4418 only group by country on dxcc list 2019-12-03 19:04:44 +00:00
Peter Goodhall
cd42aef843 Add "Satellites" column to the DXCC table in the Awards selection 2019-12-03 17:36:35 +00:00
Peter Goodhall
0a03fa7fbf Awards are shown based on the active station profile 2019-09-25 00:05:45 +01:00
Peter Goodhall
46e7b87ffb Fixed error where old table was called 2019-06-24 17:34:01 +01:00
Tobias Mädel
a311be9dd2
fix undefined array index warning 2019-06-17 18:42:57 +02:00
Tobias Mädel
9e422756f9
removed hardcoded table name 2019-06-17 18:39:09 +02:00
Kim Huebel
5d31520faf Make Awards - DXCC to show only worked band-slots 2019-06-17 10:10:55 +02:00
Kim Huebel
cd4c752c8c Added more Band-Slots on DXCC-Statistics 2019-06-16 18:41:02 +02:00
Peter Goodhall
1ce6fdba73 Microwaves breaking DXCC Award chart fixed 2019-05-14 13:08:41 +01:00
Peter Goodhall
660ee53636 3cm causing error on dxcc awards tracking 2019-05-14 13:01:50 +01:00