wx_user.rb 7.1 KB

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