CN108763442B

CN108763442B - Workbook filtering method and device, computer equipment and storage medium

Info

Publication number: CN108763442B
Application number: CN201810514821.5A
Authority: CN
Inventors: 陈宝花
Original assignee: Ping An Technology Shenzhen Co Ltd
Current assignee: Ping An Technology Shenzhen Co Ltd
Priority date: 2018-05-25
Filing date: 2018-05-25
Publication date: 2020-03-31
Anticipated expiration: 2038-05-25
Also published as: CN108763442A; WO2019223135A1

Abstract

The invention discloses a method and a device for filtering a workbook, computer equipment and a storage medium. The method comprises the following steps: acquiring the mechanism grade and keywords of the current user; acquiring configuration information of a workbook, and verifying the organization grade of a user according to the configuration information of the workbook to obtain a verification result; matching the filtering schemes contained in the scheme library according to the verification result and the keywords to obtain the matching probability of the filtering schemes; and filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result. By calculating the matching probability of a plurality of filtering schemes provided in the scheme library and filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result, the problem of inaccuracy caused by directly filtering the keyword content input by the user can be avoided.

Description

Workbook filtering method and device, computer equipment and storage medium

Technical Field

The invention relates to the technical field of workbooks, in particular to a workbook filtering method and device, computer equipment and a storage medium.

Background

In the daily work process, when the report data in the workbook is filtered, the report data needs to be filtered by setting a filtering field, so as to obtain target data. For large enterprises, employees are divided into different levels for the convenience of managing the employees of the enterprises, and different authorities are set for the employees of the different levels to use the report forms. However, when data in a report is filtered, in the method in the prior art, a user needs to set a keyword and filter report data in a workbook in combination with user authority, however, when the report data is filtered in combination with the user authority and the keyword, the problem of inaccurate filtering often exists, so that a large difference exists between the finally filtered data and target data expected by the user, and the actually filtered data is difficult to meet the use requirements of the user.

Disclosure of Invention

The embodiment of the invention provides a method and a device for filtering a workbook, computer equipment and a storage medium, and aims to solve the problem that filtering is inaccurate when user rights and keywords are combined to filter report data in the prior art.

In a first aspect, an embodiment of the present invention provides a method for filtering a workbook, including:

acquiring the mechanism grade of a current user and keywords input by the user;

acquiring configuration information of a workbook, and verifying the organization grade of the current user according to the configuration information of the workbook to obtain a verification result;

matching the filtering schemes contained in a scheme library according to the verification result and the keywords to obtain the matching probability of the filtering schemes;

and filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

In a second aspect, an embodiment of the present invention provides a workbook filtering device, including:

the information acquisition unit is used for acquiring the mechanism grade of the current user and the keywords input by the user;

the mechanism level verification unit is used for acquiring configuration information of a workbook and verifying the mechanism level of the current user according to the configuration information of the workbook to obtain a verification result;

the matching unit is used for matching the filtering schemes contained in the scheme library according to the verification result and the keywords so as to obtain the matching probability of the filtering schemes;

and the filtering unit is used for filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and the processor implements the workbook filtering method according to the first aspect when executing the computer program.

In a fourth aspect, an embodiment of the present invention further provides a storage medium, where the storage medium stores a computer program, and the computer program includes program instructions, and when the program instructions are executed by a processor, the processor is caused to execute the workbook filtering method according to the first aspect.

The embodiment of the invention provides a method and a device for filtering a workbook, computer equipment and a storage medium. According to the method, the matching probability calculation is carried out on the multiple filtering schemes provided in the scheme library, and the filtering scheme with the highest matching probability is selected as the optimal filtering scheme, so that the problem of inaccuracy caused by directly filtering the keyword content input by the user can be avoided. And matching to obtain the most preferable filtering scheme by combining the result of verifying the mechanism grade of the user and the analysis result of the input keywords, so that the finally screened data meets the requirements of the user.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

FIG. 1 is a schematic flow chart illustrating a method for filtering a workbook according to an embodiment of the present invention;

FIG. 2 is a schematic sub-flow diagram of a workbook filtering method according to an embodiment of the invention;

FIG. 3 is a schematic view of another sub-flow of a workbook filtering method according to an embodiment of the invention;

FIG. 4 is a schematic view of another sub-flow of a workbook filtering method according to an embodiment of the invention;

FIG. 5 is a schematic flow chart illustrating a workbook filtering method according to an embodiment of the invention;

FIG. 6 is a schematic block diagram of a workbook filter arrangement provided by an embodiment of the invention;

FIG. 7 is a schematic block diagram of a sub-unit of a workbook filtering apparatus provided in an embodiment of the present invention;

FIG. 8 is a schematic block diagram of another sub-unit of a workbook filtering device provided in an embodiment of the present invention;

FIG. 9 is a schematic block diagram of another sub-unit of a workbook filtering device provided in accordance with an embodiment of the present invention;

FIG. 10 is another schematic block diagram of a workbook filter arrangement provided by an embodiment of the invention;

FIG. 11 is a schematic block diagram of a computer device provided by an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

Referring to fig. 1, fig. 1 is a schematic flow chart of a workbook filtering method according to an embodiment of the present invention, where the method is applied to a terminal such as a desktop computer, a laptop computer, and a tablet computer. As shown in fig. 1, the method includes steps S101 to S104.

S101, acquiring the mechanism level of the current user and keywords input by the user.

After the user logs in the report data query system, the system acquires the mechanism grade of the current user. When the login account of each user is created, the mechanism code of the user in the report data query system is determined according to the mechanism where the login account of the user is located, and the mechanism where the login account of the user is located is bound with the login account of the user. And determining the mechanism grade of the user by analyzing the mechanism code of the user, and storing the mechanism grade of the user into a database of the report data query system.

For example, the login account of the user belongs to the organization of the software development department, and the organization code of the software development department is queried to be 201 in the report data query system, so that the organization level of the user is 2 by analyzing the organization code of the user. The keywords are information input by the user in the system, wherein the keywords are limited contents of report data required by the user, and the keywords can be Chinese, English or other languages.

S102, obtaining configuration information of a workbook, and verifying the mechanism level of the current user according to the configuration information of the workbook to obtain a verification result.

The configuration information of the workbook comprises authority configuration information and filtering field configuration information. After configuring the authority configuration information and the filtering field configuration information of the report in the workbook, the report data query system can obtain the authority configuration information and the filtering field configuration information of each report belonging to the workbook by obtaining the configuration information of the workbook.

In one embodiment, as shown in fig. 2, step S102 includes sub-steps S1021 and S1022.

And S1021, acquiring the authority configuration information and the filtering field configuration information of the workbook.

One or more reports are contained in one workbook, unified authority configuration management and filtering field configuration management can be carried out on the reports belonging to the workbook through the workbook, and when the number of the reports contained in the workbook is large, a user can conveniently manage the authority and the filtering field of the reports.

And the authority configuration information is information for configuring the access authority of the workbook, and when the user filters the report data in the workbook, the report data matched with the access authority of the user is displayed according to the access authority in the authority configuration information corresponding to the authority level of the user. The filtering field configuration information is the field that needs to be filtered when the report data is filtered. And each filtering field in the filtering field configuration information is matched with the corresponding mechanism grade in the authority configuration information.

For example, the rights configuration information of the workbook is shown in Table 1.

The workbook ID:	2021
		the name of the workbook:	XXXX
and (3) expanding information:	is that
		The upper limit of the mechanism:	2
lower limit of mechanism:	4

TABLE 1

The right configuration information of the workbook includes: extended information, an upper organizational limit, and a lower organizational limit. Wherein, the organization upper limit and the organization lower limit jointly form organization grade information in the authority configuration information.

When the organization level of a user is higher than the organization upper limit in the workbook authority configuration information, the authority of the report in the workbook is not filtered, and the organization upper limit can be set to be any authority level in 1-5; the lower limit of the organization is the lower limit of authority when the authority filtering is carried out on the report, when the level of the user is lower than the lower limit of the organization in the authority configuration information of the workbook, the user cannot view the report in the workbook, and the lower limit of the organization can be set to be any authority level in 1-5. The extension information is whether to extend the mechanism lower limit in the workbook authority configuration information, and when the extension information in the workbook authority configuration information is yes, the set mechanism lower limit is extended downwards to the lowest level in the mechanism levels; and when the extension information in the workbook authority configuration information is negative, not extending the lower limit of the mechanism.

For example, if the extension information is yes when the lower mechanism limit is set to 3, the set lower mechanism limit is extended to the lowest level 5 of the mechanism levels, and if the authority level of the user is 4 or 5, the authority filtering process is automatically performed on the report data according to the authority level of 3.

For example, the filter field configuration information for a workbook is shown in Table 2.

TABLE 2

Wherein, the filtering field configuration information comprises: a Tableau field, i.e., a filter field name corresponding to an organization level, and an organization level. For example, when the organization level of the user is 2, if the organization code of the user is automatically acquired as 201, the configured filter field is "201" in terms of destination _ code _ 012.

