@extends('layouts/acc_layout')
@section('title', '| Edit Daily Cash & Bank Balance Register')
@section('content')
@include('successMsg')

    <div class="row add-data-form">
        <div class="col-md-12">
            <div class="col-md-3"></div>
            <div class="col-md-12 fullbody">
                <div class="viewTitle" style="border-bottom: 1px solid white;">
                    <a href="{{ url('vaultRegister/vaultRegisterListFiltering/') }}" class="btn btn-info pull-right addViewBtn"><i
                            class="glyphicon glyphicon-th-list viewIcon">
                        </i>View Register</a>
                </div><br>
                <div class="panel panel-default panel-border">
                    <div class="panel-heading">
                        <div class="panel-title">Daily Cash & Bank Balance Register</div>
                    </div>
                    {!! Form::open(['url' => '#', 'role' => 'form', 'class' => 'form-horizontal form-groups']) !!}
                    <div class="panel-body">
                        <div class="row">
                            <div class="col-md-9">
                                <div class="form-group">
                                    {!! Form::label('branch', 'Branch:', ['class' => 'col-sm-1 control-label']) !!}
                                    <div class="col-sm-2">
                                        {!! Form::text('', $branchIdwithName, ['class' => 'form-control', 'id' => 'viewBranchName', 'readonly' => 'readonly']) !!}
                                    </div>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('currency', 'Collection Date:', ['class' => 'col-sm-1 control-label']) !!}
                                <div class="col-sm-2">
                                    {!! Form::text('',  date('d-m-Y', strtotime($VaultRegister->collectionDate)) , ['class' => 'form-control', 'id' => 'viewCollectionDate','readonly' => 'readonly']) !!}
                                </div>
                            </div>
                            {!! Form::hidden('id', $VaultRegister->id) !!}
                        </div><br>

                        <div class="panel-body panelBodyView">
                            
                            <div class="panel-title">Cash in Hand:</div>
                            
                            <table class="table table-striped table-bordered" id="viewVaultRegister" style="color:black;">
                                <thead>
                                    <tr>
                                        <th width="140" rowspan="2">Particulars<br></th>
                                        <th colspan="{{ sizeof($takas) }}">Number of Banknotes (TK.)</th>
                                        <th width="170" rowspan="2">Total Amount</th>
                                    </tr>
                                    <tr>
                                        @foreach ($takas as $taka)
                                            <th>{{ $taka }}</th>
                                        @endforeach
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr>
                                        <th style="padding-right: 20px; text-align: left;">Cash Book<br>(প্রকৃত হাতে নগদ)</th>
                                        @foreach($takas as $i=> $taka)
                                            <td style="padding: 5px;">{!! Form::text('noOfCashBookNotes[]', $value = $noOfCashBookNotes[$i],  ['class' => 'form-control text-center noOfCashBookNotes', 'id' => 'noOfCashBookNotes', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off', 'data-note' => $taka ]) !!}</td>
                                        @endforeach

                                        <td style="padding: 5px;">{!! Form::text('cashBookSum', $value = $cashBookSum, ['class' => 'form-control text-right', 'id' => 'cashBookSum', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}</td>
                                    </tr>
                                </tbody>
                                <tbody>
                                    <tr>
                                        <th style="text-align: left;">After Closing<br>(বিকালের আদায়)</th>
                                        @foreach($takas as $i=> $taka)
                                            <td style="padding: 5px;"> {!! Form::text('noOfAfterClosingNotes[]', $value = $noOfAfterClosingNotes[$i], ['class' => 'form-control text-center noOfAfterClosingNotes', 'id' => 'noOfAfterClosingNotes', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off', 'data-note' => $taka ]) !!}</td>
                                        @endforeach

                                        <td style="padding: 5px;">{!! Form::text('afterClosingSum', $value = $afterClosingSum, ['class' => 'form-control text-right', 'id' => 'afterClosingSum', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}</td>
                                    </tr>
                                </tbody>
                                <tbody>
                                    <tr>
                                        <th style="text-align: left; padding: 5px;" >Cash Deficit<br>(ক্যাশ ঘাটতি)</th>                                        
                                        <td colspan="{{ sizeof($takas) }}" style="padding: 5px; text-align: left;"> {!! Form::text('cashDeficitReason', $value = $cashDeficitReason, ['class' => 'form-control text-left', 'id' => 'cashDeficitReason', 'type' => 'text', 'placeholder' => 'ক্যাশ ঘাটতির কারন ?','autocomplete'=>'off']) !!}</td>

                                        <td style="padding: 5px;"> {!! Form::text('cashDeficitAmount', $value = $cashDeficitAmount, ['class' => 'form-control text-right', 'id' => 'cashDeficitAmount', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}</td>
                                    </tr>
                                </tbody>
                                <tbody>
                                    <tr>
                                        <th style="text-align: left;">Total Amount<br>(মোট)</th>  
                                        <th colspan="{{ sizeof($takas) }}" style="padding: 5px;">{!! Form::text('totalInWords', $value = $totalInWords, ['class' => 'form-control', 'readonly', 'id' => 'totalInWords', 'type' => 'text', 'placeholder' => 'In Words', 'autocomplete' => 'off']) !!}</th>
                                        <td style="padding: 5px;"> {!! Form::text('totalSum', $value = $totalSum, ['class' => 'form-control text-right', 'id' => 'totalSum', 'readonly', 'type' => 'text', 'placeholder' => '0', 'autocomplete' => 'off']) !!}</td>
                                    </tr>
                                </tbody>
                            </table>

                            @if(!$BankAcRegisters->isEmpty())

                                <br><br>

                                <div class="panel-title">Cash at Bank:</div>
                        
                                <table class="table table-striped table-bordered" id="vaultReport" style="color:black;">
                                    <thead>
                                        <tr>
                                            <tr>
                                                <th rowspan="2" width="50px" >SL#</th>
                                                <th colspan="4">Bank Account Information</th>
                                                <th rowspan="2">Amount</th>
                                            </tr>
                                            <tr>
                                                <th>Bank Name</th>
                                                <th>A/C Number</th>
                                                <th>Routing Number</th>
                                                <th>Branch Name</th>
                                            </tr>
                                        </tr>
                                    </thead>
                                    <tbody>

                                                                                @foreach ($BankAcRegisters as $BankAcRegister)
                    
                                            {!! Form::hidden('cashAtBankAcIds[]', $BankAcRegister->id) !!}
                    
                                            <tr class="item{{ ($no + 1) }}">
                                                <td class="text-center slNo">{{ ++$no }}</td>
                    
                                                <td style="text-align: left; padding-left: 1em;"> {{ $BankAcRegister->bankName }} </td>
                                                <td style="text-align: middle;"> {{ $BankAcRegister->bankAcNumber }} </td>
                                                <td style="text-align: middle;"> {{ $BankAcRegister->acRoutingNumber }} </td>
                                                <td style="text-align: left; padding-left: 1em;"> {{ $BankAcRegister->bankBranchName }}, {{ $BankAcRegister->district }} </td>
                    

                                                <td style="padding: 5px;"> 
                                                    {!! Form::text('cashAtBank[]', $cashAtBankAmounts[$BankAcRegister->id] ?? null, ['class' => 'form-control text-right amount cash-At-Bank', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}
                                                </td>
                    
                                            </tr>

                                        @endforeach


                                        <tr>
                                            
                                            <th></th>  
                                            <th style="text-align: left;">Total Amount</th>  

                                            <th  colspan="3" >{!! Form::text('cashAtBAnkAmountInWords', $cashAtBankAmountInWords, ['class' => 'form-control', 'readonly', 'id' => 'cashAtBAnkAmountInWords', 'type' => 'text', 'placeholder' => 'In Words', 'autocomplete' => 'off']) !!}</th>


                                            <td style="padding: 5px;"> 
                                                {!! Form::text('cashAtBankTotal', $totalCashAtBankAmount, ['class' => 'form-control text-right amount cash-At-Bank-Total', 'style' => 'font-weight: bold', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}
                                            </td>
                                            
                                        </tr>
                    
                                        
                                    </tbody>

                                </table>
                                
                            @endif
                       

                        </div><br><br>
                        <div class="form-group">
                            {!! Form::label('submit', ' ', ['class' => 'col-sm-5 control-label']) !!}
                            <div class="col-sm-5">
                                {!! Form::submit('Submit', ['id' => 'add', 'class' => 'btn btn-info']) !!}
                                <a href="{{ url('vaultRegister/vaultRegisterListFiltering') }}"
                                    class="btn btn-danger closeBtn">Close</a>
                                <span id="success" style="color:green; font-size:20px;" class="pull-right"></span>
                            </div>
                        </div>
                    </div>
                    {!! Form::close() !!}
                </div>
            </div>
            <div class="footerTitle" style="border-top:1px solid white"></div>
        </div>
        <div class="col-md-2"></div>
    </div>


    <script type="text/javascript">
        $(document).ready(function() {

            $(document).on("input",".noOfCashBookNotes",function() {
                this.value = this.value.replace(/[^0-9]/g, '').replace(/(\..*)\./g, '$1'); 
            });
            $(document).on("input",".noOfAfterClosingNotes",function() {
                this.value = this.value.replace(/[^0-9]/g, '').replace(/(\..*)\./g, '$1'); 
            });

            $(document).on("input", ".amount", function () {
                this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1'); 
            });

            ////////////////////////// Auto Calculation Function  /////////////////////
            $('.noOfCashBookNotes').on('keyup', function() {
                var cashBookSum = 0;
                $('.noOfCashBookNotes').each(function(i, el) {
                    cashBookSum += +$(el).val()* +$(el).data('note');
                });
                $('#cashBookSum').val(cashBookSum);
                totalSum();
            });

            $('.noOfAfterClosingNotes').on('keyup', function() {
                var afterClosingSum = 0;
                $('.noOfAfterClosingNotes').each(function(i, el) {
                    afterClosingSum += +$(el).val()* +$(el).data('note');
                });
                $('#afterClosingSum').val(afterClosingSum);
                totalSum();
            });

            $('#cashDeficitAmount').on('keyup', function() {
                totalSum();
            });

            function totalSum() {
                var totalSum = +$('#cashBookSum').val() + +$('#afterClosingSum').val() + +$('#cashDeficitAmount').val();
                $('#totalSum').val(totalSum);
                $('#totalInWords').val(int_to_words(totalSum));
            }

            ////////////////////////// End Auto Calculation Function  /////////////////////

            ////////////////////////// Cash at bank Calculation Function  /////////////////////

            $('.cash-At-Bank').on('keyup', function() {
                calculateTotal();
            });

            function calculateTotal() {
                var total = 0;
                $('.cash-At-Bank').each(function() {
                    var value = parseFloat($(this).val()) || 0; // Parse value as float
                    total += value;
                });
                $('.cash-At-Bank-Total').val(total.toFixed(2));
                $('#cashAtBAnkAmountInWords').val(int_to_words(Math.floor(total)));
            }

            //////////////////////////  Cash at bank Calculation Function end  /////////////////////

            ////////////////////////// Amount in words convert Function  /////////////////////
            var IS_SOUTH_ASIAN = true;
            var ONES_WORD = ['', 'One', 'Two', 'Three', 'Four', 'Five', 'Six', 'Seven', 'Eight', 'Nine', 'Ten', 'Eleven', 'Twelve', 'Thirteen', 'Fourteen', 'Fifteen', 'Sixteen', 'Seventeen', 'Eighteen', 'Nineteen'];
            var TENS_WORD = ['', '', 'Twenty', 'Thirty', 'Fourty', 'Fifty', 'Sixty', 'Seventy', 'Eighty', 'Ninety'];
            var SCALE_WORD_WESTERN = ['', 'Thousand', 'Million', 'Billion', 'Trillion', 'Quadrillion', 'Quintillion', 'Sextillion', 'Septillion', 'Octillion', 'Nonillion'];
            var SCALE_WORD_SOUTH_ASIAN = ['', 'Thousand', 'Lakh', 'Crore', 'Hundred Crore', 'Thousand Crore', 'Lakh Crore', 'Crore Crore', 'Hundred Crore Crore', '***', '***'];
            var GROUP_SIZE = (typeof IS_SOUTH_ASIAN != "undefined" && IS_SOUTH_ASIAN) ? 2 : 3;
            var SCALE_WORD = (typeof IS_SOUTH_ASIAN != "undefined" && IS_SOUTH_ASIAN) ? SCALE_WORD_SOUTH_ASIAN : SCALE_WORD_WESTERN;
            function int_to_words(int) {
                if (int === 0) return 'Zero';
                return recurse('', 0, get_first_3(String(int)), get_rest_3(String(int)));
            }
            // Return string of first three digits, padded with zeros if needed
            function get_first_3(str) {
                return ('000' + str).substr(-(3));
            }
            function get_first(str) { //-- Return string of first GROUP_SIZE digits, padded with zeros if needed, if group size is 2, make it size 3 by prefixing with a '0'
                return (GROUP_SIZE == 2 ? '0' : '') + ('000' + str).substr(-(GROUP_SIZE));
            }
            // Return string of digits with first three digits chopped off
            function get_rest_3(str) {
                return str.substr(0, str.length - 3);
            }
            function get_rest(str) { // Return string of digits with first GROUP_SIZE digits chopped off
                return str.substr(0, str.length - GROUP_SIZE);
            }
            // Return string of triplet convereted to words
            function triplet_to_words(_3rd, _2nd, _1st) {
                return (_3rd == '0' ? '' : ONES_WORD[_3rd] + ' Hundred ') +
                    (_1st == '0' ? TENS_WORD[_2nd] : TENS_WORD[_2nd] && TENS_WORD[_2nd] + ' ' || '') +
                    (ONES_WORD[_2nd + _1st] || ONES_WORD[_1st]);  //-- 1st one returns one-nineteen - second one returns one-nine
            }
            // Add to result, triplet words with scale word
            function add_to_result(result, triplet_words, scale_word) {
                return triplet_words ? triplet_words + (scale_word && ' ' + scale_word || ' ') + ' ' + result : result;
            }
            function recurse(result, scaleIdx, first, rest) {
                if (first == '000' && rest.length === 0) return result + 'Taka Only.';
                var newResult = add_to_result(result, triplet_to_words(first[0], first[1], first[2]), SCALE_WORD[scaleIdx]);
                return recurse(newResult, ++scaleIdx, get_first(rest), get_rest(rest));
            }
            ////////////////////////// End Amount in words convert Function  /////////////////////



            $('form').submit(function(event) {
                event.preventDefault();
                $.ajax({
                    type: 'post',
                    url:   "{{url('vaultRegister/editVaultRegisterItem')}}",
                    data: $('form').serialize(),
                    dataType: 'json',
                    success: function(_response) {
                        if (_response.errors) {

                        } else {
                            if(_response.responseTitle == "Success!"){
                                toastr.success(_response.responseText, _response.responseTitle, opts);
                                setTimeout(function(){
                                    window.location.href =
                                    "{{ url('vaultRegister/vaultRegisterListFiltering/') }}";
                                }, 2000);
                            }else{
                                toastr.warning(_response.responseText, _response.responseTitle, opts);
                            }
                            
                        }
                    },
                    error: function(_response) {
                        // Handle error
                        alert(_response.errors);
                    }
                });
            });

        });
    </script>

@endsection