def send_mail(self):
eml_type = self.in_eml_type.text()
eml_file = self.in_eml_template.text()
user_group = self.in_recipient_group.text()
mail_excel = self.in_recipient_excel.text()
annex_file = self.in_annex_file.text()
url = self.data_db[5] if self.data_db else 'http://yumail.myvnc.com'
try:
if self.cb_scheduler.isChecked():
my_time = self.in_scheduler.text()+':00'
client = Client()
client.send(self.data_smtp[:4], self.data_db[:5], eml_type, eml_file, user_group, mail_excel, annex_file, url, my_time)
QMessageBox.information(self, 'Success!', '排程設定成功!', QMessageBox.Ok)
else:
sm = Smtp(self.data_smtp[0], int(self.data_smtp[1]), self.data_smtp[2], self.data_smtp[3]) if self.data_smtp else Smtp()
db = Database(self.data_db[0], int(self.data_db[1]), self.data_db[2], self.data_db[3], self.data_db[4]) if self.data_db else Database()
insert_send_mail(eml_type, eml_file, user_group, mail_excel, sm, db, annex=annex_file, url=url)
sm.close()
db.__disconnect__()
QMessageBox.information(self, 'Success!', '信件寄出成功!', QMessageBox.Ok)
except:
QMessageBox.warning(self, 'Failed!', '信件寄出失敗!', QMessageBox.Ok)
def send_mail(self):
smtp_host = self.smtp_host.text() if self.smtp_host.text(
) else 'localhost'
smtp_port = self.smtp_port.text() if self.smtp_port.text() else 465
smtp_user = self.smtp_user.text() if self.smtp_user.text(
) else '*****@*****.**'
smtp_pw = self.smtp_pw.text() if self.smtp_pw.text() else 'yucc1234'
db_host = self.db_host.text() if self.db_host.text() else 'localhost'
db_port = self.db_port.text() if self.db_port.text() else 3306
db_user = self.db_user.text() if self.db_user.text() else 'socialmails'
db_pw = self.db_pw.text() if self.db_pw.text() else 'socialmails123'
db_db = self.db_db.text() if self.db_db.text() else 'socialmails'
eml_file = self.eml.text()
eml_type = self.eml_type.text()
mails_excel = self.mails.text()
mails_group = self.mails_group.text()
if self.add_cb.isChecked():
my_time = self.datetime_edit.text() + ':00'
client = Client()
client.send(eml_type, eml_file, mails_group, mails_excel, my_time)
else:
db = Database(db_host, db_port, db_user, db_pw, db_db)
sm = Smtp(smtp_host, smtp_port, smtp_user, smtp_pw)
insert_send_mail(eml_type, eml_file, mails_group, mails_excel, sm,
db)