@extends('layouts.master')
@section('css')
    <style>
        .details {
            font-size: 15px;
        }

         .bg-color {
            background-color: #e9edfa;
            margin: auto;
            padding: 1em 0 0.1em 0;
            border-radius: 6px;
            margin-bottom: 10px;
        }
    </style>
@endsection
@section('title')
    Delivery Note
@endsection
@section('content')
    @php
        use App\Http\Controllers\Admin\ExtraController;
    @endphp
    <div class="card">
        <div class="card-header">
            <div class="col-lg-12 d-flex align-items-center">
                <h4 class="card-title mb-0 flex-grow-1">DELIVERY NOTE DETAILS</h4>
                <div>
                    @if ($posEnabled)
                        <a class="btn btn-soft-primary waves-effect waves-light" id="printModal"
                            data-id="{{ $accountingVoucher->id }}"><i class="las la-print"></i>
                            Print</a>
                    @endif
                    <a type="button" class="btn btn-soft-primary waves-effect waves-light" href="/admin/delivery-note"><i
                            class="las la-angle-double-left"></i> Go Back</a>
                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">VOUCHER TYPE</h5>
                        <p class="details">{{ $accountingVoucher->voucherType->name }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">VOUCHER NUMBER</h5>
                        <p class="details">{{ $accountingVoucher->voucher_number }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">VOUCHER DATE</h5>
                        <p class="details">{{ \Carbon\Carbon::parse($accountingVoucher->voucher_date)->format('d M Y') }}
                        </p>
                    </div>
                </div>
            </div>
            <div class="row mt-3">
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">DELIVERY NOTE LEDGER (Cr)</h5>
                        <p class="details">{{ $accountingVoucher->creditLedger?->name }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">PARTY (Dr)</h5>
                        <p class="details">{{ $accountingVoucher->debitLedger?->name }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">TAX TYPE</h5>
                        @if ($igst)
                            <p class="details">Interstate(IGST)</p>
                        @else
                            <p class="details">Intrastate</p>
                        @endif
                    </div>
                </div>
            </div>
            <div class="row mt-3">
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">PRICE SLAB</h5>
                        <p class="details">{{ $accountingVoucher->priceSlab->name ?? '--' }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">STOCK LOCATION</h5>
                        <p class="details">{{ $accountingVoucher->stockLocation->name ?? '--' }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">REMARKS</h5>
                        <p class="details">{{ $accountingVoucher->remarks ?? '--' }}</p>
                    </div>
                </div>
            </div>
            <div class="row mt-3">
                <div class="col-lg-4 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">Cost Center</h5>
                        <p class="details">{{ $accountingVoucher->costCenter->name ?? '--' }}</p>
                    </div>
                </div>
                <div class="col-lg-4 text-center">
                    <a button type="button" class="btn btn-soft-primary waves-effect waves-light"
                        href="/admin/eway-bill/sale/{{ $accountingVoucher->id }}"><i class="las la-eye"></i>
                        Generate/View
                        Eway
                        Bill</a>
                </div>
                @if ($accountingVoucher->customer)
                    <div class="col-lg-4 text-center">
                        <div class="bg-color">
                            <h5 class="text-primary">Customer Name</h5>
                            <p class="details">{{ $accountingVoucher->customer->name ?? '--' }}</p>
                        </div>
                    </div>
                    <div class="col-lg-4 text-center">
                        <div class="bg-color">
                            <h5 class="text-primary">Customer Mobile</h5>
                            <p class="details">{{ $accountingVoucher->customer->mobile ?? '--' }}</p>
                        </div>
                    </div>
                    @if ($accountingVoucher->CustomerSource)
                        <div class="col-lg-4 text-center mt-3">
                            <div class="bg-color">
                                <h5 class="text-primary">Customer Source</h5>
                                <p class="details">{{ $accountingVoucher->CustomerSource->name ?? '--' }}</p>
                            </div>
                        </div>
                    @endif
                @endif
            </div>

        </div>
    </div>
    <div class="card">
        <div class="card-header">
            <div class="col-lg-12">
                <h4 class="card-title mb-0 flex-grow-1">ITEMS</h4>
            </div>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Item</th>
                            <th>MRP</th>
                            <th>Qty</th>
                            <th>Unit</th>
                            <th>Price</th>
                            <th>Price (Inc GST)</th>
                            <th>Gross Value</th>
                            <th>Dis %</th>
                            <th>Taxable Value</th>
                            <th>CGST</th>
                            <th>SGST</th>
                            <th>IGST</th>
                            <th>CESS</th>
                            <th>Total</th>
                            <th>Profit Margin</th>
                            <th>Profit Margin On<br>Landing Cost</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $totalProfit = 0;
                            $totalPMOnLandingCost = 0;
                            $totalTaxableValue = 0;
                            $totalProfits = [];
                            $totalPercentages = [];
                        @endphp
                        @foreach ($accountingVoucherItems as $item)
                            <tr>
                                <td>{{ $item->stockItem->name }} @if ($item->variant_id != null)
                                        <br>
                                        ({{ $item->variant->name }})
                                    @endif
                                </td>
                                <td>{{ $item->stockItem->mrp }}</td>
                                <td>{{ $item->quantity }}</td>
                                <td>{{ $item->unit->symbol }}</td>
                                <td>{{ $item->price }}</td>
                                <td>{{ $item->price_inc_tax }}</td>
                                <td>{{ $item->gross_value }}</td>
                                <td>{{ $item->disc_percentage }}</td>
                                <td>
                                    @php
                                        $totalTaxableValue += $item->taxable_value;
                                    @endphp
                                    {{ $item->taxable_value }}
                                </td>
                                <td>{{ $item->cgst }}</td>
                                <td>{{ $item->sgst }}</td>
                                <td>{{ $item->igst }}</td>
                                <td>{{ $item->cess }}</td>
                                <td>{{ $item->total }}</td>
                                <td>
                                    @if (Auth::user()->can('view profit margin'))
                                        @php
                                            $extraController = new ExtraController();
                                            $avgPrice = $extraController->getAvg(
                                                $item->stock_item_id,
                                                $accountingVoucher->voucher_date,
                                            );

                                            if ($avgPrice == 0) {
                                                continue;
                                            }
                                            $price = $avgPrice * $item->quantity;
                                            if ($price == 0) {
                                                continue;
                                            }
                                            $profit = (($item->taxable_value - $price) / $price) * 100; //profit percentage
                                            $profitAmount = round($item->taxable_value - $price, 2);
                                            $avgProfit = round($profit, 2);
                                            $totalProfit += $profitAmount;
                                            $totalProfits[] = $avgProfit;
                                        @endphp
                                        {{ $profitAmount }} ({{ $avgProfit . '%' }})
                                    @else
                                        ---
                                    @endif
                                </td>
                                <td>
                                    @if (Auth::user()->can('view profit margin'))
                                        @php
                                            $costPurchases = App\Models\AccountingVoucher::select('cost_allocation_id')
                                                ->where(['business_key' => Auth::user()->business_key])
                                                ->where('status', 1)
                                                ->where('cost_allocation_id', '!=', null)
                                                ->pluck('cost_allocation_id')
                                                ->toArray();
                                            $vouchers = App\Models\AccountingVoucher::where([
                                                'business_key' => Auth::user()->business_key,
                                            ])
                                                ->whereIn('id', $costPurchases)
                                                ->whereHas('items', function ($query) use ($item) {
                                                    $query->where('stock_item_id', $item->stock_item_id);
                                                })
                                                ->get();
                                            $itemCosts = [];
                                            foreach ($vouchers as $key => $voucher) {
                                                $taxable_value = $voucher->items()->sum('taxable_value');
                                                $expense = App\Models\AccountingVoucherLedger::whereHas(
                                                    'accountingVoucher',
                                                    function ($query) use ($voucher) {
                                                        $query->where('cost_allocation_id', $voucher->id);
                                                    },
                                                )
                                                    ->where('is_cost_allocated', 1)
                                                    ->sum('amount');
                                                $percentage = ($expense / $taxable_value) * 100;
                                                $itemPrice = $voucher
                                                    ->items()
                                                    ->where('stock_item_id', $item->stock_item_id)
                                                    ->sum('taxable_value');
                                                $itemQuantity = $voucher
                                                    ->items()
                                                    ->where('stock_item_id', $item->stock_item_id)
                                                    ->sum('quantity');
                                                $itemPrice = $itemPrice / $itemQuantity;
                                                $itemCosts[] = ($itemPrice * $percentage) / 100;
                                            }
                                            $avgCost =
                                                count($itemCosts) != 0 ? array_sum($itemCosts) / count($itemCosts) : 0;
                                            $landingCost = round($avgCost + $avgPrice, 2);
                                            $netCost = $item->quantity * $landingCost;
                                            if ($netCost == 0) {
                                                continue;
                                            }
                                            $PMOnLandingCost = $item->taxable_value - $netCost;
                                            $perc = round(($PMOnLandingCost / $netCost) * 100, 2);
                                            $totalPercentages[] = $perc;
                                            $totalPMOnLandingCost += $PMOnLandingCost;
                                        @endphp
                                        {{ $PMOnLandingCost }} ({{ $perc . '%' }})
                                    @else
                                        ---
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                        <tr>
                            <td colspan="8"><b>Total</b></td>
                            <td>{{ round($totalTaxableValue, 2) }}</td>
                            <td>{{ $accountingVoucherItems->sum('cgst') }}
                            <td>{{ $accountingVoucherItems->sum('sgst') }}
                            <td colspan="2"></td>
                            <td>{{ $accountingVoucherItems->sum('total') }}
                            <td>{{ round($totalProfit, 2) }}
                                ({{ count($totalProfits) > 0 ? round(array_sum($totalProfits) / count($totalProfits), 2) : 0 }}%)
                            </td>
                            <td>{{ round($totalPMOnLandingCost, 2) }}
                                ({{ count($totalPercentages) > 0 ? round(array_sum($totalPercentages) / count($totalPercentages), 2) : 0 }}%)
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
        <div class="card-footer">
            <div class="row">
                <div class="col-lg-3 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">DISCOUNT</h5>
                        <p class="details">{{ $accountingVoucher->discount ?? '0.00' }}</p>
                    </div>
                </div>
                <div class="col-lg-3 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">FREIGHT/ETC</h5>
                        <p class="details">{{ $accountingVoucher->freight }}</p>
                    </div>
                </div>
                <div class="col-lg-3 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">ROUND OFF</h5>
                        <p class="details">{{ $accountingVoucher->round_off }}</p>
                    </div>
                </div>
                <div class="col-lg-3 text-center">
                    <div class="bg-color">
                        <h5 class="text-primary">GRAND TOTAL</h5>
                        <p class="details">{{ $accountingVoucher->amount }}</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="card">
        <div class="card-header">
            <div class="col-lg-12">
                <h4 class="card-title mb-0 flex-grow-1">Associated Ledger Accounts</h4>
            </div>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table id="datatable" class="table table-striped table-bordered">
                    <thead>
                        <tr>
                            <th>Account Name</th>
                            <th>Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($accountingVoucher->accountingVoucherDetails as $accountingVoucherDetail)
                            <tr>
                                <td>{{ $accountingVoucherDetail->ledger->name }}</td>
                                <td>{{ $accountingVoucherDetail->amount }} {{ $accountingVoucherDetail->dr_or_cr }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
    <script type="text/javascript">
        $('#printModal').click(function(e) {
            e.preventDefault();
            var id = $(this).data('id');
            print = window.open("{{ URL::to('/admin/pos-print/') }}/" + id, "myWindow",
                "scrollbars=yes,width=288,height=512");
            print.screenX = 0;
            print.screenY = 0;
            print.window.onload = function() {
                print.print();
                print.onafterprint = function() {
                    print.close();
                }
            };
        });
    </script>
@endsection