const router = require('express').Router();
const mongojs = require('mongojs');
const db = mongojs('mongodb://ricardocarlim:ric%40123!@ds163680.mlab.com:63680/remuneretech', ['user']);


router.get('/users', function(req, res, next){
  db.users.find((err, users)=>{
    if(err) return next(err);
    return res.json(users);
  });
});

router.get('/users/:id', function(req, res, next){
    db.users.findOne({_id: mongojs.ObjectId(req.params.id)},(err, users)=>{
      if(err) return next(err);
      return res.json(err);
    });
});

router.get('/users/searchByDocument/:id', function(req, res, next){
  db.users.find({Document: req.params.id},(err, users)=>{
    if(err) return next(err);
    return res.json(users);
  });
});

router.post('/users/doLogin', function(req, res, next){
  console.log(req.body.Login);
  console.log(req.body.Password);
  db.users.find({"Login": req.body.Login, "Password": req.body.Password},(err, users)=>{
    if(err) return next(err);
    return res.json(users);
  });
});

router.post('/users', (req, res, next)=>{
  const user = req.body;
  db.users.save(user, (err, user)=>{
    if(err) return next(err);
    return res.json(next);
  });
});

router.delete('/users/:id', (req,res,next)=>{
  db.users.remove({_id: mongojs.ObjectId(req.params.id)}, (err, result)=>{
    if(err) return next(err);
    return res.json(result);
  });
});

router.put('/users/:id', (req,res,next)=>{
  const user = req.body;
  db.users.update({_id: mongojs.ObjectId(req.params.id)},{Name: user.Name, Nasc: user.Nasc, Document: user.Document, Login: user.Login, Password: user.Password}, (err, result)=>{
    if(err) return next(err);
    return res.json(result);
  });
});

module.exports = router;