1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
<?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.
**/
?>
<?php
function get_last_event_by_triggerid($triggerid){
$event_data = DBfetch(DBselect('SELECT * '.
' FROM events '.
' WHERE objectid='.$triggerid.
' and object='.EVENT_OBJECT_TRIGGER.
' ORDER BY objectid desc, object desc, eventid desc', 1));
if(!$event_data)
return FALSE;
return $event_data;
}
function get_acknowledges_by_eventid($eventid){
return DBselect("select * from acknowledges where eventid=$eventid");
}
function add_acknowledge_coment($eventid, $userid, $message){
$result = set_event_acnowledged($eventid);
if(!$result)
return $result;
$acknowledgeid = get_dbid("acknowledges","acknowledgeid");
$result = DBexecute("insert into acknowledges (acknowledgeid,userid,eventid,clock,message)".
" values ($acknowledgeid,$userid,$eventid,".time().",".zbx_dbstr($message).")");
if(!$result)
return $result;
return $acknowledgeid;
}
function set_event_acnowledged($eventid){
return DBexecute("update events set acknowledged=1 where eventid=$eventid");
}
function make_acktab_by_eventid($eventid){
$table = new CTableInfo();
$table->SetHeader(array(S_TIME,S_USER, S_COMMENTS));
$acks = get_acknowledges_by_eventid($eventid);
while($ack = DBfetch($acks)){
$user = get_user_by_userid($ack['userid']);
$table->AddRow(array(
date('d-m-Y h:i:s A',$ack['clock']),
$user['alias'],
new CCol(zbx_nl2br($ack['message']),'wraptext')
));
}
return $table;
}
?>
|