'Bookmark', // Plugin Name 'author' => 'leet1994', // Who wrote the plugin 'category' => 'Utilities', // One to Two Word Description 'link' => '', // Link to plugin info 'license' => 'personal,business', // License Type use , for multiple 'idPrefix' => 'BOOKMARK', // html element id prefix 'configPrefix' => 'BOOKMARK', // config file prefix for array items without the hyphen 'dbPrefix' => 'BOOKMARK', // db prefix 'version' => '0.1.0', // SemVer of plugin 'image' => 'api/plugins/bookmark/logo.png', // 1:1 non transparent image for plugin 'settings' => true, // does plugin need a settings modal? 'bind' => true, // use default bind to make settings page - true or false 'api' => 'api/v2/plugins/bookmark/settings', // api route for settings page 'homepage' => false // Is plugin for use on homepage? true or false ); // Logo image under Public Domain from https://openclipart.org/detail/182527/open-book class Bookmark extends Organizr { public function _bookmarkGetOrganizrTabInfo() { $response = [ array( 'function' => 'fetch', 'query' => array( 'SELECT * FROM tabs', 'WHERE url = ?', 'api/v2/plugins/bookmark/page' ) ), ]; return $this->processQueries($response); } public function _bookmarkGetOrganizrTabGroupId() { $tab = $this->_bookmarkGetOrganizrTabInfo(); if ($tab) { return $tab['group_id']; } else { return 999; } } public function _checkRequest($request) { $result = false; if ($this->config['BOOKMARK-enabled'] && $this->hasDB()) { if (!$this->_checkDatabaseTablesExist()) { $this->_createDatabaseTables(); } $result = true; } return $result; } public function _checkDatabaseTablesExist() { if ($this->config['driver'] == 'sqlite3') { $queryCategories = ["SELECT `name` FROM `sqlite_master` WHERE `type` = 'table' AND `name` = 'BOOKMARK-categories'"]; $queryTabs = ["SELECT `name` FROM `sqlite_master` WHERE `type` = 'table' AND `name` = 'BOOKMARK-tabs'"]; } else { $queryCategories = ['SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_TYPE LIKE "BASE TABLE" AND TABLE_NAME = %s', (string)$this->config['dbName'], 'BOOKMARK-categories']; $queryTabs = ['SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_TYPE LIKE "BASE TABLE" AND TABLE_NAME = %s', (string)$this->config['dbName'], 'BOOKMARK-categories']; } $response = [ array( 'function' => 'fetchSingle', 'query' => $queryCategories, 'key' => 'BOOKMARK-categories' ), array( 'function' => 'fetchSingle', 'query' => $queryTabs, 'key' => 'BOOKMARK-tabs' ), ]; $data = $this->processQueries($response); return ($data["BOOKMARK-categories"] != false && $data["BOOKMARK-tabs"] != false); } protected function _createDatabaseTables() { $response = [ array( 'function' => 'query', 'query' => 'CREATE TABLE `BOOKMARK-categories` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, `order` INTEGER, `category` TEXT UNIQUE, `category_id` INTEGER, `default` INTEGER );' ), array( 'function' => 'query', 'query' => 'CREATE TABLE `BOOKMARK-tabs` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, `order` INTEGER, `category_id` INTEGER, `name` TEXT, `url` TEXT, `enabled` INTEGER, `group_id` INTEGER, `image` TEXT, `background_color` TEXT, `text_color` TEXT );' ) ]; $this->processQueries($response); } public function _getSettings() { return array( 'custom' => '

Automatic Setup Tasks

Checking for Bookmark tab...
Checking for bookmark default category...

Notice

Add tab that points to api/v2/plugins/bookmark/page and set it\'s type to Organizr.
Create Bookmark categories in the new area in Tab Editor.
Create Bookmark tabs in the new area in Tab Editor.
Open your custom Bookmark page via menu.

' ); } public function _getPage() { $bookmarks = '

