@extends('layouts.master')

@section('page_title', 'Stock Report')
@section('title', 'Stock Report')
@section('main_item', 'Reports')
@section('sub_item', 'Stock Report')

@section('content')

    <div class="col-12">
        <div class="card">
            <div id="accordion">

                <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse"
                    data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                    <h4 class="mb-0 header-title">
                        Filter
                    </h4>
                </div>


                <div id="collapseOne" class="collapse show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-3" @if ($setting->business_location != '1') style="display: none" @endif>
                                <div class="form-group">
                                    <label class="required" style="font-weight: bold">business Location</label>
                                    <select class="form-control select2" id="business_location_id"
                                        name="business_location_id">
                                        <option value="">All</option>
                                        @if (Auth::user()->role_id == '1')
                                            @foreach ($users_access_location as $business_location)
                                                @if ($business_location->is_active == '1')
                                                    <option value="{{ $business_location->id }}">
                                                        {{ $business_location->name }}
                                                    </option>
                                                @else
                                                @endif
                                            @endforeach
                                        @else
                                            @foreach ($users_access_location as $business_location)
                                                @if ($business_location->is_active == '1')
                                                    <option value="{{ $business_location->business_location_id }}">
                                                        {{ $business_location->name }}
                                                    </option>
                                                @else
                                                @endif
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="product">Product</label>
                                    <select class="form-control select2" id="product" name="product">
                                        <option value="" selected>All</option>
                                        @foreach ($products as $product)
                                            <option value="{{ $product->id }}">{{ $product->product_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="category">Category</label>
                                    <select class="form-control select2" id="product_list_filter_category_id"
                                        name="category">
                                        <option value="" selected>All</option>
                                        @foreach ($categories as $category)
                                            <option value="{{ $category->id }}">{{ $category->category_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="unit">Unit</label>
                                    <select class="form-control select2" id="product_list_filter_unit_id" name="unit">
                                        <option value="">All</option>
                                        @foreach ($units as $unit)
                                            <option value="{{ $unit->id }}">
                                                {{ $unit->actual_name . ' (' . $unit->short_name . ')' }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-12">
        <div class="card">
            <div class="card-body">
    <form action="{{ route('stock.download') }}" method="post" target="__blank">
        @csrf
       
        <div class="table-responsive dash-social">
            <table id="laravel_datatable_stock" class="table table-hover">
                <thead class="thead-dark">
                    <tr>
                        <th>SKU</th>
                        <th>Business Location</th>
                        <th>Product Name</th>
                        <th>Product Image</th>
                        <th style="text-align: center;">Attribute <br> value And Qty</th>
                        <th>Current Stock</th>
                        <th>Purchase Price</th>
                        <th>Selling Price</th>
                        <th>Current Stock Value <br> (by purchase price)</th>
                        <th>Current Stock Value <br> (by sale price)</th>
                        <th>Potential Profit</th>
                        <th>Total Unit Sold</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
                <tfoot style="background:rgb(232, 232, 232);">
                    <tr>
                        <td colspan="3">Total</td>
                        <td></td>
                        <td></td>
                        <td id="total_stock"></td>
                        <td id="total_cost"></td>
                        <td id="total_cost_purchase"></td>
                        <td id="total_sold"></td>
                        <td id="stock_value"></td>
                        <td id="stock_cost"></td>
                        <td id="unit_sold"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </form>
</div>

            <!--end card-body-->
        </div>
        <!--end card-->
    </div>
@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            $("#product").select2();
            $("#location_id").select2();
            $("#product_list_filter_category_id").select2();
            $("#product_list_filter_unit_id").select2();

            stock_report_table = $('#laravel_datatable_stock').DataTable({
                dom: 'Blfrtip',
                lengthMenu: [
                    [25, 50, 100, -1],
                    ['25 ', '50 ', '100', 'All']
                ],
                buttons: [
                    'copy', 
                    'excel', 
                    //pdf formatting
                    {
                        extend: 'pdfHtml5',
                        customize: function (doc) {
                            doc.pageSize = 'A4';
                            doc.pageOrientation = 'landscape';
                            doc.content[1].table.body.forEach(function(row, index) {
                                row.forEach(function(cell, colIndex) {
                                    cell.fontSize = 9;
                                    //format the attribute column
                                    if (colIndex === 4) {
                                        const formattedText = cell.text.split('  ').join('\n');
                                        cell.text = formattedText;
                                    }
                                    //format the selling price and unit price column
                                    if (colIndex === 6 || colIndex === 7) { 
                                        const formattedText = cell.text.split(' ').join('\n');
                                        cell.text = formattedText;
                                    }
                                });
                            });
                        }
                    },  
                    'print'
                ],
                processing: true,
                serverSide: true,
                "autoWidth": false,
                ajax: {
                    url: "{{ url('/reports/stocks') }}",
                    data: function(d) {
                        d.category_id = $('#product_list_filter_category_id').val();
                        d.unit_id = $('#product_list_filter_unit_id').val();
                        d.product = $('#product').val();
                        d.business_location_id = $('#business_location_id').val();
                    },
                },
                columnDefs: [
                {
                    "targets": "_all",
                    "createdCell": function(td, cellData, rowData, row, col) {
                        $(td).css('vertical-align', 'top');
                    }
                }],
                columns: [{
                        data: 'sku',
                        name: 'sku'
                    },
                    {
                        data: 'location_id',
                        name: 'location_id'
                    },
                    {
                        data: 'product_name',
                        name: 'product_name'
                    },
                    {
                        data: 'image',
                        name: 'image'
                    },
                    {
                        data: 'attribute',
                        name: 'attribute'
                    },
                    {
                        data: 'stock',
                        name: 'stock'
                    },
                    {
                        data: 'u_price',
                        name: 'u_price'
                    },
                    {
                        data: 's_price',
                        name: 's_price'
                    },

                    {
                        data: 'total_cost_purchase',
                        name: 'total_cost_purchase',
                        searchable: false
                    },
                    {
                        data: 'total_cost',
                        name: 'total_cost',
                        searchable: false
                    },
                    {
                       data: 'protential_profit',
                        name: 'protential_profit',
                        searchable: false
                    },
                    {
                        data: 'stock_sold',
                        name: 'stock_sold'
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    var api = this.api();
                    $('#total_stock').html(formatNumber(api.column(5, {
                        page: 'current'
                    }).data().sum()));

                    $('#stock_value').html(formatNumber(api.column(9, {
                        page: 'current'
                    }).data().sum()) + '.00');
                    
                    $('#stock_cost').html(formatNumber(api.column(10, {
                        page: 'current'
                    }).data().sum()) + '.00');
                    
                    $('#unit_sold').html(formatNumber(api.column(11, {
                        page: 'current'
                    }).data().sum()));

                    // Add summing logic for potential_profit column (column 10)
                    $('#total_profit').html(formatNumber(api.column(10, {
                        page: 'current'
                    }).data().sum()) + '.00');
                },
            });
        })
        $(document).on('change',
            '#product_list_filter_category_id, #product_list_filter_unit_id, #product, #business_location_id',
            function() {
                stock_report_table.ajax.reload();
            });
    </script>

@endsection