Bill file generation method, related device, equipment and storage medium

Abstract

The invention discloses a bill file generation method, a related device, equipment and a storage medium. An application scene at least comprises various terminals. The method comprises the following steps: in response to a selection operation for a target template, displaying a template creation page of a first sub-template; in response to a selection operation for a first data source option on the template creation page of the first sub-template, displaying first initial bill data on the page of the first sub-template according to a first initial bill format; in response to an editing operation for the first sub-template, displaying the first updated bill data on the first sub-template page according to the first updated bill format; and in response to a downloading operation for the target template, generating a target bill file. According to the method, the corresponding bill format and bill data can be presented according to user requirements, the bill making efficiency is improved, and the method has high flexibility. In addition, the problem of low data reading efficiency caused by dependence on actual charging data is avoided.

Description

Technical Field

[0001] The present application relates to the fields of Internet technology and cloud service technology, and in particular to a method for generating a billing file, related devices, equipment and storage medium. Background Art

[0002] Cloud services are a pattern of adding, using and interacting with Internet-based services, usually involving the provision of dynamically scalable and often virtualized resources through the Internet. Cloud services refer to obtaining required services through the network in an on-demand, scalable manner, which also means that computing power can be circulated as a commodity through the Internet.

[0003] At present, mainstream cloud service providers can provide customized bills for customers. In related technologies, cloud service providers can manually prepare bills for customers. That is, customers provide the billing team of the cloud service provider with the billing information they need to view, and the billing team will pull relevant business data according to customer needs to prepare bills and provide the prepared bills to customers.

[0004] The inventors have found that the current solutions have at least the following problems: although the manual customized bills have high flexibility, in actual applications, not only the billing efficiency is low, but also a lot of manpower is required to prepare the bills. No effective solution has been proposed so far for the above problems. Summary of the invention

[0005] The embodiment of the present application provides a method for generating a bill file, a related device, an apparatus and a storage medium, which can present the corresponding bill format and bill data according to user needs, which not only improves the efficiency of bill making, but also has high flexibility. In addition, it also avoids the problem of low data reading efficiency caused by relying on actual billing data.

[0006] In view of this, the present application provides a method for generating a billing file, comprising:

[0007] In response to a selection operation on a target template, a template creation page of a first sub-template is displayed, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is used to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0008] In response to a selection operation of a first data source option on a template creation page for a first sub-template, displaying first initial bill data on the first sub-template page in a first initial bill format, wherein the first data source option is one of at least one data source option, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option;

[0009] In response to an editing operation on the first sub-template, displaying first updated bill data on the first sub-template page in a first updated bill format, wherein the first updated bill data is derived from the bill sample data;

[0010] In response to a download operation for a target template, a target bill file is generated, wherein the target bill file includes first target bill data presented in a first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

[0011] Another aspect of the present application provides a bill file generating device, comprising:

[0012] A display module is configured to display a template creation page of a first sub-template in response to a selection operation on a target template, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is configured to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0013] The display module is further configured to display first initial bill data on the first sub-template page in accordance with a first initial bill format in response to a selection operation of a first data source option on a template creation page for the first sub-template, wherein the first data source option is one of at least one data source option, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option;

[0014] The display module is further configured to display first updated bill data in a first updated bill format on the first sub-template page in response to an editing operation on the first sub-template, wherein the first updated bill data is derived from the bill sample data;

[0015] A generation module is used to generate a target bill file in response to a download operation for a target template, wherein the target bill file includes first target bill data presented in a first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

[0016] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0017] A display module, specifically used to display a template management page, wherein the template management page is used to provide template information and editing controls corresponding to each editable template in at least one editable template, wherein the template information includes at least one of a template identifier, an object identifier, a template name, a template creation time, creator information, template status information, and a template effective time;

[0018] In response to a selection operation on an edit control corresponding to a target template, a template creation page of a first sub-template is displayed, wherein the target template belongs to one of the at least one editable templates.

[0019] In one possible design, in another implementation of another aspect of the embodiment of the present application, the template management page is further used to provide a download control corresponding to each editable template in at least one editable template;

[0020] A generating module, specifically configured to display a bill download page in response to a selection operation of a download control corresponding to a target template, wherein the bill download page is configured to provide a start date control, an end date control, and a confirmation control;

[0021] In response to an input operation on a start date control in a bill download page, displaying a bill start date;

[0022] In response to an input operation on an end date control in a bill download page, displaying a bill end date;

[0023] In response to the selection operation on the confirmation control, a target billing file is generated according to the billing start date and the billing end date, wherein the billing start date and the billing end date are used to determine the actual billing data of the target object.

[0024] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0025] The display module is specifically used to respond to the selection operation of the first data source option on the template creation page for the first sub-template, and when the first data source option corresponds to the system data source, display the first initial bill data in the first sub-template page according to the first initial bill format.

[0026] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0027] A display module, specifically configured to respond to a selection operation of a first data source option on a template creation page for a first sub-template, and display a file list when the first data source option corresponds to a custom data source, wherein the file list is used to provide at least one selectable file;

[0028] In response to a selection operation on a target file in the file list, uploading the target file, wherein the target file is one of the at least one selectable file;

[0029] When the target file passes the review, the first initial billing data is displayed in the first sub-template page according to the first initial billing format based on the target file, wherein the target file includes the first initial billing data corresponding to the first initial billing format.

[0030] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0031] A display module, specifically configured to display a conditional filter box on a template creation page of the first sub-template in response to a data source editing operation on the first sub-template;

[0032] In response to an input operation on the conditional filter box, a data row field value is obtained, wherein the data row field value is used to indicate T data rows in the first sub-template, and T is an integer greater than or equal to 1;

[0033] The first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data rows remaining after T data rows have been removed.

[0034] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0035] A display module, specifically configured to display a field aggregation page in response to an aggregate editing operation on the first sub-template, wherein the field aggregation page is configured to provide field options corresponding to each data column in the first sub-template;

[0036] In response to a selection operation on K field options in a field aggregation page, aggregation processing is performed on the same data in the K data columns, wherein the K field options have a one-to-one correspondence with the K data columns, and K is an integer greater than or equal to 1;

[0037] The first update bill data is displayed on the first sub-template page in a first update bill format, wherein the first update bill format includes at least one data row after aggregation processing.

[0038] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0039] A display module, specifically configured to display a data column editing page in response to a data column insert operation for the first sub-template, wherein the data column editing page is configured to provide a column name input box and an expression input box;

[0040] In response to an input operation on a column name input box in a data column editing page, a data column name is obtained, wherein the data column name is a column name of a newly added data column;

[0041] If in response to the operation editing operation on the expression input box, displaying the first updated bill data in the first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies the first expression, and the first expression is generated according to the operation editing operation;

[0042] If in response to a column splicing editing operation on the expression input box, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies a second expression, the second expression is generated according to the column splicing editing operation, and the second expression includes field names of at least two data columns in the first sub-template;

[0043] In response to a cross-table association editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column that satisfies a third expression, and the third expression is generated based on the cross-table association editing operation.

[0044] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0045] A display module, specifically configured to display a field replacement page in response to a field editing operation on a target data column in the first sub-template, wherein the field replacement page is configured to provide an original field input box and a replacement field input box;

[0046] In response to an input operation on an original field input box in a field replacement page, obtaining an original value field value for a target data column;

[0047] In response to an input operation on a replacement field input box in a field replacement page, obtaining a target field value for a target data column;

[0048] In response to the editing completion operation on the target data column in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the target data column after the field editing operation.

[0049] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0050] A display module, specifically configured to display the merged data rows on the first sub-template page in response to the same type of merge operation on the relevant field values ​​in the first sub-template;

[0051] In response to the data row insert operation in the first sub-template, displaying a data row edit page, wherein the data row edit page is used to provide a sum control corresponding to the relevant data column in the first sub-template;

[0052] In response to a selection operation on at least one summation control in the data row editing page, performing summation calculations on the data columns corresponding to each summation control in the at least one summation control;

[0053] The first updated bill data is displayed on the first sub-template page in a first updated bill format, wherein the first updated bill format includes data rows and data columns that have undergone similar merging operations and summation calculations.

[0054] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0055] A display module, specifically configured to display the first updated bill data in accordance with the first updated bill format on the first sub-template page in response to a font editing operation on a cell in the first sub-template, wherein the first updated bill format includes the cell after the font editing operation;

[0056] If in response to a background color editing operation on a cell in the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes the cell after the background color editing operation;

[0057] If in response to the row height editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data row after the row height editing operation;

[0058] If in response to the column width editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data column after the column width editing operation;

[0059] In response to a merge edit operation on at least two cells in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cells after the merge edit operation.

[0060] In one possible design, in another implementation of another aspect of the embodiment of the present application, the target bill file further includes page header data;

[0061] The display module is also used to display header data on the first sub-template page in response to a selection operation on a header display control, wherein the header data includes at least one of the title of the first sub-template, the object identifier corresponding to the target template, the name corresponding to the object identifier, and billing cycle information.

[0062] In one possible design, in another implementation of another aspect of the embodiment of the present application, the target billing file further includes footer data;

[0063] The display module is also used to display footer data on the first sub-template page in response to a selection operation on a footer display control, wherein the footer data includes at least one of the name of the service provider, the identification number of the service provider, the address of the service provider, the telephone number of the service provider, the account opening information of the service provider, the payment account number of the service provider, date information and the icon of the service provider.

[0064] In one possible design, in another implementation of another aspect of the embodiment of the present application, the target billing file further includes second target billing data presented in a second updated billing format, wherein the second target billing data is billing data obtained after replacing the second updated billing data with actual billing data of the target object;

[0065] The display module is further configured to, in response to a download operation on the target template and before generating the target bill file, display a template creation page of the second sub-template in response to a selection operation on the newly added template control, wherein the second sub-template is a sub-template in the target template, and the template creation page of the second sub-template is configured to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0066] The display module is further configured to display second initial bill data in a second initial bill format on the second sub-template page in response to a selection operation of a second data source option on a template creation page for the second sub-template, wherein the second data source option belongs to one of the at least one data source options, and the second initial bill data is derived from a set of bill sample data corresponding to the second data source option.

[0067] The display module is further used to display second updated bill data in accordance with a second updated bill format on a second sub-template page in response to an editing operation on the second sub-template, wherein the second updated bill data is derived from the bill sample data.

[0068] In one possible design, in another implementation of another aspect of the embodiment of the present application, the bill file generating device further includes a processing module;

[0069] A processing module, used for updating the header data and footer data in the first sub-template if the data row in the first sub-template is updated;

[0070] The processing module is also used to update the footer data in the first sub-template if the header data in the first sub-template is updated.

[0071] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0072] The processing module is further used to establish and store an association relationship between the target object and at least one template, wherein the at least one template includes the target template;

[0073] The processing module is further used to establish and store an association relationship between the target template and at least one sub-template, wherein the at least one sub-template includes a first sub-template;

[0074] The processing module is further used to establish and store an association relationship between the first sub-template, the first updated bill format, and the first target bill data.

[0075] In one possible design, in another implementation of another aspect of the embodiment of the present application,

[0076] A generating module, specifically configured to obtain a target template from a template database in response to a download operation on the target template;

[0077] Render the target template to obtain the target bill file.

[0078] Another aspect of the present application provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned methods when executing the computer program.

[0079] Another aspect of the present application provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the above-mentioned methods are implemented.

[0080] Another aspect of the present application provides a computer program product, including a computer program, which implements the above-mentioned methods when executed by a processor.

[0081] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:

[0082] In an embodiment of the present application, a method for generating a bill file is provided. First, in response to a selection operation for a target template, a template creation page of a first sub-template is displayed. Then, in response to a selection operation for a first data source option on the template creation page for the first sub-template, first initial bill data is displayed on the first sub-template page in accordance with a first initial bill format. Based on this, in response to an edit operation for the first sub-template, first updated bill data is displayed on the first sub-template page in accordance with a first updated bill format. When responding to a download operation for the target template, a target bill file is generated, the target bill file includes first target bill data presented in accordance with a first updated bill format, and the first target bill data is the bill data obtained after replacing the first updated bill data with the actual billing data of the target object. Through the above method, users are supported to perform visual editing operations on each sub-template under the target template, so that the sub-template can present the corresponding bill format and bill data according to user needs, which not only improves the efficiency of bill making, but also has high flexibility. In addition, the bill data used in the visual editing process belongs to bill sample data, not the actual billing data of the customer, thus avoiding the problem of low data reading efficiency caused by relying on actual billing data. BRIEF DESCRIPTION OF THE DRAWINGS

[0083] Figure 1 A schematic diagram of an implementation environment of the bill file generation method in the embodiment of the present application;

[0084] Figure 2 A schematic diagram of an implementation framework of the bill file generation method in an embodiment of the present application;

[0085] Figure 3 A flowchart of a method for generating a bill file in an embodiment of the present application;

[0086] Figure 4 A schematic diagram of an interface for selecting a target template in an embodiment of the present application;

[0087] Figure 5 A schematic diagram of an interface for downloading a target template in an embodiment of the present application;

[0088] Figure 6 A schematic diagram of an interface for selecting a system data source in an embodiment of the present application;

[0089] Figure 7 A schematic diagram of an interface for selecting a custom data source in an embodiment of the present application;

[0090] Figure 8 A schematic diagram of an interface for filtering a data source in a sub-template in an embodiment of the present application;

[0091] Fig. 9A schematic diagram of an interface for aggregating data sources in a sub-template in an embodiment of the present application;

[0092] Fig.10 A schematic diagram of an interface for inserting a new data column in an embodiment of the present application;

[0093] Fig.11 A schematic diagram of an interface for replacing fields in a data column in an embodiment of the present application;

[0094] Fig.12 A schematic diagram of an interface for generating a summation result in an embodiment of the present application;

[0095] Fig.13 A schematic diagram of an interface for adjusting a cell format in an embodiment of the present application;

[0096] Fig.14 A schematic diagram of an interface for adding header data in an embodiment of the present application;

[0097] Fig.15 A schematic diagram of an interface for adding footer data in an embodiment of the present application;

[0098] Fig.16 This is a schematic diagram of an interface for a newly added sub-template in an embodiment of the present application;

[0099] Fig.17 This is a schematic diagram of an overall framework of the interaction between the front-end and the back-end in the embodiment of the present application;

[0100] Fig.18 A schematic diagram of a process for implementing sub-template updating in an embodiment of the present application;

[0101] Fig.19 A schematic diagram of the background storage structure in the embodiment of the present application;

[0102] Fig. 20 A schematic diagram of a process for downloading bill files in the backend in an embodiment of the present application;

[0103] Fig.21 A schematic diagram of a bill file generating device in an embodiment of the present application;

[0104] Fig. 22 It is a structural diagram of a terminal in an embodiment of the present application. DETAILED DESCRIPTION

[0105] The embodiment of the present application provides a method for generating a bill file, a related device, an apparatus and a storage medium, which can present the corresponding bill format and bill data according to user needs, which not only improves the efficiency of bill making, but also has high flexibility. In addition, it also avoids the problem of low data reading efficiency caused by relying on actual billing data.

[0106] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein, for example. In addition, the terms "including" and "corresponding to" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0107] With the diversification of business types, service providers can provide corresponding services to customers according to their needs. Since different customers often have different needs, it is necessary to provide customers with customized bills. Take cloud service providers as an example. Cloud service providers provide customers with computing, network and storage capabilities based on hardware and software resources. Take multimedia providers as an example. Multimedia providers provide customers with audio and video products based on hardware and software resources. It can be seen that these service providers need to customize bills based on the usage details of traffic charges for different services.

[0108] Based on this, the present application provides a method for generating a customized bill file, which can convert standard bill usage data into customized bills that meet the personalized needs of customers with the help of configurable customization platform capabilities. Users (for example, service providers' reconciliation team members, customers' account verification team members, or devices with artificial intelligence, etc.) operate on a visual editing page based on the bill sample (demo) data in a WYSIWYG manner. In addition, the bill customization platform precipitates a variety of structured and unstructured data sources into bill sample data. When users customize bills, they operate based on the bill sample data without relying on the actual billing data, thereby avoiding the problem of time-consuming reading and processing that may exist when relying on the actual billing data. The bill customization platform converts the user's operations on the bill sample data into background language and saves it according to the template dimension. The template can be applied to dynamically changing actual billing data to generate bill files that meet user needs.

[0109] It is understandable that the method provided by the present application has the customization operation of cloud computing industry bills. Among them, cloud computing is a computing model that distributes computing tasks on a resource pool composed of a large number of computers, so that various application systems can obtain computing power, storage space and information services as needed. The network that provides resources is called a "cloud". The resources in the "cloud" are infinitely expandable in the eyes of users, and can be obtained at any time, used on demand, expanded at any time, and paid for by use.

[0110] As a provider of basic cloud computing capabilities, a cloud computing resource pool (referred to as a cloud platform, generally referred to as infrastructure as a service (IaaS)) platform will be established, and various types of virtual resources will be deployed in the resource pool for external customers to choose to use. The cloud computing resource pool mainly includes: computing devices (virtualized machines, including operating systems), storage devices, and network devices. According to the logical function division, the platform as a service (PaaS) layer can be deployed on the IaaS layer, and the software as a service (SaaS) layer can be deployed on the PaaS layer. SaaS can also be deployed directly on IaaS. PaaS is a platform for software operation, such as databases, web containers, etc. SaaS is a variety of business software, such as web portals, SMS mass senders, etc. Generally speaking, SaaS and PaaS are upper layers relative to IaaS.

[0111] The method provided in this application can be applied to Figure 1 The implementation environment shown in the figure includes a terminal 110 and a server 120, and the terminal 110 and the server 120 can communicate with each other through a communication network 130. The communication network 130 uses standard communication technology and / or protocols, usually the Internet, but can also be any network, including but not limited to Bluetooth, local area network (LAN), metropolitan area network (MAN), wide area network (WAN), mobile, dedicated network or any combination of virtual private networks. In some embodiments, customized or dedicated data communication technology can be used to replace or supplement the above data communication technology.

[0112] The terminal 110 involved in this application includes but is not limited to mobile phones, computers, intelligent voice interaction devices, smart home appliances, vehicle terminals, aircraft, etc. Among them, the client is deployed on the terminal 110, and the client can run on the terminal 110 in the form of a browser, or in the form of an independent application (application, APP), etc. The server 120 involved in this application can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), and big data and artificial intelligence (AI) platforms.

[0113] It should be noted that the terminal 110 provides a visual editing page of the bill customization platform. Based on the visual editing page, the user can implement specific functions supported by the bill customization platform (for example, selecting data sources, data filtering, data aggregation, table association, allowing to add rows and columns, format adjustment, adding headers and footers, and downloading, etc.).

[0114] In combination with the above implementation environment, the user selects a template as the target template through the terminal 110, and the terminal 110 sends a target template selection instruction to the server 120 through the communication network 130 based on the target template selected by the user. Based on this, the server 120 feeds back the target template to the terminal 110, and the terminal 110 displays the target template. Therefore, the user can edit the sub-template in the target template through the terminal 110, and the terminal 110 presents the effect of the user's editing in real time. The terminal 110 transmits the edited sub-template to the server 120, and the server 120 stores the sub-template. Therefore, when the user needs to download the bill file corresponding to the target template, the server 120 generates the corresponding bill file according to each sub-template included in the target template.

[0115] based on Figure 1 The implementation environment shown is shown in Figure 2 , Figure 2This is a schematic diagram of an implementation framework of the bill file generation method in the embodiment of the present application. As shown in the figure, the bill customization platform presets the bill sample data according to the data source. For example, 10 standard bill data sources and more than 100 usage detail data sources can be set. The user creates a template, and one template corresponds to a bill file. Among them, a template can include N sub-templates (sheets), each sub-template needs to specify a specific data source, and supports operations such as data filtering, data association, data aggregation and data processing. The visual editing page presents the data processing process in a flat manner, and the user can perform row and column processing or format adjustment through the visual editing page. The system converts the user's configuration based on the bill sample data into a background language (for example, a hypertext preprocessor (PHP)) for storage. When a template is issued, the user selects the object identifier (user identification number, UIN) and the month range and clicks to download. The bill customization platform adapts the configuration of the template according to the actual billing data, and finally generates a customized bill file.

[0116] Since this application involves some terms related to professional fields, they will be explained below for ease of understanding.

[0117] (1) Standard bill: The billing system generates fee data after completing the transaction deduction based on the user's order or usage, matching the price discount information, and reflecting the user's monthly consumption amount at the cloud service provider, the amount calculation, and the corresponding resource details.

[0118] (2) Usage details: Usage details provide detailed usage data for pay-as-you-go products to support reconciliation, such as CDN 5-minute details, SMS sending details, and cloud object storage (COS) bucket details.

[0119] (3) Customized bills: The customized bill platform processes bills based on data sources such as standard bills, usage details, and custom files. The amount remains consistent with the standard bill, and only the display form and format are different.

[0120] Combined with the above introduction, the following will introduce the bill file generation method in this application, please refer to Figure 3 The bill file generation method in the embodiment of the present application can be completed by the terminal independently, or by the terminal and the server in cooperation. The method of the present application includes:

[0121] 210. In response to a selection operation on a target template, a template creation page of a first sub-template is displayed, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is used to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0122] In one or more embodiments, the user selects one of the templates as the target template through the bill customization platform. Based on this, the template creation page of the first sub-template in the target template can be displayed. The first sub-template can be represented as a sheet, and the target template can include N sheets, that is, N sub-templates.

[0123] Specifically, in the process of creating a sub-template, you need to first select the corresponding data source option through the template creation page of the sub-template. Each data source option corresponds to a set of bill sample data, where the bill sample data refers to the preset demo data, not the real billing data.

[0124] It is understandable that each template corresponds to an object identifier, and an object identifier can be associated with at least one template. The object identifier is a unique identifier of a customer. The object identifier can be represented by an account number, a mobile phone number, an email address, etc., which is not limited here. In this application, the target template has an association relationship with the object identifier corresponding to the target object.

[0125] It should be noted that the term "in response to" in this application is used to indicate the conditions or states on which the execution of an operation depends, and one or more operations can be executed when certain conditions or states are met. These operations can be real-time or have a certain delay.

[0126] 220. In response to a selection operation of a first data source option on a template creation page for a first sub-template, displaying first initial bill data on the first sub-template page in a first initial bill format, wherein the first data source option is one of at least one data source option, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option;

[0127] In one or more embodiments, the user selects one of the data source options provided on the template creation page of the first sub-template as the first data source option. Thus, according to the first data source option selected by the user, the first initial bill data is displayed in the first initial bill format on the first sub-template page.

[0128] It can be understood that, in one case, the first initial bill format refers to a bill format that has not been edited by the user, and in another case, if the first sub-template has been edited by the user before, then the first initial bill format refers to the bill format saved by the user last time. The first initial bill data is derived from a set of bill sample data corresponding to the first data source option, and the set of bill sample data is used to fill in the data part of the first initial bill format.

[0129] 230. In response to an editing operation on the first sub-template, displaying first updated bill data on the first sub-template page in a first updated bill format, wherein the first updated bill data is derived from the bill sample data;

[0130] In one or more embodiments, the user performs editing operations on the first sub-template page, such as data filtering, data association, data aggregation, and data processing. Based on the user's editing operation, the editing effect is displayed in real time. After the editing of the first sub-template is completed, the first updated bill data displayed in the first updated bill format is obtained. The first updated bill format is different from the first initial bill format, and the first updated bill data may be the same as or different from the first initial bill data.

[0131] 240. In response to a download operation for a target template, a target bill file is generated, wherein the target bill file includes first target bill data presented in a first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

[0132] In one or more embodiments, after completing the editing operation of at least one sub-template in the target template, an updated target template is obtained. Based on this, when the user triggers the download operation of the target template, each updated billing data in the target template is replaced with the actual billing data of the target object, thereby obtaining the target billing data of the target template. A target billing file is generated according to the target billing data of the target template.

[0133] Specifically, since the target template includes at least the first sub-template, after replacing the first updated billing data with the actual billing data of the target object, the first target billing data can be obtained. The first target billing data is included in the target billing data, and the first target billing data is displayed in the first updated billing format.

[0134] It should be noted that the target bill file includes at least one sheet, and a sheet can include header data, body data, and footer data. Each part of the data includes text, function, text format, cell format, etc., and the footer data also supports pictures.

[0135] In an embodiment of the present application, a method for generating a bill file is provided. Through the above method, users are supported to perform visual editing operations on each sub-template under the target template, so that the sub-template can present the corresponding bill format and bill data according to user needs, which not only improves the efficiency of bill production, but also has high flexibility. In addition, the bill data used in the visual editing process belongs to the bill sample data, not the actual billing data of the customer, thus avoiding the problem of low data reading efficiency due to reliance on actual billing data.

[0136] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to a selection operation on a target template, displaying a template creation page of a first sub-template may specifically include:

[0137] Displaying a template management page, wherein the template management page is used to provide template information and editing controls corresponding to each editable template in at least one editable template, wherein the template information includes at least one of a template identifier, an object identifier, a template name, a template creation time, creator information, template status information, and a template effective time;

[0138] In response to a selection operation on an edit control corresponding to a target template, a template creation page of a first sub-template is displayed, wherein the target template belongs to one of the at least one editable templates.

[0139] In one or more embodiments, a method for selecting a target template is introduced. As can be seen from the above embodiments, a user can select an editable template as a target template through the template management page provided by the bill customization platform. The process of selecting a target template will be described below with reference to the diagram.

[0140] Specifically, for ease of understanding, see Figure 4 , Figure 4 This is a schematic diagram of an interface for selecting a target template in an embodiment of the present application. Figure 4 The figure (A) shows the template management page. Among them, 6 editable templates are provided in the template management page, and each editable template corresponds to template information and editing controls. Take the template information of the editable template indicated by A1 as an example, where the template identifier is "1010". The object identifier is "1234000". The template name is "Server Statement". The template creation time is "2023-06-06 16:18:30". The creator information is "tom". The template status information is "approved". The template effective time is "2023-06-08 10:07:04".

[0141] Assume that the user selects the editable template indicated by A1 as the target template. Based on this, when the edit control indicated by A2 is clicked, the selection operation for the edit control corresponding to the target template is triggered. Figure 4 The template creation page of the first sub-template shown in Figure (B) includes a pop-up window indicated by A3, and the user can perform relevant operations through the pop-up window indicated by A3.

[0142] Secondly, in the embodiment of the present application, a method for selecting a target template is provided. Through the above method, one or more editable templates are displayed on the template management page, and the user can directly select one of the editable templates as the target template for editing according to actual needs. Thus, the convenience and flexibility of the operation are improved.

[0143] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, the template management page is further used to provide a download control corresponding to each editable template in at least one editable template;

[0144] In response to the download operation for the target template, generating a target bill file may specifically include:

[0145] In response to a selection operation on a download control corresponding to a target template, a bill download page is displayed, wherein the bill download page is used to provide a start date control, an end date control, and a confirmation control;

[0146] In response to an input operation on a start date control in a bill download page, displaying a bill start date;

[0147] In response to an input operation on an end date control in a bill download page, displaying a bill end date;

[0148] In response to the selection operation on the confirmation control, a target billing file is generated according to the billing start date and the billing end date, wherein the billing start date and the billing end date are used to determine the actual billing data of the target object.

[0149] In one or more embodiments, a method for downloading a customized bill file is introduced. As can be seen from the above embodiments, a user can select an editable template as a target template through the template management page provided by the bill customization platform, and perform a download operation on the target template. The process of downloading the target template will be described below with reference to the diagram.

[0150] Specifically, for ease of understanding, see Figure 5 , Figure 5 This is a schematic diagram of an interface for downloading a target template in an embodiment of the present application. Figure 5The figure (A) shows the template management page. The template management page provides 6 editable templates, each of which corresponds to a download control. Assuming that the user selects the editable template indicated by B1 as the target template, based on this, when clicking the download control indicated by B2, the selection operation for the download control corresponding to the target template is triggered. Thus, the following is displayed: Figure 5 The bill download page shown in Figure (B) includes a pop-up window indicated by B3.

[0151] In the bill download page, B4 is used to indicate the start date control, B5 is used to indicate the end date control, and B6 is used to indicate the confirmation control. Exemplarily, when the user clicks the start date control indicated by B4, a date selection table may be displayed, and the user may select a date as the bill start date through the date selection table, thereby triggering an input operation for the start date control. Exemplarily, when the user clicks the start date control indicated by B4, the bill start date may be entered in the corresponding input box, thereby triggering an input operation for the start date control.

[0152] Similarly, illustratively, when the user clicks the end date control indicated by B5, a date selection table may be displayed, and the user may select a date as the bill end date through the date selection table, thereby triggering an input operation for the end date control. illustratively, when the user clicks the end date control indicated by B5, the bill end date may be entered in the corresponding input box, thereby triggering an input operation for the start date control.

[0153] It is understandable that the bill start date and the bill end date can be specific to the month or the date, which is not limited here. After obtaining the bill start date and the bill end date, click the confirmation control indicated by B6, that is, trigger the selection operation for the confirmation control. Thus, the target bill file can be generated according to the bill start date and the bill end date. Taking the figure as an example, the actual billing data in the target bill file is data from April 2023 to May 2023.

[0154] It should be noted that if the system bill discount is incorrect, you can refresh the discount to form a "re-bill". The fields of "re-bill" and "system bill" are the same, but the discount amount will be different. If a customer has a re-bill discount in a certain month and the account adjustment has not been completed, when downloading a customized bill, the user can choose to generate customized bill data based on the "re-bill".

[0155] Again, in the embodiment of the present application, a method for downloading a customized bill file is provided. Through the above method, the user can customize the bill start date and the bill end date. Thus, the bill customization platform can generate bill files for the corresponding time period according to the time dimension to meet the actual needs of the user.

[0156] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiments of the present application, in response to a selection operation of a first data source option on a template creation page for a first sub-template, displaying first initial bill data in a first initial bill format on the first sub-template page may specifically include:

[0157] In response to a selection operation of a first data source option on a template creation page for a first sub-template, when the first data source option corresponds to a system data source, first initial bill data is displayed in a first initial bill format on the first sub-template page.

[0158] In one or more embodiments, a method for a user to select a system data source is introduced. As can be seen from the above embodiments, the user selects a system data source through a template creation page provided by the bill customization platform. Typically, several system data sources may be provided, each corresponding to a data source option.

[0159] Specifically, for ease of understanding, see Figure 6 , Figure 6 This is a schematic diagram of an interface for selecting a system data source in an embodiment of the present application, as shown in the figure, taking the template creation page of the first sub-template as an example, wherein the template creation page includes a pop-up window indicated by C1. The 7 data source options indicated by C2 are displayed in the pop-up window indicated by C1, and the user can select one of the data source options (for example, the data source option corresponding to the L1 bill) as the first data source option. Among them, the 7 data source options indicated by C2 belong to the data source options corresponding to different system data sources respectively. After the selection is completed, click the confirmation control indicated by C3 to display the first initial bill data in the first sub-template page according to the first initial bill format.

[0160] It should be noted that the granularity of L0 bills to L3 bills becomes more detailed layer by layer. L0 bills refer to account-level data sources, among which the sub-data sources included in L0 bills mainly include overview sub-data sources, consumption sub-data sources, refund sub-data sources, and account adjustment sub-data sources. L1 bills refer to product or project-level data sources. Among them, the sub-data sources included in L1 bills mainly include sub-data sources summarized by product, sub-data sources summarized by project, and sub-data sources summarized by product project. L2 bills refer to resource-level data sources. Among them, the sub-data sources included in L2 bills mainly include sub-data sources of resource bills. L3 bills refer to detail-level data sources. Among them, the sub-data sources included in L3 bills mainly include sub-data sources of detailed bills and sub-data sources of detailed bills summarized by month.

[0161] Secondly, in the embodiment of the present application, a method for users to select system data sources is provided. Through the above method, users can directly select a data source from the already set data sources for editing. This can save the user's time in manually inputting the data source and improve the efficiency of template editing.

[0162] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiments of the present application, in response to a selection operation of a first data source option on a template creation page for a first sub-template, displaying first initial bill data in a first initial bill format on the first sub-template page may specifically include:

[0163] In response to a selection operation of a first data source option on a template creation page for a first sub-template, if the first data source option corresponds to a custom data source, displaying a file list, wherein the file list is used to provide at least one selectable file;

[0164] In response to a selection operation on a target file in the file list, uploading the target file, wherein the target file is one of the at least one selectable file;

[0165] When the target file passes the review, the first initial billing data is displayed in the first sub-template page according to the first initial billing format based on the target file, wherein the target file includes the first initial billing data corresponding to the first initial billing format.

[0166] In one or more embodiments, a method for a user to select a custom data source is introduced. As can be seen from the above embodiments, the user selects to upload a custom file as a custom data source through the template creation page provided by the bill customization platform.

[0167] Specifically, for ease of understanding, see Figure 7 , Figure 7This is a schematic diagram of an interface for selecting a custom data source in an embodiment of the present application. As shown in the figure, the template creation page of the first sub-template is taken as an example, wherein the template creation page includes a pop-up window indicated by D1. The data source option indicated by D2 is displayed in the pop-up window indicated by D1, and the user can select the data source option as the first data source option. Among them, the data source option indicated by D2 belongs to the data source option corresponding to the custom data source.

[0168] After clicking the data source option indicated by D2, a file list is displayed. Based on this, the user can select one of the optional files from the file list as the target file. Then click the confirmation control indicated by D3, thereby uploading the target file to the background for review. If the target file passes the review, based on the data source in the target file, the first initial bill data is displayed on the first sub-template page in the first initial bill format.

[0169] Secondly, in the embodiment of the present application, a method for a user to select a custom data source is provided. Through the above method, a user can upload a file as a custom data source, thereby improving the flexibility and richness of template editing.

[0170] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0171] In response to the data source editing operation on the first sub-template, displaying a conditional filter box on the template creation page of the first sub-template;

[0172] In response to an input operation on the conditional filter box, a data row field value is obtained, wherein the data row field value is used to indicate T data rows in the first sub-template, and T is an integer greater than or equal to 1;

[0173] The first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data rows remaining after T data rows have been removed.

[0174] In one or more embodiments, a method for filtering a data source is introduced. As can be seen from the above embodiments, the user triggers the data source editing operation through the sub-template page provided by the bill customization platform, thereby selecting the data row field value to be filtered from the sub-template. The following will be described by taking the first sub-template page as an example.

[0175] Specifically, for ease of understanding, see Figure 8 , Figure 8This is a schematic diagram of an interface for filtering data sources in a sub-template in an embodiment of the present application, such as Figure 8 Taking the first sub-template page shown in Figure (A) as an example, the first initial bill data (e.g., bill sample data including object identifier, product name, domestic and international, billing mode, original total price, and cash account expenditure) is displayed on the first sub-template page in accordance with the first initial bill format (e.g., 16 rows and 6 columns). When the user clicks the table setting control indicated by E1, the data source editing operation for the first sub-template is triggered. Thus, the display is as follows: Figure 8 The template creation page of the first sub-template shown in Figure (B) is shown in Figure 1.

[0176] Among them, the template creation page of the first sub-template includes the pop-up window indicated by E2. The conditional filter box indicated by E3 is displayed in the pop-up window indicated by E2. Exemplarily, it is assumed that the user selects the "include" relationship for "Product Name" in the conditional filter box indicated by E3, and "Product Name" contains the field value of "All". The "include" relationship is selected for "Domestic and International", and "Domestic and International" contains the field value of "All". The "include" relationship is selected for "Billing Mode", and "Billing Mode" contains the field value of "Pay as you Go".

[0177] After the user completes the input operation for the conditional filter box, it can be determined that the data row field values ​​include all the field values ​​of "Product Name", all the field values ​​of "Domestic and International", and the "Pay-per-Use" field value of "Billing Mode". Based on this, the T data rows that need to be filtered can be determined from the first sub-template. In this example, these T data rows include 5 data rows of "Yearly and Monthly Packages", that is, at this time, T = 5.

[0178] After the user clicks the confirmation control indicated by E4, the following is displayed: Figure 8 The first sub-template page shown in Figure (C) is shown in the figure. At this time, the first updated bill data (e.g., bill sample data including object identifier, product name, domestic and international, billing mode, original total price, and cash account expenditure) is displayed on the first sub-template page in accordance with the first updated bill format (e.g., 11 rows and 6 columns). It can be seen that the first updated bill format includes the remaining data rows after T data rows have been removed.

[0179] Secondly, in the embodiment of the present application, a method for filtering data sources is provided. Through the above method, users can choose to filter out data that they are not concerned about temporarily, reduce the complexity of the data, and thus help users and organizations better understand and use the data.

[0180] Optionally, in the above Figure 3On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0181] In response to the aggregate editing operation on the first sub-template, a field aggregation page is displayed, wherein the field aggregation page is used to provide field options corresponding to each data column in the first sub-template;

[0182] In response to a selection operation on K field options in a field aggregation page, aggregation processing is performed on the same data in the K data columns, wherein the K field options have a one-to-one correspondence with the K data columns, and K is an integer greater than or equal to 1;

[0183] The first update bill data is displayed on the first sub-template page in a first update bill format, wherein the first update bill format includes at least one data row after aggregation processing.

[0184] In one or more embodiments, a method for aggregating data sources is introduced. As can be seen from the above embodiments, the user triggers the aggregation editing operation through the sub-template page provided by the bill customization platform, thereby selecting the data column to be aggregated from the sub-template. The following will be described by taking the first sub-template page as an example.

[0185] Specifically, for ease of understanding, see Fig. 9 , Fig. 9 This is a schematic diagram of an interface for aggregating data sources in a sub-template in an embodiment of the present application, such as Fig. 9 Taking the first sub-template page shown in Figure (A) as an example, the first initial bill data (e.g., bill sample data including object ID, product name, domestic and international, billing mode, original total price, and cash account expenditure) is displayed on the first sub-template page in accordance with the first initial bill format (e.g., 16 rows and 6 columns). When the user clicks the insert pivot table control indicated by F1, the aggregate editing operation for the first sub-template is triggered. Thus, in one case, the following can be created: Fig. 9 The field aggregation page shown in Figure (B) in the figure. In another case, the field aggregation page can be directly displayed as the first sub-template page.

[0186] The field aggregation page includes a pop-up window indicated by F2. The pop-up window indicated by F2 displays the field options corresponding to each data column in the first sub-template, namely, the "object identifier" field option, the "product name" field option, the "domestic and international" field option, the "billing mode" field option, the "original total price" field option, and the "cash account expenditure (yuan)" field option. Assume that the user selects the "billing mode" field option and the "original total price" field option indicated by F3, that is, triggering the selection operation for K field options, at this time, K=2.

[0187] Based on this, according to the "Billing Mode" field option, the data column corresponding to the "Billing Mode" needs to be aggregated to obtain the two results of "Pay-As-You-Go" and "Yearly and Monthly Package". According to the "Original Total Price" field option, the data column corresponding to the "Original Total Price" needs to be aggregated to obtain the sum of the original total price corresponding to "Pay-As-You-Go" and the sum of the original total price corresponding to "Yearly and Monthly Package".

[0188] At this time, the first updated bill data (eg, including the billing mode and the sum of the original total price) is displayed on the first sub-template page in the first updated bill format (eg, 3 rows and 2 columns). It can be seen that the first updated bill format includes at least one data row after aggregation processing.

[0189] Secondly, in the embodiment of the present application, a method for aggregating data sources is provided. By aggregating indicators along dimensions in the above manner, richer data analysis effects can be achieved, thereby helping users and organizations to better understand and use data.

[0190] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0191] In response to the data column insert operation for the first sub-template, displaying a data column editing page, wherein the data column editing page is used to provide a column name input box and an expression input box;

[0192] In response to an input operation on a column name input box in a data column editing page, a data column name is obtained, wherein the data column name is a column name of a newly added data column;

[0193] If in response to the operation editing operation on the expression input box, displaying the first updated bill data in the first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies the first expression, and the first expression is generated according to the operation editing operation;

[0194] If in response to a column splicing editing operation on the expression input box, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies a second expression, the second expression is generated according to the column splicing editing operation, and the second expression includes field names of at least two data columns in the first sub-template;

[0195] In response to a cross-table association editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column that satisfies a third expression, and the third expression is generated based on the cross-table association editing operation.

[0196] In one or more embodiments, a method for editing an inserted data column is introduced. As can be seen from the aforementioned embodiments, the user triggers the data column insertion operation through the sub-template page provided by the bill customization platform. Taking the first sub-template page as an example, illustratively, after the user right-clicks on the first sub-template page, an "Insert Column" option may be displayed. When the user clicks on the option, the data column insertion operation for the first sub-template is triggered. In actual applications, other methods may also be used to insert new data columns, which are not limited here.

[0197] Specifically, for ease of understanding, see Fig.10 , Fig.10 This is a schematic diagram of an interface for inserting a new data column in an embodiment of the present application. As shown in the figure, the data column editing page is shown in the figure, wherein the data column editing page includes a pop-up window indicated by G1. The column name input box indicated by G2 and the expression input box indicated by G3 are displayed in the pop-up window indicated by G1. The user can enter the data column name in the column name input box indicated by G2, for example, "untaxed amount", thereby obtaining the column name of the new data column.

[0198] Exemplarily, the user may enter a first expression in the expression input box indicated by G3, thereby triggering an operation editing operation for the expression input box. The first expression is an expression that supports four arithmetic operations, for example, "[[#column name A / 1.06]]". Based on this, when the confirmation control indicated by G4 is clicked, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, and the first updated bill format includes a newly added data column that satisfies the first expression.

[0199] Exemplarily, the user can enter a second expression in the expression input box indicated by G3, thereby triggering a column splicing editing operation for the expression input box. The second expression is an expression that supports splicing of multiple data columns, for example, "[[#column name A]][[#column name B]]". Based on this, when the confirmation control indicated by G4 is clicked, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, and the first updated bill format includes a newly added data column that satisfies the second expression.

[0200] Exemplarily, the user can enter a third expression in the expression input box indicated by G3, thereby triggering a cross-table association editing operation for the expression input box. The third expression is an expression of a vertical search (VLOOKUP) function, for example, "[[VLOOKUP(#current table column name, @matched sheet name, matched column name, column name to be returned)]]". Based on this, when the confirmation control indicated by G4 is clicked, the first updated bill data is displayed in the first updated bill format on the first sub-template page, and the first updated bill format includes a newly added data column that satisfies the third expression.

[0201] Secondly, in the embodiment of the present application, a method for editing the inserted data column is provided. Through the above method, the new data column inserted by the user can support operations, splicing, and cross-table association, so as to help users and organizations better understand and use data.

[0202] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0203] In response to a field editing operation on a target data column in the first sub-template, displaying a field replacement page, wherein the field replacement page is used to provide an original field input box and a replacement field input box;

[0204] In response to an input operation on an original field input box in a field replacement page, obtaining an original value field value for a target data column;

[0205] In response to an input operation on a replacement field input box in a field replacement page, obtaining a target field value for a target data column;

[0206] In response to the editing completion operation on the target data column in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the target data column after the field editing operation.

[0207] In one or more embodiments, a method for replacing fields in a data column is introduced. As can be seen from the above embodiments, a user triggers a field editing operation through a sub-template page provided by a bill customization platform, thereby replacing field values ​​in a selected target data column. The following will be described using the first sub-template page as an example.

[0208] Specifically, for ease of understanding, see Fig.11 , Fig.11 This is a schematic diagram of an interface for replacing fields in a data column in an embodiment of the present application. As shown in the figure, in one case, after the user selects a data column as the target data column, when the replacement column control indicated by H1 is clicked, the field editing operation for the target data column is triggered, thereby displaying the field replacement page. In another case, after the user clicks the replacement column control indicated by H1, the field editing operation is triggered, thereby, the target data column can be selected through the field replacement page.

[0209] Among them, the field replacement page includes a pop-up window indicated by H2. The field name indicated by H3, the original field input box indicated by H4, and the replacement field input box indicated by H5 are displayed in the pop-up window indicated by H2. Exemplarily, if the user selects "Product Name" in the field name indicated by H3, it means that the data column corresponding to "Product Name" is used as the target data column. Exemplarily, if the user enters "Face Recognition" in the original field input box indicated by H4, then "Face Recognition" is used as the original value field value of the target data column. Exemplarily, if the user enters "Biometric Identification" in the replacement field input box indicated by H5, then "Biometric Identification" is used as the target field value of the target data column.

[0210] Based on this, when the user clicks the confirmation control indicated by H6, that is, the editing completion operation for the target data column in the first sub-template is triggered, thereby displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format. At this time, the first updated bill format includes the target data column after the field editing operation, for example, the field value of "face recognition" in the target data column is replaced with "biometric recognition".

[0211] Secondly, in the embodiment of the present application, a method for replacing fields in a data column is provided. Through the above method, a user can directly replace fields in a selected data column. On the one hand, the user does not need to search for the fields to be replaced, thereby improving processing efficiency. On the other hand, it can avoid the situation where replacement is omitted, thereby improving the reliability of the operation.

[0212] Optionally, in the above Figure 3On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0213] In response to the same type of merging operation on the relevant field values ​​in the first sub-template, displaying the merged data rows on the first sub-template page;

[0214] In response to the data row insert operation in the first sub-template, displaying a data row edit page, wherein the data row edit page is used to provide a sum control corresponding to the relevant data column in the first sub-template;

[0215] In response to a selection operation on at least one summation control in the data row editing page, performing summation calculations on the data columns corresponding to each summation control in the at least one summation control;

[0216] The first updated bill data is displayed on the first sub-template page in a first updated bill format, wherein the first updated bill format includes data rows and data columns that have undergone similar merging operations and summation calculations.

[0217] In one or more embodiments, a method for summing data is introduced. As can be seen from the foregoing embodiments, the user selects to insert a new data row through the sub-template page provided by the bill customization platform, and the new data row supports displaying the summation result of at least one data column. The first sub-template page will be used as an example for explanation below.

[0218] Specifically, for ease of understanding, see Fig.12 , Fig.12 A schematic diagram of an interface for generating a summation result in an embodiment of the present application is shown in FIG. Fig.12 In the first sub-template page shown in Figure (A), the user can select a field value as the relevant field value, for example, select "pay as you go" as the relevant field value. Then, in the window indicated by I1 that pops up, you can select "merge the same data items" indicated by I2, thereby triggering the same type of merge operation for the relevant field values ​​in the first sub-template. Based on this, all "pay as you go" field values ​​in the first sub-template can be aggregated to obtain the merged data rows (for example, 10 data rows corresponding to "pay as you go").

[0219] When the insert row control indicated by I3 is clicked, the data row insert operation in the first sub-template is triggered, thereby displaying Fig.12The data row editing page shown in Figure (B) includes a pop-up window indicated by I4. For example, assume that the user selects the "Subtotal" type indicated by I5, and selects "Billing Mode" in the Insert Rule field indicated by I6. In the Sum field, the sum control corresponding to the "Original Total Price" data column indicated by I7 is selected, thereby triggering the selection operation for the sum control, and then the "Original Total Price" of "Pay by Volume" is summed up, and the "Original Total Price" of "Yearly and Monthly Package" is summed up.

[0220] Based on this, after clicking the confirmation control indicated by I8, the following is displayed: Fig.12 The first sub-template page shown in Figure (C). It can be seen that the first updated bill data is displayed in the first updated bill format on the first sub-template page. At this time, the first updated bill format includes data rows and data columns after the same type of merging operation and the sum calculation. Among them, the "pay as you go" field value is the one that has undergone the same type of merging operation, and the "original total price" field value is the one that has undergone the sum calculation.

[0221] Secondly, in the embodiment of the present application, a method for summing data is provided. Through the above method, users can choose to subtotal some field values ​​in the column data or sum all field values ​​in the column data according to actual needs, thereby improving the diversity and flexibility of operations.

[0222] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the editing operation on the first sub-template, displaying the first updated bill data in the first updated bill format on the first sub-template page may specifically include:

[0223] In response to a font editing operation on a cell in the first sub-template, displaying the first updated bill data on the first sub-template page in accordance with a first updated bill format, wherein the first updated bill format includes the cell after the font editing operation;

[0224] If in response to a background color editing operation on a cell in the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes the cell after the background color editing operation;

[0225] If in response to the row height editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data row after the row height editing operation;

[0226] If in response to the column width editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data column after the column width editing operation;

[0227] In response to a merge edit operation on at least two cells in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cells after the merge edit operation.

[0228] In one or more embodiments, a method for supporting the formatting of cells is introduced. As can be seen from the above embodiments, users can perform formatting adjustments through the sub-template page provided by the bill customization platform. The following will be described using the first sub-template page as an example.

[0229] Specifically, for ease of understanding, see Fig.13 , Fig.13 This is a schematic diagram of an interface for adjusting the cell format in an embodiment of the present application. As shown in the figure, J1 is used to indicate a font selection box. For example, a user can set the font of a cell to Songti, thereby triggering a font editing operation for the cells in the first sub-template. J1 is used to indicate a font selection box. For example, a user can set the font of at least one cell to Songti. J2 is used to indicate a font size selection box. For example, a user can set the font size of at least one cell to 10. J2 is used to indicate a font size selection box. For example, a user can set the font size of at least one cell to 10. J3 is used to indicate a bold control. For example, a user clicks the bold control indicated by J3 to set the text in at least one cell to bold. J4 is used to indicate an italic control. For example, a user clicks the italic control indicated by J4 to set the text in at least one cell to italic. J5 is used to indicate an underline control. For example, a user clicks the underline control indicated by J5 to set the text in at least one cell to underline. J6 is used to indicate a font color control. For example, a user can set the text in at least one cell to red.

[0230] Based on at least one of the above operations, a font editing operation for a cell in the first sub-template may be triggered, thereby displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes cells after the font editing operation (e.g., font change, font size change, bold, italic, underline, etc.)

[0231] J7 is used to indicate the background color control. For example, the user can set the background color of at least one cell to gray. Based on the above operation, the background color editing operation for the cell in the first sub-template can be triggered. As a result, the first updated bill data is displayed on the first sub-template page according to the first updated bill format, wherein the first updated bill format includes the cell after the background color editing operation (for example, adding a background color, etc.).

[0232] It is understandable that in actual applications, borders and decimal points can also be set for cells. In addition, at least two cells can be merged. For example, the user selects two adjacent cells and triggers a merge edit operation for the two cells through a merge control, thereby displaying the cells after the merge edit operation.

[0233] It should be noted that, in addition to editing cells, the row height of the data row can also be set, that is, by editing the row height, the height of at least one data row can be set. Thus, at least one data row after the row height editing operation is displayed. In addition, the column width of the data column can also be set, that is, by editing the column width, the width of at least one data column can be set. Thus, at least one data column after the column width editing operation is displayed.

[0234] Secondly, in the embodiment of the present application, a method for supporting the format adjustment of cells is provided. Through the above method, users can adjust the format of cells according to actual needs, which can not only change the appearance of the sub-template, but also increase the diversity of template styles.

[0235] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, the target bill file also includes page header data;

[0236] It may also include:

[0237] In response to a selection operation on a header display control, header data is displayed on the first sub-template page, wherein the header data includes at least one of the title of the first sub-template, the object identifier corresponding to the target template, the name corresponding to the object identifier, and billing cycle information.

[0238] In one or more embodiments, a method of adding header data is introduced. As can be seen from the above embodiments, the user can trigger the operation of displaying header data through the sub-template page provided by the bill customization platform. The following will be described by taking the first sub-template page as an example.

[0239] Specifically, for ease of understanding, see Fig.14 , Fig.14This is a schematic diagram of an interface for adding header data in an embodiment of the present application. As shown in the figure, K1 is used to indicate a header display control. When a user clicks the header display control indicated by K1, a selection operation for the header display control is triggered. Thus, the header data is displayed on the first sub-template page.

[0240] It should be noted that the page header data of the first sub-template includes but is not limited to the title of the first sub-template (for example, server statement), the object identifier corresponding to the target template (i.e., each sub-template in the target template) (for example, 1234000), the name corresponding to the object identifier, and the billing cycle information (for example, April 2023 to May 2023).

[0241] Secondly, in the embodiment of the present application, a method for adding header data is provided. Through the above method, the user can add the header data of the bill with one click, which not only has high flexibility, but also does not need to manually enter the content of the header data, thereby helping to improve the efficiency of bill processing.

[0242] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, the target bill file further includes footer data;

[0243] It may also include:

[0244] In response to a selection operation on a footer display control, footer data is displayed on the first sub-template page, wherein the footer data includes at least one of the name of the business provider, the identification number of the business provider, the address of the business provider, the telephone number of the business provider, the account opening information of the business provider, the payment account number of the business provider, date information, and the icon of the business provider.

[0245] In one or more embodiments, a method of adding footer data is introduced. As can be seen from the above embodiments, the user can trigger the operation of displaying footer data through the sub-template page provided by the bill customization platform. The following will be described by taking the first sub-template page as an example.

[0246] Specifically, for ease of understanding, see Fig.15 , Fig.15 This is a schematic diagram of an interface for adding footer data in an embodiment of the present application. As shown in the figure, L1 is used to indicate a footer display control. When a user clicks the footer display control indicated by L2, a selection operation for the footer display control is triggered. Thus, the footer data is displayed on the first sub-template page.

[0247] It should be noted that the footer data of the first sub-template includes but is not limited to the name of the business provider (for example, XXX Cloud Technology (Beijing) Co., Ltd.), the identification number of the business provider (for example, taxpayer identification number), the address of the business provider, the telephone number of the business provider, the account opening information of the business provider (for example, information of the opening bank), the payment account number of the business provider, date information (for example, June 12, 2023) and the icon of the business provider.

[0248] Secondly, in the embodiment of the present application, a method for adding footer data is provided. Through the above method, the user can add footer data of the bill with one click, which not only has high flexibility, but also does not need to manually enter the content of the footer data, thereby helping to improve the efficiency of bill processing.

[0249] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, the target bill file further includes second target bill data presented in a second updated bill format, wherein the second target bill data is bill data obtained after replacing the second updated bill data with actual billing data of the target object;

[0250] In response to the download operation on the target template, before generating the target bill file, the following may also be included:

[0251] In response to a selection operation on a newly added template control, a template creation page of a second sub-template is displayed, wherein the second sub-template is a sub-template in the target template, and the template creation page of the second sub-template is used to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0252] In response to a selection operation of a second data source option on a template creation page for a second sub-template, second initial bill data is displayed on the second sub-template page in accordance with a second initial bill format, wherein the second data source option is one of the at least one data source options, and the second initial bill data is derived from a set of bill sample data corresponding to the second data source option.

[0253] In response to the editing operation on the second sub-template, second updated bill data is displayed on the second sub-template page in accordance with a second updated bill format, wherein the second updated bill data is derived from the bill sample data.

[0254] In one or more embodiments, a method of adding a new sub-template to a target template is introduced. As can be seen from the above embodiments, a user can select an editable template as a target template through the template management page provided by the bill customization platform, and create multiple sub-templates in the target template.

[0255] Specifically, for ease of understanding, see Fig.16 , Fig.16 This is a schematic diagram of an interface for adding a sub-template in an embodiment of the present application, such as Fig.16 In the first sub-template page shown in Figure (A), M1 is used to indicate a newly added template control. When the user clicks the newly added template control indicated by M1, the selection operation for the newly added template control is triggered. Thus, the following is displayed: Fig.16 The template creation page of the second sub-template shown in Figure (B) wherein the template creation page includes a pop-up window indicated by M2, and the user can perform related operations through the pop-up window indicated by M2.

[0256] Seven data source options are displayed in the pop-up window indicated by M2, and the user can select one of the data source options (for example, the data source option corresponding to the L1 bill) as the second data source option. Among them, the seven data source options belong to the data source options corresponding to different system data sources. After the selection is completed, click the confirmation control indicated by M3 to display the second initial bill data on the second sub-template page in the second initial bill format. Then, the user can edit the second sub-template to display the second updated bill data on the second sub-template page in the second updated bill format. It can be understood that the method of editing the second sub-template is similar to the method of editing the first sub-template, so it will not be repeated here. Moreover, the first sub-template and the second sub-template are both included in the target template.

[0257] Secondly, in the embodiment of the present application, a method for adding a new sub-template to a target template is provided. Through the above method, users can add multiple sub-templates to a template according to actual needs. Thus, based on the configuration capability, various customization needs can be flexibly adapted and template customization can be completed quickly.

[0258] In conjunction with the above embodiments, please refer to Fig.17 , Fig.17 This is a schematic diagram of the overall framework of the interaction between the front-end and the back-end in the embodiment of the present application. As shown in the figure, the overall framework includes three parts, namely, the front-end online visual editing page implementation, the back-end template storage implementation, and the back-end customized bill download implementation.

[0259] In step N1, the user can configure the template through the visual editing page. During the template configuration process, the data source provides the bill sample data required by the template.

[0260] In step N2, after the user completes the template configuration, the background can save the edited template into the template database.

[0261] In step N3, the user downloads the customized bill through the visual editing page.

[0262] In step N4, the backend obtains the template corresponding to the customized bill from the template database according to the customized bill download request triggered by the user, and then replaces the bill sample data in the template with the customer's actual billing data and renders it.

[0263] In step N5, a customized bill file is generated according to the rendered template.

[0264] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, another optional embodiment provided by the embodiment of the present application may further include:

[0265] If the data row in the first sub-template is updated, the header data and footer data in the first sub-template are updated;

[0266] If the header data in the first sub-template is updated, the footer data in the first sub-template is updated.

[0267] In one or more embodiments, a method for implementing page updates based on front-end technology is introduced. As can be seen from the aforementioned embodiments, the background can update the data rows, header data, and footer data in the sub-template (for example, the first sub-template) in combination with the user's front-end operations. Among them, updating the data rows will affect the formula calculations of the header and footer, so the header data and footer data will be checked and updated in conjunction. Updating the header data will affect the formula references and cell coordinates of the footer, so the footer will be checked and updated in conjunction.

[0268] For easier understanding, see Fig.18 , Fig.18 A schematic diagram of a process for implementing sub-template updating in an embodiment of the present application is shown in the figure, specifically:

[0269] In step P1, the user enters the page and initializes the page and components by calling the ":init function". Thus, the corresponding components are obtained and rendered to the page.

[0270] In step P2, it is determined whether the user needs to perform an editing operation on the visual editing page, and if the editing operation is required, step P3 is executed. If the editing operation is not required, step P4 is executed.

[0271] In step P3, the ":loadData() function" is called to load the data corresponding to the template identifier.

[0272] In step P4, the ":showNew() function" is called to display the newly added sub-template page.

[0273] In step P5, based on the pulled data source (ie, bill sample data), determine whether preprocessing is required. If preprocessing is required, execute step P6. If preprocessing is not required, execute step P7.

[0274] In step P6, the ":preHandle(data) function" is called to pre-process the loaded data. For example, field replacement, that is, null value replacement or text replacement, etc. can be performed. For example, assuming that the customer wants to display "-" for the amount "0" or empty text in the bill file, the replacement function will be involved.

[0275] In step P7, call the ":parseData(data) function" to parse the rules of the current sub-template. Parse the configured data field list (dataFieldsList) to perform secondary processing on the data and generate the data that needs to be processed. According to the specific configured rules, perform secondary processing, sorting, insertion, and aggregation on the data. Among them, sorting mainly includes sorting of data column fields (for example, the first priority is "product name", the second priority is "project name", and the third priority is "cash expenditure") and sorting of data column contents (for example, sort the "product name" column in ascending order and the "cash expenditure" column in descending order).

[0276] In step P8, it is determined whether there is a custom column in the sub-template, and if so, step P9 is executed. If not, step P10 is executed.

[0277] It should be noted that step P8 may appear before step P9 or after step P14, and this is not limited here.

[0278] In step P9, call the ":createColumns(columns) function" to insert custom data columns.

[0279] In step P10, it is determined whether there is a custom row in the sub-template, and if so, step P11 is executed. If not, step P12 is executed.

[0280] In step P11, call the ":createRows(rows) function" to insert custom data rows.

[0281] In step P12, it is determined whether there is header data in the sub-template, and if so, step P13 is executed. If not, step P14 is executed.

[0282] In step P13, the ":createHeader(header) function" is called to generate the page header data.

[0283] In step P14, it is determined whether there is footer data in the sub-template, and if so, step P15 is executed. If not, step P16 is executed.

[0284] In step P15, ":createFooter(footer)" is called to generate footer data.

[0285] Therefore, the expression is calculated according to the configuration files of the header and footer to generate the corresponding header and footer files.

[0286] In step P16, it is determined whether the user performs an update operation. If the user performs an update operation, step P17 is executed. If the user does not perform an update operation, step P18 is executed.

[0287] In step P17, at least one of the data row, data column, header data and footer data is updated, wherein the data row update may affect the update of the header data and footer data in conjunction with each other, and the header data update may affect the update of the footer data in conjunction with each other.

[0288] In step P18, the ":calc() function" is called to render the generated header data, billing data, and footer data into the view.

[0289] In step P19, optionally, the ":render() function" may be called to review and approve the submitted template.

[0290] In step P20, the ":save() function" is called to save the configuration of the template to the background.

[0291] Secondly, in the embodiment of the present application, a method for implementing page updates based on front-end technology is provided. Through the above method, the bill customization platform can present the corresponding interface in real time in combination with the user's operation on the front end, achieving a customized effect of what you see is what you get. It can be seen that the present application has strong operability, and can flexibly and efficiently respond to the user's customization needs without repeated coding, improve billing efficiency and user experience, and enhance the operational capabilities of service providers.

[0292] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, another optional embodiment provided by the embodiment of the present application may further include:

[0293] Establishing and storing an association relationship between a target object and at least one template, wherein the at least one template includes a target template;

[0294] Establishing and storing an association relationship between a target template and at least one sub-template, wherein the at least one sub-template includes a first sub-template;

[0295] An association relationship between the first sub-template, the first updated bill format, and the first target bill data is established and stored.

[0296] In one or more embodiments, a method of storing template-related content in the background is introduced. It can be seen from the aforementioned embodiments that for the management of bill sample data, the background stores the type of bill sample data, header fields, and bill sample data. After the user selects a specific set of bill sample data on the front end, the background can return to the front end for visual editing. The background decomposes the data of the visual editing page into three parts, namely the header, body, and footer. Among them, the header and footer are not required, and the user can freely edit the content of the header and footer. In the header and footer, the system presets some functions to dynamically obtain information such as customer name, billing cycle, and collection account number. The body is required, that is, the user performs filtering, aggregation, hiding, adding rows and columns, and format adjustment operations based on the bill sample data.

[0297] Specifically, for ease of understanding, see Fig.19 , Fig.19 This is a schematic diagram of the background storage structure in the embodiment of the present application. As shown in the figure, the background architecture abstracts the data submitted by the entire template into a parent template (for example, a target template), and abstracts each sheet into a child template. The relationship between the parent template and the child template is 1 to N, where N is an integer greater than or equal to 1. The child template stores information such as headers, footers, custom rows, filter conditions, and data sources through an association rule table. The association field table is used to store information such as the coordinates, calculation rules, and styles of each field. If the child template is a custom file, the link to the custom file will also be recorded in the association file table.

[0298] Secondly, in the embodiment of the present application, a method for storing template-related content in the background is provided. Through the above method, the background establishes and stores the relationship between the template and various types of content (for example, sub-templates, rules, etc.), thereby enabling flexible configuration and rotation of the template. This satisfies the bill differentiation demands of different customers or the same customer for different products.

[0299] Optionally, in the above Figure 3 On the basis of the corresponding embodiments, in another optional embodiment provided by the embodiment of the present application, in response to the selection operation on the target template, in response to the download operation on the target template, generating the target bill file may specifically include:

[0300] In response to a download operation on a target template, acquiring the target template from a template database;

[0301] Render the target template to obtain the target bill file.

[0302] In one or more embodiments, a method for downloading a bill file is introduced. As can be seen from the above embodiments, the backend can provide a corresponding target bill file based on the user's operation on the front end. The following will be introduced in conjunction with the diagram.

[0303] For easier understanding, see Fig. 20 , Fig. 20 This is a flow chart of downloading bill files in the background of the present application embodiment, as shown in the figure, specifically:

[0304] In step Q1, the user triggers the download operation of the bill file through the front end of the bill customization platform.

[0305] In step Q2, the background of the bill customization platform obtains the template information corresponding to the target template from the template database, wherein the template information includes at least one of the template identifier, object identifier, template name, template creation time, creator information, template status information and template effective time.

[0306] In step Q3, when generating bill files, you can obtain bill sample data from different data sources, including system bills, usage details, custom files, and support for expanding data sources according to actual needs.

[0307] In step Q4, spreadsheet formats (e.g., xls and xlsx) or comma-separated values ​​(CSV) format files of different data sources can be uniformly processed into a processable data format, supporting multi-dimensional data filtering and cleaning, including but not limited to object identifier, billing month, four product layers (i.e., product, sub-product, component type and component name) and billing mode, etc., to perform "and / or" relationship screening of multiple condition groups.

[0308] In step Q5, during the template rendering process, the page header data in the sub-template may be rendered.

[0309] In step Q6, template rendering includes text rendering. In the text rendering, field-level regular expressions are parsed to support expressions such as subtotals, totals, VLOOKUP functions, preset parameters, addition, four arithmetic operations, and data pivoting.

[0310] In step Q7, during text rendering, header data of the text may be generated.

[0311] In step Q8, in the text rendering, data sorting and aggregation as well as data processing can be performed. Sorting and aggregation are used to pre-process the data to facilitate the implementation of the field ascending and descending order function and the subtotal aggregation function. Data processing is used to implement the corresponding function for the regular expression.

[0312] In step Q9, in the text rendering, the data rows in the sub-template are rendered.

[0313] In step Q10, during the template rendering process, the footer data in the sub-template may be rendered.

[0314] In step Q11, the template rendering process supports merging cells, font style setting, cell style setting, inserting pictures, inserting expressions, etc. Since the same template is applied to downloads without object identification and the actual number of billing data rows in the billing month is not fixed, the corresponding offset calculation needs to be performed for adaptation when setting the body and footer styles.

[0315] Thus, the edited data on the sub-template page is rendered.

[0316] In step Q12, a corresponding billing document is generated.

[0317] Secondly, in the embodiment of the present application, a method for downloading bill files is provided. Through the above method, based on the user's interactive operation at the front end, the back end will execute corresponding instructions according to the user's operation, thereby achieving the effect of customizing the bill file. Thus, the feasibility and operability of the solution are improved.

[0318] The following is a detailed description of the bill file generation device in this application, please refer to Fig.21 , Fig.21 This is a schematic diagram of an embodiment of a bill file generating device in an embodiment of the present application. The bill file generating device 30 includes:

[0319] Display module 310, configured to display a template creation page of a first sub-template in response to a selection operation on a target template, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is configured to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0320] The display module 310 is further configured to display first initial bill data in a first initial bill format on the first sub-template page in response to a selection operation of a first data source option on a template creation page for the first sub-template, wherein the first data source option is one of the at least one data source options, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option;

[0321] The display module 310 is further configured to display first updated bill data in a first updated bill format on the first sub-template page in response to an editing operation on the first sub-template, wherein the first updated bill data is derived from the bill sample data;

[0322] The generation module 320 is used to generate a target bill file in response to a download operation for a target template, wherein the target bill file includes first target bill data presented in a first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

[0323] In an embodiment of the present application, a bill file generation device is provided. The above device is used to support users to perform visual editing operations on each sub-template under the target template, so that the sub-template can present the corresponding bill format and bill data according to user needs, which not only improves the efficiency of bill production, but also has high flexibility. In addition, the bill data used in the visual editing process belongs to the bill sample data, not the actual billing data of the customer, thus avoiding the problem of low data reading efficiency caused by relying on the actual billing data.

[0324] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0325] The display module 310 is specifically used to display a template management page, wherein the template management page is used to provide template information and editing controls corresponding to each editable template in at least one editable template, and the template information includes at least one of a template identifier, an object identifier, a template name, a template creation time, creator information, template status information, and a template effective time;

[0326] In response to a selection operation on an edit control corresponding to a target template, a template creation page of a first sub-template is displayed, wherein the target template belongs to one of the at least one editable templates.

[0327] In an embodiment of the present application, a bill file generation device is provided. With the above device, one or more editable templates are displayed on the template management page, and the user can directly select one of the editable templates as the target template for editing according to actual needs. Thus, the convenience and flexibility of operation are improved.

[0328] Optionally, in the above Fig.21On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application, the template management page is further used to provide a download control corresponding to each editable template in at least one editable template;

[0329] The generating module 320 is specifically used to display a bill download page in response to a selection operation of a download control corresponding to a target template, wherein the bill download page is used to provide a start date control, an end date control, and a confirmation control;

[0330] In response to an input operation on a start date control in a bill download page, displaying a bill start date;

[0331] In response to an input operation on an end date control in a bill download page, displaying a bill end date;

[0332] In response to the selection operation on the confirmation control, a target billing file is generated according to the billing start date and the billing end date, wherein the billing start date and the billing end date are used to determine the actual billing data of the target object.

[0333] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can customize the bill start date and bill end date. Thus, the bill customization platform can generate bill files for the corresponding time period according to the time dimension to meet the actual needs of the user.

[0334] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0335] The display module 310 is specifically used to respond to the selection operation of the first data source option on the template creation page for the first sub-template, and when the first data source option corresponds to the system data source, display the first initial bill data in the first sub-template page according to the first initial bill format.

[0336] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can directly select a data source from the already set data sources for editing. This can save the user's time of manually inputting the data source and improve the efficiency of template editing.

[0337] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0338] The display module 310 is specifically configured to, in response to a selection operation of a first data source option on a template creation page for a first sub-template, display a file list when the first data source option corresponds to a custom data source, wherein the file list is configured to provide at least one selectable file;

[0339] In response to a selection operation on a target file in the file list, uploading the target file, wherein the target file is one of the at least one selectable file;

[0340] When the target file passes the review, the first initial billing data is displayed in the first sub-template page according to the first initial billing format based on the target file, wherein the target file includes the first initial billing data corresponding to the first initial billing format.

[0341] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can upload a file as a custom data source, thereby improving the flexibility and richness of template editing.

[0342] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0343] The display module 310 is specifically configured to display a conditional filter box on a template creation page of the first sub-template in response to a data source editing operation on the first sub-template;

[0344] In response to an input operation on the conditional filter box, a data row field value is obtained, wherein the data row field value is used to indicate T data rows in the first sub-template, and T is an integer greater than or equal to 1;

[0345] The first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data rows remaining after T data rows have been removed.

[0346] In an embodiment of the present application, a bill file generation device is provided. With the above device, users can choose to filter out data that they are not concerned about temporarily, reduce the complexity of the data, and thus help users and organizations better understand and use the data.

[0347] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0348] The display module 310 is specifically configured to display a field aggregation page in response to an aggregate editing operation on the first sub-template, wherein the field aggregation page is configured to provide field options corresponding to each data column in the first sub-template;

[0349] In response to a selection operation on K field options in a field aggregation page, aggregation processing is performed on the same data in the K data columns, wherein the K field options have a one-to-one correspondence with the K data columns, and K is an integer greater than or equal to 1;

[0350] The first update bill data is displayed on the first sub-template page in a first update bill format, wherein the first update bill format includes at least one data row after aggregation processing.

[0351] In an embodiment of the present application, a bill file generation device is provided. By using the above device, indicators are aggregated along dimensions, which can achieve richer data analysis effects. This can help users and organizations better understand and use data.

[0352] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0353] The display module 310 is specifically configured to display a data column editing page in response to the data column insert operation for the first sub-template, wherein the data column editing page is configured to provide a column name input box and an expression input box;

[0354] In response to an input operation on a column name input box in a data column editing page, a data column name is obtained, wherein the data column name is a column name of a newly added data column;

[0355] If in response to the operation editing operation on the expression input box, displaying the first updated bill data in the first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies the first expression, and the first expression is generated according to the operation editing operation;

[0356] If in response to a column splicing editing operation on the expression input box, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes a newly added data column that satisfies a second expression, the second expression is generated according to the column splicing editing operation, and the second expression includes field names of at least two data columns in the first sub-template;

[0357] In response to a cross-table association editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column that satisfies a third expression, and the third expression is generated based on the cross-table association editing operation.

[0358] In an embodiment of the present application, a bill file generation device is provided. The above device can support operations, concatenation, and cross-table association for new data columns inserted by users, thereby helping users and organizations to better understand and use data.

[0359] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0360] The display module 310 is specifically used to display a field replacement page in response to a field editing operation on a target data column in the first sub-template, wherein the field replacement page is used to provide an original field input box and a replacement field input box;

[0361] In response to an input operation on an original field input box in a field replacement page, obtaining an original value field value for a target data column;

[0362] In response to an input operation on a replacement field input box in a field replacement page, obtaining a target field value for a target data column;

[0363] In response to the editing completion operation on the target data column in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the target data column after the field editing operation.

[0364] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can directly replace fields in a selected data column. On the one hand, the user does not need to search for the fields to be replaced, thereby improving processing efficiency. On the other hand, it can avoid the occurrence of replacement omissions, thereby improving the reliability of the operation.

[0365] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0366] The display module 310 is specifically configured to display the merged data rows on the first sub-template page in response to the same type of merge operation on the relevant field values ​​in the first sub-template;

[0367] In response to the data row insert operation in the first sub-template, displaying a data row edit page, wherein the data row edit page is used to provide a sum control corresponding to the relevant data column in the first sub-template;

[0368] In response to a selection operation on at least one summation control in the data row editing page, performing summation calculations on the data columns corresponding to each summation control in the at least one summation control;

[0369] The first updated bill data is displayed on the first sub-template page in a first updated bill format, wherein the first updated bill format includes data rows and data columns that have undergone similar merging operations and summation calculations.

[0370] In an embodiment of the present application, a bill file generation device is provided. With the above device, users can choose to calculate the subtotal of some field values ​​in the column data, or calculate the total of all field values ​​in the column data according to actual needs, thereby improving the diversity and flexibility of operations.

[0371] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0372] The display module 310 is specifically configured to display the first updated bill data in accordance with the first updated bill format on the first sub-template page in response to a font editing operation on a cell in the first sub-template, wherein the first updated bill format includes the cell after the font editing operation;

[0373] If in response to a background color editing operation on a cell in the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill format includes the cell after the background color editing operation;

[0374] If in response to the row height editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data row after the row height editing operation;

[0375] If in response to the column width editing operation in the first sub-template, displaying the first updated bill data in accordance with the first updated bill format on the first sub-template page, wherein the first updated bill format includes the data column after the column width editing operation;

[0376] In response to a merge edit operation on at least two cells in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cells after the merge edit operation.

[0377] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can adjust the format of a cell according to actual needs, which can not only change the appearance of a sub-template, but also increase the diversity of template styles.

[0378] Optionally, in the above Fig.21On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application, the target bill file further includes page header data;

[0379] The display module 310 is also used to display header data on the first sub-template page in response to a selection operation on a header display control, wherein the header data includes at least one of the title of the first sub-template, the object identifier corresponding to the target template, the name corresponding to the object identifier, and billing cycle information.

[0380] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can add the header data of the bill with one click, which not only has high flexibility but also does not need to manually input the content of the header data, thereby facilitating improving the bill processing efficiency.

[0381] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application, the target bill file further includes footer data;

[0382] The display module 310 is also used to display footer data on the first sub-template page in response to a selection operation on a footer display control, wherein the footer data includes at least one of the name of the service provider, the identification number of the service provider, the address of the service provider, the telephone number of the service provider, the account opening information of the service provider, the payment account number of the service provider, date information and the icon of the service provider.

[0383] In an embodiment of the present application, a bill file generation device is provided. With the above device, a user can add footer data of a bill with one click, which not only has high flexibility but also does not need to manually input the content of the footer data, thereby facilitating improving bill processing efficiency.

[0384] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application, the target bill file further includes second target bill data presented in a second updated bill format, wherein the second target bill data is bill data obtained after replacing the second updated bill data with actual billing data of the target object;

[0385] The display module 310 is further configured to, in response to a download operation on the target template and before generating the target bill file, display a template creation page of the second sub-template in response to a selection operation on the newly added template control, wherein the second sub-template is a sub-template in the target template, and the template creation page of the second sub-template is configured to provide at least one data source option, each data source option corresponding to a set of bill sample data;

[0386] The display module 310 is further configured to display second initial bill data in a second initial bill format on the second sub-template page in response to a selection operation of a second data source option on a template creation page for the second sub-template, wherein the second data source option is one of the at least one data source options, and the second initial bill data is derived from a set of bill sample data corresponding to the second data source option.

[0387] The display module 310 is further used to display second updated bill data in accordance with a second updated bill format on the second sub-template page in response to an editing operation on the second sub-template, wherein the second updated bill data is derived from the bill sample data.

[0388] In the embodiment of the present application, a bill file generation device is provided. With the above device, users can add multiple sub-templates to a template according to actual needs. Therefore, based on the configurability, various customization needs can be flexibly adapted and template customization can be completed quickly.

[0389] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application, the bill file generating device further includes a processing module 330;

[0390] The processing module 330 is used to update the header data and the footer data in the first sub-template if the data row in the first sub-template is updated;

[0391] The processing module 330 is further configured to update the footer data in the first sub-template if the header data in the first sub-template is updated.

[0392] In the embodiment of the present application, a bill file generation device is provided. With the above device, the bill customization platform can present the corresponding interface in real time in combination with the user's operation at the front end, achieving a customized effect of what you see is what you get. It can be seen that the present application has strong operability, and can flexibly and efficiently respond to the user's customization needs without repeated coding, improve billing efficiency and user experience, and enhance the operational capabilities of service providers.

[0393] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0394] The processing module 330 is further configured to establish and store an association relationship between the target object and at least one template, wherein the at least one template includes the target template;

[0395] The processing module 330 is further configured to establish and store an association relationship between the target template and at least one sub-template, wherein the at least one sub-template includes a first sub-template;

[0396] The processing module 330 is further used to establish and store an association relationship between the first sub-template, the first updated bill format, and the first target bill data.

[0397] In an embodiment of the present application, a bill file generation device is provided. Using the above device, the background establishes and stores the relationship between the template and various contents (e.g., sub-templates, rules, etc.), thereby enabling flexible configuration and rotation of the template. This satisfies the bill differentiation demands of different customers or the same customer for different products.

[0398] Optionally, in the above Fig.21 On the basis of the corresponding embodiment, in another embodiment of the bill file generating device 30 provided in the embodiment of the present application,

[0399] The generating module 320 is specifically configured to obtain the target template from the template database in response to a download operation on the target template;

[0400] In the embodiment of the present application, a bill file generation device is provided. With the above device, based on the user's interactive operation at the front end, the back end will execute corresponding instructions according to the user's operation, thereby achieving the effect of customized bill files. Thus, the feasibility and operability of the solution are improved.

[0401] The present application also provides a terminal, such as Fig. 22 For the sake of convenience, only the parts related to the embodiments of the present application are shown. For specific technical details not disclosed, please refer to the method part of the embodiments of the present application. In the embodiments of the present application, the terminal is taken as a computer for example:

[0402] Fig. 22 FIG. 1 is a block diagram showing a partial structure of a computer related to a terminal provided in an embodiment of the present application. Fig. 22 The computer includes components such as a radio frequency (RF) circuit 410, a memory 420, an input unit 430, a display unit 440, a sensor 450, an audio circuit 460, a wireless fidelity (WiFi) module 470, a processor 480, and a power supply 490. Those skilled in the art will appreciate that Fig. 22 The computer structure shown in the figure does not constitute a limitation of the computer, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0403] Combine the following Fig. 22A detailed introduction to the various components of a computer:

[0404] The RF circuit 410 can be used for receiving and sending signals during the process of sending and receiving information or making calls. In particular, after receiving the downlink information of the base station, it is sent to the processor 480 for processing; in addition, the designed uplink data is sent to the base station. Generally, the RF circuit 410 includes but is not limited to an antenna, at least one amplifier, a transceiver, a coupler, a low noise amplifier (LNA), a duplexer, etc. In addition, the RF circuit 410 can also communicate with the network and other devices through wireless communication. The above-mentioned wireless communication can use any communication standard or protocol, including but not limited to the global system of mobile communication (GSM), general packet radio service (GPRS), code division multiple access (CDMA), wideband code division multiple access (WCDMA), long term evolution (LTE), email, short messaging service (SMS), etc.

[0405] The memory 420 can be used to store software programs and modules. The processor 480 executes various functional applications and data processing of the computer by running the software programs and modules stored in the memory 420. The memory 420 can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the data storage area can store data created according to the use of the computer (such as audio data, a phone book, etc.), etc. In addition, the memory 420 can include a high-speed random access memory, and can also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0406] The input unit 430 can be used to receive input digital or character information, and to generate key signal input related to the user settings and function control of the computer. Specifically, the input unit 430 may include a touch panel 431 and other input devices 432. The touch panel 431, also known as a touch screen, can collect the user's touch operation on or near it (such as the user's operation on the touch panel 431 or near the touch panel 431 using any suitable object or accessory such as a finger, stylus, etc.), and drive the corresponding connection device according to a pre-set program. Optionally, the touch panel 431 may include two parts: a touch detection device and a touch controller. Among them, the touch detection device detects the user's touch orientation, detects the signal brought by the touch operation, and transmits the signal to the touch controller; the touch controller receives the touch information from the touch detection device, converts it into contact coordinates, and then sends it to the processor 480, and can receive and execute commands sent by the processor 480. In addition, the touch panel 431 can be implemented in various types such as resistive, capacitive, infrared, and surface acoustic waves. In addition to the touch panel 431, the input unit 430 may further include other input devices 432. Specifically, the other input devices 432 may include but are not limited to one or more of a physical keyboard, function keys (such as volume control keys, switch keys, etc.), a mouse, a joystick, etc.

[0407] The display unit 440 may be used to display information input by the user or information provided to the user and various menus of the computer. The display unit 440 may include a display panel 441. Optionally, the display panel 441 may be configured in the form of a liquid crystal display (LCD), an organic light-emitting diode (OLED), etc. Further, the touch panel 431 may cover the display panel 441. When the touch panel 431 detects a touch operation on or near it, it is transmitted to the processor 480 to determine the type of touch event. Subsequently, the processor 480 provides a corresponding visual output on the display panel 441 according to the type of touch event. Although in Fig. 22 In the embodiment, the touch panel 431 and the display panel 441 are used as two independent components to realize the input and output functions of the computer, but in some embodiments, the touch panel 431 and the display panel 441 can be integrated to realize the input and output functions of the computer.

[0408] The computer may also include at least one sensor 450, such as a light sensor, a motion sensor, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display panel 441 according to the brightness of the ambient light, and the proximity sensor may turn off the display panel 441 and / or the backlight when the computer is moved to the ear. As a type of motion sensor, the accelerometer sensor can detect the magnitude of acceleration in all directions (generally three axes), and can detect the magnitude and direction of gravity when stationary. It can be used for applications that identify computer postures (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometers, tapping), etc.; as for other sensors that can be configured on the computer, such as gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc., they will not be repeated here.

[0409] The audio circuit 460, the speaker 461, and the microphone 462 can provide an audio interface between the user and the computer. The audio circuit 460 can transmit the received audio data to the speaker 461 after converting the received audio data into an electrical signal, which is converted into a sound signal for output; on the other hand, the microphone 462 converts the collected sound signal into an electrical signal, which is received by the audio circuit 460 and converted into audio data, and then the audio data is output to the processor 480 for processing, and then sent to another computer through the RF circuit 410, or the audio data is output to the memory 420 for further processing.

[0410] WiFi is a short-range wireless transmission technology. The computer can help users send and receive emails, browse web pages, and access streaming media through the WiFi module 470. It provides users with wireless broadband Internet access. Fig. 22 A WiFi module 470 is shown, but it is understandable that it is not an essential component of the computer and can be omitted as needed without changing the essence of the invention.

[0411] The processor 480 is the control center of the computer. It uses various interfaces and lines to connect various parts of the entire computer. It executes various functions of the computer and processes data by running or executing software programs and / or modules stored in the memory 420 and calling data stored in the memory 420. Optionally, the processor 480 may include one or more processing units; optionally, the processor 480 may integrate an application processor and a modem processor, wherein the application processor mainly processes the operating system, user interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the above-mentioned modem processor may not be integrated into the processor 480.

[0412] The computer also includes a power supply 490 (such as a battery) for supplying power to various components. Optionally, the power supply can be logically connected to the processor 480 through a power management system, thereby implementing functions such as charging, discharging, and power consumption management through the power management system.

[0413] Although not shown, the computer may also include a camera, a Bluetooth module, etc., which will not be described in detail here.

[0414] The steps performed by the terminal in the above embodiment can be based on the Fig. 22 The terminal structure shown.

[0415] A computer device is also provided in an embodiment of the present application, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the steps of the methods described in the above embodiments are implemented.

[0416] A computer-readable storage medium is also provided in an embodiment of the present application, on which a computer program is stored. When the computer program is executed by a processor, the steps of the methods described in the above embodiments are implemented.

[0417] A computer program product is also provided in an embodiment of the present application, including a computer program, which, when executed by a processor, implements the steps of the methods described in the above embodiments.

[0418] It is understandable that in the specific implementation of this application, related data such as user information and billing data are involved. When the above embodiments of this application are applied to specific products or technologies, user permission or consent is required, and the collection, use and processing of relevant data need to comply with relevant laws, regulations and standards of relevant countries and regions.

[0419] 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.

[0420] In the several embodiments provided in the present application, it should be understood that the disclosed systems, 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 an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0421] 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.

[0422] 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. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0423] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a server or terminal 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: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk and other media that can store computer programs.

[0424] As described above, the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for generating a bill file, characterized in that: include: In response to a selection operation on a target template, a template creation page of a first sub-template is displayed, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is used to provide at least one data source option, each data source option corresponding to a set of bill sample data; In response to a selection operation of a first data source option on a template creation page for the first sub-template, displaying first initial bill data on the first sub-template page in a first initial bill format, wherein the first data source option is one of the at least one data source option, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option; In response to an editing operation on the first sub-template, displaying first updated bill data in a first updated bill format on the first sub-template page, wherein the first updated bill data is derived from bill sample data; In response to a download operation for the target template, a target bill file is generated, wherein the target bill file includes first target bill data presented in accordance with the first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

2. The generation method according to claim 1, characterized in that: The step of displaying a template creation page of the first sub-template in response to a selection operation on the target template includes: Displaying a template management page, wherein the template management page is used to provide template information and editing controls corresponding to each editable template in at least one editable template, wherein the template information includes at least one of a template identifier, an object identifier, a template name, a template creation time, creator information, template status information, and a template effective time; In response to a selection operation on an edit control corresponding to the target template, a template creation page of the first sub-template is displayed, wherein the target template belongs to one of the at least one editable template.

3. The generation method according to claim 2, characterized in that: The template management page is further used to provide a download control corresponding to each editable template in at least one editable template; The step of generating a target bill file in response to the download operation on the target template includes: In response to a selection operation on a download control corresponding to the target template, displaying a bill download page, wherein the bill download page is used to provide a start date control, an end date control, and a confirmation control; In response to an input operation on the start date control in the bill download page, displaying the bill start date; In response to an input operation on the end date control in the bill download page, displaying the bill end date; In response to a selection operation on the confirmation control, the target billing file is generated according to the billing start date and the billing end date, wherein the billing start date and the billing end date are used to determine actual billing data of the target object.

4. The generation method according to claim 1, characterized in that: In response to the selection operation of the first data source option on the template creation page for the first sub-template, displaying the first initial bill data in the first initial bill format on the first sub-template page includes: In response to a selection operation of the first data source option on the template creation page for the first sub-template, if the first data source option corresponds to a system data source, the first initial bill data is displayed on the first sub-template page in accordance with the first initial bill format.

5. The generation method according to claim 1, characterized in that: In response to the selection operation of the first data source option on the template creation page for the first sub-template, displaying the first initial bill data in the first initial bill format on the first sub-template page includes: In response to a selection operation of the first data source option on the template creation page for the first sub-template, if the first data source option corresponds to a custom data source, displaying a file list, wherein the file list is used to provide at least one selectable file; In response to a selection operation on a target file in the file list, uploading the target file, wherein the target file is one of the at least one selectable file; When the target file passes the review, the first initial billing data is displayed on the first sub-template page in accordance with the first initial billing format based on the target file, wherein the target file includes the first initial billing data corresponding to the first initial billing format.

6. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to the data source editing operation on the first sub-template, displaying a conditional filtering box on the template creation page of the first sub-template; In response to an input operation on the conditional filter box, a data row field value is obtained, wherein the data row field value is used to indicate T data rows in the first sub-template, and T is an integer greater than or equal to 1; The first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data rows remaining after the T data rows have been removed.

7. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to the aggregate editing operation on the first sub-template, displaying a field aggregation page, wherein the field aggregation page is used to provide field options corresponding to each data column in the first sub-template; In response to a selection operation on K field options in the field aggregation page, aggregation processing is performed on the same data in the K data columns, wherein the K field options have a one-to-one correspondence with the K data columns, and K is an integer greater than or equal to 1; The first update bill data is displayed on the first sub-template page in a first update bill format, wherein the first update bill format includes at least one data row after the aggregation processing.

8. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to the data column insert operation for the first sub-template, displaying a data column editing page, wherein the data column editing page is used to provide a column name input box and an expression input box; In response to an input operation on the column name input box in the data column editing page, a data column name is obtained, wherein the data column name is a column name of a newly added data column; If in response to an operation editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column satisfying a first expression, and the first expression is generated according to the operation editing operation; If in response to a column splicing editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column that satisfies a second expression, the second expression is generated according to the column splicing editing operation, and the second expression includes field names of at least two data columns in the first sub-template; In response to a cross-table association editing operation on the expression input box, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes a newly added data column that satisfies a third expression, and the third expression is generated based on the cross-table association editing operation.

9. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to a field editing operation on a target data column in the first sub-template, displaying a field replacement page, wherein the field replacement page is used to provide an original field input box and a replacement field input box; In response to an input operation on the original field input box in the field replacement page, obtaining an original value field value for the target data column; In response to an input operation on the replacement field input box in the field replacement page, obtaining a target field value for the target data column; In response to the completion of the editing operation on the target data column in the first sub-template, the first updated bill data is displayed on the first sub-template page according to the first updated bill format, wherein the first updated bill format includes the target data column after the field editing operation.

10. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to the same type of merging operation on the relevant field values ​​in the first sub-template, displaying the merged data rows on the first sub-template page; In response to the data row insert operation in the first sub-template, displaying a data row editing page, wherein the data row editing page is used to provide a sum control corresponding to the relevant data column in the first sub-template; In response to a selection operation on at least one summation control in the data row editing page, performing summation calculations on the data columns corresponding to each summation control in the at least one summation control; The first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes data rows and data columns after the same type of merging operation and the sum calculation.

11. The generation method according to claim 1, characterized in that: In response to the editing operation on the first sub-template, displaying the first updated bill data in a first updated bill format on the first sub-template page includes: In response to a font editing operation on a cell in the first sub-template, displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cell after the font editing operation; In response to a background color editing operation on a cell in the first sub-template, displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cell after the background color editing operation; If in response to a row height editing operation in the first sub-template, displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data row after the row height editing operation; In response to the column width editing operation in the first sub-template, displaying the first updated bill data on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the data column after the column width editing operation; In response to a merge edit operation on at least two cells in the first sub-template, the first updated bill data is displayed on the first sub-template page in accordance with the first updated bill format, wherein the first updated bill format includes the cells after the merge edit operation.

12. The generation method according to claim 1, characterized in that: The target bill file also includes page header data; The method further comprises: In response to a selection operation on a header display control, header data is displayed on the first sub-template page, wherein the header data includes at least one of the title of the first sub-template, the object identifier corresponding to the target template, the name corresponding to the object identifier, and billing cycle information.

13. The generation method according to claim 1, characterized in that: The target billing file also includes footer data; The method further comprises: In response to a selection operation on a footer display control, footer data is displayed on the first sub-template page, wherein the footer data includes at least one of the name of the service provider, the identification number of the service provider, the address of the service provider, the telephone number of the service provider, the account opening information of the service provider, the payment account number of the service provider, date information and the icon of the service provider.

14. The generation method according to claim 1, characterized in that: The target billing file further includes second target billing data presented in a second updated billing format, wherein the second target billing data is billing data obtained after replacing the second updated billing data with actual billing data of the target object; Before generating a target bill file in response to the download operation on the target template, the method further includes: In response to a selection operation on a newly added template control, displaying a template creation page of a second sub-template, wherein the second sub-template belongs to a sub-template of the target template, and the template creation page of the second sub-template is used to provide at least one data source option, each data source option corresponding to a set of bill sample data; In response to a selection operation of a second data source option on a template creation page for the second sub-template, second initial bill data is displayed on the second sub-template page in a second initial bill format, wherein the second data source option is one of the at least one data source option, and the second initial bill data is derived from a set of bill sample data corresponding to the second data source option. In response to an editing operation on the second sub-template, the second updated bill data is displayed on the second sub-template page in accordance with the second updated bill format, wherein the second updated bill data is derived from the bill sample data.

15. The generation method according to any one of claims 1 to 14, characterized in that: The method further comprises: If the data row in the first sub-template is updated, the header data and the footer data in the first sub-template are updated; If the header data in the first sub-template is updated, the footer data in the first sub-template is updated.

16. The generation method according to any one of claims 1 to 14, characterized in that: The method further comprises: Establishing and storing an association relationship between the target object and at least one template, wherein the at least one template includes the target template; Establishing and storing an association relationship between the target template and at least one sub-template, wherein the at least one sub-template includes the first sub-template; An association relationship between the first sub-template, the first updated bill format, and the first target bill data is established and stored.

17. The generation method according to any one of claims 1 to 14, characterized in that: The step of generating a target bill file in response to the download operation on the target template includes: In response to a download operation on the target template, acquiring the target template from a template database; The target template is rendered to obtain the target bill file.

18. A bill file generating device, characterized in that: include: A display module is configured to display a template creation page of a first sub-template in response to a selection operation on a target template, wherein the target template is a template created for a target object, the first sub-template is a sub-template in the target template, and the template creation page of the first sub-template is configured to provide at least one data source option, each data source option corresponding to a set of bill sample data; The display module is further configured to display first initial bill data in a first initial bill format on the first sub-template page in response to a selection operation of a first data source option on a template creation page for the first sub-template, wherein the first data source option is one of the at least one data source option, and the first initial bill data is derived from a set of bill sample data corresponding to the first data source option; The display module is further configured to display first updated bill data in a first updated bill format on the first sub-template page in response to an editing operation on the first sub-template, wherein the first updated bill data is derived from the bill sample data; A generation module is used to generate a target bill file in response to a download operation for the target template, wherein the target bill file includes first target bill data presented in accordance with the first updated bill format, and the first target bill data is bill data obtained after replacing the first updated bill data with actual billing data of the target object.

19. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the steps of the generation method according to any one of claims 1 to 17 are implemented.

20. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the generation method according to any one of claims 1 to 17 are implemented.

Images