package main
import (
"fmt"
"net/http"
"strings"
)
type (
group struct {
GroupId int
Name string
NodeId int
NodeName string
State int
MappingId int
}
)
func showGroups(con *Context) {
query := `select
group_id,
group_name,
node_id,
node_name,
mapping_id,
state
from (
select
g.id group_id,
g.name group_name,
n.id node_id,
n.name node_name,
ac.states[1] state,
ac.mapping_id,
ac.acknowledged,
row_number() over (partition by c.node_id order by ac.states[1] desc) maxstate
from groups g
join nodes_groups ng on g.id = ng.group_id
join nodes n on ng.node_id = n.id
join checks c on n.id = c.node_id
join active_checks ac on c.id = ac.check_id
%s
order by g.name, n.name
) groups
where maxstate = 1`
if strings.HasPrefix(con.r.URL.Path, "/unhandled") {
query = fmt.Sprintf(query, `where ac.states[1] != 0 and acknowledged = false`)
con.Unhandled = true
} else {
query = fmt.Sprintf(query, "")
}
rows, err := DB.Query(query)
if err != nil {
con.w.WriteHeader(http.StatusInternalServerError)
con.w.Write([]byte("problems with the database"))
con.log.Info("could not get check list", "error", err)
return
}
groups := []group{}
for rows.Next() {
g := group{}
err := rows.Scan(&g.GroupId, &g.Name, &g.NodeId, &g.NodeName, &g.MappingId, &g.State)
if err != nil {
con.w.WriteHeader(http.StatusInternalServerError)
con.w.Write([]byte("problems with the database"))
con.log.Info("could not get check list", "error", err)
return
}
groups = append(groups, g)
}
con.Groups = groups
if err := con.loadMappings(); err != nil {
con.w.WriteHeader(http.StatusInternalServerError)
con.w.Write([]byte("problem with the mappings"))
con.log.Info("could not load mappings", "error", err)
return
}
con.w.Header()["Content-Type"] = []string{"text/html"}
con.Render("grouplist")
return
}
