/**
* Initializes the database with the init data for the data query.
*/
public function init()
{
// create config entries
$queryExamplesModel = new Query_Model_Examples();
if ($queryExamplesModel->getResource()->countRows() == 0) {
foreach ($this->_init->options['init']['query']['examples'] as $a) {
$a['publication_role_id'] = Daiquiri_Auth::getInstance()->getRoleId($a['publication_role']);
unset($a['publication_role']);
$r = $queryExamplesModel->create($a);
$this->_check($r, $a);
}
}
}
/**
* Returns all examples which the user has access to.
* @return array $response
*/
public function examples()
{
$model = new Query_Model_Examples();
$rows = array();
foreach ($model->getResource()->fetchRows(array('order' => 'order ASC')) as $dbRow) {
if (Daiquiri_Auth::getInstance()->checkPublicationRoleId($dbRow['publication_role_id'])) {
$rows[] = array('id' => $dbRow['id'], 'name' => $dbRow['name'], 'value' => $dbRow['query'], 'order' => $dbRow['order']);
}
}
return array('examples' => $rows, 'status' => 'ok');
}