CN115344688A - Business data display method and device, electronic equipment and computer readable medium - Google Patents
Business data display method and device, electronic equipment and computer readable medium Download PDFInfo
- Publication number
- CN115344688A CN115344688A CN202211269684.6A CN202211269684A CN115344688A CN 115344688 A CN115344688 A CN 115344688A CN 202211269684 A CN202211269684 A CN 202211269684A CN 115344688 A CN115344688 A CN 115344688A
- Authority
- CN
- China
- Prior art keywords
- data source
- control
- data
- query
- source information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 48
- 230000004044 response Effects 0.000 claims abstract description 43
- 238000001514 detection method Methods 0.000 claims abstract description 21
- 238000013515 script Methods 0.000 claims description 68
- 238000007405 data analysis Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 8
- 238000004891 communication Methods 0.000 description 6
- 230000009191 jumping Effects 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 239000002699 waste material Substances 0.000 description 4
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 239000003795 chemical substances by application Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/34—Browsing; Visualisation therefor
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the disclosure discloses a business data display method, a business data display device, electronic equipment and a computer readable medium. One embodiment of the method comprises: displaying an online document page in response to detecting a selection operation acting on a new document control displayed in a personal document page; determining a data source information set corresponding to the query operation according to the query operation acting on the loading data source module; displaying each data source information control corresponding to the data source information set in the loading data source module; in response to the detection of the selection operation of any data source information control acting on each data source information control, determining the data source information corresponding to any data source information control in the data source information set as target data source information; acquiring a service data set corresponding to target data source information; and displaying the business data set in the document editing module. The implementation mode can make the operation of loading the service data simpler and more convenient.
Description
Technical Field
The embodiment of the disclosure relates to the technical field of computers, in particular to a business data display method, a business data display device, electronic equipment and a computer readable medium.
Background
An online document refers to a document that can be edited or browsed in coordination with multiple people at the same time. At present, when loading service data through an online document system, the method generally adopted is as follows: and loading the service data file to be displayed in a local uploading mode or a cloud uploading mode.
However, the inventor finds that when the business data is loaded through the online document system in the above manner, the following technical problems often exist:
firstly, business data to be displayed is loaded in a local uploading mode or a cloud uploading mode, and all levels of directories of the local or the cloud are required to be browsed for inquiry, so that the operation is complex.
Secondly, the business data to be displayed is loaded in a local uploading mode or a cloud uploading mode, the whole file needs to be uploaded first, and partial data in the file cannot be acquired, so that network resources are wasted.
The above information disclosed in this background section is only for enhancement of understanding of the background of the inventive concept and, therefore, it may contain information that does not form the prior art that is already known to a person of ordinary skill in the art in this country.
Disclosure of Invention
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the detailed description. This summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
Some embodiments of the present disclosure propose a business data presentation method, apparatus, electronic device and computer readable medium to solve one or more of the technical problems mentioned in the background section above.
In a first aspect, some embodiments of the present disclosure provide a business data display method, where the method includes: responding to the detection of a selection operation of a newly-built document control displayed in a personal document interface page, and displaying an online document interface page, wherein an edited document module and a data loading source module are displayed in the online document interface page, the data loading source module comprises a public data source control, a personal data source control and a user-defined query control, and the personal document page is displayed in a data analysis interface; determining a data source information set corresponding to the query operation according to the query operation acting on the loading data source module; displaying each data source information control corresponding to the data source information set in the loading data source module; in response to the detection of the selection operation of any data source information control acting on each data source information control, determining the data source information of the data source information set corresponding to any data source information control as target data source information; acquiring a service data set corresponding to the target data source information; and displaying the service data set in the document editing module.
In a second aspect, some embodiments of the present disclosure provide a business data presentation apparatus, including: a first display unit configured to display an online document interface page in response to detecting a selection operation acting on a new document control displayed in a personal document interface page, wherein an edited document module and a loaded data source module are displayed in the online document interface page, the loaded data source module includes a public data source control, a personal data source control and a custom query control, and the personal document page is displayed in a data analysis interface; a first determining unit configured to determine a data source information set corresponding to a query operation according to the query operation acting on the loading data source module; a second display unit configured to display each data source information control corresponding to the data source information set in the loading data source module; a second determining unit, configured to determine, in response to detecting a selection operation acting on any data source information control of the data source information controls, data source information in the data source information set corresponding to the any data source information control as target data source information; an obtaining unit configured to obtain a service data set corresponding to the target data source information; and a third display unit configured to display the service data set in the edit document module.
In a third aspect, some embodiments of the present disclosure provide an electronic device, comprising: one or more processors; a storage device having one or more programs stored thereon, which when executed by one or more processors, cause the one or more processors to implement the method described in any of the implementations of the first aspect.
In a fourth aspect, some embodiments of the present disclosure provide a computer readable medium on which a computer program is stored, wherein the program, when executed by a processor, implements the method described in any of the implementations of the first aspect.
The above embodiments of the present disclosure have the following advantages: through the business data display method of some embodiments of the present disclosure, the operation of loading business data can be more convenient. Specifically, the reason why the operation of loading the service data is cumbersome is that: the business data to be displayed is loaded in a local uploading mode or a cloud uploading mode, and all levels of directories of the local or the cloud are required to be browsed for query, so that the operation is complicated. Based on this, the business data presentation method of some embodiments of the present disclosure first displays an online document page in response to detecting a selection operation acting on a new document control displayed in a personal document page. The online document page displays an editing document module and a loading data source module. The loading data source module comprises a public data source control, a personal data source control and a custom query control. The personal document page is displayed in a data analysis interface. Thus, an online document page can be displayed and thus can be used to present business data. And secondly, determining a data source information set corresponding to the query operation according to the query operation acted on the loading data source module. Therefore, the data source information set which needs to be inquired by the user can be obtained, and therefore the data source information set can be used for acquiring the needed service data. Then, displaying each data source information control corresponding to the data source information set in the loading data source module. Therefore, the data source information controls corresponding to the data source information sets can be displayed, and the data source information controls can be used for selecting the data source information required by the user. And then, in response to the detection of the selection operation acting on any data source information control in the data source information controls, determining the data source information corresponding to the any data source information control in the data source information set as the target data source information. Therefore, the data source information required by the user can be obtained, and the method can be used for acquiring the service data required by the user. And then, acquiring a service data set corresponding to the target data source information. Therefore, the business data required by the user can be obtained from the database corresponding to the target data source information, and the user does not need to browse all levels of directories of the local or cloud side for query. And finally, displaying the service data set in the document editing module. Therefore, each service data required by the user can be displayed, and the task of loading the service data can be completed. And service data required by the user can be obtained from the database corresponding to the data source information by searching the data source information, so that the user does not need to browse all levels of directories of the local or cloud side for query. Therefore, the operation of loading the service data can be simpler and more convenient.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and elements are not necessarily drawn to scale.
FIG. 1 is a flow diagram of some embodiments of a business data presentation method according to the present disclosure;
FIG. 2 is a schematic block diagram of some embodiments of a business data presentation apparatus according to the present disclosure;
FIG. 3 is a schematic block diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be noted that, for convenience of description, only the portions related to the related invention are shown in the drawings. The embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict.
It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence relationship of the functions performed by the devices, modules or units.
It is noted that references to "a", "an", and "the" modifications in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will recognize that "one or more" may be used unless the context clearly dictates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
Fig. 1 illustrates a flow 100 of some embodiments of a business data presentation method according to the present disclosure. The business data display method comprises the following steps:
In some embodiments, an executing body (e.g., a computing device) of the business data exposing method may display an online document interface in response to detecting a selection operation acting on a new document control displayed in a personal document page. The personal document page can be used for displaying a personal document. The personal document can be a document which is created by a target user and analyzes business data. The target user may be a user who logs in the data analysis system. The data analysis system may be a system for analyzing business data. The personal document page is displayed in a data analysis interface. The data analysis interface may be an interface for analyzing business data. The data analysis interface may display a data source page control and a personal document page control. The personal document page control may be a control for jumping to a personal document page. The data source page control may be a control for jumping to a data source page. The new document control can be a control for creating a new document. The selection operation may include, but is not limited to, at least one of: click, drag, hover, and slide. The online document interface can be an interface for displaying and creating an online document. The online document may be an online spreadsheet. The online document interface displays a document editing module and a data loading module. The document editing module may be a module for editing a document. The loading data source module can be a module for inquiring and displaying data sources. The loading data source module can comprise a public data source control, a personal data source control and a custom query control. The common data source control may be a control for selecting a query common data source. The common data source may be information of each data source corresponding to a group in which the target user is located. The group may be a predetermined group of users. The personal data source control can be a control for selecting a query personal data source. The personal data source may be information of each data source created for the target user. The data source information may characterize the data source. The user-defined query control can be a control for selecting user-defined query service data.
And 102, determining a data source information set corresponding to the query operation according to the query operation acting on the loading data source module.
In some embodiments, the execution subject may determine, according to a query operation applied to the load data source module, a data source information set corresponding to the query operation. The query operation may be an operation of querying a data source. The data source information included in the data source information set may be attribute information of the data source configured by a user who creates the data source. Each data source information included in the data source information set may correspond to a user identifier and a group identifier for creating the data source information. The user identifier may be a unique identifier of the user. For example, the user identifier may be a login account of the user. The group identifier may be a unique identifier of the group. In practice, first, the execution main body may obtain, from the execution main body, a user identifier of a target user in response to determining that the query operation is a selection operation acting on the personal data source control. Next, the execution body may determine each data source information corresponding to the user identifier as a data source information set corresponding to the query operation.
In some optional implementation manners of some embodiments, the execution main body may determine, according to a query operation performed on the data source loading module, a data source information set corresponding to the query operation, through the following steps:
and step one, responding to the selection operation of determining that the query operation is acted on the public data source control, and acquiring the user identification of the target user. In practice, the execution subject may obtain the user identifier of the target user from the execution subject.
And secondly, determining a preset user identifier group corresponding to the user identifier as a target user identifier group. The preset user identifier group may be a preset user identifier group. The preset user identifier group may correspond to a group identifier. The group identifier may be a unique identifier of a preset user identifier group.
And thirdly, determining the group identification corresponding to the target user identification group as the target group identification.
And fourthly, determining each data source information corresponding to the target group identification as a data source information set corresponding to the query operation.
And 103, displaying each data source information control corresponding to the data source information set in the loading data source module.
In some embodiments, the execution subject may display, in the loaded data source module, each data source information control corresponding to the data source information set. The data source information control included in each data source information control may be a control for selecting data source information. And each data source information control corresponds to one data source information.
And 104, in response to the detection of the selection operation of any data source information control acting on each data source information control, determining the data source information of any data source information control in the data source information set as the target data source information.
In some embodiments, the execution subject may determine, in response to detecting a selection operation applied to any data source information control of the data source information controls, data source information in the data source information set corresponding to the any data source information control as target data source information.
And 105, acquiring a service data set corresponding to the target data source information.
In some embodiments, the executing entity may obtain a service data set corresponding to the target data source information. The service data included in the service data set may be service related data. The service may be any service. In practice, the executing agent may obtain a service data set corresponding to the target data source information from a database corresponding to the target data source information.
And 106, displaying the service data set in the editing document module.
In some embodiments, the execution body may display the business data set in the edit document module. In practice, the execution subject may display the business data set in a page in a display state in the edit document module. The pages may be pages in an electronic form displayed in the edit document module.
In some optional implementations of some embodiments, the executing body may display the service data set in the edit document module by:
in the first step, the number of each service data included in the service data set is determined as the service number.
And secondly, in response to the fact that the service quantity meets a preset quantity condition, determining each service data meeting a preset arrangement condition in the service data set as target service data to obtain a target service data set. The preset quantity condition may be that the service quantity is greater than a preset threshold. The preset threshold may be a preset threshold. For example, the preset threshold may be 5000. The preset arrangement condition may be that the ranking of the positions of the service data in the service data set is within a preset range. The preset range may be a preset range. For example, the predetermined range may be [0,5000].
And thirdly, displaying the target business data set in a page corresponding to a target page control included in the document editing module. The target paging control may be a control for selecting a target paging. The target page may be a page that is not displayed in an expanded state.
And fourthly, determining the rest service data set as the service data set according to the service data set and the target service data set. The remaining service data in the remaining service data set may be service data different from each target service data included in the target service data set. In practice, the executing body may determine each service data in the service data set different from each target service data as a remaining service data set as a service data set.
Optionally, the executing body may further display the service data set in a page corresponding to the target page control in response to determining that the service number does not satisfy the preset number condition.
Optionally, the executing body may further execute the following steps:
the method comprises the first step of responding to the detection of the selection operation of a newly added data source control which is displayed in a data source page, and displaying the newly added data source page. The data source page can be a page for editing, creating, and deleting a data source. The data source page may be displayed in the data analysis interface. And editing data source controls can be displayed in the data source pages. The edit data source control may be a control for jumping to an edit data source page. The edit data source page may be a page for editing attribute information of the data source. The newly added data source control may be a control for jumping to a newly added data source page. The newly added data source page may be a page for configuring attribute information of the data source. And the newly added data source page displays a data source storage control and each text box for configuring each attribute of the data source. The data source saving control may be a control for saving attribute information of the data source. Each text box included in the text boxes corresponds to one attribute. For example, the text boxes described above may include, but are not limited to: a text box corresponding to a group identification attribute which can be applied by the data source, a text box corresponding to a name attribute of the data source, a text box corresponding to a type attribute of the data source, a text box corresponding to an account name attribute, and a text box corresponding to a password attribute of the account. The data source type may be a type of a corresponding database. For example, the data source type may be MySQL. The account name may be an account name of a database corresponding to the data source type. The account password may be an account password of a database corresponding to the data source type. The text boxes in the text boxes can be used for receiving input operation of a user. The input operation may be an operation of inputting a text or selecting a text content of a corresponding text box. The above-mentioned respective text boxes include an input text box and a selection text box. Each click text box corresponds to a set of text content to be selected. For example, the click text box may be a text box corresponding to a data source type attribute. The text content set of the text box corresponding to the data source type attribute may include preset respective database types. The user may click on a database type from each database type to configure the data source type attributes of the data source.
And secondly, responding to the detection of the selection operation acted on the data source storage control, generating data source configuration information according to the input information corresponding to the text boxes, and storing the data source configuration information into a database corresponding to a data source configuration information set. The data source configuration information may represent each attribute of the data source. The data source configuration information may include a data source type, an account name, and an account password. In practice, first, the execution main body may combine the input information corresponding to the text boxes to obtain the data source configuration information in response to detecting the selection operation acting on the data source saving control. And then, storing the data source configuration information into a database corresponding to the data source configuration information set.
And thirdly, responding to the detected selection operation acted on the editing data source control, and displaying an editing data source page. And displaying a data source running control in the edit data source page. The data source running control can be a control used for connecting a database.
And fourthly, responding to the detected selection operation acting on the data source operation control, and connecting the database corresponding to the data source type according to the data source configuration information. In practice, first, the execution subject may determine a database corresponding to a data source type included in the data source configuration information, an account name of the database, and an account password. And then connecting the databases corresponding to the data source types.
Optionally, the executing body may further execute the following steps:
the method comprises the following steps that in response to the detection of the selection operation of a copy control corresponding to at least one service data in the service data set, the at least one service data is determined as a service data set to be encrypted. The copy control may be a control for copying the service data.
And secondly, encrypting the service data set to be encrypted to obtain an encrypted service data set. In practice, the execution main body may encrypt the service data set to be encrypted by using an ACE encryption method, so as to obtain an encrypted service data set.
And thirdly, storing the encrypted service data set to a copied service data set cache for pasting by a user. The copied service data set cache may be a cache for caching copied service data.
Optionally, the executing body may further execute the following steps:
and a first step of displaying a custom query module in the loading data source module in response to detecting a selection operation acting on the custom query control. The user-defined query module can be a module for querying and newly building an SQL statement. The user-defined query module displays a query script text box. The query script text box may be a text box for receiving an operation of inputting a script name by a user. The script name may be a name of a script. The script may be a script corresponding to each SQL statement.
And secondly, in response to the detection of the script name input operation acting on the query script text box, displaying a script name control corresponding to the script name input operation in the custom query module. The script name input operation may be an operation of inputting a script name. The script name control may be a control for displaying each SQL statement corresponding to the script name.
And thirdly, responding to the detected selection operation acted on the script name control, and displaying an editing query window. The edit query window may be a window for editing and displaying an SQL statement to query the service data. The edit query window can display a query sentence text box, an execution control and a control loaded into a document. The query statement text box can display each SQL statement corresponding to the script name in an initial state. The query statement text box can also be used for a user to modify the SQL statement. The execution control may be a control for running each SQL statement displayed in the query statement text box. The control loaded into the document may be a control for displaying the business data queried by running the SQL statement in the document editing module.
And fourthly, in response to the detection of the selection operation acting on the execution control, operating the query sentence text to display a query service data set corresponding to the query sentence text in the editing query window. The query service data in the query service data set may be service data that a user needs to query.
And fifthly, responding to the detected selection operation of the control loaded into the document, and displaying the query service data set in the document editing module.
Optionally, a new query control may be displayed in the custom query module. The newly-built query control can be a control for newly building an SQL statement to query the service data. The executing body may further execute the following steps:
and step one, responding to the detected selection operation acting on the new query control, and displaying a new query window. The newly-built query window can be a window for newly building an SQL statement and querying business data. The new query window may display, but is not limited to, at least one of the following: the method comprises the steps of querying a data source input text box, querying a statement editing text box, executing a control and loading the control into a document. The query data source input text box may be used to receive a data source permission type for querying service data, which is input by a user. The query data source input text box may click on the text box for the data source. The data source click text box corresponds to each data source authority type to be selected. The data source permission type can represent that the open permission of the data source is a personal permission or a public permission. The data source permission type may be, but is not limited to, one of the following: personal data sources, public data sources. A personal data source may characterize that the open rights of the data source belong only to the user who created the data source. The open permissions that a common data source may characterize the data source may be for each user in the group corresponding to the data source group attribute. The query statement edit text box may be a text box for receiving a user-entered SQL statement.
And secondly, responding to the detected text input operation acting on the query data source input text box, and displaying the query data source authority type corresponding to the text input operation in the newly-built query window. The text input operation may be selecting a data source permission type. The query data source permission type may be a data source permission type corresponding to data source information of service data to be queried.
And thirdly, in response to detecting the sentence input operation acting on the query sentence editing text box, displaying a query sentence text corresponding to the sentence input operation in the newly-built query window. The statement input operation may be an operation of inputting a text of an SQL statement. The query statement text may be a text of an SQL statement for querying the business data.
And fourthly, in response to the detection of the selection operation acting on the execution control, operating the query sentence text to display a query service data set corresponding to the query sentence text in the editing query window.
And fifthly, responding to the detected selection operation of the control loaded into the document, and displaying the query service data set in the document editing module.
The technical scheme and the related content serve as an invention point of the embodiment of the disclosure, and the technical problem that the network resource waste is caused by the fact that the whole file needs to be uploaded first and partial data in the file cannot be acquired by loading the service data to be displayed in a local uploading or cloud uploading mode in the background technology is solved. The factors that lead to the waste of network resources are often as follows: the business data to be displayed is loaded in a local uploading mode or a cloud uploading mode, the whole file needs to be uploaded first, partial data in the file cannot be acquired, and network resources are wasted. If the above factors are solved, the effect of reducing the waste of network resources can be achieved. To achieve this effect, in the service data presentation method according to some embodiments of the present disclosure, first, a new query window is displayed in response to detection of a selection operation acting on the new query control. And the newly-built query window displays a query data source input text box, a query statement editing text box, an execution control and a control loaded into a document. Therefore, the method can jump to a window for newly building and running the SQL statement, so that a user can edit and run the SQL statement. Secondly, in response to the detection of the text input operation acting on the query data source input text box, displaying the query data source authority type corresponding to the text input operation in the newly-built query window. Therefore, the data source information corresponding to the business data which needs to be searched by the user can be determined, and the range of searching the business data can be reduced. Then, in response to detecting a sentence input operation applied to the query sentence edit text box, a query sentence text corresponding to the sentence input operation is displayed in the newly created query window. Therefore, the user can edit the SQL sentence, so that the SQL sentence can be used for inquiring the business data. And then, responding to the detected selection operation acting on the execution control, running the query statement text, and displaying a query business data set corresponding to the query statement text in the editing query window. Therefore, the user can obtain partial business data from each file by editing the SQL sentence and inquire the needed business data, so that each complete file is not required to be uploaded. And finally, in response to detecting the selection operation of the control loaded into the document, displaying the query service data set in the document editing module. Therefore, each service data required by the user can be displayed in the document editing module, so that the user can consult and edit the service data. And when partial business data are required to be acquired from each file, the business data can be acquired by editing SQL statements, so that each complete file is not required to be uploaded. Therefore, the waste of network resources can be reduced.
Optionally, the newly created query window may further display a script saving control. The script saving control can be a control for jumping to a saving script window. The script saving window may be a window for saving a script. The executing body may further execute the following steps:
and in the first step, responding to the detected selection operation acting on the script saving control, and displaying a saving script window. And the script storage script window displays a script name text box, a script storage directory text box and a script information storage control. The script name text box can be used for receiving the operation of inputting the script name by the user. The script storing directory text box may be a script clicking text box. The script click text box corresponds to each script storage directory to be selected. The script storage directory may be a directory for storing scripts. The script storage directory text box can be used for receiving the operation of inputting the storage directory of the script by the user. The script information saving control can be a control for saving script information.
And secondly, generating script information according to the script name input information corresponding to the script name textbox and the script storage input information corresponding to the script storage directory textbox. The script name input information may be an input script name. The script name may uniquely identify the script. The script storage input information may be a storage directory of the input script. In practice, the execution body may combine the script name input information corresponding to the script name text box and the script storage input information corresponding to the script storage directory text box to obtain script information.
And thirdly, in response to the detection of the selection operation acting on the script information storage control, storing the script information into a script information cache. The script information cache may be a cache for caching script information.
The above embodiments of the present disclosure have the following advantages: through the business data display method of some embodiments of the present disclosure, the operation of loading business data can be more convenient. Specifically, the reason for the cumbersome operation of loading the service data is as follows: the business data to be displayed is loaded by adopting a local uploading mode or a cloud uploading mode, and all levels of directories of the local or the cloud are required to be browsed for query, so that the operation is complicated. Based on this, the business data presentation method of some embodiments of the present disclosure first displays an online document page in response to detecting a selection operation acting on a new document control displayed in a personal document page. The online document page displays an editing document module and a loading data source module. The loading data source module comprises a public data source control, a personal data source control and a custom query control. The personal document page is displayed in a data analysis interface. Thus, an online document page can be displayed and thus can be used to present business data. And secondly, determining a data source information set corresponding to the query operation according to the query operation acted on the loading data source module. Therefore, the data source information set which needs to be inquired by the user can be obtained, and therefore the data source information set can be used for acquiring the needed service data. Then, displaying each data source information control corresponding to the data source information set in the data source loading module. Therefore, each data source information control corresponding to the data source information set can be obtained, and the data source information control can be used for selecting the data source information required by the user. And then, in response to the detection of the selection operation acting on any data source information control in the data source information controls, determining the data source information corresponding to the any data source information control in the data source information set as the target data source information. Therefore, the data source information required by the user can be obtained, and the method can be used for acquiring the service data required by the user. And then, acquiring a service data set corresponding to the target data source information. Therefore, the business data required by the user can be obtained from the database corresponding to the target data source information, and the user does not need to browse all levels of directories of the local or cloud side for query. And finally, displaying the service data set in the document editing module. Therefore, each service data required by the user can be displayed, and the task of loading the service data can be completed. When the business data required by the user is obtained, the data source information is searched and obtained from the database corresponding to the data source information, so that the user does not need to browse all levels of directories of the local or cloud side for query. Therefore, the operation of loading the service data can be simpler and more convenient.
With further reference to fig. 2, as an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of a business data presentation apparatus, which correspond to those shown in fig. 1, and which can be applied in various electronic devices.
As shown in fig. 2, the business data presentation apparatus 200 of some embodiments includes: a first display unit 201, a first determination unit 202, a second display unit 203, a second determination unit 204, an acquisition unit 205, and a third display unit 206. The first display unit 201 is configured to respond to the detection of the selection operation of a new document control displayed in a personal document page, and display an online document page, wherein an edited document module and a loaded data source module are displayed in the online document page, the loaded data source module comprises a public data source control, a personal data source control and a custom query control, and the personal document page is displayed in a data analysis interface; the first determining unit 202 is configured to determine, according to a query operation applied to the loaded data source module, a data source information set corresponding to the query operation; the second display unit 203 is configured to display each data source information control corresponding to the data source information set in the loaded data source module; the second determining unit 204 is configured to determine, in response to detecting a selection operation acting on any data source information control in the data source information controls, data source information in the data source information set corresponding to the any data source information control as target data source information; the obtaining unit 205 is configured to obtain a service data set corresponding to the target data source information; the third display unit 206 is configured to display the service data set in the edit document module.
It is understood that the units described in the service data presentation apparatus 200 correspond to the respective steps in the method described with reference to fig. 1. Thus, the operations, features and resulting advantages described above with respect to the method are also applicable to the apparatus 200 and the units included therein, and are not described herein again.
Referring now to fig. 3, a block diagram of an electronic device 300 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device in some embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle-mounted terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 3 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 3, the electronic device 300 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 301 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM) 302 or a program loaded from a storage means 308 into a Random Access Memory (RAM) 303. In the RAM 303, various programs and data necessary for the operation of the electronic apparatus 300 are also stored. The processing device 301, the ROM 302, and the RAM 303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.
Generally, the following devices may be connected to the I/O interface 305: input devices 306 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 307 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage devices 308 including, for example, magnetic tape, hard disk, etc.; and a communication device 309. The communication means 309 may allow the electronic device 300 to communicate wirelessly or by wire with other devices to exchange data. While fig. 3 illustrates an electronic device 300 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may be alternatively implemented or provided. Each block shown in fig. 3 may represent one device or may represent multiple devices, as desired.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In some such embodiments, the computer program may be downloaded and installed from a network through the communication device 309, or installed from the storage device 308, or installed from the ROM 302. The computer program, when executed by the processing apparatus 301, performs the above-described functions defined in the methods of some embodiments of the present disclosure.
It should be noted that the computer readable medium described in some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (Hyper Text Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may be separate and not incorporated into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: responding to the detection of selection operation of a new document control displayed in a personal document page, and displaying an online document page, wherein an edited document module and a data source loading module are displayed in the online document page, the data source loading module comprises a public data source control, a personal data source control and a user-defined query control, and the personal document page is displayed in a data analysis interface; determining a data source information set corresponding to the query operation according to the query operation acting on the loading data source module; displaying each data source information control corresponding to the data source information set in the loading data source module; in response to the detection of the selection operation of any data source information control acting on each data source information control, determining the data source information of the data source information set corresponding to any data source information control as target data source information; acquiring a service data set corresponding to the target data source information; and displaying the service data set in the document editing module.
Computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by software or hardware. The described units may also be provided in a processor, and may be described as: a processor includes a first display unit, a first determination unit, a second display unit, a second determination unit, an acquisition unit, and a third display unit. Where the names of these elements do not in some cases constitute a limitation on the elements themselves, for example, the first display element may also be described as an element "displaying an online document page in response to detecting a selection operation acting on a new document control displayed in a personal document page, where the online document page displays an edited document module and a loaded data source module, where the loaded data source module includes a common data source control, a personal data source control, and a custom query control, and where the personal document page is displayed in a data analysis interface.
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems on a chip (SOCs), complex Programmable Logic Devices (CPLDs), and the like.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combinations of the above-mentioned features, and other embodiments in which the above-mentioned features or their equivalents are combined arbitrarily without departing from the spirit of the invention are also encompassed. For example, the above features and (but not limited to) technical features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.
Claims (10)
1. A business data display method comprises the following steps:
responding to the detection of selection operation of a newly-built document control displayed in a personal document page, and displaying an online document page, wherein an edited document module and a data loading source module are displayed in the online document page, the data loading source module comprises a public data source control, a personal data source control and a custom query control, and the personal document page is displayed in a data analysis interface;
determining a data source information set corresponding to the query operation according to the query operation acting on the loading data source module;
displaying each data source information control corresponding to the data source information set in the loading data source module;
in response to the detection of the selection operation of any data source information control acting on each data source information control, determining the data source information of the data source information set corresponding to any data source information control as target data source information;
acquiring a service data set corresponding to the target data source information;
and displaying the service data set in the document editing module.
2. The method of claim 1, wherein the method further comprises:
responding to the detected selection operation of a newly added data source control acting on the data source page, and displaying the newly added data source page, wherein a data source storage control and text boxes for configuring each attribute of a data source are displayed in the newly added data source page, and an edited data source control is also displayed in the data source page;
responding to the detected selection operation acting on the data source storage control, generating data source configuration information according to the input information corresponding to each text box, and storing the data source configuration information into a database corresponding to a data source configuration information set, wherein the data source configuration information comprises a data source type;
displaying an edited data source page in response to detecting a selection operation acting on the edited data source control, wherein a data source operation control is displayed in the edited data source page;
and responding to the detected selection operation acting on the data source running control, and connecting a database corresponding to the type of the data source according to the data source configuration information.
3. The method of claim 1, wherein the determining, according to the query operation applied to the load data source module, a data source information set corresponding to the query operation comprises:
in response to determining that the query operation is a selection operation for the public data source control, obtaining a user identification of a target user;
determining a preset user identifier group corresponding to the user identifier as a target user identifier group;
determining a group identifier corresponding to the target user identifier group as a target group identifier;
and determining each data source information corresponding to the target group identifier as a data source information set corresponding to the query operation.
4. The method of claim 1, wherein said displaying the business data set in the edit document module comprises:
determining the quantity of each service data included in the service data set as the service quantity;
in response to the fact that the service quantity meets a preset quantity condition, determining each service data meeting a preset arrangement condition in the service data set as target service data to obtain a target service data set;
displaying the target business data set in a page corresponding to a target page control included in the document editing module;
and determining the rest service data set as the service data set according to the service data set and the target service data set.
5. The method of claim 4, wherein the method further comprises:
and in response to determining that the business number does not meet the preset number condition, displaying the business data set in a page corresponding to the target page control.
6. The method of claim 1, wherein the method further comprises:
in response to the detection of the selection operation of a copy control corresponding to at least one service data in the service data set, determining the at least one service data as a service data set to be encrypted;
encrypting the service data set to be encrypted to obtain an encrypted service data set;
and storing the encrypted service data set to a copied service data set cache for pasting by a user.
7. The method of claim 1, wherein the method further comprises:
in response to detecting a selection operation acting on the custom query control, displaying a custom query module in the loading data source module, wherein a query script text box is displayed in the custom query module;
in response to detecting a script name input operation acting on the query script text box, displaying a script name control corresponding to the script name input operation in the custom query module;
responding to the detected selection operation acting on the script name control, and displaying an editing query window, wherein a query statement text box, an execution control and a control loaded into a document are displayed in the editing query window, and a query statement text is displayed in the query statement text box;
in response to detecting a selection operation acting on the execution control, running the query statement text to display a query business data set corresponding to the query statement text in the editing query window;
and in response to detecting the selection operation of the control loaded into the document, displaying the query business data set in the document editing module.
8. A business data presentation apparatus, comprising:
a first display unit configured to display an online document page in response to detecting a selection operation acting on a new document control displayed in a personal document page, wherein an edited document module and a loaded data source module are displayed in the online document page, the loaded data source module comprises a public data source control, a personal data source control and a custom query control, and the personal document page is displayed in a data analysis interface;
a first determining unit configured to determine, according to a query operation acting on the load data source module, a data source information set corresponding to the query operation;
a second display unit configured to display respective data source information controls corresponding to the data source information sets in the loading data source module;
a second determining unit, configured to determine, in response to detecting a selection operation acting on any data source information control of the data source information controls, data source information in the data source information set corresponding to the any data source information control as target data source information;
an obtaining unit configured to obtain a service data set corresponding to the target data source information;
a third display unit configured to display the business data set in the edit document module.
9. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-7.
10. A computer-readable medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211269684.6A CN115344688B (en) | 2022-10-18 | 2022-10-18 | Business data display method and device, electronic equipment and computer readable medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211269684.6A CN115344688B (en) | 2022-10-18 | 2022-10-18 | Business data display method and device, electronic equipment and computer readable medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115344688A true CN115344688A (en) | 2022-11-15 |
| CN115344688B CN115344688B (en) | 2022-12-23 |
Family
ID=83956957
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211269684.6A Active CN115344688B (en) | 2022-10-18 | 2022-10-18 | Business data display method and device, electronic equipment and computer readable medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115344688B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483905A (en) * | 2023-04-21 | 2023-07-25 | 浪潮智慧科技有限公司 | Method, equipment and medium for dynamically adding multiple data sources |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20200133662A1 (en) * | 2018-10-25 | 2020-04-30 | Manhattan Engineering Incorporated | Automatic generation of documentation and aggregation of community content |
| CN112328925A (en) * | 2020-10-28 | 2021-02-05 | 北京鸿腾智能科技有限公司 | Page data loading method, device, equipment and storage medium |
| CN112528203A (en) * | 2020-12-18 | 2021-03-19 | 平安国际智慧城市科技股份有限公司 | Webpage-based online document making method and system |
| CN113779953A (en) * | 2021-11-10 | 2021-12-10 | 航天宏图信息技术股份有限公司 | Automatic document generation method and system |
| CN114818619A (en) * | 2022-06-27 | 2022-07-29 | 佳瑛科技有限公司 | Online document editing processing method and device based on cloud server |
-
2022
- 2022-10-18 CN CN202211269684.6A patent/CN115344688B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20200133662A1 (en) * | 2018-10-25 | 2020-04-30 | Manhattan Engineering Incorporated | Automatic generation of documentation and aggregation of community content |
| CN112328925A (en) * | 2020-10-28 | 2021-02-05 | 北京鸿腾智能科技有限公司 | Page data loading method, device, equipment and storage medium |
| CN112528203A (en) * | 2020-12-18 | 2021-03-19 | 平安国际智慧城市科技股份有限公司 | Webpage-based online document making method and system |
| CN113779953A (en) * | 2021-11-10 | 2021-12-10 | 航天宏图信息技术股份有限公司 | Automatic document generation method and system |
| CN114818619A (en) * | 2022-06-27 | 2022-07-29 | 佳瑛科技有限公司 | Online document editing processing method and device based on cloud server |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483905A (en) * | 2023-04-21 | 2023-07-25 | 浪潮智慧科技有限公司 | Method, equipment and medium for dynamically adding multiple data sources |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115344688B (en) | 2022-12-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022073418A1 (en) | Permission control method and apparatus, and electronic device | |
| CN112528595B (en) | Document processing method and device and electronic equipment | |
| WO2022111591A1 (en) | Page generation method and apparatus, storage medium, and electronic device | |
| CN111400625B (en) | Page processing method and device, electronic equipment and computer readable storage medium | |
| CN110704833A (en) | Data permission configuration method, device, electronic device and storage medium | |
| WO2022111290A1 (en) | Display method and apparatus, and electronic device | |
| CN111857720B (en) | User interface state information generation method and device, electronic equipment and medium | |
| US20240095389A1 (en) | Information processing method and apparatus, terminal, and storage medium | |
| CN115344688B (en) | Business data display method and device, electronic equipment and computer readable medium | |
| CN110852720A (en) | Document processing method, device, equipment and storage medium | |
| US9996622B2 (en) | Browser new tab page generation for enterprise environments | |
| CN113918659A (en) | Data operation method and device, storage medium and electronic equipment | |
| WO2023131263A1 (en) | Group member adding method and apparatus, device, and medium | |
| CN111756953A (en) | Video processing method, device, equipment and computer readable medium | |
| CN115374760A (en) | Document editing method, device, equipment, computer readable medium and program product | |
| CN115017110A (en) | Information processing method, device, terminal and storage medium | |
| CN114090124A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN115422131B (en) | Business audit knowledge base retrieval method, device, equipment and computer readable medium | |
| CN112131181A (en) | Storage path display method and device and electronic equipment | |
| CN110941683A (en) | Method, device, medium and electronic equipment for acquiring object attribute information in space | |
| CN111787043A (en) | Data request method and device | |
| US11693720B1 (en) | Deploying schematically enriched document content as representational state transfer application programming interfaces | |
| CN116360710B (en) | Data storage method applied to server cluster, electronic device and readable medium | |
| CN111953741A (en) | Information pushing method and device and electronic equipment | |
| CN115729723A (en) | Copying method and 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 | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20231130 Address after: Building 4, Dongxu International Center, yard 2, sihezhuang Road, Fengtai District, Beijing 100070 (South Building of block a) Patentee after: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Patentee after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Patentee after: State Grid Siji Location Service Co.,Ltd. Address before: 100085 32-3-4108-4109, building 32, Chuangye Middle Road, Haidian District, Beijing Patentee before: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Patentee before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. |