reply.js
3.94 KB
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
var express = require('express');
const request = require('request');
const TARGET_URL = 'https://api.line.me/v2/bot/message/reply'
const TOKEN = ''
const fs = require('fs');
const path = require('path');
const HTTPS = require('https');
const domain = "2019102226.osschatbot2022.ml"
const sslport = 23023;
const bodyParser = require('body-parser');
var app = express();
app.use(bodyParser.json());
app.post('/hook', function (req, res) {
var eventObj = req.body.events[0];
var source = eventObj.source;
var message = eventObj.message;
// request log
console.log('======================', new Date(), '======================');
// mwsql
var mysql = require('mysql');
var db = mysql.createConnection({
host: 'chatbot.c7fzgftc3yrm.us-east-1.rds.amazonaws.com',
user: 'chatbot',
password: '',
database: 'chatbot',
port: '3306'
});
db.connect();
db.query('SELECT * FROM data', function (error, results, fields) {
if (error) {
console.log(error);
}
var arr = new Array();
var input_ingredients_list = message.text.split(" ");
for (var i = 0; i < results.length; i++) {
var ingredients_list = results[i].ingredients.split(", ");
if (ingredients_list.filter(x => input_ingredients_list.includes(x)).length === input_ingredients_list.length) {
arr.push(i);
}
}
if (arr.length != 0) {
var num = arr[Math.floor(Math.random() * arr.length)];
request.post(
{
url: TARGET_URL,
headers: {
'Authorization': `Bearer ${TOKEN}`
},
json: {
"replyToken": eventObj.replyToken,
"messages": [
{
"type": "text",
"text": `메뉴는 "${results[num].menu}" 입니다.`
},
{
"type": "text",
"text": `필요한 재료는\n${results[num].ingredients} 입니다.`
},
{
"type": "text",
"text": `레시피\n${results[num].recipe}`
}
]
}
}, (error, response, body) => {
console.log(body)
});
}
else {
request.post(
{
url: TARGET_URL,
headers: {
'Authorization': `Bearer ${TOKEN}`
},
json: {
"replyToken": eventObj.replyToken,
"messages": [
{
"type": "text",
"text": `재료를 다시 입력해주세요.`
}
]
}
}, (error, response, body) => {
console.log(body)
});
}
});
db.end();
res.sendStatus(200);
});
try {
const option = {
ca: fs.readFileSync('/etc/letsencrypt/live/' + domain + '/fullchain.pem'),
key: fs.readFileSync(path.resolve(process.cwd(), '/etc/letsencrypt/live/' + domain + '/privkey.pem'), 'utf8').toString(),
cert: fs.readFileSync(path.resolve(process.cwd(), '/etc/letsencrypt/live/' + domain + '/cert.pem'), 'utf8').toString(),
};
HTTPS.createServer(option, app).listen(sslport, () => {
console.log(`[HTTPS] Server is started on port ${sslport}`);
});
} catch (error) {
console.log('[HTTPS] HTTPS 오류가 발생하였습니다. HTTPS 서버는 실행되지 않습니다.');
console.log(error);
}