'; foreach ($this->_getAllCategories() as $category) { $tabs = $this->_getRelevantTabsForCategory($category['category_id']); if (count($tabs) == 0) continue; $bookmarks .= '

' . $category['category'] . '

'; foreach ($tabs as $tab) { $bookmarks .= '

' . $this->_iconPrefix($tab['image']) . ' ' . $tab['name'] . '

'; } $bookmarks .= '

'; return $bookmarks; } protected function _iconPrefix($source) { $tabIcon = explode("::", $source); $icons = array( "materialize" => "mdi mdi-", "fontawesome" => "fa fa-", "themify" => "ti-", "simpleline" => "icon-", "weathericon" => "wi wi-", "alphanumeric" => "fa-fw", ); if (is_array($tabIcon) && count($tabIcon) == 2) { if ($tabIcon[0] !== 'url' && $tabIcon[0] !== 'alphanumeric') { return ''; } else if ($tabIcon[0] == 'alphanumeric') { return '' . $tabIcon[1] . ''; } else { return ' tabIcon

'; } } else { return ' tabIcon

'; } } protected function _getAllCategories() { $response = [ array( 'function' => 'fetchAll', 'query' => 'SELECT * FROM `BOOKMARK-categories` ORDER BY `order` ASC' ) ]; return $this->processQueries($response); } protected function _getRelevantTabsForCategory($category_id) { $response = [ array( 'function' => 'fetchAll', 'query' => array( "SELECT * FROM `BOOKMARK-tabs` WHERE `enabled`='1' AND `category_id`=? AND `group_id`>=? ORDER BY `order` ASC", $category_id, $this->getUserLevel() ) ) ]; return $this->processQueries($response); } public function _getTabs() { $response = [ array( 'function' => 'fetchAll', 'query' => 'SELECT * FROM `BOOKMARK-tabs` ORDER BY `order` ASC', 'key' => 'tabs' ), array( 'function' => 'fetchAll', 'query' => 'SELECT * FROM `BOOKMARK-categories` ORDER BY `order` ASC', 'key' => 'categories' ), array( 'function' => 'fetchAll', 'query' => 'SELECT * FROM `groups` ORDER BY `group_id` ASC', 'key' => 'groups' ) ]; return $this->processQueries($response); } // Tabs public function _getSettingsTabEditorBookmarkTabsPage() { $iconSelectors = ' $(".bookmarkTabIconIconList").select2({ ajax: { url: \'api/v2/icon\', data: function (params) { var query = { search: params.term, page: params.page || 1 } return query; }, processResults: function (data, params) { params.page = params.page || 1; return { results: data.response.data.results, pagination: { more: (params.page * 20) < data.response.data.total } }; }, //cache: true }, placeholder: \'Search for an icon\', templateResult: formatIcon, templateSelection: formatIcon }); $(".bookmarkTabIconImageList").select2({ ajax: { url: \'api/v2/image/select\', data: function (params) { var query = { search: params.term, page: params.page || 1 } return query; }, processResults: function (data, params) { params.page = params.page || 1; return { results: data.response.data.results, pagination: { more: (params.page * 20) < data.response.data.total } }; }, //cache: true }, placeholder: \'Search for an image\', templateResult: formatImage, templateSelection: formatImage }); '; return '

Bookmark Tab Editor

'; } public function _isBookmarkTabNameTaken($name, $id = null) { if ($id) { $response = [ array( 'function' => 'fetchAll', 'query' => array( 'SELECT * FROM `BOOKMARK-tabs` WHERE `name` LIKE ? AND `id` != ?', $name, $id ) ), ]; } else { $response = [ array( 'function' => 'fetchAll', 'query' => array( 'SELECT * FROM `BOOKMARK-tabs` WHERE `name` LIKE ?', $name ) ), ]; } return $this->processQueries($response); } public function _getNextBookmarkTabOrder() { $response = [ array( 'function' => 'fetchSingle', 'query' => array( 'SELECT `order` from `BOOKMARK-tabs` ORDER BY `order` DESC' ) ), ]; return $this->processQueries($response); } public function _getBookmarkTabById($id) { $response = [ array( 'function' => 'fetch', 'query' => array( 'SELECT * FROM `BOOKMARK-tabs` WHERE `id` = ?', $id ) ), ]; return $this->processQueries($response); } public function _getTabByIdCheckUser($id) { $tabInfo = $this->_getBookmarkTabById($id); if ($tabInfo) { if ($this->qualifyRequest($tabInfo['group_id'], true)) { return $tabInfo; } } else { $this->setAPIResponse('error', 'id not found', 404); return false; } } public function _deleteTab($id) { $response = [ array( 'function' => 'query', 'query' => array( 'DELETE FROM `BOOKMARK-tabs` WHERE id = ?', $id ) ), ]; $tabInfo = $this->_getBookmarkTabById($id); if ($tabInfo) { $this->setLoggerChannel('Bookmark')->info('Deleted Bookmark [' . $tabInfo['name'] . ']'); $this->setAPIResponse('success', 'Tab deleted', 204); return $this->processQueries($response); } else { $this->setAPIResponse('error', 'id not found', 404); return false; } } public function _addTab($array) { if (!$array) { $this->setAPIResponse('error', 'no data was sent', 422); return null; } $array = $this->checkKeys($this->getTableColumnsFormatted('BOOKMARK-tabs'), $array); $array['group_id'] = ($array['group_id']) ?? $this->getDefaultGroupId(); $array['category_id'] = ($array['category_id']) ?? $this->_getDefaultBookmarkCategoryId(); $array['enabled'] = ($array['enabled']) ?? 0; $array['order'] = ($array['order']) ?? $this->_getNextBookmarkTabOrder() + 1; if (array_key_exists('name', $array)) { $array['name'] = $this->sanitizeUserString($array['name']); if ($this->_isBookmarkTabNameTaken($array['name'])) { $this->setAPIResponse('error', 'Tab name: ' . $array['name'] . ' is already taken', 409); return false; } if (!$this->qualifyLength($array['name'], 50, true)) { return false; } } else { $this->setAPIResponse('error', 'Tab name was not supplied', 422); return false; } if (!array_key_exists('url', $array)) { $this->setAPIResponse('error', 'Tab url was not supplied', 422); return false; } if (!array_key_exists('image', $array)) { $this->setAPIResponse('error', 'Tab image was not supplied', 422); return false; } else { $array['image'] = $this->sanitizeUserString($array['image']); } if (array_key_exists('background_color', $array)) { $array['background_color'] = $this->sanitizeUserString($array['background_color']); if (!$this->_checkColorHexCode($array['background_color'])) { $this->setAPIResponse('error', 'Tab background color is invalid', 422); return false; } } else { $this->setAPIResponse('error', 'Tab background color was not supplied', 422); return false; } if (array_key_exists('text_color', $array)) { $array['text_color'] = $this->sanitizeUserString($array['text_color']); if (!$this->_checkColorHexCode($array['text_color'])) { $this->setAPIResponse('error', 'Tab text color is invalid', 422); return false; } } else { $this->setAPIResponse('error', 'Tab text color was not supplied', 422); return false; } $response = [ array( 'function' => 'query', 'query' => array( 'INSERT INTO [BOOKMARK-tabs]', $array ) ), ]; $this->setAPIResponse(null, 'Tab added'); $this->setLoggerChannel('Bookmark')->info('Added Bookmark [' . $array['name'] . ']'); return $this->processQueries($response); } public function _updateTab($id, $array) { if (!$id || $id == '') { $this->setAPIResponse('error', 'id was not set', 422); return null; } if (!$array) { $this->setAPIResponse('error', 'no data was sent', 422); return null; } $tabInfo = $this->_getBookmarkTabById($id); if ($tabInfo) { $array = $this->checkKeys($tabInfo, $array); } else { $this->setAPIResponse('error', 'No tab info found', 404); return false; } if (array_key_exists('name', $array)) { $array['name'] = $this->sanitizeUserString($array['name']); if ($this->_isBookmarkTabNameTaken($array['name'], $id)) { $this->setAPIResponse('error', 'Tab name: ' . $array['name'] . ' is already taken', 409); return false; } if (!$this->qualifyLength($array['name'], 50, true)) { return false; } } if (array_key_exists('background_color', $array)) { $array['background_color'] = $this->sanitizeUserString($array['background_color']); if (!$this->_checkColorHexCode($array['background_color'])) { $this->setAPIResponse('error', 'Tab background color is invalid', 422); return false; } } if (array_key_exists('text_color', $array)) { $array['text_color'] = $this->sanitizeUserString($array['text_color']); if (!$this->_checkColorHexCode($array['text_color'])) { $this->setAPIResponse('error', 'Tab text color is invalid', 422); return false; } } if (array_key_exists('image', $array)) { $array['image'] = $this->sanitizeUserString($array['image']); } $response = [ array( 'function' => 'query', 'query' => array( 'UPDATE `BOOKMARK-tabs` SET', $array, 'WHERE id = ?', $id ) ), ]; $this->setAPIResponse(null, 'Tab info updated'); $this->setLoggerChannel('Bookmark')->info('Edited Bookmark [' . $tabInfo['name'] . ']'); return $this->processQueries($response); } public function _updateTabOrder($array) { if (count($array) >= 1) { foreach ($array as $tab) { if (count($tab) !== 2) { $this->setAPIResponse('error', 'data is malformed', 422); break; } $id = $tab['id'] ?? null; $order = $tab['order'] ?? null; if ($id && $order) { $response = [ array( 'function' => 'query', 'query' => array( 'UPDATE `BOOKMARK-tabs` set `order` = ? WHERE `id` = ?', $order, $id ) ), ]; $this->processQueries($response); $this->setAPIResponse(null, 'Tab Order updated'); } else { $this->setAPIResponse('error', 'data is malformed', 422); } } } else { $this->setAPIResponse('error', 'data is empty or not in array', 422); return false; } } // Categories public function _getSettingsTabEditorBookmarkCategoriesPage() { return '

Bookmark Category Editor

'; } public function _getDefaultBookmarkCategoryId() { $response = [ array( 'function' => 'fetchSingle', 'query' => array( 'SELECT `category_id` FROM `BOOKMARK-categories` WHERE `default` = 1' ) ), ]; return $this->processQueries($response); } public function _getNextBookmarkCategoryOrder() { $response = [ array( 'function' => 'fetchSingle', 'query' => array( 'SELECT `order` from `BOOKMARK-categories` ORDER BY `order` DESC' ) ), ]; return $this->processQueries($response); } public function _getNextBookmarkCategoryId() { $response = [ array( 'function' => 'fetchSingle', 'query' => array( 'SELECT `category_id` from `BOOKMARK-categories` ORDER BY `category_id` DESC' ) ), ]; return $this->processQueries($response); } public function _isBookmarkCategoryNameTaken($name, $id = null) { if ($id) { $response = [ array( 'function' => 'fetchAll', 'query' => array( 'SELECT * FROM `BOOKMARK-categories` WHERE `category` LIKE ? AND `id` != ?', $name, $id ) ), ]; } else { $response = [ array( 'function' => 'fetchAll', 'query' => array( 'SELECT * FROM `BOOKMARK-categories` WHERE `category` LIKE ?', $name ) ), ]; } return $this->processQueries($response); } public function _getBookmarkCategoryById($id) { $response = [ array( 'function' => 'fetch', 'query' => array( 'SELECT * FROM `BOOKMARK-categories` WHERE `id` = ?', $id ) ), ]; return $this->processQueries($response); } public function _clearBookmarkCategoryDefault() { $response = [ array( 'function' => 'query', 'query' => array( 'UPDATE `BOOKMARK-categories` SET `default` = 0' ) ), ]; return $this->processQueries($response); } public function _addCategory($array) { if (!$array) { $this->setAPIResponse('error', 'no data was sent', 422); return null; } $array = $this->checkKeys($this->getTableColumnsFormatted('BOOKMARK-categories'), $array); $array['default'] = ($array['default']) ?? 0; $array['order'] = ($array['order']) ?? $this->_getNextBookmarkCategoryOrder() + 1; $array['category_id'] = ($array['category_id']) ?? $this->_getNextBookmarkCategoryId() + 1; if (array_key_exists('category', $array)) { $array['category'] = $this->sanitizeUserString($array['category']); if ($this->_isBookmarkCategoryNameTaken($array['category'])) { $this->setAPIResponse('error', 'Category name: ' . $array['category'] . ' is already taken', 409); return false; } if (!$this->qualifyLength($array['category'], 50, true)) { return false; } } else { $this->setAPIResponse('error', 'Category name was not supplied', 422); return false; } $response = [ array( 'function' => 'query', 'query' => array( 'INSERT INTO [BOOKMARK-categories]', $array ) ), ]; $this->setAPIResponse(null, 'Category added'); $this->setLoggerChannel('Bookmark')->info('Added Bookmark Category [' . $array['category'] . ']'); $result = $this->processQueries($response); $this->_correctDefaultCategory(); return $result; } public function _updateCategory($id, $array) { if (!$id || $id == '') { $this->setAPIResponse('error', 'id was not set', 422); return null; } if (!$array) { $this->setAPIResponse('error', 'no data was sent', 422); return null; } $categoryInfo = $this->_getBookmarkCategoryById($id); if ($categoryInfo) { $array = $this->checkKeys($categoryInfo, $array); } else { $this->setAPIResponse('error', 'No category info found', 404); return false; } if (array_key_exists('category', $array)) { $array['category'] = $this->sanitizeUserString($array['category']); if ($this->_isBookmarkCategoryNameTaken($array['category'], $id)) { $this->setAPIResponse('error', 'Category name: ' . $array['category'] . ' is already taken', 409); return false; } if (!$this->qualifyLength($array['category'], 50, true)) { return false; } } if (array_key_exists('default', $array)) { if ($array['default']) { $this->_clearBookmarkCategoryDefault(); } } $response = [ array( 'function' => 'query', 'query' => array( 'UPDATE `BOOKMARK-categories` SET', $array, 'WHERE id = ?', $id ) ), ]; $this->setAPIResponse(null, 'Category info updated'); $this->setLoggerChannel('Bookmark')->info('Edited Bookmark Category [' . $categoryInfo['category'] . ']'); $result = $this->processQueries($response); $this->_correctDefaultCategory(); return $result; } public function _updateCategoryOrder($array) { if (count($array) >= 1) { foreach ($array as $category) { if (count($category) !== 2) { $this->setAPIResponse('error', 'data is malformed', 422); break; } $id = $category['id'] ?? null; $order = $category['order'] ?? null; if ($id && $order) { $response = [ array( 'function' => 'query', 'query' => array( 'UPDATE `BOOKMARK-categories` set `order` = ? WHERE `id` = ?', $order, $id ) ), ]; $this->processQueries($response); $this->setAPIResponse(null, 'Category Order updated'); } else { $this->setAPIResponse('error', 'data is malformed', 422); } } } else { $this->setAPIResponse('error', 'data is empty or not in array', 422); return false; } } public function _deleteCategory($id) { $response = [ array( 'function' => 'query', 'query' => array( 'DELETE FROM `BOOKMARK-categories` WHERE id = ?', $id ) ), ]; $categoryInfo = $this->_getBookmarkCategoryById($id); if ($categoryInfo) { $this->setLoggerChannel('Bookmark')->info('Deleted Bookmark Category [' . $categoryInfo['category'] . ']'); $this->setAPIResponse('success', 'Category deleted', 204); $result = $this->processQueries($response); $this->_correctDefaultCategory(); return $result; } else { $this->setAPIResponse('error', 'id not found', 404); return false; } } protected function _correctDefaultCategory() { if ($this->_getDefaultBookmarkCategoryId() == null) { $response = [ array( 'function' => 'query', 'query' => 'UPDATE `BOOKMARK-categories` SET `default` = 1 WHERE `category_id` = (SELECT `category_id` FROM `BOOKMARK-categories` ORDER BY `category_id` ASC LIMIT 0,1)' ) ]; return $this->processQueries($response); } } protected function _checkColorHexCode($hex) { return preg_match('/^\#([0-9a-fA-F]{3}){1,2}$/', $hex); } /** * Increases or decreases the brightness of a color by a percentage of the current brightness. * * @param string $hexCode Supported formats: `#FFF`, `#FFFFFF`, `FFF`, `FFFFFF` * @param float $adjustPercent A number between -1 and 1. E.g. 0.3 = 30% lighter; -0.4 = 40% darker. * * @return string * * @author maliayas * @link https://stackoverflow.com/questions/3512311/how-to-generate-lighter-darker-color-with-php */ protected function adjustBrightness($hexCode, $adjustPercent) { $hexCode = ltrim($hexCode, '#'); if (strlen($hexCode) == 3) { $hexCode = $hexCode[0] . $hexCode[0] . $hexCode[1] . $hexCode[1] . $hexCode[2] . $hexCode[2]; } $hexCode = array_map('hexdec', str_split($hexCode, 2)); foreach ($hexCode as &$color) { $adjustableLimit = $adjustPercent < 0 ? $color : 255 - $color; $adjustAmount = ceil($adjustableLimit * $adjustPercent); $color = str_pad(dechex($color + $adjustAmount), 2, '0', STR_PAD_LEFT); } return '#' . implode($hexCode); } public function _checkForBookmarkTab() { $response = [ array( 'function' => 'fetchAll', 'query' => array( 'SELECT * FROM tabs', 'WHERE url = ?', 'api/v2/plugins/bookmark/page' ) ), ]; $tab = $this->processQueries($response); if ($tab) { $this->setAPIResponse('success', 'Tab already exists', 200); return $tab; } else { $createTab = $this->_createBookmarkTab(); if ($createTab) { $tab = $this->processQueries($response); $this->setAPIResponse('success', 'Tab created', 200); return $tab; } else { $this->setAPIResponse('error', 'Tab creation error', 500); } } } public function _createBookmarkTab() { $tabInfo = [ 'order' => $this->getNextTabOrder() + 1, 'category_id' => $this->getDefaultCategoryId(), 'name' => 'Bookmarks', 'url' => 'api/v2/plugins/bookmark/page', 'default' => false, 'enabled' => true, 'group_id' => $this->getDefaultGroupId(), 'image' => 'fontawesome::book', 'type' => 0 ]; $response = [ array( 'function' => 'query', 'query' => array( 'INSERT INTO [tabs]', $tabInfo ) ), ]; return $this->processQueries($response); } public function _checkForBookmarkCategories() { $categories = $this->_getAllCategories(); if ($categories) { $this->setAPIResponse('success', 'Categories already exists', 200); return $categories; } else { $createCategory = $this->_addCategory(['category' => 'Unsorted', 'default' => 1]); if ($createCategory) { $categories = $this->_getAllCategories(); $this->setAPIResponse('success', 'Category created', 200); return $categories; } else { $this->setAPIResponse('error', 'Category creation error', 500); } } } }

Automatic Setup Tasks

Add New Tab

Edit Tab

Add New Bookmark Category

Edit Category