Web table screening method, terminal device and computer-readable storage medium

Abstract

The present invention discloses a web table screening method, a terminal device and a computer-readable storage medium. The web table screening method comprises: a front end directly classifies, matches and screens table data, and there is no need to develop a cumbersome request interface at the back end to correspond to a query request issued by a user, thereby conveniently realizing a global fuzzy screening function in web table data, and at the same time realizing a multi-style conditional header screening function by setting fuzzy screening for table header screening conditions and screening multiple conditions simultaneously, meeting the user's personalized query needs when querying web tables, improving the user's query efficiency, making the web table data query more user-friendly in different screening scenarios, and improving the user's use experience.

Description

Technical Field

[0001] The present invention relates to the fields of web, front end and data screening, and in particular to a web table screening method, terminal equipment and computer-readable storage medium. Background Art

[0002] With the continuous development and application of Internet technology, users visit web pages more and more frequently. When users query data through web tables, the common way is that users select a series of filtering conditions, and then the backend returns the corresponding table data. However, there are cases where users only vaguely remember the keywords of part of the data, and the existing filtering conditions cannot find the filtering conditions related to the keywords. On the other hand, some tables can realize the function of header filtering, but there is a single filtering form and too much data filtered by a header, which is also not conducive to the realization of the filtering function, causing users to spend a lot of time but unable to find the data they want. Therefore, the current web table query function is not user-friendly and is not conducive to the user experience.

[0003] The above contents are only used to assist in understanding the technical solution of the present invention and do not constitute an admission that the above contents are prior art. Summary of the invention

[0004] The main purpose of the present invention is to provide a web form screening method, aiming to solve the technical problem that the current web form query function is not user-friendly and is not conducive to user experience.

[0005] To achieve the above object, the present invention provides a web form screening method, the web form screening method comprising:

[0006] Get the full table data from the backend, and classify the full table data to obtain optional header filtering conditions;

[0007] Displaying the full table data in the current web page table, the web page table further comprising: a fuzzy filter input box and a header filter condition column, and displaying the optional header filter condition in the header filter condition column;

[0008] When the content of the fuzzy filter input box or the filter condition selected in the header filter condition column changes, the filter function is triggered;

[0009] Determine whether to trigger fuzzy filtering;

[0010] If fuzzy filtering is triggered, the content of the current fuzzy filtering input box is matched with the full data table to obtain the filtered data;

[0011] Determine whether to trigger header filtering;

[0012] If the header filter is triggered, the filter condition selected in the current header filter condition column is matched with the fuzzy filter data to obtain the secondary filter data;

[0013] The secondary filtering data is displayed in the table of the current web page, and the fuzzy filtering input box and the table header filtering condition column are monitored synchronously.

[0014] Furthermore, the optional header screening conditions obtained by classifying the entire table data include:

[0015] Get the data of each column in the entire table data as the optional header filtering condition of the corresponding column header;

[0016] Among them, the optional header filtering conditions are first-level and above filtering conditions, and are displayed in the header filtering condition column of the corresponding column.

[0017] Furthermore, matching the filter condition selected in the filter condition column of the current table header with the fuzzy filter data includes:

[0018] If the current header filter condition column is a numerical header column and a numerical range is selected, then all data falling within the numerical range matches the filter condition selected for the numerical header column.

[0019] Furthermore, displaying the secondary screening data in a table on the current web page includes:

[0020] The characters in the secondary filtering data that are identical to the contents of the current fuzzy filtering input box are highlighted in the web page table, and the table headers with changed filtering conditions are placed in front of the web table, and the table data that matches the contents of the current fuzzy filtering input box is placed in front of the web table.

[0021] Furthermore, the table header filtering condition column also includes a table header fuzzy filtering condition input box, and the table header fuzzy filtering condition input box is monitored at the same time.

[0022] Further, the monitoring of the header fuzzy screening condition input box includes:

[0023] When the content of the header fuzzy filtering condition input box changes, the content of the current header fuzzy filtering condition input box is matched with the optional header filtering condition to obtain an optional header filtering condition;

[0024] The optional header filtering condition is displayed in the header filtering condition column.

[0025] Furthermore, after the step of determining whether fuzzy screening is triggered, the following steps are included:

[0026] If the fuzzy filter is not triggered, the content of the current header filter condition column is matched with the full table data to obtain the filtered data;

[0027] The filtered data is displayed once in the table of the current web page, and the fuzzy filter input box and the table header filter condition column are monitored synchronously.

[0028] Furthermore, after the step of determining whether to trigger header screening, the following steps are included:

[0029] If the header filter is not triggered, the first-filtered data will be displayed on the current web page, and the characters in the first-filtered data that are identical to the content of the current fuzzy filter input box will be highlighted, and the fuzzy filter input box and the header filter condition bar will be monitored synchronously.

[0030] In addition, to achieve the above-mentioned purpose, the present invention also provides a terminal device, which includes: a memory, a processor, and a web form filtering program stored in the memory and executable on the processor, and the web form filtering program implements the steps of the web form filtering method as described above when executed by the processor.

[0031] In addition, to achieve the above object, the present invention further provides a computer-readable storage medium, on which a web form screening program is stored, and when the web form screening program is executed by a processor, the steps of the web form screening method as described above are implemented.

[0032] A web table screening method proposed in an embodiment of the present invention, when the front-end page is loaded, the front-end will obtain all the table data stored in the back-end, and directly classify, match and screen the data on the front-end, without the need to develop a cumbersome request interface on the back-end to correspond to the query request issued by the user, thereby conveniently realizing the function of global fuzzy screening in web table data, and at the same time realizing the multi-style condition header screening function by setting fuzzy screening for the header screening conditions and screening with multiple conditions at the same time, meeting the user's demand for personalized query when querying the web table, improving the user's query efficiency, making the web table data query more user-friendly in different screening scenarios, and improving the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is a schematic diagram of the structure of a terminal device in a hardware operating environment involved in an embodiment of the present invention;

[0034] Figure 2 It is a flowchart of the first embodiment of the web form screening method of the present invention;

[0035] Figure 3This is a flow chart of a second embodiment of the web form screening method of the present invention based on the first embodiment;

[0036] Figure 4 This is a schematic diagram of a third implementation flow of the web form screening method of the present invention based on the first embodiment.

[0037] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0038] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.

[0039] The main solution of the embodiment of the present invention is: after all table data are obtained through the front end, the obtained table data are uniformly classified, matched and filtered, thereby providing users with web page table fuzzy filtering and multi-style header filtering functions.

[0040] Since the common method in the prior art is that the user selects a series of filtering conditions, and then the backend returns the corresponding table data, only a single header is used for filtering. This is also not conducive to realizing the filtering function when the amount of data to be filtered is large, resulting in low efficiency in user query data, and the query function is not user-friendly, which is not conducive to the user experience.

[0041] The present invention provides a web table screening method, which provides users with web page table fuzzy screening and multi-style header screening functions, meets the user's screening needs under different screening conditions, improves the user's screening efficiency, and enhances the user experience.

[0042] like Figure 1 As shown, Figure 1 It is a schematic diagram of the device terminal structure of the hardware operating environment involved in the embodiment of the present invention.

[0043] The terminal in the embodiment of the present invention may be a PC, or an electronic device such as a portable computer.

[0044] like Figure 1As shown, the terminal may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a WI-FI interface). The memory 1005 may be a high-speed RAM memory, or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0045] Optionally, the terminal may also include a camera, an RF (Radio Frequency) circuit, a sensor, an audio circuit, a WiFi module, and the like. Among them, sensors include light sensors, motion sensors, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display screen according to the brightness of the ambient light, and the proximity sensor may turn off the display screen and / or backlight when the mobile terminal is moved to the ear. As a type of motion sensor, the gravity acceleration sensor can detect the magnitude of acceleration in each direction (generally three axes), and can detect the magnitude and direction of gravity when stationary. It can be used for applications that identify the posture of the mobile terminal (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal may also be equipped with other sensors such as gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc., which will not be repeated here.

[0046] Those skilled in the art will understand that Figure 1 The terminal structure shown in the figure does not constitute a limitation on the terminal, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0047] like Figure 1 As shown, the memory 1005 as a computer storage medium may include an operating system, a network communication module, a user interface module, and a web form screening method.

