I have this mysql table and i need a query to know available pcs of every order distinct by type. Is it possible to do?
I need a mysql query
Must work as fifo queue
Now i need a query to know how pieces of every order are available
Ask question before bid: 5+2?
Order Type Available pcs
I buy 5 pcs with order type PLANNED PLANNED+5
I buy 5 pcs with order type CASH CASH+5
I buy 5 pcs with order type CASH CASH+10
I sell 1 pcs PLANNED+4
I sell 1 pcs PLANNED+3
1 sell 2 pcs PLANNED+1
I buy 15 pcs with order type PLANNED PLANNED+16
14 freelancers estão ofertando em média €24 para esse trabalho
Hi I have gone through the requirements. Will do this script using PHP. I'm available to start now. Please contact for further discussions. Regards, Mohan
I can complete this task very quickly and with good quality. i am professional web developer,please see my profile. Please Send me a message so that we can discuss more about this project Regards
Bid answer: 7 I work daily with complex SQL databases, and this is easy. To be honest, I'm just looking for a good score, so I'll do it for half the average bid.