Laravel > Soft Delete 구현하기 (실제로는 DB에 남아있음)

삭제를 해도 Database 에서는 실제로 삭제되지 않음.

1. Update the Model

In your StockCtg model, add the SoftDeletes trait:

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class StockCtg extends Model
{
    use SoftDeletes;

    protected $dates = ['deleted_at'];
}

2. Update the Migration

Update your migration file to include a soft deletes column:

Schema::table('stock_ctgs', function (Blueprint $table) {
    $table->softDeletes();
});

Run the migration:

php artisan migrate

3. Modify the Controller for Deletion

In your controller, use the delete method for soft deletion:

public function destroy($id)
{
    $category = StockCtg::findOrFail($id);
    $category->delete();
    return redirect()->route('admin.stock_ctgs.index');
}

4. Querying Soft Deleted Records

To include soft deleted records in queries, use:

$stock_ctgs = StockCtg::withTrashed()->get();

To only get soft deleted records:

$deletedStockCtg = StockCtg::onlyTrashed()->get();

To restore a soft deleted record:

$category = StockCtg::withTrashed()->find($id);
$category->restore();

5. Adjust Views (Optional)

You can adjust your views to handle the display of soft deleted records or provide options to restore them.

To create a migration file for adding soft deletes to the stock_ctgs table, use the following steps:

 

추가 : 마이그레이션 파일 만들기

1. Create the Migration

Run the following Artisan command to create a new migration:

php artisan make:migration add_soft_deletes_to_stock_ctgs_table

2. Update the Migration File

In the newly created migration file, add the softDeletes column:

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::table('stock_ctgs', function (Blueprint $table) {
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::table('stock_ctgs', function (Blueprint $table) {
            $table->dropSoftDeletes();
        });
    }
};

3. Run the Migration

Execute the migration to apply the changes:

php artisan migrate

This will add a deleted_at column to the stock_ctgs table, enabling soft deletes.