Reservation Systems and Programs

Abstract

To provide a reservation system and program that realize reservations that improve the utilization rate of multiple types of services provided by multiple staff members correspondingly to dynamic shifts of the multiple staff members.SOLUTION: A reservation system and a program are provided, in which a reservation server 1 is linked to a shift management table in which multiple staff members are dynamically entered, and for multiple types of services provided by the multiple staff members, reservations are set in a reservation correspondence table according to shift statuses of the multiple staff members and the multiple types of services, daily reservations from users are received on the Web, and availability of reservations is displayed on the Web according to the reservation status.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a reservation system, and more particularly to a reservation system and program that improves the operational efficiency of multiple types of services provided in response to dynamic shifts of multiple staff members. [Background technology]

[0002] [Prior Art] Conventionally, there are web reservation systems that use networks.

[0003] Related prior art documents include Patent Publication No. 2003-006492, "Reservation management system, reservation management method, and reservation management program" (Patent Document 1), Patent Publication No. 2005-216280, "Pet care service franchise system using light vehicles, and customer management and reservation management system using computer servers and mobile phones" (Patent Document 2), and Patent Publication No. 2021-149722, "Service reservation reception management system" (Patent Document 3).

[0004] Patent Document 1 discloses that a customer is selected based on information indicating whether the customer can visit a store for an available reservation slot, and the customer is notified of the availability of the reservation slot.

[0005] Patent Document 2 shows that reservations are received on the homepage of a headquarters server, and franchised stores in the franchise area are notified of the reservation receipt by email.

[0006] Patent Document 3 shows that the profiles and work shifts of service employees are posted on a store website to accept reservations, and when the reservation situation meets certain conditions, the store is redirected to a dedicated website. [Prior art documents] [Patent documents]

[0007] [Patent Document 1] Japanese Patent Application Laid-Open No. 2003-006492 [Patent Document 2] Japanese Patent Application Laid-Open No. 2005-216280 [Patent Document 3] Patent Publication No. 2021-149722 Summary of the Invention [Problem to be solved by the invention]

[0008] However, the above-mentioned conventional technology has a problem in that it does not realize reservations that improve the utilization rate of multiple types of services by multiple staff members in accordance with the dynamic shift situations of those multiple staff members.

[0009] Incidentally, Patent Documents 1 to 3 do not describe a configuration for making reservations that improves the availability of multiple types of services provided by multiple staff members in response to dynamic shifts of multiple staff members.

[0010] The present invention has been made in consideration of the above-mentioned circumstances, and aims to provide a reservation system and program that realizes reservations that improve the utilization rate of multiple types of services provided by multiple staff members in response to dynamic shifts of multiple staff members. [Means for solving the problem]

[0011] The present invention, which solves the problems of the above-mentioned conventional example, is a reservation system having a reservation server that makes reservations for services to be provided to users at a shop or store. The reservation server generates a reservation status table based on a shift management table in which the shifts of multiple staff members are set, and when a service reservation is input by a user, the server obtains the required time according to the type of service of the reservation from a service definition table in which the required time for each type of service is set, and selects the staff member who is available in the reservation status table. Available to work Reservation of users for the time slot with the required time As a reservation slot for available time slots Set up and book In the reservation status table, in the time frame in which the staff member who set the reservation can work, after the set reservation available frame, the required time according to the type of service that takes a long time and is frequently used is secured as a gap time and the next reservation is set. It is characterized by:

[0012] The present invention is characterized in that in the reservation system, even if a reservation is set for a specific staff member in a reservation status table to which a plurality of staff members are assigned, the reservation server sets the reservation if no reservation is set for other staff members.

[0013] The present invention is directed to the reservation system, in which the reservation server is configured to store a reservation status table containing a specific staff member. Available time slots before and after the available work time slots If is set, Available reservation slots for the required time within the gap time slot The feature is that the following is set:

[0014] The present invention is characterized in that in the above reservation system, the reservation server adjusts the required time for each type of service according to the level of the staff in the service definition table, and when setting a reservation in the reservation status table, reads the required time adjusted according to the level of the staff from the service definition table and sets the reservation.

