def run(self): while True: time.sleep(1800) courseList = select_end_course_for_chart() if len(courseList) is not 0: for course in courseList: wb, sheet, style = self.setChart(course) userInfo = select_user_in_end_course(course.index) if len(userInfo) is 0: wb.save() continue posY = 2 for info in userInfo: sheet.write(posY, 0, info.name, style) sheet.write(posY, 1, info.firstLogin, style) sheet.write(posY, 2, info.lastLogin, style) sheet.write(posY, 3, info.lastLogout, style) posX = 4 procList = info.individualInfomation.split('*') for proc in procList: sheet.write(posY, posX, proc, style) posX += 1 posY += 1 wb.save() send_chart_with_mail.delay(select_master_email(course.testName)[0]) #path 추가
def send_email_handler(self, data): try: info = data.split(";") userIndex = int(info[0]) programInfo = info[2].split(',') userInfo = select_user_info(userIndex) mailAddress = select_master_email(programInfo[2])[0] programName = select_ban_program_name(programInfo[0])[0] send_mail.delay(userInfo[0], userInfo[1], programName, programInfo[1], mailAddress) except Exception as e: print(e) return