@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('report/incexp/filter') }}">
                        <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>

                            <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 name="category" id="account" class="form-select sm:mr-2 ml-2 w-52" required
                                        value="{{ old('category') }}">
                                        <option value="">Choose Account</option>
                                        <option value="income">Income</option>
                                        <option value="expense">Expense</option>
                                        <option value="income_expense">Income & Expense</option>
                                </select>
                                <select class="form-select sm:mr-2 ml-2 w-52" name="type">
                                    <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('report.incexp.print')}}">
                        <input type="hidden" name="fromDate" value="{{$fromDate}}">
                        <input type="hidden" name="toDate" value="{{$toDate}}">
                        <input type="hidden" name="type" value="{{$type}}">
                        <input type="hidden" name="category" value="{{$category}}">
                        <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" >
                    @php
                        $income_openning = App\Models\ChartofAccount::where('account_type', '!=', 'expense')
                                                                            ->where("account_type", '!=','fixed assets')
                                                                            ->sum("openning_balance");
                        $student_income_total = 0; $shared_total = 0;
                    @endphp
                    @if(isset($studentRevenues))
                       <h1 style="text-align: center; margin-top: 10px;"><strong>Student Incomes</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>
                                        <td class="whitespace-nowrap">#</td>
                                        <td class="whitespace-nowrap">Slip#</td>
                                        <td class="whitespace-nowrap">Name</td>
                                        <td class="whitespace-nowrap">F/Name</td>
                                        <td class="whitespace-nowrap">Course</td>
                                        <td class="whitespace-nowrap">Admission</td>
                                        <td class="whitespace-nowrap">Exam</td>
                                        <td class="whitespace-nowrap">Monthly Fee</td>
                                        <td class="whitespace-nowrap">Material Fee</td>
                                        <td class="whitespace-nowrap">Total</td>
                                        <td class="whitespace-nowrap">Status</td>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($studentRevenues as $row)
                                        @php
                                            $student = App\Models\Student::where('id', $row->student_id)->first();
                                            $course = App\Models\Course::where('id', $row->section_id)->first();
                                            $courseName = $course != null ? $course->title : '';
                                            $stName = $student != null ? $student->name : '';
                                            $fName = $student != null ? $student->father_name : '';
                                            $totalStudentRevenue = $row->payment + $row->admission_fee + $row->material_fees + $row->exam_fee;

                                            $student_income_total += $totalStudentRevenue;
                                        @endphp
                                    <tr>
                                        <td>{{++$loop->index}}</td>
                                        <td>{{$row->id}}</td>
                                        <td>{{$stName}}</td>
                                        <td>{{$fName}}</td>
                                        <td>{{$courseName}}</td>
                                        <td>{{$row->admission_fee}}</td>
                                        <td>{{$row->exam_fee}}</td>
                                        <td>{{$row->payment}}</td>
                                        <td>{{$row->material_fees}}</td>
                                        <td>{{$totalStudentRevenue}}</td>
                                        <td>{{$row->fees_payment}}</td>
                                    </tr>
                                    @endforeach
                                    <tr>
                                        <td style="background-color: #A9A9A9;" colspan="10">Total: {{$student_income_total}}</td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <br>
                        <br>
                @endif

                @php $other_opennings = 0; @endphp
                @if(isset($data['incomeTransactions']))

                <h1 style="text-align: center; margin-top: 10px;"><strong>Other Incomes</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">Category</th>
                                 <th class="whitespace-nowrap">Title</th>
                                 <th class="whitespace-nowrap">Description</th>
                                 <th class="whitespace-nowrap">Date</th>
                                 <th class="whitespace-nowrap">Amount</th>
                             </tr>
                         </thead>
                         <tbody>
                             @php $other_income_total = 0; @endphp
                             @foreach($data['incomeTransactions'] as $row)
                             @php
                                 $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                 $other_income_total += $row->amount;

                             @endphp
                             <tr>
                                 <td>{{++$loop->index}}</td>
                                 <td>{{$account->name}}</td>
                                 <td>{{$row->title}}</td>
                                 <td>{{$row->description}}</td>
                                 <td>{{$row->timestamp}}</td>
                                 <td>{{$row->amount}}</td>
                             </tr>
                             @endforeach
                             <tr>
                                 <td style="background-color: #A9A9A9;" colspan="6">Total: {{$other_income_total}}</td>
                             </tr>
                         </tbody>
                     </table>
                 </div>

             </div>

         </div>

            <br>
            <br>
              @endif

              @if(isset($data['salaryTransactions']))
              <h1 style="text-align: center; margin-top: 10px;"><strong>Receipt Expense</strong></h1>
               <div class="overflow-x-auto parents box" 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">Slip#</th> --}}
                               <th class="whitespace-nowrap">Name</th>
                               <th class="whitespace-nowrap">F/Name</th>
                               <th class="whitespace-nowrap">Position</th>
                               <th class="whitespace-nowrap">Amount</th>
                               <th class="whitespace-nowrap">Notes</th>
                               <th class="whitespace-nowrap">Date</th>
                           </tr>
                       </thead>
                       <tbody>
                           @php $salary_total = 0; @endphp
                           @foreach($data['salaryTransactions'] as $row)
                               @php
                                   $emp = App\Models\Employee::where('id', $row->employee_id)->first();
                                   $teacher = App\Models\Teacher::where('id', $row->teacher_id)->first();

                                   $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                   $salary_total += $row->amount;

                                   $name = $emp != null ? $emp->emp_fname : $teacher->name;
                                   $fname = $emp != null ? $emp->emp_father_name : $teacher->name;
                                   $job = $emp != null ? $emp->emp_job : 'Teacher';

                               @endphp
                           <tr>
                               <td>{{++$loop->index}}</td>
                               <td>{{$name}}</td>
                               <td>{{$fname}}</td>
                               <td>{{$job}}</td>
                               <td>{{$row->amount}}</td>
                               <td>{{$row->title}}</td>
                               <td>{{$row->timestamp}}</td>
                           </tr>
                           @endforeach
                           <tr>
                               <td style="background-color: #A9A9A9;" colspan="7">Total: {{$salary_total}}</td>
                           </tr>
                       </tbody>
                   </table>
               </div>
               <br>
               <br>

       @endif

       @if(isset($shared))
       <h1 style="text-align: center; margin-top: 10px;"><strong>Shared Dividends</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">F/Name</th>
                        <th class="whitespace-nowrap">Percentage</th>
                        <th class="whitespace-nowrap">Amount</th>
                        <th class="whitespace-nowrap">Notes</th>
                        <th class="whitespace-nowrap">Date</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($shared as $row)
                        @php
                            $partner = App\Models\Partner::where('id', $row->partner_id)->first();
                            $shared_total += $row->shared_amount;
                        @endphp
                    <tr>
                        <td>{{++$loop->index}}</td>
                        <td>{{$partner != null ? $partner->name : ''}}</td>
                        <td>{{$partner != null ? $partner->father_name : ''}}</td>
                        <td>{{$row->shared_percentage}}</td>
                        <td>{{$row->shared_amount}}</td>
                        <td>{{$row->description}}</td>
                        <td>{{$row->date}}</td>
                    </tr>
                    @endforeach
                    <tr>
                        <td style="background-color: #A9A9A9;" colspan="7">Total: {{$shared_total}}</td>
                    </tr>
                </tbody>
            </table>
        </div>
