@extends('backend.layouts.master')

@section('title', 'Bank Transaction Report')

@push('css')
<!-- bootstrap-datetimepicker -->
	<link rel="stylesheet" href="{{ asset('myfile/backend/assets/datepicker/zebra_datepicker.min.css') }}" type="text/css">
	<link rel="stylesheet" href="{{ asset('myfile/backend/assets/datepicker/examples.css') }}" type="text/css">
	<style>
		#search-btn{
			margin-top:24px;
		}
		/*thead{
			font-size: 11px;
		}
		tbody{
			font-size: 11px;
		}*/
	</style>
@endpush
@section('content')
<div class="right_col" role="main">
        <div class="">
            <div class="clearfix"></div>
            <div class="row">
                <div class="col-md-12 col-sm-12 col-xs-12">
                    <div class="x_panel">
                        <div class="x_title">
                            <h2>Bank Transaction Entry
							<a href="{{route('transaction.list')}}" class="btn btn-xs btn-success">Transaction List</a>
							</h2>
                            <ul class="nav navbar-right panel_toolbox">
                                <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                                </li>
                                <li class="dropdown">
                                    <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button"
                                       aria-expanded="false"><i class="fa fa-wrench"></i></a>
                                    <ul class="dropdown-menu" role="menu">
                                        <li><a href="#">Settings 1</a>
                                        </li>
                                        <li><a href="#">Settings 2</a>
                                        </li>
                                    </ul>
                                </li>
                                <li><a class="close-link"><i class="fa fa-close"></i></a>
                                </li>
                            </ul>
                            <div class="clearfix"></div>
                        </div>
                        <div class="x_content">
							<form id="demo-form2" action="{{ route('transaction.btlist')}}" method="post" data-parsley-validate class="form" enctype="multipart/form-data" >
								{{ csrf_field()}}
								<div class="row">
									<div class="col-sm-2"></div>
									<div class="col-sm-2">
										<div class="form-group">
											<label>Bank Name *</label>
											<select name="bank_id" id="bank_id" class="form-control select2">
												<option value="All">All</option>
												@foreach($banks as $bk)
													<option value="{{ $bk->id}}" {{$bk->id == $bank->id ? 'selected' : ''}}>{{ $bk->bank_name}}</option>
												@endforeach
											</select>
										</div>
									</div>
									<div class="col-sm-2">
										<div class="form-group">
											<label>From</label>
											<input id="datepicker-range-start" type="text" name="from_date"  class="form-control" value="{{ date('d-m-Y', strtotime($from_date))}}" data-zdp_readonly_element="false" placeholder="yyyy-mm-dd">
										</div>
									</div>
									<div class="col-sm-2">
										<div class="form-group">
											<label>To</label>
											<input id="datepicker-range-end" type="text" name="to_date"  class="form-control"value="{{ date('d-m-Y', strtotime($to_date))}}" data-zdp_readonly_element="false" placeholder="yyyy-mm-dd">
										</div>
									</div>
									<div class="col-sm-1">
										<div class="form-group">
											<button class="btn btn-success btn-xs" id="search-btn">
												<i class="ace-icon fa fa-search fa-2x icon-only"></i>
											</button>
										</div>
									</div>
									<div class="col-sm-2">
										<a href="#" id="search-btn" class="btn btn-xs btn-info" onclick="printDiv('printableArea')">
											<i class="ace-icon fa fa-print fa-2x icon-only"></i>
										</a>
									</div>
								</div>
							</form>
							<hr/>
							<div class="row">
								<div class="col-md-12 col-sm-12 col-xs-12">
									<div class="" id="printableArea">
										<div class="row">
											<div class="col-xs-12 col-sm-12">
											@if($transactions != '')
												<div class="row">
													<div class="col-xs-1"></div>
													<div class="col-xs-1">
														<img src="{{ asset('storage/about/'.about()->logo)}}" class="img-responsive img-thumbnail" alt="logo" width="85px" height="75px" >
													</div>
													<div class="col-xs-8">
														<div class="text-center">
															<h4>{{about()->english_name}}</h4>
															<h5>{{about()->bank_name}}</h5>
															<p>From: {{ date("d-m-Y", strtotime($from_date))}} - {{ date("d-m-Y", strtotime($to_date))}}</p>
														</div>
													</div>
													<div class="col-xs-2"></div>
												</div>
												<table class="table table-bordered">
													<thead>
														<tr>
															<th>SL</th>
															<th>Date</th>
															<th>Account No</th>
															<th>Cheque No</th>
															<th>Deposit</th>
															<th>Withdraw</th>
															<th>Loan</th>
															<th>Balance</th>
														</tr>
													</thead>
													<tbody>
														@php
															$depo = 0;
															$wt = 0;
															$loan = 0;
														@endphp
													@foreach($transactions as $key=>$tr)
														@php
															$depo = $depo + ($tr->transaction_status == 'Deposit' ? $tr->transaction_amount : '0');
															$wt = $wt + ($tr->transaction_status == 'Withdraw' ? $tr->transaction_amount : '0');
															$loan = $loan + ($tr->transaction_status == 'Loan' ? $tr->transaction_amount : '0');
														@endphp
														<tr>
															<td>{{ $key + 1}}</td>
															<td>{{ date("d-m-Y", strtotime($tr->transaction_date))}}</td>
															<td>{{ $tr->account_no}}</td>
															<td>{{ $tr->cheque_no}}</td>
															<td>{{ $tr->transaction_status == 'Deposit' ? $tr->transaction_amount : '0.00'}}</td>
															<td>{{ $tr->transaction_status == 'Withdraw' ? $tr->transaction_amount : '0.00'}}</td>
															<td>{{ $tr->transaction_status == 'Loan' ? $tr->transaction_amount : '0.00'}}</td>
															<td>{{ $depo - $wt}}</td>
														</tr>
													@endforeach
														<tr>
															<th colspan="3"></th>
															<th>Total=</th>
															<th>{{$depo}}</th>
															<th>{{$wt}}</th>
															<th>{{$loan}}</th>
															<th>{{($loan + $depo) - $wt}}</th>
														</tr>
													</tbody>
												</table>
											@else
												<p align="center">Sory! no data found.</p>
											@endif
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
    </div>
@endsection

@push('js')

<!-- Jquery Plugin For Date Calender-->
<script type="text/javascript" src="{{ asset('myfile/backend/assets/datepicker/zebra_datepicker.src.js') }}"></script>
<script type="text/javascript" src="{{ asset('myfile/backend/assets/datepicker/examples.js') }}"></script>
<script>
  $(document).ready(function() 
  {
	// select2 section
    $('.select2').select2()	;
	});

  function printDiv(divName) {
		 var printContents = document.getElementById(divName).innerHTML;
		 var originalContents = document.body.innerHTML;

		 document.body.innerHTML = printContents;

		 window.print();

		 document.body.innerHTML = originalContents;
		}
</script>
@endpush
    
 