def getMail():
if request.method == 'GET':
cur = g.db
email = cur.execute(
"SELECT email FROM sfmail where id = 1").fetchone()[0]
smtp = cur.execute(
"SELECT smtp FROM sfmail where id = 1").fetchone()[0]
port = cur.execute(
"SELECT port FROM sfmail where id = 1").fetchone()[0]
return render_template('admin/mail.html',
email=email,
smtp=smtp,
port=port)
if request.method == 'POST':
subject = request.form['subject']
email = request.form['email']
password = request.form['password']
recipient = request.form['recipient']
body = request.form['body']
smtp = request.form['smtp']
port = request.form['port']
sendMail(subject, email, password, recipient, body, smtp, port)
cur = g.db
cur.execute(
"UPDATE sfmail SET email = '{}' where id = 1".format(email))
cur.execute("UPDATE sfmail SET smtp = '{}' where id = 1".format(smtp))
cur.execute("UPDATE sfmail SET port = '{}' where id = 1".format(port))
g.db.commit()
return redirect('/mail')
def postSendMail():
if request.is_json:
content = request.get_json()
cur = g.db
tokenapi = cur.execute("SELECT token FROM socialfish where id = 1").fetchone()[0]
if content['key'] == tokenapi:
subject = content['subject']
email = content['email']
password = content['password']
recipient = content['recipient']
body = content['body']
smtp = content['smtp']
port = content['port']
if sendMail(subject, email, password, recipient, body, smtp, port) == 'ok':
cur = g.db
cur.execute("UPDATE sfmail SET email = '{}' where id = 1".format(email))
cur.execute("UPDATE sfmail SET smtp = '{}' where id = 1".format(smtp))
cur.execute("UPDATE sfmail SET port = '{}' where id = 1".format(port))
g.db.commit()
status = {'status':'ok'}
else:
status = {'status':'bad','error':str(sendMail(subject, email, password, recipient, body, smtp, port))}
else:
status = {'status':'bad'}
else:
status = {'status':'bad'}
return jsonify(status)