CN109829141A - A kind of project table generation method and device - Google Patents
A kind of project table generation method and device Download PDFInfo
- Publication number
- CN109829141A CN109829141A CN201811624649.5A CN201811624649A CN109829141A CN 109829141 A CN109829141 A CN 109829141A CN 201811624649 A CN201811624649 A CN 201811624649A CN 109829141 A CN109829141 A CN 109829141A
- Authority
- CN
- China
- Prior art keywords
- project
- template
- cell
- data
- value
- 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.)
- Granted
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The present invention provides a kind of project table generation method and devices, method includes: in operation interface indicating template Table List, after detecting the target template table that user selects in template form list, target template table is replicated, template data is obtained, and generates project table with resulting template data；No. OID of project table is identical as No. OID of target template table；After obtaining the project data that user keys in project table generated, using default merging rule, template data existing in project table and project data are merged, obtain the project table formed by amalgamation result: wherein, the default rule that merges is for same cell, if template data has value in the cell, using template data the cell value as the value of the cell；If template data in the cell without value, using project data the cell value as the value of the cell.Using the embodiment of the present invention, the normalization of raising project table is realized.
Description
Technical field
The present invention relates to online table field more particularly to a kind of project table generation method and devices.
Background technique
With the continuous development of business item, completing a project may be made of a large amount of online tables, for example, an item
Mesh has a sub-project more than 100, and every sub-project may include 300 books, and each book includes 3 online tables, that
It completes the project and needs to make 90,000 online tables altogether.Staff usually requires to handle a large amount of table and data.
In order to improve working efficiency and while also can improve the normalization of table, existing table generation method is usually:
By editing to template form has been previously set, to generate new table.However, inventor is realizing process of the invention
Middle discovery, at least there are the following problems for the prior art: since all data in project table can be modified, causing same
Project table in project is often difficult to uniform template, and the normalization of project table is not high.
Summary of the invention
It is an object of the invention to overcome the defect of the prior art, a kind of project table generation method and device are provided,
With guarantee project table in the same project can uniform template, to realize the normalization of raising project table.
The present invention is implemented as follows:
In a first aspect, the present invention provides a kind of project table generation method, which comprises
In operation interface indicating template Table List, in the target for detecting that user selects in the template form list
After template form, the target template table is replicated, obtains template data, and generate project with resulting template data
Table；No. OID of the project table is identical as No. OID of the target template table；
After obtaining the project data that user keys in project table generated, using default merging rule, by institute
It states existing template data and the project data in project table to merge, obtains the project table formed by amalgamation result: its
In, the default merging rule is for same cell, if template data has value in the cell, by the template data
In value of the value as the cell of the cell；If template data in the cell without value, by project data in the unit
Value of the value of lattice as the cell.
Optionally, using default merging rule, by existing template data and the project data in the project table
Merge, obtain the project table formed by amalgamation result, comprising:
Using existing template data in the project table and the project data as the first JSON object and
Two JSON objects；
It, will be described if the first JSON object has value in the cell for each cell in the project table
Value of the value of first JSON object as the cell；If the first JSON object in the cell without value, by described second
Value value as the cell of the JSON object in the cell.
Optionally, after obtaining project data, the method also includes:
Project data obtained is saved as into JSON format.
Optionally, the method also includes:
By each template form in the project table formed by amalgamation result and the template form list cache to
It is local.
Optionally, the method also includes:
After detecting load instruction, the online table of local cache is different from from server load, with being loaded
The online table of line table update local cache, the online table include template form and project table.
Optionally, the online table of local cache is different from from server load, with the online table update sheet loaded
The online table of ground caching, comprising:
For the local each template form cached, the local version number and ID number of the template form are obtained；From service
Device obtains the source version number with the template form of the ID number；Judge whether the local version number and the source version number are identical；If
It is not identical, then there is the template form of the ID number from server pull, update the template form with the template form pulled；If
It is identical, then not from server pull template form；
For the local each project table cached, the local version number of the project table, ID number and No. OID are obtained；
Determining has No. OID corresponding template table, and the source version number of the project table with the ID number is obtained from server；Sentence
Break the project table local version number and source version number it is whether identical；If not identical, there is the ID number from server pull
Project table, the project table locally cached with the project table update pulled makees updated project table
For project table to be combined；If they are the same, then using local project table cached as project table to be combined；This is waited closing
And project table and identified corresponding template table merge, and update the project table to be combined with amalgamation result.
Optionally, the method also includes:
After detecting modification instruction, acted on template form is instructed to modify the modification.
Second aspect, the present invention provide a kind of project table generating means, and described device includes:
Module is obtained, in operation interface indicating template Table List, is detecting that user arranges in the template form
After the target template table selected in table, the target template table is replicated, obtains template data, and with resulting mould
Plate data generate project table；No. OID of the project table is identical as No. OID of the target template table；
Merging module, for after obtaining the project data keyed in project table generated of user, using default
Merge rule, existing template data in the project table and the project data are merged, obtain being formed by amalgamation result
Project table: where the default merging rule is for same cell, if template data has value in the cell,
Using the template data the cell value as the value of the cell；If template data in the cell without value, by item
Value of the mesh number according to the value in the cell as the cell.
Optionally, merging module merges rule using default, by existing template data in the project table and described
Project data merges, and obtains the project table formed by amalgamation result, specifically:
Using existing template data in the project table and the project data as the first JSON object and
Two JSON objects；
It, will be described if the first JSON object has value in the cell for each cell in the project table
Value of the value of first JSON object as the cell；If the first JSON object in the cell without value, by described second
Value value as the cell of the JSON object in the cell.
Optionally, described device further includes memory module, is used for:
After obtaining project data, project data obtained is saved as into JSON format.
Optionally, described device further include:
Cache module, each mould in project table and the template form list for will be formed by amalgamation result
Plate table is cached to local.
Optionally, described device further include:
Loading module, for being different from the online table of local cache from server load after detecting load instruction,
With the online table of the online table update local cache loaded, the online table includes template form and project table.
Optionally, the loading module is different from the online table of local cache from server load, with being loaded
The online table of line table update local cache, specifically:
For the local each template form cached, the local version number and ID number of the template form are obtained；From service
Device obtains the source version number with the template form of the ID number；Judge whether the local version number and the source version number are identical；If
It is not identical, then there is the template form of the ID number from server pull, update the template form with the template form pulled；If
It is identical, then not from server pull template form；
For the local each project table cached, the local version number of the project table, ID number and No. OID are obtained；
Determining has No. OID corresponding template table, and the source version number of the project table with the ID number is obtained from server；Sentence
Break the project table local version number and source version number it is whether identical；If not identical, there is the ID number from server pull
Project table, the project table locally cached with the project table update pulled makees updated project table
For project table to be combined；If they are the same, then using local project table cached as project table to be combined；This is waited closing
And project table and identified corresponding template table merge, and update the project table to be combined with amalgamation result.
Optionally, described device further includes modified module, is used for:
After detecting modification instruction, acted on template form is instructed to modify the modification.
The invention has the following advantages: using the embodiment of the present invention, it can be by duplication template form come New any
Each project table in mesh realizes the efficiency for improving generation project table, and each project table in project is
From template data and project data merging, if project data and template data have value in some cell, then modulus
Value end value as the cell of the plate data in the cell；Ensure projects table generated based on same template form
The uniformity of template data in lattice ensure that the consistency and normalization of projects table within the same project, reach
According to the purpose of template form specification item table；And due to No. OID of project table and the OID phase of target template table
Together, across the table reference relationship in template form can be directly copied in project table, and project table can directly obtain simultaneously
Using across the table reference relationship, without re-establishing across the table reference relationship in project table, to realize simplified project
The newly-built process of table, convenient for quickly generating required project table.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is a kind of flow diagram of project table generation method provided in an embodiment of the present invention；
Fig. 2 is a kind of structural schematic diagram of project table generating means provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts all other
Embodiment shall fall within the protection scope of the present invention.
It should be noted that project table generation method provided by the present invention can be applied to electronic equipment, wherein
In concrete application, which can be computer, PC, plate, mobile phone etc., this is all reasonable.In addition, real
The functional software of project table generation method provided by the existing embodiment of the present invention can generate software for special project table,
Or the plug-in unit in the software with project table systematic function.The present invention does not limit the operating system in electronic equipment
It is fixed, such as can be LINUX operating system or Windows operating system or UNIX operating system etc..
Referring to Fig. 1, the embodiment of the present invention provides a kind of project table generation method, and method includes the following steps:
S101, in operation interface indicating template Table List, detecting that user selects in the template form list
Target template table after, the target template table is replicated, obtains template data, and is raw with resulting template data
At project table；No. OID of the project table is identical as No. OID of the target template table；
Can there are multiple template table option, the corresponding template table of each template form option in template form list
Lattice, template form can be the basic table constructed in advance, and user, which can be, any can operate the common of human-computer interaction interface
Technical staff, user are properly termed as target template table, mesh selected by user in the selected template form of template form option
Mark template form can have one or more, for each target template table, can use the template of the target template table
Data generate a project table.
It should be noted that template form and project table of the invention may each comprise OID (Object
Identifier, object identifier) number and ID (identification, mark) numbers, wherein No. OID of each template form
It is identical with ID number, No. OID identical, each project of No. OID of project table and the template form for generating the project table
No. OID of table is different with ID number, and the ID number of template form is used for unique identification template form, and the ID number of project table is for only
One mark project table.The relationship that can be quickly identified project between table and template form by No. OID, thus quickly really
Make projects table generated by same template form.The present invention to ID number, No. OID concrete form without limitation, for example,
It can be the character string formed by one of characters such as number, letter, underscore or combination.
The template data of target template table may include field value, the cell of field in the table, each field
Formula in pattern and cell etc..Table can be online table, and format can be Excel format, csv (Comma-
Separated Values, comma separated value) format or xml (eXtensible Markup Language, extensible markup language
Speech) format etc..The present invention to specifically with template data generate project table mode without limitation, for example, can use
The program languages such as C#, ASP.NET are write in advance generates Excel for realizing the method for generating table or the directly reference library Excel
Table.
User can construct template form in advance by SpreadJS online editor, and can template form key in across
Table function can pre-establish across the table reference relationship of the template form Yu other template forms by this across table function, should be across
Table reference relationship can be copied in the project table generated based on the template form.Parameter format across table function are as follows: ("
[oid:sheetindex] sheetname ", cell), wherein oid indicates No. OID of target table to be quoted,
Sheetindex indicates the call number to the target list where reference data, and sheetname is indicated to reference data institute
Target list title, cell indicate to the cell region where reference data.
Project table and template form can be regarded as database purchase two and open tables of data, if setting in advance in template form
There is across table reference function, then it also can be comprising being somebody's turn to do across table reference letter in projects table generated based on the duplication template form
Number, due to across table reference function by No. OID one of as parameter, and No. OID of project table with for generating the project table
No. OID of template form it is identical, therefore, across the table reference relationship in template form can directly be copied to project table
In, thus project table can directly obtain and using should across table reference relationship, without re-established in project table this across
Table reference relationship, so that the newly-built process of simplified project table is realized, convenient for quickly generating required project table.
S102, after obtaining the project data keyed in project table generated of user, it is regular using default mergings,
Existing template data in the project table and the project data are merged, the project table formed by amalgamation result is obtained
Lattice: where the default merging rule is for same cell, if template data has value in the cell, by the mould
Value value as the cell of the plate data in the cell；If template data, without value, project data is existed in the cell
Value of the value of the cell as the cell.
User can key in project data in project table, if having template data in some cell, then the list
The value of first lattice will not change with the variation of the value for the project data newly keyed in, it is ensured that the normalization of project table.
Specifically, merging rule using default, by existing template data and the project data in the project table
Merge, obtains the project table formed by amalgamation result, may include: by existing template data and institute in the project table
It states project data and is respectively converted into the first JSON object and the 2nd JSON object；For each unit in the project table
Lattice, if the first JSON object has value in the cell, using the value of the first JSON object as the value of the cell；If the
One JSON object in the cell without value, then using the 2nd JSON object the cell value as the value of the cell.
JSON (JavaScript Object Notation, JS object numbered musical notation) is a kind of data exchange lattice of lightweight
Formula, template data and project data can be the forms for using JSON character string, and be translated into JSON object, can
Quickly to realize that data merge.The present invention to the mutual conversion between JSON object and JSON character string without limitation, can be with
It is converted using existing conversion regime.
Or in other embodiments, rule can also be merged using other modes design is default, the present invention to this not
It limits.For example, it is also possible to merge two JSON objects using JQuery.
Using the embodiment of the present invention, can by duplication target template table come each project table in grassroot project,
The efficiency for improving generation project table is realized, and each project table in project is by template data and project data
Merge, if project data and template data have value in some cell, then taking template data in the value of the cell
End value as the cell；Ensure the unification of the template data in projects table generated based on same template form
Property, it ensure that the consistency and normalization of projects table within the same project, reached according to template form specification item
The purpose of table.
In a kind of embodiment, the method also includes:
After detecting modification instruction, acted on template form is instructed to modify the modification.
After the completion of building, the data in table can be modified for template form and project table.The present invention is to specific
Modification mode without limitation, such as can be modified in template form or project table by the online Table edit device of SpreadJS
Across the tables particular content such as table function, field name, field value.For example, adaptability can be carried out according to project related content
Modification project table, for example, across the table reference relationship modified the occurrence of the certain field of project table, modify some cell
Etc., the relevant content of field name, pattern of template form can be modified, such as the font of cell, row are high.
Template form usually can meet the needs of most of project, but during actual creation project, it may
Need to be modified according to template of the project situation to project, due to No. OID of project table with for generating the project table
No. OID of template form it is identical, therefore, after modifying template form, can unite with the content in No. OID project table
One is modified, and realizes all project tables of the unified entire project of modification, every project table is individually modified without spending.
Using the embodiment of the present invention, since project table is from duplication template form, rather than directly by template
Table is as project table, and therefore, between the two independently of each other, will not all an other side be had an impact by modifying either party.
When the project table needed for project and existing template form have a small number of enter and leave, user still be can choose using the template table
Lattice carry out grassroot project, then individually remove the template data in modification project table, for by each of the unified generation of template form
For project table, their No. OID is identical as No. OID of template form, therefore, the template data in each project table
It unified with the modification of the template data in some project table can be modified, be realized by modifying a project table
Template data and uniformly modify the template data of each project table, simplify modification process, and be convenient for projects table mould
The unification of plate.
In addition, user can oneself basis when the project table needed for project and existing template form are quite different
Project demands create a set of template form, for generating project table, ensure that the flexibility and availability of template form.
Template form is created for the ease of user, button can be managed in operation interface with indicating template, detecting use
After Template Manager button is clicked at family, dialog box can be popped up, the template name that user is inputted by the dialog box can be obtained, obtained
After obtaining template name, edit operation button, example can be provided with indicating template edit operation interface, edit model operation interface
Such as, for creating, modifying, the button of Delete Folder or file, being pressed from both sides by filesselected and clicking new buttons is file
Create sub- grade file.
File tree directory for storing template form can be the infinite stages tree data structure based on database sharing,
In order to facilitate user's use, file can also be moved by way of pulling file, change document order or hierarchical structure, in addition
User can also be each file (i.e. template form) editing template data by the online Table edit device of SpreadJS, click
After save button, electronic equipment can be deposited into database.After template form building is completed, user can be in template
Newly-increased template is chosen in edit operation interface, is adjusted to enabling mode, and then can be in the template table shown by operation interface
The lattice list display template form is for selection by the user.
Using the embodiment of the present invention, required template form can be quickly constructed in order to user, improve user experience.
For the ease of subsequent quick reading project table, after obtaining project data, the method also includes:
Project data obtained is saved as into JSON format.
After user keys in project data, user can be with click data save button, and then electronic equipment can save item
Mesh number evidence, alternatively, just directly save the project data after obtaining the project data that user keys in, specific preserving type can be with
Are as follows: data are switched to by JSON format by online electrical form, and carry out whole preservation.To open the project table again in next time
When lattice, the merging of template data and project data can be rapidly performed by by JSON covering logic, to improve reading project
The rate of table.
In order to improve the subsequent efficiency for obtaining table, the method also includes:
By each template form in the project table formed by amalgamation result and the template form list cache to
It is local.
It, can be to avoid because constantly from server pull project table by caching project table and template form to local
With template form and influence efficiency, improve it is subsequent obtain table efficiency.
Each online table can also include version number (version), and when it is stored in server, version number can be with
Referred to as source version number；When it is buffered in it is local when, version number is properly termed as local version number.In order to guarantee the integrality of data
With version accuracy, if the data (data) in online table change, the version number of the online table can be therewith
Variation.Version can be MD5 (Message-Digest Algorithm) value of the text string generation with data field, MD5
It is a kind of Cryptographic Hash Function being widely used, can produce out the hashed value (hash of one 128 (16 byte)
Value), different with the MD5 value of different text string generations, version is different after may insure data variation in this way, thus really
Protect the integrality and consistency of data.
The MD5 value of the online table cached can be calculated using MD5 calculator, or can also use Python, PHP
Equal programming languages write the program for calculating MD5 value in advance, and the online table for calculating and being cached is realized by executing the program
The MD5 value of lattice.In addition, SHA (the Secure Hash of the online table cached can also be calculated in other implementations
Algorithm, Secure Hash Algorithm) 1 value, SHA256 value or SHA512 value, will calculate resulting SHA1 value, SHA256 value or
Local version number of the SHA512 value as the online table cached.Template cache can be distinguished using two caching data structures
Table and project table, the caching data structure for storing template form may include id, data { }, version and oid,
Respectively indicate the ID number of template form, data, local version number and No. OID；Caching data structure for stored items table
It may include id, data { }, excel_id, project_id, version and oid, respectively indicate ID number, the number of project table
According to, form NO., item number, local version number and No. OID.It in other embodiments, can also be using other data structures point
Other template cache table and project table, the present invention to the form of specific data structure without limitation.
In a kind of implementation, method further include: after detecting load instruction, be different from from server load local slow
The online table deposited, with the online table of the online table update local cache loaded, the online table includes template table
Lattice and project table.
The present invention is to the mode of load instruction is specifically detected without limitation, for example, can be with are as follows: beat obtaining application program
After opening instruction, the template form and project table of local cache are different from from server load；Or, at the interface for detecting display
On refresh button or reload after button is clicked, the template form and project of local cache are different from from server load
Table；Alternatively, being different from the mould of local cache from server load after default fixed duration or every arrival preset time point
Plate table and project table.
Electronic equipment can show the icon of the application program for realizing function of the present invention, and user can click or double-click
The icon so that electronic equipment can obtain application program open instructions, and then can load from server and be different from local delay
The template form and project table deposited.Alternatively, the interface that electronic equipment can show for user's operation, interface may include brush
New button reloads button, after detecting that user clicks refresh button or reloads button, can add from server
Carry the online table for being different from local cache.From server load be different from local cache table refer to from server load with
The different online table of the online table of local cache.Default fixed duration and preset time point can be set in advance according to demand
Fixed, for example, preset duration is 1 hour, 2 hours etc., preset time point can be 9:00,14:00,18:00 etc..
Specifically, being different from the online table of local cache from server load, with the online table update sheet loaded
Ground caching online table, may include:
For the local each template form cached, the local version number and ID number of the template form are obtained；From service
Device obtains the source version number with the template form of the ID number；Judge whether the local version number and the source version number are identical；If
It is not identical, then there is the template form of the ID number from server pull, update the template form with the template form pulled；If
It is identical, then not from server pull template form；
For the local each project table cached, the local version number of the project table, ID number and No. OID are obtained；
Determining has No. OID corresponding template table, and the source version number of the project table with the ID number is obtained from server；Sentence
Break the project table local version number and source version number it is whether identical；If not identical, there is the ID number from server pull
Project table, the project table locally cached with the project table update pulled makees updated project table
For project table to be combined；If they are the same, then using local project table cached as project table to be combined；This is waited closing
And project table and identified corresponding template table merge, and update the project table to be combined with amalgamation result.
When loading first time, due to not including the table from server in local cache, therefore can be from server
All template forms and project table are pulled, the table that load all only need to be different from local cache from server pull every time later
Lattice.
Specifically, following combination principle can be used, identified corresponding template table and project table to be combined are closed
And: if project table to be combined and corresponding template table have value in some cell, then taking the value of corresponding template table
End value as the cell；It may insure the normalization of project table to be combined in this way.Assuming that the number of corresponding template table
It is A={ a:1, b:{ b1:2, b2:3 }, c:2 according to content }, the data content of project table to be combined is B={ a:2, d:3 }, then
It is that corresponding template table merges with project to be combined the result is that { a:1, b:{ b1:2, b2:3 }, c:2, d:3.
In a kind of implementation, determining has No. OID corresponding template table, may include:
The source version number with No. OID template form is obtained from server；Judgement has No. OID template form
Local version number and source version number it is whether identical；If not identical, there is No. OID template form from server pull,
There is No. OID template form with the template form update local cache pulled, updated template form is determined
For with No. OID corresponding template table；If they are the same, there is No. OID template form to be determined as having local cache
There is No. OID corresponding template table.
Using the embodiment of the present invention, by the way that online table is buffered in local, without being obtained in each server
Line table avoids because constantly influencing efficiency from server pull project table and template form, improves subsequent obtain
The efficiency of line table.And by comparing version number, it is ensured that the template form in the template form and server of local cache
Content is consistent, the project table of local cache is consistent with the content of project table in server, realize and local delayed
There are timely updating for line table, improve the accuracy and reliability of the online table of local cache.
In addition, the table that server can load electronic equipment requests compresses for improve data transfer efficiency,
And then compressed table is transmitted, to improve efficiency of transmission, for example, server can use GZIP and/or LZ-
String compresses table, so that electronic equipment is before showing loaded table, the method also includes to added
The table of load unzips it；Loaded table is shown, including the table after display decompression.
Corresponding with above-mentioned embodiment of the method, the embodiment of the present invention also provides a kind of project table generating means.
Referring to fig. 2, Fig. 2 is a kind of structural schematic diagram of project table generating means provided by the embodiment of the present invention, dress
It sets and includes:
Module 201 is obtained, for detecting user in the template form in operation interface indicating template Table List
After the target template table selected in list, the target template table is replicated, obtains template data, and with resulting
Template data generates project table；No. OID of the project table is identical as No. OID of the target template table；
Merging module 202, for after obtaining the project data keyed in project table generated of user, using pre-
If merging rule, existing template data in the project table and the project data are merged, obtained by amalgamation result shape
At project table: where the default merging rule is for same cell, if template data has value in the cell,
Then using the template data the cell value as the value of the cell；If template data, without value, is incited somebody to action in the cell
Value value as the cell of the project data in the cell.
Using the embodiment of the present invention, can by duplication target template table come each project table in grassroot project,
The efficiency for improving generation project table is realized, and each project table in project is by template data and project data
Merge, if project data and template data have value in some cell, then taking template data in the value of the cell
End value as the cell；Ensure the unification of the template data in projects table generated based on same template form
Property, it ensure that the consistency and normalization of projects table within the same project, reached according to template form specification item
The purpose of table；And No. OID due to project table is identical as No. OID of the target template table, in template form
Across table reference relationship can be directly copied in project table, so that project table can directly obtain and be drawn using being somebody's turn to do across table
With relationship, without re-establishing across the table reference relationship in project table, to realize creating for simplified project table
Journey, convenient for quickly generating required project table.
Optionally, merging module merges rule using default, by existing template data in the project table and described
Project data merges, and obtains the project table formed by amalgamation result, specifically:
Using existing template data in the project table and the project data as the first JSON object and
Two JSON objects；
It, will be described if the first JSON object has value in the cell for each cell in the project table
Value of the value of first JSON object as the cell；If the first JSON object in the cell without value, by described second
Value value as the cell of the JSON object in the cell.
Optionally, described device further includes memory module, is used for:
After obtaining project data, project data obtained is saved as into JSON format.
Optionally, described device further include:
Cache module, each mould in project table and the template form list for will be formed by amalgamation result
Plate table is cached to local.
Optionally, described device further include:
Loading module, for being different from the online table of local cache from server load after detecting load instruction,
With the online table of the online table update local cache loaded, the online table includes template form and project table.
Optionally, the loading module is different from the online table of local cache from server load, with being loaded
The online table of line table update local cache, specifically:
For the local each template form cached, the local version number and ID number of the template form are obtained；From service
Device obtains the source version number with the template form of the ID number；Judge whether the local version number and the source version number are identical；If
It is not identical, then there is the template form of the ID number from server pull, update the template form with the template form pulled；If
It is identical, then not from server pull template form；
For the local each project table cached, the local version number of the project table, ID number and No. OID are obtained；
Determining has No. OID corresponding template table, and the source version number of the project table with the ID number is obtained from server；Sentence
Break the project table local version number and source version number it is whether identical；If not identical, there is the ID number from server pull
Project table, the project table locally cached with the project table update pulled makees updated project table
For project table to be combined；If they are the same, then using local project table cached as project table to be combined；This is waited closing
And project table and identified corresponding template table merge, and update the project table to be combined with amalgamation result.
Optionally, described device further includes modified module, is used for:
After detecting modification instruction, acted on template form is instructed to modify the modification.
The above is merely preferred embodiments of the present invention, be not intended to limit the invention, it is all in spirit of the invention and
Within principle, any modification, equivalent replacement, improvement and so on be should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of project table generation method, which is characterized in that the described method includes:
In operation interface indicating template Table List, in the target template for detecting that user selects in the template form list
After table, the target template table is replicated, obtains template data, and generate project table with resulting template data
Lattice；No. OID of the project table is identical as No. OID of the target template table；
After obtaining the project data that user keys in project table generated, using default merging rule, by the item
Existing template data and the project data merge in mesh table, obtain the project table formed by amalgamation result: where institute
Stating the default rule that merges is for same cell, if template data has value in the cell, by the template data at this
Value of the value of cell as the cell；If template data in the cell without value, by project data in the cell
It is worth the value as the cell.
2. the method according to claim 1, wherein merge rule using default, by the project table
Some template datas and the project data merge, and obtain the project table formed by amalgamation result, comprising:
Using existing template data in the project table and the project data as the first JSON object and second
JSON object；
For each cell in the project table, if the first JSON object has value in the cell, by described first
Value of the value of JSON object as the cell；If the first JSON object in the cell without value, by the described 2nd JSON pairs
Value as the value in the cell as the cell.
3. method according to claim 1 or 2, which is characterized in that after obtaining project data, the method also includes:
Project data obtained is saved as into JSON format.
4. the method according to claim 1, wherein the method also includes:
Each template form in the project table formed by amalgamation result and the template form list is cached to local.
5. according to the method described in claim 4, it is characterized in that, the method also includes:
After detecting load instruction, the online table of local cache is different from from server load, with the online table loaded
Lattice update the online table of local cache, and the online table includes template form and project table.
6. according to the method described in claim 5, it is characterized in that, being different from the online table of local cache from server load
Lattice, with the online table of the online table update local cache loaded, comprising:
For the local each template form cached, the local version number and ID number of the template form are obtained；It is obtained from server
There must be the source version number of the template form of the ID number；Judge whether the local version number and the source version number are identical；If not phase
Together, then there is the template form of the ID number from server pull, update the template form with the template form pulled；If phase
Together, then not from server pull template form；
For the local each project table cached, the local version number of the project table, ID number and No. OID are obtained；It determines
With No. OID corresponding template table, and obtain from server the source version number of the project table with the ID number；Judgement should
Whether the local version number of project table and source version number are identical；If not identical, there is the item of the ID number from server pull
Mesh table, the project table locally cached with the project table update pulled, using updated project table as to
Merging project table；If they are the same, then using local project table cached as project table to be combined；By the item to be combined
Mesh table and identified corresponding template table merge, and update the project table to be combined with amalgamation result.
7. the method according to claim 1, wherein the method also includes:
After detecting modification instruction, acted on template form is instructed to modify the modification.
8. a kind of project table generating means, which is characterized in that described device includes:
Module is obtained, for detecting user in the template form list in operation interface indicating template Table List
After the target template table of selection, the target template table is replicated, obtains template data, and with resulting template number
According to generation project table；No. OID of the project table is identical as No. OID of the target template table；
Merging module, for after obtaining the project data keyed in project table generated of user, using default merging
Existing template data in the project table and the project data are merged, obtain the item formed by amalgamation result by rule
Mesh table: where the default merging rule is for same cell, if template data has value in the cell, by institute
Template data is stated in value of the value as the cell of the cell；If template data in the cell without value, by item number
Value according to the value in the cell as the cell.
9. device according to claim 8, which is characterized in that the merging module merges rule using default, will be described
Existing template data and the project data merge in project table, obtain the project table formed by amalgamation result, specifically
Are as follows:
Using existing template data in the project table and the project data as the first JSON object and second
JSON object；
For each cell in the project table, if the first JSON object has value in the cell, by described first
Value of the value of JSON object as the cell；If the first JSON object in the cell without value, by the described 2nd JSON pairs
Value as the value in the cell as the cell.
10. device according to claim 8 or claim 9, which is characterized in that described device further includes memory module, is used for:
After obtaining project data, project data obtained is saved as into JSON format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811624649.5A CN109829141B (en) | 2018-12-28 | 2018-12-28 | Project table generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811624649.5A CN109829141B (en) | 2018-12-28 | 2018-12-28 | Project table generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109829141A true CN109829141A (en) | 2019-05-31 |
| CN109829141B CN109829141B (en) | 2023-06-09 |
Family
ID=66860567
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811624649.5A Active CN109829141B (en) | 2018-12-28 | 2018-12-28 | Project table generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109829141B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111767704A (en) * | 2020-06-30 | 2020-10-13 | 山东浪潮通软信息科技有限公司 | Excel form template generation method and device |
| CN112949266A (en) * | 2019-12-11 | 2021-06-11 | 珠海金山办公软件有限公司 | Electronic form processing method, processing device, electronic equipment and storage medium |
| CN113220752A (en) * | 2021-05-06 | 2021-08-06 | 北京字跳网络技术有限公司 | Display method and device and electronic equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050094206A1 (en) * | 2003-10-15 | 2005-05-05 | Canon Kabushiki Kaisha | Document layout method |
| US20050149583A1 (en) * | 2003-12-29 | 2005-07-07 | Rajagopal Baskaran | Customizable metadata merging framework |
| US20090254803A1 (en) * | 2006-11-30 | 2009-10-08 | Duncan Bayne | Programming methods for improving browser-based electronic forms |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN102708336A (en) * | 2012-05-02 | 2012-10-03 | 四川建设网有限责任公司 | Method and system for electronic document processing based on separation of key data from customized template |
| CN104978215A (en) * | 2014-10-08 | 2015-10-14 | 腾讯科技（深圳）有限公司 | File updating method, relevant equipment and system |
| CN107943777A (en) * | 2017-12-14 | 2018-04-20 | 北京久蓉科技有限公司 | A kind of collaborative editing, cooperative processing method, device, equipment and storage medium |
-
2018
- 2018-12-28 CN CN201811624649.5A patent/CN109829141B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050094206A1 (en) * | 2003-10-15 | 2005-05-05 | Canon Kabushiki Kaisha | Document layout method |
| US20050149583A1 (en) * | 2003-12-29 | 2005-07-07 | Rajagopal Baskaran | Customizable metadata merging framework |
| US20090254803A1 (en) * | 2006-11-30 | 2009-10-08 | Duncan Bayne | Programming methods for improving browser-based electronic forms |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN102708336A (en) * | 2012-05-02 | 2012-10-03 | 四川建设网有限责任公司 | Method and system for electronic document processing based on separation of key data from customized template |
| CN104978215A (en) * | 2014-10-08 | 2015-10-14 | 腾讯科技（深圳）有限公司 | File updating method, relevant equipment and system |
| CN107943777A (en) * | 2017-12-14 | 2018-04-20 | 北京久蓉科技有限公司 | A kind of collaborative editing, cooperative processing method, device, equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| WILLIAM D. DUNN JR.等: "REDLetr: Workflow and tools to support the migration of legacy clinical data capture systems to REDCap", INTERNATIONAL JOURNAL OF MEDICAL INFORMATICS, vol. 93, pages 103 - 110, XP029643527, DOI: 10.1016/j.ijmedinf.2016.06.015 * |
| 陈洪磊等: "基于C#的OLEDB和COM组件对Excel文件操作", 大众科技, vol. 16, no. 6, pages 6 - 9 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112949266A (en) * | 2019-12-11 | 2021-06-11 | 珠海金山办公软件有限公司 | Electronic form processing method, processing device, electronic equipment and storage medium |
| CN111767704A (en) * | 2020-06-30 | 2020-10-13 | 山东浪潮通软信息科技有限公司 | Excel form template generation method and device |
| CN111767704B (en) * | 2020-06-30 | 2024-01-26 | 浪潮通用软件有限公司 | Excel form template generation method and device |
| CN113220752A (en) * | 2021-05-06 | 2021-08-06 | 北京字跳网络技术有限公司 | Display method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109829141B (en) | 2023-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109829144A (en) | A kind of across table reference method and device of online table | |
| KR102610712B1 (en) | Customize your visualization | |
| US10558741B2 (en) | Concurrent preparation of multiple versions of a website | |
| JP2017050011A (en) | System, method and graphical user interface for workflow generation, placement and/or execution | |
| CN106502725A (en) | The upgrade method of application program, equipment and electronic equipment | |
| CN109829141A (en) | A kind of project table generation method and device | |
| CN111598533A (en) | Process approval processing method and device, electronic equipment and storage medium | |
| CN106022007A (en) | Cloud platform system and method oriented to biological omics big data calculation | |
| KR20210014117A (en) | Automatic layout of visualizations based on contract maps | |
| WO2015081779A1 (en) | Service processing method and apparatus based on bpm | |
| US20190134507A1 (en) | Game development system | |
| US20240028991A1 (en) | Flexible Work Breakdown Structure | |
| US20130067379A1 (en) | Graphical comparison of geographic information system data | |
| CN108089879A (en) | Increment updating method, equipment and programmable device | |
| US10705832B2 (en) | Efficient storage and analysis of source code modification history data | |
| CN113312052A (en) | Component calling method and device, electronic equipment and storage medium | |
| CN109815428A (en) | A kind of online table caching method and device | |
| US20190171989A1 (en) | Dynamic Workflow Control Based on Database Logic | |
| CN113076186A (en) | Task processing method and device, electronic equipment and storage medium | |
| US11907175B2 (en) | Model object management and storage system | |
| JP6350260B2 (en) | CONFERENCE SUPPORT DEVICE, CONFERENCE SUPPORT SYSTEM, CONFERENCE SUPPORT METHOD, AND CONFERENCE SUPPORT PROGRAM | |
| JP6590905B2 (en) | Content development device | |
| US20200380437A1 (en) | Business process design support method and business process design support apparatus | |
| JP2019197405A (en) | Project status management device, project status management program, and project status management method | |
| US11061664B2 (en) | Code management system and code management method |
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 | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230830 Address after: DB Area, Liye Commune Store, No. 289 Guanshan Avenue, Hongshan District, Wuhan City, Hubei Province, 430070 Patentee after: Wuhan Mango Technology Co.,Ltd. Address before: 430056 room 1603, building 36, Golden Harbor Phase IV, 68 Dongfeng Avenue, Hanyang District, Wuhan City, Hubei Province Patentee before: Chen Deqin |