mirror of
https://github.com/magicbug/Cloudlog
synced 2026-08-13 17:49:35 -04:00
c3a5410805
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. |
||
|---|---|---|
| .. | ||
| counties | ||
| cq | ||
| dok | ||
| dxcc | ||
| ffma | ||
| gmdxsummer | ||
| gridmaster | ||
| iota | ||
| pota | ||
| sig | ||
| sota | ||
| vucc | ||
| wab | ||
| waja | ||
| was | ||
| wwff | ||
| details.php | ||
| index.php | ||
| settings.php | ||