Icinga\Module\TrapDirector\Tables\HandlerTableList

Complexity

Total Complexity

29

Size/Duplication

Total Lines	247
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	1

13 Methods

Rating	Name	Duplication	Size	Complexity
A	setMibloader()	0	4	1
A	getTable()	0	11	3
A	__toString()	0	3	1
A	getBaseQuery()	0	10	1
A	getTitles()	0	2	1
A	setFilter()	0	4	1
A	getFilterEditor()	0	13	1
A	getColumns()	0	3	1
C	render()	0	100	15
A	count()	0	15	1
A	getPaginator()	0	6	1
A	applyFiltersToQuery()	0	20	1
A	getSearchColumns()	0	3	1

<?php

namespace Icinga\Module\TrapDirector\Tables;

use Icinga\Web\Request;
use Icinga\Web\Url;
use Icinga\Web\Widget;
use Icinga\Web\Widget\Paginator;

use Icinga\Module\Trapdirector\Tables\TrapTable;



class HandlerTableList extends TrapTable
{	
	// Db connection : getConnection / setConnection
	protected $connection;
	
	// translate
	protected $doTranslate=false;
	protected $MIB;
	
	// status
	protected $status_display=array(
		-2	=>'ignore',
		-1 => '-',
		0	=> 'OK',
		1	=> 'warning',
		2	=> 'critical',
		3	=> 'unknown',);
	
	// Filters 
	
    protected $filter;
    protected $enforcedFilters = array();
    protected $searchColumns = array();
	
	protected function getTitles() {
		return $this->moduleConfig->getHandlerListTitles();
	}
	
	public function setMibloader($mibloader)
	{
		$this->MIB=$mibloader;
		$this->doTranslate=true;
	}
	// ******************  Render table in html  
    public function __toString()
    {
        return $this->render();
    }
	
	public function render()
	{
		$data=$this->getTable();
		$view = $this->getView();
		$this->columnCount = count($this->getTitles());
		$this->lastDay=null;
		// Table start
		$htm  = '<table class="simple common-table table-row-selectable">';
		
		// Titles
		$htm .= "<thead>\n  <tr>\n";
		$titles = $this->getTitles();
		foreach ($titles as $title) 
		{
			$htm .= '    <th>' . $view->escape($view->translate($title)) . "</th>\n";
		}
		$htm .= "  </tr>\n</thead>\n";
		
		// Rows
		$htm .= "<tbody>\n";
		
		foreach ($data as $row) 
		{
			$firstCol = true;
			// Put date header
			//$htm .= $this->renderDayIfNew($row->timestamp);
			
			
			// Render row
			$htm .= '<tr '.' >';
			foreach ( $titles as $rowkey => $title) 
			{
				// Check missing value
				if (property_exists($row, $rowkey)) 
				{
					switch ($rowkey)
					{
						case 'action_match': // display text levels
						case 'action_nomatch':
							$val=$this->status_display[$row->$rowkey];
						break;
						case 'trap_oid': // try to traslate oids.
						
							if ($this->doTranslate===true)
							{
								$oidName=$this->MIB->translateOID($row->$rowkey);
								if (isset($oidName['name']))
								{
									$val=$oidName['name'];
								}
								else
								{
									$val = $row->$rowkey;
								}								
							}
							else
							{
								$val = $row->$rowkey;
							}
						break;
						case 'host_name': // switch to hostgroup if name is null
							if ($row->$rowkey == null)
							{
								$val = $row->host_group_name;
							}
							else
							{
								$val = $row->$rowkey;
							}
						break;
						default:
							$val = $row->$rowkey;
					}
					if ($rowkey == 'trap_oid' && $this->doTranslate===true)
					{					
							
					}
				} else {
					$val = '-';
				}
				if ($firstCol === true) { // Put link in first column for trap detail.
					$htm .= '<td>' 
							. $view->qlink(
									$view->escape($val),  
									Url::fromPath(
										$this->moduleConfig->urlPath() . '/handler/add', 
										array('ruleid' => $row->id)
									)
							)
							. '</td>';
				} else {
					$htm .= '<td>' . $view->escape($val) . '</td>';
				}
				$firstCol=false;
			}
			$htm .= "<tr>\n";
		}
		$htm .= "</tbody></table>\n";
		//$htm .= "Filter : " . $this->filter."<br>\n";
		return $htm;

	}

    public function count()
    {
        //$db = $this->connection()->getConnection();
        $query = clone($this->getBaseQuery());
        $query->reset('order')->columns(array('COUNT(*)'));
        $this->applyFiltersToQuery($query);

		$db=$this->db();
		
		$query = $db->select()->from(
            $this->moduleConfig->getTrapRuleName(),
            array('COUNT(*)')
        );
		
        return $db->fetchOne($query);
    }
	
    public function getPaginator()
    {
        $paginator = new Paginator();
        $paginator->setQuery($this);

        return $paginator;
    }
	
	// ****************** DB connection and query
	
	protected function getTable()
	{
		$db=$this->db();
		
		$query = $this->getBaseQuery();
		
       if ($this->hasLimit() || $this->hasOffset()) {
            $query->limit($this->getLimit(), $this->getOffset());
        }		
		
		return $db->fetchAll($query);
	}
	 
    public function getBaseQuery()
    {
		$db=$this->db();
		
		$query = $db->select()->from(
            $this->moduleConfig->getTrapRuleName(),
            $this->moduleConfig->getHandlerListDisplayColumns()
        )->order('host_name DESC,trap_oid DESC');

        return $query;
    }	 
	
	// ****************** Filters

    protected function getSearchColumns()
    {
        return $this->getColumns();
    }
	
	public function getColumns()
	{
		return $this->moduleConfig->getHandlerListDisplayColumns();
	}

    public function setFilter($filter)
    {
        $this->filter = $filter;
        return $this;
    }
	
	public function getFilterEditor(Request $request)
    {
        $filterEditor = Widget::create('filterEditor')
            ->setColumns(array_keys($this->getColumns()))
            ->setSearchColumns(array_keys($this->getSearchColumns()))
            ->preserveParams('limit', 'sort', 'dir', 'view', 'backend')
            ->ignoreParams('page')
            ->handleRequest($request);

        $filter = $filterEditor->getFilter();
        $this->setFilter($filter);

        return $filterEditor;
    }
	
    protected function applyFiltersToQuery($query)
    {
		// TODO : implement
		
        /*$filter = null;
        $enforced = $this->enforcedFilters;
        if ($this->filter && ! $this->filter->isEmpty()) {
            $filter = $this->filter;
        } elseif (! empty($enforced)) {
            $filter = array_shift($enforced);
        }
        if ($filter) {
            foreach ($enforced as $f) {
                $filter->andFilter($f);
            }
            $query->where($this->renderFilter($filter));
        }
		*/

        return $query;
    }	

}