@extends('layouts.home_layout')
@php
    $pageTitle = "Cattle Wise Cost History";
@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 = 4;
                                                                
                                                                $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       = 2;
                                                                $lastColspan        = ($fullColspan - $firstColspan);
                                                                $animalIdColspan    = 2;
                                                                $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>

                                                            
                                                    <!-- Report Head End -->

                                                    @if ($list)
                                                        @php
                                                            $dewormingCost = json_decode($dewormingCost);
                                                            $vaccinationCost = json_decode($vaccinationCost);
                                                            $treatmentCost = json_decode($treatmentCost);
                                                            $feedingCost = json_decode($feedingCost);
                                                            $othersCost = json_decode($othersCost);
                                                        @endphp

                                                        @foreach ($list as $key => $v)
                                                            <tr>
                                                                <td class="text-center" colspan="{{$animalIdColspan}}"><strong>Animal&nbsp;ID</strong></td>
                                                                <td class="text-center"><strong>Cattle&nbsp;Name</strong></td>
                                                                <td class="text-center"><strong>Purchase Cost</strong></td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-center" colspan="{{$animalIdColspan}}">
                                                                    <a href="{{ url('_cati_i_d', [$v->cattle_id]) }}" target="_blank">
                                                                        {{$v->id_prefix ? $v->id_prefix.' - ' : ''}}{{$v->cattle_id_no}}
                                                                    </a>
                                                                </td>
                                                                <td class="text-left">{{$v->cattle_name_en}}</td>
                                                                <td class="text-right">{{number_format($v->purchase_cost, 2)}}</td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-center"><strong>#</strong></td>
                                                                <td class="text-center"><strong>Date</strong></td>
                                                                <td class="text-center"><strong>Cost Description</strong></td>
                                                                <td class="text-center"><strong>Cost</strong></td>
                                                            </tr>
                                                            @php
                                                                $i = 1;
                                                                $cattleTotalCost = $v->purchase_cost;
                                                                $dw_arr = array_values(array_filter($dewormingCost, function($dw) use($v) {
                                                                    return $dw->cattle_id == $v->cattle_id;
                                                                }));
                                                            @endphp
                                                            @if ($dw_arr)
                                                                @foreach ($dw_arr as $d)
                                                                    @php
                                                                        $cattleTotalCost += $d->deworming_cost;
                                                                    @endphp
                                                                    <tr>
                                                                        <td class="text-center">{{$i++}}</td>
                                                                        <td class="text-center">{{date('d-M-Y', strtotime($d->deworming_date))}}</td>
                                                                        <td class="text-left"><strong>Deworming : </strong>{{$d->medicine_name_en}}</td>
                                                                        <td class="text-right">{{($d->deworming_cost != 0) ? number_format($d->deworming_cost, 2) : ''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif

                                                            @php
                                                                $vacc_arr = array_values(array_filter($vaccinationCost, function($vacc) use($v) {
                                                                    return $vacc->cattle_id == $v->cattle_id;
                                                                }));
                                                            @endphp
                                                            @if ($vacc_arr)
                                                                @foreach ($vacc_arr as $d)
                                                                    @php
                                                                        $cattleTotalCost += $d->vaccine_cost;
                                                                    @endphp
                                                                    <tr>
                                                                        <td class="text-center">{{$i++}}</td>
                                                                        <td class="text-center">{{date('d-M-Y', strtotime($d->vaccine_date))}}</td>
                                                                        <td class="text-left"><strong>Vaccination : </strong>{{$d->medicine_name_en}}</td>
                                                                        <td class="text-right">{{($d->vaccine_cost != 0) ? number_format($d->vaccine_cost, 2) : ''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif

                                                            @php
                                                                $treat_arr = array_values(array_filter($treatmentCost, function($treat) use($v) {
                                                                    return $treat->cattle_id == $v->cattle_id;
                                                                }));
                                                            @endphp
                                                            @if ($treat_arr)
                                                                @foreach ($treat_arr as $d)
                                                                    @php
                                                                        $cattleTotalCost += $d->treatment_cost;
                                                                    @endphp
                                                                    <tr>
                                                                        <td class="text-center">{{$i++}}</td>
                                                                        <td class="text-center">{{date('d-M-Y', strtotime($d->treatment_date))}}</td>
                                                                        <td class="text-left"><strong>Treatment : </strong>{{$d->medicine_id}}</td>
                                                                        <td class="text-right">{{($d->treatment_cost != 0) ? number_format($d->treatment_cost, 2) : ''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif

                                                            @php
                                                                $feed_arr = array_values(array_filter($feedingCost, function($feed) use($v) {
                                                                    return $feed->cattle_id == $v->cattle_id;
                                                                }));
                                                            @endphp
                                                            @if ($feed_arr)
                                                                @foreach ($feed_arr as $d)
                                                                    @php
                                                                        $cattleTotalCost += $d->feeding_cost;
                                                                    @endphp
                                                                    <tr>
                                                                        <td class="text-center">{{$i++}}</td>
                                                                        <td class="text-center">{{date('d-M-Y', strtotime($d->entry_date))}}</td>
                                                                        <td class="text-left"><strong>Feed : </strong>{{$d->feed_name_en}}</td>
                                                                        <td class="text-right">{{($d->feeding_cost != 0) ? number_format($d->feeding_cost, 2) : ''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif

                                                            @php
                                                                $other_arr = array_values(array_filter($othersCost, function($other) use($v) {
                                                                    return $other->cattle_id == $v->cattle_id;
                                                                }));
                                                            @endphp
                                                            @if ($other_arr)
                                                                @foreach ($other_arr as $d)
                                                                    @php
                                                                        $cattleTotalCost += $d->other_cost;
                                                                    @endphp
                                                                    <tr>
                                                                        <td class="text-center">{{$i++}}</td>
                                                                        <td class="text-center">{{date('d-M-Y', strtotime($d->entry_date))}}</td>
                                                                        <td class="text-left">{{$d->cost_description}}</td>
                                                                        <td class="text-right">{{($d->other_cost != 0) ? number_format($d->other_cost, 2) : ''}}</td>
                                                                    </tr>
                                                                @endforeach
                                                            @endif
                                                            <tr>
                                                                <td class="text-right" colspan="{{$totalColspan}}"><strong>Total Cost</strong></td>
                                                                <td class="text-right"><strong>{{number_format($cattleTotalCost, 2)}}</strong></td>
                                                            </tr>
                                                        @endforeach
                                                    @endif
                                                           
                                                </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