@php
    use Illuminate\Support\Facades\DB;
    $monthWise           =   [];
    $target_target_arr     =   [];
    $netsale_target_arr  =   [];
    $achvment_target_arr  =   [];
    $gawt_target        =   0;
    $gdt_target     =   0;
    $gdt_cus_target     =   0;
    error_reporting(0);
@endphp
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <td colspan="6">
            <b>Per Capita Consumption Report</b>
        </td>

    </tr>
    <tr>
        <td colspan="2"><b>Start Month:</b></td>
        <td>{{date('M-Y',strtotime($start_date))}}</td>
        <td colspan="2"><b>End Month:</b></td>
        <td>{{date('M-Y',strtotime($end_date))}}</td>
    </tr>
    </thead>
</table>
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <th rowspan="2" style="background-color: #F9F9F9"><b>City/Town</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Province Name</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>City/Town Tier</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Population</b></th>
        @foreach($months as $month)
            <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>{{date('M-Y',strtotime($month.'-01'))}}</b></th>
        @endforeach
{{--        <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>Overall</b></th>--}}
    </tr>
    <tr>
        @foreach($months as $month)
            <th style="background-color: #F9F9F9"><b>Net Sales (CTNs)</b></th>
            <th style="background-color: #F9F9F9"><b>Net Sales (PCs)</b></th>
            <th style="background-color: #F9F9F9"><b>Per Capita Cons.</b></th>
        @endforeach
{{--
            <th style="background-color: #F9F9F9"><b>Per Capita Cons.</b></th>
            <th style="background-color: #F9F9F9"><b>Net Sales</b></th>
--}}
    </tr>
    </thead>
    <tbody>
    @foreach($cities as $city)
        @php
            $city_arr =collect($data)->where('city_id', $city->id)->all();
            $row = collect($city_arr)->first();
        @endphp
        <tr>
            <td>{{$row->city_name}}</td>
            <td>{{$row->province_name}}</td>
            <td>{{$row->tier_name}}</td>
            <td>{{$row->population}}</td>
            @foreach($months as $month)
                @php
                    $month_wise =collect($city_arr)->where('date', $month)->first();
                @endphp
                <td>{{$month_wise->net_sale}}</td>
                <td>{{$month_wise->total_pieces}}</td>
                <td>{{number_format($month_wise->per_capita,2)}}</td>
            @endforeach
        </tr>
    @endforeach
    </tbody>
</table>