How to Calculate Total and Working Days in Laravel and JavaScripts?

How to Calculate Total and Working Days in Laravel and JavaScripts?

To calculate total and working days in Laravel and JavaScript, you can use a combination of Laravel's Carbon library and JavaScript's Date object. Here's a step-by-step guide on how to do it:

1. Install Carbon library in Laravel:

If you haven't installed Carbon library in your Laravel project, you can install it via composer by running the following command in your terminal:

composer require carbon/carbon

2. Define helper function in Laravel to calculate total days between two dates:

Create a helper function in your Laravel project to calculate the total number of days between two dates using Carbon library. Add the following code in your app/Helpers/Helper.php file:

if (!function_exists('totalDays')) {
    function totalDays($startDate, $endDate)
    {
        return Carbon\Carbon::parse($startDate)->diffInDays(Carbon\Carbon::parse($endDate), false);
    }
}

3. Define helper function in JavaScript to calculate working days:

Create a helper function in your JavaScript file to calculate the number of working days between two dates. Add the following code in your resources/js/app.js file:

if (!window.totalWorkingDays) {
    window.totalWorkingDays = function(startDate, endDate, workingDays) {
        let totalDays = Math.floor((endDate - startDate) / (1000 * 60 * 60 * 24)) + 1;
        let workingDaysCount = 0;

        let currentDate = new Date(startDate);
        while (currentDate <= endDate) {
            let dayOfWeek = currentDate.getDay();
            if (workingDays.includes(dayOfWeek)) {
                workingDaysCount++;
            }
            currentDate.setDate(currentDate.getDate() + 1);
        }

        return workingDaysCount;
    }
}

Replace workingDays with an array of working days (0-6, where 0 is Sunday and 6 is Saturday).

4. Use helper functions in Laravel and JavaScript:

Now you can use these helper functions in your Laravel and JavaScript code to calculate total and working days.

For example, in Laravel, you can use the totalDays helper function to calculate the total number of days between two dates:

$startDate = Carbon\Carbon::parse('2022-01-01');
$endDate = Carbon\Carbon::parse('2022-01-31');

$totalDays = totalDays($startDate, $endDate);

In JavaScript, you can use the totalWorkingDays helper function to calculate the number of working days between two dates:

let startDate = new Date('2022-01-01');
let endDate = new Date('2022-01-31');
let workingDays = [0, 2, 3, 4, 5]; // Monday, Wednesday, Thursday, Friday, Saturday

let workingDaysCount = totalWorkingDays(startDate, endDate, workingDays);

That's it! You have now learned how to calculate total and working days in Laravel and JavaScript using Carbon library and JavaScript's Date object.