Page data form output method, device and equipment and storage medium thereof

Abstract

The embodiment of the invention belongs to the technical field of research and development design, is applied to a front-end interface data form output scene, and relates to a page data form output method, device and equipment and a storage medium thereof. Data is prevented from being repeatedly called from a background database, and the resource calling pressure of the database is reduced; the method comprises the following steps: carrying out first processing on business data content, preliminarily generating a cache file in a target format, then carrying out more standardized second processing on the preliminarily generated cache file in the target format by utilizing a data form plug-in, and carrying out form output on the cache file after the second processing. And the problem of resource consumption during conversion to a complex file format is reduced. When the page data form output method is applied to an online medical health service scene, data calling resource consumption and complex file format conversion resource consumption can be avoided, and the service list generation efficiency is improved.

Description

Technical Field

[0001] The present application relates to the field of R&D and design technology, and is applied to the front-end interface data form output scenario, and in particular to a page data form output method, device, equipment and storage medium thereof. Background Art

[0002] The internet boasts a vast user base. To enhance service convenience and leverage its advantages, more and more industries are developing online services. For example, traditional medical services are gradually shifting towards online services, including online appointment booking, online family doctor consultations, and online drug purchases.

[0003] In the actual development of online medical services, the actual medical business scenarios involved are becoming more and more complex, which leads to certain difficulties in generating service documents for online services. First, it is difficult to integrate these online service documents in a unified way when generating online service documents. They can only be generated separately according to actual business conditions; secondly, when generating online service documents, the server-side files are often generated through the back-end server and then transmitted to the front-end for download. If the server resources are tight or the data volume is large, the server pressure is significantly increased, and it is heavily dependent on the processing of the back-end server, which increases the resource consumption of data call and complex file format conversion, resulting in low efficiency in business order generation. Summary of the Invention

[0004] The purpose of the embodiments of the present application is to propose a page data form output method, device, equipment and storage medium thereof, so as to solve the problem that the existing online service document generation is heavily dependent on the back-end server, which increases the resource consumption of data call and complex file format conversion, resulting in low efficiency in business document generation.

[0005] In order to solve the above technical problems, the embodiment of the present application provides a method for outputting page data in a form, which adopts the following technical solutions:

[0006] A method for outputting page data in a form, comprising the following steps:

[0007] Extract business data content from the target page;

[0008] Performing a first processing on the business data content to generate a data cache file in a target format;

[0009] Importing the data cache file into the data form plug-in;

[0010] Based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in, performing a second processing on the business data content in the data cache file to obtain a second processing result;

[0011] Output the target data form generated by the data form plug-in according to the second processing result.

[0012] Furthermore, the step of extracting the business data content in the target page specifically includes:

[0013] Introducing a preset front-end data extraction plug-in into the target page, wherein the preset front-end data extraction plug-in includes: a front-end data extraction plug-in based on optical OCR text recognition technology, a front-end data extraction plug-in based on web crawler technology, and a front-end data extraction plug-in based on Sheet.JS technology;

[0014] Start the front-end data extraction plug-in to extract the business data content.

[0015] Furthermore, the step of performing a first processing on the business data content to generate a data cache file in a target format specifically includes:

[0016] Pre-classify all data in the business data content according to a preset classification dictionary;

[0017] Based on the pre-classification processing result, all data in the business data content are processed into N×M preliminary forms, where N represents the number of classification categories and M represents the number of classification data corresponding to the largest classification category in the pre-classification processing result;

[0018] Generate a cache file in xlsx format based on the N×M preliminary form processing results.

[0019] Furthermore, after executing the step of pre-classifying all data in the business data content according to a preset classification dictionary, the method further includes:

[0020] Count the number of classification data corresponding to each classification category;

[0021] If the amount of classified data corresponding to the current classification category is greater than a set first quantity threshold, performing secondary classification processing on the classified data corresponding to the current classification category;

[0022] If the amount of classification data corresponding to the current classification category is less than the set second amount threshold, the classification data corresponding to the current classification category is used as merged data and merged into other classification categories;

[0023] The classification is completed until the quantity of classified data corresponding to all classification categories is between a first quantity threshold and a second quantity threshold, wherein the first quantity threshold is greater than the second quantity threshold.

