@extends('admin.layouts.main')

@section('title')
{{ trans('finance.petty_cash') }}
@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') }}</a></li>
					<li class="breadcrumb-item active" aria-current="page">{{ @trans('finance.petty_cash') }}</li>
				</ol>
			</nav>
			<div class="top-bar d-flex align-items-center">
				<h2>{{ @trans('finance.petty_cash') }}</h2>
				<div class="right-table-container ml-auto">
					<div class="right-table-container ml-auto">
						<form id="frmSearchPcMonth" action="{{ route('admin.petty-cash.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('petty-cash-write')
                            <a href="{{ route('admin.petty-cash.add',['panel' => Session::get('panel'), 'type' => 'credit']) }}"
                                class="btn btn-em btn-primary-em">{{ @trans('finance.create_credit_entry') }}</a>

                            <a href="{{ route('admin.petty-cash.add',['panel' => Session::get('panel'), 'type' => 'debit']) }}"
                                class="btn btn-em btn-primary-em">{{ @trans('finance.create_debit_entry') }}</a>
						@endpermission
						@permission('petty-cash-read')
							@if(count($pettyCashes) > 0)
								<a href="javascript:void()" class="btn btn-em btnExport" target="_blank">Export</a>
							@endif
						@endpermission
						<button class="btn btn-em scrollTableLeft pl-2 pr-2" title="Scoll Left"><i class="material-icons">chevron_left</i></button>
						<button class="btn btn-em scrollTableRight pl-2 pr-2" title="Scoll Right"><i class="material-icons">chevron_right</i></button>
					</div>
				</div>
			</div>
			<div class="table-wrapper">
				@if(count($pettyCashes) > 0 || $carriedOverAmounts['preview_entry_exist'])
					<div class="table-data">
						<div class="table-responsive three-col-fix table-bordered">
							<table class="table table-secondary" id="mtcTable">

								@include('admin.modules.finance.petty_cash.table_header')

								<tbody>
									<!-- start department wise rows -->
										@foreach($pettyCashes as $petty_cash)

											@php
												if(isset($credit_general_dept))
													$credit_general_dept += $petty_cash->credit_general;
												else
													$credit_general_dept = $petty_cash->credit_general;

												if(isset($debit_general_dept))
													$debit_general_dept += $petty_cash->debit_general;
												else
													$debit_general_dept = $petty_cash->debit_general;

												$totalTax = 0;
												$taxes = $petty_cash->taxes->pluck('tax_value', 'tax_title')->toArray();
												foreach($taxes as $key => $val) {
													if($petty_cash->tax_excluded_values && isset($petty_cash->tax_excluded_values[$key]) && $petty_cash->tax_excluded_values[$key] == 1) {
														$totalTax += $taxes[$key];
													}
												}

												if(isset($totalAmount[$petty_cash->entry_type])){
													$totalAmount[$petty_cash->entry_type] += getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax);
												} else {
													$totalAmount[$petty_cash->entry_type] = getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax);
												}

												if(isset($totalDebitTax) && $petty_cash->entry_type == 'debit') {
													$totalDebitTax += getPercentage($petty_cash['total_debit_amount'], $totalTax);
												} elseif($petty_cash->entry_type == 'debit') {
													$totalDebitTax = getPercentage($petty_cash['total_debit_amount'], $totalTax);
												}

												if($petty_cash->entry_type == 'credit') {
													$carriedOverAmounts[$petty_cash->payment_mode . 'BalanceAmount'] += getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax);
												} else if($petty_cash->entry_type == 'debit') {
													$carriedOverAmounts[$petty_cash->payment_mode . 'BalanceAmount'] -= getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax);
												}

											@endphp
											<tr>
												<td class="table-cl-red">{{ $petty_cash->date_formatted }}</td>
												<td class="table-cl-red">{{ $petty_cash->serial_number }}</td>
												<td class="table-cl-red">{{ ucfirst($petty_cash->payment_mode) }}</td>
												<td class="table-cl-red">{{ $petty_cash->short_description }}</td>
												<td class="table-cl-red">{{ $petty_cash->owner->full_name }}</td>
												@foreach ($taxList as $tax)
													<td class="table-cl-red text-right">{{ $petty_cash[$tax->tax_title] ? $petty_cash[$tax->tax_title] . '%' : '' }}</td>
												@endforeach
												<td class="table-cl-gray top-head text-right">
													{{ $petty_cash->credit_general ? number_format($petty_cash->credit_general, 2) : '' }}
												</td>
												@foreach($departments as $department)
													@if($department->subdepts_count > 0)
														@foreach($department->subdepts as $sub_dept)
															@php
																if(isset($subDeptTotal[$petty_cash->entry_type][$sub_dept->id])){
																	$subDeptTotal[$petty_cash->entry_type][$sub_dept->id] += getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_sub_split_' . $sub_dept->id], $totalTax);
																} else {
																	$subDeptTotal[$petty_cash->entry_type][$sub_dept->id] = getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_sub_split_' . $sub_dept->id], $totalTax);
																}

																if(isset($subDepttotalDebitTax[$sub_dept->id]) && $petty_cash->entry_type == 'debit') {
																	$subDepttotalDebitTax[$sub_dept->id] += getPercentage($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax);
																} elseif($petty_cash->entry_type == 'debit') {
																	$subDepttotalDebitTax[$sub_dept->id] = getPercentage($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax);
																}
															@endphp
															<td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif top-head text-right">
																{{ isset($petty_cash['credit_sub_split_' . $sub_dept->id])
																? number_format(getPercentageAndAdd($petty_cash['credit_sub_split_' . $sub_dept->id], $totalTax), 2)
																:  ''}}
															</td>
															<td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif top-head text-right">
																{{ isset($petty_cash['debit_sub_split_' . $sub_dept->id])
																? number_format(getPercentageAndAdd($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax), 2)
																: '' }}
															</td>
														@endforeach
													@elseif ($petty_cash['credit_split_' . $department->id] != null || $petty_cash['debit_split_' . $department->id] != null)
														@php
															if(isset($deptTotal[$petty_cash->entry_type][$department->id])){
																$deptTotal[$petty_cash->entry_type][$department->id] += getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_split_' . $department->id], $totalTax);
															} else {
																$deptTotal[$petty_cash->entry_type][$department->id] = getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_split_' . $department->id], $totalTax);
															}

															if(isset($deptTotalDebitTax[$department->id]) && $petty_cash->entry_type == 'debit') {
																$deptTotalDebitTax[$department->id] += getPercentage($petty_cash['debit_split_' . $department->id], $totalTax);
															} elseif($petty_cash->entry_type == 'debit') {
																$deptTotalDebitTax[$department->id] = getPercentage($petty_cash['debit_split_' . $department->id], $totalTax);
															}
														@endphp
														<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right">
															{{ isset($petty_cash['credit_split_' . $department->id])
															? number_format(getPercentageAndAdd($petty_cash['credit_split_' . $department->id], $totalTax), 2)
															: '' }}
														</td>
														<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right">
															{{ isset($petty_cash['debit_split_' . $department->id])
															? number_format(getPercentageAndAdd($petty_cash['debit_split_' . $department->id], $totalTax), 2)
															: '' }}
														</td>
													@else
														<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right"></td>
														<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right"></td>
													@endif
												@endforeach
												<td class="table-cl-gray top-head text-right">{{ $petty_cash->debit_general }}</td>
												<td class="table-cl-green top-head text-right">
													{{ isset($petty_cash->total_credit_amount)
													? number_format(getPercentageAndAdd($petty_cash->total_credit_amount, $totalTax), 2)
													: '' }}
												</td>
												<td class="table-cl-green top-head text-right">
													{{ isset($petty_cash->total_debit_amount)
													? number_format(getPercentageAndAdd($petty_cash->total_debit_amount, $totalTax), 2)
													: '' }}
												</td>
												<td class="table-cl-red top-head text-right">
													{{ isset($carriedOverAmounts['cashBalanceAmount']) ? number_format($carriedOverAmounts['cashBalanceAmount'], 2) : '' }}
												</td>
												<td class="table-cl-blue top-head text-right">
													{{ isset($carriedOverAmounts['digitalBalanceAmount']) ? number_format($carriedOverAmounts['digitalBalanceAmount'], 2) : '' }}
												</td>
												<td class="table-cl-red top-head text-right">
													{{ isset($carriedOverAmounts['cardBalanceAmount']) ? number_format($carriedOverAmounts['cardBalanceAmount'], 2) : '' }}
												</td>
												<td class="act-btn text-left">

													@permission('petty-cash-write')
														@if($petty_cash->payment_response == null)
															<a href="{{ route('admin.petty-cash.add',['panel' => Session::get('panel'),
																'type' => $petty_cash->entry_type, 'id' => $petty_cash->id]) }}" title="Edit" class="btn btn-edit">
																<i class="material-icons">edit</i>
															</a>
														@endif
													@endpermission



													@if ($petty_cash->entry_type == 'debit' && $petty_cash->payment_mode == 'digital'
																&& $petty_cash->debit_type == 'expense' && $petty_cash->payment_response == null
                                                                && (!Auth::user()->franchise || !in_array(Auth::user()->franchise->countries->name, config('custom.allow_only_finance_countries'))))
														@permission('petty-cash-write')
															<a href="javascript:void(0)" title="Pay Now" class="btn btn-paid" data-id="{{ $petty_cash->id }}">
																<i class="material-icons">monetization_on</i>
															</a>
														@endpermission
													@elseif($petty_cash->entry_type == 'debit' && $petty_cash->payment_mode == 'digital'
														&& $petty_cash->debit_type == 'expense' && $petty_cash->payment_response != null)
														@permission('petty-cash-read')
															<a href="javascript:void(0)" title="Receipt" class="btn btn-receipt" data-id="{{ $petty_cash->id }}">
																<i class="material-icons">receipt</i>
															</a>
														@endpermission
													@endif

												</td>
											</tr>
										@endforeach
									<!-- end department wise rows -->

									<!-- start total cr and dr wise -->
										<tr>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head">Total</td>
											@foreach ($taxList as $tax)
													<td class="table-cl-darkgray top-head text-right"></td>
											@endforeach
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-gray top-head text-right">
												{{ isset($credit_general_dept) ? number_format($credit_general_dept, 2) : ''}}
											</td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach($department->subdepts as $sub_dept)
														<td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif top-head text-right">
															{{ isset($subDeptTotal['credit'][$sub_dept->id]) && $subDeptTotal['credit'][$sub_dept->id] != 0 ? number_format($subDeptTotal['credit'][$sub_dept->id], 2) :'' }}
														</td>
														<td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif top-head text-right">
															{{ isset($subDeptTotal['debit'][$sub_dept->id]) && $subDeptTotal['debit'][$sub_dept->id] != 0 ? number_format($subDeptTotal['debit'][$sub_dept->id], 2) : '' }}
														</td>
													@endforeach
												@elseif($department->subdepts_count == 0)
													<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right">
														{{ isset($deptTotal['credit'][$department->id]) && $deptTotal['credit'][$department->id] != 0 ? number_format($deptTotal['credit'][$department->id], 2) :'' }}
													</td>
													<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right">
														{{ isset($deptTotal['debit'][$department->id]) && $deptTotal['debit'][$department->id] != 0 ? number_format($deptTotal['debit'][$department->id], 2) : '' }}
													</td>
												@endif
											@endforeach
											<td class="table-cl-gray top-head text-right">
												{{ isset($debit_general_dept) && $debit_general_dept != 0
												? number_format($debit_general_dept, 2)
												: ''}}
											</td>
											<td class="table-cl-green top-head text-right">
												{{ isset($totalAmount['credit']) ? number_format($totalAmount['credit'], 2) : '' }}
											</td>
											<td class="table-cl-green top-head text-right">
												{{ isset($totalAmount['debit']) ? number_format($totalAmount['debit'], 2) : '' }}
											</td>
											<td class="table-cl-red top-head text-right">
												{{ isset($carriedOverAmounts['cashBalanceAmount']) ? number_format($carriedOverAmounts['cashBalanceAmount'], 2) : '' }}
											</td>
											<td class="table-cl-blue top-head text-right">
												{{ isset($carriedOverAmounts['digitalBalanceAmount']) ? number_format($carriedOverAmounts['digitalBalanceAmount'], 2) : '' }}
											</td>
											<td class="table-cl-red top-head text-right">
												{{ isset($carriedOverAmounts['cardBalanceAmount']) ? number_format($carriedOverAmounts['cardBalanceAmount'], 2) : '' }}
											</td>
										</tr>
									<!-- end total cr and dr wise -->

									<!-- start total after subtreact dr into cr (subdepertment) -->
										<tr>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											@foreach ($taxList as $tax)
													<td class="table-cl-darkgray top-head text-right"></td>
											@endforeach
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-gray top-head text-right" rowspan="2">
												{{ isset($credit_general_dept) && $credit_general_dept != 0
												? number_format($credit_general_dept, 2)
												: ''}}
											</td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach($department->subdepts as $sub_dept)
														<td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif top-head text-right" colspan="2">
															@php
																if(isset($subDeptTotal['credit'][$sub_dept->id]) && isset($subDeptTotal['debit'][$sub_dept->id]))
																	$tempSubDeptTotal[$sub_dept->id] = $subDeptTotal['credit'][$sub_dept->id] - $subDeptTotal['debit'][$sub_dept->id];
																elseif(isset($subDeptTotal['credit'][$sub_dept->id]) && !isset($subDeptTotal['debit'][$sub_dept->id]))
																	$tempSubDeptTotal[$sub_dept->id] = $subDeptTotal['credit'][$sub_dept->id];
																elseif(!isset($subDeptTotal['credit'][$sub_dept->id]) && isset($subDeptTotal['debit'][$sub_dept->id]))
																	$tempSubDeptTotal[$sub_dept->id] = 0 - $subDeptTotal['debit'][$sub_dept->id];
																else
																	$tempSubDeptTotal[$sub_dept->id] = null;


																if(isset($deptSubTotal[$department->id])) {
																	$deptSubTotal[$department->id] += $tempSubDeptTotal[$sub_dept->id];
																} else {
																	$deptSubTotal[$department->id] = $tempSubDeptTotal[$sub_dept->id];
																}
															@endphp
															{{  isset($tempSubDeptTotal[$sub_dept->id]) && $tempSubDeptTotal[$sub_dept->id] != 0
															? number_format($tempSubDeptTotal[$sub_dept->id], 2)
															: '' }}
														</td>
													@endforeach
												@elseif($department->subdepts_count == 0)
													<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right" colspan="2">
														@php
															if(isset($deptTotal['credit'][$department->id]) && isset($deptTotal['debit'][$department->id]))
																$tempDeptTotal[$department->id] = $deptTotal['credit'][$department->id] - $deptTotal['debit'][$department->id];
															elseif(isset($deptTotal['credit'][$department->id]) && !isset($deptTotal['debit'][$department->id]))
																$tempDeptTotal[$department->id] = $deptTotal['credit'][$department->id];
															elseif(!isset($deptTotal['credit'][$department->id]) && isset($deptTotal['debit'][$department->id]))
																$tempDeptTotal[$department->id] = 0 - $deptTotal['debit'][$department->id];
															else
																$tempDeptTotal[$department->id] = null;

															if(isset($deptSubTotal[$department->id])) {
																$deptSubTotal[$department->id] += $tempDeptTotal[$department->id];
															} else {
																$deptSubTotal[$department->id] = $tempDeptTotal[$department->id];
															}
														@endphp
														{{ isset($tempDeptTotal[$department->id]) && $tempDeptTotal[$department->id] != 0
														? number_format($tempDeptTotal[$department->id], 2)
														: '' }}
													</td>
												@endif
											@endforeach
											<td class="table-cl-gray top-head text-right" rowspan="2">
												{{ isset($debit_general_dept) && $debit_general_dept != 0
												? number_format($debit_general_dept, 2)
												: ''}}
											</td>
											<td colspan="2" rowspan="2" class="table-cl-green top-head text-right">
												@php
													$tempSubEmpowerTotal = (isset($totalAmount['credit']) ? $totalAmount['credit'] : 0) - (isset($totalAmount['debit']) ? $totalAmount['debit'] : 0);
												@endphp
												{{ isset($tempSubEmpowerTotal) && $tempSubEmpowerTotal != 0
													? number_format($tempSubEmpowerTotal, 2)
													: ''}}
											</td>
										</tr>
									<!-- end total after subtreact dr into cr (subdepertment) -->

									<!-- start total after subtreact dr into cr (department) -->
										<tr>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											<td class="table-cl-darkgray top-head text-right"></td>
											@foreach ($taxList as $tax)
													<td class="table-cl-darkgray top-head text-right"></td>
											@endforeach
											<td class="table-cl-darkgray top-head text-right"></td>
											@foreach ($departments as $department)
												<td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif top-head text-right"
													colspan="{{ (($department->subdepts_count != 0) ?  $department->subdepts_count : 1) * 2 }}">
													{{ isset($deptSubTotal[$department->id]) && $deptSubTotal[$department->id] != 0
													? number_format($deptSubTotal[$department->id], 2)
													: '' }}
												</td>
											@endforeach
										</tr>
									<!-- end total after subtreact dr into cr (department) -->

									<tr>
										<td class="top-head border-0"></td>
									</tr>

									<!-- start total cr rows -->
										<tr>
											<td class="top-head border-0" colspan="{{ 6 + $taxList->count() }}"></td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach ($department->subdepts as $sub_dept)
														<td class="top-head">Total CR</td>
														<td class="top-head text-right">
															{{ isset($subDeptTotal['credit'][$sub_dept->id]) && $subDeptTotal['credit'][$sub_dept->id] != 0 ? number_format($subDeptTotal['credit'][$sub_dept->id], 2) :'' }}
														</td>
													@endforeach
												@elseif ($department->subdepts_count == 0)
													<td class="top-head">Total CR</td>
													<td class="top-head text-right">
														{{ isset($deptTotal['credit'][$department->id]) && $deptTotal['credit'][$department->id] != 0 ? number_format($deptTotal['credit'][$department->id], 2) :'' }}
													</td>
												@endif
											@endforeach
											<td class="top-head border-0"></td>
											<td class="top-head">Total CR</td>
											<td class="top-head text-right">
												{{ isset($totalAmount['credit']) ? number_format($totalAmount['credit'], 2) : '' }}
											</td>
										</tr>
									<!--  total cr rows -->

									<tr>
										<td class="top-head  border-0"></td>
									</tr>

									<!-- start total dr rows -->
										<tr>
											<td class="top-head border-0" colspan="{{ 6 + $taxList->count() }}"></td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach ($department->subdepts as $sub_dept)
														<td class="top-head">Total DR</td>
														<td class="top-head text-right">
															{{ isset($subDeptTotal['debit'][$sub_dept->id]) && $subDeptTotal['debit'][$sub_dept->id] != 0 ? number_format($subDeptTotal['debit'][$sub_dept->id], 2) :'' }}
														</td>
													@endforeach
												@elseif ($department->subdepts_count == 0)
													<td class="top-head">Total DR</td>
													<td class="top-head text-right">
														{{ isset($deptTotal['debit'][$department->id]) && $deptTotal['debit'][$department->id] != 0 ? number_format($deptTotal['debit'][$department->id], 2) :'' }}
													</td>
												@endif
											@endforeach
											<td class="top-head border-0"></td>
											<td class="top-head">Total DR</td>
											<td class="top-head text-right">
												{{ isset($totalAmount['debit']) ? number_format($totalAmount['debit'], 2) : '' }}
											</td>
										</tr>
									<!-- end total dr rows -->

									<!-- start total dr vat excl rows -->
										<tr>
											<td class="top-head border-0" colspan="{{ 6 + $taxList->count() }}"></td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach ($department->subdepts as $sub_dept)
														<td class="top-head">DR Vat Excl</td>
														<td class="top-head text-right">
															@php
																$tempTotalExcl = 0;
																$tempTotalDr = isset($subDeptTotal['debit'][$sub_dept->id]) ? $subDeptTotal['debit'][$sub_dept->id] : 0;
																$tempTotalTax = isset($subDepttotalDebitTax[$sub_dept->id]) ? $subDepttotalDebitTax[$sub_dept->id] : 0;
																$subDeptDebitTaxExcl[$sub_dept->id] = $tempTotalDr - $tempTotalTax;
															@endphp
															{{ isset($subDeptDebitTaxExcl[$sub_dept->id]) &&  $subDeptDebitTaxExcl[$sub_dept->id] != 0 ?
															number_format($subDeptDebitTaxExcl[$sub_dept->id], 2)
															: '' }}
														</td>
													@endforeach
												@elseif ($department->subdepts_count == 0)
													<td class="top-head">DR Vat Excl</td>
													<td class="top-head text-right">
														@php
															$tempTotalExcl = 0;
															$tempTotalDr = isset($deptTotal['debit'][$department->id]) ? $deptTotal['debit'][$department->id] : 0;
															$tempTotalTax = isset($deptTotalDebitTax[$department->id]) ? $deptTotalDebitTax[$department->id] : 0;
															$deptDebitTaxExcl[$department->id] = $tempTotalDr - $tempTotalTax;
														@endphp
														{{ isset($deptDebitTaxExcl[$department->id]) &&  $deptDebitTaxExcl[$department->id] != 0
														? number_format($deptDebitTaxExcl[$department->id], 2)
														: '' }}
													</td>
												@endif
											@endforeach
											<td class="top-head border-0"></td>
											<td class="top-head">DR Vat Excl</td>
											<td class="top-head text-right">
												@php
													$tempTotalExcl = 0;
													$tempTotalDr = isset($totalAmount['debit']) ? $totalAmount['debit'] : 0;
													$tempTotalTax = isset($totalDebitTax) ? $totalDebitTax : 0;
													$totalTaxExcl = $tempTotalDr - $tempTotalTax;
												@endphp
												{{ isset($totalTaxExcl) &&  $totalTaxExcl != 0
												? number_format($totalTaxExcl, 2)
												: '' }}
											</td>
										</tr>
									<!-- end total dr vat excl rows -->

									<!-- start dr vat rows -->
										<tr>
											<td class="top-head border-0" colspan="{{ 6 + $taxList->count() }}"></td>
											@foreach ($departments as $department)
												@if($department->subdepts_count > 0)
													@foreach ($department->subdepts as $sub_dept)
														<td class="top-head">DR VAT</td>
														<td class="top-head text-right">
															{{ isset($subDepttotalDebitTax[$sub_dept->id]) &&  $subDepttotalDebitTax[$sub_dept->id] != 0 ?
															number_format($subDepttotalDebitTax[$sub_dept->id], 2)
															: '' }}
														</td>
													@endforeach
												@elseif ($department->subdepts_count == 0)
													<td class="top-head">DR VAT</td>
													<td class="top-head text-right">
														{{ isset($deptTotalDebitTax[$department->id]) &&  $deptTotalDebitTax[$department->id] != 0 ?
														number_format($deptTotalDebitTax[$department->id], 2)
														: '' }}
													</td>
												@endif
											@endforeach
											<td class="top-head border-0"></td>
											<td class="top-head">DR VAT</td>
											<td class="top-head text-right">
												{{ isset($totalDebitTax) && $totalDebitTax != 0
												? number_format($totalDebitTax, 2)
												: '' }}
											</td>
										</tr>
									<!-- end dr vat rows -->

									<tr>
										<td class="top-head border-0"></td>
									</tr>

									<tr>
										<td class="top-head border-0" colspan="{{ 6 + $taxList->count() }}"></td>
										@foreach ($departments as $department)
											@if ($department->subdepts_count > 0)
												@foreach ($department->subdepts as $sub_dept)
													@php
														$tempTotalPl = 0;
														$tempTotalCr = isset($subDeptTotal['credit'][$sub_dept->id]) ? $subDeptTotal['credit'][$sub_dept->id] : 0;
														$tempTotalDr = isset($subDeptDebitTaxExcl[$sub_dept->id]) ? $subDeptDebitTaxExcl[$sub_dept->id] : 0;
														$tempTotalPl = $tempTotalCr - $tempTotalDr;
													@endphp
													<td class="top-head">Total P/L</td>
													<td class="top-head text-right">
														{{ isset($tempTotalPl) && $tempTotalPl != 0
														?	number_format($tempTotalPl, 2)
														: '' }}
													</td>
												@endforeach
											@elseif ($department->subdepts_count == 0)
												@php
													$tempTotalPl = 0;
													$tempTotalCr = isset($deptTotal['credit'][$department->id]) ? $deptTotal['credit'][$department->id] : 0;
													$tempTotalDr = isset($deptDebitTaxExcl[$department->id]) ? $deptDebitTaxExcl[$department->id] : 0;
													$tempTotalPl = $tempTotalCr - $tempTotalDr;
												@endphp
												<td class="top-head">Total P/L</td>
												<td class="top-head text-right">
													{{ isset($tempTotalPl) && $tempTotalPl != 0
													?	number_format($tempTotalPl, 2)
													: '' }}
												</td>
											@endif
										@endforeach
										<td class="top-head border-0"></td>
										<td class="top-head">Total P/L</td>
										<td class="top-head text-right">
											@php
												$tempTotalPl = 0;
												$tempTotalCr = isset($totalAmount['credit']) ? $totalAmount['credit'] : 0;
												$tempTotalDr = isset($totalTaxExcl) ? $totalTaxExcl : 0;
												$tempTotalPl = $tempTotalCr - $tempTotalDr;
											@endphp
											{{ isset($tempTotalPl) && $tempTotalPl != 0
											?	number_format($tempTotalPl, 2)
											: '' }}
										</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>
		</div>
	</div>
