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,userinfo,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 manager LIKE '%" . $_POST['query_other'] . "%'"; |
---|
89 | } |
---|
90 | |
---|
91 | $query .= " ORDER by date DESC"; |
---|
92 | |
---|
93 | $GLOBALS['phpgw']->db->query($query); |
---|
94 | while($GLOBALS['phpgw']->db->next_record()) |
---|
95 | { |
---|
96 | $logs[] = $GLOBALS['phpgw']->db->row(); |
---|
97 | } |
---|
98 | } |
---|
99 | |
---|
100 | $var = Array( |
---|
101 | 'bg_color' => $GLOBALS['phpgw_info']['theme']['bg_color'], |
---|
102 | 'th_bg' => $GLOBALS['phpgw_info']['theme']['th_bg'], |
---|
103 | 'back_url' => $GLOBALS['phpgw']->link('/expressoAdmin1_2/index.php'), |
---|
104 | 'search_action' => $GLOBALS['phpgw']->link('/index.php','menuaction=expressoAdmin1_2.uilogs.list_logs'), |
---|
105 | |
---|
106 | 'query_manager_lid' => $_POST['query_manager_lid'], |
---|
107 | 'query_action' => $_POST['query_action'], |
---|
108 | 'query_date' => $_POST['query_date'], |
---|
109 | 'query_hour' => $_POST['query_hour'], |
---|
110 | 'query_other' => $_POST['query_other'], |
---|
111 | ); |
---|
112 | $p->set_var($var); |
---|
113 | $p->set_var($this->functions->make_dinamic_lang($p, 'list')); |
---|
114 | |
---|
115 | if ((!count($logs)) && (($_POST['query_manager_lid'] != '') || ($_POST['query_date'] != '') || ($_POST['query_hour'] != ''))) |
---|
116 | { |
---|
117 | $p->set_var('message',lang('No matches found')); |
---|
118 | } |
---|
119 | else if (count($logs)) |
---|
120 | { |
---|
121 | foreach ($logs as $log) |
---|
122 | { |
---|
123 | //_debug_array($log); |
---|
124 | $this->nextmatchs->template_alternate_row_color($p); |
---|
125 | |
---|
126 | //Date treatment |
---|
127 | $a_date = preg_split('/ /', $log['date']); |
---|
128 | $a_day = preg_split('/-/', $a_date[0]); |
---|
129 | $a_day_tmp = array_reverse($a_day); |
---|
130 | $a_day = join($a_day_tmp, "/"); |
---|
131 | $a_hour = preg_split('/\./', $a_date[1]); |
---|
132 | |
---|
133 | $var = array( |
---|
134 | 'row_date' => $a_day . ' ' . $a_hour[0], |
---|
135 | 'row_manager_lid' => $log['manager'], |
---|
136 | 'row_action' => lang($log['action']), |
---|
137 | 'row_about' => $log['userinfo'] |
---|
138 | ); |
---|
139 | $p->set_var($var); |
---|
140 | $p->set_var('row_view',$this->row_action('view','log',$log['date'])); |
---|
141 | $p->parse('rows','row',True); |
---|
142 | } |
---|
143 | } |
---|
144 | $p->parse('rows','row_empty',True); |
---|
145 | $p->pfp('out','list'); |
---|
146 | } |
---|
147 | |
---|
148 | function row_action($action,$type,$date) |
---|
149 | { |
---|
150 | return '<a href="'.$GLOBALS['phpgw']->link('/index.php',Array( |
---|
151 | 'menuaction' => 'expressoAdmin1_2.uilogs.'.$action.'_'.$type, |
---|
152 | 'date' => $date |
---|
153 | )).'"> '.lang($action).' </a>'; |
---|
154 | } |
---|
155 | } |
---|
156 | ?> |
---|