Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Jamestown 2.3.0
-
Fix Version/s: Jamestown 2.3.0
-
Component/s: None
-
Labels:None
-
Story Points:8
-
Sprint:Sprint 8
Description
Delete a campaign and add a new one in the same order. The new campaign is added and the budget spread across the 2 campaigns. The original campaign is then terminated and all the budget is allocated to the new campaign, but the terminated campaign keeps its half. Here is an example from NTT's admaxNominalMonthlyBudgets:
mysql> select * from admaxNominalMonthlyBudgets where admaxCampaignID in (59,141);
----------------------------------------------
id | admaxCampaignID | startDate | endDate | budget |
----------------------------------------------
69 | 59 | 2013-08-01 | 2013-08-01 | 6100 |
152 | 59 | 2013-08-02 | 2013-08-02 | 3050 |
153 | 141 | 2013-08-02 | NULL | 6100 |
----------------------------------------------
3 rows in set (0.06 sec)
The budget on the day of the campaign deletion should be spread across all campaigns (including this deleted campaign). The account budget should be allocated to the remaining active/paused campaigns for the day following the campaign deletion. Campaign deletion should also remove any future admaxNominalMonthlyBudgets entry for the deleted campaign before reallocating the budget to the remaining campaigns.
The scenario above should have resulted in:
----------------------------------------------
id | admaxCampaignID | startDate | endDate | budget |
----------------------------------------------
69 | 59 | 2013-08-01 | 2013-08-01 | 6100 |
152 | 59 | 2013-08-02 | 2013-08-02 | 3050 |
153 | 141 | 2013-08-02 | 2013-08-02 | 3050 |
153 | 141 | 2013-08-03 | NULL | 6100 |
----------------------------------------------