CN113515332B

CN113515332B - Data generation method, device, equipment and storage medium

Info

Publication number: CN113515332B
Application number: CN202110437155.1A
Authority: CN
Inventors: 荣雪松
Original assignee: Beijing Jingdong Zhenshi Information Technology Co Ltd
Current assignee: Beijing Jingdong Zhenshi Information Technology Co Ltd
Priority date: 2021-04-22
Filing date: 2021-04-22
Publication date: 2023-09-05
Anticipated expiration: 2041-04-22
Also published as: CN113515332A

Abstract

The embodiment of the invention discloses a data generation method, a device, equipment and a storage medium. The method comprises the following steps: when receiving a user code input by a user, determining a calculation field corresponding to the user code, and displaying the calculation field on an interactive interface; acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing the user code and the target calculation field in a template user table; when a preset calculation generation condition is met, determining a calculation field value corresponding to a target calculation field based on the target calculation field and service data corresponding to the user code in the template user table; and generating calculation data corresponding to the user code based on the target calculation field and the calculation field value. The embodiment of the invention solves the problem that the statement template needs to be developed for many times, and reduces the development difficulty and the use complexity of the statement platform system.

Description

Data generation method, device, equipment and storage medium

Technical Field

The embodiment of the invention relates to the technical field of data processing, in particular to a data generation method, a device, equipment and a storage medium.

Background

With the development of science and technology, settlement traffic is increasing. The account checking is an important measure for preventing errors of internal and external accounts and ensuring accurate and real accounts. Statement is a statement of statement that a user can obtain account information and determine the accuracy of an account by checking and checking the statement provided by the settlement platform.

In the process of realizing the invention, the prior art is found to have at least the following technical problems:

existing statement templates are generated based on pre-configured statement fields, i.e., each statement template has its own and fixed statement field. Merchants cannot configure statement templates meeting own business requirements according to own requirements, so that developers need to develop as many statement templates as possible according to various business requirements, and development difficulty and use complexity of the statement platform system are increased.

Disclosure of Invention

The embodiment of the invention provides a data generation method, a device, equipment and a storage medium, which are used for reducing the development difficulty and the use complexity of a reconciliation platform system.

In a first aspect, an embodiment of the present invention provides a data generating method, including:

When receiving a user code input by a user, determining a calculation field corresponding to the user code, and displaying the calculation field on an interactive interface;

acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing the user code and the target calculation field in a template user table;

when a preset calculation generation condition is met, determining a calculation field value corresponding to a target calculation field based on the target calculation field and service data corresponding to the user code in the template user table; wherein, the business data comprises at least one calculation field and calculation field values corresponding to the calculation fields respectively;

and generating calculation data corresponding to the user code based on the target calculation field and the calculation field value.

In a second aspect, an embodiment of the present invention further provides a data generating apparatus, where the apparatus includes:

the computing field display module is used for determining a computing field corresponding to the user code when receiving the user code input by the user and displaying the computing field on the interactive interface;

the target calculation field storage module is used for acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing the user code and the target calculation field in a template user table;

The calculation field value acquisition module is used for determining a calculation field value corresponding to the target calculation field based on the target calculation field and service data corresponding to the user code in the template user table when a preset calculation generation condition is met; wherein, the business data comprises at least one calculation field and calculation field values corresponding to the calculation fields respectively;

and the calculation data generation module is used for generating calculation data corresponding to the user code based on the target calculation field and the calculation field value.

In a third aspect, an embodiment of the present invention further provides an electronic device, including:

one or more processors;

a memory for storing one or more programs;

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the data generation method of any of the above-referenced figures.

In a fourth aspect, embodiments of the present invention also provide a storage medium containing computer executable instructions which, when executed by a computer processor, are used to perform any of the data generation methods referred to above.

The embodiments of the above invention have the following advantages or benefits:

according to the embodiment of the invention, the calculation fields are displayed on the interactive interface, and the user codes input by the user and the target calculation fields are stored in the template user table. When the preset calculation generation condition is met, a calculation field value corresponding to the target calculation field is determined based on the template user table and the service data, and calculation data is generated based on the target calculation field and the calculation field value, so that the problem that a developer needs to repeatedly develop a statement template according to the service requirement is solved, and the development difficulty and the use complexity of the statement platform system are reduced. Meanwhile, the embodiment of the invention enables the user to carry out custom setting on the statement template on the interactive interface, improves the flexibility of the generated calculation data and increases the applicable scene of the statement platform system.

Drawings

FIG. 1 is a flowchart of a data generating method according to a first embodiment of the present invention;

FIG. 2A is a schematic diagram of an interactive interface according to a first embodiment of the present invention;

FIG. 2B is a diagram of a calculation data provided in accordance with an embodiment of the present invention;

fig. 3 is a flowchart of a data generating method according to a second embodiment of the present invention;

FIG. 4 is a flowchart of a method for querying a computed field value according to a second embodiment of the present invention;

fig. 5 is a schematic diagram of a data generating method according to a third embodiment of the present invention;

FIG. 6 is a schematic diagram of a system framework for data generation according to a third embodiment of the present invention;

fig. 7 is a schematic diagram of a data generating device according to a fourth embodiment of the present invention;

fig. 8 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention.

Detailed Description

The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.

Example 1

Fig. 1 is a flowchart of a data generating method according to a first embodiment of the present invention, where the method may be applied to the case of generating statement data, and the method may be performed by a data generating device, where the device may be implemented in software and/or hardware, and the device may be configured in a terminal device, and the terminal device may be an intelligent terminal such as a mobile terminal, a notebook computer, a desktop computer, a server, and a tablet computer.

