aboutsummaryrefslogtreecommitdiffstats
path: root/admin/user_list_backend.php
diff options
context:
space:
mode:
Diffstat (limited to 'admin/user_list_backend.php')
-rw-r--r--admin/user_list_backend.php158
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