evolution-cms /
evolution
@@ -1,9 +1,9 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | if( ! defined('IN_MANAGER_MODE') || IN_MANAGER_MODE !== true) {
|
| 3 | - die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly.");
|
|
| 3 | + die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the EVO Content Manager instead of accessing this file directly.");
|
|
| 4 | 4 | } |
| 5 | 5 | if(!$modx->hasPermission('view_eventlog')) {
|
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | // Get table Names (alphabetical) |
@@ -16,14 +16,14 @@ discard block |
||
| 16 | 16 | |
| 17 | 17 | // get and save search string |
| 18 | 18 | if($_REQUEST['op'] == 'reset') {
|
| 19 | - $sqlQuery = $query = ''; |
|
| 20 | - $_PAGE['vs']['search'] = ''; |
|
| 19 | + $sqlQuery = $query = ''; |
|
| 20 | + $_PAGE['vs']['search'] = ''; |
|
| 21 | 21 | } else {
|
| 22 | - $sqlQuery = $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 23 | - if(!is_numeric($sqlQuery)) {
|
|
| 24 | - $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 25 | - } |
|
| 26 | - $_PAGE['vs']['search'] = $query; |
|
| 22 | + $sqlQuery = $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 23 | + if(!is_numeric($sqlQuery)) {
|
|
| 24 | + $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 25 | + } |
|
| 26 | + $_PAGE['vs']['search'] = $query; |
|
| 27 | 27 | } |
| 28 | 28 | |
| 29 | 29 | // get & save listmode |
@@ -124,32 +124,32 @@ discard block |
||
| 124 | 124 | <div class="row"> |
| 125 | 125 | <div class="table-responsive"> |
| 126 | 126 | <?php |
| 127 | - $ds = $modx->getDatabase()->select("el.id, ELT(el.type , 'text-info {$_style['actions_info']}' , 'text-warning {$_style['actions_triangle']}' , 'text-danger {$_style['actions_error']}' ) as icon, el.createdon, el.source, el.eventid,IFNULL(wu.username,mu.username) as username", "{$tbl_event_log} AS el
|
|
| 127 | + $ds = $modx->getDatabase()->select("el.id, ELT(el.type , 'text-info {$_style['actions_info']}' , 'text-warning {$_style['actions_triangle']}' , 'text-danger {$_style['actions_error']}' ) as icon, el.createdon, el.source, el.eventid,IFNULL(wu.username,mu.username) as username", "{$tbl_event_log} AS el
|
|
| 128 | 128 | LEFT JOIN {$tbl_manager_users} AS mu ON mu.id=el.user AND el.usertype=0
|
| 129 | 129 | LEFT JOIN {$tbl_web_users} AS wu ON wu.id=el.user AND el.usertype=1", ($sqlQuery ? "" . (is_numeric($sqlQuery) ? "(eventid='{$sqlQuery}') OR " : '') . "(source LIKE '%{$sqlQuery}%') OR (description LIKE '%{$sqlQuery}%')" : ""), "createdon DESC");
|
| 130 | - $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items
|
|
| 131 | - $grd->pagerClass = ''; |
|
| 132 | - $grd->pageClass = 'page-item'; |
|
| 133 | - $grd->selPageClass = 'page-item active'; |
|
| 134 | - $grd->noRecordMsg = $_lang['no_records_found']; |
|
| 135 | - $grd->cssClass = "table data nowrap"; |
|
| 136 | - $grd->columnHeaderClass = "tableHeader"; |
|
| 137 | - $grd->itemClass = "tableItem"; |
|
| 138 | - $grd->altItemClass = "tableAltItem"; |
|
| 139 | - $grd->fields = "type,source,createdon,eventid,username"; |
|
| 140 | - $grd->columns = $_lang['type'] . " ," . $_lang['source'] . " ," . $_lang['date'] . " ," . $_lang['event_id'] . " ," . $_lang['sysinfo_userid']; |
|
| 141 | - $grd->colWidths = "1%,,1%,1%,1%"; |
|
| 142 | - $grd->colAligns = "center,,,center,center"; |
|
| 143 | - $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang['click_to_context'] . "'><i class='[+icon+]'></i></a>||template:<a href='index.php?a=115&id=[+id+]' title='" . $_lang['click_to_view_details'] . "'>[+source+]</a>||date: " . $modx->toDateFormat(null, 'formatOnly') . ' %I:%M %p'; |
|
| 144 | - if($listmode == '1') {
|
|
| 145 | - $grd->pageSize = 0; |
|
| 146 | - } |
|
| 147 | - if($_REQUEST['op'] == 'reset') {
|
|
| 148 | - $grd->pageNumber = 1; |
|
| 149 | - } |
|
| 150 | - // render grid |
|
| 151 | - echo $grd->render(); |
|
| 152 | - ?> |
|
| 130 | + $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items
|
|
| 131 | + $grd->pagerClass = ''; |
|
| 132 | + $grd->pageClass = 'page-item'; |
|
| 133 | + $grd->selPageClass = 'page-item active'; |
|
| 134 | + $grd->noRecordMsg = $_lang['no_records_found']; |
|
| 135 | + $grd->cssClass = "table data nowrap"; |
|
| 136 | + $grd->columnHeaderClass = "tableHeader"; |
|
| 137 | + $grd->itemClass = "tableItem"; |
|
| 138 | + $grd->altItemClass = "tableAltItem"; |
|
| 139 | + $grd->fields = "type,source,createdon,eventid,username"; |
|
| 140 | + $grd->columns = $_lang['type'] . " ," . $_lang['source'] . " ," . $_lang['date'] . " ," . $_lang['event_id'] . " ," . $_lang['sysinfo_userid']; |
|
| 141 | + $grd->colWidths = "1%,,1%,1%,1%"; |
|
| 142 | + $grd->colAligns = "center,,,center,center"; |
|
| 143 | + $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang['click_to_context'] . "'><i class='[+icon+]'></i></a>||template:<a href='index.php?a=115&id=[+id+]' title='" . $_lang['click_to_view_details'] . "'>[+source+]</a>||date: " . $modx->toDateFormat(null, 'formatOnly') . ' %I:%M %p'; |
|
| 144 | + if($listmode == '1') {
|
|
| 145 | + $grd->pageSize = 0; |
|
| 146 | + } |
|
| 147 | + if($_REQUEST['op'] == 'reset') {
|
|
| 148 | + $grd->pageNumber = 1; |
|
| 149 | + } |
|
| 150 | + // render grid |
|
| 151 | + echo $grd->render(); |
|
| 152 | + ?> |
|
| 153 | 153 | </div> |
| 154 | 154 | </div> |
| 155 | 155 | </div> |
