dongtangjie0495 2018-04-28 05:11
浏览 12
已采纳

laravel auto hard delete

I have methods where i can soft delete my model, restore them and hard delete (wipe from database) theme,

So far everything is ok, what I want in additional to that is to hard delete after 30 days passed from soft delete info, so in that way even if admin forget to hard delete models it will delete automatically after 30 days.

Here is my codes:

soft delete

public function destroy($id)
    {
        $user = User::findOrFail($id);
        $user->delete();
        Mail::to($user->email)->send(new adminsoftdeleteduser($user));
        return redirect()->route('users.index')->with('success', 'User successfully deleted.');
    }

restore

public function restore($id)
    {
        $user = User::onlyTrashed()->where('id', $id)->restore();
        // Mail::to($user->email)->send(new adminrestoreduser($user));
        return redirect()->route('users.index')->with('success', 'User successfully restored.');
    }

hard delete

public function forcedelete($id)
    {
        $user = User::where('id', $id)->forcedelete();
        Storage::delete($user->image);
        return redirect()->route('users.index')->with('success', 'User Permanently deleted.');
    }

Question

  1. what should i add to my hard delete function in order to delete my model after 30 days of deleted_at column data?

Update

I've tried schedule way and as i cannot use cron job to test it so i used php artisan schedule:run and here is the result I've got:

screen1

  • 写回答

1条回答 默认 最新

  • dongshun1884 2018-04-28 05:32
    关注

    Use the Task Scheduler to automatically run a command:

    protected function schedule(Schedule $schedule)
    {
        $schedule->call(function () {
            $users = User::whereNotNull('deleted_at')->where(
                'deleted_at', '<=', now()->subDays(30)->toDateTimeString()
            )->get();
    
            $users->each->forceDelete();
        })->daily();
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效
  • ¥15 悬赏!微信开发者工具报错,求帮改
  • ¥20 wireshark抓不到vlan
  • ¥20 关于#stm32#的问题:需要指导自动酸碱滴定仪的原理图程序代码及仿真
  • ¥20 设计一款异域新娘的视频相亲软件需要哪些技术支持
  • ¥15 stata安慰剂检验作图但是真实值不出现在图上
  • ¥15 c程序不知道为什么得不到结果
  • ¥40 复杂的限制性的商函数处理
  • ¥15 程序不包含适用于入口点的静态Main方法