<?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.
*/

//--------------------------------------------
// Definition for the tag groupss table.
//--------------------------------------------

class TagGroupsDefinition extends FAModelDefinition {
	
	function getPrimaryKey() {
		return 'group_id';
	}
	
	function getField($field, $insert = FALSE) {
		$prefix = !$insert ? 'tg.' : '';
		return "$prefix$field";
	}
	
	function getTable() {
		return 'k4_tag_groups';
	}
	
	function getSelectTables() 
	{
		return 'k4_tag_groups tg, k4_group_tags gt, k4_tags ts';
	}
	
	function getSelectFields() 
	{
		return "DISTINCT tg.group_id, tg.*, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags";
		
	}
	
	function getSelectGroupby()
	{
		return "tg.group_id";
	}
	
	function getSelectWhere()
	{
		return "tg.group_id=gt.group_id AND gt.tag_id=ts.tag_id";
	}
}

class TagGroupsRecord extends FARecord
{
	var $_tags;
	
	function setTags(&$tags)
	{
		$this->_tags = &$tags;
	}
	
	function &getTags()
	{
		if($this->_tags === NULL)
		{
			$this->_tags = &new FAArrayIterator(explode(",", $this->_get('tags')));
		}
		
		return $this->_tags;
	}
	
	function getPlussedTags()
	{
		return $this->_getTagsSeparator('+');
	}
	
	function getRawTags()
	{
		return $this->_getTagsSeparator(', ');
	}
	
	function save()
	{
		if($ret = parent::save())
		{
			//--------------------------------------------
			// Loop over all of the tags that exist.
			//--------------------------------------------

			$sql = "INSERT INTO k4_group_tags (group_id,tag_id) VALUES ";
			$group_id = intval($this->getId());
			$tag_ids = array();
			
			//--------------------------------------------
			// Create the parts of the SQL query to link the 
			// tags and group.
			//--------------------------------------------
			
			while($this->_tags->next())
			{
				$tag = &$this->_tags->current();

				$sql .= "(". $group_id .",?),";
				$tag_ids[] = $tag->getId();
			}

			$sql = substr($sql, 0, -1);

			//--------------------------------------------
			// Link the tags to the group.
			//--------------------------------------------

			$this->_dba->executeUpdate($sql, $tag_ids);
		}
		
		return $ret;
	}
	
	function _getTagsSeparator($sep)
	{
		$str = '';
		
		$tags = &$this->getTags();
		
		$tags->reset();
		
		while($tags->next())
		{
			$tag = &$tags->current();
			
			$str .= $tag . $sep;
		}
		
		return substr($str, 0, (-1 * strlen($sep)) );
	}
}

?>