8 commits

Author	SHA1	Message	Date
Peter Goodhall	c3a5410805	Normalize county/state fields and use in queries ... Normalize COL_CNTY/COL_STATE handling and use normalized expressions in queries to ensure consistent grouping/filtering and avoid mismatches. - application/models/Counties.php: add normalized SQL expressions (trim/case/substring) and apply them to counting, grouping and ordering queries; filter out empty normalized states and adjust joins to compare normalized values. - application/models/Logbook_model.php: normalize incoming $county/$state, add dxcc_entities join and selects, and use normalized WHERE clauses (case/trim and substring for 'ST, County' formats); also standardize band filter to COL_BAND != 'SAT'. - application/views/view_log/partial/log_ajax.php: avoid undefined property notices by checking for name/end on the row object and use those values for Country and Flag display. These changes address inconsistent imported county/state formats (e.g. "ST, County"), whitespace/case variations, and prevent PHP notices while keeping query semantics intact.	2026-03-24 16:04:23 +00:00
Andreas	de2a0ddaa9	[Bands] US Counties support added	2022-09-07 09:44:22 +02:00
Andreas	8c7fa355fb	[Awards] Fixed implode error when logbook is empty	2021-11-14 17:11:59 +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	9f6feb24a5	[US Counties Award] Updated code to support station logbooks	2021-09-09 22:43:29 +02:00
Andreas	164a395b76	[Award US counties] A small SQL fix if when sql_mode=only_full_group_by is on. Fixed #1037	2021-05-22 08:47:24 +02:00
Andreas	7642ab874f	[Awards][US Counties] Can see list of counties now, and QSOs when clicked on county.	2021-02-07 15:22:03 +01:00
Andreas	e558abf890	[Awards][US Counties] Added US Counties Award. Only totals so far.	2021-02-07 00:03:05 +01:00