Welcome!

This application build in top of laravel 9 and dockerized by sail

Getting Started

1. If not already done, install Docker Compose.
2. Run ./vendor/bin/sail up to state the contender.
3. Use the collection to test the API.

Main Challenges

Placing Order:

• The main challenge here is every order may have multiple products that already have many ingredients which are shared between multiple products, and with concurrent orders, the ingredients will be updated from different orders at the same time
• The first solution we can do is to use DB transaction to guarantee the consistency of the ingredients but this solution will have some challenges and the main one is the high probability of facing a DeadLock Issue because overlap between orders
• My proposed solution is to add every update ingredient in a separate transaction to avoid any DeadLock issues but will increase the proccessing time

Notifying Stock updates:

• The other part is notify when the stock reach limits and that will be done by worker will run every 5m to check if the current stock < init stock, and it was not notified before(by key in db) will send the email.

DB structure

Request life cycle

• \App\Http\Controllers\Order\CreateController will call the Command.
• \Foodics\Order\Command\CreateCommand:
• • will create the order with pending status.
• • Then will call the Service to add the products into the order \Foodics\Order\Service\NewOrder\AddProductToOrder.
• • • Add ProductOrder Row then:
• • • start transaction and select the ingredient then deduct the quantity from it
• • • update ingredient and insert row for ProductOrderIngredient then close the transaction
• • change order status to placed.
• return order_id with 201 http status

Workers Part

• The first one is FailedOrdersCleaner it responsible to check any order that create from 5m and the status still pending, so the worker will return the ingredients to stock again and change order status to canceled.
• The other one is StockChangeNotifier it will check (current_stock + uncompleted orders stock) < (init_stock/2) and notify flag is not flagged then will send email to admin and update notify to be flagged