示例#1
0
    def makeHL7Docs(self,mode):
        self.session = self.db.Session()    # This starts a Transaction
        if settings.DEBUG:
            print '==== Self:', self
        # Database traversal:
        # Step through Exports. For each Export,
        # Step through Persons. For each person,
        # Step through ServiceEvent. For each Service Event, begin a new document, then
        # Step through Entrys
        # Step through ServiceEventNotes - and all note_text
        
        exports = list() # Added by FBY on (11-06-2013): 
        
        if self.export_id != None:
            #exports = self.session.query(dbobjects.Export).filter(dbobjects.Export.export_id == self.export_id)
            # Added by FBY on (11-06-2013): queries of the export table must take into
            # account the source id nobebuilder operates with which is stored in self.options.configID
            export_table_join = self.session.query(dbobjects.Export, dbobjects.SourceExportLink, dbobjects.Source). \
                    filter(dbobjects.Export.id == dbobjects.SourceExportLink.export_index_id). \
                    filter(dbobjects.SourceExportLink.source_index_id == dbobjects.Source.id). \
                    filter(dbobjects.Source.source_id == self.options.configID). \
                    filter(dbobjects.Export.export_id == self.export_id)
            # Added by FBY on (11-06-2013): from the join, extract only the export classes
            for row in export_table_join:
                exports.append(row.Export)
        else:
            #exports = self.session.query(dbobjects.Export)
            # Added by FBY on (11-06-2013): queries of the export table must take into
            # account the source id nobebuilder operates with which is stored in self.options.configID
            export_table_join = self.session.query(dbobjects.Export, dbobjects.SourceExportLink, dbobjects.Source). \
                    filter(dbobjects.Export.id == dbobjects.SourceExportLink.export_index_id). \
                    filter(dbobjects.SourceExportLink.source_index_id == dbobjects.Source.id). \
                    filter(dbobjects.Source.source_id == self.options.configID)
            # Added by FBY on (11-06-2013): from the join, extract only the export classes
            for row in export_table_join:
                exports.append(row.Export)

        hl7_output = []
        for oneExport in exports:
            selink = self.session.query(dbobjects.SourceExportLink).filter(
                                        dbobjects.SourceExportLink.export_index_id == oneExport.id).one()
            #print '==== Selink.id:', selink.id
            oneSource = self.session.query(dbobjects.Source).filter(dbobjects.Source.id == selink.source_index_id).one()
            #print '==== Source.id:', source.id
            #self.configRec = self.session.query(dbobjects.SystemConfiguration).filter(and_(dbobjects.SystemConfiguration.source_id
            #                     == source.source_id, dbobjects.SystemConfiguration.processing_mode == settings.MODE)).one()
            #print '==== sys config.id', self.configRec.id
            Persons = self.session.query(dbobjects.Person).filter(dbobjects.Person.export_index_id == oneExport.id)
            # More filtering for options
            if self.options.reported == True:
                Persons = Persons.filter(dbobjects.Person.reported == True).with_lockmode('update')
            elif self.options.unreported == True:
                Persons = Persons.filter(or_(dbobjects.Person.reported == False, dbobjects.Person.reported == None)).with_lockmode('update')
            elif self.options.reported == None:
                pass
            # Now apply the dates to the result set.
            if self.options.alldates == None:
                #Persons = Persons.filter(between(dbobjects.Person.person_id_date_collected,
                #                             self.options.startDate, self.options.endDate)).with_lockmode('update')
                Persons = Persons.filter(between(dbobjects.Export.export_date,
                                             self.options.startDate, self.options.endDate)).with_lockmode('update')
            for onePerson in Persons:
                # Get the person's latest received phone number from PersonHistorical
                personHistoricals = self.session.query(dbobjects.PersonHistorical).filter(dbobjects.PersonHistorical.person_index_id == onePerson.id)
                #Get the most recent not null (unreported already filtered) phone number (that came in from the referral)
                onePersonHistorical = None
                for onePersonHistorical in personHistoricals:
                    if onePersonHistorical.person_phone_number:
                        self.phone_number = onePersonHistorical.person_phone_number
                    # FBY New 2016-08-16 : Also check call table for phone number and if present, use it instead.
                    calls = self.session.query(dbobjects.Call).filter(dbobjects.Call.id == onePersonHistorical.call_index_id)
                    for oneCall in calls:
                        if oneCall.caller_home_phone:
                            self.phone_number = oneCall.caller_home_phone
                ServEvts = self.session.query(dbobjects.ServiceEvent).filter(dbobjects.ServiceEvent.person_index_id == onePerson.id)
                for oneServEvt in ServEvts: # One document per event???
                    #print "person is: ", self.person
                    self.processXML(oneExport, onePerson, onePersonHistorical, oneServEvt, oneSource)       # Create one document
                    xmlutilities.indent(self.root_element)  #self.prettify()
                    # Next wraps self.root_element in an ElementTree and writes it to disk
                    if mode=="disk":
                        xmlutilities.writeOutXML(self, xml_declaration=True, encoding="UTF-8")	# JCS - enc. defaults to ASCII w/decl.
                    else:
                        # here return the ccd document along with it's referral ID
                        hl7_output.append((xmlutilities.printOutXML(self, encoding="UTF-8", method="xml"), self.referredToProviderID))
                # Since no errors occurred to this point, mark the Person record as being reported
                self.updateReported(onePerson)
                self.session.commit()       # This is only for updateReported()

        if mode=="disk":
            return True     # Now nodebuilder.run() will find all output files and validate them.
        else:
            return hl7_output
示例#2
0
 def prettify(self):
     xmlutilities.indent(self.root_element)