账单明细分页查询
- 接口:/common/bill/findPageBillDetail
- Method:GET
- 接口说明:根据渠道和账单编码分页查询账单明细信息
参数
请求参数
字段名称 |
字段类型 |
字段描述 |
是否必填 |
长度限制(字节) |
source |
String |
渠道 |
TRUE |
无 |
bill_code |
String |
账单编码 |
TRUE |
无 |
page_num |
Integer |
页码 |
FALSE |
默认值:1 |
page_size |
Integer |
每页大小 |
FALSE |
默认值:100,最大2000 |
返回参数
字段名称 |
字段类型 |
字段描述 |
resCode |
Integer |
响应状态码(见附录) |
resMsg |
String |
返回信息描述 |
data |
PageHelper<BillLineVo> |
账单明细分页信息 |
PageHelper<BillLineVo>
字段名称 |
字段类型 |
字段描述 |
page_size |
Integer |
每页大小 |
page_num |
Integer |
当前页码 |
total_count |
Integer |
总记录数 |
total_page |
Integer |
总页数 |
is_first_page |
Boolean |
是否首页 |
is_last_page |
Boolean |
是否末页 |
page_info |
List<BillLineVo> |
账单明细列表 |
BillLineVo
字段名称 |
字段类型 |
字段描述 |
data |
JSONObject |
第三方提供的账单单回传原始信息 |
detail |
JSONObject |
详情 |
order_id |
String |
订单号 |
bill_line_no |
String |
账单行号 |
start_date_time |
Date |
开始时间 |
end_date_time |
Date |
结束时间 |
order_date |
Date |
订单时间 |
branch_code |
String |
分公司编码 |
branch_name |
String |
分公司名称 |
department_code |
String |
部门编码 |
department_name |
String |
部门名称 |
cost_center_code |
String |
成本中心编码 |
cost_center_name |
String |
成本中心名称 |
amount |
BigDecimal |
总金额 |
company_pay |
BigDecimal |
公司支付金额 |
person_pay |
BigDecimal |
个人支付金额 |
service_price |
BigDecimal |
服务费 |
airport_fee |
BigDecimal |
基建费 |
oil_fee |
BigDecimal |
燃油费 |
change_service_price |
BigDecimal |
改签手续费 |
refund_service_price |
BigDecimal |
退票手续费 |
refund_price |
BigDecimal |
退款金额 |
taxation |
BigDecimal |
税额 |
passenger_name |
String |
出行人 |
name |
String |
姓名 |
employee_number |
String |
员工号 |
journey_id |
String |
第三方申请单id |
document_num |
String |
申请单号 |
description |
String |
描述 |
remarks |
String |
备注 |
price |
BigDecimal |
单价 |
unit_price |
BigDecimal |
最低价 |
quantity |
Integer |
数量 |
price1~price20 |
BigDecimal |
扩展金额字段1-20 |
column1~column50 |
String |
扩展字段1-50 |
示例:
请求数据
GET /common/bill/findPageBillDetail?source=ctrip&bill_code=CTRIP_BILL001&page_num=1&page_size=100
返回数据
{
"resCode": 200000,
"resMsg": "success",
"data": {
"page_size": 100,
"page_num": 1,
"total_count": 2,
"total_page": 1,
"is_first_page": true,
"is_last_page": true,
"page_info": [
{
"data": {"platform": "ctrip", "orderType": "flight"},
"detail": {},
"order_id": "CTRIP_ORDER001",
"bill_line_no": "LINE001",
"start_date_time": 1705298400000,
"end_date_time": 1705307400000,
"order_date": 1705293000000,
"branch_code": "BR001",
"branch_name": "北京分公司",
"amount": 2800.00,
"company_pay": 2800.00,
"person_pay": 0.00,
"price": 2800.00,
"unit_price": 2800.00,
"quantity": 1,
"service_price": 100.00,
"airport_fee": 50.00,
"oil_fee": 200.00,
"passenger_name": "张三",
"name": "张三",
"employee_number": "EMP001",
"journey_id": "J001",
"document_num": "ID001",
"description": "北京到上海机票",
"remarks": "准点到达"
},
{
"data": {"platform": "ctrip", "orderType": "hotel"},
"detail": {},
"order_id": "CTRIP_ORDER002",
"bill_line_no": "LINE002",
"start_date_time": 1705363200000,
"end_date_time": 1705536000000,
"order_date": 1705372200000,
"branch_code": "BR001",
"branch_name": "北京分公司",
"amount": 500.00,
"company_pay": 500.00,
"person_pay": 0.00,
"price": 500.00,
"unit_price": 250.00,
"quantity": 2,
"service_price": 50.00,
"passenger_name": "张三",
"name": "张三",
"employee_number": "EMP001",
"journey_id": "J001",
"document_num": "ID001",
"description": "上海酒店住宿2晚",
"remarks": "含早餐"
}
]
}
}