{% extends 'TARJETAS/templates/base.html' %}{% load static %}

{% block title %}Gastos de Tarjetas{% endblock %}

{% block content %}
<!-- Content Header (Page header) -->
<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1>Listado de Gastos de Tarjetas</h1>
            </div>
            <div class="col-sm-6">
                <ol class="breadcrumb float-sm-right">
                    <li class="breadcrumb-item"><a href="#">Inicio</a></li>
                    <li class="breadcrumb-item active">Gastos de Tarjetas</li>
                </ol>
            </div>
        </div>
    </div>
</section>

<!-- Main content -->
<section class="content">

    <!-- block content -->
    <!-- Default box -->
    <div class="card">
        <div class="card-header d-flex align-items-center">
            <h3 class="card-title"><b>Tabla de listado de gastos de tarjetas</b></h3>
            <button data-crud_modal="C" class="btn btn-sm bg-success ml-auto" type="button">
                <i class="fas fa-plus"></i> Crear nuevo gasto de tarjeta
            </button>
        </div>
        <div class="card-body">

            <table class="table table-hover table-sm align-middle table-borderless rounded-3" style="width: 100%;">
                <thead class="text-white" style="background-color: #A3B0C7 !important;">
                    <tr>
                        <th>ID</th>
                        <th>Monto</th>
                        <th>Categoría</th>
                        <th>Tarjeta</th>
                        <th>Cuenta</th>
                        <th>Acciones</th>
                    </tr>
                </thead>
                <tbody class="small">
                </tbody>
                <tfoot>
                    <tr>
                        <th>ID</th>
                        <th>Monto</th>
                        <th>Categoría</th>
                        <th>Tarjeta</th>
                        <th>Cuenta</th>
                        <th></th>
                    </tr>
                </tfoot>
            </table>

        </div>
        <!-- /.card-body -->
        <div class="card-footer">
            <b>Menú de Sistema</b> - Gastos de Tarjetas
        </div>
        <!-- /.card-footer-->
    </div>
    <!-- /.card -->

</section>
<!-- /.content -->
{% endblock %}

{% block modals %}
{% include 'TARJETAS/templates/modals/tarjetas_gastos.html' %}
{% endblock %}

{% block scripts %}
<script>
    $(document).ready(function () {
        $('section.content table').DataTable({
            ajax: {
                // url: '{% static "tarjetas/mockData/tarjetas_gastos.json" %}',
                url: '{% url "tarjetas:get_tarjetas_gastos" %}',
                type: "GET",
                dataSrc: "result"
            },
            autoWidth: false,
            scrollX: true,
            scrollY: '300px',
            scrollCollapse: true,
            pageLength: 50,
            dom: 'Brftip',
            orderCellsTop: true,  // Permite filtros en el `tfoot`
            buttons: [
                { extend: 'copy', className: 'btn btn-secondary btn-sm', text: '<i class="fas fa-copy"></i>' },

                { extend: 'excel', className: 'btn btn-success btn-sm', text: '<i class="fas fa-file-excel"></i>', attr: { style: 'background-color: #218838; border-color: #218838;' } },
                { extend: 'pdf', className: 'btn btn-danger btn-sm', text: '<i class="fas fa-file-pdf"></i>' },
                { extend: 'print', className: 'btn btn-info btn-sm', text: '<i class="fas fa-print"></i>' },
                {
                    extend: 'colvis',
                    text: '<i class="fas fa-eye"></i>',
                    className: 'btn btn-primary btn-sm'
                }
            ],
            initComplete: function () {
                // **Filtros en el tfoot**
                this.api().columns().every(function () {
                    var column = this;
                    var title = $(column.footer()).text().trim();

                    if (title !== "Acciones" && title !== "") {  // Evita filtros en la columna de Acciones
                        var input = $('<input class="form-control form-control-sm filterControl" type="text" placeholder="Filtrar ' + title + '" />')
                            .appendTo($(column.footer()).empty())
                            .on("keyup change clear", function () {
                                if (column.search() !== this.value) {
                                    column.search(this.value).draw();
                                }
                            });
                    }
                });
            },
            columns: [
                {
                    data: null,
                    render: function (data, type, row, meta) {
                        return meta.row + 1;
                    }
                },
                {
                    data: null,
                    render: function (data, type, row) {
                        return DT.COL.handle_blank(DINERO(row.monto));
                    }
                },
                {
                    data: null,
                    render: function (data, type, row) {
                        return DT.COL.handle_blank(row.id_tarjeta_gasto_categoria);
                    }
                },
                {
                    data: null,
                    render: function (data, type, row) {
                        return DT.COL.handle_blank(row.id_tarjeta);
                    }
                },
                {
                    data: null,
                    render: function (data, type, row) {
                        return DT.COL.handle_blank(row.id_cuenta);
                    }
                },
                {
                    data: null,
                    render: function (data, type, row) {
                        // Botones o enlaces para acciones
                        return `
                            <div class="btn-group">
                                <a data-crud_modal="R" class="btn btn-sm btn-info" title="Ver detalles">
                                    <i class="fas fa-eye"></i>
                                </a>
                                <a data-crud_modal="U" class="btn btn-sm btn-warning" title="Editar">
                                    <i class="fas fa-edit"></i>
                                </a>
                                <a data-crud_modal="D" class="btn btn-sm btn-danger" title="Eliminar">
                                    <i class="fas fa-trash"></i>
                                </a>
                                <a data-alert="foto" class="btn btn-sm btn-primary" title="Ver Foto del Comprobante de Gasto">
                                    <i class="fas fa-file-alt"></i>
                                </a>
                            </div>
                        `;
                    }
                }
            ]
        });

        $(document).on('click', '[data-crud_modal]', function () {
            let action = $(this).data('crud_modal');
            let rowData = {};

            if (action !== 'C') {
                rowData = $(this).closest('table').DataTable().row($(this).closest('tr')).data();
            }

            SHOW_CRUD_MODAL('modal_tarjetas_gastos', action, rowData, VB.tarjetas_gastos.vb);
        });

    });
</script>
{% endblock %}