@extends('layouts.master')
@section('css')
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" type="text/css" />
    <link href="{{ URL::asset('assets/libs/sweetalert2/sweetalert2.min.css') }}" rel="stylesheet" type="text/css" />
    <style>
        .details {
            font-size: 15px;
        }

        .bg-color {
            background-color: #e9edfa;
            margin: auto;
            padding: 1em 0 0.1em 0;
            border-radius: 6px;
            margin-bottom: 10px;
        }
    </style>
@endsection
@section('title')
   Stock Item Cost Allocation
@endsection
@section('content')
    <div class="card">
        <div class="card-header">
            <div class="col-lg-12 d-flex align-items-center">
                <h4 class="card-title mb-0 flex-grow-1">Stock Item Cost Allocation</h4>
            </div>
        </div>
    <form action="/admin/opening-stock-cost-allocation-store/{{ $stockItem->id }}/{{ $stockItemLocation->id }}" method="post" id="cost_allocation_form">
        @csrf
        <div class="card-body">
            <div class="row">
                <div class="col-md-2">
                    <label for="">Item Name</label>
                    <input type="text" class="form-control" name="item_name" id="item_name"
                        value="{{ $stockItem->name }}" readonly>
                </div>
                <div class="col-md-2">
                    <label for="">Opening Stock</label>
                    <input type="text" class="form-control" name="opening_stock" id="opening_stock"
                        value="{{ $stockItemLocation->opening_stock }}-{{ $stockItemLocation->unit->symbol }}" readonly>
                </div>
                <div class="col-md-2">
                    <label for="">Landed Cost</label>
                    <input type="text" class="form-control" name="landing_value" id="landing_value"
                        value="{{ $stockLedger->landing_value }}" readonly>
                </div>
                <div class="col-md-2">
                    <label for="">New Landing Cost</label>
                    <input type="text" class="form-control" name="new_landing_value" id="new_landing_value"
                        value="" readonly>
                </div>
            </div>
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-header d-flex align-items-center">
                        <h5 class="card-title mb-0 flex-grow-1 text-center">
                            Other Expenses
                        </h5>
                    </div>
                        <div class="card-body">
                            <div class="row mb-3">
                                <div class="table-responsive">
                                    <table class="table table-responsive">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Ledger Dr</th>
                                                <th>Ledger Cr</th>
                                                <th>Amount</th>
                                                <th>Remarks</th>
                                                <th></th>
                                            </tr>
                                        </thead>
                                        <tbody id="otherExpensesRow">
                                            @foreach ($addedExpenses as $key => $costAllocatedJournal)
                                                <tr id="{{ $key + 1 }}"
                                                    class="expense-row_{{ $key + 1 }} expense-row">
                                                    <td class="text-center">{{ $key + 1 }}<input type="hidden" name="journal_id[]" value="{{ $costAllocatedJournal->accounting_voucher_id }}"></td>
                                                    <td>Voucher No : {{ $costAllocatedJournal->accountingVoucher->voucher_number }} Voucher Date : {{ date('d-m-Y', strtotime($costAllocatedJournal->accountingVoucher->voucher_date)) }} <br>
                                                        <select name="dr_ledger[]" class="form-control dr_ledger"
                                                            id="dr_ledger_{{ $key + 1 }}" required
                                                            onchange="drLedgerChange({{ $key + 1 }})">
                                                            <option value="">Select Ledger</option>
                                                            @if($costAllocatedJournal->accountingVoucher->debitLedger)
                                                                <option value="{{ $costAllocatedJournal->accountingVoucher->debitLedger->id }}" selected>{{ $costAllocatedJournal->accountingVoucher->debitLedger->name }}</option>
                                                            @endif
                                                        </select>
                                                        <input type="hidden" class="dr_ledger_group" name="dr_ledger_group[]"
                                                            id="dr_ledger_group_{{ $key + 1 }}">
                                                    </td>
                                                    <td><select name="cr_ledger[]" class="form-control cr_ledger"
                                                            id="cr_ledger_{{ $key + 1 }}">
                                                            <option value="" required>Select Ledger</option>
                                                            @if($costAllocatedJournal->accountingVoucher->creditLedger)
                                                                <option value="{{$costAllocatedJournal->accountingVoucher->creditLedger->id }}" selected>{{$costAllocatedJournal->accountingVoucher->creditLedger->name }}</option>
                                                            @endif
                                                        </select>
                                                    </td>
                                                    <td><input type="number" class="form-control expense_amount"
                                                            name="expense_amount[]" value="{{  $costAllocatedJournal->amount }}"  required></td>
                                                    <td><input type="text" class="form-control expense_remarks"
                                                            name="expense_remarks[]" value="{{  $costAllocatedJournal->accountingVoucher->remarks }}"></td>
                                                    <td><button type="button" class="btn btn-sm btn-danger"
                                                            onclick="removeExpenseRow({{ $key + 1 }})"><i
                                                                class="las la-minus"></i></td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td id="total_expense" class="fw-bold text-center">0.0</td>
                                                <td></td>
                                                <td></td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                                <hr>
                                <div class="table-responsive">
                                    <table class="table table-responsive w-75">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th> Journal/Payment Voucher</th>
                                                <th>Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody id="journalRowBody">
                                             @foreach ($addedJournals as $key => $costAllocatedJournal)
                                                <tr id="{{$loop->iteration }}" class="journal-row_{{ $loop->iteration }} journal-row">
                                                      <td class="text-center">{{ $loop->iteration }}</td>
                                                     <td>
                                                        @php
                                                            $rowId = $loop->iteration;
                                                                $name ='';
                                                                $details = \App\Models\AccountingVoucherDetails::where('accounting_voucher_id',$key)->where('dr_or_cr','dr')->get();
                                                                foreach ($details as $value) {
                                                                $name .= $value->ledger->name.':' .$value->amount.'|';
                                                                }
                                                                $accountingVoucher = \App\Models\AccountingVoucher::find($key);
                                                                @endphp
                                                                <select name="accounting_vouchers[]" class="form-control accounting_vouchers" id="accounting_vouchers_{{ $loop->iteration }}" required onchange="fetchAccountingVoucher({{ $loop->iteration }})">
                                                                    <option value="">Select Accounting Voucher</option>
                                                                    @if($accountingVoucher)
                                                                    <option value="{{ $accountingVoucher->id }}" selected>{{ $accountingVoucher->voucher_number }} - {{ $accountingVoucher->voucher_date  }}| {{ $name }}</option>
                                                                    @endif
                                                                </select>
                                                        </td>
                                                    <td></td>
                                                    <td><button type="button" class="btn btn-sm btn-danger" onclick="removeJournalRow({{$loop->iteration }})"><i class="las la-minus"></i></td>
                                                 </tr>
                                                 @foreach($costAllocatedJournal as $journal)
                                                        <tr id="journal-sub-row_{{  $journal->accounting_voucher_id }}" class="journal-sub-row" data-id="{{ $rowId }}"><td></td>
                                                        <td><input hidden name="accounting_voucher_id[]" value="{{ $journal->accounting_voucher_id }}"><input hidden name="ledger_id[]" value="{{ $journal->ledger_id }}">{{ $journal->ledger->name }}</td>
                                                        <td><input type="number" name="amount[]" class="form-control journal_expense_amount" value="{{ $journal->amount }}"></td>
                                                        <td><button type="button" class="btn btn-sm btn-danger " onclick="removeJournalSubRow({{ $journal->accounting_voucher_id }})"><i class="las la-minus"></i></button></td></tr>
                                                 @endforeach
                                            @endforeach
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <td></td>
                                                <td></td>
                                                <td id="journal_total_expense" class="fw-bold text-center">0.0</td>
                                                <td></td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                            <div id="source-add-row" class="row firsthidden_rows text-end ">
                                <div class="col-md-12 text-right">
                                    <button type="button" class="btn btn-info al-pdng-btm" onclick="appendJournal()"
                                        id="add-expense-row"><i class="las la-plus"></i>Choose Journal/Payment</button type="button">
                                    <button type="button" class="btn btn-info al-pdng-btm" onclick="appendExpenseRow()"
                                        id="add-expense-row"><i class="las la-plus"></i>Add Expense</button type="button">
                                    <button type="submit" id="submit-btn"
                                        class="btn btn-primary al-pdng-btm">Submit</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.5/jquery.validate.min.js"
        integrity="sha512-rstIgDs0xPgmG6RX1Aba4KV5cWJbAMcvRCVmglpam9SoHZiUCyQVDdH2LPlxoHtrv17XWblE/V/PP+Tr04hbtA=="
        crossorigin="anonymous" referrerpolicy="no-referrer"></script>
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="{{ URL::asset('/assets/libs/sweetalert2/sweetalert2.min.js') }}"></script>
    <script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
    <script>
        $(document).ready(function() {

              calculateExpenseSum();
            $('.cr_ledger').select2({
                placeholder: 'Select Ledger',
                ajax: {
                    url: "/admin/get-ledgers",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                        var results = data.data.map(function(item) {
                            var name = item.description != null ? item.name + ' (' + item
                                .description +
                                ')' : item.name;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });
             $('.accounting_vouchers').select2({
                placeholder: 'Select Accounting Voucher',
                ajax: {
                    url: "/admin/get-journal",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                        var results = data.data.map(function(item) {
                          var crDetails = item.details.map(function(detail) {
                            return detail.ledger?.name + ': ' + detail.amount;
                        }).join(', ');

                        var name = item.voucher_number + ' - ' + item.voucher_date + ' | ' + crDetails;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });
            $('.dr_ledger').select2({
                placeholder: 'Select Ledger',
                ajax: {
                    url: "/admin/get-expense-debit-ledgers",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                        var results = data.data.map(function(item) {
                            var name = item.description != null ? item.name + ' (' + item
                                .description +
                                ')' : item.name;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });
        });

        function appendExpenseRow() {
            var rowCount = $('#otherExpensesRow tr:last').attr('id');
            if (rowCount == "" || rowCount == undefined) {
                rowCount = 1;
            } else {
                rowCount = parseInt(rowCount) + parseInt(1);
            }

            var rows = '<tr id="' + rowCount + '" class="expense-row_' + rowCount +
                ' expense-row">';
            rows += '<td class="text-center">' + rowCount + '</td>';
            rows += '<td><select name="dr_ledger[]" class="form-control dr_ledger" id="dr_ledger_' + rowCount +
                '" required onchange="drLedgerChange(' + rowCount +
                ')"><option value="">Select Ledger</option></select><input type="hidden" class="dr_ledger_group" name="dr_ledger_group[]" id="dr_ledger_group_' +
                rowCount + '"></td>';
            rows += '<td><select name="cr_ledger[]" class="form-control cr_ledger" id="cr_ledger_' + rowCount +
                '"><option value="" required>Select Ledger</option></select></td>';
            rows += '<td><input type="number" class="form-control expense_amount" name="expense_amount[]"></td>';
            rows += '<td><input type="text" class="form-control expense_remarks"   name="expense_remarks[]"></td>';
            rows += '<td><button type="button" class="btn btn-sm btn-danger" onclick="removeExpenseRow(' + rowCount +
                ')"><i class="las la-minus"></i></td>';
            rows += '</tr>';
            $('#otherExpensesRow').append(rows);
            $('#cr_ledger_' + rowCount).select2({
                placeholder: 'Select Ledger',
                ajax: {
                    url: "/admin/get-ledgers",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                        var results = data.data.map(function(item) {
                            var name = item.description != null ? item.name + ' (' + item.description +
                                ')' : item.name;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });
            $('#dr_ledger_' + rowCount).select2({
                placeholder: 'Select Ledger',
                ajax: {
                    url: "/admin/get-expense-debit-ledgers",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                        var results = data.data.map(function(item) {
                            var name = item.description != null ? item.name + ' (' + item.description +
                                ')' : item.name;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });
            calculateExpenseSum();
        }
        $(document).on('keyup', '.expense_amount,.journal_expense_amount', function() {
            calculateExpenseSum();
        })

        function drLedgerChange(id) {
            var ledger = $('#dr_ledger_' + id).val();
            if (ledger != null) {
                $.ajax({
                    url: "/admin/get-ledger-group",
                    type: "POST",
                    data: {
                        _token: "{{ csrf_token() }}",
                        ledger: ledger,
                    },
                    success: function(response) {
                        $('#dr_ledger_group_' + id).val(response.data);
                        calculateExpenseSum();
                    }
                })
            }
        }

        function calculateExpenseSum() {
            var sum = 0;
            $('.expense_amount').each(function() {
                var value = $(this).val();
                if (!isNaN(value) && value.length != 0) {
                    sum += parseFloat(value);
                }
            });
            $('#total_expense').text(sum);
            $old_landed_cost = parseFloat($('#landing_value').val()) || 0;
            $newLandingCost = sum + $old_landed_cost;
            $('#new_landing_value').val($newLandingCost);

            var journalSum = 0;
              $('.journal_expense_amount').each(function() {
                var value = $(this).val();
                if (!isNaN(value) && value.length != 0) {
                    journalSum += parseFloat(value);
                }
            });
            $('#journal_total_expense').text(journalSum);
            $newLandingCost = $newLandingCost + journalSum;
            $('#new_landing_value').val($newLandingCost);

        }

        function removeExpenseRow(id) {
            $(".expense-row_" + id).remove();
            calculateExpenseSum();
        }
        function removeJournalSubRow(id) {
            $("#journal-sub-row_" + id).remove();
            calculateExpenseSum();
        }
        function appendJournal() {
            var rowCount = $('#journalRowBody .journal-row:last').attr('id');
            if (rowCount == "" || rowCount == undefined) {
                rowCount = 1;
            } else {
                rowCount = parseInt(rowCount) + parseInt(1);
            }

            var rows = '<tr id="' + rowCount + '" class="journal-row_' + rowCount +
                ' journal-row">';
            rows += '<td class="text-center">' + rowCount + '</td>';
            rows += '<td><select name="accounting_vouchers[]" class="form-control accounting_vouchers" id="accounting_vouchers_' + rowCount +
                '" required onchange="fetchAccountingVoucher(' + rowCount +
                ')"><option value="">Select Accounting Voucher</option></select></td>';
            rows += '<td>';
            rows += '<td><button type="button" class="btn btn-sm btn-danger" onclick="removeJournalRow(' + rowCount +
                ')"><i class="las la-minus"></i></td>';
            rows += '</tr>';
            $('#journalRowBody').append(rows);
            $('#accounting_vouchers_' + rowCount).select2({
                placeholder: 'Select Accounting Voucher',
                ajax: {
                    url: "/admin/get-journal",
                    type: "POST",
                    dataType: 'json',
                    delay: 250,
                    data: function(params) {
                        return {
                            _token: "{{ csrf_token() }}",
                            search: params.term,
                            page: params.page,
                        };
                    },
                    processResults: function(data, params) {
                        params.page = params.page || 1;
                         var results = data.data.map(function(item) {
                          var crDetails = item.details.map(function(detail) {
                            return detail.ledger?.name + ': ' + detail.amount;
                        }).join(', ');

                        var name = item.voucher_number + ' - ' + item.voucher_date + ' | ' + crDetails;
                            return {
                                id: item.id,
                                text: name,
                            };
                        });

                        return {
                            results: results,
                            pagination: {
                                more: (params.page * data.per_page) < data.total
                            }
                        };
                    },
                    cache: true
                }
            });

        }
        function removeJournalRow(id) {
            $(".journal-row_" + id).remove();
          $('.journal-sub-row[data-id="' + id + '"]').remove();
            calculateExpenseSum();
        }

        function fetchAccountingVoucher(id) {
            var accounting_voucher = $('#accounting_vouchers_' + id).val();
            $('.journal-sub-row[data-id="' + id + '"]').remove();
            calculateExpenseSum();
            if (accounting_voucher != null) {
                $.ajax({
                    url: "/admin/get-accounting-voucher",
                    type: "POST",
                    data: {
                        _token: "{{ csrf_token() }}",
                        accounting_voucher_id: accounting_voucher,
                        row_id: id
                    },
                    success: function(response) {
                        $('#journalRowBody').append(response);
                        calculateExpenseSum();
                    }
                })
            }
        }
        $('#cost_allocation_form').submit(function(e) {
            e.preventDefault();
            var formData = new FormData(this);
            var url = $(this).attr('action');
            $('#submit-btn').attr('disabled', true);
            $.ajax({
                url: url,
                type: "POST",
                data: formData,
                contentType: false,
                processData: false,
                success: function(response) {
                    if (response.status == 'success') {
                        alert(response.message);
                        location.reload();
                    }else{
                        alert(response.message);
                        $('#submit-btn').attr('disabled', false);
                    }
                },
                error: function(response) {
                    alert(response.message);
                }
            });
        });
    </script>
@endsection