A method and system for settling sales costs of cloud computing products

Abstract

The present application provides a method and system for settling the sales cost of cloud computing products. The method includes: obtaining the package period order data and the actual on-demand call data belonging to the current account period, storing them in a database table, and forming a source data set to be settled within the account period; performing data correctness verification on the source data set, filtering and marking the data that does not need to be settled, and initially assigning values ​​to the fields; performing settlement rule branch processing on the pre-processed data, finding the corresponding cost settlement price, and then calculating the cost amount according to the formula of the tariff rule; statistically summarizing the cost amount details, and generating a summary report by province, city and product dimensions. The solution proposed by the present invention enables developers to focus only on the development of settlement factors, and tests or businesses can flexibly combine settlement factors at any time, thereby speeding up the implementation of business rules and quickly responding to more needs with a lower implementation cost.

Description

Technical Field

[0001] The present application relates to the field of computer technology, in particular to the field of IT and software development technology, and in particular to a method, system, electronic device and storage medium for settling the sales cost of a cloud computing product. Background Art

[0002] As the types of cloud computing products sold increase, while sales are rising, the financial settlement of related costs is becoming more and more refined. From the original non-point settlement, supplier settlement, etc. to internal settlement, the settlement rules are becoming more and more numerous, more and more personalized, and changing more and more frequently, resulting in more and more prominent problems and pain points, as follows:

[0003] Business processing logic is becoming more and more complex, requiring the writing of many database scripts or hard coding to implement, which is time-consuming and labor-intensive; the implementation of settlement rules relies heavily on developer coding, and testers or business personnel cannot implement them easily even if they understand the rules better.

[0004] Therefore, how to provide a settlement method, system, electronic device and storage medium for the sales cost of cloud computing products has become a technical problem that urgently needs to be solved in this field. Summary of the invention

[0005] The purpose of the present invention is to provide a method, system, electronic device and storage medium for settling the sales cost of a cloud computing product.

[0006] According to a first aspect of the present invention, there is provided a method for settling the sales cost of a cloud computing product, comprising:

[0007] Step S1, data collection: extract the package period order data and the actual on-demand call data belonging to the current account period, store them in the database table, and form the source data set to be settled within the account period;

[0008] Step S2, preprocessing: verify the correctness of the source data set, filter and mark the data that does not need to be settled, and perform initial value assignment on the fields;

[0009] Step S3, batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and then calculate the cost amount according to the formula of the tariff rule;

[0010] Step S4, generate a report: perform statistical aggregation on the detailed data of the cost amount to generate a multi-dimensional summary report, wherein the dimension includes at least one of province, city and product.

[0011] According to the method of the first aspect of the present invention, in step S1, the data collection: extracting the package cycle order data and the actually used on-demand call bill data belonging to the current account period, storing them in a database table, and forming a source data set to be settled within the account period includes:

[0012] Synchronize package cycle order data: synchronize the completed order data of CRM through ETL tools; check whether the order data is abnormal. If the data is abnormal, confirm with CRM and repair or delete the order data;

[0013] Package cycle order data splitting: The synchronized order data is split according to the order item dimension. After the splitting is completed, the data is stored in the business control table of the database table and marked as ORDER type data;

[0014] On-demand bill parsing: Read bill data on the server line by line according to the configured file path and file name, and parse the content of each line field;

[0015] On-demand call record aggregation: aggregate the call record data after parsing in the same dimension, and store the aggregated call record data in the business control table, marked as OTHER type data.

[0016] According to the method of the first aspect of the present invention, in step S2, the preprocessing: performing data correctness verification on the source data set, filtering and marking data that does not require settlement, and performing initial value assignment on the fields includes:

[0017] Settlement factor development: extract common settlement factors based on existing business rules;

[0018] Filter rule combination: configure the free settlement rule, obtain the settlement attribute field and the corresponding settlement condition value of the free settlement rule, determine the actual value of the corresponding settlement attribute field according to the settlement factor, compare the settlement condition value with the actual value and mark the attribute field that meets the first condition as free settlement;

[0019] Enhanced rule combination: configure enhanced rules, obtain the enhanced attribute fields and corresponding enhanced condition values ​​configured in the enhanced rules, determine the actual values ​​of the corresponding enhanced attribute fields according to the settlement factors, compare the actual values ​​with the configured enhanced condition values ​​and assign values ​​to the enhanced attribute fields to be set if the second condition is met;

[0020] Data that needs to be settled further: After filtering and enhancing rules, records that need to be settled further and values ​​of more fields are obtained.

[0021] According to the method of the first aspect of the present invention, in step S3, the batch price: performing settlement rule branch processing on the pre-processed data, searching for the corresponding cost settlement price, and then calculating the cost amount according to the formula of the tariff rule includes:

[0022] Settlement rule combination: configure settlement rules, which set judgment conditions. The rule tree is composed of multiple layers. If the conditions of this layer are met, the next layer can be entered;

