@extends(!$download ?  'layouts.app' : 'layouts.app_with_out_nav',['dashBoardTitle'=>'BALANCE SHEET'])
@section('buttons')
    <div class="d-flex justify-content-end hedr-wdth">
        <a title="Trial Balance" class="export-btn btn btn-success btn-wdth"  href="{{url('trial_balance',['id'=>$id])}}"><i class="fa-regular fa-sheet-plastic"></i>&nbsp;TB</a>
        <a title="Profit & Loss" class="export-btn btn btn-success btn-wdth"  href="{{url('profit_loss',['id'=>$id])}}"><i class="fa-solid fa-money-bills"></i>&nbsp;P&L</a>
        <a title="Tax Report" class="export-btn btn btn-success btn-wdth"  href="{{url('tax-report',['id'=>$id])}}"><i class="fa-regular fa-file-pen"></i>&nbsp;TR</a>

        <div class="dropdown">
            <button class="btn btn-success btn-wdth dropdown-toggle" type="button" data-toggle="dropdown" id="dropdown">
            <span class="caret" ></span>Export</button>
                <div class="dropdownmenu " id="dropmenu" style="background-color:antiquewhite;color:black;margin-top:13px;border-radius: 10px;">
            <!-- <a href="{{url('balance_sheet',[$id])}}?doc=excel">excel <i class="fa-sharp fa-solid fa-file-excel"></i></a> -->
                    <a href="{{url('balance_sheet',[$id])}}?doc=pdf">pdf <i class="fa-sharp fa-solid fa-file-pdf"></i></a>
                </div>
        </div>
@endsection
@section('content')
<style>
.edit_option{
    border:1px solid #ccc;
    padding:5px;
    display:none;
}
.fa-pen-to-square{
    color:#ccc;
}
.item-input{
    display:none;
}
.update_btn{
    display: none;
    margin-left:3px;
}
.dropdownmenu{
    background-color:#ffffff;
    width:85px;
    height:70px;
    display: none;
    z-index: 1;
    padding: 15px;
    position:absolute;
    transition:  height 4s;
}
.dropdownmenu.active{
    display:block;
}
input::-webkit-outer-spin-button,
    input::-webkit-inner-spin-button {
            -webkit-appearance: none;
            margin: 0;
    }

    input[type=number] {
        -moz-appearance: textfield;
    }

</style>
<script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>

@if($download)

    <style>
    table{
        border:1px solid;
        width:100%;
        border-collapse: collapse;
    }
    tr{
        border:1px solid;
    }
    th{
        border:1px solid;
        padding:25px;
    }
    td{
        border:1px solid black;
        padding: 2.5px 5px;
    }

    .bgcl{
        background-color:#c8d8e4;
        }

        .note{
        width:30px;
        padding-left: 20px;
        padding-right: 20px;
        text-align: center;
        font-weight: bold;
        font-style: italic;
    }
    .bold{
    font-weight: bold;
    font-style: italic;

    }

    body{
        font-size:16px;

    }

</style>



@endif


<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-12">
                <div class="card-body clr-al">
                    @if (session('status'))
                        <div class="alert alert-success" role="alert">
                            {{ session('status') }}
                        </div>
                    @endif

                    
    <div class="export-btn-container d-flex justify-content-center" id="bs_pdf_container">
    <div class="col-md-12">
    <table class="table table-hover table-bordered fnt" id="tbl_exporttable_to_xls">

    @if($download)
        <tr class="bgcl">
                <td style="text-align:center;" class="bold" colspan="8"> BALANCE SHEET </td>                
        </tr>
    @endif
    

        <tr>
            <td colspan="3"style="width: 250px;"class="fw-bold">{{strtoUpper($companyDetails->taxpayer)}}</td>
            
            <td style="width: 30%"> <span style="float:left">T.R.NO : {{$companyDetails->tax_registration_number}}</span>
          </td>
            <td colspan="4">
            Tax Period:
            
            {{date('d-M-Y',strtotime(@$trialBalanceDetails->from))}}
                to
            {{date('d-M-Y',strtotime(@$trialBalanceDetails->to))}}
            </td>
           
        </tr>
        </table>
