@extends('../layout/' . $layout)
@section('subhead')
    <title>Atarud MIS - Charts of Accounts</title>
@endsection
<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-10" >

            <!-- 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>
                    <div id="inline-form" class="p-5">
                        <form class="grid grid-cols-12 gap-2" method="GET" action="{{ url('accounting/reports/prepaid') }}">
                            <div class="relative w-96 mx-auto">
                                <div class="flex flex-col sm:flex-row items-center">
                                    <select class="form-control" name="year">
                                        @for($i = 1400; $i < 1450; $i++)
                                            <option value={{ $i }}>{{$i}}</option>
                                        @endfor
                                    </select>
                                    <input type="submit" class="form-control btn btn-primary w-20 ml-2" value="Filter" />
                                </div>
                            </div>
                        </form>
                    </div>
                    @if(isset($bills) || isset($invenTransactions)  || isset($teacherSalary) || isset($empSalary))
                    <form method="get" action="{{route('report.prepaid.print')}}">
                        <input type="hidden" name="year" value="{{ $year }}">
                        <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($bills))
                       <h1 style="text-align: center; margin-top: 10px;"><strong>Prepaid Accounts Reports</strong></h1>
                        <div class="overflow-x-auto parents" id="parent" >
                           {{-- <h1 style="text-align:center;"> asdfasdf</h1> --}}
                            <table class="table mt-5" id="child" style="width: 100%;">
                                <thead class="table-light">
                                    <tr>
                                        <th class="whitespace-nowrap">#</th>
                                        <th class="whitespace-nowrap">Account Name</th>
                                        <th class="whitespace-nowrap">Amount</th>
                                        <th class="whitespace-nowrap">Bill Year</th>
                                        <th class="whitespace-nowrap">Bill Month</th>
                                        <th class="whitespace-nowrap">Description</th>

                                    </tr>
                                </thead>
                                <tbody>
                                    @php $total = 0; @endphp
                                    @foreach($bills as $row)
                                        @php
                                            $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                            $accountName = $account != null ? $account->name : '';
                                        @endphp
                                    <tr>
                                        <td>{{++$loop->index}}</td>
                                        <td>{{$accountName}}</td>
                                        <td>{{$row->amount}}</td>
                                        <td>{{$row->bill_year}}</td>
                                        <td>{{$months[$row->bill_month - 1]}}</td>
                                        <td>{{$row->description}}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                @endif

                @if(isset($teacherSalary))
                <h1 style="text-align: center; margin-top: 10px;"><strong>Prepaid Teacher Salary Reports</strong></h1>
                 <div class="overflow-x-auto parents" id="parent" >
                    {{-- <h1 style="text-align:center;"> asdfasdf</h1> --}}
                     <table class="table mt-5" id="child" style="width: 100%;">
                         <thead class="table-light">
                             <tr>
                                 <th class="whitespace-nowrap">#</th>
                                 <th class="whitespace-nowrap">Teacher Name</th>
                                 <th class="whitespace-nowrap">Amount</th>
                                 <th class="whitespace-nowrap">Payment Year</th>
                                 <th class="whitespace-nowrap">Payment Month</th>
                                 <th class="whitespace-nowrap">Description</th>

                             </tr>
                         </thead>
                         <tbody>
                             @php $total = 0; @endphp
                             @foreach($teacherSalary as $row)
                                 @php
                                     $teacher = App\Models\Teacher::where('id', $row->teacher_id)->first();
                                     $teacherName = $teacher != null ? $teacher->name : '';
                                 @endphp
                             <tr>
                                 <td>{{++$loop->index}}</td>
                                 <td>{{$teacherName}}</td>
                                 <td>{{$row->amount}}</td>
                                 <td>{{$row->payment_year}}</td>
                                 <td>{{$months[$row->payment_month - 1]}}</td>
                                 <td>{{$row->description}}</td>
                             </tr>
                             @endforeach
                         </tbody>
                     </table>
                 </div>
                @endif
                @if(isset($empSalary))
                <h1 style="text-align: center; margin-top: 10px;"><strong>Prepaid Employee Salary Reports</strong></h1>
                 <div class="overflow-x-auto parents" id="parent" >
                    {{-- <h1 style="text-align:center;"> asdfasdf</h1> --}}
                     <table class="table mt-5" id="child" style="width: 100%;">
                         <thead class="table-light">
                             <tr>
                                 <th class="whitespace-nowrap">#</th>
                                 <th class="whitespace-nowrap">Employee Name</th>
                                 <th class="whitespace-nowrap">Amount</th>
                                 <th class="whitespace-nowrap">Payment Year</th>
                                 <th class="whitespace-nowrap">Payment Month</th>
                                 <th class="whitespace-nowrap">Description</th>

                             </tr>
                         </thead>
                         <tbody>
                             @php $total = 0; @endphp
                             @foreach($empSalary as $row)
                                 @php
                                     $emp = App\Models\Employee::where('id', $row->emp_id)->first();
                                     $empName = $emp != null ? $emp->emp_fname : '';
                                 @endphp
                             <tr>
                                 <td>{{++$loop->index}}</td>
                                 <td>{{$empName}}</td>
                                 <td>{{$row->amount}}</td>
                                 <td>{{$row->payment_year}}</td>
                                 <td>{{$months[$row->payment_month - 1]}}</td>
                                 <td>{{$row->description}}</td>
                             </tr>
                             @endforeach
                         </tbody>
                     </table>
                 </div>
                @endif
                @if(isset($invenTransactions))
                <h1 style="text-align: center; margin-top: 10px;"><strong>Prepaid Inventory Items Reports</strong></h1>
                 <div class="overflow-x-auto parents" id="parent" >
                    {{-- <h1 style="text-align:center;"> asdfasdf</h1> --}}
                     <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">Quantity</th>
                                 <th class="whitespace-nowrap">Amount</th>
                                 <th class="whitespace-nowrap">Date</th>
                                 <th class="whitespace-nowrap">Transaction Type</th>

                             </tr>
                         </thead>
                         <tbody>
                             @php $total = 0; @endphp
                             @foreach($invenTransactions as $row)
                                 @php
                                     $item = App\Models\InventoryItems::where('id', $row->item_id)->first();
                                     $transaction = App\Models\Transactions::where('int_trans_id', $row->id)->first();
                                    //  $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                    $transactionAmount = $transaction != null ? $transaction->payment: 0;
                                     $itemName = $item != null ? $item->name : '';
                                 @endphp
                             <tr>
                                 <td>{{++$loop->index}}</td>
                                 <td>{{$itemName}}</td>
                                 <td>{{$row->quantity}}</td>
                                 <td>{{$transactionAmount}}</td>
                                 <td>{{$row->date}}</td>
                                 <td>{{$row->transaction_type}}</td>
                             </tr>
                             @endforeach
                         </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 () {

        $(".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>
@endsection