<?php $page = "report_income"; ?>
@extends('layouts.app')
@section('header')

@parent

<style>
	
	select[name="DataTables_Table_0_length"] {
		margin-top: 8px;
	}
	.form-horizontal{
		display: inline-block;
	}
</style>
	<?php $success_message = session('success'); if($success_message){?>
		<script>
			jQuery(document).ready(function(){
				alert('<?php echo $success_message; ?>');
			});
		</script>
	<?php session()->forget('success'); } ?>
	
	<script>
		jQuery(document).ready(function($){
			$('body').on('focus','input[name="from_date"]',function(e){
				$(this).datepicker({dateFormat: 'yy-mm-dd'});
			});
			
			$('body').on('focus','input[name="to_date"]',function(e){
				$(this).datepicker({dateFormat: 'yy-mm-dd'});
			});
			$('button[name=updateButton]').on('click', function(e){
				e.preventDefault();
				var dateFrom = $('input[name="from_date"]').val();
				var dateTo = $('input[name="to_date"]').val();
				var accountName = $("#bankName" ).val();
				var url = "{{ route('reports.income_filtered')}}";
				var urlWithParam = url+"?dateFrom="+dateFrom+"&dateTo="+dateTo+"&bankId="+accountName;
				//alert(urlWithParam);
				window.location.href = urlWithParam;
			});
		});
		
		function printWindow() {
			 window.print();
		}
		
	</script>
@endsection

@section('content')
<!-- Page header -->
<div class="page-header">
	<div class="page-header-content">
		<button class="btn btn-labeled bg-teal-400" style="float: right; margin-top: 30px; position: relative; z-index: 99;" onClick="printWindow()"><b><i class="icon-printer"></i></b> Print</button>
		<div class="page-title">
			<h4><i class="icon-arrow-left52 position-left"></i> <span class="text-semibold">Report -</span> Income Statement</h4>
		</div>
	</div>

	<div class="breadcrumb-line">
		<ul class="breadcrumb">
			<li><a href="{{route('dashboard')}}"><i class="icon-home2 position-left"></i> Home</a></li>
			<li class="active"> Report Income statement </li>
		</ul>
	</div>
</div>
<!-- /page header -->


<!-- Content area -->
<div class="content">
	<div class="panel panel-flat">
		<div class="panel-body"> 
			<form action="" class="form-horizontal">
				<span style="display: inline-block; vertical-align: top;">
					<input type="text" name="from_date" class="form-control" value="{{$dateFrom}}">
				</span>
				<span style=" display: inline-block;padding-top: 2%;">
					To
				</span>
				<span style="display: inline-block; vertical-align: top;">
					<input type="text" name="to_date" class="form-control" value="{{$dateTo}}">
				</span>
				
				<span style="display: inline-block; vertical-align: bottom;width: 100px;">
					<button style="width: 100%" type="submit" class="btn btn-primary" name="updateButton">Filter</button>
				</span>
			</form>
				<span style="display: inline-block; vertical-align: bottom;width: 100px;">
						<a href="{{route('reports.income')}}"> <button button style="width: 100%" class="btn btn-primary">Clear Filter</button> </a>
				</span>
				<div class="col-md-3" style="display: none;">
						<div class="form-group" style="margin-bottom: 0;">
							<label for="" class="col-lg-3 control-label text-right">Account</label>
							<div class="col-lg-9">
								<select id="bankName" class="form-control">
									@foreach ($sumber as $sumberBank)
										<option value="{{$sumberBank['id']}}">{{$sumberBank['name']}}</option>
									@endforeach
								</select>
							</div>
						</div>
					</div>
		</div>
	</div>
	
	<div class="panel panel-flat">
		<div class="panel-body">
			<div class="row">
				<div class="col-md-12">
					<h4>Income</h4>
					<div class="table-responsive">
						<table class="table">
							<colgroup>
								<col width="40%" />
								<col width="30%" />
								<col width="30%" />
							</colgroup>
							<thead>
								<tr>
									<th>Account</th>
									<th>Debet</th>
									<th>Credit</th>
								</tr>
							</thead>
							<tbody>
								<?php  
								$income_debet = 0;  
								$income_credit = 0;
								foreach($incomes as $income){
									$income_debet += $income['debet'];
									$income_credit += $income['credit'];
								if($income['level']==0) {?>
									<tr>
										<td><a href="{{ route('reports.balance_sheet.detail', [$income['account'], $dateFrom, $dateTo]) }}">{{$income['name']}}</a></td>
										<td>{{number_format($income['debet'],2)}}</td>
										<td>{{number_format($income['credit'],2)}}</td>
									</tr>
								<?php }} ?>
								<tr>
									<td>Total</td>
									<td><b>{{number_format($income_debet,2)}} </b></td>
									<td><b>{{number_format($income_credit,2)}} </b></td>
								</tr>
								<tr>
									<td><b>Net Income</b></td>
									<td colspan="2" align="center"><b>{{number_format($income_debet-$income_credit,2)}} </b></td>
								</tr>
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>

	<div class="panel panel-flat">
		<div class="panel-body">
			<div class="row">
				<div class="col-md-12">
					<h4>Expense</h4>
					<div class="table-responsive">
						<table class="table">
							<colgroup>
								<col width="40%" />
								<col width="30%" />
								<col width="30%" />
							</colgroup>
							<thead>
								<tr>
									<th>Account</th>
									<th>Debet</th>
									<th>Credit</th>
								</tr>
							</thead>
							<tbody>
								<?php    
								$expense_debet = 0;  
								$expense_credit = 0;
								foreach($expenses as $expense){
									$expense_debet += $expense['debet'];
									$expense_credit += $expense['credit'];
								if($expense['level']==0) {?>
									<tr>
										<td><a href="{{ route('reports.balance_sheet.detail', [$expense['account'], $dateFrom, $dateTo]) }}">{{$expense['name']}}</a></td>
										<td>{{number_format($expense['debet'],2)}}</td>
										<td>{{number_format($expense['credit'],2)}}</td>
									</tr>
								<?php }} ?>
								<tr>
									<td>Total</td>
									<td><b>{{number_format($expense_debet,2)}} </b></td>
									<td><b>{{number_format($expense_credit,2)}} </b></td>
								</tr>
								<tr>
									<td><b>Net Expense</b></td>
									<td colspan="2" align="center"><b>{{number_format($expense_debet-$expense_credit,2)}} </b></td>
								</tr>
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>
	<div class="panel panel-flat">
		<div class="panel-body"> 
		<label style="font-weight: bold; font-size: 15px;"> 
			<?php 
				$total = ($income_debet-$income_credit)-($expense_debet-$expense_credit);
				if($total >= 0) {
			?>
			Net Profit {{$total}}
		<?php } else{ ?>
			Net Loss {{ number_format(abs($total))}} 
		<?php } ?>
		</label>
		</div>
	</div>
</div>
<!-- /content area -->
@endsection
