123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234 |
- <?php
- defined('GNUSOCIAL') || die();
- class Sitemap_notice_count extends Managed_DataObject
- {
- public $__table = 'sitemap_notice_count';
- public $notice_date;
- public $notice_count;
- public $created;
- public $modified;
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'notice_date' => array('type' => 'date', 'not null' => true, 'description' => 'record date'),
- 'notice_count' => array('type' => 'int', 'not null' => true, 'description' => 'the notice count'),
- 'created' => array('type' => 'datetime', 'description' => 'date this record was created'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('notice_date'),
- );
- }
- public static function getAll()
- {
- $noticeCounts = self::cacheGet('sitemap:notice:counts');
- if ($noticeCounts === false) {
- $snc = new Sitemap_notice_count();
- $snc->orderBy('notice_date DESC');
-
- $n = $snc->find(true);
- $today = self::today();
- $noticeCounts = array();
- if (!$n) {
- $noticeCounts = self::initializeCounts();
- } elseif ($snc->notice_date < $today) {
- $noticeCounts = self::fillInCounts($snc->notice_date);
- } elseif ($snc->notice_date === $today) {
- $noticeCounts[$today] = self::updateToday();
- }
-
- while ($snc->fetch()) {
- $noticeCounts[$snc->notice_date] = $snc->notice_count;
- }
-
- self::cacheSet('sitemap:notice:counts', $noticeCounts, null, time() + 4 * 60 * 60);
- }
- return $noticeCounts;
- }
- public static function initializeCounts()
- {
- $firstDate = self::getFirstDate();
- $today = self::today();
- $counts = array();
- for ($d = $firstDate; $d <= $today; $d = self::incrementDay($d)) {
- $n = self::getCount($d);
- self::insertCount($d, $n);
- $counts[$d] = $n;
- }
- return $counts;
- }
- public static function fillInCounts($lastDate)
- {
- $today = self::today();
- $counts = array();
- $n = self::getCount($lastDate);
- self::updateCount($lastDate, $n);
- $counts[$lastDate] = $n;
- for ($d = self::incrementDay($lastDate); $d <= $today; $d = self::incrementDay($d)) {
- $n = self::getCount($d);
- self::insertCount($d, $n);
- }
- return $counts;
- }
- public static function updateToday()
- {
- $today = self::today();
- $n = self::getCount($today);
- self::updateCount($today, $n);
- return $n;
- }
- public static function getCount($d)
- {
- $notice = new Notice();
- $notice->whereAdd(
- "created BETWEEN TIMESTAMP '" . $d . " 00:00:00' AND " .
- "TIMESTAMP '" . self::incrementDay($d) . " 00:00:00'"
- );
- $notice->whereAdd('is_local = ' . Notice::LOCAL_PUBLIC);
- $n = $notice->count();
- return $n;
- }
- public static function insertCount($d, $n)
- {
- $snc = new Sitemap_notice_count();
- $snc->notice_date = DB_DataObject_Cast::date($d);
- $snc->notice_count = $n;
- $snc->created = common_sql_now();
- $snc->modified = $snc->created;
- if (!$snc->insert()) {
- common_log(LOG_WARNING, "Could not save user counts for '$d'");
- }
- }
- public static function updateCount($d, $n)
- {
- $snc = Sitemap_notice_count::getKV('notice_date', DB_DataObject_Cast::date($d));
- if (empty($snc)) {
-
- throw new Exception(_m("No such registration date: $d."));
- }
- $orig = clone($snc);
- $snc->notice_date = DB_DataObject_Cast::date($d);
- $snc->notice_count = $n;
- $snc->created = common_sql_now();
- $snc->modified = $snc->created;
- if (!$snc->update($orig)) {
- common_log(LOG_WARNING, "Could not save user counts for '$d'");
- }
- }
- public static function incrementDay($d)
- {
- $dt = self::dateStrToInt($d);
- return self::dateIntToStr($dt + 24 * 60 * 60);
- }
- public static function dateStrToInt($d)
- {
- return strtotime($d.' 00:00:00');
- }
- public static function dateIntToStr($dt)
- {
- return date('Y-m-d', $dt);
- }
- public static function getFirstDate()
- {
- $n = new Notice();
- $n->selectAdd();
- $n->selectAdd('date(min(created)) as first_date');
- if ($n->find(true)) {
- return $n->first_date;
- } else {
-
- return self::dateIntToStr(time());
- }
- }
- public static function today()
- {
- return self::dateIntToStr(time());
- }
- }
|