Тизер материалов определенного пользователя - ZOO

	
static function getZOOItem($profileID)
		{
			global $_CB_database;
					
			$sql  = "SELECT
								id
						FROM
								".$_CB_database->nameQuote('#__zoo_item')."
						WHERE
								".$_CB_database->nameQuote('created_by')." = ".$_CB_database->quote($profileID)."
						AND
								".$_CB_database->nameQuote('application_id')." = '1'
						AND
								".$_CB_database->nameQuote('type')." IN ('article','photo','video')
						AND
								".$_CB_database->nameQuote('state')." = '1'									
						ORDER BY
								".$_CB_database->nameQuote('created')." DESC";				
								
			$query = $_CB_database->setQuery($sql);
			$row  = $_CB_database->loadObjectList();
			return $row;
		}

function postsbyform($option,$uid){
	global $_CB_framework, $ueConfig;
	require_once (JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_zoo' . DS . 'config.php');
	$zoo    = App::getInstance('zoo');
	$row = HTML_comprofiler::getZOOItem($uid);
	$html = "";		
	ob_start();
			?>
			<div class="myzooitems">
			<ul class="items">

			<?php foreach ($row as $data) : ?>
			<li>		
			<?php 
					$item = $zoo->table->item->get($data->id);	
					$link = $zoo->route->item($item);	
			?>
					<a href="<?php echo $link; ?>" title="<?php echo $item->name; ?>"><?php echo $item->name; ?><a>						
			</li>
			<?php endforeach; ?>
	
			</ul>			
            </div>
			<?php
			$html = ob_get_contents();
			ob_end_clean();
			echo $html;
}

		<?php foreach ($this->items as $id => $item) : ?>
		<li>

			<?php $this->params = $item->getParams('site'); ?>
			<?php $type = ($this->renderer->pathExists('item/'.$item->type))? $item->type : 'item'; ?>
			<div class="preview hidden <?php echo $type; ?>">
				<?php
					$layout  = 'item.'.($type != 'item' ? $item->type . '.' : '');
					echo $this->renderer->render($layout.'teaser', array('view' => $this, 'item' => $item));
				?>
			</div>

		</li>
		<?php endforeach; ?>

$layout  = 'item.'.($type != 'item' ? $item->type . '.' : '');
echo $this->renderer->render($layout.'teaser', array('view' => $this, 'item' => $item));

<?php
/**
 * CB My ZOO Items - CommunityBuilder plugin displays a tab with the last user ZOO posts
 *
 * @version 2.5.0.0
 * @package ZOO plugin for CommunityBuilder
 * @author Attavus M.D. (webmaster@raslab.org)
 * @copyright (C) 2011 R.A.S.Lab (http://www.raslab.org)
 * @license GNU/GPL: http://www.gnu.org/copyleft/gpl.html
 *
 **/

// ensure this file is being included by a parent file
if ( ! ( defined( '_VALID_CB' ) || defined( '_JEXEC' ) || defined( '_VALID_MOS' ) ) ) { die( 'Direct Access to this location is not allowed.' ); }


class MyZOOItemsTab extends cbTabHandler {
	
	private $zoo;
	
	function MyZOOItemsTab() {
		$this->cbTabHandler();
		require_once (JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_zoo' . DS . 'config.php');
		$this->zoo = App::getInstance('zoo');
	}//function
	
	/**
	* Generates the HTML to display the user profile tab
	* @param object tab reflecting the tab database entry
	* @param object mosUser reflecting the user being displayed
	* @param int 1 for front-end, 2 for back-end
	* @returns mixed : either string HTML for tab content, or false if ErrorMSG generated
	*/

	function getDisplayTab($tab, $user, $ui)
	{
		$zooapps = trim($this->params->get('zooapp'), ',');
		
		$def_limit = $this->params->get('count', 10);
		$paging = $this->params->get('paging',1);
							
		if ($tab->description != null) $return .= "<div class=\"tab_Description\">".$tab->description."</div>";		
		
		$pagingParams = $this->_getPaging(array(),array("_"));
		if ($paging)
		{
			$total = $this->countZOOItem((int) $user->id, $zooapps);			
			if (!is_numeric($total)) $total = 0;
			
			if (!isset($pagingParams["_limitstart"])) $pagingParams["_limitstart"] = "0";
			if ($def_limit > $total) $pagingParams["_limitstart"] = "0";
		}
							
		$items = $this->getZOOItems ((int) $user->id, $pagingParams["_limitstart"], $def_limit, $zooapps);
				
		$html = "";		
					
			ob_start();
			?>
			
			<div class="myzooitems">
			<?php if (!empty($items)) : ?>			
			<ul class="items">
			<?php foreach ($items as $item) : ?>
				<li class="item">					
					<?php 
																					
					$renderer = $this->zoo->renderer->create('item')->addPath(array($this->zoo->path->path('component.site:'), $item->getApplication()->getTemplate()->getPath()));
		
					$path   = 'item';
					$prefix = 'item.';
					$type   = $item->getType()->id;
					if ($renderer->pathExists($path.DIRECTORY_SEPARATOR.$type)) {
						$path   .= DIRECTORY_SEPARATOR.$type;
						$prefix .= $type.'.';
					}

					if (in_array('teaser', $renderer->getLayouts($path))) {
						echo $renderer->render($prefix.'teaser', array('item' => $item));
					} elseif (in_array('full', $renderer->getLayouts($path))) {
						echo $renderer->render($prefix.'full', array('item' => $item));
					} else {
						echo '<a href="'.cbSef('index.php?option=com_zoo&task=item&item_id='. $item->id).'" >'.$item->name.'</a>';
					}		
				
					?>	 			 										
				</li>
			<?php endforeach; ?>
	
			</ul>			
				<?php if ($paging && $total > $def_limit):?>
					<!-- Start Pagination -->
					<div style='width:95%;text-align:center;'><?php echo $this->_writePaging($pagingParams,"_",$def_limit,$total);?></div>
					<!-- End Pagination -->			
				<?php endif; ?>	
			<?php else : ?>	
					<p class="no-items"><?php echo JText::_('PLG_MYZOOITEMS_NO_ITEMS'); ?></p>
			<?php endif; ?>					
			</div>
			<?php
			$html = ob_get_contents();
			ob_end_clean();
			return $html;
	}//function
	
	function getZOOItems ($profileID, $limitstart, $limit, $zooapps) {
			//init vars
			$db    = $this->zoo->database;
			// get dates			
			$date = $this->zoo->date->create();
			$now  = $db->Quote($date->toMySQL());
			$null = $db->Quote($db->getNullDate());
					
			//if(!empty($zooapp)) {
			//	$conditions = " AND application_id = 1 ";
			//} else {
			//	$conditions = "";
			//}
			
			if($this->params->get('display_expired', 1)) {
				$expired = "";
			} else {
				$expired = ' AND (publish_up = '.$null.' OR publish_up <= '.$now.')'
							.' AND (publish_down = '.$null.' OR publish_down >= '.$now.')';
			}
							
			$options = array(
						'select' => '*',
						'from' => ZOO_TABLE_ITEM,
						'conditions' => 'created_by = '.$profileID." AND application_id = 1",
						'order' => 'priority DESC',
						'offset' => (int) ( $limitstart ? $limitstart : 0 ),
						'limit' =>  (int) $limit);
			// get items
			$items = $this->zoo->table->item->all($options);	
			return $items;
		}
		
		
		function countZOOItem($profileID, $zooapp)
		{		
			global $_CB_database;
			
			//if(!empty($zooapp))
			//{
			//	$condition = " AND application_id = 1";
			//}
			//else
			//{
			//	$condition = "";
			//}
		
			$sql  = "SELECT	count(*)
					 FROM ".$_CB_database->nameQuote('#__zoo_item')."
					 WHERE ".$_CB_database->nameQuote('created_by')." = ".$_CB_database->quote($profileID)
					." AND application_id = 1";
			$query = $_CB_database->setQuery($sql);
			$count  = $_CB_database->loadResult();
			if($_CB_database->getErrorNum()) {
				JError::raiseError( 500, $_CB_database->stderr());
			}		
			
			return $count;//$count->total;
		}
		
			
		function getExpiredCondition()
		{
			global $_CB_database;
			
			$date	= new JDate();
			$now	= $date->toFormat();
			
			$condition = " AND ( " . " "
								   . "( "
			                       . $_CB_database->nameQuote('publish_up')." <= ".$_CB_database->quote($now). " AND "
						 		   . $_CB_database->nameQuote('publish_down')." >= ".$_CB_database->quote($now). " "
								   . ") OR "
								   .$_CB_database->nameQuote('publish_down')." = ".$_CB_database->quote("0000-00-00 00:00:00"). " "
							. " ) ";
						 
			return $condition;
		}
}