/** * (non-PHPdoc) * * @see \Contentinum\Service\WebsiteServiceFactory::queryDbCacheResult() */ protected function queryDbCacheResult($config, $sl) { $result = array(); $cache = $sl->get(static::CONTENTINUM_CACHE); $key = $config['cache']; if (!($result = $cache->getItem($key))) { $worker = new Worker($sl->get($config['entitymanager'])); $conn = $worker->getConnection(); $sql = "SELECT main.web_contentgroup_id, wc.title, wc.id, wpp.label "; $sql .= "FROM web_content_groups AS main "; $sql .= "LEFT JOIN web_content AS wc ON wc.id = main.web_content_id "; $sql .= "LEFT JOIN web_pages_content AS wpc ON wpc.web_contentgroup_id = main.web_contentgroup_id "; $sql .= "LEFT JOIN web_pages_parameter AS wpp ON wpp.id = wpc.web_pages_id "; $sql .= "WHERE main.scope = 'content' "; $sql .= "GROUP BY main.web_contentgroup_id "; $sql .= "ORDER BY wc.title ASC"; $entries = $conn->query($sql)->fetchAll(); $tmp = array(); foreach ($entries as $entry) { $tmp[$entry['web_contentgroup_id']] = array('name' => '(' . $entry['label'] . ') - ' . $entry['title']); } $result = new Config($tmp); if (isset($config['savecache']) && true === $config['savecache']) { $cache->setItem($key, $result); } } return $result; }
/** * (non-PHPdoc) * * @see \Contentinum\Service\WebsiteServiceFactory::queryDbCacheResult() */ protected function queryDbCacheResult($config, $sl) { $result = array(); $cache = $sl->get(static::CONTENTINUM_CACHE); $key = $config['cache']; if (!($result = $cache->getItem($key))) { $worker = new Worker($sl->get($config['entitymanager'])); $conn = $worker->getConnection(); $sql = "SELECT main.id, main.organisation, main.organisation_ext "; $sql .= "FROM accounts AS main "; $sql .= "ORDER BY main.organisation ASC"; $entries = $conn->query($sql)->fetchAll(); $tmp = array(); foreach ($entries as $entry) { $tmp[$entry['id']] = array('name' => $entry['organisation'] . ', ' . $entry['organisation_ext']); } $result = new Config($tmp); if (isset($config['savecache']) && true === $config['savecache']) { $cache->setItem($key, $result); } } return $result; }