CN117829828A - Service bill generation method, device and equipment and readable storage medium - Google Patents
Service bill generation method, device and equipment and readable storage medium Download PDFInfo
- Publication number
- CN117829828A CN117829828A CN202311870800.4A CN202311870800A CN117829828A CN 117829828 A CN117829828 A CN 117829828A CN 202311870800 A CN202311870800 A CN 202311870800A CN 117829828 A CN117829828 A CN 117829828A
- Authority
- CN
- China
- Prior art keywords
- data
- service
- business
- target
- detail
- 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
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000003860 storage Methods 0.000 title claims abstract description 21
- 230000010354 integration Effects 0.000 claims abstract description 81
- 238000006243 chemical reaction Methods 0.000 claims abstract description 10
- 238000007781 pre-processing Methods 0.000 claims description 34
- 238000012216 screening Methods 0.000 claims description 13
- 238000004140 cleaning Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 3
- 230000005540 biological transmission Effects 0.000 abstract description 4
- 238000007726 management method Methods 0.000 description 11
- 238000004891 communication Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000012545 processing Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 3
- 238000012790 confirmation Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 235000019580 granularity Nutrition 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000000737 periodic effect Effects 0.000 description 2
- 238000007639 printing Methods 0.000 description 2
- 238000004801 process automation Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 206010048669 Terminal state Diseases 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000003795 chemical substances by application Substances 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000010006 flight Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000000746 purification Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000002123 temporal effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 238000012795 verification Methods 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/102—Bill distribution or payments
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application provides a service bill generation method, device and equipment and a readable storage medium, wherein service data are acquired from each preset service system, and the preprocessed service data are stored in a pre-built data warehouse. And acquiring a data link of the target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type. And integrating the business data of each civil aviation information service in the data link of the target account opening business to obtain detail integration data. And obtaining a flow detail list of the target account opening business based on the preset account opening total detail integration data. The method and the device realize automatic conversion from business data to billing data, reduce the risks of manual intervention and cross-system backup to prevent important information from being maliciously tampered in the transmission process, and improve the information safety and accuracy of the billing data.
Description
Technical Field
The present disclosure relates to the field of civil aviation information service technologies, and in particular, to a method, an apparatus, a device, and a readable storage medium for generating a service bill.
Background
The civil aviation information service mainly aims at various information technology services such as aviation passenger traffic service processing, aviation travel electronic distribution, airport passenger processing, internet travel platform and the like for airlines, airports, air ticket sales agents, travel enterprises and civil aviation related institutions. At present, the data of each billing party is integrated in a platform mode through a billing system, the billing party is used for generating the required business detail data of the service bill and transmitting the business detail data to the platform of the billing system, and the platform is used for generating the service bill based on the business detail data to finish billing.
Disclosure of Invention
The application provides a method, a device, equipment and a readable storage medium for generating a service bill, which are as follows:
a method of generating a service bill, comprising:
acquiring service data from each preset service system, and preprocessing the service data;
storing the preprocessed business data to a pre-constructed data warehouse;
acquiring a data link of a target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type;
Integrating service data of various civil aviation information services in a data link of the target account opening service to obtain detail integration data;
summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
based on the billing agreement and the flow details of the target billing service, a service bill is generated, the service bill including a bill amount.
Optionally, acquiring service data from each preset service system, and preprocessing the service data includes:
extracting application data generated by application software from each service system in an off-line batch acquisition mode, and preprocessing the application data, wherein the preprocessing comprises data cleaning and data conversion;
and collecting the operation logs of the application software from each service system in a quasi-real-time flow collection mode to obtain log data, and preprocessing the log data.
Optionally, storing the preprocessed business data to a pre-built data warehouse, including:
the preprocessed application data is loaded to a pre-built application data warehouse periodically in a snapshot mode;
the preprocessed log data are stored in a unified format to a pre-built log data warehouse in a centralized mode;
The data warehouse includes the application data warehouse and the log data warehouse.
Optionally, the method for generating a service bill according to claim 3, wherein the integrating the service data of each civil aviation information service in the data link of the target billing service to obtain the detail integration data includes:
if the business data of the civil aviation information service in the data link of the target account opening business is log data, acquiring a target detail field in the log data of the civil aviation information service, wherein the target detail field is a detail field required by the target account opening business;
matching and associating the target detail fields by taking the transaction as a unit to obtain field association data;
and generating single data detail as detail integration data based on the field association data.
Optionally, integrating service data of each civil aviation information service in the data link of the target account opening service to obtain detail integration data, and further including:
if the business data of the civil aviation information service in the data link of the target account opening business comprises application data and log data, determining the description of a preset integration dimension in the account opening final state data, extracting data items related to the integration dimension in other business data according to the description of the integration dimension, associating the business data of each civil aviation information service in the data link of the target account opening business with the data items of the other business data to obtain business association data, and screening the business association data to form a mixed data detail.
Optionally, summarizing the detail integration data based on a preset accounting period to obtain a flow detail of the target accounting business, including:
screening the detail integration data according to a preset account opening unit to obtain unit flow data;
and summarizing the unit flow data based on the preset account period to obtain a flow detail list.
Optionally, generating the service bill based on the billing agreement and the flow details of the target billing service includes:
based on the account opening conditions of the target account opening business, acquiring an account opening protocol as a target account opening protocol, wherein the target account opening protocol comprises protocol basic data and a protocol formula;
acquiring a target data item from the flow detail list based on the protocol basic data;
calculating the target data item based on the agreement formula to obtain the bill amount;
a service bill is generated based at least on the bill amount.
A service bill generation apparatus, comprising:
the data acquisition unit comprises a step of acquiring service data from each preset service system and preprocessing the service data;
the data storage unit comprises a data warehouse which is used for storing the preprocessed business data into the preset data warehouse;
the target billing information acquisition unit is used for acquiring a data link of a target billing service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target billing service and a corresponding data type;
The data integration unit is used for integrating the business data of each civil aviation information service in the data link of the target account opening business to obtain detail integration data;
the data summarizing unit is used for summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
and the bill generation unit is used for generating a service bill based on the billing agreement and the flow detail list of the target billing service, wherein the service bill comprises the bill amount.
A service bill generation apparatus comprising: a memory and a processor;
the memory is used for storing programs;
the processor is configured to execute the program to implement the steps of the service bill generation method described above.
A readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of a method of generating a service bill as described above.
As can be seen from the above technical solutions, the method, apparatus, device, and readable storage medium for generating a service bill provided in the embodiments of the present application acquire service data from each preset service system, and preprocess the service data. And storing the preprocessed business data to a pre-constructed data warehouse. And acquiring a data link of the target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type. And integrating service data of various civil aviation information services in a data link of the target account opening service to obtain detail integration data. And obtaining a flow detail list of the target account opening business based on the preset account opening total detail integration data. Based on the billing agreement and the flow details of the target billing service, a service bill is generated, the service bill including a bill amount. Therefore, the method and the device realize automatic conversion from business data to account opening data, reduce the conditions of manual intervention, cross-system backup and the like, prevent important information from being maliciously tampered and other risks in the transmission process, improve the safety and accuracy of account opening data information, realize integration of business data by taking account opening transaction as dimension, realize association of business data of each business system, and enhance cooperation and unification of the business systems.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
Fig. 1 is a schematic architecture diagram of an accounting system according to an embodiment of the present application;
FIG. 2 is a schematic diagram of a financial process automation provided in an embodiment of the present application;
fig. 3 is a flow chart of a method for generating a service bill according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a service bill generating device according to an embodiment of the present application;
Fig. 5 is a schematic structural diagram of a service bill generating device according to an embodiment of the present application.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure have been shown in the accompanying drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but are provided to provide a more thorough and complete understanding of the present disclosure.
It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure. The term "including" and variations thereof as used herein are intended to be open-ended, i.e., including, but not limited to. The term "based on" is based at least in part on. The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments. Related definitions of other terms will be given in the description below. The references to "a" and "an" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
The existing account opening modes of the account opening system mainly comprise two main types: one is a fixed charging mode, namely a periodic billing mode, the amount charged each time is unchanged, and the other is a flow charging mode, namely billing is carried out according to the flow of the service actually used by the user and combined with a pricing standard. The method is closer to the equivalent exchange of the buyer and the seller in the flow charging mode, so that the benefits of the buyer and the seller can be guaranteed, the viscosity of the client to the service can be effectively increased by combining ladder pricing or preferential policies and the like, and the civil aviation information service is mainly opened in the flow charging mode.
The traditional system of opening accounts mainly integrates the data of each party of opening accounts with the mode of platform, and the party of opening accounts is used for generating the required business detail data of bill, transmits to the platform of system of opening accounts, and the platform is used for: firstly, checking, processing and screening service detail data, summarizing to generate bill statistical data, generating bill reports, further establishing a workflow to transfer and execute accounting information, and finally completing the accounting service.
However, for the billing mode of charging according to the flow, the service detail data includes the flow detail data, and the billing method based on the current billing system mainly has the following technical problems:
The first party and the billing party are responsible for generating and transmitting flow detail data, the generation rule of the flow detail data is automatically controlled by the billing party, and a platform in the billing system has risk of unsupervised authenticity and accuracy of the flow detail data.
And the data provided to the user after the platform opens accounts comprise service bills and account checking data. The accounting data relates to details of the operation data, and is often stored in an operation database of an accounting party. However, the operation database has short retention time for historical details due to high data change frequency, high storage cost and the like, and cannot meet the requirement of civil aviation on checking account of historical long period.
Third, the core of civil aviation information service is to solve the passenger civil aviation trip whole process, the start and stop of a civil aviation service usually need to span a plurality of business applications, the application data types generated after the completion of the civil aviation service are many, and the data association logic is complex, the application database of a business application can not provide the account opening data of the whole service process, therefore, the account opening party needs to have stronger data integration technical capability to finish the generation of account opening data, namely, is limited by the data integration technical capability of the account opening party, and the current account opening system has weaker account opening technical capability on complex businesses.
Based on this, an embodiment of the present application provides an accounting system for generating a service bill, fig. 1 is a schematic structural diagram of the accounting system, and referring to fig. 1, the accounting system and service systems of each configuration application software construct a secure communication link in advance, where the service systems include a flight inventory control system, a reservation management system, an electronic ticket management system, an off-duty message control system, a financial contract system, and the accounting system includes a data source acquisition module, a data integration module, a flow summary module, a protocol configuration module, a bill management module, and a front end display module.
The data source acquisition module is used for: and extracting application data generated by the application software from each service system, preprocessing the application data, and periodically loading and refreshing the preprocessed application data to an application data warehouse in a snapshot mode. And extracting the log data of the application software from each service system, preprocessing the log data, and then intensively storing the preprocessed log data in a log data warehouse in a unified format.
In this embodiment, the preprocessing of the application data includes, but is not limited to, data conversion and data purification, and the preprocessing of the log data includes, but is not limited to, data filtering and data normalization, where a specific implementation of each preprocessing method can be seen in the prior art.
The data integration module is used for: and sequencing the application data according to the life cycle of the civil aviation information service entity, determining the start-stop range of the data type of the account opening service, forming a data link of the account opening service, and determining the data completion identification corresponding to the account opening service. And selecting the final state data of the account opening business and the data tag thereof from the application data warehouse or the log data warehouse, acquiring other business data on a data link of the account opening business from the data type of the final state data of the account opening business, and carrying out association and/or integration operation on the other business data and the final state data of the account opening. And taking a complete account opening transaction as flow detail granularity, outputting data fields of business data required by account opening business account opening, desensitizing sensitive data to form detail integration data, and storing the detail integration data into an account opening data bazaar.
In this embodiment, the final state data of the accounting refers to data generated in a final confirmation or ending link on a data link capable of representing the accounting business, that is, data indicated by a data completion identifier. The data link of the target billing service refers to the arrangement of a plurality of civil aviation information services according to time sequence in the whole life cycle of the target billing service, namely the data link comprises the civil aviation information services which are arranged in sequence. It should be noted that, the multi-tenant technology is adopted to realize the billing data mart.
In particular, the data integration module enables data integration from a single unordered data source (each business system) to have temporal attributes in the business dimension.
The data integration module is used for modeling and storing the data acquired by the data source acquisition module, and the model is divided into an original layer, a detail layer, an integration layer and a summary layer. The detail layer classifies and stores application data or log data according to processing links, for example, the billing business can be roughly divided into four processing links of product release, product sales and process management, product delivery and settlement.
The flow summarizing module is used for screening out unit flow data from detail integration data in the billing data mart according to the billing unit, and obtaining flow detail based on the preset billing period total unit flow data.
Optionally, the flow summarizing module is specifically configured to count the flow with 1 day as a dimension in a billing unit to obtain daily flow data, and the preset billing period may include a day, a month or a quarter as a basis for checking and reconciliation. Optionally, a daily summary flow detail list obtained by day summary in a preset account period is used for checking accounts, and a month summary flow detail list or a quarter summary flow detail list obtained by month and quarter summary in a period is used for calculating the bill amount.
Optionally, the flow summary module is further configured to obtain highly summarized data such as a year summary flow detail, and the main function is to provide comprehensive analysis data, for example: and the real data support is provided for monitoring and predicting the business flow by comparing the increment amount with the historical flow and the like, so that the business department can refer to the business flow when making a business agreement.
In the billing field, since civil aviation passenger service products are numerous, different product module statistics logics are different, and even if the same detail data are used, statistics rules or data ranges can be changed at any time, so that great flexibility is increased according to product module division. Since the detail data is used only as calculation, it is not provided externally, and appropriate multiplexing can be added from the viewpoint of storage cost. When the product is adjusted, only the summarized data related to the product is required to be modified, and the summarized data of other products are not influenced.
The protocol configuration module is used for acquiring configuration data from a configuration source and storing the configuration data into the account opening protocol database.
In this embodiment, the configuration data obtained from the configuration source includes an interface of the configuration source such as an interface of the purchase contract system and an interface of the billing party third party system, and the configuration data obtained from the front end includes billing agreements for supporting ladder pricing calculation and auxiliary verification billing related information, such as agreement information including billing customer information, product configuration, and charging logic.
Specifically, the agreement configuration module manages the billing agreement in the form of rule entries and accepts the call of the bill management module. The billing agreement includes agreement underlying data and agreement formulas. For example: in ibe+billing, the protocol base data for the overflow includes "overflow reservation ratio", "overflow unit price", "bottom reservation amount", etc., and the protocol formula is: on the basis of the flow-reservation amount x excess flow reservation ratio, the flow-reservation amount is compared with the guaranteed reservation amount and multiplied by the excess flow unit price.
In this embodiment, the accounting agreement database is an Oracle database for supporting front-end applications of the financial contract system.
The bill management module is used for selecting a billing agreement and a flow detail list based on preset billing conditions and generating a service bill.
In this embodiment, the billing conditions include time requirements, user range, and the like, and the service bill includes a bill amount.
In this embodiment, the bill management module is further configured to implement background functions such as modification, deletion, display, and query of the bill, and establish a workflow to automate the financial flow with the bill and the corresponding operation authority.
Specifically, the bill management module is further configured to: the method comprises the steps of giving flow auditing and checking authority to a billing position, providing an analysis report for data comparison analysis, providing synchronous operation, synchronizing the audited data from a data mart to an operation database for executing bill billing operation, giving the billing auditing and checking authority to the billing position, and giving bill confirmation and checking authority to financial staff.
Fig. 2 is a schematic diagram of financial process automation provided in an embodiment of the present application, where, as shown in fig. 2, a workflow established by a bill management module includes bill establishment, bill-place audit, and financial confirmation, and specifically includes: flow data generation-flow data auditing-flow data synchronization-agreement configuration-bill generation-bill auditing-bill validation. Therefore, the bill management module establishes a workflow highly matched with the billing operation, and transmits and executes billing information, bill state and billing tasks among different executors, so that financial flow automation is realized.
The front-end display module is used for supporting the visual operation of the protocol configuration module and the bill management module through the front-end Web site and providing the data display and printing functions formed by the flow summarizing module.
It should be noted that, in addition to meeting the billing requirement, checking the bill is also an important task, so the front-end display module is also used for providing self-service report display and printing functions, and displaying the aggregated data to the front-end Web site to provide simple and visual data.
According to the technical scheme, the billing system provided by the embodiment of the application realizes automatic conversion from business data such as application data and log data to billing data through the data source acquisition module and the data integration module, reduces the conditions of manual intervention, cross-system backup and the like, prevents risks such as malicious tampering of important information in the transmission process, and improves the safety and accuracy of billing data information. The flow summarizing module supporting the checking account has the advantages that the statistical functions of different granularities help enterprises to enhance the monitoring and predicting capability of corresponding account receiving money, the combination of financial accounting and big data realizes the tight fusion among business, data and funds, and the data integrating module realizes the integration of business data, promotes the establishment of association of business data and enhances the cooperation and unification of business systems.
Based on the foregoing accounting system, the present application provides a method for generating a service bill, and fig. 3 is a flow chart of the method for generating a service bill provided by the present application, it should be noted that, the method for generating a service bill provided by the embodiment of the present application may be implemented based on the system for generating a service bill, and specific implementation methods of each step may refer to the foregoing embodiments. As shown in fig. 3, the method specifically includes:
s301, extracting application data generated by application software from each service system, preprocessing the application data, and periodically loading and refreshing the preprocessed application data to an application data warehouse in a snapshot mode.
In this embodiment, the data source collection module collects application data in an offline batch collection manner, optionally, obtains the full-data mirror image of the same day from each service system through a preset night maintenance timing task, obtains mirror image application data, transmits the mirror image application data to the data warehouse receiver, performs application data preprocessing operations such as cleaning and conversion on the mirror image application data through a preset loading task, and finally stores the mirror image application data preprocessed by the application data in the application data warehouse.
Optionally, the application data preprocessing operation is implemented based on an ETL (Extract-Transform-Load) tool, which is an ETL Automation (ETL Automation) architecture according to constraints of a workflow scheduling manner, and the ETL tool has multiple scheduling manners such as file driving, job timing, upstream triggering, and the like, supports re-execution at a failure point and below, does not need to be executed from scratch, and is tightly integrated and matched with a data warehouse.
S302, extracting the log data of the application software from each service system, preprocessing the log data, and then intensively storing the preprocessed log data in a log data warehouse in a unified format.
In this embodiment, the data source collection module collects log data in a quasi-real-time stream collection manner, optionally, monitors the log data generation condition of the service system by a monitoring program deployed on the service system side, captures the generated log data in time, and transmits the log data to the log data warehouse through a message queue.
In this embodiment, the application data repository is a greenplus data repository for implementing storage of multi-source application data, and the log data repository is a Hadoop data platform for implementing storage of massive log data.
It should be noted that S301 and S302 are only one optional implementation manner of acquiring service data from a service system, preprocessing the service data, and storing the preprocessed service data into a pre-constructed data warehouse, that is, the embodiment divides the service data into log data and service data, and performs different data extraction, preprocessing, and storage schemes on different types of service data, so as to implement efficient data classification and collection.
S303, acquiring a data link of the target account opening service.
It should be noted that, the civil aviation information service includes not only service types of booking a system, managing a flight, and leaving a port to carry out business for a flight or a passenger, but also service types used by a system such as data subscription and interface call, and the application data range covers the whole life cycle data of the passenger and the flight, including but not limited to application data generated by links such as a flight plan, a passenger sales, and a leaving port, so that the billing business is different in required data type according to different service types.
In this embodiment, the data link of the target billing service includes service data of at least one civil aviation information service related in the full life cycle of the target billing service and a corresponding data type. The business data of the civil aviation information service corresponds to business data of a business system executing the civil aviation information service.
S304, integrating service data of civil aviation information service in a data link of the target account opening service by taking account opening transaction as a dimension to obtain detail integration data.
In this embodiment, based on the number of civil aviation information services related to the billing service, the billing service may be divided into a simple billing service involving only one civil aviation information service and a complex billing service involving multiple civil aviation information services.
For the simple account opening business, single data detail of business data of civil aviation information service in a data link of the target account opening business is generated, and detail integration data is obtained. Wherein, the single data detail refers to the data detail which is integrated by context association of the business data only depending on one business data.
For example, in the query volume accounting business of an internet booking interface product (hereinafter referred to as ibe+) a data of log data is adopted, the accounting mode of the query volume accounting business is an interactive mode of request/response of a client and a background service, a transaction (accounting transaction) of ibe+ is considered, and the data source is the log data of a business system. After the data source acquisition module stores the log data in a message form to the log data warehouse, the data integration module is responsible for cleaning and modeling, the detail layer extracts detail fields (target detail fields) required by target account opening business in each message, the integration layer carries out matching association on the messages (detail fields) according to 'request' and 'response' by taking a transaction as a unit, other data for business processing are integrated, and finally, a single data detail is exemplified in table 1.
TABLE 1
In table 1, a field name column includes names of detail fields required for the billing service, a field type column includes field types of the respective detail fields, and a sample exemplifies field values of the detail fields.
For complex account opening business, based on final state data and data types corresponding to target account opening business, integrating data of a plurality of civil aviation information services to obtain mixed data details, and obtaining detail integrated data, wherein the final state data refers to business data of the last civil aviation information service in a data link, and the data types comprise one of application data and log data.
In this embodiment, the mixed data details refer to data details obtained by combining service data from a plurality of service systems in a complex billing service.
The method for integrating the mixed data detail comprises the following steps: determining an integration dimension, determining a description of a preset integration dimension in final state data of the account opening, extracting data items related to the integration dimension from other business data according to the description of the integration dimension, associating business data of each civil aviation information service in a data link of the target account opening business through the data items of the other business data to obtain business association data, and screening the business association data to form a mixed data detail. The other business data are business data of civil aviation information service in a data link of the target billing business except the billing final state data.
For example, an on-line sales international subscription amount billing service in ibe+ refers to the billing of a net booking leg including overseas distribution, which is successfully booked through an ibe+ interface, for which channel configuration data, airport configuration data of a product release domain in a detail layer, booking data of an ibe+ system of a product sales process domain, and booking data of an ibe+ system are required to be integrated, wherein the booking data of the ibe+ system is billing terminal state data of the billing service. Table 2 illustrates a table of subscription data sources for ibe+ systems.
TABLE 2
Firstly, determining that an integration dimension is PNR (passenger booking record, namely Passenger Name Record), relating to a data item describing PNR as PNR record number "+" PNR creation date ", associating the reservation data of an IBE+ system with the reservation data of the IBE+ system of a product sales process domain by the dimension, acquiring travel information of passengers, extracting airport fields and reservation channel fields in the travel information, screening out data conforming to international flights, overseas sales and self-supply channels in an accounting range by combining domestic and international attribute configuration data of the airports, country configuration data of the office and the like, and forming an integration table of periodic snapshot type taking the PNR as the dimension, namely mixed data detail shown in table 3.
TABLE 3 Table 3
S305, obtaining a flow detail list based on the preset ledger-summary detail integration data.
In this embodiment, unit flow data is obtained by screening from detail integration data in the billing data mart according to the billing unit, and a flow detail is obtained based on the preset billing period total unit flow data.
For example, in ibe+ online sales interface traffic, the aggregate data required for accounting is per-account per-interface call volume per day. The daily summary flow details are shown in table 4.
TABLE 4 Table 4
| Field name | Field type | Sample example |
| Billing date | date | 2023-06-01 |
| User account information | varchar16 | bluesky |
| Interface name | varchar16 | AirFlightshop |
| Quantity of adjustment | smallint | 120 |
S306, generating a service bill based on the billing agreement and the flow detail list of the target billing service.
In this embodiment, the billing agreement includes agreement underlying data and an agreement formula, and the service bill includes at least a bill amount.
Optionally, based on the billing conditions of the target billing service, a billing protocol and a flow detail list are acquired, wherein the billing conditions comprise information such as time requirements, user ranges and the like.
According to the technical scheme, the service bill generation method provided by the embodiment of the application realizes automatic conversion from business data such as application data and log data to account opening data, reduces the conditions of manual intervention, cross-system backup and the like, prevents risks such as malicious tampering of important information in a transmission process, improves the information security and accuracy of the account opening data, realizes integration of the business data by taking account opening transaction as dimension, realizes association of the business data of each business system, and enhances cooperation and unification of the business systems.
Fig. 4 is a schematic structural diagram of a service bill generating device according to an embodiment of the present application, where, as shown in fig. 4, the device may include:
the data acquisition unit 401 acquires service data from each preset service system and performs preprocessing on the service data;
a data storage unit 402, which stores the preprocessed business data to a pre-constructed data warehouse;
a target billing information obtaining unit 403, configured to obtain a data link of a target billing service, where the data link includes service data of at least one civil aviation information service related in a full life cycle of the target billing service and a corresponding data type;
a data integration unit 404, configured to integrate service data of each civil aviation information service in the data link of the target billing service to obtain detail integration data;
the data summarizing unit 405 is configured to summarize the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting service;
and the bill generating unit 406 is configured to generate a service bill based on the billing agreement and the flow details of the target billing service, where the service bill includes a bill amount.
It should be noted that, the units described in the embodiments of the present disclosure may be implemented by software, or may be implemented by hardware. Where the name of the unit does not constitute a limitation of the unit itself in some cases, for example, a "bill generation unit" may also be described as a "unit for generating service bills".
Fig. 5 shows a schematic structural diagram of the service bill generating device, which may include: at least one processor 501, at least one communication interface 502, at least one memory 503, and at least one communication bus 504;
in the embodiment of the present application, the number of the processor 501, the communication interface 502, the memory 503, and the communication bus 504 is at least one, and the processor 501, the communication interface 502, and the memory 503 complete communication with each other through the communication bus 504;
the processor 501 may be a central processing unit CPU, or a specific integrated circuit ASIC (Application Specific Integrated Circuit), or one or more integrated circuits configured to implement embodiments of the present invention, etc.;
the memory 503 may include a high-speed RAM memory, and may further include a non-volatile memory (non-volatile memory), etc., such as at least one magnetic disk memory;
the memory stores a program, and the processor may execute the program stored in the memory to implement each step of a service bill generating method provided in the embodiment of the present application, as follows:
a method of generating a service bill, comprising:
acquiring service data from each preset service system, and preprocessing the service data;
Storing the preprocessed business data to a pre-constructed data warehouse;
acquiring a data link of a target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type;
integrating service data of various civil aviation information services in a data link of the target account opening service to obtain detail integration data;
summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
based on the billing agreement and the flow details of the target billing service, a service bill is generated, the service bill including a bill amount.
Optionally, acquiring service data from each preset service system, and preprocessing the service data includes:
extracting application data generated by application software from each service system in an off-line batch acquisition mode, and preprocessing the application data, wherein the preprocessing comprises data cleaning and data conversion;
and collecting the operation logs of the application software from each service system in a quasi-real-time flow collection mode to obtain log data, and preprocessing the log data.
Optionally, storing the preprocessed business data to a pre-built data warehouse, including:
the preprocessed application data is loaded to a pre-built application data warehouse periodically in a snapshot mode;
the preprocessed log data are stored in a unified format to a pre-built log data warehouse in a centralized mode;
the data warehouse includes the application data warehouse and the log data warehouse.
Optionally, the method for generating a service bill according to claim 3, wherein the integrating the service data of each civil aviation information service in the data link of the target billing service to obtain the detail integration data includes:
if the business data of the civil aviation information service in the data link of the target account opening business is log data, acquiring a target detail field in the log data of the civil aviation information service, wherein the target detail field is a detail field required by the target account opening business;
matching and associating the target detail fields by taking the transaction as a unit to obtain field association data;
and generating single data detail as detail integration data based on the field association data.
Optionally, integrating service data of each civil aviation information service in the data link of the target account opening service to obtain detail integration data, and further including:
If the business data of the civil aviation information service in the data link of the target account opening business comprises application data and log data, determining the description of a preset integration dimension in the account opening final state data, extracting data items related to the integration dimension in other business data according to the description of the integration dimension, associating the business data of each civil aviation information service in the data link of the target account opening business with the data items of the other business data to obtain business association data, and screening the business association data to form a mixed data detail.
Optionally, summarizing the detail integration data based on a preset accounting period to obtain a flow detail of the target accounting business, including:
screening the detail integration data according to a preset account opening unit to obtain unit flow data;
and summarizing the unit flow data based on the preset account period to obtain a flow detail list.
Optionally, generating the service bill based on the billing agreement and the flow details of the target billing service includes:
based on the account opening conditions of the target account opening business, acquiring an account opening protocol as a target account opening protocol, wherein the target account opening protocol comprises protocol basic data and a protocol formula;
Acquiring a target data item from the flow detail list based on the protocol basic data;
calculating the target data item based on the agreement formula to obtain the bill amount;
a service bill is generated based at least on the bill amount.
The embodiment of the application also provides a readable storage medium, which can store a computer program suitable for being executed by a processor, and when the computer program is executed by the processor, the steps of the method for generating a service bill provided by the embodiment of the application are implemented as follows:
a method of generating a service bill, comprising:
acquiring service data from each preset service system, and preprocessing the service data;
storing the preprocessed business data to a pre-constructed data warehouse;
acquiring a data link of a target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type;
integrating service data of various civil aviation information services in a data link of the target account opening service to obtain detail integration data;
summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
Based on the billing agreement and the flow details of the target billing service, a service bill is generated, the service bill including a bill amount.
Optionally, acquiring service data from each preset service system, and preprocessing the service data includes:
extracting application data generated by application software from each service system in an off-line batch acquisition mode, and preprocessing the application data, wherein the preprocessing comprises data cleaning and data conversion;
and collecting the operation logs of the application software from each service system in a quasi-real-time flow collection mode to obtain log data, and preprocessing the log data.
Optionally, storing the preprocessed business data to a pre-built data warehouse, including:
the preprocessed application data is loaded to a pre-built application data warehouse periodically in a snapshot mode;
the preprocessed log data are stored in a unified format to a pre-built log data warehouse in a centralized mode;
the data warehouse includes the application data warehouse and the log data warehouse.
Optionally, the method for generating a service bill according to claim 3, wherein the integrating the service data of each civil aviation information service in the data link of the target billing service to obtain the detail integration data includes:
If the business data of the civil aviation information service in the data link of the target account opening business is log data, acquiring a target detail field in the log data of the civil aviation information service, wherein the target detail field is a detail field required by the target account opening business;
matching and associating the target detail fields by taking the transaction as a unit to obtain field association data;
and generating single data detail as detail integration data based on the field association data.
Optionally, integrating service data of each civil aviation information service in the data link of the target account opening service to obtain detail integration data, and further including:
if the business data of the civil aviation information service in the data link of the target account opening business comprises application data and log data, determining the description of a preset integration dimension in the account opening final state data, extracting data items related to the integration dimension in other business data according to the description of the integration dimension, associating the business data of each civil aviation information service in the data link of the target account opening business with the data items of the other business data to obtain business association data, and screening the business association data to form a mixed data detail.
Optionally, summarizing the detail integration data based on a preset accounting period to obtain a flow detail of the target accounting business, including:
screening the detail integration data according to a preset account opening unit to obtain unit flow data;
and summarizing the unit flow data based on the preset account period to obtain a flow detail list.
Optionally, generating the service bill based on the billing agreement and the flow details of the target billing service includes:
based on the account opening conditions of the target account opening business, acquiring an account opening protocol as a target account opening protocol, wherein the target account opening protocol comprises protocol basic data and a protocol formula;
acquiring a target data item from the flow detail list based on the protocol basic data;
calculating the target data item based on the agreement formula to obtain the bill amount;
a service bill is generated based at least on the bill amount.
It should be noted that in the context of this disclosure, a readable storage medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The readable storage medium may be a machine-readable signal medium or a machine-readable storage medium. The readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
Finally, it is further noted that in the context of the present disclosure, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.
While several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.
The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by persons skilled in the art that the scope of the disclosure referred to in this disclosure is not limited to the specific combinations of features described above, but also covers other embodiments which may be formed by any combination of features described above or equivalents thereof without departing from the spirit of the disclosure. Such as those described above, are mutually substituted with the technical features having similar functions disclosed in the present disclosure (but not limited thereto).
Claims (10)
1. A method for generating a service bill, comprising:
acquiring service data from each preset service system, and preprocessing the service data;
Storing the preprocessed business data to a pre-constructed data warehouse;
acquiring a data link of a target account opening service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target account opening service and a corresponding data type;
integrating service data of various civil aviation information services in a data link of the target account opening service to obtain detail integration data;
summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
based on the billing agreement and the flow details of the target billing service, a service bill is generated, the service bill including a bill amount.
2. The method for generating service bill according to claim 1, wherein the acquiring service data from each preset service system, and the preprocessing the service data comprises:
extracting application data generated by application software from each service system in an off-line batch acquisition mode, and preprocessing the application data, wherein the preprocessing comprises data cleaning and data conversion;
and collecting the operation logs of the application software from each service system in a quasi-real-time flow collection mode to obtain log data, and preprocessing the log data.
3. The method for generating a service bill according to claim 2, wherein storing the preprocessed business data to the pre-built data warehouse comprises:
the preprocessed application data is loaded to a pre-built application data warehouse periodically in a snapshot mode;
the preprocessed log data are stored in a unified format to a pre-built log data warehouse in a centralized mode;
the data warehouse includes the application data warehouse and the log data warehouse.
4. The method for generating a service bill according to claim 3, wherein the integrating the service data of each civil aviation information service in the data link of the target billing service to obtain the detail integration data includes:
if the business data of the civil aviation information service in the data link of the target account opening business is log data, acquiring a target detail field in the log data of the civil aviation information service, wherein the target detail field is a detail field required by the target account opening business;
matching and associating the target detail fields by taking the transaction as a unit to obtain field association data;
and generating single data detail as detail integration data based on the field association data.
5. The method for generating service bill according to claim 4, wherein integrating the service data of each civil aviation information service in the data link of the target billing service to obtain detail integration data further comprises:
if the business data of the civil aviation information service in the data link of the target account opening business comprises application data and log data, determining the description of a preset integration dimension in the account opening final state data, extracting data items related to the integration dimension in other business data according to the description of the integration dimension, associating the business data of each civil aviation information service in the data link of the target account opening business with the data items of the other business data to obtain business association data, and screening the business association data to form a mixed data detail.
6. The method for generating a service bill according to claim 5, wherein the step of summarizing the detail integration data based on a preset billing period to obtain a flow detail of the target billing service includes:
screening the detail integration data according to a preset account opening unit to obtain unit flow data;
and summarizing the unit flow data based on the preset account period to obtain a flow detail list.
7. The method for generating a service bill according to claim 6, wherein the generating a service bill based on the billing agreement and the traffic details of the target billing service comprises:
based on the account opening conditions of the target account opening business, acquiring an account opening protocol as a target account opening protocol, wherein the target account opening protocol comprises protocol basic data and a protocol formula;
acquiring a target data item from the flow detail list based on the protocol basic data;
calculating the target data item based on the agreement formula to obtain the bill amount;
a service bill is generated based at least on the bill amount.
8. A service bill generation apparatus, comprising:
the data acquisition unit comprises a step of acquiring service data from each preset service system and preprocessing the service data;
the data storage unit comprises a data warehouse which is used for storing the preprocessed business data into the preset data warehouse;
the target billing information acquisition unit is used for acquiring a data link of a target billing service, wherein the data link comprises service data of at least one civil aviation information service related in the whole life cycle of the target billing service and a corresponding data type;
The data integration unit is used for integrating the business data of each civil aviation information service in the data link of the target account opening business to obtain detail integration data;
the data summarizing unit is used for summarizing the detail integration data based on a preset accounting period to obtain a flow detail list of the target accounting business;
and the bill generation unit is used for generating a service bill based on the billing agreement and the flow detail list of the target billing service, wherein the service bill comprises the bill amount.
9. A service bill generation apparatus, characterized by comprising: a memory and a processor;
the memory is used for storing programs;
the processor is configured to execute the program to implement the steps of the service bill generation method according to any one of claims 1 to 7.
10. A readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of generating a service bill according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311870800.4A CN117829828A (en) | 2023-12-29 | 2023-12-29 | Service bill generation method, device and equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311870800.4A CN117829828A (en) | 2023-12-29 | 2023-12-29 | Service bill generation method, device and equipment and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117829828A true CN117829828A (en) | 2024-04-05 |
Family
ID=90522466
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311870800.4A Pending CN117829828A (en) | 2023-12-29 | 2023-12-29 | Service bill generation method, device and equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117829828A (en) |
-
2023
- 2023-12-29 CN CN202311870800.4A patent/CN117829828A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112950162B (en) | Information system engineering supervision work distribution management information system | |
| CN111815283B (en) | Information system engineering supervision enterprise business management system | |
| US8442917B1 (en) | Energy distribution and marketing backoffice system and method | |
| CN110874718A (en) | Concrete enterprise big data management system | |
| CN101071481A (en) | Business trip service system and method | |
| CN103123712A (en) | Method and system for monitoring network behavior data | |
| US10650359B2 (en) | Energy distribution and marketing backoffice system and method | |
| CN111081361A (en) | Intelligent logistics platform management system | |
| CN105404999A (en) | Purchase and asset management platform suitable for aviation field | |
| CN112184313A (en) | Power marketing business application system based on client portrait data | |
| CN111222973B (en) | Information processing system and method | |
| CN111798221A (en) | Value-added tax invoice management system | |
| CN111882386A (en) | Freight quotation method and device | |
| CN112258306B (en) | Account information checking method, device, electronic equipment and storage medium | |
| CN110750302B (en) | Assembly line account making method for accountant | |
| CN115170090A (en) | Project management method and device, electronic equipment and readable storage medium | |
| CN111652699A (en) | Data transmission method for tax receipt system | |
| CN113362025B (en) | Data accounting system, method, computer-readable storage medium, and electronic device | |
| CN111080262A (en) | Intelligent logistics platform management method | |
| CN112258220A (en) | Information acquisition and analysis method, system, electronic device and computer readable medium | |
| CN115409589B (en) | Financial data standardization system and method thereof | |
| CN117829828A (en) | Service bill generation method, device and equipment and readable storage medium | |
| CN112001705B (en) | Accounting and settlement management system for equipment | |
| CN115775188A (en) | Asset financial integrated system | |
| CN109377155A (en) | The loan information measures and procedures for the examination and approval and device |
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 |