def generate_restore_payload(user, restore_id): try: last_sync = None if restore_id: try: last_sync = SyncLog.get(restore_id) except Exception: logging.error("Request for bad sync log %s by %s, ignoring..." % (restore_id, user)) username = user.username chw_id = user.get_profile().chw_id if not chw_id: raise Exception("No linked chw found for %s" % username) chw = CommunityHealthWorker.get(chw_id) last_seq = get_db().info()["update_seq"] cases_to_send = get_open_cases_to_send(chw.current_clinic_id, chw.current_clinic_zone, last_sync) case_xml_blocks = [xml.get_case_xml(case, create) for case, create in cases_to_send] # save the case blocks for case, _ in cases_to_send: case.save() saved_case_ids = [case.case_id for case, _ in cases_to_send] # create a sync log for this last_sync_id = last_sync.get_id if last_sync is not None else None # change 5/28/2011, always sync reg xml to phone reg_xml = xml.get_registration_xml(chw) synclog = SyncLog(chw_id=chw_id, last_seq=last_seq, clinic_id=chw.current_clinic_id, date=datetime.utcnow(), previous_log_id=last_sync_id, cases=saved_case_ids) synclog.save() yield xml.RESTOREDATA_TEMPLATE % {"registration": reg_xml, "restore_id": synclog.get_id, "case_list": "".join(case_xml_blocks)} except Exception, e: logging.exception("problem restoring: %s" % user.username) raise
def logs(request): # TODO: pagination, etc. logs = get_db().view("phone/sync_logs_by_chw", group=True, group_level=1).all() for log in logs: [chw_id] = log["key"] try: chw = CommunityHealthWorker.get(chw_id) except ResourceNotFound: chw = None log["chw"] = chw # get last sync: log["last_sync"] = SyncLog.last_for_chw(chw_id) return render_to_response(request, "phone/sync_logs.html", {"sync_data": logs})
def handle(self, *args, **options): if len(args) != 0: raise CommandError('Usage: manage.py add_clinic_ids_to_sync_logs') for sl in SyncLog.view("phone/sync_logs_by_chw", reduce=False, include_docs=True): try: chw = CommunityHealthWorker.get(sl.chw_id) except ResourceNotFound: chw = None if not chw: print "failed to update %s" % sl continue sl.clinic_id = chw.current_clinic_id sl.save()
def restore_caseless(request): restore_id_from_request = lambda req: req.GET.get("since") restore_id = restore_id_from_request(request) last_sync = None if restore_id: try: last_sync = SyncLog.get(restore_id) except Exception: logging.error("Request for bad sync log %s by %s, ignoring..." % (restore_id, request.user)) username = request.user.username chw_id = request.user.get_profile().chw_id if not chw_id: raise Exception("No linked chw found for %s" % username) chw = CommunityHealthWorker.get(chw_id) last_seq = 0 # hackity hack # create a sync log for this if last_sync == None: reg_xml = xml.get_registration_xml(chw) synclog = SyncLog(chw_id=chw_id, last_seq=last_seq, clinic_id=chw.current_clinic_id, date=datetime.utcnow(), previous_log_id=None, cases=[]) synclog.save() else: reg_xml = "" # don't sync registration after initial sync synclog = SyncLog(chw_id=chw_id, last_seq=last_seq, date=datetime.utcnow(), clinic_id=chw.current_clinic_id, previous_log_id=last_sync.get_id, cases=[]) synclog.save() to_return = xml.RESTOREDATA_TEMPLATE % {"registration": reg_xml, "restore_id": synclog.get_id, "case_list": ""} return HttpResponse(to_return, mimetype="text/xml")
def sync_logs_for_chw(chw_id): logs = SyncLog.view("phone/sync_logs_by_chw", reduce=False, startkey=[chw_id], endkey=[chw_id, {}], include_docs=True) return render_to_string("phone/partials/sync_log_for_chw_table.html", {"sync_data": logs})
def chw_dashboard_summary(clinic_dict): def _status_from_last_sync(last_sync): diff = datetime.utcnow() - last_sync.date if last_sync else None if not diff or diff > timedelta(days=5): return "bad" elif diff > timedelta(days=3): return "warn" else: return "good" def _fmt_hh_visits(num_visits, chw): ret = {} ret["count"] = num_visits zone = chw.get_zone() # > 100% of quota for the month in 30 days: green # 50 - 100% of quota for the month in 30 days: yellow # < 50% of quota for the month in 30 days: red # the quota is # of hh's in the zone / 3 if zone: ret["households"] = zone.households ret["percent"] = float(100) * float(num_visits) / float(zone.households) if num_visits > zone.households / 3: ret["status"] = "good" elif num_visits > zone.households / (2 * 3): ret["status"] = "warn" else: ret["status"] = "bad" else: ret["percent"] = "?" ret["households"] = "?" ret["status"] = "unknown" return ret def _status_from_ref_visits(ref_visits): if ref_visits > 2: return "good" elif ref_visits > 0: return "warn" else: return "bad" def _status_from_overdue_fus(fus): if fus > 2: return "bad" elif fus > 0: return "warn" else: return "good" chws = filter(lambda chw: chw.user and chw.user.is_active, CommunityHealthWorker.view("chw/by_clinic", key=clinic_dict["id"], include_docs=True).all()) if chws: clinic_dict["active"] = True clinic_dict["chws"] = [] for chw in chws: chw_dict = { "id": chw.get_id, "name": chw.formatted_name, "zone": chw.current_clinic_zone } # Metrics per CHW: # - date/time of last sync last_sync = SyncLog.view("phone/sync_logs_by_chw", reduce=False, startkey=[chw.get_id, {}], endkey=[chw.get_id], include_docs=True, limit=1, descending=True).one() chw_dict["last_sync"] = fmt_time(last_sync.date) if last_sync else None chw_dict["last_sync_status"] = _status_from_last_sync(last_sync) end = datetime.today() + timedelta(days=1) start = end - timedelta(days=30) # - current outstanding follow ups # Any follow up assigned to the CHW's clinic/zone that is past due # and not closed. This is different from the PI in that it won't # check whether or not the CHW has had that case sync down to their # phone or not. # This is much faster to calculate than anything else. res = get_db().view("centralreports/cases_due", startkey=[chw.current_clinic_id, chw.current_clinic_zone, 0], endkey=[chw.current_clinic_id, chw.current_clinic_zone, end.year, end.month - 1, end.day], reduce=True).one() chw_dict["overdue_fus"] = res["value"] if res else 0 chw_dict["overdue_fus_status"] = _status_from_overdue_fus(chw_dict["overdue_fus"]) # - visits performed chw_dict["hh_visits"] = _fmt_hh_visits(forms_submitted\ (chw.get_id, config.CHW_HOUSEHOLD_SURVEY_NAMESPACE, start, end), chw) # - referrals made chw_dict["ref_visits"] = forms_submitted\ (chw.get_id, config.CHW_REFERRAL_NAMESPACE, start, end) chw_dict["ref_visits_status"] = _status_from_ref_visits(chw_dict["ref_visits"]) clinic_dict["chws"].append(chw_dict) # sort clinic_dict["chws"].sort(key=lambda k: k['zone']) return clinic_dict