文档
测试

20-报表导出（需要修改）

websocket测试
POST
http://localhost:7003/api/report/finance/organizationSalesList

请求头

参数名
类型
描述
必填
sso-token
string
示例：eyJpdiI6IlpsS3dySURmbjBiTG5Cb1wvcmVqWW9nPT0iLCJ2YWx1ZSI6IlM2Y1R0TUNRRVdoQ3VsNUVCUVI1S25SR2dSaGlSY1Q5RFRCTjB6YXRTWVZjamwrYXVIYVZHc2FsUXJkSml4V3dVVmptNnRsdktlVGNUZWdLbVlkWWJjYkVZWUg5OVNzYlA2a1FkNmlOREZIeFFlcWZxbHRtcFlzK1UybmxlUmp1b0hQSmlcL1BidFE3cUlOZm5CQnVYblVKZU1uUHU0S3Z4a0s1R3IzODBMbDUrREU3bVwvaVhnMFI5RDBGcitYXC9EdUc2TXVEYzhJalVCN2lGQkdreityR1FDYjIrT3ZwQlQ4cnkzbFVOc1oydGExYzVLSHRMeGlRNXNNclowSnowTmpuTGZYdGFQU3ZNTW1MVmgrUGNmRlREYmxhaUtROXoxS1ZZWGEwdHFkRlBLekFqNXY1RkcrRmlFNE1Uc2dnQjJqVnVsXC8rWWc3SDZab1pIalBiK0Uzem4rK2R5R096QnM3MVR6VHJGSHkreDZDOEgrVytRZUl3Z3BiclhUbUY1ZksxUGZVaU9xM3VwUW9TYzZcLzNPbjQzTk11WkVtdFJzeTBSb2s5cDJBbE5Nc0ZxdFhVeG9lelV6QVBuUDNYZThEQVZlT3FBM0tFTHNUVWl6Y3FaNFwvdUNUQVRoRmVSdzMxdUd0bWdtQnlISnRPeFAzM2tFZVhsYXJRb2QySkFLdmlqRGpCRkl5SWpjWHd4RXg2WTF0YkRXdndveFRZbDErbEpET2hyTzRXMDJhVDNFd3V2OUFMY0JcL3gxdUJDRzBzXC9PIiwibWFjIjoiZTU0YWE0ZWUxNzYyN2YxZDMxOTQ0ZmQ3MmM5ODVjY2VlODdmZjc3NGU5NjBmMDk0MTJhMzAxYWM3MzFhNjJiNyJ9
必填

请求参数

参数名
类型
描述
必填
Month[]
string
示例：2020-12
必填

响应参数

参数名
类型
描述
必填
code
int
示例：0
必填
data
array
数据列表
必填
ContainerId
int
示例：159932
必填
Shipper
string
示例：佛山大沥高伟江
必填
TransportWay
string
示例：多式联运
必填
TransportComposition
string
示例：装货拖车+海运+送货拖车
必填
TotalAmount
string
示例：160.000
必填
AlreadyCavMoney
string
示例：0.000
必填
CavTime
object
示例：null
必填
NoRelasion
int
示例：0
必填
CostId
int
示例：667706
必填
PlannedLoadingDate
string
示例：2020-11-02 08:00:00
必填
AccreditId
int
示例：8001005224
必填
BusinessCompany
string
示例：佛山航力船务有限公司
必填
OperateCompany
string
示例：客服销售一部
必填
groupByString
string
示例：佛山航力船务有限公司多式联运佛山大沥高伟江
必填
ID
string
示例：667706/PayCostId/Order/67330
必填
Receivable
int
示例：1
必填
ReceivableSum
string
示例：14,600.000
必填
CavMoneyReceivableSum
string
示例：0.000
必填
PaySum
string
示例：12133.000
必填
LastReceivableSum
string
示例：44400.000
必填
LastPaySum
string
示例：38141.200
必填
LastCavMoneyReceivableSum
string
示例：0.000
必填
li
int
示例：1
必填
Profit
string
示例：2,467.000
必填
LastProfit
float
示例：6258.800000000003
必填
ReceivableRate
string
示例：-67.12%
必填
ProfitRate
string
示例：-60.58%
必填
ReceivableRemainder
string
示例：14,600.000
必填
ContainerCount
string
示例：4
必填
LastContainerCount
int
示例：12
必填
ContainerCountRate
string
示例：-66.67%
必填
Manager
string
示例：区启伟,吕国行,吴卓凤,陈玩萍
必填
statistics
object
数据字典
必填
ReceivableSum
string
示例：12,498,167.780
必填
CavMoneyReceivableSum
string
示例：30633.600
必填
PaySum
string
示例：14523713.910
必填
count
int
示例：384
必填
Profit
string
示例：-2,025,546.130
必填
ReceivableRemainder
string
示例：12,467,534.180
必填
ContainerCount
string
示例：52.000
必填
startCount
int
示例：1
必填
endCount
int
示例：10
必填
pageCount
int
示例：39
必填
count
int
示例：384
必填
sso_token
string
示例：eyJpdiI6Ik9tYUJXYkI3alVnb1lRSmJsbEZkWEE9PSIsInZhbHVlIjoiSmppSk41U2NzSWluaVZyc285TEIzRk9tczBtQmhZeTBjSyszV1lZM1E3QWlxVFkxSFNlS054UHgxNGRnZDlGNUI1NXdMRjh2NkNOZjljNUYyc2NmMlM5XC9vcFVcLzFEZlVcL1wvNng5NkRFWHhCT2xEbXhVeHRYZW15RzVFSVQyTGltRVV3MkpNUEFxU2Zaa2NSNDVCektKWTR4bncrcSt4MURvQW9wT0VJVzdCdkJkbERpSWdOWUFkVWpDWUdcLzFVXC9qbTk2eE84T0RjMTYyUjNmY3pTNVRzZjNVd09RaHFXUGFMMUxRQVllVU1Cd0lFb0ZESFNYSVA3Q...
必填

