CONTENIDO Forum

Code: Alles auswählen

<?php
/**
 * Project: 
 * Contenido Content Management System
 * 
 * Description: 
 * Module list
 * 
 * Requirements: 
 * @con_php_req 5.0
 * 
 *
 * @package    Contenido Backend includes
 * @version    1.3.2
 * @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 2003-03-21
 *   modified 2008-06-27, Frederic Schneider, add security fix
 *   modified 2010-08-18, Munkh-Ulzii Balidar, add a functionality to show the used info
 *
 *   $Id: include.mod_overview.php 1224 2010-10-12 08:59:42Z dominik.ziegler $:
 * }}
 * 
 */

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

cInclude("classes", "class.htmlelements.php");
cInclude("classes", "class.todo.php");
cInclude("classes", "contenido/class.module.php");
cInclude("classes", "contenido/class.user.php");
cInclude("classes", "widgets/class.widgets.page.php");
cInclude("classes", "widgets/class.widgets.foldingrow.php");
cInclude("classes", "widgets/class.widgets.pager.php");
cInclude("classes", "class.ui.php");

if (!(int) $client > 0) {
  #if there is no client selected, display empty page
  $oPage = new cPage;
  $oPage->render();
  return;
}

############################
# Now build bottom with list
############################
$cApiModuleCollection	= new cApiModuleCollection;
$classmodule			    = new cApiModule;
$oPage					      = new cPage;

// no value found in request for items per page -> get form db or set default
$oUser = new cApiUser($auth->auth["uid"]);
if (!isset($_REQUEST["elemperpage"]) || !is_numeric($_REQUEST['elemperpage']) || $_REQUEST['elemperpage'] < 0) 
{
	$_REQUEST["elemperpage"] = $oUser->getProperty("itemsperpage", $area);
}
if (!is_numeric($_REQUEST["elemperpage"])) 
{
	$_REQUEST["elemperpage"] = 0;
}
if ($_REQUEST["elemperpage"] > 0) 
{
	// -- All -- will not be stored, as it may be impossible to change this back to something more useful
	$oUser->setProperty("itemsperpage", $area, $_REQUEST["elemperpage"]);
}
unset ($oUser);

if (!isset($_REQUEST["page"]) || !is_numeric($_REQUEST['page']) || $_REQUEST['page'] <= 0 || $_REQUEST["elemperpage"] == 0) 
{
	$_REQUEST["page"] = 1;
}

// Sort by requested
if (isset ($_REQUEST["sortby"]) && $_REQUEST["sortby"] != "")
{
	$cApiModuleCollection->setOrder($_REQUEST["sortby"]." ".$_REQUEST["sortorder"]);
} 
else
{
	$cApiModuleCollection->setOrder("name asc");
}


// Search filter requested
if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == '')
{
	$cApiModuleCollection->setWhereGroup("default", "name", "%".$_REQUEST["filter"]."%", "LIKE");
	$cApiModuleCollection->setWhereGroup("default", "description", "%".$_REQUEST["filter"]."%", "LIKE");
	$cApiModuleCollection->setWhereGroup("default", "type", "%".$_REQUEST["filter"]."%", "LIKE");
	$cApiModuleCollection->setWhereGroup("default", "input", "%".$_REQUEST["filter"]."%", "LIKE");
	$cApiModuleCollection->setWhereGroup("default", "output", "%".$_REQUEST["filter"]."%", "LIKE");
	$cApiModuleCollection->setInnerGroupCondition("default", "OR");
} else if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == 'name') {
    $cApiModuleCollection->setWhereGroup("default", "name", "%".$_REQUEST["filter"]."%", "LIKE");
    $cApiModuleCollection->setInnerGroupCondition("default", "OR");
} else if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == 'description') {
    $cApiModuleCollection->setWhereGroup("default", "description", "%".$_REQUEST["filter"]."%", "LIKE");
    $cApiModuleCollection->setInnerGroupCondition("default", "OR");
} else if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == 'type') {
    $cApiModuleCollection->setWhereGroup("default", "type", "%".$_REQUEST["filter"]."%", "LIKE");
    $cApiModuleCollection->setInnerGroupCondition("default", "OR");
} else if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == 'input') {
    $cApiModuleCollection->setWhereGroup("default", "input", "%".$_REQUEST["filter"]."%", "LIKE");
    $cApiModuleCollection->setInnerGroupCondition("default", "OR");
} else if (isset ($_REQUEST["filter"]) && $_REQUEST["filter"] != ""  && $_REQUEST["searchin"] == 'output') {
    $cApiModuleCollection->setWhereGroup("default", "output", "%".$_REQUEST["filter"]."%", "LIKE");
    $cApiModuleCollection->setInnerGroupCondition("default", "OR");
}

// Type filter requested
if (isset($_REQUEST["filtertype"]))
{
	switch ($_REQUEST["filtertype"])
	{
		case "--all--":
			break;
		case "--wotype--":
			$cApiModuleCollection->setWhere("type", "");
			break;
		default:
			$cApiModuleCollection->setWhere("type", $_REQUEST["filtertype"]);
			break;	
	}
}

// Items per page requested
$cApiModuleCollection->setWhere("idclient", $client);


if ($_REQUEST["elemperpage"] > 0) 
{
	$cApiModuleCollection->query();
	$iItemCount = $cApiModuleCollection->count();

	if ($iItemCount < (($_REQUEST["page"] - 1) * $_REQUEST["elemperpage"])) 
	{
		$_REQUEST["page"] = 1;
	}
    
    if ($_REQUEST["elemperpage"]*($_REQUEST["page"]) >= $iItemCount+$_REQUEST["elemperpage"] && $_REQUEST["page"]  != 1) {
        $_REQUEST["page"]--;
    }

	$cApiModuleCollection->setLimit(($_REQUEST["elemperpage"] * ($_REQUEST["page"] -1)), $_REQUEST["elemperpage"]);
} 
else 
{
	$iItemCount 		= 0;
}


// Build list for left_bottom considering filter values
$mlist 				      = new UI_Menu;
$sOptionModuleCheck	= getSystemProperty("system", "modulecheck");
$sOptionForceCheck	= getEffectiveSetting("modules", "force-menu-check", "false");
$iMenu				= 0;

$cApiModuleCollection->query();
while ($cApiModule = $cApiModuleCollection->next())
{
	if ($perm->have_perm_item($area, $db->f("idmod")) || $perm->have_perm_area_action("mod_translate", "mod_translation_save") || $perm->have_perm_area_action_item("mod_translate", "mod_translation_save", $cApiModule->get("idmod")))
	{
			$idmod = $cApiModule->get("idmod");
			
			$link = new cHTMLLink;
			$link->setMultiLink("mod", "", "mod_edit", "");
			$link->setCustom("idmod", $cApiModule->get("idmod"));
			$link->updateAttributes(array ("alt" => $cApiModule->get("description")));
			$link->updateAttributes(array ("title" => $cApiModule->get("description")));
			$link->updateAttributes(array ("style" => "margin-left:5px"));

			$sName = $cApiModule->get("name");

			if ($sOptionModuleCheck !== "false" && $sOptionForceCheck !== "false")
			{
				// Check module and force check has been enabled - check module (surprisingly...)
				$inputok = modTestModule($cApiModule->get("input"), $cApiModule->get("idmod")."i", false);
				$outputok = modTestModule($cApiModule->get("output"), $cApiModule->get("idmod")."o", true);

				if ($inputok && $outputok)		// Everything ok
				{
					$colName = $sName;			// The set default color: none :)
				}
				else if ($inputok || $outputok)	// Input or output has a problem
				{
					$colName = '<font color="#B1AC58">'.$sName.'</font>';
				}
				else							// Input >and< output has a problem
				{
					$colName = '<font color="red">'.$sName.'</font>';
				}
			}
			else
			{
				// Do not check modules (or don't force it) - so, let's take a look into the database 
				$sModuleError = $cApiModule->get("error");
				
				if ($sModuleError == "none")
				{
					$colName = $sName;
				} 
				else if ($sModuleError == "input" || $sModuleError == "output")
				{
					$colName = '<font color="#B1AC58">'.$sName.'</font>';
				} 
				else
				{
					$colName = '<font color="red">'.$sName.'</font>';
				}
			}

			$iMenu ++;

			$mlist->setTitle($iMenu, $colName);
			if ($perm->have_perm_area_action_item("mod_edit", "mod_edit", $db->f("idmod")) || $perm->have_perm_area_action_item("mod_translate", "mod_translation_save", $cApiModule->get("idmod")))
			{
				$mlist->setLink($iMenu, $link);
			}

			$inUse = $classmodule->moduleInUse($idmod);

			$deletebutton = "";
			
			if ($inUse)
			{
				$inUseString = i18n("In use");
				$mlist->setActions($iMenu, 'inuse', '<a href="javascript:;" rel="' . $idmod . '" class="in_used_mod"><img src="'.$cfg['path']['images'].'exclamation.gif" border="0" title="'.$inUseString.'" alt="'.$inUseString.'"></a>');
				$delDescription = i18n("Module in use, cannot delete");
				
			} else {
                $mlist->setActions($iMenu, 'inuse', '<img src="./images/spacer.gif" border="0" width="16">');
				if ($perm->have_perm_area_action_item("mod", "mod_delete", $cApiModule->get("idmod")))
				{
				$delTitle = i18n("Delete module");
				$delDescr = sprintf(i18n("Do you really want to delete the following module:<br><br>%s<br>"), $sName);

				$deletebutton = '<a title="'.$delTitle.'" href="javascript://" onclick="box.confirm(\''.$delTitle.'\', \''.$delDescr.'\', \'deleteModule('.$idmod.')\')"><img src="'.$cfg['path']['images'].'delete.gif" border="0" title="'.$delTitle.'" alt="'.$delTitle.'"></a>';				
				} else {
					$delDescription = i18n("No permission");	
				}
			}
			
			if ($deletebutton == "")
			{
                //$deletebutton = '<img src="images/spacer.gif" width="16" height="16">';
				$deletebutton = '<img src="'.$cfg['path']['images'].'delete_inact.gif" border="0" title="'.$delDescription.'" alt="'.$delDescription.'">';	
			}
			
			$todo = new TODOLink("idmod", $db->f("idmod"), "Module: $sName", "");
			
			$mlist->setActions($iMenu, "todo", $todo->render());
			$mlist->setActions($iMenu, "delete", $deletebutton);
            
            if ($_GET['idmod'] == $idmod) {
                $mlist->setExtra($iMenu, 'id="marked" ');
            }     
			//$mlist->setImage($iMenu, "images/but_module.gif");
			//$mlist->setImage($iMenu, 'images/spacer.gif', 5);
		}
}

$deleteScript = '    <script type="text/javascript">

        var sid = "'.$sess->id.'";
        box = new messageBox("", "", "", 0, 0);

        function deleteModule(idmod) {

        //console.log(parent.frames[1].document.filter.sortorder);
        
  			form = document.getElementById("filter");

        url  = \'main.php?area=mod_edit\';
        url += \'&action=mod_delete\';
        url += \'&frame=4\';
        url += \'&idmod=\' + idmod;
        url += \'&contenido=\' + sid;
        url += get_registered_parameters();
        url += \'&sortby=\' + parent.frames[1].document.filter.sortby;
				url += \'&sortorder=\' + parent.frames[1].document.filter.sortorder;
				url += \'&filter=\' + parent.frames[1].document.filtertype;
				url += \'&elemperpage=\' + parent.frames[1].document.filter.elemperpage;
				url += \'&page=\' + parent.frames[1].document.filter.page;
				parent.parent.right.right_bottom.location.href = url;
        }

    </script>';

