CN114996406A - Standing book generation method and device, storage medium and electronic equipment - Google Patents
Standing book generation method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN114996406A CN114996406A CN202210695701.6A CN202210695701A CN114996406A CN 114996406 A CN114996406 A CN 114996406A CN 202210695701 A CN202210695701 A CN 202210695701A CN 114996406 A CN114996406 A CN 114996406A
- Authority
- CN
- China
- Prior art keywords
- target
- field
- key field
- user
- standing book
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
-
- 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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/335—Filtering based on additional data, e.g. user or group profiles
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application discloses a standing book generating method, a device, a storage medium and electronic equipment, wherein the method comprises the following steps: responding to the selection operation of a user aiming at key fields in the field library to obtain a plurality of target key fields; receiving field conditions set by a user for each target key field; responding to the sequence adjustment operation of a user aiming at each target key field to adjust the arrangement sequence of each target key field; and screening target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain a target standing book. According to the method and the device, the key fields are selected, the field conditions are set according to the key fields, and meanwhile the arrangement sequence of the key fields is adjusted, so that the machine account expected by a user can be accurately and quickly generated, and the problem of low machine account generation efficiency in the prior art is solved.
Description
Technical Field
The invention relates to the technical field of computers and financial leasing, in particular to a standing book generating method, a standing book generating device, a storage medium and electronic equipment.
Background
Due to the arrival of the digital era, the understanding and analysis demand of each business party on company data assets is gradually increased, a data analyst needs to understand the business logic of fields according to the data analyst, put forward a ledger requirement, understand, sort and convert the ledger requirement into a requirement document through requirement communication, compile an sql script according to the business logic, and develop online at a later period. After the machine account is online, a user logs in and checks the machine account data, the data accuracy is verified, if the user thinks that the data have deviation, the user needs to communicate with the machine account again, and the process is repeated in a circulating mode until the user thinks that the data are accurate. This whole process, the step is more, and in the information transfer process, there is both sides to understand the deviation easily, causes redevelopment, and then causes the problem that the ledger generates efficiency lower, and scientific and technological resource is extravagant.
Therefore, a standing book generating method is needed to solve the problem of low standing book generating efficiency in the prior art.
Disclosure of Invention
In view of this, the present invention provides a standing book generation method, apparatus, storage medium and electronic device, and mainly aims to solve the problem of low standing book generation efficiency in the prior art.
In order to solve the above problem, the present application provides a machine account generation method, including:
responding to the selection operation of a user aiming at key fields in the field library to obtain a plurality of target key fields;
receiving field conditions set by a user for each target key field;
responding to the sequence adjustment operation of a user aiming at each target key field to adjust the arrangement sequence of each target key field;
and screening target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain a target standing book.
Optionally, before the plurality of target key fields are obtained in response to the selection operation of the user for the key fields in the field library, the method further includes:
inquiring each key field in the field library to obtain attribute information of each key field;
determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book;
wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
Optionally, the responding to the order adjustment operation of the user for each target key field to adjust the arrangement order of each target key field specifically includes:
and responding to the drag operation of the user in the target area aiming at each target key field to adjust the arrangement sequence of each target key field.
Optionally, before the target data is screened from the database based on each target key field, the field condition, and the arrangement order of each target key field to obtain the target standing book, the method further includes:
screening a preset number of pieces of preview data from a database based on each target key field, the field condition and the arrangement sequence of each target key field;
comparing the data type of the preview data with the preset data type;
and under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of a user for each target key field to obtain a plurality of current target key fields for generating the standing book.
Optionally, after the target standing book is obtained, the standing book generating method further includes: responding to information configuration operation of a user aiming at the target standing book to configure basic information for the target standing book;
wherein, the basic information comprises any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
Optionally, after the target standing book is obtained, the standing book generating method further includes:
acquiring a target display mode matched with a preset data type based on the preset data type of the target account book;
and displaying the target standing book according to the target display mode.
In order to solve the above problem, the present application provides a machine account generation device, including:
the first obtaining module is used for responding to the selection operation of a user aiming at key fields in the field library and obtaining a plurality of target key fields;
the receiving module is used for receiving field conditions set by a user aiming at each target key field;
the adjusting module is used for responding to the sequence adjusting operation of a user aiming at each target key field so as to adjust the arrangement sequence of each target key field;
and the second obtaining module is used for screening and obtaining target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field so as to obtain the target standing book.
Optionally, the apparatus further includes a query module, where the query module is configured to:
inquiring each key field in the field library to obtain attribute information of each key field;
determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target ledger;
wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
In order to solve the above problem, the present application provides a storage medium storing a computer program that, when executed by a processor, implements the steps of the ledger generation method of any one of the above.
In order to solve the above problem, the present application provides an electronic device, which at least includes a memory and a processor, where the memory stores a computer program, and the processor implements the steps of the ledger generation method according to any one of the above embodiments when executing the computer program on the memory.
According to the method and the device, the key fields are selected, the field conditions are set according to the key fields, and meanwhile the arrangement sequence of the key fields is adjusted, so that the machine account expected by a user can be accurately and quickly generated, and the problem of low machine account generation efficiency in the prior art is solved.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various additional advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a flowchart of a standing book generation method according to an embodiment of the present application;
fig. 2 is a flowchart of a standing book generation method according to another embodiment of the present application;
fig. 3 is a block diagram of a machine-account generating apparatus according to another embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
Various aspects and features of the present application are described herein with reference to the drawings.
It will be understood that various modifications may be made to the embodiments of the present application. Accordingly, the foregoing description should not be construed as limiting, but merely as exemplifications of embodiments. Those skilled in the art will envision other modifications within the scope and spirit of the application.
The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments of the application and, together with a general description of the application given above and the detailed description of the embodiments given below, serve to explain the principles of the application.
These and other characteristics of the present application will become apparent from the following description of preferred forms of embodiment, given as non-limiting examples, with reference to the attached drawings.
It is also to be understood that although the present application has been described with reference to some specific examples, those skilled in the art are able to ascertain many other equivalents to the practice of the present application.
The above and other aspects, features and advantages of the present application will become more apparent in view of the following detailed description when taken in conjunction with the accompanying drawings.
Specific embodiments of the present application are described hereinafter with reference to the accompanying drawings; however, it is to be understood that the disclosed embodiments are merely exemplary of the application, which can be embodied in various forms. Well-known and/or repeated functions and constructions are not described in detail to avoid obscuring the application of unnecessary or unnecessary detail. Therefore, specific structural and functional details disclosed herein are not to be interpreted as limiting, but merely as a basis for the claims and as a representative basis for teaching one skilled in the art to variously employ the present application in virtually any appropriately detailed structure.
The specification may use the phrases "in one embodiment," "in another embodiment," "in yet another embodiment," or "in other embodiments," which may each refer to one or more of the same or different embodiments in accordance with the application.
The embodiment of the application provides a standing book generating method which can be particularly applied to electronic equipment such as a terminal and a server. The specific application scene is a scene that a user generates a ledger containing required data content based on rental business data. As shown in fig. 1, the method in this embodiment includes the following steps:
step S101, responding to the selection operation of a user aiming at key fields in a field library, and obtaining a plurality of target key fields;
in the specific implementation process of this step, a field library may be established in advance, a plurality of key fields are stored in the field library, and the key fields stored in the field library may include any one or more of the following: the lessee age, the customer contact telephone number, the province where the customer is located, the customer residence address, the customer identification card address, the lessee name, the motor vehicle owner, the actual user contact telephone number, the actual user mobile phone number, and the like.
In this step, when the user selects the key field, the selection operation may be a single click, a double click, a drag, and the like. For example, clicking or double clicking at a position corresponding to the key field can be regarded as selecting the key field, and the key field is determined as a target key field; and if the region range specified by the dragging value of the key field is within the range, the key field can be considered to be selected, and the key field is determined as a target key field.
Step S102, receiving field conditions set by a user for each target key field;
the field condition in this step is corresponding to the target key field, for example, when the target key field includes a field of name, the field condition may be set as: the name is not null, so that the data with the name being null can be filtered out later in data screening, and the data with the name not being null is screened out. Of course, the field condition may be set such that the number of words of the name is three or two. Further, when the target key field includes the age of the lessee, the field condition may be set to an age less than 35 years or to an age range of 35 to 40 years, and the like, and may be set according to actual needs.
Step S103, responding to the order adjustment operation of the user for each target key field to adjust the arrangement order of each target key field.
In the specific implementation process of the step, the arrangement sequence of the target keywords can be specifically adjusted in a dragging mode.
And step S104, screening target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain target standing books.
In the specific implementation process of the step, a data warehouse can be specifically created in advance, namely a database is created, so that the historical lease data can be stored. Therefore, when a corresponding standing book is generated subsequently, target data can be screened from the database through the selected target key fields and the field conditions, and then the sequence of each data content in each piece of data is adjusted according to the arrangement sequence of each target key field, so that the target standing book is obtained. For example, the target key fields include the fields of the name of the lessee, the age of the lessee, the number of the mobile phone and the owner of the motor vehicle, and the sequence of the target key fields is as follows: the name of the lessee, the owner of the automatic vehicle, the mobile phone number and the age of the lessee, so that after the target data are obtained, the data contents in the target data can be adjusted according to the sequence of the target key fields. For example, the adjusted target data is: zhang three, Li four, 123456, age 40.
In the embodiment, by selecting the key fields, setting the field conditions according to the key fields, and simultaneously adjusting the sequence of the arrangement of the key fields, the target data can be accurately and quickly screened, various data contents in the target data can be adjusted, and the ledger containing the data required by the user is finally generated, so that the problem of low ledger generation efficiency in the prior art is solved.
Another embodiment of the present application provides a machine account generation method, including:
step S201, inquiring each key field in the field library to obtain the attribute information of each key field;
in this step, the attribute information of the key field includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system. In a specific implementation process of this embodiment, corresponding attribute information may be configured in advance for each key field according to data content and the like used by the key field for filtering.
Step S202, determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book;
in this step, the data type in this embodiment may be preset according to actual needs, for example, the data type may be a first data type including user identity information, or a second data type including user asset information, and the like. Because different key fields can screen out contents of different data types, selecting different key fields can generate ledgers containing different types of contents, namely, ledgers of different data types are obtained. Therefore, the data type of the data content which can be screened out by the key field can be determined according to the attribute of the key field, and the key field can be determined to be the first key field for determining the target key field under the condition that the screened out data type is close to or consistent with the preset data type of the target ledger.
Step S203, responding to the selection operation of the user aiming at the first key field in the field library, and obtaining a plurality of target key fields;
in this step, after the first key field is determined, the first key field in the field library may be selected by clicking, double clicking or dragging, so as to obtain the target key field.
Step S204, receiving field conditions set by a user for each target key field;
step S205, responding to the drag operation of the user in the target area aiming at each target key field, so as to adjust the arrangement sequence of each target key field;
step S206, screening a preset number of pieces of preview data from a database based on each target key field, the field condition and the arrangement sequence of each target key field; comparing the data type of the preview data with the preset data type; under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of a user for each target key field to obtain the current target key field for generating the standing book;
in the step, through data preview, a preset number of data can be screened and obtained, and the data are displayed, so that a user can timely know the screened data content/data type, and then the user can determine whether the data type is the data type required by the user according to the data type of the screened content.
Step S207, screening and obtaining target data from a database based on each current target key field, each field condition and the arrangement sequence of each current target key field to obtain a target standing book;
step S208, responding to the information configuration operation of the user aiming at the target standing book, and configuring basic information for the target standing book;
in this step, the basic information includes any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
In this embodiment, after the configuration of the basic information of the target standing book is completed, the final target standing book may be obtained, and then, operations such as issuing may be performed on the target standing book, so that the relevant person may view the target standing book.
Step S209, acquiring a target display mode matched with a preset data type based on the preset data type of the target ledger; and displaying the target standing book according to the target display mode.
In this step, the association relationship between each data type and each display mode may be pre-established to obtain a mapping table, and when the target ledger is subsequently displayed, the corresponding target display mode may be obtained by searching the mapping table. The data type in this embodiment may be preset according to actual needs, and may be, for example, a first data type including user identity information, or a second data type including user asset information, and so on. The display mode can be a table or picture mode, a full screen display mode or a preset area, and can be set according to actual needs.
On the basis of the above embodiment, the ledger generation method in the present application is further described below with reference to a specific application scenario. As shown in fig. 2, the standing book generating process in this embodiment includes two types, namely "data content information" and "basic information", and the specific standing book generating process includes the following steps:
step one, inquiring fields;
in the specific implementation process of this step, the user may first log in a "field query" module of the ledger generation platform, so as to know the basic information of each field/key field, that is, to know the attribute information of each key field, which specifically includes contents such as "service definition", "data range (relation with tenant, friend)", "whether it is sensitive information", "owner", "system source", and the like. The user can quickly know and confirm the field content desired by the user by inquiring the basic information/attribute information of each key field.
Step two, selecting fields;
in the specific implementation process of the step, a user can create the standing book from a line by clicking a 'new' button of a 'standing book editing' module, so that the requirement of self-use number is met. And then selecting the fields/key fields, namely selecting to obtain the target key fields, for example, selecting the fields by checking with a check box, namely, a user firstly screens the fields required by the user from the screen box and then checks to select the target key fields.
Step three, adjusting the field sequence;
in the specific implementation process of this step, the order of adjusting the fields may be: the manner in which the fields are clicked and dragged in the field box has been selected, and then the fields are dragged to their desired sequential positions.
Step four, setting field conditions;
in this step, setting the condition requires selecting a field from the selected field/target key field to set the corresponding condition. For example, the target key field includes an age, the setting condition may be: the age is less than 40 years. If the target key field includes the amount, the amount range may be set to 1 ten thousand yuan to 5 ten thousand yuan. The field condition can be specifically set and adjusted according to actual needs.
Step five, previewing;
in the step, through data preview, the user can adjust the target key field according to the preview result until the target key field is adjusted to the desired ledger field data. The first step to the fifth step are processes of generating data content information of the standing book.
Step six, selecting a department to which the standing book belongs;
in the step, after the adjustment of the data content information of the standing book is finished and the preview of the data is correct, the basic information of the standing book can be edited. For example, the belonging department information is edited for the standing book. By editing the affiliated department of the ledger, the ledger can be better classified, and the ledger can be conveniently classified, stored, inquired and the like according to the department in the follow-up process.
Step seven, editing the account name;
in the specific implementation process of the step, the user can name the standing book according to actual needs, namely, the name is configured for the target standing book.
Step eight, editing a ledger owner;
in the specific implementation process of the step, the user can clearly know the creator of the standing book when other working personnel check the standing book by adding the owner information to the standing book.
Step nine, configuring data updating time;
in the specific implementation process of the step, the user can clearly know the creation time of the standing book when other working personnel check the standing book by adding the time information to the standing book.
Step ten, editing a permission list;
in the specific implementation process of the step, the authority list is a list of people who can check the account data. The user can control the checking authority of the standing book by editing the authority list for the standing book, and the data safety is ensured.
And step eleven, issuing.
After the above steps are completed, the generated standing book can be issued.
In the specific implementation process of this embodiment, the generation process of the ledger is divided into two types, namely "data content information" and "basic information". If the user changes the 'data content information', the system side needs to regenerate the sql script according to the changed fields and conditions to perform data query preview. And the user does not need to modify the basic information, thereby reducing the system stress.
In the method in the embodiment, a user can learn, maintain and record the field asset content through the field query module of the system platform, and unify the service of the data asset and the system attribution and interpretation caliber, so that the information attenuation caused by personnel change and loss can be reduced.
In addition, according to the standing book generating method in the embodiment, a user can independently explore field data and independently create the standing book according to own requirements, and does not need to rely on scientific and technological resources. Meanwhile, the understanding deviation of the demand information in the communication and transmission process is reduced, so that the development resource waste is reduced, the communication cost is reduced, and the generation efficiency of the ledger is improved.
Another embodiment of the present application provides an apparatus for generating a standing book, as shown in fig. 3, including:
the first obtaining module 1 is used for responding to the selection operation of a user aiming at key fields in a field library and obtaining a plurality of target key fields;
a receiving module 2, configured to receive a field condition set by a user for each target key field;
the adjusting module 3 is used for responding to the sequence adjusting operation of the user aiming at each target key field so as to adjust the arrangement sequence of each target key field;
a second obtaining module 4, configured to obtain target data by screening from a database based on each target key field, each field condition, and an arrangement order of each target key field, so as to obtain a target standing book
In a specific implementation process of this embodiment, the standing book generating apparatus further includes an inquiry module. The query module is configured to: before a plurality of target key fields are obtained in response to the selection operation of a user aiming at the key fields in the field library, inquiring each key field in the field library to obtain the attribute information of each key field; determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book; wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
In a specific implementation process of this embodiment, the adjusting module is specifically configured to: and responding to the dragging operation of the user in the target area aiming at each target key field to adjust the arrangement sequence of each target key field.
In a specific implementation process of this embodiment, the standing book generating apparatus further includes a preview module, where the preview module is configured to: screening a preset number of pieces of preview data from a database based on each target key field, the field conditions and the arrangement sequence of each target key field to obtain target ledgers before target data are screened from the database based on each target key field, the field conditions and the arrangement sequence of each target key field to obtain target ledgers; comparing the data type of the preview data with the preset data type; and under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of the user for each target key field to obtain the current target key field for generating the standing book.
In a specific implementation process of this embodiment, the standing book generating apparatus further includes a configuration module, where the configuration module is configured to: after the target standing book is obtained, responding to information configuration operation of a user aiming at the target standing book to configure basic information for the target standing book; wherein, the basic information comprises any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
In a specific implementation process of this embodiment, the standing book generating apparatus further includes a display module, where the display module is configured to: after the target standing book is obtained, obtaining a target display mode matched with a preset data type based on the preset data type of the target standing book; and displaying the target ledger according to the target display mode.
In the embodiment, the key fields are selected, the field conditions are set according to the key fields, and the arrangement sequence of the key fields is adjusted, so that the standing book expected by the user can be accurately and quickly generated, and the problem of low standing book generation efficiency in the prior art is solved.
Another embodiment of the present application provides a storage medium storing a computer program which, when executed by a processor, performs the method steps of:
step one, responding to the selection operation of a user aiming at key fields in a field library to obtain a plurality of target key fields;
receiving field conditions set by a user for each target key field;
responding to the sequence adjustment operation of the user aiming at each target key field to adjust the arrangement sequence of each target key field;
and step four, screening and obtaining target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain a target standing book.
In a specific implementation process of this embodiment, before a plurality of target key fields are obtained in response to a selection operation of a user for a key field in a field library, the method further includes: inquiring each key field in the field library to obtain attribute information of each key field; determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book; wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
In a specific implementation process of this embodiment, the responding to the order adjustment operation of the user for each target key field to adjust the arrangement order of each target key field specifically includes: and responding to the drag operation of the user in the target area aiming at each target key field to adjust the arrangement sequence of each target key field.
In a specific implementation process of this embodiment, before obtaining target data by screening from a database based on each target key field, the field condition, and an arrangement order of each target key field to obtain a target standing book, the method further includes: screening a preset number of pieces of preview data from a database based on each target key field, the field condition and the arrangement sequence of each target key field; comparing the data type of the preview data with the preset data type; and under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of the user for each target key field to obtain the current target key field for generating the standing book.
In a specific implementation process of this embodiment, after obtaining the target standing book, the method further includes: responding to information configuration operation of a user aiming at the target standing book to configure basic information for the target standing book; wherein, the basic information comprises any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
In a specific implementation process of this embodiment, after obtaining the target standing book, the method further includes: acquiring a target display mode matched with a preset data type based on the preset data type of the target account book; and displaying the target ledger according to the target display mode.
The storage medium in the application selects the key fields, then sets the field conditions according to the key fields, and simultaneously adjusts the sequence of the key fields, so that the machine account expected by a user can be accurately and quickly generated, and the problem of low machine account generation efficiency in the prior art is solved.
Another embodiment of the present application provides an electronic device, as shown in fig. 4, at least including a memory 1 and a processor 2, where the memory 1 stores a computer program thereon, and the processor 2, when executing the computer program on the memory 1, implements the following method steps:
step one, responding to the selection operation of a user aiming at key fields in a field library to obtain a plurality of target key fields;
receiving field conditions set by a user for each target key field;
responding to the sequence adjustment operation of the user aiming at each target key field to adjust the arrangement sequence of each target key field;
and step four, screening and obtaining target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain a target standing book.
In a specific implementation process of this embodiment, before a plurality of target key fields are obtained in response to a selection operation of a user for a key field in a field library, the method further includes: inquiring each key field in the field library to obtain attribute information of each key field; determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book; wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
In a specific implementation process of this embodiment, the responding to the order adjustment operation of the user for each target key field to adjust the arrangement order of each target key field specifically includes: and responding to the dragging operation of the user in the target area aiming at each target key field to adjust the arrangement sequence of each target key field.
In a specific implementation process of this embodiment, before obtaining target data by screening from a database based on each target key field, the field condition, and an arrangement order of each target key field to obtain a target standing book, the method further includes: screening a preset number of pieces of preview data from a database based on each target key field, the field condition and the arrangement sequence of each target key field; comparing the data type of the preview data with the preset data type; and under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of the user for each target key field to obtain the current target key field for generating the standing book.
In a specific implementation process of this embodiment, after obtaining the target standing book, the method further includes: responding to information configuration operation of a user aiming at the target standing book to configure basic information for the target standing book; wherein, the basic information comprises any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
In a specific implementation process of this embodiment, after obtaining the target standing book, the method further includes: acquiring a target display mode matched with a preset data type based on the preset data type of the target account book; and displaying the target standing book according to the target display mode.
According to the electronic equipment, the key fields are selected, the field conditions are set according to the key fields, and meanwhile the arrangement sequence of the key fields is adjusted, so that the machine account expected by a user can be accurately and quickly generated, and the problem of low machine account generation efficiency in the prior art is solved.
The above embodiments are only exemplary embodiments of the present application, and are not intended to limit the present application, and the protection scope of the present application is defined by the claims. Various modifications and equivalents may be made by those skilled in the art within the spirit and scope of the present application and such modifications and equivalents should also be considered to be within the scope of the present application.
Claims (10)
1. A standing book generating method is characterized by comprising the following steps:
responding to the selection operation of a user aiming at key fields in the field library to obtain a plurality of target key fields;
receiving field conditions set by a user for each target key field;
responding to the sequence adjustment operation of a user aiming at each target key field to adjust the arrangement sequence of each target key field;
and screening and obtaining target data from a database based on each target key field, each field condition and the arrangement sequence of each target key field to obtain a target standing book.
2. The method of claim 1, wherein prior to obtaining a number of target key fields in response to a user selection operation for a key field in a field library, the method further comprises:
inquiring each key field in the field library to obtain attribute information of each key field;
determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target standing book;
wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
3. The method of claim 1, wherein the responding to the order adjustment operation of the user for each of the target key fields to adjust the arrangement order of each of the target key fields specifically comprises:
and responding to the dragging operation of the user in the target area aiming at each target key field to adjust the arrangement sequence of each target key field.
4. The method of claim 1, wherein prior to screening target data from a database based on each of the target key fields, the field condition, and the rank order of each of the target key fields to obtain a target ledger, the method further comprises:
screening a preset number of pieces of preview data from a database based on each target key field, the field condition and the arrangement sequence of each target key field;
comparing the data type of the preview data with the preset data type;
and under the condition that the data type of the preview data is inconsistent with the preset data type, responding to the adjustment operation of a user for each target key field to obtain a plurality of current target key fields for generating the standing book.
5. The method of claim 1, wherein after obtaining the target ledger, the method further comprises: responding to information configuration operation of a user aiming at the target standing book to configure basic information for the target standing book;
wherein, the basic information comprises any one or more of the following: the department to which the standing book belongs, the name of the standing book, the user to which the standing book belongs, the data updating time and the authority list.
6. The method of claim 1, wherein after obtaining the target ledger, the method further comprises:
acquiring a target display mode matched with a preset data type based on the preset data type of the target account book;
and displaying the target standing book according to the target display mode.
7. An ledger generation apparatus characterized by comprising:
the first acquisition module is used for responding to the selection operation of a user aiming at key fields in the field library and acquiring a plurality of target key fields;
the receiving module is used for receiving field conditions set by a user for each target key field;
the adjusting module is used for responding to the sequence adjusting operation of a user aiming at each target key field so as to adjust the arrangement sequence of each target key field;
and a second obtaining module, configured to screen and obtain target data from a database based on each target key field, each field condition, and an arrangement order of each target key field, so as to obtain a target ledger.
8. The apparatus of claim 7, wherein the apparatus further comprises a query module configured to:
inquiring each key field in the field library to obtain attribute information of each key field;
determining a first key field for obtaining a target key field based on the attribute information of each key field and the preset data type of the target ledger;
wherein, the attribute information includes any one or more of the following: the service definition of the key field, the data range of the key field, whether the key field relates to sensitive information, the owner of the key field and the source of the system.
9. A storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, implements the steps of the ledger generation method of any one of claims 1-6 above.
10. An electronic device, characterized by comprising at least a memory, a processor, the memory having a computer program stored thereon, the processor implementing the steps of the ledger generation method of any of the previous claims 1-6 when executing the computer program on the memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210695701.6A CN114996406A (en) | 2022-06-20 | 2022-06-20 | Standing book generation method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210695701.6A CN114996406A (en) | 2022-06-20 | 2022-06-20 | Standing book generation method and device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114996406A true CN114996406A (en) | 2022-09-02 |
Family
ID=83035688
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210695701.6A Pending CN114996406A (en) | 2022-06-20 | 2022-06-20 | Standing book generation method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114996406A (en) |
-
2022
- 2022-06-20 CN CN202210695701.6A patent/CN114996406A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102004752A (en) | Flexible cube data warehousing | |
| CN110598107A (en) | Management method of query system and computer storage medium | |
| US9355227B2 (en) | Dynamic document display personalization implemented in a digital rights management system | |
| CN112651826A (en) | Credit limit management and control system, method and readable storage medium | |
| CN114861623A (en) | Protocol template generation method and device, electronic equipment and storage medium | |
| CN113988319A (en) | Federal learning model training method and device, electronic equipment, medium and product | |
| JP2020042640A (en) | Insurance business support system, contractor specification device, method, and program | |
| CN114996406A (en) | Standing book generation method and device, storage medium and electronic equipment | |
| CN115408598A (en) | Information processing method, apparatus, device, storage medium, and program product | |
| CN110457332B (en) | Information processing method and related equipment | |
| CN113240543A (en) | Gas archive management method, system, intelligent terminal and storage medium | |
| CN112287658A (en) | Business data processing method and device, electronic equipment and medium | |
| US11954225B1 (en) | Data privacy management | |
| CN114519090B (en) | Method and device for managing stop words and electronic equipment | |
| CN111062676A (en) | Method and device for realizing government affair approval process | |
| CN112632930B (en) | Table data control method and device | |
| CN116738451A (en) | Method, platform, equipment and storage medium for controlling authority of low-code platform | |
| US11972018B2 (en) | Data categories for purpose-based processing of personal data | |
| CN107729013B (en) | Method for managing operation buttons on web page and computer-readable storage medium | |
| CN116756022A (en) | Data preparation method, device, computer equipment and storage medium | |
| CN116109417A (en) | Product data processing method, device, computer equipment and storage medium | |
| CN113836873A (en) | Electronic manuscript management method and process management method | |
| CN115657901A (en) | Service change method and device based on unified parameters | |
| CN117807084A (en) | Verification method for index configuration data and related equipment | |
| CN113704746A (en) | Data permission processing method and device and computer equipment |
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 |