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: Content Repository Service
-
Labels:None
-
Environment:
-
Sprint:Sprint 6
Description
used Unique Count doesn't reset the count if subscriber cancel the order before deployment.
1.Select any BA and see the table "contentGroups" of it.
BA: Swimming pools > above ground pools
mysql> SELECT * FROM content_repository.contentGroups WHERE businessAreaID=10904 AND contentTypeID=2;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | contentTypeID | businessCategoryID | businessAreaID | locationID | locationType | languageID | statusID | sourceContentGroupID | totalUniqueCount | usedUniqueCount | contentRequired | businessAreaSubGroupID |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | 2 | 0 | 10904 | 0 | 0 | 2 | 1 | 0 | 10 | 0 | 0 | 0 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
2.Create a Merchant and click 'Current Order' tab
3.Add business Area/Business location and verify the database.
It adds the "usedUniqueCount" to db
mysql> SELECT * FROM content_repository.contentGroups WHERE businessAreaID=10904 AND contentTypeID=2;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | contentTypeID | businessCategoryID | businessAreaID | locationID | locationType | languageID | statusID | sourceContentGroupID | totalUniqueCount | usedUniqueCount | contentRequired | businessAreaSubGroupID |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | 2 | 0 | 10904 | 0 | 0 | 2 | 1 | 0 | 10 | 2 | 0 | 0 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
4.Click the close button, Current order page displays.
Actual result:
After checking the table "content_repository.contentGroups" value of "totalUniqueCount" remains 2. This may leads to wrong alerts if reseller user creates few more merchants with the same BA/BL and close the page without deployment.
Expected:
I would expect the usedUniqueCount should set the value if the order is in status of scheduled/Quotes/deployed.
