문자 전송 프로그램
발송 대상 번호는 콤마(,) 로 구분됩니다.
config 파일 설정
filename : config.ini sac_number=021234567 // 메시지 발송시 문자발송 전화번호
sac_banner=[보안관제센터] // 메시지 최상단 문자열
sqlplus_id=ctl01 // DB서버 ID
sqlplus_pass=passw0rd // DB서버 password
sqlplus_server_ip=x.x.x.x // DB 서버 IP
sqlplus_server_port=1523 // DB서버 port
sqlfile=D:\sms\sql_query.sql // sql 파일 위치 (각 사용하는 PC의 압축해제된 위치로 변경)
# -*- coding: utf-8 -*-
import os, sys
import time
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_mainWindow(object):
def setupUi(self, mainWindow):
mainWindow.setObjectName("mainWindow")
mainWindow.resize(571, 467)
self.centralwidget = QtWidgets.QWidget(mainWindow)
self.centralwidget.setObjectName("centralwidget")
self.sms_body = QtWidgets.QTextEdit(self.centralwidget)
self.sms_body.setGeometry(QtCore.QRect(10, 30, 551, 211))
self.sms_body.setObjectName("sms_body")
self.pushButton = QtWidgets.QPushButton(self.centralwidget)
self.pushButton.setGeometry(QtCore.QRect(10, 390, 551, 61))
self.pushButton.setObjectName("pushButton")
self.number = QtWidgets.QTextEdit(self.centralwidget)
self.number.setGeometry(QtCore.QRect(10, 270, 551, 111))
self.number.setObjectName("number")
self.label_sms_body = QtWidgets.QLabel(self.centralwidget)
self.label_sms_body.setGeometry(QtCore.QRect(10, 10, 111, 16))
self.label_sms_body.setObjectName("label_sms_body")
self.label_number = QtWidgets.QLabel(self.centralwidget)
self.label_number.setGeometry(QtCore.QRect(10, 250, 111, 16))
self.label_number.setObjectName("label_number")
mainWindow.setCentralWidget(self.centralwidget)
self.retranslateUi(mainWindow)
QtCore.QMetaObject.connectSlotsByName(mainWindow)
self.pushButton.clicked.connect(self.pushButton_clicked) # 푸시버튼#1 연결
def retranslateUi(self, mainWindow):
_translate = QtCore.QCoreApplication.translate
mainWindow.setWindowTitle(_translate("mainWindow", "문자 전송 프로그램"))
self.pushButton.setText(_translate("mainWindow", "전송"))
self.label_sms_body.setText(_translate("mainWindow", "발송 SMS 내용"))
self.label_number.setText(_translate("mainWindow", "발송 대상 번호"))
def query(self,config):
sms = self.sms_body.toPlainText().replace("\n", "'||chr(10)||'")
number = self.number.toPlainText()
number_list = number.split(',')
number_len = len(number_list)
sms_query = ""
f_w = open("sql_query.sql", 'w')
중간 생략
if __name__ == "__main__":
import sys
app = QtWidgets.QApplication(sys.argv)
mainWindow = QtWidgets.QMainWindow()
ui = Ui_mainWindow()
ui.setupUi(mainWindow)
mainWindow.show()
sys.exit(app.exec_())
