aboutsummaryrefslogtreecommitdiff
path: root/engine
diff options
context:
space:
mode:
Diffstat (limited to 'engine')
-rw-r--r--engine/lib/annotations.php92
-rw-r--r--engine/lib/sites.php24
2 files changed, 96 insertions, 20 deletions
diff --git a/engine/lib/annotations.php b/engine/lib/annotations.php
index 4c1d15cb0..3a950568f 100644
--- a/engine/lib/annotations.php
+++ b/engine/lib/annotations.php
@@ -326,6 +326,98 @@
}
/**
+ * Return the sum of a given integer annotation.
+ *
+ * @param $object_id int
+ * @param $object_type string
+ * @param $name string
+ */
+ function get_annotations_sum($object_id, $object_type, $name)
+ {
+ global $CONFIG;
+
+ $object_id = (int)$object_id;
+ $object_type = sanitise_string($object_type);
+ $name = santitise_string($name);
+
+ $row = get_data_row("SELECT sum(value) as sum from {$CONFIG->dbprefix}annotations where object_id=$object_id and object_type='$object_type' and value_type='integer' and name='$name' and (access_id in {$access} or (access_id = 0 and owner_id = {$_SESSION['id']}))");
+
+ if ($row)
+ return $row->sum;
+
+ return false;
+ }
+
+ /**
+ * Return the max of a given integer annotation.
+ *
+ * @param $object_id int
+ * @param $object_type string
+ * @param $name string
+ */
+ function get_annotations_max($object_id, $object_type, $name)
+ {
+ global $CONFIG;
+
+ $object_id = (int)$object_id;
+ $object_type = sanitise_string($object_type);
+ $name = santitise_string($name);
+
+ $row = get_data_row("SELECT max(value) as max from {$CONFIG->dbprefix}annotations where object_id=$object_id and object_type='$object_type' and value_type='integer' and name='$name' and (access_id in {$access} or (access_id = 0 and owner_id = {$_SESSION['id']}))");
+
+ if ($row)
+ return $row->max;
+
+ return false;
+ }
+
+ /**
+ * Return the minumum of a given integer annotation.
+ *
+ * @param $object_id int
+ * @param $object_type string
+ * @param $name string
+ */
+ function get_annotations_min($object_id, $object_type, $name)
+ {
+ global $CONFIG;
+
+ $object_id = (int)$object_id;
+ $object_type = sanitise_string($object_type);
+ $name = santitise_string($name);
+
+ $row = get_data_row("SELECT min(value) as min from {$CONFIG->dbprefix}annotations where object_id=$object_id and object_type='$object_type' and value_type='integer' and name='$name' and (access_id in {$access} or (access_id = 0 and owner_id = {$_SESSION['id']}))");
+
+ if ($row)
+ return $row->min;
+
+ return false;
+ }
+
+ /**
+ * Return the average of a given integer annotation.
+ *
+ * @param $object_id int
+ * @param $object_type string
+ * @param $name string
+ */
+ function get_annotations_avg($object_id, $object_type, $name)
+ {
+ global $CONFIG;
+
+ $object_id = (int)$object_id;
+ $object_type = sanitise_string($object_type);
+ $name = santitise_string($name);
+
+ $row = get_data_row("SELECT avg(value) as avg from {$CONFIG->dbprefix}annotations where object_id=$object_id and object_type='$object_type' and value_type='integer' and name='$name' and (access_id in {$access} or (access_id = 0 and owner_id = {$_SESSION['id']}))");
+
+ if ($row)
+ return $row->avg;
+
+ return false;
+ }
+
+ /**
* Delete a given annotation.
*
* @param $id int The id
diff --git a/engine/lib/sites.php b/engine/lib/sites.php
index e8c17b34c..546ef9161 100644
--- a/engine/lib/sites.php
+++ b/engine/lib/sites.php
@@ -517,11 +517,7 @@
* @param string $name
* @param int $site_id
*/
- function get_site_annotations_avg($name, $site_id)
- {
- // TODO : Writeme
- throw new NotImplementedException("Writeme!");
- }
+ function get_site_annotations_avg($name, $site_id) { return get_annotations_avg($object_id, $object_type, $name); }
/**
* Get the sum of integer type annotations of a given type.
@@ -529,11 +525,7 @@
* @param string $name
* @param int $site_id
*/
- function get_site_annotations_sum($name, $site_id)
- {
- // TODO : Writeme
- throw new NotImplementedException("Writeme!");
- }
+ function get_site_annotations_sum($name, $site_id) { return get_annotations_sum($object_id, $object_type, $name); }
/**
* Get the min of integer type annotations of a given type.
@@ -541,11 +533,7 @@
* @param string $name
* @param int $site_id
*/
- function get_site_annotations_min($name, $site_id)
- {
- // TODO : Writeme
- throw new NotImplementedException("Writeme!");
- }
+ function get_site_annotations_min($name, $site_id) { return get_annotations_min($object_id, $object_type, $name); }
/**
* Get the max of integer type annotations of a given type.
@@ -553,11 +541,7 @@
* @param string $name
* @param int $site_id
*/
- function get_site_annotations_max($name, $site_id)
- {
- // TODO : Writeme
- throw new NotImplementedException("Writeme!");
- }
+ function get_site_annotations_max($name, $site_id) { return get_annotations_max($object_id, $object_type, $name); }
/**
* Remove all site annotations, or site annotations of a given type.