/application/models/ContentHasContent.php

<?php
/**
 *  ContentHasContent -> ContentHasContent database model for content has content link table.
 *
* 	Copyright (c) <2009>, Markus Riihel�
* 	Copyright (c) <2009>, Mikko Sallinen
*
 * 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., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 *
 * License text found in /license/
 */

/**
 *  ContentHasContent - class
 *
 *  @package 	models
 *  @author 		Markus Riihel� & Mikko Sallinen
 *  @copyright 	2009 Markus Riihel� & Mikko Sallinen
 *  @license 	GPL v2
 *  @version 	1.0
 */ 
class Default_Model_ContentHasContent extends Zend_Db_Table_Abstract
{
	// Table name
    protected $_name = 'cnt_has_cnt';
	
	// Table reference map
	protected $_referenceMap    = array(
        'ParentContent' => array(
            'columns'           => array('id_parent_cnt'),
            'refTableClass'     => 'Default_Model_Content',
            'refColumns'        => array('id_cnt')
        ),  
		 'ChildContent' => array(
            'columns'           => array('id_child_cnt'),
            'refTableClass'     => 'Default_Model_Content',
            'refColumns'        => array('id_cnt')
        ),
    );
	
	/**
	*	addContentToContent
	*
	*	Add content to be a child of another content
	*
	*	@param integer $id_parent_cnt
	*	@param integer $id_child_cnt
	*/
	public function addContentToContent($id_parent_cnt = 0, $id_child_cnt = 0)
	{
		// If id values not 0
		if($id_parent_cnt != 0 && $id_child_cnt != 0)
		{
			$data = array(
					'id_parent_cnt' => $id_parent_cnt,
					'id_child_cnt' => $id_child_cnt,
					'created_cnt' => new Zend_Db_Expr('NOW()')
			);
			$this->insert($data);

		} // end if
	} // end of addContentToContent
    
    /*
    *   Get the parents and children  of content
    *   
    *   @param  id      integer id of the content for which we want the tree
    *   @return return  array   array of the family tree
    */
    public function getContentFamilyTree($id = -1) 
    {
        $return = array();
    
        $selectParents = $this->_db->select()
                            ->from(array('cnt_has_cnt' => 'cnt_has_cnt'),
                                   array('id_parent_cnt'))
                            ->joinLeft(array('cnt' => 'contents_cnt'),
                                       'cnt.id_cnt = cnt_has_cnt.id_parent_cnt', 
                                       array())
                            ->where('id_child_cnt = ?', $id)
                            ->where('cnt.published_cnt = 1')
                            ->order('cnt_has_cnt.created_cnt desc')
        ;
        $parents = $this->_db->fetchAll($selectParents);
        
        $i = 0;
        foreach ($parents as $parent) {
            $return['parents'][$i] = $parent['id_parent_cnt'];
            
            $i++;
        }

        $selectChildren = $this->_db->select()
                            ->from(array('cnt_has_cnt' => 'cnt_has_cnt'),
                                   array('id_child_cnt'))
                            ->joinLeft(array('cnt' => 'contents_cnt'),
                                       'cnt.id_cnt = cnt_has_cnt.id_child_cnt', 
                                       array())
                            ->where('id_parent_cnt = ?', $id)
                            ->where('cnt.published_cnt = 1')
                            ->order('cnt_has_cnt.created_cnt desc')
        ;
        $children = $this->_db->fetchAll($selectChildren);
        
        $i = 0;
        foreach ($children as $child) {
            $return['children'][$i] = $child['id_child_cnt'];
            $i++;
        }

        return $return;
    }
    
    public function checkIfContentHasContent($id_parent_cnt = -1, $id_child_cnt = -1) {
        $return = false;
        
        if($id_parent_cnt != -1 && $id_child_cnt != -1)
        {
            $select = $this->select()
                           ->from($this, array('*'))
                           ->where('`id_parent_cnt` = ?', $id_parent_cnt)
                           ->where('`id_child_cnt` = ?', $id_child_cnt);

            $result = $this->fetchAll($select)->toArray();
            
            if(count($result) != 0) {
                $return = true;
            }
        }
        
        return $return;
    }