</main>
@endsection

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

		// snackbar message
		@if(Session::has('message'))
			Snackbar.show({
				pos: 'bottom-right',
				text: "{!! session('message') !!}",
				actionText: 'Okay'
			});
		@endif

		// freeze tables
		$(".table-data .table-responsive").freezeTable({
			'columnNum': 3,
			'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();
		});

		$('.btn-paid').click(function() {
			var pcId = $(this).attr('data-id');
			$('#frmApprovePcPayment #pettyCashId').val(pcId);
			$('#modalApproveConfirm').modal('show');
		});

		@if(Session::has('insufficent_balance'))
			$('.show_wallet_balance_error').html('{{ Session::get("insufficent_balance") }}');
			$('#modalShowError').modal('show');
		@endif

		$('.submit_approve_payment').on('click', function(){
			$('.submit_approve_payment').addClass('disabled');
			$('.submit_approve_payment').text('Please Wait...');
			$('#frmApprovePcPayment').submit();
		});

		$('.btn-receipt').click(function() {
			axios.get(get_receiptUrl + '/' + $(this).data('id'))
                .then(function (response) {

					$('.receipt_trans_id').text(response.data.trans_id);
					$('.receipt_reference_id').text(response.data.reference_id);
					$('.receipt_phone').text(response.data.phone);
					$('.receipt_amount').text(response.data.amount);
                    $('#modalReceipt').modal();
                });
		});

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

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

