wx_user.rb 6.7 KB

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