Guest User

Untitled

a guest
Dec 18th, 2018
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. app.get('/orders/:pizzeriaID/:status', async (req, res) => {
  2. try {
  3. const requestedOrderByPizzeriaID = req.params['pizzeriaID'];
  4. const requestedOrderByStatus = req.params['status'];
  5. console.log("STATUS" + requestedOrderByStatus);
  6. const client = await pool.connect();
  7. 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 + ''');
  8. const results = (result) ? result.rows : null;
  9. res.json({results});
  10. client.release();
  11. } catch (err) {
  12. console.error(err);
  13. res.send("Error " + err);
  14. }});
  15.  
  16. results:{
  17. orderid: 1,
  18. orderDetails: [{
  19. pizzaid: 1,
  20. pizzaorderquantity: 2,
  21. },
  22. pizzaid: 2,
  23. pizzaorderquantity: 4,
  24. },
  25. pizzaid: 3,
  26. pizzaorderquantity: 1,
  27. }],
  28. ordername: 'Karol Piwnicki',
  29. orderaddress: 'Rydla 26/30',
  30. ordercomment: 'Szybko poprosze',
  31. orderphone: '111-222-333',
  32. orderemail: 'mail@mail.com' }
Add Comment
Please, Sign In to add comment