api.js

var express = require('express');
var router = express.Router();
var pool =  require('./pool');
var upload = require('./multer');

const bcrypt = require('bcrypt');
const saltRounds = 10;
const salt = bcrypt.genSaltSync(saltRounds);



router.post('/validate',(req,res)=>{
    let body = req.body;
    console.log(req.body)
    pool.query(`select * from users where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
      if(err) throw err;
      else if(result[0]) res.json({status : 500 , msg : 'User Found'});
      else res.json({status : 200 ,msg:'User Not Found'});
    })
})


router.post('/sign-up',(req,res)=>{
    let body = req.body;
    var today = new Date();
    var dd = String(today.getDate()).padStart(2, '0');
    var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
    var yyyy = today.getFullYear();

    today = mm + '/' + dd + '/' + yyyy;

    body['created_date']  = today;
    body['password'] = bcrypt.hashSync(req.body.password, salt); 

    pool.query(`insert into users set ?`,body,(err,result)=>{
        err ? res.json({status:500 , msg : 'error occured' , description : err}) : res.json({status:200 , msg : 'success' , description : result})
    })
})


router.post('/login',(req,res)=>{
  let body = req.body;
  console.log(req.body)
    pool.query(`select * from users where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
        if(err) throw err;
        else if(result[0]) {
            let password = result[0].password;
            let checkpassword = bcrypt.compareSync(req.body.password, password);
            if(checkpassword == true) res.json({status : 200 ,msg:'User Found' , description : result})
            else res.json({status : 500 ,msg:'Incorrect Password' , description : 'Password Not Match'})
        }
        else res.json({status : 500 ,msg:'Email or Number Not Found' , description : 'Email or Number Not Exists'});
      })
})


