Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- app.get('/orders/:pizzeriaID/:status', async (req, res) => {
- try {
- const requestedOrderByPizzeriaID = req.params['pizzeriaID'];
- const requestedOrderByStatus = req.params['status'];
- console.log("STATUS" + requestedOrderByStatus);
- const client = await pool.connect();
- const result = await client.query('SELECT od.orderID, od.pizzaID, od.pizzaOrderQuantity, o.orderName, o.orderAddress, o.orderComment, o.orderPhone, o.orderEmail FROM ordersDetails od NATURAL JOIN pizzeria p NATURAL join orders o WHERE p.pizzeriaID='' + requestedOrderByPizzeriaID + '' AND o.orderStatus='' + requestedOrderByStatus + ''');
- const results = (result) ? result.rows : null;
- res.json({results});
- client.release();
- } catch (err) {
- console.error(err);
- res.send("Error " + err);
- }});
- results:{
- orderid: 1,
- orderDetails: [{
- pizzaid: 1,
- pizzaorderquantity: 2,
- },
- pizzaid: 2,
- pizzaorderquantity: 4,
- },
- pizzaid: 3,
- pizzaorderquantity: 1,
- }],
- ordername: 'Karol Piwnicki',
- orderaddress: 'Rydla 26/30',
- ordercomment: 'Szybko poprosze',
- orderphone: '111-222-333',
- orderemail: 'mail@mail.com' }
Add Comment
Please, Sign In to add comment