JP2023051227A - Case management system - Google Patents

Abstract

To provide a case management system that can manage a use product for each construction case, which can achieve reduction in load of selection of the use product for each of the construction cases and reduction in waste.SOLUTION: There is provided a case management system 1 in which a server 3 and a plurality of terminal devices 5 are connected to each other via the Internet 7. In the case management system 1, the server 3 includes a database for storing order contents and items including construction names in the state where the order contents and the items are associated with each other. When accessing the server 3 from the terminal devices 5, the server 3 rearranges the items of the database, and partially distributes information of the database to the terminal device 5 for each item in response to the request of the terminal device 5.SELECTED DRAWING: Figure 1

Description

The present invention relates to case management systems.

Products such as electric wires/cables and electrical construction materials are selected for each purpose of use (construction project), and the same type of products are often used in the same type of construction.
Patent Literature 1 discloses an electronic catalog presentation system that presents information on cable products. In the technique disclosed in Patent Document 1, when selecting a product, consideration is given to what kind of place it will be used and what kind of installation method it will be installed, and the product will be introduced according to the situation.

Japanese Patent Application Laid-Open No. 2003-168033

By the way, currently, contractors for construction projects select and purchase a large number of products such as electric wires, cables, and electrical construction materials from catalogs and websites in accordance with the details of the order. A lot of effort goes into purchasing. If there is an omission in the selection, it may lead to the double effort of purchasing additional products, which may lead to a delay in the start of construction. If there is a surplus in the selection, it may have to be discarded.
The main object of the present invention is to provide a project management system that can manage products used for each construction project, and that can realize reduction in labor for selecting products to be used and reduction in disposal for each construction project. to do.

In order to solve the above problems, according to the present invention,
In an issue management system in which a server and a plurality of terminal devices are connected via the Internet,
The server is provided with a database that stores items including order details and construction names in a mutually linked state,
When the server is accessed from the terminal device, the server rearranges the items of the database and partially distributes the information of the database to the terminal device for each item according to the request of the terminal device. There is provided an issue management system characterized by:

According to the present invention, the products to be used can be managed for each construction project, and it is possible to reduce the effort required to select the products to be used and reduce the disposal of the products for each construction project.

1 is a diagram showing a schematic configuration of a case management system; FIG. 3 is a diagram showing a schematic configuration of a server database; FIG. 3 is a diagram showing a schematic configuration of a server database; FIG. It is a figure which shows an example of the display screen of a terminal device.

Preferred embodiments of the present invention are described below.

FIG. 1 is a diagram showing a schematic configuration of the case management system.
As shown in FIG. 1, the case management system 1 has a configuration in which a server 3 and a plurality of terminal devices 5 are connected via the Internet 7 . A plurality of databases are installed in the server 3 , and the terminal device 5 can extract information from the databases or input information to the databases from the terminal device 5 .

2 and 3 are diagrams showing schematic configurations of the databases 3A and 3B of the server 3. FIG.
As shown in FIG. 2, the database 3A stores a list of product codes, product names, prices, and product images that are associated with each other.
As shown in FIG. 3, the database 3B of the server 3 stores the order date, order number, order details (product and its quantity), order amount, construction number, and construction name as a list, and these are linked to each other. stored in .

The terminal device 5 is a PC (Personal Computer), a tablet, a smart phone, or the like, and is a terminal used by a user. A user can access the server 3 from the terminal device 5 and display the information in the database 3A and the database 3B on the terminal device 5 .

In the case management system 1, when a user accesses the server 3 from the terminal device 5 and orders a product from the database 3A, the server 3 extracts the product information from the database 3A and records it in the database 3B as a purchase history. ing.
In such a case, the server 3 automatically assigns the order date, order number, construction number, and purchase order number to the database 3B. The server 3 can rearrange the list in the database 3B for each purchase history item, and can partially distribute the list to the terminal device 5 in response to a request from the terminal device 5. - 特許庁

In addition, the user can arbitrarily assign a construction name to the database 3B from the terminal device 5 through the server 3. FIG.
In conjunction with this, the server 3 can recognize that in the database 3B when an additional product is ordered in the item of the same construction name, and the user can use the terminal device 5 through the server 3 during construction or construction. If there are surplus products later, the information can be given to the database 3B.
In such a case, the server 3 can additionally deliver to the terminal device 5 additional or surplus order details (products and their quantities) in the database 3B.

FIG. 4 is a diagram showing an example of the display screen of the terminal device 5. As shown in FIG.
When the user accesses the server 3 from the terminal device 5, the display screen of FIG. 4 is displayed on the terminal device 5. FIG. In the display screen of FIG. 4, an input section (upper stage) and an output section (lower stage) corresponding thereto are prepared. Items for inputting the order number, construction number, construction name, product code, product name, purchase order number, and order date are prepared in the input section, and items corresponding to the input section are prepared in the output section. .

When the user inputs any item in the input section, the server 3 rearranges the purchase history in the database 3B, and the past purchase history corresponding to the user's input item is output to the output section.
For example, when the user inputs "tunnel construction" in the construction name field of the input section, the purchase history related to past tunnel construction is output to the output section.
In particular, the product name and its quantity are output in the items of the order details, and additional purchased products and surplus products in the construction project are displayed to that effect.

According to the present embodiment described above, the database 3B of the server 3 stores and records the user's purchase history, and the list is rearranged for each purchase history item according to the user's request. Therefore, the user can check the past purchase history on the terminal device 5 for each construction project, and can manage the products used in the past for each construction project.
In particular, according to this embodiment, items that have been additionally purchased or items that are surplus in past construction projects are indicated to that effect. It is also possible to realize reduction in labor for selecting products to be used and reduction in disposal for each case.

1 Matter Management System 3 Server 3A Database 3B Database 5 Terminal Device 7 Internet

Claims (2)

In an issue management system in which a server and a plurality of terminal devices are connected via the Internet,
The server is provided with a database that stores items including order details and construction names in a mutually linked state,
When the server is accessed from the terminal device, the server rearranges the items of the database and partially distributes the information of the database to the terminal device for each item according to the request of the terminal device. A project management system characterized by In the matter management system according to claim 1,
the database stores additional or surplus order details;
When the server is accessed from the terminal device, when the server partially distributes the information in the database to the terminal device, additional or surplus order content in the database is additionally distributed to the terminal device. A project management system characterized by:

Images