[0048] exist Figure 1 In the terminal shown, the network interface 1004 is mainly used to connect to the backend server and perform data communication with the backend server; the user interface 1003 is mainly used to connect to the client (user end) and perform data communication with the client; and the processor 1001 can be used to call the web form screening method stored in the memory 1005 and perform the following operations:

[0049] Get the full table data from the backend, and classify the full table data to obtain optional header filtering conditions;

[0050] Displaying the full table data in the current web page table, the web page table further comprising: a fuzzy filter input box and a header filter condition column, and displaying the optional header filter condition in the header filter condition column;

[0051] When the content of the fuzzy filter input box or the filter condition selected in the header filter condition column changes, the filter function is triggered;

[0052] Determine whether to trigger fuzzy filtering;

[0053] If fuzzy filtering is triggered, the content of the current fuzzy filtering input box is matched with the full data table to obtain the filtered data;

[0054] Determine whether to trigger header filtering;

[0055] If the header filter is triggered, the filter condition selected in the current header filter condition column is matched with the fuzzy filter data to obtain the secondary filter data;

[0056] The secondary filtering data is displayed in the table of the current web page, and the fuzzy filtering input box and the table header filtering condition column are monitored synchronously.

[0057] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0058] The optional header screening conditions obtained by classifying the entire table data include:

[0059] Get the data of each column in the entire table data as the optional header filtering condition of the corresponding column header;

[0060] Among them, the optional header filtering conditions are first-level and above filtering conditions, and are displayed in the header filtering condition column of the corresponding column.

[0061] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0062] The matching of the filter condition selected in the filter condition column of the current table header with the fuzzy filter data includes:

[0063] If the current header filter condition column is a numerical header column and a numerical range is selected, then all data falling within the numerical range matches the filter condition selected for the numerical header column.

[0064] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0065] The secondary screening data is displayed in the table of the current web page including:

[0066] The characters in the secondary filtering data that are identical to the contents of the current fuzzy filtering input box are highlighted in the web page table, and the table headers with changed filtering conditions are placed in front of the web table, and the table data that matches the contents of the current fuzzy filtering input box is placed in front of the web table.

[0067] Furthermore, the table header filtering condition column also includes a table header fuzzy filtering condition input box, and the table header fuzzy filtering condition input box is monitored at the same time.

[0068] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0069] The monitoring of the header fuzzy screening condition input box includes:

[0070] When the content of the header fuzzy filtering condition input box changes, the content of the current header fuzzy filtering condition input box is matched with the optional header filtering condition to obtain an optional header filtering condition;

[0071] The optional header filtering condition is displayed in the header filtering condition column.

[0072] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0073] After the step of determining whether fuzzy screening is triggered, the following steps are included:

[0074] If the fuzzy filter is not triggered, the content of the current header filter condition column is matched with the full table data to obtain the filtered data;

[0075] The filtered data is displayed once in the table of the current web page, and the fuzzy filter input box and the table header filter condition column are monitored synchronously.

[0076] Further, the processor 1001 may call the web form screening program stored in the memory 1005, and further perform the following operations:

[0077] After the step of determining whether to trigger header screening, the following steps are included:

[0078] If the header filter is not triggered, the first-filtered data will be displayed on the current web page, and the characters in the first-filtered data that are identical to the content of the current fuzzy filter input box will be highlighted, and the fuzzy filter input box and the header filter condition bar will be monitored synchronously.

[0079] Reference Figure 2 In a first embodiment of the web form screening method of the present invention, the web form screening method comprises:

[0080] Step S10, obtaining the full table data of the backend, classifying the full table data to obtain optional header filtering conditions, and displaying the full table data in the current web page table, wherein the web page table further includes: a fuzzy filtering input box and a header filtering condition column, and the optional header filtering conditions are displayed in the header filtering condition column;

[0081] It can be understood that the web table filtering function in this embodiment is realized by secondary development of Element-UI components through the front-end javascript language and the render function of the Vue framework, where javascript is used to obtain all the table data of the back end, and Element-UI is used to display the table data. Therefore, the implementation subject of data classification, matching and filtering in this embodiment is the front-end web page. The front-end web page obtains all the table data of the back end, that is, the full table data, and classifies all the obtained table data according to the header of each column in the table data, and obtains the data of each column in the full table data as the optional header filtering condition of the corresponding column header, wherein the optional header filtering condition is the first level and above filtering condition, and is displayed in the header filtering condition column of the corresponding column.

[0082] For example, in a data table, the header of each column is the label name, Chinese name, directory, type, person in charge, creation time and description, etc., and each header is a collection of header filtering conditions. For example, under the Chinese name header, the last level of header filtering conditions are included: Test 1, Test 2, Test 3, Test 4, Experiment 1, Experiment 2, Experiment 3 and Experiment 4, etc. Therefore, the filtering conditions under the Chinese name header can be divided into two levels, and the first-level filtering conditions are: Test and Experiment. For the first-level filtering condition test, the front-end web page divides the table data containing test under the Chinese name header in all the acquired table data into a collection of first-level filtering conditions, wherein the first-level filtering condition test contains several second-level filtering conditions: Test 1, Test 2, Test 3 and Test 4, etc. For the header filtering condition test 1, the front-end web page divides the table data of the first-level filtering condition collection test under the Chinese name header that is also test 1 into a collection of second-level filtering. When the user checks the test, it means that the collection data of the second-level filtering is selected. When the web page is loaded and all table data is obtained, all the obtained table data will be displayed in the current web page table. In addition, a fuzzy filter input box and a header filter condition bar are provided in the web page table. When the user only remembers some keywords of the data, the keyword can be entered in the fuzzy filter input box, and the header filter condition bar provides the user with filtering conditions.

[0083] It is understandable that in this embodiment, the classification processing of the table data is completed by the front-end web page, so as to facilitate the matching and screening work on the front-end web page, eliminating the need for back-end screening interface development work.

[0084] Step S20, monitoring the fuzzy filter input box and the table header filter condition column, and triggering the filter function when the content of the fuzzy filter input box or the filter condition selected in the table header filter condition column changes;

[0085] When all the acquired data are displayed in a table on the webpage, the fuzzy filter input box and the table header filter condition column are monitored at the same time. When the user enters or deletes characters in the fuzzy filter input box or the filter condition selected in the table header filter condition column is reduced or increased, it is considered that a change has occurred. When a change occurs, it is considered that the user is filtering data in the table, and a filtering function is called, and the filtering function includes steps S30 to S70.

[0086] Step S30, determining whether fuzzy screening is triggered;

[0087] After calling the filter function, first determine whether to trigger the fuzzy filter based on whether the content of the fuzzy filter input box changes.

[0088] Step S40, if fuzzy filtering is triggered, the content of the current fuzzy filtering input box is matched with the full data table to obtain primary filtering data;

[0089] If the content of the fuzzy filter input box changes, it is considered that the user is using fuzzy filtering. After determining that the fuzzy filter is triggered, the content of the current fuzzy filter input box is extracted, and a search and match is performed in all table data based on the content of the input box. In this example, the content of the input box can be Chinese, numbers, and English, case-sensitive and special characters, etc. All table data containing the content of the input box are the objects of this match. For example, when the user enters ng in the fuzzy filter input box, the content of the input box changes, triggering fuzzy filtering, and extracting ng in the current fuzzy filter input box. Among all the acquired table data, if the information in the cell corresponding to the header name Type of the a-th row data is string; the information in the cell corresponding to the header name Responsible Person of the n-th row data is string; the information in the cell corresponding to the header name Description of the f-th row data is string, where string contains the letter ng, so the data in the a-th, n-th and f-th rows above will all be the objects of this match, and the a-th, n-th and f-th row data are the filtered data after fuzzy filtering.

[0090] It is understandable that when the user only remembers some of the keywords in the data he wants to find, he can perform global fuzzy filtering on the table data by searching for some of the keywords. This solves the problem that when there is too much table data and the vaguely remembered keywords cannot be found in the filtering conditions, the user can only perform manual comparison in the cells in the table data, thereby improving the user's filtering speed.

[0091] Step S50, determining whether to trigger header screening;

[0092] When the fuzzy filtering is completed, whether to trigger the header filtering is determined based on whether the filtering condition selected in the header filtering condition column changes.

[0093] Step S60, if the header screening is triggered, the screening condition selected in the current header screening condition column is matched with the fuzzy screening data to obtain secondary screening data;

