@extends('layouts.home_layout')
@php
    $pageTitle = "Breed Wise Animal 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">
                                            @if (sizeof($list) > 0)
                                                @include('common.print_css')
                                                <table id="excelExportArea" class="table table-bordered table-striped dataTable">
                                                    <tbody>
                                                        <tr>
                                                            @php
                                                                $fullColspan = 11;
                                                                
                                                                $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');

                                                                $firstColspan       = 2;
                                                                $lastColspan        = ($fullColspan - $firstColspan);
                                                            @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 Date</strong></td>
                                                            <td class="text-left" colspan="{{$lastColspan}}">{{date('d-M-Y')}}</td>
                                                        </tr>

                                                            
                                                        <tr>
                                                            <td class="text-center"><strong>#</strong></td>
                                                            <td class="text-center"><strong>Cooperative Name</strong></td>
                                                            <td class="text-center"><strong>#</strong></td>
                                                            <td class="text-center"><strong>{!!str_repeat("&nbsp;", 15)!!}Breed&nbsp;Name{!!str_repeat("&nbsp;", 15)!!}</strong></td>
                                                            <td class="text-center"><strong>Number of Animals</strong></td>
                                                            <td class="text-center"><strong>Sold</strong></td>
                                                            <td class="text-center"><strong>Current Stock</strong></td>
                                                            <td class="text-center"><strong>Avg. Weight at Sold</strong></td>
                                                            <td class="text-center"><strong>Avg. Duration of Fattening (month)</strong></td>
                                                        </tr>
                                                        @php
                                                            $i = 1;
                                                            $breedTotalAnimal = json_decode($breedTotalAnimal);
                                                            $cattleWeight = json_decode($cattleWeight);
                                                        @endphp
                                                        @foreach ($list as $key => $v)
                                                            @php
                                                                $bta_arr = array_values(array_filter($breedTotalAnimal, function($nta) use($v) {
                                                                    return $nta->cooperative_id == $v->id;
                                                                }));
                                                            @endphp 
                                                            @if ($bta_arr)
                                                                @php
                                                                    $j = 1;
                                                                @endphp
                                                                @foreach ($bta_arr as $item)
                                                                    @php
                                                                        $currentStock = ($item->totalCattle - $item->totalSoldCattle);

                                                                        $totalCattleWeight = 0;
                                                                        // $number_of_cattle = 1;
                                                                        $avg_sold_weight = 0;
                                                                        $totalFatteningDays = 0;
                                                                        $fatteningMonth = 0;
                                                                        $weight_arr = array_values(array_filter($cattleWeight, function($weight) use ($v, $item) {
                                                                            return $weight->cooperative_id == $v->id && $weight->livestock_breed_id == $item->livestock_breed_id;
                                                                        }));
                                                                        if($weight_arr) {
                                                                            // $number_of_cattle = sizeof($weight_arr);
                                                                            foreach ($weight_arr as $t) {
                                                                                $totalCattleWeight += $t->weight ? $t->weight : $t->scale_weight;
                                                                                $totalFatteningDays += $t->fattening_days ?: 0;
                                                                            }
                                                                            // $avg_sold_weight = ($totalCattleWeight / $number_of_cattle);
                                                                        } else {
                                                                            // $avg_sold_weight = $item->cattle_weight;
                                                                            // $totalCattleWeight += $item->cattle_weight;
                                                                        }
                                                                        if($item->totalSoldCattle != 0) {
                                                                            // $avg_sold_weight = ($totalCattleWeight / 1);
                                                                            $avg_sold_weight = ($totalCattleWeight / $item->totalSoldCattle);
                                                                            $avg_fattening_days = ($totalFatteningDays / $item->totalSoldCattle);

                                                                            $start_date = new DateTime(date("Y/m/d"));
                                                                            $end_date = new DateTime(date("Y/m/d",strtotime("+$avg_fattening_days days")));
                                                                            $dd = date_diff($start_date, $end_date);
                                                                            $fatteningMonth = "$dd->m months $dd->d days";
                                                                        }
                                                                        
                                                                        
                                                                    @endphp
                                                                    <tr>
                                                                        @if ($j==1)
                                                                            <td class="text-center" rowspan="{{sizeof($bta_arr)}}">{{($key+1)}}</td>
                                                                            <td class="text-left" rowspan="{{sizeof($bta_arr)}}" title="{{$v->id}}">{{$v->cp_name_en}}</td>
                                                                        @endif
                                                                        <td class="text-left" >{{$j++}}</td>
                                                                        <td class="text-left" title="{{$item->livestock_breed_id}}">{{$item->breed_name_en}}</td>
                                                                        <td class="text-right">{{$item->totalCattle}}</td>
                                                                        <td class="text-right">{{$item->totalSoldCattle}}</td>
                                                                        <td class="text-right">{{$currentStock}}</td>
                                                                        <td class="text-right">{{$avg_sold_weight}}</td>
                                                                        <td class="text-center">{{$fatteningMonth?:''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif
                                                            
                                                        @endforeach
                                                        
                                                    </tbody>
                                                </table>
                                            @endif
                                        </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