@extends('../layout/' . $layout)

@section('subhead')
    <title>Atarud MIS - Transaction Report</title>
@endsection
<style type="text/css">
    .stu_pro tr td {
        padding: 1px;
    }

    .fileBtn:hover {
        cursor: progress;
        color: red;
    }
</style>
<link rel="stylesheet" href="{{ asset('dist/persianDatepicker/css/persianDatepicker-default.css') }}" />
@section('subcontent')
    <div class="intro-y flex items-center mt-8">
        <h2 class="text-lg font-medium mr-auto">Transaction Report</h2>
    </div>

    <div class="box ">

        <div class="col-span-12 lg:col-span-8 2xl:col-span-9 ">
            <div class="flex box items-center p-5 border-b border-slate-200/60 dark:border-darkmode-400">
                <h2 class="font-medium text-base mr-auto">Filter</h2>
            </div>

            <div class="p-5 box">
                <div class="flex flex-col-reverse xl:flex-row">
                    <div class="flex-1 mt-6 xl:mt-0">
                        <form action="{{route('report.transaction.filter')}}" method="get">
                            <div class="grid grid-cols-12 gap-2">
                                <div class="form-control col-span-5 mt-2">
                                    <label class="control-label">From</label>
                                    <input type="text" placeholder="YYYY-0M-0D" id="dateFrom"   name="from" class="form-control pdpF2 pl-12" value="{{  app('request')->input('from')  }}">

                                </div>
                                <div class="form-control col-span-5 mt-2">
                                    <label class="control-label">To</label>
                                    <input type="text" placeholder="YYYY-0M-0D" id="dateTo"  name="from" class="form-control pdpF2 pl-12" value="{{  app('request')->input('to')  }}">

                                </div>

                            </div>

                            <div class="grid grid-cols-12 gap-2">
                                <button type="submit" onclick="filter()" class="btn btn-primary mt-5" style="float: right;">Filter</button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>

        <div class="intro-y box lg:mt-5">

            <div class="p-5 box ">
                <div class="flex flex-col-reverse xl:flex-row flex-col">
                    <div class="flex-1 mt-6 xl:mt-0">

                        @if(isset($income))
                        <h1 style="text-align:center; font-size: 20px;">
                            <strong>
                                {{$data['from']}} - {{$data['to']}}
                            </strong>
                        </h1>
                        <br>
                        <div class="grid grid-cols-12 gap-2">
                            <div class="col-span-6" style="background-color: rgb(248, 247, 246); padding:20px;">
                                <h1 style=" font-size: 20px;"><strong>Assets</strong></h1>
                                <hr style="border:1px solid black; margin:10px 0;" />
                                <table class="table">
                                    <tr>
                                        <td>Expenses</td>
                                        <td>AFN {{$data['expenseSum']}}</td>
                                    </tr>
                                    <tr>
                                        <td>Assets</td>
                                        <td>AFN {{ $data['assetSum'] + $data['incomeSum'] }}</td>
                                    </tr>
                                </table>
                            
                                <h2 style="background-color:rgb(239, 233, 227); text-align:center; padding:10px; font-weight:bold;">
                                    Sub Total: {{ $data['expenseSum'] + $data['assetSum'] + $data['liableDbtSum'] + $data['equityDbtSum'] + $data['incomeDbtSum'] }}
                                </h2>
                            </div>
                            <div class="col-span-6" style="background-color: rgb(248, 247, 246); padding:20px;">
                                <h1 style=" font-size: 20px;"><strong>Liabilities & Equity</strong></h1>
                                <hr style="border:1px solid black; margin:10px 0;" />
                                <table class="table">
                                    <tr>
                                        <td>Income/Revenue</td>
                                        <td>AFN {{ $data['incomeSum'] }}</td>
                                    </tr>
                                    <tr>
                                        <td>Liabilities</td>
                                        <td>AFN {{ $data['liableSum'] + $data['expenseSum'] }}</td>
                                    </tr>
                                    <tr>
                                        <td>Equities</td>
                                        <td>AFN {{ $data['equitySum'] }}</td>
                                    </tr>
                                </table>

                                <h2 style="background-color:rgb(239, 233, 227); text-align:center; padding:10px; font-weight:bold;">
                                    Sub Total: {{ $data['liableSum'] + $data['equitySum'] + $data['incomeSum'] + $data['expenseDbtSum'] + $data['assetDbtSum'] }}
                                </h2>
                            </div>
                        </div>
                        @endif
                    </div>
                </div>
            </div>


            <div class="p-5 box hidden">
                <div class="flex flex-col-reverse xl:flex-row flex-col">
                    <div class="flex-1 mt-6 xl:mt-0">

                        @if(isset($income))
                        <h1 style="text-align:center; font-size: 20px;">
                            <strong>
                            {{$data['from']}} - {{$data['to']}}
                            </strong>
                        </h1>
                        <br>
                        <div class="grid grid-cols-12 gap-2">
                            <div class="col-span-6" style="background-color: rgb(248, 247, 246); padding:10px;">
                                @if(count($expense) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Expense</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($expense as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['expenseSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($asset) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Asset</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($asset as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['assetSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($liableDbt) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Liable Dbt</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($liableDbt as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->from_account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['liableDbtSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($equityDbt) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Equity</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($equityDbt as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->from_account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['equityDbtSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($incomeDbt) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Income</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($incomeDbt as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->from_account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['incomeDbtSum']}}</strong></h1>
                                    </div>
                                @endif
                            
                                <h2 style="background-color:rgb(239, 233, 227); text-align:center; padding:10px; font-weight:bold;">
                                    Sub Total: {{ $data['expenseSum'] + $data['assetSum'] + $data['liableDbtSum'] + $data['equityDbtSum'] + $data['incomeDbtSum'] }}
                                </h2>
                            </div>
                            <div class="col-span-6" style="background-color: rgb(248, 247, 246); padding:10px;">
                                @if(count($liable) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Liable</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($liable as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['liableSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($equity) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Equity</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($equity as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['equitySum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($income) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Income</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($income as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['incomeSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($expenseDbt) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Expense</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($expenseDbt as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->from_account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['expenseDbtSum']}}</strong></h1>
                                    </div>
                                @endif
                                @if(count($assetDbt) > 0)
                                    <div class="overflow-x-auto">
                                        <h1 style=" font-size: 20px;"><strong>Asset</strong></h1>
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th class="whitespace-nowrap">#</th>
                                                    <th class="whitespace-nowrap">Title</th>
                                                    <th class="whitespace-nowrap">Account</th>
                                                    <th class="whitespace-nowrap">Amount</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($assetDbt as $row)
                                                @php $acc = App\Models\ChartofAccount::where('id',$row->from_account_id )->first(); @endphp
                                                <tr>
                                                    <td>{{$row->id}}</td>
                                                    <td>{{$row->title}}</td>
                                                    <td>{{$acc->name}}</td>
                                                    <td>{{$row->amount}}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        <h1 style=" font-size: 15px;"><strong>Total: {{$data['assetDbtSum']}}</strong></h1>
                                    </div>
                                @endif

                                <h2 style="background-color:rgb(239, 233, 227); text-align:center; padding:10px; font-weight:bold;">
                                    Sub Total: {{ $data['liableSum'] + $data['equitySum'] + $data['incomeSum'] + $data['expenseDbtSum'] + $data['assetDbtSum'] }}
                                </h2>
                            </div>
                        </div>
                        @endif
                    </div>
                </div>
            </div>

            <div class="p-5 box">
                <div class="flex flex-col-reverse xl:flex-row">
                    <div class="flex-1 mt-6 xl:mt-0" id="result"></div>
                </div>
            </div>

        </div>

    </div>
    <!-- END: Display Information -->
@endsection

@section('script')
<script src="{{ asset('dist/js/jquery.js') }}"></script>
<script src="{{ asset('dist/persianDatepicker/js/persianDatepicker.js') }}"></script>
<script>
    $(function () {

        $(".pdpF2").persianDatepicker({
            months: ["حمل", "ثور", "جوزا", "سرطان", "اسد", "سنبله", "میزان", "عقرب", "قوس", "جدی", "دلو", "حوت"],
            dowTitle: ["شنبه", "یکشنبه", "دوشنبه", "سه شنبه", "چهارشنبه", "پنج شنبه", "جمعه"],
            shortDowTitle: ["ش", "ی", "د", "س", "چ", "پ", "ج"],
            showGregorianDate: !1,
            persianNumbers: !0,
            formatDate: "YYYY/MM/DD",
            selectedBefore: !1,
            selectedDate: null,
            startDate: null,
            endDate: null,
            prevArrow: '\u25c4',
            nextArrow: '\u25ba',
            theme: 'default',
            alwaysShow: !1,
            selectableYears: null,
            selectableMonths: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
            cellWidth: 25, // by px
            cellHeight: 20, // by px
            fontSize: 13, // by px
            isRTL: !1,
            calendarPosition: {
                x: 0,
                y: 0,
            },
            onShow: function () {},
            onHide: function () {},
            onSelect: function () {},
            onRender: function () {}
    });


    });
</script>


    <script>
        function rangeType(el) {
            if(el.value == ''){
                document.getElementById('dateFrom').disabled = true;
                document.getElementById('dateTo').disabled = true;
            }
            else{
                document.getElementById('dateFrom').disabled = false;
                document.getElementById('dateTo').disabled = false;
            }
        }
        function filter(){
            var dateFrom = document.getElementById('dateFrom').value;
            var dateTo = document.getElementById('dateTo').value;
            var account = document.getElementById('account').value;
            var range_type = document.getElementById('range_type').value;

            $.ajax({
                method: 'GET',
                url: "{{ url('/report/transaction/filter/') }}",
                data: {
                    from: dateFrom,
                    to: dateTo,
                    category: account,
                    type: range_type,
                },

                success: function(response) {
                    console.log(response);
                    jQuery('#result').html(response);
                }
            });
        }

        // print invoice function
        function PrintElem() {
            Popup($('#invoice_print').html());
        }

        function Popup(data)
        {
            var mywindow = window.open('', 'Report', 'height=600,width=850');
            mywindow.document.write('<html><head><title>Invoice</title>');
            mywindow.document.write('</head><body >');
            mywindow.document.write(data);
            mywindow.document.write('</body></html>');
            setTimeout(function(){
                mywindow.print();
            mywindow.close();
            }, 500);


            return true;
        }
    </script>
@endsection