[0094] If the filter condition selected in the header filter condition column changes, it is considered that the header filter is triggered. After determining that the header filter is triggered, the filter condition selected in the current header filter column is matched with the primary filter data after fuzzy filtering. For example, the primary filter data contains the original data in the ath row, the nth row and the fth row, and the information in the cells under the Chinese names of the three rows of data are Test 1, Test 2 and Test 3 respectively. In the primary filter data, the header filter column with the Chinese name will contain the three filter conditions of Test 1, Test 2 and Test 3. If the user selects all the filter conditions by default without performing header filtering, when the user only selects the filter condition Test 1, the header filter is triggered. In the primary filter data, only the data in the ath row meets the filter condition of Test 1. Therefore, the secondary filter data obtained will only contain the data in the ath row.

[0095] Similarly, when several header filtering conditions are changed, for example, in the above example, the header names corresponding to each column of data include label name, Chinese name, directory, type, person in charge, creation time and description, etc., where the header of the Chinese name contains header filtering conditions: Test 1, Test 2 and Test 3, etc. Similarly, each header name contains one or more header filtering conditions, such as the header of the person in charge contains header filtering conditions: Zhao ××, Qian ××, Sun ×× and Zhou ××. If the original a row, The data in the nth row, the fth row and the hth row, and the corresponding Chinese name filtering conditions are test 1, test 2, test 3 and test 1, and the corresponding responsible person filtering conditions are Zhao ××, Qian ××, Sun ×× and Zhou ××. At this time, the user may modify several header filtering conditions during the condition filtering process. For example, the user selects Test 1 in the Chinese name filtering condition and Zhao ×× in the responsible person filtering condition. Only the data in the ath row meets the above filtering conditions. Therefore, the secondary filtering data obtained at this time will only contain the data in the ath row. At the same time, if the current header filtering condition column is a numerical header column and a numerical interval is selected, the data falling into the numerical interval will match the filtering condition of the numerical header column. It can be understood that in this embodiment, regarding the filtering condition header of the numerical value, such as the header of the creation time (the information in each cell under the header of the creation time is a time point such as: 2021-05-20 13.56.51, 2021-05-24 10.14.24, 2021-05-24 10.15.07 and 2021-06-01 10.25.17, etc.), the user can not only select each time point as the filtering condition, but also use a time period as the filtering condition for filtering (for example, under the header of the creation time, the time period selected by the user is 2021-05-20 00.00.00 to 2021-05-2100.00.00, then the creation time is 2021-05-20 13.56.51, 2021-05-24 The data of 10.14.24 and 2021-05-2410.15.07 will match the conditions of this filtering). The table data falling into this time period are all matching objects in the header condition filtering of this creation time. In addition to time, the numerical header also includes specific values ​​such as temperature, quantity and amount.

[0096] In addition, the header filter condition column also includes a header fuzzy filter condition input box, and monitors the header fuzzy filter condition input box at the same time. When the content of the header fuzzy filter condition input box changes, the content of the current header fuzzy filter condition input box is matched with the optional header filter condition to obtain a first optional header filter condition, and the first optional header filter condition is displayed in the header filter condition column. It can be understood that when the cardinality of the data table is too large, the number of header filter conditions also increases. In the web table in this embodiment, the header filter condition column also includes a header fuzzy filter condition input box, that is, the header filter condition is fuzzily filtered. When the content in the input box changes, the content of the input box is extracted and matched with all the filter conditions to obtain a first optional header filter condition. The user then selects the filter condition based on the first optional header filter condition.

[0097] It is understandable that, for the convenience of explanation, only a small number of examples are selected for description in the fuzzy screening and header screening in this embodiment. In actual applications, the object data to be screened is very large, especially when the user only remembers some keywords and there are no screening conditions related to the keywords. Single header screening will consume a lot of user time and is far from meeting the user's screening needs. This embodiment implements the above-mentioned screening function without the need to develop complex and large back-end screening interfaces. All data is directly classified, matched and screened on the front-end web page, meeting the user's needs for fuzzy screening and screening with multiple styles of conditions, improving the user-friendliness of web forms in different screening scenarios, and saving user time.

