PHP Post::withTrashed方法代码示例

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::table('posts', function (Blueprint $table) {
         $table->timestamp('bumplocked_at')->nullable()->default(null)->after('stickied_at');
         $table->timestamp('locked_at')->nullable()->default(null)->after('bumplocked_at');
         $table->timestamp('bumped_last')->nullable()->default(null)->after('reply_last');
     });
     Post::withTrashed()->whereNull('bumped_last')->update(["bumped_last" => DB::raw("reply_last")]);
 }

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::table('posts', function (Blueprint $table) {
         $table->string('author_ip', 46)->nullable()->change();
         $table->string('author_id', 6)->nullable()->after('author_ip');
         $table->timestamp('author_ip_nulled_at')->nullable()->after('author_id');
     });
     Post::withTrashed()->chunk(100, function ($posts) {
         foreach ($posts as $post) {
             $post->author_id = $post->makeAuthorId();
             $post->save();
         }
     });
 }

 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::table('bans', function (Blueprint $table) {
         $table->string('ban_ip', 46)->after('ban_ip_end');
     });
     Schema::table('posts', function (Blueprint $table) {
         $table->string('author_ip_string', 46)->after('author_ip');
     });
     Schema::table('reports', function (Blueprint $table) {
         $table->string('ip', 46)->after('reporter_ip');
     });
     Ban::chunk(100, function ($bans) {
         foreach ($bans as $ban) {
             $ban->ban_ip_start = inet_ntop($ban->ban_ip);
             $ban->ban_ip_end = inet_ntop($ban->ban_ip);
             $ban->save();
         }
     });
     Post::withTrashed()->chunk(100, function ($posts) {
         foreach ($posts as $post) {
             $post->author_ip_string = null;
             if (!is_null($post->author_ip)) {
                 $post->author_ip_string = inet_ntop($post->author_ip);
             }
             $post->save();
         }
     });
     Report::chunk(100, function ($reports) {
         foreach ($reports as $report) {
             $report->ip = inet_ntop($report->reporter_ip);
             $report->save();
         }
     });
     Schema::table('bans', function (Blueprint $table) {
         $table->dropColumn('ban_ip_start', 'ban_ip_end');
     });
     Schema::table('posts', function (Blueprint $table) {
         $table->dropColumn('author_ip');
     });
     Schema::table('posts', function (Blueprint $table) {
         $table->renameColumn('author_ip_string', 'author_ip');
     });
     Schema::table('reports', function (Blueprint $table) {
         $table->dropColumn('reporter_ip');
     });
 }

 /**
  * Manage post personal information (IPs)
  *
  * @return void
  */
 protected function handlePostInformation()
 {
     $this->comment("    Pruning posts data...");
     $postIpLife = (int) Settings::get('ephePostIpLife', 0);
     $postTrashedLife = (int) Settings::get('ephePostHardDelete', 0);
     if ($postIpLife) {
         $carbonLife = Carbon::now()->subDays($postIpLife);
         $affected = Post::withTrashed()->where('created_at', '<=', $carbonLife)->whereNotNull('author_ip')->update(['author_ip' => null]);
         $this->comment("      Pruned {$affected} author IP(s).");
     }
     if ($postTrashedLife) {
         $carbonLife = Carbon::now()->subDays($postTrashedLife);
         // Destroy old, trashed posts.
         $affected = Post::onlyTrashed()->where('deleted_at', '<=', $carbonLife)->forceDelete();
         $this->comment("      Pruned {$affected} trashed post(s).");
     }
 }

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::table('posts', function (Blueprint $table) {
         $table->bigInteger('reply_to_board_id')->unsigned()->nullable()->after('reply_to');
     });
     // Add reply_to_board_id for all posts.
     $replies = Post::withTrashed()->whereNotNull('posts.reply_to')->leftJoin('posts as op', function ($join) {
         $join->on('op.post_id', '=', 'posts.reply_to');
     })->addSelect('posts.*', 'op.board_id as op_board_id')->get();
     foreach ($replies as $reply) {
         $reply->reply_to_board_id = $reply->op_board_id;
         try {
             $reply->save();
         } catch (Exception $e) {
             dd($e);
         }
     }
 }

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('post_cites', function (Blueprint $table) {
         $table->bigIncrements('post_cite_id');
         $table->bigInteger('post_id')->unsigned();
         $table->string('post_board_uri', 32);
         $table->bigInteger('post_board_id')->unsigned();
         $table->bigInteger('cite_id')->unsigned()->nullable();
         $table->string('cite_board_uri', 32);
         $table->bigInteger('cite_board_id')->unsigned()->nullable();
         $table->foreign('post_id')->references('post_id')->on('posts')->onDelete('cascade')->onUpdate('cascade');
         $table->foreign('post_board_uri')->references('board_uri')->on('boards')->onDelete('cascade')->onUpdate('cascade');
         $table->foreign('cite_id')->references('post_id')->on('posts')->onDelete('cascade')->onUpdate('cascade');
         $table->foreign('cite_board_uri')->references('board_uri')->on('boards')->onDelete('cascade')->onUpdate('cascade');
     });
     // Process citations.
     $posts = Post::withTrashed()->chunk(100, function ($posts) {
         echo " - Adding citations for 100 posts.\n";
         foreach ($posts as $post) {
             $cited = $post->getCitesFromText();
             $cites = [];
             foreach ($cited['posts'] as $citedPost) {
                 if (is_null($citedPost->deleted_at)) {
                     $cites[] = new PostCite(['post_board_uri' => $post->board_uri, 'post_board_id' => $post->board_id, 'cite_id' => $citedPost->post_id, 'cite_board_uri' => $citedPost->board_uri, 'cite_board_id' => $citedPost->board_id]);
                 }
             }
             foreach ($cited['boards'] as $citedBoard) {
                 $cites[] = new PostCite(['post_board_uri' => $post->board_uri, 'cite_board_uri' => $citedBoard->board_uri]);
             }
             if (count($cites) > 0) {
                 try {
                     $post->cites()->saveMany($cites);
                 } catch (Exception $e) {
                     dd($post);
                 }
             }
         }
     });
 }

 /**
  * @return \Illuminate\Contracts\Pagination\Paginator
  */
 protected function __getPosts()
 {
     $posts = Post::withTrashed()->orderBy('date', 'DESC')->simplePaginate(8);
     $posts->setPath(route('load_next_posts'));
     return $posts;
 }

 /**
  * Manage post personal information (IPs)
  *
  * @return void
  */
 protected function handlePostInformation()
 {
     $this->comment("    Pruning posts data...");
     $postIpLife = (int) Settings::get('ephePostIpLife', 0);
     $postTrashedLife = (int) Settings::get('ephePostHardDelete', 0);
     if ($postIpLife) {
         $carbonLife = Carbon::now()->subDays($postIpLife);
         $affected = Post::withTrashed()->where('created_at', '<=', $carbonLife)->whereNotNull('author_ip')->update(['author_ip' => null]);
         $this->comment("      Pruned {$affected} author IP(s).");
     }
     if ($postTrashedLife) {
         $carbonLife = Carbon::now()->subDays($postTrashedLife);
         // Find old posts.
         $forTrash = Post::onlyTrashed()->select('post_id', 'deleted_at')->where('deleted_at', '<=', $carbonLife);
         // Remove relationships.
         $forTrash->chunk(100, function ($posts) {
             foreach ($posts as $post) {
                 $post->attachmentLinks()->delete();
             }
         });
         // Destroy old, trashed posts.
         $affected = $forTrash->forceDelete();
         $this->comment("      Pruned {$affected} trashed post(s).");
     }
 }

 public function restore($id)
 {
     $post = Post::withTrashed()->where('id', '=', $id)->restore();
     return ['message' => 'Articolo nuovamente visibile'];
 }

 public function testSoftDelete()
 {
     // test trashed()
     $post = Post::find(1);
     $post->delete();
     $this->assertTrue($post->trashed());
     // test withTrashed()
     Post::find(2)->delete();
     $post = Post::find(2);
     $this->assertNull($post);
     $post = Post::withTrashed()->find(2);
     $this->assertNotNull($post);
     // test onlyTrashed()
     $post = Post::find(3);
     $this->assertNotNull($post);
     $post = Post::onlyTrashed()->find(3);
     $this->assertNull($post);
     // test restore
     $post = Post::find(3);
     $post->delete();
     $post->restore();
     $post1 = Post::find(3);
     $this->assertNull($post1);
     $post = Post::onlyTrashed()->find(3);
     $post->restore();
     $post1 = Post::find(3);
     $this->assertNotNull($post1);
 }

 /**
  * Restored post from trash
  */
 public function getRestore($id)
 {
     $post = Post::withTrashed()->find($id);
     $post->restore();
     return redirect('post/deleted-post')->with('restore', true);
 }