@extends('admin.layout.master')

@section('title')
    Stock
@endsection

<link rel="stylesheet" href="{{ URL::asset('admin/assets/vendors/datatables.net-bs5/dataTables.bootstrap5.css') }}">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/OwlCarousel2/2.3.4/assets/owl.carousel.min.css">
<link rel="stylesheet"
      href="https://cdnjs.cloudflare.com/ajax/libs/OwlCarousel2/2.3.4/assets/owl.theme.default.min.css">
<style>
    .owl-nav {
        display: none !important;
    }
</style>
@section('content')

    <div class="page-content">

        <nav class="page-breadcrumb">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="{{ route('admin./') }}">Home</a></li>
                <li class="breadcrumb-item active" aria-current="page">Stock</li>
            </ol>
        </nav>

        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            @include('admin.layout.laravel_errors')
                        </div>

                        <div class="table-responsive">
                            <table id="dataTableExample" class="table">
                                <thead>
                                <tr>
                                    <th>Id</th>
                                    <th>Category</th>
                                    <th>Product</th>
                                    <th>Total Quantity</th>
                                    <th>Sale</th>
                                    <th>Quantity Remaining</th>
                                    <th>Latest Purchase Price</th>
                                    <th>Latest Sale Price</th>
                                </tr>
                                </thead>
                                <tbody>
                                @forelse($stocks as $i=>$stock)
                                    <tr>
                                        <td>{{ $i+1 }}</td>
                                        <td>{{ ($stock->category_data) ? $stock->category_data->name : '--' }}</td>
                                        <td>{{ ($stock->name) ? $stock->name : '--' }}</td>
                                        <td>{{ ($stock->inventory_data) ? $stock->inventory_data->sum('quantity') : '' }}</td>
                                        <td>{{ ($stock->sale_data) ? $stock->sale_data->sum('quantity') : '' }}</td>
                                        <td>{{ number_format($stock->inventory_data->sum('quantity')-$stock->sale_data->sum('quantity')) }}</td>
                                        <td>{{ ($stock->latest_purchase_price->first()) ? number_format($stock->latest_purchase_price->first()->price) : '--' }}</td>
                                        <td>{{ ($stock->latest_purchase_price->first()) ? number_format($stock->latest_purchase_price->first()->sale_price) : '--' }}</td>
                                    </tr>
                                @empty
                                @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection
@section('script')

    <script src="{{ URL::asset('admin/assets/vendors/datatables.net/jquery.dataTables.js') }}"></script>
    <script src="{{ URL::asset('admin/assets/vendors/datatables.net-bs5/dataTables.bootstrap5.js') }}"></script>
    <script src="{{ URL::asset('admin/assets/js/data-table.js') }}"></script>

@endsection