[0098] Step S70, displaying the secondary screening data in the table of the current web page, and synchronously monitoring the fuzzy screening input box and the table header screening condition column.

[0099] The secondary filtered data obtained at this time is the data that meets the user's filtering conditions. At the same time, the characters in the secondary filtered data that are the same as the content of the current fuzzy filter input box are highlighted in the web page table. In addition, the header of the table with changed filtering conditions is placed in front of the web table, and the table data that matches the content of the current fuzzy filter input box is placed in front of the web table (for example, in the above example, if the content of the current fuzzy filter input box is ng, all ng in the web table displaying the second filtered data will be highlighted with other color marks, such as yellowing the ng field in string. Moreover, if a row of table data contains more ng, the row of data will be placed in the front position of the current web page table. Similarly, the header of the table with changed filtering conditions is placed in the front position of the current web page table, and the header of the table with unchanged filtering conditions is placed at the back of the table). At the same time, continue to monitor the fuzzy filter input box and the header filter condition bar, so that the user can respond immediately when querying the filter again.

[0100] In this embodiment, the front end will obtain all the table data of the back end, and classify, match and filter the obtained table data, without the need to develop complex and large number of back-end filtering interfaces on the back end, thereby conveniently realizing the function of global fuzzy filtering in web table data. At the same time, by setting fuzzy filtering for the header filtering conditions and filtering multiple conditions at the same time, the multi-style header condition filtering function is realized, meeting the user's personalized query needs when querying web tables, improving user query efficiency, making web table data query more user-friendly in different filtering scenarios, and improving user experience.

[0101] Further, see Figure 3 The second embodiment of the web form screening method of the present invention based on the first embodiment, after step S30, includes:

[0102] Step S400, if fuzzy filtering is not triggered, the content of the current header filtering condition column is matched with the full table data to obtain primary filtering data;

[0103] When the content of the fuzzy filter input box does not change, the fuzzy filter will not be triggered. It can be understood that the condition for triggering the above-mentioned filter function is: when the content of the fuzzy filter input box or the filter condition selected in the header filter condition column changes, the filter function is triggered. Therefore, under the condition of triggering the filter function, if the fuzzy filter is not triggered, the filter condition selected in the default header filter condition column changes, that is, the header filter is triggered. According to the filter condition selected in the current header filter condition column, the full table data is matched, and the header with the changed filter condition can be one or more. When it comes to the header filter related to the value, the filter condition can be a single value point or a value range. The table data in the full table data that meets the filter condition selected in the current header filter condition column is sorted to obtain a filter data. Similarly, when there are too many filter conditions, the relevant keywords of the filter condition can be entered in the header fuzzy filter condition input box corresponding to the header, and the header filter condition where the keyword appears under the corresponding header is searched according to the input keyword, and the header filter condition related to the keyword is displayed in the header filter column for the user to choose. This avoids users spending too much time looking for filter conditions.

[0104] Step S401, displaying the filtered data once in the table of the current web page, and synchronously monitoring the fuzzy filtering input box and the table header filtering condition column.

[0105] Understandably, if the user only performs conditional filtering, the filtered data will be displayed on the current web page after the conditional filtering. Similarly, the table header of the filter condition change will be placed in the front position in the page table, so that the user can obtain the filter conditions at the first time, speed up the filtering speed, and save time. At the same time, the fuzzy filter input box and the table header filter condition bar will continue to be monitored, so that the user can respond immediately when querying and filtering again.

[0106] In this embodiment, the user only performs conditional filtering, and uses a variety of filtering condition styles such as: selecting a numerical range and fuzzy filtering conditions, etc., to adapt to the filtering needs in different scenarios, speed up the filtering speed, and improve the user's web table data filtering experience.

[0107] Further, see Figure 4 The third embodiment of the web form screening method of the present invention based on the first embodiment, after step S50, includes:

[0108] Step S600, if the header filter is not triggered, the filtered data is displayed on the current web page, and the data in the current web page table that is the same as the content of the current fuzzy filter input box is highlighted, and the fuzzy filter input box and the header filter condition bar are monitored synchronously.

[0109] If the user only enters a keyword in the fuzzy filter input box, the header filter will not be triggered. In this case, the filtered data after fuzzy filtering will be displayed directly on the current web page, and the data with the same keyword as the input box will be highlighted in the web page table.

