sales.getList 查询销售单信息(根据销售单创建时间)

详细描述

按分页及时间范围查询销售单详细信息

应用级参数

参数名称 是否必要 类型 示列值 描述
start_time date 2012-12-08 18:50:30 开始时间(销售单创建时间),例如2012-12-08 18:50:30
end_time date 2012-12-08 18:50:30 结束时间(同上)
page_no number 1 页码,默认1 第一页
page_size number 100 每页数量,最大100
shop_bn string aaa#bbb#ccc shop_bn(*支持多个)

返回结果

注意: 已经做过特殊字符处理的字段如下: shop_code,shop_name,order_no, member_name, sale_no, pay_method, order_check_op, logi_name, logi_no, branch_name, branch_bn, delivery_no, consignee, consignee_addr, consignee_zip, consignee_tel, consignee_mobile, consignee_email, name, spec_name, item_type

XML数据,例:

成功

<response>
    <count>6337</count>
    <lists>
        <shop_code><![CDATA[shopex]]></shop_code>
        <shop_name><![CDATA[shopex]]></shop_name>
        <order_no>194276753441633</order_no>
        <member_name><![CDATA[danny]]></member_name>
        <sale_no><![CDATA[S20121219000001]]></sale_no>
        <pay_method><![CDATA[支付宝]]></pay_method>
        <sale_time>2012-12-08 18:50:30</sale_time>
        <order_create_time>2012-12-08 18:50:30</order_create_time>
        <pay_time>2012-12-08 18:50:30</pay_time>
        <ship_time>2012-12-08 18:50:30</ship_time>
        <order_check_op><![CDATA[admin]]></order_check_op>
        <order_check_time>2012-12-08 18:50:30</order_check_time>
        <goods_amount>163.000</goods_amount>
        <freight_amount>0.000</freight_amount>
        <additional_amount>0.000</additional_amount>
        <has_tax><![CDATA[否]]></has_tax>
        <pmt_amount>0.000</pmt_amount>
        <sale_amount>163.000</sale_amount>
        <logi_name><![CDATA[圆通速递]]></logi_name>
        <logi_no>7104892994</logi_no>
        <branch_name><![CDATA[上海仓]]></branch_name>
        <delivery_no>1211101100004</delivery_no>
        <consignee><![CDATA[danny]]></consignee>
        <consignee_area><![CDATA[上海-上海市-徐汇区]]></consignee_area>
        <consignee_addr><![CDATA[上海上海市徐汇区桂林路396号]]></consignee_addr>
        <consignee_zip>200233</consignee_zip>
        <consignee_tel><![CDATA[]]></consignee_tel>
        <consignee_mobile><![CDATA[021-51086858]]></consignee_mobile>
        <consignee_email><![CDATA[]]></consignee_email>
        <sale_items>
            <bn><![CDATA[JCWL0002]]></bn>
            <name><![CDATA[基础物料名称二]]></name>
            <spec_name><![CDATA[WLGG0002]]></spec_name>
            <barcode><![CDATA[TMWL0002]]></barcode>
            <price>195.000</price>
            <nums>4</nums>
            <pmt_price>0.000</pmt_price>
            <sale_price>780.000</sale_price>
            <apportion_pmt>78.500</apportion_pmt>
            <sales_amount>701.500</sales_amount>
            <item_type><![CDATA[product]]></item_type>
            <type_name><![CDATA[普通]]></type_name>
            <sales_material_bn><![CDATA[XSWL0002]]></sales_material_bn>
            <sales_material_name><![CDATA[销售物料名称二]]></sales_material_name>
            <bn><![CDATA[jcwl0001]]></bn>
            <name><![CDATA[基础物料名称一]]></name>
            <spec_name><![CDATA[]]></spec_name>
            <barcode><![CDATA[TMWL0001]]></barcode>
            <price>87.500</price>
            <nums>4</nums>
            <pmt_price>0</pmt_price>
            <sale_price>350.000</sale_price>
            <apportion_pmt>35.22</apportion_pmt>
            <sales_amount>350.000</sales_amount>
            <item_type><![CDATA[pkg]]></item_type>
            <type_name><![CDATA[促销]]></type_name>
            <sales_material_bn><![CDATA[WLPKG0001]]></sales_material_bn>
            <sales_material_name><![CDATA[促销型销售物料名称一]]></sales_material_name>
            <bn><![CDATA[JCWL0002]]></bn>
            <name><![CDATA[基础物料名称二]]></name>
            <spec_name><![CDATA[]]></spec_name>
            <barcode><![CDATA[TMWL0002]]></barcode>
            <price>75.000</price>
            <nums>6</nums>
            <pmt_price>0</pmt_price>
            <sale_price>450.000</sale_price>
            <apportion_pmt>45.28</apportion_pmt>
            <sales_amount>450.000</sales_amount>
            <item_type><![CDATA[pkg]]></item_type>
            <type_name><![CDATA[促销]]></type_name>
            <sales_material_bn><![CDATA[WLPKG0001]]></sales_material_bn>
            <sales_material_name><![CDATA[促销型销售物料名称一]]></sales_material_name>
        </sale_items>
    </lists>
