@extends('layouts.template')

@section('template')

<section class="content-header">
    <h1>
        INVENTORY 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">Inventory Report</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content" style="">
    <div class="row">
        <div class="col-md-12" id="printPageButton">    
            <div class="panel panel-default">
                <div class="panel-body">
                    <form class="form" action="{{ url('report/inventory/descriptive') }}" id="date_form" method="post">
                        {!! csrf_field() !!}
                        <input type="hidden" name="_token" value="{{ csrf_token() }}">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="">Stock Location</label>
                                <select class="form-control select2" name="stock_location_id" id="stock_location_id">
                                    <option value="">Select</option>
                                    @foreach($stock_location as $data)
                                    <option value="{{$data->stock_location_id}}" @if(isset($stock_location_id)) @if($stock_location_id==$data->stock_location_id) selected @endif @endif>{{$data->stock_location_name}}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div> 
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="">Start Date</label>
                                <input type="text" autocomplete="OFF" id="datepicker" name="start_date" class="form-control input-sm" @if(isset($start_date)) value="{{ $start_date }}"@endif  required />
                            </div>
                        </div> 
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="">End Date</label>
                                <input type="text" autocomplete="OFF" id="datepicker2" name="end_date" class="form-control input-sm" @if(isset($end_date)) value="{{ $end_date }}"@endif  required onchange='if(this.value != "") { this.form.submit(); }'/>
                            </div>
                        </div>    
                        <div class="col-md-3">
                            &nbsp<br>
                            <button  type="submit" class="btn btn-info btn-sm " style="">Submit</button>
                        </div>  
                    </form>
                </div>
            </div>        
        </div>
        
        @if(isset($start_date))
        <div class="col-md-12">
            <div class="panel panel-primary">
                <div class="panel-heading" id="printPageButton">
                    List Inventory
                   
                    <a class="btn btn-default btn-xs pull-right" href="{{ url('/report/inventory/descriptive-pdf/'.$start_date.'/'.$end_date.'/'.$stock_location_id) }}" target="_blank">Print/Download as PDF</a>
            
                </div>

                <div class="panel-body">
                    <div class="table-responsive" style="">
                        <table  class="table-striped" border="1" width="100%">
                            <thead>
                                <tr class="text-center font-bold">
                                    <td rowspan="2">Srl</td>
                                    <td rowspan="2">Category</td>
                                    <td colspan="2" class="bg-1">Opening Inventory</td>
                                    <td colspan="4" class="bg-2">Transaction Inventory</td>
                                    <td colspan="2" class="bg-3" >Closing Inventory</td>
                                </tr>
                                <tr class="text-center font-bold">
                                    <td class="bg-1">Stock</td>
                                    <td class="bg-1">Amount</td>
                                    <td class="bg-2">Stock In</td>
                                    <td class="bg-2">Amount</td>
                                    <td class="bg-2">Stock Out</td>
                                    <td class="bg-2">Amount</td>
                                    <td class="bg-3">Stock</td>
                                    <td class="bg-3">Amount</td>
                                </tr>
                            </thead>
                            <tbody>
                            @for ($i=0; $i < count($inventory); $i++) 
                                <tr>
                                    <td style="padding-left: 3px;">{{$i+1}}</td>
                                    <td style="padding-left: 3px;">{{$inventory[$i]['cata_name']}}</td>
                                    <td class="qty-center bg-1">{{$inventory[$i]['opening_qty']}}</td>
                                    <td class="amount bg-1">{{$inventory[$i]['opening_amount']}}</td>
                                    <td class="qty-center bg-2">{{$inventory[$i]['transaction_qty_in']}}</td>
                                    <td class="amount bg-2">{{$inventory[$i]['transaction_amount_in']}}</td>
                                    <td class="qty-center bg-2">{{$inventory[$i]['transaction_qty_out']}}</td>
                                    <td class="amount bg-2">{{$inventory[$i]['transaction_amount_out']}}</td>
                                    <td class="qty-center bg-3">{{$inventory[$i]['closing_qty']}}</td>
                                    <td class="amount bg-3">{{$inventory[$i]['closing_amount']}}</td>
                                </tr>
                            @endfor 

                            <tr class="font-bold">
                                <td class="text-center" colspan="2">TOTAL</td>
                                <td class="qty-center bg-1">{{$op_inventory_total_qty}}</td>
                                <td class="amount bg-1">{{number_format($op_inventory_total_amount,2)}}</td>
                                <td class="qty-center bg-2">{{$stock_in_today}}</td>
                                <td class="amount bg-2">{{number_format($stock_in_total,2)}}</td>
                                <td class="qty-center bg-2">{{$stock_out_today}}</td>
                                <td class="amount bg-2">{{number_format($stock_out_total,2)}}</td>
                                <td class="qty-center bg-3">{{$closing_inventory_total_qty}}</td>
                                <td class="amount bg-3">{{number_format($closing_inventory_total_amount,2)}}</td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        @endif
    </div>
</section>
<!-- End Main Content -->
@endsection