product.rb 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
  1. class Product < ActiveRecord::Base
  2. has_paper_trail
  3. self.table_name = 'products'
  4. belongs_to :product_cat, :foreign_key => :category_id
  5. belongs_to :merchant, :foreign_key => :merchant_id
  6. validates :name,:buy_price,:price,:category_id,:count,:robo_balance_price, presence: true
  7. attr_accessor :v_share_img,:get_size_enum,:gross_interest_rate
  8. after_find :get_size_enum
  9. after_create :after_create
  10. #after_update :after_update
  11. before_save :before_save
  12. after_destroy :del_picture
  13. def after_create
  14. #主商品默认关联商品
  15. if self.show_flag
  16. self.relate_product_id = self.id
  17. self.save
  18. end
  19. end
  20. def before_save
  21. #主商品默认关联商品
  22. if self.show_flag
  23. self.relate_product_id = self.id
  24. end
  25. end
  26. def del_picture
  27. # 删除商品图片
  28. pictures = ProductPicture.find_by_sql("select * from product_pictures where pic_type=0 and product_id = #{self.id}")
  29. # 创建商品图片
  30. pictures.each do |u|
  31. u.remove
  32. end
  33. end
  34. TYPE_ENUM = [["直营","direct_sale"]]
  35. #["代销","user_sale"]
  36. SIZE_ENUM = []
  37. COLOR_ENUM = []
  38. def get_size_enum
  39. SIZE_ENUM.clear
  40. if SIZE_ENUM.length ==0 && !self.id.nil?
  41. linkSize = ProductAttrConfig.where("product_id=? and size_type='size'",self.relate_product_id).first
  42. if !linkSize.blank?
  43. productAttrs = ProductAttr.where("attr_key_id=?",linkSize.attr_key_id).order("recommend desc")
  44. productAttrs.each do |attr|
  45. a=[attr.name,attr.id]
  46. SIZE_ENUM.push(a)
  47. end
  48. end
  49. end
  50. COLOR_ENUM.clear
  51. if COLOR_ENUM.length==0 && !self.id.nil?
  52. linkColor = ProductAttrConfig.where("product_id=? and size_type='color'",self.relate_product_id).first
  53. if !linkColor.blank?
  54. productColorAttrs = ProductAttr.where("attr_key_id=?",linkColor.attr_key_id).order("recommend desc")
  55. productColorAttrs.each do |color_attr|
  56. b=[color_attr.name,color_attr.id]
  57. COLOR_ENUM.push(b)
  58. end
  59. end
  60. end
  61. end
  62. IMG_STORE_PATH = "product"
  63. def size_name
  64. linkSize = ProductAttr.where("id = ?", self.size_id).first
  65. if !linkSize.blank?
  66. return linkSize.name
  67. else
  68. return "-"
  69. end
  70. end
  71. def color_name
  72. linkColor = ProductAttr.where("id = ?", self.color_id).first
  73. if !linkColor.blank?
  74. return linkColor.name
  75. else
  76. return "-"
  77. end
  78. end
  79. def v_share_img=file
  80. unless file.blank?
  81. file_name = "#{UUID.new.generate[0...8].downcase}.jpg"
  82. file_path = "#{IMG_STORE_PATH}/product/share/#{file_name}"
  83. Ali::Oss.store(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path, file.read)
  84. self.share_img = file_path
  85. self.save
  86. end
  87. end
  88. def clean_share_img
  89. file_path = "#{self.share_img}"
  90. Ali::Oss.delete_object(Ali::Oss::BUCKET_NAME_PUBLIC_READ, file_path)
  91. end
  92. def get_share_img
  93. url = "http://#{Ali::Oss::CDN_URL_FOR_HOST}/#{self.share_img}"
  94. return url
  95. end
  96. def after_destroy
  97. clean_share_img
  98. end
  99. def gross_interest_rate
  100. rate = 0
  101. if self.buy_price != 0 && self.price != 0
  102. rate = (( self.price.to_f - self.buy_price.to_f )/self.buy_price.to_f)*100
  103. end
  104. return ((rate*100).round.to_f/100).to_s + "%"
  105. end
  106. rails_admin do
  107. navigation_label '商品管理'
  108. weight -240
  109. list do
  110. filters [:id,:detail,:status,:name]
  111. field :id
  112. field :merchant_id
  113. field :merchant
  114. field :name do
  115. filterable true
  116. end
  117. field :ptype, :enum do
  118. enum do
  119. TYPE_ENUM
  120. end
  121. end
  122. #field :category_id
  123. field :product_cat
  124. field :detail
  125. field :price do
  126. label "现金价格(元)"
  127. formatted_value do # used in form views
  128. value.to_f / 100
  129. end
  130. end
  131. field :robo_balance_price
  132. field :user_sale_price
  133. field :buy_price
  134. field :gross_interest_rate
  135. field :count
  136. field :recommend
  137. field :status
  138. #field :is_support_poor
  139. field :virtual_sold_count
  140. field :purchase_limit_count
  141. field :share_img do
  142. visible false
  143. formatted_value do
  144. bindings[:view].tag(:img,{:src => bindings[:object].get_share_img,
  145. :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px;',
  146. :onClick => "javascript:window.open('#{bindings[:object].get_share_img}')"})
  147. end
  148. end
  149. field :seckill_price do
  150. label "秒杀显示原价(元)"
  151. formatted_value do # used in form views
  152. value.to_f / 100
  153. end
  154. end
  155. field :is_only_new
  156. field :video_state
  157. field :size_name
  158. field :color_name
  159. field :relate_product_id
  160. field :show_flag
  161. field :created_at
  162. field :updated_at
  163. end
  164. show do
  165. field :id
  166. field :merchant_id
  167. field :merchant
  168. field :name
  169. field :ptype, :enum do
  170. enum do
  171. TYPE_ENUM
  172. end
  173. end
  174. #field :category_id
  175. field :product_cat
  176. field :detail
  177. field :price do
  178. label "现金价格(元)"
  179. formatted_value do # used in form views
  180. value.to_f / 100
  181. end
  182. end
  183. field :robo_balance_price
  184. field :buy_price
  185. field :user_sale_price
  186. field :count
  187. field :recommend
  188. field :status
  189. #field :is_support_poor
  190. field :virtual_sold_count
  191. field :purchase_limit_count
  192. field :share_content
  193. # field :share_img do
  194. # formatted_value do
  195. # bindings[:view].tag(:img,{:src => bindings[:object].get_share_img,
  196. # :style => 'width: 100px;height: 100px;cursor: pointer;display: block;max-width: 100px;',
  197. # :onClick => "javascript:window.open('#{bindings[:object].get_share_img}')"})
  198. # end
  199. # end
  200. field :seckill_start
  201. field :seckill_end
  202. field :seckill_price do
  203. label "秒杀显示原价(元)"
  204. formatted_value do # used in form views
  205. value.to_f / 100
  206. end
  207. end
  208. field :deliver_stop_at
  209. field :deliver_start_at
  210. field :is_only_new
  211. field :specification
  212. field :no_delivery_area
  213. field :video_state
  214. field :video_url
  215. field :size_name
  216. field :color_name
  217. field :relate_product_id
  218. field :show_flag
  219. field :created_at
  220. field :updated_at
  221. end
  222. edit do
  223. field :name
  224. field :ptype, :enum do
  225. enum do
  226. TYPE_ENUM
  227. end
  228. end
  229. #field :category_id
  230. field :merchant_id
  231. field :product_cat
  232. field :detail, :ck_editor
  233. field :price
  234. field :robo_balance_price
  235. field :buy_price
  236. field :user_sale_price
  237. field :count
  238. field :recommend
  239. field :status
  240. #field :is_support_poor
  241. field :virtual_sold_count
  242. field :purchase_limit_count
  243. field :share_content
  244. =begin
  245. field :v_share_img, :file_upload do
  246. pretty_value do
  247. bindings[:view].tag(:img, {:src => bindings[:object].get_share_img, :class => 'preview'})
  248. end
  249. end
  250. =end
  251. field :seckill_start
  252. field :seckill_end
  253. field :seckill_price
  254. field :deliver_stop_at
  255. field :deliver_start_at
  256. field :is_only_new
  257. field :specification
  258. field :no_delivery_area
  259. field :video_state
  260. field :video_url
  261. field :size_id, :enum do
  262. enum do
  263. SIZE_ENUM
  264. end
  265. end
  266. field :color_id, :enum do
  267. enum do
  268. COLOR_ENUM
  269. end
  270. end
  271. field :relate_product_id
  272. field :show_flag
  273. end
  274. end
  275. end