/**
* Creates a new element instance and stores its configuration
*
* @param DB $db
*
* @return bool
* @throws CMSException
* @throws \Exception
*/
public function create(DB $db)
{
try {
// For default we create the instance in db... has to be overwritten if the module has any settings
$stmntModID = $db->prepare("SELECT ID FROM cms_element_available WHERE name = ? AND active = 1");
$resModID = $db->select($stmntModID, array($this->identifier));
if (count($resModID) <= 0) {
throw new CMSException('Could not create module with identifier: "' . $this->identifier . '"');
}
$stmntCreateInstance = $db->prepare("\n\t\t\t\tINSERT INTO cms_element_instance SET mod_IDFK = ?, parent_mod_IDFK = ?, creator_IDFK = ?, created = NOW(), page_IDFK = ?\n\t\t\t");
$this->ID = $db->insert($stmntCreateInstance, array($resModID[0]->ID, $this->parentElement !== null ? $this->parentElement->getID() : null, $this->creatorID, $this->pageID));
} catch (DBException $e) {
throw new CMSException('Could not create module cause of DB error: ' . $e->getMessage() . ', Query: ' . $e->getQueryString());
}
return true;
}
protected function getChildElements(CmsElement $element, \ArrayObject $elementInstances)
{
$childElements = array();
foreach ($elementInstances as $m) {
/** @var CmsElement $m */
if ($m->getParentElementID() != $element->getID()) {
continue;
}
if ($m instanceof LayoutElement) {
$m->setElements($this->getChildElements($m, $elementInstances));
}
$childElements[$m->getID()] = $m;
}
return $childElements;
}
/**
* @param CmsElement $cmsElement
* @param string $revision
*/
private function updateElementRevision(CmsElement $cmsElement, $revision)
{
$stmntSetRev = $this->db->prepare("\n\t\t\tUPDATE cms_element_instance\n\t\t\tSET revision = ?\n\t\t\tWHERE ID = ? AND page_IDFK = ?\n\t\t");
$this->db->update($stmntSetRev, array($revision, $cmsElement->getID(), $cmsElement->getPageID()));
}
public function __construct($ID, $pageID)
{
parent::__construct($ID, $pageID, 'element_display_mod');
}
public function __construct($ID, $pageID)
{
parent::__construct($ID, $pageID, 'element_sitetitle');
}
/**
* @param DB $db
*/
public function remove(DB $db)
{
$stmntRemoveElementSettings = $db->prepare("DELETE FROM " . $this->identifier . " WHERE element_instance_IDFK = ?");
$db->delete($stmntRemoveElementSettings, array($this->ID));
parent::remove($db);
}
public function reorderElements(DB $db, CmsElement $movedCmsElement, $dropZoneID, array $elementOrder)
{
// Remove all from column
$colNo = (int) StringUtils::afterFirst($dropZoneID, 'column-') + 1;
$this->logger->debug('-- Reorder module in column: ' . $colNo);
$stmntRemove = $db->prepare("\n\t\t\tDELETE FROM element_column_layout_module WHERE col = ? AND page_IDFK = ? AND element_column_layout_IDFK = ?\n\t\t");
$deletedElements = $db->delete($stmntRemove, array($colNo, $this->pageID, $this->ID));
$this->logger->debug('Deleted ' . $deletedElements . ' elements');
// Remove the element itself (cause of PK crashes)
$stmntRemoveOriginal = $db->prepare("\n\t\t\tDELETE FROM element_column_layout_module WHERE element_column_layout_IDFK = ? AND page_IDFK = ? AND element_instance_IDFK = ?\n\t\t");
$deletedOriginal = $db->delete($stmntRemoveOriginal, array($this->ID, $movedCmsElement->getPageID(), $movedCmsElement->getID()));
$this->logger->debug('Deleted ' . $deletedOriginal . ' original element');
// Add the new order
$stmntInsert = $db->prepare("\n\t\t\tINSERT IGNORE INTO element_column_layout_module\n\t\t\t\tSET element_column_layout_IDFK = ?, page_IDFK = ?, col = ?, element_instance_IDFK = ?, sort = ?\n\t\t");
$stmntUpdate = $db->prepare("UPDATE cms_element_instance SET parent_mod_IDFK = ? WHERE ID = ?");
$this->logger->debug('Add those modules', array($elementOrder));
foreach ($elementOrder as $k => $e) {
$this->logger->debug('Added module: ' . $e);
$eParts = explode('-', $e);
if (isset($eParts[0]) === false) {
continue;
}
$db->update($stmntUpdate, array($this->ID, $eParts[0]));
$db->insert($stmntInsert, array($this->ID, $this->pageID, $colNo, $eParts[0], $k + 1));
}
}
protected static function getSettingsAsStr(CmsElement $mod)
{
if ($mod instanceof CmsElementSettingsLoadable === false) {
return '(no settings)';
}
/** @var CmsElementSettingsLoadable $mod */
if ($mod->hasSettings() === false) {
return '(no settings found)';
}
$settingsStr = '';
foreach ($mod->getSettings() as $k => $v) {
if (in_array($k, array('mod_instance_IDFK'))) {
continue;
}
$value = htmlentities(strip_tags(print_r($v, true)));
$value = strlen($value) > 254 ? substr($value, 0, 254) . ' [...]' : $value;
$settingsStr .= $k . ': ' . $value . "\n";
}
return $settingsStr;
}
/**
* @param array $elements
* @param array $elementInstances
* @param CmsElement|null $parentElement
* @return array The elements for the current parent element
*/
private function createTree(array $elements, array $elementInstances, $parentElement = null)
{
$elementTree = array();
foreach ($elements as $e) {
// Not interesting yet
if ($parentElement == null && $e->parent_element_ID != null || $parentElement != null && $e->parent_element_ID != $parentElement->getID()) {
continue;
}
/** @var CmsElement $elementInstance */
$elementInstance = $elementInstances[$e->ID];
if ($parentElement !== null) {
$elementInstance->setParentElement($parentElement);
}
$elementInstance->setParentElementID($parentElement != null ? $parentElement->getID() : null);
if ($elementInstance instanceof LayoutElement) {
/** @var LayoutElement $elementInstance */
$subElementTree = $this->createTree($elements, $elementInstances, $elementInstance);
$elementInstance->setElements($subElementTree);
}
$elementTree[$e->ID] = $elementInstance;
}
return $elementTree;
}