/** * @param DB $db The database object * @param array $modIDs The IDs of the modules for which the settings should be loaded * @param array $pageIDs The nested page IDs context * @return array The settings found sorted by module IDs */ public static function getSettingsForElements(DB $db, array $modIDs, array $pageIDs) { $params = array_merge($modIDs, $pageIDs, $pageIDs); $stmntSettings = $db->prepare("\n\t\t\tSELECT element_instance_IDFK, page_IDFK, url\n\t\t\tFROM element_iframe\n\t\t\tWHERE element_instance_IDFK IN (" . DB::createInQuery($modIDs) . ")\n\t\t\tAND page_IDFK IN (" . DB::createInQuery($pageIDs) . ")\n\t\t\tORDER BY FIELD(page_IDFK, " . DB::createInQuery($pageIDs) . ")\n\t\t"); $resSettings = $db->select($stmntSettings, $params); $settingsArr = array(); foreach ($resSettings as $res) { $settingsArr[$res->element_instance_IDFK][$res->page_IDFK] = $res; } return $settingsArr; }
/** * @param string $elementIdentifier * @param array $settings * @param DB $db * @param array $modIDs Module IDs to load settings for * @param array $pageIDs Page context IDs * @param string $elementInstanceColumn * @param string $pageInstanceColumn * @return array */ public static function loadCmsElementSettings($elementIdentifier, $settings, DB $db, array $modIDs, array $pageIDs, $elementInstanceColumn = 'element_instance_IDFK', $pageInstanceColumn = 'page_IDFK') { $params = array_merge($modIDs, $pageIDs, $pageIDs); $settingsCols = array(); foreach ($settings as $col => $as) { $settingsCols[] = $col . ' ' . $as; } $stmntSettings = $db->prepare("\n\t\t\tSELECT " . $elementInstanceColumn . ", " . $pageInstanceColumn . ", " . implode(', ', $settingsCols) . "\n\t\t\tFROM " . $elementIdentifier . "\n\t\t\tWHERE " . $elementInstanceColumn . " IN (" . DB::createInQuery($modIDs) . ")\n\t\t\tAND " . $pageInstanceColumn . " IN (" . DB::createInQuery($pageIDs) . ")\n\t\t\tORDER BY FIELD(" . $pageInstanceColumn . ", " . DB::createInQuery($pageIDs) . ")\n\t\t"); $resSettings = $db->select($stmntSettings, $params); $settingsArr = array(); foreach ($resSettings as $res) { $settingsArr[$res->{$elementInstanceColumn}][$res->{$pageInstanceColumn}] = $res; } return $settingsArr; }
/** * @param DB $db The database object * @param array $modIDs The IDs of the modules for which the settings should be loaded * @param array $pageIDs The nested page IDs context * @return array The settings found sorted by module IDs */ public static function getSettingsForElements(DB $db, array $modIDs, array $pageIDs) { //try { /*$pageIds = array(1);*/ $params = array_merge($modIDs, $pageIDs, $pageIDs); $stmntSettings = $db->prepare("\n\t\t\t\tSELECT mod_instance_IDFK, page_IDFK, east_grid_size, center_grid_size, west_grid_size,\n\t\t\t\t\tnorth_mod_IDFK, south_mod_IDFK, east_mod_IDFK, west_mod_IDFK, center_mod_IDFK\n\t\t\t\tFROM mod_border_layout\n\t\t\t\tWHERE mod_instance_IDFK IN (" . DB::createInQuery($modIDs) . ")\n\t\t\t\tAND page_IDFK IN (" . DB::createInQuery($pageIDs) . ")\n\t\t\t\tORDER BY FIELD(page_IDFK, " . DB::createInQuery($pageIDs) . ")\n\t\t\t"); $resSettings = $db->select($stmntSettings, $params); $settingsArr = array(); foreach ($resSettings as $res) { $settingsArr[$res->mod_instance_IDFK][$res->page_IDFK] = $res; } return $settingsArr; /*} catch(\Exception $e) { return false; }*/ }
/** * @param DB $db The database object * @param array $modIDs The IDs of the modules for which the settings should be loaded * @param array $pageIDs The nested page IDs context * @return array The settings found sorted by module IDs and page IDs */ public static function getSettingsForElements(DB $db, array $modIDs, array $pageIDs) { $params = array_merge($modIDs, $pageIDs, $pageIDs); $stmntSettings = $db->prepare("\n\t\t\tSELECT element_instance_IDFK, page_IDFK, navigation_IDFK, level_from, level_to, mode, class_name, show_active_stages_only\n\t\t\tFROM element_nav\n\t\t\tWHERE element_instance_IDFK IN (" . DB::createInQuery($modIDs) . ")\n\t\t\tAND page_IDFK IN (" . DB::createInQuery($pageIDs) . ")\n\t\t\tORDER BY FIELD (page_IDFK, " . DB::createInQuery($pageIDs) . ")\n\t\t"); $resSettings = $db->select($stmntSettings, $params); $settingsArr = array(); foreach ($resSettings as $res) { $settingsArr[$res->element_instance_IDFK][$res->page_IDFK] = $res; } return $settingsArr; }
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)); }
/** * 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; }
/** * Deletes the setting of itself for the current page * * @param DB $db * @param int $pageID */ public function deleteSettingsSelf(DB $db, $pageID) { $stmntDelete = $db->prepare("DELETE FROM " . $this->identifier . " WHERE element_instance_IDFK = ? AND page_IDFK = ?"); $db->delete($stmntDelete, array($this->ID, $pageID)); }
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)); } }
private function getPKColumnsForTable(DB $db, $tableName) { $stmntPK = $db->prepare("\n\t\t\t\tSELECT k.COLUMN_NAME\n\t\t\t\tFROM information_schema.table_constraints t\n\t\t\t\tLEFT JOIN information_schema.key_column_usage k\n\t\t\t\tUSING(constraint_name, table_schema, table_name)\n\t\t\t\tWHERE t.constraint_type = 'PRIMARY KEY'\n\t\t\t\tAND t.table_schema = DATABASE()\n\t\t\t\tAND t.table_name= ?\n\t\t\t"); $resPK = $db->select($stmntPK, array($tableName)); $pkArray = array(); foreach ($resPK as $pk) { $pkArray[] = $pk->COLUMN_NAME; } return $pkArray; }