Please enable JavaScript.
Coggle requires JavaScript to display documents.
Models, Routes, /upsert-order - Coggle Diagram
Models
Sku
name
availableStock
currentStock
sizes: [{qty, size}]
description
imageLink
category :star: ref
Users
name
email
password
store :star: ref
role
order_sku
sku :star: ref
order :star: ref
bookDate
returnDate
size
Order
totalBill
name
address
store :star: ref
Category
category
description
Store
name
address
Routes
authentication :checkered_flag:
/sign-up
/sign-in
/sign-out
:black_flag: /isSignedIn
isAuthenticated
:black_flag: isAdmin
store :checkered_flag:
/get-all-stores
/upsert-store
/delete-store
:black_flag: /get-store-detals-by-id
category :checkered_flag:
/get-all-category
/upsert-category
/delete-category
:black_flag: /get-category-details-by-id
users :checkered_flag:
/get-all-users
:black_flag: /get-user-detaill-by-id
/update-user
/delete-user
sku :checkered_flag:
/upsert-sku
/get-sku-details-by-id
/delete-sku
/get-all-sku
order :checkered_flag:
/get-all-orders
/upsert-order
/delete-orders
:black_flag: /get-order-details-by-id
order_sku
/upsert-details
/get-details-by-order-id
/upsert-order
Create a Temporary Order ID
Check All the SKUs are available or not for Selected Date
Available
Insert one by one SKU with Temporary Order ID in
order_sku
Table
Successful
Insert In Record in
Order
Table.
Replace
Temporary Order ID
with
Order_ID
in
order_sku
Table.
Success
throw Exception
throw Exception
throw Exception
Not Available
throw Exception