require_once dirname(__FILE__).'/../include/CLegacyWebTest.php';
class testPageAdministrationDMProxies extends CLegacyWebTest {
private $sqlHashProxy = '';
private $oldHashProxy = '';
private $sqlHashInterface = '';
private $oldHashInterface = '';
private $sqlHashHosts = '';
private $oldHashHosts = '';
private $sqlHashDRules = '';
private $oldHashDRules = '';
private function calculateHash($proxy_hostid) {
$this->sqlHashProxy = 'SELECT * FROM hosts WHERE hostid='.$proxy_hostid;
$this->oldHashProxy = CDBHelper::getHash($this->sqlHashProxy);
$this->sqlHashInterface = 'SELECT * FROM interface WHERE hostid='.$proxy_hostid.' ORDER BY interfaceid';
$this->oldHashInterface = CDBHelper::getHash($this->sqlHashInterface);
$this->sqlHashHosts = 'SELECT hostid,proxy_hostid FROM hosts WHERE proxy_hostid='.$proxy_hostid.' ORDER BY hostid';
$this->oldHashHosts = CDBHelper::getHash($this->sqlHashHosts);
$this->sqlHashDRules = 'SELECT druleid,proxy_hostid FROM drules WHERE proxy_hostid='.$proxy_hostid.' ORDER BY druleid';
$this->oldHashDRules = CDBHelper::getHash($this->sqlHashDRules);
private function verifyHash() {
$this->assertEquals($this->oldHashProxy, CDBHelper::getHash($this->sqlHashProxy));
$this->assertEquals($this->oldHashInterface, CDBHelper::getHash($this->sqlHashInterface));
$this->assertEquals($this->oldHashHosts, CDBHelper::getHash($this->sqlHashHosts));
$this->assertEquals($this->oldHashDRules, CDBHelper::getHash($this->sqlHashDRules));
public static function proxies() {
return CDBHelper::getDataProvider(
' WHERE status IN ('.HOST_STATUS_PROXY_ACTIVE.','.HOST_STATUS_PROXY_PASSIVE.') AND hostid<>20003'
public function testPageAdministrationDMProxies_CheckLayout() {
$this->zbxTestLogin('zabbix.php?action=proxy.list');
$this->zbxTestCheckTitle('Configuration of proxies');
$this->zbxTestCheckHeader('Proxies');