@extends('layouts.master')

@section('title', 'Inventory Report')

@section('content')

    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Inventory Report</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">Inventory Report</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>


    <div class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="col-md-3">
                        <label>Item</label>
                        <select class="select2 form-control" id="item" name="item" onchange="getInventory()">
                            <option value="-1">All Items</option>
                            @foreach ($item as $value)
                                <option value="{{ $value->id }}">
                                    {{ $value->item_code . '-' . $value->item_name . ($value->barcode!=''?' ('.$value->barcode.')':'') }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-lg-3" style="padding-top: 31px;">
                        <div class="btn-group">
                            <button type="button" class="btn btn-info">Export To </button>
                            <button type="button" class="btn btn-info dropdown-toggle dropdown-icon" data-toggle="dropdown">
                                <span class="sr-only">Toggle Dropdown</span>
                            </button>
                            <div class="dropdown-menu" role="menu">
                                <a class="dropdown-item" href="#" onclick="exportExcel()">Excel</a>
                            </div>
                        </div>
                    </div>
                    <br>
                </div>
            </div>
            <div class="row">
                <div class="col-lg-12">
                    <div class="card card-primary card-outline card-outline-tabs" style="padding: 15px">
                        <table class="table ">
                            <tr>
                                <th>#</th>
                                <th>Item Code</th>
                                <th>Barcode</th>
                                <th>Item Name</th>
                                <th style="text-align: right">Cost Price</th>
                                <th style="text-align: right">Sales Price</th>
                                <th style="text-align: right">Current Stock</th>
                                <th style="text-align: right">Total Value</th>

                            </tr>
                            @php
                                $count = 1;
                                $total_inventory_value = 0;
                            @endphp
                            @foreach ($stock as $value)