order_detail.rb 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. # encoding:utf-8
  2. class OrderDetail < ActiveRecord::Base
  3. has_paper_trail
  4. self.table_name = "order_details"
  5. belongs_to :product
  6. belongs_to :order, :foreign_key => :order_id
  7. # has_one :order, :foreign_key=>:order_id, :primary_key=>:order_id
  8. validates :order_no,:product_id,:nums, presence: true
  9. validate :order_validation
  10. after_create :import_orders
  11. def import_orders
  12. # 获取商品信息
  13. pd = Product.where("id = ?", self.product_id).first
  14. detail = OrderDetail.where("id = ?", self.id).first
  15. od = Order.where("order_id = ?", self.order_no).first
  16. if !pd.blank? && !od.blank?
  17. detail.order_id=od.id
  18. detail.product_name=pd.name
  19. detail.relate_product_id=pd.relate_product_id
  20. detail.pv=pd.pv
  21. detail.price=pd.price
  22. detail.order_status=order.status
  23. detail.depart=order.depart
  24. od.pv=od.pv+detail.nums*detail.pv
  25. end
  26. # 更新order信息
  27. od.save
  28. detail.save
  29. end
  30. def order_validation
  31. if self.product_id > 0
  32. prd = Product.where("id = ?", self.product_id).first
  33. if prd.blank?
  34. self.errors.add(:product_id,"商品不存在,请重新填写商品ID")
  35. else
  36. self.product_name=prd.name
  37. #self.price=prd.price
  38. end
  39. end
  40. if self.order_no.length>0
  41. ord = Order.where("order_id = ?", self.order_no).first
  42. if ord.blank?
  43. self.errors.add(:order_id,"订单不存在,请重新填写编号")
  44. else
  45. self.order_id=ord.id
  46. end
  47. end
  48. end
  49. def order_state
  50. order = Order.where("id = ?", self.order_id).first
  51. if !order.blank?
  52. return order.status
  53. end
  54. end
  55. def paid_time
  56. order = Order.where("id = ?", self.order_id).first
  57. if !order.blank?
  58. paidTime=order.paied_at == 0 || order.paied_at == nil ? Time.at(0) : Time.at(order.paied_at)
  59. return paidTime
  60. end
  61. return paidTime
  62. end
  63. def pay_way
  64. payWay = ""
  65. order = Order.where("id = ?", self.order_id).first
  66. if !order.blank?
  67. payWay=order.pay_way
  68. end
  69. return payWay
  70. end
  71. STATUS_ENUM = [["未支付","unpay"],["已关闭","closed"],["待确认","unconfirmed"],["处理中","processing"],["已完成","complete"],["待收货","dispatch"],["已退款","refunded"]]
  72. PAY_WAY_ENUM = [
  73. # ["Web网银连连支付","webbankllpay"],
  74. # ["Web认证连连支付","webauthllpay"],
  75. # ["Wap认证连连支付","wapauthllpay"],
  76. ["微信支付","weixinpay"],
  77. ["提货券支付","balance"],
  78. # ["公众号微信支付","gzhwxpay"],
  79. # ["公众号提货券支付","gzhbalance"],
  80. # ["统统微信支付","wx_sumpay"],
  81. # ["统统Web网银支付","webbanksumpay"],
  82. ]
  83. rails_admin do
  84. navigation_label '商品管理'
  85. weight -240
  86. parent Order
  87. list do
  88. filters [:product,:order_no,:nums,:price,:order_status]
  89. field :id
  90. field :order_no do
  91. filterable true
  92. end
  93. #field :order
  94. #field :product
  95. field :product do
  96. visible false
  97. end
  98. field :nums
  99. field :price do
  100. visible true
  101. label "单价(元)"
  102. formatted_value do
  103. value!=0 ? (value/100.0):0
  104. end
  105. end
  106. field :product_name
  107. field :order_status, :enum do
  108. filterable true
  109. enum do
  110. STATUS_ENUM
  111. end
  112. end
  113. # field :paid_time do
  114. # filterable true
  115. # formatted_value do
  116. # #bindings[:object].order.paied_time
  117. # (bindings[:object].order.paied_at == 0 || bindings[:object].order.paied_at == nil) ? Time.at(0) : Time.at(bindings[:object].order.paied_at)
  118. # end
  119. # end
  120. field :paid_time
  121. field :order do
  122. queryable true
  123. searchable [:status]
  124. end
  125. field :pay_way, :enum do
  126. filterable true
  127. enum do
  128. PAY_WAY_ENUM
  129. end
  130. end
  131. field :is_zeng
  132. field :size_name
  133. field :color_name
  134. field :pv do
  135. formatted_value do # used in form views
  136. value.to_f / 100
  137. end
  138. end
  139. field :created_at
  140. field :updated_at
  141. end
  142. show do
  143. field :id
  144. field :order_no
  145. field :product
  146. field :nums
  147. field :is_zeng
  148. field :price do
  149. visible true
  150. label "单价(元)"
  151. formatted_value do
  152. value!=0 ? (value/100.0):0
  153. end
  154. end
  155. field :order_status, :enum do
  156. filterable true
  157. enum do
  158. STATUS_ENUM
  159. end
  160. end
  161. field :product_name
  162. field :size_name
  163. field :color_name
  164. field :pv do
  165. formatted_value do # used in form views
  166. value.to_f / 100
  167. end
  168. end
  169. field :created_at
  170. field :updated_at
  171. end
  172. edit do
  173. field :order_no
  174. #field :order_id
  175. field :product_id
  176. field :nums
  177. field :is_zeng
  178. field :price
  179. end
  180. export do
  181. include_all_fields
  182. field :wx_user_id do
  183. formatted_value do
  184. bindings[:object].order.wx_user_id
  185. end
  186. end
  187. field :nums
  188. field :product_name
  189. field :unit_robo_balance_price do
  190. visible false
  191. end
  192. field :pv do
  193. formatted_value do # used in form views
  194. value.to_f / 100
  195. end
  196. end
  197. end
  198. end
  199. end