Zabbix

<?php

/*

** Zabbix

** Copyright (C) 2001-2022 Zabbix SIA

**

** This program is free software; you can redistribute it and/or modify

** it under the terms of the GNU General Public License as published by

** the Free Software Foundation; either version 2 of the License, or

** (at your option) any later version.

**

** 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 General Public License for more details.

**

** You should have received a copy of the GNU General Public License

** along with this program; if not, write to the Free Software

** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

**/

​

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

require_once dirname(__FILE__).'/../traits/FilterTrait.php';

​

/**

 * @backup widget

 * @backup profiles

 *

 * @onBefore setDefaultWidgetType

 */

class testDashboardGraphWidget extends CWebTest {

​

    use FilterTrait;

​

    /*

     * SQL query to get widget and widget_field tables to compare hash values, but without widget_fieldid

     * because it can change.

     */

    private $sql = 'SELECT wf.widgetid, wf.type, wf.name, wf.value_int, wf.value_str, wf.value_groupid, wf.value_hostid,'.

            ' wf.value_itemid, wf.value_graphid, wf.value_sysmapid, w.widgetid, w.dashboardid, w.type, w.name, w.x, w.y,'.

            ' w.width, w.height'.

            ' FROM widget_field wf'.

            ' INNER JOIN widget w'.

            ' ON w.widgetid=wf.widgetid ORDER BY wf.widgetid, wf.name, wf.value_int, wf.value_str, wf.value_groupid,'.

            ' wf.value_itemid, wf.value_graphid';

​

    /*

     * Set "Graph" as default widget type.

     */

    public function setDefaultWidgetType() {

        DBexecute('DELETE FROM profiles WHERE idx=\'web.dashbrd.last_widget_type\' AND userid=\'1\'');

        DBexecute('INSERT INTO profiles (profileid, userid, idx, value_str, type)'.

                ' VALUES (99999,1,\'web.dashbrd.last_widget_type\',\'svggraph\',3)');

    }

​

    /**

     * Open dashboard and add/edit graph widget.

     *

     * @param string $name      name of graphic widget to be opened

     */

    private function openGraphWidgetConfiguration($name = null) {

        $dashboard = CDashboardElement::find()->one()->edit();

​

        // Open existed widget by widget name.