Files
2026-05-06 11:04:41 +02:00

219 lines
18 KiB
PHP

<?= $this->extend('layouts/main') ?>
<?= $this->section('part_body') ?>
<div class="container" role="main" >
<!-- Page Header -->
<br />
<h3>Gestione Automobili Aziendali (CSiCoCars)</h3>
<br />
<!-- Introduzione tabella: -->
<p>Elenco di tutte le automobili aziendali (<?= $pager->getTotalRecords() ?> records) inserite, che soddisfano il filtro seguente:</p>
<?= $this->include('cmpnts/filter/filter_csicocar', ) ?>
<?= $pager->links() ?>
<!-- Tabella -->
<table class="table table-striped">
<thead class="thead-dark">
<tr>
<th>
<a data-toggle="tooltip" title="Order by ID <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caIDcar','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caIDcar'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
ID
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by Targa <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caTarga','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caTarga'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Targa
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by Descrizione <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caDescrizione','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caDescrizione'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Descrizione
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by Data Assicurazione <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caDataAssicurazione','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caDataAssicurazione'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Scadenza Assicurazione
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by Tipo Gomme <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caTipoGomme','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caTipoGomme'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Tipo Gomme
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by CreatedAt <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caCreatedAt','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caCreatedAt'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Created At
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by UpdatedAt <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caUpdatedAt','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caUpdatedAt'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Updated At
</a>
</th>
<th>
<a data-toggle="tooltip" title="Order by Stato <?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>" onclick="sort_tab('caStato','<?php echo ($sortDir=='ASC' ? 'DESC' : 'ASC'); ?>')">
<?php if ($sortCol=='caStato'): ?>
<?php if ($sortDir=='ASC'): ?>
<svg class="bi bi-arrow-up-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 5.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.646 4.646a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1-.708.708L8 5.707 5.354 8.354a.5.5 0 1 1-.708-.708l3-3z"/></svg>
<?php else: ?>
<svg class="bi bi-arrow-down-short" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M4.646 7.646a.5.5 0 0 1 .708 0L8 10.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z"/><path fill-rule="evenodd" d="M8 4.5a.5.5 0 0 1 .5.5v5a.5.5 0 0 1-1 0V5a.5.5 0 0 1 .5-.5z"/></svg>
<?php endif; ?>
<?php endif; ?>
Stato
</a>
</th>
<!-- <th>Comandi</th> -->
<th>
<button class="btn btn-success btn-sm" data-toggle="tooltip" title="Crea nuovo record" onclick="add_record()">
<!-- <svg class="bi bi-plus" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M8 3.5a.5.5 0 0 1 .5.5v4a.5.5 0 0 1-.5.5H4a.5.5 0 0 1 0-1h3.5V4a.5.5 0 0 1 .5-.5z"/><path fill-rule="evenodd" d="M7.5 8a.5.5 0 0 1 .5-.5h4a.5.5 0 0 1 0 1H8.5V12a.5.5 0 0 1-1 0V8z"/></svg> -->
Nuovo
</button>
</th>
</tr>
</thead>
<tbody>
<?php foreach ($dataset as $item) : ?>
<tr>
<td><?= $item->caIDcar ?></td>
<td><?= $item->caTarga ?></td>
<td><?= $item->caDescrizione ?></td>
<td><?= $item->caDataAssicurazione ?></td>
<td><?= $item->caTipoGomme ?></td>
<td><?= $item->caCreatedAt ?></td>
<td><?= $item->caUpdatedAt ?></td>
<td><?= $item->caStato ?></td>
<td>
<div class="btn-group" role="group" aria-label="Basic example">
<button type="button" class="btn btn-outline-success btn-sm" data-toggle="tooltip" title="Edit Record" onclick="edit_record('<?= $item->caIDcar ?>')">
<svg class="bi bi-pencil" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M11.293 1.293a1 1 0 0 1 1.414 0l2 2a1 1 0 0 1 0 1.414l-9 9a1 1 0 0 1-.39.242l-3 1a1 1 0 0 1-1.266-1.265l1-3a1 1 0 0 1 .242-.391l9-9zM12 2l2 2-9 9-3 1 1-3 9-9z"/><path fill-rule="evenodd" d="M12.146 6.354l-2.5-2.5.708-.708 2.5 2.5-.707.708zM3 10v.5a.5.5 0 0 0 .5.5H4v.5a.5.5 0 0 0 .5.5H5v.5a.5.5 0 0 0 .5.5H6v-1.5a.5.5 0 0 0-.5-.5H5v-.5a.5.5 0 0 0-.5-.5H3z"/></svg>
</button>
<button type="button" class="btn btn-outline-danger btn-sm" data-toggle="tooltip" title="Delete Record" onclick="delete_record('<?= $item->caIDcar ?>')">
<svg class="bi bi-trash" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path d="M5.5 5.5A.5.5 0 0 1 6 6v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5zm2.5 0a.5.5 0 0 1 .5.5v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5zm3 .5a.5.5 0 0 0-1 0v6a.5.5 0 0 0 1 0V6z"/><path fill-rule="evenodd" d="M14.5 3a1 1 0 0 1-1 1H13v9a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V4h-.5a1 1 0 0 1-1-1V2a1 1 0 0 1 1-1H6a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1h3.5a1 1 0 0 1 1 1v1zM4.118 4L4 4.059V13a1 1 0 0 0 1 1h6a1 1 0 0 0 1-1V4.059L11.882 4H4.118zM2.5 3V2h11v1h-11z"/></svg>
</button>
<button type="button" class="btn btn-outline-warning btn-sm" data-toggle="tooltip" title="Select Record" onclick="select_record('<?= $item->caIDcar ?>')">
<svg class="bi bi-card-list" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14.5 3h-13a.5.5 0 0 0-.5.5v9a.5.5 0 0 0 .5.5h13a.5.5 0 0 0 .5-.5v-9a.5.5 0 0 0-.5-.5zm-13-1A1.5 1.5 0 0 0 0 3.5v9A1.5 1.5 0 0 0 1.5 14h13a1.5 1.5 0 0 0 1.5-1.5v-9A1.5 1.5 0 0 0 14.5 2h-13z"/><path fill-rule="evenodd" d="M5 8a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7A.5.5 0 0 1 5 8zm0-2.5a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5zm0 5a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5z"/><circle cx="3.5" cy="5.5" r=".5"/><circle cx="3.5" cy="8" r=".5"/><circle cx="3.5" cy="10.5" r=".5"/></svg>
</button>
</div>
</td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<?= $pager->links() ?>
<br />
<br />
<p>
Per esportare tutti gli csicocars che soddisfano il filtro indicato:
<button class="btn btn-success btn-sm" data-toggle="tooltip" title="Esporta i records in CSV" onclick="export_records_csv()">
<svg class="bi bi-cloud-download" width="1em" height="1em" viewBox="0 0 16 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg"><path d="M4.887 5.2l-.964-.165A2.5 2.5 0 1 0 3.5 10H6v1H3.5a3.5 3.5 0 1 1 .59-6.95 5.002 5.002 0 1 1 9.804 1.98A2.501 2.501 0 0 1 13.5 11H10v-1h3.5a1.5 1.5 0 0 0 .237-2.981L12.7 6.854l.216-1.028a4 4 0 1 0-7.843-1.587l-.185.96z"/><path fill-rule="evenodd" d="M5 12.5a.5.5 0 0 1 .707 0L8 14.793l2.293-2.293a.5.5 0 1 1 .707.707l-2.646 2.646a.5.5 0 0 1-.708 0L5 13.207a.5.5 0 0 1 0-.707z"/><path fill-rule="evenodd" d="M8 6a.5.5 0 0 1 .5.5v8a.5.5 0 0 1-1 0v-8A.5.5 0 0 1 8 6z"/></svg>
CSV
</button>
</p>
<br />
</div>
<script type="text/javascript">
function add_record() {
//alert("\r\n TASK TODO \r\n\r\n <?php echo base_url('/CSiCoCars/add/'); ?>");
window.location = "<?php echo base_url('/CSiCoCars/add/'); ?>";
}
function edit_record(id) {
//alert("\r\n TASK TODO \r\n\r\n <?php echo base_url('/CSiCoCars/edit/'); ?>/" + id);
window.location = "<?php echo base_url('/CSiCoCars/edit/'); ?>/" + id;
}
function delete_record(id) {
var cnfrm = confirm('Confermi la cancellazione del record ' + id + ' ?');
if (cnfrm) {
//alert("\r\n TASK TODO \r\n\r\n <?php echo base_url('/CSiCoCars/delete/'); ?>/" + id);
window.location = "<?php echo base_url('/CSiCoCars/delete/'); ?>/" + id;
}
}
function select_record(id) {
//alert("\r\n TASK TODO \r\n\r\n <?php echo base_url('/CSiCoCars/select/'); ?>/" + id);
window.location = "<?php echo base_url('/CSiCoCars/select/'); ?>/" + id;
}
function export_records_csv(){
var cnfrm = confirm('Confermi la richiesta di esportare i valori filtrati ?\r\n L\'operazione potrebbe richiedere del tempo.');
if (cnfrm) {
//alert("\r\n TASK TODO \r\n\r\n <?php echo base_url('/CSiCoCars/export_csv/'); ?>");
window.location = "<?php echo base_url('/CSiCoCars/export_csv/'); ?>";
}
}
function sort_tab(field, val){
//alert("<?php echo base_url('/CSiCoCars/set_order/cars'); ?>/" + field + "/" + val);
window.location = "<?php echo base_url('/dashboard/set_order/cars'); ?>/" + field + "/" + val;
}
</script>
<?= $this->endSection() ?>