order_static.rb 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. # encoding: utf-8
  2. require 'date' # 包含DateTime
  3. require 'time'
  4. class OrderStatic < ActiveRecord::Base
  5. has_paper_trail
  6. self.table_name = "order_statics"
  7. #after_create :order_static
  8. #after_update :order_static
  9. after_destroy :del_static
  10. validates :begin_date,presence: true
  11. def order_static
  12. #统计订单商品销售数据
  13. url = "#{CONFIG_FILE["api_host"]}/railsadmin/order/static/#{self.id}"
  14. p url
  15. open(url)
  16. end
  17. def del_static
  18. # 删除商品统计数据
  19. details = OrderStaticDetail.find_by_sql("select * from order_static_details where static_id = #{self.id}")
  20. # 删除
  21. details.each do |u|
  22. u.delete
  23. end
  24. end
  25. def begin_date_fomat
  26. if !self.begin_date.nil?
  27. return self.begin_date.strftime
  28. end
  29. end
  30. def end_date_fomat
  31. if !self.end_date.nil?
  32. return self.end_date.strftime
  33. end
  34. end
  35. STATUS_ENUM = [["处理中,已完成,待收货",""],["未支付","unpay"],["已关闭","closed"],["待确认","unconfirmed"],["处理中","processing"],["已完成","complete"],["待收货","dispatch"],["已退款","refunded"]]
  36. rails_admin do
  37. navigation_label '统计汇总'
  38. weight -500
  39. list do
  40. filters [:state,:is_send]
  41. field :id
  42. field :begin_date_fomat
  43. field :end_date_fomat
  44. field :state, :enum do
  45. enum do
  46. STATUS_ENUM
  47. end
  48. end
  49. field :is_send
  50. field :created_at
  51. field :updated_at
  52. end
  53. show do
  54. field :id
  55. field :begin_date_fomat
  56. field :end_date_fomat
  57. field :state, :enum do
  58. enum do
  59. STATUS_ENUM
  60. end
  61. end
  62. field :is_send
  63. field :created_at
  64. field :updated_at
  65. end
  66. edit do
  67. field :begin_date
  68. field :end_date
  69. field :state, :enum do
  70. enum do
  71. STATUS_ENUM
  72. end
  73. end
  74. field :is_send
  75. end
  76. end
  77. end