# encoding:utf-8
class WaIdUserRole < ActiveRecord::Base
  has_paper_trail
  self.table_name = "wa_id_user_roles"
  belongs_to :wa_id_user, :foreign_key => :user_id
  belongs_to :wa_id_role, :foreign_key => :role_id
  validates :user_id, :role_id, presence: true

  def permission_names
    names = ""
    sql = "select p.name as permission_name from wa_id_role_permissions rp left JOIN wa_id_permissions p on rp.permission_id = p.id where rp.role_id = #{self.role_id}"
    permissionNames = WaIdPermission.find_by_sql(sql)
    permissionNames.each do |u|
        names = names + u.permission_name + ','
    end
    return names
  end

  rails_admin do
    navigation_label '报表权限管理系统'
    parent WaIdUser
    weight -150

    list do
        filters [:id]
        field :id
        field :wa_id_user
        field :wa_id_role
        field :permission_names
    end

    show do
        field :id
        field :wa_id_user
        field :wa_id_role
        field :permission_names
        field :created_at
        field :updated_at
    end

    edit do
        field :wa_id_user
        field :wa_id_role
    end
  end
end