def get_cards(self, check_only=True):
now = datetime.now().to_utc()
soon = now + timedelta(hours=6)
soon_seconds = int(soon.strftime('%s'))
now_seconds = int(now.strftime('%s'))
all_cards = TrelloCard.filter(due_epoch__gte=now_seconds, due_epoch__lte=soon_seconds, user=self.default_user, closed=False)
logging.info('soon: {soon} --now: {now}'.format(soon=soon_seconds, now=now_seconds))
check_ok = False
cards = []
# See if there are any cards that have checklists
self.num_cards = len(all_cards)
logging.info('number of cards: {}'.format(self.num_cards))
for card in all_cards:
logging.info('card:{id} {url} {seconds}, {due}'.format(url=card.shortUrl, seconds=str(card.due_epoch), due=card.due, id=card.idCard))
if card.idMembers is not None and \
card.checklist_finished is not None:
logging.info('soon: {soon} --card:{card} -- now: {now}'.format(soon=soon_seconds, now=now_seconds, card=card.due_epoch))
if card.due_datetime is not None:
if now <= card.due_datetime <= soon and card.checklist_finished is False:
check_ok = True
if check_only:
return check_ok
else:
cards.append(card)
if check_only:
return check_ok
else:
return cards
def action(self):
self.notify_checklist_incomplete = 'Ran'
logging.debug(self.last_actor)
hook = Webhook.get(model_id=self.card_data['idBoard'])
card = TrelloCard.get(idCard=self.card_data['id'])
logging.debug(hook.user)
unarchived = unarchive_card(self.card_data['id'], hook.user)
if unarchived == True:
if len(self.card_data['idMembers']) == 0:
trello_user = TrelloUserInfo.get(trello_id=card.idMemberCreator)
send_email('*****@*****.**', """
Hello, A card has been archived that has an incomplete checklist. It has
been unarchived. Please take a moment to look into this matter. %s Thanks!
The Nebri Support Team This email should have been sent to %s.
""" % (self.card_data['shortUrl'], trello_user.username), "An Incomplete Card has been Archived")
else:
for member in self.card_data['idMembers']:
trello_user = TrelloUserInfo.get(trello_id=member)
send_email('*****@*****.**', """
Hello, A card has been archived that has an incomplete checklist. It has
been unarchived. Please take a moment to look into this matter. %s Thanks!
The Nebri Support Team This email should have been sent to %s.
""" % (self.card_data['shortUrl'], trello_user.username), "An Incomplete Card has been Archived")
else:
send_email('*****@*****.**', """
An error occurred... %s
""" % unarchived, "An Error Occurred during Archiving")
def action(self):
self.trello_search_template_checklist = 'RAN: {}'.format(datetime.now())
if self.default_user is None:
self.default_user = DEFAULT_USER
template_cards = TrelloCard.filter(is_template=True, closed=False, drip=self.drip, user=self.default_user)
logging.info('starting action')
logging.info('card gotten')
self.num_cards = len(template_cards)
card_ids = []
logging.info('starting for loop')
for card in template_cards:
logging.info('card id: {}'.format(card.idCard))
if card.idCard in card_ids:
continue
p = Process.objects.create()
p.idCard = card.idCard
p.drip = self.drip
p.trello_copy_template = True
p.default_user = self.DEFAULT_USER
p.save()
card_ids.append(card.idCard)
logging.info('action finished')
def check(self):
logging.info("start check")
if self.default_user is None:
self.default_user = DEFAULT_USER
if self.trello_copy_template == True:
try:
card = TrelloCard.get(
idCard=self.idCard, is_template=True, closed=False, drip=self.drip, user=self.default_user
)
logging.info("card found")
except Exception as e:
logging.error("Error in copy template")
logging.error(str(e))
self.card_get_error = str(e)
return False
if card:
return True
return False
def action(self):
self.handle_unapproved_archived = 'Ran'
hook = Webhook.get(model_id=self.card_data['idBoard'])
try:
card = TrelloCard.get(idCard=self.card_data['id'], user=self.default_user)
except Process.DoesNotExist:
return
unarchived = unarchive_card(self.card_data['id'], hook.user)
if unarchived == True:
trello_user = TrelloUserInfo.get(trello_id=card.idMemberCreator)
send_email('*****@*****.**', """
Hello, A card has been archived which was not approved by a board admin. It has
been unarchived. Please take a moment to look into this matter. %s Thanks!
The Nebri Support Team Team This email should have been sent to %s.
""" % (self.card_data['shortUrl'], trello_user.username), "An Unapproved Card has been Archived")
else:
send_email('*****@*****.**', """
An error occurred... %s
""" % unarchived, "An Error Occurred during Archiving")
def get_or_check_cards(self, check_only=True):
now = datetime.now().to_utc()
long_ago = datetime.now() - timedelta(days=2)
now_seconds = int(now.strftime('%s'))
long_ago_seconds = int(long_ago.strftime('%s'))
logging.info(' Now: {now}, seconds: {s}, longago:{ago}'.format(
now=now,
s=now_seconds,
ago=long_ago_seconds
))
all_overdue_cards = TrelloCard.filter(
due_epoch__lte=now_seconds,
due_epoch__gte=long_ago_seconds,
overdue_notice_sent=False,
user=self.default_user
)
if check_only:
return len(all_overdue_cards) > 0
else:
return all_overdue_cards
def action(self):
self.handle_trello_webhook = "Ran"
logging.debug("handle new trello webhook")
if self.hook_data["action"]["type"] == "updateCard" and self.hook_data["action"]["data"]["card"].get(
"closed", False
):
# card has been archived. check for rule prerequisites
logging.debug("this card was archived!")
card = TrelloCard.get(idCard=self.card_data.get("id"), user=self.default_user)
logging.debug(card)
logging.debug(card.checklist_finished)
# let's check checklists first
if card.checklist_finished == False:
self.notify_checklist_incomplete = True
# next let's check for approved status
approved_commenter = None
for action in self.comment_data["actions"]:
if action["data"]["text"] == "approved":
approved_commenter = action["memberCreator"]
break
if approved_commenter is None or approved_commenter["username"] not in self.board_admins:
self.handle_unapproved_archived = True
def action(self):
self.trello_copy_template = "RAN: {}".format(datetime.now())
logging.info("start action")
client = get_client(self.default_user)
logging.info("client found")
card = TrelloCard.get(idCard=self.idCard, user=self.default_user)
card = template_checklist_setup(card, client)
self.template_idList = card.template_idList
logging.info("template_list {}".format(card.template_idList))
# self.json_data = card.card_json
# self.description = self.json_data.get('description')
logging.info("card updated")
out = copy_template_card(client, card)
self.out = out.id
# if new_card is not None:
# self.new_id = new_card.id
logging.info("finished")
def card_json_to_model(card, user):
epoch = '1970-01-01T12:00:00.00+0000'
pepoch = iso8601.parse_date(epoch)
logging.info('card list is next: ')
logging.info(str(card))
new = False
# card_obj, new = TrelloCard.get_or_create(idCard=card.get('id'))
try:
card_obj = TrelloCard.get(idCard=card.get('id'), user=user)
except Process.DoesNotExist:
logging.debug('create new.....')
card_obj = TrelloCard(idCard=card.get('id'), user=user)
card_obj.save()
new = True
except Exception as e:
logging.info('error finding too many cards...')
logging.debug(str(e))
if len(TrelloCard.filter(idCard=card.get('id'))) > 1:
for tcard in TrelloCard.filter(idCard=card.get('id'), user=user):
tcard.delete()
logging.debug('create new.....')
card_obj = TrelloCard(idCard=card.get('id'), user=user)
card_obj.save()
new = True
# update card
# check webhook json response
card_obj.idBoard = card.get('idBoard')
card_obj.idMembers = card.get('idMembers')
card_obj.idLabels = card.get('idLabels')
card_obj.idChecklists = card.get('idChecklists')
card_obj.idList = card.get('idList')
card_obj.checklists = card.get('checklists')
card_obj.due = card.get('due')
card_obj.due_epoch = None
card_obj.due_datetime = None
card_obj.name = card.get('name')
card_obj.shortUrl = card.get('shortUrl')
card_obj.card_json = card
card_obj.closed = card.get('closed', False)
card_obj.is_template = False
card_obj.template_idBoard = None
card_obj.template_idList = None
card_obj.drip = None
logging.info(str(card_obj.due))
if card_obj.idMemberCreator is False:
card_obj.idMemberCreator = None
if card_obj.due is not None and card_obj.due != '':
try:
# Timezone was set to UTC in the instance. This will make sure that
# UTC is always broght in
duedate = iso8601.parse_date(card_obj.due)
except Exception as e:
logging.error('TrelloCard date error: ' + str(e))
else:
# card_obj.due_epoch = (duedate - epoch).total_seconds()
card_obj.due_epoch = int(duedate.strftime('%s'))
card_obj.due_datetime = duedate
labels = card.get('labels', [])
if labels != []:
for label in labels:
name = label.get('name')
if name == 'template checklist':
card_items = template_checklist_parser(card_obj)
if card_items is None:
card_obj.is_template = False
else:
card_obj.is_template = True
card_obj.drip = card_items.get('drip')
card_obj.save()
return card_obj, new