[0024] Furthermore, before executing the step of importing the data cache file into the data form plug-in, the method further includes:

[0025] Obtain a pre-created first configuration function, wherein the first configuration function is used to configure row and column attribute information in a form, and the configuration items of the first configuration function include the number of rows, the number of columns, the row height, and the column width;

[0026] Obtain a pre-created second configuration function, wherein the second configuration function is used to configure cell attribute information in the form, and the configuration items of the second configuration function include cell data type, cell alignment, cell font style, cell fill style, and cell border style;

[0027] The first configuration function and the second configuration function are encapsulated to obtain the data form plug-in.

[0028] Furthermore, the step of performing a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result specifically includes:

[0029] Identify the row and column attribute configuration information and the cell attribute configuration information obtained by the data form plug-in according to the preset parameter interface;

[0030] Configure the row and column attribute information and the cell attribute information in the data cache file of the target format according to the row and column attribute configuration information and the cell attribute configuration information;

[0031] Obtain the configuration result corresponding to the data cache file.

[0032] Furthermore, the step of outputting the target data form generated by the data form plug-in according to the second processing result specifically includes:

[0033] Identify the preset output interface;

[0034] Setting the output interface to the plug-in output interface of the data form plug-in;

[0035] According to the configuration result corresponding to the data cache file, the data cache file is processed into a form to obtain a workbook format file to be output;

[0036] The workbook format file is output through the plug-in output interface of the data form plug-in to obtain the target data form.

[0037] In order to solve the above technical problems, the embodiment of the present application also provides a device for outputting page data in a form, which adopts the following technical solution:

[0038] A device for outputting page data in a form, comprising:

[0039] Data extraction module, used to extract business data content from the target page;

[0040] A first processing module, configured to perform a first processing on the business data content to generate a data cache file in a target format;

[0041] An import plug-in module, used to import the data cache file into the data form plug-in;

[0042] A second processing module is configured to perform a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result;

[0043] The form output module is used to output the target data form generated by the data form plug-in according to the second processing result.

[0044] In order to solve the above technical problems, the embodiment of the present application further provides a computer device, which adopts the following technical solution:

[0045] A computer device includes a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of the above-mentioned page data form output method when executing the computer-readable instructions.

[0046] In order to solve the above technical problems, the embodiment of the present application further provides a computer-readable storage medium, which adopts the following technical solution:

[0047] A computer-readable storage medium stores computer-readable instructions, which, when executed by a processor, implement the steps of the above-mentioned method for outputting page data in a form.

[0048] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0049] The page data form output method described in the embodiment of the present application is as follows: extracting the business data content in the target page; performing a first processing on the business data content to generate a data cache file in the target format; importing the data cache file into a data form plug-in; performing a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and outputting the target data form generated by the data form plug-in according to the second processing result. This avoids repeatedly retrieving data from the background database and reduces the resource call pressure of the database; performing a first processing on the business data content to preliminarily generate a cache file in the target format, and then performing a more standardized second processing on the preliminarily generated cache file in the target format using the data form plug-in, and outputting the cache file after the second processing in a form, thereby reducing the resource consumption problem when converting to a complex file format. Applying the page data form output method to online medical and health scenarios can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] In order to more clearly illustrate the solutions in this application, a brief introduction will be given below to the drawings required for use in the description of the embodiments of this application. Obviously, the drawings described below are some embodiments of this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0051] Figure 1 is an exemplary system architecture diagram to which the present application may be applied;

[0052] Figure 2 is a flow chart of an embodiment of a method for outputting page data in a form according to the present application;

[0053] Figure 3 yes Figure 2 A flowchart of a specific embodiment of step 202 is shown;

[0054] Figure 4 This is a flowchart of a specific embodiment of controlling the number of classification categories in the page data form output method described in this application;

[0055] Figure 5 This is a flowchart of a specific embodiment of constructing a data form plug-in in the page data form output method described in this application;

[0056] Figure 6 yes Figure 2 A flowchart of a specific embodiment of step 204 is shown;

[0057] Figure 7 yes Figure 2 A flowchart of a specific embodiment of step 205 is shown;

[0058] Figure 8 1 is a schematic structural diagram of an embodiment of a device for outputting page data in a form according to the present application;

