Method, device and electronic equipment for generating a report file

Abstract

Embodiments of the present application disclose a method, device and electronic equipment for generating a report file. The method comprises: in response to a request for generating a travel report file of a target user in a target time period, obtaining basic data related to a travel itinerary generated by the target user in the target time period; obtaining data on a plurality of target fields by performing calculation and processing on the basic data; generating an electronic spreadsheet file according to the data on the plurality of target fields and a preset electronic spreadsheet file template; and returning the electronic spreadsheet file and a presentation file template, wherein the presentation file template is associated with reference logic information for referencing data in the electronic spreadsheet file. The efficiency of generating a report file can be improved by the embodiments of the present application.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to methods, apparatus and electronic devices for generating report documents. Background Technology

[0002] In systems that provide services related to the purchase / reservation of travel-related products (especially service systems primarily targeting corporate users), corporate employees can purchase airline tickets, book hotels, etc., in the name of the company. Correspondingly, the system can also summarize and statistically analyze travel-related expenses on a corporate basis and generate travel reports for delivery to corporate users, so that companies can know about their travel-related expenses over a period of time, and so on.

[0003] In existing technologies, when enterprise or individual users need to obtain such travel report files, especially when enterprise users may require presentation-format travel report files, they usually need to be manually created by the system's operations personnel. During the creation process, the operations personnel need to obtain specific enterprise-related travel data from multiple backends (e.g., underlying databases, or application-layer databases), then perform data aggregation and calculations, and finally input the data into a presentation template. The entire process is quite time-consuming. For example, statistics show that operations personnel typically spend 2 hours per enterprise per instance creating enterprise travel reports.

[0004] Therefore, how to generate corporate travel reports more efficiently has become a technical problem that needs to be solved by those skilled in the art. Summary of the Invention

[0005] This application provides a method, apparatus, and electronic device for generating report files, which can improve the efficiency of generating report files.

[0006] This application provides the following solution:

[0007] A method for generating a report file includes:

[0008] In response to a request to generate a travel report file for a target user within a target time period, basic data related to the travel itinerary generated by the target user within the target time period is obtained.

[0009] By processing the basic data, data from multiple target fields are obtained;

[0010] Generate a spreadsheet file based on the data in the multiple target fields and the preset spreadsheet file template;

[0011] The spreadsheet file and presentation file template are returned, wherein the presentation file template is associated with reference logic information that references data in the spreadsheet file, so as to generate a travel report file in presentation format by referencing the data in the spreadsheet file.

[0012] The step of acquiring basic data related to travel-related product consumption generated by the target user within the target time period includes:

[0013] Based on the data retrieval method information pre-configured for the target fields involved in the spreadsheet file template, determine the basic data information that needs to be retrieved from the relevant database, and retrieve the basic data based on this information;

[0014] The data acquisition method information also includes: calculation and processing method information for the basic data, so as to perform calculation and processing on the basic data.

[0015] The generated spreadsheet-type file includes:

[0016] A first spreadsheet file is generated by filling the data from the multiple target fields into a preset spreadsheet file template;

[0017] The step of returning the spreadsheet file and presentation file includes:

[0018] The first spreadsheet file, the preset second spreadsheet file template, and the presentation file template are returned to the target user. The second spreadsheet file template is associated with a first reference logic that references data in the first spreadsheet file so that the content in the second spreadsheet file template can be updated by referencing the data in the first spreadsheet file to generate a second spreadsheet file. The second spreadsheet file includes charts generated based on the data referenced from the first spreadsheet file.

[0019] The reference logic associated with the presentation file template is as follows: a second reference logic information that references the chart data in the second spreadsheet file, so as to generate a travel report file in presentation format by referencing the chart data in the second spreadsheet file.

[0020] In response to a request to open a second spreadsheet file template, a first update operation option is provided so that, upon receiving an update operation, data in the first spreadsheet file is referenced according to the first reference logic, and the chart data in the second spreadsheet file template is updated based on the data referenced from the first spreadsheet file.

[0021] In response to a request to open the presentation file template, a second update operation option is provided so that, upon receiving the update operation, the chart data in the second spreadsheet file is referenced according to the second reference logic, the content in the presentation file template is updated based on the chart data referenced from the second spreadsheet file, and a travel report file in the presentation format is generated.

[0022] The step of returning the spreadsheet file and the preset presentation file template includes:

[0023] The spreadsheet file and the preset presentation file template are returned as a compressed file package.

[0024] After generating the spreadsheet file, a link is provided for downloading the compressed file package, so that the spreadsheet file and the preset presentation file template can be downloaded through the link.

[0025] The response to the request to generate a travel report file for a target time period for a target user includes:

[0026] In response to a request initiated by an operator in the system to generate a travel report file for a target time period for the target user; the system includes a system that provides travel-related services.

[0027] The response to the request to generate a travel report file for a target time period for a target user includes:

[0028] In response to a request initiated by the target user to generate a travel report file for the target user within a target time period.

[0029] A method for generating a report file includes:

[0030] The target interface provides options for entering a user identifier and selecting a time period to initiate a request to generate a report file.

[0031] After receiving the request to generate the report file through the operation options, the request is submitted to the server so that the server can obtain basic data related to the travel itinerary generated by the target user within the target time period. By performing calculations on the basic data, data on multiple target fields is obtained. Based on the data on the multiple target fields and a preset spreadsheet file template, a spreadsheet file is generated. The spreadsheet file and a preset presentation file template are saved to the target network address. The presentation file template is associated with reference logic information that references the data in the spreadsheet file.

[0032] The system provides options for downloading the spreadsheet file and the presentation file template from the target network address, and generates a travel report file in presentation format by referencing data from the spreadsheet file in the presentation file template.

[0033] An apparatus for generating a report file, comprising:

[0034] The basic data acquisition unit is used to acquire basic data related to the travel itinerary generated by the target user during the target time period in response to a request to generate a travel report file for a target user within a target time period.

[0035] The target field data acquisition unit is used to acquire data from multiple target fields by performing calculations on the basic data.

[0036] The spreadsheet file generation unit is used to generate a spreadsheet file based on the data in the multiple target fields and a preset spreadsheet file template;

[0037] The file return unit is used to return the spreadsheet file and the presentation file template, wherein the presentation file template is associated with reference logic information that references data in the spreadsheet file, so as to generate a travel report file in presentation format by referencing the data in the spreadsheet file.

[0038] An apparatus for generating a report file, comprising:

[0039] The request initiation operation option providing unit is used to provide operation options in the target interface for initiating a request to generate a report file after entering a user identifier and selecting a time period;

[0040] The request submission unit is used to receive the request to generate the report file through the operation options, and then submit the request to the server so that the server can obtain the basic data related to the travel itinerary generated by the target user within the target time period, calculate and process the basic data to obtain data on multiple target fields, generate a spreadsheet file based on the data on the multiple target fields and a preset spreadsheet file template, and save the spreadsheet file and a preset presentation file template to a target network address. The presentation file template is associated with reference logic information that references the data in the spreadsheet file.

[0041] The download operation option providing unit is used to provide operation options for downloading the spreadsheet file and the presentation file template, so as to download the spreadsheet file and the presentation file template from the target network address, and generate a travel report file in presentation format by referencing data in the spreadsheet file in the presentation file template.

[0042] A computer-readable storage medium having a computer program stored thereon that, when executed by a processor, implements the steps of any of the preceding methods.

[0043] An electronic device, comprising:

[0044] One or more processors; and

[0045] A memory associated with the one or more processors, the memory being used to store program instructions that, when read and executed by the one or more processors, perform the steps of the method described in any of the preceding descriptions.

[0046] According to the specific embodiments provided in this application, the following technical effects are disclosed:

[0047] Through the embodiments of this application, a digital operation system for system operators or a data service system for target users can be provided to automatically generate travel report documents. When it is necessary to generate a travel report document for a target user within a target time period, the system can automatically obtain basic data related to travel product consumption generated by the target user within the target time period, and perform calculations on the basic data to obtain data on multiple target fields. Then, based on the data on the multiple target fields and a preset spreadsheet file template, a spreadsheet file can be generated, and the spreadsheet file and a presentation file template can be returned. The presentation file template is associated with reference logic information that references data in the spreadsheet file. In this way, a travel report document in presentation format can be generated by referencing data in the spreadsheet file. In this way, because data can be automatically read and processed, and the ability of the presentation file to reference data in the spreadsheet file can be used to automatically generate travel report documents, the manual data query, calculation, and entry processes of operation personnel can be avoided, thereby improving the efficiency of generating travel report documents.

[0048] Of course, any product implementing this application does not necessarily need to achieve all of the advantages described above at the same time. Attached Figure Description

[0049] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0050] Figure 1 This is a schematic diagram of the system architecture provided in the embodiments of this application;

[0051] Figure 2 This is a flowchart of the first method provided in the embodiments of this application;

[0052] Figure 3 This is a schematic diagram of an interface for initiating a request provided in an embodiment of this application;

[0053] Figure 4 This is a schematic diagram of the first spreadsheet file provided in the embodiments of this application;

[0054] Figure 5 This is a schematic diagram of the second spreadsheet file provided in the embodiments of this application;

[0055] Figure 6 This is a schematic diagram of the travel report document provided in an embodiment of this application;

[0056] Figure 7 This is a flowchart of the second method provided in the embodiments of this application;

[0057] Figure 8 This is a schematic diagram of the first device provided in the embodiments of this application;

[0058] Figure 9 This is a schematic diagram of the second device provided in the embodiments of this application;

[0059] Figure 10 This is a schematic diagram of the electronic device provided in the embodiments of this application. Detailed Implementation

[0060] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of this application are within the scope of protection of this application.

[0061] First, it should be noted that, in the process of developing this application, the inventors discovered that in existing technologies where operations personnel need to manually create PPT files, the required data is often scattered across multiple different backend databases. These might include underlying databases recording specific order data, or databases generated by application layers after processing the underlying databases. Operations personnel need to retrieve the required data from each of these databases, possibly through writing database query statements. Furthermore, after obtaining the data, some calculations may be required. For example, if the PPT requires data such as "month-on-month" or "year-on-year" comparisons for a specific customer, it might not only be necessary to retrieve data for the same customer within a specific target time period from the database, but also data from the previous month or year for the same time period, and then manually calculate the "month-on-month" and "year-on-year" comparisons using certain formulas before finally inputting it into the PPT template. This process is extremely time-consuming.

[0062] In this embodiment, considering the trend of digital operations, a solution for automatically generating travel report documents can be provided for operators based on existing digital operations systems. Specifically, considering that travel report documents are usually in the form of presentation files, which often require the insertion of charts (including bar charts, pie charts, line charts, etc.) to visualize consumption data, spreadsheet files are generally more suitable for the automatic generation of such charts. Furthermore, the same office software system usually provides data referencing capabilities between presentation files and spreadsheet files. Therefore, in this embodiment, spreadsheet file templates, presentation file templates, and data referencing logic between presentation files and spreadsheet files can be pre-configured in the digital operations system to support the automatic generation of documents. In a preferred embodiment, the spreadsheet file template can be divided into two parts. The first spreadsheet file specifies the target fields required and can also specify the method of obtaining data for these target fields. For example, it can specify which basic data needs to be obtained from the database first, and what calculations need to be performed based on this basic data, such as calculation formulas. This information can also be configured in the digital operations system. The second spreadsheet file is used to generate specific chart data based on the data in the target field. To this end, logic can be configured for the second spreadsheet file to reference data from the first spreadsheet. Additionally, logic can be configured for the presentation file to reference data from the second spreadsheet file.

[0063] Based on the above configuration, an entry point for automatically generating travel reports can be provided to operations personnel in the digital operations system. Through this entry point, operations personnel can input specific target user identifiers and the required target time period information. The system can then perform automated data processing. Specifically, firstly, basic data is retrieved from the relevant database according to the pre-configured data acquisition method for the target fields. Then, the basic data is processed according to the specific calculation method to obtain the data for the target fields. Next, the data is written into the corresponding data table according to the format and other information in the first spreadsheet file template, resulting in the first spreadsheet file. Afterwards, this first spreadsheet file, along with the aforementioned second spreadsheet file template and presentation file template, can be returned to the operations personnel. For example, in a specific implementation, these three files can be packaged together, and a download address for the compressed package can be provided for the operations personnel to download. After downloading the compressed package, since the second spreadsheet file template contains data reference logic for the first spreadsheet file, and the presentation file template contains data reference logic for the second spreadsheet file, the second spreadsheet file and the presentation file can be generated through this data reference logic.

[0064] As can be seen, through this embodiment, a digital operations system can automate data processing. As an operations staff member, you only need to input the identifier of the target user (specific enterprise customer, etc.) and the desired time period for the data. The system will automatically generate a file package for operations staff to download. After downloading, operations staff only need to open the presentation file in the file package and click the file update option provided in the file. The file will then be updated according to its associated data reference logic, that is, the data from the specific spreadsheet file will be referenced in the presentation file, thereby generating a specific presentation-type travel report file. Of course, if the aforementioned second spreadsheet file exists, it may also involve clicking the update option provided in the second spreadsheet file. In this case, the second spreadsheet file will also be updated according to the corresponding data reference logic. Therefore, in the entire implementation process, operations staff no longer need to manually retrieve basic data from the database, nor do they need to perform calculations and inputting this data into the presentation file; the travel report file can be automatically generated, thereby helping operations staff improve efficiency.

[0065] It should be noted that in practical applications, besides providing the aforementioned entry point for automatically generating travel report files to the system's operational staff, this entry point can also be directly opened to specific enterprise users, allowing them to generate and download travel report files independently. In other words, in this embodiment, the initiator of the request to generate a travel report file can be either the system's operational staff or the target user themselves. For the latter, a user-oriented data service system (such as a functional module within a product information service system) can be provided, through which users can initiate specific requests to generate travel reports. Furthermore, in this case, various optional presentation file templates and background themes can be provided to the target user to further meet their personalized needs.

[0066] From a system architecture perspective, as mentioned above, see [link to relevant documentation]. Figure 1This application embodiment can provide an automatic travel report generation function in a digital operation system associated with a commodity information service system (especially an information system that mainly provides travel-related commodity services such as air ticket purchase and hotel reservation for enterprise users). This function allows for the configuration of spreadsheet templates, data acquisition methods for target fields, presentation templates, and data referencing logic between files, etc. These configuration operations typically only need to be performed once and do not need to be reconfigured each time a specific travel report file is generated (unless the presentation template needs to be updated, in which case the configuration information can be modified in the system). Afterwards, operators can automatically generate travel report files based on this digital operation system. During the generation process, they only need to specify the target user identifier and the target time period information to obtain the file download link provided by the system. Following this link, they can download the file package, which includes spreadsheet files and presentation files. Of course, in practical implementation, since the presentation file is generated through data referencing logic of a spreadsheet file, users can also perform data link update operations on the presentation file. That is, when double-clicking to open the presentation file, an option to update the file can be provided through a pop-up window. After the user clicks update, the file can automatically retrieve the required data from the spreadsheet file and fill it into the corresponding position in the presentation template, thus completing the generation of the presentation file. Afterwards, operations personnel can also edit this presentation file, including changing the background theme, editing some text content, etc., and then provide it to the corresponding target users. Alternatively, in the case where the target user initiates the request to generate a travel report, the client interface of the specific enterprise or other target user can provide an operation option to specify a specific target time period and initiate a request to generate a travel report, allowing the target user to initiate the specific request to generate a travel report themselves. Afterwards, the specific processing method on the server side is similar to the processing method when the request is initiated by operations personnel. After generating the specific spreadsheet file, the spreadsheet file and the presentation file template are packaged and returned to the target user.

[0067] The specific implementation schemes provided in the embodiments of this application will be described in detail below.

[0068] Example 1

[0069] First, this application's first embodiment provides a method for generating report files from the perspective of the aforementioned digital operation system server. See [link to previous document]. Figure 2 The method may include:

[0070] S201: In response to a request to generate a travel report file for a target user within a target time period, obtain basic data related to the travel itinerary generated by the target user within the target time period.

[0071] After pre-configuring spreadsheet and presentation templates, operations personnel can generate travel reports for specific target users by entering the target user's identifier (specifically, operations personnel may have assigned user groups and can search for the target user's identifier) ​​into the relevant interface of the digital operations system. They can also select the desired target time period. The system will then recognize the need to generate a travel report for that specific time period for that target user. For example, the interface might look like this: Figure 3 As shown (where information about the target user is not shown). Alternatively, as mentioned above, specific target users such as enterprises can also initiate a specific request to generate travel report documents through their associated clients.

[0072] Upon receiving the aforementioned request, the system can first retrieve data from the database. Specifically, the data retrieval method information for the target fields required in the spreadsheet file can be pre-configured in the digital operations system. The specific target fields needed in the spreadsheet file can be determined based on the data required in the travel report file. For example, if the travel report needs to show "month-on-month" and "year-on-year" data on a user's travel expenses, then the target fields configured in the spreadsheet template could include "month-on-month" and "year-on-year". Furthermore, since the database may not directly contain the data for these fields, the data can be calculated based on some basic data in the database. Therefore, data retrieval method information can also be configured for the target fields. This database retrieval method information can include: what specific basic data is needed, and how to perform calculations on this basic data. Therefore, the system can retrieve the basic data from the relevant database based on this pre-configured data retrieval method information for each target field.

[0073] It's worth noting that in practice, the presentation templates can offer multiple background themes. When targeting operations personnel, the system can automatically match the background theme based on the target user's industry, etc., though operations personnel can also edit it later. When targeting enterprises or other users directly, the target user can select a specific presentation template when making a request, and the system can automatically generate the report using the selected template. Different templates can have different background themes, and the specific data referencing logic in the spreadsheet can also differ. In other words, the request to generate a travel report can include information such as the target user, target time period, and the identifier of the selected presentation template, etc.

[0074] S202: By performing calculations on the basic data, data from multiple target fields are obtained.

[0075] After retrieving basic data from the database, the system can also obtain specific data for the target field based on pre-configured data calculation and processing methods. That is, in this embodiment, the digital operation system can not only query basic data in the database but also perform data calculation and processing, all of which can be done on the database side. For example, if the target field is the "month-on-month change" of payment amount, the specific basic data includes: the monthly payment amount for the specific target user, and the specific calculation and processing method can be set according to the month-on-month change calculation formula, etc.

[0076] S203: Generate a spreadsheet file based on the data in the multiple target fields and the preset spreadsheet file template.

[0077] After calculating the data for the specific target field, the data can be entered into the designated data table according to the format set in the spreadsheet template, thus generating the spreadsheet file. The spreadsheet template can define one or more data tables, as well as the target fields included in those tables. Once the data for the target field is obtained, it can be entered into the specific data table according to this configuration information. For example, in a specific example, after entering data into a data table in the spreadsheet file, it can be done as follows: Figure 4 As shown (of course, the Figure 4 (Only some of the target fields and their corresponding data are shown in the image). In other words, the system can perform data acquisition and calculations on the target fields at the database level, and then automatically populate the data into the data table to generate a spreadsheet file.

[0078] Since travel reports typically require charts and graphs to visually compare and contrast various data points, in a preferred implementation, two spreadsheet files can be created. One of these can be as follows: Figure 4 The file shown is used to save the data on the acquired target fields (referred to as the first spreadsheet file). Another file (referred to as the second spreadsheet file) can be used to reference the data on the target fields in the first spreadsheet file to generate specific charts. For this purpose, a second spreadsheet file template can be pre-configured, along with data referencing logic for the first spreadsheet file. This data referencing logic can be stored within the second spreadsheet file template. Specifically, after retrieving data from multiple target fields from the database, the data from these fields can first be filled into the pre-configured spreadsheet file template to generate the first spreadsheet file. When the second spreadsheet file is opened, the data referencing logic can be executed automatically. Alternatively, an update option can be provided to operators, and the specific data referencing logic can be executed only after the operators click the update option, and so on.

[0079] S204: Return the spreadsheet file and presentation file template, wherein the presentation file template is associated with reference logic information that references data in the spreadsheet file, so as to generate a travel report file in presentation format by referencing the data in the spreadsheet file.

[0080] After obtaining the data from the target field and filling it into the spreadsheet template, the generated spreadsheet file and presentation template can be returned to the operations personnel or target users. If there are two spreadsheet templates, the aforementioned first spreadsheet file, second spreadsheet file template, and presentation template can be returned to the operations personnel or target users. Specifically, in one implementation, the above files can be combined into a file package, and a download link can be provided to the operations personnel or target users, who can download the file package to their local terminal. The second spreadsheet file template is associated with a first reference logic that references data from the first spreadsheet file. This allows the content in the second spreadsheet file template to be updated by referencing data from the first spreadsheet file, thereby generating the second spreadsheet file. This second spreadsheet file may include charts generated based on data referenced from the first spreadsheet file. Specifically, after downloading the aforementioned files to their local machines, operators or target users can open the second spreadsheet template within the file package. At this point, a first update operation option can be provided (e.g., via a pop-up window within the second spreadsheet file). Upon receiving the update operation from the operator or target user, the data in the first spreadsheet file can be referenced according to the first referencing logic, and the chart data in the second spreadsheet template can be updated based on the data referenced from the first spreadsheet file. For example, such as... Figure 5 As shown, the generated second spreadsheet file can generate multiple charts, and the data in the specific fields of the specific charts can be referenced from the first spreadsheet file.

[0081] Additionally, the file package includes a presentation file template. If the aforementioned second spreadsheet file exists, the reference logic associated with this presentation file template can be a second reference logic that references chart data in the second spreadsheet file. This allows a travel report file in presentation format to be generated by referencing the chart data in the second spreadsheet file. Specifically, when operations personnel or target users open the presentation file template in the file package, a second update operation option can be provided (this can also be provided via a pop-up window within the presentation file, etc.). Upon receiving an update operation from operations personnel or target users, the chart data in the second spreadsheet file can be referenced according to the aforementioned second reference logic, and the content of the presentation file can be updated based on the chart data referenced from the second spreadsheet file, thereby generating a travel report file in presentation format. For example, one page of the generated travel report file could be as follows: Figure 6As shown, when initiated by operations personnel, the personnel can save the travel report file separately by saving it as a different file, and then provide it to the target user for viewing. In other words, the file actually provided to the target user may only include the updated presentation-style travel report file, and does not necessarily need to include the actual spreadsheet file.

[0082] The specific travel report document can include a wide range of information, such as monthly expenses, month-on-month and year-on-year data, savings for the month, losses incurred, and potential for further cost savings. After receiving the report, the target user can use its contents to report to their superiors. Furthermore, they can improve their travel plans based on the recommendations in the report to further reduce travel costs.

[0083] In summary, through the embodiments of this application, a digital operation system for system operators or a data service system for target users can provide the ability to automatically generate travel report documents. When it is necessary to generate a travel report document for a target user within a target time period, the system can automatically obtain basic data related to travel product consumption generated by the target user within the target time period, and perform calculations on the basic data to obtain data on multiple target fields. Then, based on the data on the multiple target fields and a preset spreadsheet file template, a spreadsheet file can be generated, and the spreadsheet file and a presentation file template can be returned. The presentation file template is associated with reference logic information that references data in the spreadsheet file. In this way, a travel report document in presentation format can be generated by referencing data in the spreadsheet file. In this way, because data can be automatically read and processed, and the ability of the presentation file to reference data in the spreadsheet file can be used to automatically generate travel report documents, the manual data query, calculation, and entry processes of operation personnel can be avoided, thereby improving the efficiency of generating travel report documents.

[0084] Example 2

[0085] This second embodiment, corresponding to the first embodiment, provides a method for generating report files from the perspective of a digital operation system client (primarily in the form of web pages, etc.) for system operators or a client for enterprise users (primarily in the form of mobile applications, etc.). See [link to documentation]. Figure 7 The method may specifically include:

[0086] S701: The target interface provides operation options for entering a user identifier and selecting a time period to initiate a request to generate a report file;

[0087] S702: After receiving the request to generate the report file through the operation option, the request is submitted to the server so that the server can obtain basic data related to the travel itinerary generated by the target user within the target time period, calculate and process the basic data to obtain data on multiple target fields, generate a spreadsheet file based on the data on the multiple target fields and a preset spreadsheet file template, and save the spreadsheet file and the preset presentation file template to the target network address, wherein the presentation file template is associated with reference logic information that references the data in the spreadsheet file;

[0088] S703: Provides an operation option for downloading the spreadsheet file and the presentation file template, so as to download the spreadsheet file and the presentation file template from the target network address, and generate a travel report file in presentation format by referencing data in the spreadsheet file in the presentation file template.

[0089] For the parts of this embodiment that are not described in detail, please refer to the description in the aforementioned embodiment one and other parts of this specification, which will not be repeated here.

[0090] It should be noted that the embodiments of this application may involve the use of user data. In practical applications, user-specific personal data may be used in the scheme described herein within the scope permitted by applicable laws and regulations, provided that it complies with the applicable laws and regulations of the country (e.g., with the user's explicit consent, with the user being properly notified, etc.).

[0091] Corresponding to the aforementioned method embodiment one, this application embodiment also provides an apparatus for generating report files, see [link to example]. Figure 8 The device may include:

[0092] The basic data acquisition unit 801 is used to acquire basic data related to the travel itinerary generated by the target user during the target time period in response to a request to generate a travel report file for a target user within a target time period.

[0093] The target field data acquisition unit 802 is used to acquire data on multiple target fields by performing calculations on the basic data.

[0094] The spreadsheet file generation unit 803 is used to generate a spreadsheet file based on the data in the multiple target fields and a preset spreadsheet file template;

[0095] The file return unit 804 is used to return the spreadsheet file and the presentation file template, wherein the presentation file template is associated with reference logic information that references data in the spreadsheet file, so as to generate a travel report file in presentation format by referencing the data in the spreadsheet file.

[0096] Specifically, the basic data acquisition unit can be used for:

[0097] Based on the data retrieval method information pre-configured for the target fields involved in the spreadsheet file template, determine the basic data information that needs to be retrieved from the relevant database, and retrieve the basic data based on this information;

[0098] The data acquisition method information also includes: calculation and processing method information for the basic data, so as to perform calculation and processing on the basic data.

[0099] In specific implementation, the spreadsheet file generation unit can be used for:

[0100] A first spreadsheet file is generated by filling the data from the multiple target fields into a preset spreadsheet file template;

[0101] The file return unit can be specifically used to: return the first spreadsheet file, the preset second spreadsheet file template, and the presentation file template to the target user, wherein the second spreadsheet file template is associated with a first reference logic that references data in the first spreadsheet file, so as to update the content in the second spreadsheet file template by referencing the data in the first spreadsheet file, thereby generating a second spreadsheet file, and the second spreadsheet file includes charts generated based on the data referenced from the first spreadsheet file;

[0102] The reference logic associated with the presentation file template is as follows: a second reference logic information that references the chart data in the second spreadsheet file, so as to generate a travel report file in presentation format by referencing the chart data in the second spreadsheet file.

[0103] In a specific implementation, the device may further include:

[0104] The first update unit is configured to provide a first update operation option in response to a request to open a second spreadsheet file template, so that after receiving the update operation, it references the data in the first spreadsheet file according to the first reference logic, and updates the chart data in the second spreadsheet file template based on the data referenced from the first spreadsheet file.

[0105] The second update unit is configured to provide a second update operation option in response to a request to open the presentation file template, so that after receiving the update operation, it references the chart data in the second spreadsheet file according to the second reference logic, updates the content in the presentation file template based on the chart data referenced from the second spreadsheet file, and generates a travel report file in the presentation format.

[0106] Specifically, the file return unit can be used for:

[0107] The spreadsheet file and the presentation file template will be returned as a compressed file package.

[0108] Additionally, the device may also include:

[0109] The download link providing unit is configured to provide a link for downloading the compressed file package after the spreadsheet file is generated, so that the spreadsheet file and the preset presentation file template can be downloaded through the link.

[0110] In specific implementation, the basic data acquisition unit can be used for:

[0111] In response to a request initiated by an operator in the system to generate a travel report file for a target time period for the target user; the system includes a system that provides travel-related services.

[0112] Alternatively, the basic data acquisition unit can be specifically used for:

[0113] In response to a request initiated by the target user to generate a travel report file for the target user within a target time period.

[0114] Corresponding to Embodiment 2, this application also provides an apparatus for generating report files, see [link to embodiment]. Figure 9 The device may include:

[0115] The request initiation operation option providing unit 901 is used to provide operation options in the target interface for initiating a request to generate a report file after inputting a user identifier and selecting a time period;

[0116] The request submission unit 902 is used to receive the request to generate the report file through the operation options, and then submit the request to the server so that the server can obtain the basic data related to the travel itinerary generated by the target user within the target time period, calculate and process the basic data to obtain data on multiple target fields, generate a spreadsheet file based on the data on the multiple target fields and a preset spreadsheet file template, and save the spreadsheet file and a preset presentation file template to a target network address. The presentation file template is associated with reference logic information that references the data in the spreadsheet file.

[0117] The download operation option providing unit 903 is used to provide operation options for downloading the spreadsheet file and the presentation file template, so as to download the spreadsheet file and the presentation file template from the target network address, and generate a travel report file in presentation format by referencing data in the spreadsheet file in the presentation file template.

[0118] In addition, embodiments of this application also provide a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the steps of the method described in any of the foregoing method embodiments.

[0119] And an electronic device, comprising:

[0120] One or more processors; and

[0121] A memory associated with the one or more processors, the memory being used to store program instructions that, when read and executed by the one or more processors, perform the steps of the method described in any of the foregoing method embodiments.

[0122] in, Figure 10 An exemplary architecture of an electronic device is shown, which may include a processor 1010, a video display adapter 1011, a disk drive 1012, an input / output interface 1013, a network interface 1014, and a memory 1020. The processor 1010, video display adapter 1011, disk drive 1012, input / output interface 1013, network interface 1014, and memory 1020 can communicate with each other via a communication bus 1030.

[0123] The processor 1010 can be implemented using a general-purpose CPU (Central Processing Unit), microprocessor, application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solution provided in this application.

[0124] The memory 1020 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage device, dynamic storage device, etc. The memory 1020 can store the operating system 1021 for controlling the operation of the electronic device 1000, and the basic input / output system (BIOS) for controlling the low-level operations of the electronic device 1000. Additionally, it can store a web browser 1023, a data storage management system 1024, and a report file processing system 1025, etc. The aforementioned report file processing system 1025 can be the application program that specifically implements the aforementioned steps in this embodiment. In summary, when the technical solution provided in this application is implemented through software or firmware, the relevant program code is stored in the memory 1020 and is called and executed by the processor 1010.

[0125] Input / output interface 1013 is used to connect input / output modules to realize information input and output. Input / output modules can be configured as components in the device (not shown in the figure) or externally connected to the device to provide corresponding functions. Input devices may include keyboards, mice, touch screens, microphones, various sensors, etc., and output devices may include displays, speakers, vibrators, indicator lights, etc.

[0126] The network interface 1014 is used to connect the communication module (not shown in the figure) to enable communication and interaction between this device and other devices. The communication module can communicate via wired means (such as USB, Ethernet cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.).

[0127] Bus 1030 includes a pathway for transmitting information between various components of the device (e.g., processor 1010, video display adapter 1011, disk drive 1012, input / output interface 1013, network interface 1014, and memory 1020).

[0128] It should be noted that although the above-described device only shows the processor 1010, video display adapter 1011, disk drive 1012, input / output interface 1013, network interface 1014, memory 1020, bus 1030, etc., in specific implementations, the device may also include other components necessary for normal operation. Furthermore, those skilled in the art will understand that the above-described device may only include the components necessary for implementing the solution of this application, and does not necessarily include all the components shown in the figures.

[0129] As can be seen from the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented by means of software plus necessary general-purpose hardware platforms. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in various embodiments or some parts of the embodiments of this application.

[0130] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, for system or system embodiments, since they are basically similar to method embodiments, the description is relatively simple, and relevant parts can be referred to the descriptions in the method embodiments. The systems and system embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0131] The methods, apparatus, and electronic devices for generating report files provided in this application have been described in detail above. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the above embodiments are only for the purpose of helping to understand the methods and core ideas of this application. Furthermore, those skilled in the art will recognize that, based on the ideas of this application, there will be changes in the specific implementation methods and application scope. Therefore, the content of this specification should not be construed as a limitation of this application.

Claims

1. A method for generating a report file, characterized in that, include: In response to a request to generate a travel report file for a target user within a target time period, basic data related to the travel itinerary generated by the target user within the target time period is obtained. By processing the basic data, data from multiple target fields are obtained; A first spreadsheet file is generated by filling the data from the multiple target fields into a preset first spreadsheet file template; The first spreadsheet file, a preset second spreadsheet file template, and a presentation file template are returned to the target user. The second spreadsheet file template is associated with a first reference logic that references data from the first spreadsheet file, allowing the content of the second spreadsheet file template to be updated and a second spreadsheet file to be generated. The second spreadsheet file includes charts generated based on data referenced from the first spreadsheet file. The presentation file template is associated with reference logic information that references data from the second spreadsheet file, allowing the generation of a travel report file in presentation format. The reference logic associated with the presentation file template is a second reference logic that references chart data from the second spreadsheet file, allowing the generation of a travel report file in presentation format.

2. The method according to claim 1, characterized in that, The step of obtaining basic data related to travel itineraries generated by the target user within the target time period includes: determining the basic data information to be obtained from the relevant database based on the data acquisition method information pre-configured for the target fields involved in the first spreadsheet file template, and obtaining the basic data based on the basic data information; The data acquisition method information also includes: calculation and processing method information for the basic data, so as to perform calculation and processing on the basic data.

3. The method according to claim 1, characterized in that, In response to a request to open a second spreadsheet file template, a first update operation option is provided so that, upon receiving an update operation, data in the first spreadsheet file is referenced according to the first reference logic, and the chart data in the second spreadsheet file template is updated based on the data referenced from the first spreadsheet file.

4. The method according to claim 3, characterized in that, In response to a request to open the presentation file template, a second update operation option is provided so that, upon receiving the update operation, the chart data in the second spreadsheet file is referenced according to the second reference logic, the content in the presentation file template is updated based on the chart data referenced from the second spreadsheet file, and a travel report file in the presentation format is generated.

5. The method according to claim 1, characterized in that, Return the first spreadsheet file, the preset second spreadsheet file template, and the preset presentation file template, including: The first spreadsheet file, the preset second spreadsheet file template, and the preset presentation file template are returned as a compressed file package.

6. The method according to claim 5, characterized in that, After generating the first spreadsheet file, a link is provided for downloading the compressed file package, so that the first spreadsheet file, the preset second spreadsheet file template, and the preset presentation file template can be downloaded via the link.

7. The method according to any one of claims 1 to 6, characterized in that, The response to the request to generate a travel report file for a target time period for a target user includes: In response to a request initiated by an operator in the system to generate a travel report file for a target time period for the target user; the system includes a system that provides travel-related services.

8. The method according to any one of claims 1 to 6, characterized in that, The response to the request to generate a travel report file for a target time period for a target user includes: In response to a request initiated by the target user to generate a travel report file for the target user within a target time period.

9. A method for generating a report file, characterized in that, include: The target interface provides options for entering a user identifier and selecting a time period to initiate a request to generate a report file. After receiving the request to generate the report file through the operation options, the request is submitted to the server so that the server can obtain basic data related to the travel itinerary generated by the target user within the target time period. The server then processes the basic data to obtain data on multiple target fields. This data is then filled into a preset first spreadsheet template to generate a first spreadsheet file. The first spreadsheet file, a preset second spreadsheet template, and a preset presentation template are saved to a target network address. The second spreadsheet template is associated with a first reference logic that references data from the first spreadsheet file, allowing the content of the second spreadsheet template to be updated and a second spreadsheet file to be generated. The second spreadsheet file includes charts generated based on data referenced from the first spreadsheet file. The presentation template is associated with reference logic information that references data from the second spreadsheet file. The reference logic associated with the presentation template is a second reference logic that references chart data from the second spreadsheet file, allowing the generation of a travel report file in presentation format. The system provides operation options for downloading the first spreadsheet file, the preset second spreadsheet file template, and the presentation file template, so as to download the first spreadsheet file, the preset second spreadsheet file template, and the presentation file template from the target network address, and generate a travel report file in presentation format by referencing data from the second spreadsheet file in the presentation file template.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When executed by a processor, the program implements the steps of the method described in any one of claims 1 to 9.

11. An electronic device, characterized in that, include: One or more processors; as well as A memory associated with the one or more processors, the memory being used to store program instructions that, when read and executed by the one or more processors, perform the steps of the method according to any one of claims 1 to 9.

Images