Zabbix

<?php

/*

** Copyright (C) 2001-2025 Zabbix SIA

**

** This program is free software: you can redistribute it and/or modify it under the terms of

** the GNU Affero General Public License as published by the Free Software Foundation, version 3.

**

** This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

** without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

** See the GNU Affero General Public License for more details.

**

** You should have received a copy of the GNU Affero General Public License along with this program.

** If not, see <https://www.gnu.org/licenses/>.

**/

​

​

require_once dirname(__FILE__).'/../../include/CLegacyWebTest.php';

​

/**

 * @dataSource Actions

 */

class testPageActions extends CLegacyWebTest {

​

    private $sqlHashAction = '';

    private $oldHashAction = '';

    private $sqlHashConditions = '';

    private $oldHashConditions = '';

    private $sqlHashOperations = '';

    private $oldHashOperations = '';

    private $sqlHashOpMessage = '';

    private $oldHashOpMessage = '';

    private $sqlHashOpMessageGrp = '';

    private $oldHashOpMessageGrp = '';

    private $sqlHashOpMessageUsr = '';

    private $oldHashOpMessageUsr = '';

    private $sqlHashOpCommand = '';

    private $oldHashOpCommand = '';

    private $sqlHashOpCommandHst = '';

    private $oldHashOpCommandHst = '';

    private $sqlHashOpCommandGrp = '';

    private $oldHashOpCommandGrp = '';

    private $sqlHashOpGroup = '';

    private $oldHashOpGroup = '';

    private $sqlHashOpTemplate = '';

    private $oldHashOpTemplate = '';

    private $sqlHashOpConditions = '';

    private $oldHashOpConditions = '';

​

    private $event_sources = [

        EVENT_SOURCE_TRIGGERS => 'Trigger actions',

        EVENT_SOURCE_SERVICE => 'Service actions',

        EVENT_SOURCE_DISCOVERY => 'Discovery actions',

        EVENT_SOURCE_AUTOREGISTRATION => 'Autoregistration actions',

        EVENT_SOURCE_INTERNAL => 'Internal actions'

    ];

​

    private function calculateHash($actionid) {

        $this->sqlHashAction = 'SELECT actionid,name,eventsource,evaltype,status,formula,pause_suppressed FROM actions '

                . 'WHERE actionid='.$actionid;

        $this->oldHashAction = CDBHelper::getHash($this->sqlHashAction);

        $this->sqlHashConditions = 'SELECT * FROM conditions WHERE actionid='.$actionid.' AND actionid>2  ORDER BY conditionid';

        $this->oldHashConditions = CDBHelper::getHash($this->sqlHashConditions);

        $this->sqlHashOperations = 'SELECT * FROM operations WHERE actionid='.$actionid.' ORDER BY operationid';

        $this->oldHashOperations = CDBHelper::getHash($this->sqlHashOperations);

        $this->sqlHashOpMessage =

            'SELECT om.* FROM opmessage om,operations o'.

            ' WHERE om.operationid=o.operationid'.

                ' AND o.actionid='.$actionid.

                ' ORDER BY om.operationid';

        $this->oldHashOpMessage = CDBHelper::getHash($this->sqlHashOpMessage);

        $this->sqlHashOpMessageGrp =

            'SELECT omg.* FROM opmessage_grp omg,operations o'.

            ' WHERE omg.operationid=o.operationid'.

                ' AND o.actionid='.$actionid.

                ' ORDER BY omg.opmessage_grpid';

        $this->oldHashOpMessageGrp = CDBHelper::getHash($this->sqlHashOpMessageGrp);

        $this->sqlHashOpMessageUsr =

            'SELECT omu.* FROM opmessage_usr omu,operations o'.

            ' WHERE omu.operationid=o.operationid'.

                ' AND o.actionid='.$actionid.

                ' ORDER BY omu.opmessage_usrid';

        $this->oldHashOpMessageUsr = CDBHelper::getHash($this->sqlHashOpMessageUsr);

        $this->sqlHashOpCommand =

            'SELECT oc.* FROM opcommand oc,operations o'.

            ' WHERE oc.operationid=o.operationid'.

                ' AND o.actionid='.$actionid.

                ' ORDER BY oc.operationid';

        $this->oldHashOpCommand = CDBHelper::getHash($this->sqlHashOpCommand);

        $this->sqlHashOpCommandHst =

            'SELECT och.* FROM opcommand_hst och,operations o'.

            ' WHERE och.operationid=o.operationid'.