[Advanced Logbook] Started on dbtools

wavelog · AndreasK79 · Dec 2, 2025 · Dec 7, 2025 · Dec 7, 2025 · Dec 7, 2025
commit 969b079ae7848d26bc4f4d96c3bdef06b4db71a9
diff --git a/application/controllers/Logbookadvanced.php b/application/controllers/Logbookadvanced.php
@@ -884,4 +884,19 @@ public function updateDistances() {
 	public function callbookDialog() {
 		$this->load->view('logbookadvanced/callbookdialog');
 	}
+
+	public function dbtoolsDialog() {
+		$this->load->view('logbookadvanced/dbtoolsdialog');
+	}
+
+	public function checkDb() {
+		if(!clubaccess_check(9)) return;
+
+		$type = $this->input->post('type', true);
+
+		$this->load->model('logbookadvanced_model');
+		$result = $this->logbookadvanced_model->runCheckDb($type);
+		header("Content-Type: application/json");
+		print json_encode($result);
+	}
 }
diff --git a/application/models/Logbookadvanced_model.php b/application/models/Logbookadvanced_model.php
@@ -1446,4 +1446,19 @@ public function update_distances_batch() {
 
 		return $recordcount;
 	}
+
+	public function runCheckDb($type) {
+		$this->load->model('logbooks_model');
+		$logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($this->session->userdata('active_station_logbook'));
+
+		$sql = "select count(*) as count from " . $this->config->item('table_name') . "
+		join station_profile on " . $this->config->item('table_name') . ".station_id = station_profile.station_id
+		where " . $this->config->item('table_name') . ".station_id in (" . implode(',', array_map('intval', $logbooks_locations_array)) . ")
+		and user_id = ? and coalesce(col_distance, '') = ''";
+
+		$bindings[] = [$this->session->userdata('user_id')];
+
+		$query = $this->db->query($sql, $bindings);
+		return $query->result();
+	}
 }
diff --git a/application/views/logbookadvanced/dbtoolsdialog.php b/application/views/logbookadvanced/dbtoolsdialog.php
@@ -0,0 +1,117 @@
+<div class="container">
+    <div class="row">
+        <div class="col-md-6">
+            <h5><?= __("Data Repair Tools") ?></h5>
+            <div class="list-group">
+                <div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Fix CQ Zones") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Update missing or incorrect CQ zone information") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkFixCqZonesBtn" onclick="checkFixCqZones()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="fixCqZonesBtn" onclick="runFixCqZones()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+                <div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Fix ITU Zones") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Update missing or incorrect ITU zone information") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkFixItuZonesBtn" onclick="checkFixItuZones()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="fixItuZonesBtn" onclick="runFixItuZones()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+                <div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Fix Continent") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Update missing or incorrect continent information") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkFixContinentBtn" onclick="checkFixContinent()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="fixContinentBtn" onclick="runFixContinent()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+                <div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Fix State") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Update missing or incorrect state/province information") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkFixStateBtn" onclick="checkFixState()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="fixStateBtn" onclick="runFixState()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+                <div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Update Distances") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Calculate and update distance information for QSOs") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkUpdateDistancesBtn" onclick="checkUpdateDistances()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="updateDistancesBtn" onclick="runUpdateDistances()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+				<div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Check QSOs missing DXCC data") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Identify QSOs that are missing DXCC information") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkUpdateDistancesBtn" onclick="checkUpdateDistances()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="updateDistancesBtn" onclick="runUpdateDistances()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+				<div class="list-group-item d-flex justify-content-between align-items-center">
+                    <div>
+                        <h6 class="mb-1"><?= __("Re-check DXCC for all QSOs in the logbook") ?></h6>
+                        <p class="mb-1 small text-muted"><?= __("Use Wavelog to determine DXCC for all QSOs. This will overwrite existing DXCC information.") ?></p>
+                    </div>
+                    <div class="d-flex nowrap">
+                        <button type="button" class="btn btn-sm btn-secondary me-1" id="checkUpdateDistancesBtn" onclick="checkUpdateDistances()">
+                            <?= __("Check") ?>
+                        </button>
+                        <button type="button" class="btn btn-sm btn-primary" id="updateDistancesBtn" onclick="runUpdateDistances()">
+                            <?= __("Run") ?>
+                        </button>
+                    </div>
+                </div>
+
+            </div>
+        </div>
+		<div class="col-md-6 result"></div>
+
+
+    </div>
+</div>
diff --git a/application/views/logbookadvanced/index.php b/application/views/logbookadvanced/index.php
@@ -771,6 +771,7 @@
 									<button type="button" class="btn btn-sm btn-success dropdown-action" id="fixContinent"><?= __("Fix Continent"); ?></button>
 									<button type="button" class="btn btn-sm btn-success dropdown-action" id="fixState"><?= __("Fix State"); ?></button>
 									<button type="button" class="btn btn-sm btn-success dropdown-action" id="updateDistances"><?= __("Update Distances"); ?></button>
