@extends('layouts.home_layout')
@php
    $pageTitle = "Monthly Farmer & Agricultural Production Report";
@endphp
@section('title', $pageTitle)

@section('style')
@endsection

@section('content')
    @php
        // dd($list);
    @endphp
    <div class="app-content content">
        <div class="content-wrapper">
            <div class="content-header row">
                <div class="content-header-left col-md-6 col-12 mb-2 breadcrumb-new">
                    <h3 class="content-header-title mb-0 d-inline-block">{{$pageTitle}}</h3>
                    {{-- <div class="row breadcrumbs-top d-inline-block">
                        <div class="breadcrumb-wrapper col-12">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item"><a href="index.html">Home</a></li>
                                <li class="breadcrumb-item active">Animation</li>
                            </ol>
                        </div>
                    </div> --}}
                </div>
				<div class="content-header-right col-md-6 col-12">
					<div class="dropdown float-md-right">
                        <button type="button" class="btn btn-danger round btn-glow px-2 mb-1 printBtn" onClick="print_content();">Print</button>
                        <button type="button" class="btn btn-danger round btn-glow px-2 mb-1 excel_export_btn" onclick="tableToExcel('excelExportArea', 'Sheet1')">Export to Excel</button>
					</div>
				</div>
            </div>
            <div class="content-body">
				
                <!-- Button animation start -->
                <section id="btnAnimation" class="btnAnimation">
                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">{{$pageTitle}}</h4>
                                    <a class="heading-elements-toggle"><i class="la la-ellipsis-h font-medium-3"></i></a>
                                    <div class="heading-elements">
                                        <ul class="list-inline mb-0">
                                            <li><a data-action="collapse"><i class="ft-minus"></i></a></li>
                                            <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
                                            <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
                                            <li><a data-action="close"><i class="ft-x"></i></a></li>
                                        </ul>
                                    </div>
                                </div>
                                <div class="card-content collapse show">
                                    <div class="card-body">
                                        <div id="printArea" class="table-responsive">
                                            @include('common.print_css')
                                            <table id="excelExportArea" class="table table-bordered table-striped dataTable">
                                                <tbody>
                                                    <!-- Report Head Start -->
                                                        <tr>
                                                            @php
                                                                $fullColspan = 3;
                                                                
                                                                $partner_id         = request()->get('partner_id');
                                                                $cooperative_id     = request()->get('cooperative_id');
                                                                $group_id           = request()->get('group_id');
                                                                $farmer_id          = request()->get('farmer_id');
                                                                $animal_type_id     = request()->get('animal_type_id');
                                                                $cattle_gender_id   = request()->get('cattle_gender_id');
                                                                $livestock_breed_id = request()->get('cattle_gender_id');

                                                                $division_id        = request()->get('division_id');
                                                                $district_id        = request()->get('district_id');
                                                                $upazilla_id        = request()->get('upazilla_id');
                                                                $union_id           = request()->get('union_id');
                                                                $village_id         = request()->get('village_id');
                                                                $f_date             = request()->get('f_date');
                                                                $t_date             = request()->get('t_date');

                                                                $firstColspan       = 3;
                                                                if($animal_type_id != '') {
                                                                    $fullColspan += 10;
                                                                } else {
                                                                    $fullColspan += 20;
                                                                }
                                                                $lastColspan        = ($fullColspan - $firstColspan);
                                                                $singleGroupColspan = 10;
                                                                $groupColspan       = 3;
                                                                $cpNameColspan      = 4;
                                                                $totalColspan       = 3;
                                                            @endphp
                                                            <td class="text-center" colspan="{{$fullColspan}}"><h4>{{$pageTitle}}</h4></td>
                                                        </tr>
                                                        @if ($reportInfo['partners'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Partner Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['partners']->partner_name_en}} {{$reportInfo['partners']->partner_code ? "[{$reportInfo['partners']->partner_code}]" : ''}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['cooperative'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Cooperative Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['cooperative']->cp_name_en}} {{$reportInfo['cooperative']->cp_code ? "[{$reportInfo['cooperative']->cp_code}]" : ''}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['group'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Farmer Group Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['group']->group_name_en}} {{$reportInfo['group']->group_code ? "[{$reportInfo['group']->group_code}]" : ''}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['farmer'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Farmer Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['farmer']->farmer_name_en}} {{$reportInfo['farmer']->farmer_code ? "[{$reportInfo['farmer']->farmer_code}]" : ''}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['animal_type'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Animal Type Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['animal_type']->type_name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['livestock_breed'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Livestock Breed Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['livestock_breed']->breed_name_en}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['cattle_gender'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Cattle Gender</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['cattle_gender']->gender_name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['division'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Division Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['division']->name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['district'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>District Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['district']->name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['upazilla'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Upazila Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['upazilla']->name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['union'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Union Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['union']->name}}</td>
                                                            </tr>
                                                        @endif
                                                        @if ($reportInfo['village'])
                                                            <tr>
                                                                <td class="text-left" colspan="{{$firstColspan}}"><strong>Village Name</strong></td>
                                                                <td class="text-left" colspan="{{$lastColspan}}">{{$reportInfo['village']->en_name}}</td>
                                                            </tr>
                                                        @endif
                                                        <tr>
                                                            <td class="text-left" colspan="{{$firstColspan}}"><strong>Reporting Period</strong></td>
                                                            <td class="text-left" colspan="{{$lastColspan}}">{{$reportingPeriod}}</td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-left" colspan="{{$firstColspan}}"><strong>Reporting Date</strong></td>
                                                            <td class="text-left" colspan="{{$lastColspan}}">{{date('d-M-Y')}}</td>
                                                        </tr>
                                                        @php
                                                            $fullRowspan = 3;
                                                            $secondRowspan = 2;

                                                            $cowColumnShow = true;
                                                            $goatColumnShow = true;

                                                            if ($animal_type_id != '') {
                                                                if ($animal_type_id == 2) {
                                                                    $goatColumnShow = false;
                                                                }
                                                                if ($animal_type_id == 3) {
                                                                    $cowColumnShow = false;
                                                                }
                                                            }
                                                        @endphp
                                                        <tr>
                                                            <td class="text-center" rowspan="{{$fullRowspan}}"><strong>#</strong></td>
                                                            <td class="text-center" rowspan="{{$fullRowspan}}"><strong>Name&nbsp;of&nbsp;Cooperative</strong></td>
                                                            <td class="text-center" rowspan="{{$fullRowspan}}"><strong>Cooperative Code</strong></td>
                                                            @if($cowColumnShow)
                                                                <td class="text-center" colspan="{{$singleGroupColspan}}"><strong>Fattening Beef Production Data</strong></td>
                                                            @endif
                                                            @if($goatColumnShow)
                                                                <td class="text-center" colspan="{{$singleGroupColspan}}"><strong>Fattening Goat Production Data</strong></td>
                                                            @endif
                                                        </tr>
                                                        <tr>
                                                            @if($cowColumnShow)
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Farmer</strong></td>
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Fattening Beef</strong></td>
                                                                <td class="text-center" rowspan="{{$secondRowspan}}"><strong>Total Market Demand for Fattened Beef</strong></td>
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Beef for Sale</strong></td>
                                                            @endif
                                                            @if($goatColumnShow)
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Farmer</strong></td>
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Goats</strong></td>
                                                                <td class="text-center" rowspan="{{$secondRowspan}}"><strong>Total Market Demand of Goats</strong></td>
                                                                <td class="text-center" colspan="{{$groupColspan}}"><strong>Number of Goats for Sale</strong></td>
                                                            @endif
                                                        </tr>
                                                        <tr>
                                                            @if($cowColumnShow)
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                                
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                                
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                            @endif

                                                            @if($goatColumnShow)
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                                
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                                
                                                                <td class="text-center"><strong>Members</strong></td>
                                                                <td class="text-center"><strong>Others</strong></td>
                                                                <td class="text-center"><strong>Total</strong></td>
                                                            @endif
                                                        </tr>
                                                    <!-- Report Head End -->


                                                    @php
                                                        $i = 1;
                                                        $g_totalFarmer = 0;
                                                            
                                                        $g_total_cow_farmer = 0;
                                                        $g_total_cow = 0;
                                                        $g_total_market_cow_need = 0;
                                                        $g_total_saleable_cow = 0;
                                                        $g_total_goat_farmer = 0;
                                                        $g_total_goat = 0;
                                                        $g_total_market_goat_need = 0;
                                                        $g_total_saleable_goat = 0;

                                                        $g_r_totalCowFarmer = 0;
                                                        $g_totalCow = 0;
                                                        $g_r_totalCow = 0;
                                                        $g_readyToSaleCow = 0;
                                                        $g_r_totalReadyToSaleCow = 0;

                                                        
                                                        $g_r_totalGoatFarmer = 0;
                                                        $g_totalGoat = 0;
                                                        $g_r_totalGoat = 0;
                                                        $g_readyToSaleGoat = 0;
                                                        $g_r_totalReadyToSaleGoat = 0;
                                                    @endphp
                                                    @if ($list)
                                                        @foreach ($list as $key => $v)
                                                            @php
                                                                // $soldCattleWeight->where('cooperative_id', $v->id)->avg('cattleWight');
                                                                // $far_arr = $farmerList->where('cooperative_id', $v->id)->first();
                                                                // $far_arr = collect($farmerList)->where('cooperative_id', $v->id)->all();
                                                                $totalFarmer = 0;
                                                                $far_arr = $farmerList->filter(function ($fl, $j) use ($v){
                                                                    return $fl->cooperative_id == $v->id;
                                                                });
                                                                if($far_arr->count() > 0) {
                                                                    $totalFarmer = $far_arr->first()->totalFarmer;
                                                                }
                                                            
                                                                $total_cow_farmer = 0;
                                                                $total_cow = 0;
                                                                $total_market_cow_need = 0;
                                                                $total_saleable_cow = 0;
                                                                $total_goat_farmer = 0;
                                                                $total_goat = 0;
                                                                $total_market_goat_need = 0;
                                                                $total_saleable_goat = 0;
                                                                $mdl_arr = $manualDataList->filter(function ($mdl, $j) use ($v){
                                                                    return $mdl->cooperative_id == $v->id;
                                                                });
                                                                if($mdl_arr->count() > 0) {
                                                                    $mdl_row = $mdl_arr->first();

                                                                    $total_cow_farmer = $mdl_row->total_cow_farmer;
                                                                    $total_cow = $mdl_row->total_cow;
                                                                    $total_market_cow_need = $mdl_row->total_market_cow_need;
                                                                    $total_saleable_cow = $mdl_row->total_saleable_cow;

                                                                    $total_goat_farmer = $mdl_row->total_goat_farmer;
                                                                    $total_goat = $mdl_row->total_goat;
                                                                    $total_market_goat_need = $mdl_row->total_market_goat_need;
                                                                    $total_saleable_goat = $mdl_row->total_saleable_goat;
                                                                }

                                                                $g_totalFarmer += $totalFarmer;

                                                                $g_total_cow_farmer += $total_cow_farmer;
                                                                $g_total_cow += $total_cow;
                                                                $g_total_market_cow_need += $total_market_cow_need;
                                                                $g_total_saleable_cow += $total_saleable_cow;

                                                                $g_total_goat_farmer += $total_goat_farmer;
                                                                $g_total_goat += $total_goat;
                                                                $g_total_market_goat_need += $total_market_goat_need;
                                                                $g_total_saleable_goat += $total_saleable_goat;
                                                            @endphp
                                                            <tr>
                                                                <td class="text-center">{{$i++}}</td>
                                                                <td class="text-left" title="{{$v->id}}">{{$v->cp_name_en}}</td>
                                                                <td class="text-center">{{$v->cp_code}}</td>

                                                                @if($cowColumnShow)
                                                                    @php
                                                                        $r_totalCowFarmer = ($totalFarmer + $total_cow_farmer);
                                                                        $g_r_totalCowFarmer += $r_totalCowFarmer;
                                                                    @endphp
                                                                    <td class="text-right">{{$totalFarmer ? $totalFarmer : ''}}</td>
                                                                    <td class="text-right">{{$total_cow_farmer ? $total_cow_farmer : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalCowFarmer ? $r_totalCowFarmer : ''}}</strong></td>
                                                                    @php
                                                                        $totalCow = 0;
                                                                        $ftcl_arr = $fatteningTotalCowList->filter(function ($ftcl, $j) use ($v){
                                                                            return $ftcl->cooperative_id == $v->id;
                                                                        });
                                                                        if($ftcl_arr->count() > 0) {
                                                                            $totalCow = $ftcl_arr->first()->totalCow;
                                                                        }
                                                                        $r_totalCow = ($totalCow + $total_cow);
                                                                        $g_totalCow += $totalCow;
                                                                        $g_r_totalCow += $r_totalCow;
                                                                    @endphp
                                                                    <td class="text-right">{{$totalCow ? $totalCow : ''}}</td>
                                                                    <td class="text-right">{{$total_cow ? $total_cow : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalCow ? $r_totalCow : ''}}</strong></td>
                                                                    <td class="text-right">{{$total_market_cow_need ? $total_market_cow_need : ''}}</td>
                                                                    @php
                                                                        $readyToSaleCow = 0;
                                                                        $rtscl_arr = $readyToSaleCowList->filter(function ($rtscl, $j) use ($v){
                                                                            return $rtscl->cooperative_id == $v->id;
                                                                        });
                                                                        if($rtscl_arr->count() > 0) {
                                                                            $readyToSaleCow = $rtscl_arr->first()->readyToSaleCow;
                                                                        }
                                                                        $r_totalReadyToSaleCow = ($readyToSaleCow + $total_saleable_cow);
                                                                        $g_readyToSaleCow += $readyToSaleCow;
                                                                        $g_r_totalReadyToSaleCow += $r_totalReadyToSaleCow;
                                                                    @endphp
                                                                    <td class="text-right">{{$readyToSaleCow ? $readyToSaleCow : ''}}</td>
                                                                    <td class="text-right">{{$total_saleable_cow ? $total_saleable_cow : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalReadyToSaleCow ? $r_totalReadyToSaleCow : ''}}</strong></td>
                                                                @endif

                                                                @if($goatColumnShow)
                                                                    @php
                                                                        $r_totalGoatFarmer = ($totalFarmer + $total_goat_farmer);
                                                                        $g_r_totalGoatFarmer += $r_totalGoatFarmer;
                                                                    @endphp
                                                                    <td class="text-right">{{$totalFarmer ? $totalFarmer : ''}}</td>
                                                                    <td class="text-right">{{$total_goat_farmer ? $total_goat_farmer : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalGoatFarmer ? $r_totalGoatFarmer : ''}}</strong></td>
                                                                    @php
                                                                        $totalGoat = 0;
                                                                        $ftgl_arr = $fatteningTotalGoatList->filter(function ($ftgl, $j) use ($v){
                                                                            return $ftgl->cooperative_id == $v->id;
                                                                        });
                                                                        if($ftgl_arr->count() > 0) {
                                                                            $totalGoat = $ftgl_arr->first()->totalGoat;
                                                                        }
                                                                        $r_totalGoat = ($totalGoat + $total_goat);
                                                                        $g_totalGoat += $totalGoat;
                                                                        $g_r_totalGoat += $r_totalGoat;
                                                                    @endphp
                                                                    <td class="text-right">{{$totalGoat ? $totalGoat : ''}}</td>
                                                                    <td class="text-right">{{$total_goat ? $total_goat : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalGoat ? $r_totalGoat : ''}}</strong></td>
                                                                    <td class="text-right">{{$total_market_goat_need ? $total_market_goat_need : ''}}</td>
                                                                    @php
                                                                        $readyToSaleGoat = 0;
                                                                        $rtsgl_arr = $readyToSaleGoatList->filter(function ($rtsgl, $j) use ($v){
                                                                            return $rtsgl->cooperative_id == $v->id;
                                                                        });
                                                                        if($rtsgl_arr->count() > 0) {
                                                                            $readyToSaleGoat = $rtsgl_arr->first()->readyToSaleGoat;
                                                                        }
                                                                        $r_totalReadyToSaleGoat = ($readyToSaleGoat + $total_saleable_goat);
                                                                        $g_readyToSaleGoat += $readyToSaleGoat;
                                                                        $g_r_totalReadyToSaleGoat += $r_totalReadyToSaleGoat;
                                                                    @endphp
                                                                    <td class="text-right">{{$readyToSaleGoat ? $readyToSaleGoat : ''}}</td>
                                                                    <td class="text-right">{{$total_saleable_goat ? $total_saleable_goat : ''}}</td>
                                                                    <td class="text-right"><strong>{{$r_totalReadyToSaleGoat ? $r_totalReadyToSaleGoat : ''}}</strong></td>
                                                                @endif
                                                                {{-- <td class="text-left" colspan="10">@php  echo "<pre>"; print_r($far_arr->all()); @endphp</td> --}}
                                                            </tr>
                                                        @endforeach
                                                    @endif

                                                            
                                                    <tr>
                                                        <td class="text-right" colspan="{{$totalColspan}}"><strong>Total</strong></td>
                                                        @if($cowColumnShow)
                                                            <td class="text-right"><strong>{{number_format($g_totalFarmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_cow_farmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalCowFarmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_totalCow, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_cow, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalCow, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_market_cow_need, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_readyToSaleCow, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_saleable_cow, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalReadyToSaleCow, 0)}}</strong></td>
                                                        @endif 

                                                        @if($goatColumnShow)
                                                            <td class="text-right"><strong>{{number_format($g_totalFarmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_goat_farmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalGoatFarmer, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_totalGoat, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_goat, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalGoat, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_market_goat_need, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_readyToSaleGoat, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_total_saleable_goat, 0)}}</strong></td>
                                                            <td class="text-right"><strong>{{number_format($g_r_totalReadyToSaleGoat, 0)}}</strong></td>
                                                        @endif
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </section>
                <!-- Card animation end -->
            </div>
        </div>
        {{-- Modal Start id="modal" --}}
             
		{{-- Modal End  --}}
    </div>
@endsection


@section('script')
    <script src="{{asset('app-assets/js/custom_print.js')}}"></script>
    <script>
    </script>
@endsection