<?php

/*
OneLobby
Copyright (C) 2007 Peter Goodman, Geoffrey Goodman

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

class BookmarkedThreadsDefinition extends FAModelDefinition 
{
	
	function getField($field, $insert = FALSE) 
	{
		$prefix = !$insert ? 'bt.' : '';
		return "$prefix$field";
	}
	
	function getPrimaryKey() 
	{
		return 'bookmark_id';
	}
	
	function getTable() {
		return 'k4_bookmarked_threads';
	}
	
	function getSelectFields() 
	{
		return "bt.*, t.name AS name, t.body AS body, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags";
	}
	
	function getSelectGroupby() 
	{
		return 'bt.thread_id';
	}
	
	function getSelectTables() 
	{
		return 'k4_bookmarked_threads bt, k4_thread_user_tags tut, k4_tags ts, k4_threads t';
	}
	
	function getSelectWhere() 
	{
		return 'bt.thread_id=t.thread_id AND bt.thread_id=tut.thread_id AND bt.user_id=tut.user_id AND tut.tag_id=ts.tag_id';
	}
}

class BookmarkedThreadsRecord extends FARecord
{
	var $_tags;
	
	function &getTags()
	{
		if($this->_tags === NULL)
		{
			$this->_tags = &new FAArrayIterator(explode(",", $this->_get('tags')));
		}
		
		return $this->_tags;
	}
}

?>