def import_all(src_folder):
author = get_autobot()
success_dir = 'success'
error_dir = 'error'
if not os.path.exists(success_dir):
os.makedirs(success_dir)
if not os.path.exists(error_dir):
os.makedirs(error_dir)
for fname in os.listdir(src_folder):
if not fname.endswith('.xls'):
print('skipping %s' % fname)
continue
submit_excel_file(os.path.join(src_folder, fname),
author, success_dir, error_dir)
def import_all(src_folder):
author = get_autobot()
success_dir = 'success'
error_dir = 'error'
if not os.path.exists(success_dir):
os.makedirs(success_dir)
if not os.path.exists(error_dir):
os.makedirs(error_dir)
for fname in os.listdir(src_folder):
if not fname.endswith('.xls'):
print('skipping %s' % fname)
continue
submit_excel_file(os.path.join(src_folder, fname), author, success_dir,
error_dir)
def action(self):
""" send SMS to district/region | email to PNLP for each new report """
for report in MalariaReport.unvalidated\
.filter(period=self.args.period):
# entity has no parent. Either Mali or error
if not report.entity.parent:
# should never happen but we never know
# drop if entity has no parent.
if not report.entity.level == 0:
return
# we now have a national report
logger.info(u"Report %s found." % report)
report._status = MalariaReport.STATUS_VALIDATED
with reversion.create_revision():
report.save()
reversion.set_user(get_autobot().user)
#report.save()
# send emails
ct, oi = Access.target_data(Entity.objects.get(slug='mali'))
nat_access = list(Access.objects.filter(content_type=ct, \
object_id=oi))
providers = list(Provider.active\
.select_related()\
.filter(user__email__isnull=False, \
access__in=nat_access)\
.values_list('user__email', flat=True))
rurl = full_url(path=reverse('raw_data', \
kwargs={'entity_code': report.entity.slug, \
'period_str': report.period.middle().strftime('%m%Y')}))
sent, sent_message = send_email(recipients=providers, \
context={'report': report, \
'report_url': rurl, \
'url': full_url()},
template='emails/mali_report_available.txt', \
title_template='emails/title.mali_report_available.txt')
# the rest of the method is only for non-national
return
# we only send notifications for CSCom & District reports.
if report.entity.type.slug not in ('cscom', 'district'):
continue
# we don't bug district if cscom period is over
if report.entity.type.slug == 'cscom' \
and time_cscom_over(period=self.args.period):
continue
# we don't bug region if district period is over
if report.entity.type.slug == 'district' \
and time_district_over(period=self.args.period):
continue
# create a dedicated alert so it can be tracked by report
# then fire it.
alert = IndividualMalariaReportCreated.create(report=report)
if alert.can_trigger():
alert.trigger()
def action(self):
""" Validate remaining reports and inform region """
# retrieve autobot provider if possible
try:
author = Provider.active.get(user__username='******')
except:
author = None
if self.args.is_district:
validate_level = 'cscom'
aggregate_level = 'district'
else:
validate_level = 'district'
aggregate_level = 'region'
# validate non-validated reports
for report in MalariaReport.unvalidated\
.filter(period=self.args.period, \
entity__type__slug=validate_level):
report._status = MalariaReport.STATUS_VALIDATED
if author:
report.modified_by = author
report.modified_on = datetime.now()
with reversion.create_revision():
report.save()
if author:
reversion.set_user(author.user)
else:
reversion.set_user(get_autobot().user)
#report.save()
# create aggregated reports
for entity in Entity.objects.filter(type__slug=aggregate_level):
if entity.pnlp_core_malariareport_reports\
.filter(period=self.args.period).count() > 0:
continue
rauthor = contact_for(entity) if not author else author
logger.info(u"Creating Aggregated report for %s" % entity)
report = MalariaReport.create_aggregated(self.args.period, \
entity, rauthor)
# region auto-validates their reports
if not self.args.is_district:
report._status = MalariaReport.STATUS_VALIDATED
#report.save()
with reversion.create_revision():
report.save()
reversion.set_user(rauthor.user)
# region-only section
# create national report
mali = Entity.objects.get(slug='mali')
if not self.args.is_district \
and mali.pnlp_core_malariareport_reports\
.filter(period=self.args.period).count() == 0:
rauthor = author if author else get_autobot()
logger.info(u"Creating National report")
report = MalariaReport.create_aggregated(self.args.period, \
mali, rauthor)
# following only applies to districts (warn regions).
return
# district-only section
# let region know there are reports to validate
for region in Entity.objects.filter(type__slug='region'):
contact = contact_for(region, recursive=False)
# skip if not recipient
if not contact or not contact.phone_number:
continue
nb_reports = MalariaReport.unvalidated\
.filter(period=self.args.period, \
entity__type__slug='district', \
entity__parent=region).count()
message = u"[PNLP] La periode de validation CSRef est " \
u"terminee. Vous avez %(nb)d rapports de " \
u"CSRef a valider." % {'nb': nb_reports}
email_title = u"[PNLP] Fin de la periode de validation CSRef"
if not contact.email:
continue
send_email(contact.email, message=message, title=email_title)