Payslip for {{ showDate($payroll->from_date).' to '.showDate($payroll->to_date) }}
--}}
| Employee Code : |
{!! (isset($user->card_id)) ? $user->card_id : 'Nil' !!} |
|
Date of Payment : |
{!! showDate($payroll->date_of_payroll) !!} |
| Name : |
{!! $user->full_name !!} |
|
Contract Type : |
{!! ($user->userContract->last()) ? $user->userContract->last()->contractType->name : 'NO CONTRACT' !!} |
| NRIC/FIN : |
{!! (isset($user->Profile->unique_identification_number)) ? $user->Profile->unique_identification_number : ''!!} |
|
Date of Birth : |
{!! (isset($user->Profile->date_of_birth)) ? $user->Profile->date_of_birth : 'NIL' !!} |
| Site : |
{!! ($site) ? $site->name : 'NIL' !!} |
|
Designation : |
{!! (isset($user->designation_name)) ? $user->designation_name : 'Nil' !!} |
| Ethnic Group : |
{!! (!empty($user->Profile->ethnic_group)) ? $user->Profile->ethnic_group : 'Nil' !!} |
|
Age : |
{!! floor((Carbon::parse($user->Profile->date_of_birth)->diffInMonths($to_date)) / 12) !!} |
| Payment Method : |
{!! (!empty($payroll->payment_method)) ? ucfirst($payroll->payment_method) : 'Nil' !!} |
{{-- |
|
| --}}
@if(config('config.payroll_include_salary_summary') && $user_salary->type != "fixed")
| {!! trans('messages.user').' '.trans('messages.salary').' '.trans('messages.detail') !!} |
| {!! trans('messages.salary').' '.trans('messages.item') !!} |
{!! trans('messages.amount') !!} |
{!! trans('messages.salary').' '.trans('messages.item') !!} |
{!! trans('messages.amount') !!} |
@foreach($earning_salary_heads->whereNotIn('slug',['rest_day_overtime_x20','public_holiday_overtime_x20','allowance'])->chunk(2) as $earning_salary_head)
@foreach($earning_salary_head as $salary_head)
@if($user_salary->type != 'daily' && $salary_head->slug != 'basic_salary_daily')
@if($salary_head->slug == 'overtime')
| {!! $salary_head->name.' / Hour' !!} |
@elseif($salary_head->slug == 'leave_pay')
{!! $salary_head->name.' / Day' !!} |
@else
{!! $salary_head->name!!} |
@endif
@if ($salary_head->slug == 'overtime')
{!! currency($user_salary->overtimeHourlyRate,1,$user_salary->currency_id) !!} |
@elseif ($salary_head->slug == 'rest_day_work')
{!! currency($user_salary->restDayRate,1,$user_salary->currency_id) !!} |
@elseif ($salary_head->slug == 'public_holiday_allowance')
{!! currency($user_salary->publicDayRate,1,$user_salary->currency_id) !!} |
@elseif ($salary_head->slug == 'leave_pay')
{!! currency($user_salary->leaveDayRate,1,$user_salary->currency_id) !!} |
@else
{{-- {!! currency($user_salary->UserSalaryDetail->where('slug',$salary_head->slug)->first()->amount,1,$user_salary->currency_id) !!} | --}}
{!! currency(isset($user_salary->UserSalaryDetail->where('slug',$salary_head->slug)->first()->amount) ? $user_salary->UserSalaryDetail->where('slug',$salary_head->slug)->first()->amount : 0,1,$user_salary->currency_id) !!} | {{-- If the salary head has no amount, put it as 0 --}}
@endif
@elseif($user_salary->type == 'daily' && $salary_head->slug == 'basic_salary_daily')
{!! $salary_head->name !!} |
{!! currency(isset($user_salary->UserSalaryDetail->where('slug',$salary_head->slug)->first()->amount) ? $user_salary->UserSalaryDetail->where('slug',$salary_head->slug)->first()->amount : 0,1,$user_salary->currency_id) !!} |
@endif
@if (count($earning_salary_head) == 1)
|
|
@endif
@endforeach
@endforeach
|
@endif
| {!! trans('messages.earning') !!} |
{!! trans('messages.amount') !!} |
@foreach($earning_salary_heads as $earning_salary_head)
@if (isset($payroll_details[$earning_salary_head->slug]) && $payroll_details[$earning_salary_head->slug] > 0)
@if (!in_array($earning_salary_head->slug,['rest_day_overtime_x20','public_holiday_overtime_x20']))
@if ($earning_salary_head->slug == 'basic_salary')
| {!! $earning_salary_head->name.' (Days: '.((isset($payroll_detail_quantities[$earning_salary_head->slug])) ? $payroll_detail_quantities[$earning_salary_head->slug] : 0).')' !!} |
{!! array_key_exists($earning_salary_head->slug, $payroll_details) ? currency($payroll_details[$earning_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@elseif ($earning_salary_head->slug == 'overtime')
| {!! $earning_salary_head->name.' ('.currency($user_salary->hourlyRate,1,$payroll->currency_id).' x 1.5 x '.$payroll_detail_quantities[$earning_salary_head->slug].'hrs)' !!} |
{!! array_key_exists($earning_salary_head->slug, $payroll_details) ? currency($payroll_details[$earning_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@elseif ($earning_salary_head->slug == 'public_holiday_allowance')
| {!! $earning_salary_head->name.' (Days: '.round($payroll_detail_quantities[$earning_salary_head->slug],2).')' !!} |
{!! array_key_exists($earning_salary_head->slug, $payroll_details) ? currency($payroll_details[$earning_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@elseif ($earning_salary_head->slug == 'leave_pay')
{{-- @if($show_leave_section) --}}
| {!! $earning_salary_head->name.' (Days: '.round($payroll_detail_quantities[$earning_salary_head->slug]).')' !!} |
{!! array_key_exists($earning_salary_head->slug, $payroll_details) ? currency($payroll_details[$earning_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@foreach($leave_heads as $leave_head)
@if($leave_payroll_details[$leave_head->name] > 0)
| {!! $leave_head->name.' (Days: '.round($leave_payroll_detail_quantities[$leave_head->name]).')' !!} |
{!! array_key_exists($leave_head->name, $leave_payroll_details) ? currency($leave_payroll_details[$leave_head->name],1,$payroll->currency_id) : 0 !!} |
@endif
@endforeach
{{-- @endif --}}
@else
@if($earning_salary_head->slug == 'basic_salary_daily')
| {!! $earning_salary_head->name.' (Days: '.((isset($payroll_detail_quantities[$earning_salary_head->slug])) ? round($payroll_detail_quantities[$earning_salary_head->slug]) : 0).')' !!} |
@else
{!! $earning_salary_head->name !!} |
@endif
{!! array_key_exists($earning_salary_head->slug, $payroll_details) ? currency($payroll_details[$earning_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@endif
@endif
@endif
@endforeach
{{-- To show custom salary heads --}}
@if(isset($earning_custom_payroll_details))
| {!! trans('messages.custom').' '.trans('messages.earning').' '.trans('messages.head') !!} |
|
@foreach($custom_earning_heads as $custom_earning_head)
| {!! $custom_earning_head->name !!} |
{!! array_key_exists($custom_earning_head->id, $earning_custom_payroll_details) ? currency($earning_custom_payroll_details[$custom_earning_head->id][$custom_earning_head->name],1,$payroll->currency_id) : 0 !!} |
@endforeach
@endif
@if($user->Profile->nationality == 'Foreigner')
{!! trans('messages.total').' '.trans('messages.earning') !!} |
{!! currency($total_earning,1,$payroll->currency_id,true) !!} |
@else
{!! trans('messages.total').' '.trans('messages.earning').'
('.trans('messages.cpf').' '.trans('messages.payable').' '.trans('messages.amount').')' !!} |
{!! currency($total_earning,1,$payroll->currency_id).'
('.currency(($ordinary_cpf_amount + $additional_cpf_amount),1,$payroll->currency_id,true).')' !!} |
@endif
|
| {!! trans('messages.deduction') !!} |
{!! trans('messages.amount') !!} |
@foreach($deduction_salary_heads as $deduction_salary_head)
@if (isset($payroll_details[$deduction_salary_head->slug]) && $payroll_details[$deduction_salary_head->slug] > 0)
@if($deduction_salary_head->slug == 'shg_fund_donation' || $deduction_salary_head->slug == 'employee_cpf')
@if($user->Profile->nationality != "Foreigner")
@if ($deduction_salary_head->slug == 'shg_fund_donation')
| {!! $deduction_salary_head->name.' ('.$user->Profile->shg_fund.')' !!} |
{!! array_key_exists($deduction_salary_head->slug, $payroll_details) ? currency($payroll_details[$deduction_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@else
| {!! $deduction_salary_head->name !!} |
{!! array_key_exists($deduction_salary_head->slug, $payroll_details) ? currency($payroll_details[$deduction_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@endif
@endif
@else
@if($deduction_salary_head->slug == 'advance_payment')
| {!! $deduction_salary_head->name !!} |
{!! array_key_exists($deduction_salary_head->slug, $payroll_details) ? currency($payroll_details[$deduction_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@if(isset($advance_payments))
@foreach($advance_payments as $advance_payment)
| {!! trans('messages.advance').' '.trans('messages.payment').' ('.$advance_payment['date'].')' !!} |
{!! currency($advance_payment['amount'],1,$payroll->currency_id)!!} |
@endforeach
@endif
@else
| {!! ($deduction_salary_head->slug == 'incomplete_month_of_work') ? ($deduction_salary_head->name.' (Days: '.round($payroll_detail_quantities[$deduction_salary_head->slug]).')') : $deduction_salary_head->name !!} |
{!! array_key_exists($deduction_salary_head->slug, $payroll_details) ? currency($payroll_details[$deduction_salary_head->slug],1,$payroll->currency_id) : 0 !!} |
@endif
@endif
@endif
@endforeach
{{-- To show custom salary heads --}}
@if(isset($deduction_custom_payroll_details))
| {!! trans('messages.custom').' '.trans('messages.deduction').' '.trans('messages.head') !!} |
|
@foreach($custom_deduction_heads as $custom_deduction_head)
| {!! $custom_deduction_head->name !!} |
{!! array_key_exists($custom_deduction_head->id, $deduction_custom_payroll_details) ? currency($deduction_custom_payroll_details[$custom_deduction_head->id][$custom_deduction_head->name],1,$payroll->currency_id) : 0 !!} |
@endforeach
@endif
| {!! trans('messages.total').' '.trans('messages.deduction') !!} |
{!! currency($total_deduction,1,$payroll->currency_id) !!} |
|
| {!! trans('messages.summary') !!} |
{!! trans('messages.amount') !!} |
@if($user->Profile->nationality != "Foreigner")
| Employee CPF ({!! round($user->calculateCPF($ordinary_cpf_amount,$additional_cpf_amount, $payroll->currency_id, $payroll->to_date)['employee_cpf_percentage'],2) !!}%) |
{!! currency(isset($payroll_details['employee_cpf']) ? $payroll_details['employee_cpf'] : 0,1,$payroll->currency_id) !!} |
| Employer CPF ({!! round($user->calculateCPF($ordinary_cpf_amount,$additional_cpf_amount, $payroll->currency_id, $payroll->to_date)['employer_cpf_percentage'],2) !!}%) |
{!! currency($user->calculateCPF($ordinary_cpf_amount,$additional_cpf_amount, $payroll->currency_id, $payroll->to_date)['employer_cpf'],1,$payroll->currency_id) !!} |
| Total CPF |
{!! currency(($user->calculateCPF($ordinary_cpf_amount,$additional_cpf_amount, $payroll->currency_id, $payroll->to_date)['employer_cpf']+$user->calculateCPF($ordinary_cpf_amount,$additional_cpf_amount, $payroll->currency_id, $payroll->to_date)['employee_cpf']),1,$payroll->currency_id) !!} |
@endif
| {!! trans('messages.gross').' '.trans('messages.salary') !!} |
{!! currency(($total_earning),1,$payroll->currency_id) !!} |
@if ($user_salary->type == "monthly")
{!! trans('messages.net').' '.trans('messages.salary').'
for Working Days ('.($att_summary['P'] + $att_summary['H'] + $att_summary['L']).')' !!} |
@else
{!! trans('messages.net').' '.trans('messages.salary') !!} |
@endif
{!! currency(($total_earning - $total_deduction),1,$payroll->currency_id) !!}
{!! "(".ucwords(numberToWord(currency(($total_earning-$total_deduction)))).")" !!}
|
|
@if (!empty($payroll->description))
| Remarks |
| {{ $payroll->description }} |
|
@endif
@if (!empty($user_leave_data))
| {{ trans('messages.leave').' '.trans('messages.summary').' ('.trans('messages.leave_up_to').' '.$payroll->to_date.')' }} |
@foreach($leave_types as $leave_type)
@if(isset($user_leave_data[$leave_type->slug]['leave_assigned']) && $user_leave_data[$leave_type->slug]['leave_assigned'] != 0)
| {!!$leave_type->name!!}
@endif
@endforeach
|
@foreach($leave_types as $leave_type)
@if(isset($user_leave_data[$leave_type->slug]['leave_assigned']) && $user_leave_data[$leave_type->slug]['leave_assigned'] != 0)
| {!!((isset($user_leave_data[$leave_type->slug]['leave_used'])) ? $user_leave_data[$leave_type->slug]['leave_used'] : '0').'/'.
((isset($user_leave_data[$leave_type->slug]['leave_assigned'])) ? $user_leave_data[$leave_type->slug]['leave_assigned'] : '0')!!}
@endif
@endforeach
|
|
@endif