wx_user.rb 7.4 KB

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