@extends('layouts.master')
@section('styles')
    <style>
        .topstats {
            margin-top: 10px;
            font-size: 13px;
            margin-bottom: -5px;
        }

        .topstats .gary-box {
            line-height: 1;
            background-color: #f9f9f9;
            border-bottom: solid 1px #d1d1d1;
            padding: 10px;
        }

        .topstats .gary-box span {
            font-family: 'Rationale', sans-serif;
            color: #0038ba;
            font-size: 20px;
            float: right;
            margin-top: -4px;
        }
        table.dataTable tbody th{
            white-space: nowrap;
        }

        td.dt-nowrap { white-space: nowrap }



        .dis-slab-card{font-size: 13px; margin:0;}
        .dis-input{font-size: 13px; border: solid 1px #E8E8E8; width: 240px; height: 25px; padding-left:8px}
        .dis-input:focus{border: solid 1px #0038BA}
        .topsec{background-color: #F7F7F7; font-size: 14px; line-height: 25px; padding: 5px 0px; margin:0; border-bottom:solid 1px #0038BA; cursor: pointer}
        .topsec i{float:right; font-size:18px; line-height:25px; color:#a4a4a4}
        .bottomsec{background-color:#ededed;padding: 10px 15px;}
        .dis-slab-card .btn-primary{font-size: 13px; padding: 5px 12px; line-height:1; box-shadow: none;}
        .dis-slab-card .red-bg{border-color: #F12300; box-shadow: none;}
        .dis-slab-card .add-slab-btn{font-size: 14px; padding:5px 12px; height: 28px; letter-spacing: 1px; margin-left:10px;}
        .criteria-sh{padding-top: 10px; padding-bottom: 10px; border:solid 1px #F1F1F1; background-color: #F9F9F9 }
        .criteria-sh strong{padding-right: 10px;}
    </style>
@endsection
@section('content')
    <div class="row mt-2 mb-3">
        <div class="col-lg-6 col-md-6 col-sm-6">
            <h2 class="_head01">Report <span> Management</span></h2>
        </div>

        <div class="col-lg-6 col-md-6 col-sm-6">
            <ol class="breadcrumb">
                <li><a href="#"><span>Report</span></a></li>
                <li><span>List</span></li>
            </ol>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="card">

                <div class="header">
                    <a href="/generate-distributor-stock-report-excel?{{$queryString}}" class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                    <h2>Distributor Stock <span> Report</span>

                    </h2>
                </div>
                <div class="body body_table">
                    <div class="col-md-12 p-0">
                        <div class="table-wrap " style="overflow-y: auto">
                            <table class="table table-hover no-wrap display pb-30" style="width:100%;" id="stockReportTable" >
                                <thead>
                                <tr>
                                    <th style="white-space: nowrap !important;">Code/SKU </th>
                                    <th style="white-space: nowrap !important;">Product </th>
                                    <th style="white-space: nowrap !important;">Packing Unit</th>
                                    <th style="white-space: nowrap !important;">Opening Stock</th>
                                    <th style="white-space: nowrap !important;">Company Purchase</th>
                                    <th style="white-space: nowrap !important;">Market Return</th>
                                    <th style="white-space: nowrap !important;">Adjustment In</th>
                                    <th style="white-space: nowrap !important;">Total Available Stock</th>
                                    <th style="white-space: nowrap !important;">Company Return</th>
                                    <th style="white-space: nowrap !important;">Sold</th>
                                    <th style="white-space: nowrap !important;">Damage</th>
                                    <th style="white-space: nowrap !important;">Adjustment Out</th>
                                    <th style="white-space: nowrap !important;">Stock In Hand</th>
                                    <th style="white-space: nowrap !important;">Cost Price</th>
                                    <th style="white-space: nowrap !important;">G.Sales Value</th>
                                </tr>
                                </thead>
                                <tbody>
                                @if (collect($data['brands'])->count()>0)
                                    @foreach (collect($data['brands']) as $brand)
                                        @php
                                            $t_open_blnc    =  0;
                                            $t_purchased    =  0;
                                            $t_return       =  0;
                                            $t_avl_blnc     =  0;
                                            $t_sold         =  0;
                                            $t_demaged      =  0;
                                            $t_adjustmentIn =  0;
                                            $t_adjustmentOut=  0;
                                            $t_value        =  0;
                                            $t_cost_value   =  0;
                                            $t_companyreturn= 0;
                                            $t_issued       =  0;
                                        @endphp
                                        @foreach (collect($brand->items) as $item)
                                            @php
                                                $purchaseds     =     array_values(array_filter(@$data['purchased'],  fn ($x) => $x->item_id == $item->item_id));
                                                $returns        =     array_values(array_filter(@$data['return'],     fn ($x) => $x->item_id == $item->item_id));
                                                $companyreturns =     array_values(array_filter(@$data['companyreturn'],     fn ($x) => $x->item_id == $item->item_id));
                                                $solds          =     array_values(array_filter(@$data['sold'],       fn ($x) => $x->item_id == $item->item_id));
                                                $demageds       =     array_values(array_filter(@$data['demaged'],    fn ($x) => $x->item_id == $item->item_id));
                                                $adjustments    =     array_values(array_filter(@$data['adjustment'],    fn ($x) => $x->item_id == $item->item_id));


                                                $purchased      =     (int)@$purchaseds[0]->qty;
                                                $return         =     abs((int)@$returns[0]->qty);
                                                $companyreturn  =     (int)@$companyreturns[0]->qty;
                                                $sold           =     (int)@$solds[0]->qty;
                                                $demaged        =     (int)@$demageds[0]->qty;
                                                $adjustmentIn   =     (int)@$adjustments[0]->qty_in;
                                                $adjustmentOut  =     (int)@$adjustments[0]->qty_out;
                                                $avl_balance    =     $purchased + (float)@$item->opening_balance + $return +$adjustmentIn;
                                                $value          =     ($avl_balance -($sold+$companyreturn+$adjustmentOut)) * $item->item_trade_price ;
                                                $cost_value     =     $value;
                                                $value          =     $value - ( $value * $item->discount / 100 );
                                                $issued         =     0;//$item->issued_stock;

                                                $t_open_blnc    +=    (float)@$item->opening_balance;
                                                $t_purchased    +=    $purchased;
                                                $t_return       +=    $return;
                                                $t_companyreturn+=    $companyreturn;
                                                $t_avl_blnc     +=    $avl_balance;
                                                $t_sold         +=    $sold;
                                                $t_demaged      +=    $demaged;
                                                $t_adjustmentIn +=    $adjustmentIn;
                                                $t_adjustmentOut+=    $adjustmentOut;
                                                $t_value        +=    $value;
                                                $t_cost_value   +=    $cost_value;
                                                $t_issued       +=    $issued
                                            @endphp
                                            <tr>
                                                <td style="text-align: center">{{$item->item_sku}}</td>
                                                <td style="text-align: center">{{$item->item_name}}</td>
                                                <td style="text-align: center">{{$item->unit_name}}</td>
                                                <td style="text-align: center">{{number_format($item->opening_balance)}}</td>
                                                <td style="text-align: center">{{number_format($purchased)}}</td>
                                                <td style="text-align: center">{{number_format($return)}}</td>
                                                <td style="text-align: center">{{number_format($adjustmentIn)}}</td>
                                                <td style="text-align: center">{{number_format($avl_balance)}}</td>
                                                <td style="text-align: center">{{number_format($companyreturn)}}</td>
                                                <td style="text-align: center">{{number_format($sold)}}</td>
                                                <td style="text-align: center">{{number_format($demaged)}}</td>
                                                <td style="text-align: center">{{number_format($adjustmentOut)}}</td>
                                                <td style="text-align: center">{{number_format($avl_balance-($sold+$companyreturn+$adjustmentOut))}}</td>
                                                <th style="text-align: center">{{number_format($value,2)}}</th>
                                                <th style="text-align: center">{{number_format($cost_value,2)}}</th>
                                            </tr>
                                        @endforeach
                                        <tr style="background-color: #F6F6F6">
                                            <th style="text-align: center" colspan="3">{{$brand->brand_name}} Total</th>
                                            <th style="text-align: center">{{number_format($t_open_blnc)}}</th>
                                            <th style="text-align: center">{{number_format($t_purchased)}}</th>
                                            <th style="text-align: center">{{number_format($t_return)}}</th>
                                            <th style="text-align: center">{{number_format($t_adjustmentIn)}}</th>
                                            <th style="text-align: center">{{number_format($t_avl_blnc)}}</th>
                                            <th style="text-align: center">{{number_format($t_companyreturn)}}</th>
                                            <th style="text-align: center">{{number_format($t_sold)}}</th>
                                            <th style="text-align: center">{{number_format($t_demaged)}}</th>
                                            <th style="text-align: center">{{number_format($t_adjustmentOut)}}</th>
                                            <th style="text-align: center">{{number_format($t_avl_blnc-($t_sold+$t_companyreturn+$t_adjustmentOut))}}</th>
                                            <th style="text-align: center">{{number_format($t_value,2)}}</th>
                                            <th style="text-align: center">{{number_format($t_cost_value,2)}}</th>
                                        </tr>
                                    @endforeach
                                @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        $(document).ready(function () {

            $('#stockReportTable').dataTable({
                scrollX: true,
            });
        });
    </script>
@endsection