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)