git.roojs.org Git - web.Reddit/blob - Reddit.php

   1 <?php
   2
   3
   4 require_once 'Pman.php';
   5
   6 class  Reddit  extends Pman
   7 {
   8     var $template= 'Reddit.Index.html';
   9
  10
  11     function getAuth()
  12     {
  13         return true;
  14     }
  15
  16     function get($day='')
  17     {
  18         //DB_DataObject::debugLevel(1);
  19
  20         $day = empty($day) ? '2014-10-01' : date('Y-m-d', strtotime($day));
  21         $f = DB_DataObject::factory('reddit_livefeed');
  22         $f->selectAdd('created_dt - INTERVAL 8 HOUR as created_local_dt');
  23
  24         $f->whereAdd("
  25                 created_dt - INTERVAL 8 HOUR > '{$day} 00:00:00'
  26                 AND
  27                 created_dt - INTERVAL 8 HOUR < '{$day} 00:00:00' + INTERVAL 1 DAY
  28         ");
  29
  30         $f->orderBy('created_dt ASC');
  31         $f->find();
  32         $this->feed=array();
  33         while ($f->fetch()) {
  34             $c = clone($f);
  35             $c->embeds_ar = $c->embedsArray();
  36             $this->feed[] = $c;
  37         }
  38
  39
  40     }
  41
  42
  43 }