The method specifically comprises the following steps:

and S110, when receiving the user code input by the user, determining a calculation field corresponding to the user code, and displaying the calculation field on the interactive interface.

In one example, a user code may be used to identify a current user for subsequent lookup of a target computing field corresponding to the current user based on the user code.

The calculation field may be, for example, a user name, a user contact, a user mailbox, a settlement amount, a calculation subject, a settlement date, an amount due, a fee type, and the like. The specific setting content of the calculation field is not limited herein, and may be set according to actual requirements.

Wherein, exemplary, according to the mapping relation of the preset user field, the calculation field corresponding to the user code is determined. The preset user field mapping relationship is used for representing the mapping relationship between the user code and the calculation field, and the user code can correspond to at least one calculation field.

In one embodiment, optionally, determining a computation field corresponding to the user code includes: acquiring at least one subject template corresponding to the user code, and displaying each subject template on an interactive interface; when detecting a target subject template selected and input by a user, determining a calculation field corresponding to the target subject template based on a preset field subject table; the preset field subject table comprises at least one subject template and calculation fields respectively corresponding to the subject templates.

The method comprises the steps of obtaining at least one subject template corresponding to a user code according to a preset user subject mapping relation. The preset user subject mapping relation is used for representing the mapping relation between the user code and the subject templates, and the user code can correspond to at least one subject template.

Wherein, the subject template is a basic standard template set for different business requirements, and exemplary subject templates include, but are not limited to, standard large-piece templates, standard small-piece templates, standard three-party templates, standard warehouse templates, standard loading and unloading templates, standard distribution templates and the like.

Wherein, the calculation fields corresponding to different order templates are different. Illustratively, the calculation fields corresponding to the standard delivery templates include delivery order numbers, delivery times, delivery destinations, and the like, and the calculation fields corresponding to the standard delivery templates include delivery vehicle types, delivery objects, delivery stores, and the like.

The method has the advantages that the calculation fields corresponding to the user codes are further divided based on the subject templates, the number of the displayed calculation fields is reduced, the user can select the calculation fields in a targeted mode, the operation complexity is reduced, and the efficiency of selecting and inputting the target calculation fields by the user is improved.

S120, acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing the user code and the target calculation field in a template user table.

On the basis of the above embodiment, optionally, storing the user code and the target calculation field in the template user table correspondingly includes: the user code, the target calculation field and the target subject template are correspondingly stored in a template user table. Specifically, a user code, a target subject template corresponding to the user code and a target calculation field corresponding to the target subject template are stored in a template user table.

On the basis of the above embodiment, optionally, the type of the calculation field includes a fixed field and an optional field. The fixed fields are fields which are displayed on the interactive interface and can not be selected and input by a user, and the selectable fields are fields which are displayed on the interactive interface and can be selected and input by the user. Illustratively, the fixed fields may include merchant numbers, purchase order numbers, and document types, etc., and the optional fields may include contract numbers, buyer names, and quotation patterns, etc.

Specifically, the obtaining the target calculation field selected and input by the user based on the calculation field includes: the fixed field is used as a first target calculation field, and a second target calculation field which is input by a user based on the calculation field selection of the selectable fields is acquired. Correspondingly, the template user table stores a user code, a first target calculation field and a second target calculation field corresponding to the user code.

The advantage of this arrangement is that the accuracy and integrity of the subsequently generated calculation data is ensured while the user operation steps are reduced.

Fig. 2A is a schematic diagram of an interactive interface according to an embodiment of the present invention. Specifically, the user may input the user code through an input box behind the "user code" on the interactive interface, and after the user inputs the user code, the user clicks an input box behind the "subject template" to display at least one subject template corresponding to the user code. Fig. 2A shows the subject templates in a drop-down manner, but it is also possible to directly display at least one subject template on the interactive interface. The specific manner of presentation of the subject templates is not limited herein. After the user selects and inputs the target subject template, based on the preset field subject table, the fixed field and the optional field corresponding to the target subject template are respectively displayed in the selected field and the optional field of the interactive interface, and in this embodiment, the field displayed in the selected field is defaulted to be the target calculation field.

And S130, when the preset calculation generation condition is met, determining a calculation field value corresponding to the target calculation field based on the target calculation field and service data corresponding to the user code in the template user table.

In one embodiment, optionally, the preset calculation generation condition includes after generating the service data based on the preset statistical time or when a calculation instruction input by the user is received. The preset statistical time may be, for example, the month beginning of each month, such as 4 months 1 day, 5 months 1 day, 6 months 1 day, etc., or the preset statistical period, such as 7 days or 30 days. The preset statistical time is not limited herein, and may be set according to actual requirements.

In this embodiment, the service data includes at least one calculation field and calculation field values corresponding to the calculation fields, respectively. Wherein, specifically, the type of the calculation field includes a statistics field, such as the calculation field is settlement amount, sales amount, profit, and the like. Specifically, service data is queried based on a target calculation field to obtain a calculation field value corresponding to the target calculation field. Illustratively, when the target calculation field is a business date, the corresponding calculation field value is 2020, 1, 2, and when the target calculation field is sales, the corresponding calculation field value is 100 yuan.

And S140, generating calculation data corresponding to the user code based on the target calculation field and the calculation field value.

Wherein, illustratively, based on the goal templates, the goal calculation fields, and the calculation field values, calculation data corresponding to the user codes is generated. Specifically, the target calculation field and the calculation field value are added to the target subject template to obtain calculation data corresponding to the user code.

