客户消费明细 - 方软OpenApi-机构版

注意：该接口受了解途径&客户渠道权限控制，确认存在但无数据返回请确认参数配置

请求参数

Header 参数

FRHis-Open-Timestamp

string

必需

示例值:

{% mock 'timestamp' %}

FRHis-Open-App-Id

string

必需

示例值:

FRHis-Open-Token

string

必需

示例值:

Body 参数application/json

pageNo

integer

页码

必需

默认1

pageSize

integer

页数

必需

默认100

startTime

string

开始时间

必需

endTime

string

结束时间

必需

区间不能超过30天，有患者ID则不再限制

consumeType

integer

消费类型

必需

1：收款情况
【1=药品销售】
【2=产品销售】
【3=项目收款】
【4=跨机构转诊 || 积分兑换项目 || 初始化项目退费 || 项目转赠 || 项目受赠 || 项目置换 || 初始化录入】
【5=预收费用】
【6=还款记录】（需开启参数：客户消费明细表-查询“收款情况”包含客户还款后返回）
2：收入情况
【1=药品销售】
【2=产品销售】
【7=直接收入】
【8=项目划扣】
9：治疗（手术）用药请领情况
【9=药品请领】
【10=物资请领】

accountingMethod

integer

开发人员核算方式

必需

1 - 按客户过往所属（先前）开发人员核算2 - 按客户当前所属开发人员核算

patientName

integer

患者姓名

可选

patientID

integer

患者UD

可选

registerType

string

就诊类型

可选

获取字典：ZDJZLX的编号

triageDesigner

integer

分诊设计师

可选

员工ID

designer

integer

所属设计师

可选

员工ID

itemClassify

string

项目分类

可选

获取字典：ZDSRXM的编号

department

integer

咨询/执行科室

可选

部门ID

customerService

integer

客服人员

可选

员工ID

developer

integer

开发人员

可选

员工ID

developmentDept

integer

开发部门

可选

部门ID

示例

