jro_apps/redmine Commit - r6225:a51829eb2236

15

#

15

#

16

# helper :sort

16

# helper :sort

17

# include SortHelper

17

# include SortHelper

18

#

18

#

19

# def list

19

# def list

20

# sort_init 'last_name'

20

# sort_init 'last_name'

21

# sort_update %w(first_name last_name)

21

# sort_update %w(first_name last_name)

22

# @items = Contact.find_all nil, sort_clause

22

# @items = Contact.find_all nil, sort_clause

23

# end

23

# end

24

#

24

#

25

# Controller (using Pagination module):

25

# Controller (using Pagination module):

26

#

26

#

27

# helper :sort

27

# helper :sort

28

# include SortHelper

28

# include SortHelper

29

#

29

#

30

# def list

30

# def list

31

# sort_init 'last_name'

31

# sort_init 'last_name'

32

# sort_update %w(first_name last_name)

32

# sort_update %w(first_name last_name)

34

# :order_by => sort_clause,

34

# :order_by => sort_clause,

35

# :per_page => 10

35

# :per_page => 10

36

# end

36

# end

37

#

37

#

38

# View (table header in list.rhtml):

38

# View (table header in list.rhtml):

39

#

39

#

40

# <thead>

40

# <thead>

41

# <tr>

41

# <tr>

42

# <%= sort_header_tag('id', :title => 'Sort by contact ID') %>

42

# <%= sort_header_tag('id', :title => 'Sort by contact ID') %>

52

53

module SortHelper

53

module SortHelper

54

class SortCriteria

54

class SortCriteria

55

56

def initialize

56

def initialize

57

@criteria = []

57

@criteria = []

58

end

58

end

59

60

def available_criteria=(criteria)

60

def available_criteria=(criteria)

61

unless criteria.is_a?(Hash)

61

unless criteria.is_a?(Hash)

62

criteria = criteria.inject({}) {|h,k| h[k] = k; h}

62

criteria = criteria.inject({}) {|h,k| h[k] = k; h}

63

end

63

end

64

@available_criteria = criteria

64

@available_criteria = criteria

65

end

65

end

66

67

def from_param(param)

67

def from_param(param)

68

@criteria = param.to_s.split(',').collect {|s| s.split(':')[0..1]}

68

@criteria = param.to_s.split(',').collect {|s| s.split(':')[0..1]}

69

normalize!

69

normalize!

70

end

70

end

71

72

def criteria=(arg)

72

def criteria=(arg)

73

@criteria = arg

73

@criteria = arg

74

normalize!

74

normalize!

75

end

75

end

76

77

def to_param

77

def to_param

78

@criteria.collect {|k,o| k + (o ? '' : ':desc')}.join(',')

78

@criteria.collect {|k,o| k + (o ? '' : ':desc')}.join(',')

79

end

79

end

80

81

def to_sql

81

def to_sql

82

sql = @criteria.collect do |k,o|

82

sql = @criteria.collect do |k,o|

83

if s = @available_criteria[k]

83

if s = @available_criteria[k]

86

end.compact.join(', ')

86

end.compact.join(', ')

87

sql.blank? ? nil : sql

87

sql.blank? ? nil : sql

88

end

88

end

89

90

def add!(key, asc)

90

def add!(key, asc)

91

@criteria.delete_if {|k,o| k == key}

91

@criteria.delete_if {|k,o| k == key}

92

@criteria = [[key, asc]] + @criteria

92

@criteria = [[key, asc]] + @criteria

93

normalize!

93

normalize!

94

end

94

end

95

96

def add(*args)

96

def add(*args)

97

r = self.class.new.from_param(to_param)

97

r = self.class.new.from_param(to_param)

98

r.add!(*args)

98

r.add!(*args)

99

r

99

r

100

end

100

end

101

102

def first_key

102

def first_key

103

@criteria.first && @criteria.first.first

103

@criteria.first && @criteria.first.first

104

end

104

end

105

106

def first_asc?

106

def first_asc?

107

@criteria.first && @criteria.first.last

107

@criteria.first && @criteria.first.last

108

end

108

end

109

110

def empty?

110

def empty?

111

@criteria.empty?

111

@criteria.empty?

112

end

112

end

113

114

private

114

private

115

116

def normalize!

116

def normalize!

117

@criteria ||= []

117

@criteria ||= []

118

@criteria = @criteria.collect {|s| s = s.to_a; [s.first, (s.last == false || s.last == 'desc') ? false : true]}

118

@criteria = @criteria.collect {|s| s = s.to_a; [s.first, (s.last == false || s.last == 'desc') ? false : true]}

120

@criteria.slice!(3)

120

@criteria.slice!(3)

121

self

121

self

122

end

122

end

123

124

# Appends DESC to the sort criterion unless it has a fixed order

124

# Appends DESC to the sort criterion unless it has a fixed order

125

def append_desc(criterion)

125

def append_desc(criterion)

126

if criterion =~ / (asc|desc)$/i

126

if criterion =~ / (asc|desc)$/i

130

end

130

end

131

end

131

end

132

end

132

end

133

134

def sort_name

134

def sort_name

135

controller_name + '_' + action_name + '_sort'

135

controller_name + '_' + action_name + '_sort'

136

end

136

end

137

138

# Initializes the default sort.

138

# Initializes the default sort.

139

# Examples:

139

# Examples:

140

#

140

#

141

# sort_init 'name'

141

# sort_init 'name'

142

# sort_init 'id', 'desc'

142

# sort_init 'id', 'desc'

143

# sort_init ['name', ['id', 'desc']]

143

# sort_init ['name', ['id', 'desc']]

165

@sort_criteria.criteria = @sort_default if @sort_criteria.empty?

165

@sort_criteria.criteria = @sort_default if @sort_criteria.empty?

166

session[sort_name] = @sort_criteria.to_param

166

session[sort_name] = @sort_criteria.to_param

167

end

167

end

168

169

# Clears the sort criteria session data

169

# Clears the sort criteria session data

170

#

170

#

171

def sort_clear

171

def sort_clear

187

#

187

#

188

def sort_link(column, caption, default_order)

188

def sort_link(column, caption, default_order)

189

css, order = nil, default_order

189

css, order = nil, default_order

190

191

if column.to_s == @sort_criteria.first_key

191

if column.to_s == @sort_criteria.first_key

192

if @sort_criteria.first_asc?

192

if @sort_criteria.first_asc?

193

css = 'sort asc'

193

css = 'sort asc'

198

end

198

end

199

end

199

end

200

caption = column.to_s.humanize unless caption

200

caption = column.to_s.humanize unless caption

201

202

sort_options = { :sort => @sort_criteria.add(column.to_s, order).to_param }

202

sort_options = { :sort => @sort_criteria.add(column.to_s, order).to_param }

203

url_options = params.merge(sort_options)

203

url_options = params.merge(sort_options)

204

205

# Add project_id to url_options

205

# Add project_id to url_options

206

url_options = url_options.merge(:project_id => params[:project_id]) if params.has_key?(:project_id)

206

url_options = url_options.merge(:project_id => params[:project_id]) if params.has_key?(:project_id)

207

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             #
             #   helper :sort
             #   include SortHelper
+            #
             #   def list
             #     sort_init 'last_name'
             #     sort_update %w(first_name last_name)
             #     @items = Contact.find_all nil, sort_clause
             #   end
+            #
             # Controller (using Pagination module):
             #
             #   helper :sort
             #   include SortHelper
+            #
             #   def list
             #     sort_init 'last_name'
             #     sort_update %w(first_name last_name)
             #       :order_by => sort_clause,
             #       :per_page => 10
             #   end
+            #
             # View (table header in list.rhtml):
+            #
             #   <thead>
             #     <tr>
             #       <%= sort_header_tag('id', :title => 'Sort by contact ID') %>
             module SortHelper
               class SortCriteria
                 def initialize
                   @criteria = []
                 end
                 def available_criteria=(criteria)
                   unless criteria.is_a?(Hash)
                     criteria = criteria.inject({}) {|h,k| h[k] = k; h}
                   end
                   @available_criteria = criteria
                 end
                 def from_param(param)
                   @criteria = param.to_s.split(',').collect {|s| s.split(':')[0..1]}
                   normalize!
                 end
                 def criteria=(arg)
                   @criteria = arg
                   normalize!
                 end
                 def to_param
                   @criteria.collect {|k,o| k + (o ? '' : ':desc')}.join(',')
                 end
                 def to_sql
                   sql = @criteria.collect do |k,o|
                     if s = @available_criteria[k]
                   end.compact.join(', ')
                   sql.blank? ? nil : sql
                 end
                 def add!(key, asc)
                   @criteria.delete_if {|k,o| k == key}
                   @criteria = [[key, asc]] + @criteria
                   normalize!
                 end
                 def add(*args)
                   r = self.class.new.from_param(to_param)
                   r.add!(*args)
                   r
                 end
                 def first_key
                   @criteria.first && @criteria.first.first
                 end
                 def first_asc?
                   @criteria.first && @criteria.first.last
                 end
                 def empty?
                   @criteria.empty?
                 end
                 private
                 def normalize!
                   @criteria ||= []
                   @criteria = @criteria.collect {|s| s = s.to_a; [s.first, (s.last == false || s.last == 'desc') ? false : true]}
                   @criteria.slice!(3)
                   self
                 end
                 # Appends DESC to the sort criterion unless it has a fixed order
                 def append_desc(criterion)
                   if criterion =~ / (asc|desc)$/i
                   end
                 end
               end
               def sort_name
                 controller_name + '_' + action_name + '_sort'
               end
               # Initializes the default sort.
               # Examples:
+              #
               #   sort_init 'name'
               #   sort_init 'id', 'desc'
               #   sort_init ['name', ['id', 'desc']]
                 @sort_criteria.criteria = @sort_default if @sort_criteria.empty?
                 session[sort_name] = @sort_criteria.to_param
               end
               # Clears the sort criteria session data
               #
               def sort_clear
               #
               def sort_link(column, caption, default_order)
                 css, order = nil, default_order
                 if column.to_s == @sort_criteria.first_key
                   if @sort_criteria.first_asc?
                     css = 'sort asc'
                   end
                 end
                 caption = column.to_s.humanize unless caption
                 sort_options = { :sort => @sort_criteria.add(column.to_s, order).to_param }
                 url_options = params.merge(sort_options)
                  # Add project_id to url_options
                 url_options = url_options.merge(:project_id => params[:project_id]) if params.has_key?(:project_id)