diff options
Diffstat (limited to 'admin/user_list_backend.php')
| -rw-r--r-- | admin/user_list_backend.php | 158 |
1 files changed, 158 insertions, 0 deletions
diff --git a/admin/user_list_backend.php b/admin/user_list_backend.php new file mode 100644 index 000000000..8b9734b07 --- /dev/null +++ b/admin/user_list_backend.php @@ -0,0 +1,158 @@ +<?php +define('PHPWG_ROOT_PATH','../'); +define('IN_ADMIN', true); + +include_once(PHPWG_ROOT_PATH.'include/common.inc.php'); + +/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + * Easy set variables + */ + +/* Array of database columns which should be read and sent back to DataTables. Use a space where + * you want to insert a non-database field (for example a counter or static image) + */ +$aColumns = array('id', 'username', 'status', 'mail_address'); + +/* Indexed column (used for fast and accurate table cardinality) */ +$sIndexColumn = "id"; + +/* DB table to use */ +$sTable = USERS_TABLE.' INNER JOIN '.USER_INFOS_TABLE.' AS ui ON id = ui.user_id'; + +/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + * If you just want to use the basic configuration for DataTables with PHP server-side, there is + * no need to edit below this line + */ + +/* + * Paging + */ +$sLimit = ""; +if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' ) +{ + $sLimit = "LIMIT ".pwg_db_real_escape_string( $_GET['iDisplayStart'] ).", ". + pwg_db_real_escape_string( $_GET['iDisplayLength'] ); +} + + +/* + * Ordering + */ +if ( isset( $_GET['iSortCol_0'] ) ) +{ + $sOrder = "ORDER BY "; + for ( $i=0 ; $i<intval( $_GET['iSortingCols'] ) ; $i++ ) + { + if ( $_GET[ 'bSortable_'.intval($_GET['iSortCol_'.$i]) ] == "true" ) + { + $sOrder .= $aColumns[ intval( $_GET['iSortCol_'.$i] ) ]." + ".pwg_db_real_escape_string( $_GET['sSortDir_'.$i] ) .", "; + } + } + + $sOrder = substr_replace( $sOrder, "", -2 ); + if ( $sOrder == "ORDER BY" ) + { + $sOrder = ""; + } +} + + +/* + * Filtering + * NOTE this does not match the built-in DataTables filtering which does it + * word by word on any field. It's possible to do here, but concerned about efficiency + * on very large tables, and MySQL's regex functionality is very limited + */ +$sWhere = ""; +if ( $_GET['sSearch'] != "" ) +{ + $sWhere = "WHERE ("; + for ( $i=0 ; $i<count($aColumns) ; $i++ ) + { + $sWhere .= $aColumns[$i]." LIKE '%".pwg_db_real_escape_string( $_GET['sSearch'] )."%' OR "; + } + $sWhere = substr_replace( $sWhere, "", -3 ); + $sWhere .= ')'; +} + +/* Individual column filtering */ +for ( $i=0 ; $i<count($aColumns) ; $i++ ) +{ + if ( $_GET['bSearchable_'.$i] == "true" && $_GET['sSearch_'.$i] != '' ) + { + if ( $sWhere == "" ) + { + $sWhere = "WHERE "; + } + else + { + $sWhere .= " AND "; + } + $sWhere .= $aColumns[$i]." LIKE '%".pwg_db_real_escape_string($_GET['sSearch_'.$i])."%' "; + } +} + + +/* + * SQL queries + * Get data to display + */ +$sQuery = " + SELECT SQL_CALC_FOUND_ROWS ".str_replace(" , ", " ", implode(", ", $aColumns))." + FROM $sTable + $sWhere + $sOrder + $sLimit + "; +$rResult = pwg_query($sQuery); + +/* Data set length after filtering */ +$sQuery = " + SELECT FOUND_ROWS() + "; +$rResultFilterTotal = pwg_query($sQuery); +$aResultFilterTotal = pwg_db_fetch_array($rResultFilterTotal); +$iFilteredTotal = $aResultFilterTotal[0]; + +/* Total data set length */ +$sQuery = " + SELECT COUNT(".$sIndexColumn.") + FROM $sTable + "; +$rResultTotal = pwg_query($sQuery); +$aResultTotal = pwg_db_fetch_array($rResultTotal); +$iTotal = $aResultTotal[0]; + + +/* + * Output + */ +$output = array( + "sEcho" => intval($_GET['sEcho']), + "iTotalRecords" => $iTotal, + "iTotalDisplayRecords" => $iFilteredTotal, + "aaData" => array() + ); + +while ( $aRow = pwg_db_fetch_array( $rResult ) ) +{ + $row = array(); + for ( $i=0 ; $i<count($aColumns) ; $i++ ) + { + if ( $aColumns[$i] == "version" ) + { + /* Special output formatting for 'version' column */ + $row[] = ($aRow[ $aColumns[$i] ]=="0") ? '-' : $aRow[ $aColumns[$i] ]; + } + else if ( $aColumns[$i] != ' ' ) + { + /* General output */ + $row[] = $aRow[ $aColumns[$i] ]; + } + } + $output['aaData'][] = $row; +} + +echo json_encode( $output ); +?>
\ No newline at end of file |