@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.stockho') }}">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="formdate">From Date</label>
                                    <div class="input-group date" id="formdate" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input"
                                            data-target="#formdate" name="formdate" id="formdate"
                                            value="{{$formdate}}" placeholder="Enter From Date" required />
                                        <div class="input-group-append" data-target="#formdate"
                                            data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>

                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="todate">To Date</label>
                                    <div class="input-group date" id="todate" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input"
                                            data-target="#todate" name="todate" id="todate"
                                            value="{{$todate}}" placeholder="Enter To Date" required />
                                        <div class="input-group-append" data-target="#todate"
                                            data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>

                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="cat_id">Categories</label>
                                    <select id="cat_id" name="cat_id" class="form-control form-control-sm select2"
                                        style="width: 100%;">
                                        <option value="">Select Categories</option>
                                        @foreach ($categories as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($cat_id) && $cat_id == $v->id ? 'selected' : '' }}>
                                            {{ $v->id }} - {{ $v->cat_name }}
                                        </option>
                                        @endforeach

                                    </select>

                                </div>
                            </div>
                            <div class="col-sm-4">
                                <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-4">
                                <button type="submit" style="margin-top: 30px;" class="btn btn-sm btn-primary btn_mt">Search</button>
                                <a href="{{ route('report.stockho') }}" style="margin-top: 30px;"
                                    class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                            </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">Inventory Movement 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>OP. Stock</th>
                                    <th>Pur. Qty</th>
                                    <th>Usage Qty</th>
                                    <th>Clo. Qty</th>
                                    <th>HO Balance</th>
                                    <th>Difference</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                $sl = 1;
                                $totalOpening = 0;
                                $totalPurchase = 0;
                                $totalUsage = 0;
                                $totalClosing = 0;
                                $totalHoBalance = 0;
                                $totalDifference = 0;
                                @endphp
                                @foreach ($reportData as $stock)
                                @php
                                $totalOpening += $stock->opening_qty;
                                $totalPurchase += $stock->purchase_qty;
                                $totalUsage += $stock->usage_qty;
                                $totalClosing += $stock->closing_qty;
                                $totalHoBalance += $stock->ho_balance;
                                $totalDifference += $stock->difference;
                                @endphp
                                <tr>
                                    <td>{{ $sl++ }}</td>
                                    <td>{{ $stock->cat_name }}</td>
                                    <td>{{ $stock->product_name }}</td>
                                    <td>{{ $stock->opening_qty }}</td>
                                    <td>{{ $stock->purchase_qty }}</td>
                                    <td>{{ $stock->usage_qty }}</td>
                                    <td>{{ $stock->closing_qty }}</td>
                                    <td>{{ $stock->ho_balance }}</td>
                                    {{-- ✅ highlight difference --}}
                                    <td class="{{ $stock->difference != 0 ? 'text-danger font-weight-bold' : 'text-success' }}">
                                        {{ $stock->difference }}
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="3">Total</th>
                                    <th>{{ $totalOpening }}</th>
                                    <th>{{ $totalPurchase }}</th>
                                    <th>{{ $totalUsage }}</th>
                                    <th>{{ $totalClosing }}</th>
                                    <th>{{ $totalHoBalance }}</th>
                                    <th>{{ $totalDifference }}</th>
                                </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({
            responsive: true,
            lengthChange: true,
            autoWidth: false,
            pageLength: 50,
            buttons: [{
                    extend: 'excelHtml5',
                    title: 'Inventory Movement Report',
                    footer: true,
                    exportOptions: {
                        columns: ':visible',
                        modifier: {
                            page: 'all'
                        }
                    }
                },
                {
                    extend: 'pdfHtml5',
                    title: 'Inventory Movement Report',
                    footer: true, // ✅ include footer totals
                    exportOptions: {
                        columns: ':visible',
                        modifier: {
                            page: 'all'
                        }
                    },
                    orientation: 'landscape', // ✅ horizontal layout
                    pageSize: 'A4', // ✅ better for wide tables
                    customize: function(doc) {
                        // Optional styling improvements for PDF
                        doc.styles.tableHeader.fontSize = 9;
                        doc.styles.tableBodyEven.fontSize = 8;
                        doc.styles.tableBodyOdd.fontSize = 8;
                        doc.styles.tableFooter = {
                            bold: true,
                            fontSize: 9,
                            alignment: 'right'
                        };
                        doc.content[1].table.widths = Array(doc.content[1].table.body[0].length + 1)
                            .join('*')
                            .split('');
                    }
                },
                {
                    extend: 'print',
                    title: 'Inventory Movement Report',
                    footer: true,
                    exportOptions: {
                        columns: ':visible',
                        modifier: {
                            page: 'all'
                        }
                    }
                },
                'colvis'
            ]
        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');



        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false, // 👈 Hide dropdown (fixed 50 rows)
            "searching": false,
            "ordering": true,
            "autoWidth": false,
            "responsive": true,
            "pageLength": 50 // 👈 Always show 50
        });

    });

    $(function() {



        $('#formdate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('#todate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('.select2').select2()

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


        $("#print_div").click(function(e) {
            e.preventDefault();

            printSlip();


        });
    })
</script>
@endpush