Пример #1
0
$search_str = ' kbdocuments.deleted =0';
//if node id is untagged, then create query for all untagged articles
if ($n_id == 'UNTAGGED_NODE_ID') {
    $search_str .= " and kbdocuments.id NOT IN\n                                (select kbdocument_id from kbdocuments_kbtags where deleted = 0)";
} else {
    //create query for articles under this tag
    $search_str .= " and kbdocuments.id\n                        IN (\n                            SELECT kbd.id\n                            FROM kbdocuments kbd, kbdocuments_kbtags kbd_kt\n                            WHERE kbd.id = kbd_kt.kbdocument_id\n                            AND kbd.deleted = 0\n                            AND kbd_kt.deleted = 0\n                            AND kbd_kt.kbtag_id = '{$n_id}'\n                        )";
}
//check to see if sortCol has been specified
if (isset($_REQUEST['sortCol']) && !empty($_REQUEST['sortCol'])) {
    //if sorcol has been set to PAGINATE, then this is a pagination and requires
    //reversing the sort order so listview data can process correctly
    if ($_REQUEST['sortCol'] == 'PAGINATE') {
        if (isset($lvso) && !empty($lvso)) {
            $lvso = strcmp(strtolower($lvso), 'asc') == 0 ? 'DESC' : 'ASC';
        }
    } else {
        //this is a normal sort column command, override sort order
        //with currently selected column (if this call is from sort event)
        $sortCol = $_REQUEST['sortCol'];
    }
}
//Set Request Object parameter so that Sort order will happen in get_fts_list method
$_REQUEST['KBDocuments2_KBDOCUMENT_ORDER_BY'] = $sortCol;
//if set to 'all tags', pass in query 'where' clause into method that returns list for admins
if (!empty($zero_node) && strtolower($zero_node) == 'all_tags') {
    $results = get_admin_fts_list($search_str, false, true);
} else {
    $results = get_fts_list($search_str, false, true);
}
echo $results;
Пример #2
0
function get_admin_browse_articles($params)
{
    $_REQUEST['module'] = 'KBDocuments';
    if (empty($params['NODES']) || empty($params['TREE'])) {
        //return no documents found message
        echo "There was an error accessing this tag information";
    } else {
        global $odd_bg, $even_bg, $hilite_bg;
        $mod_strings = get_kbtag_strings();
        $colorclass = '';
        $bgColor = $even_bg;
        $depth = $params['TREE']['depth'];
        $tag_id = $params['NODES'][$depth]['id'];
        global $app_strings, $odd_bg, $even_bg, $hilite_bg;
        $colorclass = '';
        $search_str = "kbdocuments.id\n                            IN (\n                                SELECT kbd.id\n                                FROM kbdocuments kbd, kbdocuments_kbtags kbd_kt\n                                WHERE kbd.id = kbd_kt.kbdocument_id\n                                AND kbd_kt.kbtag_id = '{$tag_id}'\n                                AND kbd_kt.deleted = 0\n                                AND kbd.deleted = 0 \n\t\t                       )";
        require_once 'modules/KBDocuments/SearchUtils.php';
        $results = get_admin_fts_list($search_str, true);
        echo $results;
    }
}