feature 1668, in progress: redesign user manager (jQuery datatables, AJAX calls)

git-svn-id: http://piwigo.org/svn/trunk@25194 68402e56-0260-453c-a942-63ccdbb3a9ee

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