aboutsummaryrefslogtreecommitdiff
path: root/engine
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-07-17 09:08:55 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-07-17 09:08:55 +0000
commitd0f3cef69eff311d8eba8b2be0c076399da8ced1 (patch)
treed1c9cbfc4b7ed29e9035357769bdbdd01e3d5e8d /engine
parent68a08f14925e7129cf8302871f8eb70ada822be0 (diff)
downloadelgg-d0f3cef69eff311d8eba8b2be0c076399da8ced1.tar.gz
elgg-d0f3cef69eff311d8eba8b2be0c076399da8ced1.tar.bz2
Introducing list_entities_from_annotations
git-svn-id: https://code.elgg.org/elgg/trunk@1450 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine')
-rw-r--r--engine/lib/annotations.php58
1 files changed, 50 insertions, 8 deletions
diff --git a/engine/lib/annotations.php b/engine/lib/annotations.php
index 2886fda4e..69110f3dc 100644
--- a/engine/lib/annotations.php
+++ b/engine/lib/annotations.php
@@ -341,9 +341,10 @@
* @param int $group_guid Group container. Currently this is only supported if $entity_type == 'object'
* @param int $limit Maximum number of results to return.
* @param int $offset Place to start.
- * @param string $order_by How to order results.
+ * @param string $order_by How to order results.
+ * @param boolean $count Whether to count entities rather than return them
*/
- function get_entities_from_annotations($entity_type = "", $entity_subtype = "", $name = "", $value = "", $owner_guid = 0, $group_guid = 0, $limit = 10, $offset = 0, $order_by = "asc")
+ function get_entities_from_annotations($entity_type = "", $entity_subtype = "", $name = "", $value = "", $owner_guid = 0, $group_guid = 0, $limit = 10, $offset = 0, $order_by = "asc", $count = false)
{
global $CONFIG;
@@ -402,17 +403,58 @@
if ($value != "")
$where[] = "a.value_id='$value'";
-
- $query = "SELECT e.*, n.string as name, v.string as value from {$CONFIG->dbprefix}annotations a JOIN {$CONFIG->dbprefix}entities e on a.entity_guid = e.guid JOIN {$CONFIG->dbprefix}metastrings v on a.value_id=v.id JOIN {$CONFIG->dbprefix}metastrings n on a.name_id = n.id ";
+
+ if ($count) {
+ $query = "count distinct (e.guid) as total ";
+ } else {
+ $query = "SELECT distinct e.*, n.string as name, v.string as value ";
+ }
+ $query .= "from {$CONFIG->dbprefix}annotations a JOIN {$CONFIG->dbprefix}entities e on a.entity_guid = e.guid JOIN {$CONFIG->dbprefix}metastrings v on a.value_id=v.id JOIN {$CONFIG->dbprefix}metastrings n on a.name_id = n.id ";
if (($group_guid != 0) && ($entity_type=='object')) $query .= "JOIN {$CONFIG->dbprefix}objects_entity o on o.guid = e.guid";
$query .= " where";
foreach ($where as $w)
$query .= " $w and ";
- $query .= get_access_sql_suffix("a"); // Add access controls
- $query .= " order by $order_by limit $offset,$limit"; // Add order and limit
-
- return get_data($query, "row_to_elggannotation");
+ $query .= get_access_sql_suffix("a"); // Add access controls
+
+ if ($count) {
+ $row = get_data_row($query);
+ return $row->total;
+ } else {
+ $query .= " order by $order_by limit $offset,$limit"; // Add order and limit
+ return get_data($query, "row_to_elggannotation");
+ }
+ }
+
+ /**
+ * Lists entities
+ *
+ * @see elgg_view_entity_list
+ *
+ * @param string $entity_type Type of entity.
+ * @param string $entity_subtype Subtype of entity.
+ * @param string $name Name of annotation.
+ * @param string $value Value of annotation.
+ * @param int $limit Maximum number of results to return.
+ * @param int $owner_guid Owner.
+ * @param int $group_guid Group container. Currently this is only supported if $entity_type == 'object'
+ * @param boolean $asc Whether to list in ascending or descending order (default: desc)
+ * @param boolean $fullview Whether to display the entities in full
+ * @return string Formatted entity list
+ */
+ function list_entities_from_annotations($entity_type = "", $entity_subtype = "", $name = "", $value = "", $limit = 10, $owner_guid = 0, $group_guid = 0, $asc = false, $fullview = true) {
+
+ if ($asc) {
+ $asc = "asc";
+ } else {
+ $asc = "desc";
+ }
+ $count = get_entities_from_annotations($entity_type, $entity_subtype, $name, $value, $owner_guid, $group_guid, null, null, $asc, true);
+ $offset = (int) get_input("offset",0);
+ $entities = get_entities_from_annotations($entity_type, $entity_subtype, $name, $value, $owner_guid, $group_guid, null, null, $asc);
+
+ return elgg_view_entity_list($entities, $count, $offset, $limit, $fullview);
+
}
/**