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>
|