[0059] Figure 9 It is a structural diagram of an embodiment of a computer device according to the present application. DETAILED DESCRIPTION

[0060] Unless otherwise defined, all technical and scientific terms used herein have the same meanings as commonly understood by those skilled in the art to which this application belongs. The terms used in the specification of the application are for the purpose of describing specific embodiments only and are not intended to limit this application. The terms "including" and "having" and any variations thereof in the specification and claims of this application and the above-mentioned drawings are intended to cover non-exclusive inclusions. The terms "first", "second", etc. in the specification and claims of this application or the above-mentioned drawings are used to distinguish different objects, not to describe a specific order.

[0061] References herein to "embodiments" mean that a particular feature, structure, or characteristic described in connection with the embodiments may be included in at least one embodiment of the present application. The appearance of this phrase in various places in the specification does not necessarily refer to the same embodiment, nor does it constitute an independent or alternative embodiment that is mutually exclusive of other embodiments. It is understood, both explicitly and implicitly, by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0062] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings.

[0063] like Figure 1 As shown, system architecture 100 may include a terminal device 101, a network 102, and a server 103. Terminal device 101 may be a laptop computer 1011, a tablet computer 1012, or a mobile phone 1013. Network 102 is a medium for providing a communication link between terminal device 101 and server 103. Network 102 may include various connection types, such as wired or wireless communication links or fiber optic cables.

[0064] The user can use the terminal device 101 to interact with the server 103 via the network 102 to receive or send messages, etc. Various communication client applications can be installed on the terminal device 101, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0065] The terminal device 101 can be various electronic devices with a display screen and supporting web browsing. In addition to the laptop computer 1011, tablet computer 1012 or mobile phone 1013, the terminal device 101 can also be an e-book reader, an MP3 player (Moving Picture Experts Group Audio Layer III), an MP4 (Moving Picture Experts Group Audio Layer IV) player, a laptop computer and a desktop computer, etc.

[0066] The server 103 may be a server that provides various services, such as a background server that provides support for web pages displayed on the terminal device 101 .

[0067] It should be noted that the page data form output method provided in the embodiment of the present application is generally executed by a server, and accordingly, the page data form output device is generally set in the server.

[0068] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is merely illustrative. Any number of terminal devices, networks and servers may be provided as required.

[0069] Continue to refer Figure 2 , shows a flow chart of an embodiment of a method for outputting page data in a form according to the present application. The method for outputting page data in a form includes the following steps:

[0070] Step 201: extract the business data content in the target page.

[0071] In this embodiment, the target page includes an online medical order page and an online medical appointment page. The business data content includes the drug name, specification information, price information, prescribing doctor information, etc. in the online medical order page. The business data content also includes the doctor's basic information, treatment time information, and patient basic information in the online medical appointment page.

[0072] By extracting the business data content from the target page, it is possible to quickly generate online medical-related forms, such as online consultation appointment forms, online drug ordering forms, etc.

[0073] Step 202: Perform a first process on the service data content to generate a data cache file in a target format.

[0074] In this embodiment, the first processing of the business data content includes classifying and clustering the business data content to facilitate subsequent form generation. The generated data cache file in the target format can be a preliminary xlsx format file to facilitate the form display of the business data content in the xlsx format file.

[0075] Specifically, for example, the drug name, specification information, price information, prescribing doctor information, etc. in the online medical order page in step 201 are first processed to generate a data cache file in the target format, which is convenient for subsequent form-based mapping output of the online drug order form.

[0076] Specifically, before the first processing is performed on the business data content, the business data content is also preliminarily cleaned and error corrected, so as to ensure the accuracy of the data obtained by the front-end page.

[0077] Step 203: Import the data cache file into the data form plug-in.

[0078] In this embodiment, the data cache file, that is, the cache file in the preliminary xlsx format, can be understood as not having too many complex form styles set at this time. Therefore, the data cache file is imported into the data form plug-in, and the cache file in the preliminary xlsx format is organized in a more detailed form according to the row and column attribute configuration information and cell attribute configuration information in the data form plug-in.

[0079] Step 204 : Based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in, perform a second processing on the business data content in the data cache file to obtain a second processing result.

