CN115828869A - Report exporting method based on dynamic field configuration and related device - Google Patents
Report exporting method based on dynamic field configuration and related device Download PDFInfo
- Publication number
- CN115828869A CN115828869A CN202211422585.7A CN202211422585A CN115828869A CN 115828869 A CN115828869 A CN 115828869A CN 202211422585 A CN202211422585 A CN 202211422585A CN 115828869 A CN115828869 A CN 115828869A
- Authority
- CN
- China
- Prior art keywords
- target
- field
- data
- export
- report
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a report exporting method and a related device based on dynamic field configuration, which are applied to an information management server in an information management system, wherein the information management system comprises an information management server for managing information data corresponding to a target enterprise and user equipment associated with a target enterprise account of the target enterprise; the method comprises the following steps: receiving configuration information from the user equipment, the configuration information being used for indicating a target field to be derived; generating a dynamic field configuration table according to the configuration information; responding to an export instruction from user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export style of a target field in a target report; receiving a determination instruction from user equipment; and exporting the target report consistent with the style of the export style table in response to the determination instruction. Therefore, the preview interface is displayed to the user before exporting, so that the user can determine the export result, the revising after exporting is avoided, and the efficiency of exporting the report is improved.
Description
Technical Field
The application belongs to the technical field of internet general data processing, and particularly relates to a report exporting method and a related device based on dynamic field configuration.
Background
Currently, in a Software as a Service (SaaS) system, there is no template reference before export, there is only one export button, and a client can see exported excel data only after waiting for export for a long time. However, since the demands of each client are different, the excel l data to be exported are also different, and if the excel l data is found to be incorrect after export, the excel l data needs to be modified again in the SaaS system and then exported, so that the data export efficiency is reduced.
Disclosure of Invention
The embodiment of the application provides a report exporting method and a related device based on dynamic field configuration, so that the efficiency of report exporting is improved.
In a first aspect, an embodiment of the present application provides a report exporting method based on dynamic field configuration, which is applied to an information management server in an information management system, where the information management system includes the information management server for managing information data corresponding to a target enterprise and a user device associated with a target enterprise account of the target enterprise; the method comprises the following steps:
receiving configuration information from the user equipment, wherein the configuration information is used for indicating a target field to be derived;
generating a dynamic field configuration table according to the configuration information, wherein the dynamic field configuration table comprises a plurality of first fields and export settings for the first fields, the export settings are used for indicating whether each first field in the first fields needs to be exported, and the first fields comprise the target field;
responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction;
receiving a determination instruction from user equipment;
and responding to the determination instruction, and exporting the target report.
In a second aspect, an embodiment of the present application provides a report exporting apparatus based on dynamic field configuration, which is applied to an information management server in an information management system, where the information management system includes the information management server for managing information data corresponding to a target enterprise and a user device associated with a target enterprise account of the target enterprise; the device comprises:
a receiving unit, configured to receive configuration information from the user equipment, where the configuration information is used to indicate a target field to be derived;
a first generating unit, configured to generate a dynamic field configuration table according to the configuration information, where the dynamic field configuration table includes a plurality of first fields and export settings for the plurality of first fields, where the export settings are used to indicate whether each of the plurality of first fields needs to be exported, and the plurality of first fields includes the target field;
a second generating unit, configured to respond to an export instruction from the user equipment, and generate a preview interface according to the dynamic field configuration table, where the preview interface is used to display an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction;
a second receiving unit, configured to receive a determination instruction from the user equipment;
and the derivation unit is used for responding to the determination instruction and deriving the target report.
In a third aspect, an embodiment of the present application provides an electronic device, including a processor, a memory, a communication interface, and one or more programs, stored in the memory and configured to be executed by the processor, the programs including instructions for performing the steps of any of the first to second aspects of the embodiments of the present application.
In a fourth aspect, an embodiment of the present application provides a computer storage medium storing a computer program for electronic data exchange, where the computer program makes a computer perform some or all of the steps described in any of the first aspect to the second aspect of the present embodiment.
In a fifth aspect, the present application provides a computer program product, where the computer program product includes a non-transitory computer-readable storage medium storing a computer program, where the computer program is operable to cause a computer to perform some or all of the steps as described in any of the first to second aspects of the embodiments of the present application. The computer program product may be a software installation package.
It can be seen that, in the embodiment of the present application, first, configuration information from the user equipment is received; generating a dynamic field configuration table according to the configuration information; responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction; receiving a determination instruction from user equipment; and responding to the determination instruction, and exporting the target report. Therefore, the preview interface is displayed to the user before exporting, so that the user can determine the export result, the revising after exporting is avoided, and the efficiency of exporting the report is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1a is a schematic structural diagram of an information management system according to an embodiment of the present application;
fig. 1b is a schematic structural diagram of an electronic device according to an embodiment of the present application;
FIG. 2 is a flowchart illustrating a report exporting method based on dynamic field configuration according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a report exporting apparatus based on dynamic field configuration according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the description and claims of the present application and in the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, system, article, or apparatus.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
The following description will first be made with respect to terms related to the present application.
SaaS is short for Software as a Service, and is a completely innovative Software application mode beginning to rise in the 21 st century with the development of Internet technology and the maturity of application Software. It has a similar meaning as "on-demand software", the app identity service provider (ASP), hosted software. The method is a mode for providing software through the Internet, a manufacturer uniformly deploys application software on a server of the manufacturer, a client can order required application software services from the manufacturer through the Internet according to actual requirements of the client, the client pays a fee to the manufacturer according to the amount and time of the ordered services, and obtains the services provided by the manufacturer through the Internet. SaaS is the best approach to adopt advanced technology for many small businesses, eliminating the need for businesses to purchase, build, and maintain infrastructure and applications.
Currently, in a Software as a Service (SaaS) system, there is no template reference before export, there is only one export button, and a client can see exported excel data only after waiting for export for a long time. However, since the demands of each client are different, the excel l data to be exported are also different, and if the excel l data is found to be incorrect after export, the excel l data needs to be modified again in the SaaS system and then exported, so that the data export efficiency is reduced.
In order to solve the above problem, an embodiment of the present application provides a report exporting method based on dynamic field configuration. The method can be applied to the scene of exporting the report form in the server. May be determined by receiving configuration information from the user equipment; generating a dynamic field configuration table according to the configuration information; then responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table; and when a determination instruction from the user equipment is received, responding to the determination instruction, and exporting the target report consistent with the style of the export style table. Therefore, the preview interface is displayed to the user before exporting, so that the user can determine the export result, the revising after exporting is avoided, and the efficiency of exporting the report is improved. The present solution may be applicable to a variety of scenarios, including but not limited to the application scenarios mentioned above.
The system architecture according to the embodiments of the present application is described below.
Fig. 1a is a schematic structural diagram of an information management system 100 according to an embodiment of the present disclosure, where the information management system 100 includes the information management server 110 for managing information data corresponding to a target enterprise and a user device 120 associated with a target enterprise account of the target enterprise. A database 111 is disposed in the information management server 110, and a plurality of fields and data corresponding to the fields are stored in the database 111.
The information management server 110 provides data processing services for different enterprises, and after an enterprise purchases the data processing server, at least one enterprise account is registered in the information management server 110. The device on which the enterprise account is logged is the user device 120.
Fig. 1b is a schematic structural diagram of an electronic device 10 provided in the embodiment of the present application, as shown in fig. 1b, which includes at least one processor (processor) 11; a display screen 12; and a memory (memory) 13, and may further include a communication interface (Commun medicine I interface) 15 and a bus 14. The processor 11, the display 12, the memory 13 and the communication interface 15 can communicate with each other through the bus 14. The display 12 is configured to display a user guidance interface preset in an initial setting mode. The communication interface 15 may transmit information. The processor 11 may call logic instructions in the memory 13 to perform the method in the above-described embodiment.
Optionally, the electronic device 10 may be a mobile electronic device, or may be an electronic device or other devices, which is not limited herein.
In addition, the logic instructions in the memory 13 may be implemented in the form of software functional units and stored in a computer readable storage medium when the logic instructions are sold or used as independent products.
The memory 13, which is a computer-readable storage medium, may be configured to store a software program, a computer-executable program, such as program instructions or modules corresponding to the methods in the embodiments of the present disclosure. The processor 11 executes the functional application and data processing, i.e. implements the method in the above-described embodiments, by running a software program, instructions or modules stored in the memory 13.
The memory 13 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created from use of the electronic device 10, and the like. Further, the memory 13 may include a high-speed random access memory, and may also include a nonvolatile memory. For example, a variety of media that can store program codes, such as a usb disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, may also be transient storage media.
The specific method is described in detail below.
Referring to fig. 2, fig. 2 is a schematic flowchart illustrating a report exporting method based on dynamic field configuration according to an embodiment of the present application, where the method can be applied to the information management server described above. The method comprises the following steps:
In a specific implementation, a user corresponding to the target enterprise logs in the target enterprise account on the user equipment, enters a webpage/interface maintained by the information management server, and edits or uploads the configuration information in the webpage/interface.
Illustratively, the derived settings include at least one of: field name, database field name, sort priority, whether filtering queries are supported, type of field, and control of field.
In a specific implementation, when receiving the configuration information, the information management server performs export setting on a corresponding field according to the configuration information, and further generates the dynamic configuration table.
In a possible embodiment, the generating a preview interface according to the dynamic field configuration table includes:
determining the target field from the dynamic field configuration table;
querying the target data corresponding to the target field from a database;
and obtaining the preview interface according to the target data.
The data types at least comprise a cascade type and an enumeration type, and the cascade type comprises a first cascade type and a second cascade type; the querying the target data corresponding to the target field from the database includes: if the data type corresponding to the target field is a first cascade type, inquiring a cascade relation table according to the target field to obtain first associated data associated with the target field; if the data type corresponding to the target field is a second cascade type, inquiring an administrative division table according to the target field to obtain second associated data associated with the target field; and if the data type corresponding to the target field is an enumeration type, querying an enumeration type value taking table according to the numerical value to obtain a target text corresponding to the target field.
Specifically, the obtaining the preview interface according to the target data includes: generating an initial interface; and importing the target field and the first associated data/the second associated data/the target text into the initial interface in the export style to obtain the preview interface.
In a possible embodiment, after the export pre-processing of the target data according to the data type, the method further includes: setting the target field as a header; generating preset field content corresponding to the target field; and displaying the target field and the content of the preset field in the preset interface.
For example, a derived identifier may be set for a target field to be derived in the dynamic configuration table to mark that the target field needs to be derived, and the derived identifier may be in any form, such as a tick mark or a highlight mark, which is not limited herein.
Illustratively, the field description table is used for storing configuration information of the field specifically, as mentioned above: field name, whether displayed, type of field, whether export is supported, hint content, and the like.
For example, the enumeration type value taking table is used for storing texts corresponding to some fields, for example, some fields appear in the form of numerical values, the numerical values correspond to specific meanings, and the enumeration type value taking table stores the association relationship between the numerical values and the meanings.
For example, some fields have a hierarchical relationship, for example, the hierarchical relationship among provinces, cities, towns and villages in an administrative region, in a screening query, provinces need to be selected to select a corresponding city, and so on, for example, a commodity, from a large brand to a sub-brand, and so on.
For example, the administrative division table is used for recording the latest administrative division data of the country, for example, some attributes are related to the region, and the query derivation needs to be performed by relying on the region data of the table.
In a specific implementation, when the export instruction is received, traversing the dynamic field configuration table, and determining the target field (which may be one or more fields) to be exported from the dynamic field configuration table; and then judging the data type of the target data corresponding to the target field, and acquiring the target data from different storage tables according to the data type after determining the data type of the target data.
Specifically, the data type includes, but is not limited to, a cascade type and an enumeration type, a data type identifier of the target field is obtained, and the data type of the target data is determined according to the data type identifier. If the data type is determined to be a first cascade type, such as 'rose', inquiring the cascade relation table to obtain that the cascade relation corresponding to the rose is 'plant-flower-rose', inquiring the cascade relation corresponding to the 'rose' from the cascade relation table, and obtaining corresponding first correlation data from the database according to the cascade relation.
Further, if it is determined that the data type is a second cascade type, for example, "XX province/YY city," an administrative division relationship corresponding to "YY city" is queried from the administrative division table, and second associated data corresponding to "YY city" is queried from the database according to the administrative division relationship.
Furthermore, if it is determined that the data type is an enumeration type, for example, the target field is gender, and the data 1 or 0 recorded in the main table, but the derived data of the excell is not 1 or 0, but needs to be converted into text data of which 1 is male and 0 is female, so that the relation of 1: male and 0: female is bound through the enumeration type table; and when the target field needs to be exported, acquiring a target text of corresponding data from the enumeration type value-taking table.
And finally, generating an initial interface, using the target field as a header of a report, using the inquired target data as preset field content of the target field, and filling the target field as the preset field content into the initial interface according to the export style to finally obtain the preview interface.
It can be seen that, in this embodiment, the target data is queried based on the data type of the target data corresponding to the target field, so as to improve the query efficiency.
In one possible embodiment, the target data includes form style data and field content, the form style including at least one or more of highlighting, illustration, cell consolidation, and window freezing; obtaining the preview interface according to the target data, including: generating an initial interface according to the form style data; inquiring the dynamic field configuration table to obtain the incidence relation between the target field and the form style data; and filling the target field into the cell corresponding to the initial interface according to the incidence relation.
In a specific implementation, the user may set form style data in the configuration information, and the generated dynamic field configuration table includes an association relationship between the form style data and the target field. And generating the initial interface with patterns such as highlighting, illustration, cell merging, window freezing and the like according to the form pattern data, inquiring the association relation from the dynamic field configuration table, and filling the target field and the target data corresponding to the target field into the cell corresponding to the initial interface according to the association relation so as to obtain the preview interface.
For example, the user sets the configuration information in an edit page of the user equipment, and configures the form style by checking a corresponding option in the edit page, thereby obtaining corresponding form style data. Optionally, the editing page may further be provided with a style setting control, after the user clicks the control, the user jumps to the report form queried in the information management server, and then sets a form style for the corresponding cell, and after the setting is completed, associates the target field and/or the target data in the cell corresponding to the form style, thereby generating corresponding form style data.
Specifically, if the form style data is not configured by the user, the preview interface is generated according to the form style when the target field is stored.
It can be seen that, in this embodiment, by configuring the form style and generating the preview interface according to the form style, the excell form data consistent with the final export effect can be displayed in the preview interface, so that the user can confirm whether a data error exists before export, the need of revising and exporting again after export is avoided, and the export efficiency is improved.
In a specific implementation, when the user determines that the data in the preview interface is accurate, the determining instruction is sent to the information management server through a control in the user equipment, and the information management server receives the determining instruction.
And step 205, responding to the determination instruction, and exporting the target report.
In a specific implementation, after receiving the determination instruction, the information management server responds to the determination instruction and derives the target report according to the form of the preview interface.
It can be seen that, in this embodiment, first, configuration information from the user equipment is received; generating a dynamic field configuration table according to the configuration information; responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction; receiving a determination instruction from user equipment; and responding to the determination instruction, and exporting the target report. Therefore, the preview interface is displayed to the user before exporting, so that the user can determine the export result, the revising after exporting is avoided, and the efficiency of exporting the report is improved.
In one possible embodiment, the method further comprises: receiving configuration change information from the user equipment; and updating the dynamic field configuration table according to the configuration change information, and outputting the updated first preview interface.
In a specific implementation, when the user determines that the data in the preview interface needs to be changed, configuration change information may be input in the user equipment, and then the configuration change information is sent to the information management server to modify the data that needs to be changed. After receiving the configuration change information, the information management server updates the dynamic field configuration table according to the configuration change information, and then generates a new first preview interface according to the dynamic field configuration table. And the user checks whether the first preview interface is accurate or not, and if not, the first preview interface can be modified continuously according to the method until the required target excel l data is obtained.
In the embodiment, whether the data error exists can be determined according to the preview interface before the target report is exported, the data error can be directly modified when the data error needs to be modified, the required accurate data can be determined before the data error is exported, the data can be prevented from being modified after the data error is exported, and the export efficiency of the excel data is improved.
The above description has introduced the solution of the embodiment of the present application mainly from the perspective of the method-side implementation process. It will be appreciated that the mobile electronic device, in order to carry out the above-described functions, comprises corresponding hardware structures and/or software modules for performing the respective functions. Those of skill in the art will readily appreciate that the present application is capable of hardware or a combination of hardware and computer software implementing the various illustrative elements and algorithm steps described in connection with the embodiments provided herein. Whether a function is performed in hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiment of the present application, the electronic device may be divided into the functional units according to the method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. It should be noted that the division of the unit in the embodiment of the present application is schematic, and is only a logic function division, and there may be another division manner in actual implementation.
Referring to fig. 3, fig. 3 is a schematic structural diagram of a report exporting apparatus 30 based on dynamic field configuration according to an embodiment of the present application, and is applied to an information management server in an information management system, where the information management system includes the information management server for managing information data corresponding to a target enterprise and a user device associated with a target enterprise account of the target enterprise; the device comprises:
a receiving unit 31, configured to receive configuration information from the user equipment, where the configuration information is used to indicate a target field to be derived;
a first generating unit 32, configured to generate a dynamic field configuration table according to the configuration information, where the dynamic field configuration table includes a plurality of first fields and export settings for the plurality of first fields, the export settings being used to indicate whether each of the plurality of first fields needs to be exported, and the plurality of first fields include the target field;
a second generating unit 33, configured to respond to an export instruction from the user equipment, and generate a preview interface according to the dynamic field configuration table, where the preview interface is used to display an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction;
a receiving unit 31, configured to receive a determination instruction from a user equipment;
and the derivation unit 34 is configured to respond to the determination instruction to derive the target report.
It can be seen that, in the embodiment of the present application, first, configuration information from the user equipment is received; generating a dynamic field configuration table according to the configuration information; responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction; receiving a determination instruction from user equipment; and responding to the determination instruction, and exporting the target report. Therefore, the preview interface is displayed to the user before exporting, so that the user can determine the export result, the revising after exporting is avoided, and the efficiency of exporting the report is improved.
In a possible embodiment, in the aspect of generating a preview interface according to the dynamic field configuration table, the second generating unit 33 is specifically configured to: determining the target field from the dynamic field configuration table; querying the target data corresponding to the target field from a database; and obtaining the preview interface according to the target data.
In one possible embodiment, the data types include at least a concatenation type and an enumeration type, and the concatenation type includes a first concatenation type and a second concatenation type; in the aspect of querying the target data corresponding to the target field from the database, the second generating unit 33 is specifically configured to: if the data type corresponding to the target field is a first cascade type, inquiring a cascade relation table according to the target field to obtain first associated data associated with the target field; if the data type corresponding to the target field is a second cascade type, inquiring an administrative division table according to the target field to obtain second associated data associated with the target field; and if the data type corresponding to the target field is an enumeration type, querying an enumeration type value taking table according to the numerical value to obtain a target text corresponding to the target field.
In a possible embodiment, in terms of obtaining the preview interface according to the target data, the second generating unit 33 is specifically configured to: generating an initial interface; and importing the target field and the first associated data/the second associated data/the target text into the initial interface in the export style to obtain the preview interface.
In a possible embodiment, in order to import the target field and the first associated data/the second associated data/the target text into the initial interface in the export style, and obtain an aspect of the preview interface, the second generating unit 33 is specifically configured to: setting the target field as a header; generating preset field content corresponding to the target field; and displaying the target field and the preset field content in the preset interface.
In one possible embodiment, the apparatus comprises: the receiving unit 31 is further configured to receive configuration change information from the user equipment; the first generating unit 32 is further configured to update the dynamic field configuration table according to the configuration change information; the second generating unit 33 is configured to output the updated first preview interface.
In one possible embodiment, the target data includes form style data and field content, the form style including at least one or more of highlighting, illustration, cell consolidation, and window freezing; obtaining the preview interface according to the target data, where the second generating unit 33 is specifically configured to: generating an initial interface according to the form style data; inquiring the dynamic field configuration table to obtain the incidence relation between the target field and the form style data; and filling the target field into the cell corresponding to the initial interface according to the incidence relation.
The above embodiments may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, the above-described embodiments may be implemented in whole or in part in the form of a computer program product. The computer program product comprises one or more computer instructions or computer programs. The procedures or functions according to the embodiments of the present application are wholly or partially generated when the computer instructions or the computer program are loaded or executed on a computer. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another computer readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by wire or wirelessly. The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains one or more collections of available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium. The semiconductor medium may be a solid state disk.
Embodiments of the present application also provide a computer storage medium, where the computer storage medium stores a computer program for electronic data exchange, the computer program enabling a computer to execute part or all of the steps of any one of the methods described in the above method embodiments, and the computer includes an electronic device.
Embodiments of the present application also provide a computer program product comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any of the methods as described in the above method embodiments. The computer program product may be a software installation package, the computer comprising an electronic device.
It should be understood that, in the various embodiments of the present application, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
In the several embodiments provided in the present application, it should be understood that the disclosed method, apparatus and system may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative; for example, the division of the unit is only a logic function division, and there may be another division manner in actual implementation; for example, various elements or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may be physically included alone, or two or more units may be integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer-readable storage medium. The software functional unit is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute some steps of the methods according to the embodiments of the present invention. And the aforementioned storage medium includes: u disk, removable hard disk, magnetic disk, optical disk, volatile memory or non-volatile memory. The non-volatile memory may be a read-on-ly memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory. Volatile memory can be Random Access Memory (RAM), which acts as external cache memory. By way of example, but not limitation, many forms of Random Access Memory (RAM) are available, such as Static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), synchronous Dynamic Random Access Memory (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), and dri RAM (DR RAM). And the like, which may store program code.
Although the present invention is disclosed above, the present invention is not limited thereto. Various changes and modifications can be easily made by those skilled in the art without departing from the spirit and scope of the present invention, and it is within the scope of the present invention to include different functions, combination of implementation steps, software and hardware implementations.
Claims (10)
1. A report exporting method based on dynamic field configuration is characterized in that the report exporting method is applied to an information management server in an information management system, wherein the information management system comprises the information management server for managing information data corresponding to a target enterprise and user equipment associated with a target enterprise account of the target enterprise; the method comprises the following steps:
receiving configuration information from the user equipment, wherein the configuration information is used for indicating a target field to be derived;
generating a dynamic field configuration table according to the configuration information, wherein the dynamic field configuration table comprises a plurality of first fields and export settings for the first fields, the export settings are used for indicating whether each first field in the first fields needs to be exported, and the first fields comprise the target field;
responding to an export instruction from the user equipment, and generating a preview interface according to the dynamic field configuration table, wherein the preview interface is used for displaying an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction;
receiving a determination instruction from user equipment;
and responding to the determination instruction, and exporting the target report.
2. The method of claim 1, wherein generating a preview interface according to the dynamic field configuration table comprises:
determining the target field from the dynamic field configuration table;
querying the target data corresponding to the target field from a database;
and obtaining the preview interface according to the target data.
3. The method of claim 2, wherein the data types include at least a concatenation type and an enumeration type, the concatenation type including a first concatenation type and a second concatenation type; the querying the target data corresponding to the target field from the database includes:
if the data type corresponding to the target field is a first cascade type, inquiring a cascade relation table according to the target field to obtain first associated data associated with the target field;
if the data type corresponding to the target field is a second cascade type, inquiring an administrative division table according to the target field to obtain second associated data associated with the target field;
and if the data type corresponding to the target field is an enumeration type, querying an enumeration type value taking table according to the numerical value to obtain a target text corresponding to the target field.
4. The method of claim 2, wherein said deriving the preview interface based on the target data comprises:
generating an initial interface;
and importing the target field and the first associated data/the second associated data/the target text into the initial interface in the export style to obtain the preview interface.
5. The method of claim 4, wherein importing the target field and the first associated data/the second associated data/target text into the initial interface in the export style to obtain the preview interface comprises:
setting the target field as a header;
generating preset field content corresponding to the target field;
and displaying the target field and the preset field content in the preset interface.
6. The method of claim 1, further comprising:
receiving configuration change information from the user equipment;
and updating the dynamic field configuration table according to the configuration change information, and outputting the updated first preview interface.
7. The method of claim 2, wherein the target data includes form style data and field content, the form style including at least one or more of highlighting, illustration, cell consolidation, and window freezing; obtaining the preview interface according to the target data, including:
generating an initial interface according to the form style data;
inquiring the dynamic field configuration table to obtain the incidence relation between the target field and the form style data;
and filling the target field into the cell corresponding to the initial interface according to the incidence relation.
8. A report exporting device based on dynamic field configuration is characterized in that the report exporting device is applied to an information management server in an information management system, wherein the information management system comprises the information management server for managing information data corresponding to a target enterprise and user equipment associated with a target enterprise account of the target enterprise; the device comprises:
a receiving unit, configured to receive configuration information from the user equipment, where the configuration information is used to indicate a target field to be derived;
a first generating unit, configured to generate a dynamic field configuration table according to the configuration information, where the dynamic field configuration table includes a plurality of first fields and export settings for the plurality of first fields, the export settings being used to indicate whether each of the plurality of first fields needs to be exported, and the plurality of first fields include the target field;
a second generating unit, configured to respond to an export instruction from the user equipment, and generate a preview interface according to the dynamic field configuration table, where the preview interface is used to display an export pattern of the target field in a target report, the export pattern is consistent with a target table pattern of the target report, and the target report is a report to be exported by the export instruction;
a second receiving unit, configured to receive a determination instruction from the user equipment;
and the derivation unit is used for responding to the determination instruction and deriving the target report.
9. An electronic device comprising a processor, a memory, a communication interface, and one or more programs stored in the memory and configured to be executed by the processor, the programs comprising instructions for performing the steps in the method of any of claims 1-7.
10. A computer-readable storage medium, characterized by storing a computer program for electronic data exchange, wherein the computer program causes a computer to execute instructions of the steps in the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211422585.7A CN115828869A (en) | 2022-11-15 | 2022-11-15 | Report exporting method based on dynamic field configuration and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211422585.7A CN115828869A (en) | 2022-11-15 | 2022-11-15 | Report exporting method based on dynamic field configuration and related device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115828869A true CN115828869A (en) | 2023-03-21 |
Family
ID=85528044
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211422585.7A Pending CN115828869A (en) | 2022-11-15 | 2022-11-15 | Report exporting method based on dynamic field configuration and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115828869A (en) |
-
2022
- 2022-11-15 CN CN202211422585.7A patent/CN115828869A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109087054B (en) | Collaborative office data stream processing method, device, computer equipment and storage medium | |
| CN109325729A (en) | A kind of method and server generating electronic contract | |
| CN111984902A (en) | Visual page configuration method, system, computer equipment and storage medium | |
| CN109062925A (en) | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence | |
| CN111738737B (en) | Method, device and equipment for generating digital property right certificate | |
| CN104133772A (en) | Automatic test data generation method | |
| CN102637184A (en) | Method and system for customizing webpages | |
| CN109189379A (en) | code generating method and device | |
| CN109542433A (en) | Product page face generates method, apparatus, computer equipment and storage medium | |
| CN108897728B (en) | Short message splicing processing method and device, computer equipment and storage medium | |
| CN111158687B (en) | Interface generation method and device of JAVA plugin, computer equipment and storage medium | |
| CN110795140A (en) | Configuration file generation method and device | |
| CN107515866B (en) | Data operation method, device and system | |
| CN110806866A (en) | Generation method and device of front-end management system | |
| CN111198772A (en) | Method and system for generating application program interface API | |
| US9934291B2 (en) | Dynamic presentation of a results set by a form-based software application | |
| CN111309991A (en) | Query statement generation method and device and data query method and system | |
| CN115828869A (en) | Report exporting method based on dynamic field configuration and related device | |
| CN109614188A (en) | A kind of page online help method, apparatus, computer equipment and storage medium | |
| CN114138813A (en) | Attribute configuration method and related device | |
| CN115357970A (en) | Linkage modeling method between BIM (building information modeling) software, terminal equipment and storage medium | |
| CN104156209A (en) | Cross-platform application interface modeling method and device | |
| CN114327376A (en) | IT architecture establishing method, IT architecture establishing device, processor and electronic equipment | |
| CN108256957A (en) | Vehicle source search result based on user's history behavior shows method and device | |
| CN112181407B (en) | Service realization processing method, device, system, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |