@extends('layouts.main_without_top_button')
@section('title')
    Fuel Managements
@stop
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a> <span class="divider">/</span></li>
        <li><a href="">Fuels Managements</a> <span class="divider">/</span></li>
        <li class="active">Fuels Inventory</li>
    </ul>
@stop
@section('contentinner')
    <style>
        .inventory {
            background: white;
            font-family: "DejaVu Sans Mono", monospace;
            border: 1px solid #549c7f;
        }

        .inventory tbody td:nth-child(5),
        .inventory tbody td:nth-child(3),
        .inventory tbody td:nth-child(4),
        .inventory .inward {
            background: #eee;
            font-family: "DejaVu Sans Mono", monospace;
        }

        .inventory .inward {
            background: #eee;
        }

        .inventory tfoot {
            font-family: "DejaVu Sans Mono", monospace;
        }

        .inventory tfoot td {
            text-align: right;
        }

        .inventory tbody td:nth-child(7),
        .inventory tbody td:nth-child(8),
        .inventory tbody td:nth-child(6),
        .inventory .outward {
            background: #d2eeec;
            font-family: "DejaVu Sans Mono", monospace;
        }

        .inventory .outward {
            background: #d2eeec;
        }

        .inventory tbody td:nth-child(9),
        .inventory tbody td:nth-child(11),
        .inventory tbody td:nth-child(10),
        .inventory .balance {
            background: #d4d4d4;
            font-weight: 700;
            font-family: "DejaVu Sans Mono", monospace;
        }

        .inventory .balance {
            font-weight: 700;
        }
    </style>
<div class="widgetcontent">
    <center style="margin-bottom: 8px">
        <form class=" form-inline" action="{{route('fuel.inventory')}}" method="get">

            <label class="control-label" for="Category">Date From</label>
            <input type="text" name="date_from" id="starting_date" class="span3 datepicker">
            <label class="control-label" for="Category">Date to</label>
            <input type="text" name="date_to" id="expiring_date" class="span3 datepicker">

            <button type="submit" class="btn" style="">
                FILTER
            </button>
            <a href="{{route('fuel.inventory.print')}}" target="_blank" class="btn" style="">PRINT</a>
        </form>
    </center>

    <table class="table table-bordered inventory" id="inventory">
        <thead>
        <tr class="widgettitle">
            <th colspan="2">&nbsp;</th>
            <th class="inward" colspan="3" style="text-align: center">Inward</th>
            <th class="outward" colspan="3" style="text-align: center">Outward</th>
            <th class="balance" colspan="3" style="text-align: center">Balance</th>
        </tr>
        <tr>
            <th class="head0">Date</th>
            <th class="head1">Equipment/Vehicle</th>
            <th class="inward head1">Qnty</th>
            <th class="inward head1">Price</th>
            <th class="inward head1">Amount</th>
            <th class="outward head1">Qnty</th>
            <th class="outward head1">Price</th>
            <th class="outward head1">Amount</th>
            <th class="balance head1">Qnty</th>
            <th class="balance head1">Price</th>
            <th class="balance head1">Amount</th>
        </tr>
        <tr>
            <th colspan="8" style="text-align: right">OPEN BALANCE</th>
            <th style="text-align: right">{{number_format($open_balance['open_quantity'])}}</th>
            <th style="text-align: right">{{number_format($open_balance['avarage_price'])}}</th>
            <th style="text-align: right">{{number_format($open_balance['open_quantity']*$open_balance['avarage_price'])}}</th>
        </tr>
        </thead>
        <tbody>
        {{--*/ $in_quantity_total = 0 /*--}}
        {{--*/ $out_quantity_total = 0 /*--}}
        {{--*/ $avarage_price = $open_balance['avarage_price'] /*--}}
        {{--*/ $balance_quantity = $open_balance['open_quantity'] /*--}}
        @foreach($fuel_inventories as $inventory)
            <tr>
                <td style="width: 90px">{{ \Carbon\Carbon::parse($inventory['date'])->toFormattedDateString()}}</td>
                <td>{{ $inventory['registration_number']}}</td>
                <td>{{number_format($inventory['in_quantity'])}}</td>
                <td style="text-align: right">{{number_format($inventory['in_price'])}}</td>
                <td style="text-align: right">{{number_format($inventory['in_amount'])}}</td>
                {{--*/ $in_quantity_total += $inventory['in_quantity'] /*--}}
                {{--*/ $out_quantity_total += $inventory['out_quantity'] /*--}}
                <td>{{number_format($inventory['out_quantity'])}}</td>
                <td style="text-align: right">{{number_format($inventory['out_price'])}}</td>
                <td style="text-align: right">{{number_format($inventory['out_amount'])}}</td>
                {{--*/ $balance_quantity += $inventory['in_quantity'] /*--}}
                {{--*/ $balance_quantity -= $inventory['out_quantity'] /*--}}
                {{--*/ $avarage_price = $inventory['average_price'] /*--}}
                @if($inventory['in_price']>0)
                @endif
                <td>{{number_format($balance_quantity)}}</td>
                <td style="text-align: right">{{number_format($inventory['average_price'])}}</td>
                <td style="text-align: right">{{number_format($inventory['average_price']*$balance_quantity)}}</td>
        @endforeach
        </tbody>
        <tfoot>
        <tr>
            <td colspan="2"> TOTAL INWARD</td>
            <td style="text-align: left">{{number_format($in_quantity_total)}}</td>
            <td colspan="2">TOTAL OUTWARD</td>
            <td style="text-align: left">{{number_format($out_quantity_total)}}</td>
            <td colspan="2">CLOSED BALANCE</td>
            <td>{{number_format($balance_quantity)}}</td>
            <td style="text-align: right">{{number_format($avarage_price)}}</td>
            <td>{{number_format($avarage_price*$balance_quantity)}}</td>
        </tr>
        </tfoot>
    </table>

</div>
<script>
    jQuery('.datepicker').datepicker();
</script>
@stop