PHP/Mysql Algorithm Correction Specialist Needed
Budget: $25 – $75 USD
Need a PROPER PHP/Mysql Expert to correct / fine tune / debug / correct or re-code the following algorithm in PHP.
--------
I currently have 4 databases :
products database
purchase_orders database
sales_orders database
suppliers database
I have already coded the project but i'm getting the wrong results. (ie : more stock than projected or wrong answers)
So i need someone to either go through the code or re-write in full to solve the following problem :
Be able to provide answers to the following customer request :
Customer needs x amount of product A
Questions :
1 - Is it in stock? Yes - display stock available => This part is ALREADY DONE - DO NOT TOUCH
2 - Is it in stock? No - and purchase order exists
a) When can i have x amount
(check purchase orders, free quantity, check if there's any reserved quantity, check all pending and fullfilled (delivered or collected) sales orders - based on their dates, to calculate free incoming available stock and on *what date* customer can have x amount. This will be the earliest date when customer can have x amount of his product
b) Can i have x amount on x date? This is based on a SPECIFIC date (similar to the above) but the system will need to check the exact stock quantity after considering all stock movements (sales and purchases) on that specific given date, then give an answer to the customer : yes customer can have because we will have y amount
/ No customer can't have because on that date there'll only be y amount. And give the next available possible date when customer can have.
3 - Is it in stock? No - and purchase order DOES NOT exist
Give the due date for next purchase order. => This part is ALREADY DONE - do NOT TOUCH
PLEASE PLEASE PLEASE do not bid, just to bid - you need to take your time to properly understand the algorithm. It looks easy but it's quite tedious - especially with the quantities of stock. When calculating / checking when customer can have his stock, it shouldn't go below 0, meaning customer can't have it. It's not complicated, and should take an expert a day or 2 to complete - Bid accordingly and sensibly - Most of the work is ALREADY done, only fine tuning is required as i must have messed up one part of the code.
Any questions, let us know.
Attached are the databases - and i'll send you the page where most of the code is done.
PLEASE NOTE : IF some values need to be changed in the db let me know because the will get updated frequently. ie : purchase order should have a delivered date or things like that. Let me know of any field missing or any values needing to be modified IF ANY. I may have overlooked it. Thanks
Note : Will be choosing the freelancer today, please bid only if you can complete in 2 days or less. Thanks
Focus on debugging the stock calculation logic to ensure accurate stock projections.
--------
I currently have 4 databases :
products database
purchase_orders database
sales_orders database
suppliers database
I have already coded the project but i'm getting the wrong results. (ie : more stock than projected or wrong answers)
So i need someone to either go through the code or re-write in full to solve the following problem :
Be able to provide answers to the following customer request :
Customer needs x amount of product A
Questions :
1 - Is it in stock? Yes - display stock available => This part is ALREADY DONE - DO NOT TOUCH
2 - Is it in stock? No - and purchase order exists
a) When can i have x amount
(check purchase orders, free quantity, check if there's any reserved quantity, check all pending and fullfilled (delivered or collected) sales orders - based on their dates, to calculate free incoming available stock and on *what date* customer can have x amount. This will be the earliest date when customer can have x amount of his product
b) Can i have x amount on x date? This is based on a SPECIFIC date (similar to the above) but the system will need to check the exact stock quantity after considering all stock movements (sales and purchases) on that specific given date, then give an answer to the customer : yes customer can have because we will have y amount
/ No customer can't have because on that date there'll only be y amount. And give the next available possible date when customer can have.
3 - Is it in stock? No - and purchase order DOES NOT exist
Give the due date for next purchase order. => This part is ALREADY DONE - do NOT TOUCH
PLEASE PLEASE PLEASE do not bid, just to bid - you need to take your time to properly understand the algorithm. It looks easy but it's quite tedious - especially with the quantities of stock. When calculating / checking when customer can have his stock, it shouldn't go below 0, meaning customer can't have it. It's not complicated, and should take an expert a day or 2 to complete - Bid accordingly and sensibly - Most of the work is ALREADY done, only fine tuning is required as i must have messed up one part of the code.
Any questions, let us know.
Attached are the databases - and i'll send you the page where most of the code is done.
PLEASE NOTE : IF some values need to be changed in the db let me know because the will get updated frequently. ie : purchase order should have a delivered date or things like that. Let me know of any field missing or any values needing to be modified IF ANY. I may have overlooked it. Thanks
Note : Will be choosing the freelancer today, please bid only if you can complete in 2 days or less. Thanks
Focus on debugging the stock calculation logic to ensure accurate stock projections.