Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- requisition_stocks -> filter by date (12/10/2019) -> get stock_id (โบน โกดังร้าน)
- 1. Get threshold volume of product category -> 25 ตรม.
- 2. Get final_amount(ตรม.) of that req_stocks on that 12/10/2019
- 2.1 Get product id to get all req_stocks
- 2.2 Sum final_amount (กล่อง)
- 2.3 Convert to ตรม. final_amount*area/perbox
- 3. if 1. > 2. show that requisition_stock
Advertisement
Add Comment
Please, Sign In to add comment