[phpwebapp-commits] CVS: top10/templates/admin/users users.php,1.1.2.8,1.1.2.9 users.db,1.1.2.6,1.1.2.7

[Dashamir H. <das...@us...>]

Update of /cvsroot/phpwebapp/top10/templates/admin/users
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5895/templates/admin/users

Modified Files:
      Tag: maisp
	users.php users.db 
Log Message:


Index: users.php
===================================================================
RCS file: /cvsroot/phpwebapp/top10/templates/admin/users/Attic/users.php,v
retrieving revision 1.1.2.8
retrieving revision 1.1.2.9
diff -C2 -d -r1.1.2.8 -r1.1.2.9
*** users.php	2 Feb 2004 13:54:58 -0000	1.1.2.8
--- users.php	26 Jul 2004 10:06:07 -0000	1.1.2.9
***************
*** 82,85 ****
--- 82,113 ----
        WebApp::message($msg);
      }
+ 
+   function onRender()
+     {
+       WebApp::addVar('user_filter', $this->get_user_filter());
+     }
+ 
+   /**
+    * Construct an SQL filter (condition) 
+    * based on the variables of the user_filter.
+    */
+   function get_user_filter()
+     {
+       //get state vars of user_filter
+       $username = WebApp::getSVar('user_filter->username');
+       $realname = WebApp::getSVar('user_filter->realname');
+       $email    = WebApp::getSVar('user_filter->email');
+       $status   = WebApp::getSVar('user_filter->status');
+ 
+       $arr_conditions = array();
+       if ($username<>'')  $arr_conditions[] = "username LIKE '%$username%'"; 
+       if ($realname<>'')  $arr_conditions[] = "realname LIKE '%$realname%'"; 
+       if ($email<>'')     $arr_conditions[] = "email LIKE '%$email%'"; 
+       if ($status<>'')    $arr_conditions[] = "status LIKE '%$status%'";
+       $user_filter = implode(' AND ', $arr_conditions);
+       if ($user_filter=='')  $user_filter = '1=1';
+ 
+       return $user_filter;
+     }
  }
  ?>
\ No newline at end of file

Index: users.db
===================================================================
RCS file: /cvsroot/phpwebapp/top10/templates/admin/users/Attic/users.db,v
retrieving revision 1.1.2.6
retrieving revision 1.1.2.7
diff -C2 -d -r1.1.2.6 -r1.1.2.7
*** users.db	7 Feb 2004 14:23:59 -0000	1.1.2.6
--- users.db	26 Jul 2004 10:06:07 -0000	1.1.2.7
***************
*** 3,8 ****
  <Recordset ID="users_rs" type="PagedRS" recs_per_page="10">
    <Query>
!     SELECT * FROM users
!     WHERE {{user_filter->condition}}
    </Query>
  </Recordset>
--- 3,7 ----
  <Recordset ID="users_rs" type="PagedRS" recs_per_page="10">
    <Query>
!     SELECT * FROM users WHERE ({{user_filter}})
    </Query>
  </Recordset>