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
85
backend/src/backend/App.js
+ 117
− 177
@@ -4,21 +4,51 @@ const db = require('./DatabaseConnection')
@@ -4,21 +4,51 @@ 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) => {
app.post('/liste-horaires', (req, res) => {
 
let date = formatDate(req.body.date);
 
console.log(date)
 
db.executeQuery("select Heure from rendez_vous WHERE Date = '"+date+"' AND Id_Adresse = "+req.body.address).then((result) => {
 
console.log(result);
 
res.status(200).send(result);
 
}).catch((err) => {
 
res.status(500).send(err);
 
});
 
})
 
 
app.post('/prendre-rdv', (req, res) => {
let date = formatDate(req.body.date);
let date = formatDate(req.body.date);
let id_address = req.body.id_address;
selectAppointmentWithDate(date,req.body.address, 'Heure, Id_Adresse').then((result) => {
 
for(let i = 0; i < result.length; i++) {
 
if(result[i].Heure == req.body.hour && result[i].Id_Adresse == req.body.address) {
 
res.status(400).send("Horaire déjà pris");
 
return;
 
}
 
}
db.executeQuery("SELECT * FROM Rendez_Vous where Id_Adresse = " + id_address + " and Date = " + date)
let hour = req.body.hour;
 
let client = req.body.client;
 
let address = req.body.address;
 
db.updateQuery("INSERT INTO Rendez_Vous (Date, Heure, Description, Id_Client, Id_Adresse) VALUES ('" + date + "', STR_TO_DATE('" + hour + "', '%H:%i'), NULL, '" + client + "', '" + address + "')")
 
.then(() => {
 
res.status(200).send("Rendez-vous pris");
 
})
 
.catch((err) => {
 
console.log(err);
 
res.status(500).send(err);
 
});
 
}).catch((err) => {
 
res.status(500).send(err);
 
});
 
})
 
 
app.get('/liste-magasins', (req, res) => {
 
db.executeQuery("SELECT * FROM Adresse")
.then((result) => {
.then((result) => {
console.log(result);
console.log(result);
res.status(200).send(result);
res.status(200).send(result);
@@ -28,71 +58,70 @@ app.get('/liste-rdv-magasin', (req, res) => {
@@ -28,71 +58,70 @@ app.get('/liste-rdv-magasin', (req, res) => {
});
});
})
})
app.listen(port, () => {
app.post('/liste-rdv', (req, res) => {
console.log(`Example app listening on port ${port}`)
let client_id = req.body.client_id
 
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) => {
 
for (let i = 0; i < result.length; i++) {
 
console.log(formatDate(result[i].Date))
 
result[i].Date = formatDate(result[i].Date);
 
}
 
console.log(result);
 
res.status(200).send(result);
 
})
 
.catch((err) => {
 
console.log(err);
 
res.status(500).send(err);
 
});
})
})
app.post('/liste-horaires', (req, res) => {
let date = formatDate(req.body.date);
console.log(date)
db.executeQuery("select Heure from rendez_vous WHERE Date = '"+date+"' AND Id_Adresse = "+req.body.address).then((result) => {
console.log(result);
res.status(200).send(result);
}).catch((err) => {
res.status(500).send(err);
});
})
app.get('/prendre-rdv', (req, res) => {
app.post('/login', (req, res) => {
selectAppointmentWithDate(req.body.date, 'Heure').then((result) => {
let mail = req.body.mail;
res.status(200).send(result);
let password = req.body.password;
}).catch((err) => {
console.log("login request")
res.status(500).send(err);
console.log(mail)
});
console.log(password)
})
app.post('/prendre-rdv', (req, res) => {
db.executeQuery("SELECT * FROM Client WHERE Mail = '" + mail + "' AND Password = '" + password + "'")
selectAppointmentWithDate(req.body.date, 'Heure, Id_Adresse').then((result) => {
.then((result) => {
for (let i = 0; i < result.length; i++) {
console.log(result.length)
if (result[i].Heure == req.body.hour && result[i].Id_Adresse == req.body.address) {
if(result.length > 0){
res.status(400).send("Horaire déjà pris");
res.status(200).send(result);
return;
} else {
}
res.status(204).send("Les informations de connection sont pas les bonnes");
}
}
let date = formatDate(req.body.date);
})
let hour = req.body.hour;
.catch((err) => {
let client = req.body.client;
console.log(err);
let address = req.body.address;
});
db.updateQuery("INSERT INTO Rendez_Vous (Date, Heure, Description, Id_Client, Id_Adresse) VALUES ('" + date + "', STR_TO_DATE('" + hour + "', '%H:%i'), NULL, '" + client + "', '" + address + "')")
.then(() => {
res.status(200).send("Rendez-vous pris");
})
.catch((err) => {
console.log(err);
res.status(500).send(err);
});
}).catch((err) => {
res.status(500).send(err);
});
})
})
app.get('/liste-magasins', (req, res) => {
db.executeQuery("SELECT * FROM Adresse")
app.post('/inscription', (req, res) => {
.then((result) => {
console.log("inscription request")
console.log(result);
console.log(req.body)
res.status(200).send(result);
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, '"
.catch((err) => {
+ req.body.nom + "', '" + req.body.prenom + "', '" + req.body.email + "', '" + req.body.password + "', '"
res.status(500).send(err);
+ date + "', '" + req.body.sexe + "', '" + req.body.taille + "', '"
});
+ req.body.poids + "', '" + req.body.pointure + "', '0')")
 
.then(() => {
 
res.status(200).send("Le client à bien été ajouté.");
 
})
 
.catch((err) => {
 
console.log(err)
 
res.status(500).send(err);
 
});
})
})
app.delete('/supp-rendez-vous', (req, res) => {
app.post('/supp-rendez-vous', (req, res) => {
let date = formatDate(req.body.date);
let date = formatDate(req.body.date);
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']))
 
if(formatDate(result[0]['Date']) >= date){
db.executeQuery("DELETE FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv)
db.executeQuery("DELETE FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv)
.then(r => {
.then(r => {
console.log(r)
console.log(r)
@@ -110,134 +139,45 @@ app.delete('/supp-rendez-vous', (req, res) => {
@@ -110,134 +139,45 @@ app.delete('/supp-rendez-vous', (req, res) => {
})
})
})
})
app.post('/ajouter-conseil', (req, res) => {
let id_rdv = req.body.idrdv;
let description = req.body.description;
let id_article = req.body.idarticle
let has_bought = req.body.hasbought;
if(typeof id_article === 'undefined'){
db.executeQuery('INSERT INTO conseil (Description, id_RDV) VALUES ("' + description + '", "' + id_rdv + '")')
.then(() => {
res.status(200).send("Le conseil à bien été ajouté.");
})
.catch((err) => {
res.status(500).send(err);
});
} else {
if(typeof has_bought === 'undefined'){
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) => {
res.status(500).send(err);
});
}
})
app.post('/inscription', (req, res) => {
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.date_naissance + "', '" + req.body.sexe + "', '" + req.body.taille + "', '"
+ req.body.poids + "', '" + req.body.pointure + "', '0')")
.then(() => {
res.status(200).send("Le client à bien été ajouté.");
})
.catch((err) => {
res.status(500).send(err);
});
})
app.put('/update-conseil', (req, res) => {
app.listen(port, () => {
let id_conseil = req.body.idconseil;
console.log(`Example app listening on port ${port}`)
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) => {
function selectAppointmentWithDate(date,address, column = "*") {
let realDate = formatDate(req.body.realdate);
return db.executeQuery("SELECT " + column + " FROM Rendez_Vous WHERE DATE=" + date + " AND Id_Adresse="+address)
let newDate = formatDate(req.body.newdate);
.then((result) => {
let heure = formatHour(req.body.heure);
console.log(result)
db.executeQuery("SELECT * FROM rendez_vous WHERE Id_RDV = " + req.body.idrdv + " AND Id_Client = " + req.body.idclient)
for (let i = 0; i < result.length; i++) {
.then((result) => {
if(formatDate(result[0]['Date']) > date){
result[i].Heure = formatHour(result[i].Heure);
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'])
}
.then(r => {
console.log(result);
console.log(r)
return result;
res.status(200).send(r);
})
})
.catch((err) => {
.catch((err) => {
console.log(err);
res.status(500).send(err);
return err;
})
});
} else {
res.status(500).send("Impossible de modifier un rendez-vous déjà passé.");
}
})
.catch((err) => {
res.status(500).send("Aucun rendez-vous à modifier");
})
})*/
function selectAppointmentWithDate(date, column = "*") {
return db.executeQuery("SELECT " + column + " FROM Rendez_Vous WHERE DATE='" + date + "'")
.then((result) => {
for (let i = 0; i < result.length; i++) {
result[i].Heure = formatHour(result[i].Heure);
}
console.log(result);
return result;
})
.catch((err) => {
console.log(err);
return err;
});
}
}
function formatDate(date) {
function formatDate(date) {
var d = new Date(date),
var d = new Date(date),
month = '' + (d.getMonth() + 1),
month = '' + (d.getMonth() + 1),
day = '' + d.getDate(),
day = '' + d.getDate(),
year = d.getFullYear();
year = d.getFullYear();
if (month.length < 2)
if (month.length < 2)
month = '0' + month;
month = '0' + month;
if (day.length < 2)
if (day.length < 2)
day = '0' + day;
day = '0' + day;
return [year, month, day].join('-');
return [year, month, day].join('-');
}
}
function formatHour(hour) {
function formatHour(hour) {
var hours = hour.substring(0, 2);
var hours = hour.substring(0, 2);
var minutes = hour.substring(3, 5);
var minutes = hour.substring(3, 5);
return hours + ":" + minutes;
return hours + ":" + minutes;
}
}
\ No newline at end of file