@extends('layouts.master')

@section('page_title', 'Product Summary')
@section('title', 'Product Summary')
@section('main_item', 'Reports')
@section('sub_item', 'Product Summary')

@section('content')

<style>
    th.sort {
        color: white;
    }
    th.sort:hover {
        color: blue;
    }
</style>

<div class="col-12">
    <div class="card">
        <div class="card-header bg-white">
            <h4 class="mb-0 header-title">Filter</h4>
        </div>
        <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 custom-select" 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="category">Supplier</label>
                        <select class="form-control select2" id="supplier_id" name="supplier">
                            <option value="" selected>All</option>
                            @foreach ($suppliers as $supplier)
                                <option value="{{ $supplier->id }}">{{ $supplier->business_name }} |
                                    {{ $supplier->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-3">
                    <label><b>Date</b></label>
                    <div class="input-group">
                        <input type="text" class="form-control" name="range" id="reportrange" readonly>
                        <div class="input-group-append">
                            <span class="input-group-text"><i class="dripicons-calendar"></i></span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- DataTable -->
<div class="col-12">
    <div class="card">
        <div class="card-body">

            <button class="btn btn-primary px-3 float-right mt-0 mb-3" data-toggle="modal"
                        data-animation="bounce" id="add_bulk"
                        style="transform: translate(-10px);" href="javascript:void(0)">
                        <i class="fas fa-plus-circle px-2"></i>Bulk Purchase Order</button>

            <div class="table-responsive">
                <table id="product-summary-table" class="table table-striped table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>
                                <input type="checkbox" class="check_all" id="multiple-select">
                            </th>
                            <th>Action</th>
                            <th>SKU</th>
                            <th>Product Name</th>
                            <th>Location</th>
                            <th>Supplier</th>
                            <th>Sale Date</th>
                            <th>Total Order Qty</th>
                            <th>Total Purchased Qty</th>
                            <th>Blance Qty</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>
</div>

@endsection

@section('scripts')
<script>
$(document).ready(function() {
    let table = $('#product-summary-table').DataTable({
        dom: 'Blfrtip',
        lengthMenu: [
            [25, 50, 100, -1],
            ['25 ', '50 ', '100', 'All']
        ],
        buttons: [
            {
                extend: 'copy',
                exportOptions: {
                    columns: [2,3,4,5]
                }
            },
            {
                extend: 'excel',
                exportOptions: {
                    columns: [2,3,4,5]
                }
            },
            {
                extend: 'pdf',
                exportOptions: {
                    columns: [2,3,4,5]
                }
            },
            {
                extend: 'print',
                exportOptions: {
                    columns: [2,3,4,5]
                }
            },
        ],
        processing: true,
        serverSide: true,
        ajax: {
            url: "{{ route('sale_product_summary') }}",
            data: function(d) {
                d.range = $('#reportrange').val();
                d.location = $('#business_location_id').val();
                d.supplier_id = $('#supplier_id').val();
            }
        },
        columnDefs: [{ 
            "targets": [0],
            "orderable": false,
            "searchable": false 
        }],
        columns: [
            { data: 'checkbox', name: 'checkbox' }, 
            { data: 'action', name: 'action' },
            { data: 'sku', name: 'sku' },
            { data: 'product_name', name: 'product_name' },
            { data: 'location', name: 'location' },
            { data: 'supplier', name: 'supplier' },
            { data: 'sale_date', name: 'sale_date' },
            { data: 'qty', name: 'qty' },
            { data: 'purchased_qty', name: 'purchased_qty' },
            { data: 'balance_qty', name: 'balance_qty' },
        ]
    });
    $('#reportrange, #business_location_id, #supplier_id').on('change', function() {
        table.ajax.reload();
    });

    $(document).on('click', '#multiple-select', function() {
        $('.check-multiple').prop('checked', $(this).prop('checked'));
    });

    $('#add_bulk').on('click', function() {
        let selectedProducts = [];
        let quantities = [];
        let dates = [];
        let locations = [];
        let sale_item_ids = [];
        let invalidQty = false;

        $('.check-multiple:checked').each(function() {
            let productId = $(this).val().split('|')[0];
            let date = $(this).val().split('|')[2];
            let locationId = $(this).closest('tr').find('.location-col').data('location-id');
            let qty = $(this).closest('tr').find('td:eq(9)').text();
            // If qty negative or zero
            if (qty < 1 || isNaN(qty)) {
                invalidQty = true;
            }
            // same product in same location 
            let productIndex = selectedProducts.findIndex(item => item.productId === productId && item.locationId === locationId);

            if (productIndex !== -1) {
                quantities[productIndex] += parseInt(qty);
            } else {
                selectedProducts.push({ productId: productId, locationId: locationId });
                quantities.push(parseInt(qty));
                locations.push(locationId);
                dates.push(date);
            }
        });


    if (invalidQty) {
        $.toast({
            heading: 'Error',
            text: 'Quantities must be greater than zero!',
            position: 'top-right',
            bgColor: '#f1646c',
            icon: 'error',
            showHideTransition: 'fade',
            loaderBg: '#ecf0f1',
        });
        return;
    }
        // If no product is selected
        if (selectedProducts.length === 0) {
            Swal.fire(
                    'Warning',
                    'Please select at least one product',
                    'warning'
            );
            return;
        }
        
        let supplierId = $('#supplier_id').val();
        if (!supplierId) {
            Swal.fire(
                'Warning',
                'Please filter by supplier',
                'warning'
            );
            return;
        }

        let productIds = selectedProducts.map(item => item.productId);
        let locationsList = selectedProducts.map(item => item.locationId);

        $.ajax({
            url: "{{ route('purchase.bulk-create') }}",
            method: "POST",
            data: {
                product_ids: productIds,
                contact_id: supplierId,
                location_id: locationsList,
                quantities: quantities,
                dates: dates,
                _token: "{{ csrf_token() }}"
            },
            success: function(response) {
            if (response.success === 1) {
                $.toast({
                    heading: 'Success',
                    text: response.message,
                    position: 'top-right',
                    bgColor: '#1ecab8',
                    icon: 'success',
                    showHideTransition: 'fade',
                    loaderBg: '#ecf0f1',
                });
                setTimeout(function() {
                    if (response.redirect_url) {
                        window.location.href = response.redirect_url;
                    }
                }, 1000);
            } else {
                $.toast({
                    heading: 'Error',
                    text: response.msg,
                    position: 'top-right',
                    bgColor: '#f1646c',
                    icon: 'error',
                    showHideTransition: 'fade',
                    loaderBg: '#ecf0f1'
                });
            }
        },
    });
});

    //if qty is less than 1 then not allowed for purchasing
    $(document).on('click', '.add-purchase-orde', function() {
        let qty = $(this).closest('tr').find('td:eq(9)').text();
        if (qty < 1 || isNaN(qty)) {
            $.toast({
            heading: 'Error',
            text: 'Quantities must be greater than zero!',
            position: 'top-right',
            bgColor: '#f1646c',
            icon: 'error',
            showHideTransition: 'fade',
            loaderBg: '#ecf0f1',
        });
        return false;

        }
    });
});
</script>
@endsection