@extends('layouts.master')

@section('title', 'General Ledger')

@section('content')

    <style>
        .ledger_caption {
            text-align: center;
            background: rgb(145, 159, 182);
            color: #ffffff;
            padding: 8px;
            font-weight: bold;
        }
    </style>
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">General Ledger</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">General Ledger</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>


    <div class="content">
        <div class="container-fluid">

            <div class="row">
                <div class="col-lg-12">

                    <div class="row mt-2">
                        <div class="col-lg-3">
                            <label>From Date</label>
                            <input type="date" class="form-control" id="from_date" name="from_date" value="{{date('Y-m-01')}}">
                        </div>
                        <div class="col-lg-3">
                            <label>To Date</label>
                            <input type="date" class="form-control" id="to_date" name="to_date"  value="{{date('Y-m-t')}}">
                        </div>
                        <div class="col-lg-3">
                            <label>Ledger</label>
                            <select class="form-control select2" id="ledger" name="ledger">
                                <option value="-1">All Ledgers</option>
                                @foreach ($ledger as $value)
                                    <option value="{{ $value->acc_id }}">{{ $value->acc_code . '-' . $value->acc_name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-lg-3">
                            <label>&nbsp;</label><br>
                            <input type="button" value="Search" class="btn btn-info" onclick="getGeneralLedger()">
                            <div class="btn-group">
                                <button type="button" class="btn btn-info">Export To </button>
                                <button type="button" class="btn btn-info dropdown-toggle dropdown-icon" data-toggle="dropdown">
                                    <span class="sr-only">Toggle Dropdown</span>
                                </button>
                                <div class="dropdown-menu" role="menu">
                                    <a class="dropdown-item" href="#" onclick="exportExcel()">Excel</a>
                                </div>
                            </div>
                        </div>
                    </div>
                    <br>

                </div>
            </div>

            {{-- @php
                $priority = '';
                $priorityRow = 0;
                $mainSccName="";
            @endphp --}}

            @foreach ($doubleEntryArray as $doubleEntry)
            {{-- @php
            dd($doubleEntry['arr']);
            @endphp
                @if ($priority == '' || $priority != $doubleEntry['arr'][0]->priority)
                    @php
                        $priority = $doubleEntry['arr'][0]->priority;
                        $priorityRow = 1;
                        if ($priorityRow == 1) {
                            $priorityRow = 0;
                            $mainAccName=$doubleEntry['arr'][0]->account_type;
                            echo "<div class='row'><div class='col-lg-12'><p><b><u>$mainAccName</u></b></p></div></div>";
                        }
                    @endphp
                @endif --}}

                <div class="row">

                    <div class="col-lg-2" id="ledger{{$doubleEntry['acc_code']}}">
                        <p class="ledger_caption">{{ $doubleEntry['acc_code'] }}</p>
                    </div>
                    <div class="col-lg-10">
                        <p class="ledger_caption">{{ $doubleEntry['account_name'] }}</p>
                    </div>
                    <br />
                    <div class="col-lg-12">
                        <div class="card card-primary card-outline card-outline-tabs">
                            <table class="table table-striped">

                                <tr>
                                    <th>#</th>
                                    <th>Date</th>
                                    <th>Voucher No</th>
                                    <th>Description</th>
                                    <th style="text-align: right">Debit({{ $currencyCode }})</th>
                                    <th style="text-align: right">Credit({{ $currencyCode }})</th>

                                </tr>
                                @php
                                    $count = 1;
                                    $debitTotal = 0;
                                    $creatidTotal = 0;
                                    $priority = '';
                                    $priorityRow = 0;
                                @endphp
                                <tr>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td><b>Beginning Balance for period</b></td>
                                    @php

                                        $open_debit = $doubleEntry['open_bal_debit'] - $doubleEntry['open_bal_credit'] > 0 ? number_format($doubleEntry['open_bal_debit'] - $doubleEntry['open_bal_credit'], 2, '.', ',') : '';
                                        $open_credit = $doubleEntry['open_bal_credit'] - $doubleEntry['open_bal_debit'] > 0 ? number_format($doubleEntry['open_bal_credit'] - $doubleEntry['open_bal_debit'], 2, '.', ',') : ($doubleEntry['open_bal_credit'] - $doubleEntry['open_bal_debit'] == 0 ?'0.00':'');

                                        $open_debits = str_replace(',', '', $open_debit);
                                        $open_credits = str_replace(',', '', $open_credit);
                                        $open_debits = floatval($open_debits);
                                        $open_credits = floatval($open_credits);

                                        if($doubleEntry['trans'] == 1)
                                        {
                                            //$open_debits += $doubleEntry['opening_balance'];
                                        }

                                        if($doubleEntry['trans'] == 2)
                                        {
                                            //$open_credits += $doubleEntry['opening_balance'];
                                        }

                                        if(is_numeric($open_debits))
                                        {
                                            $debitTotal += $open_debits;
                                        }
                                        
                                        if(is_numeric($open_credits))
                                        {
                                            $creatidTotal += $open_credits;
                                        }

                                        
                                    @endphp
                                    <td align='right'>{{ number_format($open_debits, 2, '.', ',') }}</td>
                                    <td align='right'>{{ number_format($open_credits, 2, '.', ',') }}</td>
                                </tr>
                                @foreach ($doubleEntry['arr'] as $value)
                                    <tr>
                                        <td>{{ $count++ }}</td>
                                        <td>{{ $value->date }}</td>
                                        <td>{{ $value->voucher_no }}</td>
                                        <td>{{ $value->description }}</td>
                                        <td align='right'>{{ $value->debit != 0 ? number_format($value->debit, 2, '.', ',') : '' }}</td>
                                        <td align='right'>{{ $value->credit != 0 ? number_format($value->credit, 2, '.', ',') : '' }}</td>

                                    </tr>
                                    @php
                                        $debitTotal += $value->debit;
                                        $creatidTotal += $value->credit;
                                    @endphp
                                @endforeach
                                <tr>
                                    <td colspan="3"></td>
                                    <td><b>Total for Period</b></td>
                                    <td align='right'><b>{{ number_format($debitTotal, 2, '.', ',') }}</b></td>
                                    <td align='right'><b>{{ number_format($creatidTotal, 2, '.', ',') }}</b></td>
                                </tr>
                                <tr style="color: red">
                                    <td colspan="3"></td>
                                    <td><b>Ending Balance for period</b></td>
                                    <td align='right'><b>{{ $debitTotal - $creatidTotal > 0 ? number_format($debitTotal - $creatidTotal, 2, '.', ',') : '' }}</b>
                                    </td>
                                    <td align='right'><b>{{ $creatidTotal - $debitTotal > 0 ? number_format($creatidTotal - $debitTotal, 2, '.', ',') : ($creatidTotal - $debitTotal == 0 ?'0.00':'') }}</b>
                                    </td>
                                </tr>
                            </table>
                        </div>
                    </div>
                </div>
                <br /><br />
            @endforeach
        </div>
    </div>
    <script>
        function getGeneralLedger() {
            var csrf_token = $('meta[name="csrf-token"]').attr('content');
            var _from_date = $("#from_date").val();
            var _to_date = $("#to_date").val();
            var _ledger = $("#ledger option:selected").val();

            $.ajax({
                type: 'post',
                url: '{{ url('/general-ledger-by-date') }}',
                data: {
                    _token: csrf_token,
                    from_date: _from_date,
                    to_date: _to_date,
                    ledger: _ledger
                },
                async: true,
                success: function(data) {
                    document.open();
                    document.write(data);
                    document.close();
                    $("#from_date").val(_from_date);
                    $("#to_date").val(_to_date);
                    $("#ledger").val(_ledger);
                },
                error: function(data) {
                    swlToster('error', "Something went wrong");
                }
            });
        }

        function exportExcel()
        {
            var query = {
                from_date : $("#from_date").val(),
                to_date : $("#to_date").val(),
                chart_of_account_id: $('#ledger').val()
            }
            var url = "{{URL::to('/export-excel-general-ledger')}}?" + $.param(query)
            window.location = url;
        }
    </script>
@endsection