JP2980470B2 - Data processing device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention stores in a data file
Output a list of data with one or more item values
In particular, for each data,
When adding and outputting a new item value generated from the item value
In the came, a data processing apparatus which allows the addition of: brief and quickly a new field value.

List of data stored in data file
In the data processing apparatus for outputting, for each data, it may continue to output by adding new item value processing is required to generate the field values with the data. Such processing needs to be performed easily and quickly.

[0003]

2. Description of the Related Art If the prior art is described using a form processing apparatus as an example, conventionally, a new item value generated from the item value of the form data is added to each form data and output. In such a case, adopt a configuration that describes a conversion formula in a program that executes the output of form data, and calculate new item values to be added by substituting item values into the described conversion formula. Was added.

[0004]

However, according to such a conventional technique, there is a problem that every time the conversion formula is changed, the form data output execution program must be rewritten. Then, according to such a conventional technique, there is a problem that a new item value derived by a conversion formula cannot be quickly added because a new item value is calculated by online processing of a program.

[0005] The present invention has been made in view of such circumstances, and provides a list of data stored in a data file.
When adding and outputting new item values generated from the item values of the data at the time of inputting, it is possible to easily and quickly add new item values To provide a new data processing device.

[0006]

FIG. 1 shows the principle configuration of the present invention. In the figure, reference numeral 1 denotes a data processing device configured according to the present invention, and 2 denotes a terminal provided in the data processing device 1.

The data processing apparatus 1 comprises a data file 10, an input / output control means 11, a first setting means 12
, A second setting unit 13, a creating unit 14, a temporary table management area 15, and an output control unit 16.

[0008] The data file 10 manages data having one or more item values. The input / output control means 11
It controls input / output processing with the terminal 2. The first setting unit 12 interacts with the terminal 2 to set a plurality of conversion expressions (including those for converting item names to fixed values) by converting item names, and to set the conversion expressions and Set the correspondence with the category item value to be distinguished. Second setting means 1
3 sets the corresponding category item value generated by the first setting unit 12 for each data by interacting with the terminal 2.

[0009] The creating means 14 creates a temporary table of converted values by substituting the item values of each data into the conversion formula set by the first setting means 12. The temporary table management area 15 manages the temporary table created by the creating unit 14. The output control means 16 transmits the data to which the new item value has been added to the terminal 2.
Output to

[0010]

According to the present invention, the first setting means 12 sets a plurality of conversion formulas whose item names are to be converted by interacting with the terminal 2, and sets the conversion formulas and a classification for distinguishing them. Set the correspondence with the item value. And the second
The setting means 13 sets the corresponding category item value generated by the first setting means 12 for each data by interacting with the terminal 2.

When these setting processes are completed, the creating means 14 creates a temporary table of the converted values by substituting the item values of each data into the conversion formula set by the first setting means 12, and creates a temporary table of the converted values. Expand to the management area 15.

When the temporary table is expanded in the temporary table management area 15, the output control means 16 executes a process of reading data from the data file 10 and outputting the data to the terminal 2. At this time, The conversion value indicated by the category item value of each data is searched from the created temporary table, and the conversion value is set as a new item value of the data and output to the terminal 2.

As described above, the present invention adopts a configuration in which the conversion formula for deriving the additional item value to the data is separated from the data output execution program, so that the conversion formula can be easily changed. . Then, a configuration in which the conversion value is calculated at once in the offline processing is adopted, and a configuration in which the corresponding conversion value is searched for and added to the data is employed, so that a new item value derived by the conversion formula is obtained. Can be quickly added and output.

[0014]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described in detail according to an embodiment applied to a form processing apparatus. When applied to a form processing apparatus, the first setting unit 12 sets a plurality of conversion formulas for converting the form item names by interacting with the user via the terminal 2 and sets the conversion formulas. And the corresponding relationship with the category item value that distinguishes them.

FIG. 2 shows an embodiment of the setting data set by the first setting means 12. Here, “TANKA” in the figure represents “unit price” of the form item name,
"URYO" represents "quantity" of the form item name.

In the embodiment shown in FIG.
Is a conversion formula (hereinafter, referred to as a category) associated with the section item value “1”.
As the conversion formula (1), set the conversion formula (1) = unit price × 0.9 × quantity, and set the conversion formula (hereinafter, conversion formula (2) and Conversion formula (2) = unit price × 0.8 × quantity is set as the conversion formula, and the conversion formula associated with the category item value “3” (hereinafter sometimes referred to as conversion formula (3)) As an example, an example of setting the conversion formula (3) = unit price × 0.7 × quantity is shown.

On the other hand, when applied to a form processing device, the second
The setting unit 13 sets the corresponding category item value generated by the first setting unit 12 for each form data by interacting with the user via the terminal 2.

FIG. 3 shows an embodiment of the setting data set by the second setting means 13. In the embodiment of this figure, the category item value “1” is set for the form data with the product name “Tangerine M (1 box)”, and the product name is “Grape L.
(1 box) "and the classification item value" 2 "
Is set, the section item value “2” is set for the form data with the product name “Hakuto M (1 box)”, and the product name is “Pear L
(1 box) "for the group data" 1 "
Is set, and the classification item value “3” is set for the form data whose product name is “watermelon M (one ball)”.

Here, in this embodiment, "Tangerine M (1
Box data) has an item value of unit price “5000 yen” and quantity “10 boxes”, and “grape L (1
Box data) has an item value of unit price “2500 yen” and quantity “30 boxes”, and “white peach M (1
Box) "has an item value of unit price" 3000 yen "and quantity of" 25 boxes ", and" pear L (one box) "
Has the item value of "3000 yen" and the quantity of "45 boxes", and the form data of "watermelon M (one ball)" has the unit price of "1000 yen" and the quantity of "2
It is assumed that the item value is “0 ball”.