$sShowUsedInfo = ' 
		<script type="text/javascript">       
			$(document).ready(function() {
				
	        	$(".in_used_mod").live("click", function() {
	            	var iId = $(this).attr("rel");
	            	if (iId) {
	            		$.post(
	            		   "' . $cfg['path']['contenido_fullhtml'] . 'ajaxmain.php' . '", 
	      				   { area: "' . $area . '", ajax: "inused_module", id: iId, contenido: sid }, 
	      				   function(data) {
	      					  box.notify("' . i18n("Is used in") . ':", data);
	      				   } 
	      				);
	            	}	
	        	});
	        });
        </script>
        ';

$sMarkRow = '<script language="javascript">    
                if (document.getElementById(\'marked\')) {
                    row.click(document.getElementById(\'marked\'));
                }
            </script>';
    
$oPage->setMargin(0);
$oPage->addScript('messagebox', '<script type="text/javascript" src="scripts/messageBox.js.php?contenido='.$sess->id.'"></script>');
$oPage->addScript('jquery', '<script type="text/javascript" src="scripts/jquery/jquery.js"></script>');
$oPage->addScript('delete', $deleteScript);
$oPage->addScript('showUsedInfo', $sShowUsedInfo);
$oPage->addScript('cfoldingrow.js', '<script language="JavaScript" src="scripts/cfoldingrow.js"></script>');
$oPage->addScript('parameterCollector.js', '<script language="JavaScript" src="scripts/parameterCollector.js"></script>');
$oPage->setContent($mlist->render(false).$sMarkRow);

//generate current content for Object Pager
$oPagerLink = new cHTMLLink;
$pagerl="pagerlink";
$oPagerLink->setTargetFrame('left_bottom');
$oPagerLink->setLink("main.php");
$oPagerLink->setCustom("elemperpage", $elemperpage);
$oPagerLink->setCustom("filter", stripslashes($_REQUEST["filter"]));
$oPagerLink->setCustom("sortby", $_REQUEST["sortby"]);
$oPagerLink->setCustom("sortorder", $_REQUEST["sortorder"]);
$oPagerLink->setCustom("frame", $frame);
$oPagerLink->setCustom("area", $area);
$oPagerLink->enableAutomaticParameterAppend();
$oPagerLink->setCustom("contenido", $sess->id);
$oPager = new cObjectPager("02420d6b-a77e-4a97-9395-7f6be480f497", $iItemCount, $_REQUEST["elemperpage"], $_REQUEST["page"], $oPagerLink, "page", $pagerl);

//add slashes, to insert in javascript
$sPagerContent = $oPager->render(1);
$sPagerContent = str_replace('\\', '\\\\', $sPagerContent);
$sPagerContent = str_replace('\'', '\\\'', $sPagerContent);

//send new object pager to left_top
$sRefreshPager = '
    <script type="text/javascript">
        var sNavigation = \''.$sPagerContent.'\';
        var left_top = parent.left_top;
        if (left_top.document) {
            var oPager = left_top.document.getElementById(\'02420d6b-a77e-4a97-9395-7f6be480f497\');
            if (oPager) {
                oInsert = oPager.firstChild;
                oInsert.innerHTML = sNavigation;
                left_top.toggle_pager(\'02420d6b-a77e-4a97-9395-7f6be480f497\');
            }
        }
    </script>';
            
$oPage->addScript('refreshpager', $sRefreshPager); 

$oPage->render();
?>

Code: Alles auswählen

$idmod = $cApiModule->get("idmod");

Code: Alles auswählen

while ($cApiModule = $cApiModuleCollection->next())
{
   if ($perm->have_perm_item($area, $db->f("idmod")) || $perm->have_perm_area_action("mod_translate", "mod_translation_save") || $perm->have_perm_area_action_item("mod_translate", "mod_translation_save", $cApiModule->get("idmod")))
   {
         $idmod = $cApiModule->get("idmod");
         
         $link = new cHTMLLink;
         $link->setMultiLink("mod", "", "mod_edit", "");
         $link->setCustom("idmod", $cApiModule->get("idmod"));
         $link->updateAttributes(array ("alt" => $cApiModule->get("description")));
         $link->updateAttributes(array ("title" => $cApiModule->get("description")));
         $link->updateAttributes(array ("style" => "margin-left:5px"));

         $sName = $cApiModule->get("name");

         if ($sOptionModuleCheck !== "false" && $sOptionForceCheck !== "false")
         {
            // Check module and force check has been enabled - check module (surprisingly...)
            $inputok = modTestModule($cApiModule->get("input"), $cApiModule->get("idmod")."i", false);
            $outputok = modTestModule($cApiModule->get("output"), $cApiModule->get("idmod")."o", true);

            if ($inputok && $outputok)      // Everything ok
            {
               $colName = $sName;         // The set default color: none :)
            }
            else if ($inputok || $outputok)   // Input or output has a problem
            {
               $colName = '<font color="#B1AC58">'.$sName.'</font>';
            }
            else                     // Input >and< output has a problem
            {
               $colName = '<font color="red">'.$sName.'</font>';
            }
         }
         else
         {
            // Do not check modules (or don't force it) - so, let's take a look into the database
            $sModuleError = $cApiModule->get("error");
            
            if ($sModuleError == "none")
            {
               $colName = $sName;
            }
            else if ($sModuleError == "input" || $sModuleError == "output")
            {
               $colName = '<font color="#B1AC58">'.$sName.'</font>';
            }
            else
            {
               $colName = '<font color="red">'.$sName.'</font>';
            }
         }

         $iMenu ++;

         $mlist->setTitle($iMenu, $colName);
         if ($perm->have_perm_area_action_item("mod_edit", "mod_edit", $db->f("idmod")) || $perm->have_perm_area_action_item("mod_translate", "mod_translation_save", $cApiModule->get("idmod")))
         {
            $mlist->setLink($iMenu, $link);
         }

         $inUse = $classmodule->moduleInUse($idmod);

         $deletebutton = "";
         
         if ($inUse)
         {
            $inUseString = i18n("In use");
            $mlist->setActions($iMenu, 'inuse', '<a href="javascript:;" rel="' . $idmod . '" class="in_used_mod"><img src="'.$cfg['path']['images'].'exclamation.gif" border="0" title="'.$inUseString.'" alt="'.$inUseString.'"></a>');
            $delDescription = i18n("Module in use, cannot delete");
            
         } else {
                $mlist->setActions($iMenu, 'inuse', '<img src="./images/spacer.gif" border="0" width="16">');
            if ($perm->have_perm_area_action_item("mod", "mod_delete", $cApiModule->get("idmod")))
            {
            $delTitle = i18n("Delete module");
            $delDescr = sprintf(i18n("Do you really want to delete the following module:<br><br>%s<br>"), $sName);

            $deletebutton = '<a title="'.$delTitle.'" href="javascript://" onclick="box.confirm(\''.$delTitle.'\', \''.$delDescr.'\', \'deleteModule('.$idmod.')\')"><img src="'.$cfg['path']['images'].'delete.gif" border="0" title="'.$delTitle.'" alt="'.$delTitle.'"></a>';            
            } else {
               $delDescription = i18n("No permission");   
            }
         }
         
         if ($deletebutton == "")
         {
                //$deletebutton = '<img src="images/spacer.gif" width="16" height="16">';
            $deletebutton = '<img src="'.$cfg['path']['images'].'delete_inact.gif" border="0" title="'.$delDescription.'" alt="'.$delDescription.'">';   
         }
         
         $todo = new TODOLink("idmod", $db->f("idmod"), "Module: $sName", "");
         
         $mlist->setActions($iMenu, "todo", $todo->render());
         $mlist->setActions($iMenu, "delete", $deletebutton);
           
            if ($_GET['idmod'] == $idmod) {
                $mlist->setExtra($iMenu, 'id="marked" ');
            }     
         //$mlist->setImage($iMenu, "images/but_module.gif");
         //$mlist->setImage($iMenu, 'images/spacer.gif', 5);
      }
}

Code: Alles auswählen

SELECT * FROM con_clients WHERE idclient = 1

Code: Alles auswählen

$oClient = new cApiClient(1);