@php
    use App\Http\Controllers\Mod\ModNegotiationOrigin;
    use App\Http\Controllers\Mod\ModPaymentMethodRecurrent;
    use App\Http\Controllers\Mod\ModSalesOrderPaymentMethod;
    use App\Http\Controllers\ModFinancial;

@endphp
@include('system-layouts/head')
@include('mod-report.title-report')


<div class="container-fluid">

    <div class="card">
        <!-- card -->
        <div class="card-body" id="concludedDefault">
            <div class="card-header" style="background-color: #FFFFFF;">
                <h3 style="margin-top: -15px;">Origem das negociações</h3>
            </div>
            <div style=" overflow: auto;">
                <table class="table  stylish-table font-13" role="grid" aria-describedby="DataTables_Table_0_info">
                    <thead>
                    <tr>
                        {{-- ORIGEM--}}
                        <th>
                        </th>
                        {{-- ANALISE--}}
                        <th class="text-center ">
                        </th>
                        <th class="text-center ">
                        </th>
                        {{-- TOTAL--}}

                        <th class="text-center " colspan="4">
                            TOTAL<br>
                            <small> Forma de pagamento</small>
                        </th>


                        {{-- BASE--}}
                        <th class="text-center columm-title columm-select-b1 align-middle " colspan="4">
                            FATURADO
                        </th>
                        <th class="text-center columm-title columm-select-b2 align-middle" colspan="4">
                            PENDENTE
                        </th>

                    </tr>
                    <tr>
                        {{-- ORIGEM--}}
                        <th>
                        </th>
                        {{-- ANALISE--}}
                        <th class="text-center columm-title-b-r" colspan="2">
                            Todas as Propostas
                        </th>


                        {{-- TOTAL--}}
                        <th class="text-center columm-title " style="" colspan="2">
                            Vendas
                        </th>
                        <th class="text-center columm-title" colspan="2">
                            Recorrente
                        </th>


                        {{-- BASE--}}
                        <th class="text-center columm-title" style="" colspan="2">
                            Vendas
                        </th>
                        <th class="text-center columm-title" colspan="2">
                            Recorrente
                        </th>


                        <th class="text-center columm-title" colspan="2">
                            Vendas
                        </th>
                        <th class="text-center columm-title" colspan="2">
                            Recorrente
                        </th>

                    </tr>
                    <tr>
                        {{-- ORIGEM--}}
                        <th class="text-center">
                            Origem das negociações
                        </th>

                        {{-- TOTAL--}}
                        <th class="text-center columm-value">
                            Qtdd
                        </th>
                        <th class="text-center columm-value" title="Aproveitamento">
                            %
                        </th>

                        {{-- BASE--}}
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>


                        {{-- FATURADO--}}
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>

                        {{-- PENDENTE--}}
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>
                        <th class="text-center">
                            Qtdd
                        </th>
                        <th class="text-center">
                            Valor
                        </th>

                    </tr>
                    </thead>
                    <tbody>
                    {{--                @php dd($record_ranger_responsible); @endphp--}}
                    @php

                        //TOTAL
    //                    $record_origin_total = ModOrigin::informationSalesorder([
    //                        'selectString'=>'idOrigin,idSalesOrder,idUserResponsible' ,
    //                       // 'idOrigin' => $row->idOrigin,
    //                        'distinct'=>'on',
    //                        //'idSalesOrderStatus' => '9,3', //VENDAS REALIZADA
    //
    //                        'dateRange'=>  Request::input('dateRangeEdit'),
    //                        'dateRangeName' => 'clientAcceptedDate,sellerDate',//Data de criação
    //                        'idUserResponsible'=>$record_ranger_responsible,
    //
    //                        'orderByName'=> 'idUserResponsible',
    //                        'optionList'=>'g',
    //                        'optionListQtt'=>'a',
    //                        ]);
    //
    //                $count_total = count($record_origin_total);
                    @endphp
                    @foreach($record_report as $row)
                        @php
