@extends('layouts.app')
@section('title', 'Activities Comparizon Details')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header no-print">
    <h1>Activities Comparizon Details</h1>
</section>

<!-- Main content -->
<section class="content no-print">
    <div class="row">
        
            @component('components.filters', ['title' => __('report.filters')])

            <div class="col-md-10 mx-2">
            <label class="form-control bg-dark header-print"> Get Activities Comparizon At Date Range : {{$reportdate}} </label>
            </div>

            <div class="col-md-2 mx-2">
            <a href="/additional_reports/activities_comparizon" style="text-decoration: none;"><button class="form-control bg-dark  button" style="background: #e10f28 !important; color: white; border-radius: 50px; border-style: none; font-weight: 700;">New Report</button></a>
            </div>

            @endcomponent
        <!--</div>-->
        
        
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="box">
                <div class="box-body">
                    <div class="table-responsive">
                    <table id="dtBasicExample" class="table table-bordered table-striped text-center" >
                        <caption style="display: none;"><label class="form-control bg-dark header-print"> Get Activities Comparizon At Date Range : {{$reportdate}} and printed by : {{$printed_user}} </label></caption>
                        <thead>
                            <tr>
                                <th>Business Location</th>
                                <th>Activity Name</th>
                                <!--<th>Variation Name</th>-->
                                <th>{{ $reportdate }}</th>
                                <th>{{ $reportdate_year_before }}</th>
                                <th>{{ $daterange_new_formate }}</th>
                                <th>{{ $daterange_new_formate_year_before }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            <div style="display: none">
                                {{ $final_total_report_date_same_year = 0 }}
                                {{ $final_total_report_date_year_before = 0 }}
                                {{ $final_total_date_range_same_year = 0 }}
                                {{ $final_total_date_range_year_before = 0 }}
                             </div>
                            @foreach($queries as $query)
                            <tr>
                                
                                <td>{{$query->business_location_name}}</td>
                                <td>{{$query->product_name}}</td>
                                <!--<td>{{$query->variation_id}}</td>-->
                                <td>{{number_format($query->total_report_date_same_year  , 2)}}</td>
                                <td>{{number_format($query->total_report_date_year_before  , 2)}}</td>
                                <td>{{number_format($query->total_date_range_same_year  , 2)}}</td>
                                <td>{{number_format($query->total_date_range_year_before  , 2)}}</td>

                            </tr>
                            <div style="display: none">
                            	{{ $final_total_report_date_same_year += $query->total_report_date_same_year }}
                            	{{ $final_total_report_date_year_before += $query->total_report_date_year_before }}
                            	{{ $final_total_date_range_same_year += $query->total_date_range_same_year }}
                            	{{ $final_total_date_range_year_before += $query->total_date_range_year_before }}
                            </div>
                            @endforeach
                        </tbody>
                        <tfoot class="bg-gray">
                            <tr>
                                <th colspan='2' >Totals</th>
                                <th colspan='1' > {{ number_format($final_total_report_date_same_year , 2) }} </th>
                                <th colspan='1' > {{ number_format($final_total_report_date_year_before , 2) }} </th>
                                <th colspan='1' > {{ number_format($final_total_date_range_same_year , 2) }} </th>
                                <th colspan='1' > {{ number_format($final_total_date_range_year_before , 2) }} </th>
                            </tr>
                        </tfoot>
                    </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    
</section>


<style>
    tr.odd td:first-child,
tr.even td:first-child {
    padding-left: 4em;
}
</style>

@endsection


@section('javascript')
<script>
   $(document).ready(function () {
    $('#dtBasicExample').DataTable({  
        aLengthMenu: [[10, 25, 50, 75, -1], [10, 25, 50, 75, "All"]],
        iDisplayLength: -1,
        });

});
</script>
@endsection