​



    /**********
    This script is to set the boolean DM2
    It should check to see if the patient has a diagnostico DM2 and if not null put DM2 to be true. I didn't do just those with an hour preference because we should have all of them.
    ********/

    import org.openmrs.api.context.Context
    import org.openmrs.api.EncounterService;
    import org.openmrs.module.groovy.GroovyUtil
    import org.openmrs.Encounter;
    import org.openmrs.EncounterType;
    import org.openmrs.Person;
    import org.openmrs.Obs;
    import org.openmrs.Concept;
    import org.hibernate.SessionFactory;
    import org.openmrs.api.FormService;
    import org.openmrs.api.ObsService;

    //import groovy.sql.Sql;
    sf = Context.serviceContext.applicationContext.getBean(SessionFactory.class)

    // Easy SQL calls
    def sql(s) { admin.executeSQL(s,false) }

    EncounterService es = Context.getEncounterService()
    FormService fs = Context.getFormService()
    ObsService os = Context.getObsService()

    def c = new Concept(1272)  //diagnostico DM2
    def trueCon = new Concept(1)  //diagnostico DM2


    //get patient_id and encounter_id for patients with diagnostico not null and DM2 null
    rs = sql("""
    select distinct(e.patient_id), e.encounter_id from encounter e, obs diag, obs dm2
    where  e.voided = 0
    and diag.person_id = e.patient_id and diag.concept_id = 1272 and diag.voided = 0 limit 5
    """)

    rs.each { row ->
        (pid,enc_id) = row
        person = new Person(pid)
        def today = Calendar.instance.getTime()
     //    def e = new Encounter(enc_id)
         def obs1 = new Obs()
        obs1.setPerson(person);
         obs1.setConcept(c);
obs1.setObsDatetime(today);
    //     obs1.setEncounter(e);
    //     obs1.setValueCoded(trueCon);
           obs1.setValueText("test");
        os.saveObs(obs1,null);
         print obs1
    }

​