array(T_ZBX_STR, O_MAND,P_SYS, NOT_EMPTY, null), "dstfld1"=> array(T_ZBX_STR, O_MAND,P_SYS, NOT_EMPTY, null), "dstfld2"=> array(T_ZBX_STR, O_OPT,P_SYS, null, null), "srctbl" => array(T_ZBX_STR, O_MAND,P_SYS, NOT_EMPTY, null), "srcfld1"=> array(T_ZBX_STR, O_MAND,P_SYS, NOT_EMPTY, null), "srcfld2"=> array(T_ZBX_STR, O_OPT,P_SYS, null, null), "nodeid"=> array(T_ZBX_INT, O_OPT, null, DB_ID, null), "groupid"=> array(T_ZBX_INT, O_OPT, null, DB_ID, null), "hostid"=> array(T_ZBX_INT, O_OPT, null, DB_ID, null), "screenid"=> array(T_ZBX_INT, O_OPT, null, DB_ID, null), "templates"=> array(T_ZBX_STR, O_OPT, null, NOT_EMPTY, null), "host_templates"=> array(T_ZBX_STR, O_OPT, null, NOT_EMPTY, null), "existed_templates"=> array(T_ZBX_STR, O_OPT, null, NOT_EMPTY, null), "only_hostid"=> array(T_ZBX_INT, O_OPT, null, DB_ID, null), "monitored_hosts"=> array(T_ZBX_INT, O_OPT, null, IN('0,1'), null), 'real_hosts'=> array(T_ZBX_INT, O_OPT, null, IN('0,1'), null), 'itemtype'=> array(T_ZBX_INT, O_OPT, null, null, null), 'reference'=> array(T_ZBX_STR, O_OPT, null, null, null), "select"=> array(T_ZBX_STR, O_OPT, P_SYS|P_ACT, null, null) ); $allowed_item_types = array(ITEM_TYPE_ZABBIX,ITEM_TYPE_SIMPLE,ITEM_TYPE_INTERNAL,ITEM_TYPE_AGGREGATE); if(isset($_REQUEST['itemtype']) && !str_in_array($_REQUEST['itemtype'], $allowed_item_types)) unset($_REQUEST['itemtype']); check_fields($fields); $dstfrm = get_request("dstfrm", ''); // destination form $dstfld1 = get_request("dstfld1", ''); // output field on destination form $dstfld2 = get_request("dstfld2", ''); // second output field on destination form $srcfld1 = get_request("srcfld1", ''); // source table field [can be different from fields of source table] $srcfld2 = get_request("srcfld2", null); // second source table field [can be different from fields of source table] $monitored_hosts = get_request("monitored_hosts", 0); $real_hosts = get_request("real_hosts", 0); $only_hostid = get_request("only_hostid", null); $host_status = array(); if ($monitored_hosts) array_push($host_status, HOST_STATUS_MONITORED); else if ($real_hosts) array_push($host_status, HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED); else array_push($host_status, HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_TEMPLATE); ?> $USER_DETAILS['type']){ access_deny(); } ?> AddVar('monitored_hosts', 1); if($real_hosts) $frmTitle->AddVar('real_hosts', 1); $frmTitle->AddVar("dstfrm", $dstfrm); $frmTitle->AddVar("dstfld1", $dstfld1); $frmTitle->AddVar("dstfld2", $dstfld2); $frmTitle->AddVar("srctbl", $srctbl); $frmTitle->AddVar("srcfld1", $srcfld1); $frmTitle->AddVar("srcfld2", $srcfld2); if(isset($_REQUEST['reference'])) $frmTitle->AddVar("reference", $_REQUEST['reference']); if(isset($only_hostid)){ $_REQUEST['hostid'] = $only_hostid; $frmTitle->AddVar("only_hostid",$only_hostid); unset($_REQUEST["groupid"],$_REQUEST["nodeid"]); } $validation_param = array("allow_all_hosts"); if($monitored_hosts) array_push($validation_param, "monitored_hosts"); if($real_hosts) array_push($validation_param, "real_hosts"); if(str_in_array($srctbl,array("graphs","screens","triggers","logitems","items"))){ array_push($validation_param, "always_select_first_host"); validate_group_with_host(PERM_READ_LIST,$validation_param); } else if(str_in_array($srctbl,array('hosts','templates','host_templates'))){ validate_group(PERM_READ_LIST,$validation_param); } $nodeid = get_request('nodeid', get_current_nodeid()); $available_nodes = get_accessible_nodes_by_user($USER_DETAILS,PERM_READ_LIST,PERM_RES_IDS_ARRAY); $available_hosts = get_accessible_hosts_by_user($USER_DETAILS,PERM_READ_ONLY,PERM_RES_IDS_ARRAY,$nodeid); if(isset($only_hostid)){ if(!isset($_REQUEST["hostid"]) || (bccomp($_REQUEST["hostid"], $only_hostid) != 0)) access_deny(); $hostid = $only_hostid; } else{ if(str_in_array($srctbl,array('hosts','host_group','triggers','logitems','items', 'applications','screens','slides','graphs','simple_graph', 'sysmaps','plain_text','screens2','overview','host_group_scr'))) { if(ZBX_DISTRIBUTED){ $cmbNode = new CComboBox('nodeid', $nodeid, 'submit()'); $db_nodes = DBselect('SELECT * FROM nodes WHERE '.DBcondition('nodeid',$available_nodes)); while($node_data = DBfetch($db_nodes)){ $cmbNode->AddItem($node_data['nodeid'], $node_data['name']); if((bccomp($nodeid , $node_data['nodeid']) == 0)) $ok = true; } $frmTitle->AddItem(array(SPACE,S_NODE,SPACE,$cmbNode)); } } if(!isset($ok)) $nodeid = get_current_nodeid(); unset($ok); if(str_in_array($srctbl,array('hosts','templates','triggers','logitems','items','applications','host_templates','graphs','simple_graph','plain_text'))){ $groupid = get_request('groupid',get_profile('web.popup.groupid',0)); $cmbGroups = new CComboBox('groupid',$groupid,'submit()'); $cmbGroups->AddItem(0,S_ALL_SMALL); $db_groups = DBselect('SELECT DISTINCT g.groupid,g.name '. ' FROM groups g, hosts_groups hg, hosts h '. ' WHERE '.DBin_node('g.groupid', $nodeid). ' AND g.groupid=hg.groupid '. ' AND hg.hostid=h.hostid'. ' AND '.DBcondition('h.hostid',$available_hosts). ' AND h.status in ('.implode(',', $host_status).')'. ' ORDER BY name'); while($group = DBfetch($db_groups)){ $cmbGroups->AddItem($group["groupid"],$group["name"]); if((bccomp($groupid , $group["groupid"]) == 0)) $ok = true; } $frmTitle->AddItem(array(S_GROUP,SPACE,$cmbGroups)); update_profile("web.popup.groupid",$groupid); if(!isset($ok) || $groupid == 0) unset($groupid); unset($ok); } if(str_in_array($srctbl,array("help_items"))){ $itemtype = get_request("itemtype",get_profile("web.popup.itemtype",0)); $cmbTypes = new CComboBox("itemtype",$itemtype,"submit()"); foreach($allowed_item_types as $type) $cmbTypes->AddItem($type, item_type2str($type)); $frmTitle->AddItem(array(S_TYPE,SPACE,$cmbTypes)); } if(str_in_array($srctbl,array("triggers","logitems","items",'applications','graphs','simple_graph','plain_text'))){ $hostid = get_request("hostid",get_profile("web.popup.hostid",0)); $cmbHosts = new CComboBox("hostid",$hostid,"submit()"); $sql = 'SELECT DISTINCT h.hostid,h.host FROM hosts h'; if(isset($groupid)){ $sql .= ',hosts_groups hg WHERE '. ' h.hostid=hg.hostid AND hg.groupid='.$groupid.' AND '; } else{ $sql .= ' WHERE '; $cmbHosts->AddItem(0,S_ALL_SMALL); } $sql .= DBin_node('h.hostid', $nodeid). ' and '.DBcondition('h.hostid',$available_hosts). ' and h.status in ('.implode(',', $host_status).')'. ' order by host,h.hostid'; $db_hosts = DBselect($sql); while($host = DBfetch($db_hosts)){ $cmbHosts->AddItem($host["hostid"],$host["host"]); if(bccomp($hostid , $host["hostid"]) == 0) $ok = true; } $frmTitle->AddItem(array(SPACE,S_HOST,SPACE,$cmbHosts)); update_profile("web.popup.hostid",$hostid); if(!isset($ok) || $hostid == 0) unset($hostid); unset($ok); } if(str_in_array($srctbl,array("triggers","hosts"))){ $btnEmpty = new CButton("empty",S_EMPTY, get_window_opener($dstfrm, $dstfld1, 0). get_window_opener($dstfrm, $dstfld2, ''). ((isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard'))?"window.opener.setTimeout('add2favorites();', 1000);":''). " close_window(); return false;"); $frmTitle->AddItem(array(SPACE,$btnEmpty)); } } show_table_header($page["title"], $frmTitle); ?> SetHeader(array(S_HOST,S_DNS,S_IP,S_PORT,S_STATUS,S_AVAILABILITY)); $sql = 'SELECT DISTINCT h.* FROM hosts h'; if(isset($groupid)) $sql .= ',hosts_groups hg WHERE hg.groupid='.$groupid. ' AND h.hostid=hg.hostid AND '; else $sql .= ' WHERE '; $sql .= DBin_node('h.hostid', $nodeid). ' and '.DBcondition('h.hostid',$available_hosts). ' and h.status in ('.implode(',', $host_status).')'. ' order by h.host,h.hostid'; $db_hosts = DBselect($sql); while($host = DBfetch($db_hosts)){ $name = new CLink($host["host"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srctbl). get_window_opener($dstfrm, $dstfld2, $host[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $host[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $host[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); if($host["status"] == HOST_STATUS_MONITORED) $status=new CSpan(S_MONITORED,"off"); else if($host["status"] == HOST_STATUS_NOT_MONITORED) $status=new CSpan(S_NOT_MONITORED,"on"); else if($host["status"] == HOST_STATUS_TEMPLATE) $status=new CSpan(S_TEMPLATE,"unknown"); else if($host["status"] == HOST_STATUS_DELETED) $status=new CSpan(S_DELETED,"unknown"); else $status=S_UNKNOWN; if($host["status"] == HOST_STATUS_TEMPLATE){ $dns = $ip = $port = $available = '-'; } else{ $dns = $host['dns']; $ip = $host['ip']; if($host["useip"]==1) $ip = bold($ip); else $dns = bold($dns); $port = $host["port"]; if($host["available"] == HOST_AVAILABLE_TRUE) $available=new CSpan(S_AVAILABLE,"off"); else if($host["available"] == HOST_AVAILABLE_FALSE) $available=new CSpan(S_NOT_AVAILABLE,"on"); else if($host["available"] == HOST_AVAILABLE_UNKNOWN) $available=new CSpan(S_UNKNOWN,"unknown"); } $table->AddRow(array( $name, $dns, $ip, $port, $status, $available )); unset($host); } $table->Show(); } else if($srctbl == "templates"){ $existed_templates = get_request('existed_templates', array()); $templates = get_request('templates', array()); $templates = $templates + $existed_templates; if(!validate_templates(array_keys($templates))){ show_error_message('Conflict between selected templates'); } else if(isset($_REQUEST['select'])){ $new_templates = array_diff($templates, $existed_templates); if(count($new_templates) > 0) { foreach($new_templates as $id => $name) { ?> 0 unset($new_templates); } $table = new CTableInfo(S_NO_TEMPLATES_DEFINED); $table->SetHeader(array(S_NAME)); $sql = "SELECT DISTINCT h.* from hosts h"; if(isset($groupid)) $sql .= ",hosts_groups hg where hg.groupid=".$groupid. " AND h.hostid=hg.hostid AND "; else $sql .= " where "; $sql .= DBin_node('h.hostid', $nodeid). ' AND '.DBcondition('h.hostid',$available_hosts). ' AND h.status='.HOST_STATUS_TEMPLATE. ' order by h.host,h.hostid'; $db_hosts = DBselect($sql); while($host = DBfetch($db_hosts)) { $chk = new CCheckBox('templates['.$host["hostid"].']',isset($templates[$host["hostid"]]), null,$host["host"]); $chk->SetEnabled(!isset($existed_templates[$host["hostid"]])); $table->AddRow(array( array( $chk, $host["host"]) )); unset($host); } $table->SetFooter(new CButton('select',S_SELECT)); $form = new CForm(); $form->AddVar('existed_templates',$existed_templates); if($monitored_hosts) $form->AddVar('monitored_hosts', 1); if($real_hosts) $form->AddVar('real_hosts', 1); $form->AddVar('dstfrm',$dstfrm); $form->AddVar('dstfld1',$dstfld1); $form->AddVar('srctbl',$srctbl); $form->AddVar('srcfld1',$srcfld1); $form->AddVar('srcfld2',$srcfld2); $form->AddItem($table); $form->Show(); } else if(str_in_array($srctbl,array("host_group"))){ $available_groups = get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY,null,$nodeid); $table = new CTableInfo(S_NO_GROUPS_DEFINED); $table->SetHeader(array(S_NAME)); $db_groups = DBselect("SELECT DISTINCT groupid,name from groups ". ' where '.DBin_node('groupid', $nodeid). " AND groupid in (".$available_groups.") ". " order by name"); while($row = DBfetch($db_groups)){ $name = new CLink($row["name"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if(str_in_array($srctbl,array('host_templates'))){ $table = new CTableInfo(S_NO_TEMPLATES_DEFINED); $table->SetHeader(array(S_NAME)); $sql = 'SELECT DISTINCT h.* from hosts h'; if(isset($groupid)) $sql .= ',hosts_groups hg where hg.groupid='.$groupid. ' AND h.hostid=hg.hostid AND '; else $sql .= ' WHERE '; $sql .= DBin_node('h.hostid',$nodeid). ' AND h.status='.HOST_STATUS_TEMPLATE. ' AND '.DBcondition('h.hostid',$available_hosts). ' ORDER BY h.host,h.hostid'; $db_hosts = DBselect($sql); while($row = DBfetch($db_hosts)){ $name = new CLink($row['host'],'#','action'); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == "usrgrp"){ $table = new CTableInfo(S_NO_GROUPS_DEFINED); $table->SetHeader(array(S_NAME)); $result = DBselect('select * from usrgrp where '.DBin_node('usrgrpid').' order by name'); while($row = DBfetch($result)){ $name = new CLink( get_node_name_by_elid($row['usrgrpid']).$row['name'], '#', 'action' ); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == "users"){ $table = new CTableInfo(S_NO_USERS_DEFINED); $table->SetHeader(array(S_NAME)); $result = DBselect('select * from users where '.DBin_node('userid').' order by name'); while($row = DBfetch($result)){ $name = new CLink( get_node_name_by_elid($row['userid']).$row['alias'], '#', 'action' ); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == "help_items"){ $table = new CTableInfo(S_NO_ITEMS); $table->SetHeader(array(S_KEY,S_DESCRIPTION)); $result = DBselect("select * from help_items where itemtype=".$itemtype." order by key_"); while($row = DBfetch($result)){ $name = new CLink($row["key_"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, html_entity_decode($row[$srcfld1])). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow(array( $name, $row["description"] )); } $table->Show(); } else if($srctbl == "triggers"){ $available_triggers = get_accessible_triggers(PERM_READ_ONLY, PERM_RES_IDS_ARRAY, $nodeid); $table = new CTableInfo(S_NO_TRIGGERS_DEFINED); $table->SetHeader(array( S_NAME, S_SEVERITY, S_STATUS)); $sql = 'SELECT h.host,t.triggerid,t.description,t.expression,t.priority,t.status,count(d.triggerid_up) as dep_count '. ' FROM hosts h,items i,functions f, triggers t'. ' LEFT JOIN trigger_depends d ON d.triggerid_down=t.triggerid '. ' WHERE f.itemid=i.itemid '. ' AND h.hostid=i.hostid '. ' AND t.triggerid=f.triggerid'. ' AND '.DBin_node('t.triggerid', $nodeid). ' AND '.DBcondition('t.triggerid',$available_triggers). ' AND h.status in ('.implode(',', $host_status).')'; if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= ' GROUP BY h.host, t.triggerid, t.description, t.expression, t.priority, t.status'. ' ORDER BY h.host,t.description'; $result=DBselect($sql); while($row=DBfetch($result)){ $exp_desc = expand_trigger_description_by_data($row); $description = new CLink($exp_desc,"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $exp_desc). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $exp_desc); } $description->SetAction($action." close_window(); return false;"); if($row['dep_count'] > 0){ $description = array( $description, BR(),BR(), bold(S_DEPENDS_ON), BR()); $deps = get_trigger_dependencies_by_triggerid($row["triggerid"]); foreach($deps as $val) $description[] = array(expand_trigger_description($val),BR()); } if($row["status"] == TRIGGER_STATUS_DISABLED){ $status= new CSpan(S_DISABLED, 'disabled'); } else if($row["status"] == TRIGGER_STATUS_UNKNOWN){ $status= new CSpan(S_UNKNOWN, 'unknown'); } else if($row["status"] == TRIGGER_STATUS_ENABLED){ $status= new CSpan(S_ENABLED, 'enabled'); } if($row["status"] != TRIGGER_STATUS_UNKNOWN) $row["error"]=SPACE; if($row["error"]=="") $row["error"]=SPACE; $table->AddRow(array( $description, new CCol(get_severity_description($row['priority']),get_severity_style($row['priority'])), $status, )); unset($description); unset($status); } $table->Show(); } else if($srctbl == "logitems"){ insert_js_function('add_item_variable'); $table = new CTableInfo(S_NO_ITEMS_DEFINED); $table->SetHeader(array( !isset($hostid) ? S_HOST : null, S_DESCRIPTION,S_KEY,nbsp(S_UPDATE_INTERVAL), S_STATUS)); $db_items = DBselect('SELECT DISTINCT h.host,i.* '. ' FROM items i,hosts h'. ' WHERE i.value_type='.ITEM_VALUE_TYPE_LOG. ' AND h.hostid=i.hostid '. ' AND '.DBin_node('i.itemid', $nodeid). (isset($hostid)?' AND '.$hostid.'=i.hostid ':''). ' and '.DBcondition('h.hostid',$available_hosts). ' and h.status in ('.implode(',', $host_status).')'. ' ORDER BY h.host,i.description, i.key_, i.itemid'); while($db_item = DBfetch($db_items)) { $description = new CLink(item_description($db_item["description"],$db_item["key_"]),"#","action"); $description->SetAction("return add_item_variable('".$dstfrm."','".$db_item["itemid"]."');"); switch($db_item["status"]){ case 0: $status=new CCol(S_ACTIVE,"enabled"); break; case 1: $status=new CCol(S_DISABLED,"disabled"); break; case 3: $status=new CCol(S_NOT_SUPPORTED,"unknown"); break; default:$status=S_UNKNOWN; } $table->AddRow(array( !isset($hostid) ? $db_item["host"] : null, $description, $db_item["key_"], $db_item["delay"], $status )); } unset($db_items, $db_item); $table->Show(); } else if($srctbl == "items") { $table = new CTableInfo(S_NO_GROUPS_DEFINED); $table->SetHeader(array( (isset($hostid) ? null : S_HOST), S_DESCRIPTION, S_TYPE, S_TYPE_OF_INFORMATION, S_STATUS )); $sql = 'SELECT DISTINCT h.host,i.* from hosts h,items i '. ' WHERE h.hostid=i.hostid '. ' AND '.DBin_node('i.itemid', $nodeid). ' AND '.DBcondition('h.hostid',$available_hosts). ' AND h.status in ('.implode(',', $host_status).')'; if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= " order by h.host, i.description, i.key_, i.itemid"; $result = DBselect($sql); while($row = DBfetch($result)) { $row["description"] = item_description($row["description"],$row["key_"]); $description = new CLink($row["description"],"#","action"); $row["description"] = $row['host'].':'.$row["description"]; if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $description->SetAction($action." close_window(); return false;"); $table->AddRow(array( (isset($hostid) ? null : $row['host']), $description, item_type2str($row['type']), item_value_type2str($row['value_type']), new CSpan(item_status2str($row['status']),item_status2style($row['status'])) )); } $table->Show(); } else if($srctbl == "applications") { $table = new CTableInfo(S_NO_APPLICATIONS_DEFINED); $table->SetHeader(array( (isset($hostid) ? null : S_HOST), S_NAME)); $sql = 'SELECT DISTINCT h.host,a.* '. ' FROM hosts h,applications a '. ' WHERE h.hostid=a.hostid '. ' AND '.DBin_node('a.applicationid', $nodeid). ' and '.DBcondition('h.hostid',$available_hosts). ' and h.status in ('.implode(',', $host_status).')'; if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= " order by h.host,a.name"; $result = DBselect($sql); while($row = DBfetch($result)) { $name = new CLink($row["name"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow(array(isset($hostid) ? null : $row['host'], $name)); } $table->Show(); } else if($srctbl == "nodes") { $table = new CTableInfo(S_NO_NODES_DEFINED); $table->SetHeader(S_NAME); $result = DBselect('SELECT DISTINCT * from nodes where nodeid in ('.$available_nodes.')'); while($row = DBfetch($result)) { $name = new CLink($row["name"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == "graphs"){ $table = new CTableInfo(S_NO_GRAPHS_DEFINED); $table->SetHeader(array( isset($hostid)?null:S_HOST, S_NAME, S_GRAPH_TYPE )); $available_graphs = get_accessible_graphs(PERM_READ_ONLY, PERM_RES_IDS_ARRAY, $nodeid); $sql = 'SELECT DISTINCT g.graphid,g.name,g.graphtype,h.host '. ' FROM graphs g,graphs_items gi,items i,hosts h '. ' WHERE gi.graphid=g.graphid '. ' AND i.itemid=gi.itemid '. ' AND h.hostid=i.hostid '. ' AND h.status='.HOST_STATUS_MONITORED. ' AND '.DBcondition('g.graphid',$available_graphs); if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= ' ORDER BY h.host,g.name'; $result=DBselect($sql); while($row=DBfetch($result)){ $row['node_name'] = get_node_name_by_elid($row['graphid']); $name = $row['node_name'].$row['host'].':'.$row['name']; $description = new CLink($row['name'],'#','action'); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $name); } $description->SetAction($action." close_window(); return false;"); switch($row['graphtype']){ case GRAPH_TYPE_STACKED: $graphtype = S_STACKED; break; case GRAPH_TYPE_PIE: $graphtype = S_PIE; break; case GRAPH_TYPE_EXPLODED: $graphtype = S_EXPLODED; break; default: $graphtype = S_NORMAL; break; } $table->AddRow(array( isset($hostid)?null:$row['host'], $description, $graphtype )); unset($description); } $table->Show(); } else if($srctbl == "simple_graph"){ $table = new CTableInfo(S_NO_ITEMS_DEFINED); $table->SetHeader(array( (isset($hostid) ? null : S_HOST), S_DESCRIPTION, S_TYPE, S_TYPE_OF_INFORMATION, S_STATUS )); $sql = 'SELECT n.name as node_name,h.host,i.*,i.key_ '. ' FROM hosts h,items i '. ' left join nodes n on n.nodeid='.DBid2nodeid('i.itemid'). ' WHERE h.hostid=i.hostid '. ' AND h.status='.HOST_STATUS_MONITORED. ' AND i.status='.ITEM_STATUS_ACTIVE. ' AND '.DBin_node('i.itemid', $nodeid). ' AND '.DBcondition('h.hostid',$available_hosts); if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= " order by h.host, i.description, i.key_, i.itemid"; $result = DBselect($sql); while($row = DBfetch($result)){ $row['node_name'] = isset($row['node_name']) ? '('.$row['node_name'].') ' : ''; $row["description"] = item_description($row["description"],$row["key_"]); $description = new CLink($row["description"],"#","action"); $row["description"] = $row['node_name'].$row['host'].':'.$row["description"]; if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]); } $description->SetAction($action." close_window(); return false;"); $table->AddRow(array( (isset($hostid) ? null : $row['host']), $description, item_type2str($row['type']), item_value_type2str($row['value_type']), new CSpan(item_status2str($row['status']),item_status2style($row['status'])) )); } $table->Show(); } else if($srctbl == "sysmaps") { $table = new CTableInfo(S_NO_MAPS_DEFINED); $table->SetHeader(array(S_NAME)); $sql = 'SELECT n.name as node_name, s.sysmapid,s.name '. ' FROM sysmaps s'. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('s.sysmapid'). ' WHERE '.DBin_node('s.sysmapid', $nodeid). ' ORDER BY s.name'; $result=DBselect($sql); while($row=DBfetch($result)){ if(!sysmap_accessible($row["sysmapid"],PERM_READ_ONLY)) continue; $row['node_name'] = isset($row['node_name']) ? '('.$row['node_name'].') ' : ''; $name = $row['node_name'].$row['name']; $description = new CLink($row['name'],'#','action'); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $name); } $description->SetAction($action." close_window(); return false;"); $table->AddRow($description); unset($description); } $table->Show(); } else if($srctbl == "plain_text"){ $table = new CTableInfo(S_NO_ITEMS_DEFINED); $table->SetHeader(array( (isset($hostid) ? null : S_HOST), S_DESCRIPTION, S_TYPE, S_TYPE_OF_INFORMATION, S_STATUS )); $sql = 'SELECT n.name as node_name,h.host,i.*,i.key_ '. ' FROM hosts h,items i '. ' left join nodes n on n.nodeid='.DBid2nodeid('i.itemid'). ' WHERE h.hostid=i.hostid '. ' AND h.status='.HOST_STATUS_MONITORED. ' AND i.status='.ITEM_STATUS_ACTIVE. ' AND '.DBin_node('i.itemid', $nodeid). ' AND '.DBcondition('h.hostid',$available_hosts); if(isset($hostid)) $sql .= ' AND h.hostid='.$hostid; $sql .= ' ORDER BY h.host, i.description, i.key_, i.itemid'; $result = DBselect($sql); while($row = DBfetch($result)) { $row['node_name'] = isset($row['node_name']) ? '('.$row['node_name'].') ' : ''; $row["description"] = item_description($row["description"],$row["key_"]); $description = new CLink($row["description"],"#","action"); $row["description"] = $row['node_name'].$row['host'].':'.$row["description"]; if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srctbl). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]); } $description->SetAction($action." close_window(); return false;"); $table->AddRow(array( (isset($hostid) ? null : $row['host']), $description, item_type2str($row['type']), item_value_type2str($row['value_type']), new CSpan(item_status2str($row['status']),item_status2style($row['status'])) )); } $table->Show(); } else if('slides' == $srctbl) { require_once "include/screens.inc.php"; $table = new CTableInfo(S_NO_NODES_DEFINED); $table->SetHeader(S_NAME); $result = DBselect('select slideshowid,name from slideshows where '.DBin_node('slideshowid',$nodeid).' order by name'); while($row=DBfetch($result)){ if(!slideshow_accessible($row["slideshowid"], PERM_READ_ONLY)) continue; $name = new CLink($row["name"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == 'screens') { require_once "include/screens.inc.php"; $table = new CTableInfo(S_NO_NODES_DEFINED); $table->SetHeader(S_NAME); $result = DBselect('select screenid,name from screens where '.DBin_node('screenid',$nodeid).' order by name'); while($row=DBfetch($result)) { if(!screen_accessible($row["screenid"], PERM_READ_ONLY)) continue; $name = new CLink($row["name"],"#","action"); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == 'screens2') { require_once "include/screens.inc.php"; $table = new CTableInfo(S_NO_NODES_DEFINED); $table->SetHeader(S_NAME); $result = DBselect('SELECT DISTINCT n.name as node_name,s.screenid,s.name '. ' FROM screens s '. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('s.screenid'). ' WHERE '.DBin_node('s.screenid',$nodeid). ' ORDER BY s.name'); while($row=DBfetch($result)) { if(!screen_accessible($row["screenid"], PERM_READ_ONLY)) continue; if(check_screen_recursion($_REQUEST['screenid'],$row['screenid'])) continue; $row['node_name'] = isset($row['node_name']) ? '('.$row['node_name'].') ' : ''; $name = new CLink($row['name'],'#','action'); $row['name'] = $row['node_name'].$row['name']; if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == "overview") { $table = new CTableInfo(S_NO_GROUPS_DEFINED); $table->SetHeader(S_NAME); $result = DBselect('SELECT DISTINCT n.name as node_name,g.groupid,g.name '. ' FROM hosts_groups hg,hosts h,groups g '. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('g.groupid'). ' WHERE '.DBin_node('g.groupid',$nodeid). ' AND g.groupid=hg.groupid '. ' AND hg.hostid=h.hostid '. ' AND h.status='.HOST_STATUS_MONITORED. ' ORDER BY g.name'); while($row=DBfetch($result)) { $row['node_name'] = isset($row['node_name']) ? '('.$row['node_name'].') ' : ''; $name = new CLink($row['name'],'#','action'); $row['name'] = $row['node_name'].$row['name']; if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). (isset($srcfld2) ? get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]) : ''); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); } $table->Show(); } else if($srctbl == 'host_group_scr'){ $available_groups = get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY); $table = new CTableInfo(S_NO_GROUPS_DEFINED); $table->SetHeader(array(S_NAME)); $db_groups = DBselect('SELECT DISTINCT n.name as node_name,g.groupid,g.name,n.nodeid '. ' FROM hosts_groups hg, groups g '. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('g.groupid'). ' WHERE g.groupid IN ('.$available_groups.') '. ' AND '.DBin_node('g.groupid',$nodeid). ' ORDER BY n.nodeid,g.name'); $all = false; while($row = DBfetch($db_groups)) { $row['node_name'] = isset($row['node_name'])?'('.$row['node_name'].') ':''; if(!$all){ $name = new CLink(bold(S_MINUS_ALL_GROUPS_MINUS),'#','action'); if(isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard')){ $action = get_window_opener($dstfrm, $dstfld1, $srcfld2). get_window_opener($dstfrm, $dstfld2, create_id_by_nodeid(0,$nodeid)). "window.opener.setTimeout('add2favorites();', 1000);"; } else{ $action = get_window_opener($dstfrm, $dstfld1, create_id_by_nodeid(0,$nodeid)). get_window_opener($dstfrm, $dstfld2, $row['node_name'].S_MINUS_ALL_GROUPS_MINUS); } $name->SetAction($action." close_window(); return false;"); $table->AddRow($name); $all = true; } $name = new CLink($row['name'],'#','action'); $row['name'] = $row['node_name'].$row['name']; $name->SetAction( get_window_opener($dstfrm, $dstfld1, $row[$srcfld1]). get_window_opener($dstfrm, $dstfld2, $row[$srcfld2]). ((isset($_REQUEST['reference']) && ($_REQUEST['reference'] =='dashboard'))?"window.opener.setTimeout('add2favorites();', 1000);":''). ' return close_window();'); $table->AddRow($name); } $table->Show(); } ?>