pichaya_om

Report Stock Logic

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