wx_user.rb 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. # encoding:utf-8
  2. #微信用户表
  3. class WxUser < ActiveRecord::Base
  4. has_paper_trail
  5. self.table_name = "wx_users"
  6. belongs_to :user
  7. #has_many :channel_qrcode_results, :foreign_key => :mp_openid
  8. belongs_to :parent_signup_channel, :foreign_key => :channel_qrcode_id
  9. validates_presence_of :nickname, :unionid
  10. #belongs_to :channel_qrcode
  11. attr_accessor :invite, :v_head, :intro_user
  12. SEX_ENUM= [["未知","0"], ["男性","1"], ["女性", "2"]]
  13. COPARTNET_STATE_ENUM = [["否",0],["是",1],["曾经是",2]]
  14. IMG_STORE_PATH = "wx_user"
  15. after_destroy :after_destroy
  16. def invite
  17. wu = WxUser.where("id = ?", invite_id).first
  18. if !wu.blank?
  19. return wu.nickname
  20. end
  21. end
  22. def intro_user
  23. wu = WxUser.where("id = ?", intro_user_id).first
  24. if !wu.blank?
  25. return wu.nickname
  26. end
  27. end
  28. def tel
  29. if self.user_id.to_i >0
  30. u = User.where("id=?",self.user_id).first
  31. return if u.blank?
  32. return u.tel
  33. end
  34. end
  35. def gzhOpenid
  36. if self.id.to_i >0
  37. u = WxUserGongzhonghao.where("wx_user_id=?",self.id).first
  38. return if u.blank?
  39. return u.gzh_open_id
  40. end
  41. return "-"
  42. end
  43. def gzhIsSub
  44. if self.id.to_i >0
  45. u = WxUserGongzhonghao.where("wx_user_id=?",self.id).first
  46. return false if u.blank?
  47. return u.subscribe
  48. end
  49. return false
  50. end
  51. def gzhSubTime
  52. if self.id.to_i >0
  53. u = WxUserGongzhonghao.where("wx_user_id=?",self.id).first
  54. return "-" if u.blank? || u.subscribe_time.blank? || u.subscribe_time == nil
  55. return Time.at(u.subscribe_time) if u.subscribe_time != nil
  56. end
  57. return "-"
  58. end
  59. def gzhUnSubTime
  60. if self.id.to_i >0
  61. u = WxUserGongzhonghao.where("wx_user_id=?",self.id).first
  62. return "-" if u.blank? || u.unsubscribe_time.blank? || u.unsubscribe_time == nil
  63. return Time.at(u.unsubscribe_time) if u.unsubscribe_time != nil
  64. end
  65. return "-"
  66. end
  67. def gzhLastConversationTime
  68. if self.id.to_i >0
  69. u = WxUserGongzhonghao.where("wx_user_id=?",self.id).first
  70. return "-" if u.blank? || u.last_conversation_at.blank? || u.last_conversation_at == nil
  71. return Time.at(u.last_conversation_at) if u.last_conversation_at != nil
  72. end
  73. return "-"
  74. end
  75. rails_admin do
  76. navigation_label '用户管理'
  77. # parent User
  78. weight -300
  79. list do
  80. filters [:id,:user_id,:nickname, :city, :parent_signup_channel, :sale_group, :sale_group_sum]
  81. field :id
  82. field :user_id do
  83. filterable true
  84. end
  85. field :tel
  86. # field :gzhOpenid
  87. field :gzhIsSub, :boolean
  88. field :gzhSubTime
  89. field :gzhUnSubTime
  90. field :gzhLastConversationTime
  91. field :nickname
  92. field :invite_id
  93. field :intro_user_id
  94. field :sex, :enum do
  95. enum do
  96. SEX_ENUM
  97. end
  98. end
  99. field :head do
  100. formatted_value do
  101. bindings[:view].tag(:img,{:src => bindings[:object].get_head_img,
  102. :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px',
  103. :onClick => "javascript:window.open('#{bindings[:object].get_head_img}')"})
  104. end
  105. end
  106. # field :openid
  107. # field :unionid
  108. # field :province
  109. field :city
  110. # field :signup_ip
  111. field :parent_signup_channel
  112. field :show_invite_mode
  113. field :sale_group
  114. field :sale_group_sum
  115. # field :channel_qrcode_id
  116. field :created_at
  117. end
  118. show do
  119. field :id
  120. field :user
  121. field :user_id
  122. field :nickname
  123. field :invite
  124. field :invite_id
  125. field :intro_user
  126. field :intro_user_id
  127. field :sex, :enum do
  128. enum do
  129. SEX_ENUM
  130. end
  131. end
  132. field :head do
  133. formatted_value do
  134. bindings[:view].tag(:img,{:src => bindings[:object].get_head_img,
  135. :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px',
  136. :onClick => "javascript:window.open('#{bindings[:object].get_head_img}')"})
  137. end
  138. end
  139. field :unionid
  140. field :openid
  141. field :gzhOpenid
  142. field :gzhIsSub, :boolean
  143. field :gzhSubTime
  144. field :gzhUnSubTime
  145. field :gzhLastConversationTime
  146. field :province
  147. field :city
  148. field :signup_ip
  149. # field :subscribe
  150. # field :subscribe_time do
  151. # formatted_value do
  152. # (value !=nil || value != 0) ? Time.at(value):Time.now
  153. # end
  154. # end
  155. # field :unsubscribe_time do
  156. # formatted_value do
  157. # (value !=nil || value != 0) ? Time.at(value):Time.now
  158. # end
  159. # end
  160. # field :last_conversation_at do
  161. # formatted_value do
  162. # (value !=nil || value != 0) ? Time.at(value):Time.now
  163. # end
  164. # end
  165. # field :channel_qrcode_id
  166. field :invite_qrcode_url
  167. field :show_invite_mode
  168. field :parent_signup_channel
  169. field :sale_group
  170. field :sale_group_sum
  171. field :created_at
  172. end
  173. edit do
  174. field :user_id
  175. field :nickname
  176. # field :unionid
  177. field :city
  178. field :country
  179. field :province
  180. field :sex, :enum do
  181. enum do
  182. SEX_ENUM
  183. end
  184. end
  185. field :v_head, :file_upload do
  186. pretty_value do
  187. bindings[:view].tag(:img, {:src => bindings[:object].get_head_img, :class => 'preview'})
  188. end
  189. end
  190. # field :subscribe
  191. # field :unsubscribe_time, :datetime do
  192. # formatted_value do
  193. # (value.blank?) ? Time.at(0) : Time.at(value)
  194. # end
  195. # end
  196. # field :subscribe_time, :datetime do
  197. # formatted_value do
  198. # (value.blank?) ? Time.at(0) : Time.at(value)
  199. # end
  200. # end
  201. # field :last_conversation_at
  202. field :invite_id
  203. field :signup_ip
  204. field :channel_qrcode_id
  205. field :invite_qrcode_url
  206. field :show_invite_mode
  207. end
  208. end
  209. def get_head_img
  210. url = "http://#{Ali::Oss::CDN_URL_FOR_HOST}/#{self.head}"
  211. return url
  212. end
  213. def v_head=file
  214. unless file.blank?
  215. clear_head_img
  216. file_name = "#{UUID.new.generate[0...8].downcase}.jpg"
  217. file_path = "#{IMG_STORE_PATH}/#{file_name}"
  218. Ali::Oss.store(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path, file.read)
  219. self.head = file_path
  220. self.save
  221. end
  222. end
  223. def clear_head_img
  224. file_path = "#{self.head}"
  225. Ali::Oss.delete_object(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path)
  226. end
  227. def after_destroy
  228. clear_head_img
  229. end
  230. end