fluent-boards / app / Services / UserService.php

UserService.php in FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration 1.11, at app/Services/UserService.php

271 lines 9.9 KB

Raw Download Zip

1	<?php
2
3	namespace FluentBoards\App\Services;
4
5	use FluentBoards\App\Models\Activity;
6	use FluentBoards\App\Models\Meta;
7	use FluentBoards\App\Models\Task;
8	use FluentBoards\App\Models\User;
9	use FluentBoards\App\Models\Board;
10	use FluentBoards\App\Models\Relation;
11	use FluentBoards\Framework\Support\Arr;
12
13
14	class UserService
15	{
16	public function allFluentBoardsUsers($boardId = null)
17	{
18	// Get the global admins first
19	$adminUserIds = Meta::query()->where('object_type', Constant::FLUENT_BOARD_ADMIN)
20	->get()->pluck('object_id')->toArray();
21
22	$boardObjects = Relation::where('object_type', 'board_user');
23
24	if ($adminUserIds) {
25	$boardObjects = $boardObjects->whereNotIn('foreign_id', $adminUserIds);
26	}
27
28	if ($boardId) {
29	$boardObjects = $boardObjects->where('object_id', $boardId);
30	}
31
32	$boardObjects = $boardObjects->whereNotIn('foreign_id', $adminUserIds)
33	->get();
34
35	$boardUserMaps = [];
36
37	$accessBoardIds = [];
38
39	foreach ($boardObjects as $boardObject) {
40	if (!isset($boardUserMaps[$boardObject->foreign_id])) {
41	$boardUserMaps[$boardObject->foreign_id] = [];
42	}
43
44	$accessBoardIds[] = $boardObject->object_id;
45
46	$boardUserMaps[$boardObject->foreign_id][] = [
47	'board_id' => $boardObject->object_id,
48	'role' => Arr::get($boardObject->settings, 'is_admin') ? 'admin' : 'member'
49	];
50	}
51
52	$accessBoardIds = array_unique($accessBoardIds);
53	$allUserIds = array_unique(array_merge($adminUserIds, array_keys($boardUserMaps)));
54
55	$users = get_users([
56	'include' => $allUserIds
57	]);
58
59	$boardUsers = [];
60	$allBoards = Board::query()->whereIn('id', $accessBoardIds)->get()->keyBy('id');
61
62	foreach ($users as $user) {
63
64	$boards = Arr::get($boardUserMaps, $user->ID, []);
65
66	$formattedBoars = [];
67
68	foreach ($boards as $board) {
69	if (empty($allBoards[$board['board_id']])) {
70	continue;
71	}
72
73	$boardModel = $allBoards[$board['board_id']];
74	$formattedBoars[] = [
75	'id' => $boardModel->id,
76	'title' => $boardModel->title,
77	'role' => $board['role']
78	];
79	}
80
81	$name = trim($user->first_name . ' ' . $user->last_name);
82
83	if (!$name) {
84	$name = $user->display_name;
85	}
86
87	$photo = fluent_boards_user_avatar($user->user_email, $name);
88
89	$boardUsers[] = [
90	'ID' => $user->ID,
91	'display_name' => $user->display_name,
92	'photo' => $photo,
93	'email' => $user->user_email,
94	'boards' => $formattedBoars,
95	'is_super' => in_array($user->ID, $adminUserIds),
96	'is_wpadmin' => $user->has_cap('manage_options')
97	];
98	}
99
100	usort($boardUsers, function ($a, $b) {
101	return strcmp($a['display_name'], $b['display_name']);
102	});
103
104	return $boardUsers;
105	}
106
107	public function memberAssociatedTaskUsers($userId)
108	{
109	$user = User::find($userId);
110	$boards = $user->whichBoards->pluck('id');
111	$boardUsers = Relation::whereIn('object_id', $boards)
112	->where('object_type', Constant::OBJECT_TYPE_BOARD_USER)
113	->pluck('foreign_id')->toArray();
114	$uniqueUsersIds = array_unique($boardUsers);
115	$uniqueUsers = User::whereIn('ID', $uniqueUsersIds)->with('whichBoards')->get();
116
117	$userWiseBoardDesignation = Relation::query()->whereIn('foreign_id', $uniqueUsersIds)
118	->where('object_type', Constant::OBJECT_TYPE_BOARD_USER)->get();
119
120	$data = array();
121	$data['userWiseBoardDesignation'] = $userWiseBoardDesignation;
122
123	foreach ($uniqueUsers as &$uniqueUser) {
124	if (user_can($uniqueUser['ID'], 'manage_options') && PermissionManager::isFluentBoardsAdmin($uniqueUser['ID'])) {
125	$uniqueUser['is_super'] = true;
126	$uniqueUser['is_wpadmin'] = true;
127	} elseif (user_can($uniqueUser['ID'], 'manage_options')) {
128	$uniqueUser['is_wpadmin'] = true;
129	$uniqueUser['is_super'] = false;
130	} elseif (PermissionManager::isFluentBoardsAdmin($uniqueUser['ID'])) {
131	$uniqueUser['is_super'] = true;
132	$uniqueUser['is_wpadmin'] = false;
133	} else {
134	$uniqueUser['all_boards'] = Arr::get($uniqueUser, 'boards');
135	$uniqueUser['is_super'] = false;
136	$uniqueUser['is_wpadmin'] = false;
137	}
138	}
139
140	$data['uniqueUsers'] = $uniqueUsers;
141
142	return $data;
143	}
144
145	public function searchFluentBoardsUser($search_input)
146	{
147
148	$boardUsers = User::whereHas('whichBoards', function ($query) use ($search_input) {
149	$query->where('display_name', 'like', '%' . $search_input . '%');
150	})
151	->where('display_name', 'like', '%' . $search_input . '%')
152	->with('whichBoards')
153	->get()
154	->toArray();
155
156	foreach ($boardUsers as &$boardUser) {
157	if (user_can($boardUser['ID'], 'manage_options') && PermissionManager::isFluentBoardsAdmin($boardUser['ID'])) {
158	$boardUser['is_super'] = true;
159	$boardUser['is_wpadmin'] = true;
160	} elseif (user_can($boardUser['ID'], 'manage_options')) {
161	$boardUser['is_wpadmin'] = true;
162	$boardUser['is_super'] = false;
163	} elseif (PermissionManager::isFluentBoardsAdmin($boardUser['ID'])) {
164	$boardUser['is_super'] = true;
165	$boardUser['is_wpadmin'] = false;
166	} else {
167	$boardUser['all_boards'] = Arr::get($boardUser, 'boards');
168	$boardUser['is_super'] = false;
169	$boardUser['is_wpadmin'] = false;
170	}
171	}
172
173	return $boardUsers;
174	}
175
176	public function searchMemberUser($search_input, $userId)
177	{
178	$user = User::find($userId);
179	$boards = $user->boards->pluck('id');
180	$boardUsers = Relation::whereIn('board_id', $boards)->orWhere('board_id', null)->where('status', 'ACTIVE')->pluck('user_id')->toArray();
181	$uniqueUsersIds = array_unique($boardUsers);
182	// $uniqueUsers = User::whereIn('ID', $uniqueUsersIds)->with('boards')->get();
183
184	$searchResult = User::query()->whereIn('ID', $uniqueUsersIds)->with('boards')
185	->where('display_name', 'like', '%' . $search_input . '%')
186	->take(20)->get();
187
188	foreach ($searchResult as &$uniqueUser) {
189	if (PermissionManager::isAdmin($uniqueUser['ID'])) {
190	$uniqueUser['all_boards'] = Board::query()->where('is_archived', 0)->get();
191	$isFluentBoardsAdmin = Relation::where('user_id', $uniqueUser['ID'])
192	->whereNull('board_id')
193	->where('status', 'ACTIVE')
194	->first();
195	if ($isFluentBoardsAdmin) {
196	$uniqueUser['is_super'] = true;
197	$uniqueUser['is_wpadmin'] = false;
198	} else {
199	$uniqueUser['is_super'] = false;
200	$uniqueUser['is_wpadmin'] = true;
201	}
202	} else {
203	$uniqueUser['all_boards'] = $uniqueUser['boards'];
204	$uniqueUser['is_super'] = false;
205	$uniqueUser['is_wpadmin'] = false;
206	}
207	}
208
209	return $searchResult;
210	}
211
212	public function getMemberAssociatedTasks($user_id, $page)
213	{
214	// get the user
215	$user = User::find($user_id);
216	// get the task created by the user
217	$tasks = Task::query()->where('created_by', $user_id)
218	->orderBy('created_at', 'desc')
219	->with(['stage', 'board'])
220	->paginate(10, ['*'], 'page', $page);
221	// get the task assigned to the user
222	$assignedTasks = $user->tasks()
223	->orderBy('created_at', 'desc')
224	->with(['stage', 'board'])
225	->paginate(10, ['*'], 'page', $page);
226	return [
227	'tasks' => $tasks->merge($assignedTasks)->sortByDesc('created_at')->values()->toArray(),
228	'paginationInfo' => [
229	'current_page' => $tasks->currentPage(),
230	'last_page' => $tasks->lastPage() > $assignedTasks->lastPage() ? $tasks->lastPage() : $assignedTasks->lastPage()
231	]
232	];
233
234	}
235
236	public function getMemberRelatedAcitivies($user_id, $page)
237	{
238	$activities = Activity::query()->where('created_by', $user_id)
239	->orderBy('created_at', 'desc')
240	->with('user')->paginate(40, ['*'], 'page', $page);
241
242	$activitiesToShow = array();
243
244	foreach ($activities as $activity) {
245	if ($activity->object_type == Constant::ACTIVITY_BOARD) {
246	$activity->load('board');
247	// if($activity->settings && $activity->settings['task_id']){
248	// $activity->task = Task::findOrFail($activity->settings['task_id']);
249	// }
250	if (PermissionManager::userHasPermission($activity->board_id, get_current_user_id())) {
251	$activitiesToShow[] = $activity;
252	}
253	} elseif ($activity->object_type == Constant::ACTIVITY_TASK) {
254	$activity->load('task');
255	if ($activity->task && PermissionManager::userHasPermission($activity->task->board_id, get_current_user_id())) {
256	$activitiesToShow[] = $activity;
257	}
258	}
259	}
260	return [
261	'activities' => $activitiesToShow,
262	'pagination' => $activities->toArray(),
263	];
264	}
265
266	private function getTaskById($taskId)
267	{
268	return Task::findOrFail($taskId);
269	}
270	}
271