product.rb 12 KB

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