wx_user.rb 8.6 KB

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