S1022, the mechanism level of the current user is verified through the mechanism level information and the extension information in the authority configuration information to obtain a verification result.

The report data query system obtains the organization grade of the user by obtaining, and verifies the organization grade of the user by combining the organization grade and the extension information in the authority configuration information of the workbook to obtain a verification result, wherein the verification result comprises the following four conditions.

1) And if the mechanism level of the current user is higher than the mechanism upper limit, the verification result comprises that the authority filtering is not performed on the report data in the workbook, the system does not perform the authority filtering on the report data in the workbook in the subsequent execution process, and the filtering field is not effective.

2) If the mechanism level of the current user is below the lower limit of the mechanism and the extension information is negative, the mechanism level of the user is verified according to the extension information, the current user cannot check the report, and the verification result does not carry out authority filtering on the report data in the workbook.

3) If the mechanism level of the current user is below the lower limit of the mechanism and the extension information is yes, the verification result comprises the permission filtering of the report data in the workbook, and the permission filtering of the report data is carried out according to the filtering field corresponding to the lower limit of the mechanism in the permission configuration information.

4) If the mechanism level of the current user is between the upper mechanism limit and the lower mechanism limit, the verification result comprises the authority filtering of the report data in the workbook, and the authority filtering of the report data needs to be carried out according to the filtering field corresponding to the mechanism level of the user.

For example, if the configuration information of the workbook has an upper mechanism limit of 2, a lower mechanism limit of 4, and no extension information, the following three cases occur. a. And if the organization grade of the user is 1, the organization grade of the user is higher than the organization upper limit 2, and the authority filtering of the report data is not performed. b. And if the organization grade of the user is 5, if the organization grade of the user is lower than the lower limit of the organization 4, the authority of the report data is filtered, and the report data inquiry system sends information of 'no authority to view the report' to prompt the user. c. And if the organization grade of the user is 3, filtering the authority of the report data according to the organization grade of the user.

S103, matching the filtering schemes contained in the scheme library according to the verification result and the keywords to obtain the matching probability of the filtering schemes.

In a specific implementation mode, matching is carried out on the scheme library according to the verification result and the keywords input by the user, so that the matching probability of each filtering scheme in the scheme library is obtained. The scheme library comprises a plurality of filtering schemes for filtering the report data, each filtering scheme comprises corresponding date information and characteristic words, and the characteristic words of the filtering schemes can be one or more.

In an embodiment, as shown in fig. 3, step S103 includes sub-steps S1031, S1032 and S1033.

And S1031, performing word segmentation on the keywords and extracting characteristic information to obtain the characteristic information of the keywords.

The method comprises the steps of analyzing keywords input by a user to obtain an analysis result, and specifically analyzing the keywords by word segmentation and feature information extraction. By segmenting the keywords input by the user and extracting the feature information, the analysis result is the feature information of the input keywords. The characteristic information includes, but is not limited to, year information, month information, day information, filtering categories, and name information. Wherein, the year information, the month information and the day information are date information in the characteristic information. And filtering the category and the name information into characteristic words in the matching information.

And if the keyword input by the user contains date information, verifying the date information in the keyword. If the date information input by the user is effective date information, extracting corresponding characteristic information; and if the date information extracted by the user is invalid date information, sending prompt information to the user to prompt the user that the input date information is invalid.

And if the keywords input by the user contain name information, filtering the responsible persons in the report data through the name information to obtain the report data provided by the related persons.

The filtering type is filtering type information for filtering the report data in the workbook, and the target data required by the user can be quickly obtained by filtering the report data in the workbook through the filtering type. The system comprises report data provided by a plurality of responsible persons, the report data in the workbook is filtered by acquiring name information contained in keywords input by a user, and the report data provided by the corresponding responsible persons can be obtained by rapid filtering.

And verifying whether the date information input by the user is valid or not by acquiring the date information in the keyword input by the user and verifying whether the date information input by the user does not exceed the current date and time. Specifically, the current date may be returned by TODAY (): TODAY () "2/23/2018"; return the current date and time by NOW (): NOW () "2/23/201811: 02:21 AM". For example, the current time, date and time are "2018-02-20, 15: 00", and when the date information input by the user is "5 months in 2018", the date information input by the user exceeds the current date and time, the date information input by the user is verified to be invalid, and prompt information is sent out for the user; and when the date information input by the user is '5 months in 2017', the date information input by the user does not exceed the current date and time, the date information input by the user is verified to be valid, and the feature information of the keywords input by the user is further extracted.

