|
SL No.
|
Name
|
ID #
|
Designation
|
Area/Dist.
|
Branch
|
Male
|
Female
|
Total (M + F)
|
Remarks
|
@php
$slNo = 0;
$_colorPckerFirst = 0;
$areaName = '';
$sex = 0;
$mSex = 0;
$fSex = 0;
$totalSex = 0;
$mTotalSex = 0;
$fTotalSex = 0;
@endphp
@if ($reqCategory == 'Branch')
{{-- Branch data start --}}
@if ($reqBAZ == 'all')
@foreach ($employeeList as $key => $employee)
@foreach ($employee as $key => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchID = DB::table('hr_emp_org_info')
->where('emp_id_fk', $employeeValue->id)
->pluck('branch_id_fk')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->whereIn('id', $branchID)
->pluck('name')
->toArray();
$area = DB::table('gnr_area')
->get();
foreach ($area as $key => $areaValue) {
$areaBranchInfo = $areaValue->branchId;
$areaBranch = json_decode($areaBranchInfo);
// dd($areaBranch);
foreach ($areaBranch as $key => $value) {
if ($value == $branchID[0]) {
$areaName = $areaValue->name;
break;
}
}
}
// dd($area[0]->branchId, $areaName);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
@else
@foreach ($employeeList as $key => $employee)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employee->id)
->pluck('name')
->toArray();
$branchID = DB::table('hr_emp_org_info')
->where('emp_id_fk', $employee->id)
->pluck('branch_id_fk')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->whereIn('id', $branchID)
->pluck('name')
->toArray();
$area = DB::table('gnr_area')
->get();
foreach ($area as $key => $areaValue) {
$areaBranchInfo = $areaValue->branchId;
$areaBranch = json_decode($areaBranchInfo);
// dd($areaBranch);
foreach ($areaBranch as $key => $value) {
if ($value == $branchID[0]) {
$areaName = $areaValue->name;
break;
}
}
}
// dd($area[0]->branchId, $areaName);
@endphp
@php
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employee->id)
->pluck('name')
->toArray();
// dd($designation[0]);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employee->emp_name_english}} |
{{$employee->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employee->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employee->emp_name_english}} |
{{$employee->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employee->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endif
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
{{-- Branch data end --}}
@elseif ($reqCategory == 'Area')
{{-- Area data start --}}
@if ($reqBAZ == 'all')
@foreach ($employeeList as $key1 => $employee)
@foreach ($employee as $key2 => $Value)
@foreach ($Value as $key => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_area')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
@elseif ($reqBAZ == 'all_with_head_office')
@php
$condition = 0;
// dd($employeeList);
// withHeadOffice($endDate);
$employeeListBranch = DB::table('hr_emp_org_info')
->join('hr_emp_general_info', 'hr_emp_org_info.emp_id_fk', '=', 'hr_emp_general_info.id')
->where([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '>', $endDate]])
->orWhere([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '=', '0000-00-00']])
->get();
@endphp
@if ($condition == 0)
@php
++$condition;
@endphp
@foreach ($employeeListBranch as $keyL => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_area')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
Head Office
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
Head Office
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endif
@foreach ($employeeList as $key1 => $employee)
@foreach ($employee as $key2 => $Value)
@foreach ($Value as $key => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all' ) {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
if ($reqBAZ == 'all_with_head_office' ) {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_area')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
@else
@php
// dd($employeeList);
@endphp
@foreach ($employeeList as $key1 => $employee)
@foreach ($employee as $key2 => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_area')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
@endif
{{-- Area data end --}}
@else
{{-- Zone Data Start --}}
@if ($reqBAZ == 'all')
@foreach ($employeeList as $key1 => $value1)
@foreach ($value1 as $key2 => $value2)
@foreach ($value2 as $key3 => $value3)
@foreach ($value3 as $key4 => $employeeValue)
@php
// dd($employeeValue);
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_zone')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_zone')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endforeach
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
@elseif ($reqBAZ == 'all_with_head_office')
@php
$condition = 0;
// dd($employeeList);
// withHeadOffice($endDate);
$employeeListBranch = DB::table('hr_emp_org_info')
->join('hr_emp_general_info', 'hr_emp_org_info.emp_id_fk', '=', 'hr_emp_general_info.id')
->where([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '>', $endDate]])
->orWhere([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '=', '0000-00-00']])
->get();
@endphp
@if ($condition == 0)
@php
++$condition;
@endphp
@foreach ($employeeListBranch as $keyL => $employeeValue)
@php
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_area')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_area')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
Head Office
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
Head Office
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endif
@foreach ($employeeList as $key1 => $value1)
@foreach ($value1 as $key2 => $value2)
@foreach ($value2 as $key3 => $value3)
@foreach ($value3 as $key4 => $employeeValue)
@php
// dd($employeeValue);
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_zone')
->where('id', $key1)
->pluck('name')
->toArray();
}
elseif ($reqBAZ == 'all_with_head_office') {
$areaName = DB::table('gnr_zone')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_zone')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endforeach
@endforeach
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endforeach
@else
@foreach ($employeeList as $key1 => $value1)
@foreach ($value1 as $key2 => $value2)
@foreach ($value2 as $key3 => $value3)
@foreach ($value3 as $key4 => $employeeValue)
@php
// dd($employeeValue);
++$sex;
++$totalSex;
$designation = DB::table('hr_emp_org_info')
->join('hr_settings_position', 'hr_emp_org_info.position_id_fk', 'hr_settings_position.id')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('name')
->toArray();
$branchNameOnly = DB::table('gnr_branch')
->join('hr_emp_org_info', 'gnr_branch.id', '=', 'hr_emp_org_info.branch_id_fk')
->where('hr_emp_org_info.emp_id_fk', $employeeValue->id)
->pluck('gnr_branch.name')
->toArray();
if ($reqBAZ == 'all') {
$areaName = DB::table('gnr_zone')
->where('id', $key1)
->pluck('name')
->toArray();
}
else {
$areaName = DB::table('gnr_zone')
->where('id', $reqBAZ)
->pluck('name')
->toArray();
}
// dd($areaName, $branchNameOnly);
@endphp
@if ($_colorPckerFirst == 1)
@php
$_colorPckerFirst = 0;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@else
@php
$_colorPckerFirst = 1;
@endphp
| {{++$slNo}} |
{{$employeeValue->emp_name_english}} |
{{$employeeValue->emp_id}} |
@foreach ($designation as $key => $value)
{{$value}}
@endforeach
|
@if ($areaName == '')
Head Office
@else
{{$areaName[0]}}
{{-- @foreach ($areaName as $key => $value)
{{$value}}
@endforeach --}}
@endif
|
{{$branchNameOnly[0]}} |
@if ($employeeValue->sex == 'Male')
1 |
0 |
@php
++$mSex;
++$mTotalSex;
@endphp
@else
0 |
1 |
@php
++$fSex;
++$fTotalSex;
@endphp
@endif
1 |
|
@endif
@endforeach
@endforeach
@endforeach
@endforeach
@endif
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
{{-- Zone Data End --}}
@endif