* @license http://www.contenido.org/license/LIZENZ.txt * @link http://www.4fb.de * @link http://www.contenido.org * * {@internal * created 2003-05-20 * modified 2010-05-20, Murat Purc, removed request check during processing ticket [#CON-307] * * $Id: include.workflow_subnav.php 128 2019-07-03 11:58:28Z oldperl $ * }} * */ if (!defined('CON_FRAMEWORK')) { die('Illegal call'); } $nav = new Contenido_Navigation; $parentarea = getParentAreaID($area); $sql = "SELECT idarea FROM " . $cfg["tab"]["area"] . " AS a WHERE a.name = '" . Contenido_Security::escapeDB($parentarea, $db) . "' OR a.parent_id = '" . Contenido_Security::escapeDB($parentarea, $db) . "' ORDER BY idarea"; $db->query($sql); $in_str = ""; while ($db->next_record()) { $in_str .= $db->f('idarea') . ','; } $len = strlen($in_str) - 1; $in_str = substr($in_str, 0, $len); $in_str = '(' . $in_str . ')'; $sql = "SELECT b.location AS location, a.name AS name FROM " . $cfg["tab"]["area"] . " AS a, " . $cfg["tab"]["nav_sub"] . " AS b WHERE b.idarea IN " . Contenido_Security::escapeDB($in_str, $db) . " AND b.idarea = a.idarea AND b.level = 1 ORDER BY b.idnavs"; $db->query($sql); while ($db->next_record()) { # Extract caption from # the xml language file $caption = $nav->getName($db->f("location")); $tmp_area = $db->f("name"); # Set template data $tpl->set("d", "ID", 'c_' . $tpl->dyn_cnt); $tpl->set("d", "CLASS", ''); $tpl->set("d", "OPTIONS", ''); $tpl->set("d", "CAPTION", '' . $caption . ''); if ($area == $tmp_area) { $tpl->set('s', 'DEFAULT', markSubMenuItem($tpl->dyn_cnt, true)); } $tpl->next(); } $tpl->set('s', 'COLSPAN', ($tpl->dyn_cnt * 2) + 2); $tpl->set('s', 'IDCAT', $idcat); $tpl->set('s', 'SESSID', $sess->id); $tpl->set('s', 'CLIENT', $client); $tpl->set('s', 'LANG', $lang); # Generate the third # navigation layer if ($idworkflow <= 0) { $tpl->generate($cfg["path"]["templates"] . $cfg["templates"]["subnav_blank"]); } else { $tpl->generate($cfg["path"]["templates"] . $cfg["templates"]["subnav"]); }