Esempio n. 1
0
/**
 * create_most_viewed_articles_query
 */
function create_most_viewed_articles_query($bean, $order_by, $where, $keywords, $row_offset, $limit, $date_filter, $searchVars, $spec_SearchVars)
{
    $spec_SearchVars['frequency'] = 'Top_10';
    $sql = create_fts_search_list_query($bean->db, $spec_SearchVars, $searchVars, true);
    $sql = str_replace("'Published'", "'Published' AND {$date_filter} ", $sql);
    return $sql;
}
Esempio n. 2
0
function perform_basic_search($srch_str_raw, $focus)
{
    $searchVars = array();
    $spec_SearchVars = array();
    //make sure string does not have html encoding
    $srch_str_raw = from_html($srch_str_raw);
    $srch_str_raw_orig = $srch_str_raw;
    //lets remove defined tags from the search string
    $tagNamesArr = separateTagNames($srch_str_raw);
    if (!empty($tagNamesArr)) {
        $_POST['searchText'] = $tagNamesArr['search_string_raw'];
        $spec_SearchVars['tag_name'] = $tagNamesArr['tag_token_string'];
    }
    if (isset($_POST['canned_search']) and !empty($_POST['canned_search'])) {
        $spec_SearchVars['canned_search'] = $_POST['canned_search'];
    }
    //create array of available search parameters.
    if (isset($_POST['searchText']) and !empty($_POST['searchText'])) {
        $spec_SearchVars['searchText_include'] = from_html($_POST['searchText']);
    }
    $list_query = create_fts_search_list_query($focus->db, $spec_SearchVars, $searchVars);
    if (empty($list_query)) {
        return '';
    }
    return $list_query;
}