/**
* constructor
*
* @param Doctrine_Query $query
*/
public function __construct(Doctrine_Query $query, $viewName)
{
$this->name = $viewName;
$this->query = $query;
$this->query->setView($this);
$this->conn = $query->getConnection();
}
/**
* constructor
*
* @param Doctrine_Query $query
*/
public function __construct(Doctrine_Query $query, $viewName)
{
$this->_name = $viewName;
$this->_query = $query;
$this->_query->setView($this);
$this->_conn = $query->getConnection();
$this->_dql = $query->getDql();
$this->_sql = $query->getSqlQuery();
}
private function update($table_name, $d, $id)
{
$tid = $id;
if (!is_array($id)) {
$tid = array('id' => $id);
}
$table = Doctrine::getTable($table_name);
$dq = new Doctrine_Query();
$conn = $dq->getConnection();
return $conn->update($table, $d, $tid);
}
/**
* Should return the database server name or source name
*
* Ex: mysql, pgsql, array, xml
*
* @return string
*/
public function getSourceName()
{
return strtolower($this->_query->getConnection()->getDriverName());
}
protected function modifyImpl(Doctrine_Query &$o)
{
if (!$this->ignoreIds) {
$table = $o->getConnection()->getTable($this->getTarget());
$keys = $table->getIdentifierColumnNames();
$o->addSelect(implode($keys));
} else {
$o->disableAutoIdentifierFields(true);
}
foreach ($this->additionalSelects as $alias => $select) {
$o->addSelect($select . (is_numeric($alias) ? "" : " AS " . $alias));
}
$db = $this->getContext()->getDatabaseManager()->getDatabase('icinga');
// check if retained state must be respected
if (method_exists($db, "useRetained")) {
/*
* the core with idomod dumps 2 different config types
* idomod.cfg:config_output_options
* 1 = original config => config_type = 0
* 2 = retained config => config_type = 1
* 3 = both, both config_types are available
*/
if ($this->retainedAlias) {
$o->andWhere($this->retainedAlias . ".config_type= ?", $db->useRetained() ? "1" : "0");
}
}
if ($this->getTarget() == "IcingaObjects") {
$o->andWhere($this->mainAlias . ".is_active = 1");
}
foreach ($this->forceGroup as $group) {
$o->addGroupBy($group);
}
parent::modifyImpl($o);
}
public function executeUpdateFilter(sfWebRequest $request)
{
$this->menu = $this->getMenu('index');
$this->informations = $this->getInformations();
$id = $request->getParameter('id');
$sql = <<<ENDSQL
\t\t\tSELECT domain, lists_id, ordre
\t\t\tFROM lists_filter
\t\t\tJOIN lists ON lists_filter.list_id = lists.id
\t\t\tJOIN lists_detail ON lists.id = lists_detail.lists_id
\t\t\tWHERE lists_filter.filter_id = '{$id}'
\t\t\tAND lists.origin = 'SI'
\t\t\tORDER BY ordre
ENDSQL;
$dq = new Doctrine_Query();
$conn = $dq->getConnection();
$filters_private_lists_res = $conn->fetchAll($sql);
foreach ($filters_private_lists_res as $filter) {
if ($filter['domain'] != '') {
switch ($filter['ordre']) {
case 0:
$globale_whitelist .= $filter['domain'] . "\n";
break;
case 1:
$globale_blacklist .= $filter['domain'] . "\n";
break;
case 2:
$private_whitelist .= $filter['domain'] . "\n";
break;
case 3:
$private_blacklist .= $filter['domain'] . "\n";
break;
case 4:
$other_blacklists[$filter['lists_id']] = $filter['lists_id'];
break;
}
}
}
$this->globale_whitelist = $globale_whitelist;
$this->globale_blacklist = $globale_blacklist;
$this->private_whitelist = $private_whitelist;
$this->private_blacklist = $private_blacklist;
// @TODO ////////////////////////////////////////////////////////////
$sql = <<<SQL
\t\t\tSELECT li.id, li.name, lf.ordre
\t\t\tFROM lists li
\t\t\t\tLEFT JOIN lists_filter lf ON li.id = lf.list_id
\t\t\tWHERE lf.filter_id = '{$id}'
\t\t\t\tAND li.origin != 'SI'
SQL;
$dq = new Doctrine_Query();
$conn = $dq->getConnection();
$filters_to = $conn->fetchAll($sql);
foreach ($filters_to as $filterT) {
$aaa = $filterT['id'];
$other_blacklists[$aaa] = $aaa;
}
$this->other_blacklists = $other_blacklists;
$this->aaa = $filters_to;
$lists = Doctrine_Query::create()->select('l.name, l.id')->from('Lists l')->where('origin != ?', 'SI')->orderBy('name')->execute();
$this->lists = $lists;
$filters = Doctrine_Query::create()->select('name, description, id')->from('Filter')->where('id = ?', $request->getParameter('id'))->execute();
$this->filters = $filters;
return;
}
