public static function get_db_name($source)
{
$dbObj = new dbAPI();
if ($source == 'content' || $source == "CMSdb") {
return $dbObj->db_get_contentDB();
} else {
return $dbObj->db_get_usersDB();
}
}
public static function get_locking_user($UID, $entity_type)
{
$dbObj = new dbAPI();
$query = "SELECT usr.* FROM " . dbAPI::get_db_name('content') . ".CONTENT_LOCK AS lk INNER JOIN " . dbAPI::get_db_name('user') . ".USERS AS usr ON (usr.UID = lk.USER_ID) where lk.LOCKED_UID = '" . $UID . "' AND lk.ENTITY_TYPE = '" . $entity_type . "' AND lk.LOCK_STATUS = 'LOCKED' AND lk.ENABLED = 1 ";
$results = $dbObj->db_select_query($dbObj->db_get_contentDB(), $query);
if (count($results) > 0) {
$usr = $results[0];
$usr["PASSWORD"] = '******';
return $usr;
}
return null;
}
public static function get_terms_of_scope($scope_UID, $lang = '')
{
$terms = array();
// extract scope terms relations
$dbObj = new dbAPI();
$query = "SELECT * FROM TERMS where ENABLED = 1 AND ( ID_SCOPE = " . $scope_UID . ")";
$terms_related = $dbObj->db_select_query($dbObj->db_get_contentDB(), $query);
if ($terms_related == null) {
return null;
}
// get terms details
for ($i = 0; $i < count($terms_related); $i++) {
$curr_term = term::get_term_by_UID_with_relations($terms_related[$i]["ID_TERM_STRING"], $lang);
if ($curr_term != null) {
array_push($terms, $curr_term);
}
}
return $terms;
}
/**
* Returns the Delivery's base from content database
* @param {int} $UID The UID of the requested Delivery
* @return {DeliveryBase} the requested Delivery
*/
public static function get_Delivery_by_UID($UID)
{
// returns the Delivery from content database for as read-only
$dbObj = new dbAPI();
$query = "SELECT * FROM DELIVERY_BASE where UID = '" . $UID . "' AND ENABLED = '1'";
$results = $dbObj->db_select_query($dbObj->db_get_contentDB(), $query);
if (count($results) == 0) {
return null;
}
return $results[0];
}
public static function get_scopes_of_term($term_UID, $lang = '')
{
$scopes = array();
// extract scope terms relations
$dbObj = new dbAPI();
$query = "SELECT * FROM TERMS where ENABLED = 1 AND ( ID_TERM_STRING = " . $term_UID . ")";
$scopes_related = $dbObj->db_select_query($dbObj->db_get_contentDB(), $query);
if ($scopes_related == null) {
return null;
}
// get scopes and meanings details
for ($i = 0; $i < count($scopes_related); $i++) {
$curr_scope = scope::get_scope_by_UID($scopes_related[$i]["ID_SCOPE"], $lang);
$curr_meaning = term::get_term_meaning_by_UID($scopes_related[$i]["ID_TERM_MEAN"], $lang);
if ($curr_scope != null) {
array_push($scopes, array('scope' => $curr_scope, 'meaning' => $curr_meaning));
}
}
return $scopes;
}