The data format of the calculation data may be, for example, an statement format. Fig. 2B is a schematic diagram of calculation data according to an embodiment of the invention. Specifically, "subject template a" indicates the name of the target subject template selected and input by the user, "customer name", "order number", "commodity price", "commodity number", "user code", "fee type", and "settlement amount" indicate target calculation fields, "a company", "xxxxxxxx", "10-element", "10", "aaaaaaaaa", "general billing", and "100-element" indicate calculation field values corresponding to the above target calculation fields, respectively.

It should be noted that fig. 2B is an exemplary illustration of a pattern of the calculation data, and is not limited thereto, and a specific pattern of the calculation data may be set according to actual requirements.

According to the technical scheme, the calculation fields are displayed on the interactive interface, and the user codes and the target calculation fields input by the user are stored in the template user table. When the preset calculation generation condition is met, a calculation field value corresponding to the target calculation field is determined based on the template user table and the service data, and calculation data is generated based on the target calculation field and the calculation field value, so that the problem that a developer needs to repeatedly develop a statement template according to the service requirement is solved, and the development difficulty and the use complexity of the statement platform system are reduced. Meanwhile, the embodiment of the invention enables the user to carry out custom setting on the statement template on the interactive interface, improves the flexibility of the generated calculation data and increases the applicable scene of the statement platform system.

Example two

Fig. 3 is a flowchart of a data generating method according to a second embodiment of the present invention, and the technical solution of this embodiment is further refinement based on the foregoing embodiment. Optionally, the determining, based on the target calculation field and the service data corresponding to the user code in the template user table, a calculation field value corresponding to the target calculation field includes: determining a data source corresponding to the target subject template based on the target subject template corresponding to the user code and a preset template table, and acquiring business data corresponding to the target subject template based on the data source; the preset template table comprises at least one subject template and data sources respectively corresponding to the subject templates; determining a field source corresponding to the target calculation field based on the target calculation field and a preset field table; the preset field table is used for representing the association relation between the calculated field and the field source; and determining a calculated field value corresponding to the target calculated field based on the field source and the service data.

The specific implementation steps of the embodiment include:

And S210, when receiving the user code input by the user, determining a calculation field corresponding to the user code, and displaying the calculation field on the interactive interface.

S220, acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing the user code and the target calculation field in a template user table.

And S230, when the preset calculation generation condition is met, determining a data source corresponding to the target subject template based on the target subject template corresponding to the user code and a preset template table, and acquiring service data corresponding to the target subject template based on the data source.

In this embodiment, the preset template table includes at least one subject template and data sources respectively corresponding to the subject templates. Wherein, in particular, the data source may be used to describe a storage location of the business data. In practical applications, different service data may be stored in different service systems due to the large data size of the service data and different specific service requirements corresponding to the service data. Illustratively, the data sources may be used to describe a business system of a business data store corresponding to the subject template. And storing the mapping relation between the subject template and the data source in a preset template table, so that the subsequent inquiry of the data source is facilitated.

S240, determining a field source corresponding to the target calculation field based on the target calculation field and a preset field table.

In this embodiment, the preset field table is used to characterize the association relationship between the calculated field and the field source. Wherein, the field source can be used for describing the storage position of the calculated field value corresponding to the calculated field in the service data. By way of example, the field source may be "transAccount. SellerNo," where "transAccount" represents the data name of the business data and "sellerNo" represents the specific table location in the business data where the user code is stored.

In one embodiment, optionally, the preset field table includes a user field table, and accordingly, determining a field source corresponding to the target calculation field based on the target calculation field and the preset field table includes: if the user code is matched with the preset user code corresponding to the user field table, determining a field source corresponding to the target calculation field in the user field table based on the user code and the target calculation field; the user field table comprises at least one preset user code, calculation fields respectively corresponding to the preset user codes and field sources respectively corresponding to the calculation fields.

Specifically, the user field table is a field table in which a developer performs division setting on the calculation field in advance based on the user coding dimension. In practical applications, it may be necessary to set in advance a calculation field corresponding to a different user. If the user belongs to the food class merchant, the user field table sets the calculation field related to the food class in advance according to the user code of the user, and if the user belongs to the clothing class merchant, the user field table sets the calculation field related to the food class in advance according to the user code of the user.

Specifically, the preset user code is a preset user code stored in a user field table. And matching the user code with a preset user code corresponding to the user field table, and if the matching is successful, indicating that a calculation field corresponding to the user code is preset in the user field table, and inquiring in the user field table based on the user code and the target calculation field to obtain a field source corresponding to the target calculation field.

The advantage of this arrangement is that, because of the great variety of service requirements, the number of preset calculation fields is great, and if the field source corresponding to the target calculation field is directly searched in the preset field table containing massive data, the data volume of the query can be greatly increased and the query efficiency can be reduced. According to the embodiment, the user field table is set by dividing the calculation field based on the user dimension, so that the data volume of query can be effectively reduced, and the query efficiency can be improved.

In one embodiment, optionally, the preset field table includes a subject field table, and accordingly, determining a field source corresponding to the target calculation field based on the target calculation field and the preset field table includes: if the target subject template is matched with a preset subject template corresponding to the subject field table, determining a field source corresponding to a target calculation field in the subject field table based on the target subject template and the target calculation field; the subject field table comprises at least one preset subject template, calculation fields respectively corresponding to the preset subject templates and field sources respectively corresponding to the calculation fields.

The subject field table is a field table in which a developer divides and sets calculation fields in advance based on dimensions of the subject template. In practical application, different subject templates correspond to different calculation fields, for example, calculation fields corresponding to a standard delivery template comprise a delivery single number, a delivery time, a delivery destination and the like, and calculation fields corresponding to a standard loading and unloading template comprise a loading and unloading vehicle type, a loading and unloading object and a delivery warehouse and the like.

