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