如何在Laravel 4中软删除模型

Question

I have a table of Advertisements, I need to delete a record temporarily that can be enabled again and I can also fetch the deleted results.

Answer 1

You just need to add soft delete trait in your Advertisement.php (Advertisement model)

For soft delete:

use Illuminate\Database\Eloquent\SoftDeletingTrait;

class Advertisement extends Eloquent {

    use SoftDeletingTrait; 

    .....
}

Next, you need to add a column in table deleted_at (timestamp, default null), now when you normally delete your Advertisement

$advertisement = Advertisement::find($id);
$advertisement->delete();

It will add current timestamp in deleted_at column, and that particular row will not be fetched until deleted_at column has value.

For get all soft deleted values:

$deletedAdvertisement = Advertisement::onlyTrashed()->get();

you can use documentation for more info:

http://laravel.com/docs/4.2/eloquent#insert-update-delete