1、根据需求进行数据表的设计。
数据库名 | e6yun3_tms_customized | 数据库表名(代理盈利信息) | agent_profit_info | |
---|---|---|---|---|
字段名 | 类型 | 是否为空 | 默认值 | 描述 |
created_user_id | int(11) | not null | 0 | 创建人 |
created_time | datetime | not null | CURRENT_TIMESTAMP | 创建时间/生成时间 |
modified_user_id | int(11) | not null | 0 | 修改人 |
modified_time | datetime | not null | CURRENT_TIMESTAMP | 修改时间 |
waybill_no | varchar(64) | not null | 0 | 运单单号 |
order_no | varchar(64) | not null | 0 | 关联订单单号 |
customer_name | varchar(64) | not null | 客户名称 | |
pay_person | varchar(64) | not null | 结算方 | |
corp_id | int(11) | not null | 公司id | |
valid | tinyint(1) | not null | 1 | 是否可用 |
id | varchar(18) | not null | 主键递增 | |
ticket_person | varchar(18) | not null | 开票方 | |
carrier | varchar(18) | not null | 承运商 | |
cost_status | varchar(18) | not null | 费用状态 | |
waybill_status | varchar(18) | not null | 运单状态 | |
gross_margin | decimal(18,6) | not null | 0.000000 | 毛利 |
receive_freight | decimal(18,6) | not null | 0.000000 | 应收运费 |
receive_premium | decimal(18,6) | not null | 0.000000 | 应收保险费 |
receive_extrude_fee | decimal(18,6) | not null | 0.000000 | 应收压车费 |
receive_loader_fee | decimal(18,6) | not null | 0.000000 | 应收装卸费 |
receive_damage_fee | decimal(18,6) | not null | 0.000000 | 应收货损费 |
receive_overload_fee | decimal(18,6) | not null | 0.000000 | 应收超重费 |
receive_excrete_fee | decimal(18,6) | not null | 0.000000 | 应收拆单费 |
receive_message_fee | decimal(18,6) | not null | 0.000000 | 应收信息费 |
receive_express_fee | decimal(18,6) | not null | 0.000000 | 应收快递费 |
receive_delivery_fee | decimal(18,6) | not null | 0.000000 | 应收提货送货费 |
receive_pound_fee | decimal(18,6) | not null | 0.000000 | 应收磅费 |
receive_receipt_fee | decimal(18,6) | not null | 0.000000 | 应收办单费 |
receive_debit_fee | decimal(18,6) | not null | 0.000000 | 应收违约金 |
receive_damaged_goods_fee | decimal(18,6) | not null | 0.000000 | 应收货损品回收费 |
receive_tally_fee | decimal(18,6) | not null | 0.000000 | 应收现场理货费 |
receive_run_fee | decimal(18,6) | not null | 0.000000 | 应收跑空费 |
receive_material_handling_fee | decimal(18,6) | not null | 0.000000 | 应收装卸材料费 |
receive_fall_fee | decimal(18,6) | not null | 0.000000 | 应收倒运费 |
receive_reinforce_fee | decimal(18,6) | not null | 0.000000 | 应收加固费 |
handle_waybill_fee | decimal(18,6) | not null | 0.000000 | 应付运费 |
handle_waybill_account | varchar(256) | not null | 应付运费费结算对象 | |
handle_premium_fee | decimal(18,6) | not null | 0.000000 | 应付保险费 |
handle_premium_account | varchar(256) | not null | 人保 | 应付保险费结算对象 |
handle_service_fee | decimal(18,6) | not null | 0.000000 | 应付业务开发费 |
handle_service_account | varchar(256) | not null | 阮初强 | 应付业务开发费结算对象 |
handle_care_fee | decimal(18,6) | not null | 0.000000 | 应付关爱基金 |
handle_care_account | varchar(256) | not null | 阮初强 | 应付关爱基金结算对象 |
handle_operation_fee | decimal(18,6) | not null | 0.000000 | 应付操作费 |
handle_opertion_account | varchar(256) | not null | 阮初强 | 应付操作费结算对象 |
handle_tallying_fee | decimal(18,6) | not null | 0.000000 | 应付理货基金 |
handle_tallying_account | varchar(256) | not null | 阮初强 | 应付理货基金结算对象 |
handle_loader_fee | decimal(18,6) | not null | 0.000000 | 应付装卸费 |
handle_loader_account | varchar(256) | not null | 应付装卸费结算对象 | |
handle_damage_fee | decimal(18,6) | not null | 0.000000 | 应付货损费 |
handle_damage_account | varchar(256) | not null | 应付货损费结算对象 | |
handle_overload_fee | decimal(18,6) | not null | 0.000000 | 应付超重费 |
handle_overload_account | varchar(256) | not null | 应付超重费结算对象 | |
handle_excrete_fee | decimal(18,6) | not null | 0.000000 | 应付拆单费 |
handle_excrete_account | varchar(256) | not null | 应付拆单费结算对象 | |
handle_extrude_fee | decimal(18,6) | not null | 0.000000 | 应付压车费 |
handle_extrude_account | varchar(256) | not null | 应付压车费结算对象 | |
handle_message_fee | decimal(18,6) | not null | 0.000000 | 应付信息费 |
handle_message_account | varchar(256) | not null | 应付信息费结算对象 | |
handle_express_fee | decimal(18,6) | not null | 0.000000 | 应付快递费 |
handle_express_account | varchar(256) | not null | 应付快递费结算对象 | |
handle_delivery_fee | decimal(18,6) | not null | 0.000000 | 应付提货送货费 |
handle_delivery_account | varchar(256) | not null | 应付提货送货结算对象 | |
handle_pound_fee | decimal(18,6) | not null | 0.000000 | 应付磅费 |
handle_pound_account | varchar(256) | not null | 应付磅费结算对象 | |
handle_store_fee | decimal(18,6) | not null | 0.000000 | 应付仓库接洽费 |
handle_store_account | varchar(256) | not null | 应付仓库接洽费结算对象 | |
handle_receipt_fee | decimal(18,6) | not null | 0.000000 | 应付办单费 |
handle_receipt_account | varchar(256) | not null | 应付办单费结算对象 | |
handle_debit_fee | decimal(18,6) | not null | 0.000000 | 应付违约金 |
handle_debit_account | varchar(256) | not null | 应付违约金结算对象 | |
handle_amendment_fee | decimal(18,6) | not null | 0.000000 | 应付改单费 |
handle_amendment_account | varchar(256) | not null | 应付改单费结算对象 | |
handle_reception_fee | decimal(18,6) | not null | 0.000000 | 应付业务接待费 |
handle_reception_account | varchar(256) | not null | 应付业务接待费结算对象 | |
handle_tally_fee | decimal(18,6) | not null | 0.000000 | 应付现场理货费 |
handle_tally_account | varchar(256) | not null | 应付现场理货费结算对象 | |
handle_run_fee | decimal(18,6) | not null | 0.000000 | 应付跑空费 |
handle_run_account | varchar(256) | not null | 应付跑空费结算对象 | |
handle_material_handling_fee | decimal(18,6) | not null | 0.000000 | 应付装卸材料费 |
handle_material_handling_account | varchar(256) | not null | 应付装卸材料费结算对象 | |
handle_fall_fee | decimal(18,6) | not null | 0.000000 | 应付倒运费 |
handle_fall_account | varchar(256) | not null | 应付倒运费结算对象 | |
handle_adjustment_fee | decimal(18,6) | not null | 0.000000 | 应付小额调整 |
handle_adjustment_account | varchar(256) | not null | 应付小额调整结算对象 | |
handle_railway_fee | decimal(18,6) | not null | 0.000000 | 应付铁路运费 |
handle_railway_account | varchar(256) | not null | 应付铁路运费结算对象 | |
handle_gate_fee | decimal(18,6) | not null | 0.000000 | 应付入闸费 |
handle_gate_account | varchar(256) | not null | 应付入闸费结算对象 | |
handle_standby_fee | decimal(18,6) | not null | 0.000000 | 应付客户备用金 |
handle_standby_account | varchar(256) | not null | 应付客户备用金结算对象 | |
handle_trailer_fee | decimal(18,6) | not null | 0.000000 | 应付起运港拖车费 |
handle_trailer_account | varchar(256) | not null | 应付起运港拖车费结算对象 | |
handle_recycle_fee | decimal(18,6) | not null | 0.000000 | 应付货损品回收费 |
handle_recycle_account | varchar(256) | not null | 应付货损品回收费结算对象 | |
handle_reinforce_fee | decimal(18,6) | not null | 0.000000 | 应付加固费 |
handle_reinforce_account | varchar(256) | not null | 应付加固费结算对象 |
1.1 SQ设计
CREATE TABLE `agent_profit_info` (
`created_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建人',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间/生成时间',
`modified_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '修改人',
`modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`waybill_no` varchar(64) utf8 NOT NULL DEFAULT '' COMMENT '运单单号',
`order_no` json NOT NULL COMMENT '关联订单单号',
`customer_name` varchar(64) NOT NULL DEFAULT '' COMMENT '客户名称',
`pay_person` varchar(64) NOT NULL DEFAULT '' COMMENT '结算方',
`corp_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司id',
`valid` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否可用',
`id` varchar(18) NOT NULL DEFAULT '' COMMENT '主键id',
`ticket_person` varchar(18) NOT NULL DEFAULT '' COMMENT '开票方',
`carrier_id` tinyint(4) NOT NULL DEFAULT '0' COMMENT '承运商ID',
`carrier` varchar(18) NOT NULL DEFAULT '' COMMENT '承运商',
`cost_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '费用状态',
`waybill_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '运单状态',
`gross_margin` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '毛利',
`receive_freight` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收运费',
`receive_premium` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收保险费',
`receive_extrude_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收压车费',
`receive_loader_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收装卸费',
`receive_damage_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收货损费',
`receive_overload_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收超重费',
`receive_excrete_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收拆单费',
`receive_message_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收信息费',
`receive_express_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收快递费',
`receive_delivery_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收提货送货费',
`receive_pound_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收磅费',
`receive_receipt_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收办单费',
`receive_debit_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收违约金',
`receive_recycle_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收货损品回收费',
`receive_tally_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收现场理货费',
`receive_run_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收跑空费',
`receive_material_handling_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收装卸材料费',
`receive_fall_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收倒运费',
`receive_reinforce_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应收加固费',
`pay_waybill_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付运费',
`pay_waybill_account` varchar(256) NOT NULL COMMENT '应付运费费结算对象',
`pay_premium_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付保险费',
`pay_premium_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付保险费结算对象',
`pay_care_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付关爱基金',
`pay_care_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付关爱基金结算对象',
`pay_service_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付业务开发费',
`pay_service_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付业务开发费结算对象',
`pay_operation_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付操作费',
`pay_opertion_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付操作费结算对象',
`pay_tallying_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付理货基金',
`pay_tallying_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付理货基金结算对象',
`pay_loader_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付装卸费',
`pay_loader_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付装卸费结算对象',
`pay_damage_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付货损费',
`pay_damage_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付货损费结算对象',
`pay_overload_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付超重费',
`pay_overload_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付超重费结算对象',
`pay_excrete_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付拆单费',
`pay_excrete_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付拆单费结算对象',
`pay_extrude_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付压车费',
`pay_extrude_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付压车费结算对象',
`pay_message_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付信息费',
`pay_message_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付信息费结算对象',
`pay_express_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付快递费',
`pay_express_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付快递费结算对象',
`pay_delivery_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付提货送货费',
`pay_delivery_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付提货送货结算对象',
`pay_pound_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付磅费',
`pay_pound_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付磅费结算对象',
`pay_store_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付仓库接洽费',
`pay_store_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付仓库接洽费结算对象',
`pay_receipt_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付办单费',
`pay_receipt_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付办单费结算对象',
`pay_debit_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付违约金',
`pay_debit_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付违约金结算对象',
`pay_amendment_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付改单费',
`pay_amendment_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付改单费结算对象',
`pay_reception_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付业务接待费',
`pay_reception_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付业务接待费结算对象',
`pay_tally_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付现场理货费',
`pay_tally_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付现场理货费结算对象',
`pay_run_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付跑空费',
`pay_run_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付跑空费结算对象',
`pay_material_handling_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付装卸材料费',
`pay_material_handling_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付装卸材料费结算对象',
`pay_fall_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付倒运费',
`pay_fall_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付倒运费结算对象',
`pay_adjustment_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付小额调整',
`pay_adjustment_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付小额调整结算对象',
`pay_railway_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付铁路运费',
`pay_railway_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付铁路运费结算对象',
`pay_gate_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付入闸费',
`pay_gate_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付入闸费结算对象',
`pay_standby_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付客户备用金',
`pay_standby_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付客户备用金结算对象',
`pay_trailer_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付起运港拖车费',
`pay_trailer_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付起运港拖车费结算对象',
`pay_recycle_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付货损品回收费',
`pay_recycle_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付货损品回收费结算对象',
`pay_reinforce_fee` decimal(18, 6) NOT NULL DEFAULT '0.000000' COMMENT '应付加固费',
`pay_reinforce_account` varchar(256) NOT NULL DEFAULT '' COMMENT '应付加固费结算对象',
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代理服务盈利表';
1.2 AgentProfitQueryVO 的设计
属性:
private List<Date> createdTimeList;// 创建时间
private List<String> coustomerList;// 客户
private List<String> carrierList;// 承运商
private List<String> waybillStatusList;// 运单状态
private List<String> costStatusList;// 费用状态
private String waybillNo;// 运单号
private String orderNo;// 关联订单号
private PageParamNewVO<Object> pageParamNewVO;// 分页参数
1.3 AgentProfitPageVO
1.3 AgentProfitPagePO
2、接口文档设计
2.1 代理盈利分页查询
URL:
请求参数:
{
// 创建时间
"createdTimeList": [
"2022-03-16T15:44:32.071Z"
],
// 客户
"coustomerList": [
"String"
],
// 承运商
"carrierList":[
"String"
],
// 运单状态
"waybillStatusList":[
"String"
],
// 费用状态
"costStatusList":[
"String"
],
// 运单号
"waybillNo":"String",
// 关联订单号
"orderNo":"String",
// 分页
"pageParamNewVO": {
"curPage": 0,
"data": [
{}
],
"otherObject": {},
"pageSize": 0,
"sortDir": "string",
"sortIndx": "string",
"totalRecords": 0
}
}
请求响应:
{
"code": 1,
"message": "操作成功",
"result": {
"curPage": 1,
"data":[
{
"createdUserId":Integer,// 创建人
"createdTime":"2022-03-17 14:50:08",// 创建时间/生成时间
"modifiedUserId":Integer,// 修改人
"modifiedTime":"2022-03-17 14:50:08",// 修改时间
"waybillNo":String,// 运单单号
"orderNo":String,// 关联订单单号
"customerName":String,// 客户名称
"payPerson":String,// 结算方
"corpId":Integer,// 公司id
"valid":1,// 是否可用
"id":String,// 主键递增
"ticketPerson":String,// 开票方
"carrier":StringString,// 承运商
"costStatus":
{
id:"1",
name:"已提交财务系统"
},
,// 费用状态 1 表示已提交财务系统 2 表示未提交财务系统
"waybillStatus":
{// 1 -->待派车 2 -->待运输 3 -->运输中 4 -->待签收 5 -->回单待审核
// 6 -->账单待生成 7 -->已完成 8 -->异常完成 9 -->已拒签
id:"1",
name:"待派车"
},// 运单状态
"grossMargin":Decimal,// 毛利
"receiveFreight":Decimal,// 应收运费
"receivePremium":Decimal,// 应收保险费
"receiveExtrudeFee":Decimal,// 应收压车费
"receiveLoaderFee":Decimal,// 应收装卸费
"receiveDamageFee":Decimal,// 应收货损费
"receiveOverloadFee":Decimal,// 应收超重费
"receiveExcreteFee":Decimal,// 应收拆单费
"receiveMessageFee":Decimal,// 应收信息费
"receiveExpressFee":Decimal,// 应收快递费
"receiveDeliveryFee":Decimal,// 应收提货送货费
"receivePoundFee":Decimal,// 应收磅费
"receiveReceiptFee":Decimal,// 应收办单费
"receiveDebitFee":Decimal,// 应收违约金
"receiveRecycleFee":Decimal,// 应收货损品回收费
"receiveTallyFee":Decimal,// 应收现场理货费
"receiveRunFee":Decimal,// 应收跑空费
"receiveMaterialHandlingFee":Decimal,// 应收装卸材料费
"receiveFallFee":Decimal,// 应收倒运费
"receiveReinforceFee":Decimal,// 应收加固费
"payWaybillFee":Decimal,// 应付运费
"payWaaybillAccount":String,// 应付运费费结算对象
"payPremiumFee":Decimal,// 应付保险费
"payPremiumAccount":String,// 应付保险费结算对象
"payServiceFee":Decimal,// 应付业务开发费
"payServiceAccount":String,// 应付业务开发费结算对象
"payCareFee":Decimal,// 应付关爱基金
"payCareAccount":String,// 应付关爱基金结算对象
"payOperationFee":Decimal,// 应付操作费
"payOpertionAccount":String,// 应付操作费结算对象
"payTallyingFee":Decimal,// 应付理货基金
"payTallyingAccount":String,// 应付理货基金结算对象
"payLoaderFee":Decimal,// 应付装卸费
"payLoaderAccount":String,// 应付装卸费结算对象
"payDamageFee":Decimal,// 应付货损费
"payDamageAccount":String,// 应付货损费结算对象
"payOverloadFee":Decimal,// 应付超重费
"payOverloadAccount":String,// 应付超重费结算对象
"payExcreteFee":Decimal,// 应付拆单费
"payExcreteAccount":String,// 应付拆单费结算对象
"payExtrudeFee":Decimal,// 应付压车费
"payExtrudeAccount":String,// 应付压车费结算对象
"payMessageFee":Decimal,// 应付信息费
"payMessageAccount":String,// 应付信息费结算对象
"payExpressFee":Decimal,// 应付快递费
"payExpressAccount":String,// 应付快递费结算对象
"payDeliveryFee":Decimal,// 应付提货送货费
"payDeliveryAccount":String,// 应付提货送货结算对象
"payPoundFee":Decimal,// 应付磅费
"payPoundAccount":String,// 应付磅费结算对象
"payStoreFee":Decimal,// 应付仓库接洽费
"payStoreAccount":String,// 应付仓库接洽费结算对象
"payReceiptFee":Decimal,// 应付办单费
"payReceiptAccount":String,// 应付办单费结算对象
"payDebitFee":Decimal,// 应付违约金
"payDebitAccount":String,// 应付违约金结算对象
"payAmendmentFee":Decimal,// 应付改单费
"payAmendmentAccount":String,// 应付改单费结算对象
"payReceptionFee":Decimal,// 应付业务接待费
"payReceptionAccount":String,// 应付业务接待费结算对象
"payTallyFee":Decimal,// 应付现场理货费
"payTallyAccount":String,// 应付现场理货费结算对象
"payRunFee":Decimal,// 应付跑空费
"payRunAccount":String,// 应付跑空费结算对象
"payMaterialHandlingFee":Decimal,// 应付装卸材料费
"payMaterialHandlingAccount":String,// 应付装卸材料费结算对象
"payFallFee":Decimal,// 应付倒运费
"payFallAccount":String,// 应付倒运费结算对象
"payAdjustmentFee":Decimal,// 应付小额调整
"payAdjustmentAccount":String,// 应付小额调整结算对象
"payRailwayFee":Decimal,// 应付铁路运费
"payRailwayAccount":String,// 应付铁路运费结算对象
"payGateFee":Decimal,// 应付入闸费
"payGateAccount":String,// 应付入闸费结算对象
"payStandbyFee":Decimal,// 应付客户备用金
"payStandbyAccount":String,// 应付客户备用金结算对象
"payTrailerFee":Decimal,// 应付起运港拖车费
"payTrailerAccount":String,// 应付起运港拖车费结算对象
"payRecycleFee":Decimal,// 应付货损品回收费
"payRecycleAccount":String,// 应付货损品回收费结算对象
"payReinforceFee":Decimal,// 应付加固费
"payReinforceFeeAccount":String// 应付加固费结算对象
},
{
...
}
]
}
}
2.2 上报应收/应付接口
URL:
agentProfit/reported?id=xxx&type=1
请求方式:get
请求参数
id:表示代理服务盈利表的id
type : 1 ---> 表示上报应收 2 ---> 表示上报应付
请求响应
{
"code":1
"message":"操作成功"
"result":{
"id":Integer,//标识
"waybillNo":"T20181022IPGM0033",// 运单号
"orderNo":"W20181022IPGM0033",// 订单号
"customerName":"泰晟新材料科技有限公司",// 客户
"mateList":[// 匹配费目项
{
"id":Integer,// 匹配费用项的标识
"feeName":"压车费",// 匹配费用项的名字
"feePrice":1234.998,// 费用项的价格
"account":null,// 结算对象 如果是type 是 1 ,则结算对象为空,如果是 2 ,则展示
},
{
...
}
],
"receiveFeeList":[
{// 人工费用项
"id":Integer,// 匹配费用项的标识
"feeName":"装卸费",// 匹配费用项的名字
"feePrice":1234.998,// 费用项的价格
"account":"哈哈哈哈",// 结算对象 如果是type 是 1 ,则结算对象为空,如果是 2 ,则展示
},
{
...
}
]
}
}
2.3 应收/应付费目项下拉框接口
URL:
请求方式:
请求参数:
请求响应
{
"code":
"message":
"result":{
"receiveFeeEnum":[// 应报费目项
{
"id":1,// 标识
"feeName":"运费",// 费目项名称
"feePrice":568.899,// 费目项所对应的费用
"filedName":"receiveFreight",// 费目项所对应的数据库表中的字段名
"feeType":1// 费目项类型 1---> 表示匹配费目项 2---> 表示人工上报费目项
},
{
"id":Integer,
"feeName":"保险费",
"feePrice":Deciml,
"filedName":"receivePremium",
"feeType":1
},
{
"id":Integer,
"feeName":"压车费",
"feePrice":1234.988,
"filedName":"receiveExtrudeFee",
"feeType":2
},
{
"id":Integer,
"feeName":"装卸费",
"feePrice":Deciml,
"filedName":"receiveLoaderFee",
"feeType":2
},
{
"id":Integer,
"feeName":"货损费",
"feePrice":Deciml,
"filedName":"receiveDamageFee",
"feeType":2
},
{
"id":Integer,
"feeName":"超重费",
"feePrice":Deciml,
"filedName":"receiveOverloadFee",
"feeType":2
},
{
"id":Integer,
"feeName":"拆单费",
"feePrice":Deciml,
"filedName":"receiveExcreteFee",
"feeType":2
},
{
"id":Integer,
"feeName":"信息费",
"feePrice":Deciml,
"filedName":"receiveMessageFee",
"feeType":2
},
{
"id":Integer,
"feeName":"快递费",
"feePrice":Deciml,
"filedName":"receiveExpressFee",
"feeType":2
},
{
"id":Integer,
"feeName":"提货送货费",
"feePrice":Deciml,
"filedName":"receiveDeliveryFee",
"feeType":2
},
{
"id":Integer,
"feeName":"磅费",
"feePrice":Deciml,
"filedName":"receivePoundFee",
"feeType":2
},
{
"id":Integer,
"feeName":"办单费",
"feePrice":Deciml,
"filedName":"receiveReceiptFee",
"feeType":2
},
{
"id":Integer,
"feeName":"违约金",
"feePrice":Deciml,
"filedName":"receiveDebitFee",
"feeType":2
},
{
"id":Integer,
"feeName":"货损品回收费",
"feePrice":Deciml,
"filedName":"handleRecycleAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"现场理货费",
"feePrice":Deciml,
"filedName":"receiveTallyFee",
"feeType":2
},
{
"id":Integer,
"feeName":"跑空费",
"feePrice":Deciml,
"filedName":"receiveRunFee",
"feeType":2
},
{
"id":Integer,
"feeName":"装卸材料费",
"feePrice":Deciml,
"filedName":"receiveMaterialHandlingFee",
"feeType":2
},
{
"id":Integer,
"feeName":"到运费",
"feePrice":Deciml,
"filedName":"receiveFallFee",
"feeType":2
},
{
"id":Integer,
"feeName":"加固费",
"feePrice":Deciml,
"filedName":"receiveReinforceFee",
"feeType":2
}
],
"payFeeEnum":[// 应付费目项
{
"id":Integer,// 标识
"feeName":"运费",// 费目项名称
"feePrice":Deciml,// 费目项所对应的费用
"filedName":"payWaybillFee",// 费目项所对应的数据库表中的字段名
"accountName":"运费结算对象",// 结算对象名
"accountFiledName":"payWaybillAccount",
"feeType":1// 费目项类型 1---> 表示匹配费目项 2---> 表示人工上报费目项
},
{
"id":Integer,
"feeName":"保险费",
"feePrice":Deciml,
"filedName":"payPremiumFee",
"accountName":"保险费结算对象",// 结算对象名
"accountFiledName":"payPremiumAccount",
"feeType":1
},
{
"id":Integer,
"feeName":"业务开发费",
"feePrice":Deciml,
"filedName":"payServiceFee",
"accountName":"业务开发费结算对象",// 结算对象名
"accountFiledName":"payServiceAccount",
"feeType":1
},
{
"id":Integer,
"feeName":"关爱基金",
"feePrice":Deciml,
"filedName":"payCareFee",
"accountName":"关爱基金结算对象",// 结算对象名
"accountFiledName":"payCareAccount",
"feeType":1
},
{
"id":Integer,
"feeName":"操作费",
"feePrice":Deciml,
"filedName":"payOperationFee",
"accountName":"操作费结算对象",// 结算对象名
"accountFiledName":"payOpertionAccount",
"feeType":1
},
{
"id":Integer,
"feeName":"理会基金",
"feePrice":Deciml,
"filedName":"payTallyingFounds",
"accountName":"货损费结算对象",// 结算对象名
"accountFiledName":"payTallyingAccount",
"feeType":1
},
{
"id":Integer,// 标识
"feeName":"装卸费",// 费目项名称
"feePrice":Deciml,// 费目项所对应的费用
"filedName":"payLoaderFee",// 费目项所对应的数据库表中的字段名
"accountName":"装卸费结算对象",// 结算对象名
"accountFiledName":"payLoaderAccount",
"feeType":2// 费目项类型 1---> 表示匹配费目项 2---> 表示人工上报费目项
},
{
"id":Integer,
"feeName":"货损费",
"feePrice":Deciml,
"filedName":"payDamageFee",
"accountName":"货损费结算对象",// 结算对象名
"accountFiledName":"payDamageAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"超重费",
"feePrice":Deciml,
"filedName":"payOverloadFee",
"accountName":"超重费结算对象",// 结算对象名
"accountFiledName":"payOverloadAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"拆单费",
"feePrice":Deciml,
"filedName":"payExcreteFee",
"accountName":"拆单费结算对象",// 结算对象名
"accountFiledName":"payExcreteAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"压车费",
"feePrice":Deciml,
"filedName":"payExtrudeFee",
"accountName":"压车费结算对象",// 结算对象名
"accountFiledName":"payExtrudeAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"信息费",
"feePrice":Deciml,
"filedName":"payMessageFee",
"accountName":"信息费结算对象",// 结算对象名
"accountFiledName":"payMessageAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"快递费",
"feePrice":Deciml,
"filedName":"payExpressFee",
"accountName":"快递费结算对象",// 结算对象名
"accountFiledName":"payExpressAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"提货送货费",
"feePrice":Deciml,
"filedName":"payDeliveryFee",
"accountName":"提货送货费结算对象",// 结算对象名
"accountFiledName":"payDeliveryAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"磅费",
"feePrice":Deciml,
"filedName":"payPoundFee",
"accountName":"磅费结算对象",// 结算对象名
"accountFiledName":"payPoundAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"仓库接洽费",
"feePrice":Deciml,
"filedName":"payStoreFee",
"accountName":"仓库接洽费结算对象",// 结算对象名
"accountFiledName":"payStoreAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"办单费",
"feePrice":Deciml,
"filedName":"payReceiptFee",
"accountName":"办单费结算对象",// 结算对象名
"accountFiledName":"payReceiptAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"违约金",
"feePrice":Deciml,
"filedName":"payDebitFee",
"accountName":"违约金结算对象",// 结算对象名
"accountFiledName":"payDebitAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"改单费",
"feePrice":Deciml,
"filedName":"payAmendmentFee",
"accountName":"改单费结算对象",// 结算对象名
"accountFiledName":"payAmendmentAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"业务接待费",
"feePrice":Deciml,
"filedName":"payReceptionFee",
"accountName":"业务接待费结算对象",// 结算对象名
"accountFiledName":"payReceptionAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"现场理货费",
"feePrice":Deciml,
"filedName":"payTallyFee",
"accountName":"现场理货费结算中心",// 结算对象名
"accountFiledName":"payTallyAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"跑空费",
"feePrice":Deciml,
"filedName":"payRunFee",
"accountName":"跑空费结算对象",// 结算对象名
"accountFiledName":"payRunAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"装卸材料费",
"feePrice":Deciml,
"filedName":"payMaterialHandlingFee",
"accountName":"装卸材料费结算对象",// 结算对象名
"accountFiledName":"payMaterialHandlingAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"倒运费",
"feePrice":Deciml,
"filedName":"payFallFee",
"accountName":"倒到运费结算对象",// 结算对象名
"accountFiledName":"payFallAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"小额调整",
"feePrice":Deciml,
"filedName":"payAdjustmentFee",
"accountName":"小额调整结算对象",// 结算对象名
"accountFiledName":"payAdjustmentAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"铁路运费",
"feePrice":Deciml,
"filedName":"payRailwayFee",
"accountName":"铁路运费结算对象",// 结算对象名
"accountFiledName":"payRailwayAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"入闸费",
"feePrice":Deciml,
"filedName":"payGateFee",
"accountName":"入闸费结算对象",// 结算对象名
"accountFiledName":"payGateAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"客户备用金",
"feePrice":Deciml,
"filedName":"payStandbyFee",
"accountName":"客户备用金结算对象",// 结算对象名
"accountFiledName":"payStandbyAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"起运港拖车费",
"feePrice":Deciml,
"filedName":"payTrailerFee",
"accountName":"起运港拖车费结算对象",// 结算对象名
"accountFiledName":"payTrailerAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"货损品回收费",
"feePrice":Deciml,
"filedName":"payRecycleFee",
"accountName":"货损品回收费结算对象",// 结算对象名
"accountFiledName":"payRecycleAccount",
"feeType":2
},
{
"id":Integer,
"feeName":"加固费",
"feePrice":Deciml,
"filedName":"payReinforceFee",
"accountName":"加固费结算对象",// 结算对象名
"accountFiledName":"payReinforceFee",
"feeType":2
}{
"id":Integer,// 标识
"feeName":"运费",// 费目项名称
"feePrice":Deciml,// 费目项所对应的费用
"filedName":"",// 费目项所对应的数据库表中的字段名
"accountName":"货损费结算对象",// 结算对象名
"feeType":1// 费目项类型 1---> 表示匹配费目项 2---> 表示人工上报费目项
},
{
"id":Integer,
"feeName":"保险费",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":1
},
{
"id":Integer,
"feeName":"业务开发费",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":1
},
{
"id":Integer,
"feeName":"关爱基金",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":1
},
{
"id":Integer,
"feeName":"操作费",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":1
},
{
"id":Integer,
"feeName":"理会基金",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":1
},
{
"id":Integer,// 标识
"feeName":"装卸费",// 费目项名称
"feePrice":Deciml,// 费目项所对应的费用
"filedName":"",// 费目项所对应的数据库表中的字段名
"accountName":"装卸费结算对象",// 结算对象名
"feeType":2// 费目项类型 1---> 表示匹配费目项 2---> 表示人工上报费目项
},
{
"id":Integer,
"feeName":"货损费",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"超重费",
"feePrice":Deciml,
"filedName":"",
"accountName":"超重费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"拆单费",
"feePrice":Deciml,
"filedName":"",
"accountName":"拆单费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"压车费",
"feePrice":Deciml,
"filedName":"",
"accountName":"压车费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"信息费",
"feePrice":Deciml,
"filedName":"",
"accountName":"信息费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"快递费",
"feePrice":Deciml,
"filedName":"",
"accountName":"快递费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"提货送货费",
"feePrice":Deciml,
"filedName":"",
"accountName":"提货送货费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"磅费",
"feePrice":Deciml,
"filedName":"",
"accountName":"磅费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"仓库接洽费",
"feePrice":Deciml,
"filedName":"",
"accountName":"仓库接洽费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"办单费",
"feePrice":Deciml,
"filedName":"",
"accountName":"办单费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"违约金",
"feePrice":Deciml,
"filedName":"",
"accountName":"违约金结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"改单费",
"feePrice":Deciml,
"filedName":"",
"accountName":"改单费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"货损品回收费",
"feePrice":Deciml,
"filedName":"",
"accountName":"货损品回收费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"业务接待费",
"feePrice":Deciml,
"filedName":"",
"accountName":"业务接待费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"现场理货费",
"feePrice":Deciml,
"filedName":"",
"accountName":"现场理货费结算中心",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"跑空费",
"feePrice":Deciml,
"filedName":"",
"accountName":"跑空费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"装卸材料费",
"feePrice":Deciml,
"filedName":"",
"accountName":"装卸材料费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"到运费",
"feePrice":Deciml,
"filedName":"",
"accountName":"到运费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"小额调整",
"feePrice":Deciml,
"filedName":"",
"accountName":"小额调整结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"铁路运费",
"feePrice":Deciml,
"filedName":"",
"accountName":"铁路运费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"入闸费",
"feePrice":Deciml,
"filedName":"",
"accountName":"入闸费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"客户备用金",
"feePrice":Deciml,
"filedName":"",
"accountName":"客户备用金结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"起运港拖车费",
"feePrice":Deciml,
"filedName":"",
"accountName":"起运港拖车费结算对象",// 结算对象名
"feeType":2
},
{
"id":Integer,
"feeName":"加固费",
"feePrice":Deciml,
"filedName":"",
"accountName":"加固费结算对象",// 结算对象名
"feeType":2
}
]
}
}
2.4 添加接口(确定)
URL:
请求方式:
请求参数:
{
"id":Integer,//标识
"waybillNo":"T20181022IPGM0033",// 运单号
"orderNo":"W20181022IPGM0033",// 订单号
"customerName":"泰晟新材料科技有限公司",// 客户
"mateFeeList":[// 匹配费目项
{
"id":Integer,// 匹配费用项的标识
"feeName":String,// 匹配费用项的名字
"feePrice":Decimal,// 费用项的价格
"account":null,// 结算对象 如果是type 是 1 ,则结算对象为空,如果是 2 ,则不会空
},
] ,
"receiveFeeList":[
{// 人工费用项
"id":Integer,// 匹配费用项的标识
"feeName":String,// 匹配费用项的名字
"feePrice":Decimal,// 费用项的价格
"account":String,// 结算对象 如果是type 是 1 ,则结算对象为空,如果是 2 ,则展示
}
],
"deleteReceiveFeeList":[// 需要删除的费目项
{
"id":Integer,// 人工费用项的标识
"feeName":String,// 人工费用项的名字
"feePrice":Decimal,// 人工费用项的价格
"account":String,// 结算对象 如果是type 是 1 ,则结算对象为空,如果是 2 ,则展示
}
]
}
请求响应
{
"code": 1,
"message": "操作成功",
"result": {}
}