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:表示代理服务盈利表的idtype : 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": {}}