[0023] Tariff rule combination: configure the tariff rules, which are located at the bottom of the rule tree and support the combination of reference objects and addition, subtraction, multiplication, division, and brackets. Finally, they are mapped to operation reference objects to achieve the calculation of settlement amount according to the formula;

[0024] Cost settlement data: After obtaining the settlement amount, the order data, customer data, product data and settlement amount are aggregated into detailed data.

[0025] According to the method of the first aspect of the present invention, in step S4, generating a report: summarizing the cost amount detail data to generate a summary report by province, city and product dimensions includes:

[0026] Configure report generation rules, including: scripts for obtaining data, script condition parameter values, and uploading report templates; statistically summarize the cost amount detail data according to the report generation rules, generate a multi-dimensional summary report, and upload it to a file server, wherein the dimensions include at least one of provinces, cities, and products.

[0027] According to the method of the first aspect of the present invention, in step S1, the data anomalies include: duplicate orders, annual package type identification errors, discount type errors, on-demand call orders are identified as package period orders, and key fields are missing;

[0028] The synchronized order data that needs to be split includes: upgrade / downgrade, unsubscribe, and parent-child orders;

[0029] The contents of the fields include: sales product ID, resource ID, service type, resource type, usage time and usage amount.

[0030] According to the method of the first aspect of the present invention, in step S2, the settlement-free rule includes: settlement-free for special resource pools, settlement-free for special customer mailboxes, and settlement-free for special products;

[0031] Enhanced rules include: assigning initial values ​​to order item values ​​and cycle quantities, and assigning values ​​to product-related fields.

[0032] A second aspect of the present invention discloses a settlement system for the sales cost of a cloud computing product; the system comprises:

[0033] The first processing module is configured to collect data: retrieve the package cycle order data and the actual on-demand call data belonging to the current account period, store them in the database table, and form a source data set to be settled within the account period;

[0034] The second processing module is configured to pre-process: perform data correctness verification on the source data set, filter and mark data that does not need to be settled, and perform initial value assignment on the fields;

[0035] The third processing module is configured to,batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and calculate the cost amount according to the tariff rule;

[0036] The fourth processing module is configured to generate a report: statistically summarize the detailed data of the cost amount to generate a multi-dimensional summary report, wherein the dimension includes at least one of province, city and product.

[0037] The third aspect of the present invention discloses an electronic device. The electronic device includes a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the steps in any one of the methods for settling the sales cost of a cloud computing product in the first aspect of the present disclosure are implemented.

[0038] The fourth aspect of the present invention discloses a computer-readable storage medium. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps in any one of the methods for settling the sales cost of a cloud computing product in the first aspect of the present disclosure are implemented.

[0039] A fifth aspect of the present invention discloses a computer program product. When instructions in the computer program product are executed by a processor of an electronic device, the electronic device is enabled to execute the method described in any one of the above aspects.

[0040] The technical solution provided by this application may have the following beneficial effects:

[0041] Implement methods for independent configuration and processing of settlement factors; implement methods for combining various rules based on settlement factors, which can be adjusted at any time to reduce hard coding; allow developers to focus on the development of basic settlement factors, and testers or businesses can also participate in the upper-level combination and implementation of settlement rules, reducing dependence on developers; quickly respond to needs and greatly reduce the time required to implement needs. Allow developers to focus only on the development of settlement factors, and testers or businesses can flexibly combine settlement factors at any time, thereby speeding up the implementation of business rules and responding to more needs quickly with a lower implementation cost. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 A flowchart of a method for settling sales costs of a cloud computing product provided according to an embodiment;

[0043] Figure 2 A flowchart of data collection according to an embodiment;

[0044] Figure 3 A flowchart of preprocessing according to an embodiment;

[0045] Figure 4 A flowchart of a batch price provided according to an embodiment;

[0046] Figure 5 A schematic diagram of filtering rule configuration provided according to an embodiment;

[0047] Figure 6 A schematic diagram of configuring tariff rules according to an embodiment;

[0048] Figure 7 A schematic diagram of a settlement system for sales costs of cloud computing products provided according to an embodiment;

[0049] Figure 8 A block diagram of an electronic device provided according to an embodiment;

[0050] Fig. 9 A block diagram of a computer-readable storage medium provided according to an embodiment. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution in the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiment of the present invention. Obviously, the described embodiment is a part of the embodiment of the present invention, not all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0052] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0053] In view of the shortcomings of the prior art, the present invention configures the settlement rules that are most likely to change during the settlement process, extracts the universal settlement factors, and then forms personalized settlement rules for each business by combining different settlement factors, and then calculates the cost amount according to the tariff rules. This allows developers to focus only on the development of settlement factors, and tests or businesses can flexibly combine settlement factors at any time, thereby speeding up the implementation of business rules and quickly responding to more needs with a lower implementation cost.

[0054] Glossary:

