product.rb 12 KB

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