@extends('layouts.template')

@section('template')

<section class="content-header">
    <h1>
        STOCK REPORT - INVENTORY
        
        </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/product') }}" 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="">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-6">
                            &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/product-pdf/'.$start_date.'/'.$end_date) }}" target="_blank">Print/Download as PDF</a>
            
                </div>

                <div class="panel-body">
                    <div class="table-responsive" style="">
                        <input class="form-control" id="myInput" type="text" placeholder="Search..">
                        <br>
                        <table  class="table-striped" border="1" width="100%">
                            <thead>
                                <tr class="text-center font-bold">
                                    <td rowspan="2">Srl</td>
                                    <td rowspan="2">Item</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 id="myTable">
                            @php 
                                $op_qty_sum = 0; 
                                $op_amount_sum = 0;

                                $tran_in_qty_sum = 0; 
                                $tran_in_amount_sum = 0;
                                $tran_out_qty_sum = 0; 
                                $tran_out_amount_sum = 0;
                                
                                $closing_qty_sum = 0;
                                $closing_amount_sum = 0;
                            @endphp
                            @for ($i=0; $i < count($inventory); $i++) 
                                @if( $inventory[$i]['opening_qty'] > 0 || $inventory[$i]['transaction_qty_in'] > 0 || $inventory[$i]['closing_qty'] > 0)
                                <tr>
                                    <td>{{$i+1}}</td>
                                    <td>{{$inventory[$i]['item_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>
                                @endif
                            @php 
                                $op_qty_sum += (int) $inventory[$i]['opening_qty'];
                                $op_amount_sum += (int) $inventory[$i]['opening_amount'];

                                $tran_in_qty_sum += (int) $inventory[$i]['transaction_qty_in'];
                                $tran_in_amount_sum += (int) $inventory[$i]['transaction_amount_in'];
                                $tran_out_qty_sum += (int) $inventory[$i]['transaction_qty_out'];
                                $tran_out_amount_sum += (int) $inventory[$i]['transaction_amount_out'];

                                $closing_qty_sum += (int) $inventory[$i]['closing_qty'];
                                $closing_amount_sum += (int) $inventory[$i]['closing_amount'];
                            @endphp
                            @endfor
                            <tr class="font-bold">
                                <td class="text-center" colspan="2">TOTAL</td>
                                <td class="qty-center bg-1">{{$op_qty_sum}}</td>
                                <td class="amount bg-1">{{$op_amount_sum}}</td>
                                <td class="qty-center bg-2">{{$tran_in_qty_sum}}</td>
                                <td class="amount bg-2">{{$tran_in_amount_sum}}</td>
                                <td class="qty-center bg-2">{{$tran_out_qty_sum}}</td>
                                <td class="amount bg-2">{{$tran_out_amount_sum}}</td>
                                <td class="qty-center bg-3">{{$closing_qty_sum}}</td>
                                <td class="amount bg-3">{{$closing_amount_sum}}</td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        @endif
    </div>
</section>

<script>
$(document).ready(function(){
  $("#myInput").on("keyup", function() {
    var value = $(this).val().toLowerCase();
    $("#myTable tr").filter(function() {
      $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
    });
  });
});
</script>

@endsection