This patch introduces a new query which can export all confirmed QSOs
for JCC award. It reuse some existing SQL logic of entity_status.
This new query addresses the issue of 1+N query and is expected to be
much faster.
Signed-off-by: ceba <ceba_robot@outlook.com>
This patch refactors the JCC summary and map generation in Jcc_model
to use the new entity_status query. Now all the JCC infomation relys on
a single query, which should be more efficient and easier to maintain.
Signed-off-by: ceba <ceba_robot@outlook.com>
This patch refactors the JCC array generation to use the new entity_status
query. Now only one query is needed to get all the necessary information
for the array(table).
This patch also remove the HTML generation from the model. The link will
be generated in the view using a helper function in future commits.
Signed-off-by: ceba <ceba_robot@outlook.com>
This patch refactors the entity_status query, which will be the basement
of array, summary and map generation.
Signed-off-by: ceba <ceba_robot@outlook.com>
It's not a good idea to maintain a huge data array in PHP models. This
patches moves the data to a separate JSON file.
Thanks to this change, the frontend JS could directly access the JSON
file, rather than asks PHP to generate them.
Signed-off-by: ceba <ceba_robot@outlook.com>
