PayRollController

app / Http / Controllers / PayRollController.php

payRoll

public function payRoll(){
        if (!Auth::user()->can('View Payroll')){
            return abort('404');
        }
        return view('Payroll.index');
    }

payRollTable

public function payRollTable(Request $request){
    if (!Auth::user()->can('View Payroll')){
        return abort('404');
    }

    $employee_name = $request->employee_name;
    $month = $request->month;
    $year = $request->year;

    $startOfMonth = $year.'-'.$month.'-'.'01'; //2022-05-01
    $endOfMonth = Carbon::parse($startOfMonth)->endOfMonth()->format('Y-m-d');

    $daysInMonth = Carbon::parse($startOfMonth)->daysInMonth; //daysInMonth from Carbon

    $workingDays = Carbon::parse($startOfMonth)
                            ->diffInDaysFiltered(function (Carbon $date){
                                return $date->isWeekday();
                        },Carbon::parse($endOfMonth))->addDays(1); // parse for string

    $offDays = $daysInMonth - $workingDays;

    $attendances = CheckInCheckOut::whereMonth('Indate', $month)
        ->whereYear('Indate', $year)
        ->get();

    $companySetting = CompanySetting::findOrfail(1);

    $employees = User::orderBy('name')
        ->with('salariesInfo')
        ->where('name', 'like', "%$employee_name%")
        ->get();
    $periods = new CarbonPeriod($startOfMonth, $endOfMonth);

    return view('Payroll.payrollTable', [
        'employees' => $employees,
        'attendances' => $attendances,
        'companySetting' => $companySetting,
        'periods' => $periods,
        'daysInMonth' => $daysInMonth,
        'workingDays' => $workingDays,
        'offDays' => $offDays,
        'month' => $month,
        'year' => $year
    ])->render(); // render for ajax
}

Code Overview

<?php

namespace App\Http\Controllers;

use App\Models\CheckInCheckOut;
use App\Models\CompanySetting;
use App\Models\User;
use Carbon\Carbon;
use Carbon\CarbonPeriod;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class PayrollController extends Controller
{
    public function payRoll(){
        if (!Auth::user()->can('View Payroll')){
            return abort('404');
        }
        return view('Payroll.index');
    }
    public function payRollTable(Request $request){
        if (!Auth::user()->can('View Payroll')){
            return abort('404');
        }

        $employee_name = $request->employee_name;
        $month = $request->month;
        $year = $request->year;

        $startOfMonth = $year.'-'.$month.'-'.'01'; //2022-05-01
        $endOfMonth = Carbon::parse($startOfMonth)->endOfMonth()->format('Y-m-d');

        $daysInMonth = Carbon::parse($startOfMonth)->daysInMonth; //daysInMonth from Carbon

        $workingDays = Carbon::parse($startOfMonth)
                                ->diffInDaysFiltered(function (Carbon $date){
                                    return $date->isWeekday();
                            },Carbon::parse($endOfMonth))->addDays(1); // parse for string

        $offDays = $daysInMonth - $workingDays;

        $attendances = CheckInCheckOut::whereMonth('Indate', $month)
            ->whereYear('Indate', $year)
            ->get();

        $companySetting = CompanySetting::findOrfail(1);

        $employees = User::orderBy('name')
            ->with('salariesInfo')
            ->where('name', 'like', "%$employee_name%")
            ->get();
        $periods = new CarbonPeriod($startOfMonth, $endOfMonth);

        return view('Payroll.payrollTable', [
            'employees' => $employees,
            'attendances' => $attendances,
            'companySetting' => $companySetting,
            'periods' => $periods,
            'daysInMonth' => $daysInMonth,
            'workingDays' => $workingDays,
            'offDays' => $offDays,
            'month' => $month,
            'year' => $year
        ])->render(); // render for ajax
    }
}