[0080] Specifically, based on the row and column attribute configuration information and cell attribute configuration information in the data form plug-in, the business data content in the data cache file is subjected to a second processing to obtain a second processing result. This can be understood as supplementing the cache file in the preliminary xlsx format after the first processing with row and column attribute configuration information and cell attribute configuration information to make the display of the business data content more standardized.

[0081] For example, the drug name, specification information, price information, prescribing doctor information, etc. in the online medical order page in step 201 are first processed to preliminarily generate a data cache file in xlsx format. Here, step 204 combines the row and column attribute configuration information and cell attribute configuration information in the data form plug-in to perform a more standardized arrangement of the preliminarily generated data cache file in xlsx format to facilitate the subsequent standardized output of the business data content.

[0082] Step 205: Output the target data form generated by the data form plug-in according to the second processing result.

[0083] Specifically, the business data content is finally output in the form of a data form through the data form plug-in.

[0084] Generally speaking, directly extracting business data content from the front-end target page avoids repeatedly retrieving data from the background database, reducing the resource call pressure of the database; performing a first processing on the business data content to preliminarily generate a cache file in the xlsx format, and then using a data form plug-in to perform a more standardized second processing on the preliminarily generated cache file in the xlsx format, outputting the cache file after the second processing in the form, and formatting the business data content in xlsx, which facilitates subsequent form output and reduces resource consumption when converting to complex file formats.

[0085] In this embodiment, the business data content in the target page is extracted; a first processing is performed on the business data content to generate a data cache file in a target format; the data cache file is imported into a data form plug-in; a second processing is performed on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and a target data form generated by the data form plug-in based on the second processing result is output. By directly extracting the business data content from the front-end target page, repeated data retrieval from the back-end database is avoided, reducing the resource call pressure of the database; the business data content is first processed to initially generate a cache file in the .xlsx format; then, the initially generated cache file in the .xlsx format is subjected to a more standardized second processing by the data form plug-in; the cache file after the second processing is output as a form, and the business data content is formatted and organized in .xlsx format, which facilitates subsequent form output and reduces the resource consumption problem when converting to complex file formats. The page data form output method is applied to online medical and health scenarios, which can avoid the resource consumption of data call and complex file format conversion, and improve the efficiency of business form generation.

[0086] In this embodiment, the step of extracting the business data content in the target page specifically includes: introducing a preset front-end data extraction plug-in into the target page, wherein the preset front-end data extraction plug-in includes: a front-end data extraction plug-in based on optical OCR text recognition technology, a front-end data extraction plug-in based on web crawler technology, and a front-end data extraction plug-in based on Sheet.JS technology; starting the front-end data extraction plug-in to extract the business data content.

[0087] Specifically, the front-end data extraction plug-in based on optical OCR text recognition technology extracts the business data content in the target page; the front-end data extraction plug-in based on web crawler technology extracts the business data content in the target page, and the front-end data extraction plug-in based on Sheet.JS technology extracts the business data content in the target page, realizing the direct acquisition of business data content from the front-end page, avoiding the previous frequent call of data content from the database, and reducing the consumption of database call resources.

[0088] Continue to refer Figure 3 , Figure 3 yes Figure 2 The flowchart of a specific embodiment of step 202 shown includes the following steps:

[0089] Step 301: pre-classify all data in the business data content according to a preset classification dictionary;

[0090] Step 302: Based on the pre-classification processing result, all data in the business data content are processed into N×M preliminary tables, where N represents the number of classification categories and M represents the number of classification data corresponding to the largest classification category in the pre-classification processing result;

[0091] Step 303: Generate a cache file in xlsx format based on the N×M preliminary form processing results.

[0092] Continue to refer Figure 4 In some optional implementations, after step 301, a step of controlling the number of classification categories is also included. Figure 4 This is a flowchart of a specific embodiment of controlling the number of classification categories in the page data form output method described in this application, including the following steps:

[0093] Step 401, counting the number of classification data corresponding to each classification category;

[0094] Step 402: If the amount of classified data corresponding to the current classification category is greater than a set first quantity threshold, then secondary classification processing is performed on the classified data corresponding to the current classification category;

[0095] Step 403: If the amount of classification data corresponding to the current classification category is less than the set second amount threshold, the classification data corresponding to the current classification category is used as merged data and merged into other classification categories;

