Hello, I need help with 2 pages. Pulling information from a mysql database and putting it on a page in the format we need it
to be in.
Page 1 - List all sku's waiting by priority with a checkbox next to each one.
Has to be able to check multiple skus if needed.
Have a submit button - when pressed sends info to page 2
Page 2 -
A - At the top of the page if an herb is in multiple skus that we just checked say something like: Cayenne is 3 skus
(then list them here) ect...
Then underneath print out the each sku like this
SKU # | PRODUCT NAME | QTY/PULL | MATH | CHECKBOX |
CHECKBOX for if they cleaned | Field for Clean time
The QTY/PULL will be based on a work order that they created just before this step. This is done but there
will be some math involved probably to pull it out correctly. Then the MATH section is the inventory of each herb - the
qty/pull = ??? so like this (INVENTORY - QTY/PULL = TOTAL)
Also if there is multiple herbs that need to be pulled they need to be bolded so it stands out.
B - When they are done pulling all the herbs they will come back to the screen and check each checkbox that they
pulled. If they did not check on the herbs a warning message will pop up and say 'bla bla was not pulled - do you want to
continue' if they click no then they can check that box that it is pulled and then continue. If they click yes then it will
not finish that product.
C. On the bottom just a comments box for in case there was problems. Then a submit button which completes this
section and send it to the next section.
I will dummy up some images so you can see the way we want it to look. It's actually really simple. Please feel free to ask any questions and hope to have this done asap. Thanks