| 12
 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})
        }
    })
} | 
Partager