    /**
    *   getContentContents
    *   Get all content contents
    *
    *   @author Mikko Korpinen
    *   @param int id_parent_cnt Id of content
    *   @return array
    */
    public function getContentContents($id_cnt) {

        $result = array();  // container for final results array

        $contentSelectParents = $this->_db->select()
                                   ->from(array('chc' => 'cnt_has_cnt'),
                                          array('id_parent_cnt', 'id_child_cnt'))
                                   ->joinLeft(array('cnt' => 'contents_cnt'),
                                          'cnt.id_cnt = chc.id_child_cnt',
                                          array('id_cnt', 'id_cty_cnt', 'title_cnt',
                                                'lead_cnt', 'published_cnt', 'created_cnt'))
                                   ->joinLeft(array('cty' => 'content_types_cty'),
                                          'cty.id_cty = cnt.id_cty_cnt',
                                          array('key_cty'))
                                   ->joinLeft(array('chu' => 'cnt_has_usr'),
                                          'chu.id_cnt = cnt.id_cnt',
                                          array('id_usr'))
                                   ->joinLeft(array('usr' => 'users_usr'),
                                          'usr.id_usr = chu.id_usr',
                                          array('login_name_usr'))
                                   ->where('chc.id_parent_cnt = ?', $id_cnt)
                                   ->group('cnt.id_cnt');

        $contentSelectChilds = $this->_db->select()
                                   ->from(array('chc' => 'cnt_has_cnt'),
                                          array('id_parent_cnt', 'id_child_cnt'))
                                   ->joinLeft(array('cnt' => 'contents_cnt'),
                                          'cnt.id_cnt = chc.id_parent_cnt',
                                          array('id_cnt', 'id_cty_cnt', 'title_cnt',
                                                'lead_cnt', 'published_cnt', 'created_cnt'))
                                   ->joinLeft(array('cty' => 'content_types_cty'),
                                          'cty.id_cty = cnt.id_cty_cnt',
                                          array('key_cty'))
                                   ->joinLeft(array('chu' => 'cnt_has_usr'),
                                          'chu.id_cnt = cnt.id_cnt',
                                          array('id_usr'))
                                   ->joinLeft(array('usr' => 'users_usr'),
                                          'usr.id_usr = chu.id_usr',
                                          array('login_name_usr'))
                                   ->where('chc.id_child_cnt = ?', $id_cnt)
                                   ->group('cnt.id_cnt');

        $result['parents'] = $this->_db->fetchAll($contentSelectParents);
        $result['childs'] = $this->_db->fetchAll($contentSelectChilds);

        return $result;
    }

    /**
    *   removeContentFromContents
    *   Removes specified content from contents (child or parent)
    *
    *   @param int id_cnt Id of content
    *   @author Mikko Korpinen
    */
    public function removeContentFromContents($id_cnt = 0)
    {
        $parent = $this->getAdapter()->quoteInto('id_parent_cnt = ?', (int)$id_cnt);
        $child = $this->getAdapter()->quoteInto('id_child_cnt = ?', (int)$id_cnt);
        $where = "$parent OR $child";
        $this->delete($where);
        
        return !$this->fetchAll($where)->count();
    }

    /**
    *   removeContentFromContent
    *   Removes specified content from content
    *
    *   @param int id_parent_cnt Id of content
    *   @param int id_child_cnt Id of content
    *   @author Mikko Korpinen
    */
    public function removeContentFromContent($id_parent_cnt = 0, $id_child_cnt = 0)
    {
        $parent = $this->getAdapter()->quoteInto('id_parent_cnt = ?', (int)$id_parent_cnt);
        $child = $this->getAdapter()->quoteInto('id_child_cnt = ?', (int)$id_child_cnt);
        $where = "$parent AND $child";
        if ($this->delete($where)) {
            return true;
        } else {
            return false;
        }
    }
    
    public function getContentLinkIds($id) {
    	$selectParents = $this->select()->from($this, array('id_cnt' => 'id_parent_cnt'))
    					->where('id_child_cnt = ?', $id);
    	$ids = $this->fetchAll($selectParents)->toArray();

    	$selectChilds = $this->select()	->from($this, array('id_cnt' => 'id_child_cnt' ))
    									->where('id_parent_cnt = ?', $id);
    	return array_merge($ids, $this->fetchAll($selectChilds)->toArray());	
    }
    
} // end of class
?>