<?php
/* $Id$ */
namespace MCMS\_\Modx\mcms\BBoard\_\Service;

(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use \MCMS\System;

require_once (__DIR__ . __DS__ . 'cls.datasvcbase.php');
class DataSvc extends DataSvcBase {
	protected static $catTable = 'm_mcms#bboard_categorys';
	protected static $boardTable = 'm_mcms#bboard_boards';

	public static function getAllCategories($siteId, $instance) {
		$db = System::getInstance()->getDB();
		
		/**
		 * @var MFDBResult $result
		 */
		$result = $db->table(self::$catTable)->select();
		$data = $result->fetchObjectList('\\MCMS\_\Modx\\MCMS\\BBoard\\_\\Model\\Category');
		return $data;
	}

	public static function getBoardsForCategory($siteId, $instance, $categoryId) {
		$db = System::getInstance()->getDB();
		
		$con = array('category_id' => (int) $categoryId);
		
		/**
		 * @var MFDBResult $result
		 */
		$result = $db->table(self::$boardTable)->select($con);
		$data = $result->fetchObjectList('MMModBBoardBoard');
		return $data;
	}

	public static function getPostList($topic, $maxppp, $from) {
		$db = System::getInstance()->getDB();
		
		$result = $db->query("SELECT * FROM `m_mcms#bboard_posts` WHERE `topic_id`='{$topic}' ORDER BY `created_at`");
		$list = $result->fetchObjectList('MMModBBoardPost');
		$result->close();
		return $list;
	}
}