258 lines
9.5 KiB
PHP
258 lines
9.5 KiB
PHP
<?php
|
|
require_once 'layout_header.php';
|
|
require_once 'db/config.php';
|
|
|
|
$month = isset($_GET['month']) ? $_GET['month'] : date('m');
|
|
$year = isset($_GET['year']) ? $_GET['year'] : date('Y');
|
|
|
|
$days_in_month = cal_days_in_month(CAL_GREGORIAN, $month, $year);
|
|
|
|
$provincias = ['LIMA', 'AREQUIPA', 'TRUJILLO', 'ICA', 'CUSCO', 'CAJAMARCA', 'CHICLAYO', 'PIURA'];
|
|
|
|
// Fetch data for the month
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare("SELECT fecha, provincia, monto, estado FROM liquidaciones_provincia WHERE MONTH(fecha) = ? AND YEAR(fecha) = ?");
|
|
$stmt->execute([$month, $year]);
|
|
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
// Organize data for easy access
|
|
$liquidaciones = [];
|
|
foreach ($data as $row) {
|
|
$liquidaciones[$row['fecha']][$row['provincia']] = [
|
|
'monto' => $row['monto'],
|
|
'estado' => $row['estado']
|
|
];
|
|
}
|
|
|
|
?>
|
|
|
|
<style>
|
|
.table thead th {
|
|
background-color: #337ab7;
|
|
color: #ffffff;
|
|
font-weight: 600;
|
|
position: sticky;
|
|
top: 0;
|
|
z-index: 10;
|
|
}
|
|
.table tfoot th {
|
|
position: sticky;
|
|
bottom: 0;
|
|
background-color: #e9ecef;
|
|
z-index: 10;
|
|
font-weight: 700;
|
|
}
|
|
.editable-cell {
|
|
cursor: pointer;
|
|
}
|
|
.editable-cell input {
|
|
width: 100%;
|
|
box-sizing: border-box;
|
|
border: 1px solid #007bff;
|
|
font: inherit;
|
|
padding: 0.75rem;
|
|
}
|
|
</style>
|
|
|
|
<div class="container-fluid mt-4">
|
|
<h2>Liquidaciones Provincia</h2>
|
|
<p>Haz clic en una celda de "Monto" o "Estado" para editarla. Presiona "Enter" o haz clic fuera para guardar.</p>
|
|
|
|
<form method="GET" action="liquidaciones_provincia.php" class="form-inline mb-4">
|
|
<div class="form-group mr-2">
|
|
<label for="month" class="mr-2">Mes:</label>
|
|
<select name="month" id="month" class="form-control">
|
|
<?php for ($m = 1; $m <= 12; $m++): ?>
|
|
<option value="<?php echo str_pad($m, 2, '0', STR_PAD_LEFT); ?>" <?php echo $m == $month ? 'selected' : ''; ?>>
|
|
<?php echo DateTime::createFromFormat('!m', $m)->format('F'); ?>
|
|
</option>
|
|
<?php endfor; ?>
|
|
</select>
|
|
</div>
|
|
<div class="form-group mr-2">
|
|
<label for="year" class="mr-2">Año:</label>
|
|
<select name="year" id="year" class="form-control">
|
|
<?php for ($y = date('Y'); $y >= date('Y') - 5; $y--): ?>
|
|
<option value="<?php echo $y; ?>" <?php echo $y == $year ? 'selected' : ''; ?>><?php echo $y; ?></option>
|
|
<?php endfor; ?>
|
|
</select>
|
|
</div>
|
|
<button type="submit" class="btn btn-primary">Filtrar</button>
|
|
</form>
|
|
|
|
<div class="table-responsive" style="max-height: 70vh; overflow-y: auto;">
|
|
<table class="table table-bordered table-striped table-hover" style="width: 100%;">
|
|
<thead>
|
|
<tr>
|
|
<th>Fecha</th>
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
<th><?php echo htmlspecialchars($provincia); ?></th>
|
|
<th>ESTADO</th>
|
|
<?php endforeach; ?>
|
|
</tr>
|
|
</thead>
|
|
<tbody id="liquidaciones-tbody">
|
|
<?php for ($day = 1; $day <= $days_in_month; $day++): ?>
|
|
<?php $date = date('Y-m-d', strtotime("$year-$month-$day")); ?>
|
|
<tr data-date="<?php echo $date; ?>">
|
|
<td><?php echo $date; ?></td>
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
<?php
|
|
$monto = isset($liquidaciones[$date][$provincia]['monto']) ? number_format($liquidaciones[$date][$provincia]['monto'], 2, '.', '') : '0.00';
|
|
$estado = isset($liquidaciones[$date][$provincia]['estado']) ? htmlspecialchars($liquidaciones[$date][$provincia]['estado']) : '';
|
|
?>
|
|
<td class="editable-cell" data-provincia="<?php echo htmlspecialchars($provincia); ?>" data-column="monto"><?php echo $monto; ?></td>
|
|
<td class="editable-cell" data-provincia="<?php echo htmlspecialchars($provincia); ?>" data-column="estado"><?php echo $estado; ?></td>
|
|
<?php endforeach; ?>
|
|
</tr>
|
|
<?php endfor; ?>
|
|
</tbody>
|
|
<tfoot>
|
|
<tr>
|
|
<th>TOTAL</th>
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
<th data-total-column="<?php echo htmlspecialchars($provincia); ?>">0.00</th>
|
|
<th></th>
|
|
<?php endforeach; ?>
|
|
</tr>
|
|
</tfoot>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
|
|
<script>
|
|
document.addEventListener('DOMContentLoaded', function() {
|
|
const tableBody = document.getElementById('liquidaciones-tbody');
|
|
let activeInput = null;
|
|
|
|
function calculateTotals() {
|
|
const totals = {};
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
totals['<?php echo $provincia; ?>'] = 0;
|
|
<?php endforeach; ?>
|
|
|
|
tableBody.querySelectorAll('tr').forEach(row => {
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
const cell = row.querySelector(`td[data-provincia="<?php echo $provincia; ?>"][data-column="monto"]`);
|
|
if (cell) {
|
|
const value = parseFloat(cell.textContent.replace(/,/g, '')) || 0;
|
|
totals['<?php echo $provincia; ?>'] += value;
|
|
}
|
|
<?php endforeach; ?>
|
|
});
|
|
|
|
<?php foreach ($provincias as $provincia): ?>
|
|
const totalCell = document.querySelector(`tfoot th[data-total-column="<?php echo $provincia; ?>"]`);
|
|
if (totalCell) {
|
|
totalCell.textContent = totals['<?php echo $provincia; ?>'].toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ",");
|
|
}
|
|
<?php endforeach; ?>
|
|
}
|
|
|
|
calculateTotals();
|
|
|
|
function turnCellIntoInput(cell) {
|
|
if (cell.querySelector('input')) return; // Already an input
|
|
|
|
const originalValue = cell.textContent.trim();
|
|
cell.setAttribute('data-original-value', originalValue);
|
|
cell.innerHTML = '';
|
|
|
|
const input = document.createElement('input');
|
|
input.type = cell.dataset.column === 'monto' ? 'number' : 'text';
|
|
input.className = 'form-control form-control-sm';
|
|
input.value = originalValue;
|
|
|
|
cell.appendChild(input);
|
|
input.focus();
|
|
activeInput = input;
|
|
|
|
input.addEventListener('blur', () => saveChanges(input));
|
|
input.addEventListener('keydown', (e) => {
|
|
if (e.key === 'Enter') {
|
|
e.preventDefault();
|
|
saveChanges(input);
|
|
} else if (e.key === 'Escape') {
|
|
const original = cell.getAttribute('data-original-value');
|
|
cell.innerHTML = original;
|
|
activeInput = null;
|
|
}
|
|
});
|
|
}
|
|
|
|
function saveChanges(input) {
|
|
if (!input) return;
|
|
|
|
const cell = input.parentElement;
|
|
const originalValue = cell.getAttribute('data-original-value');
|
|
const newValue = input.value.trim();
|
|
|
|
activeInput = null;
|
|
cell.innerHTML = newValue; // Optimistic update
|
|
|
|
if (newValue === originalValue) {
|
|
return; // No change
|
|
}
|
|
|
|
const row = cell.closest('tr');
|
|
const fecha = row.dataset.date;
|
|
const provincia = cell.dataset.provincia;
|
|
const columna = cell.dataset.column;
|
|
|
|
let finalValue = newValue;
|
|
if (columna === 'monto') {
|
|
let numValue = parseFloat(newValue.replace(/,/g, ''));
|
|
if (isNaN(numValue)) numValue = 0;
|
|
finalValue = numValue.toFixed(2);
|
|
cell.innerHTML = finalValue; // Show formatted value
|
|
}
|
|
|
|
const formData = new URLSearchParams();
|
|
formData.append('fecha', fecha);
|
|
formData.append('provincia', provincia);
|
|
formData.append('columna', columna);
|
|
formData.append('valor', finalValue);
|
|
|
|
fetch('save_liquidaciones_provincia.php', {
|
|
method: 'POST',
|
|
headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
|
|
body: formData
|
|
})
|
|
.then(response => response.json())
|
|
.then(result => {
|
|
if (result.success) {
|
|
if (columna === 'monto') calculateTotals();
|
|
} else {
|
|
alert('Error al guardar: ' + (result.message || 'Error desconocido'));
|
|
cell.innerHTML = originalValue; // Revert on failure
|
|
if (columna === 'monto') calculateTotals();
|
|
}
|
|
})
|
|
.catch(error => {
|
|
alert('Error de conexión. No se pudieron guardar los cambios.');
|
|
cell.innerHTML = originalValue; // Revert on failure
|
|
if (columna === 'monto') calculateTotals();
|
|
});
|
|
}
|
|
|
|
// --- Event Delegation ---
|
|
tableBody.addEventListener('click', function(e) {
|
|
const targetCell = e.target.closest('.editable-cell');
|
|
|
|
if (!targetCell) return;
|
|
|
|
// If we are clicking a cell but another one is being edited, save the other one first.
|
|
if (activeInput && activeInput.parentElement !== targetCell) {
|
|
saveChanges(activeInput);
|
|
}
|
|
|
|
// Now, turn the clicked cell into an input.
|
|
turnCellIntoInput(targetCell);
|
|
});
|
|
});
|
|
</script>
|
|
|
|
<?php
|
|
require_once 'layout_footer.php';
|
|
?>
|