[0110] In addition, to achieve the above-mentioned purpose, the present invention also provides a terminal device, which includes: a memory, a processor, and a web form filtering program stored in the memory and executable on the processor, and the web form filtering program implements the steps of the web form filtering method as described above when executed by the processor.

[0111] In addition, to achieve the above object, the present invention further provides a computer-readable storage medium, on which a web form screening program is stored, and when the web form screening program is executed by a processor, the steps of the web form screening method as described above are implemented.

[0112] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or system including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or system. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or system including the element.

[0113] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0114] 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 a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention is essentially 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) as described above, and includes a number of instructions for 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 invention.

[0115] The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A web table screening method, characterized in that: The web form screening method includes the following contents: Get the full table data from the backend, and classify the full table data to obtain optional header filtering conditions; Displaying the full table data in the current web page table, the web page table further comprising: a fuzzy filter input box and a header filter condition column, and displaying the optional header filter condition in the header filter condition column; When the content of the fuzzy filter input box or the filter condition selected in the header filter condition column changes, the filter function is triggered; Determine whether to trigger fuzzy filtering; If fuzzy filtering is triggered, the content of the current fuzzy filtering input box is matched with the full data table to obtain the filtered data; Determine whether to trigger header filtering; If the header filter is triggered, the filter condition selected in the current header filter condition column is matched with the fuzzy filter data to obtain the secondary filter data; The secondary filtering data is displayed in the table of the current web page, and the fuzzy filtering input box and the table header filtering condition column are monitored synchronously.

2. The web form screening method according to claim 1, characterized in that: The optional header screening conditions obtained by classifying the entire table data include: Get the data of each column in the entire table data as the optional header filtering condition of the corresponding column header; Among them, the optional header filtering conditions are first-level and above filtering conditions, and are displayed in the header filtering condition column of the corresponding column.

3. The web form screening method according to claim 2, characterized in that: The matching of the filter condition selected in the filter condition column of the current table header with the fuzzy filter data includes: If the current header filter condition column is a numerical header column and a numerical range is selected, then all data falling within the numerical range matches the filter condition selected for the numerical header column.

4. The web form screening method according to claim 3, characterized in that: The secondary screening data is displayed in the table of the current web page including: The characters in the secondary filtering data that are identical to the contents of the current fuzzy filtering input box are highlighted in the web page table, and the table headers with changed filtering conditions are placed in front of the web table, and the table data that matches the contents of the current fuzzy filtering input box is placed in front of the web table.

5. The web form screening method according to claim 4, characterized in that: The table header filtering condition column also includes a table header fuzzy filtering condition input box, and the table header fuzzy filtering condition input box is monitored at the same time.

6. The web form screening method according to claim 5, characterized in that: The monitoring of the header fuzzy screening condition input box includes: When the content of the header fuzzy filtering condition input box changes, the content of the current header fuzzy filtering condition input box is matched with the optional header filtering condition to obtain an optional header filtering condition; The optional header filtering condition is displayed in the header filtering condition column.

7. The web form screening method according to claim 6, characterized in that: After the step of determining whether fuzzy screening is triggered, the following steps are included: If the fuzzy filter is not triggered, the content of the current header filter condition column is matched with the full table data to obtain the filtered data; The filtered data is displayed once in the table of the current web page, and the fuzzy filter input box and the table header filter condition column are monitored synchronously.

8. The web form screening method according to claim 6, characterized in that: After the step of determining whether to trigger header screening, the following steps are included: If the header filter is not triggered, the first-filtered data will be displayed on the current web page, and the characters in the first-filtered data that are identical to the content of the current fuzzy filter input box will be highlighted, and the fuzzy filter input box and the header filter condition bar will be monitored synchronously.

9. A terminal device, characterized in that: The terminal device comprises: a memory, a processor, and a web form screening program stored in the memory and executable on the processor, wherein the web form screening program implements the steps of the web form screening method according to any one of claims 1 to 8 when executed by the processor.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a web form screening program, and when the web form screening program is executed by a processor, the steps of the web form screening method according to any one of claims 1 to 8 are implemented.

Images