@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>
<link rel="stylesheet" href="{{ asset('dist/persianDatepicker/css/persianDatepicker-default.css') }}" />

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.4/jspdf.min.js"></script>
@section('subcontent')
@php
    $total = 0; $payment =0;
@endphp
    <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">Payables 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 id="inline-form" class="p-5">
                    <form class="grid grid-cols-12 gap-2" method="GET" action="{{ route('payable_ledger') }}">
                        @csrf
                        @method('get')
                        <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" placeholder="YYYY-0M-0D"  name="payableMonth" class="form-control pdpF2 pl-12 ml-2" style="width: 400px;">

                        </div>

                        <input type="submit" class="form-control btn btn-primary w-20 ml-80" value="Filter" />
                    </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($startofmonth) && isset($endofmonth))
                    <form method="get" action="{{route('payable_ledger.print')}}">

                        <input type="text" name="startofmonth" value="{{$startofmonth}}" style="display:none;">
                        <input type="text" name="endofmonth" value="{{$endofmonth}}" style="display:none;">
                        <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($data['employees']))

                   <h1 style="text-align: center; margin-top: 10px;"><strong>Employees Payables</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">Salary</th>
                                    <th class="whitespace-nowrap">Payment</th>
                                    <th class="whitespace-nowrap">Remaining</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $totalEmpSalary = 0;  @endphp
                                @foreach($data['employees'] as $row)
                                @php
                                $completeSalary = App\Models\Salary::where('emp_id', $row->id)->
                                                            where('payment_status', 'complete')->
                                                            whereBetween('date', [ $data['startofmonth'],  $data['endofmonth']])->first();
                                if($completeSalary != null) continue;


                                $half = App\Models\Salary::where('emp_id', $row->id)->
                                                            where('payment_status', 'half')->
                                                            whereBetween('date', [ $data['startofmonth'],  $data['endofmonth']])->first();
                                if($half != null ){
                                    $paid = $half->payable_amount - $half->payment;
                                    $totalEmpSalary += $paid;
                                }else{
                                    $paid = $row->emp_salary_amount;
                                    $totalEmpSalary += $paid;
                                }
                                // $total +=  $row->payable_amount;

                                @endphp
                                <tr>
                                    <td>{{++$loop->index}}</td>
                                    <td>{{$row->emp_fname}}</td>
                                    <td>{{$row->emp_salary_amount}}</td>
                                    <td>{{$half != null ? $half->payment : 0}}</td>
                                    <td>{{$paid}}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                        <table class=" box table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">';
                            <thead>
                               <tr>

                                   <td><strong>Remaining</strong></td>
                                   <td>{{$totalEmpSalary }}</td>
                               </tr>
                            </thead>
                            @php $total += $totalEmpSalary; @endphp
                       </table>
                    </div>
            @endif
                </div>

            <div class="p-5 box">
                @if(isset($data))

                   <h1 style="text-align: center; margin-top: 10px;"><strong>Teachers Payables</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">Salary</th>
                                    <th class="whitespace-nowrap">Payment</th>
                                    <th class="whitespace-nowrap">Remaining</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $totalTeaSalary = 0; @endphp
                                @foreach($data['teachers'] as $row)
                                @php
                                $completeSalary = App\Models\Salary::where('teacher_id', $row->id)->
                                                            where('payment_status', 'complete')->
                                                            whereBetween('date', [ $data['startofmonth'],  $data['endofmonth']])->first();
                                if($completeSalary != null) continue;


                                    $half = App\Models\Salary::where('teacher_id', $row->id)->
                                                            where('payment_status', 'half')->
                                                            whereBetween('date', [ $data['startofmonth'],  $data['endofmonth']])->first();
                                                            // $startMonth = $data['startofmonth']; $endMonth=$data['endofmonth'];
                                    $paid = '';
                                    if($half != null ){
                                          $payment = $half->payable_amount;
                                          $paid = $half->payable_amount - $half->payment;
                                          $totalTeaSalary += $paid;
                                    }else{
                                        $contract = getTeacherSalary($row, $data['startofmonth'],  $data['endofmonth']);
                                        if($contract[0] == null) continue;
                                        $paid = $contract[0]->salary_type == 'fixed' ? $contract[0]->salary : $contract[2];
                                        $paid = $contract[0]->salary_type == 'fixed' ? $payment = $contract[0]->salary :$payment =  $contract[2];
                                        $totalTeaSalary += $paid;
                                    }
                                    // $total +=  $row->payable_amount;

                                @endphp
                                <tr>
                                    <td>{{++$loop->index}}</td>
                                    <td>{{$row->name}}</td>
                                    <td>{{round($payment)}}</td>
                                    <td>{{$half != null ? round($half->payment) : 0}}</td>
                                    <td>{{round($paid)}}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                        <table class=" box table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">';
                            <thead>
                               <tr>

                                   <td><strong>Remaining</strong></td>
                                   <td>{{round($totalTeaSalary) }}</td>
                               </tr>
                            </thead>
                            @php $total += $totalTeaSalary; @endphp
                       </table>
                    </div>

            @endif
                </div>
                <div class="p-5" >
                    @if(isset($vouchers))

                       <h1 style="text-align: center; margin-top: 10px;"><strong>Voucher Payables</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</th>
                                        <th class="whitespace-nowrap">Amount</th>
                                        <th class="whitespace-nowrap">Payment</th>
                                        <th class="whitespace-nowrap">Remaining</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $totalVoucher = 0;
                                    @endphp
                                    @foreach($vouchers as $row)
                                        @php
                                            $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                            $totalAmount = 0;
                                            $totalPayment = 0;
                                            $totalAmount +=  $row->v_amount;
                                            $totalPayment +=  $row->v_paid;
                                            $totalVoucher += $row->v_amount - $row->v_paid;
                                        @endphp
                                    <tr>
                                        <td>{{++$loop->index}}</td>
                                        <td>{{$row->v_title}}</td>
                                        <td>{{$account->name}}</td>
                                        <td>{{$row->v_amount}}</td>
                                        <td>{{$row->v_paid}}</td>
                                        <td>{{$row->v_amount - $row->v_paid}}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            @php $total += $totalVoucher; @endphp
                            <table class=" box table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">';
                                <thead>
                                   <tr>
                                       <td><strong>Remaining</strong></td>
                                       <td>{{$totalVoucher }}</td>
                                   </tr>
                                </thead>
                           </table>
                        </div>
                @endif
                    </div>

                    <div class="p-5" >
                        @if(isset($transactions))

                           <h1 style="text-align: center; margin-top: 10px;"><strong>Other Payables</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</th>
                                            <th class="whitespace-nowrap">Amount</th>
                                            <th class="whitespace-nowrap">Payment</th>
                                            <th class="whitespace-nowrap">Remaining</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $totalOther = 0;
                                        @endphp
                                        @foreach($transactions as $row)
                                            @php
                                                $account = App\Models\ChartofAccount::where('id', $row->account_id)->first();
                                                $totalAmount = 0;
                                                $totalPayment = 0;
                                                $totalAmount +=  $row->amount;
                                                $totalPayment +=  $row->payment;
                                                $totalOther += $row->amount - $row->payment;
                                            @endphp
                                        <tr>
                                            <td>{{++$loop->index}}</td>
                                            <td>{{$row->title}}</td>
                                            <td>{{$account->name}}</td>
                                            <td>{{$row->amount}}</td>
                                            <td>{{$row->payment}}</td>
                                            <td>{{$row->amount - $row->payment}}</td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                                @php $total += $totalOther; @endphp
                                <table class=" box table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">';
                                    <thead>
                                       <tr>

                                           <td><strong>Remaining</strong></td>
                                           <td>{{$totalOther }}</td>

                                       </tr>
                                    </thead>
                               </table>
                            </div>
                            <br>
                            <table class=" box table table-bordered datatable" cellpadding="0" cellspacing="0" style="width:30%; float: right;">';
                                <thead>
                                   <tr>
                                       <td><strong>Total Remaining</strong></td>
                                       <td>{{round($total) }}</td>
                                   </tr>
                                </thead>
                           </table>
                    @endif
              </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