Skip to content
Snippets Groups Projects

Deleted rpg_app/assets/fonts/Inter-Bold.ttf,...

Merged Deleted rpg_app/assets/fonts/Inter-Bold.ttf,...
mobile_subs_conn into main
Merged julien.debray requested to merge mobile_subs_conn into main
Compare
and
85 files
+ 11992
− 558
Compare changes
  • Side-by-side
  • Inline

Files

backend/src/backend/App.js
+ 117
− 177
@@ -4,34 +4,12 @@ const db = require('./DatabaseConnection')
@@ -4,34 +4,12 @@ const db = require('./DatabaseConnection')
const app = express()
const app = express()
const port = 3001
const port = 3001
const cors = require('cors');
app.use(bodyParser.json());
app.use(bodyParser.json());
app.use(cors({
origin: '*'
}));
app.get('/', (req, res) => {
app.get('/', (req, res) => {
res.send('Hello World!')
res.send('Hello World!')
})
})
app.get('/liste-rdv-magasin', (req, res) => {
let date = formatDate(req.body.date);
let id_address = req.body.id_address;
db.executeQuery("SELECT * FROM Rendez_Vous where Id_Adresse = " + id_address + " and Date = " + date)
.then((result) => {
console.log(result);
res.status(200).send(result);
})
.catch((err) => {
res.status(500).send(err);
});
})
app.listen(port, () => {
console.log(`Example app listening on port ${port}`)
})
app.post('/liste-horaires', (req, res) => {
app.post('/liste-horaires', (req, res) => {
let date = formatDate(req.body.date);
let date = formatDate(req.body.date);
console.log(date)
console.log(date)
@@ -43,24 +21,16 @@ app.post('/liste-horaires', (req, res) => {
@@ -43,24 +21,16 @@ app.post('/liste-horaires', (req, res) => {
});
});
})
})
app.get('/prendre-rdv', (req, res) => {
selectAppointmentWithDate(req.body.date, 'Heure').then((result) => {
res.status(200).send(result);
}).catch((err) => {
res.status(500).send(err);
});
})
app.post('/prendre-rdv', (req, res) => {
app.post('/prendre-rdv', (req, res) => {
selectAppointmentWithDate(req.body.date, 'Heure, Id_Adresse').then((result) => {
let date = formatDate(req.body.date);
 
selectAppointmentWithDate(date,req.body.address, 'Heure, Id_Adresse').then((result) => {
for(let i = 0; i < result.length; i++) {
for(let i = 0; i < result.length; i++) {
if(result[i].Heure == req.body.hour && result[i].Id_Adresse == req.body.address) {
if(result[i].Heure == req.body.hour && result[i].Id_Adresse == req.body.address) {
res.status(400).send("Horaire déjà pris");
res.status(400).send("Horaire déjà pris");
return;
return;
}
}
}
}
let date = formatDate(req.body.date);
let hour = req.body.hour;
let hour = req.body.hour;
let client = req.body.client;
let client = req.body.client;
let address = req.body.address;
let address = req.body.address;
@@ -88,107 +58,71 @@ app.get('/liste-magasins', (req, res) => {
@@ -88,107 +58,71 @@ app.get('/liste-magasins', (req, res) => {
});
});
})
})
app.delete('/supp-rendez-vous', (req, res) => {
app.post('/liste-rdv', (req, res) => {
let date = formatDate(req.body.date);
let client_id = req.body.client_id
db.executeQuery("SELECT * FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv + " AND Id_Client = " + req.body.idclient)
db.executeQuery("SELECT * FROM Rendez_Vous JOIN Adresse on Rendez_Vous.Id_Adresse = Adresse.Id_Adresse WHERE Id_Client = " + client_id + " ORDER BY Date DESC")
.then((result) => {
.then((result) => {
if(formatDate(result[0]['Date']) > date){
for (let i = 0; i < result.length; i++) {
db.executeQuery("DELETE FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv)
console.log(formatDate(result[i].Date))
.then(r => {
result[i].Date = formatDate(result[i].Date);
console.log(r)
res.status(200).send(r);
})
.catch((err) => {
res.status(500).send(err);
})
} else {
res.status(500).send("Impossible de supprimer un rendez-vous déjà passé.");
}
}
 
console.log(result);
 
res.status(200).send(result);
})
})
.catch((err) => {
.catch((err) => {
res.status(500).send("Aucun rendez-vous à annuler");
console.log(err);
})
res.status(500).send(err);
 
});
})
})
app.post('/ajouter-conseil', (req, res) => {
let id_rdv = req.body.idrdv;
let description = req.body.description;
let id_article = req.body.idarticle
app.post('/login', (req, res) => {
let has_bought = req.body.hasbought;
let mail = req.body.mail;
 
let password = req.body.password;
 
console.log("login request")
 
console.log(mail)
 
console.log(password)
if(typeof id_article === 'undefined'){
db.executeQuery('INSERT INTO conseil (Description, id_RDV) VALUES ("' + description + '", "' + id_rdv + '")')
db.executeQuery("SELECT * FROM Client WHERE Mail = '" + mail + "' AND Password = '" + password + "'")
.then(() => {
.then((result) => {
res.status(200).send("Le conseil à bien été ajouté.");
console.log(result.length)
})
if(result.length > 0){
.catch((err) => {
res.status(200).send(result);
res.status(500).send(err);
});
} else {
} else {
if(typeof has_bought === 'undefined'){
res.status(204).send("Les informations de connection sont pas les bonnes");
has_bought = 0;
}
}
db.executeQuery('INSERT INTO conseil (Description, Has_Bought, Id_RDV, Id_Article) VALUES ("' + description + '", "' + has_bought + '", "' + id_rdv + '", "' + id_article + '")')
.then(() => {
res.status(200).send("Le conseil à bien été ajouté.");
})
})
.catch((err) => {
.catch((err) => {
res.status(500).send(err);
console.log(err);
});
});
}
})
})
 
app.post('/inscription', (req, res) => {
app.post('/inscription', (req, res) => {
 
console.log("inscription request")
 
console.log(req.body)
 
let date = formatDate(req.body.date_naissance);
db.executeQuery("INSERT INTO `Client` (`Id_Client`, `Nom`, `Prenom`, `Mail`, `Password`, `Date_Naissance`, `Sexe`, `Taille`, `Poids`, `Pointure`, `IsAdmin`) VALUES (NULL, '"
db.executeQuery("INSERT INTO `Client` (`Id_Client`, `Nom`, `Prenom`, `Mail`, `Password`, `Date_Naissance`, `Sexe`, `Taille`, `Poids`, `Pointure`, `IsAdmin`) VALUES (NULL, '"
+ req.body.nom + "', '" + req.body.prenom + "', '" + req.body.email + "', '" + req.body.password + "', '"
+ req.body.nom + "', '" + req.body.prenom + "', '" + req.body.email + "', '" + req.body.password + "', '"
+ req.body.date_naissance + "', '" + req.body.sexe + "', '" + req.body.taille + "', '"
+ date + "', '" + req.body.sexe + "', '" + req.body.taille + "', '"
+ req.body.poids + "', '" + req.body.pointure + "', '0')")
+ req.body.poids + "', '" + req.body.pointure + "', '0')")
.then(() => {
.then(() => {
res.status(200).send("Le client à bien été ajouté.");
res.status(200).send("Le client à bien été ajouté.");
})
})
.catch((err) => {
.catch((err) => {
 
console.log(err)
res.status(500).send(err);
res.status(500).send(err);
});
});
})
})
app.put('/update-conseil', (req, res) => {
app.post('/supp-rendez-vous', (req, res) => {
let id_conseil = req.body.idconseil;
let date = formatDate(req.body.date);
let description = req.body.description;
let id_article = req.body.idarticle
let has_bought = req.body.hasbought;
if(typeof id_article === 'undefined'){
db.executeQuery('UPDATE conseil SET Description = "' + description + '" WHERE Id_Conseil = "' + id_conseil + '"')
.then(() => {
res.status(200).send("Le conseil à bien été mis à jour.");
})
.catch((err) => {
res.status(500).send(err);
});
} else {
if(typeof has_bought === 'undefined'){
has_bought = 0;
}
db.executeQuery('UPDATE conseil SET Description = "' + description + '", Id_Article = "' + id_article + '", Has_Bought = "' + has_bought + '" WHERE Id_Conseil = "' + id_conseil + '"')
.then(() => {
res.status(200).send("Le conseil à bien été mis à jour.");
})
.catch((err) => {
res.status(500).send(err);
});
}
})
/* app.put('/update-rendez-vous', (req, res) => {
let realDate = formatDate(req.body.realdate);
let newDate = formatDate(req.body.newdate);
let heure = formatHour(req.body.heure);
db.executeQuery("SELECT * FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv + " AND Id_Client = " + req.body.idclient)
db.executeQuery("SELECT * FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv + " AND Id_Client = " + req.body.idclient)
.then((result) => {
.then((result) => {
if(formatDate(result[0]['Date']) > date){
console.log(formatDate(result[0]['Date']))
db.executeQuery("UPDATE rendez_vous SET Date = " + date + " AND Heure = " + heure + " WHERE Id_RDV = " + result[0]['Id_RDV'] + " AND Id_Client = " + result[0]['Id_Client'])
if(formatDate(result[0]['Date']) >= date){
 
db.executeQuery("DELETE FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv)
.then(r => {
.then(r => {
console.log(r)
console.log(r)
res.status(200).send(r);
res.status(200).send(r);
@@ -197,20 +131,26 @@ app.put('/update-conseil', (req, res) => {
@@ -197,20 +131,26 @@ app.put('/update-conseil', (req, res) => {
res.status(500).send(err);
res.status(500).send(err);
})
})
} else {
} else {
res.status(500).send("Impossible de modifier un rendez-vous déjà passé.");
res.status(500).send("Impossible de supprimer un rendez-vous déjà passé.");
}
}
})
})
.catch((err) => {
.catch((err) => {
res.status(500).send("Aucun rendez-vous à modifier");
res.status(500).send("Aucun rendez-vous à annuler");
 
})
})
})
})*/
function selectAppointmentWithDate(date, column = "*") {
app.listen(port, () => {
return db.executeQuery("SELECT " + column + " FROM Rendez_Vous WHERE DATE='" + date + "'")
console.log(`Example app listening on port ${port}`)
 
})
 
 
function selectAppointmentWithDate(date,address, column = "*") {
 
return db.executeQuery("SELECT " + column + " FROM Rendez_Vous WHERE DATE=" + date + " AND Id_Adresse="+address)
.then((result) => {
.then((result) => {
 
console.log(result)
for (let i = 0; i < result.length; i++) {
for (let i = 0; i < result.length; i++) {
 
result[i].Heure = formatHour(result[i].Heure);
result[i].Heure = formatHour(result[i].Heure);
}
}
console.log(result);
console.log(result);