{{--!auth()->user()->is_seller--}}
@if($evento && auth()->user() && (auth()->user()->isRole(1) || $evento->type_product_id == 3) && (auth()->user()->isRole(1) || (auth()->user()->isRole(5) && !auth()->user()->is_seller ) ))
    <h1>{{ strtoupper($evento->title_small) }}</h1>
    <table border="1">
        <thead>
        {{--        <tr>--}}
        {{--            <th colspan="4" style="font-size: 20px"><b--}}
        {{--                    style="font-size: 20px"></b></th>--}}
        {{--        </tr>--}}
        <tr>
            <th colspan="9" style="font-size: 20px"><b
                    style="font-size: 20px">REPORTE POR ZONAS</b></th>

        </tr>
        <tr>
            <th>Tipo entrada</th>
            <th>N° Cortesías</th>
            {{--            <th>N° Ventas</th>--}}
            <th>N° Entradas Vendidas</th>
            <th>Costo por entrada</th>

            <th>Total por Entradas</th>
            <th>Comisión Cliente</th>
            <th>Descuento (Cortesìas)</th>
            <th>Total recaudado</th>
        </tr>


        </thead>
        @foreach($evento->productTerms as $tipoEntradaPadre)
            <tr>
                <th colspan="8"><b style="font-size: 13px">{{ $tipoEntradaPadre->name }}
                        @if(!empty($tipoEntradaPadre->product_date_id) && $tipoEntradaPadre->productDate)
                            - {{ $tipoEntradaPadre->productDate->fecha_hora->format("d/m/Y h:i a") }}
                        @endif
                    </b></th>
            </tr>
            @foreach($tipoEntradaPadre->subProductTerms as $tipoEntrada)
                @php
                    $dataSales = $tipoEntrada->getCollectionsaleProductForReport(request()->get('seler_id'));
                    $dataSalesGruped = $dataSales->groupBy('unit_price');
                   // dd($dataSalesGruped);

                @endphp
                @foreach($dataSalesGruped as $pricesGrup => $rowGroupPrice)
                    @php
                        if($tipoEntradaPadre->id == 1533 && $pricesGrup == 234){
//dd($rowGroupPrice);
}
//where('sale_payment_method_id','!=',12)
                        $subTotal = $rowGroupPrice->sum('sub_total_price');//where('sale_payment_method_id','!=',12)
                       $descuento = $rowGroupPrice->sum('discount');//where('sale_payment_method_id','!=',12)
                       $comisionCliente  = $rowGroupPrice->sum('client_comision');//where('sale_payment_method_id','!=',12)
                    @endphp
                    <tr>
                        <td>{{ $tipoEntrada->name }}</td>

                        <td>
                            {{ $rowGroupPrice->where('sale_payment_method_id',12)->sum('persons') }}
                        </td>

                        {{--                        <td>--}}
                        {{--                            {{ $rowGroupPrice->where('sale_payment_method_id','!=',12)->count() }}--}}
                        {{--                        </td>--}}
                        <td>
                            {{ $rowGroupPrice->where('sale_payment_method_id','!=',12)->sum('persons') }}
                        </td>
                        <td>{{ $pricesGrup }}</td>
                        <td>{{ $subTotal }}</td>

                        <td>{{ $comisionCliente }}</td>
                        <td>{{ $descuento }}</td>
                        <td>{{ ($subTotal+$comisionCliente+$descuento) }}</td>
                    </tr>
                @endforeach

            @endforeach
        @endforeach

    </table>
    {{--    @php--}}
    {{--    exit;--}}
    {{--    @endphp--}}
    <br>
    <br>
    <br>
    <table border="1">
        <thead>

        <tr>
            <th colspan="12" style="font-size: 20px"><b
                    style="font-size: 20px">REPORTE POR VENDEDORES</b></th>

        </tr>
        <tr>
            <th rowspan="2">Vendedor</th>
            <th colspan="2">CORTESIAS</th>
            <th colspan="9">VENTA</th>


        </tr>
        <TR>

            <th>CANTIDAD</th>
            <th>PERSONAS</th>
            <th>CANTIDAD</th>
            <th>PERSONAS</th>

            <th>SUB TOTAL</th>
            <th>COMISIÓN</th>
            <th>DESCUENTO</th>

            <th>TOTAL EN EFECTIVO</th>
            <th>TOTAL EN POS</th>
            <th>TOTAL EN OTROS</th>

            <th>TOTAL VENTA</th>
        </TR>

        </thead>
        <tbody>
        @foreach($data as $selerID => $sales)
            @php
                $vendedor = '';
                $cantidad_ventas = 0;

                $total_efectivo = 0;
                $total_pos = 0;
                $total_cortesia = 0;
                $total_otros = 0;

                $sub_total_venta = 0;
                $comision_venta = 0;
                $descuento_venta = 0;
                $monto_venta = 0;

                if($selerID > 0){
                    $vendedor =  $sales[0]->seler->name;
                }else{
                   $vendedor = 'VAOPE.COM';
                }

            $cantidad_ventas = $sales->where('payment_method_id','!=',12)->count();
            $cantidad_personas = $sales->where('payment_method_id','!=',12)->sum('persons');




            $sub_total_venta = $sales->sum('sub_total');
            $comision_venta = $sales->sum('delivery');
            $descuento_venta = $sales->sum('discount');


            $monto_venta = $sales->sum('total_price');
            $total_efectivo = $sales->where('payment_method_id',2)->sum('total_price');
            $total_pos = $sales->where('payment_method_id',3)->sum('total_price');
            $total_otros = $sales->whereNotIn ('payment_method_id',[2,3])->sum('total_price');

            $cantidad_ventas_cort = $sales->where('payment_method_id',12)->count();
            $cantidad_personas_cort = $sales->where('payment_method_id',12)->sum('persons');

            @endphp
            <tr>
                <td>{{ $vendedor }}</td>

                <td>{{ $cantidad_ventas_cort }}</td>
                <td>{{ $cantidad_personas_cort }}</td>

                <td>{{ $cantidad_ventas }}</td>
                <td>{{ $cantidad_personas }}</td>


                <td>{{ $sub_total_venta }}</td>
                <td>{{ $comision_venta }}</td>
                <td>{{ $descuento_venta }}</td>

                <td>{{ $total_efectivo }}</td>
                <td>{{ $total_pos }}</td>
                <td>{{ $total_otros }}</td>
                <td>{{ $monto_venta }}</td>

            </tr>
        @endforeach
        </tbody>
    </table>
    <br>
    <br>
    <br>
    <table border="1">
        <thead>

        <tr>
            <th colspan="12" style="font-size: 20px"><b
                    style="font-size: 20px">SERVICIOS / DESCUENTOS</b></th>

        </tr>
        <tr>
            <th>Fecha</th>
            <th>Descripción</th>
            <th>Monto</th>
        </tr>


        </thead>
        <tbody>
        @foreach($evento->productLiquidationOperations as $productLiquidationOperation)
            <tr>
                <td>{{ $productLiquidationOperation->created_at->format('d/m/Y h:i A') }}</td>
                <td>{{ $productLiquidationOperation->description }}</td>
                <td>{{ number_format($productLiquidationOperation->amount,2) }}</td>
            </tr>
        @endforeach
        </tbody>
    </table>
    <br>
    <br>
    <br>
