CN110618990B - List report setting method, system and list report acquisition method - Google Patents
List report setting method, system and list report acquisition method Download PDFInfo
- Publication number
- CN110618990B CN110618990B CN201910754466.3A CN201910754466A CN110618990B CN 110618990 B CN110618990 B CN 110618990B CN 201910754466 A CN201910754466 A CN 201910754466A CN 110618990 B CN110618990 B CN 110618990B
- Authority
- CN
- China
- Prior art keywords
- target user
- field
- authority
- permission
- down menu
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000013507 mapping Methods 0.000 claims abstract description 47
- 238000012795 verification Methods 0.000 claims description 32
- 238000004590 computer program Methods 0.000 claims description 10
- 230000008520 organization Effects 0.000 claims description 9
- 230000004044 response Effects 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 abstract description 4
- 238000012216 screening Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 2
- 238000010295 mobile communication Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- VYZAMTAEIAYCRO-UHFFFAOYSA-N Chromium Chemical compound [Cr] VYZAMTAEIAYCRO-UHFFFAOYSA-N 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6245—Protecting personal data, e.g. for financial or medical purposes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Human Computer Interaction (AREA)
- Medical Informatics (AREA)
- Automation & Control Theory (AREA)
- Storage Device Security (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a method for setting a list report, which comprises the following steps: configuring a list report, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields; acquiring authority setting information of a target user; selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information; establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field; and storing the mapping relation so that the target user can acquire the target data item in the authority range of the target user from the list report according to the mapping relation. In the embodiment, a list report is configured by using the same logical list, so that the configuration efficiency and the subsequent maintenance efficiency are improved. Meanwhile, the burden of data downloading is reduced, unnecessary links such as screening and the like are eliminated, and the data privacy of other institutions is effectively ensured.
Description
Technical Field
The embodiment of the invention relates to the field of computer data processing, in particular to a method, a system, computer equipment, a computer readable storage medium and a method for acquiring a list report.
Background
The existing list report generally has two configuration methods, wherein the first method is as follows: a full list report is configured based on the list of the same logic, and the second method is as follows: the list of the same logic is used for respectively configuring a plurality of list reports based on different users.
However, both of the above methods have certain drawbacks:
The first method is as follows: a full-volume list report often comprises massive data recorded by dozens of institutions or dozens of departments, and the data volume is huge; when one of the institutions needs to acquire the data of the institution, the full-volume list report needs to be downloaded, and then the data belonging to the institution is manually screened out for use. The method ensures that a user needs to acquire a large amount of invalid data of other institutions while acquiring the data of the institutions, so that the downloaded data amount is huge, unnecessary links such as screening and the like are added, and the data privacy of other institutions is challenging.
The second method is as follows: inventory reporting of the same logic needs to be configured for each institution or department repeatability. The configuration efficiency is low, and when some same field needs to be modified, the list report of each organization needs to be modified, which also reduces the subsequent maintenance efficiency.
Disclosure of Invention
Accordingly, an object of the embodiments of the present invention is to provide a method, a system, a computer device, a computer readable storage medium, and a method for acquiring a list report, which are capable of configuring a list report with a list of the same logic, so as to improve configuration efficiency and subsequent maintenance efficiency. Meanwhile, the problem that a target user needs to acquire a large amount of invalid data of other institutions while acquiring the data of the institutions is avoided, the burden of data downloading is reduced, unnecessary links such as screening are eliminated, and the data privacy of other institutions is effectively guaranteed.
In order to achieve the above object, an embodiment of the present invention provides a method for setting a manifest report, including the following steps:
Configuring a list report, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields;
Acquiring authority setting information of a target user;
Selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information;
Establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field;
and storing the mapping relation so that the target user can acquire the target data item in the authority range of the target user from the list report according to the mapping relation.
Preferably, the step of selecting at least one field from the plurality of word segments as the authority distinguishing field includes:
Selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
The plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field.
Preferably, the step of acquiring rights setting information of the target user includes:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning the user graphical interface with the authority classification setting entry, wherein the authority classification setting entry comprises a first-level drop-down menu type entry and a second-level drop-down menu type entry, the first-level drop-down menu type interface is provided with a plurality of options corresponding to a plurality of authority classification levels in advance, the option corresponding to each authority classification level corresponds to a second-level drop-down menu, and each second-level drop-down menu comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
And acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance.
In order to achieve the above object, an embodiment of the present invention further provides a manifest report setting system, including:
The configuration module is used for configuring a list report, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields;
The acquisition module is used for acquiring the authority setting information of the target user;
The selection module is used for selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information;
the mapping module is used for establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field;
And the storage module is used for storing the mapping relation so that the target user can acquire the target data item in the target user authority range from the list report according to the mapping relation.
To achieve the above object, an embodiment of the present invention further provides a computer device, a memory of the computer device, a processor, and a computer program stored in the memory and executable on the processor, where the computer program when executed by the processor implements the steps of the manifest report setting method as described above.
To achieve the above object, an embodiment of the present invention also provides a computer-readable storage medium having stored therein a computer program executable by at least one processor to cause the at least one processor to perform the steps of the manifest report setting method as described above.
In order to achieve the above object, the embodiment of the present invention further provides a method for acquiring a manifest report based on user rights, where the method includes:
Receiving request information for requesting a target list report form from a client, wherein the request information carries user identification information of a target user;
In response to the request information:
Inquiring a target user permission range of the target user in a list report form from a preset mapping table according to the user identification information of the target user;
Extracting a plurality of data items in the target user authority range from the list report according to the target user authority range, and generating a target list report based on the plurality of data items;
And sending the target list report to the client so that the client displays the target list report on a display interface.
Preferably, the method further comprises the step of presetting the mapping table:
Acquiring authority setting information of a target user;
selecting at least one field from a plurality of fields of the list report form as a permission distinguishing field according to the permission setting information;
Establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field; and
And the mapping relation is stored in the mapping table.
Preferably, the step of acquiring rights setting information of the target user includes:
Selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
The plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field.
Preferably, the step of acquiring rights setting information of the target user includes:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning the user graphical interface with the authority classification setting entry, wherein the authority classification setting entry comprises a first-level drop-down menu type entry and a second-level drop-down menu type entry, the first-level drop-down menu type interface is provided with a plurality of options corresponding to a plurality of authority classification levels in advance, the option corresponding to each authority classification level corresponds to a second-level drop-down menu, and each second-level drop-down menu comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
And acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance.
According to the method, the system, the computer equipment, the computer readable storage medium and the method for acquiring the list report, the authority relationship is preset for each target user according to the authority distinguishing field in the list report, so that the target user can acquire the target data item in the authority range of the target user from the list report.
In the embodiment, a list report is configured by using the same logical list, so that the configuration efficiency and the subsequent maintenance efficiency are improved. Meanwhile, the problem that a target user needs to acquire a large amount of invalid data of other institutions while acquiring the data of the institutions is avoided, the burden of data downloading is reduced, unnecessary links such as screening are eliminated, and the data privacy of other institutions is effectively guaranteed.
Drawings
Fig. 1 is a flowchart of a first embodiment of a method for setting a manifest report.
Fig. 2 is a schematic flow chart of step S102 in fig. 1.
FIG. 3 is a schematic diagram of a program module of a second embodiment of a report setting method of the present invention.
Fig. 4 is a schematic diagram of a hardware structure of a third embodiment of the computer device of the present invention.
Fig. 5 is a flowchart of a fifth embodiment of a method for acquiring a manifest report according to the present invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The following embodiments will exemplarily describe taking the computer device 2 as an execution subject.
Computer device 2 illustratively connects clients. The clients can be classified into two types by use distinction, one being a client of an administrator who configures the manifest report, and the other being a client of a user who requests data from the manifest report. It should be noted that, the client side of the administrator may also be used to ask for data from the manifest report.
The client may also be a personal computer, tablet computer, or the like. Operating systems such as Microsoft Windows, linux, mac OS, android, IOS and the like can be run on the client, and application programs (such as an IE browser, a Chrome browser and the like) and the like are loaded in the operating systems, so that a worker can perform data interaction with the computer device 2 through the application programs to provide configuration instructions and the like for the computer device 2.
Example 1
Referring to fig. 1, a flowchart illustrating steps of a method for setting a manifest report according to a first embodiment of the present invention is shown. It will be appreciated that the flow charts in the method embodiments are not intended to limit the order in which the steps are performed. Specifically, the following is described.
Step S100, configuring a list report, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields.
In an exemplary embodiment, the manifest report is: a full-volume inventory report configured according to a plurality of inventory of the same logic may be used to record various types of data of tens of institutions or tens of departments.
The same logic may be the same type of inventory, such as an A inventory and a B inventory (rather than an A inventory and a B customer inventory), and configured with the same plurality of fields, each of which has the same field attributes, such as primary key, foreign key settings, etc. It will be appreciated that multiple listings may be combined into one summary, i.e., a full-scale listing report, based on the same logical hierarchy.
Step S102, obtaining authority setting information of a target user.
In an exemplary embodiment, a user graphical interface is preconfigured that may be displayed on an administrator's client. The user graphic interface comprises a plurality of sub-interfaces, and each sub-interface is used for inputting corresponding configuration instructions. These sub-interfaces may be drop down menu interfaces, text input interfaces, etc. The drop-down menu type interface is provided with various options in advance, and a worker can execute the adding or deleting operation on the various options.
For example, in this embodiment, a B/S architecture is adopted, and the administrator may input the setting instruction through the user graphical interface displayed on the browser of the client, where the client is configured with a hardware interface such as a physical keyboard/mouse or a virtual keyboard/mouse. The staff member can input the user setting instruction into the user graphic interface through the hardware interface.
In an exemplary embodiment, step S102 further includes the steps of:
step S102a, acquiring the identity verification information of the target user;
Step S102b, carrying out identity verification on the target user according to the identity verification information;
Step S102c, if the verification is passed, returning the user graphical interface with the authority classification setting entry, wherein the authority classification setting entry comprises a first-level pull-down menu type entry and a second-level pull-down menu type entry, the first-level pull-down menu type interface is provided with a plurality of options corresponding to a plurality of authority classification levels in advance, the option corresponding to each authority classification level corresponds to a second-level pull-down menu, and each second-level pull-down menu comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
Step S102d, obtaining authority setting information of the target user according to a selection instruction based on the first-level drop-down menu type entrance and the second-level drop-down menu type entrance of the target user.
Step S104, selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information.
In an exemplary embodiment, the step S104 further includes: at least one candidate field is selected from a plurality of candidate fields for representing different rights dimensions as a rights discrimination field.
The plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields may include a sales center field, an organization field, an employee number field, and the like. It should be noted that the above-mentioned candidate fields are not exhaustive.
Step S106, a mapping relation is established between the target user and the authority distinguishing field value of the authority distinguishing field.
Taking the example of the data item in the sales center field, the sales center field may include a first sales center, a second sales center, …, and an nth sales center. And according to the user authority setting information, mapping and associating the target user with a second sales center.
Taking the data item in the employee number field as an example, the employee number center field may include a first number, a second number, …, and an nth number. Illustratively, according to the user authority setting information, mapping and associating the target user with an Nth number.
Step S108, the mapping relation is saved.
And the target user acquires the target data item in the authority range of the target user from the list report according to the mapping relation.
Example two
With continued reference to fig. 3, a schematic program module diagram of a second embodiment of the inventory report setting system of the invention is shown. In this embodiment, the inventory report setting system 20 may include or be divided into one or more program modules, which are stored in a storage medium and executed by one or more processors to accomplish the present invention and to implement the data manipulation methods described above. Program modules in accordance with the embodiments of the present invention are directed to a series of computer program instruction segments capable of performing particular functions, and are more suited to describing the execution of the inventory report setting system 20 on a storage medium than the program itself. The following description will specifically describe functions of each program module of the present embodiment:
the configuration module 200 is configured to configure a list report, where the list report is configured to store a plurality of records of a plurality of users, and each record includes a plurality of data items corresponding to a plurality of fields.
In an exemplary embodiment, the manifest report is: a full-volume inventory report configured according to a plurality of inventory of the same logic may be used to record various types of data of tens of institutions or tens of departments.
An obtaining module 202, configured to obtain rights setting information of the target user.
In an exemplary embodiment, a user graphical interface is preconfigured that may be displayed on an administrator's client. The user management interface comprises a plurality of sub-interfaces, and each sub-interface is used for inputting corresponding configuration instructions. These sub-interfaces may be drop down menu interfaces, text input interfaces, etc. The drop-down menu type interface is provided with various options in advance, and a worker can execute the adding or deleting operation on the various options.
For example, in this embodiment, a B/S architecture is adopted, and an administrator may input a setting instruction for a target user through the user graphical interface displayed on a browser of the client, where the client is configured with a hardware interface such as an entity keyboard/mouse or a virtual keyboard/mouse. The administrator may input the user setting instruction into the user graphic interface through the hardware interface.
In an exemplary embodiment, the acquisition module 202 is further configured to:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning the user graphical interface with the authority classification setting entry, wherein the authority classification setting entry comprises a first-level drop-down menu type entry and a second-level drop-down menu type entry, the first-level drop-down menu type interface is provided with a plurality of options corresponding to a plurality of authority classification levels in advance, the option corresponding to each authority classification level corresponds to a second-level drop-down menu, and each second-level drop-down menu comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
And acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance.
And a selecting module 204, configured to select at least one field from the plurality of word segments as a permission differentiating field according to the permission setting information.
In an exemplary embodiment, the selection module 204 is further configured to: at least one candidate field is selected from a plurality of candidate fields for representing different rights dimensions as a rights discrimination field.
The plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields may include a sales center field, an organization field, an employee number field, and the like. It should be noted that the above-mentioned candidate fields are not exhaustive.
And the mapping module 206 is configured to establish a mapping relationship between the target user and the permission discrimination field value of the permission discrimination field.
Taking the example of the data item in the sales center field, the sales center field may include a first sales center, a second sales center, …, and an nth sales center. And according to the user authority setting information, mapping and associating the target user with a second sales center.
Taking the data item in the employee number field as an example, the employee number center field may include a first number, a second number, …, and an nth number. Illustratively, according to the user authority setting information, mapping and associating the target user with an Nth number.
A saving module 208, configured to save the mapping relationship.
And the target user can acquire the target data item in the authority range of the target user from the list report according to the mapping relation.
Example III
Referring to fig. 4, a hardware architecture diagram of a computer device according to a third embodiment of the present invention is shown. In this embodiment, the computer device 2 is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction. The computer device 2 may be a rack server, a blade server, a tower server, or a rack server (including a stand-alone server, or a server cluster made up of multiple servers), or the like. As shown, the computer device 2 includes, but is not limited to, at least a memory 21, a processor 22, a network interface 23, and a statement of list setting system 20 communicatively coupled to each other via a system bus. Wherein:
In this embodiment, the memory 21 includes at least one type of computer-readable storage medium including flash memory, a hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, and the like. In some embodiments, the memory 21 may be an internal storage unit of the computer device 2, such as a hard disk or a memory of the computer device 2. In other embodiments, the memory 21 may also be an external storage device of the computer device 2, such as a plug-in hard disk provided on the computer device 20, a smart memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD), or the like. Of course, the memory 21 may also include both internal storage units of the computer device 2 and external storage devices. In this embodiment, the memory 21 is typically used to store the operating system and various types of application software installed on the computer device 2, such as program codes of the inventory report setting system 20 of the fifth embodiment. Further, the memory 21 may be used to temporarily store various types of data that have been output or are to be output.
Processor 22 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 22 is typically used to control the overall operation of the computer device 2. In this embodiment, the processor 22 is configured to run the program code stored in the memory 21 or process data, for example, run the inventory report setting system 20, to implement the inventory report setting method of the first embodiment.
The network interface 23 may comprise a wireless network interface or a wired network interface, which network interface 23 is typically used for establishing a communication connection between the computer apparatus 2 and other electronic devices. For example, the network interface 23 is used to connect the computer device 2 to an external terminal through a network, establish a data transmission channel and a communication connection between the computer device 2 and the external terminal, and the like. The network may be an Intranet (Intranet), the Internet (Internet), a global system for mobile communications (Global System of Mobile communication, GSM), wideband code division multiple access (Wideband Code Division Multiple Access, WCDMA), a 4G network, a 5G network, bluetooth (Bluetooth), wi-Fi, or other wireless or wired network.
It is noted that fig. 4 only shows a computer device 2 having components 20-23, but it is understood that not all of the illustrated components are required to be implemented, and that more or fewer components may alternatively be implemented.
In this embodiment, the inventory report setting system 20 stored in the memory 21 may be further divided into one or more program modules, which are stored in the memory 21 and executed by one or more processors (the processor 22 in this embodiment) to complete the present invention.
For example, fig. 3 shows a schematic program module diagram of a second embodiment of the inventory-based report setting system 20, where the inventory-based report setting system 20 may be divided into a configuration module 200, an acquisition module 202, a selection module 204, a mapping module 206, and a storage module 208. Program modules in the present invention are understood to mean a series of computer program instruction segments capable of performing a specific function, more appropriately than a program, for describing the execution of the statement setting system 20 in the computer device 2. The specific functions of the program modules 200-208 are described in detail in the second embodiment, and are not described herein.
Example IV
The present embodiment also provides a computer-readable storage medium such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, a server, an App application store, etc., on which a computer program is stored, which when executed by a processor, performs the corresponding functions. The computer readable storage medium of the present embodiment is used to store the manifest report setting system 20, and when executed by the processor, implements the manifest report setting method of the first embodiment.
Example five
Referring to fig. 5, a flowchart illustrating steps of a manifest report acquiring method according to a third embodiment of the present invention is shown. It will be appreciated that the flow charts in the method embodiments are not intended to limit the order in which the steps are performed. Specifically, the following is described.
Step S300, receiving request information for requesting a target list report form from a client, wherein the request information carries user identification information of the target user.
Step S302, in response to the request information:
step S302a, inquiring a target user authority range of the target user in a list report form from a preset mapping table according to the user identification information of the target user.
In an exemplary embodiment, the step of presetting the mapping table:
acquiring authority setting information of a target user; selecting at least one field from a plurality of fields of the list report form as a permission distinguishing field according to the permission setting information; establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field; and the mapping relation is stored in the mapping table.
Further, the step of acquiring the authority setting information of the target user includes:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning the user graphical interface with the authority classification setting entry, wherein the authority classification setting entry comprises a first-level drop-down menu type entry and a second-level drop-down menu type entry, the first-level drop-down menu type interface is provided with a plurality of options corresponding to a plurality of authority classification levels in advance, the option corresponding to each authority classification level corresponds to a second-level drop-down menu, and each second-level drop-down menu comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
And acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance.
Further, the step of obtaining the authority setting information of the target user includes:
Selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
The plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field.
Step S302b, extracting a plurality of data items in the target user authority range from the list report according to the target user authority range, and generating a target list report based on the plurality of data items;
and step S302c, the target list report is sent to the client so that the client displays the target list report on a display interface.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (5)
1. A method for setting a manifest report, the method comprising:
configuring a list report with the same logic, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields;
Acquiring authority setting information of a target user;
Selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information; wherein selecting at least one field from the plurality of word segments as a permission discrimination field comprises: selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
Establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field;
storing the mapping relation so that the target user can acquire a target data item in the target user authority range from the list report according to the mapping relation;
the plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field;
the step of acquiring the authority setting information of the target user comprises the following steps:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning a user graphical interface with a permission classification setting inlet, wherein the permission classification setting inlet comprises a first-level drop-down menu type inlet and a second-level drop-down menu type inlet, the first-level drop-down menu type inlet is provided with a plurality of options corresponding to a plurality of permission classification levels in advance, each option corresponding to a permission classification level corresponds to a second-level drop-down menu inlet, and each second-level drop-down menu inlet comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
Acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance;
the sales center field comprises a first sales center, a second sales center, … and an Nth sales center; and according to the user authority setting information, mapping and associating the target user with a second sales center.
2. A manifest report setting system, the system comprising:
the configuration module is used for configuring a list report with the same logic, wherein the list report is used for storing a plurality of records of a plurality of users, and each record comprises a plurality of data items corresponding to a plurality of fields;
The acquisition module is used for acquiring the authority setting information of the target user;
The selection module is used for selecting at least one field from the plurality of word segments as a permission distinguishing field according to the permission setting information; wherein selecting at least one field from the plurality of word segments as a permission discrimination field comprises: selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
the mapping module is used for establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field;
The storage module is used for storing the mapping relation so that the target user can acquire a target data item in the target user authority range from the list report according to the mapping relation;
the plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field;
the method for acquiring the authority setting information of the target user comprises the following steps:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning a user graphical interface with a permission classification setting inlet, wherein the permission classification setting inlet comprises a first-level drop-down menu type inlet and a second-level drop-down menu type inlet, the first-level drop-down menu type inlet is provided with a plurality of options corresponding to a plurality of permission classification levels in advance, each option corresponding to a permission classification level corresponds to a second-level drop-down menu inlet, and each second-level drop-down menu inlet comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
Acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance;
the sales center field comprises a first sales center, a second sales center, … and an Nth sales center; and according to the user authority setting information, mapping and associating the target user with a second sales center.
3. A computer device, a memory of the computer device, a processor and a computer program stored on the memory and executable on the processor, characterized in that the computer program, when executed by the processor, implements the steps of the manifest report setting method of claim 1.
4. A computer-readable storage medium, in which a computer program is stored, the computer program being executable by at least one processor to cause the at least one processor to perform the steps of the manifest report setting method of claim 1.
5. A list report acquisition method based on user rights is characterized by comprising the following steps:
Receiving request information for requesting a target list report form from a client, wherein the request information carries user identification information of a target user;
In response to the request information:
inquiring a target user authority range in a list report created in the same logic with the target user from a preset mapping table according to the user identification information of the target user;
Extracting a plurality of data items in the target user authority range from the list report according to the target user authority range, and generating a target list report based on the plurality of data items;
the target list report is sent to a client so that the client displays the target list report on a display interface;
the method further comprises the step of presetting the mapping table:
Acquiring authority setting information of a target user; the step of acquiring the authority setting information of the target user comprises the following steps: selecting at least one candidate field from a plurality of candidate fields for representing different permission dimensions as a permission discrimination field;
selecting at least one field from a plurality of fields of the list report form as a permission distinguishing field according to the permission setting information;
Establishing a mapping relation between the target user and the authority distinguishing field value of the authority distinguishing field; and
The mapping relation is in the mapping table;
the plurality of candidate fields are selected from the plurality of fields of the list report, and the plurality of candidate fields comprise a sales center field, an organization field and/or an employee number field;
the step of acquiring the authority setting information of the target user comprises the following steps:
Acquiring the identity verification information of the target user;
carrying out identity verification on the target user according to the identity verification information;
If the verification is passed, returning a user graphical interface with a permission classification setting inlet, wherein the permission classification setting inlet comprises a first-level drop-down menu type inlet and a second-level drop-down menu type inlet, the first-level drop-down menu type inlet is provided with a plurality of options corresponding to a plurality of permission classification levels in advance, each option corresponding to a permission classification level corresponds to a second-level drop-down menu inlet, and each second-level drop-down menu inlet comprises a plurality of options corresponding to a plurality of to-be-selected fields; and
Acquiring authority setting information of the target user according to a selection instruction of the target user at the first-level drop-down menu type entrance and the second-level drop-down menu type entrance;
the sales center field comprises a first sales center, a second sales center, … and an Nth sales center; and according to the user authority setting information, mapping and associating the target user with a second sales center.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910754466.3A CN110618990B (en) | 2019-08-15 | 2019-08-15 | List report setting method, system and list report acquisition method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910754466.3A CN110618990B (en) | 2019-08-15 | 2019-08-15 | List report setting method, system and list report acquisition method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110618990A CN110618990A (en) | 2019-12-27 |
| CN110618990B true CN110618990B (en) | 2024-04-30 |
Family
ID=68921849
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910754466.3A Active CN110618990B (en) | 2019-08-15 | 2019-08-15 | List report setting method, system and list report acquisition method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110618990B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112765627B (en) * | 2021-01-22 | 2022-02-18 | 重庆允成互联网科技有限公司 | Business report data authority control method based on double-layer authority control |
| CN113407225B (en) * | 2021-06-23 | 2022-09-23 | 未鲲(上海)科技服务有限公司 | Code list generation method and device, computer equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
| CN108280365A (en) * | 2017-09-19 | 2018-07-13 | 平安科技（深圳）有限公司 | Data access authority management method, device, terminal device and storage medium |
| CN108681674A (en) * | 2018-04-23 | 2018-10-19 | 平安科技（深圳）有限公司 | Reports module creation method, device, computer installation and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7599934B2 (en) * | 2005-09-27 | 2009-10-06 | Microsoft Corporation | Server side filtering and sorting with field level security |
| US10942937B2 (en) * | 2017-04-14 | 2021-03-09 | Seagate Technology Llc | Data mining systems |
-
2019
- 2019-08-15 CN CN201910754466.3A patent/CN110618990B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
| CN108280365A (en) * | 2017-09-19 | 2018-07-13 | 平安科技（深圳）有限公司 | Data access authority management method, device, terminal device and storage medium |
| CN108681674A (en) * | 2018-04-23 | 2018-10-19 | 平安科技（深圳）有限公司 | Reports module creation method, device, computer installation and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110618990A (en) | 2019-12-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110727954B (en) | Data authorization desensitization automation method, device and storage medium | |
| CN110704521A (en) | Interface data access method and system | |
| US9876699B2 (en) | System and method for generating a report in real-time from a resource management system | |
| CN107862425B (en) | Wind control data acquisition method, device and system and readable storage medium | |
| CN108241529B (en) | Salary calculation method, application server and computer readable storage medium | |
| CN110618990B (en) | List report setting method, system and list report acquisition method | |
| CN111580874A (en) | System safety control method and system for data application and computer equipment | |
| CN110851495A (en) | Heterogeneous source data processing method and device, storage medium and electronic equipment | |
| CN112956157A (en) | System and method for tracking client device events | |
| CN110502482B (en) | User operation interface configuration method, system and data operation method | |
| CN110019076B (en) | Method, device and equipment for constructing multi-system log data and readable storage medium | |
| CN111049824B (en) | Resource environment big data management method, storage medium and control device | |
| CN111552712A (en) | Report data extraction method and device and computer equipment | |
| CN111767262A (en) | Log display method, device, equipment and storage medium | |
| CN109544348B (en) | Asset security screening method, device and computer readable storage medium | |
| CN112580065A (en) | Data query method and device | |
| KR20130126012A (en) | Method and apparatusfor providing report of business intelligence | |
| US20200258093A1 (en) | Compliance standards mapping | |
| CN109828884B (en) | Hanging service data processing method, system, computer equipment and storage medium | |
| CN110443560B (en) | Protocol data management method, device, computer equipment and storage medium | |
| CN112686742A (en) | Sales invoice risk early warning method and device, storage medium and electronic equipment | |
| CN110674129A (en) | Abnormal event processing method, system, computer equipment and storage medium | |
| CN113722225A (en) | Page testing method and device, computer equipment and storage medium | |
| CN112860629B (en) | Method and system for attributing performance, computer equipment and readable storage medium thereof | |
| US20210319170A1 (en) | System and Method for Generating a Dynamic Document |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |