zammad/app/models/link.rb

# Copyright (C) 2012-2014 Zammad Foundation, http://zammad-foundation.org/

class Link < ApplicationModel
  belongs_to :link_type,    class_name: 'Link::Type'
  belongs_to :link_object,  class_name: 'Link::Object'

  @map = {
    'normal' => 'normal',
    'parent' => 'child',
    'child'  => 'parent',
  }

=begin

  links = Link.list(
    :link_object       => 'Ticket',
    :link_object_value => 1
  )

=end

  def self.list(data)
    linkobject = link_object_get( name: data[:link_object] )
    return if !linkobject
    items = []

    # get links for one site
    list = Link.where(
      'link_object_source_id = ? AND link_object_source_value = ?', linkobject.id, data[:link_object_value]
    )

    list.each { |item|
      link = {}
      link['link_type']         = @map[ Link::Type.find( item.link_type_id ).name ]
      link['link_object']       = Link::Object.find( item.link_object_target_id ).name
      link['link_object_value'] = item.link_object_target_value
      items.push link
    }

    # get links for the other site
    list = Link.where(
      'link_object_target_id = ? AND link_object_target_value = ?', linkobject.id, data[:link_object_value]
    )
    list.each { |item|
      link = {}
      link['link_type']         = Link::Type.find( item.link_type_id ).name
      link['link_object']       = Link::Object.find( item.link_object_source_id ).name
      link['link_object_value'] = item.link_object_source_value
      items.push link
    }

    items
  end

=begin

   Link.add(
    :link_type                => 'normal',
    :link_object_source       => 'Ticket',
    :link_object_source_value => 6,
    :link_object_target       => 'Ticket',
    :link_object_target_value => 31
  )

  Link.add(
    :link_types_id            => 12,
    :link_object_source_id    => 1,
    :link_object_source_value => 1,
    :link_object_target_id    => 1,
    :link_object_target_value => 1
  )

=end

  def self.add(data)

    if data.key?(:link_type)
      linktype = link_type_get( name: data[:link_type] )
      data[:link_type_id] = linktype.id
      data.delete( :link_type )
    end

    if data.key?(:link_object_source)
      linkobject = link_object_get( name: data[:link_object_source] )
      data[:link_object_source_id] = linkobject.id
      data.delete( :link_object_source )
    end

    if data.key?(:link_object_target)
      linkobject = link_object_get( name: data[:link_object_target] )
      data[:link_object_target_id] = linkobject.id
      data.delete( :link_object_target )
    end

    Link.create(data)
  end

=begin

   Link.remove(
    :link_type                => 'normal',
    :link_object_source       => 'Ticket',
    :link_object_source_value => 6,
    :link_object_target       => 'Ticket',
    :link_object_target_value => 31
  )

=end

  def self.remove(data)
    if data.key?(:link_object_source)
      linkobject = link_object_get( name: data[:link_object_source] )
      data[:link_object_source_id] = linkobject.id
    end

    if data.key?(:link_object_target)
      linkobject = link_object_get( name: data[:link_object_target] )
      data[:link_object_target_id] = linkobject.id
    end

    # from one site
    if data.key?(:link_type)
      linktype = link_type_get( name: data[:link_type] )
      data[:link_type_id] = linktype.id
    end
    links = Link.where(
      link_type_id: data[:link_type_id],
      link_object_source_id: data[:link_object_source_id],
      link_object_source_value: data[:link_object_source_value],
      link_object_target_id: data[:link_object_target_id],
      link_object_target_value: data[:link_object_target_value]
    )
    links.each(&:destroy)

    # from the other site
    if data.key?(:link_type)
      linktype = link_type_get( name: @map[ data[:link_type] ] )
      data[:link_type_id] = linktype.id
    end
    links = Link.where(
      link_type_id: data[:link_type_id],
      link_object_target_id: data[:link_object_source_id],
      link_object_target_value: data[:link_object_source_value],
      link_object_source_id: data[:link_object_target_id],
      link_object_source_value: data[:link_object_target_value]
    )
    links.each(&:destroy)
  end

  def self.link_type_get(data)
    linktype = Link::Type.find_by( name: data[:name] )
    if !linktype
      linktype = Link::Type.create(
        name: data[:name]
      )
    end
    linktype
  end

  def self.link_object_get(data)
    linkobject = Link::Object.find_by( name: data[:name] )
    if !linkobject
      linkobject = Link::Object.create(
        name: data[:name]
      )
    end
    linkobject
  end

end

class Link::Type < ApplicationModel
  validates :name, presence: true
end

class Link::Object < ApplicationModel
  validates :name, presence: true
end