@extends('layouts.master')

@section('title', 'Eventos')

@section('content')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                    <h1 class="m-0 text-dark">Informe OLD<small> {{ $evento->nombre }}</small>  <small> {{ date('d/m/Y',strtotime($evento->fecha)) }}</small></h1>
                </div>
            </div>
        </div>
    </div>

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                    <div class="card">
                        <div class="card-header ui-sortable-handle bg-dark text-light">
                            <h3 class="card-title">
                                <i class="fa-solid fa-ticket mr-1"></i>
                                Ingreso Entradas
                            </h3>
                        </div>
                        <div class="card-body">
                            @if(count($entradas))
                                <div class="table-responsive">
                                    <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                                        <thead>
                                            <tr>
                                                <th>Nombre</th>
                                                <th class="text-right">Valor</th>
                                                <th class="text-center">Efectivo</th>
                                                <th class="text-center">Transferencia</th>
                                                <th class="text-center">Credito / Debito</th>
                                                <th class="text-center">QR</th>
                                                <th class="text-center">Free</th>
                                                <th class="text-center">Total / Ingresados / Capacidad</th>
                                                <th class="text-right">Total</th>
                                                <th class="text-right">Descuentos</th>
                                                <th class="text-right">Subtotal</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($entradas as $key => $entrada)
                                                <tr>
                                                    <td>{{ $entrada->nombre }}<br><small>Para {{ $entrada->multiplo }} Personas</small><br><small>${{ number_format($entrada->valor / $entrada->multiplo, 0, ',', '.') }} x Personas</small></td>
                                                    <td class="text-right">${{ number_format($entrada->valor, 0, ',', '.') }}</td>
                                                    <td class="text-center">{{ $entrada->cantidadCash }}</td>
                                                    <td class="text-center">{{ $entrada->cantidadTransferencia }}</td>
                                                    <td class="text-center">{{ $entrada->cantidadCreditoDebito }}</td>
                                                    <td class="text-center">{{ $entrada->cantidadQR }}</td>
                                                    <td class="text-center">{{ $entrada->cantidadFree }}</td>
                                                    <th class="text-center">{{ $entrada->cantidadTotal }} / {{ count($evento->invitadosRecepcionadosEntrada($entrada->id)) }} / {{ $entrada->cantidad * $entrada->multiplo }}</th>
                                                    <th class="text-right">${{ number_format($entrada->total, 0, ',', '.') }}</th>
                                                    <th class="text-right">${{ number_format($entrada->descuento, 0, ',', '.') }}</th>
                                                    <th class="text-right">${{ number_format($entrada->subtotal, 0, ',', '.') }}</th>
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <th>Total</th>
                                                <th></th>
                                                <th class="text-center">{{ $evento->cantidadTotalCash}}</th>
                                                <th class="text-center">{{ $evento->cantidadTotalTransferencia}}</th>
                                                <th class="text-center">{{ $evento->cantidadTotalCreditoDebito}}</th>
                                                <th class="text-center">{{ $evento->cantidadTotalQR}}</th>
                                                <th class="text-center">{{ $evento->cantidadTotalFree}}</th>
                                                <th class="text-center">{{ count($evento->invitadosConfirmados) }} / {{ count($evento->invitadosRecepcionados) }} / {{ $evento->entradasCantidadTotal() }}</th>
                                                <th class="text-right">${{ number_format($totalEntradas, 0, ',', '.') }}</th>
                                                <th class="text-right">${{ number_format($totalDescuentos, 0, ',', '.') }}</th>
                                                <th class="text-right">${{ number_format($subtotal, 0, ',', '.') }}</th>
                                            </tr>
                                            @if($evento->salon_id == 2)
                                                <tr>
                                                    <th colspan="10">Total Artista (70%)</th>
                                                    <th class="text-right">${{ number_format($subtotal * 0.70, 0, ',', '.') }}</th>
                                                </tr>
                                            @endif
                                        </tbody>
                                    </table>
                                </div>
                            @else
                                <div><br><p class="text-center">No Existen Registros</p><br></div>
                            @endif
                        </div>
                    </div>

                    <div class="card">
                        <div class="card-header ui-sortable-handle bg-dark text-light">
                            <h3 class="card-title">
                                <i class="fa-solid fa-user mr-1"></i>
                                RRPP
                            </h3>
                        </div>
                        <div class="card-body">
                            @if(count($evento->rrpps))
                                <div class="table-responsive">
                                    <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                                        <thead>
                                            <tr>
                                                <th>Nombre</th>
                                                @foreach ($entradas as $key => $entrada)
                                                    <th class="text-center">{{ $entrada->nombre}}</th>
                                                @endforeach
                                                <th class="text-center">Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($evento->rrpps as $key => $rrpp)
                                                <tr>
                                                    <td>{{ $rrpp->name }}<br>{{$rrpp->pivot->porcentaje * 100}}%</td>
                                                    @foreach ($entradas as $key => $entrada)
                                                        <td class="text-center">{{ count($rrpp->entradas($evento->id, $entrada->id)) }} <br>$ {{ number_format( count($rrpp->entradas($evento->id, $entrada->id)) * ($entrada->valor/$entrada->multiplo), 0, ',', '.') }}</td>
                                                    @endforeach
                                                    <th class="text-center">{{ count($rrpp->entradasTotales($evento->id)) }} <br> $ {{ number_format($rrpp->entradasTotalesValores($evento->id) * $rrpp->pivot->porcentaje, 0, ',', '.' ) }}</th>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            @else
                                <div><br><p class="text-center">No Existen Registros</p><br></div>
                            @endif
                        </div>
                    </div>
                    @if(0)
                    <div class="card">
                        <div class="card-header ui-sortable-handle bg-dark text-light">
                            <h3 class="card-title">
                                <i class="fa-solid fa-martini-glass mr-1"></i>
                                Ingresos
                            </h3>
                            <div class="card-tools">
                                <button type="button" class="btn btn-tool" data-toggle="modal" data-target="#detalleBarra">
                                    <i class="fa-solid fa-bars fa-lg"></i>
                                </button>
                            </div>
                        </div>
                        <div class="card-body">
                            @if(count($productos))
                                <div class="table-responsive">
                                    <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                                        <thead>
                                            <tr>
                                                <th></th>
                                                <th class="text-center" colspan="6">Cantidad</th>
                                                <th class="text-right"></th>
                                            </tr>
                                            <tr>
                                                <th>Nombre</th>
                                                <th class="text-center">Efectivo</th>
                                                <th class="text-center">Credito / Debito</th>
                                                <th class="text-center">Transferencia</th>
                                                <th class="text-center">Wallet</th>
                                                <th class="text-center">Free</th>
                                                <th class="text-center">Total</th>
                                                <th class="text-right">Subtotal</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($productos as $key => $producto)
                                                <tr>
                                                    <td>{{ substr($producto->nombre, 0, 45) }} <small> {{ $producto->categoria->nombre }}</small></td>
                                                    <td class="text-center">{{ $producto->cantidadCash }}</td>
                                                    <td class="text-center">{{ $producto->cantidadMP }}</td>
                                                    <td class="text-center">{{ $producto->cantidadTransfe }}</td>
                                                    <td class="text-center">{{ $producto->cantidadWallet }}</td>
                                                    <td class="text-center">{{ $producto->cantidadFree }}</td>
                                                    <th class="text-center">{{ $producto->cantidadTotal }}</th>
                                                    <th class="text-right">$ {{ number_format($producto->total, 0, ',', '.') }}</th>
                                                </tr>
                                            @endforeach
                                            <tr>
                                                <th>Total</th>
                                                <th class="text-center">$ {{ number_format($totalProductosCash, 0, ',', '.') }}</th>
                                                <th class="text-center">$ {{ number_format($totalProductosMP, 0, ',', '.') }}</th>
                                                <th class="text-center">$ {{ number_format($totalProductosTransfe, 0, ',', '.') }}</th>
                                                <th class="text-center">$ {{ number_format($totalProductosWall, 0, ',', '.') }}</th>
                                                <th class="text-center">$ {{ number_format($totalProductosFree, 0, ',', '.') }}</th>
                                                <th class="text-center">{{ $totalCantidadProductos }}</th>
                                                <th class="text-right">$ {{ number_format($totalProductosCash + $totalProductosMP +  $totalProductosTransfe, 0, ',', '.') }}</th>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            @else
                                <div><br><p class="text-center">No Existen Registros</p><br></div>
                            @endif
                        </div>
                    </div>
                @endif

                    @if(1)
                        <div class="card">
                            <div class="card-header ui-sortable-handle bg-dark text-light">
                                <h3 class="card-title">
                                    <i class="fa-solid fa-martini-glass mr-1"></i>
                                    Ingreso Cocina + Barra
                                </h3>
                                <div class="card-tools">
                                    <button type="button" class="btn btn-tool" data-toggle="modal" data-target="#detalleBilleteras">
                                        <i class="fa-solid fa-bars fa-lg"></i>
                                    </button>
                                </div>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                                        <thead>
                                            <tr>
                                                <th>Barra</th>
                                                <th>Cocina</th>
                                                <th>Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                <th>$ {{ number_format($barra, 0, ',', '.') }}</th>
                                                <th>$ {{ number_format($cocina, 0, ',', '.') }}</th>
                                                <th>$ {{ number_format($barra+$cocina, 0, ',', '.') }}</th>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    @endif

                    <div class="card">
                        <div class="card-header ui-sortable-handle bg-dark text-light">
                            <h3 class="card-title">
                                <i class="fa-solid fa-ticket mr-1"></i>
                                Ingreso Billeteras
                            </h3>
                            <div class="card-tools">
                                <button type="button" class="btn btn-tool" data-toggle="modal" data-target="#detalleBilleteras">
                                    <i class="fa-solid fa-bars fa-lg"></i>
                                </button>
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                                    <thead>
                                        <tr>
                                            <th>Nombre</th>
                                            <th class="text-center">Cantidad Efectivo</th>
                                            <th class="text-center">Cantidad Transferencia</th>
                                            <th class="text-center">Cantidad Credito / Debito</th>
                                            <th class="text-center">Cantidad QR</th>
                                            <th class="text-center">Cantidad Free</th>
                                            <th class="text-right">Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <th>Carga de wallets</th>
                                            <th class="text-center">$ {{ number_format($evento->movimientoCreditos(1)->sum('credito'), 0, ',', '.') }}</th>
                                            <th class="text-center">$ {{ number_format($evento->movimientoCreditos(5)->sum('credito'), 0, ',', '.') }}</th>
                                            <th class="text-center">$ {{ number_format($evento->movimientoCreditos(6)->sum('credito'), 0, ',', '.') }}</th>
                                            <th class="text-center">$ {{ number_format($evento->movimientoCreditos(2)->sum('credito'), 0, ',', '.') }}</th>
                                            <th class="text-center">$ {{ number_format($evento->movimientoCreditos(4)->sum('credito'), 0, ',', '.') }}</th>
                                            <th class="text-right">$ {{ number_format($evento->movimientoCreditos(0)->sum('credito'), 0, ',', '.') }}</th>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                    @if(1)
                        <div class="card">
                            <div class="card-header ui-sortable-handle bg-dark text-light">
                                <h3 class="card-title">
                                    <i class="fa-solid fa-bars mr-1"></i>
                                    Resumen <small>{{ $evento->nombre }}</small>
                                </h3>
                            </div>
                            <div class="card-body">
                                <table class="table table-hover table-striped" style="width:100%;">
                                    <thead>

                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Ingresos Entradas</td>
                                            <td class="text-right">$ {{ number_format($subtotal, 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <td>Ingresos Barra - Cash</td>
                                            <td class="text-right">$ {{ number_format($totalProductosCash, 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <td>Ingresos Barra - MP</td>
                                            <td class="text-right">$ {{ number_format($totalProductosMP, 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <td>Wallets</td>
                                            <td class="text-right">$ {{ number_format($evento->movimientoCreditos(1)->sum('credito') + $evento->movimientoCreditos(5)->sum('credito') + $evento->movimientoCreditos(2)->sum('credito') + $evento->movimientoCreditos(6)->sum('credito'), 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <td>Devolucion Wallets</td>
                                            <td class="text-right">$ {{ number_format((0), 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <th>Ingresos Totales</th>
                                            <th class="text-right">$ {{ number_format(( $subtotal + $totalProductosCash + $totalProductosMP + $evento->movimientoCreditos(1)->sum('credito') + $evento->movimientoCreditos(5)->sum('credito') + $evento->movimientoCreditos(2)->sum('credito')), 0, ',', '.') }}</th>
                                        </tr>
                                    </tbody>
                                </table>
                                <br>
                                <table class="table table-hover table-striped" style="width:100%;">
                                    <thead>

                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Costo Apertura</td>
                                            <td class="text-right">$ {{ number_format($evento->sena, 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <td>Total Neto</td>
                                            <td class="text-right">$ {{ number_format($subtotal + $totalProductosCash + $totalProductosMP + $evento->movimientoCreditos(1)->sum('credito') + $evento->movimientoCreditos(5)->sum('credito') + $evento->movimientoCreditos(2)->sum('credito') - $evento->sena, 0, ',', '.') }}</td>
                                        </tr>
                                        <tr>
                                            <th>Productora ({{ $evento->porcentaje * 100}}%)</th>
                                            <th class="text-right">$ {{ number_format(($subtotal + $totalProductosCash + $totalProductosMP + $evento->movimientoCreditos(1)->sum('credito') + $evento->movimientoCreditos(5)->sum('credito') + $evento->movimientoCreditos(2)->sum('credito') - $evento->sena)*$evento->porcentaje, 0, ',', '.') }}</th>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    @endif

                </div>
            </div>
        </div>
    </section>

    <!-- Modal Detalle Barra -->
    <div class="modal fade" id="detalleBarra" tabindex="-1" role="dialog" aria-labelledby="contactoAgregar" aria-hidden="true">
        <div class="modal-dialog modal-xl" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Detalle Barra</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="table-responsive">
                        <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                            <thead>
                                <tr>
                                    <th>Hora</th>
                                    <th>Nombre</th>
                                    <th>Cliente</th>
                                    <th>Medio</th>
                                    <th class="text-center">Cantidad</th>
                                    <th class="text-right">Precio</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($comandas as $key => $comanda)
                                    <tr>
                                        <td>{{ date('H:i', strtotime($comanda->created_at)) }}</td>
                                        <td>{{ @$comanda->producto->nombre }}</td>
                                        <td>{{ $comanda->nombre }}</td>
                                        <td>{{ $comanda->medio->nombre }}</td>
                                        <td class="text-center">{{ $comanda->cantidad }}</td>
                                        @if($comanda->medio_id == 4)
                                            <th class="text-right" style="color:red">$ {{ number_format($comanda->total, 0, ',', '.') }}</th>
                                        @elseif($comanda->medio_id == 3)
                                            <th class="text-right" style="color:orange">$ {{ number_format($comanda->total, 0, ',', '.') }}</th>
                                        @else
                                            <th class="text-right" style="color:green">$ {{ number_format($comanda->total, 0, ',', '.') }}</th>
                                        @endif
                                    </tr>
                                @endforeach
                                <tr>
                                    <th>Total Credito / Debito / QR</th>
                                    <th colspan="3"></th>
                                    <th class="text-center">{{ $cantidadComandasPagas }}</th>
                                    <th class="text-right" style="color:green">$ {{ number_format($totalComandasPagas, 0, ',', '.') }}</th>
                                </tr>
                                <tr>
                                    <th>Total Wallet</th>
                                    <th colspan="3"></th>
                                    <th class="text-center">{{ $cantidadComandasWallet }}</th>
                                    <th class="text-right" style="color:orange">$ {{ number_format($totalComandasWallet, 0, ',', '.') }}</th>
                                </tr>
                                <tr>
                                    <th>Total Free</th>
                                    <th colspan="3"></th>
                                    <th class="text-center">{{ $cantidadComandasFree }}</th>
                                    <th class="text-right" style="color:red">$ {{ number_format($totalComandasFree, 0, ',', '.') }}</th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                    <hr>
                    <div class="row">
                        <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                            <button type="button" class="btn btn-secondary btn-block" data-dismiss="modal">Cerrar</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Modal Detalle Billeteras-->
    <div class="modal fade" id="detalleBilleteras" tabindex="-1" role="dialog" aria-labelledby="contactoAgregar" aria-hidden="true">
        <div class="modal-dialog modal-xl" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Detalle Billeteras</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="table-responsive">
                        <table class="table table-hover table-striped w-100" style="overflow-x: auto; white-space: nowrap;">
                            <thead>
                                <tr>
                                    <th>Hora</th>
                                    <th>Nombre</th>
                                    <th>Cliente</th>
                                    <th>Medio de Pago</th>
                                    <th class="text-right">Debito / Credito</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($evento->movimientoCreditos(0) as $key => $movimineto)
                                    <tr>
                                        <td>{{ date('H:i', strtotime($movimineto->created_at)) }}</td>
                                        <td>{{ $movimineto->nombre }}</td>
                                        <td>{{ $movimineto->user->name }}</td>
                                        <td>{{ $movimineto->medio->nombre }}</td>
                                        @if($movimineto->credito != null)
                                            <th class="text-right" style="color:green">$ {{ number_format($movimineto->credito, 0, ',', '.') }}</th>
                                        @else
                                            <th class="text-right" style="color:orange">$ {{ number_format($movimineto->debito, 0, ',', '.') }}</th>
                                        @endif
                                    </tr>
                                @endforeach
                                <tr>
                                    <th>Total Cobrado</th>
                                    <th colspan="3"></th>
                                    <th class="text-right" style="color:green">$ </th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                    <hr>
                    <div class="row">
                        <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                            <button type="button" class="btn btn-secondary btn-block" data-dismiss="modal">Cerrar</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/dataTables.bootstrap4.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.21/js/dataTables.bootstrap4.min.js"></script>

    <script>
    $(document).ready(function() {
        $('#videos').DataTable( {
            "order": [[ 0, 'asc' ]],
            "scrollX": true,
            "language": {
                "lengthMenu": "Mostrar _MENU_ por pagina",
                "zeroRecords": "No existen Registros",
                "info": "", // Mostrando Pagina _PAGE_ de _PAGES_
                "infoEmpty": "",// No existen Registros
                "infoFiltered": "", // (filtrado de _MAX_ registros)
                "search": "Buscar:",
                "paginate": {
                    "first":      "Primera",
                    "last":       "Ultima",
                    "next":       "Siguiente",
                    "previous":   "Anterior"
                },
            },
            "pageLength": 250,
            //"dom": 'f<<t>p>'
            "dom": '<"top"f>rt<"bottom"p><"clear">'
        } );
    } );
    </script>

@endsection