For example, if the keyword input by the user is "life insurance information in month 2 in 2017", the keyword input by the user is segmented to obtain "life insurance" in month 2 in 2017, and "life insurance" and "information". By performing feature extraction on the word result, wherein "2017 years" is the year information, the year of a given date is returned in integer form by year (date): YEAR (# February, 2017#) ═ 2017; "month 2" is month information, which returns the month of a given date in integer form by MONTH (date): MONTH (# February, 2017#) -2, "life risk" is a specific filtering category, and the corresponding characteristic information includes year information: in 2017, monthly information: month 2, filtering category: life insurance.

Wherein, the day information is returned to the day of the given date in integer form by day (date), for example: DAY (# april12,2005#) -12.

S1032, determining matching information according to the verification result and the feature information of the keyword.

And determining matching information according to a verification result of verifying the mechanism level of the user and the characteristic information of the input keyword. Wherein the authentication information has a higher priority than the feature information of the keyword.

After the organization grade of the user is verified, a verification result can be obtained, and the verification result comprises information whether authority filtering is performed on report data or not. If the authority filtering of the report data is not included in the verification result, the authority filtering processing of the report data is not carried out; and if the verification result contains the authority filtering of the report data, acquiring the authority level of the current user, and performing the authority filtering of the report data according to the filtering field configured by the filtering field configuration information of the workbook.

In an embodiment, as shown in FIG. 4, step S1032 includes substeps S10321 and S10322.

In the specific execution process, it is necessary to first judge whether the verification result includes the filtering of the authority of the report data, and execute the subsequent steps according to the judgment result.

S10321, if the verification result does not contain report data authority filtering, the characteristic information of the keyword is used as matching information.

If the verification result does not contain the authority filtering of the report data, the authority level of the current user is higher than the mechanism upper limit in the authority configuration information of the workbook, and the user has the authority of accessing all report data in the current workbook. And taking the characteristic information of the keywords as matching information.

And S10322, if the verification result includes report data authority filtering, taking the intersection of the limited range corresponding to the current user mechanism level and the characteristic information as matching information.

If the verification result includes the authority filtering of the report data, the authority level of the current user is lower than the mechanism upper limit in the authority configuration information of the workbook, and the user can only access part of the report data in the workbook. And taking the intersection of the limited range corresponding to the current user mechanism level and the feature information of the keywords as matching information.

For example, the verification result includes that report data authority filtering is performed, the authority level of the user is 4, the keyword input by the user is "life insurance information from 2015 to now", and feature information of the keyword obtained by performing feature extraction on the keyword input by the user is year information: greater than 2015, filtration type: life insurance. Then obtaining a limited range corresponding to the current user mechanism level according to the 4-level mechanism to which the user belongs, wherein the specific operation steps are as follows: the year information is greater than 2016 years. Then the intersection of the limited range corresponding to the current user mechanism level and the feature information of the keyword is: the year information is more than 2016 and the filtering type life insurance is used as the matching information to match the filtering scheme.

S1033, matching the filtering schemes contained in the scheme library through the matching information to obtain the matching probability of the filtering schemes.

The scheme library comprises a plurality of filtering schemes for filtering the report data, each filtering scheme comprises corresponding date information and characteristic words, and the characteristic words of the filtering schemes can be one or more. The filtering schemes in the scheme library can be matched through the obtained matching information, and the matching probability between each filtering scheme and the matching information is obtained.

In one embodiment, as shown in FIG. 5, step S1033 includes substeps S10331 and S10332.

S10331, sequentially obtaining the filtering schemes in the scheme library, obtaining the coincidence degree of the date information in the matching information and the date information in the filtering schemes, and obtaining the coincidence degree of the feature words in the matching information and the corresponding feature words in the filtering schemes.

Before calculating the matching probability of the filtering scheme, the filtering schemes in the scheme library are sequentially acquired, the coincidence degree of date information in the matching information and date information in the filtering scheme and the coincidence degree of feature words in the matching information and corresponding feature words in the filtering scheme are acquired.

Wherein, the coincidence ratio a of the date information in the matching information and the date information in the filtering scheme is obtained through the formula a ═ 1- (a0-a1)/(a1-X), a0 is the date information in the matching information, a1 is the date information in the filtering scheme, and X is the starting time preset in the system. For example, when a0 is 2017, 6, a1 is 2017, 4 and X is 2010, 1, the overlap ratio a of the date information in the matching information and the date information in the filtering scheme is 97.70% through formula calculation. When a0 is less than a1, a is 0. For example, when a0 is year 2017, month 2 and a1 is year 2017, month 4, then a is 0.

And obtaining the coincidence degree Cn of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme by a formula Cn which is B/D, wherein B is the number of coincident words between the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme, and D is the total number of words of the corresponding characteristic word in the filtering scheme.

For example, if the nth feature word in the matching information is "insurance", and the feature word in the filtering scheme corresponding to the nth feature word in the matching information is "life risk", Cn — 1/2 — 50%.

Step S10332 of calculating a matching probability P of the current filtering scheme according to a formula P ═ a + C1+ C2+ C3+ … … + Cn)/(n +1), where a is a coincidence degree of date information in the matching information and date information in the filtering scheme; and Cn is the contact ratio of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme.

By the formula P ═ a + C1+ C2+ C3+ … … + Cn)/(n +1), the date information in the matching information and the matching probability of the plurality of feature words therein to the filtering scheme are calculated.

