@extends('../layout/' . $layout)
@section('subhead')
<title>Atarud MIS - Charts of Accounts</title>
@endsection
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.4/jspdf.min.js"></script>
<link rel="stylesheet" href="{{ asset('dist/persianDatepicker/css/persianDatepicker-default.css') }}" />
@section('subcontent')
<div class="grid grid-cols-12 gap-6 mt-8">
    <div class="col-span-12 lg:col-span-3 2xl:col-span-2">
        <h2 class="intro-y text-lg font-medium mr-auto mt-2">Accounting Reports</h2>
        @include('../pages/account/reports/sidebar')
    </div>
    <div class="col-span-12 lg:col-span-9 2xl:col-span-10 mt-16">
        <!-- BEGIN: Reports Filter -->

        <div class="intro-y box">
            <div
                class="flex flex-col sm:flex-row items-center p-5 border-b border-slate-200/60 dark:border-darkmode-400">
                <h2 class="font-medium text-base mr-auto">Report Filters</h2>

            </div>
            <div id="inline-form" class="p-5">
                <form class="grid grid-cols-12 gap-2" method="GET"
                    action="{{ url('accounting/reports/expense_ledger') }}">
                    <div class="relative w-96 mx-auto">
                        <div
                            class="absolute rounded-l w-10 h-full flex items-center justify-center bg-slate-100 border text-slate-500 dark:bg-darkmode-700 dark:border-darkmode-800 dark:text-slate-400">
                            <i data-lucide="filter" class="w-4 h-4"></i>
                        </div>
                        {{-- <input type="text" data-daterange="true" name="date_range"
                            class="datepicker form-control pl-12"> --}}

                        <div class="flex flex-col sm:flex-row items-center">
                            <select class="form-select sm:mr-2 ml-2 w-52" name="rangeType" id="rangeType" >
                                <option>Select Range Type</option>
                                <option value="daily">Daily</option>
                                <option value="weekly">Weekly</option>
                                <option value="monthly">Monthly</option>
                                <option value="yearly">Yearly</option>
                                <option value="range">Range</option>
                            </select>
                            <input type="text" placeholder="YYYY-0M-0D" name="from"
                                class="form-control pdpF2 pl-12 ml-2 range" style="width: 200px;">
                            <input type="text" placeholder="YYYY-0M-0D" name="to" class="form-control pdpF2 pl-12 ml-2 range"
                                style="width: 200px;">
                            <select class="form-select sm:mr-2 ml-2 w-52">
                                <option>Select Report Type</option>
                                <option value="general">General</option>
                                <option value="detailed">Detailed</option>
                            </select>
                            <input type="submit" class="form-control btn btn-primary w-20 ml-2" value="Filter" />

                        </div>


                    </div>

                </form>
            </div>
        </div>
        <!-- END: Reports Filter -->
        <!-- BEGIN: Report Content -->


        <div class="intro-y box mt-5">
            <div
                class="flex flex-col sm:flex-row items-center p-5 border-b border-slate-200/60 dark:border-darkmode-400">
                <h2 class="font-medium text-base mr-auto">Report Content</h2>
                @if(isset($fromDate) && isset($toDate))
                <form method="get" action="{{route('expense_ledger.print')}}">
                    <input type="hidden" name="fromDate" value="{{$fromDate}}">
                    <input type="hidden" name="toDate" value="{{$toDate}}">
                    <input type="hidden" name="type" value="{{$type}}">
                    <button class="btn btn-pending mr-1 mb-2">
                        <i data-lucide="download" class="w-5 h-5"></i>
                    </button>
                </form>
                @endif
            </div>
            <div class="p-5">
                @if(isset($accounts))
                <h1 style="text-align: center; margin-top: 10px;"><strong>Expense Reports</strong></h1>
                <div class="overflow-x-auto parents" id="parent">
                    <table class="table mt-5" id="child" style="width: 100%;">
                        <thead class="table-light">
                            <tr>
                                <th class="whitespace-nowrap">#</th>
                                <th class="whitespace-nowrap">Name</th>
                                <th class="whitespace-nowrap">Account Type</th>
                                <th class="whitespace-nowrap">Amount</th>

                            </tr>
                        </thead>
                        <tbody>
                            @php $total = 0; $c=0; @endphp
                            @foreach($accounts as $row)
                            @php
                            $amount = App\Models\Payment::where('account_id', $row->id)
                            ->where('vochure_id', 0)
                            ->whereBetween('timestamp', [$fromDate, $toDate])
                            ->sum('amount');
                            $total += $amount;
                            @endphp
                            <tr>
                                <td>{{++$c}}</td>
                                <td>{{$row->name}}</td>
                                <td>{{$row->account_type}}</td>
                                <td>{{$amount}}</td>

                            </tr>

                            @endforeach
                            <tr>
                                <td>{{++$c}}</td>
                                <td>Voucher</td>
                                <td>Expense</td>
                                <td>{{$vouchers}}</td>

                            </tr>
                            @php $total += $vouchers; @endphp

                            <tr>
                                <td style="background-color: #A9A9A9;" colspan="4">Total: {{$total}}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                @endif
            </div>
        </div>
        <!-- END: Report Content -->
    </div>
</div>
@endsection
@section('script')
<script src="{{ asset('dist/js/jquery.js') }}"></script>
<script src="{{ asset('dist/persianDatepicker/js/persianDatepicker.js') }}"></script>
<script>
    $(function () {
        $('.range').hide();

        $('#rangeType').on('change', function(){
            var type = $(this).val();
            if(type == 'range'){
                $('.range').show();
            }else{
                $('.range').hide();
            }

        });
        $(".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 type="text/javascript">
    $(document).ready(function() {

    var pdf = new jsPDF('p', 'pt', 'ledger');
    source = $('.parents')[1];
    specialElementHandlers = {
        '#bypassme' : function(element, renderer) {
            return true
        }
    };
    margins = {
        top : 80,
        bottom : 60,
        left : 60,
        width : 922
    };
    pdf.fromHTML(source,
    margins.left,
    margins.top, {
        'width' : margins.width,
        'elementHandlers' : specialElementHandlers
    },

    function(dispose) {
      //  pdf.save('fileNameOfGeneretedPdf.pdf');
    }, margins);


});


</script>


@endsection