CN112883012A - Implementation method and device of Domino data table component - Google Patents
Implementation method and device of Domino data table component Download PDFInfo
- Publication number
- CN112883012A CN112883012A CN202110178206.3A CN202110178206A CN112883012A CN 112883012 A CN112883012 A CN 112883012A CN 202110178206 A CN202110178206 A CN 202110178206A CN 112883012 A CN112883012 A CN 112883012A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- obtaining
- data table
- processing
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a method and a device for realizing a Domino data table component, which are characterized in that document form information is obtained and comprises initial operation type information and saving option information, wherein the saving option information is used for closing the self-saving function of a document; obtaining a data table grid form according to the initial operation type information, wherein the data table contains service field information; obtaining an editing control range according to the data table lattice form; acquiring a service processing type and corresponding service field information according to the initial operation type information; obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information; according to the operation data result, obtaining a display instruction for performing single-page display on the operation data result; and obtaining the stored updating data according to the operation data result. The technical problem that support for isomorphic data batch input is lacked, documents can only be opened one by one in a view and saved after form editing, and input efficiency exists is solved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for realizing a Domino data table component.
Background
"Domino" is a group work software. Domino has rich interfaces and is mainly used for assisting multiple persons to work cooperatively, so that the limitation of a platform, technology, organization and geography is broken through, and the sharing of information and technology is fully realized. The software has taken a leading position in the fields of enterprise-level basic communication, office automation, information release and the like at present, and is widely applied to domestic enterprises and public institutions. The Domino application takes forms as a data display or input interface, and one form stores one entity data record. Limited to the features of Domino document type databases, batch maintenance of multiple entities or multiple instances of data of an entity cannot be achieved in a single form.
However, in the process of implementing the technical solution of the invention in the embodiments of the present application, the inventors of the present application find that the above-mentioned technology has at least the following technical problems:
in the prior art, the Domino application development lacks support for isomorphic data batch input, and only can open documents one by one in a view and store the documents after editing on a form, so that the technical problems of poor input efficiency and poor user experience exist.
Disclosure of Invention
The embodiment of the application provides a method and a device for realizing a Domino data form component, and solves the technical problems that in the prior art, the Domino application development lacks support for isomorphic data batch input, documents can only be opened one by one in a view and are saved after being edited on a form, and the input efficiency and the user experience are poor.
In view of the foregoing problems, embodiments of the present application provide a method and an apparatus for implementing a Domino data table component.
In a first aspect, an embodiment of the present application provides an implementation method of a Domino data table component, which is applied to a Domino document, and the method includes: obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document; obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information; obtaining an editing control range according to the data table lattice form; acquiring a service processing type and the corresponding service field information according to the initial operation type information; obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information; obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page; and obtaining the stored and updated data according to the operation data result.
Preferably, the document form information includes main form information and sub-form information, the main form information includes the initial operation type information and the saving option information, the sub-form information is a calculation sub-form containing a data form, and different operation type information corresponds to different data form lattice forms.
Preferably, the initial operation type information includes a filling type, a review type, a view self type, and a view all types.
Preferably, when the initial operation type information is the filling type, the method includes: obtaining first user information; acquiring first user data according to the first user information; and obtaining a first loading instruction according to the first user data, wherein the first loading instruction is used for loading the first user data into the data table.
Preferably, when the initial operation type information is the view self type, the method includes: obtaining the first user information according to the type of the viewer; acquiring the first user data according to the first user information; obtaining a second loading instruction according to the first user data; loading the first user data into the data table according to the second loading instruction.
Preferably, when the initial operation type information is the viewing all types, the method includes: obtaining viewing range information according to the viewing all types; obtaining viewing data according to the viewing range information; and obtaining a third loading instruction according to the viewing data, wherein the third loading instruction is used for loading the viewing data into the data table.
Preferably, the data table includes a plurality of rows of data, wherein each row of data corresponds to one document id information, and the number of rows of the data table is set according to a predetermined requirement.
Preferably, the data table further includes a page turning field and a page turning instruction, and the method includes: obtaining the page turning instruction; acquiring a data processing instruction according to the page turning instruction; obtaining the maximum line number of a preset data table; obtaining a data display result according to the data processing instruction and the maximum line number of the preset data table; and obtaining display information according to the data display result, wherein the display information is used for performing paging display on the data display result.
Preferably, the method comprises: obtaining the page turning instruction; obtaining batch processing scripts according to the page turning instructions; executing the batch processing script to obtain processing data table information; obtaining corresponding document id information according to the processing data table information; judging whether the document id information meets a first condition; and when the first update instruction is satisfied, obtaining a first update instruction, wherein the first update instruction is used for updating the processing data to the document corresponding to the document id information.
Preferably, after the judging whether the document id information satisfies the first condition, the method includes: when the document id information does not meet the first condition, obtaining a first creation instruction, wherein the first creation instruction is used for creating a new document; acquiring a new document domain according to the new document; and acquiring first write-in information according to the new document domain, wherein the first write-in information is used for writing the new document domain into a document id.
Preferably, the executing the batch processing script to obtain the processed data table information includes: obtaining process data, wherein the process data comprises a plurality of lines; according to the processing data, obtaining first line processing data, second line processing data and processing data till Nth line processing data, wherein N is a natural number larger than 1; executing the batch processing script, and respectively processing the first line of processing data, the second line of processing data and the Nth line of processing data line by line; and obtaining the processing data table information according to the first row processing data, the second row processing data and the processing data from the Nth row, wherein the processing data table information comprises a plurality of rows of processing data.
Preferably, the method comprises: obtaining a save instruction; obtaining the batch processing script according to the saving instruction; executing the batch processing script to obtain a processing result, wherein the processing result comprises data table information; and executing the saving instruction according to the processing result, and saving the processing result to the document corresponding to the data table.
Preferably, the method comprises: obtaining an insert sub-form instruction; obtaining the main form information according to the sub-form inserting instruction; obtaining a calculation formula; and obtaining a first execution instruction according to the calculation formula, wherein the first execution instruction is used for executing the calculation formula insertion sub-form in the main form.
In another aspect, the present application further provides an apparatus for implementing a Domino data table component, where the apparatus includes:
the device comprises a first obtaining unit, a second obtaining unit and a third obtaining unit, wherein the first obtaining unit is used for obtaining document form information, the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of a document;
a second obtaining unit, configured to obtain a data table lattice form according to the initial operation type information, where the data table lattice form corresponds to a data table, and the data table includes service field information;
a third obtaining unit, configured to obtain an editing control range according to the spreadsheet lattice form;
a fourth obtaining unit, configured to obtain a service processing type and the corresponding service field information according to the initial operation type information;
a fifth obtaining unit, configured to obtain an operation data result according to the editing control range, the service processing type, and the corresponding service field information;
a sixth obtaining unit, configured to obtain a display instruction according to the operation data result, where the display instruction is used to perform single-page display on the operation data result;
a seventh obtaining unit, configured to obtain save update data according to the operation data result.
In a third aspect, the present invention provides an apparatus for implementing a Domino data table component, comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the method according to any one of the first aspect when executing the program.
One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:
the embodiment of the application provides a method and a device for realizing a Domino data form component, which are applied to a Domino document and used for obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document; obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information; obtaining an editing control range according to the data table lattice form; acquiring a service processing type and the corresponding service field information according to the initial operation type information; obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information; obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page; and obtaining the stored and updated data according to the operation data result. The form is used as an interface for data display or editing, the function of storing records of the form is cut off by setting a document storage option, a plurality of records are written in through script batch processing before document storage so as to realize convenient data maintenance, and the technical effect of batch maintenance of isomorphic data in a single page is realized, so that the technical problems that support for the batch input of the isomorphic data is lacked in Domino application development in the prior art, the documents can only be opened one by one in a view and are edited and then stored on the form, and the input efficiency and the user experience are poor are solved.
The foregoing description is only an overview of the technical solutions of the present application, and the present application can be implemented according to the content of the description in order to make the technical means of the present application more clearly understood, and the following detailed description of the present application is given in order to make the above and other objects, features, and advantages of the present application more clearly understandable.
Drawings
FIG. 1 is a flowchart illustrating a method for implementing a Domino data table component according to an embodiment of the present disclosure;
FIG. 2 is a schematic structural diagram of an apparatus for implementing a Domino data table component according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of an exemplary electronic device according to an embodiment of the present application.
Description of reference numerals: a first obtaining unit 11, a second obtaining unit 12, a third obtaining unit 13, a fourth obtaining unit 14, a fifth obtaining unit 15, a sixth obtaining unit 16, a seventh obtaining unit 17, a bus 300, a receiver 301, a processor 302, a transmitter 303, a memory 304, and a bus interface 306.
Detailed Description
The embodiment of the application provides a method and a device for realizing a Domino data form component, and solves the technical problems that in the prior art, the Domino application development lacks support for isomorphic data batch input, documents can only be opened one by one in a view and are saved after being edited on a form, and the input efficiency and the user experience are poor.
Hereinafter, example embodiments according to the present application will be described in detail with reference to the accompanying drawings. It should be apparent that the described embodiments are merely some embodiments of the present application and not all embodiments of the present application, and it should be understood that the present application is not limited to the example embodiments described herein.
Summary of the application
The Domino application takes forms as a data display or input interface, and one form stores one entity data record. Limited to the features of Domino document type databases, batch maintenance of multiple entities or multiple instances of data of an entity cannot be achieved in a single form. In the prior art, the Domino application development lacks support for isomorphic data batch input, and only can open documents one by one in a view and store the documents after editing on a form, so that the technical problems of poor input efficiency and poor user experience exist.
In view of the above technical problems, the technical solution provided by the present application has the following general idea:
the embodiment of the application provides a method for realizing a Domino data table component, which is applied to a Domino document and comprises the following steps: obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document; obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information; obtaining an editing control range according to the data table lattice form; acquiring a service processing type and the corresponding service field information according to the initial operation type information; obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information; obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page; and obtaining the stored and updated data according to the operation data result. The method achieves the technical effects that the form is used as an interface for data display or editing, the function of storing records in the form is cut off by setting a document storage option, and then a plurality of records are written in through script batch processing before document storage so as to realize convenient data maintenance, so that the batch maintenance of isomorphic data in a single page is realized.
Having thus described the general principles of the present application, various non-limiting embodiments thereof will now be described in detail with reference to the accompanying drawings.
Example one
Fig. 1 is a flowchart illustrating a method for implementing a Domino data table component according to an embodiment of the present disclosure, and as shown in fig. 1, an embodiment of the present disclosure provides a method for implementing a Domino data table component, which is applied to a Domino document, and the method includes:
step S100: obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document.
Further, the document form information includes main form information and sub-form information, the main form information includes the initial operation type information and the storage option information, the sub-form information is a calculation sub-form containing a data form, and different operation type information corresponds to different data form lattice forms.
Specifically, the embodiment of the application sets the form, and cuts off the function of storing records in the form by using the saving option of the document, and the form design is divided into a main form and a sub-form. In the main form design, there should be an initial operation type Initopr field, a save options SaveOptions field, and a calculated sub-form containing a data form. The default value of saveoperations is set to be 0, the self-saving function of the document can be closed, the self-automatic saving function of the document can be skipped through the saving options set by the user, and because the current Domino document is saved as one record and the fields are saved together when the Domino document is stored, the situation of repeated saving exists.
Step S200: and obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information.
Step S300: and obtaining an editing control range according to the data table lattice form.
Further, the data table includes a plurality of rows of data, wherein each row of data corresponds to one document id information, and the number of rows of the data table is set according to a predetermined requirement.
Specifically, different spreadsheet grid forms should be used for different operation types, to control the scope of editing, such as "fill in | Create" editable fields 1 and 2, "Review | Review" read only fields 1 and 2, "edit field 3," view oneself | ReadMine, "and" view all | ReadAll "read only all fields. The data table should contain business fields, document UNIDs corresponding to row records, and fields and buttons for turning pages, the domain names in the table are in the format of T _ m _ n (as shown in the following table), and the number of rows in the table can be determined as required.
| Field 1 | Field 2 | Field 3 | Document id |
| T_1_1 | T_2_1 | T_3_1 | ID_1 |
| T_1_2 | T_2_2 | T_3_2 | ID_2 |
| T_1_3 | T_2_3 | T_3_3 | ID_3 |
Step S400: and acquiring a service processing type and the corresponding service field information according to the initial operation type information.
Further, the initial operation type information includes a filling type, a review type, a view self type, and a view all types.
Specifically, the initial operation types generally include a filling type, a review type, a viewing self type, and a viewing all types, but are not limited thereto, and may be expanded according to requirements. For different initial operation types, there are different fields and data table ranges to process.
Step S500: and obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information.
Specifically, for different operation types, corresponding to different operation ranges, different data table lattice forms are provided, control of different editing ranges is achieved, relevant data are inquired through a background, the data are loaded into the data tables, the data tables corresponding to the different operation types are provided with service fields, document UNIDs corresponding to row records, fields and buttons for page turning, corresponding processing is carried out according to the field content of service processing in the editing range according to the processing requirements of the service field information corresponding to the different operation types, and operation data results are obtained, wherein the processing results comprise filling types, review types, own types, all types and the like.
Step S600: and obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page.
Particularly, when data are processed, all data can be checked in a single page, searching is convenient, one record is not opened any more, time and labor are wasted, a plurality of pieces of data can be checked in the single page, contents searched by editing can be seen at a glance, meanwhile, the contents can be searched for as required to set keywords, content retrieval is carried out according to the keywords, and efficiency is improved.
Step S700: and obtaining the stored and updated data according to the operation data result.
Specifically, the data processing result can be stored according to the storage requirement, the storage process is one-row-one-line storage, and the corresponding field content is stored instead of being stored integrally when the service contains a plurality of field contents, so that the problem that the existing Domino document stores all the field contents in the form integrally and is stored repeatedly is solved. The form is used as an interface for data display or editing, the function of storing records of the form is cut off by setting a document storage option, a plurality of records are written in through script batch processing before document storage so as to realize convenient data maintenance, and batch maintenance of isomorphic data in a single page is realized, so that the technical problems that support for isomorphic data batch input is lacked in Domino application development in the prior art, documents can only be opened one by one in a view and are edited and then stored on the form, and the input efficiency and the user experience are poor are solved. The technical effects that the batch storage processing of data table data is realized by cutting off the self storage function of the document, storing and inquiring Querysve and a page turning function, and the data table displays a large amount of data in a single page and edits the data efficiently are achieved.
Further, when the initial operation type information is the filling type, the method includes: obtaining first user information; acquiring first user data according to the first user information; and obtaining a first loading instruction according to the first user data, wherein the first loading instruction is used for loading the first user data into the data table.
Further, when the initial operation type information is the view self type, the method includes: obtaining the first user information according to the type of the viewer; acquiring the first user data according to the first user information; obtaining a second loading instruction according to the first user data; loading the first user data into the data table according to the second loading instruction.
Further, when the initial operation type information is the viewing all types, the method includes: obtaining viewing range information according to the viewing all types; obtaining viewing data according to the viewing range information; and obtaining a third loading instruction according to the viewing data, wherein the third loading instruction is used for loading the viewing data into the data table.
Specifically, the embodiment of the present application includes a process of data loading, which transfers an initial operation type (usually, "fill | Create", "Review | Review", "view own | ReadMine", "view all | ReadAll", etc.), queries and loads corresponding data. When filling in the data form, the data of the current user is inquired through the background and then loaded into the data form. When the data table is viewed, the data in the viewing range is queried in the background in the same way and then loaded into the data table. In order to improve loading efficiency and experience, uidoc.
Further, the method comprises: obtaining the page turning instruction; obtaining batch processing scripts according to the page turning instructions; executing the batch processing script to obtain processing data table information; obtaining corresponding document id information according to the processing data table information; judging whether the document id information meets a first condition; and when the first update instruction is satisfied, obtaining a first update instruction, wherein the first update instruction is used for updating the processing data to the document corresponding to the document id information.
Further, the determining whether the document id information satisfies a first condition includes: when the document id information does not meet the first condition, obtaining a first creation instruction, wherein the first creation instruction is used for creating a new document; acquiring a new document domain according to the new document; and acquiring first write-in information according to the new document domain, wherein the first write-in information is used for writing the new document domain into a document id.
Further, the executing the batch processing script to obtain the processing data table information includes: obtaining process data, wherein the process data comprises a plurality of lines; according to the processing data, obtaining first line processing data, second line processing data and processing data till Nth line processing data, wherein N is a natural number larger than 1; executing the batch processing script, and respectively processing the first line of processing data, the second line of processing data and the Nth line of processing data line by line; and obtaining the processing data table information according to the first row processing data, the second row processing data and the processing data from the Nth row, wherein the processing data table information comprises a plurality of rows of processing data.
Further, the method comprises: obtaining a save instruction; obtaining the batch processing script according to the saving instruction; executing the batch processing script to obtain a processing result, wherein the processing result comprises data table information; and executing the saving instruction according to the processing result, and saving the processing result to the document corresponding to the data table.
Specifically, in the data unloading operation process according to the embodiment of the present application, when a save button is clicked or a page is turned, if the initial operation type is "fill | Create" or "Review | Review", a batch save/update script is invoked to process data line by line, when a document id is empty, a document is created and written back to a document id field, and when the document id is not empty, the current line data is updated to the document. The method and the device have the advantages that the repeated fields can be prevented from being repeatedly stored by processing and storing the data table one row by one line, and batch operation processing can be realized.
Further, the data table further includes a page turning field and a page turning instruction, and the method includes: obtaining the page turning instruction; acquiring a data processing instruction according to the page turning instruction; obtaining the maximum line number of a preset data table; obtaining a data display result according to the data processing instruction and the maximum line number of the preset data table; and obtaining display information according to the data display result, wherein the display information is used for performing paging display on the data display result.
Specifically, the embodiment of the application comprises a data paging function, when the number of data exceeds the maximum line number Limit of a data table design, paging processing is needed, and when pages are turned, the consistency of a data range is ensured through an initial operation type.
In the embodiment of the application, functions such As data loading, data unloading, data paging and the like are all encapsulated into a function datagridlmpl (uidic As notesoruidocument, opr As String), and when the function is called, the current uidic (incoming service data) and the operation type are transmitted, for example, a problem table is registered in an examination bill, a Call datagridlmpl (uidic, "Create") is called to open the problem table, and for example, the problem table needs to be checked, and the Call datagridlmpl (uidic, "read") is called. Call DataGridImpl (uidoc, "PageUp/PageDown") is called when paging, and Call DataGridImpl (uidoc, "Save") is saved or before paging. The embodiment of the application is used for loading, displaying, editing and batch unloading data by designing the form which contains the data table and does not store the data. When the form is opened, data is inquired through a background and loaded into a data table, and a plurality of pieces of data can be checked on a single page; when saving or page turning is clicked, the data in the current page data table is transferred or updated line by line.
Further, the method comprises: obtaining an insert sub-form instruction; obtaining the main form information according to the sub-form inserting instruction; obtaining a calculation formula; and obtaining a first execution instruction according to the calculation formula, wherein the first execution instruction is used for executing the calculation formula insertion sub-form in the main form.
Specifically, a sub-form is inserted in the main form using a calculation formula (e.g., @ If (@ IsMember; "ReadAll": ReadMine ");" sfXX _ Read ";" InitOpr ═ Review ";" sfXX _ EditB ";" sfXX _ EditA ")). In order to realize that the sub-forms are changed along with the operation types, a file is created by a successive stage, the initial operation type is Set, and then the file is edited by using a UI working space, but the Set newUIDoc ═ ws.
The reference script is as follows:
Set doc＝db.Createdocument()
doc.Form＝"fXXList"
doc.InitOpr＝opr
Set uidoc＝ws.Editdocument(True,doc)
Set doc＝uidoc.Document
the above is merely a reference script and is not particularly limited.
Example two
Based on the same inventive concept as the method for implementing a Domino data table component in the foregoing embodiment, the present invention further provides an apparatus for implementing a Domino data table component, as shown in fig. 2, where the apparatus includes:
the first obtaining unit 11 is configured to obtain document form information, where the document form information includes initial operation type information and saving option information, and the saving option information is used to close a document self-saving function;
a second obtaining unit 12, where the second obtaining unit 12 is configured to obtain a data table lattice form according to the initial operation type information, where the data table lattice form corresponds to a data table, and the data table includes service field information;
a third obtaining unit 13, where the third obtaining unit 13 is configured to obtain an editing control range according to the spreadsheet lattice form;
a fourth obtaining unit 14, where the fourth obtaining unit 14 is configured to obtain a service processing type and the corresponding service field information according to the initial operation type information;
a fifth obtaining unit 15, where the fifth obtaining unit 15 is configured to obtain an operation data result according to the editing control range, the service processing type, and the corresponding service field information;
a sixth obtaining unit 16, where the sixth obtaining unit 16 is configured to obtain a display instruction according to the operation data result, where the display instruction is used to display the operation data result on a single page;
a seventh obtaining unit 17, where the seventh obtaining unit 17 is configured to obtain saving update data according to the operation data result.
Further, the document form information includes main form information and sub-form information, the main form information includes the initial operation type information and the storage option information, the sub-form information is a calculation sub-form containing a data form, and different operation type information corresponds to different data form lattice forms.
Further, the initial operation type information includes a filling type, a review type, a viewing self type, and a viewing all types.
Further, the apparatus further comprises:
an eighth obtaining unit, configured to obtain first user information when the initial operation type information is the filling type;
a ninth obtaining unit, configured to obtain first user data according to the first user information;
a tenth obtaining unit, configured to obtain a first loading instruction according to the first user data, where the first loading instruction is used to load the first user data into the data table.
Further, the apparatus further comprises:
an eleventh obtaining unit, configured to, when the initial operation type information is the viewing self type, obtain the first user information according to the viewing self type;
a twelfth obtaining unit, configured to obtain the first user data according to the first user information;
a thirteenth obtaining unit, configured to obtain a second loading instruction according to the first user data;
a first execution unit to load the first user data into the data table according to the second load instruction.
Further, the apparatus further comprises:
a fourteenth obtaining unit, configured to, when the initial operation type information is the all viewing types, obtain viewing range information according to the all viewing types;
a fifteenth obtaining unit, configured to obtain viewing data according to the viewing range information;
a sixteenth obtaining unit, configured to obtain, according to the view data, a third load instruction, where the third load instruction is used to load the view data into the data table.
Further, the data table comprises a plurality of rows of data, wherein each row of data corresponds to one document id information, and the rows of the data table are set according to a preset requirement.
Further, the data table further includes a page turning field and a page turning instruction, and the apparatus further includes:
a seventeenth obtaining unit, configured to obtain the page turning instruction;
an eighteenth obtaining unit, configured to obtain a data processing instruction according to the page turning instruction;
a nineteenth obtaining unit, configured to obtain a maximum row number of a preset data table;
a twentieth obtaining unit, configured to obtain a data display result according to the data processing instruction and the maximum row number of the preset data table;
a twenty-first obtaining unit, configured to obtain display information according to the data display result, where the display information is used to perform paging display on the data display result.
Further, the apparatus further comprises:
a twenty-second obtaining unit, configured to obtain the page-turning instruction;
a twenty-third obtaining unit, configured to obtain a batch processing script according to the page turning instruction;
a twenty-fourth obtaining unit, configured to execute the batch processing script and obtain processed data table information;
a twenty-fifth obtaining unit, configured to obtain the corresponding document id information according to the processing data table information;
a first judgment unit configured to judge whether the document id information satisfies a first condition;
a twenty-sixth obtaining unit, configured to, when the first update instruction is satisfied, obtain a first update instruction, where the first update instruction is used to update processing data to a document corresponding to the document id information.
Further, the apparatus further comprises:
a twenty-seventh obtaining unit, configured to obtain, when the document id information does not satisfy the first condition, a first creation instruction, where the first creation instruction is used to newly create a document;
a twenty-eighth obtaining unit, configured to obtain a new document domain according to the new document;
a twenty-ninth obtaining unit, configured to obtain, according to the new document domain, first writing information, where the first writing information is used to write the new document domain into a document id.
Further, the apparatus further comprises:
a thirtieth obtaining unit configured to obtain processed data, wherein the processed data includes a plurality of lines;
a thirty-first obtaining unit, configured to obtain, according to the processing data, a first line of processing data, a second line of processing data, and up to an nth line of processing data, where N is a natural number greater than 1;
the second execution unit is used for executing the batch processing script and respectively processing the first line of processing data, the second line of processing data and the Nth line of processing data line by line;
a thirty-second obtaining unit, configured to obtain the processed data table information according to the first row of processed data, the second row of processed data, and up to the nth row of processed data, where the processed data table information includes multiple rows of processed data.
Further, the apparatus further comprises:
a thirty-third obtaining unit, configured to obtain a save instruction;
a thirty-fourth obtaining unit, configured to obtain the batch processing script according to the saving instruction;
a thirty-fifth obtaining unit, configured to execute the batch processing script to obtain a processing result, where the processing result includes data table information;
and the third execution unit is used for executing the saving instruction according to the processing result and saving the processing result to a document corresponding to the data table.
Further, the apparatus further comprises:
a thirty-sixth obtaining unit to obtain an insert sub-table instruction;
a thirty-seventh obtaining unit, configured to obtain the main form information according to the insert sub-form instruction;
a thirty-eighth obtaining unit, configured to obtain a calculation formula;
a thirty-ninth obtaining unit, configured to obtain a first execution instruction according to the calculation formula, where the first execution instruction is used to execute the calculation formula insertion sub-form in the main form.
Various changes and specific examples of the implementation method of a Domino data table component in the first embodiment of fig. 1 are also applicable to the implementation apparatus of a Domino data table component in the present embodiment, and through the foregoing detailed description of the implementation method of a Domino data table component, those skilled in the art can clearly know the implementation method of the implementation apparatus of a Domino data table component in the present embodiment, so for the brevity of the description, detailed descriptions are omitted here.
Exemplary electronic device
The electronic device of the embodiment of the present application is described below with reference to fig. 3.
Fig. 3 illustrates a schematic structural diagram of an electronic device according to an embodiment of the present application.
Based on the inventive concept of the method for implementing a Domino data table component in the foregoing embodiments, the present invention further provides an apparatus for implementing a Domino data table component, on which a computer program is stored, and when the computer program is executed by a processor, the apparatus implements the steps of any one of the methods for implementing a Domino data table component described above.
Where in fig. 3 a bus architecture (represented by bus 300), bus 300 may include any number of interconnected buses and bridges, bus 300 linking together various circuits including one or more processors, represented by processor 302, and memory, represented by memory 304. The bus 300 may also link together various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface 306 provides an interface between the bus 300 and the receiver 301 and transmitter 303. The receiver 301 and the transmitter 303 may be the same element, i.e., a transceiver, providing a means for communicating with various other systems over a transmission medium.
The processor 302 is responsible for managing the bus 300 and general processing, and the memory 304 may be used for storing data used by the processor 302 in performing operations.
One or more technical solutions in the embodiments of the present application have at least one or more of the following technical effects:
the embodiment of the application provides a method and a device for realizing a Domino data form component, which are applied to a Domino document and used for obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document; obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information; obtaining an editing control range according to the data table lattice form; acquiring a service processing type and the corresponding service field information according to the initial operation type information; obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information; obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page; and obtaining the stored and updated data according to the operation data result. The form is used as an interface for data display or editing, the function of storing records of the form is cut off by setting a document storage option, a plurality of records are written in through script batch processing before document storage so as to realize convenient data maintenance, and the technical effect of batch maintenance of isomorphic data in a single page is realized, so that the technical problems that support for the batch input of the isomorphic data is lacked in Domino application development in the prior art, the documents can only be opened one by one in a view and are edited and then stored on the form, and the input efficiency and the user experience are poor are solved.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create a system for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks. While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (15)
1. A realization method of a Domino data table component is applied to a Domino document, wherein the method comprises the following steps:
obtaining document form information, wherein the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of the document;
obtaining a data table lattice form according to the initial operation type information, wherein the data table lattice form corresponds to a data table, and the data table contains service field information;
obtaining an editing control range according to the data table lattice form;
acquiring a service processing type and the corresponding service field information according to the initial operation type information;
obtaining an operation data result according to the editing control range, the service processing type and the corresponding service field information;
obtaining a display instruction according to the operation data result, wherein the display instruction is used for displaying the operation data result in a single page;
and obtaining the stored and updated data according to the operation data result.
2. The method of claim 1, wherein the document form information includes main form information including the initial operation type information and the saving option information, and sub-form information which is a calculation sub-form containing a data form, wherein different operation type information corresponds to different data form lattice forms.
3. The method of claim 1, wherein the initial operation type information includes a fill type, a review type, a view self type, a view all types.
4. The method of claim 3, wherein when the initial operation type information is the filling type, the method comprises:
obtaining first user information;
acquiring first user data according to the first user information;
and obtaining a first loading instruction according to the first user data, wherein the first loading instruction is used for loading the first user data into the data table.
5. The method of claim 4, wherein when the initial operation type information is the view self type, the method comprises:
obtaining the first user information according to the type of the viewer;
acquiring the first user data according to the first user information;
obtaining a second loading instruction according to the first user data;
loading the first user data into the data table according to the second loading instruction.
6. The method of claim 3, wherein the initial operation type information is the view all types, the method comprising:
obtaining viewing range information according to the viewing all types;
obtaining viewing data according to the viewing range information;
and obtaining a third loading instruction according to the viewing data, wherein the third loading instruction is used for loading the viewing data into the data table.
7. The method of claim 1, wherein the data table comprises a plurality of rows of data, wherein each row of data corresponds to a document id information, and wherein the number of rows of the data table is set according to a predetermined requirement.
8. The method of claim 7, wherein the data table further comprises a page flip field and a page flip instruction, the method comprising:
obtaining the page turning instruction;
acquiring a data processing instruction according to the page turning instruction;
obtaining the maximum line number of a preset data table;
obtaining a data display result according to the data processing instruction and the maximum line number of the preset data table;
and obtaining display information according to the data display result, wherein the display information is used for performing paging display on the data display result.
9. The method of claim 8, wherein the method comprises:
obtaining the page turning instruction;
obtaining batch processing scripts according to the page turning instructions;
executing the batch processing script to obtain processing data table information;
obtaining corresponding document id information according to the processing data table information;
judging whether the document id information meets a first condition;
and when the first update instruction is satisfied, obtaining a first update instruction, wherein the first update instruction is used for updating the processing data to the document corresponding to the document id information.
10. The method of claim 9, wherein said determining whether the document id information satisfies a first condition comprises:
when the document id information does not meet the first condition, obtaining a first creation instruction, wherein the first creation instruction is used for creating a new document;
acquiring a new document domain according to the new document;
and acquiring first write-in information according to the new document domain, wherein the first write-in information is used for writing the new document domain into a document id.
11. The method of claim 9, wherein said executing the batch processing script to obtain processed data table information comprises:
obtaining process data, wherein the process data comprises a plurality of lines;
according to the processing data, obtaining first line processing data, second line processing data and processing data till Nth line processing data, wherein N is a natural number larger than 1;
executing the batch processing script, and respectively processing the first line of processing data, the second line of processing data and the Nth line of processing data line by line;
and obtaining the processing data table information according to the first row processing data, the second row processing data and the processing data from the Nth row, wherein the processing data table information comprises a plurality of rows of processing data.
12. The method of claim 11, wherein the method comprises:
obtaining a save instruction;
obtaining the batch processing script according to the saving instruction;
executing the batch processing script to obtain a processing result, wherein the processing result comprises data table information;
and executing the saving instruction according to the processing result, and saving the processing result to the document corresponding to the data table.
13. The method of claim 2, wherein the method comprises:
obtaining an insert sub-form instruction;
obtaining the main form information according to the sub-form inserting instruction;
obtaining a calculation formula;
and obtaining a first execution instruction according to the calculation formula, wherein the first execution instruction is used for executing the calculation formula insertion sub-form in the main form.
14. An apparatus for implementing a Domino data table component, wherein the apparatus comprises:
the device comprises a first obtaining unit, a second obtaining unit and a third obtaining unit, wherein the first obtaining unit is used for obtaining document form information, the document form information comprises initial operation type information and saving option information, and the saving option information is used for closing the self-saving function of a document;
a second obtaining unit, configured to obtain a data table lattice form according to the initial operation type information, where the data table lattice form corresponds to a data table, and the data table includes service field information;
a third obtaining unit, configured to obtain an editing control range according to the spreadsheet lattice form;
a fourth obtaining unit, configured to obtain a service processing type and the corresponding service field information according to the initial operation type information;
a fifth obtaining unit, configured to obtain an operation data result according to the editing control range, the service processing type, and the corresponding service field information;
a sixth obtaining unit, configured to obtain a display instruction according to the operation data result, where the display instruction is used to perform single-page display on the operation data result;
a seventh obtaining unit, configured to obtain save update data according to the operation data result.
15. An apparatus for implementing a Domino data table component, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method of any one of claims 1-13 when executing the program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110178206.3A CN112883012B (en) | 2021-02-08 | 2021-02-08 | Implementation method and device of Domino data table component |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110178206.3A CN112883012B (en) | 2021-02-08 | 2021-02-08 | Implementation method and device of Domino data table component |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112883012A true CN112883012A (en) | 2021-06-01 |
| CN112883012B CN112883012B (en) | 2022-10-28 |
Family
ID=76056220
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110178206.3A Active CN112883012B (en) | 2021-02-08 | 2021-02-08 | Implementation method and device of Domino data table component |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112883012B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216849A (en) * | 2008-01-11 | 2008-07-09 | 清华大学 | Document automatic creation method based on integration business model |
| CN104504160A (en) * | 2015-01-20 | 2015-04-08 | 中国地质大学（武汉） | Excel document online batch write-in method based on SSH frame |
| CN107402910A (en) * | 2017-07-07 | 2017-11-28 | 北京今目标信息技术有限公司 | Data managing method, equipment and computer-readable recording medium based on list |
| CN109725933A (en) * | 2018-05-24 | 2019-05-07 | 中国平安人寿保险股份有限公司 | Big data document structure tree method, apparatus, equipment and computer readable storage medium |
| CN110196971A (en) * | 2019-04-23 | 2019-09-03 | 平安科技（深圳）有限公司 | Online document edit methods, device, terminal device and storage medium |
| CN112183036A (en) * | 2019-06-18 | 2021-01-05 | 腾讯科技（深圳）有限公司 | Format document generation method, device, equipment and storage medium |
| CN112257005A (en) * | 2020-11-10 | 2021-01-22 | 北京乐我无限科技有限责任公司 | Form component generation method and device |
-
2021
- 2021-02-08 CN CN202110178206.3A patent/CN112883012B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216849A (en) * | 2008-01-11 | 2008-07-09 | 清华大学 | Document automatic creation method based on integration business model |
| CN104504160A (en) * | 2015-01-20 | 2015-04-08 | 中国地质大学（武汉） | Excel document online batch write-in method based on SSH frame |
| CN107402910A (en) * | 2017-07-07 | 2017-11-28 | 北京今目标信息技术有限公司 | Data managing method, equipment and computer-readable recording medium based on list |
| CN109725933A (en) * | 2018-05-24 | 2019-05-07 | 中国平安人寿保险股份有限公司 | Big data document structure tree method, apparatus, equipment and computer readable storage medium |
| CN110196971A (en) * | 2019-04-23 | 2019-09-03 | 平安科技（深圳）有限公司 | Online document edit methods, device, terminal device and storage medium |
| CN112183036A (en) * | 2019-06-18 | 2021-01-05 | 腾讯科技（深圳）有限公司 | Format document generation method, device, equipment and storage medium |
| CN112257005A (en) * | 2020-11-10 | 2021-01-22 | 北京乐我无限科技有限责任公司 | Form component generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112883012B (en) | 2022-10-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6757867B2 (en) | Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes | |
| US7143338B2 (en) | Method and system in an electronic spreadsheet for handling absolute references in a copy/cut and paste operation according to different modes | |
| US6725422B1 (en) | Method and system in an electronic spreadsheet for introducing new elements in a cell named range according to different modes | |
| US20090228776A1 (en) | Dynamic formulas for spreadsheet cells | |
| US9280264B2 (en) | Multi-source, multi-destination data transfers | |
| JP7209306B2 (en) | Online work system for Excel documents based on templates | |
| US8782508B2 (en) | Manipulating labelled data for data entry in management applications | |
| WO2007000375A2 (en) | Method and system for hiding sensitive data within models in an electronic spreadsheet environment | |
| US20090049025A1 (en) | System and method for harvesting service metadata from an architecture diagram into a metadata repository | |
| CN109213480A (en) | A kind of method, storage medium, equipment and system for developing the back-stage management page | |
| JP7339628B2 (en) | Online report creation system using Excel tools | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN115840567A (en) | Application editing method and related equipment | |
| EP2157535A1 (en) | Fast search views over business objects | |
| CN112883012B (en) | Implementation method and device of Domino data table component | |
| WO2007072051A2 (en) | Data tracking system | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| US20070206010A1 (en) | Computer readable recording medium recorded with graphics editing program, and graphics editing apparatus | |
| US20040249852A1 (en) | Method and system in an electronic data table for managing order oriented criterias | |
| US20080319780A1 (en) | Defining reports for dimension based enterprise resource planning systems | |
| CN116611418B (en) | Report processing method and device based on online editing, electronic equipment and medium | |
| CN101739466A (en) | File managing method and file managing device | |
| CN114418392A (en) | Business modeling method and device for workflow, computer equipment and storage medium | |
| JP2022097358A (en) | On-line report creation system having query binding function | |
| CN103902276A (en) | Information processing method and electronic device |
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 |