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); }