[0015] The present invention is a processing program that operates on a reservation server that makes reservations for services provided to users at a shop or store. The reservation server generates a reservation status table based on a shift management table in which the shifts of multiple staff members are set, and when a service reservation is input by a user, the required time corresponding to the type of service of the reservation is obtained from a service definition table in which the required time for each type of service is set, and the reservation status table is used to select the staff member who is available in the reservation status table. Available to work Reservation of users for the time slot with the required time As a reservation slot for available time slots Set it up and make a reservation In the reservation status table, in the time frame in which the staff member who set the reservation can work, after the set reservation available frame, the required time according to the type of service that takes a long time and is frequently used is secured as a gap time and the next reservation is set. The feature of this invention is that it functions as follows.

[0016] The present invention is characterized in that, in the program, the reservation server is made to function so as to set a reservation even if a reservation is set for a specific staff member in a reservation status table to which a plurality of staff members are assigned, if no reservation is set for other staff members.

[0017] In the program, the present invention is configured to make the reservation server identify a specific staff member in the reservation status table. Available time slots before and after the available work time slots If is set, Available reservation slots for the required time within the gap time slot Set Make it work It is characterized by:

[0018] The present invention is characterized in that in the above program, the reservation server is made to function such that the required time for each type of service is adjusted in the service definition table according to the level of the staff, and when a reservation is set in the reservation status table, the required time adjusted according to the level of the staff to be set is read from the service definition table and the reservation is set. [Effects of the Invention]

[0019] According to the present invention, the reservation server generates a reservation status table based on a shift management table in which the shifts of a plurality of staff members are set, and when a user inputs a reservation for a service, it obtains the required time according to the type of service of the reservation from a service definition table in which the required time for each type of service is set, and selects the staff member who is available in the reservation status table. Available to work Reservation of users for the time slot with the required time As a reservation slot for available time slots Set up and book In the reservation status table, in the time frame in which the staff member who set the reservation can work, after the set reservation available frame, the required time according to the type of service that takes a long time and is frequently used is secured as a gap time and the next reservation is set. As it is a reservation system, it has the effect of improving the utilization rate of services according to the dynamic shifts of multiple staff members and multiple types of services. [Brief explanation of the drawings]

[0020] [Figure 1] FIG. 1 is a schematic diagram illustrating the configuration of the reservation system. [Figure 2] FIG. 10 is a schematic diagram of a shift management table. [Figure 3] FIG. 10 is a schematic diagram of a service definition table. [Figure 4] FIG. 10 is a schematic diagram of a reservation correspondence table. [Figure 5] FIG. 10 is a schematic diagram of a reservation status table. [Figure 6] FIG. 2 is a flowchart illustrating the outline of the processing of the present system. DETAILED DESCRIPTION OF THE INVENTION

[0021] An embodiment of the present invention will be described with reference to the drawings. [Outline of the embodiment] The reservation system according to an embodiment of the present invention (this reservation system) is linked to a shift management table into which multiple staff members are dynamically entered, and accepts daily reservations from users online for multiple types of services performed by the multiple staff members.The system displays on the web whether or not a reservation can be made depending on the reservation status, and can realize reservations that improve the utilization rate of services based on the dynamic shifts of multiple staff members and multiple types of services.

[0022] [This reservation system: Figure 1] This reservation system will be described with reference to Figure 1. Figure 1 is a schematic diagram of the configuration of this reservation system. As shown in FIG. 1, the reservation system comprises a reservation server 1, a staff terminal 2, a customer (user) terminal 3, an administrator terminal 4, and a network 5. In reality, a plurality of staff terminals 2 and user terminals 3 are connected to the network 5, but in FIG. 1, only one terminal is shown for ease of explanation.

[0023] Next, each part of the reservation system will be described. [Reservation Server 1] The reservation server 1 realizes the reservation process that is characteristic of this embodiment. The reservation server 1 includes a control unit 11, a storage unit 12, and an interface unit 13, and realizes a characteristic reservation process by causing the control unit 11 to execute a processing program stored in the storage unit 12. The reservation process will be described in detail later.

[0024] The storage unit 12 stores processing programs, as well as staff shift data, user reservation data, service data defining multiple types of services, and the like. Shift data is data on staff work schedules, and work schedules are set for each staff member in daily hourly units, and is the data that forms the basis of a shift management table.

[0025] Specifically, the shift data is data that specifies the arrival and departure times for each staff member by job type on a daily basis, such as "early shift," "middle shift," "late shift," and "day off." This shift data may optionally include arrival and departure times, allowing for designated shift times to be set up.

