Dashboard

Staff Distribution

@php $totalCount=0; $totalMaleCount=0; $totalFemaleCount=0; @endphp @foreach($employeeCount as $key => $count) @php $totalCount+=$count->employee; $totalMaleCount+=$count->male_cnt; $totalFemaleCount+=$count->female_cnt; @endphp @endforeach

Job Category	Employee Status	Female	Male	Total Count
{{$count->job_category_name}}	{{$count->employment_status_name}}	{{$count->female_cnt}}	{{$count->male_cnt}}	{{$count->employee}}
Total		{{$totalFemaleCount}}	{{$totalMaleCount}}	{{$totalCount}}

Birthday

Today

@foreach($today_Birthday as $key => $birth) @endforeach

Employee ID	Employee Name
{{$birth->employee_id}}	{{$birth->employee_name}}

Tomorrow

@foreach($tommorrow_Birthday as $key => $birth) @endforeach

Employee ID	Employee Name
{{$birth->employee_id}}	{{$birth->employee_name}}

Employee List

Exit Formality

@foreach($resigned_employee as $key => $value) @endforeach

Emp. ID	Employee Name	Resign Date	Action
{{$value->employee_id }}	{{$value->employee_name}}	{{date("d-M-Y",strtotime($value->resigned_date))}}	{{-- No Due, --}} Exit Interview {{-- F&F Settlement --}}

Absconded

@foreach($absconded_employee as $key => $value) @php $letter1_date = date("Y-m-d", strtotime("+4 day", strtotime("$value->status_effective_date"))); $finalletter_date = date("Y-m-d", strtotime("+15 day", strtotime("$value->status_effective_date"))); @endphp @if($letter1_date<=date("Y-m-d")) @else @endif @endforeach

Emp. ID	Employee Name	Absconded Date	Action
Minimum date:		Maximum date:
{{$value->employee_id }}	{{$value->employee_name}}	{{ date("d-M-Y", strtotime("+4 day", strtotime($value->status_effective_date))) }}	Disciplinary Letter-1, @else	@endif @if($finalletter_date<=date("Y-m-d")) Final Disciplinary Letter