@extends('layouts.admin')
@section('title', 'Product | Mintavia Admin')

@section('css')
    <style>
        table.table>tbody>tr.summary-row>td {
            background-color: #9bedae !important;
        }

        table.table>tbody>tr.details-row>td {
            background-color: #6ea4d6 !important;
        }

        table.table>tbody>tr.details-row table.table-sm tbody tr>td {
            background-color: #e9f5ff !important;
        }

        table.table>tbody>tr.details-row table.table-sm thead tr>th {
            background-color: #cfe8fc !important;
        }
    </style>
@endsection

@section('content')
    <div class="row">
        <div class="col-12">
            @if (isset($message) && $message)
                @switch($message['status'])
                    @case('success')
                        <script>
                            window.onload = function() {
                                toastr.success("{{ $message['message'] }}")
                            }
                        </script>
                    @break

                    @case('error')
                        <script>
                            window.onload = function() {
                                toastr.error("{{ $message['message'] }}")
                            }
                        </script>
                    @break
                @endswitch
            @endif
            <div class="card card-primary">
                <div class="card-header d-flex align-items-center">
                    <h3 class="card-title">Bill & Item wise profit/loss</h3>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('admin.reports.profit_loss') }}">
                        <div class="row mb-3">
                            <div class="col-md-2">
                                <input type="date" name="date_from" class="form-control"
                                    value="{{ request('date_from') }}">
                            </div>
                            <div class="col-md-2">
                                <input type="date" name="date_to" class="form-control" value="{{ request('date_to') }}">
                            </div>
                            <div class="col-md-3">
                                <select name="costCalc" class="form-control">
                                    <option value="">-- Select Formula --</option>
                                    <option value="Average_Purchase_Price"
                                        {{ request('costCalc') == 'Average_Purchase_Price' ? 'selected' : '' }}>Average Purchase
                                        Price</option>
                                    <option value="Average_Sale_Price"
                                        {{ request('costCalc') == 'Average_Sale_Price' ? 'selected' : '' }}>Average Sale Price
                                    </option>
                                    <option value="PurchasePrice" {{ request('costCalc') == 'PurchasePrice' ? 'selected' : '' }}>
                                        Purchase Price</option>
                                    <option value="MRP_Purchase" {{ request('costCalc') == 'MRP_Purchase' ? 'selected' : '' }}>MRP
                                        Purchase</option>
                                    <option value="Net_Rate_Purchase"
                                        {{ request('costCalc') == 'Net_Rate_Purchase' ? 'selected' : '' }}>Net Rate Purchase
                                    </option>
                                    <option value="SalePrice" {{ request('costCalc') == 'SalePrice' ? 'selected' : '' }}>Sale
                                        Price</option>
                                    <option value="MRP_Sale" {{ request('costCalc') == 'MRP_Sale' ? 'selected' : '' }}>MRP Sale
                                    </option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <input type="text" name="barcode" class="form-control"
                                    placeholder="Enter Barcode (optional)" value="{{ request('barcode') }}">
                            </div>
                            <div class="col-md-2">
                                <button type="submit" class="btn btn-primary w-100">Filter</button>
                            </div>
                        </div>
                    </form>
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>Part No</th>
                                    <th>Item Name</th>
                                    <th>Brand</th>
                                    <th>Barcode</th>
                                    <th>Qty</th>
                                    <th>Sale Rate</th>
                                    <th>Purchase Rate</th>
                                    <th>Profit/Loss</th>
                                    <th>Profit/Loss %</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($sales as $row)
                                    <tr>
                                        <td>{{ $row->product_part_no ?? ($row->product->product_item->part_no ?? '-') }}
                                        </td>
                                        <td>{{ $row->product->product_item->item_name ?? '-' }}</td>
                                        <td>{{ $row->brand->brand_name ?? '-' }}</td>
                                        <td>{{ $row->barcode }}</td>
                                        <td>{{ $row->qty }}</td>
                                        <td>{{ number_format($row->rate, 2) }}</td>
                                        <td>{{ number_format($row->purchase_rate, 2) }}</td>
                                        <td>{{ number_format($row->profit_loss, 2) }}</td>
                                        <td>{{ $row->profit_loss_percent }} %</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script>
        // Add JavaScript for additional functionality if needed
    </script>
@endsection