function getloginRedirect($msc_id)
{
$db = oseDB::instance();
oseDB::lock('#__menu');
$objs = array();
$where = array();
//$where = array_merge($where,oseJSON::generateQueryWhere());
// Added in V 4.4, menu access levels
//$where[] = 'm.menutype = '.$db->Quote($menutype);
$where[] = 'm.published != -2';
$where[] = 'm.client_id = 0';
$where = count($where) ? ' WHERE (' . implode(') AND (', $where) . ')' : '';
$query = 'SELECT m.*, com.name AS com_name' . ' FROM `#__menu` AS m' . ' LEFT JOIN `#__extensions` AS com ON com.extension_id = m.component_id' . $where . ' ORDER BY m.lft';
$db->setQuery($query);
//oseExit($db->getQuery());
$menus = $db->loadObjectList();
$i = 0;
if (!empty($menus)) {
foreach ($menus as $menu) {
$objs[$i]->menuid = $menu->id;
$objs[$i]->displayText = str_repeat('<span class="gtr">|—</span>', $menu->level) . '[ID-' . $menu->id . ']-' . $menu->title;
$i++;
}
}
oseDB::unlock();
return $objs;
}
function getProperty($msc_id)
{
$db = oseDB::instance();
oseDB::lock('#__osemsc_acl READ');
$query = " SELECT * FROM `#__osemsc_acl`" . " WHERE id = {$msc_id}";
$db->setQuery($query);
$item = oseDB::loadItem();
oseDB::unlock();
return $item;
}
public static function orderChange($node, $ordering)
{
$db = oseDB::instance();
$current = $node;
$type = $db->Quote($current->type);
oseDB::lock('#__osemsc_addon');
$query = " SELECT * FROM `#__osemsc_addon`" . " WHERE type={$type} AND ordering= {$ordering} ";
$db->setQuery($query);
// get the Current Msc paranet ID
$obj = $db->loadObject();
if ($current->ordering > $ordering) {
$query = " UPDATE `#__osemsc_addon` " . " SET ordering= ordering+1 " . " WHERE ordering >= {$ordering} AND ordering < {$current->ordering} " . " AND type={$type}";
$db->setQuery($query);
if (!oseDB::query()) {
oseDB::unlock();
return false;
}
$query = " UPDATE `#__osemsc_addon` " . " SET ordering= {$ordering} " . " WHERE id = {$current->id} ";
$db->setQuery($query);
if (!oseDB::query()) {
oseDB::unlock();
return false;
}
} else {
$query = " UPDATE `#__osemsc_addon` " . " SET ordering= ordering-1 " . " WHERE ordering <= {$ordering} AND ordering > {$current->ordering} " . " AND type={$type}";
$db->setQuery($query);
if (!oseDB::query()) {
oseDB::unlock();
return false;
}
$query = " UPDATE `#__osemsc_addon` " . " SET ordering= {$ordering} " . " WHERE id = {$current->id} ";
$db->setQuery($query);
if (!oseDB::query()) {
oseDB::unlock();
return false;
}
}
oseDB::unlock();
return true;
}
public static function query($unlock = false)
{
$testMode = 1;
$db = oseDB::instance();
if (!$db->query()) {
if ($testMode == 1) {
oseExit($db->getErrorMsg());
}
if ($unlock) {
oseDB::unlock();
}
return false;
}
return true;
}
public static function getNodeByOrder($parent_id, $ordering, $type = 'array')
{
$db = oseDB::instance();
oseDB::lock('#__osemsc_acl READ');
$query = " SELECT * FROM `#__osemsc_acl`" . " WHERE parent_id = {$parent_id} AND ordering = {$ordering} ";
$db->setQuery($query);
$obj = oseDB::loadItem($type);
oseDB::unlock();
return $obj;
}
function retrieveTree($type = 'array')
{
$db = oseDB::instance();
//$searchName = $db->Quote($msc_id);
$query = "LOCK TABLE `#__osemsc_acl` AS node READ, `#__osemsc_acl` AS parent READ";
$db->setQuery($query);
oseDB::query();
$where = array();
$where[] = 'node.lft BETWEEN parent.lft AND parent.rgt';
$where = oseDB::implodeWhere($where);
$query = " SELECT node.*,CONCAT( REPEAT('--', COUNT(parent.id)-1), node.title) AS treename\n " . " FROM `#__osemsc_acl` AS node,`#__osemsc_acl` AS parent" . $where . " GROUP BY node.id " . " ORDER BY node.lft; ";
$db->setQuery($query);
//oseExit($db->_sql);
$objs = oseDB::loadList($type);
oseDB::unlock();
//oseExit($objs);
return $objs;
//return oseMscTree::retrieveTree($msc_id,$type);
}
