product.rb 11 KB

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