Laravel 7 Fullcalendar Ajax Example Tutorial

June 17, 2020 XpertPhp Comments 0 Comment

Today, We will learn step by step how to integrate fullcalendar in laravel 7. we will use jQuery, jQuery UI, FullCalendar js, and Moment.js in this fullcalendar example.

FullCalendar is useful for appointment booking, event scheduling, task management, and see which peoples are leave in this current month, etc.

You can select one date or multiple dates in this example and JSON type of data pass to events to display the calendar. you can add events for a particular date or update the event.

So you can see our example source code.

Overview

Step 1: Install laravel
Step 2: Setting Database Configuration
Step 3: Create Table using migration
Step 4: Create Route
Step 5: Create a Model and Controller
Step 6: Create a view file.
Step 7: Run Our Laravel Application

Step 1: Install laravel

Install the laravel using the below command.

composer create-project --prefer-dist laravel/laravel laravel7_fullcalendar

1	composer create-project --prefer-dist laravel/laravel laravel7_fullcalendar

Step 2: Setting Database Configuration

After the complete installation of laravel. we have to database configuration. now we will open the .env file and change the database name, username, password in the .env file. See below changes in a .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(laravel7_fullcalendar)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name(laravel7_fullcalendar)

DB_USERNAME=Enter_Your_Database_Username(root)

DB_PASSWORD=Enter_Your_Database_Password(root)

Step 3: Create Table using migration
Now, We need to create a migration. so we will below command using create the bookings table migration.
Create The table using the below command.

php artisan make:migration create_bookings_table --create=bookings

1	php artisan make:migration create_bookings_table --create=bookings

After complete migration. we need below changes in the database/migrations/create_bookings_table file.

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateBookingsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('bookings', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->date('start');
            $table->date('end');
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('bookings');
    }
}
?>

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateBookingsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('bookings', function (Blueprint $table) {

$table->bigIncrements('id');

$table->string('title');

$table->date('start');

$table->date('end');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('bookings');

}

Run the below command. after the changes above file.

php artisan migrate

1	php artisan migrate

Step 4: Create Route
Add the following route code in the “routes/web.php” file.

<?php

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/', function () {
    return view('welcome');
});



Route::get('/booking','FullCalendarController@index');
Route::post('/booking/create','FullCalendarController@create');
Route::post('/booking/update','FullCalendarController@update');
Route::post('/booking/delete','FullCalendarController@destroy');
?>

<?php

|--------------------------------------------------------------------------

| Web Routes

|--------------------------------------------------------------------------

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('/', function () {

return view('welcome');

});

Route::get('/booking','FullCalendarController@index');

Route::post('/booking/create','FullCalendarController@create');

Route::post('/booking/update','FullCalendarController@update');

Route::post('/booking/delete','FullCalendarController@destroy');

Step 5: Create a Model and Controller

Now, We will create the controller and model using the below command and paste below code in this controller.

php artisan make:controller FullCalendarController

1	php artisan make:controller FullCalendarController

php artisan make:model Booking

1	php artisan make:model Booking

FullCalendarController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Booking;
use Redirect,Response;

class FullCalendarController extends Controller
{
    public function index()
	{
		if(request()->ajax())
		{
			$start = (!empty($_GET["start"])) ? ($_GET["start"]) : ('');
			$end = (!empty($_GET["end"])) ? ($_GET["end"]) : ('');
			$data = Booking::whereDate('start', '>=', $start)->whereDate('end',   '<=', $end)->get(['id','title','start', 'end']);
			return Response::json($data);
		}
		return view('fullcalendar');
	}
	public function create(Request $request)
	{
		$insertArr = [ 'title' => $request->title,
		'start' => $request->start,
		'end' => $request->end
		];
		$booking = Booking::insert($insertArr);
		return Response::json($booking);
	}
	public function update(Request $request)
	{
		$where = array('id' => $request->id);
		$updateArr = ['title' => $request->title,'start' => $request->start, 'end' => $request->end];
		$booking  = Booking::where($where)->update($updateArr);
		return Response::json($booking);
	}
	public function destroy(Request $request)
	{
		$booking = Booking::where('id',$request->id)->delete();
		return Response::json($booking);
	}
}

?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Booking;

use Redirect,Response;

class FullCalendarController extends Controller

