@extends('layouts.template')

@section('template')
<!-- Content Header -->
<section class="content-header">
    <h1>
        STOCK REPORT
        
        </h1>
    <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
        <li class="active">Stock Report</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    LIST
                   <!--  <a class="btn btn-success btn-xs" href="{{ url('/purchase') }}" target="">Add New</a> -->
                    <a class="btn btn-default btn-xs pull-right" target="_blank" href="{{ url('/report/current-stock-pdf') }}" target="">Download as PDF/Print</a>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <table class="table table-bordered" id="purchase_details" width="100%">
                            <thead>
                                <tr>
                                    <th style="width:5%" height="25">Srl</th>
                                    <th style="width:10%">Code</th>
                                    <th style="width:30%">Item Name</th>
                                    <!-- <th style="width:15%">Catagory Name</th>
                                    <th style="width:15%">Brand Name</th> -->
                                    <th style="width:10%">Stock</th>
                                    <th style="width:10%">Unit Cost</th>
                                    <th style="width:10%">Total Cost</th>
                                    <th style="width:10%">MRP</th>
                                    <th style="width:10%">Total MRP</th>
                                    <th style="width:25%;text-align: center;">Action</th>
                                </tr>
                            </thead>

                            <tbody>
                                @if(isset($item))
                                    @php 
                                        $srl = 0; 
                                        $qty = 0;
                                        $purchase_amount = 0;
                                        $mrp_amount = 0;
                                    @endphp
                                    @foreach($item as $key => $items)
                                        @if($items->opening_stock_qty+$items->stock_in-$items->stock_out>0)
                                            <tr>
                                                <td height="25">{{ ++$key }}</td>
                                                <td>{{ $items->item_code }}</td>
                                                <td>{{ $items->item_name }} {{ $items->color_name ? '| '.$items->color_name : '' }} {{ $items->size_name ? '| '.$items->size_name : '' }}</td>
                                                <td class="@if($items->opening_stock_qty+$items->stock_in-$items->stock_out <=2) btn-danger 
                                                    @elseif($items->opening_stock_qty+$items->stock_in-$items->stock_out <= 4 ) btn-warning @else btn-success @endif">{{ $items->opening_stock_qty+$items->stock_in-$items->stock_out  }}</td>
                                                    <td class="amount">{{ $items->costing_rate }}</td>
                                                    <td class="amount">{{ ($items->opening_stock_qty+$items->stock_in-$items->stock_out) * $items->costing_rate }}</td>
                                                    <td class="amount">{{ $items->mrp }}</td>
                                                    <td class="amount">{{ ($items->opening_stock_qty+$items->stock_in-$items->stock_out) * $items->mrp }}</td>
                                                <td  style="text-align: center;">
                                                    
                                                        <a target="_blank" href="{{ url('/item/'.$items->item_id.'/inventory') }}" class="btn btn-info btn-xs"><i class="fa fa-cube" aria-hidden="true"></i> Inventory History</a>

                                                    
                                                </td>
                                            </tr>
                                            @php 
                                                $qty += ($items->opening_stock_qty+$items->stock_in-$items->stock_out);
                                                $purchase_amount += (($items->opening_stock_qty+$items->stock_in-$items->stock_out) * ($items->costing_rate));
                                                $mrp_amount += ($items->opening_stock_qty+$items->stock_in-$items->stock_out) * ($items->mrp);
                                            @endphp
                                        @endif
                                    @endforeach
                                @endif
                            </tbody>
                        </table>
                    

                        <span class="text-red">
                            TOTAL QTY: {{ $qty }}<br>
                            TOTAL COST: {{ $stock_value }}
                            TOTAL MRP: {{ $mrp_amount }}
                        </span>

                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<!-- End Main Content -->
@endsection