CN109597979B - List table generation method and device, computer equipment and storage medium - Google Patents
List table generation method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109597979B CN109597979B CN201811435465.4A CN201811435465A CN109597979B CN 109597979 B CN109597979 B CN 109597979B CN 201811435465 A CN201811435465 A CN 201811435465A CN 109597979 B CN109597979 B CN 109597979B
- Authority
- CN
- China
- Prior art keywords
- data information
- list
- target
- tab
- sub
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The application relates to a list table generating method, a list table generating device, computer equipment and a storage medium. The method comprises the following steps: when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction; acquiring target data information contained in the target list, and identifying and determining a category attribute corresponding to the target data information; and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information. By adopting the method, the target list can be completely exported to generate and obtain the corresponding list table, and the corresponding incidence relation is stored among the data information in the obtained list table, so that the format setting of the list table is not required again.
Description
Technical Field
The present application relates to the field of building engineering data processing technologies, and in particular, to a method and an apparatus for generating a list table, a computer device, and a computer-readable storage medium.
Background
In the construction industry, there are already a number of pricing and cost management systems available through which users can make work lists and manage costs. However, since the popularity of pricing software is not as high as that of electronic office software such as Excel, a list compiled by pricing software is generally required to be exported for use.
In the pricing software and the cost management system existing in the market at present, when a list is exported, an obtained table can only meet the function of data viewing, and information such as a calculation formula, a data association relation and the like preset in the pricing system and the cost management software cannot be exported. Due to the incomplete derived form, when the user obtains the derived form, the user needs to reset the corresponding format information in the form to perform corresponding operation.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a method, an apparatus, a computer device, and a storage medium for generating a manifest table, which can completely derive the manifest table.
A method of manifest table generation, the method comprising:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in the target list, and identifying and determining a category attribute corresponding to the target data information;
and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information.
In one embodiment, the method further comprises the following steps:
and acquiring control information contained in the list generation instruction, and inquiring in a preset list database based on the list identification contained in the control information to obtain a target list corresponding to the list identification.
In one embodiment, the method further comprises the following steps:
generating and obtaining a corresponding homepage signing form based on target data information contained in the target list;
generating and obtaining a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list;
and summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list.
In one embodiment, the method further comprises the following steps:
and reading target data information contained in the target list, acquiring editable data information with the category attribute being an editable category in the target data information, and summarizing and de-reproducing the editable data to generate a homepage tab form containing the editable data information.
In one embodiment, the method further comprises the following steps:
based on tab information contained in a target list, reading data information associated with a target tab from target data information, and acquiring fixed data information of which the category attribute is a fixed category in the data information associated with the target tab;
acquiring a preset list form template, and determining first position information of the fixed data information in the list form template;
and importing the fixed data information into the list form template based on the first position information to generate and obtain a sub-tab form corresponding to the target tab.
In one embodiment, the method further comprises the following steps:
acquiring calculation data information of which the category attribute is a calculation category in the data information contained in the target tab;
determining a calculation rule corresponding to the calculation data information, and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule;
and determining second position information of the calculation data information in a corresponding sub-page table, and importing the calculation rule to a position corresponding to the second position information.
In one embodiment, the method further comprises the following steps:
acquiring a data identifier contained in the sub-tab form, and acquiring data information to be imported corresponding to the data identifier in the main tab form based on the data identifier so as to import the data information to be imported into the sub-tab form;
and when the data information in the main tab table is modified, acquiring the data identifier of the modified data information, and updating the data of the sub tab table containing the data identifier.
An inventory table generation apparatus, the apparatus comprising:
the list acquisition module is used for acquiring a corresponding target list based on the control information contained in the list table generation instruction when the list table generation instruction is received;
the attribute determining module is used for acquiring target data information contained in the target list and identifying and determining the category attribute corresponding to the target data information;
and the table generating module is used for generating and obtaining a list table corresponding to the target list based on the category attribute corresponding to the target data information.
A computer device comprising a memory storing a computer program and a processor implementing the following steps when the computer program is executed:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in the target list, and identifying and determining a category attribute corresponding to the target data information;
and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in the target list, and identifying and determining a category attribute corresponding to the target data information;
and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information.
According to the list table generation method, the list table generation device, the computer equipment and the storage medium, when a list table generation instruction is received, a corresponding target list is obtained according to control information contained in the received list table generation instruction, then data information contained in the target is obtained, the category attribute corresponding to the obtained data information is identified and determined, and finally a list table corresponding to the target list is generated and obtained according to the category attribute to which the data information respectively belongs. The method and the device realize that in the process of generating the list table, the category attribute corresponding to the data information contained in the target list is firstly identified, and then the list table of the target list is generated according to the category attribute of the data information, so that the data information in the generated list table has a corresponding incidence relation, and the data information in the list table does not need to be reestablished.
Drawings
FIG. 1 is a diagram of an application environment of a manifest table generation method in one embodiment;
FIG. 2 is a flow diagram illustrating a method for generating a manifest table in one embodiment;
FIG. 3 is a flowchart illustrating the steps of generating a manifest table in one embodiment;
FIG. 4 is a flowchart illustrating the steps of generating a sub-tab table in one embodiment;
FIG. 5 is a flowchart illustrating the steps of generating a sub-tab table in another embodiment;
FIG. 6 is a block diagram showing the construction of a manifest table generating apparatus in one embodiment;
FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more clearly understood, the present application is further described in 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 list table generation method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. When receiving the list table generation instruction, the terminal 102 sends the list table generation instruction to the server 104, so that the server 104 obtains a corresponding target list according to control information included in the list instruction table generation instruction, then reads target data information included in the target list, identifies a category attribute corresponding to the target data, generates a list table corresponding to the target list according to the category attribute corresponding to the target data, and finally, the terminal 102 obtains the list table generated by the server 104. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In an embodiment, as shown in fig. 2, a list table 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:
The list table generation instruction is a control instruction for generating the list table. The control information is instruction information carried in the list table generation instruction except the list table generation instruction. The target list is the basis for obtaining the list table.
When a terminal receiving end arrives at a list table generation instruction, control information contained in the list table generation instruction is identified and acquired, and then a target list corresponding to the list table generation is acquired according to the acquired control information, wherein the control information contains identification information of the list generated by the list table. Specifically, when receiving a list generation instruction, the terminal identifies a list identifier contained in control information contained in the list generation instruction, and then performs query matching in a preset list database based on the list identifier to obtain a target list corresponding to the list identifier.
It should be noted that the instruction for generating the list form is triggered based on the corresponding operation performed by the user on the terminal, and may be a virtual key for generating the list form by touching a representative on a display interface of the terminal, and the specific instruction triggering manner is not limited.
The category attribute is a category feature of the data information, and corresponding association exists between data corresponding to different category attributes.
Specifically, after obtaining the target list, the terminal reads the data information included in the target list, and identifies and determines the category attribute corresponding to the data information included in the target list. In practical application, when the list table generation instruction is triggered, the terminal queries from a preset list database with an engineering quantity list according to control information contained in the list table generation instruction to obtain a corresponding target list, reads data information contained in the target list, and identifies a category attribute corresponding to the data information.
For a list of engineering quantities, the category attributes of the data information contained in the list are generally classified into editable categories, fixed categories, and calculation categories. The data information corresponding to the editable category is data information which can be edited and modified by a user, the data information corresponding to the fixed category is data information which exists in a list and has unchangeable information, such as attribute information of an item number, an item name, item feature description, a unit, engineering quantity and the like, and the data corresponding to the calculation category is obtained based on the data corresponding to the editable category, namely the data corresponding to the calculation category carries a corresponding data information calculation rule.
And step 206, generating a list table corresponding to the obtained target list based on the category attribute corresponding to the data information.
The list form is a downloadable electronic document, such as Excel or other office software capable of performing form editing.
Specifically, after obtaining the target list and identifying and determining the category attribute of the data information included in the target list, the terminal generates a list table corresponding to the obtained target list according to the category attribute corresponding to the data information. The data information included in the target list has a certain association relationship, for example, a certain calculation relationship exists between the data information of which the category attribute is the calculation category and the data information corresponding to the editable category, the attribute information belonging to the calculation category is obtained according to a corresponding data calculation rule based on the data information corresponding to the editable category, and a corresponding correspondence relationship exists between the data information belonging to the fixed category and the data information of the editable category as well as the data information of the calculation category.
In the list table generating method, when a list table generating instruction is received, a corresponding target list is obtained according to control information contained in the received list generating instruction, then data information contained in the target is obtained, category attributes corresponding to the obtained data information are identified and determined, and finally a list table corresponding to the target list is generated according to the category attributes to which the data information respectively belongs. The method and the device realize that in the process of generating the list table, the category attribute corresponding to the data information contained in the target list is firstly identified, and then the list table of the target list is generated according to the category attribute of the data information, so that the data information in the generated list table has a corresponding incidence relation, and the data information in the list table does not need to be reestablished.
In one embodiment, as shown in fig. 3, in step 206, generating a list table corresponding to the obtained target list based on the category attribute corresponding to the data information includes:
When the list table is generated, except that the data associated with different tab information correspondingly generates corresponding sub-tab tables, the corresponding main tab table can be generated according to all the data information contained in the target list. Specifically, the terminal reads all data information contained in the target list, and then generates and obtains a corresponding homepage tag table according to the obtained data information, wherein the homepage tag table contains data corresponding to editable categories in the data information, and for the data stored in the homepage tag table, the association information of each data information is correspondingly stored so as to determine sub-pages associated with each data information respectively.
In practical application, when the target list generates and obtains the list table, and when the data information included in the target list is obtained, the category attribute of the obtained data information is identified and determined, then the data information of which the category attribute is editable category is collected to obtain a corresponding main tab table, that is, all editable data information in the target list is stored in the main tab table, in addition, the data information related to different tab information also exists in the corresponding sub tab table, and further, the association relationship between the data information in the sub tab table and the data information in the main tab table is realized.
The data information in the main tab form is a set of editable data information in all the sub tab forms, when one data in the main tab form is modified, the sub tab containing the modified data also carries out corresponding data updating, and the sub tab containing the modified data does not need to be modified and updated in sequence.
And step 304, generating a sub-tab table corresponding to the obtained target list based on the category attribute corresponding to the data information and the tab information contained in the target list.
The target list comprises a plurality of different project projects, the different project projects correspond to different tab information, the tab information is description of characteristic information of the project projects, the sub-tab table is a list table generated by data information corresponding to the project projects in the target list, it should be noted that association information corresponding to editable data in the sub-tab table is fixed and not changed along with the change of the data information, and only data information contained in the sub-tab table changes, specifically, the data information changes according to the change of the data in the sub-tab table.
Specifically, the target list includes a plurality of pieces of tab information, different pieces of tab information correspond to different pieces of data information, after the terminal obtains the category attribute corresponding to the data information included in the target list, the terminal generates a sub-tab table corresponding to the target list according to the category attribute corresponding to the data information and the tab information included in the target list, and the sub-tab table stores the data information associated with the corresponding tab information.
In practical application, the target list includes a plurality of project sub-projects, each project sub-project has corresponding tab information and corresponding data information, where data information included in different project sub-projects may have a certain relationship, such as the data information being the same or having a corresponding association relationship. When the list table is generated, different sub-tab tables are generated by different project divisions, and corresponding different sub-tab tables exist in different project divisions, unit projects and single projects according to the actual requirements of the list table.
And step 306, summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list.
Specifically, after the sub tab form and the main tab form are obtained, the sub tab form is summarized in the main tab form, and a list form containing different tab identifications is generated. When the list table is generated, each sub tab table exists independently, that is, the data information contained in the sub tab table is not influenced by the data information contained in other sub tab tables, and when the sub tab table and the main tab table are collected to obtain the list table corresponding to the target list, different tabs are displayed on different table display interfaces.
In this embodiment, a corresponding main tab table is generated according to the data information included in the target list, a corresponding sub tab table is generated according to the tab information included in the target list and the category attribute corresponding to the data information, and finally the main tab table and the sub tab table are summarized to obtain a list table corresponding to the target list, where the list table includes the main tab table and the sub tab table. All editable data are collected to obtain the homepage tag table, so that when the data information in the homepage tag table is modified, the data information in the homepage tag table needs to be modified, and then the sub-page tag table associated with the modified data information needs to update the data, thereby avoiding the situation that the data in the sub-page tags need to be sequentially modified when the data information changes.
In this embodiment, since the data in the sub-tab table is set to be in the non-editable state, when the data in the list table is modified, the corresponding data in the main tab table needs to be modified, and then the data stored in the sub-tab table is updated when the modification is completed, mainly the data of the modified data is updated. Furthermore, it is also possible to set data in some sub tab tables to be in an editable state, but data in all sub tab tables may not be editable and modified, and it may be set that a certain data is in an editable state in a specific sub tab table and is still in an uneditable state in other sub tab tables according to the actual needs of the staff, and the setting of the editable sub tab tables may be set according to the actual needs, such as the frequency of use of the sub tab tables, for example, if data a exists in sub tab tables 1, 2, and 3, and data a is set to be in an editable state in sub tab table 1 according to the actual needs and is in an uneditable state in sub tab tables 2 and 3, then when viewing sub tab table 1, if data a is to be modified, the data a in sub tab tables 2 and 3 may be directly edited and modified, and when the modification is completed, data a in sub tab tables 2 and 3 is updated, and data a in the main tab table is also updated.
In an embodiment, as shown in fig. 4, in step 302, generating a sub-tab table corresponding to the target manifest based on the category attribute corresponding to the data information and the tab information included in the target manifest includes:
And step 406, importing the fixed data information into the sub-tab table template based on the first position information, and generating a sub-tab table corresponding to the obtained target tab.
Specifically, when the sub-tab table is generated and obtained, firstly, a target tab which is currently generated by the sub-tab table needs to be determined, then, data information associated with the target tab is read from the target data information, fixed data information with a fixed category attribute in the obtained data information associated with the target tab is obtained, then, a preset sub-tab table template is obtained to determine first position information of the fixed data in the sub-tab table template, and finally, the fixed data information is imported into the obtained sub-tab table template according to the determined first position information to generate the sub-tab table corresponding to the obtained target tab.
In practical application, each project item included in the target list corresponds to one piece of tab information, and for one project amount list, because the data information included in the project amount list is huge, when all the data information is generated and derived in one table, the data information searching is complex, and because the project amount list is composed of lists corresponding to different project item lists, when the corresponding target table is generated based on the target list, a plurality of sub tab lists can be generated, and the set of data information included in all the sub tab lists is the data information included in the target list.
When the sub-tab table is generated and obtained, firstly, data information related to the target tab is obtained, and the category attribute in the data information related to the target tab is obtained as fixed category fixed data information, wherein the fixed data information is unchangeable data information, such as item number, item name, item feature description, unit, engineering quantity and other attribute information, meanwhile, a sub-tab table template for generating the sub-tab table is obtained, and then the position information of the fixed data information in the sub-tab table template is determined, and in general, the position of the fixed data information in the sub-tab table template is fixed, such as existing in a header of the table and a first column of the table. For the sub-tab table, other cells in the table, which are not used for placing the fixed data information, are used for importing corresponding editable data, and all data information in the target tab have respective corresponding data identifiers for determining the positions of the data information in the obtained table.
In this embodiment, the obtained sub tab table includes editable data information and other data information associated with the target tab in addition to the fixed data information. For the editable data information needing to be imported into the sub tab table, all the editable data are stored in the main tab table, and the association relationship between the sub tab table and the sub tab table is determined, so that the corresponding editable data information is obtained from the main tab table and is imported into the sub tab table, and the data information in each sub tab table does not need to be imported separately when the editable data information is imported.
Further, in accordance with the generation of the corresponding manifest table, the sub tab table is derived in accordance with the requirements of the actual manifest, and all editable data is present in the main tab table. In practical application, when the sub-tab table is generated and obtained, a second-level sub-tab table can be generated besides the corresponding sub-tab table according to editable data in the main-tab table and the requirement of the list table, the second-level sub-tab table is also one of the sub-tab tables and is a type of sub-tab table generated and obtained according to the sub-tab table, and when the second-level sub-tab table is generated and obtained, the data base at this time is partial data contained in the partial sub-tab table. For example, data associated with a certain characteristic needs to be summarized, three sub-tab tables associated with the characteristic are provided, namely, the sub-tab table 1, the sub-tab table 2 and the sub-tab table 3, and if data belonging to the calculation category in the three sub-tab tables needs to be summarized at this time, data belonging to the calculation category in the three sub-tab tables are directly acquired to form a secondary sub-tab table. It should be noted that, when a secondary sub-tab table associated with a certain characteristic is obtained, data associated with the characteristic may also be directly obtained, and then a corresponding sub-tab table is obtained to perform corresponding data summarization.
Further, in one embodiment, as shown in fig. 5, when generating the get sub-tab table, the method further includes:
When a sub-tab table is generated according to a target tab, all data information contained in the target tab needs to be correspondingly generated at corresponding positions in the sub-tab table, when the positions of fixed data information in the sub-tab table are determined, calculation data information with the category attribute being a calculation category in the data information contained in the target tab is obtained, a calculation rule corresponding to the calculation data information is determined, then the calculation rule is imported to the position corresponding to the calculation data information, in addition, whether the obtained calculation rule is an identifiable rule needs to be determined, and when the obtained calculation rule is not the identifiable rule, the obtained calculation rule is converted into the corresponding identifiable calculation rule.
In practical applications, the engineering volume list usually includes data information obtained based on other data information, such as common subtotal, total and total prices, and the data information is obtained by performing corresponding calculation based on editable data information, so that the corresponding list table is generated and includes data information belonging to the calculation category. In this embodiment, when the sub-tab table corresponding to the target tab is generated, data information with a category attribute as a calculation category in the data information contained in the target tab is obtained, then, corresponding second position information of the calculation data information in the corresponding sub-tab table is determined, and further, the calculation rule or a standard rule corresponding to the calculation rule is imported to a corresponding position in the sub-tab table based on the second position information.
Further, when generating the sub tab table corresponding to the obtained target tab, the other data information that needs to be imported in the sub tab table is obtained and imported from the sub tab table, specifically: acquiring a data identifier contained in the sub-tab form, and acquiring data information to be imported corresponding to the data identifier in the main tab form based on the data identifier so as to import the data information to be imported into the sub-tab form; and when the data information in the main tab table is modified, acquiring the data identifier of the modified data information, and updating the data of the sub tab table containing the data identifier.
Specifically, the homepage tag table contains all editable data information, each data information corresponds to a unique data identifier, and when a corresponding data identifier exists in the sub-homepage tag table, the corresponding data information is directly acquired from the homepage tag table so as to be imported to a position corresponding to the data identifier in the sub-homepage tag table. Meanwhile, when the data information in the homepage tab table is modified, the data information in the corresponding sub-homepage tab table containing the modified data information is updated, that is, the data information is modified.
It should be understood that although the various steps in the flow diagrams of fig. 2-5 are shown in order as indicated by the arrows, the steps are not necessarily performed in order 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 some of the steps in fig. 2-5 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed alternately or alternatingly with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 6, there is provided a manifest table generating apparatus 600 including: a manifest acquisition module 602, an attribute determination module 604, and a table generation module 606, wherein:
the list obtaining module 602 is configured to, when a list table generating instruction is received, obtain a corresponding target list based on control information included in the list table generating instruction;
the attribute determining module 604 is configured to obtain target data information included in the target list, and identify and determine a category attribute corresponding to the target data information;
the table generating module 606 is configured to generate a list table corresponding to the obtained target list based on the category attribute corresponding to the target data information.
In an embodiment, the list obtaining module is further configured to obtain control information included in the list generating instruction, and perform query in a preset list database based on a list identifier included in the control information to obtain a target list corresponding to the list identifier.
In one embodiment, a table generation module is provided that includes: the system comprises a homepage label table generating module, a sub-page label table generating module and a table summarizing generating module. The homepage signing form generating module is used for generating and obtaining a corresponding homepage signing form based on target data information contained in the target list; the sub-tab table generating module is used for generating a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list; the table summarizing and generating module is used for summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list.
In an embodiment, the homepage tab generation module is further configured to read target data information included in the target manifest, obtain editable data information in which the category attribute is an editable category in the target data information, and aggregate and reproduce the editable data to generate a homepage tab including the editable data information.
In one embodiment, the sub-tab table generation module further comprises a data information acquisition module, a location information determination module and an import generation module. The data information acquisition module is used for reading data information associated with a target tab from the target data information based on the tab information contained in the target list and acquiring fixed data information with fixed type attribute in the data information associated with the target tab; the position information determining module is used for acquiring a preset list form template and determining first position information of the fixed data information in the list form template; the import generation module is used for importing the fixed data information into the list table template based on the first position information to generate and obtain a sub-tab table corresponding to the target tab.
In one embodiment, a sub-tab table generation module is provided that further includes a rule determination module. The data information acquisition module is further used for acquiring calculation data information of which the category attribute is a calculation category in the data information contained in the target tab; the rule determining module is used for determining a calculation rule corresponding to the calculation data information and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule; the import generation module is further used for determining second position information of the calculation data information in the corresponding sub-tab table and importing the calculation rule to a position corresponding to the second position information.
In one embodiment, the list table generating method further comprises a data importing module and a data updating module. The data import module is used for acquiring data identifiers contained in the sub-tab form, acquiring data information to be imported corresponding to the data identifiers in the main tab form based on the data identifiers, and importing the data information to be imported into the sub-tab form; and the data updating module is used for acquiring the data identifier of the modified data information when the data information in the main tab table is modified, and updating the data of the sub-tab table containing the data identifier.
For specific limitations of the list table generating device, reference may be made to the above limitations on the list table generating method, which is not described herein again. The various modules in the above list table generating device may be implemented wholly or partially 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. 7. The computer device includes a processor, a memory, a network 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 operating system and the computer program to run on the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a manifest table generation 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, a corresponding voice input device, 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. 7 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 provided, comprising a memory having a computer program stored therein and a processor that when executing the computer program performs the steps of:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in a target list, and identifying and determining a category attribute corresponding to the target data information;
and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and acquiring control information contained in the list generation instruction, and inquiring in a preset list database based on the list identification contained in the control information to obtain a target list corresponding to the list identification.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
generating and obtaining a corresponding homepage signing form based on target data information contained in the target list;
generating a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list;
and summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and reading target data information contained in the target list, acquiring editable data information with the category attribute being an editable category in the target data information, and summarizing and de-duplicating editable data to generate a homepage tab containing the editable data information.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
based on the tab information contained in the target list, reading the data information associated with the target tab from the target data information, and acquiring the fixed data information of which the category attribute is a fixed category from the data information associated with the target tab;
acquiring a preset list form template, and determining first position information of fixed data information in the list form template;
and importing the fixed data information into the list form template based on the first position information, and generating and obtaining a sub-tab form corresponding to the target tab.
In one embodiment, the processor when executing the computer program further performs the steps of:
acquiring calculation data information with a category attribute as a calculation category in data information contained in a target tab;
determining a calculation rule corresponding to the calculation data information, and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule;
and determining second position information of the calculation data information in the corresponding sub-tab table, and importing the calculation rule to a position corresponding to the second position information.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a data identifier contained in the sub-tab form, and acquiring data information to be imported corresponding to the data identifier in the main tab form based on the data identifier so as to import the data information to be imported into the sub-tab form;
when the data information in the main tab table is modified, the data identification of the modified data information is obtained, and the data of the sub tab table containing the data identification is updated.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in a target list, and identifying and determining a category attribute corresponding to the target data information;
and generating a list table corresponding to the target list based on the category attribute corresponding to the target data information.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring control information contained in the list generation instruction, and inquiring in a preset list database based on the list identification contained in the control information to obtain a target list corresponding to the list identification.
In one embodiment, the computer program when executed by the processor further performs the steps of:
generating and obtaining a corresponding homepage signing form based on target data information contained in the target list;
generating a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list;
and summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list.
In one embodiment, the computer program when executed by the processor further performs the steps of:
reading target data information contained in the target list, acquiring editable data information with the category attribute being an editable category in the target data information, and summarizing and de-duplicating the editable data to generate a homepage tag table containing the editable data information.
In one embodiment, the computer program when executed by the processor further performs the steps of:
based on the tab information contained in the target list, reading the data information associated with the target tab from the target data information, and acquiring the fixed data information of which the category attribute is a fixed category in the data information associated with the target tab;
acquiring a preset list form template, and determining first position information of fixed data information in the list form template;
and importing the fixed data information into the list form template based on the first position information, and generating and obtaining a sub-tab form corresponding to the target tab.
In one embodiment, the computer program when executed by the processor further performs the steps of:
acquiring calculation data information with a category attribute as a calculation category in data information contained in a target tab;
determining a calculation rule corresponding to the calculation data information, and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule;
and determining second position information of the calculation data information in the corresponding sub-page table, and importing the calculation rule to a position corresponding to the second position information.
In one embodiment, the computer program when executed by the processor further performs the steps of:
acquiring a data identifier contained in the sub-tab form, and acquiring data information to be imported corresponding to the data identifier in the main tab form based on the data identifier so as to import the data information to be imported into the sub-tab form;
when the data information in the main tab table is modified, the data identification of the modified data information is obtained, and the data of the sub tab table containing the data identification is updated.
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, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
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 invention. 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, and these are all within the scope of protection of the present application. Therefore, the protection scope of the present patent application shall be subject to the appended claims.
Claims (10)
1. A method of manifest table generation, the method comprising:
when a list table generating instruction is received, obtaining a corresponding target list based on control information contained in the list table generating instruction;
acquiring target data information contained in the target list, and identifying and determining a category attribute corresponding to the target data information;
generating a list table corresponding to the target list based on the category attribute corresponding to the target data information;
the generating of the list table corresponding to the target list based on the category attribute corresponding to the target data information includes:
generating and obtaining a corresponding homepage signing form based on the target data information contained in the target list;
generating and obtaining a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list;
summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list;
the category attributes comprise a fixed category, an editable category and a calculation category;
generating and obtaining a corresponding homepage signing form based on the target data information contained in the target list, wherein the generating and obtaining of the corresponding homepage signing form comprises the following steps:
reading target data information contained in the target list, acquiring editable data information with the category attribute being an editable category in the target data information, and summarizing and de-duplicating the editable data to generate a homepage signing table containing the editable data information;
generating a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information included in the target list, including:
based on tab information contained in a target list, reading data information associated with a target tab from target data information, and acquiring fixed data information of which the category attribute is a fixed category in the data information associated with the target tab;
acquiring a preset list form template, and determining first position information of the fixed data information in the list form template;
based on the first position information, importing the fixed data information into the list table template to generate and obtain a sub-tab table corresponding to the target tab;
the method further comprises the following steps:
acquiring calculation data information of which the category attribute is a calculation category in the data information contained in the target tab;
determining a calculation rule corresponding to the calculation data information, and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule;
and determining second position information of the calculation data information in a corresponding sub-tab table, and importing the calculation rule to a position corresponding to the second position information.
2. The method according to claim 1, wherein obtaining the corresponding target list based on the control information included in the list table generating instruction comprises:
and acquiring control information contained in the list table generating instruction, and inquiring in a preset list database based on the list identification contained in the control information to obtain a target list corresponding to the list identification.
3. The method of claim 1, further comprising:
acquiring a data identifier contained in the sub-tab form, and acquiring data information to be imported corresponding to the data identifier in the main tab form based on the data identifier so as to import the data information to be imported into the sub-tab form;
and when the data information in the main tab table is modified, acquiring the data identifier of the modified data information, and updating the data of the sub tab table containing the data identifier.
4. The method of claim 1, wherein the manifest form is a downloadable electronic document.
5. The method of claim 1, wherein the manifest table generation instruction is triggered based on a corresponding operation performed by a user on a terminal.
6. An inventory form generation apparatus, the apparatus comprising:
the list acquisition module is used for acquiring a corresponding target list based on the control information contained in the list table generation instruction when the list table generation instruction is received;
the attribute determining module is used for acquiring target data information contained in the target list and identifying and determining the category attribute corresponding to the target data information;
the table generating module is used for generating a list table corresponding to the target list based on the category attribute corresponding to the target data information;
the table generating module comprises a homepage tab table generating module, a sub-page tab table generating module and a table summarizing generating module; the main tab table generating module is used for generating and obtaining a corresponding main tab table based on target data information contained in a target list; the sub-tab table generating module is used for generating a sub-tab table corresponding to the target list based on the category attribute corresponding to the target data information and the tab information contained in the target list; the table summarizing and generating module is used for summarizing the main page label table and the sub page label table to obtain a list table corresponding to the target list;
the homepage signing form generating module is also used for reading target data information contained in the target list, acquiring editable data information with the category attribute being an editable category in the target data information, and summarizing and de-duplicating the editable data to generate a homepage signing form containing the editable data information;
the sub-tab table generation module also comprises a data information acquisition module, a position information determination module, an import generation module and a rule determination module;
the data information acquisition module is used for reading data information associated with a target tab from the target data information based on the tab information contained in the target list and acquiring fixed data information of which the category attribute is a fixed category in the data information associated with the target tab;
the position information determining module is used for acquiring a preset list form template and determining first position information of fixed data information in the list form template;
the import generation module is used for importing the fixed data information into the list form template based on the first position information to generate and obtain a sub-tab form corresponding to the target tab;
the data information acquisition module is also used for acquiring the calculation data information of which the category attribute is a calculation category in the data information contained in the target tab;
the rule determining module is used for determining a calculation rule corresponding to the calculation data information and converting the calculation rule into an identifiable calculation rule when the calculation rule is not the identifiable rule;
the import generation module is further used for determining second position information of the calculation data information in the corresponding sub-tab table and importing the calculation rule to a position corresponding to the second position information.
7. The apparatus according to claim 6, wherein the list obtaining module is further configured to obtain control information included in the list table generating instruction, and perform query in a preset list database based on the list identifier included in the control information to obtain the target list corresponding to the list identifier.
8. The apparatus of claim 6, further comprising:
the data import module is used for acquiring data identifiers contained in the sub-tab form, acquiring data information to be imported corresponding to the data identifiers in the main tab form based on the data identifiers, and importing the data information to be imported into the sub-tab form; and
and the data updating module is used for acquiring the data identifier of the modified data information when the data information in the main tab table is modified, and updating the data of the sub tab table containing the data identifier.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 5 when executing the computer program.
10. 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 according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811435465.4A CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811435465.4A CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109597979A CN109597979A (en) | 2019-04-09 |
| CN109597979B true CN109597979B (en) | 2022-11-11 |
Family
ID=65960502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811435465.4A Active CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109597979B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111611284A (en) * | 2020-05-28 | 2020-09-01 | 联想(北京)有限公司 | Material list generation method and electronic equipment |
| CN113221525A (en) * | 2021-02-26 | 2021-08-06 | 平安普惠企业管理有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN113031883B (en) * | 2021-02-26 | 2024-07-16 | 广东核电合营有限公司 | Label data printing method, apparatus, computer device and storage medium |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN113095686A (en) * | 2021-04-15 | 2021-07-09 | 广联达科技股份有限公司 | Multi-standard-section cost adjusting method and device for power engineering |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794236A (en) * | 2009-01-30 | 2010-08-04 | 卡西欧计算机株式会社 | Application software generating apparatus, computer program and application software generation system |
| CN101968800A (en) * | 2010-09-21 | 2011-02-09 | 北京空间飞行器总体设计部 | Metadata driving based method for realizing dynamic form |
| JP5497948B1 (en) * | 2013-06-26 | 2014-05-21 | 前田建設工業株式会社 | Tabular data processing program, method and apparatus |
| JP2014157441A (en) * | 2013-02-15 | 2014-08-28 | Topic Maker:Kk | Homepage preparation method, and homepage preparation system |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050137883A1 (en) * | 2003-12-19 | 2005-06-23 | Hiroaki Nohgawa | Business form issuing apparatus and electronic business form system |
-
2018
- 2018-11-28 CN CN201811435465.4A patent/CN109597979B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794236A (en) * | 2009-01-30 | 2010-08-04 | 卡西欧计算机株式会社 | Application software generating apparatus, computer program and application software generation system |
| CN101968800A (en) * | 2010-09-21 | 2011-02-09 | 北京空间飞行器总体设计部 | Metadata driving based method for realizing dynamic form |
| JP2014157441A (en) * | 2013-02-15 | 2014-08-28 | Topic Maker:Kk | Homepage preparation method, and homepage preparation system |
| JP5497948B1 (en) * | 2013-06-26 | 2014-05-21 | 前田建設工業株式会社 | Tabular data processing program, method and apparatus |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109597979A (en) | 2019-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109597979B (en) | List table generation method and device, computer equipment and storage medium | |
| WO2020186786A1 (en) | File processing method and apparatus, computer device and storage medium | |
| CN109815471A (en) | Contract text generation method, device, computer equipment and storage medium | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN111177302A (en) | Business document processing method and device, computer equipment and storage medium | |
| CN111309991B (en) | Query statement generation method and device and data query method and system | |
| CN112527812A (en) | Data permission processing method and device based on multiple dimensions and computer equipment | |
| CN111552704A (en) | Data report generation method and device, computer equipment and storage medium | |
| CN109493158B (en) | Product quotation measuring and calculating method, device, computer equipment and storage medium | |
| CN114611481A (en) | Template configuration method and device, computer equipment and storage medium | |
| CN112464625A (en) | Receipt generation method and device, computer equipment and storage medium | |
| CN110727777A (en) | Knowledge graph management method and device, computer equipment and storage medium | |
| CN112084403B (en) | Data query method, device, computer equipment and storage medium | |
| CN113434122A (en) | Multi-role page creation method and device, server and readable storage medium | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN112433753A (en) | Interface document generation method, device, equipment and medium based on parameter information | |
| CN115687350A (en) | Index construction method and device, computer equipment and storage medium | |
| CN114327435A (en) | Technical document generation method and device and computer readable storage medium | |
| CN109871214B (en) | Program code generation method, program code generation device, computer device, and storage medium | |
| CN114547066A (en) | Nuclear power business data standardization method and device and computer equipment | |
| CN113504957A (en) | Table data processing method and device, computer equipment and storage medium | |
| CN109471840B (en) | File viewing method and device, computer equipment and storage medium | |
| CN109857759B (en) | Concurrent data processing method and device, computer equipment and storage medium | |
| CN109461074B (en) | Transaction route configuration method, device, computer equipment and storage medium | |
| CN109299300B (en) | Method and device for generating inventory subdirectories, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |