dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #42166
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 21534: TEI query, including organisation unit name in response
------------------------------------------------------------
revno: 21534
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2015-12-28 14:08:12 +0100
message:
TEI query, including organisation unit name in response
modified:
dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java
dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java
dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java 2015-12-23 12:56:31 +0000
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java 2015-12-28 13:08:12 +0000
@@ -55,6 +55,7 @@
public static final String CREATED_ID = "created";
public static final String LAST_UPDATED_ID = "lastupdated";
public static final String ORG_UNIT_ID = "ou";
+ public static final String ORG_UNIT_NAME = "ouname";
public static final String TRACKED_ENTITY_ID = "te";
public static final String TRACKED_ENTITY_ATTRIBUTE_ID = "teattribute";
public static final String TRACKED_ENTITY_ATTRIBUTE_VALUE_ID = "tevalue";
=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java'
--- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java 2015-12-23 12:56:31 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java 2015-12-28 13:08:12 +0000
@@ -176,7 +176,8 @@
grid.addHeader( new GridHeader( TRACKED_ENTITY_INSTANCE_ID, "Instance" ) );
grid.addHeader( new GridHeader( CREATED_ID, "Created" ) );
grid.addHeader( new GridHeader( LAST_UPDATED_ID, "Last updated" ) );
- grid.addHeader( new GridHeader( ORG_UNIT_ID, "Org unit" ) );
+ grid.addHeader( new GridHeader( ORG_UNIT_ID, "Organisation unit" ) );
+ grid.addHeader( new GridHeader( ORG_UNIT_NAME, "Organisation unit name" ) );
grid.addHeader( new GridHeader( TRACKED_ENTITY_ID, "Tracked entity" ) );
grid.addHeader( new GridHeader( INACTIVE_ID, "Inactive" ) );
@@ -200,6 +201,7 @@
grid.addValue( entity.get( CREATED_ID ) );
grid.addValue( entity.get( LAST_UPDATED_ID ) );
grid.addValue( entity.get( ORG_UNIT_ID ) );
+ grid.addValue( entity.get( ORG_UNIT_NAME ) );
grid.addValue( entity.get( TRACKED_ENTITY_ID ) );
grid.addValue( entity.get( INACTIVE_ID ) );
=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java'
--- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-12-23 12:56:31 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-12-28 13:08:12 +0000
@@ -219,9 +219,14 @@
// Select clause
// ---------------------------------------------------------------------
- String sql = "select tei.uid as " + TRACKED_ENTITY_INSTANCE_ID + ", " + "tei.created as " + CREATED_ID + ", "
- + "tei.lastupdated as " + LAST_UPDATED_ID + ", " + "ou.uid as " + ORG_UNIT_ID + ", " + "te.uid as "
- + TRACKED_ENTITY_ID + ", " + "tei.inactive as " + INACTIVE_ID + ", ";
+ String sql =
+ "select tei.uid as " + TRACKED_ENTITY_INSTANCE_ID + ", " +
+ "tei.created as " + CREATED_ID + ", " +
+ "tei.lastupdated as " + LAST_UPDATED_ID + ", " +
+ "ou.uid as " + ORG_UNIT_ID + ", " +
+ "ou.name as " + ORG_UNIT_NAME + ", " +
+ "te.uid as " + TRACKED_ENTITY_ID + ", " +
+ "tei.inactive as " + INACTIVE_ID + ", ";
for ( QueryItem item : params.getAttributes() )
{
@@ -265,6 +270,7 @@
map.put( CREATED_ID, rowSet.getString( CREATED_ID ) );
map.put( LAST_UPDATED_ID, rowSet.getString( LAST_UPDATED_ID ) );
map.put( ORG_UNIT_ID, rowSet.getString( ORG_UNIT_ID ) );
+ map.put( ORG_UNIT_NAME, rowSet.getString( ORG_UNIT_NAME ) );
map.put( TRACKED_ENTITY_ID, rowSet.getString( TRACKED_ENTITY_ID ) );
map.put( INACTIVE_ID, rowSet.getString( INACTIVE_ID ) );