@endif
<table border="1">
    <tr>
        <th colspan="33" style="background-color: #001b44; color: #ffffff;  text-align: center;">Detalles de ventas</th>
    </tr>
    @foreach($data as $selerID => $sales)
        <tr>
            {{--            <th><b>ProdId</b></th>--}}
            <th><b>Vendedor</b></th>
            <th><b>N° Pedido</b></th>
            <th><b>N° Operación</b></th>

            <th><b>Cliente</b></th>
            <th><b>Documento</b></th>
            <th><b>Teléfono</b></th>
            <th><b>Email</b></th>

            <th><b>Fecha de pago</b></th>
            <th><b>Número de Personas</b></th>
            <th><b>Costo por Persona</b></th>

            <th><b>Sub Total</b></th>
            <th><b>Comisión</b></th>
            <th><b>Descuento</b></th>
            <th><b>Total Pagado</b></th>
            <th><b>Método de pago</b></th>
            <th><b>Información de pago</b></th>
            <th><b>Código de descuento</b></th>


            <th><b>Comisión método de pago</b></th>
            <th><b>Comisión VAOPE.COM</b></th>
            <th><b>Total a Depositar</b></th>

            <th><b>Estado Entrada</b></th>
            <th><b>Tarifa</b></th>
            <th><b>Número Ticket</b></th>
            <th><b>N° Pedido</b></th>
            <th><b>Evento</b></th>
            <th><b>Función</b></th>
            <th><b>Tipo Entrada</b></th>
            <th><b>Nominación Dni</b></th>
            <th><b>Nominación Nombre</b></th>
            <th><b>Zona</b></th>
            <th><b>Ubicación</b></th>
            <th><b>Asiento</b></th>
            <th><b>Estado entrada</b></th>
        </tr>

        @php
            $tota_st = 0;
            $tota_c = 0;
            $tota_t = 0;
            $tota_det = 0;
            $tota_desc = 0;
            $total_persns = 0;

            $tota_comission_visa= 0;
            $tota_comission_vaope= 0;
            $tota_depositar= 0;

        @endphp
        @foreach($sales as $sale)
            @php
                $rows = count($sale->products);

