def run(self,input,sender):
regex = '(.*)\s%s\s+(\S*)' % self.keyword
method_checker = re.match(regex,input)
response = 'default'
if(method_checker.group(2) == 'update'):
""" banana: basecamp update"""
self.cacheData()
response = 'Updated!'
elif(method_checker.group(2) == 'log'):
""" banana:: basecamp log <email> <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+(.*)\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.+[0-9])\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
if parser:
projectid = ''
projectname = parser.group(3)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = int(project['id'])
hour = parser.group(4)
desc = parser.group(5)
date = int(time.strftime("%Y%m%d"))
user_email = parser.group(2).split('|')[1][:-1]
userid = ''
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
xml = bc.people().text
items = ET.fromstring(xml).findall('person')
for item in items:
if item.find('email-address').text == user_email:
userid = item.find('id').text
break
if userid == '':
response = 'Email not recognized!'
return response
projectpeople = bc.people_per_project(projectid).text
peoplesearch = ET.fromstring(projectpeople).findall('person')
for person in peoplesearch:
if int(person.find('id').text) == userid:
bc.create_time_entry(desc,float(hour),int(userid),date,int(projectid),None).text
response = 'Logged successfully!'
return response
response = 'You do not belong to that project.'
return response
""" banana:: basecamp log <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.+[0-9])\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
if parser:
print "log 2"
projectid = ''
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
hour = parser.group(3)
desc = parser.group(4)
date = int(time.strftime("%Y%m%d"))
getparams = {'token': self.slack_token,'pretty':'1'}
req = requests.get('https://slack.com/api/users.list', params=getparams)
userlist = json.loads(req.content)
user_email = ''
for user in userlist['members']:
if user['id'] == sender:
user_email = user['profile']['email']
userid = r.hget('Users:' + user_email,'id')
if userid == None or userid == '':
response = 'Your email does not exist :<'
return response
checker = r.zrangebyscore("peopleperproject:" + projectid, userid, userid)
if checker == None or checker == "" or checker == []:
response = 'Your email is not recognized. Please try banana:: basecamp log <email> <"project name"> <hours> <"desc">'
return response
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
bc.create_time_entry(desc,float(hour),int(userid),date,int(projectid),None).text
return response
else:
response = 'Wrong set of parameters. Must be banana:: basecamp log <"project name"> <hours> <"description">'
elif method_checker.group(2) == "getProjects":
""" banana:: basecamp getProjects <email>"""
regex = '(.*)\s%s\s+getProjects\s+(.*)' % self.keyword
parser = re.match(regex,input)
if parser:
email = parser.group(2)
email = email.split('|')[1][:-1]
projectlist = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
user = r.hgetall('Users:' + email)
if user == None or user == "" or user == {}:
response = 'Email not found!'
return response
userid = user['id']
projects = r.zrange('Projects',0,-1)
for project in projects:
projectid = r.hget("Projects:" + project,'id')
projectname = r.hget("Projects:" + project,'name')
checker = r.zrangebyscore("peopleperproject:" + projectid, userid, userid)
if checker != None and checker != "" and checker != []:
projectlist.append(projectname)
print projectlist
response = "Projects of %s: \n\n" % email
for project in projectlist:
response = response + project + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getProjects <email>'
elif method_checker.group(2) == "getLogs":
""" banana:: basecamp getLogs <project name in quotation marks> <email> <yyyy-mm-dd> <yyyy-mm-dd>"""
regex = '(.*)\s%s\s+getLogs\s+["|\'](.*)["|\']\s+(.*)\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])' % self.keyword
parser = re.match(regex,input)
if parser:
projectid = ''
userid = ''
projectname = parser.group(2)
email = parser.group(3).split('|')[1][:-1]
date1 = parser.group(4)
date1 = datetime(int(date1[0:4]), int(date1[5:7]), int(date1[8:10]))
date2 = parser.group(5)
date2 = datetime(int(date2[0:4]), int(date2[5:7]), int(date2[8:10]))
user_time_entry = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
userid = r.hget('Users:' + email,'id')
print userid
if userid == None or userid == "":
response = 'Email not found!'
return response
pname = r.hget('Projects:' + projectname,'name')
if pname == "" or pname == None:
response = 'Project not found'
return response
projectid = r.hget('Projects:' + projectname,'id')
userposts = r.zrangebyscore('Time_entry:' + projectid,userid,userid)
if userposts != None and userposts != "" and userposts != []:
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + str(userpost))
entrydate = timedetails['date']
entrydate = datetime(int(entrydate[0:4]), int(entrydate[5:7]), int(entrydate[8:10]))
if entrydate >= date1 and entrydate <= date2:
time_instance = []
time_instance.append(timedetails['date'])
time_instance.append(timedetails['hours'])
time_instance.append(timedetails['description'])
user_time_entry.append(time_instance)
response = "Logs of %s: \n\n" % email
for entry in user_time_entry:
response = response + entry[0] + " " + entry[1] + " " + entry[2] + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getLogs <"project name"> <email> <yyyy-mm-dd> <yyyy-mm-dd>'
elif method_checker.group(2) == "getDistribution":
""" banana:: basecamp getDistribution <email>"""
regex = '(.*)\s%s\s+getDistribution\s+(.*)' % self.keyword
parser = re.match(regex,input)
if parser:
print 'getdist opening!!!'
userid = ''
email = parser.group(2).split('|')[1][:-1]
"""distribution = [{'name':'example','hours':'69', 'percent':100}]"""
distribution = []
projectlist = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
userid = r.hget('Users:' + email,'id')
print userid
if userid == None or userid == "":
response = 'Email not found!'
return response
projects = r.zrange('Projects',0,-1)
print projects
for project in projects:
projectid = r.hget('Projects:' + project,'id')
projectname = r.hget('Projects:' + project,'name')
userposts = r.zrangebyscore("Time_entry:" + projectid,userid,userid)
if userposts != None and userposts != "" and userposts != []:
instance = {'name':projectname,'hours':0,'percent':100}
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + userpost)
instance['hours'] = instance['hours'] + float(timedetails['hours'])
distribution.append(instance)
response = "Logs of %s: \n\n" % email
total_hours = 0
for entry in distribution:
total_hours = total_hours + entry['hours']
for entry in distribution:
entry['percent'] = (float(entry['hours'])/float(total_hours)) * 100
for entry in distribution:
response = response + entry['name'] + " " + str(entry['percent']) + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getDistribution <email>'
elif method_checker.group(2) == "get-logs":
""" banana: basecamp get-logs <"Project Name">"""
regex = '(.*)\s%s\s+get[-]logs\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
people = r.zrange('peopleperproject:' + projectid, 0, -1)
for user in people:
userdata = r.hgetall('Users:' + user)
response = response + userdata['name'] + '\n'
time_entries = r.zrangebyscore("Time_entry:" + projectid, userdata['id'], userdata['id'])
csvcontent = ''
for time_entry in time_entries:
time_entry_data = r.hgetall("Time_entry:" + time_entry)
#response = response + ' ' + time_entry_data['description'] + '\n'
csvcontent = csvcontent + time_entry_data['description'] + ',' + time_entry_data['hours'] + ',' + time_entry_data['date'] + ','
#TO ADD LATER: Put these into seperate csv files
postparams = {"content":csvcontent}
getparams = {"token":self.slack_token,"channels":"C02BW6E2L", "filetype":"csv", "title":userdata['name'] + ' logs'}
req = requests.post('https://slack.com/api/files.upload',params=getparams,data=postparams)
response = 'Logs successfully saved in csv files!'
elif method_checker.group(2) == 'getTodoLists':
""" banana: basecamp getTodoLists <"Project Name">"""
regex = '(.*)\s%s\s+getTodoLists\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
todolists = r.zrange("Todo_list:" + projectid,0,-1)
for todolist in todolists:
todolistdata = r.hgetall("Todo_list:" + todolist)
response = response + todolistdata['name']
todolistid = todolistdata['id']
response = response + "\n"
elif method_checker.group(2) == 'getMessages':
""" banana: basecamp getMessages <"Project Name">"""
regex = '(.*)\s%s\s+getMessages\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
messages = r.zrange("Message:" + projectid,0,-1)
for message in messages:
messagedata = r.hgetall("Message:" + message)
response = response + messagedata['body'] + '\n'
response = response + "\n"
elif method_checker.group(2) == 'addTodoList':
""" banana: basecamp addTodoList <"Project Name"> <"Todo List Name">"""
regex = '(.*)\s%s\s+addTodoList\s+["|\'](.*)["|\']\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
todolistname = parser.group(3)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
bc.create_todo_list(project_id=int(projectid),name=todolistname)
response = 'Todo List created successfully'
elif method_checker.group(2) == 'addMessages':
""" banana: basecamp addMessages <"Project Name"> <"">"""
regex = '(.*)\s%s\s+addMessages\s+["|\'](.*)["|\']\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
#if parser:
else:
response = 'Module not found!'
return response
def run(self, input, sender):
regex = '(.*)\s%s\s+(\S*)' % self.keyword
method_checker = re.match(regex, input)
response = 'default'
if (method_checker.group(2) == 'update'):
""" banana: basecamp update"""
self.cacheData()
response = 'Updated!'
elif (method_checker.group(2) == 'log'):
""" banana:: basecamp log <email> <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+(.*)\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.+[0-9])\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
if parser:
projectid = ''
projectname = parser.group(3)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = int(project['id'])
hour = parser.group(4)
desc = parser.group(5)
date = int(time.strftime("%Y%m%d"))
user_email = parser.group(2).split('|')[1][:-1]
userid = ''
bc = Basecamp('https://seertechnologies.basecamphq.com',
self.api_token)
xml = bc.people().text
items = ET.fromstring(xml).findall('person')
for item in items:
if item.find('email-address').text == user_email:
userid = item.find('id').text
break
if userid == '':
response = 'Email not recognized!'
return response
projectpeople = bc.people_per_project(projectid).text
peoplesearch = ET.fromstring(projectpeople).findall('person')
for person in peoplesearch:
if int(person.find('id').text) == userid:
bc.create_time_entry(desc, float(hour), int(userid),
date, int(projectid), None).text
response = 'Logged successfully!'
return response
response = 'You do not belong to that project.'
return response
""" banana:: basecamp log <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.+[0-9])\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
if parser:
print "log 2"
projectid = ''
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
hour = parser.group(3)
desc = parser.group(4)
date = int(time.strftime("%Y%m%d"))
getparams = {'token': self.slack_token, 'pretty': '1'}
req = requests.get('https://slack.com/api/users.list',
params=getparams)
userlist = json.loads(req.content)
user_email = ''
for user in userlist['members']:
if user['id'] == sender:
user_email = user['profile']['email']
userid = r.hget('Users:' + user_email, 'id')
if userid == None or userid == '':
response = 'Your email does not exist :<'
return response
checker = r.zrangebyscore("peopleperproject:" + projectid,
userid, userid)
if checker == None or checker == "" or checker == []:
response = 'Your email is not recognized. Please try banana:: basecamp log <email> <"project name"> <hours> <"desc">'
return response
bc = Basecamp('https://seertechnologies.basecamphq.com',
self.api_token)
bc.create_time_entry(desc, float(hour), int(userid), date,
int(projectid), None).text
return response
else:
response = 'Wrong set of parameters. Must be banana:: basecamp log <"project name"> <hours> <"description">'
elif method_checker.group(2) == "getProjects":
""" banana:: basecamp getProjects <email>"""
regex = '(.*)\s%s\s+getProjects\s+(.*)' % self.keyword
parser = re.match(regex, input)
if parser:
email = parser.group(2)
email = email.split('|')[1][:-1]
projectlist = []
r = redis.StrictRedis(host='localhost', port=6379, db=0)
user = r.hgetall('Users:' + email)
if user == None or user == "" or user == {}:
response = 'Email not found!'
return response
userid = user['id']
projects = r.zrange('Projects', 0, -1)
for project in projects:
projectid = r.hget("Projects:" + project, 'id')
projectname = r.hget("Projects:" + project, 'name')
checker = r.zrangebyscore("peopleperproject:" + projectid,
userid, userid)
if checker != None and checker != "" and checker != []:
projectlist.append(projectname)
print projectlist
response = "Projects of %s: \n\n" % email
for project in projectlist:
response = response + project + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getProjects <email>'
elif method_checker.group(2) == "getLogs":
""" banana:: basecamp getLogs <project name in quotation marks> <email> <yyyy-mm-dd> <yyyy-mm-dd>"""
regex = '(.*)\s%s\s+getLogs\s+["|\'](.*)["|\']\s+(.*)\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])' % self.keyword
parser = re.match(regex, input)
if parser:
projectid = ''
userid = ''
projectname = parser.group(2)
email = parser.group(3).split('|')[1][:-1]
date1 = parser.group(4)
date1 = datetime(int(date1[0:4]), int(date1[5:7]),
int(date1[8:10]))
date2 = parser.group(5)
date2 = datetime(int(date2[0:4]), int(date2[5:7]),
int(date2[8:10]))
user_time_entry = []
r = redis.StrictRedis(host='localhost', port=6379, db=0)
userid = r.hget('Users:' + email, 'id')
print userid
if userid == None or userid == "":
response = 'Email not found!'
return response
pname = r.hget('Projects:' + projectname, 'name')
if pname == "" or pname == None:
response = 'Project not found'
return response
projectid = r.hget('Projects:' + projectname, 'id')
userposts = r.zrangebyscore('Time_entry:' + projectid, userid,
userid)
if userposts != None and userposts != "" and userposts != []:
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + str(userpost))
entrydate = timedetails['date']
entrydate = datetime(int(entrydate[0:4]),
int(entrydate[5:7]),
int(entrydate[8:10]))
if entrydate >= date1 and entrydate <= date2:
time_instance = []
time_instance.append(timedetails['date'])
time_instance.append(timedetails['hours'])
time_instance.append(timedetails['description'])
user_time_entry.append(time_instance)
response = "Logs of %s: \n\n" % email
for entry in user_time_entry:
response = response + entry[0] + " " + entry[
1] + " " + entry[2] + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getLogs <"project name"> <email> <yyyy-mm-dd> <yyyy-mm-dd>'
elif method_checker.group(2) == "getDistribution":
""" banana:: basecamp getDistribution <email>"""
regex = '(.*)\s%s\s+getDistribution\s+(.*)' % self.keyword
parser = re.match(regex, input)
if parser:
print 'getdist opening!!!'
userid = ''
email = parser.group(2).split('|')[1][:-1]
"""distribution = [{'name':'example','hours':'69', 'percent':100}]"""
distribution = []
projectlist = []
r = redis.StrictRedis(host='localhost', port=6379, db=0)
userid = r.hget('Users:' + email, 'id')
print userid
if userid == None or userid == "":
response = 'Email not found!'
return response
projects = r.zrange('Projects', 0, -1)
print projects
for project in projects:
projectid = r.hget('Projects:' + project, 'id')
projectname = r.hget('Projects:' + project, 'name')
userposts = r.zrangebyscore("Time_entry:" + projectid,
userid, userid)
if userposts != None and userposts != "" and userposts != []:
instance = {
'name': projectname,
'hours': 0,
'percent': 100
}
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + userpost)
instance['hours'] = instance['hours'] + float(
timedetails['hours'])
distribution.append(instance)
response = "Logs of %s: \n\n" % email
total_hours = 0
for entry in distribution:
total_hours = total_hours + entry['hours']
for entry in distribution:
entry['percent'] = (float(entry['hours']) /
float(total_hours)) * 100
for entry in distribution:
response = response + entry['name'] + " " + str(
entry['percent']) + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getDistribution <email>'
elif method_checker.group(2) == "get-logs":
""" banana: basecamp get-logs <"Project Name">"""
regex = '(.*)\s%s\s+get[-]logs\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
people = r.zrange('peopleperproject:' + projectid, 0, -1)
for user in people:
userdata = r.hgetall('Users:' + user)
response = response + userdata['name'] + '\n'
time_entries = r.zrangebyscore("Time_entry:" + projectid,
userdata['id'],
userdata['id'])
csvcontent = ''
for time_entry in time_entries:
time_entry_data = r.hgetall("Time_entry:" + time_entry)
#response = response + ' ' + time_entry_data['description'] + '\n'
csvcontent = csvcontent + time_entry_data[
'description'] + ',' + time_entry_data[
'hours'] + ',' + time_entry_data['date'] + ','
#TO ADD LATER: Put these into seperate csv files
postparams = {"content": csvcontent}
getparams = {
"token": self.slack_token,
"channels": "C02BW6E2L",
"filetype": "csv",
"title": userdata['name'] + ' logs'
}
req = requests.post('https://slack.com/api/files.upload',
params=getparams,
data=postparams)
response = 'Logs successfully saved in csv files!'
elif method_checker.group(2) == 'getTodoLists':
""" banana: basecamp getTodoLists <"Project Name">"""
regex = '(.*)\s%s\s+getTodoLists\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
todolists = r.zrange("Todo_list:" + projectid, 0, -1)
for todolist in todolists:
todolistdata = r.hgetall("Todo_list:" + todolist)
response = response + todolistdata['name']
todolistid = todolistdata['id']
response = response + "\n"
elif method_checker.group(2) == 'getMessages':
""" banana: basecamp getMessages <"Project Name">"""
regex = '(.*)\s%s\s+getMessages\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
messages = r.zrange("Message:" + projectid, 0, -1)
for message in messages:
messagedata = r.hgetall("Message:" + message)
response = response + messagedata['body'] + '\n'
response = response + "\n"
elif method_checker.group(2) == 'addTodoList':
""" banana: basecamp addTodoList <"Project Name"> <"Todo List Name">"""
regex = '(.*)\s%s\s+addTodoList\s+["|\'](.*)["|\']\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
response = ''
if parser:
projectname = parser.group(2)
todolistname = parser.group(3)
r = redis.StrictRedis(host='localhost', port=6379, db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
bc = Basecamp('https://seertechnologies.basecamphq.com',
self.api_token)
bc.create_todo_list(project_id=int(projectid),
name=todolistname)
response = 'Todo List created successfully'
elif method_checker.group(2) == 'addMessages':
""" banana: basecamp addMessages <"Project Name"> <"">"""
regex = '(.*)\s%s\s+addMessages\s+["|\'](.*)["|\']\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex, input)
response = ''
#if parser:
else:
response = 'Module not found!'
return response
def run(self,input,sender,channel):
regex = '(.*)\s%s\s+(\S*)' % self.keyword
method_checker = re.match(regex,input)
response = 'default'
if(method_checker.group(2) == 'update'):
""" banana: basecamp update"""
self.cacheData()
response = 'Updated!'
elif(method_checker.group(2) == 'Cron'):
""" banana: basecamp Cron"""
sched = Scheduler()
sched.add_cron_job(self.cacheData,hour=2,minute=0)
sched.start()
response = 'Started cron'
elif(method_checker.group(2) == 'log'):
response = 'Logging turned off'
return response
""" banana:: basecamp log <email> <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+(.*)\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.?[0-9]+)\s+["|\'](.*)["|\']((\s+)([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9]))?' % self.keyword
parser = re.match(regex,input)
if parser:
projectid = ''
projectname = parser.group(3)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = int(project['id'])
hour = parser.group(4)
desc = parser.group(5)
date = ''
inputdate = parser.group(6)
if inputdate == "" or inputdate is None:
date = int(time.strftime("%Y%m%d"))
else:
date = int(inputdate[1:5] + inputdate[6:8] + inputdate[9:11])
user_email = parser.group(2)
userid = ''
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
xml = bc.people().text
items = ET.fromstring(xml).findall('person')
for item in items:
if item.find('email-address').text == user_email:
userid = item.find('id').text
break
if userid == '':
response = 'Email not recognized!'
return response
projectpeople = bc.people_per_project(projectid).text
peoplesearch = ET.fromstring(projectpeople).findall('person')
for person in peoplesearch:
if person.find('id').text == userid:
bc.create_time_entry(desc,float(hour),int(userid),date,int(projectid),None).text
response = 'Logged successfully!'
totalLogs = float(r.hget('Users:' + userid, 'BananaLogsForTheWeek'))
totalLogs = totalLogs + float(hour)
r.hset('Users:' + userid, 'BananaLogsForTheWeek', totalLogs)
bananaUsage = r.hget('Users:' + userid, 'BananaUsageForTheWeek')
dateToday = datetime.now().weekday()
if dateToday == len(bananaUsage):
bananaUsage = bananaUsage + 'B'
r.hset('Users:' + userid, 'BananaUsageForTheWeek',bananaUsage)
return response
response = 'You do not belong to that project.'
return response
""" banana:: basecamp log <"project name"> <hours> <"desc">"""
regex = '(.*)\s%s\s+log\s+["|\'](.*)["|\']\s+([0-9]*[0-9]?\.?[0-9]+)\s+["|\'](.*)["|\']((\s+)([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9]))?' % self.keyword
parser = re.match(regex,input)
if parser:
projectid = ''
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
hour = parser.group(3)
desc = parser.group(4)
date = ''
inputdate = parser.group(5)
if inputdate == "" or inputdate is None:
date = int(time.strftime("%Y%m%d"))
else:
date = int(inputdate[1:5] + inputdate[6:8] + inputdate[9:11])
getparams = {'token': self.slack_token,'pretty':'1'}
req = requests.get('https://slack.com/api/users.list', params=getparams, verify=False)
userlist = json.loads(req.content)
user_email = ''
for user in userlist['members']:
if user['id'] == sender:
user_email = user['profile']['email']
userid = r.hget('Users:' + user_email,'id')
if userid == None or userid == '':
response = 'Your email does not exist :<'
return response
checker = r.zrangebyscore("peopleperproject:" + projectid, userid, userid)
if checker == None or checker == "" or checker == []:
response = 'Your email is not recognized. Please try banana:: basecamp log <email> <"project name"> <hours> <"desc">'
return response
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
bc.create_time_entry(desc,float(hour),int(userid),date,int(projectid),None).text
totalLogs = float(r.hget('Users:' + userid, 'BananaLogsForTheWeek'))
totalLogs = totalLogs + float(hour)
r.hset('Users:' + userid, 'BananaLogsForTheWeek', totalLogs)
bananaUsage = r.hget('Users:' + userid, 'BananaUsageForTheWeek')
dateToday = datetime.now().weekday()
if dateToday == len(bananaUsage):
bananaUsage = bananaUsage + 'B'
r.hset('Users:' + userid, 'BananaUsageForTheWeek',bananaUsage)
response = 'successfully logged!'
return response
else:
response = 'Wrong set of parameters. Must be banana:: basecamp log <"project name"> <hours> <"description">'
elif method_checker.group(2) == "getProjects":
""" banana:: basecamp getProjects <email>"""
regex = '(.*)\s%s\s+getProjects\s+(.*)' % self.keyword
parser = re.match(regex,input)
if parser:
email = parser.group(2)
projectlist = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
user = r.hgetall('Users:' + email)
if user == None or user == "" or user == {}:
response = 'Email not found!'
return response
userid = user['id']
projects = r.zrange('Projects',0,-1)
for project in projects:
projectid = r.hget("Projects:" + project,'id')
projectname = r.hget("Projects:" + project,'name')
checker = r.zrangebyscore("peopleperproject:" + projectid, userid, userid)
if checker != None and checker != "" and checker != []:
projectlist.append(projectname)
response = "Projects of %s: \n\n" % email
for project in projectlist:
response = response + project + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getProjects <email>'
elif method_checker.group(2) == "getLogs":
""" banana:: basecamp getLogs <project name in quotation marks> <email> <yyyy-mm-dd> <yyyy-mm-dd>"""
regex = '(.*)\s%s\s+getLogs\s+["|\'](.*)["|\']\s+(.*)\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])\s+([0-9][0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9])' % self.keyword
parser = re.match(regex,input)
if parser:
projectid = ''
userid = ''
projectname = parser.group(2)
email = parser.group(3)
date1 = parser.group(4)
date1 = datetime(int(date1[0:4]), int(date1[5:7]), int(date1[8:10]))
date2 = parser.group(5)
date2 = datetime(int(date2[0:4]), int(date2[5:7]), int(date2[8:10]))
user_time_entry = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
userid = r.hget('Users:' + email,'id')
if userid == None or userid == "":
response = 'Email not found!'
return response
pname = r.hget('Projects:' + projectname,'name')
if pname == "" or pname == None:
response = 'Project not found'
return response
projectid = r.hget('Projects:' + projectname,'id')
userposts = r.zrangebyscore('Time_entry:' + projectid,userid,userid)
if userposts != None and userposts != "" and userposts != []:
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + str(userpost))
entrydate = timedetails['date']
entrydate = datetime(int(entrydate[0:4]), int(entrydate[5:7]), int(entrydate[8:10]))
if entrydate >= date1 and entrydate <= date2:
time_instance = []
time_instance.append(timedetails['date'])
time_instance.append(timedetails['hours'])
time_instance.append(timedetails['description'])
user_time_entry.append(time_instance)
response = "Logs of %s: \n\n" % email
for entry in user_time_entry:
response = response + entry[0] + " " + entry[1] + " " + entry[2] + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getLogs <"project name"> <email> <yyyy-mm-dd> <yyyy-mm-dd>'
elif method_checker.group(2) == "getDistribution":
""" banana:: basecamp getDistribution <email>"""
regex = '(.*)\s%s\s+getDistribution\s+(.*)' % self.keyword
parser = re.match(regex,input)
if parser:
userid = ''
email = parser.group(2)
"""distribution = [{'name':'example','hours':'69', 'percent':100}]"""
distribution = []
projectlist = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
userid = r.hget('Users:' + email,'id')
if userid == None or userid == "":
response = 'Email not found!'
return response
projects = r.zrange('Projects',0,-1)
for project in projects:
projectid = r.hget('Projects:' + project,'id')
projectname = r.hget('Projects:' + project,'name')
userposts = r.zrangebyscore("Time_entry:" + projectid,userid,userid)
if userposts != None and userposts != "" and userposts != []:
instance = {'name':projectname,'hours':0,'percent':100}
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + userpost)
instance['hours'] = instance['hours'] + float(timedetails['hours'])
distribution.append(instance)
response = "Logs of %s: \n\n" % email
total_hours = 0
for entry in distribution:
total_hours = total_hours + entry['hours']
for entry in distribution:
entry['percent'] = round((float(entry['hours'])/float(total_hours)) * 100,2)
for entry in distribution:
response = response + entry['name'] + " " + str(entry['percent']) + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getDistribution <email>'
elif method_checker.group(2) == "get-logs":
""" banana: basecamp get-logs <"Project Name">"""
regex = '(.*)\s%s\s+get[-]logs\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
people = r.zrange('peopleperproject:' + projectid, 0, -1)
for user in people:
userdata = r.hgetall('Users:' + user)
response = response + userdata['name'] + '\n'
time_entries = r.zrangebyscore("Time_entry:" + projectid, userdata['id'], userdata['id'])
csvcontent = ''
for time_entry in time_entries:
time_entry_data = r.hgetall("Time_entry:" + time_entry)
#response = response + ' ' + time_entry_data['description'] + '\n'
csvcontent = csvcontent + time_entry_data['description'] + ',' + time_entry_data['hours'] + ',' + time_entry_data['date'] + ','
#TO ADD LATER: Put these into seperate csv files
postparams = {"content":csvcontent}
getparams = {"token":self.slack_token,"channels":"C02BW6E2L", "filetype":"csv", "title":userdata['name'] + ' logs'}
req = requests.post('https://slack.com/api/files.upload',params=getparams,data=postparams)
response = 'Logs successfully saved in csv files!'
elif method_checker.group(2) == 'getTodoLists':
""" banana: basecamp getTodoLists <"Project Name">"""
regex = '(.*)\s%s\s+getTodoLists\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
todolists = r.zrange("Todo_list:" + projectid,0,-1)
for todolist in todolists:
todolistdata = r.hgetall("Todo_list:" + todolist)
response = response + todolistdata['name']
todolistid = todolistdata['id']
response = response + "\n"
elif method_checker.group(2) == 'getMessages':
""" banana: basecamp getMessages <"Project Name">"""
regex = '(.*)\s%s\s+getMessages\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
messages = r.zrange("Message:" + projectid,0,-1)
for message in messages:
messagedata = r.hgetall("Message:" + message)
parser = MessageParser()
parser.feed(messagedata['body'])
response = response + parser.output + '\n'
response = response + "\n"
parser.close()
elif method_checker.group(2) == 'addTodoList':
""" banana: basecamp addTodoList <"Project Name"> <"Todo List Name">"""
regex = '(.*)\s%s\s+addTodoList\s+["|\'](.*)["|\']\s+["|\'](.*)["|\']' % self.keyword
parser = re.match(regex,input)
response = ''
if parser:
projectname = parser.group(2)
todolistname = parser.group(3)
r = redis.StrictRedis(host='localhost',port=6379,db=0)
project = r.hgetall("Projects:" + projectname)
if project == None or project == [] or project == {}:
response = 'Project not found'
return response
projectid = project['id']
bc = Basecamp('https://seertechnologies.basecamphq.com', self.api_token)
bc.create_todo_list(project_id=int(projectid),name=todolistname)
response = 'Todo List created successfully'
elif method_checker.group(2) == "getDistributionLastMonth":
""" banana:: basecamp getDistributionLastMonth <email>"""
regex = '(.*)\s%s\s+getDistributionLastMonth\s+(.*)' % self.keyword
parser = re.match(regex,input)
if parser:
userid = ''
email = parser.group(2)
"""distribution = [{'name':'example','hours':'69', 'percent':100}]"""
distribution = []
projectlist = []
r = redis.StrictRedis(host='localhost',port=6379,db=0)
userid = r.hget('Users:' + email,'id')
if userid == None or userid == "":
response = 'Email not found!'
return response
projects = r.zrange('Projects',0,-1)
for project in projects:
projectid = r.hget('Projects:' + project,'id')
projectname = r.hget('Projects:' + project,'name')
userposts = r.zrangebyscore("Time_entry:" + projectid,userid,userid)
if userposts != None and userposts != "" and userposts != []:
instance = {'name':projectname,'hours':0,'percent':100}
for userpost in userposts:
timedetails = r.hgetall("Time_entry:" + userpost)
entrydate = timedetails['date']
entrydate = datetime(int(entrydate[0:4]), int(entrydate[5:7]), int(entrydate[8:10]))
datetoday = datetime.now()
if (entrydate.month+1 == datetoday.month and entrydate.year == datetoday.year) or (entrydate.month == 12 and datetoday.month == 1 and entrydate.year+1 == datetoday.year):
instance['hours'] = instance['hours'] + float(timedetails['hours'])
distribution.append(instance)
response = "Logs of %s: \n\n" % email
total_hours = 0
for entry in distribution:
total_hours = total_hours + entry['hours']
for entry in distribution:
entry['percent'] = round((float(entry['hours'])/float(total_hours)) * 100,2)
for entry in distribution:
response = response + entry['name'] + " " + str(entry['percent']) + "\n"
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getDistributionLastMonth <email>'
elif method_checker.group(2) == "getStarbucks":
""" banana:: basecamp getStarbucks"""
regex = '(.*)\s%s\s+getStarbucks' % self.keyword
parser = re.match(regex,input)
if parser:
response = 'People who logged at least 32 hours using banana last week: \n'
r = redis.StrictRedis(host='localhost',port=6379,db=0)
users = r.zrange('Users',0,-1)
for user in users:
totalLogs = r.hget('Users:' + user, 'totalLogsLastWeek')
bananalogs = r.hget('Users:' + user, 'totalLogsLastWeek')
bananaUsage = r.hget('Users:' + user, 'totalLogsLastWeek')
else:
response = 'Wrong set of parameters. Must be banana:: basecamp getProjects <email>'
else:
response = 'Module not found!'
return response
