/**
* 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;
}
