查询价格策略接口

请求方式:** POST(HTTPS
请求地址: https://openapi.waiqin365.com/api/product/v1/getProductPriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求包体:


{
	"page_number":1,
	"page_length":1000,
	"start_create_date":"2018-08-11 00:00:00",
	"end_create_date":"2018-08-13 00:00:00",
	"start_modify_date":"2018-08-11 00:00:00",
	"end_modify_date":"2018-08-13 00:00:00"
}

请求信息

参数 类型 必填 说明
page_number INT 页码默认1,每页默认1000条
page_length INT 每页记录条数,默认最大是1000条,可以根据业务数据的大小自行优化调整
start_create_date TIMESTAMP 创建时间开始,格式:“yyyy-MM-dd HH:mm:ss”
end_create_date TIMESTAMP 创建时间结束,格式:“yyyy-MM-dd HH:mm:ss”
start_modify_date TIMESTAMP 修改时间开始,格式:“yyyy-MM-dd HH:mm:ss”
end_modify_date TIMESTAMP 修改时间结束,格式:“yyyy-MM-dd HH:mm:ss”

返回结果:

{
    "return_code":"0",
    "return_msg":null,
    "msg_id":null,
    "response_data":[
    {
        "basPdPriceStrategyCusFields":[
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"4979556103081514064",
                "field_code":"dept_id",
                "field_name":"部门",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"5413971904313689661,5954366674468213302",
                "selected_item_text":"12qqq,11qqq",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8288376007042223235",
                "field_code":"district_level",
                "field_name":"销售区域等级",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"6607275807085210917,8545708648846165721",
                "selected_item_text":"区域一级,区域二级",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5494965676058802438",
                "field_code":"customer_level",
                "field_name":"客户级别",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8715900737400193117,8783574560179216331,7287736961434231483",
                "selected_item_text":"A,B,C",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8187012878749847224",
                "field_code":"type_id",
                "field_name":"客户类型",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"7968458325024557719,7453205613633003407,5956742668490842859",
                "selected_item_text":"柱子类型,美缝店,单点批发",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"9102985683946733927",
                "field_code":"district_id",
                "field_name":"销售区域",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"1,4806549509248390549,9033269349423299426,4752605905626817542,5172862724621820894,7878766441603271576,6785473900023654609,5995859948628215574,9169414679160463659,6773834101348215655,8786682329420901249,6195853786308036891,5372171151167711712,8874372792720561376,7304205221425696595,6960128143568984830,5710399329032315145,4804930406018092418,8489022005741326107,6806984620975186605,7428922093170555232,8533475929045161968,5906712671265363607,5100004136839045131,8284098494790711209,5010101877517354662,7806316745076661229,7138635441227236439,5815041733160833953,6097110251496906764,9025130784836963679,5696174322419711894,8955974180437968647,6747691676937226390,5195849651805980642,7526773239149343454,8740002155359438607,6963848895258915695,6850451088181149271,7065874705002694868,7783048511557988502,8778506838930814321,5823121226032629820,9188459084514376508,8867696563624985803,5865439157473931704,5527404313734044529,7296890691583075142,8930998420006522781,7070655248600579965,4902054486495703934,6801653132571983720,5529179932315498331,6603938152513443422,7872800272962472647,5880045821365020046,8913791271306861573,5151941004870826006,7263594792154791934,8324111440386071455,5077051679792776967,8580182701647580820,5702415534215861612,5238641019005819639,8354853937680199661,8772829059239811248,9144410552198320605,8543725367370187450,6912700714433452061,7632610531119472307,7993184399593192876,8233462514004593793,8717579005028977129,5375541928661155412,8766085005154528319,8727652304406876353,4619163087627090549,7737316096259733246,5441483285055897460,9143955630056285073,7278928503899599098,6586848752069027416,6726552100426717974,8970878233371231519,4955061303843073817,8232091440202415760,6501506605141136894,5063691707131402417,6783830511963156939,5202650038133212212,7039909120009811622,6640209450032675922,7013351736687549262,8138335173189198872,7435766603881487772,6242769196531452572,9093757342451377159,6329989745150292251,8666259690017178880,5951455493630980694,7093517604680735234,8186363579390047200,6919813024558055804,5200946157833865222,4887015100184006472,7432823404565244327,8675068399081760468,5376251103504517480,7642427453514515739,6243295676460430050,5378093492323604697,8073976789933817404,4748559502293929462,5875299345031036024,5493186891473535231,5017015625344217499,6198304780946954807,5725005542041707921,5536261255308539742,6304100798578235756,4680244488935885957,7960492542065255169,7919255442124012067,5405028306500034286,8536347350806976556,4893576777483790104,7480882999482121963,8533528566914743092,5933982033045575488,8389501742623096361,5417420030865051889,8954095507963813713,6198378901073411562,4947095505757021979,6949325417668500852,7435808791924729308,7718963484845585934,8651006405369092938,5569597650914420500,5145761042373974517,4769225561796668182,7763043568847285623,8326937101137054496,5187421991303225224,7978826777595183693,5459497091108394484,8328420616055638504,5358576904327034753,7463377676457570149,8795428034949269387,5382601958084297458,7701725590267631545,7074722888797379064,6429136148696713624,5594042758894180628,6876626278689687372,5722644553629959963,7001430785260730618,7892083307954004979,9070303658142746618,6060087493865710511,7880654964019048592,6875181123275081768,6050289425316521536,9111436306787949301,8811887159084713481,9139017897669033841,5743416740837154954",
                "selected_item_text":"莱阳市,岚山区新玛特,青岛市,即墨大润发,威海海滨,威海国际海水浴场,威海汽车站,潍坊大学城1,李沧区西北,百事,城阳农业大学,莱西利群,日照火车站,日照大润发,日照银座,日照百货大楼,日照新玛特,汤头温泉城,蓝海职业学院,河口公园,莱西市,青岛市南+市北+崂山+李沧区,青岛新增客户用,烟台市莱山区,烟台市福山区,福山天府街,烟台市牟平区,威海市环翠区,烟台市龙口东区,烟台市龙口西区,莱州市,潍坊市奎文区,日照市东港北区,东营西区,东营南区,东营河口区,东营超市配送,青岛火车站,青岛市城阳区,黄岛区,黄岛区胶南,胶南商业街,胶州市,即墨市,平度市,烟台城服商务学院,烟台市芝罘区,烟台南山公园,烟台市开发区,威海市开发区,荣成市,烟台市龙口市乡镇,潍坊市潍城区,日照市东港南区,日照市岚山区,临沂市兰山+河东+罗庄区,东营东区,滨州滨城区,滨州中百,胜利油田盛大超市,青岛海云庵步行街,青岛大学城,青岛台东步行街,东方影城,胶南佳乐家,胶南汽车站,胶州佳乐家,胶州工学院,胶州大润发,向阳路商贸城,即墨佳乐家,金沙滩,湘江路,黄岛大学城,即墨宝龙,长江路,即墨服装城,平度维客,平度利群,平度大润发,莱西利客来,平度汽车站,莱西汽车站,莱西威海路,莱阳大润发,莱阳鲁花,莱阳汽车站,莱阳国货,烟台大学城,烟台第二浴场,烟台鲁东大学,烟台三站街道,万达广场,烟台南大街街道,烟台友谊广场,烟台金沙滩海水浴场,烟台富士康,烟台技术学院,烟台汽车工程学院,永安街振华,福山大润发,烟台西关大街,烟台牟平振华超市,烟台职业学院,昆嵛山景区,威海大世界步行街,威海韩国城,威海山大和哈工大学校,开发区韩乐坊,开发区汽车站,开发区华夏城,开发区海水浴场,荣成步行街,荣成哈理工,石岛步行街,荣城振华超市,龙口南山集团驻地,龙口汽车站,东海大学,博商超市,龙口龙鼎广场,龙口西站,龙口步行街,龙口海边景点,龙口东海大学城,百家福商场,莱州市北关街,莱州府西街,莱州市干休所,潍坊世纪泰华,潍坊歌尔,潍坊学院,潍坊大学城2,白浪河湿地公园,潍坊中百大厦,潍坊火车站,日照万平口景区,日照大学城,日照汽车站,岚山区银座,万德福商场,岚山区田园小区,临沂启阳美食街,临沂大润发步行街,罗庄华五路,东方不夜城,临沂动物园,临沂大学城,东营百货大楼,东营汽车站1,乐活城美食街,东营利群,东营石油大学,油田一中,五十五中,东营汽车站2,金辰美食街,樱花园园,东营职业学院,河口一中,河口银座,河口步行街,滨州学院,滨州五四,滨州职业技术学院,城阳国货,城阳琴岛学院,城阳正阳路",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"7445732441433526198",
                "field_code":"uper_cus",
                "field_name":"",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"7402769540893857974,4640262891423236599,5539558200138420640",
                "selected_item_text":"sck分销经销商,洪庆源,测试导入生成仓库1",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"6443331098049308800",
                "field_code":"exdf_freq_2",
                "field_name":"拜访频率",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"两周1次,三周1次,四周1次",
                "selected_item_text":"两周1次,三周1次,四周1次",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5153235833903571544",
                "field_code":"exdf_255526",
                "field_name":"订单流向",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"ECC,SFA",
                "selected_item_text":"ECC,SFA",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"4799997507833114611",
                "field_code":"exdf_292834",
                "field_name":"关店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8:00,8:30,9:30",
                "selected_item_text":"8:00,8:30,9:30",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5906354120252671343",
                "field_code":"exdf_400709",
                "field_name":"开店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"00:00,00:30",
                "selected_item_text":"00:00,00:30",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            }
        ],
        "basPdPriceStrategyCuss":[],"basPdPriceStrategyProducts":[{"base_unit":"5815325918493502423","create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","id":"","input_unit":"7658328476828204462","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"10004","pd_id":"8886153687546478293","pd_name":"冰绿茶","price_down":"","price_strategy_product_id":"9002288385045669146","price_up":"","sale_price":"54.00000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"8990464306442485161","create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","id":"","input_unit":"7315285013888868292","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"10003","pd_id":"7409269227144953294","pd_name":"冰红茶","price_down":"","price_strategy_product_id":"8093103850531750767","price_up":"","sale_price":"40.00000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"4672182452429575410","create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","id":"","input_unit":"4672182452429575410","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"10002","pd_id":"7407531258183844770","pd_name":"雪碧","price_down":"","price_strategy_product_id":"6239722472665744741","price_up":"","sale_price":"3.00000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"8851908411956994717","create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","id":"","input_unit":"8851908411956994717","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"1","pd_id":"6831390366898028953","pd_name":"1221","price_down":"","price_strategy_product_id":"8097950472231147547","price_up":"","sale_price":"11.00000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"6076877019412887312","create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","id":"","input_unit":"7564562801574625666","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"10005","pd_id":"4892238857644646947","pd_name":"红牛2","price_down":"","price_strategy_product_id":"7780340540109719162","price_up":"","sale_price":"82.00000000","sequ":"","status":"1","strategy_id":""}],"basPdPriceStrategySameCodes":[],"create_time":"2018-08-21 08:33:12","creator_id":"4993053750015187044","end_time":"2020-08-15 00:00:00","id":"","is_enable":"1","modify_time":"","modifyier_id":"","price_strategy_id":"5248497830880571426","prod_num":"5","product_type":"1","start_time":"2018-08-21 00:00:00","status":"1","title":"ssz测试","trade_range":"1","trade_type":"2"
},
{"basPdPriceStrategyCusFields":[{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"6648068697815115433","field_code":"dept_id","field_name":"部门","id":"","modify_time":"","modifyier_id":"","selected_item":"6293038467202789830,5862256324923875820","selected_item_text":"考勤组织,方便面","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"7440589558422644015","field_code":"district_level","field_name":"销售区域等级","id":"","modify_time":"","modifyier_id":"","selected_item":"6607275807085210917,8545708648846165721","selected_item_text":"区域一级,区域二级","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"8454993694742261279","field_code":"customer_level","field_name":"客户级别","id":"","modify_time":"","modifyier_id":"","selected_item":"8715900737400193117,7287736961434231483","selected_item_text":"A,B","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"8128575266911187982","field_code":"type_id","field_name":"客户类型","id":"","modify_time":"","modifyier_id":"","selected_item":"7453205613633003407,5956742668490842859","selected_item_text":"柱子类型,美缝店","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"8942593049559607484","field_code":"district_id","field_name":"销售区域","id":"","modify_time":"","modifyier_id":"","selected_item":"9033269349423299426,4752605905626817542,5172862724621820894,7878766441603271576,6785473900023654609","selected_item_text":"滨州滨城区,滨州中百,滨州学院,滨州五四,滨州职业技术学院","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"7556807878243137592","field_code":"uper_cus","field_name":"","id":"","modify_time":"","modifyier_id":"","selected_item":"8320062286560444570,6590825446466716903,7229839221456283463","selected_item_text":"非直营,上级经销商,直营","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"8705444525531245507","field_code":"exdf_freq_2","field_name":"拜访频率","id":"","modify_time":"","modifyier_id":"","selected_item":"四周1次,一周1次,两周1次,三周1次","selected_item_text":"四周1次,一周1次,两周1次,三周1次","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"4644981436119751330","field_code":"exdf_255526","field_name":"订单流向","id":"","modify_time":"","modifyier_id":"","selected_item":"ECC,SFA","selected_item_text":"ECC,SFA","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"5533730061059534300","field_code":"exdf_292834","field_name":"关店时间","id":"","modify_time":"","modifyier_id":"","selected_item":"8:00","selected_item_text":"8:00","status":"1","strategy_id":"","table_name":""},{"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","cus_field_id":"8308936325666272782","field_code":"exdf_400709","field_name":"开店时间","id":"","modify_time":"","modifyier_id":"","selected_item":"00:30","selected_item_text":"00:30","status":"1","strategy_id":"","table_name":""}],"basPdPriceStrategyCuss":[],"basPdPriceStrategyProducts":[],"basPdPriceStrategySameCodes":[{"base_unit":"","create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","id":"","input_unit":"7168931699463297142","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","price_down":"1.00000000","price_strategy_same_code_id":"5514868421869174073","price_up":"1.00000000","sale_price":"11.00000000","same_price_code":"aaa","sequ":"","status":"1","strategy_id":""},{"base_unit":"","create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","id":"","input_unit":"6809111616638730975","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","price_down":"2.00000000","price_strategy_same_code_id":"4680555118409114561","price_up":"2.00000000","sale_price":"22.00000000","same_price_code":"222","sequ":"","status":"1","strategy_id":""}],"create_time":"2018-08-21 15:33:03","creator_id":"4993053750015187044","end_time":"2023-08-25 00:00:00","id":"","is_enable":"1","modify_time":"","modifyier_id":"","price_strategy_id":"5061081673542762162","prod_num":"","product_type":"2","start_time":"2018-08-21 00:00:00","status":"1","title":"sszTest","trade_range":"1","trade_type":"2"
},
{"basPdPriceStrategyCusFields":[{"create_time":"","creator_id":"","cus_field_id":"","field_code":"","field_name":"","id":"","modify_time":"","modifyier_id":"","selected_item":"","selected_item_text":"","status":"","strategy_id":"","table_name":""}],"basPdPriceStrategyCuss":[{"cm_code":"","cm_id":"7367170304595826780","cm_name":"","create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","id":"","modify_time":"","modifyier_id":"","price_strategy_cus_id":"7272170345546063163","status":"1"},{"cm_code":"","cm_id":"4803878215375374955","cm_name":"","create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","id":"","modify_time":"","modifyier_id":"","price_strategy_cus_id":"5585185858935651346","status":"1"}],"basPdPriceStrategyProducts":[{"base_unit":"8851908411956994717","create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","id":"","input_unit":"8851908411956994717","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"1","pd_id":"6831390366898028953","pd_name":"1221","price_down":"","price_strategy_product_id":"7089295218249730501","price_up":"","sale_price":"11.00000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"2","create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","id":"","input_unit":"2","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"test2","pd_id":"6692513571119135748","pd_name":"测试商品2","price_down":"","price_strategy_product_id":"4915058707947250935","price_up":"","sale_price":"888.80000000","sequ":"","status":"1","strategy_id":""},{"base_unit":"6076877019412887312","create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","id":"","input_unit":"7564562801574625666","max_base_unit_num":"0.00000000","max_num":"0.00000000","min_base_unit_num":"0.00000000","min_num":"0.00000000","modify_time":"","modifyier_id":"","pd_code":"10005","pd_id":"4892238857644646947","pd_name":"红牛2","price_down":"","price_strategy_product_id":"4906508095312876540","price_up":"","sale_price":"82.00000000","sequ":"","status":"1","strategy_id":""}],"basPdPriceStrategySameCodes":[],"create_time":"2018-08-21 15:38:48","creator_id":"4993053750015187044","end_time":"2022-08-20 00:00:00","id":"","is_enable":"1","modify_time":"","modifyier_id":"","price_strategy_id":"7203823650724655752","prod_num":"3","product_type":"1","start_time":"2018-08-21 00:00:00","status":"1","title":"ssztest222","trade_range":"2","trade_type":"2"
}

]

}

响应信息

参数 类型 必填 说明
msg_id String 消息ID
return_code int 响应编码:0成功 1失败
return_msg String 响应说明
response_data 响应数据体[{......}]
price_strategy_id VARCHAR(32) 规则id
status VARCHAR(1) 0:已删除,1:正常
creator_id VARCHAR(32) 创建人
create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
modifyier_id VARCHAR(32) 修改人
modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
title VARCHAR(200) 标题
start_time TIMESTAMP 有效期开始时间,格式:“yyyy-MM-dd HH:mm:ss”
end_time TIMESTAMP 有效期结束时间,格式:“yyyy-MM-dd HH:mm:ss”
trade_type VARCHAR(2) 销售对象:1、客户,2、经销商,3、门店
trade_range VARCHAR(2) 销售范围:1、指定客户范围 2、指定具体客户
is_enable VARCHAR(2) 是否可用
product_type VARCHAR(2) 1:按商品,2:按同价码
basPdPriceStrategyCusFields(按范围设置)
basPdPriceStrategyCusFields.cus_field_id VARCHAR(32) id
basPdPriceStrategyCusFields.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyCusFields.creator_id VARCHAR(32) 创建人
basPdPriceStrategyCusFields.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCusFields.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyCusFields.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCusFields.field_code VARCHAR(200) 范围类型编码
basPdPriceStrategyCusFields.field_name VARCHAR(200) 范围类型编码名称
basPdPriceStrategyCusFields.selected_item text 选择的范围类型对应的id(外勤365id)
basPdPriceStrategyCusFields.selected_code text 选择的范围类型对应的code(外勤365code)
basPdPriceStrategyCusFields.selected_item_text text 选择的范围类型对应的名称
basPdPriceStrategyProducts(按商品设置)
basPdPriceStrategyProducts.price_strategy_product_id VARCHAR(32) id
basPdPriceStrategyProducts.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyProducts.creator_id VARCHAR(32) 创建人
basPdPriceStrategyProducts.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyProducts.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyProducts.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyProducts.pd_id VARCHAR(32) 商品id
basPdPriceStrategyProducts.pd_code VARCHAR(100) 商品code
basPdPriceStrategyProducts.pd_name VARCHAR(256) 商品name
basPdPriceStrategyProducts.input_unit VARCHAR(32) 录入单位id
basPdPriceStrategyProducts.input_unit_name VARCHAR(100) 录入单位name
basPdPriceStrategyProducts.sale_price numeric(15,8) 销售策略价
basPdPriceStrategyProducts.base_unit VARCHAR(32) 基本单位id
basPdPriceStrategyProducts.base_unit_name VARCHAR(100) 基本单位name
basPdPriceStrategyProducts.min_base_unit_num numeric(28,8) 起订量(录入数量转化成基本单位的数量)
basPdPriceStrategyProducts.min_num numeric(28,8) 起订量
basPdPriceStrategyProducts.max_base_unit_num numeric(28,8) 限订量(录入数量转化成基本单位的数量)
basPdPriceStrategyProducts.max_num numeric(28,8) 限订量
basPdPriceStrategyProducts.price_up numeric(28,8) 策略价上浮动
basPdPriceStrategyProducts.price_down numeric(28,8) 策略价下浮动
basPdPriceStrategySameCodes(按同价码设置)
basPdPriceStrategySameCodes.price_strategy_same_code_id VARCHAR(32) id
basPdPriceStrategySameCodes.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategySameCodes.creator_id VARCHAR(32) 创建人
basPdPriceStrategySameCodes.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategySameCodes.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategySameCodes.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategySameCodes.same_price_code varchar(32) 同价码
basPdPriceStrategySameCodes.input_unit_name VARCHAR(100) 录入单位name
basPdPriceStrategySameCodes.sale_price numeric(28,8) 销售策略价
basPdPriceStrategySameCodes.min_base_unit_num numeric(28,8) 起订量(录入数量转化成基本单位的数量)
basPdPriceStrategySameCodes.min_num numeric(28,8) 起订量
basPdPriceStrategySameCodes.max_base_unit_num numeric(28,8) 限订量(录入数量转化成基本单位的数量)
basPdPriceStrategySameCodes.max_num numeric(28,8) 限订量
basPdPriceStrategySameCodes.price_up numeric(28,8) 策略价上浮动
basPdPriceStrategySameCodes.price_down numeric(28,8) 策略价下浮动
basPdPriceStrategyCuss(按客户设置)
basPdPriceStrategyCuss.price_strategy_cus_id VARCHAR(32) id
basPdPriceStrategyCuss.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyCuss.creator_id VARCHAR(32) 创建人
basPdPriceStrategyCuss.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCuss.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyCuss.modify_time VARCHAR(32) 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCuss.cm_id VARCHAR(32) 客户id
basPdPriceStrategyCuss.cm_code VARCHAR(32) 客户code
basPdPriceStrategyCuss.cm_name VARCHAR(100) 客户name

新增修改价格策略接口

请求方式:** POST(HTTPS
请求地址: https://openapi.waiqin365.com/api/product/v1/addOrModifyPriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求包体:


{
	"title": "测试1111111",
	"start_date": "2019-03-18",
	"end_date": "2019-03-31",
	"channel_type": "3",
	"cm_code": "KH1Q1019576A",
	"client_range": "2",
	"product_type": "2",
	"source_code": "aaassss",
	"operate_type": "1",
	"dept_id": "5027924547848612557,7243837410903640238",
	"gradation_code": "KH1Q1008146A",
	"kasys_name": "家乐福",
	"exts": [{
		"cm_ext_key": "需要配送",
		"cm_ext_value": "是"
	}],
	"products": [{
		"code": "10002",
		"price_code": "B111",
		"unit_name": "箱",
		"price": "100",
		"price_up": "120"
	}]
}

请求信息

参数 类型 必填 说明
title VARCHAR(100) 价格方案名称
start_date VARCHAR(32) 开始日期 格式必须是yyyy-MM-dd
end_date VARCHAR(32) 结束日期 格式必须是yyyy-MM-dd
channel_type VARCHAR(32) 销售对象 1标准客户 2 经销商 3 终端门店
client_range VARCHAR(32) 客户范围 1 按客户属性设置范围 2 指定具体客户
product_type VARCHAR(32) 商品范围 1 商品 2 同价码
source_code VARCHAR(100) 价格方案第三方系统的唯一标识 source_code price_id 传一个
price_id VARCHAR(32) 价格方案id source_code price_id 传一个
dept_id VARCHAR(32) 部门id 多个逗号分隔
dept_name VARCHAR(100) 部门名称 多个逗号分隔
dept_code VARCHAR(100) 部门编码 多个逗号分隔
dept_source_code VARCHAR(100) 部门第三方系统的唯一标识 多个逗号分隔
customer_level_id VARCHAR(32) 客户级别id 多个逗号分隔
customer_level_source_code VARCHAR(100) 客户级别第三方系统的唯一标识 多个逗号分隔
customer_level_name VARCHAR(100) 客户级别名称 多个逗号分隔
district_level_id VARCHAR(32) 销售区域级别id 多个逗号分隔
district_level_code VARCHAR(100) 销售区域级别编码 多个逗号分隔
district_level_name VARCHAR(100) 销售区域级别名称 多个逗号分隔
type_id VARCHAR(32) 类型id 多个逗号分隔
type_code VARCHAR(100) 类型编码 多个逗号分隔
type_name VARCHAR(100) 类型名称 多个逗号分隔
type_source_code VARCHAR(100) 类型第三方系统的唯一标识 多个逗号分隔
district_id VARCHAR(32) 销售区域id 多个逗号分隔
district_code VARCHAR(100) 销售区域编码 多个逗号分隔
district_name VARCHAR(100) 销售区域名称 多个逗号分隔
district_source_code VARCHAR(100) 销售区域第三方系统的唯一标识 多个逗号分隔
uperCus_id VARCHAR(32) 上级客户id 多个逗号分隔
uperCus_code VARCHAR(100) 上级客户编码 多个逗号分隔
uperCus_source_code VARCHAR(100) 上级客户第三方系统的唯一标识 多个逗号分隔
uperCus_name VARCHAR(100) 上级客户名称 多个逗号分隔
kasys_id VARCHAR(32) ka系统id 多个逗号分隔
kasys_name VARCHAR(100) ka系统名称 多个逗号分隔
dealer_id VARCHAR(32) 经销商id 多个逗号分隔
dealer_code VARCHAR(100) 经销商编码 多个逗号分隔
dealer_name VARCHAR(100) 经销商名称 多个逗号分隔
dealer_source_code VARCHAR(100) 经销商第三方系统的唯一标识 多个逗号分隔
gradation_id VARCHAR(32) 客户层次id 多个逗号分隔
gradation_code VARCHAR(100) 客户层次编码 多个逗号分隔
gradation_name VARCHAR(100) 客户层次名称 多个逗号分隔
cm_id VARCHAR(2000) 经销商或客户id 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_code VARCHAR(4000) 经销商或客户编码 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_name VARCHAR(4000) 经销商或客户名称 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_source_code VARCHAR(4000) 经销商或客户第三方系统的唯一标识 多个逗号分隔 client_range 为2 cm_id cm_codecm_namecm_source_code必传一个
exts
exts[].cm_ext_key VARCHAR(100) 客户信息扩展字段key值,客户信息扩展字段需先在外勤365系统客户管理中创建自定义字段。
exts[].cm_ext_value VARCHAR(4000) 客户信息扩展字段value值对多个选项值,以“,”分隔拼接。
products
products[].id VARCHAR(32) 商品id id code source_code 传一个
products[].code VARCHAR(100) 商品编码 id code source_code传一个
products[].source_code VARCHAR(100) 商品第三方系统的唯一标识 id code source_code 传一个
products[].unit_id VARCHAR(32) 单位id unit_id unit_name传一个
products[].unit_name VARCHAR(100) 单位名称 unit_id unit_name传一个
products[].price VARCHAR(32) 价格
products[].price_up VARCHAR(32) 价格上浮动 整数位不大于7位
products[].price_down VARCHAR(32) 价格下浮动 整数位不大于7位
products[].price_code VARCHAR(32) 同价码 product_type为2 必传
ownerDeptId VARCHAR(32) 所属部门id ownerDeptId ownerDeptName ownerDeptCode ownerDeptSourceCode 必传一个
ownerDeptName VARCHAR(100) 所属部门名称 ownerDeptId ownerDeptName ownerDeptCode ownerDeptSourceCode 必传一个
ownerDeptCode VARCHAR(100) 所属部门编码 ownerDeptId ownerDeptName ownerDeptCode ownerDeptSourceCode 必传一个
ownerDeptSourceCode VARCHAR(100) 所属部门第三方系统的唯一标识 ownerDeptId ownerDeptName ownerDeptCode ownerDeptSourceCode 必传一个

返回结果:

{
    "msg_id": "PRD00001",
    "return_code": "1",
    "return_msg": "新增成功!"
}

异常结果:

{
    "msg_id": "PRD00001",
    "return_code": "0",
    "return_msg": "客户不存在!"
}

响应信息

参数 类型 必填 说明
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明

删除价格策略接口

请求方式: POST(HTTPS
请求地址: https://openapi.waiqin365.com/api/product/v1/removePriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求包体:

{
    "price_id":"565656565",
}

请求信息

参数 类型 必填 说明
price_id VARCHAR(32) 价格方案id price_id source_code 传一个
source_code VARCHAR(100) 价格方案第三方系统的唯一标识 price_id source_code 传一个

返回结果:

{
    "msg_id": "PRD00001",
    "return_code":"0",
    "return_msg":"删除成功!"
}

异常结果:

{
    "msg_id": "PRD00001",
    "return_code": "1",
    "return_msg": "删除失败,价格方案不存在!"
}

响应信息

参数 类型 必填 说明
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明