[0026] Reservation data is allocated to each staff member on a daily basis, and is data that reserves user (customer) reservations by time slot, and is the basis for the reservation correspondence table (reservation correspondence table) described below. The service data is data that defines the required times for a plurality of types of services, and is the data that forms the basis of the service definition table described later.

[0027] The control unit 11 executes a processing program stored in the storage unit 12, references the shift management table and the service definition table, and generates a reservation correspondence table for reservations from users. The interface unit 13 connects the reservation server 1 to the network 5 .

[0028] [Staff Terminal 2] The staff terminal 2 is an information terminal device used by staff working in a shop (store), and is assumed to be a smartphone or a personal computer (PC). The staff terminal 2 accesses the reservation server 1 via the network 5 and inputs the shift data of the scheduled work shift. The input shift data is reflected in the shift management table.

[0029] [User terminal 3] The user terminal 3 is an information terminal device used by a user (customer) who receives the provision of a service, and is assumed to be a smartphone or a PC. The user terminal 3 accesses the reservation site (website) of the shop provided by the reservation server 1 via the network 5 and makes a reservation.

[0030] [Administrator terminal 4] The manager terminal 4 is an information terminal device used by the store manager, human resources manager, or system manager, and is assumed to be a smartphone, a PC, or the like. The administrator terminal 4 inputs data required to create a table of service definitions.

[0031] [Data in this reservation system: Figures 2-5] Next, the data handled in this reservation system and related tables will be explained with reference to Figures 2 to 5. Figure 2 is a schematic diagram of a shift management table, Figure 3 is a schematic diagram of a service definition table, Figure 4 is a schematic diagram of a reservation correspondence table, and Figure 5 is a schematic diagram of a reservation status table.

[0032] Based on the work schedule shift data input from the staff terminal 2, the reservation server 1 generates a shift management table shown in FIG. The shift management table sets the scheduled daily work time periods for each staff member, with work types such as "early shift," "middle shift," and "late shift." The shift management table may also be input into the reservation server 1 in bulk from the manager's terminal 4 by the manager or a human resources officer.

[0033] Based on the service data input from the administrator terminal 4, the reservation server 1 generates a service definition table shown in FIG. The service definition table allows the user to set the required time for multiple types of services. It is also possible to set different times for the same service depending on the size of the pet. For example, in the case of a pet dog, the required time for trimming, grooming, shampooing, etc. can be changed depending on the size of the dog.

[0034] Additionally, the required time can be adjusted in the service definition table depending on the years of experience and skill level of the staff. For example, the required time can be adjusted to a time shorter than the standard required time (e.g., standard required time x 0.8 = "adjusted time") based on the staff level, such as the number of years of experience or high skill of the staff.

[0035] In other words, the staff level and adjustment time (or a formula for calculating the adjustment time) are set in the service definition table, the adjustment time is obtained by referring to the level of the staff to whom the reservation is assigned, and the reservation is set in the reservation correspondence table using that adjustment time. The staff level is set in advance in the service definition table, etc.

[0036] Based on the reservation data input from the user terminal 3, the reservation server 1 generates a reservation correspondence table shown in Fig. 4. Note that Fig. 4 does not take into account staff breaks during the day, etc. The reservation correspondence table is managed by day, and the staff who will be working on that day are set, and reservation data from users is allocated within the working hours of each staff member.

[0037] When a user inputs reservation data specifying the type of service (specifically, the type of dog, size, service details, etc.) and specifying the available date and time, a time slot corresponding to that type of service is retrieved from the service definition table, and that time slot is set as the reservation time from the user in the reservation correspondence table. That time slot is weighted and adjusted according to the level of the staff, and set in the reservation correspondence table.

[0038] When making a web reservation, the user refers to the reservation status table shown in FIG. The reservation status table is displayed by day, and the availability of reservations is confirmed by the "○" or "×" above the time. Specifically, "○" times are available for reservations, and "×" times are unavailable for reservations.

[0039] The reservation status table is displayed based on the reservation correspondence table in Figure 4, and an "X" indicates that the corresponding staff member is fully booked or that making a reservation at that time would result in the staff member having some free time, making the reservation unavailable.

