@php
    use App\Http\Controllers\Mod\ModCommissionSales;use App\Http\Controllers\Mod\ModSalesOrder;use App\Http\Controllers\Mod\ModSalesOrderPaymentMethod;use App\Http\Controllers\ModFinancial;use App\Models\NewClasses;use Illuminate\Support\Facades\Crypt;

    $total_value=0;
$sales_value=0;
$value_type = isset($value_type)?$value_type:1;

                $n_seller = 0;
            $bonus_value=0;
                             $bonus_value_total = 0;
@endphp

        <!-- LAYOUT -->
<!-- TITLE -->
<div class="rpanel-title sticky-top">
    <i class="fa fa-dollar"></i> {{$title}}
</div>
<!-- /TITLE -->
<!-- CONTENT -->
<div class="r-panel-body ">

    <blockquote>

        <div class="row">
            <div class="col-sm-9" id="indexFormSideSearch">
                <input type="text" name="sideBarSearchString" id="sideBarSearchString"
                       class="form-control form-control-line"
                       required="" value="" placeholder="Pesquisar" style="height: 25px;font-size: 14px;">
            </div>

        </div>

    </blockquote>
    <blockquote>

        <div class="row text-muted">
            <div class="col-sm-6" id="indexFormSideSearch">
                <strong> {{$title_due}} </strong>
            </div>
            <div class="col-sm-3">
                Qtdd:
                <span class="label label-rouded label-themestyle" id="totalQtt">{{count($record)}}</span>
            </div>
            <div class="col-sm-3">
                Total:
                R$ <strong id="totalValue"></strong>
            </div>

        </div>
        <div class="row text-muted">
            <div class="col-sm-6">
                <small>
                    <strong>Período:</strong>
                    <span class="label label-rouded label-muted">{{$date_range}}</span>
                </small>
            </div>
        </div>

    </blockquote>

    <div id="indexSearchSideBar">
        <table class="table  stylish-table font-13 ">
            <thead>
            <tr class="hide" >
                <th>&nbsp</th>
            </tr>
            </thead>
            <tbody class="card-search-p">
            @foreach($record as $row_profile)

                @php

                //------------------------------------------------
                 //REGISTRO | FINANCEIRO: RECEITA EVETUAL
                 $record_salesorder = ModSalesOrder::informationSimple([
                     'selectString' =>
                         'idSalesOrder,
                             idNegotiation,
                             idUserResponsible,
                             idClientProvider,
                             clientName,
                             clientPhone,
                             cnpjCpf,
                             city,
                             state,
                             shippingFee,
                             idPaymentMethod,
                             idPaymentMethodRecurrent',

                     'idPaymentMethod' => '1',//Parcelados
                     'idSalesOrderStatus' => '3,9', //FATURADO

                     'dateRange' => $date_range,
                     'idUserResponsible' => $row_profile->idUser,
                     'optionList' => 'g',
                     'optionListQtt' => 'a',
                 ]);

                 $record_value_total = 0;

                $bonus_value_subtotal = 0;
                @endphp
                @if (count($record_salesorder) >= 1)

                    <tr class="card-search-itens">

                        <td class="text-left align-top">
                            @php

                                //VERIFICA PEDIDOS
                                if (count($record_salesorder) >= 1) {
                                    //Quantos de premiados
                                    $n_seller++;
                                }
                            @endphp
                            <blockquote class="m-b-0">
                                <div class="card-header titulo_empresa_clientes titulo_empresa_clientes_2"
                                     title="A GUIDI &amp;AMP; CIA LTDA">
                                    <a class="get-code text-themecolor titulo_empresa_clientes_2" data-toggle="collapse"
                                       href="#sideBardescriptionSalesOrder{{$row_profile->idUser}}"
                                       aria-expanded="true">
                                        <h5 class="card-title" style="margin-top: .75rem;">
                                            <i class="mdi mdi-arrow-down-drop-circle " title="DETALHES"
                                               style="padding-left: 10px; font-style: normal; color: var(--cor-destaque); ">
                                            </i> |
                                            <span>
                                                {{$row_profile->userName}}
                                            </span>
                                            <span class=" pull-right">
                                               <div style="width: 125px">
                                                   <small class="pull-left">R$</small>
                                                   <span class="pull-right"
                                                         id="valueSallerMonth{{$row_profile->idUser}}">  {{$bonus_value}}</span>
                                               </div>
                                            </span>

                                        </h5>
                                    </a>
                                </div>
                                <h6 class="card-title m-t-10 m-l-10">
                                    <small class="font-weight-bold">Função:</small>
                                    <small>{{$row_profile->userRole}}</small><br>
                                    <small class="font-weight-bold">e-mail:</small>
                                    <small>{{$row_profile->userEmail}}</small>
                                </h6>

                                <div id="sideBardescriptionSalesOrder{{$row_profile->idUser}}" aria-expanded="true"
                                     class="collapse " style="">
                                    <hr>
                                    <span class="   font-13" id="sideBarMeta{{$row_profile->idUser}}">

                                    </span>
                                    <hr>

                                    <table class="table  stylish-table font-13 ">
                                        @foreach ($record_salesorder as $row)
                                            @php
                                                $record_value = 0;
                                                $record_method = ModSalesOrderPaymentMethod::paymentMethod('0', $row->idSalesOrder);
                                                foreach ($record_method as $row_method) {
                                                    $record_value += isset($row_method->quotaValue) ? $row_method->quotaValue : 0;
                                                }

                                                $record_value_total += $record_value;
                                            @endphp
                                            <tr class="card-search-itens">
                                                <td class="text-left align-top">
                                                    <div style="width: 200px; ">
                                                        <div style="display: inline-grid; width: 50px;">

                                                            <button type="button"
                                                                    class="right-side-open btn waves-effect waves-light "
                                                                    title="PROPOSTA" data-target="sidebar-right"
                                                                    onclick="loadsDataForm('#sidebarRight  .content','{{url('/negotiation-proposal/info')}}/{{ Crypt::encrypt($row->idSalesOrder)}}','#actionIndexNot',['#_token'])">
                                                                <i class="fa fa-external-link-square font-18"
                                                                   style="color: coral;"></i>
                                                            </button>


                                                        </div>
                                                        <div style="display: inline-table; width: 130px; ">
                                                            |<small> Negociação: </small>
                                                            {{$row->idSalesOrder}}<br>
                                                            | <small><strong>Proposta: </strong></small>
                                                            <strong> {{$row->idNegotiation}}</strong>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td class="text-left align-top">
                                                    <div style="min-width: 250px;">
                                                        <small class="text-uppercase" style="white-space:normal ;">


                                                            <strong>  {{$row->clientName}} </strong><br>

                                                            <div class="border-top p-t-5"
                                                                 style="padding-left: 5px; padding-top: 5px; padding-bottom: 5px;">
                                                                Cnpj/Cpf: {{$row->cnpjCpf}}<br>
                                                                &nbsp;| Cid.: {{$row->city}}/{{$row->state}}<br>


                                                            </div>

                                                        </small>

                                                    </div>
                                                </td>
                                                <td class="text-right align-top">

                                                    &nbsp;<span class="pull-left">R$</span>
                                                    {{ModFinancial::formatMoney($record_value,'pt_BR')}}
                                                </td>
                                        @endforeach
                                        @php
                                            //----------------------------------------------------------------------
                                            //COMISSIONAMENTO
                                            $data = new NewClasses();
                                            $data->salesValue = $record_value_total;
                                            $data->idUserCommission = $row_profile->idUser;
                                            $data->idPaymentMethod = 1;
                                            $record_commission = ModCommissionSales::analyze($data);

                                            if(count($record_commission->commissionTable)>=1){
                                                $bonus_value = $record_commission->commissionTable[0]->bonusValue;
                                                $table_name = $record_commission->commissionTable[0]->tableName;
                                                $bonus = $record_commission->commissionTable[0]-> bonus;
                                                $range_start_value = $record_commission->commissionTable[0]->rangeStartValue;
                                                $range_end_value = $record_commission->commissionTable[0]->rangeEndValue;

                                             }
                                            $bonus_value_subtotal += $bonus_value;

                                            $bonus_value_total += $bonus_value_subtotal
                                        @endphp
                                                <script>
                                                    $(function () {
                                                        $('#valueSallerMonth{{$row_profile->idUser}}').html('{{ModFinancial::formatMoney($bonus_value,'pt_BR')}}');

                                                        var v_meta =
                                                            '<div class="m-l-10 m-t-10 text-left">'+
                                                            '   <small><b> Meta: </b> </small> {{isset($table_name)?$table_name:'---'}} |'+
                                                            '   <small><b> Bonus: </b> </small> {{ModFinancial::formatMoney(isset($bonus)?$bonus:0,'pt_BR')}} %'+
                                                            '</div>'+
                                                            '<div class=" m-l-10 m-b-20 text-left">'+
                                                            '   <small><b> Inicio: </b>  R$</small> {{ModFinancial::formatMoney(isset($range_start_value)?$range_start_value:0,'pt_BR')}} | '+
                                                            '   <small><b> Final: </b>  R$ </small> {{ModFinancial::formatMoney(isset($range_end_value)?$range_end_value:0,'pt_BR')}} '+
                                                            '</div>';
                                                        $('#sideBarMeta{{$row_profile->idUser}}').html(v_meta);

                                                    });
                                                </script>
                                            </tr>

                                    </table>

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


                    </tr>
                @endif
            @endforeach

            </tbody>
        </table>
    </div>

</div>
<!-- /CONTENT -->
<!-- /LAYOUT -->


<script src="{{ asset('template/plugins/ozi-sidebar-right/sidebar-right.js') }}" type="text/javascript"></script>

<script>
    $(document).ready(function () {
        $('#totalValue').html('{{ ModFinancial::formatMoney($bonus_value_total, 'pt_BR') }}');
        $('#totalQtt').html('{{$n_seller}}');

        $("#sideBarSearchString").on("keyup", function () {

            var value = $(this).val().toLowerCase();
            if ((value.length != 2) || (value.length == 0)) {
                $(".card-search-p .card-search-itens").filter(function () {
                    $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
                });
            }
        });
    });
</script>