Esempio n. 1
0
function fn_search($params, $items_per_page = 0, $lang_code = CART_LANGUAGE)
{
    $data = array();
    $search = fn_get_search_objects();
    $pieces = array();
    $search_type = '';
    $default_params = array('page' => 1, 'items_per_page' => $items_per_page, 'objects' => array());
    $params = array_merge($default_params, $params);
    foreach ($search['conditions']['functions'] as $object => $function) {
        if (in_array($object, $search['default'])) {
            continue;
        }
        if (!in_array($object, $params['objects'])) {
            unset($search['conditions']['functions'][$object]);
        }
    }
    if (empty($params['q'])) {
        $params['q'] = '';
    }
    if (empty($params['match'])) {
        $params['match'] = 'any';
    }
    $params['search_string'] = $params['q'];
    foreach ($search['conditions']['functions'] as $object => $function) {
        if (!empty($function) && is_callable($function)) {
            $_params = $params;
            if (!empty($search['default_params'][$object])) {
                $_params = fn_array_merge($_params, $search['default_params'][$object]);
            }
            $search['conditions']['values'][$object] = call_user_func($function, $_params, $lang_code);
            $search['action_links'][$object] = str_replace('%search%', urlencode($params['q']), $search['action_links'][$object]);
        }
    }
    fn_set_hook('search_by_objects', $search['conditions']['values'], $params);
    if (count($search['conditions']['values']) == 1 && (!empty($params['compact']) && $params['compact'] == 'Y')) {
        list($object) = each($search['conditions']['values']);
        return fn_search_simple($params, $search, $object, $items_per_page, $lang_code);
    } elseif (count($search['conditions']['values'])) {
        db_query("CREATE TEMPORARY TABLE _search (id int NOT NULL, object varchar(30) NOT NULL, sort_field varchar(255) NOT NULL)ENGINE=HEAP;");
        foreach ($search['conditions']['values'] as $object => $entry) {
            $entry['table'] = !empty($entry['table']) ? $entry['table'] : "?:" . $object;
            $select = db_quote("SELECT {$entry['table']}.{$entry['key']}, '{$object}', {$entry['sort']} FROM ?:{$object} as {$entry['table']} {$entry['join']} WHERE {$entry['condition']} GROUP BY {$entry['table']}.{$entry['key']}");
            db_query("INSERT INTO _search (id, object, sort_field) ?p", $select);
        }
        if (!empty($params['items_per_page'])) {
            $params['total_items'] = db_get_field('SELECT COUNT(id) FROM _search');
            $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
            if (preg_match("/\\s+(\\d+),/", $limit, $begin)) {
                $begin = intval($begin[1]);
            } else {
                $begin = 0;
            }
        } else {
            $limit = '';
            $begin = 0;
        }
        $objects_count = db_get_hash_array('SELECT COUNT(*) as count, object, id FROM _search GROUP BY object', 'object');
        if (!empty($params['compact']) && ($params['compact'] = 'Y')) {
            return array($objects_count, $search);
        }
        $results = db_get_array('SELECT id, object FROM _search ORDER BY sort_field ' . $limit, 'id');
        if ($results) {
            $ids = array();
            foreach ($results as $id => $entry) {
                $ids[$entry['object']][] = $entry['id'];
            }
            $_data = array();
            foreach ($search['conditions']['values'] as $object => $entry) {
                if (empty($ids[$object]) || !count($ids[$object])) {
                    continue;
                }
                $entry['table'] = !empty($entry['table']) ? $entry['table'] : "?:" . $object;
                $_data[$object] = db_get_hash_array("SELECT " . implode(', ', $entry['fields']) . " FROM ?:{$object} as {$entry['table']} {$entry['join']} WHERE {$entry['condition']} AND {$entry['table']}.{$entry['key']} IN ('" . join("', '", $ids[$object]) . "') GROUP BY {$entry['table']}.{$entry['key']}", $entry['key']);
            }
            $num = 0;
            foreach ($_data as $object => &$__data) {
                if (!empty($search['bulk_data'][$object])) {
                    $search['bulk_data'][$object]($__data);
                }
            }
            foreach ($results as $key => $entry) {
                $data[$num] = $_data[$entry['object']][$entry['id']];
                $data[$num]['object'] = $entry['object'];
                if (!empty($search['more_data'][$entry['object']])) {
                    $search['more_data'][$entry['object']]($data[$num]);
                }
                $data[$num]['result_number'] = $begin + $num + 1;
                if (count($search['conditions']['values']) == 1) {
                    $data[$num]['result_type'] = 'full';
                } else {
                    $data[$num]['result_type'] = 'short';
                }
                $num++;
            }
            $data[0]['first'] = true;
            unset($_data);
            if (empty($params['total_items'])) {
                $params['total_items'] = count($data);
            }
        }
    }
    return array($data, $params);
}
Esempio n. 2
0
function fn_search($params, $items_per_page = 0, $lang_code = CART_LANGUAGE)
{
    $data = array();
    $search = Registry::get('search_object');
    $pieces = array();
    $search_type = '';
    if (empty($params['objects'])) {
        $params['objects'] = array();
    }
    if (empty($params['page'])) {
        $params['page'] = 1;
    }
    foreach ($search['conditions']['functions'] as $object => $function) {
        if ($search['default'] == $object) {
            continue;
        }
        if (!in_array($object, $params['objects'])) {
            unset($search['conditions']['functions'][$object]);
        }
    }
    if (empty($params['q'])) {
        $params['q'] = '';
    }
    if (empty($params['match'])) {
        $params['match'] = 'any';
    }
    $params['search_string'] = $params['q'];
    foreach ($search['conditions']['functions'] as $object => $function) {
        if (!empty($function) && function_exists($function)) {
            $_params = $params;
            if (!empty($search['default_params'][$object])) {
                $_params = fn_array_merge($_params, $search['default_params'][$object]);
            }
            $search['conditions']['values'][$object] = $function($_params, $lang_code);
        }
    }
    fn_set_hook('search_by_objects', $search['conditions']['values']);
    if (count($search['conditions']['values']) == 1) {
        list($object) = each($search['conditions']['values']);
        return fn_search_simple($params, $search, $object, $items_per_page, $lang_code);
    } elseif (count($search['conditions']['values'])) {
        db_query("CREATE TEMPORARY TABLE _search (id int NOT NULL, object varchar(30) NOT NULL, sort_field varchar(255) NOT NULL)ENGINE=HEAP;");
        foreach ($search['conditions']['values'] as $object => $entry) {
            $entry['table'] = !empty($entry['table']) ? $entry['table'] : "?:" . $object;
            $select = db_quote("SELECT {$entry['table']}.{$entry['key']}, '{$object}', {$entry['sort']} FROM ?:{$object} as {$entry['table']} {$entry['join']} WHERE {$entry['condition']} GROUP BY {$entry['table']}.{$entry['key']}");
            if (AREA == 'A' && Registry::is_exist('revisions')) {
                fn_revisions_process_select($select);
            }
            db_query("INSERT INTO _search (id, object, sort_field) ?p", $select);
        }
        if ($items_per_page) {
            $total = db_get_field('SELECT COUNT(id) FROM _search');
            $limit = fn_paginate($params['page'], $total, $items_per_page);
            if (preg_match("/\\s+(\\d+),/", $limit, $begin)) {
                $begin = intval($begin[1]);
            } else {
                $begin = 0;
            }
        } else {
            $limit = '';
            $total = 0;
            $begin = 0;
        }
        $results = db_get_array('SELECT id, object FROM _search ORDER BY sort_field ' . $limit, 'id');
        if ($results) {
            $ids = array();
            foreach ($results as $id => $entry) {
                $ids[$entry['object']][] = $entry['id'];
            }
            $_data = array();
            foreach ($search['conditions']['values'] as $object => $entry) {
                if (empty($ids[$object]) || !count($ids[$object])) {
                    continue;
                }
                $entry['table'] = !empty($entry['table']) ? $entry['table'] : "?:" . $object;
                $_data[$object] = db_get_hash_array("SELECT " . implode(', ', $entry['fields']) . " FROM ?:{$object} as {$entry['table']} {$entry['join']} WHERE {$entry['condition']} AND {$entry['table']}.{$entry['key']} IN ('" . join("', '", $ids[$object]) . "') GROUP BY {$entry['table']}.{$entry['key']}", $entry['key']);
            }
            $num = 0;
            foreach ($results as $key => $entry) {
                $data[$num] = $_data[$entry['object']][$entry['id']];
                $data[$num]['object'] = $entry['object'];
                if (!empty($search['more_data'][$entry['object']])) {
                    $search['more_data'][$entry['object']]($data[$num]);
                }
                $data[$num]['result_number'] = $begin + $num + 1;
                if (count($_data) == 1) {
                    $data[$num]['result_type'] = 'full';
                } else {
                    $data[$num]['result_type'] = 'short';
                }
                $num++;
            }
            $data[0]['first'] = true;
            unset($_data);
            if (!$total) {
                $total = count($data);
            }
        }
    }
    return array($data, $params, $total);
}