@extends('layouts.master')

@section('page_title', 'Purchases Details')
@section('title', 'Purchases Details')
@section('main_item', 'Purchases')
@section('sub_item', 'Purchases Details')

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

        div.dataTables_filter {
            margin-top: 7px
        }
    </style>
    <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="category">Supplier</label>
                                    <select class="form-control select2" id="contact_id" name="category">
                                        <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-4">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="payment_status">Payment Status</label>
                                    <select class="form-control custom-select" id="payment_status" name="payment_status">
                                        <option value="">All</option>
                                        <option value="paid">Paid</option>
                                        <option value="due">Due</option>
                                        <option value="partial">Partial</option>
                                        <option value="returened">Returned</option>

                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="supplier">Date Range</label>
                                    <div class="input-group">
                                        <input type="text" class="form-control" name="dates-d" 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>
                <div class="card">
                    <div class="card-body">
                        @can('purchase_create')
                            <a href="{{ route('grns.create') }}">
                                <button class="btn btn-primary px-4 float-right mt-0 mb-3"><i
                                        class="mdi mdi-plus-circle-outline mr-2"></i>Add Purchase</button>
                            </a>
                        @endcan
                        <h4 class="header-title mt-0">Purchases Details</h4>
                        <div class="table-responsive dash-social">
                            <table id="laravel_datatable" class="table table-hover">
                                <thead class="thead-dark">
                                    <tr>
                                        <th>Action</th>
                                        <th>Purchase Date</th>
                                        <th>Purchase No</th>
                                        <th>Supplier</th>
                                        <th>Payment Status</th>
                                        <th>Grand Total</th>
                                        <th>Payment Due</th>
                                        <th>Quantity</th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="4" style="text-align: center"></th>
                                        <th style="font-weight: bold">Total</th>
                                        <th></th>
                                        <th></th>

                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
              
                </div>
        
            </div>
        </div>
    </div>
    <div id="add-payment" class="modal fade">

    </div>
    <div id="view_payment" class="modal fade">

    </div>
    <div id="edit-purch-payment" class="modal fade">

    </div>
@endsection

