/webapp/plugins/insightsgenerator/insights/likespike.php

<?php
/*
 Plugin Name: Video Like Spike
 Description: Like spikes and high insights for videos posted the past 7, 30, and 365 days.
 */
/**
 *
 * ThinkUp/webapp/plugins/insightsgenerator/insights/likespike.php
 *
 * LICENSE:
 *
 * This file is part of ThinkUp (http://thinkup.com).
 *
 * ThinkUp is free software: you can redistribute it and/or modify it under the terms of the GNU General Public
 * License as published by the Free Software Foundation, either version 2 of the License, or (at your option) any
 * later version.
 *
 * ThinkUp is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with ThinkUp.  If not, see
 * <http://www.gnu.org/licenses/>.
 *
 *
 * LikeSpike Insight
 *
 * Highlights videos with spikes in likes or all time like highs
 *
 * Copyright (c) 2013 Aaron Kalair
 *
 * @author Aaron Kalair aaronkalair@gmail.com
 * @license http://www.gnu.org/licenses/gpl.html
 * @copyright 2013 Aaron Kalair
 */

class LikeSpikeInsight extends InsightPluginParent implements InsightPlugin {

    public function generateInsight(Instance $instance, User $user, $last_week_of_posts, $number_days) {
        parent::generateInsight($instance, $user, $last_week_of_posts, $number_days);
        self::generateInsightBaselines($instance, $number_days);
        $this->logger->logInfo("Begin generating insight", __METHOD__.','.__LINE__);

        $insight_baseline_dao = DAOFactory::getDAO('InsightBaselineDAO');
        $filename = basename(__FILE__, ".php");
        $video_dao = DAOFactory::getDAO('VideoDAO');
        $insight_text = '';

        $simplified_post_date = "";

        foreach ($last_week_of_posts as $post) {
            if($post->network == 'youtube') {
                $video = $video_dao->getVideoByID($post->post_id, 'youtube');
            }
            else {
                break;
            }
            if ($video->likes > 2) { //Only show insight for more than 2 likes
                // First get spike/high 30/90/365 day baselines
                if ($simplified_post_date != date('Y-m-d', strtotime($post->pub_date))) {
                    $simplified_post_date = date('Y-m-d', strtotime($post->pub_date));

                    $average_like_count_30_days =
                    $insight_baseline_dao->getInsightBaseline('avg_like_count_last_30_days', $instance->id,
                    $simplified_post_date);

                    $average_like_count_90_days =
                    $insight_baseline_dao->getInsightBaseline('avg_like_count_last_90_days', $instance->id,
                    $simplified_post_date);

                    $high_like_count_30_days =
                    $insight_baseline_dao->getInsightBaseline('high_like_count_last_30_days', $instance->id,
                    $simplified_post_date);

                    $high_like_count_90_days =
                    $insight_baseline_dao->getInsightBaseline('high_like_count_last_90_days', $instance->id,
                    $simplified_post_date);

                    $high_like_count_365_days =
                    $insight_baseline_dao->getInsightBaseline('high_like_count_last_365_days', $instance->id,
                    $simplified_post_date);

                    $hot_videos_data = $video_dao->getHotVideos($instance->network_username, 'youtube', 10, 'likes',
                    'Likes');
                    $chart_data = VideoMySQLDAO::getHotVideosVisualizationData($hot_videos_data, 'Likes');
                }
                // Next compare post like counts to baselines and store insights where there's a spike or high
                if (isset($high_like_count_365_days->value)
                && $video->likes >= $high_like_count_365_days->value) {
                    if (isset($chart_data)) {
                        $headline = "<strong>".number_format($video->likes)." people</strong> liked ";
                        $headline .= "<a href=http://plus.google.com/$instance->network_user_id>";
                        $headline .= "$instance->network_username</a>'s video <a href=http://www.youtube.com/watch?v=";
                        $headline .= "$video->post_id>$video->post_text</a>.";

                        $insight_text = "That's a new 365-day record!";

                        $this->insight_dao->insertInsightDeprecated('like_high_365_day_'.$video->id, $instance->id,
                        $simplified_post_date, $headline, $insight_text, $filename, Insight::EMPHASIS_HIGH,
                        serialize(array($video, $chart_data)));

                        $this->insight_dao->deleteInsight('like_high_90_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                        $this->insight_dao->deleteInsight('like_high_90_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                        $this->insight_dao->deleteInsight('like_spike_30_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                        $this->insight_dao->deleteInsight('like_spike_30_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                    }
                } elseif (isset($high_like_count_90_days->value)
                && $video->likes >= $high_like_count_90_days->value) {
                    if (isset($chart_data)) {
                        $insight_text = "That's a new 90-day record!";
                        $headline = "<strong>".number_format($video->likes)." people</strong> liked ";
                        $headline .= "<a href=http://plus.google.com/$instance->network_user_id>";
                        $headline .= "$instance->network_username</a>'s video <a href=http://www.youtube.com/watch?v=";
                        $headline .= "$video->post_id>$video->post_text</a>.";

                        $this->insight_dao->insertInsightDeprecated('like_high_90_day_'.$video->id, $instance->id,
                        $simplified_post_date, $headline, $insight_text, $filename, Insight::EMPHASIS_HIGH,
                        serialize(array($video, $chart_data)));

                        $this->insight_dao->deleteInsight('like_high_30_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                        $this->insight_dao->deleteInsight('like_spike_30_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                    }
                } elseif (isset($high_like_count_30_days->value)
                && $video->likes >= $high_like_count_30_days->value) {
                    if (isset($chart_data)) {
                        $insight_text = "That's a new 30-day record.";
                        $headline = "<strong>".number_format($video->likes)." people</strong> liked ";
                        $headline .= "<a href=http://plus.google.com/$instance->network_user_id>";
                        $headline .= "$instance->network_username</a>'s video <a href=http://www.youtube.com/watch?v=";
                        $headline .= "$video->post_id>$video->post_text</a>.";

                        $this->insight_dao->insertInsightDeprecated('like_high_30_day_'.$video->id, $instance->id,
                        $simplified_post_date, $headline, $insight_text, $filename, Insight::EMPHASIS_HIGH,
                        serialize(array($video, $chart_data)));
                    }
                }

                if (isset($average_like_count_90_days->value)
                && $video->likes > ($average_like_count_90_days->value*2)) {
                    if (isset($chart_data)) {
                        $multiplier = floor($video->likes/$average_like_count_30_days->value);
                        $multiplier = $this->terms->getMultiplierAdverb($multiplier);
                        $headline = "<strong>".number_format($video->likes)." people</strong> liked ";
                        $headline .= "<a href=http://plus.google.com/$instance->network_user_id>";
                        $headline .= "$instance->network_username</a>'s video <a href=http://www.youtube.com/watch?v=";
                        $headline .= "$video->post_id>$video->post_text</a>, more than <strong>".$multiplier."</strong> ";
                        $headline .= "the 90-day average.";

                        $this->insight_dao->insertInsightDeprecated('like_spike_90_day_'.$post->id, $instance->id,
                        $simplified_post_date, $headline, $insight_text, $filename, Insight::EMPHASIS_LOW,
                        serialize(array($video, $chart_data)));

                        $this->insight_dao->deleteInsight('like_spike_30_day_'.$post->id, $instance->id,
                        $simplified_post_date);
                    }
                } elseif (isset($average_like_count_30_days->value)
                && $video->likes > ($average_like_count_30_days->value*2)) {
                    if (isset($chart_data)) {
                        $multiplier = floor($video->likes/$average_like_count_30_days->value);
                        $multiplier = $this->terms->getMultiplierAdverb($multiplier);
                        $headline = "<strong>".number_format($video->likes)." people</strong> liked ";
                        $headline .= "<a href=http://plus.google.com/$instance->network_user_id>";
                        $headline .= "$instance->network_username</a>'s video <a href=http://www.youtube.com/watch?v=";
                        $headline .= "$video->post_id>$video->post_text</a>, more than <strong>".$multiplier."</strong> ";
                        $headline .= "the 30-day average.";

                        $this->insight_dao->insertInsightDeprecated('like_spike_30_day_'.$post->id, $instance->id,
                        $simplified_post_date, $headline, $insight_text, $filename, Insight::EMPHASIS_LOW,
                        serialize(array($video, $chart_data)));
                    }
                }
            }
        }
        $this->logger->logInfo("Done generating insight", __METHOD__.','.__LINE__);
    }
    /**
     * Calculate and store insight baselines for a specified number of days.
     * @param Instance $instance
     * @param int $number_days Number of days to backfill
     * @return void
     */
    private function generateInsightBaselines($instance, $number_days=3) {
        $video_dao = DAOFactory::getDAO('VideoDAO');
        $insight_baseline_dao = DAOFactory::getDAO('InsightBaselineDAO');

        $days_ago = 0;
        // Generate baseline post insights for the last 7 days
        while ($days_ago < $number_days) {
            $since_date = date("Y-m-d", strtotime("-".$days_ago." day"));

            if ($video_dao->doesUserHaveVideosWithLikesSinceDate($instance->network_username, $instance->network, 30,
            $since_date)) {
                //Save average likes over past 30 days
                $average_like_count_30_days = null;
                $average_like_count_30_days = $video_dao->getAverageLikeCount($instance->network_username,
                $instance->network, 30, $since_date);
                if ($average_like_count_30_days != null ) {
                    $insight_baseline_dao->insertInsightBaseline('avg_like_count_last_30_days', $instance->id,
                    $average_like_count_30_days, $since_date);
                    $this->logger->logSuccess("Averaged $average_like_count_30_days likes in the 30 days before ".
                    $since_date, __METHOD__.','.__LINE__);
                }

                //Save like high for last 30 days
                $high_like_count_30_days = $video_dao->getHighestLikes($instance->network_username, $instance->network,
                30, $since_date);
                if ($high_like_count_30_days != null ) {
                    $insight_baseline_dao->insertInsightBaseline('high_like_count_last_30_days', $instance->id,
                    $high_like_count_30_days, $since_date);
                    $this->logger->logSuccess("High of $high_like_count_30_days likes in the 30 days before ".
                    $since_date, __METHOD__.','.__LINE__);
                }
            }

            if ($video_dao->doesUserHaveVideosWithLikesSinceDate($instance->network_username, $instance->network, 90,
            $since_date)) {
                //Save average likes over past 90 days
                $average_like_count_90_days = null;
                $average_like_count_90_days = $video_dao->getAverageLikeCount($instance->network_username,
                $instance->network, 90, $since_date);
                if ($average_like_count_90_days != null ) {
                    $insight_baseline_dao->insertInsightBaseline('avg_like_count_last_90_days', $instance->id,
                    $average_like_count_90_days, $since_date);
                    $this->logger->logSuccess("Averaged $average_like_count_90_days likes in the 90 days before ".
                    $since_date, __METHOD__.','.__LINE__);
                }

                //Save like high for last 90 days
                $high_like_count_90_days = $video_dao->getHighestLikes($instance->network_username, $instance->network,
                90, $since_date);
                if ($high_like_count_90_days != null ) {
                    $insight_baseline_dao->insertInsightBaseline('high_like_count_last_90_days', $instance->id,
                    $high_like_count_90_days, $since_date);
                    $this->logger->logSuccess("High of $high_like_count_90_days likes in the 90 days before ".
                    $since_date, __METHOD__.','.__LINE__);
                }
            }

            if ($video_dao->doesUserHaveVideosWithLikesSinceDate($instance->network_username, $instance->network, 365,
            $since_date)) {
                //Save like high for last 365 days
                $high_like_count_365_days = $video_dao->getHighestLikes($instance->network_username, $instance->network,
                365, $since_date);
                if ($high_like_count_365_days != null ) {
                    $insight_baseline_dao->insertInsightBaseline('high_like_count_last_365_days', $instance->id,
                    $high_like_count_365_days, $since_date);
                    $this->logger->logSuccess("High of $high_like_count_365_days likes in the 365 days before ".
                    $since_date, __METHOD__.','.__LINE__);
                }
            }
            $days_ago++;
        }
    }
}

$insights_plugin_registrar = PluginRegistrarInsights::getInstance();
$insights_plugin_registrar->registerInsightPlugin('LikeSpikeInsight');