Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: sprint 13: 11-28-2012, Aquidneck
-
Fix Version/s: 2.0.0, sprint 14: 12-05-2012, Aquidneck
-
Component/s: Reseller UI
-
Labels:None
-
Sprint:Sprint 13, Sprint 14
Description
I have created an order for 'Spa Resorts in Auburn (Alabama)'. I took a sellable BA and BL, and deleted all the keywords but 1 neg keyword. This gave me a BES response of $0.00. The UI is not listing this as unsellable.
mysql> SELECT * FROM mms_common.businessAreas where id=10001;
------------------------
id | description | status |
------------------------
10001 | Spa Resorts | active |
------------------------
1 row in set (0.37 sec)
mysql> SELECT * FROM mms_common.businessLocations where description like '%Auburn, Alabama%';
--------------------------------------------------------------------------------------------------------------------+
id | description | shortDescription | status | businessLocationTypeID | useSEDefinedTargets | usePointRadiusTargets | isSellable |
--------------------------------------------------------------------------------------------------------------------+
12015 | Auburn, Alabama | Auburn | active | 5 | 0 | 1 | 1 |
--------------------------------------------------------------------------------------------------------------------+
1 row in set (0.37 sec)
mysql> SELECT * FROM biz_function_location.keywords where keywordListID=2595;
------------------------------------------------------------------------------------
id | keywordListID | keyword | matchType | isGeoMod | isGeoTarget | isMobile | isNegative | subGroupID |
------------------------------------------------------------------------------------
195291 | 2595 | what to | phrase | 0 | 1 | 1 | 1 | 0 |
------------------------------------------------------------------------------------
1 row in set (0.01 sec)
http://optus.aq-qa-tomcat1:8080/sapi/rest/campaign/estimates
Response:
{"status":"VALID","criteria":"campaigns (services in ('GOOGLE') and businessAreaId in ('10001') and locationId in ('12015'))","minimumPrice":0.0,"maximumPrice":0.0,"minimumClicks":0.0,"maximumClicks":0.0,"components":[{"status":"VALID","criteria":"campaigns (businessAreaId in ('10001') and locationId in ('12015') and services in ('GOOGLE'))","minimumPrice":0.0,"maximumPrice":0.0,"minimumClicks":0.0,"maximumClicks":0.0,"components":[
]}]}