wx_user.rb 8.2 KB

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