[0040] [Outline of the system's processing: Figure 6] Next, the outline of the processing of this system will be explained with reference to Fig. 6. Fig. 6 is a flow chart showing the outline of the processing of this system. First, as a preparation, the reservation server 1 generates the service definition table shown in Fig. 3 through an operation from the administrator terminal 4 (S1), as shown in Fig. 6. Specifically, the required times for each type of service are set.

[0041] Next, the reservation server 1 sets the shift data from the staff terminal 2 in the shift management table shown in Fig. 2 (S2). As a result, a daily work schedule for the staff is generated. Then, the reservation server 1 generates a reservation correspondence table shown in Fig. 4 based on the shift management table (S3). If there is no reservation from a user, the reservation correspondence table contains blank columns for the staff name or staff ID and the time slots that the staff can work.

[0042] Next, the reservation server 1 sets the reservation data from the user terminal 3 in the reservation correspondence table by the user who has referred to the reservation status table in Fig. 5 (S4). The reservation data is set to a time when reservations are possible in the reservation status table. The reservation server 1 updates the reservation status table based on the reservation correspondence table in which the reservation has been set (S5). The specific reservation process will be explained below.

[0043] [Reservation process of this reservation system: Figures 2-5] A specific reservation process in this reservation system will be described with reference to FIGS. In this reservation system, an example of a pet shop is shown in which reservations are accepted for trimming (3 hours) and grooming (2 hours).

[0044] The reservation server 1 generates a reservation correspondence table for multiple staff members as shown in Figure 4 based on the shift management table. If there are no reservations, available reservation slots are set according to the working situation, and all available reservations are marked with "O" in the reservation status table in Figure 5.

[0045] However, when staff work, once a reservation is set, it is controlled so that reservations are made in specific time units (for example, three hours for a grooming session, which is more frequently used and takes longer). If a reservation (reservation [1]) is set and then a three-hour grooming reservation (reservation [2]) is made, it can be made immediately after or three hours later. If reservation [2] is set three hours later, three hours of free time is secured, allowing for another reservation to be made. In other words, after the first reservation is set, reservations cannot be made for any odd time slots of less than three hours. Similarly, if a two-hour grooming reservation is made, it can be made immediately after or three hours after the first reservation. In Figure 3, the longest grooming time is 210 minutes for a toy poodle, but for other dog breeds, the times are 180 minutes (3 hours), 150 minutes (2.5 hours), and 120 minutes (2 hours).Here, 3 hours is used as the unit of spare time, as it has frequency and allows for flexibility in setting reservations.

[0046] Next, the user terminal 3 accesses the reservation site provided by the reservation server 1 and inputs a reservation from the reservation status table. Reservations can be made from times marked with "◯", but not from times marked with "X". In Figure 4, work time slots are set to correspond to the shifts of multiple staff members. When there are no reservations, staff members A and B can accommodate reservations from customers starting at 10:00 on a specific day, and staff member C can accommodate reservations starting at 11:00.

[0047] Then, when a reservation is set by a user, as shown in Figure 4, if staff A is booked for a trimming session from 10:00 to 13:00 and staff B is booked for a grooming session from 10:00 to 12:00, staff A can be booked for three hours from 13:00 to 16:00, and staff B can be booked for three hours from 12:00 to 15:00.

[0048] In FIG. 4, staff member A has a grooming appointment from 16:00 to 18:00, and staff member B has a trimming appointment from 15:00 to 18:00. In addition, staff C has a grooming appointment booked from 11:00 to 14:00, so reservations are available after 14:00. Furthermore, although trimming requiring 3 hours can be booked at available reservation times, this does not prohibit booking shorter grooming, shampooing, etc. in the 3-hour gap that occurs, and it is possible to schedule grooming, etc. in the 3-hour gap.

[0049] If the reservation status in Figure 4 is shown in the reservation status table in Figure 5, reservations at 10:00, 11:00, 15:00, and 16:00 will be marked "X", and reservations at 12:00, 13:00, 14:00, 17:00, and 18:00 will be marked "O".

[0050] From 12:00 to 15:00, staff B is available to take appointments for grooming, so 12:00 is marked as "Yes", from 13:00 to 16:00, staff A is available to take appointments for grooming, so 13:00 is marked as "Yes", from 14:00 to 17:00, staff C is available to take appointments for grooming, so 14:00 is marked as "Yes", and since staff C can handle appointments after 17:00, 17:00 and 18:00 are displayed as "Yes".

[0051] If there are three hours of free time before the staff member's shift ends, a trimming reservation can be made, but if there are less than three hours, the reservation server 1 controls so that reservations for periods shorter than three hours can be accepted.

[0052] In this way, the reservation server 1 controls the reservation so that it does not make reservations at odd times, and the reservation time slots are set according to the type of service in line with the staff shifts, thereby improving work efficiency without creating unnecessary gaps (blank time) for the staff.

[0053] This reservation system can be applied not only to pet shops, but also to beauty salons, dental clinics, training gyms, massage parlors, nail salons, etc.

[0054] [Effects of the embodiment] According to this reservation system, the reservation server 1 is linked to a shift management table into which multiple staff members are dynamically entered, and for multiple types of services provided by the multiple staff members, reservations are set in the reservation correspondence table according to the shift status of the multiple staff members and the multiple types of services, and daily reservations from users are accepted on the Web, and the availability of reservations is displayed on the Web according to the reservation status, which has the effect of improving the availability rate of services according to the dynamic shifts of multiple staff members and the multiple types of services.

[0055] Furthermore, this reservation system controls reservations to ensure specific time slots so that users do not have any incomplete time slots, which prevents incomplete reservations from being made and improves work efficiency. [Industrial Applicability]

[0056] The present invention is suitable for a reservation system and program that realizes reservations that improve the utilization rate of multiple types of services provided by multiple staff members in response to dynamic shifts of multiple staff members. [Explanation of symbols]

[0057] 1... reservation server, 2... staff terminal, 3... user terminal, 4... administrator terminal, 5... network, 11... control unit, 12... storage unit, 13... interface unit

Claims

1. A reservation system having a reservation server for making reservations for services provided to users at a shop or store, The reservation server generates a reservation status table based on a shift management table in which shifts of a plurality of staff members are set, and when a reservation for a service is input by the user, it obtains the required time corresponding to the type of service of the reservation from a service definition table in which the required time for each type of service is set, and sets the reservation of the user in a time slot in the reservation status table in which a staff member who is available to work can work as a reservation available slot for the required time, thereby making the reservation. In the reservation status table, in the time frame in which the staff member who set the reservation can work, the reservation system reserves a gap time corresponding to the type of service that takes a long time and is frequently used after the set available reservation frame and sets the next reservation.

2. The reservation system according to claim 1, characterized in that the reservation server sets a reservation even if a reservation is set for a specific staff member in a reservation status table to which multiple staff members are assigned, if no reservation is set for other staff members.

3. The reservation system according to claim 1 or 2, characterized in that, when a reservation slot is set before or after the gap time in the time slot in which a specific staff member is available to work in the reservation status table, the reservation server sets a reservation slot for the required time within the gap time in the gap time slot.

4. The reservation system according to claim 1 or 2, characterized in that the reservation server adjusts the required time for each type of service according to the level of the staff in the service definition table, and when setting a reservation in the reservation status table, reads the required time adjusted according to the level of the staff from the service definition table and sets the reservation.

5. A processing program that operates on a reservation server that makes reservations for services provided to users at a shop or store, The reservation server generates a reservation status table based on a shift management table in which shifts of a plurality of staff members are set, and when a reservation for a service is input by the user, the required time corresponding to the type of service of the reservation is obtained from a service definition table in which the required time for each type of service is set, and the reservation is made by setting the reservation of the user as a reservation available slot for a time slot in which the required time can be reserved in a time slot in which an available staff member can work in the reservation status table, The program functions to reserve a gap time according to the type of service that takes a long time and is frequently used after the set available reservation time frame of the staff member who set the reservation in the reservation status table, and set the next reservation.

6. The program according to claim 5, characterized in that the reservation server is made to function so as to set a reservation even if a reservation is set for a specific staff member in a reservation status table to which multiple staff members are assigned, if no reservation is set for other staff members.

7. The program according to claim 5 or 6, characterized in that the reservation server is made to function so that, when a reservation slot is set before or after the gap time in the time slot available for a specific staff member to work in the reservation status table, a reservation slot for the required time within the gap time is set in the gap time slot.

8. The program according to claim 5 or 6, characterized in that the reservation server is configured to read from the service definition table the required time for each type of service adjusted according to the level of the staff member when setting a reservation in the reservation status table, and to set the reservation by reading from the service definition table the required time adjusted according to the level of the staff member to be set.

Images