Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
CALIDADWEB
/
CALIDADWEB
/
FRONTED
/
CONTROLTABLAS.JS
:
FOR-S-CCI-89.js
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
$(document).ready(function () { $(".btnConChillVerifi").click(function (e) { e.preventDefault(); swal.fire({ title: "Cargando datos...", allowOutsideClick: false, didOpen: () => { swal.showLoading(); } }); if ($.fn.DataTable.isDataTable('#tblconChillVerifi')) { $('#tblconChillVerifi').DataTable().destroy(); } let tablalimpieza = $("#tblconChillVerifi").DataTable({ "ajax": { "url": "../../BACKEND/controltablas/FOR-S-CCI-89.php", "type": "POST", "data": { opcion: 1 }, "dataSrc": "" }, "columns": [ { data: "ID" }, { data: "FECHA" }, { data: "HORA" }, { data: "TIPOAVE" }, { data: "C1" }, { data: "C2" }, { data: "C3" }, { data: "C4" }, { data: "C5" }, { data: "C6" }, { data: "C7" }, { data: "C8" }, { data: "C9" }, { data: "C10" }, { data: "C11" }, { data: "C12" }, { data: "C13" }, { data: "C14" }, { data: "C15" }, { data: "C16" }, { data: "C17" }, { data: "trazabilidad" }, { data: "tempPromedio" }, { data: "OBSERVACIONES" }, { data: "RESPONS_OBSER" }, { data: "aprobo" }, { "data": null, "orderable": false, "width": "80px", "className": "text-center", "render": function () { return "<button class='btn btn-danger btn-sm btnBorrar'><i class='fas fa-trash-alt'></i></button>"; } }, { "data": null, "orderable": false, "width": "80px", "className": "text-center", "render": function (data, type, row) { // Cambiado data-id a row.ID return "<button class='btn btn-primary btn-sm btnEditar' data-id='" + row.ID + "'><i class='fas fa-edit'></i></button>"; } } ], "language": { "url": "//cdn.datatables.net/plug-ins/1.10.20/i18n/Spanish.json" }, "scrollX": true, "scrollCollapse": true, "autoWidth": false, "dom": "Bfrtip", "buttons": [ { extend: "pageLength", className: "btn btn-warning" }, { extend: "excelHtml5", autoFilter: true, sheetName: "CONTROL DEFECTOS CANAL SALIDA CHILLER", title: "CONTROL DEFECTOS CANAL SALIDA CHILLER", text: '<i class="fa-lg fa-solid fa-file-excel"></i> GENERAR EXCEL', className: "btn btn-success", exportOptions: { columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25] } } ], "initComplete": function () { swal.close(); } }); // --- ELIMINAR --- $('#tblconChillVerifi tbody').off('click', '.btnBorrar').on('click', '.btnBorrar', function (e) { e.preventDefault(); let data = tablalimpieza.row($(this).parents('tr')).data(); swal.fire({ title: "¿Eliminar registro?", text: "ID: " + data.ID, // Unificado icon: "warning", showCancelButton: true, confirmButtonColor: "#d33", confirmButtonText: "Sí, borrar" }).then((result) => { if (result.isConfirmed) { $.ajax({ url: "../../BACKEND/controltablas/FOR-S-CCI-89.php", type: "POST", data: { opcion: 3, id: data.ID }, // Enviamos data.ID success: function () { tablalimpieza.ajax.reload(null, false); swal.fire("¡Éxito!", "Registro eliminado", "success"); } }); } }); }); // --- EDITAR --- $('#tblconChillVerifi tbody').off('click', '.btnEditar').on('click', '.btnEditar', function (e) { e.preventDefault(); let $row = $(this).closest('tr'); $row.find('td').each(function (index) { if (index > 0 && index < 26) { let valorActual = $(this).text(); let nombreColumna = tablalimpieza.settings().init().columns[index].data; // Agregamos un estilo inline "width: 100%" y un contenedor pequeño $(this).html(` <input type="text" class="form-control form-control-sm" style="min-width: 70px; width: 100%; padding: 2px;" value="${valorActual}" data-campo="${nombreColumna}"> `); } }); $(this).removeClass('btn-primary btnEditar').addClass('btn-success btnGuardar').html('<i class="fas fa-save"></i>'); $row.find('.btnBorrar').removeClass('btn-danger btnBorrar').addClass('btn-secondary btnCancelar').html('<i class="fas fa-times"></i>'); }); // --- GUARDAR --- $('#tblconChillVerifi tbody').off('click', '.btnGuardar').on('click', '.btnGuardar', function (e) { e.preventDefault(); let $row = $(this).closest('tr'); let dataRow = tablalimpieza.row($row).data(); let datosActualizados = { opcion: 4, id: dataRow.ID }; // Unificado a ID $row.find('input').each(function () { let campo = $(this).data('campo'); let valor = $(this).val(); if (campo) datosActualizados[campo] = valor; }); $.ajax({ url: "../../BACKEND/controltablas/FOR-S-CCI-89.php", type: "POST", data: datosActualizados, success: function () { tablalimpieza.ajax.reload(null, false); swal.fire("¡Éxito!", "Registro actualizado", "success"); } }); }); // --- CANCELAR --- $('#tblconChillVerifi tbody').off('click', '.btnCancelar').on('click', '.btnCancelar', function (e) { e.preventDefault(); tablalimpieza.ajax.reload(null, false); }); }); }); /* DOS */ $(document).ready(function () { $(".btnConChiller").click(function (e) { e.preventDefault(); swal.fire({ title: "Cargando datos...", allowOutsideClick: false, didOpen: () => { swal.showLoading(); } }); if ($.fn.DataTable.isDataTable('#tblConChiller')) { $('#tblConChiller').DataTable().destroy(); } let tablalimpieza = $("#tblConChiller").DataTable({ "ajax": { "url": "../../BACKEND/controltablas/FOR-S-CCI-89.php", "type": "POST", "data": { opcion: 2 }, "dataSrc": "" }, "columns": [ { data: "ID" }, { data: "FECHA" }, { data: "HORA" }, { data: "TIPO_AVE" }, { data: "C1" }, { data: "C2" }, { data: "C3" }, { data: "C4" }, { data: "C5" }, { data: "C6" }, { data: "C7" }, { data: "C8" }, { data: "C9" }, { data: "C10" }, { data: "TEMP_PROM" }, { data: "PORCENT_CUMPLI" }, { data: "PH" }, { data: "TEMP_PRECHILL" }, { data: "REGISCLORO" }, { data: "RESPONS" }, { data: "CODIGO" }, { data: "observaciones" }, { data: "aprobo" }, { "data": null, "orderable": false, "width": "80px", "className": "text-center", "render": function () { return "<button class='btn btn-danger btn-sm btnBorrar'><i class='fas fa-trash-alt'></i></button>"; } }, { "data": null, "orderable": false, "width": "80px", "className": "text-center", "render": function (data, type, row) { // Cambiado data-id a row.ID return "<button class='btn btn-primary btn-sm btnEditar' data-id='" + row.ID + "'><i class='fas fa-edit'></i></button>"; } } ], "language": { "url": "//cdn.datatables.net/plug-ins/1.10.20/i18n/Spanish.json" }, "scrollX": true, "scrollCollapse": true, "autoWidth": false, "dom": "Bfrtip", "buttons": [ { extend: "pageLength", className: "btn btn-warning" }, { extend: "excelHtml5", autoFilter: true, sheetName: "CONTROL DEFECTOS CANAL SALIDA CHILLER", title: "CONTROL DEFECTOS CANAL SALIDA CHILLER", text: '<i class="fa-lg fa-solid fa-file-excel"></i> GENERAR EXCEL', className: "btn btn-success", exportOptions: { columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22] } } ], "initComplete": function () { swal.close(); } }); // --- ELIMINAR --- $('#tblConChiller tbody').off('click', '.btnBorrar').on('click', '.btnBorrar', function (e) { e.preventDefault(); let data = tablalimpieza.row($(this).parents('tr')).data(); swal.fire({ title: "¿Eliminar registro?", text: "ID: " + data.ID, // Unificado icon: "warning", showCancelButton: true, confirmButtonColor: "#d33", confirmButtonText: "Sí, borrar" }).then((result) => { if (result.isConfirmed) { $.ajax({ url: "../../BACKEND/controltablas/FOR-S-CCI-89.php", type: "POST", data: { opcion: 6, id: data.ID }, // Enviamos data.ID success: function () { tablalimpieza.ajax.reload(null, false); swal.fire("¡Éxito!", "Registro eliminado", "success"); } }); } }); }); // --- EDITAR --- $('#tblConChiller tbody').off('click', '.btnEditar').on('click', '.btnEditar', function (e) { e.preventDefault(); let $row = $(this).closest('tr'); $row.find('td').each(function (index) { // Editamos columnas de la 1 a la 13 (evitando ID y botones) if (index > 0 && index < 23) { let valorActual = $(this).text(); let nombreColumna = tablalimpieza.settings().init().columns[index].data; // Agregamos un estilo inline "width: 100%" y un contenedor pequeño $(this).html(` <input type="text" class="form-control form-control-sm" style="min-width: 70px; width: 100%; padding: 2px;" value="${valorActual}" data-campo="${nombreColumna}"> `); } }); $(this).removeClass('btn-primary btnEditar').addClass('btn-success btnGuardar').html('<i class="fas fa-save"></i>'); $row.find('.btnBorrar').removeClass('btn-danger btnBorrar').addClass('btn-secondary btnCancelar').html('<i class="fas fa-times"></i>'); }); // --- GUARDAR --- $('#tblConChiller tbody').off('click', '.btnGuardar').on('click', '.btnGuardar', function (e) { e.preventDefault(); let $row = $(this).closest('tr'); let dataRow = tablalimpieza.row($row).data(); let datosActualizados = { opcion: 7, id: dataRow.ID }; // Unificado a ID $row.find('input').each(function () { let campo = $(this).data('campo'); let valor = $(this).val(); if (campo) datosActualizados[campo] = valor; }); $.ajax({ url: "../../BACKEND/controltablas/FOR-S-CCI-89.php", type: "POST", data: datosActualizados, success: function () { tablalimpieza.ajax.reload(null, false); swal.fire("¡Éxito!", "Registro actualizado", "success"); } }); }); // --- CANCELAR --- $('#tblConChiller tbody').off('click', '.btnCancelar').on('click', '.btnCancelar', function (e) { e.preventDefault(); tablalimpieza.ajax.reload(null, false); }); }); });