Meeting room reservation application construction
1. Usage scenarios
Meeting is the place where every enterprise makes major decisions. It digitizes conference rooms and appointments, and makes conference room appointments online. Previous conference room appointments have some limitations, such as companies, enterprises, units and individuals in different regions can not arrive at the scene to query and reserve the limitations of the conference room, and the conference room reservation system can solve this problem well, and can solve the problem of waste of conference resources in modern offices.
2. Video Display
3. Pages required for meeting room reservation
For the convenience of demonstration, let's briefly demonstrate the conference room reservation scenario in the simple version.
3.1 meeting room and reserved time stock table
Meeting Room name, appointment date, and appointment time period
3.2 conference room reservation
Appointment person, visitor, meeting date, selection of conference room (number of people), appointment time period, remarks, tips
Note that there are two data linkage settings. Select the meeting room and the appointment period. The settings are as shown in the following figure:
(1) Business Association rules
- One is to delete the data in the corresponding time period after the user submits the application.
- One is to release the reserved time period after rejection.
3.3 Conference room reservation
Select the corresponding dataset and the displayed column field.
4. Meeting room reservation logic
4.1 meeting room reservation
It is used to submit a meeting room reservation application. After approval, the business association rule is used to automatically remove the time period option in the inventory table.
4.2 meeting room and reserved time stock table
It is used to store meeting room reservation information and appointment time information, and provides optional data for meeting room reservation.
4.3 meeting room reservation records
It is used to show the reservation of meeting rooms, which are divided into reserved meeting rooms and optional meeting rooms.
##> click the link to authenticate now ##<
「Click me for free consultation!」
Kuairen enters the digital age step by step
-------------------- Get the latest information YIDA, welcome to follow US--------------------