For example, as a result of verifying the organization level of the user, the authority of the data is filtered, the authority level of the user is 4, and the keyword input by the user is "life insurance information of 2015, the feature information of the keyword obtained by extracting the features of the keyword input by the user is year information: greater than 2015, filtration type: life insurance. And performing authority filtering on the data according to the 4-level mechanism to which the user belongs and according to the priority _ code _03 ═ 20101', wherein authority filtering is limited to: the year information is greater than 2016 years. The intersection of the definition of the user mechanism level and the feature information of the keyword is: the year information is more than 2016 and the filtering type life insurance is used as the matching information to match the filtering scheme.

The feature fields of filtering scheme 1 are: the year information is greater than 2015 years, insurance, the year information is the same as the matching information, and "insurance" is only 50% of the matching information, so that the matching probability of the filtering scheme 1 is (1+0.5)/2 is 75%, and the characteristic field of the filtering scheme 2 is: if the year information is greater than 2015, the person life risk is equal to the year information and the matching information, and the "person life risk" is only 66% equal to the matching information, the matching probability of the filtering scheme 2 is (1+0.66)/2, which is 83%.

In this embodiment, by matching the plurality of filtering schemes in the scheme library with the matching information, the matching probability of the filtering schemes is obtained, and the optimal filtering scheme is selected, so that the problem of inaccuracy caused by directly filtering the keyword content input by the user can be avoided.

And S104, filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

The system automatically selects the filtering scheme with the highest matching probability, filters the report data through the filtering scheme with the highest matching probability, and displays the filtered data result.

For example, if the matching probability of the filtering scheme 1 is 75% and the matching probability of the filtering scheme 2 is 83%, the filtering scheme 2 is automatically selected as the preferred filtering scheme, and the report data is filtered through the filtering scheme 2, that is, the report data is filtered through the characteristic fields containing the year information of 2015 or the life insurance of people, so as to obtain the final data result, and the final data result is displayed.

In this embodiment, by performing matching probability calculation on a plurality of filtering schemes provided in the scheme library and selecting the filtering scheme with the highest matching probability as the optimal filtering scheme, the problem of inaccuracy caused by directly filtering the keyword content input by the user can be avoided. And matching to obtain the most preferable filtering scheme by combining the result of verifying the mechanism grade of the user and the analysis result of the input keywords, so that the finally screened data meets the requirements of the user.

Embodiments of the present invention further provide a workbook filtering device, where the workbook filtering device is configured to execute any one of the embodiments of the workbook filtering method. Specifically, referring to fig. 6, fig. 6 is a schematic block diagram of a workbook filtering device according to an embodiment of the invention. The workbook filter device 100 may be configured in a desktop computer, a tablet computer, a laptop computer, etc.

As shown in fig. 6, the workbook filtering device 100 includes an information acquiring unit 101, an organization level verifying unit 102, a matching unit 103, and a filtering unit 104.

An information obtaining unit 101 is configured to obtain the mechanism level of the current user and the keyword input by the user.

For example, the login account of the user belongs to the organization of the software development department, and the organization code of the software development department is queried to be 201 in the report data query system, so that the organization level of the user is 2 by analyzing the organization code of the user.

The keywords are information input by the user in the system, wherein the keywords are limited contents of report data required by the user, and the keywords can be Chinese, English or other languages.

And the mechanism level verification unit 102 is configured to obtain configuration information of the workbook, and verify the mechanism level of the current user according to the configuration information of the workbook to obtain a verification result.

