jro_apps/redmine Files · app/helpers/attachments_helper.rb

Pass the order option as an array to satisfy sqlserver adapter (#12713)....

Pass the order option as an array to satisfy sqlserver adapter (#12713). Unlike other adapters, the sqlserver adapter processes the order option and wipes it when using functions. Here we can see a "ASC" inserted in the COALESCE call: irb(main):001:0> Issue.order("coalesce(estimated_hours, 0), id").to_sql => "SELECT [issues].* FROM [issues] ORDER BY coalesce(estimated_hours ASC, 0) ASC, id ASC" This does not happen when passing the order SQL fragments separately. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@11115 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r9750:a0c495b953b8


                r10885:a8083fb9a81d

Download file

             attachments_helper.rb
        
                    47 lines
            
             | 2.0 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / helpers / attachments_helper.rb
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      # encoding: utf-8

      #

      # Redmine - project management software

      # Copyright (C) 2006-2012  Jean-Philippe Lang

      #

      # This program is free software; you can redistribute it and/or

      # modify it under the terms of the GNU General Public License

      # as published by the Free Software Foundation; either version 2

      # of the License, or (at your option) any later version.

      #

      # This program is distributed in the hope that it will be useful,

      # but WITHOUT ANY WARRANTY; without even the implied warranty of

      # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

      # GNU General Public License for more details.

      #

      # You should have received a copy of the GNU General Public License

      # along with this program; if not, write to the Free Software

      # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

      module AttachmentsHelper

        # Displays view/delete links to the attachments of the given object

        # Options:

        #   :author -- author names are not displayed if set to false

        #   :thumbails -- display thumbnails if enabled in settings

        def link_to_attachments(container, options = {})

          options.assert_valid_keys(:author, :thumbnails)

          if container.attachments.any?

            options = {:deletable => container.attachments_deletable?, :author => true}.merge(options)

            render :partial => 'attachments/links',

              :locals => {:attachments => container.attachments, :options => options, :thumbnails => (options[:thumbnails] && Setting.thumbnails_enabled?)}

          end

        end

        def render_api_attachment(attachment, api)

          api.attachment do

            api.id attachment.id

            api.filename attachment.filename

            api.filesize attachment.filesize

            api.content_type attachment.content_type

            api.description attachment.description

            api.content_url url_for(:controller => 'attachments', :action => 'download', :id => attachment, :filename => attachment.filename, :only_path => false)

            api.author(:id => attachment.author.id, :name => attachment.author.name) if attachment.author

            api.created_on attachment.created_on

          end

        end

      end

	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

				# encoding: utf-8
				#
				# Redmine - project management software
				# Copyright (C) 2006-2012 Jean-Philippe Lang
				#
				# This program is free software; you can redistribute it and/or
				# modify it under the terms of the GNU General Public License
				# as published by the Free Software Foundation; either version 2
				# of the License, or (at your option) any later version.
				#
				# This program is distributed in the hope that it will be useful,
				# but WITHOUT ANY WARRANTY; without even the implied warranty of
				# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
				# GNU General Public License for more details.
				#
				# You should have received a copy of the GNU General Public License
				# along with this program; if not, write to the Free Software
				# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

				module AttachmentsHelper
				# Displays view/delete links to the attachments of the given object
				# Options:
				# :author -- author names are not displayed if set to false
				# :thumbails -- display thumbnails if enabled in settings
				def link_to_attachments(container, options = {})
				options.assert_valid_keys(:author, :thumbnails)

				if container.attachments.any?
				options = {:deletable => container.attachments_deletable?, :author => true}.merge(options)
				render :partial => 'attachments/links',
				:locals => {:attachments => container.attachments, :options => options, :thumbnails => (options[:thumbnails] && Setting.thumbnails_enabled?)}
				end
				end

				def render_api_attachment(attachment, api)
				api.attachment do
				api.id attachment.id
				api.filename attachment.filename
				api.filesize attachment.filesize
				api.content_type attachment.content_type
				api.description attachment.description
				api.content_url url_for(:controller => 'attachments', :action => 'download', :id => attachment, :filename => attachment.filename, :only_path => false)
				api.author(:id => attachment.author.id, :name => attachment.author.name) if attachment.author
				api.created_on attachment.created_on
				end
				end
				end