JPH0589152A - Slip processor - Google Patents

Abstract

PURPOSE:To display the name, the post and the telephone number of a user who is updated at present when there is the update request of same slip data from the user, and to display the name, the post and the telephone number of a former user to an input/output device at the time of updating slip data. CONSTITUTION:When a slip number to be updated is inputted from the input/ output device 1, a slip data registration/update means (d) judges whether a present worker code is registered in a slip data base 4b or not. When it is registered, the name, the post and the telephonenumber of the N user corresponding to the worker code of the person who is updated at present, which are stored in a user data base 4a, update data of the person who is updated at present, which is stored in the slip data base 4b and an updating message are displayed in the input/output device 1.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a slip processing apparatus which allows an unspecified number of users to simultaneously access a database for update processing.

[0002]

2. Description of the Related Art In a conventional slip processing apparatus, it is often the case that an unspecified number of users must update data registered in a database during a certain period of time. When users concentrate on one piece of data, when a certain user updates the data, the slip processing device performs exclusive control to prohibit the update processing of other users and make them wait, and after that update processing ends. , The exclusive control is released and the update processing is performed by other users, and the exclusive control is applied in the same manner as above.

[0003]

In the conventional slip processing device as described above, when the other user performs the update process, only the input / output device indicates that the current user is performing the update process. There was a problem that the name of the user who was in the process of updating was not known.

Further, there is a problem that the updating process takes a long time, or even if the contents of the updating process are in doubt, it is impossible to make an inquiry to the user of the updating process.

The present invention has been made to solve the above problems, and temporarily stores the name of the user who is currently performing the updating process, and when there is a user who is performing the updating process of the same data, the updating process is currently being performed. It is an object to obtain a slip processing device capable of displaying a user name, update data, etc. on an input / output device.

[0006]

A voucher processing apparatus according to the present invention is an apparatus for registering voucher data from a plurality of input / output devices in a database on a host computer side and updating the contents thereof. Name, ID code,
A user database that stores user information including passwords, update data that includes slip numbers, drawing numbers that correspond to the slip numbers, the ID code of the previous updater that was previously updated, and the current update Check whether the slip database in which the ID code of the current updater is stored and the ID code and password of one user input from one input / output device at the time of update are registered in the user database. If there is one of the above user ID
A user checking means for storing the code in the temporary storage means, and a slip number input from the one input / output device after the user checking means stores the ID code of the one user in the temporary storage means. Check if the ID code of the one user is registered in the slip database, and if it is not registered, the ID of the one user
The code is registered in the slip database as the ID code of the current updater, and subsequently, based on the ID code of the previous updater registered in the slip database, the user information of the previous updater from the user database. And the registration data of the pre-updater corresponding to the slip number input from the one input / output device is extracted from the slip database and displayed on the one input / output device, and the desired update data is displayed from the one input / output device. The slip database is input to update the slip database, and after the update, the ID code of the previous updater in the slip database is rewritten to the ID code of the current updater to erase the ID code of the current updater and the temporary storage is performed. The ID code of the current updater stored in the means is erased, and while the data is being updated by the one input / output device, the same code is sent from another input / output device. When there is a request to update the vote number, the ID code of the current updater is checked in the slip database, and if the ID code of the current updater is registered, it is stored in the user database corresponding to the ID code of the current updater. Registered slip data for displaying the user information of the one user, the update data of the current updater stored in the slip database, and the message being updated on the other input / output device and waiting for the update process. And updating means.

[0007]

In the present invention, when the ID code and password of one user is input from one input / output device at the time of updating,
The user check means checks whether the input ID code and password are registered in the user database, and if registered, stores the ID code in the temporary storage means. Then, after the ID code is stored in the temporary storage means by the user checking means, when a slip number is input from one input / output device, the slip data registration / update means causes the current update person corresponding to the input slip number to enter. I
It is checked whether the D code is registered in the slip database. If it is not registered, the ID code of the one user is registered in the slip database as the ID code of the current updater, and then registered in the slip database. The user information of the pre-updater is retrieved from the user database based on the ID code of the pre-updater and the registration data of the pre-updater corresponding to the slip number input from the one input / output device is stored in the slip. When it is retrieved from the database and displayed on the one input / output device, and the desired update data is input from the input / output device, the slip data registration / update means causes the update data to be updated in the slip database, and after the update, the I of the previous updater of the slip database
The D code is rewritten to the ID code of the current updater to erase the ID code of the current updater and the ID code of the current updater stored in the temporary storage means. Further, when the same input / output device requests the update of the same slip number while the data is being updated by the one input / output device, the slip data registration / update means searches the slip database for the ID code of the current updater. If the ID code of the current updater is registered, the user information of the one user stored in the user database corresponding to the ID code of the current updater, the current updater stored in the slip database The update data and the message being updated are displayed on another input / output device and the update processing is made to wait.

