public function getSpamCommentPage()
{
$record = FbPage::whereRaw('status = ? AND crawl_fb = ?', array(true, false))->first();
if (!$record) {
FbPage::where('crawl_fb', '=', true)->update(['crawl_fb' => false]);
$record = FbPage::whereRaw('status = ? AND crawl_fb = ?', array(true, false))->first();
}
if (!empty($record->fb_id)) {
// Get post of current page
//$records = FbFeed::whereRaw('status = ? AND page_id = ? AND per_day = CURDATE() AND comment_count > ? AND type = ? AND spam IS NULL', [true, $record->id, LIMIT_COMMENT_COUNT, 'link', null])
$feeds = FbFeed::whereRaw('status = ? AND page_id = ? AND DATE(created_at) = CURDATE() AND comment_count > ? AND type = ? AND spam IS NULL', [true, $record->id, LIMIT_COMMENT_COUNT, 'link'])->select(DB::raw('id, fb_id, fb_link, name, message, picture, page_id, category_id, like_count, comment_count, share_count, type, source, object_id, created_at, DATE(created_at) AS per_day'))->orderBy('per_day', 'DESC')->orderBy('comment_count', 'DESC')->take(10)->get();
if (count($feeds) >= 4) {
// Get hot news
//$feeds = FbFeed::getHotFeeds($record->id, 2);
/*if (count($feeds)) {
foreach ( $records as $record ) {
if ($record->fb_id != ) {
HelperNews::postCommentToFB($record->fb_id, $record->link, $record->name);
}
}
}*/
$last = count($feeds) - 1;
if ($last >= 1) {
foreach ($feeds as $i => $feed) {
if ($last - $i != $i) {
$feed->spam = HelperNews::postCommentToFB($feed->fb_id, $feeds[$last - $i]->fb_link, $feeds[$last - $i]->name);
$feed->save();
$record->crawl_fb = true;
$record->save();
}
}
}
}
}
return Response::json(array('status' => 'success', 'data' => $feeds), 200);
}
public static function get_fb_user_infor($fb_uid, $access_token)
{
$url = self::$api_url . $fb_uid . '?access_token=' . $access_token;
$obj = json_decode(HelperNews::curl($url));
return $obj;
}
