product.rb 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453
  1. class Product < ActiveRecord::Base
  2. has_paper_trail
  3. self.table_name = 'products'
  4. #Thread.current[:current_user] = @current_user
  5. scope :active, -> { where(ptype: "cent_sale") }
  6. scope :inactive, -> { where(ptype: "direct_sale") }
  7. belongs_to :product_cat, :foreign_key => :category_id
  8. belongs_to :merchant, :foreign_key => :merchant_id
  9. validates :product_no,:name,:buy_price,:price,:category_id,:count,:robo_balance_price,:relate_product_id, presence: true
  10. validate :product_validation
  11. validates :id, presence: true, uniqueness: true
  12. def product_validation
  13. if self.relate_product_id <= 0
  14. #主商品默认关联商品
  15. if self.show_flag
  16. self.relate_product_id = self.id
  17. end
  18. prd = Product.where("id = ?", self.relate_product_id).first
  19. if prd.blank?
  20. self.relate_product_id = self.id
  21. end
  22. self.save
  23. end
  24. end
  25. attr_accessor :v_share_img,:get_size_enum,:get_color_enum,:gross_interest_rate
  26. # after_find :get_size_enum
  27. after_create :after_create
  28. before_save :before_save
  29. after_destroy :del_picture
  30. after_update :clear_product_cache
  31. def after_create
  32. #主商品默认关联商品
  33. if self.show_flag
  34. self.relate_product_id = self.id
  35. self.save
  36. end
  37. end
  38. def before_save
  39. #主商品默认关联商品
  40. if self.show_flag
  41. self.relate_product_id = self.id
  42. end
  43. if self.size_id.nil?
  44. self.size_id = 0
  45. end
  46. if self.color_id.nil?
  47. self.color_id = 0
  48. end
  49. end
  50. def del_picture
  51. # 删除商品图片
  52. pictures = ProductPicture.find_by_sql("select * from product_pictures where pic_type=0 and product_id = #{self.id}")
  53. # 创建商品图片
  54. pictures.each do |u|
  55. u.delete
  56. end
  57. end
  58. def clear_product_cache
  59. #清空商品缓存
  60. url = "#{CONFIG_FILE["api_host"]}/railsadmin/clean_cache/product/#{self.id}"
  61. p url
  62. open(url)
  63. end
  64. TYPE_ENUM = [["直营","direct_sale"],["店铺专区","shop_sale"],["积分专区","cent_sale"]]
  65. SIZE_ENUM = []
  66. COLOR_ENUM = []
  67. def get_size_enum
  68. SIZE_ENUM.clear
  69. if SIZE_ENUM.length ==0 && !self.id.nil?
  70. linkSize = ProductAttrConfig.where("product_id=? and size_type='size'",self.relate_product_id).first
  71. if !linkSize.blank?
  72. productAttrs = ProductAttr.where("attr_key_id=? and status=1 ",linkSize.attr_key_id).order("recommend desc")
  73. productAttrs.each do |attr|
  74. a=[attr.name,attr.id]
  75. SIZE_ENUM.push(a)
  76. end
  77. end
  78. end
  79. return SIZE_ENUM
  80. end
  81. def get_color_enum
  82. COLOR_ENUM.clear
  83. if COLOR_ENUM.length==0 && !self.id.nil?
  84. linkColor = ProductAttrConfig.where("product_id=? and size_type='color'",self.relate_product_id).first
  85. if !linkColor.blank?
  86. productColorAttrs = ProductAttr.where("attr_key_id=? and status=1",linkColor.attr_key_id).order("recommend desc")
  87. productColorAttrs.each do |color_attr|
  88. b=[color_attr.name,color_attr.id]
  89. COLOR_ENUM.push(b)
  90. end
  91. end
  92. end
  93. return COLOR_ENUM
  94. end
  95. IMG_STORE_PATH = "product"
  96. def size_name
  97. linkSize = ProductAttr.where("id = ?", self.size_id).first
  98. if !linkSize.blank?
  99. return linkSize.name
  100. else
  101. return "-"
  102. end
  103. end
  104. def color_name
  105. linkColor = ProductAttr.where("id = ?", self.color_id).first
  106. if !linkColor.blank?
  107. return linkColor.name
  108. else
  109. return "-"
  110. end
  111. end
  112. def v_share_img=file
  113. unless file.blank?
  114. file_name = "#{UUID.new.generate[0...8].downcase}.jpg"
  115. file_path = "#{IMG_STORE_PATH}/product/share/#{file_name}"
  116. Ali::Oss.store(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path, file.read)
  117. self.share_img = file_path
  118. self.save
  119. end
  120. end
  121. def clean_share_img
  122. file_path = "#{self.share_img}"
  123. Ali::Oss.delete_object(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path)
  124. end
  125. def get_share_img
  126. url = "http://#{Ali::Oss::CDN_URL_FOR_HOST}/#{self.share_img}"
  127. return url
  128. end
  129. def after_destroy
  130. clean_share_img
  131. end
  132. def gross_interest_rate
  133. rate = 0
  134. if self.buy_price != 0 && self.price != 0
  135. rate = (( self.price.to_f - self.buy_price.to_f )/self.buy_price.to_f)*100
  136. end
  137. return rate
  138. end
  139. rails_admin do
  140. navigation_label '商品管理'
  141. weight -240
  142. list do
  143. #scopes [:inactive]
  144. filters [:id,:detail,:status,:name]
  145. field :id
  146. #field :merchant_id
  147. #field :merchant
  148. field :name do
  149. filterable true
  150. end
  151. field :ptype, :enum do
  152. enum do
  153. TYPE_ENUM
  154. end
  155. end
  156. field :product_no
  157. #field :category_id
  158. field :product_cat
  159. field :detail
  160. field :price do
  161. label "现金价格(元)"
  162. formatted_value do # used in form views
  163. value.to_f / 100
  164. end
  165. end
  166. #field :robo_balance_price
  167. field :user_sale_price
  168. # field :buy_price
  169. #field :gross_interest_rate
  170. field :count
  171. field :recommend
  172. field :status
  173. #field :is_support_poor
  174. field :virtual_sold_count
  175. field :purchase_limit_count
  176. field :share_img do
  177. visible false
  178. formatted_value do
  179. bindings[:view].tag(:img,{:src => bindings[:object].get_share_img,
  180. :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px;',
  181. :onClick => "javascript:window.open('#{bindings[:object].get_share_img}')"})
  182. end
  183. end
  184. field :seckill_price do
  185. label "秒杀显示原价(元)"
  186. formatted_value do # used in form views
  187. value.to_f / 100
  188. end
  189. end
  190. #field :is_only_new
  191. #ield :video_state
  192. field :size_name
  193. field :color_name
  194. field :relate_product_id
  195. field :show_flag
  196. field :live
  197. field :sale_nums
  198. field :single_purch_limit
  199. field :package
  200. field :pv do
  201. formatted_value do # used in form views
  202. value.to_f / 100
  203. end
  204. end
  205. field :out_nums
  206. field :key_words
  207. field :created_at
  208. field :updated_at
  209. end
  210. show do
  211. field :id
  212. field :merchant_id
  213. field :merchant
  214. field :name
  215. field :ptype, :enum do
  216. enum do
  217. TYPE_ENUM
  218. end
  219. end
  220. field :product_no
  221. #field :category_id
  222. field :product_cat
  223. field :detail
  224. field :price do
  225. label "现金价格(元)"
  226. formatted_value do # used in form views
  227. value.to_f / 100
  228. end
  229. end
  230. field :robo_balance_price
  231. field :buy_price
  232. field :user_sale_price
  233. field :count
  234. field :recommend
  235. field :status
  236. #field :is_support_poor
  237. field :virtual_sold_count
  238. field :purchase_limit_count
  239. field :share_content
  240. # field :share_img do
  241. # formatted_value do
  242. # bindings[:view].tag(:img,{:src => bindings[:object].get_share_img,
  243. # :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px;',
  244. # :onClick => "javascript:window.open('#{bindings[:object].get_share_img}')"})
  245. # end
  246. # end
  247. field :seckill_start
  248. field :seckill_end
  249. field :seckill_price do
  250. label "秒杀显示原价(元)"
  251. formatted_value do # used in form views
  252. value.to_f / 100
  253. end
  254. end
  255. field :deliver_stop_at
  256. field :deliver_start_at
  257. field :is_only_new
  258. field :specification
  259. field :no_delivery_area
  260. field :only_delivery_area
  261. field :video_state
  262. field :video_url
  263. field :size_name
  264. field :color_name
  265. field :relate_product_id
  266. field :show_flag
  267. field :live
  268. field :single_purch_limit
  269. field :package
  270. field :product_cycle
  271. field :stock_cycle
  272. field :min_purchase
  273. field :pv do
  274. formatted_value do # used in form views
  275. value.to_f / 100
  276. end
  277. end
  278. field :out_nums
  279. field :silver
  280. field :use_quan
  281. field :key_words
  282. field :created_at
  283. field :updated_at
  284. end
  285. edit do
  286. field :id do
  287. read_only do
  288. bindings[:object].id>0
  289. end
  290. end
  291. field :name
  292. field :ptype, :enum do
  293. enum do
  294. TYPE_ENUM
  295. end
  296. end
  297. field :product_no
  298. #field :category_id
  299. field :merchant_id
  300. field :product_cat
  301. field :detail, :ck_editor
  302. field :price
  303. field :robo_balance_price
  304. field :buy_price
  305. field :user_sale_price
  306. field :count
  307. field :recommend
  308. field :status
  309. #field :is_support_poor
  310. field :virtual_sold_count
  311. field :purchase_limit_count
  312. field :share_content
  313. =begin
  314. field :v_share_img, :file_upload do
  315. pretty_value do
  316. bindings[:view].tag(:img, {:src => bindings[:object].get_share_img, :class => 'preview'})
  317. end
  318. end
  319. =end
  320. field :seckill_start
  321. field :seckill_end
  322. field :seckill_price
  323. field :deliver_stop_at
  324. field :deliver_start_at
  325. field :is_only_new
  326. field :specification
  327. field :no_delivery_area
  328. field :only_delivery_area
  329. field :video_state
  330. field :video_url
  331. field :size_id, :enum do
  332. enum do
  333. bindings[:object].get_size_enum
  334. end
  335. end
  336. field :color_id, :enum do
  337. enum do
  338. bindings[:object].get_color_enum
  339. end
  340. end
  341. field :relate_product_id
  342. field :show_flag
  343. field :live
  344. field :single_purch_limit
  345. field :package
  346. field :product_cycle
  347. field :stock_cycle
  348. field :min_purchase
  349. field :pv
  350. field :out_nums
  351. field :key_words
  352. field :silver
  353. field :use_quan
  354. end
  355. create do
  356. field :id
  357. field :name
  358. field :ptype, :enum do
  359. enum do
  360. TYPE_ENUM
  361. end
  362. end
  363. field :product_no
  364. #field :category_id
  365. field :merchant_id
  366. field :product_cat
  367. field :detail, :ck_editor
  368. field :price
  369. field :robo_balance_price
  370. field :buy_price
  371. field :user_sale_price
  372. field :count
  373. field :recommend
  374. field :status
  375. #field :is_support_poor
  376. field :virtual_sold_count
  377. field :purchase_limit_count
  378. field :share_content
  379. =begin
  380. field :v_share_img, :file_upload do
  381. pretty_value do
  382. bindings[:view].tag(:img, {:src => bindings[:object].get_share_img, :class => 'preview'})
  383. end
  384. end
  385. =end
  386. field :seckill_start
  387. field :seckill_end
  388. field :seckill_price
  389. field :deliver_stop_at
  390. field :deliver_start_at
  391. field :is_only_new
  392. field :specification
  393. field :no_delivery_area
  394. field :only_delivery_area
  395. field :video_state
  396. field :video_url
  397. field :size_id, :enum do
  398. enum do
  399. bindings[:object].get_size_enum
  400. end
  401. end
  402. field :color_id, :enum do
  403. enum do
  404. bindings[:object].get_color_enum
  405. end
  406. end
  407. field :relate_product_id
  408. field :show_flag
  409. field :live
  410. field :single_purch_limit
  411. field :package
  412. field :product_cycle
  413. field :stock_cycle
  414. field :min_purchase
  415. field :pv
  416. field :out_nums
  417. field :key_words
  418. field :silver
  419. field :use_quan
  420. end
  421. end
  422. end