</response>
json数据,例:

成功

{"response":{
    "count":"6337",
    "lists":{
        "1355932064461265":{
            "shop_code":"shopex",
            "shop_name":"shopex",
            "order_no":"194276753441633",
            "member_name":"danny",
            "sale_no":"S20121219000001",
            "pay_method":"\u652f\u4ed8\u5b9d\uff08\u793a\u8303\uff09",
            "sale_time":"2012-12-08 18:50:30",
            "order_create_time":"2012-12-08 18:50:30",
            "pay_time":"2012-12-08 18:50:30",
            "ship_time":"2012-12-08 18:50:30",
            "order_check_op":"admin",
            "order_check_time":"2012-12-08 18:50:30",
            "goods_amount":"163.000",
            "freight_amount":"0.000",
            "additional_amount":"0.000",
            "has_tax":"\u5426",
            "pmt_amount":"0.000",
            "sale_amount":"163.000",
            "logi_name":"\u5706\u901a\u901f\u9012",
            "logi_no":"7104892994",
            "branch_name":"\u5c0f\u732a\u73ed\u7eb3",
            "delivery_no":"1211101100004",
            "consignee":"\u97e9\u7389\u5143",
            "consignee_area":"\u6e56\u5317-\u8346\u5dde\u5e02-\u6c99\u5e02\u533a",
            "consignee_addr":"\u6e56\u5317\u7701 \u8346\u5dde\u5e02 \u6c99\u5e02\u533a \u6e56\u5317\u7701\u8346\u5dde\u5e02\u6c99\u5e02\u533a",
            "consignee_zip":"200233",
            "consignee_tel":"51086858",
            "consignee_mobile":"",
            "consignee_email":"",
            "sale_items":{
                "1":{
                    "bn":"JCWL0002",
                    "name":"基础物料名称二",
                    "spec_name":"WLGG0002",
                    "barcode":"TMWL0002",
                    "price":"195.000",
                    "nums":"4",
                    "pmt_price":"0.000",
                    "sale_price":"780.000",
                    "apportion_pmt":"78.500",
                    "sales_amount":"701.500",
                    "item_type":"product",
                    "type_name":"普通",
                    "sales_material_bn":"XSWL0002",
                    "sales_material_name":"销售物料名称二"
                },
                "2":{
                    "bn":"jcwl0001",
                    "name":"基础物料名称一",
                    "spec_name":"",
                    "barcode":"TMWL0001",
                    "price":"87.500",
                    "nums":"4",
                    "pmt_price":0,
                    "sale_price":"350.000",
                    "apportion_pmt":35.22,
                    "sales_amount":"350.000",
                    "item_type":"pkg",
                    "type_name":"促销",
                    "sales_material_bn":"WLPKG0001",
                    "sales_material_name":"促销型销售物料名称一"
                },
                "3":{
                    "bn":"JCWL0002",
                    "name":"基础物料名称二",
                    "spec_name":"",
                    "barcode":"TMWL0002",
                    "price":"75.000",
                    "nums":"6",
                    "pmt_price":0,
                    "sale_price":"450.000",
                    "apportion_pmt":45.28,
                    "sales_amount":"450.000",
                    "item_type":"pkg",
                    "type_name":"促销",
                    "sales_material_bn":"WLPKG0001",
                    "sales_material_name":"促销型销售物料名称一"
                },
            }
        }
    }
}}

失败

{"error_response":{
    "code":"e000001",
    "msg":"system params lost or error",
    "sub_msg":""
}}

沪ICP备05002918号

© 2003-2017 ShopEx,Inc.All rights reserved.