1 | <?php |
---|
2 | /************************************************************************************\ |
---|
3 | * Expresso Administração * |
---|
4 | * by Joao Alfredo Knopik Junior (joao.alfredo@gmail.com, jakjr@celepar.pr.gov.br) * |
---|
5 | * -----------------------------------------------------------------------------------* |
---|
6 | * This program is free software; you can redistribute it and/or modify it * |
---|
7 | * under the terms of the GNU General Public License as published by the * |
---|
8 | * Free Software Foundation; either version 2 of the License, or (at your * |
---|
9 | * option) any later version. * |
---|
10 | \************************************************************************************/ |
---|
11 | |
---|
12 | class uilogs |
---|
13 | { |
---|
14 | var $public_functions = array |
---|
15 | ( |
---|
16 | 'list_logs' => True, |
---|
17 | 'view_log' => True |
---|
18 | ); |
---|
19 | |
---|
20 | var $functions; |
---|
21 | var $nextmatchs; |
---|
22 | |
---|
23 | function uilogs() |
---|
24 | { |
---|
25 | $this->functions = createobject('expressoAdmin1_2.functions'); |
---|
26 | $this->nextmatchs = createobject('phpgwapi.nextmatchs'); |
---|
27 | } |
---|
28 | |
---|
29 | function list_logs() |
---|
30 | { |
---|
31 | $account_lid = $GLOBALS['phpgw']->accounts->data['account_lid']; |
---|
32 | $tmp = $this->functions->read_acl($account_lid); |
---|
33 | $manager_context = $tmp[0]['context']; |
---|
34 | |
---|
35 | // Verifica se o administrador tem acesso. |
---|
36 | if (!$this->functions->check_acl($account_lid,'view_logs')) |
---|
37 | { |
---|
38 | $GLOBALS['phpgw']->redirect($GLOBALS['phpgw']->link('/expressoAdmin1_2/inc/access_denied.php')); |
---|
39 | } |
---|
40 | |
---|
41 | unset($GLOBALS['phpgw_info']['flags']['noheader']); |
---|
42 | unset($GLOBALS['phpgw_info']['flags']['nonavbar']); |
---|
43 | $GLOBALS['phpgw_info']['flags']['app_header'] = $GLOBALS['phpgw_info']['apps']['expressoAdmin1_2']['title'].' - '.lang('Logs'); |
---|
44 | $GLOBALS['phpgw']->common->phpgw_header(); |
---|
45 | |
---|
46 | $p = CreateObject('phpgwapi.Template',PHPGW_APP_TPL); |
---|
47 | $p->set_file(Array('logs' => 'logs.tpl')); |
---|
48 | $p->set_block('logs','list','list'); |
---|
49 | $p->set_block('logs','row','row'); |
---|
50 | $p->set_block('logs','row_empty','row_empty'); |
---|
51 | |
---|
52 | //Administrador realizou uma pesquisa no log |
---|
53 | if (($_POST['query_manager_lid'] != '') || ($_POST['query_action'] != '') || ($_POST['query_date'] != '') || ($_POST['query_hour'] != '') || ($_POST['query_other'] != '')) |
---|
54 | { |
---|
55 | $query = "SELECT manager,date,groupinfo,userinfo,appinfo,msg,action FROM phpgw_expressoadmin_log WHERE"; |
---|
56 | |
---|
57 | if ($_POST['query_manager_lid'] != '') |
---|
58 | { |
---|
59 | $query .= " manager LIKE '%".$_POST['query_manager_lid']."%'"; |
---|
60 | } |
---|
61 | |
---|
62 | if ($_POST['query_date'] != '') |
---|
63 | { |
---|
64 | if ($_POST['query_manager_lid'] != '') |
---|
65 | $query .= " AND"; |
---|
66 | |
---|
67 | if ($_POST['query_hour'] != '') |
---|
68 | $query .= " date > TO_TIMESTAMP('".$_POST['query_date'].$_POST['query_hour']."','DD/MM/YYYYHH24:MI') AND date < TO_TIMESTAMP('".$_POST['query_date'].$_POST['query_hour']."','DD/MM/YYYYHH24:MI') + INTERVAL '1 minute'"; |
---|
69 | else |
---|
70 | $query .= " date > TO_TIMESTAMP('".$_POST['query_date']."','DD/MM/YYYY') AND date < TO_TIMESTAMP('".$_POST['query_date']."','DD/MM/YYYY') + INTERVAL '1 day'"; |
---|
71 | } |
---|
72 | |
---|
73 | if ($_POST['query_action']) |
---|
74 | { |
---|
75 | if (($_POST['query_manager_lid'] != '') || ($_POST['query_date'] != '')) |
---|
76 | $query .= " AND"; |
---|
77 | |
---|
78 | $query .= " action LIKE '%".$_POST['query_action']."%'"; |
---|
79 | } |
---|
80 | |
---|
81 | if ($_POST['query_other']) |
---|
82 | { |
---|
83 | if (($_POST['query_manager_lid'] != '') || ($_POST['query_date'] != '') || ($_POST['query_action'] != '')) |
---|
84 | $query .= " AND"; |
---|
85 | |
---|
86 | $query .= " userinfo LIKE '%" . $_POST['query_other'] . "%'"; |
---|
87 | $query .= "OR action LIKE '%" . $_POST['query_other'] . "%'"; |
---|
88 | $query .= "OR groupinfo LIKE '%" . $_POST['query_other'] . "%'"; |
---|
89 | $query .= "OR appinfo LIKE '%" . $_POST['query_other'] . "%'"; |
---|
90 | $query .= "OR msg LIKE '%" . $_POST['query_other'] . "%'"; |
---|
91 | $query .= "OR manager LIKE '%" . $_POST['query_other'] . "%'"; |
---|
92 | } |
---|
93 | |
---|
94 | $query .= " ORDER by manager ASC, date DESC"; |
---|
95 | |
---|
96 | $GLOBALS['phpgw']->db->query($query); |
---|
97 | while($GLOBALS['phpgw']->db->next_record()) |
---|
98 | { |
---|
99 | $logs[] = $GLOBALS['phpgw']->db->row(); |
---|
100 | } |
---|
101 | } |
---|
102 | |
---|
103 | $var = Array( |
---|
104 | 'bg_color' => $GLOBALS['phpgw_info']['theme']['bg_color'], |
---|
105 | 'th_bg' => $GLOBALS['phpgw_info']['theme']['th_bg'], |
---|
106 | 'back_url' => $GLOBALS['phpgw']->link('/expressoAdmin1_2/index.php'), |
---|
107 | 'search_action' => $GLOBALS['phpgw']->link('/index.php','menuaction=expressoAdmin1_2.uilogs.list_logs'), |
---|
108 | |
---|
109 | 'query_manager_lid' => $_POST['query_manager_lid'], |
---|
110 | 'query_action' => $_POST['query_action'], |
---|
111 | 'query_date' => $_POST['query_date'], |
---|
112 | 'query_hour' => $_POST['query_hour'], |
---|
113 | 'query_other' => $_POST['query_other'], |
---|
114 | |
---|
115 | 'lang_manager_lid' => lang('Manager Login'), |
---|
116 | 'lang_date' => lang('Date'), |
---|
117 | 'lang_hour' => lang('Hour'), |
---|
118 | 'lang_action' => lang('Action'), |
---|
119 | 'lang_view' => lang('view'), |
---|
120 | 'lang_back' => lang('back'), |
---|
121 | 'lang_search' => lang('search'), |
---|
122 | 'lang_action' => lang('Action'), |
---|
123 | 'lang_other' => lang('Other') |
---|
124 | ); |
---|
125 | $p->set_var($var); |
---|
126 | |
---|
127 | |
---|
128 | if ((!count($logs)) && (($_POST['query_manager_lid'] != '') || ($_POST['query_date'] != '') || ($_POST['query_hour'] != ''))) |
---|
129 | { |
---|
130 | $p->set_var('message',lang('No matches found')); |
---|
131 | } |
---|
132 | else if (count($logs)) |
---|
133 | { |
---|
134 | foreach ($logs as $log) |
---|
135 | { |
---|
136 | //_debug_array($log); |
---|
137 | $this->nextmatchs->template_alternate_row_color($p); |
---|
138 | |
---|
139 | $var = array( |
---|
140 | 'row_manager_lid' => $log['manager'], |
---|
141 | 'row_action' => $log['action'], |
---|
142 | 'row_date' => $log['date'], |
---|
143 | //'row_view' => (!$account['account_lastname']?' ':$account['account_lastname']) |
---|
144 | ); |
---|
145 | $p->set_var($var); |
---|
146 | $p->set_var('row_view',$this->row_action('view','log',$log['date'])); |
---|
147 | $p->parse('rows','row',True); |
---|
148 | } |
---|
149 | } |
---|
150 | $p->parse('rows','row_empty',True); |
---|
151 | $p->pfp('out','list'); |
---|
152 | } |
---|
153 | |
---|
154 | function view_log() |
---|
155 | { |
---|
156 | $account_lid = $GLOBALS['phpgw']->accounts->data['account_lid']; |
---|
157 | $tmp = $this->functions->read_acl($account_lid); |
---|
158 | $manager_context = $tmp[0]['context']; |
---|
159 | |
---|
160 | // Verifica se o administrador tem acesso. |
---|
161 | if (!$this->functions->check_acl($account_lid,'view_logs')) |
---|
162 | { |
---|
163 | $GLOBALS['phpgw']->redirect($GLOBALS['phpgw']->link('/expressoAdmin1_2/inc/access_denied.php')); |
---|
164 | } |
---|
165 | |
---|
166 | unset($GLOBALS['phpgw_info']['flags']['noheader']); |
---|
167 | unset($GLOBALS['phpgw_info']['flags']['nonavbar']); |
---|
168 | $GLOBALS['phpgw_info']['flags']['app_header'] = $GLOBALS['phpgw_info']['apps']['expressoAdmin1_2']['title'].' - '.lang('View Log'); |
---|
169 | $GLOBALS['phpgw']->common->phpgw_header(); |
---|
170 | |
---|
171 | $p = CreateObject('phpgwapi.Template',PHPGW_APP_TPL); |
---|
172 | $p->set_file(Array('log' => 'log_form.tpl')); |
---|
173 | |
---|
174 | $query = "SELECT manager,date,groupinfo,userinfo,appinfo,msg,action FROM phpgw_expressoadmin_log"; |
---|
175 | $query .= " WHERE date = '".$_GET['date']."'"; |
---|
176 | |
---|
177 | $GLOBALS['phpgw']->db->query($query); |
---|
178 | while($GLOBALS['phpgw']->db->next_record()) |
---|
179 | { |
---|
180 | $log[] = $GLOBALS['phpgw']->db->row(); |
---|
181 | } |
---|
182 | |
---|
183 | $tmp = explode(" ", $log[0]['date']); |
---|
184 | $tmp_date = explode("-", $tmp[0]); |
---|
185 | $date = $tmp_date[2] . '/' . $tmp_date[1] . '/' . $tmp_date[0]; |
---|
186 | |
---|
187 | $tmp_hour = explode(".", $tmp[1]); |
---|
188 | $hour = $tmp_hour[0]; |
---|
189 | |
---|
190 | $var = Array( |
---|
191 | |
---|
192 | 'manager_lid' => $log[0]['manager'], |
---|
193 | 'date' => $date, |
---|
194 | 'hour' => $hour, |
---|
195 | 'action' => $log[0]['action'], |
---|
196 | 'userinfo' => $log[0]['userinfo'], |
---|
197 | 'groupinfo' => $log[0]['groupinfo'], |
---|
198 | 'appinfo' => $log[0]['appinfo'], |
---|
199 | 'back_url' => './index.php?menuaction=expressoAdmin1_2.uilogs.list_logs', |
---|
200 | |
---|
201 | 'color_bg1' => "#E8F0F0", |
---|
202 | 'color_bg2' => "#D3DCE3", |
---|
203 | 'color_font1' => "#DDDDDD", |
---|
204 | 'color_font2' => "#EEEEEE", |
---|
205 | |
---|
206 | 'lang_back' => lang('Back'), |
---|
207 | 'lang_manager_lid' => lang('Manager Login'), |
---|
208 | 'lang_date' => lang('Date'), |
---|
209 | 'lang_hour' => lang('Hour'), |
---|
210 | 'lang_action' => lang('Action'), |
---|
211 | 'lang_userinfo' => lang('User Info'), |
---|
212 | 'lang_groupinfo' => lang('Group Info'), |
---|
213 | 'lang_appinfo' => lang('App Info') |
---|
214 | ); |
---|
215 | |
---|
216 | $p->set_var($var); |
---|
217 | $p->pfp('out','log'); |
---|
218 | } |
---|
219 | |
---|
220 | function row_action($action,$type,$date) |
---|
221 | { |
---|
222 | return '<a href="'.$GLOBALS['phpgw']->link('/index.php',Array( |
---|
223 | 'menuaction' => 'expressoAdmin1_2.uilogs.'.$action.'_'.$type, |
---|
224 | 'date' => $date |
---|
225 | )).'"> '.lang($action).' </a>'; |
---|
226 | } |
---|
227 | } |
---|
228 | ?> |
---|