[0055] Settlement factor: a type of data or variable, including constants, internal parameters, reference objects, calculation reference values, etc. It also supports custom factors, that is, packaging database functions into factor variables for use

[0056] Settlement rules: Conditional judgment rules composed of settlement factors, supporting multi-layer combination to form a rule tree. Only when the conditions of this layer are true can you enter the next layer.

[0057] Tariff rules: composed of settlement factors, addition, subtraction, multiplication, division, brackets, etc., which can realize formula calculation.

[0058] Embodiment 1:

[0059] According to a first aspect of the present invention, the present invention discloses a method for settling sales costs of a cloud computing product. Figure 1 FIG. 1 is a flow chart of a method for settling sales costs of a cloud computing product according to an embodiment of the present invention. Figure 1 As shown, the method includes:

[0060] Step S1, data collection: extract the package period order data and the actual on-demand call data belonging to the current account period, store them in the database table, and form the source data set to be settled within the account period;

[0061] Step S2, preprocessing: verify the correctness of the source data set, filter and mark the data that does not need to be settled, and perform initial value assignment on the fields;

[0062] Step S3, batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and then calculate the cost amount according to the formula of the tariff rule;

[0063] Step S4, generate a report: summarize the cost amount detail data and generate a summary report by province, city and product dimensions.

[0064] In step S1, data collection: extract the package cycle order data belonging to the current account period and the actual on-demand call bill data, store them in the database table, and form the source data set to be settled within the account period.

[0065] In some embodiments, in step S1, Figure 2 As shown, the data collection includes: extracting the package cycle order data belonging to the current account period and the actual on-demand call data, storing them in the database table, and forming the source data set to be settled within the account period, including:

[0066] Synchronize package cycle order data: synchronize the completed order data of CRM through ETL tools, such as master_order_his, inner_order_item_his, inner_ord_prod_spec_inst_his, etc.; check whether the order data is abnormal; if the data is abnormal, confirm with CRM, repair or eliminate the order data, and then optimize it into a data monitoring tool to improve the verification efficiency;

[0067] ETL: Extract-Transform-Load, refers to the process of extracting (extract), transforming (transform), and loading (load) data from the source to the destination. ETL is a very important link in data warehouse and business intelligence (BI) projects. It is mainly used to integrate scattered, messy, and non-uniform data to provide analytical basis for corporate decision-making.

[0068] CRM: Customer Relationship Management, refers to the process by which enterprises use corresponding information technology and Internet technology to coordinate the interaction between enterprises and customers in sales, marketing and services in order to improve their core competitiveness, thereby improving their management methods and providing customers with innovative and personalized customer interaction and services. Its ultimate goal is to attract new customers, retain old customers, and convert existing customers into loyal customers to increase the market.

[0069] Package cycle order data splitting: The synchronized order data is split according to the order item dimension. After the splitting is completed, the data is stored in the business control table of the database table and marked as ORDER (database type) type data;

[0070] On-demand bill analysis: Read bill data on the server line by line according to the configured file path and file name, and parse the content of each line field. This can be achieved through multi-threading technology or distributed computing technology to speed up processing;

[0071] On-demand call bill aggregation: aggregate the parsed call bill data of the same dimension, such as cloud hard disk, and calculate and aggregate the usage data of the same user on a monthly basis according to dimensions such as resource type + resource id + sales product id + billing type + cycle type + pricing unit + resource pool + settlement month. In this way, the total usage time of this user in a settlement month is obtained, instead of scattered calculation based on each call bill data; the aggregated call bill data is stored in the business control table and marked as OTHER (database type) type data.

[0072] The data anomalies include: duplicate orders, annual package type identification errors, discount type errors, on-demand call records being identified as package period orders, and key fields missing;

[0073] The synchronized order data that needs to be split includes: upgrade, downgrade, unsubscribe, and parent-child orders, such as updating the expiration time of the parent order, determining whether it is an annual order, processing special settlement-free orders, and the child order inheriting the parent order cycle type and cycle number.

[0074] The contents of the fields include: sales product ID, resource ID, service type, resource type, usage time and usage amount.

[0075] In step S2, preprocessing: verify the correctness of the source data set, filter and mark the data that does not need to be settled, and perform initial assignment of values ​​to the fields.

[0076] In some embodiments, in step S2, Figure 3 As shown, the preprocessing includes: checking the correctness of the source data set, filtering and marking the data that does not need to be settled, and initially assigning values ​​to the fields.

[0077] Settlement factor development: extract common settlement factors based on existing business rules; distinguish between constants, internal parameters, reference objects, calculation reference objects and other types to facilitate subsequent rule combination; constants, such as 8% bad debt rate; internal parameters, such as order types (new purchase, renewal, upgrade, downgrade, etc.), are generally enumeration type values ​​used internally; reference objects, such as inter-department settlement cost price; calculation reference objects, such as inter-department settlement fees, the formula is inter-department settlement cost price * call billing value * cycle number;

[0078] Filter rule combination: configure the free settlement rule, obtain the settlement attribute field and the corresponding settlement condition value of the free settlement rule, query or calculate the actual value of the corresponding settlement attribute field according to the settlement factor, compare the settlement condition value with the actual value, and mark the free settlement if the condition is met;

[0079] Enhanced rule combination: configure enhanced rules, obtain the enhanced attribute fields and corresponding enhanced condition values ​​configured in the enhanced rules, query or calculate the actual values ​​of the corresponding enhanced attribute fields according to the settlement factors, compare the actual values ​​with the configured enhanced condition values, and assign values ​​to the enhanced attribute fields to be set if the conditions are met; the values ​​can be configured constant values ​​or values ​​calculated by settlement factors; in this way, necessary fields can be processed and assigned values ​​for subsequent processing;

[0080] Data that needs to be settled: After filtering and enhancing rules, records that need to be settled and values ​​of more fields are obtained. The filtering and enhancing rules can be sorted and executed in sequence when called to solve the dependency problem between rules.

[0081] The settlement-free rules include: settlement-free for special resource pools, settlement-free for special customer mailboxes, and settlement-free for special products;

[0082] Enhanced rules include: assigning initial values ​​to order item values ​​and cycle quantities, and assigning values ​​to product-related fields. These fields have been configured and can be selected on the page to form conditional expression rules.

[0083] In step S3, batch pricing: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, the price supports standard type, step arrival, step progressive type, and then calculate the cost amount according to the formula of the tariff rule.

[0084] In some embodiments, in step S3, Figure 4 As shown, the batch price: the pre-processed data is processed according to the settlement rule branch, the corresponding cost settlement price is found, and then the cost amount is calculated according to the formula of the tariff rule, including:

[0085] Settlement factor development: extract common settlement factors based on existing business rules; distinguish between constants, internal parameters, reference objects, calculation reference objects and other types to facilitate subsequent rule combination; constants, such as 8% bad debt rate; internal parameters, such as order types (new purchase, renewal, upgrade, downgrade, etc.), are generally enumeration type values ​​used internally; reference objects, such as inter-department settlement cost price; calculation reference objects, such as inter-department settlement fees, the formula is inter-department settlement cost price * call billing value * cycle number;

[0086] Settlement rule combination: Settlement rules can be configured to be divided into different businesses, such as non-one-point settlement, inter-department settlement, etc. For non-one-point settlement, it can be further subdivided into on-demand settlement, package period settlement, package period cancellation and other rules; the settlement rules set judgment conditions and reference settlement factors. The judgment conditions support grouping (and for the same group, or for different groups), and a rule tree is formed by multiple layers. If the conditions of this layer are true (correct), you can enter the next layer;

[0087] Tariff rule combination: configure the tariff rules, which are located at the bottom of the rule tree and support the combination of reference objects and addition, subtraction, multiplication, division, and brackets. Finally, they are mapped to operation reference objects to achieve the calculation of settlement amount according to the formula;

[0088] Cost settlement data: After obtaining the settlement amount, the order data, customer data, product data and settlement amount are aggregated into detailed data.

[0089] In step S4, a report is generated: the cost amount detailed data is statistically summarized to generate a summary report by province, city and product dimensions.

[0090] In some embodiments, in step S4, generating a report: summarizing the cost amount detail data to generate a summary report by province, city and product dimensions includes:

[0091] Configure report generation rules, including: scripts for obtaining data, script condition parameter values, and uploading report templates; summarize the cost amount detail data according to the report generation rules, generate summary reports by province, city, and product dimensions, and upload them to the file server.

[0092] Specifically, report downloading: users view the required reports through the file generation list and download them for use.

[0093] The application scenario is inter-departmental settlement, that is, PAAS settles the used IAAS resources, which is applicable to this embodiment. The specific application is as follows:

[0094] (1) After the synchronization of CRM (CRM software) is completed, the order data with special enterprise account identification is processed again and split into order item dimension data. For example, if there are three sub-orders under a main order, the three data are split into three pieces for subsequent processes and saved in the business control table;

[0095] (2) Analyze the inter-department settlement call records transmitted by billing, aggregate the product usage and time of the same user, and save them in the business control table;

[0096] (3) Develop new settlement factors, such as determining whether an order record exists. The logic is to query whether there is a record in the order-related table based on the order ID and resource ID;

[0097] (4) Configure filtering rules, reference the settlement factors developed in step (3), and determine whether there are order records; configure key field enhancement rules, and reuse existing settlement factors, such as initializing price types and converting period quantity units (converting seconds into hours), etc. Figure 5 As shown;

[0098] (5) Develop new settlement factors, i.e., calculation reference values, and configure the tariff calculation formula: inter-department settlement fee = inter-department settlement cost price * billing value * number of cycles;

[0099] (6) Configure settlement rules. You can reuse existing settlement factors. For example, if the price type is on-demand, you can import the price list to match the cost price based on the sales product and price type.

[0100] (7) Configure the tariff rules, reference the settlement factors developed in step (5), and calculate the cost amount according to the calculation formula, such as Figure 6 As shown;

[0101] (8) Gather all order data for which cost amounts can be settled and generate summary and detailed reports.

[0102] In summary, the solution proposed in the present invention can realize the method of independent configuration and processing of settlement factors; realize the method of combining various rules based on settlement factors, which can be adjusted at any time to reduce hard coding; enable developers to focus on the development of basic settlement factors, and testers or businesses can also participate in the upper-level combination and implementation of settlement rules, reducing dependence on developers; quickly respond to needs and greatly reduce the time efficiency of implementing needs. Developers can only focus on the development of settlement factors, and testers or businesses can flexibly combine settlement factors at any time, thereby speeding up the implementation of business rules and quickly responding to more needs with a lower implementation cost.

[0103] It should be noted that, for the method embodiments, for the sake of simplicity, they are all expressed as a series of action combinations, but those skilled in the art should be aware that the present application is not limited by the order of the actions described, because according to the present application, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all optional embodiments, and the actions involved are not necessarily required by the present application.

[0104] Embodiment 2:

[0105] The invention discloses a settlement system for sales costs of cloud computing products. Figure 7 FIG. 4 is a structural diagram of a settlement system for cloud computing product sales costs according to an embodiment of the present invention; Figure 7 As shown, the system 100 includes:

[0106] The first processing module 101 is configured to collect data: retrieve the package cycle order data and the actual on-demand call data belonging to the current account period, store them in a database table, and form a source data set to be settled within the account period;

[0107] The second processing module 102 is configured to pre-process: perform data correctness verification on the source data set, filter and mark the data that does not need to be settled, and perform initial value assignment on the fields;

[0108] The third processing module 103 is configured to: batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and then calculate the cost amount according to the formula of the tariff rule;

[0109] The fourth processing module 104 is configured to generate a report: statistically summarize the cost amount detail data and generate a summary report by province, city and product dimensions.

[0110] According to the system of the second aspect of the present invention, the first processing module 101 is specifically configured as follows: Figure 2 As shown, the data collection includes: extracting the package cycle order data belonging to the current account period and the actual on-demand call data, storing them in the database table, and forming the source data set to be settled within the account period, including:

[0111] Synchronize package cycle order data: synchronize the completed order data of CRM through ETL tools, such as master_order_his, inner_order_item_his, inner_ord_prod_spec_inst_his, etc.; check whether the order data is abnormal; if the data is abnormal, confirm with CRM, repair or eliminate the order data, and then optimize it into a data monitoring tool to improve the verification efficiency;

[0112] Package cycle order data splitting: The synchronized order data is split according to the order item dimension. After the splitting is completed, the data is stored in the business control table of the database table and marked as ORDER type data;

[0113] On-demand bill analysis: Read bill data on the server line by line according to the configured file path and file name, and parse the content of each line field. This can be achieved through multi-threading technology or distributed computing technology to speed up processing;

[0114] On-demand call bill aggregation: aggregate the parsed call bill data of the same dimension, such as cloud hard disk, and calculate and aggregate the usage data of the same user on a monthly basis according to dimensions such as resource type + resource id + sales product id + billing type + cycle type + pricing unit + resource pool + settlement month. In this way, the total usage time of this user in a settlement month can be obtained, rather than calculating it piecemeal based on each call bill data; the aggregated call bill data is stored in the business control table and marked as OTHER type data.

[0115] The data anomalies include: duplicate orders, annual package type identification errors, discount type errors, on-demand call records being identified as package period orders, and key fields missing;

[0116] The synchronized order data that needs to be split includes: upgrade, downgrade, unsubscribe, and parent-child orders, such as updating the expiration time of the parent order, determining whether it is an annual order, processing special settlement-free orders, and the child order inheriting the parent order cycle type and cycle number.

[0117] The contents of the fields include: sales product ID, resource ID, service type, resource type, usage time and usage amount.

[0118] According to the system of the second aspect of the present invention, the second processing module 102 is specifically configured as follows: Figure 3As shown, the preprocessing includes: checking the correctness of the source data set, filtering and marking the data that does not need to be settled, and initially assigning values ​​to the fields.

[0119] Settlement factor development: extract common settlement factors based on existing business rules; distinguish between constants, internal parameters, reference objects, calculation reference objects and other types to facilitate subsequent rule combination; constants, such as 8% bad debt rate; internal parameters, such as order types (new purchase, renewal, upgrade, downgrade, etc.), are generally enumeration type values ​​used internally; reference objects, such as inter-department settlement cost price; calculation reference objects, such as inter-department settlement fees, the formula is inter-department settlement cost price * call billing value * cycle number;

[0120] Filter rule combination: configure the free settlement rule, obtain the settlement attribute field and the corresponding settlement condition value of the free settlement rule, query or calculate the actual value of the corresponding settlement attribute field according to the settlement factor, compare the settlement condition value with the actual value, and mark the free settlement if the condition is met;

[0121] Enhanced rule combination: configure enhanced rules, obtain the enhanced attribute fields and corresponding enhanced condition values ​​configured in the enhanced rules, query or calculate the actual values ​​of the corresponding enhanced attribute fields according to the settlement factors, compare the actual values ​​with the configured enhanced condition values, and assign values ​​to the enhanced attribute fields to be set if the conditions are met; the values ​​can be configured constant values ​​or values ​​calculated by settlement factors; in this way, necessary fields can be processed and assigned values ​​for subsequent processing;

[0122] Data that needs to be settled: After filtering and enhancing rules, records that need to be settled and values ​​of more fields are obtained. The filtering and enhancing rules can be sorted and executed in sequence when called to solve the dependency problem between rules.

[0123] The settlement-free rules include: settlement-free for special resource pools, settlement-free for special customer mailboxes, and settlement-free for special products;

[0124] Enhanced rules include: assigning initial values ​​to order item values ​​and cycle quantities, and assigning values ​​to product-related fields. These fields have been configured and can be selected on the page to form conditional expression rules.

[0125] According to the system of the second aspect of the present invention, the third processing module 103 is specifically configured as follows: Figure 4 As shown, the batch price: the pre-processed data is processed according to the settlement rule branch, the corresponding cost settlement price is found, and then the cost amount is calculated according to the formula of the tariff rule, including:

[0126] Settlement factor development: extract common settlement factors based on existing business rules; distinguish between constants, internal parameters, reference objects, calculation reference objects and other types to facilitate subsequent rule combination; constants, such as 8% bad debt rate; internal parameters, such as order types (new purchase, renewal, upgrade, downgrade, etc.), are generally enumeration type values ​​used internally; reference objects, such as inter-department settlement cost price; calculation reference objects, such as inter-department settlement fees, the formula is inter-department settlement cost price * call billing value * cycle number;

[0127] Settlement rule combination: Settlement rules can be configured to be divided into different businesses, such as non-one-point settlement, inter-department settlement, etc. For non-one-point settlement, it can be further subdivided into on-demand settlement, package period settlement, package period cancellation and other rules; the settlement rules set judgment conditions and reference settlement factors. The judgment conditions support grouping (and for the same group, or for different groups), and the rule tree is composed of multiple layers. If the conditions of this layer are true, you can enter the next layer;

[0128] Tariff rule combination: configure the tariff rules, which are located at the bottom of the rule tree and support the combination of reference objects and addition, subtraction, multiplication, division, and brackets. Finally, they are mapped to operation reference objects to achieve the calculation of settlement amount according to the formula;

[0129] Cost settlement data: After obtaining the settlement amount, the order data, customer data, product data and settlement amount are aggregated into detailed data.

[0130] According to the system of the second aspect of the present invention, the fourth processing module 104 is specifically configured to generate a report: statistically summarize the cost amount detail data, and generate a summary report by province, city and product dimensions, including:

[0131] Configure report generation rules, including: scripts for obtaining data, script condition parameter values, and uploading report templates; summarize the cost amount detail data according to the report generation rules, generate summary reports by province, city, and product dimensions, and upload them to the file server.

[0132] Specifically, report downloading: users view the required reports through the file generation list and download them for use.

[0133] As for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0134] Embodiment 3:

[0135] An embodiment of the present application also provides an electronic device, including: a processor, a memory, and a computer program stored in the memory and executable on the processor. When the computer program is executed by the processor, the various processes of the above-mentioned method embodiment are implemented, and the same technical effect can be achieved. To avoid repetition, it will not be described here.

[0136] Figure 8 800 is a block diagram of an electronic device 800 shown in the present application. For example, the electronic device 800 may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, a fitness device, a personal digital assistant, etc.

[0137] Reference Figure 8 , the electronic device 800 may include one or more of the following components: a processing component 802 , a memory 804 , a power component 806 , a multimedia component 808 , an audio component 810 , an input / output (I / O) interface 812 , a sensor component 814 , and a communication component 816 .

[0138] The processing component 802 generally controls the overall operation of the electronic device 800, such as operations associated with display, phone calls, data communications, camera operations, and recording operations. The processing component 802 may include one or more processors 820 to execute instructions to complete all or part of the steps of the above method. In addition, the processing component 802 may include one or more modules to facilitate the interaction between the processing component 802 and other components. For example, the processing component 802 may include a multimedia module to facilitate the interaction between the multimedia component 808 and the processing component 802.

[0139] The memory 804 is configured to store various types of data to support operations on the device 800. Examples of such data include instructions for any application or method operating on the electronic device 800, contact data, phone book data, messages, images, videos, etc. The memory 804 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk.

[0140] The power supply component 806 provides power to the various components of the electronic device 800. The power supply component 806 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power to the electronic device 800.

[0141] The multimedia component 808 includes a screen that provides an output interface between the electronic device 800 and the user. In some embodiments, the screen may include a liquid crystal display (LCD) and a touch panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from the user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundaries of the touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front camera and / or a rear camera. When the device 800 is in an operating mode, such as a shooting mode or a video mode, the front camera and / or the rear camera may receive external multimedia data. Each front camera and the rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.

[0142] The audio component 810 is configured to output and / or input audio signals. For example, the audio component 810 includes a microphone (MIC), and when the electronic device 800 is in an operating mode, such as a call mode, a recording mode, and a voice recognition mode, the microphone is configured to receive an external audio signal. The received audio signal can be further stored in the memory 804 or sent via the communication component 816. In some embodiments, the audio component 810 also includes a speaker for outputting audio signals.

[0143] I / O interface 812 provides an interface between processing component 802 and peripheral interface modules, such as keyboards, click wheels, buttons, etc. These buttons may include but are not limited to: home button, volume button, start button, and lock button.

[0144] The sensor assembly 814 includes one or more sensors for providing various aspects of status assessment for the electronic device 800. For example, the sensor assembly 814 can detect the open / closed state of the device 800, the relative positioning of components, such as the display and keypad of the electronic device 800, and the sensor assembly 814 can also detect the position change of the electronic device 800 or a component of the electronic device 800, the presence or absence of contact between the user and the electronic device 800, the orientation or acceleration / deceleration of the electronic device 800, and the temperature change of the electronic device 800. The sensor assembly 814 may include a proximity sensor configured to detect the presence of nearby objects without any physical contact. The sensor assembly 814 may also include an optical sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an accelerometer, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

[0145] The communication component 816 is configured to facilitate wired or wireless communication between the electronic device 800 and other devices. The electronic device 800 can access a wireless network based on a communication standard, such as WiFi, a carrier network (such as 2G, 3G, 4G or 5G), or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast operation information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 816 also includes a near field communication (NFC) module to facilitate short-range communication. For example, the NFC module can be implemented based on radio frequency identification (RFID) technology, infrared data association (IrDA) technology, ultra-wideband (UWB) technology, Bluetooth (BT) technology and other technologies.

[0146] In an exemplary embodiment, the electronic device 800 may be implemented by one or more application-specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components to perform the above methods.

[0147] In an exemplary embodiment, a non-transitory computer-readable storage medium including instructions is also provided, such as a memory 804 including instructions, and the instructions can be executed by a processor 820 of an electronic device 800 to perform the above method. For example, the non-transitory computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0148] Embodiment 4:

[0149] The embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, each process of the above method embodiment is implemented, and the same technical effect can be achieved. To avoid repetition, it is not repeated here. The computer-readable storage medium is, for example, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0150] Fig. 9 19 is a block diagram of a computer-readable storage medium 1900 shown in the present application. For example, the computer-readable storage medium 1900 may be provided as a server.

[0151] Reference Fig. 9, the computer-readable storage medium 1900 includes a processing component 1922, which further includes one or more processors, and a memory resource represented by a memory 1932 for storing instructions, such as an application, that can be executed by the processing component 1922. The application stored in the memory 1932 may include one or more modules, each corresponding to a set of instructions. In addition, the processing component 1922 is configured to execute instructions to perform the above method.

[0152] The computer readable storage medium 1900 may also include a power supply component 1926 configured to perform power management of the computer readable storage medium 1900, a wired or wireless network interface 1950 configured to connect the computer readable storage medium 1900 to a network, and an input / output (I / O) interface 1958. The computer readable storage medium 1900 may operate based on an operating system stored in the memory 1932, such as Windows Server™, Mac OS X™, Unix™, Linux™, FreeBSD™ or the like.

[0153] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.

[0154] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, a magnetic disk, or an optical disk), and includes a number of instructions for a terminal (which can be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to execute the methods described in each embodiment of the present application.

[0155] The embodiments of the present application are described above in conjunction with the accompanying drawings, but the present application is not limited to the above-mentioned specific implementation methods. The above-mentioned specific implementation methods are merely illustrative and not restrictive. Under the guidance of the present application, ordinary technicians in this field can also make many forms without departing from the purpose of the present application and the scope of protection of the claims, all of which are within the protection of the present application.

[0156] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed in the present application can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0157] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0158] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0159] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0160] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0161] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard drives, ROM, RAM, magnetic disks, or optical disks.

[0162] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A method for settling the sales cost of a cloud computing product, characterized in that: include: Step S1, data collection: extract the package period order data and the actual on-demand call data belonging to the current account period, store them in the database table, and form the source data set to be settled within the account period; Step S2, preprocessing: verify the correctness of the source data set, filter and mark the data that does not need to be settled, and perform initial value assignment on the fields; Step S3, batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and calculate the cost amount according to the tariff rules; Step S4, generate a report: perform statistical aggregation on the detailed data of the cost amount to generate a multi-dimensional summary report, wherein the dimension includes at least one of province, city and product.

2. The method for settling the sales cost of cloud computing products according to claim 1, characterized in that: In step S1, the data collection includes: extracting the package period order data and the actual on-demand call data belonging to the current account period, storing them in a database table, and forming a source data set to be settled within the account period, including: Synchronize package cycle order data: synchronize the completed order data of CRM through ETL tools; check whether the order data is abnormal. If the data is abnormal, confirm with CRM and repair or delete the order data; Package cycle order data splitting: The synchronized order data is split according to the order item dimension. After the splitting is completed, the data is stored in the business control table of the database table and marked as ORDER type data; On-demand bill parsing: Read bill data on the server line by line according to the configured file path and file name, and parse the content of each line field; On-demand call record aggregation: aggregate the call record data after parsing in the same dimension, and store the aggregated call record data in the business control table, marked as OTHER type data.

3. The method for settling the sales cost of cloud computing products according to claim 1, characterized in that: In step S2, the preprocessing: checking the correctness of the source data set, filtering and marking the data that does not need to be settled, and initially assigning values ​​to the fields include: Settlement factor development: extract common settlement factors based on existing business rules; Filter rule combination: configure the free settlement rule, obtain the settlement attribute field and the corresponding settlement condition value of the free settlement rule, determine the actual value of the corresponding settlement attribute field according to the settlement factor, compare the settlement condition value with the actual value and mark the attribute field that meets the first condition as free settlement; Enhanced rule combination: configure enhanced rules, obtain the enhanced attribute fields and corresponding enhanced condition values ​​configured in the enhanced rules, determine the actual values ​​of the corresponding enhanced attribute fields according to the settlement factors, compare the actual values ​​with the configured enhanced condition values ​​and assign values ​​to the enhanced attribute fields to be set if the second condition is met; Data that needs to be settled further: After filtering and enhancing rules, records that need to be settled further and values ​​of more fields are obtained.

4. The method for settling the sales cost of cloud computing products according to claim 1, characterized in that: In step S3, the batch price: performing settlement rule branch processing on the pre-processed data, searching for the corresponding cost settlement price, and then calculating the cost amount according to the formula of the tariff rule includes: Settlement rule combination: configure settlement rules, which set judgment conditions. The rule tree is composed of multiple layers. If the conditions of this layer are met, the next layer can be entered; Tariff rule combination: configure the tariff rules, which are located at the bottom of the rule tree and support the combination of reference objects and addition, subtraction, multiplication, division, and brackets. Finally, they are mapped to operation reference objects to achieve the calculation of settlement amount according to the formula; Cost settlement data: After obtaining the settlement amount, the order data, customer data, product data and settlement amount are aggregated into detailed data.

5. The method for settling the sales cost of cloud computing products according to claim 1, characterized in that: In step S4, the report generation: statistically summarizing the cost amount detail data, generating a summary report by province, city and product dimensions includes: Configure report generation rules, including: scripts for obtaining data, script condition parameter values, and uploading report templates; statistically summarize the cost amount detail data according to the report generation rules, generate a multi-dimensional summary report, and upload it to a file server, wherein the dimensions include at least one of provinces, cities, and products.

6. The method for settling the sales cost of cloud computing products according to claim 2, characterized in that: In step S1, the data anomalies include: duplicate orders, annual package type identification errors, discount type errors, on-demand call orders are identified as package period orders, and key fields are missing; The synchronized order data that needs to be split includes: upgrade / downgrade, unsubscribe, and parent-child orders; The contents of the fields include: sales product ID, resource ID, service type, resource type, usage time and usage amount.

7. The method for settling the sales cost of cloud computing products according to claim 3, characterized in that: In step S2, the settlement-free rules include: settlement-free for special resource pools, settlement-free for special customer mailboxes, and settlement-free for special products; Enhanced rules include: assigning initial values ​​to order item values ​​and cycle quantities, and assigning values ​​to product-related fields.

8. A settlement system for the sales cost of cloud computing products, characterized in that: The system comprises: The first processing module is configured to collect data: retrieve the package cycle order data and the actual on-demand call data belonging to the current account period, store them in the database table, and form a source data set to be settled within the account period; The second processing module is configured to pre-process: perform data correctness verification on the source data set, filter and mark the data that does not need to be settled, and perform initial value assignment on the fields; The third processing module is configured to,batch price: perform settlement rule branch processing on the pre-processed data, find the corresponding cost settlement price, and calculate the cost amount according to the tariff rule; The fourth processing module is configured to generate a report: statistically summarize the detailed data of the cost amount to generate a multi-dimensional summary report, wherein the dimension includes at least one of province, city and product.

9. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and when the processor executes the computer program, the steps in the method for settling the sales cost of a cloud computing product described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the method for settling the sales cost of a cloud computing product described in any one of claims 1 to 7 are implemented.

Images