@extends('admin.master')
@section('content')
@section('title','Attendance Summary Report')
<style>
	.present{
		color: #7ace4c;
		font-weight: 700;
		cursor: pointer;
	}
	.absence{
		color: #f33155;
		font-weight: 700;
		cursor: pointer;
	}
	.leave{
		color: #41b3f9;
		font-weight: 700;
		cursor: pointer;
	}
	.bolt{
		font-weight: 700;
	}
</style>
<script>
    jQuery(function (){
        $("#attendanceSummaryReport").validate();
    });
</script>
<div class="container-fluid">
	<div class="row bg-title">
		<div class="col-lg-7 col-md-7 col-sm-7 col-xs-12">
			<ol class="breadcrumb">
				<li class="active breadcrumbColor"><a href="{{ url('dashboard') }}"><i class="fa fa-home"></i> Dashboard</a></li>
				<li>@yield('title')</li>
			</ol>
		</div>

	</div>

	<div class="row">
		<div class="col-sm-12">
			<div class="panel panel-info">
				<div class="panel-heading"><i class="mdi mdi-table fa-fw"></i>@yield('title')</div>
				<div class="panel-wrapper collapse in" aria-expanded="true">
					<div class="panel-body">
						<div class="row">
							<div id="searchBox">
								{{ Form::open(array('route' => 'attendanceSummaryReport.attendanceSummaryReport','id'=>'attendanceSummaryReport')) }}
								<div class="col-md-3"></div>

								<div class="col-md-4">
									<label class="control-label" for="email">Month<span class="validateRq">*</span></label>
									<div class="input-group">
										<span class="input-group-addon"><i class="fa fa-calendar"></i></span>
										<input type="text" class="form-control monthField required" readonly placeholder="Select Month"  name="month" value="@if(isset($month)) {{$month}}@else {{ date("Y-m") }} @endif">
									</div>
								</div>
								<div class="col-md-2">
									<div class="form-group">
										<input type="submit" id="filter" style="margin-top: 25px; width: 100px;" class="btn btn-info " value="Filter">
									</div>
								</div>
								{{ Form::close() }}
							</div>
						</div>
						@if(nCount($results) > 0)
							<h4 class="text-right">
								@if(isset($month))
									<a target="_blank" class="btn btn-success" style="color: #fff" href="{{ URL('downloadAttendanceSummaryReport/'.$month)}}"><i class="fa fa-download fa-lg" aria-hidden="true"></i> Download PDF</a>
								@else
									<a class="btn btn-success" style="color: #fff" href="{{ URL('downloadAttendanceSummaryReport/'.date('Y-m') )}}"><i class="fa fa-download fa-lg" aria-hidden="true"></i> Download PDF</a>
								@endif
							</h4>
						@endif
						<div class="table-responsive">
							<table  class="table table-bordered table-striped table-hover">
								<thead>
									<tr>
										<th>S/L</th>
										<th>Year</th>
										<th colspan="0" class="totalCol">Month</th>
									</tr>
									<tr>
										<th>#</th>
										<th>2017</th>
										<th>{{$monthName}}</th>
										@foreach($monthToDate as $head)
											<th>{{$head['day_name']}}</th>
										@endforeach
										<th>Day off worked</th>
										<th>Gov. day worked </th>
										@foreach($leaveTypes as $leaveType)
											<th>{{$leaveType->leave_type_name}}</th>
										@endforeach
									</tr>
								</thead>
								<tbody>
									<tr>
										<td>#</td>
										<th>Name</th>
										<th>Designation</th>
										@foreach($monthToDate as $head)
											<th>{{$head['day']}}</th>
										@endforeach
										<th>#</th>
										<th>#</th>
										@foreach($leaveTypes as $leaveType)
											<th>#</th>
										@endforeach
									</tr>

									@php
										$sl = null;
										$totalPresent = 0;
										$totalGovDayWorked = 0;
										$leaveData = [];
										$totalCol = 0;
									@endphp
									@foreach($results as $key => $value)
										<tr>
											<td>{{++$sl}}</td>
											<td>{{$key}}</td>
											<td>{{$value[0]['designation_name']}}</td>
											@foreach($value as $v)
												@php
														if($sl == 1){
                                                 			$totalCol ++;
                                                 		}
                                                        if($v['attendance_status'] == 'present'){
                                                            if($v['gov_day_worked'] == 'yes'){
                                                                $totalGovDayWorked++;
                                                            }
                                                            $totalPresent++;
                                                            echo  "<td><span class='present' title='Present'>P</span></td>";
                                                        }elseif($v['attendance_status'] == 'absence'){
                                                            echo  "<td><span class='absence' title='Absence'>A</span></td>";
                                                        }elseif($v['attendance_status'] == 'leave'){
                                                            $leaveData[$key][$v['leave_type']][] = $v['leave_type'];
                                                            echo  "<td><span class='leave' title='Leave'>L</span></td>";
                                                        }else{
                                                            echo  "<td></td>";
                                                        }
												@endphp
											@endforeach
											<td><span class="bolt">{{$totalPresent}}</span></td>
											<td><span class="bolt">{{$totalGovDayWorked}}</span></td>

											@foreach($leaveTypes as $leaveType)

												<td>
													<span class="bolt">
														@php
															if($sl == 1){
                                                 				$totalCol ++;
                                                 			}
															if (isset($leaveData[$key][$leaveType->leave_type_name]))
																$c = count($leaveData[$key][$leaveType->leave_type_name]);
															else
																$c = 0;
														@endphp
														{{ $c }}
													</span>
												</td>
											@endforeach
											@php
                                                 $totalPresent = 0;
                                                 $totalGovDayWorked = 0;

											@endphp
										</tr>
									@endforeach
									<script>
										{!!"$('.totalCol').attr('colspan',$totalCol+3);" !!}
									</script>
								</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>
@endsection