Your assignment is to create and fetch sale orders
Add sale order api should have these parameter to add order:
customerId, orderNo, companyId, orderDate, shipmentDate, customerNote, total, taxes, grandTotal, list_of_items(productId, quantity, unitPrice, tax, amount), status(default pending), paymentStatus, packedStatus, shipStatus, deliveryStatus, fromQuotation
Response expected status:0 for failed & status: 1 for success
After creating add-sale-order API then create getSaleOrders API
Order detail with list on items in order.
Response expected [list of order containing list of items]
Make these two APIs till evening. Technologies should be NodeJs & MySQL Database. You're free to use any library or framework.
You need to submit your code and schema of your database & we are expecting you to submit this assignment till evening.
ENDPONT
http://localhost:5000/api/v1/order/add
*METHOD * : POST
BODY
{
"customerId":"1",
"companyId":"1",
"orderDate":"12-12-2020",
"orderNumber":"345678",
"shipmentDate":"12-12-2020",
"customerNote":"This is customer note",
"total":"12",
"taxes":"12",
"grandTotal":"12",
"paymentStatus":true,
"packedStatus":true,
"shipStatus":false,
"deliveryStatus":false,
"fromQuotation":"I don't know what is this?",
"items":[
{
"productId":"11",
"quantity":1,
"unitPrice":100,
"tax":10,
"amount":110
},
{
"productId":"1",
"quantity":1,
"unitPrice":100,
"tax":10,
"amount":110
}
]
}
ENDPONT
http://localhost:5000/api/v1/orders
*METHOD * : GET
RESPONSE
{
"status": 1,
"message": "Orders Found",
"data": [
{
"id": 2,
"orderNumber": 345678,
"orderDate": "2020-12-11T18:30:00.000Z",
"shipmentDate": "2020-12-11T18:30:00.000Z",
"customerNote": "This is customer note",
"total": "12",
"taxes": "12",
"grandTotal": "12",
"paymentStatus": true,
"packedStatus": true,
"shipStatus": false,
"deliveryStatus": false,
"fromQuotation": "I don't know what is this?",
"createdAt": "2022-12-22T10:08:17.000Z",
"updatedAt": "2022-12-22T10:08:17.000Z",
"customerId": 1,
"companyId": 1,
"OrderdProducts": [
{
"id": 1,
"quantity": 1,
"unitPrice": 100,
"tax": 10,
"amount": 110,
"createdAt": "2022-12-22T10:08:17.000Z",
"updatedAt": "2022-12-22T10:08:17.000Z",
"orderId": 2
},
{
"id": 2,
"quantity": 1,
"unitPrice": 100,
"tax": 10,
"amount": 110,
"createdAt": "2022-12-22T10:08:17.000Z",
"updatedAt": "2022-12-22T10:08:17.000Z",
"orderId": 2
}
]
}
]
}