In one embodiment, optionally, for each subject template, statistics is performed on target calculation fields input by a user based on selection of optional fields under the subject template, and the optional fields with the selection frequency reaching a preset frequency threshold or the selection frequency ranking meeting the preset ranking number are added to the subject field table. The subject field table specifically comprises fixed fields and common optional fields corresponding to the subject template.

Specifically, the preset subject template is a preset subject template stored in a subject field table. Matching the subject template with a preset subject template corresponding to the subject field table, and if the matching is successful, explaining that a calculation field corresponding to the subject template is preset in the subject field table, and inquiring in the subject template based on the subject template and the target calculation field to obtain a field source corresponding to the target calculation field.

The method has the advantages that the method can effectively reduce the query data quantity of field sources and improve the query efficiency by dividing the calculated fields based on the dimension of the subject template to set the subject field table.

On the basis of the foregoing embodiment, optionally, the preset field table includes a user field table and a subject field table, and correspondingly, determining, based on the target calculation field and the preset field table, a field source corresponding to the target calculation field includes: if the user code is matched with the preset user code corresponding to the user field table, determining a field source corresponding to the target calculation field in the user field table based on the user code and the target calculation field; if the user code does not match the preset user code corresponding to the user field table, or if the field source corresponding to the target calculation field does not exist in the user field table, determining the field source corresponding to the target calculation field based on the target calculation field and the subject field table.

Specifically, the user code is matched with a preset user code corresponding to the user field table, and if the user code is successfully matched with the preset user code, the user field table is queried based on the user code and the target calculation field to obtain a field source. And if the matching is unsuccessful, matching the target subject template with a preset subject template corresponding to the subject field table. And if the matching is successful, inquiring the subject field table based on the target subject template and the target calculation field to obtain a field source.

Further, in the process of inquiring the user field table based on the user code and the target calculation fields to obtain field sources, when the number of the target calculation fields is at least one, judging whether field sources respectively corresponding to all the target calculation fields exist in the user fields, and if not, determining the field sources corresponding to the residual target calculation fields based on the residual target calculation fields and the subject field table. For example, the target calculation field corresponding to the user code includes a field a, a field B and a field C, and if no field source of the field C corresponding to the user code exists in the user field table, the field source is obtained by querying the field table based on the target subject template and the field C.

In this embodiment, the preset field table includes a user field table and a subject field table, and the matching order of the two field tables is preset. The user code dimension has a higher degree of association with the target computation field in the template user table relative to the subject template dimension, that is, the probability of querying the field source of the target computation field based on the user field table is higher. According to the method, the user field table is queried based on the user code and the target calculation field, and then the subject field table is queried based on the target subject template and the target calculation field, so that the query efficiency of the field source can be further improved.

In the foregoing embodiment, optionally, the preset field table further includes a base field table, and correspondingly, the method further includes: if the target subject template is not matched with the preset subject template corresponding to the subject field table, or a field source corresponding to the target calculation field does not exist in the subject field table, determining the field source corresponding to the target calculation field in the basic field table based on the target calculation field; the basic field table comprises at least one calculation field and field sources respectively corresponding to the calculation fields.

Specifically, the basic field table includes a huge number of calculation fields and field sources corresponding to the calculation fields respectively. When no data source corresponding to the target calculation field is queried based on the user field table and the subject field table, the basic field table is queried based on the target calculation field to obtain the field source corresponding to the target calculation field, so that the field source corresponding to each target calculation field can be queried.

Fig. 4 is a flowchart of a method for querying and calculating a field value according to a second embodiment of the present invention. Specifically, a preset template table is queried based on a target subject template to obtain a data source, and business data corresponding to the target subject template is obtained based on the data source. Inquiring a user field table based on the user code and the target calculation field to obtain a field source corresponding to the target calculation field, if the user code is not matched with the preset user code corresponding to the user field table, or if the user code does not have the field source corresponding to the target calculation field in the user field table, continuously inquiring the field table based on the target subject template and the target calculation field to obtain the field source corresponding to the target calculation field, and if the target subject template is not matched with the preset subject template corresponding to the field table, or if the field source corresponding to the target calculation field does not exist in the field table, continuously inquiring the basic field table based on the target calculation field to obtain the field source corresponding to the target calculation field. And acquiring a calculated field value corresponding to the target calculated field in the service data based on the field source.

S250, determining a calculated field value corresponding to the target calculated field based on the field source and the service data.

Specifically, service data is queried based on field sources, and calculated field values corresponding to target calculated fields of service data summary are obtained.

And S260, generating calculation data corresponding to the user code based on the target calculation field and the calculation field value.

According to the technical scheme, the preset template table for storing the association relation between the subject template and the data source and the preset field table for representing the association relation between the calculated field and the field source are preset, the data sources corresponding to different service data and the field sources corresponding to the calculated field values are preset, the problem of huge data volume in the data query process is solved, the service data corresponding to the subject template and the calculated field values corresponding to the target calculated field in the service data can be purposefully and directly obtained based on the obtained data sources and the obtained field sources, and the query efficiency of the calculated field values is improved, so that the generation efficiency of the calculated data is further improved.

Example III

Fig. 5 is a schematic diagram of a data generating method according to a third embodiment of the present invention, and the technical solution of this embodiment is further refinement based on the foregoing embodiment. Optionally, before storing the user code and the target calculation field in the template user table, the method further includes: acquiring field sequence codes corresponding to the target calculation fields; the field sequence codes comprise preset field sequence codes corresponding to target calculation fields in the preset field subject table, or user-defined field sequence codes input by a user on an interactive interface based on the target calculation fields; correspondingly, the storing the user code, the target calculation field and the target subject template in the template user table correspondingly includes: storing the user code, the target calculation field, the target subject template and the field sequence code in a template user table correspondingly; the generating, based on the target calculation field and the calculation field value, calculation data corresponding to the user code includes: and generating calculation data corresponding to the user code based on the target calculation field, the calculation field value and the field sequence code.

The specific implementation steps of the embodiment include:

and S310, when receiving the user code input by the user, determining a calculation field corresponding to the user code, and displaying the calculation field on the interactive interface.

S320, acquiring a target calculation field selected and input by a user based on the calculation field, and acquiring a field sequence code corresponding to the target calculation field.

Wherein, specifically, when the number of the target calculation fields is at least two, the field order code can be used to describe the arrangement order of each target calculation field in the finally generated calculation data.

In this embodiment, the field sequential code includes a preset field sequential code corresponding to the target calculation field in the preset field subject table, or a custom field sequential code input by the user on the interactive interface based on the target calculation field.

In one embodiment, the preset field subject table specifically includes at least one subject template, at least one calculation field corresponding to each subject template, and a field sequential code corresponding to each calculation field. If the preset field subject table includes a calculation field a and a calculation field B, the preset field sequential codes corresponding to the calculation field a and the calculation field B may be 1 and 2, respectively.

In another embodiment, specifically, after the user selects to input the target calculation fields on the interactive interface, the display sequence between the target calculation fields can be adjusted, and the adjusted display sequence is used as the custom field sequence code. For example, when the user sequentially selects the calculation field a, the calculation field B, and the calculation field C on the interactive interface, the default display order of the 3 calculation fields is the calculation field a, the calculation field B, and the calculation field C, and when the user adjusts the display order, it is assumed that the adjusted display order is the calculation field a, the calculation field C, and the calculation field B, and the custom field sequential codes corresponding to the calculation field a, the calculation field B, and the calculation field C are 1, 3, and 2, respectively.

S330, storing the user codes, the target calculation field, the target subject template and the field sequence codes in a template user table correspondingly.

The template user table comprises at least one user code, at least one target subject template corresponding to each user code, at least one target calculation field corresponding to each target subject template, and field sequence codes corresponding to each target calculation field.

And S340, when the preset calculation generation condition is met, determining a calculation field value corresponding to the target calculation field based on the target calculation field and service data corresponding to the user code in the template user table.

In one embodiment, a data source corresponding to the target subject template is determined based on the target subject template corresponding to the user code and a preset template table, service data corresponding to the target subject template is acquired based on the data source, a field source corresponding to the target calculation field is determined based on the target calculation field and the preset field table, and a calculation field value corresponding to the target calculation field is determined based on the field source and the service data.

On the basis of the above embodiment, optionally, determining, based on the field source and the service data, a calculated field value corresponding to the target calculated field includes: if the type of the field source belongs to the mapping class source, determining a calculated field value corresponding to the target calculated field in the service data based on the field mapping corresponding to the field source; the field mapping is used for representing and calculating the storage position of the field value in the service data; and if the type of the field source belongs to an interface class source or a translation class source, calling an interface corresponding to the interface class source to acquire a calculated field value corresponding to the target calculated field, or executing translation operation based on the translation class source to acquire the calculated field value corresponding to the target calculated field.

In one embodiment, in particular, if the type of field source belongs to a mapping class source, it is indicated that the calculated field value corresponding to the field source is derived from service data. The field source may be used to describe specific service data corresponding to the calculated field value, and the field map is used to describe a storage location of the calculated field value in the service data. Illustratively, when the target calculation field is a customer unit name, the field source of the calculation field value corresponding to the target calculation field is "service data a", and the field map is "extendstocmername", that is, the calculation field value corresponding to the customer unit name is taken from the extendstocmername location in service data a. Specifically, the field map may be stored in a preset field table corresponding to a field source of the map class source.

In another embodiment, specifically, if the type of the field source belongs to the interface class source, the calculated field value corresponding to the field source is directly obtained by calling the interface. In another embodiment, in particular, if the type of the field source belongs to a translation class source, it is indicated that the calculated field value corresponding to the field source may be obtained by performing a translation operation. Illustratively, the field source is "100+200", and the calculated field value is 300 after performing the translation operation on the field source.

S350, calculating the field value and field sequence coding based on the target, and generating calculation data corresponding to the user coding.

Specifically, a field sequential code corresponds to a display position in the calculated data. Illustratively, the display position is position A when the field order code is 1, position B when the field order code is 2, position C when the field order code is 3, and so on.

In one embodiment, if the field sequential code is a preset field sequential code corresponding to the target calculation field in the preset field subject table, since the preset field sequential code is preset, a situation may occur in which the field sequential code corresponding to the target calculation field is discontinuous. For example, the preset field sequential codes of the preset calculation field a, the calculation field B, and the calculation field C in the preset field subject table are 1, 2, and 3, respectively. When the target calculation input by the user based on the interactive interface selection only comprises a calculation field A and a calculation field C, the preset field sequential codes are respectively 1 and 3. If the calculation field is displayed according to the above example, a vacancy will occur in position B.

On the basis of the above embodiment, optionally, if the field sequential code in the template user table is a preset field sequential code corresponding to the target calculation field in the preset field subject table, recoding the preset field sequential code to obtain the adjusted field sequential code. Taking the above example as an example, the preset field sequential codes corresponding to the calculation field a and the calculation field C are 1 and 3, respectively, and the adjusted field sequential codes corresponding to the calculation field a and the calculation field C are 1 and 2, respectively. The advantage of this arrangement is that the occurrence of data vacancies in the calculated data generated when the preset field sequential encoding is discontinuous is avoided.

On the basis of the above embodiment, optionally, the method further includes: the calculation data and the calculation detail data corresponding to the calculation data are stored on a server; when a calculation query instruction input by a user is detected, acquiring a download address corresponding to calculation data and calculation detail data; and displaying the calculated data on the interactive interface, and sending the download address to a mailbox address corresponding to the user code in the form of mail.

Specifically, the calculation detail data may be used to describe detail data corresponding to a calculation field belonging to a statistical type in the calculation data. By way of example, the type of server may be a JSS server (Joint Shared Servers, federated share server).

The download address is specifically used for describing the storage address of the calculation detail data on the server. The downloading address is sent to the mailbox address corresponding to the user code through the mail, so that the advantage of the configuration is that the processing pressure of the billing platform system can be increased if the calculation detail data is directly displayed on the interactive interface because the data size of the calculation detail data is usually large. The problem that the mail cannot push the large file can be avoided by the mode of downloading the address sent by the mail, and the efficiency of acquiring the calculation detail data by the user is improved.

Fig. 6 is a schematic diagram of a system framework for data generation according to a third embodiment of the present invention. Specifically, the system framework includes pages, a control layer, a service layer, a task layer, and system interactions. The page framework is provided with a configuration bill field and a download bill file controlled by user input, and a maintenance field table controlled by a developer, wherein the bill file comprises calculation data and calculation detail data corresponding to the calculation data, and the field table comprises a preset field subject table, a preset template table, a user field table, a subject field table and a basic field table. The service layer provides a bill template configuration service, a bill field configuration service and a file downloading service, and the task layer is used for completing a bill generation task and a mail notification task, specifically, after the bill generation task is completed, the bill file is stored in the JSS server, and when a query instruction input by a user is received, a downloading address corresponding to the bill file in the JSS server is sent to the user in a mail mode. The log record is specifically an operation flow log of the billing platform system, and may record log information such as time of bill downloading, time of generating a bill file, and whether the bill file is successfully generated. The authority control means that the service provided in the service layer has the corresponding user access authority, and only the user satisfying the corresponding data authority can see the interactive interface or execute the related control operation.

According to the technical scheme, the field sequence codes corresponding to the target calculation fields are obtained, the user codes, the target calculation fields, the target subject templates and the field sequence codes are correspondingly stored in the template user table, and the calculation data corresponding to the user codes are generated based on the target calculation fields, the calculation field values and the field sequence codes, so that the problem of arrangement sequence of the target calculation fields in the calculation data is solved, and the normalization of the generated calculation data is improved.

Example IV

Fig. 7 is a schematic diagram of a data generating apparatus according to a fourth embodiment of the present invention. The embodiment may be applicable to the case of generating statement data, the apparatus may be implemented in software and/or hardware, and the apparatus may be configured in a terminal device. The data generation device includes: a calculation field presentation module 410, a target calculation field storage module 420, a calculation field value acquisition module 430, and a calculation data generation module 440.

The computing field display module 410 is configured to determine a computing field corresponding to a user code when receiving the user code input by the user, and display the computing field on the interactive interface;

The target calculation field storage module 420 is configured to obtain a target calculation field that is selectively input by a user based on the calculation field, and store a user code and the target calculation field in a template user table correspondingly;

a calculation field value obtaining module 430, configured to determine, when a preset calculation generation condition is satisfied, a calculation field value corresponding to a target calculation field based on the target calculation field and service data corresponding to the user code in the template user table; the service data comprises at least one calculation field and calculation field values corresponding to the calculation fields respectively;

the calculation data generation module 440 is configured to generate calculation data corresponding to the user code based on the target calculation field and the calculation field value.

Based on the above technical solution, optionally, the calculation field display module 410 is specifically configured to:

acquiring at least one subject template corresponding to the user code, and displaying each subject template on an interactive interface;

when detecting a target subject template selected and input by a user, determining a calculation field corresponding to the target subject template based on a preset field subject table; the preset field subject table comprises at least one subject template and calculation fields respectively corresponding to the subject templates;

the target calculation field storage module 420 is specifically configured to:

the user code, the target calculation field and the target subject template are correspondingly stored in a template user table.

Based on the above technical solution, optionally, the calculation field value obtaining module 430 includes:

the business data acquisition unit is used for determining a data source corresponding to the target subject template based on the target subject template corresponding to the user code and a preset template table and acquiring business data corresponding to the target subject template based on the data source; the preset template table comprises at least one subject template and data sources respectively corresponding to the subject templates;

a field source obtaining unit, configured to determine a field source corresponding to the target calculation field based on the target calculation field and a preset field table; the method comprises the steps that a preset field table is used for representing the association relation between a calculated field and a field source;

And a calculation field value determining unit for determining a calculation field value corresponding to the target calculation field based on the field source and the service data.

On the basis of the above technical solution, optionally, the preset field table includes a user field table, and the corresponding field source obtaining unit includes:

a first field source obtaining unit, configured to determine a field source corresponding to a target calculation field in the user field table based on the user code and the target calculation field if the user code matches a preset user code corresponding to the user field table; the user field table comprises at least one preset user code, calculation fields respectively corresponding to the preset user codes and field sources respectively corresponding to the calculation fields.

On the basis of the above technical solution, optionally, the preset field table includes a subject field table, and the corresponding field source obtaining unit includes:

a second field source obtaining unit, configured to determine, if the target subject template matches a preset subject template corresponding to the subject field table, a field source corresponding to the target calculation field in the subject field table based on the target subject template and the target calculation field; the subject field table comprises at least one preset subject template, calculation fields respectively corresponding to the preset subject templates and field sources respectively corresponding to the calculation fields.

