path: root/help/app/models/ticket.rb

class Ticket < CouchRest::Model::Base
  #include ActiveModel::Validations

  use_database "tickets"
  require 'securerandom'
=begin
    title
    created_at
    updated_at
    email_address
    user
    user_verified?
    admins (list of admins who have commented on the ticket)
    code (secret url)
=end

  #belongs_to :user #from leap_web_users. doesn't necessarily belong to a user though
  property :created_by, String, :protected => true #Integer #nil unless user was authenticated for ticket creation, #THIS should not be changed after being set
  #property :regarding_user, String#Integer # form cannot be submitted if they type in a username w/out corresponding ID. this field can be nil. for authenticated ticket creation by non-admins, should this just automatically be set to be same as created_by?  or maybe we don't use this field unless created_by is nil?
  #also, both created_by and regarding_user could be nil---say user forgets username, or has general question
  property :title, String
  property :email, String #verify

  #property :user_verified, TrueClass, :default => false #will be true exactly when user is set
  #admins
  #property :code, String, :protected => true # only should be set if created_by is nil #instead we will just use couchdb ID
  property :is_open, TrueClass, :default => true
  property :comments, [TicketComment]

  timestamps!

  #before_validation :set_created_by, :set_code, :set_email, :on => :create
  before_validation :set_email, :on => :create


  #named_scope :open, :conditions => {:is_open => true} #??

  design do
    #TODO--clean this all up
    view :by_is_open
    view :by_created_by

    view :by_updated_at
    view :by_created_at

    view :by_is_open_and_created_by
    view :by_is_open_and_created_at
    view :by_is_open_and_updated_at

    view :includes_post_by,
      :map =>
      "function(doc) {
        var arr = {}
        if (doc['type'] == 'Ticket' && doc.comments) {
          doc.comments.forEach(function(comment){
          if (comment.posted_by && !arr[comment.posted_by]) {
             //don't add duplicates
             arr[comment.posted_by] = true;
             emit(comment.posted_by, 1);
          }
          });
        }
      }", :reduce => "function(k,v,r) { return sum(v); }"

    view :includes_post_by_and_open_status_and_updated_at,
      :map =>
      "function(doc) {
        var arr = {}
        if (doc['type'] == 'Ticket' && doc.comments) {
          doc.comments.forEach(function(comment){
          if (comment.posted_by && !arr[comment.posted_by]) {
            //don't add duplicates
            arr[comment.posted_by] = true;
            emit([comment.posted_by, doc.is_open, doc.updated_at], 1);
          }
          });
        }
      }", :reduce => "function(k,v,r) { return sum(v); }"

    view :includes_post_by_and_open_status_and_created_at,
      :map =>
      "function(doc) {
        var arr = {}
        if (doc['type'] == 'Ticket' && doc.comments) {
          doc.comments.forEach(function(comment){
          if (comment.posted_by && !arr[comment.posted_by]) {
            //don't add duplicates
            arr[comment.posted_by] = true;
            emit([comment.posted_by, doc.is_open, doc.created_at], 1);
          }
          });
        }
      }", :reduce => "function(k,v,r) { return sum(v); }"

    view :includes_post_by_and_updated_at,
      :map =>
      "function(doc) {
        var arr = {}
        if (doc['type'] == 'Ticket' && doc.comments) {
          doc.comments.forEach(function(comment){
          if (comment.posted_by && !arr[comment.posted_by]) {
            //don't add duplicates
            arr[comment.posted_by] = true;
            emit([comment.posted_by, doc.updated_at], 1);
          }
          });
        }
      }", :reduce => "function(k,v,r) { return sum(v); }"


    view :includes_post_by_and_created_at,
      :map =>
      "function(doc) {
        var arr = {}
        if (doc['type'] == 'Ticket' && doc.comments) {
          doc.comments.forEach(function(comment){
          if (comment.posted_by && !arr[comment.posted_by]) {
            //don't add duplicates
            arr[comment.posted_by] = true;
            emit([comment.posted_by, doc.created_at], 1);
          }
          });
        }
      }", :reduce => "function(k,v,r) { return sum(v); }"

  end

  validates :title, :presence => true
  #validates :comments, :presence => true #do we want it like this?


  # html5 has built-in validation which isn't ideal, as it says 'please enter an email address' for invalid email addresses, which implies an email address is required, and it is not.
  validates :email, :format => /\A([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})\Z/, :if => :email #email address is optional

  #TODO:
  #def set_created_by
  #  self.created_by = User.current if User.current
  #end

  def self.for_user(user, options = {}, is_admin = false)

    # TODO: This is obviously super tedious. we will refactor later.
    # TODO: thought i  should reverse keys for descending, but that didn't work. look into whether that should be tweaked, and whether it works okay with pagination (seems to now...)
    # TODO: Time.now + 2.days is to catch tickets created in future. shouldn't happen but does on my computer now, so this at least catches for now.
    # TODO handle default values correctly:
    options[:open_status] = 'open' if !options[:open_status] #hacky. redo this when handling defaults correctly

    if (is_admin && (options[:admin_status] != 'mine'))
      # show all (selected) tickets to admin
      if options[:open_status] == 'all'
        if options[:sort_order] == 'created_at_desc'
          Ticket.by_created_at.startkey(0).endkey(Time.now + 2.days).descending
        elsif options[:sort_order] == 'updated_at_asc'
          Ticket.by_updated_at.startkey(0).endkey(Time.now + 2.days)
        elsif options[:sort_order] == 'created_at_asc'
          Ticket.by_created_at.startkey(0).endkey(Time.now + 2.days)
        else
          Ticket.by_updated_at.startkey(0).endkey(Time.now + 2.days).descending
        end
      else
        if options[:sort_order] == 'created_at_desc'
          Ticket.by_is_open_and_created_at.startkey([(options[:open_status] == 'open'), 0]).endkey([(options[:open_status] == 'open'),  Time.now + 2.days]).descending
        elsif options[:sort_order] == 'updated_at_asc'
          Ticket.by_is_open_and_updated_at.startkey([(options[:open_status] == 'open'), 0]).endkey([(options[:open_status] == 'open'),  Time.now + 2.days])
        elsif options[:sort_order] == 'created_at_asc'
          Ticket.by_is_open_and_created_at.startkey([(options[:open_status] == 'open'), 0]).endkey([(options[:open_status] == 'open'),  Time.now + 2.days])
        else
          Ticket.by_is_open_and_updated_at.startkey([(options[:open_status] == 'open'), 0]).endkey([(options[:open_status] == 'open'),  Time.now + 2.days]).descending
        end
      end
    else
      # only show tickets this user has commented on, as user is non-admin or admin viewing only their tickets
      if options[:open_status] == 'all'
        if options[:sort_order] == 'created_at_desc'
          Ticket.includes_post_by_and_created_at.startkey([user.id, 0]).endkey([user.id, Time.now + 2.days]).descending
        elsif options[:sort_order] == 'updated_at_asc'
          Ticket.includes_post_by_and_updated_at.startkey([user.id, 0]).endkey([user.id, Time.now + 2.days])
        elsif options[:sort_order] == 'created_at_asc'
          Ticket.includes_post_by_and_created_at.startkey([user.id, 0]).endkey([user.id, Time.now + 2.days])
        else
          Ticket.includes_post_by_and_updated_at.startkey([user.id, 0]).endkey([user.id,  Time.now + 2.days]).descending
        end
      else
        if options[:sort_order] == 'created_at_desc'
          Ticket.includes_post_by_and_open_status_and_created_at.startkey([user.id, (options[:open_status] == 'open'), 0]).endkey([user.id, (options[:open_status] == 'open'), Time.now + 2.days]).descending
        elsif options[:sort_order] == 'updated_at_asc'
          Ticket.includes_post_by_and_open_status_and_updated_at.startkey([user.id, (options[:open_status] == 'open'), 0]).endkey([user.id, (options[:open_status] == 'open'), Time.now + 2.days]) 
        elsif options[:sort_order] == 'created_at_asc'
          Ticket.includes_post_by_and_open_status_and_created_at.startkey([user.id, (options[:open_status] == 'open'), 0]).endkey([user.id, (options[:open_status] == 'open'), Time.now + 2.days]) 
        else
          Ticket.includes_post_by_and_open_status_and_updated_at.startkey([user.id, (options[:open_status] == 'open'), 0]).endkey([user.id, (options[:open_status] == 'open'), Time.now + 2.days]).descending
        end
      end
    end
  end

  def self.tickets_by_commenter(user_id)#, options = {})
    Ticket.includes_post_by_and_updated_at.startkey([user_id, 0]).endkey([user_id, Time.now])
  end

  def is_creator_validated?
    !!created_by
  end