//                            $record_origin_subtotal = ModOrigin::informationSalesorder([
//
//                                'selectString'=>'idOrigin,idSalesOrder,idUserResponsible,created_at,clientAcceptedDate,sellerDate',
//                                'idOrigin' => $row->idOrigin,
//                                'distinct'=>'on',
//                                //'idSalesOrderStatus' => '9,3', //VENDAS REALIZADA
//
//                                'dateRange'=>  Request::input('dateRangeEdit'),
//                                'dateRangeName' => 'created_at',//Data de criação
//                                'idUserResponsible'=>96,
//
//                                'orderByName'=> 'idUserResponsible',
//                                'optionList'=>'g',
//                                'optionListQtt'=>'a',
//                                ]);

                            //dev

//                          $date_range_name = 'clientAcceptedDate,sellerDate';

//                            $record = DB::table('view_salesorder_origin');
//                            $record = $record->where(['idOrigin' => $row->idOrigin,'idUserResponsible'=>96,]);

//                              $data_range_xmulti = explode(',', $date_range_name);
//                                    if (is_array($data_range_xmulti) === true) {
//
//                                        if (count($data_range_xmulti) >= 2) {
//                                            //--------------------
//                                            //Direfenrença entre datas por quantidade de colunas
//                                            foreach ($data_range_xmulti as $row_xmulti) {
//                                                $record = $record->where(function ($query) use ('2023-04-01 00:00:00', '2023-05-08 00:00:00', $row_xmulti) {
//                                                    $date_range_name = $row_xmulti;
//                                                    $query->orWhereBetween($date_range_name, ['2023-04-01', '2023-05-08'])
//                                                        ->orWhere($date_range_name, null);
//                                                });
//                                            }
//                                            //--------------------
//                                            //Iqualdades entre datas por quantidade de colunas
//                                            $record = $record->where(function ($query) use ($data_range_xmulti) {
//                                                foreach ($data_range_xmulti as $row_xmulti) {
//                                                    $query = $query->orWhere($row_xmulti, '!=', null);
//                                                }
//                                            });
//
//                                        } else {
//                                            //----------------------------------------
//                                            //simples
//                                            $record = $record->whereBetween($date_range_name, [$date_start, $date_end]);//PERIODO DAS DATA
//                                        }
//                                    }

