// Get area
$stat = $DB->prepare("SELECT area_information.* FROM area_information " . " JOIN area_mapit_information ON area_mapit_information.area_id = area_information.id " . " JOIN (" . $innerSQL . ") AS area_tweets ON area_tweets.area_id = area_information.id " . " WHERE area_tweets.tweets = 0 AND area_information.is_deleted = '0' AND area_information.cached_future_events > " . EVENTS_NEEDED_IN_AREA . " ORDER BY area_information.cached_future_events DESC LIMIT 1 ");
$stat->execute();
if ($stat->rowCount() == 0) {
die("No AREA Data");
}
$area = new \models\AreaModel();
$area->setFromDataBaseRow($stat->fetch());
$areaURL = "http://" . $CONFIG->webSiteDomain . "/area/" . $area->getSlugForUrl();
print "Found Area " . $area->getTitle() . "\n";
$erb = new \com\meetyournextmp\repositories\builders\EventRepositoryBuilder();
$erb->setAfterNow();
$erb->setArea($area);
$erb->setIncludeCancelled(false);
$erb->setIncludeDeleted(false);
$events = $erb->fetchCount();
if ($events < EVENTS_NEEDED_IN_AREA) {
die("We checked and found less than " . EVENTS_NEEDED_IN_AREA . " events; is cache broken!");
}
$hrb = new \com\meetyournextmp\repositories\builders\HumanRepositoryBuilder();
$hrb->setIncludeDeleted(false);
$hrb->setArea($area);
$humans = $hrb->fetchAll();
$humanTweets = array();
$humanTweetRepo = new \com\meetyournextmp\repositories\HumanTweetRepository();
foreach ($humans as $human) {
if ($human->getTwitter()) {
$humanTweet = new \com\meetyournextmp\models\HumanTweetModel();
$humanTweet->setHumanId($human->getId());
$txt = $tweetTexts[rand(0, count($tweetTexts) - 1)];
$txt = str_replace("[AREA]", $area->getTitle(), $txt);
