Mail-based real-time data display method and device, computer device and medium

Abstract

The application is suitable for the technical field of data display, and particularly relates to a real-time data display method and device based on an email, a computer device and a medium. The method uses an email system to collect target online data of a target business at a current time, determines a construction template, combines the target online data with the construction template, obtains corresponding structure data, extracts the content of the back end of a split placeholder in a template placeholder as the row position of a table during rendering for any structure data, extracts each element split by an element placeholder in the content of the front end of the split placeholder, determines the first element as a data value and other elements as the column position of the table during rendering according to the front-back order of the elements, uses the data value, the row position and the column position to combine a rendering template for rendering, obtains a rendering result and displays the rendering result, realizes timely display of real-time data of email sending and receiving, does not need to build an XML template, and can effectively reduce the delay during data mapping and identification by using the XML template.

Description

Technical Field

[0001] This application relates to the field of data display technology, and in particular to a method, apparatus, computer equipment and medium for real-time data display based on email. Background Technology

[0002] Currently, with the rapid development of the company's business and the increasing number of areas involved, various types of data are generated in each business scenario. It is crucial for managers and operations teams to view online data promptly, identify problems and shortcomings in real time, and implement timely prevention and improvement. To achieve this functionality, existing technologies typically use dashboards on web platforms or emails for viewing. However, for better compatibility, these often use older web kernels and disable JavaScript to prevent user interaction via email. This results in static or simplistic data displays, making it impossible to present data from many complex business scenarios in a timely and objective manner. To address these issues, UI rendering is used for data display. Current technologies require XML templates during UI iteration, but XML template construction is inefficient and suffers from significant latency in the UI engine's mapping and recognition of templates and data, impacting timeliness. Therefore, developing appropriate template components for data UI display to improve performance is a pressing issue. Summary of the Invention

[0003] In view of this, embodiments of this application provide a method, apparatus, computer device, and medium for real-time data display based on email, in order to solve the problem of how to construct appropriate template components for the UI display of data in order to improve the corresponding performance.

[0004] In a first aspect, embodiments of this application provide a real-time data display method based on email, the real-time data display method comprising:

[0005] The target online data at the current moment is collected using the email system. The target online data is business data for the target business transmitted via email based on the email address of the email system.

[0006] A construction template corresponding to the target business is determined, and each group of data in the target online data is combined with the construction template to obtain the corresponding structured data. The construction template includes template placeholders, segment placeholders and element placeholders. The template placeholder is a template identifier, the segment placeholder is a content segment identifier, and the element placeholder is an element segment identifier.

[0007] For any structured data, extract the content after the dividing placeholder in the template placeholder as the row position of the table during rendering, extract each element divided by the element placeholder in the content before the dividing placeholder, determine the first element as the data value according to the order of the elements, and the other elements as the column position of the table during rendering.

[0008] Using the data values, row positions, and column positions, and combining them with the rendering template, the rendering results are obtained and displayed.

[0009] In one embodiment, the row position represents the row content of the first column of the row in which the cell is located, and the column position represents the column content of the first row of the column in which the cell is located. Before rendering and displaying the rendering result using the data value, the row position, and the column position in conjunction with the rendering template, the method further includes:

[0010] The row content corresponding to the row position of all structured data is deduplicated to obtain row content without repetition;

[0011] The column content corresponding to the column position of all structured data is deduplicated to obtain column content without repetition;

[0012] Starting from the second cell in the first row of the blank table, write the column content without repetition into each subsequent cell. Starting from the second cell in each row of the first column of the blank table, write the row content without repetition into each subsequent cell to obtain the initial table.

[0013] The initial table is rendered using preset rendering rules to obtain a rendering template.

[0014] In one embodiment, the data value, the row position, and the column position are used in conjunction with a rendering template to perform rendering, and the resulting rendering is displayed, including:

[0015] Based on the row position and the column position, find the corresponding target cell in the rendering template;

[0016] Render the data value into the target cell;

[0017] Traverse all structural data to obtain the rendered template, and then display the rendered template.

[0018] In one embodiment, the dividing placeholder includes a first dividing placeholder and a second dividing placeholder. The content following the dividing placeholder within the template placeholder is extracted as the row position of the table during rendering. Each element separated by the element placeholder in the content preceding the dividing placeholder includes:

[0019] Extract each element from the content preceding the first segmentation placeholder, which is segmented by the element placeholder;

[0020] Extract the content of the back end of the first dividing placeholder and the front end of the second dividing placeholder within the template placeholder to determine the row position of the table during rendering;

[0021] Extract the content at the back of the second dividing placeholder into the cell format for rendering;

[0022] Using the data values, row positions, and column positions, and combining them with the rendering template, a rendering result is obtained and displayed, including:

[0023] Using the data values, row positions, column positions, and cell formats, and combining them with the rendering template, a rendering result is obtained and displayed.

[0024] In one embodiment, each set of data in the target line data is combined with the construction template to obtain the corresponding structure data, including:

[0025] Obtain the data value, data source organization, and data category of each group of data in the target online data;

[0026] Place the data source organization at the back end of the segment placeholder in the construction template, place the data value and the data category at the front end of the segment placeholder, and place the data value at the front end of the element placeholder in the construction template, and place the data category at the back end of the element placeholder.

[0027] In one embodiment, determining the construction template corresponding to the target service includes:

[0028] Extract the business identifier representing the target service from the target online data;

[0029] The construction template corresponding to the business identifier is matched from the construction template library, which stores the mapping relationship between the business identifier and the construction template.

[0030] In one implementation, if the content at the beginning of the placeholder contains N elements, where N is an integer greater than 2, then determining the first element as the data value based on the order of the elements, and the other elements as the column positions of the table during rendering, includes:

[0031] The first element is determined as the data value based on the order of the elements.

[0032] The second element is determined to be the position of the first-level column in the table during rendering. The third element is determined to be the position of the second-level column within the first-level column during rendering. The i-th element is determined to be the position of the i-1-level column within the i-2-level column during rendering. i represents the order of the elements.

[0033] Secondly, embodiments of this application provide a real-time data display device based on email, the real-time data display device comprising:

[0034] The data acquisition module is used to collect target online data at the current moment using the email system. The target online data is business data for the target business transmitted via email based on the email address of the email system.

[0035] The data construction module is used to determine the construction template corresponding to the target business, and to combine each group of data in the target online data with the construction template to obtain the corresponding structured data. The construction template includes template placeholders, segment placeholders and element placeholders. The template placeholder is a template identifier, the segment placeholder is a content segment identifier and the element placeholder is an element segment identifier.

[0036] The information extraction module is used to extract, for any structured data, the content after the dividing placeholder in the template placeholder as the row position of the table during rendering, and extract each element divided by the element placeholder in the content before the dividing placeholder, and determine the first element as the data value according to the order of the elements, and the other elements as the column position of the table during rendering.

[0037] The rendering and display module is used to render the data value, the row position, and the column position in combination with the rendering template to obtain the rendering result and display it.

[0038] In one embodiment, the row position represents the row content of the first column of the row in which the cell is located, and the column position represents the column content of the first row of the column in which the cell is located. The real-time data display device further includes:

[0039] The first deduplication module is used to use the data value, the row position and the column position, combined with the rendering template to render, obtain the rendering result and display it, and then perform deduplication processing on the row content corresponding to the row position of all structural data to obtain row content without repetition.

[0040] The second deduplication module is used to deduplicate the column content corresponding to the column position of all structured data to obtain column content without repetition.

[0041] The initial table construction module is used to write the non-repeating column content into each cell of the first row of the blank table, starting from the second cell and continuing to each cell thereafter, and to write the non-repeating row content into each cell of the first row of the first column of the blank table, starting from the second cell and continuing to each cell thereafter, to obtain the initial table;

[0042] The template rendering module is used to render the initial table using preset rendering rules to obtain a rendering template.

[0043] In one embodiment, the rendering and display module includes:

[0044] A position determination unit is used to find the corresponding target cell in the rendering template based on the row position and the column position;

[0045] A data rendering unit is used to render the data value into the target cell;

[0046] The rendering and display unit is used to traverse all structural data, obtain the rendered template, and display the rendered template.

[0047] In one embodiment, the segmentation placeholders include a first segmentation placeholder and a second segmentation placeholder, and the information extraction module includes:

[0048] An element extraction unit is used to extract each element from the content at the front of the first dividing placeholder, which is divided by the element placeholder.

[0049] The row position extraction unit is used to extract the content of the back end of the first dividing placeholder and the front end of the second dividing placeholder within the template placeholder as the row position of the table where it is located during rendering;

[0050] The format extraction unit is used to extract the content behind the second dividing placeholder as the cell format during rendering.

[0051] The rendering and display module specifically includes:

[0052] Using the data values, row positions, column positions, and cell formats, and combining them with the rendering template, a rendering result is obtained and displayed.

[0053] In one embodiment, the data construction module includes:

[0054] The data content acquisition unit is used to acquire the data value, data source organization, and data category of each group of data in the target online data;

[0055] A data construction unit is used to place the data source organization at the back end of the segment placeholder in the construction template, place the data value and the data category at the front end of the segment placeholder, and place the data value at the front end of the element placeholder in the construction template, and place the data category at the back end of the element placeholder.

[0056] In one embodiment, the data construction module includes:

[0057] The identifier extraction unit is used to extract the business identifier representing the target business from the target online data;

[0058] The template matching unit is used to match the construction template corresponding to the business identifier from the construction template library, wherein the construction template library stores the mapping relationship between the business identifier and the construction template.

[0059] In one embodiment, if the content at the beginning of the placeholder contains N elements, where N is an integer greater than 2, then the information extraction module includes:

[0060] The data value extraction unit is used to determine the first element as the data value according to the order of the elements.

[0061] The column position extraction unit is used to determine that the second element is the first-level column position of the table in which it is located during rendering, to determine that the third element is the second-level column position within the first-level column position during rendering, and to determine that the i-th element is the i-1 level column position within the i-2 level column position during rendering, where i represents the order of the elements.

[0062] Thirdly, embodiments of this application provide a computer device, the computer device including a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, it implements the email-based real-time data display method as described in the first aspect.

[0063] Fourthly, embodiments of this application provide a computer-readable storage medium storing a computer program that, when executed by a processor, implements the email-based real-time data display method as described in the first aspect.

[0064] The beneficial effects of this application embodiment compared with the prior art are as follows: This application uses an email system to collect target online data for the target business at the current moment, determines the construction template corresponding to the target business, combines each group of data in the target online data with the construction template to obtain the corresponding structure data, for any structure data, extracts the content behind the dividing placeholder in the template placeholder as the row position of the table when rendering, extracts each element separated by element placeholder in the content before the dividing placeholder, determines the first element as the data value according to the order of the elements, and the other elements as the column position of the table when rendering, uses the data value, row position and column position, combined with the rendering template to render, obtain the rendering result and display it, realizes the timely display of real-time data of email sending and receiving, does not require the construction of XML template, and can effectively reduce the latency when using XML template for data mapping and recognition. Attached Figure Description

[0065] To more clearly illustrate the technical solutions in the embodiments of this application, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0066] Figure 1 This is a schematic diagram of an application environment for a real-time data display method based on email, provided in Embodiment 1 of this application.

[0067] Figure 2 This is a flowchart illustrating a real-time data display method based on email, provided in Embodiment 2 of this application.

[0068] Figure 3 This is a flowchart illustrating a real-time data display method based on email, provided in Embodiment 3 of this application.

[0069] Figure 4 This is a schematic diagram of the structure of a real-time data display device based on email, provided in Embodiment 4 of this application;

[0070] Figure 5 This is a schematic diagram of the structure of a computer device provided in Embodiment 5 of this application. Detailed Implementation

[0071] In the following description, specific details such as particular system architectures and techniques are set forth for illustrative purposes and not for limitation, in order to provide a thorough understanding of the embodiments of this application. However, those skilled in the art will understand that this application may also be implemented in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, apparatuses, circuits, and methods have been omitted so as not to obscure the description of this application with unnecessary detail.

[0072] It should be understood that, when used in this application specification and the appended claims, the term "comprising" indicates the presence of the described features, integrals, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components and / or a collection thereof.

[0073] It should also be understood that the term “and / or” as used in this application specification and the appended claims means any combination of one or more of the associated listed items and all possible combinations, and includes such combinations.

[0074] As used in this application specification and the appended claims, the term "if" may be interpreted, depending on the context, as "when," "once," "in response to determination," or "in response to detection." Similarly, the phrase "if determined" or "if detected [the described condition or event]" may be interpreted, depending on the context, as meaning "once determined," "in response to determination," "once detected [the described condition or event]," or "in response to detection [the described condition or event]."

[0075] Furthermore, in the description of this application and the appended claims, the terms "first," "second," "third," etc., are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.

[0076] References to "one embodiment" or "some embodiments" as described in this specification mean that one or more embodiments of this application include a specific feature, structure, or characteristic described in connection with that embodiment. Therefore, the phrases "in one embodiment," "in some embodiments," "in other embodiments," "in still other embodiments," etc., appearing in different parts of this specification do not necessarily refer to the same embodiment, but rather mean "one or more, but not all, embodiments," unless otherwise specifically emphasized. The terms "comprising," "including," "having," and variations thereof mean "including but not limited to," unless otherwise specifically emphasized.

[0077] The embodiments of this application can acquire and process relevant data based on artificial intelligence technology. Artificial intelligence (AI) refers to the theories, methods, technologies, and application systems that use digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use that knowledge to obtain optimal results.

[0078] Foundational technologies for artificial intelligence generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing, operating / interactive systems, and mechatronics. AI software technologies mainly encompass computer vision, robotics, biometrics, speech processing, natural language processing, and machine learning / deep learning.

[0079] It should be understood that the sequence number of each step in the following embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.

[0080] To illustrate the technical solution of this application, specific embodiments are described below.

[0081] The real-time data display method based on email provided in Embodiment 1 of this application can be applied to, for example... Figure 1 In this application environment, the client communicates with the server. Clients include, but are not limited to, handheld computers, desktop computers, laptops, ultra-mobile personal computers (UMPCs), netbooks, cloud computing devices, and personal digital assistants (PDAs). The server can be implemented using a standalone server or a server cluster consisting of multiple servers.

[0082] See Figure 2 This is a flowchart illustrating a real-time data display method based on email, provided in Embodiment 2 of this application. The aforementioned real-time data display method based on email... Figure 1 This system can be used on both the server and client sides, provided that the corresponding computer devices have an email system installed. This email system connects to the relevant business systems and databases, enabling it to acquire business data in real time for subsequent data processing. The email system has a user interface on the aforementioned computer devices, based on email UI rendering engine technology, to render and display the processed structured data. For example... Figure 2 As shown, this email-based real-time data display method may include the following steps:

[0083] Step S201: Use the email system to collect the target online data at the current moment.

[0084] In this application, the email system can refer to any system that has email sending and receiving functions, a UI rendering engine, and a display interface. The email sending and receiving functions can provide corresponding sending and receiving addresses, and the data provider can send data to the sending and receiving addresses so that the email system can receive the data.

[0085] The aforementioned target online data refers to business data transmitted via email to email addresses within an email system, targeting specific business operations. A business system can refer to a system that provides certain business services, such as a financial system or an insurance contract signing system. This system can effectively collect business data, which can be data developed specifically for the business system. For example, for a financial system, business data could include the number of approval forms, the number of approved applications, and the approval rate; for an insurance contract signing system, business data could include the number of contracts signed, the number of cases closed, and daily and monthly comparisons.

[0086] For business systems, an automatic sending function can be set up. The sender and receiver addresses of the email system and the sending time can be entered into the automatic sending function. After the sending time is reached, the corresponding business data will be automatically collected and sent to the sender and receiver addresses. The data types of business data to be sent can also be set in the automatic sending function so that the business system only collects data of the relevant business data types at the sending time.

[0087] The aforementioned statistics may refer to mapping business data to corresponding attributes such as name and type, so that subsequent structuring of business data can be carried out effectively and accurately.

[0088] For example, a set of business data after statistics is as follows:

[0089] {"assist_count":"7615",

[0090] "ai_finish_pop":"1.19382",

[0091] "scene_detail":"scene_1",

[0092] "ai_handle_cnt":"3",

[0093] "ai_handle_rate":"0.00039",

[0094] "level2_region_name":"Dongguan",

[0095] "ai_finish_cnt":"1",

[0096] "ai_finish_rate":"0.00013",

[0097] "ai_handle_pop":"1.19382"}

[0098] The content before the ":" symbol is the data attribute, and the content after the ":" symbol is the data itself. The business system has the function of statistical data, and the statistical method used can obtain a set of business data of the above type.

[0099] Step S202: Determine the construction template corresponding to the target business, and combine each group of data in the target online data with the construction template to obtain the corresponding structured data.

[0100] In this application, the construction template includes template placeholders, separator placeholders, and element placeholders. The template placeholder is a template identifier, the separator placeholder is a content separation identifier, and the element placeholder is an element separation identifier.

[0101] Due to different business needs, the corresponding data structures are different. For example, for one business, it belongs to a second-level data, with a first-level data above it and no data below it. Therefore, the data structure has two levels. For another business, the data structure may be three levels. Therefore, different construction templates need to be created for different target businesses.

[0102] The construction template needs to be paired with the target business to be able to combine with the corresponding data structure. Combining means that by filling in the corresponding data in the construction template, the structured data can be obtained. For example, for a target business with a two-level data structure, the template placeholder is represented by "{}", the separator placeholder is represented by "#", and the element placeholder is represented by ".", as shown in the construction template below:

[0103] {deptscene.scene_1.ai_handle_rate#**#100}, where deptscene represents the data value, scene_1 represents the level 1 header, ai_handle_rate represents the level 2 header, ** represents the value in the first column of the row where the data value is to be entered, and 100 indicates whether the cell into which the data value is to be entered has a % semicolon.

[0104] For example, if a data structure has a three-level target business logic, and the template placeholders are represented by "{}", the separator placeholders by "#", and the element placeholders by ".", the corresponding construction template would be as follows:

[0105] {deptscene.scene_1.ai_handle_rate.ai_handle_rate1#**#100}, where deptscene represents the data value, scene_1 represents the level 1 header, ai_handle_rate represents the level 2 header, ai_handle_rate1 represents the level 3 header, ** represents the value in the first column of the row where the data value is to be entered, and 100 indicates whether the cell where the data value is to be entered has a % semicolon.

[0106] Optionally, determining the construction template corresponding to the target business includes:

[0107] Extract business identifiers representing the target business from the target online data;

[0108] The construction template is matched with the business identifier from the construction template library, which stores the mapping relationship between business identifiers and construction templates.

[0109] Among them, the target online data packet contains the service identifier of the target service. For different target services, after the construction template is created, the service identifier of the target service and the construction template are mapped to form a map, and the mapping map is stored in the construction template library.

[0110] The aforementioned template library can be integrated with an email system as a supplementary function. After a new template is created, it can be uploaded to the template library via this supplementary function within the email system. In one embodiment, the template library is set up independently of the email system, but the email system connects to the template library to obtain templates.

[0111] Optionally, each set of data in the target online data is combined with the construction template to obtain the corresponding structured data, including:

[0112] Obtain the data value, data source organization, and data category for each group of data in the target online data;

[0113] Place the data source organization at the back of the split placeholder in the construction template, place the data value and the data category at the front of the split placeholder, and place the data value at the front of the element placeholder in the construction template, and place the data category at the back of the element placeholder.

[0114] In this system, data values ​​are the content ultimately displayed. For example, in a financial system, data values ​​could be the number of approval orders, the number of approved orders, or the approval rate. The data source organization indicates the source attribute of the corresponding data value, and the data category indicates the category attribute. For example, if the data source organization is B, all data values ​​with data source organization B can belong to the same category and can be displayed in the same row. Similarly, if the data category is AC, it means the data value belongs to category A and subcategory C. Data values ​​belonging to category A are considered the same category, and data values ​​belonging to categories AC are considered the same subcategory. Data values ​​within the same category are displayed in the same area, and subcategories can be placed in the same row or column.

[0115] Referring to the structure of the above construction template, for example, the construction template structure is as follows:

[0116] {deptscene.scene_1.ai_handle_rate#**#100}, where deptscene represents the data value, scene_1 represents the level 1 header, ai_handle_rate represents the level 2 header, the level 1 and level 2 headers represent the data category, ** represents the value in the first column of the row where the data value is to be entered, which is the data source organization, and 100 indicates whether the cell where the data value is to be entered has a % semicolon. This 100 can also belong to one of the data categories.

[0117] Step S203: For any structured data, extract the content behind the dividing placeholder within the template placeholder as the row position of the table during rendering, extract each element separated by element placeholders from the content before the dividing placeholder, determine the first element as the data value according to the order of the elements, and the other elements as the column positions of the table during rendering.

[0118] In this application, the target online data is combined with the construction template to obtain structural data. When rendering the structural data using UI engine rendering technology, it is necessary to extract the structural data so that the computer device knows the meaning of each content in the structural data.

[0119] Template placeholders can be used to define a structured data. In this structured data, the content before and after the split placeholders can be determined based on the split placeholders. Each element can be determined based on the element placeholders. According to the characteristics of the template construction, the first element in the order of elements is the data value, and the other elements are used to represent the column position of the data value in the table during rendering.

[0120] Optionally, if the content before the placeholder contains N elements, where N is an integer greater than 2, then the first element is determined as the data value based on the order of the elements, and the other elements are the column positions of the table in which they are rendered, including:

[0121] The first element is determined as the data value based on the order of the elements.

[0122] The second element is determined to be the position of the first-level column in the table during rendering. The third element is determined to be the position of the second-level column within the first-level column during rendering. The i-th element is determined to be the position of the i-1-level column within the i-2-level column during rendering. i represents the order of the elements.

[0123] The number of element placeholders in the template corresponds to the data structure of the target business. There must be at least one element placeholder. When there is only one element placeholder, the data value is at the beginning of the element placeholder, and the column position of the table where it is rendered is at the end of the element placeholder.

[0124] When there are two element placeholders, the first element placeholder's beginning represents the data value. The content between the first and second element placeholders, combined with the content after the second element placeholder, represents the column position in the table during rendering. Specifically, the content between the first and second element placeholders represents a major category (level one), and the content after the second element placeholder represents a minor category (level two) within that major category. The same logic applies to cases with more than two element placeholders.

[0125] Step S204: Use the data values, row positions, and column positions, combined with the rendering template, to render the result and display it.

[0126] In this application, after obtaining the above data values ​​and positions, the data values ​​are rendered in the corresponding positions in the rendering template, and the rendering result can be obtained by traversing all the structural data.

[0127] Optionally, the dividing placeholders include a first dividing placeholder and a second dividing placeholder. The content after the dividing placeholders within the template placeholders is extracted to be the row position of the table where it is located during rendering. Each element separated by element placeholders in the content before the dividing placeholders is extracted, including:

[0128] Extract each element separated by element placeholders from the content before the first delimiter;

[0129] Extract the content from the back end of the first split placeholder and the front end of the second split placeholder within the template placeholder to determine the row position in the table during rendering;

[0130] Extract the content behind the second dividing placeholder into the cell format for rendering;

[0131] Using data values, row positions, and column positions, combined with a rendering template, the rendering result is obtained and displayed, including:

[0132] The data values, row positions, column positions, and cell formats are combined with a rendering template to render the result and display it.

[0133] The system includes at least one separator placeholder. To allow for customized cell formatting, two separator placeholders are used: a first separator placeholder and a second separator placeholder. The first separator placeholder begins with multiple elements, the content between the first and second separator placeholders represents the row position, and the second separator placeholder represents the cell format. The data values, positions, and formats are then used in subsequent rendering to obtain the final rendering result.

[0134] This application embodiment uses an email system to collect target online data for a target business at the current time, determines a construction template corresponding to the target business, and combines each group of data in the target online data with the construction template to obtain the corresponding structured data. For any structured data, the content after the dividing placeholder in the template placeholder is extracted as the row position of the table where it is rendered, and each element separated by element placeholder in the content before the dividing placeholder is extracted. The first element is determined as the data value according to the order of the elements, and the other elements are the column positions of the table where it is rendered. The data value, row position, and column position are combined with the rendering template to render and obtain the rendering result, which is then displayed. This enables timely display of real-time data for email sending and receiving without the need to build an XML template, effectively reducing the latency when using XML templates for data mapping and recognition.

[0135] See Figure 3 This is a flowchart illustrating a real-time data display method based on email, as provided in Embodiment 3 of this application. Figure 3 As shown, this email-based real-time data display method may include the following steps:

[0136] Step S301: Use the email system to collect the target online data at the current moment.

[0137] Step S302: Determine the construction template corresponding to the target business, and combine each group of data in the target online data with the construction template to obtain the corresponding structured data.

[0138] Step S303: For any structured data, extract the content behind the dividing placeholder within the template placeholder as the row position of the table during rendering, extract each element separated by element placeholders from the content before the dividing placeholder, determine the first element as the data value according to the order of the elements, and the other elements as the column positions of the table during rendering.

[0139] Steps S301 to S303 are the same as those steps S201 to S203 above, and can be referred to the description of steps S201 to S203, which will not be repeated here.

[0140] Step S304: Perform deduplication on the row content corresponding to the row position of all structured data to obtain row content without repetition.

[0141] In this application, row position represents the row content of the first column of the row in which the cell is located, and column position represents the column content of the first row of the column in which the cell is located.

[0142] After extracting the corresponding row content, there may be duplicate content in the row content. For example, the row content corresponding to the row position of structure data 1 is scenario 1, the row content corresponding to the row position of structure data 2 is scenario 2, and the row content corresponding to the row position of structure data 3 is scenario 1. After deduplication, the row content without duplicates is scenario 1 and scenario 2.

[0143] Step S305: Perform deduplication on the column content corresponding to the column position of all structured data to obtain column content without duplication.

[0144] In this application, after the corresponding column content is extracted, there may be duplicate content in the column content. For example, the column content corresponding to the column position of structure data 1 is region 1, the column content corresponding to the column position of structure data 2 is region 2, and the column content corresponding to the column position of structure data 3 is region 1. After deduplication, the row content without duplicates is region 1 and region 2.

[0145] Step S306: Starting from the second cell in the first row of the blank table, write the column content without repetition to each cell in turn. Starting from the second cell in each row of the first column of the blank table, write the row content without repetition to each cell in turn, to obtain the initial table.

[0146] In this application, unique column and row contents are filled into a blank table to form the first row and first column, resulting in an initial table. The cell where the first row and first column intersect is left empty. Of course, this cell can be automatically filled in as needed, or it can be pre-filled in the blank table.

[0147] Step S307: Render the initial table using preset rendering rules to obtain a rendering template.

[0148] In this application, the preset rendering rule can refer to the settings for the cell color, size, etc. of a blank table. For example, the preset rendering rule is that the cell color of the first row and the first column is blue. Using the preset rendering rule to render the initial table makes the first row and the first column of the blank table turn blue, thus obtaining the rendering template.

[0149] Step S308: Use the data values, row positions, and column positions, combined with the rendering template, to render the result and display it.

[0150] Step S308 is the same as step S204 above, and can be referred to the description of step S204, so it will not be repeated here.

[0151] Optionally, data values, row positions, and column positions can be used in conjunction with a rendering template to obtain and display the rendering results, including:

[0152] Based on the row and column positions, locate the corresponding target cell in the rendering template;

[0153] Render the data value into the target cell;

[0154] Iterate through all the structure data to obtain the rendered template, and then display the rendered template.

[0155] The process involves locating the target cell from the rendering template based on its position, rendering the data value into the target cell, and, if cell formatting exists, also rendering the cell formatting into the target cell. All structured data is then traversed to obtain the rendered template, which is then displayed so that users can view the rendered template through the email system.

[0156] This application embodiment uses an email system to collect target online data for the target business at the current time, determines the construction template corresponding to the target business, and combines each group of data in the target online data with the construction template to obtain the corresponding structured data. For any structured data, the content after the dividing placeholder within the template placeholder is extracted as the row position of the table during rendering. Each element separated by element placeholders in the content before the dividing placeholder is extracted, and the first element is determined as the data value according to the order of the elements, and the other elements are the column positions of the table during rendering. The row content corresponding to the row position of all structured data is deduplicated to obtain row content without repetition. The column content corresponding to the column position is deduplicated to obtain unique column content. Starting from the second cell of the first row of the blank table, each cell is written with unique column content. Starting from the second cell of each row of the first column of the blank table, each cell is written with unique row content. This results in an initial table. The initial table is rendered using preset rendering rules to obtain a rendering template. The data values, row positions, and column positions are combined with the rendering template to render the result and display it. This enables real-time display of email sending and receiving data without the need to build an XML template, effectively reducing the latency when using XML templates for data mapping and recognition.

[0157] Corresponding to the email-based real-time data display method in the above embodiments, Figure 4 This diagram illustrates a structural block diagram of an email-based real-time data display device provided in Embodiment 4 of this application. The aforementioned email-based real-time data display device... Figure 1 This system can be used on both the server and client sides, provided that the corresponding computer devices have an email system installed. This email system connects to the relevant business systems and databases, enabling it to acquire business data from the business systems in real time for subsequent data processing. The email system has a display interface on the aforementioned computer devices, based on email UI rendering engine technology, to render and display the processed structured data. For ease of explanation, only the parts relevant to the embodiments of this application are shown.

[0158] See Figure 4 The email-based real-time data display device includes:

[0159] Data acquisition module 41 is used to collect target online data at the current moment using the email system. The target online data is business data for the target business transmitted via email based on the email address of the email system.

[0160] The data construction module 42 is used to determine the construction template corresponding to the target business. Each set of data in the target online data is combined with the construction template to obtain the corresponding structured data. The construction template includes template placeholders, segment placeholders and element placeholders. The template placeholder is the template identifier, the segment placeholder is the content segment identifier, and the element placeholder is the element segment identifier.

[0161] The information extraction module 43 is used to extract the content after the dividing placeholder in the template placeholder as the row position of the table when rendering, and extract each element divided by the element placeholder in the content before the dividing placeholder. The first element is determined as the data value according to the order of the elements, and the other elements are the column positions of the table when rendering.

[0162] The rendering and display module 44 is used to render data values, row positions, and column positions in combination with a rendering template, obtain the rendering result, and display it.

[0163] Optionally, the row position represents the content of the first column of the row in which the cell is located, and the column position represents the content of the first row of the column in which the cell is located. The real-time data display device also includes:

[0164] The first deduplication module is used to use data values, row positions, and column positions, combined with the rendering template, to render the data. Before the rendering result is obtained and displayed, the module performs deduplication on the row content corresponding to the row position of all structured data to obtain row content without repetition.

[0165] The second deduplication module is used to deduplicate the column content corresponding to the column position of all structured data to obtain column content without repetition.

[0166] The initial table construction module is used to write non-repeating column content into each cell of the first row of a blank table, starting from the second cell and continuing to each cell thereafter, and to write non-repeating row content into each cell of the first row of the first column of the blank table, starting from the second cell and continuing to each cell thereafter, thus obtaining the initial table.

[0167] The template rendering module is used to render the initial table using preset rendering rules to obtain a rendering template.

[0168] Optionally, the rendering and display module 44 includes:

[0169] The position determination unit is used to find the corresponding target cell in the rendering template based on the row and column positions;

[0170] The data rendering unit is used to render data values ​​into the target cell;

[0171] The rendering and display unit is used to traverse all structural data, obtain the rendered template, and display the rendered template.

[0172] Optionally, the segmentation placeholders include a first segmentation placeholder and a second segmentation placeholder, and the information extraction module 43 includes:

[0173] The element extraction unit is used to extract each element separated by the element placeholder from the content at the beginning of the first dividing placeholder;

[0174] The row position extraction unit is used to extract the content of the back end of the first dividing placeholder and the front end of the second dividing placeholder within the template placeholder as the row position of the table where it is rendered.

[0175] The format extraction unit is used to extract the content behind the second dividing placeholder as the cell format during rendering.

[0176] The rendering and display module 44 specifically includes:

[0177] The data values, row positions, column positions, and cell formats are combined with a rendering template to render the result and display it.

[0178] Optionally, the data construction module 42 includes:

[0179] The data content acquisition unit is used to acquire the data value, data source organization, and data category of each group of data in the target online data.

[0180] The data construction unit is used to place the data source organization at the back of the split placeholder in the construction template, place the data value and the data category at the front of the split placeholder, and place the data value at the front of the element placeholder in the construction template and the data category at the back of the element placeholder.

[0181] Optionally, the data construction module 42 includes:

[0182] The identifier extraction unit is used to extract business identifiers that represent the target business from the target online data.

[0183] The template matching unit is used to match the construction template corresponding to the business identifier from the construction template library. The construction template library stores the mapping relationship between the business identifier and the construction template.

[0184] Optionally, if the content before the placeholder contains N elements, where N is an integer greater than 2, then the information extraction module 43 includes:

[0185] The data value extraction unit is used to determine the first element as the data value according to the order of the elements.

[0186] The column position extraction unit is used to determine that the second element is the first-level column position of the table in which it is located during rendering, the third element is the second-level column position within the first-level column position during rendering, and the i-th element is the i-1-level column position within the i-2-level column position during rendering, where i represents the order of the elements.

[0187] It should be noted that the information interaction and execution process between the above modules are based on the same concept as the method embodiments of this application. For details on their specific functions and technical effects, please refer to the method embodiments section, which will not be repeated here.

[0188] Figure 5 This is a schematic diagram of the structure of a computer device provided in Embodiment 5 of this application. Figure 5 As shown, the computer device of this embodiment includes: at least one processor ( Figure 5 Only one is shown in the diagram), a memory, and a computer program stored in the memory and capable of running on at least one processor, which, when executed by the processor, implements the steps in any of the above embodiments of the email-based real-time data display method.

[0189] This computer device may include, but is not limited to, a processor and memory. Those skilled in the art will understand that... Figure 5 The examples of computer devices are merely examples and do not constitute a limitation on computer devices. Computer devices may include more or fewer components than shown in the illustration, or combinations of certain components, or different components, such as network interfaces, displays, and input devices.

[0190] The processor referred to can be a CPU, but it can also be other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor can be a microprocessor or any conventional processor.

[0191] Memory includes readable storage media, internal memory, etc., wherein internal memory can be the RAM of a computer device, providing an environment for the operation of the operating system and computer-readable instructions stored in the readable storage media. The readable storage media can be the hard drive of a computer device, or in other embodiments, it can be an external storage device of the computer device, such as a plug-in hard drive, Smart Media Card (SMC), Secure Digital (SD) card, or Flash Card. Furthermore, memory can include both internal storage units and external storage devices of a computer device. Memory is used to store the operating system, applications, bootloader, data, and other programs, such as program code for computer programs. Memory can also be used to temporarily store data that has been output or will be output.

[0192] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the above-described division of functional units and modules is used as an example. In practical applications, the above functions can be assigned to different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiments can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit. Furthermore, the specific names of the functional units and modules are only for easy differentiation and are not intended to limit the scope of protection of this application. The specific working process of the units and modules in the above device can be referred to the corresponding process in the foregoing method embodiments, and will not be repeated here. If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the methods of the above embodiments of this application can be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the above method embodiments. The computer program includes computer program code, which can be in the form of source code, object code, executable files, or certain intermediate forms. A computer-readable medium can include at least: any entity or device capable of carrying computer program code, a recording medium, a computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signals, telecommunication signals, and software distribution media. Examples include USB flash drives, portable hard drives, magnetic disks, or optical disks. In some jurisdictions, according to legislation and patent practice, computer-readable media cannot be electrical carrier signals or telecommunication signals.

[0193] The implementation of all or part of the processes in the methods of the above embodiments can also be accomplished by a computer program product. When the computer program product is run on a computer device, it enables the computer device to execute the steps in the above method embodiments.

[0194] In the above embodiments, the descriptions of each embodiment have different focuses. For parts that are not described in detail or recorded in a certain embodiment, please refer to the relevant descriptions of other embodiments.

[0195] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0196] In the embodiments provided in this application, it should be understood that the disclosed apparatus / computer devices and methods can be implemented in other ways. For example, the apparatus / computer device embodiments described above are merely illustrative. For instance, the division of modules or units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or units may be electrical, mechanical, or other forms.

[0197] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0198] The above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application, and should all be included within the protection scope of this application.

Claims

1. A method for real-time data display based on email, characterized in that, The real-time data display method includes: The target online data at the current moment is collected using the email system. The target online data is business data for the target business transmitted via email based on the email address of the email system. A construction template corresponding to the target business is determined, and each group of data in the target online data is combined with the construction template to obtain the corresponding structured data. The construction template includes template placeholders, segment placeholders and element placeholders. The template placeholder is a template identifier, the segment placeholder is a content segment identifier, and the element placeholder is an element segment identifier. For any structured data, extract the content after the dividing placeholder in the template placeholder as the row position of the table during rendering, extract each element divided by the element placeholder in the content before the dividing placeholder, determine the first element as the data value according to the order of the elements, and the other elements as the column position of the table during rendering. Using the data values, the row positions, and the column positions, and combining them with the rendering template, a rendering result is obtained and displayed. Each set of data in the target line data is combined with the construction template to obtain the corresponding structure data, including: Obtain the data value, data source organization, and data category of each group of data in the target online data; Place the data source organization at the back end of the segment placeholder in the construction template, place the data value and the data category at the front end of the segment placeholder, and place the data value at the front end of the element placeholder in the construction template, and place the data category at the back end of the element placeholder.

2. The real-time data display method according to claim 1, characterized in that, The row position represents the row content of the first column of the row in which the cell is located, and the column position represents the column content of the first row of the column in which the cell is located. Before rendering and displaying the rendered result using the data value, the row position, and the column position, combined with the rendering template, the process further includes: The row content corresponding to the row position of all structured data is deduplicated to obtain row content without repetition; The column content corresponding to the column position of all structured data is deduplicated to obtain column content without repetition; Starting from the second cell in the first row of the blank table, write the column content without repetition into each subsequent cell. Starting from the second cell in each row of the first column of the blank table, write the row content without repetition into each subsequent cell to obtain the initial table. The initial table is rendered using preset rendering rules to obtain a rendering template.

3. The real-time data display method according to claim 2, characterized in that, Using the data values, row positions, and column positions, and combining them with the rendering template, a rendering result is obtained and displayed, including: Based on the row position and the column position, find the corresponding target cell in the rendering template; Render the data value into the target cell; Traverse all structural data to obtain the rendered template, and then display the rendered template.

4. The real-time data display method according to claim 1, characterized in that, The dividing placeholders include a first dividing placeholder and a second dividing placeholder. The content following the dividing placeholder within the template placeholder is extracted as the row position in the table during rendering. Each element separated by the element placeholder within the content preceding the dividing placeholder includes: Extract each element from the content preceding the first segmentation placeholder, which is segmented by the element placeholder; Extract the content of the back end of the first dividing placeholder and the front end of the second dividing placeholder within the template placeholder to determine the row position of the table during rendering; Extract the content at the back of the second dividing placeholder into the cell format for rendering; Using the data values, row positions, and column positions, and combining them with the rendering template, a rendering result is obtained and displayed, including: Using the data values, row positions, column positions, and cell formats, and combining them with the rendering template, a rendering result is obtained and displayed.

5. The real-time data display method according to claim 1, characterized in that, Determining the construction template corresponding to the target service includes: Extract the business identifier representing the target service from the target online data; The construction template corresponding to the business identifier is matched from the construction template library, which stores the mapping relationship between the business identifier and the construction template.

6. The real-time data display method according to any one of claims 1 to 5, characterized in that, If the content at the beginning of the placeholder contains N elements, where N is an integer greater than 2, then determining the first element as the data value based on the order of the elements, and the other elements as the column positions of the table during rendering, includes: The first element is determined as the data value based on the order of the elements. The second element is determined to be the position of the first-level column in the table during rendering. The third element is determined to be the position of the second-level column within the first-level column during rendering. The i-th element is determined to be the position of the i-1-level column within the i-2-level column during rendering. i represents the order of the elements.

7. A real-time data display device based on email, characterized in that, The real-time data display device includes: The data acquisition module is used to collect target online data at the current moment using the email system. The target online data is business data for the target business transmitted via email based on the email address of the email system. The data construction module is used to determine the construction template corresponding to the target business, and to combine each group of data in the target online data with the construction template to obtain the corresponding structured data. The construction template includes template placeholders, segment placeholders and element placeholders. The template placeholder is a template identifier, the segment placeholder is a content segment identifier and the element placeholder is an element segment identifier. The information extraction module is used to extract, for any structured data, the content after the dividing placeholder in the template placeholder as the row position of the table during rendering, and extract each element divided by the element placeholder in the content before the dividing placeholder, and determine the first element as the data value according to the order of the elements, and the other elements as the column position of the table during rendering. The rendering and display module is used to use the data values, the row positions, and the column positions, combined with the rendering template, to render the result and display it. The data construction module includes: The data content acquisition unit is used to acquire the data value, data source organization, and data category of each group of data in the target online data; A data construction unit is used to place the data source organization at the back end of the segment placeholder in the construction template, place the data value and the data category at the front end of the segment placeholder, and place the data value at the front end of the element placeholder in the construction template, and place the data category at the back end of the element placeholder.

8. A computer device, characterized in that, The computer device includes a processor, a memory, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the real-time data display method as described in any one of claims 1 to 6.

9. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the real-time data display method as described in any one of claims 1 to 6.

Images