[0096] Step 404 : Classification is completed until the quantity of classified data corresponding to all classification categories is between a first quantity threshold and a second quantity threshold, wherein the first quantity threshold is greater than the second quantity threshold.

[0097] By combining the first quantity threshold and the second quantity threshold, the number of classification categories corresponding to the business data content is between the first quantity threshold and the second quantity threshold, that is, the number of columns of the final output form is guaranteed to be between the first quantity threshold and the second quantity threshold, avoiding the problem of too few columns or too many columns.

[0098] Continue to refer Figure 5 In some optional implementations, a step of constructing a data form plug-in is included before step 203. Figure 5 This is a flowchart of a specific embodiment of constructing a data form plug-in in the page data form output method described in this application, including the following steps:

[0099] Step 501: Obtain a pre-created first configuration function, wherein the first configuration function is used to configure row and column attribute information in a form, and the configuration items of the first configuration function include row height and column width;

[0100] Step 502: Obtain a pre-created second configuration function, wherein the second configuration function is used to configure attribute information of cells in the form, and the configuration items of the second configuration function include cell data type, cell alignment, cell font style, cell fill style, and cell border style;

[0101] Step 503: Encapsulate the first configuration function and the second configuration function to obtain the data form plug-in.

[0102] The data form plug-in is obtained by encapsulating the first configuration function and the second configuration function. Since the first configuration function is used to configure the row height and column width of the form, and the second configuration function is used to configure the data type, cell alignment, cell font style, cell fill style and cell border style in the cell, it is ensured that the form processed by the subsequent data form plug-in has completed the addition of the above-mentioned table style, so as to output more beautiful online documents for customers.

[0103] In this embodiment, after executing the step of encapsulating the first configuration function and the second configuration function to obtain the data form plug-in, the method also includes: setting the dynamic processing priority of the data form plug-in according to the front-end access frequency, wherein the front-end access frequency is provided by the access record log. Specifically, if the front-end access frequency within the continuous set unit time and number of times is less than the set access frequency threshold, the processing priority of the data form plug-in is dynamically increased to the first processing priority; if the front-end access frequency within the continuous set unit time and number of times is greater than the set access frequency threshold, the processing priority of the data form plug-in is dynamically reduced to the second processing priority, and the first processing priority is higher than the second processing priority.

[0104] By setting the dynamic processing priority of the data form plug-in according to the front-end access frequency, it can fully take into account the situation that the computing power of the front-end is not high, so as to facilitate the generation of online documents when the customer access frequency is low. When the customer access frequency is high, that is, when the browsing is frequently refreshed, a lower processing efficiency is used for generation to reduce the situation where customers encounter freezes on the target page.

[0105] Continue to refer Figure 6 , Figure 6 yes Figure 2 The flowchart of a specific embodiment of step 204 shown includes the following steps:

[0106] Step 601: Identify the row and column attribute configuration information and the cell attribute configuration information obtained by the data form plug-in according to the preset parameter interface;

[0107] Step 602, configuring the row and column attribute information and the cell attribute information in the data cache file of the target format according to the row and column attribute configuration information and the cell attribute configuration information;

[0108] Step 603: Obtain the configuration result corresponding to the data cache file.

[0109] Specifically, the preset parameter interface of the data form plug-in can be an input parameter interface reserved for external use when the first configuration function and the second configuration function are encapsulated to obtain the data form plug-in. The row and column attribute configuration information and the cell attribute configuration information can be set through this input parameter interface, so that the data form plug-in can configure the row and column attribute information and the cell attribute information in the data cache file of the target format.

[0110] Continue to refer Figure 7 , Figure 7 yes Figure 2 The flowchart of a specific embodiment of step 205 shown includes the following steps:

[0111] Step 701, identifying a preset output interface;

[0112] Specifically, the preset output interface is, for example, a document output interface for customers who make appointments or place orders when the target page generates an online document.

[0113] Step 702: setting the output interface as the plug-in output interface of the data form plug-in;

[0114] Step 703: Based on the configuration result corresponding to the data cache file, the data cache file is converted into a form to obtain a workbook format file to be output;

[0115] Step 704: Output the workbook format file via the plug-in output interface of the data form plug-in to obtain the target data form.