<table class="table table-bordered fnt">
        <tr>
            <td colspan="3" class="fnt">{{trans('United Arab Emirates')}}</td>
        </tr>
        <tr >
            <td
           
            colspan="3"
            
            class="fw-bold">{{trans('Statement of Financial Position')}}</td>
        </tr>

        <tr class="bgcl">
                <td 
               
            colspan="3"

                class="note"><i class="fa-sharp fa-solid fa-coins icn"> </i>Assets </td>
                
        </tr>


       


        @php
        $totalAsset = 0;
        @endphp
        @if(count($assets) > 0)
        @foreach($assets as $asset)
        @php
        $totalAsset += abs(round(floatval($asset['debit_value']),2)); 
        @endphp

        @if(abs(floatval($asset['debit_value'])) > 0)
        <tr class="dot-row">
            <td width="40%" class="font-weight-light">{{$asset['section_name']}}</td>
            <td
            
            @if($download)
            colspan="2"
            @endif
           

            class="edit_option_row" id="edit_option_row_135" align="right">{{numbermillions(abs(floatval($asset['debit_value'])))}}</td>
            @if(!$download)
            <td width="5%">
            <form method="POST" action="{{url('delete/bs')}}" class="d-flex">
            @csrf
            <input name="bs_item_id" type="hidden" value="{{$asset['key_id']}}" />
        
            <button class="btn">
                <i style="color:red; cursor:pointer;" class="fa-solid fa-xmark"></i>
            </button>
            </form>
            </td>

            @endif
        </tr>
        @endif
        @endforeach

       


        @endif



       @if($currentYrPL < 0)

       <tr class="dot-row">
            <td width="40%" class="font-weight-light">Current Year Loss</td>
            <td class="edit_option_row" id="edit_option_row_135" align="right">{{numbermillions(abs($currentYrPL))}}</td>
            <td></td>
        </tr>

        @php 
       $totalAsset = $totalAsset + abs(round(floatval($currentYrPL),2));
       @endphp

       @endif

       @if(!$download)
        <tr id="row_btn_add_assets">
                <td colspan="3">
                    <a class="btn btn-success" style=" height: 28.333334px;padding-top: 3px;padding-bottom: 3px;padding-left: 8px;padding-right: 8px;"
                     id="btn_add_assets" onclick="addingEntry('assets')"><i class="fa-sharp fa-solid fa-plus" ></i></a>
                </td>
        </tr>
        @endif

       

        <tr>
            
            <td 
            @if($download)
            colspan="2"
            @endif

            colspan="2" style="font-weight:bold;width:100px" class="note">Total Assets</td>
            <td style="font-weight:bold; background-color:#fff2d1;text-align: right;width:226px" class="note">{{numbermillions($totalAsset)}}</td>
           
            
        </tr>
        

        <tr class="bgcl">
                <td
                
                @if($download)
                
                @endif
                colspan="3"
                class="note"><i class="fa-sharp fa-solid fa-coins icn"> </i>Liabilites </td>              
                    @if(!$download)
                
                @endif


        </tr>
        @php
        $totalLiabilite = 0;
        @endphp
        @if(count($liabilites) > 0)
        @foreach($liabilites as $liabilite)
        @php
        $totalLiabilite += abs(round(floatval($liabilite['credit_value']),2)); 
        @endphp

        @if(abs(floatval($liabilite['credit_value'])) > 0)
        <tr class="dot-row">
            <td
            
            @if($download)
            colspan="2"
            @endif

            width="40%" class="font-weight-light">{{$liabilite['section_name']}}</td>
            <td class="edit_option_row" id="edit_option_row_135" align="right">{{numbermillions(abs(floatval($liabilite['credit_value'])))}}</td>

            @if(!$download)
            <td>
            <form method="POST" action="{{url('delete/bs')}}" class="d-flex">
            @csrf
            <input name="bs_item_id" type="hidden" value="{{$liabilite['key_id']}}" />
            <button class="btn">
                <i style="color:red; cursor:pointer;" class="fa-solid fa-xmark"></i>
            </button>
            </form>
            </td>
            @endif
        </tr>
        @endif

        @endforeach
        @endif

        @if($currentYrPL > 0)

            <tr class="dot-row">
                <td 
                
                @if($download)
                colspan="2"
                @endif

                width="40%" class="font-weight-light">Current Year Gain</td>
                <td class="edit_option_row" id="edit_option_row_135" align="right">{{numbermillions(abs(floatval($currentYrPL)))}}</td>
                @if(!$download)
                <td></td>
                @endif
            </tr>

            @php 
            $totalLiabilite = $totalLiabilite + abs(floatval($currentYrPL));
            @endphp
            @endif

            @if(!$download)
            <tr id="row_btn_add_liabilite">
                <td colspan="3">
                    <a class="btn btn-success" style=" height: 28.333334px;padding-top: 3px;padding-bottom: 3px;padding-left: 8px;padding-right: 8px;"
                     id="btn_add_liabilite" onclick="addingEntry('liabilite')"><i class="fa-sharp fa-solid fa-plus" ></i></a>
                </td>
            </tr>
            @endif


        <tr>
            <td 
            
            @if($download)
            colspan="2"
            @endif

            colspan="2" class="note">Total Liability</td>
            <td style="font-weight:bold; background-color:#fff2d1;text-align: right;" class="note">{{numbermillions($totalLiabilite)}}</td>

            @if(!$download)
            
            @endif
        </tr>

        <tr>
            <td 
            
            @if($download)
            colspan="2"
            @endif

            colspan="2" class="note">Total Difference (Asset - Liability)</td>
            <td style="font-weight:bold; background-color:#fff2d1;text-align: right;" class="note">{{numbermillions($totalAsset - $totalLiabilite)}} </td>
            @if(!$download)
            
            @endif
        </tr>



