CN114239524A

CN114239524A - Questionnaire generation method, questionnaire generation device, computer equipment and storage medium

Info

Publication number: CN114239524A
Application number: CN202111402514.6A
Authority: CN
Inventors: 颜果开; 张磊; 周小伟
Original assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Current assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Priority date: 2021-11-19
Filing date: 2021-11-19
Publication date: 2022-03-25

Abstract

The present application relates to a questionnaire generation method, apparatus, computer device, storage medium, and computer program product. The method comprises the following steps: responding to a request instruction containing a questionnaire type, and extracting a target questionnaire template corresponding to the questionnaire type from a database; responding to the editing operation of the target questionnaire template, and acquiring a plurality of configuration information corresponding to the questionnaire framework; respectively storing each configuration information into a corresponding questionnaire information table in a database, and receiving current identification information returned by the database; historical configuration information corresponding to all historical questionnaires is stored in each questionnaire information table; determining target identification information, and respectively extracting corresponding target configuration information from each questionnaire information table of the database according to the target identification information; and combining the target configuration information according to a questionnaire framework to generate a complete questionnaire. By adopting the method, the questionnaire generation efficiency can be improved, and the sharing and the multiplexing of the questionnaires among different users can be realized.

Description

Questionnaire generation method, questionnaire generation device, computer equipment and storage medium

Technical Field

The present application relates to the field of big data intelligent analysis technology, and in particular, to a questionnaire generating method, apparatus, computer device, storage medium, and computer program product.

Background

In a conventional questionnaire generating system, after a user edits and sets a questionnaire, the system fixedly stores all relevant information of the questionnaire into a static file, and then stores the static file into a database. Due to the difference of questionnaire architectures, different questionnaires designed by different users are different, and the new questionnaire is required to be edited and produced again every time a new questionnaire is generated, so that the problem of low questionnaire generation efficiency exists.

Disclosure of Invention

In view of the above, it is necessary to provide a questionnaire generating method, apparatus, computer device, computer-readable storage medium, and computer program product capable of improving questionnaire generating efficiency in view of the above technical problems.

In a first aspect, the present application provides a questionnaire generating method. The method comprises the following steps:

responding to a request instruction containing a questionnaire type, and extracting a target questionnaire template corresponding to the questionnaire type from a database; wherein, the questionnaire templates of different questionnaire types are preset with different questionnaire architectures;

responding to the editing operation of the target questionnaire template, and acquiring a plurality of configuration information corresponding to the questionnaire framework;

respectively storing each configuration information into a corresponding questionnaire information table in the database, and receiving current identification information returned by the database; historical configuration information corresponding to all historical questionnaires is stored in each questionnaire information table;

determining target identification information, and respectively extracting corresponding target configuration information from each questionnaire information table of the database according to the target identification information; wherein the target identification information at least comprises the current identification information;

and combining the target configuration information according to a questionnaire framework to generate a complete questionnaire.

In one embodiment, the extracting, in response to the request instruction including the questionnaire type, the target questionnaire template corresponding to the questionnaire type in the database includes:

acquiring a request instruction, and extracting a questionnaire type carried in the request instruction;

determining at least one candidate questionnaire template corresponding to the questionnaire type in a plurality of historical questionnaire templates stored in a database based on the questionnaire type;

in response to a selection operation, a target questionnaire template is determined among the at least one candidate questionnaire template.

In one embodiment, the configuration information includes at least one of questionnaire level information, topic group information, and topic information; the questionnaire information table at least comprises one of a questionnaire table, a group table and a question table;

the storing each configuration information into the corresponding questionnaire information table in the database respectively includes:

storing the questionnaire hierarchy information into a questionnaire table, storing the question group information into a group table, and storing the question information into a question table;

wherein the questionnaire table is associated with the group table through questionnaire identification information; the group table is associated with the topic table through the topic identification information.

In one embodiment, the questionnaire information table further comprises a score rule table; the method further comprises the following steps:

in response to an input operation, determining input content conforming to a variable identification rule as a dynamic variable;

obtaining a scoring rule associated with the dynamic variable;

storing the scoring rules into a scoring rule table in a database; the scoring rule table is associated with the topic table through topic identification information.

In one embodiment, the target configuration information comprises target topic information and target score rule information; the step of combining the target configuration information according to a questionnaire framework to generate a complete questionnaire comprises the following steps:

filling target topic information and target score rule information of the same topic into the same component;

determining target positions of the filled components in a questionnaire page space respectively according to a questionnaire framework;

and respectively rendering the components at corresponding target positions in a questionnaire page space based on the plurality of components to generate a complete questionnaire.

In one embodiment, the questionnaire page space is comprised of a grid; determining the target positions of the filled components in the questionnaire page space respectively according to the questionnaire architecture, wherein the target positions comprise:

determining the initial positions of the components in a questionnaire page space according to a questionnaire framework;

obtaining coordinate values and grid granularity of an initial grid occupied by a component to be moved, and obtaining coordinate values of a target grid based on movement operation of a user;

calculating whether the grid granularity of the initial grid can be accommodated in a grid space corresponding to the coordinate value of the target grid;

and if the grid granularity of the initial grid can be accommodated, moving the component to be moved from the initial position to the target position according to the coordinate value of the initial grid and the coordinate value of the target grid.

In one embodiment, the method further comprises:

in response to the updating operation, determining identification information to be updated;

extracting the configuration information to be updated corresponding to the identification information to be updated from a questionnaire information table of a database so as to be displayed in a configuration interface for a user to update; and

and acquiring the updated configuration information, and updating a corresponding questionnaire information table in the database based on the corresponding identification information.

In a second aspect, the present application further provides a questionnaire generating device. The device comprises:

the extraction module is used for responding to a request instruction containing a questionnaire type and extracting a target questionnaire template corresponding to the questionnaire type from a database; wherein, the questionnaire templates of different questionnaire types are preset with different questionnaire architectures;

the obtaining module is used for responding to the editing operation of the target questionnaire template and obtaining a plurality of configuration information corresponding to the questionnaire framework;

the storage module is used for respectively storing each configuration information into a corresponding questionnaire information table in the database and receiving current identification information returned by the database; historical configuration information corresponding to all historical questionnaires is stored in each questionnaire information table;

the determining module is used for determining target identification information and respectively extracting corresponding target configuration information from each questionnaire information table of the database according to the target identification information; wherein the target identification information at least comprises the current identification information;

and the generating module is used for combining the target configuration information according to the questionnaire framework to generate a complete questionnaire.

In one embodiment, the extraction module is further configured to:

the storage module is further configured to:

In one embodiment, the questionnaire information table further comprises a score rule table; the storage module is further configured to:

obtaining a scoring rule associated with the dynamic variable;

In one embodiment, the target configuration information comprises target topic information and target score rule information; the generation module is further to:

In one embodiment, the generating module is further configured to:

In one embodiment, the apparatus further comprises an update module configured to:

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the following steps when executing the computer program:

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

In a fifth aspect, the present application further provides a computer program product. The computer program product comprising a computer program which when executed by a processor performs the steps of:

According to the questionnaire generating method, the questionnaire generating device, the computer equipment, the storage medium and the computer program product, the questionnaire template is provided for the user, and corresponding configuration information is obtained; the configuration information is respectively stored in the corresponding questionnaire information tables of the database in a split mode, and compared with a mode that the whole questionnaire is taken as a file to be stored statically in the prior art, the configuration information is more flexibly extracted and stored, and the questionnaire generation efficiency is higher. Meanwhile, when the questionnaire is generated, corresponding configuration information is extracted according to the identification information returned by the database and then combined to generate the complete questionnaire, so that a user can input the configuration information by himself or call the configuration information of other users stored in the database, the multiplexing of different users on the configuration information is realized, and the questionnaire generation efficiency is greatly improved.

Drawings

FIG. 1 is a diagram of an application environment of a questionnaire generation method in an embodiment;

FIG. 2 is a schematic flow chart diagram of a questionnaire generation method in an embodiment;

FIG. 3A is a diagram illustrating the structure of a questionnaire in one embodiment;

FIG. 3B is a flowchart illustrating the steps of the terminal extracting a target questionnaire template corresponding to a questionnaire type in the database in response to a request command containing the questionnaire type in one embodiment;

FIG. 4 is a schematic flow chart of a questionnaire generating method in another embodiment;

fig. 5 is a flowchart illustrating a step in which the terminal combines the target configuration information according to a questionnaire framework to generate a complete questionnaire in one embodiment;

fig. 6 is a schematic flowchart illustrating a step in which the terminal determines, according to a questionnaire framework, target positions of the plurality of filled components in a questionnaire page space, respectively;

FIG. 7 is a schematic flow chart of a questionnaire generating method in yet another embodiment;

FIG. 8 is a flowchart schematically illustrating a questionnaire generating method in still another embodiment;

FIG. 9 is a block diagram showing the configuration of a questionnaire generating apparatus in one embodiment;

FIG. 10 is a diagram showing an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The questionnaire generating method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. The terminal 102 performs data transmission with the server 104 through a communication network. The data storage system may store data that the server 104 needs to process. The data storage system is for example a database. The data storage system may be integrated on the server 104, or may be located on the cloud or other network server. A user designs a questionnaire on a terminal, and the terminal sends the information related to the questionnaire to a server and stores the information by the server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.

In one embodiment, as shown in fig. 2, a questionnaire generating method is provided, which is described by taking the method as an example applied to the terminal in fig. 1, and includes the following steps:

step S202, in response to a request instruction containing a questionnaire type, extracting a target questionnaire template corresponding to the questionnaire type in a database; wherein, different questionnaire frameworks are preset in questionnaire templates of different questionnaire types.

The questionnaire type includes, but is not limited to, one or more of a survey type, an examination type, an evaluation type, a voting type, an entry type, and the like. Different questionnaire templates are preset for different questionnaire types, and different questionnaire architectures are preset for different questionnaire templates. For example, as shown in fig. 3A, a questionnaire may include a plurality of parallel sub-questionnaires, each sub-questionnaire includes topic groups and topics according to levels, at least one topic of the same type or different types is set under each topic group, and each topic has a corresponding option and answer. The questions correspond to different question types respectively, including but not limited to a single-choice question, a multiple-choice question, a main-sub question, a custom question, a blank filling question, an input question and other question types.

The questionnaire template can be set by other users and stored in a database; the questionnaire architecture in the questionnaire template is custom set by the other user. For example, the user a sets a questionnaire template of an "enterprise satisfaction questionnaire" in advance, and the terminal stores the questionnaire template in the database. Then, when the user B needs to generate a questionnaire, for example, after clicking "newly added template", the questionnaire template set by the user a provided on the questionnaire generation interface by the terminal may be selected, so as to generate the questionnaire template of the "enterprise satisfaction questionnaire". Therefore, sharing of the questionnaire template by different users is realized.

