app.get('/users/:userId/books/:bookId', function (req, res) {
res.send(req.params)
})await pool.query(`select distinct * from tenders where category = '${category}'`, (error,results,fields) => {
if(error) console.log(error)
resolve(results.map(r => r.creator))
})const { app,static } = require('../modules/app_config')
const { successAccess } = require('../modules/check_page')
const { pool } = require('../modules/mysql')
const { multer,bodyParser } = require('../modules/packages')
app.use(bodyParser.json({limit: '500mb'}));
app.use(bodyParser.urlencoded({limit: '500mb', extended: true}));
let images = []
let Storage = multer.diskStorage({
destination: (req, file, callback) => {
callback(null, `${static}/images/`)
},
filename: (req, file, callback) => {
callback(null, Date.now() + "-" + file.originalname)
images.push( Date.now() + "-" + file.originalname)
}
})
let upload = multer({
storage: Storage
}).array("documents", 4)
app.get('/control-company',successAccess, (req,res) => {
res.sendFile(`${static}/www/control-company.html`)
})
app.post('/create-company',async (req,res) => {
console.log(req.body)
const {
name,
name2,
name3,
email,
skype,
website,
creator
} = req.body
await pool.query(`select * from users where email = '${creator}'`,async (error,results,fields) => {
console.log(`Creator: ${creator} / Result: ${results.map(r => r)}`)
const creator_id = results.map(r => r.id)
const documents = images.toString()
await pool.query(`INSERT INTO the_company SET ?`,{name,name2,name3,email,documents,skype,website,creator_id},(err,res) => {
if(err) console.log(err)
images = []
})
})
return res.redirect('/')
})
app.post('/upload', (req,res) => {
upload(req, res, function(err) {
if (err) {
return console.log("Something went wrong!")
}
console.log("File uploaded sucessfully!")
})
})register.onsubmit = async (e) => {
e.preventDefault()
const form = new FormData(register)
fetch('/upload', {
method: 'POST',
body: form
})
fetch('/create-company', {
method: 'POST',
headers: {
'Content-Type': 'application/json'
},
body:
JSON.stringify({
name: form.get('name'),
name2: form.get('name2'),
name3: form.get('name3'),
email: form.get('email'),
skype: form.get('skype'),
website: form.get('website'),
creator: form.get('creator')
})
})
}