Add agent function getPads_ordByOwnByName()

1 files changed, 30 insertions, 0 deletions

diff --git a/app/class/agent.class.php b/app/class/agent.class.php
index 038c485..a2c8c2e 100644
--- a/app/class/agent.class.php
+++ b/app/class/agent.class.php
@@ -13,6 +13,7 @@
  */
 
 require_once "class/object.class.php";
+require_once "class/pad.class.php";
 
 /*
  * This is a supertype for users and groups, since these two object types
@@ -69,6 +70,35 @@ abstract class agent extends object
     }
 
     /*
+     * Get all pads this agent owns or is a member of.  This isn't
+     * necessarily all pads this agent has access permission for.
+     * Results are sorted by ownership, then by name.
+     */
+    public function getPads_ordByOwnByName() : array
+    {
+        $pads = array();
+
+        /* owner */
+        $query = "SELECT guid FROM objects WHERE objtype = 'pad' AND " .
+            "owner = '" . database::esc($this->guid) . "' ORDER BY name";
+        $res = database::query($query);
+
+        foreach ($res as $p)
+            $pads[] = new pad($p['guid']);
+
+        /* members */
+        $query = "SELECT o.guid FROM objects o JOIN members m ON " .
+            "o.guid = m.guid WHERE o.objtype = 'pad' AND " .
+            "m.member = '" . database::esc($this->guid) . "' ORDER BY o.name";
+        $res = database::query($query);
+
+        foreach ($res as $p)
+            $pads[] = new pad($p['guid']);
+
+        return $pads;
+    }
+
+    /*
      * Check whether this agent has access permission for given
      * object
      */