Ubilling/api/libs/api.corporate.php

<?php

/**
 * Corporate users API
 */

/**
 * Returns array of all linked users
 * 
 * @return array
 */
function cu_GetAllLinkedUsers() {
    global $ubillingConfig;
    $linkcfid = $ubillingConfig->getAlterParam('USER_LINKING_CFID');
    $query = "SELECT `login`,`content` from `cfitems` WHERE `typeid`='" . $linkcfid . "' AND `content` !=''";
    $allusers = simple_queryall($query);
    $result = array();
    if (!empty($allusers)) {
        foreach ($allusers as $io => $eachuser) {
            $result[$eachuser['login']] = $eachuser['content'];
        }
    }
    return ($result);
}

/**
 * Returns parent user login by linking param
 * 
 * @param string $param
 * @return string
 */
function cu_GetParentUserLogin($param) {
    global $ubillingConfig;
    $linkfield = $ubillingConfig->getAlterParam('USER_LINKING_FIELD');
    $param = mysql_real_escape_string($param);
    $query = "SELECT `login` from `users` WHERE `" . $linkfield . "`='" . $param . "'";
    $result = simple_query($query);
    if (!empty($result)) {
        $result = $result['login'];
    }
    return ($result);
}

/**
 * Returns all child users 
 * 
 * @param string $param
 * @return array
 */
function cu_GetAllChildUsers($param) {
    global $ubillingConfig;
    $linkcfid = $ubillingConfig->getAlterParam('USER_LINKING_CFID');
    $param = mysql_real_escape_string($param);
    $query = "SELECT `login` from `cfitems` WHERE `typeid`='" . $linkcfid . "' AND `content`='" . $param . "' ";
    $result = array();
    $alllinks = simple_queryall($query);
    if (!empty($alllinks)) {
        foreach ($alllinks as $io => $eachlink) {
            $result[] = $eachlink['login'];
        }
    }
    return ($result);
}

/**
 * Returns array of all parent users
 * 
 * @return array
 */
function cu_GetAllParentUsers() {
    global $ubillingConfig;
    $linkfield = $ubillingConfig->getAlterParam('USER_LINKING_FIELD');
    $linkcfid = $ubillingConfig->getAlterParam('USER_LINKING_CFID');
    $result = array();
    $query_cfs = "SELECT DISTINCT `content` FROM `cfitems` WHERE `typeid`='" . $linkcfid . "' AND `content` <> ''";
    $allcfs = simple_queryall($query_cfs);
    if (!empty($allcfs)) {
        foreach ($allcfs as $io => $eachcf) {
            $query_user = "SELECT `login` from `users` WHERE `" . $linkfield . "`='" . $eachcf['content'] . "' ";
            $userlogin = simple_query($query_user);
            if (!empty($userlogin) AND ! empty($eachcf['content'])) {
                $result[$userlogin['login']] = $eachcf['content'];
            }
        }
    }
    return ($result);
}

/**
 * Checks is some user child of another?
 * 
 * @param string $login
 * @return bool
 */
function cu_IsChild($login) {
    $login = mysql_real_escape_string($login);
    $allchilds = cu_GetAllLinkedUsers();
    if (isset($allchilds[$login])) {
        return (true);
    } else {
        return (false);
    }
}

/**
 * Checks is some user parent for another one?
 * 
 * @param string $login
 * @return bool
 */
function cu_IsParent($login) {
    $login = mysql_real_escape_string($login);
    $allparents = cu_GetAllParentUsers();
    if (isset($allparents[$login])) {
        return (true);
    } else {
        return (false);
    }
}

?>