[0116] The present application extracts the business data content from the target page; performs a first processing on the business data content to generate a data cache file in a target format; imports the data cache file into a data form plug-in; performs a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and outputs the target data form generated by the data form plug-in based on the second processing result. By directly extracting the business data content from the front-end target page, it avoids repeatedly retrieving data from the back-end database, reducing the resource call pressure of the database; performs a first processing on the business data content to initially generate a cache file in the xlsx format, and then uses the data form plug-in to perform a more standardized second processing on the initially generated xlsx format cache file, outputs the cache file after the second processing in a form, and formats the business data content in xlsx format, facilitating subsequent form output and reducing the resource consumption problem when converting to complex file formats. The page data form output method is applied to online medical and health scenarios, which can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation.

[0117] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Artificial Intelligence (AI) is the theory, method, technology, and application system that uses digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use knowledge to achieve optimal results.

[0118] Fundamental AI technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing, operating / interaction systems, and mechatronics. AI software technologies primarily encompass computer vision, robotics, biometrics, speech processing, natural language processing, and machine learning / deep learning.

[0119] In an embodiment of the present application, the business data content in the target page is extracted; the business data content is first processed to generate a data cache file in a target format; the data cache file is imported into a data form plug-in; based on the row and column attribute configuration information and cell attribute configuration information in the data form plug-in, the business data content in the data cache file is second processed to obtain a second processing result; and the target data form generated by the data form plug-in according to the second processing result is output. By directly extracting the business data content from the front-end target page, repeated data retrieval from the back-end database is avoided, reducing the resource call pressure of the database; the business data content is first processed to initially generate a cache file in the xlsx format, and then the cache file in the initially generated xlsx format is subjected to a more standardized second processing using the data form plug-in, and the cache file after the second processing is output in a form, and the business data content is formatted and organized in xlsx format, which facilitates subsequent form output and reduces the resource consumption problem when converting to complex file formats. The page data form output method is applied to online medical and health scenarios, which can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation.

[0120] Further references Figure 8 , as a response to the above Figure 2 The present application provides an embodiment of a device for outputting page data in a form. Figure 2 Corresponding to the method embodiment shown, the device can be specifically applied to various electronic devices.

[0121] like Figure 8 As shown, the apparatus 800 for outputting page data in a form according to this embodiment includes: a data extraction module 801, a first processing module 802, an import plug-in module 803, a second processing module 804 and a form output module 805.

[0122] Data extraction module 801, used to extract business data content from the target page;

[0123] A first processing module 802 is configured to perform a first processing on the service data content to generate a data cache file in a target format;

[0124] The import plug-in module 803 is used to import the data cache file into the data form plug-in;

[0125] A second processing module 804 is configured to perform a second process on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result;

[0126] The form output module 805 is used to output the target data form generated by the data form plug-in according to the second processing result.

[0127] The present application extracts the business data content from the target page; performs a first processing on the business data content to generate a data cache file in a target format; imports the data cache file into a data form plug-in; performs a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and outputs the target data form generated by the data form plug-in based on the second processing result. By directly extracting the business data content from the front-end target page, it avoids repeatedly retrieving data from the back-end database, reducing the resource call pressure of the database; performs a first processing on the business data content to initially generate a cache file in the xlsx format, and then uses the data form plug-in to perform a more standardized second processing on the initially generated xlsx format cache file, outputs the cache file after the second processing in a form, and formats the business data content in xlsx format, facilitating subsequent form output and reducing the resource consumption problem when converting to complex file formats. The page data form output method is applied to online medical and health scenarios, which can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation.

[0128] Those skilled in the art will appreciate that all or part of the processes in the above-described method embodiments can be implemented by instructing related hardware via computer-readable instructions. The computer-readable instructions can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes in the above-described method embodiments. The aforementioned storage medium can be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0129] It should be understood that although the steps in the flowcharts of the accompanying drawings are shown in sequence as indicated by the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some of the steps in the flowcharts of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.

[0130] To solve the above technical problems, the present application also provides a computer device. Figure 9 , Figure 9 This is a basic structural block diagram of the computer device in this embodiment.

