# Copyright (C) 2012-2013 Zammad Foundation, http://zammad-foundation.org/ class Tag < ApplicationModel belongs_to :tag_object, :class_name => 'Tag::Object' belongs_to :tag_item, :class_name => 'Tag::Item' @@cache_item = {} @@cache_object = {} def self.tag_add(data) # lookups if data[:object] tag_object_id = self.tag_object_lookup( data[:object] ) end if data[:item] tag_item_id = self.tag_item_lookup( data[:item] ) end # create history Tag.create( :tag_object_id => tag_object_id, :tag_item_id => tag_item_id, :o_id => data[:o_id], :created_by_id => data[:created_by_id], ) return true end def self.tag_remove(data) # lookups if data[:object] tag_object_id = self.tag_object_lookup( data[:object] ) end if data[:item] tag_item_id = self.tag_item_lookup( data[:item] ) end # create history result = Tag.where( :tag_object_id => tag_object_id, :tag_item_id => tag_item_id, :o_id => data[:o_id], ) result.each { |item| item.destroy } return true end def self.tag_list( data ) tag_object_id_requested = self.tag_object_lookup( data[:object] ) tag_search = Tag.where( :tag_object_id => tag_object_id_requested, :o_id => data[:o_id], ) tags = [] tag_search.each {|tag| tags.push self.tag_item_lookup_id( tag.tag_item_id ) } return tags end private def self.tag_item_lookup_id( id ) # use cache return @@cache_item[ id ] if @@cache_item[ id ] # lookup tag_item = Tag::Item.find(id) @@cache_item[ id ] = tag_item.name return tag_item.name end def self.tag_item_lookup( name ) name = name.downcase # use cache return @@cache_item[ name ] if @@cache_item[ name ] # lookup tag_item = Tag::Item.where( :name => name ).first if tag_item @@cache_item[ name ] = tag_item.id return tag_item.id end # create tag_item = Tag::Item.create( :name => name ) @@cache_item[ name ] = tag_item.id return tag_item.id end def self.tag_object_lookup_id( id ) # use cache return @@cache_object[ id ] if @@cache_object[ id ] # lookup tag_object = Tag::Object.find(id) @@cache_object[ id ] = tag_object.name return tag_object.name end def self.tag_object_lookup( name ) # use cache return @@cache_object[ name ] if @@cache_object[ name ] # lookup tag_object = Tag::Object.where( :name => name ).first if tag_object @@cache_object[ name ] = tag_object.id return tag_object.id end # create tag_object = Tag::Object.create( :name => name ) @@cache_object[ name ] = tag_object.id return tag_object.id end class Object < ActiveRecord::Base end class Item < ActiveRecord::Base end end