@extends('admin.layouts.main')

@section('title')
    {{ trans('finance.vat_log') }}
@endsection

@section('content')
    <main>
        <loading :active.sync="isLoading"></loading>
        <div class="two-col">

            @include('admin.common.sidebar')

            <div class="right-sec">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0)">{{ @trans('finance.finance_reports') }}</a></li>
                        <li class="breadcrumb-item active" aria-current="page">{{ @trans('finance.vat_log') }}</li>
                    </ol>
                </nav>

                <div class="top-bar d-flex align-items-center">
                    <h2>{{ @trans('finance.vat_log_report') }}</h2>
                    <div class="right-table-container ml-auto">
                        <div class="right-table-container ml-auto">
                            <form id="frmSearchPcMonth" action="{{ route('admin.vat-log.index',['panel' => session('panel')])}}">
                                <input type="hidden" name="month" id="month_filter" value="" />
                            </form>
                            <label class="pt-2 pr-2" style="font-size: 14px;">(Amounts are in TZS)</label>
                            <div class="date">
                                <div class="input-group">
                                    <input type="text" class="form-control bg-white" id="cal_month_filter" name="cal_month_filter" placeholder="Select" autocomplete="off" readonly
                                        value="{{ \Carbon\Carbon::parse($dates['year'] . '-' . $dates['month'])->format('m/Y') }}">
                                    <div class="input-group-addon">
                                        <span class="material-icons">date_range</span>
                                    </div>
                                </div>
                            </div>
                            @permission('vat-log-read')
                                @if(count($vatLogs) > 0)
                                    <a href="javascript:void()" class="btn btn-em btnExport ml-4" target="_blank">Export</a>
                                @endif
                            @endpermission
                        </div>
                    </div>
                </div>
                <div class="table-wrapper">
                    @if(count($vatLogs))
                        <div class="table-data first-col-fix">
                            <div class="table-responsive table-bordered">
                                <table class="table" id="mtcTable">
                                    <thead>
                                        <tr>
                                            <th>PV / PC Number</th>
                                            <th>VRN</th>
                                            <th>Company Name</th>
                                            <th>Receipt Invoice Number</th>
                                            <th>Date</th>
                                            <th>Description</th>
                                            <th>VAT Exclusive</th>
                                            <th>VAT</th>
                                            <th>VAT Inclusive</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $vatExclusive = 0;
                                            $vatAmount = 0;
                                            $grossAmount = 0;
                                        @endphp
                                        @foreach($vatLogs as $vat_log)
                                            @php
                                                $vatExclusive += ($vat_log->is_payment_voucher) ? $vat_log->total_amount_converted : $vat_log->total_amount;
                                                $vatAmount += $vat_log->vat_amount;
                                                $grossAmount += ($vat_log->is_payment_voucher) ?
                                                                ($vat_log->total_amount_converted + $vat_log->vat_amount) :
                                                                ($vat_log->total_amount + $vat_log->vat_amount);
                                            @endphp
                                            <tr>
                                                <td>
                                                    @if($vat_log->is_payment_voucher)
                                                        PV{{ $vat_log->pv_serial_number ?? '' }}
                                                    @else
                                                        PC{{ $vat_log->serial_number ?? '' }}
                                                    @endif
                                                </td>
                                                <td>{{ $vat_log->company->registrations[0]->registration_value ?? '' }}</td>
                                                <td>{{ $vat_log->company->name ?? '' }}</td>
                                                <td>
                                                    @if($vat_log->is_payment_voucher)
                                                        {{ $vat_log->lpo_receipt_invoice_number }}
                                                    @else
                                                        {{ $vat_log->receipt_number }}
                                                    @endif
                                                </td>
                                                <td>
                                                    @if($vat_log->is_payment_voucher)
                                                        {{ $vat_log->receipt_date_formatted }}
                                                    @else
                                                        {{ $vat_log->date_formatted }}
                                                    @endif
                                                </td>
                                                <td>
                                                    @if($vat_log->is_payment_voucher)
                                                        {{ $vat_log->description }}
                                                    @else
                                                        {{ $vat_log->short_description }}
                                                    @endif
                                                </td>
                                                <td class="text-right">
                                                    @if($vat_log->is_payment_voucher)
                                                        {{ number_format($vat_log->total_amount_converted, 2) }}
                                                    @else
                                                        {{ number_format($vat_log->total_amount, 2) }}
                                                    @endif
                                                </td>
                                                <td class="text-right">{{ number_format($vat_log->vat_amount, 2) }}</td>
                                                <td class="text-right">
                                                    @if($vat_log->is_payment_voucher)
                                                        {{ number_format(($vat_log->total_amount_converted + $vat_log->vat_amount), 2) }}
                                                    @else
                                                        {{ number_format(($vat_log->total_amount + $vat_log->vat_amount), 2) }}
                                                    @endif
                                                </td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="6" class="border-0"></td>
                                            <td class="text-right"><strong>{{ number_format($vatExclusive, 2) }}</strong></td>
                                            <td class="text-right"><strong>{{ number_format($vatAmount, 2) }}</strong></td>
                                            <td class="text-right"><strong>{{ number_format($grossAmount, 2) }}</strong></td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    @else
                        <div class="row">
                            <div class="col-md-12">
                                <div class="alert alert-warning" role="alert">
                                {{ @trans('finance.no_records_to_show') }}
                                </div>
                            </div>
                        </div>
                    @endif
                </div>
                @if(count($vatLogs) > 0 && count($departmentList) > 0)
                    <div class="top-bar d-flex align-items-center pt-5 pb-3">
                        <h2>{{ @trans('finance.vat_payable') }}</h2>
                    </div>
                    <div class="table-wrapper">
                        <div class="table-data first-col-fix">
                            <div class="table-responsive table-bordered">
                                <table class="table" id="mtcTable">
                                    <thead>
                                        <tr>
                                            <th rowspan="2" style="min-width: 190px;"></th>
                                            @foreach($departmentList as $dept)
                                                <th @if($dept->subdepts_count > 0) colspan="{{ $dept->subdepts_count }}" @endif class="text-center top-head
                                                    @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">{{ $dept->name }}</th>
                                            @endforeach
                                            <th rowspan="2" class="top-head text-center">Total</th>
                                        </tr>
                                        <tr>
                                            @foreach ($departmentList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach($dept->subdepts as $sub_dept)
                                                        <th class="text-center @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif"
                                                            style="min-width:120px;">{{ $sub_dept->name }}</th>
                                                    @endforeach
                                                @else
                                                    <th class="text-center @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif" style="min-width:120px;">-</th>
                                                @endif
                                            @endforeach
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Total Revenue (VAT)</td>
                                            @foreach($departmentList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach($dept->subdepts as $sub_dept)
                                                        <td class="text-right @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif">
                                                            @isset($vatLogRevenue['subdepts'][$sub_dept->id])
                                                                {{ number_format($vatLogRevenue['subdepts'][$sub_dept->id], 2) }}
                                                            @endisset
                                                        </td>
                                                    @endforeach
                                                @else
                                                    <td class="text-right @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">
                                                        @isset($vatLogRevenue['depts'][$dept->id])
                                                            {{ number_format($vatLogRevenue['depts'][$dept->id], 2) }}
                                                        @endisset
                                                    </td>
                                                @endif
                                            @endforeach
                                            <td class="text-right">
                                                @isset($vatLogRevenue['total'])
                                                    <strong>{{ number_format($vatLogRevenue['total'], 2) }}</strong>
                                                @endisset
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>Total Expense (VAT)</td>
                                            @foreach($departmentList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach($dept->subdepts as $sub_dept)
                                                        <td class="text-right @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif">
                                                            @isset($vatLogExpense['subdepts'][$sub_dept->id])
                                                                {{ number_format($vatLogExpense['subdepts'][$sub_dept->id], 2) }}
                                                            @endisset
                                                        </td>
                                                    @endforeach
                                                @else
                                                    <td class="text-right @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">
                                                        @isset($vatLogExpense['depts'][$dept->id])
                                                            {{ number_format($vatLogExpense['depts'][$dept->id], 2) }}
                                                        @endisset
                                                    </td>
                                                @endif
                                            @endforeach
                                            <td class="text-right">
                                                @isset($vatLogExpense['total'])
                                                    <strong>{{ number_format($vatLogExpense['total'], 2) }}</strong>
                                                @endisset
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>VAT Payable</td>
                                            @foreach($departmentList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach($dept->subdepts as $sub_dept)
                                                        <td class="text-right @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif">
                                                            @isset($vatLogRevenue['subdepts'][$sub_dept->id])
                                                                @php
                                                                    $tempPayable['sub_dept'][$sub_dept->id] = (isset($vatLogRevenue['subdepts'][$sub_dept->id]) ? $vatLogRevenue['subdepts'][$sub_dept->id] : 0)
                                                                                                            - (isset($vatLogExpense['subdepts'][$sub_dept->id]) ? $vatLogExpense['subdepts'][$sub_dept->id] : 0);

                                                                @endphp
                                                                @if($tempPayable['sub_dept'][$sub_dept->id] > 0)
                                                                    @php
                                                                        if(isset($totalVatPayable))
                                                                            $totalVatPayable += $tempPayable['sub_dept'][$sub_dept->id];
                                                                        else
                                                                            $totalVatPayable = $tempPayable['sub_dept'][$sub_dept->id];
                                                                    @endphp
                                                                    {{ number_format($tempPayable['sub_dept'][$sub_dept->id], 2) }}
                                                                @endif
                                                            @endisset
                                                        </td>
                                                    @endforeach
                                                @else
                                                    <td class="text-right @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">
                                                        @isset($vatLogRevenue['depts'][$dept->id])
                                                            @php
                                                                $tempPayable['dept'][$dept->id] = $vatLogRevenue['depts'][$dept->id] -
                                                                                                    (isset($vatLogExpense['depts'][$dept->id]) ? $vatLogExpense['depts'][$dept->id] : 0);
                                                            @endphp
                                                            @if(isset($tempPayable['dept'][$dept->id]) && $tempPayable['dept'][$dept->id] > 0)
                                                                @php
                                                                    if(isset($totalVatPayable))
                                                                        $totalVatPayable += $tempPayable['dept'][$dept->id];
                                                                    else
                                                                        $totalVatPayable = $tempPayable['dept'][$dept->id];
                                                                @endphp
                                                                {{ number_format($tempPayable['dept'][$dept->id], 2) }}
                                                            @endif
                                                        @endisset
                                                    </td>
                                                @endif
                                            @endforeach
                                            <td class="text-right">
                                                @isset($totalVatPayable)
                                                    @if($totalVatPayable > 0)
                                                        <strong>{{ number_format($totalVatPayable, 2) }}</strong>
                                                    @endif
                                                @endisset
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>Allocation</td>
                                            @foreach($departmentList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach($dept->subdepts as $sub_dept)
                                                        <td class="text-right @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif">
                                                            @if(isset($vatLogRevenue['subdepts'][$sub_dept->id]) && isset($tempPayable['sub_dept'][$sub_dept->id]) && isset($totalVatPayable))
                                                                @php
                                                                    $tempPercentage = ($tempPayable['sub_dept'][$sub_dept->id] * 100) / $totalVatPayable;
                                                                @endphp
                                                                @if($totalVatPayable > 0 && $tempPercentage > 0)
                                                                    @php
                                                                        if(isset($totalPercentage))
                                                                            $totalPercentage += $tempPercentage;
                                                                        else
                                                                            $totalPercentage = $tempPercentage;
                                                                    @endphp
                                                                    {{ number_format($tempPercentage, 2) }}%
                                                                @endif
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                @else
                                                    <td class="text-right @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">
                                                        @if(isset($vatLogRevenue['depts'][$dept->id]) && isset($tempPayable['dept'][$dept->id]) && isset($totalVatPayable))
                                                            @php
                                                                $tempPercentage = ($tempPayable['dept'][$dept->id] * 100) / $totalVatPayable;
                                                            @endphp
                                                            @if($totalVatPayable > 0 && $tempPercentage > 0)
                                                                @php
                                                                    if(isset($totalPercentage))
                                                                        $totalPercentage += $tempPercentage;
                                                                    else
                                                                        $totalPercentage = $tempPercentage;
                                                                @endphp
                                                                {{ number_format($tempPercentage, 2) }}%
                                                            @endif
                                                        @endif
                                                    </td>
                                                @endif
                                            @endforeach
                                            <td class="text-right">
                                                @if(isset($totalPercentage))
                                                <strong>{{ number_format(($totalPercentage > 100) ? '100.00' : $totalPercentage, 2) }}%</strong>
                                                @endif
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                @endif
            </div>
        </div>
    </main>
@endsection

@push('pageJs')
<script>
    var exportUrl =  '{{ route("admin.vat-log.export", ["panel" => Session::get("panel")]) }}';
	var exportUrlParams = ("{!! http_build_query($dates) !!}");
	$(document).ready(function() {

        // freeze tables
		// $(".table-data .table-responsive").freezeTable({
		// 	'columnNum': 1,
		// 	'scrollable': true,
		// });

		// $(window).resize(function() {
		// 	$(".table-data .table-responsive").freezeTable('update');
		// });

		// $(document).on('click', '.sidebar-icon', function() {
		// 	setTimeout(() => {
		// 		$(".table-data .table-responsive").freezeTable('update');
		// 	}, 500);
		// });

		// initialize month picker
		var today = new Date();
        var $calMonthFilter = $('#cal_month_filter');
        $calMonthFilter.datepicker({
            format: 'mm/yyyy',
            zIndex: 2048,
            autoHide: true,
            date: null,
            endDate: (today.getMonth() + 1) + '/' + today.getFullYear(),
        });

		$('#cal_month_filter').on('change', function() {
            app.isLoading = true
			$('#month_filter').val(moment($('#cal_month_filter').datepicker('getDate')).format('YYYY-MM'));
			$('#frmSearchPcMonth').submit();
		});

        // export petty cash
		$('.btnExport').attr('href', exportUrl + '?' + exportUrlParams);
	});

    var app = new Vue({
        el: '#app',
        data: {
            isLoading: false,
        }
    });
</script>
@endpush