When the first and second setting means 12 and 13 complete the setting process in this way, as described with reference to FIG. 1, the creating means 14 stores the item values of each form data in the first form. By substituting into the conversion formula set by the setting means 12, a temporary table of conversion values is created and expanded in the temporary table management area 15.

In FIG. 4, when the first setting means 12 sets the setting data of FIG. 2 and the second setting means 13 sets the setting data of FIG. FIG.

That is, the creating unit 14 substitutes the item value of “Tangerine M (1 box)” into the conversion formula (1) to convert the conversion value “45000” and “Grape L (1 box)”. The conversion value “67500” is obtained by substituting the item value possessed by “”, and the conversion value “6” is obtained by substituting the item value possessed by “Hakuto M (1 box)”.
7500 ", the conversion value" 121500 "by substituting the item values of" pear L (1 box) "and the conversion value" 18000 "by substituting the item values of" watermelon M (1 ball) " In addition, this calculation operation is expressed by the conversion formula (2)
By performing the same for (3), a temporary table as shown in FIG. 4 is created. Here, the data type of the entry of the temporary table is the maximum data type (in this case, the integer 6
Digits).

When the temporary table is expanded in the temporary table management area 15 as described above, the output control means 16 generates the form data to which the new item value is added, as described with reference to FIG. The data is output to the terminal 2.

FIG. 5 shows an embodiment of a processing flow of a form output process executed by the output control means 16. Next, this processing flow will be described. Output control means 1
6 shows that the temporary table is expanded in the temporary table management area 15 as shown in FIG.
As shown in the processing flow of FIG.
Then, change the heading of the section item value of the form data to the form item name to be added. For example, the heading of the category item value is changed to “sales”.

Next, in step 2, it is determined whether or not all form data has been selected. If it is determined that all form data has not been selected, the process proceeds to step 3, where the next form data (the first form data) is selected. Sometimes the first form data) is selected,
In the following step 4, the value of the category item value set in the selected form data is specified. Then, in step 5, the conversion value of the temporary table pointed to by the specified category item value is specified. In the following step 6, the category item value is replaced with the specified temporary table conversion value. Go back to

For example, according to the processing of step 3, FIG.
When the form data of “Tangerine M (1 box)” is selected, the classification item value “1” is specified in accordance with the processing in step 4.
The conversion value “45000” of the conversion equation (1) shown in FIG. 4 is specified, and the section item value “1” is replaced with this conversion value “45000” in accordance with the processing of step 6.

When it is determined in step 2 that all the form data has been selected, the process proceeds to step 7 where the replaced form data is output to the terminal 2 in accordance with the processing of steps 1 to 6, and the processing is terminated.

In this way, the output control means 16 outputs to the terminal 2 the form data to which the item value of sales is newly added as shown in FIG. Although the illustrated embodiment has been described, the present invention is not limited to this. For example, in the embodiments, the present invention has been described according to the form processing apparatus, but the present invention is not limited to this.

[0029]

As described above, according to the present invention,
A data processing apparatus for processing a data having one or more item values so that a new item value generated from the item value is added and output, and a conversion formula for deriving an additional item value to the data Is separated from the data output execution program, so that the conversion formula can be easily changed. Then, a configuration in which the conversion value is calculated at once in the offline processing is adopted, and a configuration in which the corresponding conversion value is searched for and added to the data is employed, so that a new item value derived by the conversion formula is obtained. Can be quickly added and output.

[Brief description of the drawings]

FIG. 1 is a principle configuration diagram of the present invention.

FIG. 2 is an explanatory diagram of a setting process of a first setting unit.

FIG. 3 is an explanatory diagram of a setting process of a second setting unit.

FIG. 4 is an explanatory diagram of a temporary table.

FIG. 5 is an embodiment of a processing flow executed by an output control means.

FIG. 6 is an explanatory diagram of form data to be output.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Data processing apparatus 2 Terminal 10 Data file 11 I / O control means 12 First setting means 13 Second selection means 14 Creation means 15 Temporary table management area 16 Output control means

Claims (1)

(57) [Claims] 1. One or more data stored in a data file.
Distinguishing the data process unit you output a list of data with the item value of the number, by interacting with the terminal, and sets a plurality of conversion formulas to be converted the item name, the conversion formula and the conversion formula Setting means for setting a correspondence relationship with a category item value to be set
By interacting with (12) and the terminal, the data file to be output is
And second setting means (13) for setting the division field values for each data, the field values with the respective data of the data file to be output, and set the first setting means (12) Creation means (14) for creating a temporary table of conversion values by substituting in a conversion formula, and when reading and outputting data from a data file
To add a new item name in association with the above category item value
Go with it, is set by et al or in the temporary table created by the upper Symbol creating means (14), said second setting means (13)
Was searching for conversion value pointed to the partitioning field values with the respective data, further comprising an output control means (16) for outputting set as items value of the item name to be newly added to the converted value, Characteristic data processing device.