[0008]

1 is an explanatory view showing an embodiment of the present invention, FIG.
1 is a hardware configuration diagram of FIG. 1, FIG. 3 is an explanatory diagram of the user database of FIG. 1, and FIG. 4 is an explanatory diagram of the slip database of FIG. In the figure, reference numeral 1 is an input / output device on the terminal side connected via a communication line, such as input of slip data based on the format screen or data (slip data, user data) stored in a database, etc. Is displayed. A communication control device 2 is connected to the input / output device 1 via a communication line, and accesses a central processing unit (described later) on the host side by an interrupt signal input together with the data input from the input / output device 1 (data (Transfer control), or the data stored in the database is controlled to be transferred to the input / output device 1 based on a command from the central processing unit. Reference numeral 3 denotes a central processing unit on the host side including a CPU, a storage unit, and the like. The CPU externally stores data input from the input / output unit 1 via the communication control unit 2 based on a database processing program stored in the storage unit. Magnetic disk device that is a device (described later)
To register the data, and display the data stored in the magnetic disk device on the input / output device 1 via the communication control device 2. Reference numeral 4 denotes a magnetic disk device connected to the central processing unit 3, which performs data registration / updating / erasing as a database based on a command from the central processing unit 3. As a database in the magnetic disk device 4, a user database 4a that stores data such as a user name, employee code and passcode of the user, a slip number, a product name and quantity corresponding to the slip number, It is provided with a slip database 4b for storing a delivery date and drawing number data, and a drawing number database 4c for collectively storing the drawing number.

Reference numeral a is an input / output control means, which is a user checking means (described later) via the communication control device 2 for data from the input / output device 1 based on a database processing program stored in the storage unit of the central processing unit 3. Alternatively, the slip data registration / update means (described later) is controlled to transfer the data, and the data from the user check means or the slip data registration / update means is transferred to the input / output device 1 via the communication control device 2.

Reference numeral b is a user checking means, which controls the input and output of the employee code and pass code of the user input from the input / output device 1 based on the database processing program stored in the storage unit of the central processing unit 3. It is received from the means a, and it is verified whether the received data is stored in the user database (described later).

Reference numeral c is a temporary storage means for storing the employee code when the user checking means b performs data collation based on a database processing program stored in the storage portion of the central processing unit 3.

Reference numeral d denotes a slip data registration / updating means, which processes the registration / updating / erasing by accessing the slip database 4b or the drawing number database 4c based on a database processing program stored in the storage unit of the central processing unit 3. In addition, the data stored in the slip database 4b is displayed on the input / output device 1 via the input / output control means a, and when the update process is completed, the employee code in the current updater column of the slip database. Is deleted and the employee code is stored in the temporary storage means c.

Reference numeral e is a database input / output means for controlling transfer of data from the slip data registration / updating means d to the slip database 4b based on a database processing program stored in the storage unit of the central processing unit 3 and for use. The user database 4a, the slip database 4b, or the drawing number database 4c based on the data access from the person check means b or the slip data registration / update means d.
The data stored in (1) is transferred to the user check means b or the slip data registration / update means d.

Reference numeral f is a screen format storage means, and a format screen required for a response to the input / output device 1, the user check means b, or the slip data registration / update means d is stored in the storage portion of the central processing unit 3. ing.

The slip processing apparatus of the present invention is configured as described above, FIG. 5 is a flow chart showing the operation of the present invention, FIG. 6 is an input format screen of the user checking means, and FIG. Input format screen (1) of the slip number of the updating means, FIG. 8 is an input format screen (2) of the item corresponding to the slip number of the slip data / updating means, and FIG. 9 is updating the slip data registration / updating means. Is a message screen for notifying that the operation of the present apparatus will be described based on the flowchart of FIG.

First, in step 1, the input / output device 1
When a format screen for update processing is designated from, the input / output control means a calls the screen format stored in the screen format storage means f to display the user processing screen shown in FIG. 6 on the input / output device 1. , Go to step 2.

In step 2, when the user inputs his employee code and password in the employee code column and pass code column displayed on the input / output device 1, the user check means b is the input / output control means. The employee code and the password are received via a, the user database 4a is accessed via the database input / output means e to check whether the employee code and the password are registered, and the process proceeds to step 3. ..

In step 3, if the user checking means b determines that the employee code and password are not registered in the user database 4a, the process proceeds to step 4, and if it is determined that they are registered. Proceeds to step 5.

In step 4, the user check means b causes the input / output device 1 to display a message indicating that there is no corresponding person through the input / output control means a, and returns to step 2.

In step 5, the user check means b writes the employee code registered in the user database 4a into the temporary storage means c and proceeds to step 6.

In step 6, the user check means b reads the screen format for processing slips stored in the screen format storage means f and transfers it to the input / output device 1 via the input / output control means a as shown in FIG. The slip processing screen shown is displayed, and the process proceeds to step 7.

In step 7, when the user inputs the slip number to be updated in the slip number column, the slip data is registered and
The updating means d receives the data of the slip number input to the input / output device 1 via the input / output control means a, and subsequently accesses the slip database 4b via the database input / output means e to enter the slip database 4b. It is checked whether or not the slip number is registered and the process proceeds to step 8.

In step 8, if the slip data registration / updating means d determines that the data of the slip number is not registered in the slip database 4b, the process proceeds to step 9, and if it is determined that the data is registered. Proceeds to step 10.

In step 9, the slip data registration / updating means d causes the input / output control means a to display a message of "not applicable" on the input / output device 1 and returns to step 7.

In step 10, registering slip data
The updating means d receives all the data (slip number, employee code in the previous updater column, employee code in the current updater column, item name, drawing) corresponding to the slip number in the slip database 4b via the database input / output means e. (Number, quantity, delivery date) is read (see FIG. 4), and it is checked whether the employee code in the current updater column is written in the data. If the employee code is written in the current updater column, it is being updated in another input / output device, so the process proceeds to step 11. If the employee code is not written in the current updater column. Is not being updated, the process proceeds to step 13.

In step 11, the slip data registration /
The updating means d accesses the user database 4a via the database input / output means e on the basis of the employee code written in the current updating person column in the slip database 4b to obtain the name, the belonging name and the telephone number. Read, step 12
Proceed to.

In step 12, the slip data registration /
The updating means d is the data of the name, affiliation name and telephone number read from the user database and all the data corresponding to the slip number previously read from the slip database 4b (slip number, employee in the previous updater column). (The employee code, the employee code in the current updater column, the product name, the drawing number, the quantity, and the delivery date), and the input / output control means a is caused to display the processing screen during update shown in FIG. Notify that the update is in progress and return to step 7. It should be noted that this display screen makes it clear that the user is performing update processing with the same slip number on other input / output devices. Persons can be urged to finish the work immediately. In addition, if you have any questions about the updated content, you can make an inquiry.

In step 13, when the employee code is not written in the current updater column of the slip database 4b, the slip data registration / update means d is a temporary storage means in which the employee code of the user is written. The employee code is retrieved from c, the employee code is written in the current updater column corresponding to the slip number in the slip database 4b via the database input / output means e, and the process proceeds to step 14.

In step 14, registration of slip data
The updating means d takes out the employee code in the previous updater column corresponding to the slip number in the slip database 4b via the database input / output means e, and via the database input / output means e based on the employee code. The name, affiliation name, and telephone number in the user database 4a are read out, and the process proceeds to step 15.

At step 15, the slip data registration /
The updating means d causes the input / output device 1 to display the slip processing screen shown in FIG. 8 through the input / output control means a on the contents of all the slip data corresponding to the slip number, the name, the affiliation name and the telephone number. Proceed to 16. At this time, if there is any doubt about the displayed update content, the previous updater can be contacted by telephone to inquire about the update content.

In step 16, when the user inputs a drawing number from the input / output device 1, the slip data registration / updating means d receives the drawing number via the input / output control means a, and the drawing number is the drawing number. It is checked via the database input / output means e whether or not it is registered in the number database 4c, and the process proceeds to step 17.

At step 17, the slip data registration /
The updating means d stores the drawing number in the drawing number database 4c.
If it is determined that the drawing number is not registered in the drawing number database 4c, the process proceeds to step 18, and if it is determined that the drawing number is registered in the drawing number database 4c, the process proceeds to step 19.

In step 18, the slip data registration /
The updating means d displays a message that the drawing number is erroneous input on the input / output device 1 via the input / output control means a and displays it on the input / output device 1, and returns to step 16.

In step 19, the slip data registration /
The updating means d writes the data at the time of updating into the slip database 4b corresponding to the slip number in the slip database 4b via the database input / output means e, and the step 20
Proceed to.

When the user finishes the updating process in step 20, the slip data registration / updating means d updates the employee code in the previous updater column in the slip database 4b through the database input / output means e. The employee code of the current updater is erased, and the employee code of the current updater written in the temporary storage means c is also erased.

Thus, even if another user has previously updated the data of the same slip number, the updated status and the name of the user are displayed on the input / output device, and the progress status is displayed. Can be dealt with accordingly.

[0037]

As described above, according to the present invention, even when the data having the same slip number is updated while updating the data based on the slip number, the user who is currently updating the data can use it. Since the update status of user information and data is displayed on the input / output device and made to wait, if the progress status of the user who is currently updating is slow, the user information is used to inquire of the user to promote the work. Even if the data at the time of updating is in doubt, the user can be inquired to correct the data at the time of updating.

Further, when updating the data, the user information of the previous updater is also displayed in correspondence with the data updated by the previous updater. You can contact the former updater with the information.

[Brief description of drawings]

FIG. 1 is an explanatory diagram showing an embodiment of the present invention.

FIG. 2 is a hardware configuration diagram of FIG.

FIG. 3 is an explanatory diagram of a user database shown in FIG.

4 is an explanatory diagram of a slip database of FIG. 1. FIG.

FIG. 5 is a flowchart showing the operation of the present invention.

FIG. 6 is an input format screen of the user checking means.

FIG. 7 is an input format screen of a slip number of slip data registration / update means.

FIG. 8 is an input format screen of items corresponding to slip numbers of slip data registration / update means.

FIG. 9 is a message screen notifying that the slip data registration / update means is being updated.

[Explanation of symbols]

 1 input / output device 2 communication control device 3 central processing unit 4 magnetic disk device a input / output control means b user checking means c temporary storage means d slip data registration / update means e database input / output means f screen format storage means 4a use Database 4b Voucher database 4c Drawing number database

Claims (3)

[Claims] 1. A device for registering slip data from a plurality of input / output devices in a database on a host computer side and updating the contents thereof, wherein user information including at least a user's name, ID code, password, etc. User database to be stored, registration data that has undergone update processing, including slip number, drawing number corresponding to the slip number, ID code of previous updater that was updated last time, and current update that is currently being updated. Person's ID
Check whether the slip database in which the code is stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. A user check means for storing an ID code of a person in the temporary storage means, and a slip number input from the one input / output device after the ID code of the one user is stored in the temporary storage means by the user check means Then, it is checked whether the ID code of the one user is registered in the slip database, and if not registered, the ID code of the one user is registered in the slip database as the ID code of the current updater. Then, based on the ID code of the previous updater registered in the slip database, the user database The user information of the previous updater is retrieved from the database and the registration data of the previous updater corresponding to the slip number input from the one input / output device is retrieved from the slip database and displayed on the one input / output device. Desired update data is input from the input / output device to update the slip database, and after the update, the ID code of the previous updater of the slip database is rewritten to the ID code of the current updater to update the ID code of the current updater. A slip processing device, comprising: slip data registration / update means for deleting the ID code and for deleting the ID code of the current updater stored in the temporary storage means. 2. A device for registering slip data from a plurality of input / output devices in a database on a host computer side and updating the contents thereof, wherein user information including at least a user's name, ID code, password, etc. User database to be stored, registration data that has undergone update processing, including slip number, drawing number corresponding to the slip number, ID code of previous updater that was updated last time, and current update that is currently being updated. Person's ID
Check whether the slip database in which the code is stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. The user check means for storing the ID code of the person in the temporary storage means, and the update of the same slip number from the other input / output device while the data is being updated by the one input / output device, the current data is stored in the slip database. The updater's ID code is checked and the current updater's I
When the D code is registered, the user information of the one user stored in the user database corresponding to the ID code of the current updater, the update data and update of the current updater stored in the slip database A slip processing device, comprising: slip data registering / updating means for displaying an internal message on the other input / output device and waiting for update processing. 3. A device for registering slip data from a plurality of input / output devices in a database on a host computer side and updating the contents thereof, wherein user information including at least a user's name, ID code, password, etc. User database to be stored, registration data that has undergone update processing, including slip number, drawing number corresponding to the slip number, ID code of previous updater that was updated last time, and current update that is currently being updated. Person's ID
Check whether the slip database in which the code is stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. A user check means for storing an ID code of a person in the temporary storage means, and a slip number input from the one input / output device after the ID code of the one user is stored in the temporary storage means by the user check means Then, it is checked whether the ID code of the one user is registered in the slip database, and if not registered, the ID code of the one user is registered in the slip database as the ID code of the current updater. Then, based on the ID code of the previous updater registered in the slip database, the user database The user information of the previous updater is retrieved from the database and the registration data of the previous updater corresponding to the slip number input from the one input / output device is retrieved from the slip database and displayed on the one input / output device. Desired update data is input from the input / output device to update the slip database, and after the update, the ID code of the previous updater of the slip database is rewritten to the ID code of the current updater to update the ID code of the current updater. Deleting the ID code and the ID code of the current updater stored in the temporary storage means,
Further, when an update request for the same slip number is issued from another input / output device while data is being updated by the one input / output device, the ID code of the current updater is checked in the slip database and the ID code of the current updater is displayed. If registered, the user information of the one user stored in the user database corresponding to the ID code of the current updater, the update data of the current updater stored in the slip database, and the update are in progress. A slip processing device, comprising: slip data registering / updating means for displaying a message on the other input / output device and waiting for update processing.