@@ -4,8 +4,8 @@ |
||
| 4 | 4 | } |
| 5 | 5 | |
| 6 | 6 | if(!$modx->hasPermission('delete_plugin')) { |
| 7 | - $e->setError(3); |
|
| 8 | - $e->dumpError(); |
|
| 7 | + $e->setError(3); |
|
| 8 | + $e->dumpError(); |
|
| 9 | 9 | } |
| 10 | 10 | |
| 11 | 11 | $tbl_site_plugins = $modx->getDatabase()->getFullTableName('site_plugins'); |
@@ -3,22 +3,22 @@ |
||
| 3 | 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('delete_role')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | $id = isset($_GET['id'])? (int)$_GET['id'] : 0; |
| 10 | 10 | if($id==0) { |
| 11 | - $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 11 | + $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | if($id==1){ |
| 15 | - $modx->webAlertAndQuit("The role you are trying to delete is the admin role. This role cannot be deleted!"); |
|
| 15 | + $modx->webAlertAndQuit("The role you are trying to delete is the admin role. This role cannot be deleted!"); |
|
| 16 | 16 | } |
| 17 | 17 | |
| 18 | 18 | $rs = $modx->getDatabase()->select('COUNT(*)', $modx->getDatabase()->getFullTableName('user_attributes'), "role='{$id}'"); |
| 19 | 19 | $count=$modx->getDatabase()->getValue($rs); |
| 20 | 20 | if($count>0){ |
| 21 | - $modx->webAlertAndQuit("There are users with this role. It can't be deleted."); |
|
| 21 | + $modx->webAlertAndQuit("There are users with this role. It can't be deleted."); |
|
| 22 | 22 | } |
| 23 | 23 | |
| 24 | 24 | // Set the item name for logger |
@@ -3,12 +3,12 @@ discard block |
||
| 3 | 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('delete_plugin')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | $id = isset($_GET['id'])? (int)$_GET['id'] : 0; |
| 10 | 10 | if($id==0) { |
| 11 | - $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 11 | + $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | // Set the item name for logger |
@@ -17,9 +17,9 @@ discard block |
||
| 17 | 17 | |
| 18 | 18 | // invoke OnBeforePluginFormDelete event |
| 19 | 19 | $modx->invokeEvent("OnBeforePluginFormDelete", |
| 20 | - array( |
|
| 21 | - "id" => $id |
|
| 22 | - )); |
|
| 20 | + array( |
|
| 21 | + "id" => $id |
|
| 22 | + )); |
|
| 23 | 23 | |
| 24 | 24 | // delete the plugin. |
| 25 | 25 | $modx->getDatabase()->delete($modx->getDatabase()->getFullTableName('site_plugins'), "id='{$id}'"); |
@@ -29,9 +29,9 @@ discard block |
||
| 29 | 29 | |
| 30 | 30 | // invoke OnPluginFormDelete event |
| 31 | 31 | $modx->invokeEvent("OnPluginFormDelete", |
| 32 | - array( |
|
| 33 | - "id" => $id |
|
| 34 | - )); |
|
| 32 | + array( |
|
| 33 | + "id" => $id |
|
| 34 | + )); |
|
| 35 | 35 | |
| 36 | 36 | // empty cache |
| 37 | 37 | $modx->clearCache('full'); |
@@ -3,7 +3,7 @@ |
||
| 3 | 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('settings')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | $modx->getDatabase()->truncate($modx->getDatabase()->getFullTableName('manager_log')); |
@@ -3,12 +3,12 @@ discard block |
||
| 3 | 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('delete_module')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | $id = isset($_GET['id'])? (int)$_GET['id'] : 0; |
| 10 | 10 | if($id==0) { |
| 11 | - $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 11 | + $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | // Set the item name for logger |
@@ -17,9 +17,9 @@ discard block |
||
| 17 | 17 | |
| 18 | 18 | // invoke OnBeforeModFormDelete event |
| 19 | 19 | $modx->invokeEvent("OnBeforeModFormDelete", |
| 20 | - array( |
|
| 21 | - "id" => $id |
|
| 22 | - )); |
|
| 20 | + array( |
|
| 21 | + "id" => $id |
|
| 22 | + )); |
|
| 23 | 23 | |
| 24 | 24 | // delete the module. |
| 25 | 25 | $modx->getDatabase()->delete($modx->getDatabase()->getFullTableName('site_modules'), "id='{$id}'"); |
@@ -32,9 +32,9 @@ discard block |
||
| 32 | 32 | |
| 33 | 33 | // invoke OnModFormDelete event |
| 34 | 34 | $modx->invokeEvent("OnModFormDelete", |
| 35 | - array( |
|
| 36 | - "id" => $id |
|
| 37 | - )); |
|
| 35 | + array( |
|
| 36 | + "id" => $id |
|
| 37 | + )); |
|
| 38 | 38 | |
| 39 | 39 | // empty cache |
| 40 | 40 | $modx->clearCache('full'); |
@@ -3,12 +3,12 @@ discard block |
||
| 3 | 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('delete_document')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | $id = isset($_REQUEST['id'])? (int)$_REQUEST['id'] : 0; |
| 10 | 10 | if($id==0) { |
| 11 | - $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 11 | + $modx->webAlertAndQuit($_lang["error_no_id"]); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | /************ webber ********/ |
@@ -31,14 +31,14 @@ discard block |
||
| 31 | 31 | $udperms->role = $_SESSION['mgrRole']; |
| 32 | 32 | |
| 33 | 33 | if(!$udperms->checkPermissions()) { |
| 34 | - $modx->webAlertAndQuit($_lang["access_permission_denied"]); |
|
| 34 | + $modx->webAlertAndQuit($_lang["access_permission_denied"]); |
|
| 35 | 35 | } |
| 36 | 36 | |
| 37 | 37 | // get the timestamp on which the document was deleted. |
| 38 | 38 | $rs = $modx->getDatabase()->select('deletedon', $modx->getDatabase()->getFullTableName('site_content'), "id='{$id}' AND deleted=1"); |
| 39 | 39 | $deltime = $modx->getDatabase()->getValue($rs); |
| 40 | 40 | if(!$deltime) { |
| 41 | - $modx->webAlertAndQuit("Couldn't find document to determine it's date of deletion!"); |
|
| 41 | + $modx->webAlertAndQuit("Couldn't find document to determine it's date of deletion!"); |
|
| 42 | 42 | } |
| 43 | 43 | |
| 44 | 44 | $children = array(); |
@@ -46,20 +46,20 @@ discard block |
||
| 46 | 46 | getChildrenForUnDelete($id); |
| 47 | 47 | |
| 48 | 48 | if(count($children)>0) { |
| 49 | - $modx->getDatabase()->update( |
|
| 50 | - array( |
|
| 51 | - 'deleted' => 0, |
|
| 52 | - 'deletedby' => 0, |
|
| 53 | - 'deletedon' => 0, |
|
| 54 | - ), $modx->getDatabase()->getFullTableName('site_content'), "id IN(".implode(", ", $children).")"); |
|
| 49 | + $modx->getDatabase()->update( |
|
| 50 | + array( |
|
| 51 | + 'deleted' => 0, |
|
| 52 | + 'deletedby' => 0, |
|
| 53 | + 'deletedon' => 0, |
|
| 54 | + ), $modx->getDatabase()->getFullTableName('site_content'), "id IN(".implode(", ", $children).")"); |
|
| 55 | 55 | } |
| 56 | 56 | //'undelete' the document. |
| 57 | 57 | $modx->getDatabase()->update( |
| 58 | - array( |
|
| 59 | - 'deleted' => 0, |
|
| 60 | - 'deletedby' => 0, |
|
| 61 | - 'deletedon' => 0, |
|
| 62 | - ), $modx->getDatabase()->getFullTableName('site_content'), "id='{$id}'"); |
|
| 58 | + array( |
|
| 59 | + 'deleted' => 0, |
|
| 60 | + 'deletedby' => 0, |
|
| 61 | + 'deletedon' => 0, |
|
| 62 | + ), $modx->getDatabase()->getFullTableName('site_content'), "id='{$id}'"); |
|
| 63 | 63 | |
| 64 | 64 | $modx->invokeEvent("OnDocFormUnDelete", |
| 65 | 65 | array( |
@@ -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('edit_web_user')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | // initialize page view state - the $_PAGE object |
@@ -11,12 +11,12 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | // get and save search string |
| 13 | 13 | if($_REQUEST['op'] == 'reset') { |
| 14 | - $query = ''; |
|
| 15 | - $_PAGE['vs']['search'] = ''; |
|
| 14 | + $query = ''; |
|
| 15 | + $_PAGE['vs']['search'] = ''; |
|
| 16 | 16 | } else { |
| 17 | - $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | - $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 19 | - $_PAGE['vs']['search'] = $query; |
|
| 17 | + $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | + $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 19 | + $_PAGE['vs']['search'] = $query; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | // get & save listmode |
@@ -119,29 +119,29 @@ discard block |
||
| 119 | 119 | <div class="row"> |
| 120 | 120 | <div class="table-responsive"> |
| 121 | 121 | <?php |
| 122 | - $ds = $modx->getDatabase()->select("wu.id, wu.username, wua.fullname, wua.email, wua.lastlogin, wua.logincount, IF(wua.blocked,'{$_lang['yes']}','-') as 'blocked'", $modx->getDatabase()->getFullTableName("web_users") . " wu |
|
| 122 | + $ds = $modx->getDatabase()->select("wu.id, wu.username, wua.fullname, wua.email, wua.lastlogin, wua.logincount, IF(wua.blocked,'{$_lang['yes']}','-') as 'blocked'", $modx->getDatabase()->getFullTableName("web_users") . " wu |
|
| 123 | 123 | INNER JOIN " . $modx->getDatabase()->getFullTableName("web_user_attributes") . " wua ON wua.internalKey=wu.id", ($sqlQuery ? "(wu.username LIKE '{$sqlQuery}%') OR (wua.fullname LIKE '%{$sqlQuery}%') OR (wua.email LIKE '%{$sqlQuery}%')" : ""), 'username'); |
| 124 | - $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items |
|
| 125 | - $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 126 | - $grd->cssClass = "table data"; |
|
| 127 | - $grd->columnHeaderClass = "tableHeader"; |
|
| 128 | - $grd->itemClass = "tableItem"; |
|
| 129 | - $grd->altItemClass = "tableAltItem"; |
|
| 130 | - $grd->fields = "id,username,fullname,email,lastlogin,logincount,blocked"; |
|
| 131 | - $grd->columns = $_lang["icon"] . " ," . $_lang["name"] . " ," . $_lang["user_full_name"] . " ," . $_lang["email"] . " ," . $_lang["user_prevlogin"] . " ," . $_lang["user_logincount"] . " ," . $_lang["user_block"]; |
|
| 132 | - $grd->colWidths = "1%,,,,1%,1%,1%"; |
|
| 133 | - $grd->colAligns = "center,,,,right' nowrap='nowrap,right,center"; |
|
| 134 | - $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang["click_to_context"] . "'><i class='" . $_style["icons_user"] . "'></i></a>||template:<a href='index.php?a=88&id=[+id+]' title='" . $_lang["click_to_edit_title"] . "'>[+value+]</a>||template:[+fullname+]||template:[+email+]||date: " . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . |
|
| 135 | - " %H:%M"; |
|
| 136 | - if($listmode == '1') { |
|
| 137 | - $grd->pageSize = 0; |
|
| 138 | - } |
|
| 139 | - if($_REQUEST['op'] == 'reset') { |
|
| 140 | - $grd->pageNumber = 1; |
|
| 141 | - } |
|
| 142 | - // render grid |
|
| 143 | - echo $grd->render(); |
|
| 144 | - ?> |
|
| 124 | + $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $number_of_results); // set page size to 0 t show all items |
|
| 125 | + $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 126 | + $grd->cssClass = "table data"; |
|
| 127 | + $grd->columnHeaderClass = "tableHeader"; |
|
| 128 | + $grd->itemClass = "tableItem"; |
|
| 129 | + $grd->altItemClass = "tableAltItem"; |
|
| 130 | + $grd->fields = "id,username,fullname,email,lastlogin,logincount,blocked"; |
|
| 131 | + $grd->columns = $_lang["icon"] . " ," . $_lang["name"] . " ," . $_lang["user_full_name"] . " ," . $_lang["email"] . " ," . $_lang["user_prevlogin"] . " ," . $_lang["user_logincount"] . " ," . $_lang["user_block"]; |
|
| 132 | + $grd->colWidths = "1%,,,,1%,1%,1%"; |
|
| 133 | + $grd->colAligns = "center,,,,right' nowrap='nowrap,right,center"; |
|
| 134 | + $grd->colTypes = "template:<a class='gridRowIcon' href='javascript:;' onclick='return showContentMenu([+id+],event);' title='" . $_lang["click_to_context"] . "'><i class='" . $_style["icons_user"] . "'></i></a>||template:<a href='index.php?a=88&id=[+id+]' title='" . $_lang["click_to_edit_title"] . "'>[+value+]</a>||template:[+fullname+]||template:[+email+]||date: " . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . |
|
| 135 | + " %H:%M"; |
|
| 136 | + if($listmode == '1') { |
|
| 137 | + $grd->pageSize = 0; |
|
| 138 | + } |
|
| 139 | + if($_REQUEST['op'] == 'reset') { |
|
| 140 | + $grd->pageNumber = 1; |
|
| 141 | + } |
|
| 142 | + // render grid |
|
| 143 | + echo $grd->render(); |
|
| 144 | + ?> |
|
| 145 | 145 | </div> |
| 146 | 146 | </div> |
| 147 | 147 | </div> |
@@ -113,31 +113,31 @@ |
||
| 113 | 113 | // Handle Input "Search in main fields" |
| 114 | 114 | if ($searchfields != '') { |
| 115 | 115 | |
| 116 | - /*start search by TV. Added Rising13*/ |
|
| 117 | - $tbl_site_tmplvar_contentvalues = $modx->getDatabase()->getFullTableName('site_tmplvar_contentvalues'); |
|
| 118 | - $articul_query = "SELECT `contentid` FROM {$tbl_site_tmplvar_contentvalues} WHERE `value` LIKE '%{$searchfields}%'"; |
|
| 119 | - $articul_result = $modx->getDatabase()->query($articul_query); |
|
| 120 | - $articul_id_array = $modx->getDatabase()->makeArray($articul_result); |
|
| 121 | - if(count($articul_id_array)>0){ |
|
| 122 | - $articul_id = ''; |
|
| 123 | - $i = 1; |
|
| 124 | - foreach( $articul_id_array as $articul ) { |
|
| 125 | - $articul_id.=$articul['contentid']; |
|
| 126 | - if($i !== count($articul_id_array)){ |
|
| 127 | - $articul_id.=','; |
|
| 128 | - } |
|
| 129 | - $i++; |
|
| 130 | - } |
|
| 131 | - $articul_id_query = " OR sc.id IN ({$articul_id})"; |
|
| 132 | - }else{ |
|
| 133 | - $articul_id_query = ''; |
|
| 134 | - } |
|
| 135 | - /*end search by TV*/ |
|
| 116 | + /*start search by TV. Added Rising13*/ |
|
| 117 | + $tbl_site_tmplvar_contentvalues = $modx->getDatabase()->getFullTableName('site_tmplvar_contentvalues'); |
|
| 118 | + $articul_query = "SELECT `contentid` FROM {$tbl_site_tmplvar_contentvalues} WHERE `value` LIKE '%{$searchfields}%'"; |
|
| 119 | + $articul_result = $modx->getDatabase()->query($articul_query); |
|
| 120 | + $articul_id_array = $modx->getDatabase()->makeArray($articul_result); |
|
| 121 | + if(count($articul_id_array)>0){ |
|
| 122 | + $articul_id = ''; |
|
| 123 | + $i = 1; |
|
| 124 | + foreach( $articul_id_array as $articul ) { |
|
| 125 | + $articul_id.=$articul['contentid']; |
|
| 126 | + if($i !== count($articul_id_array)){ |
|
| 127 | + $articul_id.=','; |
|
| 128 | + } |
|
| 129 | + $i++; |
|
| 130 | + } |
|
| 131 | + $articul_id_query = " OR sc.id IN ({$articul_id})"; |
|
| 132 | + }else{ |
|
| 133 | + $articul_id_query = ''; |
|
| 134 | + } |
|
| 135 | + /*end search by TV*/ |
|
| 136 | 136 | |
| 137 | 137 | if (ctype_digit($searchfields)) { |
| 138 | 138 | $sqladd .= "sc.id='{$searchfields}'"; |
| 139 | 139 | if (strlen($searchfields) > 3) { |
| 140 | - $sqladd .= $articul_id_query;//search by TV |
|
| 140 | + $sqladd .= $articul_id_query;//search by TV |
|
| 141 | 141 | $sqladd .= " OR sc.pagetitle LIKE '%{$searchfields}%'"; |
| 142 | 142 | } |
| 143 | 143 | } |
@@ -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('edit_user')) { |
| 6 | - $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 6 | + $modx->webAlertAndQuit($_lang["error_no_privileges"]); |
|
| 7 | 7 | } |
| 8 | 8 | |
| 9 | 9 | // initialize page view state - the $_PAGE object |
@@ -11,12 +11,12 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | // get and save search string |
| 13 | 13 | if($_REQUEST['op'] == 'reset') { |
| 14 | - $query = ''; |
|
| 15 | - $_PAGE['vs']['search'] = ''; |
|
| 14 | + $query = ''; |
|
| 15 | + $_PAGE['vs']['search'] = ''; |
|
| 16 | 16 | } else { |
| 17 | - $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | - $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 19 | - $_PAGE['vs']['search'] = $query; |
|
| 17 | + $query = isset($_REQUEST['search']) ? $_REQUEST['search'] : $_PAGE['vs']['search']; |
|
| 18 | + $sqlQuery = $modx->getDatabase()->escape($query); |
|
| 19 | + $_PAGE['vs']['search'] = $query; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | // get & save listmode |
@@ -119,54 +119,54 @@ discard block |
||
| 119 | 119 | <div class="row"> |
| 120 | 120 | <div class="table-responsive"> |
| 121 | 121 | <?php |
| 122 | - $where = ""; |
|
| 123 | - if(!$modx->hasPermission('save_role')) { |
|
| 124 | - $where .= (empty($where) ? "" : " AND ") . "mua.role != 1"; |
|
| 125 | - } |
|
| 126 | - if(!empty($sqlQuery)) { |
|
| 127 | - $where .= (empty($where) ? "" : " AND ") . "((mu.username LIKE '{$sqlQuery}%') OR (mua.fullname LIKE '%{$sqlQuery}%') OR (mua.email LIKE '{$sqlQuery}%'))"; |
|
| 128 | - } |
|
| 129 | - $ds = $modx->getDatabase()->select("mu.id, mu.username, rname.name AS role, mua.fullname, mua.email, IF(mua.blocked,'{$_lang['yes']}','-') as blocked, mua.thislogin, mua.logincount", $modx->getDatabase()->getFullTableName('manager_users') . " AS mu |
|
| 122 | + $where = ""; |
|
| 123 | + if(!$modx->hasPermission('save_role')) { |
|
| 124 | + $where .= (empty($where) ? "" : " AND ") . "mua.role != 1"; |
|
| 125 | + } |
|
| 126 | + if(!empty($sqlQuery)) { |
|
| 127 | + $where .= (empty($where) ? "" : " AND ") . "((mu.username LIKE '{$sqlQuery}%') OR (mua.fullname LIKE '%{$sqlQuery}%') OR (mua.email LIKE '{$sqlQuery}%'))"; |
|
| 128 | + } |
|
| 129 | + $ds = $modx->getDatabase()->select("mu.id, mu.username, rname.name AS role, mua.fullname, mua.email, IF(mua.blocked,'{$_lang['yes']}','-') as blocked, mua.thislogin, mua.logincount", $modx->getDatabase()->getFullTableName('manager_users') . " AS mu |
|
| 130 | 130 | INNER JOIN " . $modx->getDatabase()->getFullTableName('user_attributes') . " AS mua ON mua.internalKey=mu.id |
| 131 | 131 | LEFT JOIN " . $modx->getDatabase()->getFullTableName('user_roles') . " AS rname ON mua.role=rname.id", $where, 'mua.blocked ASC, mua.thislogin DESC'); |
| 132 | - $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $modx->config['number_of_results']); // set page size to 0 t show all items |
|
| 133 | - $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 134 | - $grd->cssClass = "table data"; |
|
| 135 | - $grd->columnHeaderClass = "tableHeader"; |
|
| 136 | - $grd->itemClass = "tableItem"; |
|
| 137 | - $grd->altItemClass = "tableAltItem"; |
|
| 138 | - $grd->fields = "id,username,fullname,role,email,thislogin,logincount,blocked"; |
|
| 139 | - $grd->columns = implode(',', array( |
|
| 140 | - $_lang["icon"], |
|
| 141 | - $_lang["name"], |
|
| 142 | - $_lang["user_full_name"], |
|
| 143 | - $_lang['role'], |
|
| 144 | - $_lang["email"], |
|
| 145 | - $_lang["user_prevlogin"], |
|
| 146 | - $_lang["user_logincount"], |
|
| 147 | - $_lang["user_block"] |
|
| 148 | - )); |
|
| 149 | - $grd->colWidths = "1%,,,,,1%,1%,1%"; |
|
| 150 | - $grd->colAligns = "center,,,,,right' nowrap='nowrap,right,center"; |
|
| 151 | - $grd->colTypes = implode('||', array( |
|
| 152 | - 'template:<a class="gridRowIcon" href="javascript:;" onclick="return showContentMenu([+id+],event);" title="' . $_lang['click_to_context'] . '"><i class="' . $_style['icons_user'] . '"></i></a>', |
|
| 153 | - 'template:<a href="index.php?a=12&id=[+id+]" title="' . $_lang['click_to_edit_title'] . '">[+value+]</a>', |
|
| 154 | - 'template:[+fullname+]', |
|
| 155 | - 'template:[+role+]', |
|
| 156 | - 'template:[+email+]', |
|
| 157 | - 'date: ' . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . ' %H:%M', |
|
| 158 | - 'template:[+logincount+]', |
|
| 159 | - 'template:[+blocked+]' |
|
| 160 | - )); |
|
| 161 | - if($listmode == '1') { |
|
| 162 | - $grd->pageSize = 0; |
|
| 163 | - } |
|
| 164 | - if($_REQUEST['op'] == 'reset') { |
|
| 165 | - $grd->pageNumber = 1; |
|
| 166 | - } |
|
| 167 | - // render grid |
|
| 168 | - echo $grd->render(); |
|
| 169 | - ?> |
|
| 132 | + $grd = new \EvolutionCMS\Support\DataGrid('', $ds, $modx->config['number_of_results']); // set page size to 0 t show all items |
|
| 133 | + $grd->noRecordMsg = $_lang["no_records_found"]; |
|
| 134 | + $grd->cssClass = "table data"; |
|
| 135 | + $grd->columnHeaderClass = "tableHeader"; |
|
| 136 | + $grd->itemClass = "tableItem"; |
|
| 137 | + $grd->altItemClass = "tableAltItem"; |
|
| 138 | + $grd->fields = "id,username,fullname,role,email,thislogin,logincount,blocked"; |
|
| 139 | + $grd->columns = implode(',', array( |
|
| 140 | + $_lang["icon"], |
|
| 141 | + $_lang["name"], |
|
| 142 | + $_lang["user_full_name"], |
|
| 143 | + $_lang['role'], |
|
| 144 | + $_lang["email"], |
|
| 145 | + $_lang["user_prevlogin"], |
|
| 146 | + $_lang["user_logincount"], |
|
| 147 | + $_lang["user_block"] |
|
| 148 | + )); |
|
| 149 | + $grd->colWidths = "1%,,,,,1%,1%,1%"; |
|
| 150 | + $grd->colAligns = "center,,,,,right' nowrap='nowrap,right,center"; |
|
| 151 | + $grd->colTypes = implode('||', array( |
|
| 152 | + 'template:<a class="gridRowIcon" href="javascript:;" onclick="return showContentMenu([+id+],event);" title="' . $_lang['click_to_context'] . '"><i class="' . $_style['icons_user'] . '"></i></a>', |
|
| 153 | + 'template:<a href="index.php?a=12&id=[+id+]" title="' . $_lang['click_to_edit_title'] . '">[+value+]</a>', |
|
| 154 | + 'template:[+fullname+]', |
|
| 155 | + 'template:[+role+]', |
|
| 156 | + 'template:[+email+]', |
|
| 157 | + 'date: ' . $modx->toDateFormat('[+thislogin+]', 'formatOnly') . ' %H:%M', |
|
| 158 | + 'template:[+logincount+]', |
|
| 159 | + 'template:[+blocked+]' |
|
| 160 | + )); |
|
| 161 | + if($listmode == '1') { |
|
| 162 | + $grd->pageSize = 0; |
|
| 163 | + } |
|
| 164 | + if($_REQUEST['op'] == 'reset') { |
|
| 165 | + $grd->pageNumber = 1; |
|
| 166 | + } |
|
| 167 | + // render grid |
|
| 168 | + echo $grd->render(); |
|
| 169 | + ?> |
|
| 170 | 170 | </div> |
| 171 | 171 | </div> |
| 172 | 172 | </div> |