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