Class: Coupon::PromoItemSync

Inherits:
BaseService show all
Defined in:
app/services/coupon/promo_item_sync.rb

Defined Under Namespace

Classes: InvalidCouponType, MissingCatalogItems, PriceCalculator

Constant Summary collapse

VALID_COUPON_TYPES = 
['%', '%V', '%M', '$'].freeze

Instance Method Summary collapse

Methods inherited from BaseService

#initialize, #log_debug, #log_error, #log_info, #log_warning, #logger, #options, #tagged_logger

Constructor Details

This class inherits a constructor from BaseService

Instance Method Details

#apply_coupon_to_catalog_items(coupon) ⇒ Object 



90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
 
# File 'app/services/coupon/promo_item_sync.rb', line 90

def apply_coupon_to_catalog_items(coupon)
  # Real-time ltree queries - no cache refresh needed
  current_catalog_items = coupon.all_applicable_catalog_items
  current_catalog_item_ids = current_catalog_items.pluck(:id)

  # Find items that were previously linked but are no longer applicable
  previously_linked_items = CatalogItem.where('coupon_id = ? OR new_coupon_id = ?', coupon.id, coupon.id)
  items_to_unlink = previously_linked_items.where.not(id: current_catalog_item_ids)

  results = current_catalog_items.map do |catalog_item|
    changes = determine_changes_for_catalog_item(catalog_item, coupon)
    update_catalog_item(catalog_item, changes)
  end.compact

  # Clear promotions for items no longer applicable
  items_to_unlink.each do |catalog_item|
    changes = clear_promotion_for_catalog_item(catalog_item, coupon)
    results << update_catalog_item(catalog_item, changes)
  end

  coupon.update(promo_tracking: false) if current_catalog_items.blank?

  results.compact
end

#cleanup_orphaned_sales_promotions ⇒ Object 



170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
 
# File 'app/services/coupon/promo_item_sync.rb', line 170

def cleanup_orphaned_sales_promotions
  results = []

  CatalogItem.where(coupon_id: nil)
             .where.not(sale_price: nil)
             .find_each do |catalog_item|
    catalog_item.update(sale_price: nil)
    results << build_cleanup_result(catalog_item, :sale_price)
  end

  CatalogItem.where(new_coupon_id: nil)
             .where.not(new_sale_price: nil)
             .find_each do |catalog_item|
    catalog_item.update(new_sale_price: nil)
    results << build_cleanup_result(catalog_item, :new_sale_price)
  end

  results
end

#cleanup_removed_catalog_items(coupon, current_catalog_item_ids) ⇒ Object 



160
161
162
163
164
165
166
167
168
 
# File 'app/services/coupon/promo_item_sync.rb', line 160

def cleanup_removed_catalog_items(coupon, current_catalog_item_ids)
  CatalogItem.where(coupon_id: coupon.id)
             .where.not(id: current_catalog_item_ids)
             .update_all(coupon_id: nil, sale_price: nil)

  CatalogItem.where(new_coupon_id: coupon.id)
             .where.not(id: current_catalog_item_ids)
             .update_all(new_coupon_id: nil, new_sale_price: nil)
end

#determine_changes_for_catalog_item(catalog_item, coupon) ⇒ Object 



115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
 
# File 'app/services/coupon/promo_item_sync.rb', line 115

def determine_changes_for_catalog_item(catalog_item, coupon)
  changes = {}
  should_recalculate = coupon.calculation_type_goods != 'MX'

  case coupon.status
  when :active
    if catalog_item.new_coupon_id == coupon.id
      changes = {
        coupon_id: coupon.id,
        new_coupon_id: nil,
        sale_price: if should_recalculate
                      PriceCalculator.new(catalog_item, coupon).calculate_sale_price
                    else
                      catalog_item.new_sale_price
                    end,
        new_sale_price: nil
      }
    elsif catalog_item.coupon_id != coupon.id || should_recalculate
      changes[:coupon_id] = coupon.id
      changes[:sale_price] = PriceCalculator.new(catalog_item, coupon).calculate_sale_price
    end
  when :not_yet_in_effect
    if catalog_item.coupon_id == coupon.id
      new_sale_price = if should_recalculate
                         PriceCalculator.new(catalog_item, coupon).calculate_sale_price
                       else
                         catalog_item.sale_price
                       end
      changes = {
        coupon_id: nil,
        new_coupon_id: coupon.id,
        sale_price: nil,
        new_sale_price: new_sale_price
      }
    elsif catalog_item.new_coupon_id != coupon.id || should_recalculate
      changes[:new_coupon_id] = coupon.id
      changes[:new_sale_price] = PriceCalculator.new(catalog_item, coupon).calculate_sale_price
    end
  else
    changes = clear_promotion_for_catalog_item(catalog_item, coupon)
  end

  changes
end

#process(coupons = nil, trial_run: false, skip_no_changes: true) ⇒ Object 



57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
 
# File 'app/services/coupon/promo_item_sync.rb', line 57

def process(coupons = nil, trial_run: false, skip_no_changes: true)
  res = []
  CatalogItem.transaction do
    # First, clean up any stale references to expired coupons
    cleanup_expired_coupon_references

    coupons = fetch_relevant_coupons(coupons)
    logger.info "Processing #{coupons.size} coupons and synchronizing promotions"

    res = coupons.order(:expiration_date, :effective_date).map do |coupon|
      process_coupon(coupon)
    end

    res += cleanup_orphaned_sales_promotions
    res = res.reject { |r| r[:status] == :no_changes } if skip_no_changes
    raise ActiveRecord::Rollback if trial_run
  end
  res
end

#process_coupon(coupon) ⇒ Object 



77
78
79
80
81
82
83
84
85
86
87
88
 
# File 'app/services/coupon/promo_item_sync.rb', line 77

def process_coupon(coupon)
  return invalid_coupon_result(coupon) unless valid_coupon?(coupon) && coupon.valid?

  result = apply_coupon_to_catalog_items(coupon)
  {
    coupon_id: coupon.id,
    coupon_code: coupon.code,
    status: result.present? ? :changes_applied : :no_changes,
    result: result,
    message: coupon.saved_changes.present? ? "Coupon updated: #{coupon.saved_changes.inspect}" : nil
  }
end