def close(self,LockerWindow):
db = MySQLdb.connect("localhost","admin","1234","lee")
cur = db.cursor()
sql = "update box set password = null where user_id = %s" % idvalue.idnum()
cur.execute(sql)
cur.close()
db.commit()
db.close()
stackwidget.password_stack(self)
LockerWindow.hide()
def close(self, PasswordWindow):
su = stackwidget.num()
if su == 1:
stackwidget.callin_div_stack(self)
db = MySQLdb.connect("localhost", "admin", "1234", "lee")
cur = db.cursor()
sql = "delete from box where user_id = %s" % idvalue.idnum()
cur.execute(sql)
cur.close()
db.commit()
db.close()
else:
stackwidget.find_div_stack(self)
PasswordWindow.hide()
def p2lock(self,LockerWindow):
global Y
Y = 2
msgbox = QMessageBox.question(self.centralwidget,'Message',"2 보관함에 보관하시겠습니까?",QMessageBox.Yes | QMessageBox.No)
if msgbox == QMessageBox.Yes:
db = MySQLdb.connect("localhost","admin","1234","lee")
cur = db.cursor()
sql = "update box set locker2 = 2 where user_id = %s" % idvalue.idnum()
cur.execute(sql)
cur.close()
db.commit()
db.close()
con = serial.Serial('/dev/ttyUSB0',9600)
con.write('6')
stackwidget.door_stack(self)
LockerWindow.hide()
def btPwClicked(self, PasswordWindow):
su = stackwidget.num()
password_text = self.le_pw.text()
if len(password_text) != 0:
if su == 1:
stackwidget.locker_stack(self)
db = MySQLdb.connect("localhost", "admin", "1234", "lee")
cur = db.cursor()
sql = "update box set password = %s where user_id = %s"
cur.execute(sql, (password_text, idvalue.idnum()))
cur.close()
db.commit()
db.close()
else:
stackwidget.door_stack(self)
db = MySQLdb.connect("localhost", "admin", "1234", "lee")
cur = db.cursor()
cur2 = db.cursor()
sql = "select password from box where user_id = %s" % idvalue.id2num(
)
sql2 = "select locker1,locker2 from box where user_id = %s" % idvalue.id2num(
)
cur.execute(sql)
cur2.execute(sql2)
sur = cur2.fetchone()
con = serial.Serial('/dev/ttyUSB0', 9600)
if sur[0] == 2:
con.write('5')
elif sur[1] == 2:
con.write('6')
cur.close()
cur2.close()
cur.close()
db.commit()
db.close()
PasswordWindow.hide()
else:
QMessageBox.information(self.gridLayoutWidget, "경고", "빈칸을 넣어주세요")
def message(self):
# '''
number = 0
db = MySQLdb.connect("localhost", "admin", "1234", "lee")
cur = db.cursor()
sql = "select LPAD(callnum,11,'0'),locker1,locker2,password from box where user_id = %s" % idvalue.idnum(
)
cur.execute(sql)
row = cur.fetchone()
phone = row[0]
if row[1] == 2:
number = 1
elif row[2] == 2:
number = 2
password = row[3]
print phone
cur.close()
db.commit()
db.close()
print row[0]
# set api key, api secret
api_key = "#"
api_secret = "#"
## 4 params(to, from, type, text) are mandatory. must be filled
params = dict()
params['type'] = 'sms' # Message type ( sms, lms, mms, ata )
params[
'to'] = phone #'01099504047 Recipients Number '01000000000,01000000001'
params['from'] = '#' # Sender number
params['text'] = (' %s 보관함에 보관되었습니다' + '\n' + '패스워드는 %s 입니다' + '\n' +
'찾아가시길 바랍니다 ') % (number, password) # Message
cool = Message(api_key, api_secret)
try:
response = cool.send(params)
print("Success Count : %s" % response['success_count'])
print("Error Count : %s" % response['error_count'])
print("Group ID : %s" % response['group_id'])
if "error_list" in response:
print("Error List : %s" % response['error_list'])
except CoolsmsException as e:
print("Error Code : %s" % e.code)
print("Error Message : %s" % e.msg)