@extends('layouts.admin')

@push('styles')
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


<style type="text/css">
    .btn_mt {
        margin-top: 31px;
    }
</style>
@endpush

@section('content')

<!-- Main content -->
<section class="content">
    <div class="container-fluid pt-2">

        <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-info">

                <!-- form start -->
                <form method="GET" action="{{ route('report.stockho2') }}">
                    <div class="card-body">
                        <div class="row">

                            <div class="col-md-3">

                                <div class="form-group row">
                                    <label for="cat_id">Category:</label>
                                    <div class="col-sm-12">

                                        <select id="cat_id" name="cat_id" class="form-control form-control-sm select2" style="width: 100%;">

                                            <option value="">Select Category</option>
                                            @foreach($categories as $v)
                                            <option value="{{$v->id}}">{{ $v->cat_name }}</option>
                                            @endforeach

                                        </select>

                                        @error('cat_id')
                                        <span class="error invalid-feedback" role="alert">
                                            <strong>{{ $message }}</strong>
                                        </span>
                                        @enderror

                                    </div>
                                </div>

                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="product_id">Product</label>

                                    <select id="product_id" name="product_id"
                                        class="form-control form-control-sm select2" value=""
                                        style="width: 100%;">
                                        <option value="">Select Product</option>
                                        @foreach ($products as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($product_id) && $product_id == $v->id ? 'selected' : '' }}>
                                            {{ $v->product_name }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="stock_type">Stock Type</label>

                                    <select id="stock_type" name="stock_type" class="form-control form-control-sm"
                                        value="" style="width: 100%;">

                                        <option value=""> All </option>
                                        <option value="1" {{ $stock_type == 1 ? 'selected' : '' }}> Not Empty
                                        </option>
                                        <option value="2" {{ $stock_type == 2 ? 'selected' : '' }}> Empty
                                        </option>

                                    </select>
                                </div>
                            </div>


                            <div class="col-sm-4">
                                <button type="submit" style="margin-top: 30px;"
                                    class="btn btn-sm btn-primary btn_mt">Search</button>
                                <a href="{{ route('report.stockho2') }}" style="margin-top: 30px;"
                                    class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                            </div>

                        </div>
                    </div>
                </form>
            </div>
        </div>

        <!-- /.card -->

        <div class="row">
            <!-- left column -->
            <div class="col-md-12">

                <div class="card card-info">
                    <div class="card-header">
                        <h3 class="card-title">Head Office Stock Balance Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <table id="example1" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>SL</th>
                                    <th>Category</th>
                                    <th>Product Name</th>
                                    <th>Unit</th>
                                    <th>Balance</th>
                                    <th> Price</th>
                                    <!-- <th>Previous Price</th>
                                        <th>AVG Price</th> -->
                                    <th>Total Amt.</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if (!empty($reportData))
                                @php
                                $sl = 1;
                                $grandTotal= 0;
                                @endphp
                                @foreach ($reportData as $key => $stock)
                                @php

                                $lastPrice = Helper::lastPrice(['product_id' => $stock->product_id]);

                                if (empty($lastPrice)) {
                                $lastPrice = Helper::lastPrice2(['id' => $stock->product_id]);
                                }

                                $avgPrice = Helper::avgPrice(['product_id' => $stock->product_id]);

                                if ($avgPrice < 1) {
                                    $avgPrice=$lastPrice;
                                    }

                                    $previousPrice=Helper::previousPrice(['product_id'=> $stock->product_id]);

                                    @endphp

                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $stock->cat_name }}</td>
                                        <td>{{ $stock->product_name }}</td>
                                        <td>{{ $stock->unit_name }}</td>
                                        <td>{{ $stock->balanceinhand }}</td>

                                        <td>{{ $lastPrice }}</td>
                                        <!--   <td>{{ $previousPrice }}</td>
                                                <td>{{ $avgPrice }}</td> -->

                                        <td>{{ $stock->balanceinhand * $lastPrice }}</td>
                                    </tr>

                                    @php
                                    $grandTotal += $stock->balanceinhand * $lastPrice
                                    @endphp
                                    @endforeach
                                    @endif
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th class="text-right" colspan="6">Grand Total</th>
                                    <td>{{number_format($grandTotal,3)}} </td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!--/.col (left) -->
            <!-- right column -->
            <div class="col-md-6">

            </div>
            <!--/.col (right) -->
        </div>
        <!-- /.row -->
    </div><!-- /.container-fluid -->
</section>
<!-- /.content -->

@endsection

@push('scripts')
<script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>


<script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>

<script>
    $(function() {

        $('.select2').select2()

        $('.select2bs4').select2({
            theme: 'bootstrap4'
        })


        $("#example1").DataTable({
            "pageLength": 100,
            "responsive": true,
            "lengthChange": false,
            "autoWidth": false,
            buttons: [{
                    extend: 'excel',
                    title: 'Product List'
                },
                {
                    extend: 'pdf',
                    title: 'Product List'
                },
                {
                    extend: 'print',
                    title: 'Product List'
                },
                'colvis'
            ]

        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

        $('#example2').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });

    });
</script>
@endpush