+									<button type="button" class="btn btn-sm btn-success dropdown-action" id="dbtools"><?= __("Database Tools"); ?></button>
 									</div>
 								</div>
 							</div>

diff --git a/assets/js/sections/logbookadvanced.js b/assets/js/sections/logbookadvanced.js
@@ -1335,6 +1335,31 @@ $(document).ready(function () {
 		});
 	});
 
+	$('#dbtools').click(function (event) {
+		$.ajax({
+			url: base_url + 'index.php/logbookadvanced/dbtoolsDialog',
+			type: 'post',
+			success: function (html) {
+				BootstrapDialog.show({
+					title: 'Database tools',
+					size: BootstrapDialog.SIZE_WIDE,
+					cssClass: 'options',
+					nl2br: false,
+					message: html,
+					buttons: [
+					{
+						label: lang_admin_close,
+						cssClass: 'btn btn-sm btn-secondary',
+						id: 'closeButton',
+						action: function (dialogItself) {
+							dialogItself.close();
+						}
+					}],
+				});
+			}
+		});
+	});
+
 	function runUpdateDistancesFix(dialogItself) {
 		$('#updateDistanceButton').prop("disabled", true).addClass("running");
 		$('#closeButton').prop("disabled", true);
@@ -2002,3 +2027,43 @@ function saveOptions() {
         dateFrom.value = '';
         dateTo.value = '';
     }
+
+	function checkUpdateDistances() {
+		$('#checkUpdateDistancesBtn').prop("disabled", true).addClass("running");
+		$('#closeButton').prop("disabled", true);
+
+
+		$.ajax({
+		url: base_url + 'index.php/logbookadvanced/checkDb',
+		data: {
+			type: 'distance'
+		},
+		type: 'POST',
+		success: function(response) {
+			$('#checkUpdateDistancesBtn').prop("disabled", false).removeClass("running");
+			$('#closeButton').prop("disabled", false);
+			// Create a nice display for the results
+			let resultHtml = '<h6>Distance Check Results</h6>';
+			resultHtml += '<p><strong>QSO to update found:</strong> ' + (response[0].count) + '</p>';
+
+			$('.result').html(resultHtml);
+		},
+		error: function(xhr, status, error) {
+			$('#checkUpdateDistancesBtn').prop('disabled', false).text('<?= __("Check") ?>');
+			$('#closeButton').prop('disabled', false);
+
+			let errorMsg = '<?= __("Error checking distance information") ?>';
+			if (xhr.responseJSON && xhr.responseJSON.message) {
+				errorMsg += ': ' + xhr.responseJSON.message;
+			}
+
+			BootstrapDialog.alert({
+				title: '<?= __("Error") ?>',
+				message: errorMsg,
+				type: BootstrapDialog.TYPE_DANGER
+			});
+		}
+	});
+
+
+	}