/** * Save widget settings * * @param array $widget * string widget_name * integer widget_id * integer page_id * integer id * @param array $settingsList * @param array $formData * @param string $currentlanguage * @return boolean|string */ public function saveWidgetSettings(array $widget, array $settingsList, array $formData, $currentlanguage) { try { $this->adapter->getDriver()->getConnection()->beginTransaction(); $widgetId = $widget['widget_id']; $pageId = $widget['page_id']; $widgetConnectionId = $widget['id']; $this->updateStructurePageEditedDate($pageId); // update primary widget settings $update = $this->update()->table('page_widget_connection')->set(['title' => !empty($formData['title']) ? $formData['title'] : null, 'layout' => !empty($formData['layout']) ? $formData['layout'] : null, 'cache_ttl' => !empty($formData['cache_ttl']) ? $formData['cache_ttl'] : 0])->where(['id' => $widgetConnectionId]); $statement = $this->prepareStatementForSqlObject($update); $statement->execute(); // update extra widget settings foreach ($settingsList as $setting) { if (array_key_exists($setting['name'], $formData)) { // remove previously value $query = $this->delete('page_widget_setting_value')->where(['setting_id' => $setting['id'], 'widget_connection' => $widgetConnectionId]); $statement = $this->prepareStatementForSqlObject($query); $statement->execute(); $value = is_array($formData[$setting['name']]) ? implode(PageWidgetSetting::SETTINGS_ARRAY_DEVIDER, $formData[$setting['name']]) : (null != $formData[$setting['name']] ? $formData[$setting['name']] : ''); $query = $this->insert('page_widget_setting_value')->values(['setting_id' => $setting['id'], 'value' => $value, 'widget_connection' => $widgetConnectionId]); $statement = $this->prepareStatementForSqlObject($query); $statement->execute(); } } // clear all widget old visibility settings $delete = $this->delete()->from('page_widget_visibility')->where(['widget_connection' => $widgetConnectionId]); $statement = $this->prepareStatementForSqlObject($delete); $result = $statement->execute(); // add new widget visibility settings if (!empty($formData['visibility_settings'])) { foreach ($formData['visibility_settings'] as $aclRoleId) { $insert = $this->insert()->into('page_widget_visibility')->values(['widget_connection' => $widgetConnectionId, 'hidden' => $aclRoleId]); $statement = $this->prepareStatementForSqlObject($insert); $statement->execute(); } } // clear caches $this->clearLanguageSensitivePageCaches(); $this->clearWidgetsSettingsCache($pageId, $currentlanguage); $dynamicCache = $this->serviceLocator->get('Application\\Cache\\Dynamic'); $widgetCacheName = CacheUtility::getCacheName($widget['widget_name'], [$widgetConnectionId]); if ($dynamicCache->hasItem($widgetCacheName)) { $dynamicCache->removeItem($widgetCacheName); } $this->adapter->getDriver()->getConnection()->commit(); } catch (Exception $e) { $this->adapter->getDriver()->getConnection()->rollback(); ApplicationErrorLogger::log($e); return $e->getMessage(); } PageEvent::fireEditWidgetSettingsEvent($widgetId, $pageId); return true; }