search

pafavero / book_a_seat

Desk booking software. Space Management. Based on reactjs
https://book-a-seat.vercel.app
MIT License
5 stars 2 forks source link

Not showing Tables, Chairs etc. #2

Open VapidRush opened 5 months ago

VapidRush commented 5 months ago

Hello, I cam a cross your application and wanted to set it up on my system. unfortunately the tables, chairs etc isnt showing up. Im now sitting at it 2days in a row but cant figure out why it wont show everything. Do you know what the issue could be? Im running on Ubuntu

Thanks in advance and kind regards.

Screenshot from 2024-04-13 20-48-16

pfavero-wheregroup commented 4 months ago

Hi @VapidRush , Sorry for the delay in my reply. I am assuming that with a new database you have some rows in the seat_objs table. Is this correct?

Here I have added some seats and tables as sample data: https://github.com/pafavero/nextjs_book_a_seat/blob/main/sql/create_db.sql 

INSERT INTO book_a_seat.table_objs ("name",x,y,width,height) VALUES
     ('table 2',49.0,17.0,166.0,38.0),
     ('table 1',599.0,87.0,46.0,161.0);

INSERT INTO book_a_seat.seat_objs ("name",x,y) VALUES
     ('chair 3',95.0,56.0),
     ('chair 4',168.0,55.0),
     ('chair 1',599.0,219.0),
     ('chair 2',599.0,111.0);

However, the normal user (example "user0") cannot add tables or seats. Only the administrator can. If you are logged into the application as "admin0", you can add new tables or seats:

image