@extends('layouts.home_layout')
@php
    $pageTitle = "Sales And Stock (Cooperative Wise)";
@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 = 10;
                                                                
                                                                $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       = 5;
                                                                $lastColspan        = ($fullColspan - $firstColspan);
                                                                $cpNameColspan      = 6;
                                                                $totalColspan       = 4;
                                                            @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>
                                                        <tr>
                                                            <td class="text-center"><strong>#</strong></td>
                                                            <td class="text-center"><strong>Name&nbsp;of&nbsp;Cooperative</strong></td>
                                                            <td class="text-center"><strong>Cooperative&nbsp;Code</strong></td>
                                                            <td class="text-center"><strong>No. of Cattle Ready to Sale</strong></td>
                                                            <td class="text-center"><strong>No. of Local Market Sold</strong></td>
                                                            <td class="text-center"><strong>No. of Online Market Sold</strong></td>
                                                            <td class="text-center"><strong>No. of Cattle Sold</strong></td>
                                                            <td class="text-center"><strong>Avg. Weight of Sold Cattle <small>(Kg)</small></strong></td>
                                                            <td class="text-center"><strong>No. of Remaining Cattle Ready to Sale</strong></td>
                                                            <td class="text-center"><strong>Total Sold Amount <small>(BDT)</small></strong></td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-center"></td>
                                                            <td class="text-center"></td>
                                                            <td class="text-center"></td>
                                                            <td class="text-center"><small>A</small></td>
                                                            
                                                            <td class="text-center"><small>B</small></td>
                                                            <td class="text-center"><small>C</small></td>
                                                            <td class="text-center"><small>D = (B+C)</small></td>
                                                            <td class="text-center"><small>E</small></td>
                                                            <td class="text-center"><small>F = (A-D)</small></td>
                                                            <td class="text-center"><small>G</small></td>
                                                        </tr>
                                                    <!-- Report Head End -->

                                                    @if ($list)
                                                        @php
                                                            $i = 1;
                                                            $readyToSale = json_decode($readyToSale);
                                                            $soldCattle = json_decode($soldCattle);
                                                            $onlineSoldCattle = json_decode($onlineSoldCattle);
                                                            // $soldCattleWeight = json_decode($soldCattleWeight);

                                                            $t_readyToSale = 0;
                                                            $t_soldCattle = 0;
                                                            $t_onlineSoldCattle = 0;
                                                            $t_remainingCattleForSale = 0;
                                                            $t_soldCattleAmount = 0;
                                                            $t_cattleAvgWeight = 0;
                                                        @endphp

                                                        @foreach ($list as $key => $v)
                                                            @php
                                                                $rowPrintVal = 0;

                                                                $r_readyToSale = 0;
                                                                $trs_arr = array_values(array_filter($readyToSale, function($trs) use ($v) {
                                                                    return $trs->cooperative_id == $v->id;
                                                                }));
                                                                if($trs_arr) {
                                                                    $r_readyToSale = $trs_arr[0]->totalCattleReadyToSale;
                                                                }
                                                                $rowPrintVal += $r_readyToSale;

                                                                $r_soldCattle = 0;
                                                                $r_soldCattleAmount = 0;
                                                                $sc_arr = array_values(array_filter($soldCattle, function($sc) use ($v) {
                                                                    return $sc->cooperative_id == $v->id;
                                                                }));
                                                                if($sc_arr) {
                                                                    $r_soldCattle = $sc_arr[0]->totalSoldCattle;
                                                                    $r_soldCattleAmount = $sc_arr[0]->totalSoldAmount;
                                                                }

                                                            //    online sold 
                                                                $r_onlineSoldCattle = 0;
                                                                $osc_arr = array_values(array_filter($onlineSoldCattle, function($sc) use ($v) {
                                                                    return $sc->cooperative_id == $v->id;
                                                                }));
                                                                if($osc_arr) {
                                                                    $r_onlineSoldCattle = $osc_arr[0]->totalSoldCattle;
                                                                }

                                                                $r_remainingCattleForSale = $r_readyToSale;
                                                                $r_readyToSale += $r_soldCattle;

                                                                $r_cattleAvgWeight = $soldCattleWeight->where('cooperative_id', $v->id)->avg('cattleWight');

                                                                $t_readyToSale              += $r_readyToSale;
                                                                $t_soldCattle               += $r_soldCattle;
                                                                $t_onlineSoldCattle         += $r_onlineSoldCattle;
                                                                $t_remainingCattleForSale   += $r_remainingCattleForSale;
                                                                $t_soldCattleAmount         += $r_soldCattleAmount;
                                                                $t_cattleAvgWeight          += $r_cattleAvgWeight;

                                                                $rowPrintVal += $r_soldCattle;

                                                                // $scw_arr = array_values(array_filter($soldCattleWeight, function($scw) use ($v) {
                                                                //     return $scw->cooperative_id == $v->id;
                                                                // }));
                                                            @endphp
                                                            @if ($rowPrintVal <> 0)
                                                           

                                                                <tr>
                                                                    <td class="text-center">{{$i++}}</td>
                                                                    <td class="text-left">{{$v->cp_name_en}}</td>
                                                                    <td class="text-center">{{$v->cp_code}}</td>
                                                                    <td class="text-right">{{number_format($r_readyToSale, 0)}}</td>
                                                                    
                                                                    <td class="text-right">{{number_format($r_soldCattle - $r_onlineSoldCattle, 0)}}</td>
                                                                    <td class="text-right">{{number_format($r_onlineSoldCattle, 0)}}</td>
                                                                    <td class="text-right">{{number_format($r_soldCattle, 0)}}</td>
                                                                    {{-- <td class="text-left">
                                                                        @php
                                                                            print_r($trs_arr);
                                                                        @endphp
                                                                    </td> --}}
                                                                    <td class="text-right">
                                                                        {{ number_format($r_cattleAvgWeight, 2) }}
                                                                    </td>
                                                                    <td class="text-right">{{number_format($r_remainingCattleForSale, 0)}}</td>
                                                                    <td class="text-right">{{number_format($r_soldCattleAmount, 2)}}</td>
                                                                </tr>
                                                            @endif
                                                        @endforeach
                                                    @endif
                                                         
                                                    <tr>
                                                        <td class="text-right" colspan="{{$totalColspan}}"><strong>Total</strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_soldCattle - $t_onlineSoldCattle, 0)}} </strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_onlineSoldCattle, 0)}} </strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_soldCattle, 0)}} </strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_cattleAvgWeight, 2)}}</strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_remainingCattleForSale, 0)}}</strong></td>
                                                        <td class="text-right"><strong>{{number_format($t_soldCattleAmount, 2)}}</strong></td>
                                                    </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