@extends('admin/layouts/default')
{{-- Page title --}}
@section('title')
    Pricing
    @parent
@stop

{{-- page level styles --}}
@section('header_styles')

    <link href="{{ asset('assets/css/pages/pareto.css') }}" rel="stylesheet" type="text/css"/>




@stop
{{-- Page content --}}
@section('content')
    <section class="content-header">
        <!--section starts-->
        <h1>
            Pricing

            @if(\App\Models\Role_Permission::hasExportPermission())
                <button style="width: 100px; float: right; text-transform: capitalize; " id="button-md"
                        onclick="loading();setTimeout(function(){ save_tabel_and_chart('triangle-table', 'table2') }, 2000);">
                    Export
                </button>
            @endif

        </h1>

    </section>
    <!--section ends-->
    <section class="content">
        <div class="col-md-4">
            <!--lg-6 starts-->
            <!--basic form starts-->
            <div class="panel " id="hidepanel1">
                @if(Sentinel::inRole('admin'))
                    <div class="panel-body">
                        <form action="{{ route('admin.pricing_csv_upload')}}" name="upload" method="post"
                              enctype="multipart/form-data" class="pareto-menu form-horizontal">
                            {{csrf_field()}}
                            <div class="active-first-tier input-block file-uploader">
                                <div class="form-group">
                                    <div class="file-upload">
                                        <div class="file-select" style="">
                                            {{--<label class="col-md-3 control-label" id="h1-import"> Choose file to upload </label>--}}
                                            <div class="file-select-button" id="fileName">Choose File
                                                <label class="file-select-name" id="noFile" style="border-radius:0px;">No
                                                    file chosen...</label></div>
                                            <input type="file" name="csv_file" id="csv_file" required
                                                   class="form-control">
                                        </div>
                                    </div>

                                    <div>
                                        @if($errors->any())
                                            <h4 style="color: red;">{{$errors->first()}}</h4>
                                        @endif
                                    </div>
                                </div>
                            </div>
                            <div class="form-group">
                                <button type="submit" class="btn btn-responsive btn-primary btn-sm" style="width:29%;"
                                        id="button-lg">Upload
                                </button>
                            </div>
                        </form>


                    </div>
            @endif
            <!--main content-->

                <!--row starts-->
                <div class="panel-body">
                    <form class="form-horizontal pareto-menu">
                    {{--{{csrf_field()}}--}}
                    <!-- CSRF Token -->
                        <!-- Name input-->
                        <div class="form-position">
                            <button type="button" onClick="clearForm(this.form)" id="button-lg"
                                    class="btn btn-responsive btn-primary btn-lg">
                                Clear Inputs
                            </button>
                        </div>
                        <h2 class="first-tier-trigger">MEASURES
                            <i class="glyphicon glyphicon-chevron-up showhide clickable" title="Show Panel content"></i>
                        </h2>
                        <div class="active-first-tier input-block">

                            @include("admin.layouts.impact.dimensions")

                            @include("admin.layouts.impact.dateRange",  ["labelFrom" => "date-from", "labelTo" => "date-to", "name" => "Date Range",
                                                                            "requiredFrom" => "", "requiredTo" => ""])
                        </div>
                        <h2 class="first-tier-trigger">FILTERS
                            <i class="glyphicon glyphicon-chevron-up showhide clickable" title="Show Panel content"></i>
                        </h2>
                        <div class=" input-block">

                            @include("admin.layouts.impact.filters" , ["dataset"=> ""])
                        </div>
                        <div class="form-position">

                            <button type="submit" id="button-lg" class="btn btn-responsive btn-primary btn-lg">
                                Submit
                            </button>

                        </div>
                    </form>
                </div>
            </div>
        </div>

        <div class="col-md-8 pull-right">
            <!-- Stack charts strats here-->
            <div class="panel panel-primary no-search-datatable">
                <div class="panel-heading">
                    <h3 class="panel-title">
                        <i class="livicon" data-name="barchart" data-size="16" data-loop="true" data-c="#F0785F"
                           data-hc="#F0785F"></i> Pricing Chart
                        @include('admin.display_date_range')
                    </h3>
                    <span class="pull-right">
                        <i class="glyphicon glyphicon-chevron-up showhide clickable"></i>

                    </span>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <table id="triangle-table" width="100%">
                            @if(isset($dimension_name) and isset($dimension_array)and isset($date_array)and isset($graphic_values))
                                <tr>
                                    <td></td>
                                                                    </tr>
                                                            @endif
                        </table>
                    </div>

                    </br>
                </div>
            </div>

        </div>

        <div class="col-md-8 pull-right">
            <!-- Stack charts strats here-->
            <div class="panel panel-primary no-search-datatable">
                <div class="panel-heading">
                    <h3 class="panel-title">
                        <i class="livicon" data-name="barchart" data-size="16" data-loop="true" data-c="#F0785F"
                           data-hc="#F0785F"></i> Pricing Table
                    </h3>
                    <span class="pull-right">
                        <i class="glyphicon glyphicon-chevron-up showhide clickable"></i>

                    </span>
                </div>
                <div class="panel-body">

                    <div class="table-responsive height-scroll-table">
                        <table class="table table-striped table-bordered" width="100%" id="table2">
                            <thead>
                            <tr>
                                <th>Dimension</th>
                                <th>Date</th>
                                <th>Calculation Level (SKU)</th>
                                <th>Entity</th>
                                <th>Country</th>
                                <th>Segment</th>
                                <th>Freight included</th>
                                <th>Net Sales</th>
                                <th>Freight</th>
                                <th>Adjusted Net Sales</th>
                                <th>SQM</th>
                                <th>Actual Reference Price</th>
                                <th>Target Price</th>
                                <th>Color</th>
                            </tr>
                            </thead>
                            <tbody>

                            @if(isset($result))
                                @foreach ($result as $key => $dimension)

                                    <tr>
                                        @php($ok = true)
                                        <td> {{$key}}</td>

                                        @foreach ($dimension as $date => $entry)

                                            @if($ok)
                                                <td>{{$date}}</td>
                                                @php($ok = false)
                                            @else
                                                <tr>
                                                    <td></td>
                                                    <td>{{$date}}</td>

                                            @endif

                                            @php($ok2 = false)
                                            @if (array_key_exists('header', $entry))
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>


                                                <td> {{number_format($entry['header']['net_sales'], 2)}}</td>
                                                <td> {{number_format($entry['header']['sum_freight'], 2)}} </td>
                                                <td>{{number_format($entry['header']['excl_freight'], 2)}} </td>
                                                <td> {{number_format($entry['header']['sqm'], 2)}}</td>
                                                <td> {{number_format($entry['header']['actual_ref_price'], 2)}} </td>
                                                <td> {{number_format($entry['header']['target_price'], 2)}}</td>
                                                <td>
                                                    @if ($entry['header']['target_price'] <= $entry['header']['actual_ref_price'])
                                                        {{"green"}} @else  {{"red"}} @endif
                                                </td>

                                        </tr>

                                        
                                        @php($ok2 = true)

                                        @endif

                                            @foreach ($entry as $values)

                                                @if ($ok2)
                                                    <tr>
                                                        <td></td>
                                                        <td></td>
                                                @endif

                                                        <td>{{ $values['material_no']}} </td>
                                                        <td> {{str_replace("*", "", $values['entity'])}} </td>
                                                        <td>{{str_replace("*", "", $values['country'])}}</td>
                                                        <td> {{str_replace("*", "", $values['segment'])}}</td>
                                                        <td>
                                                            @if ($values['freight'] == 1) {{"Y"}} @else {{"N"}}@endif
                                                        </td>

                                                        <td> {{number_format($values['net_sales'], 2)}} </td>
                                                        <td>{{ number_format($values['sum_freight'], 2) }}</td>
                                                        <td> {{number_format($values['excl_freight'], 2)}} </td>
                                                        <td> {{number_format($values['Quantity_QM'], 2)}} </td>
                                                        <td> {{number_format($values['actual_ref_price'], 2)}} </td>
                                                        <td> {{number_format($values['target_price'], 2)}}</td>
                                                        <td>
                                                            @if ($values['target_price'] <= $values['actual_ref_price'])
                                                                {{"green"}} @else {{"red"}} @endif
                                                        </td>
                                                        @php($ok2 = true)
                                                    </tr>

                                            @endforeach

                                            </tr>


                                    @endforeach


                                @endforeach


                            @endif
                                        <tr>
                                            <td colspan='16'>
                                                <strong>*Filter criteria</strong> </br>

                                                @include("admin.filters_display", ['filter'=>$filters_name])

                                            </td>
                                        </tr>


                            </tbody>

                        </table>

                    </div>


                    <!-- End Of Main Application -->
                </div>
            </div>
        </div>
        <!--md-6 ends-->
        <!--main content ends-->
    </section>
    <!-- content -->
@stop

{{-- page level scripts --}}
@section('footer_scripts')

    <script src="{{ asset('assets/vendors/jasny-bootstrap/js/jasny-bootstrap.js') }}"></script>
    <script src="{{ asset('assets/vendors/iCheck/js/icheck.js') }}"></script>
    <script language="javascript" type="text/javascript" src="{{ asset('assets/js/pages/pricing.js') }}"></script>


@stop