-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
77 lines (66 loc) · 2.03 KB
/
server.js
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
var mysql = require('mysql');
var express = require('express');
var bodyParser = require('body-parser');
const {google} = require('googleapis');
const keys = require('./apisheets.json');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
database : 'ieee-mf'
});
var app = express();
app.use(bodyParser.urlencoded({extended : true}));
app.use(bodyParser.json());
client = new google.auth.JWT(
keys.client_email,
null,
keys.private_key,
['https://www.googleapis.com/auth/spreadsheets'],
),
client.authorize(function(err, tokens) {
if(err) {
console.log('Error',err);
return;
} else {
console.log('Connected!');
}
});
const gsapi = google.sheets({
version:'v4',
auth: client
});
app.post('/', function(request, response) {
var name = request.body.name;
var email = request.body.email;
var phone = request.body.phoneNumber;
var uni = request.body.university;
var faculty = request.body.faculty;
var acadYear = request.body.academicYear;
var workshops = request.body.workshop;
if (name && acadYear &&workshops) {
connection.query('INSERT INTO `ieee-form`(`name`,`mail`,`phone`,`uni`,`fac`,`academic_year`,`workshops`) VALUES ("'+name+'","'+email+'","'+phone+'","'+uni+'","'+faculty+'","'+acadYear+'","'+workshops+'")', function(error, results, fields) {
if(error){
throw error
}
else{
// response.send('Your submit is succefully sent. Thank you! :)');
dataArray = [name, email, phone, uni, faculty, acadYear, workshops[0],workshops[1]];
const insertData = {
spreadsheetId: '17RevEMQYRb9ubWihvTTz0LQ7GHr-5phxqQHggyRkpKY',
range: 'A1',
valueInputOption: 'USER_ENTERED',
resource: { values: [dataArray]}
}
gsapi.spreadsheets.values.append(insertData);
console.log("submitted",workshops);
response.send('Your submit is succefully sent. Thank you! :)');
}
});
} else
{
response.send('Please enter the required fields!');
response.end();
}
});
app.listen(3000)