def approval_suspension(self,request,details):
with transaction.atomic():
try:
if not request.user in self.allowed_assessors:
raise ValidationError('You do not have access to suspend this approval')
if not self.can_reissue and self.can_action:
raise ValidationError('You cannot suspend approval if it is not current or suspended')
if details.get('to_date'):
to_date= details.get('to_date').strftime('%d/%m/%Y')
else:
to_date=''
self.suspension_details = {
'from_date' : details.get('from_date').strftime('%d/%m/%Y'),
'to_date' : to_date,
'details': details.get('suspension_details'),
}
today = timezone.now().date()
from_date = datetime.datetime.strptime(self.suspension_details['from_date'],'%d/%m/%Y')
from_date = from_date.date()
if from_date <= today:
if not self.status == 'suspended':
self.status = 'suspended'
self.set_to_suspend = False
self.save()
send_approval_suspend_email_notification(self)
else:
self.set_to_suspend = True
self.save()
# Log approval action
self.log_user_action(ApprovalUserAction.ACTION_SUSPEND_APPROVAL.format(self.id),request)
# Log entry for proposal
#self.current_proposal.log_user_action(ProposalUserAction.ACTION_SUSPEND_APPROVAL.format(self.current_proposal.id),request)
except:
raise
def approval_suspension(self, request, details):
with transaction.atomic():
try:
if not request.user in self.allowed_assessors:
raise ValidationError(
'You do not have access to suspend this approval')
if not self.can_reissue and self.can_action:
raise ValidationError(
'You cannot suspend approval if it is not current or suspended'
)
if details.get('to_date'):
to_date = details.get('to_date').strftime('%d/%m/%Y')
else:
to_date = ''
self.suspension_details = {
'from_date': details.get('from_date').strftime('%d/%m/%Y'),
'to_date': to_date,
'details': details.get('suspension_details'),
}
today = timezone.now().date()
from_date = datetime.datetime.strptime(
self.suspension_details['from_date'], '%d/%m/%Y')
from_date = from_date.date()
if from_date <= today:
if not self.status == Approval.STATUS_SUSPENDED:
self.status = Approval.STATUS_SUSPENDED
self.set_to_suspend = False
self.save()
send_approval_suspend_email_notification(self)
# Change the statuses of the apiary sites, too
self.change_apiary_site_status(self.status)
else:
self.set_to_suspend = True
send_approval_suspend_email_notification(
self, future_suspend=True)
self.save()
# Log approval action
self.log_user_action(
ApprovalUserAction.ACTION_SUSPEND_APPROVAL.format(
self.lodgement_number), request)
# Log entry for proposal
#self.current_proposal.log_user_action(ProposalUserAction.ACTION_SUSPEND_APPROVAL.format(self.current_proposal.id),request)
except:
raise
def handle(self, *args, **options):
try:
user = EmailUser.objects.get(email='*****@*****.**')
except:
user = EmailUser.objects.create(email='*****@*****.**', password = '')
today = timezone.localtime(timezone.now()).date()
logger.info('Running command {}'.format(__name__))
for a in Approval.objects.filter(status = 'current'):
if a.suspension_details and a.set_to_suspend:
from_date = datetime.datetime.strptime(a.suspension_details['from_date'],'%d/%m/%Y')
from_date = from_date.date()
if from_date <= today:
try:
a.status = 'suspended'
a.set_to_suspend = False
a.save()
send_approval_suspend_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_SUSPEND_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_SUSPEND_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error suspending Approval {} status'.format(a.id))
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = 'cancelled'
a.set_to_cancel = False
a.save()
send_approval_cancel_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_CANCEL_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error cancelling Approval {} status'.format(a.id))
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(a.surrender_details['surrender_date'],'%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = 'surrendered'
a.set_to_surrender = False
a.save()
send_approval_surrender_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_SURRENDER_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_SURRENDER_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error surrendering Approval {} status'.format(a.id))
for a in Approval.objects.filter(status = 'suspended'):
if a.suspension_details and a.suspension_details['to_date']:
to_date = datetime.datetime.strptime(a.suspension_details['to_date'],'%d/%m/%Y')
to_date = to_date.date()
if to_date <= today and today < a.expiry_date:
try:
a.status = 'current'
a.save()
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_REINSTATE_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_REINSTATE_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error suspending Approval {} status'.format(a.id))
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = 'cancelled'
a.set_to_cancel = False
a.save()
send_approval_cancel_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_CANCEL_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error cancelling Approval {} status'.format(a.id))
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(a.surrender_details['surrender_date'],'%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = 'surrendered'
a.set_to_surrender = False
a.save()
send_approval_surrender_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(a,ApprovalUserAction.ACTION_SURRENDER_APPROVAL.format(a.id),user)
ProposalUserAction.log_action(proposal,ProposalUserAction.ACTION_SURRENDER_APPROVAL.format(proposal.id),user)
logger.info('Updated Approval {} status to {}'.format(a.id,a.status))
except:
logger.info('Error surrendering Approval {} status'.format(a.id))
logger.info('Command {} completed'.format(__name__))
def handle(self, *args, **options):
try:
user = EmailUser.objects.get(email='*****@*****.**')
except:
user = EmailUser.objects.create(email='*****@*****.**',
password='')
today = timezone.localtime(timezone.now()).date()
logger.info('Running command {}'.format(__name__))
for a in Approval.objects.filter(status='current'):
if a.suspension_details and a.set_to_suspend:
from_date = datetime.datetime.strptime(
a.suspension_details['from_date'], '%d/%m/%Y')
from_date = from_date.date()
if from_date <= today:
try:
a.status = 'suspended'
a.set_to_suspend = False
a.save()
send_approval_suspend_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SUSPEND_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SUSPEND_APPROVAL.format(
proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error suspending Approval {} status'.format(a.id))
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = 'cancelled'
a.set_to_cancel = False
a.save()
send_approval_cancel_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_CANCEL_APPROVAL.format(
proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error cancelling Approval {} status'.format(a.id))
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(
a.surrender_details['surrender_date'], '%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = 'surrendered'
a.set_to_surrender = False
a.save()
send_approval_surrender_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SURRENDER_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SURRENDER_APPROVAL.
format(proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error surrendering Approval {} status'.format(
a.id))
for a in Approval.objects.filter(status='suspended'):
if a.suspension_details and a.suspension_details['to_date']:
to_date = datetime.datetime.strptime(
a.suspension_details['to_date'], '%d/%m/%Y')
to_date = to_date.date()
if to_date <= today and today < a.expiry_date:
try:
a.status = 'current'
a.save()
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_REINSTATE_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_REINSTATE_APPROVAL.
format(proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error suspending Approval {} status'.format(a.id))
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = 'cancelled'
a.set_to_cancel = False
a.save()
send_approval_cancel_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_CANCEL_APPROVAL.format(
proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error cancelling Approval {} status'.format(a.id))
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(
a.surrender_details['surrender_date'], '%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = 'surrendered'
a.set_to_surrender = False
a.save()
send_approval_surrender_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SURRENDER_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SURRENDER_APPROVAL.
format(proposal.id), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
except:
logger.info(
'Error surrendering Approval {} status'.format(
a.id))
logger.info('Command {} completed'.format(__name__))
def handle(self, *args, **options):
try:
user = EmailUser.objects.get(email=settings.CRON_EMAIL)
except:
user = EmailUser.objects.create(email=settings.CRON_EMAIL,
password='')
errors = []
updates = []
today = timezone.localtime(timezone.now()).date()
logger.info('Running command {}'.format(__name__))
for a in Approval.objects.filter(status=Approval.STATUS_CURRENT):
if a.suspension_details and a.set_to_suspend:
from_date = datetime.datetime.strptime(
a.suspension_details['from_date'], '%d/%m/%Y')
from_date = from_date.date()
if from_date <= today:
try:
a.status = Approval.STATUS_SUSPENDED
a.set_to_suspend = False
a.save()
send_approval_suspend_email_notification(a)
# Change apiary site status too
a.change_apiary_site_status(a.status)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SUSPEND_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SUSPEND_APPROVAL.format(
proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(suspended=a.lodgement_number))
except Exception as e:
err_msg = 'Error suspending Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = Approval.STATUS_CANCELLED
a.set_to_cancel = False
a.save()
send_approval_cancel_email_notification(a)
# Change apiary site status too
a.change_apiary_site_status(a.status)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_CANCEL_APPROVAL.format(
proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(cancelled=a.lodgement_number))
except Exception as e:
err_msg = 'Error cancelling Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(
a.surrender_details['surrender_date'], '%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = Approval.STATUS_SURRENDERED
a.set_to_surrender = False
a.save()
send_approval_surrender_email_notification(a)
# Change apiary site status too
a.change_apiary_site_status(a.status)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SURRENDER_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SURRENDER_APPROVAL.
format(proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(surrendered=a.lodgement_number))
except Exception as e:
err_msg = 'Error surrendering Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
for a in Approval.objects.filter(status=Approval.STATUS_SUSPENDED):
if a.suspension_details and a.suspension_details['to_date']:
to_date = datetime.datetime.strptime(
a.suspension_details['to_date'], '%d/%m/%Y')
to_date = to_date.date()
if to_date <= today and today < a.expiry_date:
try:
a.status = Approval.STATUS_CURRENT
a.save()
# Change apiary site status too
a.change_apiary_site_status(a.status)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_REINSTATE_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_REINSTATE_APPROVAL.
format(proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(current=a.lodgement_number))
except Exception as e:
err_msg = 'Error suspending Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
if a.cancellation_date and a.set_to_cancel:
if a.cancellation_date <= today:
try:
a.status = Approval.STATUS_CANCELLED
a.set_to_cancel = False
a.save()
# Change apiary site status too
a.change_apiary_site_status(a.status)
send_approval_cancel_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_CANCEL_APPROVAL.format(
a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_CANCEL_APPROVAL.format(
proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(cancelled=a.lodgement_number))
except Exception as e:
err_msg = 'Error cancelling Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
if a.surrender_details and a.set_to_surrender:
surrender_date = datetime.datetime.strptime(
a.surrender_details['surrender_date'], '%d/%m/%Y')
surrender_date = surrender_date.date()
if surrender_date <= today:
try:
a.status = Approval.STATUS_SURRENDERED
a.set_to_surrender = False
a.save()
# Change apiary site status too
a.change_apiary_site_status(a.status)
send_approval_surrender_email_notification(a)
proposal = a.current_proposal
ApprovalUserAction.log_action(
a,
ApprovalUserAction.ACTION_SURRENDER_APPROVAL.
format(a.id), user)
ProposalUserAction.log_action(
proposal,
ProposalUserAction.ACTION_SURRENDER_APPROVAL.
format(proposal.lodgement_number), user)
logger.info('Updated Approval {} status to {}'.format(
a.id, a.status))
updates.append(dict(surrendered=a.lodgement_number))
except Exception as e:
err_msg = 'Error surrendering Approval {} status'.format(
a.lodgement_number)
logger.error('{}\n{}'.format(err_msg, str(e)))
errors.append(err_msg)
cmd_name = __name__.split('.')[-1].replace('_', ' ').upper()
err_str = '<strong style="color: red;">Errors: {}</strong>'.format(
len(errors)
) if len(
errors) > 0 else '<strong style="color: green;">Errors: 0</strong>'
msg = '<p>{} completed. {}. IDs updated: {}.</p>'.format(
cmd_name, err_str, updates)
logger.info(msg)
print(
msg) # will redirect to cron_tasks.log file, by the parent script