{

public function index()

{

if(request()->ajax())

{

$start = (!empty($_GET["start"])) ? ($_GET["start"]) : ('');

$end = (!empty($_GET["end"])) ? ($_GET["end"]) : ('');

$data = Booking::whereDate('start', '>=', $start)->whereDate('end', '<=', $end)->get(['id','title','start', 'end']);

return Response::json($data);

}

return view('fullcalendar');

}

public function create(Request $request)

{

$insertArr = [ 'title' => $request->title,

'start' => $request->start,

'end' => $request->end

];

$booking = Booking::insert($insertArr);

return Response::json($booking);

}

public function update(Request $request)

{

$where = array('id' => $request->id);

$updateArr = ['title' => $request->title,'start' => $request->start, 'end' => $request->end];

$booking = Booking::where($where)->update($updateArr);

return Response::json($booking);

}

public function destroy(Request $request)

{

$booking = Booking::where('id',$request->id)->delete();

return Response::json($booking);

}

Booking.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Booking extends Model
{
    protected $fillable = ['title','start','end'];
}
?>

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Booking extends Model

{

protected $fillable = ['title','start','end'];

}

Step 6: Create a view file.

Finally, We will create a fullcalendar.blade.php file in the “resources/views/” folder directory and paste below code.

<!DOCTYPE html>
<html>
<head>
<title>Laravel 7 Fullcalendar Ajax Example Tutorial - XpertPhp</title>
<meta name="csrf-token" content="{{ csrf_token() }}">
</head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/3.9.0/fullcalendar.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment.min.js" integrity="sha256-4iQZ6BVL4qNKlQ27TExEhBN1HFPvAvAMbFavKKosSWQ=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/3.9.0/fullcalendar.js"></script>
<body>
<div class="container">
<div class="response"></div>
<div id='calendar'></div>
</div>
<script>
  $(document).ready(function () {
         
        var SITEURL = "{{url('/')}}";
        $.ajaxSetup({
          headers: {
              'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
          }
        });
 
        var calendar = $('#calendar').fullCalendar({
            editable: true,
            events: SITEURL + "booking",
            displayEventTime: true,
            editable: true,
            eventRender: function (event, element, view) {
                if (event.allDay === 'true') {
                    event.allDay = true;
                } else {
                    event.allDay = false;
                }
            },
            selectable: true,
            selectHelper: true,
            select: function (start, end, allDay) {
                var title = prompt('Event Title:');
 
                if (title) {
                    var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");
                    var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");
 
                    $.ajax({
                        url: SITEURL + "booking/create",
                        data: 'title=' + title + '&amp;start=' + start + '&amp;end=' + end,
                        type: "POST",
                        success: function (data) {
                            displayMessage("Added Successfully");
                        }
                    });
                    calendar.fullCalendar('renderEvent',
                            {
                                title: title,
                                start: start,
                                end: end,
                                allDay: allDay
                            },
                    true
                            );
                }
                calendar.fullCalendar('unselect');
            },
             
            eventDrop: function (event, delta) {
                        var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");
                        var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");
                        $.ajax({
                            url: SITEURL + 'booking/update',
                            data: 'title=' + event.title + '&amp;start=' + start + '&amp;end=' + end + '&amp;id=' + event.id,
                            type: "POST",
                            success: function (response) {
                                displayMessage("Updated Successfully");
                            }
                        });
                    },
            eventClick: function (event) {
                var deleteMsg = confirm("Do you really want to delete?");
                if (deleteMsg) {
                    $.ajax({
                        type: "POST",
                        url: SITEURL + 'booking/delete',
                        data: "&amp;id=" + event.id,
                        success: function (response) {
                            if(parseInt(response) > 0) {
                                $('#calendar').fullCalendar('removeEvents', event.id);
                                displayMessage("Deleted Successfully");
                            }
                        }
                    });
                }
            }
 
        });
  });
 
  function displayMessage(message) {
    $(".response").html("<div class='success'>"+message+"</div>");
    setInterval(function() { $(".success").fadeOut(); }, 1000);
  }
</script>
</body>
</html>

100

101

102

103

104

105

106

107

<!DOCTYPE html>

<html>

<head>

<title>Laravel 7 Fullcalendar Ajax Example Tutorial - XpertPhp</title>

</head>

<body>

</div>

$(document).ready(function () {

var SITEURL = "{{url('/')}}";

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

var calendar = $('#calendar').fullCalendar({

editable: true,

events: SITEURL + "booking",

displayEventTime: true,

editable: true,

eventRender: function (event, element, view) {

if (event.allDay === 'true') {

event.allDay = true;

} else {

event.allDay = false;

}

selectable: true,

selectHelper: true,

select: function (start, end, allDay) {

var title = prompt('Event Title:');

if (title) {

var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");

var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");

$.ajax({

url: SITEURL + "booking/create",

data: 'title=' + title + '&start=' + start + '&end=' + end,

type: "POST",

success: function (data) {

displayMessage("Added Successfully");

}

});

calendar.fullCalendar('renderEvent',

{

title: title,

start: start,

end: end,

allDay: allDay

true

);

}

calendar.fullCalendar('unselect');

eventDrop: function (event, delta) {

var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");

var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");

$.ajax({

url: SITEURL + 'booking/update',

data: 'title=' + event.title + '&start=' + start + '&end=' + end + '&id=' + event.id,

type: "POST",

success: function (response) {

displayMessage("Updated Successfully");

}

});

eventClick: function (event) {

var deleteMsg = confirm("Do you really want to delete?");

if (deleteMsg) {

$.ajax({

type: "POST",

url: SITEURL + 'booking/delete',

data: "&id=" + event.id,

success: function (response) {

if(parseInt(response) > 0) {

$('#calendar').fullCalendar('removeEvents', event.id);

displayMessage("Deleted Successfully");

}

});

}

});

function displayMessage(message) {

$(".response").html("<div class='success'>"+message+"</div>");

setInterval(function() { $(".success").fadeOut(); }, 1000);

}

</script>

</body>

</html>

Step 7: Run Our Laravel Application
We can start the server and run this example using the below command.

php artisan serve

1	php artisan serve

Now we will run our example using the below Url in the browser.

http://127.0.0.1:8000/booking

1	http://127.0.0.1:8000/booking

Please follow and like us: