#
#= menus モデル
# Authors:: Sumiyo Yamamoto
# Copyright:: Copyright (C) OrbusNeich Medical K.K.  2010.
#--
# date        name                   note
# 2010.4.23   Sumiyo Yamamoto        新規登録
#-------------------------------------------------------------------------------
#++
class Menu < Comm::BaseModel::General
  include Comm::Const::MasterCode
  has_many :roles_menus, :dependent => :destroy
  has_many :users_menus, :dependent => :destroy
  
  named_scope :with_category_sort, :joins => 'INNER JOIN menu_categories ON menu_categories.id = menus.menu_category_id', :order => 'menu_categories.disp_sort, menus.disp_sort'
  named_scope :with_valid, lambda {|col|
    {:conditions => "`menus`.invalid_flag_code != #{MCODE_FLAG_ON}"}
  }
  
  def self.get_disp_name(name)
    ars = find_by_sql(["SELECT disp_name FROM menus WHERE name = ?", name])
    logger.debug('get_disp_name_ars:'+ars.inspect)
    unless ars.blank?
      return ars.first.disp_name
    end
    return name
  end
end