应收单
1.表
老版本的表(需求被推翻,被舍弃重新做)
Rcm_Receipt 实收账单
Rcm_ReceiptDetail 实收账单明细
Rcm_Receivable 应收单
Rcm_ReceivableDetail 应收单明细
新版本的表
rcm_receipt_info 实收账单
rcm_receipt_info_detail 实收账单明细
rcm_receivable_info 应收单
rcm_receivableinfo_detail 应收单明细
板块:财务会计工作站
保险理赔单查询接口:
http://api.testgxkf.everjiankang.com.cn/rcm/ar/receivableInfo/search
<select id="search" resultMap="BaseResultMap"> SELECT d.clinic_id, d.total_fee, d.pay_insur, b.diagnosis, m.insur_org_id, m.claim_number, d.paid_insur, d.patient_id, d.settlement_code, d.insur_init_fee, m.create_by, m.create_time, d.order_dept, d.order_doctor, d.charge_date, d.insur_product_id, m.type, d.id, d.mid, d.adjust_fee, d.baddebt_fee, d.baddebt_fee, d.benefit_fee, d.refuse_fee, d.pay_person, d.paid_person, d.pay_status FROM rcm_receivableinfo_detail d INNER JOIN rcm_receivable_info m on d.mid = m.id left JOIN Cs_Settlement rs ON d.settlement_id = rs.id left JOIN ( SELECT settlementid, min(accountBillID) AS accountbillid, sum(prefee) AS totalFee, sum(fee) AS realTotalFee FROM Cs_SettlementDetail GROUP BY settlementid ) rsd ON rsd.settlementid = rs.id left JOIN Cs_AccountBill b ON rsd.accountBillID = b.id where m.is_delete = 0 <if test="param.applyBeginDate != null and param.applyBeginDate != ''"> and TO_DAYS(m.create_time) <![CDATA[>=]]> TO_DAYS(#{param.applyBeginDate}) </if> <if test="param.applyEndDate != null and param.applyEndDate != ''"> and TO_DAYS(m.create_time) <![CDATA[<=]]> TO_DAYS(#{param.applyEndDate}) </if> <if test="param.insurOrgId != null and param.insurOrgId != ''"> and m.insur_org_id = #{param.insurOrgId} </if> <if test="param.applyUser != null and param.applyUser != ''"> and m.create_by = #{param.applyUser} </if> <if test="param.patientid != null and param.patientid != ''"> and d.patient_id = #{param.patientid} </if> <if test="param.settlementCode != null and param.settlementCode != ''"> and d.settlement_code = #{param.settlementCode} </if> <if test="param.insurProductId != null and param.insurProductId != ''"> and d.insur_product_id = #{param.insurProductId} </if> <if test="param.refuseFee != null"> and d.refuse_fee <![CDATA[<>]]> #{param.refuseFee} </if> <if test="param.claimNumber != null"> and m.claim_number like '%${param.claimNumber}%' </if> order by m.create_time desc </select>
结算单查询接口
http://api.testgxkf.everjiankang.com.cn/rcm/ar/receivableInfo/getReceivableSettlements
<select id="getReceivableSettlements" resultType="com.thc.rcm.ar.model.ReceivableinfoDetail"> SELECT s.id as settlementId, s.settleCode as settlementCode, s.settleDate as chargeDate, s.clinicID as clinicid, b.orderDept as orderDept, b.orderDoctor as orderDoctor, s.patientid as patientid, ifnull(sd.totalFee, 0) as totalFee, ifnull(s.comInsuranceDirectFee, 0) as payInsur, ifnull(s.comInsuranceDirectFee, 0) as insurInitFee, b.diagnosis as diagnosis, i.insurOrgId as insurOrgId, i.insurProductId as insurProductId, 0 as paidInsur FROM Cs_Settlement s inner join Cs_SettlementComInsurDet i on s.id = i.mid and s.isComInsurance = 1 inner join (select accountBillID, settlementID, sum(prefee) as totalFee FROM Cs_SettlementDetail GROUP BY settlementID) sd on s.id = sd.settlementID inner join Cs_AccountBill b on sd.accountBillID = b.id where s.isDelete = 0 and s.claimFlag = 0 <if test="param.clinicid != null and param.clinicid != ''"> and s.clinicID = #{param.clinicid} </if> <if test="param.insurOrgId != null and param.insurOrgId != ''"> and i.insurOrgId = #{param.insurOrgId} </if> <if test="param.patientid != null and param.patientid != ''"> and s.patientid = #{param.patientid} </if> <if test="param.insurProductId != null and param.insurProductId != ''"> and i.insurProductId = #{param.insurProductId} </if> order by s.createtime desc </select>
结算单要先经过审批的,审批之后的,才能生成理赔单,理赔单进一步生成收款单
我的工作:审批单模块
1.新建审批单
2.发起审批
3.查询审批
开启流程:
{ "head": { "errMsg": "成功", "errCode": 0 }, "data": [ { "variables": { "lastTaskId": "7fc5f6e9-f9e4-11e8-a6d2-0242ac110010", "businessCode": "CM201812070000784MPN", "_ACTIVITI_SKIP_EXPRESSION_ENABLED": true, "roleCode": "1029197041273667584", "initiator": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "tenantId": 88, "processKey": "commercialInsuranceApproval", "organId": 88002, "initiatorName": "吴喆", "categoryCode": "oa", "typeCode": null }, "instanceId": "7fc5f6e9-f9e4-11e8-a6d2-0242ac110010", "isSuspended": false, "processName": "商保账单审批", "name": "商保审批", "startTime": 1544162042636, "assignee": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "isEnd": false, "taskId": "7fc61e07-f9e4-11e8-a6d2-0242ac110010", "key": "commercialInsuranceApproval_begin" } ] }
{ "head": { "errMsg": "成功", "errCode": 0 }, "data": [ { "variables": { "lastTaskId": "7f555ab9-f9e4-11e8-a6d2-0242ac110010", "businessCode": "CM201812070000884MPN", "_ACTIVITI_SKIP_EXPRESSION_ENABLED": true, "roleCode": "1029197041273667584", "initiator": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "tenantId": 88, "processKey": "commercialInsuranceApproval", "organId": 88002, "initiatorName": "吴喆", "categoryCode": "oa", "typeCode": null }, "instanceId": "7f555ab9-f9e4-11e8-a6d2-0242ac110010", "isSuspended": false, "processName": "商保账单审批", "name": "商保审批", "startTime": 1544162041898, "assignee": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "isEnd": false, "taskId": "7f55a8e7-f9e4-11e8-a6d2-0242ac110010", "key": "commercialInsuranceApproval_begin" } ] }
第一次流动流程
{ "head": { "errMsg": "成功", "errCode": 0 }, "data": [ { "variables": { "nrOfDisAgree": 0, "gbAudit": null, "initiator": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "initiatorName": "吴喆", "categoryCode": "oa", "typeCode": null, "lastTaskId": "7f55a8e7-f9e4-11e8-a6d2-0242ac110010", "businessCode": "CM201812070000884MPN", "_ACTIVITI_SKIP_EXPRESSION_ENABLED": true, "roleCode": "1029197041273667584", "tenantId": 88, "processKey": "commercialInsuranceApproval", "organId": 88002, "nrOfAgree": 0 }, "instanceId": "7f555ab9-f9e4-11e8-a6d2-0242ac110010", "isSuspended": false, "processName": "商保账单审批", "name": "一级审批", "startTime": 1544162415576, "assignee": null, "isEnd": false, "taskId": "5e1065e3-f9e5-11e8-a6d2-0242ac110010", "key": "commercialInsuranceApproval_first" }, { "variables": { "nrOfDisAgree": 0, "operateId": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "gbAudit": null, "initiator": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "initiatorName": "吴喆", "categoryCode": "oa", "typeCode": null, "lastTaskId": "7f555ab9-f9e4-11e8-a6d2-0242ac110010", "businessCode": "CM201812070000884MPN", "_ACTIVITI_SKIP_EXPRESSION_ENABLED": true, "now": "2018-12-07 14:00:15", "eventStatus": "FINISHED", "roleCode": "1029197041273667584", "tenantId": 88, "eventName": "正常完成", "processKey": "commercialInsuranceApproval", "organId": 88002, "operateName": "吴喆", "nrOfAgree": 0 }, "instanceId": "7f555ab9-f9e4-11e8-a6d2-0242ac110010", "processName": "商保账单审批", "name": "商保审批", "startTime": 1544162041898, "assignee": "caaa3afd-4a52-4dd7-969f-3ced578a8b2e", "endTime": 1544162415574, "isEnd": true, "taskId": "7f55a8e7-f9e4-11e8-a6d2-0242ac110010", "key": "commercialInsuranceApproval_begin" } ] }