$errarr = array();
$cnt = 0;
//проходим все сервера Zabbix
$sql = "select * from zabbix_mod_cfg";
$result = $sqlcn->ExecuteSQL($sql) or die("Не могу выбрать список серверов zabbix!" . mysqli_error($sqlcn->idsqlconnection));
while ($row = mysqli_fetch_array($result)) {
$idz = $row["id"];
$sname = $row["sname"];
$host = $row["host"];
$username = $row["username"];
$pass = $row["pass"];
$basename = $row["basename"];
$zb->connect($host, $username, $pass, $basename);
//получаем информацию с dashboard
$sql = "SELECT g.groupid,h.host,t.triggerid,g.name group_name,t.priority priority \n FROM hosts h,items i,hosts_groups hg,groups g,functions f, triggers t \n WHERE h.status = 0 AND h.hostid = i.hostid AND hg.groupid = g.groupid AND hg.hostid = h.hostid AND i.status = 0 AND i.itemid = f.itemid AND t.triggerid = f.triggerid AND t.VALUE = 1 AND t.status = 0\n GROUP BY t.triggerid,g.name, t.priority";
$result2 = $zb->ExecuteSQL($sql) or die("Не могу выбрать список dashboard zabbix!" . mysqli_error($zb->idsqlconnection));
while ($row2 = mysqli_fetch_array($result2)) {
$gid = $row2["groupid"];
$hosterr = $row2["host"];
$triggerid = $row2["triggerid"];
$group_name = $row2["group_name"];
$priority = $row2["priority"];
$sql = "select * from triggers where triggerid={$triggerid}";
//echo "$sql\n";
$result3 = $zb->ExecuteSQL($sql) or die("Не могу выбрать подробности по триггеру!" . mysqli_error($zb->idsqlconnection));
while ($row3 = mysqli_fetch_array($result3)) {
$description = $row3["description"];
$lastchange = $row3["lastchange"];
$comments = $row3["comments"];
//echo "!!!!";
}
echo '<div class="span6">';
//проходим все сервера Zabbix
$sql = "select * from zabbix_mod_cfg";
$result = $sqlcn->ExecuteSQL($sql) or die("Не могу выбрать список серверов zabbix!" . mysqli_error($sqlcn->idsqlconnection));
while ($row = mysqli_fetch_array($result)) {
$id = $row["id"];
$sname = $row["sname"];
$host = $row["host"];
$username = $row["username"];
$pass = $row["pass"];
$basename = $row["basename"];
$zb->connect($host, $username, $pass, $basename);
//получаес группы из заббикса
echo "<strong>{$sname}</strong></br>";
$sql = "select * from groups";
$result2 = $zb->ExecuteSQL($sql) or die("Не могу выбрать список групп zabbix!" . mysqli_error($zb->idsqlconnection));
while ($row2 = mysqli_fetch_array($result2)) {
$groupid = $row2["groupid"];
$gname = $row2["name"];
$nm = "{$id}" . "_" . "{$groupid}";
$rp = $par->GetByParam($user->id . "_{$nm}");
if ($rp == $nm) {
$ch = "checked";
} else {
$ch = "";
}
echo "</br><input type='checkbox' name={$nm} value={$nm} {$ch}> {$gname}</br>";
}
}
echo "</div>";
echo '<div class="span6">';