On the basis of the above technical solution, optionally, the preset field table includes a user field table and a subject field table, and the corresponding field source obtaining unit is specifically configured to:

if the user code is matched with the preset user code corresponding to the user field table, determining a field source corresponding to the target calculation field in the user field table based on the user code and the target calculation field;

if the user code does not match the preset user code corresponding to the user field table, or if the field source corresponding to the target calculation field does not exist in the user field table, determining the field source corresponding to the target calculation field based on the target calculation field and the subject field table.

On the basis of the above technical solution, optionally, the preset field table further includes a base field table, and the corresponding field source obtaining unit is further configured to:

if the target subject template is not matched with the preset subject template corresponding to the subject field table, or a field source corresponding to the target calculation field does not exist in the subject field table, determining the field source corresponding to the target calculation field in the basic field table based on the target calculation field; the basic field table comprises at least one calculation field and field sources respectively corresponding to the calculation fields.

Based on the above technical solution, optionally, the calculation field value obtaining module 430 is specifically configured to:

if the type of the field source belongs to the mapping class source, determining a calculated field value corresponding to the target calculated field in the service data based on the field mapping corresponding to the field source; the field mapping is used for representing and calculating the storage position of the field value in the service data;

and if the type of the field source belongs to an interface class source or a translation class source, calling an interface corresponding to the interface class source to acquire a calculated field value corresponding to the target calculated field, or executing translation operation based on the translation class source to acquire the calculated field value corresponding to the target calculated field.

On the basis of the above technical solution, optionally, the apparatus further includes:

a field sequential code acquisition module for acquiring a field sequential code corresponding to a target calculation field before storing the user code and the target calculation field in the template user table; the field sequence codes comprise preset field sequence codes corresponding to the target calculation fields in a preset field subject table, or user-defined field sequence codes input by a user on the interactive interface based on the target calculation fields;

Accordingly, the target calculation field storage module 420 is specifically configured to: storing the user code, the target calculation field, the target subject template and the field sequence code in a template user table correspondingly;

accordingly, the calculation data generating module 440 is specifically configured to: based on the target calculation field, the calculation field value, and the field order code, calculation data corresponding to the user code is generated.

the computing data display module is used for storing the computing data and the computing detail data corresponding to the computing data on the server; when a calculation query instruction input by a user is detected, acquiring a download address corresponding to calculation data and calculation detail data; and displaying the calculated data on the interactive interface, and sending the download address to a mailbox address corresponding to the user code in the form of mail.

The data generation device provided by the embodiment of the invention can be used for executing the data generation method provided by the embodiment of the invention, and has the corresponding functions and beneficial effects of the execution method.

It should be noted that, in the embodiment of the data generating apparatus, each unit and module included are only divided according to the functional logic, but not limited to the above-mentioned division, so long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present invention.

Example five

Fig. 8 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention, where the embodiment of the present invention provides services for implementing the data generating method according to the foregoing embodiment of the present invention, and the data generating apparatus according to the foregoing embodiment may be configured. Fig. 8 illustrates a block diagram of an exemplary electronic device 12 suitable for use in implementing embodiments of the present invention. The electronic device 12 shown in fig. 8 is merely an example and should not be construed as limiting the functionality and scope of use of embodiments of the present invention.

As shown in fig. 8, the electronic device 12 is in the form of a general purpose computing device. Components of the electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, a bus 18 that connects the various system components, including the system memory 28 and the processing units 16.

Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, and a local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include Industry Standard Architecture (ISA) bus, micro channel architecture (MAC) bus, enhanced ISA bus, video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

Electronic device 12 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by electronic device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 30 and/or cache memory 32. The electronic device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from or write to non-removable, nonvolatile magnetic media (not shown in FIG. 8, commonly referred to as a "hard disk drive"). Although not shown in fig. 8, a magnetic disk drive for reading from and writing to a removable non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive for reading from or writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In such cases, each drive may be coupled to bus 18 through one or more data medium interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored in, for example, memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment. Program modules 42 generally perform the functions and/or methods of the embodiments described herein.

The electronic device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), one or more devices that enable a user to interact with the electronic device 12, and/or any devices (e.g., network card, modem, etc.) that enable the electronic device 12 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 22. Also, the electronic device 12 may communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network, such as the Internet, through a network adapter 20. As shown in fig. 8, the network adapter 20 communicates with other modules of the electronic device 12 over the bus 18. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with electronic device 12, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.

The processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, for example, implementing the data generation method provided by the embodiment of the present invention.

Through the electronic equipment, the problem that developers need to repeatedly develop statement templates according to business requirements is solved, and the development difficulty and the use complexity of the statement platform system are reduced. Meanwhile, the embodiment of the invention enables the user to carry out custom setting on the statement template on the interactive interface, improves the flexibility of the generated calculation data and increases the applicable scene of the statement platform system.

Example six

A sixth embodiment of the present invention also provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform a data generation method comprising:

acquiring a target calculation field selected and input by a user based on the calculation field, and correspondingly storing a user code and the target calculation field in a template user table;

When the preset calculation generation condition is met, determining a calculation field value corresponding to a target calculation field based on the target calculation field and service data corresponding to the user code in the template user table; the service data comprises at least one calculation field and calculation field values corresponding to the calculation fields respectively;

based on the target calculation field and the calculation field value, calculation data corresponding to the user code is generated.

The computer storage media of embodiments of the invention may take the form of any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations of the present invention may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present invention is not limited to the above method operations, and may also perform the related operations in the data generating method provided in any embodiment of the present invention.

Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.

Claims

1. A data generation method, comprising:

generating calculation data corresponding to the user code based on the target calculation field and the calculation field value;

the determining a computation field corresponding to the user code includes:

when detecting a target subject template selected and input by a user, determining a calculation field corresponding to the target subject template based on a preset field subject table; the preset field subject table comprises at least one subject template and calculation fields corresponding to the subject templates respectively;

correspondingly, the storing the user code and the target calculation field in the template user table correspondingly includes:

correspondingly storing the user code, the target calculation field and the target subject template in a template user table;

The determining, based on the target calculation field and the service data corresponding to the user code in the template user table, a calculation field value corresponding to the target calculation field includes:

determining a data source corresponding to the target subject template based on the target subject template corresponding to the user code and a preset template table, and acquiring business data corresponding to the target subject template based on the data source; the preset template table comprises at least one subject template and data sources respectively corresponding to the subject templates;

determining a field source corresponding to the target calculation field based on the target calculation field and a preset field table; the preset field table is used for representing the association relation between the calculated field and the field source;

and determining a calculated field value corresponding to the target calculated field based on the field source and the service data.

2. The method of claim 1, wherein the predetermined field table comprises a user field table, and wherein the determining a field source corresponding to the target-computing field based on the target-computing field and the predetermined field table, respectively, comprises:

If the user code is matched with a preset user code corresponding to the user field table, determining a field source corresponding to the target calculation field in the user field table based on the user code and the target calculation field; the user field table comprises at least one preset user code, calculation fields respectively corresponding to the preset user codes and field sources respectively corresponding to the calculation fields.

3. The method of claim 1, wherein the predetermined field table comprises a subject field table, and wherein the determining a field source corresponding to the target calculation field based on the target calculation field and the predetermined field table, respectively, comprises:

if the target subject template is matched with a preset subject template corresponding to the subject field table, determining a field source corresponding to the target calculation field in the subject field table based on the target subject template and the target calculation field; the subject field table comprises at least one preset subject template, calculation fields respectively corresponding to the preset subject templates and field sources respectively corresponding to the calculation fields.

4. The method of claim 1, wherein the predetermined field table comprises a user field table and a subject field table, and wherein the determining a field source corresponding to the target calculation field based on the target calculation field and the predetermined field table, respectively, comprises:

if the user code is matched with a preset user code corresponding to the user field table, determining a field source corresponding to the target calculation field in the user field table based on the user code and the target calculation field;

and if the user code is not matched with the preset user code corresponding to the user field table, or a field source corresponding to the target calculation field does not exist in the user field table, determining the field source corresponding to the target calculation field based on the target calculation field and the subject field table.

5. The method of claim 4, wherein the preset field table further comprises a base field table, and wherein the method further comprises:

if the target subject template is not matched with a preset subject template corresponding to the subject field table, or a field source corresponding to the target calculation field does not exist in the subject field table, determining a field source corresponding to the target calculation field in the basic field table based on the target calculation field; the basic field table comprises at least one calculation field and field sources respectively corresponding to the calculation fields.

6. The method of claim 1, wherein the determining a calculated field value corresponding to the target calculated field based on the field source and the traffic data comprises:

if the type of the field source belongs to a mapping class source, determining a calculated field value corresponding to the target calculated field in the service data based on a field mapping corresponding to the field source; wherein the field mapping is used for representing and calculating the storage position of a field value in the service data;

7. The method of claim 1, wherein prior to storing the user code and the target-computing field correspondence in a template user table, the method further comprises:

acquiring field sequence codes corresponding to the target calculation fields; the field sequence codes comprise preset field sequence codes corresponding to target calculation fields in the preset field subject table, or user-defined field sequence codes input by a user on an interactive interface based on the target calculation fields;

Correspondingly, the storing the user code, the target calculation field and the target subject template in the template user table correspondingly includes: storing the user code, the target calculation field, the target subject template and the field sequence code in a template user table correspondingly;

the generating, based on the target calculation field and the calculation field value, calculation data corresponding to the user code includes: and generating calculation data corresponding to the user code based on the target calculation field, the calculation field value and the field sequence code.

8. The method according to claim 1, wherein the method further comprises:

the calculation data and the calculation detail data corresponding to the calculation data are stored on a server;

when a calculation query instruction input by a user is detected, acquiring the calculation data and a download address corresponding to the calculation detail data;

and displaying the calculated data on an interactive interface, and sending the download address to a mailbox address corresponding to the user code in a mail mode.

9. A data generating apparatus, comprising:

a calculation data generation module for generating calculation data corresponding to the user code based on the target calculation field and the calculation field value;

the calculation field display module is specifically configured to: acquiring at least one subject template corresponding to the user code, and displaying each subject template on an interactive interface;

The target calculation field storage module is specifically configured to: correspondingly storing the user code, the target calculation field and the target subject template in a template user table;

the calculation field value obtaining module includes:

a service data acquisition unit, configured to determine a data source corresponding to a target subject template based on the target subject template corresponding to the user code and a preset template table, and acquire service data corresponding to the target subject template based on the data source; the preset template table comprises at least one subject template and data sources respectively corresponding to the subject templates;

a field source obtaining unit, configured to determine a field source corresponding to the target calculation field based on the target calculation field and a preset field table; the preset field table is used for representing the association relation between the calculated field and the field source;

and a calculated field value determining unit configured to determine a calculated field value corresponding to the target calculated field based on the field source and the service data.

10. An electronic device, the electronic device comprising:

one or more processors;

A memory for storing one or more programs;

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the data generation method of any of claims 1-9.

11. A storage medium containing computer executable instructions which, when executed by a computer processor, are for performing the data generation method of any of claims 1-9.