JP4756144B2 - Commerce system, method and program - Google Patents

Description

  The present invention relates to a transaction system, method, and program that can reduce the number of transaction data in a database and the number of programs for processing the data.

  Conventionally, various electronic commerce systems have been devised. (For example, the following patent document 1).

In the conventional electronic commerce system, so-called BtoB transaction, BtoC transaction, and the like are performed. Data on ordering, ordering, sales, shipping, and the like related to the transaction is collected as an ordering slip, an order slip, a sales slip, a shipping slip, etc., respectively. Therefore, transaction data corresponding to each slip, such as order data, order data, sales data, and shipping data, is created and managed. Transaction data relating to such transactions has been created and held for each orderer, contractor, and system administrator.
JP 2003-256777 A

  However, in the conventional electronic commerce system, transaction data related to transactions is created and managed for each purchaser, contractor, and system administrator, so the same data must exist and be consistent. was there. Further, in order to display, update, or delete transaction data of the orderer, the contractor, the system administrator, etc., a program composed of SQL statements is necessary. However, a program composed of these SQL statements is necessary. However, it is necessary for each transaction data such as the orderer's transaction, the contractor's transaction, and the system administrator's transaction. Moreover, since these transaction data are created as transaction data corresponding to each slip such as order data, order data, sales data, shipping data, etc., the amount of data becomes enormous, and the number of programs composed of SQL statements is the same. What was needed was the actual situation.

  The present invention has been made in view of such circumstances, and an object of the present invention is to provide a commercial transaction system, method, and program that can reduce the number of transaction data in a database and the number of programs for processing the data.

  In order to achieve the above object, the commercial transaction system of the present invention receives the access from the terminal device of the first trader and the terminal device of the second trader that perform transactions with each other via the network. A transaction system for executing transaction processing performed between a first trader and a second trader, wherein a transaction table in which data relating to trades conducted between the first trader and the second trader is recorded; Collating a database storing a trader master in which trader information including a trader code for identifying a trader is stored with information stored in the trader master for access from the terminal device. Login permission means for permitting login by means of the above and an access state detection means for detecting the access state of the terminal device to which login is permitted by the login permission means And a data processing means that enables data processing of transaction data in a terminal device that is permitted to log in, each transaction data in the transaction table is a trader that identifies a first trader and a second trader For the terminal device in the first transaction state that includes each code and whose access state detected by the access state detection unit is authenticated as the first transaction unit, the data processing unit includes the first transaction unit in the transaction table. The transaction data having the transaction code of the transaction is extracted and the data processing is possible, and the access state detected by the access state detection means is the second transaction state terminal device authenticated as the second transaction state. On the other hand, the data processing means performs the transaction. By extracting the transaction data having the trader code of the second trader in the table and enabling the data processing, the first trader terminal device and the second trader terminal device have a common data processing means. The gist is that data processing of a common transaction table can be performed.

  In order to achieve the above object, the commercial transaction method of the present invention receives access from the terminal device of the first trader and the terminal device of the second trader that perform transactions mutually via the network, respectively, A transaction method for executing a transaction process performed between one trader and a second trader, in which data relating to a trade conducted between the first trader and the second trader is recorded. And a database in which a transaction master that stores transaction information including a transaction code for identifying a transaction is stored, and information stored in the transaction master for access from the terminal device is collated. Login permission means for permitting login by performing, and access state detection means for detecting an access state of the terminal device permitted to log in by the login permission means And a data processing means for enabling data processing of transaction data in a terminal device permitted to log in, and each transaction data in the transaction table identifies a first trader and a second trader. For the terminal device in the first transaction state that includes each code and whose access state detected by the access state detection unit is authenticated as the first transaction unit, the data processing unit includes the first transaction unit in the transaction table. The transaction data having the transaction code of the transaction is extracted and the data processing is possible, and the access state detected by the access state detection means is the second transaction state terminal device authenticated as the second transaction state. On the other hand, the data processing means performs the transaction. By extracting the transaction data having the trader code of the second trader in the table and enabling the data processing, the first trader terminal device and the second trader terminal device have a common data processing means. The main point is that data processing of a common transaction table is performed.

  In order to achieve the above object, the business transaction program of the present invention accepts access from the terminal device of the first trader and the terminal device of the second trader that perform transactions mutually via the network, respectively, A transaction transaction program for executing a transaction process performed between one trader and a second trader, in which data relating to a trade conducted between the first trader and the second trader is recorded And a database in which a transaction master that stores transaction information including a transaction code for identifying a transaction is stored, and information stored in the transaction master for access from the terminal device is collated. Login permission means for permitting login by performing access, and access for detecting an access state of the terminal device to which login is permitted by the login permission means. A state detection means and a data processing means that enables data processing of transaction data in a terminal device that is permitted to log in, and each transaction data in the transaction table includes a first trader and a second trader. For the terminal device in the first transaction state that includes the transaction code to be identified and whose access status detected by the access status detection means is authenticated as the first transaction, the data processing means A step of extracting transaction data having a trader code of the first trader in the table and enabling the data processing; and a second state in which the access state detected by the access state detection means is authenticated as the second trader. For terminal devices in the transaction state, the above data processing means is used. And extracting the transaction data having the trader code of the second trader in the transaction table and enabling the data processing to be executed by the computer device, and the terminal device of the first trader and the second trader The terminal device performs data processing of a common transaction table by a common data processing means.

  That is, according to the present invention, by using a common transaction table among a plurality of traders and managers, the transaction table can be saved and the processing load can be reduced. In addition, the number of programs consisting of SQL statements for data processing can be reduced. Moreover, since transaction data corresponding to each transition state such as ordering data, order data, sales data, shipping data, etc. is made common, the data amount is greatly reduced, and the program composed of SQL statements is corresponding to that amount. It can be greatly reduced.

  The network in the present invention is intended to include not only the Internet but also a network such as an intranet.

  In the present invention, the database further includes a terminal device in which the access state detected by the access state detection means is an administrator state authenticated as an administrator, as a first trader or a second trader. For the terminal device that is authorized and authenticated as the first trader from the manager state, the data processing means extracts transaction data having the trader code of the first trader in the transaction table. Transaction data having the transaction code of the second transaction in the transaction table in the data processing means for the terminal device that has been able to process the data and is further authenticated as the second transaction from the manager state. Authenticated as administrator The terminal device, by allowing the update of the transaction table adds authentication as trader, it is possible to reduce the number of program of SQL statements that perform data processing.

  Hereinafter, the best mode for carrying out the present invention will be described.

  1 to 6 show an example in which the present invention is applied to a security management system and an electronic commerce system.

  FIG. 1 is a functional block diagram of a system according to an embodiment of the present invention. Reference numeral 1 denotes a server device 1 that executes the program of the present invention to realize the method of the present invention and functions as the system of the present invention.