@push('pageModals')
	<div class="modal" tabindex="-1" role="dialog" id="modalApproveConfirm">
		<div class="modal-dialog modal-dialog-centered" role="document">
			<div class="modal-content">
				<form id="frmApprovePcPayment" method="post" action="{{ route('admin.petty-cash.approve-payment',['panel' => session('panel')]) }}">
					@csrf
					<input type="hidden" id="pettyCashId" name="pettyCashId" value="" />
					<div class="modal-header">
						<h5 class="modal-title">{{ @trans('finance.confirm') }}</h5>
						<button type="button" class="close" data-dismiss="modal" aria-label="Close">
							<span aria-hidden="true">&times;</span>
						</button>
					</div>
					<div class="modal-body">
						<p>Are you sure you want to send a digital wallet payment to the receiver?</p>
					</div>
					<div class="modal-footer d-flex justify-content-between">
						<button type="button" class="btn btn-cncl" data-dismiss="modal">{{ @trans('finance.cancel') }}</button>
						<button type="button" class="btn btn-success submit_approve_payment">{{ @trans('finance.approve') }}</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<div class="modal" tabindex="-1" role="dialog" id="modalShowError">
		<div class="modal-dialog modal-dialog-centered modal-confirm" role="document">
			<div class="modal-content">
				<div class="modal-body">
					<button type="button" class="close" data-dismiss="modal" aria-label="Close">
						<span aria-hidden="true">&times;</span>
					</button>
				</div>
				<div class="modal-body text-center">
					<div class="icon-box">
						<i class="material-icons"></i>
						<i class="material-icons"></i>
						<i class="material-icons"></i>
					</div>
				</div>
				<div class="modal-body text-center">
					<h4 class="show_wallet_balance_error"></h4>
				</div>
			</div>
		</div>
	</div>
	<div class="modal" tabindex="-1" role="dialog" id="modalReceipt">
		<div class="modal-dialog modal-dialog-centered" role="document">
			<div class="modal-content">
				<div class="modal-header">
					<h5 class="modal-title">Receipt</h5>
					<button type="button" class="close" data-dismiss="modal" aria-label="Close">
						<span aria-hidden="true">&times;</span>
					</button>
				</div>
				<div class="modal-body">
					<table style="width: 100%;">
						<tr style="height: 45px;">
							<td width="50%" class="h6">Transfer No</td>
							<td class="receipt_trans_id h6"></td>
						</tr>
						<tr style="height: 45px;">
							<td width="50%" class="h6">Reference No</td>
							<td class="receipt_reference_id h6"></td>
						</tr>
						<tr style="height: 45px;">
							<td width="50%" class="h6">Receiver Number</td>
							<td class="receipt_phone h6"></td>
						</tr>
						<tr style="height: 45px;">
							<td width="50%" class="h6">Amount</td>
							<td class="receipt_amount h6"></td>
						</tr>
					</table>
				</div>
			</div>
		</div>
	</div>
@endpush