=begin
  def set_code #let's not use this---can use same show url
    # ruby 1.9 provides url-safe option---this is not necessarily url-safe
    self.code = SecureRandom.hex(8) if !is_creator_validated?
  end
=end


  def set_email
    self.email = nil if self.email == ""
    # in controller set to be current users email if that exists
  end

  #not saving with close and reopen, as we will save in update when they are called.
  #TODO: not sure if we should bother with these:
  def close
    self.is_open = false
    #save
  end

  def reopen
    self.is_open = true
    #save
  end

  def commenters
    commenters = []
    self.comments.each do |comment|
      if comment.posted_by
        if user = User.find(comment.posted_by)
          commenters << user.login if user and !commenters.include?(user.login)
        else
          commenters << 'unknown user' if !commenters.include?('unknown user') #todo don't hardcode string 'unknown user'
        end
      else
        commenters << 'unauthenticated user' if !commenters.include?('unauthenticated user') #todo don't hardcode string 'unauthenticated user'
      end
    end
    commenters.join(', ')
  end

  def comments_attributes=(attributes)
    if attributes # could be empty as we will empty if nothing was typed in
      comment = TicketComment.new(attributes.values.first) #TicketComment.new(attributes)
      #comment.posted_by = User.current.id if User.current #we want to avoid User.current, and current_user won't work here. instead will set in tickets_controller
      # what about: comment.posted_by = self.updated_by  (will need to add ticket.updated_by)
      comment.posted_at = Time.now
      comments << comment
    end
  end

=begin
  def validate
    if email_address and not email_address.strip =~ RFC822::EmailAddress
      errors.add 'email', 'contains an invalid address'
    end
  end
=end
end