说明 / 示例

{ "code": 0, "data": [ { "ContainerId": 159932, "Shipper": "佛山大沥高伟江", "TransportWay": "多式联运", "TransportComposition": "装货拖车+海运+送货拖车", "TotalAmount": "160.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 667706, "PlannedLoadingDate": "2020-11-02 08:00:00", "AccreditId": 8001005224, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "客服销售一部", "groupByString": "佛山航力船务有限公司多式联运佛山大沥高伟江", "ID": "667706/PayCostId/Order/67330", "Receivable": 1, "ReceivableSum": "14,600.000", "CavMoneyReceivableSum": "0.000", "PaySum": "12133.000", "LastReceivableSum": "44400.000", "LastPaySum": "38141.200", "LastCavMoneyReceivableSum": "0.000", "li": 1, "Profit": "2,467.000", "LastProfit": 6258.800000000003, "ReceivableRate": "-67.12%", "ProfitRate": "-60.58%", "ReceivableRemainder": "14,600.000", "ContainerCount": "4", "LastContainerCount": 12, "ContainerCountRate": "-66.67%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 160801, "Shipper": "佛山市金福板业有限公司", "TransportWay": "多式联运", "TransportComposition": "装货拖车+海运+送货拖车", "TotalAmount": "80.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 674586, "PlannedLoadingDate": "2020-11-01 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司多式联运佛山市金福板业有限公司", "ID": "674586/PayCostId/Order/67893", "Receivable": 1, "ReceivableSum": "295,950.000", "CavMoneyReceivableSum": "0.000", "PaySum": "660.000", "LastReceivableSum": "1190934.250", "LastPaySum": "1036519.000", "LastCavMoneyReceivableSum": "0.000", "li": 2, "Profit": "295,290.000", "LastProfit": 154415.25, "ReceivableRate": "-75.15%", "ProfitRate": "91.23%", "ReceivableRemainder": "295,950.000", "ContainerCount": "33", "LastContainerCount": 218, "ContainerCountRate": "-84.86%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 162079, "Shipper": "佛山市龙熹金属贸易有限公司", "TransportWay": "多式联运", "TransportComposition": "装货拖车+海运+送货拖车", "TotalAmount": "6.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 684619, "PlannedLoadingDate": "2020-11-06 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司多式联运佛山市龙熹金属贸易有限公司", "ID": "684619/PayCostId/Order/68693", "Receivable": 1, "ReceivableSum": "6,600.000", "CavMoneyReceivableSum": "0.000", "PaySum": "6363.000", "LastReceivableSum": "58000.000", "LastPaySum": "55195.000", "LastCavMoneyReceivableSum": "0.000", "li": 3, "Profit": "237.000", "LastProfit": 2805, "ReceivableRate": "-88.62%", "ProfitRate": "-91.55%", "ReceivableRemainder": "6,600.000", "ContainerCount": "2", "LastContainerCount": 16, "ContainerCountRate": "-87.50%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 162154, "Shipper": "佛山市龙钢金属回收有限公司", "TransportWay": "多式联运", "TransportComposition": "装货拖车+海运+送货拖车", "TotalAmount": "30.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 685002, "PlannedLoadingDate": "2020-11-07 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司多式联运佛山市龙钢金属回收有限公司", "ID": "685002/PayCostId/Order/68750", "Receivable": 1, "ReceivableSum": "3,300.000", "CavMoneyReceivableSum": "0.000", "PaySum": "3232.000", "LastReceivableSum": "22300.000", "LastPaySum": "21724.000", "LastCavMoneyReceivableSum": "0.000", "li": 4, "Profit": "68.000", "LastProfit": 576, "ReceivableRate": "-85.20%", "ProfitRate": "-88.19%", "ReceivableRemainder": "3,300.000", "ContainerCount": "1", "LastContainerCount": 7, "ContainerCountRate": "-85.71%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 161284, "Shipper": "上海瞻通物流有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "150.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 678630, "PlannedLoadingDate": "2020-11-01 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输上海瞻通物流有限公司", "ID": "678630/PayCostId/Dispatch/155231", "Receivable": 1, "ReceivableSum": "0.000", "CavMoneyReceivableSum": "0.000", "PaySum": "0.000", "LastReceivableSum": "43398.000", "LastPaySum": "45558.000", "LastCavMoneyReceivableSum": "43,398.000", "li": 5, "Profit": "0.000", "LastProfit": -2160, "ReceivableRate": "-100.00%", "ProfitRate": "-100.00%", "ReceivableRemainder": "0.000", "ContainerCount": "0", "LastContainerCount": 24, "ContainerCountRate": "-100.00%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 163978, "Shipper": "上海闽展建材有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "16.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 698978, "PlannedLoadingDate": "2020-11-10 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输上海闽展建材有限公司", "ID": "698978/PayCostId/Dispatch/159836", "Receivable": 1, "ReceivableSum": "0.000", "CavMoneyReceivableSum": "0.000", "PaySum": "0.000", "LastReceivableSum": "36116.160", "LastPaySum": "37178.000", "LastCavMoneyReceivableSum": "0.000", "li": 6, "Profit": "0.000", "LastProfit": -1061.8399999999965, "ReceivableRate": "-100.00%", "ProfitRate": "-100.00%", "ReceivableRemainder": "0.000", "ContainerCount": "0", "LastContainerCount": 18, "ContainerCountRate": "-100.00%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 165071, "Shipper": "临沂元信货运代理有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "1402.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 660221, "PlannedLoadingDate": "2020-11-10 00:00:00", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输临沂元信货运代理有限公司", "ID": "660221/ReceivableCostId/Order/70680", "Receivable": 2, "ReceivableSum": "8,620.000", "CavMoneyReceivableSum": "0.000", "PaySum": "8820.000", "LastReceivableSum": "19362.000", "LastPaySum": "20932.000", "LastCavMoneyReceivableSum": "0.000", "li": 7, "Profit": "-200.000", "LastProfit": -1570, "ReceivableRate": "-55.48%", "ProfitRate": "-87.26%", "ReceivableRemainder": "8,620.000", "ContainerCount": "6", "LastContainerCount": 17, "ContainerCountRate": "-64.71%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 162144, "Shipper": "临沂立晟货运代理有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "15.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 684994, "PlannedLoadingDate": "2020-11-06 13:54:15", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输临沂立晟货运代理有限公司", "ID": "684994/PayCostId/Dispatch/156647", "Receivable": 1, "ReceivableSum": "0.000", "CavMoneyReceivableSum": "0.000", "PaySum": "0.000", "LastReceivableSum": "2824.000", "LastPaySum": "3004.000", "LastCavMoneyReceivableSum": "2,824.000", "li": 8, "Profit": "0.000", "LastProfit": -180, "ReceivableRate": "-100.00%", "ProfitRate": "-100.00%", "ReceivableRemainder": "0.000", "ContainerCount": "0", "LastContainerCount": 2, "ContainerCountRate": "-100.00%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 160593, "Shipper": "佛山市万海货运代理有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "64.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 673097, "PlannedLoadingDate": "2020-11-01 17:01:15", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输佛山市万海货运代理有限公司", "ID": "673097/PayCostId/Dispatch/154226", "Receivable": 1, "ReceivableSum": "9,502.000", "CavMoneyReceivableSum": "0.000", "PaySum": "9502.000", "LastReceivableSum": "63034.000", "LastPaySum": "64104.000", "LastCavMoneyReceivableSum": "0.000", "li": 9, "Profit": "0.000", "LastProfit": -1070, "ReceivableRate": "-84.93%", "ProfitRate": "-100.00%", "ReceivableRemainder": "9,502.000", "ContainerCount": "6", "LastContainerCount": 38, "ContainerCountRate": "-84.21%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" }, { "ContainerId": 165750, "Shipper": "佛山市万程物流有限公司", "TransportWay": "海上运输", "TransportComposition": "海运", "TotalAmount": "15.000", "AlreadyCavMoney": "0.000", "CavTime": null, "NoRelasion": 0, "CostId": 711514, "PlannedLoadingDate": "2020-11-18 15:32:21", "AccreditId": 8001000200, "BusinessCompany": "佛山航力船务有限公司", "OperateCompany": "佛山航力船务有限公司", "groupByString": "佛山航力船务有限公司海上运输佛山市万程物流有限公司", "ID": "711514/PayCostId/Dispatch/162557", "Receivable": 1, "ReceivableSum": "0.000", "CavMoneyReceivableSum": "0.000", "PaySum": "0.000", "LastReceivableSum": "7310.000", "LastPaySum": "7500.000", "LastCavMoneyReceivableSum": "1,410.000", "li": 10, "Profit": "0.000", "LastProfit": -190, "ReceivableRate": "-100.00%", "ProfitRate": "-100.00%", "ReceivableRemainder": "0.000", "ContainerCount": "0", "LastContainerCount": 4, "ContainerCountRate": "-100.00%", "Manager": "区启伟,吕国行,吴卓凤,陈玩萍" } ], "statistics": { "ReceivableSum": "12,498,167.780", "CavMoneyReceivableSum": "30633.600", "PaySum": "14523713.910", "count": 384, "Profit": "-2,025,546.130", "ReceivableRemainder": "12,467,534.180", "ContainerCount": "52.000" }, "startCount": 1, "endCount": 10, "pageCount": 39, "count": 384, "sso_token": "eyJpdiI6Ik9tYUJXYkI3alVnb1lRSmJsbEZkWEE9PSIsInZhbHVlIjoiSmppSk41U2NzSWluaVZyc285TEIzRk9tczBtQmhZeTBjSyszV1lZM1E3QWlxVFkxSFNlS054UHgxNGRnZDlGNUI1NXdMRjh2NkNOZjljNUYyc2NmMlM5XC9vcFVcLzFEZlVcL1wvNng5NkRFWHhCT2xEbXhVeHRYZW15RzVFSVQyTGltRVV3MkpNUEFxU2Zaa2NSNDVCektKWTR4bncrcSt4MURvQW9wT0VJVzdCdkJkbERpSWdOWUFkVWpDWUdcLzFVXC9qbTk2eE84T0RjMTYyUjNmY3pTNVRzZjNVd09RaHFXUGFMMUxRQVllVU1Cd0lFb0ZESFNYSVA3QnBYVkZabmtcL2lnK3RlSEs0bmZONTlKNE9zVlB3VWtJYWtabVFtckJNdHpHb1dqclFBdjllOUh3eUcwRE42XC90K0srbmpoeFU1a2t2VTAxbDRPXC9MU29hUTNjSEcwRDBtRmV3c3RySmVxVHJndHZVMTBUTTJRUTRxVzd5QW94eGVuanRuTkVMYVNTQ2g4bjVsYXB3bUdhOGV4TERDZmh3cUkxWUE0c2Jhc1ljQ0N4XC9OYUVLcjExYWFNb2NTVzhFam9QM1hNSFc2TnAycXBxZFNMK0xyakJ3ejArS2w4VXRCZVwvNlpMTTIwNHNqT2RXaUZDbDBsZVdNUmNpYUViMVhaOEVZNEJ3TmRhbjMrbTVFSGJ5UytRMnd2TXd0b3JtUkpnenZINlRPY0RqSU5EWTRxTDdFSHFMUjZsSkMwTjY5OEF0MTVnUjAxWVYiLCJtYWMiOiI2ZTBhNmUyZjQxNmU1MzZlNDRjZGQ0ZDBiYTI0ZjgyYWU2MDMyNGRiMzc3NzYzOTJhZWY4YmNhNWIzZjNjMjVjIn0=" }
上一篇 20-报表导出（需要修改）
上一篇
本文档使用易文档编写, 更新时间: 2021-01-14 15:19