@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>

@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="date" name="from" id="dateFrom"  value="{{  app('request')->input('from')  }}"
                                        class="form-control" placeholder="From">
                                </div>
                                <div class="form-control col-span-5 mt-2">
                                    <label class="control-label">To</label>
                                    <input type="date" name="to" id="dateTo" class="form-control" value="{{ app('request')->input('to')}}"
                                        placeholder="From" >
                                </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: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>
        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