@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>
                                    @if ($setting->allow_minus_instocks == 1)<th>Stock To Reduce</th> @endif
                                    <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>
                                <!--end 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>
                                @if ($setting->allow_minus_instocks == 1)<td></td>@endif
                                <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', 'csv', {
                extend: 'pdfHtml5',
                customize: function (doc) {

                    doc.content[1].table.body.forEach(function(row, index) {
                        row.forEach(function(cell, i) {
                            cell.fontSize = 9;
                        });
                    });
                }
            }, 'print'
        ],
        processing: false,
        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'
            },
            @if ($setting->allow_minus_instocks == 1)
            {
                data: 'stock_to_reduce',
                name: 'stock_to_reduce'
            },
            @endif
            {
                data: 'u_price',
                name: 'u_price'
            },
            {
                data: 's_price',
                name: 's_price'
            },
            {
                data: 'total_cost_purchase',
                name: 'total_cost_purchase'
            },
            {
                data: 'total_cost',
                name: 'total_cost'
            },
            {
                data: 'protential_profit',
                name: 'protential_profit'
            },
            {
                data: 'stock_sold',
                name: 'stock_sold'
            },
        ],
        fnDrawCallback: function(oSettings) {
            var api = this.api();
            $('#total_stock').html(formatNumber(api.column(5, {
                page: 'current'
            }).data().sum()));
            $('#total_sold').html(formatNumber(api.column(8, {
                page: 'current'
            }).data().sum()) + '.00');
            // $('#total_cost_purchase').html(formatNumber(api.column(7, {
            //     page: 'current'
            // }).data().sum()) + '.00');
            // $('#total_cost').html(formatNumber(api.column(6, {
            //     page: 'current'
            // }).data().sum()) + '.00');
            $('#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()));
        },
    });
        })
        $(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