diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-06-27 14:14:38 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-06-27 14:14:38 +0000 |
| commit | 715d45c30750b2f32d186f0f5fa879212e1736cf (patch) | |
| tree | 362bb175086938f7d91c0fb0deb16df99f2ee432 /frontends/php/include/export.inc.php | |
| parent | a88e4ef120a13064f2bf09238abfd7a1ea952a1a (diff) | |
- changed properties of text files in SVN repository (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@4371 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/export.inc.php')
| -rw-r--r-- | frontends/php/include/export.inc.php | 802 |
1 files changed, 401 insertions, 401 deletions
diff --git a/frontends/php/include/export.inc.php b/frontends/php/include/export.inc.php index a89d0d2e..77eb49fc 100644 --- a/frontends/php/include/export.inc.php +++ b/frontends/php/include/export.inc.php @@ -1,401 +1,401 @@ -<?php
-/*
-** ZABBIX
-** Copyright (C) 2000-2005 SIA Zabbix
-**
-** 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., 675 Mass Ave, Cambridge, MA 02139, USA.
-**/
-
- require_once "include/defines.inc.php";
-?>
-<?php
- global $ZBX_EXPORT_MAP;
-
- $ZBX_EXPORT_MAP = array(
- XML_TAG_HOST => array(
- 'attribures' => array(
- 'host' => 'name'),
- 'elements' => array(
- 'useip' => '',
- 'dns' => '',
- 'ip' => '',
- 'port' => '',
- 'status' => '')
- ),
- XML_TAG_ITEM => array(
- 'attribures' => array(
- 'type' => '',
- 'key_' => 'key',
- 'value_type' => ''),
- 'elements' => array(
- 'description' => '',
- 'delay' => '',
- 'history' => '',
- 'trends' => '',
- 'status' => '',
- 'units' => '',
- 'multiplier' => '',
- 'delta' => '',
- 'formula' => '',
- 'lastlogsize' => '',
- 'logtimefmt' => '',
- 'delay_flex' => '',
- 'params' => '',
- 'trapper_hosts' => '',
- 'snmp_community' => '',
- 'snmp_oid' => '',
- 'snmp_port' => '',
- 'snmpv3_securityname' => '',
- 'snmpv3_securitylevel' => '',
- 'snmpv3_authpassphrase' => '',
- 'snmpv3_privpassphrase' => '')
- ),
- XML_TAG_TRIGGER => array(
- 'attribures' => array(),
- 'elements' => array(
- 'description' => '',
- 'expression' => '',
- 'url' => '',
- 'status' => '',
- 'priority' => '',
- 'comments' => '')
- ),
- XML_TAG_GRAPH => array(
- 'attribures' => array(
- 'name' => '',
- 'width' => '',
- 'height' => ''),
- 'elements' => array(
- 'yaxistype' => '',
- 'show_work_period' => '',
- 'show_triggers' => '',
- 'graphtype' => '',
- 'yaxismin' => '',
- 'yaxismax' => '')
- ),
- XML_TAG_GRAPH_ELEMENT => array(
- 'attribures' => array(
- 'item' => ''),
- 'elements' => array(
- 'drawtype' => '',
- 'sortorder' => '',
- 'color' => '',
- 'yaxisside' => '',
- 'calc_fnc' => '',
- 'type' => '',
- 'periods_cnt' => '')
- )
- );
-
- function zbx_xmlwriter_open_memory()
- {
- return array('tabs' => 0, 'tag'=>array());
- }
-
- function zbx_xmlwriter_set_indent($mem, $val)
- {
- return true;
- }
-
- function zbx_xmlwriter_start_document(&$mem, $ver)
- {
- echo '<?xml version="'.$ver.'"?';
- return true;
- }
-
- function zbx_xmlwriter_start_element(&$mem, $tag)
- {
- array_push($mem['tag'], $tag);
- echo '>'."\n".str_repeat("\t",$mem['tabs']).'<'.$tag;
- $mem['tabs']++;
- return true;
- }
- function zbx_xmlwriter_write_attribute(&$mem, $name, $val)
- {
- echo ' '.$name.'="'.htmlspecialchars($val).'"';
- return true;
- }
-
- function zbx_xmlwriter_end_element(&$mem)
- {
- $teg = array_pop($mem['tag']);
- $mem['tabs']--;
- echo '>'."\n".str_repeat("\t",$mem['tabs']).'</'.$teg;
- }
-
- function zbx_xmlwriter_output_memory(&$mem, $val)
- { /* NOTE: use this function only in the end of xml file creation */
- echo '>';
- }
-
- function zbx_xmlwriter_write_element(&$mem, $name, $val)
- {
- echo '>'."\n".str_repeat("\t",$mem['tabs']).'<'.$name.'>'.htmlspecialchars($val).'</'.$name;
- }
-
- class CZabbixXMLExport
- {
- function CZabbixXMLExport(){}
-
- function export_item(&$memory, $itemid)
- {
- global $ZBX_EXPORT_MAP;
-
- $data = DBfetch(DBselect('select * from items where itemid='.$itemid));
- if(!$data) return false;
-
- zbx_xmlwriter_start_element ($memory,XML_TAG_ITEM);
-
- $map =& $ZBX_EXPORT_MAP[XML_TAG_ITEM];
-
- foreach($map['attribures'] as $db_name => $xml_name)
- {
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]);
- }
- foreach($map['elements'] as $db_name => $xml_name)
- {
- if(empty($data[$db_name])) continue;
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]);
- }
-
- if( !empty($data['valuemapid']) && $valuemap = DBfetch(DBselect('select name from valuemaps where valuemapid='.$data['valuemapid'])))
- {
- zbx_xmlwriter_write_element($memory, 'valuemap', $valuemap['name']);
- }
-
- $db_applications=DBselect('select distinct a.name from applications a,items_applications ia '.
- ' where ia.applicationid=a.applicationid and ia.itemid='.$itemid);
- if ($application = DBfetch($db_applications))
- {
- zbx_xmlwriter_start_element ($memory,XML_TAG_APPLICATIONS);
- do {
- zbx_xmlwriter_write_element ($memory, XML_TAG_APPLICATION, $application['name']);
- } while($application = DBfetch($db_applications));
- zbx_xmlwriter_end_element($memory); // XML_TAG_APPLICATIONS
- }
-
- zbx_xmlwriter_end_element($memory); // XML_TAG_ITEM
- }
-
-
- function export_trigger(&$memory, $triggerid)
- {
- global $ZBX_EXPORT_MAP;
-
- $data = DBfetch(DBselect('select * from triggers where triggerid='.$triggerid));
- if(!$data) return false;
-
- $data['expression'] = explode_exp($data["expression"],0,true);
-
- zbx_xmlwriter_start_element ($memory,XML_TAG_TRIGGER);
-
- $map =& $ZBX_EXPORT_MAP[XML_TAG_TRIGGER];
-
- foreach($map['attribures'] as $db_name => $xml_name)
- {
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]);
- }
- foreach($map['elements'] as $db_name => $xml_name)
- {
- if(empty($data[$db_name])) continue;
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_TRIGGER
- }
-
- function export_graph_element(&$memory, $gitemid)
- {
- global $ZBX_EXPORT_MAP;
-
- $data = DBfetch(DBselect('select gi.*,i.key_,h.host from graphs_items gi, items i, hosts h'.
- ' where h.hostid=i.hostid and i.itemid=gi.itemid and gi.gitemid='.$gitemid));
- if(!$data) return false;
-
- $data['item'] = '{HOSTNAME}:'.$data['key_'];
-
- zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH_ELEMENT);
-
- $map =& $ZBX_EXPORT_MAP[XML_TAG_GRAPH_ELEMENT];
-
- foreach($map['attribures'] as $db_name => $xml_name)
- {
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]);
- }
- foreach($map['elements'] as $db_name => $xml_name)
- {
- if(empty($data[$db_name])) continue;
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH_ELEMENT
- }
-
- function export_graph(&$memory, $graphid)
- {
- global $ZBX_EXPORT_MAP;
-
- $data = DBfetch(DBselect('select * from graphs where graphid='.$graphid));
- if(!$data) return false;
-
- zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH);
-
- $map =& $ZBX_EXPORT_MAP[XML_TAG_GRAPH];
-
- foreach($map['attribures'] as $db_name => $xml_name)
- {
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]);
- }
- foreach($map['elements'] as $db_name => $xml_name)
- {
- if(empty($data[$db_name])) continue;
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]);
- }
- zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH_ELEMENTS);
- $db_elements = DBselect('select gitemid from graphs_items where graphid='.$graphid);
- while($element = DBfetch($db_elements))
- {
- $this->export_graph_element($memory, $element['gitemid']);
- }
-
- zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH_ELEMENTS
- zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH
- }
-
- function export_host(&$memory, $hostid, $export_templates, $export_items, $export_triggers, $export_graphs)
- {
- global $ZBX_EXPORT_MAP;
-
- $data = DBfetch(DBselect('select * from hosts where hostid='.$hostid));
- if(!$data) return false;
-
- zbx_xmlwriter_start_element ($memory,XML_TAG_HOST);
-
- $map =& $ZBX_EXPORT_MAP[XML_TAG_HOST];
-
- foreach($map['attribures'] as $db_name => $xml_name)
- {
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]);
- }
- foreach($map['elements'] as $db_name => $xml_name)
- {
- if(empty($data[$db_name])) continue;
- if(empty($xml_name)) $xml_name = $db_name;
- zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]);
- }
-
- if($db_groups = DBselect('select g.name from groups g, hosts_groups hg'.
- ' where g.groupid=hg.groupid and hg.hostid='.$hostid))
- {
- zbx_xmlwriter_start_element ($memory,XML_TAG_GROUPS);
- while($group = DBfetch($db_groups))
- {
- zbx_xmlwriter_write_element ($memory, XML_TAG_GROUP, $group['name']);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_GROUP
- }
-
- if($export_templates){
- $query = 'SELECT t.host '.
- ' FROM hosts t, hosts_templates ht'.
- ' WHERE t.hostid=ht.templateid AND ht.hostid='.$hostid;
-
- if($db_templates = DBselect($query)){
- zbx_xmlwriter_start_element ($memory,XML_TAG_TEMPLATES);
-
- while($template = DBfetch($db_templates)){
- zbx_xmlwriter_write_element ($memory, XML_TAG_TEMPLATE, $template['host']);
- }
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_TEMPLATES
- }
-
- if($export_items)
- {
- zbx_xmlwriter_start_element ($memory,XML_TAG_ITEMS);
- $db_items=DBselect('select itemid from items where hostid='.$hostid);
- while($item_id = DBfetch($db_items))
- {
- $this->export_item($memory, $item_id['itemid']);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_ITEMS
- }
-
-
- if($export_triggers)
- {
- zbx_xmlwriter_start_element ($memory,XML_TAG_TRIGGERS);
- $db_triggers = DBselect('select f.triggerid, i.hostid, count(distinct i.hostid) as cnt '.
- ' from functions f, items i '.
- ' where f.itemid=i.itemid group by f.triggerid, i.hostid');
- while($trigger = DBfetch($db_triggers))
- {
- if($trigger['hostid'] != $hostid || $trigger['cnt']!=1) continue;
- $this->export_trigger($memory, $trigger['triggerid']);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_TRIGGERS
- }
- if($export_graphs)
- {
- zbx_xmlwriter_start_element ($memory, XML_TAG_GRAPHS);
- $db_graphs = DBselect('select gi.graphid, i.hostid, count(distinct i.hostid) as cnt '.
- ' from graphs_items gi, items i '.
- ' where gi.itemid=i.itemid group by gi.graphid, i.hostid');
- while($graph = DBfetch($db_graphs))
- {
- if($graph['hostid'] != $hostid || $graph['cnt']!=1) continue;
- $this->export_graph($memory, $graph['graphid']);
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPHS
- }
- /* export screens */
- zbx_xmlwriter_end_element($memory); // XML_TAG_HOST
- return true;
- }
-
- function Export(&$hosts, &$templates, &$items, &$triggers, &$graphs)
- {
- $memory = zbx_xmlwriter_open_memory();
- zbx_xmlwriter_set_indent($memory, true);
- zbx_xmlwriter_start_document($memory,'1.0');
- zbx_xmlwriter_start_element ($memory,XML_TAG_ZABBIX_EXPORT);
- zbx_xmlwriter_write_attribute($memory, 'version', '1.0');
- zbx_xmlwriter_write_attribute($memory, 'date', date('d.m.y'));
- zbx_xmlwriter_write_attribute($memory, 'time', date('h.i'));
- zbx_xmlwriter_start_element ($memory,XML_TAG_HOSTS);
- foreach(array_keys($hosts) as $hostid)
- {
- $this->export_host(
- $memory,
- $hostid,
- isset($templates[$hostid]),
- isset($items[$hostid]),
- isset($triggers[$hostid]),
- isset($graphs[$hostid])
- );
- }
- zbx_xmlwriter_end_element($memory); // XML_TAG_HOSTS
- zbx_xmlwriter_end_element($memory); // XML_TAG_ZABBIX_EXPORT
- die(zbx_xmlwriter_output_memory($memory,true));
- }
- }
-?>
+<?php +/* +** ZABBIX +** Copyright (C) 2000-2005 SIA Zabbix +** +** 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., 675 Mass Ave, Cambridge, MA 02139, USA. +**/ + + require_once "include/defines.inc.php"; +?> +<?php + global $ZBX_EXPORT_MAP; + + $ZBX_EXPORT_MAP = array( + XML_TAG_HOST => array( + 'attribures' => array( + 'host' => 'name'), + 'elements' => array( + 'useip' => '', + 'dns' => '', + 'ip' => '', + 'port' => '', + 'status' => '') + ), + XML_TAG_ITEM => array( + 'attribures' => array( + 'type' => '', + 'key_' => 'key', + 'value_type' => ''), + 'elements' => array( + 'description' => '', + 'delay' => '', + 'history' => '', + 'trends' => '', + 'status' => '', + 'units' => '', + 'multiplier' => '', + 'delta' => '', + 'formula' => '', + 'lastlogsize' => '', + 'logtimefmt' => '', + 'delay_flex' => '', + 'params' => '', + 'trapper_hosts' => '', + 'snmp_community' => '', + 'snmp_oid' => '', + 'snmp_port' => '', + 'snmpv3_securityname' => '', + 'snmpv3_securitylevel' => '', + 'snmpv3_authpassphrase' => '', + 'snmpv3_privpassphrase' => '') + ), + XML_TAG_TRIGGER => array( + 'attribures' => array(), + 'elements' => array( + 'description' => '', + 'expression' => '', + 'url' => '', + 'status' => '', + 'priority' => '', + 'comments' => '') + ), + XML_TAG_GRAPH => array( + 'attribures' => array( + 'name' => '', + 'width' => '', + 'height' => ''), + 'elements' => array( + 'yaxistype' => '', + 'show_work_period' => '', + 'show_triggers' => '', + 'graphtype' => '', + 'yaxismin' => '', + 'yaxismax' => '') + ), + XML_TAG_GRAPH_ELEMENT => array( + 'attribures' => array( + 'item' => ''), + 'elements' => array( + 'drawtype' => '', + 'sortorder' => '', + 'color' => '', + 'yaxisside' => '', + 'calc_fnc' => '', + 'type' => '', + 'periods_cnt' => '') + ) + ); + + function zbx_xmlwriter_open_memory() + { + return array('tabs' => 0, 'tag'=>array()); + } + + function zbx_xmlwriter_set_indent($mem, $val) + { + return true; + } + + function zbx_xmlwriter_start_document(&$mem, $ver) + { + echo '<?xml version="'.$ver.'"?'; + return true; + } + + function zbx_xmlwriter_start_element(&$mem, $tag) + { + array_push($mem['tag'], $tag); + echo '>'."\n".str_repeat("\t",$mem['tabs']).'<'.$tag; + $mem['tabs']++; + return true; + } + function zbx_xmlwriter_write_attribute(&$mem, $name, $val) + { + echo ' '.$name.'="'.htmlspecialchars($val).'"'; + return true; + } + + function zbx_xmlwriter_end_element(&$mem) + { + $teg = array_pop($mem['tag']); + $mem['tabs']--; + echo '>'."\n".str_repeat("\t",$mem['tabs']).'</'.$teg; + } + + function zbx_xmlwriter_output_memory(&$mem, $val) + { /* NOTE: use this function only in the end of xml file creation */ + echo '>'; + } + + function zbx_xmlwriter_write_element(&$mem, $name, $val) + { + echo '>'."\n".str_repeat("\t",$mem['tabs']).'<'.$name.'>'.htmlspecialchars($val).'</'.$name; + } + + class CZabbixXMLExport + { + function CZabbixXMLExport(){} + + function export_item(&$memory, $itemid) + { + global $ZBX_EXPORT_MAP; + + $data = DBfetch(DBselect('select * from items where itemid='.$itemid)); + if(!$data) return false; + + zbx_xmlwriter_start_element ($memory,XML_TAG_ITEM); + + $map =& $ZBX_EXPORT_MAP[XML_TAG_ITEM]; + + foreach($map['attribures'] as $db_name => $xml_name) + { + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]); + } + foreach($map['elements'] as $db_name => $xml_name) + { + if(empty($data[$db_name])) continue; + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]); + } + + if( !empty($data['valuemapid']) && $valuemap = DBfetch(DBselect('select name from valuemaps where valuemapid='.$data['valuemapid']))) + { + zbx_xmlwriter_write_element($memory, 'valuemap', $valuemap['name']); + } + + $db_applications=DBselect('select distinct a.name from applications a,items_applications ia '. + ' where ia.applicationid=a.applicationid and ia.itemid='.$itemid); + if ($application = DBfetch($db_applications)) + { + zbx_xmlwriter_start_element ($memory,XML_TAG_APPLICATIONS); + do { + zbx_xmlwriter_write_element ($memory, XML_TAG_APPLICATION, $application['name']); + } while($application = DBfetch($db_applications)); + zbx_xmlwriter_end_element($memory); // XML_TAG_APPLICATIONS + } + + zbx_xmlwriter_end_element($memory); // XML_TAG_ITEM + } + + + function export_trigger(&$memory, $triggerid) + { + global $ZBX_EXPORT_MAP; + + $data = DBfetch(DBselect('select * from triggers where triggerid='.$triggerid)); + if(!$data) return false; + + $data['expression'] = explode_exp($data["expression"],0,true); + + zbx_xmlwriter_start_element ($memory,XML_TAG_TRIGGER); + + $map =& $ZBX_EXPORT_MAP[XML_TAG_TRIGGER]; + + foreach($map['attribures'] as $db_name => $xml_name) + { + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]); + } + foreach($map['elements'] as $db_name => $xml_name) + { + if(empty($data[$db_name])) continue; + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_TRIGGER + } + + function export_graph_element(&$memory, $gitemid) + { + global $ZBX_EXPORT_MAP; + + $data = DBfetch(DBselect('select gi.*,i.key_,h.host from graphs_items gi, items i, hosts h'. + ' where h.hostid=i.hostid and i.itemid=gi.itemid and gi.gitemid='.$gitemid)); + if(!$data) return false; + + $data['item'] = '{HOSTNAME}:'.$data['key_']; + + zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH_ELEMENT); + + $map =& $ZBX_EXPORT_MAP[XML_TAG_GRAPH_ELEMENT]; + + foreach($map['attribures'] as $db_name => $xml_name) + { + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]); + } + foreach($map['elements'] as $db_name => $xml_name) + { + if(empty($data[$db_name])) continue; + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH_ELEMENT + } + + function export_graph(&$memory, $graphid) + { + global $ZBX_EXPORT_MAP; + + $data = DBfetch(DBselect('select * from graphs where graphid='.$graphid)); + if(!$data) return false; + + zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH); + + $map =& $ZBX_EXPORT_MAP[XML_TAG_GRAPH]; + + foreach($map['attribures'] as $db_name => $xml_name) + { + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]); + } + foreach($map['elements'] as $db_name => $xml_name) + { + if(empty($data[$db_name])) continue; + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]); + } + zbx_xmlwriter_start_element ($memory,XML_TAG_GRAPH_ELEMENTS); + $db_elements = DBselect('select gitemid from graphs_items where graphid='.$graphid); + while($element = DBfetch($db_elements)) + { + $this->export_graph_element($memory, $element['gitemid']); + } + + zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH_ELEMENTS + zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPH + } + + function export_host(&$memory, $hostid, $export_templates, $export_items, $export_triggers, $export_graphs) + { + global $ZBX_EXPORT_MAP; + + $data = DBfetch(DBselect('select * from hosts where hostid='.$hostid)); + if(!$data) return false; + + zbx_xmlwriter_start_element ($memory,XML_TAG_HOST); + + $map =& $ZBX_EXPORT_MAP[XML_TAG_HOST]; + + foreach($map['attribures'] as $db_name => $xml_name) + { + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_attribute($memory, $xml_name, $data[$db_name]); + } + foreach($map['elements'] as $db_name => $xml_name) + { + if(empty($data[$db_name])) continue; + if(empty($xml_name)) $xml_name = $db_name; + zbx_xmlwriter_write_element ($memory, $xml_name, $data[$db_name]); + } + + if($db_groups = DBselect('select g.name from groups g, hosts_groups hg'. + ' where g.groupid=hg.groupid and hg.hostid='.$hostid)) + { + zbx_xmlwriter_start_element ($memory,XML_TAG_GROUPS); + while($group = DBfetch($db_groups)) + { + zbx_xmlwriter_write_element ($memory, XML_TAG_GROUP, $group['name']); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_GROUP + } + + if($export_templates){ + $query = 'SELECT t.host '. + ' FROM hosts t, hosts_templates ht'. + ' WHERE t.hostid=ht.templateid AND ht.hostid='.$hostid; + + if($db_templates = DBselect($query)){ + zbx_xmlwriter_start_element ($memory,XML_TAG_TEMPLATES); + + while($template = DBfetch($db_templates)){ + zbx_xmlwriter_write_element ($memory, XML_TAG_TEMPLATE, $template['host']); + } + } + zbx_xmlwriter_end_element($memory); // XML_TAG_TEMPLATES + } + + if($export_items) + { + zbx_xmlwriter_start_element ($memory,XML_TAG_ITEMS); + $db_items=DBselect('select itemid from items where hostid='.$hostid); + while($item_id = DBfetch($db_items)) + { + $this->export_item($memory, $item_id['itemid']); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_ITEMS + } + + + if($export_triggers) + { + zbx_xmlwriter_start_element ($memory,XML_TAG_TRIGGERS); + $db_triggers = DBselect('select f.triggerid, i.hostid, count(distinct i.hostid) as cnt '. + ' from functions f, items i '. + ' where f.itemid=i.itemid group by f.triggerid, i.hostid'); + while($trigger = DBfetch($db_triggers)) + { + if($trigger['hostid'] != $hostid || $trigger['cnt']!=1) continue; + $this->export_trigger($memory, $trigger['triggerid']); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_TRIGGERS + } + if($export_graphs) + { + zbx_xmlwriter_start_element ($memory, XML_TAG_GRAPHS); + $db_graphs = DBselect('select gi.graphid, i.hostid, count(distinct i.hostid) as cnt '. + ' from graphs_items gi, items i '. + ' where gi.itemid=i.itemid group by gi.graphid, i.hostid'); + while($graph = DBfetch($db_graphs)) + { + if($graph['hostid'] != $hostid || $graph['cnt']!=1) continue; + $this->export_graph($memory, $graph['graphid']); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_GRAPHS + } + /* export screens */ + zbx_xmlwriter_end_element($memory); // XML_TAG_HOST + return true; + } + + function Export(&$hosts, &$templates, &$items, &$triggers, &$graphs) + { + $memory = zbx_xmlwriter_open_memory(); + zbx_xmlwriter_set_indent($memory, true); + zbx_xmlwriter_start_document($memory,'1.0'); + zbx_xmlwriter_start_element ($memory,XML_TAG_ZABBIX_EXPORT); + zbx_xmlwriter_write_attribute($memory, 'version', '1.0'); + zbx_xmlwriter_write_attribute($memory, 'date', date('d.m.y')); + zbx_xmlwriter_write_attribute($memory, 'time', date('h.i')); + zbx_xmlwriter_start_element ($memory,XML_TAG_HOSTS); + foreach(array_keys($hosts) as $hostid) + { + $this->export_host( + $memory, + $hostid, + isset($templates[$hostid]), + isset($items[$hostid]), + isset($triggers[$hostid]), + isset($graphs[$hostid]) + ); + } + zbx_xmlwriter_end_element($memory); // XML_TAG_HOSTS + zbx_xmlwriter_end_element($memory); // XML_TAG_ZABBIX_EXPORT + die(zbx_xmlwriter_output_memory($memory,true)); + } + } +?> |
