Order MicroService

Order MicroService for Grizzly Store
🐼🐼🐼🐼🐼 🐼🐼🐼🐼🐼 🐼🐼🐼🐼🐼

Database Structure

• order_sum
  • order_id [int][FK][PK]
  • status [string]
    • pending
    • complete
    • Processing *
    • Closed *
    • Canceled *
    • On Hold *
  • total_price [double]
  • email [int]
  
  
• order_line
  • orderline_id [int][PK]
  • product_id [int]
  • qty [int]
  • unit_price [double]
  • sub_total [double]
  • order_id [int][FK]

API Functionality Requirement

• Initial Stage(Initial Deploy)

• getAllOrder (String email);
• getOrderByOrderId (int orderId);
• getOrderByStatus (String email, String status);
• getCartNum (String email)
• deleteOrderById (int orderId);
• addProduct (String email, OrderLine orderline);
  • Sub: addOrder (Order order);
• delProduct (String email, OrderLine orderline);
  • Sub: deleteOrder (Order order);
• updateOrderStatus (String status,int orderId);

• Updating Statge(Further polish)

• Error handle
• Update Multiple Order info
  • QTY
  • Something
  • Something
• Payment validation ???