' +
'| ' + this.col_time_on + ' | ' +
'' + this.col_call + ' | ' +
'' + this.col_band + ' | ' +
'' + mode + ' | ' +
'' + this.col_rst_sent + ' | ' +
'' + this.col_rst_rcvd + ' | ' +
'' + this.col_stx_string + ' | ' +
'' + this.col_srx_string + ' | ' +
'' + this.col_stx + ' | ' +
'' + this.col_srx + ' | ' +
'' + this.col_gridsquare + ' | ' +
'' + this.col_vucc_grids + ' | ' +
'');
});
$.fn.dataTable.moment('DD-MM-YYYY HH:mm:ss');
$('.qsotable').DataTable({
"pageLength": 25,
responsive: false,
"scrollY": "400px",
"scrollCollapse": true,
"paging": false,
"scrollX": true,
"dom": 'rt<"bottom"i>',
"language": {
url: getDataTablesLanguageUrl(),
},
"search": { "search": $('#logbook-search').val() },
order: [0, 'desc'],
"columnDefs": [
{
"render": function (data, type, row) {
return pad(row[8], 3);
},
"targets": 8
},
{
"render": function (data, type, row) {
return pad(row[9], 3);
},
"targets": 9
}
]
});
$('#logbook-search').off('keyup.logbook').on('keyup.logbook', function () {
$('.qsotable').DataTable().search(this.value).draw();
});
updateContestStats(html);
updateTableColumns($('#exchangetype').val());
}
});
} else {
// Runs when no session is set usually when its a clean contest
var selectElement = document.getElementById('contestname');
var selected_contest_id = selectElement.options[selectElement.selectedIndex].value;
$.ajax({
url: base_url + 'index.php/contesting/getSessionFreshQsos',
type: 'post',
data: { 'contest_id': selected_contest_id },
success: function (html) {
// Destroy DataTables FIRST so DOM manipulation is clean
if ($.fn.DataTable.isDataTable('.qsotable')) {
$('.qsotable').DataTable().destroy();
}
var mode = '';
$(".contest_qso_table_contents").empty();
var dupeCounts = {};
$.each(html, function () {
var key = this.col_call + '|' + this.col_band + '|' + this.col_mode;
dupeCounts[key] = (dupeCounts[key] || 0) + 1;
});
$.each(html, function () {
if (this.col_submode == null || this.col_submode == '') {
mode = this.col_mode;
} else {
mode = this.col_submode;
}
var isDupe = dupeCounts[this.col_call + '|' + this.col_band + '|' + this.col_mode] > 1;
$(".qsotable tbody").prepend('' +
'' + this.col_time_on + ' | ' +
'' + this.col_call + ' | ' +
'' + this.col_band + ' | ' +
'' + mode + ' | ' +
'' + this.col_rst_sent + ' | ' +
'' + this.col_rst_rcvd + ' | ' +
'' + this.col_stx_string + ' | ' +
'' + this.col_srx_string + ' | ' +
'' + this.col_stx + ' | ' +
'' + this.col_srx + ' | ' +
'' + this.col_gridsquare + ' | ' +
'' + this.col_vucc_grids + ' | ' +
'');
});
$.fn.dataTable.moment('DD-MM-YYYY HH:mm:ss');
$('.qsotable').DataTable({
"pageLength": 25,
responsive: false,
"scrollY": "400px",
"scrollCollapse": true,
"paging": false,
"scrollX": true,
"dom": 'rt<"bottom"i>',
"language": {
url: getDataTablesLanguageUrl(),
},
"search": { "search": $('#logbook-search').val() },
order: [0, 'desc'],
"columnDefs": [
{
"render": function (data, type, row) {
return pad(row[8], 3);
},
"targets": 8
},
{
"render": function (data, type, row) {
return pad(row[9], 3);
},
"targets": 9
}
]
});
$('#logbook-search').off('keyup.logbook').on('keyup.logbook', function () {
$('.qsotable').DataTable().search(this.value).draw();
});
updateContestStats(html);
updateTableColumns($('#exchangetype').val());
}
});
}
}
function updateTableColumns(exchangetype) {
if (!$.fn.DataTable.isDataTable('.qsotable')) return;
var table = $('.qsotable').DataTable();
var showExch = ['Exchange', 'Serialexchange'].indexOf(exchangetype) !== -1;
var showSerial = ['Serial', 'Serialexchange', 'Serialgridsquare'].indexOf(exchangetype) !== -1;
var showGrid = ['Gridsquare', 'Serialgridsquare'].indexOf(exchangetype) !== -1;
table.column(6).visible(showExch, false);
table.column(7).visible(showExch, false);
table.column(8).visible(showSerial, false);
table.column(9).visible(showSerial, false);
table.column(10).visible(showGrid, false);
table.column(11).visible(showGrid, false);
table.draw(false);
}
function updateContestStats(qsoData) {
if (!qsoData || qsoData.length === 0) {
$('#contest-stats-card').hide();
return;
}
var bandOrder = ['160m','80m','60m','40m','30m','20m','17m','15m','12m','10m','6m','4m','2m','70cm','23cm'];
var bandCounts = {};
var now = new Date();
var cutoff = new Date(now.getTime() - 60 * 60 * 1000);
var recentCount = 0;
$.each(qsoData, function () {
var band = this.col_band || 'Unknown';
bandCounts[band] = (bandCounts[band] || 0) + 1;
// Parse col_time_on: format DD-MM-YYYY HH:mm:ss
var parts = this.col_time_on.match(/(\d{2})-(\d{2})-(\d{4}) (\d{2}):(\d{2}):(\d{2})/);
if (parts) {
var qsoTime = new Date(Date.UTC(
parseInt(parts[3]), parseInt(parts[2]) - 1, parseInt(parts[1]),
parseInt(parts[4]), parseInt(parts[5]), parseInt(parts[6])
));
if (qsoTime >= cutoff) {
recentCount++;
}
}
});
var total = qsoData.length;
$('#stats-total').text(total + (total === 1 ? ' QSO' : ' QSOs'));
$('#stats-rate').text(recentCount + '/hr');
// Build per-band badges in canonical order, then remaining bands alphabetically
var orderedBands = bandOrder.filter(function (b) { return bandCounts[b]; });
var extraBands = Object.keys(bandCounts).filter(function (b) { return bandOrder.indexOf(b) === -1; }).sort();
var allBands = orderedBands.concat(extraBands);
var html = allBands.map(function (b) {
return '' + b + ': ' + bandCounts[b] + '';
}).join('');
$('#stats-bands').html(html);
$('#contest-stats-card').show();
}
function pad(str, max) {
str = str.toString();
return str.length < max ? pad("0" + str, max) : str;
}
function getUTCTimeStamp(el) {
var now = new Date();
var localTime = now.getTime();
var utc = localTime + (now.getTimezoneOffset() * 60000);
$(el).attr('value', ("0" + now.getUTCHours()).slice(-2) + ':' + ("0" + now.getUTCMinutes()).slice(-2) + ':' + ("0" + now.getUTCSeconds()).slice(-2));
}
function getUTCDateStamp(el) {
var now = new Date();
var localTime = now.getTime();
var utc = localTime + (now.getTimezoneOffset() * 60000);
$(el).attr('value', ("0" + now.getUTCDate()).slice(-2) + '-' + ("0" + (now.getUTCMonth() + 1)).slice(-2) + '-' + now.getUTCFullYear());
}