It should be noted that the questionnaire generating interface is an interface provided by the terminal and capable of interacting with the user, and is not limited to the form of a web page window/browser page, and may also be visually displayed in the form of an interactive video player, and the like. In addition, the questionnaire generation interface is not limited to one page, and may be a collective name of a plurality of pages. For example, another page that is jumped/generated by clicking a link in the questionnaire generation interface may also be referred to as the questionnaire generation interface. In addition, the questionnaire generation interface may also be referred to as a questionnaire configuration interface, a questionnaire editing interface, and the like.

Specifically, a user performs selection operation on a questionnaire generating interface provided by a terminal, the questionnaire generating interface encapsulates the selection operation of the user into a request instruction, the terminal obtains and analyzes the request instruction, determines the type of the questionnaire selected by the user, and extracts a target questionnaire template corresponding to the type of the questionnaire from a database.

Taking a specific scenario as an example, a user clicks a "new template" button on a questionnaire generation page provided by a terminal, and the terminal displays a plurality of selectable questionnaire types through the page; after receiving a questionnaire type selected by a user through clicking, the terminal displays a plurality of questionnaire templates pre-stored in a database through a page, and determines a target questionnaire template based on selection operation of the user.

In step S204, in response to the editing operation on the target questionnaire template, a plurality of pieces of configuration information corresponding to the questionnaire framework are acquired.

The configuration information includes, but is not limited to, one or more of questionnaire level information, topic group information, topic information, scoring rule information, answer information, and attachment information. The questionnaire hierarchy information refers to the hierarchical relationship between the questionnaire and the sub-questionnaires. The topic group information refers to a group to which a topic belongs. The topic information includes, but is not limited to, one or more of topic content, number of options, option content, and the like.

Specifically, after receiving the target questionnaire template returned by the database, the terminal displays the target questionnaire template to the user in a questionnaire generating page and provides the target questionnaire template for the user to edit. Wherein, the editing operation includes but is not limited to one or more of selection, input, deletion and the like. And after the user edits the corresponding content of each questionnaire hierarchy according to the questionnaire framework in the questionnaire generation interface, the terminal responds to the editing operation of the user on the target questionnaire template and acquires the configuration information input by the user. For example, in a questionnaire generation page, a user inputs a group name in a position corresponding to a topic group, and inputs topic content and answer content in a position corresponding to a topic.

Step S206, storing each configuration information into a corresponding questionnaire information table in the database respectively, and receiving current identification information returned by the database; each questionnaire information table stores history configuration information corresponding to all history questionnaires.

The database stores a plurality of questionnaire information tables, and the types of the questionnaire information tables include but are not limited to one or more of questionnaire tables, questionnaire detail tables, group question tables, score rule tables, parameter tables, answer detail tables, answer attachment tables and the like.

And according to the difference of the questionnaire frameworks corresponding to the configuration information, the terminal correspondingly stores the configuration information into different questionnaire information tables in the database. In some embodiments, questionnaire level information is stored in a questionnaire table, topic group information is stored in a group table, and topic information is stored in a topic table; the questionnaire table is associated with the group table through questionnaire identification information; the group table is associated with the topic table through topic identification information. Illustratively, the questionnaire identification information is, for example, a questionnaire number, the topic identification information is, for example, a topic number, and the like. More, store questionnaire details information into questionnaire details table, store score rules information into score rules table, store answer information into answer table, store answer details into answer details table, and store attachments into answer attachments table, etc.

It should be understood that the questionnaire information table and the corresponding configuration information in the embodiment of the present application may be changed according to actual questionnaire generation requirements, and for example, the questionnaire information table may further include picture information and needs to be stored in a picture table of a database, and the like. Accordingly, any suitable modifications or variations thereof, which would be apparent to persons skilled in the art based on the foregoing examples, are intended to be included within the scope of the present application.

Specifically, after acquiring a plurality of configuration information, the terminal stores each configuration information into a corresponding questionnaire information table according to the mapping relationship between the configuration information and the questionnaire information table. And after the terminal stores each configuration information into the corresponding questionnaire information table, the database returns a plurality of current identification information corresponding to each configuration information. Wherein the identification information characterizes the location of the configuration information stored in the corresponding questionnaire information table. Different configuration information has different identification information. For example, the title group information is stored in a group table of the database, and the group number is used as the identification information. For another example, the title information is stored in a title table of the database, and the title number is used as the identification information. In a specific scenario, the terminal stores the topic group information into a group table in the database, and returns a group number to indicate that the topic group information is stored in a storage space corresponding to the group number in the group table.

Each questionnaire information table also stores history arrangement information corresponding to all history questionnaires. The historical questionnaire refers to a complete questionnaire which is configured by other users before and is generated through a terminal, and corresponding configuration information is historical configuration information. In order to facilitate sharing of questionnaire related information among different users, when each user configures questionnaires, the terminal respectively stores the completed configuration information into corresponding questionnaire information tables according to the mapping relation between the configuration information and the questionnaire information tables; compared with the mode that the whole questionnaire is taken as one file to be statically stored in the prior art, the configuration information is more flexibly extracted and stored, and the questionnaire generation efficiency is higher. Meanwhile, the configuration information of the questionnaire is split and stored in different tables of the database, so that the multiplexing of different users on the configuration information is realized.

For example, when the user edits the target questionnaire template, historical configuration information preset by other users can be extracted from the database. For example, when a user edits a certain radio topic, the configured topic content and answer content provided by other users on the questionnaire generating interface through the terminal are directly selected and added to the current questionnaire template, so that the user does not need to repeatedly input configuration information, and the questionnaire generating efficiency is improved.

It should be noted that, in the process of editing the target questionnaire template by the user to configure the questionnaire, the terminal does not store the configuration information, but synchronizes the configuration information to the database in real time, or transmits the configuration information to the database to be stored after the user completes configuration. Therefore, after the user completes the configuration of the questionnaire, the terminal needs to extract corresponding configuration information from the database for combination, and generate a final complete questionnaire through the rendering of the page component. Accordingly, the terminal performs the following steps.

Step S208, determining target identification information, and respectively extracting corresponding target configuration information from each questionnaire information table of the database according to the target identification information; wherein the target identification information at least comprises current identification information.

If the user does not extract the historical configuration information stored in the database, that is, the user only inputs the configuration information by himself, the target identification information is the current identification information corresponding to the configuration information input by the user. If the user refers to historical configuration information besides configuration information input by the user, the target identification information comprises historical identification information and current identification information corresponding to the historical configuration information.

Specifically, the terminal determines target identification information corresponding to the edited questionnaire, and extracts corresponding target configuration information according to a storage position indicated by the target identification information in each questionnaire information table of the database. Corresponding to the identification information, the target configuration information includes configuration information configured by the user, and besides, may also include historical configuration information configured by other users.

For example, the terminal extracts, according to the group number a and the topic number B, topic group information a corresponding to the group number a from a group table of the database, and extracts, from the topic table, topic information B corresponding to the topic number B, thereby extracting configuration information input by the user in the configuration process. For another example, the terminal extracts, according to the group number a and the topic number B, topic group information a corresponding to the group number a and input by the user in the configuration process from a group table of the database, and extracts, from the topic table, historical topic information B corresponding to the topic number B and configured by other users in the database called by the terminal.

Step S210, combining the target configuration information according to a questionnaire framework to generate a complete questionnaire.

Specifically, after the terminal acquires each target configuration information, the terminal combines each target configuration information according to a position preset by a questionnaire framework on a questionnaire generation interface, and finally generates a complete questionnaire.

In the questionnaire generating method, the questionnaire template is provided for the user, and corresponding configuration information is obtained; the configuration information is respectively stored in the corresponding questionnaire information tables of the database in a split mode, and compared with a mode that the whole questionnaire is taken as a file to be stored statically in the prior art, the configuration information is more flexibly extracted and stored, and the questionnaire generation efficiency is higher. Meanwhile, when the questionnaire is generated, corresponding configuration information is extracted according to the identification information returned by the database and then combined to generate the complete questionnaire, so that the user can input the configuration information by himself or call the configuration information of other users stored in the database, and the multiplexing of different users on the configuration information is realized.

In one embodiment, as shown in fig. 3B, the step of, in response to the request command containing the questionnaire type, the terminal extracting the target questionnaire template corresponding to the questionnaire type from the database includes:

step S302, a request instruction is obtained, and the questionnaire type carried in the request instruction is extracted.

Specifically, a user performs selection operation on a questionnaire generation interface provided by the terminal, and the questionnaire generation interface encapsulates the selection operation of the user into a request instruction. And the terminal acquires and analyzes the request instruction, and extracts the related information of the questionnaire type carried in the request instruction so as to determine the questionnaire type selected by the user.

Step S304, based on the questionnaire type, at least one candidate questionnaire template corresponding to the questionnaire type is determined in a plurality of historical questionnaire templates stored in the database.

In the database, a large number of questionnaire templates of various questionnaire types may be stored, which are generated and stored for the terminal based on editing operations by other users. For one questionnaire type, a plurality of different questionnaire templates may be stored in the database in advance.

Specifically, after determining the questionnaire type selected by the user, the terminal determines one or more candidate questionnaire templates corresponding to the questionnaire type from a plurality of historical questionnaire templates stored in the database, so that the user can select among the candidate questionnaire templates.

Step S306, responding to the selection operation, determining a target questionnaire template in at least one candidate questionnaire template.

Specifically, a user selects from a plurality of candidate questionnaire templates displayed on the questionnaire generation interface, and after selection, the terminal detects a detection operation. The terminal responds to the selection operation, and determines one candidate questionnaire template in the at least one candidate questionnaire template as a target questionnaire template.

In the embodiment, the target questionnaire template is selected based on the selection operation of the user in a large number of questionnaire templates stored in the database, so that the user does not need to manually configure the questionnaire templates one by one, and the configured templates of other users can be directly referred to, thereby realizing the sharing and multiplexing of the questionnaire templates.

In the question types of questionnaires, the gap filling questions may require more complex calculations and therefore a corresponding configuration. Generally, in the prior art, by means of generating a static questionnaire file, since all of the questionnaire display and interaction control logics have static pages, the questionnaire generation requirement with high logic high calculation cannot be fulfilled. Even if time and energy can be consumed, variables are predefined for each topic one by one, and a calculation rule is embedded into each topic respectively so as to achieve the purpose of supporting the calculation of a complex rule, the method also needs personnel with front-end technical knowledge, not only is the cost high and the time consuming long, but also the sharing among different users and the reuse of the existing resources of a database cannot be realized.

Therefore, in an embodiment, as shown in fig. 4, the questionnaire generating method provided by the present application further includes:

step S402, responding to the input operation, and determining the input content conforming to the variable identification rule as a dynamic variable.

In step S404, a scoring rule associated with the dynamic variable is obtained.

Step S406, storing the score rule into a score rule table in a database; the scoring rule table is associated with the topic table through topic identification information.

The variable identification rule refers to a predefined rule for indicating the position of the variable. For example, it is predefined that when an input character string is in a specific format, the character string in the specific format is recognized as a dynamic variable.

Specifically, the terminal acquires the input content of the user based on the input operation of the user on the questionnaire generation page for the blank question type. When the input content does not accord with the variable identification rule, the terminal outputs the input content as a text; and when the input content conforms to the variable identification rule, the terminal determines the input content as a dynamic variable. Then, based on the input operation of the user, the terminal acquires the score rule associated with the dynamic variable and stores the score rule into a score rule table in the database. To indicate which topic the score rule corresponds to, the score rule table is associated with the topic table by topic identification information.

In a specific scenario, when the user edits the gap-filling question, if the edited character string conforms to the variable recognition rule of "____ [ a ]" (four underlines and [ lower case english alphabet ]), after the user clicks and saves the gap-filling content, the terminal recognizes the character string, and then determines the character string as the dynamic variable a. When the user floats to the position by using a mouse, the value of the dynamic variable A can be edited, the filling attribute is controlled to be in a digital or date format and the like, whether a default value exists or not is confirmed, namely, a specific code is generated and bound for the dynamic variable A, and then the data corresponding to the code in the database is read. In addition, the user may also select the fill authority role so that only a portion of the population may modify the value of the dynamic variable a. Thus, the dynamic variables in the gap filler may be any number and occur at any location within the gap filler. According to the variable identified in the gap filling question, the user can add a rule condition to the gap filling question. For example, clicking on "add score condition" selects variables, operators, and logics to compose the final score rule.

In this embodiment, by setting the variable identification rule for the gap filling question, the variable of the gap filling question can be set arbitrarily and support more complex calculation, the user use is not limited by a technical threshold, and sharing among different users and reuse of existing resources of the database can be realized.

In some embodiments, in a scenario where after the generation of the questionnaire is completed and other users answer the questionnaire, when the terminal acquires the questionnaire, the terminal simultaneously acquires the calculation rules of all the questions, and the calculation rules of all the questions form a score rule group. After a user finishes a question, the value corresponding to the variable and the scoring rule group corresponding to the question are transmitted to the background, and the background calculates the score. Simple questions such as the single-choice question, the multiple-choice question, the user-defined question and the like can obtain the final score through 'complete matching' according to the selected options, the corresponding score mode (deduction or score) and the maximum grading factor. For the gap filling questions of the combination (R1, R2, R3) of the score rules related to a plurality of variables (A, B, C, D), a plurality of rules in the score rule group are a union R1| | | R2| | | R3 (mutual exclusion between the rules is ensured by a user during configuration), and according to the sequence of the set rules, when the previous conditions are met, the scores under the rules are preferentially returned. For example, R1 is an inequality logic calculation, such as "1 < a + b < 5". The terminal analyzes the character string of the incoming score rule ' 1< a + b <5 ', if the analyzed data is any one of the numbers, inequalities ' < ', ' > ', ', and ', calculation symbols ' + ', ' - ', ', ' and brackets ' (', '), the calculated priority rule is calculated according to the priority rule of the four arithmetic operations, and the calculation is performed from left to right, firstly in the brackets, and then is performed by multiplication and division and then is performed by addition and subtraction.

Often, when generating a questionnaire, a visual presentation is required to the user. Therefore, in some embodiments, as shown in fig. 5, the step of combining, by the terminal, the target configuration information according to a questionnaire architecture to generate a complete questionnaire includes:

step S502, filling the target topic information and the target score rule information of the same topic into the same component.

Step S504, according to the questionnaire framework, determining the target positions of the filled multiple components in the questionnaire page space respectively.

Step S506, rendering is performed at corresponding target positions in the questionnaire page space based on the plurality of components, respectively, to generate a complete questionnaire.

Specifically, the terminal is provided with a plurality of components in advance, and when a questionnaire is generated, topic information and score rule information belonging to the same topic are filled into the same component in a questionnaire generation page. To distinguish from other topic information and score rule information used to populate other components, topic information and score rule information populated to a component are referred to as target topic information and target score rule information. Wherein the questionnaire framework specifies in advance a default topic/topic group order, and accordingly determines the initial positions of the various components. Under the condition that a user does not move the positions of all the components, after each topic in the questionnaire is correspondingly filled to the corresponding component, the terminal determines the target positions of the filled components in the questionnaire page space respectively according to the questionnaire framework, and renders the target positions in the questionnaire page space respectively based on the components to generate the complete questionnaire.

In the embodiment, the terminal utilizes the assembly to render and generate the complete questionnaire, and the configured questionnaire can be visually displayed for the user, so that the user can have good use experience.

In order to further reduce the operation difficulty and improve the use experience of a user, the questionnaire generating method provided by the application can also support the customization of page layout, can not only customize group sequencing and topic sequencing, but also support the modification of style or spatial position layout on all topics in the whole questionnaire space in a dragging mode. In an embodiment, the entire questionnaire space can be viewed as a custom meshed coordinate space consisting of an infinite number of grids (minimum granularity in the questionnaire layout), each topic type is broken up into finer-grained component elements, and all elements can be defined by the minimum-grained grid, each coordinate moving equal to the size of the minimum-grained network. Therefore, when the title layout is newly added (edited), it is necessary to check whether the dragged space is already occupied by other elements or there is a case that some elements are occupied, and if the space is not occupied, each of the newly added titles is initialized according to the initial style, and the titles are arranged at the specified spatial positions and are arranged according to the initialization style of the titles. Otherwise, the information is automatically arranged in a blank position (a position of the full subject space size including the unoccupied space) in the space. When the layout of the questionnaire is stored, the styles of all questions of the questionnaire are respectively stored in a style sheet and are associated with the questions through the question numbers.

Accordingly, in some embodiments, as shown in fig. 6, the step of determining, by the terminal according to the questionnaire framework, the target positions of the filled multiple components in the questionnaire page space respectively includes:

step S602, determining the initial positions of the components in the questionnaire page space according to the questionnaire architecture.

Step S604, obtaining coordinate values and grid granularity of the initial grid occupied by the component to be moved, and obtaining coordinate values of the target grid based on the moving operation of the user.

Step S606, calculating whether the grid space corresponding to the coordinate value of the target grid can accommodate the grid granularity of the initial grid.

Step S608, if the grid granularity of the initial grid can be accommodated, the to-be-moved component is moved from the initial position to the target position according to the coordinate values of the initial grid and the coordinate values of the target grid.

As a result, the questionnaire framework pre-defines the default topic/topic group order, and accordingly determines the initial positions of the various components. Specifically, the terminal determines the initial positions of the components in the questionnaire page space according to the default positions specified by the questionnaire framework. When a user selects a component and drags the component, the terminal firstly obtains the coordinate value and the grid granularity of the initial grid occupied by the component to be moved, and obtains the coordinate value of the target grid based on the moving operation of the user. Then, the terminal calculates whether the grid space corresponding to the coordinate value of the target grid can accommodate the grid granularity of the initial grid. And if the grid granularity of the initial grid can be accommodated, the terminal moves the component to be moved from the initial position to the target position according to the coordinate values of the initial grid and the target grid.

In a specific scene, any component on each question type is initialized to a certain multiple of a rectangular frame (the question type can be normally unfolded), namely, a default style is provided, and on the basis of the initialization, the question type is added into a questionnaire space, and then the size of the question type can be changed up, down, left, right and the like, so that the style of the question type can be customized. The configured questionnaire template can be understood as an entire questionnaire page space. The length and width of the questionnaire page space can be continuously expanded along with the expansion of the configured content. The whole questionnaire page space is used as the minimum granularity according to a self-defined pixel rectangular frame, so that the whole questionnaire page space becomes a self-defined gridding space to form a new coordinate system. Each question type is arranged in the space by taking the upper left corner as the gravity center and the space actually occupied by the question type in the dragging process. Each topic would record specific coordinates. As mentioned above, each topic stores its coordinates and how many grid spaces of minimum granularity correspond. Therefore, according to the coordinate starting point and the number of spaces with the minimum granularity, whether the position to which the user wants to move can accommodate the currently dragged component can be calculated. However, if the position of the component to be dragged is already provided with other components, that is, the space is occupied, the terminal moves to the right to search for the unoccupied space position capable of accommodating the component, and then the space position is occupied, and the terminal can be manually adjusted to a specific position.

In the embodiment, the layout customization of the page layout is supported, the layout of all questions in the whole questionnaire space is changed in a dragging mode, the style of the whole questionnaire is greatly enriched, and the questionnaire generation is completed by a common user in a graphical page configuration mode, so that the operation is simplified, and the questionnaire configuration threshold is reduced

In one embodiment, as shown in fig. 7, the questionnaire generating method provided by the present application further includes:

step S702, in response to the update operation, determines the identification information to be updated.

Step S704, extracting the configuration information to be updated corresponding to the identification information to be updated from the questionnaire information table of the database, so as to be displayed in the configuration interface for the user to update.

Step S706, the updated configuration information is obtained, and the corresponding questionnaire information table in the database is updated based on the corresponding identification information.

Specifically, when the user needs to update the configuration information, the terminal determines the configuration information that the user needs to update in response to the update operation of the user on the questionnaire generation page, so as to determine the identification information corresponding to the configuration information to be updated, which is called as the identification information to be updated. For example, if the user selects the option of the single topic a, the terminal determines that the configuration information to be currently edited is topic information, and thus determines the identification information (for example, topic number a) corresponding to the topic information. And then the terminal extracts the configuration information to be updated corresponding to the identification information to be updated from the questionnaire information table of the database so as to be displayed in a configuration interface for the user to update. And after the user finishes updating, the terminal acquires the updated configuration information again, and updates the corresponding configuration information in the corresponding questionnaire information table in the database based on the corresponding identification information.

In the embodiment, each configuration information is stored in a database in a split manner, so that when a user needs to modify or add or delete, only the corresponding configuration information needs to be extracted, the whole questionnaire does not need to be extracted and edited again, and then the questionnaire is regenerated, and the generation efficiency of the questionnaire is improved.

In the embodiment of the application, various questionnaire information tables set by the database can be set according to actual requirements. For example, a questionnaire table, a questionnaire list table, a group table, and a group question table may be set; a question table (a question library is formed by a question collection), a score rule table (a blank filling question), and a parameter table (used for setting the blank filling in the blank filling question, including whether to read a default value and the like); answer sheet, answer detail sheet, answer attachment sheet.

The questionnaire table stores main information of the questionnaire, including template information of the questionnaire (questionnaire name, questionnaire year, questionnaire enterprise type, maximum value of the questionnaire, minimum value of the questionnaire, credit rating of the questionnaire), questionnaire issue state information (issue start time, issue end time, issue designated time), and the like. The questionnaire list stores sub-questionnaire information of the questionnaire, including sub-questionnaire types, sub-questionnaire states, and the like. And the questionnaire numbers are associated with the questionnaire table. The group table stores group main information of the questionnaire, including a group name of the questionnaire. The questionnaire list is associated with the questionnaire list number. The group topic table stores topic ranking information in groups of the questionnaire. And associating with the group list and the title list respectively through the group number and the title number. The topic table stores valid topics for the entire questionnaire system. The topic table comprises topic titles, topic total scores, topic question types (single selection, multiple selection, blank filling, user-defined questions, main and auxiliary questions and the like), topic descriptions, whether to upload attachment identifications, whether to self-score identifications, sorting, scoring rules (adding scores, subtracting scores and subtracting the total scores of the questions, subtracting the total scores of questionnaires) and topic content numbers. And associating according to the title numbers of the group title table. The content table stores the content information of the title, including title content, score and sequencing. And associating with the title table through the title number. The parameter table stores the configuration of the blank filling options of the blank filling question, and the configuration comprises symbols, control blank filling field types (namely, whether the current blank filling is a number or a date), control blank filling authorities (namely, the current blank filling is performed by different authority roles), control whether the blank filling has default values, operation authorities and the like. The association is made with the table of contents by the content number. The scoring rule table stores logic calculation rules, rule types (condition scores and calculation scores), sorting, and inequality operations of addition, subtraction, multiplication and division, AND or NOR logic operation, and the like in the space filling variables of the space filling questions. And the association is carried out through the content number and the content table (the combination of a plurality of scoring rules exists in a single theme, and the logic calculation realization of the complex theme is ensured). The answer table stores the main information of the answers of a certain questionnaire, including the total score of the answers, the credit rating, the questionnaire flow state (the current auditing flow node is stored in the questionnaire flow state because the credit rating questionnaire of an enterprise needs to be audited in multiple layers), the business flow number and the questionnaire type. The answer detail list stores the detailed information of the answer, including the answer content, the answer content description and the remarks. Associating with a topic table according to topic numbers, associating with a topic table according to topic numbers (if the topic numbers exist, the current topic is a secondary topic), associating with an answer table according to questionnaire answer numbers, associating with a questionnaire detail table according to questionnaire numbers, and associating with a business process table according to business process numbers (questionnaire answers can be answered in different processes of a business, and multiple answers are allowed to exist, so that different answer records are distinguished according to the business process numbers). The answer attachment table stores attachment related contents uploaded by the answer, including an attachment name and an attachment path address (the attachment is actually stored on the file server). And associating the number of the questionnaire answer detail list with the questionnaire answer detail list.

In the embodiment of the application, a plurality of initialized question type templates are provided for the questionnaire system, and the plurality of question types comprise a single-choice question, a multi-choice question, a blank filling question, a main-side question, a user-defined question and the like, and the question types are allowed to be expanded and supplemented. The title comprises a theme (theme stem), a score calculation index description, title contents, all question types, a highest score and a score mode, wherein the theme comprises the theme (theme stem), the score calculation index description, whether materials need to be uploaded for auxiliary verification and the highest score and the score mode of the theme, and the score mode is divided into a score mode and a deduction mode. The main and sub-questions allow multiple types of questions to be combined. Generally, the method has a single choice question as a theme, and binds other configured question types for each option as a secondary question. Thus, different choice options are selected according to the theme, corresponding to different subtopics. The problem type with precondition can be satisfied. The gap filling questions allow to increase variables at any position, the gap filling questions identify the whole question contents through the front end of the terminal, and the variables meeting the variable definition in the gap filling contents in the configuration process are identified, so that the automatic generation and binding of the dynamic variables are completed. In addition, the gap filling questions allow editing of gap filling variables, the authority of the variables can be set, only users who accord with the authority can assign values to the variables, and the input types of the current questions can be configured to be numerical values or dates; the method can bind the variables of background data of the terminal for the variables, and is used for dynamically configuring default values of the variables. In particular, the gap filling question is allowed to bind a plurality of rules, supports multivariable addition, subtraction, multiplication, division, mixing calculation, and NOR logic calculation and the like, and can simultaneously carry out configuration equality or inequality rules on a plurality of variables. And storing each calculation rule in a defined score rule table, and associating the calculation rule with the title content table through a content number. When the score calculation of the question needs to be carried out, after all current blank filling is input at the front end of the terminal, namely the front end of the terminal automatically triggers the blank filling question score calculation method after the cursor focus leaves, all input data are packaged into the calculation rule of the configuration variables together by the front end of the terminal, and are transmitted to the background of the terminal in the character string paradigm. And the background of the terminal predefines a set of calculation templates through self-defined analysis classes, analyzes the operation expression converted from the front-end configuration of the terminal, fills the analyzed symbols into the templates, completes the identification of the symbols, performs questionnaire topic score calculation according to the analyzed priority rule, and returns the configured score to the rule meeting the calculation rule (inequality logic calculation).

In a specific embodiment, as shown in fig. 8, when a new questionnaire needs to be generated, taking an enterprise credit rating as a topic questionnaire as an example, the interaction flow between the front end and the back end of the terminal and the database is as follows:

a questionnaire is added first, template information (e.g., template name) is edited, and then the questionnaire template is saved. And adding a new sub-questionnaire, and rendering an empty credit evaluation sub-questionnaire by the terminal to wait for the configuration of the user. For an empty questionnaire, the first step is to add a topic group. Thus, the user clicks on the additional topic group, adds the topic group, and edits the topic group information (e.g., enters the topic of the topic group). And then after clicking and storing, the terminal stores the question group information into the database, writes the information into the questionnaire group list after the storage is finished, and simultaneously returns the question group information to the front-end group number. The questionnaire is now presented with an empty questionnaire containing only group names. At this point copying, editing and deleting of the group may be allowed. Then click to edit the question group, and add the question. And clicking the newly added title by the user, editing the title information and storing the title information. For a radio topic, for example, multiple radio options, including option content, and scores, may be added in sequence. The front end adds a blank question type according to a predefined good question type component, the styles and contents of different question type renderings are different, but the common part comprises a main question, an index description, a scoring mode, a highest score, certification materials needing to be uploaded and the like. And after clicking the storage questions, storing the single-selection questions into a database. At this time, whether to continue editing the added title is judged. If so, returning to the step of adding the new topic and continuing to execute. If not, the question group is stored, namely the parameters are the questionnaire number, the group number and the question number, and the parameters are the number of the group question table. At this time, it is judged whether to continue editing the add topic group. If so, returning to the step of adding the new topic group and continuing to execute. If not, the questionnaire is saved, and whether to continuously edit the questionnaire is judged. If so, returning to the step of adding a new sub questionnaire and continuing to execute. If not, the questionnaire is issued, the user is provided with a preview of the questionnaire on the interface, and the whole process is ended. Thereby, questionnaire generation based on user configuration is achieved.

The method comprises the steps of designing a database related to the questionnaire, storing edited questionnaire related information in the database, combining data read from the database according to the architecture of the questionnaire, and dynamically generating the questionnaire by combining a predefined basic component. Meanwhile, the application provides a plurality of initialized question type templates, which comprise a plurality of question types such as single-choice questions, multiple-choice questions, blank filling questions, main and auxiliary questions, user-defined questions and the like, and the question types are allowed to be expanded and supplemented. In particular, the gap filling in the application supports automatic generation and binding of dynamic variables, can be a variable binding calculation rule, supports multivariable addition, subtraction, multiplication, division, hybrid calculation, AND or NOR logic calculation and the like, and provides strong logic calculation capability for questionnaires. In addition, the method and the device also support customization of page layout, change of layout on the spatial position of the questions by means of dragging in the whole questionnaire space, greatly enrich the style of the whole questionnaire, and support the completion of questionnaire generation by a common user in a graphical page configuration mode, thereby simplifying operation and reducing questionnaire configuration threshold.

It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the present application further provides a questionnaire generating device for implementing the above-mentioned questionnaire generating method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the above method, so specific limitations in one or more embodiments of the questionnaire generating device provided below can be referred to the limitations on the questionnaire generating method in the above, and details are not described here.

In one embodiment, as shown in fig. 9, there is provided a questionnaire generating apparatus 900 comprising: an extracting module 901, an obtaining module 902, a storing module 903, a determining module 904, and a generating module 905, wherein:

an extracting module 901, configured to, in response to a request instruction including a questionnaire type, extract a target questionnaire template corresponding to the questionnaire type in a database; wherein, different questionnaire frameworks are preset in questionnaire templates of different questionnaire types.

An obtaining module 902, configured to obtain a plurality of configuration information corresponding to the questionnaire framework in response to an editing operation on the target questionnaire template.

A storage module 903, configured to store each configuration information into a corresponding questionnaire information table in the database, and receive current identification information returned by the database; each questionnaire information table stores history configuration information corresponding to all history questionnaires.

A determining module 904, configured to determine target identification information, and extract corresponding target configuration information from each questionnaire information table of the database according to the target identification information; wherein the target identification information at least comprises current identification information.

A generating module 905, configured to combine the target configuration information according to a questionnaire framework, so as to generate a complete questionnaire.

The above-described questionnaire generation device may be implemented in whole or in part by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 10. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a questionnaire generating method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the architecture shown in fig. 10 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is further provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method embodiments when executing the computer program.

In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

In an embodiment, a computer program product is provided, comprising a computer program which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

It should be noted that the configuration information (i.e. questionnaire-related information) and data (including but not limited to data for analysis, stored data, presented data, etc.) of the user referred to in the present application are both information and data authorized by the user or sufficiently authorized by each party.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. A questionnaire generation method, characterized in that the method comprises:

2. The method according to claim 1, wherein the extracting, in response to the request instruction containing the questionnaire type, the target questionnaire template corresponding to the questionnaire type in the database comprises:

3. The method of claim 1, wherein the configuration information comprises at least one of questionnaire level information, topic group information, and topic information; the questionnaire information table at least comprises one of a questionnaire table, a group table and a question table;

4. The method of claim 3, wherein the questionnaire information table further comprises a scoring rule table; the method further comprises the following steps:

obtaining a scoring rule associated with the dynamic variable;

5. The method of claim 1, wherein the target configuration information comprises target topic information and target score rule information; the step of combining the target configuration information according to a questionnaire framework to generate a complete questionnaire comprises the following steps:

6. The method of claim 5, wherein the questionnaire page space is comprised of a grid; determining the target positions of the filled components in the questionnaire page space respectively according to the questionnaire architecture, wherein the target positions comprise:

7. The method according to any one of claims 1 to 6, further comprising:

8. A questionnaire generating apparatus, characterized in that the apparatus comprises:

9. The apparatus of claim 8, wherein the extraction module is further configured to:

10. The apparatus of claim 8, wherein the configuration information comprises at least one of questionnaire level information, topic group information, and topic information; the questionnaire information table at least comprises one of a questionnaire table, a group table and a question table;

the storage module is further configured to:

11. The apparatus of claim 10, wherein the questionnaire information table further comprises a scoring rule table; the storage module is further configured to:

obtaining a scoring rule associated with the dynamic variable;

12. The apparatus of claim 8, wherein the target configuration information comprises target topic information and target score rule information; the generation module is further to:

13. The apparatus of claim 12, wherein the generating module is further configured to:

14. The apparatus according to any one of claims 7 to 12, wherein the apparatus further comprises an update module configured to:

15. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.

16. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.

17. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 7 when executed by a processor.