</table>

</div>
</div>
</div>
</div>
@if(!$download)
<script>
    
     // String validation for input fields with class 'string'
     $('body').on('input', 'input.string', function() {
        $(this).val($(this).val().replace(/[^a-zA-Z0-9.\s]/g, ''));
         });

    function editValue(id){
            //item_div_row_0
            //item_0
            $("#item_"+id).css('display','inline-block');
            $("#item_btn_"+id).css('display','inline-block');
            $("#item_div_row_"+id).css('display','none');
    }

    $(".edit_option_row").on('mouseenter', function(event){
        var text = event.target.id;
        var row =  text.split('_')[text.split('_').length-1];
        $(".edit_option").css('display','none');
        $("#item_option_"+row).css('display','inline-block');
        //console.log(document.getElementById("#item_option_"+row));
    });
    $(".edit_option_row").on('mouseleave', function(event){
        $(".edit_option").css('display','none');
    });
    $("#dropdown").on('click',function(event){
        $("#dropmenu").addClass('active');
    });
    $("#dropmenu").on('mouseleave', function (event){
      $("#dropmenu").removeClass('active');
    });
        function addingEntry(type){
        let tr = document.createElement('tr');
        tr.setAttribute('id', 'row-'+type);
        let td = `<td colspan='2'>
                    <form class="form-group row" method="POST" action="{{url('manual-entry-bs',['id'=>$id])}}">
                    <div class="col-6">
                            @csrf
                            <input name="item" class="form-control string" type="text" placeholder="Name" required></input>
                            <input name="company_id" class="form-control" type="hidden" placeholder="company_id" value="{{$companyDetails->id}}" required="required"></input>
                            <input name="type" class="form-control" type="hidden" value="`+type+`" required="required"></input>
                            </div>
                            <div class="col-6 d-flex" style="padding-left:20px">
                            <input id="amountInput" name="amount" class="form-control" type="number" placeholder="Amount" step="0.01" required="">
                            <button type="submit" class="btn btn-success" style="margin:0 4px;">Add</button>
                            </div>
                    </form>
                </td>
                <td>
                <button class="btn" onClick="CloseBtn('`+type+`')"><i style="color:red; cursor:pointer;" class="fa-solid fa-xmark"  id="close_btn_add_`+type+`" ></i></button>
                </td>`;
                tr.innerHTML = td;
                var existingNode = document.getElementById('row_btn_add_'+type);
                var table = document.getElementById('tbl_exporttable_to_xls');
                console.log(existingNode);
                console.log(existingNode.parentNode);
                existingNode.parentNode.insertBefore(tr, existingNode);
                document.getElementById('btn_add_'+type).style.display = "none";
                
        }

        function CloseBtn(type){
                document.getElementById('row-'+type).remove();
                document.getElementById('btn_add_'+type).style.display ="inline-block";

        }
</script>
@endif

@endsection