<?php

 
require_once 'Pman.php';

class  Reddit  extends Pman
{
    var $template= 'Reddit.Index.html';
    
    
    function getAuth()
    {
        return true;
    }
    
    function get($day='')
    {
        //DB_DataObject::debugLevel(1);
        
        $day = empty($day) ? '2014-10-01' : date('Y-m-d', strtotime($day));
        $f = DB_DataObject::factory('reddit_livefeed');
        $f->selectAdd('created_dt - INTERVAL 8 HOUR as created_local_dt');
        
        $f->whereAdd("
                created_dt - INTERVAL 8 HOUR > '{$day} 00:00:00'
                AND
                created_dt - INTERVAL 8 HOUR < '{$day} 00:00:00' + INTERVAL 1 DAY                
        ");
        
        $f->orderBy('created_dt ASC');
        $this->feed = $f->fetchAll();
        
        
    }
  
  
}