The working book in the system comprises one or more reports, and the one or more reports in the working book share the configuration information of the working book, wherein the configuration information of the working board comprises authority configuration information and filtering field configuration information. After configuring the authority configuration information and the filtering field configuration information of the report in the workbook, the report data query system can obtain the authority configuration information and the filtering field configuration information of each report belonging to the workbook by obtaining the configuration information of the workbook.

In other embodiments of the invention, as shown in fig. 7, the institution level verification unit 102 includes sub-units: a configuration information acquisition unit 1021, and a verification result acquisition unit 1022.

A configuration information obtaining unit 1021, configured to obtain the authority configuration information and the filter field configuration information of the workbook.

And the authority configuration information is information for configuring the access authority of the workbook, and when the user filters the report data in the workbook, the report data matched with the access authority of the user is displayed according to the access authority in the authority configuration information corresponding to the authority level of the user.

The filtering field configuration information is the field that needs to be filtered when the report data is filtered. And each filtering field in the filtering field configuration information is matched with the corresponding mechanism grade in the authority configuration information.

A verification result obtaining unit 1022, configured to verify the organization level of the current user through the organization level information and the extension information in the authority configuration information to obtain a verification result.

A matching unit 103, configured to match the filtering schemes included in the scheme library according to the verification result and the keyword to obtain matching probabilities of the filtering schemes.

In other embodiments of the present invention, as shown in fig. 8, the matching unit 103 includes sub-units: a feature extraction unit 1031, a matching information integration unit 1032, and a matching probability calculation unit 1033.

A feature extraction unit 1031, configured to perform word segmentation on the keyword and extract feature information to obtain feature information of the keyword.

The method comprises the steps of analyzing keywords input by a user to obtain an analysis result, and specifically analyzing the keywords by word segmentation and feature information extraction. By segmenting the keywords input by the user and extracting the feature information, the analysis result is the feature information of the input keywords. The characteristic information includes, but is not limited to, year information, month information, day information, filtering categories, and name information.

And a matching information integration unit 1032, configured to determine matching information according to the verification result and the feature information of the keyword.

And integrating to obtain matching information according to a verification result of verifying the mechanism level of the user and the characteristic information of the input keywords. Wherein the authentication information has a higher priority than the feature information of the keyword.

In other embodiments of the present invention, as shown in fig. 9, the matching information integrating unit 1032 includes a sub-unit: a matching information acquisition unit 10321 and an intersection calculation unit 10322.

A matching information obtaining unit 10321, configured to, if the verification result does not include report data authority filtering, use the feature information of the keyword as matching information.

And the intersection calculation unit 10322 is configured to, if the verification result includes performing report data authority filtering, use an intersection between the limited range corresponding to the current user mechanism level and the feature information as matching information.

A matching probability calculation unit 1033 configured to match the filtering schemes included in the scheme library with the matching information to obtain matching probabilities of the filtering schemes.

In other embodiments of the present invention, as shown in fig. 10, the matching probability calculating unit 1033 includes sub-units: a filtering scheme acquisition unit 10331 and a calculation unit 10332.

The filtering scheme obtaining unit 10331 is configured to sequentially obtain the filtering schemes in the scheme library, obtain the overlap ratio between the date information in the matching information and the date information in the filtering scheme, and obtain the overlap ratio between the feature words in the matching information and the corresponding feature words in the filtering scheme.

A calculating unit 10332, configured to calculate a matching probability P of the current filtering scheme according to a formula P ═ a + C1+ C2+ C3+ … … + Cn)/(n +1), where a is a coincidence degree of date information in the matching information and date information in the filtering scheme; and Cn is the contact ratio of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme.

And the filtering unit 104 is used for filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

The above-described workbook filtering apparatus may be implemented in the form of a computer program that may be run on a computer device such as that shown in FIG. 11.

Referring to fig. 11, fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present invention. The computer device 500 device may be a terminal. The terminal can be an electronic device such as a tablet computer, a notebook computer, a desktop computer, a personal digital assistant and the like.

Referring to fig. 11, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.

The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer programs 5032 include program instructions that, when executed, cause the processor 502 to perform a workbook filtering method.

The processor 502 is used to provide computing and control capabilities that support the operation of the overall computer device 500.

The internal memory 504 provides an environment for the execution of the computer program 5032 on the non-volatile storage medium 503, and when the computer program 5032 is executed by the processor 502, the processor 502 is caused to execute the workbook filtering method.

