Queue Logic : FIFO ( Query should get a set of users from this table based on the date assign them to a week . Query should filtered by location in which the machine group is present. While assigning you have to check the validity if not valid ignore that user try the next user. The set of user that are updated will have updated date which is week start date in the queue table.
Tables
QueueTable (columns: Auditor, Location, Date)
machine(columns : machine_name,m_no,location)
group(columns:groupname,groupnumber,location ,shift)
weektable(today,weeek,week1,week2,week3)[week is current week,week1,is next to current week,week2 is next to week1,....soon]
help me to write queue or sugget me any other like procedure or service with reason
thanks in advance
Thanks&Regards
vamsi krishna