@section('scripts')
        <script>
        document.addEventListener("DOMContentLoaded", function() {
            @if(session('download_pdf'))
                window.open("{{ route('download.barcode.pdf') }}", '_blank');
            @endif
        });
    </script>
    <script>
        $(document).ready(function() {
            $("#contact_id").select2();
            report_table = $('#laravel_datatable').DataTable({
                dom: 'Blfrtip',
                lengthMenu: [
                    [25, 50, 100, -1],
                    ['25 ', '50 ', '100', 'All']
                ],
                buttons: [{
                        extend: 'copy',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6]
                        }
                    },

                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6]
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6]
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6]
                        }
                    },
                ],
                processing: false,
                serverSide: true,
                ajax: {

                    url: "{{ url('/grns') }}",
                    data: function(d) {
                        d.contact_id = $('#contact_id').val();
                        d.range = $('#reportrange').val();
                        d.payment_status = $('#payment_status').val();
                    }

                },
                "fnDrawCallback": function(oSettings) {
                    $.fn.tooltip && $('[data-toggle="tooltip"]').tooltip()
                },
                "footerCallback": function(row, data, start, end, display) {
                    var api = this.api(),
                        data;
                  
                    var intVal = function(i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                            i : 0;
                    };

                    let grand_total = api.column(5).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);


                    $(api.column(5).footer()).html(formatNumber(grand_total) + '.00')
                    let payment_due = api.column(6).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);


                    $(api.column(6).footer()).html(formatNumber(payment_due) + '.00')

                },
                columnDefs: [{
                        "targets": [0],
                        "orderable": false,
                        "searchable": false,

                    },
                    {
                        "width": "14%",
                        "targets": 2
                    },
                    {
                        "width": "14%",
                        "targets": 1
                    }
                ],

                columns: [{
                        data: 'action',
                        name: 'action'
                    },
                    {
                        data: 'grn_date',
                        name: 'grn_date'
                    },
                    {
                        data: 'ref_no',
                        name: 'ref_no'
                    },
                    {
                        data: 'contact_id',
                        name: 'contact_id'
                    },
                    {
                        data: 'payment_status',
                        name: 'payment_status'
                    },
                    {
                        data: 'grn_nettotal',
                        name: 'grn_nettotal'
                    },
                    {
                        data: 'due_payment',
                        name: 'due_payment'
                    },
                    {
                        data: 'qty',
                        name: 'qty'
                    },

                ]
            });
            $(document).on('click', '#view_history', function() {
                $('#view_payment').load($(this).data('href'), function() {
                    $('#mdate').bootstrapMaterialDatePicker({
                        weekStart: 0,
                        time: false
                    });
                    $('#view_payment').modal('show');

                })
            });
            $(document).on('click', '#add', function() {
                var today = new Date().toLocaleDateString();
                $('#add-payment').load($(this).data('href'), function() {
                    $('#mdate').bootstrapMaterialDatePicker({
                        weekStart: 0,
                        time: false
                    });
                    $('#mdate').val(moment(new Date()).format("YYYY-MM-DD"));
                    $('#add-payment').modal('show');
                })

            });
            $(document).on('click', '#update_payment', function() {
                let p_amount = $('#p_amount').val();
                let account_id = $('#account_id').val();
                let date = $('#mdate').val();
                let payment_method = $('#payment_method').val();
                let description = $('#description').val()
                let id = $('#purchase_id').val();
                let due_amount = $('#due_amount').val();
                let url = "{{ route('grns.update-payment') }}";
                $.ajax({
                    method: 'POST',
                    url: url,
                    data: {
                        "_token": "{{ csrf_token() }}",
                        'p_amount': p_amount,
                        'id': id,
                        'due_amount': due_amount,
                        'date': date,
                        'description': description,
                        'payment_method': payment_method,
                        'account_id': account_id,
                    },
                    success: function(response) {
                        if (response == 'ok') {
                            $('#add-payment').modal('hide');
                            location.reload();
                        }
                    }
                });
            });

            $(document).on('click', '.delete-grn', function(e) {
                e.preventDefault();
                var url = $(this).attr('href');
                Swal.fire({
                    title: 'Are you sure?',
                    text: "You won't be able to revert this!",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Yes, delete it!'
                }).then((result) => {
                    if (result.value) {
                        $.ajax({
                            type: "GET",
                            url: url,
                            success: function(response) {
                                if (response.success == 1) {
                                    $.toast({
                                        heading: 'Success',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#1ecab8',
                                        icon: 'success',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })

                                    report_table.ajax.reload();
                                } else {
                                    $.toast({
                                        heading: 'Error',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#f1646c',
                                        icon: 'error',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })
                                }
                            }
                        });
                    }
                })
            });

            $(document).on('click', '#edit_purch_payment', function() {
                var today = new Date().toLocaleDateString();
                $('#edit-purch-payment').load($(this).data('href'), function() {
                    $('#mdate').bootstrapMaterialDatePicker({
                        weekStart: 0,
                        time: false
                    });
                    $('#edit-purch-payment').modal('show');
                })
            });
            $(document).on('click', '.return-grn', function(e) {
                e.preventDefault();
                var url = $(this).attr('href');
                Swal.fire({
                    title: 'Are you sure?',
                    text: "You won't be able to revert this!",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Yes, return it!'
                }).then((result) => {
                    if (result.value) {
                        $.ajax({
                            type: "GET",
                            url: url,
                            success: function(response) {
                                if (response.success == 1) {
                                    $.toast({
                                        heading: 'Success',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#1ecab8',
                                        icon: 'success',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })
                                    report_table.ajax.reload();
                                } else {
                                    $.toast({
                                        heading: 'Error',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#f1646c',
                                        icon: 'error',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })
                                }
                            }
                        });
                    }
                })
            });
        });

        $(document).on('change', '#reportrange, #contact_id, #payment_status',
            function() {
                report_table.ajax.reload();
            });

        $(document).on('change', '#amount', function() {
            let paid_amount = $('#amount').val();
            let due_amount = $('#hidden_due_amount').val();
            if (Math.round(due_amount) < paid_amount) {
                Swal.fire(
                    'Warning',
                    'Paid Amount is greater than Due Amount',
                    'warning'
                )
                $('#amount').val('');
            }
        });
    </script>
@endsection