//                           $record = $record ->orderByDesc('created_at')->get();

                         //    dd($record_origin_subtotal, Request::input('dateRangeEdit'),$record);
                        @endphp


                        @php

                            //TOTAL
                            $record_origin_subtotal = ModNegotiationOrigin::informationSalesOrderLast([
                                'selectString'=>'idOrigin,idSalesOrder,idUserResponsible' ,
                                'idOrigin' => $row->idOrigin,
                                'distinct'=>'on',
                                //'idSalesOrderStatus' => '9,3', //VENDAS REALIZADA

                                'dateRange'=>  Request::input('dateRangeEdit'),
                                'dateRangeName' => 'clientAcceptedDate,sellerDate',//Data de criação
                                'idUserResponsible'=>$record_ranger_responsible,

                                'orderByName'=> 'idUserResponsible',
                                'optionList'=>'g',
                                'optionListQtt'=>'a',
                                ]);

                        //    dd($record_origin_subtotal);

                            $count_subtotal = count($record_origin_subtotal);
                            $calc_value_pt = 0;
                            $calc_value_rt=0;


                                //FORMA DE PAGAMENTO: PADRAO
                                $record_origin = ModNegotiationOrigin::informationSalesOrderLast([
                                    'selectString'=>'idOrigin,idNegotiation,idSalesOrder,idPaymentMethod,idPaymentMethodRecurrent,shippingFee' ,
                                    'idOrigin' => $row->idOrigin,

                                    'idSalesOrderStatus' => '9', //VENDAS REALIZADA
                                    'idPaymentMethod'=>1,

                                    'dateRange'=>  Request::input('dateRangeEdit'),
                                    'dateRangeName'=>'clientAcceptedDate,sellerDate',
                                    'idUserResponsible'=>$record_ranger_responsible,

                                    'optionList'=>'g',
                                    'optionListQtt'=>'a',

                                    ]);
                                $count=count($record_origin);
                                $calc_value=0;
                                foreach ($record_origin as $row_so){
                                    //FORMA DE PAGMTO: PARCELADO
                                    $record_method = ModSalesOrderPaymentMethod::paymentMethod('0', $row_so->idSalesOrder);
                                    foreach ($record_method as $row_method) {
                                        $calc_value += isset($row_method->quotaValue) ? $row_method->quotaValue : 0;
                                    }
                                }



                                //FORMA DE PAGAMENTO: PADRAO
                                $record_origin = ModNegotiationOrigin::informationSalesOrderLast([
                                    'selectString'=>'idOrigin,idNegotiation,idSalesOrder,idPaymentMethod,idPaymentMethodRecurrent,shippingFee' ,
                                    'idOrigin' => $row->idOrigin,
                                    'idSalesOrderStatus' => '3', //PENDENTE
                                    'idPaymentMethod'=>1,

                                    'dateRange'=>  Request::input('dateRangeEdit'),
                                    'dateRangeName'=>'clientAcceptedDate,sellerDate',
                                    'idUserResponsible'=>$record_ranger_responsible,

                                    'optionList'=>'g',
                                    'optionListQtt'=>'a',

                                    ]);
                                $count_pf=count($record_origin);
                                $calc_value_pf=0;
                                foreach ($record_origin as $row_so){
                                    //FORMA DE PAGMTO: PARCELADO
                                    $record_method = ModSalesOrderPaymentMethod::paymentMethod('0', $row_so->idSalesOrder);
                                    foreach ($record_method as $row_method) {
                                        $calc_value_pf += isset($row_method->quotaValue) ? $row_method->quotaValue : 0;
                                    }
                                }

                                //------------------------------------------------------------------------------------
                                //FORMA DE PAGAMENTO: RECORRENTE
                               $record_origin_r = ModNegotiationOrigin::informationSalesOrderLast([
                                    'selectString'=>'idOrigin,idNegotiation,idSalesOrder,idPaymentMethod,idPaymentMethodRecurrent,shippingFee' ,
                                    'idOrigin' => $row->idOrigin,
                                     'idSalesOrderStatus' => '9', //VENDAS REALIZADA
                                    'idPaymentMethod'=>2,

                                    'dateRange'=>  Request::input('dateRangeEdit'),
                                    'dateRangeName'=>'clientAcceptedDate,sellerDate',
                                    'idUserResponsible'=>$record_ranger_responsible,

                                    'optionList'=>'g',
                                    'optionListQtt'=>'a',

                                    ]);

                                $count_r=count($record_origin_r);
                                $calc_value_r=0;

                                foreach ($record_origin_r as $row_so){
                                $calc_value_r += $row_so->shippingFee;
                                    //Escolhe o metodo de pagamento
                                    //FORMA DE PAGMTO: RECORRENTE
                                    $record_value_rec = ModPaymentMethodRecurrent::information([
                                        'idSalesOrder' => $row_so->idSalesOrder,
                                        'idStatusReg' => 1,
                                        'sumValue' => 'on',
                                        'groupBy' => 'idSalesOrder',
                                    ]);

                                    $calc_value_r += isset($record_value_rec->value) ? $record_value_rec->value : 0;
                                }


                               //------------------------------------------------------------------------------------
                               //PENDENTE
                               //FORMA DE PAGAMENTO: RECORRENTE
                               $record_origin_pr=ModNegotiationOrigin::informationSalesOrderLast([
                                    'selectString'=>'idOrigin,idNegotiation,idSalesOrder,idPaymentMethod,idPaymentMethodRecurrent,shippingFee' ,
                                    'idOrigin' => $row->idOrigin,
                                     'idSalesOrderStatus' => '3', //VENDAS REALIZADA
                                    'idPaymentMethod'=>2,

                                    'dateRange'=>  Request::input('dateRangeEdit'),
                                    'dateRangeName'=>'clientAcceptedDate,sellerDate',
                                    'idUserResponsible'=>$record_ranger_responsible,

                                    'optionList'=>'g',
                                    'optionListQtt'=>'a',

                                    ]);

                                $count_pr=count($record_origin_pr);
                                $calc_value_pr=0;
                                foreach ($record_origin_pr as $row_so){
                                $calc_value_pr += $row_so->shippingFee;

                                    //Escolhe o metodo de pagamento
                                    //FORMA DE PAGMTO: RECORRENTE
                                    $record_value_rec = ModPaymentMethodRecurrent::information([
                                        'idSalesOrder' => $row_so->idSalesOrder,
                                        'idStatusReg' => 1,
                                        'sumValue' => 'on',
                                        'groupBy' => 'idSalesOrder',
                                    ]);

                                 $calc_value_pr += floatval(isset($record_value_rec->value) ? $record_value_rec->value : 0);
                                }
                        @endphp
                        @php
                            $id=$row->idOrigin;
                        @endphp

                        <tr role="row" id="idRow{{$id}}" class="toggleInfor bg-themecolor-opacidad-0 "
                            style="cursor: pointer">

                            {{-- ORIGEM--}}
                            <td>
                                <input type="hidden" name="idRowInput" id="idRow{{$id}}Input" value="{{$id}}">
                                {{$row->xName}}
                            </td>

                            {{-- TOTAL--}}
                            <td class="qtdd-t text-center columm-value columm-select-a1">
                                {{$count_subtotal}}
                            </td>
                            <td class="value-cent text-center columm-value columm-select-a2">
                                {{--                            {{$count+$count_pf+$count_r+$count_pr}}--}}
                                @php
                                    $soma = $count+$count_pf+$count_r+$count_pr;

                                    $result=0;
                                    if($soma != 0) {
                                       // dd($count_subtotal,$soma,$result );
                                        if($count_subtotal != 0) {
                                          $result = ModFinancial::porcentagemConvert($soma,$count_subtotal);
    //                                        $result=$soma*100;
    //                                        $result=$result/$count_total;
                                        }

                                    }
                                       echo  ModFinancial::formatMoney( $result,'pt_BR').'%';


                                @endphp

                            </td>


                            {{-- BASE--}}
                            <td class="qtdd-tf text-center columm-value">
                                {{$count+$count_pf}}
                            </td>
                            <td class="value-tf text-right columm-value columm-select-b1 ">
                                {{ModFinancial::formatMoney($calc_value+$calc_value_pf,'pt_BR')}}
                            </td>
                            <td class="qtdd-tr text-center columm-value ">
                                {{$count_r+$count_pr}}
                            </td>
                            <td class="value-tr text-right columm-value columm-select-b1 ">
                                {{ModFinancial::formatMoney($calc_value_r+$calc_value_pr,'pt_BR')}}
                            </td>


                            {{-- FATURADO--}}

                            <td class="qtdd-ff text-center columm-value">
                                {{$count}}
                            </td>
                            <td class="value-ff text-right columm-value">
                                {{ModFinancial::formatMoney($calc_value,'pt_BR')}}
                            </td>
                            <td class="qtdd-fr text-center columm-value">
                                {{$count_r}}
                            </td>
                            <td class="value-fr text-right columm-value">
                                {{ModFinancial::formatMoney($calc_value_r,'pt_BR')}}
                            </td>


                            {{-- PENDENTE--}}
                            <td class="qtdd-pf text-center columm-value">
                                {{$count_pf}}
                            </td>
                            <td class="value-pf text-right columm-value">
                                {{ModFinancial::formatMoney($calc_value_pf,'pt_BR')}}
                            </td>
                            <td class="qtdd-pr text-center columm-value">
                                {{$count_pr}}
                            </td>
                            <td class="value-pr  text-right columm-value">
                                {{ModFinancial::formatMoney($calc_value_pr,'pt_BR')}}
                            </td>


                        </tr>


                        {{--INFORMACOES--}}
                        <tr role="row" id="idRow{{$row->idOrigin}}Infor" class="hide">
                            {{-- ORIGEM--}}
                            <td colspan="15" class="text-center p-0">

                            </td>
                        </tr>
                    @endforeach
                    <tr role="row" class=" columm-select-b2 font-14 font-weight-bold text-muted">
                        {{-- ORIGEM--}}
                        <td>
                            TOTAL
                        </td>
                        {{-- ANALISE--}}
                        <td id="qtddTotal" class="text-center columm-value columm-select-a1">
                            0
                        </td>
                        <td id="valueTotal" class="value-t text-center columm-value columm-select-a2">
                            0,0
                        </td>

                        {{-- TOTAL--}}
                        <td id="qtddTF" class="text-center columm-value">
                            0
                        </td>
                        <td id="valueTF" class="text-right columm-value">
                            0,0
                        </td>

                        <td id="qtddTR" class="text-center columm-value">
                            0
                        </td>
                        <td id="valueTR" class="text-right columm-value">
                            0,0
                        </td>

                        {{-- FATURADO--}}
                        <td id="qtddFF" class="text-center columm-value">
                            0
                        </td>
                        <td id="valueFF" class="text-right columm-value">
                            0,0
                        </td>
                        <td id="qtddFR" class="text-center columm-value">
                            0
                        </td>
                        <td id="valueFR" class="text-right columm-value">
                            0,0
                        </td>

                        {{-- PENDENTE--}}
                        <td id="qtddPF" class="text-center columm-value">
                            0
                        </td>
                        <td id="valuePF" class="text-right columm-value">
                            0,0
                        </td>
                        <td id="qtddPR" class="text-center columm-value">
                            0
                        </td>
                        <td id="valuePR" class="text-right columm-value">
                            0,0
                        </td>


                    </tr>
                    </tbody>
                </table>
            </div>
        </div>
        <!--/ card -->
    </div>

    <div class="card">
        <!-- card -->
        <div class=" card-body-">
            <blockquote class="text-muted">
                <h5 class="text-muted"><strong>Descrições </strong></h5>
                <div class="m-l-10">
                    <h6 class="text-muted"><strong> Todas as propostas: </strong></h6>
                    <small>A partir da origem da negociação, lista todas as propostas pelas data do ultimo evento de
                        alteração "Origem"</small>
                    <h6 class="m-t-10 text-muted"><strong> Total Faturado/Recorrente: </strong></h6>
                    <small>A partir da origem da negociação, lista todas as propostas pelas data de aceite do cliente e
                        da liberação do gerente com a forma de pagamento da proposta Vendas e/ou Recorrente</small>
                    <h6 class="m-t-10 text-muted"><strong> Total Faturado/Recorrente=faturado/Pendente:</strong></h6>
                    <small>A partir da origem da negociação, lista todas as proposta pelas data de aceite do cliente e
                        da liberação do gerente com a forma de pagamento da proposta Vendas e/ou Recorrente e com os
                        status de pagamento faturado e pendente </small>
                    <h6 class="m-t-10 text-muted"><strong> Listas de Usuários:</strong></h6>
                    <small>Lista: Os usuários Administradores, Supervisor de Vendas e Vendedores.<br> Não listar:
                        Usuarios que não tiveram registro de proposta </small>
                    <hr>
                    <h5 class="text-muted"><strong>Descrições dos vendedores </strong></h5>
                    <h6 class="text-muted">Origem de negociações por vendedores </h6>

                    <h6 class="text-muted">Lista os vendedores com as respectivas vendas;</h6>


                </div>
            </blockquote>
        </div>
    </div>


</div>


@include('system-layouts/footer')
<script>
    $(document).ready(function () {

        //--------------------------------------
        //TOTAL: QTDD
        var v_value = 0;
        $(".qtdd-t").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddTotal').html(v_value)
        //--------------------------------------
        // //TOTAL: VALOR
        // var v_value = 0;
        // $(".value-t").each(function () {
        //     v_value += convertPonto($(this).html());
        // });
        //   var v_value = convertVirgola(v_value.toFixed(2));
        // $('#valueTotal').html(v_value)

        //--------------------------------------
        //--------------------------------------
        //FATURADO RECORRENTE: QTDD
        var v_value = 0;
        $(".qtdd-tf").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddTF').html(v_value);
        //--------------------------------------
        //FATURADO RECORRENTE: VALOR
        var v_value = 0;
        $(".value-tf").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valueTF').html(v_value);
        //--------------------------------------
        //--------------------------------------
        //FATURADO RECORRENTE: QTDD
        var v_value = 0;
        $(".qtdd-tr").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddTR').html(v_value);
        //--------------------------------------
        //FATURADO RECORRENTE: VALOR
        var v_value = 0;
        $(".value-tr").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valueTR').html(v_value);

        //--------------------------------------
        //--------------------------------------
        //FATURADO FATURADO: QTDD
        var v_value = 0;
        $(".qtdd-ff").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddFF').html(v_value)
        //--------------------------------------
        //FATURADO FATURADO: VALOR
        var v_value = 0;
        $(".value-ff").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valueFF').html(v_value);
        //--------------------------------------
        //--------------------------------------
        //FATURADO RECORRENTE: QTDD
        var v_value = 0;
        $(".qtdd-fr").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddFR').html(v_value);
        //--------------------------------------
        //FATURADO RECORRENTE: VALOR
        var v_value = 0;
        $(".value-fr").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valueFR').html(v_value);
        //--------------------------------------
        //--------------------------------------
        //FATURADO RECORRENTE: QTDD
        var v_value = 0;
        $(".qtdd-pf").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddPF').html(v_value);
        //--------------------------------------
        //FATURADO RECORRENTE: VALOR
        var v_value = 0;
        $(".value-pf").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valuePF').html(v_value);
        //--------------------------------------
        //--------------------------------------
        //FATURADO RECORRENTE: QTDD
        var v_value = 0;
        $(".qtdd-pr").each(function () {
            v_value += convertPonto($(this).html());
        });
        $('#qtddPR').html(v_value);
        //--------------------------------------
        //FATURADO RECORRENTE: VALOR
        var v_value = 0;
        $(".value-pr").each(function () {
            v_value += convertPonto($(this).html());
        });
        var v_value = convertVirgola(v_value.toFixed(2));
        $('#valuePR').html(v_value);


        $('.toggleInfor').click(function () {
            var v_id_pri = $(this).attr('id');

            $('#' + v_id_pri + 'Infor').toggle("show", function () {
                //  console.log(this,$(this).attr('class'))
                if ($(this).attr('class') == 'hide') {
                    //TEMPO DE CARREGAMENTO
                    var v_load = '<td colspan="15" class="text-center"  ><div class="d-flex justify-content-center">' +
                        '<div class="spinner-border" role="status">' +
                        '<span class="sr-only">Loading...</span>' +
                        '</div> ' +
                        '</div></td>'

                    $('#' + v_id_pri + 'Infor').html(v_load);

                    loadsDataForm('#' + v_id_pri + 'Infor', '{{url("report/3-1")}}', '#actionNot', ['#_token', '#dateRangeEdit', '#' + v_id_pri + 'Input']);
                } else {
                    $('#' + v_id_pri + 'Infor').remove();
                }
            });

            // var newRowContent = '<tr role="row" id="idRow1Infor" class="">' +
            //                     ' <td colspan="15" class="text-center"  >555</td>' +
            //                     '</tr>';
            //
            // $("#idRow1").after(newRowContent);
        });


    });
</script>