{
    "pageNo": 1,
    "pageSize": 10,
    "startTime": "2022-6-2",
    "endTime": "2022-7-2",
    "consumeType": 1,
    "developer": 3104
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

businessDate

string

营业日期

必需

registerNo

string

门诊挂号流水号

必需

patientId

string

患者ID

必需

customerNo

string

客户卡号

可选

patientName

string

姓名

可选

age

string

年龄

可选

gender

string

性别

可选

registerType

string

就诊类型

必需

serialNo

string

系统流水号

必需

billNo

string

收款单号

必需

billSerialNo

string

订单明细流水号

必需

consumeType

string

消费类型

可选

【1=药品销售】
【2=产品销售】
【3=项目收款】
【4=跨机构转诊 || 积分兑换项目 || 初始化项目退费 || 项目转赠 || 项目受赠 || 项目置换 || 初始化录入】
【5=预收费用】
【6=还款记录】（需开启参数：客户消费明细表-查询“收款情况”包含客户还款后返回）
【7=直接收入】
【8=项目划扣】
【9=药品请领】
【10=物资请领】

consumeTypeName

string

消费类型名称

可选

itemNo

string

项目编码

必需

itemName

string

项目名称

必需

pkgItemNo

string

套餐流水号

可选

pkgItemName

string

套餐名称

可选

costAmount

string

成本金额

可选

standard

string

规格

可选

quantity

string

数量

必需

originalPrice

number

原价

必需

unitPrice

string

单价

必需

remainingCount

number

剩余次数

必需

currentCount

number

本次次数

必需

amountPayable

string

应付金额

必需

currentUsed

string

本次用额

必需

itemBalance

string

项目余额

必需

income

string

实收

可选

cash

string

现金

可选

bankCard

string

银行卡

可选

depositPay

string

预存款支付

可选

discount

string

赠送/减免

可选

arrears

string

欠款

可选

excludeCoupon

string

不含券

可选

introducer

string

推介人

可选

billing

string

开单人

可选

registerDocter

string

就诊医生

可选

assistantDoctor

string

助诊医生

可选

ImageDesigner

string

形象设计师

可选

ImageDesignerID

integer

形象设计师ID

可选

developer

string

开发人员

可选

developerID

integer

开发人员ID

可选

customerService

string

客服人员

可选

channelType

string

渠道类型

可选

developChannel

string

开发渠道

可选

cashierTime

string

收银时间

可选

orderDept

string

开单科室

可选

consultingDept

string

咨询/执行科室

可选

executor

string

执行人

可选

remarks

string

备注

可选

示例

{
    "errcode": 0,
    "errmsg": "成功",
    "data": [
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 2,
            "currentCount": 1,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【银行：1480.00】",
            "unitPrice": 1480,
            "orderDept": "口腔科11",
            "billSerialNo": 136659,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:12:08",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:12:08",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": 1480,
            "billNo": "000000009119",
            "age": 26,
            "gender": "男",
            "quantity": 1,
            "consultingDept": "口腔科11",
            "itemName": "艾莉薇",
            "itemNo": "03.02.19.0004",
            "depositPay": 0,
            "standard": "1ml*支",
            "consumeTypeName": "产品销售",
            "executor": null,
            "remainingCount": 0,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": 1480,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": 0,
            "amountPayable": 1480,
            "originalPrice": 1480,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": 1480,
            "cash": 0,
            "registerDocter": null,
            "excludeCoupon": 1480,
            "rownumber": 1
        },
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 2,
            "currentCount": -1,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【银行：-1480.00】",
            "unitPrice": 1480,
            "orderDept": "口腔科11",
            "billSerialNo": 136659,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:12:08",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:12:08",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": -1480,
            "billNo": "000000009118",
            "age": 26,
            "gender": "男",
            "quantity": -1,
            "consultingDept": "口腔科11",
            "itemName": "艾莉薇",
            "itemNo": "03.02.19.0004",
            "depositPay": 0,
            "standard": "1ml*支",
            "consumeTypeName": "产品销售",
            "executor": null,
            "remainingCount": 0,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": -1480,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": 0,
            "amountPayable": -1480,
            "originalPrice": 1480,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": -1480,
            "cash": 0,
            "registerDocter": null,
            "excludeCoupon": -1480,
            "rownumber": 2
        },
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 2,
            "currentCount": -1,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【银行：-1480.00】",
            "unitPrice": 0,
            "orderDept": "口腔科11",
            "billSerialNo": 136660,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:12:08",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:12:08",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": 0,
            "billNo": "000000009118",
            "age": 26,
            "gender": "男",
            "quantity": -1,
            "consultingDept": "口腔科11",
            "itemName": "笔记本",
            "itemNo": "121111",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "产品销售",
            "executor": null,
            "remainingCount": 0,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": 0,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": 0,
            "amountPayable": 0,
            "originalPrice": 0,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": null,
            "excludeCoupon": 0,
            "rownumber": 3
        },
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【银行：39800.00】",
            "unitPrice": 39800,
            "orderDept": "口腔科11",
            "billSerialNo": 136719,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:07:10",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:07:10",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": 39800,
            "billNo": "000000009117",
            "age": 26,
            "gender": "男",
            "quantity": 1,
            "consultingDept": "财务部",
            "itemName": "520脸小三剑客",
            "itemNo": "WZXXD047",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": 1,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": 39800,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": 39800,
            "amountPayable": 39800,
            "originalPrice": 39800,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": null,
            "excludeCoupon": 39800,
            "rownumber": 4
        },
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【现金：-49800.00，银行：-39800.00】",
            "unitPrice": 39800,
            "orderDept": "口腔科11",
            "billSerialNo": 136719,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:07:09",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:07:09",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": -39800,
            "billNo": "000000009116",
            "age": 26,
            "gender": "男",
            "quantity": -1,
            "consultingDept": "财务部",
            "itemName": "520脸小三剑客",
            "itemNo": "WZXXD047",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": -39800,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": -39800,
            "amountPayable": -39800,
            "originalPrice": 39800,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": null,
            "excludeCoupon": -39800,
            "rownumber": 5
        },
        {
            "developChannel": "奶茶店",
            "customerService": null,
            "channelType": "合作商户",
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2207012700",
            "remarks": "  单据付款方式：【现金：-49800.00，银行：-39800.00】",
            "unitPrice": 49800,
            "orderDept": "口腔科11",
            "billSerialNo": 136720,
            "costAmount": 0,
            "cashierTime": "2022-07-02 22:07:09",
            "patientId": 161023,
            "businessDate": "2022-07-02 22:07:09",
            "registerType": "初诊",
            "patientName": "李铁蛋",
            "income": -49800,
            "billNo": "000000009116",
            "age": 26,
            "gender": "男",
            "quantity": -1,
            "consultingDept": "财务部",
            "itemName": "5分钟提眉峰-集团专家",
            "itemNo": "WZXXD002",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16726,
            "introducer": "柴鸿律",
            "discount": 0,
            "bankCard": 0,
            "billing": "柴鸿律",
            "arrears": 0,
            "itemBalance": -49800,
            "amountPayable": -49800,
            "originalPrice": 49800,
            "developer": null,
            "ImageDesigner": "柴鸿律",
            "currentUsed": 0,
            "cash": -49800,
            "registerDocter": null,
            "excludeCoupon": -49800,
            "rownumber": 6
        },
        {
            "developChannel": null,
            "customerService": null,
            "channelType": null,
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2206242666",
            "remarks": "  单据付款方式：【银联POS1：-68689.00】",
            "unitPrice": 7000,
            "orderDept": "整形外科",
            "billSerialNo": 136723,
            "costAmount": 0,
            "cashierTime": "2022-07-01 23:12:45",
            "patientId": 160524,
            "businessDate": "2022-07-01 23:12:45",
            "registerType": "复诊",
            "patientName": "喇叭花",
            "income": -7000,
            "billNo": "000000009115",
            "age": 26,
            "gender": "女",
            "quantity": -1,
            "consultingDept": "财务部",
            "itemName": "鼻尖塑形-自体真皮瓣",
            "itemNo": "WKBB0130",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16728,
            "introducer": "罗谦",
            "discount": 0,
            "bankCard": -7000,
            "billing": "罗谦",
            "arrears": 0,
            "itemBalance": -7000,
            "amountPayable": -7000,
            "originalPrice": 7000,
            "developer": "李世林",
            "ImageDesigner": "罗谦",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": "孙中元",
            "excludeCoupon": -7000,
            "rownumber": 7
        },
        {
            "developChannel": null,
            "customerService": null,
            "channelType": null,
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2206242666",
            "remarks": "  单据付款方式：【银联POS1：-68689.00】",
            "unitPrice": 1,
            "orderDept": "整形外科",
            "billSerialNo": 136724,
            "costAmount": 0,
            "cashierTime": "2022-07-01 23:12:45",
            "patientId": 160524,
            "businessDate": "2022-07-01 23:12:45",
            "registerType": "复诊",
            "patientName": "喇叭花",
            "income": -1,
            "billNo": "000000009115",
            "age": 26,
            "gender": "女",
            "quantity": -1,
            "consultingDept": "财务部",
            "itemName": "鼻尖塑形-自体筋膜",
            "itemNo": "WKBB0132",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16728,
            "introducer": "罗谦",
            "discount": 0,
            "bankCard": -1,
            "billing": "罗谦",
            "arrears": 0,
            "itemBalance": -1,
            "amountPayable": -1,
            "originalPrice": 1,
            "developer": "李世林",
            "ImageDesigner": "罗谦",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": "孙中元",
            "excludeCoupon": -1,
            "rownumber": 8
        },
        {
            "developChannel": null,
            "customerService": null,
            "channelType": null,
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2206242666",
            "remarks": "  单据付款方式：【银联POS1：-68689.00】",
            "unitPrice": 42800,
            "orderDept": "整形外科",
            "billSerialNo": 136725,
            "costAmount": 0,
            "cashierTime": "2022-07-01 23:12:45",
            "patientId": 160524,
            "businessDate": "2022-07-01 23:12:45",
            "registerType": "复诊",
            "patientName": "喇叭花",
            "income": -42800,
            "billNo": "000000009115",
            "age": 26,
            "gender": "女",
            "quantity": -1,
            "consultingDept": "美容外科",
            "itemName": "++假体隆胸术（圆形 威宁花样年华）院长",
            "itemNo": "MY1408",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16728,
            "introducer": "罗谦",
            "discount": 0,
            "bankCard": -42800,
            "billing": "罗谦",
            "arrears": 0,
            "itemBalance": -42800,
            "amountPayable": -42800,
            "originalPrice": 42800,
            "developer": "李世林",
            "ImageDesigner": "罗谦",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": "孙中元",
            "excludeCoupon": -42800,
            "rownumber": 9
        },
        {
            "developChannel": null,
            "customerService": null,
            "channelType": null,
            "consumeType": 3,
            "currentCount": 0,
            "assistantDoctor": null,
            "customerNo": "2206242666",
            "remarks": "  单据付款方式：【银联POS1：-68689.00】",
            "unitPrice": 8718.7,
            "orderDept": "整形外科",
            "billSerialNo": 136726,
            "costAmount": 0,
            "cashierTime": "2022-07-01 23:12:45",
            "patientId": 160524,
            "businessDate": "2022-07-01 23:12:45",
            "registerType": "复诊",
            "patientName": "喇叭花",
            "income": -8718.7,
            "billNo": "000000009115",
            "age": 26,
            "gender": "女",
            "quantity": -1,
            "consultingDept": "财务部",
            "itemName": "鼻尖塑形-人工真皮瓣",
            "itemNo": "WKBB0131",
            "depositPay": 0,
            "standard": "",
            "consumeTypeName": "项目收款",
            "executor": null,
            "remainingCount": -1,
            "registerNo": 16728,
            "introducer": "罗谦",
            "discount": 0,
            "bankCard": -8718.7,
            "billing": "罗谦",
            "arrears": 0,
            "itemBalance": -8718.7,
            "amountPayable": -8718.7,
            "originalPrice": 6000,
            "developer": "李世林",
            "ImageDesigner": "罗谦",
            "currentUsed": 0,
            "cash": 0,
            "registerDocter": "孙中元",
            "excludeCoupon": -8718.7,
            "rownumber": 10
        }
    ]
}