<?php /* $Id$ */
	(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

	require_once(__DIR__.__DS__.'cls.mmmodnewsrepossvcbase.php');
	
	class MMModNewsReposSvc extends MMModNewsReposSvcBase {
	
		private static $ENTRYTABLE = 'm_mcms#news_entrys';
		private static $COMMENTTABLE = 'm_mcms#news_entrycomments';
		
		public static function getIndex($siteId,$instance) {
			$db = MMSystem::getInstance()->getDB();
			
			// TODO: Implement
		}
		
		/**
		 * @return array of MMModNewsEntry
		 */
		public static function getPageEntries($site, $instance, $page, $pagesize) {
			$db = MMSystem::getInstance()->getDB();
			$usrv = MMSystem::getInstance()->getUserSvc();
			$start = $page*$pagesize;
			$sql = 'SELECT * FROM '.$db->escapeTableName(self::$ENTRYTABLE);
			$sql .= ' WHERE site_id='.$site.' AND instance='.$db->escapeValue($instance);
			$sql .= ' ORDER BY created_at DESC';
			$list = $db->getObjectList($sql,'MMModNewsEntry',NULL,$pagesize,$start);
			foreach ($list as $idx => &$entry) {
				$entry->created_by = NULL;
				if ($entry->created_by_id > 0) {
					$usr = $usrv->getUser((int)$entry->created_by_id);
					$entry->created_by = $usr;
				}
			}
			return $list;
		}
		
		public static function getPageCount($site, $instance, $pagesize) {
			$db = MMSystem::getInstance()->getDB();
			$where = 'WHERE site_id='.$site.' AND instance='.$db->escapeValue($instance);
			$count = $db->getObject("SELECT COUNT(id) AS c FROM ".$db->escapeTableName(self::$ENTRYTABLE).' '.$where)->c;
			$pages = ceil($count/$pagesize);
			return $pages;
		}
		
		public static function getHistory($siteId,$instance,$page,$pagesize,$reverse) {
			$db = MMSystem::getInstance()->getDB();
			
			// TODO: Implement
		}
		 
		public static function getComments(MMModNewsEntry $newsEntry,$page,$pagesize,$reverse) {
			$db = MMSystem::getInstance()->getDB();
			
			// TODO: Implement
		} 
	}