@@ -33,15 +33,19 class UsersController < ApplicationController | |||||
33 | sort_update |
|
33 | sort_update | |
34 |
|
34 | |||
35 | @status = params[:status] ? params[:status].to_i : 1 |
|
35 | @status = params[:status] ? params[:status].to_i : 1 | |
36 | conditions = "status <> 0" |
|
36 | c = ARCondition.new(@status == 0 ? "status <> 0" : ["status = ?", @status]) | |
37 | conditions = ["status=?", @status] unless @status == 0 |
|
37 | ||
|
38 | unless params[:name].blank? | |||
|
39 | name = "%#{params[:name].strip.downcase}%" | |||
|
40 | c << ["LOWER(login) LIKE ? OR LOWER(firstname) LIKE ? OR LOWER(lastname) LIKE ?", name, name, name] | |||
|
41 | end | |||
38 |
|
42 | |||
39 | @user_count = User.count(:conditions => conditions) |
|
43 | @user_count = User.count(:conditions => c.conditions) | |
40 | @user_pages = Paginator.new self, @user_count, |
|
44 | @user_pages = Paginator.new self, @user_count, | |
41 | per_page_option, |
|
45 | per_page_option, | |
42 | params['page'] |
|
46 | params['page'] | |
43 | @users = User.find :all,:order => sort_clause, |
|
47 | @users = User.find :all,:order => sort_clause, | |
44 | :conditions => conditions, |
|
48 | :conditions => c.conditions, | |
45 | :limit => @user_pages.items_per_page, |
|
49 | :limit => @user_pages.items_per_page, | |
46 | :offset => @user_pages.current.offset |
|
50 | :offset => @user_pages.current.offset | |
47 |
|
51 |
@@ -6,8 +6,11 | |||||
6 |
|
6 | |||
7 | <% form_tag({}, :method => :get) do %> |
|
7 | <% form_tag({}, :method => :get) do %> | |
8 | <fieldset><legend><%= l(:label_filter_plural) %></legend> |
|
8 | <fieldset><legend><%= l(:label_filter_plural) %></legend> | |
9 |
<label><%= l(:field_status) %> |
|
9 | <label><%= l(:field_status) %>:</label> | |
10 | <%= select_tag 'status', users_status_options_for_select(@status), :class => "small", :onchange => "this.form.submit(); return false;" %> |
|
10 | <%= select_tag 'status', users_status_options_for_select(@status), :class => "small", :onchange => "this.form.submit(); return false;" %> | |
|
11 | <label><%= l(:label_user) %>:</label> | |||
|
12 | <%= text_field_tag 'name', params[:name], :size => 30 %> | |||
|
13 | <%= submit_tag l(:button_apply), :class => "small", :name => nil %> | |||
11 | </fieldset> |
|
14 | </fieldset> | |
12 | <% end %> |
|
15 | <% end %> | |
13 | |
|
16 | |
General Comments 0
You need to be logged in to leave comments.
Login now