router.get('/category',(req,res)=>{
    pool.query(`select * from category where market_place_id = '${req.query.market_place_id}' order by name`,(err,result)=>{
        if(err) throw err;
        else res.json({status:200 , result})
    })
})





  router.get('/get-products',(req,res)=>{
    pool.query(`select * from products where vendorid = '${req.query.vendorid}'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })



  router.get('/best-deals',(req,res)=>{
    pool.query(`SELECT *, SQRT(
      POW(69.1 * (latitude - '${req.query.latitude}'), 2) +
      POW(69.1 * (longitude - '${req.query.longitude}') * COS(latitude / 57.3), 2)) AS distance
  FROM products having distance <= 60000000000 ORDER BY discount desc , distance;`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })


router.get('/single-vendor-details',(req,res)=>{
    var query = `select * from vendor where id = '${req.query.vendorid}';`
    pool.query(query,(err,result)=>{
      if(err) throw err;
      else res.json({status : 200 ,result});
    })
  
  })  

// get addresses with its usernumber(passed as query)
router.get('/get-address',(req,res)=>{
  // when usernumber not in the query
  if(!req.query.usernumber) {
    return res.status(400).send({
      error: 'usernumber not found in the query'
    })
  }
  pool.query(`select * from address where usernumber = '${req.query.usernumber}'`,(err,result)=>{
    if(err) {
      return res.status(500).send({
        error: err
      })
    }
    if (!result[0]) {
      return res.status(404).send({
        error: 'Address not found'
      })
    }
    return res.status(200).send({
      ...result
    })
  })
}) 

// get specific address with its id
router.get('/get-single-address',(req,res)=>{
  if(!req.query.id) {
    return res.status(400).send({
      error: 'id not found in the query'
    })
  }
  pool.query(`select * from address where id = '${req.query.id}'`,(err,result)=>{
    if(err) {
      return res.status(500).send({
        error: err
      })
    }
    return res.status(200).send({
      ...result[0]
    })
  })
})

// saves the address to address table
// columns - place_name, decription, tag, townid, districtid, zoneid, usernumber
router.post('/save-address',(req,res)=>{
  if(Object.keys(req.body).length === 0) {
    return res.status(400).send({
      error: 'No data in request body'
    })
  }
  pool.query(`insert into address set ?`,req.body,(err)=>{
    if(err) {
      return res.status(500).send({
        error: err
      })
    }
    return res.status(200).send({
      status: 'Address added Successfully'
    })
  })
})
  
router.put('/update-address', (req, res) => {
  if (!req.body.id) {
    return res.status(400).send({
      error: 'ID not found in the body'
    })
  }
  pool.query(`update address set ? where id = ?`, [req.body, req.body.id], (err, result) => {
    if(err) {
        return res.status(500).send({
          error: err
        })
    }
    return res.status(200).send({
      status: 'Address updated Successfully'
    })
  })
})

// delete address with its id
router.delete('/delete-address',(req,res)=>{
  if (!req.query.id) {
    return res.status(400).send({
      error: 'id not in the request body'
    })
  }
  pool.query(`delete from address where id = '${req.query.id}'`,(err,result)=>{
    if(err) {
      return res.status(500).send({
        error: err
      })
    }
    if(result.affectedRows === 0) {
      return res.status(404).send({
        error: `no address with id-${req.query.id} to delete`
      })
    }
    return res.status(200).send({
      status: `address-${req.query.id} deleted`,
    })
  })
})
  

  router.post("/cart-handler", (req, res) => {
    let body = req.body
    console.log(req.body)
    if (req.body.quantity == "0" || req.body.quantity == 0) {
    pool.query(`delete from cart where booking_id = '${req.body.booking_id}' and  usernumber = '${req.body.usernumber}'`,(err,result)=>{
        if (err) throw err;
        else {
          res.json({
            status:200,
            msg: "updated sucessfully",
          });
        }
    })
    }
    else {
        pool.query(`select oneprice from cart where booking_id = '${req.body.booking_id}' and  categoryid = '${req.body.categoryid}' and usernumber = '${req.body.usernumber}' `,(err,result)=>{
            if (err) throw err;
            else if (result[0]) {
               // res.json(result[0])
                pool.query(`update cart set quantity = ${req.body.quantity} , price = ${result[0].oneprice}*${req.body.quantity}  where booking_id = '${req.body.booking_id}' and categoryid = '${req.body.categoryid}' and usernumber = '${req.body.usernumber}'`,(err,result)=>{
                    if (err) throw err;
                    else {
                        res.json({
                          status:200,
                          msg: "updated sucessfully",
                        });
                      }

                })
            }
            else {
                body['oneprice'] = req.body.price
              body["price"] = (req.body.price)*(req.body.quantity)
          
                 pool.query(`insert into cart set ?`, body, (err, result) => {
                 if (err) throw err;
                 else {
                   res.json({
                     status:200,
                     msg: "updated sucessfully",
                   });
                 }
               });

            }

        })
    }

  })


router.post("/mycart", (req, res) => {
    console.log(req.body)
       var query = `select c.*,(select s.name from products s where s.id = c.booking_id) as servicename
       ,(select s.image from products s where s.id = c.booking_id) as productlogo,
       (select s.quantity from products s where s.id = c.booking_id) as productquantity
       from cart c where c.usernumber = '${req.body.number}';`
       var query1 = `select count(id) as counter from cart where usernumber = '${req.body.number}';`
       var query2 = `select sum(c.price) as total_ammount from cart c where c.quantity <= (select p.quantity from products p where p.id = c.booking_id ) and  c.usernumber = '${req.body.number}' ;`
       var query3 = `select c.*,(select s.name from products s where s.id = c.booking_id) as servicename
       ,(select s.image from products s where s.id = c.booking_id) as productlogo,
       (select s.quantity from products s where s.id = c.booking_id) as productquantity,
       (select s.small_description from products s where s.id = c.booking_id) as productsmalldescription
   
         
       from cart c where c.quantity <= (select p.quantity from products p where p.id = c.booking_id ) and c.usernumber = '${req.body.number}' ;`
       var query4 = `select count(id) as counter from cart c where c.quantity <= (select p.quantity from products p where p.id = c.booking_id ) and c.usernumber = '${req.body.number}';`
       pool.query(query+query1+query2+query3+query4, (err, result) => {
         if (err) throw err;
         else if (result[0][0]) {
           req.body.mobilecounter = result[1][0].counter;
           console.log("MobileCounter", req.body.mobilecounter);
           res.json(result);
         } else
           res.json({
             status:200,
             msg: "empty cart",
           });
       });
   
   });



   router.post('/order-now',(req,res)=>{
    let body = req.body;
  console.log('body',req.body)
    let cartData = req.body
  
  
  //  console.log('CardData',cartData)
  
     body['status'] = 'pending'
      
  
    var today = new Date();
  var dd = today.getDate();
  
  var mm = today.getMonth()+1; 
  var yyyy = today.getFullYear();
  if(dd<10) 
  {
    dd='0'+dd;
  } 
  
  if(mm<10) 
  {
    mm='0'+mm;
  } 
  today = yyyy+'-'+mm+'-'+dd;
  
  
  body['date'] = today
  
  
  
    var randomChars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
    var result = '';
    for ( var i = 0; i < 12; i++ ) {
        result += randomChars.charAt(Math.floor(Math.random() * randomChars.length));
    }
   orderid = result;
  
  
   
  
  
   pool.query(`select * from cart where usernumber = '${req.body.usernumber}'`,(err,result)=>{
       if(err) throw err;
       else {
  
       let data = result
  
       for(i=0;i<result.length;i++){
        data[i].name = req.body.name
        data[i].date = today
        data[i].orderid = orderid
        data[i].status = 'pending'
        data[i].number = req.body.number
        data[i].usernumber = req.body.usernumber
        data[i].payment_mode = 'cash'
        data[i].address = req.body.address
        data[i].id = null
  
  
       }
  
  
  
  
  for(i=0;i<data.length;i++) {
   let j = i;
   pool.query(`insert into booking set ?`,data[i],(err,result)=>{
           if(err) throw err;
           else if(result){
  
  // console.log('afyeri',j);
  
  
  pool.query(`update products set quantity = quantity - ${data[j].quantity} where id = '${data[j].booking_id}'`,(err,result)=>{
   if(err) throw err;
   else {
  console.log(data[j].quantity);
   }
  
  })
  
           }
      })
  }
  
  
    
  
  
  pool.query(`delete from cart where usernumber = '${req.body.usernumber}'`,(err,result)=>{
    if(err) throw err;
    else {
  
      res.json({
        status:200,
        msg : 'success'
    })
  
    }
  })
  
  
       }
   })
  
   
  })


  // start here 

  router.get('/profile',(req,res)=>{
    pool.query(`select * from users where number = '${req.query.number}'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })

  router.post('/update-profile',upload.single('image'), (req, res) => {
    console.log('data',req.body)
    let body = req.body

    if(req.file){
    body['image'] = req.file.filename;
    }

    pool.query(`update users set ? where id = ?`, [req.body, req.body.id], (err, result) => {
        if(err) {
            res.json({
                status:500,
                type : 'error',
                description:err
            })
        }
        else {
            res.json({
                status:200,
                type : 'success',
                description:'successfully update'
            })
  
            
        }
    })
  })

  router.get('/notification',(req,res)=>{
    pool.query(`select * from notification where number = '${req.query.number}' and type = '${req.query.type}'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })


  router.get('/favourite-restaurant',(req,res)=>{
    pool.query(`select f.*,
    (select v.name  from vendor v where v.id = f.typeid) as vendorname,
    (select v.image from vendor v where v.id = f.typeid) as vendorimage,
    (select v.rating from vendor v where v.id = f.typeid) as vendorrating,
    (select v.address from vendor v where v.id = f.typeid) as vendoraddress
    from favourite f where f.number = '${req.query.number}' and f.type = 'favourite_restaurant'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })


  router.get('/favourite-food',(req,res)=>{
    pool.query(`select f.*,
    (select v.name  from vendor v where v.id = f.typeid) as productsname,
    (select v.image  from vendor v where v.id = f.typeid) as productsimage,
    (select v.price  from vendor v where v.id = f.typeid) as productsprice,
    (select c.name from category where c.id = (select v.categoryid from vendor v where v.id = f.typeid)) as productscategory
    from products f where f.number = '${req.query.number}' and f.type = 'favourite_food'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })

 
  router.get('/ongoing-order',(req,res)=>{
    pool.query(`select f.*,
    (select v.name  from products v where v.id = f.booking_id) as productsname,
    (select v.image  from products v where v.id = f.booking_id) as productsimage,
    (select v.price  from products v where v.id = f.booking_id) as productsprice
    from booking f where f.number = '${req.query.number}' and status != 'completed'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })
  
  
  router.get('/completed-order',(req,res)=>{
    pool.query(`select f.*,
    (select v.name  from products v where v.id = f.booking_id) as productsname,
    (select v.image  from products v where v.id = f.booking_id) as productsimage,
    (select v.price  from products v where v.id = f.booking_id) as productsprice
    from booking f where f.number = '${req.query.number}' and status = 'completed'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })


  router.get('/single-order',(req,res)=>{
    pool.query(`select f.*,
    (select v.name  from products v where v.id = f.booking_id) as productsname,
    (select v.image  from products v where v.id = f.booking_id) as productsimage,
    (select v.price  from products v where v.id = f.booking_id) as productsprice
    from booking f where f.id = '${req.query.id}'`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })

  router.get('/offers',(req,res)=>{
    pool.query(`select * from offers where vendorid = '${req.query.vendorid}' order by id desc`,(err,result)=>{
      if(err) throw err;
      else res.json({status:200,result})
    })
  })


  // user api end here 

  
  // vendor api starts

  router.post('/vendor-validate',(req,res)=>{
    let body = req.body;
    console.log(req.body)
    pool.query(`select * from vendor where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
      if(err) throw err;
      else if(result[0]) res.json({status : 500 , msg : 'User Found'});
      else res.json({status : 200 ,msg:'User Not Found'});
    })
})


router.post('/vendor-sign-up',(req,res)=>{
    let body = req.body;
    var today = new Date();
    var dd = String(today.getDate()).padStart(2, '0');
    var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
    var yyyy = today.getFullYear();

    today = mm + '/' + dd + '/' + yyyy;

    body['created_date']  = today;
    body['password'] = bcrypt.hashSync(req.body.password, salt); 

    pool.query(`insert into vendor set ?`,body,(err,result)=>{
        err ? res.json({status:500 , msg : 'error occured' , description : err}) : res.json({status:200 , msg : 'success' , description : result})
    })
})


router.post('/vendor-login',(req,res)=>{
    let body = req.body;
    pool.query(`select * from vendor where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
        if(err) throw err;
        else if(result[0]) {
            let password = result[0].password;
            let checkpassword = bcrypt.compareSync(req.body.password, password);
            if(checkpassword == true) res.json({status : 200 ,msg:'User Found' , description : result})
            else res.json({status : 500 ,msg:'Incorrect Password' , description : 'Password Not Match'})
        }
        else res.json({status : 500 ,msg:'Email or Number Not Found' , description : 'Email or Number Not Exists'});
      })
})

router.get('/vendor-profile',(req,res)=>{
  pool.query(`select * from vendor where number = '${req.query.number}'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})

router.post('/update-vendor-profile', (req, res) => {
  console.log('data',req.body)
  pool.query(`update vendor set ? where id = ?`, [req.body, req.body.id], (err, result) => {
      if(err) {
          res.json({
              status:500,
              type : 'error',
              description:err
          })
      }
      else {
          res.json({
              status:200,
              type : 'success',
              description:'successfully update'
          })

          
      }
  })
})


router.post('/vendor/update-image',upload.fields([{ name: 'image', maxCount: 1 }, { name: 'id_proof', maxCount: 8 }]), (req, res) => {
  let body = req.body;
  body['image'] = req.files.image[0].filename;
  body['id_proof'] = req.files.id_proof[0].filename;



pool.query(`update vendor set ? where id = ?`, [req.body, req.body.id], (err, result) => {
      if(err) {
          res.json({
              status:500,
              type : 'error',
              description:err
          })
      }
      else {
          res.json({
              status:200,
              type : 'success',
              description:'successfully update'
          })

      }
  })


})


router.get('/vendor-dashboard',(req,res)=>{
  var query = `select count(id) as total_products from products where vendorid = '${req.query.vendorid}';`
  var query1 = `select sum(quantity) as total_stock from products where vendorid = '${req.query.vendorid}';`
  pool.query(query+query1,(err,result)=>{
    if(err) throw err;
    else res.json(result);
  })
})


router.post('/save-menu',(req,res)=>{
  let body = req.body;
  console.log('body h',req.body)
  pool.query(`insert into menu set ?`,body,(err,result)=>{
      if(err) throw err;
      else res.json({
          msg : 'success'
      })
  })
})



router.get('/get-menu',(req,res)=>{
  pool.query(`select * from menu where vendorid = '${req.query.vendorid}'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/delete-menu',(req,res)=>{
  pool.query(`delete from menu where id = '${req.query.id}'`,(err,result)=>{
    if(err) throw err;
    else res.json({msg:'success'})
  })
})


router.post('/save-products',(req,res)=>{
  let body = req.body;
  console.log('body h',req.body)
  pool.query(`insert into products set ?`,body,(err,result)=>{
      if(err) throw err;
      else res.json({
          msg : 'success'
      })
  })
})


router.get('/get-products',(req,res)=>{
  pool.query(`select * from products where vendorid = '${req.query.vendorid}'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})
  

router.get('/delete-products',(req,res)=>{
  pool.query(`delete from products where id = '${req.query.id}'`,(err,result)=>{
    if(err) throw err;
    else res.json({msg:'success'})
  })
})


router.get('/get-offers',(req,res)=>{
  pool.query(`select * from offers where vendorid = '${req.query.vendorid}' order by id desc`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/vendor-ongoing-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.vendorid = '${req.query.vendorid}' and status != 'completed'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/vendor-completed-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.vendorid = '${req.query.vendorid}' and status = 'completed'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/vendor-new-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.vendorid = '${req.query.vendorid}' and status = 'pending'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.post('/accept-order', (req, res) => {
  console.log('data',req.body)
  pool.query(`update booking set ? where id = ?`, [req.body, req.body.id], (err, result) => {
      if(err) {
          res.json({
              status:500,
              type : 'error',
              description:err
          })
      }
      else {
          res.json({
              status:200,
              type : 'success',
              description:'successfully update'
          })

          
      }
  })
})


// vendor api ends 


// delivery api starts 


router.post('/delivery-validate',(req,res)=>{
  let body = req.body;
  console.log(req.body)
  pool.query(`select * from delivery where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
    if(err) throw err;
    else if(result[0]) res.json({status : 500 , msg : 'User Found'});
    else res.json({status : 200 ,msg:'User Not Found'});
  })
})


router.post('/delivery-sign-up',(req,res)=>{
  let body = req.body;
  var today = new Date();
  var dd = String(today.getDate()).padStart(2, '0');
  var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
  var yyyy = today.getFullYear();

  today = mm + '/' + dd + '/' + yyyy;

  body['created_date']  = today;
  body['password'] = bcrypt.hashSync(req.body.password, salt); 

  pool.query(`insert into delivery set ?`,body,(err,result)=>{
      err ? res.json({status:500 , msg : 'error occured' , description : err}) : res.json({status:200 , msg : 'success' , description : result})
  })
})


router.post('/delivery-login',(req,res)=>{
  let body = req.body;
  pool.query(`select * from delivery where ${Object.keys(body)[0].toString()} = '${Object.values(body)[0]}'`,(err,result)=>{
      if(err) throw err;
      else if(result[0]) {
          let password = result[0].password;
          let checkpassword = bcrypt.compareSync(req.body.password, password);
          if(checkpassword == true) res.json({status : 200 ,msg:'User Found' , description : result})
          else res.json({status : 500 ,msg:'Incorrect Password' , description : 'Password Not Match'})
      }
      else res.json({status : 500 ,msg:'Email or Number Not Found' , description : 'Email or Number Not Exists'});
    })
})

router.get('/delivery-profile',(req,res)=>{
pool.query(`select * from delivery where number = '${req.query.number}'`,(err,result)=>{
  if(err) throw err;
  else res.json(result)
})
})

router.post('/update-delivery-profile', (req, res) => {
console.log('data',req.body)
pool.query(`update delivery set ? where id = ?`, [req.body, req.body.id], (err, result) => {
    if(err) {
        res.json({
            status:500,
            type : 'error',
            description:err
        })
    }
    else {
        res.json({
            status:200,
            type : 'success',
            description:'successfully update'
        })

        
    }
})
})


router.post('/delivery/update-image',upload.single('image'), (req, res) => {
let body = req.body;
body['image'] = req.file.filename;



pool.query(`update delivery set ? where id = ?`, [req.body, req.body.id], (err, result) => {
    if(err) {
        res.json({
            status:500,
            type : 'error',
            description:err
        })
    }
    else {
        res.json({
            status:200,
            type : 'success',
            description:'successfully update'
        })

    }
})


})


router.get('/delivery-ongoing-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.deliveryid = '${req.query.deliveryid}' and status != 'completed'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/delivery-completed-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.deliverid = '${req.query.deliveryid}' and status = 'completed'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.get('/delivery-new-order',(req,res)=>{
  pool.query(`select f.*,
  (select v.name  from products v where v.id = f.booking_id) as productsname,
  (select v.image  from products v where v.id = f.booking_id) as productsimage,
  (select v.price  from products v where v.id = f.booking_id) as productsprice
  from booking f where f.deliveryid = '${req.query.deliveryid}' and status = 'pending'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})


router.post('/accept-order', (req, res) => {
  console.log('data',req.body)
  pool.query(`update booking set ? where id = ?`, [req.body, req.body.id], (err, result) => {
      if(err) {
          res.json({
              status:500,
              type : 'error',
              description:err
          })
      }
      else {
          res.json({
              status:200,
              type : 'success',
              description:'successfully update'
          })

          
      }
  })
})



router.get('/get-marketplace',(req,res)=>{
  pool.query(`select * from market_place`,(err,result)=>{
    if(err) throw err;
    else res.json(result);
  })
})


router.get('/get-town',(req,res)=>{
  pool.query(`select * from town`,(err,result)=>{
    if(err) throw err;
    else res.json(result);
  })
})

router.get('/get-district',(req,res)=>{
  pool.query(`select * from district`,(err,result)=>{
    if(err) throw err;
    else res.json(result);
  })
})


router.get('/get-zone',(req,res)=>{
  pool.query(`select * from zone`,(err,result)=>{
    if(err) throw err;
    else res.json(result);
  });
});



router.get('/get-banner',(req,res)=>{
  pool.query(`select * from banner order by id desc`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})







// home page api


router.get('/get-all-marketplace',(req,res)=>{
  var query = `SELECT *, SQRT(
      POW(69.1 * (latitude - '${req.query.latitude}'), 2) +
      POW(69.1 * (longitude - '${req.query.longitude}') * COS(latitude / 57.3), 2)) AS distance
  FROM vendor where market_place_id = '${req.query.market_place_id}' having distance <= 60000000000 ORDER BY distance;`
   pool.query(query,(err,result)=>{
  if(err) throw err;
      else res.json({status : 200 ,result})
})
})


router.get('/best-marketplace',(req,res)=>{
  var query = `SELECT *, SQRT(
      POW(69.1 * (latitude - '${req.query.latitude}'), 2) +
      POW(69.1 * (longitude - '${req.query.longitude}') * COS(latitude / 57.3), 2)) AS distance
  FROM vendor where market_place_id = '${req.query.market_place_id}' having distance <= 60000000000 ORDER BY rating desc , distance desc;`
   pool.query(query,(err,result)=>{
  if(err) throw err;
      else res.json({status : 200 ,result})
})
})


router.get('/get-all-marketplace',(req,res)=>{
  pool.query(`select * from product where market_place_id = '${req.query.market_place_id}'`,(err,result)=>{
    if(err) throw err;
    else res.json(result)
  })
})







// home page api ends


// Dummy#Dummy2022#Dummy

// delivery api ends 




module.exports = router;