Focus-To-Do/test.py at master · isaif1/Focus-To-Do · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint
import re
import os
import smtplib
import imghdr
import schedule
import time
from email.message import EmailMessage
from datetime import datetime


def scrumcall(start):
    #EMAIL_ADDRESS = os.environ.get('EMAIL_USER')
    #EMAIL_PASSWORD = os.environ.get('EMAIL_PASS')

    contacts = []


    scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]

    creds = ServiceAccountCredentials.from_json_keyfile_name("My Project 74674-48aa88984250.json", scope)

    client = gspread.authorize(creds)

    sheet = client.open("sprint sheet").sheet1

    def find_sum(t):
        return sum(map(int,re.findall('\d+',t)))
    numcols = sheet.col_count
    count=4
    per=0
    while(count<numcols):
        msg = EmailMessage()
        msg1=EmailMessage()
        msg2=EmailMessage()
        a=find_sum(sheet.cell(start,count).value)
        b=find_sum(sheet.cell(start+1,count).value)
        name=sheet.cell(1,count).value
        msg2['Subject'] = 'Hey! {} your scrum is here!'.format(name)
        msg1['Subject'] = 'Hey! {} your scrum is here!'.format(name)
        msg1['From'] = 'Team Now n Never'
        msg2['From'] = 'Team Now n Never'
        msg1['To'] = contacts[per]
        msg2['To'] = contacts[per]
        msg['Subject'] = 'Hey {} your scrum is here!'.format(name)
        msg['From'] = 'Team Now n Never'
        msg['To'] = contacts[per]
        msg1.set_content('{} Looks like you are behind current scrum.You just have did {} questions while you have proposed {} questions'.format(name,b,a))
        msg.set_content('Hey! {} You are doing great! keep it up'.format(name))
        msg2.set_content('Hey! {} Looks like you have not did any question during this scrum Is everything ok!'.format(name) )
        per+=1
        count=count+5
        if a==0 or b==0:
            with smtplib.SMTP_SSL('smtp.gmail.com', 465) as smtp:
                smtp.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
                smtp.send_message(msg2)
        elif a>b:
            with smtplib.SMTP_SSL('smtp.gmail.com', 465) as smtp:
                smtp.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
                smtp.send_message(msg1)
        else:
            with smtplib.SMTP_SSL('smtp.gmail.com', 465) as smtp:
                smtp.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
                smtp.send_message(msg)

start=50
if datetime.today().strftime('%A')=='Monday':
    schedule.every().monday.at("14:50").do(scrumcall,start)
    start+=14

if datetime.today().strftime('%A')=='Monday':
    schedule.every().monday.at("14:53").do(scrumcall,start)
    start+=3

if datetime.today().strftime('%A')=='Monday':
    schedule.every().monday.at("14:56").do(scrumcall,start)
    start+=3


while True:
    schedule.run_pending()
    time.sleep(1)