ConLite/conlite/includes/include.upl_artlist.php

<?php
/**
 * Project: 
 * Contenido Content Management System
 * 
 * Description: 
 * Article list for upload
 * 
 * Requirements: 
 * @con_php_req 5.0
 * 
 *
 * @package    Contenido Backend includes
 * @version    1.0.1
 * @author     unknown
 * @copyright  four for business AG <www.4fb.de>
 * @license    http://www.contenido.org/license/LIZENZ.txt
 * @link       http://www.4fb.de
 * @link       http://www.contenido.org
 * @since      file available since contenido release <= 4.6
 * 
 * {@internal 
 *   created unknown
 *   modified 2008-06-27, Frederic Schneider, add security fix
 *
 *   $Id$:
 * }}
 * 
 */

if(!defined('CON_FRAMEWORK')) {
	die('Illegal call');
}


cInclude("includes", "functions.con.php");

$page = new cPage;

conCreateLocationString($idcat, "/", $cat_str);

$mcatlink = "";

$_cecIterator = $_cecRegistry->getIterator("Contenido.Content.CreateCategoryLink");
if ($_cecIterator->count() > 0)
{
	while ($chainEntry = $_cecIterator->next())
	{
	    $catlink = $chainEntry->execute($idcat);
	    
	    if ($catlink != "")
	    {
	    	$mcatlink = $catlink;	
	    }				    
	}
}

if ($mcatlink == "")
{
	$mcatlink = "front_content.php?idcat=$idcat";
}

$jslink = 'parent.parent.frames[\'left\'].frames[\'left_top\'].document.getElementById(\'selectedfile\').value= \''.$mcatlink.'\'; window.returnValue=\''.$mcatlink.'\'; window.close();';
$content[] = '<div style="padding: 2px; border: 1px; border-color: #B3B3B3; border-style: solid; background-color: #F4F4F7;">';
$content[] = '<table border="0" cellspacing="0" cellpadding="0"><tr><td>';
$content[] = '<a href="javascript://" onclick="'.$jslink.'"><img alt="'.i18n("Use this category").'" title="'.i18n("Use this category").'" style="padding-right: 4px;" src="images/folder_movedown.gif"></a></td><td>';
$content[] = $cat_str;
$content[] = '</td></tr></table></div>';

$cApiCategoryArticleCollection = new cApiCategoryArticleCollection;

$cApiCategoryArticleCollection->link("cApiCategoryLanguageCollection");
$cApiCategoryArticleCollection->link("cApiArticleCollection");
$cApiCategoryArticleCollection->link("cApiArticleLanguageCollection");
$cApiCategoryArticleCollection->link("cApiCategoryCollection");
$cApiCategoryArticleCollection->setWhere("cApiCategoryLanguageCollection.idlang", $lang);
$cApiCategoryArticleCollection->setWhere("cApiArticleLanguageCollection.idlang", $lang);
$cApiCategoryArticleCollection->setWhere("cApiCategoryLanguageCollection.idcat", $idcat);
$cApiCategoryArticleCollection->query();

$headlines = array(i18n("Start"), i18n("Title"), i18n("Created"), i18n("Modified"), i18n("Sort Order"), i18n("Online"));
$fields = array("is_start", "title", "created", "lastmodified", "artsort", "online");

$content[] = '<table width="100%" style="margin-top: 10px; border-left: 1px solid '.$cfg['color']['table_border'].'; border-top: 1px solid '.$cfg['color']['table_border'].';" cellspacing="0" cellpadding="0"><tr>';

foreach ($headlines as $headline)
{
	$content[] = '<td nowrap="nowrap" style="padding: 2px; white-space: nowrap; color: white; background: '.$cfg['color']['table_header'].'; border-bottom: 1px solid '.$cfg['color']['table_border'].';  border-right: 1px solid '.$cfg['color']['table_border'].';">'.$headline.'</td>';	
}

$content[] = '</tr>';

$dateformat = getEffectiveSetting("backend", "timeformat", "Y-m-d H:i:s");

$odd = false;

while ($cApiCategoryArticle = $cApiCategoryArticleCollection->next())
{
	$obj = $cApiCategoryArticleCollection->fetchObject("cApiArticleLanguageCollection");
	
	$odd = !$odd;
	
	if ($odd)
	{
		$mcol = $cfg['color']['table_light'];
	} else {
		$mcol = $cfg['color']['table_dark'];
	}

	$content[] = '<tr>';	

	$martlink = "";
	$idart = $obj->get("idart");

	$_cecIterator = $_cecRegistry->getIterator("Contenido.Content.CreateArticleLink");
	if ($_cecIterator->count() > 0)
	{
		while ($chainEntry = $_cecIterator->next())
		{
		    $artlink = $chainEntry->execute($idart, $idcat);
		    
		    if ($artlink != "")
		    {
		    	$martlink = $artlink;	
		    }				    
		}
	}
	
	if ($martlink == "")
	{
		$martlink = "front_content.php?idart=$idart";
	}	
	
	$jslink = 'parent.parent.frames[\'left\'].frames[\'left_top\'].document.getElementById(\'selectedfile\').value= \''.$martlink.'\'; window.returnValue=\''.$martlink.'\'; window.close();';
	
	foreach ($fields as $field)
	{
		switch ($field)
		{
			case "is_start":
				$value = isStartArticle($obj->get("idartlang"), $idcat, $lang);
				
				if ($value == true)
				{
					$value = '<img src="images/isstart1.gif">';	
				} else {
					$value = '<img src="images/isstart0.gif">';
				}
				break;
			case "created":
			case "modified":
				$value = date($dateformat,strtotime($obj->get($field)));
				break;
			case "online":
				if ($obj->get("online") == true)
				{
					$value = '<img src="images/online.gif">';
				} else {
					$value = '<img src="images/offline.gif">';	
				}
				break;
				
			default:
				$value = $obj->get($field);
				break;	
		}
		

		if ($field == "title")
		{
			$xwidth = 'width="100%"';	
		} else {
			$xwidth = 'width="1%"';	
		}
		
		$content[] = '<td onclick="'.$jslink.'" nowrap="nowrap" '.$xwidth.' style="cursor: pointer; padding: 2px; white-space: nowrap; background: '.$mcol.'; border-bottom: 1px solid '.$cfg['color']['table_border'].'; border-right: 1px solid '.$cfg['color']['table_border'].';">'.$value.'</td>';	
	}
	
	$content[] = '</tr>';
}

$content[] = '</table>';
$page->setContent(implode("", $content));
$page->render();
?>