const connection = require("./conf");
const express = require("express");
const app = express();
const port = 3000;

const bodyParser = require("body-parser");
app.use(bodyParser.json());
app.use(
  bodyParser.urlencoded({
    extended: true
  })
);

app.get("/", (req, res) => {
  res.send("Welcome Home !");
});

app.get("/api/movie", (req, res) => {
  db.query("SELECT * from movies", (err, results) => {
    if (err) {
      res.status(500).send("Erreur lors de la récupération d'un film");
    } else {
      res.json(results);
    }
  });
});

app.get("/api/movie/name", (req, res) => {
  db.query("SELECT name from movies", (err, results) => {
    if (err) {
      res.status(500).send("Erreur lors de la récupération des noms des films");
    } else {
      res.json(results);
    }
  });
});

app.get("/api/movie/:name", (req, res) => {
  const name = req.params.name;

  db.query("SELECT * FROM movies WHERE name= ?", name, (err, results) => {
    if (err) {
      res.status(500).send("Erreur lors de la récupération du film");
    } else {
      res.json(results);
    }
  });
});

app.get("/api/movie/name/:name", (req, res) => {
  const name = req.params.name;

  db.query(`SELECT * FROM movies WHERE name LIKE '${name}%'`, (err, result) => {
    if (err) {
      console.log("Erreur : ", err);
      res.sendStatus(500);
    } else {
      res.json(result);
    }
  });
});

app.get("/api/search/:date", (req, res) => {
  db.query(
    "SELECT * FROM movies WHERE birthdate > ?",
    req.params.date,
    (err, result) => {
      if (err) {
        console.log("Erreur : ", err);
        res.sendStatus(500);
      } else {
        res.json(result);
      }
    }
  );
});

app.get("/api/order", (req, res) => {
  const type = req.query.type;
  const sql =
    type === "desc"
      ? "SELECT * FROM movies ORDER BY age DESC"
      : "SELECT * FROM movies ORDER BY age ASC";
  db.query(sql, (err, result) => {
    if (err) {
      console.log("Erreur : ", err);
      res.sendStatus(500);
    } else {
      res.json(result);
    }
  });
});

app.post("/api/movie/movies", (req, res) => {
  const formData = req.body;

  db.query("INSERT INTO movies SET ?", formData, (err, result) => {
    if (err) {
      console.log("Erreur : ", err);
      res.status(500).send("Erreur lors de l'ajout d'un film");
    } else {
      res.sendStatus(200);
    }
  });
});

app.put("/api/movie/movies/:id", (req, res) => {
  const formData = req.body;
  const idmovies = req.params.id;

  db.query("UPDATE movies SET ? WHERE id=?", [formData, idmovies], err => {
    if (err) {
      console.log(err);
      res.status(500).send("Erreur lors de la sauvegarde d'un film");
    } else {
      res.sendStatus(200);
    }
  });
});

app.put("/api/movie/movies/active/:id", (req, res) => {
  const moviesId = req.params.id;

  db.query("UPDATE movies SET `active` = 1 WHERE id = ?", moviesId, err => {
    if (err) {
      console.log(err);
      res.status(500).send("Erreur lors de la modification d'un film");
    } else {
      res.sendStatus(200);
    }
  });
});

app.delete("/api/movie/:id", (req, res) => {
  const moviesId = req.params.id;

  db.query("DELETE FROM movies WHERE id = ?", moviesId, err => {
    if (err) {
      console.log(err);
      res.status(500).send("Erreur lors de la suppression d'un film");
    } else {
      res.sendStatus(200);
    }
  });
});

app.delete("/api/movie/actif", (req, res) => {
  db.query("DELETE FROM movies WHERE `active` = 0", err => {
    if (err) {
      console.log(err);
      res.status(500).send("Erreur lors de la suppression des films");
    } else {
      res.sendStatus(200);
    }
  });
});