Criando um Lembrete de Tarefa com Laravel e MongoDB

1
composer create-project laravel/laravel LaravelMongodbProject
2
cd LaravelMongodbProject

1
composer require mongodb/laravel-mongodb

1
return [
2
    'connections' => [
3
      'mongodb' => [
4
      'driver' => 'mongodb',
5
      'dsn' => env('MONGODB_URI'),
6
      'database' => 'YOUR_DATABASE_NAME',
7
    ],
8
    //You can keep other existing connections
9
  ],

1
MONGODB_URI="<<MONGODB_ATLAS_CONNECTION_STRING>>"
2
DB_CONNECTION=mongodb

1
composer require laravel/breeze --dev

1
php artisan key:generate
2
3
php artisan breeze:install
4
php artisan migrate
5
6
php artisan db:seed
7
npm install
8
npm run dev

1
┌ Which Breeze stack would you like to install? ───────────────┐
2
│ > ● Blade with Alpine │
3
│ ○ Livewire (Volt Class API) with Alpine │
4
│ ○ Livewire (Volt Functional API) with Alpine │
5
│ ○ React with Inertia │
6
│ ○ Vue with Inertia │
7
│ ○ API only 

1
php artisan serve

1
Route::get('/ping', function  (Request $request) {
2
  $connection = DB::connection('mongodb');
3
  try {
4
    $connection->command(['ping' => 1]);
5
    $msg = 'MongoDB is accessible!';
6
  } catch (Exception $e) {
7
    $msg = 'You are not connected to MongoDB. Error: ' . $e->getMessage();
8
  }
9
  return ['msg' => $msg];
10
});

1
php artisan make:model Task --resource --controller

1
use  App\Http\Controllers\TaskController;
2
Route::resource('tasks', TaskController::class)->middleware('auth');

1
<?php
2
namespace  App\Models;
3
use  MongoDB\Laravel\Eloquent\Model;
4
class  Task  extends  Model
5
{
6
  protected $connection = 'mongodb';
7
  protected $table = 'tasks';
8
  protected $fillable = [
9
    'title', 'description', 'due_date', 'email', 'reminder_time', 'last_notification_date'
10
  ];
11
}

1
<?php
2
namespace  App\Http\Controllers;
3
use App\Models\Task;
4
use Carbon\Carbon;
5
use Illuminate\Http\Request;
6
class TaskController extends Controller
7
{
8
    /**
9
    * Display a listing of the resource.
10
    */
11
    public  function  index()
12
    {
13
        $tasks = Task::where('email', auth()->user()->email)->get();
14
        return view('tasks.index', compact('tasks'));
15
    }
16
17
    /**
18
    * Show the form for creating a new resource.
19
    */
20
    public  function  create()
21
    {
22
        return view('tasks.create');
23
    }
24
25
    /**
26
    * Store a newly created resource in storage.
27
    */
28
    public  function  store(Request $request)
29
    {
30
        $request->validate([
31
            'title' => 'required|string|max:255',
32
            'description' => 'nullable|string',
33
            'due_date' => 'required|date',
34
            'reminder_time' => 'required|date',
35
        ]);
36
37
        $data = $request->all();
38
        $data['due_date'] = Carbon::parse($request->due_date);
39
        $data['reminder_time'] = Carbon::parse($request->reminder_time);
40
        $data['email'] = auth()->user()->email;
41
42
        $data['last_notification_date'] = null;
43
44
        Task::create($data);
45
46
        return redirect()->route('tasks.index')->with('success', 'Task created successfully.');
47
    }
48
49
    /**
50
    * Display the specified resource.
51
    */
52
    public  function  show(string $id)
53
    {
54
        //
55
    }
56
57
    /**
58
    * Show the form for editing the specified resource.
59
    */
60
    public  function  edit(string $id)
61
    {
62
        $tasks = Task::where('id', $id)->get();
63
        return view('tasks.edit', ['tasks' => $tasks]);
64
    }
65
66
    /**
67
    * Update the specified resource in storage.
68
    */
69
    public  function  update(Request $request, string $id)
70
    {
71
        $task = Task::findOrFail($id);
72
        $data = $request->all();
73
74
        $data['due_date'] = Carbon::parse($request->due_date)->format('Y-m-d H:i:s');
75
        $data['reminder_time'] = Carbon::parse($request->reminder_time)->format('Y-m-d H:i:s');
76
        $task->update($data);
77
78
        return redirect()->route('tasks.index')->with('success', 'Task updated successfully.');
79
    }
80
81
    /**
82
    * Remove the specified resource from storage.
83
    */
84
    public  function  destroy(string $id)
85
    {
86
        $task = Task::findOrFail($id);
87
        $task->delete();
88
        Return redirect()->route('tasks.index')->with('success', 'Task deleted successfully.');
89
    }
90
}

1
<x-app-layout>
2
    <x-slot name="header">
3
        <h2 class="font-semibold  text-xl  text-gray-800 leading-tight">
4
            {{ __('Tasks') }}
5
        </h2>
6
    </x-slot>
7
8
    <div class="py-12">
9
        <div  class="max-w-7xl  mx-auto  sm:px-6 lg:px-8">
10
            <div  class="bg-white  overflow-hidden  shadow-sm  sm:rounded-lg">
11
                <div  class="container  mx-auto  p-4">
12
                    <h2  class="text-2xl  font-bold  mb-4">Create  New  Task</h2>
13
                    <form  action="{{ route('tasks.store') }}" method="POST">
14
                        @csrf
15
                        <div class="mb-4">
16
                            <label for="title" class="block text-gray-700">Title:</label>
17
                            <input type="text" name="title" id="title" required class="border border-gray-300 p-2 w-full" value="{{ old('title') }}">
18
                            @error('title')
19
                            <p class="text-red-500">{{ $message }}</p>
20
                            @enderror
21
                        </div>
22
                        <div class="mb-4">
23
                            <label for="description" class="block text-gray-700">Description:</label>
24
                            <textarea name="description" id="description" class="border border-gray-300 p-2 w-full">{{ old('description') }}</textarea>
25
                        </div>
26
                        <div class="mb-4">
27
                            <label for="due_date" class="block text-gray-700">Due Date:</label>
28
                            <input type="date" name="due_date" id="due_date" required class="border border-gray-300 p-2 w-full" value="{{ old('due_date') }}">
29
                            @error('due_date')
30
                            <p class="text-red-500">{{ $message }}</p>
31
                            @enderror
32
                        </div>
33
                        <div class="mb-4">
34
                            <label for="reminder_time" class="block text-gray-700">Reminder Time:</label>
35
                            <input type="datetime-local" name="reminder_time" id="reminder_time" class="border border-gray-300 p-2 w-full" value="{{ old('reminder_time') }}">
36
                        </div>
37
                        <button type="submit" class="bg-green-600 text-white text-gray-399 p-2 border rounded">Create Task</button>
38
                    </form>
39
                </div>
40
            </div>
41
        </div>
42
    </div>
43
</x-app-layout>
44

1
<x-app-layout>
2
    <x-slot name="header">
3
        <h2 class="font-semibold  text-xl  text-gray-800 leading-tight">
4
            {{ __('Edit Task') }}
5
        </h2>
6
    </x-slot>
7
8
    <div class="py-12">
9
        <div  class="max-w-7xl  mx-auto  sm:px-6 lg:px-8">
10
            <div  class="bg-white  overflow-hidden  shadow-sm  sm:rounded-lg">
11
                <div  class="p-6 text-gray-900">
12
                    @foreach($tasks  as $task)
13
                        <form  action="{{ route('tasks.update', $task->id) }}" method="POST">
14
                            @csrf
15
                            @method('PUT')
16
                            <div class="mb-4">
17
                                <label for="title" class="block text-gray-700">Title:</label>
18
                                <input type="text" name="title" id="title" required class="border border-gray-300 p-2 w-full" value="{{ old('title', $task->title) }}">
19
                                @error('title')
20
                                <p class="text-red-500">{{ $message }}</p>
21
                                @enderror
22
                            </div>
23
                            <div class="mb-4">
24
                                <label for="description" class="block text-gray-700">Description:</label>
25
                                <textarea name="description" id="description" class="border border-gray-300 p-2 w-full">{{ old('description', $task->description) }}</textarea>
26
                            </div>
27
                            <div class="mb-4">
28
                                <label for="due_date" class="block text-gray-700">Due Date:</label>
29
                                <input type="date" name="due_date" id="due_date" required class="border border-gray-300 p-2 w-full" value="{{ old('due_date', $task->due_date) }}">
30
                                @error('due_date')
31
                                <p class="text-red-500">{{ $message }}</p>
32
                                @enderror
33
                            </div>
34
                            <div class="mb-4">
35
                                <label for="reminder_time" class="block text-gray-700">Reminder Time:</label>
36
                                <input type="datetime-local" name="reminder_time" id="reminder_time" class="border border-gray-300 p-2 w-full" value="{{ old('reminder_time', $task->reminder_time) }}">
37
                            </div>
38
                            <button type="submit" class="bg-blue-500 text-white p-2 rounded">Update Task</button>
39
                        </form>
40
                    @endforeach
41
                </div>
42
            </div>
43
        </div>
44
    </div>
45
</x-app-layout>

1
<x-app-layout>
2
    <x-slot name="header">
3
        <h2 class="font-semibold  text-xl  text-gray-800 leading-tight">
4
            {{ __('Tasks') }}
5
        </h2>
6
    </x-slot>
7
8
    <div class="py-12">
9
        <div  class="max-w-7xl  mx-auto  sm:px-6 lg:px-8">
10
            <div  class="bg-white  overflow-hidden  shadow-sm  sm:rounded-lg">
11
                <div  class="p-6 text-gray-900">
12
                    <div  class="mb-2">
13
                        <a  href="{{ route('tasks.create') }}" class="p-2 border mb-4">Create New Task</a>
14
                    </div>
15
                    <ul class="mt-4">
16
                        @foreach ($tasks as $task)
17
                            <div class="mt-2">
18
                                <hr>
19
                            </div>
20
                            <li>
21
                                <h1 class="text-2xl">
22
                                    <strong>{{ $task->title }}</strong> - Due: {{ $task->due_date }}
23
                                </h1>
24
                                <p class="text-gray-600">
25
                                    {{ $task->description }}
26
                                </p>
27
                                <div class="flex gap-2 mt-4">
28
                                    <div class="p-2 text-white bg-gray-700">
29
                                        <a href="{{ route('tasks.edit', $task->id) }}">Edit</a>
30
                                    </div>
31
                                    <div class="p-2 text-white bg-red-700 rounded">
32
                                        <form action="{{ route('tasks.destroy', $task->id) }}" method="POST" style="display:inline;">
33
                                            @csrf
34
                                            @method('DELETE')
35
                                            <button type="submit">Delete</button>
36
                                        </form>
37
                                    </div>
38
                                </div>
39
                            </li>
40
                        @endforeach
41
                    </ul>
42
                </div>
43
            </div>
44
        </div>
45
    </div>
46
</x-app-layout>

1
//...existing code ...
2
<div class="hidden  space-x-8 sm:-my-px  sm:ms-10 sm:flex">
3
    <x-nav-link :href="route('tasks.index')":active="request()->routeIs('tasks.index')">
4
        {{ __('Tasks') }}
5
    </x-nav-link>
6
</div>

1
php artisan make:command SendTaskReminders

1
<?php
2
3
namespace App\Console\Commands;
4
5
use App\Models\Task;
6
use Carbon\Carbon;
7
use Illuminate\Console\Command;
8
use Illuminate\Support\Facades\Mail;
9
10
class SendTaskReminders extends Command
11
{
12
    /**
13
    * The name and signature of the console command.
14
    *
15
    * @var string
16
    */
17
    protected $signature = 'app:send-task-reminders';
18
19
    /**
20
    * The console command description.
21
    *
22
    * @var string
23
    */
24
    protected $description = 'Command description';
25
26
    /**
27
    * Execute the console command.
28
    */
29
    public  function  handle()
30
    {
31
        $now = Carbon::now();
32
        $upcomingTasks = Task::where('last_notification_date', null)->get();
33
34
        $upcomingTasks = Task::where('last_notification_date', null)
35
36
        ->where('reminder_time', '>=', $now->clone()->subMinutes(10))
37
38
        ->get();
39
40
        foreach ($upcomingTasks as $task) {
41
            $emailBody = <<<EOF
42
              Hello,
43
              This is a reminder for your task:
44
              Title: {$task->title}
45
              Description: {$task->description}
46
              Due Date: {$task->due_date}
47
              Please make sure to complete it on time!
48
              Regards,
49
              Your Task Reminder App
50
              EOF;
51
52
            Mail::raw($emailBody, function ($message) use ($task) {
53
                $message->to($task->email)
54
                ->subject("Task Reminder: {$task->title}");
55
            });
56
57
            $task->last_notification_date = $now;
58
            $task->save();
59
            $this->info("Reminder email sent for task: {$task->title}");
60
        }
61
62
        return self::SUCCESS;
63
    }
64
}

1
//...existing code ...
2
Schedule::command('app:send-task-reminders')->everyMinute();

1
php artisan schedule:run

1
crontab -e

1
* * * * * /usr/bin/php /path-to-your-project/artisan schedule:run >> /dev/null  2>&1

1
crontab -l