1 files changed, 89 insertions, 0 deletions
diff --git a/plugins/Group_assign/Model/GroupAssignCalendarModel.php b/plugins/Group_assign/Model/GroupAssignCalendarModel.php
new file mode 100644
index 00000000..5b45ca09
--- /dev/null
+++ b/plugins/Group_assign/Model/GroupAssignCalendarModel.php
@@ -0,0 +1,89 @@
+<?php
+
+namespace Kanboard\Plugin\Group_assign\Model;
+
+use DateTime;
+use Kanboard\Model\GroupMemberModel;
+use Kanboard\Plugin\Group_assign\Model\MultiselectMemberModel;
+use Kanboard\Model\TimezoneModel;
+use Kanboard\Model\TaskFinderModel;
+use Kanboard\Model\ColorModel;
+use Kanboard\Core\Base;
+
+/**
+ * Group_assign Calendar Model
+ *
+ * @package  Kanboard\Plugin\Group_assign
+ * @author   Craig Crosby
+ */
+class GroupAssignCalendarModel extends Base
+{
+    /**
+     * SQL table name
+     *
+     * @var string
+     */
+    const TABLE = 'tasks';
+    /**
+     * Get query to fetch all users
+     *
+     * @access public
+     * @param  integer $group_id
+     * @return \PicoDb\Table
+     */
+    public function getUserCalendarEvents($user_id, $start, $end)
+    {
+        $getMS_Ids = $this->db->table(MultiselectMemberModel::TABLE)
+            ->eq('user_id', $user_id)
+            ->findAllByColumn('group_id');
+
+        $getGr_Ids = $this->db->table(GroupMemberModel::TABLE)
+            ->eq('user_id', $user_id)
+            ->findAllByColumn('group_id');
+
+         $tasks = $this->db->table(self::TABLE)
+            ->beginOr()
+            ->eq('owner_id', $user_id)
+            ->in('owner_gp', $getGr_Ids)
+            ->in('owner_ms', $getMS_Ids)
+            ->closeOr()
+            ->gte('date_due', strtotime($start))
+            ->lte('date_due', strtotime($end))
+                           ->neq('is_active', 0);
+
+         $tasks = $tasks->findAll();
+
+         $events = array();
+
+         foreach ($tasks as $task) {
+
+         $startDate = new DateTime();
+         $startDate->setTimestamp($task['date_started']);
+
+         $endDate = new DateTime();
+         $endDate->setTimestamp($task['date_due']);
+
+         if ($startDate->getTimestamp() == 0) { $startDate = $endDate; }
+
+         $allDay = $startDate == $endDate && $endDate->format('Hi') == '0000';
+         $format = $allDay ? 'Y-m-d' : 'Y-m-d\TH:i:s';
+
+            $events[] = array(
+                'timezoneParam' => $this->timezoneModel->getCurrentTimezone(),
+                'id' => $task['id'],
+                'title' => t('#%d', $task['id']).' '.$task['title'],
+                'backgroundColor' => $this->colorModel->getBackgroundColor('dark_grey'),
+                'borderColor' => $this->colorModel->getBorderColor($task['color_id']),
+                'textColor' => 'white',
+                'url' => $this->helper->url->to('TaskViewController', 'show', array('task_id' => $task['id'], 'project_id' => $task['project_id'])),
+                'start' => $startDate->format($format),
+                'end' => $endDate->format($format),
+                'editable' => $allDay,
+                'allday' => $allDay,
+            );
+         }
+
+         return $events;
+    }
+
+}