Conference accommodation reservation and branch room management system and operation method
By designing the conference accommodation reservation and room distribution management system, the problems of inefficiency and inconsistent information caused by traditional manual operations are solved, and automated accommodation reservation and room distribution management are realized, which improves the work efficiency of conference organizers and participants. satisfaction.
Patent Information
- Application Number
- CN202411137237.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-19
- Publication Date
- 2024-12-10
AI Technical Summary
Traditional conference accommodation management relies on manual operations, resulting in data entry errors, information omissions, and inefficiency. The existing system is independent of the conference management system, and cannot achieve integrated management and intelligent room allocation, making it difficult to meet the needs of large-scale conferences or events.
A conference accommodation reservation and room distribution management system was designed, including room management module, registration module, reservation accommodation module and room distribution module. The hotel information is entered through the backend, the participants register and book accommodation, and the rooms are automatically allocated to achieve integrated Management and intelligent room distribution.
Significantly reduce manual operations, improve work efficiency, ensure data accuracy and consistency, maximize room utilization, improve participants' satisfaction, simplify operational processes, and enhance the control and data analysis capabilities of conference organizers.
Smart Images
Figure CN119106751A_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the field of information systems, and in particular relates to a conference accommodation reservation and room allocation management system and an operation method. Background Art
[0002] Accommodation reservation and room allocation management is a complex and important link in the organization of large-scale conferences or events. Traditional conference accommodation management usually relies on manual operations, and there are several major problems: Manually handling the accommodation reservation and room allocation of a large number of participants is prone to data entry errors and information omissions, resulting in low efficiency. Communication between participants and conference organizers often relies on emails or phone calls, and information is not delivered in a timely manner, which is prone to misunderstandings or omissions. Due to the lack of effective accommodation resource management, room resources may be wasted or the needs of participants may not be met. Due to the cumbersome and opaque reservation and room allocation process, the satisfaction of participants may be affected, which in turn affects the overall experience of the conference.
[0003] The existing conference accommodation reservation system is usually independent of the conference management system, resulting in inconsistent information and cumbersome operations. In addition, the traditional room allocation management method relies on manual operation, which has problems such as low efficiency and prone to errors. The existing technology cannot achieve integrated management and intelligent room allocation, and it is difficult to meet the needs of large-scale conferences or activities. Summary of the invention
[0004] In order to solve the problems in the prior art, the present invention provides a conference accommodation reservation and room allocation management system, which includes the following modules: a room management module, which is used by a conference organizer to enter the accommodation hotel information, room type, available check-in date, room price and bed information of the current conference in the background; a registration module, which is used by participants to access the conference system through a registration link, view the conference details, conference schedule, conference location and conference date, and enter the registration page to fill in the registration information; a reservation module, which is used by participants to reserve accommodation after successful registration, and the participants select the room type of the accommodation hotel according to their accommodation needs; a room allocation module, which is used to allocate and adjust the rooms according to the reservation information of the participants and the allocation strategy of the conference organizer; and a management module, which is used by the conference organizer to view and manage the accommodation reservation and room allocation of the participants.
[0005] Another aspect of the present invention further provides a method for operating a conference accommodation reservation and room allocation management system, which is used to operate a conference accommodation reservation and room allocation management system, and comprises the following steps:
[0006] Step 1: The conference organizer creates a conference in the background, sets registration fields, tickets, and enters hotel and room information, generates an invitation link through the system, and sends the invitation link to the participants;
[0007] Step 2: After receiving the conference invitation, participants log in to the conference website or open the conference application and fill in the registration information;
[0008] Step 3: After the participants have successfully registered, they can choose to book accommodation. Select the hotel and room type according to the hotel and room information displayed on the page, and enter the check-in date and check-out date to book accommodation;
[0009] Step 4: Participants need to sign in at the check-in desk before the meeting starts, and the conference affairs team will allocate rooms to participants based on their reserved accommodation information.
[0010] The present invention can produce the following beneficial effects through the above technical solution:
[0011] The system can automatically handle the registration, accommodation reservation and room allocation tasks of participants, greatly reducing manual operations and improving overall work efficiency. Reservation and room allocation information is updated in real time to ensure that participants and conference organizers can obtain the latest accommodation arrangements in a timely manner, avoiding misunderstandings and errors caused by delayed information.
[0012] By automatically entering and processing data, the accuracy and consistency of all information is ensured. The system integrates registration, reservation, room allocation and other functions on one platform, and all data is managed in a unified manner, avoiding information dispersion and inconsistency.
[0013] The system can intelligently allocate room resources based on the needs of participants and the strategies of conference organizers, ensuring maximum room utilization and reducing resource waste. The system can make personalized room arrangements based on the special needs of participants, such as gender, whether to share a room, etc., to improve the accommodation experience of participants.
[0014] Participants can clearly understand their accommodation arrangements and room allocation process, which increases the transparency and fairness of the system. The system provides a simple and friendly user interface, so participants can easily complete registration and reservation, and conference organizers can easily manage accommodation arrangements.
[0015] Conference organizers can use the system to monitor accommodation reservations and room allocation in real time and make timely adjustments to ensure the smooth progress of the conference. The system provides powerful data analysis and reporting functions to help conference organizers understand the needs and preferences of participants and optimize the organization and arrangement of future meetings.
[0016] The system integrates registration, reservation, room allocation and other functions on one platform, simplifying the operation process. Conference organizers can complete all management work on one interface. The system automatically generates registration and reservation links, which are convenient for participants to access and use, reducing the workload of conference organizers.
[0017] Through efficient reservation and room allocation management, conference organizers can focus more on conference content and event organization, improving the overall quality of the conference. Participants receive convenient, efficient and personalized accommodation services, improving their overall satisfaction and experience with the conference.
[0018] In summary, the automated conference accommodation reservation and room allocation management system has significant beneficial effects in improving work efficiency, enhancing data accuracy, optimizing resource utilization, improving participant satisfaction, realizing real-time monitoring and data analysis, simplifying operating procedures, and enhancing the overall experience of the conference, providing strong technical support for the successful holding of the conference. BRIEF DESCRIPTION OF THE DRAWINGS
[0019] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0020] Figure 1 This is the interface diagram for administrators to add hotels and room types;
[0021] Figure 2 This is the list interface for participants to book accommodation rooms;
[0022] Figure 3 This is the interface for participants to choose where to stay;
[0023] Figure 4 This is the administrator accommodation demand interface diagram;
[0024] Figure 5 This is the interface for administrators to view the room status table;
[0025] Figure 6 It is the room allocation operation interface for the administrator. DETAILED DESCRIPTION
[0026] Below, the invention is preferably described in conjunction with the accompanying drawings and specific implementation methods.
[0027] This embodiment solves the above problem through the following steps:
[0028] In this implementation, the conference accommodation reservation and room allocation management system includes a room management module, a registration module, an accommodation reservation module, a room allocation module, and a management module. This embodiment will provide detailed descriptions and explanations of the relevant modules.
[0029] The database tables involved in this system include:
[0030] User table (MeetingUser): stores user information, including user ID, user name, gender, age and other fields.
[0031] Hotel information (MeetingHotel): stores hotel information, including fields such as hotel ID and hotel name.
[0032] Room type information table (MeetingRoomType): stores room type information, including room type ID, hotel ID, room name, room type, available number of reservations, room rate, available check-in start date, available check-in end date, reservation deadline, etc.
[0033] Room Information Table (RoomNo): Stores room information, including room ID, room number, whether reserved, whether checked out, check-out date, start date, etc.
[0034] The accommodation log table (AccommodationLog) stores accommodation log information, including ID, guest ID, hotel ID, room type ID, room ID, room number, shared room / private room, check-in time, check-out time, etc.
[0035] The accommodation reservation table (Accommondat ionRecord) stores accommodation reservation information, including ID, hotel ID, room type ID, shared room / private room, check-in date, check-out date, room number, room ID, total cost, payment method for accommodation fee, whether to change room, etc.
[0036] The room management module is used by conference organizers to enter the accommodation hotel information, room type, available check-in date, room price, and bed information of the current conference in the background.
[0037] Specifically:
[0038] like Figure 1 As shown, the administrator logs into the system backend and enters the vacant room number given by the hotel into the system.
[0039] Collect all room information lists L0 in the system that contain the newly added room number, including room number, room type, hotel name and sort by time.
[0040] Traverse L0, perform duplicate verification for each room information, and traverse and verify according to the check-in time T1 and check-out time T2 of each room. If the current room number is in the system and the check-in date of the current room is greater than T1 and the check-out date is less than T2, it is determined that the current room number already exists in the system, and the program terminates the addition.
[0041] Traverse the list of room numbers that need to be added and save the information of each room number to the system.
[0042] Traverse the participant ID, obtain the current participant's reservation accommodation record, and update the corresponding room ID and room number to the reservation accommodation record table.
[0043] The registration module is used for participants to access the conference system through the registration link, view the conference details, meeting schedule, meeting location, meeting date, and enter the registration page to fill in the registration information;
[0044] Specifically:
[0045] The conference organizer generates a unique registration link through the conference system background and sends the link to potential participants. Participants click the registration link to enter the registration page of the conference system.
[0046] Participants can view detailed information about the meeting on the registration page, including the meeting theme, speakers, meeting agenda, etc. This information helps participants understand the specific content and arrangements of the meeting.
[0047] The registration page provides a detailed conference schedule, where participants can view the start and end time of each session, speech topics, break time, etc. This information helps participants arrange their time reasonably.
[0048] The registration page provides the specific address and venue information of the conference, including detailed address, transportation guide, etc., to help participants plan their travel routes in advance.
[0049] The registration page shows the start and end dates of the conference, and participants can arrange their travel and accommodation accordingly.
[0050] Fill in the registration information:
[0051] Participants fill in their personal information (such as name, gender, contact information, etc.) and other necessary registration information (such as purpose of participation, special needs, etc.) on the registration page. After completing the information, participants submit their registration information.
[0052] The accommodation booking module is used for participants to book accommodation after successfully registering. Participants can choose the type of hotel room according to their accommodation needs.
[0053] Specifically:
[0054] like Figure 2-3 After the participants successfully register through the registration link, they can click the Book Accommodation button on the registration success page to enter the accommodation booking page, select the hotel and room type and enter the check-in date and check-out date.
[0055] The system receives parameters transmitted by the page, including participant ID, check-in date, check-out date, room type ID, whether the room is shared, etc.
[0056] Assume that the check-in date of the participants is D1; the check-out date is D2; the total number of rooms is M; the room type of the king-size bed room is marked as A1; the room type of the standard room is marked as A2; the total number of rooms of the king-size bed room A1 is M1; the total number of rooms of the standard room A2 is M2; the number of people who have booked the king-size bed room is N1; the number of people who have booked the standard room is N2; the number of rooms of the king-size bed room is P1; the number of rooms of the standard room is P2. (Note: the king-size bed room has 1 bed and the standard room has 2 beds).
[0057] Calculate the remaining rooms: From the participant's check-in date D1 to the participant's check-out date D2, traverse by day and calculate the number of rooms of the room type currently selected by the participant. If the room type selected by the participant is a double bed room A1, the number of rooms of double bed rooms that have been booked P1=N1. If M1>P1, continue to loop for the next day, otherwise it is determined that the current room type A1 is full, and the loop continues until the participant's check-out date. If the room type selected by the participant is a standard room A2, the number of rooms of standard rooms that have been booked P2=CEILING(N / 2), if M2>P2, continue to loop for the next day, otherwise it is determined that the current room type A2 is full, and the loop continues until the participant's check-out date.
[0058] If the reserved room type is not fully occupied, the reservation is successful and written into the system, otherwise it is prompted that the reserved room is full.
[0059] The room allocation module is used to allocate and adjust rooms based on the reservation information of participants and the allocation strategy of the conference organizer.
[0060] This embodiment supports automatic room allocation and manual room allocation.
[0061] Automatic room allocation by administrator:
[0062] After participants sign in at the conference check-in counter, the administrator can use the automatic room allocation function in the system background to assign rooms to the current participants.
[0063] Get the following information based on the participant table MeetingUser and the accommodation record table AccommodationRecord:
[0064] The total number of participants N;
[0065] Total number of rooms M;
[0066] The reservation information of the i-th participant, including the check-in date and check-out date R i
[0067] The capacity (number of beds) of the i-th room is C i
[0068] Type B of the i-th roomi
[0069] Special needs of the i-th participant (such as gender, whether a separate room is needed, etc.) S i
[0070] The goal is to minimize the number of unassigned participants while trying to meet the needs of each participant and the room capacity constraints. Define the objective function:
[0071]
[0072] Among them, x ij is a binary variable. When the i-th participant is assigned to the j-th room, x ij =1 otherwise x ij =0.
[0073] Room capacity constraints: the actual number of occupants in each room cannot exceed its capacity:
[0074]
[0075] Participant demand constraints, each participant can only be assigned to one room:
[0076]
[0077] Time overlap constraint: the check-in and check-out dates of the participants cannot overlap with the dates of the allocated rooms:
[0078]
[0079] Special needs constraints, special needs such as gender, separate rooms, etc. must be met:
[0080]
[0081] When allocating
[0082] Set all x ij Variables are initialized to 0.
[0083] Traverse each participant i, according to their needs S i and time R i Choose the right room j.
[0084] Check if room j meets capacity C j and the time overlap constraint R i ∩R j .
[0085] If the constraints are met, assign room j to participant i and set x ij =1
[0086] Minimize the objective function Z using linear programming optimization.
[0087] The algorithm ends when all participants are assigned rooms or no more assignments can be made.
[0088] Output the allocation result x for each participant ij , that is, the room number and allocation status (allocated or unallocated) to which each participant is assigned.
[0089] The above algorithm can realize the automatic allocation of conference accommodation, ensuring that the room utilization rate and the accommodation experience of participants are optimized to the maximum extent possible while meeting various constraints.
[0090] Manual room allocation by administrator:
[0091] like Figure 6 As shown, according to the participant's accommodation requirements, manually search for all matching room numbers and select room numbers to allocate rooms.
[0092] The room allocation time can be set, the minimum time is 0:00 am and the maximum time is 8:00 am. Get the set room allocation time. The time range for room allocation is greater than the participant's check-in time + the set room allocation time and less than the participant's check-in time + the set room allocation time + 1 day. If it is within this range, room allocation can continue, otherwise it cannot be allocated.
[0093] Query the list of allocable rooms and obtain the list of unoccupied rooms based on the page parameters accommodation record ID, check-in date, and room number.
[0094] The room information table RoomNo is associated with the room type information table MeetingRoomType and the hotel information table MeetingHotel to obtain the room information details list M.
[0095] The accommodation record table AccommodationRecord and the participant information table MeetingUser are associated to obtain a list N of accommodation record information details.
[0096] Traverse the room information M and the accommodation record information details list N, associate them with the room number, obtain the accommodation information, accommodation status, and name of the guest, and display the data on the page.
[0097] The management module is used by conference organizers to view and manage the accommodation reservations and room allocation of participants.
[0098] Administrators view the reservation room information:
[0099] The administrator logs into the system backend to view the reserved room information.
[0100] According to the association query between the room type table MeetingRoomType and the hotel information MeetingHotel, query all room types of all hotels and set the result set to T1.
[0101] According to the room record table AccommodationRecord and the attendee information association query, query all attendee reservation records, and set the result set to R1.
[0102] Traverse loop T1, where the loop element is set to E1, and query the accommodation record R2 of the current room type through the room type RoomTypeId.
[0103] Let the earliest check-in time of the current room type be A1, A1=R, which is equal to the minimum check-in time InTime of all elements in the R2 set. Let the latest check-out time of the current room type be A2, which is equal to the maximum check-out time of all elements in the set; loop through the minimum check-in time and the maximum check-out time by day, and the loop variable is dt.
[0104] The number of paid rooms P1 = the number of elements in the R2 set whose check-in time is greater than dt and check-out time is less than dt and whose payment time is not null.
[0105] The number of male roommates M1 is equal to the number of all elements in the R2 set whose check-in time InTime is greater than dt and whose check-out time is less than dt, whose roommate IsJoin=1 and whose gender Gender is 0.
[0106] The number of female roommates M2 is equal to the number of all elements in the R2 set whose check-in time InTime is greater than dt and whose check-out time is less than dt, whose roommate IsJoin=1 and whose gender Gender is 1.
[0107] The number of rooms required for men to share a room is M3 = (int)Math.Truncate(M1 / 2). If they share a room, half of the room may be left empty, which needs to be displayed on the page. Let M4 = M1 / 2-M3; if M4>0, there is half a room left for women, and if M4=0, the men's room is just full.
[0108] The number of rooms required for women to share a room is M5 = (int) Math.Truncate(M1 / 2). If M5>0, there is half a room left for women. If M5=0, the rooms for women are just full.
[0109] Administrators check accommodation requirements:
[0110] The administrator logs into the system backend to check accommodation requirements.
[0111] Sort all participants' booked accommodations by their check-in and check-out times, obtain the earliest check-in time D1 and the latest check-out time D2, and generate a time set L for the room status table based on the earliest check-in time.
[0112] Traverse the time series of the room status table by day, query the reservation information of all participants, query the data of all people who need to check in on that day, obtain the total number of check-ins M on that day, and obtain the number of people who have reserved a room N. First, group the total number of people by gender to obtain the number of men (P1) and the number of women (P2).
[0113] For people of the same gender, each room can only accommodate one gender, so the number of shared rooms can be calculated using the following formula: Number of shared rooms for men = CEILING(P1 / 2) Number of shared rooms for women = CEILING(P2 / 2).
[0114] The total number of shared rooms required = the number of shared male rooms + the number of shared female rooms. The remaining people are allocated separately to calculate the remaining number of males (P11) and females (P12) who are not sharing a room, which are equal to P1-the number of shared male rooms*2 and P2-the number of shared female rooms*2 respectively.
[0115] For the remaining number of men, the number of separate rooms to be allocated is CEILING(P11 / 2). For the remaining number of women, the number of separate rooms to be allocated is CEILING(P12 / 2).
[0116] Administrators manage hotel room information:
[0117] like Figure 4-5 As shown, the administrator logs in to the backend and adds or modifies room information on the accommodation management page, including hotel name, room type, number of beds, room price, number of available rooms, available check-in date, reservation deadline, etc., and clicks Save.
[0118] The system receives various parameters from the page and determines whether the user is performing an edit operation or an add operation based on whether the hotel room type ID is passed on the page. If the hotel room type ID exists, the user is currently performing an edit operation; if it does not exist, the user is currently performing an add operation.
[0119] If the user performs an editing operation, the hotel room type table MeetingRoomType and the hotel information table MeetingHotel are associated through the hotel ID, and the room type ID is used as a filtering condition to obtain the room type information obj currently edited by the user.
[0120] The participant table MeetingUser and the accommodation reservation table AccommondationRecord are associated and queried through the participant ID, and the currently edited room type is used as the filtering condition to obtain the reserved accommodation set poList of the current room type.
[0121] The destined accommodation set poList of the current room type is filtered by the field IsJoin to obtain the accommodation record set mrtPoList_Package of the private room and the accommodation record set mrtPoList_Bed of the bed.
[0122] Use the Min function to obtain the earliest check-in time InTime of the accommodation record set mrtPoList_Package of the private room, and use the Max function to obtain the latest check-in time OutTime of the accommodation record set mrtPoList_Package of the private room.
[0123] Traverse from the earliest check-in time InTime to the latest check-in time OutTime by day, and obtain the maximum number of reservations HasSaleCount for the current room type.
[0124] Use the Min function to obtain the earliest check-in time InTime of the private room accommodation record set mrtPoList_Bed, and use the Max function to obtain the latest check-in time OutTime of the private room accommodation record set mrtPoList_Bed.
[0125] Traverse from the earliest check-in time InTime to the latest check-in time OutTime on a daily basis, and obtain the maximum number of beds HasSaleCount_Bed that have been booked for the current room type.
[0126] If HasSaleCount and HasSaleCount is less than or equal to 0, set the current room type to be modifiable, otherwise the current room type is not modifiable.
[0127] Assign all parameters to the MeetingRoomType object and save it to the system.
[0128] If a new room type is added, assign the parameters to the MeetingRoomType object and save it to the system.
[0129] Furthermore, the present invention also discloses an operation method of a conference accommodation reservation and room allocation management system, which includes the following steps:
[0130] Step 1: The conference organizer creates a meeting in the background, sets registration fields, tickets, and enters hotel and room information, generates an invitation link through the system, and sends the invitation link to the participants.
[0131] The conference organizer first logs in to the conference management system backend and creates a new conference project. At this point, you need to enter the basic information of the conference, such as the conference name, date, location and introduction. Next, set the registration fields (such as name, contact information, position, etc.) and ticket information (such as ticket type, price and quantity). Then, enter the accommodation-related information, including detailed information of the cooperating hotel (hotel name, address, contact information, etc.), as well as the room type (single room, double room, suite, etc.), number of beds, price and available check-in date. The system will generate a unique registration link based on this information, and the conference organizer can send this link to potential participants via email or other communication methods.
[0132] Step 2: After receiving the conference invitation, participants log in to the conference website or open the conference application and fill in the registration information.
[0133] After receiving the conference invitation link, participants click the link to enter the conference registration page. On this page, participants can view detailed information about the conference, including the conference theme, agenda, speakers, etc. Then, participants need to fill in their personal registration information, including name, gender, contact information, position, company name, etc. In addition, they may also need to fill in some specific requirements or notes (such as dietary requirements, whether special assistance is needed, etc.). After completing the form, participants submit their registration information, and the system will automatically generate confirmation information and record the participant's registration data.
[0134] Step 3. After participants have successfully registered, they can choose to book accommodation. Select the hotel and room type based on the hotel and room information displayed on the page, and enter the check-in date and check-out date to book accommodation.
[0135] After successfully registering, participants will be directed to the accommodation reservation page. On this page, the system will display detailed information and room types of partner hotels, including the price, number of beds, facilities and available check-in dates for each room type. Participants can choose the appropriate hotel and room type according to their needs and budget. After making the selection, participants need to enter the specific check-in date and check-out date, and confirm whether they need to stay alone or share a room. Finally, participants submit the accommodation reservation request, the system will check the availability of the room, and confirm the reservation. If the reservation is successful, the system will generate accommodation confirmation information and update the reservation record in the database.
[0136] Step 4: Participants need to sign in at the check-in desk before the meeting starts. The conference staff will allocate rooms to participants based on their reserved accommodation information. Factors considered in room allocation include the role of the participant, room type, check-in time, whether they are traveling together, special needs, etc.
[0137] Before the meeting begins, participants need to arrive at the meeting site and go to the sign-in desk to sign in and confirm. The conference affairs team will use the system to find the reservation information of each participant, including name, reserved hotel and room type, check-in and check-out dates, etc. The conference affairs team will allocate rooms based on the reservation information in the system and the actual room situation. When allocating rooms, the conference affairs team needs to consider multiple factors, such as the role of the participant (guest, ordinary participant, etc.), the reserved room type, check-in time and check-out time, whether there are accompanying people, and the special needs of the participants (such as gender, whether a separate room is needed, whether there are special care needs, etc.). After the room allocation is completed, the conference affairs team will notify the participants of their specific room number and provide relevant check-in instructions. The participants go to the hotel to check in according to the instructions and successfully check in to the reserved room.
[0138] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.
[0139] The present invention does not particularly specify the structure of some modules, which shall be subject to the contents recorded in the prior art. The prior art mentioned in the above background technology section and the specific embodiment section of the present invention can be used as part of the present invention to understand the meaning of some technical features or parameters. The scope of protection of the present invention shall be subject to the contents actually recorded in the claims.
Claims
1. A conference accommodation reservation and room allocation management system, characterized in that The system includes the following modules: The room management module is used by conference organizers to input the hotel information, room type, available check-in date, room price, and bed information of the current conference in the background; The registration module is used for participants to access the conference system through the registration link, view the conference details, meeting schedule, meeting location, meeting date, and enter the registration page to fill in the registration information; The accommodation booking module is used for participants to book accommodation after successfully registering. Participants can choose the type of hotel room to stay in according to their accommodation needs. The room allocation module is used to allocate and adjust rooms based on the reservation information of participants and the allocation strategy of the conference organizer; The management module is used by conference organizers to view and manage the accommodation reservations and room allocation of participants.
2. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The implementation method of the room management module is: Collect all room information lists L0 in the system that contain the newly added room number, including room number, room type, hotel name and sort by time; Traverse L0, perform duplicate verification for each room information, and traverse and verify according to the check-in time T1 and check-out time T2 of each room. If the current room number is in the system and the check-in date of the current room is greater than T1 and the check-out date is less than T2; it is determined that the current room number already exists in the system, and the program terminates the addition; Traverse the list of room numbers that need to be added and save the information of each room number to the system; Traverse the participant ID, obtain the current participant's reservation accommodation record, and update the corresponding room ID and room number to the reservation accommodation record table.
3. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The implementation method of the registration module is: The conference organizer generates a unique registration link through the conference system background and sends the link to potential participants. Participants click the registration link to enter the registration page of the conference system. Participants can view detailed information about the conference on the registration page; The registration page provides a detailed conference schedule, where participants can view the start and end time of each session, speech topics, and break times; The registration page provides the specific address and venue information of the conference, including detailed address and transportation guide; The registration page shows the start and end dates of the conference; Participants fill in their personal information on the registration page.
4. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The implementation method of the accommodation reservation module is: After the participants successfully register through the registration link, they click the Book Accommodation button on the registration success page to enter the accommodation booking page, select the hotel and room type, and enter the check-in date and check-out date; The system receives the parameters passed by the page; Assume that the check-in date of the participants is D1; the check-out date is D2; the total number of rooms is M; the room type of the double bed room is marked as A1; the room type of the standard room is marked as A2; the total number of rooms of the double bed room A1 is M1; the total number of rooms of the standard room A2 is M2; the number of people who have booked the double bed room is N1; the number of people who have booked the standard room is N2; the number of rooms of the double bed room is P1; the number of rooms of the standard room is P2; Traverse from the participant's check-in date D1 to the participant's check-out date D2 by day, and calculate the number of rooms of the room type currently selected by the participant. If the room type selected by the participant is a double bed room A1, the number of double bed rooms that have been booked P1=N1; if M1>P1, continue to loop to the next day, otherwise it is determined that the current room type A1 is full, and the loop continues until the participant's check-out date. If the room type selected by the participant is a standard room A2, the number of standard rooms that have been booked P2=CEILING(N / 2), if M2>P2, continue to loop to the next day, otherwise it is determined that the current room type A2 is full, and the loop continues until the participant's check-out date; If the reserved room type is not fully occupied, the reservation is successful and written into the system, otherwise it is prompted that the reserved room is full.
5. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The room allocation module includes automatic room allocation by an administrator, and the method for implementing automatic room allocation by an administrator is as follows: Obtain the following information based on the participant list and accommodation record sheet: The total number of participants N; Total number of rooms M; The reservation information of the i-th participant, including the check-in date and check-out date R i The capacity of the i-th room is C i Type B of the i-th room i ; The special needs of the i-th participant S i ; The goal is to minimize the number of unassigned participants while trying to meet the needs of each participant and the room capacity constraints; Define the objective function; Room capacity constraints: the actual number of occupants in each room cannot exceed its capacity; Due to the demand constraints of participants, each participant can only be assigned to one room; Time overlap constraint: the check-in and check-out dates of the participants cannot overlap with the dates of the allocated rooms; Special needs constraints, special needs including gender and separate rooms must be met; When making an allocation: Set all x ij Variables are initialized to 0; Traverse each participant i, according to their needs S i and time R i Choose the right room j; Check if room j meets capacity C j and the time overlap constraint R i ∩R j ; If the constraints are met, assign room j to participant i and set x ij =1 Minimize the objective function Z using linear programming optimization; When all participants are assigned rooms or no more assignments can be made, the algorithm ends; Output the allocation result x for each participant ij , that is, the room number and allocation status to which each participant is assigned.
6. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The room allocation module includes manual room allocation by an administrator, and the method for implementing manual room allocation by an administrator is as follows: Manually search for all matching room numbers based on the participants' accommodation requirements and select room numbers to allocate rooms; The room allocation time can be set, with the minimum time being 0:00 am and the maximum time being 8:00 am; Get the set room allocation time; The time range for room allocation is greater than the participant's check-in time + the set room allocation time and less than the participant's check-in time + the set room allocation time + 1 day. If it is within this range, room allocation can continue, otherwise it cannot be allocated; Query the list of available rooms, and obtain the list of unoccupied rooms based on the page parameters accommodation record ID, check-in date, and room number; Associate the room information table RoomNo with the room type information table MeetingRoomType and the hotel information table MeetingHotel to obtain the room information details list M; Associate the accommodation record table AccommodationRecord with the participant information table MeetingUser to obtain the accommodation record information details list N; Traverse the room information M and the accommodation record information details list N, associate them with the room number, obtain the accommodation information, accommodation status, and name of the guest, and display the data on the page.
7. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The management module includes an administrator viewing the reserved room information, and the administrator viewing the reserved room information is implemented by: According to the association query between the room type table MeetingRoomType and the hotel information MeetingHotel, query all the room types of all hotels, and set the result set to T1; According to the room record table AccommodationRecord and the attendee information association query, query all attendee reservation records, and set the result set to R1; Traverse loop T1, where the loop element is set to E1, and query the accommodation record R2 of the current room type through the room type RoomTypeId. Suppose the earliest check-in time of the current room type is A1, A1=R is equal to the minimum check-in time InTime of all elements in the R2 set; Suppose the latest check-out time of the current room type is A2, A2 is equal to the maximum check-out time of all elements in the set; traverse the loop by day according to the minimum check-in time and the maximum check-out time, and the loop variable is dt; The number of paid rooms P1 = the number of elements in the R2 set whose check-in time is greater than dt and whose check-out time is less than dt and whose payment time is not null; The number of male roommates M1 is equal to the number of all elements in the R2 set whose check-in time InTime is greater than dt and whose check-out time is less than dt, whose roommate IsJoin = 1 and whose gender Gender is 0; The number of female roommates M2 is equal to the number of all elements in the R2 set whose check-in time InTime is greater than dt and whose check-out time is less than dt, whose roommate IsJoin = 1 and whose gender Gender is 1; The number of rooms required for male roommates is M3 = (int) Math.Truncate (M1 / 2). If they share a room, half of the room may be left empty, which needs to be displayed on the page. Let M4 = M1 / 2-M3; if M4>0, half of the room is left for female roommates, and if M4=0, the male room is just full; The number of rooms required for women to share a room is M5 = (int) Math.Truncate(M1 / 2). If M5>0, there is half a room left for women. If M5=0, the rooms for women are just full.
8. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The management module includes an administrator checking accommodation needs, and the administrator checking accommodation needs includes: Sort all participants' booked accommodation by check-in time and check-out time, obtain the earliest check-in time D1 and the latest check-out time D2, and generate a time set L of the room status table based on the earliest check-in time; Traverse the time series of the room status table by day, query the reservation information of all participants, query the data of all people who need to check in on that day, obtain the total number of check-ins M on that day, and obtain the number of people who booked the room N. First, group the total number of people by gender to obtain the number of males P1 and the number of females P2; For people of the same gender, each room can only accommodate one gender, so the number of shared rooms can be calculated by the following formula: Number of shared male rooms = CEILING(P1 / 2) Number of shared female rooms = CEILING(P2 / 2); The total number of shared rooms required = the number of shared male rooms + the number of shared female rooms. The remaining persons are allocated separately to calculate the remaining number of males (P11) and females (P12) who are not shared, which are equal to P1-the number of shared male rooms*2 and P2-the number of shared female rooms*2 respectively; For the remaining number of men, the number of separate rooms that need to be allocated is CEILING(P11 / 2); for the remaining number of women, the number of separate rooms that need to be allocated is CEILING(P12 / 2).
9. A conference accommodation reservation and room allocation management system according to claim 1, characterized in that The management module includes an administrator managing hotel room information, and the administrator managing hotel room information includes: The administrator logs in to the backend and adds or modifies room information on the accommodation management page, including hotel name, room type, number of beds, room price, number of available rooms, available check-in date, and reservation deadline, and clicks Save; The system receives various parameters from the page and determines whether the user is performing an edit operation or an add operation based on whether the hotel room type ID is passed on the page; if the hotel room type ID exists, the user is currently performing an edit operation; if it does not exist, the user is currently performing an add operation; If the user performs an editing operation, the hotel room type table MeetingRoomType and the hotel information table MeetingHotel are associated through the hotel ID, and the room type ID is used as the filtering condition to obtain the room type information obj currently edited by the user; The participant table MeetingUser and the accommodation reservation table AccommondationRecord are associated and queried by the participant ID, and the currently edited room type is used as the filtering condition to obtain the reservation accommodation set poList of the current room type; The current room type's destined accommodation set poList is filtered by the field IsJoin to obtain the accommodation record set mrtPoList_Package for private rooms and the accommodation record set mrtPoList_Bed for beds; Use the Min function to obtain the earliest check-in time InTime of the accommodation record set mrtPoList_Package of the private room, and use the Max function to obtain the latest check-in time OutTime of the accommodation record set mrtPoList_Package of the private room; Traverse from the earliest check-in time InTime to the latest check-in time OutTime by day, and obtain the maximum number of reservations HasSaleCount for the current room type; Use the Min function to obtain the earliest check-in time InTime of the accommodation record set mrtPoList_Bed of the private room, and use the Max function to obtain the latest check-in time OutTime of the accommodation record set mrtPoList_Bed of the private room; Traverse from the earliest check-in time InTime to the latest check-in time OutTime by day, and obtain the maximum number of beds HasSaleCount_Bed that have been booked for the current room type; If HasSaleCount and HasSaleCount is less than or equal to 0, set the current room type to be modifiable, otherwise if the current room type is not modifiable; Assign all parameters to the MeetingRoomType object and save it to the system; If a new room type is added, assign the parameters to the MeetingRoomType object and save it to the system.
10. A method for operating a conference accommodation reservation and room allocation management system, characterized in that the method is used to operate the conference accommodation reservation and room allocation management system according to any one of claims 1 to 9, and comprises the following steps: Step 1: The conference organizer creates a conference in the background, sets registration fields, tickets, and enters hotel and room information, generates an invitation link through the system, and sends the invitation link to the participants; Step 2: After receiving the conference invitation, participants log in to the conference website or open the conference application and fill in the registration information; Step 3: After the participants have successfully registered, they can choose to book accommodation. Select the hotel and room type according to the hotel and room information displayed on the page, and enter the check-in date and check-out date to book accommodation; Step 4: Participants need to sign in at the check-in desk before the meeting starts, and the conference affairs team will allocate rooms to participants based on their reserved accommodation information.