tags.php

Go to the documentation of this file.

<?php
function string_to_tag_array($string) {
    if (!is_string($string)) {
        return $string;
    }
    
    $ar = explode(",", $string);
    $ar = array_map('trim', $ar);
    $ar = array_filter($ar, 'is_not_null');
    $ar = array_map('strip_tags', $ar);
    $ar = array_unique($ar);
    return $ar; 
}

function elgg_get_tags(array $options = array()) {
    global $CONFIG;

    $defaults = array(
        'threshold' => 1,
        'tag_names' => array(),
        'limit' => elgg_get_config('default_limit'),

        'types' => ELGG_ENTITIES_ANY_VALUE,
        'subtypes' => ELGG_ENTITIES_ANY_VALUE,
        'type_subtype_pairs' => ELGG_ENTITIES_ANY_VALUE,

        'owner_guids' => ELGG_ENTITIES_ANY_VALUE,
        'container_guids' => ELGG_ENTITIES_ANY_VALUE,
        'site_guids' => $CONFIG->site_guid,

        'modified_time_lower' => ELGG_ENTITIES_ANY_VALUE,
        'modified_time_upper' => ELGG_ENTITIES_ANY_VALUE,
        'created_time_lower' => ELGG_ENTITIES_ANY_VALUE,
        'created_time_upper' => ELGG_ENTITIES_ANY_VALUE,

        'joins' => array(),
        'wheres' => array(),
    );


    $options = array_merge($defaults, $options);

    $singulars = array('type', 'subtype', 'owner_guid', 'container_guid', 'site_guid', 'tag_name');
    $options = _elgg_normalize_plural_options_array($options, $singulars);

    $registered_tags = elgg_get_registered_tag_metadata_names();

    if (!is_array($options['tag_names'])) {
        return false;
    }

    // empty array so use all registered tag names
    if (count($options['tag_names']) == 0) {
        $options['tag_names'] = $registered_tags;
    }

    $wheres = $options['wheres'];

    // catch for tags that were spaces
    $wheres[] = "msv.string != ''";

    $sanitised_tags = array();
    foreach ($options['tag_names'] as $tag) {
        $sanitised_tags[] = '"' . sanitise_string($tag) . '"';
    }
    $tags_in = implode(',', $sanitised_tags);
    $wheres[] = "(msn.string IN ($tags_in))";

    $wheres[] = _elgg_services()->entityTable->getEntityTypeSubtypeWhereSql('e', $options['types'],
        $options['subtypes'], $options['type_subtype_pairs']);
    $wheres[] = _elgg_get_guid_based_where_sql('e.site_guid', $options['site_guids']);
    $wheres[] = _elgg_get_guid_based_where_sql('e.owner_guid', $options['owner_guids']);
    $wheres[] = _elgg_get_guid_based_where_sql('e.container_guid', $options['container_guids']);
    $wheres[] = _elgg_get_entity_time_where_sql('e', $options['created_time_upper'],
        $options['created_time_lower'], $options['modified_time_upper'], $options['modified_time_lower']);

    // see if any functions failed
    // remove empty strings on successful functions
    foreach ($wheres as $i => $where) {
        if ($where === false) {
            return false;
        } elseif (empty($where)) {
            unset($wheres[$i]);
        }
    }

    // remove identical where clauses
    $wheres = array_unique($wheres);

    $joins = $options['joins'];

    $joins[] = "JOIN {$CONFIG->dbprefix}metadata md on md.entity_guid = e.guid";
    $joins[] = "JOIN {$CONFIG->dbprefix}metastrings msv on msv.id = md.value_id";
    $joins[] = "JOIN {$CONFIG->dbprefix}metastrings msn on md.name_id = msn.id";

    // remove identical join clauses
    $joins = array_unique($joins);

    foreach ($joins as $i => $join) {
        if ($join === false) {
            return false;
        } elseif (empty($join)) {
            unset($joins[$i]);
        }
    }


    $query  = "SELECT msv.string as tag, count(msv.id) as total ";
    $query .= "FROM {$CONFIG->dbprefix}entities e ";

    // add joins
    foreach ($joins as $j) {
        $query .= " $j ";
    }

    // add wheres
    $query .= ' WHERE ';

    foreach ($wheres as $w) {
        $query .= " $w AND ";
    }

    // Add access controls
    $query .= _elgg_get_access_where_sql();

    $threshold = sanitise_int($options['threshold']);
    $query .= " GROUP BY msv.string HAVING total >= {$threshold} ";
    $query .= " ORDER BY total DESC ";

    $limit = sanitise_int($options['limit']);
    $query .= " LIMIT {$limit} ";

    return get_data($query);
}

function elgg_register_tag_metadata_name($name) {
    if (!isset($GLOBALS['_ELGG']->registered_tag_metadata_names)) {
        $GLOBALS['_ELGG']->registered_tag_metadata_names = array();
    }

    if (!in_array($name, $GLOBALS['_ELGG']->registered_tag_metadata_names)) {
        $GLOBALS['_ELGG']->registered_tag_metadata_names[] = $name;
    }

    return true;
}

function elgg_get_registered_tag_metadata_names() {
    $names = (isset($GLOBALS['_ELGG']->registered_tag_metadata_names)) ? $GLOBALS['_ELGG']->registered_tag_metadata_names : array();

    return $names;
}

function _elgg_tags_init() {
    // register the standard tags metadata name
    elgg_register_tag_metadata_name('tags');
}

return function(\Elgg\EventsService $events, \Elgg\HooksRegistrationService $hooks) {
    $events->registerHandler('init', 'system', '_elgg_tags_init');
};