@endif

       @if(isset($data['expenseTransactions']))

          <h1 style="text-align: center; margin-top: 10px;"><strong>Other Expenses</strong></h1>
           <div class="overflow-x-auto parents box" 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">Category</th>
                           <th class="whitespace-nowrap">Title</th>
                           <th class="whitespace-nowrap">Description</th>
                           <th class="whitespace-nowrap">Date</th>
                           <th class="whitespace-nowrap">Amount</th>
                       </tr>
                   </thead>
                   <tbody>
                       @php $other_expense_total = 0; @endphp
                       @foreach($data['expenseTransactions'] as $row)
                       @php
                           $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                           $other_expense_total += $row->amount;

                       @endphp
                       <tr>
                           <td>{{++$loop->index}}</td>
                           <td>{{$account->name}}</td>
                           <td>{{$row->title}}</td>
                           <td>{{$row->description}}</td>
                           <td>{{$row->timestamp}}</td>
                           <td>{{$row->amount}}</td>
                       </tr>
                       @endforeach
                       <tr>
                           <td style="background-color: #A9A9A9;" colspan="6">Total: {{$other_expense_total}}</td>
                       </tr>
                   </tbody>
               </table>
            </div>
            @endif
            @if(isset($data['voucherExpense']))

          <h1 style="text-align: center; margin-top: 10px;"><strong>Voucher Expenses</strong></h1>
           <div class="overflow-x-auto parents box" 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">Category</th>
                           <th class="whitespace-nowrap">Title</th>
                           <th class="whitespace-nowrap">Description</th>
                           <th class="whitespace-nowrap">Date</th>
                           <th class="whitespace-nowrap">Amount</th>
                       </tr>
                   </thead>
                   <tbody>
                       @php $voucher_total = 0; @endphp
                       @foreach($data['voucherExpense'] as $row)
                       @php
                                    $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                    $voucher_total += $row->amount;

                        @endphp
                       <tr>
                        <td>{{++$loop->index}}</td>
                        <td>{{$account->name}}</td>
                        <td>{{$row->title}}</td>
                        <td>{{$row->description}}</td>
                        <td>{{$row->timestamp}}</td>
                        <td>{{$row->amount}}</td>
                       </tr>
                       @endforeach
                       <tr>
                           <td style="background-color: #A9A9A9;" colspan="6">Total: {{$voucher_total}}</td>
                       </tr>
                   </tbody>
               </table>
            </div>
            @endif
               <div class="p-5" >
                <table class="table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">
                   <thead>
                    @php
                     $revenue = $student_income_total + $other_income_total;
                     $expense = $salary_total + $other_expense_total + $voucher_total + $shared_total;
                     $totalBalance = ($revenue + $income_openning - $expense);
                    @endphp
                   <tr>
                     <td>Starting Balance</td>
                     <td>{{$income_openning}}</td>
                   </tr>
                   <tr>
                     <td>Today's Revenue</td>
                     <td>{{ $revenue}}</td>
                   </tr>
                   <tr>
                     <td>Today's Expenses</td>
                     <td>{{ $expense }}</td>
                   </tr>
                   <tr>
                   <tr>
                     <td>Today's Balance</td>
                     <td>{{$totalBalance}}</td>
                   </tr>
                   <tr>
                     <td>Closing Balance</td>
                     <td>{{ ($totalBalance) }}</td>
                   </tr>

                   </thead>
                   </table>
                  </div>
           </div>

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

@endsection