[0131] The computer device 9 includes a memory 9a, a processor 9b, and a network interface 9c that are interconnected via a system bus. Figure 9 Only a computer device 9 having components such as a memory 9a, a processor 9b, and a network interface 9c is shown. However, it should be understood that it is not required to implement all of the components shown, and more or fewer components may be implemented instead. It should be understood by those skilled in the art that a computer device herein is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to a microprocessor, an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), a digital signal processor (DSP), an embedded device, and the like.

[0132] The computer device may be a desktop computer, notebook computer, PDA, cloud server, etc. The computer device may interact with the user via a keyboard, mouse, remote control, touchpad, or voice control device.

[0133] The memory 9a includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic storage, magnetic disk, optical disk, etc. In some embodiments, the memory 9a can be an internal storage unit of the computer device 9, such as the hard disk or memory of the computer device 9. In other embodiments, the memory 9a can also be an external storage device of the computer device 9, such as a plug-in hard disk equipped on the computer device 9, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, etc. Of course, the memory 9a can also include both the internal storage unit of the computer device 9 and its external storage device. In this embodiment, the memory 9a is generally used to store the operating system and various application software installed on the computer device 9, such as computer-readable instructions for a method for outputting page data in a form. In addition, the memory 9a can also be used to temporarily store various types of data that have been output or are to be output.

[0134] In some embodiments, the processor 9b may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip. The processor 9b is generally used to control the overall operation of the computer device 9. In this embodiment, the processor 9b is used to execute computer-readable instructions stored in the memory 9a or process data, such as executing computer-readable instructions for the page data form output method.

[0135] The network interface 9c may include a wireless network interface or a wired network interface. The network interface 9c is generally used to establish a communication connection between the computer device 9 and other electronic devices.

[0136] The computer device proposed in this embodiment belongs to the field of research and development design technology and is applied to the front-end interface data form output scenario. This application extracts the business data content in the target page; performs a first processing on the business data content to generate a data cache file in the target format; imports the data cache file into the data form plug-in; performs a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and outputs the target data form generated by the data form plug-in according to the second processing result. By directly extracting the business data content from the front-end target page, it avoids repeatedly retrieving data from the background database and reduces the resource call pressure of the database; performs a first processing on the business data content to preliminarily generate a cache file in the xlsx format, and then uses the data form plug-in to perform a more standardized second processing on the preliminarily generated xlsx format cache file, outputs the cache file after the second processing in form form, and formats the business data content in xlsx, which facilitates subsequent form output and reduces the resource consumption problem when converting to complex file formats. Applying the page data form output method to online medical and health scenarios can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation.

[0137] The present application also provides another embodiment, namely, providing a computer-readable storage medium, which stores computer-readable instructions. The computer-readable instructions can be executed by a processor to enable the processor to perform the steps of the page data form output method as described above.

[0138] The computer-readable storage medium proposed in this embodiment belongs to the field of research and development design technology and is applied to the front-end interface data form output scenario. This application extracts the business data content in the target page; performs a first processing on the business data content to generate a data cache file in the target format; imports the data cache file into the data form plug-in; performs a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; and outputs the target data form generated by the data form plug-in according to the second processing result. By directly extracting the business data content from the front-end target page, it avoids repeatedly retrieving data from the background database and reduces the resource call pressure of the database; performs a first processing on the business data content to preliminarily generate a cache file in the xlsx format, and then uses the data form plug-in to perform a more standardized second processing on the preliminarily generated xlsx format cache file, outputs the cache file after the second processing in form form, and formats the business data content in xlsx, which facilitates subsequent form output and reduces the resource consumption problem when converting to complex file formats. Applying the page data form output method to online medical and health scenarios can avoid data call resource consumption and complex file format conversion resource consumption, and improve the efficiency of business order generation.

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

[0140] Obviously, the embodiments described above are only some of the embodiments of the present application, rather than all of the embodiments. The preferred embodiments of the present application are given in the accompanying drawings, but they do not limit the patent scope of the present application. The present application can be implemented in many different forms. On the contrary, the purpose of providing these embodiments is to make the understanding of the disclosure of the present application more thorough and comprehensive. Although the present application has been described in detail with reference to the aforementioned embodiments, for those skilled in the art, it is still possible to modify the technical solutions described in the aforementioned specific embodiments, or to make equivalent replacements for some of the technical features therein. Any equivalent structure made using the contents of the present application specification and the accompanying drawings, directly or indirectly used in other related technical fields, is also within the scope of patent protection of the present application.

