1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| exports.createCars = function(req,res,next){
let imageUrl = `${req.protocol}://${req.get('host')}/images/${req.file.filename}`
console.log(req.file)
let model = req.body.model
let immatriculation= req.body.immatriculation
let detailsCars = req.body.detailsCars
let price = req.body.price
let categorie = req.body.categorie
let kilometrage = req.body.kilometrage
let passager = req.body.passager
let porte = req.body.porte
let transmission = req.body.transmission
let clim = req.body.clim
let emission = req.body.emission
let bagage = req.body.bagage
// connection.query('INSERT INTO cars SET id_admin= ?, isAdmin= ?, model= ?, immatriculation= ?, imageUrl= ?',[req.params.id_admin,req.params.isAdmin, req.body.model,req.body.immatriculation, imageUrl],(error,results)=>{
connection.query('INSERT INTO cars SET id_admin=?, isAdmin= ?, model= ?,categorie = ?,detailsCars= ?,price=?, immatriculation= ?,imageUrl= ?, kilometrage= ?, passager=?,porte= ?,transmission= ?, clim= ?,emission= ?, bagage= ?',[1,1,model,categorie,detailsCars,price,immatriculation,imageUrl, kilometrage,passager,porte,transmission,clim,emission,bagage],(error,results)=>{
//console.log(model)
if(results){
console.log(results)
res.status(201).json({results})
}else{
res.status(401).json({error: error, message:'la publication de la voiture à échouée!'})
console.log({error: error})
}
})
} |