Eduardo P. Sales EduardoSP6

Implementing pagination in PHP with library Spatie Query Builder + React Tanstack Table

Tested with:

PHP 8.3
Laravel 11 with Spatie Laravel Query Builder
Next.js 15 with TanStack Table

Back-end implementation:

How to Prevent Page Refresh When Swiping Down on Mobile

In many mobile browsers, a "pull down" gesture at the top of the page can trigger the "pull-to-refresh" functionality. While useful in some scenarios, this behavior can be undesirable in web applications that utilize touch elements or where the page should not be reloaded.

We can use touch events (touchstart and touchmove) to detect when the user tries to "pull down" from the top of the page. In this case, we can prevent the default refresh action, ensuring that normal scrolling continues to work.

To do this, I created the component below:

Implementação de rotina de verificação da conta de e-mail

Criar migração do model User adicionando o campo:

$table->timestamp('email_verified_at')->nullable();

Implementar a interface MustVerifyEmail no model User;

Custom password validation laravel 7:

For create a custom password rule for laravel you should run a command: php artisan make:rule PasswordRule. The class will be created in App\Rules folder.

Example:

<?php

Password reset in Laravel v7.x:

Add the traits below in model User:

Illuminate\Notifications\Notifiable;
Illuminate\Contracts\Auth\CanResetPassword;

	<?php

	namespace Infrastructure\Utils\OCR;

	use Exception;
	use Imagick;
	use ImagickException;
	use RuntimeException;
	use thiagoalessio\TesseractOCR\TesseractOCR;

	<?php

	function csvToArray($filename = '', $delimiter = '\t')
	{
	if (!file_exists($filename) \|\| !is_readable($filename))
	return [];

	$row = 0;
	$fileContent = [];
	if (($handle = fopen($filename, "r")) !== FALSE) {

	import org.json.JSONException;
	import org.json.JSONObject;

	import java.lang.reflect.Field;
	import java.lang.reflect.InvocationTargetException;
	import java.lang.reflect.Method;
	import java.util.ArrayList;

	import io.realm.RealmObject;

	### Snippet para o VS Code

	- Dentro do VS Code tecle `Ctrl + Shift + P`, digite `snippet` e escolha a opção `Preferences: Configure User Snippets`;

	- Clicar em New Global Snippets file...

	- Digite um nome para o arquivo;

	- Apagar o conteudo do arquivo e inserir o json abaixo:

	<?php

	public function __toArray(): array
	{
	return call_user_func('get_object_vars', $this);
	}