Esempio n. 1
0
<?php

error_reporting(0);
require_once dirname(__FILE__) . '/../inc/init.php';
require_once dirname(__FILE__) . '/../inc/twitter/twitteroauth.php';
// only tweet when we reach these milestones
$mileStones = array(10, 12, 15, 18, 20, 22, 24, 25);
$current = getCurrentData();
if (shouldTweet($current)) {
    tweetPercentage($current);
}
function getCurrentData()
{
    // get latest data
    // inner select grabs highest % tweeted today
    // only check today's readings
    $hour = date('H');
    if ($hour < 12) {
        $start = time();
        $end = time();
        $dateSMYSQL = es(date("Y-m-d 00:00", $start));
        // today 00
        $dateEMYSQL = es(date("Y-m-d 12:00", $end));
        // today 12
    } else {
        $start = time();
        $end = time() + 3600 * 24;
        $dateSMYSQL = es(date("Y-m-d 12:00", $start));
        // today 12
        $dateEMYSQL = es(date("Y-m-d 00:00", $end));
        // tomorrow 00
Esempio n. 2
0
<?php

require_once dirname(__FILE__) . '/../inc/init.php';
require_once dirname(__FILE__) . '/../inc/twitter/twitteroauth.php';
$maxPercentage = getMaxPercentageForTheNight();
if (shouldTweet($maxPercentage)) {
    tweetPercentage($maxPercentage);
}
function getMaxPercentageForTheNight()
{
    $today = time();
    $dateSMYSQL = es(date("Y-m-d 00:00", $today));
    // midnight
    $dateEMYSQL = es(date("Y-m-d 09:00", $today));
    // 9am
    $query = "SELECT\n                timestamp,\n                FLOOR(100*wind/demand) AS percent\n              FROM\n                wind_vs_demand\n              WHERE\n                timestamp BETWEEN '{$dateSMYSQL}' AND '{$dateEMYSQL}'\n              ORDER BY\n                percent DESC\n              LIMIT 1";
    return fetchAssoc(query($query));
}
function shouldTweet($data)
{
    // if the max production went over 10%
    return $data['percent'] > 10;
}
function tweetPercentage($current)
{
    global $socialUrl;
    // tweet the max percentage for last night
    $percent = $current['percent'];
    $time = $current['timestamp'];
    $message = "While you were sleeping, #windenergy reached {$percent}% of the National Grid's electricity demand. {$socialUrl}";
    $connection = new TwitterOAuth(API_KEY, API_SECRET, ACCESS_TOKEN, ACCESS_TOKEN_SECRET);