The network interface 505 is used for network communication such as sending assigned tasks and the like. Those skilled in the art will appreciate that the configuration shown in fig. 11 is a block diagram of only a portion of the configuration associated with aspects of the present invention and is not intended to limit the computing device 500 to which aspects of the present invention may be applied, and that a particular computing device 500 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

Wherein the processor 502 is configured to run the computer program 5032 stored in the memory to implement the following functions: acquiring the mechanism grade of a current user and keywords input by the user; acquiring configuration information of a workbook, and verifying the organization grade of the current user according to the configuration information of the workbook to obtain a verification result; matching the filtering schemes contained in a scheme library according to the verification result and the keywords to obtain the matching probability of the filtering schemes; and filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

In one embodiment, the processor 502 performs the following operations when obtaining the configuration information of the workbook and verifying the organization level of the current user according to the configuration information of the workbook to obtain a verification result: acquiring authority configuration information and filtering field configuration information of the workbook; and verifying the mechanism level of the current user through the mechanism level information and the extension information in the authority configuration information to obtain a verification result.

In an embodiment, when performing matching of the filtering schemes included in the scheme library according to the verification result and the keyword to obtain a matching probability of the filtering scheme, the processor 502 performs the following operations: performing word segmentation on the keywords and extracting characteristic information to obtain the characteristic information of the keywords; determining matching information according to the verification result and the feature information of the keyword; and matching the filtering schemes contained in the scheme library through the matching information to obtain the matching probability of the filtering schemes.

In an embodiment, the processor 502, when performing the determining the matching information according to the verification result and the feature information of the keyword, performs the following operations: if the verification result does not contain report data authority filtering, the characteristic information of the keywords is used as matching information; and if the verification result comprises report data authority filtering, taking the intersection of the limiting range corresponding to the current user mechanism level and the characteristic information as matching information.

In an embodiment, when performing matching of the filtering schemes included in the scheme library by the matching information to obtain the matching probability of the filtering scheme, the processor 502 performs the following operations: sequentially acquiring the filtering schemes in the scheme library, acquiring the coincidence degree of date information in the matching information and date information in the filtering schemes, and the coincidence degree of feature words in the matching information and corresponding feature words in the filtering schemes; calculating the matching probability P of the current filtering scheme by a formula P of (A + C1+ C2+ C3+ … … + Cn)/(n +1), wherein A is the coincidence degree of the date information in the matching information and the date information in the filtering scheme; and Cn is the contact ratio of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme.

Those skilled in the art will appreciate that the embodiment of a computer device illustrated in fig. 11 does not constitute a limitation on the specific construction of the computer device, and that in other embodiments a computer device may include more or fewer components than those illustrated, or some components may be combined, or a different arrangement of components. For example, in some embodiments, the computer device may only include a memory and a processor, and in such embodiments, the structures and functions of the memory and the processor are consistent with those of the embodiment shown in fig. 11, and are not described herein again.

It should be understood that, in the embodiment of the present invention, the Processor 502 may be a Central Processing Unit (CPU), and the Processor 502 may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

In another embodiment of the present invention, a storage medium is provided. The storage medium may be a non-volatile computer-readable storage medium. The storage medium stores a computer program, wherein the computer program comprises program instructions. The program instructions when executed by the processor implement the steps of: acquiring the mechanism grade of a current user and keywords input by the user; acquiring configuration information of a workbook, and verifying the organization grade of the current user according to the configuration information of the workbook to obtain a verification result; matching the filtering schemes contained in a scheme library according to the verification result and the keywords to obtain the matching probability of the filtering schemes; and filtering the workbook data through the filtering scheme with the highest matching probability to obtain a data result.

In an embodiment, the step of obtaining configuration information of a workbook and verifying the organization level of the current user according to the configuration information of the workbook to obtain a verification result includes: acquiring authority configuration information and filtering field configuration information of the workbook; and verifying the mechanism level of the current user through the mechanism level information and the extension information in the authority configuration information to obtain a verification result.

In an embodiment, the step of matching the filtering schemes included in the scheme library according to the verification result and the keyword to obtain the matching probability of the filtering schemes includes: performing word segmentation on the keywords and extracting characteristic information to obtain the characteristic information of the keywords; determining matching information according to the verification result and the feature information of the keyword; and matching the filtering schemes contained in the scheme library through the matching information to obtain the matching probability of the filtering schemes.

In an embodiment, the step of determining matching information according to the verification result and the feature information of the keyword includes: if the verification result does not contain report data authority filtering, the characteristic information of the keywords is used as matching information; and if the verification result comprises report data authority filtering, taking the intersection of the limiting range corresponding to the current user mechanism level and the characteristic information as matching information.

