} \relive\misc\FacebookPagePoster::post($event->event_id); \relive\models\CrawlJob::create(['event_id' => $event->event_id]); $event->save(); } if (isset($_GET['deleteevent'])) { $event_id = $_GET['event_id']; \relive\models\Event::find($event_id)->delete(); \relive\models\Post::whereNotIn('post_id', function ($query) { $query->select('post_id')->from('posteventrelationships'); })->delete(); } if (isset($_GET['post_id'])) { if (isset($_GET['filter'])) { $post = \relive\models\PostEventRelationship::whereIn('post_id', function ($query) { $query->select('post_id')->from('reports')->where('post_id', '=', $_GET['post_id']); })->first(); $post->isFiltered = 1; $post->save(); $report = \relive\models\Report::where('post_id', '=', $_GET['post_id'])->get(); foreach ($report as $rep) { $rep->isSettled = 1; $rep->save(); } } else { if (isset($_GET['settle'])) { $report = \relive\models\Report::where('post_id', '=', $_GET['post_id'])->get(); foreach ($report as $rep) { $rep->isSettled = 1; $rep->save(); }
<?php require_once '/var/www/vendor/autoload.php'; use relive\models\Event; use relive\models\Post; use relive\models\PostEventRelationship; foreach (Event::all() as $event) { $event_id = $event->event_id; $count = PostEventRelationship::where('event_id', '=', $event_id)->count(); if ($count > 500) { $post = Post::whereIn('post_id', function ($query) use($event_id) { $query->select('post_id')->from('posteventrelationships')->where('event_id', '=', $event_id); })->orderBy('rankPoints', 'asc')->offset($count * 0.35)->limit(1)->first(); $rankPoints = $post->rankPoints; PostEventRelationship::whereIn('post_id', function ($query) use($rankPoints) { $query->select('post_id')->from('posts')->where('rankPoints', '<', $rankPoints); })->where('event_id', '=', $event_id)->update(['isFiltered' => 1]); PostEventRelationship::whereIn('post_id', function ($query) use($rankPoints) { $query->select('post_id')->from('posts')->where('rankPoints', '>=', $rankPoints); })->where('event_id', '=', $event_id)->update(['isFiltered' => 0]); } }