Claims

1. A method for outputting page data in a form, characterized in that: The steps include: Extract business data content from the target page; Performing a first process on the business data content to generate a data cache file in a target format; Importing the data cache file into the data form plug-in; Based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in, performing a second processing on the business data content in the data cache file to obtain a second processing result; Outputting the target data form generated by the data form plug-in according to the second processing result.

2. The method for outputting page data in a form according to claim 1, characterized in that: The step of extracting the business data content in the target page specifically includes: Introducing a preset front-end data extraction plug-in into the target page, wherein the preset front-end data extraction plug-in includes: a front-end data extraction plug-in based on optical OCR text recognition technology, a front-end data extraction plug-in based on web crawler technology, and a front-end data extraction plug-in based on Sheet.JS technology; Start the front-end data extraction plug-in to extract the business data content.

3. The method for outputting page data in a form according to claim 1, characterized in that: The step of performing a first processing on the business data content to generate a data cache file in a target format specifically includes: Pre-classifying all data in the business data content according to a preset classification dictionary; Based on the pre-classification processing result, all data in the business data content are processed into N×M preliminary forms, where N represents the number of classification categories and M represents the number of classification data corresponding to the largest classification category in the pre-classification processing result; Generate a cache file in xlsx format based on the N×M preliminary form processing results.

4. The method for outputting page data in a form according to claim 3, characterized in that: After executing the step of pre-classifying all data in the business data content according to a preset classification dictionary, the method further includes: Count the number of classified data corresponding to each classification category; If the amount of classified data corresponding to the current classification category is greater than a set first amount threshold, performing secondary classification processing on the classified data corresponding to the current classification category; If the amount of classification data corresponding to the current classification category is less than the set second amount threshold, the classification data corresponding to the current classification category is used as merged data and merged into other classification categories; The classification is completed until the quantity of classified data corresponding to all classification categories is between a first quantity threshold and a second quantity threshold, wherein the first quantity threshold is greater than the second quantity threshold.

5. The method for outputting page data in a form according to claim 1, characterized in that: Before executing the step of importing the data cache file into the data form plug-in, the method further includes: Obtain a pre-created first configuration function, wherein the first configuration function is used to configure row and column attribute information in a form, and the configuration items of the first configuration function include the number of rows, the number of columns, the row height, and the column width; Obtain a pre-created second configuration function, wherein the second configuration function is used to configure cell attribute information in the form, and the configuration items of the second configuration function include cell data type, cell alignment, cell font style, cell fill style, and cell border style; The first configuration function and the second configuration function are encapsulated to obtain the data form plug-in.

6. The method for outputting page data in a form according to claim 1 or 5, characterized in that: The step of performing a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result specifically includes: Identify the row and column attribute configuration information and the cell attribute configuration information obtained by the data form plug-in according to the preset parameter interface; According to the row and column attribute configuration information and the cell attribute configuration information, configuring the row and column attribute information and the cell attribute information in the data cache file of the target format; Obtain the configuration result corresponding to the data cache file.

7. The method for outputting page data in a form according to claim 6, characterized in that: The step of outputting the target data form generated by the data form plug-in according to the second processing result specifically includes: Identify the preset output interface; Setting the output interface to be the plug-in output interface of the data form plug-in; According to the configuration result corresponding to the data cache file, the data cache file is processed into a form to obtain a workbook format file to be output; The workbook format file is output through the plug-in output interface of the data form plug-in to obtain the target data form.

8. A device for outputting page data in a form, characterized in that: include: Data extraction module, used to extract business data content from the target page; A first processing module, used for performing a first processing on the business data content to generate a data cache file in a target format; An import plug-in module is used to import the data cache file into the data form plug-in; A second processing module, configured to perform a second processing on the business data content in the data cache file based on the row and column attribute configuration information and the cell attribute configuration information in the data form plug-in to obtain a second processing result; The form output module is used to output the target data form generated by the data form plug-in according to the second processing result.

9. A computer device, characterized in that: The method comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of the page data form output method according to any one of claims 1 to 7 when executing the computer-readable instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the steps of the method for outputting page data in a form as described in any one of claims 1 to 7 are implemented.

Images