The server device 1 accepts access from the terminal device of the first trader and the terminal device of the second trader that perform transactions with each other via the network, and the terminal device of the first trader and the second trader It functions as a commercial transaction system that executes transaction processing performed with a terminal device.
The server device 1 functions as a security management system in a web server that accepts access from the terminal device 3 via the Internet 2.

  In this example, the server device 1 is connected to the Internet 2 serving as an information communication network, and a web server that enables browsing of a web page on the terminal device 3 that is also connected to the Internet 2, and a web page in the web server. It functions as a database server for providing data for construction.

  Each of the server devices 1 is a system having a communication interface, a large-capacity data storage device, etc., and the central processing unit reads a program recorded in an external storage device such as a hard disk device and executes processing according to the program. Various functions as will be described later are realized.

  The server device 1 is connected to an information communication network (the Internet 2 in this embodiment). A terminal device 3 used by the user is connected to the Internet 2. Each of the terminal devices 3 is a computer device such as a personal computer.

  The server device 1 functions as a WEB distribution server by performing data communication with each terminal device 3 accessed via the Internet 2 in accordance with a protocol such as HTTP (HyperText Transfer Protocol). That is, in response to a request from each terminal device 3, the server device 1 sends a web page that is data including a document or image described in a digital document description language such as HTML (HyperText Markup Language) to the terminal device 3. Send to.

  The web page is configured by inserting data supplied from the database 6 into data serving as a template stored in the external storage device.

  The server device 1 is given a unique network address (URL). The user can access the server device 1 by specifying this URL on each terminal device 3, and data including documents and images described in a digital document description language such as the above-mentioned HTML (HyperText Markup Language). Can be viewed on the homepage. Further, on the home page, data such as documents and images and selection input operations are input and transmitted to the server device 1 as necessary, and decision-making information is transmitted to the server device 1. . Details of these operations will be described later.

  In this system, unspecified general users, specific general users (general traders), and managers are scheduled as users who use the terminal device 3. In this system, an attribute code is assigned to each user and processing is performed. As the attribute code, 0 and an integer greater than or equal to 1 are used. (0) for unspecified general users, (1) (2) for general users (general traders) (X) ), (X + 1) is given to the system administrator.

  Here, the unspecified general user is a user who accesses the server device 1 via the Internet 2 and does not log in, which will be described later, and is in a login-less state, and is assigned (0) as an attribute code. The terminal in such an access state is indicated as terminal device 3 (0) in the figure.

  For (1), (2),... (X) of general users (general traders), the traders targeted by this system are classified into traders with common industry attributes (1) ( 2) (3) ... (X) is given.

  Specifically, among general users (general traders), (1) purchases a product (customer), (2) sells a product to a customer (shop), and wholesales the product to the shop. (Wholesale) can be (3). In addition, if necessary, it can be a system that targets a group of traders of various industry attributes such as (logistics company) (delivery company) (credit card company) (payment agency) ... In this case, (4), (5),... (X) are assigned as the attribute codes.

  In the figure, the terminals that are authenticated and logged in as these users (traders) are displayed as terminal device 3 (1), terminal device 3 (2)... Terminal device 3 (X), respectively. ing.

  An integer (X + 1) larger than the largest integer (X) among the attribute codes given as general users (general traders) is given to the manager. A terminal that is authenticated and logged in as an administrator is displayed as terminal device 3 (X + 1) in the figure.

  The server device 1 includes a database 6 in which a plurality of tables storing various data used by the system of the present invention are stored. The database 6 includes the terminal devices 3 of general users (traders), for example, the terminal device 3 (1) of the customer as the first trader and the terminal device 3 (2) of the shop as the second trader. The transaction storage unit 17 stores a transaction table in which data relating to commercial transactions performed between the two is stored. In addition, the database 6 includes a master storage unit 18 in which a master table in which information on general users (traders) and managers is recorded is stored.

  The database 6 is constructed by a relational database management system (RDBMS) that expresses data using a relationship between two-dimensional tables.

  FIG. 2 shows an example of a master table as a user master (trader master) in which information on the user (trader) stored in the master storage unit 18 is recorded.

  In this example, a customer (attribute code (0)), a shop (attribute code (1)), a wholesaler (attribute code (2)), and an administrator (attribute code (X + 1)) are used as users (traders). An example of the system is shown, and a customer master 21, a shop master 22, a wholesale master 23, and an administrator master 24 are provided as master tables. If necessary, it can be a system targeted at users of traders of various industry attributes such as (logistics company) (delivery company) (credit card company) (payment agency) ... In this case, a master table for each user (trader) is prepared.

  In the customer master 21, authentication information to be referred to at the time of authentication such as a customer code, an ID, and a password is recorded as a transaction code for identifying a customer as a transaction. In addition, the customer master 21 records customer-related information such as the customer's name, address, telephone number, FAX number, and mail address.

  The shop master 22 stores authentication information to be referred to at the time of authentication such as a shop code, ID, and password as a trader code for identifying a shop as a trader. In addition, the shop master 22 records information about the shop such as a shop name, an address, a telephone number, a FAX number, and an e-mail address.

  In the wholesale master 23, authentication information to be referred to at the time of authentication such as a wholesale code, ID, and password is recorded as a trader code for identifying wholesale as a trader. In addition, the wholesale master 23 records wholesale information such as a wholesale name, address, telephone number, FAX number, and mail address.

  The administrator master 24 records authentication information to be inquired at the time of authentication such as an administrator code, ID, and password for identifying the administrator. In addition, the manager master 24 records information about the manager such as the name of the manager.

  Transactions such as customer IDs, passwords and other authentication information, customer codes, shop codes, wholesale codes, etc. recorded in the customer master 21, shop master 22, wholesale master 23, administrator master 24 as the user master (trader master) The administrator code and the administrator code are inquired at the time of login authentication by the login permission means 11 described later. Further, the above-mentioned transaction code and manager code are used when an access state is detected by the access state detection means 10 described later.

  FIG. 3 is a diagram illustrating an example of a transaction table in which data regarding transactions performed between the terminal devices 3 of the respective traders is recorded.

  In this example, for example, data related to a transaction performed between the terminal device 3 (1) of the customer as the first trader and the terminal device 3 (2) of the shop as the second trader is recorded. Data relating to transactions performed between the transaction (1-2) 26, the terminal device 3 (2) of the shop as the first trader, and the wholesale terminal device 3 (3) as the second trader The recorded transaction (2-3) 27 is illustrated.

  That is, in this example, as shown in FIG. 6, as a trader, a customer who purchases a product (attribute code (1)), a shop that sells the product to the customer and purchases the product from wholesale (attribute) Description will be made by taking as an example a model called code (2)) and a wholesaler (attribute code (3)) which wholesales products to the shop. In this example, a customer who purchases a product can be a first trader, and a shop that trades with the first trader can be a second trader. Further, in the relationship between a shop and a wholesaler, a shop that purchases a product can be a first trader, and a wholesaler that trades with the first trader can be a second trader.

  As described above, the first trader and the second trader in the present invention can be determined relatively among traders having a business relationship, and are not absolute.

  In this example, the transaction (1-2) 26 includes a slip No. as transaction data. Data relating to product transactions such as date, product code, quantity, amount, etc. are recorded. The transaction (1-2) 26 includes, as transaction data, a customer code as a trader code for identifying that the transaction data belongs to the first trader, and the transaction data containing the second transaction data. A shop code as a trader code as a trader code for identifying that it belongs to a trader is recorded.

  In the transaction (2-3) 27, a slip No. Data relating to product transactions such as date, product code, quantity, amount, etc. are recorded. Further, in the transaction (2-3) 27, as transaction data, a shop code as a trader code for identifying the first trader and a wholesale code as a trader code for identifying the second trader are recorded. ing.

  In addition, the server device 1 includes a web page storage unit 15 that stores a web page to be displayed on the terminal device 3 that has accessed the server device 1 via the Internet 2. The web page stored in the web page storage unit 15 is output to the terminal device 3 to display predetermined information and to allow data processing of transaction data on the web page. Such a web page is created by a static file such as the HTML document described above. A page on which transaction data is displayed and processed is configured by inserting transaction data extracted from the database 6 into a predetermined template file.

  The server device 1 further includes a program storage unit 16 in which a program that enables data processing of a transaction table stored in the transaction storage unit 17 in the terminal device 3 accessed via the Internet 2 is provided. ing. This program is composed of SQL statements that are database access languages of a relational database management system (RDBMS).

  In addition, the server device 1 includes a log storage unit 19 that stores an access log from the terminal device 3 accessed via the Internet 2. In the log storage unit 19, as described above, the terminal device 3 (0), which is an unspecified general user in an access state less than the login state, is authenticated and logged in as a general user (general trader). Access status of a terminal device 3 (1) of a customer, a terminal device 3 (2) of the shop, a terminal device 3 (X), and a terminal device 3 (X + 1) in a state of being authenticated and logged in as an administrator The content of the access log to be saved is changed according to the attribute code assigned according to the above.

  Further, the server device 1 includes control means 5 for controlling operations for realizing various functions of the present invention, including data processing for the database 6, the web page storage unit 15, the program storage unit 16, the log storage unit 19, and the like. I have.

  The control means 5 controls a static file such as an HTML file stored in the web page storage unit 15 so that it can be displayed on a browser or the like of each terminal device 3 and is input on a screen displayed on each terminal device 3. And display control means 8 for performing reception control for receiving the transmitted data.

  The control means 5 logs in by checking information recorded in each master table stored in the master storage unit 18 which is a user master (trader master) with respect to access from each terminal device 3. A login permission unit 11 is provided.

  For example, when the terminal device 3 accesses the server device 1 by specifying a predetermined network address (URL) via the Internet 2, the login permission unit 11 displays a predetermined login screen by the display control unit 8. Displayed on the device 3 to prompt for input of ID and password. The ID and password entered on this login screen are accepted, and the ID and password recorded in the user master (trader master) such as the customer master 21, shop master 22, wholesale master 23 and manager master 24 are collated. If the correct ID and password are entered, login is permitted. If the entered ID and password are not correct, an error message is displayed.

  In this system, the data update of the user master (trader master) is not permitted from the terminal device 3 in a state of less than login where the authentication is not performed. That is, unless logged in, the data update screen is not output and displayed on the terminal device 3. On the other hand, in the logged-in login state, the terminal device 3 is allowed to update the data of the user master (trader master), and the data update screen is displayed on the terminal device 3 so that the data processing means 9 can update the data. .

  For example, when the ID and password recorded in the customer master 21 are entered and authenticated in the terminal device 3 used by the customer, (1) is given as the attribute code and recognized as the customer's terminal device 3 (1). The In this way, in the terminal device 3 (1) recognized as the customer's terminal device 3 (1), the master information update page is displayed in response to the request from the terminal device 3 (1), and the customer of the customer master 21 The customer data can be updated. Specifically, it is a change of e-mail address or the like.

  Similarly, in the terminal device 3 used by the shop, when the ID and password recorded in the shop master 22 are inputted and authenticated, (2) is given as the attribute code and recognized as the terminal device 3 (2) of the shop. Is done. Further, when the terminal device 3 used by the wholesaler is authenticated by inputting the ID and password recorded in the wholesale master 23, the attribute code (3) is given and recognized as the wholesale terminal device 3 (3). The

  When the terminal device 3 (2) or the wholesale terminal device 3 (3) is recognized as described above, the master information is updated in response to requests from the terminal devices 3 (2) and 3 (3). The page is displayed and the shop master 22 and wholesale master 23 can update the shop and wholesale data.

  The control unit 5 includes an access state detection unit 10 that detects an access state of the terminal device 3 that has accessed the server device 1 via the Internet 2.

  FIG. 4 shows an example of the detection table 28 for the access state detection means 10 to detect the access state.

  The access state detection means 10 includes, as an access state from the terminal device 3, a login state in which data update of the user master (trader master) is permitted from the terminal device 3 by login, and a user master (transaction) from the terminal device 3. The user's master) is not allowed to update data, and it is detected that the status is less than login.

  The login state is basically a state in which the user (transactioner) can be identified by referring to the master table based on the ID and password input in the accessed terminal device 3. In this login state, since the user of the terminal device 3 who has accessed is a user (transactioner) or administrator of a customer, shop, wholesale, etc., the attribute code is (1) (2) (3) .. A numerical value of 1 or more is given as (X) and (X + 1).

  On the other hand, if the login is less than the above, basically, the terminal device 3 that has been accessed has not been entered with an ID, password, etc., and the user (transactioner) using the terminal device 3 cannot be identified. State. In this under-login state, the number of users of the terminal device 3 who have accessed is unspecified, and the access state is recognized as an unspecified state, and (0) is assigned as the attribute code.

  Further, the access state detection means 10 is a state in which the user information input in the terminal device 3 is received as the access state from the terminal device 3 while the login authentication by the login permission means 11 is not performed. One pseudo login state is further detected. The first pseudo login state is, for example, when a user (transactioner) who has not registered as a user accesses the server device 1 through his / her terminal device 3 (0) and displays a user registration screen. In this user registration screen, information related to the user (transactioner) is input and transmitted to the server device 1, and the server device 1 accepts the information as a new user (transactioner).

  In the first pseudo login state, the user is not logged in, but is not an unspecified user (transactioner), and user (transactioner) information that can specify the user (transactioner) is stored in the server device. Since it is in the state accepted in 1, it is less than the login state, but it is recognized as the first pseudo login state, not the unspecified state. In the first pseudo login state, login authentication by the login permission means 11 is not performed, so that information in the master table cannot be rewritten by the terminal device 3.

  Moreover, in this 1st pseudo login state, the information of the accepted user (trader) is not written in the master table. Thereafter, data is recorded in the customer master 21 if this new user (transactioner) is a customer, data is recorded in the shop master 22 if it is a shop, and data is recorded in the wholesale master 23 if it is wholesale. As described above, when the user (transactioner) information is recorded in the master table, the first pseudo login state is canceled, and the access state can be recognized as the login state.

  Further, the access state detection means 10 is a state in which the user information of the master table is read in the terminal device in the state where the login authentication by the login permission means 11 is not performed as the access state from the terminal device 3. Further detect pseudo login status. In the second pseudo login state, for example, a user (transactioner) who has been registered as a user accesses the server device 1 through his / her terminal device 3 (0) and performs login authentication by the login permission means 11. However, it is a state in which the user (transactioner) data is called from the master table by entering the ID and password.

  Specifically, for example, before a customer logs in, after a product list screen is displayed and a desired product is selected, a shopping cart screen is displayed and an ID and a password are input. The customer information, which is data, is called from the customer master 21 and written in the transaction.

  In this second pseudo-login state, the user is not logged in, but is not an unspecified user (transactioner), and user (transactioner) information that can specify the user (transactioner) is stored in the master table. Since it is a state read from, it is recognized as a second pseudo login state, not an unspecified state, although it is a state less than the login state. In the second pseudo login state, login authentication by the login permission means 11 is not performed, so that information in the master table cannot be rewritten by the terminal device 3.

  Further, the access state detection unit 10 detects the access state of the terminal device 3 to which login is permitted by the login permission unit 11.

  That is, the access state detection unit 10 detects which attribute code is assigned to the terminal device 3 to which the terminal device 3 authenticated by the login permission unit 11 is assigned. Specifically, depending on whether the ID and password input at the time of login by the terminal device 3 are the customer, the shop or the wholesale, the attribute code (1) is given to the customer. If so, the attribute code (2) is assigned. If wholesale, the attribute code (3) is assigned. However, at this time, it is detected which attribute code (1) to (X) is assigned. is there.

  Thus, by detecting which attribute code (1) to (X) is given access by the access state detection means 10, the access state authenticated by login is authenticated as the first trader in the present invention. It is detected whether the state is the first trader state or the second trader state authenticated as the second trader in the present invention.

  Further, the access state detection means 10 further detects an administrator state logged in after receiving authentication as an administrator as an access state from the terminal device 3. That is, in the terminal device 3 used by the administrator, when the ID and password recorded in the administrator master 24 are input and authenticated, (X + 1) is given as an attribute code, and the administrator terminal device 3 (X + 1) ). In this way, in the terminal device 3 (X + 1) recognized as the administrator terminal device 3 (X + 1), a master information update page is displayed in response to a request from the terminal device 3 (X + 1). The administrator data can be updated.

  In addition, the login permission unit 11 further permits authentication as a transaction to the terminal device 3 (X + 1) in which the access state detected by the access state detection unit 10 is an administrator state authenticated as an administrator. To do. That is, an additional authentication screen is displayed on the administrator-dedicated menu displayed on the terminal device 3 (X + 1) in the access state authenticated as the administrator, and the customer (shop, wholesaler, etc.) as the additional authentication information ) Is prompted for input of ID and password, and additional authentication is performed as a user (transactioner) of the input ID and password.

  At this time, if the authentication information for additional authentication is the customer ID and password, the terminal device 3 (X + 1) in the manager state is recognized as an access state that is the customer terminal device 3 (1). . If the authentication information for additional authentication is the shop ID and password, the terminal device 3 (X + 1) in the manager state recognizes the access state as if it is the terminal device 3 (2) of the shop, and additional authentication If the authentication information for doing so is a wholesale ID and password, the terminal device 3 (X + 1) in the administrator state is recognized as an access state that is the wholesale terminal device 3 (3).

  In this way, the terminal device 3 (X + 1) authenticated as the administrator performs additional authentication as the first trader or the second trader in the present invention of the customer, shop, wholesale, etc., and is added as the trader. It is possible to update the master data of the additionally authenticated customer, shop, and wholesaler for the terminal device 3 (X + 1) of the authenticated manager. That is, since the master information update page of the customer (or shop, wholesale, etc.) with the additionally authenticated ID is displayed, the customer, shop, wholesale data of the customer master 21, shop master 22, and wholesale master 23 can be updated. is there.

  The control means 5 includes data processing means 9 that enables data processing of transaction data in the terminal device 3 that is permitted to log in by the login permission means 11.

  The data processing means 9 performs data processing on the transaction table stored in the transaction storage unit 17 of the database 6 by a program composed of SQL statements stored in the program storage unit 16. The data processing here refers to processing such as search of a transaction table, extraction of transaction data, display of extracted transaction data, change or update of displayed transaction data, addition of transaction data, and the like.

  For the terminal device 3 in the first transaction state in which the access state detected by the access state detection unit 10 is authenticated as the first transaction unit, the data processing unit 9 is the first transaction in the transaction table. Transaction data having the following transaction code is extracted and the data can be processed. In addition, the data processing means 9 sends the second transaction status to the second transaction state terminal device 3 whose access status detected by the access status detection means 10 has been authenticated as the second transaction status. Transaction data having the trader code of the trader is extracted and the data can be processed. By doing in this way, the terminal device 3 of a 1st trader and the terminal device 3 of a 2nd trader can perform the data processing of a common transaction table by the common data processing means 9. .

  Specifically, if the access state detected by the access state detection means 10 is the terminal device 3 (1) to which the customer attribute code is assigned, the authentication is made from the transaction (1-2) 26. The transaction data of the customer code of the selected customer is extracted and displayed as a list, and can be changed / updated / deleted. If the access state detected by the access state detection means 10 is the terminal device 3 (2) to which the shop attribute code is assigned, the transaction (1-2) 26 and / or the transaction (2) -3) The transaction data of the shop code of the authenticated shop is extracted from 27 and displayed in a list, and the change / update / deletion, etc., can be performed. If the access status detected by the access status detection means 10 is the terminal device 3 (3) to which the wholesale attribute code is assigned, the authenticated wholesale wholesale is obtained from the transaction (2-3) 27. Code transaction data is extracted and displayed in a list, which can be changed / updated / deleted.

  In addition, the data processing means 9 sends the first transaction in the transaction table to the terminal device 3 that is further authenticated as the first transaction from the terminal device 3 (X + 1) whose access status is the administrator status. Transaction data having a trader code is extracted and the data can be processed. Further, the data processing means 9 sends transaction data having the transaction code of the second transaction person in the transaction table to the terminal device 3 whose access state is further authenticated as the second trader from the administrator state. The data can be extracted and processed.

  Specifically, an additional authentication screen is displayed in the administrator-only menu displayed on the terminal device 3 (X + 1) in the access state authenticated as the administrator, and the customer (shop, wholesale, etc.) user (additional authentication information) The user is prompted to input an ID and a password that are authentication information of the trader, and is additionally authenticated as a user (trader) of the entered ID and password. In this way, for the terminal device 3 (X + 1) in the manager state additionally authenticated as a trader, it is possible to update the transaction data of the additionally authenticated customer, shop, and wholesale.

  The data processing means 9 also updates master data in the terminal device 3 in the login state as described above. Furthermore, data processing in the first pseudo login state and the second pseudo login state is also performed.

  The control unit 5 includes an access log storage unit 13 that stores an access log from the terminal device.

  The access log storage means 13 is different depending on whether the access state by the access state detection means 10 is a login state, a less-login state, a first pseudo login state, a second pseudo login state, or an administrator state. The contents stored in the access log stored in the log storage unit 19 are changed.

  FIG. 5 is a diagram for explaining the access log storage state in the log storage unit 19.

  That is, when the access state detected by the access state detection means 10 is the unspecified state (0), the access log is stored in the access log file (0) 30. Examples of the access log stored in the access log file (0) 30 include a time stamp, a provider area, and an IP address.

  When the access state detected by the access state detection means 10 is the first pseudo login state (0-A), the access log is stored in the access log file (0-A) 31. Examples of the access log stored in the access log file (0-A) 31 include a time stamp, a provider area, an IP address, and a trader code.

  When the access state detected by the access state detection means 10 is the second pseudo login state (0-B), the access log is stored in the access log file (0-B) 32. The access log stored in the access log file (0-B) 32 includes, for example, a time stamp, a provider area, a trader code, and an IP address.

  Further, when the access state detected by the access state detection means 10 is the customer state (1) in the transaction specific state, the access log is stored in the access log file (1) 33. The access log stored in the access log file (1) 33 includes, for example, a time stamp, a provider area, an IP address, a trader code, and an operated application name.

  Further, when the access state detected by the access state detection means 10 is the shop state (2) in the transaction specific state, the access log is stored in the access log file (2) 34. The access log stored in the access log file (2) 34 includes, for example, a time stamp, a provider area, an IP address, a trader code, and an operated application name.

  Further, when the access state detected by the access state detection means 10 is the wholesaler state (3) of the trader specific state, the access log is stored in the access log file (3) (not shown). The access log stored in the access log file (3) includes, for example, a time stamp, a provider area, an IP address, a trader code, and an operated application name.

  Further, when the access state detected by the access state detection means 10 is the wholesale state (X) in a predetermined transaction specific state, the access log is stored in the access log file (X) 35. The access log stored in the access log file (X) 35 includes, for example, a time stamp, a provider area, an IP address, a trader code, and an operated application name.

  If the access status detected by the access status detection means 10 is the administrator status (X + 1), the access log is stored in the access log file (X + 1) 36. The access log stored in the access log file (X + 1) 36 includes, for example, a time stamp, a provider area and an IP address, an operated application name, an administrator code, and data before and after data update.

  When the access status detected by the access status detection means 10 is the additional authentication status (X + 1: n), the access log is stored in the access log file (X + 1: n) 37. Examples of the access log stored in the access log file (X + 1: n) 37 include, for example, a time stamp, a provider area and an IP address, an operated application, an administrator code, a user code related to additional authentication, and before and after data update. It is data of.

  As described above, the access log storage unit 13 determines whether the access state by the access state detection unit 10 is the login state, the less-login state, the first pseudo login state, the second pseudo login state, or the administrator state. By changing the content of the access log stored in the log storage unit 19 due to the difference, the access log can be appropriately stored with a small system load.

  In addition, the database stores the administrator information related to the administrator together with the user information related to the general user, and the access state detection means is connected to the terminal device in the administrator state authenticated as the administrator. On the other hand, an additional authentication state in which authentication as a general user is permitted is further detected, and depending on whether the access state by the access state detection means is a login state, a less than login state, or an additional authentication state, When changing the contents of the access log saved by the access log saving means, when the terminal device authenticated as an administrator is further authenticated as a general user, in a special additional authentication state, when in another access state It is possible to store an appropriate access log different from.

  FIG. 6 is a diagram schematically showing a relationship between traders who use each terminal device 3 and a state in which each trader and manager perform data processing of a transaction table in the terminal device 3.

  First, in this example, a business transaction is performed between a customer and a shop, and a common transaction (1-2) 26 is used. That is, the customer terminal device 3 (1) and the shop terminal device 3 (2) each access the server device 1 and process data of the common transaction (1-2) 26 stored in the transaction storage unit 17. (Arrow A in the figure). Further, the administrator terminal device 3 (X + 1) also accesses the server device 1 and processes the data of the common transaction (1-2) 26 stored in the transaction storage unit 17 (arrow A in the figure). .

  Further, a commercial transaction is performed between the shop and the wholesaler, and a common transaction (2-3) 27 is used. That is, the shop terminal device 3 (2) and the wholesale terminal device 3 (3) access the server device 1 and process data of the common transaction (2-3) 27 stored in the transaction storage unit 17. (Arrow B in the figure). Furthermore, the administrator's terminal device 3 (X + 1) also accesses the server device 1 and processes data of the common transaction (2-3) 27 stored in the transaction storage unit 17 (arrow B in the figure). .

  That is, if the access state detected by the access state detection means 10 is the terminal device 3 (1) to which the customer attribute code is assigned, the authenticated customer from the transaction (1-2) 26 The customer code transaction data is extracted and displayed as a list, and can be changed / updated / deleted. If the access state detected by the access state detection means 10 is the terminal device 3 (2) to which the shop attribute code is assigned, the authenticated shop is obtained from the transaction (1-2) 26. The transaction data of the shop code is extracted and displayed as a list, and it is possible to change, update, delete, etc.

  If the access state detected by the access state detection means 10 is the terminal device 3 (2) to which the shop attribute code is assigned, the authenticated shop from the transaction (2-3) 27. The transaction data of the shop code is extracted and displayed as a list, and it is possible to change, update, delete, etc. If the access status detected by the access status detection means 10 is the terminal device 3 (3) to which the wholesale attribute code is assigned, the authenticated wholesale wholesale is obtained from the transaction (2-3) 27. Code transaction data is extracted and displayed in a list, which can be changed / updated / deleted.

  If the access state detected by the access state detecting means 10 is the terminal device 3 (X + 1) to which the administrator attribute code is assigned, the transaction (2-3) 27 and the transaction (2- 3) 27 transaction data can be changed / updated / deleted.

  Further, an additional authentication screen is displayed in the administrator-only menu displayed on the terminal device 3 (X + 1) in the access state authenticated as the administrator, and the customer (shop), customer, shop, wholesaler, etc., as additional authentication information The user is prompted to input the ID and password, which are the authentication information, and is additionally authenticated as the user (transactioner) of the input ID and password. The state of additional authentication as a customer is indicated by arrow C in the figure, the state of additional authentication as a shop is indicated by arrow D in the figure, and the state additionally authenticated as wholesale is indicated by arrow E in the figure.

  As described above, the terminal device 3 (X + 1) in the manager state additionally authenticated as a customer, shop, wholesaler, etc., is added to the additionally authenticated customer, shop, wholesale terminal devices 3 (1), 3 (2), 3 As a result, the transaction (1-2) 26 and (2-3) 27 can be updated.

  At this time, the terminal devices 3 (1), 3 (2), 3 (3)... 3 (X) authenticated as customers, shops, wholesalers, etc. are added as other traders, respectively. Authentication is not performed, and each trader is only allowed to view his / her own transaction data, and cannot view other traders' transaction data. Thereby, the security of transaction data is ensured.

  Thus, by using a common transaction table for a plurality of traders and managers, the transaction table can be saved and the processing load can be reduced. In addition, the number of programs consisting of SQL statements for data processing can be reduced. Moreover, since transaction data corresponding to each transition state such as ordering data, order data, sales data, shipping data, etc. is made common, the data amount is greatly reduced, and the program composed of SQL statements is corresponding to that amount. It can be greatly reduced. Further, the terminal device 3 (X-1) authenticated as an administrator is additionally authenticated as a transaction person, and the transaction table can be updated, thereby reducing the number of programs composed of SQL statements for data processing. be able to.

It is a functional block diagram which shows the system of one Embodiment of this invention. It is a figure which shows an example of a master table. It is a figure which shows an example of a transaction table. It is a figure which shows an example of the detection table for detecting an access state. It is a figure explaining the preservation | save state of a log. It is a figure explaining the effect | action of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Server apparatus 2 Internet 3 Terminal apparatus 5 Control means 6 Database 8 Display control means 9 Data processing means 10 Access state detection means 11 Login permission means 13 Access log preservation | save means 15 Web page storage part 16 Program storage part 17 Transaction storage part 18 Master Storage unit 19 Log storage unit 21 Customer master 22 Shop master 23 Wholesale master 24 Administrator master 26 Transaction (1-2)
27 Transaction (2-3)
28 Detection table 30-36 Access log file

Claims (4)

Accepts access from the terminal device of the first trader and the terminal device of the second trader who perform transactions with each other via the network, and executes the transaction processing performed between the first trader and the second trader. A commerce system that
A transaction table in which data relating to transactions performed between the first trader and the second trader is recorded, a trader master in which trader information including trader codes for identifying traders is recorded, management A database storing an administrator master in which administrator information including an administrator code for identifying a person is recorded;
Login permission means for permitting login by collating information stored in the trader master and / or administrator master for access from the terminal device;
An access state detection means for detecting an access state of a terminal device whose login is permitted by the login permission means;
A data processing means for enabling data processing of transaction data in a terminal device permitted to log in,
Each transaction data in the transaction table includes a trader code for identifying whether the transaction data belongs to the first trader or the second trader,
The data processing means is
For the terminal device in the first transaction state in which the access state detected by the access state detection means is authenticated as the first transaction person, the data processing means uses the first transaction partner in the transaction table in the data processing means. Extract transaction data with code and enable its processing,
For the terminal device in the second transaction state in which the access state detected by the access state detection unit is authenticated as the second transaction unit, in the data processing unit, the second transaction partner in the transaction table Extract transaction data with code and enable its processing,
For the terminal device in the administrator state whose access state detected by the access state detection unit is authenticated as an administrator, the data processing unit enables data processing of transaction data in the transaction table. ,
A commercial transaction characterized in that the terminal device of the first trader, the terminal device of the second trader, and the terminal device of the manager can perform data processing of a common transaction table by a common data processing means. system. For the terminal device in which the access state detected by the access state detection means is an administrator state authenticated as an administrator, further authentication as a first trader or a second trader is permitted,
For the terminal device further authenticated as the first trader from the manager state, the data processing means extracts transaction data having the trader code of the first trader in the transaction table and performs the data processing. Made possible
For the terminal device further authenticated as the second trader from the manager state, the data processing means extracts transaction data having the trader code of the second trader in the transaction table and performs the data processing. The commercial transaction system according to claim 1, which is enabled. Accepts access from the terminal device of the first trader and the terminal device of the second trader who perform transactions with each other via the network, and executes the transaction processing performed between the first trader and the second trader. A commercial transaction method
A transaction table in which data relating to transactions performed between the first trader and the second trader is recorded, a trader master in which trader information including trader codes for identifying traders is recorded, management A database storing an administrator master in which administrator information including an administrator code for identifying a person is recorded;
Login permission means for permitting login by collating information stored in the trader master and / or administrator master for access from the terminal device;
An access state detection means for detecting an access state of a terminal device whose login is permitted by the login permission means;
A data processing means for enabling data processing of transaction data in a terminal device permitted to log in;
Each transaction data in the transaction table includes a trader code for identifying whether the transaction data belongs to the first trader or the second trader,
The data processing means is
For the terminal device in the first transaction state in which the access state detected by the access state detection means is authenticated as the first transaction person, the data processing means uses the first transaction partner in the transaction table in the data processing means. Extracting transaction data having code and enabling the data processing;
For the terminal device in the second transaction state in which the access state detected by the access state detection unit is authenticated as the second transaction unit, in the data processing unit, the second transaction partner in the transaction table Extracting transaction data having code and enabling the data processing;
For the terminal device in the administrator state whose access state detected by the access state detection unit is authenticated as an administrator, the data processing unit enables the data processing of the transaction data in the transaction table; By running
A commercial transaction characterized in that the terminal device of the first trader, the terminal device of the second trader, and the terminal device of the manager can perform data processing of a common transaction table by a common data processing means. Method. Accepts access from the terminal device of the first trader and the terminal device of the second trader who perform transactions with each other via the network, and executes the transaction processing performed between the first trader and the second trader. A commercial transaction method
A transaction table in which data relating to transactions performed between the first trader and the second trader is recorded, a trader master in which trader information including trader codes for identifying traders is recorded, management A database storing an administrator master in which administrator information including an administrator code for identifying a person is recorded;
Login permission means for permitting login by collating information stored in the trader master and / or administrator master for access from the terminal device;
An access state detection means for detecting an access state of a terminal device whose login is permitted by the login permission means;
A data processing means for enabling data processing of transaction data in a terminal device permitted to log in;
Each transaction data in the transaction table includes a trader code for identifying whether the transaction data belongs to the first trader or the second trader,
The data processing means is
For the terminal device in the first transaction state in which the access state detected by the access state detection means is authenticated as the first transaction person, the data processing means uses the first transaction partner in the transaction table in the data processing means. Extracting transaction data having code and enabling the data processing;
For the terminal device in the second transaction state in which the access state detected by the access state detection unit is authenticated as the second transaction unit, in the data processing unit, the second transaction partner in the transaction table Extracting transaction data having code and enabling the data processing;
For the terminal device in the administrator state whose access state detected by the access state detection unit is authenticated as an administrator, the data processing unit enables the data processing of the transaction data in the transaction table; By causing the computer device to execute
A business transaction method, wherein a terminal device of a first trader, a terminal device of a second trader, and a terminal device of an administrator perform data processing of a common transaction table by a common data processing means.

Images