=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/patient/Patient.java' --- dhis-2/dhis-api/src/main/java/org/hisp/dhis/patient/Patient.java 2012-07-10 14:05:24 +0000 +++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/patient/Patient.java 2012-07-13 02:46:02 +0000 @@ -64,6 +64,7 @@ public static String PREFIX_PATIENT_ATTRIBUTE = "attr"; public static String PREFIX_PROGRAM = "prg"; public static String FIXED_ATTR_BIRTH_DATE = "birthDate"; + public static String FIXED_ATTR_AGE = "age"; private Integer id; === modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java 2012-07-10 14:05:24 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java 2012-07-13 02:46:02 +0000 @@ -325,6 +325,10 @@ { patientWhere += " p." + id + value; } + else if ( id.equals( Patient.FIXED_ATTR_AGE ) ) + { + patientWhere += " ((DATE(now()) - DATE(birthdate))/365) " + value; + } else { patientWhere += " lower(p." + id + ")='" + value + "'"; @@ -375,7 +379,7 @@ { sql += statementBuilder.limitRecord( min, max ); } - +System.out.println("\n\n === \n SQL : " + sql ); return sql; } === modified file 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/dataEntryForm.vm' --- dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/dataEntryForm.vm 2012-07-12 10:23:25 +0000 +++ dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/dataEntryForm.vm 2012-07-13 02:46:02 +0000 @@ -68,7 +68,7 @@ #set( $hasOptionSet = 'false') #end #if( $programStageDataElement.dataElement.textType == "longText" ) - + #elseif( $programStageDataElement.dataElement.type == "bool" ) '; - dateField += ''; - return dateField; -} - function getTrueFalseBox() { var trueFalseBox = ''; + ageField += ''; + return ageField; +} + //----------------------------------------------------------------------------- // Search Patient //----------------------------------------------------------------------------- === modified file 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/searchPatientCriteria.vm' --- dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/searchPatientCriteria.vm 2012-07-06 09:59:36 +0000 +++ dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/searchPatientCriteria.vm 2012-07-13 02:46:02 +0000 @@ -34,8 +34,8 @@ + - #foreach( $attribute in $patientAttributes )