product.rb 12 KB

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