@extends('layouts.master')

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

@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">

                    <form action="{{ url('grns/new/page') }}" method="get" id="filter_form">
                        <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" for="activate_code">Business Location</label>
                                    <select class="form-control select2" id="location_id" name="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>
                                        @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>
                                        @endif
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="contact_id">Supplier</label>
                                    <select class="form-control select2" id="contact_id" name="contact_id">
                                        <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">
                                <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-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="dates-d">Date Range</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>
                        <input type="hidden" name="data_type" id="data_type" value="">

                        <div class="row">
                            <div class="col-md-12">
                                <button type="submit" class="btn btn-primary">Filter</button>
                                <a href="{{ url('grns/new/page') }}" class="btn btn-danger px-5 py-2">Reset</a>
                            </div>
                        </div>
                    </form>

                </div>
                <!--end card-body-->
            </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 --}}
            <div>
                        <a href="{{ url('grns/new/page') }}" class="btn btn-primary float-right px-5 py-2 submit-filters" data-type="excel" style="margin-right: 10px" ;>Download
                            Excel</a>

                    </div>
            <h4 class="header-title mt-0">Purchases Details</h4>
            <div class="table-responsive dash-social">
                <table id="laravel_datatable1" class="table table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>Action</th>
                            <th>Purchase Date</th>
                            <th>Business Location</th>
                            <th>Purchase No</th>
                            <th>Supplier</th>
                            <th>Payment Status</th>
                            <th>Grand Total</th>
                            <th>Payment Due</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                        $totalGrand = 0;
                        $totalDue = 0;
                        @endphp
                        @foreach($grns as $grn)
                        @php
                        $due_amount = $grn->grn_nettotal - \App\PurchasePayment::where('purchase_id', $grn->id)->sum('paid_amount');
                        $totalGrand += $grn->grn_nettotal;
                        $totalDue += $due_amount;
                        @endphp
                        <tr>
                            <td>
                                <div class="dropdown">
                                    <button class="btn btn-secondary dropdown-toggle" type="button" id="dropdownMenu2" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                        Action
                                    </button>
                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                        <a href="{{ url('grns/' . $grn->id) }}" class="dropdown-item"><i class="fas fa-eye text-primary font-16"></i> View</a>
                                        @can('purchase_edit')
                                        @if($grn->payment_status != 'returened')
                                        <a href="{{ url('grn/' . $grn->id . '/edit') }}" class="dropdown-item"><i class="fas fa-edit text-success font-16"></i> Edit</a>
                                        <a href="javascript:void(0)" id="add" data-href="{{ url('grns/' . $grn->id . '/add') }}" class="dropdown-item"><i class="fas fa-plus-circle text-dark font-16"></i> Payment Update</a>
                                        <a href="{{ url('grn/' . $grn->id . '/return') }}" class="dropdown-item return-grn"><i class="fas fa-undo text-warning font-16"></i> Return</a>
                                        <a href="javascript:void(0)" id="view_history" class="dropdown-item" data-href="{{ route('grn.view_payment', $grn->id) }}"><i class="fa fa-eye text-info font-16"></i> View Payment</a>
                                        @endif
                                        @endcan
                                        <a href="{{ url('grns/' . $grn->id . '/print') }}" class="dropdown-item"><i class="fas fa-print text-purple font-16"></i> Print</a>
                                        @can('purchase_delete')
                                        <a href="{{ url('grns/' . $grn->id . '/delete') }}" class="dropdown-item delete-grn"><i class="fas fa-trash-alt text-danger font-16"></i> Delete</a>
                                        @endcan
                                    </div>
                                </div>
                            </td>
                            <td>{{ Carbon\Carbon::parse($grn->grn_date)->format('Y-m-d') }}</td>
                            <td>{{ $grn->business_location_name ?? 'N/A' }}</td>
                            <td>{{ $grn->ref_no }}</td>
                            <td>{{ $grn->supplier->business_name ?? 'N/A' }}</td>
                            <td>
                                @if ($grn->payment_status == 'due')
                                <span class="badge badge-warning">N/Paid</span>
                                @elseif ($grn->payment_status == 'paid')
                                <span class="badge badge-success">Paid</span>
                                @elseif ($grn->payment_status == 'returened')
                                <span class="badge badge-danger">Returned</span>
                                @else
                                <span class="badge badge-info">Partial</span>
                                @endif
                            </td>
                            <td>{{ number_format($grn->grn_nettotal, 2) }}</td>
                            <td>{{ number_format($due_amount, 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="5" style="text-align: center"></th>
                            <th style="font-weight: bold">Total</th>
                            <th>{{ number_format($totalGrand, 2) }}</th>
                            <th>{{ number_format($totalDue, 2) }}</th>
                        </tr>
                    </tfoot>
                </table>
                <div class="d-flex justify-content-end">
                    {{ $grns->appends($_GET)->links() }}
                </div>
                <div>
                    Showing {{ $grns->firstItem() }} to {{ $grns->lastItem() }} of
                    {{ $grns->total() }}
                    entries
                    </span>
                </div>
            </div>
        </div>

        <!--end card-body-->
    </div>
    <!--end card-->
</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).ready(function() {
        $("#contact_id").select2();
        $("#location_id").select2();
        $('#reportrange').val('')
        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.location_id = $('#location_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;
                // converting to interger to find total
                var intVal = function(i) {
                    return typeof i === 'string' ?
                        i.replace(/[\$,]/g, '') * 1 :
                        typeof i === 'number' ?
                        i : 0;
                };

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


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


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

            },
            columnDefs: [{
                    "targets": [0],
                    "orderable": false,
                    "searchable": false,
                },
                {
                    "targets": [],
                    "orderable": false,
                    "searchable": false,
                    "visible": false,
                },
                {
                    "width": "14%",
                    "targets": 2
                },
                {
                    "width": "14%",
                    "targets": 1
                }
            ],

            columns: [{
                    data: 'action',
                    name: 'action'
                },
                {
                    data: 'grn_date',
                    name: 'grn_date'
                },
                {
                    data: 'location_id',
                    name: 'location_id'
                },
                {
                    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'
                },

            ]
        });
        $(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() {

            var clicks = 0;
            $('#update_payment').click(function() {
                clicks++;
                if (clicks === 2) {
                    $(this).prop('disabled', true);
                }
            });

            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, #location_id',
        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('');
        }
    });
    $(document).on('click', '.submit-filters', function(e) {
        e.preventDefault()
        let data_type = $(this).data('type');
        $('#data_type').val(data_type);
        $('#filter_form').submit();

    });
</script>
@endsection