mirror of
https://github.com/magicbug/Cloudlog
synced 2026-08-13 17:49:35 -04:00
897ba50c0e
Introduces a new section in the maintenance page allowing manual updates of reference data files (Clublog SCP, LoTW Users, DOK, SOTA, WWFF, POTA) via AJAX buttons with loading indicators. Adds corresponding UI-friendly controller methods with authorization checks and improves the WWFF update logic to process CSV files line by line for better memory efficiency.
230 lines
8.6 KiB
PHP
230 lines
8.6 KiB
PHP
<div class="container">
|
|
<br>
|
|
<?php if($this->session->flashdata('message')) { ?>
|
|
<!-- Display Message -->
|
|
<div class="alert-message error">
|
|
<p><?php echo $this->session->flashdata('message'); ?></p>
|
|
</div>
|
|
<?php } ?>
|
|
|
|
<h2><?php echo $page_title; ?></h2>
|
|
|
|
<style>
|
|
.htmx-indicator {
|
|
display: none;
|
|
}
|
|
.htmx-request .htmx-indicator {
|
|
display: inline-block;
|
|
}
|
|
.htmx-request.htmx-indicator {
|
|
display: inline-block;
|
|
}
|
|
</style>
|
|
|
|
<div class="card" style="margin-bottom: 15px;">
|
|
<div class="card-header">
|
|
QSO-DB Maintenance
|
|
</div>
|
|
<?php if(!empty($qsos_with_no_station_id)) { ?>
|
|
<div class="alert alert-danger" role="alert" style="margin-bottom: 0px !important;">
|
|
<span class="badge rounded-pill text-bg-warning">Warning</span> The Database contains <?php echo count($qsos_with_no_station_id); ?> QSO<?php echo count($qsos_with_no_station_id) > 1 ? 's' : '' ?> without a station-profile (location)<br/>
|
|
</div>
|
|
<div class="card-body">
|
|
<div class?"table-responsive">
|
|
<table id="unasigned_qsos_table" class="table table-sm table-striped">
|
|
<thead>
|
|
<tr>
|
|
<th scope="col"><input type="checkbox" onClick="toggleAll(this)"></th>
|
|
<th scope="col">Date</th>
|
|
<th scope="col">Time</th>
|
|
<th scope="col">Call</th>
|
|
<th scope="col">Mode</th>
|
|
<th scope="col">Band</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php if($this->session->userdata('user_date_format')) {
|
|
$custom_date_format = $this->session->userdata('user_date_format');
|
|
} else {
|
|
$custom_date_format = 'd.m.Y';
|
|
}
|
|
foreach ($qsos_with_no_station_id as $qso) {
|
|
echo '<tr>';
|
|
echo '<td><input type="checkbox" id="'.$qso->COL_PRIMARY_KEY.'" name="cBox[]" value="'.$qso->COL_PRIMARY_KEY.'"></td>';
|
|
$timestamp = strtotime($qso->COL_TIME_ON);
|
|
echo '<td>'.date($custom_date_format, $timestamp).'</td>';
|
|
$timestamp = strtotime($qso->COL_TIME_ON);
|
|
echo '<td>'.date('H:i', $timestamp).'</td>';
|
|
echo '<td>'.$qso->COL_CALL.'</td>';
|
|
echo '<td>'.$qso->COL_MODE.'</td>';
|
|
echo '<td>'.$qso->COL_BAND.'</td>';
|
|
echo '</tr>';
|
|
} ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<p class="card-text">Please reassign those QSOs to an existing station location:</p>
|
|
|
|
|
|
<div class="table-responsive">
|
|
<table id="station_locations_table" class="table table-sm table-striped">
|
|
<thead>
|
|
<tr>
|
|
<th scope="col">Call</th>
|
|
<th scope="col">Target Location</th>
|
|
<th scope="col">Reassign</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
foreach ($calls_wo_sid as $call) {
|
|
echo '<tr><td><div id="station_call">'.$call['COL_STATION_CALLSIGN'].'</div></td><td><select name="station_profile" id="station_profile" onChange="updateCallsign(this)">';
|
|
$options='';
|
|
foreach ($stations->result() as $station) {
|
|
$options.='<option value='.$station->station_id.'>'.$station->station_profile_name.' ('.$station->station_callsign.')</option>';
|
|
}
|
|
echo $options.'</select></td><td><button class="btn btn-warning" onClick="reassign(\''.$call['COL_STATION_CALLSIGN'].'\',$(\'#station_profile option:selected\').val());"><i class="fas fa-sync"></i> Reassign</a></button></td></tr>';
|
|
} ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
} else { ?>
|
|
<div class="alert alert-secondary" role="alert" style="margin-bottom: 0px !important;">
|
|
<span class="badge rounded-pill text-bg-success">Everything ok</span> Every QSO in your Database is assigned to a station-profile (location)
|
|
</div>
|
|
<?php } ?>
|
|
</div>
|
|
|
|
<div class="card" style="margin-bottom: 15px;">
|
|
<div class="card-header">
|
|
Settings Maintenance
|
|
</div>
|
|
<?php if(!$this->config->item('cl_multilanguage')) { ?>
|
|
<div class="alert alert-danger" role="alert" style="margin-bottom: 0px !important;">
|
|
<span class="badge rounded-pill text-bg-warning">Warning</span> You didn't enabled Multilanguage support in your config.php
|
|
</div>
|
|
<div class="card-body">
|
|
<p class="card-text">Please edit your ./application/config/config.php File and add some rows to it:</br></br>
|
|
Go to your application/config Folder and compare config.sample.php with your config.php</br>
|
|
You'll probably find a block with language-settings. Please include this block into your current config.php
|
|
</p>
|
|
</div>
|
|
|
|
<?php
|
|
} else { ?>
|
|
<div class="alert alert-secondary" role="alert" style="margin-bottom: 0px !important;">
|
|
<span class="badge rounded-pill text-bg-success">Everything ok</span> You have enabled Multuser-Language support
|
|
</div>
|
|
<?php } ?>
|
|
</div>
|
|
|
|
<div class="card">
|
|
<div class="card-header">
|
|
Data File Updates
|
|
</div>
|
|
<div class="card-body">
|
|
<p class="card-text">Manually update reference data files used by Cloudlog. These updates are normally run via cron, but you can trigger them manually here.</p>
|
|
|
|
<div class="table-responsive">
|
|
<table class="table table-sm">
|
|
<thead>
|
|
<tr>
|
|
<th scope="col">Data Source</th>
|
|
<th scope="col">Description</th>
|
|
<th scope="col">Action</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td><strong>Clublog SCP</strong></td>
|
|
<td>Super Check Partial callsign database</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/update_clublog_scp_ui'); ?>"
|
|
hx-target="#update-result-clublog"
|
|
hx-indicator="#spinner-clublog">
|
|
<i class="fas fa-sync"></i> Update Clublog SCP
|
|
</button>
|
|
<span id="spinner-clublog" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-clublog" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><strong>LoTW Users</strong></td>
|
|
<td>Active Logbook of the World users database</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/lotw_users_ui'); ?>"
|
|
hx-target="#update-result-lotw"
|
|
hx-indicator="#spinner-lotw">
|
|
<i class="fas fa-sync"></i> Update LoTW Users
|
|
</button>
|
|
<span id="spinner-lotw" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-lotw" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><strong>DOK</strong></td>
|
|
<td>German DOK and SDOK reference data</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/update_dok_ui'); ?>"
|
|
hx-target="#update-result-dok"
|
|
hx-indicator="#spinner-dok">
|
|
<i class="fas fa-sync"></i> Update DOK
|
|
</button>
|
|
<span id="spinner-dok" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-dok" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><strong>SOTA</strong></td>
|
|
<td>Summits on the Air reference data</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/update_sota_ui'); ?>"
|
|
hx-target="#update-result-sota"
|
|
hx-indicator="#spinner-sota">
|
|
<i class="fas fa-sync"></i> Update SOTA
|
|
</button>
|
|
<span id="spinner-sota" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-sota" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><strong>WWFF</strong></td>
|
|
<td>World Wide Flora & Fauna reference data</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/update_wwff_ui'); ?>"
|
|
hx-target="#update-result-wwff"
|
|
hx-indicator="#spinner-wwff">
|
|
<i class="fas fa-sync"></i> Update WWFF
|
|
</button>
|
|
<span id="spinner-wwff" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-wwff" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><strong>POTA</strong></td>
|
|
<td>Parks on the Air reference data</td>
|
|
<td>
|
|
<button class="btn btn-sm btn-primary"
|
|
hx-get="<?php echo site_url('update/update_pota_ui'); ?>"
|
|
hx-target="#update-result-pota"
|
|
hx-indicator="#spinner-pota">
|
|
<i class="fas fa-sync"></i> Update POTA
|
|
</button>
|
|
<span id="spinner-pota" class="htmx-indicator spinner-border spinner-border-sm ms-2" role="status"></span>
|
|
<div id="update-result-pota" class="mt-2"></div>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|