@extends(\Auth::user()->role != 10 ? 'layout' : 'layoutfrontdesk')

@section('title', 'Account Payable Aging List')

@section('css')
<style type="text/css">
	.datatable-column-width{
		overflow: hidden; text-overflow: ellipsis; max-width: 200px;
	}
    #company_id{
        width:12.5rem;
    }
</style>
@endsection

@section('content')

	<!-- Page header -->
	<div class="page-header {{in_array(\Auth::user()->role, [1,2]) ? 'page-header-light' : ''}}">
		<div class="page-header-content header-elements-md-inline">
			<div class="page-title d-flex">
				<h4>  <span class="font-weight-semibold">Account Payable Aging List</span></h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>
			<div class="d-flex">
				<div class="btn-group" role="group">
				  <a href="{{ url('account-payable/aging-list') }}" class="btn btn-primary mr-1 {{ (!isset($_GET['view'])) || ($_GET['view']) == ""  ? 'active font-weight-bolder' : '' }}">Group By Company</a>
				  <a href="{{ url('account-payable/aging-list') }}?view=withdetail" class="btn btn-primary mr-1 {{ isset($_GET['view']) ? ($_GET['view'] == 'withdetail' ? 'active font-weight-bolder' : '') : '' }}">AP Aging With Detail</a>
				  <div class="dropdown">
					  <button class="btn btn-primary {{ isset($_GET['view']) ? ($_GET['view'] == 'withpreviousbalance' ? 'active font-weight-bolder' : '') : '' }} dropdown-toggle" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
					    AP Aging With Previous Balance
					  </button>
					  <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
					    <a class="dropdown-item" href="{{ url('account-payable/aging-list') }}?view=withpreviousbalance&detail=1">Detail</a>
					    <a class="dropdown-item" href="{{ url('account-payable/aging-list') }}?view=withpreviousbalance&detail=0">Summary</a>
					  </div>
				  </div>
			  </div>
			</div>
		</div>
	</div>
	<!-- /page header -->

	<!-- Content area -->
	<div class="content">
		<form method="GET" id="form-filter-payment-date">
			<input type="hidden" name="view" value="{{ isset($_GET['view']) ? $_GET['view'] : '' }}">
			<input type="hidden" name="detail" value="{{ isset($_GET['detail']) ? $_GET['detail'] : '' }}">
			<div class="row mb-2 justify-content-between">
				<div class="d-flex pl-2">
					<label class="col-form-label mr-2" style="white-space: nowrap" for="payment_date_filter"><b>Payment Date</b></label>
					<input type="text" name="payment_date_filter" class="form-control" id="payment_date_filter" autocomplete="off">
				</div>

                @php
                $filter_date = $_GET['payment_date_filter'] ?? '';
                $company_id = $_GET['company_id'] ?? '';
                @endphp

				<div class="d-flex pr-2">
					<label class="col-form-label mr-2 font-weight-bolder">Company: </label>
					<div class="mr-1">
						<select name="company_id" id="company_id" onchange="onchangeCompany()" class="form-control form-control-select2">
							<option value="">-- Select Company --</option>
							<option value="0" {{ $company_id == '0' ? 'selected' : '' }}>-- Empty Recipient --</option>
                            @foreach($companies as $company)
                            <option value="{{ $company->id }}" {{ $company_id == $company->id ? 'selected' : '' }}>{{ $company->company_title.' '.$company->company_name }}</option>
                            @endforeach
						</select>
					</div>
					<div>
						<a id="print_ap_payment_list"
						   href="{{ route('account-payable.print-aging') }}?{{ isset($_GET['view']) ? 'view='.$_GET['view']."&" : "" }}{{ isset($_GET['detail']) ? 'detail='.$_GET['detail']."&" : "" }}payment_date_filter={{ $filter_date }}&company_id={{ $company_id }}"
						   class="btn btn-danger"
						   target="_blank"
						>
							<i class="fa fa-file-pdf"></i>&nbsp;
							Print
						</a>
						<a id="export_ap_payment_list"
						   href="{{ route('account-payable.export-aging') }}?{{ isset($_GET['view']) ? 'view='.$_GET['view']."&" : "" }}{{ isset($_GET['detail']) ? 'detail='.$_GET['detail']."&" : "" }}payment_date_filter={{ $filter_date }}&company_id={{ $company_id }}"
						   class="btn btn-success"
						>
							<i class="fa fa-file-excel"></i>&nbsp;
							Export
						</a>
					</div>
				</div>
			</div>
		</form>
        <div class="card">
			@php
			$view = isset($_GET['view']) ? $_GET['view'] : '';

			//Untuk with previous balance dengan detail
			$detail = isset($_GET['detail']) ? $_GET['detail'] : '';
			@endphp
            <table class="table table-hover">
                <thead>
                    <tr>
                        <th style="width: 10px">#</th>
                        <th>Name</th>
						@if(!$view || $detail == '0')
							@if($detail == '0')
							<th style="text-align: right">Prev Balance</th>
							<th style="text-align: right">Debit</th>
							<th style="text-align: right">Credit</th>
							<th style="text-align: right">Ending </th>
							@else
							<th style="text-align: right">Outstanding</th>
							@endif
                        <th style="text-align: right">30 Days</th>
                        <th style="text-align: right">31 - 60 Days</th>
                        <th style="text-align: right">61 - 90 Days</th>
                        <th style="text-align: right">OVER 90 Days</th>
						@else
						<th>Transaction Date</th>
						<th style="text-align: right">Document No</th>
							@if($view == 'withpreviousbalance')
							<th style="text-align: right">Prev Balance</th>
							<th style="text-align: right">Debit</th>
							<th style="text-align: right">Credit</th>
							<th style="text-align: right">Ending </th>
							@else
							<th style="text-align: right">Balance </th>
							@endif
						<th style="text-align: right">30 Days</th>
                        <th style="text-align: right">31 - 60 Days</th>
                        <th style="text-align: right">61 - 90 Days</th>
                        <th style="text-align: right">OVER 90 Days</th>
						@endif
                    </tr>
                </thead>
                <tbody>
                    @php
					$no = 1;

					if(!$view || $detail == '0'){
						$grand_prev_balance = 0;
						$grand_debit = 0;
						$grand_credit = 0;
						$grand_outstanding = 0;
					}
					else{
						$grand_prev_balance = 0;
						$grand_debit = 0;
						$grand_credit = 0;
						$grand_ending_balance = 0;
					}

					$grand_days30 = 0;
					$grand_days60 = 0;
					$grand_days90 = 0;
					$grand_over = 0;
                    @endphp

					@if(count($aging_lists) > 0)
						@if(!$view || $detail == '0')
							@foreach($aging_lists as $header => $details)
							@php
							$no = 1;

							//Jika Dari AP Aging With Detail Summary
							if($detail == '0'){
								$total_prev_balance = 0;
								$total_debit = 0;
								$total_credit = 0;
							}

							$total_outstanding = 0;
							$total_days30 = 0;
							$total_days60 = 0;
							$total_days90 = 0;
							$total_over90days = 0;
							@endphp
							<tr>
								<td colspan="{{ $detail == '0' ? '10' : '7'}}">
									@if($header != '0')
									<b>{{$header}}</b>
									@else
									<span class="text-danger"><b>Empty Recipient</b></span>
									@endif
								</td>
							</tr>
								@foreach($details as $key => $aging_list)

									@php
									//Menghitung Breakdown Dari AP Aging Detail
									if($detail == '0'){ //Jika Dari AP Aging with Previous Balance
										$prev_balance = array_sum($aging_list['prev_balance']);
										$debit = array_sum($aging_list['debit']);
										$credit = array_sum($aging_list['credit']);
									}
									$outstanding = array_sum($aging_list['outstanding']);
									$days30 = array_sum($aging_list['30days']);
									$days60 = array_sum($aging_list['60days']);
									$days90 = array_sum($aging_list['90days']);
									$over90days = array_sum($aging_list['over90days']);

									//Menghitung Total Dari Record per group
									if($detail == '0'){ //Jika Dari AP Aging With previous Balance
										$total_prev_balance += $prev_balance;
										$total_debit += $debit;
										$total_credit += $credit;
									}
									$total_outstanding += $outstanding;
									$total_days30 += $days30;
									$total_days60 += $days60;
									$total_days90 += $days90;
									$total_over90days += $over90days;

									//Menghitung total keseluruhan
									if($detail == '0'){ //Jika dari AP Aging With Previous Balance
										$grand_prev_balance += $prev_balance;
										$grand_debit += $debit;
										$grand_credit += $credit;
									}
									$grand_outstanding += $outstanding;
									$grand_days30 += $days30;
									$grand_days60 += $days60;
									$grand_days90 += $days90;
									$grand_over += $over90days;
									@endphp
									<tr>
										<td>{{$no}}</td>
										<td>
											@if($key != '0')
											{{$key}}
											@else
											<span>Empty Recipient</span>
											@endif
										</td>
										@if($detail == '0')
										<td style="text-align: right">{{ number_format($prev_balance, 2) }}</td>
										<td style="text-align: right">{{ number_format($debit, 2) }}</td>
										<td style="text-align: right">{{ number_format($credit, 2) }}</td>
										@endif
										<td style="text-align: right">{{ number_format($outstanding, 2) }}</td>
										<td style="text-align: right">{{ number_format($days30, 2) }}</td>
										<td style="text-align: right">{{ number_format($days60, 2) }}</td>
										<td style="text-align: right">{{ number_format($days90, 2) }}</td>
										<td style="text-align: right">{{ number_format($over90days, 2) }}</td>
									</tr>
									@php
									$no++;
									@endphp
								@endforeach
							<tr>
								<td></td>
								<td><b>Total:</b></td>

								@if($detail == '0')
								<td style="text-align: right">{{ number_format($total_prev_balance, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_debit, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_credit, 2) }}</td>
								@endif

								<td style="text-align: right">{{ number_format($total_outstanding, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days30, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days60, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days90, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_over90days, 2) }}</td>
							</tr>
							<tr>
								<td></td>
								<td><b>Statistic Percentage (%):</b></td>

								@if($detail == '0')
								<td></td>
								<td></td>
								<td></td>
								@endif

								<td style="text-align: right">{{number_format(100, 2)}}</td>
								<td style="text-align: right">{{$total_days30 == 0 ? number_format(0, 2) : number_format(($total_days30/$total_outstanding) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_days60 == 0 ? number_format(0, 2) : number_format(($total_days60/$total_outstanding) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_days90 == 0 ? number_format(0, 2) : number_format(($total_days90/$total_outstanding) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_over90days == 0 ? number_format(0, 2) : number_format(($total_over90days/$outstanding) * 100, 2)}}</td>
							</tr>
							@endforeach
						@else
							@foreach($aging_lists as $key => $details)

								@php
								$no = 1;
								if($view){
									$total_prev_balance = 0;
									$total_debit = 0;
									$total_credit = 0;
								}
								$total_ending_balance = 0;
								$total_days30 = 0;
								$total_days60 = 0;
								$total_days90 = 0;
								$total_over90days = 0;
								@endphp

								<tr>
									<td colspan="{{ $view == 'withpreviousbalance' ? '12' : '9'}}">
										@if($key != '0')
										<b>{{$key}}</b>
										@else
										<span class="text-danger"><b>Empty Recipient</b></span>
										@endif
									</td>
								</tr>
								@foreach($details as $aging_list)
									@php
									if($view == 'withpreviousbalance'){
										$prev_balance = $aging_list['prev_balance'];
										$debit = $aging_list['debit'];
										$credit = $aging_list['credit'];
									}

									$ending_balance = $aging_list['ending_balance'];
									$days30 = $aging_list['30days'];
									$days60 = $aging_list['60days'];
									$days90 = $aging_list['90days'];
									$over90days = $aging_list['over90days'];

									if($view == 'withpreviousbalance'){
										$total_prev_balance += $prev_balance;
										$total_debit += $debit;
										$total_credit += $credit;
									}
									$total_ending_balance += $ending_balance;
									$total_days30 += $days30;
									$total_days60 += $days60;
									$total_days90 += $days90;
									$total_over90days += $over90days;

									if($view == 'withpreviousbalance'){
										$grand_prev_balance += $prev_balance;
										$grand_debit += $debit;
										$grand_credit += $credit;
									}
									$grand_ending_balance += $ending_balance;
									$grand_days30 += $days30;
									$grand_days60 += $days60;
									$grand_days90 += $days90;
									$grand_over += $over90days;
									@endphp
									<tr>
										<td>{{ $no }}</td>
										<td>
											@if($aging_list['supplier_name'] != '0')
											{{ $aging_list['supplier_name'] }}
											@else
											Empty Recipient
											@endif
										</td>
										<td>{{ $aging_list['invoice_date'] }}</td>
										<td style="text-align: right">
											{{ $aging_list['document_no'] }}
										</td>

										@if($view == 'withpreviousbalance')
										<td style="text-align: right">{{ number_format($prev_balance, 2) }}</td>
										<td style="text-align: right">{{ number_format($debit, 2) }}</td>
										<td style="text-align: right">{{ number_format($credit, 2) }}</td>
										@endif

										<td style="text-align: right">{{ number_format($ending_balance, 2) }}</td>
										<td style="text-align: right">{{ number_format($days30, 2) }}</td>
										<td style="text-align: right">{{ number_format($days60, 2) }}</td>
										<td style="text-align: right">{{ number_format($days90, 2) }}</td>
										<td style="text-align: right">{{ number_format($over90days, 2)}}</td>
									</tr>
									@php
									$no++;
									@endphp
								@endforeach
							<tr>
								<td></td>
								<td colspan="3"><b>Total:</b></td>

								@if($view == 'withpreviousbalance')
								<td style="text-align: right">{{ number_format($total_prev_balance, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_debit, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_credit, 2) }}</td>
								@endif

								<td style="text-align: right">{{ number_format($total_ending_balance, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days30, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days60, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_days90, 2) }}</td>
								<td style="text-align: right">{{ number_format($total_over90days, 2) }}</td>
							</tr>
							<tr>
								<td></td>
								<td colspan="3"><b>Statistic Percentage (%):</b></td>
								@if($view == 'withpreviousbalance')
								<td></td>
								<td></td>
								<td></td>
								@endif
								<td style="text-align: right">{{number_format(100, 2)}}</td>
								<td style="text-align: right">{{$total_days30 == 0 ? number_format(0, 2) : number_format(($total_days30/$total_ending_balance) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_days60 == 0 ? number_format(0, 2) : number_format(($total_days60/$total_ending_balance) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_days90 == 0 ? number_format(0, 2) : number_format(($total_days90/$total_ending_balance) * 100, 2)}}</td>
								<td style="text-align: right">{{$total_over90days == 0 ? number_format(0, 2) : number_format(($total_over90days/$total_ending_balance) * 100, 2)}}</td>
							</tr>

							@endforeach
						@endif
						<tr style="border-top: solid 3px lightgrey; background-color: #F7F7F7; font-weight: bolder;">
							<td></td>
							@if(!$view || $detail == '0')
								<td style="font-weight: bold">Grand Total</td>
								@if($detail == '0')
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								@endif
								<td style="text-align: right">{{ number_format($grand_outstanding, 2) }}</td>
								@php
								$grandtotal = $grand_outstanding;
								@endphp
							@else
								<td style="font-weight: bold" colspan="3">Grand Total</td>

								@if($view == 'withpreviousbalance')
								<td style="text-align: right">{{ number_format($grand_prev_balance, 2) }}</td>
								<td style="text-align: right">{{ number_format($grand_debit, 2) }}</td>
								<td style="text-align: right">{{ number_format($grand_credit, 2) }}</td>
								@endif

								<td style="text-align: right">{{ number_format($grand_ending_balance, 2) }}</td>

								@php
								$grandtotal = $grand_ending_balance;
								@endphp
							@endif
							<td style="text-align: right">{{number_format($grand_days30, 2)}}</td>
							<td style="text-align: right">{{number_format($grand_days60, 2)}}</td>
							<td style="text-align: right">{{number_format($grand_days90, 2)}}</td>
							<td style="text-align: right">{{number_format($grand_over, 2)}}</td>
						</tr>
						<tr style="background-color: #F7F7F7; font-weight: bolder;">
							<td></td>
							@if(!$view || $detail == '0')
								<td style="font-weight: bold">Grand Total Percentage</td>
								@if($detail == '0')
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								@endif
								<td style="text-align: right">{{ number_format(100, 2) }}</td>
							@else
								<td style="font-weight: bold" colspan="3">Grand Total Percentage (%)</td>
								@if($view == 'withpreviousbalance')
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								<td style="text-align: right"></td>
								@endif
								<td style="text-align: right">{{ number_format(100, 2) }}</td>
							@endif
							<td style="text-align: right">{{$grand_days30 == 0 ? number_format(0, 2) : number_format(($grand_days30 / $grandtotal) * 100, 2)}}</td>
							<td style="text-align: right">{{$grand_days60 == 0 ? number_format(0, 2) : number_format(($grand_days60 / $grandtotal) * 100, 2)}}</td>
							<td style="text-align: right">{{$grand_days90 == 0 ? number_format(0, 2) : number_format(($grand_days90 / $grandtotal) * 100, 2)}}</td>
							<td style="text-align: right">{{$grand_over == 0 ? number_format(0, 2) : number_format(($grand_over / $grandtotal) * 100, 2)}}</td>
						</tr>
					@else
						@if($view == 'withpreviousbalance')
						<tr>
							<td colspan="12" style="text-align: center">Data not available</td>
						</tr>
                        @elseif($view == 'withdetail')
						<tr>
							<td colspan="9" style="text-align: center">Data not available</td>
						</tr>
						@else
						<tr>
							<td colspan="7" style="text-align: center">Data not available</td>
						</tr>
						@endif
					@endif
                </tbody>
            </table>
        </div>
        <!-- /hover rows -->
	</div>
	<!-- /content area -->
@endsection

@section('js')
	<!-- Theme JS files -->
	<script src="{{asset('global_assets/js/plugins/notifications/pnotify.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/notifications/bootbox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/tables/datatables/datatables.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/selects/select2.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/spin.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/ladda.min.js')}}"></script>
    <script src="{{asset('global_assets/js/plugins/media/fancybox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/styling/uniform.min.js')}}"></script>

	<!-- JS Date Picker -->
	<!-- <script src="{{asset('/')}}/global_assets/js/plugins/ui/moment/moment.min.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/daterangepicker.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/anytime.min.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/pickadate/picker.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/pickadate/picker.date.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/pickadate/picker.time.js"></script>
	<script src="{{asset('/')}}/global_assets/js/plugins/pickers/pickadate/legacy.js"></script> -->
	<script src="{{asset('/')}}/global_assets/js/plugins/notifications/jgrowl.min.js"></script>
    <script src="{{asset('global_assets/js/plugins/forms/inputs/jquery.mask.js')}}"></script>


	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/gallery_library.js')}}"></script>
	<script type="text/javascript">
		$('#payment_date_filter').daterangepicker({
			@if($view != 'withpreviousbalance')
			startDate: "{{ date('d-m-Y', strtotime( $maxdate_filter ) ) }}",
			@else
				@php
				$arr_date = explode(' - ', $maxdate_filter);
				$start_date = $arr_date[0];
				$end_date = $arr_date[1];
				@endphp

				startDate: "{{ $start_date }}",
				endDate: "{{ $end_date }}",
			@endif

			maxDate: "{{ date('d-m-Y') }}",
			applyClass: 'btn-primary',
			cancelClass: 'btn-light',

			@if($view != 'withpreviousbalance')
			singleDatePicker: true,
			@endif

			@if(!isset($_GET['payment_date_filter']))
			autoUpdateInput: false,
			@endif

			locale: {
				format: 'DD-MM-YYYY'
			}
		});

		$('#payment_date_filter').on('apply.daterangepicker', function(ev, picker) {

			@if($view != 'withpreviousbalance')
		    $(this).val(picker.startDate.format('DD-MM-YYYY'));
			@else
			$(this).val(picker.startDate.format('DD-MM-YYYY')+' - '+picker.endDate.format('DD-MM-YYYY'));
			@endif

			$('#form-filter-payment-date').submit();
		});

	  	$('#payment_date_filter').on('cancel.daterangepicker', function(ev, picker) {
	      	$(this).val('');
	  	});

		// Filter Payment Date Action
		$('#payment_date_filter').on('change', function(){
			$('#form-filter-payment-date').submit();
		});

		//Memunculkan Debit Berdasarkan Metode Pembayaran
		function onchangeCompany(){
			let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
			params.delete('company_id');
            params.append('company_id', document.getElementById("company_id").value);
            document.location.href = "?" + params.toString();
		}

		$( document ).ready(function() {
	        // Default style
	        @if(session('error'))
	            new PNotify({
	                title: 'Error',
	                text: '{{ session('error') }}.',
	                icon: 'icon-blocked',
	                type: 'error'
	            });
            @endif
            @if ( session('success'))
	            new PNotify({
	                title: 'Success',
	                text: '{{ session('success') }}.',
	                icon: 'icon-checkmark3',
	                type: 'success'
	            });
            @endif

		});
	</script>
@endsection