@extends('layouts.master')

@section('title', 'Balance Sheet')

@section('content')

    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Balance Sheet</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">Balance Sheet</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>Date</label>
                            <input type="date" class="form-control" id="p_and_l_date" name="p_and_l_date"
                                onchange="getPAndL()" value="{{$date}}">
                        </div>

                        <div class="col-lg-3" style="padding-top: 31px;">
                            <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>
            <div class="row">
                <div class="col-lg-12">
                    <div class="card card-primary card-outline card-outline-tabs" style="padding: 15px">
                        <table class="table ">
                            <tr>
                                <th>#</th>
                                {{-- <th>Date</th> --}}
                                <th>Account Code</th>
                                <th>Description</th>
                                <th style="text-align: right">Amount({{ $currencyCode }})</th>
                                <th></th>

                            </tr>
                            @php
                                $count = 1;
                                $debitTotal = 0;
                                $creatidTotal = 0;
                                $priority = '';
                                $priorityRow = 0;
                                $sectionTotal = 0;

                                $nonCurrentAssets = 0;
                                $currentAssets = 0;
                                $ownerEquity = 0;
                                $currentLiabilities = 0;
                                $nonCurrentLiabilities = 0;

                                $retainAdd=0;
                                $retainAdd2=0;

                                $accountType = '';
                            @endphp
                            @foreach ($balanceSheet as $value)
                                @if ($priority == '' || $priority != $value->priority)
                                    @php
                                        $priorityRow = 1;

                                        if ($priorityRow == 1 && $priority != '') {
                                            if ($priority != $value->priority) {

                                                @endphp
                                                @if ($priority == '7' && $retainAdd==0)
                                                <tr>
                                                    <td>{{ $count++ }}</td>
                                                    <td>-</td>
                                                    <td>Retained Earnings</td>
                                                    <td align='right'>{{ number_format($pAndL, 2, '.', ',') }}</td>
                                                    <td></td>
                                                </tr>
                                                @php
                                                $retainAdd=1;
                                                @endphp
                                                @endif
                                                @php
                                                
                                                echo " <tr><td align='right' colspan='3'><b>Total $accountType :</b></td><td align='right'><b>" . number_format($sectionTotal, 2, '.', ',') . '</b></td><td></td></tr>';

                                                $accountType = $value->account_type;
                                                if ($priority == '1') {
                                                    $nonCurrentAssets = $sectionTotal;
                                                } elseif ($priority == '2') {
                                                    $currentAssets = $sectionTotal;
                                                } elseif ($priority == '7') {
                                                    $ownerEquity = $sectionTotal;
                                                } elseif ($priority == '8') {
                                                    $currentLiabilities = $sectionTotal;
                                                } elseif ($priority == '9') {
                                                    $nonCurrentLiabilities = $sectionTotal;
                                                }
                                                $sectionTotal = 0;

                                                if ($priority == '2') {
                                                echo " <tr style='color: red'><td colspan='3' align='right'><b>Total Current Assets & Non-Current Assets :</b></td><td align='right'><b>" . number_format($nonCurrentAssets+$currentAssets, 2, '.', ',') . '</b></td><td></td><tr>';
                                                }
                                            }
                                        }
                                        $priority = $value->priority;

                                        if ($priorityRow == 1) {
                                            $priorityRow = 0;
                                            echo " <tr><td colspan='5'><b><u>$value->account_type</u></b></td><tr>";
                                        }
                                    @endphp
                                @endif



                                <tr>
                                    <td>{{ $count++ }}</td>
                                    <td>{{ $value->acc_code }}</td>
                                    <td>{{ $value->acc_name }}</td>
                                    @if ($priority == '1' || $priority == '2')

                                        @php

                                            $debit = $value->debit;
                                            $credit = $value->credit;

                                            if($value->trans == 1)
                                            {
                                                //$debit += $value->opening_balance;
                                            }

                                            if($value->trans == 2)
                                            {
                                                //$credit += $value->opening_balance;
                                            }

                                            $sectionTotal += $debit - $credit;

                                        @endphp

                                        <td align='right'>{{ number_format($debit - $credit, 2, '.', ',') }}</td>
                                    @elseif ($priority == '8' || $priority == '9' || $priority == '7')
                                        @php

                                            $debit = $value->debit;
                                            $credit = $value->credit;

                                            if($value->trans == 1)
                                            {
                                                //$debit += $value->opening_balance;
                                            }

                                            if($value->trans == 2)
                                            {
                                                //$credit += $value->opening_balance;
                                            }

                                            $sectionTotal += $credit - $debit;

                                            if($retainAdd2 == 0)
                                            {
                                                $sectionTotal += $pAndL;
                                                $retainAdd2 = 1;
                                            }

                                        @endphp
                                        <td align='right'>{{ number_format($credit - $debit, 2, '.', ',') }}</td>
                                    @endif
                                    <td><a href="general-ledger#ledger{{$value->acc_code}}" target="_blank"><i class="fa fa-eye"></i></a></td>
                                </tr>

                                

                                @php
                                $accountType = $value->account_type;
                             
                                if ($priority == '1') {
                                    $nonCurrentAssets = $sectionTotal;
                                } elseif ($priority == '2') {
                                    $currentAssets = $sectionTotal;
                                } elseif ($priority == '7') {
                                    $ownerEquity = $sectionTotal;
                                } elseif ($priority == '8') {
                                    $currentLiabilities = $sectionTotal;
                                } elseif ($priority == '9') {
                                    $nonCurrentLiabilities = $sectionTotal;
                                }

                                @endphp
                            @endforeach

                            @if ($retainAdd == 0)

                                <tr><td colspan='5'><b><u>Owner equity</u></b></td><tr>

                                <tr>
                                    <td>{{ $count++ }}</td>
                                    <td>-</td>
                                    <td>Retained Earnings</td>
                                    <td align='right'>{{ number_format($pAndL, 2, '.', ',') }}</td>
                                    <td></td>

                                </tr>

                                @php

                                echo " <tr><td colspan='3' align='right'><b>Total Owner equity :</b></td><td align='right'><b>" . number_format($pAndL, 2, '.', ',') . '</b></td><td></td><tr>';

                                $retainAdd=1;

                                @endphp

                                <tr style='color: red'><td colspan='3' align='right'><b>Total Equity, Current Liabilities & Non-Current Liabilities :</b></td><td align='right'><b>{{ number_format($ownerEquity+$currentLiabilities+$nonCurrentLiabilities, 2, '.', ',') }} </b></td><td></td><tr>';

                            @else

                                <tr style='color: red'><td colspan='3' align='right'><b>Total Equity, Current Liabilities & Non-Current Liabilities :</b></td><td align='right'><b>{{ number_format($ownerEquity+$currentLiabilities+$nonCurrentLiabilities, 2, '.', ',') }} </b></td><td></td><tr>';

                            @endif

                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script>
        function getPAndL() {
            var csrf_token = $('meta[name="csrf-token"]').attr('content');
            var date = $("#p_and_l_date").val();
            $.ajax({
                type: 'post',
                url: '{{ url('/balance-sheet-by-date') }}',
                data: {
                    _token: csrf_token,
                    date: date
                },
                async: true,
                success: function(data) {
                    document.open();
                    document.write(data);
                    document.close();
                    $("#p_and_l_date").val(date);
                },
                error: function(data) {
                    swlToster('error', "Something went wrong");
                }
            });
        }

        function exportExcel()
        {
            var query = {
                date: $('#p_and_l_date').val()
            }
            var url = "{{URL::to('/export-excel-balance-sheet-report')}}?" + $.param(query)
            window.location = url;
        }

    </script>
@endsection