wx_user.rb 7.1 KB

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