In an embodiment, the step of matching the filtering schemes included in the scheme library by the matching information to obtain the matching probability of the filtering scheme includes: sequentially acquiring the filtering schemes in the scheme library, acquiring the coincidence degree of date information in the matching information and date information in the filtering schemes, and the coincidence degree of feature words in the matching information and corresponding feature words in the filtering schemes; calculating the matching probability P of the current filtering scheme by a formula P of (A + C1+ C2+ C3+ … … + Cn)/(n +1), wherein A is the coincidence degree of the date information in the matching information and the date information in the filtering scheme; and Cn is the contact ratio of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme.

The storage medium may be an internal storage unit of the aforementioned device, such as a hard disk or a memory of the device. The storage medium may also be an external storage device of the device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like provided on the device. Further, the storage medium may also include both an internal storage unit and an external storage device of the apparatus.

It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses, devices and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

In the embodiments provided by the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only a logical division, and there may be other divisions when the actual implementation is performed, or units having the same function may be grouped into one unit, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may also be an electric, mechanical or other form of connection.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk.

While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A workbook filtering method, comprising:

acquiring the mechanism grade of a current user and keywords input by the user;

filtering the report data in the workbook through the filtering scheme with the highest matching probability to obtain a data result;

the configuration information comprises authority configuration information and filtering field configuration information, and the authority configuration information comprises organization grade information and extension information;

acquiring configuration information of a workbook, and verifying the organization grade of the current user according to the configuration information of the workbook to obtain a verification result, wherein the verification result comprises the following steps:

acquiring authority configuration information and filtering field configuration information of the workbook;

verifying the mechanism level of the current user through mechanism level information and extension information in the authority configuration information to obtain a verification result; the organization grade information comprises an organization upper limit and an organization lower limit;

the extension information is used for judging whether the lower limit of the organization in the authority configuration information of the workbook is extended downwards;

the filtering field configuration information is used for performing authority filtering on the report data when the verification result contains authority filtering on the report data in the workbook;

the matching the filtering scheme contained in the scheme library according to the verification result and the keyword to obtain the matching probability of the filtering scheme comprises the following steps:

performing word segmentation on the keywords and extracting characteristic information to obtain the characteristic information of the keywords;

determining matching information according to the verification result and the feature information of the keyword;

matching the filtering schemes contained in the scheme library through the matching information to obtain the matching probability of the filtering schemes;

the matching the filtering schemes included in the scheme library through the matching information to obtain the matching probability of the filtering schemes includes:

sequentially acquiring the filtering schemes in the scheme library, acquiring the coincidence degree of date information in the matching information and date information in the filtering schemes, and the coincidence degree of feature words in the matching information and corresponding feature words in the filtering schemes;

calculating the matching probability P of the current filtering scheme by a formula P of (A + C1+ C2+ C3+ … … + Cn)/(n +1), wherein A is the coincidence degree of the date information in the matching information and the date information in the filtering scheme; and Cn is the contact ratio of the nth characteristic word in the matching information and the corresponding characteristic word in the filtering scheme.

2. The workbook filtering method of claim 1, wherein the determining matching information according to the verification result and the feature information of the keyword comprises:

if the verification result does not contain report data authority filtering, the characteristic information of the keywords is used as matching information;

and if the verification result comprises report data authority filtering, taking the intersection of the limiting range corresponding to the current user mechanism level and the characteristic information as matching information.

3. A workbook filter assembly, comprising:

the filtering unit is used for filtering the report data in the workbook through the filtering scheme with the highest matching probability to obtain a data result;

the agency level verification unit includes:

the configuration information acquisition unit is used for acquiring the authority configuration information and the filtering field configuration information of the workbook;

the verification result acquisition unit is used for verifying the mechanism level of the current user through the mechanism level information and the extension information in the authority configuration information to obtain a verification result; the organization grade information comprises an organization upper limit and an organization lower limit;

the matching unit includes:

the feature extraction unit is used for segmenting the keywords and extracting feature information to obtain the feature information of the keywords;

the matching information integration unit is used for determining matching information according to the verification result and the characteristic information of the keyword;

a matching probability calculation unit, configured to match the filtering schemes included in the scheme library through the matching information to obtain matching probabilities of the filtering schemes;

4. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the workbook filtering method as claimed in any one of claims 1-2 when executing the computer program.

5. A storage medium storing a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the workbook filtering method of any one of claims 1-2.