CN110543303A - Visual business platform - Google Patents
Visual business platform Download PDFInfo
- Publication number
- CN110543303A CN110543303A CN201910662392.0A CN201910662392A CN110543303A CN 110543303 A CN110543303 A CN 110543303A CN 201910662392 A CN201910662392 A CN 201910662392A CN 110543303 A CN110543303 A CN 110543303A
- Authority
- CN
- China
- Prior art keywords
- business
- dictionary
- query
- data
- business document
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Abstract
the invention discloses a visual business platform, which comprises a business form modeling device and a business data query device, wherein the business form modeling device comprises: a dictionary modeler for generating an editable dictionary based on interaction with a user on the visual interface; the business document modeler is used for generating an editable business document and an approval object corresponding to the business document based on interaction with a user on a visual interface; the business data query device is used for querying business data corresponding to a field to be queried in a query instruction input by a user in a query report based on interaction with the user on a visual interface, and outputting a query result. According to the visual business platform, business logic implementation is configured from the foreground, code compiling is not involved in the process, business logic is visual, users and implementers participate in the system development process, the users can customize all function display pages, the change requirements of the users can be responded quickly, and flexibility is high.
Description
Technical Field
the invention relates to the technical field of computer software, in particular to a visual service platform.
background
with the increase of company business, various conditions and continuous changes of the process in the business communication process gradually diversify the requirements on the business form, and the complexity of the business form also continuously increases. The existing business form realized in a coding mode obviously cannot meet the requirements of people. The service form implemented in the form of code may fix the format of the service form, that is, neither the header nor the data column of the service form can be adjusted. If the format of the business form is adjusted, the business form can be modified only by rewriting the code or modifying the original code.
In addition, enterprises generate a large amount of form data during production work, and most of the form data is stored in a business database. When a certain amount of data is reached or the number of data satisfying the query condition is large, it usually takes a long time to query the required data from the business database, which brings inconvenience to the statistics and summarization work of each department.
therefore, a visual business platform capable of solving the above problems is needed.
disclosure of Invention
In order to solve the above technical problems, the present invention provides a visual service platform, which comprises a service form modeling device and a service data query device,
Wherein, the business form modeling device comprises:
A dictionary modeler for generating an editable dictionary based on interaction with a user on the visual interface; and
The business document modeler is used for generating an editable business document and an approval object corresponding to the business document based on interaction with a user on a visual interface;
The business data query device is used for querying business data corresponding to a field to be queried in a query instruction input by a user in a query report based on interaction with the user on a visual interface, and outputting a query result.
Preferably, the dictionary modeler comprises:
The dictionary type determining module is used for determining the dictionary type according to a first instruction of a user;
The dictionary template determining module is used for determining a dictionary template to be selected according to the dictionary type and selecting the dictionary template to be edited from the dictionary template to be selected according to a second instruction of a user; and
The dictionary generating module is used for editing the dictionary template to be edited according to a third instruction of a user so as to generate an editable dictionary;
The business document modeler comprises:
The business document type determining module is used for determining the type of the business document according to a fourth instruction of the user;
the business document template determining module is used for determining a business document template to be selected according to the business document type and selecting the business document template to be edited from the business document template to be selected according to a fifth instruction of a user; and
And the business document generating module is used for editing the business document template to be edited according to a sixth instruction of the user so as to generate an editable business document and generate an approval object corresponding to the business document.
preferably, the dictionary generating module is specifically configured to edit the dictionary template to be edited by editing the dictionary base attribute table and the default data column of the dictionary;
The dictionary generation module is further configured to edit the dictionary by editing the dictionary base property list and dictionary default data columns.
Preferably, the business document generating module is specifically configured to edit the selected business document template by editing a business document basic attribute table and a business document default data column;
The business document generation module is also used for editing the generated business document by editing the basic attribute list of the business document and the default data column of the business document.
preferably, the dictionary generation module is further configured to generate a help page corresponding to the generated dictionary so that data within the dictionary can be referenced.
Preferably, the business document generating module is further configured to generate a help page corresponding to the generated business document so that data in the business document can be referred to.
Preferably, the business document generating module is further configured to generate a red note corresponding to the generated business document, where the red note is used to replace the original business document when an error occurs in the entry of the business document.
Preferably, the service data query device includes:
The form data set creating unit is used for creating a form data set and enabling the data set to store a plurality of associated data objects, a plurality of fields corresponding to each data object and service data corresponding to each field;
The query report creating unit is used for creating a query report based on the data object and the field and enabling the query report to store the field serving as a query item;
The data binding unit is used for binding the business data corresponding to each field in the form data set and the cell of the row or column where the field is located aiming at each field in the query report;
The query statement generating unit is used for acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query statement corresponding to the query instruction based on a preset query language grammar rule;
And the data query unit is used for querying the business data corresponding to the field to be queried in the query report by using the query statement and outputting a query result.
Preferably, the data objects and the fields are selected from a service database in response to a selection instruction entered by a user.
preferably, the service data query device further includes: and the data processing unit is used for processing the data of the query result according to the data processing instruction input by the user.
Preferably, the data processing comprises one or more of sorting, grouping, co-searching and drilling.
preferably, the service data query device further includes: and the authority setting unit is used for setting authority for the query report according to the authority instruction input by the user.
Preferably, the rights include access rights and operation rights.
Compared with the prior art, one or more embodiments in the above scheme can have the following advantages or beneficial effects:
Through a number of different system development processes, it can be determined that: each system can not leave the four contents of modeling, menu and permission, approval process and inquiry statistics, so that the four contents are edited from a background code to a foreground for visualization, writing of some codes is avoided through visual editing, more and more general functions are visualized with optimization of each platform, writing of a part of codes is saved, and the current platform development mode which basically does not need code editing is formed.
according to the visual business platform, business logic implementation is configured from the foreground, code compiling is not involved in the process, business logic is visual, users and implementers participate in the system development process, the users can customize all function display pages, the change requirements of the users can be responded quickly, and flexibility is high.
Specifically, the dictionary modeler of the business form modeling device forming the visual business platform can rapidly and conveniently create the dictionary according to the requirements of customers, and can edit the created dictionary in the using process, namely, the dictionary format can be modified by editing the basic attribute table of the dictionary and the default data column of the dictionary, so that dictionary data can be stored and edited better. Similarly, the business document modeler can rapidly and conveniently create the business document according to the requirements of a customer in the process of obtaining the business document modeling, and the created business document can be edited in the using process, namely, the format of the business document can be modified by editing the basic attribute list of the business document and the default data list of the business document, so that the business data can be well input and edited, and the business document modeler can directly generate an approval object corresponding to the created business document, so that the business document can be circulated in a process.
In the business form modeling device forming the visual business platform, since a programmer only needs to input the query language grammar rule into the query sentence generation unit in advance, the query sentence generation unit can automatically generate the query sentence corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction which is input by a user and comprises the field to be queried, and the business data query device can effectively reduce the workload of the programmer and improve the business data query efficiency.
Drawings
the scope of the present disclosure may be better understood by reading the following detailed description of exemplary embodiments in conjunction with the accompanying drawings. Wherein the included drawings are:
FIG. 1 shows a schematic diagram of a framework for visualizing a business platform in accordance with an embodiment of the invention;
FIG. 2 is a schematic diagram of a framework of a business form modeling apparatus in an embodiment of the invention;
FIG. 3 is a flow chart diagram illustrating a modeling method of the business form modeling apparatus of FIG. 2;
Fig. 4 is a schematic flow chart illustrating a query statistics method of a service data query device according to an embodiment of the present invention;
Fig. 5 is a schematic flow chart illustrating a query statistics method of a service data query device according to an embodiment of the present invention;
Fig. 6 is a schematic diagram of a framework of a business data query device in an embodiment of the present invention;
Fig. 7 shows another frame diagram of the service data query device in the embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the following will describe in detail an implementation method of the present invention with reference to the accompanying drawings and embodiments, so that how to apply technical means to solve the technical problems and achieve the technical effects can be fully understood and implemented.
in the prior art, when a service form is generated, the format of the service form is fixed due to the service form implemented in an encoded form, that is, neither a header nor a data column of the service form can be adjusted. If the format of the business form is adjusted, the business form can be modified only by rewriting the code or modifying the original code. In addition, when the form data is subjected to query and statistics, when a certain amount of data is reached or the query conditions are met, it usually takes a long time to query the required data from the business database, which brings inconvenience to the statistics and summarization work of each department. In order to solve the technical problem, an embodiment of the present invention provides a visual service platform.
Example one
Fig. 1 shows a schematic structural diagram of a visual service platform according to an embodiment of the present invention. As shown in fig. 1, the visual service platform provided by this embodiment mainly includes a service form modeling device and a service data query device. In one aspect, the business form modeling apparatus includes a dictionary modeler and a business document modeler. The dictionary modeler is to generate an editable dictionary based on interaction with a user on the visual interface. And the business document modeler is used for generating an editable business document and an approval object corresponding to the business document based on the interaction with the user on the visual interface. On the other hand, the business data query device is used for querying the business data corresponding to the field to be queried in the query instruction input by the user in the query report based on the interaction with the user on the visual interface and outputting the query result.
through a number of different system development processes, it can be determined that: each system can not leave the four contents of modeling, menu and permission, approval process and inquiry statistics, so that the four contents are edited from a background code to a foreground for visualization, writing of some codes is avoided through visual editing, more and more general functions are visualized with optimization of each platform, writing of a part of codes is saved, and the current platform development mode which basically does not need code editing is formed. Therefore, the visual service platform provided by the invention has the advantages that the service logic is realized from the foreground configuration, the code compiling is not involved in the process, the service logic is visual, the user and implementers participate in the system development process, the user can customize all function display pages, the change requirements of the user can be quickly responded, and the flexibility is strong.
The visual service platform of the embodiment of the invention specifically comprises the following characteristics:
(1) The business logic is visualized, the business logic of the platform is realized by being configured from the foreground, the code compiling is not involved in the process, and the personalized requirements are excluded
(2) User and implementer participate in system development process
(3) User customizable all function presentation pages
(4) Quick response to user change requirements
(5) Platform modeling, menu, authority, process approval, query and statistics form a set of self-owned rapid system building system
(6) System development mode is changed, and implementing personnel are closely integrated with service
Example two
The business form modeling apparatus in the present embodiment is described in detail below with reference to fig. 2 and 3.
Fig. 2 is a block diagram of a business form modeling apparatus according to an embodiment of the present invention. Referring to fig. 2, the business form modeling apparatus of the present embodiment includes a dictionary modeler and a business receipt modeler.
The dictionary modeler includes a dictionary type determination module, a dictionary template determination module, and a dictionary generation module.
The dictionary type determining module is used for determining the dictionary type according to a first instruction of a user.
Specifically, the dictionary can be divided into a plurality of types according to preset regulations, a user inputs a first instruction according to the type of the dictionary to which the dictionary to be built belongs, the dictionary type determining module determines the type of the dictionary according to the first instruction, and meanwhile, the determined dictionary type information is sent to the dictionary template confirming module. Further, the dictionary type determination module may classify dictionary types into policy management, index system, business system, public system, etc. according to the storage contents. Assuming that a customer needs to establish a department dictionary, because the department dictionary belongs to the category of the public system, a first instruction input by a user into the dictionary type determination module is the public system, the dictionary type determination module confirms that the public system is selected, and sends the selected information of the public system to the dictionary template determination module.
The dictionary template confirming module is used for determining the dictionary templates to be selected according to the dictionary types and selecting the dictionary templates to be edited from the dictionary templates to be selected according to the second instruction of the user.
Specifically, the dictionary template confirming module receives the dictionary type information transmitted by the dictionary type confirming module, determines the corresponding dictionary template to be edited according to the dictionary type information to be established, and simultaneously, the dictionary template confirming module determines the dictionary template corresponding to the dictionary to be established in the dictionary template to be edited according to a second instruction input by a user. Furthermore, at least one dictionary template corresponding to each dictionary type is respectively stored in the dictionary template confirming module. Assuming that a department dictionary needs to be established by a client, the specific working mode of the dictionary template confirming module is as follows: receiving dictionary category information sent by the dictionary type determining module, namely the selected information of the public system, and determining dictionary templates corresponding to the public system according to the information, wherein the dictionary templates comprise a non-hierarchical dictionary template, a non-hierarchical dictionary data template (with an inner frame), a hierarchical dictionary template, a hierarchical dictionary data template (with an inner frame), an associated hierarchical dictionary and an associated hierarchical dictionary (tree-shaped and with an inner frame). And assuming that the department dictionary to be established is in a form without an inner frame in the hierarchical dictionary template, the dictionary template confirming module selects the non-hierarchical dictionary template as the template to be edited according to a second instruction of the user, namely the non-hierarchical template.
And the dictionary generating module is used for editing the selected dictionary template to be edited according to a third instruction of the user so as to generate an editable dictionary which meets the requirements of the user.
specifically, all dictionary templates include a dictionary base attribute list and a default dictionary data column corresponding thereto. The dictionary generation module edits the common attribute in the dictionary basic attribute list of the template to be edited according to a third instruction of the user, and specifically modifies the common attribute in the dictionary basic attribute list into content meeting the requirement of the dictionary to be established; and meanwhile, the dictionary generation module adds a data column in the template to be edited according to a third instruction of the user, and stores the template to be edited after the edition is finished to generate the required dictionary. It should be noted that, after the data column is added, the attribute of the added data column needs to be modified, so that the dictionary can better store the data. The dictionary generation module may be further operable to edit the generated dictionary by editing the dictionary base property tables and dictionary default data columns. Further, assuming that a department dictionary is required to be established by a client and assuming that a dictionary template to be edited is a hierarchical dictionary template, the dictionary generation module modifies table names, dictionary titles, function categories, encoding types and the like in the hierarchical dictionary template into contents corresponding to the department dictionary; and simultaneously, changing the contents of the added data column, such as column description, column name, attribute name, data type in the input column, column length, selection control type and the like, into corresponding contents. And after the modification is finished, the dictionary to be edited is stored, namely a department dictionary is generated, and the user can store corresponding department information in the department dictionary according to the requirement.
it should be noted that, the dictionary generation module generates a dictionary and also generates a help page corresponding to the dictionary at the same time, so that the data stored in the dictionary can be referred to. Meanwhile, in order to better meet the requirements of users, the generated dictionary is an editable dictionary, namely, the dictionary can be edited if the users need the dictionary. In order to better edit the template to be edited, the dictionary generation module can also generate a browsing page before storage, so as to browse the format of the template to be edited which is edited before, check whether the edition of the template to be edited meets the requirements of the user, and be more convenient for the user to edit the template to be edited.
The business document modeler comprises a business document type determining module, a business document template determining module and a business document generating module.
And the business document type determining module is used for determining the type of the business document according to the fourth instruction of the user.
Specifically, the business document can be divided into a plurality of types according to preset regulations, a user inputs a fourth instruction according to the type of the business document to which the business document to be established belongs, the business document type determining module determines the type of the business document according to the fourth instruction, and meanwhile, the determined type information of the business document is sent to the business document template determining module. Furthermore, the business document type determining module can divide the business document types into quality standard management, operation management, strategy management, customer relationship management and the like according to the management content. Supposing that a customer needs to establish an reimbursement application business document, because the reimbursement application business document belongs to the customer relationship management category, a fourth instruction input by the user to the business document type determining module is used for customer relationship management, and the business document type determining module confirms that the public system is selected and sends selected information of customer relationship management to the business document template determining module.
and the business document template confirming module is used for confirming the business document template to be selected according to the business document type and selecting the business document template to be edited from the business document template to be selected according to a fifth instruction of the user.
Specifically, the business document template confirming module receives the business document type information transmitted by the business document type confirming module, and determines a corresponding business document template to be edited according to the business document type information to be established, and meanwhile, the business document template confirming module determines a business document template corresponding to the business document to be established in the business document template to be edited according to a fifth instruction input by a user. Furthermore, at least one business document template corresponding to each business document type is respectively stored in the business document template confirming module. Assuming that the customer needs to establish a reimbursement application business document, the specific working mode of the business document template confirmation module is as follows: and receiving the business document type information sent by the business document type determining module, namely the selected information of the customer relationship management, and determining that the business document template corresponding to the customer relationship management comprises a document template and a document template without an inner frame according to the information. And if the reimbursement application business document to be established is in the form of an inner frame, the business document template confirming module selects the document template as the template to be edited according to a fifth instruction of the user, namely the document template.
The business document generating module is used for editing the selected business document template to be edited according to a sixth instruction of the user to generate an editable business document meeting the requirements of the user and simultaneously generate an approval object corresponding to the business document
Specifically, all the business document templates include a corresponding business document basic attribute list and a business document default data list. The business document generation module edits the public attribute in the business document basic attribute list of the template to be edited according to a sixth instruction of the user, and specifically modifies the public attribute in the business document basic attribute list into content meeting the requirement of the business document to be established; and meanwhile, the business document generation module also adds a data column in the template to be edited according to a sixth instruction of the user, and stores the template to be edited after the edition is finished to generate the required business document. The business document generation module can also be used for editing the generated business document by editing the basic attribute list of the business document and the default data column of the business document. It should be noted that, after the data column is added, the attribute of the added data column needs to be modified, so that the business document can better store the data. Furthermore, assuming that the customer needs to establish an reimbursement application service document, and assuming that the to-be-edited service document template is the document template, the service document generation module modifies the document title, the table name, the function category and the like in the document template into the content corresponding to the reimbursement application service document; and simultaneously, changing the contents of the added data column, such as column description, column name, attribute name, data type, column length, selection control type and the like, into corresponding contents. And after the modification is finished, the business document to be edited is stored, namely, the reimbursement application business document is generated, and meanwhile, the business document generation module also generates an approval object corresponding to the reimbursement application business document, so that the business document can be circulated in a process.
the business document generation module is also used for generating a red document corresponding to the generated business document, and the red document is used for replacing the original business document when the business document is wrongly input.
Specifically, when an original business document has an entry error in an entry process or a business itself has an error, the original business form needs to be cancelled, and a red form corresponding to the original business document needs to be generated, wherein the red form is completely the same as an original business unit, so that the entry of data is not affected.
It should be noted that, while the business document generation module generates the business document, it also generates a help page corresponding to the business document, so that the data stored in the business document can be referred. Meanwhile, in order to better meet the requirements of users, the generated business document is an editable business document, namely, the business document can be edited if the customer needs. In order to better edit the template to be edited, the business document generation module can also generate a browsing page before storage, so as to browse the format of the template to be edited which is edited before, check whether the edition of the template to be edited meets the requirements of the user, and be more convenient for the user to edit the template to be edited.
The following describes a schematic flow chart of the modeling method of the business form modeling apparatus with reference to fig. 3. Referring to fig. 3, the business form modeling method includes the following steps.
S101: and judging the type of the service form required to be established by the user.
specifically, the business form includes a dictionary and a business document, and before the business form is created, the business form to be created needs to be judged to determine a creation target.
When a user needs to create a dictionary, the following steps are as follows:
S102: the dictionary type is determined according to a first instruction of a user.
specifically, a user inputs a first instruction according to the type of the dictionary to be created, and the computer determines the type of the dictionary to be created according to the first instruction of the user. The more specific determination process is the same as the way of determining the dictionary type by the dictionary type determination module, and is not described herein again.
S103: and determining the dictionary templates to be selected according to the dictionary types, and selecting the dictionary templates to be edited from the dictionary templates to be selected according to a second instruction of the user.
Specifically, the dictionary template corresponding to the dictionary type is determined according to the determined dictionary type, and then the dictionary template to be used by the dictionary to be established is selected as the dictionary template to be edited according to the second instruction of the user. Similarly, the more specific selection process is the same as the process of determining the dictionary template and selecting the dictionary template to be edited by the dictionary template determination module, and is not repeated herein.
S104: and editing the dictionary template to be edited according to a third instruction of the user to generate an editable dictionary.
Specifically, the corresponding selected template to be edited is edited according to a third instruction of the user, so as to generate an editable dictionary. Similarly, the more specific process of editing the dictionary template to be edited is the same as the process of editing the dictionary template to be edited by the dictionary generation module, and is not repeated here.
When a user needs to create a business document, the following steps are as follows:
s202: and determining the type of the business document according to the first instruction of the user.
Specifically, the user inputs a fourth instruction according to the type of the service bill to be created, and the computer determines the type of the service bill to be created according to the fourth instruction of the user. The more specific determination process is the same as the manner of determining the type of the business document by the business document type determination module, and is not described herein again.
S203: and determining a business document template to be selected according to the type of the business document, and selecting the business document template to be edited from the business document template to be selected according to a fifth instruction of the user.
Specifically, a business document template corresponding to the business document type is determined according to the determined business document type, and then a business document template to be used by the established business document is selected as a business document template to be edited according to a fifth instruction of the user. Similarly, the more specific selection process is the same as the process of determining the business document template and selecting the business document template to be edited by the business document template confirmation module, and is not described herein again.
s204: and editing the business document template to be edited according to a sixth instruction of the user to generate an editable business document and generate an approval object corresponding to the business document.
Specifically, the corresponding template to be edited selected in the above is edited according to a sixth instruction of the user to generate an editable business document, and in order to facilitate the created business document to be circulated in the process, the computer generates the business document and simultaneously generates an approval object corresponding to the business document. Similarly, the more specific process of editing the business document template to be edited is the same as the process of editing the business document template to be edited by the business document generation module, and is not described herein again.
By applying the business form modeling device of the embodiment, the dictionary and the business form can be quickly and conveniently created according to the specific requirements of the customer, and in order to further enable the created dictionary and the created business form to meet the requirements of the customer, the created dictionary and the created business form are both in an editable form, namely, the successfully created dictionary and the successfully created business form can be edited. In addition, in the embodiment, while the dictionary and the business document are created, help pages corresponding to the created dictionary and the created business document are also generated respectively, so that data stored in the created dictionary and the created business document can be read when needed. Meanwhile, if the business document created in the embodiment has an error in the data entry process or the business itself has an error, the original business document needs to be cancelled, and at the moment, the embodiment generates a red document corresponding to the original business document so as not to influence the data entry.
EXAMPLE III
The service data query device in the present embodiment is described in detail below with reference to fig. 4 to 7.
fig. 4 is a flowchart illustrating a query statistics method of a service data query device according to an embodiment of the present invention.
as shown in fig. 4, the service data query method mainly includes the following steps S401 to S405.
in step S401, a form dataset is created and is made to hold a plurality of associated data objects, a plurality of fields corresponding to each data object, and business data corresponding to each field. The form dataset serves as a data source for the query report.
preferably, the data objects and fields are selected from the business database in response to a selection instruction entered by the user.
Specifically, based on the data that the user wants to present, the associated data object and a plurality of fields corresponding to each data object are selected from the business database according to the selection instruction input by the user, wherein each field corresponds to business data. Form datasets are created based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
Here, for convenience of understanding, the description will be given taking an example of inquiring data of the business trip reimbursement application.
First, based on the business trip reimbursement application data that the user wants to present, three associated data objects are selected from the business database according to a first selection instruction input by the user, wherein the data objects are respectively 'business trip reimbursement', 'accommodation fee' and 'transportation fee'. Next, according to a second selection instruction input by the user, the "document number", "trip location" and "trip event route" fields are selected from the "trip reimbursement" data object, the "accommodation date" and "accommodation amount" fields are selected from the "accommodation fee" data object, and the "traffic date" and "traffic fee" fields are selected from the "traffic fee" data object. Here, it should be noted that each field corresponds to service data. Finally, a form dataset is created for the business return application based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
The form data set of the embodiment of the invention is created based on the data which the user wants to show, namely, the user wants to show which data in the query report, corresponding data objects and fields are selected from the business database, and each field corresponds to business data. Therefore, the form data set can be created according to the user requirements in a self-defining mode.
in step S402, a query report is created based on the data objects and the fields, and the query report is made to hold the fields as query items.
The query reports are mainly divided into five types: detail report, unit report, floating row report, floating column report and floating row and column report. The detail report is a report in which the header of the report is fixed and the data of the report is displayed in a mode of automatically expanding downwards in a whole line. The unit report is a report in which data is displayed in a cell format, and the header of the report and the displayed data are fixed. The floating row report is a report in which the header of the report is fixed and the data of the report is displayed in a manner of automatically expanding from row to row (similar to the detailed report, but the floating row can set a floating condition, which is a component of the floating row-column report). The floating column report is a report in which the report format shows data in a column-to-right automatic expansion mode. The floating row-column report is a report in which the data is displayed in a report format in a mode of automatically expanding rows downwards and automatically expanding columns rightwards.
When the query report is created, different types of query reports can be created according to different instructions input by a user. In addition, the form style of the query report can be customized according to the instruction input by the user. For example, the table style can be obtained by importing Excel, can be obtained by introducing a template, or can be defined by the user according to requirements.
specifically, based on the data objects and fields selected by the user, a query report is created, as shown in table 1 below:
TABLE 1
The query items in the query report are fields of data objects selected by the user, namely, data which the user wants to show in the query report.
In step S403, for each field in the query report, the business data corresponding to the field in the cell and form data set of the row or column where the field is located is bound.
Specifically, for the "document number" field in the query report, the cell in the column in which the field is located is bound to the business data corresponding to the "document number" field in the form data set. That is, after data binding, the cell in the column of the "document number" in the query report only displays the business data related to the document number in the form data set. And binding the cells in the column of the field with the business data corresponding to the 'business trip location' field in the form data set aiming at the 'business trip location' field in the query report. That is, after data binding, the cell in the column of the "business trip location" in the query report only displays the business data related to the business trip location in the form data set. And repeating the steps until the cells in the columns where the fields in the query report are located are bound with the business data corresponding to the fields in the form data set.
here, it should be noted that, according to the created form style, it is determined whether to bind the service data corresponding to the field in the cell and form data set of the row where the field is located, or to bind the service data corresponding to the field in the cell and form data set of the column where the field is located. For example, according to the created form style of table 1 above, it can be determined that the business data corresponding to the field in the cell and form data set of the column where the field is located is bound.
in step S404, a query instruction including a field to be queried, which is input by a user, is obtained, and a query statement corresponding to the query instruction is automatically generated based on a preset query language grammar rule.
Specifically, when a user wants to query data related to a document number 001, the user inputs a query instruction including the document number 001, and the query statement generation unit automatically generates a query statement corresponding to the query instruction based on a preset query language grammar rule after acquiring the query instruction input by the user.
Here, it should be noted that the query statement of the embodiment of the present invention is not limited to the SQL statement. When a user wants to query business data by using other query languages except SQL sentences, only syntax rules of the query language need to be input into the query sentence generating unit in advance, and after the query sentence generating unit obtains a query instruction which is input by the user and comprises a field to be queried, the query sentence generating unit can automatically generate a query sentence corresponding to the query instruction based on the preset query language syntax rules.
in step S405, the query statement is used to query the business data corresponding to the field to be queried in the query report, and the query result is output.
Specifically, the query statement generated above is used to query the business data corresponding to the "document number 001" in the query report, and the query result is output, as shown in table 2 below.
TABLE 2
Based on this, the query of the service data can be completed.
by applying the business data query method, since a programmer only needs to input the query language grammar rule into the query sentence generation unit in advance, and the query sentence generation unit can automatically generate the query sentence corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction which is input by a user and comprises the field to be queried. In the business data query method, only the step of generating the query language grammar rules needs the participation of SQL sentences or query sentences written by other query languages, so the business data query method can effectively reduce the workload of programmers and improve the business data query efficiency.
fig. 5 is a schematic flow chart illustrating a query statistics method of a service data query device in an embodiment of the present invention. As shown in fig. 5, the service data query method herein mainly includes steps S401 to S407. Since steps S401 to S405 are the same as the example of fig. 4, no further description is given here, and only step S406 and step S407 are described in detail.
In step S406, data processing is performed on the query result according to the data processing instruction input by the user.
preferably, the data processing comprises one or more of sorting, grouping, co-searching and drilling.
Here, it should be noted that the packet includes an independent packet and a logical packet. Independent grouping refers to grouping the result data that meets the condition according to the data processing instruction input by the user. For example, when the user inputs a condition that "the traffic cost is greater than 80", data of the rows (i.e., the first row and the third row) where "the traffic cost is 200" and "the traffic cost is 100" in the query report are grouped. Logical grouping refers to grouping the same data in the query results into a group. For example, when the user inputs a condition of "accommodation amount is 200", data of the row (i.e., the first row and the second row) in which "accommodation amount is 200" in the query report is grouped.
By processing the data of the query result, the user can check the data conveniently, and the working efficiency is effectively improved.
In step S407, a permission is set for the query report according to the permission instruction input by the user.
Here, the sequence numbers of the above steps do not indicate the order of execution of the steps, and are only for convenience of description. For example, step S407 is performed after step S403 and before step S404, that is, after performing data binding on each field in the query report, and before generating the query statement corresponding to the query instruction, step S407 is performed.
Preferably, the rights include access rights and operation rights. Here, it should be noted that the operation authority is mainly used for controlling the operation of the query report by the user, for example, the operation of modifying, saving, submitting, printing, and the like of the query report by the user may be controlled. Besides, the operation authority can be used for controlling the data of the query report to be operated by the user.
by setting the authority of the query report, the access and operation authority of the user can be flexibly controlled, and the safety of query report data is effectively ensured.
By applying the business data query method shown in fig. 5, since a programmer only needs to input the query language grammar rule into the query sentence generation unit in advance, and after the query sentence generation unit obtains a query instruction including a field to be queried, which is input by a user, the query sentence corresponding to the query instruction can be automatically generated based on the preset query language grammar rule. In the business data query method, only the step of generating the query language grammar rules needs the participation of SQL sentences or query sentences written by other query languages, so the business data query method can effectively reduce the workload of programmers and improve the business data query efficiency.
in addition, the data processing is carried out on the query result and the authority setting is carried out on the query report, so that the working efficiency of the user can be effectively improved, and the safety of the query report data is ensured.
Fig. 6 shows a schematic diagram of a framework of a business data query device in an embodiment of the present invention. As shown in fig. 6, the service data query apparatus according to the embodiment of the present invention mainly includes: a form dataset creating unit 101, a query report creating unit 102, a data binding unit 103, a query statement generating unit 104, and a data querying unit 105.
specifically, the form dataset creating unit 101 is configured to create a form dataset, and make the dataset hold a plurality of associated data objects, a plurality of fields corresponding to each data object, and business data corresponding to each field.
Preferably, the data objects and fields are selected from the business database in response to a selection instruction entered by the user.
The query report creating unit 102 is configured to create a query report based on the data objects and the fields, and to store the query report with the fields as query items.
And the data binding unit 103 is configured to bind, for each field in the query report, the business data corresponding to the field in the cell and form data set of the row or column where the field is located.
The query statement generating unit 104 is configured to obtain a query instruction including a field to be queried, which is input by a user, and automatically generate a query statement corresponding to the query instruction based on a preset query language grammar rule.
And the data query unit 105 is configured to query the business data corresponding to the field to be queried in the query report by using the query statement, and output a query result.
fig. 7 shows another frame diagram of the service data query device in the embodiment of the present invention. As shown in fig. 7, the service data query apparatus according to the embodiment of the present invention mainly includes: a form dataset creating unit 101, a query report creating unit 102, a data binding unit 103, a query statement generating unit 104, a data querying unit 105, a data processing unit 106, and a permission setting unit 107. Since the form dataset creating unit 101, the query report creating unit 102, the data binding unit 103, the query statement generating unit 104, and the data querying unit 105 are the same as the example shown in fig. 6, details are not repeated here, and only the data processing unit 106 and the authority setting unit 107 are described in detail.
And the data processing unit 106 is configured to perform data processing on the query result according to the data processing instruction input by the user.
Preferably, the data processing comprises one or more of sorting, grouping, co-searching and drilling.
Here, it should be noted that the packet includes an independent packet and a logical packet. Independent grouping refers to grouping the result data that meets the condition according to the data processing instruction input by the user. For example, when the user inputs a condition that "the traffic cost is greater than 80", data of the rows (i.e., the first row and the third row) where "the traffic cost is 200" and "the traffic cost is 100" in the query report are grouped. Logical grouping refers to grouping the same data in the query results into a group. For example, when the user inputs a condition of "accommodation amount is 200", data of the row (i.e., the first row and the second row) in which "accommodation amount is 200" in the query report is grouped.
And the authority setting unit 107 is configured to set authority for the query report according to the authority instruction input by the user.
here, it should be noted that the right setting unit 107 is connected to the data binding unit 103. After each field in the query report is subjected to data binding, setting authority for the query report according to an authority instruction input by a user.
Preferably, the rights include access rights and operation rights. Here, it should be noted that the operation authority is mainly used for controlling the operation of the query report by the user, for example, the operation of modifying, saving, submitting, printing, and the like of the query report by the user may be controlled. Besides, the operation authority can be used for controlling the data of the query report to be operated by the user.
By applying the business data query device provided by the embodiment of the invention, because the query statement generating unit is arranged, a programmer only needs to input the query language grammar rule into the query statement generating unit in advance, and after the query statement generating unit acquires the query instruction which is input by a user and comprises the field to be queried, the query statement corresponding to the query instruction can be automatically generated based on the preset query language grammar rule. In the business data query device of the embodiment, only the step of generating the query language grammar rule needs the participation of the SQL statement or the query statement written by other query languages, so the business data query device of the embodiment of the invention can effectively reduce the workload of programmers and improve the business data query efficiency.
In addition, the data processing unit is arranged to process the data of the query result, and the permission setting unit is arranged to set the permission of the query report, so that the working efficiency of a user can be effectively improved, and the safety of the query report data is ensured.
Those skilled in the art will appreciate that the modules or steps of the invention described above can be implemented in a general purpose computing device, centralized on a single computing device or distributed across a network of computing devices, and optionally implemented in program code that is executable by a computing device, such that the modules or steps are stored in a memory device and executed by a computing device, fabricated separately into integrated circuit modules, or fabricated as a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
Although the embodiments of the present invention have been described above, the above description is only for the convenience of understanding the present invention, and is not intended to limit the present invention. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (13)
1. a visual service platform is characterized by comprising a service form modeling device and a service data query device,
Wherein, the business form modeling device comprises:
A dictionary modeler for generating an editable dictionary based on interaction with a user on the visual interface; and
The business document modeler is used for generating an editable business document and an approval object corresponding to the business document based on interaction with a user on a visual interface;
The business data query device is used for querying business data corresponding to a field to be queried in a query instruction input by a user in a query report based on interaction with the user on a visual interface, and outputting a query result.
2. The visual business platform of claim 1,
the dictionary modeler includes:
The dictionary type determining module is used for determining the dictionary type according to a first instruction of a user;
The dictionary template determining module is used for determining a dictionary template to be selected according to the dictionary type and selecting the dictionary template to be edited from the dictionary template to be selected according to a second instruction of a user; and
The dictionary generating module is used for editing the dictionary template to be edited according to a third instruction of a user so as to generate an editable dictionary;
The business document modeler comprises:
The business document type determining module is used for determining the type of the business document according to a fourth instruction of the user;
The business document template determining module is used for determining a business document template to be selected according to the business document type and selecting the business document template to be edited from the business document template to be selected according to a fifth instruction of a user; and
And the business document generating module is used for editing the business document template to be edited according to a sixth instruction of the user so as to generate an editable business document and generate an approval object corresponding to the business document.
3. The visual business platform of claim 2, wherein the dictionary generation module is specifically configured to edit the dictionary template to be edited by editing a dictionary base attribute table and a dictionary default data column;
The dictionary generation module is further configured to edit the dictionary by editing the dictionary base property list and dictionary default data columns.
4. a visual business platform according to claim 2, wherein the business document generation module is specifically configured to edit the selected business document template by editing a business document basic attribute table and a business document default data column;
The business document generation module is also used for editing the generated business document by editing the basic attribute list of the business document and the default data column of the business document.
5. A visual business platform according to any one of claims 2 to 4 wherein the dictionary generation module is further operable to generate a help page corresponding to the generated dictionary such that data within the dictionary may be referenced.
6. A visual business platform according to any one of claims 2 to 4, wherein the business document generation module is further configured to generate a help page corresponding to the generated business document so that data within the business document can be referenced.
7. A visual business platform according to any one of claims 2 to 4, wherein the business document generation module is further configured to generate a red slip corresponding to the generated business document, and the red slip is used to replace the original business document when an error occurs in the entry of the business document.
8. a visual service platform according to claim 1, wherein the service data query means comprises:
the form data set creating unit is used for creating a form data set and enabling the data set to store a plurality of associated data objects, a plurality of fields corresponding to each data object and service data corresponding to each field;
the query report creating unit is used for creating a query report based on the data object and the field and enabling the query report to store the field serving as a query item;
The data binding unit is used for binding the business data corresponding to each field in the form data set and the cell of the row or column where the field is located aiming at each field in the query report;
The query statement generating unit is used for acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query statement corresponding to the query instruction based on a preset query language grammar rule;
And the data query unit is used for querying the business data corresponding to the field to be queried in the query report by using the query statement and outputting a query result.
9. a visual services platform as claimed in claim 8 wherein said data objects and said fields are selected from a services database in response to a selection instruction entered by a user.
10. A visual service platform according to claim 8 or 9, wherein the service data query device further comprises: and the data processing unit is used for processing the data of the query result according to the data processing instruction input by the user.
11. A visual business platform according to claim 10, wherein the data processing comprises one or more of sorting, grouping, co-searching and drilling.
12. A visual service platform according to claim 8 or 9, wherein the service data query device further comprises: and the authority setting unit is used for setting authority for the query report according to the authority instruction input by the user.
13. A visual services platform as claimed in claim 12 wherein said rights include access rights and operational rights.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910662392.0A CN110543303B (en) | 2019-07-22 | 2019-07-22 | Visual service platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910662392.0A CN110543303B (en) | 2019-07-22 | 2019-07-22 | Visual service platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110543303A true CN110543303A (en) | 2019-12-06 |
| CN110543303B CN110543303B (en) | 2023-05-30 |
Family
ID=68709705
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910662392.0A Active CN110543303B (en) | 2019-07-22 | 2019-07-22 | Visual service platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110543303B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111611270A (en) * | 2020-05-26 | 2020-09-01 | 深圳博沃智慧科技有限公司 | Form design and operation processing method and system |
| CN111784108A (en) * | 2020-05-29 | 2020-10-16 | 远光软件股份有限公司 | Modeling method and device for main data management platform |
| CN112947913A (en) * | 2021-02-26 | 2021-06-11 | 金蝶软件（中国）有限公司 | Service change method, device and computer storage medium |
| CN113609828A (en) * | 2021-07-13 | 2021-11-05 | 广州政企互联科技有限公司 | Form visual configuration method and system |
| CN114741079A (en) * | 2022-04-14 | 2022-07-12 | 上海携宁计算机科技股份有限公司 | Software development method, platform, electronic device and computer-readable storage medium |
| CN111767818B (en) * | 2020-06-23 | 2024-04-26 | 北京思特奇信息技术股份有限公司 | Method and device for intelligently accepting business |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101788996A (en) * | 2009-11-19 | 2010-07-28 | 山东浪潮齐鲁软件产业股份有限公司 | User-defined searching method |
| US20140129493A1 (en) * | 2012-10-11 | 2014-05-08 | Orboros, Inc. | Method and System for Visualizing Complex Data via a Multi-Agent Query Engine |
| CN105404509A (en) * | 2015-11-11 | 2016-03-16 | 神州数码国信信息技术（苏州）有限公司 | ExtJS UI based visual code generation method |
| CN109634590A (en) * | 2018-12-28 | 2019-04-16 | 北京神舟航天软件技术有限公司 | A kind of Object Query method based on business model |
-
2019
- 2019-07-22 CN CN201910662392.0A patent/CN110543303B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101788996A (en) * | 2009-11-19 | 2010-07-28 | 山东浪潮齐鲁软件产业股份有限公司 | User-defined searching method |
| US20140129493A1 (en) * | 2012-10-11 | 2014-05-08 | Orboros, Inc. | Method and System for Visualizing Complex Data via a Multi-Agent Query Engine |
| CN105404509A (en) * | 2015-11-11 | 2016-03-16 | 神州数码国信信息技术（苏州）有限公司 | ExtJS UI based visual code generation method |
| CN109634590A (en) * | 2018-12-28 | 2019-04-16 | 北京神舟航天软件技术有限公司 | A kind of Object Query method based on business model |
Non-Patent Citations (2)
| Title |
|---|
| THIBAULT LESCOAT ET AL.: "A Survey on Data-driven Dictionary-based Methods for 3D Modeling", 《COMPUTER GRAPHICS FORUM》 * |
| 李晨阳: "基于大数据处理技术的BI平台设计与开发", 《中国优秀硕士学位论文全文数据库经济与管理科学辑》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111611270A (en) * | 2020-05-26 | 2020-09-01 | 深圳博沃智慧科技有限公司 | Form design and operation processing method and system |
| CN111784108A (en) * | 2020-05-29 | 2020-10-16 | 远光软件股份有限公司 | Modeling method and device for main data management platform |
| CN111784108B (en) * | 2020-05-29 | 2024-01-02 | 远光软件股份有限公司 | Modeling method and device of main data management platform |
| CN111767818B (en) * | 2020-06-23 | 2024-04-26 | 北京思特奇信息技术股份有限公司 | Method and device for intelligently accepting business |
| CN112947913A (en) * | 2021-02-26 | 2021-06-11 | 金蝶软件（中国）有限公司 | Service change method, device and computer storage medium |
| CN113609828A (en) * | 2021-07-13 | 2021-11-05 | 广州政企互联科技有限公司 | Form visual configuration method and system |
| CN114741079A (en) * | 2022-04-14 | 2022-07-12 | 上海携宁计算机科技股份有限公司 | Software development method, platform, electronic device and computer-readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110543303B (en) | 2023-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110543303B (en) | Visual service platform | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| CN106020950B (en) | The identification of function call graph key node and identification method based on Complex Networks Analysis | |
| CN104133772B (en) | Automatic test data generation method | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN112650766B (en) | Database data operation method, system and server | |
| CN103530407B (en) | Method and device for generating rich text document | |
| CN110738037A (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| US8601367B1 (en) | Systems and methods for generating filing documents in a visual presentation context with XBRL barcode authentication | |
| CN101488086A (en) | Software generation method and apparatus based on field model | |
| WO2008107665A2 (en) | A graphical user interface for use in integrating programming functions with spreadsheet applications | |
| CN107783949A (en) | A kind for the treatment of method and apparatus of PPT documents | |
| CN106339363A (en) | PPT report making method and device | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN115358204A (en) | Report generation method and device, electronic equipment and storage medium | |
| JP5747698B2 (en) | Requirements management support device | |
| CN108694043A (en) | page decoration method and system | |
| CN108766513B (en) | Intelligent health medical data structured processing system | |
| CN116644728A (en) | Contract generation method and system based on clause digitization | |
| CN116450246A (en) | Event stream configurable method based on state machine | |
| CN110597491B (en) | Method for quickly constructing different service systems | |
| CN110597507A (en) | Business form modeling system and modeling method | |
| CN113177059A (en) | Method and device for generating matching platform SQL script |
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 |