@extends('backend.layouts.master')
@section('section-title', 'Report')
@section('page-title', 'Purchase 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.purchase') }}">
                    <div class="form-row">
                        <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.purchase') }}" 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">Purchase 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($purchaseItem))
                            <table class="table">
                                <thead>
                                    <tr class="header_bg">
                                        <th class="header_style_left">SL.</th>
                                        <th>Date</th>
                                        <th>Purchase No</th>
                                        <th>Product</th>
                                        <th>Quantity</th>
                                        <th>Return Qty</th>
                                        <th>Unit Price</th>
                                        <th class="header_style_right">Sub Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $sub_total = 0;
                                        $total_qty = 0;
                                    @endphp
                                    @forelse($purchaseItem as $key => $data)
                                        @php
                                            if ($data->product->unit->related_unit == null) {
                                                // Purchase qty
                                                $qty = $data->main_qty . ' ' . $data->product->unit->name;

                                                // Return qty
                                                $rtn_qty = $data->rtn_main . ' ' . $data->product->unit->name;
                                            } else {
                                                // Purchase qty convert
                                                $main_qty = $data->main_qty;
                                                $pur_total_main = $main_qty * $data->product->unit->related_value;
                                                $sub_qty = $data->sub_qty ?? 0;

                                                $pur_total_qty = $pur_total_main + $sub_qty;

                                                $check = $pur_total_qty / $data->product->unit->related_value;

                                                if (is_integer($check)) {
                                                    $qty =
                                                        $check .
                                                        ' ' .
                                                        $data->product->unit->name .
                                                        ' 0 ' .
                                                        $data->product->unit->related_unit->name;
                                                } else {
                                                    $main_value = floor($check) * $data->product->unit->related_value;
                                                    $sub_value = $pur_total_qty - $main_value;

                                                    $qty =
                                                        floor($check) .
                                                        ' ' .
                                                        $data->product->unit->name .
                                                        ' ' .
                                                        $sub_value .
                                                        ' ' .
                                                        $data->product->unit->related_unit->name;
                                                }

                                                // 🔹 Return qty convert
                                                $rtn_main = $data->rtn_main ?? 0;
                                                $rtn_sub = $data->rtn_sub ?? 0;

                                                $rtn_total_main = $rtn_main * $data->product->unit->related_value;
                                                $rtn_total_qty = $rtn_total_main + $rtn_sub;

                                                $rtn_check = $rtn_total_qty / $data->product->unit->related_value;

                                                if (is_integer($rtn_check)) {
                                                    $rtn_qty =
                                                        $rtn_check .
                                                        ' ' .
                                                        $data->product->unit->name .
                                                        ' 0 ' .
                                                        $data->product->unit->related_unit->name;
                                                } else {
                                                    $rtn_main_value =
                                                        floor($rtn_check) * $data->product->unit->related_value;
                                                    $rtn_sub_value = $rtn_total_qty - $rtn_main_value;

                                                    $rtn_qty =
                                                        floor($rtn_check) .
                                                        ' ' .
                                                        $data->product->unit->name .
                                                        ' ' .
                                                        $rtn_sub_value .
                                                        ' ' .
                                                        $data->product->unit->related_unit->name;
                                                }
                                            }

                                            $sub_total += $data->subtotal;
                                            $total_qty += $data->main_qty;
                                        @endphp
                                        <tr>
                                            <td class="table_data_style_left">{{ $key + 1 }}</td>
                                            <td>{{ date('m-d-Y', strtotime($data->purchase->date)) }}</td>
                                            <td>{{ $data->purchase->purchase_no }}</td>
                                            <td>{{ $data->product->name }}</td>
                                            <td>{{ $qty }}</td>
                                            <td>{{ $rtn_qty }}</td>
                                            <td>{{ number_format($data->rate, 2) }}
                                                {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}
                                            </td>
                                            <td class="table_data_style_right">{{ number_format($data->subtotal, 2) }}
                                                {{ empty(get_setting('com_currency')) ?: get_setting('com_currency') }}
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="10" 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="2"></td>
                                        <td colspan="2"> <strong class="text-white text-end"> Total : </strong></td>
                                        <td colspan="1"> <strong class="text-white"> {{ $total_qty }} pcs</strong>
                                        </td>
                                        <td colspan="1"> <strong class="text-white"></strong></td>
                                        <td class="header_style_right text-white" colspan="2"><strong>
                                                {{ number_format($sub_total, 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-center" role="alert"> Please Select Start and End
                                    Month</div>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection