Report processing method and device, equipment, medium and product

Abstract

The invention discloses a report processing method, device and equipment, a medium and a product, relates to the technical field of data processing, and can be applied to the field of financial science and technology. The method comprises the following steps: in response to a triggering operation on a report processing packaging file, displaying a report interaction interface; obtaining a to-be-processed report uploaded by a user; and performing data processing on the to-be-processed report based on the data processing logic in the report processing packaging file to obtain a target report. Through the technical scheme, the report processing efficiency can be improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology and can be applied to the field of financial technology, and in particular to a report processing method, device, equipment, medium and product. Background Art

[0002] Currently, reports are processed directly from the database or using computer programming languages. The data source of reports processed by the database is fixed and inconvenient to transmit. Some computer programming languages ​​are not friendly to some type conversions, and the report processing speed is relatively slow. The display effect of the exported table is not very neat and beautiful. Some computer programming languages ​​have data processing packages that can also process reports, but the usage method is only for compilation, which is not friendly to business personnel who do not understand code writing, and the processing efficiency is also relatively slow. Summary of the invention

[0003] The present invention provides a report processing method, device, equipment, medium and product to improve the report processing efficiency.

[0004] According to one aspect of the present invention, a report processing method is provided, the method comprising:

[0005] In response to a trigger operation on a report processing package file, a report interaction interface is displayed;

[0006] Get the pending reports uploaded by the user;

[0007] The report to be processed is processed based on the data processing logic in the report processing package file to obtain a target report.

[0008] According to another aspect of the present invention, a report processing device is provided, the device comprising:

[0009] A report interaction interface display module, used to display a report interaction interface in response to a trigger operation on a report processing package file;

[0010] The pending report acquisition module is used to obtain the pending reports uploaded by users;

[0011] The to-be-processed report processing module is used to perform data processing on the to-be-processed report based on the data processing logic in the report processing encapsulation file to obtain a target report.

[0012] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0013] at least one processor; and

[0014] a memory communicatively connected to the at least one processor; wherein,

[0015] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the report processing method described in any embodiment of the present invention.

[0016] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the report processing method described in any embodiment of the present invention when executed.

[0017] According to another aspect of the present invention, a computer program product is provided. The computer program product includes a computer program. When the computer program is executed by a processor, the report processing method according to any embodiment of the present invention is implemented.

[0018] The technical solution of the embodiment of the present invention displays a report interaction interface in response to a trigger operation on a report processing package file; obtains a report to be processed uploaded by a user; and processes the report to be processed based on the data processing logic in the report processing package file to obtain a target report. The above technical solution can improve the processing efficiency of reports.

[0019] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0021] Figure 1 is a flow chart of a report processing method provided according to an embodiment of the present invention;

[0022] Figure 2 is a flow chart of a report processing method provided according to an embodiment of the present invention;

[0023] Figure 3 is a structural schematic diagram of a report processing device provided according to an embodiment of the present invention;

[0024] Figure 4 It is a schematic diagram of the structure of an electronic device for implementing the report processing method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0025] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0026] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention 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 interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0027] In addition, it should be noted that in the technical solution of the present invention, the collection, storage, use, processing, transmission, provision and disclosure of relevant data such as pending reports are in compliance with the provisions of relevant laws and regulations and do not violate public order and good morals.

[0028] Figure 1 1 is a flow chart of a report processing method according to an embodiment of the present invention. This embodiment is applicable to the case of how to process reports, especially to the case of processing a large number of reports in financial scenarios. The method can be executed by a report processing device, which can be implemented in the form of hardware and / or software. The device can be configured in an electronic device that carries the report processing function, such as a mobile terminal or a PC. Figure 1 As shown, the method includes:

[0029] S110 . In response to a triggering operation on a report processing package file, a report interaction interface is displayed.

[0030] In this embodiment, the report processing encapsulation file refers to a file that encapsulates the code of the data processing logic, such as an .exe file; it should be noted that the report processing encapsulation file encapsulates the program code corresponding to the data processing logic and the operating environment of the program code, and can be provided to non-code writers for use, which expands the scope of use and facilitates the work of personnel to process related table logic. The report interaction interface refers to an interface for interacting with business personnel on reports. The trigger operation can be a click operation.

[0031] Specifically, when business personnel need to process a report, they can click on the report processing package file, respond to the trigger operation on the report processing package file, open the report processing package file, and display the report interaction interface, which has a report upload button, a report download button, etc.

[0032] S120: Obtain the pending report uploaded by the user.

[0033] Among them, pending reports refer to reports that need data processing.

[0034] Specifically, the user uploads the report to be processed by clicking the report upload button. Correspondingly, the system on the mobile terminal or PC obtains the report to be processed uploaded by the user.

[0035] S130 , performing data processing on the report to be processed based on the data processing logic in the report processing encapsulation file to obtain a target report.

[0036] The target report refers to the report obtained after processing.

[0037] Specifically, data processing can be performed on the reports to be processed in sequence based on the data processing logic in the report processing encapsulation file, such as reading data in the reports to be processed, determining and processing abnormal data, converting data of the same type, and the like.

[0038] Furthermore, after obtaining the target report, the target report can be displayed in the report interaction interface; and in response to the download operation of the target report, the target report can be exported. Specifically, the target report is displayed in the report interaction interface for the user to preview, and then the target report can be exported in response to the user's download operation of the target report.

[0039] The technical solution of the embodiment of the present invention displays a report interaction interface in response to a trigger operation on a report processing package file; obtains a report to be processed uploaded by a user; and processes the report to be processed based on the data processing logic in the report processing package file to obtain a target report. The above technical solution can improve the processing efficiency of reports.

[0040] Figure 2 This is a flow chart of a report processing method provided according to an embodiment of the present invention. Based on the above embodiment, this embodiment further optimizes "processing the report to be processed based on the data processing logic in the report processing encapsulation file to obtain the target report" and provides an optional implementation scheme.

[0041] like Figure 2 As shown, the method includes:

[0042] S210: In response to a triggering operation on a report processing package file, display a report interaction interface.

[0043] S220: Obtain the pending report uploaded by the user.

[0044] S230: Based on the data reading logic in the report processing encapsulation file, data of the report to be processed is read to obtain data to be processed.

[0045] The data to be processed refers to the data read from the report to be processed.

[0046] One optional method is to pre-read the report to be processed to obtain the initial data; and re-read the initial data according to the reading method corresponding to the report field type to obtain the data to be processed. Specifically, the report to be processed can be pre-read, that is, all the data in the report to be processed can be read to obtain the initial data; then, according to the reading method corresponding to the report field type, for example, the field columns that do not need to be calculated are read as string type, and the field columns of numeric type are read as numeric type to obtain the data to be processed. This can improve the data foundation for subsequent data processing.

[0047] S240 , based on the data processing logic in the report processing encapsulation file, data processing is performed on the data to be processed in units of lines to obtain processed data.

[0048] Specifically, based on the data processing logic in the report processing package file, including the judgment and processing of abnormal data, the conversion of data of the same type, etc., the data to be processed is processed in units of lines to obtain the processed data. This can improve the data processing efficiency.

[0049] S250, beautify the processed data to obtain a target report.

[0050] An optional method is to beautify the processed data based on the beautification template to obtain the target report.

[0051] Another optional method is to classify and count the processed data and export them to obtain an initial table file; set the cell format and style of the initial table file to obtain a candidate table file; adjust the data alignment in the candidate table file based on the Excel template to obtain the target report.

[0052] Specifically, the processed data is classified and counted, such as summing up the amount, classifying the data, counting the number of items, etc., and then exported to obtain the initial table file. After that, the cell format and style of the initial table file are set, such as retaining decimals, filling colors, etc., to obtain a candidate table file. However, there are still some problems in the candidate table file, such as data being too long, thousandths being displayed, or being centered. Therefore, the data alignment in the candidate table file is adjusted based on the Excel template to obtain the target report and improve the beautification presentation effect.

[0053] The technical solution of the embodiment of the present invention displays a report interaction interface in response to a trigger operation on a report processing package file; obtains a report to be processed uploaded by a user; reads data from the report to be processed based on the data reading logic in the report processing package file to obtain the data to be processed; processes the data to be processed in units of lines based on the data processing logic in the report processing package file to obtain processed data; and beautifies the processed data to obtain a target report. The above technical solution can improve the efficiency of table data processing and provide a more beautified report.

[0054] Figure 3 is a structural diagram of a report processing device provided according to an embodiment of the present invention. This embodiment can be applied to the situation of how to process reports, especially to the situation of processing a large number of reports in financial scenarios. The device can be implemented in the form of hardware and / or software, and the device can be configured in an electronic device that carries the report processing function, such as a mobile terminal or a PC. Figure 3 As shown, the device comprises:

[0055] A report interaction interface display module 310, for displaying a report interaction interface in response to a trigger operation on a report processing package file;

[0056] The pending report acquisition module 320 is used to acquire the pending report uploaded by the user;

[0057] The pending report processing module 330 is used to perform data processing on the pending report based on the data processing logic in the report processing encapsulation file to obtain a target report.

[0058] The technical solution of the embodiment of the present invention displays a report interaction interface in response to a trigger operation on a report processing package file; obtains a report to be processed uploaded by a user; and processes the report to be processed based on the data processing logic in the report processing package file to obtain a target report. The above technical solution can improve the processing efficiency of reports.

[0059] Optionally, the pending report processing module 330 includes:

[0060] A data reading unit is used to read data of the report to be processed based on the data reading logic in the report processing encapsulation file to obtain the data to be processed;

[0061] A data processing unit is used to process the data to be processed in units of lines based on the data processing logic in the report processing encapsulation file to obtain processed data;

[0062] The data beautification unit is used to beautify the processed data to obtain the target report.

[0063] Optionally, the data reading unit is specifically used for:

[0064] Pre-read the report to be processed to obtain the initial data;

[0065] According to the reading method corresponding to the report field type, the initial data is re-read to obtain the data to be processed.

[0066] Optionally, the data beautification unit is specifically used for:

[0067] Classify and count the processed data and export them to obtain the initial table file;

[0068] Performing cell formatting and style setting on the initial table file to obtain a candidate table file;

[0069] Adjust the data alignment in the candidate table file based on the Excel template to obtain the target report.

[0070] Optionally, the report processing encapsulation file encapsulates program codes corresponding to the data processing logic and a running environment of the program codes.

[0071] Optionally, the device further includes a report post-processing module, which is used to:

[0072] Display the target report in the report interaction interface;

[0073] In response to the download operation on the target report, the target report is exported.

[0074] The report processing device provided in the embodiment of the present invention can execute the report processing method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0075] According to an embodiment of the present invention, the present invention also provides an electronic device, a readable storage medium and a computer program product.

[0076] Figure 4 It is a schematic diagram of the structure of an electronic device for implementing the report processing method according to an embodiment of the present invention. Figure 4A schematic diagram of the structure of an electronic device 10 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0077] like Figure 4 As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0078] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0079] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as a report processing method.

[0080] In some embodiments, the report processing method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the report processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to execute the report processing method in any other appropriate manner (e.g., by means of firmware).

[0081] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0082] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0083] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0084] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0085] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0086] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0087] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0088] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A report processing method, characterized in that: include: In response to a trigger operation on a report processing package file, a report interaction interface is displayed; Get the pending reports uploaded by the user; The report to be processed is processed based on the data processing logic in the report processing package file to obtain a target report.

2. The method according to claim 1, characterized in that The report to be processed is processed based on the data processing logic in the report processing encapsulation file to obtain a target report, including: Based on the data reading logic in the report processing encapsulation file, data of the report to be processed is read to obtain data to be processed; Based on the data processing logic in the report processing encapsulation file, the data to be processed is processed in units of lines to obtain processed data; The processed data is beautified to obtain the target report.

3. The method according to claim 2, characterized in that Based on the data reading logic in the report processing encapsulation file, the report to be processed is read to obtain the data to be processed, including: Pre-reading the report to be processed to obtain initial data; According to the reading mode corresponding to the report field type, the initial data is re-read to obtain the data to be processed.

4. The method according to claim 2, characterized in that: The processed data is beautified to obtain the target report, including: Classifying and counting the processed data and exporting them to obtain an initial table file; Performing unit formatting and style setting on the initial table file to obtain a candidate table file; The data alignment in the candidate table file is adjusted based on the Excel template to obtain the target report.

5. The method according to any one of claims 1 to 4, characterized in that The report processing encapsulation file encapsulates program codes corresponding to data processing logic and a running environment of the program codes.

6. The method according to any one of claims 1 to 4, characterized in that Also includes: Displaying the target report in the report interaction interface; In response to the download operation on the target report, the target report is exported.

7. A report processing device, characterized in that: include: A report interaction interface display module, used to display a report interaction interface in response to a trigger operation on a report processing package file; The pending report acquisition module is used to obtain the pending reports uploaded by users; The to-be-processed report processing module is used to perform data processing on the to-be-processed report based on the data processing logic in the report processing encapsulation file to obtain a target report.

8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the report processing method according to any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the report processing method according to any one of claims 1 to 6 when executed.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the computer program implements the report processing method according to any one of claims 1 to 6.

Images