}
\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]);
}
}
