public function update(DB $db, stdClass $newSettings, $pageID)
{
$stmntUpdate = $db->prepare("\n\t\t\tREPLACE INTO element_nav\n\t\t\tSET element_instance_IDFK = ?, page_IDFK = ?, navigation_IDFK = ?, level_from = ?, level_to = ?, mode = ?, class_name = ?, show_active_stages_only = ?\n\t\t");
$db->update($stmntUpdate, array($this->ID, $pageID, $newSettings->navigation_IDFK, strlen($newSettings->level_from) > 0 && is_numeric($newSettings->level_from) ? $newSettings->level_from : null, strlen($newSettings->level_to) > 0 && is_numeric($newSettings->level_to) ? $newSettings->level_to : null, $newSettings->mode, strlen($newSettings->class_name) > 0 ? $newSettings->class_name : null, isset($newSettings->show_active_stages_only) ? 1 : 0));
}
public function update(DB $db, \stdClass $newSettings, $pageID)
{
$stmntUpdate = $db->prepare("\n\t\t\tINSERT INTO " . $this->identifier . "\n\t\t\t\tSET element_instance_IDFK = ?, page_IDFK = ?, text = ?\n\t\t\tON DUPLICATE KEY\n\t\t\t\tUPDATE text = ?\n\t\t");
$db->update($stmntUpdate, array($this->ID, $pageID, $newSettings->text, $newSettings->text));
}
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));
}
}
public function update(DB $db, stdClass $newSettings, $pageID)
{
$stmntUpdate = $db->prepare("\n\t\t\tREPLACE INTO element_nav_title\n\t\t\tSET element_instance_IDFK = ?, page_IDFK = ?, navigation_IDFK = ?, level = ?\n\t\t");
$db->update($stmntUpdate, array($this->ID, $pageID, $newSettings->navigation_IDFK, $newSettings->level));
}
public function update(DB $db, stdClass $newSettings, $pageID)
{
$stmntUpdateSettings = $db->prepare("\n\t\t\tINSERT INTO " . $this->identifier . " SET\n\t\t\t\telement_instance_IDFK = ?, page_IDFK = ?, url = ?\n\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\turl = ?\n\t\t");
$db->update($stmntUpdateSettings, array($this->ID, $pageID, $newSettings->url, $newSettings->url));
}
