3 files changed, 120 insertions, 1 deletions
diff --git a/app/Decorator/ColumnMoveRestrictionCacheDecorator.php b/app/Decorator/ColumnMoveRestrictionCacheDecorator.php
index 2a3e9c2a..82140d16 100644
--- a/app/Decorator/ColumnMoveRestrictionCacheDecorator.php
+++ b/app/Decorator/ColumnMoveRestrictionCacheDecorator.php
@@ -40,7 +40,8 @@ class ColumnMoveRestrictionCacheDecorator
     /**
      * Proxy method to get sortable columns
      *
-     * @param  int $project_id
+     * @param  int    $project_id
+     * @param  string $role
      * @return array|mixed
      */
     public function getSortableColumns($project_id, $role)
diff --git a/app/Decorator/ColumnRestrictionCacheDecorator.php b/app/Decorator/ColumnRestrictionCacheDecorator.php
new file mode 100644
index 00000000..a615030d
--- /dev/null
+++ b/app/Decorator/ColumnRestrictionCacheDecorator.php
@@ -0,0 +1,59 @@
+<?php
+
+namespace Kanboard\Decorator;
+
+use Kanboard\Core\Cache\CacheInterface;
+use Kanboard\Model\ColumnRestrictionModel;
+
+/**
+ * Class ColumnRestrictionCacheDecorator
+ *
+ * @package Kanboard\Decorator
+ * @author  Frederic Guillot
+ */
+class ColumnRestrictionCacheDecorator
+{
+    protected $cachePrefix = 'column_restriction:';
+
+    /**
+     * @var CacheInterface
+     */
+    protected $cache;
+
+    /**
+     * @var ColumnRestrictionModel
+     */
+    protected $columnRestrictionModel;
+
+    /**
+     * ColumnMoveRestrictionDecorator constructor.
+     *
+     * @param CacheInterface             $cache
+     * @param ColumnRestrictionModel     $columnMoveRestrictionModel
+     */
+    public function __construct(CacheInterface $cache, ColumnRestrictionModel $columnMoveRestrictionModel)
+    {
+        $this->cache = $cache;
+        $this->columnRestrictionModel = $columnMoveRestrictionModel;
+    }
+
+    /**
+     * Proxy method to get sortable columns
+     *
+     * @param  int    $project_id
+     * @param  string $role
+     * @return array|mixed
+     */
+    public function getAllByRole($project_id, $role)
+    {
+        $key = $this->cachePrefix.$project_id.$role;
+        $columnRestrictions = $this->cache->get($key);
+
+        if ($columnRestrictions === null) {
+            $columnRestrictions = $this->columnRestrictionModel->getAllByRole($project_id, $role);
+            $this->cache->set($key, $columnRestrictions);
+        }
+
+        return $columnRestrictions;
+    }
+}
diff --git a/app/Decorator/ProjectRoleRestrictionCacheDecorator.php b/app/Decorator/ProjectRoleRestrictionCacheDecorator.php
new file mode 100644
index 00000000..a6e24048
--- /dev/null
+++ b/app/Decorator/ProjectRoleRestrictionCacheDecorator.php
@@ -0,0 +1,59 @@
+<?php
+
+namespace Kanboard\Decorator;
+
+use Kanboard\Core\Cache\CacheInterface;
+use Kanboard\Model\ProjectRoleRestrictionModel;
+
+/**
+ * Class ProjectRoleRestrictionCacheDecorator
+ *
+ * @package Kanboard\Decorator
+ * @author  Frederic Guillot
+ */
+class ProjectRoleRestrictionCacheDecorator
+{
+    protected $cachePrefix = 'project_restriction:';
+
+    /**
+     * @var CacheInterface
+     */
+    protected $cache;
+
+    /**
+     * @var ProjectRoleRestrictionModel
+     */
+    protected $projectRoleRestrictionModel;
+
+    /**
+     * ColumnMoveRestrictionDecorator constructor.
+     *
+     * @param CacheInterface                  $cache
+     * @param ProjectRoleRestrictionModel     $projectRoleRestrictionModel
+     */
+    public function __construct(CacheInterface $cache, ProjectRoleRestrictionModel $projectRoleRestrictionModel)
+    {
+        $this->cache = $cache;
+        $this->projectRoleRestrictionModel = $projectRoleRestrictionModel;
+    }
+
+    /**
+     * Proxy method to get sortable columns
+     *
+     * @param  int    $project_id
+     * @param  string $role
+     * @return array|mixed
+     */
+    public function getAllByRole($project_id, $role)
+    {
+        $key = $this->cachePrefix.$project_id.$role;
+        $projectRestrictions = $this->cache->get($key);
+
+        if ($projectRestrictions === null) {
+            $projectRestrictions = $this->projectRoleRestrictionModel->getAllByRole($project_id, $role);
+            $this->cache->set($key, $projectRestrictions);
+        }
+
+        return $projectRestrictions;
+    }
+}