CN104965816B - The edit methods and device of a kind of tables of data - Google Patents
The edit methods and device of a kind of tables of data Download PDFInfo
- Publication number
- CN104965816B CN104965816B CN201510434205.5A CN201510434205A CN104965816B CN 104965816 B CN104965816 B CN 104965816B CN 201510434205 A CN201510434205 A CN 201510434205A CN 104965816 B CN104965816 B CN 104965816B
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- edit item
- edit
- item
- 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
Landscapes
- User Interface Of Digital Computer (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a kind of edit methods of tables of data and device, the edit methods of the tables of data include：Receive editor's information of the tables of data of the first user terminal transmission；Editor's information includes position and the content of current edit item；When judging the current edit item currently without edit by second user end, according to the position of the current edit item, from default rule table inquiry obtain the currently edit item and edit rule accordingly；Included in editor's rule of the rule list according to the contents of at least two different edit items the rule that configures；When the content for detecting the current edit item meets that the editor is regular, according to the position of the current edit item, by the Edition Contains of the current edit item in the tables of data in corresponding edit item.Using the embodiment of the present invention, the data edited in tables of data can be detected in real time, improve editorial efficiency.
Description
Technical field
The present invention relates to the edit methods and device of field of computer technology, more particularly to a kind of tables of data.
Background technology
In development of games, game developer is filled in by tables of data (the generally formatted file such as csv, xls, xml)
To control the numerical value of game, flow etc..Therefore, filling in for tables of data one of is the most frequently worked in game.Due to game
Exploitation is related to Duo Ren team collaborations, and filling in for tables of data may be completed by different developers, thus on stream,
Need using certain team collaboration's mode come change of the unitized overall development personnel to tables of data.
At present, tables of data is filled in generally using SVN (Subversion, Version Management Software system) cooperation part
Formula.SVN cooperation mode workflows are after developer fills in tables of data, and the data of modification are submitted into SVN servers, SVN
Server enters line discipline inspection to the data of modification, such as runs into the modification to break the rules, then is reminded by modes such as Emails
Developer modifies again.
For whole exploitation test link, SVN cooperation modes planning rule of filling in a form is more, and iteration is frequent, Yi Fa
What life broke the rules fills in a form, and so as to cause to do over again, phenomenon occurs again and again, and rework cost is big.
The content of the invention
The embodiment of the present invention proposes a kind of edit methods of tables of data, the data that edited in tables of data can be carried out real-time
Detection, improve editorial efficiency.
The embodiment of the present invention provides a kind of edit methods of tables of data, including：
Receive editor's information of the tables of data of the first user terminal transmission；Editor's information includes the position of current edit item
And content；
When judging the current edit item currently without being edited by second user end, according to the position of the current edit item
Put, from default rule table inquiry obtain the current edit item and edit rule accordingly；Editor's rule of the rule list
In include according to the contents of at least two different edit items the rule that configures；
When the content for detecting the current edit item meets that the editor is regular, according to the position of the current edit item
Put, by the Edition Contains of the current edit item in the tables of data in corresponding edit item.
Further, the tables of data has N* (M-1) individual edit item；Wherein, N is total columns of the tables of data, and M is
Total line number of the tables of data；N >=2, M >=2；Each edit item has unique position in the tables of data；Each editor
The position of item includes the row name and line number of edit item；
It is described when judging the current edit item currently without being edited by second user end, according to the current edit item
Position, from default rule table inquiry obtain the edit item and edit rule accordingly, specifically include：
According to the position of the current edit item, judge whether the current edit item is being edited by second user end；
If so, then send conflict prompt message to first user terminal；
If it is not, then inquired about from default rule table according to the row name of the current edit item and work as pre-editing described in obtaining
The corresponding editor's rule of item；The rule list is that each row name edits the mapping table of rule with it；The volume of the rule list
Comprising being the content according at least two edit items with different lines name the rule that configures in volume rule.
Further, the position according to the current edit item, judges whether the current edit item is used by second
Family, which is rectified, is editing, and specifically includes：
Judge whether the current edit item has been inserted into the locking information at second user end；If so, then judge described work as
Pre-editing item is rectified by the second user to be edited；If it is not, then judge the current edit item not by the second user
Rectify and editing；
And when judging that the current edit item is not rectified in editor by the second user, also work as pre-editing to described
Item inserts the locking information of first user terminal.
Further, editor's rule includes the row name of the condition edit item as the current edit item, condition rule
Then and when pre-editing arranges rule；
It is described when the content for detecting the current edit item meets that the editor is regular, according to the current edit item
Position, the Edition Contains of the current edit item in corresponding edit item, is specifically included in the tables of data：
The tables of data pre-established is traveled through, obtains the tables of data where the condition edit item；
According to the row name of the condition edit item and the line number of the current edit item, inquire about where the condition edit item
Tables of data, obtain the content of the condition edit item；
Whether the content for detecting the condition edit item meets the conditional plan；
If meeting the conditional plan, whether the content for detecting the current edit item meets that the pre-editing row of working as are advised
Then；If so, then according to the position of the current edit item, by the Edition Contains of the current edit item in the tables of data phase
In the edit item answered；If it is not, then to the first client feeds back miscue information.
Further, before the editor's information for the tables of data that the first user terminal of the reception is sent, in addition to：
Receive the edit requests that first user terminal is sent；The edit requests include table name and the user of editor user
Information；
Inquire about in the editing authority table being pre-configured with and whether there is the user profile；
If in the presence of to tables of data corresponding to table name described in first client feeds back, for the editor user in institute
State the first user terminal and edlin is entered to the tables of data；If being not present, refuse the edit requests.
Further, before the editor's information for the tables of data that the first user terminal of the reception is sent, in addition to：
Receive the Table Header information for the tables of data that first user terminal is sent；The Table Header information includes gauge outfit position and row
Name；
Judge whether the row name and the row name cached in advance are identical；
If identical, to the first client feeds back miscue information；
If differing, according to the gauge outfit position, the row name is buffered in the tables of data in corresponding gauge outfit.
Further, by the Edition Contains of the current edit item in the tables of data it in corresponding edit item
Afterwards, in addition to：
Editor's information of the current edit item is sent to second user end, makes the second user end in the data
The content of the current edit item is shown in the position of the current edit item of table.
Further, by the Edition Contains of the current edit item in the tables of data it in corresponding edit item
Afterwards, in addition to：
Receive the preservation instruction that first user terminal is sent；
Instructed according to described preserve, preserve the tables of data.
Preferably, the tables of data is the tables of data of configuration game attributes；The content of the edit item is game attributes.
Preferably, the conflict prompt message includes the user profile at the second user end.
Correspondingly, the embodiment of the present invention provides a kind of editing device of tables of data, including：
Information receiving module is edited, editor's information of the tables of data sent for receiving the first user terminal；Editor's letter
Breath includes position and the content of current edit item；
Rule acquisition module is edited, for when judging the current edit item currently without being edited by second user end,
According to the position of the current edit item, from default rule table inquiry obtain the current edit item and edit rule accordingly
Then；Included in editor's rule of the rule list according to the contents of at least two different edit items the rule that configures；And
Editor module, during for meeting that the editor is regular in the content for detecting the current edit item, according to described
The position of current edit item, by the Edition Contains of the current edit item in the tables of data in corresponding edit item.
Further, the tables of data has N* (M-1) individual edit item；Wherein, N is total columns of the tables of data, and M is
Total line number of the tables of data；N >=2, M >=2；Each edit item has unique position in the tables of data；Each editor
The position of item includes the row name and line number of edit item；
Editor's rule acquisition module specifically includes：
Judging unit, for the position according to the current edit item, judge the currently edit item whether by the
Two user terminal editors；
Conflicting information sending module, for when judging that the current edit item is rectified in editor by second user, to institute
State the first user terminal and send conflict prompt message；
Rule unit is edited, for the row name according to the current edit item, inquires about and obtains from default rule table
Obtain the current edit item and edit rule accordingly；The rule list is that each row name edits the mapping table of rule with it；
The content according at least two edit items with different lines name is included in editor's rule of the rule list come the rule that configures.
Further, the judging unit is specifically used for judging whether the current edit item has been inserted into second user end
Locking information；Edited if so, then judging that the current edit item is rectified by the second user；If it is not, described in then judging
Current edit item is not rectified by the second user to be edited；
The editing device of the tables of data also includes locking module；The locking module is used to work as pre-editing described in judgement
Item is not rectified in editor by the second user, and the locking for also inserting first user terminal to the current edit item is believed
Breath.
Further, editor's rule includes the row name of the condition edit item as the current edit item, condition rule
Then and when pre-editing arranges rule；
The editor module specifically includes：
Tables of data acquisition module, for traveling through the tables of data pre-established, obtain the data where the condition edit item
Table；
Tables of data query unit, for the row name according to the condition edit item and the line number of the current edit item, look into
The tables of data where the condition edit item is ask, obtains the content of the condition edit item；
Whether the first detection unit, the content for detecting the condition edit item meet the conditional plan；And
Second detection unit, if for meeting the conditional plan, whether the content for detecting the current edit item is full
Foot is described when pre-editing row rule；If so, then the content of the current edit item is compiled according to the position of the current edit item
Collect in the tables of data in corresponding edit item；If it is not, then to the first client feeds back miscue information.
Further, the editing device of the tables of data also includes：
Edit requests receiving module, the edit requests sent for receiving first user terminal；The edit requests bag
Include table name and the user profile of editor user；
User profile enquiry module, it whether there is the user profile for inquiring about in the editing authority table being pre-configured with；
And
Tables of data feedback module, if in the presence of, to tables of data corresponding to table name described in first client feeds back,
Edlin is entered to the tables of data in first user terminal for the editor user；If being not present, refusing the editor please
Ask.
Further, the editing device of the tables of data also includes：
Table Header information receiving module, the Table Header information of the tables of data sent for receiving first user terminal；The table
Header includes gauge outfit position and row name；And
Row name judge module, for judging whether the row name and the row name cached in advance are identical；If identical, to described
First client feeds back miscue information；If differing, according to the gauge outfit position, the row name is buffered in the number
According in corresponding gauge outfit in table.
Further, the editing device of the tables of data also includes：
Information sending module is edited, for editor's information of the current edit item to be sent into second user end, makes institute
State the content that second user end shows the current edit item in the position of the current edit item of the tables of data.
Further, the editing device of the tables of data also includes：
Command reception module is preserved, the preservation instruction sent for receiving first user terminal；And
Tables of data preserving module, for being instructed according to described preserve, preserve the tables of data.
Preferably, the tables of data is the tables of data of configuration game attributes；The content of the edit item is game attributes.
Preferably, the conflict prompt message includes the user profile at the second user end.
Implement the embodiment of the present invention, have the advantages that：
The edit methods and device of tables of data provided in an embodiment of the present invention, the number that can be edited in real-time reception tables of data
According to, and detect whether editor's data meet corresponding editor's rule in real time, by the data edition of satisfaction editor's rule to data
In table, so as to be detected in real time to the data edited in tables of data, editorial efficiency is improved；Mass data cross-correlation in tables of data
Connection, editor's rule is configured according to associated data, in rule detection, first to the condition volume as current edit item
The content for collecting item is detected, and is carried out when the content of condition edit item meets conditional plan, then to the content of current edit item
Detection, makes editor's rule better meet the edit request of tables of data, improves the accuracy to current edit item content detection；
Same edit item is edited by more people simultaneously when, prompt the user with the current edit item and clash prompt message, so as to real
Now more people while online editing tables of data, greatly increase the editor to tables of data or efficiency of filling in a form.
Brief description of the drawings
Fig. 1 is the schematic flow sheet of one embodiment of the edit methods of tables of data provided by the invention；
Fig. 2 be tables of data provided by the invention edit methods in rule detection one embodiment schematic flow sheet；
Fig. 3 is the structural representation of one embodiment of the editing device of tables of data provided by the invention；
Fig. 4 is the structural representation of one embodiment of the editor module in the editing device of tables of data provided by the invention
Figure.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
It is the schematic flow sheet of one embodiment of the edit methods of tables of data provided by the invention referring to Fig. 1, including：
S1, the editor's information for receiving the tables of data that the first user terminal is sent；Editor's information includes current edit item
Position and content；
S2, when judging the current edit item currently without being edited by second user end, according to the current edit item
Position, from default rule table inquiry obtain the current edit item and edit rule accordingly；The editor of the rule list
Comprising being rule according to the content of at least two different edit items to configure in rule；
S3, when the content for detecting the current edit item meets that the editor is regular, according to the current edit item
Position, by the Edition Contains of the current edit item in the tables of data in corresponding edit item.
Wherein, editor's information is the information that the first user terminal is sent when the content in checking tables of data changes.
Editor's information includes the information for the form item that content changes, i.e., the position of current edit item and content.Due to a data
Table can realize more people online editing simultaneously, therefore, when receiving editor's information of the tables of data, need first to current edit item
Editor's situation judged.Do not rectified in the current edit item of judgement by second user end, i.e. other users in editor, root
According to the position of current edit item, you can inquiry obtains current edit item and edits rule accordingly from default rule table, and then
The content of current edit item is detected.When the content for detecting current edit item meets that editor is regular, pre-editing will be worked as
Content caching into tables of data in corresponding edit item, so as to be examined in real time to the data edited in tables of data
Survey, improve editorial efficiency.
It is even not interrelated with the data in tables of data because mass data is interrelated in tables of data, thus basis
Multiple associated data are regular to configure editor, editor's rule is better met the edit request of tables of data, improve to working as
The accuracy of pre-editing item content detection.
It should be noted that the tables of data of editor is class excel style tables, there is similar display with traditional excel
And mode of operation.The major function of tables of data includes equation editing, ranks operation, preserves, fixes ranks, export form, screening
Data, right button menu etc..
It should be noted that the edit methods of the tables of data of the present embodiment are realized by server.Server is to user's sum
Unified management is carried out according to table so that server can carry out joining table look-up with real-time reminding user to the data of editor, and make
Obtaining tables of data can be by multi-person synergy editor.
Further, the tables of data has N* (M-1) individual edit item；Wherein, N is total columns of the tables of data, and M is
Total line number of the tables of data；N >=2, M >=2；Each edit item has unique position in the tables of data；Each editor
The position of item includes the row name and line number of edit item；
It is described when judging the current edit item currently without being edited by second user end, according to the current edit item
Position, from default rule table inquiry obtain the edit item and edit rule accordingly, specifically include：
According to the position of the current edit item, judge whether the current edit item is being edited by second user end；
If so, then send conflict prompt message to first user terminal；
If it is not, then inquired about from default rule table according to the row name of the current edit item and work as pre-editing described in obtaining
The corresponding editor's rule of item；The rule list is that each row name edits the mapping table of rule with it；The volume of the rule list
Comprising being the content according at least two edit items with different lines name the rule that configures in volume rule.
It should be noted that tables of data has N rows M row, wherein, the first behavior gauge outfit arranges name, the N-1 beyond gauge outfit
The form item of row M row is edit item.Each edit item is corresponding with the row name and line number of unique position, i.e. edit item, according to
The position of edit item can determine that in tables of data when the edit item of pre-editing.
According to the position of current edit item, first judge whether current edit item is rectified by second user and editing.It is if current
Edit item is rectified by second user to be edited, then sends conflict prompting message to the first user terminal.When the first user terminal receives
During the conflict prompting message that the server returns, by tables of data display reminding information to prompt the current edit item of user
In being edited by second user end, for example, indicating current edit item with red in the tables of data of the first user terminal, prohibit simultaneously
The data message of the current edit item only is sent into the server to be preserved, so as to ensure that second user end can be normal
To the current edit item editor with preserving.Edited if current edit item is not rectified by second user, inquiring about current compile
The editor's rule for collecting item, continues to detect the content of current edit item.
The principle of above clash handle is that the editing authority of each edit item is separate in tables of data, i.e., different
User can edit edit item different in tables of data.For any one edit item, the user terminal meeting edited at first to it
This is locked, remaining user terminal is alerted conflict editing the Xiang Shihui, so as to solve the problems, such as conflict and in editor
Appearance is protected.The edit methods of tables of data more than, it is possible to achieve more people edit same tables of data simultaneously, and solve
Collision problem of the different user in editor, the efficiency for greatly increasing the editor of tables of data and filling in a form.
After solving more people and editing conflict simultaneously, also need to detect content of edit.Each row in tables of data are advance
Corresponding editor's rule is configured with, i.e., the content of the edit item of each row needs to meet certain editor's condition.Due to tables of data
The data of middle different lines, even not there is correlation with the data in tables of data, then data in associated row are matched somebody with somebody
Editor's rule is put, editor's rule is better met the edit request of tables of data.
Further, the position according to the current edit item, judges whether the current edit item is used by second
Family, which is rectified, is editing, and specifically includes：
Judge whether the current edit item has been inserted into the locking information at second user end；If so, then judge described work as
Pre-editing item is rectified by the second user to be edited；If it is not, then judge the current edit item not by the second user
Rectify and editing；
And when judging that the current edit item is not rectified in editor by the second user, also work as pre-editing to described
Item inserts the locking information of first user terminal.
Wherein, equivalent to one mark of locking information, for judging which user terminal is editing current edit item, each
The edit item edited can all be inserted into a locking information, so as to rapidly judge which user terminal is compiled
Volume.In addition, when user terminal exits editor, the locking information of all user terminals can be deleted in tables of data.
Further, editor's rule includes the row name of the condition edit item as the current edit item, condition rule
Then and when pre-editing arranges rule；
As shown in Fig. 2 it is described when the content for detecting the current edit item meets that the editor is regular, according to described
The position of current edit item, by the Edition Contains of the current edit item in the tables of data in corresponding edit item, specifically
Including：
The tables of data that S21, traversal pre-establish, obtains the tables of data where the condition edit item；
S22, according to the row name of the condition edit item and the line number of the current edit item, inquire about the condition edit item
The tables of data at place, obtain the content of the condition edit item；
Whether S23, the content of the detection condition edit item meet the conditional plan；If so, then perform step S24；
It is described when pre-editing row rule whether S24, the content of the detection current edit item meet；If so, then perform step
Rapid S25, if it is not, then performing step S26；
S25, the position according to the current edit item, by the Edition Contains of the current edit item in the tables of data
In corresponding edit item；
S26, to the first client feeds back miscue information.
It should be noted that, it is necessary to enter the configuration of edlin rule, institute before the data in tables of data detect
The editor's rule for having configuration can come into force in real time.Wherein, only the user with editing authority can add and delete editor
Editor's rule can only be checked and searched in rule, the domestic consumer without editing authority.
When the content to current edit item detects, the content of other edit items need to be relied on, that is, is used as and works as pre-editing
The content of the condition edit item of item.Wherein, condition edit item can be the editor in the tables of data with current edit item different lines
, or the edit item in other tables of data.If the configuration of editor's rule, which is generally condition edit item, meets that condition is advised
Then, then the pre-editing of working as that current edit item must is fulfilled for arranges rule.In detection, first according to the row name of condition edit item, find
Tables of data where condition edit item.The line number of row name and current edit item further according to condition edit item, from condition edit item
The content of the corresponding condition edit item of current edit item is found out in the tables of data at place, and the content for detecting the condition edit item is
The no conditional plan for meeting to set, if satisfied, then continuing to detect the content of current edit item.In current edit item
Appearance similarly meets, when pre-editing row are regular, to illustrate that the content of current edit item meets the editor that current edit item is pre-configured with
Rule, then the content of current edit item is cached；It is unsatisfactory for, when pre-editing row are regular, saying in the content of current edit item
The content of bright current edit item does not meet editor's rule, then gives miscue feedback of the information to the first user terminal.First user terminal
Regular prompt message is shown at current edit item, and changes the background colour of current edit item.Wherein, background colour can edited
Set in rule, different colours is represented the priority of Different Rule.
Wherein, the data detected needed for editor's rule may be from multiple tables of data, and connection table inspection need to be carried out to tables of data
Look into.Because other tables of data may be also at the state edited, then using file cache technology to the data edited
Table generates cache file, when joining table look-up, the cache file for editing tables of data is checked, so as to ensure its newest editor
State.
In editor's rule, rule that the most basic relation being configured between two row need to meet, if for example, X row meet X
Conditional plan, then Y, which is arranged, need to meet Y rules.Editor's rule can also configure increasingly complex rule, but can also pass through most basic shape
Formula is changed to realize.For example, if X row meet X conditional plans and Y row meet Y conditional plans, Z row need to meet Z rules,
Nested form can be converted to realize, if X row meet X conditional plans, needed (if Y row meet Y conditional plans, Z row need
Meet Z rules)；If X row meet X conditional plans, Y row need to meet Y conditional plans and Z row need to meet Z rules, can be converted to
If X row meet X conditional plans, Y row need to meet Y conditional plans, if X row meet X conditional plans, Z row need to meet Z rules；
If X row meet X conditional plans, Y row need to meet that Y conditional plans or Z row need to meet Z rules, if can be converted to X row meets X
Conditional plan, then need (if Y row are unsatisfactory for Y conditional plans, Z row need to meet Z rules)；If X row meet X conditional plans or Y
Row meet Y conditional plans, then Z row need to meet Z rules, if can be converted to X row meets X conditional plans, Z row need to meet that Z is advised
Then, if Y row meet Y conditional plans, Z row need to meet Z rules.Wherein it is possible to by configure editor rule in operator come
Realize different conditional plans.
Further, before the editor's information for the tables of data that the first user terminal of the reception is sent, in addition to：
Receive the edit requests that first user terminal is sent；The edit requests include table name and the user of editor user
Information；
Inquire about in the editing authority table being pre-configured with and whether there is the user profile；
If in the presence of to tables of data corresponding to table name described in first client feeds back, for the editor user in institute
State the first user terminal and edlin is entered to the tables of data；If being not present, refuse the edit requests.
It should be noted that the authority of each tables of data is configured by management data table center, realize to different user
Rights management, be generally divided into and editing authority and check authority, as the common employee of company has editing authority and checks authority,
And the new employee and trainee of company only have check authority.
Further, before the editor's information for the tables of data that the first user terminal of the reception is sent, in addition to：
Receive the Table Header information for the tables of data that first user terminal is sent；The Table Header information includes gauge outfit position and row
Name；
Judge whether the row name and the row name cached in advance are identical；
If identical, to the first client feeds back miscue information；
If differing, according to the gauge outfit position, the row name is buffered in the tables of data in corresponding gauge outfit.
It should be noted that before edlin is entered to the edit item of tables of data, number can be filled in using file cache technology
According to the gauge outfit of table, that is, arrange name.Whether when often filling in a row name, detect in the row name file cached in advance has the row name；
If so, then, if not having, the row name is buffered in the first client feeds back miscue information in row name file.Using this
Detection mode, the row name duplicated in tables of data can be prevented.
Further, by the Edition Contains of the current edit item in the tables of data it in corresponding edit item
Afterwards, in addition to：
Editor's information of the current edit item is sent to second user end, makes the second user end in the data
The content of the current edit item is shown in the position of the current edit item of table.
Wherein, a tables of data can be edited and checked simultaneously by more people.After some editor user enters edlin, it is compiled
The data broadcasting collected edits or checked the user of the tables of data to other, and the user terminal of these users responds the broadcast, and
Real-time update is carried out in the tables of data of user terminal.
Further, by the Edition Contains of the current edit item in the tables of data it in corresponding edit item
Afterwards, in addition to：
Receive the preservation instruction that first user terminal is sent；
Instructed according to described preserve, preserve the tables of data.
It should be noted that tables of data needs to carry out to preserve operation after data are edited and tables of data could be modified.
If editor user does not preserve when exiting editor to tables of data, then tables of data can return to the data mode do not edited,
Meanwhile other are notified to edit or checking that the first user terminal of the tables of data returns to tables of data the data shape do not edited
State.
Preferably, the tables of data is the tables of data of configuration game attributes；The content of the edit item is game attributes.
Preferably, the conflict prompt message includes the user profile at the second user end.For example, second user end
Title, ID accounts, department or IP address etc..When clashing, whom this user terminal can learn to identical list
Member enters edlin, so as to carry out communication and coordination.The edit methods of tables of data provided in an embodiment of the present invention, being capable of real-time reception number
According to the data edited in table, and detect whether editor's data meet corresponding editor's rule in real time, will meet to edit rule
Data edition is into tables of data, so as to be detected in real time to the data edited in tables of data, improves editorial efficiency；In tables of data
Mass data is interrelated, and editor's rule is configured according to associated data, in rule detection, first to as current
The content of the condition edit item of edit item is detected, and is compiled when the content of condition edit item meets conditional plan, then to current
The content for collecting item is detected, and editor's rule is better met the edit request of tables of data, is improved to current edit item content
The accuracy of detection；When same edit item is edited by more people simultaneously, prompt the user with the current edit item and clash
Prompt message, so as to realize more people online editing tables of data simultaneously, greatly increase the editor to tables of data or efficiency of filling in a form.
Accordingly, the present invention also provides a kind of editing device of tables of data, can realize the tables of data in above-described embodiment
Edit methods all flows.
It is the structural representation of one embodiment of the editing device of tables of data provided by the invention referring to Fig. 3, including：
Information receiving module 1 is edited, editor's information of the tables of data sent for receiving the first user terminal；Editor's letter
Breath includes position and the content of current edit item；
Rule acquisition module 2 is edited, for when judging the current edit item currently without being edited by second user end,
According to the position of the current edit item, from default rule table inquiry obtain the current edit item and edit rule accordingly
Then；Included in editor's rule of the rule list according to the contents of at least two different edit items the rule that configures；And
Editor module 3, during for meeting that the editor is regular in the content for detecting the current edit item, according to described
The position of current edit item, by the Edition Contains of the current edit item in the tables of data in corresponding edit item.
Further, the tables of data has N* (M-1) individual edit item；Wherein, N is total columns of the tables of data, and M is
Total line number of the tables of data；N >=2, M >=2；Each edit item has unique position in the tables of data；Each editor
The position of item includes the row name and line number of edit item；
Editor's rule acquisition module 2 includes：
Judging unit, for the position according to the current edit item, judge the currently edit item whether by the
Two user terminal editors；
Conflicting information sending module, for when judging that the current edit item is rectified in editor by second user, to institute
State the first user terminal and send conflict prompt message；
Rule unit is edited, for the row name according to the current edit item, inquires about and obtains from default rule table
Obtain the current edit item and edit rule accordingly；The rule list is that each row name edits the mapping table of rule with it；
The content according at least two edit items with different lines name is included in editor's rule of the rule list come the rule that configures.
Further, the judging unit is specifically used for judging whether the current edit item has been inserted into second user end
Locking information；Edited if so, then judging that the current edit item is rectified by the second user；If it is not, described in then judging
Current edit item is not rectified by the second user to be edited；
The editing device of the tables of data also includes locking module；The locking module is used to work as pre-editing described in judgement
Item is not rectified in editor by the second user, and the locking for also inserting first user terminal to the current edit item is believed
Breath.
Further, editor's rule includes the row name of the condition edit item as the current edit item, condition rule
Then and when pre-editing arranges rule；
The editor module 3 specifically includes：
Tables of data acquisition module 41, for traveling through the tables of data pre-established, obtain the number where the condition edit item
According to table；
Tables of data query unit 42, for the row name according to the condition edit item and the line number of the current edit item,
The tables of data inquired about where the condition edit item, obtain the content of the condition edit item；
Whether the first detection unit 43, the content for detecting the condition edit item meet the conditional plan；And
Second detection unit 44, if for meeting the conditional plan, detect the current edit item content whether
Meet described when pre-editing row rule；If so, then according to the position of the current edit item, by the content of the current edit item
Editor is in the tables of data in corresponding edit item；If it is not, then to the first client feeds back miscue information.
Further, the editing device of the tables of data also includes：
Edit requests receiving module, the edit requests sent for receiving first user terminal；The edit requests bag
Include table name and the user profile of editor user；
User profile enquiry module, it whether there is the user profile for inquiring about in the editing authority table being pre-configured with；
And
Tables of data feedback module, if in the presence of, to tables of data corresponding to table name described in first client feeds back,
Edlin is entered to the tables of data in first user terminal for the editor user；If being not present, refusing the editor please
Ask.
Further, the editing device of the tables of data also includes：
Table Header information receiving module, the Table Header information of the tables of data sent for receiving first user terminal；The table
Header includes gauge outfit position and row name；And
Row name judge module, for judging whether the row name and the row name cached in advance are identical；If identical, to described
First client feeds back miscue information；If differing, according to the gauge outfit position, the row name is buffered in the number
According in corresponding gauge outfit in table.
Further, the editing device of the tables of data also includes：
Information sending module is edited, for editor's information of the current edit item to be sent into second user end, makes institute
State the content that second user end shows the current edit item in the position of the current edit item of the tables of data.
Further, the editing device of the tables of data also includes：
Command reception module is preserved, the preservation instruction sent for receiving first user terminal；And
Tables of data preserving module, for being instructed according to described preserve, preserve the tables of data.
Preferably, the tables of data is the tables of data of configuration game attributes；The content of the edit item is game attributes.
Preferably, the conflict prompt message includes the user profile at the second user end.
Implement the embodiment of the present invention, have the advantages that：
The editing device of tables of data provided in an embodiment of the present invention, the data that can be edited in real-time reception tables of data, and
Detect whether editor's data meet corresponding editor's rule in real time, by the data edition for meeting to edit rule into tables of data,
So as to be detected in real time to the data edited in tables of data, editorial efficiency is improved；Mass data is interrelated in tables of data, compiles
Collecting rule is configured according to associated data, in rule detection, first to the condition edit item as current edit item
Content detected, when the content of condition edit item meets conditional plan, then the content of current edit item is detected,
Editor's rule is better met the edit request of tables of data, improve the accuracy to current edit item content detection；Same
Individual edit item is edited by more people simultaneously when, prompt the user with the current edit item and clash prompt message, it is more so as to realize
People while online editing tables of data, greatly increase the editor to tables of data or efficiency of filling in a form.
Described above is the preferred embodiment of the present invention, it is noted that for those skilled in the art
For, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications are also considered as
Protection scope of the present invention.
Claims (18)
- A kind of 1. edit methods of tables of data, it is characterised in that including：Receive editor's information of the tables of data of the first user terminal transmission；The position of editor's information including current edit item and interior Hold；When judging the current edit item currently without edit by second user end, according to the position of the currently edit item, Inquiry obtains the current edit item and edits rule accordingly from default rule table；Wrapped in editor's rule of the rule list Containing the content according at least two different edit items come the rule that configures；Wherein, editor's rule is included as described current The row name of the condition edit item of edit item, conditional plan and when pre-editing arranges rule；When the content for detecting the current edit item meets that the editor is regular, according to the position of the current edit item, By the Edition Contains of the current edit item in the tables of data in corresponding edit item；Wherein, the number pre-established is traveled through According to table, the tables of data where the condition edit item is obtained；According to the row name of the condition edit item and the current edit item Line number, the tables of data inquired about where the condition edit item, obtain the content of the condition edit item；Whether the content for detecting the condition edit item meets the conditional plan；If meeting the conditional plan, whether the content for detecting the current edit item meets that the pre-editing of working as arranges rule； If so, then according to the position of the current edit item, by the Edition Contains of the current edit item in the tables of data it is corresponding Edit item in；If it is not, then to the first client feeds back miscue information.
- 2. the edit methods of tables of data as claimed in claim 1, it is characterised in that the tables of data has N* (M-1) individual volume Collect item；Wherein, N is total columns of the tables of data, and M is total line number of the tables of data；N >=2, M >=2；Each edit item exists There is unique position in the tables of data；The position of each edit item includes the row name and line number of edit item；It is described when judging the current edit item currently without edit by second user end, according to the position of the currently edit item Put, from default rule table inquiry obtain the edit item and edit rule accordingly, specifically include：According to the position of the current edit item, judge whether the current edit item is being edited by second user end；If so, then send conflict prompt message to first user terminal；If it is not, then inquired about from default rule table according to the row name of the current edit item and obtain the current edit item phase The editor's rule answered；The rule list is that each row name edits the mapping table of rule with it；Editor's rule of the rule list The content according at least two edit items with different lines name is included in then come the rule that configures.
- 3. the edit methods of tables of data as claimed in claim 2, it is characterised in that the position according to the current edit item Put, judge whether the current edit item is being edited by second user end, specifically include：Judge whether the current edit item has been inserted into the locking information at second user end；If so, then judge the current volume Item is collected to be edited by the second user end；If it is not, then judge the current edit item currently without by the second user End editor；And when judging the current edit item currently without being edited by the second user end, also the current edit item is inserted Enter the locking information of first user terminal.
- 4. the edit methods of the tables of data as described in any one of claims 1 to 3, it is characterised in that receive the first use described Before the editor's information for the tables of data that family end is sent, in addition to：Receive the edit requests that first user terminal is sent；The edit requests include table name and user's letter of editor user Breath；Inquire about in the editing authority table being pre-configured with and whether there is the user profile；If in the presence of to tables of data corresponding to table name described in first client feeds back, for the editor user described One user terminal enters edlin to the tables of data；If being not present, refuse the edit requests.
- 5. the edit methods of tables of data as claimed in claim 2, it is characterised in that sent in the first user terminal of the reception Before editor's information of tables of data, in addition to：Receive the Table Header information for the tables of data that first user terminal is sent；The Table Header information includes gauge outfit position and row name；Judge whether the row name and the row name cached in advance are identical；If identical, to the first client feeds back miscue information；If differing, according to the gauge outfit position, the row name is buffered in the tables of data in corresponding gauge outfit.
- 6. the edit methods of the tables of data as described in any one of claims 1 to 3, it is characterised in that working as pre-editing by described in Edition Contains in the tables of data in corresponding edit item after, in addition to：Editor's information of the current edit item is sent to second user end, makes the second user end in the tables of data The content of the current edit item is shown in the position of current edit item.
- 7. the edit methods of the tables of data as described in any one of claims 1 to 3, it is characterised in that working as pre-editing by described in Edition Contains in the tables of data in corresponding edit item after, in addition to：Receive the preservation instruction that first user terminal is sent；Instructed according to described preserve, preserve the tables of data.
- 8. the edit methods of tables of data as claimed in claim 1 or 2, it is characterised in that the tables of data is configuration game category The tables of data of property；The content of the edit item is game attributes.
- 9. the edit methods of tables of data as claimed in claim 2, it is characterised in that the conflict prompt message includes described the The user profile of two user terminals.
- A kind of 10. editing device of tables of data, it is characterised in that including：Information receiving module is edited, editor's information of the tables of data sent for receiving the first user terminal；Editor's packet Include position and the content of current edit item；Rule acquisition module is edited, for when judging the current edit item currently without being edited by second user end, according to The position of the current edit item, from default rule table inquiry obtain the current edit item and edit rule accordingly；Institute State and included in editor's rule of rule list according to the contents of at least two different edit items the rule that configures；Wherein, the volume Collecting rule is included as the currently row name of the condition edit item of edit item, conditional plan and when pre-editing row are regular；AndEditor module, during for meeting that the editor is regular in the content for detecting the current edit item, according to described current The position of edit item, by the Edition Contains of the current edit item in the tables of data in corresponding edit item；Wherein, it is described Editor module specifically includes：Tables of data acquiring unit, for traveling through the tables of data pre-established, obtain the tables of data where the condition edit item；Tables of data query unit, for the row name according to the condition edit item and the line number of the current edit item, inquire about institute The tables of data where condition edit item is stated, obtains the content of the condition edit item；Whether the first detection unit, the content for detecting the condition edit item meet the conditional plan；AndSecond detection unit, if for meeting the conditional plan, whether the content for detecting the current edit item meets institute State when pre-editing row rule；If so, then the Edition Contains of the current edit item is existed according to the position of the current edit item In the tables of data in corresponding edit item；If it is not, then to the first client feeds back miscue information.
- 11. the editing device of tables of data as claimed in claim 10, it is characterised in that the tables of data has N* (M-1) individual Edit item；Wherein, N is total columns of the tables of data, and M is total line number of the tables of data；N >=2, M >=2；Each edit item There is unique position in the tables of data；The position of each edit item includes the row name and line number of edit item；Editor's rule acquisition module specifically includes：Judging unit, for the position according to the current edit item, judge whether the current edit item is being used by second Edit at family end；Conflicting information sending module, for when judging that the current edit item is edited by second user end, to described the One user terminal sends conflict prompt message；Rule unit is edited, for the row name according to the current edit item, is inquired about from default rule table and obtains institute State current edit item and edit rule accordingly；The rule list is that each row name edits the mapping table of rule with it；It is described The content according at least two edit items with different lines name is included in editor's rule of rule list come the rule that configures.
- 12. the editing device of tables of data as claimed in claim 11, it is characterised in that the judging unit is specifically used for judging Whether the current edit item has been inserted into the locking information at second user end；If so, then judge the current edit item Edited by the second user end；If it is not, then judge that the current edit item is edited currently without by the second user end；The editing device of the tables of data also includes locking module；The locking module is used to judge that the current edit item ought It is preceding when not edited by the second user end, the locking information of first user terminal is also inserted to the current edit item.
- 13. the editing device of the tables of data as described in any one of claim 10 to 12, it is characterised in that the volume of the tables of data Collecting device also includes：Edit requests receiving module, the edit requests sent for receiving first user terminal；The edit requests include table Name and the user profile of editor user；User profile enquiry module, it whether there is the user profile for inquiring about in the editing authority table being pre-configured with；AndTables of data feedback module, if in the presence of to tables of data corresponding to table name described in first client feeds back, for institute State editor user and edlin is entered to the tables of data in first user terminal；If being not present, refuse the edit requests.
- 14. the editing device of tables of data as claimed in claim 11, it is characterised in that the editing device of the tables of data also wraps Include：Table Header information receiving module, the Table Header information of the tables of data sent for receiving first user terminal；The gauge outfit letter Breath includes gauge outfit position and row name；AndRow name judge module, for judging whether the row name and the row name cached in advance are identical；If identical, to described first Client feeds back miscue information；If differing, according to the gauge outfit position, the row name is buffered in the tables of data In in corresponding gauge outfit.
- 15. the editing device of the tables of data as described in any one of claim 10 to 12, it is characterised in that the volume of the tables of data Collecting device also includes：Information sending module is edited, for editor's information of the current edit item to be sent into second user end, makes described the Two user terminals show the content of the current edit item in the position of the current edit item of the tables of data.
- 16. the editing device of the tables of data as described in any one of claim 10 to 12, it is characterised in that the volume of the tables of data Collecting device also includes：Command reception module is preserved, the preservation instruction sent for receiving first user terminal；AndTables of data preserving module, for being instructed according to described preserve, preserve the tables of data.
- 17. the editing device of the tables of data as described in claim 10 or 11, it is characterised in that the tables of data is played for configuration The tables of data of attribute；The content of the edit item is game attributes.
- 18. the editing device of tables of data as claimed in claim 11, it is characterised in that the conflict prompt message includes described The user profile at second user end.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510434205.5A CN104965816B (en) | 2015-07-22 | 2015-07-22 | The edit methods and device of a kind of tables of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510434205.5A CN104965816B (en) | 2015-07-22 | 2015-07-22 | The edit methods and device of a kind of tables of data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104965816A CN104965816A (en) | 2015-10-07 |
| CN104965816B true CN104965816B (en) | 2018-01-16 |
Family
ID=54219851
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510434205.5A Active CN104965816B (en) | 2015-07-22 | 2015-07-22 | The edit methods and device of a kind of tables of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104965816B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019279B (en) * | 2019-04-11 | 2020-12-04 | 北京字节跳动网络技术有限公司 | Online document collaborative updating method, device, equipment and storage medium |
| CN110196837B (en) * | 2019-04-23 | 2023-06-23 | 平安科技（深圳）有限公司 | Document editing method, device, computer equipment and storage medium |
| CN112328664A (en) * | 2020-11-05 | 2021-02-05 | 中国农业银行股份有限公司 | Report generation method and system |
| CN113709575B (en) * | 2021-04-07 | 2024-04-16 | 腾讯科技（深圳）有限公司 | Video editing processing method and device, electronic equipment and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101315621A (en) * | 2007-05-29 | 2008-12-03 | 北京书生国际信息技术有限公司 | Method for implementing document sharing editting |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9053079B2 (en) * | 2011-12-12 | 2015-06-09 | Microsoft Technology Licensing, Llc | Techniques to manage collaborative documents |
-
2015
- 2015-07-22 CN CN201510434205.5A patent/CN104965816B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101315621A (en) * | 2007-05-29 | 2008-12-03 | 北京书生国际信息技术有限公司 | Method for implementing document sharing editting |
Non-Patent Citations (1)
| Title |
|---|
| 如何在Excel中对输入数据进行审核;刘鑫;《秘书》;20130430(第04期);29-33 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104965816A (en) | 2015-10-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104965816B (en) | The edit methods and device of a kind of tables of data | |
| CN104798066B (en) | Detect the relationship between editor and the system and method taken action to the subset of editor | |
| Levin et al. | Modeling the role of brand alliances in the assimilation of product evaluations | |
| CN102687143B (en) | For implementing the method and system of definable action | |
| Botella et al. | ISO/IEC 9126 in practice: what do we need to know | |
| Oliver Schwarz | Pitfalls in implementing a strategic early warning system | |
| CA2401565A1 (en) | Automated method and system for selecting and procuring electronic components used in circuit and chip designs | |
| CN107016025A (en) | A kind of method for building up and device of non-relational database index | |
| CN106844730A (en) | The display methods and device of file content | |
| CN106257480A (en) | A kind of method and device preventing the robot tool malicious access page | |
| CN109101410A (en) | A kind of risk driven test method and device and computer readable storage medium | |
| CN104991886B (en) | A kind of edit methods of tables of data, device and system | |
| KR102368720B1 (en) | Integrated system including new proposal menu and explorer | |
| Choi et al. | Booklovers' world: An examination of factors affecting continued usage of social cataloging sites | |
| US20020178109A1 (en) | Fact based negotiation tool | |
| CN105450464B (en) | Test method and device for service interface | |
| Tseng et al. | A Web-based integrated design system: its applications on conceptual design stage | |
| CN110033237A (en) | A kind of configuration platform and configuration method that integrated integration is configurable | |
| CN106156043A (en) | A kind of off-line data processing method and processing device | |
| Couger et al. | Product: Measurement of creativity of IS products | |
| De Nicola et al. | Drivers of knowledge conversion in socio-technical systems | |
| Weber et al. | Haptic systems architecture modeling | |
| KR101966321B1 (en) | System for developing mission service and electric device thereof | |
| CN108052262A (en) | Edit page content color amending method, device, terminal and storage medium | |
| Palmquist et al. | Towards a traceable and circular textile value chain: Necessities to meet the digital product passport (DPP) |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |