Пример #1
0
function getAllVotingForUser($userid, $direction, $sort, $oldsort)
{
    global $DB, $CFG, $HUB_SQL;
    $params = array();
    $params[0] = $userid;
    $allNodeVotes = array();
    if ($direction) {
        if ($oldsort === $sort) {
            if ($direction === 'ASC') {
                $direction = "DESC";
            } else {
                $direction = "ASC";
            }
        } else {
            $direction = "DESC";
        }
    } else {
        $direction = "DESC";
    }
    $allNodeVotes = array();
    $sql = $HUB_SQL->STATSLIB_USER_ALL_VOTING;
    if ($sort != 'Name' && $sort != "NodeType") {
        $sql .= $HUB_SQL->STATSLIB_ALL_VOTING_ORDER_BY . $sort . " " . $direction;
    }
    $ns = new NodeSet();
    $ns->loadNodesWithExtras($sql, $params, 'short');
    // These properties had to be taken out of the original sql call
    // as Virtuoso complained about a long data type error
    // Do now data called as separate Nodes and these sorts are done afterwards.
    if ($sort === "Name") {
        if ($direction === "ASC") {
            usort($ns->nodes, 'nameSortASC');
        } else {
            usort($ns->nodes, 'nameSortDESC');
        }
    } else {
        if ($sort === "NodeType") {
            if ($direction === "ASC") {
                usort($ns->nodes, 'roleTextSortASC');
            } else {
                usort($ns->nodes, 'roleTextSortDESC');
            }
        }
    }
    return $ns;
}
Пример #2
0
/**
 * Fetch a node list of lemons used against the given issue for the current user.
 * @param $issueid the id of the issue to get the lemons for.
 * @returns NodeSet or Error
 */
function getMyLemonsForIssue($issueid)
{
    global $USER, $HUB_SQL;
    $params = array();
    $params[0] = $USER->userid;
    $params[1] = $issueid;
    $ns = new NodeSet();
    return $ns->loadNodesWithExtras($HUB_SQL->DATAMODEL_UTIL_USER_LEMONS_FOR_ISSUE, $params);
}