@extends('layouts.master')

@section('title', 'Profit and Lost')

@section('content')

    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Profit and Lost</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">Profit and Lost</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>
                    <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;
                                $salesTotal= 0;
                                $incomeTotal= 0;
                                $costTotal= 0;
                                $expenceTotal= 0;
                                $accountType='';
                            @endphp
                            @foreach ($pandl as $value)
                                @if ($priority == '' || $priority != $value->priority)
                                    @php

                                    $priorityRow = 1;

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

                                            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 == '3') {
                                                $expenceTotal = $sectionTotal;
                                            } elseif ($priority == '4') {
                                                $costTotal = $sectionTotal;
                                            } elseif ($priority == '5') {
                                                $salesTotal = $sectionTotal;
                                            } elseif ($priority == '6') {
                                                $incomeTotal = $sectionTotal;
                                            }
                                            $sectionTotal=0;

                                            }
                                        }

                                        $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->date }}</td> --}}
                                    <td>{{ $value->acc_code }}</td>
                                    <td>{{ $value->acc_name }}</td>
                                    @if ($priority == '3' || $priority == '4')
                                    @php
                                     $sectionTotal+=$value->debit-$value->credit;
                                    @endphp
                                    <td align='right'>{{ number_format($value->debit-$value->credit, 2, '.', ',') }}</td>
                                    @elseif ($priority == '5' || $priority == '6')
                                    @php
                                     $sectionTotal+=$value->credit-$value->debit;
                                    @endphp
                                    <td align='right'>{{ number_format($value->credit-$value->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(count($pandl)==$count-1){

                                    echo " <tr align='right'><td colspan='3'><b>Total $value->account_type :</b></td><td align='right'><b>".number_format($sectionTotal, 2, '.', ',')."</b></td><td></td><tr>";

                                    if($priority == '3'){
                                        $expenceTotal= $sectionTotal;
                                    }elseif ($priority == '4') {
                                        $costTotal= $sectionTotal;
                                    }elseif ($priority == '5') {
                                        $salesTotal= $sectionTotal;
                                    }elseif ($priority == '6') {
                                        $incomeTotal= $sectionTotal;
                                    }
                                    $sectionTotal=0;

                                }

                                @endphp
                            @endforeach
                            <tr style="color: red">
                                @php
                                $profit=($incomeTotal+$salesTotal)-($expenceTotal+$costTotal)

@endphp
                                <td colspan="3" align='right'><b>Net Ordinary Income :</b></td>
                                <td align='right'><b>{{ number_format($profit, 2, '.', ',') }}</b></td><td></td>
                            </tr>
                        </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('/profit-and-lost-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");
                }
            });
        }
    </script>
@endsection