Commit graph

14 commits

Author SHA1 Message Date
Peter Goodhall
44f15d5f55 Use primary key for eQSL batch updates
Refactor eQSL batch update to operate on resolved primary keys instead of re-matching QSOs by time/callsign/band/mode. Eqslmethods_model now queries current eQSL status by COL_PRIMARY_KEY, builds update batches keyed by primary key, and returns updated_ids and duplicate_ids. This avoids re-querying with un-normalized ADIF modes, improves reliability (avoids CI3 affected_rows() pitfalls), and makes duplicate detection deterministic. EqslImporter was updated to enqueue qso_id for batch updates and to mark QSOs as Updated or Already received based on the returned ID lists.
2026-03-18 15:29:10 +00:00
Peter Goodhall
b9d842ca47 Use correct eQSL received flag field
Fixes a bug where the wrong array key was checked when determining if an eQSL was received. The code previously used $record['qsl_sent']; it now checks $record['eqsl_qsl_rcvd'] to set $qsl_rcvd (or an empty string) using config['eqsl_rcvd_mark'], ensuring imports correctly mark received eQSLs.
2026-03-07 14:35:45 +00:00
Peter Goodhall
d4a7e4cfac Batch eQSL updates and add indexes
Add batch processing for eQSL imports/exports and introduce performance indexes. Bump migration_version to 248 and add Migration_add_eqsl_performance_indexes to create idx_eqsl_qslrdate and idx_eqsl_confirmation_match indexes to speed up eQSL queries and batch matching. Modify Eqsl controller to collect successful uploads and perform a single batch mark-as-sent update. Update EqslImporter to queue confirmations and run a single batch update at the end. Implement eqsl_update_batch() and eqsl_mark_sent_batch() in Eqslmethods_model to perform efficient batch DB operations and logging, reducing per-record queries for large eQSL operations.
2026-02-11 11:32:25 +00:00
Christoph Kottke
1d11d00ea8 add stations_id to eqsl functions 2024-02-05 21:59:52 +01:00
abarrau
57dc71292d
eqsl: add date force update 2023-10-02 20:50:23 +02:00
abarrau
d750a6cd4b
eqsl: add date force update 2023-10-02 20:43:37 +02:00
abarrau
8d0af35567
Update EqslImporter.php 2023-09-28 19:09:18 +02:00
Petr Kracík
059a0860af
eSQL: Security fix, use HTTPS to send password over the internet
Signed-off-by: Petr Kracík <petrkr@petrkr.net>
2023-08-29 17:58:22 +02:00
int2001
4c663bf514 Added MODE to matching from LotW/eQSL Confirmations 2023-07-05 17:13:17 +00:00
int2001
ca850adf22 Fixed #2238 2023-07-04 18:49:00 +00:00
Andreas
86312d16aa [eQSL] Refactored and moved stuff from logbook_model to eqslmethods_model 2023-05-06 11:35:09 +02:00
phl0
cab8f01c6c
Show link to eQSL image on import status page 2023-01-10 00:29:43 +01:00
Alessio Caiazza
d8c8260097
More robust error handling and cleanup 2022-09-22 08:58:25 +02:00
Alessio Caiazza
27a8d235fd
eQSL import from multiple QTH nicknames 2022-09-22 08:58:14 +02:00