@extends('backend.layouts.master')
@section('section-title', 'Report')
@section('page-title', 'Product Sale Report')

@push('css')
    <style>
        @media print {

            table,
            table th,
            table td {
                color: black !important;
            }

            #h-hide {
                display: none;
            }
        }
    </style>
@endpush

@section('content')
    <div class="row">
        <div class="col-lg-12">
            <div class="card card-body card_style mb-2" style="margin-top: -5px;" id="h-hide">
                <form action="{{ route('report.product.sale') }}">
                    <div class="form-row">
                        <div class="form-group col-md-4">
                            <select class="select2" name="category_id">
                                <option selected value="">Select Category</option>
                                @foreach ($categories as $category)
                                    <option value="{{ $category->id }}">{{ $category->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-4">
                            <select class="select2" name="product_id">
                                <option selected value="">Select Product</option>
                                @foreach ($products as $product)
                                    <option value="{{ $product->id }}"
                                        @isset($oneProduct) @if ($product->id == $oneProduct->id) selected @endif @endisset>
                                        {{ $product->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-4">
                            <input type="date" name="start_date" class="form-control"
                                value="{{ isset($sdate) ? date('Y-m-d', strtotime($sdate)) : '' }}">
                        </div>
                        <div class="form-group col-md-4">
                            <input type="date" name="end_date" class="form-control"
                                value="{{ isset($edate) ? date('Y-m-d', strtotime($edate)) : '' }}">
                        </div>
                    </div>
                    <div class="form-row mt-2">
                        <div class="form-group col-12">
                            <button class="btn add_list_btn" type="submit">
                                <i class="fa fa-sliders"></i> Filter
                            </button>
                            <a href="{{ route('report.product.sale') }}" class="btn add_list_btn_reset">Reset</a>
                            <a href="" class="btn add_list_btn float-right" onclick="window.print()">Print</a>
                        </div>
                    </div>
                </form>
            </div>
            <div class="card m-b-30 print_area card_style">
                <div class="card-header">
                    <h4 style="text-align: center; font-weight:bold; margin-top:25px;font-size:30px">Product Sale Report
                        ({{ isset($sdate) ? date('m-d-Y', strtotime($sdate)) : '' }} -
                        {{ isset($edate) ? date('m-d-Y', strtotime($edate)) : '' }})</h4>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        @if (isset($invoiceItem))
                            <table class="table">
                                <thead>
                                    <tr class="header_bg">
                                        <th class="header_style_left">SL.</th>
                                        <th>Date</th>
                                        <th>Invoice No</th>
                                        <th>Product</th>
                                        <th>Quantity</th>
                                        <th>Unit Price</th>
                                        <th>Sub Total</th>
                                        <th>Discount</th>
                                        <th class="header_style_right">Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $sub_total = 0;
                                        $total_sale = 0;
                                        $total_goods = 0;
                                        $total_discount = 0;
                                        $total_delivery_charge = 0;
                                        $total_profit = 0;
                                        $total_amount = 0;
                                        $service_amount = 0;
                                    @endphp
                                    @forelse($invoiceItem as $key => $data)
                                        @php
                                            $items = App\Models\InvoiceItem::where('invoice_id', $data->id)
                                                ->where('is_return', 0)
                                                ->get();
                                            $saleAmt = 0;
                                            $goodCost = 0;
                                            foreach ($items as $item) {
                                                // Sale subtotal থেকে return বাদ
                                                $netSale = $item->inv_subtotal - $item->rtn_total;
                                                $saleAmt += $netSale;
                                                // Purchase subtotal থেকে return বাদ
                                                $unitCost =
                                                    $item->main_qty > 0 ? $item->pur_subtotal / $item->main_qty : 0;
                                                $returnCost = $unitCost * $item->rtn_main;
                                                $netPurchase = $item->pur_subtotal - $returnCost;
                                                $goodCost += $netPurchase;
                                                if (($item->product?->is_service ?? 0) == 1) {
                                                    $service_amount += $item->subtotal;
                                                }
                                            }
                                            $sub_total += $data->total_amount;
                                            $grossProfit =
                                                $saleAmt - $goodCost - $data->discount_amount + $data->delivery_charge;
                                            $total_sale += $saleAmt;
                                            $total_goods += $goodCost;
                                            $total_discount += $data->discount_amount;
                                            $total_delivery_charge += $data->delivery_charge;
                                            $total_profit += $grossProfit;
                                            $total_amount += $data->total_amount;
                                        @endphp
                                        @if ($items->count() > 0)
                                            <tr>
                                                <td class="table_data_style_left">{{ $key + 1 }}</td>
                                                <td>{{ date('m-d-Y', strtotime($data->date)) }}</td>
                                                <td>{{ $data->invoice_no }}</td>
                                                <td>
                                                    @foreach ($items as $item)
                                                        <ul>
                                                            <li>{{ $item->product?->name }}</li>
                                                        </ul>
                                                    @endforeach
                                                </td>
                                                <td>
                                                    @foreach ($items as $item)
                                                        @php
                                                            $main_qty = $item->main_qty - $item->rtn_main;
                                                            $sub_qty = $item->sub_qty - $item->rtn_sub;
                                                        @endphp
                                                        @if ($item->product->unit?->related_unit == null)
                                                            <ul>
                                                                <li>{{ $main_qty . ' ' . $item->product->unit?->name }}
                                                                </li>
                                                            </ul>
                                                        @else
                                                            <ul>
                                                                <li>{{ $main_qty . ' ' . $item->product->unit->name . ' ' . $sub_qty . ' ' . $item->product->unit->related_unit->name }}
                                                                </li>
                                                            </ul>
                                                        @endif
                                                    @endforeach
                                                </td>
                                                <td>
                                                    @foreach ($items as $item)
                                                        <ul>
                                                            <li>{{ $item->rate }}
                                                            </li>
                                                        </ul>
                                                    @endforeach
                                                </td>
                                                <td>
                                                    @foreach ($items as $item)
                                                        <ul>
                                                            <li>{{ $item->subtotal }}
                                                            </li>
                                                        </ul>
                                                    @endforeach
                                                </td>
                                                <td>{{ number_format($data->discount_amount, 2) }}
                                                    {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}
                                                </td>
                                                <td class="table_data_style_right">
                                                    {{ number_format($data->total_amount, 2) }}
                                                    {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}
                                                </td>
                                            </tr>
                                        @endif
                                    @empty
                                        <tr>
                                            <td colspan="9" class="text-center text-danger no_data_style">No Data Found
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                <tfooter>
                                    <tr class="header_bg" style="font-size: 20px; font-width: 700; font-family:sans-serif">
                                        <td class="header_style_left" colspan="3"></td>
                                        <td colspan="2"> <strong class="text-white"> Total: </strong></td>
                                        <td class="text-white" colspan="1"></td>
                                        <td class="header_style_right text-white text-right" colspan="3"><strong>
                                                {{ number_format($total_amount, 2) }}
                                                {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}
                                            </strong></td>
                                    </tr>
                                </tfooter>
                            </table>
                        @else
                            <div class="col-md-12" style="padding-bottom: 30px;">
                                <div class="alert alert-danger text-right" role="alert"> Please Select Start and End
                                    Month</div>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection