BUG #31775 【优惠劵策略】创建优惠劵接口报错 - 技术中心-需求池

重现步骤

测试地址：

https://product-web-test.zhcxkj.com/#/AmazonListing?token=Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2

创建优惠劵接口报错

接口：https://productapi.internal.zhcxkj.com/coupon/strategy/createCouponStrategy

{
"strategyFilterOutput": {
"publishType": 1
},
"strategySource": [{
"countryCode": "GB",
"discountType": 2,
"discountRate": 5.999,
"minSellingPrice": 100.33,
"maxSellingPrice": 55.67,
"budget": 999.99966
}],
"adaptorType": 0,
"strategyName": "测试输入框类型",
"startTime": "2022-09-22 00:00:00",
"endTime": "2022-09-22 23:59:59",
"strategyStatus": 1,
"frequency": 0,
"usefulLife": 85,
"targetCustomer": 1,
"departmentId": 84
}

历史记录

2022-09-21 14:02:44, 由闫峰创建。
2022-09-21 14:10:54, 由闫峰编辑。
修改了 重现步骤，区别为：
002-
002+
003-
003+
004- <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004+ <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
005-
005+
006-
006+
007-
007+ 对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList
008- ~~对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
008+ { "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84}
009- ~~{ "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84}~~
009+
010-
010+
011-
011+ 实际根据SQL：
012- ~~实际根据SQL：~~
012+ “”“
013- ~~“”“~~
013+ SELECT * FROM `coupon`WHERE department_id=84AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59"OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59")
014- ~~SELECT * FROM `coupon`WHERE department_id=84AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59"OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59")~~
014+ ”“”
015- ~~”“”~~
015+
016-
016+ 商品优惠记录/Amazon Lsiting 也存在此问题一并解决

002- ~~~~
002+ 
003- ~~<div class="lake-content">~~
003+ <div class="lake-content">
004- <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=</a>Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004+ <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=</a>Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
005- ~~</div>~~
005+ </div>
006-
006+ <img src="{216266.png}" alt="" />
007- ~~<img src="{216266.png}" alt="" />~~
007+ 对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList
008- ~~对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
008+ { "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84 }
009- { "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84 }
009+ <img src="{216267.png}" alt="" />
010- ~~<img src="{216267.png}" alt="" />~~
010+ 
011- ~~ ~~
011+ 实际根据SQL：
012- ~~实际根据SQL：~~
012+ “”“
013- ~~“”“~~
013+ SELECT * FROM `coupon` WHERE department_id=84 AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59" OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59")
014- SELECT * FROM `coupon` WHERE department_id=84 AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59" OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59") 
014+ ”“”
015- ~~”“”~~
015+ <img src="{216268.png}" alt="" />
016- ~~<img src="{216268.png}" alt="" />~~
016+ 商品优惠记录/Amazon Lsiting 也存在此问题一并解决
2022-09-21 14:12:28, 由闫峰编辑。
修改了 Bug标题，区别为：
001- ~~【优惠劵】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
001+ 【优惠劵商品优惠记录 Amazon Listing】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList

001- ~~【优惠劵】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
001+ 【优惠劵商品优惠记录 Amazon Listing】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList
2022-09-21 15:00:31, 由闫峰编辑。
修改了 重现步骤，区别为：
013- ~~SELECT * FROM `coupon`WHERE department_id=84AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59"OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59")~~
013+ SELECT * FROM `coupon`WHERE department_id=84-- AND source_id=5267AND start_time <= "2022-09-22 23:59:59"AND end_time >= "2022-09-01 00:00:00"
015-
015+

013- SELECT * FROM `coupon` WHERE department_id=84 AND (start_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59" OR end_time BETWEEN "2022-09-01 00:00:00" AND "2022-09-22 23:59:59")
013+ SELECT * FROM `coupon` WHERE department_id=84 -- AND source_id=5267 AND start_time <= "2022-09-22 23:59:59" AND end_time >= "2022-09-01 00:00:00"
015- ~~<img src="{216268.png}" alt="" />~~
015+ <img src="{216285.png}" alt="" />
2022-09-22 09:00:00, 由闫峰编辑。
修改了 指派给 ，旧值为 "qinguangxian"，新值为 "wangqian"。
修改了 重现步骤，区别为：
002-
002+
003-
003+ <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004- <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004+
005-
005+ 创建优惠劵接口报错
006-
006+
007- ~~对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
007+
008- ~~{ "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84}~~
008+
009-
009+ 接口：https://productapi.internal.zhcxkj.com/coupon/strategy/createCouponStrategy
010-
010+ { "strategyFilterOutput": { "publishType": 1 }, "strategySource": [{ "countryCode": "GB", "discountType": 2, "discountRate": 5.999, "minSellingPrice": 100.33, "maxSellingPrice": 55.67, "budget": 999.99966 }], "adaptorType": 0, "strategyName": "测试输入框类型", "startTime": "2022-09-22 00:00:00", "endTime": "2022-09-22 23:59:59", "strategyStatus": 1, "frequency": 0, "usefulLife": 85, "targetCustomer": 1, "departmentId": 84}
011- ~~实际根据SQL：~~
011+
012- ~~“”“~~
012+
013- ~~SELECT * FROM `coupon`WHERE department_id=84-- AND source_id=5267AND start_time <= "2022-09-22 23:59:59"AND end_time >= "2022-09-01 00:00:00"~~
014- ~~”“”~~
015-
016- ~~商品优惠记录/Amazon Lsiting 也存在此问题一并解决~~

002- ~~ ~~
002+ <div class="lake-content">
003- ~~<div class="lake-content">~~
003+ <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=</a>Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004- <a href="https://product-web-test.zhcxkj.com/#/AmazonListing?token=MTgwMl8xXzg3ZTQ1NTM1LTc4NTEtNDdmYS1hNDFhLTNlZGVhYzNlM2JlNg==" target="_blank" class="ne-link" rel="noreferrer noopener">https://product-web-test.zhcxkj.com/#/AmazonListing?token=</a>Mzg5XzFfODdlNDU1MzUtNzg1MS00N2ZhLWE0MWEtM2VkZWFjM2UzYmU2
004+ 
005- ~~</div>~~
005+ 创建优惠劵接口报错
006- ~~<img src="{216266.png}" alt="" />~~
006+ 
007- ~~对应接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
007+ </div>
008- { "key1": 1, "startDate": "2022-09-01 00:00:00", "endDate": "2022-09-22 23:59:59", "otherQueryFlag": 1, "otherQueryList": [], "pageNum": 1, "pageSize": 20, "departmentId": 84 }
008+ <img src="{216380.png}" alt="" />
009- ~~<img src="{216267.png}" alt="" />~~
009+ 接口：https://productapi.internal.zhcxkj.com/coupon/strategy/createCouponStrategy
010- ~~ ~~
010+ { "strategyFilterOutput": { "publishType": 1 }, "strategySource": [{ "countryCode": "GB", "discountType": 2, "discountRate": 5.999, "minSellingPrice": 100.33, "maxSellingPrice": 55.67, "budget": 999.99966 }], "adaptorType": 0, "strategyName": "测试输入框类型", "startTime": "2022-09-22 00:00:00", "endTime": "2022-09-22 23:59:59", "strategyStatus": 1, "frequency": 0, "usefulLife": 85, "targetCustomer": 1, "departmentId": 84 }
011- ~~实际根据SQL：~~
011+ <img src="{216381.png}" alt="" />
012- ~~“”“~~
012+ 
013- ~~SELECT * FROM `coupon` WHERE department_id=84 -- AND source_id=5267 AND start_time <= "2022-09-22 23:59:59" AND end_time >= "2022-09-01 00:00:00"~~
014- ~~”“”~~
015- ~~<img src="{216285.png}" alt="" />~~
016- ~~商品优惠记录/Amazon Lsiting 也存在此问题一并解决~~
2022-09-22 09:05:36, 由闫峰编辑。
修改了 Bug标题，区别为：
001- ~~【优惠劵商品优惠记录 Amazon Listing】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
001+ 【优惠劵策略】创建优惠劵接口报错

001- ~~【优惠劵商品优惠记录 Amazon Listing】根据优惠时间区间查询接口错误涉及接口：https://productapi.internal.zhcxkj.com/coupon/manage/getCouponList~~
001+ 【优惠劵策略】创建优惠劵接口报错
2022-09-22 09:41:29, 由 覃光贤 指派给 覃光贤。
修改了 指派给，旧值为 "wangqian"，新值为 "qinguangxian"。
2022-09-22 09:43:09, 由 覃光贤 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决版本，旧值为 ""，新值为 "625"。
修改了 解决日期，旧值为 ""，新值为 "2022-09-22 09:42:11"。
修改了 指派给 ，旧值为 "qinguangxian"，新值为 "yanfeng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "qinguangxian"。

已解决：创建策略未选是否限制买家是前端没有给传值，后台也没有默认值
2022-09-22 10:27:16, 由闫峰关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yanfeng"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yanfeng"。
修改了 关闭日期，旧值为 ""，新值为 "2022-09-22 10:27:16"。
2023-11-17 11:19:01, 由刘超编辑。
修改了 所属模块，旧值为 "1715"，新值为 "1878"。

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	多平台 java独立项目
所属计划
所属迭代	优惠券项目
Bug类型	程序BUG
严重程度	提示
优先级	P2
Bug状态	已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效	0
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2022-09-22 10:27:16
截止日期	0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给	闫峰

所属迭代	优惠券项目
相关需求
相关任务

Bug的一生
其他相关

由谁创建	闫峰于 2022-09-21 14:02:42
影响环境	625
由谁解决	覃光贤于 2022-09-22 09:42:11
解决版本	亚马逊优惠券V1.0.0
解决方案	程序BUG
由谁关闭	闫峰于 2022-09-22 10:27:16
最后修改	刘超于 2023-11-17 11:18:59

相关Bug