PluginProbe
FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration / 1.13
FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration v1.13
2.0.15 2.0.12 2.0.10 2.0.4 2.0.1 2.0.0 1.95.3 1.95.2 1.95 1.91.6 trunk 1.11 1.12 1.13 1.20 1.21 1.22 1.23 1.30 1.31 1.32 1.35 1.40 1.41 1.45 All 41 releases
fluent-boards / app / Http / Controllers / OptionsController.php

OptionsController.php in FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration 1.13, at app/Http/Controllers/OptionsController.php

843 lines 31.0 KB
No matching file
Up and down to move Enter to open Esc to close
Raw Download Zip
1 <?php
2
3 namespace FluentBoards\App\Http\Controllers;
4
5 use FluentBoards\App\App;
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\App\Services\BoardService;
12 use FluentBoards\App\Services\Helper;
13 use FluentBoards\App\Services\OptionService;
14 use FluentBoards\App\Services\Constant;
15 use FluentBoards\App\Services\PermissionManager;
16 use FluentBoards\Framework\Http\Request\Request;
17 use FluentBoards\Framework\Support\Arr;
18
19 class OptionsController extends Controller
20 {
21 private $boardService;
22 private $optionService;
23
24 public function __construct(BoardService $boardService, OptionService $optionService)
25 {
26 parent::__construct();
27 $this->boardService = $boardService;
28 $this->optionService = $optionService;
29 }
30
31 public function selectorOptions(Request $request)
32 {
33 try {
34 $optionKey = $request->getSafe('option_key');
35 $search = $request->getSafe('search');
36 $includedIds = $request->getSafe('values');
37 $boardId = $request->getSafe('board_id');
38
39 $options = [];
40 if ('users' === $optionKey || 'task_assignees' === $optionKey) { // no ajax/code is designed to handle this eventually will goto else
41
42 if (!PermissionManager::isBoardManager($boardId)) {
43 throw new \Exception('You do not have permission to access this route');
44 }
45
46 if (!defined('FLUENT_BOARDS_PRO')) {
47 // get who has 'manage_options' capability
48 $users = PermissionManager::getAll_WP_Admins($search);
49
50 } else {
51 $users = User::query()
52 ->when($search, function ($query) use ($search) {
53 return $query->where('display_name', 'LIKE', '%' . $search . '%')->orWhere('user_email', 'LIKE', '%' . $search . '%');
54 })
55 ->limit(20)->get();
56 }
57
58 $options = $this->addUserDataAsSelectorOption($users);
59
60 } elseif ('boards' === $optionKey) {
61 $boards = Board::query()
62 ->when($search, function ($query) use ($search) {
63 return $query->where('title', 'LIKE', '%' . $search . '%');
64 })->take(20)->get();
65
66 foreach ($boards as $board) {
67 $options[] = [
68 'id' => $board->id,
69 'title' => $board->title,
70 'left_side_value' => $board->title,
71 'right_side_value' => $board->slug,
72 ];
73 }
74 } elseif ('tasks' === $optionKey) {
75 $tasks = Task::where('board_id', $boardId)
76 ->whereNull('archived_at')
77 ->whereNull('parent_id')
78 ->when($search, function ($query) use ($search) {
79 return $query->where('title', 'LIKE', '%' . $search . '%');
80 })->take(20)->get();
81
82 foreach ($tasks as $task) {
83 $options[] = [
84 'id' => $task->id,
85 'title' => $task->title,
86 'board_id' => $task->board_id
87 ];
88 }
89
90 } elseif ('assigned_in_task' == $optionKey) {
91 $users = (new BoardService())->getAssigneesByBoard($boardId, $search);
92 $options = $this->addUserDataAsSelectorOption($users);
93 } else {
94 $options = apply_filters('fluent_boards/ajax_options_' . $optionKey, [], $search, $includedIds);
95 }
96
97 return $this->sendSuccess([
98 'options' => $options,
99 ], 200);
100 } catch (\Exception $e) {
101 return $this->sendError($e->getMessage(), 404);
102 }
103 }
104
105 private function addUserDataAsSelectorOption($users)
106 {
107 $options = [];
108 foreach ($users as $user) {
109 $options[] = [
110 'id' => $user->ID,
111 'email' => $user->user_email,
112 'name' => $user->display_name ?? $user->user_email,
113 'title' => $user->display_name . ' (' . $user->user_email . ')',
114 'photo' => get_avatar_url($user->user_email),
115 ];
116 }
117 return $options;
118 }
119
120 public function getCurrentUserPermissions()
121 {
122 try {
123 $currentUserBoards = Relation::query()
124 ->where('user_id', get_current_user_id())
125 ->whereNotNull('board_id')
126 ->where('status', 'ACTIVE')
127 ->get();
128 foreach ($currentUserBoards as &$currentUserBoardPermission) {
129 $currentUserBoardPermission->permissions = \maybe_unserialize($currentUserBoardPermission->permissions);
130 }
131
132 return $this->sendSuccess(
133 $currentUserBoards, 200
134 );
135 } catch (\Exception $e) {
136 return $this->sendError($e->getMessage(), 404);
137 }
138 }
139
140 public function getUserPermission(Request $request)
141 {
142 try {
143 $boardId = $request->getSafe('boardId');
144 $userId = $request->getSafe('userId');
145
146 $boardUser = Relation::where('board_id', $boardId)
147 ->where('user_id', $userId)
148 ->where('status', 'ACTIVE')->first();
149 if (!$boardUser->is_admin) {
150 $boardUser->permissions = \maybe_unserialize($boardUser->permissions);
151 }
152
153 return $this->sendSuccess(
154 $boardUser, 200
155 );
156 } catch (\Exception $e) {
157 return $this->sendError($e->getMessage(), 404);
158 }
159 }
160
161 public function updatedUserPermission(Request $request)
162 {
163 try {
164 $permission = $request->getSafe('userPermission');
165 $updateType = $request->getSafe('updateType');
166 $boardId = $request->getSafe('boardId');
167 $userId = $request->getSafe('userId');
168
169 $boardUser = Relation::where('board_id', $boardId)->where('user_id', $userId)->status('ACTIVE')->first();
170
171 if ('Board Admin' == $permission) {
172 $boardUser->is_admin = 'add' == $updateType ? 1 : 0;
173 $boardUser->save();
174 } else {
175 if (0 == $boardUser->is_admin) {
176 $permissionsAlreadyHave = maybe_unserialize($boardUser->permissions);
177 if (!in_array($permission, $permissionsAlreadyHave) && 'add' == $updateType) {
178 array_push($permissionsAlreadyHave, $permission);
179 } elseif (in_array($permission, $permissionsAlreadyHave) && 'remove' == $updateType) {
180 if (($key = array_search($permission, $permissionsAlreadyHave)) !== false) {
181 unset($permissionsAlreadyHave[$key]);
182 }
183 }
184 $boardUser->permissions = serialize($permissionsAlreadyHave);
185 $boardUser->save();
186 }
187 }
188
189 $boardUser->permissions = maybe_unserialize($boardUser->permissions);
190
191 return $this->sendSuccess(
192 $boardUser, 200
193 );
194 } catch (\Exception $e) {
195 return $this->sendError($e->getMessage(), 404);
196 }
197 }
198
199 public function SetUserSuperAdmin($userId)
200 {
201 try {
202 $this->optionService->createSuperAdmin($userId);
203 return $this->sendSuccess([
204 'message' => __('Member has been set super admin successfully!', 'fluent-boards')
205 ], 200);
206
207 } catch (\Exception $e) {
208 return $this->sendError($e->getMessage(), 404);
209 }
210 }
211
212 public function removeUserSuperAdmin($userId)
213 {
214 try {
215 $this->optionService->removeUserSuperAdmin($userId);
216
217 return $this->sendSuccess([
218 'message' => __('User has been removed as super admin successfully!', 'fluent-boards'),
219 ], 200);
220 } catch (\Exception $e) {
221 return $this->sendError($e->getMessage(), 404);
222 }
223 }
224
225 public function IsUserAllBoardAdmin(Request $request)
226 {
227 try {
228 $userId = $request->getSafe('id');
229 $isSuperAdmin = false;
230 $superAdmin = Relation::where('board_id', null)->where('user_id', $userId)->where('status', 'ACTIVE')->first();
231 $totalSuperAdmin = Relation::where('board_id', null)->where('status', 'ACTIVE')->count();
232 $permissions = [];
233 if ($superAdmin) {
234 $isSuperAdmin = true;
235 $permissions = \maybe_unserialize($superAdmin->permissions);
236 }
237
238 return $this->sendSuccess([
239 'allBoardAdmin' => $isSuperAdmin,
240 'permissions' => $permissions,
241 'numberOfSuperAdmin' => $totalSuperAdmin,
242 ], 200);
243 } catch (\Exception $e) {
244 return $this->sendError($e->getMessage(), 404);
245 }
246 }
247
248 public function RemoveUserFromSuperAdmin(Request $request, $id)
249 {
250 try {
251 $userId = $request->getSafe('id');
252
253 $superAdmin = Relation::where('board_id', null)->where('user_id', $userId)->first();
254 $superAdmin->status = 'INACTIVE';
255 $superAdmin->save();
256
257 return $this->sendSuccess([
258 'message' => __('User removed as super admin', 'fluent-boards'),
259 ], 201);
260 } catch (\Exception $e) {
261 return $this->sendError($e->getMessage(), 404);
262 }
263 }
264
265 public function removeUserFromBoard(Request $request)
266 {
267 try {
268 $boardId = $request->getSafe('boardId');
269 $userId = $request->getSafe('userId');
270
271 $this->boardService->removeUserFromBoard($boardId, $userId);
272
273 if (!PermissionManager::isAdmin($userId)) {
274 $this->boardService->removeFromRecentlyOpened($boardId, $userId);
275 }
276
277 return $this->sendSuccess([
278 'message' => __('User Removed from Board successfully!', 'fluent-boards'),
279 ], 201);
280 } catch (\Exception $e) {
281 return $this->sendError($e->getMessage(), 404);
282 }
283 }
284
285 public function addAsSuperAdmin(Request $request)
286 {
287 try {
288 $userIds = $request->getSafe('memberIds');
289 foreach ($userIds as $userId) {
290 $this->createSuperAdmin($userId);
291 }
292
293 return $this->sendSuccess([
294 'message' => __('Fluent boards admin added', 'fluent-boards'),
295 ], 201);
296 } catch (\Exception $e) {
297 return $this->sendError($e->getMessage(), 404);
298 }
299 }
300
301 private function createSuperAdmin($userId)
302 {
303 try {
304 $existUser = Meta::where('object_id', $userId)->first();
305 if (!$existUser) {
306 $meta = new Meta();
307 $meta->object_id = $userId;
308 $meta->object_type = Constant::FLUENT_BOARD_ADMIN;
309 $meta->save();
310 }
311 } catch (\Exception $e) {
312 return $this->sendError($e->getMessage(), 404);
313 }
314 }
315
316 public function addMembersInBoards(Request $request)
317 {
318 try {
319 $userIds = $request->getSafe('memberIds');
320 $boardIds = $request->getSafe('boardIds');
321
322 foreach ($userIds as $userId) {
323 foreach ($boardIds as $boardId) {
324 $this->boardService->addMembersInBoard($boardId, $userId);
325 }
326 }
327
328 return $this->sendSuccess([
329 'message' => __('Members added to boards', 'fluent-boards'),
330 ], 201);
331 } catch (\Exception $e) {
332 return $this->sendError($e->getMessage(), 404);
333 }
334 }
335
336
337 public function updateGlobalNotificationSettings(Request $request)
338 {
339 try {
340 $newSettings = $request->getSafe('updatedSettings');
341
342 $this->optionService->updateGlobalNotificationSettings($newSettings);
343
344 return $this->sendSuccess([
345 'message' => __("Notification settings are updated", 'fluent-boards'),
346 ], 201);
347 } catch (\Exception $e) {
348 return $this->sendError($e->getMessage(), 404);
349 }
350 }
351
352 public function getGlobalNotificationSettings()
353 {
354 try {
355 $globalSettings = $this->optionService->getGlobalNotificationSettings();
356 if ($globalSettings->value)
357 $currentSettings = maybe_unserialize($globalSettings->value);
358
359 return $this->sendSuccess([
360 'currentSettings' => $currentSettings,
361 ], 200);
362 } catch (\Exception $e) {
363 return $this->sendError($e->getMessage(), 404);
364 }
365 }
366
367 public function getBoardMembers(Request $request)
368 {
369 if (!PermissionManager::userHasAnyBoardAccess()) {
370 return $this->sendError([
371 'message' => __('You do not have permission to access this route', 'fluent-boards')
372 ]);
373 }
374
375 $boardId = $request->getSafe('boardId', 'intval');
376
377 $memberUserIds = Relation::where('object_type', 'board_user')
378 ->select(['foreign_id'])
379 ->groupBy('foreign_id');
380
381 if ($boardId) {
382 $memberUserIds = $memberUserIds->where('object_id', $boardId);
383 }
384
385 $members = [];
386
387 $memberUserIds = $memberUserIds->get()
388 ->pluck('foreign_id')->toArray();
389
390
391 if ($memberUserIds) {
392 $memberUsers = get_users([
393 'include' => $memberUserIds
394 ]);
395
396
397 foreach ($memberUsers as $memberUser) {
398 $name = trim($memberUser->first_name . ' ' . $memberUser->last_name);
399 if (!$name) {
400 $name = $memberUser->display_name;
401 }
402
403 $members[$memberUser->ID] = [
404 'ID' => $memberUser->ID,
405 'display_name' => $name,
406 'photo' => get_avatar_url($memberUser->user_email)
407 ];
408 }
409
410 }
411
412 $adminUsers = get_users([
413 'role' => 'administrator',
414 'exclude' => $memberUserIds
415 ]);
416
417 foreach ($adminUsers as $user) {
418 $name = trim($user->first_name . ' ' . $user->last_name);
419 if (!$name) {
420 $name = $user->display_name;
421 }
422 $members[$user->ID] = [
423 'ID' => $user->ID,
424 'display_name' => $name,
425 'photo' => get_avatar_url($user->user_email)
426 ];
427 }
428
429 $members = array_values($members);
430
431 // sort members by name
432 usort($members, function ($a, $b) {
433 return strcmp($a['display_name'], $b['display_name']);
434 });
435
436 return [
437 'members' => $members
438 ];
439 }
440
441 public function quickSearch()
442 {
443 $currentUserId = get_current_user_id();
444
445 $query = sanitize_text_field($_REQUEST['query']);
446 $query = strtolower($query);
447 $scope = sanitize_text_field($_REQUEST['scope']);
448
449 $tasksQuery = Task::query()->where('parent_id', null)->whereRaw('LOWER(title) LIKE ?', ['%' . $query . '%']);
450 $isUserAdmin = PermissionManager::isAdmin($currentUserId);
451
452 // This is a check for deleted tasks to be excluded from search results
453 $allActiveBoardsIds = Board::query()->where('archived_at', null)->pluck('id')->toArray();
454
455 if ($scope == 'all') {
456 $boardQuery = Board::query()->whereRaw('LOWER(title) LIKE ?', ['%' . $query . '%']);
457 if ($isUserAdmin) {
458 $boards = $boardQuery->get();
459 $tasks = $tasksQuery->get();
460 } else {
461 $boardIds = PermissionManager::getBoardIdsForUser($currentUserId);
462 $boards = $boardQuery->whereIn('id', $boardIds)->get();
463 $tasks = $tasksQuery->whereIn('board_id', $boardIds)->get();
464 }
465 } else {
466 $boards = []; // boards results is not needed in scoped search
467 $inBoard = (int)$scope;
468 if ($isUserAdmin || in_array($inBoard, $boardIds = PermissionManager::getBoardIdsForUser($currentUserId))) {
469 $tasks = $tasksQuery->where('board_id', $inBoard)->get();
470 } else {
471 // Out of permission scope search
472 $tasks = [];
473 }
474 }
475
476
477 $formattedTasks = [];
478 $formattedBoards = [];
479 foreach ($boards as $board) {
480 $formattedBoards[] = [
481 'type' => 'board',
482 'id' => $board->id,
483 'title' => $board->title,
484 'description' => $board->description,
485 'url' => Helper::getBoardUrl($board->id)
486 ];
487 }
488 foreach ($tasks as $task) {
489
490 if (!in_array($task->board_id, $allActiveBoardsIds)) {
491 // if the task is not in an active board, skip it
492 continue;
493 }
494
495 $board = $task->board;
496
497 $formattedTasks[] = [
498 'type' => 'task',
499 'id' => $task->id,
500 'title' => $task->title,
501 'description' => $task->description,
502 'url' => Helper::getTaskUrl($task->id, $board->id),
503 'board' => [
504 'id' => $board->id,
505 'title' => $board->title,
506 'url' => Helper::getBoardUrl($board->id)
507 ],
508 'stage' => [
509 'id' => $task->stage_id,
510 'title' => $task->stage->title ?? '',
511 ],
512
513 ];
514 }
515 return $this->sendSuccess([
516 'tasks' => $formattedTasks,
517 'boards' => $formattedBoards
518 ], 200);
519
520 }
521
522 public function getDashboardViewSettings()
523 {
524 try {
525 $globalSettings = $this->optionService->getDashboardViewSettings();
526 if ($globalSettings->value)
527 $currentSettings = maybe_unserialize($globalSettings->value);
528
529 return $this->sendSuccess([
530 'currentSettings' => $currentSettings,
531 ], 200);
532 } catch (\Exception $e) {
533 return $this->sendError($e->getMessage(), 404);
534 }
535 }
536
537 public function updateDashboardViewSettings(Request $request)
538 {
539 try {
540 $newSettings = $request->getSafe('updatedSettings');
541
542 $this->optionService->updateDashboardViewSettings($newSettings);
543
544 return $this->sendSuccess([
545 'message' => __("Dashboard view settings are updated", 'fluent-boards'),
546 ], 201);
547 } catch (\Exception $e) {
548 return $this->sendError($e->getMessage(), 404);
549 }
550 }
551
552
553 public function getAddonsSettings()
554 {
555 $addOns = [
556 'fluent-crm' => [
557 'title' => __('FluentCRM', 'fluent-boards'),
558 'logo' => fluent_boards_mix('images/addons/fluent-crm.svg'),
559 'is_installed' => defined('FLUENTCRM'),
560 'learn_more_url' => 'https://fluentcrm.com/',
561 'associate_doc' => 'https://fluentboards.com/docs/fluentboards-integration-with-fluentcrm/',
562 'action_text' => $this->isPluginInstalled('fluent-crm/fluent-crm.php') ? __('Activate FluentCRM', 'fluent-boards') : __('Install FluentCRM', 'fluent-boards'),
563 'description' => __('FluentCRM is a Self Hosted Email Marketing Automation Plugin for WordPress. Manage your leads and customers, email campaigns, automated email sequencing and many more', 'fluent-boards')
564 ],
565 'fluentform' => [
566 'title' => __('Fluent Forms', 'fluent-boards'),
567 'logo' => fluent_boards_mix('images/addons/fluentform.png'),
568 'is_installed' => defined('FLUENTFORM'),
569 'learn_more_url' => 'https://wordpress.org/plugins/fluentform/',
570 'associate_doc' => 'https://fluentboards.com/docs/fluentboards-integration-with-fluent-forms/',
571 'action_text' => $this->isPluginInstalled('fluent-form/fluent-form.php') ? __('Activate Fluent Forms', 'fluent-boards') : __('Install Fluent Forms', 'fluent-boards'),
572 'description' => __('Collect leads and build any type of forms, accept payments, connect with your CRM with the Fastest Contact Form Builder Plugin for WordPress', 'fluent-boards')
573 ],
574 'fluent-support' => [
575 'title' => __('Fluent Support', 'fluent-boards'),
576 'logo' => fluent_boards_mix('images/addons/fluent-support.svg'),
577 'is_installed' => defined('FLUENT_SUPPORT_VERSION'),
578 'learn_more_url' => 'https://wordpress.org/plugins/fluent-connect/',
579 'settings_url' => admin_url('admin.php?page=fluent-support#/'),
580 'associate_doc' => 'https://fluentboards.com/docs/fluentboards-integration-with-fluentsupport/',
581 'action_text' => $this->isPluginInstalled('fluent-support/fluent-support.php') ? __('Activate Fluent Support', 'fluent-boards') : __('Install Fluent Support', 'fluent-boards'),
582 'description' => __('WordPress Helpdesk and Customer Support Ticket Plugin. Provide awesome support and manage customer queries right from your WordPress dashboard.', 'fluent-boards')
583 ],
584 'fluent-smtp' => [
585 'title' => __('Fluent SMTP', 'fluent-boards'),
586 'logo' => fluent_boards_mix('images/addons/fluent-smtp.svg'),
587 'is_installed' => defined('FLUENTMAIL'),
588 'learn_more_url' => 'https://wordpress.org/plugins/fluent-smtp/',
589 'associate_doc' => admin_url('options-general.php?page=fluent-mail#/'),
590 'action_text' => $this->isPluginInstalled('fluent-smtp/fluent-smtp.php') ? __('Activate Fluent SMTP', 'fluent-boards') : __('Install Fluent SMTP', 'fluent-boards'),
591 'description' => __('The Ultimate SMTP and SES Plugin for WordPress. Connect with any SMTP, SendGrid, Mailgun, SES, Sendinblue, PepiPost, Google, Microsoft and more.', 'fluent-boards')
592 ],
593 ];
594
595 $modules = fluent_boards_get_pref_settings(false);
596
597 if (empty($modules['frontend']['render_type'])) {
598 $modules['frontend']['render_type'] = 'standalone';
599 }
600
601 $modules['panel_url'] = fluent_boards_page_url();
602
603 return [
604 'addons' => $addOns,
605 'featureModules' => $modules
606 ];
607 }
608
609 public function saveAddonsSettings(Request $request)
610 {
611 if (!defined('FLUENT_BOARDS_PRO')) {
612 return $this->sendError([
613 'message' => __('This feature is only available in Fluent Boards Pro', 'fluent-boards')
614 ]);
615 }
616
617 $settings = $request->get('settings', []);
618
619 $prefSettings = fluent_boards_get_pref_settings(false);
620
621 $settings = wp_parse_args($settings, $prefSettings);
622
623 $settings = Arr::only($settings, array_keys($prefSettings));
624 $settings['frontend']['slug'] = sanitize_title($settings['frontend']['slug']);
625
626 if (empty($settings['frontend']['slug'])) {
627 $settings['frontend']['slug'] = 'projects';
628 }
629
630 if (defined('FLUENT_BOARDS_SLUG') && FLUENT_BOARDS_SLUG) {
631 $settings['frontend']['slug'] = FLUENT_BOARDS_SLUG;
632 }
633
634 do_action('fluent_boards/saving_addons', $settings, $prefSettings);
635
636 update_option('fluent_boards_modules', $settings, 'yes');
637
638 return $this->sendSuccess([
639 'message' => __('Settings are saved', 'fluent-boards'),
640 'featureModules' => $settings
641 ]);
642 }
643
644 public function installPlugin(Request $request)
645 {
646 if (!current_user_can('install_plugins')) {
647 return $this->sendError([
648 'message' => __('Sorry! you do not have permission to install plugin', 'fluent-crm')
649 ]);
650 }
651
652 $plugin = $request->getSafe('plugin', 'sanitize_text_field');
653
654 $acceptedPlugins = [
655 'fluent-crm' => 'fluent-crm.php',
656 'fluentform' => 'fluentform.php',
657 'fluent-support' => 'fluent-support.php',
658 'fluent-smtp' => 'fluent-smtp.php'
659 ];
660
661 if (!isset($acceptedPlugins[$plugin])) {
662 return $this->sendError([
663 'message' => __('Invalid plugin', 'fluent-boards')
664 ]);
665 }
666
667
668 $pluginToInstall = [
669 'name' => __('Fluent Plugin', 'fluent-boards'),
670 'repo-slug' => $plugin,
671 'file' => $acceptedPlugins[$plugin],
672 ];
673
674 $this->backgroundInstaller($pluginToInstall, $plugin);
675
676 return $this->sendSuccess([
677 'message' => __('Plugin is being installed', 'fluent-boards')
678 ]);
679 }
680
681 private function isPluginInstalled($plugin)
682 {
683 return file_exists(WP_PLUGIN_DIR . '/' . $plugin);
684 }
685
686 private function backgroundInstaller($plugin_to_install, $plugin_id)
687 {
688 if (!empty($plugin_to_install['repo-slug'])) {
689 require_once ABSPATH . 'wp-admin/includes/file.php';
690 require_once ABSPATH . 'wp-admin/includes/plugin-install.php';
691 require_once ABSPATH . 'wp-admin/includes/class-wp-upgrader.php';
692 require_once ABSPATH . 'wp-admin/includes/plugin.php';
693
694 WP_Filesystem();
695
696 $skin = new \Automatic_Upgrader_Skin();
697 $upgrader = new \WP_Upgrader($skin);
698 $installed_plugins = array_reduce(array_keys(\get_plugins()), array($this, 'associate_plugin_file'), array());
699 $plugin_slug = $plugin_to_install['repo-slug'];
700 $plugin_file = isset($plugin_to_install['file']) ? $plugin_to_install['file'] : $plugin_slug . '.php';
701 $installed = false;
702 $activate = false;
703
704 // See if the plugin is installed already.
705 if (isset($installed_plugins[$plugin_file])) {
706 $installed = true;
707 $activate = !is_plugin_active($installed_plugins[$plugin_file]);
708 }
709
710 // Install this thing!
711 if (!$installed) {
712 // Suppress feedback.
713 ob_start();
714
715 try {
716 $plugin_information = plugins_api(
717 'plugin_information',
718 array(
719 'slug' => $plugin_slug,
720 'fields' => array(
721 'short_description' => false,
722 'sections' => false,
723 'requires' => false,
724 'rating' => false,
725 'ratings' => false,
726 'downloaded' => false,
727 'last_updated' => false,
728 'added' => false,
729 'tags' => false,
730 'homepage' => false,
731 'donate_link' => false,
732 'author_profile' => false,
733 'author' => false,
734 ),
735 )
736 );
737
738 if (is_wp_error($plugin_information)) {
739 throw new \Exception($plugin_information->get_error_message());
740 }
741
742 $package = $plugin_information->download_link;
743 $download = $upgrader->download_package($package);
744
745 if (is_wp_error($download)) {
746 throw new \Exception($download->get_error_message());
747 }
748
749 $working_dir = $upgrader->unpack_package($download, true);
750
751 if (is_wp_error($working_dir)) {
752 throw new \Exception($working_dir->get_error_message());
753 }
754
755 $result = $upgrader->install_package(
756 array(
757 'source' => $working_dir,
758 'destination' => WP_PLUGIN_DIR,
759 'clear_destination' => false,
760 'abort_if_destination_exists' => false,
761 'clear_working' => true,
762 'hook_extra' => array(
763 'type' => 'plugin',
764 'action' => 'install',
765 ),
766 )
767 );
768
769 if (is_wp_error($result)) {
770 throw new \Exception($result->get_error_message());
771 }
772
773 $activate = true;
774
775 } catch (\Exception $e) {
776 }
777
778 // Discard feedback.
779 ob_end_clean();
780 }
781
782 wp_clean_plugins_cache();
783
784 // Activate this thing.
785 if ($activate) {
786 try {
787 $result = activate_plugin($installed ? $installed_plugins[$plugin_file] : $plugin_slug . '/' . $plugin_file);
788
789 if (is_wp_error($result)) {
790 throw new \Exception($result->get_error_message());
791 }
792 } catch (\Exception $e) {
793 }
794 }
795 }
796 }
797
798 private function associate_plugin_file($plugins, $key)
799 {
800 $path = explode('/', $key);
801 $filename = end($path);
802 $plugins[$filename] = $key;
803 return $plugins;
804 }
805
806 public function getBoards(Request $request)
807 {
808 $boards = Board::select(['id', 'title', 'type'])
809 ->byAccessUser(get_current_user_id())
810 ->orderBy('title', 'ASC')
811 ->get();
812
813 return $this->sendSuccess([
814 'boards' => $boards
815 ]);
816 }
817
818 public function getPages(Request $request)
819 {
820
821 $db = App::getInstance('db');
822
823 $allPages = $db->table('posts')->where('post_type', 'page')
824 ->where('post_status', 'publish')
825 ->select(['ID', 'post_title'])
826 ->orderBy('post_title', 'ASC')
827 ->get();
828
829 $pages = [];
830 foreach ($allPages as $page) {
831 $pages[] = [
832 'id' => $page->ID,
833 'title' => $page->post_title ? $page->post_title : __('(no title)', 'fluent-boards')
834 ];
835 }
836
837 return $this->sendSuccess([
838 'pages' => $pages
839 ]);
840 }
841
842 }
843