channel_qrcode_result.rb 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. # encoding:utf-8
  2. class ChannelQrcodeResult < ActiveRecord::Base
  3. has_paper_trail
  4. self.table_name = "channel_qrcode_results"
  5. belongs_to :channel_qrcode
  6. # belongs_to :wx_user, :foreign_key => :mp_openid
  7. validates_presence_of :mp_openid,:channel_qrcode
  8. def wx_user_nickname
  9. return "-" if self.blank?
  10. wx_user_gzh = WxUserGongzhonghao.where("gzh_open_id = ?", self.mp_openid).first
  11. return "-" if wx_user_gzh.blank?
  12. wx_user = WxUser.where("id = ?", wx_user_gzh.wx_user_id).first
  13. return "-" if wx_user.blank?
  14. return wx_user.nickname
  15. end
  16. def wx_user_id
  17. return "-" if self.blank?
  18. wx_user_gzh = WxUserGongzhonghao.where("gzh_open_id = ?", self.mp_openid).first
  19. if !wx_user_gzh.blank?
  20. return wx_user_gzh.wx_user_id
  21. end
  22. end
  23. def user_tel
  24. return "-" if self.blank?
  25. wx_user_gzh = WxUserGongzhonghao.where("gzh_open_id = ?", self.mp_openid).first
  26. return "-" if wx_user_gzh.blank?
  27. wx_user = WxUser.where("id = ?", wx_user_gzh.wx_user_id).first
  28. return "-" if wx_user.blank?
  29. user = User.where("id = ?", wx_user.user_id).first
  30. return "-" if user.blank?
  31. return user.tel
  32. end
  33. rails_admin do
  34. navigation_label '二维码管理'
  35. parent ChannelQrcode
  36. weight -500
  37. list do
  38. filters [:channel_qrcode, :id]
  39. field :id
  40. field :channel_qrcode
  41. field :channel_qrcode_id
  42. # field :mp_openid
  43. field :user_tel
  44. field :wx_user_nickname
  45. field :wx_user_id
  46. field :created_at
  47. end
  48. show do
  49. field :id
  50. field :channel_qrcode
  51. field :channel_qrcode_id
  52. field :mp_openid
  53. field :user_tel
  54. field :wx_user_nickname
  55. field :wx_user_id
  56. field :created_at
  57. end
  58. edit do
  59. field :mp_openid
  60. field :channel_qrcode
  61. end
  62. end
  63. end