@extends('backend.layouts.master')
@section('section-title', 'Report')
@section('page-title', 'Item 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.item-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.item-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">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>Category</th>
                                        <th>Product</th>
                                        <th>Quantity</th>
                                        <th>Unit Price</th>
                                        <th>Discount</th>
                                        <th class="header_style_right">Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $total_discount = 0;
                                        $total_amount = 0;
                                        $total_qty = 0;
                                    @endphp
                                    @forelse($invoiceItem as $key => $item)
                                        @php
                                        $product = App\Models\Product::where('id', $item->product_id)
                                        ->with('unit.related_unit')
                                        ->first();
                                        if ($product->is_service == 0) {
                                            if ($product->unit->related_unit == null) {
                                                // Sub unit নাই → normal show
                                                $qty = $item->main_qty . ' ' . $product->unit->name;
                                            } else {
                                                // Sub unit আছে → সব convert হবে main unit এ
                                                $sub_qty = $item->sub_qty ?? 0;
                                                $related_value = $product->unit->related_value; // ১ main unit = কত sub unit
                                                // main_qty + sub_qty convert to main unit
                                                $total_main = $item->main_qty + $sub_qty / $related_value;
                                                // চূড়ান্ত show → শুধু main unit এ
                                                $qty = $total_main . ' ' . $product->unit->name;
                                            }
                                        } else {
                                            $qty = $item->main_qty . ' pcs';
                                        }
                                            $total_discount += $item->product_discount;
                                            $total_amount += $item->subtotal;
                                            $total_qty += $item->main_qty;
                                        @endphp
                                        <tr>
                                            <td>{{ $key + 1 }}</td>
                                            <td>{{ date('m-d-Y', strtotime($item->invoice->date)) }}</td>
                                            <td>{{ $item->invoice->invoice_no }}</td>
                                            <td>{{ $item->product->category->name }}</td>
                                            <td>{{ $item->product->name }}</td>
                                            <td>{{ $qty }}</td>
                                            <td>{{ $item->rate }}</td>
                                            <td>{{ number_format($item->product_discount, 2) }}</td>
                                            <td>{{ number_format($item->subtotal, 2) }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="8" 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">{{ $total_qty }} pcs</td>
                                        <td class="text-white" colspan="1"></td>
                                        <td class="text-white" colspan="1">{{ number_format($total_discount, 2) }}    {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}</td>
                                        <td class="header_style_right text-white text-left" colspan="1"><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