if($sale->persons <= 0){
    $sale->persons = 1;
}

                $tota_st += $sale->sub_total;
                $tota_c += $sale->delivery;
                $tota_t += $sale->total_price;
                $tota_desc += $sale->discount;
                $total_persns += $sale->persons;

                $comision_visa = 0;
                $comision_vaope = 0;
                $depositar = 0;

                if($sale->productLiquidationDetail){
                     $comision_visa = $sale->productLiquidationDetail->payment_commission;
                    $comision_vaope = $sale->productLiquidationDetail->vaope_commission+$sale->productLiquidationDetail->sale_commission;
                    $depositar = $sale->productLiquidationDetail->total_deposit;
                }


            $tota_comission_visa += $comision_visa;
            $tota_comission_vaope += $comision_vaope;
            $tota_depositar += $depositar;


            @endphp
            <tr>
                {{--                <td rowspan="{{ $rows  }}">--}}
                {{--                   {{ $sale->product_id }}--}}
                {{--                </td>--}}
                <td rowspan="{{ $rows  }}">
                    @if($sale->seler)
                        {{ $sale->seler->name }}
                    @else
                        VAOPE.COM
                    @endif
                </td>
                <td rowspan="{{ $rows  }}">{{ $sale->id }}</td>
                <td rowspan="{{ $rows  }}">
                    @if(!empty($sale->operation_number))
                        {{ $sale->operation_number }}
                    @else
                        {{ $sale->purchase_number }}
                    @endif
                </td>

                <td rowspan="{{ $rows  }}">@if($sale->client)
                        {{ $sale->client->name }} {{ $sale->client->paternal_name }} {{ $sale->client->maternal_name }}
                    @endif</td>
                <td rowspan="{{ $rows  }}">@if($sale->client)
                        {{ $sale->client->document_type }} {{ $sale->client->document_number }}
                    @endif</td>
                <td rowspan="{{ $rows  }}">@if($sale->client)
                        {{ $sale->client->phone }}
                    @endif</td>
                <td rowspan="{{ $rows  }}">@if($sale->client)
                        {{ $sale->client->email }}
                    @endif</td>
                <td rowspan="{{ $rows  }}">{{ $sale->paid_at->format('d/m/Y H:i:s') }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->persons }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->sub_total/$sale->persons }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->sub_total }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->delivery }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->discount }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->total_price }}</td>
                <td rowspan="{{ $rows  }}">{{ $sale->paymentMethod->name }}</td>
                <td rowspan="{{ $rows  }}">
                    @if($sale->paymentMethod->id == 1 && $sale->transaction && $sale->transaction->billing_info)
                        {{ $sale->transaction->billing_info['banco_emisor']  }}
                        {{ $sale->transaction->billing_info['tarjeta_tipo']  }}
                        {{ $sale->transaction->billing_info['tarjeta_marca']  }}
                        {{--                    {{ $sale->transaction->billing_info['tarjeta']  }}--}}
                    @endif
                </td>
                <td rowspan="{{ $rows  }}">{{ $sale->giftcard }}
                    @if(!empty($sale->giftcardCode))
                        (<small>{{ $sale->giftcardCode->comments }}</small>)
                    @endif
                </td>


                <td rowspan="{{ $rows  }}">{{ ($comision_visa*-1) }}</td>
                <td rowspan="{{ $rows  }}">{{ ($comision_vaope*-1) }}</td>
                <td rowspan="{{ $rows  }}">{{ $depositar }}</td>


                <td rowspan="{{ $rows  }}">{{ $sale->getStageName() }}</td>
                <td>{{ $sale->products[0]->product_fee_id?$sale->products[0]->fee->name:'-' }}</td>
                <td>&nbsp;{{ $sale->products[0]->correlative }}</td>
                <td>{{ $sale->id }}</td>
                <td>{{ $sale->products[0]->product->title_small }}</td>
                <td>
                    @if($sale->products[0]->tipoEntrada && $sale->products[0]->tipoEntrada->date_term)
                        {!! $sale->products[0]->tipoEntrada->date_term->format("d/m/Y") !!}
                        {{ $sale->products[0]->tipoEntrada->hour_term }} Hrs
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->tipoEntrada && $sale->products[0]->tipoEntrada->superProductTerms)
                        {!! $sale->products[0]->tipoEntrada->superProductTerms->name !!}
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->nominated_at)
                        {!! $sale->products[0]->nom_dni !!}
                    @else
                        -
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->nominated_at)
                        {{ $sale->products[0]->nom_name }} {{ $sale->products[0]->nom_lastname }}
                    @else
                        -
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->tipoEntrada)
                        {!! $sale->products[0]->tipoEntrada->name !!}
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->ubicacion)
                        {!! $sale->products[0]->ubicacion->name !!}
                    @endif
                </td>
                <td>
                    @if($sale->products[0]->seat)
                        {!! $sale->products[0]->seat->seat_name !!}
                    @endif
                </td>

                <td>
                    @if($sale->products[0]->status_code == '1')
                        Acceso validado
                    @else
                        -
                    @endif
                </td>


                {{--            @php--}}
                {{--                $tota_det += $sale->products[0]->total_price;--}}
                {{--            @endphp--}}
            </tr>
            @foreach($sale->products as $num => $product)
                @if($num > 0)
                    <tr>
                        <td>{{ $product->product_fee_id?$product->fee->name:'-' }}</td>
                        <td>&nbsp;{{ $product->correlative }}</td>
                        <td>{{ $sale->id }}</td>
                        <td>{{ $product->product->title_small }}</td>
                        <td>
                            @if($product->tipoEntrada && $product->tipoEntrada->date_term)
                                {!! $product->tipoEntrada->date_term->format("d/m/Y") !!}
                                {{ $product->tipoEntrada->hour_term }} Hrs
                            @endif
                        </td>
                        <td>
                            @if($product->tipoEntrada && $product->tipoEntrada->superProductTerms)
                                {!! $product->tipoEntrada->superProductTerms->name !!}
                            @endif
                        </td>
                        <td>
                            @if($product->nominated_at)
                                {!! $product->nom_dni !!}
                            @else
                                -
                            @endif
                        </td>
                        <td>
                            @if($product->nominated_at)
                                {{ $product->nom_name }} {{ $product->nom_lastname }}
                            @else
                                -
                            @endif
                        </td>
                        <td>
                            @if($product->tipoEntrada)
                                {!! $product->tipoEntrada->name !!}
                            @endif
                        </td>
                        <td>
                            @if($product->ubicacion)
                                {!! $product->ubicacion->name !!}
                            @endif
                        </td>
                        <td>
                            @if($product->seat)
                                {!! $product->seat->seat_name !!}
                            @endif
                        </td>

                        <td>
                            @if($product->status_code == '1')
                                Acceso validado
                            @else
                                -
                            @endif
                        </td>
                    </tr>

                @endif

                @php
                    $tota_det += $product->total_price;
                @endphp

            @endforeach

        @endforeach

        <tr>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th></th>
            <th>{{ $total_persns }}</th>
            <th></th>
            <th><b>{{ $tota_st }}</b></th>
            <th><b>{{ $tota_c }}</b></th>
            <th><b>{{ $tota_desc }}</b></th>
            <th><b>{{ $tota_t }}</b></th>
            <th></th>
            <th></th>
            <th></th>

            <th>{{ ($tota_comission_visa*-1) }}</th>
            <th>{{ ($tota_comission_vaope*-1) }}</th>
            <th>{{ $tota_depositar }}</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>
        <tr>
            <td></td>
        </tr>
    @endforeach
</table>