zulhari created the topic: the location of the queue table that will be called in MySQL
excuse me, ladies and gentlemen
I want to ask.
1. I use the qsystem queue with mysql database. where is the location of the queue table that has been pressed by the customer?
for example the queue A1, A2, A3 .... B1, B2, B3, B4 .....
after I see. which is the client table. fill in the queue that has been served.
2. how to pre-register. immediately get the queue A1, A2, A3 etc. .... B1, B2, B3 etc. .... not numeric codes. so customers don't need to print the queue at the kiosk.
Evgenic replied the topic: the location of the queue table that will be called in MySQL
1. "clients" for current state -> "statistic" for detailed information.
2. not clear. Do you want to work without a kiosk? For this, you can use service as "Paper roll".
zulhari replied the topic: the location of the queue table that will be called in MySQL
Thank you sir....
I want to work without kiosks. so consumers have to order queue numbers via SMS (short message from mobile), to get service tomorrow, consumers have to order queues first today. 30 pieces a day, if the queue is full tomorrow, the queue will automatically be made the next day. so forever. consumers immediately get the queue number A1, A2, A3 etc. ... if the A30 automatically becomes the next day A1, A2 ..... so on ...
if there is a queue table that has not been called in the MySQL table, I will immediately be able to create the program with MySQL, PHP and SMS service.
in the client table in MySQL fill in the queue number that has been served
Evgenic replied the topic: the location of the queue table that will be called in MySQL
For pre-registered customers, you should use the table "ADVANCE". But where is only ID. A number as "A15" will be created when a person will come to a kiosk and input the ID.
