@extends('backend.layouts.app')
@section('content')
<div class="container-fluid">
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">Subscriptions Bill Details</h1>
				<ol class="breadcrumb float-right">
					<li class="breadcrumb-item"><a href="{{route('dashboard')}}">Dashboard</a></li>
					<li class="breadcrumb-item"><a href="{{route('golf-operation')}}">Golf Operation</a></li>
					<li class="breadcrumb-item"><a href="{{route('golf-operation.monthly-subscriptions')}}">Monthly Subscriptions</a></li>
					<li class="breadcrumb-item active">Subscriptions Bill Details</li>
				</ol>
				<div class="clearfix"></div>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-md-12">
			<div class="card">
				<div class="card-header text-right">
					<button class="btn btn-info btn-sm" onclick="printJS({printable:'subscription-receipt', type: 'html', css: '{{ asset('public/css/print.css') }}'})">
						<i class="fa fa-print"></i> Print
					</button>
					
				</div>
				<div class="card-body">
					<div style="overflow-x: scroll;">

						{{-- bill details starts --}}
						@if($bill)

						<div id="subscription-receipt">

							@php
							$old_dues_present_due = 0;
							if ($bill->member->old_dues) {
								$old_dues_present_due = $bill->member->old_dues->present_due;
							}

							$advance_next_date = strtotime('+1 Month', strtotime($bill->year.'-'.$bill->month));
							$advance_next_year = date('Y', $advance_next_date);
							$advance_next_month = date('F', $advance_next_date);

							$getAllAdvanceBillPaid = $bill->member->getAllAdvanceBillPaid($bill->member->id, $advance_next_year, $advance_next_month);
							
							$advance_months_paid = 0;
							if (count($getAllAdvanceBillPaid)) {
								$advance_months_paid = $getAllAdvanceBillPaid->sum('paid_amount');
							}							

					        $all_due_bill = $bill->member->getAllDueBillDetails($bill->member->id);

					        //here previous month is bill month		        
					        $previous_month = $bill->month;
					        $previous_year = $bill->year;

				        	$prev_month_bill=collect();
				        	$prev_of_prev_bills=collect();
				        	$adv_month_bills=collect();
					        foreach ($all_due_bill as $key => $value) {

					        	if(strtotime($value->year.'-'.$value->month) < strtotime($previous_year.'-'.$previous_month)){

						        	$prev_of_prev_bills->push($value);

					        	}else if ($previous_month == $value->month && $previous_year == $value->year) {
					        		$prev_month_bill = $value;

					        	}
					        	if(strtotime($value->year.'-'.$value->month) > strtotime($previous_year.'-'.$previous_month)){
					        		
					        		$adv_month_bills->push($value);
					        	}
					        }									        	

					        //previous dues of entry ok for specific month here
							$dues_start_date="";
							$dues_end_date="";
							if ($bill->member->getLastBillDetails()['old_dues'] && $bill->member->getLastBillDetails()['old_dues']->present_due > 0) {

								$dues_start_date = $bill->member->getLastBillDetails()['old_dues']->from_month;
								$dues_end_date = $bill->member->getLastBillDetails()['old_dues']->to_month;
							}

							$dues_or_advance = ($bill->member->getLastBillDetails()['old_dues'] ? $bill->member->getLastBillDetails()['old_dues']->present_due:0) + 
								(count($prev_of_prev_bills)?$prev_of_prev_bills->sum('due_amount'):0) ;
							// echo '<pre>'; dd($dues_or_advance); echo '</pre>';

							$advancePay = $bill->member->subscriptionAdvance();
							$advancePayDate="";
							if (isset($advancePay->total_amount) && $advancePay->total_amount > 0) {
								$advancePayDate = 'Advance up to '.$advancePay->to_month.' '.$advancePay->to_year;
							}else if( count($getAllAdvanceBillPaid) ){
								$advancePayDate = 'Advance up to '.$getAllAdvanceBillPaid->last()->month.' '.$getAllAdvanceBillPaid->last()->year;
							}

							$total_bill = 0;

						@endphp

							<table style="border: 0px; width: 100%;">
								<tr>
									<td style="border: 0px;">
										<div style="width: 480px; margin-left: auto; margin-right: auto; margin-top: 25px;">
											<h3 class="text-center" style="margin: 0px; font-size: 18px;">Bhatiary Golf &Country Club</h3>
											<p class="text-center" style="margin: 0px;">Dhaka Catonment</p>
											<p class="text-center" style="margin: 0px;">Dhaka - 1206, Opposite Zoarshahara Bus Stand</p>
											<p class="text-center" style="margin: 0px;">Phone: 88 02 8752332, Army 8751777 Ex 6110 Email: agc_bd@yahoo.com, Web: www.agc.com.bd</p>
											<hr />
											<h3 style="margin: 0px; border: 1px solid #000; width: 60%; text-align: center; display:block; font-size: 14px; font-weight: bold; margin-left: auto; margin-right: auto;">Monthly Bill - Member Copy</h3>
											<table class="table table-sm borderless padding-less" style="border: 0;">
												<tr>
													<td style="text-align: left; width: 150px;">Bill No</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ sprintf('%06d', $bill->id) }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Billing Month</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->month . ' ' . $bill->year }}</td>
												</tr>												
												<tr>
													<td style="text-align: left; width: 150px;">Print Date</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ date('d F Y') }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Due Date</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ date('20 F Y', strtotime("+1 month", strtotime($bill->year.'-'.$bill->month.'-01'))) }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Membership No</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->member->membership_no }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Member Name</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->member->full_name }}</td>
												</tr>
												<tr>
													<td>Address</td>
													<td>:</td>
													<td>{{ $bill->member->present_address }}</td>
												</tr>
											</table>
											
											<table class="table table-bordered table-sm bill-status" style="font-size: 10px;">
												<thead>
													<tr>
														<th class="text-left">Description</th>														
														<th class="text-right">Susbcription Fee</th>
														<th class="text-right">Dependent Fee</th>
														<th class="text-right">Fee Increased</th>
														<th class="text-right">Bill Total</th>
														<th class="text-right">Bill Paid</th>
														<th class="text-right" style="width: 10%;">Balance</th>
													</tr>								
												</thead>
												<tbody>

													<tr>
														<td class="text-center">{{$bill->month.' '.$bill->year}}</td>
														<td class="text-right">{{ number_format($bill->subscription_fee, 2) }}</td>
														<td class="text-right">{{ number_format($bill->dependent_fee, 2) }}</td>
														<td class="text-right">{{ number_format($bill->fee_increased, 2) }}</td>
														<td class="text-right">
															{{ number_format($bill->total_amount, 2) }}
														</td>
														<td class="text-right">
															{{ number_format($bill->paid_amount, 2) }}
														</td>
														<td class="text-right">
															{{ number_format($bill->due_amount, 2) }}
															@php $total_bill += $bill->due_amount @endphp
														</td>
													</tr>										

													@if($dues_or_advance != 0)

														<tr>
															<td colspan="6">
																{{ ($dues_or_advance>0)?'[Dues]':'' }}
																{{ ($dues_or_advance<0)?'[Advance]':'' }}

																@if(count($prev_of_prev_bills))
																 
																{{ $dues_start_date ? $dues_start_date:
																	$prev_of_prev_bills->first()->month.' '.$prev_of_prev_bills->first()->year}}
																
																{{' to '.$prev_of_prev_bills->last()->month.' '.$prev_of_prev_bills->last()->year}}

																@elseif( $dues_start_date && $dues_end_date)

																	{{$dues_start_date.' to '.$dues_end_date}}
																@endif

															</td>											
															<th class="text-right ">
																{{ number_format($dues_or_advance, 2) }}

																@php $total_bill += $dues_or_advance @endphp
															</th>
														</tr>
													@endif
													
													
												</tbody>
												<tfoot>
													<tr>
														<th colspan="6" class="text-right">Total</th>
														<th class="text-right">{{ number_format(
														$total_bill, 2) }}
														</th>
													</tr>
												</tfoot>
											</table>
											
											<p><b>In Word: </b>
												Zero Taka Only	
											</p>
											<p style="margin-bottom: 0px;">Note:</p>
											<ol style="font-size: 10px;">
												<li>Please notify in the case of any change in your address/update online visiting the website www.agc-bd.com</li>
												<li>20th of each month is the last date of payment.</li>
												<li>Checque should be issued in favour of 'Bhatiary Golf &Country Club, Dhaka Cantonment'</li>
												<li>Please add Tk. 40.00 (Fourty) for Bank Cheque of outside of Dhaka City, Otherwise cheque will not be accepted</li>
											</ol>
											<p style="text-align: center;">This is computer generated bill and does not require any singnature</p>
											<p style="margin-top: 25px; border-top: 1px dotted #000;" class="text-center">
												Powered By ISSIT Ltd. Mobile: +8801712 650270
											</p>
										</div>
									</td>
									<td style="width: 100px;">
										
									</td>

									@php $total_bill = 0; @endphp

									<td style="border: 0px;">
										<div style="width: 480px; margin-left: auto; margin-right: auto; margin-top: 25px;">
											<h3 class="text-center" style="margin: 0px; font-size: 18px;">Bhatiary Golf &Country Club</h3>
											<p class="text-center" style="margin: 0px;">Dhaka Catonment</p>
											<p class="text-center" style="margin: 0px;">Dhaka - 1206, Opposite Zoarshahara Bus Stand</p>
											<p class="text-center" style="margin: 0px;">Phone: 88 02 8752332, Army 8751777 Ex 6110 Email: agc_bd@yahoo.com, Web: www.agc.com.bd</p>
											<hr />
											<h3 style="margin: 0px; border: 1px solid #000; width: 60%; text-align: center; display:block; font-size: 14px; font-weight: bold; margin-left: auto; margin-right: auto;">Monthly Bill - Office Copy</h3>
											<table class="table table-sm borderless padding-less" style="border: 0;">
												<tr>
													<td style="text-align: left; width: 150px;">Bill No</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ sprintf('%06d', $bill->id) }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Billing Month</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->month . ' ' . $bill->year }}</td>
												</tr>													
												<tr>
													<td style="text-align: left; width: 150px;">Print Date</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ date('d F Y') }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Due Date</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ date('20 F Y', strtotime($bill->year.'-'.$bill->month.'-01')) }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Membership No</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->member->membership_no }}</td>
												</tr>
												<tr>
													<td style="text-align: left; width: 150px;">Member Name</td>
													<td style="width: 2px; text-align: center;">:</td>
													<td style="text-align: left;">{{ $bill->member->full_name }}</td>
												</tr>
												<tr>
													<td>Address</td>
													<td>:</td>
													<td>{{ $bill->member->present_address }}</td>
												</tr>
											</table>
											
											<table class="table table-bordered table-sm bill-status" style="font-size: 10px;">
												<thead>
													<tr>
														<th class="text-left">Description</th>														
														<th class="text-right">Susbcription Fee</th>
														<th class="text-right">Dependent Fee</th>
														<th class="text-right">Fee Increased</th>
														<th class="text-right">Bill Total</th>
														<th class="text-right">Bill Paid</th>
														<th class="text-right" style="width: 10%;">Balance</th>
													</tr>								
												</thead>
												<tbody>

													<tr>
														<td class="text-center">{{$bill->month.' '.$bill->year}}</td>
														<td class="text-right">{{ number_format($bill->subscription_fee, 2) }}</td>
														<td class="text-right">{{ number_format($bill->dependent_fee, 2) }}</td>
														<td class="text-right">{{ number_format($bill->fee_increased, 2) }}</td>
														<td class="text-right">
															{{ number_format($bill->total_amount, 2) }}
														</td>
														<td class="text-right">
															{{ number_format($bill->paid_amount, 2) }}
														</td>
														<td class="text-right">
															{{ number_format($bill->due_amount, 2) }}
															@php $total_bill += $bill->due_amount @endphp
														</td>
													</tr>										

													@if($dues_or_advance != 0)

														<tr>
															<td colspan="6">
																{{ ($dues_or_advance>0)?'[Dues]':'' }}
																{{ ($dues_or_advance<0)?'[Advance]':'' }}

																@if(count($prev_of_prev_bills))
																 
																{{ $dues_start_date ? $dues_start_date:
																	$prev_of_prev_bills->first()->month.' '.$prev_of_prev_bills->first()->year}}
																
																{{' to '.$prev_of_prev_bills->last()->month.' '.$prev_of_prev_bills->last()->year}}

																@elseif( $dues_start_date && $dues_end_date)

																	{{$dues_start_date.' to '.$dues_end_date}}
																@endif

															</td>											
															<th class="text-right ">
																{{ number_format($dues_or_advance, 2) }}

																@php $total_bill += $dues_or_advance @endphp
															</th>
														</tr>
													@endif
													
													
												</tbody>
												<tfoot>
													<tr>
														<th colspan="6" class="text-right">Total</th>
														<th class="text-right">{{ number_format(
														$total_bill, 2) }}
														</th>
													</tr>
												</tfoot>
											</table>
											
											<p><b>In Word: </b>
												Zero Taka Only	
											</p>
											<p style="margin-bottom: 0px;">Note:</p>
											<ol style="font-size: 10px;">
												<li>Please notify in the case of any change in your address/update online visiting the website www.agc-bd.com</li>
												<li>20th of each month is the last date of payment.</li>
												<li>Checque should be issued in favour of 'Bhatiary Golf &Country Club, Dhaka Cantonment'</li>
												<li>Please add Tk. 40.00 (Fourty) for Bank Cheque of outside of Dhaka City, Otherwise cheque will not be accepted</li>

											</ol>
											<p style="text-align: center;">This is computer generated bill and does not require any singnature</p>
											<p style="margin-top: 25px; border-top: 1px dotted #000;" class="text-center">
												Powered By ISSIT Ltd. Mobile: +8801712 650270
											</p>
										</div>
									</td>
								</tr>
							</table>										
						</div>

						@else
						<h5>Invalid Bill</h5>
						@endif
						{{-- bill details end	 --}}

					</div>																	
				</div>
			</div>			
		</div>
	</div>
</div>
@endsection

@section('before_body_end')
<style type="text/css">
	#subscription-receipt{
		font-family: Arial;
		font-size: 12px;
	}
</style>
@endsection