|
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;
// dd($employeeList);
@endphp
@if ($reqCategory == 'Branch')
{{-- Branch data start --}}
@if ($reqBAZ == 'all')
@foreach ($employeeList as $key => $employee)
@foreach ($employee as $key => $employeeValue)
@php
// dd($employeeValue['emp_name_english']);
++$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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
// dd($prevDsignation, $employeeValue['id'], $approveDate, $approveDateFormat, $previousData, $decodedPreviousData->value->position->name, $designation);
$branchID = $employeeValue['branchId'];
$branchNameOnly = DB::table('gnr_branch')
->where('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) {
$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
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
// dd($employeeList);
@endphp
@endforeach
@else
@foreach ($employeeList as $key => $employee)
@foreach ($employee as $key => $employeeValue)
@php
// dd($employeeValue['emp_name_english']);
++$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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $employeeValue['branchId'];
$branchNameOnly = DB::table('gnr_branch')
->where('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) {
$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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
// dd($employeeList);
@endphp
@endforeach
@endif
| Total |
{{$mTotalSex}} |
{{$fTotalSex}} |
{{$totalSex}} |
|
{{-- Branch data end --}}
@elseif ($reqCategory == 'Area')
@php
// dd($employeeList);
@endphp
{{-- 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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key2;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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], ['joining_date', '<=', $endDate]])
->orWhere([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '=', '0000-00-00'], ['joining_date', '<=', $endDate]])
->get();
@endphp
@if ($condition == 0)
@php
++$condition;
@endphp
@foreach ($employeeListBranch as $keyL => $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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue->id]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@php
$mSex = 0;
$fSex = 0;
$sex = 0;
@endphp
@endif
@php
// dd($employeeList);
@endphp
@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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key2;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key1;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key3;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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], ['joining_date', '<=', $endDate]])
->orWhere([['hr_emp_org_info.branch_id_fk', '=', 1], ['hr_emp_org_info.terminate_resignation_date', '=', '0000-00-00'], ['joining_date', '<=', $endDate]])
->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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue->id]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key3;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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}} |
|
--}}
@if ($sex > 0)
| Sub Total |
{{$mSex}} |
{{$fSex}} |
{{$sex}} |
|
@endif
@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();
// PREVIOUS DESIGNATION START
$prevDsignation = DB::table('hr_promotion_increment')
->join('users', 'hr_promotion_increment.users_id_fk', '=', 'users.id')
->where([['approved_time', '!=', null], ['effect_month', '>', $endDate], ['users.emp_id_fk', $employeeValue['id']]])
->select('users.emp_id_fk', 'approved_time', 'previous_data')
->limit(1)
->get();
$approveDate = $prevDsignation->pluck('approved_time')->toArray();
if (sizeof($approveDate) > 0) {
$approveDateFormat = date_format(date_create($approveDate[0]), 'Y-m-d');
if ($approveDateFormat > $endDate) {
$previousData = $prevDsignation->pluck('previous_data')->toArray();
$decodedPreviousData = json_decode($previousData[0]);
$designation = [
str_replace('','"',$decodedPreviousData->value->position->name)
];
}
}
// PREVIOUS DESIGNATION END
$branchID = $key3;
$branchNameOnly = DB::table('gnr_branch')
->where('id', $branchID)
->pluck('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