CN117474696A - Diagnosis method, system, equipment and storage medium for commission settlement problem - Google Patents
Diagnosis method, system, equipment and storage medium for commission settlement problem Download PDFInfo
- Publication number
- CN117474696A CN117474696A CN202311446465.5A CN202311446465A CN117474696A CN 117474696 A CN117474696 A CN 117474696A CN 202311446465 A CN202311446465 A CN 202311446465A CN 117474696 A CN117474696 A CN 117474696A
- Authority
- CN
- China
- Prior art keywords
- settlement
- data
- diagnosis
- link
- commission
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003745 diagnosis Methods 0.000 title claims abstract description 249
- 238000000034 method Methods 0.000 title claims abstract description 95
- 238000004364 calculation method Methods 0.000 claims description 69
- 238000007726 management method Methods 0.000 claims description 55
- 230000002093 peripheral effect Effects 0.000 claims description 44
- 238000012795 verification Methods 0.000 claims description 38
- 238000012550 audit Methods 0.000 claims description 28
- 239000002131 composite material Substances 0.000 claims description 21
- 238000012544 monitoring process Methods 0.000 claims description 8
- 230000004044 response Effects 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 4
- 238000007670 refining Methods 0.000 abstract 1
- 230000008569 process Effects 0.000 description 42
- 238000010586 diagram Methods 0.000 description 21
- 238000004891 communication Methods 0.000 description 8
- 230000000694 effects Effects 0.000 description 8
- 230000002159 abnormal effect Effects 0.000 description 4
- 238000009825 accumulation Methods 0.000 description 4
- 238000011835 investigation Methods 0.000 description 4
- 230000000007 visual effect Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 241000700605 Viruses Species 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000002405 diagnostic procedure Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/128—Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/182—Distributed file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/1873—Versioning file systems, temporal file systems, e.g. file system supporting different historic versions of files
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Devices For Checking Fares Or Tickets At Control Points (AREA)
Abstract
The application provides a diagnosis method, a system, equipment and a storage medium for commission settlement problems, which are applied to the technical field of data processing. Obtaining a target original ticket file of a target diagnosis account period corresponding to an object to be diagnosed according to a diagnosis instruction, aiming at an n+1 link in a plurality of links with sequence included in commission settlement, obtaining first settlement data according to the output of the n link, the target original ticket file and a commission settlement rule corresponding to the n+1 link, comparing the first settlement data with second settlement data obtained from a channel centralized management system, obtaining a diagnosis result corresponding to the n+1 link, reflecting the consistency of the first settlement data and the second settlement data, refining the commission settlement problem to each link, and improving the problem positioning accuracy; when the first settlement data and the second settlement data are inconsistent, diagnosis is stopped, a diagnosis result corresponding to the (n+1) th link is output, diagnosis time is saved, and problem positioning efficiency is improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, a system, an apparatus, and a storage medium for diagnosing a commission settlement problem.
Background
With the development of economy, various types of agents are emerging in each field to earn commissions in economic transactions, correspondingly, each enterprise realizes that commissions and/or subsidies are paid to agents according to a unified business process through respective settlement systems, for example, currently, in commission payment of channel agents in the communication fields of operators and the like, the commission calculation process comprises links of collection, auditing, sorting, merging, pricing and fee calculation, and commissions are paid to channel agents of each branch company according to calculation results of the related settlement systems.
However, the data volume involved in the commission calculation is large, the calculation rule is large, the calculation flow is complex, when the commission calculation has calculation errors, the commission calculation needs to be gradually checked in the log file according to the payment problem fed back by the agent, and the checking efficiency is low.
Disclosure of Invention
The application provides a diagnosis method, a system, equipment and a storage medium for commission settlement problems, which effectively improve the investigation efficiency of settlement problems through a visual diagnosis flow and improve the positioning accuracy of settlement problems to a certain extent.
In a first aspect, the present application provides a method for diagnosing a commission settlement problem, comprising:
Receiving a diagnosis instruction, wherein the diagnosis instruction carries a target diagnosis account period and an object identification of an object to be diagnosed;
acquiring a target original ticket file of a target diagnosis account period corresponding to an object to be diagnosed;
aiming at the n+1 link in a plurality of links with sequence contained in the commission settlement, obtaining first settlement data according to the output of the n link contained in the commission settlement, the target original ticket file and the commission settlement rule corresponding to the n+1 link, wherein the commission settlement rule is the same as the commission settlement rule corresponding to the n+1 link contained in the channel centralized management system;
comparing the first settlement data with the second settlement data to obtain a diagnosis result corresponding to the (n+1) th link, wherein the second settlement data is obtained by the channel centralized management system, and the diagnosis result reflects that the first settlement data is consistent with the second settlement data or the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data;
if the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, the diagnosis is terminated, and the diagnosis result corresponding to the (n+1) th link is output.
In one possible implementation, the multiple links with the sequence included in the commission settlement are sequentially auditing, sorting, merging, pricing and billing, where:
If the link is audit, the commission settlement rule corresponding to the audit is a check rule, the second settlement data is an audit check result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, and the method comprises the following steps: according to the verification rule, auditing and checking the target original ticket file to obtain an auditing and checking result as first settlement data;
if the link is sorting, sorting the corresponding commission settlement rule is sorting rule, and the second settlement data is sorting result obtained by the channel centralized management system, and obtaining the first settlement data according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, wherein the output of the nth link, the target original ticket file and the target original ticket file are included in the commission settlement, and the first settlement data comprises: classifying and storing the target original ticket file according to the sorting rule to obtain a sorting result as first settlement data;
if the links are merging, and the corresponding commission settlement rules are merging rules, the second settlement data is a composite ticket obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rules corresponding to the (n+1) th link, which are included in the commission settlement, and the first settlement data comprises: merging the sorted file data according to a merging rule to generate a composite ticket as first settlement data;
If the link is a rating, the second settlement data is a rating result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, including: analyzing the composite ticket to extract channel related data, and integrating integral data and proportion data of the channel to obtain a rating result as first settlement data;
if the link is a fee calculation, the second settlement data is a fee calculation result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the fee settlement rule corresponding to the (n+1) th link, which are included in the fee settlement, including: and performing commission calculation on the priced data, generating at least one of an agent bill and a developer bill, and obtaining a fee calculation result as first settlement data.
In one possible implementation, if the link is audit, the diagnosis result includes a differential audit verification rule, a commission settlement process verification result, and a diagnosis process verification result;
if the link is sorting, the diagnosis result comprises a file name with difference, a commission settlement flow distribution directory and a diagnosis flow distribution directory;
If the links are merging, the diagnosis result comprises a differential interface name, a data type and a field name;
if the link is the price, the diagnosis result comprises a channel name with difference, a value accumulated by integral data and a value accumulated by proportion data;
if the link is a fee calculation, the diagnosis result includes at least one of commission, agent bill and developer bill.
In one possible implementation manner, the obtaining the target original ticket file corresponding to the target diagnostic accounting period of the object to be diagnosed includes:
pulling a target ticket file snapshot of a target diagnostic account period corresponding to an object to be diagnosed from a Hadoop distributed file system (Hadoop Distributed Filesystem, HDFS) server through a data warehouse, wherein a version list is stored in the data warehouse, the ticket file snapshot corresponding to the version list is stored in the HDFS server, and an original ticket file corresponding to the ticket file snapshot is generated by a peripheral system and is stored in a secure file information transmission system (Secure File Transfer Protocol, SFTP) server;
and recovering the original target ticket file according to the target ticket file snapshot.
In one possible implementation, the ticket file snapshot is obtained by:
The version control center responds to monitoring that the peripheral system uploads an original ticket file to the SFTP server, and determines whether the original ticket file is a new version or not;
if the new version is the new version, the version control center issues notification information to the task scheduling center, and the task scheduling center is used for executing a diagnosis method of the commission settlement problem;
the task scheduling center responds to the received notification information and sends a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse;
and the data warehouse responds to receiving the version snapshot backup task, acquires the original ticket file uploaded by the peripheral system from the SFTP server, generates a ticket file snapshot corresponding to the original ticket file, and stores the ticket file snapshot to the HDFS server.
In one possible implementation manner, the outputting the diagnosis result corresponding to the n+1th link includes:
displaying a diagnosis result corresponding to the (n+1) th link on a diagnosis interface;
and/or, in the diagnostic interface, displaying a link to a diagnostic report, the diagnostic report comprising the diagnostic result.
In a second aspect, the present application provides a diagnosis apparatus for a commission settlement problem, comprising:
the receiving module is used for receiving a diagnosis instruction, wherein the diagnosis instruction carries a target diagnosis account period and an object identification of an object to be diagnosed;
The acquisition module is used for acquiring a target original ticket file of a target diagnosis account period corresponding to the object to be diagnosed;
the determining module is used for obtaining first settlement data according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link in the multiple links with the sequence contained in the commission settlement, wherein the commission settlement rule is the same as the commission settlement rule corresponding to the (n+1) th link contained in the channel centralized management system;
the diagnosis module is used for comparing the first settlement data with the second settlement data to obtain a diagnosis result corresponding to the (n+1) th link, the second settlement data is obtained by the channel centralized management system, the diagnosis result reflects that the first settlement data is consistent with the second settlement data, or the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data;
and the output module is used for stopping diagnosis when the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, and outputting the diagnosis result corresponding to the (n+1) th link.
In one possible implementation, the multiple links with the sequence included in the commission settlement are sequentially auditing, sorting, merging, pricing and billing, where: if the link is audit, the commission settlement rule corresponding to the audit is a check rule, the second settlement data is an audit check result obtained by the channel centralized management system, and the determining module is specifically used for: according to the verification rule, auditing and checking the target original ticket file to obtain an auditing and checking result as first settlement data; if the link is sorting, the sorting corresponding commission settlement rule is a sorting rule, the second settlement data is a sorting result obtained by the channel centralized management system, and the determining module is further used for: classifying and storing the target original ticket file according to the sorting rule to obtain a sorting result as first settlement data; if the link is merging, merging the corresponding commission settlement rules into merging rules, and the second settlement data is a composite ticket obtained by the channel centralized management system, the determining module is further used for: merging the sorted file data according to a merging rule to generate a composite ticket as first settlement data; if the link is rating, the second settlement data is rating result obtained by the channel centralized management system, and the determining module is further used for: analyzing the composite ticket to extract channel related data, and integrating integral data and proportion data of the channel to obtain a rating result as first settlement data; if the link is fee calculation, the second settlement data is fee calculation result obtained by the channel centralized management system, and the determining module is further used for: and performing commission calculation on the priced data, generating at least one of an agent bill and a developer bill, and obtaining a fee calculation result as first settlement data.
In one possible implementation, if the link is audit, the diagnosis result includes a differential audit verification rule, a commission settlement process verification result, and a diagnosis process verification result; if the link is sorting, the diagnosis result comprises a file name with difference, a commission settlement flow distribution directory and a diagnosis flow distribution directory; if the links are merging, the diagnosis result comprises a differential interface name, a data type and a field name; if the link is the price, the diagnosis result comprises a channel name with difference, a value accumulated by integral data and a value accumulated by proportion data; if the link is a fee calculation, the diagnosis result includes at least one of commission, agent bill and developer bill.
In one possible implementation, the obtaining module is specifically configured to: pulling a target ticket file snapshot of a target diagnostic account period corresponding to an object to be diagnosed from a Hadoop distributed file system (Hadoop Distributed Filesystem, HDFS) server through a data warehouse, wherein a version list is stored in the data warehouse, the ticket file snapshot corresponding to the version list is stored in the HDFS server, and an original ticket file corresponding to the ticket file snapshot is generated by a peripheral system and is stored in a secure file information transmission system (Secure File Transfer Protocol, SFTP) server; and recovering the original target ticket file according to the target ticket file snapshot.
In one possible implementation, the ticket file snapshot is obtained by: the version control center responds to monitoring that the peripheral system uploads an original ticket file to the SFTP server, and determines whether the original ticket file is a new version or not; if the new version is the new version, the version control center issues notification information to the task scheduling center, and the task scheduling center is used for executing a diagnosis method of the commission settlement problem; the task scheduling center responds to the received notification information and sends a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse; and the data warehouse responds to receiving the version snapshot backup task, acquires the original ticket file uploaded by the peripheral system from the SFTP server, generates a ticket file snapshot corresponding to the original ticket file, and stores the ticket file snapshot to the HDFS server.
In one possible implementation, the output module is specifically configured to: displaying a diagnosis result corresponding to the (n+1) th link on a diagnosis interface; and/or, in the diagnostic interface, displaying a link to a diagnostic report, the diagnostic report comprising the diagnostic result.
In a third aspect, the present application provides an electronic device, comprising: a processor, a memory communicatively coupled to the processor;
A memory for storing computer-executable instructions;
a processor for executing computer-executable instructions to cause the processor to perform the method of diagnosing a commission settlement problem as described in any one of the first aspects.
In a fourth aspect, the present application provides a system for diagnosing a commission settlement problem, comprising: SFTP server, version control center, task scheduling center, data warehouse and HDFS server, wherein:
the SFTP server is used for storing the original ticket file generated and uploaded by the peripheral system;
the version control center is used for responding to the monitoring that the peripheral system uploads the original ticket file to the SFTP server and determining whether the original ticket file is a new version or not; if the new version is the new version, the notification information is issued to the task scheduling center;
a task scheduling center for transmitting a version snapshot backup task for an original ticket file uploaded by a peripheral system to a data warehouse in response to receiving the notification information, and performing the diagnosis method of the commission settlement problem according to any one of the first aspects;
and the data warehouse is used for responding to the received version snapshot backup task, acquiring an original ticket file uploaded by the peripheral system from the SFTP server, generating a ticket file snapshot corresponding to the original ticket file and storing the ticket file snapshot to the HDFS server.
Optionally, the commission settlement problem diagnosis system further comprises a relational database service (Relational Database Service, RDS) for storing version information of the original ticket file generated by the version control center.
Optionally, the peripheral systems include, but are not limited to, a centralized business support system (central Business Support System, CBSS) for generating raw ticket files for user classes and payment classes, via a subsystem for generating raw ticket files for business usage and user detail information, a cloud server (Elastic Compute Service, ECS) for generating raw ticket files for card sales information, an activity center for generating raw ticket files for user electronic ticket information, and a revenue management system for generating raw ticket files for billing revenue ratio information.
In a fifth aspect, the present application provides a computer-readable storage medium having stored therein computer-executable instructions that, when executed, are configured to implement the method for diagnosing a commission settlement problem according to any one of the first aspects.
In a sixth aspect, the present application provides a computer program product comprising a computer program which, when executed, implements the method for diagnosing a commission settlement problem according to any one of the first aspects.
According to the diagnosis method, the system, the equipment and the storage medium for the commission settlement problem, when a diagnosis instruction is received, a target original ticket file of a target diagnosis account period corresponding to an object to be diagnosed is obtained, aiming at an n+1th link in a plurality of links with sequence contained in the commission settlement, according to the output of the n+1th link contained in the commission settlement, the target original ticket file and the commission settlement rule corresponding to the n+1th link, first settlement data are obtained, verification is carried out on each link of the commission settlement based on the commission settlement rule and the target original ticket file respectively, compared with the first settlement data and the second settlement data, diagnosis results corresponding to the n+1th link are obtained, the settlement problem is refined to each link, so that the problem is positioned more accurately, in addition, when the diagnosis results reflect that the first settlement data and the second settlement data are inconsistent, diagnosis is terminated, namely, when any link is inconsistent, the first settlement data and the second settlement data are not consistent, the diagnosis time is not saved, and the problem positioning efficiency is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
FIG. 1 is an application scenario diagram of a commission settlement problem diagnosis method according to an embodiment of the present application;
FIG. 2 is a flow chart of a method for diagnosing commission settlement problems according to one embodiment of the present disclosure;
FIG. 3 is a schematic diagram of commission settlement rules corresponding to links in a commission settlement process according to one embodiment of the present application;
FIG. 4 is a schematic diagram of a diagnosis result corresponding to auditing in a diagnosis process of commission settlement according to an embodiment of the present application;
FIG. 5 is a schematic diagram showing sorting of corresponding diagnostic results in the diagnosis process of commission settlement according to one embodiment of the present application;
FIG. 6 is a schematic diagram showing a combination of corresponding diagnosis results in the diagnosis process of the commission settlement problem according to an embodiment of the present application;
FIG. 7 is a schematic diagram of a diagnosis result corresponding to a price in a diagnosis process of a commission settlement problem according to an embodiment of the present application;
FIG. 8 is a schematic diagram of a diagnosis result corresponding to a fee calculation in a diagnosis process of a commission settlement problem according to an embodiment of the present application;
FIG. 9 is a schematic diagram of a generating process of a ticket document snapshot according to an embodiment of the present application;
FIG. 10 is a schematic diagram of a commission settlement problem diagnosis device according to an embodiment of the present application;
fig. 11 is a schematic structural diagram of an electronic device according to an embodiment of the present application;
fig. 12 is a schematic structural diagram of a commission settlement problem diagnosis system according to an embodiment of the present application.
Specific embodiments thereof have been shown by way of example in the drawings and will herein be described in more detail. These drawings and the written description are not intended to limit the scope of the inventive concepts in any way, but to illustrate the concepts of the present application to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present application as detailed in the accompanying claims.
It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or fully authorized by each party, and the collection, use and processing of the related data need to comply with the related laws and regulations and standards, and provide corresponding operation entries for the user to select authorization or rejection.
In the related art, in the process of performing commission settlement according to an original ticket file, because the data volume involved in commission calculation is large, the calculation rule is large and the calculation flow is complex, when the commission calculation has a calculation error, the log file of the related commission calculation needs to be extracted from a settlement system, such as a channel centralized management system, and then a large number of log files are gradually checked according to the payment problem fed back by an agent, a large amount of time is required to be spent in a log checking mode, the checking efficiency is low, and a plurality of links involved in commission settlement are involved, so that the problem can not be locked quickly and accurately.
Aiming at the technical problems, the application provides a diagnosis method, a system, equipment and a storage medium for a commission settlement problem, when the commission settlement problem occurs, a target original ticket file of a target diagnosis account period corresponding to an object to be diagnosed is obtained, first settlement data of a current settlement link is obtained according to the target original ticket file and a commission settlement rule corresponding to the current settlement link, the first settlement data is compared with second settlement data obtained through calculation of a channel centralized management system, and when the first settlement data and the second settlement data are inconsistent, a diagnosis result is output, diagnosis is terminated, so that the purpose of rapidly and accurately finding out the problem is achieved.
The following describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 1 is an application scenario diagram of a commission settlement problem diagnosis method according to an embodiment of the present application. As shown in fig. 1, the application scenario includes a server 11, a server 12, a server 13, and a client 14, in this embodiment, the server 13 is used for diagnosing a commission settlement problem, specifically, the client 14 provides a diagnosis operation interface for a user, the client 14 corresponds to the server 13, that is, a diagnosis system of the commission settlement problem is deployed on the server 13, and the user acts on the client 14, that is, diagnosis of the commission settlement problem can be triggered; deploying peripheral systems on the server 11, including but not limited to CBSS, via subsystem, ECS, activity center, and revenue management system; a channel centralized management system is deployed on the server 12; the diagnosis system of the commission settlement problem on the server 13 is respectively in butt joint with a peripheral system on the server 11 and a channel centralized management system on the server 12, the peripheral system can periodically upload an original ticket file to the diagnosis system of the commission settlement problem, the diagnosis system stores the original ticket file in the form of a ticket file snapshot, and the diagnosis system of the commission settlement problem obtains a commission settlement log from the channel centralized management system, analyzes the commission settlement log to obtain a calculation result of the commission settlement process, and is used for relevant diagnosis of the commission settlement problem. For example, after receiving the commission payment problem fed back by a channel agent, the related technician issues a diagnosis operation for the agent feedback target diagnosis account period (the target diagnosis account period corresponding to the object to be diagnosed) through the client 14, the server 13 restores the target original ticket file according to the stored ticket file snapshot corresponding to the target original ticket file corresponding to the target diagnosis account period corresponding to the object to be diagnosed, obtains the calculation result of the commission settlement process from the server 12, performs related diagnosis of the commission settlement problem according to the target original ticket file and the calculation result of the commission settlement process, and feeds back the diagnosis result to the client 14 for the related technician to check.
Any two or three of the server 11, the server 12, and the server 13 may be the same device, and the number of the various devices is not limited. The server may also be replaced by a virtual resource, a host with a certain computing power, or a server cluster, etc., and the client 14 may be a wearable device, a mobile phone, a computer, a notebook, a personal digital assistant (Personal Digital Assistant, abbreviated as PDA), etc., which is not particularly limited in this application.
The following describes a method for diagnosing a commission settlement problem according to an embodiment of the present application with reference to fig. 2 in conjunction with the application scenario of fig. 1. The diagnosis method of the commission settlement problem is performed by the server 13 in fig. 1, and it should be noted that the above application scenario is only shown for the convenience of understanding the spirit and principle of the present application, and the embodiment of the present application is not limited by the application scenario shown in fig. 1.
Fig. 2 is a flow chart of a method for diagnosing commission settlement problems according to an embodiment of the present application. Referring to fig. 2, the commission settlement problem diagnosis method includes the steps of:
s201, receiving a diagnosis instruction, wherein the diagnosis instruction carries a target diagnosis account period and an object identification of an object to be diagnosed.
In the embodiment of the present application, the object identifier of the object to be diagnosed is used to indicate that the province score of the ticket file is generated, and the object identifier of the object to be diagnosed may be a province division company name, or a digital code, for example, xx province yy company, or 001 identifier xx province yy company, or the like; the target diagnostic billing period refers to a bill for a certain period of time, for example, 202310. The specific implementation manner of the object identification of the object to be diagnosed and the target diagnosis account period is not limited in this embodiment.
Illustratively, on the client 14 in fig. 1, a diagnosis interface for commission settlement is logged in, a target diagnosis account period and an object identifier of an object to be diagnosed are selected in an option box of the diagnosis interface, and a diagnosis instruction carrying the target diagnosis account period and the object identifier of the object to be diagnosed can be generated by clicking a "start diagnosis" button, and meanwhile, the diagnosis instruction is issued to a corresponding server, and the server receives the diagnosis instruction, for example, the server 13 in fig. 1 receives the diagnosis instruction.
Optionally, a target diagnosis account period and an object identifier of the object to be diagnosed can be added in the configuration file, the configuration file is uploaded to the diagnosis interface, then a diagnosis start button is clicked, and a diagnosis instruction carrying the target diagnosis account period and the object identifier of the object to be diagnosed is generated by loading configuration information in the configuration file.
S202, acquiring a target original ticket file of a target diagnosis account period corresponding to the object to be diagnosed.
For example, all original ticket files are uploaded to the server 13 through the peripheral system deployed on the server 11 in fig. 1 and stored, for example, the original ticket files are stored in folders named in the provincial account adding period, and the target original ticket files of the target diagnostic account corresponding to the target diagnostic account of the target to be diagnosed can be uniquely locked through the target diagnostic account carried in the diagnostic instruction and the object identification of the target to be diagnosed.
S203, aiming at the n+1 link in the links with the sequence contained in the commission settlement, obtaining first settlement data according to the output of the n link contained in the commission settlement, the target original ticket file and the commission settlement rule corresponding to the n+1 link, wherein the commission settlement rule is the same as the commission settlement rule corresponding to the n+1 link contained in the channel centralized management system.
In this step, for example, the enterprise may utilize the channel centralized management system to perform the operations of calculating and paying the commissions and subsidies of the channels of the branch companies nationwide according to a unified flow, and each commission settlement link includes a corresponding commission settlement rule, that is, based on the target original ticket document, performing the commission settlement according to the commission settlement rule.
Correspondingly, the diagnosis method of the commission settlement problem can be based on the target original ticket file, and the commission settlement rules corresponding to all links in the channel centralized management system are utilized to carry out the commission settlement for each link, and as the commission settlement process is carried out, all links have a sequence, and the calculation result of the next link depends on the previous link, for example, the calculation result of the previous link is abnormal, the calculation of the next link can be directly caused to be problematic, so that when the calculation result of the previous link is normal, the calculation of the next link is carried out, and therefore, the first settlement data can be obtained according to the output of the nth link, the target original ticket file and the commission settlement rules corresponding to the (n+1) th link, which are contained in the commission settlement.
In this embodiment, the commission settlement rules corresponding to each link may be stored in advance in the form of a configuration file in the local area of the client 14 in fig. 1, the user logs in to the diagnosis interface of the commission settlement problem on the client 14, selects the target diagnosis account period and the object identifier of the object to be diagnosed in the option box of the diagnosis interface, selects the local storage path of the configuration file, clicks the "start diagnosis" button, and can implement reading the commission settlement rules corresponding to each link from the configuration file, and obtain the target original ticket file corresponding to the target diagnosis account period of the object to be diagnosed, so as to calculate the first settlement data corresponding to each link.
S204, comparing the first settlement data with the second settlement data to obtain a diagnosis result corresponding to the (n+1) th link, wherein the second settlement data is obtained by the channel centralized management system, and the diagnosis result reflects that the first settlement data is consistent with the second settlement data or the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data.
Illustratively, the diagnosis system for commission settlement problems deployed on the server 13 in fig. 1 interfaces with the channel centralized management system, and a commission settlement log for a target diagnosis account period corresponding to the object to be diagnosed can be obtained from the channel centralized management system, and the commission settlement log is parsed to obtain second settlement data. Integrating a third party comparison tool in a diagnosis system of the commission settlement problem, or comparing the first settlement data with the second settlement data by means of software programs and the like to obtain a diagnosis result corresponding to the n+1th link, wherein the diagnosis result reflects whether the first settlement data and the second settlement data are consistent or not, if so, the commission calculation of the n+1th link in the channel centralized management system is correct, and if not, the commission calculation of the n+1th link in the channel centralized management system is abnormal.
And S205, if the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, stopping diagnosis, and outputting the diagnosis result corresponding to the (n+1) th link.
When the first settlement data and the second settlement data are inconsistent, namely abnormal commission calculation occurs in the (n+1) th link in the channel centralized management system, diagnosis is terminated at the moment, that is, the problem of commission payment error caused by abnormal calculation occurs in the (n+1) th link is already located, and a diagnosis result corresponding to the (n+1) th link is output for the user to review.
According to the method and the device, the first calculation data are obtained by calculating each link of the commission settlement based on the commission settlement rules and the target original ticket file, the first settlement data are compared with the second settlement data obtained from the channel centralized management system, the diagnosis results corresponding to the current links are obtained, the settlement problems are refined to each link, so that the problem positioning is more accurate, in addition, when the diagnosis results reflect that the first settlement data are inconsistent with the second settlement data, the diagnosis is terminated, the diagnosis results corresponding to the current links are output, namely, the diagnosis is terminated in time when the first settlement data are inconsistent with the second settlement data in any link, the diagnosis time of the commission settlement problem is saved, and the problem positioning efficiency is improved. In addition, since the commission rule used in the diagnosis method of the commission settlement problem is consistent with the commission rule in the channel centralized management system, a reliable basis can be provided for the adjustment of the commission rule involved in the commission calculation flow of the channel centralized management system.
In one possible implementation manner, the links with the sequence included in the commission settlement are sequentially auditing, sorting, merging, rating and calculating fees, and correspondingly, according to the output of the nth link included in the commission settlement, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, the first settlement data is obtained, which is specifically divided into the following cases:
in the first case, if the link is audit, the commission settlement rule corresponding to the audit is a check rule, the second settlement data is an audit check result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, and the first settlement data includes: and carrying out auditing verification on the target original ticket file according to the verification rule to obtain an auditing verification result as first settlement data.
It can be understood that after the target original ticket file is collected, condition judgment, i.e. auditing, is performed on the target original ticket file by using a verification rule, for example, the object to be diagnosed: a division a, target diagnosis account period: 202310, collecting the checking rules of audit as shown in fig. 3 (a), including: provincial and regional service verification, drainage verification, channel service verification and developer service verification.
In a second case, if the link is sorting, sorting the corresponding commission settlement rule as a sorting rule, and the second settlement data is a sorting result obtained by the channel centralized management system, and obtaining first settlement data according to the output of the nth link, the target original ticket file, and the commission settlement rule corresponding to the (n+1) th link, where the commission settlement includes: and classifying and storing the target original ticket file according to the sorting rule to obtain a sorting result as first settlement data.
It can be understood that, after the inspection, the sorting is performed on the objective original ticket file after the inspection by using a sorting rule, where the sorting rule is shown in fig. 3 (b), and includes: file type, file name, distribution directory, and filter criteria, e.g., according to the file type, the file is a memory file with the file name of xxx_xxx_xxx the distribution catalog is $ (YYY)/YYY/YYY and the filtering condition is RRR (AAA) to store the target original ticket file in a classified way, and obtaining a sorting result.
In a third case, if the links are merging, merging the corresponding commission settlement rules are merging rules, and the second settlement data is a composite ticket obtained by the channel centralized management system, and obtaining first settlement data according to the output of the nth link, the target original ticket file and the commission settlement rules corresponding to the (n+1) th link, wherein the output of the nth link is included in the commission settlement, and the first settlement data comprises: and merging the sorted file data according to the merging rule to generate a composite ticket as first settlement data.
It can be understood that the merging is to merge the target original ticket file information meeting the condition after sorting without error according to a merging rule, and the merging rule is as shown in fig. 3 (c), and includes: interface name, data type, field name and field length, for example, according to interface name xx interface, data type xx_xxx, field name xxx and field length 6, combining file data meeting the condition to generate composite ticket
In the fourth case, if the link is a rating, the second settlement data is a rating result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, including: analyzing the composite ticket to extract channel related data, and integrating integral data and proportion data of the channel to obtain a rating result as first settlement data.
It can be understood that the rating is to analyze the generated composite ticket information, accumulate channel-level indexes, generate the fee-counting worksheet, and calculate the commission at the user level after merging, i.e. the rating result comprises accumulated integral data and accumulated proportion data corresponding to the channel.
In a fifth aspect, if the link is a fee calculation, the second settlement data is a fee calculation result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file, and the fee settlement rule corresponding to the (n+1) th link, where the fee settlement includes: and performing commission calculation on the priced data, generating at least one of an agent bill and a developer bill, and obtaining a fee calculation result as first settlement data.
It will be appreciated that the fee calculation is to analyze the fee calculation work order generated by the price after the price is correct, and to perform the commission calculation and the payment data generation, i.e. the fee calculation result includes at least one of commission, agent bill and developer bill.
Accordingly, the diagnosis result of the commission settlement problem will be described with reference to fig. 4 to 8.
In some embodiments, if the link is audit, the diagnostic result includes a differential audit verification rule, a verification result of the commission settlement process, and a verification result of the diagnostic process.
Fig. 4 is a schematic diagram of a diagnosis result corresponding to auditing in a commission settlement process according to an embodiment of the present application, as shown in fig. 4, a verification rule is input in an auditing module, an auditing verification is performed on a target original ticket file, the verification result (first settlement data) is compared with a commission calculation process auditing result (second settlement data), if there is no difference, the next module is continuously executed, if there is a difference, the comparison result is output, and, for example, the comparison result is displayed in a list form, information displayed in the list is a difference auditing verification rule, a commission settlement process verification result, and a diagnosis process verification result, thereby determining that the location of the commission settlement process problem is the auditing module, and a specific problem is that the verification rule verification process displayed in the difference list has a problem.
If the link is sorting, the diagnosis result comprises a file name with difference, a commission settlement flow distribution catalog and a diagnosis flow distribution catalog.
Fig. 5 is a schematic diagram of a diagnosis result corresponding to sorting in a commission settlement problem diagnosis process according to an embodiment of the present application, as shown in fig. 5, a sorting rule is input in a sorting module, a sorting result (first settlement data) is sorted and stored in a sorting module, and compared with a commission calculation flow sorting result (second settlement data), if there is no difference, the next module is continuously executed, if there is a difference, the comparison result is output, and, for example, the comparison result is displayed in a list form, where information displayed in the list is a file name with a difference, a commission settlement flow distribution catalog, and a diagnosis flow distribution catalog, so that a position where the commission settlement flow problem is located is determined as the sorting module, and a specific problem is that the sorting file displayed in the difference list has a problem.
If the links are merging, the diagnosis result comprises a differential interface name, a data type and a field name.
Fig. 6 is a schematic diagram of merging corresponding diagnostic results in the diagnosis process of the commission settlement problem provided in an embodiment of the present application, as shown in fig. 6, a merging rule is input in a merging module, the sorted file data is merged according to the rule to generate a composite ticket, the generated composite ticket (first settlement data) is compared with a composite ticket (second settlement data) generated by the commission settlement process, if there is no difference, the next module is continuously executed, if there is no difference, a comparison result is output, and, for example, the comparison result is displayed in a list form, and information displayed in the list is a differential interface name, a data type and a field name, so that it is determined that the commission settlement process problem occurs in the merging module, and a specific problem is that the data merging displayed in the difference list has a problem.
If the link is the price, the diagnosis result comprises the channel name with difference, the accumulated value of the integral data and the accumulated value of the proportion data.
Fig. 7 is a schematic diagram of a diagnosis result corresponding to a price in a diagnosis process of a commission settlement problem according to an embodiment of the present application, and as shown in fig. 7, the composite ticket generated by the merging module is parsed, channel related data is extracted, and integration data accumulation and proportion data accumulation are performed on channels. Comparing the rating result (first settlement data) with the rating result (second settlement data) of the commission settlement process, if no difference exists, continuing to execute the next module, and if difference exists, outputting the comparison result, wherein the comparison result is displayed in a list form, and the information displayed in the list is the differential channel name, the accumulated value of the integral data and the accumulated value of the proportional data, so that the commission settlement process problem is determined to occur in the rating module, and the specific problem is that the rating module has a problem when the integral data accumulation and the proportional data accumulation are carried out.
If the link is a fee calculation, the diagnosis result includes at least one of commission, agent bill and developer bill.
Fig. 8 is a schematic diagram of a diagnosis result corresponding to a fee calculation in a diagnosis process of a fee settlement problem according to an embodiment of the present application, as shown in fig. 8, the fee calculation is performed on the rated data, an agent bill and a developer bill are generated, the result (first settlement data) after the fee calculation is compared with the fee calculation result (second settlement data) of the fee settlement process, if there is no difference, the next module is continuously executed, if there is a difference, the comparison result is output, and, for example, the comparison result is displayed in a list form, and information displayed in the list is the fee, the agent bill and the developer bill, so that it is determined that the fee settlement process problem occurs in the fee calculation module, and particularly, the fee calculation module has a problem in calculating the fee, generating the agent bill and the developer bill.
According to the embodiment of the application, the contents contained in the diagnosis results of all links in the commission settlement are contracted, and after a problem occurs in diagnosis of a certain link, the diagnosis results can provide clear investigation basis for a user, so that the method and the device are convenient to use for determining the problem, and the investigation efficiency of the problem is improved.
In some embodiments, the outputting the diagnosis result corresponding to the n+1th link may include the following possible implementation manners:
in the first implementation manner, the diagnosis result corresponding to the (n+1) th link is displayed on a diagnosis interface.
Still referring to the diagnosis results shown in each link in the diagnosis process of the commission settlement problem in fig. 4 to 8, the diagnosis results are displayed on the diagnosis interface, so that the user can conveniently check.
In a second implementation, a link to a diagnostic report is displayed in a diagnostic interface, the diagnostic report containing the diagnostic result.
For example, after the comparison of the first settlement data and the second settlement data corresponding to the (n+1) th link is completed, the difference point (i.e. the diagnosis result) may be saved in a link form, and the diagnosis report may be downloaded by clicking the link, so as to further view the diagnosis result.
Alternatively, the diagnosis result corresponding to the n+1th link may be displayed on the diagnosis interface, and the link of the diagnosis report may be displayed on the diagnosis interface.
According to the embodiment of the application, the visual interface is used for outputting the diagnosis result, so that the method is simple, visual and easy to use, and the efficiency of problem investigation is improved.
Based on any of the foregoing embodiments, in some embodiments, the obtaining the target original ticket file corresponding to the target diagnostic accounting period of the object to be diagnosed may include:
and step 1-1, pulling a target ticket file snapshot of a target diagnostic account period corresponding to the object to be diagnosed from an HDFS server through a data warehouse, wherein a version list is stored in the data warehouse, the ticket file snapshot corresponding to the version list is stored in the HDFS server, and an original ticket file corresponding to the ticket file snapshot is generated by a peripheral system and is stored in an SFTP server.
For example, after receiving the diagnosis instruction, the dispatching center issues a notification to the data warehouse to obtain a target ticket file snapshot of the target diagnosis account period corresponding to the object to be diagnosed, the data warehouse may be understood as a ticket file snapshot management center, a list including the ticket file snapshot versions of all account periods is stored in the data warehouse, the ticket file snapshots of all account periods are stored in the HDFS, for example, a commission settlement of the 202310 th account period of the xx province yy division company is problematic, after starting the diagnosis process, the dispatching center notifies the data warehouse to pull the ticket file snapshot of the 202310 th account period of the xx province yy division company from the HDFS server, and at the same time, the pulled record or log may be stored in the data warehouse for a subsequent user to view.
And step 1-2, recovering the original target ticket file according to the snapshot of the target ticket file.
The data warehouse pulls a target ticket file snapshot of the target diagnostic account period corresponding to the object to be diagnosed from the HDFS server, can be stored in a database of a diagnosis system of the commission settlement problem, and restores the target ticket file snapshot into a target original ticket file for diagnosis of the commission settlement problem, and reads the target original ticket file from the database when diagnosis of the commission settlement problem is performed.
Optionally, the data warehouse pulls a target ticket file snapshot of the object to be diagnosed corresponding to the target diagnosis account period from the HDFS server, restores the target original ticket file according to the target ticket file snapshot, and sends the target ticket file snapshot to the computing host executing the diagnosis method of the commission settlement problem for diagnosing the commission settlement problem.
According to the method and the device for recovering the target original ticket file, the list of the ticket file snapshot in each account period is stored in the data warehouse, when problems occur in the commission settlement process or errors occur in data calculation, the target original ticket file is recovered by pulling the target ticket file snapshot from the HDFS through the data warehouse, commission settlement is carried out again, and loss of the target original ticket file caused by misoperation or malicious deletion can be effectively prevented. Meanwhile, the data warehouse enables the storage and the reading of the original ticket files to be flexible and convenient.
Further, as shown in fig. 9, which is a schematic diagram of a generation flow of a ticket file snapshot according to an embodiment of the present application, the ticket file snapshot is obtained by:
and 2-1, the version control center responds to monitoring that the peripheral system uploads the original ticket file to the SFTP server, and determines whether the original ticket file is a new version or not.
This step corresponds to step 1 and step 2 in fig. 9.
In step 2-1, the original ticket file is a 38-class file uploaded to the SFTP server by the peripheral system, for example, the user class and payment class ticket file is uploaded from the CBSS system to the SFTP server, for example, the original ticket file is saved according to the province, the account period and the version classification. The SFTP server only stores the current accounting period file, that is, the object identifier (province score) of the same object to be diagnosed, only stores the last original ticket file uploaded from the peripheral system, for example, the original ticket file of the 202309 accounting period for the xx province yy division company is uploaded in the morning at 10 month 15 in 2023, the version number is V1.0, the original ticket file corresponding to the province score, account period and version is uploaded to the SFTP server, the original ticket file of the V1.0 version is finally stored in the form of a ticket file snapshot in the HDFS server through the data warehouse, then the record on the SFTP server is emptied, because the original ticket file of the account period has errors, the original ticket file needs to be retransmitted, the original ticket file of the 202309 accounting period for the xx province yy division company is uploaded in the afternoon at 10 month 15 in 2023, the original ticket file of V1.1 is monitored, when the version control center uploads the original ticket file to the peripheral system, the original ticket file of the version number is carried by the corresponding to the V1 version number, and the version number is compared with the version number of the original ticket file of the V1, and the version number of the original ticket file is stored in the data warehouse has the same version number as the corresponding to the version 1.
And 2-2, if the version is the new version, the version control center transmits notification information to the task scheduling center, and the task scheduling center is used for executing a diagnosis method of the commission settlement problem.
This step corresponds to step 3 in fig. 9.
And under the condition that the new version is determined, the version control center issues notification information for storing the snapshot of the new version ticket file to the task scheduling center.
And 2-3, the task scheduling center responds to the received notification information and sends the version snapshot backup task of the original ticket file uploaded by the peripheral system to the data warehouse.
This step corresponds to step 4 in fig. 9.
And 2-4, responding to the received version snapshot backup task, the data warehouse acquires the original ticket file uploaded by the peripheral system from the SFTP server, generates a ticket file snapshot corresponding to the original ticket file, and stores the ticket file snapshot to the HDFS server.
This step corresponds to step 5 and step 6 in fig. 9.
Alternatively, according to the actual usage scenario or requirement, the account period number stored in the data warehouse and the HDFS server may be set, for example, information of a ticket file snapshot corresponding to the original ticket file of 12 months in the current year is stored, or information of a ticket file snapshot corresponding to the original ticket file of the last half year is stored, which is not particularly limited in this application.
According to the embodiment of the application, the original ticket files uploaded by the peripheral system are stored in the HDFS server in the form of the ticket file snapshot to be backed up, and in the related technology, the original ticket files are stored in the SFTP server to be backed up, file backup deletion can be generated due to misoperation in the process of backing up the original ticket files, or after the files are backed up to the related catalogues on the SFTP, hackers or virus attack is easy to occur, and compared with the situation that the files are maliciously deleted or destroyed, the embodiment of the application is stored in the form of the ticket file snapshot, so that the safety of the backup files is improved to a certain extent, and the safety performance of the HDFS server is superior to that of the SFTP server, and the safety of the backup files is further enhanced.
Fig. 10 is a schematic structural diagram of a commission settlement device according to an embodiment of the present application. As shown in fig. 10, the commission settlement problem diagnosis device 100 includes: a receiving module 101, an obtaining module 102, a determining module 103, a diagnosing module 104 and an outputting module 105. Wherein:
the receiving module 101 is configured to receive a diagnosis instruction, where the diagnosis instruction carries a target diagnosis account period and an object identifier of an object to be diagnosed;
The acquisition module 102 is used for acquiring a target original ticket file of a target diagnosis account period corresponding to the object to be diagnosed;
a determining module 103, configured to obtain, for an n+1th link of the multiple links with a sequence included in the commission settlement, first settlement data according to an output of the n link included in the commission settlement, a target original ticket file, and a commission settlement rule corresponding to the n+1th link, where the commission settlement rule is the same as a commission settlement rule corresponding to the n+1th link included in the channel centralized management system;
the diagnosis module 104 is configured to compare the first settlement data with the second settlement data, and obtain a diagnosis result corresponding to the (n+1) th link, where the second settlement data is obtained by the channel centralized management system, and the diagnosis result reflects that the first settlement data is consistent with the second settlement data, or that the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data;
and the output module 105 is used for terminating the diagnosis when the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, and outputting the diagnosis result corresponding to the (n+1) th link.
In one possible implementation, the multiple links with the sequence included in the commission settlement are sequentially auditing, sorting, merging, pricing and billing, where: if the link is audit, the commission settlement rule corresponding to the audit is a check rule, the second settlement data is an audit check result obtained by the channel centralized management system, and the determining module 103 is specifically configured to: according to the verification rule, auditing and checking the target original ticket file to obtain an auditing and checking result as first settlement data; if the link is sorting, the sorting corresponding commission settlement rule is a sorting rule, the second settlement data is a sorting result obtained by the channel centralized management system, and the determining module 103 is further configured to: classifying and storing the target original ticket file according to the sorting rule to obtain a sorting result as first settlement data; if the link is merging, the corresponding commission settlement rule is merging rule, and the second settlement data is a composite ticket obtained by the channel centralized management system, the determining module 103 is further configured to: merging the sorted file data according to a merging rule to generate a composite ticket as first settlement data; if the link is rating, the second settlement data is rating result obtained by the channel centralized management system, and the determining module 103 is further configured to: analyzing the composite ticket to extract channel related data, and integrating integral data and proportion data of the channel to obtain a rating result as first settlement data; if the link is fee calculation, the second settlement data is a fee calculation result obtained by the channel centralized management system, and the determining module 103 is further configured to: and performing commission calculation on the priced data, generating at least one of an agent bill and a developer bill, and obtaining a fee calculation result as first settlement data.
In one possible implementation, if the link is audit, the diagnosis result includes a differential audit verification rule, a commission settlement process verification result, and a diagnosis process verification result; if the link is sorting, the diagnosis result comprises a file name with difference, a commission settlement flow distribution directory and a diagnosis flow distribution directory; if the links are merging, the diagnosis result comprises a differential interface name, a data type and a field name; if the link is the price, the diagnosis result comprises a channel name with difference, a value accumulated by integral data and a value accumulated by proportion data; if the link is a fee calculation, the diagnosis result includes at least one of commission, agent bill and developer bill.
In one possible implementation, the obtaining module 102 is specifically configured to: pulling a target ticket file snapshot of a target diagnostic account period corresponding to an object to be diagnosed from an HDFS server through a data warehouse, wherein a version list is stored in the data warehouse, the ticket file snapshot corresponding to the version list is stored in the HDFS server, and an original ticket file corresponding to the ticket file snapshot is generated by a peripheral system and is stored in an SFTP server; and recovering the original target ticket file according to the target ticket file snapshot.
In one possible implementation, the ticket file snapshot is obtained by: the version control center responds to monitoring that the peripheral system uploads an original ticket file to the SFTP server, and determines whether the original ticket file is a new version or not; if the new version is the new version, the version control center issues notification information to the task scheduling center, and the task scheduling center is used for executing a diagnosis method of the commission settlement problem; the task scheduling center responds to the received notification information and sends a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse; and the data warehouse responds to receiving the version snapshot backup task, acquires the original ticket file uploaded by the peripheral system from the SFTP server, generates a ticket file snapshot corresponding to the original ticket file, and stores the ticket file snapshot to the HDFS server.
In one possible implementation, the output module 105 is specifically configured to: displaying a diagnosis result corresponding to the (n+1) th link on a diagnosis interface; and/or, in the diagnostic interface, displaying a link to a diagnostic report, the diagnostic report comprising the diagnostic result.
The diagnosis device for the commission settlement problem provided in the embodiment of the present application may execute the technical solution shown in the foregoing method embodiment, and its implementation principle and beneficial effects are similar, and will not be described in detail.
Fig. 11 is a schematic structural diagram of an electronic device according to an embodiment of the present application. As shown in fig. 11, the electronic device 110 includes: at least one processor 111 and a memory 112. The memory 112 is used for storing instructions, and the processor 111 is used for calling the instructions in the memory to execute the method steps provided in the above embodiment, and detailed implementation and technical effects are similar, and are not repeated herein.
Alternatively, the memory 112 may be separate or integrated with the processor 111.
The memory 112 may include random access memory (Random Access Memory, simply RAM) and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.
The processor 111 may be a general-purpose processor, including a central processing unit, a network processor (Network Processor, NP) and the like; digital signal processors (Digital Signal Processor, DSP for short), application specific integrated circuits (Application Specific Integrated Circuit, ASIC for short), field programmable gate arrays (Field Programmable Gate Array, FPGA for short) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
Optionally, the electronic device 110 may also include a communication interface 113. In a specific implementation, if the communication interface 113, the memory 112, and the processor 111 are implemented independently, the communication interface 113, the memory 112, and the processor 111 may be connected to each other and perform communication with each other through buses. The system bus may be a peripheral component interconnect standard (Peripheral Component Interconnect, PCI) bus, or an extended industry standard architecture (Extended Industry Standard Architecture, EISA) bus, among others. The system bus may be divided into an address bus, a data bus, a control bus, etc., but does not represent only one bus or one type of bus.
Alternatively, in a specific implementation, if the communication interface 113, the memory 112, and the processor 111 are integrated on a chip, the communication interface 113, the memory 112, and the processor 111 may complete communication through internal interfaces.
The implementation principle and technical effects of the electronic device provided in this embodiment may be referred to the foregoing embodiments, and will not be described herein again.
Fig. 12 is a schematic structural diagram of a commission settlement problem diagnosis system according to an embodiment of the present application. As shown in fig. 12, the commission settlement problem diagnosis system 120 includes: SFTP server 121, version control center 122, task scheduling center 123, data warehouse 124, and HDFS server 125, wherein:
An SFTP server 121 for storing an original ticket file generated and uploaded by the peripheral system;
the version control center 122 is configured to determine whether the original ticket file is a new version in response to monitoring that the peripheral system uploads the original ticket file to the SFTP server 121; if the new version is the new version, the notification information is issued to the task scheduling center;
a task scheduling center 123 for transmitting a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse in response to receiving the notification information, and performing the diagnosis method of the commission settlement problem according to any one of the above-described method embodiments;
and the data repository 124 is configured to obtain, from the SFTP server 121, an original ticket file uploaded by the peripheral system in response to receiving the version snapshot backup task, generate a ticket file snapshot corresponding to the original ticket file, and store the ticket file snapshot to the HDFS server 125.
Optionally, the commission settlement problem diagnosis system 120 further includes an RDS126, and the RDS126 is configured to store version information of the original ticket file generated by the version control center 122.
Optionally, the peripheral systems include, but are not limited to, CBSS for generating original ticket files for the user class and the payment class, via the subsystem for generating original ticket files for the business usage and user detail information, ECS for generating original ticket files for the card sales information, ECS for generating original ticket files for the user electronic ticket information, an activity center for generating original ticket files for the billing revenue duty cycle information, and a revenue management system for generating original ticket files for the billing revenue duty cycle information.
The implementation principle and technical effects of the commission settlement problem diagnosis system provided in this embodiment can be referred to the foregoing embodiments, and will not be described herein.
The present application further provides a computer readable storage medium, where computer executable instructions are stored, where the computer executable instructions are used to implement a method for diagnosing a commission settlement problem according to any one of the foregoing method embodiments, and specific implementation manner and technical effects are similar, and are not repeated herein.
Embodiments of the present application also provide a program product comprising computer-executable instructions. When the computer-executed instructions are executed to implement the method steps in the method embodiments described above, the specific implementation manner and technical effects are similar, and will not be described herein again.
It should be noted that, for simplicity of description, the foregoing method embodiments are all expressed as a series of action combinations, but it should be understood by those skilled in the art that the present application is not limited by the order of actions described, as some steps may be performed in other order or simultaneously in accordance with the present application. Further, those skilled in the art will also appreciate that the embodiments described in the specification are all alternative embodiments, and that the acts and modules referred to are not necessarily required in the present application.
It should be further noted that, although the steps in the flowchart are sequentially shown as indicated by arrows, the steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least a portion of the steps in the flowcharts may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order in which the sub-steps or stages are performed is not necessarily sequential, and may be performed in turn or alternately with at least a portion of the sub-steps or stages of other steps or other steps.
It should be understood that the above-described device embodiments are merely illustrative, and that the device of the present application may be implemented in other ways. For example, the division of the units/modules in the above embodiments is merely a logic function division, and there may be another division manner in actual implementation. For example, multiple units, modules, or components may be combined, or may be integrated into another system, or some features may be omitted or not performed.
In addition, each functional unit/module in each embodiment of the present application may be integrated into one unit/module, or each unit/module may exist alone physically, or two or more units/modules may be integrated together, unless otherwise specified. The integrated units/modules described above may be implemented either in hardware or in software program modules.
The integrated units/modules, if implemented in hardware, may be digital circuits, analog circuits, etc. Physical implementations of hardware structures include, but are not limited to, transistors, memristors, and the like. The processor may be any suitable hardware processor, such as CPU, GPU, FPGA, DSP and ASIC, etc., unless otherwise specified. Unless otherwise indicated, the storage elements may be any suitable magnetic or magneto-optical storage medium, such as resistive Random Access Memory RRAM (Resistive Random Access Memory), dynamic Random Access Memory DRAM (Dynamic Random Access Memory), static Random Access Memory SRAM (Static Random-Access Memory), enhanced dynamic Random Access Memory EDRAM (Enhanced Dynamic Random Access Memory), high-Bandwidth Memory HBM (High-Bandwidth Memory), hybrid Memory cube HMC (Hybrid Memory Cube), etc.
The integrated units/modules may be stored in a computer readable memory if implemented in the form of software program modules and sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a memory, including several instructions for causing a computer device (which may be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the methods of the embodiments of the present application. And the aforementioned memory includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and for parts of one embodiment that are not described in detail, reference may be made to related descriptions of other embodiments. The technical features of the foregoing embodiments may be arbitrarily combined, and for brevity, all of the possible combinations of the technical features of the foregoing embodiments are not described, however, all of the combinations of the technical features should be considered as being within the scope of the disclosure.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the application following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the application pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It is to be understood that the present application is not limited to the precise arrangements and instrumentalities shown in the drawings, which have been described above, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the application is limited only by the appended claims.
Claims (10)
1. A method for diagnosing a commission settlement problem, comprising:
receiving a diagnosis instruction, wherein the diagnosis instruction carries a target diagnosis account period and an object identification of an object to be diagnosed;
acquiring a target original ticket file of the object to be diagnosed corresponding to the target diagnosis account period;
aiming at an n+1 link in a plurality of links with sequence contained in the commission settlement, obtaining first settlement data according to the output of the n link contained in the commission settlement, the target original ticket file and a commission settlement rule corresponding to the n+1 link, wherein the commission settlement rule is the same as the commission settlement rule corresponding to the n+1 link contained in the channel centralized management system;
Comparing the first settlement data with the second settlement data to obtain a diagnosis result corresponding to the (n+1) th link, wherein the second settlement data is obtained by the channel centralized management system, and the diagnosis result reflects that the first settlement data is consistent with the second settlement data or the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data;
if the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, diagnosis is terminated, and a diagnosis result corresponding to the (n+1) th link is output.
2. The method of claim 1, wherein the plurality of links in a sequence included in the commission settlement are sequentially auditing, sorting, merging, rating, and billing, wherein:
if the link is audit, the commission settlement rule corresponding to the audit is a check rule, the second settlement data is an audit check result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, and the method comprises the following steps: performing audit verification on the target original ticket file according to the verification rule to obtain an audit verification result which is the first settlement data;
If the link is sorting, sorting the corresponding commission settlement rule as a sorting rule, wherein the second settlement data is a sorting result obtained by the channel centralized management system, and obtaining first settlement data according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, the first settlement data comprises: classifying and storing the target original ticket file according to the sorting rule to obtain a sorting result which is the first settlement data;
if the links are merging, and the corresponding commission settlement rules are merging rules, the second settlement data is a composite ticket obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rules corresponding to the (n+1) th link, which are included in the commission settlement, and the first settlement data comprises: merging the sorted file data according to the merging rule to generate a composite ticket as the first settlement data;
if the link is a rating, the second settlement data is a rating result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, and includes: analyzing the composite ticket to extract channel related data, and integrating integral data and proportion data of the channel to obtain a rating result as the first settlement data;
If the link is a fee calculation, the second settlement data is a fee calculation result obtained by the channel centralized management system, and the first settlement data is obtained according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, and includes: and performing commission calculation on the priced data, generating at least one of an agent bill and a developer bill, and obtaining a fee calculation result as the first settlement data.
3. The method for diagnosing a commission settlement problem according to claim 2, wherein:
if the link is audit, the diagnosis result comprises a differential audit verification rule, a commission settlement flow verification result and a diagnosis flow verification result;
if the link is sorting, the diagnosis result comprises a file name with difference, a commission settlement flow distribution catalog and a diagnosis flow distribution catalog;
if the links are merging, the diagnosis result comprises a differential interface name, a data type and a field name;
if the link is the price, the diagnosis result comprises a channel name with difference, a value accumulated by integral data and a value accumulated by proportion data;
If the link is a fee calculation, the diagnosis result comprises at least one of commission, agency bill and developer bill.
4. A method of diagnosing a commission settlement problem according to any one of claims 1 to 3, wherein the acquiring the target original ticket file of the object to be diagnosed corresponding to the target diagnostic accounting period comprises:
pulling a target ticket file snapshot of the object to be diagnosed corresponding to the target diagnosis account period from a Hadoop Distributed File System (HDFS) server through a data warehouse, wherein a version list is stored in the data warehouse, the ticket file snapshot corresponding to the version list is stored in the HDFS server, and an original ticket file corresponding to the ticket file snapshot is generated by a peripheral system and is stored in a secure file information transmission System (SFTP) server;
and recovering the target original ticket file according to the target ticket file snapshot.
5. The method of claim 4, wherein the ticket document snapshot is obtained by:
the version control center responds to monitoring that the peripheral system uploads an original ticket file to the SFTP server, and determines whether the original ticket file is a new version or not;
If the version is the new version, the version control center transmits notification information to a task scheduling center, and the task scheduling center is used for executing the diagnosis method of the commission settlement problem;
the task scheduling center responds to the receiving of the notification information and sends a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse;
and the data warehouse responds to receiving the version snapshot backup task, acquires the original ticket file uploaded by the peripheral system from the SFTP server, generates a ticket file snapshot corresponding to the original ticket file, and stores the ticket file snapshot to the HDFS server.
6. A commission settlement method as claimed in any one of claims 1 to 3, wherein the outputting of the diagnosis result corresponding to the (n+1) -th link comprises:
displaying a diagnosis result corresponding to the (n+1) th link on a diagnosis interface;
and/or, in a diagnostic interface, displaying a link to a diagnostic report, the diagnostic report comprising the diagnostic result.
7. A commission settlement problem diagnosis device, comprising:
the receiving module is used for receiving a diagnosis instruction, wherein the diagnosis instruction carries a target diagnosis account period and an object identification of an object to be diagnosed;
The acquisition module is used for acquiring a target original ticket file of the object to be diagnosed corresponding to the target diagnosis account period;
the determining module is used for obtaining first settlement data according to the output of the nth link, the target original ticket file and the commission settlement rule corresponding to the (n+1) th link, which are included in the commission settlement, in the plurality of links with the sequence, wherein the commission settlement rule is the same as the commission settlement rule corresponding to the (n+1) th link which is included in the channel centralized management system;
the diagnosis module is used for comparing the first settlement data with the second settlement data to obtain a diagnosis result corresponding to the (n+1) th link, the second settlement data is obtained by the channel centralized management system, the diagnosis result reflects that the first settlement data is consistent with the second settlement data, or the diagnosis result reflects that the first settlement data is inconsistent with the second settlement data;
and the output module is used for stopping diagnosis when the diagnosis result reflects that the first settlement data and the second settlement data are inconsistent, and outputting the diagnosis result corresponding to the (n+1) th link.
8. An electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
the memory is used for storing computer execution instructions;
the processor for executing the computer-executable instructions to implement the method of diagnosing a commission settlement problem as claimed in any one of claims 1 to 6.
9. A commission settlement problem diagnosis system, comprising: the system comprises a secure file information transmission system SFTP server, a version control center, a task scheduling center, a data warehouse and a Hadoop distributed file system HDFS server, wherein:
the SFTP server is used for storing an original ticket file generated and uploaded by the peripheral system;
the version control center is used for responding to the monitoring that the peripheral system uploads an original ticket file to the SFTP server and determining whether the original ticket file is a new version or not; if the new version is the new version, sending notification information to the task scheduling center;
the task scheduling center for transmitting a version snapshot backup task for the original ticket file uploaded by the peripheral system to the data warehouse in response to receiving the notification information, and performing the diagnosis method of the commission settlement problem according to any one of claims 1 to 6;
And the data warehouse is used for responding to the received snapshot backup task of the version, acquiring the original ticket file uploaded by the peripheral system from the SFTP server, generating a ticket file snapshot corresponding to the original ticket file and storing the ticket file snapshot to the HDFS server.
10. A computer-readable storage medium having stored therein computer-executable instructions that when executed are adapted to implement the method of diagnosing commission settlement problems as claimed in any one of claims 1 to 6.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311446465.5A CN117474696A (en) | 2023-11-01 | 2023-11-01 | Diagnosis method, system, equipment and storage medium for commission settlement problem |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311446465.5A CN117474696A (en) | 2023-11-01 | 2023-11-01 | Diagnosis method, system, equipment and storage medium for commission settlement problem |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117474696A true CN117474696A (en) | 2024-01-30 |
Family
ID=89634406
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202311446465.5A Pending CN117474696A (en) | 2023-11-01 | 2023-11-01 | Diagnosis method, system, equipment and storage medium for commission settlement problem |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117474696A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN117952620A (en) * | 2024-03-27 | 2024-04-30 | 广州易尊网络科技股份有限公司 | Commission settlement method and system for restoring online rate of statement based on data processing |
-
2023
- 2023-11-01 CN CN202311446465.5A patent/CN117474696A/en active Pending
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN117952620A (en) * | 2024-03-27 | 2024-04-30 | 广州易尊网络科技股份有限公司 | Commission settlement method and system for restoring online rate of statement based on data processing |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
KR102033971B1 (en) | Data quality analysis | |
CN111078140B (en) | Nuclear power station file uploading management method and device, terminal equipment and medium | |
US10511453B2 (en) | Information processing system and charge calculation apparatus | |
CN111797019B (en) | Transaction accounting test method and device, electronic equipment and storage medium | |
CN110060139B (en) | Accounting processing method and device | |
CN117474696A (en) | Diagnosis method, system, equipment and storage medium for commission settlement problem | |
CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
CA2895033A1 (en) | System and method for financial transaction management | |
CN112668303A (en) | Data processing method, device, equipment and storage medium | |
CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
CN111045935A (en) | Automatic version auditing method, device, equipment and storage medium | |
CN114840527A (en) | Data processing method, device and computer readable storage medium | |
CN113420057A (en) | Account checking data processing method and related device | |
CN116167860A (en) | Account checking processing method and device, electronic equipment and storage medium | |
CN113609011B (en) | Testing method, device, medium and equipment of insurance product factory | |
US11200102B1 (en) | System for tracking transaction data across applications | |
RU2745340C2 (en) | Virtual marketplace for distributed tools in an enterprise environment | |
US11663087B2 (en) | Validating metering of a disaster recovery service used in clouds | |
CN111045983B (en) | Nuclear power station electronic file management method, device, terminal equipment and medium | |
CN112596806A (en) | Data lake data loading script generation method and system | |
CN111415096A (en) | Credit investigation data checking method and system | |
CN107180047B (en) | File generation method and device | |
CN117194242A (en) | Log playback method and device for transaction system, electronic equipment and storage medium | |
CN116663518A (en) | Financial report data input method, device, equipment and storage medium | |
CN116128669A (en) | Processing system, method, electronic equipment and storage medium for summarizing tax return data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |