CN105468592B - display method and device of associated data table - Google Patents
display method and device of associated data table Download PDFInfo
- Publication number
- CN105468592B CN105468592B CN201410380352.4A CN201410380352A CN105468592B CN 105468592 B CN105468592 B CN 105468592B CN 201410380352 A CN201410380352 A CN 201410380352A CN 105468592 B CN105468592 B CN 105468592B
- Authority
- CN
- China
- Prior art keywords
- data
- characteristic value
- result data
- result
- business object
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a method and a device for displaying an associated data table, wherein the method comprises the following steps: acquiring first service object data and second service object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications; storing the first service object data and the second service object data into a database; extracting first service object data and second service object data with the first identification and the second identification consistent from the database, and generating associated data of the first service object data and the second service object data based on the first identification or the second identification; writing the associated data into an associated data table; and providing the display of the associated data table. The embodiment of the invention is used for providing the display of the associated data table, so that the reading and understanding of related personnel are facilitated.
Description
Technical Field
the present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for displaying an associated data table.
background
The data sheet is an indispensable part of an enterprise application software system, various data sheets are automatically or auxiliarily generated through a computer, the standardized management of data can be realized, the working efficiency is greatly improved, and the informatization process of various industries is accelerated. As a presentation form of the data sheet, the appearance of the statement of account brings great convenience to the daily life of people.
statement regarding bills is widely used in transaction systems. The user can recharge his account in the transaction system, and perform various consumption behaviors through the transaction system, so as to facilitate the user to know his consumption situation, generally list a statement at the end of the month or the end of the year, and provide the user with knowledge of his consumption situation in the current month or the current year, but the transaction system only lists the consumption behavior of the user, for example, lists a certain consumption expenditure of 300 yuan, and the corresponding consumption behavior is clothing. The method for simply listing each consumption of the user is that the user can only know the consumption condition of the user, but can not know the corresponding relation between each recharging and consumption, can not accurately reflect the consumption of the money recharged to the transaction system, can not carry out business intelligent analysis on the consumption behavior of the user, and is difficult to know the recharging and consumption conditions of the user in the transaction system, thereby being capable of reasonably distributing account funds and providing data guidance.
disclosure of Invention
the technical problem to be solved by the embodiments of the present invention is to provide a method for displaying an association data table, which analyzes a corresponding relationship between business object data and the business object data, stores the business object data into the association data table, and provides a display of the association data table, so that relevant people can read and understand the association data table conveniently.
Correspondingly, the embodiment of the invention also provides a display device of the associated data table, which is used for ensuring the realization and the application of the method.
in order to solve the above problems, the present invention discloses a method for displaying an associated data table, comprising:
acquiring first service object data and second service object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications;
Storing the first service object data and the second service object data into a database;
extracting first service object data and second service object data with the first identification and the second identification consistent from the database, and generating associated data of the first service object data and the second service object data based on the first identification or the second identification;
writing the associated data into an associated data table;
and providing the display of the associated data table.
preferably, before the step of acquiring the first service object data and the second service object data, the method further includes:
the database is emptied.
Preferably, the step of extracting the first service object data and the second service object data of which the first identifier is consistent with the second identifier from the database and generating the associated data of the first service object data and the second service object data based on the first identifier or the second identifier includes:
Judging whether a second identifier consistent with the first identifier exists or not;
if yes, extracting first business object data corresponding to the first identification and second business object data corresponding to the second identification from the database;
and recording the first service object data and the second service object data as associated data.
Preferably, the first business object data includes first characteristic value data and second characteristic value data, and the second business object data includes third characteristic value data and fourth characteristic value data; the step of recording the first service object data and the second service object data as associated data includes:
judging whether the first characteristic value data is larger than or equal to the third characteristic value data;
If the first characteristic value data is greater than or equal to the third characteristic value data, taking the first characteristic value data as first result data;
calculating a difference between the first result data and the third feature value data;
Taking the difference value as second result data;
Taking the third characteristic value data as third result data;
if the first characteristic value data is smaller than the third characteristic value data, taking the first characteristic value data as first result data;
taking a preset numerical value as second result data;
taking the first characteristic value data as third result data;
And recording the first result data, the second result data and the third result data as associated data.
preferably, if the first characteristic value data is smaller than the third characteristic value data, the step of recording the first service object data and the second service object data as the associated data further includes:
calculating a difference value between the third characteristic value data and the first characteristic value data;
the difference is taken as fourth result data.
preferably, the step of recording the first service object data and the second service object data as associated data further includes:
judging whether the second characteristic value data is greater than or equal to the fourth characteristic value data; if the second characteristic value data is greater than or equal to the fourth characteristic value data, the second result data is used as first result data;
Calculating a difference between the first result data and fourth characteristic value data;
taking the difference value as second result data;
taking the fourth characteristic value data as third result data;
calculating a difference between the fourth characteristic value data and the third result data;
taking the difference value as fourth result data;
if the second characteristic value data is smaller than the fourth characteristic value data, judging whether the fourth result data is smaller than or equal to a preset value;
if the fourth result data is less than or equal to a preset value, judging whether the second result data is the preset value; if the second result data is a preset numerical value, taking the second characteristic value data as first result data;
if the second result data is not a preset value, taking the second result data as first result data;
taking a preset numerical value as second result data;
taking the first result data as third result data;
if the fourth result data is larger than a preset value, taking the second characteristic value data as first result data;
judging whether the second characteristic value data is larger than or equal to fourth result data or not;
if the second characteristic value data is greater than or equal to fourth result data, calculating a difference value between the second characteristic value data and the fourth result data;
taking the difference value as second result data;
if the second characteristic value data is smaller than fourth result data, taking a preset numerical value as second result data;
taking the first result data as third result data;
and recording the first result data, the second result data and the third result data as associated data.
preferably, the first service object data and the second service object data have a first state identifier, and after the step of extracting the first service object data and the second service object data of which the first identifiers are consistent with the second identifiers from the database and generating the associated data of the first service object data and the second service object data based on the first identifiers or the second identifiers, the method further includes:
and updating the first state identifier of the first service object data and the second service object data to be a second state identifier.
preferably, the first business object data is recharging data, and the second business object data is consumption data; the first identification and the second identification are user identifications; the first characteristic value data and the second characteristic value data are recharging amount, and the third characteristic value data and the fourth characteristic value data are consumption amount; the first state flag is 0, and the second state flag is 1; the first result data is a last recharging balance, the second result data is a current balance, the third result data is a consumption balance, the fourth result data is a residual consumption balance, and the preset value is 0.
the embodiment of the invention also discloses a display device of the associated data table, which comprises the following components:
The acquisition module is suitable for acquiring first business object data and second business object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications;
the storage module is suitable for storing the first business object data and the second business object data into a database;
the generating module is suitable for extracting first service object data and second service object data with first identifications and second identifications consistent from the database and generating associated data of the first service object data and the second service object data based on the first identifications or the second identifications;
The writing module is suitable for writing the associated data into an associated data table;
and the display module is suitable for providing display of the associated data table.
preferably, the apparatus further comprises:
and the emptying module is suitable for emptying the database.
preferably, the generating module comprises:
the judgment submodule is suitable for judging whether a second identifier consistent with the first identifier exists or not; if yes, calling an extraction submodule;
the extraction submodule is suitable for extracting first business object data corresponding to the first identification and second business object data corresponding to the second identification from the database;
and the recording submodule is suitable for recording the first service object data and the second service object data as associated data.
preferably, the first business object data includes first characteristic value data and second characteristic value data, and the second business object data includes third characteristic value data and fourth characteristic value data; the recording sub-module includes:
a first judgment unit configured to judge whether the first characteristic value data is greater than or equal to the third characteristic value data; if the first characteristic value data is greater than or equal to the third characteristic value data, calling a first processing unit, if the first characteristic value data is less than the third characteristic value data, calling a fourth processing unit,
a first processing unit configured to take the first feature value data as first result data;
A first calculation unit configured to calculate a difference value between the first result data and the third feature value data;
A second processing unit for taking the difference value as second result data;
a third processing unit configured to take the third feature value data as third result data;
a fourth processing unit configured to take the first feature value data as first result data;
A fifth processing unit, configured to preset a numerical value as second result data;
a sixth processing unit configured to take the first feature value data as third result data;
and the first recording unit is used for recording the first result data, the second result data and the third result data as the associated data.
preferably, if the first characteristic value data is smaller than the third characteristic value data, the recording submodule further includes:
a second calculation unit configured to calculate a difference value between the third characteristic value data and the first characteristic value data;
a seventh processing unit for taking the difference value as fourth result data.
preferably, the recording sub-module further includes:
A second determination unit configured to determine whether the second characteristic value data is greater than or equal to the fourth characteristic value data; if the second characteristic value data is greater than or equal to the fourth characteristic value data, calling an eighth processing unit, and if the second characteristic value data is less than the fourth characteristic value data, calling a third judging unit;
an eighth processing unit configured to take the second result data as first result data;
a third calculation unit configured to calculate a difference between the first result data and fourth feature value data;
a ninth processing unit configured to take the difference value as second result data;
a tenth processing unit configured to take the fourth feature value data as third result data;
A fourth calculation unit configured to calculate a difference value between the fourth feature value data and the third result data;
an eleventh processing unit configured to take the difference value as fourth result data;
a third judging unit, configured to judge whether the fourth result data is less than or equal to a preset value; if the fourth result data is less than or equal to the preset value, a fourth judgment unit is called,
A fourth judging unit, configured to judge whether the second result data is a preset value; if the second result data is a preset numerical value, calling a twelfth processing unit, and if the second result data is not the preset numerical value, calling a thirteenth processing unit;
a twelfth processing unit configured to take the second characteristic value data as first result data;
a thirteenth processing unit configured to take the second result data as first result data;
a fourteenth processing unit, configured to take the preset value as second result data;
A fifteenth processing unit configured to take the first result data as third result data;
a sixteenth processing unit, configured to take the second feature value data as first result data if the fourth result data is greater than a preset numerical value;
a fifth judging unit operable to judge whether the second characteristic value data is greater than or equal to fourth result data; if the second characteristic value data is greater than or equal to fourth result data, calling a fifth calculating unit, and if the second characteristic value data is less than the fourth result data, calling an eighteenth processing unit;
a fifth calculation unit configured to calculate a difference value between the second feature value data and the fourth result data;
a seventeenth processing unit configured to take the difference as second result data;
an eighteenth processing unit configured to take the preset numerical value as second result data;
a nineteenth processing unit configured to take the first result data as third result data;
and the second recording unit is used for recording the first result data, the second result data and the third result data as associated data.
preferably, the first service object data and the second service object data have a first state identifier, and further include:
And the modification module is suitable for modifying the first state identifier of the first service object data and the second state identifier of the second service object data into a second state identifier.
preferably, the first business object data is recharging data, and the second business object data is consumption data; the first identification and the second identification are user identifications; the first characteristic value data and the second characteristic value data are recharging amount, and the third characteristic value data and the fourth characteristic value data are consumption amount; the first state flag is 0, and the second state flag is 1; the first result data is a last recharging balance, the second result data is a current balance, the third result data is a consumption balance, the fourth result data is a residual consumption balance, and the preset value is 0.
compared with the prior art, the embodiment of the invention has the following advantages:
In the embodiment of the invention, the business object data is acquired, the associated data is generated and written into the associated data table for the related business object data according to the identification of the business object data, and the associated data table can be displayed. The generation of the associated data of the business object data can better show the corresponding relation of the business object data, reduce the workload of business object data analysis for related personnel and improve the data processing capacity.
In the embodiment of the invention, the process calculation associated data can be calculated according to the relation of the business object data, so that the calculation time is reduced, and the overall data processing efficiency is improved.
drawings
FIG. 1 is a flowchart of the steps of embodiment 1 of a method for presenting an associated data table according to an embodiment of the present invention;
FIG. 2 is a flowchart of the steps of embodiment 2 of a method for presenting an associated data table according to an embodiment of the present invention;
FIG. 3 is a block diagram of a device for displaying an associated data table according to an embodiment of the present invention.
Detailed Description
in order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.
One of the core concepts of the embodiment of the present invention is to obtain the business object data, generate the associated data for the related business object data according to the identification of the business object data, write the associated data into the associated data table, and display the associated data table. And generating the associated data of the business object data, thereby better showing the corresponding relation of the business object data. The workload of related personnel for reducing the data analysis of the business object is reduced, and the data processing capacity is improved.
referring to fig. 1, a flowchart of a step of an embodiment 1 of a presentation method for an associated data table according to an embodiment of the present invention is shown, which may specifically include the following steps:
step 101, acquiring first service object data and second service object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications;
it should be noted that, in the business fields of different systems, the oriented business objects are also different. For example, in the business field of a news media system, a targeted business object may be news data; in the business field of the electronic commerce system, the oriented business objects can be commodity data and store data; in the business field of the transaction system, the oriented business objects can be filling data and consumption data, and the like.
Taking a transaction system as an example, the first business object data may be filling value data, and the second business object data may be consumable data; the first identifier and the second identifier may be user identifiers, such as user accounts used by the user when the transaction system performs various consuming activities.
step 102, storing the first service object data and the second service object data into a database;
in a specific implementation, all the first service object data and all the second service object data in a certain time period may be collected and stored in the database according to the first identifier and the second identifier. For example, all top-up and consumption data for a transaction system during a month may be collected and stored in the database based on the user identification.
103, extracting first service object data and second service object data with the first identification and the second identification consistent from the database, and generating associated data of the first service object data and the second service object data based on the first identification or the second identification;
In a preferred embodiment of the present invention, the step 103 may comprise the following sub-steps:
A substep S11 of determining whether there is a second identifier identical to the first identifier; if yes, go to substep S12;
Substep S12, extracting first business object data corresponding to the first identifier and second business object data corresponding to the second identifier from the database;
and a substep S13 of recording the first service object data and the second service object data as associated data.
in the specific implementation, the business object data in the database has corresponding identifiers, and when the consistent business object data is found, the business object data corresponding to the identifiers is obtained. Such as top-up data and consumption data in a transaction system, are based on user identification.
In a preferred embodiment of the present invention, the first business object data may include first characteristic value data and second characteristic value data, and the second business object data may include third characteristic value data and fourth characteristic value data; the sub-step S13 may include:
A substep S13-1 of determining whether the first characteristic value data is greater than or equal to the third characteristic value data; performing a sub-step S13-2 if the first characteristic value data is greater than or equal to the third characteristic value data, and performing a sub-step S13-7 if the first characteristic value data is less than the third characteristic value data;
A substep S13-2 of taking the first characteristic value data as first result data;
A substep S13-3 of calculating a difference value between the first result data and the third characteristic value data;
a substep S13-4 of taking the difference value as second result data;
a substep S13-5 of taking the third characteristic value data as third result data;
substep S13-6, recording the first result data, the second result data and the third result data as associated data;
A substep S13-7 of taking the first characteristic value data as first result data;
substep S13-8, taking a preset value as second result data;
A substep S13-9 of taking the first characteristic value data as third result data;
and a substep S13-10 of recording the first result data, the second result data and the third result data as associated data.
In a preferred embodiment of the present invention, if the first characteristic value data is smaller than the third characteristic value data, the sub-step S13 may further include:
A substep S13-11 of calculating a difference value of the third characteristic value data and the first characteristic value data;
And a sub-step S13-12 of taking the difference as fourth result data.
in a preferred embodiment of the present invention, the sub-step S13 may further include:
A substep S13-13 of determining whether the second characteristic value data is greater than or equal to the fourth characteristic value data; performing the sub-step S13-14 if the second characteristic value data is greater than or equal to the fourth characteristic value data, and performing the sub-step S13-20 if the second characteristic value data is less than the fourth characteristic value data;
a substep S13-14 of taking the second result data as first result data;
a substep S13-15 of calculating a difference between the first result data and the fourth characteristic value data;
a substep S13-16 of taking the difference as second result data;
a substep S13-17 of taking the fourth characteristic value data as third result data;
a substep S13-18 of calculating a difference value of the fourth characteristic value data and the third result data;
substeps 13-19, taking the difference as fourth result data;
substep S13-20, determining whether the fourth result data is less than or equal to a preset value; performing substeps 13-21 if the fourth result data is less than or equal to a predetermined value, and performing substeps 13-26 if the fourth result data is greater than the predetermined value;
Substeps 13-21, determining whether the second result data is a preset value; performing substeps 13-22 if the second result data is a predetermined value, and performing substeps 13-23 if the second result data is not the predetermined value;
a substep S13-22 of taking the second characteristic value data as first result data;
a substep S13-23 of treating the second result data as first result data;
substeps 13-24, using the preset value as the second result data;
a substep S13-25 of taking the first result data as third result data;
Substeps 13-26 of taking the second characteristic value data as first result data;
A substep S13-27 of judging whether the second characteristic value data is greater than or equal to fourth result data; performing the sub-step S13-28 if the second characteristic value data is greater than or equal to fourth result data, and performing the sub-step S13-30 if the second characteristic value data is less than the fourth result data;
A substep S13-28 of calculating a difference value of the second characteristic value data and the fourth result data;
Substeps 13-29, taking the difference value as second result data;
substeps 13-30, using the preset value as second result data;
A substep S13-31 of taking the first result data as third result data;
And a substep S13-32 of recording the first result data, the second result data and the third result data as associated data.
in the concrete implementation, assuming that there are a plurality of recharging and corresponding plurality of consumption, the calculation is started from the first recharging and the first consumption, if the first recharging is greater than or equal to the first consumption, the first recharging minus the first consumption may be offset exactly, or there are some remainders, which may be added in the calculation of the associated data of the next consumption, if the first recharging is less than the first consumption, the current consumption needs to use the recharging of the next consumption to calculate the associated data, and so on, until the collected plurality of recharging and the corresponding plurality of consumption may be offset with each other, at this time, the associated data completes the calculation, and the next operation may be performed. It should be noted that, in practice, the association data may also be calculated in other manners, and the embodiment of the present invention is not limited to this.
step 104, writing the associated data into an associated data table;
and 105, providing the display of the associated data table.
by applying the embodiment of the invention, the generated associated data is written into the associated data table in the database. When the relevant personnel need to query the associated data table, a query request can be sent to the database to acquire the associated data so as to provide the relevant personnel with the display of the associated data table. It should be noted that, in the embodiment of the present invention, an appropriate data dimension may be selected according to a requirement of the user.
Specifically, after the user logs in the application, a query request may be initiated to query the associated data table content to be viewed, where the query request may include a data table identifier, and the data table identifier may include the following information: identification of business object data. After receiving the query request, the associated data table content matched with the data table identifier can be obtained from the database as the display content, so that the associated data table content can be obtained more pertinently and efficiently, and the user experience effect is improved.
the embodiment of the invention can analyze the corresponding relation between the user recharging amount and the consumption behaviors, and the recharged money is respectively used in the consumption behaviors, thereby providing data for carrying out business intelligent analysis on the consumption behaviors of the user, facilitating the user to know the recharging and consumption conditions and providing data guidance for reasonably distributing account funds.
referring to fig. 2, a flowchart of a step of embodiment 2 of a presentation method for an associated data table according to an embodiment of the present invention is shown, which may specifically include the following steps:
Step 201, emptying a database;
in the specific implementation, when new business object data is stored in the database, records of transaction days to be collected in a collection table in the database can be emptied in advance, transaction records in a transaction system of yesterday are collected today, and other data such as yesterday transaction records in the collection table are emptied first.
step 202, acquiring first service object data and second service object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications;
step 203, storing the first service object data and the second service object data into a database;
step 204, extracting first service object data and second service object data with the first identifier and the second identifier consistent from the database, and generating associated data of the first service object data and the second service object data based on the first identifier or the second identifier;
step 205, modifying the first state identifier of the first service object data and the second service object data to be a second state identifier;
In a specific implementation, a default state 0 of the business object data in the collection table of the database indicates that the business object data is not analyzed yet, associated data is generated, and after the business object data is analyzed, the analyzed business object data is modified from the default state 0 to an end state 1 in order to avoid repeated operations. For example, after a certain recharge and consumption analysis is finished, the state is changed from the default state 0 to the end state 1, and the recharge and consumption will not participate when the statement program is operated next time.
Of course, other marks may also be used as the identifier for whether the service object data has been analyzed, for example, a default state 1 indicates that analysis has not been performed, and an end state 0 indicates that analysis is completed.
Step 206, writing the associated data into an associated data table;
step 207, providing the display of the associated data table.
in order to further understand the embodiments of the present invention, the following description uses specific examples.
Taking a transaction system as an example, the first business object data may be filling value data, and the second business object data may be consumption data; the first identification and the second identification are user identifications; the first characteristic value data can be a recharge amount, and the second characteristic value data can be a consumption amount; the first state flag may be 0, and the second state flag may be 1; the first result data may be a last charged balance, the second result data may be a current balance, and the third result data may be a consumed balance. The associated data table is a statement. The process of displaying the associated data table of the recharge data and the consumption data is realized as follows:
and (4) collecting recharging and consumption data of all users every day in advance, and inserting a collection table after the end state defaults to 0.
and after the recharging and consumption data of the user are collected, operating to generate a statement program, and inserting the recharging and consumption data of the user into an account form table in a statement database, wherein the statement table data comprises the corresponding relation of recharging records, consumption records and recharging consumption.
and displaying the account statement table of the page query database.
as an example of a specific application of the present invention, the statement pseudo code is generated as follows:
and finally, the account checking list table can be obtained by running the codes. When a user or related personnel needs to query the statement of account table, a query request can be sent to the database, and a proper data dimension can be selected for query according to self requirements, for example, the time of recharging and consuming transactions can be increased. An example of query operation result data specifically is as follows:
note that the original charge occurrence sequence in this example refers to the transaction serial number in the pseudo code. In addition, in this example, several association data are first defined: last charge balance, current balance, consumption balance, and may be initialized to 0. The consumption amount is the amount used in one consumption, the last-time recharging balance is the amount obtained by subtracting the consumption amount used in the last consumption from a certain recharging operation, the current balance is the amount obtained by subtracting the consumption amount used in the current consumption from the last-time recharging balance, and the consumption balance is the amount occupied by the consumption amount used in the current consumption in the last-time recharging balance. For example, if a charge of the user a is 10 yuan, and the user a consumes 3 times and uses the charge, there will be three groups of associated data in total, and if the consumption amounts of the 3 times of consumption are 1 yuan, and 8 yuan, respectively, the last charge balance, the current balance, and the consumption balance in the first group of associated data are: 10-membered, 9-membered, 1-membered; the last recharging balance, the current balance and the consumption balance in the second group of associated data are respectively as follows: 9-membered, 8-membered, 1-membered; the last recharging balance, the current balance and the consumption balance in the third group of associated data are respectively as follows: 8-membered, 0-membered, 8-membered.
In a specific implementation, there is another associated data: the residual consumption balance means that the current last-time recharging balance cannot completely offset the amount of a certain consumption. For example, there is a recharge amount of 2 yuan (the last recharge balance is 2 yuan at this time), a recharge amount of 4 yuan, and at this time, the corresponding of the recharge amount of 4 yuan and the recharge amount of 2 yuan is only 2 yuan, which means that the recharge amount of this time cannot be completely offset, there will be more transactions, that is, another recharge amount is needed to offset the recharge amount, and other related data will be calculated. When the balance of the last recharging and the consumption amount cannot be completely offset, the mark of more transactions can be changed into 1, which indicates that more transactions exist and other associated data needs to be calculated.
in a specific implementation, when the remaining consumption balance is not 0, the current consumption may be continuously calculated, and if the remaining consumption balance is 0, the end state identifier may be updated for the current consumption, which indicates that the current consumption has been analyzed, and does not participate any more next time, and certainly, the next consumption may be continuously calculated. When the current balance is not 0, the recharging of the pen can be continuously calculated, and when the current balance is 0, the recharging ending state of the pen of the collection form can be updated to show that the recharging is analyzed and does not participate any more next time.
In the embodiment of the present invention, a presentation form other than a table, such as a bar chart, a pie chart, or the like, may also be adopted. In addition, when the associated data packet is displayed, only the associated data and the identification can be listed, so that the reading amount of related personnel is reduced. Of course, other data besides the associated data can be added, so that the relevant personnel can quickly know the overall data situation. By adopting a mode of adding or reducing data dimensions, personalized services can be provided for different people needing to be displayed, and the user experience effect is improved.
it should be noted that, for simplicity of description, the method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the illustrated order of acts, as some steps may occur in other orders or concurrently in accordance with the embodiments of the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no particular act is required to implement the invention.
referring to fig. 3, a block diagram of a structure of an embodiment of an apparatus for displaying an associated data table according to an embodiment of the present invention is shown, which may specifically include the following modules:
an obtaining module 301, adapted to obtain first service object data and second service object data; the first business object data has one or more first identifications, and the second business object data has one or more second identifications;
a storage module 302, adapted to store the first service object data and the second service object data in a database;
a generating module 303, adapted to extract first service object data and second service object data of which the first identifier is consistent with the second identifier from the database, and generate associated data of the first service object data and the second service object data based on the first identifier or the second identifier;
In a preferred embodiment of the present invention, the generating module 303 may include the following sub-modules:
the judgment submodule is suitable for judging whether a second identifier consistent with the first identifier exists or not; if so, then
the extraction submodule is suitable for extracting first business object data corresponding to the first identification and second business object data corresponding to the second identification from the database;
and the recording submodule is suitable for recording the first service object data and the second service object data as associated data.
in a preferred embodiment of the present invention, the first business object data includes first characteristic value data and second characteristic value data, and the second business object data includes third characteristic value data and fourth characteristic value data; the recording sub-module includes:
a first judgment unit configured to judge whether the first characteristic value data is greater than or equal to the third characteristic value data; if the first characteristic value data is greater than or equal to the third characteristic value data, calling a first processing unit, if the first characteristic value data is less than the third characteristic value data, calling a fourth processing unit,
a first processing unit configured to take the first feature value data as first result data;
A first calculation unit configured to calculate a difference value between the first result data and the third feature value data;
a second processing unit for taking the difference value as second result data;
a third processing unit configured to take the third feature value data as third result data;
a fourth processing unit configured to take the first feature value data as first result data;
A fifth processing unit, configured to take a preset value as first result data;
A sixth processing unit configured to take the third feature value data as third result data;
and the first recording unit is used for recording the first result data, the second result data and the third result data as the associated data.
in a preferred embodiment of the present invention, if the first characteristic value data is smaller than the third characteristic value data, the recording sub-module further includes:
A second calculation unit configured to calculate a difference value between the third characteristic value data and the first characteristic value data;
a seventh processing unit for taking the difference value as fourth result data.
in a preferred embodiment of the present invention, the recording sub-module may further include:
a second determination unit configured to determine whether the second characteristic value data is greater than or equal to the fourth characteristic value data; if the second characteristic value data is greater than or equal to the fourth characteristic value data, calling an eighth processing unit, and if the second characteristic value data is less than the fourth characteristic value data, calling a third judging unit;
an eighth processing unit configured to take the second result data as first result data;
a third calculation unit configured to calculate a difference between the first result data and fourth feature value data;
a ninth processing unit configured to take the difference value as second result data;
a tenth processing unit configured to take the fourth feature value data as third result data;
a fourth calculation unit configured to calculate a difference value between the fourth feature value data and the third result data;
an eleventh processing unit configured to take the difference value as fourth result data;
a third judging unit, configured to judge whether the fourth result data is less than or equal to a preset value; if the fourth result data is less than or equal to the preset value, a fourth judgment unit is called,
a fourth judging unit, configured to judge whether the second result data is a preset value; if the second result data is a preset numerical value, calling a twelfth processing unit, and if the second result data is not the preset numerical value, calling a thirteenth processing unit;
A twelfth processing unit configured to take the second characteristic value data as first result data;
a thirteenth processing unit configured to take the second result data as first result data;
a fourteenth processing unit, configured to take the preset value as second result data;
a fifteenth processing unit configured to take the first result data as third result data;
A sixteenth processing unit, configured to take the second feature value data as first result data if the fourth result data is greater than a preset numerical value;
a fifth judging unit operable to judge whether the second characteristic value data is greater than or equal to fourth result data; if the second characteristic value data is greater than or equal to fourth result data, calling a fifth calculating unit, and if the second characteristic value data is less than the fourth result data, calling an eighteenth processing unit;
A fifth calculation unit configured to calculate a difference value between the second feature value data and the fourth result data;
A seventeenth processing unit configured to take the difference as second result data;
an eighteenth processing unit configured to take the preset numerical value as second result data;
a nineteenth processing unit configured to take the first result data as third result data;
and the second recording unit is used for recording the first result data, the second result data and the third result data as associated data.
a writing module 304 adapted to write the associated data into an associated data table;
A presentation module 305 adapted to provide a presentation of the associated data table.
In a preferred embodiment of the present invention, the apparatus may further include the following modules:
and the emptying module is suitable for emptying the database.
in a preferred embodiment of the present invention, the first service object data and the second service object data have a first status identifier, and may further include the following modules:
and the modification module is suitable for modifying the first state identifier of the first service object data and the second state identifier of the second service object data into a second state identifier.
in a preferred embodiment of the present invention, the first service object data may be charging data, the first service object data is charging data, and the second service object data is consumption data; the first identification and the second identification are user identifications; the first characteristic value data and the second characteristic value data are recharging amount, and the third characteristic value data and the fourth characteristic value data are consumption amount; the first state flag is 0, and the second state flag is 1; the first result data is a last recharging balance, the second result data is a current balance, the third result data is a consumption balance, the fourth result data is a residual consumption balance, and the preset value is 0.
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
the embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
as will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
these computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
these computer program instructions may also be loaded onto a computer or other programmable data processing terminal to cause a series of operational steps to be performed on the computer or other programmable terminal to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal provide steps adapted for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
while preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.
the method for displaying the associated data table and the device for displaying the associated data table provided by the invention are described in detail, and a specific example is applied in the text to explain the principle and the implementation mode of the invention, and the description of the embodiment is only suitable for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (16)
1. A display method of an associated data table is characterized by comprising the following steps:
acquiring first service object data and second service object data; the first business object data has one or more first identifications, the second business object data has one or more second identifications, the first business object data is recharging data, and the second business object data is consumption data;
storing the first service object data and the second service object data into a database;
extracting first service object data and second service object data with the first identification and the second identification consistent from the database, and generating associated data of the first service object data and the second service object data based on the first identification or the second identification;
writing the associated data into an associated data table;
and providing the display of the associated data table.
2. the method of claim 1, further comprising, before the step of obtaining the first business object data and the second business object data:
the database is emptied.
3. The method of claim 1, wherein the step of extracting the first business object data and the second business object data with the first identifier and the second identifier consistent from the database and generating the associated data of the first business object data and the second business object data based on the first identifier or the second identifier comprises:
judging whether a second identifier consistent with the first identifier exists or not;
if yes, extracting first business object data corresponding to the first identification and second business object data corresponding to the second identification from the database;
And recording the first service object data and the second service object data as associated data.
4. the method according to claim 3, characterized in that the first business object data includes first characteristic value data and second characteristic value data, and the second business object data includes third characteristic value data and fourth characteristic value data; the step of recording the first service object data and the second service object data as associated data includes:
judging whether the first characteristic value data is larger than or equal to the third characteristic value data;
If the first characteristic value data is greater than or equal to the third characteristic value data, taking the first characteristic value data as first result data;
calculating a difference between the first result data and the third feature value data;
taking the difference value as second result data;
taking the third characteristic value data as third result data;
if the first characteristic value data is smaller than the third characteristic value data, taking the first characteristic value data as first result data;
taking a preset numerical value as second result data;
taking the first characteristic value data as third result data;
And recording the first result data, the second result data and the third result data as associated data.
5. the method of claim 4, wherein if the first characteristic value data is smaller than the third characteristic value data, the step of recording the first service object data and the second service object data as associated data further comprises:
calculating a difference value between the third characteristic value data and the first characteristic value data;
The difference is taken as fourth result data.
6. the method of claim 5, wherein the step of recording the first business object data and the second business object data as associated data further comprises:
Judging whether the second characteristic value data is greater than or equal to the fourth characteristic value data; if the second characteristic value data is greater than or equal to the fourth characteristic value data, the second result data is used as first result data;
calculating a difference between the first result data and fourth characteristic value data;
Taking the difference value as second result data;
taking the fourth characteristic value data as third result data;
calculating a difference between the fourth characteristic value data and the third result data;
taking the difference value as fourth result data;
If the second characteristic value data is smaller than the fourth characteristic value data, judging whether the fourth result data is smaller than or equal to a preset value;
if the fourth result data is less than or equal to a preset value, judging whether the second result data is the preset value; if the second result data is a preset numerical value, taking the second characteristic value data as first result data;
if the second result data is not a preset value, taking the second result data as first result data;
taking a preset numerical value as second result data;
taking the first result data as third result data;
If the fourth result data is larger than a preset value, taking the second characteristic value data as first result data;
judging whether the second characteristic value data is larger than or equal to fourth result data or not;
if the second characteristic value data is greater than or equal to fourth result data, calculating a difference value between the second characteristic value data and the fourth result data;
taking the difference value as second result data;
if the second characteristic value data is smaller than fourth result data, taking a preset numerical value as second result data;
taking the first result data as third result data;
and recording the first result data, the second result data and the third result data as associated data.
7. The method of claim 1, wherein the first business object data and the second business object data have a first status identifier, and wherein after the step of extracting the first business object data and the second business object data with the first identifier consistent with the second identifier from the database and generating the association data of the first business object data and the second business object data based on the first identifier or the second identifier, the method further comprises:
And updating the first state identifier of the first service object data and the second service object data to be a second state identifier.
8. the method of claim 1, 2, 3, 4, 5, 6 or 7, wherein the first identifier and the second identifier are user identifiers; the first characteristic value data and the second characteristic value data are recharging amount, and the third characteristic value data and the fourth characteristic value data are consumption amount; the first state flag is 0, and the second state flag is 1; the first result data is a last recharging balance, the second result data is a current balance, the third result data is a consumption balance, the fourth result data is a residual consumption balance, and the preset value is 0.
9. a presentation apparatus for associated data tables, comprising:
the acquisition module is suitable for acquiring first business object data and second business object data; the first business object data has one or more first identifications, the second business object data has one or more second identifications, the first business object data is recharging data, and the second business object data is consumption data;
the storage module is suitable for storing the first business object data and the second business object data into a database;
The generating module is suitable for extracting first service object data and second service object data with first identifications and second identifications consistent from the database and generating associated data of the first service object data and the second service object data based on the first identifications or the second identifications;
The writing module is suitable for writing the associated data into an associated data table;
and the display module is suitable for providing display of the associated data table.
10. the apparatus of claim 9, further comprising:
And the emptying module is suitable for emptying the database.
11. the apparatus of claim 9, wherein the generating module comprises:
the judgment submodule is suitable for judging whether a second identifier consistent with the first identifier exists or not; if so, then
the extraction submodule is suitable for extracting first business object data corresponding to the first identification and second business object data corresponding to the second identification from the database;
And the recording submodule is suitable for recording the first service object data and the second service object data as associated data.
12. The apparatus according to claim 11, wherein the first business object data includes first characteristic value data and second characteristic value data, and the second business object data includes third characteristic value data and fourth characteristic value data; the recording sub-module includes:
a first judgment unit configured to judge whether the first characteristic value data is greater than or equal to the third characteristic value data; if the first characteristic value data is greater than or equal to the third characteristic value data, calling a first processing unit, if the first characteristic value data is less than the third characteristic value data, calling a fourth processing unit,
A first processing unit configured to take the first feature value data as first result data;
a first calculation unit configured to calculate a difference value between the first result data and the third feature value data;
A second processing unit for taking the difference value as second result data;
a third processing unit configured to take the third feature value data as third result data;
A fourth processing unit configured to take the first feature value data as first result data;
a fifth processing unit, configured to preset a numerical value as second result data;
a sixth processing unit configured to take the first feature value data as third result data;
and the first recording unit is used for recording the first result data, the second result data and the third result data as the associated data.
13. The apparatus of claim 12, wherein if the first characteristic value data is less than the third characteristic value data, the recording submodule further comprises:
a second calculation unit configured to calculate a difference value between the third characteristic value data and the first characteristic value data;
a seventh processing unit for taking the difference value as fourth result data.
14. the apparatus of claim 13, wherein the logging sub-module further comprises:
a second determination unit configured to determine whether the second characteristic value data is greater than or equal to the fourth characteristic value data; if the second characteristic value data is greater than or equal to the fourth characteristic value data, calling an eighth processing unit, and if the second characteristic value data is less than the fourth characteristic value data, calling a third judging unit;
An eighth processing unit configured to take the second result data as first result data;
a third calculation unit configured to calculate a difference between the first result data and fourth feature value data;
a ninth processing unit configured to take the difference value as second result data;
a tenth processing unit configured to take the fourth feature value data as third result data;
A fourth calculation unit configured to calculate a difference value between the fourth feature value data and the third result data;
An eleventh processing unit configured to take the difference value as fourth result data;
a third judging unit, configured to judge whether the fourth result data is less than or equal to a preset value; if the fourth result data is less than or equal to the preset value, a fourth judgment unit is called,
a fourth judging unit, configured to judge whether the second result data is a preset value; if the second result data is a preset numerical value, calling a twelfth processing unit, and if the second result data is not the preset numerical value, calling a thirteenth processing unit;
a twelfth processing unit configured to take the second characteristic value data as first result data;
a thirteenth processing unit configured to take the second result data as first result data;
a fourteenth processing unit, configured to take the preset value as second result data;
a fifteenth processing unit configured to take the first result data as third result data;
a sixteenth processing unit, configured to take the second feature value data as first result data if the fourth result data is greater than a preset numerical value;
a fifth judging unit operable to judge whether the second characteristic value data is greater than or equal to fourth result data; if the second characteristic value data is greater than or equal to fourth result data, calling a fifth calculating unit, and if the second characteristic value data is less than the fourth result data, calling an eighteenth processing unit;
a fifth calculation unit configured to calculate a difference value between the second feature value data and the fourth result data;
a seventeenth processing unit configured to take the difference as second result data;
An eighteenth processing unit configured to take the preset numerical value as second result data;
a nineteenth processing unit configured to take the first result data as third result data;
and the second recording unit is used for recording the first result data, the second result data and the third result data as associated data.
15. the apparatus of claim 9, wherein the first business object data and the second business object data have a first status identification, further comprising:
and the modification module is suitable for modifying the first state identifier of the first service object data and the second state identifier of the second service object data into a second state identifier.
16. the apparatus according to claim 9, 10, 11, 12, 13, 14 or 15, wherein the first identifier and the second identifier are user identifiers; the first characteristic value data and the second characteristic value data are recharging amount, and the third characteristic value data and the fourth characteristic value data are consumption amount; the first state flag is 0, and the second state flag is 1; the first result data is a last recharging balance, the second result data is a current balance, the third result data is a consumption balance, the fourth result data is a residual consumption balance, and the preset value is 0.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410380352.4A CN105468592B (en) | 2014-08-04 | 2014-08-04 | display method and device of associated data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410380352.4A CN105468592B (en) | 2014-08-04 | 2014-08-04 | display method and device of associated data table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105468592A CN105468592A (en) | 2016-04-06 |
| CN105468592B true CN105468592B (en) | 2019-12-13 |
Family
ID=55606306
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410380352.4A Active CN105468592B (en) | 2014-08-04 | 2014-08-04 | display method and device of associated data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105468592B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874322A (en) * | 2016-06-27 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of data table correlation method and device |
| CN109543073A (en) * | 2018-10-17 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Enterprise's supply and marketing relation map generation method, device and computer equipment |
| CN110069562B (en) * | 2019-04-23 | 2020-07-03 | 北京金堤科技有限公司 | Data display method and device, storage medium and computer equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101515234A (en) * | 2009-03-26 | 2009-08-26 | 华亚微电子（上海）有限公司 | Associated data processing method and associated data device |
| CN101661510A (en) * | 2009-09-29 | 2010-03-03 | 金蝶软件（中国）有限公司 | Data matching method and device thereof |
| CN103020227A (en) * | 2012-12-13 | 2013-04-03 | 中国银行股份有限公司 | Data processing method and system in computer equipment |
| CN103646342A (en) * | 2013-12-18 | 2014-03-19 | 北京博雅立方科技有限公司 | Search engine consumption data and return data registration method and platform |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100145885A1 (en) * | 2008-12-05 | 2010-06-10 | Lava Four, Llc | System for on-board metering of recharging energy consumption in vehicles equipped with electrically powered propulsion systems |
-
2014
- 2014-08-04 CN CN201410380352.4A patent/CN105468592B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101515234A (en) * | 2009-03-26 | 2009-08-26 | 华亚微电子（上海）有限公司 | Associated data processing method and associated data device |
| CN101661510A (en) * | 2009-09-29 | 2010-03-03 | 金蝶软件（中国）有限公司 | Data matching method and device thereof |
| CN103020227A (en) * | 2012-12-13 | 2013-04-03 | 中国银行股份有限公司 | Data processing method and system in computer equipment |
| CN103646342A (en) * | 2013-12-18 | 2014-03-19 | 北京博雅立方科技有限公司 | Search engine consumption data and return data registration method and platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105468592A (en) | 2016-04-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106648690B (en) | Automatic code generation method and device | |
| CN108256996B (en) | Two-part form splitting method and system for credit repayment service | |
| CN107292493B (en) | Account checking system and method between power enterprise and bank | |
| WO2019080662A1 (en) | Information recommendation method, device and apparatus | |
| RU2014127000A (en) | SYSTEM AND METHOD FOR SUBMITTING A LOAN REPORT WITH THE POSSIBILITY OF SETTING | |
| CN110233741B (en) | Service charging method, device, equipment and storage medium | |
| CN105574041B (en) | Data recombination method and device | |
| TW202008251A (en) | Payment instrument recommendation method and apparatus, device, and computer readable storage medium | |
| CN105468592B (en) | display method and device of associated data table | |
| CN109118288A (en) | Target user's acquisition methods and device based on big data analysis | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN102738871A (en) | Charging treatment method and system for mobile device | |
| CN109697231A (en) | A kind of display methods, system, storage medium and the processor of case document | |
| CN111190682B (en) | Reminding item display method and device | |
| CN113807066A (en) | Chart generation method and device and electronic equipment | |
| EP3723030A1 (en) | Technical fee automatic calculation system, technical fee automatic calculation method, and program | |
| CN106096957A (en) | The update method of service attribute value and system | |
| CN112286879B (en) | Metadata-based data asset construction method and device | |
| CN106155754B (en) | Display template processing method and device | |
| EP3048568A1 (en) | Method, server and system for estimating patent prosecution related activity | |
| WO2016131230A1 (en) | Event information processing method and device | |
| CN111950996A (en) | Accounting processing method, device, equipment and medium | |
| CN114546553B (en) | Information display method, device, equipment and medium | |
| CN114863463A (en) | Intelligent auditing and checking method and device for same text | |
| CN112948441A (en) | Financial data-oriented multidimensional data aggregation method and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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: 20220715 Address after: Room 801, 8th floor, No. 104, floors 1-19, building 2, yard 6, Jiuxianqiao Road, Chaoyang District, Beijing 100015 Patentee after: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Address before: 100088 room 112, block D, 28 new street, new street, Xicheng District, Beijing (Desheng Park) Patentee before: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Patentee before: Qizhi software (Beijing) Co.,Ltd. |