@if ($salary_summary_count > 0) @php $total_basic = 0; $total_allowance = 0; $total_reliability = 0; $total_adjustment = 0; $total_reward = 0; $total_add_pay = 0; $total_loan = 0; $provident_fund = 0; $all_total_deduction = 0; $total_add_deduction = 0; $total_gross = 0; $total_tax = 0; $total_net = 0; @endphp @foreach ($salary_summaries as $salary_summary) @if($salary_summary->NetSalary !=0) @php $department_data=App\Models\Departments::where('Department_ID',$salary_summary->Department)->first(); $designation=App\Models\Designations::where('DesignationID', $salary_summary->Designation)->first(); $total_deduction= $salary_summary->LateInAndEarluOutCharges+ $salary_summary->AbsentCharge+ $salary_summary->HalfDayCharge+ $salary_summary->AbsentDueToLowPerformanceCharge+ $salary_summary->HalfDueToLowPerformanceCharge; @endphp @php $total_basic = $total_basic +$salary_summary->BasicPay; $total_allowance = $total_allowance + $salary_summary->ConveyanceAllowance; $total_reliability = $total_reliability +$salary_summary->ReliabilityBonus; $total_adjustment = $total_adjustment + $salary_summary->Adjustment; $total_reward= $total_reward +$salary_summary->PerformanceReward; $total_add_pay= $total_add_pay+ $salary_summary->AddPayCharges; $total_loan= $total_loan + $salary_summary->loan_amount; $provident_fund= $provident_fund + $salary_summary->ProvidentFund; $all_total_deduction= $all_total_deduction+$total_deduction; $total_add_deduction=$total_add_deduction+ $salary_summary->DeductionCharges; $total_gross=$total_gross+$salary_summary->goss; $total_tax=$total_tax+$salary_summary->Tax; $total_net=$total_net+$salary_summary->NetSalary; @endphp @endif @endforeach @else @endif

S.No	Employee Name	Department	Date	Account Number	Designation	Basic Salary	Conveyance Allowance	Reliability Bonus	Adjustment	Performance Reward	Extra Day	Loan	Provident Fund	Cumulative Attendance Deduction	Performance Base Deduction	Gross Salary	Tax	Net Salary
{{ $salary_summary->FullName }}	{{ $department_data->DepartmentName }}	{{ date('F-Y',strtotime($salary_summary->Month)) }}	{{ $designation->AccountNumber }}	{{ $designation->DesignationName }}	{{number_format( $salary_summary->BasicPay) }}	{{number_format( $salary_summary->ConveyanceAllowance) }}	{{number_format( $salary_summary->ReliabilityBonus) }}	{{number_format( $salary_summary->Adjustment) }}	{{number_format( $salary_summary->PerformanceReward) }}	{{number_format( $salary_summary->AddPayCharges) }}	{{number_format( $salary_summary->loan_amount) }}	{{number_format( $salary_summary->ProvidentFund) }}	{{number_format( $total_deduction) }}	{{number_format( $salary_summary->DeductionCharges) }}	{{number_format( $salary_summary->goss) }}	{{number_format( $salary_summary->Tax) }}	{{number_format($salary_summary->NetSalary) }}
Total					{{$total_basic }}	{{$total_allowance }}	{{ $total_reliability}}	{{ $total_adjustment }}	{{$total_reward}}	{{$total_add_pay }}	{{ $total_loan}}	{{ $provident_fund}}	{{$all_total_deduction }}	{{$total_add_deduction}}	{{ $total_gross }}	{{ $total_tax }}	{{$total_net }}
No Record Found