@extends('layouts.app', ['activePage' => 'abonos', 'menuParent' => 'consultas', 'titlePage' => __('Contabilidad - Depósitos')])
@section('content')
@include('includes.tailwind')
@include('contabilidad.includes.creacionPago',['formasPago' => $formasPago, 'tipoComprobante' => $tipoComprobante, 'bancos' => $bancos])
@include('contabilidad.includes.creacionPolizas',['cuentasContables' => $cuentasContables, 'tipoComprobante' => $tipoComprobante, 'tiposPolizas' => $tiposPolizas])

<div class="content">
    <div class="container-fluid mt-4">
        <div class="row mb-4">
            <div class="col-6">
                <h6 class="text-xl font-semibold text-gray-800">Listado de depósitos</h6>
            </div>
        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="bg-white rounded-lg shadow-md">
                    <div class="p-6">
                        <div class="grid grid-cols-12 gap-4 mb-4">
                            <div class="col-span-2">
                                <label class="block text-sm font-medium text-gray-700 mb-1">Año: <span class="text-red-500">*</span></label>
                                <select id="anioFilter" class="select2 w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500" data-size="7" data-width="100%" data-style="select-with-transition">
                                    <option value="" disabled selected>-Seleccione-</option>
                                    @for($i = date('Y'); $i >= 2020; $i--)
                                    <option value="{{ $i }}">{{ $i }}</option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-span-2">
                                <label class="block text-sm font-medium text-gray-700 mb-1">Mes: <span class="text-red-500">*</span></label>
                                <select id="mesFilter" class="select2 w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500" data-size="7" data-width="100%" data-style="select-with-transition">
                                    <option value="" disabled selected>-Seleccione-</option>
                                    <option value="1">Enero</option>
                                    <option value="2">Febrero</option>
                                    <option value="3">Marzo</option>
                                    <option value="4">Abril</option>
                                    <option value="5">Mayo</option>
                                    <option value="6">Junio</option>
                                    <option value="7">Julio</option>
                                    <option value="8">Agosto</option>
                                    <option value="9">Septiembre</option>
                                    <option value="10">Octubre</option>
                                    <option value="11">Noviembre</option>
                                    <option value="12">Diciembre</option>
                                </select>
                            </div>
                            <div class="col-span-2">
                                <label class="block text-sm font-medium text-gray-700 mb-1">Forma de pago:</label>
                                <select id="formaPagoFilter" class="select2 w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500  listado-cuentas-mayor" data-size="7" data-width="100%" data-style="select-with-transition" data-live-search="true">
                                    <option value="" disabled selected>-Todos-</option>
                                    @foreach($formasPago as $formaPago)
                                    <option value="{{ $formaPago->idFormapago }}">{{ $formaPago->nombre }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-span-2">
                                <label class="block text-sm font-medium text-gray-700 mb-1">Cliente:</label>
                                <select id="clienteFilter" class="select2 w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500  listado-cuentas-mayor" data-size="7" data-width="100%" data-style="select-with-transition" data-live-search="true">
                                    <option value="" disabled selected>-Todos-</option>
                                    @foreach($clientes as $cliente)
                                    <option value="{{ $cliente->id }}">{{ $cliente->razon_social }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-span-2">
                                <label class="block text-sm font-medium text-gray-700 mb-1">Estatus:</label>
                                <select id="estatusFilter" class="select2 w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500  listado-cuentas-mayor" data-size="7" data-width="100%" data-style="select-with-transition" data-live-search="true">
                                    <option value="" disabled selected>-Todos-</option>
                                    <option value="activo">Activos</option>
                                    <option value="cancelado">Cancelados</option>
                                </select>
                            </div>
                            <div class="col-span-2 mt-4">
                                <button class="bg-[#0A415F] hover:bg-[#083549] text-white px-4 py-1.5 text-sm rounded-md mr-2 transition-colors duration-200" onclick="getAbonos()">
                                    <i class="material-icons align-middle text-sm">search</i> Buscar
                                </button>

                            </div>
                        </div>
                        <div class="grid grid-cols-12 ">
                            <div class="col-span-2">

                                <button class="bg-[#0A415F] hover:bg-[#083549] text-white px-4 py-1.5 text-sm rounded-md mr-2 transition-colors duration-200" onclick="generarPagoFactura()">
                                    <i class="material-icons align-middle text-sm">payments</i> Generar deposito
                                </button>
                            </div>
                        </div>
                        <div class="table-scroll">
                            <table class="min-w-full" id="list-depositos">
                                <thead class=" sticky-top bg-gray-50 px-6 py-3  text-[10px] font-semibold text-left font-medium text-gray-500 uppercase tracking-wider">
                                    <tr>
                                        <th></th>
                                        <th></th>
                                        <th class="px-2 py-2">Póliza</th>
                                        <th class="px-2 py-2">Estatus</th>
                                        <th class="px-2 py-2" width="15%">Cliente</th>
                                        <th class="px-2 py-2">Fecha de creación</th>
                                        <th class="px-2 py-2">Banco</th>
                                        <th class="px-2 py-2">Subtotal</th>
                                        <th class="px-2 py-2">IVA</th>
                                        <th class="px-2 py-2">IVA Ret.</th>
                                        <th class="px-2 py-2">ISR</th>
                                        <th class="px-2 py-2">Monto total</th>
                                        <th class="px-2 py-2">F. Pago</th>
                                        <th class="px-2 py-2">Moneda</th>
                                        <th class="px-2 py-2">T.C</th>
                                    </tr>
                                </thead>
                                <tfoot>
                                    <tr>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>



<style>
    .select2-container {
        width: 100% !important;
    }

    .select2-container .select2-selection--single {
        height: 40px !important;
    }

    .select2-container .select2-selection--single .select2-selection__rendered {
        line-height: 40px !important;
    }


    .dataTables_wrapper .dataTables_length,
    .dataTables_wrapper .dataTables_filter,
    .dataTables_wrapper .dataTables_info,
    .dataTables_wrapper .dataTables_processing,
    .dataTables_wrapper .dataTables_paginate {
        font-size: 10px;
    }

    .dataTables_wrapper .dataTables_length select,
    .dataTables_wrapper .dataTables_filter input {
        font-size: 10px !important;
    }

    table.dataTable thead th,
    table.dataTable thead td {
        font-size: 10px !important;
    }

    table.dataTable tfoot th,
    table.dataTable tfoot td {
        font-size: 11px !important;
    }

    table.dataTable tbody td {
        font-size: 11px !important;
    }


    table.dataTable tbody tr:hover {
        background-color: #f8f9fa;
        cursor: pointer;
    }

    .dataTables_wrapper .dataTables_filter input {
        padding: 0.25rem 0.5rem !important;
        border-radius: 0.375rem !important;
        border: 1px solid #e2e8f0 !important;
    }

    .dataTables_wrapper .dataTables_filter input:focus {
        outline: none !important;
        border-color: #0A415F !important;
        box-shadow: 0 0 0 2px rgba(10, 65, 95, 0.1) !important;
    }

    .table-scroll {
        max-height: 650px;
        overflow-y: auto;
    }

    .estatus-row span {
        margin-right: 6px;
        width: 22px;
        height: 22px;
        display: inline-block;
    }
</style>
@endsection

@push('js')
<script>
    $(document).ready(function() {

        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        $('.select2').select2({
            placeholder: "-Todos-",
            width: '100%',
        });

        // Obtener mes y año actual
        var fecha = new Date();
        var mesActual = fecha.getMonth() + 1; // getMonth() devuelve 0-11
        var anioActual = fecha.getFullYear();

        // Establecer valores en los selectores
        $('#mesFilter').val(mesActual).trigger('change');
        $('#anioFilter').val(anioActual).trigger('change');

        // Llamar a la función getAbonos
        getAbonos();
    });

    let id_factura = '';

    function getAbonos() {
        if (!$('#mesFilter').val() || !$('#anioFilter').val()) {
            Swal.fire({
                icon: 'warning',
                title: 'Atención',
                text: 'Debe seleccionar mes y año para continuar',
                confirmButtonColor: '#0A415F'
            });
            return false;
        }

        $('#list-depositos').dataTable().fnDestroy();

        var table = $('#list-depositos').DataTable({
            lengthMenu: [10, 15, 20, 50, 100, 200, 500],
            dom: 'Bfrtip',
            language: {
                url: "{{asset('material/datatable_sp.json')}}"
            },
            ajax: {
                url: "{{route('depositos.get-depositos')}}",
                type: "POST",
                data: {
                    cliente: $('#clienteFilter').val(),
                    formaPago: $('#formaPagoFilter').val(),
                    mes: $('#mesFilter').val(),
                    anio: $('#anioFilter').val(),
                    estatus: $('#estatusFilter').val(),
                },
            },
            createdRow: function(row, data, rowIndex) {
                $.each($('td', row), function(colIndex) {
                    $(this).attr('title', 'Ver detalles del deposito');
                });
            },
            footerCallback: function(row, data, start, end, display) {
                var api = this.api();
                // Remove the formatting to get integer data for summation
                var intVal = function(i) {
                    return typeof i === 'string' ?
                        i.replace(/[\$,]/g, '') * 1 :
                        typeof i === 'number' ?
                        i : 0;
                };

                var array = [7, 8, 9, 10, 11];
                array.forEach(element => {

                    // Total over all pages
                    total = api
                        .column(element)
                        .data()
                        .reduce(function(a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total over this page
                    pageTotal = api
                        .column(element, {
                            page: 'current'
                        })
                        .data()
                        .reduce(function(a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Update footer
                    $(api.column(element).footer()).html(
                        '<span class="font-weight-bold">' + formatter.format(parseFloat(total)) + '<span>'
                    );
                });
            },
            columns: [{
                    data: "id",
                    visible: false
                },
                {
                    data: "acciones",
                    orderable: false,
                    searchable: false
                },
                {
                    data: "polizaActionBtn",
                    orderable: false,
                    searchable: false,
                    className: 'text-center',
                },
                {
                    data: "estatus",
                    orderable: false,
                    searchable: false
                },
                {
                    data: "cliente",
                },
                {
                    data: "fecha",
                },
                {
                    data: "banco",
                },
                {
                    data: "subtotal",
                },
                {
                    data: "iva",
                },
                {
                    data: "iva_ret",
                },
                {
                    data: "isr",
                },
                {
                    data: "monto",
                },
                {
                    data: "forma_pago",
                },
                {
                    data: "moneda",
                },
                {
                    data: "tipo_cambio",
                },
            ],
            buttons: [{
                    extend: 'excel',
                    text: 'Exportar a Excel',
                    className: 'bg-[#0A415F] hover:bg-[#083549] text-white px-4 py-2 rounded-md text-xs font-medium transition-colors duration-200',
                    exportOptions: {
                        columns: ':not(:first-child)',
                        footer: true
                    },
                },
                {
                    extend: 'pdf',
                    className: 'bg-[#0A415F] hover:bg-[#083549] text-white px-4 py-2 rounded-md text-xs font-medium transition-colors duration-200',
                    text: 'Exportar a PDF',
                    title: 'Listado de depositos',
                    orientation: 'landscape',
                    exportOptions: {
                        columns: ':not(:first-child)',
                        footer: true
                    },
                    customize: function(doc) {
                        doc.defaultStyle.fontSize = 8;
                        doc.styles.tableHeader.fontSize = 8;
                    }
                }
            ],
            order: [
                [4, "desc"]
            ],
        });

        table.on('click', 'tr', function(e) {
            var target = $(e.target);
            var cell = table.cell(target);

            if (!cell || !cell.index()) {
                return;
            }

            var columnIndex = cell.index().column;
            var columnTitle = table.column(columnIndex).header().textContent.trim();

            if (columnTitle === 'Acciones' || columnTitle === 'Estatus') {
                return;
            }

            var row = table.row(this).data();
            if (!row) {
                return;
            }

            $('.checkPro').map(function() {
                if ($(this).val() == row.id) {
                    $(this).prop('checked', true);
                }
            });

            window.open("{{ route('depositos.detalles-deposito', ['id' => ':id']) }}".replace(':id', row.id), '_blank');
        });
    }


    function eliminarDeposito(id) {
        Swal.fire({
            title: '¿Estás seguro?',
            text: "¿Deseas eliminar este depósito? Esta acción no se puede deshacer.",
            icon: 'warning',
            showCancelButton: true,
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33',
            confirmButtonText: 'Sí, eliminar',
            cancelButtonText: 'Cancelar'
        }).then((result) => {
            if (result.isConfirmed) {
                $('#loadingLoad').modal('show');
                $.ajax({
                        url: "{{ route('depositos.delete') }}",
                        type: 'POST',
                        dataType: 'json',
                        data: {
                            id: id,
                        },
                    })
                    .done(function(resp) {
                        if (resp.result == 'success') {
                            showNotification('delete', 'top', 'center', 'success', '¡Eliminado!', resp.mensaje);
                            $('#list-depositos').DataTable().ajax.reload();
                        } else {
                            Swal.fire({
                                icon: 'error',
                                title: 'Error',
                                text: resp.mensaje || 'No se pudo eliminar el depósito.'
                            });
                        }
                    })
                    .fail(function() {
                        Swal.fire({
                            icon: 'error',
                            title: 'Error',
                            text: 'Ocurrió un error al intentar eliminar el depósito.'
                        });
                    })
                    .always(function() {
                        setTimeout(() => {
                            $('#loadingLoad').modal('hide');
                        }, 1000);
                    });
            }
        });
    }
</script>

@endpush