@extends('layouts.master')

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

@section('content')
    <style>
        div.dt-buttons {
            position: relative;
            float: right;
        }

        div.dataTables_filter {
            margin-top: 7px
        }
    </style>
    {{-- <div class="card" @if ($setting->trending_product != '1') style="display: none" @endif> --}}
    <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-4">
                                <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-4">
                                <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-4">
                                <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 class="col-md-4" hidden>
                                <form action="{{ route('stock.download') }}" method="post" target="__blank">
                                    @csrf
                                    <button type="submit" class="btn btn-success" id="export_export_image">Export Excel
                                    </button>
                                </form>
                            </div>
                        </div>
                    </div>

                </div>

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

    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="col-md-4">
                    <form action="{{ route('stock.download') }}" method="post" target="__blank">
                        @csrf
                        <button type="submit" class="btn btn-primary px-4  mt-0 mb-3" id="export_export_image"
                            style="">Export Excel </button>
                    </form>
                </div><br>
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable_stock" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>SKU</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>Re-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);">
                            <td colspan="2">Total</td>
                            <td></td>
                            <td></td>
                            <td id="total_stock"></td>
                            <td></td>
                            <td></td>
                            <td></td> 
                            <td id="total_cost_purchase"></td>
                            <td id="total_cost"></td>
                            <td id="protential_profit"></td>
                            <td id="unit_sold"></td>
                        </tfoot>
                    </table>
                </div>
            </div>
          
        </div>
      
    </div>
@endsection
@section('scripts')

    <script>
        $(document).ready(function() {
            $("#product").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', 'pdf', 'print'
                ],
                columnDefs: [
                    {
                        targets: [0],
                        width: '60px'
                    }
                ],
                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();
                        
                    },
                },
                
                columns: [      
                    {
                        data: 'sku',
                        name: 'sku'
                    },
                    {
                        data: 'product_name',
                        name: 'product_name'
                    },
                    {
                    data: 'image',
                    name: 'image',
                    },
                    {
                        data: 'attribute',
                        name: 'attribute'
                    },
                    {
                        data: 'stock',
                        name: 'stock'
                    },     
                    {
                        data: 'u_price',
                        name: 'u_price',
                        
                        searchable: false,
                        orderable: false
                    },           
                    {
                        data: 's_price',
                        name: 's_price',
                        searchable: false,
                    },
                    {
                        data: 'second_price',
                        name: 'second_price',
                        searchable: false,
                    },                                        
                    {
                        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',
                        searchable: false,
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    var api = this.api();
                    $('#total_stock').html(formatNumber(api.column(4, {
                        page: 'current'
                    }).data().sum()));
                    $('#total_cost_purchase ').html(formatNumber(api.column(8, {
                        page: 'current'
                    }).data().sum()) + '.00');
                    $('#total_cost').html(formatNumber(api.column(9, {
                        page: 'current'
                    }).data().sum()) + '.00');
                    $('#protential_profit').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',
            function() {
                stock_report_table.ajax.reload();
            });
    </script>

@endsection