I need the the table contents changed to be ordered by yellowtype, totalrun DESC
When an item is printed the database needs to be updated to reflect that and if all the items have been printed off it needs to not be shown.
The YellowType needs to be replaced with
0 = Shortage
1 = Low Stock
2 = High Stock