@extends('layouts.admin')

@section('content')

<div class="page-wrapper">
	<div class="content">

		<div class="page-header" style="display: block;">
			<div class="row">
				<div class="col-sm-6">
					<h4>{{ __('messages.Graphic of all your entries') }}</h4>

					@if(Auth::user()->reg_country == 'us')
					<a href="{{ route('report.T776', ['year'=>request('year'), 'type'=>'view', 'client_plans_id'=>$client_plans_id]) }}" class="btn btn-sm btn-primary" target="_blank">{{ __('Report to F1040 SCHEDULE E') }}</a>
					<a href="{{ route('report.T776', ['year'=>request('year'), 'type'=>'print', 'client_plans_id'=>$client_plans_id]) }}" class="btn btn-sm btn-primary" target="_blank">{{ __('Print F1040 SCHEDULE E') }}</a>

					<form method="post" action="{{ route('report.pdf') }}" style="display: inline-block;">
					@csrf
						<input type="hidden" name="year" value="{{ request('year') }}">
						<input type="hidden" name="client_plans_id" value="{{ $client_plans_id }}">
						<button type="submit" class="btn btn-sm btn-primary">{{ __('Export to PDF') }}</button>
					</form>
					@else
					<a href="{{ route('report.T776', ['year'=>request('year'), 'type'=>'view', 'client_plans_id'=>$client_plans_id]) }}" class="btn btn-sm btn-primary" target="_blank">{{ __('messages.Report to T776') }}</a>
					<a href="{{ route('report.T776', ['year'=>request('year'), 'type'=>'print', 'client_plans_id'=>$client_plans_id]) }}" class="btn btn-sm btn-primary" target="_blank">{{ __('messages.Print your T776') }}</a>

					<form method="post" action="{{ route('report.pdf') }}" style="display: inline-block;">
					@csrf
						<input type="hidden" name="year" value="{{ request('year') }}">
						<input type="hidden" name="client_plans_id" value="{{ $client_plans_id }}">
						<button type="submit" class="btn btn-sm btn-primary">{{ __('Export to PDF') }}</button>
					</form>
					@endif
				</div>  

				<div class="col-sm-3">
		            <select name="year" class="form-control" id="year-select">
		                <option value="">{{ __('messages.Select Year') }}</option>
		                @for ($years = now()->year; $years >= now()->year - 6; $years--)
		                    <option value="{{ $years }}" {{ request('year') == $years ? 'selected' : '' }}>{{ $years }}</option>
		                @endfor
		            </select>
				</div>
			</div>
		</div>	
			@include('layouts.errors')
		<div class="row mb-3">
			<div class="col-md-6">
				<div class="card">
					<div class="card-header">
						<h5 class="card-title">{{ __('messages.AmountByMonth') }}</h5>
					</div>
					<div class="card-body">
						<div id="s-col" class="chart-set"></div>
					</div>
				</div>
			</div>
			<div class="col-md-6">
				<div class="table-responsive product-list">
					<table class="table datanew1">
						<thead>
							<tr>
								<th>{{ __('messages.Month') }}</th>
								<th>{{ __('messages.Total Amount') }} 
								<span style="font-size: 12px;">{{ __('messages.(Rents - Expenses)') }}</span></th>
							</tr>
						</thead>
						@php 
					        $months = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December']; 
					        $months_grand_total = 0;
					        $count = 0;
					    @endphp
					    <tbody>
					        @if(count($months) > 0)
					            @foreach($months as $month)
					                <tr>
					                	<th>{{ __('messages.'.$month) }}</th>
						                @php  
						                    $total = amount_by_month($month, $year, $client_plans_id); 
						                    $months_grand_total += $total; 
						                @endphp
						                <td>
						                @if($total < 0)
						                (${{ number_format(abs($total), 2) }})
						                @else
						                ${{ number_format($total, 2) }}
						                @endif
						            	</td>
						                @php $count++; @endphp
					                </tr>
					            @endforeach
					        @endif
					    </tbody>
						<tfoot>
							<th>{{ __('messages.Grand Total') }}</th>
							<th>
							@if($months_grand_total < 0)
							(${{ number_format(abs($months_grand_total), 2) }})
							@else
							${{ number_format($months_grand_total, 2) }}
							@endif
							</th>
						</tfoot>
					</table>
				</div>
			</div>
		</div>

		<div class="row">
			<div class="col-md-6">
				<div class="table-responsive product-list">
					<table class="table datanew1">
						<thead>
							<tr>
								<th>{{ __('messages.Income Type') }}</th>
								<th>{{ __('messages.Total Amount') }}</th>
							</tr>
						</thead>
						<tbody>
							@php $income_grand_total = 0; @endphp
							@if(count($incomes) > 0)
							@foreach($incomes as $income)
							<tr>
								<th>{{ $income->name }}</th>
								@php 
								$total = income_by_category($income->id, $year, $client_plans_id); 
								$income_grand_total += $total; 
								@endphp
								<td>${{ number_format($total, 2) }}</td>
							</tr>
							@endforeach
							@endif
						</tbody>
						<tfoot>
							<th>{{ __('messages.Grand Total') }}</th>
							<th>
							@if($income_grand_total < 0)
							(${{ number_format(abs($income_grand_total), 2) }})
							@else
							${{ number_format($income_grand_total, 2) }}
							@endif
							</th>
						</tfoot>
					</table>
				</div>
			</div>
			<div class="col-md-6">
				<div class="table-responsive product-list">
					<table class="table datanew1">
						<thead>
							<tr>
								<th>{{ __('messages.Expense Type') }}</th>
								<th>{{ __('messages.Total Amount') }}</th>
							</tr>
						</thead>